jro_apps/pbase Files · trunk/models/_memberModel.php

modificaciones del componente usuarios. Reduccion de codigo

arturo - - Load All Authors

File last commit:

r0:1


                r4:5

Download file

             _memberModel.php
        
                    81 lines
            
             | 2.8 KiB
            
                | text/x-php
            
             |
                PhpLexer
            
             / trunk / models / _memberModel.php
          
                    History
                
                 |
                  Source
                 | Raw
                 |Copy content
                 |Copy permalink

        arturo
    
creando directorios base para el desarrollo

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

          }

      }

      ?>

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages

arturo creando directorios base para el desarrollo	r0	<?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;
		}
		}
		?>