* User: ppmacs
* Date: 2015/12/23
* Time: 16:53
*/
set_time_limit(0);
header('Content-Type:text/html;charset=utf-8 ');
//设置URL编码头信息
require '../../../../../Model/dbModel.php';
//获取button_id值
$button_id = $_GET["q"];
//$button_id = "adasddasdsads";
$dbModel = new dbModel();
//删除与button_id同名的表
$tableName = $button_id;
$dropTblSql = "DROP TABLE IF EXISTS " . $tableName;
$resDropTbl = $dbModel->dropTable($dropTblSql);
//删除task_regis中的数据
$task_id = substr($button_id, -10);
//取出后10位
//$task_id = substr($lastLetter,0,10);//取出前10位
$deleteSql = "DELETE FROM task_regis WHERE id = " . $task_id;
$resDel = $dbModel->deleteItem($deleteSql);
if ($resDropTbl == "删除成功" && $resDel == "删除成功") {
echo "success";
//页面跳转
$url = "http://demo-firstlab.huawei.com:8081/Registration/pcController/manage_Console/taskController/tasks/task.php?p=1";
if (isset($url)) {
Header("Location: {$url}");
}
} else {
echo "fail";
//获取部门列表
$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'];
$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];
