How to implement the initiation process and review process using php+ajax

This article mainly introduces the php ajax initiation process and review process (taking leave as an example). Friends in need can refer to it

Let me talk about the ideas first:

(1) Log in and use session to obtain the user’s ID

(2) The user initiates a process

Note: You need to write the application reason

(3) The reviewer at the node will review in turn

Note: for each review that passes, the corresponding towhere field will be added by 1; when the review reaches the end, the corresponding isok field will change to 1 (here 1 means the end, 0 means Not ended)

shares three tables:

Step one: Make a simple login page first, and use session to get the user name:

denglu.php page

     
  
 用户名：
 密码：
  
  

denglu-cl.php page

strquery($sql); if($pwd==$mm && !empty($pwd)) { $_SESSION["uid"]=$uid; header("location:liucheng.php"); } else { echo "密码或登录名输入错误"; } ?>

Rendering:

Step 2: Make a simple note page: liucheng.php

      
  
 
主页面
 
 发起流程
 审核流程 
 
  

Rendering:

Step 3: Initiate the process page faqi.php

(1) First display all processes in a drop-down list

(2) The reason for initiating the process needs to be filled in by the logged in user

      
  
 
 
发起流程页面
  query($sql); foreach($arr as $v) { echo "{$v[1]}"; } ?> 
 发起流程事由：  
  
 
  

Step 4: Write the initiation process The processing page fq-cl.php

query($sql,0); header("location:liucheng.php"); ?>

Click "Confirm Initiation" and this data will be added to the database

Step 5: Process review page shenhe.php

Knowledge points used: subquery: irrelevant subquery (subquery and parent query can be executed independently); related subquery (subquery The conditions here use something from the parent query )

      
  
 
流程审核页面
 =(select orders from liuchengjiedian b where b.code = a.code and b.uids = '{$uid}')"; $arr = $db->query($sql); //var_dump($arr); echo ""; foreach($arr as $v){ //操作最后一列 //设置默认项 $zt = "审核未通过"; $sql = "select orders from liuchengjiedian where code ='{$v[1]}' and uids ='{$uid}'"; $wz = $db->strquery($sql); if($v[6]>$wz) { $zt = "审核已通过"; } echo ""; } echo "
 
 
流程代号
 
发起者
 
发起内容
 
发起时间
 
是否结束
 
操作
 
 
{$v[1]}
 
{$v[2]}
 
{$v[3]}
 
{$v[4]}
 
{$v[5]}
 
{$zt}
 
"; ?> 
  

Step 6: Write tongguo-cl.php page (important)

query($sql,0); //当流程走到最后一个审核的人时，流程要结束 //获取该流程最大的orders $sql =" select max(orders) from liuchengjiedian where code = (select code from liuchengpath where ids ='{$ids}')"; $maxorders = $db->strquery($sql); //获取该用户处于哪个位置，也就是towhere等于多少 $sql ="select towhere from liuchengpath where ids ='{$ids}'"; $towhere = $db->strquery($sql); //判断是否已到达最后一个审核的人 if($towhere>$maxorders) { $sql = "update liuchengpath set isok=1 where ids='{$ids}'"; // var_dump($sql); $db->query($sql,0); } header("location:shenhe.php"); ?>

When this step is written, click "Audit failed" and it will change to "Audit passed";

Let’s verify the effect from the beginning:

First: initiate a new leave process:

Secondly: zhangsan is the first to ask for leave The reviewer

clicks "After the review fails",

Finally : zhaoliu is the last reviewer

After clicking "Audit failed", whether the end is changed to 1; the operation turns green "Audit passed"~~~

Related recommendations:

continue statement for php process control

php flow control break statement

php flow control what is foreach

The above is the detailed content of How to implement the initiation process and review process using php+ajax. For more information, please follow other related articles on the PHP Chinese website!