public function getId()
{
if ($this->__isInitialized__ === false) {
return (int) $this->_identifier["id"];
}
$this->__load();
return parent::getId();
}
public function addAction($reception = null)
{
$this->view->setVar("TopMenuSelected", 'work');
$this->view->setVar("MenuSelected", 'add');
$this->view->setVar("MenuItemActive", $reception);
if (!empty($reception)) {
$this->view->setVar("countries", References::getCountries());
$this->view->setVar("currency", References::getCurrency());
$this->view->setVar("units_1", References::getUnits(NULL, array(1))['units']);
$this->view->setVar("units_34", References::getUnits(NULL, array(3, 4))['units']);
$this->view->setVar("date_on_reception_default", date('d-m-Y H:i:s'));
$this->view->pick('/package/' . $reception);
View::addJs($this, ['/js/async/jquery.tmpl.min.js', '/js/async/scripts_package_add.js', '/js/async/jquery.mb.browser.js', '/js/async/jquery.mousewheel.js', '/js/async/calendar_date-time.js']);
View::addCss($this, ['/css/calendar_date-time.css']);
}
if ($this->request->isPost()) {
$post = $this->request->getPost();
$user_id = Users::getId($this);
$station_id = Users::getStationId($this);
$package_document = $post['cont_type'];
if ($package_document == '0') {
$pcp = $post['pack_cont_pl'];
$package_contents_places = array();
for ($i = 0; $i < count($pcp); $i++) {
$pcpa = $pcp[$i]['att'];
$package_contents_place_attachments = array();
for ($j = 0; $j < count($pcpa); $j++) {
$package_contents_place_attachments[] = array('description' => $pcpa[$j]['descr'], 'unit_count' => $pcpa[$j]['u_count'], 'units_id' => $pcpa[$j]['units'], 'unit_price' => $pcpa[$j]['price']);
}
$package_contents_places[] = array('length' => $pcp[$i]['length'], 'width' => $pcp[$i]['width'], 'height' => $pcp[$i]['height'], 'units_id' => $post['pack_cont_pl_units'], 'attachment' => $package_contents_place_attachments);
}
$time_arr = explode(' ', $post['date_on_reception']);
$date_arr = explode('-', $time_arr[0]);
$date_on_reception = $date_arr[2] . '-' . $date_arr[1] . '-' . $date_arr[0] . ' ' . $time_arr[1];
for ($i = 0; $i < count($post['package_rec_name']); $i++) {
for ($j = 0; $j < count($post['package_send_name']); $j++) {
$package_id = Package::addNotDocument($post['package_send_name'][$i], $post['package_send_addr'][$i], $post['package_send_country'][$i], $post['package_rec_name'][$j], $post['package_rec_addr'][$j], $post['package_rec_country'][$j], $station_id, $post['pack_cont_descr_nd'], $post['pack_cont_pl_count_nd'], $post['pack_cont_weight_nd'], $post['pack_cont_curr_nd'], $package_contents_places, $post['pack_cont_comm_nd'], 'null', 'null', $post['package_send_phone'][$i], $post['package_rec_phone'][$j], $post['package_guar'], $date_on_reception);
/**/
$res = Package::setStatus($package_id[0]['package_add_all_not_document'], 2, 'true', $user_id, 'null');
/**/
}
}
} else {
for ($i = 0; $i < count($post['package_rec_name']); $i++) {
for ($j = 0; $j < count($post['package_send_name']); $j++) {
$package_id = Package::addDocument($post['package_send_name'][$i], $post['package_send_addr'][$i], $post['package_send_country'][$i], $post['package_rec_name'][$j], $post['package_rec_addr'][$j], $post['package_rec_country'][$j], $station_id, $post['pack_cont_descr_d'], $post['pack_cont_pl_count_d'], $post['pack_cont_weight_d'], 'null', $post['pack_cont_comm_d'], 'null', 'null', $post['package_send_phone'][$i], $post['package_rec_phone'][$j], $post['package_guar'], $date_on_reception);
/**/
$res = Package::setStatus($package_id[0]['package_add_all_document'], 2, 'true', $user_id, 'null');
/**/
}
}
}
//$this->response->redirect('/search/full/package', '/');
//$this->view->setVar("test", $package_id);
}
}
public function update(Users $user)
{
$id = $user->getId();
$query = "UPDATE users SET content = '" . $content . "', id_author = '" . $id_author . "' WHERE id = '" . $id . "'";
$result = mysqli_query($this->database, $query);
if ($result) {
return $this->findById($id);
} else {
return "Erreur serveur.";
}
}
public function addAction()
{
$this->view->title = "Send - ";
$this->view->selectmenu = "user";
if ($this->request->isPost()) {
$user = new Users();
$user->name = $this->request->getPost('name');
$user->alias = $this->request->getPost('alias');
$user->num = $this->request->getPost('num');
$user->group = $this->request->getPost('group');
$user->save();
$response = $user->getId();
return $this->dispatcher->forward(array('action' => 'sent', 'params' => array($this->view->title, $this->view->selectmenu, $response)));
}
}
protected function execute($arguments = array(), $options = array())
{
$databaseManager = new sfDatabaseManager($this->configuration);
$environment = $this->configuration instanceof sfApplicationConfiguration ? $this->configuration->getEnvironment() : $options['env'];
$connection = $databaseManager->getDatabase($options['connection'])->getConnection();
$conn = Doctrine_Manager::connection();
$user = new Users();
$user['given_name'] = $this->ask('Given Name :');
$user['family_name'] = $this->ask('Family Name :');
while ($user['family_name'] == "") {
$this->logSection('Invalid name', "The family name can't be empty, please provide one", null, 'ERROR');
$user['family_name'] = $this->ask('Family Name :');
}
$user['db_user_type'] = Users::ADMIN;
$user->save();
$this->logSection('User added', 'User is added with admin rights');
$login = $this->ask('Login :'******'Invalid login', "The login can't be empty, please provide one", null, 'ERROR');
$login = $this->ask('Login :'******'Password :'******'Invalid password', "The password can't be empty, please provide one", null, 'ERROR');
$password = $this->ask('Password :'******'local');
$login_info->setUserRef($user->getId());
$login_info->save();
$this->logSection('Widgets', "Start adding widgets for this user");
$user->addUserWidgets();
$this->logSection('Finished', "Widget added");
}
public function setUser(Users $user)
{
$this->id_user = $user->getId();
return true;
}
/**
* Save User
* @param Language $language
* @return void
*/
public function saveUser(Users $user)
{
try {
if ($user->getId() == '') {
$idGenService = new IDGeneratorService();
$idGenService->setEntity($user);
$user->setId($idGenService->getNextID());
}
$user->save();
} catch (Exception $e) {
throw new AdminServiceException($e->getMessage());
}
}
<?php
include 'Blocs/toutePageConectee.php';
if ($conecte == 1) {
$userProfile = new Users();
if (isset($_GET['userName'])) {
$userProfile->setIdWithUserName($_GET['userName'], $bdd);
$userProfile->hydrateTotalWithId($bdd);
} else {
if (isset($_GET['userId'])) {
$userProfile->setId($_GET['userId']);
$userProfile->hydrateTotalWithId($bdd);
}
}
$userProfile->amIFollowing($userProfile->getId(), $bdd);
//$userProfile->getAllMyFollowers($bdd);
//var_dump($userProfile->getMesFollowers());
} else {
header("Location: index.php");
}
$('input[name=phone]').val(selectedOption.data('phone') );
$('input[name=email]').val(selectedOption.data('email') );
})});
</script>
<?php
if (!defined('__ROOT__')) {
define('__ROOT__', dirname(dirname(__FILE__)));
}
if (!isset($_SESSION)) {
session_start();
}
require_once __ROOT__ . '/class/Users.php';
require_once __ROOT__ . '/class/UsersList.php';
$user = new Users($_SESSION['id_user']);
$user->read();
$id = $user->getId();
$name = $user->getName();
$lastname = $user->getLastName();
$address = $user->getAddress();
$phone = $user->getPhone();
$email = $user->getMail();
if (isset($_POST['update'])) {
$newId = $_POST['id_update'];
$newAddress = $_POST['address'];
$newPhone = $_POST['phone'];
$newEmail = $_POST['email'];
$newPass = $_POST['pass'];
if ($newPass != '') {
$newPass = md5($newPass);
$updateUser = new Users($newId, null, null, $newAddress, $newPhone, $newEmail, $newPass);
$updateUser->update();
<?php
require_once 'Classes/ListUsers.class.php';
require_once '/Blocs/toutesPagesApi.php';
$listeUsers = new ListUsers();
$listeUsers->getAllUsers($bdd);
if (isset($_GET['idUser'])) {
$listeUsers->getListeByIdUser($_GET['idUser'], $bdd);
} else {
if (isset($_GET['userName'])) {
$user = new Users();
$user->setIdWithUserName($_GET['userName'], $bdd);
$listeUsers->getListeByIdUser($user->getId(), $bdd);
}
}
//var_dump($listePosts->getListePosts());
$arrayToJson = $listeUsers->toArray();
$cat = SpecimensTable::getDistinctCategories();
$t->is(count($cat), 13, 'Number of differents categories: "13"');
$t->is($cat['undefined'], 'Undefined', 'get the first category: "Undefined"');
$t->is($cat['collect'], 'Collect', 'get the last category: "Collect"');
/* Prepare data for the test of findConservatories method */
// >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
// User creation/extraction
$userEvil = Doctrine::getTable('Users')->findOneByFamilyName('Evil');
$brol_user = new Users();
$brol_user->setFamilyName('Brolus');
$brol_user->setGivenName('Brolus');
$brol_user->setDbUserType(Users::REGISTERED_USER);
$brol_user->save();
$conn = Doctrine_Manager::connection();
// Collection Rights association for the "brol" user - rights on Molusca, Amphibia and Aves collections
$conn->exec("INSERT INTO collections_rights (collection_ref, user_ref, db_user_type)\n (\n SELECT id, ? , ?\n FROM collections\n WHERE name_indexed IN ('molusca', 'amphibia', 'aves')\n )", array($brol_user->getId(), $brol_user->getDbUserType()));
// Building and Floor creation for specimens under Molusca and Amphibia collections
$conn->exec("UPDATE specimens\n SET building = CASE WHEN id = 1 THEN 'De Vestel' ElSE 'Geology' END,\n floor = CASE WHEN id = 1 THEN '14' ElSE '-1' END\n WHERE collection_ref IN (\n SELECT id\n FROM collections\n WHERE name_indexed IN ('molusca', 'amphibia')\n )\n ");
// <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
$t->info('Test of "findConservatories" - part 1 - registered user - building list searched');
$conservatories_counts = Doctrine::getTable("Specimens")->findConservatories($brol_user, 'building', array());
$t->is('', $conservatories_counts[0]['item'], '"1" specimen in "empty" building (in aves collection)');
$t->is(1, $conservatories_counts[0]['ctn'], '"1" specimen in "empty" building in (aves collection)');
$t->is('De Vestel', $conservatories_counts[1]['item'], '"1" specimen in building "De Vestel"');
$t->is(1, $conservatories_counts[1]['ctn'], '"1" specimen in building "De Vestel"');
$t->is('Geology', $conservatories_counts[2]['item'], '"2" specimen in building "Geology"');
$t->is(2, $conservatories_counts[2]['ctn'], '"2" specimen in building "De Vestel"');
$t->info('Test of "findConservatories" - part 2 - registered user - floor list searched for "De Vestel" building');
$floor_counts = Doctrine::getTable("Specimens")->findConservatories($brol_user, 'floor', array("building" => $conservatories_counts[2]['item']));
$t->is('-1', $floor_counts[0]['item'], '"2" specimens on floor "-1" for "Geology" building');
$t->is(2, $floor_counts[0]['ctn'], '"2" specimens on floor "-1" for "Geology" building');
public function deleteAction($user_login)
{
$this->getConnectedUser()->assertRight('user_delete');
Users::deleteOne(Users::getId($user_login));
}
public function putAction($user_login)
{
Users::updateOne(Users::getId($user_login), $_POST);
$this->setParameter('user_login', $_POST['user_login']);
}
$t->is($widgets[0]->getOrderBy(), 2, "Is order set for everyone");
$t->is($widgets[0]->getColNum(), 2, "Is col_num set correctly");
$t->comment('->changeOrder()');
Doctrine::getTable('MyWidgets')->setUserRef($userEvil)->changeOrder('board_widget', array("savedSpecimens"), array("savedSearch"));
$widgets = Doctrine::getTable('MyWidgets')->setUserRef($userEvil)->createQuery()->andWhereIn("group_name", array("savedSpecimens", "savedSearch"))->orderBy('group_name ASC')->execute();
$t->is($widgets[0]->getOrderBy(), 1, "Is order set correctly");
$t->is($widgets[1]->getOrderBy(), 1, "Is order set for everyone");
$t->is($widgets[0]->getColNum(), 2, "Is col_num set correctly");
$t->is($widgets[1]->getColNum(), 1, "Is col_num for everyone");
$q = Doctrine_Query::create()->delete('MyWidgets p')->Where('p.user_ref = ?', $userEvil)->execute();
$t->is(count(Doctrine::getTable('MyWidgets')->setUserRef($userEvil)->getWidgets('board_widget')), 0, 'All widget would have been deleted');
$t->comment('->addWidgets()');
$brol_user = new Users();
$brol_user->setFamilyName('Brolus');
$brol_user->setGivenName('Brolus');
$brol_user->setDbUserType(Users::REGISTERED_USER);
$brol_user->save();
$brol_user->addUserWidgets();
$t->comment('->updateWigetsAvailabilityForRole()');
$t->is(count(Doctrine::getTable('MyWidgets')->setUserRef($brol_user->getId())->setDbUserType(Users::REGISTERED_USER)->getWidgets('board_widget')), 5, '6 board widgets but only 5 visible for a registered user');
$widget_workflowsSummary = Doctrine_Query::create()->from("MyWidgets p")->where("p.user_ref = ?", array($brol_user->getId()))->andWhere("p.category = ?", array("board_widget"))->andWhere("p.group_name = ?", array("workflowsSummary"))->fetchArray();
$collection_mollusca = Doctrine_Query::create()->select("c.id")->from("Collections c")->where("c.name = ?", array("Molusca"))->fetchArray();
$t->info('Testing the "doUpdateWidgetRight" method');
Doctrine::getTable('MyWidgets')->setUserRef($brol_user->getId())->setDbUserType(Users::REGISTERED_USER)->doUpdateWidgetRight($collection_mollusca[0]['id'], array($widget_workflowsSummary[0]['id']), 'insert');
$widget_workflowsSummary = Doctrine_Query::create()->from("MyWidgets p")->where("p.user_ref = ?", array($brol_user->getId()))->andWhere("p.category = ?", array("board_widget"))->andWhere("p.group_name = ?", array("workflowsSummary"))->fetchArray();
$t->is(count(Doctrine::getTable('MyWidgets')->setUserRef($brol_user->getId())->setDbUserType(Users::REGISTERED_USER)->getWidgets('board_widget', $collection_mollusca[0]['id'])), 6, '6 board widgets if Molusca collection given');
$t->info('Testing the "doUpdateWidgetRight" method - clap 2nd: remove of Mollusca collection for workflowsSummary widget');
Doctrine::getTable('MyWidgets')->setUserRef($brol_user->getId())->setDbUserType(Users::REGISTERED_USER)->doUpdateWidgetRight($collection_mollusca[0]['id'], array($widget_workflowsSummary[0]['id']), 'delete');
$t->is(count(Doctrine::getTable('MyWidgets')->setUserRef($brol_user->getId())->setDbUserType(Users::REGISTERED_USER)->getWidgets('board_widget', $collection_mollusca[0]['id'])), 5, 'Back to 5 board widgets even with Molusca collection given');
Doctrine::getTable('MyWidgets')->setUserRef($brol_user->getId())->updateWigetsAvailabilityForRole(Users::REGISTERED_USER, false);
$t->is(count(Doctrine::getTable('MyWidgets')->setUserRef($brol_user->getId())->getWidgets('board_widget')), 1, 'Removing \'Registered user\' right : 1 board widgets visible now (stats)');
<?php
include dirname(__FILE__) . '/../../bootstrap/Doctrine.php';
$t = new lime_test(4, new lime_output_color());
$t->comment('->getUserByPassword()');
$t->is(Doctrine::getTable('Users')->getUserByPassword("root", "brol"), false, 'Test the local login with a wrong password');
$t->is(Doctrine::getTable('Users')->getUserByPassword("root", "evil")->getFamilyName(), "Evil", 'Test the local login with a good password');
$t->is('' . Doctrine::getTable('Users')->getUserByPassword("root", "evil"), "Evil Root (Mr)", 'Test the local login with a good password');
$u = Doctrine::getTable('Users')->getUserByPassword("root", "evil");
$nu = new Users();
$nu->setFamilyName('Chambert');
$nu->setGivenName('Yann');
$nu->setGender('M');
$nu->setDbUserType(1);
$nu->setIsPhysical(true);
$nu->save();
$t->comment('->findUser()');
$t->is(Doctrine::getTable('Users')->findUser($nu->getId())->getFamilyName(), 'Chambert', 'User Chambert is created');
$uli = new UsersLoginInfos();
/**
* set session
*/
public function setSession(\Users $user)
{
Session::set('auth', array('id' => $user->getId()));
}
private function getParams(Users $Users)
{
$params = array(':id' => $Users->getId(), ':username' => $Users->getUsername(), ':email' => $Users->getEmail(), ':password' => $Users->getPassword());
if ($Users->getId()) {
// unset created date, this one is never updated
unset($params[':created_on']);
}
return $params;
}
<?php
require_once 'Classes/ListePosts.class.php';
require_once '/Blocs/toutesPagesApi.php';
$listePosts = new ListePosts();
if (isset($_GET['idUser'])) {
$listePosts->getListeByIdUser($_GET['idUser'], $bdd);
} else {
if (isset($_GET['userName'])) {
$user = new Users();
$user->setIdWithUserName($_GET['userName'], $bdd);
$listePosts->getListeByIdUser($user->getId(), $bdd);
}
}
//var_dump($listePosts->getListePosts());
$arrayToJson = $listePosts->toArray();
