<?php

namespace Retail\Controller;

use Think\Controller;

//[1.4.53]
/*
 * 拒绝直接更新 2019-6-3版本
 */

class CashierController extends BaseController
{
//    public function index()
//    {
//        $userinfo = session("ls_userinfo");
//
//        $this->display();
//    }
    public function index()
    {
        $userinfo = session("ls_userinfo");
        $store_id = I('session.storeid');
        $jur = M('retail_store_jurisdiction')->where(array('storeid'=>$store_id))->field('data_export')->find();   //判断是否有导出权限
        $arr = array(
            'cashierInfoExport' => '/index.php/Retail/Cashier/cashierInfoExport',
            'addCashier' => '/index.php/Retail/Cashier/addCashier',
            'editadCashier' => '/index.php/Retail/Cashier/editadCashier',
            'model' => '/index.php/Retail/Cashier/model',
            'delCashier' => '/index.php/Retail/Cashier/delCashier',
            'shiftingdetailinfo' => '/index.php/Retail/Cashier/shiftingdetailinfo',
            'permiset' => '/index.php/Retail/Cashier/permiset',
        );
        $authArr = checkFunction($arr);
        $this->assign('authArr', $authArr);
        $this->assign('data_export', $jur['data_export']);
        $this->display();
    }

    public function lists()
    {
        $userinfo = session("ls_userinfo");
        $storeid = session("storeid");
        $keyword = I("post.keyword");
        if (!empty($keyword)) {
            if (is_numeric($keyword)) {
                $map['mobile'] = $keyword;
            } else {
                $map['name'] = array('like', "%" . $keyword . "%");
            }
        }
        $map['merchantid'] = $userinfo['merchantid'];
        $map['storeid'] = $storeid;
        $map['status'] = 1;

        $info = M("retail_cashier")->where($map)->page(I("get.page"), I("get.limit"))->select();
        $count = M("retail_cashier")->where($map)->count();
        foreach ($info as $key => $value) {
            $info[$key]['index'] = $key + 1;
            $info[$key]['storetag'] = M("retail_store")->where(array('id' => $value['storeid']))->getField('storetag');
            $info[$key]['addtime'] = date("Y-m-d H:i:s", $value['addtime']);
            $info[$key]['canrefund'] = $value['canrefund'] == 2 ? "开启" : "关闭";
            $info[$key]['canrecharge'] = $value['canrecharge'] == 2 ? "开启" : "关闭";
            $info[$key]['modifymem'] = $value['modifymem'] == 2 ? "开启" : "关闭";
            $info[$key]['customviprecharge'] = $value['customviprecharge'] == 2 ? "开启" : "关闭";
            $info[$key]['salesdiction'] = $value['salesdiction'] == 1 ? "开启" : "关闭";
            $info[$key]['preferential'] = $value['preferential'] == 1 ? "开启" : "关闭";

            $info[$key]['sku_discount'] = $value['sku_discount'] == 1 ? "开启" : "关闭";
            $info[$key]['code_auth'] = $value['code_auth'] == 1 ? "开启" : "关闭";
        }

        $res['code'] = 0;
        $res['count'] = $count;
        $res['data'] = $info;

        $this->ajaxReturn($res);

    }

    //收银员信息导出
    public function cashierInfoExport()
    {
        $userinfo = session("ls_userinfo");
        $storeid = session("storeid");
        $keyword = I("get.keyword");
        if (!empty($keyword)) {
            if (is_numeric($keyword)) {
                $map['mobile'] = $keyword;
            } else {
                $map['name'] = array('like', "%" . $keyword . "%");
            }
        }
        $map['merchantid'] = $userinfo['merchantid'];
        $map['storeid'] = $storeid;
        $map['status'] = 1;
        $info = M("retail_cashier")->where($map)->select();
        foreach ($info as $key => $value) {
            $info[$key]['index'] = $key + 1;
            $info[$key]['storetag'] = M("retail_store")->where(array('id' => $value['storeid']))->getField('storetag');
            $info[$key]['addtime'] = date("Y-m-d H:i:s", $value['addtime']);
            $info[$key]['canrefund'] = $value['canrefund'] == 2 ? "开启" : "关闭";
            $info[$key]['canrecharge'] = $value['canrecharge'] == 2 ? "开启" : "关闭";
            $info[$key]['modifymem'] = $value['modifymem'] == 2 ? "开启" : "关闭";
            $info[$key]['customviprecharge'] = $value['customviprecharge'] == 2 ? "开启" : "关闭";
            $info[$key]['salesdiction'] = $value['salesdiction'] == 1 ? "开启" : "关闭";
            $info[$key]['preferential'] = $value['preferential'] == 1 ? "开启" : "关闭";
        }
        $field_name = '收银员信息';
        $arr = array(
            array('index', '序号'),
            array('name', '姓名'),
            array('jobnum', '工号'),
            array('mobile', '手机号码'),
            array('storetag', '门店'),
            array('addtime', '加入时间'),
            array('canrefund', '退款权限'),
            array('canrecharge', '充值权限'),
            array('modifymem', '编辑资料权限'),
            array('customviprecharge', '赠送金额权限(自定义)'),
            array('salesdiction', '销售明细权限'),
            array('preferential', '结算打折'),
        );
        $str = $field_name . '导出日期' . date('Y-m-d H:i:s', time());
        $this->getExcel($field_name, $arr, $info, $str);
    }

