";
			//print_r($info_list);
	    }
	}
	
	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->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($post['delarr']))  
		{
			$number = $this->input->post('number',true);
			$type = $this->input->post('type',true);
			$timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$where = "type != 0";
			if(isset($_SESSION['api']))
			{
				if($type)
            	{
                	$where  .= " and type = '$type'";
           		}
				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;
				}
			}
			if($timetk && $timetj)
            {
                $where  .= " and time > '$timetk' and time < '$timetj'";
            }
			if($number)
            {
                $where  .= " and number = '$number'";
            }
            $id_arr = $this->input->post('delarr');
            $id_arr =  explode(',',rtrim($id_arr,','));
            if(!$id_arr)
            {
                echo json_encode(array('msg'=>'未选择需要删除的内容！','success'=>false));exit;
            }
            //循环删除记录
			$a=0;
            foreach ($id_arr as $v) 
		    {
				if($this->systemwigsout->remove($v))
				{
					$a++;
				}
				
            }
			if($a == count($id_arr))
			{
				$data = 0;
				$count = $this->systemwigsout->find_all($where);
				foreach ($count as $v) 
				{
					$data += $v['quantity']; 
				}
                echo json_encode(array('del'=>$id_arr,'data'=>$data-$a,'msg'=>'删除成功！','success'=>true));
			}
			else
			{
				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 .= "";
				}
				else if($ke != 'fpdata' && $ke != 'hl' && $ke != 'currencytitle')
				{
		            $str .= ""; 
				}
		    }
			$str .= ""; 
			$str .= "";
		    $str .= "\n"; 
		}
		$str .= $tail;
		$str .= "
".$va."
".$va."
";
			$a = 0;
			foreach ($value['fpdata'] as $k=>$v) 
		    {
				$vd = '';
				foreach ($v as $vv) 
		        {
					$vd .= "";
				}
				$str .= "".$vd."";
				$endv = is_numeric(end($v))?end($v):0;
				$a = $a + $endv;
			}
			$str .= "
".$vv."
".$a."
"; 
		return $str; 
		//return $str;
	}
}