prefix."wpsp_attendance";
$class_table=$wpdb->prefix."wpsp_class";
$leave_table=$wpdb->prefix."wpsp_leavedays";
$get_classes=$wpdb->get_results("select * from $class_table");
$today=date('Y-m-d');
?>
c_sdate);
$edate=sanitize_text_field($get_class->c_edate);
if($sdate=='' || $sdate=='0000-00-00'){
$sdate=date('Y-m-d');
$date_warning= esc_html("*Please enter valid start date.", "wpschoolpress");
}
if($edate=='' || $edate=='0000-00-00' || $edate>$today){
$edate=date('Y-m-d');
}
$class_id = intval($get_class->cid);
//$att = $wpdb->get_row("SELECT * from $att_table where date='".esc_sql($today)."' and class_id='".esc_sql($class_id)."'");
$att = $wpdb->get_row($wpdb->prepare("SELECT * FROM $att_table WHERE date = %s and class_id=%d",$today,$class_id));
//$check_leave = $wpdb->get_row("SELECT * from $leave_table where leave_date='".esc_sql($today)."' and class_id='".esc_sql($class_id)."'");
$check_leave = $wpdb->get_row($wpdb->prepare("SELECT * FROM $leave_table WHERE leave_date = %s and class_id=%d",$today,$class_id));
if($att) {
if($att->absents=='Nil')
$tot_abs=0;
if($att->absents!='Nil')
$tot_abs=count(json_decode($att->absents));
if($tot_abs==0) {
$box_class="cbox-success";
}else {
$box_class="cbox-danger";
}
?>
c_name); ?>
0)?'N/A':'N/E'; ?>
">
">
0){ ?>
description);?>