public function setUser(User $user)
{
if ($this->user !== $user) {
$this->user = $user;
$user->setAddress($this);
}
}
function login($username, $password)
{
$sql = "SELECT * FROM users WHERE username = '******' AND password = '******'";
$result = mysql_query($sql, $this->conn);
if (mysql_num_rows($result) > 0) {
//successful login
while ($row = mysql_fetch_assoc($result)) {
$user = new User();
$user->charities = $this->getCharities($row["user_id"]);
$user->setEmail($this->getEmail($row["user_id"]));
$user->setAddress($this->getAddress($row["user_id"]));
$user->setZipcode($this->getZipcode($row["user_id"]));
$card = $this->getCard($row["user_id"]);
$user->setCard($card[0]);
$user->setFullName($row["full_name"]);
$user->setUsername($row["username"]);
$user->setId($row["user_id"]);
return $user;
}
} else {
return null;
//Unsuccessful login
}
return null;
}
function getUserForID($userId)
{
$user = new User();
ini_set('display_errors', 'On');
$db = "w4111c.cs.columbia.edu:1521/adb";
$conn = oci_connect("kpg2108", "test123", $db);
$stmt = oci_parse($conn, "select * from users where user_Id='" . $userId . "'");
$rows = oci_execute($stmt);
oci_close($conn);
while ($row = oci_fetch_assoc($stmt)) {
echo $row['LOGIN_ID'];
$user->setUserId($row['USER_ID']);
$user->setPassword($row['PASSWORD']);
$user->setFirstName($row['FNAME']);
$user->setLastName($row['LNAME']);
$user->setLoginId($row['LOGIN_ID']);
$user->setEmailId($row['EMAIL_ID']);
$user->setAddress($row['ADDRESS']);
$user->setPhoneNumber($row['PHONE_NO']);
$user->setSecurityAnswer($row['ANSWER']);
$user->setSecurityQuestion($row['QUESTION']);
$user->setMiles($row['MILES']);
}
return $user;
}
public function import($adminUserId)
{
$count = 0;
$add_method = $this->getValue('add_method');
$file = $this->getValue('file');
$delimiter = $this->getValue('delimiter');
$skipHeader = $this->getValue('skipHeader');
$fp = fopen($file->getTempName(), 'r');
if ($fp) {
if ($add_method == self::REPLACE) {
$c = new Criteria();
$c->add(UserPeer::ID, $adminUserId, Criteria::NOT_EQUAL);
UserPeer::doDelete($c);
}
while ($data = fgetcsv($fp, 0, $delimiter)) {
if (empty($data[0]) || count($data) < 7) {
continue;
}
if ($skipHeader) {
$skipHeader = false;
continue;
}
try {
$user = new User();
$user->setFamilyName($data[0]);
$user->setSurname($data[1]);
$user->setBirthdate($data[2]);
$user->setCardNumber($data[3]);
$user->setEmailAddress($data[4]);
$user->setAddress($data[5]);
$user->setPhoneNumber($data[6]);
$user->autoCorrectNames();
$user->autoSetLogin();
$user->save();
++$count;
} catch (Exception $ex) {
}
}
fclose($fp);
return $count;
}
return false;
}
public function getAbonentByID($user_id)
{
try {
$sql = "select * from users t1, phonenumbers t2 where t1.user_id=t2.user_id and t1.user_id=?";
$query = $this->db->query($sql, array($user_id));
$UserObj = new User();
if ($query->num_rows() > 0) {
$row = $query->row_array();
$UserObj->setID($row['user_id']);
$UserObj->setFirstName($row['first_name']);
$UserObj->setLastName($row['last_name']);
$UserObj->setAddress($row['address']);
$UserObj->setPhoneNumber($row['phonenumber']);
}
return $UserObj;
} catch (Exception $e) {
throw new Exception($e->getMessage());
}
}
public function testPut()
{
$user = new User();
$user->setId('2');
$user->setName('Doe');
$user->setFirstname('John');
$user->setLogin('jDoe');
$user->setPassword('3131', true);
$user->setMail('*****@*****.**');
$user->setAddress('9 rue de la pochette');
$user->setPhone('0143523213');
$user->setPortable('0625884536');
$user->setSubscriptionDate('2012-11-27 08:39:00');
$user->setHash('79457832847b44a73ccfeef57c03033db88cad08');
$user->setNewsletter('1');
$user->setRole('user');
$userMapper = new UserMapper();
$userMapper->setId(2);
$userMapper->updateUser($user);
$this->assertEquals($user, $userMapper->selectUser());
}
fURL::redirect('/members');
}
if (isset($_POST['submit'])) {
try {
fRequest::validateCSRFToken($_POST['token']);
$validator = new fValidation();
$validator->addRequiredFields('fullname', 'password', 'email', 'address');
$validator->addEmailFields('email');
$validator->validate();
if ($_POST['password'] != $_POST['passwordconfirm']) {
throw new fValidationException('Passwords do not match');
}
$user = new User();
$user->setEmail(strtolower($_POST['email']));
$user->setFullName($_POST['fullname']);
$user->setAddress($_POST['address']);
$user->setPassword(fCryptography::hashPassword($_POST['password']));
if (isset($_POST['hackney'])) {
$user->setHackney(true);
}
$user->store();
fSession::set('user', $user->getId());
fURL::redirect('/members');
exit;
} catch (fValidationException $e) {
echo "<p>" . $e->printMessage() . "</p>";
} catch (fSQLException $e) {
echo "<p>An unexpected error occurred, please try again later</p>";
trigger_error($e);
}
}
public function testGetSetAddress()
{
$user = new User();
$user->setAddress('9 rue de la pochette');
$this->assertEquals('9 rue de la pochette', $user->getAddress());
}
class Address
{
private $street;
private $extra;
private $zip;
private $city;
public function __construct($street, $extra, $zip, $city)
{
// Validation stuff should be here
$this->street = $street;
$this->extra = $extra;
$this->zip = $zip;
$this->city = $city;
}
}
class User
{
private $name;
private $email;
private $address;
// More stuff
function setAddress(Address $address)
{
$this->address = $address;
}
}
$address = new AddressDTO('Calle principal 14', '', '1234', 'My Town');
$user = new User();
$user->setAddress($address);
print_r($user);
function getUsers($order = "login", $sort = "ASC", $offset = 0, $count = 0, $filter = array())
{
$users = false;
$order = in_array($order, array('id', 'login', 'email', 'firstname', 'lastname', 'fullname', 'birthdate', 'registeredmoment')) ? $order : "login";
$sort = in_array($sort, array('ASC', 'DESC')) ? $sort : "ASC";
$sql = "SELECT \tid, \n\t\t\t\t\t\tlogin, \n\t\t\t\t\t\t'' AS pwd, \n\t\t\t\t\t\tIF(login = '******' AND pwd = MD5('" . $this->fDevPassword . "'), 1, 0) AS is_dev, \n\t\t\t\t\t\tIF(login = '******', 1, 0) AS is_defaultuser, \n\t\t\t\t\t\temail, \n\t\t\t\t\t\tfirstname, \n\t\t\t\t\t\tmiddlename, \n\t\t\t\t\t\tlastname, \n\t\t\t\t\t\tCONCAT(firstname, ' ', middlename, ' ', lastname) AS fullname, \n\t\t\t\t\t\tDATE_FORMAT(birthdate, '%m/%d/%Y') AS f_birthdate, \n\t\t\t\t\t\tphone, \n\t\t\t\t\t\taddress, \n\t\t\t\t\t\tcity, \n\t\t\t\t\t\tstate, \n\t\t\t\t\t\tpostalcode, \n\t\t\t\t\t\tcountry, \n\t\t\t\t\t\tDATE_FORMAT(registeredmoment, '%m/%d/%Y') AS f_registeredmoment, \n\t\t\t\t\t\tDATE_FORMAT(previousvisitmoment, '%m/%d/%Y') AS f_previousvisitmoment, \n\t\t\t\t\t\tINET_NTOA(previousvisitip) AS f_previousvisitip, \n\t\t\t\t\t\tDATE_FORMAT(currentvisitmoment, '%m/%d/%Y') AS f_currentvisitmoment, \n\t\t\t\t\t\tINET_NTOA(currentvisitip) AS f_currentvisitip \n\t\t\t\t\tFROM " . $this->fUsersTable . " ORDER BY " . $order . " " . $sort;
if ($count > 0 && $offset > 0) {
$sql .= " LIMIT " . (int) $offset . ", " . (int) $count;
} elseif ($count > 0) {
$sql .= " LIMIT " . (int) $count;
}
if ($arrUsers = $this->fDB->getQueryRecordSet($sql)) {
$users = array();
foreach ($arrUsers as $arrUser) {
$user = new User($arrUser['id'], $arrUser['login'], $arrUser['pwd'], $arrUser['email'], $arrUser['firstname'], $arrUser['middlename'], $arrUser['lastname']);
$user->setBirthDate($arrUser['f_birthdate']);
$user->setPhone($arrUser['phone']);
$user->setAddress($arrUser['address']);
$user->setCity($arrUser['city']);
$user->setState($arrUser['state']);
$user->setPostalCode($arrUser['postalcode']);
$user->setCountry($arrUser['country']);
$user->setRegisteredDate($arrUser['f_registeredmoment']);
$user->setPreviousVisitMoment($arrUser['f_previousvisitmoment']);
$user->setPreviousVisitIP($arrUser['f_previousvisitip']);
$user->setCurrentVisitMoment($arrUser['f_currentvisitmoment']);
$user->setCurrentVisitIP($arrUser['f_currentvisitip']);
$user->setIsDev($arrUser['is_dev']);
$user->setIsDefaultUser($arrUser['is_defaultuser']);
$users[] = $user;
}
}
return $users;
}
$validator->addValidation("phoneNo", "req", "Please fill in phone number");
$validator->addValidation("phoneNo", "numeric", "Please fill only numeric values for phone number");
$validator->addValidation("passwordRecoveryQues", "req", "Please fill in password recovery question");
$validator->addValidation("passwordRecoveryAns", "req", "Please fill in password recovery answer");
$validator->addValidation("email", "email", "The input for email should be a valid email value");
$validator->addValidation("email", "req", "Please fill in email");
if ($validator->ValidateForm()) {
$_SESSION['action'] = "updateUser";
$user = new User();
$user->setUserId($_SESSION['userId']);
$user->setLoginId($user1->getLoginId());
$user->setPassword($_REQUEST["password"]);
$user->setFirstName($_REQUEST["firstName"]);
$user->setLastName($_REQUEST["lastName"]);
$user->setEmailId($_REQUEST["email"]);
$user->setAddress($_REQUEST["address"]);
$user->setPhoneNumber($_REQUEST["phoneNo"]);
$user->setSecurityAnswer($_REQUEST["passwordRecoveryQues"]);
$user->setSecurityQuestion($_REQUEST["passwordRecoveryAns"]);
$_SESSION['userToBeUpdated'] = serialize($user);
header("Location: ../controller/Controller.php");
} else {
echo "<B>Validation Errors:</B>";
$error_hash = $validator->GetErrors();
foreach ($error_hash as $inpname => $inp_err) {
echo "<p>{$inpname} : {$inp_err}</p>\n";
}
}
}
$disp_loginName = isset($_POST['loginName']) ? $_POST['loginName'] : $user1->getLoginId();
$disp_password = isset($_POST['password']) ? $_POST['password'] : $user1->getPassword();
//$user_id=mysqli_real_escape_string($adduserobj->conxn,$_POST['user_id']);
$fullname = mysqli_real_escape_string($adduserobj->conxn, $_POST['fullname']);
$username = mysqli_real_escape_string($adduserobj->conxn, $_POST['username']);
$password = mysqli_real_escape_string($adduserobj->conxn, $_POST['password']);
$password = md5($password);
$confirm_password = mysqli_real_escape_string($adduserobj->conxn, $_POST['confirm_password']);
$confirm_password = md5($confirm_password);
$address = mysqli_real_escape_string($adduserobj->conxn, $_POST['address']);
$telephone = mysqli_real_escape_string($adduserobj->conxn, $_POST['telephone']);
$email = mysqli_real_escape_string($adduserobj->conxn, $_POST['email']);
//$adduserobj->setUserID($user_id);
$adduserobj->setFullname($fullname);
$adduserobj->setUsername($username);
$adduserobj->setPassword($password);
$adduserobj->setCPassword($confirm_password);
$adduserobj->setEmail($email);
$adduserobj->setAddress($address);
$adduserobj->setTelephone($telephone);
//$adduserobj->setError($er);
//$adduserobj->setMessage($msg);
$flag = $adduserobj->addUser();
/*echo '<pre>';
print_r ($adduserobj);
echo '</pre>';
exit;*/
if ($flag) {
header('location:../../rms/login.php');
$_SESSION['msg'] = $adduserobj->msg = "Thanks, You have registered sucessfully";
} else {
echo $_SESSION['msg'] = $adduserobj->msg = "Sorry the user has not been added, please try again later";
}
fURL::redirect('/members');
}
if (isset($_POST['submit'])) {
try {
fRequest::validateCSRFToken($_POST['token']);
$validator = new fValidation();
$validator->addRequiredFields('fullname', 'password', 'email', 'address');
$validator->addEmailFields('email');
$validator->validate();
if ($_POST['password'] != $_POST['passwordconfirm']) {
throw new fValidationException('Passwords do not match');
}
$user = new User();
$user->setEmail(strtolower(trim($_POST['email'])));
$user->setFullName(trim($_POST['fullname']));
$user->setAddress(trim($_POST['address']));
$user->setPassword(fCryptography::hashPassword($_POST['password']));
$user->setEmergencyName(trim($_POST['emergency_name']));
$user->setEmergencyPhone(trim($_POST['emergency_phone']));
$user->store();
fSession::set('user', $user->getId());
fURL::redirect('/members');
exit;
} catch (fValidationException $e) {
echo "<p>" . $e->printMessage() . "</p>";
} catch (fSQLException $e) {
echo "<p>An unexpected error occurred, please try again later</p>";
trigger_error($e);
}
}
?>
if (!empty($p)) {
$p = md5($p . SALT);
$p = base64_encode($p);
$p = hash('sha256', $p);
$u->setPassword($p);
}
$u->setIdRole(fRequest::encode('role', 'integer'));
$u->setEmail(fRequest::encode('email', 'string'));
$u->setFirstName(fRequest::encode('firstName', 'string'));
$u->setLastName(fRequest::encode('lastName', 'string'));
$u->setBirthday(fRequest::encode('birthday', 'date'));
$u->setPhone(fRequest::encode('phone', 'string'));
$u->setCellphone(fRequest::encode('cellphone', 'string'));
$u->setNextel(fRequest::encode('nextel', 'string'));
$u->setFax(fRequest::encode('fax', 'string'));
$u->setAddress(fRequest::encode('address', 'string'));
try {
$u->store();
} catch (Exception $e) {
die('El correo electrónico ya está asociado con una cuenta');
}
try {
$regions = array_unique(fRequest::encode('region', 'array'));
$permissions = array_unique(fRequest::encode('permission', 'array'));
$ur = new UserRegion();
$userRegions = $ur->getByIdUser($u->getIdUser());
foreach ($userRegions as $item) {
$ur = new UserRegion(array('id_user' => $u->getIdUser(), 'id_region' => $item->getIdRegion()));
$ur->delete();
}
$up = new UserPermission();
// On envoit au serveur d'advanced-creation les informations sur les versions et logiciels
sendVersionsInfo($software->getSoftware(), $software->getVersion());
$test = $user->getUsername();
$testAddress = $user->getCompanyName();
if (!empty($test)) {
$boutonUpdate = "Update";
}
if (!empty($testAddress)) {
$boutonUpdateAdresse = "Update";
}
//------- On identifie le formulaire en fonction du nom du bouton submit ---------
if (isset($_POST['send-credentials'])) {
if (!empty($_POST['username']) && !empty($_POST['password'])) {
$user->setCredentials($_POST['username'], $_POST['password']);
} else {
$message = "Your Username and password can't be empty, please fill them and update";
}
} else {
if (isset($_POST['send-address'])) {
if (!empty($_POST['company_name']) && !empty($_POST['street1']) && !empty($_POST['city']) && !empty($_POST['zip']) && !empty($_POST['country'])) {
$user->setAddress($_POST['company_name'], $_POST['street1'], $_POST['street2'], $_POST['street3'], $_POST['city'], $_POST['state'], $_POST['zip'], $_POST['country'], $_POST['phone'], $_POST['support']);
} else {
$message = "We coudn't update your address, please fill the required fields and try again";
}
$testAddress = $user->getCompanyName();
if (!empty($testAddress)) {
$boutonUpdateAdresse = "Update";
}
}
}
include_once PLUGIN_PATH_SHIPWORKSWORDPRESS . 'view/admin.php';
d($o);
}
require_once 'Value_Object/User.php';
require_once 'Logic/UserLogic.php';
$user = new User();
$ulogic = new UserLogic();
//$user->setFbId($fbme['id']);
if ($fbme) {
$user->setFbId($fbme['id']);
$user->setFname($fbme['first_name']);
$user->setLname($fbme['last_name']);
$user->setEmail($fbme['email']);
$user->setSex($fbme['gender']);
$address = $userInfo[0];
$address = $address['current_location'];
$user->setAddress('Not specified.');
$user->setCountry($address['country']);
$datte = $fbme['birthday'];
$user->setBday(date("Y-m-d", $datte));
$user->setCity($address['city']);
$user->setUsername($_POST['uid']);
$user->setPassword($_POST['pass']);
$today = date("Y-m-d");
$user->setJoinedOn($today);
$path = $fqlResult[0];
$user->setPicPath($path['pic_square']);
$user = $ulogic->fbMap($user);
echo "After ";
echo print_r($user);
if ($user->id) {
$_SESSION['user'] = $user->id;
function setUser($user)
{
$userw = new User();
$userw->setId($user->id);
$userw->setName($user->name);
$userw->setPhone($user->phone);
$userw->setEmail($user->email);
$userw->setAddress($user->address);
$userw->setPassword($user->password);
$userw->setSex($user->sex);
$userw->setAge($user->age);
$userw->setCode($user->code);
$userw->setCreatedate($user->createdate);
$userw->setUpdatedate($user->updatedate);
$userw->setDr($user->dr);
return $userw;
}
function login($user_id, $user_pass, &$retVal)
{
$user = NULL;
$retVal = -1;
$this->connect();
//$result = $this->conn->query("CALL sp_login_account('$user_id', '$user_pass')");
$result = $this->conn->query("CALL sp_login_account2('{$user_id}')");
if ($result) {
//var_dump($result);
//$row = $result->fetch_assoc();
$obj = $result->fetch_object();
if ($obj) {
//var_dump($obj);
$retVal = $obj->result;
switch ($obj->result) {
case 0:
$hash = $obj->Passwd;
if (password_verify($user_pass, $hash)) {
$user = new User();
$user->setId($obj->Account_id);
$user->setName($obj->Name);
$user->setRole($obj->Account_type);
$user->setAddress($obj->Address);
$user->setPhone($obj->Phone);
$user->setEmail($obj->Email);
$user->setEnrollYear($obj->Enroll_year);
//echo 'Before<br /><br />'; var_dump($user); echo 'After<br /><br />';
}
break;
case 1:
break;
case 2:
break;
}
}
$result->close();
// for fetch_object()
}
//$result->free_result(); // for fetch_assoc()
$this->close();
return $user;
}
public static function Edit()
{
$log_user = Tool::getLoginUser();
try {
$user = new User();
if (isset($_POST["id"]) && !empty($_POST["id"])) {
$user->setId($_POST["id"]);
}
if (isset($_POST["cache"]) && !empty($_POST["cache"])) {
$user->setCache($_POST["cache"]);
}
if (isset($_POST["username"]) && !empty($_POST["username"])) {
$user->setUsername($_POST["username"]);
} else {
Tool::pageError();
}
if (isset($_POST["password"]) && !empty($_POST["password"])) {
$user->setPassword($_POST["password"]);
} else {
Tool::pageError();
}
if (isset($_POST["name"]) && !empty($_POST["name"])) {
$user->setName($_POST["name"]);
}
if (isset($_POST["status"]) && !empty($_POST["status"])) {
$user->setStatus($_POST["status"]);
}
if (isset($_POST["address"]) && !empty($_POST["address"])) {
$user->setAddress($_POST["address"]);
}
if (isset($_POST["phone"]) && !empty($_POST["phone"])) {
$user->setPhone($_POST["phone"]);
}
if (isset($_POST["cache"]) && !empty($_POST["cache"])) {
if ($_POST["cache"] == User::CACHE_HIDE) {
$user->setCache(User::CACHE_HIDE);
} else {
$user->setCache(User::CACHE_SHOW);
}
}
$user->UpdateDatabase($log_user);
header("Location:../?menu=" . PAGE_MANAGE_USER);
exit;
} catch (Exception $e) {
echo 'Caught exception: ', $e->getMessage(), "\n";
// header("Location:../404.html");
}
}
