get_row("Select heading from $tt_table where class_id='".esc_sql($class_id)."' and heading!=''"); $check_tt = $wpdb->get_row($wpdb->prepare("SELECT heading FROM $tt_table WHERE class_id = %d and heading!= %s",$class_id,'')); $error = ''; $session = array(); if (!empty($check_tt)) { $error = 0; $get_sessions = unserialize($check_tt->heading); foreach ($get_sessions as $sesio) { $session[] = $sesio; } }else { $error = 1; echo "

Can't fetch template from the selected class

"; } if (count($session) > 0) { // $chck_hd = $wpdb->get_row("SELECT * from $tt_table where class_id='".esc_sql($class_id)."' and time_id='0' and day='0' and heading!=''"); $chck_hd = $wpdb->get_row($wpdb->prepare("SELECT * FROM $tt_table WHERE class_id = %d and time_id= %s and day = %s",$class_id,'0','0')); if (empty($chck_hd)) { //if(count($chck_hd) == null) { $ins = $wpdb->insert($tt_table, array('class_id' => $class_id,'heading' => serialize($session))); } } else { $error = 1; echo "

No Sessions Retrieved

"; } $wpsp_hours_table = $wpdb->prefix . "wpsp_workinghours"; $wpsp_subjects_table = $wpdb->prefix . "wpsp_subject"; // $clt = $wpdb->get_results("SELECT * FROM $wpsp_subjects_table WHERE class_id='".esc_sql($class_id)."' or class_id=0 order by class_id desc"); $clt = $wpdb->get_results($wpdb->prepare("SELECT * FROM $wpsp_subjects_table WHERE class_id = %d or class_id= %s order by class_id desc",$class_id,'0')); if( count($clt) == 0 ) { $error = 1; echo "

No Subjects retrieved, Check you have subject for this class at Subjects

"; } if( $error == 0 ) { $timetable = array(); $tt_query = $wpdb->prepare("SELECT * FROM $tt_table WHERE class_id = %d and time_id != %s",$class_id,'0'); $tt_days = $wpdb->get_results($tt_query,ARRAY_A); foreach( $tt_days as $ttd ) { $timetable[$ttd['day']][$ttd['time_id']] = $ttd['subject_id']; } ?>

' . esc_html($id->sub_name) . '

'; } ?>

prefix."wpsp_leavedays"; /* Sat-sun Off */ // $check = $wpdb->get_row("select description from $leave_table where class_id='".esc_sql($class_id)."'"); $check = $wpdb->get_row($wpdb->prepare("SELECT description FROM $leave_table WHERE class_id = %s",$class_id)); $wd = explode(',', $check->description); for ($j = 1; $j <= 7; $j++) { /* Sat-sun Off */ if (!empty($check)) { if ($wd[0] == $dayname[$j-1]) { continue; } if (isset($wd[1])) { if ($wd[1] == $dayname[$j-1]) { continue; } } }/* Sat-sun Off */ ?> get_results("SELECT * from $tt_table where class_id='".esc_sql($class_id)."' and day = '".esc_sql($j)."' ORDER BY session_id ASC"); $get_heading = $wpdb->get_results($wpdb->prepare("SELECT * FROM $tt_table WHERE class_id = %s and day = %s ORDER BY session_id ASC",$class_id,$j)); foreach ($get_heading as $subid){ $subida[] = $subid->subject_id; $subtimesloat[] = $subid->time_id; $subida1[] = $subid->is_active; reset($subida); reset($subida1); reset($subtimesloat); } $pa = 0; foreach ($session as $key => $ses) { $ses = esc_sql($ses); if($ses != $subtimesloat[$pa]){ // $hour_det = $wpdb->get_row("Select * from $wpsp_hours_table where id='$ses'"); $hour_det = $wpdb->get_row($wpdb->prepare("SELECT * FROM $wpsp_hours_table WHERE id = %s",$ses)); $td_class = $hour_det->type == "1" ? "drop" : "Break"; ?> get_row("Select * from $wpsp_hours_table where id='$ses'"); $hour_det = $wpdb->get_row($wpdb->prepare("SELECT * FROM $wpsp_hours_table WHERE id = %s",$ses)); $td_class = $hour_det->type == "1" ? "drop" : "break"; $sub_id = $sub_name = ''; if( isset($timetable[$j][$ses]) ) $sub_id = $timetable[$j][$ses]; if( $sub_id >0 ) { // $sub_name_f = $wpdb->get_results("SELECT sub_name from $subject_table where id=$subida[$pa]"); $sub_name_f = $wpdb->get_results($wpdb->prepare("SELECT sub_name FROM $subject_table WHERE id = %s",$subida[$pa])); $sub_name = isset( $sub_name_f[0]->sub_name ) ? $sub_name_f[0]->sub_name : 'N/A'; } if( !empty( $sub_name ) ) { if($td_class == "break"){ $sub_name = '

Break

'; } else { if($subida1[$pa] == 1){ $sub_name = '-'; } else { $sub_name = '

'.esc_attr($sub_name).'

'; } } } ?>

	get_row("Select * from $wpsp_hours_table where id='$sess'"); $ses_info = $wpdb->get_row($wpdb->prepare("SELECT * FROM $wpsp_hours_table WHERE id = %s",$sess)); echo esc_html($ses_info->begintime . " to " . $ses_info->endtime) ?>