Hello,
I can not solve the good qty in this request.
She always gives me double the value of qty.
The result is false when I put the following condition:
PHP Code:
$this->db->select_sum('qty_alert');
$this->db->join('stocks_alert', 'stocks_alert.id_product = stocks.id_product');
$this->db->having('qty < qty_alert');
Here is the complete request:
PHP Code:
$this->db->select('products.id, products.reference, products.label');
$this->db->select_sum('qty_alert');
$this->db->select("(SUM(CASE WHEN slug IN ('orders','variation','transfer','add') THEN stocks.qty ELSE 0 END) - SUM(CASE WHEN slug ='used' THEN stocks.qty ELSE 0 END)) as qty");
$this->db->from('products');
$this->db->join('stocks', 'stocks.id_product = products.id');
$this->db->join('stocks_alert', 'stocks_alert.id_product = stocks.id_product');
$this->db->group_start();
$this->db->like("products.reference", $_POST["search"]["value"]);
$this->db->or_like("products.label", $_POST["search"]["value"]);
$this->db->group_end();
$this->db->having('qty < qty_alert');
$this->db->group_by('products.id');
I also tried sub-query, but I can not do it.
Would anyone have an idea to put me on the track.
Thank you to all of you.
Excuse me for my english.