// 是否赞
$data['importance'] = 0;
//默认为普通文章，若为1则是重要文章
$data['abstract'] = $abstract;
//摘要
/**
* *****存入wx_info数据库***********
*
*/
//查看是否是文化理念
$sql_type = "select type from wx_articlelist_module where id=" . $moduleId;
$res_type = $db->getrow($sql_type);
if ($res_type['type'] == 2) {
//该模块为文化理念，删除其他文章，只留一篇文章
$sql_delete = "delete from wx_info where moduleId=" . $moduleId;
$res_delete = $db->execsql($sql_delete);
}
$insert = $db->insert('wx_info', $data);
// 插入语句
if ($insert) {
$upload['infoId'] = mysql_insert_id();
$upload['error'] = 1;
// 保存成功
if ($res_type['type'] == 2) {
//该模块为文化理念，修改文化理念的微信端链接
$urlWechat = "../../culture/html/culturelist.php?arctileId=" . $upload['infoId'];
$urlPC = "../../article/html/cultureidea.html?articleId=" . $upload['infoId'];
$sql_update = "update wx_articlelist_module set urlWechat='{$urlWechat}' and urlPC='{$urlPC}' where id=" . $moduleId;
$res_update = $db->execsql($sql_update);
}
if ($public == 1) {
header("content-type:text/json;charset=utf-8");
$path = dirname(dirname(dirname(__FILE__)));
// echo $path;
require_once '../../../common/php/dbaccess.php';
require_once '../../../common/php/uploadFiles.php';
require_once '../../../common/php/regexTool.class.php';
session_start();
$db = new DB();
$regex = new regexTool();
$file = array();
$type = $_GET['type'];
//获取type的值
//$type="modify_past";
if ($type == "show") {
$sql_show = "select * from wx_talent_philosophy ";
$res_show = $db->execsql($sql_show);
// var_dump($res_show);
if (empty($res_show)) {
$file['empty'] = true;
} else {
$file['empty'] = false;
$file['show'] = $res_show;
}
echo json_encode($file);
} elseif ($type == 'updateInfo') {
/**
* *****************后台管理员编辑、修改文章信息的具体内容,点击“修改”按钮**********************
*/
$infoId = $_GET['infoId'];
//获取显示具体内容的文章信息ID
//$infoId = 5; // 获取显示具体内容的文章信息ID
//请检查空值
} else {
if (empty($subcom['coordinate'])) {
echo 3;
//坐标值获取失败
} elseif (!$regex->isEmail($subcom['email'])) {
echo 4;
//email格式错误
} else {
//判断是否有置顶项，若有，则取消其他置顶
if ($subcom['isTop'] == 1) {
$sql_top = "select id from wx_map where isTop=1";
$res_top = $db->getrow($sql_top);
if (!empty($res_top)) {
$sql_topDel = "update wx_map set isTop=0 where id=" . $res_top['id'];
$res_topDel = $db->execsql($sql_topDel);
}
}
//判断同一子公司名称是否重复添加
$sql_repeat = "select id from wx_map where companyName='{$subcom['companyName']}'";
$res_repeat = $db->getrow($sql_repeat);
if (!empty($res_repeat)) {
echo 6;
//该子公司信息已存在，不能重复添加
} else {
$insert = $db->insert('wx_map', $subcom);
if ($insert) {
echo 1;
//添加成功
} else {
echo 0;
//微信端显示
$a = 1;
// $review_name="往期回顾";
// $sql_name="select id ,name from wx_activity_module where name !='{$review_name}'";
// // echo $sql_name;
// $res_name=$db->execsql($sql_name);
// $file['activity_IdandName']=$res_name; //所有用于往期回顾活动的ID和名字
$reviewName = $_POST['reviewName'];
$sql = "select * from " . $reviewName . " where review = " . $a;
// echo $sql;die;
$result = mysql_query($sql);
// var_dump($result);
$sql_list = "select id,title,review,start from " . $reviewName . " where review =\n\t\t'{$a}' and valid = 0 order by start desc limit " . $start . "," . $num;
//选择能够往期回顾的活动
// echo $sql_list;die;
$res_list = $db->execsql($sql_list);
// var_dump($res_list);
$file['details_dataBase'] = $reviewName;
//往期回顾的活动名称
$file['list'] = $res_list;
//往期回顾的列表显示信息
$file['num'] = mysql_num_rows($result);
// echo $reviewName;die;
$sql_details = "select fronturl from wx_activity_module where reviewTable = '{$reviewName}'";
// echo $sql_details;die;
$res_details = $db->getrow($sql_details);
// var_dump($res_details);
$file['fronturl'] = $res_details;
echo json_encode($file);
} elseif ($list_type == "manager_delete") {
//删除往期回顾
/*
* ***********招聘信息标题列表显示*********************
*/
if ($type == "list") {
$page = $_POST['page'];
//获取页码
// $page=1;
$num = 10;
//每页的容量
$start = ($page - 1) * $num;
$sql = "SELECT * FROM wx_talent_recruit";
$result = mysql_query($sql);
// $sql_list="select * from wx_talent_recruit order by date desc limit ".$start.",".$num;
$sql_list = "select title,date,id from wx_talent_recruit order by date desc limit " . $start . "," . $num;
// echo $sql_list;die;
$res_list = $db->execsql($sql_list);
$file['list'] = $res_list;
$file['num'] = mysql_num_rows($result);
// var_dump($res_list);die;
echo json_encode($file);
/*
* **********招聘信息的详细展示******************
*/
} elseif ($type == "details") {
// echo "234";
$details_id = $_POST['id'];
//获取要查看的招聘信息ID
// $details_id=24;
$sql_details = "select * from wx_talent_recruit where id=" . $details_id;
$res_details = $db->getrow($sql_details);
$file['details'] = $res_details;
function delmenu($menuType, $menuId)
{
$db = new DB();
if ($menuType == 1) {
/*
* 若要删除的菜单按钮为活动类型,则活动的模块表为wx_activity_module
*/
// 查找出存储活动数据的表
$sql_table = "select b.id,reviewTable from wx_wechat_module as a left join wx_activity_module as b on a.id=b.menuid where a.id='{$menuId}'";
$res_table = $db->getrow($sql_table);
if ($res_table['reviewTable'] == 'wx_activity_interact_project') {
/*
* 图片互动类型的活动
*/
$sql_delete_interact = "DELETE a,b,c,d from wx_activity_interact as b left join wx_activity_interact_project as a on a.id=b.projectId\n\t\t\tleft join wx_activity_leaveword as c on c.activityId=b.id\n\t\t\tleft join wx_activity_zan as d on d.activityId=b.id\n\t\t\twhere a.moduleId='{$res_table['id']}'";
$res_delete_interact = $db->execsql($sql_delete_interact);
if (mysql_affected_rows() >= 0) {
$error1 = 1;
//删除成功
} else {
$error1 = 0;
//删除失败
}
} elseif ($res_table['reviewTable'] == 'wx_vote_project') {
/*
* 投票类型的活动
*/
$sql_delete_vote = "delete a,b,c from wx_vote_project as a left join wx_vote_option as b on b.voteId=a.id\n\t\t\t\t\t left join wx_vote_interact as c on c.voteId=a.id";
$res_delete_vote = $db->execsql($sql_delete_vote);
if (mysql_affected_rows() >= 0) {
$error1 = 1;
//删除成功
} else {
$error1 = 0;
//删除失败
}
}
// 删除菜单数据库表
$sql_delete_menu = "delete a,b from wx_wechat_module as a left join wx_activity_module as b on a.id=b.menuId where a.id='{$menuId}'";
$res_delete_menu = $db->execsql($sql_delete_menu);
if (mysql_affected_rows() > 0) {
$error2 = 1;
// 删除成功
} else {
$error2 = 0;
// 删除失败
}
if ($error1 && $error2) {
$del['error'] = "删除成功";
} else {
$del['error'] = "删除失败";
}
} elseif ($menuType == 2) {
/*
* 若要删除的菜单按钮为文章列表类型,则活动的模块表为wx_activity_module
*/
// 判断要删除的是否是菜单
if ($menuId != 0) {
/*
* 是菜单类型
*/
// 删除相关文件
$sql_file = "select thumb,media from wx_info as b left join wx_articlelist_module as a on a.id=b.moduleId where a.menuId='{$menuId}'";
$res_file = $db->execsql($sql_file);
foreach ($res_file as $val_file) {
if (!empty($val_file['thumb'])) {
unlink($val_file['thumb']);
}
if (!empty($val_file['media'])) {
$media = explode(';', $val_file['media']);
foreach ($media as $key_media => $val_media) {
if (empty($val_media)) {
unset($media[$key_media]);
} else {
unlink($val_media);
}
}
}
}
// 删除数据库中的数据
$sql_delete_articlelist = "DELETE a,b,c,d from wx_info as b left join wx_articlelist_module as a on a.id=b.moduleId\n\t\t\tleft join wx_leaveword as c on c.infoId=b.id\n\t\t\tleft join wx_zan as d on d.infoId=b.id\n\t\t\twhere a.menuId='{$menuId}'";
$res_delete_articlelist = $db->execsql($sql_delete_articlelist);
if (mysql_affected_rows() >= 0) {
$error1 = 1;
//删除成功
} else {
$error1 = 0;
//删除失败
}
// 删除菜单数据库表
$sql_delete_menu = "delete a,b from wx_wechat_module as a left join wx_articlelist_module as b on a.id=b.menuId where a.id='{$menuId}'";
$res_delete_menu = $db->execsql($sql_delete_menu);
if (mysql_affected_rows() > 0) {
$error2 = 1;
// 删除成功
} else {
$error2 = 0;
// 删除失败
}
if ($error1 && $error2) {
$del['error'] = "删除成功";
} else {
$del['error'] = "删除失败";
}
} else {
$del['error'] = "不是菜单类型，不能删除";
}
} elseif ($menuType == 3) {
/*
* 菜单类型为人才理念
*/
$sql_delete_talent2 = "delete from wx_talent_philosophy";
$sql_delete_talent2 = $db->execsql($sql_delete_talent2);
if (mysql_affected_rows() >= 0) {
$errortalent2 = 1;
// 删除成功
} else {
$errortalent2 = 0;
// 删除失败
}
// 删除菜单数据库表
$sql_delete_menu = "delete from wx_wechat_module where id='{$menuId}'";
$res_delete_menu = $db->execsql($sql_delete_menu);
if (mysql_affected_rows() > 0) {
$errortalent1 = 1;
// 删除成功
} else {
$errortalent1 = 0;
// 删除失败
}
if ($errortalent1 && $errortalent2) {
$del['error'] = "删除成功";
} else {
$del['error'] = "删除失败";
}
} elseif ($menuType == 4) {
/*
* 菜单类型为人才招聘
*/
$sql_delete_talent1 = "delete from wx_talent_recruit";
$res_delete_talent1 = $db->execsql($sql_delete_talent1);
if (mysql_affected_rows() >= 0) {
$errortalent1 = 1;
// 删除成功
} else {
$errortalent1 = 0;
// 删除失败
}
// 删除菜单数据库表
$sql_delete_menu = "delete from wx_wechat_module where id='{$menuId}'";
$res_delete_menu = $db->execsql($sql_delete_menu);
if (mysql_affected_rows() > 0) {
$errortalent2 = 1;
// 删除成功
} else {
$errortalent2 = 0;
// 删除失败
}
if ($errortalent1 && $errortalent2) {
$del['error'] = "删除成功";
} else {
$del['error'] = "删除失败";
}
} elseif ($menuType == 5) {
/*
* 菜单类型为企业简介
*/
// 删除相关文件
$sql_file = "select picture from wx_profile";
$res_file = $db->execsql($sql_file);
foreach ($res_file as $val_file) {
unlink($val_file['picture']);
}
// 删除数据库中的数据
$sql_delete_profile = "delete from wx_profile";
$res_delete_profile = $db->execsql($sql_delete_profile);
if (mysql_affected_rows() >= 0) {
$error1 = 1;
// 删除成功
} else {
$error1 = 0;
// 删除失败
}
// 删除菜单数据库表
$sql_delete_menu = "delete from wx_wechat_module where id='{$menuId}'";
$res_delete_menu = $db->execsql($sql_delete_menu);
if (mysql_affected_rows() > 0) {
$error2 = 1;
// 删除成功
} else {
$error2 = 0;
// 删除失败
}
if ($error1 && $error2) {
$del['error'] = "删除成功";
} else {
$del['error'] = "删除失败";
}
} elseif ($menuType == 6) {
/*
* 菜单类型为地图导航
*/
// 删除数据库中的数据
$sql_delete_map = "delete from wx_map";
$res_delete_map = $db->execsql($sql_delete_map);
if (mysql_affected_rows() >= 0) {
$error1 = 1;
// 删除成功
} else {
$error1 = 0;
// 删除失败
}
// 删除菜单数据库表
$sql_delete_menu = "delete from wx_wechat_module where id='{$menuId}'";
$res_delete_menu = $db->execsql($sql_delete_menu);
if (mysql_affected_rows() > 0) {
$error2 = 1;
// 删除成功
} else {
$error2 = 0;
// 删除失败
}
if ($error1 && $error2) {
$del['error'] = "删除成功";
} else {
$del['error'] = "删除失败";
}
}
return $del;
}
* ************显示文章信息列表***************
*/
$page = $_REQUEST['page'];
$moduleId = $_REQUEST['moduleId'];
$list = array();
//根据moduleId查询模块名称
$sql_name = "select name from wx_articlelist_module where id=" . $moduleId;
$res_name = $db->getrow($sql_name);
$list['moduleName'] = $res_name['name'];
$num = 10;
//每页显示10条
$start = ($page - 1) * $num;
//本页显示的起始位置
// 从wx_info中查询出文章信息的基本文章信息
$sql_info_num = "select id from wx_info where moduleId='{$moduleId}' and importance=0 ";
$res_info_num = $db->execsql($sql_info_num);
$list['PageNum'] = ceil(count($res_info_num) / $num);
if ($page == 1) {
//查找是否有置顶项，在首页显示
$sql_top_select = "select id,title,thumb,abstract,content,date,is_leaveword,is_zan,importance from wx_info where moduleId='{$moduleId}' and importance=1 order by date desc ";
$res_top_select = $db->execsql($sql_top_select);
if (!empty($res_top_select)) {
//有置顶项
$list['top'] = $res_top_select;
}
$sql_info = "select id,title,thumb,abstract,content,date,importance from wx_info where moduleId='{$moduleId}' and importance=0 order by date desc limit " . $start . "," . $num;
$res_info = $db->execsql($sql_info);
} else {
$sql_info = "select id,title,thumb,abstract,content,date,importance from wx_info where moduleId='{$moduleId}' and importance=0 order by date desc limit " . $start . "," . $num;
$res_info = $db->execsql($sql_info);
}
<?php
/**
* 判断用户是否已在PC端绑定，并根据微信ID将职员编号取出，保存到session中
*/
require_once 'dbaccess-SAE.php';
require_once 'getuser.php';
$db = new DB();
session_start();
// 获取微信ID
//$openid = '0002';
// 判断微信是否已确认绑定
$flag = $_GET['flag'];
if ($flag == 1) {
$sql = "update t_hs_wechat set FType = 1 where FWechatID='{$openid}'";
$db->execsql($sql);
}
$sql_type = "select FType,FNumber from t_hs_wechat where FWechatID='{$openid}'";
$res_type = $db->getrow($sql_type);
// var_dump($res_type);die;
if (count($res_type) == 0) {
//没有记录
//echo 2; // 请先在PC端绑定微信号
echo "<p>您的微信ID为：<b>" . $openid . "</b></p>";
echo "请先在PC端绑定微信号";
$db->db_close();
die;
} elseif ($res_type['FType'] == 0) {
//echo 0; // 显示确认界面
$fnumber = $res_type['FNumber'];
$sql = "select a.FName, b.FName,c.FName from t_hs_employee as a inner join t_hs_company as b on a.FCompanyID == b.FID inner join \n\t t_hs_section as c on a.FSectionID == c.FID where a.FNumber == '" . $fnumber . "'";
require_once '../../../common/php/regexTool.class.php';
require_once '../../../common/php/leaveword.class.php';
require_once '../../../common/php/zan.class.php';
session_start();
$openid = $_SESSION['openid'];
$db = new DB();
$lwd = new LWD('wx_activity_leaveword');
$zan = new ZAN('wx_activity_zan');
$regex = new regexTool();
$type = $_GET['type'];
if ($type == "ing") {
/***************************显示当前正在进行的活动*************************/
//将活动中的过期的活动关闭
//wx_activity_interact_project表
$sql_valid_activity = "select valid,end,id from wx_activity_interact_project";
$res_valid_activity = $db->execsql($sql_valid_activity);
$nowTime = time();
foreach ($res_valid_activity as $val_valid_activity) {
if ($val_valid_activity['valid'] == 1) {
if (strtotime($val_valid_activity['end']) <= $nowTime) {
$sql_update_activity = "update wx_activity_interact_project set valid=0 where id='{$val_valid_activity['id']}'";
$res_update_activity = $db->execsql($sql_update_activity);
}
}
}
/*********************************显示活动*************************************/
$moduleId = $_GET['moduleId'];
if ($regex->isNumber($moduleId)) {
$page = $_GET['page'];
//获得当前页码
$num = 10;
<?php
header('content-type:text/html;charset=utf-8');
require_once '../php/db_mysql/dbaccess.php';
// error_reporting(0);
session_start();
if (empty($_GET['function_name']) && empty($_GET['path']) && empty($_GET['id'])) {
echo 2;
//空值
} else {
$db = new DB();
$_SESSION['user']['number'] = $_SESSION['user']['name'];
$_SESSION['user']['modify_person'] = $_SESSION['user']['name'];
$call['function_name'] = $_GET['function_name'];
$call['path'] = $_GET['path'];
$call['interface_detail'] = $_GET['interface_detail'];
$call['modify_time'] = date('Y-m-d H:i:s', time());
$_SESSION['user']['name'] = $_GET['modify_persion'];
$sql = "UPDATE showinterfacetable set function_name='{$_GET['function_name']}',path='{$_GET['path']}',interface_detail='{$_GET['interface_detail']}',modify_time='{$call['modify_time']}',modify_person='{$_GET['modify_persion']}' where id={$_GET['id']}";
//echo $sql;
$res = $db->execsql($sql);
if ($res) {
echo 1;
//成功
} else {
echo 0;
//失败
}
}
/**
* **判断标题内容是否为空****
*/
$title = $_POST['title'];
$content = $_POST['content'];
$moduleId = $_POST['moduleId'];
$abstract = $_POST['abstract'];
$subtype = $_GET['subtype'];
$articleupload = $_REQUEST['articleupload'];
$public = $_POST['public'];
//1：是；0:否
$picurl = $_POST['picurl'];
//echo "test".$picurl;//die;
//查询文章的最大排序字段
$sql_max_seq = "SELECT MAX( seq ) as max_seq FROM wx_info WHERE moduleId ='{$moduleId}'";
$res_max_seq = $db->execsql($sql_max_seq);
$seq = $res_max_seq[0]['max_seq'] + 1;
//echo "subtype".$subtype;
if ($subtype == 'upvideo') {
/**
* ***视频上传功能***
*/
unset($_SESSION['upvideo']);
$dest = uploadmulti('video', 1);
$_SESSION['upvideo'] = $dest[0];
echo $dest[0];
} elseif (empty($title) || empty($content)) {
$upload['error'] = 2;
// 标题和内容不能为空
} elseif (get_strlength($abstract) > 200) {
$upload['error'] = 3;
<?php
header("content-type:text/json;charset=utf-8");
require_once '../../../common/php/dbaccess.php';
$db = new DB();
// 查询出图文类型的模块名称
$sql_type = "select id,name,urlPC from wx_articlelist_module where type=0";
$res_type = $db->execsql($sql_type);
foreach ($res_type as $key_type => $val_type) {
if (!empty($val_type['urlPC'])) {
$type[$key_type]['name'] = $val_type['name'];
$type[$key_type]['moduleId'] = $val_type['id'];
}
}
echo json_encode($type);
require_once '../../../common/php/dbaccess.php';
require_once '../../../common/php/uploadFiles.php';
require_once '../../../common/php/regexTool.class.php';
require_once '../../../common/php/leaveword_pc.class.php';
require_once '../../../common/php/zan.class.php';
$db = new DB();
$lwd = new LWD('wx_activity_leaveword');
$zan = new ZAN('wx_activity_zan');
$regex = new regexTool();
$type = $_REQUEST['type'];
if ($type == 'list') {
/***************将过期的活动关闭，并分页显示图片互动活动列表*******************/
//将活动中的过期的活动关闭
//wx_activity_interact_project表
$sql_valid_activity = "select valid,end,id from wx_activity_interact_project";
$res_valid_activity = $db->execsql($sql_valid_activity);
// var_dump($res_valid_activity);
$nowTime = time();
// echo $nowTime;die;
foreach ($res_valid_activity as $val_valid_activity) {
if ($val_valid_activity['valid'] == 1) {
if (strtotime($val_valid_activity['end']) <= $nowTime) {
$sql_update_activity = "update wx_activity_interact_project set valid=0 where id='{$val_valid_activity['id']}'";
$res_update_activity = $db->execsql($sql_update_activity);
}
}
}
/* //wx_vote_project表
$sql_valid_vote="select valid,end,id from wx_vote_project";
$res_valid_vote=$db->execsql($sql_valid_vote);
// var_dump($res_valid_vote);
$is_zan = 1;
} else {
$is_zan = 0;
}
/*****构造wx_info数据库表的数据结构****/
$data['userId'] = $_SESSION['user']['id'];
//用户ID
$data['picture'] = $dest_db;
//图片地址
$data['moduleId'] = $_POST['moduleId'];
//模块信息
$data['date'] = date('Y-m-d H-i-s', time());
//日期
$data['title'] = $_POST['title'];
//标题
$data['content'] = $_POST['content'];
//内容
$data['is_leaveWord'] = $is_leaveWord;
//是否评论
$data['is_zan'] = $is_zan;
//是否赞
/*******存入wx_info数据库************/
$insert = $db->insert('wx_info', $data);
if ($db->execsql($insert)) {
$data['error'] = 0;
//保存成功
} else {
$data['error'] = 1;
//保存失败
}
echo json_encode($data);
if ($nickname == "" || $headimgurl == "") {
$url2 = "https://api.weixin.qq.com/cgi-bin/user/info?access_token=" . $access_token . "&openid=" . $openid . "&lang=zh_CN";
$res2 = getData($url2);
$result2 = json_decode($res2, true);
$nickname = $result2['nickname'];
$headimgurl = $result2['headimgurl'];
}
//查找数据库中是否有该用户信息，若没有，则添加
$_SESSION['openid'] = $openid;
$_SESSION['nickname'] = $nickname;
$_SESSION['headimgurl'] = $headimgurl;
$sql_user = "******";
$res_user = $db->getrow($sql_user);
if (empty($res_user)) {
$sql_insert = "insert into wx_user (openId,wechatName,header) values('{$openid}','{$nickname}','{$headimgurl}')";
$res_insert = $db->execsql($sql_insert);
} elseif ($res_user['wechatName'] != $nickname || $res_user['header'] != $headimgurl) {
$sql_update = "update wx_user set wechatName='{$nickname}' and header='{$headimgurl}' where id='{$res_user['id']}'";
$res_update = $db->execsql($sql_update);
}
}
function getData($url)
{
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0 (compatible; MSIE 5.01; Windows NT 5.0)');
curl_setopt($ch, CURLOPT_ENCODING, 'gzip');
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
$data = curl_exec($ch);
} else {
$upload['error'] = $result['errcode'];
//消息发送失败
$upload['errmsg'] = $result['errmsg'];
}
//end预览接口
} else {
$upload['error'] = 7;
//请选择需要推送的文章
}
}
echo json_encode($upload);
} else {
//将预览的文章删除
$sql_del_preview = "delete from wx_info where preview=1";
$res_del_preview = $db->execsql($sql_del_preview);
$articles = $_POST['data'];
//接收到的json格式的文章数组
foreach ($articles as $key => $val) {
if (empty($val)) {
array_splice($articles, $key, 1);
}
}
//修改mouleId，实现不归类功能
foreach ($articles as $key_mo => $val_mo) {
if (!$regex->isNumber($val_mo['moduleId'])) {
$articles[$key_mo]['moduleId'] = 0;
}
}
$flag = 1;
//用于标志文章信息插入数据库是否成功，默认值为1
<?php
header("content-type:text/json;charset=utf-8");
require_once '../../../common/php/dbaccess.php';
$db = new DB();
$type = $_GET['type'];
// $type="show";
if ($type == "show") {
$sql_show = "select * from wx_audit";
$res_show = $db->execsql($sql_show);
// var_dump($res_show);
echo json_encode($res_show);
} elseif ($type == "set") {
$lwd = $_GET["lwd"];
//评论功能是否审核
$pic = $_GET["pic"];
//图片互动是否审核
$sql_setlwd = "update wx_audit set flag='{$lwd}' where name='leaveword'";
// echo $sql_setlwd;die;
$res_setlwd = $db->execsql($sql_setlwd);
if (mysql_affected_rows() >= 0) {
$result1 = true;
} else {
$result1 = false;
}
$sql_setpic = "update wx_audit set flag='{$pic}' where name='pictureInteract'";
$res_setpic = $db->execsql($sql_setpic);
if (mysql_affected_rows() >= 0) {
$result2 = true;
} else {
$result2 = false;
if ($past_password != $a) {
echo 0;
//密码输入错误
} elseif ($past_password == $a) {
echo 1;
}
} elseif ($passwordType == "newpwdType") {
$now_password1 = $_POST['now_password1'];
//获取用户第一次的新密码
$now_password2 = $_POST['now_password2'];
//获取用户第二次的新密码
/*************判断两次新密码输入是否相同***************/
if ($now_password1 == $now_password2) {
// echo 123;
$now_password1 = md5(md5($now_password1));
$sql_update = "update wx_admin set pwd='{$now_password1}' where id = " . $_SESSION['admin']['id'];
// 存入数据库
$res_update = $db->execsql($sql_update);
$res = mysql_affected_rows();
if ($res > 0) {
echo 1;
// 修改成功
} else {
echo 0;
// 修改失败
}
} elseif ($now_password1 != $now_password2) {
echo 2;
//密码输入不一致
}
}
<?php
session_start();
header("Content-type: text/html; charset=utf-8");
require_once '../php/db_mysql/dbaccess.php';
// error_reporting(0);
$db = new DB();
$username = '******';
$password = 123;
$sql = "select * from showinterfacetable where version=1";
$result = $db->execsql($sql);
$num = count($result);
$arr = json_encode($result);
echo $arr;
$status = 0;
if (empty($result)) {
$status = -1;
} else {
$status = 1;
}
$regex = new regexTool();
define(IP, "www.chinwhiz.cn");
if ($type == 'list') {
/**
* ************显示文章信息列表***************
*/
$page = $_REQUEST['page'];
$moduleId = $_REQUEST['moduleId'];
$list = array();
$num = 10;
//每页显示10条
$start = ($page - 1) * $num;
//本页显示的起始位置
// 从wx_info中查询出文章信息的基本文章信息
$sql_info_num = "select id from wx_info where moduleId='{$moduleId}' ";
$res_info_num = $db->execsql($sql_info_num);
$list['PageNum'] = ceil(count($res_info_num) / $num);
$sql_info = "select id,title,thumb,date,importance,seq from wx_info where moduleId='{$moduleId}' order by importance desc,seq asc limit " . $start . "," . $num;
$res_info = $db->execsql($sql_info);
foreach ($res_info as $key_list => $val_list) {
// 根据文章信息ID在wx_leaveword表中查询出该文章信息的评论次数，在wx_zan表中查询出该文章信息的点赞次数
$list[$key_list]['num_leaveword'] = $lwd->lwdNum($val_list['id']);
//评论次数
$list[$key_list]['num_zan'] = $zan->zanNum($val_list['id']);
//点赞次数
$list[$key_list]['id'] = $val_list['id'];
$list[$key_list]['thumb'] = $val_list['thumb'];
$list[$key_list]['title'] = $val_list['title'];
$list[$key_list]['date'] = $val_list['date'];
$list[$key_list]['importance'] = $val_list['importance'];
}
//获取页码
// $page=1;
$num = 10;
//每页的容量
$start = ($page - 1) * $num;
if ($list_type == "wx") {
$a = 1;
$sql = "select * from " . $reviewName . " where review = " . $a;
// echo $sql;die;
$result = mysql_query($sql);
// var_dump($result);
// echo mysql_num_rows($result);
$sql_list = "select id,title,review,start from " . $reviewName . " where review =\n\t\t'{$a}' order by start desc limit " . $start . "," . $num;
//选择能够往期回顾的信息
// echo $sql_list;die;
$res_list = $db->execsql($sql_list);
// var_dump($res_list);
$file['details_dataBase'] = $reviewName;
$file['list'] = $res_list;
$file['num'] = mysql_num_rows($result);
echo json_encode($file);
} elseif ($list_type == "manager_show") {
$sql = "select * from " . $reviewName;
// echo $sql;die;
$result = mysql_query($sql);
$sql_list = "select id,title,review,start from " . $reviewName . " order by start desc limit " . $start . "," . $num;
//选择要往期回顾的信息
// echo $sql_list;die;
$res_list = $db->execsql($sql_list);
$file['list'] = $res_list;
$file['num'] = mysql_num_rows($result);
require_once '../../../common/php/regexTool.class.php';
//正则表达式匹配的类文件
$db = new DB();
$regex = new regexTool();
$type = $_GET['type'];
if ($type == 'checkPage') {
/**********************分页查询公司信息**************************/
$check_data = array();
$page = $_GET['page'];
$num = 10;
//每页显示10条
$start = ($page - 1) * $num;
//本页显示的起始位置
// $sql_check="select * from wx_map limit ".$start.",".$num;
$sql_check = "select * from wx_map order by isTop desc,convert(companyName USING gbk) COLLATE gbk_chinese_ci desc limit " . $start . "," . $num;
$res_check = $db->execsql($sql_check);
// 获取总数据
$sql_info_num = "select * from wx_map ";
$res_info_num = $db->execsql($sql_info_num);
$check_data['PageNum'] = ceil(count($res_info_num) / $num);
$num_res = count($res_check);
if ($num_res == 0) {
$check_data['error'] = 0;
//数据为空
} else {
$check_data['check'] = $res_check;
$check_data['error'] = 1;
//数据不为空
}
echo json_encode($check_data);
} elseif ($type == 'checkFuzzy') {
switch ($menuType) {
case 'picture':
$mediaType = 0;
$urlPC = '../../article/html/articlelist.html';
$wechat = "../../article/html/newslist.php?moduleId=";
break;
case 'video':
$mediaType = 1;
$urlPC = '../../article/html/videolist.html';
$wechat = "";
break;
default:
break;
}
$sql_insert_second = "insert into wx_articlelist_module (name,type,menuId,parentId,urlPC) values ('{$name}','{$mediaType}',0,'{$parentId}','{$urlPC}')";
$res_insert_second = $db->execsql($sql_insert_second);
if (mysql_affected_rows() > 0) {
$moduleid = mysql_insert_id();
if ($menuType == "picture") {
$sql_update1 = "update wx_articlelist_module set urlWechat='" . $wechat . $moduleid . "' where id=" . $moduleid;
$res_update1 = $db->execsql($sql_update1);
}
if (mysql_affected_rows() > 0) {
echo 1;
//操作成功
} else {
echo 0;
//操作失败
}
} else {
echo 0;
<?php
/**
* $type="showmenuPC":用于显示PC端左侧的菜单
*/
header("content-type:text/json;charset=utf-8");
require_once './dbaccess.php';
$db = new DB();
$type = $_GET['type'];
if ($type == "showmenuPC") {
/*
* 将菜单按级别输出名字和ID,用于PC端左侧菜单展示
*/
//获取一级模块名称
$sql_menu = "select id,name,urlPC,menuType from wx_wechat_module where parentId=0 order by seq asc";
$res_menu = $db->execsql($sql_menu);
//遍历获取二级模块名称
foreach ($res_menu as $key_First => $val_First) {
//如果是文章列表类型的菜单，则输出moduleId
$sql_type = "select name from wx_wechat_module_type where id='{$val_First['menuType']}'";
$res_type = $db->getrow($sql_type);
// echo $sql_type;die;
if ($res_type['name'] == "文章列表") {
$sql_module = "select id from wx_articlelist_module where menuId='{$val_First['id']}'";
$res_module = $db->getrow($sql_module);
$res_menu[$key_First]['moduleId'] = $res_module['id'];
}
//自身连接查询
$sql_second = "select s.id,s.name,s.urlPC,s.parentId,s.menuType from wx_wechat_module as s left join wx_wechat_module as p\n\t\ton s.parentId=p.id where p.id='{$val_First['id']}' order by s.seq asc";
$res_second = $db->execsql($sql_second);
foreach ($res_second as $key_second => $val_second) {
define('SHOW_DIR', '../uploadfile/');
$db = new DB();
$act = $_REQUEST['act'];
if ($act == "uploadpic") {
//上传
$info = array();
$dest = uploadmulti('thumbpic', 0);
$sql_count = "select count(*) as rsum from wx_profile";
$res = $db->getRow($sql_count);
if (!$res) {
$index = 1;
} else {
$index = $res['rsum'] + 1;
}
$sql_insert = "insert into wx_profile (picture,seq) values('" . $dest[0] . "'," . $index . ")";
$res = $db->execsql($sql_insert);
if ($res) {
$info["error"] = false;
//上传成功
$info["dest"] = $dest[0];
$info["index"] = $index;
} else {
$info["error"] = true;
//上传失败
}
echo json_encode($info);
} elseif ($act == "save") {
//保存图片设置
$images = $_GET['images'];
$separator = ":";
$images_array = explode($separator, $images);
*/
header("content-type:text/json;charset=utf-8");
// echo $path;
require_once '../../../common/php/dbaccess.php';
require_once '../../../common/php/regexTool.class.php';
$db = new DB();
$regex = new regexTool();
$type = $_GET['type'];
if ($type == "list") {
/**********列出管理员信息**************/
$page = $_GET['page'];
//获得当前页码
$num = 10;
// 每页显示的条数
$sql_list1 = "select number,name from wx_admin ";
$res_list1 = $db->execsql($sql_list1);
$list['PageNum'] = ceil(count($res_list1) / $num);
// 总页数
$start = ($page - 1) * $num;
$sql_list = "select id,number,name from wx_admin limit " . $start . "," . $num;
$res_list = $db->execsql($sql_list);
if (empty($res_list)) {
$list['error'] = 0;
// 当前页为空
} else {
$list['list'] = $res_list;
}
echo json_encode($list);
} else {
if ($type == "add") {
/**********添加管理员帐号**************/
