This article mainly introduces Tongda OA's use of Ajax and workflow plug-ins to add OA accounts based on human resources system data. Friends who need it can refer to it
The program developed by Xiaofeiyu this time mainly solves the problem of a subordinate If the company's account addition in the human resources system cannot be approved immediately, the plug-in can automatically add OA accounts in the background after approval through this process. The adding mechanism is the same as the synchronization between HR and OA systems.
Only add operations, no modification or deletion operations. The automatic data synchronization development of the two systems has been carried out originally, so this development is a supplementary content, and only an application idea and discussion of the development process are provided here.
When the front-end initiator fills in the job number assigned in the HR system when applying, other relevant data can be queried accordingly. In order to avoid modifying the work number after finding the data, a confirmation work number input box is added. Other information is automatically obtained by Ajax in read-only form. In this way, errors caused by completely human input of data can be avoided by obtaining data from another system.
After the approval process is completed, it will be transferred to the OA administrator. The administrator will create an account in the background when making the next transfer. If there are no errors, it will prompt that the creation is successful. , it will also prompt if there is an error.
#The hr system is Hongjing’s human resources system, and the database is SQL Server2008, so this development also needs to connect to the sqlserver database.
The main code of the system:
$query="select * from t_hr_view where c01u7='" .$gonghao. "'"; $cursor=sqlsrv_query($conn,$query); if($row=sqlsrv_fetch_array($cursor,SQLSRV_FETCH_ASSOC)){ $hr_dept_id=$row["E0122_0"]; $hr_dept_name=$row["e0122"]; $OA=$row["OA"]; $hr_name=$row["A0101"]; $hr_gangwei=$row["e01a1"]; $hr_gonghao=$row["c01u7"]; $hr_unique_id=$row["unique_id"]; if($OA==1 or $OA==2){ $query2="select * from user where hr_unique_id='$hr_unique_id' limit 1"; $cursor2=exequery(TD::conn(),$query2); $num=mysql_num_rows($cursor2); if($num==0 and $hr_gonghao!=""){ //新增用户 $DEPT_ID="0"; $new_flag=1; $query4="select DEPT_ID from department where hr_dept_id='$hr_dept_id' limit 1"; $cursor4=exequery(TD::conn(),$query4); if($row4=mysql_fetch_row($cursor4)){ $DEPT_ID=$row4[0]; } if(in_array($hr_dept_name, $neitui_dept_arr)){ $DEPT_ID="0"; } /****查询byname有没有重复的**/ $query5="select * from user where BYNAME='$hr_gonghao' limit 1"; $cursor5=exequery(TD::conn(),$query5); $num5=mysql_num_rows($cursor5); //$num5=1;//测试失败 if($num5==1){ $new_flag=-1; } /******/ if($new_flag==1){ //允许新增用户 $has_user_id_str = ''; $queryn = 'SELECT UID,USER_ID FROM user'; $cursorn = exequery(TD::conn(), $queryn); while ($rown = mysql_fetch_array($cursorn)) { $has_user_id_str .= $rown['USER_ID'] . ','; } $USER_ID = get_user_id($has_user_id_str); $BYNAME=$hr_gonghao; //登录名为工号 $BYNAME = trim($BYNAME); $USER_NAME=$hr_name; $USER_NAME = trim($USER_NAME); $BYNAME = trim($BYNAME); $UID=add_user_new($ARRAY); if($UID!=""){ $USER_ID=$UID; $query3 = "insert into USER_EXT(UID,USER_ID,USE_POP3,EMAIL_CAPACITY,FOLDER_CAPACITY,WEBMAIL_CAPACITY,WEBMAIL_NUM,DUTY_TYPE) values('$UID','$USER_ID','0','500','500','0','0','1')"; exequery(TD::conn(),$query3); } } } } }
The solution to the problem that the value of the Ajax submission parameter containing the html tag cannot be submitted successfully
Ajax submission form page refreshes quickly
The above is the detailed content of Tongda OA uses Ajax and workflow plug-ins to add OA accounts based on human resources system data (detailed explanation with pictures and texts). For more information, please follow other related articles on the PHP Chinese website!