public static function getRand()
{
$table = self::table();
$sql = "SELECT * FROM {$table} WHERE id >= ((SELECT MAX(id) FROM {$table})-(SELECT MIN(id) FROM {$table})) * RAND() + (SELECT MIN(id) FROM {$table}) AND status=1 LIMIT 5";
$rs = DB::GetQueryResult($sql, false);
return $rs;
}
function backup_make_header($table)
{
$sql = "DROP TABLE IF EXISTS `" . $table . "`;\n";
$result = DB::GetQueryResult("SHOW CREATE TABLE `{$table}`", true);
$tmp = preg_replace("/[\r\n]+/", '', $result['create table']);
$sql .= $tmp . ";\n";
return $sql;
}
function get_settings()
{
$ret = array();
$settings = DB::GetQueryResult("SELECT * FROM `settings`", false);
foreach ($settings as $value) {
$ret[$value['name']] = $value['var'];
}
return $ret;
}
public static function getSkuStock($sku)
{
if (!$sku) {
return 0;
}
$table = self::table();
$time = time() + 3600 * 24 * self::$_expday;
$sql = "SELECT SUM(stock) AS stock FROM {$table} WHERE exp_date > {$time} AND product_sku='{$sku}'";
$stock = DB::GetQueryResult($sql, true);
$stock = isset($stock['stock']) ? (int) $stock['stock'] : 0;
return $stock;
}
public static function getNum($user_id)
{
$user_id = (int) $user_id;
if (!$user_id) {
0;
}
$table = self::table();
$sql = "SELECT SUM(qt) as count FROM {$table} WHERE user_id='{$user_id}' AND status=0";
$rs = DB::GetQueryResult($sql, false);
$rs = isset($rs[0]['count']) ? (int) $rs[0]['count'] : 0;
return $rs;
}
public static function getOrderSku($order_code)
{
if (!$order_code) {
return array();
}
$table = self::table();
$sku_table = ProductsSku::table();
$item_table = ProductsItem::table();
$pic_table = ProductsPic::table();
$sql = "SELECT c.title, b.sku, b.sku_name, b.item, b.current_price, SUM(a.product_num) AS product_num\n\t\tFROM {$table} AS a, {$sku_table} AS b, {$item_table} AS c\n\t\tWHERE c.item=b.item AND a.product_sku=b.sku AND a.order_code='{$order_code}' GROUP BY a.product_sku";
$rs = DB::GetQueryResult($sql, false);
return $rs;
}
public static function getSkusByIds($ids, $exclude_id = 0, $n = 5)
{
if (!$ids) {
return array();
}
$table = self::table();
$exclude = '';
if ($exclude_id) {
$exclude = "AND id <> '{$exclude_id}'";
}
$sql = "SELECT * FROM {$table} WHERE id IN (9,6) {$exclude} AND status=1 GROUP BY item ORDER BY id DESC LIMIT {$n}";
$rs = DB::GetQueryResult($sql, false);
return $rs;
}
<?php
require_once dirname(__FILE__) . '/app.php';
need_login(true);
if ($login_user['rang'] == 'admin' || $login_user['rang'] == 'operator') {
$user = DB::GetQueryResult("SELECT * FROM `user` WHERE id != {$login_user['id']}", false);
include template('admin_message');
} else {
include template('message');
}
<?php
ini_set("display_errors", "1");
ini_set("display_startup_errors", "1");
ini_set('error_reporting', E_ALL);
require_once dirname(__FILE__) . '/app.php';
require_once dirname(__FILE__) . '/lib/iqsms_function.php';
function date_diff_f($date1, $date2)
{
$diff = strtotime($date2) - strtotime($date1);
return $diff;
}
$now = date("Y-m-d");
// Проверим статус ранее отправленных SMS
check_sms_msg_status();
$orders = DB::GetQueryResult("SELECT * FROM `order` WHERE time_date != '' AND time_time != '' AND master_name != 0 AND street != ''", false);
// TEST
//$orders = DB::GetQueryResult("SELECT * FROM `order` WHERE id > 974 AND time_date != '' AND time_time != '' AND master_name != 0 AND street != ''", false);
foreach ($orders as $one) {
$date_f = date_diff_f($now, $one['time_date']);
if ($date_f <= 82000 && $date_f >= 0) {
prepare_sms_master($one['id']);
prepare_sms_client($one['id'], $one['phone'], $one['customer-name'], 3);
if ($one['phone2'] != '' && $one['sms2'] == 'on') {
prepare_sms_client($one['id'], $one['phone2'], $one['customer-name2'], 4);
}
if ($one['phone3'] != '' && $one['sms3'] == 'on') {
prepare_sms_client($one['id'], $one['phone3'], $one['customer-name3'], 5);
}
}
}
<?php
require_once dirname(__FILE__) . '/app.php';
need_login(true);
if ($login_user['rang'] == 'master') {
Utility::Redirect(WEB_ROOT . '/account.php');
}
$work_types = DB::GetQueryResult("SELECT * FROM `work_type`", false);
$master = DB::GetQueryResult("SELECT * FROM `master`", false);
$city = DB::GetQueryResult("SELECT * FROM `city` WHERE parent_id = 0", false);
$users_master = DB::GetQueryResult("SELECT id,realname FROM `user` WHERE rang = 'master'", false);
include template('operator');
} elseif ($action == 'master') {
//if($_GET['date1'] == '' || $_GET['date2'] == '') die('Нет даты');
$user_mas = DB::GetQueryResult("SELECT * FROM `user` WHERE rang = 'master' AND id != 0 ", false);
$array_mas = array();
//$start_time = mysql_real_escape_string($_GET['date1']);
//$end_time = mysql_real_escape_string($_GET['date2']);
//$html .= '<table><tr><td> Даты: с '.$start_time.' по '.$end_time.'</td></tr></table>';
$html .= '<table class="table table-bordered" border="1" style="border: 1px solid #000;">';
$html .= '<tr style="text-align: center;"><td style="width: 300px;padding: 0 2px;">ФИО</td>';
$html .= '<td style="width: 100px;padding: 0 2px;">Рассчитано</td>';
$html .= '<td style="width: 100px;padding: 0 2px;">Выплачено</td>';
$html .= '<td style="width: 100px;padding: 0 2px;">З/П</td></tr>';
foreach ($user_mas as $two) {
//$sum = DB::GetQueryResult("SELECT SUM(cost) AS summ FROM `order` WHERE STR_TO_DATE(time_date, '%d.%m.%Y') BETWEEN STR_TO_DATE('".$start_time."', '%d.%m.%Y') AND STR_TO_DATE('".$end_time."', '%d.%m.%Y') AND master_name =".$two['id'], true);
$sum = DB::GetQueryResult("SELECT SUM(cost) AS summ FROM `order` WHERE master_name =" . $two['id'], true);
$sum_pay = DB::GetQueryResult("SELECT SUM(cost) AS summ FROM `pay` WHERE user_id =" . $two['id'] . " AND cost != 0", true);
$zp_calc = $sum['summ'] * $two['stavka'] / 100;
if ($zp_calc > 0) {
$zp = $zp_calc - $sum_pay['summ'];
$array_mas[$two['id']]['id'] = $two['id'];
$array_mas[$two['id']]['name'] = $two['realname'] . ' (' . $two['username'] . ')';
$array_mas[$two['id']]['zp_calc'] = $zp_calc;
$array_mas[$two['id']]['zp_pay'] = $sum_pay['summ'];
$array_mas[$two['id']]['zp'] = $zp;
$html .= '<tr>';
$html .= '<td>' . $two['realname'] . ' (' . $two['username'] . ')' . '</td>';
$html .= '<td style="text-align: right;">' . $zp_calc . '</td>';
$html .= '<td style="text-align: right;">' . $sum_pay['summ'] . '</td>';
$html .= '<td style="text-align: right;">' . $zp . '</td>';
$html .= '</tr>';
}
<?php
require_once(dirname(__FILE__) . '/app.php');
$today = strtotime(date('Y-m-d'));
$sql = "SELECT p.title,p.mobile,p.phone,p.address FROM `team` t,`partner` p WHERE t.partner_id = p.id AND t.end_time >= ".$today." group by t.partner_id";
$result = DB::GetQueryResult($sql,false);
$kn = array(
'title' => '商户名称',
'mobile' => '商户电话',
'address' => '商户地址',
);
foreach($result As $k=>$row) {
$o['title'] = $row['title'];
$o['mobile'] = $row['mobile'].'/'.$row['phone'];
$o['address'] = $row['address'];
$bizers[$k] = $o;
}
$name = "_bizer_".date('Ymd');
down_xls($bizers, $kn, $name);
?>
<?php
require_once dirname(dirname(__FILE__)) . '/app.php';
if ($_POST) {
$user_name = $_POST['email'];
if ($INI['sms']['login'] == '1') {
if (Utility::IsMobile($user_name)) {
$user = DB::GetQueryResult("SELECT username,email from user WHERE mobile='" . $user_name . "'");
//根据手机号获取用户名
if ($user) {
$user_name = $user['username'];
}
}
}
$login_user = ZUser::GetLogin($user_name, $_POST['password']);
if (!$login_user) {
Session::Set('error', '账号或密码错误，请重新输入。如果已绑定手机号，建议用手机号登录。');
redirect(WEB_ROOT . '/account/login.php');
} else {
if (option_yes('mobilecode') && $login_user['emailable'] == 'Y' && $login_user['enable'] == 'N') {
$user['id'] = $login_user['id'];
Session::Set('error', '请验证手机号');
die(include template('account_signmobile'));
} else {
if (option_yes('emailverify') && $login_user['emailable'] == 'N' && $login_user['enable'] == 'N' && $login_user['secret']) {
Session::Set('unemail', $_POST['email']);
redirect(WEB_ROOT . '/account/verify.php');
} else {
Session::Set('user_id', $login_user['id']);
if (abs(intval($_POST['auto_login']))) {
ZLogin::Remember($login_user);
<?php
require_once (dirname(dirname(dirname(__FILE__))) . '/app.php');
$partnerList = DB::LimitQuery('partner',array(
'condition'=>array('fid'=>0),
));
//商户名称，电话，地址，负责人手机号码，最近多少时间内做个团购
$kn = array(
'id' => '商家ID',
'title' => '商家名称',
'mobile' => '商家电话',
'address' => '地址',
'phone' => '负责人电话',
'team_create' => '最近团购时间',
);
foreach($partnerList as $k=>$partner){
$sql = "SELECT * FROM `team` WHERE `partner_id`=".$partner['id'].' ORDER BY id DESC';
$team = DB::GetQueryResult($sql,true);
$partner['team_create'] = date('Y-m-d',$team['begin_time']);
$partnerList[$k] = $partner;
}
$name = "milituan_partner_".date('Ymd');
down_xls($partnerList, $kn, $name);
?>
} else {
if ('teamcoupon' == $action) {
need_auth('team');
$team = Table::Fetch('team', $id);
team_state($team);
if ($team['now_number'] < $team['min_number']) {
json('团购未结束或未达到最低成团人数', 'alert');
}
/* all orders */
$all_orders = DB::LimitQuery('order', array('condition' => array('team_id' => $id, 'state' => 'pay')));
$all_orders = Utility::AssColumn($all_orders, 'id');
$all_order_ids = Utility::GetColumn($all_orders, 'id');
$all_order_ids = array_unique($all_order_ids);
/* all coupon id */
$coupon_sql = "SELECT order_id, count(1) AS count FROM coupon WHERE team_id = '{$id}' GROUP BY order_id";
$coupon_res = DB::GetQueryResult($coupon_sql, false);
$coupon_order_ids = Utility::GetColumn($coupon_res, 'order_id');
$coupon_order_ids = array_unique($coupon_order_ids);
/* miss id */
$miss_ids = array_diff($all_order_ids, $coupon_order_ids);
foreach ($coupon_res as $one) {
if ($one['count'] < $all_orders[$one['order_id']]['quantity']) {
$miss_ids[] = $one['order_id'];
}
}
$orders = Table::Fetch('order', $miss_ids);
foreach ($orders as $order) {
ZCoupon::Create($order);
}
json('发券成功', 'alert');
} elseif ($action == 'partnerhead') {
$currefer = uencode(strval($_SERVER['REQUEST_URI']));
/* session,cache,configure,webroot register */
Session::Init();
$INI = ZSystem::GetINI();
$AJAX = 'XMLHttpRequest' == @$_SERVER['HTTP_X_REQUESTED_WITH'];
if (false == $AJAX) {
header('Content-Type: text/html; charset=UTF-8');
} else {
header("Cache-Control: no-store, no-cache, must-revalidate");
}
/* end */
/* biz logic */
$currency = $INI['system']['currency'];
$login_user_id = ZLogin::GetLoginId();
$login_user = Table::Fetch('user', $login_user_id);
//$login_partner = ZPartner::GetLoginPartner();
$partner_id = abs(intval($_SESSION['partner_id']));
$login_partner = Table::Fetch('partner', $partner_id);
$city = cookie_city(null);
$hotcities = Table::Fetch('category', $INI['hotcity']);
$sql = "SELECT sum(now_number*(market_price-team_price)) AS tsm FROM `team`";
$totalSavedMoney = DB::GetQueryResult($sql);
/* get team count */
$daytime = strtotime(date('Y-m-d'));
$condition = array('team_type' => 'normal', "audit" => 1);
$allteamcount = Table::Count('team', $condition);
/* not allow access app.php */
if ($_SERVER['SCRIPT_FILENAME'] == __FILE__) {
Utility::Redirect(WEB_ROOT . '/index.php');
}
/* end */
$user = Table::Fetch('user', strval($_POST['email']), 'email');
if ($user) {
$user['recode'] = $user['recode'] ? $user['recode'] : md5(json_encode($user));
Table::UpdateCache('user', $user['id'], array('recode' => $user['recode']));
mail_repass($user);
Session::Set('reemail', $user['email']);
redirect(WEB_ROOT . '/account/repass.php?action=ok');
}
Session::Set('error', '抱歉，这个邮箱没有在本站绑定过用户，试试<a style="color:#000" href="/account/repassmobile.php">手机号找回密码？</a>');
redirect(WEB_ROOT . '/account/repass.php');
} elseif (!empty($_POST['mobile'])) {
if (!Utility::IsMobile($_POST['mobile'])) {
Session::Set('error', '手机号码不正确');
redirect(WEB_ROOT . '/account/repass.php');
} else {
$sended = DB::GetQueryResult("SELECT mobile FROM verifycode WHERE mobile='" . $_POST['mobile'] . "' AND status=3 AND getip='" . Utility::GetRemoteIp() . "' AND dateline>'" . (time() - 3600) . "'");
if ($sended) {
Session::Set('error', '每IP每手机号每小时只能找回一次密码');
redirect(WEB_ROOT . '/account/repass.php');
} else {
$user = Table::Fetch('user', strval($_POST['mobile']), 'mobile');
if ($user) {
//设置6位随机数字密码
$new_password = Utility::VerifyCode();
$content = $INI['system']['sitename'] . " 您的用户名：" . $user['username'] . " 新密码：" . $new_password . " 请及时修改密码。";
//长度不能超过70个字符
$ret = sms_send($_POST['mobile'], $content);
if ($ret === true) {
//插入获取验证码数据记录
$verifycode_data = array('mobile' => $_POST['mobile'], 'getip' => Utility::GetRemoteIp(), 'verifycode' => $new_password, 'dateline' => time(), 'reguid' => $user['id'], 'regdateline' => time(), 'status' => 3);
$table = new Table('verifycode', $verifycode_data);
if (empty($verifycode)) {
json('绑定验证码不能为空', 'alert');
}
$exists = Table::Count('user', array('mobile' => $mobile));
if ($exists >= 1) {
json('此手机号已有会员绑定', 'alert');
}
//验证手机号验证码和IP
$verify = DB::GetQueryResult("SELECT mobile FROM verifycode WHERE mobile='" . $mobile . "' AND verifycode='" . $verifycode . "' AND getip='" . Utility::GetRemoteIp() . "' AND status=4 AND dateline>'" . (time() - 86400) . "'");
//验证码一天内有效
if (!$verify) {
json('手机号和绑定验证码不匹配', 'alert');
} else {
DB::GetQueryResult("UPDATE user SET mobile='" . $mobile . "' WHERE id=" . $login_user['id'] . "");
//更新会员手机号数据
DB::GetQueryResult("UPDATE verifycode SET reguid=" . $login_user['id'] . ",regdateline='" . time() . "',status=5 WHERE mobile='" . $mobile . "' AND verifycode='" . $verifycode . "' AND getip='" . Utility::GetRemoteIp() . "' AND status=4 AND dateline>'" . (time() - 86400) . "'");
//更新验证码记录表数据
}
json('手机号：' . $mobile . ' 绑定成功', 'alert');
}
}
}
}
}
}
}
}
}
}
}
}
<?php
/**
* 我的抽奖列表
* @author abei <*****@*****.**>
*/
require_once dirname(dirname(__FILE__)) . '/app.php';
need_login();
$sql = "SELECT count(a.id) FROM `activity` a,`activity_record` ar WHERE ar.user_id = " . $login_user_id . " AND ar.activity_id = a.id GROUP BY ar.activity_id";
$list = DB::GetQueryResult($sql, false);
list($pagesize, $offset, $pagestring) = pagestring(count($list), 10);
$sql = "SELECT a.title,a.id,a.begin_time,a.end_time,a.state FROM `activity` a,`activity_record` ar WHERE ar.user_id = " . $login_user_id . " AND ar.activity_id = a.id GROUP BY ar.activity_id LIMIT {$offset},{$pagesize}";
$itemList = DB::GetQueryResult($sql, false);
$pagetitle = '我的活动';
include template('account_activity_index');
}
$condition[] = "(city_ids like '%@{$city_id}@%' or city_ids like '%@0@%') or (city_ids = '' and city_id in(0,{$city_id}))";
$count = Table::Count('team', $condition);
list($pagesize, $offset, $pagestring) = pagestring($count, $size);
$teams = DB::LimitQuery('team', array('condition' => $condition, 'order' => 'ORDER BY `sort_order` DESC, `id` DESC', 'size' => $pagesize, 'offset' => $offset));
$disable_multi = true;
/***********************加入的代码：开始*********************************/
$cates = DB::LimitQuery('category', array('condition' => array('zone' => 'group', 'fid' => '0', 'display' => 'Y'), 'order' => 'ORDER BY `sort_order` DESC, `id` DESC'));
$alls = array();
$anow = time();
foreach ($cates as $key => $value) {
$alls[$key]['name'] = $value[name];
$alls[$key]['ename'] = $value[ename];
$alls[$key]['gid'] = $value[id];
$alls[$key]['number'] = Table::Count('team', array('team_type' => 'normal', 'group_id' => $value[id], "(city_ids like '%@{$city_id}@%' or city_ids like '%@0@%') or (city_ids = '' and city_id in(0,{$city_id}))", "begin_time < '{$anow}'", "end_time > '{$anow}'"));
$alls[$key]['teams'] = DB::LimitQuery('team', array('condition' => array('team_type' => 'normal', 'group_id' => $value[id], "(city_ids like '%@{$city_id}@%' or city_ids like '%@0@%') or (city_ids = '' and city_id in(0,{$city_id}))", "begin_time < '{$anow}'", "end_time > '{$anow}'"), 'order' => 'ORDER BY `sort_order` DESC, `id` DESC', 'size' => $value[show_number]));
$alls[$key]['recom'] = DB::GetQueryResult("SELECT *,t.id AS tid,p.title AS ptitle, t.title AS ttitle, p.image AS pimage FROM `team` AS t LEFT JOIN `partner` as p ON t.partner_id=p.id WHERE t.group_id={$value['id']} AND t.team_type='normal' AND t.begin_time<'" . $anow . "' AND t.end_time>'" . $anow . "' AND t.is_recom='Y' AND p.display='Y'", false);
}
/***********************加入的代码：结束*********************************/
die(require_once dirname(__FILE__) . '/multi.php');
} else {
$team = $teams = index_get_team($city['id'], $group_id);
if ($team && $team['id']) {
$_GET['id'] = abs(intval($team['id']));
die(require_once dirname(__FILE__) . '/team.php');
} elseif ($teams) {
$disable_multi = true;
die(require_once dirname(__FILE__) . '/multi.php');
}
}
include template('subscribe');
public static function Count($n = null, $condition = null, $sum = null)
{
$condition = DB::BuildCondition($condition);
$condition = null == $condition ? null : "WHERE {$condition}";
$zone = $sum ? "SUM({$sum})" : "COUNT(1)";
$sql = "SELECT {$zone} AS count FROM `{$n}` {$condition}";
$row = DB::GetQueryResult($sql, true);
return intval($row['count']);
}
}
if (abs(intval($ucity))) {
$condition['city_id'] = abs(intval($ucity));
}
if ($numbers) {
/* all user id */
$u_sql = "SELECT user_id, count(user_id) AS count FROM `order` WHERE state = 'pay' GROUP BY user_id HAVING count > {$numbers}";
$user_res = DB::GetQueryResult($u_sql, false);
$user_ids = Utility::GetColumn($user_res, 'user_id');
$user_ids = array_unique($user_ids);
$uids = implode(',', $user_ids);
$condition[] = "(id in({$uids}))";
}
if ($prices) {
/* all user id */
$p_sql = "SELECT user_id, sum(origin) AS count FROM `order` WHERE state = 'pay' GROUP BY user_id HAVING count > {$prices}";
$p_res = DB::GetQueryResult($p_sql, false);
$p_ids = Utility::GetColumn($p_res, 'user_id');
$p_ids = array_unique($p_ids);
$pids = implode(',', $p_ids);
$condition[] = "(id in({$pids}))";
}
if ($havemoney) {
/* have money */
$condition[] = "money > {$havemoney}";
}
/* end */
$count = Table::Count('user', $condition);
list($pagesize, $offset, $pagestring) = pagestring($count, 20);
$users = DB::LimitQuery('user', array('condition' => $condition, 'order' => 'ORDER BY id DESC', 'size' => $pagesize, 'offset' => $offset));
include template('manage_user_index');
public static function Group($n = null, $condition = null, $gname = null, $sum = null)
{
$condition = DB::BuildCondition($condition);
$condition = null == $condition ? null : "WHERE {$condition}";
$group = "GROUP BY {$gname}";
$zone = $sum ? "SUM({$sum})" : "COUNT(1)";
$sql = "SELECT {$gname} AS name,{$zone} AS count FROM `{$n}` {$condition} {$group}";
$row = DB::GetQueryResult($sql, false);
return Utility::OptionArray($row, 'name', 'count');
}
} elseif ($action == 'get_contact_messages') {
$html = '';
$id = $_GET['id'];
$last_message = $_GET['last_message'];
$settings = get_settings();
$mail_count = DB::GetQueryResult("SELECT count(*) as cnt FROM message WHERE for_user = 100000 AND user_id = {$id} OR for_user = {$id}", true);
if ($last_message == '1' && (int) $mail_count['cnt'] > (int) $settings['msg_record_show_cnt']) {
$query = "SELECT * FROM (\n SELECT * FROM message WHERE for_user = 100000 AND user_id = {$id} OR for_user = {$id} ORDER BY `date` DESC LIMIT " . $settings['msg_record_show_cnt'] . "\n ) AS `table` ORDER by `date` ASC";
} else {
$query = "SELECT * FROM message WHERE for_user = 100000 AND user_id = {$id} OR for_user = {$id}";
}
$mail = DB::GetQueryResult($query, false);
foreach ($mail as $one) {
if ($one['user_id'] == 100000) {
$name = 'Администратор';
$html .= '<div class="div-send-message">';
} else {
$user_name = DB::GetQueryResult("SELECT realname, username FROM user WHERE id = {$one['user_id']}", true);
$name = $user_name['realname'] . '(' . $user_name['username'] . ')';
$html .= '<div class="div-recieve-message' . ($one['is_read'] == 0 ? ' div-recieve-message-unread' : '') . '">';
}
$html .= '<strong>' . $name . ' ' . $one['date'] . '</strong><hr>';
$html .= $one['message'];
$html .= '</div>';
// Отмечаем как прочитанные сообщения
if ($one['is_read'] == 0) {
$result = DB::Query("UPDATE `message` SET `is_read` = 1 WHERE `id` = {$one['id']}");
}
}
die(json_encode(array('html' => $html, 'hide_msg' => $last_message == '1' && (int) $mail_count['cnt'] > (int) $settings['msg_record_show_cnt'])));
}
<?php
require_once dirname(dirname(dirname(__FILE__))) . '/app.php';
import('backup');
need_manager(true);
function _go_reload()
{
redirect(WEB_ROOT . '/manage/misc/backup.php');
}
/* get tables */
$db_name = $INI['db']['name'];
$tables = DB::GetQueryResult("SHOW TABLE STATUS FROM `{$db_name}`", false);
/* end */
if (is_get()) {
$results = DB::GetQueryResult("SHOW TABLE STATUS FROM `{$db_name}`", false);
$option_table = Utility::OptionArray($results, 'name', 'name');
die(include template('manage_misc_backup'));
}
$bftype = $_POST['bfzl'];
if ($bftype == "quanbubiao") {
if (!$_POST['fenjuan']) {
//不是分卷
$sql = null;
foreach ($tables as $one) {
$table = $one['name'];
$sql .= backup_make_header($table);
$query = DB::Query("SELECT * FROM `{$table}`");
while ($r = DB::NextRecord($query)) {
$sql .= backup_make_record($table, $r);
}
}
$cbtime = $team['begin_time'];
} else {
//$cbtime = $daytime-86400*7;
}
$ocbday = date('Y-m-d H:i:s', $cbtime);
$condition[] = "consume_time >= '{$cbtime}'";
}
if ($ceday) {
$cetime = strtotime($ceday);
$oceday = date('Y-m-d H:i:s', $cetime);
$condition[] = "consume_time <= '{$cetime}'";
} else {
$cetime = $daytime;
$oceday = $ceday = date('Y-m-d H:i:s', $cetime);
$condition[] = "consume_time <= '{$daytime}'";
}
$condition['consume'] = 'Y';
$condition['doer_id'] = $partner_id;
$condition['team_id'] = $search_team_id;
$count = Table::Count('coupon', $condition);
/* filter */
$sql = "SELECT \r\r\n\tFROM_UNIXTIME(consume_time, '%Y-%m-%d') ts, \r\r\n\tFROM_UNIXTIME(consume_time, '%w') we, \r\r\n\tcount(id) ids \r\r\n\tFROM coupon \r\r\n\tWHERE \t\t\r\r\n\t\t`consume_time` >= {$cbtime} \r\r\n\t\tAND `consume_time` < {$cetime} \r\r\n\t\tAND `team_id` = {$search_team_id} \t\t\r\r\n\t\tAND `doer_id` = {$partner_id} \r\r\n\t\tAND `consume` = 'Y' \r\r\n\t\tAND {$sql_verifytype_str} \r\r\n\tGROUP BY ts";
$coupons = DB::GetQueryResult($sql, false);
$coupons_count = count($coupons);
list($pagesize, $offset, $pagestring) = pagestring($coupons_count, 100);
$sql .= ' LIMIT ' . $offset . ',' . $pagesize;
$coupons = DB::GetQueryResult($sql, false);
$current_store = Table::Fetch('store', $login_partner['store_id']);
// 该店员店铺所运行的项目
$teams = DB::LimitQuery('team', array('condition' => array('store_ids LIKE "%@' . $login_partner['store_id'] . '@%"')));
include template('biz_coupon_consume_doer');
AND c.expire_time < " . time() ."
AND c.expire_time >= ".(time()-86400*7)."
GROUP BY c.order_id";
$rows = DB::GetQueryResult ( $count_sql, false );
list ( $pagesize, $offset, $pagestring ) = pagestring ( count ( $rows ), 10 );
$sql = "SELECT o.*,c.expire_time AS o_expire_time FROM `order` o,`coupon` c
WHERE
o.id = c.order_id
AND o.rstate = 'normal'
AND c.consume = 'N' AND o.user_id = $login_user_id
AND c.expire_time < " .time()."
AND c.expire_time >= ".(time()-86400*7)."
GROUP BY c.order_id ORDER BY o.pay_time DESC
LIMIT $offset,10";
$orders = DB::GetQueryResult ( $sql, false );
}
else if ($selector == 'unpay') {
$condition ['state'] = 'unpay';
//$condition ['rstate'] = "normal";
$condition ['rstate'] = 'normal';
$count = Table::Count ( 'order', $condition );
list ( $pagesize, $offset, $pagestring ) = pagestring ( $count, 10 );
$orders = DB::LimitQuery ( 'order', array (
'condition' => $condition,
'order' => 'ORDER BY team_id DESC, id ASC',
'size' => $pagesize,
'offset' => $offset
) );
} else if ($selector == 'pay') {
$options_list = $options_list_new;
}
foreach ($options_list as $key => $options) {
$sql = "SELECT * FROM `vote_feedback_question`\n\t\t\t\tWHERE `question_id` = '{$question['id']}' AND `options_id`='{$options['id']}'\n\t\t\t\tGROUP BY `feedback_id`";
$feedback = DB::GetQueryResult($sql, 0);
$options_list[$key]['feedback'] = count($feedback);
}
include template('manage_vote_feedback_question_view');
exit;
//查看自定义输入
} elseif ($action == 'input_list') {
$options_id = isset($_REQUEST['options_id']) && is_numeric($_REQUEST['options_id']) ? $_REQUEST['options_id'] : 0;
$options = Table::Fetch('vote_options', $options_id);
if (!$options) {
Session::Set('error', '此选项不存在。');
redirect(WEB_ROOT . '/manage/vote/feedback.php');
exit;
}
$question = Table::Fetch('vote_question', $options['question_id']);
if (!$question) {
Session::Set('error', '此问题不存在。');
redirect(WEB_ROOT . '/manage/vote/feedback.php');
exit;
}
$sql = "SELECT *, COUNT(id) AS num FROM `vote_feedback_input`\n\t\t\tWHERE `options_id`='{$options['id']}'\n\t\t\tGROUP BY `value`\n\t\t\tORDER BY `num` DESC\n\t\t\t";
$input_list = DB::GetQueryResult($sql, 0);
include template('manage_vote_feedback_input_list');
exit;
}
redirect(WEB_ROOT . '/manage/vote/feedback.php');
exit;
`order_dp`.pb,
`order_dp`.yz,
`order_dp`.images,
`order_dp`.create_time,
`order_dp`.order_id
FROM
`order_dp`,
`user`
WHERE
order_dp.team_id = $id
AND order_dp.user_id = `user`.id
ORDER BY order_dp.create_time DESC
Limit 0,5
";
$remark_item_result = DB::GetQueryResult($remark_item_sql,false);
foreach($remark_item_result as &$rtr){
if(!empty($rtr['images'])){
$imgs = explode('@', $rtr['images']);
$rtr['imgList'] = $imgs;
}else{
$rtr['imgList'] = null;
}
if(!empty($rtr['username'])){
$username2=mb_substr($rtr['username'],0,1,'utf-8')."**".mb_substr($rtr['username'],mb_strlen($rtr['username'],'utf-8')-1,1,'utf-8');
$rtr['username2']=$username2;
}
if(!empty($rtr['create_time'])){
$dptime=date("m-d",$ri['create_time']);
$rtr['dptime']=$dptime;
}
<?php
require_once dirname(__FILE__) . '/app.php';
$user_id = $_SESSION['user_id'];
if (!empty($user_id)) {
//---------------是否为登录状态
if (!empty($_REQUEST['token'])) {
$userinfo = $denglu_api->get_userinfo();
//获取媒体用户信息
$denglu_data = $denglu_api->denglu_data();
//获取媒体信息
//----判断该帐号是否已经绑定
$sql = 'select * from user_denglu where mediaUserID=' . $userinfo['mediaUserID'];
$row = DB::GetQueryResult($sql);
if ($row) {
if ($row['tag'] == 0) {
$time = time();
$sql = 'update user_denglu set uid=' . $_SESSION['user_id'] . ',tag=1,createtime=' . $time . ' where mediaUserID=' . $userinfo['mediaUserID'];
$db = DB::Query($sql);
if ($db) {
Session::Set('notice', '成功绑定！');
redirect(get_loginpage(WEB_ROOT . '/denglu.php?act=dl_user'));
} else {
Session::Set('notice', '绑定失败，请重新绑定！');
redirect(get_loginpage(WEB_ROOT . '/denglu.php?act=dl_user'));
}
}
if ($row['tag'] == 1) {
Session::Set('error', '该媒体帐号已经和其他网站帐号绑定！');
redirect(get_loginpage(WEB_ROOT . '/denglu.php?act=dl_user'));
}
