id(); $user = Staff::with('StaffDetail')->find($id); $site = SiteSetting::first(); $coverage = Coverage::where('Type','R')->orderBy('building_name')->get(); $all = count(WorkOrder::where('contractor_id', $user->company_id)->get()); $pp = count(WorkOrder::where('status','Pending Non Prelaid')->where('contractor_id', $user->company_id)->get()); $cm = count(WorkOrder::where('status','Completed')->where('contractor_id', $user->company_id)->get()); $pc = count(WorkOrder::where('status','Pending Contractor')->where('contractor_id', $user->company_id)->get()); $pi = count(WorkOrder::where('status','Pending Installer')->where('contractor_id', $user->company_id)->get()); return view('v3.main-contractor.work_order.contractor', compact('user','site','coverage','all','pp','cm','pc','pi')); } public function pendingNonPrelaid(){ $id = Auth::guard('main-contractor')->id(); $user = Staff::with('StaffDetail')->find($id); $site = SiteSetting::first(); $coverage = Coverage::where('Type','R')->orderBy('building_name')->get(); $all = count(WorkOrder::where('contractor_id', $user->company_id)->get()); $pp = count(WorkOrder::where('status','Pending Non Prelaid')->where('contractor_id', $user->company_id)->get()); $cm = count(WorkOrder::where('status','Completed')->where('contractor_id', $user->company_id)->get()); $pc = count(WorkOrder::where('status','Pending Contractor')->where('contractor_id', $user->company_id)->get()); $pi = count(WorkOrder::where('status','Pending Installer')->where('contractor_id', $user->company_id)->get()); return view('v3.main-contractor.work_order.pending_non_prelaid', compact('user','site','coverage','all','pp','cm','pc','pi')); } public function installer(){ $id = Auth::guard('main-contractor')->id(); $user = Staff::with('StaffDetail')->find($id); $site = SiteSetting::first(); $coverage = Coverage::where('Type','R')->orderBy('building_name')->get(); $all = count(WorkOrder::where('contractor_id', $user->company_id)->get()); $pp = count(WorkOrder::where('status','Pending Non Prelaid')->where('contractor_id', $user->company_id)->get()); $cm = count(WorkOrder::where('status','Completed')->where('contractor_id', $user->company_id)->get()); $pc = count(WorkOrder::where('status','Pending Contractor')->where('contractor_id', $user->company_id)->get()); $pi = count(WorkOrder::where('status','Pending Installer')->where('contractor_id', $user->company_id)->get()); return view('v3.main-contractor.work_order.installer', compact('user','site','coverage','all','pp','cm','pc','pi')); } public function completed(){ $id = Auth::guard('main-contractor')->id(); $user = Staff::with('StaffDetail')->find($id); $site = SiteSetting::first(); $coverage = Coverage::where('Type','R')->orderBy('building_name')->get(); $all = count(WorkOrder::where('contractor_id', $user->company_id)->get()); $pp = count(WorkOrder::where('status','Pending Non Prelaid')->where('contractor_id', $user->company_id)->get()); $cm = count(WorkOrder::where('status','Completed')->where('contractor_id', $user->company_id)->get()); $pc = count(WorkOrder::where('status','Pending Contractor')->where('contractor_id', $user->company_id)->get()); $pi = count(WorkOrder::where('status','Pending Installer')->where('contractor_id', $user->company_id)->get()); return view('v3.main-contractor.work_order.completed', compact('user','site','coverage','company','all','all','pp','cm','pc','pi')); } /** * Create confirm work order detail controller. * * @return view */ public function viewWorkOrderDetailForm($wo){ $id = Auth::guard('main-contractor')->id(); $user = Staff::with('StaffDetail')->find($id); $site = SiteSetting::first(); $w = WorkOrder::where('wo',$wo)->first(); $form = Form::with('Subscriber','WorkOrder')->where('_id',$w->_id)->first(); $coverage = Coverage::where('Type', $form->type_application)->orderBy('building_name','ASC')->get(); $company = Company::where('_id',$w->contractor_id)->first(); return view('v3.main-contractor.work_order.view_work_order_detail_form', compact('user','site','w','company','form','coverage')); } /** * Create edit work order detail controller. * * @return view */ public function editWorkOrderDetailForm($wo){ $id = Auth::guard('main-contractor')->id(); $user = Staff::with('StaffDetail')->find($id); $site = SiteSetting::first(); $w = WorkOrder::where('wo',$wo)->first(); $form = Form::with('Subscriber','WorkOrder')->where('_id',$w->_id)->first(); $coverage = Coverage::where('Type', $form->type_application)->orderBy('building_name','ASC')->get(); $company = Company::where('_id',$w->contractor_id)->first(); return view('v3.main-contractor.work_order.edit_work_order_detail_form', compact('user','site','w','company','form','coverage')); } /** * Create update work order detail controller. * * @return post */ public function updateWorkOrder(Request $request){ $id = Auth::guard('main-contractor')->id(); $user = Staff::with('StaffDetail')->find($id); $wo = WorkOrder::where('wo',$request->work_order)->first(); if(!empty($wo)){ $wo->remarks_custservice = $request->remark; $wo->save(); return redirect('/v3/main-contractor/work-order/pending-contractor'); }else { return redirect()->back()->with('error_msg', 'Cant update work order '.$request->get('work_order')); } } /** * Create send work order to contractor by email controller. * * @return post */ public function sendWorkOrdersByEmail($work_order_id) { $work_order = WorkOrder::where('wo',$work_order_id)->first(); $s = StaffDetail::where('company_id',$work_order->contractor_id)->where('position','Contractor')->get(); $customer = Subscriber::where('_id',$work_order->_id)->first(); if($work_order->contractor_id == '5b42b935ee0dc2b707473b76'){ $company = Company::where('_id',$work_order->contractor_id)->first(); $staff = StaffDetail::where('company_id',$work_order->contractor_id)->where('email','mimi@jitech.com.my')->first(); SendWorkOrder::dispatch($work_order,$staff,'cbbinstallation@jitech.com.my',$customer,$company); }else { $company = Company::where('_id',$work_order->contractor_id)->first(); foreach($s as $staff){ SendWorkOrder::dispatch($work_order,$staff,$staff->email,$customer,$company); } } } }