示例#1
0
 function export()
 {
     $map = $this->_search();
     if (method_exists($this, '_filter')) {
         $this->_filter($map);
     }
     $EmployeeNewspaper = D('EmployeeNewspaper');
     $EmployeeId = get_employeeid($_SESSION[C('USER_AUTH_KEY')]);
     $MagazineList = $EmployeeNewspaper->getEmployeeNespapers($EmployeeId);
     $MagazinePostCodes;
     foreach ($MagazineList as $vo) {
         $MagazinePostCodes .= $vo['postCode'] . ',';
     }
     $MagazinePostCodes = substr($MagazinePostCodes, 0, strlen($MagazinePostCodes) - 1);
     if ($MagazinePostCodes) {
         $map['postCode'] = array('in', $MagazinePostCodes);
     }
     if (method_exists($this, '_filter')) {
         $this->_filter($map);
     }
     $model = D('OrderBase');
     if (!empty($model)) {
         $count = $model->where($map)->count('id');
         if ($count > 0) {
             import("ORG.Util.Page");
             $EmployeeId = get_employeeid($_SESSION[C('USER_AUTH_KEY')]);
             $EmployeeNewspaper = D('EmployeeNewspaper');
             $MagazineList = $EmployeeNewspaper->getEmployeeNespapers($EmployeeId);
             $MagazinePostCodes;
             foreach ($MagazineList as $vo) {
                 $MagazinePostCodes .= $vo['postCode'] . ',';
             }
             $MagazinePostCodes = substr($MagazinePostCodes, 0, strlen($MagazinePostCodes) - 1);
             if ($MagazinePostCodes) {
                 $map['postCode'] = array('in', $MagazinePostCodes);
             }
             //创建分页对象
             if (!empty($_REQUEST['listRows'])) {
                 $listRows = $_REQUEST['listRows'];
             } else {
                 $listRows = '';
             }
             $p = new Page($count, $listRows);
             //分页查询数据
             $order = 'insertTime desc, employeeID desc, recPeople desc, postCode desc ';
             $voList = $model->where($map)->order($order)->select();
             $FileName = date('Y-m-d') . "订单审核数据.xls";
             $FileName = iconv("UTF-8", "GBK", $FileName);
             header("Content-Type: application/vnd.ms-execl");
             header("Content-Disposition: attachment; filename= {$FileName}");
             header("Pragma: no-cache");
             header("Expires: 0");
             /*first line*/
             $HeaderStr = "日期" . "\t";
             $HeaderStr .= "批次" . "\t";
             $HeaderStr .= "业务经理" . "\t";
             $HeaderStr .= "客户名称" . "\t";
             $HeaderStr .= "收货人" . "\t";
             $HeaderStr .= "省份" . "\t";
             $HeaderStr .= "城市" . "\t";
             $HeaderStr .= "单位" . "\t";
             $HeaderStr .= "班级" . "\t";
             $HeaderStr .= "手机" . "\t";
             $HeaderStr .= "传真" . "\t";
             $HeaderStr .= "备用电话" . "\t";
             $HeaderStr .= "地址" . "\t";
             $HeaderStr .= "邮编" . "\t";
             $HeaderStr .= "报刊" . "\t";
             $HeaderStr .= "份数" . "\t";
             $HeaderStr .= "起月" . "\t";
             $HeaderStr .= "止月" . "\t";
             $HeaderStr .= "磁带数" . "\t";
             $HeaderStr .= "答案数" . "\t";
             $HeaderStr .= "是否薄弱县" . "\t";
             $HeaderStr .= "发货类型" . "\t";
             $HeaderStr .= "发货方式" . "\t";
             $HeaderStr .= "发货周期" . "\t";
             $HeaderStr .= "备注" . "\t";
             $HeaderStr .= "付款人" . "\t";
             $HeaderStr .= "保存时间" . "\t";
             $HeaderStr .= "提交时间" . "\t";
             $HeaderStr .= "是否审核" . "\t\n";
             $ContentStr = '';
             /*start of second line*/
             foreach ($voList as $vo) {
                 $ContentStr .= date('Y-m-d', $vo['orderTime']) . "\t";
                 $ContentStr .= $vo['batch'] . "\t";
                 $ContentStr .= get_employee_name($vo['employeeID']) . "\t";
                 $ContentStr .= get_custom_name($vo['customID']) . "\t";
                 $ContentStr .= $vo['recPeople'] . "\t";
                 $ContentStr .= get_province_name($vo['provinceID']) . "\t";
                 $ContentStr .= $vo['cityName'] . "\t";
                 $ContentStr .= get_custom_unit_name($vo['schoolID']) . "\t";
                 $ContentStr .= $vo['class'] . "\t";
                 $ContentStr .= $vo['recTelphone'] . "\t";
                 $ContentStr .= $vo['recFax'] . "\t";
                 $ContentStr .= $vo['recSpareTel'] . "\t";
                 $ContentStr .= $vo['recAddress'] . "\t";
                 $ContentStr .= $vo['zipCode'] . "\t";
                 $ContentStr .= get_magazine_name($vo['postCode']) . "\t";
                 $ContentStr .= $vo['orderNum'] . "\t";
                 $ContentStr .= $vo['beginOrderDate'] . "\t";
                 $ContentStr .= $vo['endOrderDate'] . "\t";
                 $ContentStr .= $vo['tapeNum'] . "\t";
                 $ContentStr .= $vo['answerNum'] . "\t";
                 $ContentStr .= $vo['weakCity'] . "\t";
                 $ContentStr .= get_send_goods_sort_name($vo['sendGoodsSortID']) . "\t";
                 $ContentStr .= get_send_goods_type_name($vo['sendGoodsTypeID']) . "\t";
                 $ContentStr .= get_send_order_cyle_name($vo['sendCyleID']) . "\t";
                 $ContentStr .= $vo['memo'] . "\t";
                 $ContentStr .= $vo['payPerson'] . "\t";
                 $ContentStr .= date('Y-m-d H:i:s', $vo['insertTime']) . "\t";
                 $ContentStr .= date('Y-m-d H:i:s', $vo['commitTime']) . "\t";
                 if ($vo['isChecked'] == 1) {
                     $ContentStr .= "是\t\n";
                 } else {
                     $ContentStr .= "否\t\n";
                 }
             }
             $HeaderStr = iconv("UTF-8", "GBK", $HeaderStr);
             $ContentStr = iconv("UTF-8", "GBK", $ContentStr);
             echo $HeaderStr . $ContentStr;
             exit;
         } else {
             //错误提示
             $this->error('没有数据!');
         }
     }
 }
