id(); $user = Staff::with('StaffDetail')->find($id); $site = SiteSetting::first(); $coverage = Coverage::where('Type','R')->orderBy('building_name')->get(); $agentList = Staff::with('StaffDetail')->where('company_id',$user->company_id)->get(); return view('v3.main-dealer.application_form', compact('user','site','coverage','agentList')); } /*** /* Pending Form **/ public function pendingForm(){ $id = Auth::guard('dealer')->id(); $user = Staff::with('StaffDetail')->find($id); $site = SiteSetting::first(); $coverage = Coverage::where('Type','R')->orderBy('building_name')->get(); $agentList = Staff::with('StaffDetail')->where('company_id',$user->company_id)->get(); return view('v3.main-dealer.pending_form', compact('user','site','coverage','agentList')); } /*** /* Activated Form **/ public function activatedFormResidential(){ $id = Auth::guard('dealer')->id(); $user = Staff::with('StaffDetail')->find($id); $site = SiteSetting::first(); $coverage = Coverage::where('Type','R')->orderBy('building_name')->get(); $agentList = Staff::with('StaffDetail')->where('company_id',$user->company_id)->get(); return view('v3.main-dealer.completed_form', compact('user','site','coverage','agentList')); } /*** /* Rejected Form **/ public function rejectedForm(){ $id = Auth::guard('dealer')->id(); $user = Staff::with('StaffDetail')->find($id); $site = SiteSetting::first(); $coverage = Coverage::where('Type','R')->orderBy('building_name')->get(); $agentList = Staff::with('StaffDetail')->where('company_id',$user->company_id)->get(); return view('v3.main-dealer.rejected_form', compact('user','site','coverage','agentList')); } /*** /* Application Online **/ public function applicationPackage($type){ $id = Auth::guard('dealer')->id(); $user = Staff::with('StaffDetail')->find($id); $today = Carbon::now(); $site = SiteSetting::first(); if($type == 'residential'){ $type = 'R'; }else if($type == 'business'){ $type = 'B'; } return view('v3.main-dealer.application_package', compact('user','site','today','coverage','type')); } public function residentialPackageID($_id){ $id = Auth::guard('dealer')->id(); $user = Staff::with('StaffDetail')->find($id); $today = Carbon::now(); $site = SiteSetting::first(); $coverage = Coverage::where('Type','R')->orderBy('building_name')->get(); $product = Product::where('formT','R')->orderBy('created_at','ASC')->get(); $country = Country::orderBy('name','ASC')->get(); $form = Form::with('Subscriber','PackageDetail')->where('_id',$_id)->first(); return view('v3.main-dealer.residential_package_id', compact('user','site','today','coverage','product','country','form')); } public function businessPackageID($_id){ $id = Auth::guard('dealer')->id(); $user = Staff::with('StaffDetail')->find($id); $today = Carbon::now(); $site = SiteSetting::first(); $coverage = Coverage::where('Type','B')->orderBy('building_name')->get(); $product = Product::where('formT','B')->orderBy('created_at','ASC')->get(); $country = Country::orderBy('name','ASC')->get(); $form = Form::with('Subscriber','PackageDetail')->where('_id',$_id)->first(); return view('v3.main-dealer.business_package_id', compact('user','site','today','coverage','product','country','form')); } /*** /* Form Details **/ public function viewFormDetail($subscriber){ $id = Auth::guard('dealer')->id(); $user = Staff::with('StaffDetail')->find($id); $site = SiteSetting::first(); $subsc = Subscriber::where('subscriber_id',$subscriber)->withTrashed()->first(); $form = Form::with('subscribetrashed','packagedetailtrashed')->where('_id', $subsc->id)->withTrashed()->first(); $country = Country::orderBy('name','ASC')->get(); if($form->type_application == 'R'){ $coverage = Coverage::where('Type','R')->get(); if(empty($coverage)){ $coverage = 'null'; } }else if($form->type_application == 'B'){ $coverage = Coverage::where('Type','B')->get(); if(empty($coverage)){ $coverage = 'null'; } } if(isset($form->company_id)){ $company = Company::where('_id', $form->company_id)->first(); $company = $company->name; $agent = Staff::with('StaffDetail')->where('_id', $form->dealer_id)->first(); $agent = $agent->StaffDetail->name; }else{ $company = 'null'; $agent = 'null'; } return view('v3.main-dealer.view_customer_detail', compact('user','site','form','company','agent','coverage','country')); } public function updateFormDetail(Request $request){ $id = Auth::guard('dealer')->id(); $user = Staff::with('StaffDetail')->find($id); $subscriber = Subscriber::with('formtrashed')->where('subscriber_id',$request->subscriber_id)->withTrashed()->first(); if(!empty($subscriber)){ $form = Form::with('subscribetrashed','packagedetailtrashed')->where('_id', $subscriber->id)->withTrashed()->first(); if(!empty($form)){ if($subscriber->formtrashed->type_application == 'R'){ $street = '-'; if($request->has('street')){ $street = $request->street; } $cov = Coverage::where('building_name',$request->building)->where('Type','R')->first(); $subscriber->name = $request->name; $subscriber->ic = $request->ic; $subscriber->email = $request->email; $subscriber->phone1 = $request->phone1; $subscriber->phone2 = $request->phone2; $subscriber->unit_no = $request->unit_no; $subscriber->building_name = $cov->building_name; $subscriber->street = $request->street; $subscriber->city = $cov->city; $subscriber->postcode = $cov->postcode; $subscriber->state = $cov->state; $subscriber->save(); $destinationPath = 'document/'.$subscriber->subscriber_id; // create folder/dir if not exist if(!File::exists(public_path().'/'.$destinationPath)){ File::makeDirectory(public_path().'/'.$destinationPath,0777,true); } if($request->hasfile('front_ic')){ $icon = $request->file('front_ic'); $icon->move($destinationPath,'frontic.'.$icon->getClientOriginalExtension()); $pathIconF = '/'.$destinationPath.'/frontic.'.$icon->getClientOriginalExtension(); $subscriber->front_ic = $pathIconF; $subscriber->save(); } if($request->hasfile('back_ic')){ $icon = $request->file('back_ic'); $icon->move($destinationPath,'backic.'.$icon->getClientOriginalExtension()); $pathIconB = '/'.$destinationPath.'/backic.'.$icon->getClientOriginalExtension(); $subscriber->back_ic = $pathIconB; $subscriber->save(); } if($request->hasfile('visaF')){ $icon = $request->file('visaF'); $icon->move($destinationPath,'visaF.'.$icon->getClientOriginalExtension()); $pathVisaF = '/'.$destinationPath.'/visaF.'.$icon->getClientOriginalExtension(); $subscriber->visaF = $pathVisaF; $subscriber->save(); } if($request->hasfile('visaB')){ $icon = $request->file('visaB'); $icon->move($destinationPath,'visaB.'.$icon->getClientOriginalExtension()); $pathVisaB = '/'.$destinationPath.'/visaB.'.$icon->getClientOriginalExtension(); $subscriber->visaB = $pathVisaB; $subscriber->save(); } }else if($subscriber->formtrashed->type_application == 'B'){ $fax = '-'; if($request->has('company_fax')){ $fax = $request->company_fax; } $subscriber->company_reg = $request->company_reg; $subscriber->company_num = $request->company_num; $subscriber->company_fax = $fax; $subscriber->company_name = $request->company_name; $subscriber->unit_no = $request->unit_no; $subscriber->street = $request->address; $subscriber->city = $request->city; $subscriber->postcode = $request->postcode; $subscriber->state = $request->state; $subscriber->name = $request->name; $subscriber->ic = $request->ic; $subscriber->designation = $request->designation; $subscriber->email = $request->email; $subscriber->phone1 = $request->phone1; $subscriber->phone2 = $request->phone2; $subscriber->created_at = Carbon::now(); $subscriber->save(); $destinationPath = 'document/'.$subscriber->subscriber_id; // create folder/dir if not exist if(!File::exists(public_path().'/'.$destinationPath)){ File::makeDirectory(public_path().'/'.$destinationPath,0777,true); } if($request->hasfile('front_ic')){ $icon = $request->file('front_ic'); $icon->move($destinationPath,'frontic.'.$icon->getClientOriginalExtension()); $pathIconF = '/'.$destinationPath.'/frontic.'.$icon->getClientOriginalExtension(); $subscriber->front_ic = $pathIconF; $subscriber->save(); } if($request->hasfile('back_ic')){ $icon = $request->file('back_ic'); $icon->move($destinationPath,'backic.'.$icon->getClientOriginalExtension()); $pathIconB = '/'.$destinationPath.'/backic.'.$icon->getClientOriginalExtension(); $subscriber->back_ic = $pathIconB; $subscriber->save(); } if($request->hasfile('form9')){ $icon = $request->file('form9'); $icon->move($destinationPath,'formD.'.$icon->getClientOriginalExtension()); $pathForm9 = '/'.$destinationPath.'/formD.'.$icon->getClientOriginalExtension(); $subscriber->form9_44 = $pathForm9; $subscriber->save(); } if($request->hasfile('form_24')){ $icon = $request->file('form_24'); $icon->move($destinationPath,'formA_B.'.$icon->getClientOriginalExtension()); $pathForm24 = '/'.$destinationPath.'/formA_B.'.$icon->getClientOriginalExtension(); $subscriber->form24_49 = $pathForm24; $subscriber->save(); } if($request->hasfile('visaF')){ $icon = $request->file('visaF'); $icon->move($destinationPath,'visaF.'.$icon->getClientOriginalExtension()); $pathVisaF = '/'.$destinationPath.'/visaF.'.$icon->getClientOriginalExtension(); $subscriber->visaF = $pathVisaF; $subscriber->save(); } if($request->hasfile('visaB')){ $icon = $request->file('visaB'); $icon->move($destinationPath,'visaB.'.$icon->getClientOriginalExtension()); $pathVisaB = '/'.$destinationPath.'/visaB.'.$icon->getClientOriginalExtension(); $subscriber->visaB = $pathVisaB; $subscriber->save(); } } $form->created_at = Carbon::now(); $form->save(); if(!empty($form->subscribetrashed)){ $form->subscribetrashed()->restore(); } if(!empty($form->packagedetailtrashed)){ $form->packagedetailtrashed()->restore(); } $form->restore(); $formH = new FormStatus; $formH->form_id = $form->_id; $formH->status_id = $st_id; $formH->date = new \MongoDB\BSON\UTCDateTime(time()*1000); $formH->status = 'Resubmitted'; $formH->desc = 'The form alreaady been resubmited by dealer/sales'; $form->formstatus()->save($formH); return redirect('v3/dealer/subscription/submitted-form'); }else { return redirect()->back()->with('error_msg', 'Form not exist!'); } }else { return redirect()->back()->with('error_msg', 'Subscriber Id Not Found!'); } } }