OA同步钉钉组织机构

<?php
ini_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 = new dingClass();
// 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 ($depts as $k=>$val) {
        $arr = $ding->deptUser($token['access_token'],$val['id']);
        $idsARR = $arr['userlist'];
        $idsARR_sum = count($idsARR);
        if($idsARR_sum >0){
            foreach($idsARR as $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 ($users as $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_users as $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 ($userARR as $k=>$val) {
        //var_dump($k);die;
        $userinfo['mobile'] = '';
        $userinfo = $ding->getuserInfo($token['access_token'],$k);
        if($usersum >0  && in_array($k,$usersarr)){//user表存在用户
            //不做处理
        }else if($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");

<?php
ini_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	职员	10
function addUser($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_ARRAY as $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";