Prueba de integracion para service worker

FIX: Ofuscator

CLI.Dockerfile

@@ -1,4 +1,4 @@
-FROM php:8.2-cli
+FROM php:8.4-cli
 
 ENV TZ "${TZ}"
 ENV APP_NAME "${APP_NAME}"
@@ -6,11 +6,14 @@ ENV API_URL "${API_URL}"
 
 RUN apt-get update && apt-get install -y --no-install-recommends cron rsyslog nano && rm -r /var/lib/apt/lists/*
 
-RUN pecl install xdebug-3.2.2 \
+RUN pecl install xdebug-3.4.2 \
     && docker-php-ext-enable xdebug \
-    && echo "#/bin/bash\nprintenv >> /etc/environment\ncron -f -L 11" > /root/entrypoint && chmod a+x /root/entrypoint
+    && echo $TZ > /etc/timezone
+
+COPY --chmod=550 ./cli/entrypoint /root/entrypoint
 
 COPY ./php-errors.ini /usr/local/etc/php/conf.d/docker-php-errors.ini
+COPY ./php-timezone.ini /usr/local/etc/php/conf.d/docker-php-timezone.ini
 
 WORKDIR /code/bin
 

Dockerfile

@@ -1,11 +1,12 @@
-FROM php:8.2-fpm
+FROM php:8.4-fpm
 
 ENV TZ=America/Santiago
 
-RUN apt-get update && apt-get install -y --no-install-recommends libzip-dev libicu-dev git libpng-dev unzip tzdata \
+RUN apt-get update && apt-get install -y --no-install-recommends libzip-dev libicu-dev git \
+    libpng-dev unzip tzdata libxml2-dev \
     && rm -r /var/lib/apt/lists/* \
-    && docker-php-ext-install pdo pdo_mysql zip intl gd bcmath \
-    && pecl install xdebug-3.3.2 \
+    && docker-php-ext-install pdo pdo_mysql zip intl gd bcmath dom \
+    && pecl install xdebug-3.4.2 \
     && docker-php-ext-enable xdebug \
     && echo $TZ > /etc/timezone
 

app/.env.sample

@@ -2,17 +2,18 @@
 
 APP_URL=
 
-MYSQL_HOST=db
-
 COOKIE_NAME=
 COOKIE_DOMAIN=
 COOKIE_PATH=/
 MAX_LOGIN_HOURS=120
 
-REDIS_HOST=redis
-REDIS_PORT=6379
+#REDIS_HOST=redis
+#REDIS_PORT=6379
 
 DB_HOST=db
 DB_DATABASE=incoviba
 DB_USER=incoviba
 DB_PASSWORD=
+
+TOKU_URL=
+TOKU_TOKEN=

app/.gitignore

@@ -1 +1,2 @@
 **/bin
+**/public/tests

app/.phpunit-watcher.yml

@@ -10,5 +10,5 @@ notifications:
   failingTests: false
 hideManual: true
 phpunit:
-  arguments: '--log-events-text /logs/output.txt --stop-on-failure'
+  arguments: '--testsuite unit --log-events-text /logs/output.txt --stop-on-failure'
   timeout: 180

app/bin/console

@@ -0,0 +1,3 @@
+#!/usr/bin/bash
+
+php -d auto_prepend_file=test.bootstrap.php -a

app/bin/integration_tests

@@ -0,0 +1,3 @@
+#!/usr/bin/bash
+
+bin/phpunit --testsuite acceptance $@

app/bin/performance_tests

@@ -0,0 +1,3 @@
+#!/usr/bin/bash
+
+bin/phpunit --testsuite performance $@

app/bin/unit_tests

@@ -0,0 +1,3 @@
+#!/usr/bin/bash
+
+./bin/phpunit --testsuite unit $@

app/common/Alias/View.php

@@ -1,9 +1,6 @@
 <?php
 namespace Incoviba\Common\Alias;
 
-use Illuminate\Events\Dispatcher;
 use Slim\Views\Blade;
 
-class View extends Blade
-{
-}
+class View extends Blade {}

app/common/Define/Money/Provider.php

@@ -8,9 +8,9 @@ interface Provider
 {
     /**
      * @param string $money_symbol
-     * @param DateTimeInterface $dateTime
+     * @param ?DateTimeInterface $dateTime = null
      * @return float
      * @throws EmptyResponse
      */
-    public function get(string $money_symbol, DateTimeInterface $dateTime): float;
+    public function get(string $money_symbol, ?DateTimeInterface $dateTime = null): float;
 }

app/common/Ideal/LoggerEnabled.php

@@ -0,0 +1,18 @@
+<?php
+namespace Incoviba\Common\Ideal;
+
+use Psr\Log\LoggerAwareInterface;
+use Psr\Log\LoggerInterface;
+
+abstract class LoggerEnabled implements LoggerAwareInterface
+{
+    protected LoggerInterface $logger;
+    public function setLogger(LoggerInterface $logger): void
+    {
+        $this->logger = $logger;
+    }
+    public function getLogger(): LoggerInterface
+    {
+        return $this->logger;
+    }
+}

app/common/Ideal/Repository.php

@@ -24,6 +24,11 @@ abstract class Repository implements Define\Repository
         return $this;
     }
 
+    public function getConnection(): Define\Connection
+    {
+        return $this->connection;
+    }
+
     public function load(array $data_row): Define\Model
     {
         $model = $this->create($data_row);
@@ -189,7 +194,7 @@ abstract class Repository implements Define\Repository
         try {
             $this->connection->execute($query, $values);
         } catch (PDOException $exception) {
-            throw new EmptyResult($query, $exception);
+            throw new EmptyResult($query, $exception, $data);
         }
         return $this->fetchById($this->getIndex($model));
     }
@@ -205,10 +210,10 @@ abstract class Repository implements Define\Repository
         try {
             $result = $this->connection->execute($query, $data)->fetch(PDO::FETCH_ASSOC);
             if ($result === false) {
-                throw new EmptyResult($query);
+                throw new EmptyResult($query, null, $data);
             }
         } catch (PDOException $exception) {
-            throw new EmptyResult($query, $exception);
+            throw new EmptyResult($query, $exception, $data);
         }
         return $this->load($result);
     }
@@ -224,7 +229,7 @@ abstract class Repository implements Define\Repository
         try {
             $results = $this->connection->execute($query, $data)->fetchAll(PDO::FETCH_ASSOC);
         } catch (PDOException $exception) {
-            throw new EmptyResult($query, $exception);
+            throw new EmptyResult($query, $exception, $data);
         }
         return array_map([$this, 'load'], $results);
     }
@@ -240,7 +245,7 @@ abstract class Repository implements Define\Repository
         try {
             $results = $this->connection->execute($query, $data)->fetchAll(PDO::FETCH_ASSOC);
         } catch (PDOException $exception) {
-            throw new EmptyResult($query, $exception);
+            throw new EmptyResult($query, $exception, $data);
         }
         return $results;
     }

app/common/Ideal/Service/API.php

@@ -0,0 +1,56 @@
+<?php
+namespace Incoviba\Common\Ideal\Service;
+
+use Psr\Log\LoggerInterface;
+use Incoviba\Common\Define;
+use Incoviba\Common\Ideal;
+use Incoviba\Exception\ServiceAction;
+
+abstract class API extends Ideal\Service
+{
+    public function __construct(LoggerInterface $logger)
+    {
+        parent::__construct($logger);
+    }
+
+    /**
+     * @param string|array|null $order
+     * @return array
+     */
+    abstract public function getAll(null|string|array $order = null): array;
+
+    /**
+     * @param int $id
+     * @return Define\Model
+     * @throws ServiceAction\Read
+     */
+    abstract public function get(int $id): Define\Model;
+
+    /**
+     * @param array $data
+     * @return Define\Model
+     * @throws ServiceAction\Create
+     */
+    abstract public function add(array $data): Define\Model;
+
+    /**
+     * @param Define\Model $model
+     * @param array $new_data
+     * @return Define\Model
+     * @throws ServiceAction\Update
+     */
+    abstract public function edit(Define\Model $model, array $new_data): Define\Model;
+
+    /**
+     * @param int $id
+     * @return Define\Model
+     * @throws ServiceAction\Delete
+     */
+    abstract public function delete(int $id): Define\Model;
+
+    /**
+     * @param Define\Model $model
+     * @return Define\Model
+     */
+    abstract protected function process(Define\Model $model): Define\Model;
+}

app/common/Implement/Database/Query/Insert.php

@@ -81,6 +81,9 @@ class Insert extends Ideal\Query implements Define\Query\Insert
             if ($value === (int) $value) {
                 return $value;
             }
+            if (str_starts_with($value, ':')) {
+                return $value;
+            }
             return "'{$value}'";
         }, $this->values)) . ')';
     }

app/common/Implement/Exception/EmptyResult.php

@@ -6,10 +6,15 @@ use Throwable;
 
 class EmptyResult extends Exception
 {
-    public function __construct(public string $query, ?Throwable $previous = null)
+    public function __construct(public string $query, ?Throwable $previous = null, protected ?array $data = null)
     {
         $message = "Empty results for {$query}";
         $code = 700;
         parent::__construct($message, $code, $previous);
     }
+
+    public function getData(): ?array
+    {
+        return $this->data;
+    }
 }

app/common/Implement/Exception/HttpException.php

@@ -0,0 +1,13 @@
+<?php
+namespace Incoviba\Common\Implement\Exception;
+
+use Throwable;
+use Exception;
+
+class HttpException extends Exception
+{
+    public function __construct(string $message = "", int $code = 0, ?Throwable $previous = null)
+    {
+        parent::__construct($message, $code, $previous);
+    }
+}

app/common/Implement/Log/Formatter/PDO.php

@@ -0,0 +1,48 @@
+<?php
+namespace Incoviba\Common\Implement\Log\Formatter;
+
+use Throwable;
+use Monolog\Formatter\JsonFormatter;
+use Monolog\LogRecord;
+
+class PDO extends JsonFormatter
+{
+    public function __construct(int $batchMode = self::BATCH_MODE_JSON, bool $appendNewline = false, bool $ignoreEmptyContextAndExtra = false, bool $includeStacktraces = true)
+    {
+        parent::__construct($batchMode, $appendNewline, $ignoreEmptyContextAndExtra, $includeStacktraces);
+    }
+
+    public function format(LogRecord $record): string
+    {
+        if (is_a($record->message, Throwable::class)) {
+            $exception = $record->message;
+            $message = $this->normalizeException($exception);
+            $context = $record->context;
+            $context['exception'] = $exception;
+            if ($exception->getPrevious()) {
+                $context['previous'] = $this->walkException($exception);
+            }
+            $new_record = new LogRecord(
+                $record->datetime,
+                $record->channel,
+                $record->level,
+                json_encode($message),
+                $context,
+                $record->extra
+            );
+            $record = $new_record;
+        }
+        $normalized = $this->normalize($record, $this->maxNormalizeDepth);
+        return $normalized['message'];
+    }
+
+    protected function walkException(Throwable $exception, int $depth = 0): array
+    {
+        $output = [];
+        $currentDepth = $depth;
+        while ($previous = $exception->getPrevious() and $currentDepth < $this->maxNormalizeDepth) {
+            $output []= $this->normalizeException($previous);
+        }
+        return $output;
+    }
+}

app/common/Implement/Log/Handler/MySQL.php

@@ -1,13 +1,13 @@
 <?php
-namespace Incoviba\Common\Implement\Log;
+namespace Incoviba\Common\Implement\Log\Handler;
 
-use PDOStatement;
-use Monolog\Handler\AbstractProcessingHandler;
-use Monolog\LogRecord;
-use Monolog\Level;
 use Incoviba\Common\Define\Connection;
+use Monolog\Handler\AbstractProcessingHandler;
+use Monolog\Level;
+use Monolog\LogRecord;
+use PDOStatement;
 
