利用ajax和PHP实现简单的流程管理

5年以前 | 阅读数：304 次 | 编程语言：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="../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='{$v[0]}'>{$v[2]}</option>";
     }
     ?>
    </select>
    <input type="button" value="添加节点" 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='删除' key='{$k}' class='del' /></div>"; //向处理页面传的是key的值
      }
     }
     ?>
    </div>
    <br />
    <div>请输入流程名称：<input type="text" id="name" /></div>
    <br />
    <input type="button" value="保存" 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="xinjian.php" rel="external nofollow" rel="external nofollow" ; //刷新页面
        }
       });
     })

    //给删除按钮加点击
    $(".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="xinjian.php" rel="external nofollow" rel="external nofollow" ;
        }
       });
     })
    //给保存按钮加点击
    $("#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="../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='{$v[0]}'>{$v[1]}</option>";
      }
      ?>
     </select>
    </div>
    <br />
    <div>
    请输入内容：
     <textarea id="nr"></textarea>
    </div>
    <br />
    <input type="button" value="发起" 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='tongguo.php?code={$v[0]}'>通过</a>";
       }
       else
       {
        $caozuo="<span style='background-color:green;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");

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持脚本之家。