public function getUserGroupId($user_id, $team_id)
{
$groups = D("UserGroups")->getTeamGroups($team_id);
$group_ids = Utility::GetColumn($groups);
$group = M("UserGroupMapping")->where(array("user_group_id" => array("in", $group_ids), "user_id" => $user_id))->getField("user_group_id");
return $group;
}
public static function Logon($user)
{
// if($isRemember) {
// $time = 30 * 86400;
// } else {
// $time = 0;
// }
//获取用户的group id和team id信息
$group_team = M()->table("user_group_mapping ugm, user_group_team_mapping ugtm")->where("ugm.user_group_id = ugtm.user_group_id and ugm.user_id = " . $user['id'])->field("ugm.user_group_id, ugtm.team_id ")->query('select %FIELD% from %TABLE% %WHERE%', true);
$group_team = $group_team[0];
$user['user_group_id'] = $group_team['user_group_id'];
$user['team_id'] = $group_team['team_id'];
$user['team'] = M('Teams')->getById($group_team['team_id']);
//用户有权限管理的组信息放到login_user里面
$group = M("UserGroups")->find($group_team['user_group_id']);
$user['role'] = $group['role'];
if ($group['role'] == 'admin') {
//管理员组
$groups = M("UserGroupTeamMapping")->where("team_id = " . $group_team['team_id'])->field("user_group_id")->select();
$groups = Utility::GetColumn($groups, "user_group_id");
} else {
$groups = array($group_team['user_group_id']);
}
$user['user_group'] = D("UserGroups")->find($group_team['user_group_id']);
$user['manage_group_ids'] = $groups;
Session::set("login_user", $user);
return $user;
}
function _after_select(&$resultSet, $options)
{
if ($resultSet) {
$creator_ids = Utility::GetColumn($resultSet, "create_user_id");
$users = M("Users")->where(array("id" => array("in", $creator_ids)))->select();
$users = Utility::AssColumn($users);
foreach ($resultSet as $index => $result) {
$resultSet[$index]['create_user_name'] = $users[$result['create_user_id']]['username'];
}
}
return $resultSet;
}
public static function SetOrderState($team)
{
if ($team->close_time == 0) {
return;
}
$c = array('team_id' => $team['id'], 'state' => 'unpay');
$os = DB::LimitQuery('order', array('condition' => $condition));
$ids = Utility::GetColumn($os, 'id');
foreach ($ids as $id) {
Table::UpdateCache('order', $id, array('state' => 'expire'));
}
}
public function getAttachmentsByModuleId($module_name, $module_id)
{
if (!$module_name || !$module_id) {
//log
return NULL;
}
$table_name = ucfirst($module_name) . 'Attachments';
$module_id_name = strtolower($module_name) . '_id';
$data = D($table_name)->where($module_id_name . '=' . $module_id)->order('id desc')->select();
$user_ids = Utility::GetColumn($data, 'update_user_id');
$users = Utility::Asscolumn(D('Users')->select(implode(',', $user_ids)));
foreach ($data as $k => $n) {
$data[$k]['update_user'] = $users[$n['update_user_id']];
}
return $data;
}
function send_sms_client($order_id, $number, $client_name)
{
$sms_api_options = get_sms_api_options();
if (count($sms_api_options) > 0) {
//$from_sms_send = '79224717444';
$from_sms_send = $sms_api_options['sms_api_phone'];
// Проверим и добавим + к номеру
//if (substr($number, 0, 1) !== '+') $number_to = '+'.$number;
//else $number_to = $number;
$options_client = DB::GetQueryResult("SELECT name, var FROM `settings` WHERE `name` = 'sms_client' LIMIT 1", true);
$sms_sended = DB::GetQueryResult("SELECT * FROM `sms_sended` WHERE order_id = " . $order_id . " AND `number` LIKE '{$number}' LIMIT 1", true);
if (!$sms_sended) {
$order = DB::GetQueryResult("SELECT * FROM `order` WHERE id = " . $order_id . " LIMIT 1", true);
//Города
$city_id = Utility::GetColumn($order, 'city_id');
$city = Table::Fetch('city', $city_id);
//Тип работ
$work_id = Utility::GetColumn($order, 'work_type');
$works = Table::Fetch('work_type', $work_id);
if ($order) {
$send = new Sms($sms_api_options['sms_api_username'], $sms_api_options['sms_api_password']);
//СМС - КЛИЕНТУ
$sms_body_client = str_replace("%date%", $order['time_date'], $options_client['var']);
$sms_body_client = str_replace("%time%", $order['time_time'], $sms_body_client);
$sms_body_client = str_replace("%name%", $client_name, $sms_body_client);
$sms_body_client = str_replace("%work_type%", $works[$order['work_type']]['name'], $sms_body_client);
$text_client_send = iconv('utf-8', 'utf-8', $sms_body_client);
$sms_sended_client = DB::GetQueryResult("SELECT * FROM `sms_sended` WHERE `number` LIKE '{$number}' ORDER BY `id` DESC LIMIT 1", true);
$time_now = time();
$time_order = strtotime($sms_sended_client['date']);
$razn = $time_now - $time_order;
if ($razn >= 60) {
if ($number_to != '') {
$result = $send->send_sms($text_client_send, $number, $from_sms_send);
$res1 = DB::GetQueryResult("INSERT INTO `sms_sended` (`id`, `date`, `number`, `text`, `order_id`, `type`) VALUES (NULL, CURRENT_TIMESTAMP, '{$number}', '{$sms_body_client}', '{$order_id}', '2');", true);
}
}
}
}
}
}
function user_list()
{
$this->admin_allowed();
$group_id = $this->_param("group_id");
if ($group_id) {
$group_ids = $group_id;
$this->assign("group_id", $group_id);
} else {
$groups = D("UserGroups")->getTeamGroups($this->login_user['team_id']);
$group_ids = Utility::GetColumn($groups);
}
$users = D("Users")->getGroupUsers($group_ids);
$count = count($users);
list($pagesize, $page_num, $pagestring) = pagestring($count, 20);
$users = D("Users")->getGroupUsers($group_ids, $page_num, $pagesize);
$this->assign("users", $users);
$this->assign("pagestring", $pagestring);
$all_team_groups = D("UserGroups")->getTeamGroups($this->login_user['team_id']);
$this->assign("groups", $all_team_groups);
$this->display();
}
private function _rich($one)
{
if (!$one) {
return NULL;
}
if (has_submit_apply($one['status'])) {
$one['userinfo'] = D("UserInfo")->getByInviteCode($one['invite_code']);
}
$one['same_recommends'] = $this->getsBySameAsId($one['id']);
$one['recommender_name_full'] = $one['recommender_name'];
if ($one['same_recommends']) {
$one['recommender_name_full'] .= ', ' . implode(', ', Utility::GetColumn($one['same_recommends'], 'recommender_name'));
}
// 冗余存储用户年龄，方便排序和查询
if ($one['userinfo']['birthday']) {
$age = date('Y') - intval(substr($one['userinfo']['birthday'], 0, 4));
if (!$one['age'] || $one['age'] !== $age) {
D("UserRecommends")->where('id=' . $one['id'])->setField('age', $age);
}
}
return $one;
}
public function index()
{
$filter = null;
$order = $this->_param("order");
if ($order) {
$order = str_replace("|", ' ', $order);
}
foreach (array_keys($this->data['all_columns']) as $v) {
$value = trim(htmlspecialchars($this->_get($v)));
if (!$value) {
continue;
}
$filter[$v] = array('like', '%' . $value . '%');
}
$count = D('Schools')->getSchoolsCount($filter);
list($pagesize, $page_num, $pagestring) = pagestring($count, 20);
$schools = D('Schools')->getSchools($filter, $page_num, $pagesize, $order);
$this->data['schools'] = $schools;
$this->data['pagestring'] = $pagestring;
$this->data['school_user_count'] = D('Schools')->getSchoolUserCount(Utility::GetColumn($schools, 'id'));
$this->assign($this->data);
D('AdminVisits')->saveVisit('school_list', $page_num);
$this->display();
}
if ($pbday) {
$pbtime = strtotime($pbday);
$condition[] = "pay_time >= '{$pbtime}'";
}
if ($peday) {
$petime = strtotime($peday);
$condition[] = "pay_time <= '{$petime}'";
}
/* end fiter */
$count = Table::Count('order', $condition);
list($pagesize, $offset, $pagestring) = pagestring($count, 20);
$orders = DB::LimitQuery('order', array(
'condition' => $condition,
'order' => 'ORDER BY id DESC',
'size' => $pagesize,
'offset' => $offset,
));
$pay_ids = Utility::GetColumn($orders, 'pay_id');
$pays = Table::Fetch('pay', $pay_ids);
$user_ids = Utility::GetColumn($orders, 'user_id');
$users = Table::Fetch('user', $user_ids);
$team_ids = Utility::GetColumn($orders, 'team_id');
$teams = Table::Fetch('team', $team_ids);
include template('manage_order_index');
<?php
require_once dirname(dirname(dirname(__FILE__))) . '/app.php';
need_manager();
need_auth('market');
$like = strval($_GET['like']);
$cs = strval($_GET['cs']);
/* build condition */
$condition = array();
if ($like) {
$condition[] = "email like '%" . mysql_escape_string($like) . "%'";
}
if ($cs) {
$cscity = DB::LimitQuery('category', array('condition' => array('zone' => 'city', 'name' => $cs), 'one' => true));
if ($cscity) {
$condition['city_id'] = $cscity['id'];
} else {
$cs = null;
}
}
/* end */
$count = Table::Count('subscribe', $condition);
list($pagesize, $offset, $pagestring) = pagestring($count, 50);
$subscribes = DB::LimitQuery('subscribe', array('condition' => $condition, 'order' => 'ORDER BY id DESC', 'size' => $pagesize, 'offset' => $offset));
$city_ids = Utility::GetColumn($subscribes, 'city_id');
$cities = Table::Fetch('category', $city_ids);
include template('manage_misc_subscribe');
$relation_id = $_GET['id'];
$relation = Table::Fetch('rbac_manage_role_relation',$relation_id);
$role_id = $relation['role_id'];
DB::Delete('rbac_manage_role_relation',array('id'=>$relation_id));
Session::Set('notice', '添加角色成功');
redirect( WEB_ROOT . "/manage/user/auth.php?action=member&id=".$role_id);
}
// 持有者
else if($action == 'member'){
$role_id = $_GET['id'];
$itemList = DB::LimitQuery('rbac_manage_role_relation',array('condition'=>array('role_id'=>$role_id)));
$user_ids = Utility::GetColumn($itemList, 'user_id');
$users = Table::Fetch('user', $user_ids);
include template('manage_user_auth_member');
}
// 一个角色的资源分配
else if($action == 'resource'){
$role_id = $_GET['id'];
$role = Table::Fetch('rbac_auth_role',$role_id);
if($_POST){
$resource = $_POST['resource'];
// delete old
DB::Delete('rbac_role_resource',array('role_id'=>$role_id));
$team = Table::Fetch('team', $id);
if ($team['delivery'] == 'express') {
$oc = array('state' => 'pay', 'team_id' => $id);
$orders = DB::LimitQuery('order', array('condition' => $oc, 'order' => 'ORDER BY pay_time DESC, id DESC'));
$kn = array('buy_id' => '支付序号', 'username' => '用户名', 'email' => '用户邮箱', 'realname' => '姓名', 'mobile' => '手机号码', 'address' => '地址', 'quantity' => '数量', 'condbuy' => '选项', 'remark' => '备注', 'date' => '支付时间');
foreach ($orders as $k => $o) {
$o['date'] = date('Y-m-d H:i', $o['pay_time']);
$orders[$k] = $o;
}
$name = "team_{$id}_" . date('Ymd');
down_xls($orders, $kn, $name);
} else {
$cc = array('team_id' => $id);
$coupons = DB::LimitQuery('coupon', array('condition' => $cc, 'order' => 'ORDER BY create_time ASC'));
$users = Table::Fetch('user', Utility::GetColumn($coupons, 'user_id'));
$orders = Table::Fetch('order', Utility::GetColumn($coupons, 'order_id'));
$kn = array('buy_id' => '支付序号', 'username' => '用户名', 'email' => '用户邮箱', 'realname' => '姓名', 'mobile' => '手机号码', 'condbuy' => '选项', 'id' => "{$INI['system']['couponname']}编号", 'secret' => "{$INI['system']['couponname']}密码", 'cmobile' => '消费手机', 'date' => '生成时间', 'remark' => '备注');
foreach ($coupons as $k => $o) {
$u = $users[$o['user_id']];
$r = $orders[$o['order_id']];
$o['buy_id'] = $r['buy_id'];
$o['username'] = $u['username'];
$o['realname'] = $u['realname'];
$o['condbuy'] = $r['condbuy'];
$o['mobile'] = $u['mobile'];
$o['email'] = $u['email'];
$o['cmobile'] = $r['mobile'] ? $r['mobile'] : $u['mobile'];
$o['date'] = date('Y-m-d H:i', $o['create_time']);
$o['remark'] = $r['remark'];
$coupons[$k] = $o;
}
case 'N': $condition['consume'] = 'N'; $condition[] = "expire_time >= {$daytime}"; break;
case 'E': $condition['consume'] = 'N'; $condition[] = "expire_time < {$daytime}"; break;
}
}
/* end filter */
$count = Table::Count('coupon', $condition);
list($pagesize, $offset, $pagestring) = pagestring($count, 10);
$coupons = DB::LimitQuery('coupon', array(
'condition' => $condition,
'order' => 'ORDER BY team_id DESC, consume_time DESC, id ASC',
'size' => $pagesize,
'offset' => $offset,
));
$team_ids = Utility::GetColumn($coupons, 'team_id');
$teams = Table::Fetch('team', $team_ids);
$user_ids = Utility::GetColumn($coupons, 'user_id');
$users = Table::Fetch('user', $user_ids);
$option_state = array(
'Y' => '已消费',
'N' => '未消费',
'E' => '已过期',
);
include template('biz_coupon');
<?php
require_once dirname(dirname(__FILE__)) . '/app.php';
need_login();
need_open(option_yes('navforum'));
$publics = option_category('public');
$id = abs(intval($_GET['id']));
$condition = array('parent_id' => 0);
if ($id && ($public = Table::Fetch('category', $id))) {
$condition['public_id'] = $id;
} else {
if ($id) {
redirect(WEB_ROOT . '/forum/public.php');
} else {
$condition[] = 'public_id > 0';
}
}
$count = Table::Count('topic', $condition);
list($pagesize, $offset, $pagestring) = pagestring($count, 20);
$topics = DB::LimitQuery('topic', array('condition' => $condition, 'size' => $pagesize, 'offset' => $offset, 'order' => 'ORDER BY head DESC, last_time DESC'));
$user_ids = Utility::GetColumn($topics, 'user_id');
$luser_ids = Utility::GetColumn($topics, 'last_user_id');
$user_ids = array_merge($user_ids, $luser_ids);
$users = Table::Fetch('user', $user_ids);
$public = Table::Fetch('category', $id);
$pagetitle = $public ? "{$public['name']}讨论区" : '公共讨论区';
include template('forum_public');
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') {
$partner = Table::Fetch('partner', $id);
<?php
require_once dirname(dirname(dirname(__FILE__))) . '/app.php';
if (!need_manager()) {
need_permission('access', 'misc/invite');
}
$memail = strval($_GET['memail']);
$oemail = strval($_GET['oemail']);
$condition = array('credit > 0', 'pay' => 'N');
if ($memail) {
$muser = Table::Fetch('user', $memail, 'email');
if ($muser) {
$condition['user_id'] = $muser['id'];
}
}
if ($oemail) {
$ouser = Table::Fetch('user', $oemail, 'email');
if ($ouser) {
$condition['other_user_id'] = $ouser['id'];
}
}
$count = Table::Count('invite', $condition);
list($pagesize, $offset, $pagestring) = pagestring($count, 20);
$invites = DB::LimitQuery('invite', array('condition' => $condition, 'order' => 'ORDER BY id DESC', 'size' => $pagesize, 'offset' => $offset));
$team_ids = Utility::GetColumn($invites, 'team_id');
$teams = Table::Fetch('team', $team_ids);
$user_ids = Utility::GetColumn($invites, 'user_id');
$user_ido = Utility::GetColumn($invites, 'other_user_id');
$user_ids = array_merge($user_ids, $user_ido);
$users = Table::Fetch('user', $user_ids);
include template('manage_misc_invite');
require_once dirname(dirname(__FILE__)) . '/app.php';
need_partner();
$partner_id = abs(intval($_SESSION['partner_id']));
$title = strval($_GET['title']);
$type = strval($_GET['type']);
$condition = array('team_id > 0', 'partner_id' => $partner_id);
/* filter */
if ($title) {
$t_con[] = "title like '%" . mysql_escape_string($title) . "%'";
$teams = DB::LimitQuery('team', array('condition' => $t_con));
$team_ids = Utility::GetColumn($teams, 'id');
if ($team_ids) {
$condition['team_id'] = $team_ids;
} else {
$title = null;
}
}
if ($type) {
$condition['type'] = $type;
}
/* end filter */
$count = Table::Count('ask', $condition);
list($pagesize, $offset, $pagestring) = pagestring($count, 20);
$asks = DB::LimitQuery('ask', array('condition' => $condition, 'order' => 'ORDER BY id DESC', 'size' => $pagesize, 'offset' => $offset));
$user_ids = Utility::GetColumn($asks, 'user_id');
$team_ids = Utility::GetColumn($asks, 'team_id');
$users = Table::Fetch('user', $user_ids);
$teams = Table::Fetch('team', $team_ids);
$option_ask = array('ask' => '团购问答', 'transfer' => '求购转让');
include template('biz_ask');
<?php
require_once(dirname(dirname(__FILE__)) . '/app.php');
need_login(true);
$condition = array( 'user_id' => $login_user['id'],);
$count = Table::Count('flow', $condition);
list($pagesize, $offset, $pagestring) = pagestring($count, 20, true);
$flows = DB::LimitQuery('flow', array(
'condition'=>$condition,
'size' => $pagesize,
'offset' => $offset,
'order' => 'ORDER BY id DESC',
));
$detail_ids = Utility::GetColumn($flows, 'detail_id');
$teams = Table::Fetch('team', $detail_ids);
$users = Table::Fetch('user', $detail_ids);
$coupons = Table::Fetch('coupon', $detail_ids);
die(include template('wap_myflow'));
<?php
require_once dirname(dirname(__FILE__)) . '/app.php';
require_once dirname(__FILE__) . '/inc.php';
$id = abs(intval($_GET['id']));
if (!$id || !($team = Table::Fetch('team', $id))) {
redirect(WEB_ROOT . '/team/index.php');
}
team_state($team);
$pagetitle = "{$INI['system']['abbreviation']}答疑 {$team['title']}";
$condition = array('length(comment)>0', 'type' => 'ask');
if (option_yes('teamask')) {
$condition[] = 'team_id > 0';
} else {
$condition['team_id'] = $id;
}
/*pageit*/
$count = Table::Count('ask', $condition);
list($pagesize, $offset, $pagestring) = pagestring($count, 10);
$asks = DB::LimitQuery('ask', array('condition' => $condition, 'order' => 'ORDER BY id DESC', 'size' => $pagesize, 'offset' => $offset));
/*endpage*/
$user_ids = Utility::GetColumn($asks, 'user_id');
$users = Table::Fetch('user', $user_ids);
include template('team_ask');
$summary = Table::Count('apply', $condition, 'remoney');
$count = Table::Count('apply', $condition);
list($pagesize, $offset, $pagestring) = pagestring($count, 20);
$applys = DB::LimitQuery('apply', array(
'condition' => $condition,
'order' => 'ORDER BY create_time DESC',
'size' => $pagesize,
'offset' => $offset,
));
$option_reasons = array(
'商家说可以直接以团购价到店消费' => '商家说可以直接以团购价到店消费',
'预约不上' => '预约不上',
'去过了，不太满意' => '去过了，不太满意',
'朋友/网上评价不好' => '朋友/网上评价不好',
'买多了/买错了' => '买多了/买错了',
'计划有变，没时间消费' => '计划有变，没时间消费',
'后悔了，不想要了' => '后悔了，不想要了',
);
$orders = Table::Fetch('order', Utility::GetColumn($applys, 'order_id'));
$users = Table::Fetch('user', Utility::GetColumn($applys, 'user_id'));
$teams = Table::Fetch('team', Utility::GetColumn($applys, 'team_id'));
$partners = Table::Fetch('partner', Utility::GetColumn($applys, 'partner_id'));
include template('manage_caiwu_askrefund');
<?php
require_once dirname(dirname(__FILE__)) . '/app.php';
need_login();
need_auth(abs(intval($INI['system']['forum'])) > 0);
$condition = array('city_id' => $city['id'], 'team_id' => 0, 'parent_id' => 0);
$topics = DB::LimitQuery('topic', array('condition' => $condition, 'order' => 'ORDER BY head DESC, last_time DESC'));
$user_ids = Utility::GetColumn($topics, 'user_id');
$users = Table::Fetch('user', $user_ids);
include template('forum_city');
$team = Table::Fetch('team', $coupon['team_id']);
Session::Set('notice-ok', '<div class=yzcg style= margin-bottom:8px><b>验证成功！</b></div>' . '<div class=ts><span>优券密码：</span>' . $coupon['id'] . '</div>' . '<div class=ts><span>验证时间：</span>' . date('Y-m-d H:i:s', time()) . '</div>' . '<div class=ts><span>项目名称：</span>' . '<a target=_blank href=http://www.milituan.net/team/' . $coupon['team_id'] . '.html>' . $team['product'] . '</a>' . '</div>');
$status = "OK";
}
}
}
}
$data = date('Y-m-d H:i:s') . " - " . $login_partner['username'] . " - " . $ruian . " - " . $status;
file_put_contents(DIR_CONFIGURE . '/consume.log', $data . "\n", FILE_APPEND);
}
/**
* Recent record / num 5
* @author abei <*****@*****.**>
* @version 20131026
*/
$now = time();
$list_condition['consume'] = 'Y';
$list_condition[] = "`consume_time` < " . $now . " AND `consume_time` > " . ($now - 86400);
if ($login_partner['fid'] == 0) {
// i am father
$list_condition['partner_id'] = $login_partner['id'];
} else {
// i am stroe
$list_condition['store_id'] = $login_partner['store_id'];
}
$count = Table::Count('coupon', $list_condition);
list($pagesize, $offset, $pagestring) = pagestring($count, 10);
$couponList = DB::LimitQuery('coupon', array('condition' => $list_condition, 'order' => 'ORDER BY consume_time DESC', 'size' => $pagesize, 'offset' => $offset));
$partner_ids = Utility::GetColumn($couponList, 'doer_id');
$partners = Table::Fetch('partner', $partner_ids);
include template('biz_consume');
$count = Table::Count('order', $condition);
list($pagesize, $offset, $pagestring) = pagestring($count, 20);
$orders = DB::LimitQuery('order', array(
'condition' => $condition,
'order' => 'ORDER BY create_time DESC',
'size' => $pagesize,
'offset' => $offset,
));
foreach($orders as &$order){
$order['albumList'] = DB::LimitQuery('dp_album',array(
'condition'=>array('order_id'=>$order['id'])
));
}
$user_ids = Utility::GetColumn($orders, 'user_id');
$users = Table::Fetch('user', $user_ids);
$team_ids = Utility::GetColumn($orders, 'team_id');
$teams = Table::Fetch('team', $team_ids);
$partner_ids = Utility::GetColumn($orders, 'parter_id');
$partners = Table::Fetch('partner', $partner_ids);
$dp_ids = Utility::GetColumn($orders, 'had_dp');
$dps = Table::Fetch('order_dp', $dp_ids);
include template('manage_misc_dp');
}
?>
need_partner_m();
$partner_id = abs(intval($_SESSION['partner_id']));
$login_partner = Table::Fetch('partner', $partner_id);
if(!$login_partner['fid']){
$condition = array(
'partner_id' => $partner_id,
);
$count = Table::Count('store', $condition);
list($pagesize, $offset, $pagestring) = pagestring($count, 10);
$stores = DB::LimitQuery('store', array(
'condition' => $condition,
'order' => 'ORDER BY id DESC',
'size' => $pagesize,
'offset' => $offset,
));
}else {
$store = Table::Fetch('store', $login_partner['store_id']);
}
$city_ids = Utility::GetColumn($teams, 'city_id');
$cities = Table::Fetch('category', $city_ids);
include template('/m_biz/biz_mystore');
"addtime > {$daytime}",
));
if ($vote_today) {
Session::Set('notice', '您今天已经参加过调查。');
redirect(WEB_ROOT . '/vote/index.php');
}
$question_list = DB::LimitQuery('vote_question', array(
'condition' => array( 'is_show' => 1, ),
'order' => 'ORDER BY `order` , id',
'size' => 100,
'offset' => $offset,
));
$question_ids = join(',', Utility::GetColumn($question_list, 'id'));
$options_list = DB::LimitQuery('vote_options', array(
'condition' => array(
'question_id' => $question_ids,
'is_show' => 1,
),
'order' => 'ORDER BY id',
'size' => 100,
'offset' => $offset,
));
if (is_array($options_list)) {
foreach($options_list AS $options_key=>$options) {
$options_list_new[$options['id']] = $options;
}
'offset' => $offset
) );
} else if ($selector == 'askrefund') {
// 退款列表协议，修正最土退款订单列表问题
$condition [] = '(allowrefund = "Y" AND state = "pay") OR (state = "unpay" AND allowrefund = "Y" AND rstate = "berefund")';
$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
) );
}
$team_ids = Utility::GetColumn ( $orders, 'team_id' );
$teams = Table::Fetch ( 'team', $team_ids );
foreach ( $teams as $tid => $one ) {
team_state ( $one );
$teams [$tid] = $one;
}
$apply_ids = Utility::GetColumn ( $orders, 'apply_id' );
$applys = Table::Fetch ( 'apply', $apply_ids );
// 标记是否可以点评
$orders = markOrderListDp ( $orders, $teams );
$pagetitle = '我的订单';
include template ( 'order_index' );
<?php
require_once dirname(dirname(__FILE__)) . '/app.php';
need_login();
$daytime = strtotime(date('Y-m-d'));
$condition = array('user_id' => $login_user_id, 'consume' => 'N', "expire_time < {$daytime}");
$count = Table::Count('coupon', $condition);
list($pagesize, $offset, $pagestring) = pagestring($count, 10);
$coupons = DB::LimitQuery('coupon', array('condition' => $condition, 'order' => 'ORDER BY team_id DESC, create_time DESC', 'size' => $pagesize, 'offset' => $offset));
$team_ids = Utility::GetColumn($coupons, 'team_id');
$teams = Table::Fetch('team', $team_ids);
include template('coupon_expire');
}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;
}
$itemList = DB::LimitQuery('order_dp_item',array(
'condition'=>array('order_id'=>$rtr['order_id'])
));
$rtr['itemlist']=$itemList;
$dp_item_ids = Utility::GetColumn($itemList, 'tpl_item_id');
$dpitems = Table::Fetch('dptpl_item', $dp_item_ids);
}
include template('team_view');
function getRecentGoods($id){
$TempNum = 5;//cookie里面存储多少个浏览记录
if(isset($_COOKIE['RecentlyGoods'])){ //判断是否设置了COOKIE
$RecentlyGoods=$_COOKIE['RecentlyGoods'];
$RecentlyGoodsArray=explode(",", $RecentlyGoods);
$RecentlyGoodsNum=count($RecentlyGoodsArray); //RecentlyGoodsNum 当前存储的变量个数
if (in_array($id, $RecentlyGoodsArray))
{
if ( 'comment' == $view ) {
$cc = array(
'partner_id' => $id,
'comment_display' => 'Y',
'comment_time > 0',
);
$comments = DB::LimitQuery('order', array(
'condition' => $cc,
));
foreach( $comments AS $k=>$v) {
$v['grade'] = 'A';
$v['grade'] = $v['comment_grade']=='none' ? 'P' : $v['grade'];
$v['grade'] = $v['comment_grade']=='bad' ? 'F' : $v['grade'];
$v['comment'] = htmlspecialchars($v['comment_content']);
$comments[$k] = $v;
}
$user_ids = Utility::GetColumn($comments, 'user_id');
$users = $user_ids ? Table::Fetch('user', $user_ids) : array();
}
$comments_num = ($partner['comment_good'] + $partner['comment_bad'] + $partner['comment_none']);
$grades['A'] = $partner['comment_good'];
$grades['P'] = $partner['comment_none'];
$grades['F'] = $partner['comment_bad'];
if (count($teams)) {
$first_big = true;
$first = array_shift($teams);
}
include template('partner');
