saoma.xchuicheng.com/application/controller/TrackCtrl.php

<?php

require_once 'trdLibrary/PHPExcel/PHPExcel.php';
require_once 'library/mdb.php';
require_once 'library/common.php';

class TrackCtrl{
    public function __construct(){
        $this->db = new MdbLib();
        $this->common = new CommonLib();
    }

    public function getOrders(){
        if(!isset($_GET['now'])){
            return false;
        }else{
            $now = $this->common->my_filter_input($_GET['now']);
            $pnsn = isset($_GET['pnsn'])?$this->common->my_filter_input($_GET['pnsn']):15;
        }
        
        $offset = ($now-1)*$pnsn;
        $sql = 'SELECT `oid`,`order_barcode`,`order_status`,`out_time`,`in_time`,`print_times`,`print_date`';
        $sql .= " FROM `app_track` ORDER BY `oid` DESC LIMIT {$offset},$pnsn;";
        $query = $this->db->querySql($sql);
        
        $line = "";
        while($item = $this->db->queryRs($query)) {
            if($item['order_status'] == '2'){
                $order_status = "已入库";
                $in_time = $item['in_time'];
                $out_time = '暂无';
                $class = 'ok1';
            }elseif($item['order_status'] == '5'){
                $order_status = "未入库";
                $in_time = '暂无';
                $out_time = '暂无';
                $class = 'no';
            }elseif($item['order_status'] == '3'){
                $order_status = "已出库";
                $in_time = $item['in_time'];
                $out_time = $item['out_time'];
                $class = 'ok2';
            }
            
            if($item['print_times'] == 0){
                $print_status = "未打印";
                $print_clazz = 'no';
            }else{
                $print_status = "已打印";
                $print_clazz = 'ok2';
            }
            
            $line .= '<div class="list_block">';
            $line .= "<span class=\"order_id\">{$item['oid']}</span>";
            $line .= "<span class=\"order_barcode\" title=\"{$item['order_barcode']}\">{$item['order_barcode']}</span>";
            $line .= "<span class=\"order_status {$class}\">{$order_status}</span>";
            $line .= "<span class=\"in_time\">{$in_time}</span>";
            $line .= "<span class=\"out_time\">{$out_time}</span>";
            $line .= "<span class=\"print_status {$print_clazz}\" title=\"{$print_status}\">{$print_status}</span>";
            $line .= "<span class=\"print_date\">{$item['print_date']}</span>";
            $line .= '<span class="options">';
            $line .= "<input type=\"button\" class=\"print_bc\" data-id=\"{$item['oid']}\" value=\"打印\">";
            $line .= '</span></div>';
        }
        return $line;
    }
    
    public function searchOrders(){
        $sql = 'SELECT `oid`,`order_barcode`,`order_status`,`out_time`,`in_time`,`print_times`,`print_date` ';
        $sql .= 'FROM `app_track` ';
        if(isset($_GET['code'])){
            $code = $this->common->my_filter_input($_GET['code']);
            $sql .= "WHERE `order_barcode`='{$code}';";
        }
        $query = $this->db->querySql($sql);
        
        $line = "";
        while($item = $this->db->queryRs($query)) {
            if($item['order_status'] == '2'){
                $order_status = "已入库";
                $in_time = $item['in_time'];
                $out_time = '暂无';
                $class = 'ok1';
            }elseif($item['order_status'] == '5'){
                $order_status = "未入库";
                $in_time = '暂无';
                $out_time = '暂无';
                $class = 'no';
            }elseif($item['order_status'] == '3'){
                $order_status = "已出库";
                $in_time = $item['in_time'];
                $out_time = $item['out_time'];
                $class = 'ok2';
            }
            
            if($item['print_times'] == 0){
                $print_status = "未打印";
                $print_clazz = 'no';
            }else{
                $print_status = "已打印";
                $print_clazz = 'ok2';
            }
            
            $line .= '<div class="list_block">';
            $line .= "<span class=\"order_id\">{$item['oid']}</span>";
            $line .= "<span class=\"order_barcode\" title=\"{$item['order_barcode']}\">{$item['order_barcode']}</span>";
            $line .= "<span class=\"order_status {$class}\">{$order_status}</span>";
            $line .= "<span class=\"in_time\">{$in_time}</span>";
            $line .= "<span class=\"out_time\">{$out_time}</span>";
            $line .= "<span class=\"print_status {$print_clazz}\" title=\"{$print_status}\">{$print_status}</span>";
            $line .= "<span class=\"print_date\">{$item['print_date']}</span>";
            $line .= '<span class="options">';
            $line .= "<input type=\"button\" class=\"print_bc\" data-id=\"{$item['oid']}\" value=\"打印\">";
            $line .= '</span></div>';
        }
        if(!empty($line)){
            return $line;
        }else{
            return -1;
        }
    }
    
