<?php
namespace Admin\Controller;

use Common\Controller\AdminController;
use Niaoyun\Admin\AdminLog;
use Common\Type\Areas;
use Niaoyun\BasePage;
use User\Model\TmOrdersModel;
use EB\Tar\TarWriter;
use EB\Services\EmailMessage;
use EB\Services\SmsMessage;
/**
 * create by ZHG
 *
 * 商标订单
 * Class TmOrderController
 * @package Admin\Controller
 */
class TmOrderController extends AdminController
{
	public function __construct()
	{
		parent::__construct();
	}

	///商标列表
	public function index()
	{
		$pagesize = I('pagesize', 20, 'intval');
		$page = I('get.page',1,'intval');

		$userid = I('user_id');

		$where=array();
		if(!empty($userid)){
			$where['userid'] = $userid;
		}
		$keyword = I('get.keyword');
		$status = I('get.status');
		$producttype = I('get.producttype');
		if(!empty($keyword)){
			$ids = M('tm_applyer')->where(['name'=>['like', '%' . $keyword . '%']])->getField('id', true);
			 $keyword_where= [
				'tm_orders.name'=>['like', '%' . $keyword . '%'],
				'tm_orders.orderid'=>$keyword,
				'tm_orders.applynumber'=>$keyword,
                 'tm_orders.id'=>$keyword,
				'_logic' => 'OR'
			];
			if(!empty($ids)){
				$keyword_where['tm_orders.applyerid'] =['in', $ids];
			}
			$where[]= $keyword_where;
		}
		if(!empty($status)){
		    if($status == 1){
                $status = '待审核';
            }
            if($status == 2){
                $status = '待提交至商标局';
            }
			$where['tm_orders.status'] = $status;
		}
		if(!empty($producttype)){
			$where['producttype'] = $producttype;
		}
		$count = M("tm_orders")->where($where)->count();
		$page = new BasePage($count, $pagesize,array(),false);
        $page->setFormID('search_form');
        $hideparam = $page->hiddenParametersHtml();
		$this->assign('hiddenparms', $hideparam);
		$show = $page->pagination();

		$domains = M("tm_orders")->field('tm_orders.*, customerservice.name as kf_name')->where($where)->limit($page->firstRow . ',' . $page->listRows)->join('left join users on users.id = tm_orders.userid')->join('left join customerservice on users.customerServiceID = customerservice.id')->order('tm_orders.updatetime desc, tm_orders.submittime desc, tm_orders.id desc')->select();
		$applyer_id = [];
		$pay_status = ['未付款', '已付款', '已退款'];
		foreach( $domains as &$value )
		{
			$applyer_id[] = $value['applyerid'];
			$value['canrefund']=$this->canrefund($value);
			$value['cansubmit']=$this->cansubmit($value);
			$value['paystatus'] = $pay_status[$value['payed']];
		}
		if(!empty($applyer_id)){
			$applyers = M("tm_applyer")->where(['id'=>['in', $applyer_id]])->getField('id,name,status');
			$this->assign('applyers', $applyers);
		}
		$this->assign('tms', $domains);
		$this->assign('page', $show);
		$this->assign('producttype', $producttype);
		$this->assign('user_id', $userid);
		$this->assign('keyword', $keyword);
		$this->assign('status', $status);

		$this->display();
	}
	private function canrefund($tm){
		return $tm['payed']==1 && in_array($tm['status'], ['审核不通过','申请不予受理']);
	}
	private function cansubmit($tm){
		return in_array($tm['status'], ['审核通过']);
	}
	///修改商标
	public function edit()
	{
        if (IS_POST) {
            $id = I('post.id', 0, 'intval');
            $model = new TmOrdersModel();
            $returnURL = U('admin/TmOrder/edit', array('id' => $id));
            $data = $model->create(I('post.'));
            if (empty($data['submittoregistration'])) {
                $data['submittoregistration'] = null;
            }
            if (!$data) {
                $this->ajaxError($model->getError(), $returnURL, C('TIPS_TIMEOUT'));
                return;
            }
            if ($id == 0) {
                unset($data['id']);
                $result = $model->add($data);
            } else {
                $tm = M('tm_orders')->find($id);
                if (!$tm) {
                    $this->ajaxError('订单不存在', $returnURL, C('TIPS_TIMEOUT'));
                }
                $data['audittime'] = date('Y-m-d H:i:s');
                $result = $model->where(array('id' => $id))->save($data);
                if ($result !== false) {
                    $this->check_status($tm, $data);
                }
            }
            if ($result !== false) {
                AdminLog::SaveLog(AdminLog::tmeditorder, $id, $data['status'], $data, UID); //存log
                $this->ajaxSuccess('编辑成功', U('admin/TmOrder/index'), C('TIPS_TIMEOUT'));
                return true;
            }
            $this->ajaxError($model->getError(), $returnURL, C('TIPS_TIMEOUT'));
            return;
        }
        $id = I('id');
        $api = M('tm_orders')->where(array('id' => $id))->find();
        $logs = M('admin_log')->where(['objId' => $id, 'objType' => AdminLog::tmeditorder])->field('title,createTime')->order("id desc")->select();
        if (!$api) {
            $api = array('id' => 0);
        } else {
            $goods = explode('&nbsp;', base64_decode($api['goodsnamearray']));
            foreach ($goods as $key => &$value) {
                $value = explode('`', $value);
            }
        }
        $this->assign('goods', $goods);
        $this->assign('logs', $logs);
        $this->assign('applyer', M("tm_applyer")->where(['id' => $api['applyerid']])->find());
        $this->assign('api', $api);
        $this->display();
	}


