jro_apps/pbase Commit - r4:5 · Jicamarca Repository

modificaciones del componente usuarios. Reduccion de codigo

arturo -

r4:5

parent child

trunk/administrator/components/com_users/UsersController.php +2 -3

                     $path = implode(DS, $url);
                     $flag = FALSE;
-                    $result = $user->getAllUsers();
+                    $data_list = $user->getAllUsers();
-                    $data_list = $result->fetchAll();
                     foreach($data_list as $userdata){
-                        if(strtolower($data_user['username']) == strtolower($userdata['username'])){$flag = TRUE; break;}
+                        if(strtolower($data_user['username']) == strtolower($userdata->username)){$flag = TRUE; break;}
                     }
                     if($flag === FALSE){

trunk/administrator/components/com_users/models/UsersModel.php +4 -24

                     return $cadena;
                 }
                 public function getStringUser($iduser){
                         //realizamos la consulta de todos los items
                         $query = $this->db->prepare('SELECT u.*  FROM sis_user AS u WHERE u.iduser = "'.$iduser.'" ');
                     return array($consulta,$paginas,$navegador);
                 }
-                function addUser($username, $password, $data_user){
-                    $query = "INSERT INTO sis_user( username, password, date_create, firstname, lastname, email,"
-                            ." photo, usertype, state ) VALUES ( '$username' , md5('$password'), '".date("Y-m-d H:i:s")."',"
-                            ." '".$data_user['firstname']."', '".$data_user['lastname']."', '".$data_user['email']."',"
-                            ." '".$data_user['urlphoto']."', 1, 4)";
-                    $result = $this->db->prepare($query);
-                    $result->execute();
-                    return $result;
                 function editUser($user){
                         $query = "SELECT * FROM sis_user WHERE iduser = '$user'";
                         $result = $this->db->prepare($query);
                         return $result;
                 }
-                function updateUser($user, $firstname, $lastname, $state){
-                        $query = "UPDATE sis_user SET firstname = '$firstname', lastname = '$lastname'"
-                                .", state = $state WHERE iduser = $user";
-                        $result = $this->db->prepare($query);
-                        $result->execute();
-                        return $result;
                 function delUser($user){
                         $query = "UPDATE sis_user SET state = 3 WHERE iduser = $user";
                         $result = $this->db->prepare($query);
                 }
                 public function getAllUsers(){
-                    $query = "SELECT username FROM sis_user WHERE usertype = 1";
+                    $str_query = "SELECT * FROM ".$this->tableName." WHERE usertype = 1";
-                    $result = $this->db->prepare($query);
+                    $this->setQuery($str_query);
-                    $result->execute();
+                    $query = $this->loadObjectList();
-                    return $result;
+                    return $query;
                 }
             }
             ?>

trunk/administrator/components/com_users/views/dolist.php +6 -6

             <?php
-                $html_select_pag = '<select onchange="window.location='.chr(39).'index.php?option=com_users&controller=Users&action=getUsers&inicio='.chr(39).'+this.value">';
+                $html_select_pag = '<select onchange="window.location='.chr(39).'index.php?option=com_users&controller=Users&action=dolist&inicio='.chr(39).'+this.value">';
                 $j = count($paginas);
                 for($i=0;$i<$j;$i++){
                 $html_select_pag .= "</select>";
                 $html_pagination  = '<ul class="mnu_pagination">';
-                $html_pagination .= '<li><a href="index.php?option=com_users&controller=Users&action=getUsers&inicio='.$navegador["fin"].'">';
+                $html_pagination .= '<li><a href="index.php?option=com_users&controller=Users&action=dolist&inicio='.$navegador["fin"].'">';
                 $html_pagination .= "Last</a></li>";
-                $html_pagination .= '<li><a href="index.php?option=com_users&controller=Users&action=getUsers&inicio='.$navegador["siguiente"].'">';
+                $html_pagination .= '<li><a href="index.php?option=com_users&controller=Users&action=dolist&inicio='.$navegador["siguiente"].'">';
                 $html_pagination .= "Next</a></li>";
                 $html_pagination .= '<li class="pages">Page'.$html_select_pag.'</li>';
-                $html_pagination .= '<li><a href="index.php?option=com_users&controller=Users&action=getUsers&inicio='.$navegador["anterior"].'">';
+                $html_pagination .= '<li><a href="index.php?option=com_users&controller=Users&action=dolist&inicio='.$navegador["anterior"].'">';
                 $html_pagination .= "Prev</a></li>";
-                $html_pagination .= '<li><a href="index.php?option=com_users&controller=Users&action=getUsers&inicio='.$navegador["inicio"].'">';
+                $html_pagination .= '<li><a href="index.php?option=com_users&controller=Users&action=dolist&inicio='.$navegador["inicio"].'">';
                 $html_pagination .= "Start</a></li>";
                 $html_pagination .= '</ul><div style="clear:both"></div>';
             ?>
                 <td align="center"><?php echo $datos_usuario['firstname']; ?></td>
                 <td align="center">
                     <?php if($datos_usuario['state'] == 1){ ?>
-                        <img src="../imagenes/usractive.jpeg" alt="Active" border="0" />
+                        <img src="images/system/tick.png" alt="Active" border="0" />
                     <?php } ?>
                     <?php if($datos_usuario['state'] == 2){ ?>
                         <img src="../imagenes/b_locked.png" alt="Locked" border="0" />

General Comments 0

Write
Preview

You need to be logged in to leave comments. Login now

No TODOs yet

	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