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 actionReport() { $identity = \Yii::$app->user->getIdentity(); $request = \Yii::$app->request; $params = \Yii::$app->params; $id = $request->get('id'); $pond = pond::findOne(['id' => $id]); $Typelist = Typelist::findOne(['id' => $pond->type]); $objfoot = Food::find()->andWhere(['pondId' => $id])->groupBy('foodTime')->all(); $arrFood = []; foreach ($objfoot as $footlst) { $objfootday = Food::find()->andWhere(['foodTime' => $footlst['foodTime']])->andWhere(['pondId' => $id])->all(); $arrFoodday = []; foreach ($objfootday as $footlstday) { $arrFoodday[] = $footlstday; } $objFood = ['Foodday' => $arrFoodday]; $objCheckyoDay = Checkyo::find()->andWhere(['checkyoTime' => $footlst['foodTime']])->andWhere(['pondId' => $id])->all(); $arrCheckyoday = []; foreach ($objCheckyoDay as $Checkyolstday) { $arrCheckyoday[] = $Checkyolstday; } $objCheckyo = ['Checkyoday' => $arrCheckyoday]; $objWeightDay = Weight::find()->andWhere(['weightTime' => $footlst['foodTime']])->andWhere(['pondId' => $id])->one(); $WeightDay = isset($objWeightDay->weightNo) ? $objWeightDay->weightNo : '-'; $objOxygenDay = Oxygen::find()->andWhere(['oxygenTime' => $footlst['foodTime']])->andWhere(['pondId' => $id])->one(); $OxygenDay = isset($objOxygenDay->weightNo) ? $objOxygenDay->weightNo : '-'; $objAlkalinityDay = Alkalinity::find()->andWhere(['alkalinityTime' => $footlst['foodTime']])->andWhere(['pondId' => $id])->one(); $AlkalinityDay = isset($objAlkalinityDay->alkalinityNum) ? $objAlkalinityDay->alkalinityNum : '-'; $objWatertempDay = Watertemp::find()->andWhere(['watertempTime' => $footlst['foodTime']])->andWhere(['pondId' => $id])->one(); $WatertempDay = isset($objWatertempDay->watertempNum) ? $objWatertempDay->watertempNum : '-'; $objTempDay = Temp::find()->andWhere(['tempTime' => $footlst['foodTime']])->andWhere(['pondId' => $id])->one(); $TempDay = isset($objTempDay->tempNum) ? $objTempDay->tempNum : '-'; $objAmmoniaDay = Ammonia::find()->andWhere(['ammoniaTime' => $footlst['foodTime']])->andWhere(['pondId' => $id])->one(); $AmmoniaDay = isset($objAmmoniaDay->ammoniaNum) ? $objAmmoniaDay->ammoniaNum : '-'; $objNitriteDay = Nitrite::find()->andWhere(['nitriteTime' => $footlst['foodTime']])->andWhere(['pondId' => $id])->one(); $NitriteDay = isset($objNitriteDay->nitriteNum) ? $objNitriteDay->nitriteNum : '-'; $objWaterchange = Waterchange::find()->andWhere(['waterchangeTime' => $footlst['foodTime']])->andWhere(['pondId' => $id])->one(); $WaterchangeDay = isset($objWaterchange->weightNo) ? 'เปลี่ยนเข้า' : '-'; $objSalinityDay = Salinity::find()->andWhere(['salinityTime' => $footlst['foodTime']])->andWhere(['pondId' => $id])->one(); $SalinityDay = isset($objSalinityDay->salinityNum) ? $objSalinityDay->salinityNum : '-'; $objOtherDay = other::find()->andWhere(['otherTime' => $footlst['foodTime']])->andWhere(['pondId' => $id])->one(); $OtherDay = isset($objOtherDay->name) ? $objOtherDay->name : '-'; $arrObjListAll[$footlst['foodTime']] = ['objFood' => $objFood, 'objCheckyo' => $objCheckyo, 'WeightDay' => $WeightDay, 'age' => $footlst['age'], 'numberOf' => $footlst['numberOf'], 'WeightDay' => $WeightDay, 'OxygenDay' => $OxygenDay, 'AlkalinityDay' => $AlkalinityDay, 'WatertempDay' => $WatertempDay, 'TempDay' => $TempDay, 'AmmoniaDay' => $AmmoniaDay, 'NitriteDay' => $NitriteDay, 'WaterchangeDay' => $WaterchangeDay, 'SalinityDay' => $SalinityDay, 'OtherDay' => $OtherDay]; } echo $this->render('report', ['pond' => $pond, 'Typelist' => $Typelist, 'arrObjListAll' => $arrObjListAll]); }