<?phpini_set("display_errors","On");error_reporting(E_ALL^E_NOTICE^E_WARNING);set_time_limit(0);header("Content-type: text/html; charset=UTF-8");//引入资源include_once('inc/session.php');include_once('core.php');include_once('html/DingClass.php');$ding=newdingClass();// var_dump($_SESSION);// exit;if(!$_SESSION['LOGIN_UID']){header('Location:'."http://oa.XXXXX.com:8089/");
exit;}dbquery("truncate table td_users_log");$AppKey='XX';$AppSecret='XX';//1.获取应用access_token$token=$ding->get_accessToken($AppKey,$AppSecret);//部门列表$deptarr=$ding->depts($token['access_token']);$depts=$deptarr['department'];//部门数组$depts_sum=count($depts);//部门总数$useridARR=[];// 钉钉userid 数组$userARR=[];//钉钉数组数据 key 为 userid val 为 姓名if($depts_sum>0){foreach($deptsas$k=>$val){$arr=$ding->deptUser($token['access_token'],$val['id']);$idsARR=$arr['userlist'];$idsARR_sum=count($idsARR);if($idsARR_sum>0){foreach($idsARRas$kk=>$v){$name=$v['name'];$count=count($userARR);$userARR[$v['userid']]=$name;$useridARR[$count]=$v['userid'];}}}}$usersidArr=[];//user userid数组 钉钉userid$users=dbarray("select userid from user where userid !=''");$usersarr=[];foreach($usersas$k=>$val){$usersarr[$k]=$val['userid'];}$usersum=count($usersarr);//user 数据总数$usersidArr=[];//user userid数组$td_users=dbarray("select userid from td_users_log");$td_userArr=[];foreach($td_usersas$k=>$val){$td_userArr[$k]=$val['userid'];}$usersum=count($usersarr);//user 数据总数//var_dump($useridARR);//var_dump($usersarr);$diff=array_diff($useridARR,$usersarr);//var_dump($diff);//var_dump($td_userArr);$diffs=array_diff($diff,$td_userArr);//区别// var_dump($diffs);// die;if(count($userARR)>0){foreach($userARRas$k=>$val){//var_dump($k);die;$userinfo['mobile']='';$userinfo=$ding->getuserInfo($token['access_token'],$k);if($usersum>0&&in_array($k,$usersarr)){//user表存在用户//不做处理}elseif($usersum>0&&!in_array($k,$usersarr)){//user表不存在用户$logdt['userid']=$k;//userid$logdt['name']=$val;//姓名$logdt['mobile']=$userinfo['mobile'];;//手机号$logdt['time']=date('Y-m-d');//日期$logdt['type']='新增';//类型$userdt['userid']=$k;$sql="select UID,MOBIL_NO,USER_PRIV_NAME from user where USER_NAME = '{$val}' ";$row=dbrow($sql);if($row){//能找到用户 但用户 钉钉userid 没绑定$UID=$row['UID'];$where="UID = $UID";$userdt['userid']=$k;dbupdate('user',$userdt,$where);}else{//找不到用户,新增$sql="select * from td_users_log where name = '{$val}' and userid = '{$k}'";$row=dbrow($sql);if($row){$where="userid = '{$k}'";dbupdate('td_users_log',$logdt,$where);}else{dbinsert('td_users_log',$logdt);}}}}}header('Location:'."http://oa.XXXX.com:8089/dingding/logs.html");
<?phpini_set("display_errors","On");error_reporting(E_ALL^E_NOTICE^E_WARNING);set_time_limit(0);header("Content-type: text/html; charset=gbk");//引入资源include_once("inc/td_core.php");include_once("inc/utility.php");include_once("inc/utility_cache.php");//用户// 默认部门 68 未分配(新增) 角色 5 职员 10functionaddUser($userId,$userName,$deptId,$mobile){$pwd="888";$PASSWORD=crypt($pwd);$USER_NAME_INDEX=getchnprefix($userName);$USER_ARRAY=array("USER_ID"=>$userId,"USER_NAME"=>$userName,"USER_NAME_INDEX"=>$USER_NAME_INDEX,"PASSWORD"=>$PASSWORD,"USER_PRIV"=>"5",// 角色id"POST_PRIV"=>"","POST_PRIV"=>"","IM_RANGE"=>1,"DEPT_ID"=>$deptId,"DEPT_ID_OTHER"=>"","AVATAR"=>$SEX,"CALL_SOUND"=>1,"SMS_ON"=>1,"USER_PRIV_OTHER"=>"","USER_NO"=>10,//用户排序号"NOT_LOGIN"=>0,"NOT_VIEW_USER"=>0,"NOT_VIEW_TABLE"=>0,"NOT_SEARCH"=>0,"BYNAME"=>$mobile,"BIRTHDAY"=>"0000-00-00","THEME"=>19,//界面主题"SHORTCUT"=>"","MOBIL_NO"=>$mobile,"MOBIL_NO_HIDDEN"=>"","BIND_IP"=>"","KEY_SN"=>"","USEING_KEY"=>"","REMARK"=>"","TEL_NO_DEPT"=>"","EMAIL"=>"","USING_FINGER"=>"","IS_LUNAR"=>0,"USER_PRIV_NO"=>10,//角色编号"USER_PRIV_NAME"=>"职员"//角色名称);$USER_KEY_STR="";$USER_KEY_VALUE="";foreach($USER_ARRAYas$key=>$value){if($key=="NOT_LOGIN"){$NOT_LOGIN=$value;}if($key=="DEPT_ID"){$DEPT_ID=$value;}$USER_KEY_STR.=$key.",";$USER_KEY_VALUE.="'".$value."',";if($key=="USER_ID"){$USER_ID=$value;}}$USER_KEY_STR=td_trim($USER_KEY_STR);$USER_KEY_VALUE=td_trim($USER_KEY_VALUE);$query="insert into user (".$USER_KEY_STR.") values({$USER_KEY_VALUE})";exequery(TD::conn(),$query);$UID=mysql_insert_id();$query=" update user set USER_ID ='{$UID}' where UID={$UID}";exequery(TD::conn(),$query);$USER_ID=$UID;cache_users();$query="insert into USER_EXT(UID,USER_ID,USE_POP3,EMAIL_CAPACITY,FOLDER_CAPACITY,WEBMAIL_CAPACITY,WEBMAIL_NUM,DUTY_TYPE) values(".$UID.",'{$USER_ID}',1,'500','500','0','0','1')";exequery(TD::conn(),$query);$sql="select * from user_priv where user_priv='5' ";$cur=exequery(TD::conn(),$sql);$row=mysql_fetch_array($cur);$query="insert into USER_FUNCTION(uid,user_id,user_func_id_str) values(".$UID.",'{$USER_ID}','{$row['FUNC_ID_STR']}')";exequery(TD::conn(),$query);}$sql=" select * from td_users_log";$cur=exequery(TD::conn(),$sql);while($row=mysql_fetch_array($cur)){//var_dump($row);die;$userId='';$userName=$row['name'];$deptId=68;$mobile=$row['mobile'];$userid=$row['userid'];addUser($userId,$userName,$deptId,$mobile);// echo "OK";// exit;}$sql="truncate table td_users_log";$cur=exequery(TD::conn(),$sql);echo"OK";