利用ajax和PHP实现简单的流程管理
2018-10-15 18:01
阅读：523
本文实例为大家分享了ajax和PHP实现简单的流程管理，供大家参考，具体内容如下
首先要先有一个新建流程的页面xinjian.php
<!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN 新建</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 发起流程</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 审核</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);以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持脚本之家。
文章来自：搜素材网的编程语言模块，转载请注明文章出处。
文章标题：利用ajax和PHP实现简单的流程管理
文章链接：http://soscw.com/index.php/essay/18950.html
文章标题：利用ajax和PHP实现简单的流程管理
文章链接：http://soscw.com/index.php/essay/18950.html
评论
亲，登录后才可以留言！