time: 2026-10-26 15:37:59 SELECT COUNT(*) as count FROM `tbl_token_blacklist` WHERE `token_jti` = '06cebc674153f6b3a32c95c110f3fc00'}
time: 2026-10-26 15:38:07 SELECT COUNT(*) as count FROM `tbl_token_blacklist` WHERE `token_jti` = 'f7f36c0ccaa4379bfb3fd83c61b256a7'}
time: 2026-10-26 15:38:07 SELECT * FROM tbl_ofz_main_category where is_active='1'}
time: 2026-10-26 15:38:10 SELECT COUNT(*) as count FROM `tbl_token_blacklist` WHERE `token_jti` = 'f7f36c0ccaa4379bfb3fd83c61b256a7'}
time: 2026-10-26 15:38:18 SELECT COUNT(*) as count FROM `tbl_token_blacklist` WHERE `token_jti` = '06cebc674153f6b3a32c95c110f3fc00'}
time: 2026-10-26 15:38:35 WITH RankedIOU AS (
            SELECT 
                iou.idtbl_IOU_list AS iou_id,
                iou.amount,
                iou.request_ref,
                iou.request_type,
                iou.created_date AS iou_created_date,
                iou.created_by AS iou_created_by,
                iou.is_active AS iou_active,
                acl.our_account_number,

                prj.project_name,
                loc.location_name,
                upr.tbl_user_payment_request_id AS payment_request_id,
                upr.requested_amount,
                upr.request_date,
                upr.receiver_name,
                upr.beneficiary_name,
                upr.account_number,
                upr.payment_ref,
                upr.payed_date,
                mcc.cost_category,

                ofz.idtbl_ofz_request AS ofz_request_id,
                ofz.beneficiary_name AS ofz_beneficiary,
                ofz.account_number AS ofz_account,
                ofz.request_date AS ofz_request_date,
                ofz.payment_ref AS ofz_payment_ref,
                ofz.payed_date AS ofz_payed_date,
                ofsb.sub_name,
                ofz.receiver_name as OfzReceiver,
                
                -- Project IOU Settlement Amounts (from tbl_user_request_list)
                CASE 
                    WHEN iou.request_type = 'constructions' THEN 
                        COALESCE((
                            SELECT SUM(url_items.actual_amount)
                            FROM tbl_user_request_list url_items
                            JOIN tbl_user_payment_request upr_items ON url_items.request_id = upr_items.tbl_user_payment_request_id
                            WHERE upr_items.req_ref_number = iou.request_ref
                              AND url_items.is_active = 1
                        ), 0)
                    ELSE 0
                END AS project_item_amount,
                
                CASE 
                    WHEN iou.request_type = 'constructions' THEN 
                        COALESCE((
                            SELECT SUM(url_items.item_disc)
                            FROM tbl_user_request_list url_items
                            JOIN tbl_user_payment_request upr_items ON url_items.request_id = upr_items.tbl_user_payment_request_id
                            WHERE upr_items.req_ref_number = iou.request_ref
                              AND url_items.is_active = 1
                        ), 0)
                    ELSE 0
                END AS project_item_discount,
                
                -- Office (OFZ) IOU Settlement Amounts
                CASE 
                    WHEN iou.request_type != 'constructions' THEN 
                        COALESCE((
                            SELECT SUM(orl_items.total_amout - orl_items.item_dis)
                            FROM tbl_ofz_request_list orl_items
                            JOIN tbl_ofz_request ofz_items ON orl_items.ofz_request_id = ofz_items.idtbl_ofz_request
                            WHERE ofz_items.req_ref_number = iou.request_ref
                        ), 0)
                    ELSE 0
                END AS ofz_item_net_amount,
                
                ROW_NUMBER() OVER (PARTITION BY iou.idtbl_IOU_list ORDER BY iou.created_date DESC) AS rn
            FROM 
                tbl_iou_list iou
            LEFT JOIN 
                tbl_user_payment_request upr ON iou.request_ref = upr.req_ref_number AND iou.request_type = 'constructions'
            LEFT JOIN 
                tbl_project_location loc ON upr.location_id = loc.idtbl_project_location
            LEFT JOIN 
                tbl_projects prj ON loc.project_id = prj.idtbl_projects
            LEFT JOIN 
                tbl_user_request_list url ON url.request_id = upr.tbl_user_payment_request_id
            LEFT JOIN 
                tbl_material_cost_category mcc ON mcc.idtbl_material_cost_category = url.cost_id
            LEFT JOIN 
                tbl_ofz_request ofz ON iou.request_ref = ofz.req_ref_number AND iou.request_type != 'constructions'
            LEFT JOIN 
                tbl_account_list acl ON acl.idtbl_account_list = iou.acc_id
            LEFT JOIN 
                tbl_ofz_request_list orl ON ofz.idtbl_ofz_request = orl.ofz_request_id
            LEFT JOIN 
                tbl_ofz_sub_category ofsb ON ofsb.idtbl_ofz_sub_category = orl.sub_category_id
        )
        SELECT *
        FROM RankedIOU
        WHERE 
            rn = 1 AND
            iou_created_date >= '2026-10-01' AND 
            iou_created_date < '2026-10-26' AND 
            iou_active = '1'
        
        ORDER BY iou_id;}
