function remove($plan) { if ($this->countUsuarios($plan) > 0) { AppError::write(AppError::PLAN_USO_CANT_DELETE); } $id = is_object($plan) ? $plan->id : $plan; $query = "DELETE FROM usuarios_planes where id = ?"; return DB::prepareExecute($query, array($id)); }
function remove($obj) { $id = is_object($obj) ? $obj->id : $obj; $query = "DELETE FROM " . $this->from . " where id = ?"; $rowCount = DB::prepareExecute($query, array($id)); $r = new stdClass(); if ($rowCount) { $r->ok = TRUE; } else { $r->error = "No hubo cambios"; } return $r; }
protected function updateRelation($parent, $child, $modelo) { $query = "UPDATE " . $this->fromRelaciones . " SET cantidad = ?, factor = ? "; $params = array($child->cantidad, $child->factor); if (isset($child->custom_nombre)) { $query .= " , custom_nombre = ? "; $params[] = $child->custom_nombre; } $query .= " WHERE id_sup = ? and id_inf = ? "; $params[] = $parent->id; $params[] = $child->id; DB::prepareExecute($query, $params); }
function remove($user) { $id = is_object($user) ? $user->id : $user; $query = "DELETE FROM usuarios where id = ?"; return DB::prepareExecute($query, array($id)); }
function remove($caratula) { DB::beginTransaction(); try { if ($this->type == TYPES::USER) { $fromDB = $this->getById($caratula->id); $usuario = new stdClass(); $usuario->id = $fromDB->id_usuario; } $params = array($caratula->id); DB::prepareExecute("DELETE FROM " . $this->tables->beneficios . " WHERE id_modelo = ?", $params); DB::prepareExecute("DELETE FROM " . $this->tables->gastos . " WHERE id_modelo = ?", $params); DB::prepareExecute("DELETE FROM " . $this->tables->relaciones . " WHERE id_modelo = ?", $params); DB::prepareExecute("DELETE FROM " . $this->tables->conceptos . " WHERE id_modelo = ?", $params); DB::prepareExecute("DELETE FROM " . $this->tables->modelos . " WHERE id = ?", $params); if (isset($usuario)) { $this->updateCountModelosUsuario($usuario); } DB::commit(); } catch (exception $e) { DB::rollBack(); throw new Exception("No se pudo eliminar "); } }
function remove($obj) { $id = is_object($obj) ? $obj->id : $obj; $query = "DELETE FROM " . $this->from . " where id = ?"; return DB::prepareExecute($query, array($id)); }
function registerAccess($user) { $query = 'UPDATE usuarios SET uacceso = NOW() WHERE id = ?'; DB::prepareExecute($query, array($user->id)); }
protected function removeDrafts() { DB::prepareExecute('DELETE FROM precios_insumos_tmp'); }
function consultas() { $query = "DELETE FROM conceptos_modelos WHERE codigo = '001855' AND id_modelo = 3"; DB::prepareExecute(); $query = "DELETE FROM conceptos_modelos WHERE codigo = '001600' AND id_modelo = 3"; DB::prepareExecute(); $query = "DELETE FROM conceptos_modelos WHERE codigo = '001804' AND id_modelo = 12"; DB::prepareExecute(); $query = "DELETE FROM conceptos_modelos WHERE codigo = '001855' AND id_modelo = 3"; DB::prepareExecute(); }
protected function updatePrecioMaestro($concepto) { $query = "UPDATE " . $this->from . " SET precio = ?, id_familia = NULL, version = ? WHERE id = ?"; $version = $concepto->version + 1; return DB::prepareExecute($query, array($concepto->precio, $version, $concepto->id)); }
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)); } }