    public function addCashier()
    {
        $userinfo = session("ls_userinfo");
        $storeid = session("storeid");
        if (IS_POST) {
            $data = I("post.");
            //需要先判断手机号是否被使用过
            $map = array(
                'c.mobile' => $data['mobile'],
                'c.status' => 1,
                's.state' => 0,
            );
            $cashier = M('retail_cashier as c')
                ->join('ls_retail_store as s on s.id=c.storeid')
                ->where($map)
                ->find();
            if (empty($cashier)) {
                if (strlen($data['password']) > 16) {
                    $res['status'] = 0;
                    $res['msg'] = '密码不能大于16位';
                    $this->ajaxReturn($res);
                    exit;
                }
                //工号不可重复
                $jobnum = M("retail_cashier")->where(array('storeid' => $storeid, 'jobnum' => $data['jobnum'], 'status' => 1))->find();
                if (empty($jobnum)) {
                    $NowTime = time();
                    $CryptrModel = new \Addons\Api\Crypto ();
                    $data['password'] = $CryptrModel->encrypt($data['password'], date('YmdHis', $NowTime));
                    $data['storeid'] = $storeid;
                    $data['merchantid'] = $userinfo['merchantid'];
                    $data['addtime'] = $NowTime;

                    $create = M("retail_cashier")->add($data);
                    if ($create) {
                        //操作日志记录
                        $source = 0;//请求来源： 0pc系统 1小助手
                        $type = 4;//平台：1合伙人端 2代理商端  3商户端  4门店端
                        $request_data = json_encode($_POST);//请求参数 json数据
                        $desc = '收银员-添加';//操作行为描述
                        action_log($source,$type,$request_data,$desc);

                        $res['status'] = 1;
                        $res['msg'] = '添加成功';
                    } else {
                        $res['status'] = 0;
                        $res['msg'] = '添加失败';
                    }
                } else {
                    $res['status'] = 0;
                    $res['msg'] = '工号已存在,请更换工号';
                }
            } else {
                $res['status'] = 0;
                $res['msg'] = '该手机号已被使用,请更换手机号';
            }

            $this->ajaxReturn($res);
        }

        //门店名称
        $map['id'] = $storeid;
        $map['merchantid'] = $userinfo['merchantid'];
        $storetag = M("retail_store")->where($map)->getField('storetag');

        $this->assign('storetag', $storetag);
        $this->display();
    }

    public function delCashier()
    {
        if (IS_POST) {
            $id = I('post.id');
            $w['id'] = $id;
            $data['status'] = 2;
            $ret = M('retail_cashier')->where($w)->save($data);
            if ($ret) {
                //操作日志记录
                $source = 0;//请求来源： 0pc系统 1小助手
                $type = 4;//平台：1合伙人端 2代理商端  3商户端  4门店端
                $request_data = json_encode($_POST);//请求参数 json数据
                $desc = '收银员-删除';//操作行为描述
                action_log($source,$type,$request_data,$desc);

                $rt['status'] = 1;
                $rt['msg'] = '删除成功';
            } else {
                $rt['status'] = 2;
                $rt['msg'] = '删除失败';
            }
            $this->ajaxReturn($rt);
        }
    }

