public function actionIndex()
{
$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[1];
$db_global_arr = $db_statist_arr[2];
$db_trace_arr = $db_statist_arr[3];
return $this->render('index', ['db_global_arr' => $db_global_arr, 'db_result_arr' => $db_result_arr, 'db_trace_arr' => $db_trace_arr]);
}
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]);
}
