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.

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189
  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\Module\Form;
  11. use App\LatestModel\Module\FormStatus;
  12. use App\LatestModel\Module\Subscriber;
  13. use App\LatestModel\Module\WorkOrder;
  14. use App\LatestModel\Module\Docket;
  15. use App\LatestModel\Module\PackageDetail;
  16. use App\LatestModel\Module\Company;
  17. use App\LatestModel\Module\Coverage;
  18. use App\LatestModel\Module\Product;
  19. class DocketController extends BaseController
  20. {
  21. /**
  22. * View PDF
  23. *
  24. * @return json
  25. */
  26. public function viewDocketPDF(Request $request){
  27. $doc = Docket::where('docket_id',$request->id)->first();
  28. if(!empty($doc)){
  29. $wo = WorkOrder::where('docket_id',$request->id)->first();
  30. if(!empty($wo)){
  31. if($wo->status == "Completed"){
  32. $form = Form::with('PackageDetail','Subscriber')->where('_id',$wo->_id)->first();
  33. if(!empty($form->Subscriber) && !empty($form->PackageDetail)){
  34. $product = Product::where('formT',$form->type_application)->where('speed',$form->PackageDetail->name)->first();
  35. if(!empty($product)){
  36. return $this->sendResponse($form, '/v3/main/docket-pdf/'.$request->id);
  37. }else{
  38. return $this->sendError('Product not exist!', '');
  39. }
  40. }else{
  41. return $this->sendError('Package or subscriber not exist!', '');
  42. }
  43. }
  44. }else{
  45. return $this->sendError('Work Order not exist!', '');
  46. }
  47. }else{
  48. return $this->sendError('Docket not exist!', '');
  49. }
  50. }
  51. /**
  52. * Get Docket data
  53. *
  54. * @return json
  55. */
  56. public function getCustomerDocket($startdate,$enddate,$company_id)
  57. {
  58. if($company_id == 'null'){
  59. if($startdate == '-' && $enddate == '-'){
  60. $docket= Docket::with(['WorkOrder' =>function($q){
  61. $q->with(['Form' => function($w) {
  62. $w->with('Subscriber','PackageDetail');
  63. }])->with('Company');
  64. }])->with(['Staff' => function($e) {
  65. $e->with('StaffDetail');
  66. }])->orderBy('created_at', 'desc')->get();
  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. $docket = Docket::with(['WorkOrder' =>function($q){
  77. $q->with(['Form' => function($w) {
  78. $w->with('Subscriber','PackageDetail');
  79. }])->with('Company');
  80. }])->with(['Staff' => function($e) {
  81. $e->with('StaffDetail');
  82. }])->orderBy('created_at', 'desc')->whereBetween('created_at', array($start, $end))->get();
  83. }
  84. }else{
  85. if($startdate == '-' && $enddate == '-'){
  86. $docket= Docket::with(['WorkOrder' => function($q) use($company_id){
  87. $q->where('contractor_id', $company_id)->with(['Form' => function($w) {
  88. $w->with('Subscriber','PackageDetail');
  89. }])->with('Company');
  90. }])->with(['Staff' => function($e) {
  91. $e->with('StaffDetail');
  92. }])->orderBy('created_at', 'desc')->get();
  93. }else if($startdate != '-'){
  94. $dateS = Carbon::createFromFormat('Y-m-d', $startdate);
  95. $start = $dateS->copy()->startOfDay();
  96. if($enddate != '-'){
  97. $dateE = Carbon::createFromFormat('Y-m-d', $enddate);
  98. $end = $dateE->copy()->endOfDay();
  99. }else{
  100. $end = $dateS->copy()->endOfDay();
  101. }
  102. $docket = Docket::with(['WorkOrder' => function($q) use($company_id){
  103. $q->where('contractor_id', $company_id)->with(['Form' => function($w) {
  104. $w->with('Subscriber','PackageDetail');
  105. }])->with('Company');
  106. }])->with(['Staff' => function($e) {
  107. $e->with('StaffDetail');
  108. }])->orderBy('created_at', 'desc')->whereBetween('created_at', array($start, $end))->get();
  109. }
  110. }
  111. return $docket;
  112. }
  113. public function displayDocketData($startdate,$enddate,$company_id){
  114. $i = 0; $company = ''; $installer = ''; $phone = '';
  115. $curr = Carbon::now()->getTimestamp();
  116. $nested_data = array();
  117. $docket = $this->getCustomerDocket($startdate, $enddate, $company_id);
  118. if(!empty($docket)){
  119. foreach($docket as $d){
  120. if(!empty($d->WorkOrder) && !empty($d->WorkOrder->Form) && !empty($d->Staff) && !empty($d->WorkOrder->Company)){
  121. $reg_time = $d->created_at;
  122. $expiry_date = $reg_time->addDays(3);
  123. $expiry_date = $expiry_date->getTimestamp();
  124. if($curr < $expiry_date) {
  125. $n1 = "New/";
  126. }
  127. $phone = $d->Staff->StaffDetail->phone;
  128. $installer = $d->Staff->StaffDetail->name;
  129. $company = $d->WorkOrder->Company->name;
  130. if($d->WorkOrder->Form->type_application == 'R'){
  131. $building = $d->WorkOrder->Form->Subscriber->building_name;
  132. }else if($d->WorkOrder->Form->type_application == 'B'){
  133. $building = $d->WorkOrder->Form->Subscriber->company_name;
  134. }
  135. $i++;
  136. array_push($nested_data, array(
  137. 'index' => $n1.$i,
  138. 'docket_id' => $d->docket_id,
  139. 'work_order_id' => $d->work_order_id,
  140. 'nature_work' => $d->nature_work,
  141. 'contractor_id' => $company,
  142. 'installer_name' => $installer,
  143. 'customer_id' => $building,
  144. 'installer_num' => $phone,
  145. 'end_job' => date('d/m/Y H:i', strtotime($d->end_job)),
  146. 'serial_number' => $d->router_serial_number,
  147. 'rating' => round((($d->Rating1 + $d->Rating2 + $d->Rating3)/15) * 100)."%/".$d->WorkOrder->contractor_id,
  148. 'action' => $d->docket_id.'/'.$d->work_order_id
  149. ));
  150. }
  151. }
  152. }
  153. return \DataTables::of($nested_data)->make(true);
  154. }
  155. }