erp/core/CoreApp/controllers/Customer.php

<?php defined('BASEPATH') OR exit('No direct script access allowed');
class Customer extends Start_Controller {
	public function __construct(){
		parent::__construct();
		$this->load->library('session');
		$this->load->_model('Model_customer','customer');
		$this->load->_model('Model_typeclass','typeclass');
		$this->load->_model('Model_shop','shop');
		$this->load->_model('Model_country','country');
		$this->load->_model('Model_express','express');
		$this->load->_model('Model_fullorder','fullorder');
		$this->load->_model('Model_fullordertt','fullordertt');
		$this->load->_model('Model_excel','excel');
		$this->load->_model('Model_whlabel','whlabel');
		$this->load->_model('Model_warehouse','warehouse');
		$this->load->_model('Model_specialstock','specialstock');
		$this->load->_model('Model_ck','ck');
		$this->load->_model('Model_weight','weight');
		$this->load->_model('Model_pay','pay');
		$this->load->_model('Model_setting','setting');
		$this->load->_model('Model_classid','classid');
		$this->load->_model('Model_apiyy','apiyy');
		$this->load->_model('Model_whlabel_fc','whlabel_fc');
		$this->load->_model('Model_hl','hl');
		$this->load->_model('Model_productdescribe','productdescribe');
		$this->load->_model('Model_shopsku','shopsku');
		$this->load->_model('Model_api','api');
		$this->load->_model("Model_logic_order","logic_order");
	}
	//定义方法的调用规则 获取URI第二段值
    public function _remap($arg,$arg_array)
    {
		if($arg == 'add')//添加
        {
             $this->_add();
        }
		else if($arg == 'edit')//修改
        {
             $this->_edit($arg_array);
        }
		else if($arg == 'del')//黑名单
        {
             $this->_del();
        }
		else if($arg == 'change')//更改名单状态
        {
             $this->_change();
        }
		else if($arg == 'mdedit')//修改
        {
             $this->_mdedit($arg_array);
        }
		else if($arg == 'black')//黑名单
        {
             $this->_black();
        }
		else if($arg == 'excela')
        {
             $this->_excela();
        }
		else if($arg == 'temuexcel')
        {
             $this->_temuexcel();
        }
		else if($arg == 'daifakehuexcel')
        {
             $this->_daifakehuexcel();
        }

		else if($arg == 'excel')//下载excel
        {
             $this->_excel();
        }
		else if($arg == 'indexexcel')//下载excel
        {
             $this->_indexexcel();
        }
		else if($arg == 'down')//黑名单
        {
             $this->_down();
        }
		else if($arg == 'bankdown')//下载客户
        {
             $this->_bankdown();
        }
		else if($arg == 'newold')//新老客户比
        {
             $this->_newold();
        }
		else if($arg == 'dgso')
        {
             $this->_dgso();
        }
		else if($arg == 'cx')
        {
             $this->_cx();
        }
		else
		{
			 $this->_index();
		}
    }

