public function getResultFromDb($page = "", $pageSize = "")
{
//编写SQL语句获得分业数据 select ＊ from 表名 LIMIT 起始位置，显示条数
$sql = "SELECT * FROM wxuserlist ORDER BY createTime DESC LIMIT " . ($page - 1) * $pageSize . "," . $pageSize;
$result = parent::selectFromTable($sql);
return $result;
}
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 "录入失败";
}
}
}
<?php
/**
* Created by PhpStorm.
* User: ppmacs
* Date: 2016/1/7
* Time: 17:22
*/
set_time_limit(0);
header('Content-Type:text/html;charset=utf-8 ');
//设置URL编码头信息
require '../../../../../Model/dbModel.php';
$huaweiId = trim($_GET['huaweiId']);
//get huaweiId
$dbModel = new dbModel();
$guessArr = array();
$selectId = "SELECT * FROM wxuserlist WHERE huaweiId=" . $huaweiId;
$selectIdRes = $dbModel->selectFromTable($selectId);
if (!empty($selectIdRes)) {
while ($row = mysql_fetch_assoc($selectIdRes)) {
array_push($guessArr, $row['name']);
array_push($guessArr, $row['weixinId']);
}
} else {
echo "no data";
}
$guessJson = json_encode($guessArr);
echo $guessJson;
//设置行高度
$objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(22);
$objPHPExcel->getActiveSheet()->getRowDimension('2')->setRowHeight(20);
//设置水平居中
$objPHPExcel->getActiveSheet()->getStyle('A')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('B')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('C')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('D')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('E')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('F')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('G')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('H')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('I')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
//查询表数据
$selectSql = "SELECT name,huaweiId,department,weixinId,gender,status,regisStatus,regisTime,lottery\r\n FROM " . $tableName;
$resource = $dbModel->selectFromTable($selectSql);
$selectRes = array();
if (isset($resource)) {
while (($row = mysql_fetch_assoc($resource)) != false) {
$row['regisStatus'] = $noToRegisStatus[$row['regisStatus']];
$selectRes[] = $row;
}
} else {
echo "no resource";
}
$data = $selectRes;
$objSheet->setCellValue("A1", $taskName);
$objSheet->setCellValue("A2", "姓名")->setCellValue("B2", "工号")->setCellValue("C2", "部门")->setCellValue("D2", "微信账号")->setCellValue("E2", "性别")->setCellValue("F2", "状态")->setCellValue("G2", "签到状态")->setCellValue("H2", "签到时间")->setCellValue("I2", "抽奖情况");
$startLine = 3;
foreach ($data as $key => $val) {
$objSheet->setCellValue("A" . $startLine, $val['name'])->setCellValue("B" . $startLine, $val['huaweiId'])->setCellValue("C" . $startLine, $val['department'])->setCellValue("D" . $startLine, $val['weixinId'])->setCellValue("E" . $startLine, $val['gender'])->setCellValue("F" . $startLine, $val['status'])->setCellValue("G" . $startLine, $val['regisStatus'])->setCellValue("H" . $startLine, $val['regisTime'])->setCellValue("I" . $startLine, $val['lottery']);
require '../../../Model/dbModel.php';
//获取入参
//$tableName = "task_regis_1451983170";
//$peopleNum = "5";
//$giftLever = "一等奖";
$tableName = $_POST['tableName'];
$peopleNum = $_POST['peopleNum'];
$giftLever = $_POST['giftLever'];
$dbModel = new dbModel();
$pickedDate = array();
//全局变量
//入参检查
//取出还未抽到奖的人员
$countUserArr = array();
$selectSql = "SELECT huaweiId FROM " . $tableName . " WHERE lottery='0'";
$selectRes = $dbModel->selectFromTable($selectSql);
if (!empty($selectRes)) {
while ($row = mysql_fetch_assoc($selectRes)) {
array_push($countUserArr, $row['huaweiId']);
}
} else {
echo "未取到数据1";
}
//计算数组长度
$countUser = count($countUserArr);
if ($peopleNum > $countUser) {
//用countUser
$Num = $countUser;
} else {
//用peopleNum
$Num = $peopleNum;
$defaultLottery = 0;
//入参检查$userid,$username,$weixinNo
if ($username == "undefined" || $userid == "undefined" || $weixinNo == "undefined" || $username == "" || $userid == "") {
//跳到失败页面
$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}");
}
} else {
}
//当输入工号时
if (!empty($userid)) {
//先判断是否已经签过到了
$sql = "SELECT * FROM " . $tablename . " WHERE huaweiId= '" . $userid . "'";
//$sql = "SELECT * FROM ".$tablename." WHERE huaweiId= '".$userid."' AND name='".$username."' AND weixinId='".$weixinNo."'";
$res = $dbModel->selectFromTable($sql);
while ($row = mysql_fetch_assoc($res)) {
$result = $row['huaweiId'];
}
if ($result !== NULL) {
//已经签过到了，不再插入，提示页面
$url = "http://demo-firstlab.huawei.com:8081/Registration/pcController/manage_Console/taskController/tasks/task_button_events/handleRegisAgain.html?name=" . $username;
if (isset($url)) {
Header("Location: {$url}");
}
} else {
//未签到,判断账号是否存在于总表中
/*
$selectFromAll = "SELECT huaweiId FROM wxuserlist WHERE huaweiId=".$userid;
$selectFromAllRes = $dbModel->selectFromTable($selectFromAll);
if(!empty($selectFromAllRes)){
<?php
/**
* Created by PhpStorm.
* User: ppmacs
* Date: 2016/1/8
* Time: 15:08
*/
set_time_limit(0);
header('Content-Type:text/html;charset=utf-8 ');
//设置URL编码头信息
require '../../../../../Model/dbModel.php';
$weixinNo = trim($_GET['weixinNo']);
//get weixinNo
$dbModel = new dbModel();
$guessArr = array();
$selectWxNo = "SELECT * FROM wxuserlist WHERE weixinId='" . $weixinNo . "'";
$selectWxNoRes = $dbModel->selectFromTable($selectWxNo);
if (!empty($selectWxNoRes)) {
while ($row = mysql_fetch_assoc($selectWxNoRes)) {
array_push($guessArr, $row['name']);
array_push($guessArr, $row['huaweiId']);
}
} else {
echo "no data";
}
$guessJson = json_encode($guessArr);
echo $guessJson;
<?php
/**
* Created by PhpStorm.
* User: ppmacs
* Date: 2016/1/8
* Time: 15:31
*/
set_time_limit(0);
header('Content-Type:text/html;charset=utf-8 ');
//设置URL编码头信息
require '../../../../../Model/dbModel.php';
$userName = trim($_GET['nameHuawei']);
$dbModel = new dbModel();
$guessArr = array();
$selectName = "SELECT * FROM wxuserlist WHERE name='" . $userName . "'";
$selectNameRes = $dbModel->selectFromTable($selectName);
if (!empty($selectNameRes)) {
while ($row = mysql_fetch_assoc($selectNameRes)) {
array_push($guessArr, $row['weixinId']);
array_push($guessArr, $row['huaweiId']);
}
} else {
echo "no data";
}
$guessJson = json_encode($guessArr);
echo $guessJson;
$gender = $noToGender[$genderId];
$statusId = $userInfo['status'];
$status = $noToStatus[$statusId];
$huaweiId = $userInfo['extattr']['attrs'][0]['value'];
$defaultRegisStatus = 1;
$defaultLottery = 0;
$regis_time_id = time();
//生成时间戳
$create_time = date('Y-m-d H:i:s', $regis_time_id);
$dbModel = new dbModel();
$table_id = $_GET['taskId'];
//从URL中取出数据表ID
$tableName = "task_regis_" . $table_id;
//根据$task_id获得任务名******************************
$selectTaskName = "SELECT task_name FROM task_regis WHERE id=" . $table_id;
$selectTaskRes = $dbModel->selectFromTable($selectTaskName);
if (!empty($selectTaskRes)) {
while ($row = mysql_fetch_assoc($selectTaskRes)) {
$task_name = $row['task_name'];
}
}
//**************************************************
//查找出数据库中最近的5位签到人***************************
$regisUser = array();
$selectRegis = "SELECT avatar FROM " . $tableName . " ORDER BY regisTime DESC LIMIT 5";
$selectRegisRes = $dbModel->selectFromTable($selectRegis);
if (!empty($selectRegisRes)) {
while ($row = mysql_fetch_assoc($selectRegisRes)) {
array_push($regisUser, $row['avatar']);
}
}
