protected function parent4process_task() { $query = Pilotplan::find(); $ctg = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 200]]); $arr = []; foreach ($ctg->getModels() as $t) { if ($t->PLAN_DATE1 != '' and $t->PLAN_DATE2 != '') { $arr[] = $t; if ($t->ACTUAL_DATE1 != '' and $t->ACTUAL_DATE2 != '') { $querySub1 = Pilotactual::find()->Where('ID=' . $t->ID); $sub1 = new ActiveDataProvider(['query' => $querySub1, 'pagination' => ['pageSize' => 200]]); foreach ($sub1->getModels() as $su1) { $arr[] = $su1; if ($t->ACTUAL_DATE2 != '' and $su1->ACTUAL_DATE2 != '' and $su1->ACTUAL_DATE2 > $t->PLAN_DATE2) { $querySub2 = Pilotdelay::find()->Where('ID=' . $t->ID); $sub2 = new ActiveDataProvider(['query' => $querySub2, 'pagination' => ['pageSize' => 200]]); foreach ($sub2->getModels() as $su2) { $arr[] = $su2; } } } } } } //return $arr; return Json::encode($arr); }
protected function parent6milestone() { $request = Yii::$app->request; $userid = $request->get('id_user'); $queryStr = Pilotplan::find()->Where('CREATED_BY=' . $userid); $ctgstart = new ActiveDataProvider(['query' => $queryStr, 'pagination' => ['pageSize' => 200]]); $arrStr = []; foreach ($ctgstart->getModels() as $st) { if ($st->STATUS == 1 and Yii::$app->ambilKonvesi->convert($st->ACTUAL_DATE2, 'date') <= Yii::$app->ambilKonvesi->convert($st->PLAN_DATE2, 'date')) { /*CLOSE PROGRESS */ $querySub1 = Pilotmilestone::find()->Where('ID=' . $st->ID); $sub1start = new ActiveDataProvider(['query' => $querySub1, 'pagination' => ['pageSize' => 200]]); foreach ($sub1start->getModels() as $str1) { $arrStr[] = $str1; } } } return Json::encode($arrStr); }