/** * 获取最近购买的 * $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; }
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"); }