<?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教程(从浅入深)
3星 · 超过75%的资源 需积分: 10 155 浏览量
2010-10-23
09:44:18
上传
评论
收藏 1.15MB RAR 举报 
最好的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 S20061029150556.dat 16B S20061029150547.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 S20060905132224.htm 124B S20060905132229.htm 124B S20060905132237.htm 124B S20060905132240.htm 124B S20060905132232.htm 124B S20060905132234.htm 124B S20060905132238.htm 124B S20060905132227.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
评论1