示例#2
0
 function export()
 {
     $BeginDateTemp = '';
     $EndDateTemp = '';
     $SearchStr;
     $map = $this->_search();
     if (method_exists($this, '_filter')) {
         $this->_filter($map);
     }
     if ($_REQUEST['beginTime']) {
         $BeginDateTemp = strtotime($_REQUEST['beginTime']);
     }
     if ($_REQUEST['endTime']) {
         $EndDateTemp = strtotime($_REQUEST['endTime']);
     }
     $EmployeeNewspaper = D('EmployeeNewspaper');
     $EmployeeId = get_employeeid($_SESSION[C('USER_AUTH_KEY')]);
     $MagazineList = $EmployeeNewspaper->getEmployeeNespapers($EmployeeId);
     $MagazinePostCodes;
     foreach ($MagazineList as $vo) {
         $MagazinePostCodes .= $vo['postCode'] . ',';
     }
     $MagazinePostCodes = substr($MagazinePostCodes, 0, strlen($MagazinePostCodes) - 1);
     if ($MagazinePostCodes) {
         $map['postCode'] = array('in', $MagazinePostCodes);
     }
     if ($BeginDateTemp || $EndDateTemp) {
         if ($BeginDateTemp && $EndDateTemp) {
             $map['orderTime'] = array('between', "{$BeginDateTemp}, {$EndDateTemp}");
         } else {
             if ($BeginDateTemp) {
                 $map['orderTime'] = array('egt', $BeginDateTemp);
             } else {
                 $map['orderTime'] = array('elt', $EndDateTemp);
             }
         }
     }
     if (method_exists($this, '_filter')) {
         $this->_filter($map);
     }
     $model = D('OrderBase');
     if (!empty($model)) {
         $count = $model->where($map)->count('id');
         if ($count > 0) {
             import("ORG.Util.Page");
             $EmployeeId = get_employeeid($_SESSION[C('USER_AUTH_KEY')]);
             $EmployeeNewspaper = D('EmployeeNewspaper');
             $MagazineList = $EmployeeNewspaper->getEmployeeNespapers($EmployeeId);
             $MagazinePostCodes;
             foreach ($MagazineList as $vo) {
                 $MagazinePostCodes .= $vo['postCode'] . ',';
             }
             $MagazinePostCodes = substr($MagazinePostCodes, 0, strlen($MagazinePostCodes) - 1);
             if ($MagazinePostCodes) {
                 $map['postCode'] = array('in', $MagazinePostCodes);
             }
             $order = 'insertTime desc, employeeID desc, recPeople desc, postCode desc ';
             $voList = $model->where($map)->order($order)->select();
             $FileName = date('Y-m-d') . "订单派发数据.xls";
             $FileName = iconv("UTF-8", "GBK", $FileName);
             header("Content-Type: application/vnd.ms-execl");
             header("Content-Disposition: attachment; filename= {$FileName}");
             header("Pragma: no-cache");
             header("Expires: 0");
             /*first line*/
             $HeaderStr = "日期" . "\t";
             $HeaderStr .= "批次" . "\t";
             $HeaderStr .= "业务经理" . "\t";
             $HeaderStr .= "客户名称" . "\t";
             $HeaderStr .= "收货人" . "\t";
             $HeaderStr .= "省份" . "\t";
             $HeaderStr .= "城市" . "\t";
             $HeaderStr .= "单位" . "\t";
             $HeaderStr .= "班级" . "\t";
             $HeaderStr .= "手机" . "\t";
             $HeaderStr .= "地址" . "\t";
             $HeaderStr .= "报刊" . "\t";
             $HeaderStr .= "份数" . "\t";
             $HeaderStr .= "起月" . "\t";
             $HeaderStr .= "止月" . "\t";
             $HeaderStr .= "发货类型" . "\t";
             $HeaderStr .= "发货方式" . "\t";
             $HeaderStr .= "发货周期" . "\t";
             $HeaderStr .= "付款人" . "\t";
             $HeaderStr .= "是否派发" . "\t";
             $HeaderStr .= "派发时间" . "\t\n";
             $ContentStr = '';
             /*start of second line*/
             foreach ($voList as $vo) {
                 $ContentStr .= date('Y-m-d', $vo['orderTime']) . "\t";
                 $ContentStr .= $vo['batch'] . "\t";
                 $ContentStr .= get_employee_name($vo['employeeID']) . "\t";
                 $ContentStr .= get_custom_name($vo['customID']) . "\t";
                 $ContentStr .= $vo['recPeople'] . "\t";
                 $ContentStr .= get_province_name($vo['provinceID']) . "\t";
                 $ContentStr .= $vo['cityName'] . "\t";
                 $ContentStr .= get_custom_unit_name($vo['schoolID']) . "\t";
                 $ContentStr .= $vo['class'] . "\t";
                 $ContentStr .= $vo['recTelphone'] . "\t";
                 $ContentStr .= $vo['recAddress'] . "\t";
                 $ContentStr .= get_magazine_name($vo['postCode']) . "\t";
                 $ContentStr .= $vo['orderNum'] . "\t";
                 $ContentStr .= $vo['beginOrderDate'] . "\t";
                 $ContentStr .= $vo['endOrderDate'] . "\t";
                 $ContentStr .= get_send_goods_sort_name($vo['sendGoodsSortID']) . "\t";
                 $ContentStr .= get_send_goods_type_name($vo['sendGoodsTypeID']) . "\t";
                 $ContentStr .= get_send_order_cyle_name($vo['sendCyleID']) . "\t";
                 $ContentStr .= $vo['payPerson'] . "\t";
                 if ($vo['isSend']) {
                     $ContentStr .= "是\t";
                 } else {
                     $ContentStr .= "否\t";
                 }
                 if ($vo['sendTime']) {
                     $ContentStr .= date('Y-m-d', $vo['sendTime']) . "\t\n";
                 } else {
                     $ContentStr .= " \t\n";
                 }
             }
             $HeaderStr = iconv("UTF-8", "GBK", $HeaderStr);
             $ContentStr = iconv("UTF-8", "GBK", $ContentStr);
             echo $HeaderStr . $ContentStr;
             exit;
         } else {
             //错误提示
             $this->error('没有数据!');
         }
     }
 }
