1. 添加新流程頁面:
<div>請選擇流程節點:<br /><br /><?phpsession_start();include("../DBDA.class.php");$db = new DBDA();$suser ="select * from users";$auser = $db->Query($suser);foreach($auser as $v){ echo "<input class='rd' type='radio' name='user' value='{$v[0]}' /> {$v[2]} ";}?></div><br /><div><input type="button" value="添加節點" id="jiedian" /></div><br /><div><?php$attr = array();if(!empty($_SESSION["user"])){ $attr = $_SESSION["user"];}foreach($attr as $k=>$v){ $sname = "select name from users where uid='{$v}'"; $name = $db->StrQuery($sname); echo "<div>{$k}--{$name}--<input type='button' value='刪除' bs='{$k}' class='shanchu' /></div>";}?></div><br /><div>請輸入資料流程名稱:<input type="text" id="name" /></div><br /><input type="button" value="儲存" id="xinjian" /><script type="text/javascript">$("#jiedian").click(function(){ //取選中的使用者名稱 var uid =""; var rd = $(".rd"); for(var i=0;i<rd.length;i++) { if(rd.eq(i).prop("checked")) { uid = rd.eq(i).val(); } } $.ajax({ url:"chuli.php", data:{uid:uid,type:0}, type:"POST", dataType:"TEXT", success: function(data){ window.location.href="add.php"; } }); }) $(".shanchu").click(function(){ var sy = $(this).attr("bs"); $.ajax({ url:"chuli.php", data:{sy:sy,type:1}, type:"POST", dataType:"TEXT", success: function(data){ window.location.href="add.php"; } }); })$("#xinjian").click(function(){ var name = $("#name").val(); $.ajax({ url:"chuli.php", data:{name:name,type:2}, type:"POST", dataType:"TEXT", success: function(data){ window.location.href="add.php"; } }); })</script>
2. 添加新流程(及其他)處理頁面:
<?phpsession_start();include("../DBDA.class.php");$db = new DBDA();$type = $_POST["type"];switch($type){ case 0: $uid = $_POST["uid"]; if(empty($_SESSION["user"])) { $_SESSION["user"] = array($uid); } else { $attr = $_SESSION["user"]; $attr[] = $uid; $_SESSION["user"] = $attr; } break; case 1: $sy = $_POST["sy"]; $attr = $_SESSION["user"]; unset($attr[$sy]); $attr = array_values($attr); $_SESSION["user"] = $attr; break; case 2: $name = $_POST["name"]; $code = time(); $slc = "insert into liucheng values('{$code}','{$name}')"; //liucheng 名字 代號 $db->Query($slc,0); $attr = array(); if(!empty($_SESSION["user"])) { $attr = $_SESSION["user"]; } foreach($attr as $k=>$v) { $sfp = "insert into flowpath values('','{$code}','{$v}','{$k}')"; //flowpath 流程具體經過哪些人 $db->Query($sfp,0); } break; case 3: $code = $_POST["code"]; $nr = $_POST["nr"]; $uid = $_SESSION["uid"]; $rq = time(); $sql = "insert into userflow values('','{$code}','{$uid}','{$nr}',0,'{$rq}',0)"; //userflow 流程具體內容,名字,發起人 $db->Query($sql,0); //,內容,是否通過,事件,進行到哪一步 break;}
3. 登入後首頁面:
<a href="faqi.php">發起流程</a><table width="100%" border="1" cellpadding="0" cellspacing="0"> <tr> <td>發起者</td> <td>發起時間</td> <td>流程名稱</td> <td>流程內容</td> <td>是否結束</td> <td>操作</td> </tr> <?php session_start(); include("../DBDA.class.php"); $db = new DBDA(); $uid = $_SESSION["uid"]; $sql = "select * from userflow"; $attr = $db->Query($sql); foreach($attr as $v) { $v[1];//流程代號 $v[6]; //流程走到哪了 //根據流程代號和當前登入者使用者名稱查orders $szai="select count(*) from flowpath where code='{$v[1]}' and uids='{$uid}'"; $n = $db->StrQuery($szai); //該人員在該流程下 if($n>0) { $sorder = "select orders from flowpath where code='{$v[1]}' and uids='{$uid}'"; $order = $db->StrQuery($sorder); if($v[6]>=$order) { $str = ""; if($v[6]==$order) { $str = "<a href='tongguo.php?ids={$v[0]}'>通過</a>"; } else { $str = "<span style='color:green'>已處理</span>"; } echo "<tr><td>{$v[2]}</td> <td>{$v[5]}</td> <td>{$v[1]}</td> <td>{$v[3]}</td> <td>{$v[4]}</td> <td>{$str}</td></tr>"; } } } ?> </table>
4. 發起流程頁面:
<h1>發起流程</h1><div>請選擇要發起的流程: <select id="sel"> <?php include("../DBDA.class.php"); $db = new DBDA(); $sql = "select * from liucheng"; $attr = $db->Query($sql); foreach($attr as $v) { echo "<option value='{$v[0]}'>{$v[1]}</option>"; } ?> </select></div><br /><div>請輸入資料流程的詳情:<textarea id="xq"></textarea></div><br /><input type="button" value="發起" id="btn" /><script type="text/javascript">$("#btn").click(function(){ var code = $("#sel").val(); var nr = $("#xq").val(); $.ajax({ url:"chuli.php", data:{code:code,nr:nr,type:3}, type:"POST", dataType:"TEXT", success: function(data){ window.location.href="main.php"; } }); })</script>
4. 判斷髮起的流程是否通過頁面:
<?phpsession_start();include("../DBDA.class.php");$db = new DBDA();$ids = $_GET["ids"];$sql = "update userflow set towhere = towhere+1 where ids='{$ids}'";$db->Query($sql,0);$stw = "select code,towhere from userflow where ids='{$ids}'";$atw = $db->Query($stw);$lcdaihao = $atw[0][0];$towhere = $atw[0][1];$jiedian = "select count(*) from flowpath where code='{$lcdaihao}'";$shuliang = $db->StrQuery($jiedian);if($towhere>=$shuliang){ $su = "update userflow set isok =1 where ids='{$ids}' "; $db->Query($su,0);}header("location:main.php");