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