智能会务管理v1.0.4微信公众号源码

<?php defined('IN_IA') or exit('Access Denied'); class xw_yishenggzModuleSite extends WeModuleSite { public function doWebSystem(){ global $_GPC,$_W; $setting = pdo_fetch('select * from ' . tablename('xwqd_setting') . ' where uniacid = :uniacid ',[':uniacid' => $_W['uniacid']]); if(!empty($setting)){ $setting['text_style'] = unserialize ($setting['text_style']); $setting['share'] = unserialize ($setting['share']); } if(checksubmit('submit')){ $data = $_GPC['data']; $text = $_GPC['text']; $share = $_GPC['share']; $data['appid'] = trim($data['appid']); $data['appsecret'] = trim($data['appsecret']); $data['index_banner'] = trim($data['index_banner']); $data['list_banner'] = trim($data['list_banner']); $data['wxts'] = trim($data['wxts']); $data['mess_id'] = trim($data['mess_id']); $data['uniacid'] = $_W['uniacid']; if(!empty($text)){ foreach($text as $key => $val){ $text[$key] = trim($val); } $data['text_style'] = serialize($text); } if(!empty($share)){ foreach($share as $k => $v){ $share[$k] = trim($v); } $data['share'] = serialize($share); } /*if(empty($data['appid']) || empty($data['appsecret'])){ message('请填写appid和appsecret','','error'); }*/ if(empty($setting)){ $result = pdo_insert('xwqd_setting',$data); }else{ $result = pdo_update('xwqd_setting',$data,['uniacid'=>$_W['uniacid']]); } if($result){ message('保存成功','','success'); }else{ message('保存失败','','error'); } } include $this->template('system'); } public function doWebContents() { global $_GPC, $_W; $contents = pdo_fetch('select * from ' . tablename('xwqd_contents') . ' where uniacid = :uniacid' , [':uniacid' => $_W['uniacid']]); if(checksubmit('submit')) { $data = [ 'uniacid' => $_W['uniacid'], 'hyyc' => $_GPC['hyyc'], 'xcap' => $_GPC['xcap'], 'hyzy' => $_GPC['hyzy'], 'hwfw' => $_GPC['hwfw'], 'wxts' => $_GPC['wxts'] ]; if(empty($contents)) { $result = pdo_insert('xwqd_contents',$data); }else{ $result = pdo_update('xwqd_contents',$data,['uniacid' => $_W['uniacid']]); } if(!empty($result)) { message('保存成功', referer(), 'success'); }else{ message('保存失败', referer(), 'error'); } } include $this->template('contents'); } public function doWebMember(){ global $_GPC, $_W; // 'select a.*,b.nickname from ims_xwqd_member as a left join ims_mc_members as b on a.user_id = b.uid where a.uniacid =:uniacid limit 0,20' $setting = pdo_fetch('select * from ' . tablename('xwqd_setting') . ' where uniacid = :uniacid ',[':uniacid' => $_W['uniacid']]); $text_style = unserialize ($setting['text_style']); $pindex = max(1, intval($_GPC['page'])); $psize = 50; $total = pdo_fetchcolumn("select count(*) from " . tablename('xwqd_member') . " where :uniacid = :uniacid ", [':uniacid' => $_W['uniacid']]); $member = pdo_fetchall('select a.*,b.nickname from ' .tablename('xwqd_member') . ' as a ' . ' left join ' . tablename('mc_members') . ' as b ' . ' on a.user_id = b.uid where a.uniacid =:uniacid limit ' . ($pindex - 1) * $psize . ', ' . $psize ,[':uniacid' => $_W['uniacid']]); $pager = pagination($total, $pindex, $psize); include $this->template('member'); } public function doWebMember_delete(){ global $_GPC, $_W; $id = intval($_GPC['id']); $empty = intval($_GPC['empty']); $result = pdo_delete('xwqd_member' , ['id' => $id]); if(!empty($empty)){ $result = pdo_delete('xwqd_member' , ['uniacid' => $_W['uniacid']]); } if($result){ message('删除成功',referer(), 'success'); }else{ message('删除失败', referer(), 'error'); } } public function doWebMember_add(){ global $_GPC, $_W; $id = intval($_GPC['id']); if(checksubmit('submit')){ $data = $_GPC['data']; $data['uniacid'] = $_W['uniacid']; if(strlen($data['user_moblie']) != 11){ message('输入手机号不正确',referer(), 'error'); } $data['user_id'] = empty(intval($data['user_id'])) ? 0 : intval($data['user_id']); if(!empty($id)){ $result = pdo_update('xwqd_member',$data,['id' => $id,'uniacid' => $_W['uniacid']]); }else{ $result = pdo_insert('xwqd_member', $data); } if($result){ message('保存成功',$this->createWebUrl('member'), 'success'); }else{ message('保存失败',referer(), 'error'); } } if(!empty($id)){ $member_info = pdo_fetch('select * from ' . tablename('xwqd_member') . ' where uniacid = :uniacid and id = :id',[':uniacid' => $_W['uniacid'], ':id' => $id]); } include $this->template('member_add'); } public function doWebExport(){ global $_GPC,$_W; $str = "id\t姓名\t手机号码\t研讨会座位号\t演出座位号\t晚宴座位号\t车次号\t状态\n"; $list = pdo_fetchall('select * from ' . tablename('xwqd_member') . ' where uniacid =:uniacid ' , [':uniacid' => $_W['uniacid']]); foreach ($list as $v) { $v['status'] = $v['user_id'] ? '已签到' : '未签到' ; $str .= $v['id'] . "\t" . $v['user_name'] . "\t" . $v['user_moblie'] . "\t" . $v['ythzh'] . "\t" . $v['yczh'] . "\t" . $v['wyzh'] . "\t" . $v['cch'] . "\t" . $v['status'] . "\n" ; } $filename = "人员列表_".date('Ymd').'.xls'; $this->export_csv($filename,$str); } public function doWebImport(){ global $_GPC,$_W; if( checksubmit('submit') ){ $filename = $_FILES['file']['tmp_name']; if (empty ($filename)) { message('请选择要导入的CSV文件！'); } $handle = fopen($filename, 'r'); $result = $this->input_csv($handle); //解析csv $len_result = count($result); if($len_result==0){ message('抱歉！CSV文件没有任何数据！'); } $data_values = []; for ($i = 1; $i < $len_result; $i++) { //循环获取各字段值 $username = iconv('GBK','UTF-8//TRANSLIT//IGNORE', $result[$i][0]); $user_moblie = iconv('GBK','UTF-8//TRANSLIT//IGNORE', $result[$i][1]); $ythzh = iconv('GBK','UTF-8//TRANSLIT//IGNORE', $result[$i][2]); $yczh = iconv('GBK','UTF-8//TRANSLIT//IGNORE', $result[$i][3]); $wyzh = iconv('GBK','UTF-8//TRANSLIT//IGNORE', $result[$i][4]); $cch = iconv('GBK','UTF-8//TRANSLIT//IGNORE', $result[$i][5]); $data_values[$i] = ['user_name' => $username, 'user_moblie' => $user_moblie, 'ythzh' => $ythzh, 'yc