Notice: Undefined index: b_id in C:\Apache24\htdocs\cwcms\reports_landscape\pending_bill_quantity_report.php on line 111
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in C:\Apache24\htdocs\cwcms\reports_landscape\pending_bill_quantity_report.php on line 113
Notice: Trying to access array offset on value of type null in C:\Apache24\htdocs\cwcms\reports_landscape\pending_bill_quantity_report.php on line 115
SELECT id, Ref,Customer,Kva,Amount, if(adv_tag = 0, 'Advance',if(brd_tag = 0, 'Before Delivery',if(afd_tag = 0, 'After Delivery',if(afc_tag = 0, 'After Commissioning','Security Money')))) as Description, if(adv_tag = 0, REPLACE((substr(ADV,5,15)),'%', ''),if(brd_tag = 0, REPLACE((substr(BRD,5,15)),'%', ''),if(afd_tag = 0, REPLACE((substr(AFD,5,15)),'%', ''), if(afc_tag = 0, REPLACE((substr(AFC,5,15)),'%', ''),REPLACE((substr(SCM,5,15)),'%', '') )))) as ratio, do_code, bill_type, DATE_FORMAT((SELECT exp_date FROM tbl_generator_bill_update u WHERE u.payment_term_id = view_generator_creating_bill_all.id and u.bill_type = view_generator_creating_bill_all.bill_type order by id desc limit 0, 1), '%b %d, %y') as exp_date, (SELECT updates FROM tbl_generator_bill_update u WHERE u.payment_term_id = view_generator_creating_bill_all.id and u.bill_type = view_generator_creating_bill_all.bill_type order by id desc limit 0, 1) as updates FROM view_generator_creating_bill_all WHERE adv_tag = 0 or (brd_tag = 0 and bds != 0) or afd_tag = 0 or afc_tag = 0 or scm_tag = 0 order by adv_tag asc, brd_tag asc, afd_tag asc, rnb_tag asc, afc_tag asc, scm_tag asc, sales_date desc; Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in C:\Apache24\htdocs\cwcms\reports_landscape\pending_bill_quantity_report.php on line 152
Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in C:\Apache24\htdocs\cwcms\reports_landscape\pending_bill_quantity_report.php on line 155
Notice: Trying to access array offset on value of type null in C:\Apache24\htdocs\cwcms\reports_landscape\pending_bill_quantity_report.php on line 257
