public function getMmPoint(Request $request) { $key = request('key'); $mmpointM = DB::connection(DBUtils::getDBName())->table('mmpoint_table')->where('A', $key)->first(); // Log::info("lenth ".sizeof($mmtrendM)); return response()->json(['mmpointM' => json_encode($mmpointM)]); }
/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function search() { Log::info("Into SpecialController"); $design_trend_B = Input::get('design_trend_B'); $search = Input::get('search'); $sortBy = Input::get('sortBy'); $orderBy = Input::get('orderBy'); if (empty($design_trend_B)) { $design_trend_B = Auth::user()->empId; } $datas = MmnameModel::on(DBUtils::getDBName())->newQuery(); if (Input::has('page')) { // paging Log::info("into paging"); $search = session()->get('design_trend_search'); $sortBy = session()->get('sortBy'); $orderBy = session()->get('orderBy'); $design_trend_B = session()->get('design_trend_B'); } if (!empty($search)) { $datas = $datas->Where(function ($datas) use($search) { $datas->orWhere('A', 'LIKE', "%{$search}%"); }); } if (!empty($design_trend_B) && $design_trend_B != -1) { $datas = $datas->Where('B', '=', "{$design_trend_B}"); } if (!empty($sortBy) && !empty($orderBy)) { $datas = $datas->orderBy($sortBy, $orderBy); } session()->put('sortBy', $sortBy); session()->put('orderBy', $orderBy); session()->put('design_trend_search', $search); session()->put('design_trend_B', $design_trend_B); // $datas=$datas->orderBy('updated_at','DESC')->paginate(10); $datas = $datas->paginate(10); //$mmtrend_groups = DB::connection(DBUtils::getDBName())->table('mmtrend_group')->where('mmplant','=',session()->get('user_mmplant'))->get(); // $mmtrend_groups = DB::table('mmtrend_group')->where('mmplant', '=', session()->get('user_mmplant')); if (session()->get('user_priority') < 128) { $mmtrend_groups = $mmtrend_groups->where('B', '=', '9'); } $mmtrend_groups = $mmtrend_groups->get(); return view('ais/special', ['mmtrendsM' => $datas, 'mmtrend_groups' => $mmtrend_groups]); }
public function search() { Log::info("x dbName->y"); $dbName = DBUtils::getDBName(); Log::info("x dbName->" . $dbName); $search = Input::get('search'); $sortBy = Input::get('sortBy'); $orderBy = Input::get('orderBy'); // $users = DB::connection('foo'); // solution 1 /* $someModel=new AddUserModel(); $someModel->setConnection('mysql_ais_473'); $datas = $someModel->newQuery(); */ // solution 2 ::on('connection_name') $datas = AddUserModel::query(); if (Input::has('page')) { // paging Log::info("into paging"); $search = session()->get('addUser_search'); $sortBy = session()->get('sortBy'); $orderBy = session()->get('orderBy'); } if (!empty($search)) { $datas = $datas->Where(function ($datas) use($search) { $datas->orWhere('A', 'LIKE', "%{$search}%")->orWhere('C', 'LIKE', "%{$search}%"); }); } if (!empty($sortBy) && !empty($orderBy)) { $datas = $datas->orderBy($sortBy, $orderBy); } session()->put('sortBy', $sortBy); session()->put('orderBy', $orderBy); session()->put('addUser_search', $search); // $datas=$datas->paginate(10); $datas = $datas->orderBy('updated_at', 'DESC')->paginate(10); /* $info_employee = AddUserModel::orderBy('updated_at','DESC') // ->orderBy('updated_at','DESC') ->paginate(12); */ return view('ais/addUser', ['info_employee' => $datas]); }
public function readEventDataTrend($point, $unit, $startTime, $endTime) { //public function readEventDataTrend($point,$unit,$startTime,$endTime){ //$unit,$startTime,$endTime //echo $point; $pointArray = explode(",", $point); $pointNum = ""; for ($i = 0; $i < count($pointArray); $i++) { if ($i == 0) { $pointNum .= "'" . substr($pointArray[$i], 1) . "'"; } else { $pointNum .= ",'" . substr($pointArray[$i], 1) . "'"; } } //echo $pointNum; //convert string to int $unit = (int) $unit; Log::info("Into readEventDataTrend"); $tagName = ""; $queryTag = "select DISTINCT(D) as tagName from mmtrend_table\r\n WHERE H in({$pointNum})\r\n AND B='{$unit}'"; //$reslutQueryTag = DB::connection('mysql_ais_47')->select($queryTag); $reslutQueryTag = DB::select($queryTag); //print_r($reslutQueryTag); $i = 0; foreach ($reslutQueryTag as $rs) { //echo $rs->tagName; if ($i == 0) { $tagName .= $rs->tagName; } else { $tagName .= "|" . $rs->tagName; } $i++; } // echo $tagName; /* while($rsTag=mysql_fetch_array($reslutQueryTag)){ echo $rsTag[tagName]; }*/ $query = "\r\n select '2014-05-01 00:00:00' as 'EvTime',vpser_raw.ois_vpser,event_raw.ois_event,'data Action' as ois_action from vpser_raw\r\n LEFT JOIN event_raw\r\n ON event_raw.sys_date=vpser_raw.sys_date\r\n LEFT JOIN action_raw\r\n on vpser_raw.sys_date=action_raw.sys_date\r\n where \r\n (vpser_raw.ois_vpser REGEXP 'VPSER|L83E131|80S'\r\n or event_raw.ois_event REGEXP 'VPSER|L83E131|80S'\r\n or action_raw.ois_action REGEXP 'VPSER|L83E131|80S'\r\n )\r\n AND \r\n (vpser_raw.sys_date \r\n \tBETWEEN '2014-10-01 00:00:00' \r\n \tand '2014-10-25 01:00:00'\r\n \tor event_raw.sys_date \r\n \tBETWEEN '2014-10-01 00:00:00' \r\n \tand '2014-10-25 01:00:00'\r\n \tor action_raw.sys_date \r\n \tBETWEEN '2014-10-01 00:00:00' \r\n \tand '2014-10-25 01:00:00'\r\n )"; $reslutQuery = DB::connection(DBUtils::getDBName())->select($query); //$reslutQuery = DB::connection('mysql_ais_47')->select($query); return json_encode($reslutQuery); }
public function destroy($id) { $tagConfigModel = TagConfigModel::on(DBUtils::getDBName())->find($id); $tagConfigModel->delete(); DB::connection(DBUtils::getDBName())->table('mmpoint_table')->where('A', '=', $tagConfigModel->A)->delete(); session()->flash('message', ' Delete successfuly.'); return redirect('ais/tagConfiguration'); }
public function mulipleDB(Request $request) { $account = DB::connection(DBUtils::getDBName())->connection('lportal')->table('Account_')->get(); Log::info("Into mulipleDB callAjax" . $account[0]->name); $mmpoint = DB::connection(DBUtils::getDBName())->table('mmpoint_table')->get(); Log::info("Into mulipleDB callAjax" . $mmpoint[0]->A); return response()->json(['account' => json_encode($account), 'mmpoint' => json_encode($mmpoint)]); }
public function destroy($id) { Log::info("into destroy[" . $id . "]"); $pointConfigModel = PointConfigModel::on(DBUtils::getDBName())->find($id); Log::info($pointConfigModel->H); $pointConfigModel->delete(); /* //DB::connection(DBUtils::getDBName())->table('mmtag_table')->where('A', '=', $pointConfigModel->H)->delete(); */ session()->flash('message', ' Delete successfuly.'); //return redirect('ais/pointConfiguration'); return redirect('ais/tag/' . $pointConfigModel->H . '/points'); }
public function getTrendByTrendNameGroup($trendNameGroup) { //echo $trendName; $query = "select * from mmname_table\r\n WHERE A LIKE '%{$trendNameGroup}%'"; $reslutQuery = DB::connection(DBUtils::getDBName())->select($query); //$reslutQuery = DB::connection('mysql_ais_47')->select($query); Log::info(json_encode($reslutQuery)); return json_encode($reslutQuery); }
public function executeCalculationBK() { /* key:"88-c102" startTime:"2014-05-01 00:01:00" endTime:"2014-05-01 00:50:00" scaleType:'minute' server:’47’ value:"U04D1+ U04D2+Enthalpy(U04D2;U04D2)" */ $key_param = request('key'); $startTime_param = request('startTime'); $endTime_param = request('endTime'); $scaleType_param = request('scaleType'); $server_param = request('server'); $value_param = request('value'); Log::info("value_param " . $value_param[0]); $str = $value_param[0]; //"U04D1+ U04D2+Enthalpy(U04D2;U04D2)"; $str = str_replace(";", ":", $str); $str = strtoupper($str); preg_match_all('/(U[0-9]{1,2})(D[0-9]{1,4})/', $str, $matches); $fomula_array = array(); if (!empty($matches)) { $full_formats = $matches[0]; //full format $first_groups = $matches[1]; //first group (U0x) $second_groups = $matches[2]; //second group (Dyyy) foreach ($full_formats as $key => $full_format) { if (!array_key_exists($full_format, $fomula_array)) { $new_array_inner = array(); $new_array_inner['unit'] = $first_groups[$key]; $new_array_inner['data'] = $second_groups[$key]; $new_array_inner['time'] = ''; $new_array_inner['value'] = ''; $fomula_array[$full_format] = $new_array_inner; } } } // Log::info($fomula_array); $groupby = ""; $data_table = ""; if ($scaleType_param == 'minute') { $data_table = "data"; } else { if ($scaleType_param == 'hour') { $data_table = "datahr"; } } if ($scaleType_param == 'day') { $data_table = "dataday"; } if ($scaleType_param == 'month') { $data_table = "dataday"; $groupby = " group by month(evTime) "; } $result_array = array(); $result_key_time_array = array(); foreach ($fomula_array as $key => $fomula) { $data_str = $fomula["data"]; if ($scaleType_param == 'month') { $data_str = "avg(" . $fomula["data"] . ")"; } /* $sql = " select evTime , " . $data_str . " as data from ais_db." . $data_table . strtolower($fomula["unit"]) . " where evTime between '" . $startTime_param . "' " . " and '" . $endTime_param . "' " . $groupby; */ $sql = " select evTime , " . $data_str . " as data from " . $data_table . strtolower($fomula["unit"]) . " where evTime between '" . $startTime_param . "' " . " and '" . $endTime_param . "' " . $groupby; //$lists = DB::connection('mysql')->select($sql); $lists = DB::connection(DBUtils::getDBName())->select($sql); // Log::info($sql); //Log::info($lists); $lists_str = json_encode($lists); foreach ($lists as $key2 => $result) { $new_array_result_inner = array(); $new_array_result_inner['data'] = $result->data; $result_array[$result->evTime . "|" . $key] = $new_array_result_inner; $result_key_time_array[$result->evTime] = $result->evTime; // Log::info("key2[".$key2."]->".$result->evTime); } //Log::info($lists_str); } // Log::info($result_array); // Log::info(sizeof($result_array)); // Log::info(json_encode($result_key_time_array)); // Log::info(sizeof($result_key_time_array)); // Log::info($result_array['2014-05-01 00:00:00|U04D123']['data']); $result_final_array = array(); $index = 0; foreach ($result_key_time_array as $key_time => $result_key_time) { $new_data = $str; foreach ($fomula_array as $key_fomula => $fomula) { $key = $key_time . "|" . $key_fomula; // Log::info($key); //Log::info($result_array['2014-05-01 00:00:00|U04D123']['data']); // Log::info("[.$key_time."|".$key_fomula.]".$result_array[$key_time."|".$key_fomula]['data']); $new_data = str_replace($key_fomula, $result_array[$key]['data'], $new_data); // Log::info($result_array[$key]['data']); } $new_data = str_replace(" ", "", $new_data); $new_data = str_replace(":", ",", $new_data); $new_data = strtolower($new_data); $new_array_result_final_inner = array(); $new_array_result_final_inner['key'] = $index . "-" . $key_param; $new_array_result_final_inner['value'] = $new_data; $new_array_result_final_inner['result'] = ""; $new_array_result_final_inner['time'] = $key_time; //$result_final_array[$key_time]=$new_array_result_final_inner; array_push($result_final_array, $new_array_result_final_inner); $index++; } $result_final_json = json_encode($result_final_array); //Log::info($result_final_json); //$result_final_json=json_encode($result_final_array); $url = env('CALCULATION_HOST', 'http://localhost:3000/v1/'); $json_str = "{\n \"formula\" :{$result_final_json}\n }"; // Create a client with a base URI $client = new Client(['base_uri' => $url]); $response = $client->request('POST', 'calculation', ['body' => $json_str]); $data_result = $response->getBody(); Log::info($data_result); return $data_result; }
public function createDataEventPCVPlantow47($paramPCV, $paramUnit, $paramEmpId, $paramFromDate, $paramToDate) { Log::info("Into createDataEventPlantow47"); $sess_emp_id = Auth::user()->id; $user_mmplant = Session::get('user_mmplant'); $query = "\r\n select sys_date ,ois_event from event_raw\r\n WHERE sys_date BETWEEN '{$paramFromDate}' AND '{$paramToDate}'\r\n AND ois_event REGEXP '40SP01E131|40NB01T001|40RM41D001|40RM42D001|40NB01P003|40NB01F001|40NB32F001|40RL11F001|40RL12F001|40RL13F001|40RA03T001|40RA03P002|40RA03F001|40SD11T001|40SD11T002|40VC21T001|40RC22T001|40NB35F001|40NC03P001|40NA40L001|40SD12L001|40SD11P001|40RL64T001|40RF50T00|40RB03T001|40RB03P003|40RB03F001|40NL85M901|40NG01F901|40NM11F001|40VC41T001|40NG14P002|40NG83P003|40RL61T00z|40RH30T001|40RH20T001|40RH12P001|40RM72T001|40RM68T001|40RM64T001|40RM61T001|40RH40T002|40RH40P005|40RH40L001'\r\n order by sys_date asc \r\n "; //REGEXP '$tagName' if ($user_mmplant == 1) { if ($paramUnit == 4) { $reslutQuery = DB::connection('mysql_ais_log_47_4')->select($query); } else { if ($paramUnit == 5) { $reslutQuery = DB::connection('mysql_ais_log_47_5')->select($query); } else { if ($paramUnit == 6) { $reslutQuery = DB::connection('mysql_ais_log_47_6')->select($query); } else { if ($paramUnit == 7) { $reslutQuery = DB::connection('mysql_ais_log_47_7')->select($query); } } } } } else { if ($user_mmplant == 2) { $reslutQuery = DB::connection('mysql_ais_813')->select($query); } else { if ($user_mmplant == 3) { $reslutQuery = DB::connection('mysql_ais_fgd')->select($query); } else { $query = "select '2014-05-01 01:00:00' as 'sys_date' ,ois_event from event_raw\r\n WHERE sys_date BETWEEN '2014-10-07 00:00:00' AND '2014-10-07 16:23:00'\r\n AND ois_event REGEXP '40SP01E131|40NB01T001|40RM41D001|40RM42D001|40NB01P003|40NB01F001|40NB32F001|40RL11F001|40RL12F001|40RL13F001|40RA03T001|40RA03P002|40RA03F001|40SD11T001|40SD11T002|40VC21T001|40RC22T001|40NB35F001|40NC03P001|40NA40L001|40SD12L001|40SD11P001|40RL64T001|40RF50T00|40RB03T001|40RB03P003|40RB03F001|40NL85M901|40NG01F901|40NM11F001|40VC41T001|40NG14P002|40NG83P003|40RL61T00z|40RH30T001|40RH20T001|40RH12P001|40RM72T001|40RM68T001|40RM64T001|40RM61T001|40RH40T002|40RH40P005|40RH40L001'\r\n order by sys_date asc "; $reslutQuery = DB::connection(DBUtils::getDBName())->select($query); } } } //return json_encode($reslutQuery); /*Create File*/ $strFileName = "processView/flieProcessView/processViewJson-event-{$paramPCV}-{$paramUnit}-{$paramEmpId}.txt"; $objCreate = fopen($strFileName, 'w'); if ($objCreate) { //echo '["createJsonSuccess"]'; /*write flie here start.*/ //$strFileName = "processView/flieProcessView/processViewJson-event-$paramPCV-$paramUnit-$paramEmpId.txt"; $objFopen = fopen($strFileName, 'w'); $strText1 = json_encode($reslutQuery); fwrite($objFopen, $strText1); if ($objFopen) { echo '["createJsonSuccess"]'; } else { echo '["error"]'; } fclose($objFopen); /*write flie here end.*/ } else { echo "File Not Create."; } //http://localhost:9999/ais/processView/createDataEventPCVSteam47/11/4/11/2014-05-01%2000:00:00/2014-05-01%2001:00:00 }
public function search() { $sootView = Input::get('sootView'); $sootUnit = Input::get('sootUnit'); $sootDate = Input::get('sootDate'); Log::info('sootViewi[' . Input::get('sootView') . ']'); Log::info('sootUnit[' . Input::get('sootUnit') . ']'); Log::info('sootDate[' . Input::get('sootDate') . ']'); Log::info('into search' . Input::has('search') . 'x'); if (!Input::has('sootDate')) { $date = new DateTime(); $sootDate = date_format($date, 'd/m/Y'); } if (!Input::has('sootView')) { $sootView = '1'; } if (!Input::has('sootUnit')) { $user_mmplant = session()->get('user_mmplant'); if ($user_mmplant == '1') { $sootUnit = '4'; } else { if ($user_mmplant == '2') { $sootUnit = '8'; } } if ($user_mmplant == '3') { $sootUnit = '8'; } } $sootDates = explode("/", $sootDate); $phase_start_times = ['00:00:00', '08:00:00', '16:00:00']; $phase_end_times = ['07:59:59', '15:59:59', '23:59:59']; $columns = ['D990', 'D991', 'D992', 'D993', 'D994', 'D995', 'D996', 'D997', 'D998', 'D999']; $data_phase1 = null; $data_phase2 = null; $data_phase3 = null; $data_phase_list = [$data_phase1, $data_phase2, $data_phase3]; $data_result_phase1 = []; $data_result_phase2 = []; $data_result_phase3 = []; $data_phase_result_list = [$data_result_phase1, $data_result_phase2, $data_result_phase3]; $data_blow1 = array(); $data_blow2 = array(); $data_blow3 = array(); $data_blow_list = [$data_blow1, $data_blow2, $data_blow3]; $i = 0; for ($i = 0; $i < sizeof($data_phase_list); $i++) { $sootStartDate_phase = $sootDates[2] . "-" . $sootDates[1] . "-" . $sootDates[0] . " " . $phase_start_times[$i]; $sootEndDate_phase = $sootDates[2] . "-" . $sootDates[1] . "-" . $sootDates[0] . " " . $phase_end_times[$i]; $query = "SELECT EVTIME, D4, D990, D991, D992, D993, D994, D995, D996, D997, D998, D999\n from datau0{$sootUnit}\n WHERE EvTime BETWEEN '{$sootStartDate_phase}' AND '{$sootEndDate_phase}'"; $data_phase_list[$i] = DB::connection(DBUtils::getDBName())->select($query); $data_compare = ''; $max = 0; $k = 0; $data_time = null; foreach ($data_phase_list[$i] as $phase) { // $data_result_phase=[]; $data = ''; $haveData = false; $j = 0; foreach ($columns as $column) { if ($phase->{$column} != '0') { if ($haveData) { $data = $data . ','; } $sootNumber = $this->getSootFormat($j, $phase->{$column}); $data = $data . $sootNumber; if (empty($data_blow_list[$i][$sootNumber])) { $data_blow_list[$i][$sootNumber] = 1; } else { $data_blow_list[$i][$sootNumber] = $data_blow_list[$i][$sootNumber] + 1; } $haveData = true; } $j++; } if (empty($data)) { $data = 'No Soot Operate'; } else { $data = 'Soot=' . $data; } //$max=$phase->D4; if ($k == 0) { $data_time = $phase->EVTIME; $max = $phase->D4; $data_compare = $data; } if ($data_compare != $data) { //$phase->data=$data; //$phase->time=date_format(new DateTime($phase->EVTIME),'H:i'); //$phase->amount='Flow='.number_format($phase->D4, 2, '.', ',').' kg/s'; $phase->data = $data_compare; $phase->time = date_format(new DateTime($data_time), 'H:i'); $phase->amount = 'Flow=' . number_format($max, 2, '.', ',') . ' kg/s'; array_push($data_phase_result_list[$i], $phase); // reset $data_compare = $data; $max = $phase->D4; $data_time = $phase->EVTIME; } if ($phase->D4 > $max) { $max = $phase->D4; } if ($k == sizeof($data_phase_list[$i]) - 1) { //Log::info('lasted ['.$data_time.'],max ['.$max.']'); $phase->data = $data_compare; $phase->time = date_format(new DateTime($data_time), 'H:i'); $phase->amount = 'Flow=' . number_format($max, 2, '.', ',') . ' kg/s'; array_push($data_phase_result_list[$i], $phase); } $k++; // Log::info('phase1 ['.$i++.']['.date_format(new DateTime($phase->EVTIME),'H:i').']['.number_format($phase->D4, 2, '.', ',').']='.$phase->data); } // Log::info('sootCount_list ['.sizeof($data_blow_list[$i]).']'); } /* return view('ais/soot_blower',['sootDate'=>$sootDate,'sootView'=>$sootView, 'data_phase_list'=>$data_phase_list,'data_blow_list'=>$data_blow_list]); */ return view('ais/soot_blower', ['sootDate' => $sootDate, 'sootView' => $sootView, 'data_phase_list' => $data_phase_result_list, 'data_blow_list' => $data_blow_list]); }
/** * Remove the specified resource from storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function deleteSelect(Request $request) { Log::info("deleteSelect "); $checkboxs_hidden = Input::get('checkboxs_hidden'); $checkboxs_explode = explode("_", $checkboxs_hidden); for ($i = 0; $i < sizeof($checkboxs_explode); $i++) { if (!empty($checkboxs_explode[$i])) { Log::info(" [" . $i . "]" . $checkboxs_explode[$i]); MmcalculationModel::on(DBUtils::getDBName())->find($checkboxs_explode[$i])->delete(); } } return redirect('ais/designCalculation'); }