流程： 十一 个页面
1,denglu.php(登录)
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>登录</title>
</head>
<body>
<h1>登录页面</h1>
<form action="chulidl.php" method="POST">
<div>用户名：<input type="text" name="uid" id="uid"></div>
<div>密码<input type="text" name="pwd" id="pwd"></div>
<input type="submit" value="登录"></input>
</form>
</body>
</html>
显示：
2,chulidl（处理登录） 登录成功进入main.php页
<?php
session_start(); include("../DBDA.php"); $db=new DBDA(); $uid=$_POST["uid"];
$pwd=$_POST["pwd"]; $sql="select count(*) from Users where UserName='{$uid}' and Password='{$pwd}' ";
$str=$db->StrQuery($sql,1,"lcdb"); if ($str=="1") {
$_SESSION["uid"]=$uid;
header("Location:main.php");
}
else{
header("Location:denglu.php");
} ?>
3,main.php(新建流程，发起流程，处理流程 三个条目)链接页面
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
<style type="text/css">
.menu
{
width:100px;
height:30px;
float:left;
text-align:center;
line-height:30px;
vertical-align:middle;
font-size:14px;
color:white;
}
</style>
</head> <body>
<h1>主页面</h1>
<div style="width:100%; height:30px; background-color:#6CF">
<div class="menu"><a href="xinjian.php">新建流程</a></div>
<div class="menu"><a href="faqi.php">发起流程</a></div>
<div class="menu"><a href="liuchenggenzong.php">流程处理</a></div>
</div>
</body>
</html>
显示：
4,xinjian.php(流程创建 节点人员 流程名称)
<?php
session_start();
?>
<!DOCTYPE html> <html lang="en">
<head>
<meta charset="UTF-8">
<title>首页</title>
<script type="text/javascript" src="../jquery-1.11.2.min.js"></script>
</head>
<body>
<h1>新建流程</h1>
<br>
<div>请选择节点人员：</div><br>
<div> <?php
include("../DBDA.php");
$db=new DBDA(); $sqlj="select * from Users"; $strj=$db->StrQuery($sqlj,1,"lcdb");
$hangj=explode("|", $strj); for ($i=0; $i <count($hangj) ; $i++) {
list($UserName,$Password,$Name)=explode("^", $hangj[$i]);
echo "<input type='radio' value='{$UserName}' class='ren' name='ren'>{$Name} ";
} ?>
</div><br>
<input type="button" value="添加节点" id="tian"></input><br><br>
<div id="biao">
<?php
if (isset($_SESSION["liuch"])) {
$attr=$_SESSION["liuch"]; for ($i=0; $i <count($attr) ; $i++) {
$sqlu="select Name from Users where UserName='{$attr[$i]}'";
$stru=$db->StrQuery($sqlu,1,"lcdb");
echo "<div class='jd' bs='{$attr[$i]}'>{$i}.{$stru} <input type='button' class='delete' bs='{$i}' value='删除'></div>";
}
}
else
{
echo "当前没有设置流程！";
} ?>
</div><br>
<div>输入流程名：
<input type="text" id="liuch"></input>
</div>
<br>
<input type="button" value="确定" id="add"></input> </body><br>
<script type="text/javascript">
$(document).ready(function(e){
//添加节点
$("#tian").click(function(){
var user=$(".ren");
for (var i = 0; i < user.length; i++) {
if (user.eq(i)[0].checked==true) { var uid=user.eq(i).val();
$.ajax({
url:"chulilc.php",
data:{uid:uid},
type:"POST",
dataType:"TEXT",
success:function(data){ window.location="xinjian.php";
}
});
}
}
})
$(".delete").click(function(){
var ids=$(this).attr("bs");
$.ajax({
url:"dechuli.php",
data:{ids:ids},
type:"POST",
dataType:"TEXT",
success:function(data){
window.location="xinjian.php";
}
})
})
//添加流程
$("#add").click(function(){
var name=$("#liuch").val(); $.ajax({
url:"addchuli.php",
data:{name:name},
type:"POST",
dataType:"TEXT",
success:function(data){
if (data="OK") {
alert("添加成功!");
window.location="main.php";
}
else{
alert("添加失败！");
}
}
})
})
});
</script>
</html>
显示：
5,chulilc.php(重点是value值传入session中 保存在数组里 ajax返回)
<?php
session_start(); $uid=$_POST["uid"]; if (isset($_SESSION["liuch"])) {
$shuzu=$_SESSION["liuch"];
array_push($shuzu,$uid);
$_SESSION["liuch"]=$shuzu;
}
else
{
$shuzu=array();
array_push($shuzu, $uid);
$_SESSION["liuch"]=$shuzu;
} ?>
6,addchuli.php(节点人员增加)
<?php
session_start();
include("../DBDA.php"); $db=new DBDA(); $name=$_POST["name"]; if (empty($_SESSION["liuch"])) {
echo "请添加节点人员！";
}
else
{
$attr=$_SESSION["liuch"];
$code=date("Ymdhisms",time()); $sqll="insert into liuCheng values ('{$code}','{$name}')"; if ($db->StrQuery($sqll,0,"lcdb"))
{ for ($i=0; $i <count($attr) ; $i++) {
$sql="insert into FlowPath values('','{$code}','{$attr[$i]}','{$i}')";
$db->StrQuery($sql,0,"lcdb");
} }
echo "添加成功！"; } ?>
7,dechuli.php(删除节点人员)
<?php
session_start();
$ids=$_POST["ids"]; $array=$_SESSION["liuch"]; unset($array[$ids]); //删除元素 $array=array_values($array); //重新索引 $_SESSION["liuch"]=$array; ?>
显示：
比上面少了张三
8,faqi.php(流程发起页面)
<?php
session_start(); ?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>流程发起</title>
<script type="text/javascript" src="../jquery-1.11.2.min.js"></script>
</head>
<body>
<h1>发起流程</h1>
<div>请选择流程：
<select id="lc">
<?php
include("../DBDA.php");
$db=new DBDA(); $sql="select * from LiuCheng"; $str=$db->StrQuery($sql,1,"lcdb");
$hang=explode("|", $str);
for($i=0;$i<count($hang);$i++) {
list($code,$name)=explode("^", $hang[$i]); echo "<option value='{$code}'>{$name}</option>"; } ?>
</select>
</div><br> <div>
<div>请输入流程内容：</div><br>
<div><textarea id="neir" style="width: 400px; height: 300px;"></textarea></div>
</div><br> <input type="button" value="确定" id="btn"></input>
<a href="liuchenggenzong.php">处理页面</a>
</body>
<script type="text/javascript">
$(document).ready(function(e){
$("#btn").click(function(){
var lc=$("#lc").val(); var nr=$("#neir").val();
$.ajax({
url:"chulifq.php",
data:{lc:lc,nr:nr},
type:"POST",
dataType:"TEXT",
success:function(data){
if (data=="OK") {
alert("发起成功！")
}
else{
alert("发起失败！");
}
}
});
})
}); </script>
</html>
显示：
9,chulifq.php(处理发起页面)
<?php
session_start();
include("../DBDA.php"); $db=new DBDA();
$lc=$_POST["lc"];
$nr=$_POST["nr"]; $uid=$_SESSION["uid"];
//echo $uid;
$riqi=date("Y-m-d H:i:s",time()); $sqlf="insert into UserFlow values('','{$lc}','{$uid}','{$nr}',false,'{$riqi}',0)"; $str=$db->StrQuery($sqlf,0,"lcdb");
echo $str;
?>
10,liuchenggenzong.php(流程中各个节点人员审核的表格)
<?php
session_start();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title></title>
</head>
<body>
<h1>处理流程</h1>
<table width="100%" border="1" cellspacing="0" cellpadding="0">
<tr>
<td>流程名称</td>
<td>发起者</td>
<td>内容</td>
<td>是否结束</td>
<td>发起日期</td>
<td>操作</td>
</tr>
<?php
$uid=$_SESSION["uid"];
include("../DBDA.php"); $db=new DBDA(); $sql="select * from userflow "; $str=$db->StrQuery($sql,1,"lcdb");
$hang=explode("|", $str); for ($i=0; $i < count($hang); $i++) {
list($ids,$code,$uids,$nr,$isok,$riqi,$towhere)=explode("^", $hang[$i]); //查流程里面所有的节点
$sqlj="select * from FlowPath where code='{$code}'";
$strj=$db->StrQuery($sqlj,1,"lcdb"); $hangj=explode("|",$strj); $bs=false;
$bscl=false;
for ($j=0; $j <count($hangj) ; $j++) {
list($idsj,$codej,$uidj,$orderj)=explode("^",$hangj[$j]);
if (($uidj==$uid)and($orderj<=$towhere)) {
if ($orderj==$towhere) {
$bscl=true; }
$bs=true;
} }
//处理流程名
$sqllc="select Name from LiuCheng where Code='{$code}'";
$lcname=$db->StrQuery($sqllc,1,"lcdb"); //处理发起者
$sqlfq="select Name from Users where UserName='{$uid}'";
$fqname=$db->StrQuery($sqlfq,1,"lcdb"); //处理是否结束
$jieguo=$isok?"<span style='background-color:red'>已结束</span>":"<span style='background-color:green'>进行中</span>"; //处理操作
$caozuo=$bscl?"<a href='tongguo.php?code={$ids}'>通过</a>":"<span style='background-color:gray'>已通过</span>";
if ($bs) {
echo "<tr>
<td>{$lcname}</td>
<td>{$fqname}</td>
<td>{$nr}</td>
<td>{$jieguo}</td>
<td>{$riqi}</td>
<td>{$caozuo}</td></tr>";
}
} ?>
</table> </body>
</html>
显示：
11,tongguo.php(处理 根据uid是否相等，以及order和towhere的相对大小来处理 是否显示)
<?php
include("../DBDA.php");
$db=new DBDA(); $code=$_GET["code"]; $sql="update UserFlow set ToWhere=ToWhere+1 where ids='{$code}'";
$db->StrQuery($sql,0,"lcdb"); $sqlt="select Code,ToWhere from UserFlow where Ids='{$code}'";
$strtw=$db->StrQuery($sqlt,1,"lcdb");
list($lccode,$tw)= explode("^",$strtw); //查询该流程下节点数量
$sqlf="select count(*) from FlowPath where code='{$lccode}'";
$zs=$db->StrQuery($sqlf,1,"lcdb");
//判断是否走完流程
if($tw>=$zs)
{
$sqlx="update userFlow set IsOK=true where Ids='{$code}'";
$db->StrQuery($sqlx,0,"lcdb");
} header("Location:liuchenggenzong.php"); ?>