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));
}
