';
}
}
$info_list[$key]['time'] = trim($info_list[$key]['time'],'
');
}
$total = $this->systemtransfer->find_count($where);
$pagenum = ceil($total/$perpage);
$over = $total-($start+$perpage);
$exdata = 0;
$count = $this->systemtransfer->find_all($where);
foreach ($count as $v)
{
$exdata += $v['quantity'];
}
$rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($info_list),'datacount'=>$exdata,'exdata'=>$exdata);
echo json_encode($rows);exit;
}
}
public function _out()
{
$post = $this->input->post(NULL, TRUE);
if(isset($post['number']))
{
$time = time();
$number = $this->input->post('number',true);
$type = $this->input->post('type',true);
$ps = $this->input->post('ps',true);
$cz = $this->input->post('cz',true);
$lx = $this->input->post('lx',true);
$ly = $this->input->post('ly',true);
$czwarehouse = $this->input->post('czwarehouse',true);
$timetk = $this->input->post('timetk',true);
$timetj = $this->input->post('timetj',true);
$timetk = strtotime($timetk);
$timetj = strtotime($timetj);
if(!$number)
{
echo json_encode(array('msg'=>'未扫入数据！','success'=>false));exit;
}
if(!$type)
{
echo json_encode(array('msg'=>'请选择需要录入数据的仓库！','success'=>false));exit;
}
if(!$cz)
{
echo json_encode(array('msg'=>'请选择需对应的部门！','success'=>false));exit;
}
if(!$lx)
{
echo json_encode(array('msg'=>'请选择需要操作的类型！','success'=>false));exit;
}
if(!$ly)
{
$ly = 0;
}
$nu = $this->fullorder->get_number($number);
if(!$nu)
{
$nu = $this->fullordersmt->get_number($number);
}
if(!$nu)
{
echo json_encode(array('msg'=>'错误！未找到此编号的订单','success'=>false));exit;
}
if($nu['state'] == '214' || $nu['state'] == '217')
{
echo json_encode(array('msg'=>'错误，此单已取消！请联系店员核实','success'=>false));exit;
}
$systemtransfer = $this->systemtransfer->get_czwarehouse($number,$czwarehouse);
//$systemtransfer = $this->systemtransfer->get_number($number);
if(!$systemtransfer)
{
if($this->systemtransfer->insert(array('type'=>$type,'cz'=>'|'.$cz.'|','cztime'=>'|'.$time.'|','number'=>$number,'shipremarks'=>$nu['shipremarks'],'printtime'=>$nu['printtime'],'quantity'=>1,'gtime'=>date('YmdH',$time),'time'=>$time,'fpdata'=>$nu['fpdata'],'ctime'.$cz=>$time,'czwarehouse'=>$czwarehouse)))
{
echo json_encode(array('music'=>'1','success'=>true));exit;
}
else
{
echo json_encode(array('msg'=>'数据写入失败，请重试！','success'=>false));exit;
}
}
$czarray = explode('|',trim($systemtransfer['cz'],'|'));
$cztimearray = explode('|',trim($systemtransfer['cztime'],'|'));
$czarray = array_flip($czarray);
if(stripos($systemtransfer['cz'],'|'.$cz.'|') !== false && $cztimearray[$czarray[$cz]] > $time-1200)
{
echo json_encode(array('msg'=>'错误，系统20分钟内已录入过！','success'=>false));exit;
}
if($this->systemtransfer->save(array('cz'=>$systemtransfer['cz'].$cz.'|','cztime'=>$systemtransfer['cztime'].$time.'|','ctime'.$cz=>$time),$systemtransfer['id']))
{
if($nu['state'] == '216')
{
echo json_encode(array('msg'=>'数据已录入成功！提示：此订单已出库，可选择终止生产。','success'=>false));exit;
}
else
{
echo json_encode(array('music'=>'1','success'=>true));exit;
}
}
else
{
echo json_encode(array('msg'=>'数据写入失败，请重试！','success'=>false));exit;
}
}
}
public function _barcode($arg_array)
{
$dir = 'data/img/'.date('Ymd',time()).'/';
if(!is_dir('./'.$dir))mkdir('./'.$dir,0777);
$imgUrl = $dir.$arg_array.'.png';
// 引用class文件夹对应的类
require_once('./data/barcodegen/class/BCGFontFile.php');
require_once('./data/barcodegen/class/BCGColor.php');
require_once('./data/barcodegen/class/BCGDrawing.php');
// 条形码的编码格式
require_once('./data/barcodegen/class/BCGcode128.barcode.php');
// 加载字体大小
$font = new \BCGFontFile('./data/barcodegen/Arial.ttf', 18);
//设置条形码颜色
$color_black = new \BCGColor(0, 0, 0);
$color_white = new \BCGColor(255, 255, 255);
$drawException = null;
try
{
$code = new \BCGcode128();
$code->setScale(2);
$code->setThickness(30); // 条形码的厚度
$code->setForegroundColor($color_black); // 条形码颜色
$code->setBackgroundColor($color_white); // 条形码间隙颜色
$code->setFont($font); //设置引用字体 条形码下方的文字
$code->parse($arg_array); // 条形码需要的数据内容
}
catch(\Exception $exception)
{
$drawException = $exception;
}
$drawing = new \BCGDrawing($imgUrl, $color_white);
if($drawException)
{
$drawing->drawException($drawException);
}
else
{
$drawing->setBarcode($code);
$drawing->draw();
}
// Header that says it is an image (remove it if you save the barcode to a file)
//header('Content-Type: image/png');
//header('Content-Disposition: inline; filename="barcode.png"');
// Draw (or save) the image into PNG format.
$drawing->finish(\BCGDrawing::IMG_FORMAT_PNG);
return 'http://'.$_SERVER['HTTP_HOST'].'/data/img/'.date('Ymd',time()).'/'.$arg_array.'.png';
//return "![](".$data.")
";
}
public function _excel()
{
if(isset($_GET['fexcel']))
{
$timetk = $this->input->get('timetk',true);
$timetj = $this->input->get('timetj',true);
$type = $this->input->get('type',true);
$cz = $this->input->get('cz',true);
$number = $this->input->get('number',true);
$timetk = strtotime($timetk.':0:0');
$timetj = strtotime($timetj);
$gctime = "gctime".$cz;
$where = "type != 0 and $gctime like '%-".date('YmdH',$timetk)."'";
if(isset($_SESSION['api']))
{
if($type)
{
$where .= " and type = '$type'";
$warehouse = $this->warehouse->read($type);
$titletype = "---".$warehouse['title'];
}
else
{
$uw = '';
$u = $this->user->get_api($_SESSION['api']);
$u['warehouse'] = explode('|',trim($u['warehouse'],'|'));
foreach ($u['warehouse'] as $v)
{
$uw .= " type = '$v' or";
}
$uw = rtrim($uw,'or');
$uw = " and (".ltrim($uw,' ').")";
$where .= $uw;
$titletype = "";
}
}
else
{
echo json_encode(array('msg'=>'导出失败，请重新登陆！','success'=>false));exit;
}
if($number)
{
$where .= " and number = '$number'";
}
if($cz)
{
$where .= " and cz like '%~".$cz."-%'";
}
$data = array();
$datafy = array();
$j = 0;
$info_list = $this->systemtransfer->find_all($where,'number,shipremarks,printtime,quantity');
foreach ($info_list as $key=>$value)
{
$img = $this->_barcode($value['number']);
$info_list[$key]['number'] = ".![](".$img.")
";
$info_list[$key]['shipremarks'] = str_replace(array('<','>'),array('<','>'),$value['shipremarks']);
$info_list[$key]['printtime'] = date('Y-m-d H:i:s',$value['printtime']);
}
$title = date('Y-m-d H-i',time()).'扫码统计表'.$titletype;
$titlename = "
".$title." |
|---|
| 编号 |
仓库品名 |
打印时间 |
数量 |
|
";
$filename = $title.".xls";
$tail = "\n";
$str = "
";
$str .= $titlename;
foreach ($info_list as $key=>$value)
{
$str .= "";
foreach ($value as $ke=>$va)
{
$tj = '';
if($ke == 'number')
{
$str .= "| ".$va." | ";//使用文本格式
}
else
{
$str .= "".$va." | ";//使用文本格式
}
}
$str .= "
|
|
\n";
}
$str .= $tail;
$str .= "
";
header( "Content-Type: application/vnd.ms-excel; name='excel'" );
header( "Content-type: application/octet-stream" );
header( "Content-Disposition: attachment; filename=".$filename );
header( "Cache-Control: must-revalidate, post-check=0, pre-check=0" );
header( "Pragma: no-cache" );
header( "Expires: 0" );
exit($str);
//echo "";
//print_r($info_list);
}
}
public function _xz()
{
if(isset($_GET['fexcel']))
{
$tc = array();$zh = array();
$typeclass = $this->typeclass->find_all();
foreach ($typeclass as $v)
{
$tc[$v['id']] = $v['title'];
$zh[$v['id']] = $v;
}
$timetk = $this->input->get('timetk',true);
$timetj = $this->input->get('timetj',true);
$cz = $this->input->get('cz',true);
if(!$cz)
{
$cz = 1;
}
$type = $this->input->get('type',true);
$czwarehouse = $this->input->get('czwarehouse',true);
$timetk = strtotime($timetk);
$timetj = strtotime($timetj);
$where = "type != '0'";
$cxctime = "ctime".$cz;
if($timetk)
{
$where .= " and $cxctime > '$timetk' and $cxctime < '$timetj'";
}
if($cz)
{
$where .= " and cz like '%|".$cz."|%'";
}
if($czwarehouse != '')
{
$where .= " and czwarehouse = '$czwarehouse'";
}
$data = array();
$datafy = array();
$j = 0;
$info_list = $this->systemtransfer->find_all($where,'number,shipremarks,printtime');
foreach ($info_list as $key=>$value)
{
$dd = $this->fullordersmt->get_number($value['number']);
if(!$dd)
{
$dd = $this->fullorder->get_number($value['number']);
}
$info_list[$key]['printtime'] = date('Y-m-d H:i:s',$value['printtime']);
$info_list[$key]['shipremarks'] = str_replace(array('<','>'),array('<','>'),$value['shipremarks']);
//$this->systemtransfer->save(array('xz'=>1),$value['id']);
$fpdata = array();
if(stripos($dd['fpdata'],';') !== false)
{
$fpdata = explode(';',rtrim($dd['fpdata'],';'));
foreach ($fpdata as $ke=>$va)
{
$pm = array(13=>'',22=>'',8=>'',15=>'',18=>'','100'=>'',33=>'',34=>'',35=>'',7=>'','dc'=>'','c'=>'',14=>'',12=>'',25=>'',26=>'',27=>'',10=>'',6=>'',9=>'',999=>'',9999=>'');
$title = '';
$fg = explode('|',$va);
$fg[0] = str_replace(array('163-','164-','165-','166-','-0-'),array('','','','','-'),$fg[0]);
$cp = explode('-',rtrim($fg[0],'-'));
if(isset($cp[2]))
{
$dj = $tc[$cp[2]];
}
else
{
$dj = '';
}
if(isset($cp[3]))
{
$ys = isset($tc[$cp[3]])?$tc[$cp[3]]:'0';
}
else
{
$ys = 0;
}
if(isset($cp[7]))
{
$md = (isset($tc[$cp[7]]))?$tc[$cp[7]]:'';
}
else
{
$md = '';
}
foreach ($cp as $v)
{
$v = rtrim($v,',');
if(isset($zh[$v]['classid']) && isset($pm[$zh[$v]['classid']]))
{
$pm[$zh[$v]['classid']] = $zh[$v]['zh'];
}
}
unset($cp[0],$cp[1],$cp[2],$cp[3],$cp[7]);
foreach ($cp as $v)
{
$title .= (isset($tc[$v]))?$tc[$v].' ':' ';
}
$fpdata[$ke] = array(implode(" ",$pm),$fg[5],$dj,$ys,$title,$md,$fg[2]);//内容，尺寸，等级，颜色,数量,密度
}
}
$info_list[$key]['fpdata'] = $fpdata;
}
$title = date('Y-m-d',$timetk).'-'.date('Y-m-d',$timetj).' 完成仓统计表';
$titlename = "
| 编号 |
仓库品名 |
打印时间 |
| 订单产品信息 |
| 产品名称 |
尺寸 |
等级 |
颜色 |
花型 |
密度 |
数量 |
总数量 |
|
";
$filename = $title.".xls";
$tail = "\n";
$this->excel->get_fz($info_list,$titlename,$filename,$tail);
}
}
public function _add()
{
$post = $this->input->post(NULL, TRUE);
if(isset($post['number']))
{
$where = "gtime = '".date('Ymd',time())."'";
$number = $this->input->post('number',true);
$id = $this->input->post('id',true);
$type = $this->input->post('type',true);
$time = $this->input->post('time',true);
$time = strtotime($time);
if($id)
{
if($type)
{
$where .= " and type = '$type'";
}
else
{
$uw = '';
$u = $this->user->get_api($id);
$u['warehouse'] = explode('|',trim($u['warehouse'],'|'));
foreach ($u['warehouse'] as $v)
{
$uw .= " type = '$v' or";
}
$uw = rtrim($uw,'or');
$uw = " and (".ltrim($uw,' ').")";
$where .= $uw;
}
}
if(!$number)
{
echo json_encode(array('msg'=>'编号不能为空！','success'=>false));exit;
}
if(!$type)
{
echo json_encode(array('msg'=>'请选择需要录入数据的仓库！','success'=>false));exit;
}
$nu = $this->fullorder->get_number($number);
if(!$nu)
{
$nu = $this->fullordersmt->get_number($number);
}
if(!$nu)
{
echo json_encode(array('msg'=>'错误！未找到此编号的订单','success'=>false));exit;
}
if($nu['printtime'] == '0')
{
echo json_encode(array('msg'=>'错误，此单没有打印时间！请联系店员核实','success'=>false));exit;
}
$data = 0;
$count = $this->systemtransfer->find_all($where);
foreach ($count as $v)
{
$data += $v['quantity'];
}
$systemtransfer = $this->systemtransfer->get_number($number);
if($systemtransfer)
{
$this->systemtransfer->save(array('quantity'=>$systemtransfer['quantity']+1),$systemtransfer['id']);
echo json_encode(array('title'=>'添加成功','msg'=>$data+1,'music'=>'1','success'=>true));exit;
}
else
{
if($this->systemtransfer->insert(array('type'=>$type,'number'=>$number,'shipremarks'=>$nu['shipremarks'],'printtime'=>$nu['printtime'],'quantity'=>1,'gtime'=>date('YmdH',time()),'time'=>time())))
{
echo json_encode(array('title'=>'添加成功','msg'=>$data+1,'music'=>'1','success'=>true));exit;
}
else
{
echo json_encode(array('msg'=>'数据写入失败，请重试！','success'=>false));exit;
}
}
}
}
public function _del()
{
/**
$post = $this->input->post(NULL, TRUE);
if(isset($_SESSION['api']))
{
$user = $this->user->get_api($_SESSION['api']);
}
if(stripos($user['userid'],'peihuo') !== false)
{
$kx = 1;
}
else if(stripos($user['userid'],'gaozhen') !== false)
{
$kx = 2;
}
else if(stripos($user['userid'],'wancheng') !== false)
{
$kx = 3;
}
else if(stripos($user['userid'],'qvfa') !== false)
{
$kx = 4;
}
else if(stripos($user['userid'],'qianchuli') !== false)
{
$kx = 5;
}
else if(stripos($user['userid'],'houchuli') !== false)
{
$kx = 6;
}
else if(stripos($user['userid'],'faxingshi') !== false)
{
$kx = 7;
}
else if(stripos($user['userid'],'baozhuang') !== false)
{
$kx = 8;
}
else if(stripos($user['userid'],'sheji') !== false)
{
$kx = 9;
}
else if(stripos($user['userid'],'piaokou') !== false)
{
$kx = 10;
}
if(isset($post['delarr']))
{
$id_arr = $this->input->post('delarr');
$id_arr = explode(',',rtrim($id_arr,','));
if(!$id_arr)
{
echo json_encode(array('msg'=>'未选择需要删除的内容！','success'=>false));exit;
}
if(count($id_arr) > 1)
{
echo json_encode(array('msg'=>'每次只能删除一个！','success'=>false));exit;
}
//循环删除记录
$a=0;
foreach ($id_arr as $v)
{
$systemtransfer = $this->systemtransfer->read($v);
$czarray = explode('|',trim($systemtransfer['cz'],'|'));
$cztimearray = explode('|',trim($systemtransfer['cztime'],'|'));
if(count($czarray) == 1)
{
$this->systemtransfer->remove($v);
continue;
}
foreach ($czarray as $ka=>$va)
{
if($va == $kx)
{
unset($czarray[$ka]);
unset($cztimearray[$ka]);
}
}
$cz = "|".implode("|",$czarray)."|";
$cztime = "|".implode("|",$cztimearray)."|";
$this->systemtransfer->save(array('cz'=>$cz,'cztime'=>$cztime),$v);
}
echo json_encode(array('success'=>true));exit;
}
**/
$post = $this->input->post(NULL, TRUE);
if(isset($post['s']))
{
$id_arr = $this->input->post('s');
$id_arr = explode(',',trim($id_arr,','));
if(!$id_arr)
{
echo json_encode(array('msg'=>'参数错误！','success'=>false));exit;
}
if(count($id_arr) > 1)
{
echo json_encode(array('msg'=>'为防止删错，每次只可删除一条数据！请检查','success'=>false));exit;
}
//循环删除记录
foreach ($id_arr as $v)
{
$data = $this->systemtransfer->read($v);
$this->systemtransfer->remove($v);
$this->systemtransfer_del->insert($data);
}
echo json_encode(array('del'=>$id_arr,'msg'=>'删除记录成功！','success'=>true));
}
}
public function _hb()
{
$dataorder = array();
/* 订单加入键值-k */
$fdata = $this->fullorder->find_all('dtime > "'.(time()-50*24*3600).'" and printtime > 0','number,orderinfo,fpdata,shipremarks');
foreach ($fdata as $v)
{
$dataorder[$v['number']] = $v;
}
$sdata = $this->fullordersmt->find_all('dtime > "'.(time()-50*24*3600).'" and printtime > 0','number,orderinfo,fpdata,shipremarks');
foreach ($sdata as $v)
{
$dataorder[$v['number']] = $v;
}
/* 匹配ID加入 */
$tc = array();$ztc = array();$tclass = array();
$typeclass = $this->typeclass->find_all();
foreach ($typeclass as $v)
{
$ztc[$v['id']] = $v['zh'];
$tc[$v['id']] = $v['title'];
$tclass[$v['id']] = $v['classid'];
}
$dir = '/data/excel/'.date('Ymd',time()).'/';
$config['upload_path'] = '.'.$dir ;
$config['file_name'] = date('Ymd_His_',time()).rand(1000,9999);
$config['allowed_types'] = 'xls|xlsx|csv';
$config['max_size'] = 10240;
$this->load->library('upload', $config);
$this->upload->initialize($config);
if ($this->upload->do_upload('userfile'))
{
$full_path = $dir.$this->upload->data('file_name');
$fileName = '.' . $full_path;
if (!file_exists($fileName))
{
echo json_encode(array('msg'=>"上传失败，请重试",'success'=>false));exit;
}
else
{
require_once "./data/excel/PHPExcel/IOFactory.php";
$phpExcel = PHPExcel_IOFactory::load($fileName);// 载入当前文件
$phpExcel->setActiveSheetIndex(0);// 设置为默认表
$sheetCount = $phpExcel->getSheetCount();// 获取表格数量
$row = $phpExcel->getActiveSheet()->getHighestRow();// 获取行数
$column = $phpExcel->getActiveSheet()->getHighestColumn();// 获取列数
++$column;//如果列数大于26行
$list = array();
for ($i = 2; $i <= $row; $i++) // 行数循环
{
$data = array();
for ($c = 'A'; $c != $column; $c++) // 列数循环
{
$data[] = $phpExcel->getActiveSheet()->getCell($c . $i)->getValue();
}
$list[] = $data;
}
}
$ed = array();$i = 0;$j = 0;$dcdata = array();$yc = '';
$cmf_arr = array_column($list, '1');
array_multisort($cmf_arr, SORT_ASC, $list);
foreach ($list as $key=>$value)
{
$number = $value['1'];
$bbtime = $value['7'];
if(stripos($number,'QM') !== false)
{
continue;
}
if(isset($dataorder[$number]))
{
$thisnumber = $dataorder[$number];$thisshipremarks = array();
if(stripos($thisnumber['fpdata'],';') !== false)
{
$fpdata = explode(';',rtrim($thisnumber['fpdata'],';'));
foreach ($fpdata as $ke=>$va)
{
$title = '';
$fg = explode('|',$va);
$fg[0] = str_replace(array('163-','164-','165-','166-','-0-'),array('','','','','-'),$fg[0]);
$cp = explode('-',rtrim($fg[0],'-'));
if(isset($cp[5]))
{
$tt = $ztc[$cp[5]];
}
else
{
$tt = '';
}
$md = '';
foreach ($cp as $v)
{
if(!isset($tclass[$v]))
{
continue;
}
if($tclass[$v] == '10')
{
$md = $tc[$v];
}
}
if(isset($cp[4]))
{
$dchx = $tc[$cp[4]];
}
else
{
$dchx = ' ';
}
$thisshipremarks[] = array($tt,$tc[$cp[3]],$md,$dchx,$fg[5],$fg[2]);//头套种类，颜色,密度,花型，尺寸,数量
}
}
$thisnumber['shipremarks'] = str_replace(array('<','>'),array('<','>'),$thisnumber['shipremarks']);
$dcdata[] = array('number'=>$thisnumber['number'],'time'=>$bbtime,'shipremarks'=>$thisnumber['shipremarks'],'fpdata'=>$thisshipremarks);
}
else
{
$ed[] = array($number.'-系统未找到此订单信息');
$i++;
continue;
}
}
if($i > 0)
{
$yc = $i.'条异常';
}
$title = date('Y-m-d H:i:s',time())." 产品详细信息";
$titlename = "
".$title." |
|---|
| 订单编号 |
配货时间 |
仓库品名 |
|
总条数 |
";
$filename = $title.".xls";
$tail = "\n";
$downexcel = $this->get_fz($dcdata,$titlename,$filename,$tail);
$time = date('Ymd',time());
$dir = '/data/excel/'.$time.'/';
$file_name = $title;
if(!is_dir('.'.$dir))mkdir('.'.$dir,0777);
$myfile = fopen(".".$dir.$file_name.".xls", "w") or die();
fwrite($myfile,$downexcel);
fclose($myfile);
$goexcel = $dir.$file_name.'.xls';
echo json_encode(array('msg'=>'操作成功 '.$yc,'goexcel'=>$goexcel,'success'=>true));exit;
}
else
{
echo json_encode(array('msg'=>'上传失败！','t'=>$this->upload->display_errors(),'success'=>false));exit;
}
}
public function get_fz($info_list,$titlename,$filename,$tail)
{
$str = "
";
$str .= $titlename;
$str .= "";
foreach ($info_list as $key=>$value)
{
if($value['fpdata'] == '')
{
continue;
}
$str .= "";
foreach ($value as $ke=>$va)
{
if($ke == 'orderinfo' || $ke == 'waybill')
{
$str .= "| ".$va." | ";
}
else if($ke != 'fpdata' && $ke != 'hl' && $ke != 'currencytitle')
{
$str .= "".$va." | ";
}
}
$str .= "";
$a = 0;
foreach ($value['fpdata'] as $k=>$v)
{
$vd = '';
foreach ($v as $vv)
{
$vd .= "| ".$vv." | ";
}
$str .= "".$vd." ";
$endv = is_numeric(end($v))?end($v):0;
$a = $a + $endv;
}
$str .= " | ";
$str .= "".$a." | ";
$str .= "
\n";
}
$str .= $tail;
$str .= "
";
return $str;
//return $str;
}
}