/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = MGoods::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); if (!($this->load($params) && $this->validate())) { return $dataProvider; } $query->andFilterWhere(['goods_id' => $this->goods_id, 'price' => $this->price, 'price_old' => $this->price_old, 'quantity' => $this->quantity, 'office_ctrl' => $this->office_ctrl, 'package_ctrl' => $this->package_ctrl, 'detail_ctrl' => $this->detail_ctrl, 'pics_ctrl' => $this->pics_ctrl, 'goods_kind' => $this->goods_kind]); $query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'descript', $this->descript])->andFilterWhere(['like', 'price_hint', $this->price_hint])->andFilterWhere(['like', 'price_old_hint', $this->price_old_hint])->andFilterWhere(['like', 'detail', $this->detail])->andFilterWhere(['like', 'list_img_url', $this->list_img_url])->andFilterWhere(['like', 'body_img_url', $this->body_img_url]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params, $pub_userid, $goods_kind) { //$query = MGoods::find(); if ($pub_userid == -1) { if ($goods_kind == 0) { //全部 $query = MGoods::find()->where(['status' => 1]); } else { $query = MGoods::find()->where(['status' => 1, 'goods_kind' => $goods_kind]); } } else { $user = User::findOne(['id' => $pub_userid]); if ($user->role == 1) { if ($goods_kind == 0) { //全部 $query = MGoods::find(); } else { $query = MGoods::find()->where(['pub_userid' => $pub_userid, 'goods_kind' => $goods_kind]); } } else { if ($goods_kind == 0) { //全部 $query = MGoods::find()->where(['pub_userid' => $pub_userid]); } else { $query = MGoods::find()->where(["pub_userid" => $pub_userid, 'goods_kind' => $goods_kind]); } } } $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(['goods_id' => $this->goods_id, 'goods_kind' => $this->goods_kind, 'price' => $this->price, 'price_old' => $this->price_old, 'quantity' => $this->quantity, 'status' => $this->status, 'create_time' => $this->create_time, 'update_time' => $this->update_time]); $query->andFilterWhere(['like', 'title', $this->title])->andFilterWhere(['like', 'descript', $this->descript])->andFilterWhere(['like', 'price_hint', $this->price_hint])->andFilterWhere(['like', 'detail', $this->detail])->andFilterWhere(['like', 'list_img_url', $this->list_img_url])->andFilterWhere(['like', 'body_img_url', $this->body_img_url]); return $dataProvider; }
public function actionGoodslist() { $this->layout = false; $gh_id = U::getSessionParam('gh_id'); $openid = U::getSessionParam('openid'); $goods_kind = $_GET['goods_kind']; $goods = MGoods::find()->where(['goods_kind' => $goods_kind])->all(); return $this->render('goodslist', ['gh_id' => $gh_id, 'openid' => $openid, 'goods' => $goods, 'goods_kind' => $goods_kind]); }
public function actionIndex() { $goods = MGoods::find()->where(['status' => 1])->orderBy(['create_time' => DESC])->limit(24)->all(); $about = MAbout::find()->one(); return $this->render('index', ['goods' => $goods, 'about' => $about]); }
]; //} $menuItems[] = [ 'label' => '退出 (' . Yii::$app->user->identity->username . ')', 'url' => ['/site/logout'], 'linkOptions' => ['data-method' => 'post'] ]; } */ foreach ($goodscat as $gc) { if ($gc->value == 0) { /*全部*/ $goodsCnt = MGoods::find()->where(['status' => 1])->count(); } else { $goodsCnt = MGoods::find()->where(['status' => 1, 'goods_kind' => $gc->value])->count(); } if ($goodsCnt == 0) { $menuItems[] = ['label' => '<span> </span> ' . $gc->cat, 'url' => ['/site/client-goods-list', 'pub_userid' => Yii::$app->user->isGuest ? -1 : Yii::$app->user->identity->id, 'goods_kind' => $gc->value], 'linkOptions' => ['data-method' => 'post']]; } else { $menuItems[] = ['label' => '<span class="badge">' . $goodsCnt . '</span> ' . $gc->cat, 'url' => ['/site/client-goods-list', 'pub_userid' => Yii::$app->user->isGuest ? -1 : Yii::$app->user->identity->id, 'goods_kind' => $gc->value], 'linkOptions' => ['data-method' => 'post']]; } } echo Nav::widget(['options' => ['class' => 'navbar-nav navbar-right'], 'encodeLabels' => false, 'items' => [['label' => '<form class="navbar-form navbar-left" role="search"><div class="input-group"><input type="text" class="form-control" placeholder="Search"><span class="input-group-btn"><button class="btn btn-default" type="button"><span class="fa fa-search"></span></button></span></div></form>'], ['label' => '首页', 'url' => ['/site/index']], ['label' => '关于我们', 'items' => [['label' => '<i class="fa fa-globe"></i> 公司简介', 'url' => ['/site/about'], 'linkOptions' => ['data-method' => 'post']], ['label' => '<i class="fa fa-star"></i> 招才纳士', 'url' => ['#'], 'linkOptions' => ['data-method' => 'post']]]], $isAdmin ? "" : ['label' => '商品列表', 'items' => $menuItems], $isAdmin ? "" : ['label' => '新闻动态', 'items' => [['label' => '<i class="fa fa-chevron-right"></i> 行业新闻', 'url' => ['/site/client-news-list', 'cat' => 1], 'linkOptions' => ['data-method' => 'post']], ['label' => '<i class="fa fa-chevron-right"></i> 公司动态', 'url' => ['/site/client-news-list', 'cat' => 2], 'linkOptions' => ['data-method' => 'post']]]], ['label' => '会员', 'visible' => $isMember, 'items' => [['label' => '<i class="fa fa-tags"></i> 商品管理', 'url' => ['/goods/index', 'pub_userid' => Yii::$app->user->identity->id, 'goods_kind' => 0], 'linkOptions' => ['data-method' => 'post']], ['label' => '<i class="fa fa-list"></i> 我的订单', 'url' => ['/order/index', 'userid' => Yii::$app->user->identity->id], 'linkOptions' => ['data-method' => 'post']], '<li class="divider"></li>', ['label' => '<i class="fa fa-user"></i> 会员信息', 'url' => ['/site/client-user-view', 'id' => Yii::$app->user->identity->id], 'linkOptions' => ['data-method' => 'post']]]], ['label' => '管理', 'visible' => $isAdmin, 'items' => [['label' => '<i class="fa fa-user"></i> 用户管理', 'url' => ['/user/index'], 'linkOptions' => ['data-method' => 'post']], ['label' => '<i class="fa fa-tags"></i> 商品管理', 'url' => ['/goods/index', 'pub_userid' => Yii::$app->user->identity->id, 'goods_kind' => 0], 'linkOptions' => ['data-method' => 'post']], ['label' => '<i class="fa fa-list"></i> 订单管理', 'url' => ['/order/index', 'userid' => Yii::$app->user->identity->id], 'linkOptions' => ['data-method' => 'post']], '<li class="divider"></li>', ['label' => '<i class="fa fa-newspaper-o"></i> 新闻管理', 'url' => ['/news/index', 'cat' => 0], 'linkOptions' => ['data-method' => 'post']], ['label' => '<i class="fa fa-cog"></i> 网站配置', 'url' => ['/about/index'], 'linkOptions' => ['data-method' => 'post']]]], Yii::$app->user->isGuest ? ['label' => '登录', 'url' => ['/site/login']] : ['label' => '<span class="glyphicon glyphicon-user"></span> ' . Html::encode(Yii::$app->user->identity->username), 'items' => [['label' => '<i class="fa fa-sign-out"></i> 退出', 'url' => ['/site/logout'], 'linkOptions' => ['data-method' => 'post']]]]]]); NavBar::end(); ?> <div class="container"> <?php echo Breadcrumbs::widget(['links' => isset($this->params['breadcrumbs']) ? $this->params['breadcrumbs'] : []]);