public function getAds($conditions, $offset, $size, $orderby) { $ads = self::queryDatas('archive_position_relate', $conditions, $offset, $size, $orderby, true); if (!empty($ads['list'])) { $category = [1 => '疾病文章', 2 => '资讯文章', 3 => '图片', 4 => '代码']; $position = []; foreach ($ads['list'] as &$ad) { $position = Position::find()->asArray()->where(['id' => $ad['position_id']])->one(); if (!empty($position)) { $ad['position_name'] = $position['name']; } $ad['category_name'] = $category[$ad['category']]; $ad['createtime_str'] = date('Y-m-d H:i', $ad['createtime']); } } return $ads; }
public function getPosition($condition) { return Position::find()->where($condition)->asArray()->one(); }
public function actionSearch() { \Yii::$app->response->format = Response::FORMAT_JSON; $id = $this->helpGpost('id', '0'); $name = $this->helpGpost('name', ''); $page = $this->helpGpost('page', 1); $page = empty($page) ? 1 : $page; $conditions = []; if (!empty($id)) { $conditions['id'] = $id; } if (!empty($name)) { $conditions['name'] = $name; } $size = 9; $offset = ($page - 1) * $size; $orderby = 'id ASC'; if (!empty($conditions) && isset($conditions['name']) && !empty($conditions['name'])) { $archive_name_arr = ['LIKE', 'name', $conditions['name']]; unset($conditions['name']); $conditions[] = $archive_name_arr; } $position = new Position(); $values = $position->getPositions($conditions, $offset, $size, $orderby); $pageHTML = $this->getPageHTML($page, $size, $values['total']); return ['positions' => $values['list'], 'pageHTML' => $pageHTML]; }
public function actionAdd() { $position = new Position(); $positions = $position->getPositions(null, null, null, null, false); $positions = $positions['list']; $params = ['positions' => $positions]; return $this->render('add', $params); }