if (mysql_affected_rows() > 0) {
echo 1;
//操作成功
} else {
echo 0;
//操作失败
}
} else {
echo 0;
//操作失败
}
}
}
if ($type == "delList") {
$moduleId = $_GET['moduleId'];
if ($regex->isNumber($moduleId)) {
$sql_thumb = "select thumb,media from wx_info where moduleId='{$moduleId}'";
$res_thumb = $db->execsql($sql_thumb);
foreach ($res_thumb 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);
}
}
} else {
$error = 4;
// 手机格式不正确
}
if ($regex->isEmail($email)) {
$data['email'] = $email;
} else {
$error = 5;
// 邮箱格式不正确
}
$data['sexRequire'] = $sexRequire;
// $data ['eduRequire'] = $eduRequire;
$data['other'] = $other;
$data['salary'] = $salary;
$data['content'] = $content;
if ($regex->isNumber($num)) {
$data['num'] = $num;
} else {
$error = 6;
// 人数格式不正确
}
$data['date'] = $date;
// var_dump($data);
/*
* *******存入wx_talent_recruit数据库********
*/
if (empty($data['num'])) {
$error = 2;
// 人数不能为空或者格式不正确；
} else {
$insert = $db->insert('wx_talent_recruit', $data);
$list['normal'][$key_list]['id'] = $val_list['id'];
$list['normal'][$key_list]['thumb'] = $val_list['thumb'];
$list['normal'][$key_list]['title'] = $val_list['title'];
$list['normal'][$key_list]['date'] = $val_list['date'];
$list['normal'][$key_list]['importance'] = $val_list['importance'];
$list['normal'][$key_list]['abstract'] = $val_list['abstract'];
$list['normal'][$key_list]['content'] = $val_list['content'];
}
echo json_encode($list);
} elseif ($type == 'details') {
/**
* ************显示某篇文章信息的具体内容***************
*/
$infoId = $_REQUEST['infoId'];
//获取显示具体内容的文章信息ID
if ($regex->isNumber($infoId)) {
$sql_info_details = "select media,title,date,content,abstract,is_leaveword,is_zan,thumb from wx_info where id='{$infoId}'";
$res_info_details = $db->getrow($sql_info_details);
// 根据文章信息ID在wx_leaveword表中查询出该文章信息的评论次数和详情，在wx_zan表中查询出该文章信息的点赞次数
$page = $_REQUEST['page'];
$num = 10;
//每页显示10条评论
$details['is_leaveword'] = $lwd->isLwd($infoId);
$details['is_zan'] = $zan->isZan($infoId);
/*//获取用户的openid之后，显示评论信息
if($openid != ''){
$details['comment']=$lwd->showLwd($page, $num, $infoId);//分页显示具体的评论信息
}else{
$details['error'] = 2;//信息获取失败，请退出网页重新进入
}*/
$details['comment'] = $lwd->showLwd($page, $num, $infoId);
echo json_encode($list);
} elseif ($type == 'seqInfo') {
/**
* ************排序***************
*/
$infoId = $_REQUEST['infoId'];
//获取显示具体内容的文章信息ID
$moduleId = $_REQUEST['moduleId'];
//获取显示具体内容的文章信息ID
$flag = 1;
$nseq = $_REQUEST['seq'];
//位置
//$reSeq = $_REQUEST['reSeq'];//修改前的位置
$is_top = $_REQUEST['is_top'];
//是否已置顶 0:否;1:是
if ($regex->isNumber($nseq)) {
//查询文章的总数
$sql_max_seq = "SELECT id FROM wx_info WHERE moduleId ='{$moduleId}'";
$res_max_seq = $db->execsql($sql_max_seq);
$numAll = count($res_max_seq);
//判断位置是否超出范围
if ($nseq <= 0 || $nseq > $numAll) {
$flag = 5;
//已超出有效位置范围
echo $flag;
die;
}
//查找序号为$nseq的文章的id和seq
$sql_n = "select seq,importance from wx_info where moduleId='{$moduleId}' order by importance desc,seq asc limit 0," . $nseq;
$res_n = $db->execsql($sql_n);
$seq = $res_n[$nseq - 1]['seq'];
}
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
if (count($articles) <= 8 && count($articles) > 0) {
foreach ($articles as $key_article => $val_article) {
if ($regex->isNumber($val_article['moduleId'])) {
if (empty($val_article['title']) || empty($val_article['content']) || empty($val_article['zaiyao'])) {
$flag = 2;
// 标题和内容不能为空
break;
} elseif (get_strlength($val_article['zaiyao']) > 200) {
$flag = 3;
// 摘要不能超过100字
//将活动中的过期的活动关闭
//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;
// 每页显示的条数
$sql_list1 = "select a.id from wx_activity_interact_project as a left join wx_activity_module as b on a.moduleId=b.id where b.menuId='{$moduleId}' and valid=1";
$res_list1 = $db->execsql($sql_list1);
$list['PageNum'] = ceil(count($res_list1) / $num);
// 总页数
$start = ($page - 1) * $num;
$sql_list = "select a.id,a.title,a.content,a.valid,a.thumb,a.start from wx_activity_interact_project as a left join wx_activity_module as b on a.moduleId=b.id where b.menuId='{$moduleId}' and valid=1 order by a.start desc limit " . $start . "," . $num;
$res_list = $db->execsql($sql_list);
if (empty($res_list)) {
$list['error'] = 2;
// 当前页为空
} else {
$sql_valid_vote="select valid,end,id from wx_vote_project";
$res_valid_vote=$db->execsql($sql_valid_vote);
// var_dump($res_valid_vote);
$nowTime=time();
// echo $nowTime;die;
foreach ($res_valid_vote as $val_valid_vote){
if ($val_valid_vote['valid']==1){
if (strtotime($val_valid_vote['end'])<=$nowTime){
// echo "90";
$sql_update_vote="update wx_vote_project set valid=0 where id='{$val_valid_vote['id']}'";
$res_update_vote=$db->execsql($sql_update_vote);
}
}
} */
$menuId = $_GET['menuId'];
if ($regex->isNumber($menuId)) {
$page = $_GET['page'];
//获得当前页码
$num = 10;
// 每页显示的条数
$sql_list1 = "select a.id from wx_activity_interact_project as a left join wx_activity_module as b on a.moduleId=b.id where b.menuId='{$menuId}'";
$res_list1 = $db->execsql($sql_list1);
$list['PageNum'] = ceil(count($res_list1) / $num);
// 总页数
$start = ($page - 1) * $num;
$sql_list = "select a.id,a.title,a.start,a.end,a.valid,a.review from wx_activity_interact_project as a left join wx_activity_module as b on a.moduleId=b.id where b.menuId='{$menuId}' order by a.valid desc ,a.start desc limit " . $start . "," . $num;
$res_list = $db->execsql($sql_list);
if (empty($res_list)) {
$list['error'] = 2;
// 当前页为空
} else {
