orderBy('created_at', 'desc')->get(); }else if($package == 'null' && $dealer != 'null'){ $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('company_id', $dealer)->get(); }else if($package == 'R' && $building == 'null' && $dealer == 'null'){ $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->get(); }else if($package == 'R' && $building == 'null' && $dealer != 'null'){ $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->where('company_id', $dealer)->get(); }else if($package == 'R' && $building != 'null' && $dealer == 'null'){ $form = Form::with(['Subscriber' => function($q) use($building) { $q->where('building_name', $building); }],'PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->get(); }else if($package == 'R' && $building != 'null' && $dealer != 'null'){ $form = Form::with(['Subscriber' => function($q) use($building) { $q->where('building_name', $building); }],'PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->where('company_id', $dealer)->get(); }else if($package == 'B' && $dealer == 'null'){ $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->get(); }else if($package == 'B' && $dealer != 'null'){ $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->where('company_id', $dealer)->get(); } }else if($startdate != '-'){ $dateS = Carbon::createFromFormat('Y-m-d', $startdate); $start = $dateS->copy()->startOfDay(); if($enddate != '-'){ $dateE = Carbon::createFromFormat('Y-m-d', $enddate); $end = $dateE->copy()->endOfDay(); }else{ $end = $dateS->copy()->endOfDay(); } if($package == 'null' && $dealer == 'null'){ $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->whereBetween('created_at', array($start, $end))->get(); }else if($package == 'null' && $dealer != 'null'){ $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('company_id', $dealer)->whereBetween('created_at',[$start, $end])->get(); }else if($package == 'R' && $building == 'null' && $dealer == 'null'){ $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->whereBetween('created_at',[$start, $end])->get(); }else if($package == 'R' && $building == 'null' && $dealer != 'null'){ $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->whereBetween('created_at',[$start, $end])->where('company_id', $dealer)->get(); }else if($package == 'R' && $building != 'null' && $dealer == 'null'){ $form = Form::with(['Subscriber' => function($q) use($building) { $q->where('building_name', $building); }],'PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->whereBetween('created_at',[$start, $end])->get(); }else if($package == 'R' && $building != 'null' && $dealer != 'null'){ $form = Form::with(['Subscriber' => function($q) use($building) { $q->where('building_name', $building); }],'PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->where('company_id', $dealer)->whereBetween('created_at',[$start, $end])->get(); }else if($package == 'B' && $dealer == 'null'){ $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->whereBetween('created_at',[$start, $end])->get(); }else if($package == 'B' && $dealer != 'null'){ $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->whereBetween('created_at',[$start, $end])->where('company_id', $dealer)->get(); } } return $form; } public function displayApplicationData($startdate,$enddate,$type,$package,$building,$dealer,$agent){ $i = 0; $curr = Carbon::now()->getTimestamp(); $nested_data = array(); $form = $this->getApplicationData($startdate,$enddate,$type,$package,$building,$dealer,$agent); if(!empty($form)){ foreach ($form as $key => $f) { if($f->type_service != 'Rectification'){ if($f->status_form != 'Draft' || empty($f->status_form)){ $nP = ''; $n1 = ''; $labelD = ''; $agentN = ''; $reg_time = $f->created_at; $expiry_date = $reg_time->addDays(3); $expiry_date = $expiry_date->getTimestamp(); if($curr < $expiry_date) { $n1 = 'New/'; }else{ $n1 = ''; } if(empty($f->WorkOrder) && !empty($f->Subscriber) && !empty($f->PackageDetail) && !$f->trashed()){ $wo = ''; $work_order = ''; $building = ''; $unit = '-'; $address = ''; /*** Package ***/ if($f->PackageDetail->voice_fee == 'Yes' || $f->PackageDetail->voice_fee == 'YES'){ $nP = 'Yes'; }else if($f->PackageDetail->voice_fee == 'No' || $f->PackageDetail->voice_fee == 'NO'){ $nP = 'No'; }else if($f->PackageDetail->voice_fee == ''){ $nP = '-'; } /*** Generate Work Order ID ***/ do { $work_order = 'WO-'.$this->createWorkID(4); if($f->status_email == 'verified'){ $wo = $work_order.'/'.$f->Subscriber->subscriber_id; }else{ $wo = ''; } } while (WorkOrder::where("wo", "=", $work_order)->first() instanceof WorkOrder); if($f->type_application == 'R'){ $building = $f->Subscriber->building_name; $unit = $f->Subscriber->unit_no; if($f->Subscriber->street != ''){ $address = $f->Subscriber->street. ' , '.$f->Subscriber->postcode. ' , '.$f->Subscriber->city. ' , '.$f->Subscriber->state; }else { $address = $f->Subscriber->postcode. ' , '.$f->Subscriber->city. ' , '.$f->Subscriber->state; } $cov = Coverage::where('building_name',$f->Subscriber->building_name)->where('Type','R')->first(); if(!empty($cov)){ if($cov->status_building == 'non prelaid'){ $wo = 'Non/'.$wo; } } }else if($f->type_application == 'B'){ if($f->Subscriber->unit_no == ''){ $unit = '-'; }else { $unit = $f->Subscriber->unit_no; } $building = $f->Subscriber->company_name; $address = $f->Subscriber->street. ' , '.$f->Subscriber->postcode. ' , '.$f->Subscriber->city. ' , '.$f->Subscriber->state; $cov = Coverage::where('building_name',$f->Subscriber->building_name)->where('Type','B')->first(); if(!empty($cov)){ if($cov->status_building == 'non prelaid'){ $wo = 'Non/'.$wo; } } } if(!empty($f->dealer_id)){ $company = Company::where('_id', $f->company_id)->first(); $com = explode(' ',trim($company->name)); $labelD = 'D/'.$com[0].'.'; $agentN = Staff::with('StaffDetail')->where('_id', $f->dealer_id)->first(); $agentN = $agentN->StaffDetail->name; }else{ $labelD = ''; $agentN = ''; } if($f->type_service == $type){ if($agent == 'null'){ $i++; array_push($nested_data, array( 'formT' => $n1.$i.$f->type_application, 'date' => $f->created_at->toDateTimeString(), 'type' => $f->type_service, 'name' => $labelD.$f->Subscriber->name, 'phone' => $f->Subscriber->phone1, 'postcode' => $f->Subscriber->postcode, 'city' => $f->Subscriber->city, 'unit' => $unit, 'building' => $building, 'street' => $address, 'need_phone' => $nP, 'email' => $f->status_email, 'action1' => $wo, 'action2' => $f->_id, 'agent' => $agentN )); }else if($f->dealer_id == $agent){ $i++; array_push($nested_data, array( 'formT' => $n1.$i.$f->type_application, 'date' => $f->created_at->toDateTimeString(), 'type' => $f->type_service, 'name' => $labelD.$f->Subscriber->name, 'phone' => $f->Subscriber->phone1, 'postcode' => $f->Subscriber->postcode, 'city' => $f->Subscriber->city, 'unit' => $unit, 'building' => $building, 'street' => $address, 'need_phone' => $nP, 'email' => $f->status_email, 'action1' => $wo, 'action2' => $f->_id, 'agent' => $agentN )); } }else if($type == 'null'){ if($agent == 'null'){ $i++; array_push($nested_data, array( 'formT' => $n1.$i.$f->type_application, 'date' => $f->created_at->toDateTimeString(), 'type' => $f->type_service, 'name' => $labelD.$f->Subscriber->name, 'phone' => $f->Subscriber->phone1, 'postcode' => $f->Subscriber->postcode, 'city' => $f->Subscriber->city, 'unit' => $unit, 'building' => $building, 'street' => $address, 'need_phone' => $nP, 'email' => $f->status_email, 'action1' => $wo, 'action2' => $f->_id, 'agent' => $agentN )); }else if($f->dealer_id == $agent){ $i++; array_push($nested_data, array( 'formT' => $n1.$i.$f->type_application, 'date' => $f->created_at->toDateTimeString(), 'type' => $f->type_service, 'name' => $labelD.$f->Subscriber->name, 'phone' => $f->Subscriber->phone1, 'postcode' => $f->Subscriber->postcode, 'city' => $f->Subscriber->city, 'unit' => $unit, 'building' => $building, 'street' => $address, 'need_phone' => $nP, 'email' => $f->status_email, 'action1' => $wo, 'action2' => $f->_id, 'agent' => $agentN )); } } } } } } } return \DataTables::of($nested_data)->make(true); } public function displayRectificationData($startdate,$enddate,$type,$package,$building,$dealer,$agent){ $i = 0; $curr = Carbon::now()->getTimestamp(); $nested_data = array(); $form = $this->getApplicationData($startdate,$enddate,$type,$package,$building,$dealer,$agent); if(!empty($form)){ foreach ($form as $key => $f) { if($f->type_service == $type){ $wo = ''; $n1 = ''; $do = ''; $reg_time = $f->created_at; $expiry_date = $reg_time->addDays(3); $expiry_date = $expiry_date->getTimestamp(); if($curr < $expiry_date) { $n1 = 'New/'; }else{ $n1 = ''; } if(!empty($f->Subscriber) && !empty($f->PackageDetail)){ if(!empty($f->WorkOrder)){ $wo = $f->WorkOrder->wo; if($f->WorkOrder->status == "Completed"){ $doc = Docket::where('work_order_id',$f->WorkOrder->wo)->first(); if(!empty($doc)){ $do = $doc->docket_id; } }else{ $do = ""; } } if($f->type_application == 'R'){ $building = $f->Subscriber->building_name; $unit = $f->Subscriber->unit_no; if($f->Subscriber->street != ''){ $address = $f->Subscriber->street; }else { $address = '-'; } }else if($f->type_application == 'B'){ if($f->Subscriber->unit_no == ''){ $unit = '-'; }else { $unit = $f->Subscriber->unit_no; } $building = $f->Subscriber->company_name; $address = $f->Subscriber->street; } $i++; array_push($nested_data, array( 'formT' => $n1.$i.$f->type_application, 'submittion' => Carbon::parse($f->created_at)->toDateString(), 'type' => $f->type_service, 'name' => $f->Subscriber->name, 'phone' => $f->Subscriber->phone1, 'unit' => $unit, 'building' => $building, 'street' => $address, 'postcode' => $f->Subscriber->postcode, 'city' => $f->Subscriber->city, 'action1' => $f->_id, 'action2' => $wo, 'action3' => $do )); } } } } return \DataTables::of($nested_data)->make(true); } public function displayPendingData($startdate,$enddate,$type,$package,$building,$dealer,$agent){ $i = 0; $curr = Carbon::now()->getTimestamp(); $nested_data = array(); $form = $this->getApplicationData($startdate,$enddate,$type,$package,$building,$dealer,$agent); if(!empty($form)){ foreach ($form as $key => $f) { if($f->type_service != 'Rectification'){ $wo = ''; $n1 = ''; $do = ''; $agentN = ''; $reg_time = $f->created_at; $expiry_date = $reg_time->addDays(3); $expiry_date = $expiry_date->getTimestamp(); if(!empty($f->Subscriber) && !empty($f->PackageDetail) && !empty($f->WorkOrder)){ if($f->WorkOrder->status != "Completed"){ $wo = $f->WorkOrder->wo; if($f->type_application == 'R'){ $building = $f->Subscriber->building_name; $unit = $f->Subscriber->unit_no; if($f->Subscriber->street != ''){ $address = $f->Subscriber->street; }else { $address = '-'; } }else if($f->type_application == 'B'){ if($f->Subscriber->unit_no == ''){ $unit = '-'; }else { $unit = $f->Subscriber->unit_no; } $building = $f->Subscriber->company_name; $address = $f->Subscriber->street; } if(!empty($f->dealer_id)){ $company = Company::where('_id', $f->company_id)->first(); $com = explode(' ',trim($company->name)); $labelD = 'D/'.$com[0].'.'; $agentN = Staff::with('StaffDetail')->where('_id', $f->dealer_id)->first(); $agentN = $agentN->StaffDetail->name; }else{ $labelD = ''; $agentN = ''; } if($f->type_service == $type){ if($agent == 'null'){ $i++; array_push($nested_data, array( 'formT' => $n1.$i.$f->type_application, 'submittion' => Carbon::parse($f->created_at)->toDateString(), 'type' => $f->type_service, 'name' => $labelD.$f->Subscriber->name, 'phone' => $f->Subscriber->phone1, 'unit' => $unit, 'building' => $building, 'street' => $address, 'postcode' => $f->Subscriber->postcode, 'city' => $f->Subscriber->city, 'action1' => $f->_id, 'action2' => $wo, 'agent' => $agentN )); }else if($f->dealer_id == $agent){ $i++; array_push($nested_data, array( 'formT' => $n1.$i.$f->type_application, 'submittion' => Carbon::parse($f->created_at)->toDateString(), 'type' => $f->type_service, 'name' => $labelD.$f->Subscriber->name, 'phone' => $f->Subscriber->phone1, 'unit' => $unit, 'building' => $building, 'street' => $address, 'postcode' => $f->Subscriber->postcode, 'city' => $f->Subscriber->city, 'action1' => $f->_id, 'action2' => $wo, 'agent' => $agentN )); } }else if($type == 'null'){ if($agent == 'null'){ $i++; array_push($nested_data, array( 'formT' => $n1.$i.$f->type_application, 'submittion' => Carbon::parse($f->created_at)->toDateString(), 'type' => $f->type_service, 'name' => $labelD.$f->Subscriber->name, 'phone' => $f->Subscriber->phone1, 'unit' => $unit, 'building' => $building, 'street' => $address, 'postcode' => $f->Subscriber->postcode, 'city' => $f->Subscriber->city, 'action1' => $f->_id, 'action2' => $wo, 'agent' => $agentN )); }else if($f->dealer_id == $agent){ $i++; array_push($nested_data, array( 'formT' => $n1.$i.$f->type_application, 'submittion' => Carbon::parse($f->created_at)->toDateString(), 'type' => $f->type_service, 'name' => $labelD.$f->Subscriber->name, 'phone' => $f->Subscriber->phone1, 'unit' => $unit, 'building' => $building, 'street' => $address, 'postcode' => $f->Subscriber->postcode, 'city' => $f->Subscriber->city, 'action1' => $f->_id, 'action2' => $wo, 'agent' => $agentN )); } } } } } } } return \DataTables::of($nested_data)->make(true); } public function displayActivatedData($startdate,$enddate,$type,$package,$building,$dealer,$agent){ $i = 0; $curr = Carbon::now()->getTimestamp(); $nested_data = array(); $form = $this->getApplicationData($startdate,$enddate,$type,$package,$building,$dealer,$agent); if(!empty($form)){ foreach ($form as $key => $f) { if($f->type_service != 'Rectification'){ $wo = ''; $n1 = ''; $do = ''; $agentN = ''; $reg_time = $f->created_at; $expiry_date = $reg_time->addDays(3); $expiry_date = $expiry_date->getTimestamp(); if($curr < $expiry_date) { $n1 = 'New/'; }else{ $n1 = ''; } if(!empty($f->Subscriber) && !empty($f->PackageDetail) && !empty($f->WorkOrder)){ if($f->WorkOrder->status == "Completed"){ $wo = $f->WorkOrder->wo; $doc = Docket::where('work_order_id',$wo)->first(); if(!empty($doc)){ $do = $doc->docket_id; if($f->type_application == 'R'){ $building = $f->Subscriber->building_name; $unit = $f->Subscriber->unit_no; if($f->Subscriber->street != ''){ $address = $f->Subscriber->street; }else { $address = '-'; } }else if($f->type_application == 'B'){ if($f->Subscriber->unit_no == ''){ $unit = '-'; }else { $unit = $f->Subscriber->unit_no; } $building = $f->Subscriber->company_name; $address = $f->Subscriber->street; } if(!empty($f->dealer_id)){ $company = Company::where('_id', $f->company_id)->first(); $com = explode(' ',trim($company->name)); $labelD = 'D/'.$com[0].'.'; $agentN = Staff::with('StaffDetail')->where('_id', $f->dealer_id)->first(); $agentN = $agentN->StaffDetail->name; }else{ $labelD = ''; $agentN = ''; } if($f->type_service == $type){ if($agent == 'null'){ $i++; array_push($nested_data, array( 'formT' => $n1.$i.$f->type_application, 'submittion' => Carbon::parse($f->created_at)->toDateString(), 'type' => $f->type_service, 'name' => $labelD.$f->Subscriber->name, 'phone' => $f->Subscriber->phone1, 'unit' => $unit, 'building' => $building, 'street' => $address, 'postcode' => $f->Subscriber->postcode, 'city' => $f->Subscriber->city, 'action1' => $f->_id, 'action2' => $wo, 'action3' => $do, 'action4' => $wo, 'agent' => $agentN )); }else if($f->dealer_id == $agent){ $i++; array_push($nested_data, array( 'formT' => $n1.$i.$f->type_application, 'submittion' => Carbon::parse($f->created_at)->toDateString(), 'type' => $f->type_service, 'name' => $labelD.$f->Subscriber->name, 'phone' => $f->Subscriber->phone1, 'unit' => $unit, 'building' => $building, 'street' => $address, 'postcode' => $f->Subscriber->postcode, 'city' => $f->Subscriber->city, 'action1' => $f->_id, 'action2' => $wo, 'action3' => $do, 'action4' => $wo, 'agent' => $agentN )); } }else if($type == 'null'){ if($agent == 'null'){ $i++; array_push($nested_data, array( 'formT' => $n1.$i.$f->type_application, 'submittion' => Carbon::parse($f->created_at)->toDateString(), 'type' => $f->type_service, 'name' => $labelD.$f->Subscriber->name, 'phone' => $f->Subscriber->phone1, 'unit' => $unit, 'building' => $building, 'street' => $address, 'postcode' => $f->Subscriber->postcode, 'city' => $f->Subscriber->city, 'action1' => $f->_id, 'action2' => $wo, 'action3' => $do, 'action4' => $wo, 'agent' => $agentN )); }else if($f->dealer_id == $agent){ $i++; array_push($nested_data, array( 'formT' => $n1.$i.$f->type_application, 'submittion' => Carbon::parse($f->created_at)->toDateString(), 'type' => $f->type_service, 'name' => $labelD.$f->Subscriber->name, 'phone' => $f->Subscriber->phone1, 'unit' => $unit, 'building' => $building, 'street' => $address, 'postcode' => $f->Subscriber->postcode, 'city' => $f->Subscriber->city, 'action1' => $f->_id, 'action2' => $wo, 'action3' => $do, 'action4' => $wo, 'agent' => $agentN )); } } } } } } } } return \DataTables::of($nested_data)->make(true); } public function getDealerForm($startdate,$enddate,$type,$package,$building,$dealer,$agent){ if($startdate == '-' && $enddate == '-'){ if($package == 'null' && $dealer == 'null'){ $form = Form::with('Subscriber','PackageDetail','WorkOrder')->whereNotNull('dealer_id')->orderBy('created_at', 'desc')->get(); }else if($package == 'null' && $dealer != 'null'){ $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('company_id', $dealer)->get(); }else if($package == 'R' && $building == 'null' && $dealer == 'null'){ $form = Form::with('Subscriber','PackageDetail','WorkOrder')->whereNotNull('dealer_id')->orderBy('created_at', 'desc')->where('type_application', $package)->get(); }else if($package == 'R' && $building == 'null' && $dealer != 'null'){ $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->where('company_id', $dealer)->get(); }else if($package == 'R' && $building != 'null' && $dealer == 'null'){ $form = Form::with(['Subscriber' => function($q) use($building) { $q->where('building_name', $building); }],'PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->whereNotNull('dealer_id')->where('type_application', $package)->get(); }else if($package == 'R' && $building != 'null' && $dealer != 'null'){ $form = Form::with(['Subscriber' => function($q) use($building) { $q->where('building_name', $building); }],'PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->where('company_id', $dealer)->get(); }else if($package == 'B' && $dealer == 'null'){ $form = Form::with('Subscriber','PackageDetail','WorkOrder')->whereNotNull('dealer_id')->orderBy('created_at', 'desc')->where('type_application', $package)->get(); }else if($package == 'B' && $dealer != 'null'){ $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->where('company_id', $dealer)->get(); } }else if($startdate != '-'){ $dateS = Carbon::createFromFormat('Y-m-d', $startdate); $start = $dateS->copy()->startOfDay(); if($enddate != '-'){ $dateE = Carbon::createFromFormat('Y-m-d', $enddate); $end = $dateE->copy()->endOfDay(); }else{ $end = $dateS->copy()->endOfDay(); } if($package == 'null' && $dealer == 'null'){ $form = Form::with('Subscriber','PackageDetail','WorkOrder')->whereNotNull('dealer_id')->orderBy('created_at', 'desc')->whereBetween('created_at', array($start, $end))->get(); }else if($package == 'null' && $dealer != 'null'){ $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('company_id', $dealer)->whereBetween('created_at',[$start, $end])->get(); }else if($package == 'R' && $building == 'null' && $dealer == 'null'){ $form = Form::with('Subscriber','PackageDetail','WorkOrder')->whereNotNull('dealer_id')->orderBy('created_at', 'desc')->where('type_application', $package)->whereBetween('created_at',[$start, $end])->get(); }else if($package == 'R' && $building == 'null' && $dealer != 'null'){ $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->whereBetween('created_at',[$start, $end])->where('company_id', $dealer)->get(); }else if($package == 'R' && $building != 'null' && $dealer == 'null'){ $form = Form::with(['Subscriber' => function($q) use($building) { $q->where('building_name', $building); }],'PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->whereNotNull('dealer_id')->where('type_application', $package)->whereBetween('created_at',[$start, $end])->get(); }else if($package == 'R' && $building != 'null' && $dealer != 'null'){ $form = Form::with(['Subscriber' => function($q) use($building) { $q->where('building_name', $building); }],'PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->where('company_id', $dealer)->whereBetween('created_at',[$start, $end])->get(); }else if($package == 'B' && $dealer == 'null'){ $form = Form::with('Subscriber','PackageDetail','WorkOrder')->whereNotNull('dealer_id')->orderBy('created_at', 'desc')->where('type_application', $package)->whereBetween('created_at',[$start, $end])->get(); }else if($package == 'B' && $dealer != 'null'){ $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->whereBetween('created_at',[$start, $end])->where('company_id', $dealer)->get(); } } return $form; } public function displayDealerForm($startdate,$enddate,$type,$package,$building,$dealer,$agent){ $i = 0; $curr = Carbon::now()->getTimestamp(); $nested_data = array(); $form = $this->getDealerForm($startdate,$enddate,$type,$package,$building,$dealer,$agent); if(!empty($form)){ foreach ($form as $key => $f) { $wo = ''; $n1 = ''; $do = ''; $agentN = ''; $reg_time = $f->created_at; $expiry_date = $reg_time->addDays(3); $expiry_date = $expiry_date->getTimestamp(); if($curr < $expiry_date) { $n1 = 'New/'; }else{ $n1 = ''; } if(!empty($f->dealer_id)){ $company = Company::where('_id', $f->company_id)->first(); $com = explode(' ',trim($company->name)); $labelD = 'D/'.$com[0].'.'; $agentN = Staff::with('StaffDetail')->where('_id', $f->dealer_id)->first(); $agentN = $agentN->StaffDetail->name; if(!empty($f->Subscriber) && !empty($f->PackageDetail)){ if(!empty($f->WorkOrder)){ $wo = $f->WorkOrder->wo; if($f->WorkOrder->status == "Completed"){ $doc = Docket::where('work_order_id',$wo)->first(); if(!empty($doc)){ $do = $doc->docket_id; } } } if($f->type_application == 'R'){ $building = $f->Subscriber->building_name; $unit = $f->Subscriber->unit_no; if($f->Subscriber->street != ''){ $address = $f->Subscriber->street; }else { $address = '-'; } }else if($f->type_application == 'B'){ if($f->Subscriber->unit_no == ''){ $unit = '-'; }else { $unit = $f->Subscriber->unit_no; } $building = $f->Subscriber->company_name; $address = $f->Subscriber->street; } if($f->type_service == $type){ if($agent == 'null'){ $i++; array_push($nested_data, array( 'formT' => $n1.$i.$f->type_application, 'submittion' => Carbon::parse($f->created_at)->toDateString(), 'type' => $f->type_service, 'name' => $labelD.$f->Subscriber->name, 'phone' => $f->Subscriber->phone1, 'unit' => $unit, 'building' => $building, 'street' => $address, 'postcode' => $f->Subscriber->postcode, 'city' => $f->Subscriber->city, 'action1' => $f->_id, 'action2' => $wo, 'action3' => $do, 'action4' => $wo, 'agent' => $agentN )); }else if($f->dealer_id == $agent){ $i++; array_push($nested_data, array( 'formT' => $n1.$i.$f->type_application, 'submittion' => Carbon::parse($f->created_at)->toDateString(), 'type' => $f->type_service, 'name' => $labelD.$f->Subscriber->name, 'phone' => $f->Subscriber->phone1, 'unit' => $unit, 'building' => $building, 'street' => $address, 'postcode' => $f->Subscriber->postcode, 'city' => $f->Subscriber->city, 'action1' => $f->_id, 'action2' => $wo, 'action3' => $do, 'action4' => $wo, 'agent' => $agentN )); } }else if($type == 'null'){ if($agent == 'null'){ $i++; array_push($nested_data, array( 'formT' => $n1.$i.$f->type_application, 'submittion' => Carbon::parse($f->created_at)->toDateString(), 'type' => $f->type_service, 'name' => $labelD.$f->Subscriber->name, 'phone' => $f->Subscriber->phone1, 'unit' => $unit, 'building' => $building, 'street' => $address, 'postcode' => $f->Subscriber->postcode, 'city' => $f->Subscriber->city, 'action1' => $f->_id, 'action2' => $wo, 'action3' => $do, 'action4' => $wo, 'agent' => $agentN )); }else if($f->dealer_id == $agent){ $i++; array_push($nested_data, array( 'formT' => $n1.$i.$f->type_application, 'submittion' => Carbon::parse($f->created_at)->toDateString(), 'type' => $f->type_service, 'name' => $labelD.$f->Subscriber->name, 'phone' => $f->Subscriber->phone1, 'unit' => $unit, 'building' => $building, 'street' => $address, 'postcode' => $f->Subscriber->postcode, 'city' => $f->Subscriber->city, 'action1' => $f->_id, 'action2' => $wo, 'action3' => $do, 'action4' => $wo, 'agent' => $agentN )); } } } } } } return \DataTables::of($nested_data)->make(true); } /** * Create Data Form controller. * * @return json */ public function filterByTypeADate($type, $startdate, $enddate){ if($type == 'All' && $startdate == 'null'){ $form = Form::with('Subscriber','PackageDetail')->orderBy('created_at', 'desc'); return $form; }else if($type == 'All' && $startdate != 'null'){ $dateS = Carbon::createFromFormat('Y-m-d', $startdate); $start = $dateS->copy()->startOfDay(); $dateE = Carbon::createFromFormat('Y-m-d', $enddate); $end = $dateE->copy()->endOfDay(); $form = Form::with('Subscriber','PackageDetail')->orderBy('created_at', 'desc')->whereBetween('created_at', array($start, $end)); return $form; }else if($type != 'All' && $startdate == 'null'){ $form = Form::with('Subscriber','PackageDetail')->where('type_service',$type)->orderBy('created_at', 'desc'); return $form; }else if($type != 'All' && $startdate == 'null'){ $dateS = Carbon::createFromFormat('Y-m-d', $startdate); $start = $dateS->copy()->startOfDay(); $dateE = Carbon::createFromFormat('Y-m-d', $enddate); $end = $dateE->copy()->endOfDay(); $form = Form::with('Subscriber','PackageDetail')->where('type_service',$type)->orderBy('created_at', 'desc')->whereBetween('created_at', array($start, $end)); return $form; } } public function filterByPackage($type,$startdate,$enddate,$package){ $form = $this->filterByTypeADate($type,$startdate,$enddate); if($package == 'All'){ return $form; }else{ $form = $form->where('type_application', $package); return $form; } } public function filterByBuilding($type,$startdate,$enddate,$package,$building){ $form = $this->filterByPackage($type,$startdate,$enddate,$package); if($building == 'null'){ return $form->with('Subscriber'); }else{ return $form->with(['Subscriber' => function($q) use($building) { $q->where('building_name', $building); }]); } } public function filterByDealer($type,$startdate,$enddate,$package,$building,$dealer){ $form = $this->filterByBuilding($type,$startdate,$enddate,$package,$building); if($dealer != 'null'){ $form = $form->where('company_id', $dealer); return $form; }else{ return $form; } } public function filterByAgent($type,$startdate,$enddate,$package,$building,$dealer,$agent){ $form = $this->filterByDealer($type,$startdate,$enddate,$package,$building,$dealer); if($agent == 'null'){ return $form; }else{ $form = $form->where('dealer_id', $agent); return $form; } } public function displayNewData($type,$startdate,$enddate,$package,$building,$dealer,$agent,$subcriber){ if($dealer != 'null' && $agent != 'null'){ $form = $this->filterByAgent($type,$startdate,$enddate,$package,$building,$dealer,$agent); }else if($dealer != 'null' && $agent == 'null'){ $form = $this->filterByDealer($type,$startdate,$enddate,$package,$building,$dealer); }else if($dealer == 'null' && $agent == 'null'){ $form = $this->filterByDealer($type,$startdate,$enddate,$package,$building,$dealer); } if($subcriber != 'null'){ $form = $form->with(['Subscriber' => function($q) use($subcriber) { $q->where('subscriber_id', 'CBB-'.$subcriber); }],'PackageDetail','WorkOrder')->get(); }else{ $form = $form->with('PackageDetail','WorkOrder')->get(); } $i = 0; $curr = Carbon::now()->getTimestamp(); $nested_data = array(); if(!empty($form)){ foreach ($form as $key => $f) { $n1 = ''; $labelD = ''; $agent = ''; $name = ''; $reg_time = $f->created_at; $expiry_date = $reg_time->addDays(3); $expiry_date = $expiry_date->getTimestamp(); if($curr < $expiry_date) { $n1 = 'New/'; }else{ $n1 = ''; } if(!empty($f->dealer_id)){ $company = Company::where('_id', $f->company_id)->first(); $com = explode(' ',trim($company->name)); $labelD = 'D/'.$com[0].'.'; $agent = Staff::with('StaffDetail')->where('_id', $f->dealer_id)->first(); $agent = $agent->StaffDetail->name; }else{ $labelD = ''; } if(!empty($f->Subscriber) && !empty($f->PackageDetail) && empty($f->WorkOrder) && $f->type_service != "Rectification"){ $wo = ''; $work_order = ''; $building = ''; $unit = '-'; $address = ''; /*** Package ***/ if($f->PackageDetail->voice_fee == 'Yes' || $f->PackageDetail->voice_fee == 'YES'){ $nP = 'Yes'; }else if($f->PackageDetail->voice_fee == 'No' || $f->PackageDetail->voice_fee == 'NO'){ $nP = 'No'; }else if($f->PackageDetail->voice_fee == ''){ $nP = '-'; } /*** Generate Work Order ID ***/ do { $work_order = 'WO-'.$this->createWorkID(4); if($f->status_email == 'verified'){ $wo = $work_order.'/'.$f->Subscriber->subscriber_id; }else{ $wo = ''; } } while (WorkOrder::where("wo", "=", $work_order)->first() instanceof WorkOrder); if($f->type_application == 'R'){ $name = $f->Subscriber->name; $building = $f->Subscriber->building_name; $unit = $f->Subscriber->unit_no; if($f->Subscriber->street != ''){ $address = $f->Subscriber->street. ', '.$f->Subscriber->postcode. ' , '.$f->Subscriber->city. ', '.$f->Subscriber->state; }else { $address = $f->Subscriber->postcode. ', '.$f->Subscriber->city. ', '.$f->Subscriber->state; } }else if($f->type_application == 'B'){ if($f->Subscriber->unit_no == ''){ $unit = '-'; }else { $unit = $f->Subscriber->unit_no; } $name = $f->Subscriber->company_name; $building = $f->Subscriber->building_name; $address = $f->Subscriber->street. ', '.$f->Subscriber->postcode. ', '.$f->Subscriber->city. ', '.$f->Subscriber->state; } $i++; array_push($nested_data, array( 'formT' => $n1.$i.$f->type_application, 'date' => $f->created_at->toDateString(), 'id' => str_replace("CBB-","",$f->Subscriber->subscriber_id), 'type' => $f->type_service, 'name' => $labelD.$f->Subscriber->name, 'phone' => $f->Subscriber->phone1, 'unit' => $unit, 'building' => $building, 'street' => $address, 'agent' => $agent, 'type' => $f->type_service, 'need_phone' => $nP, 'email' => $f->status_email, 'action' => $f->_id, 'action1' => $wo, )); } } } return \DataTables::of($nested_data)->make(true); } public function displayProcessData($type,$startdate,$enddate,$package,$building,$dealer,$agent,$subcriber){ if($dealer != 'null' && $agent != 'null'){ $form = $this->filterByAgent($type,$startdate,$enddate,$package,$building,$dealer,$agent); }else if($dealer != 'null' && $agent == 'null'){ $form = $this->filterByDealer($type,$startdate,$enddate,$package,$building,$dealer); } if($subcriber != 'null'){ $form = $form->with(['Subscriber' => function($q) use($subcriber) { $q->where('subscriber_id', 'CBB-'.$subcriber); }],'PackageDetail','WorkOrder')->get(); }else{ $form = $form->with('PackageDetail','WorkOrder')->get(); } $i = 0; $curr = Carbon::now()->getTimestamp(); $nested_data = array(); if(!empty($form)){ foreach ($form as $key => $f) { $n1 = ''; $labelD = ''; $agent = ''; $name = ''; $reg_time = $f->created_at; $expiry_date = $reg_time->addDays(3); $expiry_date = $expiry_date->getTimestamp(); if($curr < $expiry_date) { $n1 = 'New/'; }else{ $n1 = ''; } if(!empty($f->dealer_id)){ $company = Company::where('_id', $f->company_id)->first(); $com = explode(' ',trim($company->name)); $labelD = 'D/'.$com[0].'.'; $agent = Staff::with('StaffDetail')->where('_id', $f->dealer_id)->first(); $agent = $agent->StaffDetail->name; }else{ $labelD = ''; } if(!empty($f->Subscriber) && !empty($f->PackageDetail) && !empty($f->WorkOrder)){ if($f->type_application == 'R'){ $name = $f->Subscriber->name; $building = $f->Subscriber->building_name; $unit = $f->Subscriber->unit_no; if($f->Subscriber->street != ''){ $address = $f->Subscriber->street. ', '.$f->Subscriber->postcode. ' , '.$f->Subscriber->city. ', '.$f->Subscriber->state; }else { $address = $f->Subscriber->postcode. ', '.$f->Subscriber->city. ', '.$f->Subscriber->state; } }else if($f->type_application == 'B'){ if($f->Subscriber->unit_no == ''){ $unit = '-'; }else { $unit = $f->Subscriber->unit_no; } $name = $f->Subscriber->company_name; $building = $f->Subscriber->building_name; $address = $f->Subscriber->street. ', '.$f->Subscriber->postcode. ', '.$f->Subscriber->city. ', '.$f->Subscriber->state; } $i++; if($f->WorkOrder->status != 'Completed'){ array_push($nested_data, array( 'formT' => $n1.$i.$f->type_application, 'wo' => $f->WorkOrder->wo, 'date' => $f->created_at->toDateString(), 'id' => str_replace("CBB-","",$f->Subscriber->subscriber_id), 'type' => $f->type_service, 'name' => $labelD.$f->Subscriber->name, 'phone' => $f->Subscriber->phone1, 'unit' => $unit, 'building' => $building, 'street' => $address, 'agent' => $agent, 'action' => $f->_id, )); } } } } return \DataTables::of($nested_data)->make(true); } public function displayCompletedData($type,$startdate,$enddate,$package,$building,$dealer,$agent,$subcriber){ if($dealer != 'null' && $agent != 'null'){ $form = $this->filterByAgent($type,$startdate,$enddate,$package,$building,$dealer,$agent); }else if($dealer != 'null' && $agent == 'null'){ $form = $this->filterByDealer($type,$startdate,$enddate,$package,$building,$dealer); } if($subcriber != 'null'){ $form = $form->with(['Subscriber' => function($q) use($subcriber) { $q->where('subscriber_id', 'CBB-'.$subcriber); }],'PackageDetail','WorkOrder')->get(); }else{ $form = $form->with('PackageDetail','WorkOrder')->get(); } $i = 0; $curr = Carbon::now()->getTimestamp(); $nested_data = array(); if(!empty($form)){ foreach ($form as $key => $f) { $n1 = ''; $labelD = ''; $agent = ''; $name = ''; $reg_time = $f->created_at; $expiry_date = $reg_time->addDays(3); $expiry_date = $expiry_date->getTimestamp(); if($curr < $expiry_date) { $n1 = 'New/'; }else{ $n1 = ''; } if(!empty($f->dealer_id)){ $company = Company::where('_id', $f->company_id)->first(); $com = explode(' ',trim($company->name)); $labelD = 'D/'.$com[0].'.'; $agent = Staff::with('StaffDetail')->where('_id', $f->dealer_id)->first(); $agent = $agent->StaffDetail->name; }else{ $labelD = ''; } if(!empty($f->Subscriber) && !empty($f->PackageDetail) && !empty($f->WorkOrder)){ if($f->type_application == 'R'){ $name = $f->Subscriber->name; $building = $f->Subscriber->building_name; $unit = $f->Subscriber->unit_no; if($f->Subscriber->street != ''){ $address = $f->Subscriber->street. ', '.$f->Subscriber->postcode. ' , '.$f->Subscriber->city. ', '.$f->Subscriber->state; }else { $address = $f->Subscriber->postcode. ', '.$f->Subscriber->city. ', '.$f->Subscriber->state; } }else if($f->type_application == 'B'){ if($f->Subscriber->unit_no == ''){ $unit = '-'; }else { $unit = $f->Subscriber->unit_no; } $name = $f->Subscriber->company_name; $building = $f->Subscriber->building_name; $address = $f->Subscriber->street. ', '.$f->Subscriber->postcode. ', '.$f->Subscriber->city. ', '.$f->Subscriber->state; } $i++; if($f->WorkOrder->status == 'Completed'){ $doc = Docket::where('work_order_id',$f->WorkOrder->wo)->first(); $activated = '-'; $do = '-'; if(!empty($doc)){ $do = $doc->docket_id; $activated = $doc->end_job; } array_push($nested_data, array( 'formT' => $n1.$i.$f->type_application, 'wo' => $f->WorkOrder->wo, 'do' => $do, 'active' => $activated, 'id' => str_replace("CBB-","",$f->Subscriber->subscriber_id), 'type' => $f->type_service, 'name' => $labelD.$f->Subscriber->name, 'phone' => $f->Subscriber->phone1, 'unit' => $unit, 'building' => $building, 'street' => $address, 'agent' => $agent, 'action' => $f->_id, )); } } } } return \DataTables::of($nested_data)->make(true); } /** * Create Trashed Data Form controller. * * @return json */ public function filterTrashedByTypeADate($type, $startdate, $enddate){ if($type == 'All' && $startdate == 'null'){ $form = Form::with('subscribetrashed','packagedetailtrashed')->orderBy('created_at', 'desc')->onlyTrashed(); return $form; }else if($type == 'All' && $startdate != 'null'){ $dateS = Carbon::createFromFormat('Y-m-d', $startdate); $start = $dateS->copy()->startOfDay(); $dateE = Carbon::createFromFormat('Y-m-d', $enddate); $end = $dateE->copy()->endOfDay(); $form = Form::with('subscribetrashed','packagedetailtrashed')->orderBy('created_at', 'desc')->whereBetween('created_at', array($start, $end))->onlyTrashed(); return $form; } } public function filterTrashedByPackage($type,$startdate,$enddate,$package){ $form = $this->filterTrashedByTypeADate($type,$startdate,$enddate); if($package == 'All'){ return $form; }else{ $form = $form->where('type_application', $package); return $form; } } public function filterTrashedByBuilding($type,$startdate,$enddate,$package,$building){ $form = $this->filterTrashedByPackage($type,$startdate,$enddate,$package); if($building == 'null'){ return $form->with('subscribetrashed'); }else{ return $form->with(['subscribetrashed' => function($q) use($building) { $q->where('building_name', $building); }]); } } public function filterTrashedByDealer($type,$startdate,$enddate,$package,$building,$dealer){ $form = $this->filterTrashedByBuilding($type,$startdate,$enddate,$package,$building); if($dealer != 'null'){ $form = $form->where('company_id', $dealer); return $form; }else{ return $form; } } public function filterTrashedByAgent($type,$startdate,$enddate,$package,$building,$dealer,$agent){ $form = $this->filterTrashedByDealer($type,$startdate,$enddate,$package,$building,$dealer); if($agent == 'null'){ return $form; }else{ $form = $form->where('dealer_id', $agent); return $form; } } public function displayTrashedData($type,$startdate,$enddate,$package,$building,$dealer,$agent,$subcriber){ if($dealer != 'null' && $agent != 'null'){ $form = $this->filterTrashedByAgent($type,$startdate,$enddate,$package,$building,$dealer,$agent); }else if($dealer != 'null' && $agent == 'null'){ $form = $this->filterTrashedByDealer($type,$startdate,$enddate,$package,$building,$dealer); }else if($dealer == 'null' && $agent == 'null'){ $form = $this->filterTrashedByDealer($type,$startdate,$enddate,$package,$building,$dealer); } if($subcriber != 'null'){ $form = $form->with(['subscribetrashed' => function($q) use($subcriber) { $q->where('subscriber_id', 'CBB-'.$subcriber); }],'packagedetailtrashed')->get(); }else{ $form = $form->with('packagedetailtrashed')->get(); } $i = 0; $curr = Carbon::now()->getTimestamp(); $nested_data = array(); if(!empty($form)){ foreach ($form as $key => $f) { $n1 = ''; $labelD = ''; $agent = ''; $name = ''; $reg_time = $f->created_at; $expiry_date = $reg_time->addDays(3); $expiry_date = $expiry_date->getTimestamp(); if($curr < $expiry_date) { $n1 = 'New/'; }else{ $n1 = ''; } if(!empty($f->dealer_id)){ $company = Company::where('_id', $f->company_id)->first(); $com = explode(' ',trim($company->name)); $labelD = 'D/'.$com[0].'.'; $agent = Staff::with('StaffDetail')->where('_id', $f->dealer_id)->first(); $agent = $agent->StaffDetail->name; }else{ $labelD = ''; } if(!empty($f->subscribetrashed) && !empty($f->packagedetailtrashed)){ if($f->type_application == 'R'){ $name = $f->subscribetrashed->name; $building = $f->subscribetrashed->building_name; $unit = $f->subscribetrashed->unit_no; if($f->subscribetrashed->street != ''){ $address = $f->subscribetrashed->street. ', '.$f->subscribetrashed->postcode. ' , '.$f->subscribetrashed->city. ', '.$f->subscribetrashed->state; }else { $address = $f->subscribetrashed->postcode. ', '.$f->subscribetrashed->city. ', '.$f->subscribetrashed->state; } }else if($f->type_application == 'B'){ if($f->subscribetrashed->unit_no == ''){ $unit = '-'; }else { $unit = $f->subscribetrashed->unit_no; } $name = $f->subscribetrashed->company_name; $building = $f->subscribetrashed->building_name; $address = $f->subscribetrashed->street. ', '.$f->subscribetrashed->postcode. ', '.$f->subscribetrashed->city. ', '.$f->subscribetrashed->state; } $i++; array_push($nested_data, array( 'formT' => $n1.$i.$f->type_application, 'date' => $f->created_at->toDateString(), 'id' => str_replace("CBB-","",$f->subscribetrashed->subscriber_id), 'type' => $f->type_service, 'name' => $labelD.$f->subscribetrashed->name, 'phone' => $f->subscribetrashed->phone1, 'unit' => $unit, 'building' => $building, 'street' => $address, 'agent' => $agent, 'remark' => $f->remark_reject, 'action' => $f->_id, )); } } } return \DataTables::of($nested_data)->make(true); } /** * Delete / Reject Form controller * * @return json */ public function rejectForm(Request $request) { $form = Form::with('Subscriber','PackageDetail')->where('_id', $request->id)->first(); if(!empty($form)){ $form->remark_reject = $request->reason; $saved = $form->save(); if($saved){ if(!empty($form->Subscriber)){ $form->subscriber()->delete(); } if(!empty($form->PackageDetail)){ $form->packagedetail()->delete(); } $form->delete(); return $this->sendResponse($form, 'The form success been rejected. You can see the form in rejected category'); }else{ return $this->sendError('Cant Reject the form!', ''); } }else { return $this->sendError('Form not exist!', ''); } } /** * Restore Form controller * * @return json */ public function restoreForm(Request $request) { $form = Form::with('subscribetrashed','packagedetailtrashed')->where('_id', $request->id)->withTrashed()->first(); if(!empty($form)){ if(!empty($form->subscribetrashed)){ $form->subscribetrashed()->restore(); } if(!empty($form->packagedetailtrashed)){ $form->packagedetailtrashed()->restore(); } $form->restore(); return $this->sendResponse($form, 'The form success been restore. You can see the form in application category'); }else { return $this->sendError('Form not exist!', ''); } } /** * Update Status Email Form controller * * @return json */ public function forceVerifyform(Request $request) { $form = Form::where('_id', $request->id)->first(); if(!empty($form)){ if($form->status_email == 'unverified'){ $form->status_email = 'verified'; $form->save(); $stat = new FormStatus(); $stat->form_id = $form->_id; $stat->status_id = 2; $stat->date = new \MongoDB\BSON\UTCDateTime(time()*1000); $stat->status = 'Verified'; $stat->desc = 'Email already been verified by Customer Service'; $form->formstatus()->save($stat); return $this->sendResponse($form, 'Email already been verified by SHTECH'); }else{ return $this->sendError('Email already been verified!', ''); } }else { return $this->sendError('Form not exist!', ''); } } /** * View PDF * * @return json */ public function viewFormPDF(Request $request){ $form = Form::with('Subscriber','subscribetrashed')->where('_id', $request->id)->withTrashed()->first(); if(!empty($form)){ if(!empty($form->Subscriber) || !empty($form->subscribetrashed)){ if(!empty($form->Subscriber)){ if($form->type_application == 'R'){ return $this->sendResponse($form, '/residential/generate-pdf/'.$form->Subscriber->subscriber_id); }else if($form->type_application == 'B'){ return $this->sendResponse($form, '/business/generate-pdf/'.$form->Subscriber->subscriber_id); } }else{ if($form->type_application == 'R'){ return $this->sendResponse($form, '/residential/generate-pdf/'.$form->subscribetrashed->subscriber_id); }else if($form->type_application == 'B'){ return $this->sendResponse($form, '/business/generate-pdf/'.$form->subscribetrashed->subscriber_id); } } }else { return $this->sendError('Data subscriber not exist!', ''); } }else { return $this->sendError('Form not exist!', ''); } } /** * View PDF * * @return json */ public function viewCustomerForm(Request $request){ $form = Form::with('Subscriber','PackageDetail')->where('_id', $request->id)->first(); if(!empty($form)){ if(!empty($form->Subscriber) && !empty($form->PackageDetail)){ return $this->sendResponse($form, '/edit/form/customer/'.$form->Subscriber->subscriber_id); }else { return $this->sendError('Data subscriber or package not exist!', ''); } }else { return $this->sendError('Form not exist!', ''); } } public function viewCustomerFormTrashed(Request $request){ $form = Form::with('subscribetrashed','packagedetailtrashed')->where('_id', $request->id)->withTrashed()->first(); if(!empty($form)){ if(!empty($form->subscribetrashed) && !empty($form->packagedetailtrashed)){ return $this->sendResponse($form, '/edit/form/customer/'.$form->subscribetrashed->subscriber_id); }else { return $this->sendError('Data subscriber or package not exist!', ''); } }else { return $this->sendError('Form not exist!', ''); } } /** * View Form History * * @return json */ public function getOrderHistory($id){ $data = array(); $order_history = FormStatus::where('form_id', $id)->get(); foreach($order_history as $oh){ $utcdatetime = new \MongoDB\BSON\UTCDateTime((string) $oh->date); $datetime = $utcdatetime->toDateTime(); $time = $datetime->format(DATE_RSS); $time = strtotime($time.' UTC'); $dateInLocal = date("d/m/Y h:i a", $time); $data[] = array( 'date' => $dateInLocal, 'status' => $oh->status, 'desc' => $oh->desc ); } return response()->json($data); } public function getDeleteformHoho(){ $form = Form::onlyTrashed()->get(); foreach($form as $f){ $package = PackageDetail::where('_id', $f->_id)->first(); if(!empty($package)){ $package->deleted_at = $f->deleted_at; $package->save(); } $subsc = Subscriber::where('_id', $f->_id)->first(); if(!empty($subsc)){ $subsc->deleted_at = $f->deleted_at; $subsc->save(); } } return response()->json($form); } public function getSubscriberId(Request $request){ $subscriber = Subscriber::where('_id', $request->id)->first(); if(!empty($subscriber)){ $data = [ '_id' => $subscriber->_id, 'email' => $subscriber->email, 'subscriber_id' => $subscriber->subscriber_id ]; return response()->json(['status' => 'true', 'desc' => $data]); }else{ return response()->json(['status' => 'false', 'desc' => 'Rekod ini tidak ditemui']); } } public function savedAndSendEmail(Request $request){ $subscriber = Subscriber::where('_id', $request->_id)->first(); if(!empty($subscriber)){ $subscriber->email = $request->email; $subscriber->save(); $client1 = new \GuzzleHttp\Client(); $request1 = $client1->get('https://cumas.swisslink.com.my/resend-email/'.$subscriber->subscriber_id); $response1 = json_decode($request1->getBody()->getContents()); if($response1 == $subscriber->_id){ return redirect()->back()->with('success_msg', 'Successfully update and send email!'); }else{ return redirect()->back()->with('error_msg', 'Cant send Email!'); } }else{ return redirect()->back()->with('error_msg', 'Subscriber detail cant been found!'); } } }