<?php
class System {
function __construct() {
$this->db = new sweetzDB();
}
private $db;
/* SYSTEM USER FUNCTIONS */
public function getUsers($user_id=null) {
$sql = "SELECT * FROM users WHERE display = 1 ";
if(!empty($user_id)) {
$sql.= "AND user_id = $user_id ";
}
$sql.= "ORDER BY fullname";
$res = $this->db->queryArr($sql);
return $res;
}
public function getAllUsers() {
$sql = "SELECT s.store_id, s.store_name, u.user_id, u.fullname
FROM stores s
JOIN user_stores us ON (us.store_id = s.store_id)
JOIN users u ON (u.user_id = us.user_id)
WHERE u.status = ?
GROUP BY s.store_id, u.user_id
ORDER BY s.store_name, u.fullname";
$params = array("i",1);
$res = $this->db->cleanQueryArr($sql,$params);
if($this->db->getLastnumrows() > 0) {
$users = array();
foreach($res as $row) {
if(!isset($users[$row['user_id']])) {
$users[$row['user_id']] = array('user'=>$row['fullname'], 'stores'=>array());
}
$users[$row['user_id']]['stores'][$row['store_id']] = $row['store_name'];
}
return $users;
} else {
return false;
}
}
public function getUserStores($user_id) {
$sql = "SELECT s.*
FROM user_stores u
JOIN stores s ON (u.store_id = s.store_id)
WHERE u.user_id = ?";
$params = array("i",$user_id);
$res = $this->db->cleanQueryArr($sql,$params);
$stores = array();
if($this->db->getLastnumrows() > 0) {
foreach($res as $row) {
$stores[$row['store_id']] = $row;
}
}
return $stores;
}
public function getRoles() {
$sql = "SELECT * FROM user_control u";
$res = $this->db->queryArr($sql);
return $res;
}
public function getUserRoles($user_id) {
$sql = "SELECT control_id
FROM user_roles r
WHERE user_id = $user_id";
$res = $this->db->queryArr($sql);
$roles = array();
foreach($res as $row) { array_push($roles, $row['control_id']); }
return $roles;
}
public function getUserByName($username) {
$sql = "SELECT user_id FROM users WHERE username = ?";
$params = array("s",$username);
$res = $this->db->cleanQueryArr($sql,$params);
if($this->db->getLastnumrows() > 0) {
return $res[0]['user_id'];
} else {
return false;
}