public function search($params) { $query = Store::find(); $dataProvider = new ActiveDataProvider(['query' => $query, 'sort' => ['defaultOrder' => ['id' => SORT_DESC]], 'pagination' => ['pageSize' => 20]]); // load the seach form data and validate if (!($this->load($params) && $this->validate())) { return $dataProvider; } $dateBegin = strtotime($this->date); $dateEnd = $dateBegin + 86400; // adjust the query by adding the filters $query->andFilterWhere(['like', 'name', $this->name])->andFilterWhere(['school_id' => $this->school_id])->andFilterWhere(['like', 'address', $this->address])->andFilterWhere(['status' => $this->status])->andFilterWhere(['>=', 'created_at', $this->date ? $dateBegin : null])->andFilterWhere(['<', 'created_at', $this->date ? $dateEnd : null]); return $dataProvider; }
public function actionIndex() { $sliders = slider::find()->all(); $cat = Category::find()->all(); $blogs = BLOG::find()->all(); $store = Store::find()->all(); $userModel = new SignupForm(); $storeModel = new Store(); $about_us = CMS::find()->where("cms_name = 'ABOUT US'")->one(); $contact_us = CMS::find()->where("cms_name = 'CONTACT US'")->one(); $pp = CMS::find()->where("cms_name = 'PRIVACY POLICY'")->one(); $tc = CMS::find()->where("cms_name = 'TERMS & CONDITIONS'")->one(); $testimonials = TESTIMONIALS::find()->all(); return $this->render('index', ['categories' => array_chunk($cat, 5), 'stores' => array_chunk($store, 5), 'userModel' => $userModel, 'storeModel' => $storeModel, 'about_us' => $about_us, 'contact_us' => $contact_us, 'testimonials' => $testimonials, 'pp' => $pp, 'tc' => $tc, 'blogs' => $blogs, 'sliders' => $sliders]); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $stores = []; if (\Yii::$app->user->identity->id != 1) { $stores = UserStore::find()->select('store_id')->where(['user_id' => Yii::$app->user->identity->id])->all(); $stores = ArrayHelper::getColumn($stores, 'store_id'); } $query = Store::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['store_id' => $this->store_id]); $query->andFilterWhere(['like', 'store_name', $this->store_name])->andFilterWhere(['like', 'store_desc', $this->store_desc])->andFilterWhere(['like', 'store_picture', $this->store_picture])->andFilterWhere(['in', 'store_id', $stores]); return $dataProvider; }
/** * 将商品克隆到新的店铺 * * @param array $id 源商品ID或一个ID列表 * @param string $to 目标店铺 * @return string */ public function actionClone(array $id, $to, $surplus = null) { if (!Store::find()->where(['id' => $to])->exists()) { echo "The parameter error.\n"; return static::EXIT_CODE_ERROR; } $query = Goods::find()->where(['id' => $id]); if (($count = $query->count()) > 0) { if (!static::confirm("Next we will clone {$count} goods, are you sure?")) { echo "Cancelled.\n"; return static::EXIT_CODE_NORMAL; } } else { echo "The goods count is 0.\n"; return static::EXIT_CODE_NORMAL; } $goodsList = $query->asArray()->all(); $time = time(); $sql = "INSERT INTO {{%goods}} (name, store_id, category_id, cover, price, price_original, cost, description, status, surplus, sales, unit, is_new, is_hot, is_promotion, created_at, updated_at) VALUES (:name, :store_id, :category_id, :cover, :price, :price_original, :cost, :description, :status, :surplus, :sales, :unit, :is_new, :is_hot, :is_promotion, :created_at, :updated_at)"; $sql2 = "INSERT INTO {{%goods_img}} (name, goods_id) VALUES (:name, :goods_id)"; $sql3 = "INSERT INTO {{%goods_surplus}} (goods_id, surplus_before, amount, surplus_after, remark, created_at, updated_at) VALUES (:goods_id, :surplus_before, :amount, :surplus_after, :remark, :created_at, :updated_at)"; $transaction = Yii::$app->db->beginTransaction(); try { foreach ($goodsList as $goods) { Yii::$app->db->createCommand($sql, [':name' => $goods['name'], ':store_id' => $to, ':category_id' => $goods['category_id'], ':cover' => $goods['cover'], ':price' => $goods['price'], ':price_original' => $goods['price_original'], ':cost' => $goods['cost'], ':description' => $goods['description'], ':status' => $goods['status'], ':surplus' => $surplus ?: $goods['surplus'], ':sales' => '0', ':unit' => $goods['unit'], ':is_new' => $goods['is_new'], ':is_hot' => $goods['is_hot'], ':is_promotion' => $goods['is_promotion'], ':created_at' => $time, ':updated_at' => $time])->execute(); $goodsId = Yii::$app->db->getLastInsertID(); $goodsImgList = GoodsImg::find()->where(['goods_id' => $goods['id']])->asArray()->all(); foreach ($goodsImgList as $goodsImg) { Yii::$app->db->createCommand($sql2, [':name' => $goodsImg['name'], ':goods_id' => $goodsId])->execute(); } Yii::$app->db->createCommand($sql3, [':goods_id' => $goodsId, ':surplus_before' => 0, ':amount' => $surplus ?: $goods['surplus'], ':surplus_after' => $surplus ?: $goods['surplus'], ':remark' => '初始化库存。', ':created_at' => $time, ':updated_at' => $time])->execute(); } $transaction->commit(); echo "Success!\n"; return static::EXIT_CODE_NORMAL; } catch (\Exception $e) { $transaction->rollBack(); echo $e->getMessage(); return static::EXIT_CODE_ERROR; } }
/** * Creates a new Product model. * If creation is successful, the browser will be redirected to the 'view' page. * @return mixed */ public function actionCreate() { // echo Yii::getAlias('@common'); exit; $model = new Product(); $modelProdMeta = new ProductMeta(); $stores = []; if (\Yii::$app->user->identity->id == 1) { $stores = \common\models\UserStore::find()->select('store_id')->where(['user_id' => Yii::$app->user->identity->id])->all(); $stores = \yii\helpers\ArrayHelper::getColumn($stores, 'store_id'); $storeList = \common\models\Store::find()->where(['IN', 'store_id', $stores])->all(); } else { $storeList = \common\models\Store::find()->all(); } if ($postData = Yii::$app->request->post()) { if ($model->load($postData) && $model->save()) { $prod_id = $model->prod_id; foreach ($model->cat_id as $cat) { $catModel = new ProdCat(); $catModel->cat_id = $cat; $catModel->prod_id = $prod_id; $catModel->save(); } $file = UploadedFile::getInstances($model, 'images'); $model->file = $file[0]; $image_path = Yii::getAlias('@frontend') . '/web/uploads/product/' . $model->file->baseName . '_' . $prod_id . '.' . $model->file->extension; $model->file->saveAs($image_path); $this->updateProductMeta($id, 'prod_img', $model->file->baseName . '_' . $prod_id . '.' . $model->file->extension); foreach ($postData['PMeta'] as $key => $meta_value) { $this->updateProductMeta($id, $key, $meta_value); } return $this->redirect(['view', 'id' => $model->prod_id]); } } else { return $this->render('create', ['model' => $model, 'modelProdMeta' => $modelProdMeta, 'storeList' => $storeList]); } }