<?php
class Menu extends CI_Controller
{
    function __construct()
    {
        parent::__construct();
        $this->load->model('m_menu');
        $this->load->model('m_order');
        $this->load->model('m_kategori');
        $this->load->model('m_pelanggan');
        $this->load->library('upload');
    }


    function index()
    {
        $kopel = $this->session->userdata('kopel');
        if ($kopel == null) {
            $x['judul'] = "Login";
            $x['data'] = $this->m_menu->lokasi();
            $this->load->view('mobile/v_login', $x);
        }
        if ($kopel != null) {
            redirect('mobile/menu/hotpromo');
        }
    }

    function get_autocomplete()
    {
        if (isset($_GET['term'])) {
            $result = $this->m_menu->cari_nama($_GET['term']);
            if (count($result) > 0) {
                foreach ($result as $row) {
                    $arr_result[] = array(
                        'label' => $row->nama_menu,
                        'kode' => $row->kode_menu,
                    );
                }
                echo json_encode($arr_result);
            }
        }
    }
    function lokasi()
    {
        $kopel = $this->session->userdata('kopel');
        $aa = $this->db->query("select * from tbl_pelanggan  where plg_id='$kopel';");
        $ab = $aa->row_array();
        $x['nama'] = $ab['plg_nama'];
        $x['telp'] = $ab['plg_notelp'];

        $x['alamat'] = $ab['plg_alamat'];
        $x['judul'] = "Lokasi Kedai";
        $x['data'] = $this->m_menu->lokasi();

        $this->load->view('mobile/v_lokasi', $x);
    }
    function hotpromo()
    {
        $kopel = $this->session->userdata('kopel');
        $kode = $this->uri->segment(4);
        if ($kode <> '') {
            $aa = $this->db->query("update tbl_pelanggan set kdtoko='$kode' where plg_id='$kopel'");
        }
        $x['judul'] = "HOT PROMO";
        $x['data'] = $this->m_menu->hot_promo();
        $this->load->view('mobile/v_menu', $x);
    }
    function favorit1()
    {
        $kopel = $this->session->userdata('kopel');
        $noresi = $this->session->userdata('nobukti');
        $kdbrg1 = $this->session->userdata('kdbrgu');
        $kode = $this->uri->segment(4);
        if ($kode <> '') {
            $aa = $this->db->query("update tbl_pelanggan set kdtoko='$kode' where plg_id='$kopel'");
        }
        $x['judul'] = "MENU FAVORIT";
        $x['data'] = $this->m_menu->favorit();
        $x['data_hapus'] = $this->m_order->getListPenjualanhapus($noresi, $kdbrg1);
        $this->load->view('mobile/v_menu', $x);
    }


    function jorder()
    {
        if ($this->session->userdata('pengguna') == '' || $this->session->userdata('pengguna')) {
            $this->session->set_userdata('belumlogin', true);
        }

        include_once APPPATH . "libraries/vendor/autoload.php";
        $google_client = new Google_Client();

        $google_client->setClientId('755673399181-t58sqcm0hnt8q6mh830tmv7oskbd2qb2.apps.googleusercontent.com');
        $google_client->setClientSecret('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');
        $google_client->setRedirectUri('https://eorder.miedjoetek.com/');
        $google_client->addScope('email');
        $google_client->addScope('profile');

        if (isset($_GET["code"])) {
            $token = $google_client->fetchAccessTokenWithAuthCode($_GET["code"]);
            if (!isset($token["error"])) {
                $google_client->setAccessToken($token['access_token']);
                $this->session->set_userdata('access_token', $token['access_token']);
                $google_service = new Google_Service_Oauth2($google_client);
                $data = $google_service->userinfo->get();
                $this->session->set_userdata('nama', $data['given_name']);
                $this->session->set_userdata('email', $data['email']);
            }
        }

        if (!$this->session->userdata('access_token')) {
            if (empty($_COOKIE['telepon'])) {
                $login_button = $google_client->createAuthUrl();
                $data['login_button'] = $login_button;
                $data['promo'] = $this->m_menu->promonya();
                $this->load->view('mobile/eorder', $data);
            } else {
                redirect('mobile/member/auth');
            }
        } else {
            redirect('mobile/member/authGoogle');
        }
    }