	//保姆注册订单
    public function lists()
    {
        if (I('get.pagesize')) {
            $pagesize = I('get.pagesize');
        } else {
            $pagesize = 20;
        }
		$userid = I('user_id');
		$status = I('status');
		$where=array();
		if(!empty($userid)){
			$where['tm_orders_extends.userid'] = $userid;
		}
		if(!empty($status)){
			$where['tm_orders.status'] = $status;
		}

        $data = $this->Select(
            'tm_orders_extends',
            'tm_orders_extends.*, tm_orders.status, tm_orders.payed,tm_orders.cls as cls,tm_orders.name as name',
            $where,
            $pagesize,
            'left join tm_orders on tm_orders.id = tm_orders_extends.orderid'
        );
		// dump($data);
		foreach ($data['data'] as $key => &$value) {
			$value['classes'] = $value['cls'].' '.$this->tm_classes($value['cls']);
		}
        array_walk($data['data'], [$this, 'indexFormat']);

        $this->assign('list', $data['data']);
        $this->assign('pagination', $data['page']);
        $this->assign('pagesize', $pagesize);
		$this->assign('user_id', $userid);
		$this->assign('status', $status);
        $this->display();

	}

    //返回结果格式化
    private function indexFormat(&$item, $key) {

        switch ($item['payed']) {//判断发送状态
            case '0' :
                $item['payed'] = '未付款';
                break;
            case '1' :
                $item['payed'] = '已付款';
                break;
            case '2' :
                $item['payed'] = '已退款';
                break;
        }

    }


    /**
     * author:lirongsheng
     * description:删除商标订单
     */
    public function delete()
    {
        $id=I('post.id',0,'intval');

        $tm_order = M('tm_orders')->where(['id' => $id])->find();

        if (empty($tm_order) || $tm_order['status'] !== '待提交审核' || $tm_order['payed'] !=0) {
            $this->ajaxError('订单不存在或订单状态不能被删除');
        }

        $result = M('tm_orders')->where(['id' => $id, 'payed' => 0])->delete();
        if ($result) {
            $this->ajaxSuccess('删除成功');
        }
        $this->ajaxError('删除失败');
        
    }

    // 导出exl
    public function look_down()
    {
        $id = I('get.id');
        $where['tm_orders.id'] = $id;
        $data = M('tm_orders')->field('tm_orders.name as tm_name,cls,delegationfile,image1file,image2file,goodsnamearray,tm_applyer.*')->where($where)->join('left join tm_applyer on tm_orders.applyerid = tm_applyer.id')->select();
        // 导出Exl
        import("Org.Util.PHPExcel");
        import("Org.Util.PHPExcel.Worksheet.Drawing");
        import("Org.Util.PHPExcel.Writer.Excel2007");
        $objPHPExcel = new \PHPExcel();


        $objActSheet = $objPHPExcel->getActiveSheet();

        // 水平居中（位置很重要，建议在最初始位置）
        $objPHPExcel->setActiveSheetIndex(0)->getStyle('A')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle('B')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle('C')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle('D')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle('E')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle('F')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle('G')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle('H')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle('I')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle('J')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle('K')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle('L')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle('M')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle('N')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle('O')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle('P')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $objPHPExcel->setActiveSheetIndex(0)->getStyle('Q')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);


