RA1 – Incorporació de hotspots en el tour virtual

RA1 – Incorporació de hotspots en el tour virtual Per afegir un hotspot de informacio primer clicarem en el boto de Info Hotspot Ara afegirem el titul y el contigunt que volem per el nostre hotspot i quan ja ho tinguis tot clicarem a save HotSpot Ara únicament ens quedarà col·locar on volem el botó i ja estaria acabat el nostre hotspot Buto per veure el tour

Guardar informació en Python a una base de dades MySQL

Guardar informació en Python a una base de dades MySQL El primer que hem de fer es entrar en el envoirment per poder executar comandes necesaries. source venv/bin/activate sudo apt install mysql-server Després vam instal·lar MySQL que el necessitàvem per guarda la informació més tard  Ara crearem la base de dades i les taules necessàries per al json  — Crear base de datos CREATE DATABASE basemysql; — Crear usuario CREATE USER 'admin'@'localhost' IDENTIFIED BY 'tu_contra'; — Darle permisos al usuario sobre la base de datos GRANT ALL PRIVILEGES ON basemysql.* TO 'admin'@'localhost'; — Aplicar cambios FLUSH PRIVILEGES; — Usar la base de datos recién creada USE basemysql; — Crear una tabla CREATE TABLE accion ( id INT AUTO_INCREMENT PRIMARY KEY, nom VARCHAR(100), descripcio TEXT, data_creacio DATETIME DEFAULT CURRENT_TIMESTAMP ); Per finalitzar únicament ens quedarà afegir la part de codi que necessitem per fer la connexió de MySQL amb el Python conn = mysql.connector.connect( host="localhost", user="teu_user", password="teva_contra", database="database" ) cursor = conn.cursor() # Suposem que reps dades com {'accio': 'click':} accio = dades.get('accio') Inserim les dades a una taula anomenada 'accion' sql = "INSERT INTO accion (accio) VALUES (%s)" val = (accio) cursor.execute(sql, val) conn.commit() # resposta = {'estat': 'dades guardades', 'id': cursor.lastrowid} except mysql.connector.Error as err: print("Error:", err) resposta = {'estat': 'error', 'missatge': str(err)} finally: # Tanquem la connexio cursor.close() conn.close()

Crear un resum escrit al wordpress 

Crear un resum escrit al wordpress Chapter 0 Episode 0 – Introduction and curriculum Introduction to the Course The course is presented by Pinder, who has over four years of experience with Raspberry Pi and web application security. It is designed for beginners and is divided into four main sections. Course Structure Introduction: Covers what Raspberry Pi is and how to choose the right model based on user needs. Setting Up the Environment: Includes operating system installation and network setup. Practical Applications: Demonstrates real-world projects that utilize Raspberry Pi’s capabilities. Project Development: Focuses on using the Raspberry Pi Zero W for more advanced applications. Understanding Raspberry Pi Models Explains the differences between models and guides learners in selecting the best one for their specific goals. Setting Up Raspberry Pi Walks through the OS installation process. Covers remote access using a graphical user interface (GUI). Introduces projects related to security, such as ethical hacking practices. Practical Projects and Applications Building a Wi-Fi jammer to disrupt signals in a targeted area. Creating a network-wide ad blocker. Using Raspberry Pi as a monitoring device for environmental data like temperature, humidity, pressure, and movement. Exploring Raspberry Pi Zero W Focuses on this compact version of Raspberry Pi and its unique applications: Building a functional Wi-Fi router. Creating a portable PC. Cracking Wi-Fi passwords. Integrating a camera module. Conclusion and Further Learning The course is beginner-friendly and provides both foundational knowledge and hands-on experience. Also suitable for experienced users looking to explore new project ideas. Pinder encourages continued learning through follow-up videos. Chapter 1 Episode 1 – What is Raspberry Pi | Before moving forward, it’s important to understand what a Raspberry Pi is. It’s a credit card-sized computer that combines all essential components (RAM, processor, storage, etc.) on a single board—hence the name “single board computer.” This was a basic introduction, and the next video will cover its versions. Chapter 2 Episode 2 – Which model of Raspberry Pi you should buy This video discusses the different models of Raspberry Pi to help users choose the right one. Raspberry Pi 1: Basic and no longer available. Raspberry Pi 2: Has HDMI, but no Wi-Fi or Bluetooth. Raspberry Pi 0: Very cheap ($5), lacks Wi-Fi/Bluetooth. Raspberry Pi 3: Most recommended, includes Wi-Fi/Bluetooth, costs $35. Raspberry Pi 0W: Similar to Pi 0, but includes Wi-Fi/Bluetooth, costs $10. Recommendation: For high-performance needs, go with Raspberry Pi 3. For lightweight tasks, Raspberry Pi 0W is a good budget option.The next video will cover the Raspberry Pi 3 in more detail. Chapter 3 Episode 3 – Raspberry Pi 3 review This tutorial introduces the Raspberry Pi 3, highlighting its hardware specifications: Ports: 4 USB 2.0 ports, 1 Ethernet, 1 HDMI, and 1 audio output (no USB 3.0 or mic input; USB mic needed). Storage: No internal storage; uses SD cards. Memory: 1 GB RAM, suitable for basic applications. Processor: Quad-core ARM A53, up to 1.2 GHz. Connectivity: Built-in Wi-Fi and Bluetooth; supports monitor mode (useful for network tasks). GPIO Pins: Can be used for IoT projects. Architecture: Based on ARMv8 (unlike Pi 0W, which is ARMv6). Chapter 4 Episode 4 – Raspberry Pi Zero W Review The Raspberry Pi 0W is a compact, low-cost board similar to the Raspberry Pi 0 but includes Wi-Fi and Bluetooth. Key features include: ARM11 CPU, up to 1.1 GHz 512 MB RAM Ports: Micro USB, HDMI, power, microSD, and CSI camera port 40 unpopulated GPIO pins Supports monitor mode and packet injection Ideal for small projects like time-lapse cameras, web servers, or Wi-Fi access points Chapter 5 Episode 5 – How to install Operating System on RasPi | This section guides you through preparing your Raspberry Pi’s SD card: Choosing a suitable SD card (minimum 8 GB, Class 10 recommended) Downloading the Raspbian OS desktop version from the official Raspberry Pi website Extracting the OS image and flashing it onto the SD card using Etcher Enabling SSH by creating a blank file named ssh on the SD card’s boot partition Creating a userconf.txt file to set your username and encrypted password Generating the encrypted password via OpenSSL either on a Linux machine or through an online terminal After setup, the Raspberry Pi boots ready for remote SSH access with the new credentials Episode 0 – Introduction and curriculum Introduction to the Course The course is presented by Pinder, who has over four years of experience with Raspberry Pi and web application security. It is designed for beginners and is divided into four main sections. Course Structure Introduction: Covers what Raspberry Pi is and how to choose the right model based on user needs. Setting Up the Environment: Includes operating system installation and network setup. Practical Applications: Demonstrates real-world projects that utilize Raspberry Pi’s capabilities. Project Development: Focuses on using the Raspberry Pi Zero W for more advanced applications. Understanding Raspberry Pi Models Explains the differences between models and guides learners in selecting the best one for their specific goals. Setting Up Raspberry Pi Walks through the OS installation process. Covers remote access using a graphical user interface (GUI). Introduces projects related to security, such as ethical hacking practices. Practical Projects and Applications Building a Wi-Fi jammer to disrupt signals in a targeted area. Creating a network-wide ad blocker. Using Raspberry Pi as a monitoring device for environmental data like temperature, humidity, pressure, and movement. Exploring Raspberry Pi Zero W Focuses on this compact version of Raspberry Pi and its unique applications: Building a functional Wi-Fi router. Creating a portable PC. Cracking Wi-Fi passwords. Integrating a camera module. Conclusion and Further Learning The course is beginner-friendly and provides both foundational knowledge and hands-on experience. Also suitable for experienced users looking to explore new project ideas. Pinder encourages continued learning through follow-up videos. Episode 1 – What is Raspberry Pi | Before moving forward, it’s important to understand what a Raspberry Pi is. It’s a credit card-sized computer that combines all essential components (RAM, processor, storage, etc.) on a single board—hence the name “single … Read more

