xml可以分页案例

<?php

namespace Admin\Controller;

use Common\Controller\AdminController;

use Lib\Utils;

class BusinessController extends AdminController

{

    public function __construct()

    {

        parent::__construct();

        C('TMPL_L_DELIM', '{chenzhi:');

        C('TMPL_R_DELIM', '}');

    }

    public function index()

    {

        $TraceModel = D('TraceSelect');

        $businessService = \Lib\Utils::getService('Business');

        $businessModel = $businessService->model;

        $where = array();

        $joinOneStr = 'posp_business_info ON posp_business.id = posp_business_info.business_id';

        $joinTwoStr = 'posp_agent ON posp_business.agent_id = posp_agent.id';

        $joinThreeStr = 'posp_agent_info ON posp_business.agent_id = posp_agent_info.agent_id';

        $agent_user = session('admin_user');

        if ($agent_user['role_id'] == '27') {

            $agentIdStr = '';

            $agentList = D('Agent')->field("id")->where(array("role_user_id" => $agent_user['agent_id'], "pid" => 7))->select();

            if ($agentList) {

                foreach ($agentList as $agentListKey => $agentListValue) {

                    $agentIdStr .= $agentListValue['id'] . ",";

                    $agentLevelList = D('AgentLevel')->field("child_agent_id")->where(array("agent_id" => $agentListValue['id']))->select();

                    if ($agentLevelList) {

                        foreach ($agentLevelList as $agentLevelListKey => $agentLevelListValue) {

                            $agentIdStr .= $agentLevelListValue['child_agent_id'] . ",";

                        }

                    }

                }

                if ($agentIdStr) {

                    $agentIdStrArr = explode(",", $agentIdStr);

                    foreach ($agentIdStrArr as $agentIdStrArrKey => $agentIdStrArrValue) {

                        if ($agentIdStrArrValue) {

                            $agentIdsArr[] = $agentIdStrArrValue;

                        }

                    }

                }

            }

            $where['posp_agent.id'] = array('in', implode(',', $agentIdsArr));

        }

        if (I('serial_no')) {

            $where['posp_business.serial_no'] = I('serial_no');

        }

        if (I('agent_serial_no')) {

            $agentService = \Lib\Utils::getService('Agent');

            $agentInfo = $agentService->getAgentInfoByNo(I('agent_serial_no'));

            $agentIdArr[] = $agentInfo['id'];

            $agentLevelModel = D('AgentLevel');

            $agentLevelList = $agentLevelModel->where(array('agent_id' => $agentInfo['id']))->select();

            foreach ($agentLevelList as $agentLevel) {

                $agentIdArr[] = $agentLevel['child_agent_id'];

            }

            $where['posp_business.agent_id'] = array('in', implode(',', $agentIdArr));

        }

        if (I('company_name')) {

            $company_name = urldecode(I('company_name'));

            $where['posp_business_info.company_name'] = array('like', '%' . $company_name . '%');

        }

        if (I('status') != '') {

            $where['posp_business.status'] = I('status');

        }

        if (I('industry_id')) {

            $where['posp_business_info.industry_id'] = I('industry_id');

        }

        if (I('rate_set_id')) {

            $where['posp_business.rate_set_id'] = I('rate_set_id');

        }

        if (I('address')) {

            $addressArr = I('address');

            if (count($addressArr) < 2) {

                $this->errorPage('地址信息未填写完善，请确定后再提交.');

            }

            //$province_id ＝ $addressArr[0];

            //$city_id ＝ $addressArr[1];

            //$town_id ＝ $addressArr[2]?$addressArr[2]:0;

            if (($addressArr[0] != 0) && ($addressArr[1] == 0) && ($addressArr[2] == 0)) {

                $where['posp_business.province_id'] = $addressArr[0];

            } elseif (($addressArr[0] != 0) && ($addressArr[1] != 0) && ($addressArr[2] == 0)) {

                $where['posp_business.province_id'] = $addressArr[0];

                $where['posp_business.city_id'] = $addressArr[1];

            } elseif (($addressArr[0] != 0) && ($addressArr[1] != 0) && ($addressArr[2] != 0)) {

                $where['posp_business.province_id'] = $addressArr[0];

                $where['posp_business.city_id'] = $addressArr[1];

                $where['posp_business.town_id'] = $addressArr[2];

            }

        }

        //导出EXCEL

        if (I('exportbusiness') == '个人') {

            $this->exportExcelBusinessWFT($where);

        }

        if(I('exportbusiness') == '商户'){

            $this->exportExcelBusinessWFTPersonal($where);

        }

        $count = $businessModel->join($joinOneStr)->join($joinTwoStr)->where($where)->count();

        $Page = new \Think\PageBoot($count, 10);                   // 实例化分页类 传入总记录数和每页显示的记录数(25)

        $show = $Page->show();                                // 分页显示输出

        // 进行分页数据查询 注意limit方法的参数要使用Page类的属性

        $businessList = $businessModel->field('posp_business.*,posp_business_info.*,posp_agent.username as agent_name,posp_agent_info.company_name as agent_company_name,posp_agent_info.serial_no as agent_serial_no')->join($joinOneStr, 'left')->join($joinTwoStr, 'left')->join($joinThreeStr, 'left')->where($where)->order('posp_business.id desc')->limit($Page->firstRow . ',' . $Page->listRows)->select();

        $businessStatus = $businessService->businessStatus;

        $addressService = \Lib\Utils::getService('Address');

        //$addressList = $addressService->getAllAddressList();

        $addressModel = D('Address');

        $proAddressList = $addressModel->getChildAddressByIdCache(0);

        $industryModel = D('Industry');

        $industryList = $industryModel->where(array("status" => 1))->order("sort DESC")->getField('id,name');

        $rate_setModel = D('RateSet');

        $rate_setList = $rate_setModel->order("id DESC")->getField('id,rate_name');

        //$fwcShopModel = new \Common\Model\Fwc\CompanyModel(); //查询同一平台中的开店信息

        $TraceModel = D('TraceSelect');

        foreach ($businessList as $businesskey => $businessvalue) {

            $alipayWhere['business_id'] = $businessvalue['business_id'];

            $alipayWhere['dynamic_type'] = array('in', '0,2,4');

            $isAlipayTrace = $TraceModel->field('trace_id')->where($alipayWhere)->find();

            $businessList[$businesskey]['showAlipayTrace'] = "0";

            if ($isAlipayTrace['trace_id']) {

                $businessList[$businesskey]['showAlipayTrace'] = "1";

            }

            $weixinWhere['business_id'] = $businessvalue['business_id'];

            $weixinWhere['dynamic_type'] = 1;

            $isWeixinTrace = $TraceModel->field('trace_id')->where($weixinWhere)->find();

            $businessList[$businesskey]['showWeixinTrace'] = "0";

            if ($isWeixinTrace['trace_id']) {

                $businessList[$businesskey]['showWeixinTrace'] = "1";

            }

            //商户昨日支付宝交易额

            //S(date("Y-m-d")."yesterday_alipay_".$businessvalue['business_id'],null) ;

            if (!S(date("Y-m-d") . "yesterday_alipay_" . $businessvalue['business_id'])) {

                $yesterdayAlipayWhere['business_id'] = $businessvalue['business_id'];

                $yesterdayAlipayWhere['trans_status'] = 1;

                $yesterdayAlipayWhere['dynamic_type'] = array('in', '0,2,4');

                $yesterdayAlipayWhere['trans_begin'] = array(array('egt', date("Y-m-d 00:00:00", strtotime("-1 days"))), array('elt', date("Y-m-d 23:59:59", strtotime("-1 days"))), 'and');

                $yesterdayAlipayTrace = $TraceModel->field("IFNULL(SUM(total_fee),0.00) as total_fee,IFNULL(COUNT(*),0) as total_count")->where($yesterdayAlipayWhere)->select();

                S(date("Y-m-d") . "yesterday_alipay_" . $businessvalue['business_id'], $yesterdayAlipayTrace[0], 86400);

            }

            $yesterday_alipay = S(date("Y-m-d") . "yesterday_alipay_" . $businessvalue['business_id']);

            $businessList[$businesskey]['yesterday_alipay'] = $yesterday_alipay['total_fee'];

            $businessList[$businesskey]['yesterday_alipay_count'] = $yesterday_alipay['total_count'];

            //商户昨日微信交易额

            //S(date("Y-m-d")."yesterday_weixin_".$businessvalue['business_id'],null) ;

            if (!S(date("Y-m-d") . "yesterday_weixin_" . $businessvalue['business_id'])) {

                $yesterdayWeixinWhere['business_id'] = $businessvalue['business_id'];

                $yesterdayWeixinWhere['trans_status'] = 1;

                $yesterdayWeixinWhere['dynamic_type'] = 1;

                $yesterdayWeixinWhere['trans_begin'] = array(array('egt', date("Y-m-d 00:00:00", strtotime("-1 days"))), array('elt', date("Y-m-d 23:59:59", strtotime("-1 days"))), 'and');

                $yesterdayWeixinTrace = $TraceModel->field("IFNULL(SUM(total_fee),0.00) as total_fee,IFNULL(COUNT(*),0) as total_count")->where($yesterdayWeixinWhere)->select();

                S(date("Y-m-d") . "yesterday_weixin_" . $businessvalue['business_id'], $yesterdayWeixinTrace[0], 86400);

            }

            $yesterday_weixin = S(date("Y-m-d") . "yesterday_weixin_" . $businessvalue['business_id']);

            $businessList[$businesskey]['yesterday_weixin'] = $yesterday_weixin['total_fee'];

            $businessList[$businesskey]['yesterday_weixin_count'] = $yesterday_weixin['total_count'];

            //商户昨日支付宝退款额

            //S(date("Y-m-d")."yesterday_refund_alipay_".$businessvalue['business_id'],null) ;

            if (!S(date("Y-m-d") . "yesterday_refund_alipay_" . $businessvalue['business_id'])) {

                $yesterdayRefundAlipayWhere['business_id'] = $businessvalue['business_id'];

                $yesterdayRefundAlipayWhere['trans_status'] = 3;

                $yesterdayRefundAlipayWhere['dynamic_type'] = array('in', '0,2,4');

                $yesterdayRefundAlipayWhere['trans_begin'] = array(array('egt', date("Y-m-d 00:00:00", strtotime("-1 days"))), array('elt', date("Y-m-d 23:59:59", strtotime("-1 days"))), 'and');

                $yesterdayRefundAlipayTrace = $TraceModel->field("IFNULL(SUM(total_fee),0.00) as total_fee,IFNULL(COUNT(*),0) as total_count")->where($yesterdayRefundAlipayWhere)->select();

                S(date("Y-m-d") . "yesterday_refund_alipay_" . $businessvalue['business_id'], $yesterdayRefundAlipayTrace[0], 86400);

            }

            $yesterday_refund_alipay = S(date("Y-m-d") . "yesterday_refund_alipay_" . $businessvalue['business_id']);

            $businessList[$businesskey]['yesterday_refund_alipay'] = $yesterday_refund_alipay['total_fee'];

            $businessList[$businesskey]['yesterday_refund_alipay_count'] = $yesterday_refund_alipay['total_count'];

            //商户昨日微信退款额

            //S(date("Y-m-d")."yesterday_refund_weixin_".$businessvalue['business_id'],null) ;

            if (!S(date("Y-m-d") . "yesterday_refund_weixin_" . $businessvalue['business_id'])) {

                $yesterdayRefundWeixinWhere['business_id'] = $businessvalue['business_id'];

                $yesterdayRefundWeixinWhere['trans_status'] = 3;

                $yesterdayRefundWeixinWhere['dynamic_type'] = 1;

                $yesterdayRefundWeixinWhere['trans_begin'] = array(array('egt', date("Y-m-d 00:00:00", strtotime("-1 days"))), array('elt', date("Y-m-d 23:59:59", strtotime("-1 days"))), 'and');

                $yesterdayRefundWeixinTrace = $TraceModel->field("IFNULL(SUM(total_fee),0.00) as total_fee,IFNULL(COUNT(*),0) as total_count")->where($yesterdayRefundWeixinWhere)->select();

                S(date("Y-m-d") . "yesterday_refund_weixin_" . $businessvalue['business_id'], $yesterdayRefundWeixinTrace[0], 86400);

            }

            $yesterday_refund_weixin = S(date("Y-m-d") . "yesterday_refund_weixin_" . $businessvalue['business_id']);

            $businessList[$businesskey]['yesterday_refund_weixin'] = $yesterday_refund_weixin['total_fee'];

            $businessList[$businesskey]['yesterday_refund_weixin_count'] = $yesterday_refund_weixin['total_count'];

            //商户本周支付宝交易额

            //S(date("Y-m-d")."week_alipay_".$businessvalue['business_id'],null) ;

            if (!S(date("Y-m-d") . "week_alipay_" . $businessvalue['business_id'])) {

                $weekAlipayWhere['business_id'] = $businessvalue['business_id'];

                $weekAlipayWhere['trans_status'] = 1;

                $weekAlipayWhere['dynamic_type'] = array('in', '0,2,4');

                $weekAlipayWhere['trans_begin'] = array("egt", date("Y-m-d H:i:s", strtotime("-1 week")));

                $weekAlipayTrace = $TraceModel->field("IFNULL(SUM(total_fee),0.00) as total_fee,IFNULL(COUNT(*),0) as total_count")->where($weekAlipayWhere)->select();

                S(date("Y-m-d") . "week_alipay_" . $businessvalue['business_id'], $weekAlipayTrace[0], 86400);

            }

            $week_alipay = S(date("Y-m-d") . "week_alipay_" . $businessvalue['business_id']);

            $businessList[$businesskey]['week_alipay'] = $week_alipay['total_fee'];

            $businessList[$businesskey]['week_alipay_count'] = $week_alipay['total_count'];

            //商户本周微信交易额

            //S(date("Y-m-d")."week_weixin_".$businessvalue['business_id'],null) ;

            if (!S(date("Y-m-d") . "week_weixin_" . $businessvalue['business_id'])) {

                $weekWeixinWhere['business_id'] = $businessvalue['business_id'];

                $weekWeixinWhere['trans_status'] = 1;

                $weekWeixinWhere['dynamic_type'] = 1;

                $weekWeixinWhere['trans_begin'] = array("egt", date("Y-m-d H:i:s", strtotime("-1 week")));

                $weekWeixinTrace = $TraceModel->field("IFNULL(SUM(total_fee),0.00) as total_fee,IFNULL(COUNT(*),0) as total_count")->where($weekWeixinWhere)->select();

                S(date("Y-m-d") . "week_weixin_" . $businessvalue['business_id'], $weekWeixinTrace[0], 86400);

            }

            $week_weixin = S(date("Y-m-d") . "week_weixin_" . $businessvalue['business_id']);

            $businessList[$businesskey]['week_weixin'] = $week_weixin['total_fee'];

            $businessList[$businesskey]['week_weixin_count'] = $week_weixin['total_count'];

            //商户本月支付宝交易额

            //S(date("Y-m-d")."month_alipay_".$businessvalue['business_id'],null) ;

            if (!S(date("Y-m-d") . "month_alipay_" . $businessvalue['business_id'])) {

                $monthAlipayWhere['business_id'] = $businessvalue['business_id'];

                $monthAlipayWhere['trans_status'] = 1;

                $monthAlipayWhere['dynamic_type'] = array('in', '0,2,4');

                $monthAlipayWhere['trans_begin'] = array("egt", date("Y-m-d H:i:s", strtotime("-1 months")));

                $monthAlipayTrace = $TraceModel->field("IFNULL(SUM(total_fee),0.00) as total_fee,IFNULL(COUNT(*),0) as total_count")->where($monthAlipayWhere)->select();

                S(date("Y-m-d") . "month_alipay_" . $businessvalue['business_id'], $monthAlipayTrace[0], 86400);

            }

            $month_alipay = S(date("Y-m-d") . "month_alipay_" . $businessvalue['business_id']);

            $businessList[$businesskey]['month_alipay'] = $month_alipay['total_fee'];

            $businessList[$businesskey]['month_alipay_count'] = $month_alipay['total_count'];

            //商户本月微信交易额

            //S(date("Y-m-d")."month_weixin_".$businessvalue['business_id'],null) ;

            if (!S(date("Y-m-d") . "month_weixin_" . $businessvalue['business_id'])) {

                $monthWeixinWhere['business_id'] = $businessvalue['business_id'];

                $monthWeixinWhere['trans_status'] = 1;

                $monthWeixinWhere['dynamic_type'] = 1;

                $monthWeixinWhere['trans_begin'] = array("egt", date("Y-m-d H:i:s", strtotime("-1 months")));

                $monthWeixinTrace = $TraceModel->field("IFNULL(SUM(total_fee),0.00) as total_fee,IFNULL(COUNT(*),0) as total_count")->where($monthWeixinWhere)->select();

                S(date("Y-m-d") . "month_weixin_" . $businessvalue['business_id'], $monthWeixinTrace[0], 86400);

            }

            $month_weixin = S(date("Y-m-d") . "month_weixin_" . $businessvalue['business_id']);

            $businessList[$businesskey]['month_weixin'] = $month_weixin['total_fee'];

            $businessList[$businesskey]['month_weixin_count'] = $month_weixin['total_count'];

            //POSP_CASH_BUSINESS

            $businessList[$businesskey]['amount_fee'] = '0.00';

            $businessList[$businesskey]['amount_count'] = '0';

            $businessList[$businesskey]['rates_fee'] = '0.00';

            $businessList[$businesskey]['refund_fee'] = '0.00';

            $businessList[$businesskey]['refund_count'] = '0';

            $businessList[$businesskey]['real_fee'] = '0.00';

            $businessList[$businesskey]['cashget_fee'] = '0.00';

            $businessList[$businesskey]['cashget_count'] = '0';

            $businessList[$businesskey]['amount_wx'] = '0.00';

            $businessList[$businesskey]['rates_wx'] = '0.00';

            $businessList[$businesskey]['refund_wx'] = '0.00';

            $businessList[$businesskey]['real_wx'] = '0.00';

            $businessList[$businesskey]['amount_zfb'] = '0.00';

            $businessList[$businesskey]['rates_zfb'] = '0.00';

            $businessList[$businesskey]['real_zfb'] = '0.00';

            $businessList[$businesskey]['refund_zfb'] = '0.00';

            $cashBusiness = "";

            $cashBusiness = D('CashBusiness')->where(array("business_id" => $businessvalue['business_id']))->find();

            if ($cashBusiness['amount_fee']) {

                $businessList[$businesskey]['amount_fee'] = $cashBusiness['amount_fee'];

            }

            if ($cashBusiness['amount_count']) {

                $businessList[$businesskey]['amount_count'] = $cashBusiness['amount_count'];

            }

            if ($cashBusiness['rates_fee']) {

                $businessList[$businesskey]['rates_fee'] = $cashBusiness['rates_fee'];

            }

            if ($cashBusiness['refund_fee']) {

                $businessList[$businesskey]['refund_fee'] = $cashBusiness['refund_fee'];

            }

            if ($cashBusiness['refund_count']) {

                $businessList[$businesskey]['refund_count'] = $cashBusiness['refund_count'];

            }

            if ($cashBusiness['real_fee']) {

                $businessList[$businesskey]['real_fee'] = $cashBusiness['real_fee'];

            }

            if ($cashBusiness['cashget_fee']) {

                $businessList[$businesskey]['cashget_fee'] = $cashBusiness['cashget_fee'];

            }

            if ($cashBusiness['cashget_count']) {

                $businessList[$businesskey]['cashget_count'] = $cashBusiness['cashget_count'];

            }

            if ($cashBusiness['amount_wx']) {

                $businessList[$businesskey]['amount_wx'] = $cashBusiness['amount_wx'];

            }

            if ($cashBusiness['rates_wx']) {

                $businessList[$businesskey]['rates_wx'] = $cashBusiness['rates_wx'];

            }

            if ($cashBusiness['refund_wx']) {

                $businessList[$businesskey]['refund_wx'] = $cashBusiness['refund_wx'];

            }

            if ($cashBusiness['real_wx']) {

                $businessList[$businesskey]['real_wx'] = $cashBusiness['real_wx'];

            }

            if ($cashBusiness['amount_zfb']) {

                $businessList[$businesskey]['amount_zfb'] = $cashBusiness['amount_zfb'];

            }

            if ($cashBusiness['rates_zfb']) {

                $businessList[$businesskey]['rates_zfb'] = $cashBusiness['rates_zfb'];

            }

            if ($cashBusiness['refund_zfb']) {

                $businessList[$businesskey]['refund_zfb'] = $cashBusiness['refund_zfb'];

            }

            if ($cashBusiness['real_zfb']) {

                $businessList[$businesskey]['real_zfb'] = $cashBusiness['real_zfb'];

            }

        }

        //print_r($businessList);exit;

        $data = array(

            'pageStr' => $show,

            'businessList' => $businessList,

            'businessStatus' => $businessStatus,

            'proAddressList' => $proAddressList,

            'addressList' => $addressList,

            'industryList' => $industryList,

            'company_name' => $company_name,

            'rate_setList' => $rate_setList

        );

        $this->display($data);

    }

