<?php require_once('Connections/conn.php'); ?>
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
}
return $theValue;
}
session_start();
//身分验证
if(!isset($_SESSION["MM_Username"]))
{
header("Location: index.php");
}
//获取表单信息
if(!isset($_GET['id']) && !isset($_POST["MM_update"]))
{
die("非法的ID参数");
}
elseif(isset($_GET['id']))
{
mysql_select_db($database_conn, $conn);
$query_rs = sprintf("SELECT * FROM requestforms WHERE id = %s", $_GET['id']);
$rs = mysql_query($query_rs, $conn) or die(mysql_error());
$row_rs = mysql_fetch_assoc($rs);
$totalRows_rs = mysql_num_rows($rs);
}
//表单信息处理
switch($_SESSION["MM_UserGroup"])
{
case "web_reviewer":
$input1 = "disabled";
$input2 = "disabled";
$input3 = "disabled";
$input4 = "disabled";
$input5 = "disabled";
$input6 = "disabled";
$input7 = "";
$button1_text = "批准请求";
$button1_action = "APPROVED";
$button2_text = "拒绝请求";
$button2_action = "REJECTED";
$updateSQL = sprintf("UPDATE requestforms SET reject_reason=%s, status=%s, last_upt_id=%s WHERE id=%s",
GetSQLValueString($_POST['reject_reason'], "text"),
GetSQLValueString($_POST['status'], "text"),
GetSQLValueString($_SESSION["MM_Username"], "text"),
GetSQLValueString($_POST['id'], "int"));
break;
case "info_reviewer":
$input1 = "";
$input2 = "";
$input3 = "";
$input4 = "";
$input5 = "disabled";
$input6 = "";
$input7 = "";
$button1_text = "确认请求";
$button1_action = "CONFIRMED";
$button2_text = "拒绝请求";
$button2_action = "REJECTED";
$updateSQL = sprintf("UPDATE requestforms SET reporter_name=%s, reporter_contact=%s, content=%s, target_datetime=%s, assignee_depart=%s, reject_reason=%s, status=%s, last_upt_id=%s WHERE id=%s",
GetSQLValueString($_POST['reporter_name'], "text"),
GetSQLValueString($_POST['reporter_contact'], "text"),
GetSQLValueString($_POST['content'], "text"),
GetSQLValueString($_POST['target_datetime'], "date"),
GetSQLValueString($_POST['assignee_depart'], "text"),
GetSQLValueString($_POST['reject_reason'], "text"),
GetSQLValueString($_POST['status'], "text"),
GetSQLValueString($_SESSION["MM_Username"], "text"),
GetSQLValueString($_POST['id'], "int"));
break;
case "depart_planner":
$input1 = "disabled";
$input2 = "disabled";
$input3 = "disabled";
$input4 = "disabled";
$input5 = "";
$input6 = "disabled";
$input7 = "";
$button1_text = "分配任务";
$button1_action = "ASSIGNED";
$button2_text = "拒绝任务";
$button2_action = "APPROVED";
$updateSQL = sprintf("UPDATE requestforms SET assignee=%s, reject_reason=%s, status=%s, last_upt_id=%s WHERE id=%s",
GetSQLValueString($_POST['assignee'], "text"),
GetSQLValueString($_POST['reject_reason'], "text"),
GetSQLValueString($_POST['status'], "text"),
GetSQLValueString($_SESSION["MM_Username"], "text"),
GetSQLValueString($_POST['id'], "int"));
break;
case "worker":
$input1 = "disabled";
$input2 = "disabled";
$input3 = "disabled";
$input4 = "disabled";
$input5 = "disabled";
$input6 = "disabled";
$input7 = "";
if($row_rs['status'] == "ASSIGNED")
{
$button1_text = "接受任务";
$button1_action = "ACCEPTED";
$button2_text = "拒绝任务";
$button2_action = "CONFIRMED";
}
if($row_rs['status'] == "ACCEPTED")
{
$button1_text = "任务完成";
$button1_action = "COMPLETED";
$button2_text = "撤销接受";
$button2_action = "ASSIGNED";
}
$updateSQL = sprintf("UPDATE requestforms SET reject_reason=%s, status=%s, last_upt_id=%s WHERE id=%s",
GetSQLValueString($_POST['reject_reason'], "text"),
GetSQLValueString($_POST['status'], "text"),
GetSQLValueString($_SESSION["MM_Username"], "text"),
GetSQLValueString($_POST['id'], "int"));
break;
case "service_supporter":
$input1 = "disabled";
$input2 = "disabled";
$input3 = "disabled";
$input4 = "disabled";
$input5 = "disabled";
$input6 = "disabled";
$input7 = "";
$button1_text = "关闭请求";
$button1_action = "CLOSED";
$button2_text = "重新开启";
$button2_action = "CONFIRMED";
$updateSQL = sprintf("UPDATE requestforms SET reject_reason=%s, status=%s, last_upt_id=%s WHERE id=%s",
GetSQLValueString($_POST['reject_reason'], "text"),
GetSQLValueString($_POST['status'], "text"),
GetSQLValueString($_SESSION["MM_Username"], "text"),
GetSQLValueString($_POST['id'], "int"));
break;
default:
die('用户群组信息不正确');
break;
}
//表单提交处理
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
/*
$updateSQL = sprintf("UPDATE requestforms SET reporter_name=%s, reporter_contact=%s, content=%s, target_datetime=%s, assignee=%s, assignee_depart=%s, reject_reason=%s, status=%s, last_upt_id=%s WHERE id=%s",
GetSQLValueString($_POST['reporter_name'], "text"),
GetSQLValueString($_POST['reporter_contact'], "text"),
GetSQLValueString($_POST['content'], "text"),
GetSQLValueString($_POST['target_datetime'], "date"),
GetSQLValueString($_POST['assignee'], "text"),
GetSQLValueString($_POST['assignee_depart'], "text"),
GetSQLValueString($_POST['reject_reason'], "text"),
GetSQLValueString($_POST['status'], "text"),
GetSQLValueString($_SESSION["MM_Username"], "text"),
GetSQLValueString($_POST['id'], "int"));
*/
if($_POST['status'] == $button2_action && $_POST['reject_reason'] == "")
{
echo "<script>alert('请输入拒绝理由!'); location.href='?id=".$_POST['id']."';</script>";
}
else
{
mysql_select_db($database_conn, $conn);
$Result1 = mysql_query($updateSQL, $conn) or die(mysql_error());
echo "<script>alert('操作成功完成!'); location.href='list.php';</script>";
}
}
//获取部门信息
mysql_select_db($database_conn, $conn);
$query_rs_depart = "SELECT * FROM departs ORDER BY depart_no ASC";
$rs_depart = mysql_query($query_rs_depart, $conn) or die(mysql_error());
$row_rs_depart = mysql_fetch_assoc($rs_depart);
$totalRows_rs_depart = mysql_num_rows($rs_depart);
//获取工人信息
mysql_select_db($database_conn, $conn);
$query_rs_worker = "SELECT * FROM employees WHERE role = 'worker' AND depart_no='".$row_rs['assignee_depart']."' ORDER BY serial_no ASC";
$rs_worker = mysql_query($query_rs_worker, $conn) or die(mysql_error());
$row_rs_worker = mysql_fetch_assoc($rs_worker);
$totalRows_rs_worker = mysql_num_rows($rs_worker);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>设备维修请求详细信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
.style1 {
font-size
没有合适的资源?快使用搜索试试~ 我知道了~
php网络开发完全手册
共598个文件
php:491个
htm:59个
txt:15个
需积分: 10 13 下载量 71 浏览量
2009-02-24
23:21:36
上传
评论
收藏 1.15MB RAR 举报
温馨提示
本书从易到难、由浅入深、循序渐进、系统地介绍了PHP5知识点及其Web应用程序的开发技术。通俗易懂,提供大量的实例供读者更加深刻巩固所学的知识,使读者更好地进行开发实践。 本书共分为51章,从搭建PHP应用程序开发环境开始,首先介绍了PHP语言的编程基础知识、常用技巧及与一般Web对象的操作,?缓蠼樯芰薖HP与数据库的交互操作方法,并对PHP中的扩展库的使用方法进行了详细的介绍,其中包括PEAR、ADOdb、FPDF、GD库等。除此之外,还对PHP的缓存处理方法、XML文件操作、LDAP服务器操作和邮件系统操作进行了介绍。本书通过对CMS系统、OA系统、流程管理系统和资源管理系统等系统的介绍,详细讲解了PHP在实际开发中的应用,并且对服务器的基本知识及PHP的扩展应用都进行了系统翔实的介绍。 本书内容紧凑、实例丰富、结构严谨、深入浅出,不论是对PHP应用程序的初学者,还是对PHP应用程序开发有一定经验的开发人员,都会起到有益的帮助。
资源推荐
资源详情
资源评论
收起资源包目录
php网络开发完全手册 (598个子文件)
9be46ec960e49322208ee04390972c74 0B
logo.PNG.bak 1KB
test.conf 65B
d952151fe529b7869fdef483e0bd0e73 0B
S20060830125301.dat 64B
S20060830125301.dat 64B
S20060830125215.dat 33B
S20060830125215.dat 33B
S20061029150714.dat 28B
S20061029142708.dat 27B
S20061029150653.dat 18B
S20061029152806.dat 17B
S20061029150547.dat 16B
S20061029150556.dat 16B
S20061029150520.dat 16B
S20061029142607.dat 3B
S20061029142607.dat 3B
logo.gif 813B
.htaccess 41B
50.2.4.htm 2KB
50.3.2.htm 2KB
50.4.2.htm 2KB
send.htm 2KB
example6.htm 2KB
50.4.1.htm 2KB
post.htm 1KB
post.htm 1KB
insert.htm 1KB
50.3.1.htm 1KB
UserInfo.htm 1KB
50.2.3.htm 1KB
50.2.2.htm 1KB
login.htm 1KB
login.htm 1KB
Post.htm 921B
Post.htm 919B
Post.htm 919B
insert.htm 724B
error.htm 575B
menu.htm 538B
50.2.1.htm 524B
test5.htm 494B
Upload.htm 439B
menu1.htm 421B
menu2.htm 369B
form.htm 353B
upload.htm 334B
test6.htm 313B
model2.htm 278B
model3.htm 277B
model1.htm 276B
test3.htm 249B
test4.htm 246B
new.htm 194B
template.htm 185B
T1.htm 180B
test2.htm 175B
T2.htm 172B
test1.htm 171B
S20060904150821.htm 160B
test9.htm 154B
test7.htm 135B
test8.htm 135B
1.3.1-1.htm 135B
S20060905132240.htm 124B
S20060905132224.htm 124B
S20060905132237.htm 124B
S20060905132232.htm 124B
S20060905132234.htm 124B
S20060905132229.htm 124B
S20060905132227.htm 124B
S20060905132238.htm 124B
test.htm 118B
template.htm 115B
S20061115060732.htm 111B
.htm 95B
count.htm 59B
inc.htm 11B
test.html 610B
include.inc 104B
sight.jpg 592KB
IMG_0075.JPG 292KB
small_IMG_0075.JPG 9KB
newpic.jpg 9KB
newpic.jpg 9KB
form.js 1KB
reviewform.php 12KB
mod_project.php 10KB
admin_typemanage.php 8KB
admin_modify.php 7KB
new_invoice.php 6KB
admin_config.php 6KB
mod_user.php 6KB
payment2.php 6KB
admin_templatemanage.php 6KB
new_task.php 6KB
new_project.php 6KB
admin_addnew.php 5KB
checkin2.php 5KB
admin_usermanage.php 5KB
共 598 条
- 1
- 2
- 3
- 4
- 5
- 6
资源评论
AKin1986
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功