Desarrollo de un ERP para una clínica veterinaria

El presente Proyecto Fin de Carrera consiste en el desarrollo de un Enterprise Resource Planning(ERP) para la gestión de una clínica veterinaria y la posterior implantación en una clínica real: la Clínica Veterinaria Sinaí situada en Villanueva de Gállego (Zaragoza). Un ERP es un sistema de información gerencial que integra y automatiza muchas de las prácticas de negocio asociadas con los aspectos operativos o productivos de una empresa. El sistema de información desarrollado consta de dos partes, una aplicación de escritorio y una aplicación Web. ICAROVET es la aplicación de escritorio cuya finalidad es la organización de la información del día a día de la empresa llevando la información de empleados de la clínica, clientes y mascotas, economía de la empresa, información sobre los servicios que se ofrecen, y otro tipo de funcionalidades como la integración Web y la gestión de copias de seguridad. ICAROVET tiene un sistema de usuarios y permisos que permite que los diferentes empleados de una clínica veterinaria tengan acceso exclusivamente a la información que el administrador de la aplicación decida. Además el sistema ofrece la posibilidad de gestionar la información de los clientes de la clínica veterinaria y el historial médico de sus mascotas. Se almacena toda la información de un cliente, como puede ser visitas, citas, historial económico, asociación entre clientes, mascotas de un cliente, historial clínico, recordatorios o vacunaciones. La aplicación también es capaz de llevar la economía de la clínica veterinaria, tanto la de ingresos como la de gastos. También gestiona la información relativa al almacén, es decir, la organización de artículos y servicios que ofrece la clínica veterinaria a sus clientes, incluyendo un control de stock. Cada usuario en el sistema tendrá una agenda personal, donde podrá visualizar toda la información de la clínica que esta relacionada con él, ya sean citas, tareas a desarrollar, recordatorios de mascotas o alertas acerca del almacén. ICAROVET Web es un portal Web cuyo objetivo es publicitar los servicios de la clínica y ofrecer a sus clientes registrados un medio para ver los datos relativos a su historial y el de sus mascotas en la clínica. La aplicación Web tiene dos zonas diferenciadas, una de acceso público con información corporativa de la clínica, oferta de servicios, imágenes, formas de contacto, noticias e información general para publicitar la clínica. Y otra zona con acceso mediante identificación por usuario y contraseña con dos tipos de usuario, administrador y cliente. Un administrador tiene posibilidades similares a las de un gestor de contenidos Web, pudiendo editar la cabecera o pie de la página, así como información de contacto, noticias, anuncios y el resto de información que se genera dinámicamente en la página Web. Un cliente tiene acceso a través de la página, entre otras cosas, a la información existente en ICAROVET relativa a él y a sus mascotas

Lemierre’s Syndrome: a serious complication of an odontogenic infection

Necrobacillosis, postanginal septicaemia or Lemierre’s Syndrome is characterised by suppurative thrombophlebitis of the internal jugular vein with embolization to several sites, including the lungs. We report the case of a 38-year-old man who was initially hospitalized because of odontogenic cellulitis. Given the deterioration of his clinical state (septic shock and multiple organ failure), neck computed tomography was performed, revealing both cervical and parotid abscesses, and thrombosis of the right internal jugular vein. Streptococcus salivarius was isolated. The patient was treated with intravenous antibiotics, and surgical drainage and after 6 weeks of treatment, recovered completely. Lemierre’s Syndrome is an uncommon, but potentially lethal complication of an odontogenic infection. The case reported here is interesting since the pathogen and the site of primary infection are unusual. Fusobacterium necrophorum is the most common pathogen in Lemierre’s Syndrome, and to the best of our knowledge there are no similar case reports with Streptococcus salivarius as the causative bacteria. Early recognition and high-dose antibiotics are critical elements in reducing mortalit

Analyzing coastal environments by means of functional data analysis