Càlcul dels imports de la nòmina

Càlcul dels imports de la nòmina Per tal de realitzar els càlculs dels imports corresponents a la nòmina primer, vaig partir del fitxer de nòmina que prèviament m’havia compartit el meu company. A partir d’aquest document, vaig revisar detalladament les dades i vaig aplicar les fórmules necessàries a cada cel·la per tal d’obtenir els resultats correctes, assegurant-me que els càlculs fossin correspondents amb els criteris establerts.

Anàlisi ASG de les empreses participants al projecte mooding

Anàlisi ASG de les empreses participants al projecte mooding 1. Aspecto Ambiental (A) Nestlé ha asumido compromisos importantes en materia de sostenibilidad ambiental. Su objetivo principal es alcanzar cero emisiones netas de gases de efecto invernadero para el año 2050, alineándose con el Acuerdo de París. Para ello, está invirtiendo en energías renovables, transporte más eficiente y agricultura regenerativa. También ha implementado programas para reducir el uso del agua en sus procesos de producción, especialmente en zonas con estrés hídrico, y ha avanzado en la optimización de envases, con la meta de que el 100% de sus embalajes sean reciclables o reutilizables para 2025. A pesar de estos avances, la empresa ha sido criticada por su uso excesivo de plásticos de un solo uso y su historial de deforestación asociada a la producción de materias primas como el aceite de palma y el cacao. 2. Aspecto Social (S) Nestlé tiene un papel activo en cuestiones sociales. Desarrolla programas para mejorar la nutrición, especialmente infantil, y promueve la educación alimentaria en comunidades vulnerables. También mantiene proyectos de apoyo a agricultores locales, ayudándolos a mejorar su productividad y condiciones laborales mediante formación y acceso a recursos. En términos laborales, Nestlé impulsa la diversidad e inclusión dentro de su plantilla global y ha lanzado iniciativas como el programa “Nestlé needs YOUth” para fomentar el empleo juvenil. Sin embargo, la empresa ha enfrentado controversias relacionadas con el trabajo infantil en su cadena de suministro, especialmente en la producción de cacao, así como críticas por la comercialización de fórmulas infantiles en países en desarrollo, en condiciones poco éticas. 3. Aspecto de Gobernanza (G) Nestlé dispone de una estructura de gobernanza consolidada, con un consejo de administración diverso y políticas claras de ética empresarial, transparencia y responsabilidad corporativa. Publica regularmente informes de sostenibilidad verificados externamente y mantiene canales de denuncia interna para combatir el fraude y las malas prácticas. A nivel global, promueve el cumplimiento de los derechos humanos en su cadena de suministro y realiza auditorías para detectar posibles violaciones. No obstante, ha sido objeto de investigaciones en algunos países por prácticas anticompetitivas o problemas de transparencia en el etiquetado.

Configuració de la xarxa Wi-Fi del festival

Configuració de la xarxa Wi-Fi del festival La nostra xarxa sera a partir d’un Acces Points (AP) el qual haurem de configurar previament, on configurarem el SSID (nom de la xarxa) i la contrasenya per accedir a la nostra red, per fer aixo haurem de accedir a la pagina