$headings1
";
$printAppEx="| No Records Located |
";
//////
if($sbadG==10){
$file_E_id2=$_POST['file_E_id'];
$sq112azE9= "UPDATE $table_name36001 SET status='0' WHERE information ='$file_E_id2' ";
////$sq112azE9="DELETE FROM $table_name806A WHERE information ='$file_E_id2'";
$result3319 = @mysql_query($sq112azE9,$connection) or die(mysql_error());
$mess=" Deleted File $file_E_id2 has been deleted.
";
}
if($sbadG==11){
$file_E_id2=$_POST['file_E_id'];
$sq112azE9= "UPDATE $table_name80 SET van1='99' WHERE map_id ='$file_E_id2' ";
////$sq112azE9="DELETE FROM $table_name806A WHERE information ='$file_E_id2'";
$result3319 = @mysql_query($sq112azE9,$connection) or die(mysql_error());
$mess=" Deleted Record $file_E_id2 has been deleted.
";
}
if($sbadG==12){
$file_E_id2=$_POST['file_E_id'];
$wterm=$_POST['mywar'];
$sq112azE9= "UPDATE $table_name80 SET van50='$wterm' WHERE map_id ='$file_E_id2' ";
////$sq112azE9="DELETE FROM $table_name806A WHERE information ='$file_E_id2'";
$result3319 = @mysql_query($sq112azE9,$connection) or die(mysql_error());
$mess=" Record $file_E_id2 has been updated.
";
}
$cust_id="$text_account3";
$sq112a="SELECT * FROM $table_name80 WHERE van1 !='99' AND van56 <'3' AND survey_id = '$port_idz' AND agent_id='$text_account3' Order by create_date DESC ";
if($Tgrade==109){
$sq112a="SELECT * FROM $table_name80 WHERE van1 !='99' AND van56 >'1' AND survey_id = '$port_idz' AND agent_id='$text_account3' Order by create_date DESC $newlimit ";
}
$popmes='';
if($Wgrade==209){
$newlimit=""; ///AND van56 >'1'
$sq112a="SELECT * FROM $table_name80 WHERE van1 !='99' AND survey_id = '$port_idz' Order by create_date DESC $newlimit ";
if ($days>0){
$tomorr= date("Y-m-d H:i:s",strtotime("tomorrow"));
$yester= date("Y-m-d H:i:s",strtotime("yesterday"));
$yester1= date("Y-m-d H:i:s",strtotime("yesterday -1 day"));
$yester1= date("Y-m-d H:i:s",strtotime("today -$days day"));
$yester1V= date("Y-m-d",strtotime("today -$days day"));
$tomorr2= date("Y-m-d",strtotime("today"));
$yester1D= date("Y-m-d H:i:s",strtotime("yesterday 11:59 PM"));
$yester14= date("Y-m-d H:i:s",strtotime("yesterday -14 days 11:59 PM"));
$sq112a="SELECT * FROM $table_name80 WHERE van1 !='99' AND survey_id = '$port_idz' AND create_date > '$yester1' Order by create_date DESC $newlimit ";
$popmes ="Showing Forms Completed from $yester1V through $tomorr2";
}
}
//echo $sq112a;
$result112a = @mysql_query($sq112a,$connection) or die(mysql_error());
$Thenum = mysql_num_rows($result112a);
if ($Thenum>0) {
$printAppEx='';
}
while ($row1 = mysql_fetch_array($result112a)) {
$map_id= $row1['map_id'];
$regdateZ= $row1['create_date'];
include('survey-row1-variables.php');
$brand= $row1['van5'];
$descriptA= $row1['van20'];
$first1= $row1['firstname'];
$last1= $row1['lastname'];
$email1= strtolower($row1['email']);
///$barnT='';
if ($prodcap>0){
$yester1Vd= date("Y-m-d",strtotime("$regdateZ 20 day"));
$yester1Vdz= date("Y-m-d",strtotime("$regdateZ -20 day"));
$sq112aZ="SELECT * FROM $db_name.$table_name41 WHERE LOWER(email) = '$email1' AND date_added >='$yester1Vdz' AND date_added <'$yester1Vd' ";
///echo $sq112aZ;
$result112aZ = @mysql_query($sq112aZ,$connection) or die(mysql_error());
while ($row1Z = mysql_fetch_array($result112aZ)) {
$order_id= $row1Z['order_id'];
$orgdateZ= $row1Z['date_added'];
///$tomorr2= date("Y-m-d",strtotime("today"));
$prod_id='';
$prod_idN='';
$prod_idM='';
$sq112aZa="SELECT * FROM $table_name47 WHERE order_id = '$order_id' ";
///echo $sq112aZa;
$result112aZa = @mysql_query($sq112aZa,$connection) or die(mysql_error());
while ($row1Za = mysql_fetch_array($result112aZa)) {
$prod_id2= $row1Za['product_id'];
$prod_idN2= $row1Za['name'];
/// echo $prod_idN2;
$prod_idM2= $row1Za['model'];
$sql33a8001 ="SELECT * FROM event_manager WHERE product_id>'0' AND product_id='$prod_id2' ";
$result33A1 = @mysql_query($sql33a8001,$connection) or die(mysql_error());
$row22rAb1rt =mysql_fetch_array($result33A1,MYSQL_ASSOC);
$event_id=$row22rAb1rt['event_id'];
if ($event_id>0){
$sql33a8001 ="SELECT * FROM event_manager_class WHERE event_id>'0' AND event_id=' $event_id' ";
$result33A1 = @mysql_query($sql33a8001,$connection) or die(mysql_error());
$row22rAb1rt =mysql_fetch_array($result33A1,MYSQL_ASSOC);
$date_id=$row22rAb1rt['class_date'];
$date_idM= date("m-d-Y",strtotime($date_id));
$startT= $row22rAb1rt['start_time'];
$startTM=date("h:i:sa",strtotime($startT));
$prod_idM2="$date_idM - $startTM";
$date_idM='';
$startTM='';
}
$sq112aZaZ="SELECT * FROM $table_name54A WHERE product_id = '$prod_id2' AND category_id='$prodcap' ";
$result112aZaZ = @mysql_query($sq112aZaZ,$connection) or die(mysql_error());
while ($row1ZaZ = mysql_fetch_array($result112aZaZ)) {
$prod_id=$prod_id2;
$prod_idN=$prod_idN2;
$prod_idM=$prod_idM2;
$barnT ="$prod_idM | $prod_idN | ";
//echo "$barnT hi";
}///while
}////while
}///while
}
$wphone= $row1['van3'];
$answerT[99]="$first1 $last1
$wphone";
$descript= $row1['van22'];
$dserial= $row1['van23'];
$warterm1= $row1['van24'];
$warterm1a=$warterm1;
///$wphone= $row1['van3'];
$wevent= $row1['van4'];
$wdate= $row1['van5'];
$wtime= $row1['van6'];
$wid= $row1['van7'];
$prog979="admin/GoTool/survey_Edit_old/survey_show.php";
$seeme="
";
$barnT ="$wevent | $wdate | $wtime | $wid | ";
$partTerm="";
//echo "Hello
$descript";
$del99P="
";
///////
//////
////
////////
$printX="power/pdf3/documents/printPart.php";
$printChart99="
";
////////
$bad1a="$loc2/$CAPMIT/MITstart.php?token=$tok&log=$text_account3&Preg=$map_id";
$startClaim='';
if($Tgrade==99){
//everything shows
}
if($Tgrade==98){
$seeme='';
$seeme22='';
$del99P='';
}
if($Tgrade==100){
$seeme='';
//$seeme22='';
$del99P='';
}
if($Tgrade==101){
$seeme='';
//$seeme22='';
//$del99P='';
}
if($Tgrade==102){
//$seeme='';
$seeme22='';
$del99P='';
}
if($Tgrade==103){
//$seeme='';
$seeme22='';
//$del99P='';
}
if($Tgrade==109){
$seeme='';
$seeme22='';
$del99P='';
}
//$Pgrade2=explode(",", $Pgrade);
// $Pgrade3=count($Pgrade2);
// $nPt=($Pgrade3-1);
$printAppEx .="$map_id
App Administration
$seeme $del99P
$printChart99
$startClaim
| $regdateZ | ";
for ($ptt=0;$ptt<=$nPt; $ptt++){
$bob99=$Pgrade2[$ptt];
$printAppEx .="$answerT[$bob99] | $email1 | $barnT";
$boom2 .="
| $map_id | $regdateZ | $answerT[$bob99] | $email1 | $barnT
";
}
$printAppEx .="";
//$Pgrade44=$Pgrade3 +1;
//if ($Pgrade44<$grade3) {
//$bob99=$Pgrade2[$nPt];
//$printAppEx .="
//
//
// $answerT[$bob99]
//
// |
// ";
// }
$partTerm='';
$jade_doc1='';
/////
}///while $squ112a
$printAppEx.='