Case study of PHP process management function implementation-PHP Tutorial-php.cn

Core logic: Process management plays a very important role in various systems. You can put the set process into the system and specify several nodes. As long as all nodes pass, it can pass.

Create four database tables:

##1. Let’s first make a new process page flow.php, and first make the nodes

<!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>

Copy after login

2. Make the processing page flowchuli.php of the new process page

<?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;
}

Copy after login

The effect is as shown:

Click to select the node personnel to call the list of all personnel from the database. Now add Li Fourth, Ma Qi and Zhang San put them into the process and made a leave request process:

##Note: Code must use varchar, time cannot be used, because the timestamp is used above

Now we are making a login user page flowlogin.php, Submit all steps of the leave application process:

<!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>

Copy after login

4. The main page that jumps after logging in 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>

Copy after login

5. Initiate the process page 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>

Copy after login

6. The processing page for initiating the process 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");

Copy after login

7. The review page 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>

Copy after login

8. Process the review page 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");

Copy after login

The process effect is as shown in the figure:

李思's page:

After clicking and passing:

Database: end the process after towhere becomes 1

Then it’s Ma Qi:

Then it’s Zhang San:

Database: ends after isok becomes 1 process

The above is the detailed content of Case study of PHP process management function implementation. For more information, please follow other related articles on the PHP Chinese website!