public function createId($min, $max)
{
//生成随机数
$temp = rand($min, $max);
$tempId = "0" . $temp;
//和数据库中进行比对
$selectSql = "SELECT * FROM tempId WHERE tempId=" . $tempId;
$selectRes = parent::selectFromTable($selectSql);
if (!empty($selectRes)) {
while ($row = mysql_fetch_assoc($selectRes)) {
$this->selectTemp = $row['$tempId'];
}
} else {
return "no date";
}
if (empty($this->selectTemp)) {
//插入数据
$insertSql = "INSERT INTO tempId (tempId) VALUES ('" . $tempId . "')";
$insertRes = parent::insertIntoTable($insertSql);
if ($insertRes == "插入成功") {
return $tempId;
} else {
return "录入失败";
}
}
}
set_time_limit(0);
header('Content-Type:text/html;charset=utf-8 ');
//设置URL编码头信息
//require('../../../../../Model/dbModel.php');
require 'handleRegisMakeTemp.php';
$tablename = $_POST['tablename'];
$name = $_POST['name'];
//$weixinId = $_POST['weixinId'];
//$tempId = $_POST['tempId'];
//生成tempId
$makeTemp = new makeTemp();
$tempId = $makeTemp->createId(10000, 99999);
if (is_numeric($tempId)) {
} else {
echo "不合法的工号";
}
$defaultDepar = "外来访客";
$defaultStatus = 1;
$regisTime = time();
//生成时间戳
$regisTimeOuter = date('Y-m-d H:i:s', $regisTime);
$defaultLottery = 0;
//将外来人员数据插入数据库中
$dbModel = new dbModel();
$insertOuter = "INSERT INTO " . $tablename . " (id,name,department,huaweiId,regisStatus,regisTime,lottery)\r\n VALUES ('" . $tempId . "','" . $name . "','" . $defaultDepar . "','" . $tempId . "','" . $defaultStatus . "','" . $regisTimeOuter . "',\r\n '" . $defaultLottery . "')";
$insertRes = $dbModel->insertIntoTable($insertOuter);
if ($insertRes == "插入成功") {
echo $name;
} else {
echo "fail";
}
if (!empty($selectRes)) {
while ($row = mysql_fetch_assoc($selectRes)) {
array_push($selectArr, array($row['name'], $row['weixinId'], $row['department1'], $row['avatar'], $row['gender'], $row['status'], $row['huaweiId']));
}
if ($selectArr[0][0] == null || $selectArr[0][6] == null) {
//查找失败
echo "未查到数据";
}
} else {
echo "未查到数据";
}
$task_id = time();
//生成时间戳
$create_time = date('Y-m-d H:i:s', $task_id);
$insertUserListSql = "INSERT INTO " . $tablename . " (id , name , weixinId , department , avatar , gender , status ,\r\n huaweiId , regisStatus , regisTime , lottery ) VALUES ('" . $selectArr[0][6] . "','" . $selectArr[0][0] . "','" . $selectArr[0][1] . "','" . $selectArr[0][2] . "',\r\n '" . $selectArr[0][3] . "','" . $selectArr[0][4] . "','" . $selectArr[0][5] . "','" . $selectArr[0][6] . "',\r\n '" . $regisStatus . "','" . $create_time . "','" . $defaultLottery . "')";
$insertUserListRes = $dbModel->insertIntoTable($insertUserListSql);
if ($insertUserListRes == "插入成功") {
//跳转到签到成功页面,显示3秒后跳转到任务列表页面
//页面跳转
$url = "http://demo-firstlab.huawei.com:8081/Registration/pcController/manage_Console/taskController/tasks/task_button_events/handleRegisSuccess.html?name=" . $username;
if (isset($url)) {
Header("Location: {$url}");
}
} else {
//跳转到签到失败页面,显示3秒后跳转到任务列表页面
$url = "http://demo-firstlab.huawei.com:8081/Registration/pcController/manage_Console/taskController/tasks/task_button_events/handleRegisFailed.html?name=" . $username;
if (isset($url)) {
Header("Location: {$url}");
}
}
}
$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;
$huaweiId = $allUserOfDepart['userlist'][$i]['extattr']['attrs'][0]['value'];
$insertSql = "INSERT INTO wxuserlist (id,createTime,name,type,weixinId,department1,avatar,gender,status,huaweiId,regisStatus)\r\n VALUES ('" . $userid . "','" . $createTime . "','" . $name . "','" . $type . "','" . $weixinId . "','" . $department . "','" . $avatar . "','" . $gender . "','" . $status . "','" . $huaweiId . "','" . $regisStatus . "')";
$insertRes = $dbTasks->insertIntoTable($insertSql);
}
$response = "更新完成";
} else {
$response = "更新失败";
}
echo $response;
//已签过到，返回友好信息
$htmlNode .= "<!DOCTYPE html>\r\n <html>\r\n <head>";
$htmlNode .= " <meta charset='utf-8'>\r\n <meta name='viewport' content='initial-scale=1, maximum-scale=1, user-scalable=no'>\r\n <meta name='format-detection' content='telephone=no'>\r\n <title>" . $task_name . "</title>\r\n <link rel='stylesheet' href='../frozenui/css/frozen.css'>\r\n </head>";
$htmlNode .= "<body ontouchstart='' style='background-image: url(../frozenui/img/h5BG3.png)'>";
$htmlNode .= "<header class='ui-header ui-header-positive ui-border-b'>\r\n <h1>您签过啦</h1>\r\n </header>";
$htmlNode .= "<section class='ui-container ui-center' style='margin-top: 20%'>";
$htmlNode .= "<div class='ui-avatar-lg'>\r\n <span style='background-image:url(" . $avatar . ")'></span>\r\n </div>";
$htmlNode .= "<div class='okToast'>\r\n <img src='../frozenui/img/ok.png'>\r\n </div>";
$htmlNode .= " <div class='ui-whitespace'>\r\n <p class='ui-txt-highlight'>亲爱的" . $userName . "，您已经签过到啦</p>\r\n </div>";
$htmlNode .= "<div style='margin-top: 15%;color: #ff0000'>\r\n <span class='ui-avatar-tiled'><span style='background-image:url(" . $regisUser[0] . ")'></span></span>\r\n <span class='ui-avatar-tiled'><span style='background-image:url(" . $regisUser[1] . ")'></span></span>\r\n <span class='ui-avatar-tiled'><span style='background-image:url(" . $regisUser[2] . ")'></span></span>\r\n <span class='ui-avatar-tiled'><span style='background-image:url(" . $regisUser[3] . ")'></span></span>\r\n <span class='ui-avatar-tiled'><span style='background-image:url(" . $regisUser[4] . ")'></span></span>\r\n ...</div>";
$htmlNode .= "</section>\r\n <script src='../frozenui/lib/zepto.min.js'></script>\r\n <script src='../frozenui/js/frozen.js'></script>\r\n </body>\r\n </html>";
echo $htmlNode;
} else {
//插入
$insertSql = "INSERT INTO " . $tableName . " (id,name,weixinId,department,avatar,gender,status,huaweiId,regisStatus,regisTime,lottery)\r\n VALUES ('" . $huaweiId . "','" . $userName . "','" . $weixinNo . "','" . $department . "','" . $avatar . "','" . $gender . "',\r\n '" . $status . "','" . $huaweiId . "','" . $defaultRegisStatus . "','" . $create_time . "','" . $defaultLottery . "')";
$inserRes = $dbModel->insertIntoTable($insertSql);
/*
//向实时显示页面发送数据
$arriveUrl = "http://demo-firstlab.huawei.com:8081/Registration/pcController/manage_Console/taskController/arrived/arriveStatus.html";
$post_date = array(
"username"=>$userName,
"huaweiId"=>$huaweiId
);
$output = $wxApi->curlPostRqst($arriveUrl,$post_date);
*/
if ($inserRes == "插入成功") {
//打印成功页面
$htmlNode .= "<!DOCTYPE html>\r\n <html>\r\n <head>";
$htmlNode .= " <meta charset='utf-8'>\r\n <meta name='viewport' content='initial-scale=1, maximum-scale=1, user-scalable=no'>\r\n <meta name='format-detection' content='telephone=no'>\r\n <title>" . $task_name . "</title>\r\n <link rel='stylesheet' href='../frozenui/css/frozen.css'>\r\n </head>";
$htmlNode .= "<body ontouchstart='' style='background-image: url(../frozenui/img/h5BG3.png)'>";
$htmlNode .= "<header class='ui-header ui-header-positive ui-border-b'>\r\n <h1>欢迎您</h1>\r\n </header>";
