private function indexSearchList() { /* 获取用户的部门ID */ $EmployeeId = get_employeeid($_SESSION[C('USER_AUTH_KEY')]); $roleEname = get_role_ename($_SESSION[C('USER_AUTH_KEY')]); /* 业务经理报刊信息列表 */ $Magazine = D("Magazine"); if ($roleEname == 'businessManager') { $MagazineList = $Magazine->getMagazineListByEmId($EmployeeId); } else { $MagazineList = $Magazine->field('postCode, name')->select(); } $this->assign('MagazineList', $MagazineList); /* 客户信息 */ $Custom = M('Custom'); $map = array(); $CustomList = $Custom->where($map)->field('id, name')->select(); $this->assign('CustomList', $CustomList); unset($map); /* 报刊来源 */ $MagazineOrigin = M('MagazineOrigin'); $MagazineOriginList = $MagazineOrigin->field('id, name')->select(); $this->assign('MagazineOriginList', $MagazineOriginList); /* 发行员 */ $User = D('User'); $PostPeopleList = $User->getUserByDutyName('物流部发行员'); $this->assign('PostPeopleList', $PostPeopleList); /* 省份信息 */ $Province = M("Province"); $ProvinceList = $Province->field('id, name')->select(); $this->assign('ProvinceList', $ProvinceList); }
public function index() { $SearchSql = ''; $BeginDateTemp = ''; $EndDateTemp = ''; $EmployeeNewspaper = D('EmployeeNewspaper'); $Magazine = D('Magazine'); $EmployeeId = get_employeeid($_SESSION[C('USER_AUTH_KEY')]); $roleEname = get_role_ename($_SESSION[C('USER_AUTH_KEY')]); if ($roleEname != 'admin') { $MagazineList = $EmployeeNewspaper->getEmployeeNespapers($EmployeeId); } else { $MagazineList = $Magazine->field('postCode, name')->select(); } $this->assign('MagazineList', $MagazineList); $this->searchMap($map, $SearchSql); $this->assign('SearchSql', $SearchSql); if ($map) { if ($roleEname == "businessManager") { $map['order_base.employeeID'] = $EmployeeId; } } $model = D('OrderBase'); if (!empty($model) && !empty($map)) { $this->_list($model, $map); } $this->display(); return; }
public function before_index() { $Department = M("Department"); $Departmentlist = $Department->field('id, name')->select(); $this->assign('Departmentlist', $Departmentlist); $roleEname = get_role_ename($_SESSION[C('USER_AUTH_KEY')]); $this->assign('roleEname', $roleEname); }
public function before_index() { $roleEname = get_role_ename($_SESSION[C('USER_AUTH_KEY')]); $this->assign('roleEname', $roleEname); $User = D('User'); $businessManagerList = $User->getUserByRoleName('businessManager'); $this->assign('businessManagerList', $businessManagerList); }
public function before_index() { $Area = M("Area"); $AreaList = $Area->field('id, name')->select(); $roleEname = get_role_ename($_SESSION[C('USER_AUTH_KEY')]); $this->assign('roleEname', $roleEname); $this->assign('AreaList', $AreaList); }
private function listFilter(&$map) { $roleEname = get_role_ename($_SESSION[C('USER_AUTH_KEY')]); if ($roleEname != 'admin') { $map['magazine.status'] = array('neq', -1); $map['employee_newspaper.personID'] = get_employeeid($_SESSION[C('USER_AUTH_KEY')]); } }
public function before_index() { $Area = M("Area"); $AreaList = $Area->field('id, name')->select(); $ProvinceList = array(); if ($_REQUEST['areaID']) { $Province = M("Province"); $ProvinceList = $Province->where('areaID = ' . $_REQUEST['areaID'])->field('id, name')->select(); } $roleEname = get_role_ename($_SESSION[C('USER_AUTH_KEY')]); $this->assign('roleEname', $roleEname); $this->assign('AreaList', $AreaList); $this->assign('ProvinceList', $ProvinceList); }
protected function _list($model, $map, $sortBy = '', $asc = false) { //取得满足条件的记录数 $EmployeeID = get_employeeid($_SESSION[C('USER_AUTH_KEY')]); $roleEname = get_role_ename($_SESSION[C('USER_AUTH_KEY')]); if ($roleEname == 'customCenterWorker') { $map['sendNameID'] = $EmployeeID; $map['receiveNameID'] = $EmployeeID; $map['isValidate'] = '1'; $map['_logic'] = 'or'; //$map['isValidate'] = array( // 'eq', // '1' // ); } else { $map['sendNameID'] = $EmployeeID; $map['_string'] = '(isValidate=1 and validateStatus=1 and receiveNameID="' . $EmployeeID . '" ) or (isValidate=0 and receiveNameID="' . $EmployeeID . '" ) '; $map['_logic'] = 'or'; } $count = $model->table(array('tb_messageinfo' => 'message'))->where($map)->count('message.id'); if ($count > 0) { import("ORG.Util.Page"); //创建分页对象 if (!empty($_REQUEST['listRows'])) { $listRows = $_REQUEST['listRows']; } else { $listRows = ''; } $p = new Page($count, $listRows); //分页查询数据 $fieldStr = 'id, sendNameID, receiveNameID, sendDate, sendContent, isValidate, validateDate, validateStatus, validateNameID, replayDate, replayStatus, replayContent'; $orderStr = 'sendDate desc'; $voList = $model->table(array('tb_messageinfo' => 'message'))->where($map)->order($orderStr)->limit($p->firstRow . ',' . $p->listRows)->field($fieldStr)->select(); //分页显示 $page = $p->show(); //模板赋值显示 $this->assign('list', $voList); $this->assign("page", $page); } $this->assign('totalCount', $count); $this->assign('numPerPage', C('PAGE_LISTROWS')); $this->assign('currentPage', !empty($_REQUEST[C('VAR_PAGE')]) ? $_REQUEST[C('VAR_PAGE')] : 1); Cookie::set('_currentUrl_', __SELF__); return; }
private function listFilter(&$map) { $roleEname = get_role_ename($_SESSION[C('USER_AUTH_KEY')]); /** * 系统管理员可以查看客户信息和管理客户信息 * 物流质检员可以查看客户信息,只能修改自己的客户信息 * 业务经理只能看自己的信息和修改自己的客户信息 * 其他按照可以看自己的信息和修改自己的客户信息 */ if ($roleEname == 'businessManager') { $map['custom.employeeID'] = get_employeeid($_SESSION[C('USER_AUTH_KEY')]); } else { } $roleEname = get_role_ename($_SESSION[C('USER_AUTH_KEY')]); if ($roleEname != 'admin') { $map['custom.status'] = array('neq', -1); } }
private function canUpdate($CustomId) { if (empty($CustomId)) { return false; } $Custom = D('Custom'); $customEmployeeID = $Custom->where('id = ' . $CustomId)->getField('employeeID'); $EmployeeID = get_employeeid($_SESSION[C('USER_AUTH_KEY')]); $roleEname = get_role_ename($_SESSION[C('USER_AUTH_KEY')]); /** * 系统管理员可以查看客户信息和管理客户信息 * 物流质检员可以查看客户信息,只能修改自己的客户信息 * 业务经理只能看自己的信息和修改自己的客户信息 * 其他按照可以看自己的信息和修改自己的客户信息 */ if ($_SESSION[C('USER_AUTH_KEY')] == 1) { return true; } else { if ($EmployeeID == $customEmployeeID) { return true; } } return false; }
private function listFilter(&$map) { /* 获取用户的部门ID */ $EmployeeId = get_employeeid($_SESSION[C('USER_AUTH_KEY')]); $roleEname = get_role_ename($_SESSION[C('USER_AUTH_KEY')]); if ($roleEname == 'businessManager') { $map['order_base.employeeID'] = $EmployeeId; } else { if (isset($_REQUEST['employeeID']) && !empty($_REQUEST['employeeID'])) { $map['order_base.employeeID'] = $_REQUEST['employeeID']; } } $map['employee_newspaper.personID'] = $EmployeeId; }
public function before_index() { $roleEname = get_role_ename($_SESSION[C('USER_AUTH_KEY')]); $this->assign('roleEname', $roleEname); }
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('没有数据!'); } } }
private function listFilter(&$map) { /* 获取用户的部门ID */ $EmployeeId = get_employeeid($_SESSION[C('USER_AUTH_KEY')]); $roleEname = get_role_ename($_SESSION[C('USER_AUTH_KEY')]); if ($roleEname == 'admin') { /* */ } else { /* 获取用户负责的报刊列表 */ $EmployeeNewspaper = D('EmployeeNewspaper'); $MagazineList = $EmployeeNewspaper->getEmployeeNespapers($EmployeeId); if ($MagazineList) { foreach ($MagazineList as $vo) { $MagazinePostCodes .= $vo['postCode'] . ','; } $MagazinePostCodes = substr($MagazinePostCodes, 0, strlen($MagazinePostCodes) - 1); if ($MagazinePostCodes) { if (!$map['order_base.postCode']) { $map['order_base.postCode'] = array('in', $MagazinePostCodes); } } } } }
private function roleMainShow() { $roleEname = get_role_ename($_SESSION[C('USER_AUTH_KEY')]); $employeeId = get_employeeid($_SESSION[C('USER_AUTH_KEY')]); $this->assign('roleEname', $roleEname); if ($roleEname == "customCenterWorker") { $OrderBase = D('OrderBase'); $List = array(); $postCodeNameList = $OrderBase->table(array('tb_order_base' => 'order_base'))->join('tb_magazine magazine on magazine.postCode = order_base.postCode')->join('tb_employee_newspaper employee_newspaper on employee_newspaper.postCode = order_base.postCode')->Distinct('order_base.postCode')->field('magazine.postCode, magazine.name')->where("employee_newspaper.personID = '" . get_employeeid($_SESSION[C('USER_AUTH_KEY')]) . "'")->order('employee_newspaper.operatingFrequency desc')->select(); foreach ($postCodeNameList as $key => $vo) { $List[$key]['postCodeName'] = $vo['name']; $map['postCode'] = $vo['postCode']; $List[$key]['orderNum'] = $OrderBase->where($map)->Distinct('contractID')->count('contractID'); unset($map); $map['postCode'] = $vo['postCode']; $map['isChecked'] = array('eq', '0'); $List[$key]['sumUnChecked'] = $OrderBase->where($map)->Distinct('contractID')->count('contractID'); unset($map); $map['postCode'] = $vo['postCode']; $map['isChecked'] = array('eq', '1'); $List[$key]['sumChecked'] = $OrderBase->where($map)->Distinct('contractID')->count('contractID'); unset($map); $map['postCode'] = $vo['postCode']; $map['isSend'] = array('eq', '0'); $List[$key]['sumUnSend'] = $OrderBase->where($map)->Distinct('contractID')->count('contractID'); unset($map); $map['postCode'] = $vo['postCode']; $map['isSend'] = array('eq', '1'); $List[$key]['sumSend'] = $OrderBase->where($map)->Distinct('contractID')->count('contractID'); unset($map); } $this->assign('List', $List); } else { if ($roleEname == 'logisticsAssigner') { $OrderBase = D('OrderBase'); $List = array(); $postCodeNameList = $OrderBase->table(array('tb_order_base' => 'order_base'))->join('tb_magazine magazine on magazine.postCode = order_base.postCode')->join('tb_employee_newspaper employee_newspaper on employee_newspaper.postCode = order_base.postCode')->Distinct('order_base.postCode')->field('magazine.postCode, magazine.name')->where("employee_newspaper.personID = '" . get_employeeid($_SESSION[C('USER_AUTH_KEY')]) . "'")->order('employee_newspaper.operatingFrequency desc')->select(); foreach ($postCodeNameList as $key => $vo) { $List[$key]['postCodeName'] = $vo['name']; $map['postCode'] = $vo['postCode']; $map['isReceive'] = array('eq', '1'); $List[$key]['sumReceive'] = $OrderBase->where($map)->Distinct('contractID')->count('contractID'); unset($map); $map['postCode'] = $vo['postCode']; $map['isReceive'] = array('eq', '0'); $List[$key]['sumUnReceive'] = $OrderBase->where($map)->Distinct('contractID')->count('contractID'); unset($map); $map['postCode'] = $vo['postCode']; $map['isTrans'] = array('eq', '1'); $List[$key]['sumTrans'] = $OrderBase->where($map)->Distinct('contractID')->count('contractID'); unset($map); $map['postCode'] = $vo['postCode']; $map['isTrans'] = array('eq', '0'); $List[$key]['sumUnTrans'] = $OrderBase->where($map)->Distinct('contractID')->count('contractID'); unset($map); $PostGoods = D("PostGoods"); $map['order_base.postCode'] = $vo['postCode']; $map['post_goods.isCheckOut'] = array('eq', '1'); $List[$key]['sumCheckOut'] = $PostGoods->table(array('tb_post_goods' => 'post_goods'))->join('tb_order_flow_details order_flow_details on order_flow_details.id = post_goods.orderFlowID')->join('tb_order_base order_base on order_base.id = order_flow_details.orderID')->where($map)->count('post_goods.id'); unset($map); $PostGoods = D("PostGoods"); $map['order_base.postCode'] = $vo['postCode']; $map['post_goods.isCheckOut'] = array('eq', '0'); $List[$key]['sumUnCheckOut'] = $PostGoods->table(array('tb_post_goods' => 'post_goods'))->join('tb_order_flow_details order_flow_details on order_flow_details.id = post_goods.orderFlowID')->join('tb_order_base order_base on order_base.id = order_flow_details.orderID')->where($map)->count('post_goods.id'); unset($map); unset($map); } $this->assign('List', $List); } else { if ($roleEname == 'businessManager') { import("LibChart"); $Magazine = D('Magazine'); $OrderBase = D('OrderBase'); $List = array(); $year = date('Y'); $month = date('m'); $map = array(); $MagazineList = $Magazine->getMagazineListByEmId($employeeId); $MagazineCount = 0; $monthAdd = $month + 1; if ($MagazineList) { foreach ($MagazineList as $key => $MagazineVo) { /* 单期订单的数量 */ $orderSingleNum = 0; /* 多期订单的数量 */ $orderMonthNum = 0; /** * 算法:通过查找判断单期中的订单是否在 本月内 统计其数量 某一报刊 某一个人 */ $map['postCode'] = $MagazineVo['postCode']; $map['employeeID'] = $employeeId; $map['isSingle'] = 1; $map['orderYear'] = $year; $map['orderTime'] = array('between', strtotime("{$year}-{$month}-1 00:00:00") . ',' . strtotime("{$year}-{$monthAdd}-1 00:00:00")); $orderSingleNum = $OrderBase->where($map)->sum('orderNum'); unset($map); if (empty($orderSingleNum)) { $orderSingleNum = 0; } $map['orderYear'] = $year; $map['orderTime'] = array('between', strtotime("{$year}-{$month}-1 00:00:00") . ',' . strtotime("{$year}-{$monthAdd}-1 00:00:00")); $map['postCode'] = $MagazineVo['postCode']; $map['employeeID'] = $employeeId; $orderNumList = $OrderBase->where($map)->field('beginOrderDate, endOrderDate, orderNum')->select(); unset($map); if ($orderNumList) { foreach ($orderNumList as $orderNumVo) { $intervalMonths = $orderNumVo['endOrderDate'] - $orderNumVo['beginOrderDate'] + 1; $orderMonthNum += $orderNumVo['orderNum'] * $intervalMonths; } } $MagazineNum = $orderMonthNum + $orderSingleNum; $MagazineName = $MagazineVo['name']; if (empty($MagazineNum) || $MagazineNum == 0) { continue; } else { $List[$MagazineCount]['MagazineName'] = $MagazineName; $List[$MagazineCount]['MagazineNum'] = $MagazineNum; $MagazineCount++; } } $chart = new VerticalBarChart(600, 300); $dataSet = new XYDataSet(); $index = 1; $picUrlPath = array(); foreach ($List as $key => $vo) { /* 每行显示10个报刊,多余10个报刊,显示下一个图片 */ if ($key % 10 == 0 && $key != 0) { $chart->setDataSet($dataSet); $chart->setTitle("当月报刊的销售情况:"); $chart->render("./Public/Generated/" . $roleEname . "_" . $EmployeeId . "_" . $index . ".png"); $picUrlPath[] = "__PUBLIC__/Generated/" . $roleEname . "_" . $EmployeeId . "_" . $index . ".png"; $dataSet = new XYDataSet(); $index++; } $dataSet->addPoint(new Point($vo['MagazineName'], $vo['MagazineNum'])); } $chart->setDataSet($dataSet); $chart->setTitle("当月报刊的销售情况:"); $chart->render("./Public/Generated/" . $roleEname . "_" . $EmployeeId . "_" . $index . ".png"); $picUrlPath[] = "__PUBLIC__/Generated/" . $roleEname . "_" . $EmployeeId . "_" . $index . ".png"; $this->assign('picUrlPath', $picUrlPath); /* 只保存没提交的订单的数量 */ unset($map); $map['isChecked'] = 2; $map['employeeID'] = $employeeId; $orderSaveNotCommitNum = $OrderBase->where($map)->sum('orderNum'); $this->assign('orderSaveNotCommitNum', $orderSaveNotCommitNum); } } } } }
private function listFilter(&$map) { /* 获取用户的部门ID */ $EmployeeId = get_employeeid($_SESSION[C('USER_AUTH_KEY')]); $roleEname = get_role_ename($_SESSION[C('USER_AUTH_KEY')]); if ($roleEname == 'businessManager') { $map['order_base.employeeID'] = $EmployeeId; } }