Passed
Push — master ( d67de9...7babde )
by Joe Nilson
02:15
created
model/core/residentes_edificaciones_tipo.php 1 patch
Spacing   +29 added lines, -29 removed lines patch added patch discarded remove patch
@@ -22,7 +22,7 @@  discard block
 block discarded – undo
22 22
  *
23 23
  * @author Joe Nilson <joenilson at gmail.com>
24 24
  */
25
-class residentes_edificaciones_tipo extends \fs_model{
25
+class residentes_edificaciones_tipo extends \fs_model {
26 26
     /**
27 27
      * El Id del tipo de edificacion
28 28
      * @var integer serial
@@ -39,19 +39,19 @@  discard block
 block discarded – undo
39 39
      */
40 40
     public $padre;
41 41
     public function __construct($t = FALSE) {
42
-        parent::__construct('residentes_edificaciones_tipo','plugins/residentes');
43
-        if($t){
42
+        parent::__construct('residentes_edificaciones_tipo', 'plugins/residentes');
43
+        if ($t) {
44 44
             $this->id = $t['id'];
45 45
             $this->descripcion = $t['descripcion'];
46 46
             $this->padre = $t['padre'];
47
-        }else{
47
+        }else {
48 48
             $this->id = null;
49 49
             $this->descripcion = null;
50 50
             $this->padre = null;
51 51
         }
52 52
     }
53 53
 
54
-    public function install(){
54
+    public function install() {
55 55
         return "insert into residentes_edificaciones_tipo (descripcion) VALUES ('Bloque');";
56 56
     }
57 57
 
@@ -65,17 +65,17 @@  discard block
 block discarded – undo
65 65
                 $lista[] = new residentes_edificaciones_tipo($d);
66 66
             }
67 67
             return $lista;
68
-        } else {
68
+        }else {
69 69
             return false;
70 70
         }
71 71
     }
72 72
 
73
-    public function get($id){
73
+    public function get($id) {
74 74
         $sql = "SELECT * FROM ".$this->table_name." WHERE id = ".$this->intval($id).";";
75 75
         $data = $this->db->select($sql);
76
-        if($data){
76
+        if ($data) {
77 77
             return new residentes_edificaciones_tipo($data[0]);
78
-        }else{
78
+        }else {
79 79
             return false;
80 80
         }
81 81
     }
@@ -86,43 +86,43 @@  discard block
 block discarded – undo
86 86
      * @param type $value string or integer
87 87
      * @return boolean|\FacturaScripts\model\residentes_edificaciones_tipo
88 88
      */
89
-    public function get_by_field($field,$value){
90
-        $query = (is_string($value))?$this->var2str($value):$this->intval($value);
89
+    public function get_by_field($field, $value) {
90
+        $query = (is_string($value)) ? $this->var2str($value) : $this->intval($value);
91 91
         $sql = "SELECT * FROM ".$this->table_name." WHERE ".strtoupper(trim($field))." = ".$query.";";
92 92
         $data = $this->db->select($sql);
93
-        if($data){
93
+        if ($data) {
94 94
             $lista = array();
95
-            foreach($data as $d){
96
-                $lista[] =  new residentes_edificaciones_tipo($d);
95
+            foreach ($data as $d) {
96
+                $lista[] = new residentes_edificaciones_tipo($d);
97 97
             }
98 98
             return $lista;
99
-        }else{
99
+        }else {
100 100
             return false;
101 101
         }
102 102
     }
103 103
 
104 104
     public function exists() {
105
-        if(is_null($this->id)){
105
+        if (is_null($this->id)) {
106 106
             return false;
107
-        }else{
107
+        }else {
108 108
             return $this->get($this->id);
109 109
         }
110 110
     }
111 111
 
112 112
     public function save() {
113
-        if($this->exists()){
113
+        if ($this->exists()) {
114 114
             $sql = "UPDATE ".$this->table_name." SET ".
115 115
                     "descripcion = ".$this->var2str($this->descripcion).", ".
116 116
                     "padre = ".$this->intval($this->padre)." ".
117 117
                     "WHERE id = ".$this->intval($this->id).";";
118 118
             return $this->db->exec($sql);
119
-        }else{
119
+        }else {
120 120
             $sql = "INSERT INTO ".$this->table_name." (descripcion, padre) VALUES (".
121 121
                     $this->var2str($this->descripcion).", ".
122 122
                     $this->intval($this->padre).");";
123
-            if($this->db->exec($sql)){
123
+            if ($this->db->exec($sql)) {
124 124
                 return $this->db->lastval();
125
-            }else{
125
+            }else {
126 126
                 return false;
127 127
             }
128 128
         }
@@ -132,24 +132,24 @@  discard block
 block discarded – undo
132 132
         return $this->db->exec($sql);
133 133
     }
134 134
 
135
-    public function jerarquia(){
135
+    public function jerarquia() {
136 136
         $lista = $this->all();
137
-        return ($lista)?$this->estructura($lista):null;
137
+        return ($lista) ? $this->estructura($lista) : null;
138 138
     }
139 139
 
140
-    public function estructura($lista, $raiz = 0){
140
+    public function estructura($lista, $raiz = 0) {
141 141
         $estructura = array();
142
-        foreach($lista as $key=>$item){
143
-            if($item->padre == $raiz){
142
+        foreach ($lista as $key=>$item) {
143
+            if ($item->padre == $raiz) {
144 144
                 unset($lista[$key]);
145
-                $estructura[]=array(
145
+                $estructura[] = array(
146 146
                     'id'=>$item->id,
147 147
                     'text'=>$item->descripcion,
148 148
                     'padre'=>$item->padre,
149
-                    'nodes'=>$this->estructura($lista,$item->id)
149
+                    'nodes'=>$this->estructura($lista, $item->id)
150 150
                 );
151 151
             }
152 152
         }
153
-        return empty($estructura)?null:$estructura;
153
+        return empty($estructura) ?null:$estructura;
154 154
     }
155 155
 }
Please login to merge, or discard this patch.
model/core/residentes_edificaciones_mapa.php 1 patch
Spacing   +44 added lines, -44 removed lines patch added patch discarded remove patch
@@ -21,7 +21,7 @@  discard block
 block discarded – undo
21 21
  *
22 22
  * @author Joe Nilson <joenilson at gmail.com>
23 23
  */
24
-class residentes_edificaciones_mapa extends \fs_model{
24
+class residentes_edificaciones_mapa extends \fs_model {
25 25
     /**
26 26
      * ID correlativo de cada linea
27 27
      * @var integer
@@ -71,7 +71,7 @@  discard block
 block discarded – undo
71 71
             $this->numero = $t['numero'];
72 72
             $this->padre_tipo = $t['padre_tipo'];
73 73
             $this->padre_id = $t['padre_id'];
74
-        } else {
74
+        }else {
75 75
             $this->id = null;
76 76
             $this->id_tipo = null;
77 77
             $this->codigo_edificacion = null;
@@ -82,21 +82,21 @@  discard block
 block discarded – undo
82 82
         $this->edificaciones_tipo = new \residentes_edificaciones_tipo();
83 83
     }
84 84
 
85
-    public function install(){
85
+    public function install() {
86 86
         return "";
87 87
     }
88 88
 
89
-    public function all(){
89
+    public function all() {
90 90
         $sql = "SELECT * FROM ".$this->table_name." ORDER BY id_tipo,codigo_edificacion";
91 91
         $data = $this->db->select($sql);
92
-        if($data){
92
+        if ($data) {
93 93
             $lista = array();
94
-            foreach($data as $d){
94
+            foreach ($data as $d) {
95 95
                 $item = new residentes_edificaciones_mapa($d);
96 96
                 $lista[] = $item;
97 97
             }
98 98
             return $lista;
99
-        }else{
99
+        }else {
100 100
             return false;
101 101
         }
102 102
     }
@@ -108,29 +108,29 @@  discard block
 block discarded – undo
108 108
      * @param type $padre_tipo integer
109 109
      * @return \FacturaScripts\model\residentes_edificaciones_mapa|boolean
110 110
      */
111
-    public function get($id){
111
+    public function get($id) {
112 112
         $sql = "SELECT * FROM ".$this->table_name.
113 113
                 " WHERE id = ".$this->intval($id).";";
114 114
         $data = $this->db->select($sql);
115
-        if($data){
115
+        if ($data) {
116 116
             $item = new residentes_edificaciones_mapa($data[0]);
117 117
             $item->desc_id = $this->edificaciones_tipo->get($item->id_tipo)->descripcion;
118 118
             return $item;
119
-        }else{
119
+        }else {
120 120
             return false;
121 121
         }
122 122
     }
123 123
 
124
-    public function getEstructura(){
124
+    public function getEstructura() {
125 125
         $sql = "SELECT * FROM ".$this->table_name." WHERE codigo_edificacion = ".$this->var2str($this->codigo_edificacion)." AND ".
126 126
                 " codigo_padre = ".$this->var2str($this->codigo_padre)." AND id_tipo = ".$this->intval($this->id_tipo)." AND ".
127 127
                 " padre_tipo = ".$this->intval($this->padre_tipo)." AND padre_id = ".$this->intval($this->padre_id).";";
128 128
         $data = $this->db->select($sql);
129
-        if($data){
129
+        if ($data) {
130 130
             $item = new residentes_edificaciones_mapa($data[0]);
131 131
             $item->desc_id = $this->edificaciones_tipo->get($item->id_tipo)->descripcion;
132 132
             return $item;
133
-        }else{
133
+        }else {
134 134
             return false;
135 135
         }
136 136
     }
@@ -141,34 +141,34 @@  discard block
 block discarded – undo
141 141
      * @param type $value string
142 142
      * @return boolean|\FacturaScripts\model\residentes_edificaciones_mapa
143 143
      */
144
-    public function get_by_field($field,$value){
145
-        $query = (is_string($value))?$this->var2str($value):$this->intval($value);
144
+    public function get_by_field($field, $value) {
145
+        $query = (is_string($value)) ? $this->var2str($value) : $this->intval($value);
146 146
         $sql = "SELECT rem.*, ret.descripcion FROM ".$this->table_name." as rem, residentes_edificaciones_tipo as ret ".
147 147
                 " WHERE ".strtoupper(trim($field))." = ".$query." AND rem.id_tipo = ret.id order by codigo_edificacion ASC;";
148 148
         $data = $this->db->select($sql);
149
-        if($data){
149
+        if ($data) {
150 150
             $lista = array();
151
-            foreach($data as $d){
151
+            foreach ($data as $d) {
152 152
                 $item = new residentes_edificaciones_mapa($d);
153 153
                 $item->desc_id = $d['descripcion'];
154 154
                 $lista[] = $item;
155 155
             }
156 156
             return $lista;
157
-        }else{
157
+        }else {
158 158
             return false;
159 159
         }
160 160
     }
161 161
 
162 162
     public function exists() {
163
-        if(!$this->getEstructura()){
163
+        if (!$this->getEstructura()) {
164 164
             return false;
165
-        }else{
165
+        }else {
166 166
             return $this->getEstructura();
167 167
         }
168 168
     }
169 169
 
170 170
     public function save() {
171
-        if($this->exists()){
171
+        if ($this->exists()) {
172 172
             $sql = "UPDATE ".$this->table_name." SET ".
173 173
                     " codigo_edificacion = ".$this->var2str($this->codigo_edificacion).", ".
174 174
                     " codigo_padre = ".$this->var2str($this->codigo_padre).", ".
@@ -178,7 +178,7 @@  discard block
 block discarded – undo
178 178
                     " padre_id = ".$this->intval($this->padre_id)." ".
179 179
                     "WHERE id = ".$this->intval($this->id).";";
180 180
             return $this->db->exec($sql);
181
-        }else{
181
+        }else {
182 182
             $sql = "INSERT INTO ".$this->table_name." (id_tipo, codigo_edificacion, codigo_padre, numero, padre_tipo, padre_id) VALUES (".
183 183
                     $this->intval($this->id_tipo).", ".
184 184
                     $this->var2str($this->codigo_edificacion).", ".
@@ -186,9 +186,9 @@  discard block
 block discarded – undo
186 186
                     $this->var2str($this->numero).", ".
187 187
                     $this->intval($this->padre_tipo).", ".
188 188
                     $this->intval($this->padre_id).");";
189
-            if($this->db->exec($sql)){
189
+            if ($this->db->exec($sql)) {
190 190
                 return true;
191
-            }else{
191
+            }else {
192 192
                 return false;
193 193
             }
194 194
         }
@@ -200,11 +200,11 @@  discard block
 block discarded – undo
200 200
         return $this->db->exec($sql);
201 201
     }
202 202
 
203
-    private function pertenencia($d){
203
+    private function pertenencia($d) {
204 204
         $codigo_interno = $d->codigo_interno;
205 205
         $piezas = \json_decode($codigo_interno);
206 206
         $lista = array();
207
-        foreach($piezas as $id=>$data){
207
+        foreach ($piezas as $id=>$data) {
208 208
             $pertenencia = new \stdClass();
209 209
             $pertenencia->id = $id;
210 210
             $pertenencia->desc_id = $this->edificaciones_tipo->get($id)->descripcion;
@@ -215,47 +215,47 @@  discard block
 block discarded – undo
215 215
         return $lista;
216 216
     }
217 217
 
218
-    public function buscar_ubicacion_inmueble($id,$linea){
219
-        $inicio_busqueda = ($linea==0)?"{\"":"{%\"";
218
+    public function buscar_ubicacion_inmueble($id, $linea) {
219
+        $inicio_busqueda = ($linea == 0) ? "{\"" : "{%\"";
220 220
         $sql = "SELECT * FROM ".$this->table_name." WHERE codigo_interno LIKE '".$inicio_busqueda.$id."\":%}' ORDER BY codigo;";
221 221
         $data = $this->db->select($sql);
222
-        if($data){
222
+        if ($data) {
223 223
             $lista = array();
224
-            foreach($data as $d){
224
+            foreach ($data as $d) {
225 225
                 $l = new residentes_edificaciones_mapa($d);
226 226
                 $lista[] = $this->pertenencia($l);
227 227
             }
228 228
             return $lista;
229
-        }else{
229
+        }else {
230 230
             return false;
231 231
         }
232 232
     }
233 233
 
234
-    public function buscar_cantidad_inmuebles($id,$linea){
235
-        $inicio_busqueda = ($linea==0)?"{\"":"{%\"";
234
+    public function buscar_cantidad_inmuebles($id, $linea) {
235
+        $inicio_busqueda = ($linea == 0) ? "{\"" : "{%\"";
236 236
         $sql = "SELECT DISTINCT codigo FROM ".$this->table_name." WHERE codigo_interno LIKE '".$inicio_busqueda.$id."\":%}' ORDER BY codigo;";
237 237
         $data = $this->db->select($sql);
238
-        if($data){
238
+        if ($data) {
239 239
             $lista = array();
240
-            foreach($data as $d){
240
+            foreach ($data as $d) {
241 241
                 $l = $this->get_by_field('codigo', $d['codigo']);
242 242
                 $lista[] = $l;
243 243
             }
244 244
             return $lista;
245
-        }else{
245
+        }else {
246 246
             return false;
247 247
         }
248 248
     }
249 249
 
250
-    public function generar_mapa(){
250
+    public function generar_mapa() {
251 251
         $mapa = array();
252 252
         $linea = 0;
253
-        foreach($this->edificaciones_tipo->all() as $data){
254
-            if($linea==1){
253
+        foreach ($this->edificaciones_tipo->all() as $data) {
254
+            if ($linea == 1) {
255 255
                 break;
256 256
             }
257
-            $items = $this->buscar_cantidad_inmuebles($data->id,$data->padre);
258
-            foreach($items as $inmueble){
257
+            $items = $this->buscar_cantidad_inmuebles($data->id, $data->padre);
258
+            foreach ($items as $inmueble) {
259 259
                 $mapa[$data->id][] = $inmueble;
260 260
             }
261 261
             $linea++;
@@ -263,12 +263,12 @@  discard block
 block discarded – undo
263 263
         return $mapa;
264 264
     }
265 265
 
266
-    public function tiene_hijos(){
266
+    public function tiene_hijos() {
267 267
         $sql = "SELECT count(*) as cantidad FROM ".$this->table_name." WHERE padre_id = ".$this->intval($this->id).";";
268 268
         $data = $this->db->select($sql);
269
-        if($data){
269
+        if ($data) {
270 270
             return $data[0]['cantidad'];
271
-        }else{
271
+        }else {
272 272
             return false;
273 273
         }
274 274
     }
Please login to merge, or discard this patch.
model/core/residentes_edificaciones.php 1 patch
Spacing   +30 added lines, -30 removed lines patch added patch discarded remove patch
@@ -21,7 +21,7 @@  discard block
 block discarded – undo
21 21
  *
22 22
  * @author Joe Nilson <joenilson at gmail.com>
23 23
  */
24
-class residentes_edificaciones extends \fs_model{
24
+class residentes_edificaciones extends \fs_model {
25 25
     /**
26 26
      * El Id de la de edificacion
27 27
      * @var integer serial
@@ -95,8 +95,8 @@  discard block
 block discarded – undo
95 95
     public $cliente_info;
96 96
     public $cliente_vehiculo;
97 97
     public function __construct($t = FALSE) {
98
-        parent::__construct('residentes_edificaciones','plugins/residentes');
99
-        if($t){
98
+        parent::__construct('residentes_edificaciones', 'plugins/residentes');
99
+        if ($t) {
100 100
             $this->id = $t['id'];
101 101
             $this->iddireccion = $t['iddireccion'];
102 102
             $this->id_edificacion = $t['id_edificacion'];
@@ -109,7 +109,7 @@  discard block
 block discarded – undo
109 109
             $this->ocupado = $this->str2bool($t['ocupado']);
110 110
             $this->fecha_ocupacion = $t['fecha_ocupacion'];
111 111
             $this->fecha_disponibilidad = $t['fecha_disponibilidad'];
112
-        }else{
112
+        }else {
113 113
             $this->id = null;
114 114
             $this->iddireccion = 0;
115 115
             $this->id_edificacion = null;
@@ -147,7 +147,7 @@  discard block
 block discarded – undo
147 147
     {
148 148
         if (!is_null($this->id)) {
149 149
             return FS_PATH.'index.php?page=ver_residente&id='.$this->id;
150
-        } else {
150
+        }else {
151 151
             return FS_PATH.'index.php?page=residentes';
152 152
         }
153 153
     }
@@ -177,7 +177,7 @@  discard block
 block discarded – undo
177 177
                 $lista[] = $item;
178 178
             }
179 179
             return $lista;
180
-        } else {
180
+        }else {
181 181
             return false;
182 182
         }
183 183
     }
@@ -198,15 +198,15 @@  discard block
 block discarded – undo
198 198
         return $this->listaInfo($data);
199 199
     }
200 200
 
201
-    public function get($id){
201
+    public function get($id) {
202 202
         $sql = "SELECT * FROM ".$this->table_name." WHERE id = ".$this->intval($id).";";
203 203
         $data = $this->db->select($sql);
204
-        if($data){
204
+        if ($data) {
205 205
             $item = new residentes_edificaciones($data[0]);
206 206
             $item->pertenencia = $this->pertenencia($item);
207 207
             $this->info($item);
208 208
             return $item;
209
-        }else{
209
+        }else {
210 210
             return false;
211 211
         }
212 212
     }
@@ -217,8 +217,8 @@  discard block
 block discarded – undo
217 217
      * @param type $value string
218 218
      * @return boolean|\FacturaScripts\model\residentes_edificaciones
219 219
      */
220
-    public function get_by_field($field,$value){
221
-        $query = (is_string($value))?$this->var2str($value):$this->intval($value);
220
+    public function get_by_field($field, $value) {
221
+        $query = (is_string($value)) ? $this->var2str($value) : $this->intval($value);
222 222
         $sql = "SELECT * FROM ".$this->table_name." WHERE ".strtoupper(trim($field))." = ".$query.
223 223
             " ORDER BY codigo_interno,numero;";
224 224
         $data = $this->db->select($sql);
@@ -229,7 +229,7 @@  discard block
 block discarded – undo
229 229
     {
230 230
         if (is_null($this->id)) {
231 231
             return false;
232
-        } else {
232
+        }else {
233 233
             return $this->get($this->id);
234 234
         }
235 235
     }
@@ -251,7 +251,7 @@  discard block
 block discarded – undo
251 251
                     "ocupado = ".$this->var2str($this->ocupado)." ".
252 252
                     "WHERE id = ".$this->intval($this->id).";";
253 253
             return $this->db->exec($sql);
254
-        } else {
254
+        }else {
255 255
             $sql = "INSERT INTO ".$this->table_name." (id_edificacion, iddireccion, codigo, codigo_interno, numero, ubicacion, coordenadas,codcliente, ocupado, fecha_ocupacion, fecha_disponibilidad) VALUES (".
256 256
                     $this->intval($this->id_edificacion).", ".
257 257
                     $this->intval($this->iddireccion).", ".
@@ -266,7 +266,7 @@  discard block
 block discarded – undo
266 266
                     $this->var2str($this->fecha_disponibilidad).");";
267 267
             if ($this->db->exec($sql)) {
268 268
                 return $this->db->lastval();
269
-            } else {
269
+            }else {
270 270
                 return false;
271 271
             }
272 272
         }
@@ -308,7 +308,7 @@  discard block
 block discarded – undo
308 308
 
309 309
     public function buscar_ubicacion_inmueble($id, $linea)
310 310
     {
311
-        $inicio_busqueda = ($linea===0)?"{\"":"{%\"";
311
+        $inicio_busqueda = ($linea === 0) ? "{\"" : "{%\"";
312 312
         $sql = "SELECT * FROM ".$this->table_name." WHERE codigo_interno LIKE '".
313 313
             $inicio_busqueda.$id."\":%}' ORDER BY codigo;";
314 314
         $data = $this->db->select($sql);
@@ -319,14 +319,14 @@  discard block
 block discarded – undo
319 319
                 $lista[] = $this->pertenencia($l);
320 320
             }
321 321
             return $lista;
322
-        } else {
322
+        }else {
323 323
             return false;
324 324
         }
325 325
     }
326 326
 
327
-    public function buscar_cantidad_inmuebles($id,$linea)
327
+    public function buscar_cantidad_inmuebles($id, $linea)
328 328
     {
329
-        $inicio_busqueda = ($linea===0)?"{\"":"{%\"";
329
+        $inicio_busqueda = ($linea === 0) ? "{\"" : "{%\"";
330 330
         $sql = "SELECT DISTINCT codigo FROM ".$this->table_name." WHERE codigo_interno LIKE '".
331 331
             $inicio_busqueda.$id."\":%}' ORDER BY codigo;";
332 332
         $data = $this->db->select($sql);
@@ -337,7 +337,7 @@  discard block
 block discarded – undo
337 337
                 $lista[] = $l;
338 338
             }
339 339
             return $lista;
340
-        } else {
340
+        }else {
341 341
             return false;
342 342
         }
343 343
     }
@@ -349,7 +349,7 @@  discard block
 block discarded – undo
349 349
         $data = $this->db->select($sql);
350 350
         if ($data) {
351 351
             return $data[0]['cantidad'];
352
-        } else {
352
+        }else {
353 353
             return false;
354 354
         }
355 355
     }
@@ -360,7 +360,7 @@  discard block
 block discarded – undo
360 360
         $mapa = array();
361 361
         $linea = 0;
362 362
         foreach ($edificaciones_tipo->all() as $data) {
363
-            if ($linea===1) {
363
+            if ($linea === 1) {
364 364
                 break;
365 365
             }
366 366
             $items = $this->buscar_cantidad_inmuebles($data->id, $data->padre);
@@ -376,19 +376,19 @@  discard block
 block discarded – undo
376 376
     {
377 377
         $sql = "SELECT * FROM ".$this->table_name." WHERE ";
378 378
         $OR = "";
379
-        if ($type=='inmueble') {
380
-            $sql.=" numero LIKE '%".strtoupper($query)."%' ";
381
-            $sql.=" OR codigo LIKE '%".strtoupper($query)."%' ";
382
-        } else {
379
+        if ($type == 'inmueble') {
380
+            $sql .= " numero LIKE '%".strtoupper($query)."%' ";
381
+            $sql .= " OR codigo LIKE '%".strtoupper($query)."%' ";
382
+        }else {
383 383
             if (is_int($query)) {
384
-                $sql.=" id_edificacion LIKE '%".$query."%' ";
385
-                $sql.=" id LIKE '%".$query."%' ";
384
+                $sql .= " id_edificacion LIKE '%".$query."%' ";
385
+                $sql .= " id LIKE '%".$query."%' ";
386 386
                 $OR = "OR";
387 387
             }
388
-            $sql.=" $OR numero LIKE '%".strtoupper($query)."%' ";
389
-            $sql.=" OR codigo LIKE '%".strtoupper($query)."%' ";
388
+            $sql .= " $OR numero LIKE '%".strtoupper($query)."%' ";
389
+            $sql .= " OR codigo LIKE '%".strtoupper($query)."%' ";
390 390
         }
391
-        $sql.=" ORDER BY codigo,numero";
391
+        $sql .= " ORDER BY codigo,numero";
392 392
         $data = $this->db->select($sql);
393 393
         $lista = array();
394 394
         if ($data) {
Please login to merge, or discard this patch.
controller/imprimir_factura_residentes.php 1 patch
Spacing   +12 added lines, -12 removed lines patch added patch discarded remove patch
@@ -58,7 +58,7 @@  discard block
 block discarded – undo
58 58
         if ($logo) {
59 59
             $type = pathinfo($logo, PATHINFO_EXTENSION);
60 60
             $data = file_get_contents($logo);
61
-            $this->factura_logo_uri = 'data:image/' . $type . ';base64,' . base64_encode($data);
61
+            $this->factura_logo_uri = 'data:image/'.$type.';base64,'.base64_encode($data);
62 62
         }
63 63
 
64 64
         if ($this->id) {
@@ -71,13 +71,13 @@  discard block
 block discarded – undo
71 71
         $fac = new factura_cliente();
72 72
         $this->factura = $fac->get($this->id);
73 73
         //Agregamos la cantidad de lineas multiplicadas por 4
74
-        $this->sizeFactura+= count($this->factura->get_lineas())*8;
74
+        $this->sizeFactura += count($this->factura->get_lineas()) * 8;
75 75
         //Agregamos la linea de separación del total
76
-        $this->sizeFactura+=4;
76
+        $this->sizeFactura += 4;
77 77
         //Agregamos las 3 lineas de Neto, FS_IVA y Total
78
-        $this->sizeFactura+=12;
78
+        $this->sizeFactura += 12;
79 79
         //Agregamos un espacio de 4 lineas aprox
80
-        $this->sizeFactura+=20;
80
+        $this->sizeFactura += 20;
81 81
         $cli = new cliente();
82 82
         $this->cliente = $cli->get($this->factura->codcliente);
83 83
         $facturas = $fac->all_from_cliente($this->factura->codcliente);
@@ -89,12 +89,12 @@  discard block
 block discarded – undo
89 89
                         'fecha'=>$f->fecha,
90 90
                         'monto'=>$f->total
91 91
                     );
92
-                    $this->sizeFactura+=4;
92
+                    $this->sizeFactura += 4;
93 93
                     $this->total_facturas_pendientes += $f->total;
94 94
                 }
95 95
             }
96 96
         }
97
-        $this->sizeFactura+=20;
97
+        $this->sizeFactura += 20;
98 98
     }
99 99
 
100 100
     public function url()
@@ -120,8 +120,8 @@  discard block
 block discarded – undo
120 120
                 'page_from' => __CLASS__,
121 121
                 'page_to' => __CLASS__,
122 122
                 'type' => 'head',
123
-                'text' => '<script src="' .
124
-                            FS_PATH .
123
+                'text' => '<script src="'.
124
+                            FS_PATH.
125 125
                             'plugins/residentes/view/js/jspdf.min.js" type="text/javascript"></script>',
126 126
                 'params' => ''
127 127
             ),
@@ -130,9 +130,9 @@  discard block
 block discarded – undo
130 130
                 'page_from' => __CLASS__,
131 131
                 'page_to' => __CLASS__,
132 132
                 'type' => 'head',
133
-                'text' => '<script src="' .
134
-                             FS_PATH .
135
-                            'plugins/residentes/view/js/jsPDF/plugins/split_text_to_size.min.js" ' .
133
+                'text' => '<script src="'.
134
+                             FS_PATH.
135
+                            'plugins/residentes/view/js/jsPDF/plugins/split_text_to_size.min.js" '.
136 136
                             'type="text/javascript"></script>',
137 137
                 'params' => ''
138 138
             ),
Please login to merge, or discard this patch.
controller/clientes_vehiculos.php 1 patch
Spacing   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -68,14 +68,14 @@  discard block
 block discarded – undo
68 68
             if ($accion === 'agregar') {
69 69
                 if ($vehiculo->save()) {
70 70
                     $this->new_message('Vehiculo agregado exitosamente');
71
-                } else {
71
+                }else {
72 72
                     $this->new_error_msg('No se pudieron agregar los datos del vehiculo, revise la información e ".
73 73
                     "intentelo nuevamente.');
74 74
                 }
75 75
             } elseif ($accion === 'eliminar') {
76 76
                 if ($vehiculo->delete()) {
77 77
                     $this->new_message('Vehiculo eliminado exitosamente');
78
-                } else {
78
+                }else {
79 79
                     $this->new_error_msg('No se pudieron eliminar los datos del vehiculo, revise la información e ".
80 80
                     "intentelo nuevamente.');
81 81
                 }
@@ -110,7 +110,7 @@  discard block
 block discarded – undo
110 110
         foreach ($extensiones as $ext) {
111 111
             $fsext0 = new fs_extension($ext);
112 112
             if (!$fsext0->save()) {
113
-                $this->new_error_msg('Imposible guardar los datos de la extensión ' . $ext['name'] . '.');
113
+                $this->new_error_msg('Imposible guardar los datos de la extensión '.$ext['name'].'.');
114 114
             }
115 115
         }
116 116
     }
Please login to merge, or discard this patch.
model/core/residentes_facturacion_programada_edificaciones.php 1 patch
Spacing   +21 added lines, -21 removed lines patch added patch discarded remove patch
@@ -36,15 +36,15 @@  discard block
 block discarded – undo
36 36
     public $procesado;
37 37
     
38 38
     public function __construct($t = FALSE) {
39
-        parent::__construct('residentes_fact_prog_edificaciones','plugins/residentes');
40
-        if($t){
39
+        parent::__construct('residentes_fact_prog_edificaciones', 'plugins/residentes');
40
+        if ($t) {
41 41
             $this->id = $t['id'];
42 42
             $this->idprogramacion = $t['idprogramacion'];
43 43
             $this->id_edificacion = $t['id_edificacion'];
44 44
             $this->codcliente = $t['codcliente'];
45 45
             $this->idfactura = $t['idfactura'];
46 46
             $this->procesado = $this->str2bool($t['procesado']);
47
-        }else{
47
+        }else {
48 48
             $this->id = null;
49 49
             $this->idprogramacion = null;
50 50
             $this->id_edificacion = null;
@@ -54,13 +54,13 @@  discard block
 block discarded – undo
54 54
         }
55 55
     }
56 56
 
57
-    public function install(){
57
+    public function install() {
58 58
         return "";
59 59
     }
60 60
     
61 61
     public function exists()
62 62
     {
63
-        if(is_null($this->id)) {
63
+        if (is_null($this->id)) {
64 64
             return false;
65 65
         }
66 66
         return true;
@@ -68,7 +68,7 @@  discard block
 block discarded – undo
68 68
     
69 69
     public function save()
70 70
     {
71
-        if($this->exists()){
71
+        if ($this->exists()) {
72 72
             $sql = "UPDATE ".$this->table_name." SET ".
73 73
             "idfactura = ".$this->intval($this->idfactura).", ".
74 74
             "codcliente = ".$this->var2str($this->codcliente).", ".
@@ -78,16 +78,16 @@  discard block
 block discarded – undo
78 78
             "WHERE id = ".$this->intval($this->id).";";
79 79
             $data = $this->db->exec($sql);
80 80
             return $data;
81
-        } else {
81
+        }else {
82 82
             $sql = "INSERT INTO ".$this->table_name.
83 83
             " (idprogramacion, id_edificacion, codcliente, procesado) VALUES (".
84 84
             $this->intval($this->idprogramacion).", ".
85 85
             $this->intval($this->id_edificacion).", ".
86 86
             $this->var2str($this->codcliente).", ".
87 87
             $this->var2str($this->procesado).");";
88
-            if($this->db->exec($sql)){
88
+            if ($this->db->exec($sql)) {
89 89
                 return true;
90
-            }else{
90
+            }else {
91 91
                 return false;
92 92
             }
93 93
         }
@@ -99,7 +99,7 @@  discard block
 block discarded – undo
99 99
         $sql = "select * from ".$this->table_name." WHERE id = ".$this->intval($id);
100 100
         $this->new_advice($sql);
101 101
         $data = $this->db->select($sql);
102
-        if($data) {
102
+        if ($data) {
103 103
             return new residentes_facturacion_programada_edificaciones($data[0]);
104 104
         }
105 105
         return false;
@@ -110,8 +110,8 @@  discard block
 block discarded – undo
110 110
         $sql = "select * from ".$this->table_name." WHERE idprogramacion = ".$this->intval($idProg)." ORDER BY id";
111 111
         $data = $this->db->select($sql);
112 112
         $lista = array();
113
-        if($data) {
114
-            foreach($data as $d) {
113
+        if ($data) {
114
+            foreach ($data as $d) {
115 115
                 $lista[] = new residentes_facturacion_programada_edificaciones($d);
116 116
             }
117 117
             return $lista;
@@ -125,8 +125,8 @@  discard block
 block discarded – undo
125 125
                 " AND procesado = FALSE ORDER BY id";
126 126
         $data = $this->db->select($sql);
127 127
         $lista = array();
128
-        if($data) {
129
-            foreach($data as $d) {
128
+        if ($data) {
129
+            foreach ($data as $d) {
130 130
                 $lista[] = new residentes_facturacion_programada_edificaciones($d);
131 131
             }
132 132
             return $lista;
@@ -138,8 +138,8 @@  discard block
 block discarded – undo
138 138
         $sql = "select * from ".$this->table_name." WHERE idprogramacion = ".$this->intval($idProg)." ORDER BY id";
139 139
         $data = $this->db->select($sql);
140 140
         $lista = array();
141
-        if($data) {
142
-            foreach($data as $d) {
141
+        if ($data) {
142
+            foreach ($data as $d) {
143 143
                  $item = new residentes_facturacion_programada_edificaciones($d);
144 144
                  $this->infoAdicional($item);
145 145
                  $lista[] = $item;
@@ -185,8 +185,8 @@  discard block
 block discarded – undo
185 185
                 ." AND "."estado = ".$this->var2str($status)." ORDER BY idprogramacion, id";
186 186
         $data = $this->db->select($sql);
187 187
         $lista = array();
188
-        if($data) {
189
-            foreach($data as $d) {
188
+        if ($data) {
189
+            foreach ($data as $d) {
190 190
                 $lista[] = new residentes_facturacion_programada_edificaciones($d);
191 191
             }
192 192
             return $lista;
@@ -199,8 +199,8 @@  discard block
 block discarded – undo
199 199
         $sql = "select * from ".$this->table_name." ORDER BY idprogramacion, id";
200 200
         $data = $this->db->select($sql);
201 201
         $lista = array();
202
-        if($data) {
203
-            foreach($data as $d) {
202
+        if ($data) {
203
+            foreach ($data as $d) {
204 204
                 $lista[] = new residentes_facturacion_programada_edificaciones($d);
205 205
             }
206 206
             return $lista;
@@ -212,7 +212,7 @@  discard block
 block discarded – undo
212 212
     {
213 213
         $sql = "DELETE from ".$this->table_name." WHERE id = ".$this->intval($this->id);
214 214
         $data = $this->db->exec($sql);
215
-        if($data) {
215
+        if ($data) {
216 216
             return true;
217 217
         }
218 218
         return false;   
Please login to merge, or discard this patch.
model/core/residentes_ayudas.php 1 patch
Spacing   +23 added lines, -23 removed lines patch added patch discarded remove patch
@@ -22,7 +22,7 @@  discard block
 block discarded – undo
22 22
  *
23 23
  * @author Joe Nilson <joenilson at gmail.com>
24 24
  */
25
-class residentes_ayudas extends \fs_model{
25
+class residentes_ayudas extends \fs_model {
26 26
     /**
27 27
      * El codigo de la ayuda ya sea para parentesco u ocupacion
28 28
      * @var string
@@ -39,19 +39,19 @@  discard block
 block discarded – undo
39 39
      */
40 40
     public $descripcion;
41 41
     public function __construct($t = FALSE) {
42
-        parent::__construct('residentes_ayudas','plugins/residentes');
43
-        if($t){
42
+        parent::__construct('residentes_ayudas', 'plugins/residentes');
43
+        if ($t) {
44 44
             $this->codigo = $t['codigo'];
45 45
             $this->tipo = $t['tipo'];
46 46
             $this->descripcion = $t['descripcion'];
47
-        }else{
47
+        }else {
48 48
             $this->codigo = null;
49 49
             $this->tipo = null;
50 50
             $this->descripcion = null;
51 51
         }
52 52
     }
53 53
 
54
-    public function install(){
54
+    public function install() {
55 55
         return "insert into residentes_ayudas (codigo,tipo, descripcion) VALUES ".
56 56
             "('EMPPUB','OCUPACION','Empleado Publico'),".
57 57
             "('EMPRI','OCUPACION','Empleado Privado'),".
@@ -65,66 +65,66 @@  discard block
 block discarded – undo
65 65
             "('HIJO','PARENTESCO','HermanHijo (a)');";
66 66
     }
67 67
 
68
-    public function all(){
68
+    public function all() {
69 69
         $sql = "SELECT * FROM ".$this->table_name." ORDER BY tipo,codigo";
70 70
         $data = $this->db->select($sql);
71
-        if($data){
71
+        if ($data) {
72 72
             $lista = array();
73
-            foreach($data as $d){
73
+            foreach ($data as $d) {
74 74
                 $lista[] = new residentes_ayudas($d);
75 75
             }
76 76
             return $lista;
77
-        }else{
77
+        }else {
78 78
             return false;
79 79
         }
80 80
     }
81 81
 
82
-    public function all_tipo($tipo){
82
+    public function all_tipo($tipo) {
83 83
         $sql = "SELECT * FROM ".$this->table_name." WHERE tipo = ".$this->var2str($tipo)." ORDER BY codigo";
84 84
         $data = $this->db->select($sql);
85
-        if($data){
85
+        if ($data) {
86 86
             $lista = array();
87
-            foreach($data as $d){
87
+            foreach ($data as $d) {
88 88
                 $lista[] = new residentes_ayudas($d);
89 89
             }
90 90
             return $lista;
91
-        }else{
91
+        }else {
92 92
             return false;
93 93
         }
94 94
     }
95 95
 
96
-    public function get($codigo,$tipo){
96
+    public function get($codigo, $tipo) {
97 97
         $sql = "SELECT * FROM ".$this->table_name." WHERE codigo = ".$this->var2str($codigo)." AND tipo = ".$this->var2str($tipo).";";
98 98
         $data = $this->db->select($sql);
99
-        if($data){
99
+        if ($data) {
100 100
             return new residentes_ayudas($data[0]);
101
-        }else{
101
+        }else {
102 102
             return false;
103 103
         }
104 104
     }
105 105
 
106 106
     public function exists() {
107
-        if(is_null($this->codigo)){
107
+        if (is_null($this->codigo)) {
108 108
             return false;
109
-        }else{
110
-            return $this->get($this->codigo,$this->tipo);
109
+        }else {
110
+            return $this->get($this->codigo, $this->tipo);
111 111
         }
112 112
     }
113 113
 
114 114
     public function save() {
115
-        if($this->exists()){
115
+        if ($this->exists()) {
116 116
             $sql = "UPDATE ".$this->table_name." SET ".
117 117
                     "descripcion = ".$this->var2str($this->descripcion)." ".
118 118
                     "WHERE codigo = ".$this->var2str($this->codigo)." AND tipo = ".$this->var2str($this->tipo).";";
119 119
             return $this->db->exec($sql);
120
-        }else{
120
+        }else {
121 121
             $sql = "INSERT INTO ".$this->table_name." (codigo, tipo, descripcion) VALUES (".
122 122
                     $this->var2str($this->codigo).", ".
123 123
                     $this->var2str($this->tipo).", ".
124 124
                     $this->var2str($this->descripcion).");";
125
-            if($this->db->exec($sql)){
125
+            if ($this->db->exec($sql)) {
126 126
                 return $this->db->lastval();
127
-            }else{
127
+            }else {
128 128
                 return false;
129 129
             }
130 130
         }
Please login to merge, or discard this patch.
model/core/residentes_vehiculos.php 1 patch
Spacing   +18 added lines, -18 removed lines patch added patch discarded remove patch
@@ -24,7 +24,7 @@  discard block
 block discarded – undo
24 24
  *
25 25
  * @author Joe Nilson <joenilson at gmail.com>
26 26
  */
27
-class residentes_vehiculos extends \fs_model{
27
+class residentes_vehiculos extends \fs_model {
28 28
     /**
29 29
      * El Id del vehiculo
30 30
      * @var integer serial
@@ -80,7 +80,7 @@  discard block
 block discarded – undo
80 80
             $this->vehiculo_placa = $t['vehiculo_placa'];
81 81
             $this->vehiculo_tipo = $t['vehiculo_tipo'];
82 82
             $this->codigo_tarjeta = $t['codigo_tarjeta'];
83
-        } else {
83
+        }else {
84 84
             $this->idvehiculo = null;
85 85
             $this->codcliente = null;
86 86
             $this->vehiculo_marca = null;
@@ -120,7 +120,7 @@  discard block
 block discarded – undo
120 120
                 $lista[] = $item;
121 121
             }
122 122
             return $lista;
123
-        } else {
123
+        }else {
124 124
             return false;
125 125
         }
126 126
     }
@@ -132,7 +132,7 @@  discard block
 block discarded – undo
132 132
         $data = $this->db->select($sql);
133 133
         if ($data) {
134 134
             return new residentes_vehiculos($data[0]);
135
-        } else {
135
+        }else {
136 136
             return false;
137 137
         }
138 138
     }
@@ -145,7 +145,7 @@  discard block
 block discarded – undo
145 145
      */
146 146
     public function get_by_field($field, $value)
147 147
     {
148
-        $query = (is_string($value))?$this->var2str($value):$this->intval($value);
148
+        $query = (is_string($value)) ? $this->var2str($value) : $this->intval($value);
149 149
         $sql = "SELECT * FROM ".$this->table_name." WHERE ".strtoupper(trim($field))." = ".$query.";";
150 150
         $data = $this->db->select($sql);
151 151
         if ($data) {
@@ -155,7 +155,7 @@  discard block
 block discarded – undo
155 155
                 $lista[] = $item;
156 156
             }
157 157
             return $lista;
158
-        } else {
158
+        }else {
159 159
             return false;
160 160
         }
161 161
     }
@@ -164,7 +164,7 @@  discard block
 block discarded – undo
164 164
     {
165 165
         if (is_null($this->idvehiculo)) {
166 166
             return false;
167
-        } else {
167
+        }else {
168 168
             return $this->get($this->codcliente, $this->idvehiculo);
169 169
         }
170 170
     }
@@ -182,7 +182,7 @@  discard block
 block discarded – undo
182 182
                     "WHERE idvehiculo = ".$this->intval($this->idvehiculo)." AND ".
183 183
                     "codcliente = ".$this->var2str($this->codcliente).";";
184 184
             return $this->db->exec($sql);
185
-        } else {
185
+        }else {
186 186
             $sql = "INSERT INTO ".$this->table_name." (codcliente, vehiculo_marca, vehiculo_modelo, vehiculo_color, ".
187 187
                 "vehiculo_placa, vehiculo_tipo, codigo_tarjeta) VALUES (".
188 188
                     $this->var2str($this->codcliente).", ".
@@ -194,7 +194,7 @@  discard block
 block discarded – undo
194 194
                     $this->var2str($this->codigo_tarjeta).");";
195 195
             if ($this->db->exec($sql)) {
196 196
                 return $this->db->lastval();
197
-            } else {
197
+            }else {
198 198
                 return false;
199 199
             }
200 200
         }
@@ -209,17 +209,17 @@  discard block
 block discarded – undo
209 209
         $clilist = array();
210 210
         $query = mb_strtolower($this->no_html($busqueda), 'UTF8');
211 211
 
212
-        $consulta = "SELECT * FROM " . $this->table_name . " WHERE ";
212
+        $consulta = "SELECT * FROM ".$this->table_name." WHERE ";
213 213
         if (is_numeric($query)) {
214
-            $consulta .= "(codigo_tarjeta LIKE '%" . $query . "%' OR CAST(idvehiculo as CHAR) = '%" . $query . "%')";
215
-        } else {
214
+            $consulta .= "(codigo_tarjeta LIKE '%".$query."%' OR CAST(idvehiculo as CHAR) = '%".$query."%')";
215
+        }else {
216 216
             $buscar = str_replace(' ', '%', $query);
217
-            $consulta .= "(lower(codigo_tarjeta) LIKE '%" . $buscar .
218
-                "%' OR lower(vehiculo_color) LIKE '%" . $buscar . "%'" .
219
-                " OR lower(vehiculo_marca) LIKE '%" . $buscar .
220
-                "%' OR lower(vehiculo_modelo) LIKE '%" . $buscar . "%'" .
221
-                " OR lower(vehiculo_placa) LIKE '%" . $buscar .
222
-                "%' OR lower(vehiculo_tipo) LIKE '%" . $buscar . "%')";
217
+            $consulta .= "(lower(codigo_tarjeta) LIKE '%".$buscar.
218
+                "%' OR lower(vehiculo_color) LIKE '%".$buscar."%'".
219
+                " OR lower(vehiculo_marca) LIKE '%".$buscar.
220
+                "%' OR lower(vehiculo_modelo) LIKE '%".$buscar."%'".
221
+                " OR lower(vehiculo_placa) LIKE '%".$buscar.
222
+                "%' OR lower(vehiculo_tipo) LIKE '%".$buscar."%')";
223 223
         }
224 224
         $consulta .= " ORDER BY codcliente ASC";
225 225
 
Please login to merge, or discard this patch.
model/core/residentes_informacion.php 1 patch
Spacing   +72 added lines, -72 removed lines patch added patch discarded remove patch
@@ -25,7 +25,7 @@  discard block
 block discarded – undo
25 25
  * @author Joe Nilson <joenilson at gmail.com>
26 26
  * @version 1
27 27
  */
28
-class residentes_informacion extends \fs_model{
28
+class residentes_informacion extends \fs_model {
29 29
     /**
30 30
      * Codigo del cliente
31 31
      * @var string
@@ -143,60 +143,60 @@  discard block
 block discarded – undo
143 143
     {
144 144
         parent::__construct('residentes_informacion', 'plugins/residentes');
145 145
         if ($t) {
146
-            $this->codcliente=$t['codcliente'];
147
-            $this->codigo=$t['codigo'];
148
-            $this->ocupantes=$t['ocupantes'];
149
-            $this->ocupantes5anos=$t['ocupantes5anos'];
150
-            $this->ocupantes12anos=$t['ocupantes12anos'];
151
-            $this->ocupantes18anos=$t['ocupantes18anos'];
152
-            $this->ocupantes30anos=$t['ocupantes30anos'];
153
-            $this->ocupantes50anos=$t['ocupantes50anos'];
154
-            $this->ocupantes70anos=$t['ocupantes70anos'];
155
-            $this->ocupantes71anos=$t['ocupantes71anos'];
156
-            $this->informacion_discapacidad=$t['informacion_discapacidad'];
157
-            $this->propietario=$this->str2bool($t['propietario']);
158
-            $this->profesion=$t['profesion'];
159
-            $this->ocupacion=$t['ocupacion'];
160
-            $this->ca_nombres=$t['ca_nombres'];
161
-            $this->ca_apellidos=$t['ca_apellidos'];
162
-            $this->ca_telefono=$t['ca_telefono'];
163
-            $this->ca_email=$t['ca_email'];
164
-            $this->ca_propietario=$this->str2bool($t['ca_propietario']);
165
-            $this->ca_parentesco=$t['ca_parentesco'];
166
-            $this->ca_parentesco_obs=$t['ca_parentesco_obs'];
167
-            $this->vehiculos=$t['vehiculos'];
168
-        } else {
169
-            $this->codcliente=NULL;
170
-            $this->codigo=NULL;
171
-            $this->ocupantes=NULL;
172
-            $this->ocupantes5anos=NULL;
173
-            $this->ocupantes12anos=NULL;
174
-            $this->ocupantes18anos=NULL;
175
-            $this->ocupantes30anos=NULL;
176
-            $this->ocupantes50anos=NULL;
177
-            $this->ocupantes70anos=NULL;
178
-            $this->ocupantes71anos=NULL;
179
-            $this->informacion_discapacidad=NULL;
180
-            $this->propietario='FALSE';
181
-            $this->profesion=NULL;
182
-            $this->ocupacion=NULL;
183
-            $this->ca_nombres=NULL;
184
-            $this->ca_apellidos=NULL;
185
-            $this->ca_telefono=NULL;
186
-            $this->ca_email=NULL;
187
-            $this->ca_propietario='FALSE';
188
-            $this->ca_parentesco=NULL;
189
-            $this->ca_parentesco_obs='';
190
-            $this->vehiculos=0;
146
+            $this->codcliente = $t['codcliente'];
147
+            $this->codigo = $t['codigo'];
148
+            $this->ocupantes = $t['ocupantes'];
149
+            $this->ocupantes5anos = $t['ocupantes5anos'];
150
+            $this->ocupantes12anos = $t['ocupantes12anos'];
151
+            $this->ocupantes18anos = $t['ocupantes18anos'];
152
+            $this->ocupantes30anos = $t['ocupantes30anos'];
153
+            $this->ocupantes50anos = $t['ocupantes50anos'];
154
+            $this->ocupantes70anos = $t['ocupantes70anos'];
155
+            $this->ocupantes71anos = $t['ocupantes71anos'];
156
+            $this->informacion_discapacidad = $t['informacion_discapacidad'];
157
+            $this->propietario = $this->str2bool($t['propietario']);
158
+            $this->profesion = $t['profesion'];
159
+            $this->ocupacion = $t['ocupacion'];
160
+            $this->ca_nombres = $t['ca_nombres'];
161
+            $this->ca_apellidos = $t['ca_apellidos'];
162
+            $this->ca_telefono = $t['ca_telefono'];
163
+            $this->ca_email = $t['ca_email'];
164
+            $this->ca_propietario = $this->str2bool($t['ca_propietario']);
165
+            $this->ca_parentesco = $t['ca_parentesco'];
166
+            $this->ca_parentesco_obs = $t['ca_parentesco_obs'];
167
+            $this->vehiculos = $t['vehiculos'];
168
+        }else {
169
+            $this->codcliente = NULL;
170
+            $this->codigo = NULL;
171
+            $this->ocupantes = NULL;
172
+            $this->ocupantes5anos = NULL;
173
+            $this->ocupantes12anos = NULL;
174
+            $this->ocupantes18anos = NULL;
175
+            $this->ocupantes30anos = NULL;
176
+            $this->ocupantes50anos = NULL;
177
+            $this->ocupantes70anos = NULL;
178
+            $this->ocupantes71anos = NULL;
179
+            $this->informacion_discapacidad = NULL;
180
+            $this->propietario = 'FALSE';
181
+            $this->profesion = NULL;
182
+            $this->ocupacion = NULL;
183
+            $this->ca_nombres = NULL;
184
+            $this->ca_apellidos = NULL;
185
+            $this->ca_telefono = NULL;
186
+            $this->ca_email = NULL;
187
+            $this->ca_propietario = 'FALSE';
188
+            $this->ca_parentesco = NULL;
189
+            $this->ca_parentesco_obs = '';
190
+            $this->vehiculos = 0;
191 191
         }
192 192
         $this->cliente = new cliente();
193 193
     }
194 194
 
195
-    public function install(){
195
+    public function install() {
196 196
         return "";
197 197
     }
198 198
 
199
-    public function info_adicional($i){
199
+    public function info_adicional($i) {
200 200
         $data = $this->cliente->get($i->codcliente);
201 201
         $i->nombre = $data->nombre;
202 202
         $i->telefono1 = $data->telefono1;
@@ -206,17 +206,17 @@  discard block
 block discarded – undo
206 206
         return $i;
207 207
     }
208 208
 
209
-    public function all(){
209
+    public function all() {
210 210
         $sql = "SELECT * FROM ".$this->table_name." ORDER BY codcliente";
211 211
         $data = $this->db->select($sql);
212
-        if($data){
212
+        if ($data) {
213 213
             $lista = array();
214
-            foreach($data as $d){
214
+            foreach ($data as $d) {
215 215
                 $item = new residentes_informacion($d);
216 216
                 $lista[] = $item->info_adicional($item);
217 217
             }
218 218
             return $lista;
219
-        }else{
219
+        }else {
220 220
             return false;
221 221
         }
222 222
     }
@@ -228,14 +228,14 @@  discard block
 block discarded – undo
228 228
      * @param type $padre_tipo integer
229 229
      * @return \FacturaScripts\model\residentes_informacion|boolean
230 230
      */
231
-    public function get($codcliente){
231
+    public function get($codcliente) {
232 232
         $sql = "SELECT * FROM ".$this->table_name.
233 233
                 " WHERE codcliente = ".$this->var2str($codcliente).";";
234 234
         $data = $this->db->select($sql);
235
-        if($data){
235
+        if ($data) {
236 236
             $item = new residentes_informacion($data[0]);
237 237
             return $item->info_adicional($item);
238
-        }else{
238
+        }else {
239 239
             return false;
240 240
         }
241 241
     }
@@ -246,32 +246,32 @@  discard block
 block discarded – undo
246 246
      * @param type $value string
247 247
      * @return boolean|\FacturaScripts\model\residentes_informacion
248 248
      */
249
-    public function get_by_field($field,$value){
250
-        $query = (is_string($value))?$this->var2str($value):$this->intval($value);
249
+    public function get_by_field($field, $value) {
250
+        $query = (is_string($value)) ? $this->var2str($value) : $this->intval($value);
251 251
         $sql = "SELECT * FROM ".$this->table_name." WHERE ".strtoupper(trim($field))." = ".$query.";";
252 252
         $data = $this->db->select($sql);
253
-        if($data){
253
+        if ($data) {
254 254
             $lista = array();
255
-            foreach($data as $d){
255
+            foreach ($data as $d) {
256 256
                 $item = new residentes_informacion($d);
257 257
                 $lista[] = $item->info_adicional($item);
258 258
             }
259 259
             return $lista;
260
-        }else{
260
+        }else {
261 261
             return false;
262 262
         }
263 263
     }
264 264
 
265 265
     public function exists() {
266
-        if(!$this->get($this->codcliente)){
266
+        if (!$this->get($this->codcliente)) {
267 267
             return false;
268
-        }else{
268
+        }else {
269 269
             return $this->get($this->codcliente);
270 270
         }
271 271
     }
272 272
 
273 273
     public function save() {
274
-        if($this->exists()){
274
+        if ($this->exists()) {
275 275
             $sql = "UPDATE ".$this->table_name." SET ".
276 276
             "codigo = ".$this->var2str($this->codigo).", ".
277 277
             "ocupantes = ".$this->intval($this->ocupantes).", ".
@@ -296,7 +296,7 @@  discard block
 block discarded – undo
296 296
             "vehiculos = ".$this->intval($this->vehiculos)." ".
297 297
             "WHERE codcliente = ".$this->var2str($this->codcliente).";";
298 298
             return $this->db->exec($sql);
299
-        }else{
299
+        }else {
300 300
             $sql = "INSERT INTO ".$this->table_name." (codcliente, codigo, ocupantes, ocupantes5anos, ocupantes12anos, ocupantes18anos, ocupantes30anos, ocupantes50anos, ocupantes70anos, ocupantes71anos, informacion_discapacidad, propietario, profesion, ocupacion, ca_nombres, ca_apellidos, ca_telefono, ca_email, ca_propietario, ca_parentesco, ca_parentesco_obs, vehiculos) VALUES (".
301 301
             $this->var2str($this->codcliente).", ".
302 302
             $this->var2str($this->codigo).", ".
@@ -320,9 +320,9 @@  discard block
 block discarded – undo
320 320
             $this->var2str($this->ca_parentesco).", ".
321 321
             $this->var2str($this->ca_parentesco_obs).", ".
322 322
             $this->intval($this->vehiculos).");";
323
-            if($this->db->exec($sql)){
323
+            if ($this->db->exec($sql)) {
324 324
                 return true;
325
-            }else{
325
+            }else {
326 326
                 return false;
327 327
             }
328 328
         }
@@ -336,14 +336,14 @@  discard block
 block discarded – undo
336 336
         $clilist = array();
337 337
         $query = mb_strtolower($this->no_html($busqueda), 'UTF8');
338 338
 
339
-        $consulta = "SELECT * FROM " . $this->table_name . " WHERE ";
339
+        $consulta = "SELECT * FROM ".$this->table_name." WHERE ";
340 340
         if (is_numeric($query)) {
341
-            $consulta .= "(ca_telefono LIKE '%" . $query . "%' OR codigo LIKE '%" . $query . "%')";
342
-        } else {
341
+            $consulta .= "(ca_telefono LIKE '%".$query."%' OR codigo LIKE '%".$query."%')";
342
+        }else {
343 343
             $buscar = str_replace(' ', '%', $query);
344
-            $consulta .= "(lower(ca_nombres) LIKE '%" . $buscar . "%' OR lower(ca_apellidos) LIKE '%" . $buscar . "%'"
345
-                    . " OR lower(ocupacion) LIKE '%" . $buscar . "%' OR lower(profesion) LIKE '%" . $buscar . "%'"
346
-                    . " OR lower(ca_email) LIKE '%" . $buscar . "%')";
344
+            $consulta .= "(lower(ca_nombres) LIKE '%".$buscar."%' OR lower(ca_apellidos) LIKE '%".$buscar."%'"
345
+                    . " OR lower(ocupacion) LIKE '%".$buscar."%' OR lower(profesion) LIKE '%".$buscar."%'"
346
+                    . " OR lower(ca_email) LIKE '%".$buscar."%')";
347 347
         }
348 348
         $consulta .= " ORDER BY codcliente ASC";
349 349
 
Please login to merge, or discard this patch.