';
}
else
{
$info_list[$key]['time'] .= $zw[$cz[$i]].' ：'.'未获取到时间
';
}
}
}
$info_list[$key]['time'] = trim($info_list[$key]['time'],'
');
}
$total = $this->systemwigsout->find_count($where);
$pagenum = ceil($total/$perpage);
$over = $total-($start+$perpage);
$exdata = 0;
$count = $this->systemwigsout->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(!$cz)
{
echo json_encode(array('msg'=>'请选择需对应的部门！','success'=>false));exit;
}
if(!$lx)
{
echo json_encode(array('msg'=>'请选择需要操作的类型！','success'=>false));exit;
}
if(!$ly)
{
$ly = 0;
}
$fullorder = 'fullorder';
$nu = $this->fullorder->get_number($number);
if(!$nu)
{
$fullorder = 'fullordersmt';
$nu = $this->fullordersmt->get_number($number);
}
if(!$nu)
{
$fullorder = 'fullordertt';
$nu = $this->fullordertt->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;
}
$systemwigsout = $this->systemwigsout->get_czwarehouse($number,$czwarehouse);
//$systemwigsout = $this->systemwigsout->get_number($number);
if(!$systemwigsout)
{
if($this->systemwigsout->insert(array('type'=>$nu['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($systemwigsout['cz'],'|'));
$cztimearray = explode('|',trim($systemwigsout['cztime'],'|'));
$czarray = array_flip($czarray);
if(stripos($systemwigsout['cz'],'|'.$cz.'|') !== false && $cztimearray[$czarray[$cz]] > $time-1200 && $cz != 11)
{
echo json_encode(array('msg'=>'错误，系统20分钟内已录入过！','success'=>false));exit;
}
$fg = 0;
if($systemwigsout['ctime11'] != 0)
{
$fg = 1;
}
if($this->systemwigsout->save(array('cz'=>$systemwigsout['cz'].$cz.'|','cztime'=>$systemwigsout['cztime'].$time.'|','ctime'.$cz=>$time,'fg'=>$fg,'time'=>$time),$systemwigsout['id']))
{
if($nu['state'] == '216')
{
echo json_encode(array('msg'=>'数据已录入成功！此订单已出库，请终止生产。','success'=>false));exit;
}
else if($nu['type'] == '5')
{
echo json_encode(array('msg'=>'数据已录入成功！该单已改成美国仓发货，请终止生产。','success'=>false));exit;
}
else
{
if($nu['scapi'] == 99 && $nu['scid'] != '' && $nu['scid'] != '|' && $nu['dbapi'] != '99' && $cz == 11)
{
@$rk = $this->apiyy->_rk($nu,$fullorder);
if($rk['c'] == 1)
{
$this->apiyy->insert(array('number'=>$rk['number'],'lx'=>$rk['lc'],'type'=>2,'error'=>$rk['error']));
$this->$fullorder->save(array('dbapi'=>$rk['lc']),$nu['id']);
echo json_encode(array('music'=>'1','cs'=>$rk,'success'=>true));exit;
}
else
{
echo json_encode(array('music'=>'1','cs'=>'0','success'=>true));exit;
$this->$fullorder->save(array('dbapi'=>99),$nu['id']);
}
}
else
{
echo json_encode(array('music'=>'1','cs'=>'2','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->systemwigsout->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']))
{
if(isset($_SESSION['api']))
{
$user = $this->user->get_api($_SESSION['api']);
$wid="";
$userwh = explode('|',trim($user['warehouse'],'|'));
foreach ($userwh as $value)
{
$wid .= " type = ".$value." or";
}
}
$tc = $this->typeclass->find_all();
$typeclass = array();
foreach ($tc as $v)
{
$tcjm[$v['id']] = array($v['jm'],$v['classid']);
$typeclass[$v['id']] = array('zh'=>$v['zh'],'classid'=>$v['classid'],'bm'=>$v['bm'],'title'=>$v['title'],'jm'=>$v['jm']);
}
$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;
$wh = array();
$w = $this->warehouse->find_all('1=1','id,title');
foreach ($w as $v)
{
$wh[$v['id']] = $v['title'];
}
$info_list = $this->systemwigsout->find_all($where.' and ('.rtrim($wid,'or').')','type,number,shipremarks,printtime,fg');
foreach ($info_list as $key=>$value)
{
$info_list[$key]['type'] = $wh[$value['type']];
if($value['fg'] > 0)
{
$info_list[$key]['fg'] = '返工';
}
else
{
$info_list[$key]['fg'] = '';
}
$dd = $this->fullordersmt->get_number($value['number']);
if(!$dd)
{
$dd = $this->fullorder->get_number($value['number']);
}
if(!$dd)
{
$dd = $this->fullordertt->get_number($value['number']);
}
$classid = $this->classid->sku();
$info_list[$key]['printtime'] = date('Y-m-d H:i:s',$value['printtime']);
$info_list[$key]['shipremarks'] = str_replace(array('<','>'),array('<','>'),$value['shipremarks']);
//$this->systemwigsout->save(array('xz'=>1),$value['id']);
$fpdata = array();$bm = '03';
if(stripos($dd['fpdata'],';') !== false)
{
$fpdata = explode(';',rtrim($dd['fpdata'],';'));
foreach ($fpdata as $ke=>$va)
{
$pm = $classid;
$jm = $classid;
$bmpx = array(13=>'',16=>'',18=>'',25=>'',26=>'',41=>'');
$title = '';
$va = str_replace(array('-163-','-164-','-165-','-166-'),'-',$va);
$fg = explode('|',$va);
if(stripos($fg[0],',') !== false)
{
$ft = explode(',',$fg[0]);
$features = explode('-',trim($ft[1],'-'));
$features[] = $ft[0];
}
else
{
$features = explode('-',trim($fg[0],'-'));
}
foreach ($features as $v)
{
if(isset($typeclass[$v]))
{
if($typeclass[$v]['bm'] != '')
{
$bmpx[$typeclass[$v]['classid']] = $typeclass[$v]['bm'];
}
}
if($v != 0)
{
if(isset($typeclass[$v]))
{
if($typeclass[$v]['title'] == '9A')
{
$pm[$typeclass[$v]['classid']] = '9A';
}
else if($typeclass[$v]['title'] == '10A')
{
$pm[$typeclass[$v]['classid']] = '10A';
}
else
{
$clzh = $typeclass[$v]['zh'];
if(stripos($typeclass[$v]['zh'],'|') !== false)
{
$clzh = explode('|',rtrim($typeclass[$v]['zh'],'|'));
$clzh = $clzh[0];
}
$pm[$typeclass[$v]['classid']] = $clzh;
}
}
if(isset($typeclass[$v]))
{
if($typeclass[$v]['jm'])
{
$jm[$typeclass[$v]['classid']] = $typeclass[$v]['jm'];
}
}
}
}
$jm = array_filter($jm);//去除空值
$jm = implode("-",$jm);
$pm = array_filter($pm);//去除空值
$zh = implode(" ",$pm);
$zh = preg_replace("/\r\n|\r|\n/",'',trim($zh,' '));
$dtnr = explode('-',trim($fg[0],'-'));
$dj = '';$md = '';$ys = '';$title = '';
foreach ($dtnr as $v)
{
if(isset($typeclass[$v]))
{
if($typeclass[$v]['classid'] == '15')
{
$title = $typeclass[$v]['title'];
}
else if($typeclass[$v]['classid'] == '8')
{
$ys = $typeclass[$v]['title'];
}
else if($typeclass[$v]['classid'] == '13')
{
$dj = $typeclass[$v]['title'];
}
else if($typeclass[$v]['classid'] == '10')
{
$md = $typeclass[$v]['title'];
}
}
}
$fpdata[$ke] = array($zh,$fg[5],$dj,$ys,$title,$md,$jm,$bm.implode("",$bmpx),$fg[2]);//内容，尺寸，等级，颜色,数量,密度
}
}
$info_list[$key]['fpdata'] = $fpdata;
}
$transfer = $this->transfer->read($cz);
$title = date('Y-m-d',$timetk).'-'.date('Y-m-d',$timetj).' '.$transfer['title'].'仓统计表';
$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)
{
$nu = $this->fullordertt->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->systemwigsout->find_all($where);
foreach ($count as $v)
{
$data += $v['quantity'];
}
$systemwigsout = $this->systemwigsout->get_number($number);
if($systemwigsout)
{
$this->systemwigsout->save(array('quantity'=>$systemwigsout['quantity']+1),$systemwigsout['id']);
echo json_encode(array('title'=>'添加成功','msg'=>$data+1,'music'=>'1','success'=>true));exit;
}
else
{
if($this->systemwigsout->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;
}
else if(stripos($user['userid'],'ck') !== false)
{
$kx = 11;
}
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)
{
$systemwigsout = $this->systemwigsout->read($v);
$czarray = explode('|',trim($systemwigsout['cz'],'|'));
$cztimearray = explode('|',trim($systemwigsout['cztime'],'|'));
if(count($czarray) == 1)
{
$this->systemwigsout->remove($v);
continue;
}
foreach ($czarray as $ka=>$va)
{
if($va == $kx)
{
unset($czarray[$ka]);
unset($cztimearray[$ka]);
}
}
$cz = "|".implode("|",$czarray)."|";
$cztime = "|".implode("|",$cztimearray)."|";
$this->systemwigsout->save(array('cz'=>$cz,'cztime'=>$cztime),$v);
}
echo json_encode(array('success'=>true));exit;
}
}
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;
}
$tdata = $this->fullordertt->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;
}
}