";print_r($info_list);exit;
			$lzxq = '';
			foreach ($lzbm as $v)
		    {
				$lzxq .= ''.$v['title'].'';
			}
			$title = date('Y-m-d',$timetk).'-'.date('Y-m-d',$timetj).' 统计表'; 
            $titlename = "

           

            
订单编号
            
品名
			
简码
			
备注
            
打印时间
			

			
			".$lzxq."
            

            
订单产品信息
货物流转时间
            

			
产品名称
			
尺寸
			
等级
			
颜色
			
花型
			
密度
            
			
            
            
"; 
            $filename = $title.".xls"; 
			$tail = "\n";
            $this->excel->get_fz($info_list,$titlename,$filename,$tail,1);
	    }
	}
	
	public function _rk()
	{
		$post = $this->input->post(NULL, TRUE);
	    if(isset($post['page']))  
		{
			$api = $this->input->post('api',true);
		    $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
			$number = $this->input->post('number',true);
			$color = $this->input->post('color',true);
			$purchase = $this->input->post('purchase',true);
			$transfer = $this->input->post('transfer',true);
			$lx = $this->input->post('lx',true);
			$timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$where = "1=1";
			if($transfer)
			{
				$ctime = 'ctime'.$transfer;
			    $where  .= " and $ctime > '$timetk' and $ctime < '$timetj'";
			}
			else
			{
				$where  .= " and time > '$timetk' and time < '$timetj'";
			}
			if($number)
            {
                $where  .= " and number = '$number'";
            }
			if($transfer)
            {
                $where  .= " and rk like '%|".$transfer."|%'";
            }
			if($purchase)
            {
                $where  .= " and purchase = '$purchase'";
            }
			if($color)
            {
                $where  .= " and fpdata like '%-".$color."-%'";
            }
			if($lx)
            {
				if($lx == 1)
				{
                    $where  .= " and ordernumber = ''";
				}
				else
				{
					$where  .= " and ordernumber != ''";
				}
            }
            //数据排序
            $order_str = "id desc";
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
            //取得信息列表
            $info_list = $this->systemtransfer->find_all($where,'id,number,pm,shipremarks,printtime,time',$order_str,$start,$perpage);
			$transfer = $this->transfer->find_all();
			$t = array();
			foreach ($transfer as $v)
		    {
				$t[$v['id']] = $v['title'];
				$ot[$v['id']] = ($v['orvertime']>0)?$v['orvertime']*24*3600:0;
			}
			 //格式化数据
            foreach ($info_list as $key=>$value)
		    {
				$dd = $this->systemtransfer->read($value['id']);
				$info_list[$key]['printtime'] = date('Y-m-d H:i:s',$value['printtime']);
				$rk = explode('|',trim($dd['rk'],'|'));
				$rktime = explode('|',trim($dd['rktime'],'|'));
				$ck = explode('|',trim($dd['ck'],'|'));
				$cktime = explode('|',trim($dd['cktime'],'|'));
				$info_list[$key]['time'] = '';
				
				for($i=0;$i 0 && $rktime[$i] + $ot[$rk[$i]] < time())
					{
						$d = ' '.$t[$rk[$i]].'入库 ：'.((isset($rktime[$i]))?(date('Y-m-d H:i',$rktime[$i])):'').' 超
 ';
					}
					else
					{
						$d = $t[$rk[$i]].'入库 ：'.((isset($rktime[$i]))?(date('Y-m-d H:i',$rktime[$i])):'').'
';
					}
					$info_list[$key]['time'] .= $d;
					if(isset($ck[$i]) && $ck[$i] != '')
					{
						$info_list[$key]['time'] .= $t[$ck[$i]].'出库 ：'.date('Y-m-d H:i',$cktime[$i]).'
';
					}
				}
				$info_list[$key]['time'] = trim($info_list[$key]['time'],'
');
            }
		    $total = $this->systemtransfer->find_count($where);
		    $pagenum = ceil($total/$perpage);
		    $over = $total-($start+$perpage);
		    $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($info_list),'cs'=>$where);
		    echo json_encode($rows);exit;
		}
		if(isset($_SESSION['api']))
		{
			$user = $this->user->get_api($_SESSION['api']);
			$usp = $user;
		    $pid = "";$tid="";$sid="";$wid="";
		    $purchase = explode('|',trim($user['purchase'],'|'));
			$transfer = explode('|',trim($user['transfer'],'|'));
			$warehouse = explode('|',trim($user['warehouse'],'|'));
			foreach ($purchase as $value) 
		    {
				$pid .= " id = ".$value." or";
			}
			foreach ($transfer as $value) 
		    {
				$tid .= " id = ".$value." or";
			}
			foreach ($warehouse as $value) 
		    {
				$wid .= " id = ".$value." or";
			}
		}
		else
		{
			header('Location: /');exit;
		}
		$transfer = $this->transfer->find_all('1=1 and '.rtrim($tid,'or'));
		$this->data['transfer'] = $transfer;
		$this->_Template('transfer_rk',$this->data);
	}
	
	public function _ck()
	{
		$post = $this->input->post(NULL, TRUE);
	    if(isset($post['page']))  
		{
			$api = $this->input->post('api',true);
		    $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
			$number = $this->input->post('number',true);
			$color = $this->input->post('color',true);
			$purchase = $this->input->post('purchase',true);
			$transfer = $this->input->post('transfer',true);
			$lx = $this->input->post('lx',true);
			$timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$where = "1=1";
			if($transfer)
			{
				$ctime = 'ctime'.$transfer;
			    $where  .= " and $ctime > '$timetk' and $ctime < '$timetj'";
			}
			else
			{
				$where  .= " and time > '$timetk' and time < '$timetj'";
			}
			if($number)
            {
                $where  .= " and number = '$number'";
            }
			if($transfer)
            {
                $where  .= " and ck like '%|".$transfer."|%'";
            }
			if($purchase)
            {
                $where  .= " and purchase = '$purchase'";
            }
			if($color)
            {
                $where  .= " and fpdata like '%-".$color."-%'";
            }
			if($lx)
            {
				if($lx == 1)
				{
                    $where  .= " and ordernumber = ''";
				}
				else
				{
					$where  .= " and ordernumber != ''";
				}
            }
            //数据排序
            $order_str = "id desc";
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
            //取得信息列表
            $info_list = $this->systemtransfer->find_all($where,'id,number,pm,shipremarks,printtime,time',$order_str,$start,$perpage);
			$transfer = $this->transfer->find_all();
			$t = array();
			foreach ($transfer as $v)
		    {
				$t[$v['id']] = $v['title'];
				$ot[$v['id']] = ($v['orvertime']>0)?$v['orvertime']*24*3600:0;
			}
			 //格式化数据
            foreach ($info_list as $key=>$value)
		    {
				$dd = $this->systemtransfer->read($value['id']);
				$info_list[$key]['printtime'] = date('Y-m-d H:i:s',$value['printtime']);
				$rk = explode('|',trim($dd['rk'],'|'));
				$rktime = explode('|',trim($dd['rktime'],'|'));
				$ck = explode('|',trim($dd['ck'],'|'));
				$cktime = explode('|',trim($dd['cktime'],'|'));
				$info_list[$key]['time'] = '';
				
				for($i=0;$i 0 && $rktime[$i] + $ot[$rk[$i]] < time())
					{
						$d = ' '.$t[$rk[$i]].'入库 ：'.((isset($rktime[$i]))?(date('Y-m-d H:i',$rktime[$i])):'').' 超
 ';
					}
					else
					{
						$d = $t[$rk[$i]].'入库 ：'.((isset($rktime[$i]))?(date('Y-m-d H:i',$rktime[$i])):'').'
';
					}
					$info_list[$key]['time'] .= $d;
					if(isset($ck[$i]) && $ck[$i] != '')
					{
						$info_list[$key]['time'] .= $t[$ck[$i]].'出库 ：'.date('Y-m-d H:i',$cktime[$i]).'
';
					}
				}
				$info_list[$key]['time'] = trim($info_list[$key]['time'],'
');
            }
		    $total = $this->systemtransfer->find_count($where);
		    $pagenum = ceil($total/$perpage);
		    $over = $total-($start+$perpage);
		    $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($info_list),'cs'=>$where);
		    echo json_encode($rows);exit;
		}
		if(isset($_SESSION['api']))
		{
			$user = $this->user->get_api($_SESSION['api']);
			$usp = $user;
		    $pid = "";$tid="";$sid="";$wid="";
		    $purchase = explode('|',trim($user['purchase'],'|'));
			$transfer = explode('|',trim($user['transfer'],'|'));
			$warehouse = explode('|',trim($user['warehouse'],'|'));
			foreach ($purchase as $value) 
		    {
				$pid .= " id = ".$value." or";
			}
			foreach ($transfer as $value) 
		    {
				$tid .= " id = ".$value." or";
			}
			foreach ($warehouse as $value) 
		    {
				$wid .= " id = ".$value." or";
			}
		}
		else
		{
			header('Location: /');exit;
		}
		$transfer = $this->transfer->find_all('1=1 and '.rtrim($tid,'or'));
		$this->data['transfer'] = $transfer;
		$this->_Template('transfer_ck',$this->data);
	}
	
	
	public function _jgl()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['printtime']))  
		{
		    $pt = $this->input->post('printtime',true);
			$wt = $this->input->post('wgtime',true);
			$printtime = strtotime($pt);
			$wgtime = strtotime($wt);
			$sy = $this->systemtransfer->find_count("printtime > '$printtime' and printtime < '".($printtime+24*3600)."'");
			$wg = $this->systemtransfer->find_count("printtime > '$printtime' and printtime < '".($printtime+24*3600)."' and ctime11 < '$wgtime' and ctime11 != '0'");
			if($printtime == $wgtime || $printtime > $wgtime)
			{
				echo json_encode(array('msg'=>"
时间选择错误
",'success'=>true));exit;
			}
			echo json_encode(array('msg'=>"
".(($wgtime-$printtime)/86400)."天 完工数量：".$wg."， 总数量：".$sy."， 完工率：".number_format(($wg/$sy*100),2)."%
",'success'=>true));exit;
	    }
		$this->_Template('transfer_wgl',$this->data);
	}
	
	public function _linqi(){
		$post = $this->input->post(NULL, TRUE);
	    if(isset($post['page']))  
		{

			$api = $this->input->post('api',true);
		    $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
			
			$transfer = $this->input->post('transfer',true);
			$transfer_ids = $this->input->post('transfer_ids',true);

			$orver_flag = $this->input->post('orver_flag',true);
			
			$timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);


			$transfer_list = $this->transfer->find_all();
			$t = $transfer_list = array_column($transfer_list, 'title', 'id');
			$where = 'type = 1 ';
			
			$where .= " and is_over = 0 and orver_flag = ".$orver_flag." ";
            //数据排序
            $order_str = "id desc";
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
			
			if($transfer){
				$where  .= " and lx = '$transfer'";
			}else{
			    $where .= " and lx in (".$transfer_ids.") ";
			}
			
			$where  .= " and time > '$timetk' and time < '$timetj'";
			
			$list = $this->systemtransfer_cr->find_all($where,'*',$order_str,$start,$perpage);

			$final_list = [];
			foreach ($list as $key => $value) {
			    

				$info = $this->systemtransfer->read($value['fid']);
				$final_list[$key]['id'] = $value['id'];
				$final_list[$key]['number'] = isset($info['number'])?$info['number']:'';
			
				if($info['is_jiaji'] == 2){
		            $final_list[$key]['is_jiaji'] = "加急";
		        }else{
		            $final_list[$key]['is_jiaji'] = "常规";
		        }
			
				$final_list[$key]['pm'] = $info['pm'];
				$final_list[$key]['shipremarks'] = $info['shipremarks'];
				$final_list[$key]['printtime'] = date('Y-m-d H:i:s',$info['printtime']);

				$data = $this->systemtransfer_cr->find_all("fid = '".$info['id']."'");
				
				$info_list[$key]['time'] = "布标打印 ：".date('Y-m-d H:i',$info['ctime12']).'
';
				foreach ($data as $k=>$v)
		        {
					$type = ($v['type']==1)?'入库':'出库';
					
					
					if($v['orver_flag'] == 1){
						if($v['is_over'] == 0){
							$info_list[$key]['time'] .= "".$t[$v['lx']].$type.' ：'.date('Y-m-d H:i',$v['time']) ."  即将超时 ".'
';
							// $info_list[$key]['time'] .= ' 即将超时'.'
';
						}else{
							$info_list[$key]['time'] .= "".$t[$v['lx']].$type.' ：'.date('Y-m-d H:i',$v['time']) ."".'
';
						}
					}elseif($v['orver_flag'] == 2){
						$info_list[$key]['time'] .= "".$t[$v['lx']].$type.' ：'.date('Y-m-d H:i',$v['time']) ."  超 时 ! ".'
';
					}else{
						$info_list[$key]['time'] .= "".$t[$v['lx']].$type.' ：'.date('Y-m-d H:i',$v['time']) ."".'
';
					}
				}
				
				$final_list[$key]['time'] = trim($info_list[$key]['time'],'
');
			}

			
			$total = $this->systemtransfer_cr->find_count($where);
		   
		    $pagenum = ceil($total/$perpage);
		    $over = $total-($start+$perpage);
		    $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($final_list));
		    echo json_encode($rows);exit;
		}
		if(isset($_SESSION['api']))
		{
			$user = $this->user->get_api($_SESSION['api']);
			$usp = $user;
		    $pid = "";$tid="";$sid="";$wid="";
		    $purchase = explode('|',trim($user['purchase'],'|'));
			$transfer = explode('|',trim($user['transfer'],'|'));
			$warehouse = explode('|',trim($user['warehouse'],'|'));
			foreach ($purchase as $value) 
		    {
				$pid .= " id = ".$value." or";
			}
			foreach ($transfer as $value) 
		    {
				$tid .= " id = ".$value." or";
			}
			foreach ($warehouse as $value) 
		    {
				$wid .= " id = ".$value." or";
			}
		}
		else
		{
			header('Location: /');exit;
		}
		$kx = '';$zjtab = '';
		
		$transfer = $this->transfer->find_all('1=1 and '.rtrim($tid,'or'));
		
		$this->data['transfer'] = $transfer;
		$transfer_ids = array_column($transfer, 'id');
		$this->data['transfer_ids'] =implode(",",$transfer_ids) ;
		$this->data['vip'] = $user['vip'];
		$this->data['orver_flag'] = $this->input->get('orver_flag', TRUE);
		$this->_Template('transfer_linqi',$this->data);
	}
	//按照条件导出超时车间
	public function _overtime_export(){
		$transfer_id = $this->input->get('transfer', TRUE);
		$timetk = $this->input->get('timetk', TRUE);
		$timetj = $this->input->get('timetj', TRUE);
		$timetk = strtotime($timetk);
		$timetj = strtotime($timetj);
		if(isset($_SESSION['api']))
		{
			$user = $this->user->get_api($_SESSION['api']);
			$transfer_ids = explode('|',trim($user['transfer'],'|'));

			$tmp_transfer_list = $this->transfer->find_all();
			$transfer_list = array_column($tmp_transfer_list, 'title', 'id');
		}
		else
		{
			header('Location: /');exit;
		}
		$where = " orver_flag =  2 and type = 1";
		
		if(empty($transfer_id)){
			$where .= " and lx in (".implode(',',$transfer_ids).")  ";
		}else{
			$where .= " and lx = ".$transfer_id." ";
		}
		$where  .= " and time > '$timetk' and time < '$timetj'";

		$list = $this->systemtransfer_cr->find_all($where,'*');
		$fid_list = array_column($list, 'fid');
		if(empty($fid_list)){
			echo "没有数据" ;
			die ;
		}
		$order_list = $this->systemtransfer->find_all("id in (".implode(',',$fid_list).")");
		
		
		$where_two = " orver_flag =  2 and type = 2";
		
		if(empty($transfer_id)){
			$where_two .= " and lx in (".implode(',',$transfer_ids).")  ";
		}else{
			$where_two .= " and lx = ".$transfer_id." ";
		}
		$where_two  .= " and time > '$timetk' and time < '$timetj'";
		$list_two = $this->systemtransfer_cr->find_all($where_two,'*');

		$final_list = [];
// 		foreach($list as $k => $v){
// 			$final_list[$v['fid']]['fid'] = $v['fid'];
// 			$final_list[$v['fid']]['lx'] = $v['lx'];
// 			$final_list[$v['fid']]['start_type'] = $v['type'];
// 			$final_list[$v['fid']]['start_time'] = date('Y-m-d H:i:s',$v['time']);
// 			$final_list[$v['fid']]['condition'] = json_decode($v['limit_time_str'],true);
// 			$final_list[$v['fid']]['end_time'] = "";
// 			$final_list[$v['fid']]['lx_name'] = isset($transfer_list[$v['lx']])?$transfer_list[$v['lx']]:'';
// 		}
		
// 		foreach($order_list as $k=>$v){
// 			if(isset($final_list[$v['id']])){
// 				$final_list[$v['id']]['number'] = $v['number'];
// 				$final_list[$v['id']]['pm'] = $v['pm'];
// 			}
// 		}
		
// 		foreach($list_two as $k => $v){
// 			if(isset($final_list[$v['fid']])){
// 				if($v['lx'] ==$final_list[$v['fid']]['lx']){
// 					$final_list[$v['fid']]['end_time'] = date('Y-m-d H:i:s',$v['time']);
// 				}
				
// 			}
// 		}
    
        foreach($list as $k => $v){
			$final_list[] = [
				'fid' => $v['fid'],
				'lx' => $v['lx'],
				'start_type' => $v['type'],
				'start_time' => date('Y-m-d H:i:s',$v['time']),
				'condition' => json_decode($v['limit_time_str'],true),
				'end_time' => "",
				'lx_name' => isset($transfer_list[$v['lx']])?$transfer_list[$v['lx']]:'',
			];
		}
		
		foreach($order_list as $k=>$v){
			foreach($final_list as $kk => $vv){
				if($v['id'] == $vv['fid']){
					$final_list[$kk]['number'] = $v['number'];
					$final_list[$kk]['pm'] = $v['pm'];
				}
			}
		}
		
		foreach($list_two as $k => $v){
			foreach($final_list as $kk => $vv){
				if(($v['fid'] == $vv['fid']) && ($v['lx'] == $vv['lx'])){
					$final_list[$kk]['end_time'] = date('Y-m-d H:i:s',$v['time']);
				}
			}
			
		}
        
		$filename = date("Y-m-d")."超时单导出.xls";
		$str = "
        
        
        ";
		$str .= ""; 
		$str .= "";
		foreach ($final_list as $key=>$value) 
		{ 
			if(empty($value['number'])){
				continue;
			}
		    $str .= "";
			$str .= "";
			$str .= "";	
			$str .= "";	
			$str .= "";
			$str .= "";
			$str .= "";
		}
		$str .= "
订单编号
品名
车间
入库日期
出库日期
". $value['number']. "
". $value['pm']. "
". $value['lx_name']. "
". $value['start_time']. "
". $value['end_time']. "
"; 
		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); 
	}

	public function _jiaji(){


		$post = $this->input->post(NULL, TRUE);
	    if(isset($post['page']))  
		{
			$api = $this->input->post('api',true);
		    $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
			
			$transfer = $this->input->post('transfer',true);
			$transfer_ids = $this->input->post('transfer_ids',true);

			$orver_flag = $this->input->post('orver_flag',true);
			
			$timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);

			$transfer_list = $this->transfer->find_all();
			$t = $transfer_list = array_column($transfer_list, 'title', 'id');
			if(isset($_SESSION['api']))
			{
				$user = $this->user->get_api($_SESSION['api']);
				
				$transfer_ids = explode('|',trim($user['transfer'],'|'));
			}
			else
			{
				$transfer_ids = array_keys($t);
			}
			
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
			
			$sql_r = "select s.* from crowd_systemtransfer as s inner join crowd_systemtransfer_cr as c   on c.fid = s.id and c.is_over = 0 and  c.time > ".$timetk ." and c.time < ".$timetj." ";
			if($transfer){
				$sql_r .= " and c.lx = ".$transfer." ";
				
				
			}else{
				foreach($transfer_ids as $k=>$v){
					if($v == 11){
						unset($transfer_ids[$k]);
					}
				}
			    $transfer_str = implode(",",$transfer_ids);
				$sql_r .=  " and c.lx in (".$transfer_str.") ";
			}
			$sql_r .=" where s.is_jiaji = 2 and s.rk not like '%|11|%' " ;
			$rows_r = $this->db->query($sql_r);
			$get_list = $rows_r->result_array();
			
			$total = count($get_list);
			
			$split_list = array_chunk($get_list,$perpage);
		
			$pagenum = ceil(count($split_list));
			$key = $page - 1;
			$list = isset($split_list[$key])?$split_list[$key]:[];
			$final_list = [];
			foreach ($list as $key => $value) {
			   

				$final_list[$key]['id'] = $value['id'];
				$final_list[$key]['number'] = isset($value['number'])?$value['number']:'';
			
				if($value['is_jiaji'] == 2){
		            $final_list[$key]['is_jiaji'] = "加急";
		        }else{
		            $final_list[$key]['is_jiaji'] = "常规";
		        }
			
				$final_list[$key]['pm'] = $value['pm'];
				$final_list[$key]['shipremarks'] = $value['shipremarks'];
				$final_list[$key]['printtime'] = date('Y-m-d H:i:s',$value['printtime']);

				$data = $this->systemtransfer_cr->find_all("fid = '".$value['id']."'");
				
				$info_list[$key]['time'] = "布标打印 ：".date('Y-m-d H:i',$value['ctime12']).'
';
				foreach ($data as $k=>$v)
		        {
					$type = ($v['type']==1)?'入库':'出库';
					
					
					if($v['orver_flag'] == 1){
						if($v['is_over'] == 0){
							$info_list[$key]['time'] .= "".$t[$v['lx']].$type.' ：'.date('Y-m-d H:i',$v['time']) ."  即将超时 ".'
';
							// $info_list[$key]['time'] .= ' 即将超时'.'
';
						}else{
							$info_list[$key]['time'] .= "".$t[$v['lx']].$type.' ：'.date('Y-m-d H:i',$v['time']) ."".'
';
						}
					}elseif($v['orver_flag'] == 2){
						$info_list[$key]['time'] .= "".$t[$v['lx']].$type.' ：'.date('Y-m-d H:i',$v['time']) ."  超 时 ! ".'
';
					}else{
						$info_list[$key]['time'] .= "".$t[$v['lx']].$type.' ：'.date('Y-m-d H:i',$v['time']) ."".'
';
					}
				}
				
				$final_list[$key]['time'] = trim($info_list[$key]['time'],'
');
			}

			
			
		   
		   
		    $over = $total-($start+$perpage);
		    $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($final_list));
		    echo json_encode($rows);exit;
			    
			
		}
		if(isset($_SESSION['api']))
		{
			$user = $this->user->get_api($_SESSION['api']);
			$usp = $user;
		    $pid = "";$tid="";$sid="";$wid="";
		    $purchase = explode('|',trim($user['purchase'],'|'));
			$transfer = explode('|',trim($user['transfer'],'|'));
			$warehouse = explode('|',trim($user['warehouse'],'|'));
			foreach ($purchase as $value) 
		    {
				$pid .= " id = ".$value." or";
			}
			foreach ($transfer as $value) 
		    {
				if($value){
					if($value != 11){
						$tid .= " id = ".$value." or";
					}
				}
			}
			foreach ($warehouse as $value) 
		    {
				$wid .= " id = ".$value." or";
			}
		}
		else
		{
			header('Location: /');exit;
		}
		$kx = '';$zjtab = '';
		
		$transfer = $this->transfer->find_all('1=1 and '.rtrim($tid,'or'));
		
		$this->data['transfer'] = $transfer;
		$transfer_ids = array_column($transfer, 'id');
		$this->data['transfer_ids'] =implode(",",$transfer_ids) ;
		$this->data['vip'] = $user['vip'];
		$this->data['orver_flag'] = $this->input->get('orver_flag', TRUE);
		$this->_Template('transfer_jiaji',$this->data);



		
		
		
		


	}
}