$row_second_3_hh =& assign_record_exists($monday, $page_id, $second_3_hh);
//page_id = 3 AND assign_type_id = 36// second_3 hh query
$num_row_second_3_hh = mysqli_num_rows($row_second_3_hh);
$row_third_1 =& assign_record_exists($monday, $page_id, $third_1);
//page_id = 3 AND assign_type_id = 14// third_1 query
$num_row_third_1 = mysqli_num_rows($row_third_1);
$row_third_2 =& assign_record_exists($monday, $page_id, $third_2);
//page_id = 3 AND assign_type_id = 15// third_2 query
$num_row_third_2 = mysqli_num_rows($row_third_2);
$row_third_2_hh =& assign_record_exists($monday, $page_id, $third_2_hh);
//page_id = 3 AND assign_type_id = 37// third_2 hh query
$num_row_third_2_hh = mysqli_num_rows($row_third_2_hh);
$row_third_3 =& assign_record_exists($monday, $page_id, $third_3);
//page_id = 3 AND assign_type_id = 16// third_3 query
$num_row_third_3 = mysqli_num_rows($row_third_3);
$row_third_3_hh =& assign_record_exists($monday, $page_id, $third_3_hh);
//page_id = 3 AND assign_type_id = 38// third_3 hh query
$num_row_third_3_hh = mysqli_num_rows($row_third_3_hh);
if ($num_row_highlights = 1) {
$opt_highlights = '<option value="' . $row_highlights['user_id'] . '" selected>' . $row_highlights['Name'] . '</option>';
while ($row1 = mysqli_fetch_array($r1)) {
if ($view == 'date') {
$opt_highlights .= '<option value="' . $row1['user_id'] . '">' . $row1['Name'] . ' ... ' . date('F j, Y', strtotime($row1['Last'])) . '</option>';
} else {
if ($view == 'alpha') {
$opt_highlights .= '<option value="' . $row1['user_id'] . '">' . $row1['Name'] . '</option>';
}
}
}
} else {
while ($row1 = mysqli_fetch_array($r1)) {
// *** 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 ($num_row_attend1_meet1 = 1) {
$opt_1 = '<option value="' . $row_attend1_meet1['user_id'] . '" selected>' . $row_attend1_meet1['Name'] . '</option>';
while ($row1 = mysqli_fetch_array($r1)) {
$opt_1 .= '<option value="' . $row1['user_id'] . '">' . $row1['Name'] . '</option>';
}
} else {
while ($row1 = mysqli_fetch_array($r1)) {
$opt_1 = '<option value="' . $row1['user_id'] . '">' . $row1['Name'] . '</option>';
}
}
if ($num_row_attend2_meet1 = 1) {
}
$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>';
while ($row1 = mysqli_fetch_array($r1)) {
$opt_1 .= '<option value="' . $row1['user_id'] . '">' . $row1['Name'] . '</option>';
}
} else {
while ($row1 = mysqli_fetch_array($r1)) {
$opt_1 = '<option value="' . $row1['user_id'] . '">' . $row1['Name'] . '</option>';
}
}
if ($num_row_part_2 = 1) {
$opt_2 = '<option value="' . $row_part_2['user_id'] . '" selected>' . $row_part_2['Name'] . '</option>';
while ($row2 = mysqli_fetch_array($r2)) {
$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
$num_row_mic1_meet2 = mysqli_num_rows($row_mic1_meet2);
$row_mic2_meet2 =& assign_record_exists($monday, $page_id, $mic2_meet2);
//page_id = 6 AND assign_type_id = 23 // mic2_meet2 query
$num_row_mic2_meet2 = mysqli_num_rows($row_mic2_meet2);
$row_mic1_meet1 =& assign_record_exists($monday, $page_id, $mic1_meet1);
//page_id = 6 AND assign_type_id = 26 // mic1_meet1 query
$num_row_mic1_meet1 = mysqli_num_rows($row_mic1_meet1);
$row_mic2_meet1 =& assign_record_exists($monday, $page_id, $mic2_meet1);
//page_id = 6 AND assign_type_id = 27 // mic2_meet1 query
$num_row_mic2_meet1 = mysqli_num_rows($row_mic2_meet1);
// *** END Database query variables for forms select options ***
if ($num_row_sound_meet1 = 1) {
// If the query returns a record matching the date, assignment type and meeting, then use it for the selected option and also include the all the other names or else just show all the names in the option. Also the option assigns the user ID to its value, which is used in the POST check conditionals.
$opt_1 = '<option value="' . $row_sound_meet1['user_id'] . '" selected>' . $row_sound_meet1['Name'] . '</option>';
while ($row5 = mysqli_fetch_array($r5)) {
$opt_1 .= '<option value="' . $row5['user_id'] . '">' . $row5['Name'] . '</option>';
}
} else {
while ($row5 = mysqli_fetch_array($r5)) {
$opt_1 = '<option value="' . $row5['user_id'] . '">' . $row5['Name'] . '</option>';
}
}
if ($num_row_stage_meet1 = 1) {
$r_local_talks = mysqli_query($dbc, $query_local_talks) or die("MySQL error_local_talks: " . mysqli_error($dbc) . "<hr>\nQuery: {$query_local_talks}");
$row_local_talks = mysqli_fetch_array($r_local_talks);
$num_row_local_talks = mysqli_num_rows($row_local_talks);
//$local = $row_local_talks['local_sp'];
//echo $query_local_talks . '<br>';
$query_out_talks = "SELECT talk_id, week_of, name, phone, no_hosp, congr_id, theme_id, CONCAT (t.theme_id,' ',t.theme) AS Theme, local_sp \n\t\tFROM talks\n\t\tLEFT JOIN themes AS t\n\t\tUSING ( theme_id )\n\t\tWHERE week_of = '{$monday}' AND local_sp = 1 AND outgoing = 1";
$r_out_talks = mysqli_query($dbc, $query_out_talks) or die("MySQL error_visit_talks: " . mysqli_error($dbc) . "<hr>\nQuery: {$query_out_talks}");
$row_out_talks = mysqli_fetch_array($r_out_talks);
$num_row_out_talks = mysqli_num_rows($row_out_talks);
//echo $query_out_talks;
// Chairman query
$row_chairman =& assign_record_exists($monday, 1, 2);
//page_id = 1 AND assign_type_id = 2
$num_row_chairman = mysqli_num_rows($row_chairman);
// wtreader query
$row_wtreader =& assign_record_exists($monday, 1, 4);
//page_id = 1 AND assign_type_id = 4
$num_row_wtreader = mysqli_num_rows($row_wtreader);
// theme query
$query_theme = "SELECT theme_id, t.theme AS theme\n\t\tFROM talks\n\t\tINNER JOIN themes AS t\n\t\tUSING ( theme_id )\n\t\tWHERE week_of = '{$monday}'";
$r_theme = mysqli_query($dbc, $query_theme) or die("MySQL error: " . mysqli_error($dbc) . "<hr>\nQuery: {$query_theme}");
$row_theme = mysqli_fetch_array($r_theme);
$num_row_theme = mysqli_num_rows($row_theme);
//$row_theme =& assign_record_exists($monday, 1, 4); //page_id = 1 AND assign_type_id = 4
//$num_row_theme = mysqli_num_rows($row_theme);
// *** END Database query variables for forms select options ***
require 'db_close.php';
// Close the database connection.
// *** Database query for visiting speakers
// Assign current URL to a variable to use in the form action. This will include the GET date for the week of Monday...
$page = $_SERVER['REQUEST_URI'];
function &school_worksheet_1()
{
//require_once ('functions_date.php');
require 'config.inc.php';
require MYSQL;
// ****************** VARIABLES ************************** //
$host = $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI'];
$page = $_SERVER['REQUEST_URI'];
$user_id = $_SESSION['user_id'];
$email = $_SESSION['email'];
//$method = $_SERVER['REQUEST_METHOD'];
//$get_monday = $_GET['monday'];
//$post_monday = $_POST['monday'];
//$monday =& get_monday_date($method, $get_monday, $post_monday);
//
//POST the date for Monday when a date is selected in the drop down:
if ($_SERVER['REQUEST_METHOD'] == 'POST' and strpos($host, 'khlogic.org/index.php') !== false) {
$monday = $_POST['monday'];
}
// GET the date for Monday for the PDF view:
if ($_SERVER['REQUEST_METHOD'] == 'GET' and strpos($host, 'khlogic.org/schoolworksheet_pdf.php') !== false) {
$monday = $_GET['monday'];
}
//
$date = date('F j, Y', strtotime($monday));
$midweek = date('n/j/y', strtotime('+2 days', strtotime($monday)));
$sunday = date('n/j/y', strtotime('+6 days', strtotime($monday)));
$next_week = date('Y-n-j', strtotime('+7 days', strtotime($monday)));
// ******************END VARIABLES************************** //
// ****************** QUERIES **************************** //
// Database query variables for meeting details (titles of talks, sources material)
$cts_detail_query = "SELECT * FROM cts_detail WHERE week_of = '{$monday}'";
$cts_r = mysqli_query($dbc, $cts_detail_query) or die("MySQL error: " . mysqli_error($dbc) . "<hr>\ncts_query: {$cts_detail_query}");
while ($cts_row = mysqli_fetch_array($cts_r)) {
$song_1 = $cts_row['song_1'];
$cbs = $cts_row['cbs'];
$bible_read = $cts_row['bible_read'];
$no_1 = $cts_row['no_1'];
$no_2 = $cts_row['no_2'] . ' (' . $cts_row['no_2_source'] . ')';
$no_3 = $cts_row['no_3'] . ' (' . $cts_row['no_3_source'] . ')';
$song_2 = $cts_row['song_2'];
$sm_1 = $cts_row['sm_1'];
$sm_2 = $cts_row['sm_2'];
$sm_3 = $cts_row['sm_3'];
$song_3 = $cts_row['song_3'];
}
$next_cts_detail_query = "SELECT * FROM cts_detail WHERE week_of = '{$next_week}'";
$next_cts_r = mysqli_query($dbc, $next_cts_detail_query) or die("MySQL error: " . mysqli_error($dbc) . "<hr>\ncts_query: {$next_cts_detail_query}");
while ($next_cts_row = mysqli_fetch_array($next_cts_r)) {
$next_bible_read = $next_cts_row['bible_read'];
}
// END Database query variables for meeting details (titles of talks, sources material)
// assign_record_exists() function determines if an assignment record for a given date already exists. It returns an array including user and assignment information.
// Database query variables for when assignment record exists. The query returns data from users table and assignments table.
// overseer query
$row_overseer =& assign_record_exists($monday, 2, 3);
//page_id = 2 AND assign_type_id = 3
$num_row_overseer = mysqli_num_rows($row_overseer);
// reader query
$row_reader =& assign_record_exists($monday, 2, 4);
//page_id = 2 AND assign_type_id = 4
$num_row_reader = mysqli_num_rows($row_reader);
// open_prayer query
$row_open_prayer =& assign_record_exists($monday, 2, 5);
//page_id = 2 AND assign_type_id = 5
$num_row_open_prayer = mysqli_num_rows($row_open_prayer);
// highlights query
$row_highlights =& assign_record_exists($monday, 3, 7);
//page_id = 3 AND assign_type_id = 7
$num_row_highlights = mysqli_num_rows($row_highlights);
// next highlights query
$row_next_highlights =& assign_record_exists($next_week, 3, 7);
//page_id = 3 AND assign_type_id = 7
$num_row_next_highlights = mysqli_num_rows($row_highlights);
//Main school queries
// main_1 query
$row_main_1 =& assign_record_exists($monday, 3, 8);
//page_id = 3 AND assign_type_id = 8
$num_row_main_1 = mysqli_num_rows($row_main_1);
// main_2 query
$row_main_2 =& assign_record_exists($monday, 3, 9);
//page_id = 3 AND assign_type_id = 9
$num_row_main_2 = mysqli_num_rows($row_main_2);
// main_2 hh query
$row_main_2_hh =& assign_record_exists($monday, 3, 33);
//page_id = 3 AND assign_type_id = 33
$num_row_main_2_hh = mysqli_num_rows($row_main_2_hh);
// main_3 query
$row_main_3 =& assign_record_exists($monday, 3, 10);
//page_id = 3 AND assign_type_id = 10
$num_row_main_3 = mysqli_num_rows($row_main_3);
// main_3 hh query
$sister =& is_sister($monday, 10);
if ($sister == 1) {
$row_main_3_hh =& assign_record_exists($monday, 3, 34);
//page_id = 3 AND assign_type_id = 34
$num_row_main_3_hh = mysqli_num_rows($row_main_3_hh);
}
//END Main school queries
// Second school queries
// second_1 query
$row_second_1 =& assign_record_exists($monday, 3, 11);
//page_id = 3 AND assign_type_id = 11
$num_row_second_1 = mysqli_num_rows($row_second_1);
// second_2 query
$row_second_2 =& assign_record_exists($monday, 3, 12);
//page_id = 3 AND assign_type_id = 12
$num_row_second_2 = mysqli_num_rows($row_second_2);
// second_2 hh query
$row_second_2_hh =& assign_record_exists($monday, 3, 35);
//page_id = 3 AND assign_type_id = 35
$num_row_second_2_hh = mysqli_num_rows($row_second_2_hh);
// second_3 query
$row_second_3 =& assign_record_exists($monday, 3, 13);
//page_id = 3 AND assign_type_id = 13
$num_row_second_3 = mysqli_num_rows($row_second_3);
// second_3 hh query
$sister =& is_sister($monday, 13);
if ($sister == 1) {
$row_second_3_hh =& assign_record_exists($monday, 3, 36);
//page_id = 3 AND assign_type_id = 36
$num_row_second_3_hh = mysqli_num_rows($row_second_3_hh);
}
//END Second school queries
//Third school queries
// third_1 query
$row_third_1 =& assign_record_exists($monday, 3, 14);
//page_id = 3 AND assign_type_id = 14
$num_row_third_1 = mysqli_num_rows($row_third_1);
// third_2 query
$row_third_2 =& assign_record_exists($monday, 3, 15);
//page_id = 3 AND assign_type_id = 15
$num_row_third_2 = mysqli_num_rows($row_third_2);
// third_2 hh query
$row_third_2_hh =& assign_record_exists($monday, 3, 37);
//page_id = 3 AND assign_type_id = 37
$num_row_third_2_hh = mysqli_num_rows($row_third_2_hh);
// third_3 query
$row_third_3 =& assign_record_exists($monday, 3, 16);
//page_id = 3 AND assign_type_id = 16
$num_row_third_3 = mysqli_num_rows($row_third_3);
// third_3 hh query
$sister =& is_sister($monday, 16);
if ($sister == 1) {
$row_third_3_hh =& assign_record_exists($monday, 3, 38);
//page_id = 3 AND assign_type_id = 38
$num_row_third_3_hh = mysqli_num_rows($row_third_3_hh);
}
//END Third school queries
// *** END Database query variables for forms select options ***
// sister & aux school queries
$sister1 =& is_sister($monday, 10);
if ($sister1 == 1) {
$main_hall_no3 = $row_main_3['Name'] . '<br>' . $row_main_3_hh['Name'];
} else {
$main_hall_no3 = $row_main_3['Name'];
}
if (NUMBER_SCHOOLS >= 2) {
$sister2 =& is_sister($monday, 13);
if ($sister2 == 1) {
$sec_hall_no3 = $row_second_3['Name'] . '<br>' . $row_second_3_hh['Name'];
} else {
$sec_hall_no3 = $row_second_3['Name'];
}
$sec_hall_header = '2nd Hall';
$sec_hall_no1 = $row_second_1['Name'];
$sec_hall_no2 = $row_second_2['Name'] . '<br>' . $row_second_2_hh['Name'];
$col_wid_2 = '150';
}
if (NUMBER_SCHOOLS >= 3) {
$sister =& is_sister($monday, 16);
if ($sister == 1) {
$third_hall_no3 = $row_third_3 . '<br>' . $row_third_3_hh['Name'];
} else {
$third_hall_no3 = $row_third_3;
}
$third_hall_header = '3rd Hall';
$third_hall_no1 = $row_third_1['Name'];
$third_hall_no2 = $row_third_2['Name'] . '<br>' . $row_third_2_hh['Name'];
$col_wid_3 = '150';
}
// ****************** END QUERIES **************************** //
$school_worksheet_1 .= '<h1>' . $date . '</h1>';
$school_worksheet_1 .= '<h4>Main School (' . $midweek . ')' . $tms_edit_btn . '</h4>';
$school_worksheet_1 .= '<br><table><tr><td> </td><td> </td><td> </td><td> </td><td> </td></tr></table>
<table class="sched_table" >
<tr><th width="50" valign="top"></th><th width="150" >MainHall</th><th width="' . $col_wid_2 . '">' . $sec_hall_header . '</th><th width="' . $col_wid_3 . '" >' . $third_hall_header . '</th><th></th></tr><tr>
<td valign="top" style="border-top:1px solid black">No. 1</td>
<td valign="top" style="border-top:1px solid black">' . $row_main_1['Name'] . '</td>
<td valign="top" style="border-top:1px solid black">' . $sec_hall_no1 . '</td>
<td width="300" valign="top" style="border-top:1px solid black"><i>' . $no_1 . '</i></td>
</tr><tr>
<td valign="top" style="border-top:1px solid black">No. 2</td>
<td valign="top" style="border-top:1px solid black">' . $row_main_2['Name'] . '<br>' . $row_main_2_hh['Name'] . '</td>
<td valign="top" style="border-top:1px solid black">' . $sec_hall_no2 . '</td>
<td width="300" valign="top" style="border-top:1px solid black"><i>' . $no_2 . '</i></td>
</tr><tr>
<td valign="top" style="border-top:1px solid black">No. 3</td>
<td valign="top" style="border-top:1px solid black">' . $main_hall_no3 . '</td>
<td valign="top" style="border-top:1px solid black">' . $sec_hall_no3 . '</td>
<td width="300" valign="top" style="border-top:1px solid black"><i>' . $no_3 . '</i></td>
</tr></table>';
$school_worksheet_1 .= '
<table><tr>
<td width="120" valign="top">Bible Highlights Next Week:</td><td width="150" valign="top">' . $row_next_highlights['Name'] . '</td>
<td width="300" valign="top"><i>' . $next_bible_read . '</i></td>
</tr></table><div style="page-break-after:always"></div>';
$school_worksheet_1 .= '<h1>' . $date . '</h1>';
$school_worksheet_1 .= '<h4>Second School (' . $midweek . ')' . $tms_edit_btn . '</h4>';
$school_worksheet_1 .= '<br><table><tr><td> </td><td> </td><td> </td><td> </td><td> </td></tr></table>
<table class="sched_table" >
<tr><th width="50" valign="top"></th><th width="150" >MainHall</th><th width="' . $col_wid_2 . '">' . $sec_hall_header . '</th><th width="' . $col_wid_3 . '" >' . $third_hall_header . '</th><th></th></tr><tr>
<td valign="top" style="border-top:1px solid black">No. 1</td>
<td valign="top" style="border-top:1px solid black">' . $row_main_1['Name'] . '</td>
<td valign="top" style="border-top:1px solid black">' . $sec_hall_no1 . '</td>
<td width="300" valign="top" style="border-top:1px solid black"><i>' . $no_1 . '</i></td>
</tr><tr>
<td valign="top" style="border-top:1px solid black">No. 2</td>
<td valign="top" style="border-top:1px solid black">' . $row_main_2['Name'] . '<br>' . $row_main_2_hh['Name'] . '</td>
<td valign="top" style="border-top:1px solid black">' . $sec_hall_no2 . '</td>
<td width="300" valign="top" style="border-top:1px solid black"><i>' . $no_2 . '</i></td>
</tr><tr>
<td valign="top" style="border-top:1px solid black">No. 3</td>
<td valign="top" style="border-top:1px solid black">' . $main_hall_no3 . '</td>
<td valign="top" style="border-top:1px solid black">' . $sec_hall_no3 . '</td>
<td width="300" valign="top" style="border-top:1px solid black"><i>' . $no_3 . '</i></td>
</tr></table>';
$school_worksheet_1 .= '
<table><tr>
<td width="120" valign="top">Bible Highlights Next Week:</td><td width="150" valign="top">' . $row_next_highlights['Name'] . '</td>
<td width="300" valign="top"><i>' . $next_bible_read . '</i></td>
</tr></table><div style="page-break-after:always"></div>';
$school_worksheet_1 .= '<h1>' . $date . '</h1>';
$school_worksheet_1 .= '<h4>Auxilary Council Worksheet (' . $midweek . ')' . $tms_edit_btn . '</h4>';
$school_worksheet_1 .= '
<table><tr>
<td width="120" valign="top">Bible Highlights:</td><td width="150" valign="top">' . $row_highlights['Name'] . '</td>
<td width="300" valign="top"><i>' . $bible_read . '</i></td>
</tr></table>';
require CLSMYSQL;
// Database connection.
if (strpos($host, 'khlogic.org/index.php') !== false) {
$school_worksheet_1 .= '<a href="schedule_pdf.php?monday=' . $monday . '" target="blank"><span class="glyphicon glyphicon-file"></span></a>';
}
return $school_worksheet_1;
}
