//
//
//
//
//
$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']);
}
$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' ";
// }
if ($sbad==20){
$sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR'AND Ascore >='$look20' ";
}
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){
$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' ";
$warn= "
Record Deleted
";
}else{
$warn= "
You cannot delete the Base Survey.
";
$sq112a="SELECT * FROM $table_name80 WHERE survey_id = '$survey_idR' ";
}
}
$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'];
include("survey-row1-variables.php");
$cust_id= stripslashes($row1['customer_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']);
}
$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 .="
";
}
//// Here's the report mover
$sq112bd="SELECT distinct company FROM $table_name82 WHERE survey_id = '$survey_idR' ";
$result222ad = @mysql_query($sq112bd,$connection) or die(mysql_error());
while ($row1dd = mysql_fetch_array($result222ad)) {
$company= stripslashes($row1dd['company']);
if ($company != $blink){
$sel_org .="";
}
}
$bottomDelete .=" ";
$sel_date .="
";
$bottomDate .=" ";
include("note.php");
// $noteC - We've removed deletion on this page
if ($sbad != 100 ){
include("display_block4V.php");
}else{
// $sq112a="SELECT * FROM $table_name76 WHERE survey_id ='$survey_idR' ";
$sq112a="SELECT * FROM $table_name76 WHERE survey_id ='$survey_idR' Order By surveyQ_id ";
$survey_num=$survey_idR;
include("surv_display2.php");
include("display_block4V_100.php");
}
?>