示例#3
0
 public function export()
 {
     $BeginDateTemp = '';
     $EndDateTemp = '';
     $map = $this->_search();
     if (method_exists($this, '_filter')) {
         $this->_filter($map);
     }
     if ($_REQUEST['beginTime']) {
         $BeginDateTemp = strtotime($_REQUEST['beginTime']);
     }
     if ($_REQUEST['endTime']) {
         $EndDateTemp = strtotime($_REQUEST['endTime']);
     }
     if ($BeginDateTemp || $EndDateTemp) {
         if ($BeginDateTemp && $EndDateTemp) {
             $map['orderTime'] = array('between', "{$BeginDateTemp}, {$EndDateTemp}");
         } else {
             if ($BeginDateTemp) {
                 $map['orderTime'] = array('egt', $BeginDateTemp);
             } else {
                 $map['orderTime'] = array('elt', $EndDateTemp);
             }
         }
     }
     $model = D('OrderBase');
     if (!empty($model)) {
         /* 查询自己的信息 */
         $EmployeeId = get_employeeid($_SESSION[C('USER_AUTH_KEY')]);
         $roleEname = get_role_ename($_SESSION[C('USER_AUTH_KEY')]);
         if ($roleEname != 'admin') {
             $map['employeeID'] = $EmployeeId;
         }
         $count = $model->where($map)->count('id');
         if ($count > 0) {
             import("ORG.Util.Page");
             $order = 'isChecked asc, insertTime desc';
             $voList = $model->where($map)->order($order)->select();
             $FileName = date('Y-m-d') . "订单数据.xls";
             $FileName = iconv("UTF-8", "GBK", $FileName);
             header("Content-Type: application/vnd.ms-execl");
             header("Content-Disposition: attachment; filename= {$FileName}");
             header("Pragma: no-cache");
             header("Expires: 0");
             /*first line*/
             $HeaderStr = "日期" . "\t";
             $HeaderStr .= "客户" . "\t";
             $HeaderStr .= "批次" . "\t";
             $HeaderStr .= "收货人" . "\t";
             $HeaderStr .= "手机" . "\t";
             $HeaderStr .= "地址" . "\t";
             $HeaderStr .= "报刊分类" . "\t";
             $HeaderStr .= "报刊" . "\t";
             $HeaderStr .= "份数" . "\t";
             $HeaderStr .= "起月" . "\t";
             $HeaderStr .= "止月" . "\t";
             $HeaderStr .= "付款方式" . "\t";
             $HeaderStr .= "发货周期" . "\t";
             $HeaderStr .= "发货类型" . "\t";
             $HeaderStr .= "发货方式" . "\t";
             $HeaderStr .= "邮编" . "\t";
             $HeaderStr .= "省份" . "\t";
             $HeaderStr .= "城市" . "\t";
             $HeaderStr .= "单位" . "\t";
             $HeaderStr .= "班级" . "\t";
             $HeaderStr .= "付款人" . "\t";
             $HeaderStr .= "是否单期" . "\t";
             $HeaderStr .= "期数名称" . "\t";
             $HeaderStr .= "是否审核" . "\t";
             $HeaderStr .= "备注" . "\t\n";
             $ContentStr = '';
             /*start of second line*/
             foreach ($voList as $vo) {
                 $ContentStr .= date('Y-m-d', $vo['orderTime']) . "\t";
                 $ContentStr .= get_custom_name($vo['customID']) . "\t";
                 $ContentStr .= $vo['batch'] . "\t";
                 $ContentStr .= $vo['recPeople'] . "\t";
                 $ContentStr .= $vo['recTelphone'] . "\t";
                 $ContentStr .= $vo['recAddress'] . "\t";
                 $ContentStr .= get_magazine_type_name_by_postcode($vo['postCode']) . "\t";
                 $ContentStr .= get_magazine_name($vo['postCode']) . "\t";
                 $ContentStr .= $vo['orderNum'] . "\t";
                 $ContentStr .= $vo['beginOrderDate'] . "\t";
                 $ContentStr .= $vo['endOrderDate'] . "\t";
                 $ContentStr .= get_pay_type_name($vo['payType']) . "\t";
                 $ContentStr .= get_pay_type_name($vo['payType']) . "\t";
                 $ContentStr .= get_send_order_cyle_name($vo['sendCyleID']) . "\t";
                 $ContentStr .= get_send_goods_sort_name($vo['sendGoodsSortID']) . "\t";
                 $ContentStr .= get_send_goods_type_name($vo['sendGoodsTypeID']) . "\t";
                 $ContentStr .= $vo['zipCode'] . "\t";
                 $ContentStr .= $vo['cityName'] . "\t";
                 $ContentStr .= get_custom_unit_name($vo['schoolID']) . "\t";
                 $ContentStr .= $vo['class'] . "\t";
                 $ContentStr .= $vo['payPerson'] . "\t";
                 if ($vo['isSingle'] == 1) {
                     $ContentStr .= "是\t";
                 } else {
                     $ContentStr .= "否\t";
                 }
                 if ($vo['isSingle'] == 1) {
                     $ContentStr .= get_magazine_terrm_name($vo['termID']) . "\t";
                 } else {
                     $ContentStr .= "\t";
                 }
                 if ($vo['isChecked'] == 2) {
                     $ContentStr .= "未提交\t";
                 } else {
                     if ($vo['isChecked'] == 1) {
                         $ContentStr .= "已审核\t";
                     } else {
                         if ($vo['isChecked'] == 0) {
                             $ContentStr .= "未审核\t";
                         }
                     }
                 }
                 $ContentStr .= $vo['memo'] . "\t\n";
             }
             $HeaderStr = iconv("UTF-8", "GBK", $HeaderStr);
             $ContentStr = iconv("UTF-8", "GBK", $ContentStr);
             echo $HeaderStr . $ContentStr;
             exit;
         } else {
             //错误提示
             $this->error('没有数据!');
         }
     }
 }
