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