首頁  >  文章  >  後端開發  >  php流程管理功能實現的案例

php流程管理功能實現的案例

黄舟
黄舟原創
2017-09-25 09:37:251820瀏覽

核心邏輯:流程管理,在各種系統中扮演很重要的地位,可以把設定好的流程放入系統中,規定好幾個節點,只要所有節點都通過,就可以通過。

建立四張資料庫表:


1.我們先做一個新流程頁面 flow.php,先把節點做好

#

<!DOCTYPE html>
<html>
    <head>
        <meta charset="UTF-8">
        <title></title>    
        <script src="bootstrap/js/jquery-1.11.2.min.js"></script>    
    </head>
    <body>
        <h2>管理员新建流程</h2>
        <p><select id="users" name="users">
            <? "./DBDA.class.php" =  = "select * from users" = ->query(,0(   "<option value=&#39;{[0]}&#39;>{[2]}</option>"?>
            </select>
            <input type="button" value="添加" id="add" />
        </p>        
        <br />
        <p>
            <?((["jd" "还未添加节点人员!" = ["jd"];
                (  =>){
                     = "select name from users where uid=&#39;{}&#39;" = ->StrQuery(,0);
                     "<p>{}--{}--<input type=&#39;button&#39; value=&#39;删除&#39; class=&#39;del&#39; code=&#39;{}&#39; /></p>"?>
        </p>
        <br />
        <p><input type="text" id="name" />
        </p>
        <br />
        <input type="button" value="新建" id="addbtn" />
    </body>
    <script>      
"#add").click( uid = $("#users")..:"flowchuli.php",:"POST",:{uid:uid,type:0},:"TEXT",:.location.href = "flow.php"".del").click( k = $(this).attr("code");
            $.:"flowchuli.php",:"POST",:{k:k,type:1},:"TEXT",:.location.href = "flow.php"
        $("#addbtn").click( name = $("#name")..:"flowchuli.php",:"POST",:{name:name,type:2},:"TEXT",:"添加成功!"</script>
</html>

2.做新流程頁面的處理頁面flowchuli.php

<?phpsession_start();require_once "./DBDA.class.php";$db = new DBDA();$type = $_POST["type"];switch($type){    case 0:        $uid = $_POST["uid"];        if(empty($_SESSION["jd"])){//暂存节点
            $arr = array($uid);//新造数组
            $_SESSION["jd"] = $arr;//存入session
        }else{            $arr = $_SESSION["jd"];//取数组
            $arr[] = $uid;//追加变量到数组
            $_SESSION["jd"] = $arr;
        }        break;    case 1:        $k = $_POST["k"];        $arr = $_SESSION["jd"];        unset($arr[$k]);        $arr = array_values($arr);//重新对数组进行排序,有返回值接收
        $_SESSION["jd"] = $arr;        break;    case 2:    
        $name = $_POST["name"];        $code = time();//自动生成
        $sql = "insert into flow values(&#39;{$code}&#39;,&#39;{$name}&#39;)";//流程表
        $db->query($sql);        //流程节点表
        $arr = $_SESSION["jd"];        foreach($arr as $k=>$v){            $sql = "insert into flowpath values(0,&#39;{$code}&#39;,&#39;{$v}&#39;,{$k})";            $db->query($sql);
        }        
        break;
}

效果如圖:

 

 點選選擇節點人員可以從資料庫調所有人員名單,現在把李四,馬七和張三放入流程中,做一個請假流程:

 


注意:Code必須用varchar,不能用time,因為在上面花了時間戳

3.

現在我們在做一個登陸用戶頁面flowlogin.php,提交請假流程的所有步驟:

<!DOCTYPE html>
<html>
    <head>
        <meta charset="UTF-8">
        <title></title>
        <script src="bootstrap/js/jquery-1.11.2.min.js"></script>
        <script src="bootstrap/js/bootstrap.min.js"></script>
        <link href="bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css"/>
    </head>
    <style>
        .-left:-top:.-left:-top: -.name,.-width:.-top:</style>
    <body>        
<form ="form-horizontal" role="form">
    <h3 ="title">用户登录</h3>
    <p ="quanju">
            <p ="form-group yangshi1">
                <label ="firstname" ="col-sm-2 control-label">用户名:</label>
                <p ="col-sm-10">
                    <input type="text" ="form-control name" id="uid" placeholder="请输入用户名">
                </p>
            </p>
            <p ="form-group yangshi2">
                <label ="lastname" ="col-sm-2 control-label">密码:</label>
                <p ="col-sm-10">
                    <input type="text" ="form-control pwd" id="pwd" placeholder="请输入密码">
                </p>
            </p>
            <p ="form-group">
                <p ="col-sm-offset-2 col-sm-10">
                    <p ="checkbox">
                        <label>
                        <input type="checkbox"></label>
                        <label>
                        <input type="checkbox"></label>
                    </p>
                </p>
            </p>
            <p ="form-group">
                <p ="col-sm-offset-2 col-sm-10">
                    <button type="button" id="login" ="btn btn-warning" value="登录" ></button>
                    
                </p>
            </p>
        </p>    
    </form>        
    </body>
    <script>
"#login").click( uid = $("#uid"). pwd = $("#pwd")..:"post",:"flowloginchuli.php",:{uid:uid,pwd:pwd},:"TEXT",:(data.()=="OK".location.href="flowmain.php""用户名或密码有误!"</script>
</html>

4.登入後跳轉的主頁flowmain.php

<!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title></title> </head> <body> <h2>主页面</h2> <a href="flowfq.php">发起流程</a> <a href="flowsh.php">审核流程</a> </body> </html>

5.發起流程頁面flow.php


<!DOCTYPE html>
<html>
    <head>
        <meta charset="UTF-8">
        <title></title>
        <script src="bootstrap/js/jquery-1.11.2.min.js"></script>        
    </head>
    <body>
        <h2>发起流程</h2>
        <form action="flowfqchuli.php" method="post">
            请选择流程:            <select name="flow">
                <?php                require_once "./DBDA.class.php";                $db = new DBDA();                $sql = "select * from flow";                $arr = $db->query($sql,0);                foreach($arr as $v){                    echo "<option value=&#39;{$v[0]}&#39;>{$v[1]}</option>";
                }                ?>
            </select>
            <br />
            <br />
            请输入内容:            <textarea name="content"></textarea>
            <br />
            <br />
            <input type="submit" value="确定" />
        </form>        
    </body>
</html>

6.做發起流程的處理頁面flowfq.php

<?phpsession_start();require_once "./DBDA.class.php";$db = new DBDA();
$code = $_POST["flow"];
$uid = $_SESSION["uid"];$content = $_POST["content"];
$time = date("Y-m-d H:i:s");
$sql = "insert into userflow values(0,&#39;{$code}&#39;,&#39;{$uid}&#39;,&#39;{$content}&#39;,0,&#39;{$time}&#39;,0)";$db->query($sql);header("location:flowmain.php");
7.審核頁面flowsh.php

<!DOCTYPE html>
<html>
    <head>
        <meta charset="UTF-8">
        <title></title>    
        <script src="bootstrap/js/jquery-1.11.2.min.js"></script>
        <script src="bootstrap/js/bootstrap.min.js"></script>
        <link href="bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css"/>    
    </head>
    <body>
    <p><h2>审核页面</h2>
        <table class="table table-bordered">
            <thead>
                <tr>
                    <th>流程代号</th>
                    <th>发起人</th>
                    <th>发起内容</th>
                    <th>通过状态</th>
                    <th>发起时间</th>
                    <th>操作</th>
                </tr>
            </thead>
            <tbody>
                <?php                session_start();                $uid = $_SESSION["uid"];                require_once "./DBDA.class.php";                $db = new DBDA();                //相关子查询(用到父查询的数据)(父查询卡在某一位置)
                $sql = "select * from userflow a where towhere>=(select b.order from flowpath b where b.code=a.code and b.uid=&#39;{$uid}&#39;)";    
                $arr = $db->query($sql,0);    
                foreach($arr as $v){                    //$v[6];//流程走到的位置towhere
                    //$v[1];//利用代号和session中存的name查询order
                    $sql = "select order from flowpath where code=&#39;{$v[1]}&#39; and uid=&#39;{$uid}&#39;";                    $order = $db->StrQuery($sql,0);//该人员在流程中的次序
                    $str = "";                    if($v[6]==$order){                            //传主键值
                        $str = "<a href=&#39;flowtgchuli.php?ids={$v[0]}&#39;>通过</a>";
                    }else{                        $str = "<span style=&#39;color:green&#39;>已通过</span>";
                    }                    echo "<tr>
                    <th>{$v[1]}</th>
                    <th>{$v[2]}</th>
                    <th>{$v[3]}</th>
                    <th>{$v[4]}</th>
                    <th>{$v[5]}</th>
                    <th>{$str}</th>
                </tr>";
                }        
                ?>                                
            </tbody>
        </table>
    </p>    
    </body>
</html>

8.做審核頁面的處理頁面flowshchuli.php

<?php
session_start();
$uid = $_SESSION["uid"];require_once "./DBDA.class.php";
$db = new DBDA();$ids = $_GET["ids"];
$sql = "update userflow set towhere=towhere+1 where ids=&#39;{$ids}&#39;";
$db->query($sql);//判断;流程是否结束(使用相关子查询)
$swc = "update userflow a set isok=1 where ids=&#39;{$ids}&#39; towhere>=(select count(*) from flowpath b where b.code=a.code)";header("location:flowsh.php");

流程效果如圖:

李四的頁面:

點擊通過後:

資料庫:towhere變成1後結束流程

 ######接著該馬七:#########然後是張三:#########資料庫:isok變成1後結束流程############### ####

以上是php流程管理功能實現的案例的詳細內容。更多資訊請關注PHP中文網其他相關文章!

陳述:
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn