{"iTotalDisplayRecords":"0","query":"\r\n    SELECT SQL_CALC_FOUND_ROWS `civil_project_bill_id`, `civil_project_bill_number`, `civil_project_bill_type`, `civil_project_bill_vendor`, `civil_project_bill_amount`, `civil_project_bill_paid`, `civil_project_bill_tds`, `civil_project_bill_tds_amount`, `civil_project_bill_advance_deduction`, `civil_project_bill_status`, `civil_project_bill_company`, `civil_project_bill_project`, `civil_project_bill_address`, `civil_project_bill_from_date`, `civil_project_bill_to_date`, `civil_project_bill_remark`, `civil_project_bill_vendor_invoice_number`, `civil_project_bill_vendor_invoice_date`, `civil_project_bill_tally_status`, `civil_project_bill_added_by`, `civil_project_bill_added_on`, `civil_project_bill_accepted_by`, `civil_project_bill_accepted_on`, `civil_project_bill_approved_by`, `civil_project_bill_approved_on`, `civil_project_bill_transfered_by`, `civil_project_bill_transfered_on`, `project_master_name`, `stock_company_master_name`, `company_logo`, `manpower_vendor_name`, `manpower_vendor_code`, `contract_vendor_name`, `contract_vendor_code`, `machine_vendor_name`, `machine_vendor_code`, `civil_project_bill_added_user_name`, `civil_project_bill_accepted_user_name`, `civil_project_bill_approved_user_name`, `civil_project_bill_transfered_user_name`\r\n    FROM civil_project_bill_view\r\n     WHERE (civil_project_bill_status = 'Approved' OR civil_project_bill_status = 'Accounted' )\r\n    ORDER BY civil_project_bill_added_on DESC\r\n    \r\n    ","aaData":[]}