" . mysql_error()); $num_recipients = mysql_result($result, 0); // get total number of respondents for this survey $sql = "SELECT COUNT(*) FROM tbl_persons WHERE job_id = '$session_job_id'"; $result = mysql_query($sql, $connection) or die("could not count respondents
" . mysql_error()); $num_respondents = mysql_result($result, 0); ?>

Control & Monitor Survey Response

"; ?>

Feedback Recipients

"; ?>

Respondents

" . mysql_error()); for ($i=1; $i<=$num_recipients; $i++){ $row = mysql_fetch_array($result); $first_name = $row['first_name']; $last_name = $row['last_name']; echo""; } ?> " . mysql_error()); // for each respondent (num_respondents = num rows in the grid) for ($i=1; $i<=$num_respondents; $i++){ $row = mysql_fetch_array($result3); $first_name = $row['first_name']; $last_name = $row['last_name']; $respondent_id = $row['person_id']; //echo "i is $i. beginning a row
"; echo ""; // get all recipients that this respondent will respond to: //$sql4 = "SELECT recipient_id, response_type, y_n_completed FROM jct_recipients_respondents //WHERE respondent_id = $respondent_id"; $sql4 = "SELECT jrr.recipient_id, jrr.response_type, jrr.y_n_completed FROM jct_recipients_respondents as jrr, tbl_persons as tp WHERE jrr.respondent_id = $respondent_id AND tp.person_id = jrr.recipient_id ORDER BY tp.last_name, tp.first_name"; $result4 = mysql_query($sql4, $connection) or die("could not query for recipients
" . mysql_error()); // for each recipient for ($j=1; $j<=$num_recipients; $j++){ $row = mysql_fetch_array($result4); $recipient_id = $row['recipient_id']; //echo "recipient_id is $recipient_id
"; $response_type = $row['response_type']; //$survey_name = "survey_" . $completed = $row['y_n_completed']; if (! $completed && $response_type != 'NONE'){ $color = "CC5555";//red } else if (! $completed && $response_type = 'NONE'){ $color = "999999";//grey } else{ $color = "66CC99";//green } //echo "j is $j. echo" "; }//end of for loop using j for each recipient echo ""; } // end of for loop using i for each respondent // end of echoing one row in the grid ?>


	$first_name $last_name
$first_name $last_name	$response_type

Notifications

Color Key

SURVEY COMPLETED

SURVEY OUTSTANDING

NO SURVEY NEEDED

"; }// end function show_color_key ?>