使用Ajax實現根據人力資源系統數據增加OA賬號的方法

$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); 
 } 
 } 
 } 
 } 
}