首页 > 代码库 > 如何使用ajax与php时间简单的流程管理

如何使用ajax与php时间简单的流程管理

首先要先有一个新建流程的页面xinjian.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>新建</title>
<script src="http://www.mamicode.com/FENGZHUANG/jquery-3.1.1.min.js"></script>
</head>

<body>
<h1>新建流程</h1>

<div>
请选择节点人员:
<select id="user">
    <?php
    session_start();//需要将一些数据暂时存在session里
    include("../FENGZHUANG/DBDA.class.php");
    $db = new DBDA();
    
    $sql = "select * from users";
    $arr = $db->Query($sql);
    foreach($arr as $v)
    {
        echo "<option value=http://www.mamicode.com/‘{$v[0]}‘>{$v[2]}";
    }
    ?>
</select>
<input type="button" value="http://www.mamicode.com/添加节点" id="add" />
</div>
<br />
<div>
    <?php
    if(!empty($_SESSION["user"]))
    {
        $attr = $_SESSION["user"];
        foreach($attr as $k=>$v)  //索引为$k,取值为$v
        {
            $sname = "select name from users where uid=‘{$v}‘";  //取出名称
            $name = $db->StrQuery($sname);
            echo "<div>{$k}--{$name}--<input type=‘button‘ value=http://www.mamicode.com/‘删除‘ key=‘{$k}‘ class=‘del‘ />
"; //向处理页面传的是key的值 } } ?> </div> <br /> <div>请输入流程名称:<input type="text" id="name" /></div> <br /> <input type="button" value="http://www.mamicode.com/保存" id="btn" /> </body> <script type="text/javascript"> //添加节点按钮加点击 $("#add").click(function(){ var uid = $("#user").val(); $.ajax({ url:"chuli.php", data:{uid:uid,type:0}, //传入一个type参数,以确保在同一页面处理时与其它的分开处理 type:"POST", dataType:"TEXT", success: function(data){ window.location.href="http://www.mamicode.com/xinjian.php"; //刷新页面 } }); }) //给删除按钮加点击 $(".del").click(function(){ var key = $(this).attr("key"); //取删除的是哪条数据 $.ajax({ url:"chuli.php", data:{key:key,type:1}, type:"POST", dataType:"TEXT", success:function(data){ window.location.href="http://www.mamicode.com/xinjian.php"; } }); }) //给保存按钮加点击 $("#btn").click(function(){ var name = $("#name").val(); //取输入框中输入内容的值 $.ajax({ url:"chuli.php", data:{name:name,type:2}, type:"POST", dataType:"TEXT", success:function(data){ alert("保存成功!"); } }); }) </script> </html>

技术分享

数据库图片:

技术分享

技术分享技术分享

技术分享

 

 

 

 

处理页面chuli.php

<?php
session_start();
include("../FENGZHUANG/DBDA.class.php");
$db = new DBDA();

$type = $_POST["type"];

switch($type)
{
    case 0://添加节点的加载数据,向session数组中添加数据
        $uid = $_POST["uid"];
        if(empty($_SESSION["user"]))
        {
            $arr = array($uid);
            $_SESSION["user"] = $arr;
        }
        else
        {
            $arr = $_SESSION["user"];
            array_push($arr,$uid);
            $_SESSION["user"] = $arr;
        }
        break;
        
    case 1://取节点的索引,然后删除,重新索引
        $key = $_POST["key"];
        $arr = $_SESSION["user"];
        unset($arr[$key]); //删除
        $arr = array_values($arr); //重新索引
        $_SESSION["user"] = $arr;
        break;
        
    case 2:
        $name = $_POST["name"];
        $code = time();
        //添加流程
        $sql = "insert into liucheng values(‘{$code}‘,‘{$name}‘)";
        $db->Query($sql,0);
        //添加流程节点
        $arr = $_SESSION["user"];
        foreach($arr as $k=>$v)
        {
            $sql = "insert into flowpath values(‘‘,‘{$code}‘,‘{$v}‘,‘{$k}‘)";
            $db->Query($sql,0);
        }
        break;
        
    case 3: //用户发起流程
        $code = $_POST["code"];
        $nr = $_POST["content"];
        $uid = $_SESSION["uid"];
        $time = date("Y-m-d H:i:s");
        $sql = "insert into userflow values(‘‘,‘{$code}‘,‘{$uid}‘,‘{$nr}‘,0,‘{$time}‘,0)";
        $db->Query($sql,0);
        break;
        
}

 

 发起流程页面faqi.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>发起流程</title><br />
<script src="http://www.mamicode.com/FENGZHUANG/jquery-3.1.1.min.js"></script>

</head>

<body>

<h1>发起流程</h1>

<div>
请选择发起的流程:
    <select id="liucheng">
        <?php
        session_start();
        include("../FENGZHUANG/DBDA.class.php");
        $db = new DBDA();
        $sql = "select * from liucheng";
        $arr = $db->Query($sql);
        foreach($arr as $v)
        {
            echo "<option value=http://www.mamicode.com/‘{$v[0]}‘>{$v[1]}";
        }
        ?>
    </select>
</div>
<br />
<div>
请输入内容:
    <textarea id="nr"></textarea>
</div>
<br />
<input type="button" value="http://www.mamicode.com/发起" id="btn" />


</body>
<script type="text/javascript">
$("#btn").click(function(){
        var code = $("#liucheng").val();
        var content = $("#nr").val();
        
        $.ajax({
            url:"chuli.php",
            data:{code:code,content:content,type:3},
            type:"POST",
            dataType:"TEXT",
            success: function(data){
                alert("发起成功!");
                }            
            });
    })
</script>
</html>

技术分享

 

审核页面shenhe.php

技术分享
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>审核</title>
</head>

<body>
<h1>审核页面</h1>
<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("../FENGZHUANG/DBDA.class.php");
    $db = new DBDA();
    $uid = $_SESSION["uid"];
    echo $uid;
    //查找登录者参与的所有流程
    $sql = "select * from userflow where code in(select code from flowpath where uids=‘{$uid}‘)";
    $arr = $db->Query($sql);
    
    //显示
    foreach($arr as $v)
    {
        //判断该流程走到登录者
        $lcdh = $v[1]; //流程代号
        $towhere = $v[6];//流程走到哪
        $sql = "select orders from flowpath where code=‘{$lcdh}‘ and uids=‘{$uid}‘";
        $order = $db->StrQuery($sql);//该人员在流程中的次序
        
        if($towhere>=$order)
        {
            $caozuo = "";
            if($towhere==$order)
            {
                $caozuo="<a href=http://www.mamicode.com/‘tongguo.php?code={$v[0]}‘>通过";
            }
            else
            {
                $caozuo="<span style=‘color:white‘>已通过</span>";
            }
            echo "<tr>
        <td>{$v[1]}</td>
        <td>{$v[2]}</td>
        <td>{$v[3]}</td>
        <td>{$v[4]}</td>
        <td>{$v[5]}</td>
        <td>{$caozuo}</td> 
    </tr>";
        }
        
    }
    ?>
</table>
</body>
</html>

技术分享

技术分享

技术分享

技术分享

技术分享

技术分享

tongguo.php

 
<?php
session_start();
include("../FENGZHUANG/DBDA.class.php");
$db = new DBDA();

//流程往下走
$code = $_GET["code"];
$sql = "update userflow set towhere=towhere+1 where ids=‘{$code}‘"; //使流程向下走
$db->Query($sql,0);

//判断流程是否结束
$sql = "select * from userflow where ids=‘{$code}‘";
$arr = $db->Query($sql);

$lcdh = $arr[0][1]; //流程代号
$tw = $arr[0][6]; //流程走到哪

$sql = "select count(*) from flowpath where code=‘{$lcdh}‘";
$count = $db->StrQuery($sql); //该流程节点人数
if($tw>=$count)
{
    $sql = "update userflow set isok=1 where ids=‘{$code}‘"; //如果结束了流程,将isok项改为结束。
    $db->Query($sql,0);
}


header("location:shenhe.php");

 

 

本篇博客转自http://www.cnblogs.com/gaobint/

如何使用ajax与php时间简单的流程管理