Here we used Functional Data Analysis (FDA) to examine particle-size distributions (PSDs) in a beach/shallow marine sedimentary environment in Gijón Bay (NW Spain). The work involved both Functional Principal Components Analysis (FPCA) and Functional Cluster Analysis (FCA). The grainsize of the sand samples was characterized by means of laser dispersion spectroscopy. Within this framework, FPCA was used as a dimension reduction technique to explore and uncover patterns in grain-size frequency curves. This procedure proved useful to describe variability in the structure of the data set. Moreover, an alternative approach, FCA, was applied to identify clusters and to interpret their spatial distribution. Results obtained with this latter technique were compared with those obtained by means of two vector approaches that combine PCA with CA (Cluster Analysis). The first method, the point density function (PDF), was employed after adapting a log-normal distribution to each PSD and resuming each of the density functions by its mean, sorting, skewness and kurtosis. The second applied a centered-log-ratio (clr) to the original data. PCA was then applied to the transformed data, and finally CA to the retained principal component scores. The study revealed functional data analysis, specifically FPCA and FCA, as a suitable alternative with considerable advantages over traditional vector analysis techniques in sedimentary geology studies

Nanoscale zero-valent iron-assisted soil washing for the removal of potentially toxic elements

The present study focuses on soil washing enhancement via soil pretreatment with nanoscale zero-valent iron (nZVI) for the remediation of potentially toxic elements. To this end, soil polluted with As, Cu, Hg, Pb and Sb was partitioned into various grain sizes (500?2000, 125?500 and <125??m). The fractions were pretreated with nZVI and subsequently subjected, according to grain size, to Wet-High Intensity Magnetic Separation (WHIMS) or hydrocycloning. The results were compared with those obtained in the absence of nanoparticles. An exhaustive characterization of the magnetic signal of the nanoparticles was done. This provided valuable information regarding potentially toxic elements (PTEs) fate, and allowed a metallurgical accounting correction considering the dilution effects caused by nanoparticle addition. As a result, remarkable recovery yields were obtained for Cu, Pb and Sb, which concentrated with the nZVI in the magnetically separated fraction (WHIMS tests) and underflow (hydrocyclone tests). In contrast, Hg, concentrated in the non-magnetic fraction and overflow respectively, while the behavior of As was unaltered by the nZVI pretreatment. All things considered, the addition of nZVI enhanced the efficiency of soil washing, particularly for larger fractions (125?2000??m). The proposed methodology lays the foundations for nanoparticle utilization in soil washing operations.This work was supported by Project CTM2016-75894-P (MINECO). Carlos Boente obtained a grant from the “Formación del Profesorado Universitario” program, financed by the “Ministerio de Educación, Cultura y Deporte de España”. The authors thank the “Servicio Cientifico-Técnico de Medidas Magnéticas” of the University of Oviedo

Cervical tularaemia in a non-endemic area

Tularemia is a zoonotic disease caused by Francisella tularensis. The microorganism is transmitted to humans by contact with, or ingestion of, infected animal tissues, by insect bites, consumption of contaminated food or water, or from inhalation of aerolized bacteria. In this report we describe a case of tularemia presenting with multiple cervical lymphadenitis in Asturias (Spain). Final diagnosis was established based on a serological test. The patient was successfully managed with surgery and streptomycin for 2 weeks. The ulceroglandular form of tularemia should be considered in the differential diagnosis of cervical lymphadenitis, particularly in those not responding to penicillin treatment. To our knowledge, this is the first case described in Asturias, a north coast county of Spain

Spontaneous fracture of the mandibular genial tubercles : a case report

Fracture of the mandibular genial tubercles is an uncommon pathology affecting edentulous patients with severe maxillary atrophy. Usually occurs spontaneously which complicates the diagnosis. Their importance lies in the functional alterations, which occur as a consequence of the disinsertion of the genihyoid and genioglossus muscles. The treatment of fracture of the genial tubercles is controversial, including no surgical intervention, excision of the avulsed bone fragments, and muscular repositioning. There have been only 11 cases reported in the literature of this fracture, most of them spontaneous. We present a difficult diagnosis situation of spontaneous fracture of the genial tubercles in an 86-year-old edentulous female with a painful sublingual and submental hematoma and anterior cervical echimosis. Computerized Tomography should be made to confirm the diagnosis. Surgical treatment was not necessary, and follow-up at 6 months revealed complete symptomatic recovery, and full return of function

Papillary cystadenoma and cystadenocarcinoma of salivary glands : two unusual entities

