dfjdkjkdjffd

<?php
include_once(APPPATH.'core/My_controller.php');
class Bonus extends My_controller
{
    public function __construct()
    {
        parent::__construct();
        $this->load->model('model_transaksi');
        $this->load->model('model_member');
        $this->load->model('model_member_game');
        $array = array(
            'page' => 'bonus'
        );

        if ($this->session->userdata('hak_akses')['bonus'] == 0) {
            redirect('dashboard');
        }


        $this->session->set_userdata($array);
    }

    public function index()
    {
        $search["DATE_FORMAT(tanggal,'%Y-%m-%d') >= "] = date('Y-m-d');
        $search['id_deposit']	= null;
        $search['id_withdraw']	= null;
        $search['type']			= 'wallet';
        $data['transaksi']	= $this->model_transaksi->getDetail($search)->result();

        $data['saldo_member']	= $this->model_member->getSaldoMember()->row();

        $data['outcome'] = 0;
        $data['income']	= 0;
        $data['income_saldo'] = 0;
        $data['outcome_saldo'] = 0;
        foreach ($data['transaksi'] as $row) {
            if ($row->type ==  'game') {
                $data['outcome'] += $row->debet;
                $data['income'] += $row->kredit;
            } else {
                $data['outcome_saldo'] += $row->debet;
                $data['income_saldo'] += $row->kredit;
            }
        }

        $data['dari'] = date('Y-m-d');
        $data['sampai']	= date('Y-m-d');

        $this->render_page('bonus/index', $data);
    }

    public function filter()
    {
        $search["DATE_FORMAT(tanggal,'%Y-%m-%d') >= "] = $this->input->post('dari');
        $search["DATE_FORMAT(tanggal,'%Y-%m-%d') <= "] = $this->input->post('sampai');
        $search['id_deposit']	= null;
        $search['id_withdraw']	= null;
        $search['type']			= 'wallet';
        $data['transaksi']	= $this->model_transaksi->getDetail($search)->result();

        $data['saldo_member']	= $this->model_member->getSaldoMember()->row();

        $data['outcome'] = 0;
        $data['income']	= 0;
        $data['income_saldo'] = 0;
        $data['outcome_saldo'] = 0;
        foreach ($data['transaksi'] as $row) {
            if ($row->type ==  'game') {
                $data['outcome'] += $row->debet;
                $data['income'] += $row->kredit;
            } else {
                $data['outcome_saldo'] += $row->debet;
                $data['income_saldo'] += $row->kredit;
            }
        }

        $data['dari'] = $this->input->post('dari');
        $data['sampai']	= $this->input->post('sampai');

        $this->render_page('bonus/index', $data);
    }


    public function add()
    {
        $this->render_page('bonus/add');
    }

    public function import()
    {
        include APPPATH.'third_party/PHPExcel/PHPExcel.php';

        if ($this->input->post('submit')) {
            $p = $this->input->post();
            if ($this->_upload()) {
                $this->db->trans_begin();


                $excelreader = new PHPExcel_Reader_Excel2007();
                $loadexcel = $excelreader->load('upload/excel/data_bonus.xlsx');
                $sheet = $loadexcel->getActiveSheet()->toArray(null, true, true, true);



                $numrow = 1;
                foreach ($sheet as $row) {
                    if ($numrow > 1) {
                        //$id_member_game = $row['A'];
                        $data_member_game = $this->model_member->data_member_game($row['A']);
                        if ($data_member_game) {
                            $search['username_member'] = $data_member_game->username_member;
                            $member = $this->model_member->getDetail($search)->row();
                            $id_member		= $member->id_member;
                            $saldo_member	= $member->saldo_member;
                            $id_refferal	= $member->id_refferal;

                            //----------------------------
                            $data['id_member']	= $id_member;
                            $data['debet']		= 0;
                            $data['kredit']		= $row['B'];
                            $data['saldo']		= $saldo_member + $row['B'];
                            $data['keterangan']	= $row['C'];
                            $data['type']		= 'wallet';
                            $data['tanggal']	= date('Y-m-d H:i:s');
                            $this->model_transaksi->tambah($data);
                            //----------------------------

                            $update_saldo['saldo_member']	=	$saldo_member + $row['B'];
                            $this->model_member->update($update_saldo, $id_member);

                            if ($id_refferal != null) {
                                $search_['id_member'] = $id_refferal;
                                $refferal = $this->model_member->getDetail($search_)->row();
                                $saldo_refferal = $refferal->saldo_member;
                                $jumlah			= $row['B'] * 0.05;
                                //---------------------------------
                                $data['id_member']	= $id_refferal;
                                $data['debet']		= 0;
                                $data['kredit']		= $jumlah;
                                $data['saldo']		= $saldo_refferal + $jumlah;
                                $data['keterangan']	= "Saldo Bonus From Active Refferal";
                                $data['type']		= 'wallet';
                                $data['tanggal']	= date('Y-m-d H:i:s');
                                $this->model_transaksi->tambah($data);
                                //---------------------------------

                                $update_saldo['saldo_member']	=	$saldo_refferal + $jumlah;
                                $this->model_member->update($update_saldo, $id_refferal);
                            }
                        }
                    }

                    $numrow++;
                }


                if ($this->db->trans_status()) {
                    $this->session->set_flashdata('alert_message', show_alert('Success', 'Perintah berhasil dieksekusi', 'success'));
                    $this->db->trans_commit();
                } else {
                    $this->db->trans_rollback();
                    $this->session->set_flashdata('alert_message', show_alert('Gagal', 'Gagal dieksekusi', 'info'));
                }
            } else {
                $this->session->set_flashdata('alert_message', show_alert('Gagal', $this->upload->display_errors(), 'info'));
            }
        }




        redirect("bonus");
    }

    private function _upload()
    {
        $error= false;
        $location   = 'upload/excel/';
        $config['upload_path']          = $location;
        $config['allowed_types']        = 'xlsx';
        $config['file_name']            = 'data_bonus';
        $config['overwrite']            = true;
        $config['max_size'] 		 	= '2048';

        $this->load->library('upload', $config);

        if (!$this->upload->do_upload('file')) {
            $error = true;
        }

        if ($error) {
            return false;
        } else {
            return true;
        }
    }
}