PHP local_getdate函数代码示例

/**
 * 获得用户所在时区指定的时间戳
 *
 * @param   $timestamp  integer     该时间戳必须是一个服务器本地的时间戳
 *
 * @return  array
 */
function local_gettime($timestamp = NULL)
{
    $tmp = local_getdate($timestamp);
    return $tmp[0];
}

 $goods['promote'] = $db->GetOne('SELECT COUNT(*) FROM ' . $ecs->table('goods') . ' WHERE is_delete = 0 AND promote_price>0' . " AND promote_start_date <= '{$time}' AND promote_end_date >= '{$time}' AND is_real = 1");
 $virtual_card['promote'] = $db->GetOne('SELECT COUNT(*) FROM ' . $ecs->table('goods') . ' WHERE is_delete = 0 AND promote_price>0' . " AND promote_start_date <= '{$time}' AND promote_end_date >= '{$time}' AND is_real=0 AND extension_code='virtual_card'");
 /* 缺货商品 */
 if ($_CFG['use_storage']) {
     $sql = 'SELECT COUNT(*) FROM ' . $ecs->table('goods') . ' WHERE is_delete = 0 AND goods_number <= warn_number AND is_real = 1';
     $goods['warn'] = $db->GetOne($sql);
     $sql = 'SELECT COUNT(*) FROM ' . $ecs->table('goods') . ' WHERE is_delete = 0 AND goods_number <= warn_number AND is_real=0 AND extension_code=\'virtual_card\'';
     $virtual_card['warn'] = $db->GetOne($sql);
 } else {
     $goods['warn'] = 0;
     $virtual_card['warn'] = 0;
 }
 $smarty->assign('goods', $goods);
 $smarty->assign('virtual_card', $virtual_card);
 /* 访问统计信息 */
 $today = local_getdate();
 $sql = 'SELECT COUNT(*) FROM ' . $ecs->table('stats') . ' WHERE access_time > ' . (mktime(0, 0, 0, $today['mon'], $today['mday'], $today['year']) - date('Z'));
 $today_visit = $db->GetOne($sql);
 $smarty->assign('today_visit', $today_visit);
 $online_users = $sess->get_users_count();
 $smarty->assign('online_users', $online_users);
 /* 最近反馈 */
 $sql = "SELECT COUNT(f.msg_id) " . "FROM " . $ecs->table('feedback') . " AS f " . "LEFT JOIN " . $ecs->table('feedback') . " AS r ON r.parent_id=f.msg_id " . 'WHERE f.parent_id=0 AND ISNULL(r.msg_id) ';
 $smarty->assign('feedback_number', $db->GetOne($sql));
 /* 未审核评论 */
 $smarty->assign('comment_number', $db->getOne('SELECT COUNT(*) FROM ' . $ecs->table('comment') . ' WHERE status = 0 AND parent_id = 0'));
 $mysql_ver = $db->version();
 // 获得 MySQL 版本
 /* 系统信息 */
 $sys_info['os'] = PHP_OS;
 $sys_info['ip'] = $_SERVER['SERVER_ADDR'];

/**
 *  获取我的债券列表
 *
 * @access  public
 * @param   int     $user_id        用户ID
 * @param   int     $num            列表最大数量
 * @param   int     $start          列表起始位置
 * @param   int     $type           债券的类型
 *
 * @return  array   $booking
 */
function get_booking_list($user_id, $num, $start, $catstatus, $type)
{
    $booking = array();
    $pay_status = PS_PAYED;
    $sql = "SELECT o.invest_price,o.market_price,g.goods_number,g.goods_weight,g.add_time,g.shop_price,g.surplus_price,g.goods_sn,g.good_status " . "FROM " . $GLOBALS['ecs']->table('goods') . " AS g, " . $GLOBALS['ecs']->table('order_goods') . " AS o, " . $GLOBALS['ecs']->table('category') . " AS c " . "WHERE g.goods_id = o.goods_id AND c.cat_id = g.cat_id AND o.pay_status = " . $pay_status . " AND g.good_status = " . $type . " AND" . " o.user_id = '{$user_id}' AND c.is_standalone =" . $catstatus . " order by o.rec_id desc";
    $res = $GLOBALS['db']->SelectLimit($sql, $num, $start);
    while ($row = $GLOBALS['db']->fetchRow($res)) {
        if (empty($row['dispose_note'])) {
            $row['dispose_note'] = 'N/A';
        }
        if ($type == GD_INVING) {
            $booking[] = array('invest_price' => $row['invest_price'], 'market_price' => $row['market_price'] . '%', 'surprice' => round(100 * (($row['shop_price'] - $row['surplus_price']) / $row['shop_price']), 2) . '%', 'limit_time' => ceil(($row['goods_number'] - $row['add_time']) / (60 * 60 * 24)), 'overplus_time' => ceil(($row['goods_number'] - gmtime()) / (60 * 60 * 24)), 'good_id' => $row['goods_sn']);
        }
        if ($type == GD_FULL) {
            $monthnum = ceil(($row['goods_number'] - $row['goods_weight']) / 3600 * 24 * 30) - ceil(($row['goods_number'] - $row['goods_weight']) / 3600 * 24 * 30 / ((gmtime() - $row['goods_weight']) / 3600 * 24 * 30));
            $nextmonth = local_date('Y-m-d', $row['goods_weight'] + 3600 * 24 * 30 * $monthnum);
            if ($nextmonth - gmtime() > 0) {
                $orstatus = '未付款';
            } else {
                $orstatus = '已付款';
            }
            $booking[] = array('invest_price' => $row['invest_price'], 'market_price' => $row['market_price'], 'collect_interest' => $row['shop_price'] * $row['market_price'] / 365 * (($row['goods_number'] - $row['add_time']) / 60 * 60 * 24), 'month_interest' => $row['shop_price'] * $row['market_price'] / 365 * date('t', gmtime()), 'overplus_time' => $nextmonth, 'over_status' => $orstatus, 'good_id' => $row['goods_sn']);
        }
        if ($type == GD_OVER) {
            $booking[] = array('invest_price' => $row['invest_price'], 'market_price' => $row['market_price'], 'shop_price' => ($row['shop_price'] - $row['surplus_price']) / $row['shop_price'], 'limit_time' => ($row['goods_number'] - $row['add_time']) / (60 * 60 * 24), 'overplus_time' => local_getdate($row['goods_number']), 'over_style' => ($row['goods_number'] - gmtime()) / 60 * 60 * 24, 'good_id' => $row['goods_sn']);
        }
    }
    return $booking;
}