You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

WorkOrderController.php 23KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626
  1. <?php
  2. namespace App\Http\Controllers\v3\Main;
  3. use Illuminate\Http\Request;
  4. use App\Http\Controllers\Controller;
  5. use Illuminate\Support\Facades\Auth;
  6. use Carbon\Carbon;
  7. use App\SiteSetting;
  8. use App\LatestModel\Staff;
  9. use App\LatestModel\StaffDetail;
  10. use App\LatestModel\Module\Company;
  11. use App\LatestModel\Module\Coverage;
  12. use App\LatestModel\Module\Form;
  13. use App\LatestModel\Module\PackageDetail;
  14. use App\LatestModel\Module\Subscriber;
  15. use App\LatestModel\Module\WorkOrder;
  16. use App\LatestModel\Module\Product;
  17. use App\LatestModel\Module\FormStatus;
  18. use App\Mail\AssignWorkOrder;
  19. use App\Jobs\SendWorkOrder;
  20. class WorkOrderController extends Controller
  21. {
  22. /**
  23. * Create view work order table controller.
  24. *
  25. * @return view
  26. */
  27. public function contractor(){
  28. $id = Auth::guard('main')->id();
  29. $user = Staff::with('StaffDetail')->find($id);
  30. $site = SiteSetting::first();
  31. $company = Company::where('team','Dealer')->get();
  32. $coverage = Coverage::where('Type','R')->orderBy('building_name')->get();
  33. $all = count(WorkOrder::all());
  34. $pp = count(WorkOrder::where('status','Pending Non Prelaid')->get());
  35. $sp = count(WorkOrder::where('status','Success Non Prelaid')->get());
  36. $rs = count(WorkOrder::where('status','Reschedule')->get());
  37. $ss = count(WorkOrder::where('status','Suspend')->get());
  38. $cm = count(WorkOrder::where('status','Completed')->get());
  39. $cance = count(WorkOrder::where('status','Cancelled')->get());
  40. $pc = count(WorkOrder::where('status','Pending Contractor')->get());
  41. $pi = count(WorkOrder::where('status','Pending Installer')->get());
  42. return view('v3.main-dashboard.work_order.contractor', compact('user','site','coverage','company','all','pp','sp','rs','ss','cm','pc','pi','cance'));
  43. }
  44. public function pendingNonPrelaid(){
  45. $id = Auth::guard('main')->id();
  46. $user = Staff::with('StaffDetail')->find($id);
  47. $site = SiteSetting::first();
  48. $company = Company::where('team','Dealer')->get();
  49. $coverage = Coverage::where('Type','R')->orderBy('building_name')->get();
  50. $all = count(WorkOrder::all());
  51. $pp = count(WorkOrder::where('status','Pending Non Prelaid')->get());
  52. $sp = count(WorkOrder::where('status','Success Non Prelaid')->get());
  53. $rs = count(WorkOrder::where('status','Reschedule')->get());
  54. $ss = count(WorkOrder::where('status','Suspend')->get());
  55. $cm = count(WorkOrder::where('status','Completed')->get());
  56. $cance = count(WorkOrder::where('status','Cancelled')->get());
  57. $pc = count(WorkOrder::where('status','Pending Contractor')->get());
  58. $pi = count(WorkOrder::where('status','Pending Installer')->get());
  59. return view('v3.main-dashboard.work_order.pending_non_prelaid', compact('user','site','coverage','company','all','pp','sp','rs','ss','cm','pc','pi','cance'));
  60. }
  61. public function successNonPrelaid(){
  62. $id = Auth::guard('main')->id();
  63. $user = Staff::with('StaffDetail')->find($id);
  64. $site = SiteSetting::first();
  65. $company = Company::where('team','Dealer')->get();
  66. $coverage = Coverage::where('Type','R')->orderBy('building_name')->get();
  67. $all = count(WorkOrder::all());
  68. $pp = count(WorkOrder::where('status','Pending Non Prelaid')->get());
  69. $sp = count(WorkOrder::where('status','Success Non Prelaid')->get());
  70. $rs = count(WorkOrder::where('status','Reschedule')->get());
  71. $ss = count(WorkOrder::where('status','Suspend')->get());
  72. $cm = count(WorkOrder::where('status','Completed')->get());
  73. $cance = count(WorkOrder::where('status','Cancelled')->get());
  74. $pc = count(WorkOrder::where('status','Pending Contractor')->get());
  75. $pi = count(WorkOrder::where('status','Pending Installer')->get());
  76. return view('v3.main-dashboard.work_order.success_non_prelaid', compact('user','site','coverage','company','all','pp','sp','rs','ss','cm','pc','pi','cance'));
  77. }
  78. public function installer(){
  79. $id = Auth::guard('main')->id();
  80. $user = Staff::with('StaffDetail')->find($id);
  81. $site = SiteSetting::first();
  82. $company = Company::where('team','Dealer')->get();
  83. $coverage = Coverage::where('Type','R')->orderBy('building_name')->get();
  84. $all = count(WorkOrder::all());
  85. $pp = count(WorkOrder::where('status','Pending Non Prelaid')->get());
  86. $sp = count(WorkOrder::where('status','Success Non Prelaid')->get());
  87. $rs = count(WorkOrder::where('status','Reschedule')->get());
  88. $ss = count(WorkOrder::where('status','Suspend')->get());
  89. $cm = count(WorkOrder::where('status','Completed')->get());
  90. $cance = count(WorkOrder::where('status','Cancelled')->get());
  91. $pc = count(WorkOrder::where('status','Pending Contractor')->get());
  92. $pi = count(WorkOrder::where('status','Pending Installer')->get());
  93. return view('v3.main-dashboard.work_order.installer', compact('user','site','coverage','company','all','pp','sp','rs','ss','cm','pc','pi','cance'));
  94. }
  95. public function reschedule(){
  96. $id = Auth::guard('main')->id();
  97. $user = Staff::with('StaffDetail')->find($id);
  98. $site = SiteSetting::first();
  99. $company = Company::where('team','Dealer')->get();
  100. $coverage = Coverage::where('Type','R')->orderBy('building_name')->get();
  101. $all = count(WorkOrder::all());
  102. $pp = count(WorkOrder::where('status','Pending Non Prelaid')->get());
  103. $sp = count(WorkOrder::where('status','Success Non Prelaid')->get());
  104. $rs = count(WorkOrder::where('status','Reschedule')->get());
  105. $ss = count(WorkOrder::where('status','Suspend')->get());
  106. $cm = count(WorkOrder::where('status','Completed')->get());
  107. $cance = count(WorkOrder::where('status','Cancelled')->get());
  108. $pc = count(WorkOrder::where('status','Pending Contractor')->get());
  109. $pi = count(WorkOrder::where('status','Pending Installer')->get());
  110. return view('v3.main-dashboard.work_order.reschedule', compact('user','site','coverage','company','all','pp','sp','rs','ss','cm','pc','pi','cance'));
  111. }
  112. public function suspend(){
  113. $id = Auth::guard('main')->id();
  114. $user = Staff::with('StaffDetail')->find($id);
  115. $site = SiteSetting::first();
  116. $company = Company::where('team','Dealer')->get();
  117. $coverage = Coverage::where('Type','R')->orderBy('building_name')->get();
  118. $all = count(WorkOrder::all());
  119. $pp = count(WorkOrder::where('status','Pending Non Prelaid')->get());
  120. $sp = count(WorkOrder::where('status','Success Non Prelaid')->get());
  121. $rs = count(WorkOrder::where('status','Reschedule')->get());
  122. $ss = count(WorkOrder::where('status','Suspend')->get());
  123. $cm = count(WorkOrder::where('status','Completed')->get());
  124. $cance = count(WorkOrder::where('status','Cancelled')->get());
  125. $pc = count(WorkOrder::where('status','Pending Contractor')->get());
  126. $pi = count(WorkOrder::where('status','Pending Installer')->get());
  127. return view('v3.main-dashboard.work_order.suspend', compact('user','site','coverage','company','all','pp','sp','rs','ss','cm','pc','pi','cance'));
  128. }
  129. public function completed(){
  130. $id = Auth::guard('main')->id();
  131. $user = Staff::with('StaffDetail')->find($id);
  132. $site = SiteSetting::first();
  133. $company = Company::where('team','Dealer')->get();
  134. $coverage = Coverage::where('Type','R')->orderBy('building_name')->get();
  135. $all = count(WorkOrder::all());
  136. $pp = count(WorkOrder::where('status','Pending Non Prelaid')->get());
  137. $sp = count(WorkOrder::where('status','Success Non Prelaid')->get());
  138. $rs = count(WorkOrder::where('status','Reschedule')->get());
  139. $ss = count(WorkOrder::where('status','Suspend')->get());
  140. $cm = count(WorkOrder::where('status','Completed')->get());
  141. $cance = count(WorkOrder::where('status','Cancelled')->get());
  142. $pc = count(WorkOrder::where('status','Pending Contractor')->get());
  143. $pi = count(WorkOrder::where('status','Pending Installer')->get());
  144. return view('v3.main-dashboard.work_order.completed', compact('user','site','coverage','company','all','pp','sp','rs','ss','cm','pc','pi','cance'));
  145. }
  146. public function cancelled(){
  147. $id = Auth::guard('main')->id();
  148. $user = Staff::with('StaffDetail')->find($id);
  149. $site = SiteSetting::first();
  150. $company = Company::where('team','Dealer')->get();
  151. $coverage = Coverage::where('Type','R')->orderBy('building_name')->get();
  152. $all = count(WorkOrder::all());
  153. $pp = count(WorkOrder::where('status','Pending Non Prelaid')->get());
  154. $sp = count(WorkOrder::where('status','Success Non Prelaid')->get());
  155. $rs = count(WorkOrder::where('status','Reschedule')->get());
  156. $ss = count(WorkOrder::where('status','Suspend')->get());
  157. $cm = count(WorkOrder::where('status','Completed')->get());
  158. $cance = count(WorkOrder::where('status','Cancelled')->get());
  159. $pc = count(WorkOrder::where('status','Pending Contractor')->get());
  160. $pi = count(WorkOrder::where('status','Pending Installer')->get());
  161. return view('v3.main-dashboard.work_order.cancelled', compact('user','site','coverage','company','all','pp','sp','rs','ss','cm','pc','pi','cance'));
  162. }
  163. /**
  164. * Create uniq subscriber id controller.
  165. *
  166. * @return view
  167. */
  168. function random_code($limit) {
  169. return substr(base_convert(sha1(uniqid(mt_rand())), 16, 36), 0, $limit);
  170. }
  171. /**
  172. * Generate uniq work id controller.
  173. *
  174. * @return view
  175. */
  176. function createWorkID($limit){
  177. $allowedNumbers = range(0, 9);
  178. shuffle($allowedNumbers);
  179. $digits = array_rand($allowedNumbers, $limit);
  180. $number = '';
  181. foreach($digits as $d){
  182. $number .= $allowedNumbers[$d];
  183. }
  184. $unique_id = $number;
  185. return $unique_id;
  186. }
  187. /**
  188. * Create residential work order controller.
  189. *
  190. * @return view
  191. */
  192. public function createWorkOrderResidential(){
  193. $id = Auth::guard('main')->id();
  194. $user = Staff::with('StaffDetail')->find($id);
  195. $site = SiteSetting::first();
  196. $coverage = Coverage::where('Type','R')->orderBy('building_name')->get();
  197. $all = count(WorkOrder::all());
  198. $pp = count(WorkOrder::where('status','Pending Non Prelaid')->get());
  199. $sp = count(WorkOrder::where('status','Success Non Prelaid')->get());
  200. $rs = count(WorkOrder::where('status','Reschedule')->get());
  201. $ss = count(WorkOrder::where('status','Suspend')->get());
  202. $cm = count(WorkOrder::where('status','Completed')->get());
  203. $cance = count(WorkOrder::where('status','Cancelled')->get());
  204. $pc = count(WorkOrder::where('status','Pending Contractor')->get());
  205. $pi = count(WorkOrder::where('status','Pending Installer')->get());
  206. $product = Product::where('formT','R')->get();
  207. 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'));
  208. }
  209. /**
  210. * Create business work order controller.
  211. *
  212. * @return view
  213. */
  214. public function createWorkOrderBusiness(){
  215. $id = Auth::guard('main')->id();
  216. $user = Staff::with('StaffDetail')->find($id);
  217. $site = SiteSetting::first();
  218. $coverage = Coverage::where('Type','B')->orderBy('building_name')->get();
  219. $all = count(WorkOrder::all());
  220. $pp = count(WorkOrder::where('status','Pending Non Prelaid')->get());
  221. $sp = count(WorkOrder::where('status','Success Non Prelaid')->get());
  222. $rs = count(WorkOrder::where('status','Reschedule')->get());
  223. $ss = count(WorkOrder::where('status','Suspend')->get());
  224. $cm = count(WorkOrder::where('status','Completed')->get());
  225. $cance = count(WorkOrder::where('status','Cancelled')->get());
  226. $pc = count(WorkOrder::where('status','Pending Contractor')->get());
  227. $pi = count(WorkOrder::where('status','Pending Installer')->get());
  228. $product = Product::where('formT','B')->get();
  229. 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'));
  230. }
  231. /**
  232. * Create confirm work order detail controller.
  233. *
  234. * @return view
  235. */
  236. public function viewWorkOrderDetailForm($wo){
  237. $id = Auth::guard('main')->id();
  238. $user = Staff::with('StaffDetail')->find($id);
  239. $site = SiteSetting::first();
  240. $w = WorkOrder::where('wo',$wo)->first();
  241. $form = Form::with('Subscriber','WorkOrder')->where('_id',$w->_id)->first();
  242. $coverage = Coverage::where('Type', $form->type_application)->orderBy('building_name','ASC')->get();
  243. $company = Company::where('_id',$w->contractor_id)->first();
  244. return view('v3.main-dashboard.work_order.view_work_order_detail_form', compact('user','site','w','company','form','coverage'));
  245. }
  246. /**
  247. * Create edit work order detail controller.
  248. *
  249. * @return view
  250. */
  251. public function editWorkOrderDetailForm($wo){
  252. $id = Auth::guard('main')->id();
  253. $user = Staff::with('StaffDetail')->find($id);
  254. $site = SiteSetting::first();
  255. $w = WorkOrder::where('wo',$wo)->first();
  256. $form = Form::with('Subscriber','WorkOrder')->where('_id',$w->_id)->first();
  257. $coverage = Coverage::where('Type', $form->type_application)->orderBy('building_name','ASC')->get();
  258. $company = Company::where('_id',$w->contractor_id)->first();
  259. return view('v3.main-dashboard.work_order.edit_work_order_detail_form', compact('user','site','w','company','form','coverage'));
  260. }
  261. /**
  262. * Create update work order detail controller.
  263. *
  264. * @return post
  265. */
  266. public function updateWorkOrder(Request $request){
  267. $id = Auth::guard('main')->id();
  268. $user = Staff::with('StaffDetail')->find($id);
  269. $wo = WorkOrder::where('wo',$request->work_order)->first();
  270. if(!empty($wo)){
  271. $number_phone = '';
  272. if($request->n_phone == 'Yes'){
  273. $number_phone = $request->no_phone;
  274. }
  275. $wo->nature_work = $request->task;
  276. $wo->pppoe_username = $request->pppoe_username;
  277. $wo->onu = $request->onu_ont;
  278. $wo->router = $request->router;
  279. $wo->need_phone = $request->n_phone;
  280. $wo->no_phone = $number_phone;
  281. $wo->remarks_custservice = $request->remark;
  282. $wo->created_by = $user->_id;
  283. $wo->save();
  284. $form = Form::where('_id',$wo->_id)->first();
  285. $contractor = Company::where('_id',$wo->contractor_id)->first();
  286. $status = ''; $st_id = '';
  287. if($wo->status == 'Pending Contractor'){
  288. $st_id = 4;
  289. $status = 'Pending Contractor';
  290. }else if($wo->status == 'Pending Non Prelaid'){
  291. $st_id = 5;
  292. $status = 'Pending Non Prelaid';
  293. }
  294. $formH = new FormStatus;
  295. $formH->form_id = $form->_id;
  296. $formH->status_id = $st_id;
  297. $formH->date = new \MongoDB\BSON\UTCDateTime(time()*1000);
  298. $formH->status = $status;
  299. $formH->desc = 'This work order been assigned to particular contractor ('.$contractor->name.')';
  300. $form->formstatus()->save($formH);
  301. $this->sendWorkOrdersByEmail($request->work_order);
  302. return redirect('/v3/main/work-order/pending-contractor');
  303. }else {
  304. return redirect()->back()->with('error_msg', 'Cant update work order '.$request->get('work_order'));
  305. }
  306. }
  307. /**
  308. * Create send work order to contractor by email controller.
  309. *
  310. * @return post
  311. */
  312. public function sendWorkOrdersByEmail($work_order_id) {
  313. $work_order = WorkOrder::where('wo',$work_order_id)->first();
  314. $s = StaffDetail::where('company_id',$work_order->contractor_id)->where('position','Contractor')->get();
  315. $customer = Subscriber::where('_id',$work_order->_id)->first();
  316. if($work_order->contractor_id == '5b42b935ee0dc2b707473b76'){
  317. $company = Company::where('_id',$work_order->contractor_id)->first();
  318. $staff = StaffDetail::where('company_id',$work_order->contractor_id)->where('email','mimi@jitech.com.my')->first();
  319. SendWorkOrder::dispatch($work_order,$staff,'cbbinstallation@jitech.com.my',$customer,$company);
  320. }else {
  321. $company = Company::where('_id',$work_order->contractor_id)->first();
  322. foreach($s as $staff){
  323. SendWorkOrder::dispatch($work_order,$staff,$staff->email,$customer,$company);
  324. }
  325. }
  326. }
  327. /**
  328. * Create rectification form controller.
  329. *
  330. * @return post
  331. */
  332. public function createRectificationForm(Request $request)
  333. {
  334. $su_id = ''; $pathIconF = ''; $pathIconB = '';
  335. $sl = Form::create([
  336. 'type_service' => 'Rectification',
  337. 'type_application' => $request->formT,
  338. 'status_payment' => 'paid',
  339. 'status_email' => 'verified',
  340. 'remark_form' => ''
  341. ]);
  342. if($request->formT == 'R'){
  343. do {
  344. $su_id = strtoupper('CBB-'.$this->random_code(6).'R');
  345. } while (Subscriber::where("subscriber_id", "=", $su_id)->first() instanceof Subscriber);
  346. $coverage = Coverage::where('_id', $request->buildingsss)->first();
  347. if(!empty($coverage)) {
  348. $sdl = new Subscriber();
  349. $sdl->subscriber_id = $su_id;
  350. $sdl->name = $request->name;
  351. $sdl->ic = '';
  352. $sdl->citizen = '';
  353. $sdl->gender = '';
  354. $sdl->race = '';
  355. $sdl->email = '';
  356. $sdl->phone1 = $request->phone1;
  357. $sdl->phone2 = $request->phone2;
  358. $sdl->unit_no = $request->unit_no;
  359. $sdl->building_name = $coverage->building_name;
  360. $sdl->street = $request->street;
  361. $sdl->postcode = $coverage->postcode;
  362. $sdl->city = $coverage->city;
  363. $sdl->state = $coverage->state;
  364. $sdl->front_ic = '';
  365. $sdl->back_ic = '';
  366. $sdl->signature = '';
  367. $packageD = new PackageDetail();
  368. $packageD->contract = '';
  369. $packageD->name = $request->package;
  370. $packageD->montly_fee = '';
  371. $packageD->voice_fee = '';
  372. $packageD->deposit = '';
  373. $packageD->upfront_payment = '';
  374. $packageD->rfs = '';
  375. $sl->subscriber()->save($sdl);
  376. $sl->packagedetail()->save($packageD);
  377. $subs = Subscriber::where('subscriber_id',$su_id)->first();
  378. $form = Form::where('_id',$subs->_id)->first();
  379. $formH = new FormStatus;
  380. $formH->form_id = $form->_id;
  381. $formH->status_id = 12;
  382. $formH->date = new \MongoDB\BSON\UTCDateTime(time()*1000);
  383. $formH->status = 'New Rectification';
  384. $formH->desc = 'Rectification form been submitted';
  385. $form->formstatus()->save($formH);
  386. $wo = '';
  387. do {
  388. $wo = 'WO-'.$this->createWorkID(4);
  389. } while (WorkOrder::where("wo", "=", $wo)->first() instanceof WorkOrder);
  390. return redirect()->to('/v3/main/add-new-schedule/rectification/'.$wo.'/'. $su_id);
  391. }else{
  392. return redirect()->back()->withInput($request->input())->with('error_msg', 'Coverage Not Found!');
  393. }
  394. }else if($request->formT == 'B'){
  395. do {
  396. $su_id = strtoupper('CBB-'.$this->random_code(6).'B');
  397. } while (Subscriber::where("subscriber_id", "=", $su_id)->first() instanceof Subscriber);
  398. $sdl = new Subscriber();
  399. $sdl->subscriber_id = $su_id;
  400. $sdl->company_name = $request->cname;
  401. $sdl->company_reg = '';
  402. $sdl->company_num = '';
  403. $sdl->company_fax = '';
  404. $sdl->name = $request->name;
  405. $sdl->ic = '';
  406. $sdl->designation = '';
  407. $sdl->email = '';
  408. $sdl->phone1 = $request->phone1;
  409. $sdl->phone2 = '';
  410. $sdl->unit_no = '';
  411. $sdl->street = $request->caddress;
  412. $sdl->postcode = '';
  413. $sdl->city = '';
  414. $sdl->state = '';
  415. $sdl->front_ic = '';
  416. $sdl->back_ic = '';
  417. $sdl->form24_49 = '';
  418. $sdl->form9_44 = '';
  419. $packageD = new PackageDetail();
  420. $packageD->contract = '';
  421. $packageD->name = $request->package;
  422. $packageD->montly_fee = '';
  423. $packageD->voice_fee = 'No';
  424. $packageD->deposit = '';
  425. $packageD->upfront_payment = '';
  426. $packageD->rfs = '';
  427. $sl->subscriber()->save($sdl);
  428. $sl->packagedetail()->save($packageD);
  429. $subs = Subscriber::where('subscriber_id',$su_id)->first();
  430. $form = Form::where('_id',$subs->_id)->first();
  431. $formH = new FormStatus;
  432. $formH->form_id = $form->_id;
  433. $formH->status_id = 12;
  434. $formH->date = new \MongoDB\BSON\UTCDateTime(time()*1000);
  435. $formH->status = 'New Rectification';
  436. $formH->desc = 'Rectification form been submitted';
  437. $form->formstatus()->save($formH);
  438. $wo = '';
  439. do {
  440. $wo = 'WO-'.$this->createWorkID(4);
  441. } while (WorkOrder::where("wo", "=", $wo)->first() instanceof WorkOrder);
  442. return redirect()->to('/v3/main/add-new-schedule/rectification/'.$wo.'/'. $su_id);
  443. }
  444. }
  445. /**
  446. * Create secured development form controller.
  447. *
  448. * @return post
  449. */
  450. public function createSecuredDevelopementForm(Request $request)
  451. {
  452. $su_id = ''; $pathIconF = ''; $pathIconB = '';
  453. do {
  454. $su_id = strtoupper('CBB-'.$this->random_code(6).'R');
  455. } while (Subscriber::where("subscriber_id", "=", $su_id)->first() instanceof Subscriber);
  456. $sl = Form::create([
  457. 'type_service' => $request->app,
  458. 'type_application' => 'R',
  459. 'status_payment' => 'paid',
  460. 'status_email' => 'verified',
  461. 'remark_form' => ''
  462. ]);
  463. $coverage = Coverage::where('_id',$request->buildingssss,'Type','R')->first();
  464. $sdl = new Subscriber();
  465. $sdl->subscriber_id = $su_id;
  466. $sdl->name = $request->name;
  467. $sdl->ic = '<b>Package Development</b>';
  468. $sdl->citizen = $request->citizensss;
  469. $sdl->gender = $request->gender;
  470. $sdl->race = $request->race;
  471. $sdl->email = '<b>Package Development</b>';
  472. $sdl->phone1 = $request->phone1;
  473. $sdl->phone2 = $request->phone2;
  474. $sdl->unit_no = $request->unit_no;
  475. $sdl->building_name = $coverage->building_name;
  476. $sdl->street = $request->street;
  477. $sdl->postcode = $coverage->postcode;
  478. $sdl->city = $coverage->city;
  479. $sdl->state = $coverage->state;
  480. $sdl->front_ic = '';
  481. $sdl->back_ic = '';
  482. $sdl->signature = '';
  483. $packageD = new PackageDetail();
  484. $packageD->contract = '24';
  485. $packageD->name = $request->package;
  486. $packageD->montly_fee = '';
  487. $packageD->voice_fee = 'No';
  488. $packageD->deposit = '';
  489. $packageD->upfront_payment = '';
  490. $packageD->rfs = '';
  491. $sl->subscriber()->save($sdl);
  492. $sl->packagedetail()->save($packageD);
  493. $subs = Subscriber::where('subscriber_id',$su_id)->first();
  494. $form = Form::where('_id',$subs->_id)->first();
  495. $formH = new FormStatus;
  496. $formH->form_id = $form->_id;
  497. $formH->status_id = 13;
  498. $formH->date = new \MongoDB\BSON\UTCDateTime(time()*1000);
  499. $formH->status = 'Secured Development';
  500. $formH->desc = 'Secured development form been submitted';
  501. $form->formstatus()->save($formH);
  502. $wo = '';
  503. do {
  504. $wo = 'WO-'.$this->createWorkID(4);
  505. } while (WorkOrder::where("wo", "=", $wo)->first() instanceof WorkOrder);
  506. return redirect()->to('/v3/main/add-new-schedule/secured-development/'.$wo.'/'. $su_id);
  507. }
  508. }