class mw_data_users extends mw_data{
var $users;
- var $_user;
- var $user_status;
- var $action_status;
+ var $user;
+ var $roles;
+ var $actions_roles;
# ----------------------------------------------------------------------------------------
# users
#
- function users($start = 0, $alpha = null, $status = null){
+ function users($start = 0, $alpha = null, $id_role = null){
$sgbd = $this->sgbd();
$env = $this->env();
$users = array("list" => array(), "total" => 0);
$FROM = " FROM #--users";
$WHERE = "";
$WHERE .= (isset($alpha) ? ($WHERE ? " AND" : " WHERE")." LEFT(login, 1)=".$this->eq($alpha) : "");
- if(isset($status)){
- $SELECT .= ", #--users_roles.id_role as status";
+ if(isset($id_role)){
+ $SELECT .= ", #--users_roles.id_role";
$FROM .=
" LEFT JOIN #--users_roles ON ("
." #--users_roles.id_user=#--users.id"
- ." AND #--users_roles.id_role=".$this->eq($status)
+ ." AND #--users_roles.id_role=".$this->eq($id_role)
.")";
$WHERE .= ($WHERE ? " AND" : " WHERE")." mw_users_roles.id_role IS NOT NULL";
}
while($v_rst = $sgbd->fetch_assoc($rst)) $users["list"][$v_rst["id"]] = $v_rst;
$sgbd->free_result($rst);
foreach($users["list"] as $id_user => $user){
- if(($status = $this->list_user_status($id_user)) !== false){
- $users["list"][$id_user]["status"] = $status;
+ if(($roles = $this->list_user_roles($id_user)) !== false){
+ $users["list"][$id_user]["roles"] = $roles;
}
else{
$users = false;
return $users;
}
- function list_user_status($id_user){
+ function list_user_roles($id_user){
$sgbd = $this->sgbd();
- $status = array();
+ $roles = array();
try{
$rst = $sgbd->query("SELECT id_role FROM #--users_roles WHERE id_user=".$this->eq($id_user));
- while($v_rst = $sgbd->fetch_assoc($rst)) $status[] = $v_rst["id_role"];
+ while($v_rst = $sgbd->fetch_assoc($rst)) $roles[] = $v_rst["id_role"];
$sgbd->free_result($rst);
}
- catch(Exception $e) { $status = false; }
- return $status;
+ catch(Exception $e) { $roles = false; }
+ return $roles;
}
function user_by_id($id){
$rst = $sgbd->query($sql);
if($v_rst = $sgbd->fetch_assoc($rst)) $user = $v_rst;
$sgbd->free_result($rst);
- if(($status = $this->list_user_status($user["id"])) !== false) $user["status"] = $status;
+ if(($roles = $this->list_user_roles($user["id"])) !== false) $user["roles"] = $roles;
else $user = false;
}
catch(Exception $e) { $user = false; }
if($v_rst = $sgbd->fetch_assoc($rst)) $user = $v_rst;
$sgbd->free_result($rst);
if($user){
- if(($status = $this->list_user_status($user["id"])) !== false) $user["status"] = $status;
+ if(($roles = $this->list_user_roles($user["id"])) !== false) $user["roles"] = $roles;
else $user = false;
}
}
return $EXISTS;
}
- function add_user($login, $password, $email, $status){
+ function add_user($login, $password, $email, $roles){
$sgbd = $this->sgbd();
$user_id = false;
try{
.")";
$sgbd->query($sql);
$user_id = $sgbd->insert_id();
- foreach($status as $id_role){
+ foreach($roles as $id_role){
$sql =
"INSERT INTO #--users_roles(id_user, id_role) VALUES"
."( ".$user_id
return $user_id;
}
- function set_user($id, $login, $password, $email, $status){
+ function set_user($id, $login, $password, $email, $roles){
$sgbd = $this->sgbd();
try{
$sql =
$sgbd->query($sql);
$sql = "DELETE FROM #--users_roles WHERE id_user=".$this->eq($id);
$sgbd->query($sql);
- foreach($status as $id_role){
+ foreach($roles as $id_role){
$sql =
"INSERT INTO #--users_roles(id_user, id_role) VALUES"
."( ".$this->eq($id)
if(($user = $this->user($login)) !== false){
$sgbd = $this->sgbd();
try{
- $sql = "DELETE FROM #--users WHERE login=".$this->eq($login)." AND id=".$user["id"];
- $sgbd->query($sql);
$sql = "DELETE FROM #--users_roles WHERE id_user=".$user["id"];
$sgbd->query($sql);
+ $sql = "DELETE FROM #--users WHERE login=".$this->eq($login)." AND id=".$user["id"];
+ $sgbd->query($sql);
}
catch(Exception $e) { return false; }
}
}
# ----------------------------------------------------------------------------------------
- # status
+ # roles
#
- function init_user_status($status = array()){
+ function init_roles(){
$sgbd = $this->sgbd();
- $this->user_status = array();
+ $this->roles = array();
try{
$sql = "SELECT * FROM #--roles";
$rst = $sgbd->query($sql);
- while($v_rst = $sgbd->fetch_assoc($rst)) $this->user_status[$v_rst["id"]] = $v_rst;
+ while($v_rst = $sgbd->fetch_assoc($rst)) $this->roles[$v_rst["id"]] = $v_rst;
$sgbd->free_result($rst);
}
- catch(Exception $e) { $this->user_status = false; }
- return $this->user_status;
+ catch(Exception $e) { $this->roles = false; }
+ return $this->roles;
+ }
+
+ function roles(){
+ if(!isset($this->roles)) return false;
+ return $this->roles;
}
function add_role($nom, $intitule){
function clear_role_actions($id_role){
$sgbd = $this->sgbd();
try{
- $sql = "DELETE FROM #--action_status WHERE id_status=".$this->eq($id_role);
+ $sql = "DELETE FROM #--actions_roles WHERE id_role=".$this->eq($id_role);
$sgbd->query($sql);
}
catch(Exception $e) { return false; }
function add_role_action($id_role, $action){
$sgbd = $this->sgbd();
try{
- $sql = "INSERT INTO #--action_status(action, id_status) VALUES(".$this->eq($action).", ".$this->eq($id_role).")";
+ $sql = "INSERT INTO #--actions_roles(action, id_role) VALUES(".$this->eq($action).", ".$this->eq($id_role).")";
$sgbd->query($sql);
- $id_action_status = $sgbd->insert_id();
+ $id_action_role = $sgbd->insert_id();
}
- catch(Exception $e) { $id_action_status = false; }
- return $id_action_status;
+ catch(Exception $e) { $id_action_role = false; }
+ return $id_action_role;
}
function del_role($id_role){
return true;
}
- function status(){
- if(!isset($this->user_status)) return false;
- return $this->user_status;
- }
-
- function get_user_status(){
- $user_status = array();
+ function get_user_roles(){
+ $user_roles = array();
$user = $this->get_session_user();
if($user && isset($user["id"])){
$sgbd = $this->sgbd();
try{
$sql = "SELECT id_role FROM #--users_roles WHERE id_user=".$this->eq($user["id"]);
$rst = $sgbd->query($sql);
- while($v_rst = $sgbd->fetch_assoc($rst)) $user_status[] = $v_rst["id_role"];
+ while($v_rst = $sgbd->fetch_assoc($rst)) $user_roles[] = $v_rst["id_role"];
$sgbd->free_result($rst);
}
catch(Exception $_e){ return false; }
}
- else $user_status[] = 0;
- if(!$user_status) $user_status[] = 0;
- return $user_status;
+ else $user_roles[] = 0;
+ if(!$user_roles) $user_roles[] = 0;
+ return $user_roles;
}
- function init_action_status($status = array()){
- if(!isset($this->user_status)) return false;
- $this->action_status = $this->read_action_status();
- return $this->action_status;
+ function init_actions_roles(){
+ if(!isset($this->roles)) return false;
+ $this->actions_roles = $this->read_actions_roles();
+ return $this->actions_roles;
}
- function read_action_status($params = array()){
+ function read_actions_roles($params = array()){
$group_by_action = isset($params["group_by_action"]) ? $params["group_by_action"] : false;
$sgbd = $this->sgbd();
- $action_status = array();
+ $actions_roles = array();
try{
- $sql = "SELECT * FROM #--action_status";
+ $sql = "SELECT * FROM #--actions_roles";
$rst = $sgbd->query($sql);
while($v_rst = $sgbd->fetch_assoc($rst)){
if($group_by_action){
- if(!isset($action_status[$v_rst["action"]])) $action_status[$v_rst["action"]] = array();
- $action_status[$v_rst["action"]][] = $v_rst["id_status"];
+ if(!isset($actions_roles[$v_rst["action"]])) $actions_roles[$v_rst["action"]] = array();
+ $actions_roles[$v_rst["action"]][] = $v_rst["id_role"];
}
- else $action_status[$v_rst["id"]] = $v_rst;
+ else $actions_roles[$v_rst["id"]] = $v_rst;
}
$sgbd->free_result($rst);
}
- catch(Exception $e) { $action_status = false; }
- return $action_status;
+ catch(Exception $e) { $actions_roles = false; }
+ return $actions_roles;
}
- function get_action_status($mod, $controller = "index", $action = "index", $set_status = array()){
+ function get_action_roles($mod, $controller = "index", $action = "index"){
$sgbd = $this->sgbd();
- $status = array();
+ $roles = array();
try{
$sql =
- "SELECT action, id_status"
- ." FROM #--action_status"
+ "SELECT action, id_role"
+ ." FROM #--actions_roles"
." WHERE action=".$this->eq($mod)
." OR action=".$this->eq($mod."/".$controller)
." OR action=".$this->eq($mod."/".$controller."/".$action);
$rst = $sgbd->query($sql);
while($v_rst = $sgbd->fetch_assoc($rst)){
- if(!isset($status[$v_rst["action"]])) $status[$v_rst["action"]] = array();
- $status[$v_rst["action"]][$v_rst["id_status"]] = true;
+ if(!isset($roles[$v_rst["action"]])) $roles[$v_rst["action"]] = array();
+ $roles[$v_rst["action"]][$v_rst["id_role"]] = true;
}
$sgbd->free_result($rst);
}
- catch(Exception $e) { $status = false; }
- return $status;
+ catch(Exception $e) { $roles = false; }
+ return $roles;
}
function get_actions($id_role = null){
$env = $this->env();
if($actions = $env->get_actions()){
- if(($action_status = $this->read_action_status(array("group_by_action" => true))) !== false){
+ if(($actions_roles = $this->read_actions_roles(array("group_by_action" => true))) !== false){
foreach($actions as $module_name => $module){
if(isset($id_role)) $actions[$module_name]["module_allowed"] =
- isset($action_status[$module_name])
- && in_array($id_role, $action_status[$module_name]);
+ isset($actions_roles[$module_name])
+ && in_array($id_role, $actions_roles[$module_name]);
$actions[$module_name]["is_public"] =
- isset($action_status[$module_name])
- && in_array(0, $action_status[$module_name]);
+ isset($actions_roles[$module_name])
+ && in_array(0, $actions_roles[$module_name]);
foreach($module["controleurs"] as $controleur_name => $controleur){
if(isset($id_role)) $actions[$module_name]["controleurs"][$controleur_name]["controleur_allowed"] =
- isset($action_status[$module_name."/".$controleur_name])
- && in_array($id_role, $action_status[$module_name."/".$controleur_name]);
+ isset($actions_roles[$module_name."/".$controleur_name])
+ && in_array($id_role, $actions_roles[$module_name."/".$controleur_name]);
$actions[$module_name]["controleurs"][$controleur_name]["is_public"] =
- isset($action_status[$module_name."/".$controleur_name])
- && in_array(0, $action_status[$module_name."/".$controleur_name]);
+ isset($actions_roles[$module_name."/".$controleur_name])
+ && in_array(0, $actions_roles[$module_name."/".$controleur_name]);
foreach($controleur["als"] as $index_als => $al){
if($al["actions"]){
if(isset($id_role)){
$HAS_ACTION_NOT_ALLOWED = false;
foreach($al["actions"] as $action_name){
if(
- !isset($action_status[$module_name."/".$controleur_name."/".$action_name])
- || !in_array($id_role, $action_status[$module_name."/".$controleur_name."/".$action_name])
+ !isset($actions_roles[$module_name."/".$controleur_name."/".$action_name])
+ || !in_array($id_role, $actions_roles[$module_name."/".$controleur_name."/".$action_name])
){
$HAS_ACTION_NOT_ALLOWED = true;
break;
$HAS_ACTION_NOT_ALLOWED = false;
foreach($al["actions"] as $action_name){
if(
- !isset($action_status[$module_name."/".$controleur_name."/".$action_name])
- || !in_array(0, $action_status[$module_name."/".$controleur_name."/".$action_name])
+ !isset($actions_roles[$module_name."/".$controleur_name."/".$action_name])
+ || !in_array(0, $actions_roles[$module_name."/".$controleur_name."/".$action_name])
){
$HAS_ACTION_NOT_ALLOWED = true;
break;
$user = array();
}
}
- $this->_user = $user;
+ $this->user = $user;
return $user;
}
}
function get_session_user(){
- return $this->_user;
+ return $this->user;
}
# ----------------------------------------------------------------------------------------
function check_user_uploads_dir($user = null){
$env = $this->env();
- $user_dir = $env->path("content")."uploads/".(isset($user) ? $user : $this->_user["id"]);
+ if((!isset($user) || !$user) && !isset($this->user["id"])) return false;
+ $user_dir = $env->path("content")."uploads/".(isset($user) && $user ? $user : $this->user["id"]);
if(!file_exists($user_dir)) @mkdir($user_dir);
return file_exists($user_dir);
}