SELECT
frm.feesrec_no,
frm.feesrec_checkno,
frm.feesrec_date,
frm.feesrec_cash,
frm.feesrec_no,
frm.feesrec_refno,
frm.feesrec_total,
frm.feesrec_bankname,
frm.feesrec_id,
sm.student_id,
frm.transaction_id,
frm.payment_mode,
sd.student_curdiv,
CONCAT(sm.student_firstname,' ',sm.student_lastname,' ',sm.student_surname) AS student_name,
sec.section_name,
sd.student_grno,
(select standard_name from sms_standard std where std.standard_id = sd.student_curstd) As standard_name,
um.user_name
FROM
sms_feesrecmaster frm,
sms_studentmaster sm,
sms_sectionmaster sec,
sms_studentdetail sd,
sms_usermaster um
WHERE
sm.student_id=sd.student_id AND
frm.student_id = sm.student_id AND
frm.student_id = sd.student_id and
frm.section_id = sec.section_id AND
frm.section_id = sd.section_id AND
frm.login_id = um.user_id AND
sd.year_id=frm.year_id and
frm.school_id = '1' AND
sec.school_id = '1' AND
frm.year_id = '1' AND frm.feesrec_date >= '2026-07-28' AND frm.feesrec_date <= '2026-07-29' AND frm.feesrec_cash = 'No' AND frm.transaction_id != ' ' AND frm.payment_mode = 'SWAPCARD' AND frm.login_id = 2 order by frm.feesrec_no ASC
| Daily Fees Collection - Summary Report |
|
Section:
|
|
Div:
|
2026-2027 |
C:cash, B:cheque, O:Online
|
|
|
| Sr No |
Receipt No |
Section |
Standard |
Division |
GR No |
Student Name |
Username |
Amount |
| Receipt Date:
28-07-2026 |
| 1 |
7 |
PRIMARY SECTION |
1 |
A |
4666 |
ADITYAKUMAR SANTOSHKUMAR |
dharmesh |
1800(S) |
| Cash Received
| 0
|
| Cheque Received
| 0
|
| Online Received
| 0
|
| Phonepe Received
| 0
|
| Swapcard Received
| 1800
|
| Total Received Amount
| 1800
|
| FINAL TOTAL
| 1,800
|
|
|
| Receiver |
Cash |
Cheque |
Online |
Phonepe |
Swapcard |
Total |
| dharmesh |
0 |
0 |
0 |
0 |
1,800 |
1,800 Rs |
|
