Пример #1
0
/**
 * 获取最近购买的
 * $type 0模拟数据 1真实数据
 */
function get_licai_dealshow($limit = 10, $type = 0)
{
    $d_table = "licai_dealshow";
    if ($type == 1) {
        $d_table = "licai_order";
    }
    $sql = "SELECT d.*,l.id,l.name,l.img FROM " . DB_PREFIX . $d_table . " d LEFT JOIN " . DB_PREFIX . "licai l ON l.id = d.licai_id ORDER BY d.id DESC LIMIT " . $limit;
    $list = $GLOBALS['db']->getAll($sql);
    foreach ($list as $k => $v) {
        $list[$k] = licai_item_format($v);
    }
    return $list;
}
Пример #2
0
 public function uc_deal_lc()
 {
     if (!$GLOBALS['user_info']) {
         app_redirect(url("user#login"));
     }
     $id = intval($_REQUEST["id"]);
     $vo = $GLOBALS["db"]->getRow("select * from " . DB_PREFIX . "licai where id=" . $id);
     $vo = licai_item_format($vo);
     $list = $GLOBALS["db"]->getAll("select * from " . DB_PREFIX . "licai_interest where licai_id=" . $id . " order by id asc ");
     foreach ($list as $k => $v) {
         $list[$k] = interest_item_format($v);
         $list[$k]["min_money_format"] = format_money_wan($list[$k]["min_money"]);
         $list[$k]["max_money_format"] = format_money_wan($list[$k]["max_money"]);
     }
     $GLOBALS["tmpl"]->assign("vo", $vo);
     $GLOBALS["tmpl"]->assign("list", $list);
     $GLOBALS['tmpl']->display("licai/licai_uc_deal_lc.html");
 }