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 .= '';
$line .= "{$item['id']}";
$line .= "{$item['order_barcode']}";
$line .= "{$item['goods_no']}";
$line .= "{$item['goods_info']}";
$line .= "{$item['worker']}";
$line .= "{$item['allot_time']}";
$line .= '
';
}
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 .= '';
$line .= "{$item['id']}";
$line .= "{$item['order_barcode']}";
$line .= "{$item['goods_no']}";
$line .= "{$item['goods_info']}";
$line .= "{$item['worker']}";
$line .= "{$item['allot_time']}";
$line .= '
';
}
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 = '共 '.$num.' 页';
if($num > 1){
$pagination .= ($num>10)?"<<":'';
$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 .= "".$i."";
}
}
$pagination .= ($num>10)?">>":'';
}
$pagination .= "展示 记录";
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
}
}