* Created by PhpStorm.
* User: huzhiming
* Date: 2015/9/8
* Time: 9:07
*/
session_start();
require_once "../../smarty_include.php";
require_once "../../tools/SQLTool.class.php";
$sqltool = new SQLTool();
$kno_num = $_GET['kno_num'];
//删除附件
if (isset($_GET['flag']) and $_GET['flag'] == 'del') {
$attach_id = $_GET['attach_id'];
$attach_name = $_GET['file_name'];
//echo $attach_md5_name;
$res = $sqltool->dbUpdate("delete from t_attachment where attach_id='{$attach_id}' and attach_name='{$attach_name}'");
//删除文件
$res1 = 1;
$file_name = iconv('UTF-8', 'GB2312', $attach_name);
if (file_exists(PROJECT_DIR . "\\uploadfile\\files\\" . $attach_id . "\\" . $file_name)) {
$res1 = unlink(PROJECT_DIR . "\\uploadfile\\files\\" . $attach_id . "\\" . $file_name);
}
if ($res and $res1) {
echo "<script>alert('附件删除成功！')</script>";
} else {
echo "<script>alert('附件删除失败！')</script>";
}
}
$sql = "select *from t_kno where kno_num = '{$kno_num}'";
$res = $sqltool->dbQuery($sql);
$attachment = $sqltool->dbQuery("select attach_name,attach_id from t_attachment,t_kno where kno_attach_id=attach_id and kno_num='{$kno_num}'");
* Time: 9:51
*/
session_start();
require_once "../smarty_include.php";
require_once "../tools/SQLTool.class.php";
require_once "../tools/FileUtils.php";
$sqltool = new SQLTool();
$fileutil = new FileUtil();
//发布通知
if (isset($_POST['add_news'])) {
$news_title = $_POST['news_title'];
$news_content = $_POST['news_content'];
$attach_id = $_POST['attach_id'];
$news_author = $_SESSION['user_name'];
$sql = "insert into t_news(news_title,news_content,attach_id,news_time,news_author) values('{$news_title}','{$news_content}','{$attach_id}',NOW(),'{$news_author}')";
$res = $sqltool->dbUpdate($sql);
$res1 = 1;
if (file_exists(PROJECT_DIR . "/uploadfile/temp/" . $attach_id)) {
$res1 = $fileutil->moveDir(PROJECT_DIR . "/uploadfile/temp/" . $attach_id, PROJECT_DIR . "/uploadfile/files/news/" . $attach_id);
}
if ($res and $res1) {
echo "<script>alert('通知发布成功！')</script>";
} else {
echo "<script>alert('通知发布失败！')</script>";
}
echo "<script>window.location.href='/itildemo/home/controller/admin/news_create.php'</script>";
}
//删除通知
if (isset($_GET['news_delete'])) {
$news_id = $_GET['news_delete'];
$sql = "delete from t_news where news_id='{$news_id}'";
} else {
$req_author = $_SESSION['user_name'];
$req_source = "1";
}
$req_title = $_POST['req_title'];
$req_sort = $_POST['req_sort'];
$req_attach_id = $_POST['attach_id'];
$req_content = $_POST['req_content'];
$req_keyword = $_POST['req_keyword'];
$sql = "INSERT INTO t_req (req_num,req_title,req_sort,req_author,req_attach_id,req_content,req_time,req_keyword,req_source) VALUES\r\n (\r\n (SELECT CONCAT('REQ',DATE_FORMAT(NOW(),'%y%m%d'),id) FROM\r\n (\r\n SELECT\r\n CASE\r\n WHEN req_num IS NULL THEN '00001'\r\n ELSE LPAD(RIGHT(MAX(req_num),5)+1,5,'0')\r\n END id FROM t_req\r\n WHERE req_num LIKE CONCAT('REQ',DATE_FORMAT(NOW(),'%y%m%d'),'%')\r\n ) req_num),'{$req_title}','{$req_sort}','{$req_author}','{$req_attach_id}','{$req_content}',Now(),'{$req_keyword}','{$req_source}'\r\n )";
//上传的文件移动
$res = 1;
if (file_exists(PROJECT_DIR . "/uploadfile/temp/" . $req_attach_id)) {
$res = $fileutil->moveDir(PROJECT_DIR . "/uploadfile/temp/" . $req_attach_id, PROJECT_DIR . "/uploadfile/files/req/" . $req_attach_id);
}
if ($sqltool->dbUpdate($sql) and $res) {
echo "<script>alert('请求添加成功！')</script>";
} else {
echo "<script>alert('请求添加失败！');</script>";
}
if ($flag == "admin") {
echo "<script>window.location.href='/itildemo/home/controller/admin/request_create.php'</script>";
} else {
echo "<script>window.location.href='/itildemo/home/controller/user/request_create.php'</script>";
}
}
//指派请求
if (isset($_POST['assign_btn'])) {
$req_num = $_POST['req_num'];
$decription = $_POST['add_description'];
$req_effect = $_POST['effect'];
<?php
/**
* Created by PhpStorm.
* User: huzhiming
* Date: 2015/9/23
* Time: 10:45
*/
session_start();
require_once "../../smarty_include.php";
require_once "../../tools/SQLTool.class.php";
$news_id = $_GET['news_id'];
$sqltool = new SQLTool();
$sqltool->dbUpdate("update t_news set news_read=news_read+1 where news_id='{$news_id}'");
$sql = "select *from t_news where news_id = '{$news_id}'";
$res = $sqltool->dbQuery($sql);
$attachment = $sqltool->dbQuery("select attach_name,t_attachment.attach_id from t_attachment,t_news where t_news.attach_id=t_attachment.attach_id and news_id='{$news_id}'");
$smarty->assign("res", $res[0]);
$smarty->assign("attach", $attachment);
$smarty->display("share/news_detail.html");
$kno_author = $_SESSION['user_name'];
$kno_sort = $_POST['kno_sort'];
$kno_keyword = $_POST['kno_keyword'];
$kno_req_num = $_POST['req_num'];
$kno_attach_id = $_POST['attach_id'];
$kno_content = $_POST['kno_content'];
if ($kno_req_num == "") {
$kno_req_num = NULL;
}
$sql = "INSERT INTO t_kno (kno_num,kno_title,kno_sort,kno_author,kno_attach_id,kno_content,kno_sub_time,kno_keyword,kno_req_num) VALUES\r\n (\r\n (SELECT CONCAT('KNO',DATE_FORMAT(NOW(),'%Y%m%d'),id) FROM\r\n (\r\n SELECT\r\n CASE\r\n WHEN kno_num IS NULL THEN '00001'\r\n ELSE LPAD(RIGHT(MAX(kno_num),5)+1,5,'0')\r\n END id FROM t_kno\r\n WHERE kno_num LIKE CONCAT('KNO',DATE_FORMAT(NOW(),'%Y%m%d'),'%')\r\n ) kno_num),'{$kno_title}','{$kno_sort}','{$kno_author}','{$kno_attach_id}','{$kno_content}',Now(),'{$kno_keyword}','{$kno_req_num}'\r\n )";
//将上传的文件从temp文件夹下移到files
$res = 1;
if (file_exists(PROJECT_DIR . "/uploadfile/temp/" . $kno_attach_id)) {
$res = $fileutil->moveDir(PROJECT_DIR . "/uploadfile/temp/" . $kno_attach_id, PROJECT_DIR . "/uploadfile/files/know/" . $kno_attach_id);
}
if ($sqltool->dbUpdate($sql) and $res) {
echo "<script>alert('知识采集成功！')</script>";
} else {
echo "<script>alert('知识采集失败！')</script>";
}
echo "<script>window.location.href='/itildemo/home/controller/share/know_create.php'</script>";
}
//发布
if (isset($_GET['flag']) and $_GET['flag'] == 'pass') {
$kno_num = $_GET['kno_num'];
$res = $sqltool->dbUpdate("update t_kno set kno_state=3 where kno_num = '{$kno_num}'");
if ($res) {
echo "<script>alert('发布成功！')</script>";
} else {
echo "<script>alert('发布失败！')</script>";
}
<?php
/**
* Created by PhpStorm.
* User: huzhiming
* Date: 2015/9/1
* Time: 19:05
*/
require_once "../../smarty_include.php";
require_once "../../tools/SQLTool.class.php";
$depart_id = $_GET['depart_id'];
$sqltool = new SQLTool();
if ($_GET['flag'] == 1) {
$user_id = $_GET['user_id'];
$sql = "delete from t_user where user_id='{$user_id}'";
if ($sqltool->dbUpdate($sql)) {
echo "<script>alert('删除成功！')</script>";
} else {
echo "<script>alert('删除失败！')</script>";
}
}
if ($_GET['flag'] == 2) {
$keyword = $_GET['keyword'];
$sql = "select *from t_user,t_depart where t_user.depart_id=t_depart.depart_id and (name like '%{$keyword}%' or position like '%{$keyword}%' or depart_name like '%{$keyword}%' or staff_id like '%{$keyword}%')";
} else {
$sql = "select *from t_user,t_depart where t_user.depart_id ='{$depart_id}' and t_user.depart_id=t_depart.depart_id";
}
if ($_GET['flag'] == "" or $depart_id == "" and $_GET['flag'] != 2) {
//查询所有结果
$sql = "select *from t_user,t_depart where t_user.depart_id=t_depart.depart_id";
}
require_once "../tools/SQLTool.class.php";
$sqltool = new SQLTool();
//添加人员
if (isset($_POST['add_staff'])) {
$user_name = $_POST['username'];
$user_role = $_POST['role'];
$name = $_POST['name'];
$staff_id = $_POST['staff_id'];
$depart_id = $_POST['depart_id'];
$sex = $_POST['sex'];
$position = $_POST['position'];
$phone = $_POST['phone'];
$telephone = $_POST['telphone'];
$email = $_POST['email'];
$sql = "insert into t_user (name,user_name,user_role,staff_id,depart_id,sex,position,phone,telephone,email)\r\n values('{$name}','{$user_name}','{$user_role}','{$staff_id}','{$depart_id}','{$sex}','{$position}','{$phone}','{$telephone}','{$email}')";
if ($sqltool->dbUpdate($sql)) {
echo "<script>alert('人员添加成功！')</script>";
} else {
echo "<script>alert('人员添加失败！')</script>";
}
echo "<script>location.href='/itildemo/home/controller/admin/config_staff.php';</script>";
}
//修改密码
if (isset($_POST['pwd_change_btn'])) {
$new_pwd = md5($_POST['new_pwd']);
$old_pwd = md5($_POST['old_pwd']);
if ($old_pwd != $_SESSION['pwd']) {
echo "<script>alert('原密码输入错误！')</script>";
echo "<script>location.href='/itildemo/home/controller/share/info.php';</script>";
}
$user_name = $_SESSION['user_name'];
