Giter VIP home page Giter VIP logo

aggarcia3 / padegest Goto Github PK

View Code? Open in Web Editor NEW
0.0 3.0 0.0 3.43 MB

Un proyecto de aplicación web de gestión integral de un club de pádel para la asignatura de Aprendizaje Basado en Proyectos.

License: GNU General Public License v3.0

Shell 1.18% PHP 81.64% TSQL 0.20% CSS 2.37% Batchfile 0.13% HTML 1.49% PLpgSQL 12.25% JavaScript 0.73%
web php html-css-javascript project application padel

padegest's People

Contributors

aggarcia3 avatar pablop44 avatar plvalencia avatar salvadorperezsalcedo avatar

Watchers

 avatar  avatar  avatar

padegest's Issues

Perfeccionamiento de BD

  • Añadir o completar triggers para validar atributos de clases, reserva, pago.
  • Añadir reservas efectuadas por clases y usuarios entrenadores.

CRUD usuarios

Incluye el registro y login.

filter_var(env('DEBUG', true), FILTER_VALIDATE_BOOLEAN), /** * Configure basic information about the application. * * - namespace - The namespace to find app classes under. * - defaultLocale - The default locale for translation, formatting currencies and numbers, date and time. * - encoding - The encoding used for HTML + database connections. * - base - The base directory the app resides in. If false this * will be auto detected. * - dir - Name of app directory. * - webroot - The webroot directory. * - wwwRoot - The file path to webroot. * - baseUrl - To configure CakePHP to *not* use mod_rewrite and to * use CakePHP pretty URLs, remove these .htaccess * files: * /.htaccess * /webroot/.htaccess * And uncomment the baseUrl key below. * - fullBaseUrl - A base URL to use for absolute links. When set to false (default) * CakePHP generates required value based on `HTTP_HOST` environment variable. * However, you can define it manually to optimize performance or if you * are concerned about people manipulating the `Host` header. * - imageBaseUrl - Web path to the public images directory under webroot. * - cssBaseUrl - Web path to the public css directory under webroot. * - jsBaseUrl - Web path to the public js directory under webroot. * - paths - Configure paths for non class based resources. Supports the * `plugins`, `templates`, `locales` subkeys, which allow the definition of * paths for plugins, view templates and locale files respectively. */ 'App' => [ 'namespace' => 'App', 'encoding' => env('APP_ENCODING', 'UTF-8'), 'defaultLocale' => env('APP_DEFAULT_LOCALE', 'es_ES'), 'defaultTimezone' => env('APP_DEFAULT_TIMEZONE', 'Europe/Madrid'), 'base' => false, 'dir' => 'src', 'webroot' => 'webroot', 'wwwRoot' => WWW_ROOT, //'baseUrl' => env('SCRIPT_NAME'), 'fullBaseUrl' => false, 'imageBaseUrl' => 'img/', 'cssBaseUrl' => 'css/', 'jsBaseUrl' => 'js/', 'paths' => [ 'plugins' => [ROOT . DS . 'plugins' . DS], 'templates' => [APP . 'Template' . DS], 'locales' => [APP . 'Locale' . DS], ], ], /** * Security and encryption configuration * * - salt - A random string used in security hashing methods. * The salt value is also used as the encryption key. * You should treat it as extremely sensitive data. */ 'Security' => [ 'salt' => env('SECURITY_SALT', '__SALT__'), ], /** * Apply timestamps with the last modified time to static assets (js, css, images). * Will append a querystring parameter containing the time the file was modified. * This is useful for busting browser caches. * * Set to true to apply timestamps when debug is true. Set to 'force' to always * enable timestamping regardless of debug value. */ 'Asset' => [ //'timestamp' => true, // 'cacheTime' => '+1 year' ], /** * Configure the cache adapters. */ 'Cache' => [ 'default' => [ 'className' => FileEngine::class, 'path' => CACHE, 'url' => env('CACHE_DEFAULT_URL', null), ], /** * Configure the cache used for general framework caching. * Translation cache files are stored with this configuration. * Duration will be set to '+2 minutes' in bootstrap.php when debug = true * If you set 'className' => 'Null' core cache will be disabled. */ '_cake_core_' => [ 'className' => FileEngine::class, 'prefix' => 'padegest_core_', 'path' => CACHE . 'persistent/', 'serialize' => true, 'duration' => '+1 years', 'url' => env('CACHE_CAKECORE_URL', null), ], /** * Configure the cache for model and datasource caches. This cache * configuration is used to store schema descriptions, and table listings * in connections. * Duration will be set to '+2 minutes' in bootstrap.php when debug = true */ '_cake_model_' => [ 'className' => FileEngine::class, 'prefix' => 'padegest_model_', 'path' => CACHE . 'models/', 'serialize' => true, 'duration' => '+1 years', 'url' => env('CACHE_CAKEMODEL_URL', null), ], /** * Configure the cache for routes. The cached routes collection is built the * first time the routes are processed via `config/routes.php`. * Duration will be set to '+2 seconds' in bootstrap.php when debug = true */ '_cake_routes_' => [ 'className' => FileEngine::class, 'prefix' => 'padegest_routes_', 'path' => CACHE, 'serialize' => true, 'duration' => '+1 years', 'url' => env('CACHE_CAKEROUTES_URL', null), ], ], /** * Configure the Error and Exception handlers used by your application. * * By default errors are displayed using Debugger, when debug is true and logged * by Cake\Log\Log when debug is false. * * In CLI environments exceptions will be printed to stderr with a backtrace. * In web environments an HTML page will be displayed for the exception. * With debug true, framework errors like Missing Controller will be displayed. * When debug is false, framework errors will be coerced into generic HTTP errors. * * Options: * * - `errorLevel` - int - The level of errors you are interested in capturing. * - `trace` - boolean - Whether or not backtraces should be included in * logged errors/exceptions. * - `log` - boolean - Whether or not you want exceptions logged. * - `exceptionRenderer` - string - The class responsible for rendering * uncaught exceptions. If you choose a custom class you should place * the file for that class in src/Error. This class needs to implement a * render method. * - `skipLog` - array - List of exceptions to skip for logging. Exceptions that * extend one of the listed exceptions will also be skipped for logging. * E.g.: * `'skipLog' => ['Cake\Http\Exception\NotFoundException', 'Cake\Http\Exception\UnauthorizedException']` * - `extraFatalErrorMemory` - int - The number of megabytes to increase * the memory limit by when a fatal error is encountered. This allows * breathing room to complete logging or error handling. */ 'Error' => [ 'errorLevel' => E_ALL, 'exceptionRenderer' => ExceptionRenderer::class, 'skipLog' => [], 'log' => true, 'trace' => true, ], /** * Email configuration. * * By defining transports separately from delivery profiles you can easily * re-use transport configuration across multiple profiles. * * You can specify multiple configurations for production, development and * testing. * * Each transport needs a `className`. Valid options are as follows: * * Mail - Send using PHP mail function * Smtp - Send using SMTP * Debug - Do not send the email, just return the result * * You can add custom transports (or override existing transports) by adding the * appropriate file to src/Mailer/Transport. Transports should be named * 'YourTransport.php', where 'Your' is the name of the transport. */ 'EmailTransport' => [ 'default' => [ 'className' => DebugTransport::class ], ], /** * Email delivery profiles * * Delivery profiles allow you to predefine various properties about email * messages from your application and give the settings a name. This saves * duplication across your application and makes maintenance and development * easier. Each profile accepts a number of keys. See `Cake\Mailer\Email` * for more information. */ 'Email' => [ 'default' => [ 'transport' => 'default', 'from' => '[email protected]', //'charset' => 'utf-8', //'headerCharset' => 'utf-8', ], ], /** * Connection information used by the ORM to connect * to your application's datastores. * * ### Notes * - Drivers include Mysql Postgres Sqlite Sqlserver * See vendor\cakephp\cakephp\src\Database\Driver for complete list * - Do not use periods in database name - it may lead to error. * See https://github.com/cakephp/cakephp/issues/6471 for details. * - 'encoding' is recommended to be set to full UTF-8 4-Byte support. * E.g set it to 'utf8mb4' in MariaDB and MySQL and 'utf8' for any * other RDBMS. */ 'Datasources' => [ 'default' => [ 'className' => Connection::class, 'driver' => Mysql::class, 'persistent' => false, 'host' => '127.0.0.1', /* * CakePHP will use the default DB port based on the driver selected * MySQL on MAMP uses port 8889, MAMP users will want to uncomment * the following line and set the port accordingly */ 'port' => '/Applications/XAMPP/xamppfiles/var/mysql/mysql.sock:3306', 'username' => 'root', 'password' => '', 'database' => 'PADEGEST', /* * You do not need to set this flag to use full utf-8 encoding (internal default since CakePHP 3.6). */ //'encoding' => 'utf8mb4', 'timezone' => 'UTC', 'flags' => [], 'cacheMetadata' => true, 'log' => false, /** * Set identifier quoting to true if you are using reserved words or * special characters in your table or column names. Enabling this * setting will result in queries built using the Query Builder having * identifiers quoted when creating SQL. It should be noted that this * decreases performance because each query needs to be traversed and * manipulated before being executed. */ 'quoteIdentifiers' => false, /** * During development, if using MySQL < 5.6, uncommenting the * following line could boost the speed at which schema metadata is * fetched from the database. It can also be set directly with the * mysql configuration directive 'innodb_stats_on_metadata = 0' * which is the recommended value in production environments */ //'init' => ['SET GLOBAL innodb_stats_on_metadata = 0'], 'url' => env('DATABASE_URL', null), ], /** * The test connection is used during the test suite. */ 'test' => [ 'className' => Connection::class, 'driver' => Mysql::class, 'persistent' => false, 'host' => 'mysql', //'port' => 'non_standard_port_number', 'username' => 'PadeGestApp', 'password' => 'PadeGestApp', 'database' => 'PADEGEST', //'encoding' => 'utf8mb4', 'timezone' => 'UTC', 'cacheMetadata' => true, 'quoteIdentifiers' => false, 'log' => false, //'init' => ['SET GLOBAL innodb_stats_on_metadata = 0'], 'url' => env('DATABASE_TEST_URL', null), ], ], /** * Configures logging options */ 'Log' => [ 'debug' => [ 'className' => FileLog::class, 'path' => LOGS, 'file' => 'debug', 'url' => env('LOG_DEBUG_URL', null), 'scopes' => false, 'levels' => ['notice', 'info', 'debug'], ], 'error' => [ 'className' => FileLog::class, 'path' => LOGS, 'file' => 'error', 'url' => env('LOG_ERROR_URL', null), 'scopes' => false, 'levels' => ['warning', 'error', 'critical', 'alert', 'emergency'], ], // To enable this dedicated query log, you need set your datasource's log flag to true 'queries' => [ 'className' => FileLog::class, 'path' => LOGS, 'file' => 'queries', 'url' => env('LOG_QUERIES_URL', null), 'scopes' => ['queriesLog'], ], ], /** * Session configuration. * * Contains an array of settings to use for session configuration. The * `defaults` key is used to define a default preset to use for sessions, any * settings declared here will override the settings of the default config. * * ## Options * * - `cookie` - The name of the cookie to use. Defaults to 'CAKEPHP'. Avoid using `.` in cookie names, * as PHP will drop sessions from cookies with `.` in the name. * - `cookiePath` - The url path for which session cookie is set. Maps to the * `session.cookie_path` php.ini config. Defaults to base path of app. * - `timeout` - The time in minutes the session should be valid for. * Pass 0 to disable checking timeout. * Please note that php.ini's session.gc_maxlifetime must be equal to or greater * than the largest Session['timeout'] in all served websites for it to have the * desired effect. * - `defaults` - The default configuration set to use as a basis for your session. * There are four built-in options: php, cake, cache, database. * - `handler` - Can be used to enable a custom session handler. Expects an * array with at least the `engine` key, being the name of the Session engine * class to use for managing the session. CakePHP bundles the `CacheSession` * and `DatabaseSession` engines. * - `ini` - An associative array of additional ini values to set. * * The built-in `defaults` options are: * * - 'php' - Uses settings defined in your php.ini. * - 'cake' - Saves session files in CakePHP's /tmp directory. * - 'database' - Uses CakePHP's database sessions. * - 'cache' - Use the Cache class to save sessions. * * To define a custom session handler, save it at src/Network/Session/.php. * Make sure the class implements PHP's `SessionHandlerInterface` and set * Session.handler to * * To use database sessions, load the SQL file located at config/schema/sessions.sql */ 'Session' => [ 'defaults' => 'php', ], ];

Rehacer MERE lógico BD

Esta tarea debe de hacerse teniendo en cuenta los cambios lógicos que hicimos a las relaciones para pasarlas al modelo relacional. El MERE lógico que ya tenemos, si bien puede ser una buena base de la que partir, no está pulido del todo (algunas flechas están mal colocadas, faltan multiplicidades...) y no contempla cambios como el añadido de atributos o la inscripción de las parejas en una entidad "categoría + campeonato".

Debe de estar terminada antes de la fecha de entrega de la siguiente actividad, el 6 de noviembre.

Recursos:

Entregable:
En la carpeta de Drive de la actividad 7, un dibujo de draw.io llamado "MERE lógico" que contenga el MERE final lógico de la BD de la aplicación.

Pulido de casos de uso ya implementados

Cada uno debería de perfeccionar los casos de uso que ya hizo para la primera iteración, teniendo en cuenta las indicaciones de Anália, la presencia de errores en ciertas funcionalidades y el añadido de nuevos casos de uso.

Por ejemplo, yo sé que tendré que modificar el listado de reservas para que funcione bien con las reservas creadas por las clases de las escuelas deportivas, y que habrá que corregir el error que ocurre al insertar resultados.

Diseño físico de BD

  • Transformar MERE lógico en físico.
  • Generar scripts de creación de BD.
  • Generar script de creación de conjunto de datos de prueba.

CRUD pistas

  • CRUD básico de pistas: creación, eliminación y visualización.
  • CRUD de reserva de pistas.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.