        $objActSheet->setCellValue('A1', '申请人类型');
        $objActSheet->setCellValue('B1', '商标名称');
        $objActSheet->setCellValue('C1', '商标分类');
        $objActSheet->setCellValue('D1', '代理委托书');
        $objActSheet->setCellValue('E1', '黑白图样');
        $objActSheet->setCellValue('F1', '着色图样');
        $objActSheet->setCellValue('G1', '申请人名称');
        $objActSheet->setCellValue('H1', '申请人地域');
        $objActSheet->setCellValue('I1', '申请人省/市/区');
        $objActSheet->setCellValue('J1', '申请人地址');
        $objActSheet->setCellValue('K1', '联系人姓名');
        $objActSheet->setCellValue('L1', '联系人电话');
        $objActSheet->setCellValue('M1', '联系人邮编');
        $objActSheet->setCellValue('N1', '证件文件');
        $objActSheet->setCellValue('O1', '证件文件（反面）');
        $objActSheet->setCellValue('P1', '主体文件');
        $objActSheet->setCellValue('Q1', '商标小类');
        // 设置个表格宽度
        $objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(16);
        $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(30);
        $objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(15);
        $objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(30);
        $objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(30);
        $objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(30);
        $objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(30);
        $objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(30);
        $objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(30);
        $objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(30);
        $objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(30);
        $objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(30);
        $objPHPExcel->getActiveSheet()->getColumnDimension('M')->setWidth(30);
        $objPHPExcel->getActiveSheet()->getColumnDimension('N')->setWidth(30);
        $objPHPExcel->getActiveSheet()->getColumnDimension('O')->setWidth(30);
        $objPHPExcel->getActiveSheet()->getColumnDimension('P')->setWidth(30);
        $objPHPExcel->getActiveSheet()->getColumnDimension('Q')->setWidth(100);

