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');