public function my()
    {
        $cartModel = new CartModel();
        $id = Account::getMyID();
        if (Role::hasRole('admin')) {
            if ($_GET['id'] != "") {
                $id = addslashes($_GET['id']);
            }
        }
        if ($id < 1) {
            die('Err');
        }
        //paymentstatus != deleted
        $arr = $cartModel->getWhere("userid = '{$id}' AND payment_status != 4 ORDER BY po_date DESC");
        // pr($arr);
        ?>
<h1 class="beli" style="padding-bottom: 30px;">Order History</h1>
<div class="table-responsive">
<table class="table table-bordered">
    <thead>
        <tr>
            <th>Tanggal</th>
            <th>Value</th>
            <th>Action</th>
            <th>Status</th>
            <th>Action</th>
        </tr>
    </thead>
        <?php 
        foreach ($arr as $cartModel) {
            ?>
    <tr>
        <td><?php 
            echo indonesian_date($cartModel->po_date);
            ?>
</td>
        <td style="text-align: right;">Rp.<?php 
            echo rupiah($cartModel->total_cost);
            ?>
</td>
        <td>
            <a target="blank" href="<?php 
            echo _SPPATH;
            ?>
cartorder/details?po=<?php 
            echo $cartModel->po_id;
            ?>
">lihat details</a><br>
            <a target="blank" href="<?php 
            echo _SPPATH;
            ?>
ordersuccesspage?po=<?php 
            echo $cartModel->po_id;
            ?>
">cara pembayaran</a>
        </td>
        <td><?php 
            echo $this->arrStatus[$cartModel->payment_status];
            ?>
</td>
        <td>
            <?php 
            if ($cartModel->payment_status == 0) {
                ?>
            <button onclick="if(confirm('Delete PO Anda ?'))document.location='<?php 
                echo _SPPATH;
                ?>
CartOrder/deleteOrder?po=<?php 
                echo $cartModel->po_id;
                ?>
';">Delete Order</button>
            <?php 
            }
            ?>
        </td>
    </tr>
            <?php 
        }
        ?>
</table>
</div>
         <?php 
    }
    public function CreatePO()
    {
        $cartModel = new CartModel();
        $c = new CartOrder();
        //set ps
        $payment_status = isset($_GET['ps']) ? addslashes($_GET['ps']) : '0';
        $ps_text = "payment_status = '{$payment_status}'";
        if ($payment_status == '100') {
            $ps_text = "userid != ''";
        }
        //sort
        $sort = isset($_GET['sort']) ? addslashes($_GET['sort']) : 'po_date DESC,payment_status ASC';
        $arr = $cartModel->getWhere("{$ps_text} ORDER BY {$sort} ");
        $sortweb = urlencode($sort);
        // pr($arr);
        ?>
<style>
    .pointer{
        cursor: pointer;
    }
    .status_0{
        color:white;
        padding: 10px;
        background-color: red;
    }
    .status_1{
        color:white;
        padding: 10px;
        background-color:orange;
    }
    .status_2{
        color:white;
        padding: 10px;
        background-color:green;
    }
    
</style>
<div style="float: right;">
    <select id="payment_select">
    <?php 
        foreach ($c->arrStatus as $num => $ob) {
            $slc = "";
            if ($num == $payment_status) {
                $slc = "selected";
            }
            ?>
        <option <?php 
            echo $slc;
            ?>
 value="<?php 
            echo $num;
            ?>
"><?php 
            echo $ob;
            ?>
</option>
    <?php 
        }
        $slc = "";
        if ($payment_status == '100') {
            $slc = "selected";
        }
        ?>
        <option <?php 
        echo $slc;
        ?>
 value="100">all</option>
    </select>
    <script>
    $('#payment_select').change(function(){
        var slc = $('#payment_select').val();
        openLw('PO_Management','<?php 
        echo _SPPATH;
        ?>
CustomPO/CreatePO?sort=<?php 
        echo $sortweb;
        ?>
&ps='+slc,'fade');
    });    
    </script>
</div>
<h1 class="beli" style="padding-bottom: 30px;">Order History</h1>
        
<table class="table table-bordered">
    <thead>
        <tr>
            <th >
                Tanggal
                <i onclick="openLw('PO_Management','<?php 
        echo _SPPATH;
        ?>
CustomPO/CreatePO?ps=<?php 
        echo $payment_status;
        ?>
&sort=po_date%20ASC','fade');" class="glyphicon glyphicon-arrow-up pointer"></i>
                <i onclick="openLw('PO_Management','<?php 
        echo _SPPATH;
        ?>
CustomPO/CreatePO?ps=<?php 
        echo $payment_status;
        ?>
&sort=po_date%20DESC','fade');" class="glyphicon glyphicon-arrow-down pointer"></i>
            
            </th>
            <th>
                Order ID
                <i onclick="openLw('PO_Management','<?php 
        echo _SPPATH;
        ?>
CustomPO/CreatePO?ps=<?php 
        echo $payment_status;
        ?>
&sort=po_id%20ASC','fade');" class="glyphicon glyphicon-arrow-up pointer"></i>
                <i onclick="openLw('PO_Management','<?php 
        echo _SPPATH;
        ?>
CustomPO/CreatePO?ps=<?php 
        echo $payment_status;
        ?>
&sort=po_id%20DESC','fade');" class="glyphicon glyphicon-arrow-down pointer"></i>
            
            </th>
            <th>User ID
            <i onclick="openLw('PO_Management','<?php 
        echo _SPPATH;
        ?>
CustomPO/CreatePO?ps=<?php 
        echo $payment_status;
        ?>
&sort=userid%20ASC','fade');" class="glyphicon glyphicon-arrow-up pointer"></i>
                <i onclick="openLw('PO_Management','<?php 
        echo _SPPATH;
        ?>
CustomPO/CreatePO?ps=<?php 
        echo $payment_status;
        ?>
&sort=userid%20DESC','fade');" class="glyphicon glyphicon-arrow-down pointer"></i>
            
            </th>
            <th>
                Email
                <i onclick="openLw('PO_Management','<?php 
        echo _SPPATH;
        ?>
CustomPO/CreatePO?ps=<?php 
        echo $payment_status;
        ?>
&sort=user_email%20ASC','fade');" class="glyphicon glyphicon-arrow-up pointer"></i>
                <i onclick="openLw('PO_Management','<?php 
        echo _SPPATH;
        ?>
CustomPO/CreatePO?ps=<?php 
        echo $payment_status;
        ?>
&sort=user_email%20DESC','fade');" class="glyphicon glyphicon-arrow-down pointer"></i>
            
            </th>
            <th>
                Value
                <i onclick="openLw('PO_Management','<?php 
        echo _SPPATH;
        ?>
CustomPO/CreatePO?ps=<?php 
        echo $payment_status;
        ?>
&sort=total_cost%20ASC','fade');" class="glyphicon glyphicon-arrow-up pointer"></i>
                <i onclick="openLw('PO_Management','<?php 
        echo _SPPATH;
        ?>
CustomPO/CreatePO?ps=<?php 
        echo $payment_status;
        ?>
&sort=total_cost%20DESC','fade');" class="glyphicon glyphicon-arrow-down pointer"></i>
            
            </th>
            <th>
                Action
            </th>
            <th>
                Status
                <i onclick="openLw('PO_Management','<?php 
        echo _SPPATH;
        ?>
CustomPO/CreatePO?ps=<?php 
        echo $payment_status;
        ?>
&sort=payment_status%20ASC','fade');" class="glyphicon glyphicon-arrow-up pointer"></i>
                <i onclick="openLw('PO_Management','<?php 
        echo _SPPATH;
        ?>
CustomPO/CreatePO?ps=<?php 
        echo $payment_status;
        ?>
&sort=payment_status%20DESC','fade');" class="glyphicon glyphicon-arrow-down pointer"></i>
            
            </th>
            <th>
                Note
                <i onclick="openLw('PO_Management','<?php 
        echo _SPPATH;
        ?>
CustomPO/CreatePO?ps=<?php 
        echo $payment_status;
        ?>
&sort=po_note%20ASC','fade');" class="glyphicon glyphicon-arrow-up pointer"></i>
                <i onclick="openLw('PO_Management','<?php 
        echo _SPPATH;
        ?>
CustomPO/CreatePO?ps=<?php 
        echo $payment_status;
        ?>
&sort=po_note%20DESC','fade');" class="glyphicon glyphicon-arrow-down pointer"></i>
            
            </th>
        </tr>
    </thead>
        <?php 
        foreach ($arr as $cartModel) {
            ?>
    <tr>
        <td><?php 
            echo indonesian_date($cartModel->po_date);
            ?>
</td>
        <td><?php 
            echo $cartModel->po_id;
            ?>
</td>
        <td><a target="_blank" href="<?php 
            echo _SPPATH;
            ?>
myorder?id=<?php 
            echo $cartModel->userid;
            ?>
"><?php 
            echo $cartModel->userid;
            ?>
</a></td>
        <td><a target="_blank" href="<?php 
            echo _SPPATH;
            ?>
myorder?id=<?php 
            echo $cartModel->userid;
            ?>
"><?php 
            echo $cartModel->user_email;
            ?>
</a></td>
        <td style="text-align: right;">Rp.<?php 
            echo rupiah($cartModel->total_cost);
            ?>
</td>
        <td>
            <a target="_blank" href="<?php 
            echo _SPPATH;
            ?>
cartorder/details?po=<?php 
            echo $cartModel->po_id;
            ?>
">lihat detil</a><br>
            <a target="_blank" href="<?php 
            echo _SPPATH;
            ?>
ordersuccesspage?po=<?php 
            echo $cartModel->po_id;
            ?>
">cara pembayaran</a><br>
        </td>
        <td>
            <div class="status_<?php 
            echo $cartModel->payment_status;
            ?>
">
            <?php 
            echo $c->arrStatus[$cartModel->payment_status];
            ?>
            </div>
            <select id="set_status_<?php 
            echo $cartModel->po_id;
            ?>
">
            <?php 
            foreach ($c->arrStatus as $num => $stat) {
                $slc = "";
                if ($num == $cartModel->payment_status) {
                    $slc = "selected";
                }
                ?>
            <option <?php 
                echo $slc;
                ?>
 value="<?php 
                echo $num;
                ?>
"><?php 
                echo $stat;
                ?>
</option>
            <?php 
            }
            ?>
            </select>
            <script>
              $('#set_status_<?php 
            echo $cartModel->po_id;
            ?>
').change(function(){
                    var slc = $('#set_status_<?php 
            echo $cartModel->po_id;
            ?>
').val();
                    if(slc == '3'){
                        if(confirm('Ini akan me release stok ke pasar bebas lagi..?')){
                            $.get('<?php 
            echo _SPPATH;
            ?>
CustomPO/setStatus?po=<?php 
            echo $cartModel->po_id;
            ?>
&ps='+slc,function(data){
                                lwrefresh('PO_Management');
                            });            
                        }   
                    }else{
                         $.get('<?php 
            echo _SPPATH;
            ?>
CustomPO/setStatus?po=<?php 
            echo $cartModel->po_id;
            ?>
&ps='+slc,function(data){
                                lwrefresh('PO_Management');
                            });
                    }
                });      
            </script>
        </td>
        <td>
            <textarea id="note_<?php 
            echo $cartModel->po_id;
            ?>
"><?php 
            echo $cartModel->po_note;
            ?>
</textarea><br>
            <button id="submitnote_<?php 
            echo $cartModel->po_id;
            ?>
">update note</button>
            <script>
            $('#submitnote_<?php 
            echo $cartModel->po_id;
            ?>
').click(function(){
                var slc = $('#note_<?php 
            echo $cartModel->po_id;
            ?>
').val();
                $.post('<?php 
            echo _SPPATH;
            ?>
CustomPO/setNote?po=<?php 
            echo $cartModel->po_id;
            ?>
',{note:slc},function(data){
                    if(data.bool){
                        alert('Sukses');
                    }else{
                        alert('Gagal');
                    }
                },'json');
            });
            </script>
        </td>
    </tr>  
            <?php 
        }
        ?>
</table>     
         <?php 
    }