public function update() { B('FilterString'); $data = M("ApnsMessages")->create(); $log_info = $data['id']; //开始验证有效性 $this->assign("jumpUrl", u("MApns/edit", array("id" => $data['id']))); if (!check_empty($data['content'])) { $this->error(L("CONTENT_EMPTY_TIP")); } if ($data['send_time'] == '') { $data['send_time'] = get_gmtime(); } $data['send_time'] = to_timespan($data['send_time']); if (intval($_REQUEST['resend']) == 1) { $data['status'] = 0; } $list = M("ApnsMessages")->save($data); if (false !== $list) { //成功提示 save_log($log_info . L("UPDATE_SUCCESS"), 1); $this->success(L("UPDATE_SUCCESS")); } else { //错误提示 save_log($log_info . L("UPDATE_FAILED"), 0); $this->error(L("UPDATE_FAILED"), 0, $log_info . L("UPDATE_FAILED")); } }
public function insert_ticket() { if ($_REQUEST['money'] == '') { $this->error("券的金额不能为空"); } if ($_REQUEST['amount'] == '') { $this->error("券的数量不能为空"); } if ($_REQUEST['use_time'] == '') { $this->error("券的有效天数不能为空"); } $ticket_data['money'] = intval($_REQUEST['money']); $ticket_data['quantity'] = intval($_REQUEST['amount']); $ticket_data['rest_quantity'] = intval($_REQUEST['amount']); $ticket_data['use_time'] = intval($_REQUEST['use_time']); $ticket_data['status'] = intval($_REQUEST['status']); $ticket_data['value'] = intval($_REQUEST['value']); $ticket_data['is_deposit'] = 1; //券的类型 0:赠金券 1代金券 $ticket_data['ticket_type'] = intval($_REQUEST['type']); //券的使用类型 0:无条件 1:满减优惠 $ticket_data['type'] = intval($_REQUEST['use_type']); //系统默认时间 $ticket_data['create_time'] = get_gmtime(); $ticket_data['start_use'] = to_timespan(trim($_REQUEST['start_time'])); $ticket_data['deadline'] = to_timespan(trim($_REQUEST['end_time'])); $rs = M("Ticket")->add($ticket_data); if ($rs) { $this->success(L("INSERT_SUCCESS")); } else { $this->error(L("INSERT_FAILED")); } }
public function update() { B('FilterString'); $data = M(MODULE_NAME)->create(); $log_info = M(MODULE_NAME)->where("id=" . intval($data['id']))->getField("name"); //开始验证有效性 $this->assign("jumpUrl", u(MODULE_NAME . "/edit", array("id" => $data['id']))); if (!check_empty($data['name'])) { $this->error(L("VOUCHER_NAME_EMPTY_TIP")); } if (doubleval($data['money']) <= 0) { $this->error(L("VOUCHER_MONEY_ERROR_TIP")); } $data['begin_time'] = trim($data['begin_time']) == '' ? 0 : to_timespan($data['begin_time']); $data['end_time'] = trim($data['end_time']) == '' ? 0 : to_timespan($data['end_time']); // 更新数据 $list = M(MODULE_NAME)->save($data); if (false !== $list) { //成功提示 M("Ecv")->where("ecv_type_id=" . $data['id'])->setField("use_limit", $data['use_limit']); //同步可用次数 M("Ecv")->where("ecv_type_id=" . $data['id'])->setField("begin_time", $data['begin_time']); M("Ecv")->where("ecv_type_id=" . $data['id'])->setField("end_time", $data['end_time']); M("Ecv")->where("ecv_type_id=" . $data['id'])->setField("money", $data['money']); save_log($log_info . L("UPDATE_SUCCESS"), 1); $this->success(L("UPDATE_SUCCESS")); } else { //错误提示 save_log($log_info . L("UPDATE_FAILED"), 0); $this->error(L("UPDATE_FAILED"), 0, $log_info . L("UPDATE_FAILED")); } }
/** * 订单来路的图饼展示 */ public function order_referer() { $where = " 1=1 "; $where .= " and type <> 1"; $map['type'] = array("neq", 1); $begin_time = strim($_REQUEST['begin_time']) == '' ? 0 : to_timespan($_REQUEST['begin_time']); $end_time = strim($_REQUEST['end_time']) == '' ? 0 : to_timespan($_REQUEST['end_time']); if ($end_time == 0) { $where .= " and create_time > " . $begin_time; $map['create_time'] = array("gt", $begin_time); } else { $where .= " and create_time between " . $begin_time . " and " . $end_time; $map['create_time'] = array("between", array($begin_time, $end_time)); } $sql = "select referer,count(id) as ct from " . DB_PREFIX . "deal_order where " . $where . " and referer <> '' group by referer having count(id) > 0 order by ct desc limit 8 "; $total_sql = "select count(*) from " . DB_PREFIX . "deal_order where " . $where; $colors = array("0xAAAAAA", "0x669999", "0xBBBB55", "0xCC6600", "0x9999FF", "0x0066CC", "0x99CCCC", "0x999999", "0xFFCC00", "0x009999", "0x99CC33", "0xFF9900", "0x999966", "0x66CCCC", "0x339966", "0xCCCC33"); $total = intval($GLOBALS['db']->getOne($total_sql)); $list = $GLOBALS['db']->getAll($sql); $items = array(); foreach ($list as $k => $v) { $total -= intval($v['ct']); $items[] = array("value" => intval($v['ct']), "tip" => $v['referer'], "on-click" => "jump_to('" . u("DealOrder/deal_index", array("referer" => $v['referer'])) . "')"); } $items[] = array("value" => $total, "tip" => "直接访问", "on-click" => "jump_to('" . u("DealOrder/deal_index", array("referer" => -1)) . "')"); $data['bg_colour'] = "#ffffff"; $data['elements'] = array(array("type" => "pie", "colours" => $colors, "alpha" => 1, "border" => 2, "start-angle" => 35, "values" => $items)); ajax_return($data); }
public function index() { $page = intval($_REQUEST['p']); if ($page == 0) { $page = 1; } $limit = ($page - 1) * app_conf("PAGE_SIZE") . "," . app_conf("PAGE_SIZE"); $user_id = $GLOBALS['user_info']['id']; $status = isset($_REQUEST['stauts']) ? intval($_REQUEST['stauts']) : 3; $time = isset($_REQUEST['time']) ? to_timespan($_REQUEST['time'], "Ymd") : ""; $deal_name = strim($_REQUEST['deal_name']); $condition = ""; if ($deal_name != "") { $condition .= " and d.name = '" . $deal_name . "' "; $GLOBALS['tmpl']->assign('deal_name', $deal_name); } if ($time != "") { $condition .= " and dlr.repay_time = " . $time . " "; $GLOBALS['tmpl']->assign('time', to_date($time, "Y-m-d")); } $result = getUcRepayPlan($user_id, $status, $limit, $condition); if ($result['rs_count'] > 0) { $page = new Page($result['rs_count'], app_conf("PAGE_SIZE")); //初始化分页对象 $p = $page->show(); $GLOBALS['tmpl']->assign('pages', $p); $GLOBALS['tmpl']->assign('list', $result['list']); } $GLOBALS['tmpl']->assign("page_title", $GLOBALS['lang']['UC_REPAY_PLAN']); $GLOBALS['tmpl']->assign("inc_file", "inc/uc/uc_repay_plan.html"); $GLOBALS['tmpl']->assign("status", $status); $GLOBALS['tmpl']->display("page/uc.html"); }
public function index() { $order_sn = strim($_REQUEST['order_sn']); $time = isset($_REQUEST['time']) ? to_date(to_timespan($_REQUEST['time'], "Y-m-d"), "Y-m-d") : ""; $page = intval($_REQUEST['p']); if ($page == 0) { $page = 1; } $limit = ($page - 1) * app_conf("PAGE_SIZE") . "," . app_conf("PAGE_SIZE"); $condition = " 1=1 "; if ($order_sn != "") { $condition .= " and go.order_sn = '" . $order_sn . "' "; } if ($time != "") { $condition .= " and go.ex_date = '" . $time . "' "; $GLOBALS['tmpl']->assign('time', $time); } $user_id = $GLOBALS['user_info']['id']; $result = get_order($limit, $user_id, $condition); $page = new Page($result['count'], app_conf("PAGE_SIZE")); //初始化分页对象 $p = $page->show(); $GLOBALS['tmpl']->assign('pages', $p); $GLOBALS['tmpl']->assign("order_sn", $order_sn); $GLOBALS['tmpl']->assign("order_info", $result['list']); $GLOBALS['tmpl']->assign("inc_file", "inc/uc/uc_goods_order.html"); $GLOBALS['tmpl']->display("page/uc.html"); }
public function update() { B('FilterString'); $data = M(MODULE_NAME)->create(); $user_names = preg_split("/[ ,]/i", $data['user_names']); $user_ids = ""; foreach ($user_names as $k => $v) { $uid = M("User")->where("user_name = '" . $v . "'")->getField("id"); if ($uid) { $user_ids .= $uid . "|"; } } $data['user_ids'] = $user_ids; $data['end_time'] = trim($data['end_time']) == '' ? 0 : to_timespan($data['end_time']); $log_info = M(MODULE_NAME)->where("id=" . intval($data['id']))->getField("title"); //开始验证有效性 $this->assign("jumpUrl", u(MODULE_NAME . "/edit", array("id" => $data['id']))); if (!check_empty($data['title'])) { $this->error(L("MSY_TITLE_EMPTY_TIP")); } if (!check_empty($data['content'])) { $this->error(L("MSY_CONTENT_EMPTY_TIP")); } // 更新数据 $list = M(MODULE_NAME)->save($data); if (false !== $list) { //成功提示 save_log($log_info . L("UPDATE_SUCCESS"), 1); $this->success(L("UPDATE_SUCCESS")); } else { //错误提示 save_log($log_info . L("UPDATE_FAILED"), 0); $this->error(L("UPDATE_FAILED"), 0, $log_info . L("UPDATE_FAILED")); } }
public function index() { $GLOBALS['tmpl']->assign("page_title", "投资奖励"); $start_time = strim($_REQUEST['start_time']); $end_time = strim($_REQUEST['end_time']); $d = explode('-', $start_time); if (isset($_REQUEST['start_time']) && $start_time != "" && checkdate($d[1], $d[2], $d[0]) == false) { $this->error("开始时间不是有效的时间格式:{$start_time}(yyyy-mm-dd)"); exit; } $d = explode('-', $end_time); if (isset($_REQUEST['end_time']) && strim($end_time) != "" && checkdate($d[1], $d[2], $d[0]) == false) { $this->error("结束时间不是有效的时间格式:{$end_time}(yyyy-mm-dd)"); exit; } if ($start_time != "" && strim($end_time) != "" && to_timespan($start_time) > to_timespan($end_time)) { $this->error('开始时间不能大于结束时间:' . $start_time . '至' . $end_time); exit; } if (strim($start_time) != "") { $where .= " and gr.release_date >='" . strim($start_time) . "'"; } if (strim($end_time) != "") { $where .= " and gr.release_date <='" . strim($end_time) . "'"; } if (isset($_REQUEST['gift_type'])) { $gift_type = $_REQUEST['gift_type']; if ($gift_type != 5) { $where .= " and gr.gift_type ='" . $gift_type . "'"; $GLOBALS['tmpl']->assign("gift_type", $gift_type); } } $page = intval($_REQUEST['p']); if ($page == 0) { $page = 1; } $limit = ($page - 1) * app_conf("PAGE_SIZE") . "," . app_conf("PAGE_SIZE"); if ($limit) { $limit = " limit " . $limit; } $list_count = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "gift_record gr left join " . DB_PREFIX . "deal d on d.id = gr.deal_id WHERE gr.user_id='" . $GLOBALS['user_info']['id'] . "' {$where} "); $list = array(); if ($list_count > 0) { $sql = "select gr.*,d.name,vg.name as gift_name,sum(dlr.true_reward_money) as reward_money from " . DB_PREFIX . "gift_record gr " . "left join " . DB_PREFIX . "deal d on d.id = gr.deal_id " . "left join " . DB_PREFIX . "vip_gift vg on vg.id = gr.gift_value AND gr.gift_type='4' " . "left join " . DB_PREFIX . "deal_load_repay dlr on dlr.load_id = gr.load_id " . "WHERE gr.user_id='" . $GLOBALS['user_info']['id'] . "' AND ((gr.gift_type = 2 AND dlr.true_reward_money >0 ) OR (gr.gift_type <> 2)) {$where} GROUP BY gr.load_id order by gr.id desc " . $limit; $list = $GLOBALS['db']->getAll($sql); foreach ($list as $k => $v) { $list[$k]['url'] = url("index", "deal#index", array("id" => $v['deal_id'])); } } $page = new Page($list_count, app_conf("PAGE_SIZE")); //初始化分页对象 $p = $page->show(); $GLOBALS['tmpl']->assign('pages', $p); $GLOBALS['tmpl']->assign("list", $list); $GLOBALS['tmpl']->assign("start_time", $start_time); $GLOBALS['tmpl']->assign("end_time", $end_time); $GLOBALS['tmpl']->assign("inc_file", "inc/uc/uc_gift_record.html"); $GLOBALS['tmpl']->display("page/uc.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"); }
private function getlist($extwhere) { //分类 $cate_tree = M("DealCate")->where('is_delete = 0')->findAll(); $cate_tree = D("DealCate")->toFormatTree($cate_tree, 'name'); $this->assign("cate_tree", $cate_tree); $conditon = " 1=1 "; //开始加载搜索条件 if (intval($_REQUEST['deal_id']) > 0) { $conditon .= " and d.deal_id = " . intval($_REQUEST['deal_id']); } if (intval($_REQUEST['cate_id']) > 0) { require_once APP_ROOT_PATH . "system/utils/child.php"; $child = new Child("deal_cate"); $cate_ids = $child->getChildIds(intval($_REQUEST['cate_id'])); $cate_ids[] = intval($_REQUEST['cate_id']); $conditon .= " and d.cate_id in (" . implode(",", $cate_ids) . ")"; } if (trim($_REQUEST['user_name']) != '') { $sql = "select group_concat(id) from " . DB_PREFIX . "user where user_name like '%" . trim($_REQUEST['user_name']) . "%'"; $ids = $GLOBALS['db']->getOne($sql); if ($ids) { $conditon .= " and dl.user_id in ({$ids}) "; } else { $conditon .= " and dl.user_id = 0 "; } } if (intval($_REQUEST['user_id']) > 0) { $sql = "select user_name from " . DB_PREFIX . "user where id='" . intval($_REQUEST['user_id']) . "'"; $_REQUEST['user_name'] = $GLOBALS['db']->getOne($sql); $conditon .= " and dl.user_id = " . intval($_REQUEST['user_id']); } $begin_time = trim($_REQUEST['begin_time']) == '' ? 0 : to_timespan($_REQUEST['begin_time']); $end_time = trim($_REQUEST['end_time']) == '' ? 0 : to_timespan($_REQUEST['end_time']); if ($begin_time > 0 || $end_time > 0) { if ($end_time == 0) { $conditon .= " and dl.create_time >= {$begin_time} "; } else { $conditon .= " and dl.create_time between {$begin_time} and {$end_time} "; } } $count = $GLOBALS['db']->getOne("SELECT count(*) FROM " . DB_PREFIX . "deal_load dl LEFT JOIN " . DB_PREFIX . "deal d ON d.id =dl.deal_id where {$conditon} {$extwhere} ORDER BY dl.id DESC "); if (!empty($_REQUEST['listRows'])) { $listRows = $_REQUEST['listRows']; } else { $listRows = ''; } $p = new Page($count, $listRows); if ($count > 0) { $list = $GLOBALS['db']->getAll("SELECT dl.*,d.name,d.repay_time,d.repay_time_type,d.loantype,d.rate,d.cate_id FROM " . DB_PREFIX . "deal_load dl LEFT JOIN " . DB_PREFIX . "deal d ON d.id =dl.deal_id where {$conditon} {$extwhere} ORDER BY dl.id DESC limit " . $p->firstRow . ',' . $p->listRows); $this->assign("list", $list); } $page = $p->show(); $this->assign("page", $page); }
public function index() { if (trim($_REQUEST['log_info']) != '') { $map['log_info'] = array('like', '%' . trim($_REQUEST['log_info']) . '%'); } $log_begin_time = trim($_REQUEST['log_begin_time']) == '' ? 0 : to_timespan($_REQUEST['log_begin_time']); $log_end_time = trim($_REQUEST['log_end_time']) == '' ? 0 : to_timespan($_REQUEST['log_end_time']); if ($log_end_time == 0) { $map['log_time'] = array('gt', $log_begin_time); } else { $map['log_time'] = array('between', array($log_begin_time, $log_end_time)); } $this->assign("default_map", $map); parent::index(); }
public function index() { $root = array(); $email = strim($GLOBALS['request']['email']); //用户名或邮箱 $pwd = strim($GLOBALS['request']['pwd']); //密码 $id = intval($GLOBALS['request']['id']); //$user_id = intval($GLOBALS['user_info']['id']); $page = intval($GLOBALS['request']['page']); //检查用户,用户密码 $user = user_check($email, $pwd); $user_id = intval($user['id']); if ($user_id > 0) { require APP_ROOT_PATH . 'app/Lib/deal.php'; require APP_ROOT_PATH . 'app/Lib/uc_goods_func.php'; $root['user_login_status'] = 1; $root['response_code'] = 1; $order_sn = strim($_REQUEST['order_sn']); $time = isset($_REQUEST['time']) ? to_date(to_timespan($_REQUEST['time'], "Y-m-d"), "Y-m-d") : ""; if ($page == 0) { $page = 1; } $limit = ($page - 1) * app_conf("PAGE_SIZE") . "," . app_conf("PAGE_SIZE"); $condition = " 1=1 "; if ($order_sn != "") { $condition .= " and go.order_sn = '" . $order_sn . "' "; } if ($time != "") { $condition .= " and go.ex_date = '" . $time . "' "; $root['time'] = $time; } $root['user_id'] = $user_id; $orders = get_order($limit, $user_id, $condition); $root['page'] = array("page" => $page, "page_total" => ceil($orders['count'] / app_conf("DEAL_PAGE_SIZE")), "page_size" => app_conf("DEAL_PAGE_SIZE")); $root['order_sn'] = $order_sn; $root['order_info'] = $orders['list']; } else { $root['response_code'] = 0; $root['show_err'] = "未登录"; $root['user_login_status'] = 0; } $root['program_title'] = "我的兑现"; output($root); }
public function index() { $GLOBALS['tmpl']->assign("page_title", "节日福利"); $start_time = strim($_REQUEST['start_time']); $end_time = strim($_REQUEST['end_time']); $d = explode('-', $start_time); if (isset($_REQUEST['start_time']) && $start_time != "" && checkdate($d[1], $d[2], $d[0]) == false) { $this->error("开始时间不是有效的时间格式:{$start_time}(yyyy-mm-dd)"); exit; } $d = explode('-', $end_time); if (isset($_REQUEST['end_time']) && strim($end_time) != "" && checkdate($d[1], $d[2], $d[0]) == false) { $this->error("结束时间不是有效的时间格式:{$end_time}(yyyy-mm-dd)"); exit; } if ($start_time != "" && strim($end_time) != "" && to_timespan($start_time) > to_timespan($end_time)) { $this->error('开始时间不能大于结束时间:' . $start_time . '至' . $end_time); exit; } if (strim($start_time) != "") { $where .= " and send_date >='" . strim($start_time) . "'"; } if (strim($end_time) != "") { $where .= " and send_date <='" . strim($end_time) . "'"; } $page = intval($_REQUEST['p']); if ($page == 0) { $page = 1; } $limit = ($page - 1) * app_conf("PAGE_SIZE") . "," . app_conf("PAGE_SIZE"); if ($limit) { $limit = " limit " . $limit; } $list = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "given_record gr left join " . DB_PREFIX . "user u on u.id = gr.user_id left join " . DB_PREFIX . "vip_festivals vf on vf.id = gr.gift_id WHERE u.id='" . $GLOBALS['user_info']['id'] . "' {$where} order by gr.id desc " . $limit); $list_count = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "given_record gr left join " . DB_PREFIX . "user u on u.id = gr.user_id left join " . DB_PREFIX . "vip_festivals vf on vf.id = gr.gift_id WHERE u.id='" . $GLOBALS['user_info']['id'] . "' {$where} "); $page = new Page($list_count, app_conf("PAGE_SIZE")); //初始化分页对象 $p = $page->show(); $GLOBALS['tmpl']->assign('pages', $p); $GLOBALS['tmpl']->assign("list", $list); $GLOBALS['tmpl']->assign("start_time", $start_time); $GLOBALS['tmpl']->assign("end_time", $end_time); $GLOBALS['tmpl']->assign("inc_file", "inc/uc/uc_given_record.html"); $GLOBALS['tmpl']->display("page/uc.html"); }
public function index() { //用于处理团购搜索的处理程序 $se_name = trim(addslashes($_POST['se_name'])); $se_begin = trim(addslashes($_POST['se_begin'])); $se_end = trim(addslashes($_POST['se_end'])); $se_begin = to_timespan($se_begin, 'Y-m-d'); $se_end = to_timespan($se_end, 'Y-m-d'); $se_end = $se_end != 0 ? $se_end + 24 * 3600 - 1 : $se_end; $search['se_name'] = $se_name; $search['se_begin'] = $se_begin; $search['se_end'] = $se_end; $se_module = trim(addslashes($_POST['se_module'])); $se_action = trim(addslashes($_POST['se_action'])); $se_id = intval(addslashes($_POST['se_id'])); $search_code = urlencode(base64_encode(serialize($search))); $url = APP_ROOT . "/tuan.php?ctl=" . $se_module . "&act=" . $se_action . "&id=" . $se_id . "&search=" . $search_code; app_redirect($url); }
public function reply() { $ajax = 1; global_run(); if (!$GLOBALS['user_info']) { $result['status'] = -1000; $result['info'] = "未登录"; ajax_return($result); } if ($_REQUEST['content'] == '') { showErr($GLOBALS['lang']['MESSAGE_CONTENT_EMPTY'], $ajax); } /*验证每天只允许评论5次*/ $day_send_count = $GLOBALS['db']->getOne("select count(*) from " . DB_PREFIX . "topic_reply where create_time>" . to_timespan(to_date(NOW_TIME, "Y-m-d"), "Y-m-d") . " and create_time<" . NOW_TIME); if ($day_send_count >= 8) { showErr('今天你已经发很多了哦~', $ajax); } if (!check_ipop_limit(get_client_ip(), "message", intval(app_conf("SUBMIT_DELAY")), 0)) { showErr($GLOBALS['lang']['MESSAGE_SUBMIT_FAST'], $ajax); } $topic_info = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "topic where id = " . intval($_REQUEST['topic_id'])); if (!$topic_info) { showErr("主题不存在", $ajax); } $reply_data = array(); $reply_data['topic_id'] = intval($_REQUEST['topic_id']); $reply_data['user_id'] = intval($GLOBALS['user_info']['id']); $reply_data['user_name'] = $GLOBALS['user_info']['user_name']; $reply_data['reply_id'] = intval($_REQUEST['reply_id']); $reply_data['create_time'] = NOW_TIME; $reply_data['is_effect'] = 1; $reply_data['is_delete'] = 0; $reply_data['content'] = strim(valid_str(addslashes($_REQUEST['content']))); require_once APP_ROOT_PATH . 'system/model/topic.php'; $reply_id = insert_topic_reply($reply_data); //返回页面的数据 $reply_data['reply_id'] = $reply_id; $reply_data['create_time'] = to_date(NOW_TIME, "Y-m-d H:i"); $reply_data['avatar'] = show_avatar($reply_data['user_id'], "small"); $reply_data['user_url'] = url("index", "uc_home#index", array("id" => $reply_data['user_id'])); $reply_data['status'] = 1; ajax_return($reply_data); }
public function index() { $now = get_gmtime(); if (trim($_REQUEST['user_name']) != '') { $map[DB_PREFIX . 'user.user_name'] = array('like', '%' . trim($_REQUEST['user_name']) . '%'); } if (trim($_REQUEST['email']) != '') { $map[DB_PREFIX . 'user.email'] = array('like', '%' . trim($_REQUEST['email']) . '%'); } if (trim($_REQUEST['mobile']) != '') { $map[DB_PREFIX . 'user.mobile'] = array('like', '%' . trim($_REQUEST['mobile']) . '%'); } $create_time_2 = empty($_REQUEST['create_time_2']) ? to_date($now, 'Y-m-d') : strim($_REQUEST['create_time_2']); $create_time_2 = to_timespan($create_time_2) + 24 * 3600; if (trim($_REQUEST['create_time_1']) != '') { $map[DB_PREFIX . 'user.create_time'] = array('between', array(to_timespan($_REQUEST['create_time_1']), $create_time_2)); } if (intval($_REQUEST['id']) > 0) { $map[DB_PREFIX . 'user.id'] = intval($_REQUEST['id']); } if ($_REQUEST['is_effect'] == 'NULL') { unset($_REQUEST['is_effect']); } if ($_REQUEST['is_effect'] != NULL) { $map['is_effect'] = intval($_REQUEST['is_effect']); } if ($_REQUEST['is_investor'] == 'NULL') { unset($_REQUEST['is_investor']); } if (trim($_REQUEST['is_investor']) != '') { $map[DB_PREFIX . 'user.is_investor'] = intval($_REQUEST['is_investor']); } if (method_exists($this, '_filter')) { $this->_filter($map); } $name = $this->getActionName(); $model = D($name); if (!empty($model)) { $this->_list($model, $map); } $this->display(); }
function foreach_pay($page = 1) { $log_begin_time = trim($_REQUEST['log_begin_time']) == '' ? 0 : to_timespan($_REQUEST['log_begin_time']); $log_end_time = trim($_REQUEST['log_end_time']) == '' ? 0 : to_timespan($_REQUEST['log_end_time']); if ($log_end_time == 0) { $condtion = " and dlr.repay_time > {$log_begin_time} "; } else { $condtion = " and (dlr.repay_time between {$log_begin_time} and {$log_end_time} )"; } $sql_count = "SELECT count(dlr.id) FROM " . DB_PREFIX . "deal_load_repay dlr LEFT JOIN " . DB_PREFIX . "user u on u.id = dlr.user_id LEFT JOIN " . DB_PREFIX . "referrals r ON r.rel_user_id= dlr.user_id WHERE u.pid >0 and dlr.has_repay=1 {$condtion} "; $count = $GLOBALS['db']->getOne($sql_count); if (!empty($_REQUEST['listRows'])) { $listRows = $_REQUEST['listRows']; } else { $listRows = ''; } $p = new Page($count, $listRows); if ($count > 0) { $sql = "SELECT dlr.*,(dlr.l_key + 1) as l_key,(dlr.repay_money - dlr.self_money) as lixi,((dlr.repay_money - dlr.self_money) * u.referral_rate * 0.01 ) as smoney,u.referral_rate,u.id as rel_user_id,u.pid as user_id,r.pay_time FROM " . DB_PREFIX . "deal_load_repay dlr LEFT JOIN " . DB_PREFIX . "user u on u.id = dlr.user_id LEFT JOIN " . DB_PREFIX . "referrals r ON r.rel_user_id= dlr.user_id and r.deal_id=dlr.deal_id and r.load_id=dlr.load_id and r.l_key = dlr.l_key WHERE u.pid >0 and dlr.has_repay=1 and (r.id is null or r.id >0) {$condtion} LIMIT " . ($p->firstRow . ',' . $p->listRows); $list = $GLOBALS['db']->getAll($sql); foreach ($list as $k => $v) { if ($v['pay_time'] == 0) { $res = pay_referrals($v['id']); if ($res) { save_log("ID:" . $v['id'] . l("REFERRALS_PAY_SUCCESS"), 1); } else { save_log("ID:" . $v['id'] . l("REFERRALS_PAY_FAILED"), 0); } } } } if ($p->nowPage >= $p->totalPages) { $this->success(l("REFERRALS_PAY_SUCCESS")); } else { register_shutdown_function(array(&$this, 'foreach_pay'), $page + 1); } }
public function update() { B('FilterString'); $data = M(MODULE_NAME)->create(); $log_info = M(MODULE_NAME)->where("id=" . intval($data['id']))->getField("name"); //开始验证有效性 $this->assign("jumpUrl", u(MODULE_NAME . "/edit", array("id" => $data['id']))); if (!check_empty($data['name'])) { $this->error(L("VOTE_NAME_EMPTY_TIP")); } $data['begin_time'] = trim($data['begin_time']) == '' ? 0 : to_timespan($data['begin_time']); $data['end_time'] = trim($data['end_time']) == '' ? 0 : to_timespan($data['end_time']); // 更新数据 $list = M(MODULE_NAME)->save($data); if (false !== $list) { //成功提示 save_log($log_info . L("UPDATE_SUCCESS"), 1); $this->success(L("UPDATE_SUCCESS")); } else { //错误提示 save_log($log_info . L("UPDATE_FAILED"), 0); $this->error(L("UPDATE_FAILED"), 0, $log_info . L("UPDATE_FAILED")); } }
public function export_csv($page = 1) { set_time_limit(0); $limit = ($page - 1) * intval(app_conf("BATCH_PAGE_SIZE")) . "," . intval(app_conf("BATCH_PAGE_SIZE")); $start_time = strim($_REQUEST['start_time']); $end_time = strim($_REQUEST['end_time']); $d = explode('-', $start_time); if (isset($_REQUEST['start_time']) && $start_time != "" && checkdate($d[1], $d[2], $d[0]) == false) { $this->error("开始时间不是有效的时间格式:{$start_time}(yyyy-mm-dd)"); exit; } $d = explode('-', $end_time); if (isset($_REQUEST['end_time']) && strim($end_time) != "" && checkdate($d[1], $d[2], $d[0]) == false) { $this->error("结束时间不是有效的时间格式:{$end_time}(yyyy-mm-dd)"); exit; } if ($start_time != "" && strim($end_time) != "" && to_timespan($start_time) > to_timespan($end_time)) { $this->error('开始时间不能大于结束时间:' . $start_time . '至' . $end_time); exit; } if ($limit) { $limit = " limit " . $limit; } $className = getCollName(); //环迅 if (strtolower($className) == "ips") { $condition = " and t.pErrCode = 'MG00000F' "; if (strim($_REQUEST['pBidNo']) != '') { $condition .= " and pBidNo like '%" . strim($_REQUEST['pBidNo']) . "%'"; } if (strim($_REQUEST['deal_name']) != '') { $condition .= " and d.name like '%" . strim($_REQUEST['deal_name']) . "%'"; } if (strim($_REQUEST['user_name']) != '') { $condition .= " and u.user_name like '%" . strim($_REQUEST['user_name']) . "%'"; } if (strim($start_time) != "") { $condition .= " and UNIX_TIMESTAMP(pDate) >=" . to_timespan(strim($start_time)); } if (strim($end_time) != "") { $condition .= " and UNIX_TIMESTAMP(pDate) <=" . to_timespan(strim($end_time)); } $sql = "select t.*,d.`name`,u.user_name,d.borrow_amount,\r\n\t\t\td.borrow_amount*CONVERT(d.services_fee,DECIMAL)*0.01 as deal_fee,\r\n\t\t\t(d.borrow_amount - (d.borrow_amount*CONVERT(d.services_fee,DECIMAL)*0.01)) as loan_amount\r\n\t\t\t from " . DB_PREFIX . "ips_transfer as t\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "deal as d on d.id = t.deal_id\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "user as u on u.id = d.user_id where t.pTransferType = 1 "; $count_sql = "select count(*) from " . DB_PREFIX . "ips_transfer as t\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "deal as d on d.id = t.deal_id\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "user as u on u.id = d.user_id where t.pTransferType = 1 "; //取得满足条件的记录数 $list = $GLOBALS['db']->getAll($sql . $condition . " order by id desc " . $limit); $list_count = $GLOBALS['db']->getOne($count_sql . $condition); //print_r($count);die; //$name=$this->getActionName(); } elseif (strtolower($className) == "yeepay") { $condition = " where bizType = 'TENDER' and is_complete_transaction = 1 and t.code ='1' and is_callback = 1 "; if (strim($_REQUEST['pBidNo']) != '') { $condition .= " and d.id like '%" . strim($_REQUEST['pBidNo']) . "%'"; } if (strim($_REQUEST['deal_name']) != '') { $condition .= " and d.name like '%" . strim($_REQUEST['deal_name']) . "%'"; } if (strim($_REQUEST['user_name']) != '') { $condition .= " and u.user_name like '%" . strim($_REQUEST['user_name']) . "%'"; } if (strim($start_time) != "") { $condition .= " and t.create_time >=" . to_timespan(strim($start_time)); } if (strim($end_time) != "") { $condition .= " and t.create_time <=" . to_timespan(strim($end_time)); } $sql = "select d.id,d.`name`,u.user_name,d.borrow_amount as borrow_amount,d.id as pBidNo,\r\n\t\t\td.borrow_amount*CONVERT(d.services_fee,DECIMAL)*0.01 as deal_fee,\r\n\t\t\t(d.borrow_amount - (d.borrow_amount*CONVERT(d.services_fee,DECIMAL)*0.01)) as loan_amount,\r\n\t\t\t1 as pTransferMode, requestNo as pIpsBillNo, FROM_UNIXTIME(t.update_time ,'%Y-%m-%d') as pIpsTime\r\n\t\t\t from " . DB_PREFIX . "yeepay_cp_transaction as t\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "deal as d on d.id = t.tenderOrderNo\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "user as u on u.id = d.user_id "; $count_sql = "select count(*) from " . DB_PREFIX . "yeepay_cp_transaction as t\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "deal as d on d.id = t.tenderOrderNo\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "user as u on u.id = d.user_id "; //取得满足条件的记录数 $list = $GLOBALS['db']->getAll($sql . $condition . " group by t.tenderOrderNo order by t.id desc " . $limit); $list_count = $GLOBALS['db']->getOne($count_sql . $condition); //print_r($count);die; //$name=$this->getActionName(); } elseif (strtolower($className) == "baofoo") { $condition = " where action_type = '2' and t.code ='CSD000' and is_callback = 1 "; if (strim($_REQUEST['pBidNo']) != '') { $condition .= " and d.id like '%" . strim($_REQUEST['pBidNo']) . "%'"; } if (strim($_REQUEST['deal_name']) != '') { $condition .= " and d.name like '%" . strim($_REQUEST['deal_name']) . "%'"; } if (strim($_REQUEST['user_name']) != '') { $condition .= " and u.user_name like '%" . strim($_REQUEST['user_name']) . "%'"; } if (strim($start_time) != "") { $condition .= " and (t.req_time/1000) >=" . to_timespan(strim($start_time)); } if (strim($end_time) != "") { $condition .= " and (t.req_time/1000) <=" . to_timespan(strim($end_time)); } $sql = "select d.id,d.`name`,u.user_name,d.borrow_amount as borrow_amount,d.id as pBidNo,\r\n\t\t\td.borrow_amount*CONVERT(d.services_fee,DECIMAL)*0.01 as deal_fee,\r\n\t\t\t(d.borrow_amount - (d.borrow_amount*CONVERT(d.services_fee,DECIMAL)*0.01)) as loan_amount,\r\n\t\t\t1 as pTransferMode, order_id as pIpsBillNo, FROM_UNIXTIME(t.req_time/1000 ,'%Y-%m-%d') as pIpsTime\r\n\t\t\t from " . DB_PREFIX . "baofoo_business as t\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "deal as d on d.id = t.cus_id\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "user as u on u.id = d.user_id "; $count_sql = "select count(*) from " . DB_PREFIX . "baofoo_business as t\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "deal as d on d.id = t.cus_id\r\n\t\t\tLEFT JOIN " . DB_PREFIX . "user as u on u.id = d.user_id "; //print_r($sql.$condition);die; //取得满足条件的记录数 $list = $GLOBALS['db']->getAll($sql . $condition . " group by t.cus_id order by id desc " . $limit); $list_count = $GLOBALS['db']->getOne($count_sql . $condition); } if ($list) { register_shutdown_function(array(&$this, 'export_csv'), $page + 1); $list_value_old = array('id' => '""', 'pBidNo' => '""', 'name' => '""', 'user_name' => '""', 'borrow_amount' => '""', 'deal_fee' => '""', 'loan_amount' => '""', 'pIpsTime' => '""'); if ($page == 1) { $content = iconv("utf-8", "gbk", "编号,标号,贷款名称,借款人,借款金额,成交服务费,放款金额,第三方处理时间"); $content = $content . "\n"; } foreach ($list as $k => $v) { $list_value = $list_value_old; $list_value["id"] = '"' . iconv('utf-8', 'gbk', $v['id']) . '"'; $list_value["name"] = '"' . iconv('utf-8', 'gbk', $v['name']) . '"'; $list_value["pBidNo"] = '"' . iconv('utf-8', 'gbk', $v["pBidNo"]) . '"'; $list_value["user_name"] = '"' . iconv('utf-8', 'gbk', $v["user_name"]) . '"'; $list_value["borrow_amount"] = '"' . iconv('utf-8', 'gbk', $v["borrow_amount"]) . '"'; $list_value["deal_fee"] = '"' . iconv('utf-8', 'gbk', $v["deal_fee"]) . '"'; $list_value["loan_amount"] = '"' . iconv('utf-8', 'gbk', $v["loan_amount"]) . '"'; $list_value["pIpsTime"] = '"' . iconv('utf-8', 'gbk', $v["pIpsTime"]) . '"'; $content .= implode(",", $list_value) . "\n"; } header("Content-Disposition: attachment; filename=order_list.csv"); echo $content; } else { if ($page == 1) { $this->error(L("NO_RESULT")); } } }
function ajax_calculate() { $deal['loantype'] = intval($_REQUEST['borrowpay']); $deal['borrow_amount'] = intval($_REQUEST['borrowamount']); $deal['repay_time'] = intval($_REQUEST['repaytime']); $deal['repay_time_type'] = intval($_REQUEST['repaytimetype']); $deal['rate'] = trim($_REQUEST['apr']); $deal['repay_start_time'] = to_timespan(to_date(TIME_UTC, "Y-m-d")); $deal_repay_rs = deal_repay_money($deal); $deal['month_repay_money'] = $deal_repay_rs['month_repay_money']; //总的必须还多少本息 $deal['remain_repay_money'] = $deal_repay_rs['remain_repay_money']; //最后一期还款 $deal['last_month_repay_money'] = $deal_repay_rs['last_month_repay_money']; $deal['month_manage_money'] = $deal['borrow_amount'] * (double) app_conf('MANAGE_FEE') / 100; //总的多少管理费 if ($deal['repay_time_type'] == 1) { $deal['all_manage_money'] = $deal['month_manage_money'] * $deal["repay_time"]; } else { $deal['all_manage_money'] = $deal['month_manage_money']; } $GLOBALS['tmpl']->assign("borrowpay", $deal['loantype']); $GLOBALS['tmpl']->assign("borrowamount", $deal['borrow_amount']); $GLOBALS['tmpl']->assign("apr", $deal['rate']); if ($deal['repay_time_type'] == 1) { $GLOBALS['tmpl']->assign("rate", $deal['rate'] / 12); } else { $GLOBALS['tmpl']->assign("rate", $deal['rate'] / 12 / 30); } $GLOBALS['tmpl']->assign("repaytime", $deal['repay_time']); $GLOBALS['tmpl']->assign("repaytimetype", $deal['repay_time_type']); $GLOBALS['tmpl']->assign("repayamount", $deal['month_repay_money']); $GLOBALS['tmpl']->assign("repayallamount", $deal['remain_repay_money']); $level = intval($_REQUEST['level']); $level_list = load_auto_cache("level"); $GLOBALS['tmpl']->assign("services_fee", $level_list['services_fee'][$level] / 100 * $deal['borrow_amount']); if ($deal['repay_time_type'] == 0) { $inrepayshow = 0; } else { $inrepayshow = intval($_REQUEST['inrepayshow']); } $impose_day = intval($_REQUEST['impose_day']); if (isset($_REQUEST['isshow']) && intval($_REQUEST['isshow']) == 1) { $loantype = $deal['loantype']; $LoanModule = LoadLoanModule($loantype); $list = $LoanModule->make_repay_plan($deal); if ($impose_day >= app_conf('YZ_IMPSE_DAY')) { $impose_fee = app_conf('IMPOSE_FEE_DAY2'); $manage_impose_fee = app_conf('MANAGE_IMPOSE_FEE_DAY2'); } else { $impose_fee = app_conf('IMPOSE_FEE_DAY1'); $manage_impose_fee = app_conf('MANAGE_IMPOSE_FEE_DAY1'); } $left_repay_money = $deal['remain_repay_money']; foreach ($list as $k => $v) { $list[$k]['impose_money'] = $v['repay_money'] * $impose_fee * $impose_day * 0.01; $list[$k]['manage_impose_money'] = $v['repay_money'] * $manage_impose_fee * $impose_day * 0.01; $list[$k]['left_repay_money'] = $left_repay_money = $left_repay_money - round($v['repay_money'], 2); } $GLOBALS['tmpl']->assign("list", $list); } //提前还款 if ($inrepayshow == 1) { $tq_list = array(); $deal['compensate_fee'] = app_conf('COMPENSATE_FEE'); for ($i = 0; $i < $deal['repay_time']; $i++) { $loaninfo['deal'] = $deal; if (is_last_repay($deal['loantype'])) { $loaninfo['deal']['month_manage_money'] = $deal['all_manage_money']; } $tq_list[$i] = inrepay_repay($loaninfo, $i, next_replay_month(TIME_UTC, $i + 1)); if (is_last_repay($deal['loantype'])) { $tq_list[$i]['month_repay_money'] = 0; $tq_list[$i]['month_repay_money'] = 0; if ($i + 1 == $deal['repay_time']) { $tq_list[$i]['manage_money'] = $deal['all_manage_money']; $tq_list[$i]['month_repay_money'] = $deal['last_month_repay_money']; } } else { $tq_list[$i]['manage_money'] = $deal['month_manage_money']; $tq_list[$i]['month_repay_money'] = $deal['month_repay_money']; if ($i + 1 == $deal['repay_time']) { $tq_list[$i]['month_repay_money'] = $deal['last_month_repay_money']; } } } $GLOBALS['tmpl']->assign("tq_list", $tq_list); } $GLOBALS['tmpl']->display("inc/tool/calculate_result.html"); }
public function index() { $GLOBALS['tmpl']->caching = true; $GLOBALS['tmpl']->cache_lifetime = 600; //首页缓存10分钟 $cache_id = md5(MODULE_NAME . ACTION_NAME); if (!$GLOBALS['tmpl']->is_cached("page/index.html", $cache_id)) { make_deal_cate_js(); make_delivery_region_js(); change_deal_status(); //开始输出友情链接 $f_link_group = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "link_group where is_effect = 1 order by sort desc"); foreach ($f_link_group as $k => $v) { $g_links = $GLOBALS['db']->getAll("select * from " . DB_PREFIX . "link where is_effect = 1 and show_index = 1 and group_id = " . $v['id'] . " order by sort desc"); if ($g_links) { foreach ($g_links as $kk => $vv) { if (substr($vv['url'], 0, 7) == 'http://') { $g_links[$kk]['url'] = str_replace("http://", "", $vv['url']); } } $f_link_group[$k]['links'] = $g_links; } else { unset($f_link_group[$k]); } } //最新借款列表 $deal_list = get_deal_list(11, 0, "publish_wait =0 AND deal_status in(1,2,4) ", " deal_status ASC,is_recommend DESC,sort DESC,id DESC"); $GLOBALS['tmpl']->assign("deal_list", $deal_list['list']); //输出最新转让 $transfer_list = get_transfer_list(11, " and d.deal_status >= 4 ", '', '', " d.create_time DESC , dlt.id DESC "); $GLOBALS['tmpl']->assign('transfer_list', $transfer_list['list']); //输出公告 $notice_list = get_notice(7); $GLOBALS['tmpl']->assign("notice_list", $notice_list); //输出公司动态 $art_id = $GLOBALS['db']->getOne("SELECT id FROM " . DB_PREFIX . "article_cate where title='公司动态'"); if ($art_id > 0) { $compnay_active_list = get_article_list(5, $art_id); $GLOBALS['tmpl']->assign("art_id", $art_id); $GLOBALS['tmpl']->assign("compnay_active_list", $compnay_active_list['list']); } //投资排行 //天 $now_time = to_timespan(to_date(TIME_UTC, "Y-m-d"), "Y-m-d"); $day_load_top_list = $GLOBALS['db']->getAll("SELECT * FROM (SELECT user_name,sum(money) as total_money FROM " . DB_PREFIX . "deal_load where create_time >= " . $now_time . " group by user_id ORDER BY total_money DESC) as tmp LIMIT 5"); //周 $week_time = to_timespan(to_date(TIME_UTC - to_date(TIME_UTC, "w") * 24 * 3600, "Y-m-d"), "Y-m-d"); $week_load_top_list = $GLOBALS['db']->getAll("SELECT * FROM (SELECT user_name,sum(money) as total_money FROM " . DB_PREFIX . "deal_load where create_time >= " . $week_time . " group by user_id ORDER BY total_money DESC) as tmp LIMIT 5 "); //月 $month_time = to_timespan(to_date(TIME_UTC, "Y-m") . "-01", "Y-m-d"); $month_load_top_list = $GLOBALS['db']->getAll("SELECT * FROM (SELECT user_name,sum(money) as total_money FROM " . DB_PREFIX . "deal_load where create_time >= " . $month_time . " group by user_id ORDER BY total_money DESC) as tmp LIMIT 5"); $GLOBALS['tmpl']->assign("day_load_top_list", $day_load_top_list); $GLOBALS['tmpl']->assign("week_load_top_list", $week_load_top_list); $GLOBALS['tmpl']->assign("month_load_top_list", $month_load_top_list); //收益排名 $load_repay_list = $GLOBALS['db']->getAll("SELECT us.*,u.user_name FROM " . DB_PREFIX . "user_sta us LEFT JOIN " . DB_PREFIX . "user u ON us.user_id=u.id WHERE u.is_effect =1 and u.is_delete=0 and us.load_earnings > 0 ORDER BY us.load_earnings DESC LIMIT 5"); $GLOBALS['tmpl']->assign("load_repay_list", $load_repay_list); //使用技巧 $use_tech_list = get_article_list(12, 6); $GLOBALS['tmpl']->assign("use_tech_list", $use_tech_list); $now = TIME_UTC; $vote = $GLOBALS['db']->getRow("select * from " . DB_PREFIX . "vote where is_effect = 1 and begin_time < " . $now . " and (end_time = 0 or end_time > " . $now . ") order by sort desc limit 1"); $GLOBALS['tmpl']->assign("vote", $vote); $GLOBALS['tmpl']->assign("f_link_data", $f_link_group); //累计投资金额 $stats['total_load'] = $GLOBALS['db']->getOne("SELECT sum(money) FROM " . DB_PREFIX . "deal_load where is_repay= 0 "); $stats['total_load_format'] = format_conf_count(number_format($stats['total_load'], 2)); //成交笔数 $stats['deal_total_count'] = $GLOBALS['db']->getOne("SELECT count(*) FROM " . DB_PREFIX . "deal where deal_status >=4 "); //累计创造收益 $stats['total_rate'] = $GLOBALS['db']->getOne("SELECT sum(repay_money-self_money) FROM " . DB_PREFIX . "deal_load_repay where has_repay = 1 "); $stats['total_rate_format'] = format_conf_count(number_format($stats['total_rate'], 2)); //本息保证金(元) $stats['total_bzh'] = $GLOBALS['db']->getOne("SELECT sum(guarantor_real_freezen_amt+real_freezen_amt) FROM " . DB_PREFIX . "deal where deal_status= 4 "); $stats['total_bzh_format'] = format_conf_count(number_format($stats['total_bzh'], 2)); //待收资金(元) $stats['total_repay'] = $GLOBALS['db']->getOne("SELECT sum(repay_money) FROM " . DB_PREFIX . "deal_load_repay where has_repay = 1 "); $stats['total_repay_format'] = format_conf_count(number_format($stats['total_repay'], 2)); //待投资金(元) $statsU = $GLOBALS['db']->getRow("SELECT sum(money) as total_usermoney ,count(*) total_user FROM " . DB_PREFIX . "user where is_effect = 1 and is_delete=0 "); $stats['total_usermoney'] = $statsU['total_usermoney']; $stats['total_usermoney_format'] = format_conf_count(number_format($stats['total_usermoney'], 2)); $stats['total_user'] = $statsU['total_user']; $GLOBALS['tmpl']->assign("stats", $stats); //格式化统计代码 $VIRTUAL_MONEY_1_FORMAT = format_conf_count(floatval(trim(app_conf("VIRTUAL_MONEY_1"))) + $stats['total_load']); $VIRTUAL_MONEY_2_FORMAT = format_conf_count(floatval(trim(app_conf("VIRTUAL_MONEY_2"))) + $stats['total_rate']); $VIRTUAL_MONEY_3_FORMAT = format_conf_count(floatval(trim(app_conf("VIRTUAL_MONEY_3"))) + $stats['total_bzh']); $GLOBALS['tmpl']->assign("VIRTUAL_MONEY_1_FORMAT", $VIRTUAL_MONEY_1_FORMAT); $GLOBALS['tmpl']->assign("VIRTUAL_MONEY_2_FORMAT", $VIRTUAL_MONEY_2_FORMAT); $GLOBALS['tmpl']->assign("VIRTUAL_MONEY_3_FORMAT", $VIRTUAL_MONEY_3_FORMAT); $GLOBALS['tmpl']->assign("show_site_titile", 1); } $GLOBALS['tmpl']->display("page/index.html", $cache_id); }
public function get_invest_stroke($user_id) { $result = array(); if (!$user_id) { $user_id = intval($GLOBALS['user_info']['id']); } else { $user_id = intval($user_id); } $x_axis_labels = array(); $elements_values = array(); $m_info = array(); for ($i = 5; $i >= 0; $i--) { if ($i == 5) { $y_m = to_date(NOW_TIME, "Y-m"); $start_day = $y_m . "-1"; $next_m = to_date(NOW_TIME, "n") + 1; $now_year = to_date(NOW_TIME, "Y"); $next = $now_year . "-" . $next_m . "-1"; $m_info['start'] = to_timespan($start_day, 'Y-m-d'); $m_info['end'] = to_timespan($next, "Y-n-d") - 1; $m_info['next_start'] = $m_info['start']; $m_info['all_end'] = $m_info['end']; $x_axis_labels[$i] = to_date(NOW_TIME, "Y-m"); } else { $m_info['end'] = $m_info['next_start'] - 1; $y_m = to_date($m_info['end'], "Y-m"); $m_info['start'] = to_timespan($y_m . "-1", 'Y-m-d'); $m_info['next_start'] = $m_info['start']; if ($i == 1) { $m_info['all_start'] = $m_info['start']; } $x_axis_labels[$i] = $y_m; } $m_price = floatval($GLOBALS['db']->getOne("select sum(price) from " . DB_PREFIX . "deal_support_log where user_id=" . $user_id . " and create_time > " . $m_info['start'] . " and create_time < " . $m_info['end'] . " ")); $elements_values[$i] = array("top" => $m_price, "tip" => $y_m . "月<br>投资" . format_price($m_price)); } ksort($elements_values); ksort($x_axis_labels); $price_all = $GLOBALS['db']->getOne("select sum(price) from " . DB_PREFIX . "deal_support_log where user_id=" . $user_id . " and create_time >" . $m_info['all_start'] . " and create_time < " . $m_info['all_end'] . ""); if ($price_all > 100) { $max = ceil($price_all / 100) * 100; $max += ceil($max * 0.1 / 100) * 100; } elseif ($price_all < 100 && $price_all > 0) { $max = ceil($price_all / 100) * 100 + 200; } else { $max = 1000; } $result['bg_colour'] = "#ffffff"; $result["x_axis"] = array("stroke" => "1", "tick_height" => "10", "colour" => "#000", "grid_colour" => "#000", "labels" => array("labels" => $x_axis_labels)); $result["elements"] = array(array("type" => "bar", "alpha" => 0.8, "colour" => "#3d9eeb", "values" => $elements_values)); $result["y_axis"] = array("stroke" => "1", "tick_length" => "3", "colour" => "#000", "grid_colour" => "#000", "max" => $max); $result["title"] = array("text" => "半年内总投资额" . format_price($price_all), "style" => "{font-size: 14px; color:#333; font-family: 'Microsoft Yahei','FAE\\8F6F\\96C5\\9ED1',Arial,'Hiragino Sans GB','B8BF53'; text-align: right; padding:10px 0px 10px 0px;}"); //print_r($result); ajax_return($result); }
public function shop_update() { B('FilterString'); $data = M(MODULE_NAME)->create(); //对于商户请求操作 if (intval($_REQUEST['edit_type']) == 2 && intval($_REQUEST['deal_id']) > 0) { //商户提交修改审核 $deal_submit_id = intval($_REQUEST['id']); $data['id'] = intval($_REQUEST['deal_id']); } $log_info = M(MODULE_NAME)->where("id=" . intval($data['id']))->getField("name"); //开始验证有效性 $this->assign("jumpUrl", u(MODULE_NAME . "/shop_edit", array("id" => $data['id']))); if ($data['buy_type'] == 0) { if (intval($data['return_score']) < 0) { $this->error("积分返还不能为负数"); } if (floatval($data['return_money']) < 0) { $this->error("现金返还不能为负数"); } } else { $data['return_score'] = "-" . abs($_REQUEST['deal_score']); if (intval($_REQUEST['deal_score']) == 0) { $this->error("请输入所需的积分"); } } if (!check_empty($data['name'])) { $this->error(L("DEAL_NAME_EMPTY_TIP")); } if (!check_empty($data['sub_name'])) { $this->error(L("DEAL_SUB_NAME_EMPTY_TIP")); } if ($data['shop_cate_id'] == 0) { $this->error(L("SHOP_CATE_EMPTY_TIP")); } if ($data['max_bought'] < 0) { $this->error(L("DEAL_MAX_BOUGHT_ERROR_TIP")); } if ($data['user_min_bought'] < 0) { $this->error(L("DEAL_USER_MIN_BOUGHT_ERROR_TIP")); } if ($data['user_max_bought'] < 0) { $this->error(L("DEAL_USER_MAX_BOUGHT_ERROR_TIP")); } if ($data['user_max_bought'] < $data['user_min_bought'] && $data['user_max_bought'] > 0) { $this->error(L("DEAL_USER_MAX_MIN_BOUGHT_ERROR_TIP")); } if ($data['brand_promote'] == 1) { //品牌促销 $brand_info = M("Brand")->getById($data['brand_id']); if ($brand_info['brand_promote'] == 1) { $data['begin_time'] = $brand_info['begin_time']; $data['end_time'] = $brand_info['end_time']; } } else { $data['begin_time'] = strim($data['begin_time']) == '' ? 0 : to_timespan($data['begin_time']); $data['end_time'] = strim($data['end_time']) == '' ? 0 : to_timespan($data['end_time']); } $data['coupon_begin_time'] = strim($data['coupon_begin_time']) == '' ? 0 : to_timespan($data['coupon_begin_time']); $data['coupon_end_time'] = strim($data['coupon_end_time']) == '' ? 0 : to_timespan($data['coupon_end_time']); //将第一张图片设为团购图片 $imgs = $_REQUEST['img']; foreach ($imgs as $k => $v) { if ($v != '') { $data['img'] = $v; break; } } $data['update_time'] = NOW_TIME; $data['publish_wait'] = 0; if (intval($data['is_coupon']) == 1 && intval($data['is_refund']) == 1) { $data['expire_refund'] = intval($_REQUEST['expire_refund']); $data['any_refund'] = intval($_REQUEST['any_refund']); } else { $data['expire_refund'] = 0; $data['any_refund'] = 0; } if ($_REQUEST['deal_attr'] && count($_REQUEST['deal_attr']) > 0) { $data['multi_attr'] = 1; } else { $data['multi_attr'] = 0; } if ($data['buy_type'] != 1) { $deal_tags = $_REQUEST['deal_tag']; $deal_tag = 0; foreach ($deal_tags as $t) { $t2 = pow(2, $t); $deal_tag = $deal_tag | $t2; } $data['deal_tag'] = $deal_tag; } else { $data['deal_tag'] = 0; } $data['is_lottery'] = 0; foreach ($deal_tags as $t) { if ($t == 0) { $data['is_lottery'] = 1; } } if ($data['buy_type'] == 1) { $data['cart_type'] = 3; $data['is_refund'] = 0; $data['deal_tag'] = 0; $data['is_lottery'] = 0; } $inc_prices = $_REQUEST['inc_price']; if (isset($_REQUEST['level_ids'])) { //无数据 $level_ids = $_REQUEST['level_ids']; foreach ($level_ids as $key => $value) { $deal_tech_level = array('level_id' => $value, 'deal_id' => $data['id'], 'price' => $inc_prices[$key], 'createtime' => time()); M('dealTechLevel')->add($deal_tech_level); } } elseif ($_REQUEST['deal_tech_level_ids']) { //有数据 $deal_tech_level_ids = $_REQUEST['deal_tech_level_ids']; foreach ($deal_tech_level_ids as $key => $value) { $deal_tech_level = array('id' => $value, 'price' => $inc_prices[$key], 'createtime' => time()); M('dealTechLevel')->save($deal_tech_level); } } // 更新数据 $list = M(MODULE_NAME)->save($data); if (false !== $list) { $GLOBALS['db']->query("update " . DB_PREFIX . "deal_coupon set expire_refund = " . $data['expire_refund'] . ",any_refund = " . $data['any_refund'] . ",supplier_id=" . $data['supplier_id'] . ",end_time=" . $data['coupon_end_time'] . ",begin_time=" . $data['coupon_begin_time'] . " where deal_id = " . $data['id']); //开始处理图片 M("DealGallery")->where("deal_id=" . $data['id'])->delete(); $imgs = $_REQUEST['img']; foreach ($imgs as $k => $v) { if ($v != '') { $img_data['deal_id'] = $data['id']; $img_data['img'] = $v; $img_data['sort'] = $k; M("DealGallery")->add($img_data); } } //end 处理图片 //开始处理属性 M("DealAttr")->where("deal_id=" . $data['id'])->delete(); $deal_attr = $_REQUEST['deal_attr']; $deal_attr_price = $_REQUEST['deal_attr_price']; $deal_add_balance_price = $_REQUEST['deal_add_balance_price']; $deal_attr_stock_hd = $_REQUEST['deal_attr_stock_hd']; foreach ($deal_attr as $goods_type_attr_id => $arr) { foreach ($arr as $k => $v) { if ($v != '') { $deal_attr_item['deal_id'] = $data['id']; $deal_attr_item['goods_type_attr_id'] = $goods_type_attr_id; $deal_attr_item['name'] = $v; $deal_attr_item['add_balance_price'] = $deal_add_balance_price[$goods_type_attr_id][$k]; $deal_attr_item['price'] = $deal_attr_price[$goods_type_attr_id][$k]; $deal_attr_item['is_checked'] = intval($deal_attr_stock_hd[$goods_type_attr_id][$k]); M("DealAttr")->add($deal_attr_item); } } } //开始创建属性库存 M("AttrStock")->where("deal_id=" . $data['id'])->delete(); $stock_cfg = $_REQUEST['stock_cfg_num']; $attr_cfg = $_REQUEST['stock_attr']; $attr_str = $_REQUEST['stock_cfg']; foreach ($stock_cfg as $row => $v) { $stock_data = array(); $stock_data['deal_id'] = $data['id']; $stock_data['stock_cfg'] = $v; $stock_data['attr_str'] = $attr_str[$row]; $attr_cfg_data = array(); foreach ($attr_cfg as $attr_id => $cfg) { $attr_cfg_data[$attr_id] = $cfg[$row]; } $stock_data['attr_cfg'] = serialize($attr_cfg_data); $sql = "select sum(oi.number) from " . DB_PREFIX . "deal_order_item as oi left join " . DB_PREFIX . "deal as d on d.id = oi.deal_id left join " . DB_PREFIX . "deal_order as do on oi.order_id = do.id where" . " do.pay_status = 2 and do.is_delete = 0 and d.id = " . $data['id'] . " and oi.attr_str like '%" . $attr_str[$row] . "%'"; $stock_data['buy_count'] = intval($GLOBALS['db']->getOne($sql)); M("AttrStock")->add($stock_data); } M("FreeDelivery")->where("deal_id=" . $data['id'])->delete(); if (intval($_REQUEST['free_delivery']) == 1) { $delivery_ids = $_REQUEST['delivery_id']; $free_counts = $_REQUEST['free_count']; foreach ($delivery_ids as $k => $v) { $free_conf = array(); $free_conf['delivery_id'] = $delivery_ids[$k]; $free_conf['free_count'] = $free_counts[$k]; $free_conf['deal_id'] = $data['id']; M("FreeDelivery")->add($free_conf); } } M("DealPayment")->where("deal_id=" . $data['id'])->delete(); if (intval($_REQUEST['define_payment']) == 1) { $payment_ids = $_REQUEST['payment_id']; foreach ($payment_ids as $k => $v) { $payment_conf = array(); $payment_conf['payment_id'] = $payment_ids[$k]; $payment_conf['deal_id'] = $data['id']; M("DealPayment")->add($payment_conf); } } M("DealDelivery")->where("deal_id=" . $data['id'])->delete(); $delivery_ids = $_REQUEST['forbid_delivery_id']; foreach ($delivery_ids as $k => $v) { $delivery_conf = array(); $delivery_conf['delivery_id'] = $delivery_ids[$k]; $delivery_conf['deal_id'] = $data['id']; M("DealDelivery")->add($delivery_conf); } //开始创建筛选项 M("DealFilter")->where("deal_id=" . $data['id'])->delete(); $filter = $_REQUEST['filter']; foreach ($filter as $filter_group_id => $filter_value) { $filter_data = array(); $filter_data['filter'] = $filter_value; $filter_data['filter_group_id'] = $filter_group_id; $filter_data['deal_id'] = $data['id']; M("DealFilter")->add($filter_data); // $filter_array = preg_split("/[ ,]/i",$filter_value); // foreach($filter_array as $filter_item) // { // $filter_row = M("Filter")->where("filter_group_id = ".$filter_group_id." and name = '".$filter_item."'")->find(); // if(!$filter_row) // { // if(strim($filter_item)!='') // { // $filter_row = array(); // $filter_row['name'] = $filter_item; // $filter_row['filter_group_id'] = $filter_group_id; // M("Filter")->add($filter_row); // } // // } // } } M("DealLocationLink")->where("deal_id=" . $data['id'])->delete(); foreach ($_REQUEST['location_id'] as $location_id) { $link_data = array(); $link_data['location_id'] = $location_id; $link_data['deal_id'] = $data['id']; M("DealLocationLink")->add($link_data); } //成功提示 syn_deal_status($data['id']); syn_deal_match($data['id']); syn_attr_stock_key($data['id']); //对于商户请求操作 if (intval($_REQUEST['edit_type']) == 2 && $deal_submit_id > 0) { //商户提交修改审核 /*同步商户发布表状态*/ $GLOBALS['db']->autoExecute(DB_PREFIX . "deal_submit", array("admin_check_status" => 1), "UPDATE", "id=" . $deal_submit_id); // 1 通过 2 拒绝', } //成功提示 save_log($log_info . L("UPDATE_SUCCESS"), 1); $this->success(L("UPDATE_SUCCESS")); } else { //错误提示 $dbErr = M()->getDbError(); save_log($log_info . L("UPDATE_FAILED") . $dbErr, 0); $this->error(L("UPDATE_FAILED") . $dbErr, 0); } }
public function update_sms() { //开始验证 if (intval($_REQUEST['sms_type']) == 0) { if ($_REQUEST['content'] == '') { $this->error(L("SMS_CONTENT_EMPTY_TIP")); } } else { if (intval($_REQUEST['deal_id']) == 0 || M("Deal")->where("is_delete=0 and id =" . intval($_REQUEST['deal_id']))->count() == 0) { $this->error(l("DEAL_ID_ERROR")); } } if (intval($_REQUEST['send_type']) == 2) { if ($_REQUEST['send_define_data'] == '') { $this->error(l("SEND_DEFINE_DATE_EMPTY_TIP")); } } $msg_data['type'] = 0; $msg_data['content'] = $_REQUEST['content']; if ($_REQUEST['sms_type'] == 1) { if ($msg_data['content'] == '') { $msg_data['content'] = get_deal_sms_content(intval($_REQUEST['deal_id'])); } } $msg_data['send_time'] = strim($_REQUEST['send_time']) == '' ? NOW_TIME : to_timespan($_REQUEST['send_time']); $msg_data['deal_id'] = intval($_REQUEST['deal_id']); $msg_data['send_type'] = intval($_REQUEST['send_type']); switch ($msg_data['send_type']) { case 0: //会员组 $msg_data['send_type_id'] = intval($_REQUEST['group_id']); break; case 1: //订阅城市 $msg_data['send_type_id'] = intval($_REQUEST['city_id']); break; case 2: //自定义号码 $msg_data['send_type_id'] = 0; break; } $msg_data['send_define_data'] = $_REQUEST['send_define_data']; $msg_data['id'] = intval($_REQUEST['id']); if (intval($_REQUEST['resend']) == 1) { $msg_data['send_status'] = 0; M("PromoteMsgList")->where("msg_id=" . intval($msg_data['id']))->delete(); } $rs = M("PromoteMsg")->save($msg_data); if ($rs) { save_log($msg_data['content'] . L("UPDATE_SUCCESS"), 1); $this->success(L("UPDATE_SUCCESS")); } else { $this->error(L("UPDATE_FAILED")); } }
function get_licai_status($id) { $vo = $GLOBALS["db"]->getRow("select * from " . DB_PREFIX . "licai where id =" . $id); if (!$vo) { return ""; } $time = get_peizi_next_date(to_timespan($vo["begin_interest_date"]), $vo['begin_buy_date']); if (NOW_TIME < to_timespan($time)) { $status = 0; } elseif ($vo["end_date"] == "" || ($vo["end_date"] = "0000-00-00" || NOW_TIME <= to_timespan($vo["end_date"]) && NOW_TIME >= to_timespan($time))) { $status = 1; } elseif (NOW_TIME > to_timespan($vo["end_date"])) { $status = 3; } return $status; }
public function export_csv_deal_info($page = 1) { set_time_limit(0); $limit = ($page - 1) * intval(app_conf("BATCH_PAGE_SIZE")) . "," . intval(app_conf("BATCH_PAGE_SIZE")); //pay_status 1 已还款、2待还款、3逾期还款 $pay_status = intval(trim($_REQUEST['pay_status'])); $time = trim($_REQUEST['time']); if (trim($_REQUEST['id']) != '') { $id = intval(trim($_REQUEST['id'])); } if (trim($_REQUEST['user_name']) != '') { $user_name = trim($_REQUEST['user_name']); } if (trim($_REQUEST['deal_sn']) != '') { $deal_sn = trim($_REQUEST['deal_sn']); } if (trim($_REQUEST['sub_name']) != '') { $sub_name = trim($_REQUEST['sub_name']); } if (trim($_REQUEST['has_repay']) != '') { $has_repay = trim($_REQUEST['has_repay']); } $begin_time = trim($_REQUEST['begin_time']) == '' ? 0 : to_timespan($_REQUEST['begin_time']); $end_time = trim($_REQUEST['end_time']) == '' ? 0 : to_timespan($_REQUEST['end_time']); $condtion = " (a.repay_date ='{$time}' )"; if ($pay_status == 3) { $where = "((has_repay = 1 and a.true_repay_time > a.repay_time) or (has_repay = 0 and a.repay_time < " . TIME_UTC . ")) and a.repay_date ='{$time}' "; // $where="((has_repay = 1 and a.true_repay_date ='$time' "; } elseif ($pay_status == 2) { $where = "a.has_repay = 0 and {$condtion} "; } elseif ($pay_status == 1) { $where = " a.has_repay =1 and (a.true_repay_date ='{$time}') "; } else { $where = "1=1"; } $sql_str = "select a.id as hkID,\n\t\tu.user_name as jkr,\n\t\tb.deal_sn as jkbsm,\n\t\tb.sub_name as jkbt,\n\t\tCONCAT('第',a.l_key + 1,'期') as jkqs,\n\t\tc.`name` as jklx,\n\t\tFROM_UNIXTIME(a.repay_time + 28800, '%Y-%m-%d') as yhsj,\n\t\ta.repay_money as yhbx,\n\t\ta.manage_money as glfy,\n\t\ta.impose_money + a.manage_impose_money as fx,\n\t\tcase has_repay\n\t\twhen 0 then 0\n\t\twhen 1 then \n\t\ta.repay_money + a.impose_money + a.manage_impose_money + a.manage_money\n\t\twhen 2 then \n\t\t (select sum(repay_money + impose_money + repay_manage_money + repay_manage_impose_money) from " . DB_PREFIX . "deal_load_repay l where l.has_repay = 1 and l.deal_id = a.deal_id and l.repay_id = a.id)\n\t\telse \n\t\t '0'\n\t\tend as shze,\n\t\tif (datediff(FROM_UNIXTIME(a.true_repay_time + 28800, '%Y-%m-%d'),FROM_UNIXTIME(a.repay_time + 28800, '%Y-%m-%d')) > 0, \n\t\tdatediff(FROM_UNIXTIME(a.true_repay_time + 28800, '%Y-%m-%d'),FROM_UNIXTIME(a.repay_time + 28800, '%Y-%m-%d')),\n\t\t0) as yqts, \n\t\tFROM_UNIXTIME(a.true_repay_time + 28800, '%Y-%m-%d') as shsj,\n\t\tcase has_repay\n\t\twhen 0 then '未还'\n\t\twhen 1 then '已还'\n\t\twhen 2 then '部分还款'\n\t\telse \n\t\t '已收款'\n\t\tend as zt,\n\t\tif(is_site_bad = 1,'是','否') as sfhz,\n\t\ta.deal_id as deal_id\n\t\tfrom " . DB_PREFIX . "deal_repay as a\n\t\tleft join " . DB_PREFIX . "user u on u.id = a.user_id\n\t\tLEFT JOIN " . DB_PREFIX . "deal b on b.id = a.deal_id\n\t\tLEFT JOIN " . DB_PREFIX . "deal_cate c on c.id = b.cate_id\n\t\twhere {$where}"; if ($id) { $sql_str .= " and a.id = '{$id}'"; } if ($user_name) { $sql_str .= " and u.user_name like '%{$user_name}%'"; } if ($deal_sn) { $sql_str .= " and b.deal_sn like '%{$deal_sn}%'"; } if ($sub_name) { $sql_str .= " and b.sub_name like '%{$sub_name}%'"; } if (isset($_REQUEST['has_repay'])) { if ($has_repay == 4) { //$sql_str .="$sql_str"; } elseif ($has_repay == 3) { $sql_str .= " and has_repay = 0 "; } else { $sql_str .= " and has_repay = '{$has_repay}'"; } } //echo"$has_repay"; if ($begin_time > 0 || $end_time > 0) { if ($begin_time > 0 && $end_time == 0) { $sql_str .= " and (a.repay_time > {$begin_time})"; } elseif ($begin_time == 0 && $end_time > 0) { $sql_str .= " and (a.repay_time < {$end_time} )"; } elseif ($begin_time > 0 && $end_time > 0) { $sql_str .= " and (a.repay_time between {$begin_time} and {$end_time} )"; } } $sql_str .= " limit {$limit} "; $list = array(); $list = $GLOBALS['db']->getAll($sql_str); // echo $sql_str; // exit; // var_dump($list);exit; if ($list) { register_shutdown_function(array(&$this, 'export_csv_deal_info'), $page + 1); $deal_info_value = array('hkID' => '""', 'jkr' => '""', 'jkbsm' => '""', 'jkbt' => '""', 'jkqs' => '""', 'jklx' => '""', 'yhsj' => '""', 'yhbx' => '""', 'glfy' => '""', 'fx' => '""', 'shze' => '""', 'yqts' => '""', 'shsj' => '""', 'zt' => '""', 'sfhz' => '""'); if ($page == 1) { $content_deal_info = iconv("utf-8", "gbk", "还款ID,借款人,借款标识名,借款标题,借款期数,借款类型,应还时间,应还本息,管理费用,罚息,实还总额,逾期天数,实还时间,状态,是否坏账"); } if ($page == 1) { $content_deal_info = $content_deal_info . "\n"; } foreach ($list as $k => $v) { $deal_info_value = array(); $deal_info_value['hkID'] = iconv('utf-8', 'gbk', '"' . $v['hkID'] . '"'); $deal_info_value['jkr'] = iconv('utf-8', 'gbk', '"' . $v['jkr'] . '"'); $deal_info_value['jkbsm'] = iconv('utf-8', 'gbk', '"' . $v['jkbsm'] . '"'); $deal_info_value['jkbt'] = iconv('utf-8', 'gbk', '"' . $v['jkbt'] . '"'); $deal_info_value['jkqs'] = iconv('utf-8', 'gbk', '"' . $v['jkqs'] . '"'); $deal_info_value['jklx'] = iconv('utf-8', 'gbk', '"' . $v['jklx'] . '"'); $deal_info_value['yhsj'] = iconv('utf-8', 'gbk', '"' . $v['yhsj'] . '"'); $deal_info_value['yhbx'] = iconv('utf-8', 'gbk', '"' . number_format($v['yhbx'], 2) . '"'); $deal_info_value['glfy'] = iconv('utf-8', 'gbk', '"' . number_format($v['glfy'], 2) . '"'); $deal_info_value['fx'] = iconv('utf-8', 'gbk', '"' . number_format($v['fx'], 2) . '"'); $deal_info_value['shze'] = iconv('utf-8', 'gbk', '"' . number_format($v['shze'], 2) . '"'); $deal_info_value['yqts'] = iconv('utf-8', 'gbk', '"' . $v['yqts'] . '"'); $deal_info_value['shsj'] = iconv('utf-8', 'gbk', '"' . $v['shsj'] . '"'); $deal_info_value['zt'] = iconv('utf-8', 'gbk', '"' . $v['zt'] . '"'); $deal_info_value['sfhz'] = iconv('utf-8', 'gbk', '"' . $v['sfhz'] . '"'); $content_deal_info .= implode(",", $deal_info_value) . "\n"; } header("Content-Disposition: attachment; filename=deal_info_list.csv"); echo $content_deal_info; } else { if ($page == 1) { $this->error(L("NO_RESULT")); } } }
public function update() { B('FilterString'); $data = M(MODULE_NAME)->create(); $log_info = M(MODULE_NAME)->where("id=" . intval($data['id']))->getField("name"); //开始验证有效性 $this->assign("jumpUrl", u(MODULE_NAME . "/edit", array("id" => $data['id']))); if (!check_empty($data['name'])) { $this->error(L("BRAND_NAME_EMPTY_TIP")); } $data['begin_time'] = trim($data['begin_time']) == '' ? 0 : to_timespan($data['begin_time']); $data['end_time'] = trim($data['end_time']) == '' ? 0 : to_timespan($data['end_time']); // 更新数据 $list = M(MODULE_NAME)->save($data); if (false !== $list) { //同步更新所有的产品 M("Deal")->where("brand_id=" . $data['id'] . " and brand_promote = 1")->setField("begin_time", $data['begin_time']); M("Deal")->where("brand_id=" . $data['id'] . " and brand_promote = 1")->setField("end_time", $data['end_time']); //成功提示 syn_brand_status($data['id']); clear_auto_cache("static_goods_info"); save_log($log_info . L("UPDATE_SUCCESS"), 1); $this->success(L("UPDATE_SUCCESS")); } else { //错误提示 save_log($log_info . L("UPDATE_FAILED"), 0); $this->error(L("UPDATE_FAILED"), 0, $log_info . L("UPDATE_FAILED")); } }
public function export_csv($page = 1) { set_time_limit(0); $limit = ($page - 1) * intval(app_conf("BATCH_PAGE_SIZE")) . "," . intval(app_conf("BATCH_PAGE_SIZE")); $sql = "select t.*,d.`name`,u.user_name from " . DB_PREFIX . "ips_transfer as t\nLEFT JOIN " . DB_PREFIX . "deal as d on d.id = t.deal_id\nLEFT JOIN " . DB_PREFIX . "user as u on u.id = d.user_id where t.pTransferType = 1 "; if (strim($_REQUEST['pMerCode']) != '') { $condition .= " and t.pMerCode like '%" . strim($_REQUEST['pMerCode']) . "%'"; } if (strim($_REQUEST['pMerBillNo']) != '') { $condition .= " and t.pMerBillNo like '%" . strim($_REQUEST['pMerBillNo']) . "%'"; } if (strim($_REQUEST['pBidNo']) != '') { $condition .= " and t.pBidNo like '%" . strim($_REQUEST['pBidNo']) . "%'"; } if (isset($_REQUEST['pTransferType']) && intval(strim($_REQUEST['pTransferType'])) != -1) { $condition .= " and t.pTransferType = " . intval(strim($_REQUEST['pTransferType'])); } if (isset($_REQUEST['pTransferMode']) && intval(strim($_REQUEST['pTransferMode'])) != -1) { $condition .= " and t.pTransferMode = " . intval(strim($_REQUEST['pTransferMode'])); } if (isset($_REQUEST['pIpsBillNo']) && strim($_REQUEST['pIpsBillNo']) != "") { $condition .= " and t.pIpsBillNo = " . strim($_REQUEST['pIpsBillNo']); } $start_time = strim($_REQUEST['start_time']); $end_time = strim($_REQUEST['end_time']); $d = explode('-', $start_time); if (isset($_REQUEST['start_time']) && $start_time != "" && checkdate($d[1], $d[2], $d[0]) == false) { $this->error("开始时间不是有效的时间格式:{$start_time}(yyyy-mm-dd)"); exit; } $d = explode('-', $end_time); if (isset($_REQUEST['end_time']) && strim($end_time) != "" && checkdate($d[1], $d[2], $d[0]) == false) { $this->error("结束时间不是有效的时间格式:{$end_time}(yyyy-mm-dd)"); exit; } if ($start_time != "" && strim($end_time) != "" && to_timespan($start_time) > to_timespan($end_time)) { $this->error('开始时间不能大于结束时间:' . $start_time . '至' . $end_time); exit; } if (strim($start_time) != "") { $condition .= " and UNIX_TIMESTAMP(pDate) >=" . to_timespan(strim($start_time)); } if (strim($end_time) != "") { $condition .= " and UNIX_TIMESTAMP(pDate) <=" . to_timespan(strim($end_time)); } $list = $GLOBALS['db']->getAll($sql . $condition . " limit " . $limit); if ($list) { register_shutdown_function(array(&$this, 'export_csv'), $page + 1); $list_value_old = array('id' => '""', 'name' => '""', 'ref_data' => '""', 'pMerCode' => '""', 'pMerBillNo' => '""', 'pBidNo' => '""', 'pDate' => '""', 'pTransferType' => '""', 'pTransferMode' => '""', 'pMemo1' => '""', 'pMemo2' => '""', 'pMemo3' => '""', 'pIpsBillNo' => '""', 'pIpsTime' => '""', 'user_name' => '""'); if ($page == 1) { $content = iconv("utf-8", "gbk", "编号,贷款名称,参考,平台账号,商户开户流水号,标的号,商户日期,转账类型,转账方式,备注1,备注2,备注3,IPS订单号,IPS处理时间,借款人"); $content = $content . "\n"; } foreach ($list as $k => $v) { $list_value = $list_value_old; $list_value["id"] = '"' . iconv('utf-8', 'gbk', $v['id']) . '"'; $list_value["name"] = '"' . iconv('utf-8', 'gbk', $v['name']) . '"'; $list_value["ref_data"] = '"' . iconv('utf-8', 'gbk', $v["ref_data"]) . '"'; $list_value["pMerCode"] = '"' . iconv('utf-8', 'gbk', $v["pMerCode"]) . '"'; $list_value["pMerBillNo"] = '"' . iconv('utf-8', 'gbk', $v["pMerBillNo"]) . '"'; $list_value["pBidNo"] = '"' . iconv('utf-8', 'gbk', $v["pBidNo"]) . '"'; $list_value["pDate"] = '"' . iconv('utf-8', 'gbk', $v["pDate"]) . '"'; $list_value["pTransferType"] = '"' . iconv('utf-8', 'gbk', l("P_TRANSFER_TYPE_" . $v["pTransferType"])) . '"'; $list_value["pTransferMode"] = '"' . iconv('utf-8', 'gbk', l("P_TRANSFER_MODE_" . $v["pTransferMode"])) . '"'; $list_value["pMemo1"] = '"' . iconv('utf-8', 'gbk', $v["pMemo1"]) . '"'; $list_value["pMemo2"] = '"' . iconv('utf-8', 'gbk', $v["pMemo2"]) . '"'; $list_value["pMemo3"] = '"' . iconv('utf-8', 'gbk', $v["pMemo3"]) . '"'; $list_value["pIpsTime"] = '"' . iconv('utf-8', 'gbk', $v["pIpsTime"]) . '"'; $list_value["pIpsBillNo"] = '"' . iconv('utf-8', 'gbk', $v["pIpsBillNo"]) . '"'; $list_value["user_name"] = '"' . iconv('utf-8', 'gbk', $v["user_name"]) . '"'; $content .= implode(",", $list_value) . "\n"; } header("Content-Disposition: attachment; filename=order_list.csv"); echo $content; } else { if ($page == 1) { $this->error(L("NO_RESULT")); } } }
public function fund_export_csv($page = 1) { set_time_limit(0); $limit = ($page - 1) * intval(app_conf("BATCH_PAGE_SIZE")) . "," . intval(app_conf("BATCH_PAGE_SIZE")); //定义条件 $title_arrays = array("0" => "结存", "1" => "充值", "2" => "投标成功", "3" => "招标成功", "4" => "偿还本息", "5" => "回收本息", "6" => "提前还款", "7" => "提前回收", "8" => "申请提现", "9" => "提现手续费", "10" => "借款管理费", "11" => "逾期罚息", "12" => "逾期管理费", "13" => "人工操作", "14" => "借款服务费", "15" => "出售债权", "16" => "购买债权", "17" => "债权转让管理费", "18" => "开户奖励", "19" => "流标还返", "20" => "投标管理费", "21" => "投标逾期收入", "23" => "邀请返利", "24" => "投标返利", "25" => "签到成功", "26" => "逾期罚金(垫付后)", "27" => "其他费用", "28" => "投资奖励", "26" => "红包奖励"); $cate = isset($_REQUEST['cate']) ? intval($_REQUEST['cate']) >= 0 ? intval($_REQUEST['cate']) : -1 : -1; $extWhere = " 1=1 "; if ($cate >= 0) { $extWhere .= " AND type = " . $cate; } if (trim($_REQUEST['user_names']) != '') { $extWhere .= " and u.user_name like '%" . trim($_REQUEST['user_names']) . "%'"; } $begin_time = !isset($_REQUEST['begin_time']) ? 0 : (trim($_REQUEST['begin_time']) == "" ? 0 : to_timespan($_REQUEST['begin_time'], "Y-m-d")); $end_time = !isset($_REQUEST['end_time']) ? 0 : (trim($_REQUEST['end_time']) == "" ? 0 : to_timespan($_REQUEST['end_time'], "Y-m-d")); if ($begin_time > 0 || $end_time > 0) { if ($end_time == 0) { $extWhere .= " and uml.create_time >= {$begin_time} "; } else { $extWhere .= " and uml.create_time between {$begin_time} and {$end_time} "; } } $_REQUEST['begin_time'] = to_date($begin_time, "Y-m-d"); $_REQUEST['end_time'] = to_date($end_time, "Y-m-d"); $list = $GLOBALS['db']->getAll("select uml.*,u.user_name from " . DB_PREFIX . "user_money_log uml left join " . DB_PREFIX . "user u on uml.user_id=u.id where {$extWhere} order by id desc LIMIT " . $limit); foreach ($list as $k => $v) { $n = $list[$k]['type']; $list[$k]['type_format'] = $title_arrays[$n]; } if ($list) { register_shutdown_function(array(&$this, 'fund_export_csv'), $page + 1); $user_value = array('id' => '""', 'user_id' => '""', 'type_format' => '""', 'money' => '""', 'account_money' => '""', 'memo' => '""', 'create_time_ymd' => '""'); if ($page == 1) { $content = iconv("utf-8", "gbk", "编号,会员名,类型,操作金额,余额,备注,操作时间"); } $content = $content . "\n"; foreach ($list as $k => $v) { $fund_list = array(); $fund_list['id'] = iconv('utf-8', 'gbk', '"' . $v['id'] . '"'); $fund_list['user_name'] = iconv('utf-8', 'gbk', '"' . get_user_name_reals($v['user_id']) . '"'); $fund_list['type_format'] = iconv('utf-8', 'gbk', '"' . $v['type_format'] . '"'); $fund_list['money'] = iconv('utf-8', 'gbk', '"' . format_price($v['money']) . '"'); $fund_list['account_money'] = iconv('utf-8', 'gbk', '"' . format_price($v['account_money']) . '"'); $fund_list['memo'] = iconv('utf-8', 'gbk', '"' . $v['memo'] . '"'); $fund_list['create_time_ymd'] = iconv('utf-8', 'gbk', '"' . $v['create_time_ymd'] . '"'); $content .= implode(",", $fund_list) . "\n"; } header("Content-Disposition: attachment; filename=fund_list.csv"); echo $content; } else { if ($page == 1) { $this->error(L("NO_RESULT")); } } }
public function export_csv_site_costs_info($page = 1) { $now = get_gmtime(); set_time_limit(0); $limit = ($page - 1) * intval(app_conf("BATCH_PAGE_SIZE")) . "," . intval(app_conf("BATCH_PAGE_SIZE")); $begin_time = trim($_REQUEST['begin_time']) == '' ? 0 : to_timespan($_REQUEST['begin_time']); $end_time = trim($_REQUEST['end_time']) == '' ? 0 : to_timespan($_REQUEST['end_time']); $now = get_gmtime(); $sql_str = "select \n\t\t\tu.user_name as hymc,\n\t\t\ta.total_price as czzj, \n\t\t\tFROM_UNIXTIME(a.create_time+28800 , '%Y-%m-%d %H:%i:%S') as czsj,\n\t\t\tcase \n\t\t\twhen type = 0 then '回报众筹'\n\t\t\twhen type = 1 then '股权众筹'\n\t\t\telse ''\n\t\t\tend xmlx\n\t\t\tfrom " . DB_PREFIX . "deal_order as a left join " . DB_PREFIX . "user as u on u.id = a.user_id where a.order_status =3 and 1 = 1 "; if (trim($_REQUEST['user_name']) != '') { $sql_str .= " and u.user_name like '%" . trim($_REQUEST['user_name']) . "%' "; } if ($begin_time > 0 || $end_time > 0) { if ($begin_time > 0 && $end_time == 0) { $sql_str .= " and (a.create_time > {$begin_time})"; } elseif ($begin_time == 0 && $end_time > 0) { $sql_str .= " and (a.create_time < {$end_time} )"; } elseif ($begin_time > 0 && $end_time > 0) { $sql_str .= " and (a.create_time > {$begin_time} and a.create_time < {$end_time} )"; } } if (intval($_REQUEST['type']) <= 1) { $sql_str .= " and a.type = " . intval($_REQUEST['type']) . " "; } $list = array(); $list = $GLOBALS['db']->getAll($sql_str); if ($list) { $total_value = array('hymc' => '""', 'czzj' => '""', 'czsj' => '""', 'xmlx' => '""'); if ($page == 1) { $content_total = iconv("utf-8", "gbk", "会员名称,操作金额,操作时间,项目类型"); } if ($page == 1) { $content_total = $content_total . "\n"; } foreach ($list as $k => $v) { $total_value = array(); $total_value['hymc'] = iconv('utf-8', 'gbk', '"' . $v['hymc'] . '"'); $total_value['czzj'] = iconv('utf-8', 'gbk', '"' . $v['czzj'] . '"'); $total_value['czsj'] = iconv('utf-8', 'gbk', '"' . $v['czsj'] . '"'); $total_value['xmlx'] = iconv('utf-8', 'gbk', '"' . $v['xmlx'] . '"'); $content_total .= implode(",", $total_value) . "\n"; } header("Content-Disposition: attachment; filename=total_list.csv"); echo $content_total; } else { if ($page == 1) { $this->error(L("NO_RESULT")); } } }