$departmentArr = $departmentList['department'];
$departCount = count($departmentArr);
$departmentId = '1';
$userOfDepartment = $wxApi->wxGetUserOfDepartment($accessToken, $departmentId, 1, 0);
$allUserOfDepart = json_decode($userOfDepartment, true);
$userNum = count($allUserOfDepart['userlist']);
if ($q = "Synchronize") {
//执行更新
//数据库操作
$dbTasks = new dbModel();
//删除表
$deleteSql = "DROP TABLE IF EXISTS wxuserlist";
$dropRes = $dbTasks->dropTable($deleteSql);
//创建表
$createSql = "CREATE TABLE wxuserlist (\r\n id varchar(255) NOT NULL PRIMARY KEY,\r\n createTime datetime DEFAULT NULL,\r\n name varchar(255) DEFAULT NULL,\r\n password varchar(255) DEFAULT NULL,\r\n type int(11) DEFAULT NULL,\r\n weixinId varchar(255) DEFAULT NULL,\r\n department1 varchar(255) DEFAULT NULL,\r\n department2 varchar(255) DEFAULT NULL,\r\n projectGroup varchar(255) DEFAULT NULL,\r\n avatar varchar(255) DEFAULT NULL,\r\n email varchar(255) DEFAULT NULL,\r\n gender varchar(255) DEFAULT NULL,\r\n mobile varchar(255) DEFAULT NULL,\r\n position varchar(255) DEFAULT NULL,\r\n status varchar(255) DEFAULT NULL,\r\n huaweiId varchar(255) DEFAULT NULL,\r\n regisStatus int(11) DEFAULT NULL\r\n ) CHARACTER SET utf8 COLLATE utf8_general_ci";
$createRes = $dbTasks->createTable($createSql);
//插入数据
for ($i = 0; $i < $userNum; $i++) {
$userid = $allUserOfDepart['userlist'][$i]['userid'];
$createTime = date('Y-m-d h:i:s', time());
$name = $allUserOfDepart['userlist'][$i]['name'];
$type = '0';
$weixinId = $allUserOfDepart['userlist'][$i]['weixinid'];
$departmentid = $allUserOfDepart['userlist'][$i]['department'][0];
$department = $noToDepartment[$departmentid];
$avatar = $allUserOfDepart['userlist'][$i]['avatar'];
$genderNo = $allUserOfDepart['userlist'][$i]['gender'];
$gender = $noToGender[$genderNo];
$statusNo = $allUserOfDepart['userlist'][$i]['status'];
$status = $noToStatus[$statusNo];
$regisStatus = 0;
