SELECT ifnull(SUM(IF(plos.`IsSampleCollected`='R',0,plos.`PCCInvoiceAmt`)),0) FROM f_ledgertransaction lt   
 INNER JOIN patient_labinvestigation_opd_share plos on plos.`LedgerTransactionID`=lt.`LedgerTransactionID` 
 inner join  f_panel_master pnl on lt.Panel_ID=pnl.Panel_ID 
 WHERE pnl.InvoiceTo='193' and ifnull(plos.InvoiceNo,'')=''     
 AND plos.DATE<='2025-12-16 23:59:59'