<?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;
    }
}
?>