Esempio n. 1
0
 protected function copyModelo($modelo, $nuevoNombre)
 {
     $query = "SELECT * FROM " . $this->fromTables->modelos . " WHERE id = ?";
     error_log($query);
     $original = DB::prepareExecuteFetch($query, array($modelo->id));
     unset($original->id);
     if ($this->toType == TYPES::MODEL) {
         // es un MODELO
         $original->visible = 0;
     } else {
         // es una OBRA
         // las obras no tienen atributo visible, solo es para los modelos
         unset($original->visible);
         //se setea el id_usuario
         if (!isset($modelo->id_usuario)) {
             AppError::write(AppError::OBRA_WIDTOUT_OWNER);
         }
         $original->id_usuario = $modelo->id_usuario;
     }
     if (isset($nuevoNombre)) {
         $original->nombre = $nuevoNombre;
     }
     $original->id = ABM2::save($this->toTables->modelos, $original);
     return $original;
 }
Esempio n. 2
0
 function countUsuarios($plan)
 {
     $id = is_object($plan) ? $plan->id : $plan;
     $query = "select count(*) as cant FROM usuarios WHERE id_plan = ? ";
     $obj = DB::prepareExecuteFetch($query, array($id));
     return $obj->cant;
 }
 protected function getUsuario($modelo)
 {
     if ($this->type == TYPES::USER) {
         $query = "SELECT u.nombre,u.apellido,u.email FROM usuarios u " . " LEFT JOIN " . $this->tables->modelos . " m on m.id_usuario = u.id " . " WHERE m.id = ?";
         return DB::prepareExecuteFetch($query, array($modelo->id));
     } else {
         return null;
     }
 }
 protected function popFromModel($concepto)
 {
     // solo se saca del modelo si no esta en uso
     $query = "SELECT count(*) as count FROM " . $this->fromRelaciones . " WHERE id_sup = ? or id_inf = ?";
     $uso = DB::prepareExecuteFetch($query, array($concepto->id, $concepto->id));
     if ($uso->count == 0) {
         $querySelect = "DELETE FROM " . $this->from . " WHERE id = ?";
         DB::prepareExecute($query, array($concepto->id));
     }
 }
 function getByInsumo($concepto)
 {
     $query = 'SELECT * FROM precios_insumos_tmp WHERE id_concepto = ?';
     return DB::prepareExecuteFetch($query, array($concepto->id));
 }
Esempio n. 6
0
 protected function countParents($concepto)
 {
     $query = "SELECT count(id_sup) as count FROM " . $this->fromRelaciones . " WHERE id_inf = ? ";
     $obj = DB::prepareExecuteFetch($query, array($concepto->id));
     return isset($obj) ? $obj->count : 0;
 }
Esempio n. 7
0
 function getByEmail($email)
 {
     $query = "select id,nombre,apellido,email,uacceso,created,permiso FROM usuarios where email = ?";
     return DB::prepareExecuteFetch($query, array($email));
 }
Esempio n. 8
0
 function getById($id)
 {
     $query = "select * from " . $this->tables->modelos . " where id = ?";
     return DB::prepareExecuteFetch($query, array($id));
 }
Esempio n. 9
0
 function getById($id)
 {
     $query = "SELECT u.id,id_pase,u.nombre,u.apellido,u.email,u.permiso,u.countmodelos,u.uacceso,u.created,u.tyc_cifras, " . "      p.id as id_plan,p.nombre as plan,p.cuota  " . "FROM usuarios u " . "LEFT JOIN usuarios_planes p on p.id = u.id_plan  " . "WHERE u.id = ?";
     return DB::prepareExecuteFetch($query, array($id));
 }
Esempio n. 10
0
 function mustOwnerObra($idObra)
 {
     $user = $this->getUserLogged();
     if (!isset($user)) {
         AppError::write(AppError::USER_NOT_LOGGED);
     }
     $obra = DB::prepareExecuteFetch("SELECT id_usuario FROM modelos_usr WHERE id=?", array($idObra));
     if (!isset($obra) || $obra->id_usuario != $user->id) {
         AppError::write(AppError::NOT_ALLOW);
     }
 }
Esempio n. 11
0
 function getByNombre($familia, $nombre)
 {
     $id = is_object($familia) ? $familia->id : $familia;
     $query = 'select * from subfamilias where id_familia = ? and nombre = ?';
     return DB::prepareExecuteFetch($query, array($id, $nombre));
 }
 /**
  * @return {total:Float, // suma del total
  * 			cant:int 	 // cantidad de hijos del concepto
  * 			}
  */
 protected function calculate($concepto)
 {
     $query = "select ROUND(sum(c.precio*r.cantidad*r.factor),2) as total, count(*) as cant " . "from " . $this->from . " c " . "left join " . $this->fromRelaciones . " r on r.id_inf = c.id " . "where r.id_sup = ? ";
     $obj = DB::prepareExecuteFetch($query, array($concepto->id));
     return $obj;
 }
 protected function calculateBeneficios($modelo)
 {
     $query = "SELECT importe,es_porcentaje FROM " . $this->fromBeneficios . " WHERE id_modelo = ?";
     $obj = DB::prepareExecuteFetch($query, array($modelo->id));
     $suma = 0;
     if ($obj) {
         if ($obj->es_porcentaje == 1) {
             $suma += $obj->importe * $modelo->costo_total;
         } else {
             $suma += $obj->importe;
         }
     }
     return $suma;
 }