    public function editadCashier()
    {
        if (IS_POST) {
            $data = I("post.");
            if (empty($data['id'])) {
                $res['status'] = 0;
                $res['msg'] = '参数错误,请重试';
            } else {
                if (empty($data['password'])) {
                    //不修改密码
                    //手机号是否使用
                    $map['status'] = 1;
                    $map['mobile'] = $data['mobile'];
                    $map['id'] = array('neq', $data['id']);

                    $find = M("retail_cashier")->where($map)->find();
                    unset($map['mobile']);
                    $map['jobnum'] = $data['jobnum'];
                    $map['storeid'] = session("storeid");
                    $jobunm = M("retail_cashier")->where($map)->find();
                    if (empty($find)) {
                        if (empty($jobunm)) {
                            unset($data['password']);
                            $save = M("retail_cashier")->where(array('id' => $data['id']))->save($data);
                            if ($save) {
                                //操作日志记录
                                $source = 0;//请求来源： 0pc系统 1小助手
                                $type = 4;//平台：1合伙人端 2代理商端  3商户端  4门店端
                                $request_data = json_encode($_POST);//请求参数 json数据
                                $desc = '收银员-编辑-不修改密码';//操作行为描述
                                action_log($source,$type,$request_data,$desc);

                                $res['status'] = 1;
                                $res['msg'] = '修改成功';
                            } else {
                                $res['status'] = 0;
                                $res['msg'] = '修改失败';
                            }
                        } else {
                            $res['status'] = 0;
                            $res['msg'] = '该工号已被使用,请更换工号';
                        }
                    } else {
                        $res['status'] = 0;
                        $res['msg'] = '该手机号已被使用,请更换手机账号';
                    }
                } else {
                    //修改密码
                    if (strlen($data['password']) > 16) {
                        $res['status'] = 0;
                        $res['msg'] = '密码不能大于16位';
                        $this->ajaxReturn($res);
                        exit;
                    }
                    $map['status'] = 1;
                    $map['mobile'] = $data['mobile'];
                    $map['id'] = array('neq', $data['id']);

                    $find = M("retail_cashier")->where($map)->find();
                    unset($map['mobile']);
                    $map['jobnum'] = $data['jobnum'];
                    $map['storeid'] = session("storeid");
                    $jobunm = M("retail_cashier")->where($map)->find();
                    if (empty($find)) {
                        if (empty($jobunm)) {
                            //查询出用户的创建时间
                            $ctime = M("retail_cashier")->where(array('id' => $data['id']))->getField("addtime");

                            $CryptrModel = new \Addons\Api\Crypto ();
                            $data['password'] = $CryptrModel->encrypt($data['password'], date('YmdHis', $ctime));
                            $save = M("retail_cashier")->where(array('id' => $data['id']))->save($data);
                            if ($save) {
                                //操作日志记录
                                $source = 0;//请求来源： 0pc系统 1小助手
                                $type = 4;//平台：1合伙人端 2代理商端  3商户端  4门店端
                                $request_data = json_encode($_POST);//请求参数 json数据
                                $desc = '收银员-编辑-修改密码';//操作行为描述
                                action_log($source,$type,$request_data,$desc);

                                $res['status'] = 1;
                                $res['msg'] = '修改成功';
                            } else {
                                $res['status'] = 0;
                                $res['msg'] = '修改失败';
                            }
                        } else {
                            $res['status'] = 0;
                            $res['msg'] = '该工号已被使用,请更换工号';
                        }
                    } else {
                        $res['status'] = 0;
                        $res['msg'] = '该手机号已被使用,请更换手机账号';
                    }

                }
            }
            $this->ajaxReturn($res);
        }
        $id = I("get.id");
        $info = M("retail_cashier")->where(array('id' => $id))->find();
        $info['storetag'] = M("retail_store")->where(array('id' => $info['storeid']))->getField('storetag');
        $this->assign("info", $info);
        $this->display();
    }

    // 收银
    public function cashier()
    {
        $userinfo = session("ls_userinfo");
        if ($userinfo['storeid'] == null || $userinfo['storeid'] == '') {
            $where['merchantid'] = $userinfo['merchantid'];
            $where['store_type'] = 0;
            $one = M("store")->where($where)->find();
            if ($one) {
                $storeid = $one['id'];
            }
        } else {
            $storeid = $userinfo['storeid'];
        }
        if (IS_POST) {

        } else {
            $this->assign('storeid', $storeid);
            $this->assign('merchantid', $userinfo['merchantid']);
            $this->display();
        }
    }


    // 收银详情
    public function cashierlist()
    {
        $userinfo = session("ls_userinfo");
        if ($userinfo['storeid'] == null || $userinfo['storeid'] == '') {
            $where['merchantid'] = $userinfo['merchantid'];
            $where['store_type'] = 0;
            $one = M("store")->where($where)->find();
            if ($one) {
                $storeid = $one['id'];
            }
        } else {
            $storeid = $userinfo['storeid'];
        }
        if (IS_POST) {

        } else {
            $sstr = I('get.start');
            $estr = I('get.end');
            $aid = I('get.aid');
            $start = strtotime($sstr);
            $end = strtotime($estr);
            if (!$sstr) {
                $start = strtotime(date('Y-m-d', time()));
                $end = time();
            }
            if ($aid && $aid != -1) {
                $w['c.handleid'] = $aid;
            }
            $w['c.addtime'] = array('between', array($start, $end));
            $w['c.storeid'] = $storeid;
            $info = M('cashier_pay')->alias('c')
                ->join('ls_admin as a on c.handleid=a.id', 'LEFT')
                ->field('c.*,a.real_name')
                ->where($w)->order('c.addtime')->select();
            $w['c.type'] = 1;
            $type1 = M('cashier_pay')->alias('c')
                ->where($w)->order('c.addtime')->sum('money');
            $w['c.type'] = 2;
            $type2 = M('cashier_pay')->alias('c')
                ->where($w)->order('c.addtime')->sum('money');
            $w['c.type'] = 3;
            $type3 = M('cashier_pay')->alias('c')
                ->where($w)->order('c.addtime')->sum('money');
            $w['c.type'] = 4;
            $type4 = M('cashier_pay')->alias('c')
                ->where($w)->order('c.addtime')->sum('money');
            $w['c.type'] = 5;
            $type5 = M('cashier_pay')->alias('c')
                ->where($w)->order('c.addtime')->sum('money');
            $type1 = $type1 ? $type1 : 0;
            $type2 = $type2 ? $type2 : 0;
            $type3 = $type3 ? $type3 : 0;
            $type4 = $type4 ? $type4 : 0;
            $type5 = $type5 ? $type5 : 0;
            $this->assign('type1', $type1);
            $this->assign('type2', $type2);
            $this->assign('type3', $type3);
            $this->assign('type4', $type4);
            $this->assign('type5', $type5);
            $this->assign('cashierlist', $info);
            $cw1['merchantid'] = $userinfo['merchantid'];
            $one = M('admin')->where($cw1)->find();
            $cw['merchantid'] = $userinfo['merchantid'];
            $cw['storeid'] = $storeid;
            $cw['account_type'] = array('in', array(2, 3)); // 店长和收银员。。。
            $cw['state'] = 0;
            $clist = M('admin')->where($cw)->select();
            $this->assign('clist', $clist);
            $this->display();
        }
    }

