/**
* 获取书籍
* 初始化方式的
*/
public function getBookList($page, $language, $word)
{
require_once '../../conndb/mysql/ConnMysqlClass.php';
require_once '../../user/dao/UserDao.php';
//定义每页10本
$pageSize = 30;
//如果是0页或者没有赋值那么默认给第一页
if ("" == $page || 0 == $page) {
$page = 1;
}
$page_start = ($page - 1) * $pageSize;
$userDao = new UserDao();
$conn = ConnMysqlClass::getConnMysql();
mysql_select_db(ConnMysqlClass::getDBName(), $conn);
$str_sql = "";
//如果language不等于空，那么就加上这个条件
if ("" != $language) {
$str_sql = "select * from stack_resource_book where resource_book_language = '{$language}' order by resource_book_id desc limit {$page_start},{$pageSize} ";
} else {
if ("" != $word) {
$str_sql = "select * from stack_resource_book where resource_book_name like '%{$word}%' order by resource_book_id desc limit {$page_start},{$pageSize} ";
} else {
$str_sql = "select * from stack_resource_book order by resource_book_id desc limit {$page_start},{$pageSize} ";
//0 1,3 4
}
}
$result = mysql_query($str_sql);
$arrBooks = array();
$var = 0;
while ($row = mysql_fetch_array($result)) {
$arrBooks[$var++] = array('page' => $page, 'resource_book_name' => $row['resource_book_name'], 'resource_book_size' => $row['resource_book_size'], 'resource_book_level' => $row['resource_book_level'], 'resource_book_review' => $row['resource_book_review'], 'resource_book_word' => $row['resource_book_word'], 'resource_book_date' => $row['resource_book_date'], 'user_name' => $userDao->getUserById($row['fk_user_id']), 'resource_book_url' => $row['resource_book_url']);
}
mysql_close($conn);
return $arrBooks;
}
public function DBAccessAction()
{
$userDao = new UserDao();
$result = $userDao->getUserByLogin('root');
$this->setViewVar('result', $result);
$this->render();
}
private function userHomeSanityCheck(BackendSystem $backend_system)
{
$dao = new UserDao();
$users = $dao->searchByStatus(array(PFUser::STATUS_ACTIVE, PFUser::STATUS_RESTRICTED))->instanciateWith(array(UserManager::instance(), 'getUserInstanceFromRow'));
foreach ($users as $user) {
$backend_system->userHomeSanityCheck($user);
}
}
public static function validate(User $user)
{
$errors = array();
$dao = new UserDao();
if (!$dao->emailPasswordCheck($user)) {
$errors[] = new Error('Error', 'either your email or password is not valid.');
}
return $errors;
}
/**
* Get policy.
*
* @param UserDao $user
* @param ItemDao $item
* @return false|ItempolicyuserDao
* @throws Zend_Exception
*/
public function getPolicy($user, $item)
{
if (!$user instanceof UserDao) {
throw new Zend_Exception('Should be a user.');
}
if (!$item instanceof ItemDao) {
throw new Zend_Exception('Should be an item.');
}
return $this->initDao('Itempolicyuser', $this->database->fetchRow($this->database->select()->where('item_id = ?', $item->getKey())->where('user_id = ?', $user->getKey())));
}
function testSuspendAccountDao()
{
$dar = new MockDataAccessResult($this);
$dar->setReturnValue('isError', false);
$da = new MockDataAccess($this);
$da->expectOnce('query', array('UPDATE user SET status = "S", unix_status = "S" WHERE toto', '*'));
$da->setReturnValue('query', $dar);
$dao = new UserDao($da);
$d2 = $dao->suspendAccount('toto');
}
public function index()
{
$title = $GLOBALS['Language']->getText('admin_main', 'configure_access_controls');
$params = array('title' => $title);
$renderer = TemplateRendererFactory::build()->getRenderer($this->getTemplateDir());
$this->response->includeFooterJavascriptFile('/scripts/tuleap/admin-access-mode.js');
$this->response->header($params);
$renderer->renderToPage(self::TEMPLATE, new ForgeAccess_AdminPresenter($this->csrf, $title, $this->localincfinder->getLocalIncPath(), ForgeConfig::get(ForgeAccess::CONFIG), count($this->user_dao->searchByStatus(PFUser::STATUS_RESTRICTED)), ForgeConfig::get(User_ForgeUGroup::CONFIG_AUTHENTICATED_LABEL), ForgeConfig::get(User_ForgeUGroup::CONFIG_REGISTERED_LABEL), ForgeConfig::get(ForgeAccess::PROJECT_ADMIN_CAN_CHOOSE_VISIBILITY), ForgeConfig::get(ForgeAccess::REVERSE_PROXY_REGEXP)));
$this->response->footer($params);
}
/**
* Get policy.
*
* @param UserDao $user
* @param FolderDao $folder
* @return false|FolderpolicyuserDao
* @throws Zend_Exception
*/
public function getPolicy($user, $folder)
{
if (!$user instanceof UserDao) {
throw new Zend_Exception('Should be a user.');
}
if (!$folder instanceof FolderDao) {
throw new Zend_Exception('Should be a folder.');
}
return $this->initDao('Folderpolicyuser', $this->database->fetchRow($this->database->select()->where('folder_id = ?', $folder->getKey())->where('user_id = ?', $user->getKey())));
}
/**
* Return all client records owned by the given user.
*
* @param UserDao $userDao
* @return array
*/
public function getByUser($userDao)
{
$sql = $this->database->select()->setIntegrityCheck(false)->where('owner_id = ?', $userDao->getKey());
$rows = $this->database->fetchAll($sql);
$daos = array();
foreach ($rows as $row) {
$daos[] = $this->initDao('Client', $row, $this->moduleName);
}
return $daos;
}
/**
* Create a temporary token that will be used to fetch the user's real API token later.
*
* @param UserDao $user user to create the token for
* @param TokenDao $tokenDao token DAO
* @return Mfa_ApitokenDao
* @throws Zend_Exception
*/
public function createTempToken($user, $tokenDao)
{
/** @var Mfa_ApitokenDao $newToken */
$newToken = MidasLoader::newDao('ApitokenDao', 'mfa');
$newToken->setUserId($user->getKey());
$newToken->setTokenId($tokenDao->getKey());
$newToken->setCreationDate(date('Y-m-d H:i:s'));
$this->save($newToken);
return $newToken;
}
public function checkphone()
{
$phone = $_POST['phone'];
$UserDao = new UserDao();
$user = $UserDao->getByPhone($phone);
if ($user) {
echo "{\"msg\":\"no\"}";
} else {
echo "{\"msg\":\"ok\"}";
}
}
/**
* Returns the LDAP user corresponding to the core user, or false if the
* user is not an LDAP user.
*
* @param UserDao $userDao core user
* @return false|Ldap_UserDao
* @throws Zend_Exception
*/
public function getByUser($userDao)
{
$sql = $this->database->select()->where('user_id = ?', $userDao->getKey());
$row = $this->database->fetchRow($sql);
$dao = $this->initDao('User', $row, 'ldap');
if ($dao) {
return $dao;
} else {
return false;
}
}
/**
* Export user list in csv format
*
* @param String $user_name_search
* @param String $current_sort_header
* @param String $sort_order
*
*/
public function exportUserList($user_name_search, $current_sort_header, $sort_order, $status_values)
{
global $Language;
header('Content-Type: text/csv');
header('Content-Disposition:attachment; filename=users_list.csv');
$eol = "\n";
$documents_title = array('user_id' => $Language->getText('admin_userlist', 'id_user'), 'login_name' => $Language->getText('include_user_home', 'login_name'), 'real_name' => $Language->getText('include_user_home', 'real_name'), 'member_of' => $Language->getText('admin_userlist', 'member_of'), 'admin_of' => $Language->getText('admin_userlist', 'admin_of'), 'status' => $Language->getText('admin_userlist', 'status'));
echo build_csv_header($this->col_list, $documents_title) . $eol;
$dao = new UserDao(CodendiDataAccess::instance());
$result = $dao->listAllUsers($user_name_search, 0, 0, $current_sort_header, $sort_order, $status_values);
$users = $result['users'];
echo $this->buildCsvBody($users);
}
public function newPassword(User $user)
{
$newPassword = $this->generateNewPassword();
$newUser = $this->dao->updatePassword($user, $newPassword);
if ($newUser != null) {
$emailController = new EmailController();
if (!$emailController->sendNewPasswordEmail($newUser, $newPassword)) {
throw new Exception("Falha ao enviar email com a nova senha!");
}
return true;
}
throw new Exception("Os dados informados não existem no sistema");
}
/**
* 根据信息查询链接
*
* @param 分页页数 $page
* @param 资源类别 $category
* @param 语言类别 $language
* @param 检索关键字 $word
*/
public function getLinkList($page, $category, $language, $word)
{
require_once '../../conndb/mysql/ConnMysqlClass.php';
require_once '../../user/dao/UserDao.php';
//定义每页的条数
$pageCount = 30;
//如果是0页或者没有赋值那么默认给第一页
if ("" == $page || 0 == $page) {
$page = 1;
}
//分页数据
$page_start = ($page - 1) * $pageCount;
//根据用户id查询用户名
$userDao = new UserDao();
$conn = ConnMysqlClass::getConnMysql();
mysql_select_db(ConnMysqlClass::getDBName(), $conn);
$str_sql = "select fk_user_id,fk_category_sort_name,fk_language_sort_name,resource_link_name,resource_link_url,resource_link_content,resource_link_data,resource_link_statue from stack_resource_link where fk_category_sort_name = '{$category}' ";
$str_sql_count = "select count(resource_link_id) from stack_resource_link where fk_category_sort_name = '{$category}' ";
//组合sql语句
if ("" != $language && "" == $word) {
$str_sql .= "and fk_language_sort_name = '{$language}' ";
$str_sql_count .= "and fk_language_sort_name = '{$language}' ";
} else {
if ("" == $language && "" != $word) {
$str_sql .= "and resource_link_name like '%{$word}%' or resource_link_content like '%{$word}%' ";
$str_sql_count = "and resource_link_name like '%{$word}%' or resource_link_content like '%{$word}%' ";
} else {
if ("" != $language && "" != $word) {
$str_sql .= "and fk_language_sort_name = '{$language}' and resource_link_name like '%{$word}%' or resource_link_content like '%{$word}%' ";
$str_sql_count = "and fk_language_sort_name = '{$language}' and resource_link_name like '%{$word}%' or resource_link_content like '%{$word}%' ";
}
}
}
$str_sql .= "order by resource_link_id desc limit {$page_start},{$pageCount}";
$result = mysql_query($str_sql);
$arrLinks = array();
$var = 0;
while ($row = mysql_fetch_array($result)) {
$arrLinks[$var++] = array("fk_user_id" => $row['fk_user_id'], "user_name" => $userDao->getUserById($row['fk_user_id']), "fk_category_sort_name" => $row['fk_category_sort_name'], "fk_language_sort_name" => $row['fk_language_sort_name'], "resource_link_name" => $row['resource_link_name'], "resource_link_url" => $row['resource_link_url'], "resource_link_content" => $row['resource_link_content'], "resource_link_data" => $row['resource_link_data']);
}
//查询数量能分出来多少页
$result = mysql_query($str_sql_count);
$row = mysql_fetch_array($result);
//获得分页
$pageNum = ceil($row[0] / $pageCount);
$arrLinks['pageSum'] = strval($pageNum);
//关闭数据库
mysql_close($conn);
return $arrLinks;
}
public function postAction()
{
$password = $this->getRequest()->getPost('password');
$username = $this->getRequest()->getPost('username');
if (!empty($password) && !empty($username)) {
$user_dao = new UserDao();
if ($user_dao->login($username, $password)) {
Yaf\Session::getInstance()->start();
Yaf\Session::getInstance()->set('is_admin', $user_dao->getIsAdmin());
$this->redirect('/');
} else {
$this->redirect('/login');
}
}
}
/**
* @param <type> $username
* @param <type> $password
* @return boolean
*/
public function login($username, $password)
{
$user = new User(null, $username, $password);
$user = $this->userDao->get($user);
if ($user != null) {
Session::login($user);
setcookie('Bureau_PosicaoApps', '', time() - 3600);
//setcookie('Bureau_PosicaoApps', "publicacoes|noticias|videoteca", time() + 3600);
setcookie('Bureau_PosicaoApps', $user->getPositions(), time() + 3600);
setcookie('Bureau_AppsMinimizados', "0", Config::get('tempo_vida_cookie'));
setcookie('logged', '1', time() + 10);
return true;
}
return false;
}
function supprimer_admin($params)
{
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$deleteProjects = $_POST['check'];
$userDao = new UserDao(new User());
$list = $userDao->read($deleteProjects);
$list->setIs_admin(0);
$userDao = new UserDao($list);
$userDao->update($deleteProjects);
$this->redirect('admin/administrateur');
}
$userDao = new UserDao(new User());
$list = $userDao->read($params);
$this->set(array("user" => $list));
$this->render('supprimer_admin');
}
public function isMobileExists($mobile)
{
$condition['where']['expression'] = "mobile = :mobile";
$condition['where']['value']['mobile'] = $mobile;
$tmp = $this->userDao->selectByCondition($condition);
return $tmp ? true : false;
}
public function login(&$testParam)
{
// //新建两个观察者
// $ob1 = new identityObserver;
// $ob2 = new logObserver;
//
// //为当前方法添加观察者
// $this -> addObserver(__METHOD__, $ob1);
// $this -> addObserver(__METHOD__, $ob2);
//
// //通知观察者，并且传递参数
// $this -> notifyObserver('login', 'UserModule\'s login function work!');
// $dao = getDatabase();
$dao = new UserDao();
return $dao->login($testParam);
}
public function handleForm(Context $context, $action)
{
if ($action == "createReservation") {
if (isset($_POST['equip_id']) && $_POST['equip_id'] != "" && (isset($_POST['start_date']) && $_POST['start_date'] != "") && (isset($_POST['length']) && $_POST['length'] != "")) {
$equipId = $_POST['equip_id'];
$equip = EquipmentDao::getEquipmentByID($equipId);
if ($equip != null) {
if (SessionUtil::getUserlevel() >= $equip->minUserLevel) {
$startDate = $_POST['start_date'];
$endDate = DateUtil::incrementDate($startDate, $_POST['length']);
$reservations = ReservationDao::getReservationsForEquipmentByDate($equipId, $startDate, $endDate);
if (count($reservations) == 0) {
$user = UserDao::getUserByUsername(SessionUtil::getUsername());
$reservation = ReservationDao::createReservation($user->id, $equipId, $_POST['length'], $startDate, $endDate, $_POST['user_comment']);
EmailUtil::sendNewReservationNotices($user, $reservation);
} else {
$context->addError("Reservations already exist during selected dates ({$startDate} and {$endDate}).");
}
} else {
$context->addError("Cannot reserve equipment (User Level).");
}
} else {
$context->addError("No such equipment.");
}
} else {
$context->addError("Required Field Left Blank.");
}
} else {
$context->addError("Incorrect Action.");
}
}
public function handleForm(Context $context, $action)
{
//TODO: Check user level >= ADMIN
if ($action == "savePassword") {
if (isset($_POST['newpass']) && $_POST['newpass'] != "" && (isset($_POST['confpass']) && $_POST['confpass'] != "")) {
$newPassword = $_POST['newpass'];
$confirmPassword = $_POST['confpass'];
if ($newPassword = $confirmPassword) {
UserDao::updateUserPassword($_POST['userid'], $newPassword);
$context->addMessage("Password Successfully Changed.");
} else {
$context->addError("Passwords Don't Match.");
}
} else {
$context->addError("Required Field Left Blank.");
}
} else {
if ($action == "saveEmail") {
if (isset($_POST['email']) && $_POST['email'] != "") {
$email = $_POST['email'];
UserDao::updateUserEmail($_POST['userid'], $email);
$context->addMessage("Email Successfully Changed.");
} else {
$context->addError("Required Field Left Blank.");
}
} else {
if ($action == "saveUserLevel") {
if (isset($_POST['level']) && $_POST['level'] != "") {
$userlevel = $_POST['level'];
UserDao::updateUserLevel($_POST['userid'], $userlevel);
$context->addMessage("User Level Successfully Changed.");
} else {
$context->addError("Required Field Left Blank.");
}
} else {
if ($action == "saveNotes") {
if (isset($_POST['notes']) && $_POST['notes'] != "") {
$notes = $_POST['notes'];
UserDao::updateUserNotes($_POST['userid'], $notes);
$context->addMessage("Notes Successfully Changed.");
} else {
$context->addError("Required Field Left Blank.");
}
} else {
if ($action == "saveName") {
if (isset($_POST['name']) && $_POST['name'] != "") {
$name = $_POST['name'];
UserDao::updateName($_POST['userid'], $name);
$context->addMessage("Name Successfully Changed.");
} else {
$context->addError("Required Field Left Blank.");
}
} else {
$context->addError("Incorrect Action.");
}
}
}
}
}
}
public static function updateReservationStatus($resId, $status, $sendEmail)
{
Database::doQuery("UPDATE " . Database::addPrefix(ReservationDao::table_name) . " SET mod_status = '" . Database::makeStringSafe($status) . "'" . " WHERE res_id = '" . Database::makeStringSafe($resId) . "'");
if ($sendEmail) {
$reservation = ReservationDao::getReservation($resId);
$user = UserDao::getUserByID($reservation->userId);
EmailUtil::sendUpdateReservationNotice($user, $reservation);
}
}
/**
* Create a task.
*
* @param UserDao $userDao
* @param string $tmpWorkDirRoot
* @return Batchmake_TaskDao
* @throws Zend_Exception
*/
public function createTask($userDao, $tmpWorkDirRoot)
{
if (!$userDao instanceof UserDao) {
throw new Zend_Exception('Error parameters.');
}
/** @var Batchmake_TaskDao $task */
$task = MidasLoader::newDao('TaskDao', 'batchmake');
$task->setUserId($userDao->getKey());
$this->save($task);
$userId = $task->getUserId();
$taskId = $task->getKey();
$subdirs = array(MIDAS_BATCHMAKE_SSP_DIR, $userId, $taskId);
// create a workDir based on the task and user
$workDir = KWUtils::createSubDirectories($tmpWorkDirRoot . '/', $subdirs);
$task->setWorkDir($workDir);
$this->save($task);
return $task;
}
function generateHTML()
{
$user = UserDao::getUserByUsername(SessionUtil::getUsername());
$changePasswordRows = "";
if (Config::login_type == LOGIN_TYPE_DB) {
$changePasswordRows = "\n\t\t\t\n\t\t\t<tr>\n\t\t\t\t\n\t\t\t\t<td class=\"centeredcellbold\">Change Password</td>\n\t\t\t\t<td class=\"centeredcellbold\">Current Password</td>\n\t\t\t\t<td class=\"centeredcellbold\">New Password</td>\n\t\t\t\t<td class=\"centeredcellbold\">Confirm Password</td>\n\t\t\n\t\t\t</tr>\n\t\t\t\n\t\t\t<tr>\n\t\t\t\t\n\t\t\t\t\t<form action=\"./index.php?pageid=savepassword\" method=\"POST\"><td class=\"centeredcellbold\"><input type=\"submit\" value=\"Save Password\"></td>\n\t\t\t\t\t<td class=\"centeredcell\"><input type=\"password\" name=\"curpass\"></td>\n\t\t\t\t\t<td class=\"centeredcell\"><input type=\"password\" name=\"newpass\"></th>\n\t\t\t\t\t<td class=\"centeredcell\"><input type=\"password\" name=\"confpass\"></td></form>\n\t\t\t\n\t\t\t\t</tr>";
}
return "<center><h3>My Account</h3>" . $this->context->getErrorHTML() . "</center>\n\t\t\t\n\t\t\t<table class=\"myaccount\">\n\t\t\t\n\t\t\t\t<tr>\n\t\t\t\t\n\t\t\t\t\t<td colspan=4 class=\"header\">Edit User Information</td>\n\t\t\t\t\n\t\t\t\t</tr>\n\t\t\t\t\n\t\t\t\t<tr>\n\t\t\n\t\t\t\t\t<td class=\"centeredcellbold\">Username</td>\n\t\t\t\t\t<td colspan=3 class=\"centeredcell\">" . $user->username . "</td>\n\t\t\t\t\t\n\t\t\t\t</tr>\n\t\t\t\n\t\t\t\t<tr>\n\t\t\n\t\t\t\t\t<td class=\"centeredcellbold\">Name</th>\n\t\t\t\t\t<td colspan=3 class=\"centeredcell\">" . $user->name . "</td>\n\t\t\t\t\t\n\t\t\t\t</tr>\n\t\t\t\n\t\t\t\t" . $changePasswordRows . "\n\t\t\t\n\t\t\t\t<tr>\n\t\t\t\t\t\n\t\t\t\t\t<form action=\"./index.php?pageid=saveemail\" method=\"POST\">\n\t\t\t\t\t<td colspan=1 class=\"centeredcellbold\">Email</th><td colspan=3 class=\"centeredcell\"><input type=\"text\" name=\"email\" size=30 value=\"" . $user->email . "\"><input type=\"submit\" value=\"Save Email\"></td></form>\n\t\t\t\t\t\t\n\t\t\t\t</tr>\n\t\t\n\t\t\t\t<tr>\n\t\t\t\t\n\t\t\t\t\t<td colspan=1 class=\"centeredcellbold\">Warnings</th>\n\t\t\t\t\t<td class=\"centeredcellbold\" colspan=3><a href=\"./index.php?pageid=viewMyWarnings\">" . WarningDao::getWarningCountForUserByType($user->id, RES_WARNING_ACTIVE) . "(" . WarningDao::getWarningCountForUser($user->id) . ")</a></td>\n\t\t\t\t\n\t\t\t\t</tr>\n\t\t\t\t\t\n\t\t\t</table>";
}
public function generateHTML()
{
$users = UserDao::getAllUsersOrderByName();
$userOptions = "";
foreach ($users as $user) {
$userOptions = $userOptions . "<option value=\"" . $user->id . "\">" . $user->name . "</option>";
}
return "<center><h3>Manage Users</h3></center>\n\t<center><form action=\"index.php\" method=\"GET\"><input type=\"hidden\" name=\"pageid\" value=\"editUser\"><select name=\"userid\" size=10>\n\t" . $userOptions . "\n\t</select><br><input type=\"button\" value=\"Create User\" onClick=\"window.location = './index.php?pageid=createUser'\"><input type=\"submit\" value=\"Edit\"></form></center>";
}
public static function controleerGebruiker($email, $wachtwoord)
{
$user = UserDao::getByEmail($email);
if (isset($user) && $user->getWachtwoord() == $wachtwoord) {
return true;
} else {
return false;
}
}
public function modifyUser()
{
$username = $_POST['userName'];
$userLastName = $_POST['userLastName'];
$userPassword = $_POST['password'];
$passwordAgain = $_POST['rePassword'];
$userDao = new UserDao();
$userInfoDao = new UserInfoDao();
$uid = getUID();
$user = $userDao->selectUserById($uid);
$user->lastName = $userLastName;
$user->password = $userPassword;
$user->name = $username;
User::readProperties($user, $_POST);
$user->setInstitutionName($_POST['InstitutionName']);
$userDao->updateUser($user, $uid);
$userInfoDao->modifyUserInfo($id, $user);
}
public static function getUserGetId()
{
$id = null;
try {
$id = self::getUrlParam('id');
} catch (Exception $ex) {
throw new NotFoundException('No user identifier provided.');
}
if (!is_numeric($id)) {
throw new NotFoundException('Invalid user identifier provided.');
}
$dao = new UserDao();
$user = $dao->findById($id);
if ($user === null) {
throw new NotFoundException('Unknown user identifier provided.');
}
return $user;
}
/**
* Metodo Session::getUser()
* restituisce un oggetto user che ha avviato la sessione
*/
static function getUser($who_asks = "Anonimous")
{
if (isset($_SESSION["iduser"])) {
$userdao = new UserDao();
$user = $userdao->quickLoad($_SESSION["iduser"]);
if (!isset($_SESSION["getUser"])) {
$_SESSION["getUser"] = 1;
} else {
$_SESSION["getUser"]++;
}
if ($user != false) {
return $user;
} else {
return false;
}
} else {
return false;
}
}
