Notice: Undefined index: clientId in C:\xampp\htdocs\reis_back_server\reismx\android\getOrderItemsForCertification.php on line 13

Notice: Undefined index: orderIndex in C:\xampp\htdocs\reis_back_server\reismx\android\getOrderItemsForCertification.php on line 14

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in C:\xampp\htdocs\reis_back_server\reismx\android\getOrderItemsForCertification.php on line 20
{"success":0,"message":"No clients found\nSELECT mopn.*, (select count(inventory.id) as total_count from material_orders_inventory_detail as moid inner join inventory on inventory.id = material_orders_inventory_detail_inventory_id inner join material_inputs_detail on material_inputs_detail.id = inventory_input_detail_id inner join products on products.id = input_detail_product_id where moid.client_id in (mopn.client_id) and inventory.client_id in (mopn.client_id) and material_inputs_detail.client_id in (mopn.client_id) and material_orders_inventory_detail_valid = true and moid.material_orders_index = mopn.material_orders_index and input_detail_product_id = mopn.material_orders_detail_product_id group by id_provider) as total_count, products.id_provider, products.id_client, products.description, concat(users._name, ' ', users._lastname) as full_name FROM material_orders_detail as mopn inner join products on products.id = material_orders_detail_product_id inner join sessions on sessions.id = material_orders_detail_session inner join users on users.id = sessions.session_id_user WHERE mopn.client_id = and mopn.material_orders_index = AND material_orders_detail_valid = true ORDER BY id;"}