public function actionIndex() { $start = 0; $end = 0; $usr = "******"; $alldata = []; $dataPulses = []; $dataTemps = []; $request = Yii::$app->request; $data = 0; if ($request->post('startDatePeriod')) { $start = $request->post('startDatePeriod'); $end = $request->post('endDatePeriod'); $usr = $request->post('id'); $data = temp::find()->where(['>=', 'today', $start])->andWhere(['<=', 'today', $end])->andWhere(['usr' => $usr])->orderBy(['today' => SORT_ASC])->all(); //$tickinterval = null; } else { $data = temp::find()->where(['usr' => $usr])->orderBy(['today' => SORT_ASC])->all(); } if ($data != 0) { $pulses = []; $pulsesAvg = []; $temps = []; $dates = []; // $alldata[]=['pulse' => $value->pulse] ; foreach ($data as $value) { $alldata[] = ['date' => $value->today, 'pulse' => $value->pulse, 'pulseAvg' => (int) $value->pulseAvg, 'temp' => (double) $value->temp]; $dataPulses = ['date' => $value->today, 'pulse' => $value->pulse]; $dataTemps[] = ['date' => $value->today, 'temp' => (double) $value->temp]; array_push($pulses, (int) $value->pulse); array_push($pulsesAvg, (int) $value->pulseAvg); array_push($temps, (double) $value->temp); array_push($dates, $value->today); } if (!$start && !$end) { reset($dates); $start = current($dates); $end = end($dates); } return $this->render('index', ['pulses' => $pulses, 'pulsesAvg' => $pulsesAvg, 'temps' => $temps, 'dates' => $dates, 'alldata' => $alldata, 'dataTemps' => $dataTemps, 'dataPulses' => $dataPulses, 'tickinterval' => $tickinterval = null, 'start' => $start, 'end' => $end, 'usr' => $usr]); } return $this->render('index', ['data' => 0]); }
public function actionEdittemp() { $currentTs = time(); $identity = \Yii::$app->user->getIdentity(); $request = \Yii::$app->request; $id = $request->get('id', $request->post('id', null)); $query = Temp::find(); if ($id) { $query->where("id=" . $id); $model = $query->one(); $status = "แก้ใข"; } else { $model = new temp(); $model->createTime = date('Y-m-d H:i:s', $currentTs); $model->createBy = $identity->id; $status = "บันทึก"; } $tempTime = $request->get('tempTime', $request->post('tempTime', null)); $tempTimeIn = date('Y-m-d H:i:s', strtotime($tempTime)); if ($request->isPost) { $model->name = $request->get('name', $request->post('name', null)); $model->pondId = $request->get('pondId', $request->post('pondId', null)); $model->tempNo = $request->get('tempNo', $request->post('tempNo', null)); $model->age = $request->get('age', $request->post('age', null)); $model->tempNum = $request->get('tempNum', $request->post('tempNum', null)); $model->tempTime = $tempTimeIn; $model->numberOf = $request->get('numberOf', $request->post('numberOf', null)); $model->lastUpdateBy = $identity->id; $model->lastUpdateTime = date('Y-m-d H:i:s', $currentTs); if (trim($model->pondId) == '') { $model->addError('pondId', 'ไม่ได้เลือก รุ่น และบ่อ'); } if ($model->save()) { //เซ็ตให้ status รุ่นเก่า เป็น 0 = ไม่ active ให้หมด Ui::setMessage('บันทึกข้อมูลสำเร็จ'); return $this->redirect('temp'); } else { Ui::setMessage(json_encode($model->getErrors(), JSON_UNESCAPED_UNICODE), 'warning'); } } $query = Pond::find()->where("status = 1")->orderBy(['type' => SORT_ASC])->groupBy(['type']); $arrTypelist = [0 => 'กรุณาเลือกบ่อ และรุ่นที่ต้องการ']; $arrTypelist += \yii\helpers\ArrayHelper::map($query->all(), 'id', 'title', 'type'); echo $this->render('edittemp', ['model' => $model, 'arrTypelist' => $arrTypelist, 'status' => $status]); }