public function actionIndex() { $model = new StatisticsSearchForm(); $model->load(Yii::$app->request->post()); $query = (new Query())->from(Statistics::tableName())->where('1=1'); if (!empty($model->shop)) { $query->andWhere('shop=:shop', [':shop' => $model->shop]); } if (!empty($model->commodity)) { $query->andWhere('commodity like :commodity', [':commodity' => '%' . $model->commodity . '%']); } if (!empty($model->platform)) { $query->andWhere('platform=:platform', [':platform' => $model->platform]); } if (!empty($model->btime)) { $query->andWhere('handle_time >= :handle_time', [':handle_time' => $model->btime]); } if (!empty($model->etime)) { $query->andWhere('handle_time <= :handle_time', [':handle_time' => $model->etime]); } if ($this->user->rid == 3) { $query->andWhere('uid = :uid', [':uid' => $this->user->id]); } $query->orderBy('handle_time desc'); $pages = new Pagination(['totalCount' => $query->count(), 'pageSize' => '20']); $query->limit($pages->limit)->offset($pages->offset); $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => false]); $platforms = Platform::find()->all(); $ops = array(); $enarray = ['value' => '', 'text' => '全部']; array_push($ops, $enarray); foreach ($platforms as $platform) { $enarray = ['value' => $platform->name, 'text' => $platform->name]; array_push($ops, $enarray); } $page = 'index'; if ($this->user->rid == 4) { $page = 'index-4'; } return $this->render($page, ['model' => $model, 'dataProvider' => $dataProvider, 'pages' => $pages, 'ops' => $ops]); }
public function updatePlatform($parameters) { try { $userLogs = new UserLogsService(); switch ($parameters['oper']) { case 'changePassword': $id = $parameters['id']; $platform = Platform::find(reset($id)); $platform->api_password = $this->hashPassword($parameters['password']); $platform->save(); $parameters['oper'] = 'apiChangePassword'; $userLogs->createUserLog($parameters); return true; break; case 'del': $parameters['oper'] = 'apiDel'; $userLogs->createUserLog($parameters); return Platform::destroy($parameters['ids']); break; case 'add': $platform = $this->newPlatform($parameters); $parameters['oper'] = 'apiAdd'; $userLogs->createUserLog($parameters); break; case 'edit': $id = $parameters['id']; $platform = Platform::find($id); $parameters['oper'] = 'apiEdit'; $userLogs->createUserLog($parameters); break; } $columns = array_intersect_key($parameters, array_flip($platform->getFillableColumns())); if (!empty($columns)) { $platform->update($columns); } return $platform; } catch (\Exception $e) { throw $e; } }
public function actionSylist() { $model = new Buyer(); $query = (new Query())->select('*')->from(Buyer::tableName())->where('platform=:platform', [':platform' => '淘宝'])->andWhere('isSync=:isSync', [':isSync' => 0]); $pages = new Pagination(['totalCount' => $query->count(), 'pageSize' => '20']); $query->limit($pages->limit)->offset($pages->offset); $dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => false]); $platforms = Platform::find()->all(); return $this->render('sylist', ['model' => $model, 'dataProvider' => $dataProvider, 'platforms' => $platforms, 'pages' => $pages]); }
public function actionIndex() { $dataProvider = new ActiveDataProvider(['query' => Platform::find()]); return $this->render('index', array('dataProvider' => $dataProvider)); }
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)); }