    public function updateOrder(){
        if(isset($_GET['code']) && !empty($_GET['code']) && isset($_GET['status']) && !empty($_GET['status'])){
            $code = $this->common->my_filter_input($_GET['code']);
            $order_status = $this->common->my_filter_input($_GET['status']);
        }else{
            return false;
        }
        
        $sql_status = "SELECT `order_status`,`out_time`,`in_time`,`update_time` FROM `app_track` WHERE `order_barcode`='{$code}' ORDER BY `oid` DESC;";
        $query = $this->db->querySql($sql_status);
        $arr_status = $this->db->queryRsAll($query);
        if(empty($arr_status)){
            return json_encode(array(
                'no' => '-10'
            ));
        }
        
        $now = date("Y-m-d H:i:s", time());
        $sql = "UPDATE `app_track` SET `order_status`='{$order_status}',`in_time`='{$now}',`out_time`='{$now}' WHERE `order_barcode`='{$code}';";
        if($arr_status[0]['order_status'] == 5 && $order_status == 2){
            $this->db->querySql($sql);
            if($this->db->queryAR() == 1){
                return json_encode(array(
                    'no' => '1'
                ));
            }else{
                return json_encode(array(
                    'no' => '-1'
                ));
            }
        }elseif($arr_status[0]['order_status'] == 2 && $order_status == 3){
            $this->db->querySql($sql);
            if($this->db->queryAR() == 1){
                return json_encode(array(
                    'no' => '2'
                ));
            }else{
                return json_encode(array(
                    'no' => '-2'
                ));
            }
        }elseif($arr_status[0]['order_status'] == 5 && $order_status == 3){
            return json_encode(array(
                'no' => '-4'
            ));
        }elseif($arr_status[0]['order_status'] == 2 && $order_status == 2){
            return json_encode(array(
                'no' => '-5',
                'time' => $arr_status[0]['in_time'],
            ));
        }elseif($arr_status[0]['order_status'] == 3 && $order_status == 2){
            return json_encode(array(
                'no' => '-6',
                'time' => $arr_status[0]['out_time'],
            ));
        }elseif($arr_status[0]['order_status'] == 3 && $order_status == 3){
            return json_encode(array(
                'no' => '-7',
                'time' => $arr_status[0]['out_time'],
            ));
        }else{
            return json_encode(array(
                'no' => '-11'
            ));
        }
    }
    
    public function pagination(){
        if(!isset($_GET['wh'])){
            return false;
        }else{
            $wh = $this->common->my_filter_input($_GET['wh']);
            $pnsn = isset($_GET['pnsn'])?$this->common->my_filter_input($_GET['pnsn']):15;
        }
        
        $sql = "SELECT `oid` FROM `app_track`;";
        $query = $this->db->querySql($sql);
        $total = $this->db->queryNum($query);
        
        if($total == 0){
            $num = '0';
        }else{
            $num = ceil($total/$pnsn);
            $wh_max = ceil($num/10);
        }
        
        $direction = substr($wh, 0, 1);
        $wh = substr($wh, 1);
        if($direction == 'h'){
            $whh = ($wh==0)?'0':$wh-1;
            $wht = ($wh==0)?'1':$wh;
        }elseif($direction == 't'){
            $whh = ($wh==$wh_max)?($wh-1):$wh;
            $wht = ($wh==$wh_max)?$wh:($wh+1);
        }else{
            $whh = '0';
            $wht = '1';
        }
                
        $pagination = '<span class="total_page" data-ttpg="'.$num.'">共&nbsp;'.$num.'&nbsp;页</span>';
        if($num > 1){
            $pagination .= ($num>10)?"<span class=\"gtlt head\" data-wh=\"h{$whh}\">&lt;&lt;</span>":'';
            $clazz = '';
            for($i=1+$whh*10; $i<=10+$whh*10; $i++){
                if($i > $num){
                    break;
                }else{
                    if($i != 1+$whh*10){
                        $clazz = 'page';
                    }else{
                        $clazz = 'page pn';
                    }
                    $param = "&now={$i}&pnsn={$pnsn}";
                    $pagination .= "<span class=\"{$clazz}\" onclick=\"getOFP('{$param}')\">".$i."</span>";
                }
            }
            $pagination .= ($num>10)?"<span class=\"gtlt tail\" data-wh=\"t{$wht}\">&gt;&gt;</span>":'';
        }
        $pagination .= "<span>展示 <select class=\"pnsn\">";
        $pns = array('15', '50', '100', '250', '500');
        for($i=0; $i<5; $i++){
            if($pnsn == $pns[$i]){
                $s = 'selected="selected"';
            }else{
                $s = '';
            }
            $pagination .= "<option value=\"{$pns[$i]}\" {$s}>{$pns[$i]}条</option>";
        }
        $pagination .= "</select> 记录</span>";
        return $pagination;
    }
    
    public function updatePrint(){
        if(isset($_POST['oid']) && !empty($_POST['oid'])){
            $oid = $this->common->my_filter_input($_POST['oid']);
        }else{
            return false;
        }
        
        $time_now = date("Y-m-d H:i:s", time());
        $sql = "UPDATE `app_track` SET `print_times`=`print_times`+1,`print_date`='{$time_now}' WHERE `oid`='{$oid}';";
        if($this->db->querySql($sql)){
            return 1;
        }else{
            return -1;
        }
    }
    
    public function printAll(){
        $sql = 'SELECT `order_barcode` FROM `app_track` WHERE `print_times`=0 ORDER BY `in_time`;';
        $query = $this->db->querySql($sql);
        $rs = $this->db->queryRsAll($query);
        if(empty($rs)){
            return -1;
        }else{
			$time_now = date("Y-m-d H:i:s", time());
            $sql_update = "UPDATE `app_track` SET `print_times`=`print_times`+1,`print_date`='{$time_now}',`order_status`=2 AND `print_times`=0;";
            $query_update = $this->db->querySql($sql_update);
            $arr = array();
            foreach($rs as $val){
            	$arr[] = array(
            			'barcode' => $val['order_barcode']
            	);
            }
            return json_encode($arr);
        }
    }
    
    public function createNew(){
        $now = time();
        $order_barcode = strtoupper('GSN-'.date('ymd', $now).substr(hash('md5', $now), rand(0, 28), 4));
        $sql = "INSERT INTO `app_track` (`order_barcode`) VALUES ('{$order_barcode}');";
        $query = $this->db->querySql($sql);
        if($this->db->queryErrno() == 0){
            return 1;
        }else{
            return -1;
        }
    }
    
    public function __destruct(){
        //TODO
    }
}