        // 垂直居中
        $objPHPExcel->getActiveSheet()->getStyle('A')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('B')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('C')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('D')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('E')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('F')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('G')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('H')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('I')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('J')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('K')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('L')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('M')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('N')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('O')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('P')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
        $objPHPExcel->getActiveSheet()->getStyle('Q')->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);

        $filename_tar = ROOT_PATH . "/Uploads/tmorders_down/TMID_" . $id . ".tar"; //最终生成的文件名（含路径）
        $tw = new TarWriter($filename_tar);
        foreach ($data as $k => $v) {
            $k += 2;
            if ($v['type'] == 1) {
                $v['type'] = '企业单位';
            }
            if ($v['type'] == 2) {
                $v['type'] = '自然人';
            }
            $objActSheet->setCellValue('A' . $k, $v['type']);
            $objActSheet->setCellValue('B' . $k, $v['tm_name']);
            $objActSheet->setCellValue('C' . $k, $v['cls']);

            // 图片生成
            if (!empty($v['delegationfile'])) {
                $objDrawing[$k] = new \PHPExcel_Worksheet_Drawing();
                $objDrawing[$k]->setPath(ROOT_PATH . $v['delegationfile']);
                // 设置宽度高度
                $objDrawing[$k]->setHeight(80);//照片高度
                $objDrawing[$k]->setWidth(80); //照片宽度
                /*设置图片要插入的单元格*/
                $objDrawing[$k]->setCoordinates('D' . $k);
                // 图片偏移距离
                $objDrawing[$k]->setOffsetX(12);
                $objDrawing[$k]->setOffsetY(12);
                $objDrawing[$k]->setWorksheet($objPHPExcel->getActiveSheet());
                $tw->add_file(ROOT_PATH . $v['delegationfile'], 'delegationfile.jpg');
            }

            if (!empty($v['image1file'])) {
                $objDrawing2[$k] = new \PHPExcel_Worksheet_Drawing();
                $objDrawing2[$k]->setPath(ROOT_PATH . $v['image1file']);
                // 设置宽度高度
                $objDrawing2[$k]->setHeight(80);//照片高度
                $objDrawing2[$k]->setWidth(80); //照片宽度
                /*设置图片要插入的单元格*/
                $objDrawing2[$k]->setCoordinates('E' . $k);
                // 图片偏移距离
                $objDrawing2[$k]->setOffsetX(12);
                $objDrawing2[$k]->setOffsetY(12);
                $objDrawing2[$k]->setWorksheet($objPHPExcel->getActiveSheet());
                $tw->add_file(ROOT_PATH . $v['image1file'], 'image1file.jpg');
            }

            if (!empty($v['image2file'])) {
                $objDrawing3[$k] = new \PHPExcel_Worksheet_Drawing();
                $objDrawing3[$k]->setPath(ROOT_PATH . $v['image2file']);
                // 设置宽度高度
                $objDrawing3[$k]->setHeight(80);//照片高度
                $objDrawing3[$k]->setWidth(80); //照片宽度
                /*设置图片要插入的单元格*/
                $objDrawing3[$k]->setCoordinates('F' . $k);
                // 图片偏移距离
                $objDrawing3[$k]->setOffsetX(12);
                $objDrawing3[$k]->setOffsetY(12);
                $objDrawing3[$k]->setWorksheet($objPHPExcel->getActiveSheet());
                $tw->add_file(ROOT_PATH . $v['image2file'], 'image2file.jpg');
            }

            // 表格内容
            $objActSheet->setCellValue('G' . $k, $v['name']);
            if ($v['nationality'] == 1) {
                $v['nationality'] = '中国大陆';
            }
            if ($v['nationality'] == 3) {
                $v['nationality'] = '中国台湾';
            }
            if ($v['nationality'] == 4) {
                $v['nationality'] = '中国香港';
            }
            if ($v['nationality'] == 5) {
                $v['nationality'] = '中国澳门';
            }
            $objActSheet->setCellValue('H' . $k, $v['nationality']);
            $objActSheet->setCellValue('I' . $k, Areas::get($v['province']) . Areas::get($v['city']) . Areas::get($v['district']));
            $objActSheet->setCellValue('J' . $k, $v['address']);
            $objActSheet->setCellValue('K' . $k, $v['receivename']);
            $objActSheet->setCellValue('L' . $k, $v['receivephone']);
            $objActSheet->setCellValue('M' . $k, $v['receivepostcode']);

            if (!empty($v['cerificatefile'])) {
                $objDrawing4[$k] = new \PHPExcel_Worksheet_Drawing();
                $objDrawing4[$k]->setPath(ROOT_PATH . $v['cerificatefile']);
                // 设置宽度高度
                $objDrawing4[$k]->setHeight(80);//照片高度
                $objDrawing4[$k]->setWidth(80); //照片宽度
                /*设置图片要插入的单元格*/
                $objDrawing4[$k]->setCoordinates('N' . $k);
                // 图片偏移距离
                $objDrawing4[$k]->setOffsetX(12);
                $objDrawing4[$k]->setOffsetY(12);
                $objDrawing4[$k]->setWorksheet($objPHPExcel->getActiveSheet());
                $tw->add_file(ROOT_PATH . $v['cerificatefile'], 'cerificatefile.jpg');
            }

            if (!empty($v['cerificatefile2'])) {
                $objDrawing5[$k] = new \PHPExcel_Worksheet_Drawing();
                $objDrawing5[$k]->setPath(ROOT_PATH . $v['cerificatefile2']);
                // 设置宽度高度
                $objDrawing5[$k]->setHeight(80);//照片高度
                $objDrawing5[$k]->setWidth(80); //照片宽度
                /*设置图片要插入的单元格*/
                $objDrawing5[$k]->setCoordinates('O' . $k);
                // 图片偏移距离
                $objDrawing5[$k]->setOffsetX(12);
                $objDrawing5[$k]->setOffsetY(12);
                $objDrawing5[$k]->setWorksheet($objPHPExcel->getActiveSheet());
                $tw->add_file(ROOT_PATH . $v['cerificatefile2'], 'cerificatefile2.jpg');
            }

            if (!empty($v['businessfile'])) {
                $objDrawing6[$k] = new \PHPExcel_Worksheet_Drawing();
                $objDrawing6[$k]->setPath(ROOT_PATH . $v['businessfile']);
                // 设置宽度高度
                $objDrawing6[$k]->setHeight(80);//照片高度
                $objDrawing6[$k]->setWidth(80); //照片宽度
                /*设置图片要插入的单元格*/
                $objDrawing6[$k]->setCoordinates('P' . $k);
                // 图片偏移距离
                $objDrawing6[$k]->setOffsetX(12);
                $objDrawing6[$k]->setOffsetY(12);
                $objDrawing6[$k]->setWorksheet($objPHPExcel->getActiveSheet());
                $tw->add_file(ROOT_PATH . $v['businessfile'], 'businessfile.jpg');
            }
            $goods = base64_decode($v['goodsnamearray']);
            $objActSheet->setCellValue('Q' . $k, $goods);
            // 表格高度
            $objActSheet->getRowDimension($k)->setRowHeight(80);

        }
        $fileName = '商标信息';
        $date = date("Y-m-d", time());
        $fileName .= "_{$date}.xls";
        $fileName = iconv("utf-8", "gb2312", $fileName);
        //重命名表
        // $objPHPExcel->getActiveSheet()->setTitle('test');
        //设置活动单指数到第一个表,所以Excel打开这是第一个表
        $objPHPExcel->setActiveSheetIndex(0);
        header('Content-Type: application/octet-stream');
        header("Content-Disposition: attachment;filename=TMID_" . $id . ".tar");
        header('Cache-Control: max-age=0');
        $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');

        $objWriter->save(ROOT_PATH . "/Uploads/tmorders_down/" . $fileName); //文件通过浏览器下载
        $tw->add_file(ROOT_PATH . "/Uploads/tmorders_down/" . $fileName, $fileName);
        $tw->close();
        if (!file_exists($filename_tar)) {
            echo '';
            return;
        }
        @readfile($filename_tar);
        // END
    }

    private function send_notify($old, $template, $data, $user, $wx)
    {
        $email = new EmailMessage(4);
        $email->PostUser($user['id'], $template, $data, $user['email']);
        $applyer = M("tm_applyer")->where(['id' => $old['applyerid']])->find();
        if (!$applyer) {
            return;
        }
        if ($applyer['email'] != $user['email']) {
            $email->PostUser($user['id'], $template, $data, $applyer['email']);
        }
        $sms = new SmsMessage(2);
        $res = $sms->PostUser($user['id'], $template, $data, $applyer['receivephone']);
    }

    private function check_status($old, $new)
    {
        if ($old['status'] != $new['status']) {
            $userModel = D('Users');
            $user = $userModel->find($old['userid']);
            if (!$user) {
                return;
            }

            $data['cls'] = $old['cls'];
            $data['tm'] = $new['name'];
            $template = 'tm_status_change';
            if ($new['status'] == '待确认') {
                $template = 'tm_status_confirm';
                $data['reason'] = $new['auditmemo'];
            } else if ($new['status'] == '审核不通过') {
                $template = 'tm_status_no';
                $data['reason'] = $new['auditmemo'];
            } else if ($new['status'] == '商标被驳回') {
                $template = 'tm_status_back';
            } else if ($new['status'] == '商标部分驳回') {
                $template = 'tm_status_partback';
            } else {
                $data['status_old'] = $old['status'];
                $data['status_new'] = $new['status'];
            }
            $this->send_notify($old, $template, $data, $user, [
                'userid' => $user['id'],
                'title' => '商标名称：' . $new['name'],
                'type' => '商标注册状态变更',
                'new_status' => $new['status']
            ]);
        }
    }
    //批量跟新申请号
    public function batch(){
        $contents = I('post.contents', '');
        $contents = str_replace("\r\n","\n",$contents);
        $contents = str_replace("\r","\n",$contents);
        $contents = explode("\n", $contents);
        $final = [];

        foreach ($contents as $content) {
            if (strpos($content, '=')) {
                $result = explode('=', $content);
                array_push($final, $result);
            }
        }
        $sql = [];
        $ids = [0];
        if (!empty($final)) {
            foreach ($final as $item) {
                $sql[] = "update tm_orders set applynumber = $item[1],status = '已下发申请号' where id = $item[0]";
                array_push($ids, $item[0]);
            }
        }
        $sql = implode(';', $sql);

        $order_info_old = M('tm_orders')->where(['id' =>['in',$ids]])->select();
        $ids = [0];
        foreach( $order_info_old as $value )
        {
            if(!$value['applynumber']){
                $ids[] = $value['id'];
            }
        }

        $result = M()->execute($sql);
        if($result=== false){
            $this->ajaxError('更新数据失败');
        }
        //获取订单的详细信息
        $order_info = M('tm_orders')->where(['id' =>['in',$ids]])->select();


        if ($result !== false) {
            foreach ($order_info as $key => $item) {
                $this->check_status($order_info_old[$key], $item);
                AdminLog::SaveLog(AdminLog::tmeditorder, $item['id'], $item['status'], $item, UID); //存log
            }
        }

        $this->ajaxOK('更新数据成功');


    }

}