    // 交接班数据
    public function shiftingdetail()
    {
        $id = I('get.id');
        $where['cashierid'] = $id;
        $cashierInfo = $this->cashierMoneyTotal($where);
        $this->assign('id', $id);
        $this->assign('cashierInfo', $cashierInfo);
        $arr = array(
            'cashierExport' => '/index.php//Retail/Cashier/cashierExport',
        );
        $authArr = checkFunction($arr);
        $this->assign('authArr', $authArr);
        $this->display();
    }

    /*
     * 收银金额统计
     * @param $rmbpay  现金
     * @param $wxpay   微信
     * @param $alipay  支付宝
     * @param $other_pay 其他
     * @param $recharge_cash  现金充值
     * @parma  $recharge_wx   微信充值
     * @param  $recharge_zfb  支付宝充值
     */
    public function cashierMoneyTotal($where)
    {
        $cashierInfo = M('retail_record')->where($where)->select();
        $rmbpay = 0;
        $wxpay = 0;
        $alipay = 0;
        $other_pay = 0;
        $recharge_cash = 0;
        $recharge_wx = 0;
        $recharge_zfb = 0;
        if ($cashierInfo) {
            foreach ($cashierInfo as $key => &$val) {
                if (!empty($val['rmbpay'])) {
                    $rmbpay += $val["rmbpay"];
                }
                if (!empty($val['wxpay'])) {
                    $wxpay += $val['wxpay'];
                }
                if (!empty($val['alipay'])) {
                    $alipay += $val['alipay'];
                }
                if (!empty($val['other_pay'])) {
                    $other_pay += $val['other_pay'];
                }
                if (!empty($val['recharge_cash'])) {
                    $recharge_cash += $val['recharge_cash'];
                }
                if (!empty($val['recharge_wx'])) {
                    $recharge_wx += $val['recharge_wx'];
                }
                if (!empty($val['cash_box'])) {
                    $cash_box += $val['cash_box'];
                }
                if (!empty($val['recharge_zfb'])) {
                    $recharge_zfb += $val['recharge_zfb'];
                }
            }
        }
        $store_id = session('storeid');
        $cashier_id = $where['cashierid'];
        $WorkRecordModel = D('WorkRecord');
        $map = array(
            $WorkRecordModel::STORE_ID => $store_id,
            $WorkRecordModel::CASHIER_ID => $cashier_id
        );
        $record = $WorkRecordModel->getOrderFind($map, '*', $WorkRecordModel::START_TIME . ' desc');
        if (!empty($record) && empty($record[$WorkRecordModel::END_TIME])) {
            $payList = A('PayApi/SellData')->getPayData($record[$WorkRecordModel::START_TIME], time(), $store_id, $cashier_id);
            $rmbpay += $payList['cash_amount'];
            $wxpay += $payList['weChat_amount'];
            $alipay += $payList['ali_amount'];
            $other_pay += $payList['other_amount'];
            $recharge_cash += $payList['recharge_cash_amount'];
            $recharge_wx += $payList['recharge_weChat_amount'];
            $recharge_zfb += $payList['recharge_ali_amount'];
        }

        $arr['rmbpay'] = $rmbpay;
        $arr['wxpay'] = $wxpay;
        $arr['alipay'] = $alipay;
        $arr['other_pay'] = $other_pay;
        $arr['recharge_cash'] = $recharge_cash;
        $arr['recharge_wx'] = $recharge_wx;
        $arr['recharge_zfb'] = $recharge_zfb;
        return $arr;
    }

