Use php+ajax to create new processes related to leave, purchase, shipment, etc.

This article mainly introduces the use of php+ajax to create a new process (leave request, purchase, shipment, etc.). Friends in need can refer to it

For managers, the computer-operated leave request process is better than The manual leave process is much more efficient, so how to create a new process?

First of all: What processes need to be clarified?

Secondly: Which personnel are needed to execute each process?

Finally: What is the order of people performing this process?

Step one: Three tables are needed, namely: user table; liucheng table; liuchengjiedian table (the last two have not been added yet)

Step 2: Use the drop-down list to read the contents of the users table:

 <p id="top">
<p>请选择节点人员:</p>
<select id="user">
<?php
require "../DB.class.php";
$db = new DB();
$sql = "select * from users";
$arr = $db->query($sql);
foreach ($arr as $v){
 echo "<option value=&#39;{$v[0]}&#39;>{$v[2]}</option>";
}
?>
</select>
<input type="button" value="确定添加"/>
</p>

Implementation effect:

Step 3: Click "Confirm Add" to add the selected person to the session

(1) First introduce the jquery package

<script src="../jquery-1.11.2.min.js"></script>

(2 ) ajax code

<script type="text/javascript">
 //用session 存取选择的值
 $("#add").click(function(){
   var uid = $("#user").val();
   //  alert(uid);
   $.ajax({
    url:"add-cl.php",
    data:{uid:uid},
    type:"POST",
    dataType:"TEXT",
    success:function(data){
     window.location.href="main.php" rel="external nofollow" rel="external nofollow" ;
    }
   });  
 })
</script>

(3) add-cl.php page

<?php
 //开启session
 session_start();
 //取值
 $uid=$_POST["uid"];
 //如果session为空，造一个数组，将取到的值添加进去
 if(empty($_SESSION["jiedian"])){
  $arr = array($uid);
  $_SESSION["jiedian"] = $arr;
 }
 //如果不为空，将取到的值追加进去
 else
 {
  $arr = $_SESSION["jiedian"];
  $arr[]=$uid;
  $_SESSION["jiedian"] = $arr;
 }
?>

Step 4: Select List the people

(1) First determine whether the session value is obtained

<?php
    session_start(); 
    if(empty($_SESSION["jiedian"])){
      echo "尚未选择节点人员！";
    }

(2) Get After arriving in session

else
    {
     $arr = $_SESSION["jiedian"];
     foreach($arr as $k=>$v)
     {
      $sql = "select name from users where uid='{$v}'";
      $name = $db->strquery($sql);
      echo "<p>{$k}--{$name}--<input type =&#39;button&#39; value=&#39;移除&#39; class=&#39;yichu&#39; code=&#39;{$k}&#39;> <p>";
     }     
    }    
   ?>

(3) Add a click event to the "Remove" button

ajax page:

$(".yichu").click(function(){
  var code = $(this).attr("code");
  $.ajax({
    url:"yichu-cl.php",
    data:{code:code},
    type:"POST",
    dataType:"TEXT",
    success:function(data){
     window.location.href="main.php" rel="external nofollow" rel="external nofollow" ;
    }
   });  
 })

yichu-cl.php page:

<?php
session_start();
$code = $_POST["code"];
$arr = $_SESSION["jiedian"];
//从数组中删除code这一项
unset($arr[$code]);
//将索引重新排列
$arr = array_values($arr);
$_SESSION["jiedian"] = $arr;
?>

Click to remove Wang Wu: then Zhang Sanhe will remain Saturday, and the code is rearranged

Last step: Add a save button to add the data to the database

Note: All data before this is Exists in session

(1) Add process name input box and save button

<p id="btm">
    请输入流程名称：
   <input type="text" class="name" />
   <input type="button" value="保存" class="baocun" />
   </p>

(2) Click the save button to store all information in the database

ajax code

$(".baocun").click(function(){
  var name = $(".name").val();
//  alert(name);
  $.ajax({
    url:"baocun-cl.php",
    data:{name:name},
    type:"POST",
    dataType:"TEXT",
    success:function(data){
     alert("保存成功！");
    }
   }); 
 })

baocun-cl.php page

##

<?php
session_start();
require "../DB.class.php";
$db = new DB();
//将数据写进liucheng表
$name = $_POST["name"];
$code=time();//用时间戳来生成code
$sql = "insert into liucheng values(&#39;{$code}&#39;,&#39;{$name}&#39;)";
$db->query($sql,0);
//将数据写入liucehngjiedian表
$arr = $_SESSION["jiedian"];
foreach($arr as $k=>$v)
{
 $sql = "insert into liuchengjiedian values (&#39;&#39;,&#39;{$code}&#39;,&#39;{$v}&#39;,&#39;{$k}&#39;)";
 $db->query($sql,0);
}
?>

Implementation effects and writing Data entered into the database:

         

At this step, the entire Liu Xinjian process steps can be realized, and the interface can be beautified later. ~~~~

Summary: Each step of processing the page is more important; sessoin accesses data; unsettle() removes the array; array_values() rearranges the array, etc.~~~

The above is the detailed content of Use php+ajax to create new processes related to leave, purchase, shipment, etc.. For more information, please follow other related articles on the PHP Chinese website!