ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '658155' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '658155' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NOT NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'CodigoInstitucion'. [20018] (severity 16) [SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '658155' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;]
SELECT PublicObrasAutores.NumeroEmpleado, PublicObrasAutores.ApellidoPaterno, PublicObrasAutores.ApellidoMaterno, PublicObrasAutores.Nombre, PublicObrasAutores.NombreCompleto FROM PublicObrasAutores LEFT JOIN PublicObrasAutoresFil ON PublicObrasAutores.RefPublicacion = PublicObrasAutoresFil.RefPublicacion WHERE PublicObrasAutores.RefPublicacion = '658155' AND PublicObrasAutores.NumeroEmpleado IS NULL AND PublicObrasAutoresFil.CodigoInstitucion IS NULL;

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '658155']
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = '658155'

ERROR:SQLSTATE[HY000]: General error: 20018 Invalid column name 'Institucion'. [20018] (severity 16) [SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 658155 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 658155]
SELECT Institucion FROM PublicObrasAutoresFil WHERE RefPublicacion = 658155 AND InstitucionPropia = 'S' UNION SELECT Adscripciones.Entidad FROM PublicacionesObras JOIN PublicObrasAutores ON PublicacionesObras.Identificador = PublicObrasAutores.RefPublicacion JOIN Adscripciones ON PublicObrasAutores.NumeroEmpleado = Adscripciones.NumeroEmpleado WHERE (PublicacionesObras.FechaPublicacion BETWEEN Adscripciones.FechaDesde AND Adscripciones.FechaHasta OR (PublicacionesObras.FechaPublicacion >= Adscripciones.FechaDesde AND Adscripciones.FechaHasta IS NULL)) AND PublicacionesObras.Identificador= 658155

Título del libro:
Título del capítulo: Design of a Bi-Objective Optimization Model for Sustainable Production Planning Applied to Textile MSMEs

Autores UNAM:
JOSE ANTONIO MARMOLEJO SAUCEDO;

---

Autores externos:

---

Idioma:

---

Año de publicación:
2024

---

Palabras clave:

Sustainable city; Textile industry; Bi-objective optimization; Bi-objectives optimization models; Complex nature; Globalisation; Production Planning; Production process; Sustainable production; Technological development; Textile enterprise; Textile micro-, small-, and medium-sized textile enterprise; Sustainable development goals

---

Resumen:

The complex nature of the textile industry and factors such as technological development, COVID-19, globalization, laws, and world agreements have generated substantial changes in production processes, making it necessary to seek a balance between economic, environmental, and social variables. These new needs are a challenge for micro-, small-, and medium-sized textile enterprises (MSMEs) due to their instability, lack of economic resources, and poor sustainable development. Therefore, implementing approaches such as sustainable planning and manufacturing becomes an ally for textile companies as they seek economically robust products with minimal environmental impact in safe conditions for workers. In this context, the objective of this study is based on the development of a bi-objective optimization model that drives sustainability in the planning of production processes of textile MSMEs. The methodology follows two phases divided into data acquisition and mathematical structure of the model based on two objective functions with economic and environmental approach. The validation of the model uses data obtained from a textile MSME in the city of CUENCA in Ecuador and proposes the alternative use of photovoltaic energy and different production scenarios. As one of the results, a strategic tool for business decision-making is obtained, which visualizes the use of sustainable strategies in production planning, along with its economic and environmental impacts in the textile sector. © The Author(s), under exclusive license to Springer Nature Switzerland AG 2024.

---

Entidades citadas de la UNAM:

---

Fuente:


ISBN:
9783031674396
Editorial:
Springer Science and Business Media Deutschland GmbH

Tipo de producto:
Conference Paper

DOI:
10.1007/978-3-031-67440-2_9