    protected function exportExcelBusinessWFTPersonal($where){

        //模拟数据

        import("Org.Util.PHPExcel");

        /* @实例化 */

        $obpe = new \PHPExcel();

        /* @func 设置文档基本属性 */

        $obpe_pro = $obpe->getProperties();

        //设置当前sheet索引,用于后续的内容操作

        //在处理指定Sheet的时候，需要显示调用

        //缺省情况下,PHPExcel会自动创建第一个SHEET，其索引SheetIndex=0

        //设置 当前处于活动状态的SHEET 为PHPExcel自动创建的第一个SHEET

        $obpe->setactivesheetindex(0);

        //设置sheet1表头

        $head1 = array('商户全称', '商户简称(签购单显示名称)', '详细地址（含省、市）', '商户性质(下拉菜单)', '商户电话', '联系人姓名', '联系人手机号', '联系人邮箱', '营业执照编号', '税务证编号', '组织机构代码证编号', '法人姓名', '法人身份证号', '支付通道(下拉菜单)',

            '支付通道(下拉菜单)', '手续费率(%)','一级类目(下拉菜单)','二级类目(下拉菜单)','三级类目(仅支付宝)(下拉菜单)','结算账号开户名','结算账号','账号类型(下拉菜单)','收款行全称','收款行行号(非中信账号需填)');

        //设置sheet1宽度

        $obpe->getActiveSheet(0)->getColumnDimension('A')->setWidth(10);

        $obpe->getActiveSheet(0)->getColumnDimension('B')->setWidth(30);

        $obpe->getActiveSheet(0)->getColumnDimension('C')->setWidth(30);

        $obpe->getActiveSheet(0)->getColumnDimension('D')->setWidth(30);

        $obpe->getActiveSheet(0)->getColumnDimension('E')->setWidth(30);

        $obpe->getActiveSheet(0)->getColumnDimension('F')->setWidth(30);

        $obpe->getActiveSheet(0)->getColumnDimension('G')->setWidth(30);

        $obpe->getActiveSheet(0)->getColumnDimension('H')->setWidth(30);

        $obpe->getActiveSheet(0)->getColumnDimension('I')->setWidth(30);

        $obpe->getActiveSheet(0)->getColumnDimension('J')->setWidth(30);

        $obpe->getActiveSheet(0)->getColumnDimension('K')->setWidth(30);

        $obpe->getActiveSheet(0)->getColumnDimension('L')->setWidth(30);

        $obpe->getActiveSheet(0)->getColumnDimension('M')->setWidth(30);

        $obpe->getActiveSheet(0)->getColumnDimension('N')->setWidth(30);

        $obpe->getActiveSheet(0)->getColumnDimension('O')->setWidth(30);

        $obpe->getActiveSheet(0)->getColumnDimension('P')->setWidth(30);

        $obpe->getActiveSheet(0)->getColumnDimension('Q')->setWidth(30);

        $obpe->getActiveSheet(0)->getColumnDimension('R')->setWidth(30);

        $obpe->getActiveSheet(0)->getColumnDimension('S')->setWidth(30);

        $obpe->getActiveSheet(0)->getColumnDimension('T')->setWidth(30);

        $obpe->getActiveSheet(0)->getColumnDimension('U')->setWidth(30);

        $obpe->getActiveSheet(0)->getColumnDimension('V')->setWidth(30);

        $obpe->getActiveSheet(0)->getColumnDimension('W')->setWidth(30);

        $obpe->getActiveSheet(0)->getColumnDimension('X')->setWidth(30);

        //SHEET1内容

        $businessService = \Lib\Utils::getService('Business');

        $businessModel = $businessService->model;

        $where['excel_status'] = 0;

        $businessList1 = $businessModel->field('posp_business.id as id, 

                                       posp_business.username as username,

            posp_business_info.store_name as store_name,

            posp_business_info.industrid as industrid,

            posp_business.province_id as province,

            posp_business.city_id as city,

            posp_business_info.address as address,

            posp_bank_card.realname as realname,

            posp_business_info.phone as phone,

            posp_bank_card.email as email,

            posp_business_info.register_number as register_number,

            posp_bank_card.numberid as numberid,

            posp_bank_card.bank_id as bank_id,

            posp_bank_card.subbranch_id as subbranch_id,

            posp_bank_card.card_no as card_no')

            ->join('posp_business_info ON posp_business.id = posp_business_info.business_id')

            ->join('posp_bank_card ON posp_business.id = posp_bank_card.merchant_id')

            // ->where(array("posp_business.status"=>1,"posp_business.rate_set_id"=>1,"posp_business.excel_status"=>0))

            ->where($where)

            ->order('posp_business.id desc')

            ->select();

        $mulit_arr1 = "";

        foreach ($businessList1 as $businessListKey1 => $businessListValue1) {

            $channelModel = D('channelCategory')->where(array("merchant_id" => $businessListValue1['id']))->find();

            $id=$channelModel['id'];

            if($channelModel['wx_public']==1){

                $businessListValue1['pay_type'] = "公众账号支付";

                $businessListValue1['passageway'] = "微信支付";

                $businessListValue1['category1'] = $channelModel['wx_category1'];

                $businessListValue1['category2'] = $channelModel['wx_category2'];

                $businessListValue1['category3'] = $channelModel['wx_category3'];

                $businessListKey1 = $businessListKey1 + 1;

                $mulit_arr1[$id][$businessListKey1][0] = $businessListValue1['store_name'];//商户全称

                $mulit_arr1[$id][$businessListKey1][1] = $businessListValue1['store_name'];//'商户简称(签购单显示名称)'

                $province_name = D('Addresscode')->where(array("province_code" => $businessListValue1['province']))->find();

                $city_name = D('Addresscode')->where(array("province_code" => $businessListValue1['city']))->find();

                $mulit_arr1[$id][$businessListKey1][2] =$province_name['name'].$city_name['name'].$businessListValue1['address'];;//详细地址（含省、市）

                $mulit_arr1[$id][$businessListKey1][3] = "个体工商户";//'商户性质(下拉菜单)',   ################

                $mulit_arr1[$id][$businessListKey1][4] = "".$businessListValue1['phone']." ";//商户电话

                $mulit_arr1[$id][$businessListKey1][5] = $businessListValue1['realname'];//联系人姓名

                $mulit_arr1[$id][$businessListKey1][6] = "".$businessListValue1['phone']." ";//联系人手机号

                $mulit_arr1[$id][$businessListKey1][7] = $businessListValue1['email'];    //联系人邮箱

                $mulit_arr1[$id][$businessListKey1][8] = "".$businessListValue1['register_number']." ";//营业执照编号

                $mulit_arr1[$id][$businessListKey1][9] = "";//税务证编号

                $mulit_arr1[$id][$businessListKey1][10] ="";//组织机构代码证编号

                $mulit_arr1[$id][$businessListKey1][11] =$businessListValue1['realname'];//法人姓名

                $mulit_arr1[$id][$businessListKey1][12] = "".$businessListValue1['numberid']." ";//法人身份证号

                $mulit_arr1[$id][$businessListKey1][13] = $businessListValue1['passageway'];//支付通道(下拉菜单)',       ################

                $mulit_arr1[$id][$businessListKey1][14] = $businessListValue1['pay_type'];//支付方式(下拉菜单)',       ################

                $mulit_arr1[$id][$businessListKey1][15] = "3.8";    //手续费率(%)

                $mulit_arr1[$id][$businessListKey1][16] = $businessListValue1['category1'];//一级类目(下拉菜单)  ################

                $mulit_arr1[$id][$businessListKey1][17] = $businessListValue1['category2'];   //二级类目(下拉菜单)       ################

                $mulit_arr1[$id][$businessListKey1][18] = $businessListValue1['category3'];   //三级类目(仅支付宝)(下拉菜单) ################

                $mulit_arr1[$id][$businessListKey1][19] = $businessListValue1['realname'];   //结算账号开户名'

                $mulit_arr1[$id][$businessListKey1][20] = "".$businessListValue1['card_no']." ";   //结算账号

                $subbranch = D('BankInfo')->field('bank_no,bank_name')->where(array("id" => $businessListValue1['bank_id']))->find();

                $mulit_arr1[$id][$businessListKey1][21] = '个人账号';   //账号类型(下拉菜单)  ################

                $mulit_arr1[$id][$businessListKey1][22] = $subbranch['bank_name'];   //收款行全称

                $mulit_arr1[$id][$businessListKey1][23] = "".$subbranch['bank_no']." ";  //收款行行号(非中信账号需填)

            }

            if($channelModel['wx_cover']==1){

                $businessListValue1['pay_type'] = "被扫支付";

                $businessListValue1['passageway'] = "微信支付";

                $businessListValue1['category1'] = $channelModel['wx_category1'];

                $businessListValue1['category2'] = $channelModel['wx_category2'];