/** * 获取有效客服列表 */ function get_admin_tmp_list($role = 0) { $sql = 'SELECT user_name,user_id,group_id,role_id FROM ' . $GLOBALS['ecs']->table('admin_user') . ' WHERE status>0 AND stats>0'; if (!admin_priv('all', '', false) && $role && $_SESSION['role_id']) { $role_id = get_depart_role($_SESSION['role_id']); if (empty($role_id)) { $role_id = $_SESSION['role_id']; } $sql .= " AND role_id IN({$role_id})"; } else { if (!$role) { $role = SALE; } $sql .= ' AND role_id IN (' . $role . ') '; } $admin_list = $GLOBALS['db']->getAll($sql . ' ORDER BY convert(user_name using gbk) ASC'); return $admin_list; }
} elseif ($_REQUEST['act'] == 'personal_sales_stats') { $today = strtotime(date('Y-m-d 23:59:59', time())); // 今天 // 权限控制 $trans_role_list = ''; if (!admin_priv('all', '', false) && admin_priv('personal_trans-part_stats', '', false)) { if (admin_priv('salary_deal', '', false)) { $range = ' r.role_id IN (' . OFFLINE_SALE . ') AND a.stats>0 '; } else { $trans_role_list = implode(',', trans_part_list()); $range = "r.role_id IN ({$trans_role_list}) AND a.stats>0"; } } elseif (!admin_priv('all', '', false) && !admin_priv('finance', '', false)) { if (admin_priv('personal_part_stats', '', false)) { $admin_list = get_admin_tmp_list($_SESSION['role_id']); $trans_role_list = get_depart_role($_SESSION['role_id']); $range = " r.role_id IN({$trans_role_list}) AND a.stats>0"; //$group_list = get_group_list($_SESSION['role_id']); $smarty->assign('group_list', $group_list); } elseif (admin_priv('personal_group_stats', '', false)) { $range = " a.group_id={$_SESSION['group_id']} AND a.stats=1 "; $group_list = get_admin_list_by_group($_SESSION['group_id']); } else { $range = " a.user_id={$_SESSION['admin_id']} "; } } else { //if ($_SESSION['role_id']) { // //$role_id = implode(',', trans_part_list()); // //$r_str = return_role_by_all(); // $range = ' r.role_id IN ('.$role_id.') AND a.stats>0 '; //}else{