-class MySQLHandler extends AbstractProcessingHandler
+class MySQL extends AbstractProcessingHandler
 {
     private bool $initialized = false;
     private PDOStatement $statement;
@@ -19,9 +19,12 @@ class MySQLHandler extends AbstractProcessingHandler
     public function write(LogRecord $record): void
     {
         if (!$this->initialized) {
+            if (!$this->checkTableExists()) {
+                $this->createTable();
+            }
+            $this->cleanup();
             $this->initialized();
         }
-        $this->cleanup();
         $this->statement->execute([
             'channel' => $record->channel,
             'level' => $record->level->getName(),
@@ -35,6 +38,21 @@ class MySQLHandler extends AbstractProcessingHandler
     private function initialized(): void
     {
         $query = <<<QUERY
+INSERT INTO monolog (channel, level, message, time, context, extra)
+VALUES (:channel, :level, :message, :time, :context, :extra)
+QUERY;
+        $this->statement = $this->connection->getPDO()->prepare($query);
+        $this->initialized = true;
+    }
+    private function checkTableExists(): bool
+    {
+        $query = "SHOW TABLES LIKE 'monolog'";
+        $result = $this->connection->query($query);
+        return $result->rowCount() > 0;
+    }
+    private function createTable(): void
+    {
+        $query = <<<QUERY
 CREATE TABLE IF NOT EXISTS monolog (
     channel VARCHAR(255),
     level VARCHAR(100),
@@ -45,12 +63,6 @@ CREATE TABLE IF NOT EXISTS monolog (
 )
 QUERY;
         $this->connection->getPDO()->exec($query);
-        $query = <<<QUERY
-INSERT INTO monolog (channel, level, message, time, context, extra)
-VALUES (:channel, :level, :message, :time, :context, :extra)
-QUERY;
-        $this->statement = $this->connection->getPDO()->prepare($query);
-        $this->initialized = true;
     }
     private function cleanup(): void
     {

app/common/Implement/Log/PDOFormatter.php

@@ -1,19 +0,0 @@
-<?php
-namespace Incoviba\Common\Implement\Log;
-
-use Monolog\Formatter\JsonFormatter;
-use Monolog\LogRecord;
-
-class PDOFormatter extends JsonFormatter
-{
-    public function __construct(int $batchMode = self::BATCH_MODE_JSON, bool $appendNewline = false, bool $ignoreEmptyContextAndExtra = false, bool $includeStacktraces = true)
-    {
-        parent::__construct($batchMode, $appendNewline, $ignoreEmptyContextAndExtra, $includeStacktraces);
-    }
-
-    public function format(LogRecord $record): string
-    {
-        $normalized = $this->normalize($record);
-        return $normalized['message'];
-    }
-}

app/common/Implement/Log/Processor/ArrayBuilder.php

@@ -0,0 +1,139 @@
+<?php
+namespace Incoviba\Common\Implement\Log\Processor;
+
+use DateInvalidTimeZoneException;
+use DateMalformedStringException;
+use DateTimeImmutable;
+use DateTimeZone;
+use Psr\Container\ContainerExceptionInterface;
+use Psr\Container\ContainerInterface;
+use Psr\Container\NotFoundExceptionInterface;
+use Monolog\Formatter;
+use Monolog\Handler;
+use Monolog\Level;
+use Predis;
+use Incoviba;
+use Throwable;
+
+class ArrayBuilder
+{
+    public function __construct(protected ContainerInterface $container) {}
+
+    public function build(array $data): array
+    {
+        $handlers = [];
+        foreach ($data as $handlerData) {
+            if (in_array($handlerData['handler'], [Handler\StreamHandler::class, Handler\RotatingFileHandler::class,])) {
+                $params = [
+                    "/logs/{$handlerData['filename']}",
+                ];
+                if ($handlerData['handler'] === Handler\RotatingFileHandler::class) {
+                    $params []= 10;
+                }
+                try {
+                    $formatter = Formatter\LineFormatter::class;
+                    if (array_key_exists('formatter', $handlerData)) {
+                        $formatter = $handlerData['formatter'];
+                    }
+                    $handler = new $handlerData['handler'](...$params)
+                        ->setFormatter($this->container->get($formatter));
+                } catch (NotFoundExceptionInterface | ContainerExceptionInterface $exception) {
+                    $this->log($exception, ['handlerData' => $handlerData]);
+                    continue;
+                }
+            } elseif ($handlerData['handler'] === Incoviba\Common\Implement\Log\Handler\MySQL::class) {
+                try {
+                    $params = [
+                        $this->container->get(Incoviba\Common\Define\Connection::class)
+                    ];
+                    $formatter = Incoviba\Common\Implement\Log\Formatter\PDO::class;
+                    if (array_key_exists('formatter', $handlerData)) {
+                        $formatter = $handlerData['formatter'];
+                    }
+                    $handler = new $handlerData['handler'](...$params)
+                        ->setFormatter($this->container->get($formatter));
+                } catch (NotFoundExceptionInterface | ContainerExceptionInterface $exception) {
+                    $this->log($exception, ['handlerData' => $handlerData]);
+                    continue;
+                }
+            } elseif ($handlerData['handler'] === Handler\RedisHandler::class) {
+                try {
+                    $params = [
+                        $this->container->get(Predis\ClientInterface::class),
+                        "logs:{$handlerData['name']}"
+                    ];
+                } catch (NotFoundExceptionInterface | ContainerExceptionInterface $exception) {
+                    $this->log($exception, ['handlerData' => $handlerData]);
+                    continue;
+                }
+                $handler = new $handlerData['handler'](...$params);
+            }
+            if (!isset($handler)) {
+                $this->log("Invalid handler", ['handlerData' => $handlerData]);
+                continue;
+            }
+            $params = [
+                $handler,
+            ];
+            if (is_array($handlerData['levels'])) {
+                foreach ($handlerData['levels'] as $level) {
+                    $params []= $level;
+                }
+            } else {
+                $params []= $handlerData['levels'];
+                $params []= Level::Emergency;
+            }
+            $params []= false;
+            $handlers []= new Handler\FilterHandler(...$params);
+        }
+        return $handlers;
+    }
+
+    protected function log(string|Throwable $message, array $context = []): void
+    {
+        try {
+            $dateTime = new DateTimeImmutable('now', new DateTimeZone($_ENV['TZ'] ?? 'America/Santiago'));
+        } catch (DateMalformedStringException | DateInvalidTimeZoneException $exception) {
+            $dateTime = new DateTimeImmutable();
+        }
+        if (is_a($message, Throwable::class)) {
+            $exception = $message;
+            $message = $exception->getMessage();
+        }
+        $context = json_encode($context, JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE);
+        if ($context === false) {
+            $context = '[]';
+        }
+        $extra = [];
+        $extra['from'] = __FILE__;
+        if (isset($exception)) {
+            $extra['file'] = $exception->getFile();
+            $extra['line'] = $exception->getLine();
+            $extra['trace'] = $exception->getTrace();
+        }
+        $extra = json_encode($extra, JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE);
+        $code = 0;
+        if (isset($exception)) {
+            $code = $exception->getCode();
+        }
+        if ($extra === false) {
+            $extra = '[]';
+        }
+        $output = "[{$dateTime->format('Y-m-d H:i:s P')}] [{$code}] {$message} {$context} {$extra}";
+        $filename = '/logs/error.json';
+        $fileContents = [];
+        if (file_exists($filename)) {
+            $fileContents = file_get_contents($filename);
+            $fileContents = json_decode($fileContents, true);
+            if ($fileContents === false) {
+                $fileContents = [];
+            }
+        }
+        $fileContents[$dateTime->getTimestamp()] = $output;
+        $fileContents = json_encode($fileContents, JSON_UNESCAPED_SLASHES | JSON_UNESCAPED_UNICODE);
+        if ($fileContents === false) {
+            $fileContents = '[]';
+        }
+        file_put_contents($filename, $fileContents);
+    }
+}

app/common/Implement/Log/Processor/User.php

@@ -1,11 +1,11 @@
 <?php
-namespace Incoviba\Common\Implement\Log;
+namespace Incoviba\Common\Implement\Log\Processor;
 
+use Incoviba\Service;
 use Monolog\LogRecord;
 use Monolog\Processor\ProcessorInterface;
-use Incoviba\Service;
 
-class UserProcessor implements ProcessorInterface
+class User implements ProcessorInterface
 {
     public function __construct(protected Service\Login $loginService) {}
     public function __invoke(LogRecord $record): LogRecord

app/composer.json

@@ -4,6 +4,7 @@
     "type": "project",
     "require": {
         "ext-curl": "*",
+        "ext-dom": "*",
         "ext-gd": "*",
         "ext-openssl": "*",
         "ext-pdo": "*",
@@ -18,7 +19,8 @@
         "predis/predis": "^2",
         "robmorgan/phinx": "^0.16",
         "slim/slim": "^4",
-        "symfony/string": "^7.2"
+        "symfony/string": "^7.2",
+        "tedivm/jshrink": "^1.7"
     },
     "require-dev": {
         "fakerphp/faker": "^1",

app/phpunit.xml

@@ -28,16 +28,15 @@
       <directory>common</directory>
     </include>
   </source>
-  <coverage pathCoverage="false" ignoreDeprecatedCodeUnits="true" disableCodeCoverageIgnore="true">
+  <!--<coverage pathCoverage="false" ignoreDeprecatedCodeUnits="true" disableCodeCoverageIgnore="true">
     <report>
       <html outputDirectory="/code/public/coverage/html"/>
-      <php outputFile="/code/public/coverage/coverage.php"/>
     </report>
-  </coverage>
+  </coverage>-->
   <logging>
     <junit outputFile="/code/cache/tests/junit.xml"/>
     <teamcity outputFile="/code/cache/tests/teamcity.txt"/>
-    <testdoxHtml outputFile="/code/cache/tests/testdox.html"/>
+    <!--<testdoxHtml outputFile="/code/public/tests/testdox.html"/>-->
     <testdoxText outputFile="/code/cache/tests/testdox.txt"/>
   </logging>
 </phpunit>

app/public/index.php

@@ -13,3 +13,12 @@ try {
     $app->getContainer()->get(Psr\Log\LoggerInterface::class)->notice($exception);
     header('Location: /construccion');
 }
+register_shutdown_function(function() {
+    $error = error_get_last();
+
+    $fatal_errors = [E_ERROR, E_PARSE, E_CORE_ERROR, E_COMPILE_ERROR, E_USER_ERROR];
+    if ($error !== null and in_array($error['type'], $fatal_errors, true)) {
+        error_log(json_encode($error).PHP_EOL,3, '/logs/fatal.log');
+    }
+    error_clear_last();
+});

app/resources/database/migrations/20141101080001_create_agente.php

@@ -18,7 +18,7 @@ class CreateAgente extends Phinx\Migration\AbstractMigration
 			->addColumn('telefono', 'integer', ['length' => 11, 'default' => null, 'null' => true])
 			->addColumn('correo', 'string', ['length' => 50, 'default' => null, 'null' => true])
 			->addColumn('direccion', 'integer', ['length' => 11, 'default' => null, 'null' => true])
-			->addColumn('giro', 'mediumtext', ['default' => null, 'null' => true])
+			->addColumn('giro', 'text', ['default' => null, 'null' => true])
 			->addColumn('abreviacion', 'string', ['length' => 20, 'default' => null, 'null' => true])
 			->create();
 		$this->execute('SET unique_checks=1; SET foreign_key_checks=1;');

app/resources/database/migrations/20141101080007_create_cartolas.php

@@ -13,9 +13,9 @@ class CreateCartolas extends Phinx\Migration\AbstractMigration
 		$this->table('cartolas')
 			->addColumn('cuenta_id', 'integer', ['length' => 10, 'null' => false, 'signed' => false])
 			->addColumn('fecha', 'date', ['null' => false])
-			->addColumn('cargos', 'bigint', ['length' => 20, 'default' => 0, 'null' => false, 'signed' => false])
-			->addColumn('abonos', 'bigint', ['length' => 20, 'default' => 0, 'null' => false, 'signed' => false])
-			->addColumn('saldo', 'bigint', ['length' => 20, 'default' => 0, 'null' => false])
+			->addColumn('cargos', 'biginteger', ['length' => 20, 'default' => 0, 'null' => false, 'signed' => false])
+			->addColumn('abonos', 'biginteger', ['length' => 20, 'default' => 0, 'null' => false, 'signed' => false])
+			->addColumn('saldo', 'biginteger', ['length' => 20, 'default' => 0, 'null' => false])
 			->addForeignKey('cuenta_id', 'cuenta', 'id', ['delete' => 'cascade', 'update' => 'cascade'])
 			->create();
 		$this->execute('SET unique_checks=1; SET foreign_key_checks=1;');

app/resources/database/migrations/20141101080009_create_centros_costos.php

@@ -15,7 +15,7 @@ class CreateCentrosCostos extends Phinx\Migration\AbstractMigration
 			->addColumn('categoria_id', 'integer', ['length' => 10, 'null' => false, 'signed' => false])
 			->addColumn('tipo_cuenta_id', 'integer', ['length' => 10, 'default' => null, 'null' => true, 'signed' => false])
 			->addColumn('cuenta_contable', 'string', ['length' => 100, 'null' => false])
-			->addColumn('descripcion', 'mediumtext', ['null' => false])
+			->addColumn('descripcion', 'text', ['null' => false, 'limit' => MysqlAdapter::TEXT_MEDIUM])
 			->addForeignKey('tipo_centro_id', 'tipos_centros_costos', 'id', ['delete' => 'cascade', 'update' => 'cascade'])
 			->addForeignKey('categoria_id', 'categorias_centros_costos', 'id', ['delete' => 'cascade', 'update' => 'cascade'])
 			->create();

app/resources/database/migrations/20141101080011_create_cobro.php

@@ -19,7 +19,7 @@ class CreateCobro extends Phinx\Migration\AbstractMigration
 			->addColumn('iva', 'float', ['default' => 0])
 			->addColumn('uf', 'float', ['default' => null, 'null' => true])
 			->addColumn('identificador', 'string', ['length' => 50, 'default' => null, 'null' => true])
-			->addColumn('glosa', 'mediumtext', ['default' => null, 'null' => true])
+			->addColumn('glosa', 'text', ['default' => null, 'null' => true, 'limit' => MysqlAdapter::TEXT_MEDIUM])
 			->create();
 		$this->execute('SET unique_checks=1; SET foreign_key_checks=1;');
 	}

app/resources/database/migrations/20141101080024_create_escritura.php

@@ -11,7 +11,7 @@ class CreateEscritura extends Phinx\Migration\AbstractMigration
 		$this->execute("ALTER DATABASE COLLATE='utf8mb4_general_ci';");
 
 		$this->table('escritura')
-			->addColumn('valor', 'bigint', ['length' => 20, 'null' => false])
+			->addColumn('valor', 'biginteger', ['length' => 20, 'null' => false])
 			->addColumn('fecha', 'date', ['null' => false])
 			->addColumn('uf', 'float', ['default' => null, 'null' => true])
 			->addColumn('abonado', 'integer', ['length' => 11, 'default' => 0])

app/resources/database/migrations/20141101080029_create_estado_problema.php

@@ -13,7 +13,7 @@ class CreateEstadoProblema extends Phinx\Migration\AbstractMigration
 		$this->table('estado_problema')
 			->addColumn('problema', 'integer', ['length' => 11, 'default' => null, 'null' => true])
 			->addColumn('fecha', 'date', ['default' => null, 'null' => true])
-			->addColumn('estado', 'enum', ['length' => 'ingreso','revision','correccion','ok', 'default' => null, 'null' => true])
+			->addColumn('estado', 'enum', ['values' => ['ingreso','revision','correccion','ok'], 'default' => null, 'null' => true])
 			->create();
 		$this->execute('SET unique_checks=1; SET foreign_key_checks=1;');
 	}

app/resources/database/migrations/20141101080040_create_inmobiliarias_nubox.php

@@ -15,7 +15,7 @@ class CreateInmobiliariasNubox extends Phinx\Migration\AbstractMigration
 			->addColumn('alias', 'string', ['length' => 100, 'null' => false])
 			->addColumn('usuario', 'string', ['length' => 100, 'null' => false])
 			->addColumn('contraseña', 'string', ['length' => 100, 'null' => false])
-			->addForeignKey('inmobiliaria_rut', 'inmobiliaria', 'rut', ['delete' => 'cascade', 'update' => 'cascade'])
+			#->addForeignKey('inmobiliaria_rut', 'inmobiliaria', 'rut', ['delete' => 'cascade', 'update' => 'cascade'])
 			->create();
 		$this->execute('SET unique_checks=1; SET foreign_key_checks=1;');
 	}

app/resources/database/migrations/20141101080044_create_movimientos.php

@@ -15,9 +15,9 @@ class CreateMovimientos extends Phinx\Migration\AbstractMigration
 			->addColumn('fecha', 'date', ['null' => false])
 			->addColumn('glosa', 'text', ['null' => false])
 			->addColumn('documento', 'string', ['length' => 50, 'null' => false])
-			->addColumn('cargo', 'bigint', ['length' => 20, 'default' => 0, 'null' => false, 'signed' => false])
-			->addColumn('abono', 'bigint', ['length' => 20, 'default' => 0, 'null' => false, 'signed' => false])
-			->addColumn('saldo', 'bigint', ['length' => 20, 'default' => 0, 'null' => false])
+			->addColumn('cargo', 'biginteger', ['length' => 20, 'default' => 0, 'null' => false, 'signed' => false])
+			->addColumn('abono', 'biginteger', ['length' => 20, 'default' => 0, 'null' => false, 'signed' => false])
+			->addColumn('saldo', 'biginteger', ['length' => 20, 'default' => 0, 'null' => false])
 			->addForeignKey('cuenta_id', 'cuenta', 'id', ['delete' => 'cascade', 'update' => 'cascade'])
 			->create();
 		$this->execute('SET unique_checks=1; SET foreign_key_checks=1;');

app/resources/database/migrations/20141101080054_create_problema.php

@@ -12,7 +12,7 @@ class CreateProblema extends Phinx\Migration\AbstractMigration
 
 		$this->table('problema')
 			->addColumn('venta', 'integer', ['length' => 11, 'default' => null, 'null' => true])
-			->addColumn('descripcion', 'mediumtext', ['default' => null, 'null' => true])
+			->addColumn('descripcion', 'text', ['default' => null, 'null' => true, 'limit' => MysqlAdapter::TEXT_MEDIUM])
 			->create();
 		$this->execute('SET unique_checks=1; SET foreign_key_checks=1;');
 	}

app/resources/database/migrations/20141101080104_create_proyecto.php

@@ -12,7 +12,7 @@ class CreateProyecto extends Phinx\Migration\AbstractMigration
 
 		$this->table('proyecto')
 			->addColumn('inmobiliaria', 'integer', ['length' => 10, 'default' => null, 'null' => true, 'signed' => false])
-			->addColumn('descripcion', 'mediumtext', ['null' => false])
+			->addColumn('descripcion', 'text', ['null' => false, 'limit' => MysqlAdapter::TEXT_MEDIUM])
 			->addColumn('direccion', 'integer', ['length' => 10, 'null' => false, 'signed' => false])
 			->addColumn('superficie_terreno', 'float', ['default' => 0, 'null' => false, 'signed' => false])
 			->addColumn('valor_terreno', 'float', ['default' => 0, 'null' => false, 'signed' => false])

app/resources/database/migrations/20141101080107_create_proyecto_tipo_unidad.php

@@ -18,7 +18,7 @@ class CreateProyectoTipoUnidad extends Phinx\Migration\AbstractMigration
 			->addColumn('m2', 'float', ['default' => null, 'null' => true])
 			->addColumn('logia', 'float', ['default' => 0])
 			->addColumn('terraza', 'float', ['default' => 0])
-			->addColumn('descripcion', 'mediumtext', ['default' => null, 'null' => true])
+			->addColumn('descripcion', 'text', ['default' => null, 'null' => true, 'limit' => MysqlAdapter::TEXT_MEDIUM])
 			->addForeignKey('proyecto', 'proyecto', 'id', ['delete' => 'cascade', 'update' => 'cascade'])
 			->create();
 		$this->execute('SET unique_checks=1; SET foreign_key_checks=1;');

app/resources/database/migrations/20141101080122_create_tipo_estado_pago.php

@@ -10,7 +10,8 @@ class CreateTipoEstadoPago extends Phinx\Migration\AbstractMigration
 		$this->execute("ALTER DATABASE CHARACTER SET 'utf8mb4';");
 		$this->execute("ALTER DATABASE COLLATE='utf8mb4_general_ci';");
 
-		$this->table('tipo_estado_pago')
+		$this->table('tipo_estado_pago', ['id' => false, 'primary_key' => 'id'])
+            ->addColumn('id', 'integer', ['signed' => true])
 			->addColumn('descripcion', 'string', ['length' => 20, 'default' => null, 'null' => true])
 			->addColumn('active', 'integer', ['length' => 1, 'default' => 0])
 			->create();

app/resources/database/migrations/20141101080146_create_venta.php

@@ -33,7 +33,7 @@ class CreateVenta extends Phinx\Migration\AbstractMigration
 			->addColumn('resciliacion', 'integer', ['length' => 10, 'default' => null, 'null' => true, 'signed' => false])
 			->addColumn('devolucion', 'integer', ['length' => 10, 'default' => null, 'null' => true, 'signed' => false])
 			->addForeignKey('propiedad', 'propiedad', 'id', ['delete' => 'cascade', 'update' => 'cascade'])
-			->addForeignKey('propietario', 'propietario', 'rut', ['delete' => 'cascade', 'update' => 'cascade'])
+			#->addForeignKey('propietario', 'propietario', 'rut', ['delete' => 'cascade', 'update' => 'cascade'])
 			->create();
 		$this->execute('SET unique_checks=1; SET foreign_key_checks=1;');
 	}

app/resources/database/migrations/20141101080147_create_venta_abono_cuotas.php

@@ -1,22 +0,0 @@
-<?php
-
-use Phinx\Db\Adapter\MysqlAdapter;
-
-class CreateVentaAbonoCuotas extends Phinx\Migration\AbstractMigration
-{
-	public function change(): void
-	{
-		$this->execute('SET unique_checks=0; SET foreign_key_checks=0;');
-		$this->execute("ALTER DATABASE CHARACTER SET 'utf8mb4';");
-		$this->execute("ALTER DATABASE COLLATE='utf8mb4_general_ci';");
-
-		$this->table('venta_abono_cuotas')
-			->addColumn('venta_id', 'integer', ['length' => 11, 'null' => false, 'signed' => false])
-			->addColumn('pago_id', 'integer', ['length' => 11, 'null' => false, 'signed' => false])
-			->addColumn('numero', 'integer', ['length' => 11, 'default' => 1, 'null' => false, 'signed' => false])
-			->addForeignKey('venta_id', 'venta', 'id', ['delete' => 'cascade', 'update' => 'cascade'])
-			->addForeignKey('pago_id', 'pago', 'id', ['delete' => 'cascade', 'update' => 'cascade'])
-			->create();
-		$this->execute('SET unique_checks=1; SET foreign_key_checks=1;');
-	}
-}

app/resources/database/migrations/20250215133405_create_broker.php

@@ -0,0 +1,28 @@
+<?php
+
+declare(strict_types=1);
+
+use Phinx\Migration\AbstractMigration;
+
+final class CreateBroker extends AbstractMigration
+{
+    /**
+     * Change Method.
+     *
+     * Write your reversible migrations using this method.
+     *
+     * More information on writing migrations is available here:
+     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
+     *
+     * Remember to call "create()" or "update()" and NOT "save()" when working
+     * with the Table class.
+     */
+    public function change(): void
+    {
+        $this->table('brokers', ['id' => false, 'primary_key' => ['rut']])
+            ->addColumn('rut', 'integer', ['identity' => true, 'signed' => false, 'null' => false])
+            ->addColumn('digit', 'string', ['length' => 1, 'null' => false])
+            ->addColumn('name', 'string', ['length' => 255, 'null' => false])
+            ->create();
+    }
+}

app/resources/database/migrations/20250215133411_create_broker_contract.php

@@ -0,0 +1,36 @@
+<?php
+
+declare(strict_types=1);
+
+use Phinx\Migration\AbstractMigration;
+
+final class CreateBrokerContract extends AbstractMigration
+{
+    /**
+     * Change Method.
+     *
+     * Write your reversible migrations using this method.
+     *
+     * More information on writing migrations is available here:
+     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
+     *
+     * Remember to call "create()" or "update()" and NOT "save()" when working
+     * with the Table class.
+     */
+    public function change(): void
+    {
+        $this->execute('SET unique_checks=0; SET foreign_key_checks=0;');
+        $this->execute("ALTER DATABASE CHARACTER SET 'utf8mb4';");
+        $this->execute("ALTER DATABASE COLLATE='utf8mb4_general_ci';");
+
+        $this->table('broker_contracts')
+            ->addColumn('broker_rut', 'integer', ['signed' => false, 'null' => false])
+            ->addColumn('project_id', 'integer', ['signed' => false, 'null' => false])
+            ->addColumn('commission', 'decimal', ['precision' => 10, 'scale' => 2, 'null' => false])
+            ->addForeignKey('broker_rut', 'brokers', 'rut', ['delete' => 'cascade', 'update' => 'cascade'])
+            ->addForeignKey('project_id', 'proyecto', 'id', ['delete' => 'cascade', 'update' => 'cascade'])
+            ->create();
+
+        $this->execute('SET unique_checks=1; SET foreign_key_checks=1;');
+    }
+}

app/resources/database/migrations/20250215133419_create_broker_data.php

@@ -0,0 +1,36 @@
+<?php
+
+declare(strict_types=1);
+
+use Phinx\Migration\AbstractMigration;
+
+final class CreateBrokerData extends AbstractMigration
+{
+    /**
+     * Change Method.
+     *
+     * Write your reversible migrations using this method.
+     *
+     * More information on writing migrations is available here:
+     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
+     *
+     * Remember to call "create()" or "update()" and NOT "save()" when working
+     * with the Table class.
+     */
+    public function change(): void
+    {
+        $this->execute('SET unique_checks=0; SET foreign_key_checks=0;');
+        $this->execute("ALTER DATABASE CHARACTER SET 'utf8mb4';");
+        $this->execute("ALTER DATABASE COLLATE='utf8mb4_general_ci';");
+
+        $this->table('broker_data')
+            ->addColumn('broker_rut', 'integer', ['signed' => false, 'null' => false])
+            ->addColumn('representative_id', 'integer', ['signed' => false, 'null' => true, 'default' => null])
+            ->addColumn('legal_name', 'string', ['length' => 255, 'default' => null, 'null' => true])
+            ->addForeignKey('broker_rut', 'brokers', ['rut'], ['delete' => 'CASCADE', 'update' => 'CASCADE'])
+            ->addForeignKey('representative_id', 'broker_contacts', ['id'], ['delete' => 'CASCADE', 'update' => 'CASCADE'])
+            ->create();
+
+        $this->execute('SET unique_checks=1; SET foreign_key_checks=1;');
+    }
+}

app/resources/database/migrations/20250215133429_create_promotion.php

@@ -0,0 +1,38 @@
+<?php
+
+declare(strict_types=1);
+
+use Phinx\Migration\AbstractMigration;
+
+final class CreatePromotion extends AbstractMigration
+{
+    /**
+     * Change Method.
+     *
+     * Write your reversible migrations using this method.
+     *
+     * More information on writing migrations is available here:
+     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
+     *
+     * Remember to call "create()" or "update()" and NOT "save()" when working
+     * with the Table class.
+     */
+    public function change(): void
+    {
+        $this->execute('SET unique_checks=0; SET foreign_key_checks=0;');
+        $this->execute("ALTER DATABASE CHARACTER SET 'utf8mb4';");
+        $this->execute("ALTER DATABASE COLLATE='utf8mb4_general_ci';");
+
+        $this->table('promotions')
+            ->addColumn('price_id', 'integer', ['signed' => false, 'null' => false])
+            ->addColumn('amount', 'decimal', ['precision' => 10, 'scale' => 2, 'null' => false])
+            ->addColumn('start_date', 'date', ['null' => false])
+            ->addColumn('end_date', 'date', ['null' => false])
+            ->addColumn('valid_until', 'date', ['null' => false])
+            ->addColumn('state', 'integer', ['length' => 1, 'null' => false, 'default' => 1])
+            ->addForeignKey('price_id', 'prices', 'id', ['delete' => 'cascade', 'update' => 'cascade'])
+            ->create();
+
+        $this->execute('SET unique_checks=1; SET foreign_key_checks=1;');
+    }
+}

app/resources/database/migrations/20250215133437_create_reservation.php

@@ -0,0 +1,34 @@
+<?php
+
+declare(strict_types=1);
+
+use Phinx\Migration\AbstractMigration;
+
+final class CreateReservation extends AbstractMigration
+{
+    /**
+     * Change Method.
+     *
+     * Write your reversible migrations using this method.
+     *
+     * More information on writing migrations is available here:
+     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
+     *
+     * Remember to call "create()" or "update()" and NOT "save()" when working
+     * with the Table class.
+     */
+    public function change(): void
+    {
+        $this->execute('SET unique_checks=0; SET foreign_key_checks=0;');
+        $this->execute("ALTER DATABASE CHARACTER SET 'utf8mb4';");
+        $this->execute("ALTER DATABASE COLLATE='utf8mb4_general_ci';");
+
+        $this->table('reservation')
+            ->addColumn('buyer_rut', 'integer', ['signed' => false, 'null' => false])
+            ->addColumn('date', 'date', ['null' => false])
+            ->addForeignKey('buyer_rut', 'personas', 'rut', ['delete' => 'cascade', 'update' => 'cascade'])
+            ->create();
+
+        $this->execute('SET unique_checks=1; SET foreign_key_checks=1;');
+    }
+}

app/resources/database/migrations/20250215133451_create_broker_contract_state.php

@@ -0,0 +1,35 @@
+<?php
+
+declare(strict_types=1);
+
+use Phinx\Migration\AbstractMigration;
+
+final class CreateBrokerContractState extends AbstractMigration
+{
+    /**
+     * Change Method.
+     *
+     * Write your reversible migrations using this method.
+     *
+     * More information on writing migrations is available here:
+     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
+     *
+     * Remember to call "create()" or "update()" and NOT "save()" when working
+     * with the Table class.
+     */
+    public function change(): void
+    {
+        $this->execute('SET unique_checks=0; SET foreign_key_checks=0;');
+        $this->execute("ALTER DATABASE CHARACTER SET 'utf8mb4';");
+        $this->execute("ALTER DATABASE COLLATE='utf8mb4_general_ci';");
+
+        $this->table('broker_contract_states')
+            ->addColumn('contract_id', 'integer', ['signed' => false, 'null' => false])
+            ->addColumn('date', 'date', ['null' => false])
+            ->addColumn('type', 'integer', ['length' => 1, 'null' => false, 'default' => 0])
+            ->addForeignKey('contract_id', 'broker_contracts', 'id', ['delete' => 'cascade', 'update' => 'cascade'])
+            ->create();
+
+        $this->execute('SET unique_checks=1; SET foreign_key_checks=1;');
+    }
+}

app/resources/database/migrations/20250215135457_create_reservation_datas.php

@@ -0,0 +1,35 @@
+<?php
+
+declare(strict_types=1);
+
+use Phinx\Migration\AbstractMigration;
+
+final class CreateReservationDatas extends AbstractMigration
+{
+    /**
+     * Change Method.
+     *
+     * Write your reversible migrations using this method.
+     *
+     * More information on writing migrations is available here:
+     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
+     *
+     * Remember to call "create()" or "update()" and NOT "save()" when working
+     * with the Table class.
+     */
+    public function change(): void
+    {
+        $this->execute('SET unique_checks=0; SET foreign_key_checks=0;');
+        $this->execute("ALTER DATABASE CHARACTER SET 'utf8mb4';");
+        $this->execute("ALTER DATABASE COLLATE='utf8mb4_general_ci';");
+
+        $this->table('reservation_data')
+            ->addColumn('reservation_id', 'integer', ['signed' => false, 'null' => false])
+            ->addColumn('type', 'integer', ['length' => 1, 'signed' => false, 'null' => false])
+            ->addColumn('reference_id', 'integer', ['signed' => false, 'null' => false])
+            ->addColumn('value', 'decimal', ['precision' => 10, 'scale' => 2, 'signed' => false, 'default' => 0.00, 'null' => true])
+            ->create();
+
+        $this->execute('SET unique_checks=1; SET foreign_key_checks=1;');
+    }
+}

app/resources/database/migrations/20250215135822_create_reservation_states.php

@@ -0,0 +1,35 @@
+<?php
+
+declare(strict_types=1);
+
+use Phinx\Migration\AbstractMigration;
+
+final class CreateReservationStates extends AbstractMigration
+{
+    /**
+     * Change Method.
+     *
+     * Write your reversible migrations using this method.
+     *
+     * More information on writing migrations is available here:
+     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
+     *
+     * Remember to call "create()" or "update()" and NOT "save()" when working
+     * with the Table class.
+     */
+    public function change(): void
+    {
+        $this->execute('SET unique_checks=0; SET foreign_key_checks=0;');
+        $this->execute("ALTER DATABASE CHARACTER SET 'utf8mb4';");
+        $this->execute("ALTER DATABASE COLLATE='utf8mb4_general_ci';");
+
+        $this->table('reservation_states')
+            ->addColumn('reservation_id', 'integer', ['signed' => false, 'null' => false])
+            ->addColumn('date', 'date', ['null' => false])
+            ->addColumn('type', 'integer', ['length' => 3, 'null' => false, 'default' => 0])
+            ->addForeignKey('reservation_id', 'reservation', 'id', ['delete' => 'cascade', 'update' => 'cascade'])
+            ->create();
+
+        $this->execute('SET unique_checks=1; SET foreign_key_checks=1;');
+    }
+}

app/resources/database/migrations/20250307190931_create_broker_contacts.php

@@ -0,0 +1,38 @@
+<?php
+
+declare(strict_types=1);
+
+use Phinx\Migration\AbstractMigration;
+
+final class CreateBrokerContacts extends AbstractMigration
+{
+    /**
+     * Change Method.
+     *
+     * Write your reversible migrations using this method.
+     *
+     * More information on writing migrations is available here:
+     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
+     *
+     * Remember to call "create()" or "update()" and NOT "save()" when working
+     * with the Table class.
+     */
+    public function change(): void
+    {
+        $this->execute('SET unique_checks=0; SET foreign_key_checks=0;');
+        $this->execute("ALTER DATABASE CHARACTER SET 'utf8mb4';");
+        $this->execute("ALTER DATABASE COLLATE='utf8mb4_general_ci';");
+
+        $this->table('broker_contacts')
+            ->addColumn('rut', 'integer', ['signed' => false, 'null' => true])
+            ->addColumn('digit', 'string', ['length' => 1, 'null' => true])
+            ->addColumn('name', 'string', ['length' => 255, 'null' => true])
+            ->addColumn('email', 'string', ['length' => 255, 'null' => true])
+            ->addColumn('phone', 'string', ['length' => 255, 'null' => true])
+            ->addColumn('address_id', 'integer', ['signed' => false, 'null' => true])
+            ->addForeignKey('address_id', 'direccion', ['id'], ['delete' => 'CASCADE', 'update' => 'CASCADE'])
+            ->create();
+
+        $this->execute('SET unique_checks=1; SET foreign_key_checks=1;');
+    }
+}

app/resources/database/migrations/20250317193111_alter_promotions_remove_price.php

@@ -0,0 +1,31 @@
+<?php
+
+declare(strict_types=1);
+
+use Phinx\Migration\AbstractMigration;
+
+final class AlterPromotionsRemovePrice extends AbstractMigration
+{
+    /**
+     * Change Method.
+     *
+     * Write your reversible migrations using this method.
+     *
+     * More information on writing migrations is available here:
+     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
+     *
+     * Remember to call "create()" or "update()" and NOT "save()" when working
+     * with the Table class.
+     */
+    public function up(): void
+    {
+        if ($this->table('promotions')->hasColumn('price_id')) {
+            $this->table('promotions')
+                ->dropForeignKey('price_id')
+                ->removeColumn('price_id')
+                ->update();
+        }
+    }
+
+    public function down(): void {}
+}

app/resources/database/migrations/20250317193246_create_promotion_unit.php

@@ -0,0 +1,30 @@
+<?php
+
+declare(strict_types=1);
+
+use Phinx\Migration\AbstractMigration;
+
+final class CreatePromotionUnit extends AbstractMigration
+{
+    /**
+     * Change Method.
+     *
+     * Write your reversible migrations using this method.
+     *
+     * More information on writing migrations is available here:
+     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
+     *
+     * Remember to call "create()" or "update()" and NOT "save()" when working
+     * with the Table class.
+     */
+    public function change(): void
+    {
+        $this->table('promotion_units')
+            ->addColumn('promotion_id', 'integer', ['signed' => false, 'null' => false])
+            ->addColumn('unit_id', 'integer', ['signed' => false, 'null' => false])
+            ->addColumn('created_at', 'datetime', ['null' => false, 'default' => 'CURRENT_TIMESTAMP'])
+            ->addForeignKey('promotion_id', 'promotions', 'id', ['delete' => 'CASCADE', 'update' => 'CASCADE'])
+            ->addForeignKey('unit_id', 'unidad', 'id', ['delete' => 'CASCADE', 'update' => 'CASCADE'])
+            ->create();
+    }
+}

app/resources/database/migrations/20250318204147_alter_promotions_null_dates.php

@@ -0,0 +1,28 @@
+<?php
+
+declare(strict_types=1);
+
+use Phinx\Migration\AbstractMigration;
+
+final class AlterPromotionsNullDates extends AbstractMigration
+{
+    /**
+     * Change Method.
+     *
+     * Write your reversible migrations using this method.
+     *
+     * More information on writing migrations is available here:
+     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
+     *
+     * Remember to call "create()" or "update()" and NOT "save()" when working
+     * with the Table class.
+     */
+    public function up(): void
+    {
+        $this->table('promotions')
+            ->changeColumn('end_date', 'date', ['null' => true])
+            ->changeColumn('valid_until', 'date', ['null' => true])
+            ->update();
+    }
+    public function down(): void {}
+}

app/resources/database/migrations/20250318205221_alter_promotions_add_description_and_type.php

@@ -0,0 +1,27 @@
+<?php
+
+declare(strict_types=1);
+
+use Phinx\Migration\AbstractMigration;
+
+final class AlterPromotionsAddDescriptionAndType extends AbstractMigration
+{
+    /**
+     * Change Method.
+     *
+     * Write your reversible migrations using this method.
+     *
+     * More information on writing migrations is available here:
+     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
+     *
+     * Remember to call "create()" or "update()" and NOT "save()" when working
+     * with the Table class.
+     */
+    public function change(): void
+    {
+        $this->table('promotions')
+            ->addColumn('description', 'string', ['limit' => 255, 'null' => false, 'after' => 'id'])
+            ->addColumn('type', 'integer', ['limit' => 1, 'null' => false, 'default' => 0, 'after' => 'description'])
+            ->update();
+    }
+}

app/resources/database/migrations/20250318231051_create_promotion_projects.php

@@ -0,0 +1,29 @@
+<?php
+
+declare(strict_types=1);
+
+use Phinx\Migration\AbstractMigration;
+
+final class CreatePromotionProjects extends AbstractMigration
+{
+    /**
+     * Change Method.
+     *
+     * Write your reversible migrations using this method.
+     *
+     * More information on writing migrations is available here:
+     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
+     *
+     * Remember to call "create()" or "update()" and NOT "save()" when working
+     * with the Table class.
+     */
+    public function change(): void
+    {
+        $this->table('promotion_projects')
+            ->addColumn('promotion_id', 'integer', ['signed' => false, 'null' => false])
+            ->addColumn('project_id', 'integer', ['signed' => false, 'null' => false])
+            ->addForeignKey('promotion_id', 'promotions', 'id', ['delete' => 'cascade', 'update' => 'cascade'])
+            ->addForeignKey('project_id', 'proyecto', 'id', ['delete' => 'cascade', 'update' => 'cascade'])
+            ->create();
+    }
+}

app/resources/database/migrations/20250403175937_create_promotion_brokers.php

@@ -0,0 +1,29 @@
+<?php
+
+declare(strict_types=1);
+
+use Phinx\Migration\AbstractMigration;
+
+final class CreatePromotionBrokers extends AbstractMigration
+{
+    /**
+     * Change Method.
+     *
+     * Write your reversible migrations using this method.
+     *
+     * More information on writing migrations is available here:
+     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
+     *
+     * Remember to call "create()" or "update()" and NOT "save()" when working
+     * with the Table class.
+     */
+    public function change(): void
+    {
+        $this->table('promotion_brokers')
+            ->addColumn('promotion_id', 'integer', ['signed' => false, 'null' => false])
+            ->addColumn('broker_rut', 'integer', ['signed' => false, 'null' => false])
+            ->addForeignKey('promotion_id', 'promotions', 'id', ['delete' => 'CASCADE', 'update' => 'CASCADE'])
+            ->addForeignKey('broker_rut', 'brokers', 'rut', ['delete' => 'CASCADE', 'update' => 'CASCADE'])
+            ->create();
+    }
+}

app/resources/database/migrations/20250403175950_create_promotion_unit_lines.php

@@ -0,0 +1,29 @@
+<?php
+
+declare(strict_types=1);
+
+use Phinx\Migration\AbstractMigration;
+
+final class CreatePromotionUnitLines extends AbstractMigration
+{
+    /**
+     * Change Method.
+     *
+     * Write your reversible migrations using this method.
+     *
+     * More information on writing migrations is available here:
+     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
+     *
+     * Remember to call "create()" or "update()" and NOT "save()" when working
+     * with the Table class.
+     */
+    public function change(): void
+    {
+        $this->table('promotion_unit_lines')
+            ->addColumn('promotion_id', 'integer', ['signed' => false, 'null' => false])
+            ->addColumn('unit_line_id', 'integer', ['signed' => false, 'null' => false])
+            ->addForeignKey('promotion_id', 'promotions', 'id', ['delete' => 'CASCADE', 'update' => 'CASCADE'])
+            ->addForeignKey('unit_line_id', 'proyecto_tipo_unidad', 'id', ['delete' => 'CASCADE', 'update' => 'CASCADE'])
+            ->create();
+    }
+}

app/resources/database/migrations/20250403175954_create_promotion_unit_types.php

@@ -0,0 +1,31 @@
+<?php
+
+declare(strict_types=1);
+
+use Phinx\Migration\AbstractMigration;
+
+final class CreatePromotionUnitTypes extends AbstractMigration
+{
+    /**
+     * Change Method.
+     *
+     * Write your reversible migrations using this method.
+     *
+     * More information on writing migrations is available here:
+     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
+     *
+     * Remember to call "create()" or "update()" and NOT "save()" when working
+     * with the Table class.
+     */
+    public function change(): void
+    {
+        $this->table('promotion_unit_types')
+            ->addColumn('promotion_id', 'integer', ['signed' => false, 'null' => false])
+            ->addColumn('project_id', 'integer', ['signed' => false, 'null' => false])
+            ->addColumn('unit_type_id', 'integer', ['signed' => false, 'null' => false])
+            ->addForeignKey('promotion_id', 'promotions', 'id', ['delete' => 'CASCADE', 'update' => 'CASCADE'])
+            ->addForeignKey('project_id', 'proyecto', 'id', ['delete' => 'CASCADE', 'update' => 'CASCADE'])
+            ->addForeignKey('unit_type_id', 'tipo_unidad', 'id', ['delete' => 'CASCADE', 'update' => 'CASCADE'])
+            ->create();
+    }
+}

app/resources/database/migrations/20250506164824_create_toku_customers.php

@@ -0,0 +1,29 @@
+<?php
+
+declare(strict_types=1);
+
+use Phinx\Migration\AbstractMigration;
+
+final class CreateTokuCustomers extends AbstractMigration
+{
+    /**
+     * Change Method.
+     *
+     * Write your reversible migrations using this method.
+     *
+     * More information on writing migrations is available here:
+     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
+     *
+     * Remember to call "create()" or "update()" and NOT "save()" when working
+     * with the Table class.
+     */
+    public function change(): void
+    {
+        $this->table('toku_customers')
+            ->addColumn('rut', 'string', ['length' => 9])
+            ->addColumn('toku_id', 'string', ['length' => 255])
+            ->addTimestamps()
+            ->addIndex(['rut'], ['unique' => true])
+            ->create();
+    }
+}

app/resources/database/migrations/20250506212422_create_toku_subscriptions.php

@@ -0,0 +1,29 @@
+<?php
+
+declare(strict_types=1);
+
+use Phinx\Migration\AbstractMigration;
+
+final class CreateTokuSubscriptions extends AbstractMigration
+{
+    /**
+     * Change Method.
+     *
+     * Write your reversible migrations using this method.
+     *
+     * More information on writing migrations is available here:
+     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
+     *
+     * Remember to call "create()" or "update()" and NOT "save()" when working
+     * with the Table class.
+     */
+    public function change(): void
+    {
+        $this->table('toku_subscriptions')
+            ->addColumn('venta_id', 'integer', ['signed' => false])
+            ->addColumn('toku_id', 'string', ['length' => 255])
+            ->addTimestamps()
+            ->addIndex(['venta_id'], ['unique' => true])
+            ->create();
+    }
+}

app/resources/database/migrations/20250506213859_create_toku_invoices.php

@@ -0,0 +1,29 @@
+<?php
+
+declare(strict_types=1);
+
+use Phinx\Migration\AbstractMigration;
+
+final class CreateTokuInvoices extends AbstractMigration
+{
+    /**
+     * Change Method.
+     *
+     * Write your reversible migrations using this method.
+     *
+     * More information on writing migrations is available here:
+     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
+     *
+     * Remember to call "create()" or "update()" and NOT "save()" when working
+     * with the Table class.
+     */
+    public function change(): void
+    {
+        $this->table('toku_invoices')
+            ->addColumn('cuota_id', 'integer', ['signed' => false])
+            ->addColumn('toku_id', 'string', ['length' => 255])
+            ->addTimestamps()
+            ->addIndex(['cuota_id'], ['unique' => true])
+            ->create();
+    }
+}

app/resources/database/migrations/20250512175057_create_jobs.php

@@ -0,0 +1,28 @@
+<?php
+
+declare(strict_types=1);
+
+use Phinx\Migration\AbstractMigration;
+
+final class CreateJobs extends AbstractMigration
+{
+    /**
+     * Change Method.
+     *
+     * Write your reversible migrations using this method.
+     *
+     * More information on writing migrations is available here:
+     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
+     *
+     * Remember to call "create()" or "update()" and NOT "save()" when working
+     * with the Table class.
+     */
+    public function change(): void
+    {
+        $this->table('jobs')
+            ->addColumn('configuration', 'json')
+            ->addColumn('executed', 'boolean', ['default' => false])
+            ->addTimestamps()
+            ->create();
+    }
+}

app/resources/database/migrations/20250604015839_create_toku_webhooks.php

@@ -0,0 +1,29 @@
+<?php
+
+declare(strict_types=1);
+
+use Phinx\Migration\AbstractMigration;
+
+final class CreateTokuWebhooks extends AbstractMigration
+{
+    /**
+     * Change Method.
+     *
+     * Write your reversible migrations using this method.
+     *
+     * More information on writing migrations is available here:
+     * https://book.cakephp.org/phinx/0/en/migrations.html#the-change-method
+     *
+     * Remember to call "create()" or "update()" and NOT "save()" when working
+     * with the Table class.
+     */
+    public function change(): void
+    {
+        $this->table('toku_webhooks')
+            ->addColumn('secret', 'string', ['length' => 255])
+            ->addColumn('events', 'json')
+            ->addColumn('enabled', 'boolean', ['default' => true])
+            ->addTimestamps()
+            ->create();
+    }
+}

app/resources/database/seeds/Comuna.php

@@ -0,0 +1,391 @@
+<?php
+
+declare(strict_types=1);
+
+use Phinx\Seed\AbstractSeed;
+
+class Comuna extends AbstractSeed
+{
+    /**
+     * Run Method.
+     *
+     * Write your database seeder using this method.
+     *
+     * More information on writing seeders is available here:
+     * https://book.cakephp.org/phinx/0/en/seeding.html
+     */
+    public function run(): void
+    {
+/*id	descripcion	provincia
+1101	Iquique	11
+1107	Alto Hospicio	11
+1401	Pozo Almonte	14
+1402	Camiña	14
+1403	Colchane	14
+1404	Huara	14
+1405	Pica	14
+2101	Antofagasta	21
+2102	Mejillones	21
+2103	Sierra Gorda	21
+2104	Taltal	21
+2201	Calama	22
+2202	Ollagüe	22
+2203	San Pedro de Atacama	22
+2301	Tocopilla	23
+2302	María Elena	23
+3101	Copiapó	31
+3102	Caldera	31
+3103	Tierra Amarilla	31
+3201	Chañaral	32
+3202	Diego de Almagro	32
+3301	Vallenar	33
+3302	Alto del Carmen	33
+3303	Freirina	33
+3304	Huasco	33
+4101	La Serena	41
+4102	Coquimbo	41
+4103	Andacollo	41
+4104	La Higuera	41
+4105	Paiguano	41
+4106	Vicuña	41
+4201	Illapel	42
+4202	Canela	42
+4203	Los Vilos	42
+4204	Salamanca	42
+4301	Ovalle	43
+4302	Combarbalá	43
+4303	Monte Patria	43
+4304	Punitaqui	43
+4305	Río Hurtado	43
+5101	Valparaíso	51
+5102	Casablanca	51
+5103	Concón	51
+5104	Juan Fernández	51
+5105	Puchuncaví	51
+5107	Quintero	51
+5109	Viña del Mar	51
+5201	Isla de Pascua	52
+5301	Los Andes	53
+5302	Calle Larga	53
+5303	Rinconada	53
+5304	San Esteban	53
+5401	La Ligua	54
+5402	Cabildo	54
+5403	Papudo	54
+5404	Petorca	54
+5405	Zapallar	54
+5501	Quillota	55
+5502	Calera	55
+5503	Hijuelas	55
+5504	La Cruz	55
+5506	Nogales	55
+5601	San Antonio	56
+5602	Algarrobo	56
+5603	Cartagena	56
+5604	El Quisco	56
+5605	El Tabo	56
+5606	Santo Domingo	56
+5701	San Felipe	57
+5702	Catemu	57
+5703	Llaillay	57
+5704	Panquehue	57
+5705	Putaendo	57
+5706	Santa María	57
+5801	Quilpué	58
+5802	Limache	58
+5803	Olmué	58
+5804	Villa Alemana	58
+6101	Rancagua	61
+6102	Codegua	61
+6103	Coinco	61
+6104	Coltauco	61
+6105	Doñihue	61
+6106	Graneros	61
+6107	Las Cabras	61
+6108	Machalí	61
+6109	Malloa	61
+6110	Mostazal	61
+6111	Olivar	61
+6112	Peumo	61
+6113	Pichidegua	61
+6114	Quinta de Tilcoco	61
+6115	Rengo	61
+6116	Requínoa	61
+6117	San Vicente	61
+6201	Pichilemu	62
+6202	La Estrella	62
+6203	Litueche	62
+6204	Marchihue	62
+6205	Navidad	62
+6206	Paredones	62
+6301	San Fernando	63
+6302	Chépica	63
+6303	Chimbarongo	63
+6304	Lolol	63
+6305	Nancagua	63
+6306	Palmilla	63
+6307	Peralillo	63
+6308	Placilla	63
+6309	Pumanque	63
+6310	Santa Cruz	63
+7101	Talca	71
+7102	Constitución	71
+7103	Curepto	71
+7104	Empedrado	71
+7105	Maule	71
+7106	Pelarco	71
+7107	Pencahue	71
+7108	Río Claro	71
+7109	San Clemente	71
+7110	San Rafael	71
+7201	Cauquenes	72
+7202	Chanco	72
+7203	Pelluhue	72
+7301	Curicó	73
+7302	Hualañé	73
+7303	Licantén	73
+7304	Molina	73
+7305	Rauco	73
+7306	Romeral	73
+7307	Sagrada Familia	73
+7308	Teno	73
+7309	Vichuquén	73
+7401	Linares	74
+7402	Colbún	74
+7403	Longaví	74
+7404	Parral	74
+7405	Retiro	74
+7406	San Javier	74
+7407	Villa Alegre	74
+7408	Yerbas Buenas	74
+8101	Concepción	81
+8102	Coronel	81
+8103	Chiguayante	81
+8104	Florida	81
+8105	Hualqui	81
+8106	Lota	81
+8107	Penco	81
+8108	San Pedro de la Paz	81
+8109	Santa Juana	81
+8110	Talcahuano	81
+8111	Tomé	81
+8112	Hualpén	81
+8201	Lebu	82
+8202	Arauco	82
+8203	Cañete	82
+8204	Contulmo	82
+8205	Curanilahue	82
+8206	Los Álamos	82
+8207	Tirúa	82
+8301	Los Ángeles	83
+8302	Antuco	83
+8303	Cabrero	83
+8304	Laja	83
+8305	Mulchén	83
+8306	Nacimiento	83
+8307	Negrete	83
+8308	Quilaco	83
+8309	Quilleco	83
+8310	San Rosendo	83
+8311	Santa Bárbara	83
+8312	Tucapel	83
+8313	Yumbel	83
+8314	Alto Biobío	83
+8401	Chillán	84
+8402	Bulnes	84
+8403	Cobquecura	84
+8404	Coelemu	84
+8405	Coihueco	84
+8406	Chillán Viejo	84
+8407	El Carmen	84
+8408	Ninhue	84
+8409	Ñiquén	84
+8410	Pemuco	84
+8411	Pinto	84
+8412	Portezuelo	84
+8413	Quillón	84
+8414	Quirihue	84
+8415	Ránquil	84
+8416	San Carlos	84
+8417	San Fabián	84
+8418	San Ignacio	84
+8419	San Nicolás	84
+8420	Treguaco	84
+8421	Yungay	84
+9101	Temuco	91
+9102	Carahue	91
+9103	Cunco	91
+9104	Curarrehue	91
+9105	Freire	91
+9106	Galvarino	91
+9107	Gorbea	91
+9108	Lautaro	91
+9109	Loncoche	91
+9110	Melipeuco	91
+9111	Nueva Imperial	91
+9112	Padre las Casas	91
+9113	Perquenco	91
+9114	Pitrufquén	91
+9115	Pucón	91
+9116	Saavedra	91
+9117	Teodoro Schmidt	91
+9118	Toltén	91
+9119	Vilcún	91
+9120	Villarrica	91
+9121	Cholchol	91
+9201	Angol	92
+9202	Collipulli	92
+9203	Curacautín	92
+9204	Ercilla	92
+9205	Lonquimay	92
+9206	Los Sauces	92
+9207	Lumaco	92
+9208	Purén	92
+9209	Renaico	92
+9210	Traiguén	92
+9211	Victoria	92
+10101	Puerto Montt	101
+10102	Calbuco	101
+10103	Cochamó	101
+10104	Fresia	101
+10105	Frutillar	101
+10106	Los Muermos	101
+10107	Llanquihue	101
+10108	Maullín	101
+10109	Puerto Varas	101
+10201	Castro	102
+10202	Ancud	102
+10203	Chonchi	102
+10204	Curaco de Vélez	102
+10205	Dalcahue	102
+10206	Puqueldón	102
+10207	Queilén	102
+10208	Quellón	102
+10209	Quemchi	102
+10210	Quinchao	102
+10301	Osorno	103
+10302	Puerto Octay	103
+10303	Purranque	103
+10304	Puyehue	103
+10305	Río Negro	103
+10306	San Juan de la Costa	103
+10307	San Pablo	103
+10401	Chaitén	104
+10402	Futaleufú	104
+10403	Hualaihué	104
+10404	Palena	104
+11101	Coihaique	111
+11102	Lago Verde	111
+11201	Aisén	112
+11202	Cisnes	112
+11203	Guaitecas	112
+11301	Cochrane	113
+11302	O’Higgins	113
+11303	Tortel	113
+11401	Chile Chico	114
+11402	Río Ibáñez	114
+12101	Punta Arenas	121
+12102	Laguna Blanca	121
+12103	Río Verde	121
+12104	San Gregorio	121
+12201	Cabo de Hornos (Ex Navarino)	122
+12202	Antártica	122
+12301	Porvenir	123
+12302	Primavera	123
+12303	Timaukel	123
+12401	Natales	124
+12402	Torres del Paine	124
+13101	Santiago	131
+13102	Cerrillos	131
+13103	Cerro Navia	131
+13104	Conchalí	131
+13105	El Bosque	131
+13106	Estación Central	131
+13107	Huechuraba	131
+13108	Independencia	131
+13109	La Cisterna	131
+13110	La Florida	131
+13111	La Granja	131
+13112	La Pintana	131
+13113	La Reina	131
+13114	Las Condes	131
+13115	Lo Barnechea	131
+13116	Lo Espejo	131
+13117	Lo Prado	131
+13118	Macul	131
+13119	Maipú	131
+13120	Ñuñoa	131
+13121	Pedro Aguirre Cerda	131
+13122	Peñalolén	131
+13123	Providencia	131
+13124	Pudahuel	131
+13125	Quilicura	131
+13126	Quinta Normal	131
+13127	Recoleta	131
+13128	Renca	131
+13129	San Joaquín	131
+13130	San Miguel	131
+13131	San Ramón	131
+13132	Vitacura	131
+13201	Puente Alto	132
+13202	Pirque	132
+13203	San José de Maipo	132
+13301	Colina	133
+13302	Lampa	133
+13303	Tiltil	133
+13401	San Bernardo	134
+13402	Buin	134
+13403	Calera de Tango	134
+13404	Paine	134
+13501	Melipilla	135
+13502	Alhué	135
+13503	Curacaví	135
+13504	María Pinto	135
+13505	San Pedro	135
+13601	Talagante	136
+13602	El Monte	136
+13603	Isla de Maipo	136
+13604	Padre Hurtado	136
+13605	Peñaflor	136
+14101	Valdivia	141
+14102	Corral	141
+14103	Lanco	141
+14104	Los Lagos	141
+14105	Máfil	141
+14106	Mariquina	141
+14107	Paillaco	141
+14108	Panguipulli	141
+14201	La Unión	142
+14202	Futrono	142
+14203	Lago Ranco	142
+14204	Río Bueno	142
+15101	Arica	151
+15102	Camarones	151
+15201	Putre	152
+15202	General Lagos	152
+*/
+        $this->execute('SET unique_checks=0; SET foreign_key_checks=0;');
+
+        $table = $this->table('comuna');
+        $table->truncate();
+
+        $data = [
+            ['id' => 1101, 'descripcion' => 'Iquique', 'provincia' => 11],
+            ['id' => 1107, 'descripcion' => 'Alto Hospicio', 'provincia' => 11],
+            ['id' => 1401, 'descripcion' => 'Pozo Almonte', 'provincia' => 14],
+            ['id' => 1402, 'descripcion' => 'Camiña', 'provincia' => 14],
+            ['id' => 1403, 'descripcion' => 'Colchane', 'provincia' => 14],
+            ['id' => 1404, 'descripcion' => 'Huara', 'provincia' => 14],
+            ['id' => 1405, 'descripcion' => 'Pica', 'provincia' => 14],
+            ['id' => 2101, 'descripcion' => 'Antofagasta', 'provincia' => 21],
+            ['id' => 2102, 'descripcion' => 'Mejillones', 'provincia' => 21],
+            ['id' => 2103, 'descripcion' => 'Sierra Gorda', 'provincia' => 21],
+            ['id' => 2104, 'descripcion' => 'Taltal', 'provincia' => 21],
+            ['id' => 2201, 'descripcion' => 'Calama', 'provincia' => 22],
+            ['id' => 2202, 'descripcion' => 'Ollagüe', 'provincia' => 22],
+            ['id' => 2203, 'descripcion' => 'San Pedro de Alcántara', 'provincia' => 22],
+            ['id' => 2301, 'descripcion' => 'Tocopilla', 'provincia' => 23],
+            ['id' => 2302, 'descripcion' => 'María Elena', 'provincia' => 23],
+        ];
+    }
+}

app/resources/database/seeds/TipoEstadoPago.php

@@ -0,0 +1,36 @@
+<?php
+
+declare(strict_types=1);
+
+use Phinx\Seed\AbstractSeed;
+
+class TipoEstadoPago extends AbstractSeed
+{
+    /**
+     * Run Method.
+     *
+     * Write your database seeder using this method.
+     *
+     * More information on writing seeders is available here:
+     * https://book.cakephp.org/phinx/0/en/seeding.html
+     */
+    public function run(): void
+    {
+        $this->execute('SET unique_checks=0; SET foreign_key_checks=0;');
+
+        $table = $this->table('tipo_estado_pago');
+        $table->truncate();
+
+        $data = [
+            ['id' => -3, 'descripcion' => 'anulado'],
+            ['id' => -2, 'descripcion' => 'reemplazado'],
+            ['id' => -1, 'descripcion' => 'devuelto'],
+            ['id' => 0, 'descripcion' => 'no pagado', 'active' => 1],
+            ['id' => 1, 'descripcion' => 'depositado', 'active' => 1],
+            ['id' => 2, 'descripcion' => 'abonado', 'active' => 1],
+        ];
+        $table->insert($data)->saveData();
+
+        $this->execute('SET unique_checks=1; SET foreign_key_checks=1;');
+    }
+}

app/resources/routes/03_proyectos.php

@@ -2,6 +2,16 @@
 use Incoviba\Controller\Proyectos;
 
 $app->group('/proyectos', function($app) {
+    $folder = implode(DIRECTORY_SEPARATOR, [__DIR__, 'proyectos']);
+    if (file_exists($folder)) {
+        $files = new FilesystemIterator($folder);
+        foreach ($files as $file) {
+            if ($file->isDir()) {
+                continue;
+            }
+            include_once $file->getRealPath();
+        }
+    }
     $app->get('/unidades[/]', [Proyectos::class, 'unidades']);
     $app->get('[/]', Proyectos::class);
 })->add($app->getContainer()->get(Incoviba\Middleware\Authentication::class));

app/resources/routes/04_ventas.php

@@ -23,6 +23,7 @@ $app->group('/venta/{venta_id:[0-9]+}', function($app) {
         $app->get('[/]', [Ventas::class, 'propiedad']);
     });
     $app->group('/pie', function($app) {
+        $app->get('/add[/]', [Ventas\Pies::class, 'add']);
         $app->group('/cuotas', function($app) {
             $app->get('[/]', [Ventas::class, 'cuotas']);
         });

app/resources/routes/05_contabilidad.php

@@ -7,4 +7,4 @@ $app->group('/contabilidad', function($app) {
         }
         include_once $file->getRealPath();
     }
-});
+})->add($app->getContainer()->get(Incoviba\Middleware\Authentication::class));

app/resources/routes/96_admin.php

@@ -7,4 +7,4 @@ $app->group('/admin', function($app) {
         }
         include_once $file->getRealPath();
     }
-});
+})->add($app->getContainer()->get(Incoviba\Middleware\Authentication::class));

