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());
