//配置部门映射信息
$noToDepartment = array('1' => '净水潜流', '2' => '接入网', '3' => 'MBB', '4' => '标准专利', '5' => '算法', '6' => '系统技术', '7' => '北研', '8' => '二部', '14' => '公共', '19' => '未关注', '20' => '测试组');
$noToGender = array('0' => '未定义', '1' => '男性', '2' => '女性');
$noToStatus = array('0' => '任意', '1' => '已关注', '2' => '已禁用', '4' => '未关注');
$corpid = 'wxf2c246cabf47faa1';
$corpsecret = 'fM7FbqZlW7qrV0jRJQfhcfoSB6dcPJZ_7m4ARi892MhLPokADn9dZ2EL9S2FTwkD';
//获取全局唯一凭据ACCESS_TOKEN
$wxApi = new WxApi();
$accessToken = $wxApi->wxAccessToken($corpid, $corpsecret);
//获取部门列表
$departmentList = $wxApi->wxGetDepartmentList($accessToken);
$departmentList = json_decode($departmentList, true);
$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'];
