public function load($param)
{
$key = $this->build_key(__CLASS__, $param);
$GLOBALS['fcache']->set_dir(APP_ROOT_PATH . "public/runtime/data/" . __CLASS__ . "/");
$new_hepls = $GLOBALS['fcache']->get($key);
if ($new_hepls === false) {
$new_hepls = load_auto_cache('article_cates');
$article_array = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "article where is_effect=1 order by sort desc ");
foreach ($new_hepls as $k => $v) {
if ($v['type_id'] == 1 && $v['num'] > 0) {
foreach ($article_array as $article_k => $article_v) {
if ($article_v['cate_id'] == $v['id']) {
if ($article_v['rel_url'] == "") {
$article_v['url'] = url('article', array('id' => $article_v['id']));
} else {
$article_v['url'] = $article_v['rel_url'];
}
$new_hepls[$k]['article'][] = $article_v;
}
}
} else {
unset($new_hepls[$k]);
}
}
$new_hepls = array_filter($new_hepls);
$GLOBALS['fcache']->set_dir(APP_ROOT_PATH . "public/runtime/data/" . __CLASS__ . "/");
$GLOBALS['fcache']->set($key, $new_hepls);
}
return $new_hepls;
}
public function show()
{
//获得文章列表
$artilce_cate = load_auto_cache("article_cates");
foreach ($artilce_cate as $k => $v) {
$artilce_cate[$k]['cate_id'] = $v['id'];
$artilce_cate[$k]['titles'] = $v['title'];
if ($id > 0 && $v['id'] == $id) {
$type_id = intval($v['type_id']);
$cate_name = $v['title'];
}
if ($id == $artilce_cate[$k]['cate_id']) {
$artilce_cate[$k]['current'] = 1;
}
}
$GLOBALS['tmpl']->assign("artilce_cate", $artilce_cate);
//文章头部导航
$nav_top = set_nav_top($GLOBALS['module'], $GLOBALS['action']);
$GLOBALS['tmpl']->assign('nav_top', $nav_top);
$GLOBALS['tmpl']->assign('deal_type', 'article_type');
$act = strim($_REQUEST['act']);
$help_item = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "help where type = '" . $act . "' or id = " . intval($act));
$GLOBALS['tmpl']->assign("help_item", $help_item);
$GLOBALS['tmpl']->assign("page_title", $help_item['title']);
$GLOBALS['tmpl']->display("help_show.html");
}
public function edit()
{
//输出配送方式
//$consignee_id = $GLOBALS['db']->getOne("select id from ".DB_PREFIX."user_consignee where user_id = ".$GLOBALS['user_info']['id']);
$consignee_id = $_REQUEST['id'];
if ($consignee_id > 0) {
$consignee_data = load_auto_cache("consignee_info", array("consignee_id" => $consignee_id));
$consignee_info = $consignee_data['consignee_info'];
$region_lv1 = $consignee_data['region_lv1'];
$region_lv2 = $consignee_data['region_lv2'];
$region_lv3 = $consignee_data['region_lv3'];
$region_lv4 = $consignee_data['region_lv4'];
$GLOBALS['tmpl']->assign("region_lv1", $region_lv1);
$GLOBALS['tmpl']->assign("region_lv2", $region_lv2);
$GLOBALS['tmpl']->assign("region_lv3", $region_lv3);
$GLOBALS['tmpl']->assign("region_lv4", $region_lv4);
$GLOBALS['tmpl']->assign("consignee_info", $consignee_info);
} else {
$region_lv1 = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "delivery_region where pid = 0");
//一级地址
$GLOBALS['tmpl']->assign("region_lv1", $region_lv1);
}
if ($consignee_info) {
$GLOBALS['tmpl']->assign("consignee_info", $consignee_info);
}
$GLOBALS['tmpl']->assign("page_title", $GLOBALS['lang']['UC_CONSIGNEE']);
$GLOBALS['tmpl']->assign("inc_file", "inc/uc/uc_consignee_edit.html");
$GLOBALS['tmpl']->display("uc.html");
}
public function index()
{
//require APP_ROOT_PATH.'app/Lib/page.php';
$page = intval($GLOBALS['request']['page']);
if ($page == 0) {
$page = 1;
}
$keywords = trim(htmlspecialchars($GLOBALS['request']['keywords']));
$level = intval($GLOBALS['request']['level']);
$interest = intval($GLOBALS['request']['interest']);
$months = intval($GLOBALS['request']['months']);
$lefttime = intval($GLOBALS['request']['lefttime']);
$deal_status = intval($GLOBALS['request']['deal_status']);
$limit = ($page - 1) * app_conf("DEAL_PAGE_SIZE") . "," . app_conf("DEAL_PAGE_SIZE");
$level_list = load_auto_cache("level");
$cate_id = intval($GLOBALS['request']['cid']);
$n_cate_id = 0;
$condition = " publish_wait = 0 ";
$orderby = "";
if ($cate_id > 0) {
$n_cate_id = $cate_id;
//$condition .= "AND deal_status in(0,1)";
$orderby = "update_time DESC ,sort DESC,id DESC";
} else {
$n_cate_id = 0;
$orderby = "update_time DESC , sort DESC , id DESC";
}
if ($keywords) {
$kw_unicode = str_to_unicode_string($keywords);
$condition .= " and (match(name_match,deal_cate_match,tag_match,type_match) against('" . $kw_unicode . "' IN BOOLEAN MODE))";
}
if ($level > 0) {
$point = $level_list['point'][$level];
$condition .= " AND user_id in(SELECT u.id FROM " . DB_PREFIX . "user u LEFT JOIN " . DB_PREFIX . "user_level ul ON ul.id=u.level_id WHERE ul.point >= {$point})";
}
if ($interest > 0) {
$condition .= " AND rate >= " . $interest;
}
if ($months > 0) {
if ($months == 12) {
$condition .= " AND repay_time <= " . $months;
} elseif ($months == 18) {
$condition .= " AND repay_time >= " . $months;
}
}
if ($lefttime > 0) {
$condition .= " AND (start_time + enddate*24*3600 - " . TIME_UTC . ") <= " . $lefttime * 24 * 3600;
}
if ($deal_status > 0) {
$condition .= " AND deal_status = " . $deal_status;
}
$result = get_deal_list($limit, $n_cate_id, $condition, $orderby);
$root = array();
$root['response_code'] = 1;
$root['item'] = $result['list'];
//$root['DEAL_PAGE_SIZE'] = app_conf("DEAL_PAGE_SIZE");
//$root['count'] = $result['count'];
$root['page'] = array("page" => $page, "page_total" => ceil($result['count'] / app_conf("DEAL_PAGE_SIZE")));
output($root);
}
public function index()
{
$GLOBALS['tmpl']->caching = true;
$cache_id = md5(MODULE_NAME . ACTION_NAME);
if (!$GLOBALS['tmpl']->is_cached('faq_index.html', $cache_id)) {
$faq_list = array();
$faq_group_list = $GLOBALS['db']->getAll("select distinct(`group`) from " . DB_PREFIX . "faq order by sort asc");
foreach ($faq_group_list as $k => $v) {
$faq_list[$v['group']] = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "faq where `group`='" . $v['group'] . "' order by sort asc");
}
$GLOBALS['tmpl']->assign("faq_list", $faq_list);
$GLOBALS['tmpl']->assign("page_title", "常见问题");
}
//获得文章列表
$artilce_cate = load_auto_cache("article_cates");
foreach ($artilce_cate as $k => $v) {
$artilce_cate[$k]['cate_id'] = $v['id'];
$artilce_cate[$k]['titles'] = $v['title'];
if ($id > 0 && $v['id'] == $id) {
$type_id = intval($v['type_id']);
$cate_name = $v['title'];
}
if ($id == $artilce_cate[$k]['cate_id']) {
$artilce_cate[$k]['current'] = 1;
}
}
$GLOBALS['tmpl']->assign("artilce_cate", $artilce_cate);
//文章头部导航
$nav_top = set_nav_top($GLOBALS['module'], $GLOBALS['action']);
$GLOBALS['tmpl']->assign('nav_top', $nav_top);
$GLOBALS['tmpl']->assign('deal_type', 'article_type');
$GLOBALS['tmpl']->display("faq_index.html", $cache_id);
}
public function index()
{
$root = array();
$email = strim($GLOBALS['request']['email']);
//用户名或邮箱
$pwd = strim($GLOBALS['request']['pwd']);
//密码
//检查用户,用户密码
$user = user_check($email, $pwd);
$user_id = intval($user['id']);
$root['user_id'] = $user_id;
if ($user_id > 0) {
require APP_ROOT_PATH . 'app/Lib/uc_func.php';
$root['user_login_status'] = 1;
$root['response_code'] = 1;
$bank_list = $GLOBALS['db']->getAll("SELECT u.id, u.bankcard,u.real_name, b.name as bank_name, b.id as bank_id FROM " . DB_PREFIX . "user_bank u left join " . DB_PREFIX . "bank b on b.id = u.bank_id where u.user_id=" . $user_id . " ORDER BY u.id ASC");
foreach ($bank_list as $k => $v) {
$bank_list[$k]['bankcode'] = str_replace(" ", "", $v['bankcard']);
$bank_list[$k]['img'] = str_replace("/mapi", "", SITE_DOMAIN . APP_ROOT . '/public/bank/' . $v['bank_id'] . '.jpg');
}
$root['item'] = $bank_list;
//手续费
$fee_config = load_auto_cache("user_carry_config");
$json_fee = array();
foreach ($fee_config as $k => $v) {
$json_fee[] = $v;
$fee_config[$k]['fee_format'] = format_price($v['fee']);
}
$root['fee_config'] = $fee_config;
//$root['json_fee'] = json_encode($json_fee);
$root['open_ips'] = intval(app_conf("OPEN_IPS"));
$root['ips_acct_no'] = $user['ips_acct_no'];
$root['idno'] = $user['idno'];
//身份证号
$root['real_name'] = $user['real_name'];
//第三方托管标
if (!empty($user['ips_acct_no']) && intval(app_conf("OPEN_IPS")) > 0) {
$result = GetIpsUserMoney($user_id, 0);
$root['ips_money'] = $result['pBalance'];
//提现 http://p2p.fanwe.net/index.php?ctl=collocation&act=DoDwTrade&user_type=0&from=app&user_id=44&pTrdAmt=10
$app_url = APP_ROOT . "/index.php?ctl=collocation&act=DoDwTrade&user_type=0&pTrdAmt=parm_amt&user_id=" . $user_id . "&from=" . $GLOBALS['request']['from'];
$root['dw_url'] = str_replace("/mapi", "", SITE_DOMAIN . $app_url);
} else {
//申请
$app_url = APP_ROOT . "/index.php?ctl=collocation&act=CreateNewAcct&user_type=0&user_id=" . $user_id . "&from=" . $GLOBALS['request']['from'];
$root['acct_url'] = str_replace("/mapi", "", SITE_DOMAIN . $app_url);
$root['ips_money'] = 0;
}
$root['ips_money_format'] = format_price($root['ips_money']);
//预留 提现金额
$root['ips_money_fee'] = 0;
//预留 提现费用
} else {
$root['response_code'] = 0;
$root['show_err'] = "未登录";
$root['user_login_status'] = 0;
}
$root['program_title'] = "提现";
output($root);
}
public function load($param)
{
static $cate_list;
if ($cate_list) {
return $cate_list;
}
$key = $this->build_key(__CLASS__, $param);
$GLOBALS['fcache']->set_dir(APP_ROOT_PATH . "public/runtime/data/" . __CLASS__ . "/");
$cate_list = $GLOBALS['fcache']->get($key);
if ($cate_list === false) {
$cate_list_rs = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "shop_cate where is_effect = 1 and is_delete = 0");
foreach ($cate_list_rs as $k => $v) {
//输出筛选
$ids = load_auto_cache("shop_sub_parent_cate_ids", array("cate_id" => intval($v['id'])));
$brand_list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "brand where shop_cate_id in (" . implode(",", $ids) . ")");
$brand_list[] = array("name" => $GLOBALS['lang']['ALL'], "id" => 0);
$v['brand_list'] = $brand_list;
$filter_group = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "filter_group where is_effect = 1 and cate_id in (" . implode(",", $ids) . ") order by sort desc");
foreach ($filter_group as $kk => $vv) {
$filter_list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "filter where filter_group_id = " . $vv['id'] . " limit 20");
$filter_list[] = array("name" => $GLOBALS['lang']['ALL'], "id" => 0);
$filter_group[$kk]['filter_list'] = $filter_list;
}
$v['filter_group'] = $filter_group;
$cate_list[$v['id']] = $v;
if ($v['uname'] != "") {
$cate_list[$v['uname']] = $v;
}
}
$GLOBALS['fcache']->set_dir(APP_ROOT_PATH . "public/runtime/data/" . __CLASS__ . "/");
$GLOBALS['fcache']->set($key, $cate_list);
}
return $cate_list;
}
public function index()
{
$GLOBALS['tmpl']->assign("page_title", $GLOBALS['lang']['UC_ACCOUNT']);
//扩展字段
$field_list = load_auto_cache("user_field_list");
foreach ($field_list as $k => $v) {
$field_list[$k]['value'] = $GLOBALS['db']->getOne("select value from " . DB_PREFIX . "user_extend where user_id=" . $GLOBALS['user_info']['id'] . " and field_id=" . $v['id']);
}
$GLOBALS['tmpl']->assign("field_list", $field_list);
//地区列表
$region_lv2 = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "region_conf where region_level = 2");
//二级地址
foreach ($region_lv2 as $k => $v) {
if ($v['id'] == intval($GLOBALS['user_info']['province_id'])) {
$region_lv2[$k]['selected'] = 1;
break;
}
}
$GLOBALS['tmpl']->assign("region_lv2", $region_lv2);
$region_lv3 = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "region_conf where pid = " . intval($GLOBALS['user_info']['province_id']));
//三级地址
foreach ($region_lv3 as $k => $v) {
if ($v['id'] == intval($GLOBALS['user_info']['city_id'])) {
$region_lv3[$k]['selected'] = 1;
break;
}
}
$GLOBALS['tmpl']->assign("region_lv3", $region_lv3);
set_uc_right();
$GLOBALS['tmpl']->assign("inc_file", "inc/uc/uc_account_index.html");
$GLOBALS['tmpl']->display("uc.html");
}
public function init()
{
$id = intval($_REQUEST['id']);
$this->space_user = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "user where id = " . $id . " and is_effect= 1 and is_delete = 0");
$user_id = intval($GLOBALS['user_info']['id']);
if (!$this->space_user) {
showErr($GLOBALS['lang']['USER_NOT_EXISTS']);
}
$focus_data = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "user_focus where focus_user_id = " . $user_id . " and focused_user_id = " . $this->space_user['id']);
if ($focus_data) {
$this->space_user['focused'] = 1;
}
$region_list = load_auto_cache("cache_region_conf");
// $province_str = $GLOBALS['db']->getOne("select name from ".DB_PREFIX."region_conf where id = ".$this->space_user['province_id']);
$province_str = $region_list[$this->space_user['province_id']]['name'];
// $city_str = $GLOBALS['db']->getOne("select name from ".DB_PREFIX."region_conf where id = ".$this->space_user['city_id']);
$city_str = $region_list[$this->space_user['city_id']]['name'];
if ($province_str . $city_str == '') {
$user_location = $GLOBALS['lang']['LOCATION_NULL'];
} else {
$user_location = $province_str . $city_str;
}
$this->space_user['fav_count'] = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "topic where user_id = " . $this->space_user['id'] . " and fav_id <> 0");
$this->space_user['user_location'] = $user_location;
$GLOBALS['tmpl']->assign("space_user", $this->space_user);
//输出粉丝
$fans_list = $GLOBALS['db']->getAll("select focus_user_id as id,focus_user_name as user_name from " . DB_PREFIX . "user_focus where focused_user_id = " . $this->space_user['id'] . " order by rand() limit 5");
$ids = array(0);
foreach ($fans_list as $k => $v) {
$ids[] = $v['id'];
}
$focus_data = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "user_focus where focus_user_id = " . $user_id . " and focused_user_id in (" . implode(",", $ids) . ")");
foreach ($fans_list as $k => $v) {
foreach ($focus_data as $kk => $vv) {
if ($vv['focused_user_id'] == $v['id']) {
$fans_list[$k]['focused'] = 1;
break;
}
}
}
$GLOBALS['tmpl']->assign("rfans_list", $fans_list);
//输出我的关注
$focus_list = $GLOBALS['db']->getAll("select focused_user_id as id,focused_user_name as user_name from " . DB_PREFIX . "user_focus where focus_user_id = " . $this->space_user['id'] . " order by rand() limit 5");
$ids = array(0);
foreach ($focus_list as $k => $v) {
$ids[] = $v['id'];
}
$focus_data = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "user_focus where focus_user_id = " . $user_id . " and focused_user_id in (" . implode(",", $ids) . ")");
foreach ($focus_list as $k => $v) {
foreach ($focus_data as $kk => $vv) {
if ($vv['focused_user_id'] == $v['id']) {
$focus_list[$k]['focused'] = 1;
break;
}
}
}
$GLOBALS['tmpl']->assign("rfocus_list", $focus_list);
}
public function index()
{
$GLOBALS['tmpl']->assign("page_title", "积分兑现");
$list = load_auto_cache("level");
$GLOBALS['tmpl']->assign("list", $list['list']);
$userinfo = $GLOBALS['db']->getRow("SELECT * FROM " . DB_PREFIX . "user WHERE id='" . $GLOBALS['user_info']['id'] . "' and vip_state='1' ");
$GLOBALS['tmpl']->assign('userinfo', $userinfo);
$gradeinfo = $GLOBALS['db']->getRow("SELECT * FROM " . DB_PREFIX . "vip_type WHERE id='" . $userinfo['vip_id'] . "' and is_delete='0' ");
$GLOBALS['tmpl']->assign('gradeinfo', $gradeinfo);
$vip_type = $GLOBALS['db']->getAll("SELECT * FROM " . DB_PREFIX . "vip_type WHERE is_effect='1' and is_delete='0' ");
$GLOBALS['tmpl']->assign('vip_type', $vip_type);
$vip_setting = $GLOBALS['db']->getAll("SELECT * FROM " . DB_PREFIX . "vip_setting v LEFT JOIN " . DB_PREFIX . "vip_type vt ON v.vip_id=vt.id WHERE v.is_effect='1' and v.is_delete='0' ");
$GLOBALS['tmpl']->assign('vip_setting', $vip_setting);
$json_vipinfo = $GLOBALS['db']->getRow("SELECT * FROM " . DB_PREFIX . "vip_setting WHERE vip_id='" . $userinfo['vip_id'] . "' ");
$GLOBALS['tmpl']->assign('json_vipinfo', $json_vipinfo);
$customerinfo = $GLOBALS['db']->getRow("SELECT * FROM " . DB_PREFIX . "customer WHERE id='" . $userinfo['customer_id'] . "' and is_effect='1' ");
$GLOBALS['tmpl']->assign('customerinfo', $customerinfo);
$today = to_date(TIME_UTC, "Y-m-d");
$start_time = to_date(next_replay_month(TIME_UTC, -24), "Y-m-d");
$begin_date = to_date(next_replay_month(TIME_UTC, -3), "Y-m-d");
$user_id = $GLOBALS['user_info']['id'];
$borrow_total = $GLOBALS['db']->getOne("select sum(borrow_amount) FROM " . DB_PREFIX . "deal WHERE start_date>'{$start_time}' and user_id='{$user_id}' and deal_status > 3 ");
$load_total = $GLOBALS['db']->getOne("select sum(dl.money) FROM " . DB_PREFIX . "deal_load dl LEFT JOIN " . DB_PREFIX . "deal d ON dl.deal_id=d.id WHERE dl.create_date>'{$start_time}' and dl.user_id='{$user_id}' and d.deal_status > 3 ");
$t_u_load = $GLOBALS['db']->getRow("SELECT sum(dlr.repay_money) as load_money FROM " . DB_PREFIX . "deal_load_repay dlr LEFT JOIN " . DB_PREFIX . "deal d ON d.id=dlr.deal_id LEFT JOIN " . DB_PREFIX . "deal_load dl ON dl.id=dlr.load_id WHERE d.is_effect=1 and dl.is_repay= 0 and dlr.t_user_id = " . $user_id);
$load_total = floatval($load_total) + floatval($t_u_load['load_money']);
// $load_total = $GLOBALS['db']->getOne("select sum(money) FROM ".DB_PREFIX."deal_load WHERE create_date>'$start_time' and user_id='$user_id' ");
$overdue_total = $GLOBALS['db']->getOne("select sum(repay_money) FROM " . DB_PREFIX . "deal_repay WHERE ((has_repay=1 and repay_date<true_repay_date) or (has_repay=0 and repay_date <'{$today}')) and user_id='{$user_id}' ");
$bl_total = (int) $borrow_total + (int) $load_total;
$yx_total = $bl_total - $overdue_total;
$vipgradeinfo = $GLOBALS['db']->getRow("select * FROM " . DB_PREFIX . "vip_type WHERE lower_limit<='{$yx_total}' and upper_limit>='{$yx_total}' and is_effect='1' and is_delete='0' ");
$grade_cz = $GLOBALS['db']->getRow("SELECT * FROM " . DB_PREFIX . "vip_type where is_effect='1' and is_delete='0' order by lower_limit asc limit 1 ");
if ($grade_cz['lower_limit'] > $yx_total || $userinfo['vip_id'] == 0) {
$chazhi = (int) $grade_cz['lower_limit'] - $yx_total;
if ($chazhi > 0) {
$chazhi = $chazhi;
} else {
$chazhi = 0;
}
$nextgrade = $grade_cz['vip_grade'];
} else {
$chazhi = $vipgradeinfo['upper_limit'] - $yx_total + 1;
$nextgradeinfo = $GLOBALS['db']->getRow("select * FROM " . DB_PREFIX . "vip_type WHERE lower_limit >'" . $vipgradeinfo['upper_limit'] . "' and is_effect='1' and is_delete='0' order by lower_limit asc limit 1 ");
$nextgrade = $nextgradeinfo['vip_grade'];
}
$chazhi = number_format($chazhi);
$bl_total = number_format($bl_total);
$vipgradeinfo = number_format($vipgradeinfo);
$yx_total = number_format($yx_total);
$overdue_total = number_format($overdue_total);
$GLOBALS['tmpl']->assign('bl_total', $bl_total);
$GLOBALS['tmpl']->assign('chazhi', $chazhi);
$GLOBALS['tmpl']->assign('nextgrade', $nextgrade);
$GLOBALS['tmpl']->assign('overdue_total', $overdue_total);
$GLOBALS['tmpl']->assign('yx_total', $yx_total);
$GLOBALS['tmpl']->assign('vipgradeinfo', $vipgradeinfo);
$GLOBALS['tmpl']->assign("inc_file", "inc/uc/uc_score_exchange.html");
$GLOBALS['tmpl']->display("page/uc.html");
}
/**
* 获取文章列表
*/
function get_article_list($limit, $cate_id = 0, $where = '', $orderby = '', $cached = true)
{
$key = md5("ARTICLE" . $limit . $cate_id . $where . $orderby);
if ($cached) {
$res = $GLOBALS['cache']->get($key);
} else {
$res = false;
}
if ($res === false) {
$count_sql = "select count(*) from " . DB_PREFIX . "article as a left join " . DB_PREFIX . "article_cate as ac on a.cate_id = ac.id where a.is_effect = 1 and a.is_delete = 0 and ac.is_delete = 0 and ac.is_effect = 1 ";
$sql = "select a.*,ac.type_id,ac.title as ctitle from " . DB_PREFIX . "article as a left join " . DB_PREFIX . "article_cate as ac on a.cate_id = ac.id where a.is_effect = 1 and a.is_delete = 0 and ac.is_delete = 0 and ac.is_effect = 1 ";
if ($cate_id > 0) {
$ids = load_auto_cache("deal_shop_acate_belone_ids", array("cate_id" => $cate_id));
$sql .= " and a.cate_id in (" . implode(",", $ids) . ")";
$count_sql .= " and a.cate_id in (" . implode(",", $ids) . ")";
}
if ($where != '') {
$sql .= " and " . $where;
$count_sql .= " and " . $where;
}
if ($orderby == '') {
$sql .= " order by a.sort desc limit " . $limit;
} else {
$sql .= " order by " . $orderby . " limit " . $limit;
}
$articles = $GLOBALS['db']->getAll($sql);
foreach ($articles as $k => $v) {
if ($v['type_id'] == 1) {
$module = "help";
} elseif ($v['type_id'] == 2) {
$module = "notice";
} elseif ($v['type_id'] == 3) {
$module = "sys";
} else {
$module = 'article';
}
if ($v['rel_url'] != '') {
if (!preg_match("/http:\\/\\//i", $v['rel_url'])) {
if (substr($v['rel_url'], 0, 2) == 'u:') {
$aurl = parse_url_tag($v['rel_url']);
} else {
$aurl = APP_ROOT . "/" . $v['rel_url'];
}
} else {
$aurl = $v['rel_url'];
}
} else {
$aurl = url("index", $module . "#" . $v['id']);
}
$articles[$k]['url'] = $aurl;
}
$articles_count = $GLOBALS['db']->getOne($count_sql);
$res = array('list' => $articles, 'count' => $articles_count);
$GLOBALS['cache']->set($key, $res);
}
return $res;
}
public function index()
{
$GLOBALS['tmpl']->caching = true;
//输出文章
$id = intval($_REQUEST['id']);
$article = $GLOBALS['db']->getRow("select a.*,ac.type_id from " . DB_PREFIX . "article as a left join " . DB_PREFIX . "article_cate as ac on ac.id=a.cate_id where a.id={$id}");
//$article_shang 上一篇文章，$article_xia下一篇文章
$article_shang = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "article where id<" . $article['id'] . " and is_delete=0 and is_effect=1 order by id desc limit 0,1");
$article_xia = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "article where id>" . $article['id'] . " and is_delete=0 and is_effect=1 order by id desc limit 0,1");
if ($article_shang['rel_url'] == "") {
$article_shang['url'] = url('article', array('id' => $article_shang['id']));
} else {
$article_shang['url'] = $article_shang['rel_url'];
}
if ($article_xia['rel_url'] == "") {
$article_xia['url'] = url('article', array('id' => $article_xia['id']));
} else {
$article_xia['url'] = $article_xia['rel_url'];
}
$cate_id = $article['cate_id'];
$article['tags_arr'] = preg_split("/[ ,]/", $article['tags']);
$artilce_cate = load_auto_cache("article_cates");
$artilce_cate_new = array();
foreach ($artilce_cate as $k => $v) {
if ($v['type_id'] == $article['type_id'] && $v['id'] != $cate_id && $v['num'] > 0) {
$artilce_cate_new[$k]['cate_id'] = $v['id'];
$artilce_cate_new[$k]['titles'] = $v['title'];
$artilce_cate_new[$k]['url'] = url('article_cate', array('id' => $v['id']));
}
}
$GLOBALS['tmpl']->assign("other_cate", $artilce_cate_new);
//文章详细页面最新更新(控制最新的10条)
$temp_article_list = $GLOBALS['db']->getAllCached("SELECT a.*,c.type_id from " . DB_PREFIX . "article a LEFT JOIN " . DB_PREFIX . "article_cate c on a.cate_id=c.id where 1=1 and a.is_delete=0 and a.is_effect=1 and c.type_id=" . $article['type_id'] . " and a.cate_id={$cate_id} and a.id!={$id} order by update_time desc limit 0,5");
$article_list = array();
foreach ($temp_article_list as $k => $v) {
//最新更新
$article_list[$k]['cate_title'] = $v['title'];
if ($v['rel_url'] == "") {
$article_list[$k]['url'] = url('article', array('id' => $v['id']));
} else {
$article_list[$k]['url'] = $v['rel_url'];
}
}
unset($temp_article_list);
$GLOBALS['tmpl']->assign('deal_type', 'article_type');
//文章头部导航
$nav_top = set_nav_top($GLOBALS['module'], $GLOBALS['action'], $id);
$GLOBALS['tmpl']->assign('nav_top', $nav_top);
$GLOBALS['tmpl']->assign("page_title", $article['seo_title']);
$GLOBALS['tmpl']->assign("page_seo_keyword", $article['seo_keyword']);
$GLOBALS['tmpl']->assign("page_seo_description", $article['seo_description']);
$GLOBALS['tmpl']->assign("article", $article);
$GLOBALS['tmpl']->assign("article_shang", $article_shang);
$GLOBALS['tmpl']->assign("article_xia", $article_xia);
$GLOBALS['tmpl']->assign("article_list", $article_list);
$GLOBALS['tmpl']->display("article_index.html");
}
public function index()
{
init_app_page();
$s_account_info = $GLOBALS["account_info"];
$supplier_id = intval($s_account_info['supplier_id']);
$name = strim($_REQUEST['name']);
$begin_time = strim($_REQUEST['begin_time']);
$end_time = strim($_REQUEST['end_time']);
$begin_time_s = to_timespan($begin_time, "Y-m-d H:i");
$end_time_s = to_timespan($end_time, "Y-m-d H:i");
$condition = "";
if ($name != "") {
$youhui_ids = $GLOBALS['db']->getRow("select group_concat(id SEPARATOR ',') as ids from " . DB_PREFIX . "youhui where name like '%" . $name . "%'");
$condition .= " and log.youhui_id in (" . $youhui_ids['ids'] . ") ";
}
if ($begin_time_s) {
$condition .= " and log.create_time > " . $begin_time_s . " ";
}
if ($end_time_s) {
$condition .= " and log.create_time < " . $end_time_s . " ";
}
$GLOBALS['tmpl']->assign("name", $name);
$GLOBALS['tmpl']->assign("begin_time", $begin_time);
$GLOBALS['tmpl']->assign("end_time", $end_time);
//分页
$page_size = 15;
$page = intval($_REQUEST['p']);
if ($page == 0) {
$page = 1;
}
$limit = ($page - 1) * $page_size . "," . $page_size;
$list = $GLOBALS['db']->getAll("select distinct(log.id),log.* from " . DB_PREFIX . "youhui_log as log left join " . DB_PREFIX . "youhui_location_link as l on l.youhui_id = log.youhui_id where l.location_id in (" . implode(",", $s_account_info['location_ids']) . ") " . $condition . " order by log.create_time desc limit " . $limit);
foreach ($list as $k => $v) {
$list[$k]['user_name'] = load_user($v['user_id']);
$list[$k]['user_name'] = $list[$k]['user_name']['user_name'];
$youhui_info = load_auto_cache("youhui", array('id' => $v['youhui_id']));
$list[$k]['youhui_name'] = $youhui_info['name'];
$location_info = load_auto_cache("store", array('id' => $v['location_id']));
$list[$k]['location_name'] = $location_info['name'];
if ($list[$k]['expire_time'] != 0 && $list[$k]['expire_time'] < NOW_TIME) {
$list[$k]['expire_time'] = "已过期";
} elseif ($list[$k]['expire_time'] == 0) {
$list[$k]['expire_time'] = "永久有效";
} else {
$list[$k]['expire_time'] = to_date($list[$k]['expire_time']);
}
$list[$k]['url'] = url('index', 'youhui#' . $v['youhui_id']);
}
$total = $GLOBALS['db']->getOne("select count(distinct(log.id)) from " . DB_PREFIX . "youhui_log as log left join " . DB_PREFIX . "youhui_location_link as l on l.youhui_id = log.youhui_id where l.location_id in (" . implode(",", $s_account_info['location_ids']) . ") " . $condition);
$page = new Page($total, $page_size);
//初始化分页对象
$p = $page->show();
$GLOBALS['tmpl']->assign('pages', $p);
$GLOBALS['tmpl']->assign("list", $list);
$GLOBALS['tmpl']->assign("head_title", "优惠券下载记录");
$GLOBALS['tmpl']->display("pages/youhuio/index.html");
}
public function index()
{
$root = array();
$page = intval($GLOBALS['request']['page']);
if ($page == 0) {
$page = 1;
}
$keywords = trim(htmlspecialchars($GLOBALS['request']['keywords']));
$level = intval($GLOBALS['request']['level']);
$interest = intval($GLOBALS['request']['interest']);
$months = intval($GLOBALS['request']['months']);
$lefttime = intval($GLOBALS['request']['lefttime']);
$cate_id = intval($GLOBALS['request']['cid']);
$limit = ($page - 1) * app_conf("DEAL_PAGE_SIZE") . "," . app_conf("DEAL_PAGE_SIZE");
$level_list = load_auto_cache("level");
$page_args = array();
$condition = "";
if ($cate_id > 0) {
$condition .= "AND d.deal_status >=4 and cate_id=" . $cate_id;
$orderby = "d.update_time DESC ,d.sort DESC,d.id DESC";
} elseif ($cate_id == 0) {
$orderby = " d.create_time DESC , dlt.id DESC";
}
if ($keywords) {
$kw_unicode = str_to_unicode_string($keywords);
$condition .= " and (match(d.name_match,d.deal_cate_match,d.tag_match,d.type_match) against('" . $kw_unicode . "' IN BOOLEAN MODE))";
}
if ($level > 0) {
$point = $level_list['point'][$level];
$condition .= " AND d.user_id in(SELECT u.id FROM " . DB_PREFIX . "user u LEFT JOIN " . DB_PREFIX . "user_level ul ON ul.id=u.level_id WHERE ul.point >= {$point})";
}
if ($interest > 0) {
$condition .= " AND d.rate >= " . $interest;
}
if ($months > 0) {
if ($months == 12) {
$condition .= " AND d.repay_time <= " . $months;
} elseif ($months == 18) {
$condition .= " AND d.repay_time >= " . $months;
}
}
if ($lefttime > 0) {
$condition .= " AND (d.next_repay_time + 24*3600 - 1 - " . TIME_UTC . ") <= " . $lefttime * 24 * 3600;
}
$extfield = "";
$union_sql = "";
$result = get_transfer_list($limit, $condition, $extfield, $union_sql, $orderby);
$root = array();
$root['response_code'] = 1;
$root['item'] = $result['list'];
//$root['DEAL_PAGE_SIZE'] = app_conf("DEAL_PAGE_SIZE");
//$root['count'] = $result['count'];
$root['page'] = array("page" => $page, "page_total" => ceil($result['rs_count'] / app_conf("DEAL_PAGE_SIZE")), "page_size" => app_conf("DEAL_PAGE_SIZE"));
$root['program_title'] = "债权转让";
output($root);
}
public function send()
{
global_run();
if (check_save_login() != LOGIN_STATUS_LOGINED) {
$data['status'] = 1000;
ajax_return($data);
} else {
$t = strim($_REQUEST['t']);
$id = intval($_REQUEST['id']);
$youhui_log = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "youhui_log where id = " . $id . " and user_id = " . $GLOBALS['user_info']['id']);
$youhui_info = load_auto_cache("youhui", array("id" => $youhui_log['youhui_id']));
if ($youhui_log) {
if ($youhui_log['confirm_time'] > 0) {
$data['status'] = 0;
$data['info'] = "优惠券已使用";
ajax_return($data);
} elseif ($youhui_log['expire_time'] > 0 && $youhui_log['expire_time'] < NOW_TIME) {
$data['status'] = 0;
$data['info'] = "优惠券已过期";
ajax_return($data);
} else {
if ($t == "sms") {
if (app_conf("SMS_ON") == 0 || $youhui_info['is_sms'] == 0) {
$data['status'] = 0;
$data['info'] = "不支持短信发送";
ajax_return($data);
} elseif ($youhui_log['sms_count'] >= app_conf("SMS_COUPON_LIMIT")) {
$data['status'] = 0;
$data['info'] = "短信发送已超过" . app_conf("SMS_COUPON_LIMIT") . "次";
ajax_return($data);
} elseif ($GLOBALS['user_info']['mobile'] == "") {
$data['status'] = 0;
$data['info'] = "请先设置手机号";
$data['jump'] = url("index", "uc_account");
ajax_return($data);
} else {
send_youhui_log_sms($id);
$GLOBALS['db']->query("update " . DB_PREFIX . "youhui_log set sms_count = sms_count + 1 where id = " . $id);
$data['status'] = 1;
$data['info'] = "短信成功发送到" . $GLOBALS['user_info']['mobile'] . "，请注意查收。";
ajax_return($data);
}
} else {
$data['status'] = 0;
$data['info'] = "非法操作";
ajax_return($data);
}
}
} else {
$data['status'] = 0;
$data['info'] = "优惠券不存在";
ajax_return($data);
}
}
}
public function index()
{
global_run();
init_app_page();
$GLOBALS['tmpl']->assign("no_nav", true);
//无分类下拉
$title = $GLOBALS['lang']['GROUP_FORUM'];
$site_nav[] = array('name' => $GLOBALS['lang']['HOME_PAGE'], 'url' => url("index", "index"));
$site_nav[] = array('name' => $title, 'url' => url("index", "group"));
$GLOBALS['tmpl']->assign("site_nav", $site_nav);
//输出热门小组
$hot_group = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "topic_group where is_effect = 1 order by topic_count desc,user_count desc limit 4");
$GLOBALS['tmpl']->assign("hot_group", $hot_group);
if (intval($_REQUEST['id']) > 0) {
$page_size = 20;
$page = intval($_REQUEST['p']);
if ($page <= 0) {
$page = 1;
}
$limit = ($page - 1) * $page_size . "," . $page_size;
$cate_condition = " and id = " . intval($_REQUEST['id']);
} else {
$limit = 6;
$cate_condition = " and 1=1 ";
}
//输出分类列表
$cate_list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "topic_group_cate where is_effect = 1 " . $cate_condition . " order by sort desc");
foreach ($cate_list as $k => $v) {
$sql = " select * from " . DB_PREFIX . "topic_group where is_effect = 1 and cate_id = " . $v['id'] . " order by sort asc limit " . $limit;
$cate_list[$k]['list'] = $GLOBALS['db']->getAll($sql);
if (intval($_REQUEST['id']) > 0) {
$sql_count = "select count(*) from " . DB_PREFIX . "topic_group where is_effect = 1 and cate_id = " . $v['id'] . " order by sort asc";
$count = $GLOBALS['db']->getOne($sql_count);
}
}
$GLOBALS['tmpl']->assign("cate_list", $cate_list);
//print_r($cate_list);
if (intval($_REQUEST['id']) > 0) {
$page = new Page($count, $page_size);
//初始化分页对象
$p = $page->show();
$GLOBALS['tmpl']->assign('pages', $p);
}
//输出优秀小组长
$group_adm_list = $GLOBALS['db']->getAll("select id,name,user_count,user_id from " . DB_PREFIX . "topic_group where is_effect = 1 and user_id <> 0 group by user_id order by topic_count desc limit 5");
$GLOBALS['tmpl']->assign("group_adm_list", $group_adm_list);
//输出推荐的主题
$rec_topic_list = load_auto_cache("recommend_forum_topic");
$GLOBALS['tmpl']->assign("rec_topic_list", $rec_topic_list);
$GLOBALS['tmpl']->assign("page_title", $title);
$GLOBALS['tmpl']->assign("page_keyword", $title . ",");
$GLOBALS['tmpl']->assign("page_description", $title . ",");
$GLOBALS['tmpl']->display("group_index.html");
}
public function edit()
{
$id = intval($_REQUEST['id']);
$condition['id'] = $id;
$vo = M(MODULE_NAME)->where($condition)->find();
if ($vo['deal_status'] == 0) {
$level_list = load_auto_cache("level");
$u_level = M("User")->where("id=" . $vo['user_id'])->getField("level_id");
$vo['services_fee'] = $level_list['services_fee'][$u_level];
}
$user_info = M("User")->getById($vo['user_id']);
$old_imgdata_str = unserialize($user_info['view_info']);
foreach ($old_imgdata_str as $k => $v) {
$old_imgdata_str[$k]['key'] = $k;
/*+一个key*/
}
$this->assign("user_info", $user_info);
$this->assign("old_imgdata_str", $old_imgdata_str);
$vo['view_info'] = unserialize($vo['view_info']);
if ($vo['status'] == 0) {
$vo['manage_fee'] = app_conf("MANAGE_FEE");
$vo['user_loan_manage_fee'] = app_conf("USER_LOAN_MANAGE_FEE");
$vo['manage_impose_fee_day1'] = app_conf("MANAGE_IMPOSE_FEE_DAY1");
$vo['manage_impose_fee_day2'] = app_conf("MANAGE_IMPOSE_FEE_DAY2");
$vo['impose_fee_day1'] = app_conf("IMPOSE_FEE_DAY1");
$vo['impose_fee_day2'] = app_conf("IMPOSE_FEE_DAY2");
$vo['user_load_transfer_fee'] = app_conf("USER_LOAD_TRANSFER_FEE");
$vo['compensate_fee'] = app_conf("COMPENSATE_FEE");
$vo['user_bid_rebate'] = app_conf("USER_BID_REBATE");
$vo['generation_position'] = 100;
}
$this->assign("vo", $vo);
$citys = M("DealCity")->where('is_delete= 0 and is_effect=1 ')->findAll();
$citys_link = unserialize($vo['citys']);
foreach ($citys as $k => $v) {
foreach ($citys_link as $kk => $vv) {
if ($vv == $v['id']) {
$citys[$k]['is_selected'] = 1;
}
}
}
$this->assign('citys', $citys);
$deal_cate_tree = M("DealCate")->where('is_delete = 0')->findAll();
$deal_cate_tree = D("DealCate")->toFormatTree($deal_cate_tree, 'name');
$this->assign("deal_cate_tree", $deal_cate_tree);
$deal_agency = M("DealAgency")->where('is_effect = 1')->order('sort DESC')->findAll();
$this->assign("deal_agency", $deal_agency);
$deal_type_tree = M("DealLoanType")->findAll();
$deal_type_tree = D("DealLoanType")->toFormatTree($deal_type_tree, 'name');
$this->assign("deal_type_tree", $deal_type_tree);
$loantype_list = load_auto_cache("loantype_list");
$this->assign("loantype_list", $loantype_list);
$this->display();
}
public function futures()
{
$GLOBALS['tmpl']->caching = true;
$cache_id = md5(MODULE_NAME . ACTION_NAME);
if (!$GLOBALS['tmpl']->is_cached('peizi/weekwin.html', $cache_id)) {
$peizi_conf = load_auto_cache("peizi_conf", array('type' => 3));
$GLOBALS['tmpl']->assign("is_show_today", 1);
$GLOBALS['tmpl']->assign("peizi_conf_json", json_encode($peizi_conf));
$GLOBALS['tmpl']->assign("peizi_conf", $peizi_conf);
}
$GLOBALS['tmpl']->display("peizi/futures.html", $cache_id);
}
public function register()
{
init_app_page();
if ($GLOBALS['user_info']) {
$GLOBALS['tmpl']->assign("user_info", $GLOBALS['user_info']);
}
$step = intval($_REQUEST['step']);
if (empty($step)) {
$step = 1;
}
if ($step == 2) {
$cate_list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "deal_cate where is_effect = 1 and is_delete = 0 order by sort desc");
$GLOBALS['tmpl']->assign("cate_list", $cate_list);
$deal_city_list = load_auto_cache("city_list_result");
$GLOBALS['tmpl']->assign("city_list", $deal_city_list['ls']);
} elseif ($step == 3) {
if ($_POST) {
$data['name'] = addslashes(htmlspecialchars(trim($_REQUEST['name'])));
$data['deal_cate_id'] = intval($_REQUEST['deal_cate_id']);
foreach ($_REQUEST['deal_cate_type_id'] as $type) {
$data['deal_cate_type_id'][] = intval($type);
}
foreach ($_REQUEST['area_id'] as $area) {
$data['area_id'][] = intval($area);
}
$data['address'] = strim($_REQUEST['address']);
$data['xpoint'] = doubleval($_REQUEST['xpoint']);
$data['ypoint'] = doubleval($_REQUEST['ypoint']);
$data['tel'] = strim($_REQUEST['tel']);
$data['open_time'] = strim($_REQUEST['open_time']);
$data['location_id'] = 0;
$data['city_id'] = intval($_REQUEST['city_id']);
} else {
app_redirect(url("biz", "user#register"));
}
$GLOBALS['tmpl']->assign("base_data", base64_encode(serialize($data)));
$user_id = intval($GLOBALS['user_info']['id']);
if ($user_id) {
$GLOBALS['tmpl']->assign("user_info", $GLOBALS['user_info']);
}
} elseif ($step == 4) {
$sid = $_REQUEST['sid'];
if ($sid > 0) {
$supplier_data = $GLOBALS['db']->getRow("SELECT * FROM " . DB_PREFIX . "supplier_submit WHERE id=" . $sid);
$supplier_data['h_bank_info'] = preg_replace("/(\\d{4})(?=\\d)/", "\$1 ", $supplier_data['h_bank_info']);
$GLOBALS['tmpl']->assign("supplier_data", $supplier_data);
}
}
$GLOBALS['tmpl']->assign("sms_lesstime", load_sms_lesstime());
$GLOBALS['tmpl']->assign("sms_ipcount", load_sms_ipcount());
$GLOBALS['tmpl']->assign("step", $step);
$GLOBALS['tmpl']->display("register.html");
}
public function index()
{
$root = array();
$root['response_code'] = 1;
$artilce_cate = load_auto_cache("article_cates");
foreach ($artilce_cate as $k => $v) {
$artilce_cate[$k]['cate_id'] = $v['id'];
$artilce_cate[$k]['titles'] = $v['title'];
}
$GLOBALS['tmpl']->assign("artilce_cate", $artilce_cate);
$temp_artilce_list = $GLOBALS['db']->getAllCached("SELECT a.*,c.type_id from " . DB_PREFIX . "article a LEFT JOIN " . DB_PREFIX . "article_cate c on a.cate_id=c.id order by update_time asc");
$hot_article = array();
$week_article = array();
$artilce_item = array();
foreach ($temp_artilce_list as $k => $v) {
//最新智能头条 type_id==0帮助文章，is_hot==1热门，is_week==1本周必读
if ($v['type_id'] == 0 && $v['is_delete'] == 0 && $v['is_effect'] == 1) {
$artilce_item[$k]['cate_title'] = $v['title'];
$artilce_item[$k]['seo_keyword'] = $v['seo_keyword'];
$artilce_item[$k]['title'] = $v['title'];
$artilce_item[$k]['content'] = $v['content'];
$artilce_item[$k]['update_time'] = $v['update_time'];
if ($v['rel_url'] == "") {
$artilce_item[$k]['url'] = url('article', array('id' => $v['id']));
} else {
$artilce_item[$k]['url'] = $v['rel_url'];
}
}
//热门话题
if ($v['is_hot'] == 1 && ($v['is_effect'] = 1 && $v['is_delete'] == 0 && $v['type_id'] == 0)) {
$hot_article[$k]['title'] = $v['title'];
if ($v['rel_url'] == "") {
$hot_article[$k]['url'] = url('article', array('id' => $v['id']));
} else {
$hot_article[$k]['url'] = $v['rel_url'];
}
}
//每周必读
if ($v['is_week'] == 1 && $v['is_effect'] == 1 && $v['is_delete'] == 0 && $v['type_id'] == 0) {
$week_article[$k]['title'] = $v['title'];
if ($v['rel_url'] == "") {
$week_article[$k]['url'] = url('article', array('id' => $v['id']));
} else {
$week_article[$k]['url'] = $v['rel_url'];
}
}
}
unset($temp_artilce_list);
$root['artilce_list'] = $artilce_item;
$root['hot_1'] = $hot_article;
$root['hot_2'] = $week_article;
output($root);
}
public function index()
{
global_run();
init_app_page();
$GLOBALS['tmpl']->assign("no_nav", true);
//无分类下拉
if (check_save_login() != LOGIN_STATUS_LOGINED) {
app_redirect(url("index", "user#login"));
}
$GLOBALS['tmpl']->assign("page_title", "我的点评");
assign_uc_nav_list();
//begin review
require_once APP_ROOT_PATH . "system/model/review.php";
require_once APP_ROOT_PATH . "app/Lib/page.php";
//分页
$page_size = 10;
$page = intval($_REQUEST['p']);
if ($page == 0) {
$page = 1;
}
$limit = ($page - 1) * $page_size . "," . $page_size;
$dp_res = get_dp_list($limit, "", " user_id = " . $GLOBALS['user_info']['id']);
$dp_list = $dp_res['list'];
$total = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "supplier_location_dp where " . $dp_res['condition']);
$page = new Page($total, $page_size);
//初始化分页对象
$p = $page->show();
$GLOBALS['tmpl']->assign('pages', $p);
foreach ($dp_list as $k => $v) {
if ($v['deal_id'] > 0) {
$data_info = load_auto_cache("deal", array("id" => $v['deal_id']));
} elseif ($v['youhui_id'] > 0) {
$data_info = load_auto_cache("youhui", array("id" => $v['youhui_id']));
} elseif ($v['event_id'] > 0) {
$data_info = load_auto_cache("event", array("id" => $v['event_id']));
}
if (empty($data_info)) {
$data_info = load_auto_cache("store", array("id" => $v['supplier_location_id']));
}
$dp_list[$k]['data_info'] = $data_info;
}
$GLOBALS['tmpl']->assign('dp_list', $dp_list);
require_once APP_ROOT_PATH . "system/model/topic.php";
global $no_lazy;
$no_lazy = true;
$review_html = decode_topic_without_img($GLOBALS['tmpl']->fetch("inc/uc_review_list.html"));
$GLOBALS['tmpl']->assign("review_html", $review_html);
//end review
$no_lazy = false;
$GLOBALS['tmpl']->display("uc/uc_review_index.html");
}
public function index()
{
$title = $GLOBALS['lang']['GROUP_FORUM'];
$site_nav[] = array('name' => $GLOBALS['lang']['HOME_PAGE'], 'url' => APP_ROOT . "/");
$site_nav[] = array('name' => $title, 'url' => url("shop", "group"));
$GLOBALS['tmpl']->assign("site_nav", $site_nav);
$GLOBALS['tmpl']->assign("page_title", $title);
$GLOBALS['tmpl']->assign("page_keyword", $title . ",");
$GLOBALS['tmpl']->assign("page_description", $title . ",");
$cate_item = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "topic_group_cate where id = " . intval($_REQUEST['id']));
$cate_id = intval($cate_item['id']);
$GLOBALS['tmpl']->assign("cate_id", $cate_id);
//输出热门小组
$hot_group = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "topic_group where is_effect = 1 order by topic_count desc,user_count desc limit 4");
$GLOBALS['tmpl']->assign("hot_group", $hot_group);
//输出分类列表
$cate_list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "topic_group_cate where is_effect = 1 order by sort desc");
$GLOBALS['tmpl']->assign("cate_list", $cate_list);
//输出优秀小组长
$group_adm_list = $GLOBALS['db']->getAll("select id,name,user_count,user_id from " . DB_PREFIX . "topic_group where is_effect = 1 and user_id <> 0 group by user_id order by topic_count desc limit 5");
$GLOBALS['tmpl']->assign("group_adm_list", $group_adm_list);
$page_size = 20;
$page = intval($_REQUEST['p']);
if ($page == 0) {
$page = 1;
}
$limit = ($page - 1) * $page_size . "," . $page_size;
if ($cate_id > 0) {
$cate_condition = " and cate_id = " . $cate_id;
}
$sql = " select * from " . DB_PREFIX . "topic_group where is_effect = 1 {$cate_condition} order by sort desc limit " . $limit;
$sql_count = "select count(*) from " . DB_PREFIX . "topic_group where is_effect = 1 {$cate_condition} ";
$list = $GLOBALS['db']->getAll($sql);
$count = $GLOBALS['db']->getOne($sql_count);
$GLOBALS['tmpl']->assign("list", $list);
$page = new Page($count, $page_size);
//初始化分页对象
$p = $page->show();
$GLOBALS['tmpl']->assign('pages', $p);
//输出最新主题
$new_topic_list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "topic where group_id <> 0 and is_effect = 1 and is_delete = 0 order by create_time desc limit 10");
foreach ($new_topic_list as $k => $v) {
$new_topic_list[$k]['group_name'] = $GLOBALS['db']->getOne("select name from " . DB_PREFIX . "topic_group where id = " . $v['group_id']);
}
$GLOBALS['tmpl']->assign('new_topic_list', $new_topic_list);
//输出推荐的主题
$rec_topic_list = load_auto_cache("recommend_forum_topic");
$GLOBALS['tmpl']->assign("rec_topic_list", $rec_topic_list);
$GLOBALS['tmpl']->display("group_index.html");
}
function get_supplier_list($limit, $cate_id = 0, $city_id = 0, $where = '')
{
$condition = " is_effect = 1 ";
if ($cate_id > 0) {
$ids = load_auto_cache("deal_sub_parent_cate_ids", array("cate_id" => $cate_id));
$condition .= " and cate_id in (" . implode(",", $ids) . ")";
}
if ($city_id == 0) {
$city = get_current_deal_city();
$city_id = $city['id'];
}
if ($city_id > 0) {
$ids = load_auto_cache("deal_city_belone_ids", array("city_id" => $city_id));
if ($ids) {
$condition .= " and city_id in (" . implode(",", $ids) . ")";
}
}
if ($where != '') {
$condition .= " and " . $where;
}
$sql = "select * from " . DB_PREFIX . "supplier where " . $condition . " order by sort desc limit " . $limit;
$count_sql = "select count(*) from " . DB_PREFIX . "supplier where " . $condition;
$suppliers = $GLOBALS['db']->getAll($sql);
$suppliers_count = $GLOBALS['db']->getOne($count_sql);
foreach ($suppliers as $k => $v) {
$suppliers[$k]['url'] = url("shop", "brand", array("id" => $v['id']));
$main_location = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "supplier_location where supplier_id = " . $v['id'] . " and is_main = 1");
$suppliers[$k]['tel'] = $main_location['tel'];
$suppliers[$k]['address'] = $main_location['address'];
$suppliers[$k]['contact'] = $main_location['contact'];
$suppliers[$k]['brief'] = $main_location['brief'];
$suppliers[$k]['deal_count'] = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "deal where supplier_id = " . $v['id'] . " and is_effect = 1 and is_delete = 0 and buy_type <> 1 and time_status > 0");
$max_price = $GLOBALS['db']->getOne("select max(current_price) from " . DB_PREFIX . "deal where supplier_id = " . $v['id'] . " and is_effect = 1 and is_delete = 0 and buy_type <> 1");
$min_price = $GLOBALS['db']->getOne("select min(current_price) from " . DB_PREFIX . "deal where supplier_id = " . $v['id'] . " and is_effect = 1 and is_delete = 0 and buy_type <> 1");
if ($max_price == $min_price) {
$suppliers[$k]['deal_price'] = format_price($max_price);
} else {
$suppliers[$k]['deal_price'] = format_price($min_price) . " - " . format_price($max_price);
}
$suppliers[$k]['comment_count'] = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "message where rel_table='supplier' and rel_id = " . $v['id']);
$suppliers[$k]['comment1_count'] = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "message where rel_table='supplier' and rel_id = " . $v['id'] . " and point = 1");
//差
$suppliers[$k]['comment2_count'] = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "message where rel_table='supplier' and rel_id = " . $v['id'] . " and point = 2");
//中
$suppliers[$k]['comment3_count'] = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "message where rel_table='supplier' and rel_id = " . $v['id'] . " and point = 3");
//好
}
return array('list' => $suppliers, 'count' => $suppliers_count);
}
function index()
{
$GLOBALS['tmpl']->assign("page_title", $GLOBALS['lang']['UC_AUTO_BID']);
$deal_cates = load_auto_cache("cache_deal_cate");
$GLOBALS['tmpl']->assign("deal_cates", $deal_cates);
$autobid = $GLOBALS['db']->getRow("SELECT * FROM " . DB_PREFIX . "user_autobid WHERE user_id = '" . $GLOBALS['user_info']['id'] . "'");
$autobid['deal_cates'] = explode(",", $autobid['deal_cates']);
$GLOBALS['tmpl']->assign("autobid", $autobid);
$level = $GLOBALS['db']->getAll("SELECT * FROM " . DB_PREFIX . "user_level order by id \tASC");
$GLOBALS['tmpl']->assign("min_level", $level);
rsort($level);
$GLOBALS['tmpl']->assign("max_level", $level);
$GLOBALS['tmpl']->assign("inc_file", "inc/uc/uc_autobid.html");
$GLOBALS['tmpl']->display("page/uc.html");
}
public function register()
{
$GLOBALS['tmpl']->assign("page_title", $GLOBALS['lang']['USER_REGISTER']);
$field_list = load_auto_cache("user_field_list");
$api_uinfo = es_session::get("api_user_info");
$GLOBALS['tmpl']->assign("reg_name", $api_uinfo['name']);
$GLOBALS['tmpl']->assign("field_list", $field_list);
$GLOBALS['tmpl']->assign("agreement", app_conf("AGREEMENT"));
$GLOBALS['tmpl']->assign("privacy", app_conf("PRIVACY"));
$referer = "";
if (isset($_REQUEST['r'])) {
$referer = strim(base64_decode($_REQUEST['r']));
}
$GLOBALS['tmpl']->assign("referer", $referer);
$GLOBALS['tmpl']->display("user_register.html");
}
function add()
{
$GLOBALS['tmpl']->assign("page_title", $GLOBALS['lang']['UC_AUTO_BID']);
$deal_cates = load_auto_cache("cache_deal_cate");
$GLOBALS['tmpl']->assign("deal_cates", $deal_cates);
$level_list = load_auto_cache("level");
$range_date = array();
$rate_list = array();
foreach ($level_list['repaytime_list'] as $k => $v) {
foreach ($v as $kk => $vv) {
if ($vv[1] == 1) {
$range_date[(int) $vv[0]] = $vv[0];
}
$rate_list[(int) $vv[2]] = $vv[2];
$rate_list[(int) $vv[3]] = $vv[3];
}
}
asort($range_date);
sort($range_date);
$GLOBALS['tmpl']->assign("min_date", $range_date);
rsort($range_date);
$GLOBALS['tmpl']->assign("max_date", $range_date);
asort($rate_list);
sort($rate_list);
$rateinfo = $GLOBALS['db']->getRowCached("SELECT max(rate) as max_rate,min(rate) as min_rate FROM " . DB_PREFIX . "deal ");
if ((double) $rateinfo['max_rate'] > (int) max($rate_list)) {
$rate_list[] = intval($rateinfo['max_rate']);
}
if ((double) $rateinfo['min_rate'] < (int) min($rate_list)) {
$rate_list[0] = intval($rateinfo['min_rate']);
}
$GLOBALS['tmpl']->assign("min_rate", $rate_list);
rsort($rate_list);
$GLOBALS['tmpl']->assign("max_rate", $rate_list);
if ($id = intval($_REQUEST['id'])) {
$autobid = $GLOBALS['db']->getRow("SELECT * FROM " . DB_PREFIX . "user_autobid WHERE id = {$id}");
$autobid['deal_cates'] = explode(",", $autobid['deal_cates']);
}
$GLOBALS['tmpl']->assign("autobid", $autobid);
$level = $level_list['list'];
$GLOBALS['tmpl']->assign("max_level", $level);
krsort($level);
$GLOBALS['tmpl']->assign("min_level", $level);
$GLOBALS['tmpl']->assign("inc_file", "inc/uc/uc_autobid.html");
$GLOBALS['tmpl']->display("page/uc.html");
}
/**
* 获取正在进行的投标列表
*/
function get_deal_list($limit = "", $cate_id = 0, $where = '', $orderby = '', $user_name = '', $user_pwd = '', $is_all = false)
{
$time = TIME_UTC;
$count_sql = "select count(*) from " . DB_PREFIX . "deal where 1=1 ";
if ($is_all == false) {
$count_sql .= " and is_effect = 1 and is_delete = 0 ";
}
if (es_cookie::get("shop_sort_field") == "ulevel") {
$extfield = ",(SELECT u.level_id FROM fanwe_user u WHERE u.id=user_id ) as ulevel";
}
$sql = "select *,start_time as last_time,(load_money/borrow_amount*100) as progress_point,(start_time + enddate*24*3600 - " . $time . ") as remain_time {$extfield} from " . DB_PREFIX . "deal where 1 = 1 ";
if ($is_all == false) {
$sql .= " and is_effect = 1 and is_delete = 0 ";
}
if ($cate_id > 0) {
$ids = load_auto_cache("deal_sub_parent_cate_ids", array("cate_id" => $cate_id));
$sql .= " and cate_id in (" . implode(",", $ids) . ")";
$count_sql .= " and cate_id in (" . implode(",", $ids) . ")";
}
if ($where != '') {
$sql .= " and " . $where;
$count_sql .= " and " . $where;
}
if ($orderby == '') {
$sql .= " order by sort desc ";
} else {
$sql .= " order by " . $orderby;
}
if ($limit != "") {
$sql .= " limit " . $limit;
}
$deals_count = $GLOBALS['db']->getOne($count_sql);
if ($deals_count > 0) {
$deals = $GLOBALS['db']->getAll($sql);
//echo $sql;
if ($deals) {
foreach ($deals as $k => $deal) {
format_deal_item($deal, $user_name, $user_pwd);
$deals[$k] = $deal;
}
}
} else {
$deals = array();
}
return array('list' => $deals, 'count' => $deals_count);
}
public function __construct($appId = "", $appSecret = "")
{
$this->appId = $appId;
$this->appSecret = $appSecret;
$weixin_conf = load_auto_cache("weixin_conf");
if ($weixin_conf['platform_status']) {
$this->is_platform = 1;
$this->component_appid = $weixin_conf['platform_appid'];
$this->component_access_token = $weixin_conf['platform_component_access_token'];
$this->option = array('platform_token' => $weixin_conf['platform_token'], 'platform_encodingAesKey' => $weixin_conf['platform_encodingAesKey'], 'platform_appid' => $weixin_conf['platform_appid'], 'platform_appsecret' => $weixin_conf['platform_appsecret'], 'platform_component_verify_ticket' => $weixin_conf['platform_component_verify_ticket'], 'platform_component_access_token' => $weixin_conf['platform_component_access_token'], 'platform_pre_auth_code' => $weixin_conf['platform_pre_auth_code'], 'platform_component_access_token_expire' => $weixin_conf['platform_component_access_token_expire'], 'platform_pre_auth_code_expire' => $weixin_conf['platform_pre_auth_code_expire'], 'logcallback' => 'log_result', 'debug' => true);
$this->platform = new PlatformWechat($this->option);
$new_token = $this->platform->check_platform_access_token();
if ($new_token != $this->component_access_token) {
$this->component_access_token = $new_token;
}
}
}
public function send()
{
global_run();
if (check_save_login() != LOGIN_STATUS_LOGINED) {
$data['status'] = 1000;
ajax_return($data);
} else {
$t = strim($_REQUEST['t']);
$id = intval($_REQUEST['id']);
$lottery = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "lottery where id = " . $id . " and user_id = " . $GLOBALS['user_info']['id']);
$deal = load_auto_cache("deal", array("id" => $lottery['deal_id']));
if ($lottery) {
if ($t == "sms") {
if (app_conf("SMS_ON") == 0 || app_conf("LOTTERY_SN_SMS") == 0) {
$data['status'] = 0;
$data['info'] = "不支持短信发送";
ajax_return($data);
} elseif ($lottery['sms_count'] >= app_conf("SMS_COUPON_LIMIT")) {
$data['status'] = 0;
$data['info'] = "短信发送已超过" . app_conf("SMS_COUPON_LIMIT") . "次";
ajax_return($data);
} elseif ($GLOBALS['user_info']['mobile'] == "") {
$data['status'] = 0;
$data['info'] = "请先设置手机号";
$data['jump'] = url("index", "uc_account");
ajax_return($data);
} else {
send_lottery_sms($id);
$GLOBALS['db']->query("update " . DB_PREFIX . "lottery set sms_count = sms_count + 1 where id = " . $id);
$data['status'] = 1;
$data['info'] = "短信成功发送到" . $GLOBALS['user_info']['mobile'] . "，请注意查收。";
ajax_return($data);
}
} else {
$data['status'] = 0;
$data['info'] = "非法操作";
ajax_return($data);
}
} else {
$data['status'] = 0;
$data['info'] = "抽奖号不存在";
ajax_return($data);
}
}
}
public function daijin_index()
{
$GLOBALS['tmpl']->caching = true;
$GLOBALS['tmpl']->cache_lifetime = 600;
//代金券首页缓存10分钟
$cache_id = md5(MODULE_NAME . ACTION_NAME . $GLOBALS['deal_city']['id']);
if (!$GLOBALS['tmpl']->is_cached('daijin_index.html', $cache_id)) {
make_deal_cate_js();
make_deal_region_js();
$result = load_auto_cache("byouhui_filter_nav_cache", array('city_id' => $GLOBALS['deal_city']['id']));
$GLOBALS['tmpl']->assign("cate_list", $result['cate_list']);
$GLOBALS['tmpl']->assign("area_list", $result['area_list']);
//输出右侧的优惠列表
$result = search_youhui_list(5, 0, "", "", false, "", $GLOBALS['deal_city']['id']);
$daijin_list = $result['list'];
$GLOBALS['tmpl']->assign("daijin_list", $daijin_list);
$right_daijin_html = $GLOBALS['tmpl']->fetch("index/index_right_daijin.html");
$GLOBALS['tmpl']->assign("right_daijin_html", $right_daijin_html);
//输出右侧商家
$city_ids = load_auto_cache("deal_city_belone_ids", array("city_id" => intval($GLOBALS['deal_city']['id'])));
if ($city_ids) {
$store_list = $GLOBALS['db']->getAll("SELECT * FROM " . DB_PREFIX . "supplier_location use index(avg_point) WHERE city_id in(" . implode(",", $city_ids) . ") and is_effect = 1 order by avg_point desc limit 5");
} else {
$store_list = $GLOBALS['db']->getAll("SELECT * FROM " . DB_PREFIX . "supplier_location use index(avg_point) WHERE is_effect = 1 order by avg_point desc limit 5");
}
$GLOBALS['tmpl']->assign("store_list", $store_list);
$right_store_html = $GLOBALS['tmpl']->fetch("index/index_right_store.html");
$GLOBALS['tmpl']->assign("right_store_html", $right_store_html);
//输出左侧推荐分类
$recommend_cate = $GLOBALS['db']->getAll("select id,name from " . DB_PREFIX . "deal_cate where rec_daijin = 1 order by sort desc");
$recommend_cate_html = "";
foreach ($recommend_cate as $cate) {
$daijin_list = search_youhui_list(8, $cate['id'], "", "", false, "", $GLOBALS['deal_city']['id']);
$daijin_list = $daijin_list['list'];
$GLOBALS['tmpl']->assign("daijin_list", $daijin_list);
$scate_list = $GLOBALS['db']->getAll("select t.* from " . DB_PREFIX . "deal_cate_type as t left join " . DB_PREFIX . "deal_cate_type_link as l on l.deal_cate_type_id = t.id where t.is_recommend = 1 and l.cate_id = " . $cate['id'] . " order by sort desc");
$GLOBALS['tmpl']->assign("scate_list", $scate_list);
$GLOBALS['tmpl']->assign("bcate_item", $cate);
$recommend_cate_html .= $GLOBALS['tmpl']->fetch("inc/recommend_cate_daijin.html");
}
$GLOBALS['tmpl']->assign("recommend_cate_html", $recommend_cate_html);
}
$GLOBALS['tmpl']->display("daijin_index.html", $cache_id);
}