    function menuutama()
    {
        //cek login
        if (!$this->session->userdata('pengguna')) {
            redirect('');
        }

        // 		$kdtoko=$this->uri->segment(4);
        $kdtoko = strip_tags(str_replace("'", "", $this->input->post('toko')));
        $type = strip_tags(str_replace("'", "", $this->input->post('order_type')));
        if (isset($_COOKIE['Lat1'])) {
            $lat = $_COOKIE['Lat1'];
            $lng = $_COOKIE['Long1'];
        } else {
            $lat = "1";
            $lng = "1";
        }
        if ($kdtoko == '' || $kdtoko == null) {
            redirect('');
        }

        $ab = $this->db->query("select * from tabel_toko where kd_toko='$kdtoko';")->row();
        $x['toko'] = $ab->nm_toko;
        $x['kdtoko'] = $kdtoko;
        $x['alamat'] = $ab->almt_toko;
        $this->session->set_userdata('cabang', $kdtoko);
        $this->session->set_userdata('nm_toko', $ab->nm_toko);
        $ongkir = '0';
        $u = $this->session->userdata('telepon');
        $kodepel = $this->m_pelanggan->upd_pelanggann($u, $kdtoko, $type, $lat, $lng);
        $this->session->set_userdata('typeorder', $type);
        $this->session->set_userdata('kdcabang', $kdtoko);
        $nama = $this->session->userdata('nama_pel');
        $kdcabang = $kdtoko;

        $kopel = $this->session->userdata('kopel');
        $layanan = $this->session->userdata('typeorder');
        $i = $queryCariInv = $this->db->query("SELECT nobukti FROM tbl_belanja1 WHERE kdcabang = '$kdcabang' AND custno = '$kopel' AND stat = '0' AND tgl = curdate()")->row();
        if (!empty($i)) {
            $no_invoice = $i->nobukti;
            $this->session->set_userdata('no_invoice', $no_invoice);
            $this->session->set_userdata('nobukti', $no_invoice);
            $update = $this->db->query("update tbl_belanja1 set layanan = '$layanan' where nobukti = '$no_invoice'");
            $delete = $this->db->query("delete from tbl_belanja_detail1 where nobukti = '$no_invoice' AND jpromo <> ''");
        } else {
            $no_invoice = $this->m_order->get_invoice($kdcabang);
            $this->session->set_userdata('no_invoice', $no_invoice);
            $this->session->set_userdata('nobukti', $no_invoice);
            $order_proses = $this->m_order->order_produk1($no_invoice);
        }

        // $update = $this->db->query("update tbl_belanja1 set notelp = '$notelp' where nobukti = '$no_invoice'");
        $tgl = date('Y-m-d');
        //cari promo
        $hrr = date('w', strtotime("$tgl"));
        $wkt = date('H:i:s');
        $ses_promo = '';
        $this->session->set_userdata('promo', $ses_promo);
        if($kopel !='107' || $kopel !='355878' ) {
            $k =  $this->db->query("SELECT nobukti FROM tbl_belanja WHERE custno = '$kopel' AND stat = '6' AND tgl = curdate() and idpromo='078'")->row();
        }
        if(!empty($k)) {
                $rowpromo = $this->db->query("SELECT a.disc1,a.ndisc1,a.idprogram,a.nobukti,a.jnsdisc,a.jnspromo,a.jnsmenu,a.maxbonus FROM promoheader a
					LEFT JOIN promoarea b ON a.nobukti=b.nobukti
					WHERE a.stat='1' AND a.tglawal<='$tgl' AND a.tglakhir>='$tgl' and stpromo='1'  and a.hari like '%$hrr%' and a.hari like '%$hrr%' and jamawal<='$wkt' and jamakhir>='$wkt' and a.idprogram<>'078'
					AND (a.jnslayanan='$type' or a.jnslayanan1='$type' or a.jnslayanan2='$type') AND b.kdwil='$kdtoko' AND (a.eorder = 1 OR a.eorder = 2);")->row();
        } else {
            $rowpromo = $this->db->query("SELECT a.disc1,a.ndisc1,a.idprogram,a.nobukti,a.jnsdisc,a.jnspromo,a.jnsmenu,a.maxbonus FROM promoheader a
					LEFT JOIN promoarea b ON a.nobukti=b.nobukti
					WHERE a.stat='1' AND a.tglawal<='$tgl' AND a.tglakhir>='$tgl' and stpromo='1'  and a.hari like '%$hrr%' and a.hari like '%$hrr%' and jamawal<='$wkt' and jamakhir>='$wkt'
					AND (a.jnslayanan='$type' or a.jnslayanan1='$type' or a.jnslayanan2='$type') AND b.kdwil='$kdtoko' AND (a.eorder = 1 OR a.eorder = 2);")->row();
        }
        
        // $rowpromo = $querypromo->row_array();

        if (!empty($rowpromo)) {
            $disc1 = $rowpromo->disc1;
            $diskon = $rowpromo->ndisc1;
            $idprogram = $rowpromo->idprogram;
            $noprogram = $rowpromo->nobukti;
            $jnsdisc = $rowpromo->jnsdisc;
            $jnspromo = $rowpromo->jnspromo;
            $jnsmenu = $rowpromo->jnsmenu;
            $maxbonus = $rowpromo->maxbonus;
            $jpromo = "P";
            $this->session->set_userdata('promo', $idprogram);
            $update = $this->db->query("update tbl_belanja1 set disc='$disc1',promo = '2', idpromo = '$idprogram',jnspromo ='$jnsdisc',  maxbonus = '$maxbonus',notelp = '$u',custname='$nama' where nobukti = '$no_invoice'");
        } else {
            $update = $this->db->query("update tbl_belanja1 set promo = '1', idpromo = '',jnspromo ='',  maxbonus = '0',notelp = '$u',custname='$nama' where nobukti = '$no_invoice'");
        }

        redirect('mobile/menu/favorit', 'refresh');
    }

    function menuutama1()
    {
        //cek login
        if (!$this->session->userdata('pengguna')) {
            redirect('');
        }

        // 		$kdtoko=$this->uri->segment(4);
        $kdtoko = strip_tags(str_replace("'", "", $this->input->post('toko')));
        $type = strip_tags(str_replace("'", "", $this->input->post('order_type')));
        $alamat = $this->input->post('alamat');
        $notelp = $this->input->post('nomorwa');
        $latitudeTo = $this->input->post('lat1');
        $longitudeTo = $this->input->post('lng1');
        $ongkir = '5000';
        $ad = $this->db->query("select * from ongkir where kode='$kdtoko' and drtgl<=curdate() and smptgl>=curdate() and st='1';")->row();
        // $ad = $ac->row_array();
        if (!empty($ad)) {
            $ongkir = $ad->nilai;
        }

        if (isset($_COOKIE['Lat1'])) {
            $lat = $_COOKIE['Lat1'];
            $lng = $_COOKIE['Long1'];
        } else {
            $lat = "1";
            $lng = "1";
        }
        if ($kdtoko == '' || $kdtoko == null) {
            redirect('');
        }

        $ab = $this->db->query("select * from tabel_toko where kd_toko='$kdtoko';")->row();
        // $ab = $aa->row_array();
        $x['toko'] = $ab->nm_toko;
        $x['kdtoko'] = $kdtoko;
        $x['alamat'] = $ab->almt_toko;
        $this->session->set_userdata('cabang', $kdtoko);
        $this->session->set_userdata('nm_toko', $ab->nm_toko);


        $u = $this->session->userdata('telepon');
        $kodepel = $this->m_pelanggan->upd_pelanggann($u, $kdtoko, $type, $lat, $lng);
        $this->session->set_userdata('typeorder', $type);
        $this->session->set_userdata('kdcabang', $kdtoko);
        $nama = $this->session->userdata('nama_pel');
        $kdcabang = $kdtoko;

        $kopel = $this->session->userdata('kopel');
        $layanan = $this->session->userdata('typeorder');
        $i = $this->db->query("SELECT nobukti FROM tbl_belanja1 WHERE kdcabang = '$kdcabang' AND custno = '$kopel' AND stat = '0' AND tgl = curdate()")->row();
        if (!empty($i)) {
            $no_invoice = $i->nobukti;
            $this->session->set_userdata('no_invoice', $no_invoice);
            $this->session->set_userdata('nobukti', $no_invoice);
            $update = $this->db->query("update tbl_belanja1 set layanan = '$layanan' where nobukti = '$no_invoice'");
            $delete = $this->db->query("delete from tbl_belanja_detail1 where nobukti = '$no_invoice' AND jpromo <> ''");
        } else {
            $no_invoice = $this->m_order->get_invoice($kdcabang);
            $this->session->set_userdata('no_invoice', $no_invoice);
            $this->session->set_userdata('nobukti', $no_invoice);
            $order_proses = $this->m_order->order_produk1($no_invoice);
        }

        $update = $this->db->query("update tbl_belanja1 set alamat = '$alamat',custname='$nama', notelp = '$notelp',ongkir='$ongkir', lat = '$latitudeTo', lng = '$longitudeTo' where nobukti = '$no_invoice'");
        $tgl = date('Y-m-d');
        //cari promo
        $hrr = date('w', strtotime("$tgl"));
        $ses_promo = '';
        $wkt = date('H:i:s');
        $this->session->set_userdata('promo', $ses_promo);
        
         if($kopel !='107' || $kopel !='355878' ) {
            $k =  $this->db->query("SELECT nobukti FROM tbl_belanja WHERE custno = '$kopel' AND stat = '6' AND tgl = curdate() and idpromo='078'")->row();
        }
        if(!empty($k)) {
                $rowpromo = $this->db->query("SELECT a.disc1,a.ndisc1,a.idprogram,a.nobukti,a.jnsdisc,a.jnspromo,a.jnsmenu,a.maxbonus FROM promoheader a
					LEFT JOIN promoarea b ON a.nobukti=b.nobukti
					WHERE a.stat='1' AND a.tglawal<='$tgl' AND a.tglakhir>='$tgl' and stpromo='1'  and a.hari like '%$hrr%' and a.hari like '%$hrr%' and jamawal<='$wkt' and jamakhir>='$wkt' and a.idprogram<>'078'
					AND (a.jnslayanan='$type' or a.jnslayanan1='$type' or a.jnslayanan2='$type') AND b.kdwil='$kdtoko' AND (a.eorder = 1 OR a.eorder = 2);")->row();
        } else {
            $rowpromo = $this->db->query("SELECT a.disc1,a.ndisc1,a.idprogram,a.nobukti,a.jnsdisc,a.jnspromo,a.jnsmenu,a.maxbonus FROM promoheader a
					LEFT JOIN promoarea b ON a.nobukti=b.nobukti
					WHERE a.stat='1' AND a.tglawal<='$tgl' AND a.tglakhir>='$tgl' and stpromo='1'  and a.hari like '%$hrr%' and a.hari like '%$hrr%' and jamawal<='$wkt' and jamakhir>='$wkt'
					AND (a.jnslayanan='$type' or a.jnslayanan1='$type' or a.jnslayanan2='$type') AND b.kdwil='$kdtoko' AND (a.eorder = 1 OR a.eorder = 2);")->row();
        }
        if (!empty($rowpromo)) {
            $disc1 = $rowpromo->disc1;
            $diskon = $rowpromo->ndisc1;
            $idprogram = $rowpromo->idprogram;
            $noprogram = $rowpromo->nobukti;
            $jnsdisc = $rowpromo->jnsdisc;
            $jnspromo = $rowpromo->jnspromo;
            $jnsmenu = $rowpromo->jnsmenu;
            $maxbonus = $rowpromo->maxbonus;
            $jpromo = "P";
            $this->session->set_userdata('promo', $idprogram);
            $update = $this->db->query("update tbl_belanja1 set disc='$disc1',promo = '2', idpromo = '$idprogram',jnspromo ='$jnsdisc',  maxbonus = '$maxbonus',notelp = '$u',custname='$nama' where nobukti = '$no_invoice'");
        } else {
            $update = $this->db->query("update tbl_belanja1 set promo = '1', idpromo = '',jnspromo ='',  maxbonus = '0' where nobukti = '$no_invoice'");
        }

        redirect('mobile/menu/favorit', 'refresh');
    }
    function pilihan()
    {

        if (!$this->session->userdata('pengguna')) {
            redirect('');
        }
        $kopel = $this->session->userdata('kopel');
        $kdcabang = $this->session->userdata('kdcabang');

        $cek_sudah_ada = $this->m_order->cek_sudah_ada_nota($kopel, $kdcabang);
        if ($cek_sudah_ada->num_rows() > 0) {
            $cek = $cek_sudah_ada->row_array();
            $nolama = $cek['nobukti'];
            $this->session->set_userdata('nobuktiold', $nolama);
            redirect('mobile/menu/belanja2');
        } else {
            redirect('mobile/menu/favorit');
        }
    }
    function hotpro()
    {
        $x['judul'] = "HOT PROMO";
        $x['data'] = $this->m_menu->hot_promo();
        $this->load->view('mobile/v_home', $x);
    }
    function favorit()
    {
        //cek login
        if (!$this->session->userdata('pengguna')) {
            redirect('');
        }

        $noresi = $this->session->userdata('nobukti');
        $kdbrg1 = $this->session->userdata('kdbrgu');
        $custno = $this->session->userdata('kopel');
        $x['judul'] = "favorit";
        $x['data'] = $this->m_menu->favorit();
        $x['promo'] = $this->m_menu->promonya();
        $x['toping'] = $this->m_menu->topping();
        $x['slide1'] = $this->m_menu->slideself();
        $x['data_hapus'] = $this->m_order->getListPenjualanhapus($noresi, $kdbrg1);
        $x['tot_belanja'] = 0;
        $x['tot_nppn'] = 0;
        $x['tot_netto'] = 0;
        $x['list'] = $this->m_order->getListPenjualan($noresi)->result();

        $this->load->view('mobile/v_menu', $x);
        $this->session->set_userdata('muncul', 0);
    }
    function promobarang()
    {
        //cek login
        $noresi = $this->session->userdata('nobukti');
        $bt = 0;
        $item = 1;
        $max = 1;
        $mino = 0;

        $querycekpromo = $this->db->query("select * from tbl_belanja1 where nobukti = '$noresi'");
        $nil = $querycekpromo->row_array();
        if (isset($nil)) {

            $max = $nil['maxbonus'];
            $item = $nil['item'];
            $idpro = $nil['idpromo'];
        }
        $querycekpromo1 = $this->db->query("select sum(bruto) as total from tbl_belanja_detail1 where nobukti = '$noresi'");
        $nil1 = $querycekpromo1->row_array();
        if (isset($nil1)) {
            $bt = $nil1['total'];
        }
        $se = $this->db->query("select * from promoheader where idprogram = '$idpro'");
        $sei = $se->row_array();
        if (isset($sei)) {
            $mino = $sei['minorder'];
        }

        if (!$this->session->userdata('pengguna')) {
            redirect('');
        } elseif ($item == $max) {
            redirect('mobile/menu/belanja');
        }

        if ($bt < $mino) {
            redirect('mobile/menu/belanja');
        }

        $noresi = $this->session->userdata('nobukti');
        $kdbrg1 = $this->session->userdata('kdbrgu');
        $custno = $this->session->userdata('kopel');
        $x['judul'] = "promo";
        $x['data'] = $this->m_menu->promobarang('$noresi');
        $x['promo'] = $this->m_menu->promonya();
        $x['toping'] = $this->m_menu->topping();
        $x['data_hapus'] = $this->m_order->getListPenjualanhapus($noresi, $kdbrg1);
        $x['tot_belanja'] = 0;
        $x['tot_nppn'] = 0;
        $x['tot_netto'] = 0;
        $x['list'] = $this->m_order->getListPenjualan($noresi);
        $this->load->view('mobile/v_promo', $x);
        $this->session->set_userdata('muncul', 0);
    }

    function promobarangm()
    {
        //cek login
        $noresi = $this->session->userdata('nobukti');
        $bt = 0;
        $tbns = 0;
        $item = 1;
        $max = 1;
        $mino = 0;
        $perqty = '1';

        $querycekpromo = $this->db->query("select * from tbl_belanja1 where nobukti = '$noresi'");
        $nil = $querycekpromo->row_array();
        if (isset($nil)) {

            $max = $nil['maxbonus'];
            $item = $nil['item'];
            $idpro = $nil['idpromo'];
        }
        $querycekpromo1 = $this->db->query("select sum(bruto) as total,sum(qty) as tqty from tbl_belanja_detail1 where nobukti = '$noresi' and jpromo='B'");
        $nil1 = $querycekpromo1->row_array();
        if (isset($nil1)) {
            $bt = $nil1['total'];
            $tbns = $nil1['tqty'];
        }
        $se = $this->db->query("select * from promoheader where idprogram = '$idpro'");
        $sei = $se->row_array();
        if (isset($sei)) {
            $mino = $sei['minorder'];
            $perqty = $sei['perqty'];
        }

        if (!$this->session->userdata('pengguna')) {
            redirect('');
        } elseif ($tbns == floor($max / $perqty)) {
            redirect('mobile/menu/belanja');
        }

        if ($tbns >= floor($max / $perqty)) {
            redirect('mobile/menu/belanja');
        }

        $noresi = $this->session->userdata('nobukti');
        $kdbrg1 = $this->session->userdata('kdbrgu');
        $custno = $this->session->userdata('kopel');
        $x['judul'] = "promo";
        $x['data'] = $this->m_menu->promobarangm('$noresi');
        //  $x['promo'] = $this->m_menu->promonya();
        $x['toping'] = $this->m_menu->topping();
        $x['data_hapus'] = $this->m_order->getListPenjualanhapus($noresi, $kdbrg1);
        $x['tot_belanja'] = 0;
        $x['tot_nppn'] = 0;
        $x['tot_netto'] = 0;
        $x['list'] = $this->m_order->getListPenjualan($noresi);
        $this->load->view('mobile/v_promo1', $x);
        //   redirect('mobile/menu/belanja');
    }
    function utama()
    {
        $x['judul'] = "HOT PROMO";
        $x['data'] = $this->m_menu->hot_promo();
        $this->load->view('mobile/v_home', $x);
    }
    function miegurih()
    {
        //cek login
        if (!$this->session->userdata('pengguna')) {
            redirect('');
        }

        $noresi = $this->session->userdata('nobukti');
        $kdbrg1 = $this->session->userdata('kdbrgu');
        $x['judul'] = "miegurih";
        $x['data'] = $this->m_menu->miegurih();
        $x['toping'] = $this->m_menu->topping();
        $x['slide1'] = $this->m_menu->slideself();
        $x['promo'] = $this->m_menu->promonya();
        $x['data_hapus'] = $this->m_order->getListPenjualanhapus($noresi, $kdbrg1);
        $x['tot_belanja'] = 0;
        $x['tot_nppn'] = 0;
        $x['tot_netto'] = 0;
        $x['list'] = $this->m_order->getListPenjualan($noresi)->result();
        $this->load->view('mobile/v_menu', $x);
    }
    
    function miemewahsegar()
    {
        //cek login
        if(!$this->session->userdata('pengguna')){
            redirect('');
        }
        
        $noresi = $this->session->userdata('nobukti');
        $kdbrg1 = $this->session->userdata('kdbrgu');
        $x['judul'] = "miemewahsegar";
        $x['data'] = $this->m_menu->miemewahsegar();
        $x['toping'] = $this->m_menu->topping();
        $x['slide1'] = $this->m_menu->slideself();
        $x['promo'] = $this->m_menu->promonya();
        $x['data_hapus'] = $this->m_order->getListPenjualanhapus($noresi, $kdbrg1);
        $x['tot_belanja'] = 0;
        $x['tot_nppn'] = 0;
        $x['tot_netto'] = 0;
        $x['list'] = $this->m_order->getListPenjualan($noresi)->result();
        $this->load->view('mobile/v_menu', $x);
    }
    
    function miemewahcreamy()
    {
        //cek login
        if(!$this->session->userdata('pengguna')){
            redirect('');
        }
        
        $noresi = $this->session->userdata('nobukti');
        $kdbrg1 = $this->session->userdata('kdbrgu');
        $x['judul'] = "miemewahcreamy";
        $x['data'] = $this->m_menu->miemewahcreamy();
        $x['toping'] = $this->m_menu->topping();
        $x['slide1'] = $this->m_menu->slideself();
        $x['promo'] = $this->m_menu->promonya();
        $x['data_hapus'] = $this->m_order->getListPenjualanhapus($noresi, $kdbrg1);
        $x['tot_belanja'] = 0;
        $x['tot_nppn'] = 0;
        $x['tot_netto'] = 0;
        $x['list'] = $this->m_order->getListPenjualan($noresi)->result();
        $this->load->view('mobile/v_menu', $x);
    }

    function updatecari()
    {
        //cek login
        if (!$this->session->userdata('pengguna')) {
            redirect('');
        }

        $menucari = urldecode($this->uri->segment(4));
        $this->session->set_userdata('menucari', $menucari);
        $judul = urldecode($this->uri->segment(3));
        $uri = $judul . '/' . $menucari;
        $noresi = $this->session->userdata('nobukti');
        $kdbrg1 = $this->session->userdata('kdbrgu');
        $x['judul'] = $uri;
        $x['data'] = $this->m_menu->makananCari($menucari);
        $x['toping'] = $this->m_menu->topping();
        $x['data_hapus'] = $this->m_order->getListPenjualanhapus($noresi, $kdbrg1);
        $x['tot_belanja'] = 0;
        $x['tot_nppn'] = 0;
        $x['tot_netto'] = 0;
        $x['list'] = $this->m_order->getListPenjualan($noresi);
        $this->load->view('mobile/v_menu', $x);
    }

    function gurihtopping()
    {
        //cek login
        if (!$this->session->userdata('pengguna')) {
            redirect('');
        }

        $x['judul'] = "gurihtopping";
        $x['judul1'] = "gurihtopping";
        $x['data'] = $this->m_menu->gurihtopping();
        $this->load->view('mobile/v_menu', $x);
    }
    function miegokil()
    {
        //cek login
        if (!$this->session->userdata('pengguna')) {
            redirect('');
        }

        $noresi = $this->session->userdata('nobukti');
        $kdbrg1 = $this->session->userdata('kdbrgu');
        $x['judul'] = "miegokil";
        $x['data'] = $this->m_menu->miegokil();
        $x['toping'] = $this->m_menu->topping();
        $x['slide1'] = $this->m_menu->slideself();
        
        $x['promo'] = $this->m_menu->promonya();
        $x['data_hapus'] = $this->m_order->getListPenjualanhapus($noresi, $kdbrg1);
        $x['tot_belanja'] = 0;
        $x['tot_nppn'] = 0;
        $x['tot_netto'] = 0;
        $x['list'] = $this->m_order->getListPenjualan($noresi)->result();
        $this->load->view('mobile/v_menu', $x);
    }
    function gokiltopping()
    {
        //cek login
        if (!$this->session->userdata('pengguna')) {
            redirect('');
        }

        $x['judul1'] = "gokiltopping";
        $x['judul'] = "gokiltopping";
        $x['data'] = $this->m_menu->gokiltopping();
        $this->load->view('mobile/v_menu', $x);
    }

    function topping()
    {
        //cek login
        if (!$this->session->userdata('pengguna')) {
            redirect('');
        }

        $x['judul'] = "topping";
        $x['data'] = $this->m_menu->toppingMenu();
        $noresi = $this->session->userdata('nobukti');
        $x['slide1'] = $this->m_menu->slideself();
        $x['promo'] = $this->m_menu->promonya();
        $x['tot_belanja'] = 0;
        $x['tot_nppn'] = 0;
        $x['tot_netto'] = 0;
        $x['list'] = $this->m_order->getListPenjualan($noresi)->result();
        $this->load->view('mobile/v_menu', $x);
    }

    function topping1()
    {
        //cek login
        if (!$this->session->userdata('pengguna')) {
            redirect('');
        }

        $x['judul'] = "topping";
        $x['data'] = $this->m_menu->topping1();
        $this->load->view('mobile/v_menu', $x);
    }
    function snack()
    {
        //cek login
        if (!$this->session->userdata('pengguna')) {
            redirect('');
        }

        $x['judul'] = "snack";
        $x['data'] = $this->m_menu->snack();
        
        $x['promo'] = $this->m_menu->promonya();
        $noresi = $this->session->userdata('nobukti');
        $x['tot_belanja'] = 0;
        $x['tot_nppn'] = 0;
        $x['tot_netto'] = 0;
        $x['slide1'] = $this->m_menu->slideself();
        $x['list'] = $this->m_order->getListPenjualan($noresi)->result();

        $this->load->view('mobile/v_menu', $x);
    }
    function minuman()
    {
        //cek login
        if (!$this->session->userdata('pengguna')) {
            redirect('');
        }

        $x['judul'] = "minuman";
        $x['data'] = $this->m_menu->minuman();
        $noresi = $this->session->userdata('nobukti');
        $x['slide1'] = $this->m_menu->slideself();
        $x['promo'] = $this->m_menu->promonya();
        $x['tot_belanja'] = 0;
        $x['tot_nppn'] = 0;
        $x['tot_netto'] = 0;
        $x['list'] = $this->m_order->getListPenjualan($noresi)->result();
        $this->load->view('mobile/v_menu', $x);
    }
    function mtop1()
    {
        $x['judul'] = "makanana";
        $x['judul1'] = "mtop1";
        $x['data'] = $this->m_menu->mtop1();
        $this->load->view('mobile/v_menu', $x);
    }
    function mtop2()
    {
        $x['judul'] = "makanana";
        $x['judul1'] = "mtop2";
        $x['data'] = $this->m_menu->mtop2();
        $this->load->view('mobile/v_menu', $x);
    }
    function mtop3()
    {
        $x['judul'] = "makanana";
        $x['judul1'] = "mtop3";
        $x['data'] = $this->m_menu->mtop3();
        $this->load->view('mobile/v_menu', $x);
    }
    function mtop4()
    {
        $x['judul'] = "makanana";
        $x['judul1'] = "mtop4";
        $x['data'] = $this->m_menu->mtop4();
        $this->load->view('mobile/v_menu', $x);
    }
    function gtop1()
    {
        $x['judul'] = "makanan1a";
        $x['judul1'] = "gtop1";
        $x['data'] = $this->m_menu->gtop1();
        $this->load->view('mobile/v_menu', $x);
    }
    function gtop2()
    {
        $x['judul'] = "makanan1a";
        $x['judul1'] = "gtop2";
        $x['data'] = $this->m_menu->gtop2();
        $this->load->view('mobile/v_menu', $x);
    }
    function gtop3()
    {
        $x['judul'] = "makanan1a";
        $x['judul1'] = "gtop3";
        $x['data'] = $this->m_menu->gtop3();
        $this->load->view('mobile/v_menu', $x);
    }
    function gtop4()
    {
        $x['judul'] = "makanan1a";
        $x['judul1'] = "gtop4";
        $x['data'] = $this->m_menu->gtop4();
        $this->load->view('mobile/v_menu', $x);
    }

    function favorite()
    {
        $x['judul'] = "FAVORITE";
        $x['data'] = $this->m_menu->favorite();
        $this->load->view('mobile/v_menu', $x);
    }
    function detail_menu()
    {
        $kode = $this->uri->segment(4);
        $x['data'] = $this->m_menu->detail_menu($kode);
        $this->load->view('mobile/v_detail_menu', $x);
    }

    function like()
    {
        $kode = $this->uri->segment(4);
        $this->m_menu->add_like($kode);
        $x['data'] = $this->m_menu->detail_menu($kode);
        $this->load->view('mobile/v_detail_menu', $x);
    }

    function add_to_cart()
    {
        $kode = $this->uri->segment(4);
        $produk = $this->m_menu->detail_menu($kode);
        $i = $produk->row_array();
        $data = array(
            'id'      => $kode,
            'qty'     => 1,
            'price'   => $i['menu_harga_baru'],
            'name'    => $i['menu_nama'],
            'image'    => $i['menu_gambar']

        );

        $this->cart->insert($data);
        redirect('mobile/menu/cart');
    }

    function cart()
    {
        $nobukti = $this->session->userdata('nobukti');
        $this->load->view('mobile/v_cart');
    }

    public function belanja()
    {
        //cek login
        if (!$this->session->userdata('pengguna')) {
            redirect('');
        }

        $tgl = date('Y-m-d');
        $noresi = $this->session->userdata('nobukti');
        $custno = $this->session->userdata('kopel');
        $kdharga = 'kh01';
        $data_faktur = $this->m_order->getDataPenjualan($noresi, $custno)->row();
        $list_barang = $this->m_order->getListPenjualan($noresi)->result_array();
        $do = $this->db->query("SELECT SUM(a.bruto+a.nppn) AS tot_belppn FROM tbl_belanja_detail1  a where nobukti='$noresi'; ");
        $ni = $do->row_array();
        $netto = $ni['tot_belppn'];
        if ($netto < 60000) {
            $dl = $this->db->query("delete from tbl_belanja_detail1 where nobukti='$noresi' and kdpromo='077' and jpromo='B';");
        }
        
        if ($data_faktur) {
        $data['tgl'] = date('Y-m-d');
        $data['faktur'] = $data_faktur;
        $data['list'] = $list_barang;
        $data['tot_item'] = 0;
        $data['tot_belanja'] = 0;
        $data['tot_nppn'] = 0;
        $data['tot_netto'] = 0;
        $data['tot_diskon'] = 0;
        $data['belanja'] = $this->m_order->getTotalBelanja($noresi)->row();
        $data['ly'] = $this->db->query("select * from tbl_belanja1 where nobukti='$noresi'")->row_array();
        $this->load->view('mobile/v_belanja', $data);
        }else{
            redirect('mobile/menu/cetak_invoice');
        }
    }

    public function belanja2()
    {
        //cek login
        if (!$this->session->userdata('pengguna')) {
            redirect('');
        }

        $tgl = date('Y-m-d');
        $noresi = $this->session->userdata('nobuktiold');
        $custno = $this->session->userdata('kopel');
        $kdharga = 'kh01';
        $data_faktur = $this->m_order->getDataPenjualan($noresi, $custno)->row();
        $list_barang = $this->m_order->getListPenjualan($noresi);


        if ($data_faktur) {
            $data['tgl'] = date('Y-m-d');
            $data['faktur'] = $data_faktur;
            $data['list'] = $list_barang;
            $data['tot_item'] = 0;
            $data['tot_belanja'] = 0;
            $data['tot_nppn'] = 0;
            $data['tot_netto'] = 0;
            $data['tot_diskon'] = 0;
            $data['belanja'] = $this->m_order->getTotalBelanja($noresi)->row();
            $this->load->view('mobile/v_belanja', $data);
        } else {
            redirect('mobile/menu/cetak_invoice');
        }
    }

    public function belanja1()
    {
        $kopel = $this->session->userdata('kopel');
        $kdcabang = $this->session->userdata('kdcabang');
        $this->db->query("update tbl_pelanggan set plg_status='1' where plg_id='$kopel'");
        $no_invoice = $this->m_order->get_invoice($kdcabang);
        $this->session->set_userdata('no_invoice', $no_invoice);
        $this->session->set_userdata('nobukti', $no_invoice);
        $order_proses = $this->m_order->order_produk1($no_invoice);

        $tgl = date('Y-m-d');
        $noresi = $this->session->userdata('nobukti');
        $custno = $this->session->userdata('kopel');
        $kdharga = 'kh01';
        $data_faktur = $this->m_order->getDataPenjualan($noresi, $custno)->row();
        $list_barang = $this->m_order->getListPenjualan($noresi);

        if ($data_faktur) {
            $data['tgl'] = date('Y-m-d');
            $data['faktur'] = $data_faktur;
            $data['list'] = $list_barang;
            $data['tot_item'] = 0;
            $data['tot_belanja'] = 0;
            $data['tot_nppn'] = 0;
            $data['tot_netto'] = 0;
            $data['tot_diskon'] = 0;
            $data['belanja'] = $this->m_order->getTotalBelanja($noresi)->row();
            $this->load->view('mobile/v_belanja', $data);
        } else {
            redirect('mobile/menu/cetak_invoice');
        }
    }


    function remove()
    {
        $row_id = $this->uri->segment(4);
        $this->cart->update(array(
            'rowid'      => $row_id,
            'qty'     => 0
        ));
        redirect('mobile/menu/cart');
    }
    function update()
    {
        $this->cart->update($_POST);
        redirect('mobile/menu/cart');
    }


    function check_out()
    {
        if ($this->session->userdata('online') != TRUE) {
            $url = base_url('mobile/member');
            redirect($url);
        } else {
            $no_invoice = $this->m_order->get_invoice();
            $total = $this->cart->total();
            $this->session->set_userdata('no_invoice', $no_invoice);
            $order_proses = $this->m_order->order_produk($no_invoice, $total);
            if ($order_proses) {
                $this->cart->destroy();
                redirect('mobile/menu/sukses');
            } else {
                redirect('mobile/menu/cart');
            }
        }
    }
    function check_out1()
    {
        $nobukti = $this->session->userdata('nobukti');
        $kdjenis = $this->session->userdata('kdjenis');
        if ($this->session->userdata('online') != TRUE) {
            $url = base_url('mobile/member');
            redirect($url);
        } else {
            $order_proses = $this->m_order->updateorder($nobukti);
            if ($order_proses) {
                if($kdjenis != 2){
                    $this->m_order->kirim_struk($nobukti);
                }
                redirect('mobile/menu/cetak_invoice');
            } else {
                redirect('mobile/menu/belanja');
            }
        }
    }
    public function add_list_order()
    {

        $kdbrg = $this->uri->segment(4);
        $kode = $this->uri->segment(4);
        $balik = $this->uri->segment(5);
        $tpp = $this->uri->segment(6);

        // jika add barang dari halaman cari
        // if ($balik == 'updatecari') {
        //     $balik = 'updatecari/' . $this->session->userdata('menucari');
        //     $tpp = $this->uri->segment(7);
        // }

        $nobukti = $this->session->userdata('nobukti');
        $kdtoko = $this->session->userdata('cabang');

        $tgl = date('Y-m-d');
        $id_user = $this->session->userdata('ses_username');
        $produk = $this->m_menu->detail_menu($kode);
        $x = $produk->row_array();
        $harga_jual = $x['hargajual'];
        $ppn = $x['ppn'];
        $nourut = 1;
        $nppn = 0;
        $idpromo = '';
        $kpromo  = '';
        $jpromo = '';


        // jika menu mie maka akan muncul topping
        // if ($tpp == 'J01' || $tpp == 'J07') {
        //     $this->session->set_userdata('topping', true);
        //     $this->session->set_userdata('kdbrgu', $kdbrg);
        // } else {
        //     $this->session->unset_userdata('topping');
        //     $this->session->unset_userdata('kdbrgu');
            //jika promo coret harga

            $lay = $this->db->query("select layanan,'KH01' kdharga,idpromo,item,jnspromo,promo from tbl_belanja1 where nobukti='$nobukti';");
            $laya = $lay->row_array();
            $layanan = $laya['layanan'];
            $kdharga = $laya['kdharga'];
            $idbonus = $laya['idpromo'];
            $titem = $laya['item'];
            $jnspromo = $laya['jnspromo'];
            $promo = $laya['promo'];

            if ($promo == '2') {
                $kb = $this->db->query("select a.kdbrgbonus,b.id,jnsbonus,a.extrabonus,b.id1 from tabel_menu a
								left join jenismenu b on a.jenisbrg=b.kdjenis
								where a.kode_menu='$kdbrg';");
                $kbo = $kb->row_array();
                $kdbonus = $kbo['kdbrgbonus'];
                $idmenu = $kbo['id'];
                $idmenu1 = $kbo['id1'];
                $jnsbonus = $kbo['jnsbonus'];
                $extrabonus = $kbo['extrabonus'];



                if ($jnspromo == '2') {
                    if ($x['maxbonus'] > 0) {
                        if ($x['item'] < $x['maxbonus']) {
                            $harga_jual = $x['newharga'];
                            if ($harga_jual == 0 || null) {
                                $harga_jual = $x['hargajual'];
                                $idpromo = '';
                                $kpromo  = '';
                                $jpromo = '';
                            } else {
                                $idpromo = $x['idpromo'];
                                $kpromo  = 'Promo *';
                                $jpromo = 'P';
                                $this->db->query("UPDATE tbl_belanja1 SET item = item + 1 where nobukti = '$nobukti'");
                            }
                        }
                        if ($x['item'] > $x['maxbonus']) {
                            $harga_jual = $x['hargajual'];
                            $idpromo = '';
                            $kpromo  = '';
                            $jpromo = '';
                        }
                    }
                }

                if ($jnspromo == '4') {

                    $cbonus = $this->db->query("select * from promoheader where idprogram='$idbonus' and (jnsmenu='$idmenu' or jnsmenu='$idmenu1' );");
                    $pbonus = $cbonus->row_array();
                    if ($cbonus->num_rows() > 0) {
                        $minqtybonus = $pbonus['minqty'];
                        $maxqtybonus = $pbonus['maxbonus'];
                        $perqtybonus = $pbonus['perqty'];
                        $idpromo = $idbonus;
                        $jpromo = 'B';
                        $kpromo  = 'Bonus *';
                        $harga_jual = 0;
                    }
                }
            }
            if ($tpp == 'pr') {
                $harga_jual = 0;
                $idpromo = '077';
                $jpromo = 'B';
                $kpromo  = 'Promo *';
            }
            // jika ada ppn
            if ($ppn == "Y") {
                $nppn = ($harga_jual * (10 / 100));
            }

            // jika sudah pesan menu, maka akan edit menu
            $cek_sudah_ada = $this->m_order->cek_sudah_ada_promo($kdbrg, $nobukti, $jpromo);
            if ($cek_sudah_ada->num_rows() > 0) {

                $s = $cek_sudah_ada->row_array();
                $jum_beli = $s['qty'];
                $jum_beli_sekarang = $jum_beli + 1;
                $nppn_sekarang = 0;
                $subtot_sekarang = ($harga_jual * $jum_beli_sekarang);
                if ($ppn == 'Y') {
                    $nppn_sekarang = ($subtot_sekarang * (10 / 100));
                }
                $this->db->query("UPDATE tbl_belanja_detail1 SET qty='$jum_beli_sekarang', bruto='$subtot_sekarang',
            nppn='$nppn_sekarang' WHERE kdbrg='$kdbrg' AND nobukti='$nobukti' AND harga='$harga_jual' AND kdpromo = '$idpromo'");
                redirect('mobile/menu/' . $balik);
            }
            // jika belum pesan menu, makan akan tambah menu
            else {
                if ($tpp == 'pr') {
                    $harga_jual = 0;
                    $this->db->query("UPDATE tbl_belanja1 SET item = item + 1 where nobukti = '$nobukti'");
                    $idpromo = '077';
                    $jpromo = 'B';
                }

                $data = array(
                    'kdcabang' => $kdtoko,
                    'nobukti' => $nobukti,
                    'nourut' => $nourut,
                    'nama_menu' => $x['menu_nama'] . ' ' . $kpromo,
                    'kdpromo' => $idpromo,
                    'jpromo' => $jpromo,
                    'kdbrg' => $kdbrg,
                    'kdbrg1' => $kdbrg,
                    'qty' => 1,
                    'harga' => $harga_jual,
                    'bruto' => $harga_jual,
                    'nppn' => $nppn,
                );
                $this->db->insert('tbl_belanja_detail1', $data);
            }
            $this->db->query("UPDATE tbl_belanja1 SET stat = 0 where nobukti = '$nobukti'");
            
        redirect('mobile/menu/' . $balik);
    }
    public function add_list_orderb()
    {

        $kdbrg = $this->uri->segment(4);
        $kode = $this->uri->segment(4);
        $balik = $this->uri->segment(5);
        $tpp = $this->uri->segment(6);

        // jika add barang dari halaman cari
        if ($balik == 'updatecari') {
            $balik = 'updatecari/' . $this->session->userdata('menucari');
            $tpp = $this->uri->segment(7);
        }

        $nobukti = $this->session->userdata('nobukti');
        $kdtoko = $this->session->userdata('cabang');

        $tgl = date('Y-m-d');
        $id_user = $this->session->userdata('ses_username');
        $produk = $this->m_menu->detail_menu($kode);
        $x = $produk->row_array();
        $harga_jual = $x['hargajual'];
        $ppn = $x['ppn'];
        $nourut = 1;
        $nppn = 0;
        $idpromo = '';
        $kpromo  = '';
        $jpromo = '';
        $maxbonus = '0';
        $tqtyp = 0;
        $perqtybonus = '1';
        $maxqtybonus = 0;
        $minqtybonus = 0;


        // jika menu mie maka akan muncul topping
        if ($tpp == 'J01' || $tpp == 'J07') {
            $this->session->set_userdata('topping', true);
            $this->session->set_userdata('kdbrgu', $kdbrg);
        } else {
            $this->session->unset_userdata('topping');
            $this->session->unset_userdata('kdbrgu');
            //jika promo coret harga

            $lay = $this->db->query("select layanan,'KH01' kdharga,idpromo,item,jnspromo,promo from tbl_belanja1 where nobukti='$nobukti';");
            $laya = $lay->row_array();
            $layanan = $laya['layanan'];
            $kdharga = $laya['kdharga'];
            $idbonus = $laya['idpromo'];
            $titem = $laya['item'];
            $jnspromo = $laya['jnspromo'];
            $promo = $laya['promo'];

            if ($promo == '2') {
                $kb = $this->db->query("select a.kdbrgbonus,b.id,jnsbonus,a.extrabonus,b.id1 from tabel_menu a
								left join jenismenu b on a.jenisbrg=b.kdjenis
								where a.kode_menu='$kdbrg';");
                $kbo = $kb->row_array();
                $kdbonus = $kbo['kdbrgbonus'];
                $idmenu = $kbo['id'];
                $idmenu1 = $kbo['id1'];
                $jnsbonus = $kbo['jnsbonus'];
                $extrabonus = $kbo['extrabonus'];



                if ($jnspromo == '2') {
                    if ($x['maxbonus'] > 0) {
                        if ($x['item'] < $x['maxbonus']) {
                            $harga_jual = $x['newharga'];
                            if ($harga_jual == 0 || null) {
                                $harga_jual = $x['hargajual'];
                                $idpromo = '';
                                $kpromo  = '';
                                $jpromo = '';
                            } else {
                                $idpromo = $x['idpromo'];
                                $kpromo  = 'Promo *';
                                $jpromo = 'P';
                                $this->db->query("UPDATE tbl_belanja1 SET item = item + 1 where nobukti = '$nobukti'");
                            }
                        }
                        if ($x['item'] > $x['maxbonus']) {
                            $harga_jual = $x['hargajual'];
                            $idpromo = '';
                            $kpromo  = '';
                            $jpromo = '';
                        }
                    }
                }

                if ($jnspromo == '4') {
                    $c = $this->db->query("select sum(qty) tqty from tbl_belanja_detail1 where nobukti='$nobukti' and jpromo='B';");
                    if ($c->num_rows() > 0) {
                        $ci = $c->row_array();
                        $maxbonus = $ci['tqty'];
                    }
                    $c1 = $this->db->query("select sum(qty) tqty from tbl_belanja_detail1 where nobukti='$nobukti' and jpromo='P';");
                    if ($c1->num_rows() > 0) {
                        $ci1 = $c1->row_array();
                        $tqtyp = $ci1['tqty'];
                    }

                    $cpr = $this->db->query("select newharga from promodetail where idpromo='$idbonus' and kdbrg='$kdbrg' and kdcabang='$kdtoko';");
                    if ($cpr->num_rows() > 0) {
                        $dcpr = $cpr->row_array();
                        $harga_jual = $dcpr['newharga'];
                        $idpromo = $idbonus;
                        $jpromo = 'B';
                        $kpromo  = 'Bonus *';
                    }

                    $cbonus = $this->db->query("select * from promoheader where idprogram='$idbonus' and (jnsmenu='$idmenu' or jnsmenu='$idmenu1' or jnsmenu='7');");
                    $pbonus = $cbonus->row_array();
                    if ($cbonus->num_rows() > 0) {
                        $minqtybonus = $pbonus['minqty'];
                        $maxqtybonus = $pbonus['maxbonus'];
                        $perqtybonus = $pbonus['perqty'];
                        $idpromo = $idbonus;
                        $jpromo = 'B';
                        $kpromo  = 'Bonus *';
                    }
                }
                if ($maxbonus >= floor($tqtyp / $perqtybonus)) {
                    redirect('mobile/menu/' . $balik);
                }
            }
            if ($tpp == 'pr') {
                $harga_jual = 0;
                $idpromo = '077';
                $jpromo = 'B';
                $kpromo  = 'Promo *';
            }
            // jika ada ppn
            if ($ppn == "Y") {
                $nppn = ($harga_jual * (10 / 100));
            }

            // jika sudah pesan menu, maka akan edit menu
            $cek_sudah_ada = $this->m_order->cek_sudah_ada_promo($kdbrg, $nobukti, $jpromo);
            if ($cek_sudah_ada->num_rows() > 0) {

                $s = $cek_sudah_ada->row_array();
                $jum_beli = $s['qty'];
                $jum_beli_sekarang = $jum_beli + 1;
                $nppn_sekarang = 0;
                $subtot_sekarang = ($harga_jual * $jum_beli_sekarang);
                if ($ppn == 'Y') {
                    $nppn_sekarang = ($subtot_sekarang * (10 / 100));
                }
                $this->db->query("UPDATE tbl_belanja_detail1 SET qty='$jum_beli_sekarang', bruto='$subtot_sekarang',
            nppn='$nppn_sekarang' WHERE kdbrg='$kdbrg' AND nobukti='$nobukti' AND harga='$harga_jual' AND kdpromo = '$idpromo'");
                redirect('mobile/menu/' . $balik);
            }
            // jika belum pesan menu, makan akan tambah menu
            else {
                if ($tpp == 'pr') {
                    $harga_jual = 0;
                    $this->db->query("UPDATE tbl_belanja1 SET item = item + 1 where nobukti = '$nobukti'");
                    $idpromo = '077';
                    $jpromo = 'B';
                }

                $data = array(
                    'kdcabang' => $kdtoko,
                    'nobukti' => $nobukti,
                    'nourut' => $nourut,
                    'nama_menu' => $x['menu_nama'] . ' ' . $kpromo,
                    'kdpromo' => $idpromo,
                    'jpromo' => $jpromo,
                    'kdbrg' => $kdbrg,
                    'kdbrg1' => $kdbrg,
                    'qty' => 1,
                    'harga' => $harga_jual,
                    'bruto' => $harga_jual,
                    'nppn' => $nppn,
                );
                $this->db->insert('tbl_belanja_detail1', $data);
            }
        }
        redirect('mobile/menu/' . $balik);
    }

    public function add_list_orderp()
    {

        $kdbrg = $this->uri->segment(4);
        $kode = $this->uri->segment(4);
        $balik = $this->uri->segment(5);
        $tpp = $this->uri->segment(6);
        $angka = $this->uri->segment(7);
        $nil = 1;

        $nobukti = $this->session->userdata('nobukti');
        $kdtoko = $this->session->userdata('cabang');
        $this->db->query("UPDATE tbl_belanja1 SET item = item + 1 where nobukti = '$nobukti';");


        $tgl = date('Y-m-d');
        $id_user = $this->session->userdata('ses_username');
        $produk = $this->m_menu->detail_menu($kode);
        $x = $produk->row_array();
        $harga_jual = $x['hargajual'];
        $ppn = $x['ppn'];
        $nourut = 70;
        $nppn = 0;
        $idpromo = '';
        $kpromo  = '';
        $jpromo = '';
        $item = $x['item'];
        $qty = 1;


        $max = $x['maxbonus'];
        $d = $this->db->query("select sum(qty) as item from tbl_belanja_detail1 where nobukti='$nobukti' and jpromo='P' and kdpromo='077';");
        $di = $d->row_array();
        if (isset($di)) {
            $item = $di['item'];
        } else {
            $item = 0;
            $qty = 1;
        }
        if ($nil == $angka) {

            if ($tpp == 'pr') {
                $harga_jual = 0;
                $idpromo = '077';
                $jpromo = 'B';
                $kpromo  = 'Bonus *';
            }
            // jika sudah pesan menu, maka akan edit menu

            $cek_sudah_ada = $this->m_order->cek_sudah_ada_promop($nobukti, $jpromo);
            if ($cek_sudah_ada->num_rows() > 0) {
                redirect('mobile/menu/' . $balik);
            }
            // jika belum pesan menu, makan akan tambah menu
            else {

                if ($tpp == 'pr') {
                    $harga_jual = 0;
                    $this->db->query("UPDATE tbl_belanja1 SET item = item + 1 where nobukti = '$nobukti'");
                    $idpromo = '077';
                    $jpromo = 'B';
                }
                $data = array(
                    'kdcabang' => $kdtoko,
                    'nobukti' => $nobukti,
                    'nourut' => $nourut,
                    'nama_menu' => $x['menu_nama'] . ' ' . $kpromo,
                    'kdpromo' => $idpromo,
                    'jpromo' => $jpromo,
                    'kdbrg' => $kdbrg,
                    'kdbrg1' => $kdbrg,
                    'qty' => $qty,
                    'harga' => $harga_jual,
                    'bruto' => $harga_jual,
                    'nppn' => $nppn,
                );
                $this->db->insert('tbl_belanja_detail1', $data);
            }
        }

        redirect('mobile/menu/' . $balik);
    }
    public function add_list_topping()
    {

        //kode topping
        $kdbrg2 = $this->uri->segment(4);
        $balik = $this->uri->segment(5);
        //kode barang mie
        $kdbrg1 = $this->uri->segment(6);

        // if ($balik == 'updatecari') {
        //     $balik = 'updatecari/' . $this->session->userdata('menucari');
        //     $kdbrg1 = $this->uri->segment(7);
        // }


        $kode = $this->uri->segment(4);

        $nobukti = $this->session->userdata('nobukti');
        $kdtoko = $this->session->userdata('cabang');
        $tgl = date('Y-m-d');
        $id_user = $this->session->userdata('ses_username');



        //data toping
        $cek_menu_toping = $this->m_menu->detail_topping($kdbrg1, $kdbrg2);
        $x = $cek_menu_toping->row_array();
        $kdbrg = $x['menu_id'];
        $harga_jual = $x['hargajual'];
        $ppnt = $x['ppn'];
        $nourut = 1;
        $nppn = 0;
        $idpromo = '';
        $kpromo  = '';
        $jpromo = '';


        $lay = $this->db->query("select layanan,'KH01' kdharga,idpromo,item,jnspromo,promo,maxbonus from tbl_belanja1 where nobukti='$nobukti';");
        $laya = $lay->row_array();
        $layanan = $laya['layanan'];
        $kdharga = $laya['kdharga'];
        $idbonus = $laya['idpromo'];
        $titem = $laya['item'];
        $jnspromo = $laya['jnspromo'];
        $max = $laya['maxbonus'];
        $promo = $laya['promo'];

        $d = $this->db->query("select sum(qty) as item from tbl_belanja_detail1 where nobukti='$nobukti' and jpromo='P' and kdpromo='$idbonus';");
        $di = $d->row_array();
        if (isset($di)) {
            $item = $di['item'];
        } else {
            $item = 0;
            $qty = 1;
        }

        if ($promo == '2') {
            $kb = $this->db->query("select a.kdbrgbonus,b.id,jnsbonus,a.extrabonus,b.id1 from tabel_menu a
								left join jenismenu b on a.jenisbrg=b.kdjenis
								where a.kode_menu='$kdbrg';");
            $kbo = $kb->row_array();
            $kdbonus = $kbo['kdbrgbonus'];
            $idmenu = $kbo['id'];
            $idmenu1 = $kbo['id1'];
            $jnsbonus = $kbo['jnsbonus'];
            $extrabonus = $kbo['extrabonus'];



            if ($jnspromo == '2') {
                if ($x['maxbonus'] > 0) {
                    if ($item < $x['maxbonus']) {
                        $harga_jual = $x['newharga'];
                        if ($harga_jual == 0 || null) {
                            $harga_jual = $x['hargajual'];
                            $idpromo = '';
                            $kpromo  = '';
                            $jpromo = '';
                        } else {
                            $idpromo = $x['idpromo'];
                            $kpromo  = 'Promo *';
                            $jpromo = 'P';
                            $this->db->query("UPDATE tbl_belanja1 SET item = item + 1 where nobukti = '$nobukti'");
                        }
                    }
                    if ($item > $x['maxbonus']) {
                        $harga_jual = $x['hargajual'];
                        $idpromo = '';
                        $kpromo  = '';
                        $jpromo = '';
                    }
                }
            }

            if ($jnspromo == '4') {

                $cbonus = $this->db->query("select * from promoheader where idprogram='$idbonus' and (jnsmenu='$idmenu' or jnsmenu='$idmenu1');");
                $pbonus = $cbonus->row_array();
                if ($cbonus->num_rows() > 0) {
                    $minqtybonus = $pbonus['minqty'];
                    $maxqtybonus = $pbonus['maxbonus'];
                    $perqtybonus = $pbonus['perqty'];
                    if ($max > 0) {
                        if ($item < $max) {
                            $idpromo = $idbonus;
                            $jpromo = 'P';
                            $kpromo  = 'Promo *';
                        } else {
                            $idpromo = '';
                            $kpromo  = '';
                            $jpromo = '';
                        }
                    }
                }
            }
        }

        //tambah mie + toping
        if ($ppnt == "Y") {
            $nppn = ($harga_jual * (10 / 100));
        }
        $cek_sudah_ada = $this->m_order->cek_sudah_ada_promo($kdbrg, $nobukti, $jpromo);
        if ($cek_sudah_ada->num_rows() > 0) {
            $s = $cek_sudah_ada->row_array();
            $jum_beli = $s['qty'];
            $jum_beli_sekarang = $jum_beli + 1;
            $nppn_sekarang = 0;
            $subtot_sekarang = ($harga_jual * $jum_beli_sekarang);

            if ($ppnt == 'Y') {
                $nppn_sekarang = ($subtot_sekarang * (10 / 100));
            }
            $this->db->query("UPDATE tbl_belanja_detail1 SET qty='$jum_beli_sekarang', bruto='$subtot_sekarang',nppn='$nppn_sekarang' 
            WHERE kdbrg='$kdbrg' AND nobukti='$nobukti' AND harga='$harga_jual' AND kdpromo = '$idpromo'");
            redirect('mobile/menu/' . $balik);
        } else {


            $data = array(
                'kdcabang' => $kdtoko,
                'nobukti' => $nobukti,
                'nourut' => $nourut,
                'nama_menu' => $x['menu_nama'] . ' ' . $kpromo,
                'kdpromo' => $idpromo,
                'jpromo' => $jpromo,
                'kdbrg' => $kdbrg,
                'kdbrg1' => $kdbrg1,
                'kdbrg2' => $kdbrg2,
                'qty' => 1,
                'harga' => $harga_jual,
                'bruto' => $harga_jual,
                'nppn' => $nppn,
            );
            $this->db->insert('tbl_belanja_detail1', $data);
        }
        
            $this->db->query("UPDATE tbl_belanja1 SET stat = 0 where nobukti = '$nobukti'");
        redirect('mobile/menu/' . $balik);
    }

    public function add_list_topping_backup()
    {

        //kode topping
        $kdbrg2 = $this->uri->segment(4);
        $balik = $this->uri->segment(5);
        //kode barang mie
        $kdbrg1 = $this->uri->segment(6);

        if ($balik == 'updatecari') {
            $balik = 'updatecari/' . $this->session->userdata('menucari');
            $kdbrg1 = $this->uri->segment(7);
        }

        $kode = $this->uri->segment(4);

        $nobukti = $this->session->userdata('nobukti');
        $kdtoko = $this->session->userdata('cabang');
        $tgl = date('Y-m-d');
        $id_user = $this->session->userdata('ses_username');

        //data mie
        $produk = $this->m_menu->detail_menu1($kdbrg1);
        $x = $produk->row_array();
        $harga_jual = $x['menu_harga_lama'];
        $ppn = $x['ppn'];

        // hapus mie
        if ($ppn == "Y") {
            $nppn = ($harga_jual * (10 / 100));
        }
        $cek_sudah_ada = $this->m_order->cek_sudah_ada($kdbrg1, $nobukti);
        if ($cek_sudah_ada->num_rows() > 0) {
            $s = $cek_sudah_ada->row_array();
            $jum_beli = $s['qty'];
            $jum_beli_sekarang = $jum_beli - 1;

            $subtot_sekarang = ($harga_jual * $jum_beli_sekarang);
            $nppn_sekarang = 0;
            if ($ppn == 'Y') {
                $nppn_sekarang = $subtot_sekarang * (10 / 100);
            }
            $this->db->query("UPDATE tbl_belanja_detail1 SET qty='$jum_beli_sekarang', bruto='$subtot_sekarang',nppn='$nppn_sekarang' 
            WHERE kdbrg='$kdbrg1' AND nobukti='$nobukti'");
            $this->db->query("delete from tbl_belanja_detail1 where qty='0' and kdbrg='$kdbrg1' AND nobukti='$nobukti'");
        }

        //data toping
        $cek_menu_toping = $this->m_order->cek_menu_toping($kdbrg1, $kdbrg2);
        $t = $cek_menu_toping->row_array();
        $kdbrg = $t['menu_id'];
        $produk = $this->m_menu->detail_menu($kdbrg);
        $xt = $produk->row_array();
        $harga_jualt = $xt['menu_harga_lama'];
        $ppnt = $xt['ppn'];
        $nourut = 1;

        //tambah mie + toping
        if ($ppnt == "Y") {
            $nppn = ($harga_jualt * (10 / 100));
        }
        $cek_sudah_ada = $this->m_order->cek_sudah_ada($kdbrg, $nobukti);
        if ($cek_sudah_ada->num_rows() > 0) {
            $s = $cek_sudah_ada->row_array();
            $jum_beli = $s['qty'];
            $jum_beli_sekarang = $jum_beli + 1;
            $nppn_sekarang = 0;
            $subtot_sekarang = ($harga_jualt * $jum_beli_sekarang);
            if ($ppn == 'Y') {
                $nppn_sekarang = ($subtot_sekarang * (10 / 100));
            }
            $this->db->query("UPDATE tbl_belanja_detail1 SET qty='$jum_beli_sekarang', bruto='$subtot_sekarang',nppn='$nppn_sekarang' WHERE kdbrg='$kdbrg' AND nobukti='$nobukti'");
            redirect('mobile/menu/' . $balik);
        } else {
            $data = array(
                'kdcabang' => $kdtoko,
                'nobukti' => $nobukti,
                'nourut' => $nourut,
                'kdbrg' => $kdbrg,
                'kdbrg1' => $kdbrg1,
                'kdbrg2' => $kdbrg2,
                'qty' => 1,
                'harga' => $harga_jualt,
                'bruto' => $harga_jualt,
                'nppn' => $nppn,
            );
            $this->db->insert('tbl_belanja_detail1', $data);
        }
        redirect('mobile/menu/' . $balik);
    }

    public function add_list_order1()
    {
        $kdbrg = $this->uri->segment(4);
        $kode = $this->uri->segment(4);
        $balik = $this->uri->segment(5);
        $tpp = $this->uri->segment(6);

        // jika add barang dari halaman cari
        if ($balik == 'updatecari') {
            $balik = 'updatecari/' . $this->session->userdata('menucari');
            $tpp = $this->uri->segment(7);
        }

        $nobukti = $this->session->userdata('nobukti');
        $kdtoko = $this->session->userdata('cabang');

        $tgl = date('Y-m-d');
        $id_user = $this->session->userdata('ses_username');
        $produk = $this->m_menu->detail_menu($kode);
        $x = $produk->row_array();
        $harga_jual = $x['hargajual'];
        $ppn = $x['ppn'];
        $nourut = 1;
        $nppn = 0;
        $idpromo = '';
        $kpromo  = '';
        $jpromo = '';


        // jika menu mie maka akan muncul topping
        if ($tpp == 'J01' || $tpp == 'J07') {
            $this->session->set_userdata('topping', true);
            $this->session->set_userdata('kdbrgu', $kdbrg);
        } else {
            $this->session->unset_userdata('topping');
            $this->session->unset_userdata('kdbrgu');
        }

        //jika promo coret harga
        $lay = $this->db->query("select layanan,'KH01' kdharga,idpromo,item,jnspromo,promo from tbl_belanja1 where nobukti='$nobukti';");
        $laya = $lay->row_array();
        $layanan = $laya['layanan'];
        $kdharga = $laya['kdharga'];
        $idbonus = $laya['idpromo'];
        $titem = $laya['item'];
        $jnspromo = $laya['jnspromo'];
        $promo = $laya['promo'];

        if ($promo == '2') {
            $kb = $this->db->query("select a.kdbrgbonus,b.id,jnsbonus,a.extrabonus,b.id1 from tabel_menu a
								left join jenismenu b on a.jenisbrg=b.kdjenis
								where a.kode_menu='$kdbrg';");
            $kbo = $kb->row_array();
            $kdbonus = $kbo['kdbrgbonus'];
            $idmenu = $kbo['id'];
            $idmenu1 = $kbo['id1'];
            $jnsbonus = $kbo['jnsbonus'];
            $extrabonus = $kbo['extrabonus'];



            if ($jnspromo == '2') {
                if ($x['maxbonus'] > 0) {
                    if ($x['item'] < $x['maxbonus']) {
                        $harga_jual = $x['newharga'];
                        if ($harga_jual == 0 || null) {
                            $harga_jual = $x['hargajual'];
                            $idpromo = '';
                            $kpromo  = '';
                            $jpromo = '';
                        } else {
                            $idpromo = $x['idpromo'];
                            $kpromo  = 'Promo *';
                            $jpromo = 'P';
                            $this->db->query("UPDATE tbl_belanja1 SET item = item + 1 where nobukti = '$nobukti'");
                        }
                    }
                    if ($x['item'] > $x['maxbonus']) {
                        $harga_jual = $x['hargajual'];
                        $idpromo = '';
                        $kpromo  = '';
                        $jpromo = '';
                    }
                }
            }

            if ($jnspromo == '4') {
                $cbonus = $this->db->query("select * from promoheader where idprogram='$idbonus' and (jnsmenu='$idmenu' or jnsmenu='$idmenu1');");
                $pbonus = $cbonus->row_array();
                if ($cbonus->num_rows() > 0) {
                    $minqtybonus = $pbonus['minqty'];
                    $maxqtybonus = $pbonus['maxbonus'];
                    $perqtybonus = $pbonus['perqty'];
                    if ($x['maxbonus'] > 0) {
                        if ($x['item'] < ($x['maxbonus']) / $perqtybonus) {
                            $idpromo = $idbonus;
                            $jpromo = 'P';
                            $kpromo  = 'Promo *';
                        } else {
                            $idpromo = '';
                            $kpromo  = '';
                            $jpromo = '';
                        }
                    }
                }
            }
        }


        // jika ada ppn
        if ($ppn == "Y") {
            $nppn = ($harga_jual * (10 / 100));
        }

        // jika sudah pesan menu, maka akan edit menu
        $cek_sudah_ada = $this->m_order->cek_sudah_ada_promo($kdbrg, $nobukti, $jpromo);
        if ($cek_sudah_ada->num_rows() > 0) {

            $s = $cek_sudah_ada->row_array();
            $jum_beli = $s['qty'];
            $jum_beli_sekarang = $jum_beli + 1;
            $nppn_sekarang = 0;
            $subtot_sekarang = ($harga_jual * $jum_beli_sekarang);
            if ($ppn == 'Y') {
                $nppn_sekarang = ($subtot_sekarang * (10 / 100));
            }
            $this->db->query("UPDATE tbl_belanja_detail1 SET qty='$jum_beli_sekarang', bruto='$subtot_sekarang',
            nppn='$nppn_sekarang' WHERE kdbrg='$kdbrg' AND nobukti='$nobukti' AND harga='$harga_jual' AND kdpromo = '$idpromo'");
            redirect('mobile/menu/belanja');
        }

        // jika belum pesan menu, makan akan tambah menu
        else {
            $data = array(
                'kdcabang' => $kdtoko,
                'nobukti' => $nobukti,
                'nourut' => $nourut,
                'nama_menu' => $x['menu_nama'] . ' ' . $kpromo,
                'kdpromo' => $idpromo,
                'jpromo' => $jpromo,
                'kdbrg' => $kdbrg,
                'kdbrg1' => $kdbrg,
                'qty' => 1,
                'harga' => $harga_jual,
                'bruto' => $harga_jual,
                'nppn' => $nppn,
            );
            $this->db->insert('tbl_belanja_detail1', $data);
        }


        redirect('mobile/menu/belanja');
    }


    public function delorder()
    {
        $kdbrg = $this->uri->segment(4);
        $kode = $this->uri->segment(4);
        $harga = $this->uri->segment(5);
        $qty = $this->uri->segment(6);
        $nourut = $this->uri->segment(7);
        $qpro = 0;
        $perqyt = 1;
        $jpro = 0;
        $jpromo = '';

        $nobukti = $this->session->userdata('nobukti');
        $kdtoko = $this->session->userdata('cabang');

        $cpro = $this->db->query("select a.idpromo,b.perqty from tbl_belanja1 a 
                                left join promoheader b on a.idpromo=b.idprogram
                                where a.nobukti='$nobukti';");
        $cpp = $cpro->row_array();
        if (!empty($cpp)) {
            $perqty = $cpp['perqty'];
        }



        // cek apakah menu ada promo
        $querycekpromo = $this->db->query("select jpromo from tbl_belanja_detail1 where kdbrg='$kdbrg' AND harga = '$harga' AND nobukti='$nobukti'");
        $cekpromo = $querycekpromo->row_array();
        if (!empty($cekpromo)) {
            $jpromo = $cekpromo['jpromo'];
        }
        $this->db->query("delete from tbl_belanja_detail1 where kdbrg='$kdbrg' AND harga = '$harga' AND nobukti='$nobukti' and nourut='$nourut';;");

        $tpro = $this->db->query("select sum(qty) tqty from tbl_belanja_detail1 where nobukti='$nobukti' and jpromo='P';");
        $dtpro = $tpro->row_array();
        if (!empty($dtpro)) {
            $qpro = $dtpro['tqty'];
        }

        if ($qpro > 0) {
            $jpro = ($qpro / $perqty);
        }

        if ($jpro < 1) {
            $this->db->query("delete from tbl_belanja_detail1 where jpromo='B' AND nobukti='$nobukti';");
        }



        $this->db->query("update tbl_belanja1 set item = item - $qty where nobukti = '$nobukti'");
        $cn = $this->db->query("select sum(bruto+nppn) netto from tbl_belanja_detail1 where nobukti='$nobukti';");
        $cr = $cn->row_array();
        $netto = $cr['netto'];
        if ($netto < 60000) {
            $this->db->query("delete from tbl_belanja_detail1 where nobukti='$nobukti' and kdpromo='077';");
        }


        redirect('mobile/menu/belanja');
    }

    public function delorder1()
    {
        $balik = $this->uri->segment(5);
        if ($balik == 'updatecari') {
            $balik = $this->uri->segment(5) . '/' . $this->session->userdata('menucari');
        }
        $nobukti = $this->session->userdata('nobukti');
        $kdbrg = $this->uri->segment(4);
        $kode = $this->uri->segment(4);
        $qty = $this->uri->segment(6);
        $harga = $this->uri->segment(7);

        $qpro = 0;
        $perqyt = 1;
        $jpro = 0;
        $jpromo = '';

        $cpro = $this->db->query("select a.idpromo,b.perqty from tbl_belanja1 a 
                                left join promoheader b on a.idpromo=b.idprogram
                                where a.nobukti='$nobukti';");
        $cpp = $cpro->row_array();
        if (!empty($cpp)) {
            $perqty = $cpp['perqty'];
        }

        // cek apakah menu ada promo *
        $querycekpromo = $this->db->query("select jpromo from tbl_belanja_detail1 where kdbrg='$kdbrg' AND harga = '$harga' AND nobukti='$nobukti'");
        $cekpromo = $querycekpromo->row_array();
        if (!empty($cekpromo)) {
            $jpromo = $cekpromo['jpromo'];
        }


        $nobukti = $this->session->userdata('nobukti');
        $kdtoko = $this->session->userdata('cabang');

        $this->db->query("delete from tbl_belanja_detail1 where kdbrg='$kdbrg' AND harga = '$harga'  AND nobukti='$nobukti';");

        $tpro = $this->db->query("select sum(qty) tqty from tbl_belanja_detail1 where nobukti='$nobukti' and jpromo='P';");
        $dtpro = $tpro->row_array();
        if (!empty($dtpro)) {
            $qpro = $dtpro['tqty'];
        }
        if ($perqty > 0) {
            $jpro = ($qpro / $perqty);
        }
        if ($jpro < 1) {
            $this->db->query("delete from tbl_belanja_detail1 where jpromo='B' AND nobukti='$nobukti';");
        }
        $this->db->query("update tbl_belanja1 set item = item - $qty where nobukti = '$nobukti'");
        $cn = $this->db->query("select sum(bruto+nppn) netto from tbl_belanja_detail1 where nobukti='$nobukti';");
        $cr = $cn->row_array();
        $netto = $cr['netto'];
        if ($netto < 60000) {
            $this->db->query("delete from tbl_belanja_detail1 where  nobukti='$nobukti' and kdpromo='077';");
        }

        redirect('mobile/menu/' . $balik);
    }

    public function min_list_order()
    {
        $kdbrg1 = $this->uri->segment(6);
        $kdbrg = $this->uri->segment(4);
        $kode = $this->uri->segment(4);
        $nobukti = $this->session->userdata('nobukti');
        $kdtoko = $this->session->userdata('cabang');
        $balik = $this->uri->segment(5);

        if ($balik == 'updatecari') {
            $balik = 'updatecari/' . $this->session->userdata('menucari');
            $kdbrg1 = $this->uri->segment(7);
        }

        $tgl = date('Y-m-d');
        $id_user = $this->session->userdata('ses_username');
        $produk = $this->m_menu->detail_menu($kode);
        $x = $produk->row_array();
        $harga_jual = $x['hargajual'];
        $ppn = $x['ppn'];
        $nourut = 1;
        $nppn = 0;

        if ($kdbrg1 == 'J01' || $kdbrg1 == 'J07') {
            $this->session->set_userdata('phapus', true);
            $this->session->set_userdata('kdbrgu', $kdbrg);
        } else {


            if ($ppn == "Y") {
                $nppn = ($harga_jual * (10 / 100));
            }
            $cek_sudah_ada = $this->m_order->cek_sudah_ada($kdbrg, $nobukti);
            if ($cek_sudah_ada->num_rows() > 0) {
                $s = $cek_sudah_ada->row_array();
                $jum_beli = $s['qty'];
                $jum_beli_sekarang = $jum_beli - 1;

                $subtot_sekarang = ($harga_jual * $jum_beli_sekarang);
                $nppn_sekarang = 0;
                if ($ppn == 'Y') {
                    $nppn_sekarang = $subtot_sekarang * (10 / 100);
                }
                $this->db->query("UPDATE tbl_belanja_detail1 SET qty='$jum_beli_sekarang', bruto='$subtot_sekarang',nppn='$nppn_sekarang' WHERE kdbrg='$kdbrg' AND nobukti='$nobukti'");
                $this->db->query("delete from tbl_belanja_detail1 where qty='0' and kdbrg='$kdbrg' AND nobukti='$nobukti'");
            }
        }

        $cn = $this->db->query("select sum(bruto+nppn) netto from tbl_belanja_detail1 where nobukti='$nobukti';");
        $cr = $cn->row_array();
        $netto = $cr['netto'];
        if ($netto < 60000) {
            $this->db->query("delete from tbl_belanja_detail1 where  nobukti='$nobukti' and kdpromo='077';");
        }
        $this->db->query("UPDATE tbl_belanja1 SET stat = 0 where nobukti = '$nobukti'");

        redirect('mobile/menu/' . $balik);
    }

    public function min_list_order1()
    {
        $kdbrg = $this->uri->segment(4);
        $kode = $this->uri->segment(4);
        $nobukti = $this->session->userdata('nobukti');
        $kdtoko = $this->session->userdata('cabang');
        $jpromo = $this->uri->segment(5);

        $tgl = date('Y-m-d');
        $id_user = $this->session->userdata('ses_username');
        $produk = $this->m_menu->detail_menu($kode);
        $x = $produk->row_array();
        $harga_jual = $x['hargajual'];
        $ppn = $x['ppn'];
        $nourut = 1;
        $nppn = 0;
        if ($ppn == "Y") {
            $nppn = ($harga_jual * (10 / 100));
        }
        $cek_sudah_ada = $this->m_order->cek_sudah_adab($kdbrg, $nobukti, $jpromo);
        if ($cek_sudah_ada->num_rows() > 0) {
            $s = $cek_sudah_ada->row_array();
            $jum_beli = $s['qty'];
            $jum_beli_sekarang = $jum_beli - 1;

            $subtot_sekarang = ($harga_jual * $jum_beli_sekarang);
            $nppn_sekarang = 0;
            if ($ppn == 'Y') {
                $nppn_sekarang = $subtot_sekarang * (10 / 100);
            }
            $this->db->query("UPDATE tbl_belanja_detail1 SET qty='$jum_beli_sekarang', bruto='$subtot_sekarang',nppn='$nppn_sekarang' WHERE kdbrg='$kdbrg' AND nobukti='$nobukti' and nourut='$jpromo';");
            $this->db->query("delete from tbl_belanja_detail1 where qty='0' and kdbrg='$kdbrg' AND nobukti='$nobukti'");
        }
        $cn = $this->db->query("select sum(bruto+nppn) netto from tbl_belanja_detail1 where nobukti='$nobukti';");
        $cr = $cn->row_array();
        $netto = $cr['netto'];
        if ($netto < 60000) {
            $this->db->query("delete from tbl_belanja_detail1 where  nobukti='$nobukti' and kdpromo='077';");
        }
        redirect('mobile/menu/belanja');
    }

    function sukses()
    {
        $this->load->view('mobile/v_pembayaran');
    }
    function cod()
    {
        $no_invoice = $this->session->userdata('no_invoice');
        $this->m_order->set_pembayaran_cod($no_invoice);
        $x['data'] = $this->m_order->get_checkout($no_invoice);

        $this->load->view('mobile/v_invoice', $x);
    }

    function transfer_bank()
    {
        $x['data'] = $this->m_order->get_all_rekening();
        $this->load->view('mobile/v_rekening', $x);
    }

    function set_pembayaran()
    {
        $no_invoice = $this->session->userdata('no_invoice');
        $pem_id = $this->uri->segment(4);
        $d = $this->m_order->get_rekening($pem_id);
        $q = $d->row_array();
        $rek_id = $q['rek_id'];
        $rek_no = $q['rek_no'];
        $rek_bank = $q['rek_bank'];
        $rek_nama = $q['rek_nama'];
        $rek_cabang = $q['rek_cabang'];
        $jnsbayar = $q['jnsbayar'];
        $this->m_order->set_pembayaran_transfer($no_invoice, $rek_id, $rek_no, $rek_bank, $rek_nama, $rek_cabang, $jnsbayar);
        redirect('mobile/menu/cetak_invoice');
    }

    function cetak_invoice()
    {
        $no_invoice = $this->session->userdata('nobukti');
        $x['total'] = 0;
        $x['pb1'] = 0;
        $x['netto'] = 0;
        $x['nota'] = $this->m_order->get_nota($no_invoice)->row();
        $x['data'] = $this->m_order->get_checkout($no_invoice);
        $this->load->view('mobile/v_invoice', $x);
    }

    function lihat_invoice($no_invoice)
    {
        $cek = $this->m_order->get_checkout1($no_invoice);
        $x['total'] = 0;
        $x['pb1'] = 0;


        $x['data'] = $this->m_order->get_checkout1($no_invoice);
        if ($cek->num_rows > 0) {
            $this->load->view('mobile/v_invacc', $x);
        } else {
            $this->load->view('mobile/v_error');
        }
    }
    function lihat_invoicenota()
    {
        $no_invoice = $this->uri->segment(4);
        $cek = $this->m_order->get_checkoutnota($no_invoice);
        $x['total'] = 0;
        $x['pb1'] = 0;


        $x['data'] = $this->m_order->get_checkoutnota($no_invoice);
        if ($cek->num_rows > 0) {
            $this->load->view('mobile/v_invaccnota', $x);
        } else {
            $this->load->view('mobile/v_error');
        }
    }
    function lihat_report()
    {
        $kode = $this->uri->segment(5);
        $tglreport = $this->uri->segment(4);
        $cek = $this->m_order->get_report($tglreport, $kode);
        $x['total'] = 0;
        $x['pb1'] = 0;
        $x['netto'] = 0;
        $x['netto'] = 0;
        $x['total1'] = 0;
        $x['total2'] = 0;
        $x['total3'] = 0;
        $x['total4'] = 0;
        $x['total5'] = 0;
        $x['total6'] = 0;
        $x['total7'] = 0;
        $x['totat8'] = 0;
        $x['total9'] = 0;
        $x['total10'] = 0;
        $x['total11'] = 0;
        $x['total12'] = 0;
        $x['total13'] = 0;
        $x['total14'] = 0;
        $x['total15'] = 0;
        $x['total16'] = 0;
        $x['total17'] = 0;
        $x['total18'] = 0;
        $x['total19'] = 0;
        $x['total20'] = 0;
        $x['no'] = 1;
        $x['data'] = $this->m_order->get_report($tglreport, $kode);
        if ($cek->num_rows > 0) {
            $this->load->view('mobile/v_report', $x);
        } else {
            $this->load->view('mobile/v_error');
        }
    }

    function feedback1($noinvoice)
    {
        $detail = $this->input->post('komentar');
        $comment = $this->input->post('comment');
        $no = $this->input->post('no');
        $feedback = $this->input->post('feedback');
        $this->db->query("update tbl_invoice set feedback = '$feedback', comment='$comment', comment_detail = '$detail' where inv_no = '$no' ");
        redirect('mobile/menu/lihat_invoice/' . $noinvoice);
    }

    function feedback()
    {
        $detail = $this->input->post('komentar');
        $comment = $this->input->post('comment');
        $no = $this->input->post('no');
        $feedback = $this->input->post('feedback');
        $this->db->query("update tbl_invoice set feedback = '$feedback', comment='$comment', comment_detail = '$detail' where inv_no = '$no' ");
        redirect('mobile/menu/cetak_invoice');
    }

    function batal($no)
    {
        $this->db->query("update tbl_invoice set stat = '5', inv_status='Dibatalkan Pelanggan' where inv_no = '$no' ");
        redirect('mobile/member/berhasillogin');
    }

    function printer()
    {
        $this->load->view('mobile/printer');
    }

    public function menuList()
    {
        // POST data
        $postData = $this->input->post();

        // GET data
        $data = $this->m_menu->menuCari($postData);

        echo json_encode($data);
    }

    function pilihorder()
    {
        $x['slide'] = $this->m_menu->slideorder();
        $x['slide1'] = $this->m_menu->slideself();
        $this->load->view('mobile/v_pilihorder', $x);
    }

    function selfslider()
    {
        $x['slide'] = $this->m_menu->slideself();
        $this->load->view('mobile/v_selfslider', $x);
    }

    function selforder()
    {
        //cek login
        if (!$this->session->userdata('pengguna')) {
            redirect('');
        }
        $type    = $this->input->post('typeorder');
        $namanya = $this->input->post('nama');
        $nomornya = $this->input->post('notelp');
        $this->session->set_userdata('nama_pelanggan', $namanya);
        $this->session->set_userdata('notelp_pelanggan', $nomornya);


        // 		$kdtoko=$this->uri->segment(4);
        $kdtoko = $this->session->userdata('kdkedai');
        if ($kdtoko == null) {
            $kdcust = $this->session->userdata('kopel');
            $cust = $this->db->query("select * from tbl_pelanggan where plg_id='$kdcust'");
            if ($cust->num_rows > 0) {
                $kp = $cust->row_array();
                $kdtoko = $kp['kdcabang'];
            }
        }
        $lat = "1";
        $lng = "1";
        $aa = $this->db->query("select * from tabel_toko where kd_toko='$kdtoko';");
        $ab = $aa->row_array();
        $x['toko'] = $ab['nm_toko'];
        $x['kdtoko'] = $kdtoko;
        $x['alamat'] = $ab['almt_toko'];
        $this->session->set_userdata('cabang', $kdtoko);
        $this->session->set_userdata('nm_toko', $ab['nm_toko']);

        $u = $this->session->userdata('telepon');
        $kodepel = $this->m_pelanggan->upd_pelanggann($u, $kdtoko, $type, $lat, $lng);
        $this->session->set_userdata('typeorder', $type);
        $this->session->set_userdata('kdcabang', $kdtoko);
        $kdcabang = $kdtoko;
        $no_invoice = $this->m_order->get_invoice($kdcabang);
        $this->session->set_userdata('no_invoice', $no_invoice);
        $this->session->set_userdata('nobukti', $no_invoice);
        $order_proses = $this->m_order->order_produk1($no_invoice);
        $update = $this->db->query("update tbl_belanja1 set custname='$namanya',notelp='$nomornya' where nobukti = '$no_invoice'");

        $tgl = date('Y-m-d');
        //cari promo
        $hrr = date('w', strtotime("$tgl"));
        $wkt = date('H:i:s');
        $ses_promo = '';
        $this->session->set_userdata('promo', $ses_promo);
        $querypromo = $this->db->query("SELECT a.disc1,a.ndisc1,a.idprogram,a.nobukti,a.jnsdisc,a.jnspromo,a.jnsmenu,a.maxbonus FROM promoheader a
								LEFT JOIN promoarea b ON a.nobukti=b.nobukti
								WHERE a.stat='1' AND a.tglawal<='$tgl' AND a.tglakhir>='$tgl' and stpromo='1'  and a.hari like '%$hrr%' and jamawal<='$wkt' and jamakhir>='$wkt'
								AND (a.jnslayanan='$type' or a.jnslayanan1='$type' or a.jnslayanan2='$type') AND b.kdwil='$kdtoko' AND a.eorder = 2;");
        $rowpromo = $querypromo->row_array();

        if (!empty($rowpromo)) {
            $disc1 = $rowpromo['disc1'];
            $diskon = $rowpromo['ndisc1'];
            $idprogram = $rowpromo['idprogram'];
            $noprogram = $rowpromo['nobukti'];
            $jnsdisc = $rowpromo['jnsdisc'];
            $jnspromo = $rowpromo['jnspromo'];
            $jnsmenu = $rowpromo['jnsmenu'];
            $maxbonus = $rowpromo['maxbonus'];
            $jpromo = "P";
            $this->session->set_userdata('promo', $idprogram);
            $update = $this->db->query("update tbl_belanja1 set promo = '2', idpromo = '$idprogram',jnspromo ='$jnsdisc',  maxbonus = '$maxbonus' where nobukti = '$no_invoice'");
        }

        redirect('mobile/menu/favorit', 'refresh');
    }
}