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.
";
}
$display_block18888='';
if ($jade1a == $port_idz) {
if (isset($_POST['gbad24a'])) {
$gbad24a=$_POST['gbad24a'];
}
if (isset($_POST['form_id'])) {
$form_id=$_POST['form_id'];
}
if (isset($_POST['type_id'])) {
$type_id=$_POST['type_id'];
}
if (isset($_POST['pmap'])) {
$pmap=$_POST['pmap'];
}
if($sbad==1){
// $target_path = "forms_dep/";
$dirFix='survey/';
if($dirFix==$blink){
$target_path = "forms_dep2/";
}else{
$target_path = "../../../survey/forms_dep2/";
}
$babe="$form_id-$text_account3-";
$target_path = $target_path . $babe.basename( $_FILES['uploadedfile']['name']);
if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) {
// echo "The file ". $babe.basename( $_FILES['uploadedfile']['name']).
// " has been uploaded";
} else{
$something1 .= "There was an error uploading the file, please try again!
";
$bat=2;
}
$babe2=$babe.basename( $_FILES['uploadedfile']['name']);
$babe2=addslashes($babe2);
$Rtoday=date("Y-m-d h:i:s");
$today = date("Y-m-d h:i:s");
$date2 = date("F j,Y"); //date ("format",$timestamp)
$date3 = date("m/d/Y");
if ($bat!=2){
$sql2 = "INSERT INTO $table_name36001 (customer_id, type_id, status, date_added, information,map_id )VALUES ('$text_account3','$type_id','1', '$today', '$babe2','$pmap')";
$resultxzew = @mysql_query($sql2,$connection) or die(mysql_error());
$something1 .="File: $babe2 Uploaded
";
}
} //end of sbad attachment saving to database
$jade1a=0;
}
$button99CV1 = "";
$close99C1 = "";
if ($jedID2U == 3) {
$cust_id=$text_account3;///group_id ='$bgroup'
$display_blockRA92='';
$sq112a="SELECT * FROM $table_name80 WHERE van1 !='99' AND survey_id = '$port_idz' AND agent_id='$cust_id' Order by create_date DESC ";
//echo $sq112a;
$result112a = @mysql_query($sq112a,$connection) or die(mysql_error());
$Thenum = mysql_num_rows($result112a);
if ($Thenum>0) {
$printAppEx='';
}
while ($row112a = mysql_fetch_array($result112a)) {
$map_id= $row112a['map_id'];
$regdateZ= $row112a['create_date'];
$brand= $row112a['van5']; //Brand
$Sbrand= $row112a['van9']; //Serial
$TrueProblem= $row112a['van12']; //Problem desc
$mtbrand= $row112a['van4']; //Machine Type
$sql33er ="SELECT * FROM $table_name77 WHERE surveyA_id = '$mtbrand' ";
//echo $sql33;
$result33er = @mysql_query($sql33er,$connection) or die(mysql_error());
$row22er =mysql_fetch_array($result33er,MYSQL_ASSOC);
$mtbrand= $row22er['answer'];
$Sproblem= $row112a['van11']; //Problem
$sql33er ="SELECT * FROM $table_name77 WHERE surveyA_id = '$Sproblem' ";
//echo $sql33;
$result33er = @mysql_query($sql33er,$connection) or die(mysql_error());
$row22er =mysql_fetch_array($result33er,MYSQL_ASSOC);
$Sproblem= $row22er['answer'];
$descriptA= $row112a['van6'];
$descript= $row112a['van5'];
$dserial= $row112a['van8'];
$warterm1= $row112a['van50'];
$warterm1a=$warterm1;
if ($warterm1==121){
$warterm1a=">120";
}
$prog979="GoTool/survey_Edit_old/survey_show.php";
$seeme="";
$prog979a="../WARMIT/surveyDwTwLMITappNew.php";
$seeme22="";
$partTerm="Typical Warranties Range: "; $sq112aWW="SELECT * FROM $table_name3000 WHERE (Names Like '%$brand%' OR Names Like '%$descript%' OR Names Like '%$descriptA%') order by WarrantyMo ASC limit 1"; $result112aWW = @mysql_query($sq112aWW,$connection) or die(mysql_error()); while ($row112aWW = mysql_fetch_array($result112aWW)) { $partNam= $row112aWW['Names']; $partWam= $row112aWW['WarrantyMo']; $partTerm.="$partNam - $partWam Mo(s)
"; } $sq112aWW="SELECT * FROM $table_name3000 WHERE (Names Like '%$brand%' OR Names Like '%$descript$' OR Names Like '%$descriptA%') order by WarrantyMo DESC limit 1"; $result112aWW = @mysql_query($sq112aWW,$connection) or die(mysql_error()); while ($row112aWW = mysql_fetch_array($result112aWW)) { $partNam= $row112aWW['Names']; $partWam= $row112aWW['WarrantyMo']; $partTerm.="$partNam - $partWam Mo(s)
"; } $partTerm.="
What's Yours (Mo): "; //echo "Hello
$descript"; $del99P=""; $jade_doc1a="No documents have been uploaded."; $sql33AA1 ="SELECT DISTINCT information FROM $table_name36001 WHERE status>'0' AND map_id='$map_id' AND customer_id = '$text_account3' AND type_id='102' Order by date_added Desc "; $result33A1 = @mysql_query($sql33AA1,$connection) or die(mysql_error()); while ($row12A = mysql_fetch_array($result33A1)) { $file_E= addslashes($row12A['information']); $sql33r ="SELECT * FROM $table_name36001 WHERE status='1' AND map_id='$map_id' AND customer_id = '$text_account3' AND information='$file_E' limit 1 "; $result33r = @mysql_query($sql33r,$connection) or die(mysql_error()); $row22r =mysql_fetch_array($result33r,MYSQL_ASSOC); $create_date22=$row22r['date_added']; // $diplay_uploads.="$file_E uploaded by user:$user_E on $create_date
"; $del99=""; $dirFix=''; if($dirFix==$blink){ $display_uploads.="$file_E uploaded on $create_date22 $del99
"; }else{ $display_uploads.="$file_E uploaded on $create_date $del99
"; } }//while///$sql33AA1 -102 $jade_doc1 ="$display_uploads"; /////// ////// $sql33AA1 ="SELECT DISTINCT information FROM $table_name36001 WHERE status>0 AND map_id='$map_id' AND customer_id = '$text_account3' AND type_id='103' Order by date_added Desc "; $result33A1 = @mysql_query($sql33AA1,$connection) or die(mysql_error()); while ($row12A = mysql_fetch_array($result33A1)) { $file_E= addslashes($row12A['information']); $sql33r ="SELECT * FROM $table_name36001 WHERE status='1' AND map_id='$map_id' AND customer_id = '$text_account3' AND information='$file_E' limit 1 "; $result33r = @mysql_query($sql33r,$connection) or die(mysql_error()); $row22r =mysql_fetch_array($result33r,MYSQL_ASSOC); $create_date22=$row22r['date_added']; // $diplay_uploads.="$file_E uploaded by user:$user_E on $create_date
"; $del99=""; $dirFix=''; if($dirFix==$blink){ $display_uploads3.="
"; }else{ $display_uploads3.="
"; } }//while //// $jade_doc1 .="$display_uploads3"; $display_uploads=''; $display_uploads3=''; if ($jade_doc1==$blink){ $jade_doc1=$jade_doc1a; } //////// $printX="power/pdf3/documents/printPart.php"; $printChart99=" "; //////// $printAppEx .="
$seeme22
$del99P
$printChart99
$descript
$descript