	//管理
	public function _index_xxxxxx()//通过索引订单查询购买次数，太慢，暂时抛弃
	{
		$user = $this->user->get_api($_SESSION['api']);
		if($user)
		{
		    $fgshop = "";$sid = "";
		    $user = explode('|',trim($user['shop'],'|'));
			foreach ($user as $value) 
		    {
				$fgshop .= " shop = ".$value." or";
				$sid .= " id = ".$value." or";
			}
		}
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['page']))  
		{
		    $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
			$shop = $this->input->post('shop',true);
			$numphone = $this->input->post('numphone',true);
			$name = $this->input->post('name',true);
			$email = $this->input->post('email',true);
			$address = $this->input->post('address',true);
			$level = $this->input->post('level',true);
			$num = $this->input->post('num',true);
			$timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$where = "1=1 and type = 1 and (".rtrim($fgshop,'or').")";
			if($shop)
            {
                $where  .= " and shop = '$shop'";
            }
			if($numphone)
            {
                $where  .= " and numphone = '$numphone'";
            }
			if($name)
            {
                $where  .= " and name like '%$name%'";
            }
			if($email)
            {
                $where  .= " and email like '%$email%'";
            }
			if($level)
            {
                $where  .= " and level = '$level'";
            }
			if($address)
            {
                $where  .= " and address like '%$address%'";
            }
			if($timetk && $timetj)
            {
                //$where  .= " and ((time > '$timetk' and time < '$timetj') or time = 0)";
				$where  .= " and ((time > '$timetk' and time < '$timetj') or time = '0')";
            }
            //数据排序
            $order_str = "id desc";
			$numdata = array();
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
            //取得信息列表
			if($num > 0)
			{
				$info_list = $this->customer->find_all($where,'id,shop,source,name,email,country,level,money,num,time,count,type',$order_str);
			}
			else
			{
                $info_list = $this->customer->find_all($where,'id,shop,source,name,email,country,level,money,num,time,count,type',$order_str,$start,$perpage);
			}
			foreach ($info_list as $key=>$value)
		    {
				$shop = $this->shop->read($value['shop']);
				$info_list[$key]['shop'] = $shop['shopname'];
				$source = $this->typeclass->read($value['source']);
				$info_list[$key]['source'] = $source['title'];
				if($value['email'] != '0' && $value['email'] != '' && $value['email'] != '无')
		        {
					$gnum =  $this->fullorder->find_count("email = '".$value['email']."' and shop = '".$value['shop']."' and mergeid = 0 and buytime > '$timetk' and buytime < '$timetj'");
				}
		        else
				{
					$gnum = 0;
				}
				$info_list[$key]['num'] =  $gnum;
				if($value['country'] != 0)
				{
				    $country = $this->country->read($value['country']);
				    $info_list[$key]['country'] = $country['name'];
				}
				else
				{
					$info_list[$key]['country'] = "未知";
				}
				if($value['level'] == 1)
				{
					$info_list[$key]['level'] = "网红";
				}
				else if($value['level'] == 2)
				{
					$info_list[$key]['level'] = "批发";
				}
				else if($value['level'] == 3)
				{
					$info_list[$key]['level'] = "店铺转线下";
				}
				else if($value['level'] == 4)
				{
					$info_list[$key]['level'] = "线下其他";
				}
				else if($value['level'] == 5)
				{
					$info_list[$key]['level'] = "店内客户";
				}
				if($value['time'] != 0)
				{
					$info_list[$key]['time'] = date('Y-m-d',$value['time']);
				}
				else
				{
					$info_list[$key]['time'] = "无";
				}
				$info_list[$key]['type'] = "<a href='javascript:void(0);' class='window' data-h='/customer/mdedit/".$value['id']."' data-t='客户下单'><b>下单</b></a>&nbsp;&nbsp;&nbsp;&nbsp;<a class='customer' data-type='2' data-t='yr' data-id='".$value['id']."' href='javascript:void(0);'>移入黑名单</a>";
				if($num >= '10' && $gnum >= '10')
				{
					$numdata[] = $info_list[$key];
				}
				else if ($num > '0' && $num < '10' && $gnum == $num)
				{
					$numdata[] = $info_list[$key];
				}
		    }
			if($num > 0)
			{
				$info_list = array_slice($numdata,$start,$perpage);;
				$total = count($numdata);
			}
			else
			{
				 $total = $this->customer->find_count($where);
			}
		    $pagenum = ceil($total/$perpage);
		    $over = $total-($start+$perpage);
		    $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($info_list));
		    echo json_encode($rows);exit;
		}
		$wlshop = $this->shop->find_all('1=1 and '.rtrim($sid,'or'));
		$this->data['wlshop'] = $wlshop;
		$this->_Template('customer',$this->data);
	}
	public function _index()//通过计数，2020/02/21已校准
	{
		$user = $this->user->get_api($_SESSION['api']);
		$lv_yjtj = 0;
		if($user)
		{
		    $fgshop = "";$sid = "";
		    $users = explode('|',trim($user['shop'],'|'));
			foreach ($users as $value) 
		    {
				$fgshop .= " shop = ".$value." or";
				$sid .= " id = ".$value." or";
			}

			if(in_array($user['id'],[53241,10])){
				$lv_yjtj = 1;
			}
			if($user['vip'] == 1)
			{
				$vip = 1;
			}
			else
			{
				$vip = 0;
			}
		}
		else
		{
	    	$vip = 0;
			header('Location: /');exit;
		}
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['page']))  
		{
		    $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
			$shop = $this->input->post('shop',true);
			$numphone = $this->input->post('numphone',true);
			$name = $this->input->post('name',true);
			$email = $this->input->post('email',true);
			$address = $this->input->post('address',true);
			$country = $this->input->post('country',true);
			$level = $this->input->post('level',true);
			$num = $this->input->post('num',true);
			$timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$where = "1=1 and type = 1 and (".rtrim($fgshop,'or').")";
			if($shop)
            {
                $where  .= " and shop = '$shop'";
            }
			if($numphone != '')
            {
				if($numphone == '0')
				{
					$where  .= " and phone = '$numphone'" ;
				}
				else
				{
                    $where  .= " and numphone = '$numphone' and phone != ''" ;
				}
            }
			if($name)
            {
                $where  .= " and name like '%$name%'";
            }
			if($country)
            {
                $where  .= " and country = '$country'";
            }
			if($email)
            {
                $where  .= " and email like '%$email%'";
            }
			if($level != '')
            {
                $where  .= " and level = '$level'";
            }
			if($address)
            {
                $where  .= " and address like '%$address%'";
            }
			if($num > 0 && $num < 10 && $num != '2a')
            {
                $where  .= " and num = '$num'";
            }
			else if($num > 9)
            {
                $where  .= " and num > '9'";
            }
			else if($num == '2a')
            {
                $where  .= " and num > '1'";
            }
			else if($num == '0')
			{
				$where  .= " and num = '0'";
			}
			else
			{
				$where  .= " and num >= '0'";
			}
			if($timetk && $timetj)
            {
				$where  .= " and ((time > '$timetk' and time < '$timetj') or time = '0')";
            }
            //数据排序
            $order_str = "time desc";
			$numdata = array();
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
            //取得信息列表
			$info_list = $this->customer->find_all($where,'id,shop,source,name,email,phone,country,level,money,num,numphone,time,count,type',$order_str,$start,$perpage);

			// ========== 性能优化：全表缓存替代循环内逐条查询（消除N+1问题）==========
			// shop/country/typeclass 都是几百条的小表，直接全表查出来放内存，比逐条查或IN都高效

			// 全量加载shop表，构建 id => shopname 映射
			$shop_map = [];
			$shop_rows = $this->shop->find_all('1=1', 'id,shopname');
			foreach ($shop_rows as $row) {
				$shop_map[$row['id']] = $row['shopname'];
			}

			// 全量加载typeclass表，构建 id => title 映射
			$source_map = [];
			$source_rows = $this->typeclass->find_all('1=1', 'id,title');
			foreach ($source_rows as $row) {
				$source_map[$row['id']] = $row['title'];
			}

			// 全量加载country表，构建 id => name 映射
			$country_map = [];
			$country_rows = $this->country->find_all('1=1', 'id,name');
			foreach ($country_rows as $row) {
				$country_map[$row['id']] = $row['name'];
			}

			// level值映射表（替代原来的if-elseif链）
			$level_map = [
				1 => '网红',
				2 => '批发',
				3 => '店铺转线下',
				4 => '线下其他',
				5 => '店内客户',
			];

			// 循环内仅做内存字典查找，不再发起数据库查询
			foreach ($info_list as $key => $value) 
		    {
				// 店铺名称映射
				$info_list[$key]['shop'] = isset($shop_map[$value['shop']]) ? $shop_map[$value['shop']] : '';
				// 来源映射
				$info_list[$key]['source'] = isset($source_map[$value['source']]) ? $source_map[$value['source']] : '';
				// 国家映射
				if ($value['country'] != 0) {
					$info_list[$key]['country'] = isset($country_map[$value['country']]) ? $country_map[$value['country']] : '未知';
				} else {
					$info_list[$key]['country'] = "未知";
				}
				// 客户等级映射
				$info_list[$key]['level'] = isset($level_map[$value['level']]) ? $level_map[$value['level']] : '未定义';
				// 时间格式化
				if ($value['time'] != 0) {
					$info_list[$key]['time'] = date('Y-m-d', $value['time']);
				} else {
					$info_list[$key]['time'] = "无";
				}
				// ========== 以下为原代码（注释保留）==========
				// $shop = $this->shop->read($value['shop']);
				// $info_list[$key]['shop'] = $shop['shopname'];
				// $source = $this->typeclass->read($value['source']);
				// $info_list[$key]['source'] = $source['title'];
				// if($value['country'] != 0)
				// {
				//     $country = $this->country->read($value['country']);
				//     $info_list[$key]['country'] = $country['name'];
				// }
				// else
				// {
				// 	$info_list[$key]['country'] = "未知";
				// }
				// if($value['level'] == 1)
				// {
				// 	$info_list[$key]['level'] = "网红";
				// }
				// else if($value['level'] == 2)
				// {
				// 	$info_list[$key]['level'] = "批发";
				// }
				// else if($value['level'] == 3)
				// {
				// 	$info_list[$key]['level'] = "店铺转线下";
				// }
				// else if($value['level'] == 4)
				// {
				// 	$info_list[$key]['level'] = "线下其他";
				// }
				// else if($value['level'] == 5)
				// {
				// 	$info_list[$key]['level'] = "店内客户";
				// }
				// else
				// {
				// 	$info_list[$key]['level'] = "未定义";
				// }
				// if($value['time'] != 0)
				// {
				// 	$info_list[$key]['time'] = date('Y-m-d',$value['time']);
				// }
				// else
				// {
				// 	$info_list[$key]['time'] = "无";
				// }

				
				//$gmcs = $this->fullorder->find_count("email = '".$value['email']."' time > '$timetk' and time < '$timetj'");
				//$info_list[$key]['num'] = $gmcs;
				$info_list[$key]['numphone'] = ($value['num'] > 0)?sprintf("%01.2f",$value['money']/$value['num']):0;
				$info_list[$key]['type'] = "<p><a href='javascript:void(0);' class='window' data-h='/customer/mdedit/".$value['id']."' data-t='客户下单'><b>下单</b></a></p>";
				if($lv_yjtj == 1){
					$info_list[$key]['type'] .= "<p><a href='javascript:void(0);' class='window' data-h='/fullorderabf/yhtj_kh?cid=".$value['id']."' data-t='客户一键下单'><b>一键添加订单</b></a></p>";
				}

				$info_list[$key]['type'] .= "<a class='customer' data-type='2' data-t='yr' data-id='".$value['id']."' href='javascript:void(0);'>移入黑名单</a>";
		    }
			$total = $this->customer->find_count($where);
		    $pagenum = ceil($total/$perpage);
		    $over = $total-($start+$perpage);
		    $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($info_list));
		    echo json_encode($rows);exit;
		}
		$wlshop = $this->shop->find_all('1=1 and '.rtrim($sid,'or'));
		$this->data['wlshop'] = $wlshop;
		$this->data['vip'] = $vip;
		$this->_Template('customer',$this->data);
	}
	
	
	public function _dgso——tmp()
	{
		$user = $this->user->get_api($_SESSION['api']);
		if($user)
		{
		    $fgshop = "";$sid = "";
		    $users = explode('|',trim($user['shop'],'|'));
			foreach ($users as $value) 
		    {
				$fgshop .= " shop = ".$value." or";
				$sid .= " id = ".$value." or";
			}
			if($user['vip'] == 1)
			{
				$vip = 1;
			}
			else
			{
				$vip = 0;
			}
		}
		else
		{
			$vip = 0;
			die("请先登录！！！");
		}
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['page']))  
		{
		    $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
			$shop = $this->input->post('shop',true);
			$numphone = $this->input->post('numphone',true);
			$name = $this->input->post('name',true);
			$email = $this->input->post('email',true);
			$address = $this->input->post('address',true);
			$level = $this->input->post('level',true);
			$num = $this->input->post('num',true);
			$timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$where = "1=1 and (".rtrim($fgshop,'or').")";
			if($numphone)
            {
                $where  .= " and numphone = '$numphone'";
            }
			if($email)
            {
                $where  .= " and email like '%$email%'";
            }
			if($address)
            {
                $where  .= " and address like '%$address%'";
            }
			if($numphone || $email || $address)
			{
			    $d = $this->customer->find_all($where);
				$data = $this->customer->find_all("address like '%".$d[0]['address']."%' or email like '%".$d[0]['email']."%' or numphone like '%".$d[0]['numphone']."%'",'id,shop,source,name,email,country,level,money,num,time,type,numphone,address');
			    //$temp_key = array_column($data,'id');  //键值
                //$Newdata = array_combine($temp_key,$data) ;
			    $cx = array();
			    $info_list = $this->_dgcz($cx,$data);
				$info_list = array_values($info_list);
				$total = count($info_list);
		    $pagenum = ceil($total/$perpage);
		    $over = $total-$perpage;
			}
			else
			{
				  //数据排序
            $order_str = "id desc";
			$numdata = array();
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
            //取得信息列表
			$info_list = $this->customer->find_all($where,'id,shop,source,name,email,country,level,money,num,time,type',$order_str,$start,$perpage);
			$total = $this->customer->find_count($where);
		    $pagenum = ceil($total/$perpage);
		    $over = $total-($start+$perpage);
			}
			foreach ($info_list as $key=>$value) 
		    {
				$shop = $this->shop->read($value['shop']);
				$info_list[$key]['shop'] = $shop['shopname'];
				$source = $this->typeclass->read($value['source']);
				$info_list[$key]['source'] = $source['title'];
				if($value['country'] != 0)
				{
				    $country = $this->country->read($value['country']);
				    $info_list[$key]['country'] = $country['name'];
				}
				else
				{
					$info_list[$key]['country'] = "未知";
				}
				if($value['level'] == 1)
				{
					$info_list[$key]['level'] = "网红";
				}
				else if($value['level'] == 2)
				{
					$info_list[$key]['level'] = "批发";
				}
				else if($value['level'] == 3)
				{
					$info_list[$key]['level'] = "店铺转线下";
				}
				else if($value['level'] == 4)
				{
					$info_list[$key]['level'] = "线下其他";
				}
				else if($value['level'] == 5)
				{
					$info_list[$key]['level'] = "店内客户";
				}
				if($value['time'] != 0)
				{
					$info_list[$key]['time'] = date('Y-m-d',$value['time']);
				}
				else
				{
					$info_list[$key]['time'] = "无";
				}
				if($value['type'] != 2)
				{
				    $info_list[$key]['type'] = "<a href='javascript:void(0);' class='window' data-h='/customer/mdedit/".$value['id']."' data-t='客户下单'><b>下单</b></a>&nbsp;&nbsp;&nbsp;&nbsp;<a class='customer' data-type='2' data-t='yr' data-id='".$value['id']."' href='javascript:void(0);'>移入黑名单</a>";
				}
				else
				{
					$info_list[$key]['type'] = "黑名单客户";
				}
				unset($info_list[$key]['numphone']);
				unset($info_list[$key]['address']);
		    }
			
		    $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($info_list));
		    echo json_encode($rows);exit;
		}
		$wlshop = $this->shop->find_all('1=1 and '.rtrim($sid,'or'));
		$this->data['wlshop'] = $wlshop;
		$this->data['vip'] = $vip;
		$this->_Template('customer_dgso',$this->data);
	}
	
	public function _dgcz($child,$data)
    {
        foreach ($data as $key => $value) 
		{
           if (!isset($child[$value['id']])) 
	       {
               $child[$value['id']] = $value; 
               $rows = $this->customer->find_all("address like '%".$value['address']."%' or email like '%".$value['email']."%' or numphone like '%".$value['numphone']."%'",'id,shop,source,name,email,country,level,money,num,time,type,numphone,address');
               $this->_dgcz($child,$rows);
           }
        }
        return $child;
     }
	 
	//管理
	public function _black()
	{
		/**
		$user = $this->user->get_api($_SESSION['api']);
		if($user)
		{
		    $fgshop = "";$sid = "";
		    $user = explode('|',trim($user['shop'],'|'));
			foreach ($user as $value) 
		    {
				$fgshop .= " shop = ".$value." or";
				$sid .= " id = ".$value." or";
			}
		}
		**/
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['page']))  
		{
		    $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
			$shop = $this->input->post('shop',true);
			$numphone = $this->input->post('numphone',true);
			$name = $this->input->post('name',true);
			$email = $this->input->post('email',true);
			$address = $this->input->post('address',true);
			$xtime = $this->input->post('xtime',true);
			//$where = "1=1 and type = 2 and (".rtrim($fgshop,'or').")";
			$timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$where = "1=1 and type = 2";
			if($shop)
            {
                $where  .= " and shop = '$shop'";
            }
			if($xtime)
            {
                $where  .= " and typetime > '$timetk' and typetime < '$timetj'";
            }
			if($numphone != '')
            {
				if($numphone == '0')
				{
					$where  .= " and phone = '$numphone'" ;
				}
				else
				{
                    $where  .= " and numphone = '$numphone' and phone != ''" ;
				}
            }
			if($name)
            {
                $where  .= " and name like '%$name%'";
            }
			if($email)
            {
                $where  .= " and email like '%$email%'";
            }
			$hmdaddress1 = str_replace(array(' parkway',' drive',' street',' road',' avenue',' boulevard',' alley',' court',' place',' lane',' manor',' terrace',' trail',' view',' cove'),array(' pkwy',' dr',' st',' rd',' av',' blvd',' aly',' ct',' pl',' ln',' mnr',' ter',' trl',' vw',' cv'),strtolower($address));
			$hmdaddress2 = str_replace(array(' pkwy',' dr',' st',' rd',' av',' blvd',' aly',' ct',' pl',' ln',' mnr',' ter',' trl',' vw',' cv'),array(' parkway',' drive',' street',' road',' avenue',' boulevard',' alley',' court',' place',' lane',' manor',' terrace',' trail',' view',' cove'),strtolower($address));
			$hmdaddress3 = str_replace(array(' avenue',' ave',' av'),array(' ave',' avenue',' ave'),strtolower($address));
			if($address)
            {
                $where  .= " and (address like '%$address%' or address like '%$hmdaddress1%' or address like '%$hmdaddress2%' or address like '%$hmdaddress3%')";
            }
            //数据排序
            $order_str = "id desc";
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
            //取得信息列表
            $info_list = $this->customer->find_all($where,'id,shop,source,name,email,address,phone,count,typetime,type',$order_str,$start,$perpage);
			foreach ($info_list as $key=>$value) 
		    {
				$shop = $this->shop->read($value['shop']);
				$info_list[$key]['shop'] = $shop['shopname'];
				$source = $this->typeclass->read($value['source']);
				$info_list[$key]['source'] = $source['title'];
				if($value['typetime'] > 0)
				{
					$info_list[$key]['typetime'] = date('Y-m-d',$value['typetime']);
				}
				else
				{
					$info_list[$key]['typetime'] = '无';
				}
				$info_list[$key]['type'] = "<a class='customer' data-type='1' data-t='yc' data-id='".$value['id']."' href='javascript:void(0);'>移出</a>";
		    }
		    $total = $this->customer->find_count($where);
		    $pagenum = ceil($total/$perpage);
		    $over = $total-($start+$perpage);
		    $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($info_list),'a'=>$hmdaddress1);
		    echo json_encode($rows);exit;
		}
		if(isset($post['s']))  
		{
            $id_arr = $this->input->post('s');
            $id_arr =  explode(',',$id_arr);
            if(!$id_arr)
            {
                echo json_encode(array('msg'=>'参数错误！','success'=>false));exit;
            }
            //循环删除记录
            foreach ($id_arr as $v) 
		    {
                $this->customer->remove($v);
            }
            echo json_encode(array('del'=>$id_arr,'msg'=>'删除记录成功！','success'=>true));exit;
		}
		//$wlshop = $this->shop->find_all('1=1 and '.rtrim($sid,'or'));
		$wlshop = $this->shop->find_all('1=1');
		$this->data['wlshop'] = $wlshop;
		$this->_Template('customer_black',$this->data);
	}
	public function _cx()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['page']))  
		{
		    $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
			$shop = $this->input->post('shop',true);
			$numphone = $this->input->post('numphone',true);
			$name = $this->input->post('name',true);
			$email = $this->input->post('email',true);
			$address = $this->input->post('address',true);
			$xtime = $this->input->post('xtime',true);
			//$where = "1=1 and type = 2 and (".rtrim($fgshop,'or').")";
			$timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$where = "1=1 and type = 2";
			if($shop)
            {
                $where  .= " and shop = '$shop'";
            }
			if($xtime)
            {
                $where  .= " and typetime > '$timetk' and typetime < '$timetj'";
            }
			if($numphone)
            {
                $where  .= " and numphone = '$numphone'";
            }
			if($name)
            {
                $where  .= " and name like '%$name%'";
            }
			if($email)
            {
                $where  .= " and email like '%$email%'";
            }
			$hmdaddress1 = str_replace(array(' parkway',' drive',' street',' road',' avenue',' boulevard',' alley',' court',' place',' lane',' manor',' terrace',' trail',' view',' cove'),array(' pkwy',' dr',' st',' rd',' av',' blvd',' aly',' ct',' pl',' ln',' mnr',' ter',' trl',' vw',' cv'),strtolower($address));
			$hmdaddress2 = str_replace(array(' pkwy',' dr',' st',' rd',' av',' blvd',' aly',' ct',' pl',' ln',' mnr',' ter',' trl',' vw',' cv'),array(' parkway',' drive',' street',' road',' avenue',' boulevard',' alley',' court',' place',' lane',' manor',' terrace',' trail',' view',' cove'),strtolower($address));
			$hmdaddress3 = str_replace(array(' avenue',' ave',' av'),array(' ave',' avenue',' ave'),strtolower($address));
			if($address)
            {
                $where  .= " and (address like '%$address%' or address like '%$hmdaddress1%' or address like '%$hmdaddress2%' or address like '%$hmdaddress3%')";
            }
            //数据排序
            $order_str = "id desc";
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
            //取得信息列表
            $info_list = $this->customer->find_all($where,'id,shop,source,name,email,address,phone,count,typetime',$order_str,$start,$perpage);
			foreach ($info_list as $key=>$value) 
		    {
				$shop = $this->shop->read($value['shop']);
				$info_list[$key]['shop'] = $shop['shopname'];
				$source = $this->typeclass->read($value['source']);
				$info_list[$key]['source'] = $source['title'];
				if($value['typetime'] > 0)
				{
					$info_list[$key]['typetime'] = date('Y-m-d',$value['typetime']);
				}
				else
				{
					$info_list[$key]['typetime'] = '无';
				}
		    }
		    $total = $this->customer->find_count($where);
		    $pagenum = ceil($total/$perpage);
		    $over = $total-($start+$perpage);
		    $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($info_list),'a'=>$hmdaddress1);
		    echo json_encode($rows);exit;
		}
		if(isset($post['s']))  
		{
            $id_arr = $this->input->post('s');
            $id_arr =  explode(',',$id_arr);
            if(!$id_arr)
            {
                echo json_encode(array('msg'=>'参数错误！','success'=>false));exit;
            }
            //循环删除记录
            foreach ($id_arr as $v) 
		    {
                $this->customer->remove($v);
            }
            echo json_encode(array('del'=>$id_arr,'msg'=>'删除记录成功！','success'=>true));exit;
		}
	    $wlshop = $this->shop->find_all('1=1');
		$this->data['wlshop'] = $wlshop;
		$this->_Template('customer_black_cx',$this->data);
	}
	//添加
	public function _add()
	{
		$user = $this->user->get_api($_SESSION['api']);
		if($user)
		{
		    $fgshop = "";$sid = "";
		    $user = explode('|',trim($user['shop'],'|'));
			foreach ($user as $value) 
		    {
				$fgshop .= " shop = ".$value." or";
				$sid .= " id = ".$value." or";
			}
		}
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['shop']))
		{
			$post['shop'] = $this->input->post('shop',true);
			$post['source'] = $this->input->post('source',true);
			$post['level'] = $this->input->post('level',true);
			$post['country'] = $this->input->post('country',true);
			$name = $this->input->post('name',true);
			$post['name'] = str_replace(array('/( |　| |\s)/',"'"),array(' ',"’"),$name);
			$post['phone'] = $this->input->post('phone',true);
			$email = $this->input->post('email',true);
			$post['email'] = str_replace(array('/( |　| |\s)/',"'"),array(' ',"’"),$email);
			$post['province'] = $this->input->post('province',true);
			$post['city'] = $this->input->post('city',true);
			//$post['street'] = $this->input->post('street',true);
			$address = $this->input->post('address',true);
			$post['address'] = str_replace(array('/( |　| |\s)/',"'"),array(' ',"’"),$address);
			//$post['address2'] = $this->input->post('address2',true);
			$post['count'] = $this->input->post('count',true);
			$post['time'] = time();
			$str = $post['phone'];
			if(!$post['shop'])
			{
				echo json_encode(array('msg'=>'店铺不能为空！','success'=>false));exit;
			}
			preg_match_all('/[0-9]/u',$str,$result);
			$numphone = join('',$result[0]);
			$post['numphone'] = $numphone;
			$post['zhcx'] = $post['shop'].'-'.$post['email'];
			$kh = $this->customer->get_email($post['email'],$post['shop']);
			if($kh)
			{
				echo json_encode(array('msg'=>'此客户已存在！','success'=>false));exit;
			}
			if($this->customer->insert($post))
        	{
				echo json_encode(array('msg'=>'添加成功','success'=>true));exit;
       	 	}
       		else
        	{
           		echo json_encode(array('msg'=>'添加失败，请重试','success'=>false));exit;
        	}
		}
		 $country = $this->country->find_all('1=1','id,name','name asc');
		 $this->data['country'] = $country;
		 $wlshop = $this->shop->find_all("(type = 269 or type = 2768)and (".rtrim($sid,'or').")");
		 $this->data['wlshop'] = $wlshop;
		$this->_Template('customer_add',$this->data);
	}
	//修改
	public function _edit($arg_array)
	{
		$user = $this->user->get_api($_SESSION['api']);
		if($user)
		{
		    $fgshop = "";$sid = "";
		    $user = explode('|',trim($user['shop'],'|'));
			foreach ($user as $value) 
		    {
				$fgshop .= " shop = ".$value." or";
				$sid .= " id = ".$value." or";
			}
		}
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['id']))
		{
			$id = $this->input->post('id',true);
			$us = $this->customer->read($id);
			$post['shop'] = $this->input->post('shop',true);
			$post['source'] = $this->input->post('source',true);
			$post['level'] = $this->input->post('level',true);
			$post['country'] = $this->input->post('country',true);
			$name = $this->input->post('name',true);
			$post['name'] = str_replace(array('/( |　| |\s)/',"'"),array(' ',"’"),$name);
			$post['phone'] = $this->input->post('phone',true);
			$email = $this->input->post('email',true);
			$post['email'] = str_replace(array('/( |　| |\s)/',"'"),array(' ',"’"),$email);
			$post['province'] = $this->input->post('province',true);
			$post['city'] = $this->input->post('city',true);
			//$post['street'] = $this->input->post('street',true);
			$address = $this->input->post('address',true);
			$post['address'] = str_replace(array('/( |　| |\s)/',"'"),array(' ',"’"),$address);
			//$post['address2'] = $this->input->post('address2',true);
			$post['type'] = $this->input->post('type',true);
			$post['count'] = $this->input->post('count',true);
			$str = $post['phone'];
			preg_match_all('/[0-9]/u',$str,$result);
			$numphone = join('',$result[0]);
			$post['numphone'] = $numphone;
			$post['zhcx'] = $post['shop'].'-'.$post['email'];
			if($this->customer->save($post,$id))
        	{
         		echo json_encode(array('msg'=>'操作成功！','success'=>true));exit;
       	 	}
       		else
        	{
           		echo json_encode(array('msg'=>'操作失败，请重试','success'=>false));exit;
        	}
		}
		$arg_array = $arg_array[0];
		$customer = $this->customer->read($arg_array);
		$this->data['customer'] = $customer;
		$country = $this->country->find_all('1=1','id,name','name asc');
		$this->data['country'] = $country;
		$wlshop = $this->shop->find_all("(type = 269 or type = 2768) and (".rtrim($sid,'or').")");
		$this->data['wlshop'] = $wlshop;
		if($customer['email'] != '0' && $customer['email'] != '' && $customer['email'] != '无')
		{
		    $fdata =  $this->fullorder->find_all('email = "'.$customer['email'].'" and shop = "'.$customer['shop'].'" and mergeid = 0','orderinfo,state,product,name,email,dtime,shouldmoney','id desc');
		    foreach ($fdata as $k=>$v) 
		    {
				$d = $this->fullorder->get_orderinfo($v['orderinfo']);
				$fdata[$k]['orderinfo'] = "<a href='/fullorder/readonly/".$d['id']."'>".$v['orderinfo']."</a>";
		    	$typeclass = $this->typeclass->read($v['state']);
		    	$fdata[$k]['state'] = $typeclass['spare'];
		    	$fdata[$k]['dtime'] = date('Y-m-d',$v['dtime']);
		    }
		    $this->data['data'] = $fdata;
		}
		$this->_Template('customer_edit',$this->data);
	}
	//删除
	public function _del()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['s']))  
		{
            $id_arr = $this->input->post('s');
            $id_arr =  explode(',',$id_arr);
            if(!$id_arr)
            {
                echo json_encode(array('msg'=>'参数错误！','success'=>false));exit;
            }
            //循环删除记录
			$a=0;
            foreach ($id_arr as $v) 
		    {
				$customer = $this->customer->read($v);
				if($customer['email'] != '0' && $customer['email'] != '' && $customer['email'] != '无')
				{
		    		$fdata =  $this->fullorder->find_count('email = "'.$customer['email'].'" and shop = "'.$customer['shop'].'" and mergeid = 0');
		        }
				if($fdata > 0)
				{
					$a++;
					continue;
				}
				else
				{
                    $this->customer->remove($v);
				}
            }
			if($a > 0)
			{
                echo json_encode(array('del'=>$id_arr,'msg'=>'无订单客户删除成功，有订单的客户无法删除！','success'=>true));
			}
			else
			{
				echo json_encode(array('del'=>$id_arr,'msg'=>'删除记录成功！','success'=>true));
			}
		}
    }
	//操作
	public function _change()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['type']))  
		{
            $type = $this->input->post('type',true);
			$id = $this->input->post('id',true);
			$count = $this->input->post('count',true);
            if($this->customer->save(array('type'=>$type,'count'=>$count,'typetime'=>time()),$id))
        	{
         		echo json_encode(array('msg'=>'操作成功！','success'=>true));exit;
       	 	}
       		else
        	{
           		echo json_encode(array('msg'=>'操作失败，请重试','success'=>false));exit;
        	}
		}
    }
	//修改客户分类
	public function _mdedit($arg_array)
	{
		$user = $this->user->get_api($_SESSION['api']);
		if($user)
		{
			$uu = $user;
		    $fgshop = "";$sid = "";
			$u = $user;
		    $user = explode('|',trim($user['shop'],'|'));
			foreach ($user as $value) 
		    {
				$fgshop .= " shop = ".$value." or";
				$sid .= " id = ".$value." or";
			}
		}
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['shop']))
		{
			$fpcount = $this->input->post('fpcount',true);
			if(!$fpcount)
			{
				echo json_encode(array('msg'=>'需要先清理浏览器缓存，刷新当前页面后再试！','success'=>false));exit;
			}
			$customerid = $this->input->post('customerid',true);
			$shop = $this->input->post('shop',true);
			$sp = $this->shop->read($shop);
			$num = $this->fullorder->find_count('shop = "'.$sp['id'].'" and gtime = "'.date('Ymd',time()).'"');
			$post['source'] = 1;//订单类型：1.线下订单2.PC3.手机
			$post['state'] = 207;//订单状态：207等待发货
			$post['review'] = 2;//审核状态：1.未送审2.待审核3.不通过4取消重审5.审核通过6.自动通过
			$post['print'] = 1;//打印状态：1.不可打印2.未打印3.已打印
			$post['library'] = 1;//出库状态：1.未出库2.已出库3.已退库
			$post['libraryconfirm'] = 1;//出库确认：1.不允许2.允许
			$post['link'] = $sp['link'];
			$post['issku'] = $sp['sku'];
			if($post['print'] != 3)
			{
			    $post['librarynot'] = "订单未打印，未审核或未通过";//不能出库原因
			}
			$orderinfo = $this->input->post('orderinfo',true);
			$post['shop'] = $sp['id'];
			$post['user'] = $sp['shopuser'];
			$post['number'] = $sp['shortname'].'-'.date('ymd',time()).'-'.(substr(strval($num+1+1000),1,3));//编号 
			if($orderinfo != "")
			{
				$ordefin = $this->fullorder->get_orderinfo($orderinfo);
				if($ordefin)
				{
					echo json_encode(array('msg'=>'订单号重复！','success'=>false));exit;
				}
				else
				{
				    $post['orderinfo'] = $orderinfo;
				}
			}
			else
			{
			    $post['orderinfo'] = $sp['id'].date('ymdHis',time()).rand(0,1);//订单号
			}
			// if(empty($post['paypal'])){
			// 	echo json_encode(array('msg'=>'交易号不可为空！','success'=>false));exit;
			// }
			if($post['paypal'] != '')
			{
			    $pp = $this->fullorder->get_paypal($post['paypal']);	
			    if($pp)
			    {
				    echo json_encode(array('msg'=>'此交易号的订单已存在！','success'=>false));exit;
			    }
		    }
			$post['client'] = $this->input->post('client',true);//客户名称
			$btime = $this->input->post('buytime',true);//付款时间
			$post['buytime'] = strtotime($btime);//时间转UX
			$post['dtime'] = time();//订单时间
			$post['gtime'] = date('Ymd',time());//格式化时间
			$post['pay'] = $this->input->post('pay',true);//支付方式
			$post['capital'] = $this->input->post('capital',true);//资金状态
			$post['type'] = $this->input->post('warehouse',true);//发货仓库
			$post['currency'] = $this->input->post('currency',true);//币种
			$currency = $this->typeclass->read($post['currency']);
			$post['currencytitle'] = $currency['title'];//币种名称
			$post['freight'] = $this->input->post('freight',true);//运费
			$post['expressmoney'] = $this->input->post('expressmoney',true);//物流金额
			$post['shouldmoney'] = $this->input->post('shouldmoney',true);//应收金额
			$post['skje'] = $post['shouldmoney'];//收款金额
			$product = $this->input->post('product');//产品名称
			$product = str_replace(array('%26','%2B'),array('&','+'),$product);
			$post['product'] = preg_replace('/( |　| |\s)/',' ',$product);
			$orderremarks = $this->input->post('orderremarks');//订单备注
			$orderremarks = str_replace(array('%26','%2B'),array('&','+'),$orderremarks);
			$post['orderremarks'] = preg_replace('/( |　| |\s)/',' ',$orderremarks);
			$shipremarks = $this->input->post('shipremarks');//仓库品名
			$shipremarks = str_replace(array('%26','%2B'),array('&','+'),$shipremarks);//仓库品名
			$post['shipremarks'] = preg_replace('/( |　| |\s)/',' ',$shipremarks);
			$post['email'] = $this->input->post('email',true);//邮箱
			$name = $this->input->post('name',true);//名称
			$post['name'] = preg_replace('/( |　| |\s)/',' ',$name);
			$post['phone'] = $this->input->post('phone',true);//电话
			$post['phone'] = preg_replace('/\D/s','',$post['phone']);
			$post['country'] = $this->input->post('country',true);//国家
			$ct = $this->country->read($post['country']);//国家
			$post['al'] = $ct['lb'];//国家二字码
			$post['province'] = $this->input->post('province',true);//省、州
			$post['province'] = preg_replace("/^[\s\v".chr(227).chr(128)."]+/","", $post['province']); //替换开头空字符
            $post['province'] = preg_replace("/[\s\v".chr(227).chr(128)."]+$/","", $post['province']); //替换结尾空字符
			$post['city'] = $this->input->post('city',true);//城市
			$post['city'] = preg_replace("/^[\s\v".chr(227).chr(128)."]+/","", $post['city']); //替换开头空字符
            $post['city'] = preg_replace("/[\s\v".chr(227).chr(128)."]+$/","", $post['city']); //替换结尾空字符
			$post['zipcode'] = $this->input->post('zipcode',true);//邮编
			$post['zipcode'] = preg_replace("/^[\s\v".chr(227).chr(128)."]+/","", $post['zipcode']); //替换开头空字符
            $post['zipcode'] = preg_replace("/[\s\v".chr(227).chr(128)."]+$/","", $post['zipcode']); //替换结尾空字符
			$post['address'] = $this->input->post('address',true);//地址
			$post['printtype'] = $this->input->post('printtype',true);//打印类型
			$fpdata = $this->input->post('fpdata');//购买产品内容
			$fpdata = str_replace(array('%26','%2B'),array('&','+'),$fpdata);
			$post['fpdata'] = $fpdata;
			$post['sbpm'] = $this->input->post('sbpm',true);//申报品名
			$post['zwpm'] = $this->input->post('zwpm',true);//中文品名
			$post['ts'] = $this->input->post('ts',true);//条数
			$post['dtsbjz'] = $this->input->post('dtsbjz',true);//单条申报价
			$post['zsbjz'] = $this->input->post('zsbjz',true);//总申报价
			$post['zzl'] = $this->input->post('zzl',true);//总重量
			$post['zjs'] = $this->input->post('zjs',true);//总件数
			$post['express'] = $this->input->post('express',true);//快递公司
			$post['printtype'] = $this->input->post('printtype',true);//打印类型
			$post['quantity'] = $this->input->post('quantity',true);//数量
			$post['paypal'] = $this->input->post('paypal',true);//支付号
			$post['guarantee'] = $this->input->post('guarantee',true);//卖家保障
			$post['msg'] = $this->input->post('msg',true);//发送留言类型
			$post['ioss'] = $this->input->post('ioss',true);
			$post['sbpm'] = $this->input->post('sbpm',true);
			$pay = $this->pay->get_typeclass($post['pay']);
			$yga = $post['shouldmoney'];
			$post['budget'] = 0;
			if($pay)
			{
				$ygc = $pay['estimaterate'];//预估到账公式
				$ifbudget = eval("return $yga*1.$ygc;");
				$post['estimaterate'] = $pay['estimaterate'];
				if($ifbudget > 0)
				{
				    $post['budget'] = eval("return $yga*1.$ygc;");//预估到帐金额
				}
			}
			else
			{
				$ygb = $sp['estimaterate'];//店铺默认到账公式
				$ifbudget = eval("return $yga*1.$ygb;");
				$post['estimaterate'] = $sp['estimaterate'];
				if($ifbudget > 0)
				{
		    	    $post['budget'] = eval("return $yga*1.$ygb;");//预估到帐金额
				}
			}
			$baddress = $this->input->post('baddress',true);
			$saddress = $this->input->post('saddress',true);
			$baddress = array_reverse(explode(',',$baddress));
			$saddress = array_reverse(explode(',',$saddress));
			$bar = '';$sar = '';
			$cr = $this->country->read($post['country']);
			$baddress[1] = $cr['lb'];
			$saddress[1] = $cr['lb'];
			$baddress = array_reverse($baddress);
			$saddress = array_reverse($saddress);
			for($i=0;$i<count($baddress);$i++)
			{
				$bar .= $baddress[$i].',';
			}
			for($i=0;$i<count($saddress);$i++)
			{
				$sar .= $saddress[$i].',';
			}
			$post['baddress'] = rtrim($bar,',');//卖家保障
			$post['saddress'] = rtrim($sar,',');//卖家保障
			$whlabel = $this->input->post('whlabel',true);
			if($post['express'] == 2 && (stripos($post['name'],'&') !== false || stripos($post['name'],"'") !== false))
			{
				echo json_encode(array('msg'=>'USPS收件人或公司名不可用特殊符号！','success'=>false));exit;
			}
			if(strlen($post['client']) > 35 || strlen($post['name']) > 35)//收件人姓名或公司名不允许超过35位
			{
				echo json_encode(array('msg'=>'收件人姓名或公司名不可超过35个字符！','success'=>false));exit;
			}
			if(($post['express'] == '5' || $post['express'] == '24' || $post['express'] == '42' || $post['express'] == '31') && $post['country'] != 192)
			{
				echo json_encode(array('msg'=>'非美国无法选择Fedex、DHL官方-美国！','success'=>false));exit;
			}
			if($post['express'] == '3' && $post['country'] != 192 && $post['country'] != 35)
			{
				echo json_encode(array('msg'=>'非美国和加拿大无法选择UPS！','success'=>false));exit;
			}
			if($post['express'] == '3' && $post['country'] == 35 && $post['zsbjz'] > 20)
			{
				echo json_encode(array('msg'=>'UPS加拿大最高申报不可超过20','success'=>false));exit;
			}
			if($post['express'] == '2' && $post['warehouse'] != 5)
			{
				echo json_encode(array('msg'=>'非美国仓无法选择USPS！','success'=>false));exit;
			}
			if($post['express'] == '99' && $post['bx'] > 0)
			{
				echo json_encode(array('msg'=>'此物流不允许购买保险','success'=>false));exit;
			}
			if($post['express'] == 42 && $post['sbpm'] != 'Human Hair Wigs' && $post['sbpm'] != 'Human Hair Goods')//$post['express'] == 3 || 
			{
				echo json_encode(array('msg'=>'此快递方式必须选择Human Hair Wigs/Human Hair Goods！','success'=>false));exit;
			}
			// 
			if($post['country'] != 192 && $post['express'] == 1 && $post['sbpm'] != 'Synthetic Hair Wigs' && $post['sbpm'] != 'Synthetic Hair Goods')//$post['express'] == 3 || 
			{
				echo json_encode(array('msg'=>'非美国选择官方DHL必须选择Synthetic Hair Wigs/Synthetic Hair Goods','success'=>false));exit;
			}
			if($post['pay'] == '22' && ($post['paypal'] == '' || $post['guarantee'] == ''))
			{
				echo json_encode(array('msg'=>'交易号和卖家保障必须填写','success'=>false));exit;
			}
			if($post['pay'] == '23' && $post['paypal'] == '')
			{
				echo json_encode(array('msg'=>'交易号必须填写','success'=>false));exit;
			}
			if(empty($post['paypal'])){
				echo json_encode(array('msg'=>'交易号必须填写','success'=>false));exit;
			}
			$express = $this->express->read($post['express']);
			if($post['zsbjz'] > $express['sbjz'])
			{
				echo json_encode(array('msg'=>'总申报价值不可超出'.$express['sbjz'],'success'=>false));exit;
			}
			if($post['shouldmoney'] > $express['shouldmoney'] && $express['shouldmoney'] != 0)
			{
				echo json_encode(array('msg'=>'订单金额不可超出'.$express['shouldmoney'],'success'=>false));exit;
			}
			if($express['ioss'] == 1 && $post['ioss'] == '')
			{
				 echo json_encode(array('msg'=>'此快递方式必须选择IOSS！','success'=>false));exit;
			}
			if(strlen($post['address']) > $express['addresssize'] || strlen($post['address2']) > $express['addresssize'])
			{
				echo json_encode(array('msg'=>'此快递方地址不可超出'.$express['addresssize'].'个字符','success'=>false));exit;
			}
			if(strlen($post['address']) < 5)
			{
				echo json_encode(array('msg'=>'地址不可留空！','success'=>false));exit;
			}
			if($post['express'] == '2' && $post['zzl'] > '16' && $post['js'] == '0')
			{
				echo json_encode(array('msg'=>'重量大于16不可按Ground Advantage提交！','success'=>false));exit;
			}
			if($post['express'] == '2' && isset($post['js']) && $post['js'] == '0'&& $post['qm'] == '1')
			{
				echo json_encode(array('msg'=>'Ground Advantage不可使用签名服务！','success'=>false));exit;
			}
			if(($post['express'] == '3' || $post['express'] == '42' || $post['express'] == '24') && $post['shouldmoney'] < 1)
			{
				echo json_encode(array('msg'=>'零金额订单不可发 UPS/DHL官方-美国/Fedex(杭州)','success'=>false));exit;
			}
			if($post['express'] == '42' && $post['zsbjz'] < 1)
			{
				echo json_encode(array('msg'=>'零申报金额不可发 DHL官方-美国','success'=>false));exit;
			}
			if($post['express'] == '6' && $post['province'] == '')
			{
				echo json_encode(array('msg'=>'选择DPEX必须填写州信息','success'=>false));exit;
			}


			//仅独立站 地址美国对电话 10或者11位进行判断
			if($post['country'] == 192){
				if((strlen($post['phone'])!= 10) && (strlen($post['phone'])!= 11)){
					echo json_encode(array('msg'=>'美国电话号码应为10/11位！','success'=>false));exit;
				}
			}

			//减少代码复用吧
			$lo_ret = $this->logic_order->checkEditCustomer($post);
			if($lo_ret['code'] != 1){
				echo json_encode(array('msg'=>$lo_ret['msg'],'success'=>false));exit;
			}
			/**
			$post['saddress']
			if($post['printtype'] == 1)//如果是运单
			{
				$post['productdescription'] = $this->input->post('productdescription',true);
			    $post['customs'] = $this->input->post('customs',true);
			}
			**/
			//开始注释 xyxg
			/**
			$warehousenew = $this->warehouse->read($post['type']);
			$ft = array();
			$ftdata = explode('|',rtrim($fpcount,'|'));
			foreach ($ftdata as $va)
			{
				$ftitle = '';
				$va = explode('-',trim($va,'-'));
				foreach ($va as $v)
			    {
					$v = $this->typeclass->read($v);
					$ftitle .= $v['title'].' ';
				}
				$ft[] = rtrim($ftitle,' ');
			}
			$kcyz = $this->whlabel->get_kc($post['state'],$post['state'],$warehousenew['zd'],$warehousenew['ys'],$post['type'],$whlabel,$fpcount,$ft,$post['number'],$shop);//新添加订单老状态state和新状态state一样，不用走删除占用步奏
			if($kcyz['t'] > '0')
			{
				echo $kcyz['m'];exit;
			}
			else
			{
			    if($this->fullorder->insert($post))
        	    {
					$cusnum = $this->customer->read($customerid);
					$this->customer->save(array('num'=>$cusnum['num']+1,'time'=>$post['buytime']),$customerid);
         		    echo json_encode(array('msg'=>'下单成功','success'=>true));exit;
       	 	    }
       		    else
        	    {
           		    echo json_encode(array('msg'=>'下单失败，请重试','success'=>false));exit;
        	    }
			}
			//结束注释 
			**/
			$dtctitle = array();
			$dictionaries = $this->typeclass->find_all();
			foreach ($dictionaries as $v)
			{
				$dtctitle[$v['id']] = array($v['title'],$v['bqsku']);
			}
			$fpdata = $post['fpdata'];
			if(stripos($fpdata,'-128-') !== false || stripos($fpdata,'-127-') !== false)
			{
			    $dfp =  explode(';',trim($fpdata,';'));
			    $fdata = '';
			    foreach ($dfp as $k=>$v)
			    {
				    $ptitleb = '';
				    $fp = explode('|',trim($v,'|'));
				    $fp0 = explode(',',$fp[0]);
					if(isset($fp0[1]))
					{
				        $fp1 = explode('-',trim($fp0[1],'-'));
					}
					else
					{
						$fp1 = explode('-',trim($fp[0],'-'));
					}
				    foreach ($fp1 as $vv)
				    {
					    $ptitleb .= isset($dtctitle[$vv])?$dtctitle[$vv][0].' ':'';
				    }
					if(isset($fp0[1]))
					{
				         $ptitleb .= $dtctitle[$fp0[0]][1].'inch ';
				         $fp[1] = $ptitleb;
					}
				    $fdata .= implode("|",$fp).";";
			    }
			    $fpdata = $fdata;
			}
			
			$warehouse = $this->warehouse->read($post['type']);
			if($warehouse['bdcountry'] != 0 && $post['country'] != $warehouse['bdcountry'])
			{
				echo json_encode(array('msg'=>'当前国家无法选择'.$warehouse['title'].'！','success'=>false));exit;
			}
			    $kcyz = $this->ck->get_kc($post['state'],$warehouse,$post['shop'],$post['number'],$whlabel,$fpdata);
			    if($kcyz['t'] > '0')
			    {
					echo $kcyz['m'];exit;
			    }
			    else if($kcyz['fpdata'] != '')
			    {
				    $post['whlabel'] = $kcyz['whlabel'];
				    $post['fpdata'] = $kcyz['fpdata'];
			    }
				$fl = $this->ck->get_fl($warehouse['hz'],$whlabel,$fpdata);
				$post['sfxh'] = $fl['sfxh'];
				$post['ckfl'] = $fl['ckfl'];
				
				//查询净重开始
			$post['jweight'] = $this->weight->get_weightcx($post['fpdata']);
			//查询净重结束
					$cusnum = $this->customer->read($customerid);
					$this->customer->save(array('num'=>$cusnum['num']+1,'time'=>$post['buytime']),$customerid);
					unset($post['id']);
					$this->fullorder->insert($post);
					echo json_encode(array('msg'=>'下单成功','success'=>true));exit;	
		}
		$arg_array = $arg_array[0];//用户ID
		$customer = $this->customer->read($arg_array);//用户信息
		$this->data['customer'] = $customer;
		$country = $this->country->find_all('1=1','id,name','name asc');//国家
		$this->data['country'] = $country;
		$express = $this->express->find_all();//物流商
		$this->data['express'] = $express;
		$bm = $this->country->read($customer['country']);
		$this->data['bm'] = $bm;
		$wlshop = $this->shop->find_all('1=1 and '.rtrim($sid,'or'));
		$this->data['wlshop'] = $wlshop;
		$this->data['user'] = $u['userid'];
		$this->_Template('customer_mdedit',$this->data);
	}
	//上传excel
	public function _excela()
	{
		$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';
        $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;
                }
			}
			$i = 0;
		    $this->db->trans_begin();
		    foreach ($list as $key=>$value)
		    {
				$value['1'] = $value['1']?str_replace(array('/( |　| |\s)/',"'"),array(' ',"’"),$value['1']):'';
				$value['7'] = $value['7']?str_replace('/( |　| |\s)/','',$value['7']):'';
				if($value['7'] == "" || $value['11'] == "")
				{
					$i++;
					continue;
				}
				else
				{
					$value['7'] = str_replace('/( |　| |\s)/','',$value['7']);
				}
				$shop = $this->shop->get_name($value['9']);
				if(!$shop)
				{
					$i++;
					continue;
				}
				if($value['11'] == 2)
				{
				    $repeat = $this->customer->get_address($value['1']);//只判断地址
				}
				else
				{
					$repeat = $this->customer->find_all('email = "'.$value[7].'" and shop = "'.$shop['id'].'"');//只判断邮箱
				}
				/*  判断邮箱和地址
				if($value['1'] == "" || $value['1'] == " ")
				{
					if($value['7'] == "" || $value['7'] == " ")
					{
						$repeat = 1;
					}
					else
					{
						$repeat = $this->customer->get_email($value['7']);
					}
				}
				else
				{
					$repeat = $this->customer->get_address($value['1']);
				}
				*/
				if(isset($repeat[0]['type']))
				{
					if($repeat[0]['type'] == $value['11'])
					{
						$i++;
					}
					else if($repeat[0]['type'] != $value['11'])
					{
						$this->customer->save(array('type'=>$value['11']),$repeat[0]['id']);
					}
				}
				else
				{
					$source = $this->typeclass->get_title($value['10']);
					if($source)
					{
					    $post['name'] = ($value['0'] && $value['0'] != 'NULL')?str_replace(array('/( |　| |\s)/',"'"),array(' ',"’"),$value['0']):'';
					    $post['email'] = $value['7'];
						if($value['5'] != '')
						{
					        $country = $this->country->get_ename(str_replace(array('/( |　| |\s)/',"'"),array(' ',"’"),$value['5']));
							$post['country'] = $country['id'];
						}
						$post['level'] = $value['8']?$value['8']:5;
					    $post['phone'] = $value['6']?$value['6']:'';
					    $post['province'] = $value['3']?$value['3']:'';
					    $post['city'] = $value['2']?$value['2']:'';
					    $post['address'] = $value['1'];
					    $post['zipcode'] = $value['4']?$value['4']:'';
						$post['shop'] = $shop['id'];
					    $post['source'] = $source['id'];
						$post['type'] = $value['11'];
						$val12 = $value['12']?$value['12']:'';
						$post['count'] = $val12;
						$str = $post['phone'];
						preg_match_all('/[0-9]/u',$str,$result);
						$numphone = join('',$result[0]);
						$post['numphone'] = $numphone;
		    	        $this->customer->insert($post);
					}
                }
			}
			if ($this->db->trans_status() === FALSE)
            {
				$this->db->trans_commit();
				echo json_encode(array('msg'=>'添加失败，请重试','success'=>false));exit;
            }
            else
            {
				if(count($list) == $i)
				{
					$til = '导入全部失败！请检查导入信息';
				}
				else if(count($list) > $i && $i != 0)
				{
					$til = '部分导入成功！'.$i.'条信息有问题，请排查';
				}
				else  if($i < 1)
				{
					$til = '导入成功！';
				}
                $this->db->trans_commit();
				echo json_encode(array('msg'=>$til,'success'=>true));exit;
            }
        }
		else
		{
			echo json_encode(array('msg'=>'上传失败！','t'=>$this->upload->display_errors(),'success'=>false));exit;
		}
    }
	
	
	
	public function _temuexcel()
	{
		$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';
        $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;
                }
			}
			$i = 0;
			$gethl = $this->hl->get_hl();//获取即时汇率
			$dictionaries = $this->typeclass->find_all('spare!= "" and classid != 1 and classid != 2 and classid != 3 and classid != 4 and classid != 5 and classid != 11 and classid != 16 and classid != 17 and classid != 20 and classid != 21 and classid != 23 and classid != 24 and classid != 29 and classid != 30 and classid != 31 and classid != 32');
			$dtc = array();
			foreach ($dictionaries as $v) 
			{
				if(stripos($v['spare'],'|') !== false)//如果有多个值
				{
					$v['spare'] = explode('|',$v['spare']);
					foreach ($v['spare'] as $k=>$vs) 
		        	{
						if(stripos($v['zh'],'|') !== false)
						{
							$vzh = explode('|',$v['zh']);
							$dtc[strtolower($vs)] = array('classid'=>$v['classid'],'zh'=>$vzh[$k],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$vs);
						}
						else
						{
					   	 $dtc[strtolower($vs)] = array('classid'=>$v['classid'],'zh'=>$v['zh'],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$vs);
						}
					}
				}
				else
				{
					$dtc[strtolower($v['spare'])] = array('classid'=>$v['classid'],'zh'=>$v['zh'],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$v['spare']);
				}
			
			}
			$dk = array();
			$dictionaries2 = $this->typeclass->find_all();
			foreach ($dictionaries2 as $v)
			{
				$dtctitle[$v['id']] = $v['title'];
				$dk[$v['id']] = $v['bqsku'];
			}
			/*  匹配结束  */    
			/*  价格加入  */  
			$money = array();
			$productdescribe = $this->productdescribe->find_all('1=1');
			foreach ($productdescribe as $v) 
			{
				$money[$v['number']] = array();
			}
			/*  价格加入  */
			/*  匹配ID加入  */
			$int = array();
			$intdata = $this->typeclass->find_all('classid=14','id,spare');
			foreach ($intdata as $v) 
			{
				$v['spare'] = explode('|',$v['spare']);
				$int[$v['id']] = $v['spare'][0];
			}	
			/*  匹配ID加入  */
			$zjsku = array();
			$shopsku = $this->shopsku->find_all();
			foreach ($shopsku as $val) 
			{
				$ss = explode(',',trim($val['shop'],','));
				foreach ($ss as $v) 
			    {
					if(isset($zjsku[$v]))
					{
						$zjsku[$v] .= ','.trim($val['sku'],',');
					}
					else
					{
						$zjsku[$v] = trim($val['sku'],',');
					}
				}
			}	
			/*  匹配ID结束  */
		    $this->db->trans_begin();
			$error = "";
		    foreach ($list as $key=>$value)
		    {
				$addtess = ($value['15']!='--'?$value['15'].' ':'').($value['14']!='--'?$value['14'].' ':'').$value['13'];
				$addtess = str_replace(array('/( |　| |\s)/',"'"),array(' ',"’"),$addtess);
				$repeat = $this->customer->find_all('phone = "'.$value[11].'" and address = "'.($value['15']!='--'?$value['15'].' ':'').($value['14']!='--'?$value['14'].' ':'').$value['13'].'" and shop = 19');//判断电话地址
				$sku = $value['8'];
				$je = (isset($value['28']))?$value['28']:0;
				// $value['29'] = str_replace('/','-',$value['29']);
				// $dtime = strtotime($value['29']);
				if(!empty($value['29'])){
					$value['29'] = str_replace('/','-',$value['29']);
					$dtime = strtotime($value['29']);
					if($dtime > time()){
						$dtime = time();
					}
					if(empty($dtime)){
						$dtime = time();
					}
				}else{
					$dtime = time();
				}
				
				$post['name'] = ($value['10'] && $value['10'] != 'NULL')?str_replace(array('/( |　| |\s)/',"'"),array(' ',"’"),$value['10']):'';
				$post['email'] = $value['12'];
				$res = $this->logic_order->checkEmail($post['email']);
				if(!$res){
					$error .= "第".($key+2)."行邮箱格式错误;";
					$i++;
					continue;
				}
				if($value['20'] != '')
				{
					$country = $this->country->get_ename(str_replace(array('/( |　| |\s)/',"'"),array(' ',"’"),$value['20']));
					$post['country'] = $country['id'];
				}
				$post['level'] = 4;
				$post['phone'] = $value['11']?$value['11']:'';
				$post['province'] = $value['18']?$value['18']:'';
				$post['city'] = $value['17']?$value['17']:'';
				$post['address'] = $addtess;
				$post['zipcode'] = $value['19']?$value['19']:'';
				$post['shop'] = 19;
				$post['source'] = 2;
				$post['type'] = 1;
				$post['count'] = '';
				$post['time'] = $dtime;
				$str = $post['phone'];
				preg_match_all('/[0-9]/u',$str,$result);
				$numphone = join('',$result[0]);
				$post['numphone'] = $numphone;
				if(!isset($repeat[0]))
				{
		    	    $this->customer->insert($post);
                }
				else
				{
					$this->customer->save(array('num'=>$repeat[0]['num']+1),$repeat[0]['id']);
				}
				$sbsku = '';
				$whlabel = $this->whlabel->get_sku($sku);
				if($whlabel)
				{
					$w = explode('-',trim($whlabel['features'],'-'));
					foreach ($w as $v)
		            {
						if(isset($dk[$v]))
						{
							$sbsku .= $dk[$v].'-';
						}
					}
				}
				$sbsku = trim($sbsku,'-');
				$time = time();
				$shop = $this->shop->read(19);
				$ddpost['orderremarks'] = isset($value['30'])?$value['30']:'';
				$ddpost['shop'] = $shop['id'];//店铺ID
				$ddpost['user'] = $shop['shopuser'];//店铺负责人
				$orderid = 0;
				$ddpost['orderid'] = 0;
				$ddpost['product'] = '';//产品名称
				$ddpost['link'] = '';//产品链接
				$ddpost['issku'] = $sku;
				$ddpost['quantity'] = rtrim($value['3'],';');
				$ddpost['clientremarks'] = '';//客户备注
				//$ddpost['paypal'] = '';//交易号
				$ddpost['guarantee'] = '';//卖家保障
				$ddpost['parameter'] = '';//属性
				$ddpost['shippingmethod'] = '';//用户选择快递方式及运费金额
				$ddpost['source'] = 2;//订单类型
				$ddpost['type'] = 1;//发货仓库
				$ddpost['capital'] = 3;//资金支付状况，全部付款
				$num = $this->fullorder->find_count('gtime = "'.date('Ymd',$dtime).'" and shop = 19');
				$ddpost['number'] = $shop['shortname'].'-'.date('ymd',$dtime).'-'.(substr(strval($num+1+1000),1,3));//编号
				$ddpost['orderinfo'] =  preg_replace('/[^0-9]/', '', $value['0']);//订单号
				$d = $this->fullorder->get_orderinfo($ddpost['orderinfo']);
				if(isset($d['id']))
				{
					$error .= "第".($key+2)."行订单号重复;";
					$i++;
					continue;
				}
				$ddpost['paypal'] = $ddpost['orderinfo'];
				$ddpost['insurance'] = 0;//运输保险费用
				$ddpost['baddress'] = '';
				$ddpost['saddress'] = '';
				$ddpost['country'] = $country['id'];//此国家的ID
				$ddpost['al'] = $country['lb'];//联邦名称
				$ddpost['bname'] = $post['name'];//名称
				$ddpost['sname'] = $post['name'];//名称
				$ddpost['client'] = $post['name'];//公司名称
				$ddpost['name'] = $post['name'];//收件人名称
				$ddpost['phone'] = $post['phone'];//收件人电话
				$ddpost['email'] = $post['email'];//客户邮箱
				$ddpost['zipcode'] = $post['zipcode'];//收件人邮编
				$ddpost['province'] = $post['province'];//收件人省份
				$ddpost['city'] = $post['city'];//收件人城市
				$ddpost['address'] = $post['address'];//收件人地址
				$ddpost['shouldmoney'] = $je;//应收金额
				$ddpost['skje'] = $je;//收款金额
				$ddpost['ismoney'] = '';//支付币种金额
				$ddpost['shouldmoney'] = $je;//金额
			    $ddpost['budget'] = $je;//预估到帐金额
				$ddpost['buytime'] = $dtime;//格式化付款时间
				$ddpost['dtime'] = $dtime;//订单时间
				$ddpost['gtime'] = date('Ymd',$dtime);//格式化订单时间
				$ddpost['currencytitle'] = 'USD';//结算币种名称
				$ddpost['currency'] = 219;//钱币ID
				$ddpost['time'] = time();//同步时间
				$ddpost['shopify'] = 0;//同步时间
				$ddpost['hl'] = '6.4';//汇率
				$matching = $this->api->matching($ddpost['quantity'],$sbsku,$dtc,$money,$int,$dtctitle,$shop);
				$ddpost['shipremarks'] = $matching['title'];
				$ddpost['cost'] = $matching['cost'];
				$ddpost['purchase'] = $matching['purchase'];
				$ddpost['fpdata'] = $matching['product'];
				$ddpost['whlabel'] = $matching['whlabel'];
				$ddpost['slpx'] = $matching['wcslpx'];
				$ddpost['state'] = 207;
				$ddpost['type'] = 17;
				$this->fullorder->insert($ddpost);
			}
			
			if ($this->db->trans_status() === FALSE)
            {
				$this->db->trans_commit();
				echo json_encode(array('msg'=>'添加失败，请重试','success'=>false));exit;
            }
            else
            {
				if(count($list) == $i)
				{
					$til = '导入全部失败！请检查导入信息;'.$error;
				}
				else if(count($list) > $i && $i != 0)
				{
					$til = '部分导入成功！'.$i.'条信息有问题，请排查;'.$error;
				}
				else  if($i < 1)
				{
					$til = '导入成功！';
				}
                $this->db->trans_commit();
				echo json_encode(array('msg'=>$til,'success'=>true));exit;
            }
        }
		else
		{
			echo json_encode(array('msg'=>'上传失败！','t'=>$this->upload->display_errors(),'success'=>false));exit;
		}
    }
	
	//代发客户导入
	public function _daifakehuexcel()
	{
		$shopid = 0;
		$user = $this->user->get_api($_SESSION['api']);
		if($user)
		{
		    $users = explode('|',trim($user['shop'],'|'));
			if(count($users) == 1){
				$shopid = $users[0];
			}else{
				echo json_encode(array('msg'=>"此账号不能用于该功能！",'success'=>true));exit;
			}
		}
		
		if(empty($shopid)){
			echo json_encode(array('msg'=>"系统无法识别店铺！",'success'=>true));exit;
		}
		
		$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';
        $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;
                }
			}
			$i = 0;
			$gethl = $this->hl->get_hl();//获取即时汇率
			$dictionaries = $this->typeclass->find_all('spare!= "" and classid != 1 and classid != 2 and classid != 3 and classid != 4 and classid != 5 and classid != 11 and classid != 16 and classid != 17 and classid != 20 and classid != 21 and classid != 23 and classid != 24 and classid != 29 and classid != 30 and classid != 31 and classid != 32');
			$dtc = array();
			foreach ($dictionaries as $v) 
			{
				if(stripos($v['spare'],'|') !== false)//如果有多个值
				{
					$v['spare'] = explode('|',$v['spare']);
					foreach ($v['spare'] as $k=>$vs) 
		        	{
						if(stripos($v['zh'],'|') !== false)
						{
							$vzh = explode('|',$v['zh']);
							$dtc[strtolower($vs)] = array('classid'=>$v['classid'],'zh'=>$vzh[$k],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$vs);
						}
						else
						{
					   	 $dtc[strtolower($vs)] = array('classid'=>$v['classid'],'zh'=>$v['zh'],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$vs);
						}
					}
				}
				else
				{
					$dtc[strtolower($v['spare'])] = array('classid'=>$v['classid'],'zh'=>$v['zh'],'id'=>$v['id'],'jm'=>$v['jm'],'spare'=>$v['spare']);
				}
			
			}
			$dk = array();
			$dictionaries2 = $this->typeclass->find_all();
			foreach ($dictionaries2 as $v)
			{
				$dtctitle[$v['id']] = $v['title'];
				$dk[$v['id']] = $v['bqsku'];
			}
			/*  匹配结束  */    
			/*  价格加入  */  
			$money = array();
			$productdescribe = $this->productdescribe->find_all('1=1');
			foreach ($productdescribe as $v) 
			{
				$money[$v['number']] = array();
			}
			/*  价格加入  */
			/*  匹配ID加入  */
			$int = array();
			$intdata = $this->typeclass->find_all('classid=14','id,spare');
			foreach ($intdata as $v) 
			{
				$v['spare'] = explode('|',$v['spare']);
				$int[$v['id']] = $v['spare'][0];
			}	
			/*  匹配ID加入  */
			$zjsku = array();
			$shopsku = $this->shopsku->find_all();
			foreach ($shopsku as $val) 
			{
				$ss = explode(',',trim($val['shop'],','));
				foreach ($ss as $v) 
			    {
					if(isset($zjsku[$v]))
					{
						$zjsku[$v] .= ','.trim($val['sku'],',');
					}
					else
					{
						$zjsku[$v] = trim($val['sku'],',');
					}
				}
			}	
			/*  匹配ID结束  */
		    $this->db->trans_begin();
			$error = "";
		    foreach ($list as $key=>$value)
		    {
				if(empty($value[0])){
					continue;
				}
				$addtess = $value[7].$value[6];
				$addtess = str_replace(array('/( |　| |\s)/',"'"),array(' ',"’"),$addtess);

				$repeat = $this->customer->find_all('phone = "'.$value[4].'" and address = "'.$addtess.'" and shop = '.$shopid);//判断电话地址
				$sku = $value['2'];
				$je = (isset($value['12']))?$value['12']:0;
				if(!empty($value[13])){
					$value['13'] = str_replace('/','-',$value['13']);
					$dtime = strtotime($value['13']);
					if(empty($dtime)){
						$dtime = time();
					}
				}else{
					$dtime = time();
				}
				$dtime = $dtime + $key;
				$post['name'] = (!empty($value[3]))?str_replace(array('/( |　| |\s)/',"'"),array(' ',"’"),$value['3']):'';
				$post['email'] = $value['5'];
				$res = $this->logic_order->checkEmail($post['email']);
				if(!$res){
					$error .= '第'.($key+2).'行邮箱格式错误;';
					$i++;
					continue;
				}
				if($value['11'] != '')
				{
					$country = $this->country->get_ename(str_replace(array('/( |　| |\s)/',"'"),array(' ',"’"),$value['11']));
					$post['country'] = $country['id'];
				}
				$post['level'] = 4;
				$post['phone'] = $value['4']?$value['4']:'';
				$post['province'] = $value['9']?$value['9']:'';
				$post['city'] = $value['8']?$value['8']:'';
				$post['address'] = $addtess;
				$post['zipcode'] = $value['10']?$value['10']:'';
				$post['shop'] = $shopid;
				$post['source'] = 10;
				$post['type'] = 1;
				$post['count'] = '';
				$post['time'] = $dtime;
				$str = $post['phone'];
				preg_match_all('/[0-9]/u',$str,$result);
				$numphone = join('',$result[0]);
				$post['numphone'] = $numphone;
				if(!isset($repeat[0]))
				{
					$post['num'] = 1;
		    	    $this->customer->insert($post);
                }
				else
				{
					$this->customer->save(array('num'=>$repeat[0]['num']+1),$repeat[0]['id']);
				}
				$sbsku = '';
				$whlabel = $this->whlabel->get_sku($sku);
				if($whlabel)
				{
					$w = explode('-',trim($whlabel['features'],'-'));
					foreach ($w as $v)
		            {
						if(isset($dk[$v]))
						{
							$sbsku .= $dk[$v].'-';
						}
					}
				}
				$sbsku = trim($sbsku,'-');
				$time = time();
				$shop = $this->shop->read($shopid);
				$ddpost['orderremarks'] = '';
				$ddpost['shop'] = $shop['id'];//店铺ID
				$ddpost['user'] = $shop['shopuser'];//店铺负责人
				$orderid = 0;
				$ddpost['orderid'] = 0;
				$ddpost['product'] = '';//产品名称
				$ddpost['link'] = '';//产品链接
				$ddpost['issku'] = $sku;
				$ddpost['quantity'] = rtrim($value['1'],';');
				$ddpost['clientremarks'] = '';//客户备注
				$ddpost['guarantee'] = '';//卖家保障
				$ddpost['parameter'] = '';//属性
				$ddpost['shippingmethod'] = '';//用户选择快递方式及运费金额
				$ddpost['source'] = 2;//订单类型
				$ddpost['type'] = 1;//发货仓库
				$ddpost['capital'] = 3;//资金支付状况，全部付款
				$num = $this->fullorder->find_count('gtime = "'.date('Ymd',$dtime).'" and shop = '.$shopid);
				$ddpost['number'] = $shop['shortname'].'-'.date('ymd',$dtime).'-'.(substr(strval($num+1+1000),1,3));//编号
				$ddpost['orderinfo'] =   $value['0'];//订单号
				$d = $this->fullorder->get_orderinfo($ddpost['orderinfo']);
				if(isset($d['id']))
				{
					$error .= '第'.($key+2).'行订单号重复;';
					$i++;
					continue;
				}
				$ddpost['paypal'] = $ddpost['orderinfo'];//交易号
				$ddpost['insurance'] = 0;//运输保险费用
				$ddpost['baddress'] = '';
				$ddpost['saddress'] = '';
				$ddpost['country'] = $country['id'];//此国家的ID
				$ddpost['al'] = $country['lb'];//联邦名称
				$ddpost['bname'] = $post['name'];//名称
				$ddpost['sname'] = $post['name'];//名称
				$ddpost['client'] = $post['name'];//公司名称
				$ddpost['name'] = $post['name'];//收件人名称
				$ddpost['phone'] = $post['phone'];//收件人电话
				$ddpost['email'] = $post['email'];//客户邮箱
				$ddpost['zipcode'] = $post['zipcode'];//收件人邮编
				$ddpost['province'] = $post['province'];//收件人省份
				$ddpost['city'] = $post['city'];//收件人城市
				$ddpost['address'] = $post['address'];//收件人地址
				$ddpost['shouldmoney'] = $je;//应收金额
				$ddpost['skje'] = $je;//收款金额
				$ddpost['ismoney'] = '';//支付币种金额
				$ddpost['shouldmoney'] = $je;//金额
			    $ddpost['budget'] = $je;//预估到帐金额
				$ddpost['buytime'] = $dtime;//格式化付款时间
				$ddpost['dtime'] = $dtime;//订单时间
				$ddpost['gtime'] = date('Ymd',$dtime);//格式化订单时间
				$ddpost['currencytitle'] = 'USD';//结算币种名称
				$ddpost['currency'] = 219;//钱币ID
				$ddpost['time'] = time();//同步时间
				$ddpost['shopify'] = 0;//同步时间
				$ddpost['hl'] = '6.4';//汇率
				$matching = $this->api->matching($ddpost['quantity'],$sbsku,$dtc,$money,$int,$dtctitle,$shop);
				$ddpost['shipremarks'] = $matching['title'];
				$ddpost['cost'] = $matching['cost'];
				$ddpost['purchase'] = $matching['purchase'];
				$ddpost['fpdata'] = $matching['product'];
				$ddpost['whlabel'] = $matching['whlabel'];
				$ddpost['slpx'] = $matching['wcslpx'];
				$ddpost['state'] = 207;
				$ddpost['type'] = 13;
					
			    $this->fullorder->insert($ddpost);
				
			}
			if ($this->db->trans_status() === FALSE)
            {
				$this->db->trans_commit();
				echo json_encode(array('msg'=>'添加失败，请重试','success'=>false));exit;
            }
            else
            {
				if(count($list) == $i)
				{
					$til = '导入全部失败！请检查导入信息;'.$error;
				}
				else if(count($list) > $i && $i != 0)
				{
					$til = '部分导入成功！'.$i.'条信息有问题，请排查;'.$error;
				}
				else  if($i < 1)
				{
					$til = '导入成功！';
				}
                $this->db->trans_commit();
				echo json_encode(array('msg'=>$til,'success'=>true));exit;
            }
        }
		else
		{
			echo json_encode(array('msg'=>'上传失败！','t'=>$this->upload->display_errors(),'success'=>false));exit;
		}
    }


	public function _indexexcel()//通过计数，2020/02/21已校准
	{
		$user = $this->user->get_api($_SESSION['api']);
		if($user)
		{
		    $fgshop = "";$sid = "";
		    $users = explode('|',trim($user['shop'],'|'));
			foreach ($users as $value) 
		    {
				$fgshop .= " shop = ".$value." or";
				$sid .= " id = ".$value." or";
			}
			if($user['vip'] == 1)
			{
				$vip = 1;
			}
			else
			{
				$vip = 0;
			}
		}
		else
		{
			$vip = 0;
		}
		$post = $this->input->post(NULL, TRUE);
		if(isset($_GET['timetk']))  
		{
			$shop = $this->input->get('shop',true);
			$numphone = $this->input->get('numphone',true);
			$name = $this->input->get('name',true);
			$email = $this->input->get('email',true);
			$address = $this->input->get('address',true);
			$level = $this->input->get('level',true);
			$num = $this->input->get('num',true);
			$country = $this->input->get('country',true);
			$excelid = $this->input->get('sid',true);
			$timetk = $this->input->get('timetk',true);
			$timetj = $this->input->get('timetj',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$where = "1=1 and type = 1 and (".rtrim($fgshop,'or').")";
			if($shop)
            {
                $where  .= " and shop = '$shop'";
            }
			if($numphone)
            {
                $where  .= " and numphone = '$numphone'";
            }
			if($name)
            {
                $where  .= " and name like '%$name%'";
            }
			if($email)
            {
                $where  .= " and email like '%$email%'";
            }
			if($level)
            {
                $where  .= " and level = '$level'";
            }
			if($country)
            {
                $where  .= " and country = '$country'";
            }
			if($address)
            {
                $where  .= " and address like '%$address%'";
            }
			if($num > 0 && $num < 10 && $num != '2a')
            {
                $where  .= " and num = '$num'";
            }
			else if($num > 9)
            {
                $where  .= " and num > '9'";
            }
			else if($num == '2a')
            {
                $where  .= " and num > '1'";
            }
			else
			{
				$where  .= " and num >= '0'";
			}
			if($timetk && $timetj)
            {
				$where  .= " and ((time > '$timetk' and time < '$timetj') or time = '0')";
            }
			$xzid = '';
			if($excelid)
            {
				$excelid = explode(',',trim($excelid,','));
				foreach ($excelid as $key=>$value) 
		        {
					$xzid .= " id = ".$value." or";
				}
                $where .= " and (".rtrim($xzid,'or').")";;
            }
            //数据排序
            $order_str = "id desc";
			$numdata = array();
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
            //取得信息列表
			$info_list = $this->customer->find_all($where,'shop,name,email,phone,address,city,province,zipcode,country,level,money,num,numphone,time,count',$order_str);
			foreach ($info_list as $key=>$value) 
		    {
				$shop = $this->shop->read($value['shop']);
				$info_list[$key]['shop'] = $shop['shopname'];
				if($value['country'] != 0)
				{
				    $country = $this->country->read($value['country']);
				    $info_list[$key]['country'] = $country['name'];
				}
				else
				{
					$info_list[$key]['country'] = "未知";
				}
				if($value['level'] == 1)
				{
					$info_list[$key]['level'] = "网红";
				}
				else if($value['level'] == 2)
				{
					$info_list[$key]['level'] = "批发";
				}
				else if($value['level'] == 3)
				{
					$info_list[$key]['level'] = "店铺转线下";
				}
				else if($value['level'] == 4)
				{
					$info_list[$key]['level'] = "线下其他";
				}
				else if($value['level'] == 5)
				{
					$info_list[$key]['level'] = "店内客户";
				}
				if($value['time'] != 0)
				{
					$info_list[$key]['time'] = date('Y-m-d',$value['time']);
				}
				else
				{
					$info_list[$key]['time'] = "无";
				}
				$info_list[$key]['numphone'] = ($value['num'] > 0 && $value['money'] > 0)?sprintf("%01.2f",$value['money']/$value['num']):0;
				if(isset($value['email']) && $user['excelpass'] == '1')
				{
					$emailpass = $this->setting->get_excelpass($value['email']);
					$info_list[$key]['email'] = $emailpass;
				}
				if(isset($value['phone']) && $user['excelpass'] == '1')
				{
					$phone = $this->setting->get_excelpass($value['phone']);
					$info_list[$key]['phone'] = $phone;
				}
		    }
			$title = "按条件导出"; 
            $titlename = "<table border=1>
            <tr align='center'>
			<td>店铺</td>
			<td>名称</td>
            <td>邮箱</td>
			<td>电话</td>
			<td>详细地址</td>
			<td>城市</td>
			<td>省/州</td>
			<td>邮编</td>
			<td>国家</td>
			<td>类型</td>
			<td>总额</td>
			<td>成交次数</td>
			<td>客单价</td>
			<td>最后购买日期</td>
			<td>备注</td>
            </tr>
            </table>"; 
            $filename = $title.".xls";
			$tail = "";
            $this->excel->get_fz2($info_list,$titlename,$filename,$tail);
		}
	}
	
	//下载excel
	public function _excel()
	{
		if(isset($_GET['excel']))  
		{
			if(isset($_SESSION['api']))
		    {
			    $user = $this->user->get_api($_SESSION['api']);
			    $usp = $user;
		        $fgshop = "";$sid = "";
		        $user = explode('|',trim($user['shop'],'|'));
			    foreach ($user as $value) 
		        {
				    $fgshop .= " shop = ".$value." or";
				    $sid .= " id = ".$value." or";
			    }
		    }
			$dowid = $this->input->get('a');
			$wid = "";
			if($dowid != "")
			{
				$id_arr =  explode(',',rtrim($dowid,','));
				$wid  .= " id = 0 or";
				foreach ($id_arr as $v) 
		        {
                    $wid  .= " id = '$v' or";
                }
				$wid = " and".rtrim($wid,'or');
			}
			$excel = $this->input->get('excel',true);
			$page = $this->input->get('page',true);
		    $perpage = $this->input->get('perpage',true);
			$shop = $this->input->get('shop',true);
			$name = $this->input->get('name',true);
			$country = $this->input->get('country',true);
			$email = $this->input->get('email',true);
			$address = $this->input->get('address',true);
			$level = $this->input->get('level',true);
			$num = $this->input->get('num',true);
			$timetk = $this->input->get('timetk',true);
			$timetj = $this->input->get('timetj',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$where = "1 = 1 and (".rtrim($fgshop,'or').")";
			if($shop)
            {
                $where  .= " and shop = '$shop'";
            }
			if($name)
            {
                $where  .= " and name like '%$name%'";
            }
			if($email)
            {
                $where  .= " and email like '%$email%'";
            }
			if($country)
            {
                $where  .= " and country = '$country'";
            }
			if($level)
            {
                $where  .= " and level = '$level'";
            }
			if($num != '')
			{
				$nu = 1;
			    if($num > 9)
                {
                    $where  .= " and num > '9'";
                }
			    else if($num == '2a')
                {
                    $where  .= " and num > '1'";
                }
				else
                {
                    $where  .= " and num = '$num'";
                }
			}
			else
			{
				$nu = 2;
				$where  .= " and num >= '0'";
			}
			if($address)
            {
                $where  .= " and address like '%$address%'";
            }
			if($timetk && $timetj)
            {
                $where  .= " and time > '$timetk' and time < '$timetj'";
            }
			$where  .= " and type = 1";//白名单用户
			$info_list = array();
			if($excel == 2) //老客户列表
			{
				//$where = str_replace("level = '$level'","level > '1'",$where);
                $info_list = $this->customer->find_all($where.$wid,'name,email,country,time,num,money,numphone','time desc');
				foreach ($info_list as $key=>$value) 
		        {
					$info_list[$key]['time'] = date('Y-m-d H:i:s',$value['time']);
					if($value['country'] != 0)
				    {
					    $country = $this->country->read($value['country']);
					    $info_list[$key]['country'] = $country['ename'];
					}
					else
					{
						$info_list[$key]['country'] = '';
					}
					if($value['num'] > 0){
						$info_list[$key]['numphone'] = sprintf("%01.2f",$value['money']/$value['num']);
					}else{
						$info_list[$key]['numphone'] = "<span style='color:red'>num异常".$value['num']."</span>";
					}
					
					if(isset($value['email']) && $usp['excelpass'] == '1')
					{
						$emailpass = $this->setting->get_excelpass($value['email']);
						$info_list[$key]['email'] = $emailpass;
					}
				}
				/**
                foreach ($info_list as $key=>$value) 
		        {
					$value['time'] = date('Y-m-d H:i:s',$value['time']);
					$d = $this->fullorder->find_count('email = "'.$value['email'].'" and shop = "'.$value['shop'].'" and mergeid = 0','orderinfo,state,product,name,email,dtime,shouldmoney','time desc');
					if($d > 1)
					{
						$info_list[] = $v;
					}
				}
				**/
				
				$fzh = "<td>客户名</td><td>客户邮箱</td><td>客户国家</td><td>最近一次下单时间</td><td>购买次数</td><td>购买总金额</td><td>客单价</td>";
				$title = "老客户列表"; 
            }
			else
			{
				$fdata = $this->customer->find_all($where.$wid,'email,shop','time desc');
				foreach ($fdata as $key=>$value) 
		        {
					$d = $this->fullorder->find_all('email = "'.$value['email'].'" and shop = "'.$value['shop'].'" and mergeid = 0    and  extra_status = 0 ','orderinfo,state,product,shipremarks,name,email,country,dtime,shouldmoney','time desc');
					if($nu == 2)
					{
					    if(count($d) > 1)
				  	    {
					        foreach ($d as $k=>$v) 
		                    {
						        $v['dtime'] = date('Y-m-d H:i:s',$v['dtime']);
						        $typeclass = $this->typeclass->read($v['state']);
		    	                $v['state'] = $typeclass['spare'];
							    if($v['country'] != 0)
				                {
							        $country = $this->country->read($v['country']);
							        $v['country'] = $country['ename'];
							    }
							    else
							    {
								    $v['country'] = '';
							    }
								if(isset($v['email']) && $usp['excelpass'] == '1')
								{
									$emailpass = $this->setting->get_excelpass($v['email']);
									$v['email'] = $emailpass;
								}
						        $info_list[] = $v;
					       }
						}
					}
					else
					{
						foreach ($d as $k=>$v) 
		                    {
						        $v['dtime'] = date('Y-m-d H:i:s',$v['dtime']);
						        $typeclass = $this->typeclass->read($v['state']);
		    	                $v['state'] = $typeclass['spare'];
							    if($v['country'] != 0)
				                {
							        $country = $this->country->read($v['country']);
							        $v['country'] = $country['ename'];
							    }
							    else
							    {
								    $v['country'] = '';
							    }
								if(isset($v['email']) && $usp['excelpass'] == '1')
								{
									$emailpass = $this->setting->get_excelpass($v['email']);
									$v['email'] = $emailpass;
								}
						        $info_list[] = $v;
					       }
					}
				}
				$fzh = "<td>订单号</td><td>订单状态</td><td>产品名</td><td>仓库品名</td><td>客户名</td><td>客户邮箱</td><td>客户国家</td><td>下单时间</td><td>订单金额</td>";
				$title = "老客户订单列表"; 
			}
            $titlename = "<table border=1>
            <tr>"
            .$fzh.
            "</tr>
            </table>";
			$tail = "\n";
            $filename =  $title.'-'.date('Ymd',time()).".xls";
            $this->excel->get_fz2($info_list,$titlename,$filename,$tail);
	    }
    }
	//下载excel模板
	public function _bankdown()
	{
		if(isset($_GET['bankdown']))  
		{
			$numphone = $this->input->post('numphone',true);
			$xtime = $this->input->get('xtime',true);
			//$where = "1=1 and type = 2 and (".rtrim($fgshop,'or').")";
			$shop = $this->input->get('shop',true);
			$name = $this->input->get('name',true);
			$email = $this->input->get('email',true);
			$address = $this->input->get('address',true);
			$type = $this->input->get('type',true);
			$id = $this->input->get('id',true);
			$timetk = $this->input->get('timetk',true);
			$timetj = $this->input->get('timetj',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			if($type)
            {
                $where = "type = '$type'";
            }
			else
			{
				$where = "id != 0";
			}
			
			if($id)
            {
				$id = explode('|',trim($id,'|'));
				$downid = '';
				foreach ($id as $value) 
		    	{
					$downid .= " id = ".$value." or";
				}
                $where .= " and (".rtrim($downid,'or').")";
            }
			if(!$shop)
		    {
			    $user = $this->user->get_api($_SESSION['api']);
			    $usp = $user;
		        $fgshop = "";$sid = "";
		        $user = explode('|',trim($user['shop'],'|'));
			    foreach ($user as $value) 
		        {
				    $fgshop .= " shop = ".$value." or";
				    $sid .= " id = ".$value." or";
			    }
				$where .= " and (".rtrim($fgshop,'or').")";
		    }
			else
			{
				$where .= " and shop = '$shop'";
			}
			if($email)
            {
                $where  .= " and email = '$email'";
            }
			if($name)
            {
                $where  .= " and name = '$name'";
            }
			if($address)
            {
                $where  .= " and address = '$address'";
            }
			if($xtime)
            {
                $where  .= " and typetime > '$timetk' and typetime < '$timetj'";
            }
			 $info_list = $this->customer->find_all($where,'name,address,city,province,zipcode,country,phone,email,level,shop,source,type,count,typetime');
			foreach ($info_list as $key=>$v) 
		    {
				$country = $this->country->read($v['country']);
				$info_list[$key]['country'] = $country['ename'];
				if($v['level'] == 1)
				{
					$info_list[$key]['level'] = '网红';
				}
				else if($v['level'] == 2)
				{
					$info_list[$key]['level'] = '批发';
				}
				else if($v['level'] == 3)
				{
					$info_list[$key]['level'] = '店铺转线下';
				}
				else if($v['level'] == 4)
				{
					$info_list[$key]['level'] = '线下其他';
				}
				else if($v['level'] == 5)
				{
					$info_list[$key]['level'] = '店内';
				}
				else
				{
					$info_list[$key]['level'] = '未知';
				}
				if($v['typetime'] != 0)
				{
					$info_list[$key]['typetime'] = date('Y-m-d',$v['typetime']);
				}
				else
				{
					$info_list[$key]['typetime'] = "无";
				}
				$shop = $this->shop->read($v['shop']);
				$info_list[$key]['shop'] = $shop['shopname'];
				$source = $this->typeclass->read($v['source']);
				$info_list[$key]['source'] = $source['title'];
			}
			$titledata = array('姓名','详细地址','城市','省/州','邮编','国家','电话','邮箱','类型(1:网红2:批发3:店铺转线下4:线下其他5:店内）','所属店铺(必须ERP已有店铺）','来源(数据字典的户来源需存在）','黑白名单（白名单填1或黑名单填2）','备注','客户分类时间');
			$fzh = "";
			foreach ($titledata as $v)
		    {
				$fzh .= "<td>".$v."</td>";
			}
            $title = "客户导出";
            $titlename = "<table border=1>
            <tr>"
            .$fzh.
            "</tr>
            </table>";
			$tail = "\n";
            $filename = $title.".xls";
            $this->excel->get_fz2($info_list,$titlename,$filename,$tail);
	    }
	}
	//下载excel模板
	public function _down()
	{
		if(isset($_GET['excela']))  
		{
            $title = "客户导入模板"; 
            $titledata = array(array('姓名','详细地址','城市','省/州','邮编','国家','电话','邮箱','类型(1:网红2:批发3:店铺转线下4:线下其他5:店内）','所属店铺(必须ERP已有店铺）','来源(数据字典的户来源需存在）','黑白名单（白名单填1或黑名单填2）','备注'),array('lekia waites','700 Sandy Plains rd suite b14','marietta','Georgia','30066','United States','4047322519','lwaites@ccccare.com','5','supernovahair','独立站','1','备注'));
            $filename = $title.".xls";
            $this->customer->get_excel($titledata,$filename);
	    }
	}
	public function _newold()
	{
		if(isset($_SESSION['api']))
		{
			$user = $this->user->get_api($_SESSION['api']);
			$usp = $user;
		    $fgshop = "";$sid = "";
		    $usersp = explode('|',trim($user['shop'],'|'));
			foreach ($usersp as $value) 
		    {
				$fgshop .= " shop = ".$value." or";
				$sid .= " id = ".$value." or";
			}
		}
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['timek']))
		{
			$new = array();$old = array();$time=array();
			$timek = $this->input->post('timek',true);
			$timej = $this->input->post('timej',true);
			$k = strtotime($timek)-24*3600;//少一天为增加选择开始天时间
			$j = strtotime($timej);
			$n = ($j-$k)/(24*3600);
			if($n < 1)
			{
				$n = 1;
			}
			for($i=1;$i<$n;$i++)
		    {
				$nnum = 0;$onum = 0;
				$t = $j-($n*24*60*60)+($i*24*60*60);
			    $time[] = date('Y-m-d',$t);
				$ct = strtotime(date('Ymd',$t));
				$ctj = strtotime(date('Ymd',$t+24*3600));
				$info_list = $this->fullorder->find_all("mergeid = '0' and dtime > '$ct' and dtime < '$ctj' and (".rtrim($fgshop,'or').")");
				foreach ($info_list as $value)
		    	{
					if($value['email'] != '0' && $value['email'] != '' && $value['email'] != '无')
		        	{
						$gnum =  $this->fullorder->find_count("email = '".$value['email']."' and shop = '".$value['shop']."' and mergeid = 0");
						if($gnum >1)
						{
							$onum += 1;
						}
						else
						{
							$nnum += 1;
						}
					}
		        	else
					{
						$nnum += 1;
					}
				}
				$new[] = $nnum;
				$old[] = $onum;
			}
			echo @json_encode(array('time'=>$time,'cnew'=>$new,'cold'=>$old,'success'=>true));exit;
	    }
		$this->_Template('customer_newold',$this->data);
	}

	/**
	 * _dgsov1 - 优化版的_dgso方法
	 * 改进点：
	 * 1. 修复SQL注入漏洞，使用escape转义
	 * 2. 修复$d[0]越界问题
	 * 3. _dgcz改用BFS非递归算法，避免递归爆炸
	 * 4. 批量预加载关联数据，解决N+1查询
	 * 5. 修复特殊搜索路径的分页逻辑
	 * 6. 使用map映射替代硬编码if-else
	 * 7. 添加输入参数校验
	 * 8. 未使用的筛选参数(shop/name/level/时间范围)添加为实际筛选条件
	 */
	public function _dgso()
	{
		$user = $this->user->get_api($_SESSION['api']);
		if (!$user)
		{
			$vip = 0;
			die("请先登录！！！");
		}

		$fgshop = "";
		$sid = "";
		$users = explode('|', trim($user['shop'], '|'));
		foreach ($users as $value)
		{
			$fgshop .= " shop = " . intval($value) . " or";
			$sid .= " id = " . intval($value) . " or";
		}
		$vip = ($user['vip'] == 1) ? 1 : 0;

		$post = $this->input->post(NULL, TRUE);
		if (!isset($post['page']))
		{ 
			$wlshop = $this->shop->find_all('1=1 and ' . rtrim($sid, 'or'));
			$this->data['wlshop'] = $wlshop;
			$this->data['vip'] = $vip;
			$this->_Template('customer_dgso', $this->data);
			return;
		}

		// 输入校验：page和perpage必须是正整数
		$page = max(1, intval($this->input->post('page', true)));
		$perpage = max(1, min(200, intval($this->input->post('perpage', true))));

		// 获取搜索参数
		$shop = intval($this->input->post('shop', true));
		$numphone = $this->input->post('numphone', true);
		$name = trim($this->input->post('name', true));
		$email = trim($this->input->post('email', true));
		$address = trim($this->input->post('address', true));
		$level = intval($this->input->post('level', true));
		$num = intval($this->input->post('num', true));
		$timetk = $this->input->post('timetk', true);
		$timetj = $this->input->post('timetj', true);
		$timetk = strtotime($timetk);
		$timetj = strtotime($timetj);

		// 构建WHERE条件，使用escape防SQL注入
		$where = "1=1 and (" . rtrim($fgshop, 'or') . ")";

		if ($numphone)
		{
			$where .= " and numphone = " . $this->db->escape($numphone);
		}
		if ($email)
		{
			$where .= " and email like '%" . $this->db->escape_like_str($email) . "%'";
		}
		if ($address)
		{
			$where .= " and address like '%" . $this->db->escape_like_str($address) . "%'";
		}
		if ($shop)
		{
			$where .= " and shop = " . intval($shop);
		}
		if ($name)
		{
			$where .= " and name like '%" . $this->db->escape_like_str($name) . "%'";
		}
		if ($level)
		{
			$where .= " and level = " . intval($level);
		}
		if ($num)
		{
			$where .= " and num = " . intval($num);
		}
		if ($timetk && $timetj)
		{
			$where .= " and time >= " . intval($timetk) . " and time <= " . intval($timetj);
		}

		$fields = 'id,shop,source,name,email,country,level,money,num,time,type,numphone,address';

		if ($numphone || $email || $address)
		{
			// 特殊搜索路径：通过地址/邮箱/电话查找关联客户
			$d = $this->customer->find_all($where);

			// 修复：判断$d是否为空，避免越界
			if (empty($d))
			{
				echo json_encode(array('total' => 0, 'over' => 0, 'pagenum' => 0, 'rows' => array()));
				exit;
			}

			// 使用BFS非递归算法查找所有关联客户
			$cx = array();
			$info_list = $this->_dgczv1($cx, $d);
			$info_list = array_values($info_list);
			$total = count($info_list);
			$pagenum = ceil($total / $perpage);

			// 修复：根据当前页码做切片分页
			$start = ($page - 1) * $perpage;
			$over = $total - ($start + $perpage);
			$info_list = array_slice($info_list, $start, $perpage);
		}
		else
		{
			// 正常搜索路径
			$order_str = "id desc";
			$start = ($page - 1) * $perpage;

			$info_list = $this->customer->find_all($where, 'id,shop,source,name,email,country,level,money,num,time,type', $order_str, $start, $perpage);
			$total = $this->customer->find_count($where);
			$pagenum = ceil($total / $perpage);
			$over = $total - ($start + $perpage);
		}

		// 批量预加载关联数据，避免N+1查询
		$shopIds = array();
		$sourceIds = array();
		$countryIds = array();
		foreach ($info_list as $value)
		{
			if (!empty($value['shop'])) $shopIds[$value['shop']] = true;
			if (!empty($value['source'])) $sourceIds[$value['source']] = true;
			if (!empty($value['country'])) $countryIds[$value['country']] = true;
		}

		$shopMap = array();
		if (!empty($shopIds))
		{
			$idList = implode(',', array_map('intval', array_keys($shopIds)));
			$shopData = $this->shop->find_all("id in ($idList)", 'id,shopname');
			foreach ($shopData as $row)
			{
				$shopMap[$row['id']] = $row['shopname'];
			}
		}

		$sourceMap = array();
		if (!empty($sourceIds))
		{
			$idList = implode(',', array_map('intval', array_keys($sourceIds)));
			$sourceData = $this->typeclass->find_all("id in ($idList)", 'id,title');
			foreach ($sourceData as $row)
			{
				$sourceMap[$row['id']] = $row['title'];
			}
		}

		$countryMap = array();
		if (!empty($countryIds))
		{
			$idList = implode(',', array_map('intval', array_keys($countryIds)));
			$countryData = $this->country->find_all("id in ($idList)", 'id,name');
			foreach ($countryData as $row)
			{
				$countryMap[$row['id']] = $row['name'];
			}
		}

		// Level映射表
		$levelMap = array(
			1 => '网红',
			2 => '批发',
			3 => '店铺转线下',
			4 => '线下其他',
			5 => '店内客户',
		);

		// 数据后处理
		foreach ($info_list as $key => $value)
		{
			// 使用预加载的map赋值，避免逐条查询
			$info_list[$key]['shop'] = isset($shopMap[$value['shop']]) ? $shopMap[$value['shop']] : '';
			$info_list[$key]['source'] = isset($sourceMap[$value['source']]) ? $sourceMap[$value['source']] : '';

			if ($value['country'] != 0)
			{
				$info_list[$key]['country'] = isset($countryMap[$value['country']]) ? $countryMap[$value['country']] : '未知';
			}
			else
			{
				$info_list[$key]['country'] = '未知';
			}

			// 使用map映射替代if-else链
			$info_list[$key]['level'] = isset($levelMap[$value['level']]) ? $levelMap[$value['level']] : '未知';

			if ($value['time'] != 0)
			{
				$info_list[$key]['time'] = date('Y-m-d', $value['time']);
			}
			else
			{
				$info_list[$key]['time'] = '无';
			}

			if ($value['type'] != 2)
			{
				$info_list[$key]['type'] = "<a href='javascript:void(0);' class='window' data-h='/customer/mdedit/" . $value['id'] . "' data-t='客户下单'><b>下单</b></a>&nbsp;&nbsp;&nbsp;&nbsp;<a class='customer' data-type='2' data-t='yr' data-id='" . $value['id'] . "' href='javascript:void(0);'>移入黑名单</a>";
			}
			else
			{
				$info_list[$key]['type'] = '黑名单客户';
			}

			unset($info_list[$key]['numphone']);
			unset($info_list[$key]['address']);
		}

		$rows = array('total' => $total, 'over' => $over, 'pagenum' => $pagenum, 'rows' => ($info_list));
		echo json_encode($rows);
		exit;
	}

	/**
	 * _dgczv1 - 优化版的_dgcz方法
	 * 使用BFS广度优先搜索替代递归，避免递归爆炸和栈溢出
	 * 每一层合并所有搜索条件为一次查询，大幅减少数据库请求
	 */
	public function _dgczv1($child, $data)
	{
		// 初始化已处理集合
		foreach ($data as $value)
		{
			if (!isset($child[$value['id']]))
			{
				$child[$value['id']] = $value;
			}
		}

		$fields = 'id,shop,source,name,email,country,level,money,num,time,type,numphone,address';

		// BFS广度优先搜索
		$queue = $data;
		$maxIterations = 50; // 安全上限，防止无限循环

		while (!empty($queue) && $maxIterations > 0)
		{
			$maxIterations--;

			// 收集当前层所有不重复的搜索词
			$addressSet = array();
			$emailSet = array();
			$numphoneSet = array();

			foreach ($queue as $row)
			{
				if (!empty($row['address']))
				{
					$addressSet[$row['address']] = true;
				}
				if (!empty($row['email']))
				{
					$emailSet[$row['email']] = true;
				}
				if (!empty($row['numphone']))
				{
					$numphoneSet[$row['numphone']] = true;
				}
			}

			$queue = array(); // 清空当前层，准备下一层

			// 构建合并后的查询条件
			$conditions = array();
			foreach (array_keys($addressSet) as $addr)
			{
				$conditions[] = "address like '%" . $this->db->escape_like_str($addr) . "%'";
			}
			foreach (array_keys($emailSet) as $em)
			{
				$conditions[] = "email like '%" . $this->db->escape_like_str($em) . "%'";
			}
			foreach (array_keys($numphoneSet) as $np)
			{
				$conditions[] = "numphone like '%" . $this->db->escape_like_str($np) . "%'";
			}

			if (empty($conditions))
			{
				break;
			}

			// 一次查询获取所有匹配记录
			$where = implode(' or ', $conditions);
			$rows = $this->customer->find_all($where, $fields);

			foreach ($rows as $row)
			{
				if (!isset($child[$row['id']]))
				{
					$child[$row['id']] = $row;
					$queue[] = $row; // 新发现的节点加入下一层搜索
				}
			}
		}

		return $child;
	}

	
}