// 是否赞
 $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;
Example #6
0
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);
 }
Example #8
0
<?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);
Example #14
0
    $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
Example #17
0
<?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);
Example #22
0
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;
Example #24
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) {
Example #25
0
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") {
        /**********添加管理员帐号**************/