id(); $user = Staff::with('StaffDetail')->find($id); $site = SiteSetting::first(); $company = Company::where('_id', $cid)->withTrashed()->first(); $staff = Staff::with('StaffDetail')->where('company_id', $cid)->where('roles_access','Installer')->withTrashed()->get(); $total_docket = 0; $total_rating = 0; if(!empty($staff)){ foreach($staff as $s){ $t_rating = 0; $total_docket += count(Docket::where('installer_id',$s->_id)->get()); $docket = Docket::where('installer_id',$s->_id)->get(); if(!empty($docket)){ foreach($docket as $d){ $t_rating += $d->Rating1 + $d->Rating2 + $d->Rating3; } } $total_rating += $t_rating; } } return view('v3.main-dashboard.team.overall_rating', compact('user','site','company','total_docket','total_rating')); } function random_color_part() { return str_pad( dechex( mt_rand( 0, 255 ) ), 2, '0', STR_PAD_LEFT); } function random_color() { return $this->random_color_part() . $this->random_color_part() . $this->random_color_part(); } /** * Create vendor list * * @return post */ public function viewVendorContractor() { $id = Auth::guard('main')->id(); $user = Staff::with('StaffDetail')->find($id); $site = SiteSetting::first(); return view('v3.main-dashboard.team.vendor_contractor_list',compact('user','site')); } public function viewVendorContractorForm() { $id = Auth::guard('main')->id(); $user = Staff::with('StaffDetail')->find($id); $site = SiteSetting::first(); $colors = array(); for($i = 0; $i < 19; $i++){ $colors[] = '#'.$this->random_color(); } return view('v3.main-dashboard.team.add_new_vendor_contractor', compact('user','site','colors')); } public function viewVendorDealer() { $id = Auth::guard('main')->id(); $user = Staff::with('StaffDetail')->find($id); $site = SiteSetting::first(); return view('v3.main-dashboard.team.vendor_dealer_list',compact('user','site')); } public function requestAddVendor(Request $request){ $sl = Company::create([ 'name' => $request->cname, "address" => $request->address, "city" => $request->city, "state" => $request->state, "postcode" => $request->postcode, "color" => $request->color, "team" => $request->team, ]); return redirect()->back()->with('success_msg', 'Success! add '.$request->get('cname').' as new vendor'); } public function editVendorDetail($staff,$vendor){ $id = Auth::guard('main')->id(); $user = Staff::with('StaffDetail')->find($id); $site = SiteSetting::first(); $vendor = Company::find($vendor); return view('v3.main-dashboard.team.edit_vendor_detail', compact('user','site','vendor')); } public function requestEditVendor(Request $request){ $company = Company::where('_id',$request->company_id)->first(); if(!empty($company)){ $company->name = $request->cname; $company->address = $request->address; $company->city = $request->city; $company->state = $request->state; $company->postcode = $request->postcode; $company->save(); return redirect()->back()->with('success_msg', 'Success! update '.$request->get('cname').' detail '); }else { return redirect()->back()->with('error_msg', 'Failed! update '.$request->get('cname').' detail. No company exist!'); } } public function viewVendorDealerForm() { $id = Auth::guard('main')->id(); $user = Staff::with('StaffDetail')->find($id); $site = SiteSetting::first(); $colors = array(); for($i = 0; $i < 19; $i++){ $colors[] = '#'.$this->random_color(); } return view('v3.main-dashboard.team.add_new_vendor_dealer', compact('user','site','colors')); } /** * Create staff list * * @return post */ public function viewContractorList() { $id = Auth::guard('main')->id(); $user = Staff::with('StaffDetail')->find($id); $site = SiteSetting::first(); return view('v3.main-dashboard.team.contractor_list',compact('user','site')); } public function viewMainAgentList() { $id = Auth::guard('main')->id(); $user = Staff::with('StaffDetail')->find($id); $site = SiteSetting::first(); return view('v3.main-dashboard.team.main_agent_list',compact('user','site')); } public function viewStaffForm($roles) { $id = Auth::guard('main')->id(); $user = Staff::with('StaffDetail')->find($id); $site = SiteSetting::first(); $company = ''; if($roles == 'Contractor' || $roles == 'contractor'){ $company = Company::where('team','CBB')->orderBy('name', 'ASC')->get(); }else if($roles == 'Dealer' || $roles == 'dealer'){ $company = Company::where('team','Dealer')->orderBy('name', 'ASC')->get(); } return view('v3.main-dashboard.team.add_new_staff', compact('user','site','company','roles')); } public function requestAddStaff(Request $request){ $validator = Validator::make($request->all(), [ 'password' => 'min:6|confirmed', ]); if ($validator->fails()) { return redirect()->back()->withInput()->withErrors($validator); } if($request->role == 'Contractor' || $request->role == 'contractor'){ $position = 'Contractor'; }else if($request->role == 'Dealer' || $request->role == 'dealer'){ $position = 'Dealer'; } $encrP = $this->encryptPassword('encrypt', $request->password); $encrP2 = Hash::make($request->get('password')); $company = Company::where('_id',$request->vendor)->first(); if(!empty($company)){ $exist = Staff::with('StaffDetail')->where('email',$request->email)->where('roles_access','Contractor')->first(); if(empty($exist)){ $sl = Staff::create([ 'email' => $request->email, 'password' => $encrP, 'password2' => $encrP2, 'roles_access' => $position, 'company_id' => $request->vendor, 'last_login_at' => '', 'last_login_ip'=> '', 'company_id' => $request->vendor, 'authorized' => false, 'token_firebase' => '', ]); $sdl = new StaffDetail(); $sdl->name = $request->name; $sdl->ic = $request->ic; $sdl->email = $request->email; $sdl->phone = $request->phone; $sdl->company_id = $request->vendor; $sdl->color = $company->color; $sdl->position = $position; $sdl->password = $encrP; $sdl->password2 = $encrP2; $sdl->user_pic = 'uploads/profile/user.png'; $company->staff()->save($sl); $company->save(); $sl->staffdetail()->save($sdl); return redirect()->back()->with('success_msg', 'Success! add '.$request->get('aname').' as new contractor '); }else { return redirect()->back()->withInput()->with('error_msg', 'Staff contractor with '.$request->email.' already exist!'); } }else { return redirect()->back()->withInput()->with('error_msg', 'Record company not found!'); } } public function editStaffDetail($type,$_id) { $id = Auth::guard('main')->id(); $user = Staff::with('StaffDetail')->find($id); $site = SiteSetting::first(); $staff = Staff::with('StaffDetail')->where('_id', $_id)->first(); $current_company = Company::where('_id', $staff->company_id)->first(); $company = Company::where('team', $current_company->team)->get(); return view('v3.main-dashboard.team.edit_staff_detail',compact('user','site','company','staff','type')); } public function requestEditStaff(Request $request){ $exist = Staff::with('StaffDetail')->where('_id',$request->_id)->first(); $company = Company::where('_id',$request->vendor)->first(); if(empty($exist)){ return redirect()->back()->withInput()->withErrors('staff not found'); }else { if(!empty($company)){ $exist->email = $request->email; $exist->company_id = $request->vendor; $exist->save(); $exist->StaffDetail->name = $request->name; $exist->StaffDetail->ic = $request->ic; $exist->StaffDetail->email = $request->email; $exist->StaffDetail->phone = $request->phone; $exist->StaffDetail->company_id = $request->vendor; $exist->StaffDetail->save(); $company->staff()->save($exist); $company->save(); return redirect()->back()->with('success_msg', 'Success! update detail staff '.$request->get('name').''); }else{ return redirect()->back()->withInput()->with('error_msg', 'Record company not found!'); } } } }