示例#4
0
 public function doConvert()
 {
     $OrderBase = M('OrderBase');
     $id = $_REQUEST[$OrderBase->getPk()];
     if ($id) {
         $vo = $OrderBase->find($id);
         if ($vo['isTrans']) {
             $this->error('该订单已经转换过了,不能重复转换!');
         }
         $MagazineTerrm = M('MagazineTerrm');
         $OrderFlowDetails = M('OrderFlowDetails');
         $Data['orderID'] = $vo['id'];
         $Data['insertPerson'] = get_employeeid($_SESSION[C('USER_AUTH_KEY')]);
         $Data['insertTime'] = time();
         $Data['quantity'] = $vo['orderNum'];
         if ($vo['sendGoodsSortID']) {
             $Data['sendSort'] = get_send_goods_sort_name($vo['sendGoodsSortID']);
         }
         if ($vo['isSingle']) {
             $TermList = $MagazineTerrm->where('id = ' . $vo['termID'])->select();
             if ($TermList) {
                 $Data['termID'] = $TermList[0]['id'];
             }
         } else {
             $map['year'] = $vo['orderYear'];
             if ($vo['beginOrderDate'] && $vo['endOrderDate']) {
                 $map['month'] = array('between', array($vo['beginOrderDate'], $vo['endOrderDate']));
             } else {
                 if ($vo['beginOrderDate']) {
                     $map['month'] = $vo['beginOrderDate'];
                 } else {
                     if ($vo['endOrderDate']) {
                         $map['month'] = $vo['endOrderDate'];
                     } else {
                         $this->error('订单中没有开始月份或结束月份,请设置!');
                     }
                 }
             }
             $map['postCode'] = $vo['postCode'];
             $TermList = $MagazineTerrm->where($map)->field('id, name')->select();
             if ($TermList) {
                 foreach ($TermList as $TermVo) {
                     $TermId[$TermVo['id']] = $TermVo['name'];
                 }
                 asort($TermId);
                 $BeginTermId;
                 $EndTermId;
                 $i = 1;
                 foreach ($TermId as $key => $value) {
                     if ($i == 1) {
                         $BeginTermId = $key;
                     }
                     $i++;
                 }
                 $EndTermId = $key;
                 $Data['beginTermID'] = $BeginTermId;
                 $Data['endTermID'] = $EndTermId;
             }
         }
         if ($TermList) {
             foreach ($TermList as $termVo) {
                 $Data['termID'] = $termVo['id'];
                 $OrderFlowDetails->add($Data);
             }
             unset($Data);
             $Data['id'] = $id;
             $Data['isTrans'] = '1';
             $Data['orderStatus'] = '待分配';
             $OrderBase->data($Data)->save();
             /* 添加发货信息 */
             $this->PostGoodsAdd($vo['id']);
             $this->success('转换成功!');
         } else {
             $this->error('没有数据!');
         }
     } else {
         $this->error('转换失败!');
     }
 }