public function actionIndex() { $arrPorn = []; $objTypelist = Typelist::find()->all(); foreach ($objTypelist as $dataTypelist) { //$arrTypelist[] = $objPond = Pond::find()->andwhere("status = 1")->andwhere(['type' => $dataTypelist->id])->all(); foreach ($objPond as $dataPond) { $arrPorn[] = ['typeId' => $dataTypelist->id, 'typelist' => $dataTypelist, 'title' => $dataPond->title, 'larvae' => $dataPond->larvae]; } } $this->layout = 'layoutstyle'; return $this->render('index', ['arrPorn' => $arrPorn]); }
public function actionEdit() { $request = Yii::$app->request; $identity = \Yii::$app->user->getIdentity(); $currentTs = time(); $id = $request->post('id', 0); if (empty($id)) { $id = $request->get('id', 0); } $pond = pond::findOne(['id' => $id]); $type = $request->get('type', $request->post('type', null)); $description = $request->get('description', $request->post('description', null)); $larvae = $request->get('larvae', $request->post('larvae', null)); $larvaeType = $request->get('larvaeType', $request->post('larvaeType', null)); $larvaePrice = $request->get('larvaePrice', $request->post('larvaePrice', null)); $larvaeCompany = $request->get('larvaeCompany', $request->post('larvaeCompany', null)); $releaseTime = $request->get('releaseTime', $request->post('releaseTime', null)); $title = $request->get('title', $request->post('title', null)); if (empty($pond)) { $pond = new pond(); $pond->createBy = $identity->id; $pond->createTime = date('Y-m-d H:i:s', $currentTs); $pond->status = 1; } if ($request->isPost) { $publishTs = $currentTs; $pond->title = $title; $pond->type = $type; $pond->pond = $description; $pond->lastUpdateTime = date(DateUtil::SQL_DT_FMT, $currentTs); $pond->lastUpdateBy = $identity->id; $pond->larvae = $larvae; $pond->larvaeType = $larvaeType; $pond->larvaePrice = $larvaePrice; $pond->larvaeCompany = $larvaeCompany; $pond->releaseTime = $releaseTime; if ($pond->save()) { //เซ็ตให้ status รุ่นเก่า เป็น 0 = ไม่ active ให้หมด \Yii::$app->db->createCommand("UPDATE pond SET status = 0 WHERE type = {$type} AND id != {$pond->id} ")->execute(); Ui::setMessage('บันทึกข้อมูลสำเร็จ'); return $this->redirect('list'); } else { Ui::setMessage(json_encode($pond->getErrors(), JSON_UNESCAPED_UNICODE), 'warning'); } } $query = Typelist::find(); $query->orderBy(['id' => SORT_ASC]); $objTypelist = $query->all(); $arrTypelist = []; foreach ($objTypelist as $dataTypelist) { $arrTypelist[$dataTypelist->id] = $dataTypelist->name; } echo $this->render('edit', ['pond' => $pond, 'arrTypelist' => $arrTypelist]); }