/** * remember lang/shop state. */ public function remember(Request $request) { // toggle state if ($request->has('toggled')) { $request->session()->put('toggled', $request->toggled); } // toggle shop if ($request->has('shop')) { $shop = Shop::find($request->shop); $request->session()->put('shop', $shop->id); $request->session()->put('shop_url', $shop->url); } // toggle language if ($request->has('language')) { $request->session()->put('language', $request->language); } }
/** * Delete a shop. * * @param string $id * * @return Redirect */ public function destroy(Request $request, $id) { // delete $shop = Shop::find($id); $shop->delete(); // redirect $request->session()->flash('success', trans('shops.shop') . ' ' . trans('crud.deleted')); return redirect('admin/shops'); }
/** * Получить объект магазина * @return null | \app\models\Shop */ public function getShop() { return Shop::find(['union_id' => $this->getId()]); }
public function actionUpdate($id) { $model = Commodity::findOne($id); if (empty($model)) { throw new HttpException(404, '操作失败,商品不存在!'); } if ($this->user->rid != 1 && $model->uid != $this->user->id) { throw new HttpException(404, 'error'); } $oimg = $model->img; if ($model->load(Yii::$app->request->post())) { $img = UploadedFile::getInstance($model, 'img'); if (!is_null($img)) { $model->img = $img; $name = time() . '.' . $model->img->extension; $model->img->saveAs('uploads/images/' . $name); $model->img = '/uploads/images/' . $name; } else { $model->img = $oimg; } $platform = Platform::findOne($model->platform_id); $model->platform = $platform->name; $shop = Shop::findOne($model->shop_id); if (!empty($shop)) { $model->shop = $shop->shop_name; } $model->statu = Commodity::$_AUDIT_PEND; if ($model->save()) { $this->redirect('/commodity/index'); } else { var_dump($model->errors); } } $shops = array(); if ($this->user->rid == 3) { $shops = Shop::find()->where('uid = :uid', [':uid' => $this->user->id])->all(); } else { $shops = Shop::find()->all(); } $platforms = Platform::find()->all(); return $this->render('update', array('model' => $model, 'shops' => $shops, 'platforms' => $platforms)); }
public function actionIndex() { $dataProvider = new ActiveDataProvider(['query' => Shop::find()->orderBy('create_time desc')]); return $this->render('index', array('dataProvider' => $dataProvider)); }
function actionSpent() { if ($user = Yii::$app->getRequest()->getQueryParam('user')) { if (!$user) { return 'Доступ запрещн!'; } if (Yii::$app->getRequest()->getQueryParam('request')) { // return Yii::$app->getRequest()->getQueryParam('request'); $shop = Shop::find()->where(['name' => Yii::$app->getRequest()->getQueryParam('request')])->one(); if ($shop) { //return var_dump($shop->id); $shop_spent_sum = Bought::find()->select(['id, spent, shop_id, COUNT(*) as cnt, SUM(spent) as sum'])->where(['user_id' => 8, 'shop_id' => $shop->id])->andWhere('id > 28')->one(); $shop_last_spent = Bought::find()->where(['user_id' => 8, 'shop_id' => $shop->id])->andWhere('id > 28')->orderBy('id DESC')->limit(30)->all(); //return var_dump($shop_spent); return $this->renderPartial('spent_shop', ['spent_sum' => $shop_spent_sum, 'spents' => $shop_last_spent]); } $product = Products::find()->where(['name' => Yii::$app->getRequest()->getQueryParam('request')])->one(); if ($product) { //return var_dump($shop->id); $product_spent = Bought::find()->select(['id, spent, shop_id, COUNT(*) as cnt, SUM(spent) as sum'])->where(['user_id' => 8, 'product_id' => $product->id])->andWhere('id > 28')->one(); $product_last_spent = Bought::find()->where(['user_id' => 8, 'product_id' => $product->id])->andWhere('id > 28')->orderBy('id DESC')->limit(30)->all(); //return var_dump($product_last_spent); return $this->renderPartial('spent_product', ['spent' => $product_spent, 'spents' => $product_last_spent, 'product' => $product->name]); } $product = Products::find()->where(['name' => Yii::$app->getRequest()->getQueryParam('request')])->one(); if ($product) { //return var_dump($shop->id); $product_spent = Bought::find()->select(['id, spent, shop_id, COUNT(*) as cnt, SUM(spent) as sum'])->where(['user_id' => 8, 'product_id' => $product->id])->andWhere('id > 28')->one(); $product_last_spent = Bought::find()->where(['user_id' => 8, 'product_id' => $product->id])->andWhere('id > 28')->orderBy('id DESC')->limit(30)->all(); //return var_dump($product_last_spent); return $this->renderPartial('spent_product', ['spent' => $product_spent, 'spents' => $product_last_spent, 'product' => $product->name]); } $cat = Categories::find()->where(['name' => Yii::$app->getRequest()->getQueryParam('request')])->one(); if ($cat) { $sum = 0; $spent_prods = []; $prods = Products::find()->where(['cat_id' => $cat->id])->all(); //return var_dump($prods); foreach ($prods as $prod) { $cat_products_ids = implode(',', ArrayHelper::map(Products::find()->where(['cat_id' => $prod->cat->id])->all(), 'id', 'id')); $sum = Bought::find()->select('SUM(spent) as sum')->where('product_id IN (' . $cat_products_ids . ')')->andWhere('id > 28')->scalar(); $spent_prods[$prod->name] = Bought::find()->select('SUM(spent) as sum')->where(['user_id' => 8, 'product_id' => $prod->id])->andWhere('id > 28')->scalar(); } arsort($spent_prods); //return var_dump($spent_prods); return $this->renderPartial('spent_cat', ['sum' => $sum, 'spent_prods' => $spent_prods, 'cat' => $cat->name]); } } //return 'ok'; try { $spents = Bought::find()->select(['id, spent, product_id, COUNT(*) as cnt, SUM(spent) as sum'])->where(['user_id' => 8])->andWhere('id > 28')->groupBy('product_id')->orderBy('sum DESC')->limit(20)->all(); $shop_spents = Bought::find()->select(['id, spent, shop_id, COUNT(*) as cnt, SUM(spent) as sum'])->where(['user_id' => 8])->andWhere('id > 28')->groupBy('shop_id')->orderBy('sum DESC')->limit(20)->all(); $prod_boughts = []; $prods = Products::find()->select(['id, cat_id, COUNT(*) as cnt'])->groupBy('cat_id')->all(); //return var_dump($prods); foreach ($prods as $prod) { $cat_products_ids = implode(',', ArrayHelper::map(Products::find()->where(['cat_id' => $prod->cat->id])->all(), 'id', 'id')); $prod_boughts[$prod->cat->name] = Bought::find()->select('SUM(spent) as sum')->where('product_id IN (' . $cat_products_ids . ')')->andWhere('id > 28')->scalar(); } arsort($prod_boughts); //return var_dump($prod_boughts); } catch (\ErrorException $e) { return $e->getMessage(); } return $this->renderPartial('spent', ['spents' => $spents, 'shop_spents' => $shop_spents, 'prod_boughts' => $prod_boughts]); } }
<?php use yii\helpers\Html; use yii\bootstrap\ActiveForm; use app\models\Shop; $this->title = 'SHOP'; $this->params['breadcrumbs'][] = $this->title; $datas = array(); if ($_POST) { $datas = $_POST['ShopFormModel']; } /* * Itt van a lekérdezés !!!! * TODO */ $proba = Shop::find()->all(); //print_r($proba); foreach ($proba as $pro) { print_r($pro); echo "<hr>"; } ?> <a href='http://localhost/phpmyadmin/#PMAURL-1:db_structure.php?db=yii2basic&table=&server=1&target=&token=314f24ea1e8c1d29919c5038ebb6214e' target="_blank">localhost/phpmyadmin</a> <div class="site-contact"> <h1><?php echo Html::encode($this->title); ?> </h1> <div class = "row"> <div class = "col-lg-5">