erp/core/CoreApp/controllers/Fullorder_smt.php

<?php defined('BASEPATH') OR exit('No direct script access allowed');
class Fullorder_smt extends Start_Controller {
	public function __construct(){
		parent::__construct();
		$this->load->library('session');
		$this->load->_model('Model_fullorder_smt','fullorder_smt');
		$this->load->_model('Model_fullorder','fullorder');
		$this->load->_model('Model_fullordertt','fullordertt');
		$this->load->_model('Model_fullorderexcel','fullorderexcel');
		$this->load->_model('Model_shop','shop');
		$this->load->_model('Model_typeclass','typeclass');
		$this->load->_model('Model_express','express');
		$this->load->_model('Model_country','country');
		$this->load->_model('Model_productdescribe','productdescribe');
		$this->load->_model('Model_customs','customs');
		$this->load->_model('Model_detailed','detailed');
		$this->load->_model('Model_productdescription','productdescription');
		$this->load->_model('Model_logistics','logistics');
		$this->load->_model('Model_hl','hl');
		$this->load->_model('Model_excel','excel');
		$this->load->_model('Model_warehouse','warehouse');
		$this->load->_model('Model_customer','customer');
		$this->load->_model('Model_user','user');
		$this->load->_model('Model_dhl','dhl');
		$this->load->_model('Model_notice','notice');
		$this->load->_model('Model_api','api');
	}
	//定义方法的调用规则 获取URI第二段值
    public function _remap($arg,$arg_array)
    {
		if($arg == 'add')//添加
        {
             $this->_add();
        }
		else if($arg == 'edit')//修改
        {
             $this->_edit($arg_array);
        }
		else if($arg == 'readonly')//修改
        {
             $this->_readonly($arg_array);
        }
		else if($arg == 'readlist')
        {
             $this->_readlist();
        }
		else if($arg == 'del')//修改
        {
             $this->_del();
        }
		else if($arg == 'price')//价格明细
        {
             $this->_price();
        }
		else if($arg == 'customs')
        {
             $this->_customs();
        }
		else if($arg == 'express')
        {
             $this->_express();
        }
		else if($arg == 'hl')
        {
             $this->_hl();
        }
		else if($arg == 'repeat')
        {
             $this->_repeat();
        }
		else if($arg == 'operation')
        {
             $this->_operation();
        }
		else if($arg == 'merge')
        {
             $this->_merge();
        }
		else if($arg == 'fmexcel')
        {
             $this->_fmexcel();
        }
		else if($arg == 'fdexcel')
        {
             $this->_fdexcel();
        }
		else if($arg == 'fdfexcel')
        {
             $this->_fdfexcel();
        }
		else if($arg == 'excel')
        {
             $this->_excel();
        }
		else if($arg == 'exceldlz')
        {
             $this->_exceldlz();
        }
		else if($arg == 'evaluate')
        {
             $this->_evaluate();
        }
		else if($arg == 'state')
        {
             $this->_state();
        }
		else if($arg == 'review')
        {
             $this->_review();
        }
		else if($arg == 'black')
        {
             $this->_black();
        }
		else if($arg == 'ryf')
        {
             $this->_ryf();
        }
		else if($arg == 'expresstype')
        {
             $this->_expresstype();
        }
		else if($arg == 'fsstate')
        {
             $this->_fsstate();
        }
		else if($arg == 'power')
        {
             $this->_power();
        }
		else if($arg == 'error')
        {
             $this->_error();
        }
		else if($arg == 'dlzerror')
        {
             $this->_dlzerror();
        }
		else if($arg == 'dlz')
        {
             $this->_dlz();
        }
		else
		{
			 $this->_index();
		}
    }

