public function actionUpdate($id = null) { $cid = Yii::$app->getRequest()->getQueryParam('cid'); $model = new TblGuides(); if ($model->load($_POST)) { $id = $_POST['TblGuides']['id']; if ($id) { $model = TblGuides::findOne($id); $model->attributes = $_POST['TblGuides']; } if ($model->save()) { return $this->redirect(array('index', 'cid' => $model->cid)); } else { print_r($model->getErrors()); exit; } } if ($id) { $model = TblGuides::findOne($id); } else { $sess = Yii::$app->session->get('sessTblGuides'); $model->langs = $sess['langs']; $model->cid = $cid ? $cid : $sess['cid']; } return $this->render('update', ['model' => $model]); }
public function actionIndex($cid = 1) { $search = new TblGuides(); $langs = \app\components\langs::getLang(); $query = TblGuides::find()->where(['cid' => $cid, 'langs' => $langs, 'published' => 1]); $amp = Yii::$app->getRequest()->getQueryParam('amp'); if ($amp) { $query->andWhere(['amphur' => $amp]); } if ($search->load(Yii::$app->request->post())) { $request = Yii::$app->request->post('TblGuides'); $s = $request['search']; //$query->orWhere([['LIKE', 'titls', "%$s%"],['LIKE', 'fulltexts', "%$s%"]]); //$query->orWhere('LIKE', 'titles', "%$s%"); $query->andFilterWhere(['or', ['like', 'titles', $s], ['like', 'fulltexts', $s]]); } $query->orderBy('rand()'); $countQuery = clone $query; $pages = new Pagination(['totalCount' => $countQuery->count(), 'defaultPageSize' => 10]); $list = $query->offset($pages->offset)->limit($pages->limit)->all(); return $this->render('index', ['search' => $search, 'model' => $list, 'cid' => $cid, 'pages' => $pages]); }