public function postRepairCreate($timestamp = "0") { $input = Input::all(); $dd = new DateTime('NOW'); $y = $dd->format('Y'); $m = $dd->format('m'); $d = $dd->format('d'); if ($m >= 10) { $btw1 = $y . "-10-01"; $btw2 = $y + 1 . "-09-30"; $slash = substr($y + 544, 2, 2); } if ($m < 10) { $btw1 = $y - 1 . "-10-01"; $btw2 = $y . "-09-30"; $slash = substr($y + 543, 2, 2); } $num = DB::table('tb_durable_repair')->whereBetween('repair_date', array($btw1, $btw2))->max('id_get_year') + 1; $auto_set = DB::table('tb_durable_repair')->select('auto_set_get_name')->orderBy('repair_id', 'desc')->take(1)->get(); switch ($auto_set) { case '': $next_auto_set = "1"; break; case '1': $next_auto_set = "2"; break; default: $next_auto_set = "1"; break; } $get_id = str_pad($num, 5, '0', STR_PAD_LEFT); $s = $get_id . "/" . $slash; $repair = new DurableRepair(); $repair->id_get_year = $num; $repair->repair_id_get = $s; $repair->repair_id_dept = $input['repair_id_dept']; $repair->repair_date = \Helpers\Helper::fromJSDate(Input::get('hdd_repair_date')); $repair->dept_id = $input['dept_id']; $repair->sub_dept_id = $input['sub_dept_id']; // $repair->sub_dept2 = $input['sub_dept2']; // $repair->tel = $input['tel']; if (Input::has('urgency')) { $repair->urgency = $input['urgency']; } if (Input::has('risk')) { $repair->risk = $input['risk']; } if (Input::has('important_work')) { $repair->important_work = $input['important_work']; } if (Input::has('amount')) { $repair->amount = $input['amount']; } $repair->repair_type = $input['repair_type']; $repair->ruin_type = $input['ruin_type']; $repair->ruin = $input['ruin']; $repair->durable_id = $input['durable_id']; $repair->repair_name = $input['repair_name']; $repair->repair_get_name = $input['repair_get_name']; $repair->repair_status_report = '0'; $repair->repair_status = '0'; $repair->insert_date = $dd->format('Y-m-d'); $repair->insert_time = $dd->format('H:i:s'); $repair->insert_from_ip = $_SERVER['REMOTE_ADDR']; $repair->insert_id = 1; ///// $repair->auto_set_get_name = $next_auto_set; $repair->callcenter_date = \Carbon\Carbon::createFromTimeStamp(Crypt::decrypt($timestamp))->toDateTimeString(); $repair->repair_technician_name = $input['repair_techician_name']; $repair->save(); return Redirect::to('durable/repair-list' . '#' . $repair->repair_id); }
public function postHelpFix() { $input = Input::all(); $dd = new DateTime('NOW'); $y = $dd->format('Y'); $m = $dd->format('m'); $d = $dd->format('d'); if ($m >= 10) { $btw1 = $y . "-10-01"; $btw2 = $y + 1 . "-09-30"; $slash = substr($y + 544, 2, 2); } if ($m < 10) { $btw1 = $y - 1 . "-10-01"; $btw2 = $y . "-09-30"; $slash = substr($y + 543, 2, 2); } $num = DB::table('tb_durable_repair')->whereBetween('repair_date', array($btw1, $btw2))->max('id_get_year') + 1; $auto_set = DB::table('tb_durable_repair')->select('auto_set_get_name')->orderBy('repair_id', 'desc')->take(1)->get(); switch ($auto_set) { case '': $next_auto_set = "1"; break; case '1': $next_auto_set = "2"; break; default: $next_auto_set = "1"; break; } $s = $num . "/" . $slash; $get_id = str_pad($num, 5, '0', STR_PAD_LEFT); $dr = new DurableRepair(); $dr->id_get_year = $num; $dr->repair_id_get = $get_id . "/" . $slash; $dr->repair_date = $dd->format('Y-m-d'); $dr->dept_id = $input['dept_id']; $dr->sub_dept_id = $input['sub_dept_id']; $dr->sub_dept2 = $input['sub_dept_name']; $dr->tel = $input['tel']; $dr->repair_type = '1'; $dr->ruin_type = $input['ruin_type_id']; $dr->ruin = $input['ruin']; $dr->repair_name = $input['contact_name']; $dr->repair_status_report = '0'; $dr->repair_status = '0'; $dr->insert_date = $dd->format('Y-m-d'); $dr->insert_time = $dd->format('H:i:s'); $dr->insert_from_ip = $_SERVER['REMOTE_ADDR']; $dr->auto_set_get_name = $next_auto_set; $dr->symptom = $input['symptoms_id']; $dr->urgency = $input['urgency']; $dr->important_work = $input['important_work']; $dr->risk = $input['risk']; $dr->save(); $helpdesk = Helpdesk::find($input['helpdesk_id']); $helpdesk->repair_id = $dr->repair_id; $helpdesk->save(); return Redirect::to('helpdesk/help-message/' . Crypt::encrypt($dr->repair_id)); }