protected function render_body()
{
if (!empty($_POST)) {
$errors = $this->validate_first_name(isset($_POST['first-name']) ? $_POST['first-name'] : "");
$errors .= $this->validate_last_name(isset($_POST['last-name']) ? $_POST['last-name'] : "");
$errors .= $this->validate_username(isset($_POST['username']) ? $_POST['username'] : "");
$errors .= $this->validate_password(isset($_POST['password']) ? $_POST['password'] : "");
$errors .= $this->validate_academic_year(isset($_POST['academic-year']) ? $_POST['academic-year'] : "");
if ($errors) {
$this->render_register_form($errors);
} else {
$user = new User();
$user->set_first_name($_POST['first-name']);
$user->set_last_name($_POST['last-name']);
$user->set_username($_POST['username']);
$user->set_password($_POST['password']);
$user->set_academic_year($_POST['academic-year']);
$user_model = new User_model();
if ($user_model->store_user($user, false, false, true) == false) {
$this->render_register_form('Username already exists.');
} else {
$this->redirect_to_main_page();
}
}
} else {
$this->render_register_form();
}
}
public function get_all()
{
//ARRAY OBJECT HARU PASS GARNA
$user_list = array();
//DATABASE CONNECTION
$this->db->connect();
//SELECT ALL QUERY
$sql = "SELECT user_id,user_name,first_name,last_name,contact_number,user_type,user_status,gen_id,age FROM user INNER JOIN generaluser ON user_id = u_id";
//fetchquery
$result = $this->db->fetchquery($sql);
//STORE IN OBJECT AND SEND TO VIEW
while ($row = $result->fetch_assoc()) {
$user = new User();
$user->set_user_id($row['user_id']);
$user->set_user_name($row['user_name']);
$user->set_first_name($row['first_name']);
$user->set_last_name($row['last_name']);
$user->set_contact_number($row['contact_number']);
$user->set_user_type($row['user_type']);
$user->set_user_status($row['user_status']);
array_push($user_list, $user);
}
$this->db->close();
return $user_list;
}
public function get_by_id($id)
{
$user = null;
//DATABASE CONNECTION
$this->db->connect();
//SELECT BY ID
$sql = "SELECT * FROM user WHERE user_id=?";
//PREPARE
$stmt = $this->db->initialize($sql);
//BIND
$stmt->bind_param("i", $id);
//EXECUTE
$stmt->execute();
//BIND RESULT
$stmt->bind_result($user_id, $user_name, $first_name, $last_name, $contact_number, $user_type, $user_status);
while ($stmt->fetch()) {
//instantiate object
$user = new User();
$user->set_user_id($user_id);
$user->set_user_name($user_name);
$user->set_first_name($first_name);
$user->set_last_name($last_name);
$user->set_contact_number($contact_number);
$user->set_user_type($user_type);
$user->set_user_status($user_status);
}
$this->db->close();
return $user;
}
public function get_all()
{
//ARRAY OBJECT HARU PASS GARNA
$user_list = array();
//DATABASE CONNECTION
$this->db->connect();
//SELECT ALL QUERY
$sql = "SELECT user_id,user_name,first_name,last_name,contact_number,user_type,user_status,name,doe,img,address,service,objective FROM user INNER JOIN welfare ON user_id = u_id";
//fetchquery
$result = $this->db->fetchquery($sql);
//STORE IN OBJECT AND SEND TO VIEW
while ($row = $result->fetch_assoc()) {
$user = new User();
$user->set_user_id($row['user_id']);
$user->set_user_name($row['user_name']);
$user->set_first_name($row['first_name']);
$user->set_last_name($row['last_name']);
$user->set_contact_number($row['contact_number']);
$user->set_user_type($row['user_type']);
$user->set_user_status($row['user_status']);
$user->set_welf_name($row['name']);
$user->set_welf_doe($row['doe']);
$user->set_welf_img($row['img']);
$user->set_welf_address($row['address']);
$user->set_welf_objective($row['objective']);
$user->set_welf_service($row['service']);
array_push($user_list, $user);
}
$this->db->close();
return $user_list;
}
private function _map_posted_data()
{
$user = new User();
$user->set_user_name($_POST['user_name']);
$user->set_first_name($_POST['first_name']);
$user->set_last_name($_POST['last_name']);
$user->set_contact_number($_POST['contact_number']);
$user->set_user_type($_POST['user_type']);
$user->set_user_status($_POST['user_status']);
return $user;
}
private function _map_posted_data()
{
$user = new User();
$user->set_user_name($_POST['user_name']);
$user->set_first_name($_POST['first_name']);
$user->set_last_name($_POST['last_name']);
$user->set_contact_number($_POST['contact_number']);
if (isset($_POST['user_type'])) {
$user->set_user_type($_POST['user_type']);
}
$user->set_user_status($_POST['user_status']);
if (isset($_POST['password'])) {
$user->set_password($_POST['password']);
}
if ($_POST['user_type'] == 'organization') {
$user->set_name($_POST['name']);
$user->set_doe($_POST['doe']);
$user->set_address($_POST['address']);
$user->set_objective($_POST['objective']);
//store file
$filename = $_FILES['img']['name'];
$path = PUBLIC_PATH . "/pictures/orgPictures/";
move_uploaded_file($_FILES['img']['tmp_name'], $path . $filename);
$savepath = PUBLIC_PATH2 . "/pictures/orgPictures/";
$user->set_img($savepath . $filename);
} elseif ($_POST['user_type'] == 'welfare') {
$user->set_welf_name($_POST['welf_name']);
$user->set_welf_doe($_POST['welf_doe']);
$user->set_welf_service($_POST['welf_service']);
$user->set_welf_address($_POST['welf_address']);
$user->set_welf_objective($_POST['welf_objective']);
//store file
$filename = $_FILES['img']['name'];
$path = PUBLIC_PATH . "/pictures/welfPictures/";
move_uploaded_file($_FILES['img']['tmp_name'], $path . $filename);
$savepath = PUBLIC_PATH2 . "/pictures/welfPictures/";
$user->set_welf_img($savepath . $filename);
}
return $user;
}
$query = "SELECT password, idUsers, first_name, last_name, uID FROM Users WHERE username = :username";
$stmt = $dbh->prepare($query);
$stmt->bindParam(':username', $_POST['username'], PDO::PARAM_STR);
$stmt->execute();
//If the username exists, check the password
if ($stmt->rowCount() > 0) {
$result = $stmt->fetch();
$dbPassword = $result['password'];
if ($dbPassword == hash('sha256', $_POST['password'])) {
//Now that the user is good to log in, unset all session variables except requestedPage
clear_session_variables();
//Then populate the user object
$user = new User();
$user->set_uid($result['uID']);
$user->set_first_name($result['first_name']);
$user->set_last_name($result['last_name']);
//Store the user's UID in a session variable for easy access
$_SESSION['uid'] = $result['uID'];
//Now assign the user their roles
$query = "SELECT role FROM Roles WHERE idUsers = :idUser";
$stmt = $dbh->prepare($query);
$stmt->bindParam(':idUser', intval($result['idUsers']), PDO::PARAM_INT);
$stmt->execute();
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
//Now add the user's roles to the User object
foreach ($result as $row) {
echo "I'm adding this: " . $row['role'];
$user->add_role($row['role']);
}
//Add the user to a session variable and get their full name in one too
$_SESSION['user'] = $user;
public function set_user_last_name($last_name)
{
parent::set_last_name($last_name);
}
protected function get_object($array)
{
$user = new User();
$user->set_first_name(isset($array['first_name']) ? $array['first_name'] : null);
$user->set_last_name(isset($array['last_name']) ? $array['last_name'] : null);
$user->set_username(isset($array['username']) ? $array['username'] : null);
$user->set_password(isset($array['password']) ? $array['password'] : null);
$user->set_academic_year(isset($array['academic_year']) ? $array['academic_year'] : null);
$user->set_term(isset($array['term']) ? $array['term'] : null);
$user->set_major(isset($array['major']) ? $array['major'] : null);
$user->set_level_code(isset($array['level_code']) ? $array['level_code'] : null);
$user->set_degree(isset($array['degree']) ? $array['degree'] : null);
$user->set_profile_photo(isset($array['profile_photo']) ? $array['profile_photo'] : null);
$user->set_visibility(isset($array['visibility']) ? $array['visibility'] : 2);
return $user;
}
$query = "SELECT DISTINCT U.uID, U.first_name, U.last_name, TA.class_request, TA.recommend\n FROM Users U, TA_Applicants TA\n WHERE U.uID = TA.uID AND TA.class_request = :catNum AND semester = :semester AND year = :year\n ORDER BY TA.recommend DESC";
$stmt = $dbh->prepare($query);
$stmt->bindValue(':catNum', $courseNum, PDO::PARAM_INT);
$stmt->bindValue(':semester', $semester, PDO::PARAM_STR);
$stmt->bindValue(':year', $year, PDO::PARAM_INT);
$stmt->execute();
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
//Create an array to hold all of the User objects
$taArray = [];
foreach ($result as $row) {
//Create a new user object
$currentUser = new User();
//Set the available variables
$currentUser->set_uid($row['uID']);
$currentUser->set_first_name($row['first_name']);
$currentUser->set_last_name($row['last_name']);
$currentUser->set_class_request($row['class_request']);
$currentUser->set_recommend($row['recommend']);
//Add the object to correct array
$taArray[] = $currentUser;
}
$dbh = null;
} catch (PDOException $e) {
print "Error!:" . $e->getMessage() . "<br/>";
die;
}
/*
* Now that all of the information has been gathered from the database, we can use it to generate some html.
*
*/
//Add the additional course information in its own divs
