PHP+ajax tutorial on initiating and reviewing leave request process-PHP Tutorial-php.cn

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

The previous essay has mentioned how to create a new process, so now Let’s take a look at how to initiate a process and review process~~~

Let’s talk about the idea first:

(1) Log in with session 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 it in sequence

Three tables:

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

denglu.php page

     
   用户名：
 密码：

Copy after login

denglu-cl.php page

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

Copy after login

Rendering:

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

主页面

发起流程
 审核流程

Copy after login

Rendering:

Step 3: Initiate 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

Copy after login

Step 4: Write the processing page fq-cl.php to initiate the process

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

Copy after login

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 (conditions in the subquery 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}  
"; ?>

Copy after login

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"); ?>

Copy after login

When you have finished writing this step, click "Audit failed" and it will become " The review has been passed";

Let's verify the effect from the beginning:

First: initiate a new leave process:

Secondly: zhangsan is the first person to be reviewed

Click "After the review failed ",

Finally: zhaoliu is the last reviewer

##Click After "Audit failed", whether the end changes to 1; the operation changes to green "Audit passed"~~~

The above is the detailed content of PHP+ajax tutorial on initiating and reviewing leave request process. For more information, please follow other related articles on the PHP Chinese website!