} else { $view = 'alpha'; $r1 =& show_approved('bible_high'); $r2 =& show_approved('no_1'); $r3 =& show_approved('no_2'); $r4 =& show_approved('no_3'); $r5 =& show_approved('no_1'); $r6 =& show_approved('no_2'); $r7 =& show_approved('no_3'); $r8 =& show_approved('no_1'); $r9 =& show_approved('no_2'); $r10 =& show_approved('no_3'); $r11 =& show_approved('householder'); $r12 =& show_approved('householder'); $r32 =& show_approved('householder'); $r33 =& show_approved('householder'); } $r13 =& study(); $r14 =& setting(); $r15 =& study(); $r16 =& setting(); $r17 =& study(); $r18 =& setting(); $r19 =& study(); $r20 =& setting(); $r21 =& study(); $r22 =& setting(); $r23 =& study(); $r24 =& setting(); $r25 =& study(); $r26 =& setting();
} // *** END Update or insert attend1_meet1 assignment *** if ($_SERVER['REQUEST_METHOD'] == 'POST' and isset($_POST['attend2_meet2'])) { // *** Update or insert attend2_meet1 assignment *** $user_id = $_POST['attend2_meet2']; $conflict_msg =& handle_assignment_post($monday, $user_id, 2, $attend2_meet2, $page_id); // meeting_type_id = 1, assign_type_id = 31, page_id = 5 } // *** END Update or insert attend2_meet1 assignment *** // *** END Handle the Forms. *** $r1 =& show_approved(attend); // *** Database query variables for forms select options *** $r2 =& show_approved(attend); // Query in functions filter for those approved for assignments $r3 =& show_approved(attend); $r4 =& show_approved(attend); // Database query variables for when assignment record exists. The query returns data from users table and assignments table. $row_attend1_meet1 =& assign_record_exists($monday, $page_id, $attend1_meet1); // attend1_meet2 query - page_id = 5 AND assign_type_id = 28 $num_row_attend1_meet1 = mysqli_num_rows($row_attend1_meet1); $row_attend2_meet1 =& assign_record_exists($monday, $page_id, $attend2_meet1); // attend2_meet2 query - page_id = 5 AND assign_type_id = 29 $num_row_attend2_meet1 = mysqli_num_rows($row_attend2_meet1); $row_attend1_meet2 =& assign_record_exists($monday, $page_id, $attend1_meet2); // attend1_meet1 query - page_id = 5 AND assign_type_id = 30 $num_row_attend1_meet2 = mysqli_num_rows($row_attend1_meet2); $row_attend2_meet2 =& assign_record_exists($monday, $page_id, $attend2_meet2); // attend2_meet1 query - page_id = 5 AND assign_type_id = 31 $num_row_attend2_meet2 = mysqli_num_rows($row_attend2_meet2); // *** END Database query variables for forms select options *** // *** Create the Forms. Each form submits when a selection option is chosen. ***
} if ($_SERVER['REQUEST_METHOD'] == 'POST' and isset($_POST['mic2_meet1'])) { // *** Update or insert mic2_meet1 assignment *** $user_id = $_POST['mic2_meet1']; $conflict_msg =& handle_assignment_post($monday, $user_id, 1, $mic2_meet1, $page_id); // meeting_type_id = 1, assign_type_id = 27, page_id = 6 } $r1 =& show_approved(sound_panel); // query in functions filter for those approved for assignments $r2 =& show_approved(stage); $r3 =& show_approved(mic); $r4 =& show_approved(mic); $r5 =& show_approved(sound_panel); $r6 =& show_approved(stage); $r7 =& show_approved(mic); $r8 =& show_approved(mic); // Database query variables for when assignment record exists. The query returns data from users table and assignments table. $row_sound_meet2 =& assign_record_exists($monday, $page_id, $sound_meet2); //page_id = 6 AND assign_type_id = 20 // sound_meet2 query $num_row_sound_meet2 = mysqli_num_rows($row_sound_meet2); $row_stage_meet2 =& assign_record_exists($monday, $page_id, $stage_meet2); //page_id = 6 AND assign_type_id = 21 // stage_meet2 query $num_row_stage_meet2 = mysqli_num_rows($row_stage_meet2); $row_sound_meet1 =& assign_record_exists($monday, $page_id, $sound_meet1); //page_id = 6 AND assign_type_id = 24 // sound_meet1 query $num_row_sound_meet1 = mysqli_num_rows($row_sound_meet1); $row_stage_meet1 =& assign_record_exists($monday, $page_id, $stage_meet1); //page_id = 6 AND assign_type_id = 25 // stage_meet1 query $num_row_stage_meet1 = mysqli_num_rows($row_stage_meet1); $row_mic1_meet2 =& assign_record_exists($monday, $page_id, $mic1_meet2); //page_id = 6 AND assign_type_id = 22 // mic1_meet2 query
// *** Update or insert close_prayer assignment *** $user_id = $_POST['close_prayer']; $conflict_msg =& handle_assignment_post($monday, $user_id, $meeting_type_id, $close_prayer, $page_id); // meeting_type_id = 1, assign_type_id = 32, page_id = 4 } $cts_r =& cts_detail($monday); // Get the material for the Service Meeting while ($cts_row = mysqli_fetch_array($cts_r)) { $sm_1 = $cts_row['sm_1']; $sm_2 = $cts_row['sm_2']; $sm_3 = $cts_row['sm_3']; } $r1 =& show_approved(serv_meet); $r2 =& show_approved(serv_meet); $r3 =& show_approved(serv_meet); $r4 =& show_approved(prayer); $row_part_1 =& assign_record_exists($monday, $page_id, $part_1); // Database query variables for when assignment record exists. The query returns data from users table and assignments table. $num_row_part_1 = mysqli_num_rows($row_part_1); //page_id = 4 AND assign_type_id = 17 // part_1 query $row_part_2 =& assign_record_exists($monday, $page_id, $part_2); //page_id = 4 AND assign_type_id = 18 // part_2 query $num_row_part_2 = mysqli_num_rows($row_part_2); $row_part_3 =& assign_record_exists($monday, $page_id, $part_3); //page_id = 4 AND assign_type_id = 19 // part_3 query $num_row_part_3 = mysqli_num_rows($row_part_3); $row_close_prayer =& assign_record_exists($monday, $page_id, $close_prayer); //page_id = 4 AND assign_type_id = 32 // close_prayer query $num_row_close_prayer = mysqli_num_rows($row_close_prayer); if ($num_row_part_1 = 1) { $opt_1 = '<option value="' . $row_part_1['user_id'] . '" selected>' . $row_part_1['Name'] . '</option>';
$ptws_song_3 = $ptws_row[4]; } // END Database query variables for meeting details (titles of themes, sources material) // *** Database query variables for forms select options *** // Database query variables for when there is no assignment record yet existing. Show those who are approved for various assignments. $r1 =& show_approved(public_speaker); // Local speaker $r6 =& show_approved(public_speaker); // Outgoing speaker 1 $r10 =& show_approved(public_speaker); // Outgoing speaker 2 $r13 =& show_approved(public_speaker); // Outgoing speaker 3 $r2 =& show_approved(chairman); //$r3 =& show_approved(theme); $r4 =& show_approved(reader); //Select all the themes of the drop down(s) $query3 = "SELECT * FROM themes ORDER BY theme_id"; $r3 = mysqli_query($dbc, $query3) or die("MySQL error: " . mysqli_error($dbc) . "<hr>\nQuery: {$query3}"); $query5 = "SELECT * FROM themes ORDER BY theme_id"; $r5 = mysqli_query($dbc, $query5) or die("MySQL error: " . mysqli_error($dbc) . "<hr>\nQuery: {$query5}"); $query7 = "SELECT * FROM themes ORDER BY theme_id"; $r7 = mysqli_query($dbc, $query7) or die("MySQL error: " . mysqli_error($dbc) . "<hr>\nQuery: {$query7}"); $query12 = "SELECT * FROM themes ORDER BY theme_id"; $r12 = mysqli_query($dbc, $query12) or die("MySQL error: " . mysqli_error($dbc) . "<hr>\nQuery: {$query12}"); $query14 = "SELECT * FROM themes ORDER BY theme_id"; $r14 = mysqli_query($dbc, $query14) or die("MySQL error: " . mysqli_error($dbc) . "<hr>\nQuery: {$query15}"); //Select all the Congregation of the drop down(s) $query8 = "SELECT * FROM congregations ORDER BY congregation"; $r8 = mysqli_query($dbc, $query8) or die("MySQL error: " . mysqli_error($dbc) . "<hr>\nQuery: {$query8}"); $query9 = "SELECT * FROM congregations ORDER BY congregation";