/**
* @param $table
* @param $column
* @param null $where
* @return int
*/
public function max($table, $column, $where = NULL)
{
if (empty($this->_reader)) {
return $this->_writer->max($table, $column, $where);
} else {
return $this->_reader->max($table, $column, $where);
}
}
//todo,改变meting表中会议状态validity
// todo,inform 中增加一项
//todo，1,attendence中检索meeting id，2,对应状态state设置为0 无效，3,对应user id写成新的notice，4,并将user表中的mes改为当前inform_id
$mid = $_POST['id'];
session_start();
$id = $_SESSION['uid'];
include '../../parameter/Medoo/Resource/medoo.php';
//meeting
$db = new medoo('meetingmanage');
$db->update('meeting', array('VALIDITY' => 1), array('MEETING_ID' => $mid));
//
////inform
$re = $db->select('inform', 'CONTENT', array('MEETING_ID' => 40002));
$content = $re[0];
$new_mes = "注意：关于【" . $content . "】的会议已经取消，请您确认信息！";
$iid = $db->max('inform', 'INFORM_ID');
$iid += 1;
$date = date("Y/m/d");
$db->insert("inform", array('INFORM_ID' => $iid, 'USER_ID' => $id, 'DATE' => $date, 'CONTENT' => $new_mes, 'MEETING_ID' => $mid));
//attendence
//获得user列表
$users = $db->select('attendence', 'USER_ID', array('MEETING_ID' => 40000));
//跟新参会状态
$db->update('attendence', array('STATE' => 0), array('MEETING_ID' => $mid));
//notice & user
$num = count($users);
$nid = $db->max('notice', 'NOTICE_ID');
$nid += 1;
for ($i = 0; $i < $num; $i++) {
$db->insert('notice', array('NOTICE_ID' => $nid, 'USER_ID' => $users[$i], 'INFORM_ID' => $iid, 'STATE' => 0));
$db->update('user', array('MES' => $iid), array('USER_ID' => $users[$i]));
<?php
/**
* Created by PhpStorm.
* User: KeenSting
* Date: 2015/7/8
* Time: 12:30
*/
include './parameter/Medoo/Resource/medoo.php';
$num = $_POST['num'];
$space = $_POST['space'];
$ppt = $_POST['ppt'];
$mic = $_POST['mic'];
$board = $_POST['board'];
$mydb = new medoo('meetingmanage');
$id = $mydb->max('rooms', 'ROOM_ID');
$mydb->insert('rooms', array('ROOM_ID' => $id + 1, 'NUM' => $num, 'SPACE' => $space, 'ONE1' => 0, 'ONE2' => 0, 'ONE3' => 0, 'ONE4' => 0, 'ONE5' => 0, 'ONE6' => 0, 'TWO1' => 0, 'TWO2' => 0, 'TWO3' => 0, 'TWO4' => 0, 'TWO5' => 0, 'TWO6' => 0, 'THREE1' => 0, 'THREE2' => 0, 'THREE3' => 0, 'THREE4' => 0, 'THREE5' => 0, 'THREE6' => 0, 'MIC' => $mic, 'PPT' => $ppt, 'BOARD' => $board, 'STATE' => 1));
?>
<html>
<head>
</head>
<body style="background-color: #ffffff;">
<script>
alert('新的会议室已添加！');
</script>
</body>
<meta http-equiv="refresh" content="1;url='./meetingroom.php'">
</html>
/**
* Created by PhpStorm.
* User: KeenSting
* Date: 2015/7/8
* Time: 11:53
*/
require_once './parameter/Medoo/Resource/medoo.php';
$name = $_POST['name'];
$sex = $_POST['sex'];
$dep = $_POST['depart'];
$pos = $_POST['position'];
$tel = $_POST['tel'];
$mail = $_POST['mail'];
$mydb = new medoo('meetingmanage');
$id = $mydb->max('user', 'USER_ID');
$mydb->insert('user', array('USER_ID' => $id + 1, 'EMAIL' => $mail, 'PHONE' => $tel, 'NAME' => $tel, 'REAL_NAME' => $name, 'PWD' => $tel, 'IDENTY' => $pos, 'HEAD_IMG' => './assert/user/headimg/4.jpg', 'SEX' => $sex, 'DEPART_ID' => $dep, 'STATE' => 1, 'MES' => 0));
?>
<html>
<head>
</head>
<body>
<script>
alert('员工信息已添加，手机号即为登录账号和密码！');
</script>
</body>
<meta http-equiv="refresh" content="1;url='./addperson.php'">
</html>
<?php
ini_set('odbc.defaultlrl', '1024000');
require 'conf.php';
for ($i = 0; $i <= 200; $i++) {
$newmysqldb = new medoo(['server' => '127.0.0.1', 'username' => 'root', 'password' => '', 'database_name' => 'lianchuangcms', 'port' => 3306]);
$maxid = $newmysqldb->max('news', 'id');
$maxid == false && ($maxid = 0);
//文章表
$sql = 'SELECT TOP(5000) ID,ClassID,Title,keyword,OrderID,Attribute,UserID,CreateDate,UpdateDate,CONVERT(text,Content) as Content,DefaultPic,FromWeb,filename FROM Word where ID >' . $maxid . ' ORDER BY ID ASC';
$exec = odbc_exec($mssqldb, $sql);
while ($row = odbc_fetch_array($exec)) {
$content = trim(mb_convert_encoding(trim($row['Content']), "UTF-8", "GBK"));
$insertid = $newmysqldb->insert('news', ['id' => str_replace('.0', '', $row['ID']), 'catid' => str_replace('.0', '', $row['ClassID']), 'title' => trim(str_replace(" ", '', remove_nbsp(mb_convert_encoding($row['Title'], "UTF-8", "GBK")))), 'keywords' => trim(remove_nbsp(mb_convert_encoding($row['keyword'], "UTF-8", "GBK"))), 'description' => trim(str_replace(" ", '', remove_nbsp(mb_substr(strip_tags($content), 0, 78, 'UTF-8')))), 'listorder' => str_replace('.0', '', $row['OrderID']), 'attribute' => intval($row['Attribute']), 'uid' => str_replace('.0', '', $row['UserID']), 'username' => '', 'url' => '', 'islink' => 0, 'inputtime' => strtotime($row['CreateDate']), 'updatetime' => strtotime($row['UpdateDate']), 'status' => 99]);
$newmysqldb->insert('news_data', ['id' => str_replace('.0', '', $row['ID']), 'content' => addslashes(stripslashes($content)), 'defaultpic' => $row['DefaultPic'], 'fromweb' => $row['FromWeb'], 'filename' => $row['filename']]);
echo 'insert article success id is ' . $row['ID'] . PHP_EOL;
}
}
function remove_nbsp($str)
{
$str = mb_ereg_replace('^( | )+', '', $str);
$str = mb_ereg_replace('( | )+$', '', $str);
$str = mb_ereg_replace(' ', "\n ", $str);
$order = array("\r\n", "\n", "\r");
$replace = '<br/>';
$str = str_replace($order, $replace, $str);
return $str;
}
} else {
if (file_exists("assert/docs/" . $_FILES["file"]["name"])) {
echo $_FILES["file"]["name"] . " already exists. ";
} else {
$name = $_FILES['file']['name'];
$path = "./assert/docs/" . $_FILES["file"]["name"];
move_uploaded_file($_FILES["file"]["tmp_name"], "assert/docs/" . $_FILES["file"]["name"]);
}
}
//}
//else{
// echo "文件不合法！";
//}
$type = $_POST['type'];
$db = new medoo('meetingmanage');
$did = $db->max('docspace', 'DOC_ID');
$did += 1;
$db->insert('docspace', array('DOC_ID' => $did, 'MEETING_ID' => $mid, 'TYPE' => $type, 'DATE' => date("Y/m/d"), 'PATH' => $path, 'NAME' => $name));
?>
<html>
<head>
</head>
<body style="background:#ffffff">
<script type="text/javascript">
alert('文件上传成功！')
</script>
<meta http-equiv="refresh" content="100;url='./mymeeting.php'"/>
</body>
return true;
}
}
</script>
<?php
include './parameter/Medoo/Resource/medoo.php';
$name = '';
$describe = '';
$phone = '';
if (!$_POST) {
} else {
$db = new medoo('meetingmanage');
$name = $_POST['name'];
$phone = $_POST['phone'];
$describe = $_POST['info'];
$did = $db->max('departs', 'DEPART_ID');
$did += 1;
//depart id
$db->insert('departs', array('DEPART_ID' => $did, 'NAME' => $name, 'PHONE' => $phone, 'INSTRUCTION' => $describe));
?>
<script>
alert("添加成功！");
document.location.href='./addDepart.php';
</script>
<?php
}
?>
</head>
<body>
<div class="container">
<div class="page-header">
/**
* Controlla se l'utente è inserito in una classe
*
* @param medoo $database Connessione con il database
* @param int $user Identificativo dell'utente da considerare
* @return boolean
*/
function classe($database, $user)
{
return $database->count("studenti", array("AND" => array("id" => $database->max("studenti", "id"), "persona" => $user))) != 0;
}