time: 2026-10-26 15:38:41 SELECT COUNT(*) as count FROM `tbl_token_blacklist` WHERE `token_jti` = 'f7f36c0ccaa4379bfb3fd83c61b256a7'}
time: 2026-10-26 15:38:59 WITH RankedIOU AS (
            SELECT 
                iou.idtbl_IOU_list AS iou_id,
                iou.amount,
                iou.request_ref,
                iou.request_type,
                iou.created_date AS iou_created_date,
                iou.created_by AS iou_created_by,
                iou.is_active AS iou_active,
                acl.our_account_number,

                prj.project_name,
                loc.location_name,
                upr.tbl_user_payment_request_id AS payment_request_id,
                upr.requested_amount,
                upr.request_date,
                upr.receiver_name,
                upr.beneficiary_name,
                upr.account_number,
                upr.payment_ref,
                upr.payed_date,
                mcc.cost_category,

                ofz.idtbl_ofz_request AS ofz_request_id,
                ofz.beneficiary_name AS ofz_beneficiary,
                ofz.account_number AS ofz_account,
                ofz.request_date AS ofz_request_date,
                ofz.payment_ref AS ofz_payment_ref,
                ofz.payed_date AS ofz_payed_date,
                ofsb.sub_name,
                ofz.receiver_name as OfzReceiver,
                
                -- Project IOU Settlement Amounts (from tbl_user_request_list)
                CASE 
                    WHEN iou.request_type = 'constructions' THEN 
                        COALESCE((
                            SELECT SUM(url_items.actual_amount)
                            FROM tbl_user_request_list url_items
                            JOIN tbl_user_payment_request upr_items ON url_items.request_id = upr_items.tbl_user_payment_request_id
                            WHERE upr_items.req_ref_number = iou.request_ref
                              AND url_items.is_active = 1
                        ), 0)
                    ELSE 0
                END AS project_item_amount,
                
                CASE 
                    WHEN iou.request_type = 'constructions' THEN 
                        COALESCE((
                            SELECT SUM(url_items.item_disc)
                            FROM tbl_user_request_list url_items
                            JOIN tbl_user_payment_request upr_items ON url_items.request_id = upr_items.tbl_user_payment_request_id
                            WHERE upr_items.req_ref_number = iou.request_ref
                              AND url_items.is_active = 1
                        ), 0)
                    ELSE 0
                END AS project_item_discount,
                
                -- Office (OFZ) IOU Settlement Amounts
                CASE 
                    WHEN iou.request_type != 'constructions' THEN 
                        COALESCE((
                            SELECT SUM(orl_items.total_amout - orl_items.item_dis)
                            FROM tbl_ofz_request_list orl_items
                            JOIN tbl_ofz_request ofz_items ON orl_items.ofz_request_id = ofz_items.idtbl_ofz_request
                            WHERE ofz_items.req_ref_number = iou.request_ref
                        ), 0)
                    ELSE 0
                END AS ofz_item_net_amount,
                
                ROW_NUMBER() OVER (PARTITION BY iou.idtbl_IOU_list ORDER BY iou.created_date DESC) AS rn
            FROM 
                tbl_iou_list iou
            LEFT JOIN 
                tbl_user_payment_request upr ON iou.request_ref = upr.req_ref_number AND iou.request_type = 'constructions'
            LEFT JOIN 
                tbl_project_location loc ON upr.location_id = loc.idtbl_project_location
            LEFT JOIN 
                tbl_projects prj ON loc.project_id = prj.idtbl_projects
            LEFT JOIN 
                tbl_user_request_list url ON url.request_id = upr.tbl_user_payment_request_id
            LEFT JOIN 
                tbl_material_cost_category mcc ON mcc.idtbl_material_cost_category = url.cost_id
            LEFT JOIN 
                tbl_ofz_request ofz ON iou.request_ref = ofz.req_ref_number AND iou.request_type != 'constructions'
            LEFT JOIN 
                tbl_account_list acl ON acl.idtbl_account_list = iou.acc_id
            LEFT JOIN 
                tbl_ofz_request_list orl ON ofz.idtbl_ofz_request = orl.ofz_request_id
            LEFT JOIN 
                tbl_ofz_sub_category ofsb ON ofsb.idtbl_ofz_sub_category = orl.sub_category_id
        )
        SELECT *
        FROM RankedIOU
        WHERE 
            rn = 1 AND
            iou_created_date >= '2026-05-01' AND 
            iou_created_date < '2026-10-31' AND 
            iou_active = '1'
        
        ORDER BY iou_id;}
