public function actionCategories() { $model = new Categories(); $categories = Categories::find()->all(); $categories_roots = Categories::find()->roots()->all(); if ($model->load(Yii::$app->request->post())) { if (Yii::$app->user->can('createPost') && $model->addCategory()) { Yii::$app->getSession()->addFlash('success', '<b>Категория успешно добавлена!</b>'); } else { Yii::$app->getSession()->addFlash('error', '<b>Произошла ошибка. Запись не добавлена</b>'); } } return $this->render('categories', ['categories' => $categories, 'roots' => $categories_roots, 'model' => $model]); }
public function indexAction() { $categories = Categories::find(); echo "TESTING"; $this->logger->info('INDEX'); $this->view->categories = $categories; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Categories::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(['categoryId' => $this->categoryId, 'createdDate' => $this->createdDate, 'updatedDate' => $this->updatedDate]); $query->andFilterWhere(['like', 'categoryName', $this->categoryName])->andFilterWhere(['like', 'status', $this->status]); return $dataProvider; }
public function addCategory() { if ($this->validate()) { $category = new Categories(); $category->name = $this->name; $category->slug = $this->slug; if (Yii::$app->request->post('cats') == 0 && $category->makeRoot()) { return $category; } else { $parent = Categories::findOne(['id' => Yii::$app->request->post('cats')]); $category->makeRoot(); $category->appendTo($parent); return $category; } } return null; }
?> </td> <td id="productId<?php echo $model['Saleid']; ?> " contentEditable="true"><?php echo $model['productId']; ?> </td> <td contentEditable="true"><?php echo Html::activeDropDownList($model, 'Brand', ArrayHelper::map(Brandsmaster::find()->all(), 'brandName', 'brandName'), ['id' => 'brand' . $model['Saleid']]); ?> </td> <td contentEditable="true"><?php echo Html::activeDropDownList($model, 'categoryName', ArrayHelper::map(Categories::find()->all(), 'categoryName', 'categoryName'), ['id' => 'categoryId' . $model['Saleid']]); ?> </td> <td id="quntity<?php echo $model['Saleid']; ?> " contentEditable="true"><?php echo $model['Quantity']; ?> </td> <td id="uom<?php echo $model['Saleid']; ?> " contentEditable="true"><?php echo $model['uom']; ?>
public function actionCreatenew() { $model = new Products(); $model->scenario = 'productsupload'; if ($model->load(Yii::$app->request->post())) { $model->FileUpload = UploadedFile::getInstance($model, 'FileUpload'); $k = 0; if ($model->FileUpload) { $time = time(); $model->FileUpload->saveAs(realpath(Yii::$app->basePath) . '/csv/' . $time . '.' . $model->FileUpload->extension); $model->FileUpload = realpath(Yii::$app->basePath) . '/csv/' . $time . '.' . $model->FileUpload->extension; $handle = fopen($model->FileUpload, "r"); $i = 0; $m = 0; while (($fileop = fgetcsv($handle, 1000, ",")) !== false) { if ($i >= 1) { /* products external images $model->externalFiles = file_get_contents($fileop[5]); $find = ".'\'."; $ent = str_replace ("/\\/","/",$fileop[5]); $a = "\\"; $a = preg_replace('/\\\\/','/',$fileop[5]); $getstrpos = strripos($a,"/"); $imageName = substr($fileop[5],$getstrpos+1); $time2 = time(); $img = realpath(Yii::$app->basePath).'/web/uploads/products/'.$time2.$imageName; $fileimageUrl = 'uploads/products/'.$time2.$imageName; file_put_contents($img, file_get_contents($fileop[5])); */ /* $model->externalFiles = UploadedFile::getInstance(file_get_contents($fileop[5])); $time2 = time(); $model->externalFiles->saveAs(realpath(Yii::$app->basePath).'/csv/' .$time2. '.' . $model->FileUpload->extension); $model->externalFiles = realpath(Yii::$app->basePath).'/csv/' .$time2. '.' . $model->FileUpload->extension; */ date_default_timezone_set('Asia/Calcutta'); $model->createdDate = date("Y-m-d H:i:s"); $model->updatedDate = date("Y-m-d H:i:s"); try { $userInfo = Yii::$app->db->createCommand()->insert('products', ['productCode' => $fileop[0], 'productName' => $fileop[1], 'categoryId' => Categories::getCategoryId($fileop[2]), 'description' => $fileop[3], 'status' => 'Active', 'createdDate' => $model->createdDate, 'updatedDate' => $model->updatedDate])->execute(); if ($userInfo) { $m++; } } catch (\Exception $e) { $duplicaterrors = $e->errorInfo[0]; if ($duplicaterrors == 23000) { $k++; } } } $i++; } if ($m > 0) { Yii::$app->getSession()->setFlash('success', 'Your are successfully Uploaded ' . $m . ' Products'); } if ($k > 0) { Yii::$app->getSession()->setFlash('error', 'Your Trying to add ' . $k . ' duplicate records'); } return $this->redirect(['createnew']); } } else { return $this->render('createfile', ['model' => $model]); } }
echo Html::submitButton('Добавить', ['class' => 'btn btn-primary', 'name' => 'signup-button']); ?> </div> <?php ActiveForm::end(); ?> </div> </div> <h1 style="text-align:center;">Список категорий</h1> <?php $categories = Categories::find()->orderBy('tree,lft, rgt')->all(); $level = 0; foreach ($categories as $n => $category) { if ($category->depth == $level) { echo "</li> \n"; } else { if ($category->depth > $level) { echo "<ul>\n"; } else { echo "</li>\n"; for ($i = $level - $category->depth; $i; $i--) { echo "</ul>\n"; echo "</li>\n"; } } }
<div id="imaginary_container"> <div class="input-group stylish-input-group"> <?php echo $form->field($searchModel, 'productId')->textInput(array('placeholder' => 'Product code'))->label(false); ?> </div> </div> </div> <div class="col-md-3"> <?php echo $form->field($searchModel, 'Brand')->dropDownList(ArrayHelper::map(Brandsmaster::find()->all(), 'brandName', 'brandName'), ['prompt' => 'Select Brand'])->label(false); ?> </div> <div class="col-md-3"> <?php echo $form->field($searchModel, 'categoryName')->dropDownList(ArrayHelper::map(Categories::find()->all(), 'categoryName', 'categoryName'), ['prompt' => 'Select Category'])->label(false); ?> </div> <?php ActiveForm::end(); ?> </div> <div class="row"> <div class="col-md-12"> <div class="student-form"> </div>
?> ">Brand</label> <?php echo Html::activeDropDownList($model, 'Brand', ArrayHelper::map(Brandsmaster::find()->all(), 'brandName', 'brandName'), ['prompt' => 'Select Brand', 'class' => 'form-control', 'id' => 'vendorproducts-brand' . $cnt]); ?> </div> </div> <div class="col-md-4"> <div class="form-group"> <label class="control-label" for="vendorproducts-categoryname<?php echo $cnt; ?> ">Category Name</label> <?php echo Html::activeDropDownList($model, 'categoryName', ArrayHelper::map(Categories::find()->all(), 'categoryName', 'categoryName'), ['prompt' => 'Select categoryName', 'class' => 'form-control', 'id' => 'vendorproducts-categoryname' . $cnt]); ?> </div> </div> </div> <!--row 1 end--> <div class="row"> <!--row 2--> <div class="col-md-4"> <div class="form-group"> <label class="control-label" for="vendorproducts-quantity">Qty</label> <?php echo Html::activeInput('text', $model, 'Quantity[]', ['class' => 'form-control', 'id' => 'vendorproducts-quantity']); ?> </div>
public static function getCategoryId($catName) { $categoryName = Categories::find()->select('categoryId')->where(['categoryName' => $catName])->one(); return $categoryName['categoryId']; }
<?php echo $form->field($model, 'productId')->dropDownList(ArrayHelper::map(Products::find()->all(), 'productCode', 'productName'), ['prompt' => 'Select Product']); ?> </div> </div> <div class="col-md-4"> <div class="form-group"> <?php echo $form->field($model, 'Brand')->dropDownList(ArrayHelper::map(Brandsmaster::find()->all(), 'brandName', 'brandName'), ['prompt' => 'Select Brand']); ?> </div> </div> <div class="col-md-4"> <div class="form-group"> <?php echo $form->field($model, 'categoryName')->dropDownList(ArrayHelper::map(Categories::find()->all(), 'categoryName', 'categoryName'), ['prompt' => 'categoryName']); ?> </div> </div> </div> <!--row 1 end--> <div class="row"> <!--row 2--> <div class="col-md-4"> <div class="form-group"> <?php echo $form->field($model, 'Quantity')->textInput(['maxlength' => true]); ?> </div>
?> <div class="form-group col-lg-6 col-sm-12"> <?php echo $form->field($model, 'productCode')->textInput(['maxlength' => true]); ?> </div> <div class="form-group col-lg-6 col-sm-12"> <?php echo $form->field($model, 'productName')->textInput(['maxlength' => true]); ?> </div> <div class="form-group col-lg-6 col-sm-12"> <?php echo $form->field($model, 'categoryId')->dropDownList(ArrayHelper::map(Categories::find()->orderBy(['categoryName' => SORT_ASC])->all(), 'categoryId', 'categoryName'), ['prompt' => 'categoryName']); ?> </div> <div class="form-group col-lg-6 col-sm-12"> <?php echo $form->field($model, 'status')->dropDownList(['Active' => 'Active', 'In-active' => 'In-active'], ['prompt' => 'Status']); ?> </div> <!-- image file upload process --> <div class="form-group col-lg-6 col-sm-12"> <?php
/** * @return \yii\db\ActiveQuery */ public function getIdcategory() { return $this->hasOne(Categories::className(), ['idcategory' => 'idcategory']); }
/** * Finds the Categories model based on its primary key value. * If the model is not found, a 404 HTTP exception will be thrown. * @param integer $id * @return Categories the loaded model * @throws NotFoundHttpException if the model cannot be found */ protected function findModel($id) { if (($model = Categories::findOne($id)) !== null) { return $model; } else { throw new NotFoundHttpException('The requested page does not exist.'); } }
$form = ActiveForm::begin(); ?> <?php echo $form->field($model, 'dname')->textInput(['maxlength' => true]); ?> <?php echo $form->field($model, 'description')->textInput(['maxlength' => true]); ?> <?php echo $form->field($model, 'price')->textInput(); ?> <?php echo $form->field($model, 'idcategory')->dropDownList(ArrayHelper::map(Categories::find()->all(), 'idcategory', 'cname'), ['prompt' => 'Select category']); ?> <div class="form-group"> <?php echo Html::submitButton($model->isNewRecord ? 'Create' : 'Update', ['class' => $model->isNewRecord ? 'btn btn-success' : 'btn btn-primary']); ?> </div> <?php ActiveForm::end(); ?> </div>
/** * @return \yii\db\ActiveQuery */ public function getPIdC0() { return $this->hasOne(Categories::className(), ['categoryId' => 'categoryId']); }