//
//
//
//
//
$sq112ab="SELECT * FROM $table_name81 WHERE survey_id = '$survey_idR'";
$result222a = @mysql_query($sq112ab,$connection) or die(mysql_error());
while ($row1ab = mysql_fetch_array($result222a)) {
$survey_id= $row1ab['survey_id'];
$Cname= stripslashes($row1ab['name']);
}
// $sq112abc="SELECT * FROM $table_name300 WHERE survey_id = '$survey_idR' OR survey_id = '0' ";
$sq112abc="SELECT * FROM $table_name300 WHERE dropdown_id = '1' ";
$result222acz = @mysql_query($sq112abc,$connection) or die(mysql_error());
while ($row1abc = mysql_fetch_array($result222acz)) {
$status_id= $row1abc['table_id'];
$name= stripslashes($row1abc['value']);
//$name_exp= stripslashes($row1abc['name_exp']);
$stat_pov[$status_id]=$name;
//$stat_desc[$status_id]=$name_exp;
$stat_list .="";
}
$sq112ab11adddd="SELECT * FROM $table_name82 WHERE map_id = '$map_id' ";
$result2221addd = @mysql_query($sq112ab11adddd,$connection) or die(mysql_error());
while ($row12add = mysql_fetch_array($result2221addd)) {
$firstname= stripslashes($row12add['firstname']);
$lastname= stripslashes($row12add['lastname']);
$lastnamez1=$lastname;
$firstnamez1=$firstname;
}
$goflow="$Assessment1: $Cname";
$jed=3;
$gjed=1;
$bottomRepReset .="Refresh List
";
$bottomReport .=" ";
$bottomCriteria .=" ";
$special_code .="
";
$sbad=$_POST['sbad'];
$look1=$_POST['look1'];
$look1="%$look1%";
$searchR=$_POST['searchR'];
$look2=$_POST['look2'];
$look2="%$look2%";
$delID=$_POST['lookD'];
$look20=$_POST['look1'];
$map_id=$_POST['map_id'];
$sq112aa="SELECT * FROM $table_name81 WHERE survey_id = '$survey_idR' ";
$result222a = @mysql_query($sq112aa,$connection) or die(mysql_error());
while ($row1b = mysql_fetch_array($result222a)) {
$cutoff= stripslashes($row1b['cutoff']);
}
// if ($sbad==0){
$sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR' Order by map_id DESC ";
// }
if ($sbad==20){
$sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR'AND van57 >='$look20' Order by map_id DESC "; //was Ascore
}
if ($sbad==100){
$sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR'AND map_id ='$map_id' ";
if ($babs==100){
if ($survey_idR>21 OR $survey_idR<27){
$sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR'AND test_type ='$map_id' ";
$result2224 = @mysql_query($sq112a,$connection) or die(mysql_error());
while ($row14 = mysql_fetch_array($result2224)) {
$map_id6= $row14['map_id'];
//$map_id=253;
$map_id55= $row14['test_type'];
}
$sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR'AND map_id ='$map_id6' ";
}
}// end babs
} //end sbad
if ($sbad==50){
$look_date=$_POST['lookD'];
$org=$_POST['look44'];
$all="All";
if ($org != $all){
$caution="AND company='$org'";
}
$Btoday = date("Y-m-d");
$day=date("d");
$dayL=$day-1;
$lastmo= strtotime("last month",$Btoday);
$firstmo= date("Y-m-d",strtotime("-$day day last month")); //the end of the month 2 months out
$lastmo= date("Y-m-d",strtotime("-$dayL day this month")); //first of this month
$mo= date("Y-m-d",strtotime("1 day this month")); //first of this month
$moB= date("Y-m-d",strtotime("-90 day this month")); //first of this month
$yester= date("Y-m-d",strtotime("yesterday"));
$tomorr= date("Y-m-d",strtotime("tomorrow"));
$moName= date("Y-m-d",strtotime(" last month"));
$lweek= date("Y-m-d",strtotime(" -7 day"));
$mo30= date("Y-m-d",strtotime("-30 day")); //first of this month
$mo6= date("Y-m-d",strtotime("-6 month this month")); //first of this month
$mo12= date("Y-m-d",strtotime("-12 month this month")); //first of this month
$lastmo2= date("Y-m-d",strtotime("-$dayL day -1 month")); //first of this month
if ($look_date ==1){
//today
$mess ="
Results Found for Assessments taken between: $yester And $tomorr
";
$sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR' AND create_date between '$yester' AND '$tomorr' $caution ";
}
if ($look_date ==2){
//last 7 days
$mess =" Results Found for Assessments taken between: $lweek And $tomorr ";
$sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR' AND create_date between '$lweek' AND '$tomorr' $caution ";
}
if ($look_date ==3){
//last 30 days
$mess ="
Results Found for Assessments taken between: $mo30 And $tomorr
";
$sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR' AND create_date between '$mo30' AND '$tomorr' $caution ";
}
if ($look_date ==4){
//last mo
$mess ="
Results Found for Assessments taken between: $lastmo2 And $lastmo
";
$sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR' AND create_date between '$lastmo2' AND '$lastmo' $caution ";
}
if ($look_date ==5){
//last 90
$mess ="
Results Found for Assessments taken between: $tomorr And $moB
";
$sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR' AND create_date between '$moB' AND '$tomorr' $caution ";
}
if ($look_date ==6){
$mess ="
Results Found for Assessments taken between: $tomorr And $mo6
";
$sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR' AND create_date between '$mo6' AND '$tomorr' $caution ";
}
if ($look_date ==7){
$mess ="
Results Found for Assessments taken between: $tomorr And $mo12
";
$sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR' AND create_date between '$mo12' AND '$tomorr' $caution ";
}
}
if (($sbad==1)AND($look2==$blink)){
$sq112a="SELECT * FROM $table_name80 Where ( (lastname Like '$look1'') OR (firstname Like '$look1')OR (firstname Like '$look1'') OR (firstname Like '$look1')OR (company Like '$look1'') OR (company Like '$look1')OR (van6 Like '$look1') )AND survey_id = '$survey_idR' ";
}
if (($sbad==1)AND ($searchR==1)AND ($look2!=$blink)){
$sq112a="SELECT * FROM $table_name80 Where ( ((lastname Like '$look1')AND (company Like '$look2')) OR ((company Like '$look1')AND (lastname Like '$look2'))OR ((firstname Like '$look1')AND (company Like '$look2'))OR ((company Like '$look1')AND (firstname Like '$look2'))OR ((lastname Like '$look1')AND (van6 Like '$look2'))OR ((van6 Like '$look1')AND (lastname Like '$look2')) OR ((firstname Like '$look1')AND (van6 Like '$look2'))OR ((van6 Like '$look1')AND (firstname Like '$look2'))OR ((lastname Like '$look1')AND (firstname Like '$look2'))OR ((firstname Like '$look1')AND (lastname Like '$look2')) )AND survey_id = '$survey_idR' ";
}
if (($sbad==1)AND ($searchR==2)AND ($look2!=$blink)){
$sq112a="SELECT * FROM $table_name80 Where ( ((company Like '$look1')OR (company Like '$look2')) OR ((lastname Like '$look1')OR (lastname Like '$look2')) OR ((firstname Like '$look1')OR (firstname Like '$look2'))OR ((van6 Like '$look1')OR (van6 Like '$look2')) )AND survey_id = '$survey_idR' ";
}
if ($sbad==10){
if ($delID != 0){
$sq112zzabD="SELECT * FROM $table_name80 WHERE test_type='$delID'";
$result222azzD = @mysql_query($sq112zzabD,$connection) or die(mysql_error());
while ($row1abzzD = mysql_fetch_array($result222azzD)) {
$survey_idzzD= $row1abzzD['survey_id'];
$Smap_idD[$survey_idzzD]= stripslashes($row1abzzD['map_id']);
}
$sq112az="DELETE FROM $table_name80 WHERE map_id ='$Smap_idD[$firstS2]'";
$result331 = @mysql_query($sq112az,$connection) or die(mysql_error());
$sq112az="DELETE FROM $table_name80 WHERE map_id ='$Smap_idD[$firstS3]'";
$result331 = @mysql_query($sq112az,$connection) or die(mysql_error());
$sq112az="DELETE FROM $table_name80 WHERE map_id ='$Smap_idD[$firstS4]'";
$result331 = @mysql_query($sq112az,$connection) or die(mysql_error());
$sq112az="DELETE FROM $table_name80 WHERE map_id ='$Smap_idD[$firstS5]'";
$result331 = @mysql_query($sq112az,$connection) or die(mysql_error());
$sq112az="DELETE FROM $table_name80 WHERE map_id ='$delID'";
$result331 = @mysql_query($sq112az,$connection) or die(mysql_error());
$sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR' Order by map_id DESC ";
$warn= "
Records Deleted
";
}else{
$warn= "
You cannot delete the Base Survey.
";
$sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR' Order by map_id DESC ";
}
}
if ($sbad==414){
$Qstat5=$_POST['Qstat5'];
$map_idQ=$_POST['map_idQ'];
$num33Q=0;
$sq112zzabDe="SELECT * FROM $table_name301 WHERE map_id='$map_idQ'";
$result222azzDe = @mysql_query($sq112zzabDe,$connection) or die(mysql_error());
$num33Q = mysql_num_rows($result222azzDe);
$num33Q1=0;
$sq112zzabDe="SELECT * FROM $table_name301 WHERE map_id='$map_idQ' AND test_stat='1'";
$result222azzDe = @mysql_query($sq112zzabDe,$connection) or die(mysql_error());
$num33Q1 = mysql_num_rows($result222azzDe);
// echo "Qstat=$Qstat5 and Q1- $num33Q1 Q= $num33Q";
// if ($Qstat5 != 0 AND $Qstat5 !=$blink AND $num33Q==0){
if ($Qstat5 != 0 AND $Qstat5 !=$blink ){
If ($num33Q<1) {
$sql2azzDe = "INSERT INTO $table_name301 ( map_id, survey_id, create_date, test_stat) VALUES ('$map_idQ','$survey_idR', '$today', '$Qstat5')";
$result2azzDe = @mysql_query($sql2azzDe,$connection) or die(mysql_error());
$sql2azzDe = "INSERT INTO $table_name302 ( map_id, survey_id, create_date, test_stat) VALUES ('$map_idQ','$survey_idR', '$today', '$Qstat5')";
$result2azzDe = @mysql_query($sql2azzDe,$connection) or die(mysql_error());
$mess="
A Decision Record for Application $map_idQ has been created.
";
} else{
$sql2azzDe = "INSERT INTO $table_name302 ( map_id, survey_id, create_date, test_stat) VALUES ('$map_idQ','$survey_idR', '$today', '$Qstat5')";
$result2azzDe = @mysql_query($sql2azzDe,$connection) or die(mysql_error());
$sql2 = "UPDATE $table_name301 SET map_id='$map_idQ',survey_id='$survey_idR', test_stat='$Qstat5', create_date='$today' WHERE map_id ='$map_idQ' " ; //add support_id
$result2 = @mysql_query($sql2,$connection) or die(mysql_error());
$mess="
Application $map_idQ has been updated.
";
} //end if
}else {
$mess="
No Accept Setting was selected. Check the action pull down menu.
";
}
if ($Qstat5 == 9 AND $Qstat5 !=$blink AND $num33Q>0){
$sql2azzDe = "INSERT INTO $table_name302 ( map_id, survey_id, create_date, test_stat) VALUES ('$map_idQ','$survey_idR', '$today', '$Qstat5')";
$result2azzDe = @mysql_query($sql2azzDe,$connection) or die(mysql_error());
$sql2 = "UPDATE $table_name301 SET map_id='$map_idQ',survey_id='$survey_idR', test_stat='$Qstat5', create_date='$today' WHERE map_id ='$map_idQ' " ; //add support_id
$result2 = @mysql_query($sql2,$connection) or die(mysql_error());
$mess="
Application $map_idQ has been updated.
";
}
$sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR' Order by map_id DESC ";
} //410
$result33 = @mysql_query($sq112a,$connection) or die(mysql_error());
$num33 = mysql_num_rows($result33);
$Cstatus2[1]="Enabled";
$Cstatus2[0]="Disabled";
$result222 = @mysql_query($sq112a,$connection) or die(mysql_error());
while ($row1 = mysql_fetch_array($result222)) {
$survey_id= $row1['survey_id'];
$map_id= $row1['map_id'];
$map_id55= $row1['test_type']; //for the new survey
$firstname= stripslashes($row1['firstname']);
$lastname= stripslashes($row1['lastname']);
$company= stripslashes($row1['company']);
$email= stripslashes($row1['email']);
$van5= stripslashes($row1['van5']);
$country=$van5;
$van6= stripslashes($row1['van6']);
$state=$van6;
$van7= stripslashes($row1['van7']);
$answerT[7]=$van7;
$van8= stripslashes($row1['van8']);
$answerT[8]=$van8;
$Ccreate_dateR= $row1['create_date'];
$Ccreate_dateR=strtotime("$Ccreate_dateR");
$Ccreate_dateR=date("n-j-Y","$Ccreate_dateR");
$Ascore= $row1['Ascore'];
$test_stat[$map_id]=0;
$sq112zzabg="SELECT * FROM $table_name301 WHERE map_id='$map_id'";
$result222azzg = @mysql_query($sq112zzabg,$connection) or die(mysql_error());
while ($row1abzzg = mysql_fetch_array($result222azzg)) {
$test_stat[$map_id]= $row1abzzg['test_stat'];
if ($test_stat[$map_id]==$blink){
$test_stat[$map_id]=0;
}
}
$bobgayel=$test_stat[$map_id];
// $stat_pov[$bobgayel]=$name;
// $stat_desc[$bobgayel]=$name_exp;
include("survey-row1-variables.php");
$cust_id= stripslashes($row1['customer_id']);
$sq112zzab="SELECT * FROM $table_name80 WHERE test_type='$map_id'";
$result222azz = @mysql_query($sq112zzab,$connection) or die(mysql_error());
while ($row1abzz = mysql_fetch_array($result222azz)) {
$survey_idzz= $row1abzz['survey_id'];
$Smap_id[$survey_idzz]= stripslashes($row1abzz['map_id']);
$SAscore[$survey_idzz]= stripslashes($row1abzz['Ascore']);
$STotal[$map_id]= $STotal[$map_id]+ $SAscore[$survey_idzz];
}
$sql29999 = "UPDATE $table_name80 SET van57='$STotal[$map_id]' WHERE map_id ='$map_id' " ; //add support_id
$result29999 = @mysql_query($sql29999,$connection) or die(mysql_error());
$sq112zzab2="SELECT * FROM $table_name200 WHERE map_id='$map_id'";
$result222azz2 = @mysql_query($sq112zzab2,$connection) or die(mysql_error());
while ($row1abzz2 = mysql_fetch_array($result222azz2)) {
$Ssig_id[$map_id]= stripslashes($row1abzz2['image_2']);
}
$sq112zzab22="SELECT * FROM $table_name78 WHERE map_id='$map_id'";
$result222azz22 = @mysql_query($sq112zzab22,$connection) or die(mysql_error());
while ($row1abzz22 = mysql_fetch_array($result222azz22)) {
$Schart[$map_id]= stripslashes($row1abzz22['company']);
$pop222azz22="";
}
$sq112zzab222="SELECT * FROM $table_name104 WHERE map_id='$map_id'";
$result222azz222 = @mysql_query($sq112zzab222,$connection) or die(mysql_error());
while ($row1abzz222 = mysql_fetch_array($result222azz222)) {
$Supload[$map_id]= stripslashes($row1abzz222['file_name']);
$Supload1[$map_id]="$Supload1[$map_id] $Supload[$map_id] ";
}
$sq112bb="SELECT * FROM $table_name82 WHERE customer_id = '$cust_id' ";
if ($survey_id>=21 AND $survey_id<27){
$sq112ab11="SELECT * FROM $table_name82 WHERE map_id = '$map_id55' ";
$result2221 = @mysql_query($sq112ab11,$connection) or die(mysql_error());
while ($row12 = mysql_fetch_array($result2221)) {
$firstname= stripslashes($row12['firstname']);
$lastname= stripslashes($row12['lastname']);
$lastnamez=$lastname;
$firstnamez=$firstname;
}
$sq112bb="SELECT * FROM $table_name82 WHERE map_id = '$map_id55' ";
}
$result222aa = @mysql_query($sq112bb,$connection) or die(mysql_error());
while ($row1dd = mysql_fetch_array($result222aa)) {
$val_fname= stripslashes($row1dd['firstname']);
$val_lname= stripslashes($row1dd['lastname']);
$val_email= stripslashes($row1dd['lastname']);
$val_phoneW= stripslashes($row1dd['telephone']);
$val_phoneF= stripslashes($row1dd['fax']);
$val_phoneC= stripslashes($row1dd['cell']);
$val_phoneH= stripslashes($row1dd['homeP']);
$val_addressH= stripslashes($row1dd['addressH']);
$stateH= stripslashes($row1dd['stateH']);
$val_cityH= stripslashes($row1dd['cityH']);
$countryH= stripslashes($row1dd['countryH']);
$ipH= $row1dd['ip'];
$val_zipH= stripslashes($row1dd['zip']);
$webH= stripslashes($row1dd['web']);
$company= stripslashes($row1dd['company']);
$agent_idH= stripslashes($row1dd['agent_id']);
}
if ($company ==$blink){
$company="NA";
}
// $sz_C5[$van3]="checked";
$del_list .="";
$display_entry .="