-- Direct SQL Insert for Loan Receipt
-- This SQL can be run directly in MySQL to insert a receipt entry
-- Modify the values below as needed

INSERT INTO loan_receipt (
    loan_id, com_id, rec_no, rec_date, cust_id,
    cust_name, cust_mobile, num_dues, due_amnt,
    paid_amnt, paid_dues, balance_dues, pending_dues,
    next_date, remark, agent
) VALUES (
    'DL2025001',
    8,
    '001',
    '2025-12-04',
    534687676476,
    'Pavithra',
    '5346876764',
    60,
    92.00,
    2208.00,
    24,
    60,
    24,
    '2025-12-05',
    'hvhjfgh',
    'Raja'
);