    public function shiftingdetailinfo()
    {
        $id = I('get.id');
        $time = I('get.date01');
        $admin = M('retail_cashier')->where(array('id' => $id))->find();
        if (!empty($time)) {
            $time = explode("至", $time);
            $start_time = strtotime($time[0] . "00:00:00");
            $end_time = strtotime($time[1] . "23:59:59");
            $where['start_time'] = array('between', array($start_time, $end_time));
        }
        $where['cashierid'] = $id;
        $count = M('retail_record')->where($where)->count();
        $records = M('retail_record')->where($where)->page($_GET['page'], $_GET['limit'])->order('start_time desc')->select();
        $index = 1;
        foreach ($records as $k => $v) {
            $records[$k]['index'] = $index;
            $records[$k]['name'] = $admin['name'];
            $records[$k]['start_time'] = date('Y-m-d H:i:s', $v['start_time']);
            if ($v['end_time']) {
                $records[$k]['end_time'] = date('Y-m-d H:i:s', $v['end_time']);
                $jgtime = $v['end_time'] - $v['start_time'];
                $records[$k]['jg_time'] = round($jgtime / 3600, 0) . '时' . round(($jgtime / 60) % 60, 0) . '分';
            } else {
                $now_time = time();
                $payList = A('PayApi/SellData')->getPayData($v['start_time'], $now_time, $admin['storeid'], $id);

                $records[$k]['end_time'] = '尚未交班';
                $time = $now_time - $records[$k]['start_time'];
                $records[$k]['jg_time'] = round($time / 3600, 0) . '时' . round(($time / 60) % 60, 0) . '分';
                $records[$k]['wxpay'] = $payList['weChat_amount'];
                $records[$k]['alipay'] = $payList['ali_amount'];
                $records[$k]['rmbpay'] = $payList['cash_amount'];
                $records[$k]['cash_box'] = $this->rnf($v['cash_box']);
                //rnf封装在controller.class里,下面是不用封装方法的写法
                // $records[$k]['cash_box'] = rtrim(rtrim(number_format($v['cash_box'], 2), '0'), '.');
                $records[$k]['recharge'] = round($payList['recharge_cash_amount'] + $payList['recharge_weChat_amount'] + $payList['recharge_ali_amount'], 2);
                $records[$k]['recharge_cash'] = $payList['recharge_cash_amount'];
                $records[$k]['recharge_wx'] = $payList['recharge_weChat_amount'];
                $records[$k]['recharge_zfb'] = $payList['recharge_ali_amount'];
                $records[$k]['other_pay'] = $payList['other_amount'];
            }
            $index++;
        }
        $rt['code'] = 0;
        $rt['msg'] = '';
        $rt['count'] = $count;
        $rt['data'] = $records;
        $this->ajaxReturn($rt);
    }

    /*
     * 搜索收银员金额统计
     */
    public function cashierSearch()
    {
        $date01 = I('post.date01');
        if (!empty($date01)) {
            $time = explode("至", $date01);
            $start_time = strtotime($time[0] . "00:00:00");
            $end_time = strtotime($time[1] . "23:59:59");
            $where['start_time'] = array('between', array($start_time, $end_time));
        }
        $where['cashierid'] = I('post.id');
        $cashierInfo = $this->cashierMoneyTotal($where);
        $res['status'] = 1;
        $res['cashierInfo'] = $cashierInfo;
        $this->ajaxReturn($res);
    }

    /*
     * 交班记录导出
     */
    public function cashierExport()
    {
        $id = I('get.id');
        $time = I('get.date01');
        $admin = M('retail_cashier')->where(array('id' => $id))->find();
        if (!empty($time)) {
            $time = explode("至", $time);
            $start_time = strtotime($time[0] . "00:00:00");
            $end_time = strtotime($time[1] . "23:59:59");
            $where['start_time'] = array('between', array($start_time, $end_time));
        }
        $where['cashierid'] = $id;
        $records = M('retail_record')->where($where)->order('start_time desc')->select();
        $index = 1;
        foreach ($records as $k => $v) {
            $records[$k]['index'] = $index;
            $records[$k]['name'] = $admin['name'];
            $records[$k]['start_time'] = date('Y-m-d H:i:s', $v['start_time']);
            if ($v['end_time']) {
                $records[$k]['end_time'] = date('Y-m-d H:i:s', $v['end_time']);
                $jgtime = $v['end_time'] - $v['start_time'];
                $records[$k]['jg_time'] = round($jgtime / 3600, 0) . '时' . round(($jgtime / 60) % 60, 0) . '分';
            } else {
                $records[$k]['end_time'] = '尚未交班';
                $records[$k]['jg_time'] = '--';
                $records[$k]['wxpay'] = '--';
                $records[$k]['alipay'] = '--';
                $records[$k]['rmbpay'] = '--';
                $records[$k]['recharge'] = '--';
                $records[$k]['recharge_cash'] = '--';
                $records[$k]['recharge_wx'] = '--';
                $records[$k]['recharge_zfb'] = '--';
                $records[$k]['other_pay'] = '--';
            }
            $index++;
        }
        $field = '收银员交班记录导出';
        $arr = array(
            array('index', '序号'),
            array('name', '姓名'),
            array('jobnum', '工号'),
            array('start_time', '开班时间'),
            array('end_time', '交班时间'),
            array('jg_time', '间隔时间'),
            array('wxpay', '微信金额(元)'),
            array('alipay', '支付宝金额(元)'),
            array('rmbpay', '现金(元)'),
            array('other_pay', '其他支付(元)'),
            array('recharge_cash', '现金充值支付(元)'),
            array('recharge_wx', '微信充值支付(元)'),
            array('recharge_zfb', '支付宝充值支付(元)'),
            array('recharge', '充值总金额(元)'),
        );
        $str = $field . '导出日期' . date('Y-m-d H:i:s', time());
        $this->getExcel($field, $arr, $records, $str);
    }

