Exemplo n.º 1
0
 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)]);
 }
Exemplo n.º 2
0
 /**
  * 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]);
 }
Exemplo n.º 3
0
 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]);
 }
Exemplo n.º 4
0
 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);
 }
Exemplo n.º 5
0
 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');
 }
Exemplo n.º 6
0
 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)]);
 }
Exemplo n.º 7
0
 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');
 }
Exemplo n.º 8
0
 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);
 }
Exemplo n.º 9
0
 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;
 }
Exemplo n.º 10
0
 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
 }
Exemplo n.º 11
0
 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]);
 }
Exemplo n.º 12
0
 /**
  * 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');
 }