1: <?php
 2: 
 3: namespace GLFramework\Model;
 4: use GLFramework\Model;
 5: 
 6: /**
 7:  * Created by PhpStorm.
 8:  * User: manus
 9:  * Date: 13/1/16
10:  * Time: 20:44
11:  */
12: class User extends Model
13: {
14:     var $id;
15:     var $user_name;
16:     var $password;
17:     var $privilegios;
18:     var $nombre;
19:     var $email;
20:     var $admin;
21: 
22:     protected $table_name = "user";
23:     protected $definition = array(
24:         'index' => 'id',
25:         'fields' => array(
26:             'user_name' => "varchar(20)",
27:             'password' => "varchar(200)",
28:             'privilegios' => "text",
29:             'admin' => "int(11)",
30:             'nombre' => "text",
31:             'email' => "text",
32:         )
33:     );
34: 
35:     protected $hidden = array('password');
36: 
37:     public function getByUserPassword($user, $password)
38:     {
39:         return $this->db->select_first("SELECT * FROM {$this->table_name} WHERE user_name = '$user' AND password = '$password'");
40: 
41:     }
42: 
43:     public function encrypt($pass)
44:     {
45:         return md5($pass);
46:     }
47: 
48:     public function getPages()
49:     {
50:         $pages = new Page();
51:         $userPages = new UserPage();
52:         $sql = "SELECT * FROM " . $userPages->getTableName() . " as up
53:         LEFT JOIN {$pages->getTableName()} as p ON up.id_page = p.id
54:         WHERE up.id_user = " . $this->id;
55: 
56:         return $this->db->select($sql);
57:     }
58: }