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);
}
