Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function productos_por_agotarse()
- {
- return $this->db->query("SELECT
- A.nombre_almacen,
- P.codigo_producto,
- P.nombre_producto,
- S.cantidad_Stock
- FROM productos P
- INNER JOIN stocks S ON P.id_producto = S.producto_id
- INNER JOIN almacenes A ON S.almacen_id = A.id_almacen
- WHERE S.cantidad_stock <= P.stockMinimo_producto");
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement