Refresh List
"; $display_status .=""; $sq112ab="SELECT * FROM $table_name362 WHERE customer_group_id >8 ORDER BY name ASC "; $result112ab = @mysql_query($sq112ab,$connection) or die(mysql_error()); while ($row112ab = mysql_fetch_array($result112ab)) { $leader_id1= $row112ab['customer_group_id']; $cgfirst_id= $row112ab['name']; $last_id= $row112ab['lastname']; //$display_listCustGroup .= ""; } //List of Surveys //$sq112ab="SELECT * FROM $table_name36 where customer_group_id =$leader_id_stat OR customer_group_id =$overseer_id_stat ORDER BY lastname ASC "; $sq112ab="SELECT * FROM $table_name81 ORDER BY name ASC "; $result112ab = @mysql_query($sq112ab,$connection) or die(mysql_error()); while ($row112ab = mysql_fetch_array($result112ab)) { $leader_id1= $row112ab['survey_id']; $first_id= $row112ab['name']; //$last_id= $row112ab['lastname']; $display_listL .= ""; // $display_listCustGroup .= ""; } //find the surveys listed for metric $sq112cb="SELECT * FROM $table_name405 Where group_id ='$survey_id' ORDER BY leader_id "; $result112cb = @mysql_query($sq112cb,$connection) or die(mysql_error()); while ($row112cb = mysql_fetch_array($result112cb)) { $leader_idz= $row112cb['leader_id']; $sq112ab="SELECT * FROM $table_name76 Where survey_id='$leader_idz' ORDER BY surveyQQ_id ASC "; $result112ab = @mysql_query($sq112ab,$connection) or die(mysql_error()); while ($row112ab = mysql_fetch_array($result112ab)) { $leader_id1= $row112ab['surveyQQ_id']; $leader_id1N= $row112ab['surveyQ_id']; $gi=$gi+1; $first_id= $row112ab['question']; // $last_id= $row112ab['lastname']; $display_listL_A .= ""; //sum1 $display_listL_B .= ""; //sum2 $display_listO .= ""; //sum3 $display_listCustGroup .= ""; //sum4 } $gi=0; } $sq112ab="SELECT * FROM $table_name404 Where dropdown_id='2' ORDER BY value ASC "; $result112ab = @mysql_query($sq112ab,$connection) or die(mysql_error()); while ($row112ab = mysql_fetch_array($result112ab)) { $leader_id1= $row112ab['table_id']; $first_id= $row112ab['value']; //$last_id= $row112ab['lastname']; $display_listL_Adm .= ""; //operation 1 $display_listS .= ""; //operation 2 } //$sq112ab="SELECT * FROM $table_name36 where customer_group_id =$overseer_id_stat ORDER BY lastname ASC"; // $result112ab = @mysql_query($sq112ab,$connection) or die(mysql_error()); //while ($row112ab = mysql_fetch_array($result112ab)) { // $leader_id1= $row112ab['customer_id']; // $first_id= $row112ab['firstname']; // $last_id= $row112ab['lastname']; // $display_listO .= ""; //} //$sq112ab="SELECT * FROM $table_name36 ORDER BY lastname ASC"; // $result112ab = @mysql_query($sq112ab,$connection) or die(mysql_error()); //while ($row112ab = mysql_fetch_array($result112ab)) { // $leader_id1= $row112ab['customer_id']; // $first_id= $row112ab['firstname']; // $last_id= $row112ab['lastname']; // $display_listS .= ""; //} //$sq112ab="SELECT * FROM $table_name36 where customer_group_id =$other_id_stat ORDER BY lastname ASC"; $sq112ab="SELECT * FROM $table_name404 Where (table_id>'15'AND table_id<='20') Or table_id='25' Or dropdown_id='2' ORDER BY value ASC"; $result112ab = @mysql_query($sq112ab,$connection) or die(mysql_error()); while ($row112ab = mysql_fetch_array($result112ab)) { $leader_id1= $row112ab['table_id']; $first_id= $row112ab['value']; $last_id= $row112ab['lastname']; $display_listOth .= ""; } $sq112aaD ="SELECT * FROM $table_nameApp Where survey_id ='$survey_id' "; $result333D = @mysql_query($sq112aaD,$connection) or die(mysql_error()); $num33 = mysql_num_rows($result333D); while ($row1D = mysql_fetch_array($result333D)) { $survey_id= $row1D['survey_id']; $Cname= stripslashes($row1D['name']); $Ccomments= stripslashes($row1D['comment']); $sq112aaE ="SELECT * FROM $table_name405 Where group_id ='$survey_id' "; $result333E = @mysql_query($sq112aaE,$connection) or die(mysql_error()); while ($row1E = mysql_fetch_array($result333E)) { $leader_match_id= $row1E['leader_match_id']; $leader_id= $row1E['leader_id']; $leader_idA= $row1E['leader_idA']; $leader_idB= $row1E['leader_idB']; $leader_idAdm= $row1E['leader_idAdm']; $Cstatus= ($row1E['status']); $Ccreate_date= $row1E['create_date']; $EditQ= $row1E['EditQ']; $EditA= $row1E['EditA']; $Cstatus2[1]="Enabled"; $Cstatus2[0]="Disabled"; $sql361 ="SELECT * FROM $table_name81 WHERE survey_id = '$leader_id' "; $result2261 = @mysql_query($sql361,$connection) or die(mysql_error()); $row161 =mysql_fetch_array($result2261,MYSQL_ASSOC); if ($leader_id == $row161['survey_id']) { $Lfirst_id= $row161['name']; //$Llast_id= $row161['lastname']; } else{ //$Llast_id=''; $Lfirst_id=''; } $sql361 ="SELECT * FROM $table_name76 WHERE surveyQQ_id = '$leader_idA' "; $result2261 = @mysql_query($sql361,$connection) or die(mysql_error()); $row161 =mysql_fetch_array($result2261,MYSQL_ASSOC); if ($leader_idA == $row161['surveyQQ_id']) { $Lfirst_idA= $row161['question']; // $Llast_idA= $row161['lastname']; }else{ //$Llast_idA=''; $Lfirst_idA=''; } $sql361 ="SELECT * FROM $table_name76 WHERE surveyQQ_id = '$leader_idB' "; $result2261 = @mysql_query($sql361,$connection) or die(mysql_error()); $row161 =mysql_fetch_array($result2261,MYSQL_ASSOC); if ($leader_idB == $row161['surveyQQ_id']) { $Lfirst_idB= $row161['question']; //$Llast_idB= $row161['lastname']; }else{ //$Llast_idB=''; $Lfirst_idB=''; } $sql361 ="SELECT * FROM $table_name404 WHERE table_id = '$leader_idAdm' "; $result2261 = @mysql_query($sql361,$connection) or die(mysql_error()); $row161 =mysql_fetch_array($result2261,MYSQL_ASSOC); if ($leader_idAdm == $row161['table_id']) { $Lfirst_idAdm= $row161['value']; //$Llast_idAdm= $row161['lastname']; }else{ //$Llast_idAdm=''; $Lfirst_idAdm=''; } $overseer_id= $row1E['overseer_id']; $sql361 ="SELECT * FROM $table_name76 WHERE surveyQQ_id = '$overseer_id' "; $result2261 = @mysql_query($sql361,$connection) or die(mysql_error()); $row161 =mysql_fetch_array($result2261,MYSQL_ASSOC); if ($overseer_id == $row161['surveyQQ_id']) { $OLfirst_id= $row161['question']; //$OLlast_id= $row161['lastname']; }else{ //$OLlast_id=''; $OLfirst_id=''; } $support_id= $row1E['support_id']; $sql361 ="SELECT * FROM $table_name404 WHERE table_id = '$support_id' "; $result2261 = @mysql_query($sql361,$connection) or die(mysql_error()); $row161 =mysql_fetch_array($result2261,MYSQL_ASSOC); if ($support_id == $row161['table_id']) { $SLfirst_id= $row161['value']; //$SLlast_id= $row161['lastname']; } else{ //$SLlast_id=''; $SLfirst_id=''; } $other_id= $row1E['other_id']; $sql361 ="SELECT * FROM $table_name404 WHERE table_id = '$other_id' "; $result2261 = @mysql_query($sql361,$connection) or die(mysql_error()); $row161 =mysql_fetch_array($result2261,MYSQL_ASSOC); if ($other_id == $row161['table_id']) { $OthLfirst_id= $row161['value']; $OthLlast_id= $row161['lastname']; }else{ $OthLlast_id=''; $OthLfirst_id=''; } $gother_id= $row1E['customer_group_id']; $sql361 ="SELECT * FROM $table_name76 WHERE surveyQQ_id = '$gother_id' "; $result2261 = @mysql_query($sql361,$connection) or die(mysql_error()); $row161 =mysql_fetch_array($result2261,MYSQL_ASSOC); if ($gother_id == $row161['surveyQQ_id']) { $gOthLfirst_id= $row161['question']; } else{ $gOthLfirst_id=''; } $Ccreate_dateE= $row1E['create_date']; // } if ($Ccreate_date==$blink){ // $Ccreate_date="
No leader records created for this group
"; } $display_entry .="
$survey_id-$leader_match_id $Ccreate_date $Cname $Ccomments $Cstatus2[$Cstatus]
Select Update
"; $gother_id=''; $other_id=''; $support_id=''; $overseer_id=''; $leader_idAdm=''; $leader_idA=''; $leader_idB=''; $leader_id=''; $OthLfirst_id=''; $OthLlast_id=''; $gOthLfirst_id=''; $SLfirst_id=''; $SLlast_id =''; $OLfirst_id=''; $OLlast_id=''; $Lfirst_idAdm=''; $Llast_idAdm=''; $Lfirst_idB =''; $Llast_idB=''; $Lfirst_idA=''; $Llast_idA =''; $Lfirst_id=''; $Llast_id=''; } $display_entry .="
$Cname $Ccomments $Cstatus2[$Cstatus]
Add Elements
"; //$edit_block .="
Ability to Edit $Record: Status $Cstatus2D[$EditQD]
// Ability to Edit Answers: Status $Cstatus2D[$EditAD]
"; } // Add Stakeholder: Customer, Leader, Support Person, etc.
$display_blockV .=" $bottomRepReset
Note: [Sum1 (Operation1) Sum2] (operation2) [Sum3 (operation3) Sum4]
ie: [Sum1 difference Sum2] divisor [Sum3 multipy Sum4] = [Sum1-Sum2]/[Sum3 *Sum4]
Use of a timeframe nullifies use of Sum4 Column. Count in Operation 1 Does not use the Sum2 column. Count in Operation 2 Does nothing. Count in Operation 3 Does not use Sum4. Note: Below: Sort Function is Case-Sensitive. Date sort is Format-Sensitive. $display_entry
$Record ID Date Added $Record Title $Record Summary $Leader $Leader_A $Leader_B $Administrator $Pastor_Support $Admin_Support $Additional_Resource $Additional_Group Status Action


$noteB
Showing Results: $num33 Record(s)"; ?>