	//管理
	public function _index()
	{
		$dt = 0;
		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";
			}
		}
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['page']))
		{
		    $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
			$warehouse = $this->input->post('warehouse',true);
			$xztime = $this->input->post('xztime',true);
			$timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);
			$shop = $this->input->post('shop',true);
			$source = $this->input->post('source',true);
			$state = $this->input->post('state',true);
			$review = $this->input->post('review',true);
			$type = $this->input->post('type',true);
			$express = $this->input->post('express',true);
			$orderinfo = $this->input->post('orderinfo',true);
			$user = $this->input->post('user',true);
			$client = $this->input->post('name',true);
			$waybill = $this->input->post('waybill',true);
			$number = $this->input->post('number',true);
			$email = $this->input->post('email',true);
			$dlz = $this->input->post('dlz',true);
			$print = $this->input->post('print',true);
			$library = $this->input->post('library',true);
			$timetk = strtotime($timetk)+12*3600;
			$timetj = strtotime($timetj)+12*3600;
			$where = "1=1 and mergeid = 0 and (".rtrim($fgshop,'or').")";
			if($warehouse)
            {
                $where  .= " and type = '$warehouse'";
            }
			if($timetk && $timetj)
            {
                $where .= " and ".$xztime." > '$timetk' and ".$xztime." < '$timetj'";
            }
			if($shop)
            {
                $where  .= " and shop = '$shop'";
            }
			if($source)
            {
                $where  .= " and source = '$source'";
            }
			if($state)
            {
				$where  .= " and state = '$state'";
            }
			if($review)
            {
                $where  .= " and review = '$review'";
            }
			if($type)
            {
                $where  .= " and type = '$type'";
            }
			if($express)
            {
                $where  .= " and express = '$express'";
            }
			if($orderinfo)
            {
                $where  .= " and orderinfo = '$orderinfo'";
            }
			if($user)
            {
                $where  .= " and user = '$user'";
            }
			if($client)
            {
                $where  .= " and client like '%$client%'";
            }
			if($waybill)
            {
                $where  .= " and waybill = '$waybill'";
            }
			if($number)
            {
                $where  .= " and number = '$number'";
            }
			if($email)
            {
                $where  .= " and email = '$email'";
            }
			if($library)
            {
                $where  .= " and library = '$library'";
            }
			if($print)
            {
                $where  .= " and print = '$print'";
            }
			if($dlz != '')
            {
                $where  .= " and dlz = '$dlz'";
            }
            //数据排序
            $order_str = "numberpx desc";
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
            //取得信息列表id,shop,type,source,user,orderinfo,number,name,state,buytime,clientremarks,review,print,library,libraryconfirm,express,waybill,orderremarks,black
            $info_list = $this->fullorder_smt->find_all($where,'id,shop,type,orderinfo,number,client,state,buytime,libraryconfirm,express,waybill,orderremarks,reviewremarks,printnumber,library,fpdata,black,clientremarks',$order_str,$start,$perpage);
			 //格式化数据
            foreach ($info_list as $key=>$value) 
		    {
				$ud = $this->fullorder_smt->read($value['id']);
				$ud['address'] = str_replace("'","’",$ud['address']);
				$ud['name'] = str_replace("'","’",$ud['name']);
				$customer = $this->customer->get_email($ud['email'],$value['shop']);
				$customerb = $this->customer->get_shopdata($ud['name'],$ud['email'],$ud['address'],$value['shop']);
				//$a = array_column($customer, 'email'); //三维找其中健的数组
			    //$a = array_flip($a); //键和值调换
				$shop = $this->shop->read($value['shop']);
				$info_list[$key]['shop'] = $shop['shopname'];
				//$info_list[$key]['user'] = $shop['shopuser'];
				$warehouse = $this->warehouse->read($value['type']);
				$warehousetitle = $warehouse['title'];
				if($value['type'] != 1){$warehousetitle = "<font style='color:#f64b4b'>".$warehouse['title']."</font>";}
				$info_list[$key]['type'] = $warehousetitle;
				$typeclass = $this->typeclass->read($value['state']);
				$info_list[$key]['state'] = $typeclass['spare'];
				if($ud['source'] == 1) //线下单用订单时间，其他用付款时间
				{
					$info_list[$key]['buytime'] = '<p>'.date('Y-m-d',$ud['dtime']).'</p><p>'.date('H:i:s',$ud['dtime']).'</p>';
				}
				else
				{
				    $info_list[$key]['buytime'] = '<p>'.date('Y-m-d',$value['buytime']+$dt).'</p><p>'.date('H:i:s',$value['buytime']+$dt).'</p>';
				}
				if($ud['dlz'] == 1)
				{
					$dlz = "<p>独立站已更新</p>";
				}
				else if($ud['dlz'] == 3)
				{
					$dlz = "<p>不需要更新</p>";
				}
				else if($ud['dlz'] == 2)
				{
					$dlz = "<p style='color:#C3C'>独立站更新失败</p>";
				}
				else
				{
					$dlz = "";
				}
				if($value['waybill'] != "")
				{
					$info_list[$key]['waybill'] = "<p>".$value['waybill']."</p>".$dlz;
				}
				if($value['express'] != 0)
				{
				    $express = $this->express->read($value['express']);
					$expressservicename = $express['servicename'];
				if($value['express'] != 1){$expressservicename = "<font style='color:#f64b4b'>".$express['servicename']."</font>";}
				    $info_list[$key]['express'] = $expressservicename;
				}
				else
				{
					$info_list[$key]['express'] = "无";
				}
				$x = "";
				if($value['libraryconfirm'] == 2 && $ud['review'] > 4 && $ud['library'] == 1)
				{
				    $x = "<p class='ckn'><b class='fojz' data-type='1'>禁止发货</b></p>";
				}
				else if(($ud['review'] > 4) && $ud['print'] != 1 && $value['libraryconfirm'] == 1)
				{
					$x = "<p class='ckn'><b class='fojzof' data-type='6' data-id='".$value['id']."'>允许发货</b></p>";
				}
				if(($ud['review'] > 4) && $ud['print'] == 2)
				{
				    $x = "<p class='ckn'><b class='fojzof' data-type='7' data-id='".$value['id']."'>禁止打印</b></p>";
				}
				else if($ud['review'] >4 && $ud['print'] == 1)
				{
				    $x = "<p class='ckn'><b class='fojzof' data-type='8' data-id='".$value['id']."'>允许打印</b></p>";
				}
				if($value['waybill'] == "" && $ud['review'] > 4)
				{
					$x = $x."<p><b class='kn' data-type='2'>填写运单</b></p>";
				}
				else if($value['waybill'] != "" && $ud['review'] > 4)
				{
					$x = $x."<p><b class='kn' data-type='2'>修改运单</b></p>";
				}
				if(($ud['review'] == 1 || $ud['review'] == 3) && $ud['express'] > 0 && $ud['dtsbjz'] != 0 && $ud['ts'] != 0 && $ud['zsbjz'] != 0 && $ud['zjs'] != 0 && $ud['ts'] != 0)
				{
					$x = $x."<p><b class='focz' data-type='2' data-id='".$value['id']."'>提交审核</b></p>";
				}
				if($value['black'] == 0)
				{
					$x = $x."<p><b class='black' data-type='4' data-id='".$value['id']."'>加黑名单</b></p>";
				}
				$info_list[$key]['black'] = $x;
				$tly = "";
				if($value['clientremarks'] != "")
				{
					$tly = "<p style='color:#FF3333'>有客户留言</p>";
				}
				if($value['state'] == 217)
				{
					$info_list[$key]['orderinfo'] = "<h9 class='window' data-h='/fullorder_smt/readonly/".$value['id']."' data-t='订单号：".$value['orderinfo']."'><p>".$value['orderinfo']."</p>".$tly."</h9>";
				}
				else
				{
					$info_list[$key]['orderinfo'] = "<h9 class='window' data-h='/fullorder_smt/edit/".$value['id']."' data-t='订单号：".$value['orderinfo']."'><p>".$value['orderinfo']."</p>".$tly."</h9>";
				}
				if($value['library'] == 1)
				{
					$info_list[$key]['library'] = "未出库";
				}
				else if($value['library'] == 2)
				{
					$info_list[$key]['library'] = "已出库";
				}
				else if($value['library'] == 3)
				{
					$info_list[$key]['library'] = "退库";
				}
				if($value['fpdata'] != "")
				{
					$info_list[$key]['fpdata'] = "有";
				}
				else
				{
					$info_list[$key]['fpdata'] = "没有";
				}
				
            }
		    $total = $this->fullorder_smt->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['express'] = $this->express->find_all();
		$fullorderexcel = $this->fullorderexcel->find_all('type=1','*','idorder desc');//导出模板
		$this->data['fullorderexcel'] = $fullorderexcel;
		$error = $this->fullorder_smt->find_count("print = 1 and failed !='' and mergeid = 0 and waybill = '' and (".rtrim($fgshop,'or').")");
		$this->data['error'] = $error;
		$this->_Template('fullorder_smt',$this->data);
	}
	
	//管理
	public function _dlz()
	{
		$dt = 0;
		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";
			}
		}
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['page']))
		{
		    $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
			$warehouse = $this->input->post('warehouse',true);
			$xztime = $this->input->post('xztime',true);
			$timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);
			$shop = $this->input->post('shop',true);
			$source = $this->input->post('source',true);
			$state = $this->input->post('state',true);
			$review = $this->input->post('review',true);
			$type = $this->input->post('type',true);
			$express = $this->input->post('express',true);
			$orderinfo = $this->input->post('orderinfo',true);
			$user = $this->input->post('user',true);
			$client = $this->input->post('name',true);
			$waybill = $this->input->post('waybill',true);
			$number = $this->input->post('number',true);
			$email = $this->input->post('email',true);
			$dlz = $this->input->post('dlz',true);
			$print = $this->input->post('print',true);
			$library = $this->input->post('library',true);
			$timetk = strtotime($timetk)+12*3600;
			$timetj = strtotime($timetj)+12*3600;
			$where = "mergeid = 0 and type = 5 and review = 6 and state != 217 and state != 214 and (".rtrim($fgshop,'or').")";
			if($warehouse)
            {
                $where  .= " and type = '$warehouse'";
            }
			if($timetk && $timetj)
            {
                $where .= " and ".$xztime." > '$timetk' and ".$xztime." < '$timetj'";
            }
			if($shop)
            {
                $where  .= " and shop = '$shop'";
            }
			if($source)
            {
                $where  .= " and source = '$source'";
            }
			if($state)
            {
				$where  .= " and state = '$state'";
            }
			if($review)
            {
                $where  .= " and review = '$review'";
            }
			if($type)
            {
                $where  .= " and type = '$type'";
            }
			if($express)
            {
                $where  .= " and express = '$express'";
            }
			if($orderinfo)
            {
                $where  .= " and orderinfo = '$orderinfo'";
            }
			if($user)
            {
                $where  .= " and user = '$user'";
            }
			if($client)
            {
                $where  .= " and client like '%$client%'";
            }
			if($waybill)
            {
                $where  .= " and waybill = '$waybill'";
            }
			if($number)
            {
                $where  .= " and number = '$number'";
            }
			if($email)
            {
                $where  .= " and email = '$email'";
            }
			if($library)
            {
                $where  .= " and library = '$library'";
            }
			if($print)
            {
				if($print = 2)
				{
					 $where  .= " and waybill = ''";
				}
                $where  .= " and print = '$print'";
				
            }
			if($dlz != '')
            {
                $where  .= " and dlz = '$dlz'";
            }
            //数据排序
            $order_str = "dtime desc";
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
            //取得信息列表id,shop,type,source,user,orderinfo,number,name,state,buytime,clientremarks,review,print,library,libraryconfirm,express,waybill,orderremarks,black
            $info_list = $this->fullorder->find_all($where,'id,shop,type,orderinfo,number,client,state,buytime,libraryconfirm,express,waybill,orderremarks,reviewremarks,printnumber,library,black,clientremarks',$order_str,$start,$perpage);
			 //格式化数据
            foreach ($info_list as $key=>$value) 
		    {
				$ud = $this->fullorder->read($value['id']);
				$ud['address'] = str_replace("'","’",$ud['address']);
				$ud['name'] = str_replace("'","’",$ud['name']);
				$customer = $this->customer->get_email($ud['email'],$value['shop']);
				$customerb = $this->customer->get_shopdata($ud['name'],$ud['email'],$ud['address'],$value['shop']);
				//$a = array_column($customer, 'email'); //三维找其中健的数组
			    //$a = array_flip($a); //键和值调换
				$shop = $this->shop->read($value['shop']);
				$info_list[$key]['shop'] = $shop['shopname'];
				//$info_list[$key]['user'] = $shop['shopuser'];
				$warehouse = $this->warehouse->read($value['type']);
				$warehousetitle = $warehouse['title'];
				if($value['type'] != 1){$warehousetitle = "<font style='color:#f64b4b'>".$warehouse['title']."</font>";}
				$info_list[$key]['type'] = $warehousetitle;
				$typeclass = $this->typeclass->read($value['state']);
				$info_list[$key]['state'] = $typeclass['spare'];
				if($ud['source'] == 1) //线下单用订单时间，其他用付款时间
				{
					$info_list[$key]['buytime'] = '<p>'.date('Y-m-d',$ud['dtime']).'</p><p>'.date('H:i:s',$ud['dtime']).'</p>';
				}
				else
				{
				    $info_list[$key]['buytime'] = '<p>'.date('Y-m-d',$value['buytime']+$dt).'</p><p>'.date('H:i:s',$value['buytime']+$dt).'</p>';
				}
				if($value['waybill'] != "")
				{
					$info_list[$key]['waybill'] = "<p>".$value['waybill']."</p>";
				}
				if($value['express'] != 0)
				{
				    $express = $this->express->read($value['express']);
					$expressservicename = $express['servicename'];
				if($value['express'] != 1){$expressservicename = "<font style='color:#f64b4b'>".$express['servicename']."</font>";}
				    $info_list[$key]['express'] = $expressservicename;
				}
				else
				{
					$info_list[$key]['express'] = "无";
				}
				$x = "";
				if($value['libraryconfirm'] == 2 && $ud['review'] > 4 && $ud['library'] == 1)
				{
				    $x = "<p class='ckn'><b class='fojz' data-type='1'>禁止发货</b></p>";
				}
				else if(($ud['review'] > 4) && $ud['print'] != 1 && $value['libraryconfirm'] == 1)
				{
					$x = "<p class='ckn'><b class='fojzof' data-type='6' data-id='".$value['id']."'>允许发货</b></p>";
				}
				if(($ud['review'] > 4) && $ud['print'] == 2)
				{
				    $x = "<p class='ckn'><b class='fojzof' data-type='7' data-id='".$value['id']."'>禁止打印</b></p>";
				}
				else if($ud['review'] >4 && $ud['print'] == 1)
				{
				    $x = "<p class='ckn'><b class='fojzof' data-type='8' data-id='".$value['id']."'>允许打印</b></p>";
				}
				if($value['waybill'] == "" && $ud['review'] > 4)
				{
					$x = $x."<p><b class='kn' data-type='2'>填写运单</b></p>";
				}
				else if($value['waybill'] != "" && $ud['review'] > 4)
				{
					$x = $x."<p><b class='kn' data-type='2'>修改运单</b></p>";
				}
				if(($ud['review'] == 1 || $ud['review'] == 3) && $ud['express'] > 0 && $ud['dtsbjz'] != 0 && $ud['ts'] != 0 && $ud['zsbjz'] != 0 && $ud['zjs'] != 0 && $ud['ts'] != 0)
				{
					$x = $x."<p><b class='focz' data-type='2' data-id='".$value['id']."'>提交审核</b></p>";
				}
				if($value['black'] == 0)
				{
					$x = $x."<p><b class='black' data-type='4' data-id='".$value['id']."'>加黑名单</b></p>";
				}
				$info_list[$key]['black'] = $x;
				$tly = "";
				if($value['clientremarks'] != "")
				{
					$tly = "<p style='color:#FF3333'>有客户留言</p>";
				}
				if($value['state'] == 217)
				{
					$info_list[$key]['orderinfo'] = "<h9 class='window' data-h='/fullorder/readonly/".$value['id']."' data-t='订单号：".$value['orderinfo']."'><p>".$value['orderinfo']."</p>".$tly."</h9>";
				}
				else
				{
					$info_list[$key]['orderinfo'] = "<h9 class='window' data-h='/fullorder/edit/".$value['id']."' data-t='订单号：".$value['orderinfo']."'><p>".$value['orderinfo']."</p>".$tly."</h9>";
				}
				if($value['library'] == 1)
				{
					$info_list[$key]['library'] = "未出库";
				}
				else if($value['library'] == 2)
				{
					$info_list[$key]['library'] = "已出库";
				}
				else if($value['library'] == 3)
				{
					$info_list[$key]['library'] = "退库";
				}
				
            }
		    $total = $this->fullorder->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['express'] = $this->express->find_all();
		$fullorderexcel = $this->fullorderexcel->find_all('type=1','*','idorder desc');//导出模板
		$this->data['fullorderexcel'] = $fullorderexcel;
		$error = $this->fullorder->find_count("print = 1 and failed !='' and mergeid = 0 and waybill = '' and type = 5 and (".rtrim($fgshop,'or').")");
		$this->data['error'] = $error;
		$this->_Template('fullorder_smt_dlz',$this->data);
	}
	
	//筛选重复订单
	public function _repeat()
	{
		$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);
			$timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$where = "print != 3 and (".rtrim($fgshop,'or').")";
			if($shop)
            {
                $where  .= " and shop = '$shop'";
            }
			if($timetk && $timetj)
            {
                $where  .= " and dtime > '$timetk' and dtime < '$timetj'";
            }
            //数据排序
            $order_str = "id desc";
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
            //取得信息列表
            $info_list = $this->fullorder_smt->find_all($where,'id,shop,type,orderinfo,number,state,buytime,name,email,address');
			$info = array();
			$len = count($info_list); 
			 //格式化数据
            foreach ($info_list as $key=>$value) 
		    {
				$shop = $this->shop->read($value['shop']);
				$info_list[$key]['shop'] = $shop['shopname'];
				$warehouse = $this->warehouse->read($value['type']);
				$info_list[$key]['type'] = $warehouse['title'];
				$typeclass = $this->typeclass->read($value['state']);
				$info_list[$key]['state'] = $typeclass['title'];
				$info_list[$key]['buytime'] = '<p>'.date('Y-m-d',$value['buytime']).'</p><p>'.date('H:i:s',$value['buytime']).'</p>';
            }
			/** 操作合并
			if($value['merge'] == 0)
				{
					$info_list[$key]['merge'] = "<p><b class='jd' data-type='5'>合并订单</b></p>";
				}
				else
				{
					if($value['merge'] == $value['id'])
				    {
						$info_list[$key]['merge'] = "已合并";
					}
					else
					{
						$info_list[$key]['merge'] = "被合并";
					}
				}
			**/
			for($i=0;$i<$len;$i++) 
			{ 
			    for($j=$i+1;$j<$len;$j++) 
				{ 
                     if ($info_list[$i]['name'] == $info_list[$j]['name'] || $info_list[$i]['address'] == $info_list[$j]['address'] || $info_list[$i]['email'] == $info_list[$j]['email']) 
					 { 
					     if(!array_key_exists($j,$info))
						 {
							 $info[$j] = $info_list[$j];
						 }
						 if(!array_key_exists($i,$info))
						 {
							 $info[$i] = $info_list[$i];
						 }
						
                     }
                }
            }
			rsort($info);
		    $total = count($info);
		    $pagenum = ceil($total/$perpage);
		    $over = $total-($start+$perpage);
		    $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>(array_slice($info,$start,$perpage)));
		    echo json_encode($rows);exit;
		}
		$this->_Template('fullorder_smt_repeat',$this->data);
	}
	//修改
	public function _edit($arg_array)
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['id']))
		{
			$id = $this->input->post('id',true);
			$data = $this->fullorder_smt->read($id);
			$post['type'] = $this->input->post('warehouse',true);
			$post['country'] = $this->input->post('country',true);
			$currency = $this->country->read($post['country']);
			$post['al'] = $currency['lb'];
			$post['freight'] = $this->input->post('freight',true);
			$post['expressmoney'] = $this->input->post('expressmoney',true);
			$post['shouldmoney'] = $this->input->post('shouldmoney',true);
			$post['orderremarks'] = $this->input->post('orderremarks',true);
			$post['shipremarks'] = $this->input->post('shipremarks');
			$post['email'] = $this->input->post('email',true);
			$name = $this->input->post('name',true);
			$post['name'] = str_replace("'","’",$name);
			$post['phone'] = $this->input->post('phone',true);
			$post['country'] = $this->input->post('country',true);
			$post['province'] = $this->input->post('province',true);
			$post['city'] = $this->input->post('city',true);
			$post['zipcode'] = $this->input->post('zipcode',true);
			$post['street'] = $this->input->post('street',true);
			$address = $this->input->post('address',true);
			$post['address'] = str_replace("'","’",$address);
			$post['express'] = $this->input->post('express',true);
			$post['printtype'] = $this->input->post('printtype',true);
			$post['fpdata'] = $this->input->post('fpdata');
			$post['waybill'] = $this->input->post('waybill',true);
			$post['msg'] = $this->input->post('msg',true);
			$post['zsbjz'] = $this->input->post('zsbjz',true);
			$post['refundy'] = $this->input->post('refundy',true);
			$post['refundj'] = $this->input->post('refundj',true);
			$rtime = $this->input->post('rtime',true);
			$post['rtime'] = strtotime($rtime);
			$post['rpaypal'] = $this->input->post('rpaypal',true);
			$post['rtext'] = $this->input->post('rtext',true);
			$editstate = $this->input->post('state',true);
			$post['review'] = 1;
			if($post['zsbjz'] < '0.01')
			{
				echo json_encode(array('msg'=>'总申报价错误！','success'=>false));exit;
			}
			if($data['library'] == 1)
			{
			    if($data['print'] != 3)
			    {
			    	$post['print'] = 1;
				    $post['libraryconfirm'] = 1;
				    $post['librarynot'] = "订单未打印，未审核或未通过";
			    }
			    else
			    {
			    	$post['libraryconfirm'] = 1;
			    	$post['librarynot'] = "未审核或未通过";
			    }
			}
			if($post['printtype'] == 1)//如果是运单
			{
				$post['productdescription'] = $this->input->post('productdescription',true);
			    $post['customs'] = $this->input->post('customs',true);
			}
			/**
			if($editstate == 216 && $data['state'] != 216)
			{
				echo json_encode(array('msg'=>'不可修改为完成状态','success'=>false));exit;
			}
			**/
			if($editstate == 216 && preg_match('/\d/is',$post['waybill']) != true)
			{
				echo json_encode(array('msg'=>'当前信息不可修改订单状态','success'=>false));exit;
			}
			else
			{
				$post['review'] = $data['review'];
				$post['state'] = $editstate;
			}
			if($this->fullorder_smt->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];$fpdata = array();
		$fullorder_smt = $this->fullorder_smt->read($arg_array);
		$fullorder_smt['parameter'] = str_replace(",","---",$fullorder_smt['parameter']);
		$country = $this->country->find_all('1=1','id,name');//所有国家信息
		$express = $this->express->find_all('1=1');//所有快递配置信息
		$this->data['fullorder_smt'] = $fullorder_smt;
		$this->data['country'] = $country;
		$this->data['express'] = $express;
		$this->data['dtime'] = date('Y-m-d H:i:s',$fullorder_smt['dtime']);
		if(stripos($fullorder_smt['fpdata'],';') !== false)
		{
		    $fpdata = explode(';',rtrim($fullorder_smt['fpdata'],';'));
		    foreach ($fpdata as $k=>$v) 
		    {
			    $fpdata[$k] = explode('|',$v);
            }
		}
		$this->data['fpdata'] = $fpdata;
		$shop = $this->shop->read($fullorder_smt['shop']);
		$this->data['et'] = $shop['estimaterate'];//此店铺配置预计到帐金额比例
		$is = 0;
		if($shop['type'] == 269)//判断是否独立站，269是独立站
		{
			$is = 1;
		}
		$this->data['is'] = $is;
		if(isset($_SESSION['api']))
		{
			$user = $this->user->get_api($_SESSION['api']);
			if($user['power'] == 1)
			{
				$power = 1;
			}
			else
			{
				$power = 0;
			}
		}
		else
		{
			$power = 0;
		}
		$this->data['power'] = $power;
		/** 历史运单号展示并下载PDF 打印时间需要2019-3-21 0点之后有记录 **/
		$downwaybill = '';
		if($fullorder_smt['printtype'] == 1)
		{
			if($fullorder_smt['waybill'] != '')
			{
		        $downwaybill .= '<a href="/data/pdf/'.date('Ymd',$fullorder_smt['printtime']).'/y-'.$fullorder_smt['waybill'].'.pdf" target="_blank">'.$fullorder_smt['waybill'].'</a>、';
			}
		}
		$oldwaybill = explode('-',ltrim($fullorder_smt['oldwaybill'],'-'));
		if(isset($oldwaybill[0][1]))
		{
			$oldwaybill = array_reverse($oldwaybill); //调整顺序
		    foreach ($oldwaybill as $v) 
		    {
				$dw = explode('/',$v);
				if(isset($dw[1]))
				{
			    	$downwaybill .= '<a href="/data/pdf/'.$dw[0].'/y-'.$dw[1].'.pdf" target="_blank">'.$dw[1].'</a>、';
				}
        	}
		}
		$this->data['downwaybill'] = rtrim($downwaybill,'、');
		$this->_Template('fullorder_smt_edit',$this->data);
	}
	//不可修改
	public function _readonly($arg_array)
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['id']))
		{
			$id = $this->input->post('id',true);
			$ud = $this->fullorder_smt->read($id);
			$post['type'] = $this->input->post('warehouse',true);
			$post['orderremarks'] = $this->input->post('orderremarks',true);
			$post['state'] = $this->input->post('state',true);
			$post['msg'] = $this->input->post('msg',true);
			$post['refundy'] = $this->input->post('refundy',true);
			$post['refundj'] = $this->input->post('refundj',true);
			$post['fpdata'] = $this->input->post('fpdata');
			$rtime = $this->input->post('rtime',true);
			$post['rtime'] = strtotime($rtime);
			$post['rpaypal'] = $this->input->post('rpaypal',true);
			$post['rtext'] = $this->input->post('rtext',true);
			/**
			if($post['state'] == 216 && $ud['state'] != 216)
			{
				echo json_encode(array('msg'=>'不可修改为完成状态','success'=>false));exit;
			}
			**/
			if($this->fullorder_smt->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];$fpdata = array();
		$fullorder_smt = $this->fullorder_smt->read($arg_array);
		$fullorder_smt['parameter'] = str_replace(",","---",$fullorder_smt['parameter']);
		$this->data['fullorder_smt'] = $fullorder_smt;
		$this->data['countrys'] = $this->country->find_all();
		$this->data['express'] = $this->express->find_all();
		if(stripos($fullorder_smt['fpdata'],';') !== false)
		{
		    $fpdata = explode(';',rtrim($fullorder_smt['fpdata'],';'));
		    foreach ($fpdata as $k=>$v) 
		    {
			    $fpdata[$k] = explode('|',$v);
            }
		}
		$this->data['fpdata'] = $fpdata;
		$shop = $this->shop->read($fullorder_smt['shop']);
		$this->data['et'] = $shop['estimaterate'];//此店铺配置预计到帐金额比例
		$is = 0;
		if($shop['type'] == 269)//判断是否独立站，269是独立站
		{
			$is = 1;
		}
		$this->data['is'] = $is;
		//单项开始
		$warehouse = $this->warehouse->read($fullorder_smt['warehouse']);//发货仓库
		$state = $this->typeclass->read($fullorder_smt['state']);//订单状态
		$country = $this->country->read($fullorder_smt['country']);//国家
		if($fullorder_smt['capital'] == 1)
		{
			$capital = '暂未支付';
		}
		else if($fullorder_smt['capital'] == 2)
		{
			$capital = '部分支付';
		}
		else if($fullorder_smt['capital'] == 3)
		{
			$capital = '全部支付';
		}
		if($fullorder_smt['printtype'] == 1)
		{
			$printtype = '运单';
		}
		else if($fullorder_smt['printtype'] == 2)
		{
			$printtype = '发货单';
		}
		else if($fullorder_smt['printtype'] == 3)
		{
			$printtype = '不打印单据';
		}
		else
		{
			$printtype = '未选择';
		}
		$this->data['warehouse'] = $warehouse['title'];
		$this->data['state'] = $state['title'];
		$this->data['capital'] = $capital;
		$this->data['country'] = $country['ename'];
		$this->data['printtype'] = $printtype;
		//单项结束
		/** 历史运单号展示并下载PDF 打印时间需要2019-3-21 0点之后有记录 **/
		$downwaybill = '';
		if($fullorder_smt['printtype'] == 1)
		{
			if($fullorder_smt['waybill'] != '')
			{
		        $downwaybill .= '<a href="/data/pdf/'.date('Ymd',$fullorder_smt['printtime']).'/y-'.$fullorder_smt['waybill'].'.pdf" target="_blank">'.$fullorder_smt['waybill'].'</a>、';
			}
		}
		$oldwaybill = explode('-',ltrim($fullorder_smt['oldwaybill'],'-'));
		if(isset($oldwaybill[0][1]))
		{
			$oldwaybill = array_reverse($oldwaybill); //调整顺序
		    foreach ($oldwaybill as $v) 
		    {
				$dw = explode('/',$v);
				if(isset($dw[1]))
				{
			    	$downwaybill .= '<a href="/data/pdf/'.$dw[0].'/y-'.$dw[1].'.pdf" target="_blank">'.$dw[1].'</a>、';
				}
        	}
		}
		$this->data['downwaybill'] = rtrim($downwaybill,'、');
		$this->_Template('fullorder_smt_readonly',$this->data);
	}
	//浏览列表
	public function _readlist()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['page']))
		{
		    $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
			$warehouse = $this->input->post('warehouse',true);
			$express = $this->input->post('express',true);
			$state = $this->input->post('state',true);
			$print = $this->input->post('print',true);
			$libraryconfirm = $this->input->post('libraryconfirm',true);
			$orderinfo = $this->input->post('orderinfo',true);
			$client = $this->input->post('name',true);
			$email = $this->input->post('email',true);
			$number = $this->input->post('number',true);
			$waybill = $this->input->post('waybill',true);
			$timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);	
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$where = "mergeid = 0";
			if($warehouse)
            {
                $where  .= " and type = '$warehouse'";
            }
			if($express)
            {
                $where  .= " and express = '$express'";
            }
			if($state)
            {
				$where  .= " and state = '$state'";
            }
			if($print)
            {
				$where  .= " and print = '$print'";
            }
			if($libraryconfirm)
            {
				$where  .= " and libraryconfirm = '$libraryconfirm'";
            }
			if($orderinfo)
            {
                $where  .= " and orderinfo = '$orderinfo'";
            }
			if($client)
            {
                $where  .= " and client like '%$client%'";
            }
			if($email)
            {
                $where  .= " and email = '$email'";
            }
			if($number)
            {
                $where  .= " and number = '$number'";
            }
			if($waybill)
            {
                $where  .= " and waybill = '$waybill'";
            }
			if($timetk && $timetj)
            {
				$timetj = $timetj+24*3600;
                $where  .= " and dtime > '$timetk' and dtime < '$timetj'";
            }
            //数据排序
            $order_str = "dtime desc";
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
            //取得信息列表
            $info_list = $this->fullorder_smt->find_all($where,'id,type,orderinfo,number,client,state,buytime,express,waybill,print,library,orderremarks',$order_str,$start,$perpage);
			 //格式化数据
            foreach ($info_list as $key=>$value) 
		    {
				$ud = $this->fullorder_smt->read($value['id']);
				$warehouse = $this->warehouse->read($value['type']);
				$info_list[$key]['type'] = $warehouse['title'];
				$typeclass = $this->typeclass->read($value['state']);
				$info_list[$key]['state'] = $typeclass['spare'];
				if($ud['source'] == 1) //线下单用订单时间，其他用付款时间
				{
					$info_list[$key]['buytime'] = '<p>'.date('Y-m-d',$ud['dtime']).'</p><p>'.date('H:i:s',$ud['dtime']).'</p>';
				}
				else
				{
				    $info_list[$key]['buytime'] = '<p>'.date('Y-m-d',$value['buytime']).'</p><p>'.date('H:i:s',$value['buytime']).'</p>';
				}
				$express = $this->express->read($value['express']);
				$info_list[$key]['express'] = $express['servicename'];
				if($value['print'] == 1)
				{
					$info_list[$key]['print'] = "不可打印";
				}
				else if($value['print'] == 2)
				{
					$info_list[$key]['print'] = "未打印";
				}
				else if($value['print'] == 3)
				{
					$info_list[$key]['print'] = '<p>'.date('Y-m-d',$ud['printtime']).'</p><p>'.date('H:i:s',$ud['printtime']).'</p>';
				}
				if($value['library'] == 1)
				{
					$info_list[$key]['library'] = "未出库";
				}
				else if($value['library'] == 2)
				{
					$info_list[$key]['library'] = '<p>'.date('Y-m-d',$ud['librarytime']).'</p><p>'.date('H:i:s',$ud['librarytime']).'</p>';
				}
				else if($value['library'] == 3)
				{
					$info_list[$key]['library'] = "已退库";
				}
            }
			$total = $this->fullorder_smt->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;
		}
		$this->_Template('fullorder_smt_readlist',$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;
            }
            //循环删除记录
            foreach ($id_arr as $v) 
		    {
                $this->fullorder_smt->remove($v);
            }
            echo json_encode(array('del'=>$id_arr,'msg'=>'删除记录成功！','success'=>true));
		}
    }
	//查找商品价格
	public function _price()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['data']))  
		{
            $data = $this->input->post('data');
            $data =  explode('-',$data);
			$number = '';$num = count($data);
            //循环删除记录
            for($i=0;$i<$num-1;$i++)
		    {
				if($data[$i] != 0)
				{
				    $number=$number.$data[$i];
					if($i == 2)
				    {
					    $number=$number.$data[$num-1];
				    }
				}
            }
			$list = $this->productdescribe->get_number($number);
			if($list)
			{
				echo json_encode(array('msg'=>($list),'n'=>$data[$num-1],'number'=>$number,'success'=>true));
			}
			else
			{
				$list = array('purchase'=>0,'cost'=>0,'salesprice'=>0);
				//echo json_encode(array('msg'=>'此信息没有配置价格！','n'=>$data[$num-1],'success'=>false));exit;
				echo json_encode(array('msg'=>($list),'n'=>$data[$num-1],'number'=>$number,'success'=>true));exit;
			}
		}
    }
	
	public function _customs()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['e']))  
		{
			$e = $this->input->post('e');//快递信息
			$c = $this->input->post('c');//国家信息
            $data = $this->customs->find_all('express = "'.$e.'" and country = "'.$c.'"');
			$list = $this->productdescription->find_all('express = "'.$e.'" and country = "'.$c.'"');
			$rows = array();
			foreach ($data as $key=>$value) 
		    {
				$detailed = explode('|',trim($value['detailed'],'|'));
				//此处未对比重量选择价值，暂直接选择第一条海关价值
				$detailed = $this->detailed->read($detailed[0]);
				$money = $detailed['customsval'];//找到海关价值
			}
			foreach ($list as $key=>$value) 
		    {
				$description = $this->typeclass->read($value['description']);
				$list[$key]['title'] = $description['title'];//产品描述名称
				
			}
			if(!$data && !$list)
			{
				echo json_encode(array('msg'=>'无此快递配置信息！','success'=>false));exit;
			}
			else
			{
				//$list-title -description 取值
				echo json_encode(array('money'=>sprintf("%.2f",$money),'msg'=>$list,'success'=>true));
			}
		}
    }
	public function _express()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['e']))  
		{
			$e = $this->input->post('e');//快递信息
			$c = $this->input->post('c');//国家信息
            $data = $this->logistics->find_all('express = "'.$e.'" and country = "'.$c.'"');
			if(!$data)
			{
				echo json_encode(array('success'=>false));exit;
			}
			else
			{
				echo json_encode(array('money'=>sprintf("%.2f",$data[0]['firstmoney']),'success'=>true));
			}
		}
    }
	public function _hl()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['cy']))  
		{
			$hl = 0;
			$cy = $this->input->post('cy');//币种ID
			$cy = $this->typeclass->read($cy);
			$gethl = $this->hl->get_hl();
			foreach ($gethl as $v) 
		    {
				$code = str_replace(" ","",$v['code']);
				if($code == $cy['title'])
				{
					$hl = $v['refePrice']/100;
				}
				
			}
			echo json_encode(array('msg'=>$hl,'success'=>true));
		}
    }
	public function _operation()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['type']))  
		{
			$type = $this->input->post('type');
			$id = $this->input->post('id');
			$msg = $this->input->post('msg');
			if($type == 1)//禁止发货
			{
				$d = $this->fullorder_smt->read($id);
				if($d['library'] != 1)
				{
					echo json_encode(array('msg'=>'操作失败，订单非未出库状态！','success'=>false));exit;
				}
				if($d['print'] < 3)
				{
					$a = "订单未打印，";
				}
				else
				{
					$a = "";
				}
				if($this->fullorder_smt->save(array('libraryconfirm'=>1,'librarynot'=>$a.$msg),$id))
        	    {
         		    echo json_encode(array('msg'=>'操作成功','l'=>1,'d'=>$id,'success'=>true));exit;
       	 	    }
       		    else
        	    {
           	    	echo json_encode(array('msg'=>'操作失败，请重试','success'=>false));exit;
        	    }
			}
			if($type == 6)//允许发货
			{
				$d = $this->fullorder_smt->read($id);
				if($d['print'] < 3)
				{
					$a = "订单未打印，";
				}
				else
				{
					$a = "";
				}
				if($this->fullorder_smt->save(array('libraryconfirm'=>2,'librarynot'=>$a.$msg),$id))
        	    {
         		    echo json_encode(array('msg'=>'操作成功','l'=>1,'d'=>$id,'success'=>true));exit;
       	 	    }
       		    else
        	    {
           	    	echo json_encode(array('msg'=>'操作失败，请重试','success'=>false));exit;
        	    }
			}
			if($type == 7)//禁止打印
			{
				$d = $this->fullorder_smt->read($id);
				if($d['print'] == 3)
				{
					echo json_encode(array('msg'=>'操作失败，订单已打印！','success'=>false));exit;
				}
				if($d['print'] < 3)
				{
					$a = "订单未打印，";
				}
				else
				{
					$a = "";
				}
				if($this->fullorder_smt->save(array('print'=>1),$id))
        	    {
         		    echo json_encode(array('msg'=>'操作成功','l'=>2,'d'=>$id,'success'=>true));exit;
       	 	    }
       		    else
        	    {
           	    	echo json_encode(array('msg'=>'操作失败，请重试','success'=>false));exit;
        	    }
			}
			if($type == 8)//允许打印
			{
				$d = $this->fullorder_smt->read($id);
				if($d['print'] < 3)
				{
					$a = "订单未打印，";
				}
				else
				{
					$a = "";
				}
				if($this->fullorder_smt->save(array('print'=>2,'failed'=>''),$id))
        	    {
         		    echo json_encode(array('msg'=>'操作成功','l'=>2,'d'=>$id,'success'=>true));exit;
       	 	    }
       		    else
        	    {
           	    	echo json_encode(array('msg'=>'操作失败，请重试','success'=>false));exit;
        	    }
			}
			else if($type == 2)//填写运单、修改运单
			{
				$d = $this->fullorder_smt->read($id);
				if($d['express'] == 0)
				{
					echo json_encode(array('msg'=>'操作失败，未选择物流方式！','success'=>false));exit;
				}
				if($d['library'] == 3 || ($d['print'] == 3 && $d['libraryconfirm'] == 1))
				{
					echo json_encode(array('msg'=>'操作失败，不允许填写运单号！','success'=>false));exit;
				}
				//$fs = $this->notice->get_ordertatus(216);//216成功状态
				$gx['res'] = 3;
				$gx['state'] = 216;
				if($gx['res'] > 0 && isset($fs))
				{
					$warehouse = $this->warehouse->read($xg['type']);
					$ck = $this->_email($fs['content'],$xg,$warehouse['company']);
				}
				if($this->fullorder_smt->save(array('waybill'=>$msg,'state'=>$gx['state']),$id))
        	    {
         		    echo json_encode(array('msg'=>'操作成功','success'=>true));exit;
       	 	    }
       		    else
        	    {
           	    	echo json_encode(array('msg'=>'操作失败，请重试','success'=>false));exit;
        	    }
			}
		}
    }
		public function _merge()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['type']))  
		{
			$type = $this->input->post('type');
			$id = $this->input->post('id');
				$u = $this->fullorder_smt->read($id);
				$rows =  $this->fullorder_smt->find_all('name = "'.$u['name'].'" or email = "'.$u['email'].'" or address = "'.$u['address'].'"','*','id desc');
				if(count($rows)>1)
				{
					$this->db->trans_begin();
					$fpdata=$rows[0]['fpdata'];//购买产品
					$shouldmoney=$rows[0]['shouldmoney'];//购买应收金额
					$budget=$rows[0]['budget'];//预估到帐金额
					$cost=$rows[0]['cost'];//成本金额
					$merge=$rows[0]['id'];
					$d = array($rows[0]['id']);
					for($i=1;$i<count($rows);$i++) 
		            {
					    $fpdata=$fpdata.$rows[$i]['fpdata'];
						$shouldmoney=$shouldmoney+$rows[$i]['shouldmoney'];
						$budget=$budget+$rows[$i]['budget'];
						$cost=$cost+$rows[$i]['cost'];
						$d[] = $rows[$i]['id'];
						$this->fullorder_smt->save(array('merge'=>$rows[0]['id'],'mergeid'=>1),$rows[$i]['id']);
				    }
					$this->fullorder_smt->save(array('fpdata'=>$fpdata,'shouldmoney'=>$shouldmoney,'budget'=>$budget,'cost'=>$cost,'merge'=>$merge),$rows[0]['id']);
					if ($this->db->trans_status() === FALSE)
					{
					    $this->db->trans_commit();
					     echo json_encode(array('msg'=>'操作失败，请重试','success'=>false));exit;
					}
					else
					{
					    $this->db->trans_commit();
						echo json_encode(array('msg'=>'操作成功','d'=>($d),'b'=>$rows[0]['id'],'success'=>true));
					}
					
				}
			}
		}

	//评价管理
	public function _evaluate()
	{
		$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);
			$where = "1=1 and evaluate = 0 and (".rtrim($fgshop,'or').")";
			if($shop)
            {
                $where  .= " and shop = '$shop'";
            }
            //数据排序
            $order_str = "id desc";
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
            //取得信息列表
            $info_list = $this->fullorder_smt->find_all($where,'id,shop,orderinfo,number,operation',$order_str,$start,$perpage);
			 //格式化数据
            foreach ($info_list as $key=>$value) 
		    {
				$shop = $this->shop->read($value['shop']);
				$info_list[$key]['shop'] = $shop['shopname'];
				$info_list[$key]['operation'] = "评价";
            }
		    $total = $this->fullorder_smt->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;
		}
		$this->_Template('fullorder_smt_evaluate',$this->data);
	}
	
	//订单消息
	public function _state()
	{
		$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);
			$timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);
			$shop = $this->input->post('shop',true);
			$source = $this->input->post('source',true);
			$state = $this->input->post('state',true);
			$review = $this->input->post('review',true);
			$expressstate = $this->input->post('expressstate',true);
			$express = $this->input->post('express',true);
			$orderinfo = $this->input->post('orderinfo',true);
			$user = $this->input->post('user',true);
			$name = $this->input->post('name',true);
			$waybill = $this->input->post('waybill',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$where = "1=1 and mergeid = 0 and (".rtrim($fgshop,'or').")";
			if($timetk && $timetj)
            {
                $where  .= " and dtime > '$timetk' and dtime < '$timetj'";
            }
			if($shop)
            {
                $where  .= " and shop = '$shop'";
            }
			if($source)
            {
                $where  .= " and source = '$source'";
            }
			if($state)
            {
				$where  .= " and state = '$state'";
            }
			if($review)
            {
                $where  .= " and review = '$review'";
            }
			if($expressstate != "")
            {
                $where  .= " and expressstate = '$expressstate'";
            }
			if($express)
            {
                $where  .= " and express = '$express'";
            }
			if($orderinfo)
            {
                $where  .= " and orderinfo = '$orderinfo'";
            }
			if($user)
            {
                $where  .= " and user = '$user'";
            }
			if($name)
            {
                $where  .= " and name = '$name'";
            }
			if($waybill)
            {
                $where  .= " and waybill = '$waybill'";
            }
            //数据排序
            $order_str = "id desc";
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
            //取得信息列表
            $info_list = $this->fullorder_smt->find_all($where,'id,shop,user,orderinfo,number,country,state,review,library,librarytime,expressstate,express,waybill,fscontent',$order_str,$start,$perpage);
			 //格式化数据
            foreach ($info_list as $key=>$value) 
		    {
				$shop = $this->shop->read($value['shop']);
				$info_list[$key]['shop'] = $shop['shopname'];
				$info_list[$key]['user'] = $shop['shopuser'];
				$country = $this->country->read($value['country']);
				$info_list[$key]['country'] = $country['name'];
				$state = $this->typeclass->read($value['state']);
				$info_list[$key]['state'] = $state['title'];
				if($value['review'] == 1)
				{
					$info_list[$key]['review'] = "未送审";
				}
				else if($value['review'] == 2)
				{
					$info_list[$key]['review'] = "待审核";
				}
				else if($value['review'] == 3)
				{
					$info_list[$key]['review'] = "不通过";
				}
				else if($value['review'] == 4)
				{
					$info_list[$key]['review'] = "取消重审";
				}
				else if($value['review'] == 5)
				{
					$info_list[$key]['review'] = "审核通过";
				}
				else if($value['review'] == 6)
				{
					$info_list[$key]['review'] = "自动通过";
				}
				if($value['library'] == 1)
				{
					$info_list[$key]['library'] = "未出库";
				}
				else if($value['library'] == 2)
				{
					$info_list[$key]['library'] = "已出库";
				}
				else if($value['library'] == 3)
				{
					$info_list[$key]['library'] = "已退库";
				}
				if($value['librarytime'] == '0')
				{
					$info_list[$key]['librarytime'] = '无';
				}
				else
				{
					$info_list[$key]['librarytime'] = date('Y-m-d H:i:s',$value['librarytime']);
				}
				if($value['expressstate'] == 0)
				{
					$info_list[$key]['expressstate'] = "未取件";
				}
				else if($value['expressstate'] == 1)
				{
					$info_list[$key]['expressstate'] = "已取件";
				}
				else if($value['expressstate'] == 2)
				{
					$info_list[$key]['expressstate'] = "离开中国";
				}
				else if($value['expressstate'] == 3)
				{
					$info_list[$key]['expressstate'] = "到达目的国";
				}
				else if($value['expressstate'] == 4)
				{
					$info_list[$key]['expressstate'] = "已派送";
				}
				$express = $this->express->read($value['express']);
				$info_list[$key]['express'] = $express['servicename'];
            }
		    $total = $this->fullorder_smt->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;
		}
		$this->data['express'] = $this->express->find_all();
		$this->_Template('fullorder_smt_state',$this->data);
	}
	
	//审核订单
	public function _review()
	{
		$user = $this->user->get_api($_SESSION['api']);
		$fgshop = "";
		if($user)
		{
		    $fgshop = "";$sid = "";
		    $user = explode('|',trim($user['shop'],'|'));
			foreach ($user as $value) 
		    {
				$fgshop .= " shop = ".$value." or";
			}
			$fgshop = " and (".rtrim($fgshop,'or').")";
		}
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['page']))  
		{
		    $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
			$source = $this->input->post('source',true);
			$warehouse = $this->input->post('warehouse',true);
			$express = $this->input->post('express',true);
			$user = $this->input->post('user',true);
			$shop = $this->input->post('shop',true);
			$review = $this->input->post('review',true);
			$orderinfo = $this->input->post('orderinfo',true);
			$timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$where = "mergeid = 0".$fgshop;
			if($timetk && $timetj)
            {
                $where  .= " and buytime > '$timetk' and buytime < '$timetj'";
            }
			if($source)
            {
                $where  .= " and source = '$source'";
            }
			if($shop)
            {
                $where  .= " and shop = '$shop'";
            }
			if($warehouse)
            {
                $where  .= " and type = '$warehouse'";
            }
			if($express)
            {
                $where  .= " and express = '$express'";
            }
			if($user)
            {
                $where  .= " and user = '$user'";
            }
			if($review)
            {
                $where  .= " and review = '$review'";
            }
			if($orderinfo)
            {
                $where  .= " and orderinfo = '$orderinfo'";
            }
            //数据排序
            $order_str = "id desc";
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
            //取得信息列表
             $info_list = $this->fullorder_smt->find_all($where,'id,shop,user,type,orderinfo,number,client,express,buytime,shouldmoney,review,currencytitle,library');
			 //格式化数据
            foreach ($info_list as $key=>$value) 
		    {
				$lr = $this->fullorder_smt->read($value['id']);
				$shop = $this->shop->read($value['shop']);
				$info_list[$key]['shop'] = $shop['shopname'];
				$info_list[$key]['user'] = $shop['shopuser'];
				$warehouse = $this->warehouse->read($value['type']);
				$info_list[$key]['type'] = $warehouse['title'];
				$express = $this->express->read($value['express']);
				$info_list[$key]['express'] = $express['servicename'];
				$info_list[$key]['buytime'] = '<p>'.date('Y-m-d',$value['buytime']).'</p><p>'.date('H:i:s',$value['buytime']).'</p>';
				if($value['review'] == 1)
				{
					$info_list[$key]['review'] = "未送审";
				}
				else if($value['review'] == 2)
				{
					$info_list[$key]['review'] = "待审核";
				}
				else if($value['review'] == 3)
				{
					$info_list[$key]['review'] = "不通过";
				}
				else if($value['review'] == 4)
				{
					$info_list[$key]['review'] = "取消重审";
				}
				else if($value['review'] == 5)
				{
					$info_list[$key]['review'] = "审核通过";
				}
				else if($value['review'] == 6)
				{
					$info_list[$key]['review'] = "自动通过";
				}
				if($value['review'] == 2)
				{
					$info_list[$key]['library'] = "<p><b class='focz' data-type='5' data-id='".$value['id']."'>审核通过</b></p><p><b class='focz' data-type='3' data-id='".$value['id']."'>不通过</b></p>";
				}
				else if($value['review'] == 3)
				{
					$info_list[$key]['library'] = "<p><b class='fullorderreview' data-type='5' data-id='".$value['id']."'>审核通过</b></p>";
				}
				else if($value['review'] == 5)
				{
					$info_list[$key]['library'] = "<p><b class='fullorderreview' data-type='3' data-id='".$value['id']."'>不通过</b></p>";
				}
				else
				{
					$info_list[$key]['library'] = "";
				}
				$info_list[$key]['shouldmoney'] = $value['shouldmoney'].' '.$lr['currencytitle'];
				$lr['hl'] = $lr['hl']==0?6.71:$lr['hl'];
				$cost = $lr['cost']/$lr['hl'];
				$currencytitle = $lr['budget']-$lr['refundj']-$cost-$lr['expressmoney'];
				$info_list[$key]['currencytitle'] = sprintf("%.2f",$currencytitle).' '.$lr['currencytitle'];
            }
		    $total = $this->fullorder_smt->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;
		}
		$this->_Template('fullorder_smt_review',$this->data);
	}
	
	//导出资金统计excel
	public function _fmexcel()
	{
		$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";
			}
		}
		if(isset($_GET['excel']))  
		{
			$timetk = $this->input->get('timetk',true);
			$timetj = $this->input->get('timetj',true);
			$shop = $this->input->get('shop',true);
			$source = $this->input->get('source',true);
			$state = $this->input->get('state',true);
			$type = $this->input->get('type',true);
			$orderinfo = $this->input->get('orderinfo',true);
			$user = $this->input->get('user',true);
			$name = $this->input->get('name',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$where = "1=1 and mergeid = 0 and (".rtrim($fgshop,'or').")";
			if($timetk && $timetj)
            {
                $where  .= " and buytime > '$timetk' and buytime < '$timetj'";
            }
			if($shop)
            {
                $where  .= " and shop = '$shop'";
            }
			if($source)
            {
                $where  .= " and source = '$source'";
            }
			if($state)
            {
				if($state == 1)
				{
                    $where  .= " and state = '$state'";
				}
            }
			if($type)
            {
                $where  .= " and type = '$type'";
            }
			if($orderinfo)
            {
                $where  .= " and orderinfo = '$orderinfo'";
            }
			if($user)
            {
                $where  .= " and user = '$user'";
            }
			if($name)
            {
                $where  .= " and name = '$name'";
            }
            //取得信息列表
            $info_list = $this->fullorder_smt->find_all($where,'id,shop,user,number,orderinfo,client,country,dtime,ftime,express,waybill,shouldmoney,refund,currency,budget,fpdata,hl,currencytitle');
			 //格式化数据
			 $i = 1;$shouldmoney = 0;$refund = 0;$budget = 0;$currency = 0;$hl=1;
            foreach ($info_list as $key=>$value) 
		    {
				$info_list[$key]['id'] = $i;
				
				if($value['currencytitle'] != "CNY")
				{
					$hl=$value['hl'];
				}
				$shouldmoney=$shouldmoney+($value['shouldmoney']*$hl);
				$budget=$budget+($value['budget']*$hl);
				$currency=$currency+(($value['shouldmoney']-$value['budget'])*$hl);
				$refund=$refund+($value['refund']*$hl);
				
				$shop = $this->shop->read($value['shop']);
				$info_list[$key]['shop'] = $shop['shopname'];
				$info_list[$key]['user'] = $shop['shopuser'];
				$info_list[$key]['dtime'] = date('Y-m-d H:i:s',$value['dtime']);
				$info_list[$key]['ftime'] = date('Y-m-d H:i:s',$value['ftime']);
				$country = $this->country->read($value['country']);
				$info_list[$key]['country'] = $country['name'];
				$express = $this->express->read($value['express']);
				$info_list[$key]['express'] = $express['servicename'];
				$info_list[$key]['shouldmoney'] = $value['shouldmoney'].' '.$value['currencytitle'];
				$info_list[$key]['refund'] = $value['refund'].' '.$value['currencytitle'];
				$info_list[$key]['budget'] = $value['budget'].' '.$value['currencytitle'];
				$info_list[$key]['currency'] = sprintf("%.2f",$value['shouldmoney']-$value['budget']).' '.$value['currencytitle'];
				$fpdata = array();
				if(stripos($value['fpdata'],';') !== false)
				{
		   		    $fpdata = explode(';',rtrim($value['fpdata'],';'));
		            foreach ($fpdata as $ke=>$va)
		            {
			            $v = explode('|',rtrim($va,'|'));
					    $fpdata[$ke] = array($v[4],$v[5],$v[6],$v[5]*$v[6]);//内容，条数，数量，总条数
                    }
				}
				$info_list[$key]['fpdata'] = $fpdata;
				$i++;
            }
			$data = array($shouldmoney.' CNY',$refund.' CNY',$currency.' CNY',$budget.' CNY');
            $title = "订单资金信息"; 
            $titlename = "<table border=1>
            <tr><th colspan='14' align='left'><h3>".$title."<h3></th></tr>
            <tr>
            <td>NO.</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>
            <table border=1>
            <tr><td colspan='3' align='center'>订单产品信息</td></tr>
            <tr>
            <td>产品</td>
            <td>条数</td>
            <td>数量</td>
            </tr>
            </table>
            </td>
			<td>总条数</td>
            </tr>
            </table>"; 
            $filename = $title.".xls"; 
			$tail = "<tr><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td></td><td>合计：</td><td>".$data[0]."</td><td>".$data[1]."</td><td>".$data[2]."</td><td>".$data[3]."</td></tr>\n"; 
            $this->excel->get_fz($info_list,$titlename,$filename,$tail);
	    }
	}
	//导出订单excel
	public function _fdexcel()
	{
		if(isset($_GET['excel']))  
		{
			$page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
			$timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);
			$shop = $this->input->post('shop',true);
			$source = $this->input->post('source',true);
			$state = $this->input->post('state',true);
			$review = $this->input->post('review',true);
			$express = $this->input->post('express',true);
			$orderinfo = $this->input->post('orderinfo',true);
			$user = $this->input->post('user',true);
			$name = $this->input->post('name',true);
			$waybill = $this->input->post('waybill',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$where = "1=1 and mergeid = 0";
			if($timetk && $timetj)
            {
                $where  .= " and buytime > '$timetk' and buytime < '$timetj'";
            }
			if($shop)
            {
                $where  .= " and shop = '$shop'";
            }
			if($source)
            {
                $where  .= " and source = '$source'";
            }
			if($state)
            {
				$where  .= " and state = '$state'";
            }
			if($review)
            {
                $where  .= " and review = '$review'";
            }
			if($express)
            {
                $where  .= " and express = '$express'";
            }
			if($orderinfo)
            {
                $where  .= " and orderinfo = '$orderinfo'";
            }
			if($user)
            {
                $where  .= " and user = '$user'";
            }
			if($name)
            {
                $where  .= " and name = '$name'";
            }
			if($waybill)
            {
                $where  .= " and waybill = '$waybill'";
            }
            //取得信息列表
            $info_list = $this->fullorder_smt->find_all($where,'id,shop,number,orderinfo,source,client,name,address,city,zipcode,province,country,phone,dtime,ftime,state,shouldmoney,express,waybill,orderremarks,clientremarks,fpdata,hl,currencytitle');
			 //格式化数据
			 $i = 1;$shouldmoney = 0;$hl=1;
            foreach ($info_list as $key=>$value) 
		    {
				$info_list[$key]['id'] = $i;
				if($value['source'] == 1)
				{
					$info_list[$key]['source'] = "线下订单";
				}
				else if($value['source'] == 2)
				{
					$info_list[$key]['source'] = "PC订单";
				}
				else if($value['source'] == 3)
				{
					$info_list[$key]['source'] = "手机订单";
				}
				
				if($value['currencytitle'] != "CNY")
				{
					$hl=$value['hl'];
				}
				$shouldmoney=$shouldmoney+($value['shouldmoney']*$hl);
				
				$shop = $this->shop->read($value['shop']);
				$info_list[$key]['shop'] = $shop['shopname'];
				$info_list[$key]['dtime'] = date('Y-m-d H:i:s',$value['dtime']);
				$info_list[$key]['ftime'] = date('Y-m-d H:i:s',$value['ftime']);
				$state = $this->typeclass->read($value['state']);
				$info_list[$key]['state'] = $state['title'];
				$country = $this->country->read($value['country']);
				$info_list[$key]['country'] = $country['name'];
				$express = $this->express->read($value['express']);
				$info_list[$key]['express'] = $express['servicename'];
				$info_list[$key]['shouldmoney'] = $value['shouldmoney'].' '.$value['currencytitle'];
				$fpdata = array();
				if(stripos($value['fpdata'],';') !== false)
				{
		   		    $fpdata = explode(';',rtrim($value['fpdata'],';'));
		            foreach ($fpdata as $ke=>$va)
		            {
			            $v = explode('|',rtrim($va,'|'));
					    $fpdata[$ke] = array($v[4],$v[5],$v[6],$v[5]*$v[6]);//内容，条数，数量，总条数
                    }
				}
				$info_list[$key]['fpdata'] = $fpdata;
				$i++;
            }
			$data = array($shouldmoney.' CNY');
            $title = "订单信息表"; 
            $titlename = "<table border=1>
            <tr><th colspan='14' align='left'><h3>".$title."<h3></th></tr>
            <tr>
            <td>NO.</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>订单状态</td>
			<td>订单金额</td>
			<td>快递公司</td>
			<td>运单号</td>
			<td>订单备注</td>
			<td>客户备注</td>
            <td>
            <table border=1>
            <tr><td colspan='3' align='center'>订单产品信息</td></tr>
            <tr>
            <td>产品</td>
            <td>条数</td>
            <td>数量</td>
            </tr>
            </table>
            </td>
			<td>总条数</td>
            </tr>
            </table>"; 
            $filename = $title.".xls"; 
			$tail = "<tr><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><td>合计：</td><td>".$data[0]."</td></tr>\n"; 
            $this->excel->get_fz($info_list,$titlename,$filename,$tail);
	    }
	}
	public function _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";
			}
		}
		if(isset($_GET['excel']))
		{
			$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');
			}
			$warehouse = $this->input->get('warehouse',true);
			$xztime = $this->input->get('xztime',true);
			$timetk = $this->input->get('timetk',true);
			$timetj = $this->input->get('timetj',true);
			$shop = $this->input->get('shop',true);
			$source = $this->input->get('source',true);
			$state = $this->input->get('state',true);
			$review = $this->input->get('review',true);
			$type = $this->input->get('type',true);
			$express = $this->input->get('express',true);
			$orderinfo = $this->input->get('orderinfo',true);
			$user = $this->input->get('user',true);
			$client = $this->input->get('name',true);
			$waybill = $this->input->get('waybill',true);
			$number = $this->input->get('number',true);
			$email = $this->input->get('email',true);
			$dlz = $this->input->get('dlz',true);
			$print = $this->input->get('print',true);
			$library = $this->input->get('library',true);
			$timetk = strtotime($timetk)+12*3600;
			$timetj = strtotime($timetj)+12*3600;
			$where = "mergeid = 0 and (".rtrim($fgshop,'or').")";
			if($timetk && $timetj)
            {
                $where .= " and ".$xztime." > '$timetk' and ".$xztime." < '$timetj'";
            }
			if($shop)
            {
                $where  .= " and shop = '$shop'";
            }
			if($source)
            {
                $where  .= " and source = '$source'";
            }
			if($state)
            {
				$where  .= " and state = '$state'";
            }
			if($type)
            {
                $where  .= " and type = '$type'";
            }
			if($orderinfo)
            {
                $where  .= " and orderinfo = '$orderinfo'";
            }
			if($user)
            {
                $where  .= " and user = '$user'";
            }
			if($name)
            {
                $where  .= " and name = '$name'";
            }
			if($print)
            {
                $where  .= " and print = '$print'";
            }
			if($library)
            {
                $where  .= " and library = '$library'";
            }
            //取得信息列表
            $info_list = $this->fullorder_smt->find_all($where.$wid,'id,shop,number,orderinfo,client,country,province,city,zipcode,address,phone,waybill,shipremarks,zzl,bx,qm,js,dtime,printtime,librarytime,retreattime');
			 //格式化数据
			 $i = 1;
            foreach ($info_list as $key=>$value) 
		    {
				$shop = $this->shop->read($value['shop']);
				$info_list[$key]['shop'] = $shop['shopname'];
				$info_list[$key]['id'] = $i;
				$country = $this->country->read($value['country']);
				$info_list[$key]['country'] = $country['ename'];
				$info_list[$key]['qm'] = ($value['qm']==1)?'需要签名':'不签名';
				$info_list[$key]['js'] = ($value['js']==1)?'优先服务':'普通';
				$info_list[$key]['dtime'] = date('Y-m-d H:i:s',$value['dtime']-12*3600);
				$info_list[$key]['printtime'] = ($value['printtime']!=0)?date('Y-m-d H:i:s',$value['printtime']-12*3600):'';
				$info_list[$key]['librarytime'] = ($value['librarytime']!=0)?date('Y-m-d H:i:s',$value['librarytime']-12*3600):'';
				$info_list[$key]['retreattime'] = ($value['retreattime']!=0)?date('Y-m-d H:i:s',$value['retreattime']-12*3600):'';
				$i++;
            }
            $title = "速卖通订单信息"; 
            $titlename = "<table border=1>
            <tr><th colspan='17' align='left'><h3>".$title."<h3></th></tr>
            <tr>
            <td>NO.</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>签名</td>
			<td>快递服务</td>
			<td>订单时间(美国时间)</td>
			<td>打印时间(美国时间)</td>
			<td>出库时间(美国时间)</td>
			<td>退库时间(美国时间)</td>
            </table>"; 
            $filename = $title.".xls"; 
			$tail = "<tr><td></td></tr>\n"; 
            $this->excel->get_fz2($info_list,$titlename,$filename,$tail);
	    }
	}
	
	public function _exceldlz()
	{
		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";
			}
		}
		if(isset($_GET['excel']))
		{
			$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');
			}
			$warehouse = $this->input->get('warehouse',true);
			$xztime = $this->input->get('xztime',true);
			$timetk = $this->input->get('timetk',true);
			$timetj = $this->input->get('timetj',true);
			$shop = $this->input->get('shop',true);
			$source = $this->input->get('source',true);
			$state = $this->input->get('state',true);
			$review = $this->input->get('review',true);
			$type = $this->input->get('type',true);
			$express = $this->input->get('express',true);
			$orderinfo = $this->input->get('orderinfo',true);
			$user = $this->input->get('user',true);
			$client = $this->input->get('name',true);
			$waybill = $this->input->get('waybill',true);
			$number = $this->input->get('number',true);
			$email = $this->input->get('email',true);
			$dlz = $this->input->get('dlz',true);
			$print = $this->input->get('print',true);
			$library = $this->input->get('library',true);
			$timetk = strtotime($timetk)+12*3600;
			$timetj = strtotime($timetj)+12*3600;
			$where = "mergeid = 0 and  type = 5 and review = 6 and (".rtrim($fgshop,'or').")";
			if($timetk && $timetj)
            {
                $where .= " and ".$xztime." > '$timetk' and ".$xztime." < '$timetj'";
            }
			if($shop)
            {
                $where  .= " and shop = '$shop'";
            }
			if($source)
            {
                $where  .= " and source = '$source'";
            }
			if($state)
            {
				$where  .= " and state = '$state'";
            }
			if($type)
            {
                $where  .= " and type = '$type'";
            }
			if($orderinfo)
            {
                $where  .= " and orderinfo = '$orderinfo'";
            }
			if($user)
            {
                $where  .= " and user = '$user'";
            }
			if($print)
            {
                $where  .= " and print = '$print'";
            }
			if($library)
            {
                $where  .= " and library = '$library'";
            }
			/*  匹配ID加入  */
			$tc = array();
			$typeclass = $this->typeclass->find_all();
			foreach ($typeclass as $v) 
			{
				$tc[$v['id']] = $v['title'];
			}
            //取得信息列表
            $info_list = $this->fullorder->find_all($where.$wid,'id,shop,number,orderinfo,client,country,province,city,zipcode,address,phone,waybill,shipremarks,zzl,bx,qm,js,dtime,printtime,librarytime,retreattime');
			 //格式化数据
			 $i = 1;
            foreach ($info_list as $key=>$value) 
		    {
				$ud = $this->fullorder->read($value['id']);
				$shop = $this->shop->read($value['shop']);
				$info_list[$key]['shop'] = $shop['shopname'];
				$info_list[$key]['id'] = $i;
				$country = $this->country->read($value['country']);
				$info_list[$key]['country'] = $country['ename'];
				$info_list[$key]['qm'] = ($value['qm']==1)?'需要签名':'不签名';
				$info_list[$key]['js'] = ($value['js']==1)?'优先服务':'普通';
				$fpdata = array();
				if(stripos($ud['fpdata'],';') !== false)
				{
					$info_list[$key]['dtime'] = date('Y-m-d H:i:s',$value['dtime']-12*3600);
					$info_list[$key]['printtime'] = ($value['printtime']!=0)?date('Y-m-d H:i:s',$value['printtime']-12*3600):'';
					$info_list[$key]['librarytime'] = ($value['librarytime']!=0)?date('Y-m-d H:i:s',$value['librarytime']-12*3600):'';
					$info_list[$key]['retreattime'] = ($value['retreattime']!=0)?date('Y-m-d H:i:s',$value['retreattime']-12*3600):'';
		   		    $fpdata = explode(';',rtrim($ud['fpdata'],';'));
		            foreach ($fpdata as $ke=>$va)
		            {
			            $v = explode('|',rtrim($va,'|'));
						$one = explode('-',rtrim($v[0],'-'));
						if($one['2'] == 163 || $one['2'] == 164 || $one['2'] == 165 || $one['2'] == 166)
						{
						    $one['3'] = isset($tc[$one['3']])?$tc[$one['3']]:'无';
						    $one['4'] = isset($tc[$one['4']])?$tc[$one['4']]:'无';
							$v[1] = str_replace(array('Hair Weaving','Closure','Wigs','Clip-in Full Head',$one['3'],$one['4']),array('','','','','',''),$v[1]);
							$v[1] =  preg_replace('/(\d+)inch/','',$v[1]);
						    $v[1] = ltrim($v[1],' ');
					        $fpdata[$ke] = array($v[5],$one['3'],$one['4'],$v[1],$v[2]);//内容，尺寸，等级，颜色,数量
						}
						else
						{
							$one['2'] = isset($tc[$one['2']])?$tc[$one['2']]:'无';
						    $one['3'] = isset($tc[$one['3']])?$tc[$one['3']]:'无';
							$v[1] = str_replace(array('Hair Weaving','Closure','Wigs','Clip-in Full Head',$one['2'],$one['3']),array('','','','','',''),$v[1]);
								$v[1] =  preg_replace('/(\d+)inch/','',$v[1]);
						    $v[1] = ltrim($v[1],' ');
							$fpdata[$ke] = array($v[5],$one['2'],$one['3'],$v[1],$v[2]);//内容，尺寸，等级，颜色,数量 线下单没有真人发类型
						}
                    }
				}
				$info_list[$key]['fpdata'] = $fpdata;
				$i++;
            }
            $title = "独立站订单信息"; 
            $titlename = "<table border=1>
            <tr><th colspan='19' align='left'><h3>".$title."<h3></th></tr>
            <tr>
            <td>NO.</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>签名</td>
			<td>快递服务</td>
			<td>订单时间(美国时间)</td>
			<td>打印时间(美国时间)</td>
			<td>出库时间(美国时间)</td>
			<td>退库时间(美国时间)</td>
			<td>
            <table border=1>
            <tr><td colspan='5' align='center'>订单产品信息</td></tr>
            <tr>
			<td>尺寸</td>
			<td>等级</td>
			<td>颜色</td>
			<td>花型</td>
			<td>数量</td>
            </tr>
            </table>
            </td>
			<td>总条数</td>
            </table>"; 
            $filename = $title.".xls"; 
			$tail = "<tr><td></td></tr>\n"; 
            $this->excel->get_fz($info_list,$titlename,$filename,$tail);
	    }
	}
	
	public function _black()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['bd']))  
		{
			$bd = $this->input->post('bd',true);
			$rows = $this->fullorder_smt->read($bd);
			$post['shop'] = $rows['shop'];
			$post['source'] = 1;
			$post['name'] = $rows['client'];
			$post['email'] = $rows['email'];
			$post['phone'] = $rows['phone'];
			$post['country'] = $rows['country'];
			$post['money'] = $rows['shouldmoney'];
			$post['num'] = 1;
			$post['time'] = $rows['dtime'];
			$post['province'] = $rows['province'];
			$post['city'] = $rows['city'];
			$post['street'] = $rows['street'];
			$post['address'] = $rows['address'];
			$post['address2'] = $rows['address2'];
			$post['zipcode'] = $rows['zipcode'];
			$post['type'] = 2;
			if($this->customer->insert($post))
        	{
				$this->fullorder_smt->save(array('black'=>1),$bd);
         		echo json_encode(array('msg'=>'操作成功','success'=>true));exit;
       	 	}
       		else
        	{
           	    echo json_encode(array('msg'=>'操作失败，请重试','success'=>false));exit;
        	}
		}
	}
	public function _ryf()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['bd']))  
		{
			$bd = $this->input->post('bd',true);
			$d = $this->fullorder_smt->read($bd);
			if($d['state'] == 207 || $d['state'] == 207)//订单状态为等待发货或等待部分发货才可更改为允许发货
			{
			    if($d['print'] < 3)//打印状态为未打印
			    {
				    $print = 1;//未打印
				    $libraryconfirm = 1;//不允许出库
				    $a = "订单未打印，";
			    }
			    else//已打印订单
			    {
				    $libraryconfirm = 2;//允许出库
				    $a = "";
			    }
				if($this->fullorder_smt->save(array('librarynot'=>$a,'libraryconfirm'=>$libraryconfirm,'print'=>$print),$bd))
        	    {
         		    echo json_encode(array('msg'=>'操作成功','success'=>true));exit;
       	 	    }
       		    else
        	    {
           	       echo json_encode(array('msg'=>'操作失败，请重试','success'=>false));exit;
        	    }
			}
			if($this->fullorder_smt->save(array('librarynot'=>$a,'libraryconfirm'=>$libraryconfirm,'print'=>$print),$bd))
        	{
         		echo json_encode(array('msg'=>'操作失败！订单未非发货状态','success'=>false));exit;
       	 	}
       		else
        	{
           	   echo json_encode(array('msg'=>'操作失败，请重试','success'=>false));exit;
        	}
		}
	}
	public function _fsstate()
	{
		$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;
            }
            foreach ($id_arr as $v) 
		    {
				$data = $this->fullorder_smt->read($v);
				$warehouse = $this->warehouse->read($data['type']);
				$fs = $this->notice->get_ordertatus($data['state']);
				if($fs)
				{
					$ck = $this->_email($fs['content'],$data,$warehouse['company']);
					if($ck == 1)
					{
						$this->fullorder_smt->save(array('fscontent'=>date('Y-m-d H:i:s',time()).'已发送:'.$fs['title'].' - '),$v);
					}
				}
            }
			echo json_encode(array('msg'=>'发送完成！','success'=>true));exit;
		}
	}
	public function _power()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['id']))  
		{
		    $id = $this->input->post('id',true);
			$fullorder_smt = $this->fullorder_smt->read($id);
			if($this->fullorder_smt->save(array('library'=>1,'librarytime'=>0,'libraryconfirm'=>2,'print'=>1,'printtime'=>0,'printnumber'=>0,'retreattime'=>0,'librarynot'=>'订单未打印，未审核或未通过','review'=>1,'state'=>207,'waybill'=>'','oldwaybill'=>'-'.date('Ymd',$fullorder_smt['printtime']).'/'.$fullorder_smt['waybill']),$id))
        	{
         		echo json_encode(array('msg'=>'重置成功','success'=>true));exit;
       	 	}
       		else
        	{
           	    echo json_encode(array('msg'=>'重置失败，请重试','success'=>false));exit;
        	}
		}
	}
	public function _expresstype()
	{
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['id']))  
		{
            $id = $this->input->post('id',true);
            $data =  $this->express->read($id);
			echo json_encode(array('msg'=>$data['type'],'success'=>true));exit;
		}
	}
	public function _email($content,$data,$shopname)
	{
		$express = $this->express->read($data['express']);
		$t= array('$userName','$orderid','$trackingNumber','$expressCompany','$contactPerson','$mobileNo','$zip','$recipientAddress');//需要被替换的内容
		$h= array($data['client'],$data['orderinfo'],$data['waybill'],$express['servicename'],$data['name'],$data['phone'],$data['zipcode'],$data['address']);//替换的内容
		$content = str_replace($t,$h,$content);
		$this->load->library('email');		
		$config['protocol'] = 'smtp';
		$config['smtp_host'] = 'smtpdm-ap-southeast-1.aliyun.com';
		$config['smtp_port'] = 465; 
		$config['smtp_user'] = 'service@email.supernovahair.com';
		$config['smtp_pass'] = 'LONGyihair374';
		$config['smtp_crypto'] = 'ssl';
		$config['crlf'] = "\r\n"; 
		$config['newline'] = "\r\n";
		$this->email->initialize($config);
		$this->email->from('service@email.supernovahair.com',$shopname);
		$this->email->to($data['email']);//收件
		$this->email->subject('The product you purchased has a new progress');//标题
		$this->email->message($content);//内容
		if ( ! $this->email->send())
        {
			return 2;
        }
		else
		{
			return 1;
		}
	}
	public function _error()
	{
		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";
			}
		}
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['page']))
		{
		    $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
			$orderinfo = $this->input->post('orderinfo',true);
			$waybill = $this->input->post('waybill',true);
			$number = $this->input->post('number',true);
			$timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$where = "print = 1 and failed !='' and mergeid = 0 and waybill = '' and (".rtrim($fgshop,'or').")";
			if($orderinfo)
            {
                $where  .= " and orderinfo = '$orderinfo'";
            }
			if($waybill)
            {
                $where  .= " and waybill = '$waybill'";
            }
			if($number)
            {
                $where  .= " and number = '$number'";
            }
			if($timetk && $timetj)
            {
				$timetj = $timetj+24*3600;
                $where  .= " and dtime > '$timetk' and dtime < '$timetj'";
            }
            //数据排序
            $order_str = "dtime desc";
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
            $info_list_smt = $this->fullorder_smt->find_all($where,'id,shop,type,orderinfo,number,express,failed,operation',$order_str,$start,$perpage);
			 //格式化数据
            foreach ($info_list_smt as $key=>$value) 
		    {
				$ud = $this->fullorder_smt->read($value['id']);
				$shop = $this->shop->read($value['shop']);
				$info_list_smt[$key]['shop'] = $shop['shopname'];
				$info_list_smt[$key]['orderinfo'] = "<h9 class='window' data-h='/fullorder_smt/edit/".$value['id']."' data-t='订单号：".$value['orderinfo']."'>".$value['orderinfo']."<p>";
				$warehouse = $this->warehouse->read($value['type']);
				$warehousetitle = $warehouse['title'];
				if($value['type'] != 1){$warehousetitle = "<font style='color:#f64b4b'>".$warehouse['title']."</font>";}
				$info_list_smt[$key]['type'] = $warehousetitle;
				if($value['express'] != 0)
				{
				    $express = $this->express->read($value['express']);
					$expressservicename = $express['servicename'];
				if($value['express'] != 1){$expressservicename = "<font style='color:#f64b4b'>".$express['servicename']."</font>";}
				    $info_list_smt[$key]['express'] = $expressservicename;
				}
				else
				{
					$info_list_smt[$key]['express'] = "无";
				}
				$x = "";
				if($ud['review'] >4 && $ud['print'] == 1)
				{
				    $x = "<p class='ckn'><b class='fojzof' data-type='8' data-id='".$value['id']."'>允许打印</b></p>";
				}
				$info_list_smt[$key]['operation'] = $x;
            }
		    $total = $this->fullorder_smt->find_count($where);
		    $pagenum = ceil($total/$perpage);
		    $over = $total-($start+$perpage);
		    $rows = array('total'=>$total,'over'=>$over,'pagenum'=>$pagenum,'rows'=>($info_list_smt));
		    echo json_encode($rows);exit;
		}
		$wlshop = $this->shop->find_all('1=1 and '.rtrim($sid,'or'));
		$this->data['wlshop'] = $wlshop;
		$this->data['express'] = $this->express->find_all();
		$fullorderexcel = $this->fullorderexcel->find_all('type=1','*','idorder desc');//导出模板
		$this->data['fullorderexcel'] = $fullorderexcel;
		$this->_Template('fullorder_smt_error',$this->data);
	}
	
	public function _dlzerror()
	{
		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";
			}
		}
		$post = $this->input->post(NULL, TRUE);
		if(isset($post['page']))
		{
		    $page = $this->input->post('page',true);
		    $perpage = $this->input->post('perpage',true);
			$orderinfo = $this->input->post('orderinfo',true);
			$waybill = $this->input->post('waybill',true);
			$number = $this->input->post('number',true);
			$timetk = $this->input->post('timetk',true);
			$timetj = $this->input->post('timetj',true);
			$timetk = strtotime($timetk);
			$timetj = strtotime($timetj);
			$where = "print = 1 and failed !='' and mergeid = 0 and waybill = '' and (".rtrim($fgshop,'or').")";
			if($orderinfo)
            {
                $where  .= " and orderinfo = '$orderinfo'";
            }
			if($waybill)
            {
                $where  .= " and waybill = '$waybill'";
            }
			if($number)
            {
                $where  .= " and number = '$number'";
            }
			if($timetk && $timetj)
            {
				$timetj = $timetj+24*3600;
                $where  .= " and dtime > '$timetk' and dtime < '$timetj'";
            }
            //数据排序
            $order_str = "dtime desc";
            if(empty($page))
		    {
                $start = 0;
		    	$perpage = 1;
            }
		    else
		    {
                $start = ($page - 1)*$perpage;
            }
			$info_list = $this->fullorder->find_all($where.' and type = 5','id,shop,type,orderinfo,number,express,failed,operation',$order_str,$start,$perpage);
			 //格式化数据
            foreach ($info_list as $key=>$value) 
		    {
				$ud = $this->fullorder->read($value['id']);
				$shop = $this->shop->read($value['shop']);
				$info_list[$key]['shop'] = $shop['shopname'];
				$info_list[$key]['orderinfo'] = "<h9 class='window' data-h='/fullorder_smt/edit/".$value['id']."' data-t='订单号：".$value['orderinfo']."'>".$value['orderinfo']."<p>";
				$warehouse = $this->warehouse->read($value['type']);
				$warehousetitle = $warehouse['title'];
				if($value['type'] != 1){$warehousetitle = "<font style='color:#f64b4b'>".$warehouse['title']."</font>";}
				$info_list[$key]['type'] = $warehousetitle;
				if($value['express'] != 0)
				{
				    $express = $this->express->read($value['express']);
					$expressservicename = $express['servicename'];
				if($value['express'] != 1){$expressservicename = "<font style='color:#f64b4b'>".$express['servicename']."</font>";}
				    $info_list[$key]['express'] = $expressservicename;
				}
				else
				{
					$info_list[$key]['express'] = "无";
				}
				$x = "";
				if($ud['review'] >4 && $ud['print'] == 1)
				{
				    $x = "<p class='ckn'><b class='fojzof' data-type='8' data-id='".$value['id']."'>允许打印</b></p>";
				}
				$info_list[$key]['operation'] = $x;
            }
		    $total = $this->fullorder->find_count($where.' and type = 5');
		    $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['express'] = $this->express->find_all();
		$fullorderexcel = $this->fullorderexcel->find_all('type=1','*','idorder desc');//导出模板
		$this->data['fullorderexcel'] = $fullorderexcel;
		$this->_Template('fullorder_smt_errordlz',$this->data);
	}
}