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; }
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)); }
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; }
function getByEmail($email) { $query = "select id,nombre,apellido,email,uacceso,created,permiso FROM usuarios where email = ?"; return DB::prepareExecuteFetch($query, array($email)); }
function getById($id) { $query = "select * from " . $this->tables->modelos . " where id = ?"; return DB::prepareExecuteFetch($query, array($id)); }
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)); }
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); } }
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; }