<?php
/**
* @package Main
*/
/**
* @package CoCoMa
*/
class GroupAssoc extends AppModel {
var $name = "GroupAssoc";
var $scopeModel;
var $userModel = "User";
var $groupModel = "Group";
/**
* Grant one or multiple users access to one record with in specific roles (groups)
* @param array $users - user id -> group id
* @param int $recordId
*/
function addUsers($users, $recordId)
{
if(!is_array($users) || empty($recordId))
return null;
foreach($users as $user_id => $group_id)
$tmp[]= "({$recordId}, {$user_id}, {$group_id})";
$inserts = join(",",$tmp);
$this->query("INSERT IGNORE INTO {$this->tablePrefix}{$this->table}
(".low($this->scopeModel)."_id, ".low($this->userModel)."_id, ".low($this->groupModel)."_id)
VALUES ".$inserts.";");
return $this->getAffectedRows();
}
/**
* update groups for one or multiple users in one record
* @param array $users - user id -> group id
* @param int $recordId
*/
function assignUsers($users, $recordId)
{
if(!is_array($users) || empty($recordId))
return null;
foreach($users as $user_id => $group_id)
$tmp[]= "({$recordId}, {$user_id}, {$group_id})";
$inserts = join(",",$tmp);
$this->query("REPLACE INTO {$this->tablePrefix}{$this->table} (".low($this->scopeModel)."_id, ".low($this->userModel)."_id, ".low($this->groupModel)."_id) VALUES {$inserts}");
return $this->getAffectedRows();
}
/**
*
* @param array $userId - id of user to deny access to $recordId
* @param int $recordId
*/
function removeUsers($users, $recordId)
{
if(empty($users) || empty($recordId))
return null;
foreach($users as $user_id)
$tmp[]= $user_id;
$toRemove=join(",",$tmp);
$this->query("DELETE IGNORE FROM {$this->tablePrefix}{$this->table}
WHERE ".low($this->scopeModel)."_id = {$recordId}
AND user_id IN ({$toRemove})");
return $this->getAffectedRows();
}
/**
* add multiple associations
* @param array $users - 2 dimensional array to insert - 'user_id', 'group_id', 'record_id'
* @param int $recordId
*/
function insertAssocs($assocs){
if(!is_array($assocs))
return null;
foreach($assocs as $assoc)
$tmp[]= "({$assoc[low($this->scopeModel)."_id"]}, {$assoc['user_id']}, {$assoc['group_id']})";
$inserts = join(",",$tmp);
$this->query("INSERT IGNORE INTO {$this->tablePrefix}{$this->table}
(".low($this->scopeModel)."_id, ".low($this->userModel)."_id, ".low($this->groupModel)."_id)
VALUES ".$inserts.";");
return $this->getAffectedRows();
}
}
?>