Notice: Undefined index: clientId in C:\xampp\htdocs\reis_back_server\reisharman\android_old\backup\tradebl\getInvoiceItems.php on line 15

Notice: Undefined index: invoiceId in C:\xampp\htdocs\reis_back_server\reisharman\android_old\backup\tradebl\getInvoiceItems.php on line 16

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in C:\xampp\htdocs\reis_back_server\reisharman\android_old\backup\tradebl\getInvoiceItems.php on line 63
{"success":0,"message":"No clients found\nSELECT material_inputs_detail.id, material_inputs_detail.client_id, client_short_name, material_inputs_detail.material_input_index, products.id_provider, input_detail_product_id, products.description, input_detail_quantity, input_detail_bill_id, input_detail_motion_id, input_detail_date, input_detail_serial, input_detail_pallet_id, input_detail_pallet_serial_id, pallet_size, input_detail_batch, input_detail_external_serial, input_detail_location, concat(users._name, ' ', users._lastname) as full_name from material_inputs_detail INNER JOIN clients ON clients.id = material_inputs_detail.client_id inner join products on products.id = input_detail_product_id inner join pallets on pallets.id = input_detail_pallet_serial_id inner join sessions on sessions.id = material_inputs_detail.session_id inner join users on users.id = sessions.session_id_user left join material_providers on input_detail_material_provider_id = material_providers.id where products.client_id in () and material_inputs_detail.client_id in () and pallets.client_id in () and material_inputs_detail.input_detail_valid in (1) and material_inputs_detail.material_input_index in () order by input_detail_pallet_id "}