public function get_all()
{
$userlist = array();
$this->db->connect();
$sql = "SELECT * FROM users";
$result = $this->db->fetchquery($sql);
while ($row = $result->fetch_assoc()) {
$user = new User();
$user->set_id($row['id']);
$user->set_username($row['username']);
$user->set_password($row['password']);
array_push($userlist, $user);
}
return $userlist;
}
public function get_user($email, $password)
{
$this->db->connect();
$user = null;
$sql = "SELECT * from tbl_user WHERE email=? AND password=?";
$stmt = $this->db->initStatement($sql);
$stmt->bind_param("ss", $email, $password);
$stmt->execute();
$stmt->bind_result($id, $email, $password);
while ($stmt->fetch()) {
$user = new User();
$user->set_id($id);
$user->set_email($email);
}
$this->db->close();
return $user;
}
function get_user_by_name($name)
{
$mysqli = new mysqli(get_db_host(), get_db_user(), get_db_password(), get_db_database());
$stmt = $mysqli->prepare("SELECT id, name, email, password_hash FROM user WHERE name = ? LIMIT 1");
$stmt->bind_param("s", $name);
$stmt->execute();
$res = $stmt->get_result();
if ($res->num_rows > 0) {
$row = $res->fetch_assoc();
$user = new User();
$user->set_id($row['id']);
$user->set_name($row['name']);
$user->set_email($row['email']);
$user->set_password_hash($row['password_hash']);
$stmt->close();
return $user;
} else {
return NULL;
}
}
public function updateUser()
{
if (isset($_POST['submit'])) {
// var_dump($_POST['pass']) ;
if ($_POST['nip'] == "" || $_POST['nama'] == "") {
echo 'ada field yang masih belum diisi';
} else {
if ($_POST['pass'] !== $_POST['cpass']) {
echo 'data tidak bisa disimpan karena password berbeda dengan confirm passwordnya';
}
if ($_POST['pass'] == "no_change" || $_POST['cpass'] == "no_change") {
if ($_FILES['upload']['name'] == "") {
$user = new User($registry);
$user->set_id($_POST['id']);
$user->set_nip($_POST['nip']);
$user->set_nmUser($_POST['nama']);
$user->set_akses($_POST['akses']);
$user->updateUser_withoutpass($user);
} else {
$allowedExts = array("jpg", "jpeg", "png");
$ext = explode('.', $_FILES['upload']['name']);
$extension = $ext[count($ext) - 1];
if (in_array($extension, $allowedExts)) {
$img_small = new ResizeImage($_FILES["upload"]["tmp_name"]);
$img_small->resizeTo(64, $resizeOption = 'maxwidth');
$img_small->saveImage("files/foto/" . $_POST['nip'] . "_small." . $extension);
move_uploaded_file($_FILES["upload"]["tmp_name"], "files/foto/" . $_POST['nip'] . "." . $extension);
} else {
}
$user = new User($registry);
$user->set_id($_POST['id']);
$user->set_nip($_POST['nip']);
$user->set_nmUser($_POST['nama']);
$user->set_akses($_POST['akses']);
$user->set_foto($_POST['nip'] . "." . $extension);
$user->updateUser_withoutpass($user);
}
}
if ($_POST['pass'] !== "no_change" && $_POST['pass'] == $_POST['cpass']) {
if ($_FILES['upload']['name'] == "") {
$user = new User($registry);
$user->set_id($_POST['id']);
$user->set_nip($_POST['nip']);
$user->set_nmUser($_POST['nama']);
$user->set_pass($_POST['pass']);
$user->set_akses($_POST['akses']);
$user->updateUser($user);
} else {
$allowedExts = array("jpg", "jpeg", "png");
$ext = explode('.', $_FILES['upload']['name']);
$extension = $ext[count($ext) - 1];
if (in_array($extension, $allowedExts)) {
$img_small = new ResizeImage($_FILES["upload"]["tmp_name"]);
$img_small->resizeTo(64, $resizeOption = 'maxwidth');
$img_small->saveImage("files/foto/" . $_POST['nip'] . "_small." . $extension);
move_uploaded_file($_FILES["upload"]["tmp_name"], "files/foto/" . $_POST['nip'] . "." . $extension);
} else {
}
$user = new User($registry);
$user->set_id($_POST['id']);
$user->set_nip($_POST['nip']);
$user->set_nmUser($_POST['nama']);
$user->set_pass($_POST['pass']);
$user->set_akses($_POST['akses']);
$user->set_foto($_POST['nip'] . "." . $extension);
$user->updateUser($user);
}
}
}
}
header('location:' . URL . 'admin/listUser');
}
public function delUser($id)
{
$where = "KD_USER="******"SELECT * FROM " . $this->_table . " WHERE " . $where . "";
$result = $this->_db->select($sql);
// var_dump($result);
$pic = new User($registry);
foreach ($result as $value) {
$pic->set_id($value['KD_USER']);
$pic->set_akses($value['AKSES_USER']);
$pic->set_foto($value['FOTO_USER']);
}
$foto = "files/foto/" . $pic->get_foto();
$foto2 = explode('.', $pic->get_foto());
$foto_small = $foto2[0] . '_small.' . $foto2[1];
// var_dump($foto);
$foto_small_path = "files/foto/" . $foto_small;
// var_dump($foto_small_path);
if ($pic->get_akses() == '1') {
} else {
$this->_db->delete($this->_table, $where);
if (file_exists($foto)) {
unlink($foto);
}
if (file_exists($foto_small_path)) {
unlink($foto_small_path);
}
}
}
/**
* Get a user object from a SQL row result.
*/
public static function get_user_from_row($row)
{
if (!$row) {
return NULL;
}
$user = new User();
$user->set_id($row['user_id']);
$user->set_name($row['user_name']);
$user->set_email($row['user_email']);
$user->set_salt($row['user_salt']);
$user->set_password_hash($row['user_passwordhash']);
return $user;
}