app/resources/routes/api/admin/users.php

@@ -2,5 +2,9 @@
 use Incoviba\Controller\API\Admin\Users;
 
 $app->group('/users', function($app) {
-    $app->post('/add[/]', Users::class . ':add');
+    $app->post('/add[/]', [Users::class, 'add']);
+});
+$app->group('/user/{user_id}', function($app) {
+    $app->post('/edit[/]', [Users::class, 'edit']);
+    $app->delete('[/]', [Users::class, 'delete']);
 });

app/resources/routes/api/external.php

@@ -0,0 +1,16 @@
+<?php
+use Incoviba\Controller\API\External;
+
+$app->group('/external', function($app) {
+    $files = new FilesystemIterator(implode(DIRECTORY_SEPARATOR, [__DIR__, 'external']));
+    foreach ($files as $file) {
+        if ($file->isDir()) {
+            continue;
+        }
+        include_once $file->getRealPath();
+    }
+    $app->group('/services', function($app) {
+        $app->get('/check[/]', [External::class, 'check']);
+        $app->get('/update[/]', [External::class, 'update']);
+    });
+});

app/resources/routes/api/external/toku.php

@@ -0,0 +1,10 @@
+<?php
+use Incoviba\Controller\API\Ventas\MediosPago\Toku;
+
+$app->group('/toku', function($app) {
+    $app->post('/cuotas/{venta_id}[/]', [Toku::class, 'cuotas']);
+    $app->post('/success[/]', [Toku::class, 'success']);
+    $app->get('/test[/]', [Toku::class, 'test']);
+    $app->delete('/reset[/]', [Toku::class, 'reset']);
+    $app->post('/enqueue[/]', [Toku::class, 'enqueue']);
+});

