public function actionIndex() { // $searchModel = new DaylyTestResultsSearch(); // $dataProvider = $searchModel->search(Yii::$app->request->queryParams); $fail_arr = array(); $pass_arr = array(); $error_arr = array(); $average_arr = array(); $pass_arr = DaylyTestResults::getLastDayPassResults(); $fail_arr = DaylyTestResults::getLastDayFailResults(); $error_arr = DaylyTestResults::getLastDayErrorResults(); $average_arr = $this->foreachFunc($pass_arr, $fail_arr); return $this->render('index', ['pass_arr' => $pass_arr, 'fail_arr' => $fail_arr, 'error_arr' => $error_arr, 'average_arr' => $average_arr]); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = DaylyTestResults::find(); // add conditions that should always apply here // WHERE testdate >= dateadd (-1 day to current_date) $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } // grid filtering conditions $query->andFilterWhere(['id' => $this->id, 'server_name' => $this->server_name, 'pass_result' => $this->pass_result, 'fail_result' => $this->fail_result]); $query->andFilterWhere(['like', 'time_update', $this->time_update]); return $dataProvider; }
public function actionIndex() { $daylydataProvider = new ActiveDataProvider(['query' => PASSFAILDAYLY::find()->orderBy('DATE'), 'pagination' => false]); if (Yii::$app->user->isGuest) { return $this->render('about', []); } $fail_arr = array(); $pass_arr = array(); $error_arr = array(); $average_arr = array(); $pass_arr = DaylyTestResults::getLastDayPassResults(); $fail_arr = DaylyTestResults::getLastDayFailResults(); $error_arr = DaylyTestResults::getLastDayErrorResults(); $average_arr = $this->foreachFunc($pass_arr, $fail_arr); $db_statist_arr = array(); $db_global_arr = array(); $db_result_arr = array(); $db_trace_arr = array(); $db_statist_arr = DbStat::getDbStatistics(); $db_result_arr = $db_statist_arr[2]; $db_global_arr = $db_statist_arr[3]; $db_trace_arr = $db_statist_arr[4]; $uutFail_result = array(); $uut_result = array(); $TotaluutFail_result = array(); $uutFail_result = DaylyTestResults::getLastDayUUTFails(); //print_r($uutFail_result); $UUTFailprovider = new ArrayDataProvider(['allModels' => $uutFail_result, 'sort' => ['attributes' => ['name', 'y']], 'pagination' => ['pageSize' => 10]]); $color_array = array(); $elements_in_arr = count($uutFail_result); for ($i = 0; $i < $elements_in_arr; $i++) { $color_code = rand(0, 9); $js_text = "Highcharts.getOptions().colors[" . $color_code . "]"; $color_array[$i]['color'] = new JsExpression($js_text); } // echo("</br>"); for ($i = 0; $i < $elements_in_arr; $i++) { $TotaluutFail_result[$i] = $uutFail_result[$i] + $color_array[$i]; $TotaluutFail_result[$i]['y'] = (int) $TotaluutFail_result[$i]['y']; } // print_r($TotaluutFail_result); $pass_percent = 0; $fail_percent = 0; $error_percent = 0; $facility_arr = array(); $totall_produced = array_sum($pass_arr) + array_sum($fail_arr) + array_sum($error_arr); $pass_percent = ceil(array_sum($pass_arr) * 100 / $totall_produced); $fail_percent = ceil(array_sum($fail_arr) * 100 / $totall_produced); $error_percent = ceil(array_sum($error_arr) * 100 / $totall_produced); if (Yii::$app->user->identity->username != 'admin' and Yii::$app->user->identity->username != 'Ceragon') { $facility_arr = [Yii::$app->user->identity->username]; //$facility_name = Yii::$app->user->identity->username; } else { $facility_arr = ['Ceragon', 'Flex1', 'Flex2', 'Ionics1', 'Ionics2', 'VCL1']; //$facility_name = ''; } $DaylyPF_result = array(); $DaylyPF_result = DaylyTestResults::getDaylyPassFailResults(); $coloPFr_array = array(); for ($i = 0; $i < count($facility_arr); $i++) { $js_text = "Highcharts.getOptions().colors[" . $i . "]"; $coloPFr_array[$i]['color'] = new JsExpression($js_text); } // print(count(array_column($DaylyPF_result[0], 'PASS'))); $TotalDaylyPF_Passresult = array(); for ($i = 0; $i < count($facility_arr); $i++) { $TotalDaylyPF_Passresult[$i] = $coloPFr_array[$i]; $TotalDaylyPF_Passresult[$i]['name'] = $facility_arr[$i]; $TotalDaylyPF_Passresult[$i]['type'] = "line"; $TotalDaylyPF_Passresult[$i]['pointStart'] = gmmktime(0, 0, 0, 3, 3, 2016) * 1000; $TotalDaylyPF_Passresult[$i]['pointInterval'] = 24 * 3600 * 1000; $tmp_dayly = $DaylyPF_result[$i]; $tmp_arr = array_column($tmp_dayly, 'PASS'); $TotalDaylyPF_Passresult[$i]['data'] = array_merge(array_map('intval', array_slice($tmp_arr, 0))); } $TotalDaylyPF_Failsresult = array(); for ($i = 0; $i < count($facility_arr); $i++) { $TotalDaylyPF_Failsresult[$i] = $coloPFr_array[$i]; $TotalDaylyPF_Failsresult[$i]['name'] = $facility_arr[$i]; $TotalDaylyPF_Failsresult[$i]['type'] = "line"; $TotalDaylyPF_Failsresult[$i]['pointStart'] = gmmktime(0, 0, 0, 3, 3, 2016) * 1000; $TotalDaylyPF_Failsresult[$i]['pointInterval'] = 24 * 3600 * 1000; $tmp_dayly = $DaylyPF_result[$i]; $tmp_arr = array_column($tmp_dayly, 'FAIL'); $TotalDaylyPF_Failsresult[$i]['data'] = array_merge(array_map('intval', array_slice($tmp_arr, 0))); } return $this->render('index', ['pass_arr' => $pass_arr, 'fail_arr' => $fail_arr, 'error_arr' => $error_arr, 'average_arr' => $average_arr, 'daylydataProvider' => $daylydataProvider, 'db_global_arr' => $db_global_arr, 'db_result_arr' => $db_result_arr, 'db_trace_arr' => $db_trace_arr, 'pass_percent' => $pass_percent, 'fail_percent' => $fail_percent, 'error_percent' => $error_percent, 'uutFail_result' => $uutFail_result, 'TotaluutFail_result' => $TotaluutFail_result, 'facility_arr' => $facility_arr, 'TotalDaylyPF_Passresult' => $TotalDaylyPF_Passresult, 'TotalDaylyPF_Failsresult' => $TotalDaylyPF_Failsresult, 'UUTFailprovider' => $UUTFailprovider]); }