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

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

class WigsProduceCtrl{
    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 `id`,`order_barcode`,`goods_no`,`goods_info`,`worker`,`allot_time`';
        $sql .= ' FROM `app_wigs_produce`';
        $sql .= " ORDER BY `id` DESC LIMIT {$offset},$pnsn;";
        $query = $this->db->querySql($sql);
        
        $line = "";
        while($item = $this->db->queryRs($query)) { 
            $line .= '<div class="list_block">';
            $line .= "<span class=\"order_id\">{$item['id']}</span>";
            $line .= "<span class=\"order_barcode\" title=\"{$item['order_barcode']}\">{$item['order_barcode']}</span>";
            $line .= "<span class=\"goods_no\">{$item['goods_no']}</span>";
            $line .= "<span class=\"goods_info\" title=\"{$item['goods_info']}\">{$item['goods_info']}</span>";
            $line .= "<span class=\"worker\">{$item['worker']}</span>";
            $line .= "<span class=\"allot_time\">{$item['allot_time']}</span>";
            $line .= '</div>';
        }
        return $line;
    }
    
    public function searchOrders(){
    	$sql = 'SELECT `id`,`order_barcode`,`goods_no`,`goods_info`,`worker`,`allot_time`';
    	$sql .= ' FROM `app_wigs_produce`';
    	$sql .= ' WHERE 1=1';
        if(isset($_GET['code']) && !empty($_GET['code'])){
            $code = $this->common->my_filter_input($_GET['code']);
            $sql .= " AND `order_barcode`='{$code}' OR `goods_no`='{$code}';";
        }
        
        $query = $this->db->querySql($sql);
        $line = "";
        while($item = $this->db->queryRs($query)) {
            $line .= '<div class="list_block">';
            $line .= "<span class=\"order_id\">{$item['id']}</span>";
            $line .= "<span class=\"order_barcode\" title=\"{$item['order_barcode']}\">{$item['order_barcode']}</span>";
            $line .= "<span class=\"goods_no\">{$item['goods_no']}</span>";
            $line .= "<span class=\"goods_info\" title=\"{$item['goods_info']}\">{$item['goods_info']}</span>";
            $line .= "<span class=\"worker\">{$item['worker']}</span>";
            $line .= "<span class=\"allot_time\">{$item['allot_time']}</span>";
            $line .= '</div>';
        }
        if(!empty($line)){
            return $line;
        }else{
            return -1;
        }
    }
    
    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 `id` FROM `app_wigs_produce`";
        $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', '150', '300');
        for($i=0; $i<4; $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 allotNew(){
    	if(!isset($_POST['barcode']) || empty($_POST['barcode'])){
    		return false;
    	}else{
    		$barcode = $_POST['barcode'];
    		$worker = $_POST['worker'];
    	}
    	
    	$sql = "SELECT `goods_no`,`goods_info` FROM `app_wigsout` WHERE `order_barcode`='{$barcode}';";
    	$query = $this->db->querySql($sql);
    	$rs = $this->db->queryRs($query);
    	
    	if(empty($rs)){
    		return -1;
    	}
    	$sql = "INSERT INTO `app_wigs_produce`(`order_barcode`,`goods_no`,`goods_info`,`worker`) VALUES ('{$barcode}','{$rs['goods_no']}','{$rs['goods_info']}','{$worker}');";
    	if(!($this->db->querySql($sql))){
    		return -2;
    	}else{
    		return 1;
    	}
    }
    
    public function __destruct(){
        //TODO
    }
}