app/resources/routes/api/proyectos.php

@@ -3,6 +3,13 @@ use Incoviba\Controller\API\Proyectos;
 
 $app->group('/proyectos', function($app) {
     $app->get('/escriturando[/]', [Proyectos::class, 'escriturando']);
+    $files = new FilesystemIterator(implode(DIRECTORY_SEPARATOR, [__DIR__, 'proyectos']));
+    foreach ($files as $file) {
+        if ($file->isDir()) {
+            continue;
+        }
+        include_once $file->getRealPath();
+    }
     $app->get('[/]', [Proyectos::class, 'list']);
 });
 $app->group('/proyecto/{proyecto_id}', function($app) {
@@ -14,10 +21,13 @@ $app->group('/proyecto/{proyecto_id}', function($app) {
         $app->get('/vendible[/]', [Proyectos::class, 'superficies']);
     });
     $app->group('/unidades', function($app) {
+        $app->post('/precios[/]', [Proyectos\Unidades::class, 'precios']);
+        $app->post('/estados[/]', [Proyectos\Unidades::class, 'estados']);
         $app->get('/disponibles[/]', [Proyectos::class, 'disponibles']);
         $app->get('[/]', [Proyectos::class, 'unidades']);
     });
     $app->group('/terreno', function($app) {
         $app->post('/edit[/]', [Proyectos::class, 'terreno']);
     });
+    $app->get('/brokers', [Proyectos::class, 'brokers']);
 });

