id();
$user = Staff::with('StaffDetail')->find($id);
$site = SiteSetting::first();
$company = Company::where('team','Dealer')->get();
$coverage = Coverage::where('Type','R')->orderBy('building_name')->get();
$all = count(WorkOrder::all());
$pp = count(WorkOrder::where('status','Pending Non Prelaid')->get());
$sp = count(WorkOrder::where('status','Success Non Prelaid')->get());
$rs = count(WorkOrder::where('status','Reschedule')->get());
$ss = count(WorkOrder::where('status','Suspend')->get());
$cm = count(WorkOrder::where('status','Completed')->get());
$cance = count(WorkOrder::where('status','Cancelled')->get());
$pc = count(WorkOrder::where('status','Pending Contractor')->get());
$pi = count(WorkOrder::where('status','Pending Installer')->get());
return view('v3.main-dashboard.work_order.contractor', compact('user','site','coverage','company','all','pp','sp','rs','ss','cm','pc','pi','cance'));
}
public function pendingNonPrelaid(){
$id = Auth::guard('main')->id();
$user = Staff::with('StaffDetail')->find($id);
$site = SiteSetting::first();
$company = Company::where('team','Dealer')->get();
$coverage = Coverage::where('Type','R')->orderBy('building_name')->get();
$all = count(WorkOrder::all());
$pp = count(WorkOrder::where('status','Pending Non Prelaid')->get());
$sp = count(WorkOrder::where('status','Success Non Prelaid')->get());
$rs = count(WorkOrder::where('status','Reschedule')->get());
$ss = count(WorkOrder::where('status','Suspend')->get());
$cm = count(WorkOrder::where('status','Completed')->get());
$cance = count(WorkOrder::where('status','Cancelled')->get());
$pc = count(WorkOrder::where('status','Pending Contractor')->get());
$pi = count(WorkOrder::where('status','Pending Installer')->get());
return view('v3.main-dashboard.work_order.pending_non_prelaid', compact('user','site','coverage','company','all','pp','sp','rs','ss','cm','pc','pi','cance'));
}
public function successNonPrelaid(){
$id = Auth::guard('main')->id();
$user = Staff::with('StaffDetail')->find($id);
$site = SiteSetting::first();
$company = Company::where('team','Dealer')->get();
$coverage = Coverage::where('Type','R')->orderBy('building_name')->get();
$all = count(WorkOrder::all());
$pp = count(WorkOrder::where('status','Pending Non Prelaid')->get());
$sp = count(WorkOrder::where('status','Success Non Prelaid')->get());
$rs = count(WorkOrder::where('status','Reschedule')->get());
$ss = count(WorkOrder::where('status','Suspend')->get());
$cm = count(WorkOrder::where('status','Completed')->get());
$cance = count(WorkOrder::where('status','Cancelled')->get());
$pc = count(WorkOrder::where('status','Pending Contractor')->get());
$pi = count(WorkOrder::where('status','Pending Installer')->get());
return view('v3.main-dashboard.work_order.success_non_prelaid', compact('user','site','coverage','company','all','pp','sp','rs','ss','cm','pc','pi','cance'));
}
public function installer(){
$id = Auth::guard('main')->id();
$user = Staff::with('StaffDetail')->find($id);
$site = SiteSetting::first();
$company = Company::where('team','Dealer')->get();
$coverage = Coverage::where('Type','R')->orderBy('building_name')->get();
$all = count(WorkOrder::all());
$pp = count(WorkOrder::where('status','Pending Non Prelaid')->get());
$sp = count(WorkOrder::where('status','Success Non Prelaid')->get());
$rs = count(WorkOrder::where('status','Reschedule')->get());
$ss = count(WorkOrder::where('status','Suspend')->get());
$cm = count(WorkOrder::where('status','Completed')->get());
$cance = count(WorkOrder::where('status','Cancelled')->get());
$pc = count(WorkOrder::where('status','Pending Contractor')->get());
$pi = count(WorkOrder::where('status','Pending Installer')->get());
return view('v3.main-dashboard.work_order.installer', compact('user','site','coverage','company','all','pp','sp','rs','ss','cm','pc','pi','cance'));
}
public function reschedule(){
$id = Auth::guard('main')->id();
$user = Staff::with('StaffDetail')->find($id);
$site = SiteSetting::first();
$company = Company::where('team','Dealer')->get();
$coverage = Coverage::where('Type','R')->orderBy('building_name')->get();
$all = count(WorkOrder::all());
$pp = count(WorkOrder::where('status','Pending Non Prelaid')->get());
$sp = count(WorkOrder::where('status','Success Non Prelaid')->get());
$rs = count(WorkOrder::where('status','Reschedule')->get());
$ss = count(WorkOrder::where('status','Suspend')->get());
$cm = count(WorkOrder::where('status','Completed')->get());
$cance = count(WorkOrder::where('status','Cancelled')->get());
$pc = count(WorkOrder::where('status','Pending Contractor')->get());
$pi = count(WorkOrder::where('status','Pending Installer')->get());
return view('v3.main-dashboard.work_order.reschedule', compact('user','site','coverage','company','all','pp','sp','rs','ss','cm','pc','pi','cance'));
}
public function suspend(){
$id = Auth::guard('main')->id();
$user = Staff::with('StaffDetail')->find($id);
$site = SiteSetting::first();
$company = Company::where('team','Dealer')->get();
$coverage = Coverage::where('Type','R')->orderBy('building_name')->get();
$all = count(WorkOrder::all());
$pp = count(WorkOrder::where('status','Pending Non Prelaid')->get());
$sp = count(WorkOrder::where('status','Success Non Prelaid')->get());
$rs = count(WorkOrder::where('status','Reschedule')->get());
$ss = count(WorkOrder::where('status','Suspend')->get());
$cm = count(WorkOrder::where('status','Completed')->get());
$cance = count(WorkOrder::where('status','Cancelled')->get());
$pc = count(WorkOrder::where('status','Pending Contractor')->get());
$pi = count(WorkOrder::where('status','Pending Installer')->get());
return view('v3.main-dashboard.work_order.suspend', compact('user','site','coverage','company','all','pp','sp','rs','ss','cm','pc','pi','cance'));
}
public function completed(){
$id = Auth::guard('main')->id();
$user = Staff::with('StaffDetail')->find($id);
$site = SiteSetting::first();
$company = Company::where('team','Dealer')->get();
$coverage = Coverage::where('Type','R')->orderBy('building_name')->get();
$all = count(WorkOrder::all());
$pp = count(WorkOrder::where('status','Pending Non Prelaid')->get());
$sp = count(WorkOrder::where('status','Success Non Prelaid')->get());
$rs = count(WorkOrder::where('status','Reschedule')->get());
$ss = count(WorkOrder::where('status','Suspend')->get());
$cm = count(WorkOrder::where('status','Completed')->get());
$cance = count(WorkOrder::where('status','Cancelled')->get());
$pc = count(WorkOrder::where('status','Pending Contractor')->get());
$pi = count(WorkOrder::where('status','Pending Installer')->get());
return view('v3.main-dashboard.work_order.completed', compact('user','site','coverage','company','all','pp','sp','rs','ss','cm','pc','pi','cance'));
}
public function cancelled(){
$id = Auth::guard('main')->id();
$user = Staff::with('StaffDetail')->find($id);
$site = SiteSetting::first();
$company = Company::where('team','Dealer')->get();
$coverage = Coverage::where('Type','R')->orderBy('building_name')->get();
$all = count(WorkOrder::all());
$pp = count(WorkOrder::where('status','Pending Non Prelaid')->get());
$sp = count(WorkOrder::where('status','Success Non Prelaid')->get());
$rs = count(WorkOrder::where('status','Reschedule')->get());
$ss = count(WorkOrder::where('status','Suspend')->get());
$cm = count(WorkOrder::where('status','Completed')->get());
$cance = count(WorkOrder::where('status','Cancelled')->get());
$pc = count(WorkOrder::where('status','Pending Contractor')->get());
$pi = count(WorkOrder::where('status','Pending Installer')->get());
return view('v3.main-dashboard.work_order.cancelled', compact('user','site','coverage','company','all','pp','sp','rs','ss','cm','pc','pi','cance'));
}
/**
* Create uniq subscriber id controller.
*
* @return view
*/
function random_code($limit) {
return substr(base_convert(sha1(uniqid(mt_rand())), 16, 36), 0, $limit);
}
/**
* Generate uniq work id controller.
*
* @return view
*/
function createWorkID($limit){
$allowedNumbers = range(0, 9);
shuffle($allowedNumbers);
$digits = array_rand($allowedNumbers, $limit);
$number = '';
foreach($digits as $d){
$number .= $allowedNumbers[$d];
}
$unique_id = $number;
return $unique_id;
}
/**
* Create residential work order controller.
*
* @return view
*/
public function createWorkOrderResidential(){
$id = Auth::guard('main')->id();
$user = Staff::with('StaffDetail')->find($id);
$site = SiteSetting::first();
$coverage = Coverage::where('Type','R')->orderBy('building_name')->get();
$all = count(WorkOrder::all());
$pp = count(WorkOrder::where('status','Pending Non Prelaid')->get());
$sp = count(WorkOrder::where('status','Success Non Prelaid')->get());
$rs = count(WorkOrder::where('status','Reschedule')->get());
$ss = count(WorkOrder::where('status','Suspend')->get());
$cm = count(WorkOrder::where('status','Completed')->get());
$cance = count(WorkOrder::where('status','Cancelled')->get());
$pc = count(WorkOrder::where('status','Pending Contractor')->get());
$pi = count(WorkOrder::where('status','Pending Installer')->get());
$product = Product::where('formT','R')->get();
return view('v3.main-dashboard.work_order.create_work_order_residential', compact('user','site','coverage','all','pp','sp','rs','ss','cm','pc','pi','cance','product'));
}
/**
* Create business work order controller.
*
* @return view
*/
public function createWorkOrderBusiness(){
$id = Auth::guard('main')->id();
$user = Staff::with('StaffDetail')->find($id);
$site = SiteSetting::first();
$coverage = Coverage::where('Type','B')->orderBy('building_name')->get();
$all = count(WorkOrder::all());
$pp = count(WorkOrder::where('status','Pending Non Prelaid')->get());
$sp = count(WorkOrder::where('status','Success Non Prelaid')->get());
$rs = count(WorkOrder::where('status','Reschedule')->get());
$ss = count(WorkOrder::where('status','Suspend')->get());
$cm = count(WorkOrder::where('status','Completed')->get());
$cance = count(WorkOrder::where('status','Cancelled')->get());
$pc = count(WorkOrder::where('status','Pending Contractor')->get());
$pi = count(WorkOrder::where('status','Pending Installer')->get());
$product = Product::where('formT','B')->get();
return view('v3.main-dashboard.work_order.create_work_order_business', compact('user','site','coverage','all','pp','sp','rs','ss','cm','pc','pi','cance','product'));
}
/**
* Create confirm work order detail controller.
*
* @return view
*/
public function viewWorkOrderDetailForm($wo){
$id = Auth::guard('main')->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-dashboard.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')->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-dashboard.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')->id();
$user = Staff::with('StaffDetail')->find($id);
$wo = WorkOrder::where('wo',$request->work_order)->first();
if(!empty($wo)){
$number_phone = '';
if($request->n_phone == 'Yes'){
$number_phone = $request->no_phone;
}
$wo->nature_work = $request->task;
$wo->pppoe_username = $request->pppoe_username;
$wo->onu = $request->onu_ont;
$wo->router = $request->router;
$wo->need_phone = $request->n_phone;
$wo->no_phone = $number_phone;
$wo->remarks_custservice = $request->remark;
$wo->created_by = $user->_id;
$wo->save();
$form = Form::where('_id',$wo->_id)->first();
$contractor = Company::where('_id',$wo->contractor_id)->first();
$status = ''; $st_id = '';
if($wo->status == 'Pending Contractor'){
$st_id = 4;
$status = 'Pending Contractor';
}else if($wo->status == 'Pending Non Prelaid'){
$st_id = 5;
$status = 'Pending Non Prelaid';
}
$formH = new FormStatus;
$formH->form_id = $form->_id;
$formH->status_id = $st_id;
$formH->date = new \MongoDB\BSON\UTCDateTime(time()*1000);
$formH->status = $status;
$formH->desc = 'This work order been assigned to particular contractor ('.$contractor->name.')';
$form->formstatus()->save($formH);
$this->sendWorkOrdersByEmail($request->work_order);
return redirect('/v3/main/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);
}
}
}
/**
* Create rectification form controller.
*
* @return post
*/
public function createRectificationForm(Request $request)
{
$su_id = ''; $pathIconF = ''; $pathIconB = '';
$sl = Form::create([
'type_service' => 'Rectification',
'type_application' => $request->formT,
'status_payment' => 'paid',
'status_email' => 'verified',
'remark_form' => ''
]);
if($request->formT == 'R'){
do {
$su_id = strtoupper('CBB-'.$this->random_code(6).'R');
} while (Subscriber::where("subscriber_id", "=", $su_id)->first() instanceof Subscriber);
$coverage = Coverage::where('_id', $request->buildingsss)->first();
if(!empty($coverage)) {
$sdl = new Subscriber();
$sdl->subscriber_id = $su_id;
$sdl->name = $request->name;
$sdl->ic = '';
$sdl->citizen = '';
$sdl->gender = '';
$sdl->race = '';
$sdl->email = '';
$sdl->phone1 = $request->phone1;
$sdl->phone2 = $request->phone2;
$sdl->unit_no = $request->unit_no;
$sdl->building_name = $coverage->building_name;
$sdl->street = $request->street;
$sdl->postcode = $coverage->postcode;
$sdl->city = $coverage->city;
$sdl->state = $coverage->state;
$sdl->front_ic = '';
$sdl->back_ic = '';
$sdl->signature = '';
$packageD = new PackageDetail();
$packageD->contract = '';
$packageD->name = $request->package;
$packageD->montly_fee = '';
$packageD->voice_fee = '';
$packageD->deposit = '';
$packageD->upfront_payment = '';
$packageD->rfs = '';
$sl->subscriber()->save($sdl);
$sl->packagedetail()->save($packageD);
$subs = Subscriber::where('subscriber_id',$su_id)->first();
$form = Form::where('_id',$subs->_id)->first();
$formH = new FormStatus;
$formH->form_id = $form->_id;
$formH->status_id = 12;
$formH->date = new \MongoDB\BSON\UTCDateTime(time()*1000);
$formH->status = 'New Rectification';
$formH->desc = 'Rectification form been submitted';
$form->formstatus()->save($formH);
$wo = '';
do {
$wo = 'WO-'.$this->createWorkID(4);
} while (WorkOrder::where("wo", "=", $wo)->first() instanceof WorkOrder);
return redirect()->to('/v3/main/add-new-schedule/rectification/'.$wo.'/'. $su_id);
}else{
return redirect()->back()->withInput($request->input())->with('error_msg', 'Coverage Not Found!');
}
}else if($request->formT == 'B'){
do {
$su_id = strtoupper('CBB-'.$this->random_code(6).'B');
} while (Subscriber::where("subscriber_id", "=", $su_id)->first() instanceof Subscriber);
$sdl = new Subscriber();
$sdl->subscriber_id = $su_id;
$sdl->company_name = $request->cname;
$sdl->company_reg = '';
$sdl->company_num = '';
$sdl->company_fax = '';
$sdl->name = $request->name;
$sdl->ic = '';
$sdl->designation = '';
$sdl->email = '';
$sdl->phone1 = $request->phone1;
$sdl->phone2 = '';
$sdl->unit_no = '';
$sdl->street = $request->caddress;
$sdl->postcode = '';
$sdl->city = '';
$sdl->state = '';
$sdl->front_ic = '';
$sdl->back_ic = '';
$sdl->form24_49 = '';
$sdl->form9_44 = '';
$packageD = new PackageDetail();
$packageD->contract = '';
$packageD->name = $request->package;
$packageD->montly_fee = '';
$packageD->voice_fee = 'No';
$packageD->deposit = '';
$packageD->upfront_payment = '';
$packageD->rfs = '';
$sl->subscriber()->save($sdl);
$sl->packagedetail()->save($packageD);
$subs = Subscriber::where('subscriber_id',$su_id)->first();
$form = Form::where('_id',$subs->_id)->first();
$formH = new FormStatus;
$formH->form_id = $form->_id;
$formH->status_id = 12;
$formH->date = new \MongoDB\BSON\UTCDateTime(time()*1000);
$formH->status = 'New Rectification';
$formH->desc = 'Rectification form been submitted';
$form->formstatus()->save($formH);
$wo = '';
do {
$wo = 'WO-'.$this->createWorkID(4);
} while (WorkOrder::where("wo", "=", $wo)->first() instanceof WorkOrder);
return redirect()->to('/v3/main/add-new-schedule/rectification/'.$wo.'/'. $su_id);
}
}
/**
* Create secured development form controller.
*
* @return post
*/
public function createSecuredDevelopementForm(Request $request)
{
$su_id = ''; $pathIconF = ''; $pathIconB = '';
do {
$su_id = strtoupper('CBB-'.$this->random_code(6).'R');
} while (Subscriber::where("subscriber_id", "=", $su_id)->first() instanceof Subscriber);
$sl = Form::create([
'type_service' => $request->app,
'type_application' => 'R',
'status_payment' => 'paid',
'status_email' => 'verified',
'remark_form' => ''
]);
$coverage = Coverage::where('_id',$request->buildingssss,'Type','R')->first();
$sdl = new Subscriber();
$sdl->subscriber_id = $su_id;
$sdl->name = $request->name;
$sdl->ic = 'Package Development';
$sdl->citizen = $request->citizensss;
$sdl->gender = $request->gender;
$sdl->race = $request->race;
$sdl->email = 'Package Development';
$sdl->phone1 = $request->phone1;
$sdl->phone2 = $request->phone2;
$sdl->unit_no = $request->unit_no;
$sdl->building_name = $coverage->building_name;
$sdl->street = $request->street;
$sdl->postcode = $coverage->postcode;
$sdl->city = $coverage->city;
$sdl->state = $coverage->state;
$sdl->front_ic = '';
$sdl->back_ic = '';
$sdl->signature = '';
$packageD = new PackageDetail();
$packageD->contract = '24';
$packageD->name = $request->package;
$packageD->montly_fee = '';
$packageD->voice_fee = 'No';
$packageD->deposit = '';
$packageD->upfront_payment = '';
$packageD->rfs = '';
$sl->subscriber()->save($sdl);
$sl->packagedetail()->save($packageD);
$subs = Subscriber::where('subscriber_id',$su_id)->first();
$form = Form::where('_id',$subs->_id)->first();
$formH = new FormStatus;
$formH->form_id = $form->_id;
$formH->status_id = 13;
$formH->date = new \MongoDB\BSON\UTCDateTime(time()*1000);
$formH->status = 'Secured Development';
$formH->desc = 'Secured development form been submitted';
$form->formstatus()->save($formH);
$wo = '';
do {
$wo = 'WO-'.$this->createWorkID(4);
} while (WorkOrder::where("wo", "=", $wo)->first() instanceof WorkOrder);
return redirect()->to('/v3/main/add-new-schedule/secured-development/'.$wo.'/'. $su_id);
}
}