orderBy('created_at','asc')->get(); $form = Subscriber::with('Form','formtrashed')->where('subscriber_id',$subscriber_id)->withTrashed()->first(); $package = PackageDetail::where('_id',$form->_id)->withTrashed()->first(); $created_at = Carbon::parse($form->created_at)->toDateTimeString(); $ext1 = pathinfo(public_path().$form->front_ic, PATHINFO_EXTENSION); $ext2 = pathinfo(public_path().$form->back_ic, PATHINFO_EXTENSION); if($form->citizen != 'Malaysian'){ $ext3 = pathinfo(public_path().$form->visaF, PATHINFO_EXTENSION); $ext4 = pathinfo(public_path().$form->visaB, PATHINFO_EXTENSION); }else{ $ext3 = 'null'; $ext4 = 'null'; } // $img = Image::make(public_path('assets/images/marker.png')); // $img->text('MyNotePaper', 710, 370, function ($font) { // $font->file(public_path('font/amandasignature.ttf')); // $font->size(30); // $font->color('#f4d442'); // $font->align('center'); // $font->valign('top'); // $font->angle(0); // }); // $img->save(public_path('assets/images/marker.png')); // $img->encode('png'); // $type = 'png'; // $new_image = 'data:image/' . $type . ';base64,' . base64_encode($img); // $img = Image::make(public_path($subscriber_id)); // /* insert watermark at bottom-right corner with 10px offset */ // $img->insert(Storage::get('public/assets/images/marker.png'), 'bottom-right', 10, 10); // $img->save(Storage::get('public/assets/images/marker.png')); // $img->encode('png'); // $type = 'png'; // $new_image = 'data:image/' . $type . ';base64,' . base64_encode($img); // $config = ['instanceConfigurator' => function($mpdf) { // $mpdf->SetWatermarkText('DRAFT'); // $mpdf->showWatermarkText = true; // }] $documentPath = 'document/'.$subscriber_id; $pdf = PDF::loadView('v3.pdf.residential-pdf', compact('form','package','product','ext1','ext2','ext3','ext4','created_at','config')); $pdf->setPaper('A4', 'potrait'); // $pdf->setWatermarkImage(public_path('images/marker.png')); if(($ext1 == "jpeg" && $ext2 == "jpeg") || ($ext1 == "jpg" && $ext2 == "jpg")){ if(($ext3 == "jpeg" && $ext4 == "jpeg") || ($ext3 == "jpg" && $ext4 == "jpg")){ return $pdf->stream(); }else{ return $pdf->stream(); } }else if($ext1 == "pdf" && $ext2 == "pdf" && $ext3 == "pdf" && $ext4 == "pdf"){ $pdf->save(public_path().'/'.$documentPath.'/application.pdf'); $merges = PDFMerger::init(); $merges->addPDF(public_path().'/'.$documentPath.'/application.pdf', 'all'); $merges->addPDF(public_path().$form->front_ic,'all'); $merges->addPDF(public_path().$form->back_ic,'all'); $merges->addPDF(public_path().$form->visaF,'all'); $merges->addPDF(public_path().$form->visaB,'all'); $merges->merge(); $merges->save(public_path().'/'.$documentPath.'/'.$subscriber_id.'.pdf',"browser"); }else if($ext1 == "pdf" && $ext2 == "pdf"){ $pdf->save(public_path().'/'.$documentPath.'/application.pdf'); $merges = PDFMerger::init(); $merges->addPDF(public_path().'/'.$documentPath.'/application.pdf', 'all'); $merges->addPDF(public_path().$form->front_ic,'all'); $merges->addPDF(public_path().$form->back_ic,'all'); $merges->merge(); $merges->save(public_path().'/'.$documentPath.'/'.$subscriber_id.'.pdf',"browser"); }else{ return $pdf->stream(); } } public function generateBPDF($subscriber_id) { $product = Product::where('formT','B')->orderBy('created_at','asc')->get(); $form = Subscriber::with('Form')->where('subscriber_id',$subscriber_id)->withTrashed()->first(); $package = PackageDetail::where('_id',$form->_id)->withTrashed()->first(); $ext1 = pathinfo(public_path().$form->front_ic, PATHINFO_EXTENSION); $ext2 = pathinfo(public_path().$form->back_ic, PATHINFO_EXTENSION); $ext3 = pathinfo(public_path().$form->form24_49, PATHINFO_EXTENSION); $ext4 = pathinfo(public_path().$form->form9_44, PATHINFO_EXTENSION); $ext5 = pathinfo(public_path().$form->visaF, PATHINFO_EXTENSION); $ext6 = pathinfo(public_path().$form->visaB, PATHINFO_EXTENSION); $documentPath = 'document/'.$subscriber_id; $pdf = PDF::loadView('v3.pdf.business-pdf', compact('form','package','product','ext1','ext2','ext3','ext4','ext5','ext6')); $pdf->setPaper('A4', 'potrait'); if(($ext1 == "jpeg" && $ext2 == "jpeg") || ($ext1 == "jpg" && $ext2 == "jpg") || ($ext1 == "JPG" && $ext2 == "JPG")){ if($ext3 == "pdf" && $ext4 == "pdf"){ if(($ext5 == "jpeg" && $ext6 == "jpeg") || ($ext5 == "jpg" && $ext6 == "jpg") || ($ext5 == "JPG" && $ext6 == "JPG")){ $pdf->save(public_path('/'.$documentPath.'/application.pdf')); $merges = PDFMerger::init(); $merges->addPDF(public_path().'/'.$documentPath.'/application.pdf', 'all'); $merges->addPDF(public_path().$form->form24_49,'all'); $merges->addPDF(public_path().$form->form9_44,'all'); $merges->merge(); $merges->save(public_path().'/'.$documentPath.'/'.$subscriber_id.'.pdf',"browser"); }else if($ext5 == "pdf" && $ext6 == "pdf"){ $pdf->save(public_path('/'.$documentPath.'/application.pdf')); $merges = PDFMerger::init(); $merges->addPDF(public_path().'/'.$documentPath.'/application.pdf', 'all'); $merges->addPDF(public_path().$form->visaF,'all'); $merges->addPDF(public_path().$form->visaB,'all'); $merges->addPDF(public_path().$form->form24_49,'all'); $merges->addPDF(public_path().$form->form9_44,'all'); $merges->merge(); $merges->save(public_path().'/'.$documentPath.'/'.$subscriber_id.'.pdf',"browser"); }else{ $pdf->save(public_path('/'.$documentPath.'/application.pdf')); $merges = PDFMerger::init(); $merges->addPDF(public_path().'/'.$documentPath.'/application.pdf', 'all'); $merges->addPDF(public_path().$form->form24_49,'all'); $merges->addPDF(public_path().$form->form9_44,'all'); $merges->merge(); $merges->save(public_path().'/'.$documentPath.'/'.$subscriber_id.'.pdf',"browser"); } }else if(($ext3 == "jpeg" && $ext4 == "jpeg") || ($ext3 == "jpg" && $ext4 == "jpg") || ($ext3 == "JPG" && $ext4 == "JPG")){ if(($ext5 == "jpeg" && $ext6 == "jpeg") || ($ext5 == "jpg" && $ext6 == "jpg") || ($ext5 == "JPG" && $ext6 == "JPG")){ return $pdf->stream(); }else if($ext5 == "pdf" && $ext6 == "pdf"){ $pdf->save(public_path('/'.$documentPath.'/application.pdf')); $merges = PDFMerger::init(); $merges->addPDF(public_path().'/'.$documentPath.'/application.pdf', 'all'); $merges->addPDF(public_path().$form->visaF,'all'); $merges->addPDF(public_path().$form->visaB,'all'); $merges->merge(); $merges->save(public_path().'/'.$documentPath.'/'.$subscriber_id.'.pdf',"browser"); }else{ return $pdf->stream(); } } }else if($ext1 == "pdf" && $ext2 == "pdf"){ if($ext3 == "pdf" && $ext4 == "pdf"){ if($ext5 == "pdf" && $ext6 == "pdf"){ $pdf->save(public_path().'/'.$documentPath.'/application.pdf'); $merges = PDFMerger::init(); $merges->addPDF(public_path().'/'.$documentPath.'/application.pdf', 'all'); $merges->addPDF(public_path().$form->front_ic,'all'); $merges->addPDF(public_path().$form->back_ic,'all'); $merges->addPDF(public_path().$form->visaF,'all'); $merges->addPDF(public_path().$form->visaB,'all'); $merges->addPDF(public_path().$form->form24_49,'all'); $merges->addPDF(public_path().$form->form9_44,'all'); $merges->merge(); $merges->save(public_path().'/'.$documentPath.'/'.$subscriber_id.'.pdf',"browser"); }else if(($ext5 == "jpeg" && $ext6 == "jpeg") || ($ext5 == "jpg" && $ext6 == "jpg") || ($ext5 == "JPG" && $ext6 == "JPG")){ $pdf->save(public_path().'/'.$documentPath.'/application.pdf'); $merges = PDFMerger::init(); $merges->addPDF(public_path().'/'.$documentPath.'/application.pdf', 'all'); $merges->addPDF(public_path().$form->front_ic,'all'); $merges->addPDF(public_path().$form->back_ic,'all'); $merges->addPDF(public_path().$form->form24_49,'all'); $merges->addPDF(public_path().$form->form9_44,'all'); $merges->merge(); $merges->save(public_path().'/'.$documentPath.'/'.$subscriber_id.'.pdf',"browser"); }else{ $pdf->save(public_path().'/'.$documentPath.'/application.pdf'); $merges = PDFMerger::init(); $merges->addPDF(public_path().'/'.$documentPath.'/application.pdf', 'all'); $merges->addPDF(public_path().$form->front_ic,'all'); $merges->addPDF(public_path().$form->back_ic,'all'); $merges->addPDF(public_path().$form->form24_49,'all'); $merges->addPDF(public_path().$form->form9_44,'all'); $merges->merge(); $merges->save(public_path().'/'.$documentPath.'/'.$subscriber_id.'.pdf',"browser"); } }else if(($ext3 == "jpeg" && $ext4 == "jpeg") || ($ext3 == "jpg" && $ext4 == "jpg") || ($ext3 == "JPG" && $ext4 == "JPG")){ if($ext5 == "pdf" && $ext6 == "pdf"){ $pdf->save(public_path().'/'.$documentPath.'/application.pdf'); $merges = PDFMerger::init(); $merges->addPDF(public_path().'/'.$documentPath.'/application.pdf', 'all'); $merges->addPDF(public_path().$form->front_ic,'all'); $merges->addPDF(public_path().$form->back_ic,'all'); $merges->addPDF(public_path().$form->visaF,'all'); $merges->addPDF(public_path().$form->visaB,'all'); $merges->merge(); $merges->save(public_path().'/'.$documentPath.'/'.$subscriber_id.'.pdf',"browser"); }else if(($ext5 == "jpeg" && $ext6 == "jpeg") || ($ext5 == "jpg" && $ext6 == "jpg") || ($ext5 == "JPG" && $ext6 == "JPG")){ $pdf->save(public_path().'/'.$documentPath.'/application.pdf'); $merges = PDFMerger::init(); $merges->addPDF(public_path().'/'.$documentPath.'/application.pdf', 'all'); $merges->addPDF(public_path().$form->front_ic,'all'); $merges->addPDF(public_path().$form->back_ic,'all'); $merges->merge(); $merges->save(public_path().'/'.$documentPath.'/'.$subscriber_id.'.pdf',"browser"); }else{ $pdf->save(public_path().'/'.$documentPath.'/application.pdf'); $merges = PDFMerger::init(); $merges->addPDF(public_path().'/'.$documentPath.'/application.pdf', 'all'); $merges->addPDF(public_path().$form->front_ic,'all'); $merges->addPDF(public_path().$form->back_ic,'all'); $merges->merge(); $merges->save(public_path().'/'.$documentPath.'/'.$subscriber_id.'.pdf',"browser"); } } }else { return $pdf->stream(); } } public function generateWorkOrderPDF($wo){ $wo = WorkOrder::where('wo',$wo)->first(); $form = Form::with('PackageDetail','Subscriber')->where('_id',$wo->_id)->first(); $product = Product::where('formT',$form->type_application)->where('speed',$form->PackageDetail->name)->first(); if(empty($product)){ if($form->PackageDetail->name == "30"){ $product = '30Mbps'; }else{ $product = 'RMbps'; } }else { $product = $product->package_name; } $created_by = Staff::with('StaffDetail')->where("_id",$wo->created_by)->first(); if(empty($created_by)){ $created_by = ''; } $created_at = Carbon::parse($wo->created_at)->toDateTimeString(); $address = ''; if($form->type_application == 'R'){ if($form->Subscriber->street != ''){ $address = $form->Subscriber->unit_no. ' , '.$form->Subscriber->building_name. ' , '.$form->Subscriber->street. ' , '.$form->Subscriber->postcode. ' , '.$form->Subscriber->city. ' , '.$form->Subscriber->state; }else { $address = $form->Subscriber->unit_no. ' , '.$form->Subscriber->building_name. ' , '.$form->Subscriber->postcode. ' , '.$form->Subscriber->city. ' , '.$form->Subscriber->state; } }else if($form->type_application == 'B'){ if($form->Subscriber->unit_no != ''){ $address = $form->Subscriber->unit_no. ', '.$form->Subscriber->company_name. ', '.$form->Subscriber->street. ' , '.$form->Subscriber->postcode. ' , '.$form->Subscriber->city. ' , '.$form->Subscriber->state; }else { $address = $form->Subscriber->company_name. ', '.$form->Subscriber->street. ' , '.$form->Subscriber->postcode. ' , '.$form->Subscriber->city. ' , '.$form->Subscriber->state; } } $pdf = PDF::loadView('v3.pdf.workorder-pdf',compact('wo','form','product','created_at','created_by','address')); $pdf->setPaper('A4', 'potrait'); return $pdf->stream(); } public function generateDocketPDF($do) { $docket = Docket::with('WorkOrder')->where('docket_id',$do)->first(); if(!empty($docket)){ $form = Form::with('Subscriber','PackageDetail')->where('_id',$docket->WorkOrder->_id)->first(); $address = ''; if($form->type_application == 'R'){ if($form->Subscriber->street != ''){ $address = $form->Subscriber->unit_no. ' , '.$form->Subscriber->building_name. ' , '.$form->Subscriber->street. ' , '.$form->Subscriber->postcode. ' , '.$form->Subscriber->city. ' , '.$form->Subscriber->state; }else { $address = $form->Subscriber->unit_no. ' , '.$form->Subscriber->building_name. ' , '.$form->Subscriber->postcode. ' , '.$form->Subscriber->city. ' , '.$form->Subscriber->state; } }else if($form->type_application == 'B'){ if($form->Subscriber->unit_no != ''){ $address = $form->Subscriber->unit_no. ', '.$form->Subscriber->company_name. ', '.$form->Subscriber->street. ' , '.$form->Subscriber->postcode. ' , '.$form->Subscriber->city. ' , '.$form->Subscriber->state; }else { $address = $form->Subscriber->company_name. ', '.$form->Subscriber->street. ' , '.$form->Subscriber->postcode. ' , '.$form->Subscriber->city. ' , '.$form->Subscriber->state; } } $product = Product::where('formT',$form->type_application)->where('speed',$form->PackageDetail->name)->first(); $installer = Staff::with('StaffDetail')->where('_id',$docket->installer_id)->withTrashed()->first(); if(empty($product)){ $product = 'RMbps'; }else { $product = $product->package_name; } $dateTime = Carbon::parse($docket->WorkOrder->dateTimeStart)->toDateTimeString(); $edateTime = Carbon::parse($docket->end_job)->toDateTimeString(); $pdf = PDF::loadView('v3.pdf.docket-pdf',compact('docket','form','address','product','installer','dateTime','edateTime')); $pdf->setPaper('A4', 'potrait'); return $pdf->stream(); } } public function exportPDFClaim($company,$year,$month,$app) { $final = array(); $com = Company::where('_id',$company)->first(); $dataR = array(); $dataB = array(); $combineData = array(); if($year!='null' && $month!='null' && $app=='null'){ $dataR = $this->returnDataR($company,$year,$month); dd($dataR); $dataB = $this->returnDataB($company,$year,$month); foreach($dataR as $r){ $combineData[] = $r; } foreach($dataB as $b){ $combineData[] = $b; } $i = 0; $nested_data = array(); if(!empty($combineData)){ foreach ($combineData as $c){ $i++; array_push($final, array( 'index' => $c['index'], 'contract' => $c['contract'], 'wo' => $c['wo'], 'activated_dt' => $c['activation'], 'name' => $c['name'], 'address' => $c['address'], 'package' => $c['package'], 'retail_price' => $c['retail_price'], 'incentives1' => $c['incentives1'], 'incentives2' => $c['incentives2'], 'total' => $c['total'], 'claimed' => $c['claim'], )); } } $totals = 0; foreach($final as $f){ $totals += floatval(str_replace('RM ', '', $f['total'])); } $pdf = PDF::loadView('pdf.agent-claim', compact('final', 'month', 'year','com','totals')); $pdf->setPaper('A4', 'landscape'); $pdfName = preg_replace('/\s+/', '-', $com->name).'-'.$month.'-'.$year.'.pdf'; return $pdf->download( $pdfName ); }else if($year!='null' && $month!='null' && $app!='null'){ if($app == 'Residential'){ $dataR = $this->returnDataR($company,$year,$month); }else if($app == 'Business'){ $dataB = $this->returnDataB($company,$year,$month); } foreach($dataR as $r){ $combineData[] = $r; } foreach($dataB as $b){ $combineData[] = $b; } $i = 0; $nested_data = array(); if(!empty($combineData)){ foreach ($combineData as $c){ $i++; array_push($final, array( 'index' => $c['index'], 'contract' => $c['contract'], 'wo' => $c['wo'], 'activated_dt' => $c['activation'], 'name' => $c['name'], 'address' => $c['address'], 'package' => $c['package'], 'retail_price' => $c['retail_price'], 'incentives1' => $c['incentives1'], 'incentives2' => $c['incentives2'], 'total' => $c['total'], 'claimed' => $c['claim'], )); } } $totals = 0; foreach($final as $f){ $totals += floatval(str_replace('RM ', '', $f['total'])); } $pdf = PDF::loadView('v3.pdf.agent-claim', compact('final', 'month', 'year','com','totals')); $pdf->setPaper('A4', 'landscape'); $pdfName = preg_replace('/\s+/', '-', $com->name).'-'.$month.'-'.$year.'.pdf'; return $pdf->download( $pdfName ); } } }