app/resources/routes/api/proyectos/brokers.php

@@ -0,0 +1,30 @@
+<?php
+use Incoviba\Controller\API\Proyectos\Brokers;
+use Incoviba\Controller\API\Proyectos\Brokers\Contracts;
+
+$app->group('/brokers', function($app) {
+    $app->group('/contracts', function($app) {
+        $app->post('/add[/]', [Contracts::class, 'add']);
+        $app->get('[/]', Contracts::class);
+    });
+    $app->group('/contract/{contract_id}', function($app) {
+        $app->post('/edit[/]', [Contracts::class, 'edit']);
+        $app->post('/inactive[/]', [Contracts::class, 'inactive']);
+        $app->delete('[/]', [Contracts::class, 'delete']);
+        $app->get('[/]', [Contracts::class, 'get']);
+    });
+    $app->post('/add[/]', [Brokers::class, 'add']);
+    $app->post('/edit[/]', [Brokers::class, 'edit']);
+    $app->get('[/]', Brokers::class);
+});
+$app->group('/broker/{broker_rut}', function($app) {
+    $app->group('/contracts', function($app) {
+        $app->post('/add[/]', [Contracts::class, 'add']);
+        $app->get('[/]', [Contracts::class, 'getByBroker']);
+    });
+    $app->group('/contract/{contract_id}', function($app) {
+        $app->post('/promotions[/]', [Contracts::class, 'promotions']);
+    });
+    $app->delete('[/]', [Brokers::class, 'delete']);
+    $app->get('[/]', [Brokers::class, 'get']);
+});