    private function getExcel($expTitle, $expCellName, $expTableData, $str = "")
    {

        $xlsTitle = iconv('utf-8', 'gb2312', $expTitle);//文件名称
        $fileName = $expTitle . date('_YmdHis');//or $xlsTitle 文件名称可根据自己情况设定
        $cellNum = count($expCellName);
        $dataNum = count($expTableData);
        $common = $str;
        vendor("PHPExcel.PHPExcel");
        ob_clean();
        $objPHPExcel = new \PHPExcel();
        $cellName = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', 'AA', 'AB', 'AC', 'AD', 'AE', 'AF', 'AG', 'AH', 'AI', 'AJ', 'AK', 'AL', 'AM', 'AN', 'AO', 'AP', 'AQ', 'AR', 'AS', 'AT', 'AU', 'AV', 'AW', 'AX', 'AY', 'AZ');

        $objPHPExcel->getActiveSheet(0)->mergeCells('A1:' . $cellName[$cellNum - 1] . '1');//合并单元格
        $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', $common);
//        $objPHPExcel->setActiveSheetIndex(1)->setCellValue('A1', $str);
        for ($i = 0; $i < $cellNum; $i++) {
            $objPHPExcel->setActiveSheetIndex(0)->setCellValue($cellName[$i] . '2', $expCellName[$i][1]);
        }

        for ($i = 0; $i < $dataNum; $i++) {
            for ($j = 0; $j < $cellNum; $j++) {
                $objPHPExcel->getActiveSheet(0)->setCellValue($cellName[$j] . ($i + 3), ' ' . $expTableData[$i][$expCellName[$j][0]]);

            }
        }
        foreach ($cellName as $value) {
            $objPHPExcel->getActiveSheet()->getColumnDimension($value)->setWidth(20);

        }
        header('pragma:public');
        header('Content-type:application/vnd.ms-excel;charset=utf-8;name="' . $xlsTitle . '.xls"');
        header("Content-Disposition:attachment;filename=$fileName.xls");//attachment新窗口打印inline本窗口打印
        $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
        $objWriter->save('php://output');
        exit();
    }

    public function editadCashierrefund()
    {
        if (IS_POST) {
            $id = I('post.id');
            $canrefund = I('post.canrefund');
            $refundcode = I('post.refundcode');
            $refundcode = trim($refundcode);
            $canrefund = $canrefund ? 2 : 1;
            if ($canrefund == 1) {
                $sdata['refundcode'] = $refundcode;
                $sdata['canrefund'] = $canrefund;
            } else {
                if ($refundcode) {
                    $sdata['refundcode'] = $refundcode;
                    $sdata['canrefund'] = $canrefund;
                } else {
                    $rt['status'] = 0;
                    $rt['msg'] = '设置失败，开启权限时授权码不得为空';
                    $this->ajaxReturn($rt);
                }
            }

            $info = M("retail_cashier")->where(array('id' => $id))->save($sdata);
            if ($info !== false) {
                $rt['status'] = 1;
                $rt['msg'] = '设置成功';
            } else {
                $rt['status'] = 0;
                $rt['msg'] = '设置失败,请稍后再试';
            }
            $this->ajaxReturn($rt);
        } else {
            $id = I("get.id");
            $info = M("retail_cashier")->where(array('id' => $id))->find();
            $this->assign("info", $info);
            $this->display();
        }
    }

