| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351 |
- <?php
-
- namespace App\Http\Controllers\v3\Dealer;
-
- use Illuminate\Http\Request;
- use App\Http\Controllers\Controller;
- use Illuminate\Support\Facades\Auth;
-
- use Carbon\Carbon;
- use Validator;
- use File;
-
- use App\SiteSetting;
- use App\LatestModel\Staff;
- use App\LatestModel\StaffDetail;
- use App\LatestModel\Module\Form;
- use App\LatestModel\Module\Subscriber;
- use App\LatestModel\Module\WorkOrder;
- use App\LatestModel\Module\PackageDetail;
- use App\LatestModel\Module\Company;
- use App\LatestModel\Module\Coverage;
- use App\LatestModel\Module\Product;
- use App\LatestModel\Module\Docket;
- use App\LatestModel\Module\Country;
- use App\LatestModel\Module\FormStatus;
-
- class ApplicationController extends Controller
- {
- function random_code($limit) {
- return substr(base_convert(sha1(uniqid(mt_rand())), 16, 36), 0, $limit);
- }
-
- /***
- /* Application Form
- **/
- public function applicationForm(){
- $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.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!');
- }
- }
- }
|