Nelze vybrat více než 25 témat Téma musí začínat písmenem nebo číslem, může obsahovat pomlčky („-“) a může být dlouhé až 35 znaků.

ApplicationController.php 76KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612
  1. <?php
  2. namespace App\Http\Controllers\v3\Api;
  3. use Illuminate\Http\Request;
  4. use App\Http\Controllers\v3\Api\BaseController;
  5. use Config;
  6. use File;
  7. use Carbon\Carbon;
  8. use App\LatestModel\Staff;
  9. use App\LatestModel\StaffDetail;
  10. use App\LatestModel\Dealer;
  11. use App\LatestModel\DealerDetail;
  12. use App\LatestModel\Module\Form;
  13. use App\LatestModel\Module\FormStatus;
  14. use App\LatestModel\Module\Subscriber;
  15. use App\LatestModel\Module\WorkOrder;
  16. use App\LatestModel\Module\Docket;
  17. use App\LatestModel\Module\PackageDetail;
  18. use App\LatestModel\Module\Company;
  19. use App\LatestModel\Module\Coverage;
  20. use App\LatestModel\Module\Product;
  21. class ApplicationController extends BaseController
  22. {
  23. /**
  24. * Create work order number controller.
  25. *
  26. * @return json
  27. */
  28. public function createWorkID($limit){
  29. $allowedNumbers = range(0, 9);
  30. shuffle($allowedNumbers);
  31. $digits = array_rand($allowedNumbers, $limit);
  32. $number = '';
  33. foreach($digits as $d){
  34. $number .= $allowedNumbers[$d];
  35. }
  36. $unique_id = $number;
  37. return $unique_id;
  38. }
  39. /**
  40. * Create Application Form controller.
  41. *
  42. * @return json
  43. */
  44. public function getApplicationData($startdate,$enddate,$type,$package,$building,$dealer,$agent){
  45. if($startdate == '-' && $enddate == '-'){
  46. if($package == 'null' && $dealer == 'null'){
  47. $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->get();
  48. }else if($package == 'null' && $dealer != 'null'){
  49. $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('company_id', $dealer)->get();
  50. }else if($package == 'R' && $building == 'null' && $dealer == 'null'){
  51. $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->get();
  52. }else if($package == 'R' && $building == 'null' && $dealer != 'null'){
  53. $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->where('company_id', $dealer)->get();
  54. }else if($package == 'R' && $building != 'null' && $dealer == 'null'){
  55. $form = Form::with(['Subscriber' => function($q) use($building) {
  56. $q->where('building_name', $building);
  57. }],'PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->get();
  58. }else if($package == 'R' && $building != 'null' && $dealer != 'null'){
  59. $form = Form::with(['Subscriber' => function($q) use($building) {
  60. $q->where('building_name', $building);
  61. }],'PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->where('company_id', $dealer)->get();
  62. }else if($package == 'B' && $dealer == 'null'){
  63. $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->get();
  64. }else if($package == 'B' && $dealer != 'null'){
  65. $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->where('company_id', $dealer)->get();
  66. }
  67. }else if($startdate != '-'){
  68. $dateS = Carbon::createFromFormat('Y-m-d', $startdate);
  69. $start = $dateS->copy()->startOfDay();
  70. if($enddate != '-'){
  71. $dateE = Carbon::createFromFormat('Y-m-d', $enddate);
  72. $end = $dateE->copy()->endOfDay();
  73. }else{
  74. $end = $dateS->copy()->endOfDay();
  75. }
  76. if($package == 'null' && $dealer == 'null'){
  77. $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->whereBetween('created_at', array($start, $end))->get();
  78. }else if($package == 'null' && $dealer != 'null'){
  79. $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('company_id', $dealer)->whereBetween('created_at',[$start, $end])->get();
  80. }else if($package == 'R' && $building == 'null' && $dealer == 'null'){
  81. $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->whereBetween('created_at',[$start, $end])->get();
  82. }else if($package == 'R' && $building == 'null' && $dealer != 'null'){
  83. $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->whereBetween('created_at',[$start, $end])->where('company_id', $dealer)->get();
  84. }else if($package == 'R' && $building != 'null' && $dealer == 'null'){
  85. $form = Form::with(['Subscriber' => function($q) use($building) {
  86. $q->where('building_name', $building);
  87. }],'PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->whereBetween('created_at',[$start, $end])->get();
  88. }else if($package == 'R' && $building != 'null' && $dealer != 'null'){
  89. $form = Form::with(['Subscriber' => function($q) use($building) {
  90. $q->where('building_name', $building);
  91. }],'PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->where('company_id', $dealer)->whereBetween('created_at',[$start, $end])->get();
  92. }else if($package == 'B' && $dealer == 'null'){
  93. $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->whereBetween('created_at',[$start, $end])->get();
  94. }else if($package == 'B' && $dealer != 'null'){
  95. $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->whereBetween('created_at',[$start, $end])->where('company_id', $dealer)->get();
  96. }
  97. }
  98. return $form;
  99. }
  100. public function displayApplicationData($startdate,$enddate,$type,$package,$building,$dealer,$agent){
  101. $i = 0;
  102. $curr = Carbon::now()->getTimestamp();
  103. $nested_data = array();
  104. $form = $this->getApplicationData($startdate,$enddate,$type,$package,$building,$dealer,$agent);
  105. if(!empty($form)){
  106. foreach ($form as $key => $f) {
  107. if($f->type_service != 'Rectification'){
  108. if($f->status_form != 'Draft' || empty($f->status_form)){
  109. $nP = ''; $n1 = ''; $labelD = ''; $agentN = '';
  110. $reg_time = $f->created_at;
  111. $expiry_date = $reg_time->addDays(3);
  112. $expiry_date = $expiry_date->getTimestamp();
  113. if($curr < $expiry_date) { $n1 = 'New/';
  114. }else{ $n1 = ''; }
  115. if(empty($f->WorkOrder) && !empty($f->Subscriber) && !empty($f->PackageDetail) && !$f->trashed()){
  116. $wo = ''; $work_order = ''; $building = ''; $unit = '-'; $address = '';
  117. /*** Package ***/
  118. if($f->PackageDetail->voice_fee == 'Yes' || $f->PackageDetail->voice_fee == 'YES'){
  119. $nP = 'Yes';
  120. }else if($f->PackageDetail->voice_fee == 'No' || $f->PackageDetail->voice_fee == 'NO'){
  121. $nP = 'No';
  122. }else if($f->PackageDetail->voice_fee == ''){
  123. $nP = '-';
  124. }
  125. /*** Generate Work Order ID ***/
  126. do {
  127. $work_order = 'WO-'.$this->createWorkID(4);
  128. if($f->status_email == 'verified'){
  129. $wo = $work_order.'/'.$f->Subscriber->subscriber_id;
  130. }else{
  131. $wo = '';
  132. }
  133. } while (WorkOrder::where("wo", "=", $work_order)->first() instanceof WorkOrder);
  134. if($f->type_application == 'R'){
  135. $building = $f->Subscriber->building_name;
  136. $unit = $f->Subscriber->unit_no;
  137. if($f->Subscriber->street != ''){
  138. $address = $f->Subscriber->street. ' , '.$f->Subscriber->postcode. ' , '.$f->Subscriber->city. ' , '.$f->Subscriber->state;
  139. }else {
  140. $address = $f->Subscriber->postcode. ' , '.$f->Subscriber->city. ' , '.$f->Subscriber->state;
  141. }
  142. $cov = Coverage::where('building_name',$f->Subscriber->building_name)->where('Type','R')->first();
  143. if(!empty($cov)){
  144. if($cov->status_building == 'non prelaid'){
  145. $wo = 'Non/'.$wo;
  146. }
  147. }
  148. }else if($f->type_application == 'B'){
  149. if($f->Subscriber->unit_no == ''){
  150. $unit = '-';
  151. }else {
  152. $unit = $f->Subscriber->unit_no;
  153. }
  154. $building = $f->Subscriber->company_name;
  155. $address = $f->Subscriber->street. ' , '.$f->Subscriber->postcode. ' , '.$f->Subscriber->city. ' , '.$f->Subscriber->state;
  156. $cov = Coverage::where('building_name',$f->Subscriber->building_name)->where('Type','B')->first();
  157. if(!empty($cov)){
  158. if($cov->status_building == 'non prelaid'){
  159. $wo = 'Non/'.$wo;
  160. }
  161. }
  162. }
  163. if(!empty($f->dealer_id)){
  164. $company = Company::where('_id', $f->company_id)->first();
  165. $com = explode(' ',trim($company->name));
  166. $labelD = 'D/'.$com[0].'.';
  167. $agentN = Staff::with('StaffDetail')->where('_id', $f->dealer_id)->first();
  168. $agentN = $agentN->StaffDetail->name;
  169. }else{
  170. $labelD = '';
  171. $agentN = '';
  172. }
  173. if($f->type_service == $type){
  174. if($agent == 'null'){
  175. $i++;
  176. array_push($nested_data, array(
  177. 'formT' => $n1.$i.$f->type_application,
  178. 'date' => $f->created_at->toDateTimeString(),
  179. 'type' => $f->type_service,
  180. 'name' => $labelD.$f->Subscriber->name,
  181. 'phone' => $f->Subscriber->phone1,
  182. 'postcode' => $f->Subscriber->postcode,
  183. 'city' => $f->Subscriber->city,
  184. 'unit' => $unit,
  185. 'building' => $building,
  186. 'street' => $address,
  187. 'need_phone' => $nP,
  188. 'email' => $f->status_email,
  189. 'action1' => $wo,
  190. 'action2' => $f->_id,
  191. 'agent' => $agentN
  192. ));
  193. }else if($f->dealer_id == $agent){
  194. $i++;
  195. array_push($nested_data, array(
  196. 'formT' => $n1.$i.$f->type_application,
  197. 'date' => $f->created_at->toDateTimeString(),
  198. 'type' => $f->type_service,
  199. 'name' => $labelD.$f->Subscriber->name,
  200. 'phone' => $f->Subscriber->phone1,
  201. 'postcode' => $f->Subscriber->postcode,
  202. 'city' => $f->Subscriber->city,
  203. 'unit' => $unit,
  204. 'building' => $building,
  205. 'street' => $address,
  206. 'need_phone' => $nP,
  207. 'email' => $f->status_email,
  208. 'action1' => $wo,
  209. 'action2' => $f->_id,
  210. 'agent' => $agentN
  211. ));
  212. }
  213. }else if($type == 'null'){
  214. if($agent == 'null'){
  215. $i++;
  216. array_push($nested_data, array(
  217. 'formT' => $n1.$i.$f->type_application,
  218. 'date' => $f->created_at->toDateTimeString(),
  219. 'type' => $f->type_service,
  220. 'name' => $labelD.$f->Subscriber->name,
  221. 'phone' => $f->Subscriber->phone1,
  222. 'postcode' => $f->Subscriber->postcode,
  223. 'city' => $f->Subscriber->city,
  224. 'unit' => $unit,
  225. 'building' => $building,
  226. 'street' => $address,
  227. 'need_phone' => $nP,
  228. 'email' => $f->status_email,
  229. 'action1' => $wo,
  230. 'action2' => $f->_id,
  231. 'agent' => $agentN
  232. ));
  233. }else if($f->dealer_id == $agent){
  234. $i++;
  235. array_push($nested_data, array(
  236. 'formT' => $n1.$i.$f->type_application,
  237. 'date' => $f->created_at->toDateTimeString(),
  238. 'type' => $f->type_service,
  239. 'name' => $labelD.$f->Subscriber->name,
  240. 'phone' => $f->Subscriber->phone1,
  241. 'postcode' => $f->Subscriber->postcode,
  242. 'city' => $f->Subscriber->city,
  243. 'unit' => $unit,
  244. 'building' => $building,
  245. 'street' => $address,
  246. 'need_phone' => $nP,
  247. 'email' => $f->status_email,
  248. 'action1' => $wo,
  249. 'action2' => $f->_id,
  250. 'agent' => $agentN
  251. ));
  252. }
  253. }
  254. }
  255. }
  256. }
  257. }
  258. }
  259. return \DataTables::of($nested_data)->make(true);
  260. }
  261. public function displayRectificationData($startdate,$enddate,$type,$package,$building,$dealer,$agent){
  262. $i = 0;
  263. $curr = Carbon::now()->getTimestamp();
  264. $nested_data = array();
  265. $form = $this->getApplicationData($startdate,$enddate,$type,$package,$building,$dealer,$agent);
  266. if(!empty($form)){
  267. foreach ($form as $key => $f) {
  268. if($f->type_service == $type){
  269. $wo = ''; $n1 = ''; $do = '';
  270. $reg_time = $f->created_at;
  271. $expiry_date = $reg_time->addDays(3);
  272. $expiry_date = $expiry_date->getTimestamp();
  273. if($curr < $expiry_date) { $n1 = 'New/';
  274. }else{ $n1 = ''; }
  275. if(!empty($f->Subscriber) && !empty($f->PackageDetail)){
  276. if(!empty($f->WorkOrder)){
  277. $wo = $f->WorkOrder->wo;
  278. if($f->WorkOrder->status == "Completed"){
  279. $doc = Docket::where('work_order_id',$f->WorkOrder->wo)->first();
  280. if(!empty($doc)){
  281. $do = $doc->docket_id;
  282. }
  283. }else{
  284. $do = "";
  285. }
  286. }
  287. if($f->type_application == 'R'){
  288. $building = $f->Subscriber->building_name;
  289. $unit = $f->Subscriber->unit_no;
  290. if($f->Subscriber->street != ''){
  291. $address = $f->Subscriber->street;
  292. }else {
  293. $address = '-';
  294. }
  295. }else if($f->type_application == 'B'){
  296. if($f->Subscriber->unit_no == ''){
  297. $unit = '-';
  298. }else {
  299. $unit = $f->Subscriber->unit_no;
  300. }
  301. $building = $f->Subscriber->company_name;
  302. $address = $f->Subscriber->street;
  303. }
  304. $i++;
  305. array_push($nested_data, array(
  306. 'formT' => $n1.$i.$f->type_application,
  307. 'submittion' => Carbon::parse($f->created_at)->toDateString(),
  308. 'type' => $f->type_service,
  309. 'name' => $f->Subscriber->name,
  310. 'phone' => $f->Subscriber->phone1,
  311. 'unit' => $unit,
  312. 'building' => $building,
  313. 'street' => $address,
  314. 'postcode' => $f->Subscriber->postcode,
  315. 'city' => $f->Subscriber->city,
  316. 'action1' => $f->_id,
  317. 'action2' => $wo,
  318. 'action3' => $do
  319. ));
  320. }
  321. }
  322. }
  323. }
  324. return \DataTables::of($nested_data)->make(true);
  325. }
  326. public function displayPendingData($startdate,$enddate,$type,$package,$building,$dealer,$agent){
  327. $i = 0;
  328. $curr = Carbon::now()->getTimestamp();
  329. $nested_data = array();
  330. $form = $this->getApplicationData($startdate,$enddate,$type,$package,$building,$dealer,$agent);
  331. if(!empty($form)){
  332. foreach ($form as $key => $f) {
  333. if($f->type_service != 'Rectification'){
  334. $wo = ''; $n1 = ''; $do = ''; $agentN = '';
  335. $reg_time = $f->created_at;
  336. $expiry_date = $reg_time->addDays(3);
  337. $expiry_date = $expiry_date->getTimestamp();
  338. if(!empty($f->Subscriber) && !empty($f->PackageDetail) && !empty($f->WorkOrder)){
  339. if($f->WorkOrder->status != "Completed"){
  340. $wo = $f->WorkOrder->wo;
  341. if($f->type_application == 'R'){
  342. $building = $f->Subscriber->building_name;
  343. $unit = $f->Subscriber->unit_no;
  344. if($f->Subscriber->street != ''){
  345. $address = $f->Subscriber->street;
  346. }else {
  347. $address = '-';
  348. }
  349. }else if($f->type_application == 'B'){
  350. if($f->Subscriber->unit_no == ''){
  351. $unit = '-';
  352. }else {
  353. $unit = $f->Subscriber->unit_no;
  354. }
  355. $building = $f->Subscriber->company_name;
  356. $address = $f->Subscriber->street;
  357. }
  358. if(!empty($f->dealer_id)){
  359. $company = Company::where('_id', $f->company_id)->first();
  360. $com = explode(' ',trim($company->name));
  361. $labelD = 'D/'.$com[0].'.';
  362. $agentN = Staff::with('StaffDetail')->where('_id', $f->dealer_id)->first();
  363. $agentN = $agentN->StaffDetail->name;
  364. }else{
  365. $labelD = '';
  366. $agentN = '';
  367. }
  368. if($f->type_service == $type){
  369. if($agent == 'null'){
  370. $i++;
  371. array_push($nested_data, array(
  372. 'formT' => $n1.$i.$f->type_application,
  373. 'submittion' => Carbon::parse($f->created_at)->toDateString(),
  374. 'type' => $f->type_service,
  375. 'name' => $labelD.$f->Subscriber->name,
  376. 'phone' => $f->Subscriber->phone1,
  377. 'unit' => $unit,
  378. 'building' => $building,
  379. 'street' => $address,
  380. 'postcode' => $f->Subscriber->postcode,
  381. 'city' => $f->Subscriber->city,
  382. 'action1' => $f->_id,
  383. 'action2' => $wo,
  384. 'agent' => $agentN
  385. ));
  386. }else if($f->dealer_id == $agent){
  387. $i++;
  388. array_push($nested_data, array(
  389. 'formT' => $n1.$i.$f->type_application,
  390. 'submittion' => Carbon::parse($f->created_at)->toDateString(),
  391. 'type' => $f->type_service,
  392. 'name' => $labelD.$f->Subscriber->name,
  393. 'phone' => $f->Subscriber->phone1,
  394. 'unit' => $unit,
  395. 'building' => $building,
  396. 'street' => $address,
  397. 'postcode' => $f->Subscriber->postcode,
  398. 'city' => $f->Subscriber->city,
  399. 'action1' => $f->_id,
  400. 'action2' => $wo,
  401. 'agent' => $agentN
  402. ));
  403. }
  404. }else if($type == 'null'){
  405. if($agent == 'null'){
  406. $i++;
  407. array_push($nested_data, array(
  408. 'formT' => $n1.$i.$f->type_application,
  409. 'submittion' => Carbon::parse($f->created_at)->toDateString(),
  410. 'type' => $f->type_service,
  411. 'name' => $labelD.$f->Subscriber->name,
  412. 'phone' => $f->Subscriber->phone1,
  413. 'unit' => $unit,
  414. 'building' => $building,
  415. 'street' => $address,
  416. 'postcode' => $f->Subscriber->postcode,
  417. 'city' => $f->Subscriber->city,
  418. 'action1' => $f->_id,
  419. 'action2' => $wo,
  420. 'agent' => $agentN
  421. ));
  422. }else if($f->dealer_id == $agent){
  423. $i++;
  424. array_push($nested_data, array(
  425. 'formT' => $n1.$i.$f->type_application,
  426. 'submittion' => Carbon::parse($f->created_at)->toDateString(),
  427. 'type' => $f->type_service,
  428. 'name' => $labelD.$f->Subscriber->name,
  429. 'phone' => $f->Subscriber->phone1,
  430. 'unit' => $unit,
  431. 'building' => $building,
  432. 'street' => $address,
  433. 'postcode' => $f->Subscriber->postcode,
  434. 'city' => $f->Subscriber->city,
  435. 'action1' => $f->_id,
  436. 'action2' => $wo,
  437. 'agent' => $agentN
  438. ));
  439. }
  440. }
  441. }
  442. }
  443. }
  444. }
  445. }
  446. return \DataTables::of($nested_data)->make(true);
  447. }
  448. public function displayActivatedData($startdate,$enddate,$type,$package,$building,$dealer,$agent){
  449. $i = 0;
  450. $curr = Carbon::now()->getTimestamp();
  451. $nested_data = array();
  452. $form = $this->getApplicationData($startdate,$enddate,$type,$package,$building,$dealer,$agent);
  453. if(!empty($form)){
  454. foreach ($form as $key => $f) {
  455. if($f->type_service != 'Rectification'){
  456. $wo = ''; $n1 = ''; $do = ''; $agentN = '';
  457. $reg_time = $f->created_at;
  458. $expiry_date = $reg_time->addDays(3);
  459. $expiry_date = $expiry_date->getTimestamp();
  460. if($curr < $expiry_date) { $n1 = 'New/';
  461. }else{ $n1 = ''; }
  462. if(!empty($f->Subscriber) && !empty($f->PackageDetail) && !empty($f->WorkOrder)){
  463. if($f->WorkOrder->status == "Completed"){
  464. $wo = $f->WorkOrder->wo;
  465. $doc = Docket::where('work_order_id',$wo)->first();
  466. if(!empty($doc)){
  467. $do = $doc->docket_id;
  468. if($f->type_application == 'R'){
  469. $building = $f->Subscriber->building_name;
  470. $unit = $f->Subscriber->unit_no;
  471. if($f->Subscriber->street != ''){
  472. $address = $f->Subscriber->street;
  473. }else {
  474. $address = '-';
  475. }
  476. }else if($f->type_application == 'B'){
  477. if($f->Subscriber->unit_no == ''){
  478. $unit = '-';
  479. }else {
  480. $unit = $f->Subscriber->unit_no;
  481. }
  482. $building = $f->Subscriber->company_name;
  483. $address = $f->Subscriber->street;
  484. }
  485. if(!empty($f->dealer_id)){
  486. $company = Company::where('_id', $f->company_id)->first();
  487. $com = explode(' ',trim($company->name));
  488. $labelD = 'D/'.$com[0].'.';
  489. $agentN = Staff::with('StaffDetail')->where('_id', $f->dealer_id)->first();
  490. $agentN = $agentN->StaffDetail->name;
  491. }else{
  492. $labelD = '';
  493. $agentN = '';
  494. }
  495. if($f->type_service == $type){
  496. if($agent == 'null'){
  497. $i++;
  498. array_push($nested_data, array(
  499. 'formT' => $n1.$i.$f->type_application,
  500. 'submittion' => Carbon::parse($f->created_at)->toDateString(),
  501. 'type' => $f->type_service,
  502. 'name' => $labelD.$f->Subscriber->name,
  503. 'phone' => $f->Subscriber->phone1,
  504. 'unit' => $unit,
  505. 'building' => $building,
  506. 'street' => $address,
  507. 'postcode' => $f->Subscriber->postcode,
  508. 'city' => $f->Subscriber->city,
  509. 'action1' => $f->_id,
  510. 'action2' => $wo,
  511. 'action3' => $do,
  512. 'action4' => $wo,
  513. 'agent' => $agentN
  514. ));
  515. }else if($f->dealer_id == $agent){
  516. $i++;
  517. array_push($nested_data, array(
  518. 'formT' => $n1.$i.$f->type_application,
  519. 'submittion' => Carbon::parse($f->created_at)->toDateString(),
  520. 'type' => $f->type_service,
  521. 'name' => $labelD.$f->Subscriber->name,
  522. 'phone' => $f->Subscriber->phone1,
  523. 'unit' => $unit,
  524. 'building' => $building,
  525. 'street' => $address,
  526. 'postcode' => $f->Subscriber->postcode,
  527. 'city' => $f->Subscriber->city,
  528. 'action1' => $f->_id,
  529. 'action2' => $wo,
  530. 'action3' => $do,
  531. 'action4' => $wo,
  532. 'agent' => $agentN
  533. ));
  534. }
  535. }else if($type == 'null'){
  536. if($agent == 'null'){
  537. $i++;
  538. array_push($nested_data, array(
  539. 'formT' => $n1.$i.$f->type_application,
  540. 'submittion' => Carbon::parse($f->created_at)->toDateString(),
  541. 'type' => $f->type_service,
  542. 'name' => $labelD.$f->Subscriber->name,
  543. 'phone' => $f->Subscriber->phone1,
  544. 'unit' => $unit,
  545. 'building' => $building,
  546. 'street' => $address,
  547. 'postcode' => $f->Subscriber->postcode,
  548. 'city' => $f->Subscriber->city,
  549. 'action1' => $f->_id,
  550. 'action2' => $wo,
  551. 'action3' => $do,
  552. 'action4' => $wo,
  553. 'agent' => $agentN
  554. ));
  555. }else if($f->dealer_id == $agent){
  556. $i++;
  557. array_push($nested_data, array(
  558. 'formT' => $n1.$i.$f->type_application,
  559. 'submittion' => Carbon::parse($f->created_at)->toDateString(),
  560. 'type' => $f->type_service,
  561. 'name' => $labelD.$f->Subscriber->name,
  562. 'phone' => $f->Subscriber->phone1,
  563. 'unit' => $unit,
  564. 'building' => $building,
  565. 'street' => $address,
  566. 'postcode' => $f->Subscriber->postcode,
  567. 'city' => $f->Subscriber->city,
  568. 'action1' => $f->_id,
  569. 'action2' => $wo,
  570. 'action3' => $do,
  571. 'action4' => $wo,
  572. 'agent' => $agentN
  573. ));
  574. }
  575. }
  576. }
  577. }
  578. }
  579. }
  580. }
  581. }
  582. return \DataTables::of($nested_data)->make(true);
  583. }
  584. public function getDealerForm($startdate,$enddate,$type,$package,$building,$dealer,$agent){
  585. if($startdate == '-' && $enddate == '-'){
  586. if($package == 'null' && $dealer == 'null'){
  587. $form = Form::with('Subscriber','PackageDetail','WorkOrder')->whereNotNull('dealer_id')->orderBy('created_at', 'desc')->get();
  588. }else if($package == 'null' && $dealer != 'null'){
  589. $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('company_id', $dealer)->get();
  590. }else if($package == 'R' && $building == 'null' && $dealer == 'null'){
  591. $form = Form::with('Subscriber','PackageDetail','WorkOrder')->whereNotNull('dealer_id')->orderBy('created_at', 'desc')->where('type_application', $package)->get();
  592. }else if($package == 'R' && $building == 'null' && $dealer != 'null'){
  593. $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->where('company_id', $dealer)->get();
  594. }else if($package == 'R' && $building != 'null' && $dealer == 'null'){
  595. $form = Form::with(['Subscriber' => function($q) use($building) {
  596. $q->where('building_name', $building);
  597. }],'PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->whereNotNull('dealer_id')->where('type_application', $package)->get();
  598. }else if($package == 'R' && $building != 'null' && $dealer != 'null'){
  599. $form = Form::with(['Subscriber' => function($q) use($building) {
  600. $q->where('building_name', $building);
  601. }],'PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->where('company_id', $dealer)->get();
  602. }else if($package == 'B' && $dealer == 'null'){
  603. $form = Form::with('Subscriber','PackageDetail','WorkOrder')->whereNotNull('dealer_id')->orderBy('created_at', 'desc')->where('type_application', $package)->get();
  604. }else if($package == 'B' && $dealer != 'null'){
  605. $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->where('company_id', $dealer)->get();
  606. }
  607. }else if($startdate != '-'){
  608. $dateS = Carbon::createFromFormat('Y-m-d', $startdate);
  609. $start = $dateS->copy()->startOfDay();
  610. if($enddate != '-'){
  611. $dateE = Carbon::createFromFormat('Y-m-d', $enddate);
  612. $end = $dateE->copy()->endOfDay();
  613. }else{
  614. $end = $dateS->copy()->endOfDay();
  615. }
  616. if($package == 'null' && $dealer == 'null'){
  617. $form = Form::with('Subscriber','PackageDetail','WorkOrder')->whereNotNull('dealer_id')->orderBy('created_at', 'desc')->whereBetween('created_at', array($start, $end))->get();
  618. }else if($package == 'null' && $dealer != 'null'){
  619. $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('company_id', $dealer)->whereBetween('created_at',[$start, $end])->get();
  620. }else if($package == 'R' && $building == 'null' && $dealer == 'null'){
  621. $form = Form::with('Subscriber','PackageDetail','WorkOrder')->whereNotNull('dealer_id')->orderBy('created_at', 'desc')->where('type_application', $package)->whereBetween('created_at',[$start, $end])->get();
  622. }else if($package == 'R' && $building == 'null' && $dealer != 'null'){
  623. $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->whereBetween('created_at',[$start, $end])->where('company_id', $dealer)->get();
  624. }else if($package == 'R' && $building != 'null' && $dealer == 'null'){
  625. $form = Form::with(['Subscriber' => function($q) use($building) {
  626. $q->where('building_name', $building);
  627. }],'PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->whereNotNull('dealer_id')->where('type_application', $package)->whereBetween('created_at',[$start, $end])->get();
  628. }else if($package == 'R' && $building != 'null' && $dealer != 'null'){
  629. $form = Form::with(['Subscriber' => function($q) use($building) {
  630. $q->where('building_name', $building);
  631. }],'PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->where('company_id', $dealer)->whereBetween('created_at',[$start, $end])->get();
  632. }else if($package == 'B' && $dealer == 'null'){
  633. $form = Form::with('Subscriber','PackageDetail','WorkOrder')->whereNotNull('dealer_id')->orderBy('created_at', 'desc')->where('type_application', $package)->whereBetween('created_at',[$start, $end])->get();
  634. }else if($package == 'B' && $dealer != 'null'){
  635. $form = Form::with('Subscriber','PackageDetail','WorkOrder')->orderBy('created_at', 'desc')->where('type_application', $package)->whereBetween('created_at',[$start, $end])->where('company_id', $dealer)->get();
  636. }
  637. }
  638. return $form;
  639. }
  640. public function displayDealerForm($startdate,$enddate,$type,$package,$building,$dealer,$agent){
  641. $i = 0;
  642. $curr = Carbon::now()->getTimestamp();
  643. $nested_data = array();
  644. $form = $this->getDealerForm($startdate,$enddate,$type,$package,$building,$dealer,$agent);
  645. if(!empty($form)){
  646. foreach ($form as $key => $f) {
  647. $wo = ''; $n1 = ''; $do = ''; $agentN = '';
  648. $reg_time = $f->created_at;
  649. $expiry_date = $reg_time->addDays(3);
  650. $expiry_date = $expiry_date->getTimestamp();
  651. if($curr < $expiry_date) { $n1 = 'New/';
  652. }else{ $n1 = ''; }
  653. if(!empty($f->dealer_id)){
  654. $company = Company::where('_id', $f->company_id)->first();
  655. $com = explode(' ',trim($company->name));
  656. $labelD = 'D/'.$com[0].'.';
  657. $agentN = Staff::with('StaffDetail')->where('_id', $f->dealer_id)->first();
  658. $agentN = $agentN->StaffDetail->name;
  659. if(!empty($f->Subscriber) && !empty($f->PackageDetail)){
  660. if(!empty($f->WorkOrder)){
  661. $wo = $f->WorkOrder->wo;
  662. if($f->WorkOrder->status == "Completed"){
  663. $doc = Docket::where('work_order_id',$wo)->first();
  664. if(!empty($doc)){ $do = $doc->docket_id; }
  665. }
  666. }
  667. if($f->type_application == 'R'){
  668. $building = $f->Subscriber->building_name;
  669. $unit = $f->Subscriber->unit_no;
  670. if($f->Subscriber->street != ''){
  671. $address = $f->Subscriber->street;
  672. }else {
  673. $address = '-';
  674. }
  675. }else if($f->type_application == 'B'){
  676. if($f->Subscriber->unit_no == ''){
  677. $unit = '-';
  678. }else {
  679. $unit = $f->Subscriber->unit_no;
  680. }
  681. $building = $f->Subscriber->company_name;
  682. $address = $f->Subscriber->street;
  683. }
  684. if($f->type_service == $type){
  685. if($agent == 'null'){
  686. $i++;
  687. array_push($nested_data, array(
  688. 'formT' => $n1.$i.$f->type_application,
  689. 'submittion' => Carbon::parse($f->created_at)->toDateString(),
  690. 'type' => $f->type_service,
  691. 'name' => $labelD.$f->Subscriber->name,
  692. 'phone' => $f->Subscriber->phone1,
  693. 'unit' => $unit,
  694. 'building' => $building,
  695. 'street' => $address,
  696. 'postcode' => $f->Subscriber->postcode,
  697. 'city' => $f->Subscriber->city,
  698. 'action1' => $f->_id,
  699. 'action2' => $wo,
  700. 'action3' => $do,
  701. 'action4' => $wo,
  702. 'agent' => $agentN
  703. ));
  704. }else if($f->dealer_id == $agent){
  705. $i++;
  706. array_push($nested_data, array(
  707. 'formT' => $n1.$i.$f->type_application,
  708. 'submittion' => Carbon::parse($f->created_at)->toDateString(),
  709. 'type' => $f->type_service,
  710. 'name' => $labelD.$f->Subscriber->name,
  711. 'phone' => $f->Subscriber->phone1,
  712. 'unit' => $unit,
  713. 'building' => $building,
  714. 'street' => $address,
  715. 'postcode' => $f->Subscriber->postcode,
  716. 'city' => $f->Subscriber->city,
  717. 'action1' => $f->_id,
  718. 'action2' => $wo,
  719. 'action3' => $do,
  720. 'action4' => $wo,
  721. 'agent' => $agentN
  722. ));
  723. }
  724. }else if($type == 'null'){
  725. if($agent == 'null'){
  726. $i++;
  727. array_push($nested_data, array(
  728. 'formT' => $n1.$i.$f->type_application,
  729. 'submittion' => Carbon::parse($f->created_at)->toDateString(),
  730. 'type' => $f->type_service,
  731. 'name' => $labelD.$f->Subscriber->name,
  732. 'phone' => $f->Subscriber->phone1,
  733. 'unit' => $unit,
  734. 'building' => $building,
  735. 'street' => $address,
  736. 'postcode' => $f->Subscriber->postcode,
  737. 'city' => $f->Subscriber->city,
  738. 'action1' => $f->_id,
  739. 'action2' => $wo,
  740. 'action3' => $do,
  741. 'action4' => $wo,
  742. 'agent' => $agentN
  743. ));
  744. }else if($f->dealer_id == $agent){
  745. $i++;
  746. array_push($nested_data, array(
  747. 'formT' => $n1.$i.$f->type_application,
  748. 'submittion' => Carbon::parse($f->created_at)->toDateString(),
  749. 'type' => $f->type_service,
  750. 'name' => $labelD.$f->Subscriber->name,
  751. 'phone' => $f->Subscriber->phone1,
  752. 'unit' => $unit,
  753. 'building' => $building,
  754. 'street' => $address,
  755. 'postcode' => $f->Subscriber->postcode,
  756. 'city' => $f->Subscriber->city,
  757. 'action1' => $f->_id,
  758. 'action2' => $wo,
  759. 'action3' => $do,
  760. 'action4' => $wo,
  761. 'agent' => $agentN
  762. ));
  763. }
  764. }
  765. }
  766. }
  767. }
  768. }
  769. return \DataTables::of($nested_data)->make(true);
  770. }
  771. /**
  772. * Create Data Form controller.
  773. *
  774. * @return json
  775. */
  776. public function filterByTypeADate($type, $startdate, $enddate){
  777. if($type == 'All' && $startdate == 'null'){
  778. $form = Form::with('Subscriber','PackageDetail')->orderBy('created_at', 'desc');
  779. return $form;
  780. }else if($type == 'All' && $startdate != 'null'){
  781. $dateS = Carbon::createFromFormat('Y-m-d', $startdate);
  782. $start = $dateS->copy()->startOfDay();
  783. $dateE = Carbon::createFromFormat('Y-m-d', $enddate);
  784. $end = $dateE->copy()->endOfDay();
  785. $form = Form::with('Subscriber','PackageDetail')->orderBy('created_at', 'desc')->whereBetween('created_at', array($start, $end));
  786. return $form;
  787. }else if($type != 'All' && $startdate == 'null'){
  788. $form = Form::with('Subscriber','PackageDetail')->where('type_service',$type)->orderBy('created_at', 'desc');
  789. return $form;
  790. }else if($type != 'All' && $startdate == 'null'){
  791. $dateS = Carbon::createFromFormat('Y-m-d', $startdate);
  792. $start = $dateS->copy()->startOfDay();
  793. $dateE = Carbon::createFromFormat('Y-m-d', $enddate);
  794. $end = $dateE->copy()->endOfDay();
  795. $form = Form::with('Subscriber','PackageDetail')->where('type_service',$type)->orderBy('created_at', 'desc')->whereBetween('created_at', array($start, $end));
  796. return $form;
  797. }
  798. }
  799. public function filterByPackage($type,$startdate,$enddate,$package){
  800. $form = $this->filterByTypeADate($type,$startdate,$enddate);
  801. if($package == 'All'){
  802. return $form;
  803. }else{
  804. $form = $form->where('type_application', $package);
  805. return $form;
  806. }
  807. }
  808. public function filterByBuilding($type,$startdate,$enddate,$package,$building){
  809. $form = $this->filterByPackage($type,$startdate,$enddate,$package);
  810. if($building == 'null'){
  811. return $form->with('Subscriber');
  812. }else{
  813. return $form->with(['Subscriber' => function($q) use($building) {
  814. $q->where('building_name', $building);
  815. }]);
  816. }
  817. }
  818. public function filterByDealer($type,$startdate,$enddate,$package,$building,$dealer){
  819. $form = $this->filterByBuilding($type,$startdate,$enddate,$package,$building);
  820. if($dealer != 'null'){
  821. $form = $form->where('company_id', $dealer);
  822. return $form;
  823. }else{
  824. return $form;
  825. }
  826. }
  827. public function filterByAgent($type,$startdate,$enddate,$package,$building,$dealer,$agent){
  828. $form = $this->filterByDealer($type,$startdate,$enddate,$package,$building,$dealer);
  829. if($agent == 'null'){
  830. return $form;
  831. }else{
  832. $form = $form->where('dealer_id', $agent);
  833. return $form;
  834. }
  835. }
  836. public function displayNewData($type,$startdate,$enddate,$package,$building,$dealer,$agent,$subcriber){
  837. if($dealer != 'null' && $agent != 'null'){
  838. $form = $this->filterByAgent($type,$startdate,$enddate,$package,$building,$dealer,$agent);
  839. }else if($dealer != 'null' && $agent == 'null'){
  840. $form = $this->filterByDealer($type,$startdate,$enddate,$package,$building,$dealer);
  841. }else if($dealer == 'null' && $agent == 'null'){
  842. $form = $this->filterByDealer($type,$startdate,$enddate,$package,$building,$dealer);
  843. }
  844. if($subcriber != 'null'){
  845. $form = $form->with(['Subscriber' => function($q) use($subcriber) {
  846. $q->where('subscriber_id', 'CBB-'.$subcriber);
  847. }],'PackageDetail','WorkOrder')->get();
  848. }else{
  849. $form = $form->with('PackageDetail','WorkOrder')->get();
  850. }
  851. $i = 0;
  852. $curr = Carbon::now()->getTimestamp();
  853. $nested_data = array();
  854. if(!empty($form)){
  855. foreach ($form as $key => $f) {
  856. $n1 = ''; $labelD = ''; $agent = ''; $name = '';
  857. $reg_time = $f->created_at;
  858. $expiry_date = $reg_time->addDays(3);
  859. $expiry_date = $expiry_date->getTimestamp();
  860. if($curr < $expiry_date) { $n1 = 'New/';
  861. }else{ $n1 = ''; }
  862. if(!empty($f->dealer_id)){
  863. $company = Company::where('_id', $f->company_id)->first();
  864. $com = explode(' ',trim($company->name));
  865. $labelD = 'D/'.$com[0].'.';
  866. $agent = Staff::with('StaffDetail')->where('_id', $f->dealer_id)->first();
  867. $agent = $agent->StaffDetail->name;
  868. }else{ $labelD = ''; }
  869. if(!empty($f->Subscriber) && !empty($f->PackageDetail) && empty($f->WorkOrder) && $f->type_service != "Rectification"){
  870. $wo = ''; $work_order = ''; $building = ''; $unit = '-'; $address = '';
  871. /*** Package ***/
  872. if($f->PackageDetail->voice_fee == 'Yes' || $f->PackageDetail->voice_fee == 'YES'){
  873. $nP = 'Yes';
  874. }else if($f->PackageDetail->voice_fee == 'No' || $f->PackageDetail->voice_fee == 'NO'){
  875. $nP = 'No';
  876. }else if($f->PackageDetail->voice_fee == ''){
  877. $nP = '-';
  878. }
  879. /*** Generate Work Order ID ***/
  880. do {
  881. $work_order = 'WO-'.$this->createWorkID(4);
  882. if($f->status_email == 'verified'){
  883. $wo = $work_order.'/'.$f->Subscriber->subscriber_id;
  884. }else{
  885. $wo = '';
  886. }
  887. } while (WorkOrder::where("wo", "=", $work_order)->first() instanceof WorkOrder);
  888. if($f->type_application == 'R'){
  889. $name = $f->Subscriber->name;
  890. $building = $f->Subscriber->building_name;
  891. $unit = $f->Subscriber->unit_no;
  892. if($f->Subscriber->street != ''){
  893. $address = $f->Subscriber->street. ', '.$f->Subscriber->postcode. ' , '.$f->Subscriber->city. ', '.$f->Subscriber->state;
  894. }else {
  895. $address = $f->Subscriber->postcode. ', '.$f->Subscriber->city. ', '.$f->Subscriber->state;
  896. }
  897. }else if($f->type_application == 'B'){
  898. if($f->Subscriber->unit_no == ''){
  899. $unit = '-';
  900. }else {
  901. $unit = $f->Subscriber->unit_no;
  902. }
  903. $name = $f->Subscriber->company_name;
  904. $building = $f->Subscriber->building_name;
  905. $address = $f->Subscriber->street. ', '.$f->Subscriber->postcode. ', '.$f->Subscriber->city. ', '.$f->Subscriber->state;
  906. }
  907. $i++;
  908. array_push($nested_data, array(
  909. 'formT' => $n1.$i.$f->type_application,
  910. 'date' => $f->created_at->toDateString(),
  911. 'id' => str_replace("CBB-","",$f->Subscriber->subscriber_id),
  912. 'type' => $f->type_service,
  913. 'name' => $labelD.$f->Subscriber->name,
  914. 'phone' => $f->Subscriber->phone1,
  915. 'unit' => $unit,
  916. 'building' => $building,
  917. 'street' => $address,
  918. 'agent' => $agent,
  919. 'type' => $f->type_service,
  920. 'need_phone' => $nP,
  921. 'email' => $f->status_email,
  922. 'action' => $f->_id,
  923. 'action1' => $wo,
  924. ));
  925. }
  926. }
  927. }
  928. return \DataTables::of($nested_data)->make(true);
  929. }
  930. public function displayProcessData($type,$startdate,$enddate,$package,$building,$dealer,$agent,$subcriber){
  931. if($dealer != 'null' && $agent != 'null'){
  932. $form = $this->filterByAgent($type,$startdate,$enddate,$package,$building,$dealer,$agent);
  933. }else if($dealer != 'null' && $agent == 'null'){
  934. $form = $this->filterByDealer($type,$startdate,$enddate,$package,$building,$dealer);
  935. }
  936. if($subcriber != 'null'){
  937. $form = $form->with(['Subscriber' => function($q) use($subcriber) {
  938. $q->where('subscriber_id', 'CBB-'.$subcriber);
  939. }],'PackageDetail','WorkOrder')->get();
  940. }else{
  941. $form = $form->with('PackageDetail','WorkOrder')->get();
  942. }
  943. $i = 0;
  944. $curr = Carbon::now()->getTimestamp();
  945. $nested_data = array();
  946. if(!empty($form)){
  947. foreach ($form as $key => $f) {
  948. $n1 = ''; $labelD = ''; $agent = ''; $name = '';
  949. $reg_time = $f->created_at;
  950. $expiry_date = $reg_time->addDays(3);
  951. $expiry_date = $expiry_date->getTimestamp();
  952. if($curr < $expiry_date) { $n1 = 'New/';
  953. }else{ $n1 = ''; }
  954. if(!empty($f->dealer_id)){
  955. $company = Company::where('_id', $f->company_id)->first();
  956. $com = explode(' ',trim($company->name));
  957. $labelD = 'D/'.$com[0].'.';
  958. $agent = Staff::with('StaffDetail')->where('_id', $f->dealer_id)->first();
  959. $agent = $agent->StaffDetail->name;
  960. }else{ $labelD = ''; }
  961. if(!empty($f->Subscriber) && !empty($f->PackageDetail) && !empty($f->WorkOrder)){
  962. if($f->type_application == 'R'){
  963. $name = $f->Subscriber->name;
  964. $building = $f->Subscriber->building_name;
  965. $unit = $f->Subscriber->unit_no;
  966. if($f->Subscriber->street != ''){
  967. $address = $f->Subscriber->street. ', '.$f->Subscriber->postcode. ' , '.$f->Subscriber->city. ', '.$f->Subscriber->state;
  968. }else {
  969. $address = $f->Subscriber->postcode. ', '.$f->Subscriber->city. ', '.$f->Subscriber->state;
  970. }
  971. }else if($f->type_application == 'B'){
  972. if($f->Subscriber->unit_no == ''){
  973. $unit = '-';
  974. }else {
  975. $unit = $f->Subscriber->unit_no;
  976. }
  977. $name = $f->Subscriber->company_name;
  978. $building = $f->Subscriber->building_name;
  979. $address = $f->Subscriber->street. ', '.$f->Subscriber->postcode. ', '.$f->Subscriber->city. ', '.$f->Subscriber->state;
  980. }
  981. $i++;
  982. if($f->WorkOrder->status != 'Completed'){
  983. array_push($nested_data, array(
  984. 'formT' => $n1.$i.$f->type_application,
  985. 'wo' => $f->WorkOrder->wo,
  986. 'date' => $f->created_at->toDateString(),
  987. 'id' => str_replace("CBB-","",$f->Subscriber->subscriber_id),
  988. 'type' => $f->type_service,
  989. 'name' => $labelD.$f->Subscriber->name,
  990. 'phone' => $f->Subscriber->phone1,
  991. 'unit' => $unit,
  992. 'building' => $building,
  993. 'street' => $address,
  994. 'agent' => $agent,
  995. 'action' => $f->_id,
  996. ));
  997. }
  998. }
  999. }
  1000. }
  1001. return \DataTables::of($nested_data)->make(true);
  1002. }
  1003. public function displayCompletedData($type,$startdate,$enddate,$package,$building,$dealer,$agent,$subcriber){
  1004. if($dealer != 'null' && $agent != 'null'){
  1005. $form = $this->filterByAgent($type,$startdate,$enddate,$package,$building,$dealer,$agent);
  1006. }else if($dealer != 'null' && $agent == 'null'){
  1007. $form = $this->filterByDealer($type,$startdate,$enddate,$package,$building,$dealer);
  1008. }
  1009. if($subcriber != 'null'){
  1010. $form = $form->with(['Subscriber' => function($q) use($subcriber) {
  1011. $q->where('subscriber_id', 'CBB-'.$subcriber);
  1012. }],'PackageDetail','WorkOrder')->get();
  1013. }else{
  1014. $form = $form->with('PackageDetail','WorkOrder')->get();
  1015. }
  1016. $i = 0;
  1017. $curr = Carbon::now()->getTimestamp();
  1018. $nested_data = array();
  1019. if(!empty($form)){
  1020. foreach ($form as $key => $f) {
  1021. $n1 = ''; $labelD = ''; $agent = ''; $name = '';
  1022. $reg_time = $f->created_at;
  1023. $expiry_date = $reg_time->addDays(3);
  1024. $expiry_date = $expiry_date->getTimestamp();
  1025. if($curr < $expiry_date) { $n1 = 'New/';
  1026. }else{ $n1 = ''; }
  1027. if(!empty($f->dealer_id)){
  1028. $company = Company::where('_id', $f->company_id)->first();
  1029. $com = explode(' ',trim($company->name));
  1030. $labelD = 'D/'.$com[0].'.';
  1031. $agent = Staff::with('StaffDetail')->where('_id', $f->dealer_id)->first();
  1032. $agent = $agent->StaffDetail->name;
  1033. }else{ $labelD = ''; }
  1034. if(!empty($f->Subscriber) && !empty($f->PackageDetail) && !empty($f->WorkOrder)){
  1035. if($f->type_application == 'R'){
  1036. $name = $f->Subscriber->name;
  1037. $building = $f->Subscriber->building_name;
  1038. $unit = $f->Subscriber->unit_no;
  1039. if($f->Subscriber->street != ''){
  1040. $address = $f->Subscriber->street. ', '.$f->Subscriber->postcode. ' , '.$f->Subscriber->city. ', '.$f->Subscriber->state;
  1041. }else {
  1042. $address = $f->Subscriber->postcode. ', '.$f->Subscriber->city. ', '.$f->Subscriber->state;
  1043. }
  1044. }else if($f->type_application == 'B'){
  1045. if($f->Subscriber->unit_no == ''){
  1046. $unit = '-';
  1047. }else {
  1048. $unit = $f->Subscriber->unit_no;
  1049. }
  1050. $name = $f->Subscriber->company_name;
  1051. $building = $f->Subscriber->building_name;
  1052. $address = $f->Subscriber->street. ', '.$f->Subscriber->postcode. ', '.$f->Subscriber->city. ', '.$f->Subscriber->state;
  1053. }
  1054. $i++;
  1055. if($f->WorkOrder->status == 'Completed'){
  1056. $doc = Docket::where('work_order_id',$f->WorkOrder->wo)->first();
  1057. $activated = '-'; $do = '-';
  1058. if(!empty($doc)){
  1059. $do = $doc->docket_id;
  1060. $activated = $doc->end_job;
  1061. }
  1062. array_push($nested_data, array(
  1063. 'formT' => $n1.$i.$f->type_application,
  1064. 'wo' => $f->WorkOrder->wo,
  1065. 'do' => $do,
  1066. 'active' => $activated,
  1067. 'id' => str_replace("CBB-","",$f->Subscriber->subscriber_id),
  1068. 'type' => $f->type_service,
  1069. 'name' => $labelD.$f->Subscriber->name,
  1070. 'phone' => $f->Subscriber->phone1,
  1071. 'unit' => $unit,
  1072. 'building' => $building,
  1073. 'street' => $address,
  1074. 'agent' => $agent,
  1075. 'action' => $f->_id,
  1076. ));
  1077. }
  1078. }
  1079. }
  1080. }
  1081. return \DataTables::of($nested_data)->make(true);
  1082. }
  1083. /**
  1084. * Create Trashed Data Form controller.
  1085. *
  1086. * @return json
  1087. */
  1088. public function filterTrashedByTypeADate($type, $startdate, $enddate){
  1089. if($type == 'All' && $startdate == 'null'){
  1090. $form = Form::with('subscribetrashed','packagedetailtrashed')->orderBy('created_at', 'desc')->onlyTrashed();
  1091. return $form;
  1092. }else if($type == 'All' && $startdate != 'null'){
  1093. $dateS = Carbon::createFromFormat('Y-m-d', $startdate);
  1094. $start = $dateS->copy()->startOfDay();
  1095. $dateE = Carbon::createFromFormat('Y-m-d', $enddate);
  1096. $end = $dateE->copy()->endOfDay();
  1097. $form = Form::with('subscribetrashed','packagedetailtrashed')->orderBy('created_at', 'desc')->whereBetween('created_at', array($start, $end))->onlyTrashed();
  1098. return $form;
  1099. }
  1100. }
  1101. public function filterTrashedByPackage($type,$startdate,$enddate,$package){
  1102. $form = $this->filterTrashedByTypeADate($type,$startdate,$enddate);
  1103. if($package == 'All'){
  1104. return $form;
  1105. }else{
  1106. $form = $form->where('type_application', $package);
  1107. return $form;
  1108. }
  1109. }
  1110. public function filterTrashedByBuilding($type,$startdate,$enddate,$package,$building){
  1111. $form = $this->filterTrashedByPackage($type,$startdate,$enddate,$package);
  1112. if($building == 'null'){
  1113. return $form->with('subscribetrashed');
  1114. }else{
  1115. return $form->with(['subscribetrashed' => function($q) use($building) {
  1116. $q->where('building_name', $building);
  1117. }]);
  1118. }
  1119. }
  1120. public function filterTrashedByDealer($type,$startdate,$enddate,$package,$building,$dealer){
  1121. $form = $this->filterTrashedByBuilding($type,$startdate,$enddate,$package,$building);
  1122. if($dealer != 'null'){
  1123. $form = $form->where('company_id', $dealer);
  1124. return $form;
  1125. }else{
  1126. return $form;
  1127. }
  1128. }
  1129. public function filterTrashedByAgent($type,$startdate,$enddate,$package,$building,$dealer,$agent){
  1130. $form = $this->filterTrashedByDealer($type,$startdate,$enddate,$package,$building,$dealer);
  1131. if($agent == 'null'){
  1132. return $form;
  1133. }else{
  1134. $form = $form->where('dealer_id', $agent);
  1135. return $form;
  1136. }
  1137. }
  1138. public function displayTrashedData($type,$startdate,$enddate,$package,$building,$dealer,$agent,$subcriber){
  1139. if($dealer != 'null' && $agent != 'null'){
  1140. $form = $this->filterTrashedByAgent($type,$startdate,$enddate,$package,$building,$dealer,$agent);
  1141. }else if($dealer != 'null' && $agent == 'null'){
  1142. $form = $this->filterTrashedByDealer($type,$startdate,$enddate,$package,$building,$dealer);
  1143. }else if($dealer == 'null' && $agent == 'null'){
  1144. $form = $this->filterTrashedByDealer($type,$startdate,$enddate,$package,$building,$dealer);
  1145. }
  1146. if($subcriber != 'null'){
  1147. $form = $form->with(['subscribetrashed' => function($q) use($subcriber) {
  1148. $q->where('subscriber_id', 'CBB-'.$subcriber);
  1149. }],'packagedetailtrashed')->get();
  1150. }else{
  1151. $form = $form->with('packagedetailtrashed')->get();
  1152. }
  1153. $i = 0;
  1154. $curr = Carbon::now()->getTimestamp();
  1155. $nested_data = array();
  1156. if(!empty($form)){
  1157. foreach ($form as $key => $f) {
  1158. $n1 = ''; $labelD = ''; $agent = ''; $name = '';
  1159. $reg_time = $f->created_at;
  1160. $expiry_date = $reg_time->addDays(3);
  1161. $expiry_date = $expiry_date->getTimestamp();
  1162. if($curr < $expiry_date) { $n1 = 'New/';
  1163. }else{ $n1 = ''; }
  1164. if(!empty($f->dealer_id)){
  1165. $company = Company::where('_id', $f->company_id)->first();
  1166. $com = explode(' ',trim($company->name));
  1167. $labelD = 'D/'.$com[0].'.';
  1168. $agent = Staff::with('StaffDetail')->where('_id', $f->dealer_id)->first();
  1169. $agent = $agent->StaffDetail->name;
  1170. }else{ $labelD = ''; }
  1171. if(!empty($f->subscribetrashed) && !empty($f->packagedetailtrashed)){
  1172. if($f->type_application == 'R'){
  1173. $name = $f->subscribetrashed->name;
  1174. $building = $f->subscribetrashed->building_name;
  1175. $unit = $f->subscribetrashed->unit_no;
  1176. if($f->subscribetrashed->street != ''){
  1177. $address = $f->subscribetrashed->street. ', '.$f->subscribetrashed->postcode. ' , '.$f->subscribetrashed->city. ', '.$f->subscribetrashed->state;
  1178. }else {
  1179. $address = $f->subscribetrashed->postcode. ', '.$f->subscribetrashed->city. ', '.$f->subscribetrashed->state;
  1180. }
  1181. }else if($f->type_application == 'B'){
  1182. if($f->subscribetrashed->unit_no == ''){
  1183. $unit = '-';
  1184. }else {
  1185. $unit = $f->subscribetrashed->unit_no;
  1186. }
  1187. $name = $f->subscribetrashed->company_name;
  1188. $building = $f->subscribetrashed->building_name;
  1189. $address = $f->subscribetrashed->street. ', '.$f->subscribetrashed->postcode. ', '.$f->subscribetrashed->city. ', '.$f->subscribetrashed->state;
  1190. }
  1191. $i++;
  1192. array_push($nested_data, array(
  1193. 'formT' => $n1.$i.$f->type_application,
  1194. 'date' => $f->created_at->toDateString(),
  1195. 'id' => str_replace("CBB-","",$f->subscribetrashed->subscriber_id),
  1196. 'type' => $f->type_service,
  1197. 'name' => $labelD.$f->subscribetrashed->name,
  1198. 'phone' => $f->subscribetrashed->phone1,
  1199. 'unit' => $unit,
  1200. 'building' => $building,
  1201. 'street' => $address,
  1202. 'agent' => $agent,
  1203. 'remark' => $f->remark_reject,
  1204. 'action' => $f->_id,
  1205. ));
  1206. }
  1207. }
  1208. }
  1209. return \DataTables::of($nested_data)->make(true);
  1210. }
  1211. /**
  1212. * Delete / Reject Form controller
  1213. *
  1214. * @return json
  1215. */
  1216. public function rejectForm(Request $request) {
  1217. $form = Form::with('Subscriber','PackageDetail')->where('_id', $request->id)->first();
  1218. if(!empty($form)){
  1219. $form->remark_reject = $request->reason;
  1220. $saved = $form->save();
  1221. if($saved){
  1222. if(!empty($form->Subscriber)){
  1223. $form->subscriber()->delete();
  1224. }
  1225. if(!empty($form->PackageDetail)){
  1226. $form->packagedetail()->delete();
  1227. }
  1228. $form->delete();
  1229. return $this->sendResponse($form, 'The form success been rejected. You can see the form in rejected category');
  1230. }else{
  1231. return $this->sendError('Cant Reject the form!', '');
  1232. }
  1233. }else {
  1234. return $this->sendError('Form not exist!', '');
  1235. }
  1236. }
  1237. /**
  1238. * Restore Form controller
  1239. *
  1240. * @return json
  1241. */
  1242. public function restoreForm(Request $request) {
  1243. $form = Form::with('subscribetrashed','packagedetailtrashed')->where('_id', $request->id)->withTrashed()->first();
  1244. if(!empty($form)){
  1245. if(!empty($form->subscribetrashed)){
  1246. $form->subscribetrashed()->restore();
  1247. }
  1248. if(!empty($form->packagedetailtrashed)){
  1249. $form->packagedetailtrashed()->restore();
  1250. }
  1251. $form->restore();
  1252. return $this->sendResponse($form, 'The form success been restore. You can see the form in application category');
  1253. }else {
  1254. return $this->sendError('Form not exist!', '');
  1255. }
  1256. }
  1257. /**
  1258. * Update Status Email Form controller
  1259. *
  1260. * @return json
  1261. */
  1262. public function forceVerifyform(Request $request) {
  1263. $form = Form::where('_id', $request->id)->first();
  1264. if(!empty($form)){
  1265. if($form->status_email == 'unverified'){
  1266. $form->status_email = 'verified';
  1267. $form->save();
  1268. $stat = new FormStatus();
  1269. $stat->form_id = $form->_id;
  1270. $stat->status_id = 2;
  1271. $stat->date = new \MongoDB\BSON\UTCDateTime(time()*1000);
  1272. $stat->status = 'Verified';
  1273. $stat->desc = 'Email already been verified by Customer Service';
  1274. $form->formstatus()->save($stat);
  1275. return $this->sendResponse($form, 'Email already been verified by SHTECH');
  1276. }else{
  1277. return $this->sendError('Email already been verified!', '');
  1278. }
  1279. }else {
  1280. return $this->sendError('Form not exist!', '');
  1281. }
  1282. }
  1283. /**
  1284. * View PDF
  1285. *
  1286. * @return json
  1287. */
  1288. public function viewFormPDF(Request $request){
  1289. $form = Form::with('Subscriber','subscribetrashed')->where('_id', $request->id)->withTrashed()->first();
  1290. if(!empty($form)){
  1291. if(!empty($form->Subscriber) || !empty($form->subscribetrashed)){
  1292. if(!empty($form->Subscriber)){
  1293. if($form->type_application == 'R'){
  1294. return $this->sendResponse($form, '/residential/generate-pdf/'.$form->Subscriber->subscriber_id);
  1295. }else if($form->type_application == 'B'){
  1296. return $this->sendResponse($form, '/business/generate-pdf/'.$form->Subscriber->subscriber_id);
  1297. }
  1298. }else{
  1299. if($form->type_application == 'R'){
  1300. return $this->sendResponse($form, '/residential/generate-pdf/'.$form->subscribetrashed->subscriber_id);
  1301. }else if($form->type_application == 'B'){
  1302. return $this->sendResponse($form, '/business/generate-pdf/'.$form->subscribetrashed->subscriber_id);
  1303. }
  1304. }
  1305. }else {
  1306. return $this->sendError('Data subscriber not exist!', '');
  1307. }
  1308. }else {
  1309. return $this->sendError('Form not exist!', '');
  1310. }
  1311. }
  1312. /**
  1313. * View PDF
  1314. *
  1315. * @return json
  1316. */
  1317. public function viewCustomerForm(Request $request){
  1318. $form = Form::with('Subscriber','PackageDetail')->where('_id', $request->id)->first();
  1319. if(!empty($form)){
  1320. if(!empty($form->Subscriber) && !empty($form->PackageDetail)){
  1321. return $this->sendResponse($form, '/edit/form/customer/'.$form->Subscriber->subscriber_id);
  1322. }else {
  1323. return $this->sendError('Data subscriber or package not exist!', '');
  1324. }
  1325. }else {
  1326. return $this->sendError('Form not exist!', '');
  1327. }
  1328. }
  1329. public function viewCustomerFormTrashed(Request $request){
  1330. $form = Form::with('subscribetrashed','packagedetailtrashed')->where('_id', $request->id)->withTrashed()->first();
  1331. if(!empty($form)){
  1332. if(!empty($form->subscribetrashed) && !empty($form->packagedetailtrashed)){
  1333. return $this->sendResponse($form, '/edit/form/customer/'.$form->subscribetrashed->subscriber_id);
  1334. }else {
  1335. return $this->sendError('Data subscriber or package not exist!', '');
  1336. }
  1337. }else {
  1338. return $this->sendError('Form not exist!', '');
  1339. }
  1340. }
  1341. /**
  1342. * View Form History
  1343. *
  1344. * @return json
  1345. */
  1346. public function getOrderHistory($id){
  1347. $data = array();
  1348. $order_history = FormStatus::where('form_id', $id)->get();
  1349. foreach($order_history as $oh){
  1350. $utcdatetime = new \MongoDB\BSON\UTCDateTime((string) $oh->date);
  1351. $datetime = $utcdatetime->toDateTime();
  1352. $time = $datetime->format(DATE_RSS);
  1353. $time = strtotime($time.' UTC');
  1354. $dateInLocal = date("d/m/Y h:i a", $time);
  1355. $data[] = array(
  1356. 'date' => $dateInLocal,
  1357. 'status' => $oh->status,
  1358. 'desc' => $oh->desc
  1359. );
  1360. }
  1361. return response()->json($data);
  1362. }
  1363. public function getDeleteformHoho(){
  1364. $form = Form::onlyTrashed()->get();
  1365. foreach($form as $f){
  1366. $package = PackageDetail::where('_id', $f->_id)->first();
  1367. if(!empty($package)){
  1368. $package->deleted_at = $f->deleted_at;
  1369. $package->save();
  1370. }
  1371. $subsc = Subscriber::where('_id', $f->_id)->first();
  1372. if(!empty($subsc)){
  1373. $subsc->deleted_at = $f->deleted_at;
  1374. $subsc->save();
  1375. }
  1376. }
  1377. return response()->json($form);
  1378. }
  1379. public function getSubscriberId(Request $request){
  1380. $subscriber = Subscriber::where('_id', $request->id)->first();
  1381. if(!empty($subscriber)){
  1382. $data = [
  1383. '_id' => $subscriber->_id,
  1384. 'email' => $subscriber->email,
  1385. 'subscriber_id' => $subscriber->subscriber_id
  1386. ];
  1387. return response()->json(['status' => 'true', 'desc' => $data]);
  1388. }else{
  1389. return response()->json(['status' => 'false', 'desc' => 'Rekod ini tidak ditemui']);
  1390. }
  1391. }
  1392. public function savedAndSendEmail(Request $request){
  1393. $subscriber = Subscriber::where('_id', $request->_id)->first();
  1394. if(!empty($subscriber)){
  1395. $subscriber->email = $request->email;
  1396. $subscriber->save();
  1397. $client1 = new \GuzzleHttp\Client();
  1398. $request1 = $client1->get('https://cumas.swisslink.com.my/resend-email/'.$subscriber->subscriber_id);
  1399. $response1 = json_decode($request1->getBody()->getContents());
  1400. if($response1 == $subscriber->_id){
  1401. return redirect()->back()->with('success_msg', 'Successfully update and send email!');
  1402. }else{
  1403. return redirect()->back()->with('error_msg', 'Cant send Email!');
  1404. }
  1405. }else{
  1406. return redirect()->back()->with('error_msg', 'Subscriber detail cant been found!');
  1407. }
  1408. }
  1409. }