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 "录入失败";
}
}
}
public function getTotalPages($pageSize = "")
{
$sum = parent::selectTaskCount();
//计算页数
$total_pages = ceil($sum / $pageSize);
//向上取1
return $total_pages;
}
public function insertBPData()
{
//create the sql query
$sql = "INSERT INTO log_bodymetrics (created, user, metric_id, metric_value) values (CURRENT_TIMESTAMP, " . $this->user . ",2,'" . $this->jsonData . "')";
parent::__construct();
parent::execQuery($sql, false);
return true;
}
function __construct(\MongoCollection $shiftCollection)
{
if (!$shiftCollection instanceof \MongoCollection) {
throw new userModelException('mongo collection is required!');
}
parent::__construct($shiftCollection);
$this->setCollection($shiftCollection);
}
public function __construct()
{
parent::__construct();
global $settings;
$this->settings = $settings;
$this->wp_config = $this->get_wp_config();
$this->wp_config_array = $this->get_wp_config_array();
$this->default_themes = array('twentyfifteen' => 'Twenty Fifteen', 'twentyfourteen' => 'Twenty Fourteen', 'twentythirteen' => 'Twenty Thirteen', 'twentytwelve' => 'Twenty Twelve');
// $this->helpers = new DashboardHelpers;
}
public function returnAllData($whatData)
{
//try to find a match for the SQL we want to retrieve.
$sql = parent::getSQL($whatData);
$result = parent::execQuery($sql, true);
if (!$result) {
echo "There was an issue executing your query to return all metrics";
exit;
} else {
$strBuffer = "<ul>";
//let's package the data for consumption
for ($i = 0; $i < sizeof($result); $i++) {
$strBuffer .= "<li>" . $result[$i]['note'] . "</li>";
}
$strBuffer .= "</ul>";
}
return $strBuffer;
}
* User: ppmacs
* Date: 2015/12/31
* Time: 15:29
*/
set_time_limit(0);
header('Content-Type:text/html;charset=utf-8 ');
//设置URL编码头信息
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";
}
//计算数组长度
* User: ppmacs
* Date: 2015/12/24
* Time: 17:03
*/
set_time_limit(0);
header('Content-Type:text/html;charset=utf-8 ');
//设置URL编码头信息
require '../../../../../Model/dbModel.php';
//获取参数
$tablename = trim($_GET['tablename']);
$username = trim($_GET['name']);
$userid = trim($_GET['ID']);
$weixinNo = trim($_GET['weixinNo']);
//$userid = "100575";
//$tablename = "dalanqiuqiandao_1450864578_user";
$dbModel = new dbModel();
$selectArr = array();
$regisStatus = 1;
$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)) {
//先判断是否已经签过到了
<?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;
function __construct(\MongoCollection $tokenCollection)
{
parent::__construct($tokenCollection);
$this->setCollection($tokenCollection);
}
public function getAllCount()
{
$sum = parent::selectCount();
return $sum;
}
* User: ppmacs
* Date: 2015/12/23
* Time: 23:52
*/
set_time_limit(0);
header('Content-Type:text/html;charset=utf-8 ');
//设置URL编码头信息
require '../../../../../Model/dbModel.php';
require 'PHPExcel/PHPExcel.php';
$noToRegisStatus = array('0' => '未签到', '1' => '已签到');
//获取get方法传来的id
$tableName = $_GET['q1'];
$taskName = $_GET['q2'];
//$tableName = 'dalanqiuqiandao_1450864578_user';
//$taskName = '打篮球签到';
$dbModel = new dbModel();
$objPHPExcel = new PHPExcel();
//新建一个excel
$objPHPExcel->setActiveSheetIndex(0);
$objSheet = $objPHPExcel->getActiveSheet();
//获取当前活动sheet
$objSheet->setTitle($taskName);
//给当前活动sheet设置名称
//set width
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(15);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(10);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(12);
if(isset($_POST['username'])){
$userName = $_POST['username'];
}else{
$userName = null;
}
if(isset($_POST['huaweiId'])){
$huaweiId = $_POST['huaweiId'];
}else{
$huaweiId = null;
}
*/
//获取表名
$tableName = $_POST['name'];
$start = $_POST['userNum'];
//$tableName = "task_regis_1451034019";
$dbModel = new dbModel();
//查询数据条数
$selectCount = "SELECT COUNT(*) FROM " . $tableName;
$total = $dbModel->selectEachCount($selectCount);
$offSet = $total - $start;
//计算偏移量
$defaultStart = $total - 5;
$userArr = array();
if ($start == $total) {
//数据库已无数据
echo "";
} else {
if ($offSet > 5) {
//从表中取出最近的用户信息
$selectSql = "SELECT * FROM " . $tableName . " ORDER BY regisTime asc LIMIT " . $defaultStart . ",1";
$selectRes = $dbModel->selectFromTable($selectSql);
//die('<p style="color:red">Error: </p>'.$ex);
return false;
}
}
function add_condition($field, $value = '', $options = array('condition' => 'AND', 'operator' => '=', 'equal' => true))
{
if (empty($this->condition)) {
$this->condition = ' WHERE ';
} else {
$this->condition .= ' ' . $options['condition'] . ' ';
}
if ($options['operator'] == 'LIKE' && $options['equal'] == false) {
$value = '%' . $value . '%';
}
$this->condition .= $field . $options['operator'] . "'" . $value . "'";
// $this->condition.= $field . ' ' .
}
function get_operator($type = 'integer')
{
if ($type == 'integer') {
}
}
function check_type($field)
{
if (isset($field)) {
}
}
}
global $dbModel;
$dbModel = new dbModel();
$dbModel->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$userName = $userInfo['name'];
$weixinNo = $userInfo['weixinid'];
$departmentId = $userInfo['department'][0];
$department = $noToDepartment[$departmentId];
$avatar = $userInfo['avatar'];
$genderId = $userInfo['gender'];
$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";
<?php
include '../Model/dbModel.php';
$obj = new dbModel();
$result = $obj->getDataHostelModel1();
while ($row = mysqli_fetch_assoc($result)) {
echo $row['hostelname'] . "<br>";
}
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";
}
//获取全局唯一凭据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'];
$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];
<?php
/**
* Created by PhpStorm.
* 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)) {
<?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;
<?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;
public function getSum($tableName = "")
{
$sqlCount = "SELECT COUNT(*) FROM " . $tableName;
$sum = parent::selectEachCount($sqlCount);
return $sum;
}
