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;
}
}
