Notice: Undefined index: args in C:\xampp\htdocs\reismx\android\getInventoryBy.php on line 13

Notice: Undefined index: by in C:\xampp\htdocs\reismx\android\getInventoryBy.php on line 14

Notice: Undefined index: fristDate in C:\xampp\htdocs\reismx\android\getInventoryBy.php on line 15

Notice: Undefined index: lastDate in C:\xampp\htdocs\reismx\android\getInventoryBy.php on line 16

Notice: Undefined index: client_id in C:\xampp\htdocs\reismx\android\getInventoryBy.php on line 17

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in C:\xampp\htdocs\reismx\android\getInventoryBy.php on line 110
{"success":0,"message":"No product found\nSELECT inventory.id, inventory.client_id, products.id_provider, products.id_client, products.description, inventory_quantity, inventory_location, inventory_input_detail_id, material_inputs_detail.material_input_index, input_detail_bill_id, input_detail_serial, input_detail_pallet_id, inventory_external_serial, inventory_batch, inventory_warehouse_id, warehouse.wh_name, DATE_FORMAT(input_detail_date,'%Y-%m-%d %T') AS date FROM inventory INNER JOIN material_inputs_detail ON material_inputs_detail.id = inventory.inventory_input_detail_id INNER JOIN products ON products.id = material_inputs_detail.input_detail_product_id INNER JOIN warehouse ON warehouse.id = inventory_warehouse_id WHERE inventory.client_id in () AND material_inputs_detail.client_id in () AND products.client_id in () AND NOT material_inputs_detail.material_input_index = 0 AND inventory_valid is true AND input_detail_valid is true AND inventory.inventory_location NOT IN ('REIS', 'CUARENTENA') AND material_inputs_detail.input_detail_date BETWEEN '' AND now() ORDER BY material_inputs_detail.input_detail_serial ASC, material_inputs_detail.id ASC"}