private function getDurable($status_id, $skip, $take = 20, $search = "")
{
//sleep(1);
$durable_repair = DurableRepair::leftJoin('tb_sub_dept as sd', 'tb_durable_repair.sub_dept_id', '=', 'sd.sub_dept_id')->leftJoin('tb_durable as td', 'tb_durable_repair.durable_id', '=', 'td.durable_id')->leftJoin('tb_repair_status as trs', 'tb_durable_repair.repair_status', '=', 'trs.repair_status_id')->select('tb_durable_repair.repair_id', 'tb_durable_repair.repair_date', 'tb_durable_repair.durable_id', 'tb_durable_repair.repair_name', 'tb_durable_repair.sub_dept_id', 'sd.sub_dept_name', 'tb_durable_repair.sub_dept2', 'tb_durable_repair.ruin', 'tb_durable_repair.repair_status_report', 'tb_durable_repair.repair_status', 'tb_durable_repair.repair_result', 'tb_durable_repair.repair_out', 'tb_durable_repair.buy_replace', 'tb_durable_repair.repair_out_status', 'trs.repair_status_name', 'tb_durable_repair.approve_status', 'tb_durable_repair.close_job_date', 'tb_durable_repair.repair_technician_get_date')->whereNotNull('tb_durable_repair.repair_id')->where('tb_durable_repair.repair_status', '=', $status_id)->orderBy('tb_durable_repair.repair_date', 'desc')->orderBy('tb_durable_repair.repair_id', 'desc');
if (is_null($search) == false) {
$durable_repair->Where(function ($query) use($search) {
$query->where('tb_durable_repair.ruin', 'like', '%' . $search . '%')->orWhere('tb_durable_repair.repair_id', 'like', '%' . $search . '%');
});
}
return $durable_repair->skip($skip)->take($take)->get();
}
public function getHelpMessage($id)
{
$repair = DurableRepair::find(Crypt::decrypt($id));
$dept_name = DB::table('tb_dept')->where('dept_id', '=', $repair->dept_id)->first()->dept_name;
$technical_name = DB::table('tb_technical')->where('technic_id', '=', $repair->repair_technician_name)->first();
return View::make('helpdesk.help_message')->with(compact('repair', 'dept_name', 'technical_name'));
}