    public function editadCashierrecharge()
    {
        if (IS_POST) {
            $id = I('post.id');
            $canrefund = I('post.canrecharge');
            $refundcode = I('post.rechargecode');
            $refundcode = trim($refundcode);
            $canrefund = $canrefund ? 2 : 1;
            if ($canrefund == 1) {
                $sdata['rechargecode'] = $refundcode;
                $sdata['canrecharge'] = $canrefund;
            } else {
                if ($refundcode) {
                    $sdata['rechargecode'] = $refundcode;
                    $sdata['canrecharge'] = $canrefund;
                } else {
                    $rt['status'] = 0;
                    $rt['msg'] = '设置失败，开启权限时授权码不得为空';
                    $this->ajaxReturn($rt);
                }
            }

            $info = M("retail_cashier")->where(array('id' => $id))->save($sdata);
            if ($info !== false) {
                $rt['status'] = 1;
                $rt['msg'] = '设置成功';
            } else {
                $rt['status'] = 0;
                $rt['msg'] = '设置失败,请稍后再试';
            }
            $this->ajaxReturn($rt);
        } else {
            $id = I("get.id");
            $info = M("retail_cashier")->where(array('id' => $id))->find();
            $this->assign("info", $info);
            $this->display();
        }
    }

    public function model()
    {
        $type = I('get.type');
        if (empty($type)) {
            $this->error('访问错误');
        }
        $storeid = session('storeid');
        if ($type == 2) {
            $id = I('get.id');
            if (empty($id)) {
                $this->error('访问错误');
            }
            $cashier = M('retail_cashier')->where(array('storeid' => $storeid, 'id' => $id, 'status' => 1))->find();
            if (empty($cashier)) {
                $this->error('收银员不存在');
            }
            $this->assign('status', $cashier['cash_model']);
            $this->assign('id', $id);
        } else {
            $all = M('retail_cashier')->where(array('storeid' => $storeid, 'status' => 1))->count();
            $all1 = M('retail_cashier')->where(array('storeid' => $storeid, 'status' => 1, 'cash_model' => 1))->count();
            if ($all && $all == $all1) {
                $this->assign('status', 1);
            } else if ($all && $all1 == 0) {
                $this->assign('status', 2);
            }
        }
        $this->assign('type', $type);
        $this->display();
    }

    public function setModel()
    {
        $storeid = session('storeid');
        $type = I('post.type');
        $id = I('post.id');
        $status = I('post.status');
        if (empty($status) || empty($type)) {
            $res['status'] = 0;
            $res['msg'] = '缺少参数';
            $this->ajaxReturn($res);
        }
        if ($type == 1) {
            $update = M('retail_cashier')->where(array('storeid' => $storeid, 'status' => 1))->save(array('cash_model' => $status));
        } else if ($type == 2) {
            if (empty($id)) {
                $res['status'] = 0;
                $res['msg'] = '缺少参数';
                $this->ajaxReturn($res);
            }
            $update = M('retail_cashier')->where(array('storeid' => $storeid, 'status' => 1, 'id' => $id))->save(array('cash_model' => $status));
        } else {
            $res['status'] = 0;
            $res['msg'] = '参数有误';
            $this->ajaxReturn($res);
        }
        if ($update) {
            //操作日志记录
            $source = 0;//请求来源： 0pc系统 1小助手
            $type = 4;//平台：1合伙人端 2代理商端  3商户端  4门店端
            $request_data = json_encode($_POST);//请求参数 json数据
            $desc = '收银员-模板设置';//操作行为描述
            action_log($source,$type,$request_data,$desc);

            $res['status'] = 1;
            $res['msg'] = '设置成功';
        } else {
            $res['status'] = 0;
            $res['msg'] = '设置成功';
        }
        $this->ajaxReturn($res);
    }

    //权限设置
    public function permiset()
    {
        $id = I("get.id");
        $info = M("retail_cashier")->where(array('id' => $id))->find();
        $this->assign("info", $info);
        $this->display();
    }