time: 2026-10-26 15:39:15 WITH RankedIOU AS (
            SELECT 
                iou.idtbl_IOU_list AS iou_id,
                iou.amount,
                iou.request_ref,
                iou.request_type,
                iou.created_date AS iou_created_date,
                iou.created_by AS iou_created_by,
                iou.is_active AS iou_active,
                acl.our_account_number,

                prj.project_name,
                loc.location_name,
                upr.tbl_user_payment_request_id AS payment_request_id,
                upr.requested_amount,
                upr.request_date,
                upr.receiver_name,
                upr.beneficiary_name,
                upr.account_number,
                upr.payment_ref,
                upr.payed_date,
                mcc.cost_category,

                ofz.idtbl_ofz_request AS ofz_request_id,
                ofz.beneficiary_name AS ofz_beneficiary,
                ofz.account_number AS ofz_account,
                ofz.request_date AS ofz_request_date,
                ofz.payment_ref AS ofz_payment_ref,
                ofz.payed_date AS ofz_payed_date,
                ofsb.sub_name,
                ofz.receiver_name as OfzReceiver,
                
                -- Project IOU Settlement Amounts (from tbl_user_request_list)
                CASE 
                    WHEN iou.request_type = 'constructions' THEN 
                        COALESCE((
                            SELECT SUM(url_items.actual_amount)
                            FROM tbl_user_request_list url_items
                            JOIN tbl_user_payment_request upr_items ON url_items.request_id = upr_items.tbl_user_payment_request_id
                            WHERE upr_items.req_ref_number = iou.request_ref
                              AND url_items.is_active = 1
                        ), 0)
                    ELSE 0
                END AS project_item_amount,
                
                CASE 
                    WHEN iou.request_type = 'constructions' THEN 
                        COALESCE((
                            SELECT SUM(url_items.item_disc)
                            FROM tbl_user_request_list url_items
                            JOIN tbl_user_payment_request upr_items ON url_items.request_id = upr_items.tbl_user_payment_request_id
                            WHERE upr_items.req_ref_number = iou.request_ref
                              AND url_items.is_active = 1
                        ), 0)
                    ELSE 0
                END AS project_item_discount,
                
                -- Office (OFZ) IOU Settlement Amounts
                CASE 
                    WHEN iou.request_type != 'constructions' THEN 
                        COALESCE((
                            SELECT SUM(orl_items.total_amout - orl_items.item_dis)
                            FROM tbl_ofz_request_list orl_items
                            JOIN tbl_ofz_request ofz_items ON orl_items.ofz_request_id = ofz_items.idtbl_ofz_request
                            WHERE ofz_items.req_ref_number = iou.request_ref
                        ), 0)
                    ELSE 0
                END AS ofz_item_net_amount,
                
                ROW_NUMBER() OVER (PARTITION BY iou.idtbl_IOU_list ORDER BY iou.created_date DESC) AS rn
            FROM 
                tbl_iou_list iou
            LEFT JOIN 
                tbl_user_payment_request upr ON iou.request_ref = upr.req_ref_number AND iou.request_type = 'constructions'
            LEFT JOIN 
                tbl_project_location loc ON upr.location_id = loc.idtbl_project_location
            LEFT JOIN 
                tbl_projects prj ON loc.project_id = prj.idtbl_projects
            LEFT JOIN 
                tbl_user_request_list url ON url.request_id = upr.tbl_user_payment_request_id
            LEFT JOIN 
                tbl_material_cost_category mcc ON mcc.idtbl_material_cost_category = url.cost_id
            LEFT JOIN 
                tbl_ofz_request ofz ON iou.request_ref = ofz.req_ref_number AND iou.request_type != 'constructions'
            LEFT JOIN 
                tbl_account_list acl ON acl.idtbl_account_list = iou.acc_id
            LEFT JOIN 
                tbl_ofz_request_list orl ON ofz.idtbl_ofz_request = orl.ofz_request_id
            LEFT JOIN 
                tbl_ofz_sub_category ofsb ON ofsb.idtbl_ofz_sub_category = orl.sub_category_id
        )
        SELECT *
        FROM RankedIOU
        WHERE 
            rn = 1 AND
            iou_created_date >= '2026-10-01' AND 
            iou_created_date < '2026-10-26' AND 
            iou_active = '1'
        
        ORDER BY iou_id;}