/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Warehouse::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(['warehouse_id' => $this->warehouse_id, 'restaurant_id' => $this->restaurant_id, 'product_id' => $this->product_id, 'price' => $this->price]); $query->andFilterWhere(['like', 'description', $this->description]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Warehouse::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]); $query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['like', 'location', $this->location]); return $dataProvider; }
public function upload() { if ($this->validate()) { $this->xmlFile->saveAs('uploads/' . $this->xmlFile->baseName . '.' . $this->xmlFile->extension); $xml = simplexml_load_file('uploads/' . $this->xmlFile->baseName . '.' . $this->xmlFile->extension); foreach ($xml->product as $product) { $warehouse = new Warehouse(); $warehouse->warehouse_id = null; $restaurant = Restaurant::find()->where(['name' => $product->restaurant_name])->one(); $products = Product::find()->where(['name' => $product->product_name])->one(); if (isset($products) && isset($restaurant)) { $warehouse->restaurant_id = $restaurant->restaurant_id; $warehouse->product_id = $products->product_id; $warehouse->description = $product->description; $warehouse->price = $product->price; $warehouse->save(); } } unlink('uploads/' . $this->xmlFile->baseName . '.' . $this->xmlFile->extension); return true; } else { return false; } }
public function exportRestaurantMenuToCsv($id) { $restaurantName = Restaurant::findOne(['restaurant_id' => $id])->name; Yii::$app->params['uploadPath'] = Yii::$app->basePath . '/web/upload/'; $string = "name, description, price \n"; $product = null; foreach (Warehouse::find()->where(['restaurant_id' => $id])->batch(1) as $warehouse) { try { $product = Product::findOne(['product_id' => $warehouse[0]->product_id]); $string .= '"' . $product->name . '","' . $product->description . '","' . $warehouse[0]->price . '"'; $string .= "\n"; } catch (Exception $e) { } } $path = $this->saveStringToCsvFile($string, $restaurantName); $this->giveUserFile($path); }
/** * Finds the Warehouse model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param string $id * @return Warehouse the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { $model = new Warehouse(); $model->scenario = Warehouse::SCENARIO_READ; if (($model = Warehouse::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
</div> <div class="col-sm-8"> <?php echo $form->field($model, 'name')->textInput(['maxlength' => true])->hint('Name of the item'); ?> </div> <div class="clearfix"></div> <div class="col-sm-4"> <?php echo $form->field($model, 'category_id')->dropDownList(ArrayHelper::map(ProductCategories::find()->all(), 'id', 'name'))->hint('Category of the item'); ?> </div> <div class="col-sm-4"> <?php echo $form->field($model, 'warehouse_id')->dropDownList(ArrayHelper::map(Warehouse::find()->all(), 'id', 'name'))->hint('Warehouse Location'); ?> </div> <div class="col-sm-4"> <?php echo $form->field($model, 'status')->dropDownList(HelperComponents::getStatus())->hint('Serve as a tag if the product is available for purchase'); ?> </div> <div class="clearfix"></div> <div class="col-sm-3"> <?php echo $form->field($model, 'buy_price', ['addon' => ['prepend' => ['content' => '₱'], 'append' => ['content' => '.00']]])->textInput(['class' => 'text-align-right'])->hint('Buy price per item'); ?> </div> <div class="col-sm-3"> <?php
/** * Finds the Warehouse model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Warehouse the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Warehouse::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
<div class="col-sm-6"> <div class="form-group"> <label for="category_select" class="control-label">Select Category</label> <div class=""> <?php echo Html::dropDownList('category_select', isset($posted_data['category_select']) ? $posted_data['category_select'] : null, ['0' => 'All'] + ArrayHelper::map(ProductCategories::find()->all(), 'id', 'name'), ['class' => 'form-control', 'id' => 'category_select']); ?> </div> </div> </div> <div class="col-sm-6"> <div class="form-group"> <label for="warehouse_select" class="control-label">Select Warehouse</label> <div class=""> <?php echo Html::dropDownList('warehouse_select', isset($posted_data['warehouse_select']) ? $posted_data['warehouse_select'] : null, ['0' => 'All'] + ArrayHelper::map(Warehouse::find()->all(), 'id', 'name'), ['class' => 'form-control', 'id' => 'warehouse_select']); ?> </div> </div> </div> <div class="clearfix"></div> <div class="col-sm-6"> <div class="form-group"> <label for="products_select" class="control-label">Select Products</label> <div class=""> <?php echo Select2::widget(['name' => 'products_select', 'value' => isset($posted_data['products_select']) ? $posted_data['products_select'] : 0, 'data' => ['0' => 'All'] + ArrayHelper::map(Products::find()->all(), 'id', 'name'), 'options' => ['placeholder' => 'Select Products ...', 'class' => 'form-control', 'id' => 'products_select']]); ?> </div> </div>
private function getAllWarehouse() { $warehouse = Warehouse::find()->where(['uid' => Yii::$app->user->id])->all(); $warehouse_array = array(); foreach ($warehouse as $item) { $name = $item->getAttribute('name'); $warehouse_array[$name] = $name; } return $warehouse_array; }
public function getWarehouse() { return $this->hasMany(Warehouse::className(), ['product_id' => 'product_id']); }
protected function findModel($id) { Yii::$app->response->format = Response::FORMAT_JSON; if (($model = Warehouse::find()->where(['warehouse_id' => $id])->one()) !== null) { return $model; } else { echo json_encode(array('status' => 0, 'error_code' => Codes::$BAD_REQUEST, 'message' => StatusCodeMessage::$BAD_REQUEST), JSON_PRETTY_PRINT); exit; // throw new NotFoundHttpException('The requested page does not exist.'); } }