Cystadenoma and cystadenocarcinoma are rare salivary gland tumours histologically characterized by prominent cystic and frequently papillary growth. We present two cases of cystadenoma of a minor salivary gland (upper lip) and parotid cystadenocarcinoma respectively, captured between 834 salivary gland tumors studied in our hospital from 1980 to 2004. The authors review the clinical, histological, and biological features of these two unusual tumours, and differential diagnosis with other salivary glands neoplasms. Both entities usually reveal papillary proliferation of the epithelial lining and are composed of cells that possess bland cytomorphologic features. Differentiation of tumour types depends largely on the identification of actual infiltration of salivary gland parenchyma or surrounding connective tissue by either cystic or solid epithelium in cystadenocarcinomas. Step sections of a borderline tumour may yield unequivocal evidence of invasion. The authors discuss the problematic diagnosis between these rare neoplasms and with other tumours and compare histological findings of these two entities

Chondrosarcoma of the temporomandibular joint : a case report and review of the literature

Chondrosarcoma is a malignant tumor characterized by the formation of cartilage, but not bone, by tumor cells. Only 5% to 10% of chondrosarcomas occur in the head and neck, representing 0.1% of all head and neck neoplasms, with the larynx and the maxillo-nasal region being the most common sites. This report describes an unusual case of chondrosarcoma in a 54-year-old man who presented with pain and swelling in the left preauricular area. Computed tomography demonstrated a soft tissue mass in the left temporomandibular joint without causing erosion of the adjacent bony structures. The tumor was treated by excision in a single block with perilesional tissues, preserving the facial nerve. Histopathologic examination revealed chondrocytes with irregular nuclei with S-100 immunocytochemical staining positive in 30% of the tumor. The diagnosis was a grade I chondrosarcoma. There was no evidence of disease at the 16-month follow-up. The occurrence of chondrosarcoma in the temporomandibular joint (TMJ) is an exceptional event, with only 16 cases described. We report a case of this unusual entity and review the literature

Impact of Old Pb Mining and Metallurgical Production in Soils from the Linares Mining District (Spain)

[EN] Mineral processing and metallurgy production centers may leave a far-reaching fingerprint of soil contamination. This scenario is particularly relevant in the mining district of Linares (Southern Spain), where former industrial sites are now dedicated to other land uses. Within this context, we selected five sectors of concern in Linares region, which are currently used as agricultural and residential areas. The study began with an edaphic characterization, including grain-size fractioning and soil chemical analyses, which were complemented by mineralogical and sequential extraction information. Anomalous soil concentrations of As, Cd, Cu, Pb, and Zn were found, with higher values than the admissible regional guideline limits. Moreover, chemical speciation indicated that in general, Pb, Zn, and Cd were highly available and bound mainly to the carbonate fraction. In addition, health risk assessment evidenced potential threats by Pb and As. Regarding remediation approaches, we observed that, in soils affected by mining and ore dressing activities, the clay and silt size fractions contained the highest pollution load, making them suitable for a size classification treatment. By contrast, in areas affected by metallurgical activity, pollutants were prone to be evenly distributed among all grain sizes, thereby complicating the implementation of such remediation strategies

Phytoremediation potential depends on the degree of soil pollution: a case study in an urban brownfield

Phytoremediation is a cost-effective nature-based solution for brownfield reclamation. The choice of phytoextraction or phytostabilization strategies is highly relevant when planning full-scale treatments. A suitable approach to identify such species involves the evaluation of plants that grow spontaneously on the contaminated sites. Here, we sought to determine the phytoremediation potential of three spontaneous plant species, namely the trees Acer pseudoplatanus L (A. pseudoplatanus) and Betula celtiberica Rothm. & Vasc (B. celtiberica), and the shrub Buddleja davidii Franch (B. davidii), for the recovery of an urban brownfield. To determine the response of the species to the degree of contamination, we conducted soil and vegetation sampling inside and outside the site. The concentrations of As, Cu, and Zn in soil and plant samples were measured, and then various indexes related to phytoremediation were calculated. The translocation factor and transfer coefficient indicated that vegetation outside the brownfield had phytoextraction capacity while the same plants inside the brownfield revealed phytostabilization properties. Given our results, we propose that the selected species are suitable for phytostabilization strategies in areas with high concentrations of contaminants, whereas they could be used for phytoextraction only in soils with low or moderate levels of pollution.Open Access funding provided thanks to the CRUE-CSIC agreement with Springer Nature. This research was partially funded by the European Commission project LIFE I + DARTS (LIFE11ENV/ES/000547)