private function calcUserMark($userChoices)
{
$usermark = 0;
if (count($userChoices) <= 0) {
return $usermark;
}
$choice_ids = array_keys($userChoices);
$ref = pdo_fetchAll("SELECT * FROM " . tablename('quickexam2_choice') . " WHERE choice_id in (" . join(',', $choice_ids) . ")", array(), 'choice_id');
foreach ($userChoices as $choice_id => $choice_arr) {
if (count(array_diff(explode(',', $ref[$choice_id]['answer']), $choice_arr)) > 0) {
// different answer set, wrong!
} else {
$usermark += $ref[$choice_id]['mark'];
}
}
return $usermark;
}
电话：' . $member['mobile'] . '
时间：' . $createtime . '
', 'deviceNo' => $this->module['config']['deviceNo'], 'msgNo' => $msgNo);
echo $this->sendFreeMessage($freeMessage);
}
}
pdo_insert("xcommunity_report", $data);
$id = pdo_insertid();
//短信提醒
$content = $_GPC['content'];
$mobile = $member['mobile'];
if ($this->module['config']['report_type']) {
$result = $this->Resms($content, $mobile);
}
//微信提醒
$notice = pdo_fetchAll("SELECT * FROM" . tablename('xcommunity_wechat_notice') . "WHERE regionid='{$member['regionid']}'");
foreach ($notice as $key => $value) {
if ($value['repair_status'] == 2) {
$openid = $value['fansopenid'];
$url = $this->createMobileUrl('repair', array('op' => 'display'));
$template_id = $this->module['config']['repair_tplid'];
$createtime = date('Y-m-d H:i:s', $_W['timestamp']);
$content = array('first' => array('value' => '新报修通知'), 'keyword1' => array('value' => $member['realname']), 'keyword2' => array('value' => $member['mobile']), 'keyword3' => array('value' => $member['address']), 'keyword4' => array('value' => $_GPC['content']), 'keyword5' => array('value' => $createtime), 'remark' => array('value' => '请尽快联系客户。'));
$this->sendtpl($openid, $url, $template_id, $content);
}
}
message('报修申请提交成功,请查看"我的报修"等待工作人员联系。', $this->createMobileUrl('repair', array('op' => 'display')), 'success');
}
} elseif ($op == 'display' || $op == 'more') {
$pindex = max(1, intval($_GPC['page']));
$psize = 10;
if ($_W['ispost']) {
if (empty($_GPC['id'])) {
pdo_insert('xcommunity_carpool', $data);
} else {
pdo_update('xcommunity_carpool', $data, array('id' => $_GPC['id']));
}
message('发布成功', $this->createMobileUrl('car', array('op' => 'display')), 'success');
}
include $this->template('caradd');
} elseif ($op == 'detail') {
$id = $_GPC['id'];
if ($id) {
$item = pdo_fetch("SELECT * FROM" . tablename('xcommunity_carpool') . "WHERE id=:id", array(':id' => $id));
}
include $this->template('cardetail');
} elseif ($op == 'my') {
$pindex = max(1, intval($_GPC['page']));
$psize = 10;
$condition = '';
$keyword = $_GPC['keyword'];
if ($keyword) {
$keyword = "%{$_GPC['keyword']}%";
$condition = " AND start_position LIKE '{$keyword}' OR end_position LIKE '{$keyword}'";
}
$list = pdo_fetchAll("SELECT * FROM" . tablename('xcommunity_carpool') . "WHERE weid='{$_W['weid']}' AND status = 0 AND regionid='{$member['regionid']}' {$condition} LIMIT " . ($pindex - 1) * $psize . ',' . $psize);
if ($op == 'more') {
include $this->template('carindex_more');
}
include $this->template('car_index');
exit;
}
public function doMobileWorng()
{
global $_GPC, $_W;
$id = intval($_GPC['id']);
$flight_setting = pdo_fetch("SELECT * FROM " . tablename('fighting_setting') . " WHERE rid = '{$id}' LIMIT 1");
if (empty($flight_setting)) {
message('非法访问，请重新发送消息进入一战到底页面！');
}
$fromuser = $_W['fans']['from_user'];
$member = fans_search($fromuser);
if (empty($member)) {
$followurl = $flight_setting['followurl'];
//分享URL
header("location:{$followurl}");
}
$sql = "SELECT * FROM " . tablename('fighting_question_worng') . " AS a LEFT JOIN " . tablename('fighting') . " AS b ON b.id = a.fightingid ";
$list = pdo_fetchAll($sql);
include $this->template('worng');
exit;
}
<?php
header("Content-type:text/csv;");
header("Content-Disposition:attachment;filename=weicard.csv");
header('Cache-Control:must-revalidate,post-check=0,pre-check=0');
header('Expires:0');
header('Pragma:public');
$weid = $_W['uniacid'];
$result = pdo_fetchAll("SELECT * FROM " . tablename('amouse_weicard_member') . " WHERE weid=" . $weid . " ORDER BY id DESC ");
$title = "名字" . "," . "公司" . "," . "职务" . "," . "部门" . "," . "电话" . "," . "时间" . "\n";
if (isWin()) {
echo iconv('utf-8', 'gb2312', $title);
foreach ($result as $key => $value) {
$temp = $value['realname'] . "," . $value['company'] . "," . $value['job'] . "," . $value['department'] . "," . $value['mobile'] . "," . date("Y-m-d G:i", $value['createtime']) . "\n";
echo iconv('utf-8', 'gb2312', $temp);
}
} else {
echo $title;
foreach ($result as $key => $value) {
echo $value['realname'] . ",";
echo $value['company'] . ",";
echo $value['job'] . ",";
echo $value['department'] . ",";
echo $value['mobile'] . ",";
echo date("Y-m-d G:i", $value['createtime']) . "\n";
}
}
function isWin()
{
global $_SERVER;
$agent = $_SERVER['HTTP_USER_AGENT'];
public function doWebPackedit()
{
global $_GPC, $_W;
$sql = 'SELECT * FROM ' . tablename('fb_item');
$list = pdo_fetchAll($sql);
$op = $_GPC['op'];
if ($op == 'add') {
$url = $this->createWebUrl('packedit', array('op' => 'add'));
if (checksubmit('submit')) {
if (empty($_GPC['name'])) {
message('请输入套餐名称');
}
$data = array('p_name' => $_GPC['name'], 'thumb' => $_GPC['thumb'], 'price' => $_GPC['price'], 'm_price' => $_GPC['mprice'], 's_item' => serialize($_GPC['item']), 'detail' => $_GPC['detail'], 'is_show' => $_GPC['is_show'], 'is_recommend' => $_GPC['is_recommend']);
$result = pdo_insert('fb_package', $data);
if ($result) {
message('添加成功', $this->createWebUrl('package'), 'success');
}
}
} elseif ($op == 'edit') {
$id = $_GPC['id'];
$url = $this->createWebUrl('packedit', array('op' => 'edit', 'id' => $id));
if (checksubmit('submit')) {
$data = array('p_name' => $_GPC['name'], 'thumb' => $_GPC['thumb'], 'price' => $_GPC['price'], 'm_price' => $_GPC['mprice'], 's_item' => serialize($_GPC['item']), 'detail' => $_GPC['detail'], 'is_show' => $_GPC['is_show'], 'is_recommend' => $_GPC['is_recommend']);
//pdo_update('account', array('uniacid' => '100'), array('acid' => '10'));
$result = pdo_update('fb_package', $data, array('id' => $id));
if ($result) {
message('更新成功', $this->createWebUrl('package'), 'success');
}
}
$sql = 'SELECT * FROM ' . tablename('fb_package') . 'where id=:id';
$param = array(':id' => $id);
$item = pdo_fetch($sql, $param);
$arr = unserialize($item['s_item']);
$item['s_item'] = $arr;
} elseif ($op == 'delete') {
$id = $_GPC['id'];
$result = pdo_delete('fb_package', array('id' => $id));
if ($result) {
message('删除成功', $this->createWebUrl('package'), 'success');
}
}
include $this->template('pack_edit');
}
global $_W, $_GPC;
$op = !empty($_GPC['op']) ? $_GPC['op'] : 'display';
if ($op == 'post') {
if ($_GPC['id']) {
$item = pdo_fetch("SELECT * FROM" . tablename('xcommunity_search') . "WHERE id=:id", array(':id' => $_GPC['id']));
}
$data = array('weid' => $_W['weid'], 'sname' => $_GPC['sname'], 'surl' => $_GPC['surl'], 'icon' => $_GPC['icon'], 'status' => $_GPC['status']);
if ($_W['ispost']) {
if (empty($_GPC['id'])) {
pdo_insert("xcommunity_search", $data);
} else {
pdo_update("xcommunity_search", $data, array('id' => $_GPC['id']));
}
message('更新成功', referer(), 'success');
}
} elseif ($op == 'display') {
$list = pdo_fetchAll('SELECT * FROM' . tablename('xcommunity_search') . "WHERE weid='{$_W['weid']}'");
if ($_GPC['id']) {
if (empty($_GPC['status'])) {
pdo_query("UPDATE " . tablename('xcommunity_search') . " SET status=0 WHERE id=:id", array(':id' => $_GPC['id']));
message('成功关闭', referer(), 'success');
} else {
pdo_query("UPDATE " . tablename('xcommunity_search') . " SET status=1 WHERE id=:id", array(':id' => $_GPC['id']));
message('成功开启', referer(), 'success');
}
}
} elseif ($op == 'delete') {
pdo_delete("xcommunity_search", array('id' => $_GPC['id']));
message('删除成功', referer(), 'success');
}
include $this->template('search');
*
* [晓锋] Copyright (c) 2013 qfinfo.cn
*/
/**
* 后台黑名单管理
*/
defined('IN_IA') or exit('Access Denied');
global $_W, $_GPC;
$type = !empty($_GPC['type']) ? $_GPC['type'] : 2;
if ($type == 2) {
$table = 'xcommunity_fled';
} else {
$table = 'xcommunity_carpool';
}
$pindex = max(1, intval($_GPC['page']));
$psize = 10;
$list = pdo_fetchAll("SELECT * FROM" . tablename($table) . "WHERE weid='{$_W['weid']}' AND status = 1 LIMIT " . ($pindex - 1) * $psize . ',' . $psize);
$total = pdo_fetchcolumn("SELECT COUNT(*) FROM" . tablename($table) . "WHERE weid='{$_W['weid']}' AND status = 1");
$pager = pagination($total, $pindex, $psize);
if ($_GPC['op'] == 'delete') {
if ($_GPC['id']) {
pdo_delete($table, array('id' => $_GPC['id']));
echo json_encode(array('state' => 1));
}
} elseif ($_GPC['op'] == 'toblack') {
if ($_GPC['id']) {
pdo_query("UPDATE " . tablename($table) . "SET status =0 WHERE id=:id", array(':id' => $_GPC['id']));
echo json_encode(array('state' => 1));
}
}
include $this->template('black');
<?php
/**
* 微小区模块
*
* [晓锋] Copyright (c) 2013 qfinfo.cn
*/
/**
* 微信端 物业费查询
*/
defined('IN_IA') or exit('Access Denied');
global $_W, $_GPC;
$title = '物业费查询';
$op = !empty($_GPC['op']) ? $_GPC['op'] : 'display';
$member = $this->changemember();
$region = pdo_fetch("SELECT * FROM" . tablename('xcommunity_region') . "WHERE id='{$member['regionid']}'");
if ($op == 'display') {
//查当前公众号下面的费用时间
$list = pdo_fetchAll("SELECT * FROM" . tablename('xcommunity_protime') . "WHERE weid='{$_W['weid']}'");
include $this->template('propertyfree');
}
if ($_GPC['op'] == 'ajax') {
$protime = $_GPC['ym'];
$pro = pdo_fetch("SELECT * FROM" . tablename('xcommunity_protime') . "WHERE protime=:protime AND weid='{$_W['weid']}'", array(':protime' => $protime));
$profrees = pdo_fetchAll("SELECT * FROM" . tablename('xcommunity_propertyfree') . "WHERE protimeid='{$pro['id']}' AND mobile='{$member['mobile']}'");
$result = array('data' => $profrees, 'info' => "成功", 'status' => 1);
print_r(json_encode($result));
}
$condition .= " AND title LIKE '%{$_GPC['keyword']}%'";
}
$list = pdo_fetchAll("SELECT * FROM" . tablename('xcommunity_activity') . "WHERE weid='{$_W['weid']}' {$condition} LIMIT " . ($pindex - 1) * $psize . ',' . $psize);
$total = pdo_fetchcolumn("SELECT COUNT(*) FROM" . tablename('xcommunity_activity') . "WHERE weid='{$_W['weid']}'");
$pager = pagination($total, $pindex, $psize);
} elseif ($op == 'delete') {
pdo_delete('xcommunity_activity', array('id' => $id));
message('删除成功', referer(), 'success');
} elseif ($op == 'res') {
$pindex = max(1, intval($_GPC['page']));
$psize = 20;
$condition = '';
$params = array();
if (!empty($_GPC['keyword'])) {
$condition .= " AND title LIKE :keyword";
$params[':keyword'] = "%{$_GPC['keyword']}%";
}
$list = pdo_fetchAll("SELECT * FROM" . tablename('xcommunity_res') . " WHERE weid='{$_W['weid']}' {$condition} LIMIT " . ($pindex - 1) * $psize . ',' . $psize);
$total = pdo_fetchcolumn("SELECT COUNT(*) FROM" . tablename('xcommunity_res') . "WHERE weid='{$_W['weid']}'");
$pager = pagination($total, $pindex, $psize);
$row = array();
foreach ($list as $key => $value) {
$rows = pdo_fetch("SELECT * FROM" . tablename('xcommunity_activity') . "WHERE id=:id", array(':id' => $value['id']));
$row[] = array('truename' => $value['truename'], 'mobile' => $value['mobile'], 'num' => $value['num'], 'sex' => $value['sex'], 'createtime' => $value['createtime'], 'title' => $rows['title'], 'id' => $value['id']);
}
if (checksubmit('delete')) {
pdo_delete('xcommunity_res', " id IN ('" . implode("','", $_GPC['select']) . "')");
message('删除成功！', referer(), 'success');
}
}
include $this->template('activity');
public function doMobileHouseAdd()
{
global $_GPC, $_W;
$id = intval($_GPC['id']);
$region = pdo_fetchAll("SELECT * FROM" . tablename('hewer_gulluk') . "WHERE weid='{$_W['weid']}'");
if ($_W['ispost']) {
$data = array('weid' => $_W['weid'], 'cate_id' => $_GPC['cate_id'], 'title' => $_GPC['title'], 'gid' => $_GPC['gid'], 'housenow' => $_GPC['housenow'], 'houseall' => $_GPC['houseall'], 'yil' => $_GPC['yil'], 'hrs_lan' => $_GPC['hrs_lan'], 'mianji' => $_GPC['mianji'], 'jiage' => $_GPC['jiage'], 'direction' => $_GPC['direction'], 'house_zx' => $_GPC['house_zx'], 'picstyle' => $_GPC['picstyle'], 'content' => $_GPC['content'], 'linkman' => $_GPC['linkman'], 'jinsi' => $_GPC['jinsi'], 'tel' => $_GPC['tel'], 'wupin' => implode(',', $_GPC['wupin']), 'openid' => $_W['fans']['from_user']);
if (!empty($_FILES['thumb']['tmp_name'])) {
file_delete($_GPC['thumb-old']);
$upload = file_upload($_FILES['thumb']);
if (is_error($upload)) {
message($upload['message'], '', 'error');
}
$data['thumb'] = $upload['path'];
}
if (empty($id)) {
pdo_insert('hewer_house', $data);
message('发布成功', $this->createMobileUrl('house'), 'success');
} else {
pdo_update('hewer_house', $data, array('id' => $id));
message('更新成功', $this->createMobileUrl('house'), 'success');
}
}
include $this->template('addhouse');
}
<?php
/**
* 微小区模块
*
* [晓锋] Copyright (c) 2013 qfinfo.cn
*/
/**
* 后台菜单设置
*/
defined('IN_IA') or exit('Access Denied');
global $_W, $_GPC;
$op = !empty($_GPC['op']) ? $_GPC['op'] : 'display';
$navs = pdo_fetchAll("SELECT * FROM" . tablename('xcommunity_nav') . "WHERE uniacid= '{$_W['uniacid']}'");
if (empty($navs)) {
$data1 = array('displayorder' => 0, 'pcate' => 0, 'title' => '物业服务', 'url' => '', 'status' => 1, 'uniacid' => $_W['uniacid']);
$data2 = array('displayorder' => 0, 'pcate' => 0, 'title' => '小区互动', 'url' => '', 'status' => 1, 'uniacid' => $_W['uniacid']);
$data3 = array('displayorder' => 0, 'pcate' => 0, 'title' => '生活服务', 'url' => '', 'status' => 1, 'uniacid' => $_W['uniacid']);
if ($data1) {
pdo_insert('xcommunity_nav', $data1);
$nid1 = pdo_insertid();
$menu1 = array(array('displayorder' => 0, 'pcate' => $nid1, 'title' => '物业介绍', 'icon' => 'glyphicon glyphicon-user', 'bgcolor' => '#ffb81c', 'url' => $_W['siteroot'] . 'app/index.php?i=' . $_W['uniacid'] . '&c=entry&do=property&m=xfeng_community', 'status' => 1, 'uniacid' => $_W['uniacid']), array('displayorder' => 0, 'pcate' => $nid1, 'title' => '公告信息', 'icon' => 'glyphicon glyphicon-bullhorn', 'bgcolor' => '#95bd38', 'url' => $_W['siteroot'] . 'app/index.php?i=' . $_W['uniacid'] . '&c=entry&do=announcement&m=xfeng_community', 'status' => 1, 'uniacid' => $_W['uniacid']), array('displayorder' => 0, 'pcate' => $nid1, 'title' => '小区报修', 'icon' => 'glyphicon glyphicon-wrench', 'bgcolor' => '#3c87c8', 'url' => $_W['siteroot'] . 'app/index.php?i=' . $_W['uniacid'] . '&c=entry&do=repair&m=xfeng_community', 'status' => 1, 'uniacid' => $_W['uniacid']), array('displayorder' => 0, 'pcate' => $nid1, 'title' => '投诉建议', 'icon' => 'fa fa-legal', 'bgcolor' => '#dd4b2b', 'url' => $_W['siteroot'] . 'app/index.php?i=' . $_W['uniacid'] . '&c=entry&do=report&m=xfeng_community', 'status' => 1, 'uniacid' => $_W['uniacid']), array('displayorder' => 0, 'pcate' => $nid1, 'title' => '便民号码', 'icon' => 'glyphicon glyphicon-earphone', 'bgcolor' => '#ab5e90', 'url' => $_W['siteroot'] . 'app/index.php?i=' . $_W['uniacid'] . '&c=entry&do=phone&m=xfeng_community', 'status' => 1, 'uniacid' => $_W['uniacid']), array('displayorder' => 0, 'pcate' => $nid1, 'title' => '查物业费', 'icon' => 'fa fa-money', 'bgcolor' => '#660000', 'url' => $_W['siteroot'] . 'app/index.php?i=' . $_W['uniacid'] . '&c=entry&do=propertyfree&m=xfeng_community', 'status' => 1, 'uniacid' => $_W['uniacid']));
foreach ($menu1 as $key => $value1) {
pdo_insert('xcommunity_nav', $value1);
}
}
if ($data2) {
pdo_insert('xcommunity_nav', $data2);
$nid2 = pdo_insertid();
$menu2 = array(array('displayorder' => 0, 'pcate' => $nid2, 'title' => '小区活动', 'icon' => 'glyphicon glyphicon-tasks', 'bgcolor' => '#65944e', 'url' => $_W['siteroot'] . 'app/index.php?i=' . $_W['uniacid'] . '&c=entry&do=activity&m=xfeng_community', 'status' => 1, 'uniacid' => $_W['uniacid']), array('displayorder' => 0, 'pcate' => $nid2, 'title' => '家政服务', 'icon' => 'glyphicon glyphicon-leaf', 'bgcolor' => '#95bd38', 'url' => $_W['siteroot'] . 'app/index.php?i=' . $_W['uniacid'] . '&c=entry&do=homemaking&m=xfeng_community', 'status' => 1, 'uniacid' => $_W['uniacid']), array('displayorder' => 0, 'pcate' => $nid2, 'title' => '房屋租赁', 'icon' => 'fa fa-info', 'bgcolor' => '#38bfc8', 'url' => $_W['siteroot'] . 'app/index.php?i=' . $_W['uniacid'] . '&c=entry&do=houselease&m=xfeng_community', 'status' => 1, 'uniacid' => $_W['uniacid']), array('displayorder' => 0, 'pcate' => $nid2, 'title' => '常用查询', 'icon' => 'glyphicon glyphicon-search', 'bgcolor' => '#ec9510', 'url' => $_W['siteroot'] . 'app/index.php?i=' . $_W['uniacid'] . '&c=entry&do=search&m=xfeng_community', 'status' => 1, 'uniacid' => $_W['uniacid']), array('displayorder' => 0, 'pcate' => $nid2, 'title' => '二手市场', 'icon' => 'fa fa-exchange', 'bgcolor' => '#666699', 'url' => $_W['siteroot'] . 'app/index.php?i=' . $_W['uniacid'] . '&c=entry&do=fled&m=xfeng_community', 'status' => 1, 'uniacid' => $_W['uniacid']), array('displayorder' => 0, 'pcate' => $nid2, 'title' => '小区拼车', 'icon' => 'fa fa-truck', 'bgcolor' => '#7f6000', 'url' => $_W['siteroot'] . 'app/index.php?i=' . $_W['uniacid'] . '&c=entry&do=car&m=xfeng_community', 'status' => 1, 'uniacid' => $_W['uniacid']));
foreach ($menu2 as $key => $value2) {
include $this->template('fled_add');
} elseif ($op == 'detail') {
$id = intval($_GPC['id']);
if ($id) {
$item = pdo_fetch("SELECT * FROM" . tablename('xcommunity_fled') . "WHERE id=:id", array(':id' => $id));
if ($item['images']) {
$images = unserialize($item['images']);
if ($images) {
$picid = implode(',', $images);
$imgs = pdo_fetchall("SELECT * FROM" . tablename('xfcommunity_images') . "WHERE id in({$picid})");
}
}
}
include $this->template('fled_detail');
} elseif ($op == 'my') {
$pindex = max(1, intval($_GPC['page']));
$psize = 10;
$condition = '';
if (!empty($_GPC['keyword'])) {
$keyword = "%{$_GPC['keyword']}%";
$condition = " AND title LIKE '{$keyword}'";
}
$list = pdo_fetchAll('SELECT * FROM' . tablename('xcommunity_fled') . "WHERE weid='{$_W['weid']}' AND status = 0 AND regionid='{$member['regionid']}' AND openid='{$_W['fans']['from_user']}' LIMIT " . ($pindex - 1) * $psize . ',' . $psize);
include $this->template('fledindex');
} elseif ($op == 'delete') {
$id = $_GPC['id'];
if (pdo_delete('xcommunity_fled', array('id' => $id))) {
$result['state'] = 0;
message($result, '', 'ajax');
}
}
<?php
/**
* 微小区模块
*
* [晓锋] Copyright (c) 2013 qfinfo.cn
*/
/**
* 微信端常用查询
*/
defined('IN_IA') or exit('Access Denied');
global $_W, $_GPC;
$title = '常用查询';
//判断是否注册
$this->changemember();
$list = pdo_fetchAll("SELECT * FROM" . tablename("xcommunity_search") . "WHERE status='1' AND weid='{$_W['weid']}'");
include $this->template('search');
* [晓锋] Copyright (c) 2013 qfinfo.cn
*/
/**
* 微信端小区活动
*/
defined('IN_IA') or exit('Access Denied');
global $_GPC, $_W;
$title = '小区活动';
$op = !empty($_GPC['op']) ? $_GPC['op'] : 'display';
//判断是否注册，只有注册后，才能进入
$member = $this->changemember();
if ($op == 'display' || $op == 'more') {
$pindex = max(1, intval($_GPC['page']));
$psize = 10;
$condition = '';
$rows = pdo_fetchAll("SELECT * FROM" . tablename('xcommunity_activity') . "WHERE weid='{$_W['weid']}' order by status desc LIMIT " . ($pindex - 1) * $psize . ',' . $psize);
$list = array();
foreach ($rows as $key => $value) {
$regions = unserialize($value['regionid']);
if (@in_array($member['regionid'], $regions)) {
$list[$key]['title'] = $value['title'];
$list[$key]['starttime'] = $value['starttime'];
$list[$key]['endtime'] = $value['endtime'];
$list[$key]['resnumber'] = $value['resnumber'];
$list[$key]['createtime'] = $value['createtime'];
$list[$key]['id'] = $value['id'];
$list[$key]['picurl'] = $value['picurl'];
}
}
if ($op == 'more') {
include $this->template('activity_index_more');
public function doMobileMylist()
{
global $_GPC, $_W;
$item = pdo_fetch("SELECT * FROM " . tablename('bmhospital_slide') . " WHERE weid = :weid", array(':weid' => $_W['weid']));
$hslists = unserialize($item['hs_pic']);
$rebs = pdo_fetchAll("SELECT * FROM" . tablename('bmhospital_reservation') . "WHERE openid='{$_W['fans']['from_user']}'");
if ($_GPC['op'] == 'delete') {
pdo_delete("bmhospital_reservation", array('id' => $_GPC['id']));
message('删除成功', referer(), 'success');
}
$info_picurl = pdo_fetchcolumn("SELECT info_picurl FROM" . tablename('bmhospital_reply') . "WHERE weid='{$_W['weid']}'");
include $this->template('mylist');
}
<?php
header("Content-type:text/csv;");
header("Content-Disposition:attachment;filename=orders.csv");
header('Cache-Control:must-revalidate,post-check=0,pre-check=0');
header('Expires:0');
header('Pragma:public');
$weid = $_W['uniacid'];
$result = pdo_fetchAll("SELECT * FROM " . tablename('heixiu_car_order') . " WHERE weid=" . $weid . " ORDER BY id DESC ");
$meals = pdo_fetchall('SELECT * FROM ' . tablename('heixiu_car_meal') . " ORDER BY id DESC");
$activitys = pdo_fetchAll("SELECT * FROM " . tablename('heixiu_car_activity') . " WHERE weid=" . $weid . " ORDER BY id DESC ");
$title = "订单号" . "," . "姓名" . "," . "电话" . "," . "预约时间" . "," . "状态" . "," . "车牌号" . "," . "区域" . "," . "套餐" . "," . "价格" . "," . "技师名称" . "," . "时间" . "\n";
$mealArr = array();
foreach ($meals as $v) {
$mealArr[$v['id']] = $v['title'];
}
if (isWin()) {
echo iconv('utf-8', 'gb2312', $title);
foreach ($result as $key => $value) {
$txt = "";
if ($value['status'] == 0) {
$txt = '待确认 ';
} elseif ($value['status'] == 1) {
$txt = '已确认';
} elseif ($value['status'] == -1) {
$txt = '已关闭';
}
$temp = $value['ordersn'] . "," . $value['username'] . "," . $value['mobile'] . "," . $value['appointmenttime'] . $value['timezone'] . "," . $txt . "," . $value['carprefix'] . $value['carNo'] . "," . $value['address'] . "," . $mealArr[$value['mealid']] . "," . $value['price'] . "," . $value['jsname'] . "," . date("Y-m-d G:i", $value['createtime']) . "\n";
echo iconv('utf-8', 'gb2312', $temp);
}
} else {
<?php
/**
* 微小区模块
*
* [晓锋] Copyright (c) 2013 qfinfo.cn
*/
/**
* 后台小区通知设置
*/
defined('IN_IA') or exit('Access Denied');
global $_GPC, $_W;
$op = !empty($_GPC['op']) ? $_GPC['op'] : 'display';
if ($op == 'display') {
$list = pdo_fetchAll("SELECT * FROM" . tablename('xcommunity_wechat_notice') . "WHERE uniacid = '{$_W['uniacid']}' AND regionid='{$_GPC['regionid']}'");
} elseif ($op == 'post') {
if ($_W['ispost']) {
$data = array('uniacid' => $_W['uniacid'], 'regionid' => $_GPC['regionid'], 'fansopenid' => $_GPC['fansopenid'], 'repair_status' => $_GPC['repair_status'], 'report_status' => $_GPC['report_status']);
if ($_GPC['id']) {
if (pdo_update('xcommunity_wechat_notice', $data, array('id' => $_GPC['id']))) {
message('提交成功', referer(), 'success');
}
} else {
if (pdo_insert('xcommunity_wechat_notice', $data)) {
message('提交成功', referer(), 'success');
}
}
}
} elseif ($op == 'delete') {
if (pdo_delete('xcommunity_wechat_notice', array('id' => $_GPC['id']))) {
$result = array('status' => 1);
<?php
/**
* 微小区模块
*
* [晓锋] Copyright (c) 2013 qfinfo.cn
*/
/**
* 微信端首页
*/
defined('IN_IA') or exit('Access Denied');
global $_GPC, $_W;
$title = $_W['account']['name'];
$member = $this->changemember();
$nav1 = pdo_fetchAll("SELECT * FROM" . tablename('xcommunity_navExtension') . "WHERE weid='{$_W['weid']}' AND cate=1");
$nav2 = pdo_fetchAll("SELECT * FROM" . tablename('xcommunity_navExtension') . "WHERE weid='{$_W['weid']}' AND cate=2");
$nav3 = pdo_fetchAll("SELECT * FROM" . tablename('xcommunity_navExtension') . "WHERE weid='{$_W['weid']}' AND cate=3");
include $this->template('home');
