function tidysql($sql_ranklist_name = '') { $admin_id = $_SESSION['admin_id']; $group_id = $_SESSION['group_id']; $role_id = $_SESSION['role_id']; $tidy_date = array(); $pwd_info = authority_judge(); if ($pwd_info['company_mgr']) { $tidy_date['sql_person_ranklist'] = " GROUP BY admin_id {$order_by}"; $tidy_date['sql_group_ranklist'] = " AND group_id<>0 GROUP BY group_id"; $tidy_date['sql_finish_order_ranklist'] = ' GROUP BY platform ORDER BY num DESC'; $_REQUEST['company_mgr'] = true; } elseif ($pwd_info['statistic_part_mgr']) { $role_id_str = get_role_str(); $tidy_date['sql_person_ranklist'] = $role_id_str ? " AND platform IN({$role_id_str}) GROUP BY admin_id " : " AND platform={$role_id} GROUP BY admin_id"; $tidy_date['sql_group_ranklist'] = $role_id_str ? " AND platform IN({$role_id_str}) GROUP BY group_id " : " AND platform={$role_id} GROUP BY group_id"; $tidy_date['sql_finish_order_ranklist'] = ' GROUP BY admin_id ORDER BY num DESC'; } else { //$tidy_date['sql_person_ranklist'] = " AND group_id=$group_id GROUP BY admin_id "; //$tidy_date['sql_group_ranklist'] = " AND group_id=$group_id GROUP BY group_id "; //$tidy_date['sql_finish_order_ranklist'] = " AND group_id=$group_id GROUP BY admin_id ORDER BY num DESC"; $tidy_date['sql_person_ranklist'] = " AND platform={$role_id} GROUP BY admin_id "; $tidy_date['sql_group_ranklist'] = " AND platform={$role_id} GROUP BY group_id "; $tidy_date['sql_finish_order_ranklist'] = " AND platform={$role_id} GROUP BY admin_id ORDER BY num DESC"; } $tidy_date['sql_role_ranklist'] = " GROUP BY platform "; if ($sql_ranklist_name != '') { return $tidy_date[$sql_ranklist_name]; } else { return $tidy_date; } }
$nav = list_nav(); $smarty->assign('nav_1st', $nav[0]); $smarty->assign('nav_2nd', $nav[1]); $smarty->assign('nav_3rd', $nav[2]); if (!admin_priv('everyone_sales', '', false)) { $role_id = $_SESSION['role_id']; } else { $role_id = OFFLINE_SALE; } $hello = "<b>{$_SESSION['admin_name']}</b>"; $smarty->assign('hello', $hello); /*电话销售或会员部 预约提醒*/ if ($_SESSION['role_id'] == 1 || $_SESSION['role_id'] == 9) { $smarty->assign('appointments', 'appointments'); } $authority_judge = authority_judge(); //首页信息显示 if (empty($authority_judge['ordinary_employee'])) { $stock_alarm = get_index_alarm_stock(); //库存警报 $stats_info = get_nature_stats(); //销售情况 $public_notice = public_notice(); $pwd_info = $stats_info['pwd_info']; $smarty->assign('pwd_info', $stats_info['pwd_info']); $smarty->assign('stats_info', $stats_info); //销量排行 $smarty->assign('public_notice', $public_notice); //公告 //$smarty->assign('commemoration_list',get_commemoration()); //顾客记念日 $smarty->assign('sale_alarm_list', get_sale_alarm_list());