app/resources/routes/api/queue.php

@@ -0,0 +1,10 @@
+<?php
+use Incoviba\Controller\API\Queues;
+
+$app->group('/queue', function($app) {
+    $app->get('/jobs[/]', [Queues::class, 'jobs']);
+    $app->group('/run', function($app) {
+        $app->get('/{job_id:[0-9]+}[/]', [Queues::class, 'run']);
+        $app->get('[/]', Queues::class);
+    });
+});

app/resources/routes/api/ventas.php

@@ -21,6 +21,7 @@ $app->group('/ventas', function($app) {
     });
     $app->group('/by', function($app) {
         $app->get('/unidad/{unidad_id}', [Ventas::class, 'unidad']);
+        $app->post('/unidades[/]', [Ventas::class, 'byUnidades']);
     });
     $app->post('/get[/]', [Ventas::class, 'getMany']);
     $app->post('[/]', [Ventas::class, 'proyecto']);
@@ -55,6 +56,9 @@ $app->group('/venta/{venta_id}', function($app) {
     $app->group('/propietario', function($app) {
         $app->put('/edit[/]', [Ventas::class, 'propietario']);
     });
+    $app->group('/pie', function($app) {
+        $app->post('/add[/]', [Ventas\Pies::class, 'add']);
+    });
     $app->post('[/]', [Ventas::class, 'edit']);
     $app->get('[/]', [Ventas::class, 'get']);
 });

app/resources/routes/api/ventas/promotions.php

@@ -0,0 +1,28 @@
+<?php
+use Incoviba\Controller\API\Ventas\Promotions;
+
+$app->group('/promotions', function($app) {
+    $app->post('/add[/]', [Promotions::class, 'add']);
+    $app->post('/edit[/]', [Promotions::class, 'edit']);
+});
+$app->group('/promotion/{promotion_id}', function($app) {
+    $app->delete('/remove[/]', [Promotions::class, 'remove']);
+    $app->group('/connections', function($app) {
+        $app->post('/add[/]', [Promotions::class, 'addConnections']);
+        $app->group('/project/{project_id}', function($app) {
+            $app->delete('[/]', [Promotions::class, 'removeProject']);
+            $app->group('/unit-type/{unit_type_id}', function($app) {
+                $app->delete('[/]', [Promotions::class, 'removeUnitType']);
+            });
+        });
+        $app->group('/broker/{broker_rut}', function($app) {
+            $app->delete('[/]', [Promotions::class, 'removeBroker']);
+        });
+        $app->group('/unit-line/{unit_line_id}', function($app) {
+            $app->delete('[/]', [Promotions::class, 'removeUnitLine']);
+        });
+        $app->group('/unit/{unit_id}', function($app) {
+            $app->delete('[/]', [Promotions::class, 'removeUnit']);
+        });
+    });
+});

app/resources/routes/api/ventas/reservations.php

@@ -0,0 +1,12 @@
+<?php
+use Incoviba\Controller\API\Ventas\Reservations;
+
+$app->group('/reservations', function($app) {
+    $app->post('/add[/]', [Reservations::class, 'add']);
+    $app->get('[/]', Reservations::class);
+});
+$app->group('/reservation/{reservation_id}', function($app) {
+    $app->post('/edit[/]', [Reservations::class, 'edit']);
+    $app->delete('[/]', [Reservations::class, 'delete']);
+    $app->get('[/]', [Reservations::class, 'get']);
+});

app/resources/routes/proyectos/brokers.php

@@ -0,0 +1,12 @@
+<?php
+use Incoviba\Controller\Proyectos\Brokers;
+
+$app->group('/brokers', function($app) {
+    $app->get('[/]', Brokers::class);
+});
+$app->group('/broker/{broker_rut}', function($app) {
+    $app->group('/contract/{contract_id}', function($app) {
+        $app->get('[/]', [Brokers\Contracts::class, 'show']);
+    });
+    $app->get('[/]', [Brokers::class, 'show']);
+});

app/resources/routes/ventas/promotions.php

@@ -0,0 +1,9 @@
+<?php
+use Incoviba\Controller\Ventas\Promotions;
+
+$app->group('/promotions', function($app) {
+    $app->get('[/]', Promotions::class);
+});
+$app->group('/promotion/{promotion_id}', function($app) {
+    $app->get('[/]', [Promotions::class, 'show']);
+});

app/resources/views/admin/users.blade.php

@@ -14,15 +14,15 @@
                 </th>
             </tr>
             </thead>
-            <tbody>
+            <tbody id="users">
             @foreach($users as $user)
-                <tr>
+                <tr data-user="{{ $user->id }}">
                     <td>{{ $user->name }}</td>
                     <td class="right aligned">
-                        <button class="ui mini blue icon button">
+                        <button class="ui mini blue icon button edit" data-user="{{ $user->id }}">
                             <i class="edit icon"></i>
                         </button>
-                        <button class="ui mini red icon button">
+                        <button class="ui mini red icon button remove" data-user="{{ $user->id }}">
                             <i class="trash icon"></i>
                         </button>
                     </td>
@@ -50,6 +50,10 @@
                     <label>Contraseña</label>
                     <input type="password" name="password" placeholder="Contraseña">
                 </div>
+                <div class="field">
+                    <label>Confirmar contraseña</label>
+                    <input type="password" name="password_confirmation" placeholder="Confirmar contraseña">
+                </div>
             </form>
         </div>
         <div class="actions">
@@ -62,6 +66,45 @@
             </div>
         </div>
     </div>
+    <div class="ui modal" id="edit-user-modal">
+        <i class="close icon"></i>
+        <div class="header">
+            Editar usuario
+        </div>
+        <div class="content">
+            <form class="ui form">
+                <input type="hidden" name="id" />
+                <div class="field">
+                    <label>Contraseña Antigua</label>
+                    <input type="password" name="old_password" placeholder="Contraseña Antigua">
+                </div>
+                <div class="field">
+                    <label>Force Change?</label>
+                    <div class="ui checkbox">
+                        <input type="checkbox" name="force" >
+                        <label>Yes</label>
+                    </div>
+                </div>
+                <div class="field">
+                    <label>Contraseña</label>
+                    <input type="password" name="password" placeholder="Contraseña">
+                </div>
+                <div class="field">
+                    <label>Confirmar contraseña</label>
+                    <input type="password" name="password_confirmation" placeholder="Confirmar contraseña">
+                </div>
+            </form>
+        </div>
+        <div class="actions">
+            <div class="ui black deny button">
+                Cancelar
+            </div>
+            <div class="ui positive right labeled icon button">
+                Guardar
+                <i class="checkmark icon"></i>
+            </div>
+        </div>
+    </div>
 @endsection
 
 @include('layout.body.scripts.cryptojs')
