SELECT * FROM `emp_sal_det_month` WHERE MONTH=1 AND YEAR=2023 AND emp_id=10;
SELECT * FROM `emp_sal_det_month` WHERE MONTH=1 AND YEAR=2023 AND emp_id=181;
SELECT * FROM emp_reg WHERE NAME LIKE "%solo%";



SELECT * FROM `sch_att_batch_conf` WHERE is_ok=1;
UPDATE `sch_att_batch_conf` SET is_ok=0;
SELECT * FROM `sch_att_batch_conf` WHERE batch=81;



UPDATE `h_sql_att` SET logid=0;
UPDATE `sch_bio_att` SET logid=0;
UPDATE `leave_category_det` SET balance=3 WHERE leave_id=6;

SELECT a.`student_name`,a.id,c.* FROM  `sch_student_detail` a,`sch_stud_class_details` b,`sch_stud_fee_rcpt` c 
WHERE a.id=c.`stud_id` AND b.`stud_id`=c.stud_id AND  a.id=b.`stud_id` AND class_id=2 AND b.period_id=9 ORDER BY a.id;
SELECT * FROM sch_stud_fee_rcpt WHERE stud_id=392;

SELECT * FROM `sch_stud_class_details` WHERE stud_id=387;
SELECT * FROM `sch_stud_fee_details` WHERE stud_id=387;
SELECT * FROM sch_student_detail a,sch_stud_fee_details b WHERE a.id=b.stud_id AND class_id=2 AND b.period_id=7 AND ent_date>'2024-01-23' AND is_paid=0 AND paid_date='0000-00-00' GROUP BY a.id;
SELECT * FROM sch_student_detail WHERE id=406;
SELECT * FROM sch_student_detail a,sch_stud_fee_details b,sch_stud_class_details c 
WHERE a.id=c.`stud_id` AND c.`class_id`=2 AND c.`period_id`=9 AND c.`is_active`=1 AND b.`stud_id`=c.`stud_id` AND  a.id=b.stud_id AND b.class_id=2 AND b.period_id=7 AND ent_date>'2024-01-23' AND is_paid=1 GROUP BY a.id ;

UPDATE sch_student_detail a,sch_stud_fee_details b SET b.month='8',b.`year`='2024',b.period_id=9 WHERE a.id=b.stud_id AND class_id=2 AND b.period_id=7 AND ent_date>'2024-01-23' AND is_paid=0 AND paid_date='0000-00-00'