|
|
<?php
|
|
|
class memberModel extends ModelBase{
|
|
|
|
|
|
//JASYRC 04JUN2010
|
|
|
public function getUsersOG($idgroup){
|
|
|
$query = "SELECT iduser, lastname, firstname FROM sis_user"
|
|
|
." WHERE iduser NOT IN (SELECT su.iduser FROM sis_members"
|
|
|
." AS sgur INNER JOIN sis_user AS su ON sgur.iduser = su.iduser"
|
|
|
." WHERE sgur.idgroup = $idgroup) AND usertype = 1";
|
|
|
$result = $this->db->prepare($query);
|
|
|
$result->execute();
|
|
|
$num_rows = $result->rowCount();
|
|
|
return array($result, $num_rows);
|
|
|
}
|
|
|
|
|
|
//JASYRC 04JUN2010
|
|
|
public function getMembers($idgroup){
|
|
|
$query = "SELECT sgur.idmember, sgur.iduser, su.username, su.firstname,"
|
|
|
." su.lastname, sgur.idgxr, sgur.state"
|
|
|
." FROM sis_members AS sgur INNER JOIN sis_user AS su"
|
|
|
." ON sgur.iduser = su.iduser WHERE sgur.idgroup = $idgroup"
|
|
|
." ORDER BY sgur.idgxr";
|
|
|
$result = $this->db->prepare($query);
|
|
|
$result->execute();
|
|
|
$num_rows = $result->rowCount();
|
|
|
return array($result, $num_rows);
|
|
|
}
|
|
|
|
|
|
//JASYRC 04JUN2010
|
|
|
function getGroup($group){
|
|
|
$query = "SELECT * FROM sis_group WHERE idgroup = $group";
|
|
|
$result = $this->db->prepare($query);
|
|
|
$result->execute();
|
|
|
return $result;
|
|
|
}
|
|
|
|
|
|
//JASYRC 07JUN2010
|
|
|
function getRoles($group){
|
|
|
$query = "SELECT idgxr, alias FROM sis_groupxroles"
|
|
|
." WHERE idgroup = $group ORDER BY idrole";
|
|
|
$result = $this->db->prepare($query);
|
|
|
$result->execute();
|
|
|
return $result;
|
|
|
}
|
|
|
|
|
|
//JASYRC 04JUN2010
|
|
|
function add($data_member){
|
|
|
$query = "INSERT INTO sis_members( idgroup, iduser, idgxr, state)"
|
|
|
." VALUES ( ".$data_member['idgroup'].", ".$data_member['iduser'].","
|
|
|
." ".$data_member['idrole'].", 1)";
|
|
|
$result = $this->db->prepare($query);
|
|
|
$result->execute();
|
|
|
return $result;
|
|
|
}
|
|
|
|
|
|
//JASYRC 07JUN2010
|
|
|
function edit($idmember){
|
|
|
$query = "SELECT idmember, idgxr, idgroup FROM sis_members WHERE idmember = $idmember";
|
|
|
$result = $this->db->prepare($query);
|
|
|
$result->execute();
|
|
|
return $result;
|
|
|
}
|
|
|
|
|
|
//JASYRC 07JUN2010
|
|
|
function update($data_member){
|
|
|
$query = "UPDATE sis_members SET idgxr = ".$data_member['idrole']
|
|
|
." WHERE idmember = ".$data_member['idmember'];
|
|
|
$result = $this->db->prepare($query);
|
|
|
$result->execute();
|
|
|
return $result;
|
|
|
}
|
|
|
|
|
|
//JASYRC 08JUN2010
|
|
|
function remove($member){
|
|
|
$query = "DELETE FROM sis_members WHERE idmember = $member";
|
|
|
$result = $this->db->prepare($query);
|
|
|
$result->execute();
|
|
|
return $result;
|
|
|
}
|
|
|
}
|
|
|
?>
|
|
|
|