@@ -74,12 +117,20 @@
             return [passphrase, encrypted.toString()].join('')
         }
         $(document).ready(function () {
-            $('#create-user-modal').modal({
+            const $createUserModal = $('#create-user-modal')
+            $createUserModal.modal({
                 onApprove: function() {
+                    const form = document.querySelector('#create-user-modal form')
+                    const password = form.querySelector('[name="password"]').value
+                    const password_confirmation = form.querySelector('[name="password_confirmation"]').value
+                    if (password !== password_confirmation) {
+                        alert('Las contraseñas no coinciden')
+                        return
+                    }
                     const url = '{{$urls->api}}/admin/users/add'
                     const method = 'post'
-                    const body = new FormData(document.querySelector('#create-user-modal form'))
-                    body.set('password', encryptPassword(body.get('password')))
+                    const body = new FormData(form)
+                    body.set('password', encryptPassword(password))
                     fetchAPI(url, {method, body}).then(response => {
                         if (!response) {
                             return;
@@ -92,8 +143,64 @@
                     })
                 }
             })
-            $('#create-user-button').on('click', function () {
-                $('#create-user-modal').modal('show')
+            const $editUserModal = $('#edit-user-modal')
+            $editUserModal.modal({
+                onApprove: function() {
+                    const form = document.querySelector('#edit-user-modal form')
+                    const user_id = form.querySelector('[name="id"]').value
+                    const old_password = form.querySelector('[name="old_password"]').value
+                    const password = form.querySelector('[name="password"]').value
+                    const password_confirmation = form.querySelector('[name="password_confirmation"]').value
+                    if (password !== password_confirmation) {
+                        alert('Las nuevas contraseñas no coinciden')
+                        return
+                    }
+                    const url = `{{$urls->api}}/admin/user/${user_id}/edit`
+                    const method = 'post'
+                    const body = new FormData(form)
+                    body.set('old_password', encryptPassword(old_password))
+                    body.set('password', encryptPassword(password))
+                    if (form.querySelector('[name="force"]').checked) {
+                        body.set('force', 'true')
+                    }
+                    fetchAPI(url, {method, body}).then(response => {
+                        if (!response) {
+                            return;
+                        }
+                        response.json().then(result => {
+                            if (result.success) {
+                                location.reload()
+                            }
+                        })
+                    })
+                }
+            })
+            document.getElementById('create-user-modal').addEventListener('submit', event => {
+                $createUserModal.modal('show')
+            })
+            document.querySelectorAll('.button.edit').forEach(button => {
+                button.addEventListener('click', clickEvent => {
+                    const user_id = clickEvent.currentTarget.dataset.user
+                    $editUserModal.find('input[name="id"]').val(user_id)
+                    $editUserModal.modal('show')
+                })
+            })
+            document.querySelectorAll('.button.remove').forEach(button => {
+                button.addEventListener('click', clickEvent => {
+                    const user_id = clickEvent.currentTarget.dataset.user
+                    const url = `{{$urls->api}}/admin/user/${user_id}`
+                    const method = 'delete'
+                    fetchAPI(url, {method}).then(response => {
+                        if (!response) {
+                            return;
+                        }
+                        response.json().then(result => {
+                            if (result.success) {
+                                location.reload()
+                            }
+                        })
+                    })
+                })
             })
         });
     </script>

app/resources/views/contabilidad/movimientos/scripts/movimientos_table.blade.php

@@ -96,26 +96,7 @@
                 columnDefs,
                 order,
                 language: Object.assign(dtD.language, {
-                    searchBuilder: {
-                        add: 'Filtrar',
-                        condition: 'Comparador',
-                        clearAll: 'Resetear',
-                        delete: 'Eliminar',
-                        deleteTitle: 'Eliminar Titulo',
-                        data: 'Columna',
-                        left: 'Izquierda',
-                        leftTitle: 'Titulo Izquierdo',
-                        logicAnd: 'Y',
-                        logicOr: 'O',
-                        right: 'Derecha',
-                        rightTitle: 'Titulo Derecho',
-                        title: {
-                            0: 'Filtros',
-                            _: 'Filtros (%d)'
-                        },
-                        value: 'Opciones',
-                        valueJoiner: 'y'
-                    }
+                    searchBuilder
                 }),
                 layout: {
                     top1: {

app/resources/views/home.blade.php

@@ -20,7 +20,7 @@
 @endsection
 
 @push('page_scripts')
-    <script type="text/javascript">
+    <script>
         const cuotas = {
             get: function() {
                 return {

app/resources/views/home/alertas.blade.php

@@ -2,7 +2,7 @@
 <div class="ui divided list" id="alertas_escrituras"></div>
 
 @push('page_scripts')
-    <script type="text/javascript">
+    <script>
         const alertas_escrituras = {
             id: '#alertas_escrituras',
             data: {

app/resources/views/home/cierres_vigentes.blade.php

@@ -2,7 +2,7 @@
 <div class="ui divided list" id="cierres_vigentes"></div>
 
 @push('page_scripts')
-    <script type="text/javascript">
+    <script>
         const cierres_vigentes = {
             get: function() {
                 const list = $('#cierres_vigentes')

app/resources/views/home/cuotas_por_vencer.blade.php

@@ -2,7 +2,7 @@
 <div class="ui divided list" id="cuotas_por_vencer"></div>
 
 @push('page_scripts')
-    <script type="text/javascript">
+    <script>
         const cuotas_por_vencer = {
             get: function() {
                 const list = $('#cuotas_por_vencer')

app/resources/views/layout/body/header/menu/proyectos.blade.php

@@ -3,5 +3,6 @@
     <i class="dropdown icon"></i>
     <div class="menu">
         <a class="item" href="{{$urls->base}}/proyectos/unidades">Unidades</a>
+        <a class="item" href="{{ $urls->base }}/proyectos/brokers">Operadores</a>
     </div>
 </div>

app/resources/views/layout/body/header/menu/user.blade.php

@@ -11,7 +11,7 @@
 </div>
 
 @push('page_scripts')
-    <script type="text/javascript">
+    <script>
         function logout() {
             return fetch('{{$urls->base}}/logout').then(response => {
                 if (response.ok) {

app/resources/views/layout/body/header/menu/ventas.blade.php

@@ -3,6 +3,7 @@
     <i class="dropdown icon"></i>
     <div class="menu">
         <a class="item" href="{{$urls->base}}/ventas/precios">Precios</a>
+        <a class="item" href="{{ $urls->base }}/ventas/promotions">Promociones</a>
         <a class="item" href="{{$urls->base}}/ventas/cierres">Cierres</a>
         <div class="item">
             Cuotas
@@ -33,6 +34,7 @@
         {{--<a class="item" href="{{$urls->base}}/ventas/precios/importar">Importar Precios</a>--}}
         {{--<a class="item" href="{{$urls->base}}/ventas/cierres/evaluar">Evaluar Cierre</a>--}}
         <a class="item" href="{{$urls->base}}/ventas/facturacion">Facturación</a>
+        <div class="divider"></div>
         <a class="item" href="{{$urls->base}}/ventas/add">
             Nueva Venta
             <i class="plus icon"></i>

app/resources/views/layout/body/scripts.blade.php

@@ -1,33 +1,9 @@
 <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.7.0/jquery.min.js" integrity="sha512-3gJwYpMe3QewGELv8k/BX9vcqhryRdzRMxVfq6ngyWXwo03GFEzjsUm8Q7RZcHPHksttq7/GFoxjCVUjkjvPdw==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>
 <script src="https://cdnjs.cloudflare.com/ajax/libs/fomantic-ui/2.9.3/semantic.min.js" integrity="sha512-gnoBksrDbaMnlE0rhhkcx3iwzvgBGz6mOEj4/Y5ZY09n55dYddx6+WYc72A55qEesV8VX2iMomteIwobeGK1BQ==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>
 
-<script type="text/javascript">
-    class APIClient {
-        static fetch(url, options=null, showErrors=false) {
-            return fetchAPI(url, options, showErrors)
-        }
-    }
-    function fetchAPI(url, options=null, showErrors=false) {
-        if (options === null) {
-            options = {}
-        }
-        if (!Object.hasOwn(options, 'headers')) {
-            options['headers'] = {}
-        }
-        if (!Object.hasOwn(options['headers'], 'Authorization')) {
-            options['headers']['Authorization'] = 'Bearer {{md5($API_KEY)}}{{($login->isIn()) ? $login->getSeparator() . $login->getToken() : ''}}'
-        }
-        return fetch(url, options).then(response => {
-            if (response.ok) {
-                return response
-            }
-            throw new Error(JSON.stringify({code: response.status, message: response.statusText, url}))
-        }).catch(error => {
-            if (showErrors) {
-                console.error(error)
-            }
-        })
-    }
+@include('layout.body.scripts.api')
+
+<script>
     const datatables_defaults = {
         language: {
             emptyTable: 'No hay datos disponibles',

app/resources/views/layout/body/scripts/api.blade.php

@@ -0,0 +1,32 @@
+<script>
+    class APIClient {
+        static getApiKey() {
+            return '{{md5($API_KEY)}}{{($login->isIn()) ? $login->getSeparator() . $login->getToken() : ''}}'
+        }
+
+        static fetch(url, options=null, showErrors=false) {
+            if (options === null) {
+                options = {}
+            }
+            if (!Object.hasOwn(options, 'headers')) {
+                options['headers'] = {}
+            }
+            if (!Object.hasOwn(options['headers'], 'Authorization')) {
+                options['headers']['Authorization'] = `Bearer ${APIClient.getApiKey()}`
+            }
+            return fetch(url, options).then(response => {
+                if (response.ok) {
+                    return response
+                }
+                throw new Error(JSON.stringify({code: response.status, message: response.statusText, url}))
+            }).catch(error => {
+                if (showErrors) {
+                    console.error(error)
+                }
+            })
+        }
+    }
+    function fetchAPI(url, options=null, showErrors=false) {
+        return APIClient.fetch(url, options, showErrors)
+    }
+</script>

app/resources/views/layout/body/scripts/datatables.blade.php

@@ -1,4 +1,4 @@
 @push('page_scripts')
-    <script type="text/javascript" src="https://cdn.datatables.net/2.0.3/js/dataTables.min.js"></script>
+    <script src="https://cdn.datatables.net/2.0.3/js/dataTables.min.js"></script>
     <script src="https://cdn.datatables.net/2.0.3/js/dataTables.semanticui.min.js"></script>
 @endpush

app/resources/views/layout/body/scripts/datatables/searchbuilder.blade.php

@@ -2,4 +2,26 @@
     <script src="https://cdn.datatables.net/datetime/1.5.2/js/dataTables.dateTime.min.js"></script>
     <script src="https://cdn.datatables.net/searchbuilder/1.7.0/js/dataTables.searchBuilder.min.js"></script>
     <script src="https://cdn.datatables.net/searchbuilder/1.7.0/js/searchBuilder.semanticui.js"></script>
+    <script>
+        const searchBuilder = {
+            add: 'Filtrar',
+            condition: 'Comparador',
+            clearAll: 'Resetear',
+            delete: 'Eliminar',
+            deleteTitle: 'Eliminar Titulo',
+            data: 'Columna',
+            left: 'Izquierda',
+            leftTitle: 'Titulo Izquierdo',
+            logicAnd: 'Y',
+            logicOr: 'O',
+            right: 'Derecha',
+            rightTitle: 'Titulo Derecho',
+            title: {
+                0: 'Filtros',
+                _: 'Filtros (%d)'
+            },
+            value: 'Opciones',
+            valueJoiner: 'y'
+        }
+    </script>
 @endpush

app/resources/views/layout/body/scripts/number_format.blade.php

@@ -0,0 +1,45 @@
+@push('page_scripts')
+    <script>
+        Intl.NumberFormat.prototype.parse = function(valueString) {
+            const format = new Intl.NumberFormat(this.resolvedOptions().locale);
+            const parts = format.formatToParts(-12345.6);
+            const numerals = Array.from({ length: 10 }).map((_, i) => format.format(i));
+            const index = new Map(numerals.map((d, i) => [d, i]));
+            _minusSign = new RegExp(`[${parts.find(d => d.type === 'minusSign').value}]`);
+            _group = new RegExp(`[${parts.find(d => d.type === 'group').value}]`, 'g');
+            _decimal = new RegExp(`[${parts.find(d => d.type === 'decimal').value}]`);
+            _numeral = new RegExp(`[${numerals.join('')}]`, 'g');
+            _index = d => index.get(d);
+
+            const DIRECTION_MARK = /\u061c|\u200e/g
+            return +(
+                valueString.trim()
+                    .replace(DIRECTION_MARK, '')
+                    .replace(_group, '')
+                    .replace(_decimal, '.')
+                    .replace(_numeral, _index)
+                    .replace(_minusSign, '-')
+            )
+        }
+        Intl.NumberFormat.prototype.isLocale = function(stringValue) {
+            const format = new Intl.NumberFormat(this.resolvedOptions().locale);
+            const parts = format.formatToParts(-12345.6);
+            const group = parts.find(d => d.type === 'group').value;
+            const decimal = parts.find(d => d.type === 'decimal').value;
+
+            if (stringValue.includes(group)) {
+                if (stringValue.includes(decimal)) {
+                    return stringValue.indexOf(group) < stringValue.indexOf(decimal)
+                }
+                if (stringValue.split(group).map(d => d.length).filter(d => d > 3).length > 0) {
+                    return false
+                }
+                return stringValue.split(group).length > 2;
+            }
+            if (stringValue.includes(decimal)) {
+                return stringValue.split(decimal).length <= 2;
+            }
+            return false
+        }
+    </script>
+@endpush

app/resources/views/layout/body/scripts/number_input.blade.php

@@ -0,0 +1,76 @@
+@push('page_scripts')
+    <script>
+        if (typeof Intl.NumberFormat.isLocale === 'undefined' || typeof Intl.NumberFormat.isLocale !== 'function') {
+            // Load Intl.NumberFormat custom methods
+            @include('layout.body.scripts.number_format')
+        }
+        class NumberInput {
+            input
+            isRational
+            outputLocale
+            currentValue
+            formatters
+
+            constructor({input, isRational, outputLocale}) {
+                this.input = input
+                this.isRational = isRational
+                this.outputLocale = outputLocale || 'es-CL'
+
+                this.formatters = {}
+                const locales = ['es-CL', 'en-US']
+                locales.forEach(locale => {
+                    this.formatters[locale] = {
+                        rational: new Intl.NumberFormat(locale, {minimumFractionDigits: 2, maximumFractionDigits: 2}),
+                        integer: new Intl.NumberFormat(locale)
+                    }
+                })
+
+                if (this.input.value !== '') {
+                    this.currentValue = this.process(this.input.value)
+                    this.input.value = this.format(this.currentValue)
+                }
+            }
+            watch() {
+                this.input.addEventListener('change', event => {
+                    this.currentValue = this.process(event.currentTarget.value)
+                    this.input.value = this.format(this.currentValue)
+                })
+            }
+            process(stringValue) {
+                if (stringValue === '') {
+                    return ''
+                }
+                if (typeof stringValue !== 'string') {
+                    return stringValue
+                }
+                return this.formatters[this.detectLocale(stringValue)][this.isRational ? 'rational' : 'integer'].parse(stringValue)
+            }
+            detectLocale(stringValue) {
+                if (stringValue === '') {
+                    return ''
+                }
+                if (typeof stringValue !== 'string') {
+                    return stringValue
+                }
+                const outputFormat = this.formatters[this.outputLocale][this.isRational ? 'rational' : 'integer'].isLocale(stringValue)
+                const otherFormats = Object.entries(this.formatters).filter(formatter => formatter[0] !== this.outputLocale).map(formatter => {
+                    return {
+                        locale: formatter[0],
+                        value: formatter[1][this.isRational ? 'rational' : 'integer'].isLocale(stringValue)
+                    }
+                }).filter(formatter => formatter.value)
+
+                if (outputFormat) {
+                    return this.outputLocale
+                }
+                if (otherFormats.length > 0) {
+                    return otherFormats[0].locale
+                }
+                return 'en-US'
+            }
+            format(value) {
+                return this.formatters[this.outputLocale][this.isRational ? 'rational' : 'integer'].format(value)
+            }
+        }
+    </script>
+@endpush

app/resources/views/layout/body/scripts/rut.blade.php

@@ -28,7 +28,7 @@
                 if (!(typeof digito === 'string' || digito instanceof String)) {
                     digito = digito.toString()
                 }
-                return Rut.digitoVerificador(rut) === digito
+                return Rut.digitoVerificador(rut).toString().toUpperCase() === digito.toUpperCase()
             }
         }
     </script>

app/resources/views/layout/body/scripts/stats.blade.php

@@ -0,0 +1,6 @@
+@prepend('page_scripts')
+    <script src='https://unpkg.com/simple-statistics@7.8.8/dist/simple-statistics.min.js'></script>
+    <script>
+        const Stat = ss
+    </script>
+@endprepend

app/resources/views/layout/head.blade.php

@@ -1,9 +1,9 @@
 <head>
     <meta charset="utf8" />
     @hasSection('page_title')
-    <title>Incoviba - @yield('page_title')</title>
+        <title>Incoviba - @yield('page_title')</title>
     @else
-    <title>Incoviba</title>
+        <title>Incoviba</title>
     @endif
     <link rel="icon" href="{{$urls->images}}/Isotipo 16.png" />
     @include('layout.head.styles')

app/resources/views/login/form.blade.php

@@ -19,7 +19,7 @@
 @include('layout.body.scripts.cryptojs')
 
 @push('page_scripts')
-    <script type="text/javascript">
+    <script>
         function encryptPassword(password) {
             const passphrase = Math.floor(Math.random() * Date.now()).toString()
             const encrypted = CryptoJS.AES.encrypt(password, passphrase)

app/resources/views/not_allowed.blade.php

@@ -0,0 +1,14 @@
+@extends('layout.base')
+
+@section('page_title')
+    405 - Método No Permitido
+@endsection
+
+@section('page_content')
+    <div class="ui container">
+        <div class="ui message">
+            <i class="exclamation triangle icon"></i>
+            No se ha encontrado la página solicitada para el método solicitado.
+        </div>
+    </div>
+@endsection

app/resources/views/proyectos/brokers.blade.php

@@ -0,0 +1,219 @@
+@extends('proyectos.brokers.base')
+
+@section('brokers_content')
+    <table id="brokers" class="ui table">
+        <thead>
+        <tr>
+            <th>RUT</th>
+            <th>Nombre</th>
+            <th>Contacto</th>
+            <th>Contratos</th>
+            <th class="right aligned">
+                <button class="ui small tertiary green icon button" id="add_button">
+                    <i class="plus icon"></i>
+                </button>
+            </th>
+        </tr>
+        </thead>
+        @foreach($brokers as $broker)
+            <tr>
+                <td class="top aligned">
+                    <span
+                            @if ($broker->data()?->legalName !== '')
+                                data-tooltip="{{ $broker->data()?->legalName }}" data-position="right center"
+                    @endif
+                    >
+                        {{$broker->rutFull()}}
+                    </span>
+                </td>
+                <td class="top aligned">
+                    <a href="{{ $urls->base }}/proyectos/broker/{{ $broker->rut }}">
+                        {{$broker->name}}
+                        <i class="angle right icon"></i>
+                    </a>
+                </td>
+                <td class="top aligned">
+                    <span
+                    @if ($broker->data()?->representative?->email !== '' || $broker->data()?->representative?->phone !== '')
+                            data-tooltip="{{ ($broker->data()?->representative?->email !== '') ? "Email: " . $broker->data()?->representative?->email : '' }}{{ ($broker->data()?->representative?->phone !== '') ? ' Teléfono: ' . $broker->data()?->representative?->phone : '' }}" data-position="right center"
+                    @endif
+                    >
+                        {{ $broker->data()?->representative?->name }}
+                    </span>
+                </td>
+                <td class="top aligned">
+                    <div class="ui list">
+                        @foreach($broker->contracts() as $contract)
+                            <div class="item">
+                                <a href="{{$urls->base}}/proyectos/broker/{{$broker->rut}}/contract/{{$contract->id}}" data-tooltip="{{$contract->current()->date->format('d-m-Y')}}" data-position="right center">
+                                    {{$contract->project->descripcion}} ({{$format->percent($contract->commission, 2, true)}})
+                                </a>
+                            </div>
+                        @endforeach
+                    </div>
+                </td>
+                <td class="top aligned right aligned">
+                    <button class="ui small tertiary icon button edit_button" data-index="{{$broker->rut}}">
+                        <i class="edit icon"></i>
+                    </button>
+                    <button class="ui small tertiary red icon button remove_button" data-index="{{$broker->rut}}">
+                        <i class="remove icon"></i>
+                    </button>
+                </td>
+            </tr>
+        @endforeach
+    </table>
+    @include('proyectos.brokers.add_modal')
+    @include('proyectos.brokers.edit_modal')
+@endsection
+
+@push('page_scripts')
+    <script>
+        function storeBrokers() {
+            localStorage.setItem('brokers',  '{!! json_encode(array_map(function($broker) {
+                                                        $arr = json_decode(json_encode($broker), true);
+                                                        array_walk_recursive($arr, function(&$val, $key) {
+                                                            if ($val === null) {
+                                                                $val = '';
+                                                            }
+                                                        });
+                                                        $arr['contracts'] = $broker->contracts();
+                                                        return $arr;
+                                                }, $brokers)) !!}')
+        }
+        const brokersHandler = {
+            ids: {
+                buttons: {
+                    add: 'add_button',
+                    edit: 'edit_button',
+                    remove: 'remove_button'
+                },
+                modals: {
+                    add: '',
+                    edit: ''
+                },
+                forms: {
+                    add: '',
+                    edit: ''
+                }
+            },
+            modals: {
+                add: null,
+                edit: null
+            },
+            events() {
+                return {
+                    add: clickEvent => {
+                        clickEvent.preventDefault()
+                        brokersHandler.actions().add()
+                    },
+                    edit: clickEvent => {
+                        clickEvent.preventDefault()
+                        const broker_rut = parseInt(clickEvent.currentTarget.dataset.index)
+                        brokersHandler.actions().edit(broker_rut)
+                    },
+                    delete: clickEvent => {
+                        clickEvent.preventDefault()
+                        const broker_rut = clickEvent.currentTarget.dataset.index
+                        brokersHandler.actions().delete(broker_rut)
+                    }
+                }
+            },
+            buttonWatch() {
+                document.getElementById(brokersHandler.ids.buttons.add).addEventListener('click', brokersHandler.events().add)
+                Array.from(document.getElementsByClassName(brokersHandler.ids.buttons.edit)).forEach(button => {
+                    button.addEventListener('click', brokersHandler.events().edit)
+                })
+                Array.from(document.getElementsByClassName(brokersHandler.ids.buttons.remove)).forEach(button => {
+                    button.addEventListener('click', brokersHandler.events().delete)
+                })
+            },
+            actions() {
+                return {
+                    add: () => {
+                        this.modals.add.show()
+                    },
+                    edit: broker_rut => {
+                        const localData = JSON.parse(localStorage.getItem('brokers'))
+                        const broker = localData.find(broker => broker.rut === broker_rut)
+                        const data = {
+                            rut: broker_rut,
+                            name: broker.name,
+                            legal_name: broker.data?.legal_name || '',
+                            contact: broker.data?.representative?.name || '',
+                            email: broker.data?.representative?.email || '',
+                            phone: broker.data?.representative?.phone || '',
+                            address: broker.data?.representative?.address || '',
+                            contracts: broker.contracts
+                        }
+                        this.modals.edit.load(data)
+                    },
+                    delete: broker_rut => {
+                        brokersHandler.execute().delete(broker_rut)
+                    }
+                }
+            },
+            execute() {
+                return {
+                    add: data => {
+                        const url = '{{$urls->api}}/proyectos/brokers/add'
+                        const method = 'post'
+                        const body = new FormData()
+                        body.append('brokers[]', JSON.stringify(data))
+                        return APIClient.fetch(url, {method, body}).then(response => response.json()).then(json => {
+                            if (!json.success) {
+                                console.error(json.errors)
+                                alert('No se pudo agregar operador.')
+                                return
+                            }
+                            window.location.reload()
+                        })
+                    },
+                    edit: data => {
+                        const url = '{{$urls->api}}/proyectos/brokers/edit'
+                        const method = 'post'
+                        const body = new FormData()
+                        body.append('brokers[]', JSON.stringify(data))
+                        return APIClient.fetch(url, {method, body}).then(response => response.json()).then(json => {
+                            if (!json.success) {
+                                console.error(json.errors)
+                                alert('No se pudo editar operador.')
+                                return
+                            }
+                            window.location.reload()
+                        })
+                    },
+                    delete: broker_rut => {
+                        const url = '{{$urls->api}}/proyectos/broker/' + broker_rut
+                        const method = 'delete'
+                        return APIClient.fetch(url, {method}).then(response => response.json()).then(json => {
+                            if (!json.success) {
+                                console.error(json.errors)
+                                alert('No se pudo eliminar operador.')
+                                return
+                            }
+                            window.location.reload()
+                        })
+                    }
+                }
+            },
+            setup(ids) {
+                brokersHandler.ids = ids
+                brokersHandler.buttonWatch()
+
+                this.modals.add = new AddModal(brokersHandler)
+                this.modals.edit = new EditModal(brokersHandler)
+            }
+        }
+        $(document).ready(() => {
+            storeBrokers()
+            brokersHandler.setup({
+                buttons: {
+                    add: 'add_button',
+                    edit: 'edit_button',
+                    remove: 'remove_button',
+                },
+            })
+        })
+    </script>
+@endpush

app/resources/views/proyectos/brokers/add_modal.blade.php

@@ -0,0 +1,115 @@
+<div class="ui modal" id="add_broker_modal">
+    <div class="header">
+        Agregar Operador
+    </div>
+    <div class="content">
+        <form class="ui form" id="add_broker_form">
+            <div class="fields">
+                <div class="field">
+                    <label>RUT</label>
+                    <div class="ui right labeled input">
+                        <input type="text" name="rut" placeholder="RUT" maxlength="10" required />
+                        <div class="ui basic label">-<span id="digit"></span></div>
+                    </div>
+                </div>
+            </div>
+            <div class="fields">
+                <div class="field">
+                    <label>Nombre</label>
+                    <input type="text" name="name" placeholder="Nombre" required />
+                </div>
+                <div class="six wide field">
+                    <label>Razón Social</label>
+                    <input type="text" name="legal_name" placeholder="Razón Social" required />
+                </div>
+            </div>
+            <div class="fields">
+                <div class="field">
+                    <label>Contacto</label>
+                    <input type="text" name="contact" placeholder="Contacto" />
+                </div>
+            </div>
+            <div class="fields">
+                <div class="field">
+                    <label>Correo</label>
+                    <input type="email" name="email" placeholder="Correo" />
+                </div>
+                <div class="field">
+                    <label>Teléfono</label>
+                    <input type="text" name="phone" placeholder="Teléfono" />
+                </div>
+            </div>
+        </form>
+    </div>
+    <div class="actions">
+        <div class="ui deny button">
+            Cancelar
+        </div>
+        <div class="ui positive right labeled icon button">
+            Agregar
+            <i class="checkmark icon"></i>
+        </div>
+    </div>
+</div>
+
+@include('layout.body.scripts.rut')
+
+@push('page_scripts')
+    <script>
+        class AddModal {
+            ids
+            modal
+            handler
+            constructor(handler) {
+                this.handler = handler
+                this.ids = {
+                    modal: 'add_broker_modal',
+                    form: 'add_broker_form',
+                    digit: 'digit'
+                }
+                this.modal = $(`#${this.ids.modal}`)
+                this.modal.modal({
+                    onApprove: () => {
+                        const form = document.getElementById(this.ids.form)
+                        const data = {
+                            rut: form.querySelector('[name="rut"]').value.replace(/\D/g, ''),
+                            digit: Rut.digitoVerificador(form.querySelector('[name="rut"]').value),
+                            name: form.querySelector('[name="name"]').value,
+                            legal_name: form.querySelector('[name="legal_name"]').value,
+                            contact: form.querySelector('[name="contact"]').value || '',
+                            email: form.querySelector('[name="email"]').value || '',
+                            phone: form.querySelector('[name="phone"]').value || ''
+                        }
+                        this.handler.execute().add(data)
+                    }
+                })
+                this.modal.modal('hide')
+                const value = document.querySelector(`#${this.ids.form} input[name="rut"]`).value
+                this.update().digit(value)
+                this.watch().rut()
+            }
+            update() {
+                return {
+                    digit: value => {
+                        if (value.length > 3) {
+                            document.getElementById(this.ids.digit).textContent = Rut.digitoVerificador(value)
+                        }
+                    }
+                }
+            }
+            watch() {
+                return {
+                    rut: () => {
+                        document.querySelector(`#${this.ids.form} input[name="rut"]`).addEventListener('input', event => {
+                            const value = event.currentTarget.value
+                            this.update().digit(value)
+                        })
+                    }
+                }
+            }
+            show() {
+                this.modal.modal('show')
+            }
+        }
+    </script>
+@endpush