db = new MdbLib();
$this->common = new CommonLib();
}
public function getGoods(){
$pnsnyz = isset($_POST['pnsnyz'])?$this->common->my_filter_input($_POST['pnsnyz']):15;
$now = isset($_POST['now'])?$this->common->my_filter_input($_POST['now']):1;
$offset = ($now-1)*$pnsnyz;
$sql = "SELECT `id`,`use`,`color`,`model`,`length`,`curvature`,`density`,`print_num`,`print_times`,`delivery_date` FROM `app_wigsstockup_yz` ORDER BY `id` DESC LIMIT {$offset},{$pnsnyz};";
$query = $this->db->querySql($sql);
$line = "";
while($item = $this->db->queryRs($query)) {
if($item['print_times'] == 0){
$print_status = "未打印";
$print_clazz = 'no';
}else{
$print_status = "已打印";
$print_clazz = 'ok2';
}
$goods_info = "{$item['use']} {$item['model']} {$item['length']} {$item['curvature']} {$item['color']} {$item['density']}";
$line .= "";
$line .= "{$item['id']}";
$line .= "{$goods_info}";
$line .= "{$item['print_num']}";
$line .= "{$item['delivery_date']}";
$line .= "{$print_status}";
$line .= '';
$line .= "";
$line .= '
';
}
return $line;
}
public function pagination(){
if(!isset($_POST['wh'])){
return false;
}else{
$wh = $this->common->my_filter_input($_POST['wh']);
$pnsnyz = isset($_POST['pnsnyz'])?$this->common->my_filter_input($_POST['pnsnyz']):15;
}
$sql = "SELECT `id` FROM `app_wigsstockup_yz`;";
$query = $this->db->querySql($sql);
$total = $this->db->queryNum($query);
if($total == 0){
$num = '0';
}else{
$num = ceil($total/$pnsnyz);
$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';
}
$pagination .= "".$i."";
}
}
$pagination .= ($num>10)?">>":'';
}
$pagination .= "展示 记录";
return $pagination;
}
public function addStock(){
if(isset($_POST['form']) && !empty($_POST['form'])){
$insert = '(';
foreach($_POST['form'] as $val){
$insert .= "'{$this->common->my_filter_input($val)}',";
}
$insert .= '0)';
}else{
return false;
}
$sql = "INSERT INTO `app_wigsstockup_yz` (`use`,`curvature`,`model`,`length`,`color`,`density`,`print_num`,`delivery_date`,`print_times`) VALUES {$insert};";
if($this->db->querySql($sql)){
return 1;
}else{
return -1;
}
}
public function updatePrint(){
if(isset($_POST['id']) && !empty($_POST['id'])){
$id = $this->common->my_filter_input($_POST['id']);
}else{
return false;
}
$sql = "UPDATE `app_wigsstockup_yz` SET `print_times`=`print_times`+1 WHERE `id`='{$id}';";
if($this->db->querySql($sql)){
return 1;
}else{
return -1;
}
}
public function printAll(){
$sql = 'SELECT `use`,`color`,`model`,`length`,`curvature`,`density`,`print_num` FROM `app_wigsstockup_yz` WHERE `print_times`=0;';
$query = $this->db->querySql($sql);
$rs = $this->db->queryRsAll($query);
if(empty($rs)){
return -1;
}else{
$sql_update = 'UPDATE `app_wigsstockup_yz` SET `print_times`=`print_times`+1 WHERE `print_times`=0;';
$query_update = $this->db->querySql($sql_update);
$str = '';
foreach($rs as $val){
for($i=0; $i<$val['print_num']; $i++){
$str .= '';
$str .= $val['use'].' '.$val['model'].' '.$val['length'].' '.$val['curvature'].' '.$val['color'].' '.$val['density'].'
';
}
}
return $str;
}
}
public function __destruct(){
//TODO
}
}