get_row($wpdb->prepare("SELECT heading FROM $tt_table WHERE class_id = %d AND heading != %s",$wpsp_class_id,''));
if (!empty($check_tt)) {
$get_sessions = unserialize($check_tt->heading);
foreach ($get_sessions as $sesio) {
$session[] = $sesio;
}
$error = 0;
} 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' AND heading != %s",$wpsp_class_id,'0','0',''));
if (empty($chck_hd)) {
$ins = $wpdb->insert($tt_table, array(
'class_id' => $class_id,
'heading' => serialize($session)
));
} else {
// echo "
*Sessions already available in order to edit session delete and regenerate timetable.";
}
$error = 0;
} 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 = %d 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_days = $wpdb->get_results("select * from $tt_table where class_id='".esc_sql($class_id)."' and time_id !='0' ", ARRAY_A);
$tt_query = $wpdb->prepare("SELECT * FROM $tt_table WHERE class_id = %d or 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'];
}
?>
' . $id->sub_name . '
';*/
echo '
' . esc_html($id->sub_name) . '
';
}
?>