    //权限提交
    public function permisetsub()
    {
        if (IS_POST) {
            $storeid = session('storeid');
            $info = I('post.');
            if (empty($info['id'])) {
                $res['status'] = 0;
                $res['msg'] = '参数有误';
                $this->ajaxReturn($res);
                exit;
            }
            $canrecharge = $info['canrecharge'] == 'on' ? 2 : 1;
            $canrefund = $info['canrefund'] == 'on' ? 2 : 1;
            $modifymem = $info['modifymem'] == 'on' ? 2 : 1;
            $modify_plus_mem = $info['modify_plus_mem'] == 'on' ? 2 : 1;
            $salesdiction = $info['salesdiction'] == 'on' ? 1 : 2;
            $preferential = $info['preferential'] == 'on' ? 1 : 0;
            $cashier_show_other_sell = $info['cashier_show_other_sell'] == 'on' ? 1 : 2;
            $cashier_add_goods = $info['cashier_add_goods'] == 'on' ? 1 : 2;

            $data['code_auth'] = $info['code_auth'] == 'on' ? 1 : 0; // 授权码总权限  是否需要授权码(总):0=不需要,1=需要

            // 单品打折
            $data['manual_discount'] = $info['manual_discount'] == 'on' ? 1 : 0; // 手动打折权限:0=未开启,1=开启
            $data['manual_min_discount'] = $info['manual_min_discount']; // 手动打折最低折扣
            $data['manual_max_amount'] = $info['manual_max_amount']; // 手动打折最多优惠金额
            $data['manual_discount_code'] = $info['manual_discount_code']; // 手动打折授权码

            if( !empty($data['code_auth']) ){
                if ( empty($data['sku_discount_code']) ||  strlen($data['sku_discount_code']) > 30) {
                    $res['status'] = 0;
                    $res['msg'] = '单品打折授权码有误';
                    $this->ajaxReturn($res);
                }
            }

//            if( !empty($data['manual_discount']) ){
                if( empty($data['manual_min_discount']) || $data['manual_min_discount'] > 1 || $data['manual_min_discount'] <= 0 || !is_numeric($data['manual_min_discount']) ){
                    $res['status'] = 0;
                    $res['msg'] = '折扣数据错误1';
                    $this->ajaxReturn($res);
                }

                if( !empty($data['manual_max_amount']) ){
                    if( $data['manual_max_amount'] > 100 || $data['manual_max_amount'] < 0 || !is_numeric($data['manual_max_amount']) ){
                        $res['status'] = 0;
                        $res['msg'] = '优惠金额错误,金额取值0.01~99.99';
                        $this->ajaxReturn($res);
                    }
                } else {
                    $data['manual_max_amount'] = null;
                }
//            }

            if ($modifymem == 2 || $modify_plus_mem == 2) {
                $jurisdiction = M('retail_store_jurisdiction')->field("store_operation_vip,store_edit_vip_info")->where(array('storeid' => $storeid))->find();
                if (!empty($jurisdiction) && $jurisdiction['store_operation_vip'] == 2) {
                    $res['status'] = 0;
                    $res['msg'] = '门店暂无编辑会员资料权限';
                    $this->ajaxReturn($res);
                    exit;
                }
                if (!empty($jurisdiction) && $jurisdiction['store_edit_vip_info'] == 2) {
                    $res['status'] = 0;
                    $res['msg'] = '门店暂无编辑会员资料权限';
                    $this->ajaxReturn($res);
                    exit;
                }
            }
            //充值
            $data['canrecharge'] = $canrecharge;
            $data['refundcode'] = $info['refundcode'];
            //退款码
            $data['canrefund'] = $canrefund;
            $data['rechargecode'] = $info['rechargecode'];
            //修改资料
            $data['modifymem'] = $modifymem;
            $data['modifymemcode'] = $info['modifymemcode'];
            $data['customviprecharge'] = $info['customviprecharge'] == 'on' ? 2 : 1;
            //打印销售明细
            $data['salesdiction'] = $salesdiction;
            //打印次数
            $data['print_time'] = intval($info['print_time']);
            if ($canrecharge == 2 && empty($data['rechargecode']) || $canrecharge == 2 && strlen($data['rechargecode']) > 30) {
                $res['status'] = 0;
                $res['msg'] = '充值权限权限码有误';
                $this->ajaxReturn($res);
                exit;
            }
            if ($canrefund == 2 && empty($data['refundcode']) || $canrefund == 2 && strlen($data['refundcode']) > 30) {
                $res['status'] = 0;
                $res['msg'] = '退款权限权限码有误';
                $this->ajaxReturn($res);
                exit;
            }
            if ($modifymem == 2 && empty($data['modifymemcode']) || $modifymem == 2 && strlen($data['modifymemcode']) > 30) {
                $res['status'] = 0;
                $res['msg'] = '编辑会员权限码有误';
                $this->ajaxReturn($res);
                exit;
            }
            if (empty($data['print_time']) || $data['print_time'] < 0 || !is_numeric($data['print_time'])) {
                $res['status'] = 0;
                $res['msg'] = '打印次数格式错误';
                $this->ajaxReturn($res);
                exit;
            }
            $data['preferential'] = $preferential;
            $data['cashier_show_other_sell'] = $cashier_show_other_sell;
            $data['cashier_add_goods'] = $cashier_add_goods;
            $data['modify_plus_mem'] = $modify_plus_mem;
            $save = M('retail_cashier')->where(array('id' => $info['id']))->save($data);
            if ($save) {
                //操作日志记录
                $source = 0;//请求来源： 0pc系统 1小助手
                $type = 4;//平台：1合伙人端 2代理商端  3商户端  4门店端
                $request_data = json_encode($_POST);//请求参数 json数据
                $desc = '收银员-设置';//操作行为描述
                action_log($source,$type,$request_data,$desc);

                $res['status'] = 1;
                $res['msg'] = '设置成功';
            } else {
                $res['status'] = 1;
                $res['msg'] = '暂无修改';
            }
        } else {
            $res['status'] = 0;
            $res['msg'] = '非法请求';
        }
        $this->ajaxReturn($res);
    }
}