Example #1
0
 public function updateInventario()
 {
     $sum = 0;
     $entradas = Entrada::findAll(['producto_IdProducto' => $this->producto_idProducto]);
     foreach ($entradas as $e) {
         $sum += $e->cantidad;
     }
     $inv = Inventario::findOne(['producto_IdProducto' => $this->producto_idProducto]);
     if ($inv == null) {
         $inv = new Inventario();
         $inv->producto_idProducto = $this->producto_idProducto;
     }
     $inv->stock = $sum;
     $inv->save();
 }
Example #2
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Inventario::find();
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     $this->load($params);
     if (!$this->validate()) {
         // uncomment the following line if you do not want to return any records when validation fails
         // $query->where('0=1');
         return $dataProvider;
     }
     $query->andFilterWhere(['idInventario' => $this->idInventario, 'producto_idProducto' => $this->producto_idProducto, 'stock' => $this->stock]);
     return $dataProvider;
 }
Example #3
0
 /**
  * Creates data provider instance with search query applied
  *
  * @param array $params
  *
  * @return ActiveDataProvider
  */
 public function search($params)
 {
     $query = Inventario::find();
     $dataProvider = new ActiveDataProvider(['query' => $query]);
     $this->load($params);
     if (!$this->validate()) {
         // uncomment the following line if you do not want to return any records when validation fails
         // $query->where('0=1');
         return $dataProvider;
     }
     $query->andFilterWhere(['id' => $this->id, 'cantidad' => $this->cantidad, 'articulos_aid' => $this->articulos_aid, 'estatus_did' => $this->estatus_did, 'fechacreacion_ft' => $this->fechacreacion_ft]);
     return $dataProvider;
 }
Example #4
0
 public function actionItems($idPedido)
 {
     $contenido_pedido = Carropedido::findAll(['pedido_idPedido' => $idPedido]);
     $id_productos = array_map(function ($o) {
         return $o->producto_idProducto;
     }, $contenido_pedido);
     $productos = Producto::find()->where(['NOT IN', 'idProducto', $id_productos])->all();
     $items = array_map(function ($u) {
         $temp = Inventario::findOne(['producto_IdProducto' => $u->idProducto]);
         if (empty($temp)) {
             $existencias = 0;
         } else {
             $existencias = $temp->stock;
         }
         $row['idProducto'] = $u->idProducto;
         $row['codigo'] = $u->codigo;
         $row['nombre'] = $u->producto;
         $row['precio'] = $u->precio;
         $row['embalaje'] = $u->embalajeIdEmbalaje->nombre;
         $row['existencias'] = $existencias;
         return $row;
     }, $productos);
     return Json::encode($items);
 }
 /**
  * Finds the Inventario model based on its primary key value.
  * If the model is not found, a 404 HTTP exception will be thrown.
  * @param string $id
  * @return Inventario the loaded model
  * @throws NotFoundHttpException if the model cannot be found
  */
 protected function findModel($id)
 {
     if (($model = Inventario::findOne($id)) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }
Example #6
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getInventarios()
 {
     return $this->hasMany(Inventario::className(), ['estatus_did' => 'id']);
 }
Example #7
0
 /**
  * Finds the Inventario model based on its primary key value.
  * If the model is not found, a 404 HTTP exception will be thrown.
  * @param integer $idInventario
  * @param integer $producto_idProducto
  * @return Inventario the loaded model
  * @throws NotFoundHttpException if the model cannot be found
  */
 protected function findModel($idInventario, $producto_idProducto)
 {
     if (($model = Inventario::findOne(['idInventario' => $idInventario, 'producto_idProducto' => $producto_idProducto])) !== null) {
         return $model;
     } else {
         throw new NotFoundHttpException('The requested page does not exist.');
     }
 }
Example #8
0
 /**
  * @return \yii\db\ActiveQuery
  */
 public function getInventarios()
 {
     return $this->hasMany(Inventario::className(), ['articulos_aid' => 'id']);
 }