Example #1
0
    $smarty->assign('user_orderinfo', $user_orderinfo['user_orderinfo']);
    $sort_flag = sort_flag($user_orderinfo['filter']);
    $smarty->assign($sort_flag['tag'], $sort_flag['img']);
    make_json_result($smarty->fetch('users_order.htm'), '', array('filter' => $user_orderinfo['filter'], 'page_count' => $user_orderinfo['page_count']));
} else {
    /* 权限判断 */
    admin_priv('client_flow_stats');
    /* 时间参数 */
    if (!isset($_REQUEST['start_date'])) {
        $start_date = local_strtotime('-7 days');
    }
    if (!isset($_REQUEST['end_date'])) {
        $end_date = local_strtotime('today');
    }
    /* 取得会员排行数据 */
    $user_orderinfo = get_user_orderinfo();
    /* 赋值到模板 */
    $smarty->assign('ur_here', $_LANG['report_users']);
    $smarty->assign('action_link', array('text' => $_LANG['download_amount_sort'], 'href' => '#download'));
    $smarty->assign('filter', $user_orderinfo['filter']);
    $smarty->assign('record_count', $user_orderinfo['record_count']);
    $smarty->assign('page_count', $user_orderinfo['page_count']);
    $smarty->assign('user_orderinfo', $user_orderinfo['user_orderinfo']);
    $smarty->assign('full_page', 1);
    $smarty->assign('start_date', local_date('Y-m-d', $start_date));
    $smarty->assign('end_date', local_date('Y-m-d', $end_date));
    $smarty->assign('sort_order_num', '<img src="images/sort_desc.gif">');
    /* 页面显示 */
    assign_query_info();
    $smarty->display('users_order.htm');
}
    $smarty->assign('user_orderinfo', $user_orderinfo);
    $smarty->assign('start_date', local_date('Y-m-d', $start_date));
    $smarty->assign('end_date', local_date('Y-m-d', $end_date));
    $smarty->assign('form_act', 'turnover');
    $smarty->assign('show_num', $show_num);
    $smarty->assign('ur_here', $_LANG['report_users']);
    $smarty->assign('action_link', array('text' => $_LANG['order_amount_sort'], 'href' => 'users_order.php?act=order_num'));
    $smarty->assign('action_link2', array('text' => $_LANG['download_amount_sort'], 'href' => "users_order.php?act=download&start_date={$start_date}&end_date={$end_date}&orderby=turnover"));
    /* 显示页面 */
    assign_query_info();
    $smarty->display('users_order.htm');
}
if ($_REQUEST['act'] == 'download') {
    $start_date = $_REQUEST['start_date'];
    $end_date = $_REQUEST['end_date'];
    $user_orderinfo = get_user_orderinfo($show_num, 'turnover', $start_date, $end_date);
    $filename = $start_date . '_' . $end_date . 'users_order';
    header("Content-type: application/vnd.ms-excel; charset=utf-8");
    header("Content-Disposition: attachment; filename={$filename}.xls");
    $data = "{$_LANG['visit_buy']}\t\n";
    $data .= "{$_LANG['order_by']}\t{$_LANG['member_name']}\t{$_LANG['order_amount']}\t{$_LANG['buy_sum']}\t\n";
    foreach ($user_orderinfo as $k => $row) {
        $order_by = $k + 1;
        $data .= "{$order_by}\t{$row['user_name']}\t{$row['order_num']}\t{$row['turnover']}\n";
    }
    echo ecs_iconv(EC_CHARSET, 'GB2312', $data);
    exit;
}
/*------------------------------------------------------ */
//--会员排行需要的函数
/*------------------------------------------------------ */