a guest Aug 20th, 2019 67 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. public function productos_por_agotarse()
  2.     {
  3.         return $this->db->query("SELECT
  4.         A.nombre_almacen,
  5.         P.codigo_producto,
  6.         P.nombre_producto,
  7.         S.cantidad_Stock
  8.         FROM productos P
  9.         INNER JOIN stocks S ON P.id_producto = S.producto_id
  10.         INNER JOIN almacenes A ON S.almacen_id = A.id_almacen
  11.         WHERE S.cantidad_stock <= P.stockMinimo_producto");
  12.     }
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand