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