function sales_stats($start, $end) { $pwd_info = authority_judge(); if ($pwd_info['company_mgr']) { $platform_list = platform_list(); } $tidy_date = tidysql(); extract($tidy_date); //部门排行 if ($pwd_info['company_mgr'] || $pwd_info['statistic_part_mgr']) { $sql_role_ranklist = " GROUP BY platform "; $sales['role_ranklist'] = get_ranklist($sql_role_ranklist, 'role_ranklist', $start, $end); } //团队排行 if ($pwd_info['statistic_part_mgr']) { $sql_group_ranklist = " AND platform={$_SESSION['role_id']}"; } $sales['group_ranklist'] = get_ranklist($sql_group_ranklist, 'group_ranklist', $start, $end); //成交订单排行 if ($pwd_info['statistic_part_mgr']) { $sql_finish_order_ranklist = " AND platform={$_SESSION['role_id']} "; } elseif ($pwd_info['statistic_group_mgr']) { //$sql_finish_order_ranklist = " AND platform={$_SESSION['role_id']} AND group_id={$_SESSION['group_id']} "; $sql_finish_order_ranklist = " AND platform={$_SESSION['role_id']} AND group_id={$_SESSION['group_id']} GROUP BY admin_id "; } $sales['finish_order_ranklist'] = get_ranklist($sql_finish_order_ranklist, 'finish_order_ranklist', $start, $end); //个人排行 $sales['person_ranklist'] = get_ranklist($sql_person_ranklist, 'personal_ranklist', $start, $end); return $sales; }
$result = get_ranklist($sql_sub, 'group_ranklist', $date_start, $date_end); $key = 'group_name'; $value = 'final_amount'; break; case 'hide_ordersum_ranklist': $sql_sub = tidysql('sql_finish_order_ranklist'); $result = get_ranklist($sql_sub, 'finish_order_ranklist', $date_start, $date_end); if ($_REQUEST['company_mgr']) { $key = 'role_name'; } else { $key = 'admin_name'; } $value = 'num'; break; case 'hide_person_ranklist': $sql_sub = tidysql('sql_person_ranklist'); $result = get_ranklist($sql_sub, 'personal_ranklist', $date_start, $date_end); $key = 'admin_name'; $value = 'final_amount'; break; case 'hide_service_ranklist': $result = stats_service($date_start, $date_end); $key = 'user_name'; $value = 'num_service'; break; } $table = array(); $rank_count = ceil(count($result) / 10); $off_width = $rank_count >= 3 ? 282 * 3 : 282 * $rank_count; for ($j = 0; $j < $rank_count; $j++) { $table[$j] = '<table style="float:left;margin-right:12px;" width="264px">';