Compare commits
53 Commits
feature/ev
...
feature/sh
| Author | SHA1 | Date | |
|---|---|---|---|
| 007ba9d572 | |||
| 5ddc304435 | |||
| 675d76fcb0 | |||
| 35fd1277cb | |||
| 1986961942 | |||
| 3f76af8ec8 | |||
| 0ca2bc8d1b | |||
| c40f145b60 | |||
| 0693e52321 | |||
| cfa7acabe0 | |||
| 1633c30a22 | |||
| 7279f9c6e8 | |||
| 878382e867 | |||
| f47212fd2c | |||
| 3472fb2e5b | |||
| cb3da583be | |||
| 53acfda166 | |||
| 85c79514a3 | |||
| 1aaf05c3b0 | |||
| f7d66001a8 | |||
| 1d58e0ad38 | |||
| e7bece5bfd | |||
| e2cf53eacc | |||
| c7fc867905 | |||
| f3e226130f | |||
| 77dd0e2715 | |||
| 917f2dff09 | |||
| 6588d9f1a8 | |||
| 5d5ee7d2a5 | |||
| df19655144 | |||
| 0303803f75 | |||
| 94db48467e | |||
| 793e7be756 | |||
| 3b6d6bf28b | |||
| a9d9854e5e | |||
| 4bdd3effcc | |||
| 794acc4814 | |||
| d42896e956 | |||
| 0fe38df019 | |||
| fb5221854c | |||
| a4bd9263a2 | |||
| 85cd1ad04f | |||
| c5aeb19735 | |||
| 9db955bdcf | |||
| e988e55b77 | |||
| bc60f1caa1 | |||
| 068d5d7f4f | |||
| 370834856b | |||
| ad054127aa | |||
| a05d15d17f | |||
| 717f02ce16 | |||
| 863e911120 | |||
| 6c56b338c1 |
@@ -0,0 +1,28 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Commerce\Catalog\Controllers\AdminApp;
|
||||
|
||||
use App\Domains\Commerce\Catalog\Requests\AdminApp\UpdateCategoryConfigurationRequest;
|
||||
use App\Domains\Commerce\Catalog\Resources\AdminApp\CategoryConfigurationResource;
|
||||
use App\Domains\Commerce\Catalog\Services\CategoryConfigurationService;
|
||||
use App\Http\Controllers\Controller;
|
||||
use Illuminate\Http\Request;
|
||||
use Illuminate\Http\Resources\Json\AnonymousResourceCollection;
|
||||
|
||||
class CategoryConfigurationController extends Controller
|
||||
{
|
||||
public function index(Request $request, CategoryConfigurationService $service): AnonymousResourceCollection
|
||||
{
|
||||
return CategoryConfigurationResource::collection(
|
||||
$service->forTenant($request->user()->tenant()->firstOrFail())
|
||||
);
|
||||
}
|
||||
|
||||
public function update(UpdateCategoryConfigurationRequest $request, CategoryConfigurationService $service): AnonymousResourceCollection
|
||||
{
|
||||
$tenant = $request->user()->tenant()->firstOrFail();
|
||||
$service->update($tenant, $request->validated());
|
||||
|
||||
return CategoryConfigurationResource::collection($service->forTenant($tenant));
|
||||
}
|
||||
}
|
||||
@@ -15,6 +15,7 @@ use App\Domains\Commerce\Catalog\Resources\CatalogFeaturedGroupResource;
|
||||
use App\Domains\Commerce\Catalog\Resources\CatalogItemDetailResource;
|
||||
use App\Domains\Commerce\Catalog\Resources\CatalogSearchItemResource;
|
||||
use App\Domains\Commerce\Catalog\Resources\CatalogVariantOptionsResource;
|
||||
use App\Domains\Commerce\Catalog\Resources\CategoryResource;
|
||||
use App\Domains\Commerce\Catalog\Services\CatalogItemAllowanceService;
|
||||
use App\Domains\Commerce\Catalog\Services\CatalogService;
|
||||
use App\Domains\Commerce\Catalog\Services\FeaturedGroupService;
|
||||
@@ -78,11 +79,7 @@ class CatalogController extends Controller
|
||||
$allowances->attach($items->getCollection(), $this->userId($request));
|
||||
|
||||
return CatalogSearchItemResource::collection($items)->additional([
|
||||
'category' => [
|
||||
'id' => $category->id,
|
||||
'nombre' => $category->nombre,
|
||||
'categoria_id' => $category->categoria_id,
|
||||
],
|
||||
'category' => CategoryResource::make($category)->resolve($request),
|
||||
'layout' => $tenant->search_product_layout->value,
|
||||
'group_layout' => $tenant->search_group_layout->value,
|
||||
]);
|
||||
|
||||
@@ -0,0 +1,18 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Commerce\Catalog\Enums;
|
||||
|
||||
enum InventoryMovementOperation: string
|
||||
{
|
||||
case StockInitialized = 'stock_initialized';
|
||||
case StockIncreased = 'stock_increased';
|
||||
case StockDecreased = 'stock_decreased';
|
||||
case StockReserved = 'stock_reserved';
|
||||
case StockReleased = 'stock_released';
|
||||
case PurchaseCommitted = 'purchase_committed';
|
||||
case StockRefunded = 'stock_refunded';
|
||||
case EntryStockReserved = 'entry_stock_reserved';
|
||||
case EntryStockReleased = 'entry_stock_released';
|
||||
case InventoryReset = 'inventory_reset';
|
||||
case InventoryTransferred = 'inventory_transferred';
|
||||
}
|
||||
@@ -19,6 +19,7 @@ use Illuminate\Database\Eloquent\Relations\BelongsToMany;
|
||||
use Illuminate\Database\Eloquent\Relations\HasMany;
|
||||
use Illuminate\Database\Eloquent\SoftDeletes;
|
||||
use Illuminate\Support\Collection;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
|
||||
#[Fillable([
|
||||
'tenant_code',
|
||||
@@ -213,10 +214,14 @@ class CatalogItem extends Model
|
||||
/** @param Builder<CatalogItem> $query */
|
||||
public function scopeWhereAvailable(Builder $query): Builder
|
||||
{
|
||||
$availableInventory = static fn (Builder $inventoryQuery): Builder => Schema::hasColumn('inventories', 'available_stock')
|
||||
? $inventoryQuery->where('inventories.available_stock', '>', 0)
|
||||
: $inventoryQuery->whereRaw('inventories.real_stock > inventories.reserved_stock + inventories.entry_reserved_stock');
|
||||
|
||||
return $query->where(function (Builder $query): void {
|
||||
$query->whereNull('catalog_items.sales_end_at')
|
||||
->orWhere('catalog_items.sales_end_at', '>', now());
|
||||
})->where(function (Builder $query): void {
|
||||
})->where(function (Builder $query) use ($availableInventory): void {
|
||||
$query
|
||||
->where(function (Builder $unlimitedQuery): void {
|
||||
$unlimitedQuery
|
||||
@@ -236,20 +241,18 @@ class CatalogItem extends Model
|
||||
->whereNull('replaced_by_variant_id')
|
||||
->whereHas(
|
||||
'inventory',
|
||||
fn (Builder $inventoryQuery): Builder => $inventoryQuery
|
||||
->whereRaw('inventories.real_stock > inventories.reserved_stock + inventories.entry_reserved_stock')
|
||||
$availableInventory
|
||||
)
|
||||
)
|
||||
->orWhere(function (Builder $directItemQuery): void {
|
||||
->orWhere(function (Builder $directItemQuery) use ($availableInventory): void {
|
||||
$directItemQuery
|
||||
->whereDoesntHave('variants')
|
||||
->where(function (Builder $inventoryQuery): void {
|
||||
->where(function (Builder $inventoryQuery) use ($availableInventory): void {
|
||||
$inventoryQuery
|
||||
->whereNull('catalog_items.inventory_id')
|
||||
->orWhereHas(
|
||||
'inventory',
|
||||
fn (Builder $availableInventoryQuery): Builder => $availableInventoryQuery
|
||||
->whereRaw('inventories.real_stock > inventories.reserved_stock + inventories.entry_reserved_stock')
|
||||
$availableInventory
|
||||
);
|
||||
});
|
||||
});
|
||||
|
||||
@@ -4,6 +4,7 @@ namespace App\Domains\Commerce\Catalog\Models;
|
||||
|
||||
use App\Domains\Core\Auth\Models\User;
|
||||
use App\Domains\Core\Tenant\Models\Tenant;
|
||||
use App\Shared\Attachable\Models\Attachment;
|
||||
use Illuminate\Database\Eloquent\Attributes\Fillable;
|
||||
use Illuminate\Database\Eloquent\Factories\HasFactory;
|
||||
use Illuminate\Database\Eloquent\Model;
|
||||
@@ -16,6 +17,9 @@ use Illuminate\Database\Eloquent\Relations\HasMany;
|
||||
'categoria_id',
|
||||
'nombre',
|
||||
'is_enabled',
|
||||
'banner_id',
|
||||
'banner_enabled',
|
||||
'sort_order',
|
||||
])]
|
||||
class Category extends Model
|
||||
{
|
||||
@@ -25,6 +29,7 @@ class Category extends Model
|
||||
|
||||
protected $attributes = [
|
||||
'is_enabled' => true,
|
||||
'banner_enabled' => false,
|
||||
];
|
||||
|
||||
/**
|
||||
@@ -35,6 +40,9 @@ class Category extends Model
|
||||
return [
|
||||
'categoria_id' => 'integer',
|
||||
'is_enabled' => 'boolean',
|
||||
'banner_id' => 'integer',
|
||||
'banner_enabled' => 'boolean',
|
||||
'sort_order' => 'integer',
|
||||
];
|
||||
}
|
||||
|
||||
@@ -59,6 +67,12 @@ class Category extends Model
|
||||
return $this->belongsTo(self::class, 'categoria_id');
|
||||
}
|
||||
|
||||
/** @return BelongsTo<Attachment, $this> */
|
||||
public function banner(): BelongsTo
|
||||
{
|
||||
return $this->belongsTo(Attachment::class, 'banner_id');
|
||||
}
|
||||
|
||||
/**
|
||||
* @return HasMany<Category, $this>
|
||||
*/
|
||||
|
||||
@@ -2,11 +2,17 @@
|
||||
|
||||
namespace App\Domains\Commerce\Catalog\Models;
|
||||
|
||||
use App\Domains\Commerce\Catalog\Enums\InventoryMovementOperation;
|
||||
use App\Domains\Core\Auth\Models\User;
|
||||
use Illuminate\Database\Eloquent\Attributes\Fillable;
|
||||
use Illuminate\Database\Eloquent\Factories\HasFactory;
|
||||
use Illuminate\Database\Eloquent\Model;
|
||||
use Illuminate\Database\Eloquent\Relations\HasMany;
|
||||
use Illuminate\Database\Eloquent\Relations\HasOne;
|
||||
use Illuminate\Support\Facades\Auth;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
use Illuminate\Validation\ValidationException;
|
||||
|
||||
#[Fillable([
|
||||
'sold_units',
|
||||
@@ -38,6 +44,7 @@ class Inventory extends Model
|
||||
'reserved_stock' => 'integer',
|
||||
'entry_reserved_stock' => 'integer',
|
||||
'real_stock' => 'integer',
|
||||
'available_stock' => 'integer',
|
||||
];
|
||||
}
|
||||
|
||||
@@ -59,70 +66,295 @@ class Inventory extends Model
|
||||
return $this->hasMany(StockReservationLine::class);
|
||||
}
|
||||
|
||||
/** @return HasMany<InventoryMovement, $this> */
|
||||
public function movements(): HasMany
|
||||
{
|
||||
return $this->hasMany(InventoryMovement::class);
|
||||
}
|
||||
|
||||
public function availableStock(): int
|
||||
{
|
||||
return max(0, $this->real_stock - $this->reserved_stock - $this->entry_reserved_stock);
|
||||
if (! array_key_exists('available_stock', $this->attributes)) {
|
||||
return max(0, $this->real_stock - $this->reserved_stock - ($this->entry_reserved_stock ?? 0));
|
||||
}
|
||||
|
||||
return (int) $this->getAttribute('available_stock');
|
||||
}
|
||||
|
||||
public function reserveEntry(int $amount, bool $tracksInventory): void
|
||||
{
|
||||
if ($amount < 1 || ($tracksInventory && $this->availableStock() < $amount)) {
|
||||
throw new \InvalidArgumentException('No hay stock disponible para la reserva de entradas.');
|
||||
}
|
||||
$this->entry_reserved_stock += $amount;
|
||||
$this->save();
|
||||
$this->mutate(
|
||||
InventoryMovementOperation::EntryStockReserved,
|
||||
['entry_reserved_stock' => $amount],
|
||||
function (self $inventory) use ($amount, $tracksInventory): void {
|
||||
if ($amount < 1 || ($tracksInventory && $inventory->availableStock() < $amount)) {
|
||||
throw new \InvalidArgumentException('No hay stock disponible para la reserva de entradas.');
|
||||
}
|
||||
},
|
||||
);
|
||||
}
|
||||
|
||||
public function releaseEntry(int $amount): void
|
||||
{
|
||||
if ($amount < 1 || $this->entry_reserved_stock < $amount) {
|
||||
throw new \InvalidArgumentException('La cantidad de entradas reservadas no es válida.');
|
||||
}
|
||||
|
||||
$this->entry_reserved_stock -= $amount;
|
||||
$this->save();
|
||||
$this->mutate(
|
||||
InventoryMovementOperation::EntryStockReleased,
|
||||
['entry_reserved_stock' => -$amount],
|
||||
function (self $inventory) use ($amount): void {
|
||||
if ($amount < 1 || $inventory->entry_reserved_stock < $amount) {
|
||||
throw new \InvalidArgumentException('La cantidad de entradas reservadas no es válida.');
|
||||
}
|
||||
},
|
||||
);
|
||||
}
|
||||
|
||||
public function reserve(int $amount, bool $tracksInventory): void
|
||||
{
|
||||
if ($amount < 0) {
|
||||
throw new \InvalidArgumentException('La cantidad a reservar debe ser positiva.');
|
||||
}
|
||||
|
||||
if ($tracksInventory && $this->availableStock() < $amount) {
|
||||
throw new \InvalidArgumentException('No hay suficiente stock disponible para reservar.');
|
||||
}
|
||||
|
||||
$this->reserved_stock += $amount;
|
||||
$this->save();
|
||||
$this->mutate(
|
||||
InventoryMovementOperation::StockReserved,
|
||||
['reserved_stock' => $amount],
|
||||
function (self $inventory) use ($amount, $tracksInventory): void {
|
||||
if ($amount < 0) {
|
||||
throw new \InvalidArgumentException('La cantidad a reservar debe ser positiva.');
|
||||
}
|
||||
if ($tracksInventory && $inventory->availableStock() < $amount) {
|
||||
throw new \InvalidArgumentException('No hay suficiente stock disponible para reservar.');
|
||||
}
|
||||
},
|
||||
);
|
||||
}
|
||||
|
||||
public function release(int $amount): void
|
||||
{
|
||||
if ($amount < 0 || $this->reserved_stock < $amount) {
|
||||
throw new \InvalidArgumentException('La cantidad reservada no es válida.');
|
||||
}
|
||||
|
||||
$this->reserved_stock -= $amount;
|
||||
$this->save();
|
||||
$this->mutate(
|
||||
InventoryMovementOperation::StockReleased,
|
||||
['reserved_stock' => -$amount],
|
||||
function (self $inventory) use ($amount): void {
|
||||
if ($amount < 0 || $inventory->reserved_stock < $amount) {
|
||||
throw new \InvalidArgumentException('La cantidad reservada no es válida.');
|
||||
}
|
||||
},
|
||||
);
|
||||
}
|
||||
|
||||
public function buy(int $amount, bool $tracksInventory): void
|
||||
{
|
||||
if ($amount < 0 || $this->reserved_stock < $amount) {
|
||||
throw new \InvalidArgumentException('La cantidad reservada no alcanza para confirmar la compra.');
|
||||
$counterDeltas = ['reserved_stock' => -$amount, 'sold_units' => $amount];
|
||||
if (! array_key_exists('available_stock', $this->attributes) && $tracksInventory) {
|
||||
$counterDeltas['real_stock'] = -$amount;
|
||||
}
|
||||
|
||||
if ($tracksInventory && $this->real_stock - $this->entry_reserved_stock < $amount) {
|
||||
throw new \InvalidArgumentException('No hay suficiente stock real para confirmar la compra.');
|
||||
$this->mutate(
|
||||
InventoryMovementOperation::PurchaseCommitted,
|
||||
$counterDeltas,
|
||||
function (self $inventory) use ($amount, $tracksInventory): void {
|
||||
if ($amount < 0 || $inventory->reserved_stock < $amount) {
|
||||
throw new \InvalidArgumentException('La cantidad reservada no alcanza para confirmar la compra.');
|
||||
}
|
||||
if ($tracksInventory && $inventory->availableStock() < 0) {
|
||||
throw new \InvalidArgumentException('No hay suficiente stock real para confirmar la compra.');
|
||||
}
|
||||
},
|
||||
);
|
||||
}
|
||||
|
||||
public function adjustAvailableStock(
|
||||
int $delta,
|
||||
?User $responsibleUser = null,
|
||||
?string $idempotencyKey = null,
|
||||
): void {
|
||||
if ($delta === 0) {
|
||||
return;
|
||||
}
|
||||
|
||||
if ($tracksInventory) {
|
||||
$this->real_stock -= $amount;
|
||||
$operation = $delta > 0
|
||||
? InventoryMovementOperation::StockIncreased
|
||||
: InventoryMovementOperation::StockDecreased;
|
||||
|
||||
$this->mutate(
|
||||
$operation,
|
||||
['real_stock' => $delta],
|
||||
function (self $inventory) use ($delta): void {
|
||||
if ($inventory->real_stock + $delta < 0 || $inventory->availableStock() + $delta < 0) {
|
||||
throw ValidationException::withMessages([
|
||||
'stock_difference' => ['El ajuste dejaría el stock en un valor inválido.'],
|
||||
]);
|
||||
}
|
||||
},
|
||||
$responsibleUser,
|
||||
$idempotencyKey,
|
||||
);
|
||||
}
|
||||
|
||||
public function refundStock(int $amount, ?User $responsibleUser = null): void
|
||||
{
|
||||
$counterDeltas = ['refunded_units' => $amount];
|
||||
if (! array_key_exists('available_stock', $this->attributes)) {
|
||||
$counterDeltas['real_stock'] = $amount;
|
||||
}
|
||||
|
||||
$this->reserved_stock -= $amount;
|
||||
$this->sold_units += $amount;
|
||||
$this->save();
|
||||
$this->mutate(
|
||||
InventoryMovementOperation::StockRefunded,
|
||||
$counterDeltas,
|
||||
function () use ($amount): void {
|
||||
if ($amount < 1) {
|
||||
throw new \InvalidArgumentException('La cantidad devuelta debe ser positiva.');
|
||||
}
|
||||
},
|
||||
$responsibleUser,
|
||||
);
|
||||
}
|
||||
|
||||
public function commitDirectSale(int $amount, bool $tracksInventory = true): void
|
||||
{
|
||||
$this->mutate(
|
||||
InventoryMovementOperation::PurchaseCommitted,
|
||||
['sold_units' => $amount],
|
||||
function (self $inventory) use ($amount, $tracksInventory): void {
|
||||
if ($amount < 1 || ($tracksInventory && $inventory->availableStock() < $amount)) {
|
||||
throw new \InvalidArgumentException('No hay suficiente stock para confirmar la compra.');
|
||||
}
|
||||
},
|
||||
);
|
||||
}
|
||||
|
||||
public function recordInitialization(?User $responsibleUser = null): void
|
||||
{
|
||||
$this->recordCurrentState(InventoryMovementOperation::StockInitialized, $responsibleUser);
|
||||
}
|
||||
|
||||
public function recordTransferInitialization(?User $responsibleUser = null): void
|
||||
{
|
||||
$this->recordCurrentState(InventoryMovementOperation::InventoryTransferred, $responsibleUser);
|
||||
}
|
||||
|
||||
/** @param array<string, int> $counterDeltas */
|
||||
public function transferCounters(array $counterDeltas, ?User $responsibleUser = null): void
|
||||
{
|
||||
$counterDeltas = array_filter($counterDeltas, fn (int $delta): bool => $delta !== 0);
|
||||
if ($counterDeltas === []) {
|
||||
return;
|
||||
}
|
||||
|
||||
$this->mutate(
|
||||
InventoryMovementOperation::InventoryTransferred,
|
||||
$counterDeltas,
|
||||
function (self $inventory) use ($counterDeltas): void {
|
||||
foreach ($counterDeltas as $counter => $delta) {
|
||||
if ((int) $inventory->getAttribute($counter) + $delta < 0) {
|
||||
throw new \LogicException("El traslado dejaría {$counter} en un valor negativo.");
|
||||
}
|
||||
}
|
||||
},
|
||||
$responsibleUser,
|
||||
);
|
||||
}
|
||||
|
||||
private function recordCurrentState(
|
||||
InventoryMovementOperation $operation,
|
||||
?User $responsibleUser,
|
||||
): void {
|
||||
if (! Schema::hasTable('inventory_movements')) {
|
||||
return;
|
||||
}
|
||||
|
||||
$this->refresh();
|
||||
$counterDeltas = array_filter([
|
||||
'real_stock' => $this->real_stock,
|
||||
'sold_units' => $this->sold_units,
|
||||
'reserved_stock' => $this->reserved_stock,
|
||||
'entry_reserved_stock' => $this->entry_reserved_stock,
|
||||
'refunded_units' => $this->refunded_units,
|
||||
], fn (int $delta): bool => $delta !== 0);
|
||||
|
||||
$this->movements()->create([
|
||||
'operation' => $operation,
|
||||
'available_stock_delta' => $this->availableStock(),
|
||||
'available_stock_before' => 0,
|
||||
'available_stock_after' => $this->availableStock(),
|
||||
'counter_deltas' => $counterDeltas,
|
||||
'responsible_user_id' => $responsibleUser?->getKey() ?? Auth::id(),
|
||||
]);
|
||||
}
|
||||
|
||||
public function resetTransactionCounters(?User $responsibleUser = null): void
|
||||
{
|
||||
$this->refresh();
|
||||
$counterDeltas = array_filter([
|
||||
'sold_units' => -$this->sold_units,
|
||||
'reserved_stock' => -$this->reserved_stock,
|
||||
'entry_reserved_stock' => -$this->entry_reserved_stock,
|
||||
'refunded_units' => -$this->refunded_units,
|
||||
], fn (int $delta): bool => $delta !== 0);
|
||||
|
||||
if ($counterDeltas === []) {
|
||||
return;
|
||||
}
|
||||
|
||||
$this->mutate(
|
||||
InventoryMovementOperation::InventoryReset,
|
||||
$counterDeltas,
|
||||
static function (): void {},
|
||||
$responsibleUser,
|
||||
);
|
||||
}
|
||||
|
||||
/**
|
||||
* @param array<string, int> $counterDeltas
|
||||
* @param callable(self): void $validate
|
||||
*/
|
||||
private function mutate(
|
||||
InventoryMovementOperation $operation,
|
||||
array $counterDeltas,
|
||||
callable $validate,
|
||||
?User $responsibleUser = null,
|
||||
?string $idempotencyKey = null,
|
||||
): void {
|
||||
DB::transaction(function () use ($operation, $counterDeltas, $validate, $responsibleUser, $idempotencyKey): void {
|
||||
/** @var self $inventory */
|
||||
$inventory = self::query()->lockForUpdate()->findOrFail($this->getKey());
|
||||
$this->setRawAttributes($inventory->getAttributes(), true);
|
||||
|
||||
$recordsMovements = Schema::hasTable('inventory_movements');
|
||||
if ($recordsMovements && $idempotencyKey !== null) {
|
||||
$existing = $this->movements()
|
||||
->where('idempotency_key', $idempotencyKey)
|
||||
->first();
|
||||
if ($existing !== null) {
|
||||
if ($existing->counter_deltas !== $counterDeltas) {
|
||||
throw ValidationException::withMessages([
|
||||
'stock_adjustment_id' => ['La operación ya fue utilizada con otro ajuste.'],
|
||||
]);
|
||||
}
|
||||
|
||||
return;
|
||||
}
|
||||
}
|
||||
|
||||
$validate($this);
|
||||
$counterDeltas = array_filter($counterDeltas, fn (int $delta): bool => $delta !== 0);
|
||||
if ($counterDeltas === []) {
|
||||
return;
|
||||
}
|
||||
|
||||
$availableBefore = $this->availableStock();
|
||||
foreach ($counterDeltas as $counter => $delta) {
|
||||
$this->setAttribute($counter, (int) $this->getAttribute($counter) + $delta);
|
||||
}
|
||||
$this->save();
|
||||
$this->refresh();
|
||||
|
||||
$availableAfter = $this->availableStock();
|
||||
if ($recordsMovements) {
|
||||
$this->movements()->create([
|
||||
'operation' => $operation,
|
||||
'available_stock_delta' => $availableAfter - $availableBefore,
|
||||
'available_stock_before' => $availableBefore,
|
||||
'available_stock_after' => $availableAfter,
|
||||
'counter_deltas' => $counterDeltas,
|
||||
'responsible_user_id' => $responsibleUser?->getKey() ?? Auth::id(),
|
||||
'idempotency_key' => $idempotencyKey,
|
||||
]);
|
||||
}
|
||||
});
|
||||
}
|
||||
}
|
||||
|
||||
45
app/Domains/Commerce/Catalog/Models/InventoryMovement.php
Normal file
45
app/Domains/Commerce/Catalog/Models/InventoryMovement.php
Normal file
@@ -0,0 +1,45 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Commerce\Catalog\Models;
|
||||
|
||||
use App\Domains\Commerce\Catalog\Enums\InventoryMovementOperation;
|
||||
use App\Domains\Core\Auth\Models\User;
|
||||
use Illuminate\Database\Eloquent\Attributes\Fillable;
|
||||
use Illuminate\Database\Eloquent\Model;
|
||||
use Illuminate\Database\Eloquent\Relations\BelongsTo;
|
||||
|
||||
#[Fillable([
|
||||
'inventory_id',
|
||||
'operation',
|
||||
'available_stock_delta',
|
||||
'available_stock_before',
|
||||
'available_stock_after',
|
||||
'counter_deltas',
|
||||
'responsible_user_id',
|
||||
'idempotency_key',
|
||||
])]
|
||||
class InventoryMovement extends Model
|
||||
{
|
||||
protected function casts(): array
|
||||
{
|
||||
return [
|
||||
'operation' => InventoryMovementOperation::class,
|
||||
'available_stock_delta' => 'integer',
|
||||
'available_stock_before' => 'integer',
|
||||
'available_stock_after' => 'integer',
|
||||
'counter_deltas' => 'array',
|
||||
];
|
||||
}
|
||||
|
||||
/** @return BelongsTo<Inventory, $this> */
|
||||
public function inventory(): BelongsTo
|
||||
{
|
||||
return $this->belongsTo(Inventory::class);
|
||||
}
|
||||
|
||||
/** @return BelongsTo<User, $this> */
|
||||
public function responsibleUser(): BelongsTo
|
||||
{
|
||||
return $this->belongsTo(User::class, 'responsible_user_id');
|
||||
}
|
||||
}
|
||||
@@ -0,0 +1,69 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Commerce\Catalog\Requests\AdminApp;
|
||||
|
||||
use App\Shared\Rules\ImageOrBase64Rule;
|
||||
use Illuminate\Foundation\Http\FormRequest;
|
||||
use Illuminate\Support\Facades\Validator;
|
||||
use Illuminate\Validation\Validator as ValidationValidator;
|
||||
|
||||
class UpdateCategoryConfigurationRequest extends FormRequest
|
||||
{
|
||||
public function authorize(): bool
|
||||
{
|
||||
return true;
|
||||
}
|
||||
|
||||
public function rules(): array
|
||||
{
|
||||
return [
|
||||
'categories' => ['present', 'array', 'max:500'],
|
||||
'deleted_ids' => ['present', 'array', 'max:1000'],
|
||||
'deleted_ids.*' => ['required', 'integer', 'min:1', 'distinct'],
|
||||
];
|
||||
}
|
||||
|
||||
public function withValidator(ValidationValidator $validator): void
|
||||
{
|
||||
$validator->after(function (ValidationValidator $validator): void {
|
||||
if ($validator->errors()->isNotEmpty()) {
|
||||
return;
|
||||
}
|
||||
$this->validateNodes($validator, $this->input('categories'), 'categories', 0);
|
||||
});
|
||||
}
|
||||
|
||||
private function validateNodes(ValidationValidator $validator, array $nodes, string $path, int $depth): void
|
||||
{
|
||||
if ($depth > 10) {
|
||||
$validator->errors()->add($path, 'La jerarquía de categorías es demasiado profunda.');
|
||||
|
||||
return;
|
||||
}
|
||||
|
||||
foreach ($nodes as $index => $node) {
|
||||
$key = "{$path}.{$index}";
|
||||
if (! is_array($node)) {
|
||||
$validator->errors()->add($key, 'La categoría debe ser un objeto.');
|
||||
|
||||
continue;
|
||||
}
|
||||
$nested = Validator::make($node, [
|
||||
'id' => ['present', 'nullable', 'integer', 'min:1'],
|
||||
'nombre' => ['required', 'string', 'max:255'],
|
||||
'is_enabled' => ['required', 'boolean'],
|
||||
'banner_enabled' => ['required', 'boolean'],
|
||||
'banner' => ['present', 'nullable', new ImageOrBase64Rule],
|
||||
'subcategories' => ['present', 'array', 'max:500'],
|
||||
]);
|
||||
foreach ($nested->errors()->messages() as $field => $messages) {
|
||||
foreach ($messages as $message) {
|
||||
$validator->errors()->add("{$key}.{$field}", $message);
|
||||
}
|
||||
}
|
||||
if (! $nested->fails()) {
|
||||
$this->validateNodes($validator, $node['subcategories'], "{$key}.subcategories", $depth + 1);
|
||||
}
|
||||
}
|
||||
}
|
||||
}
|
||||
@@ -0,0 +1,25 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Commerce\Catalog\Resources\AdminApp;
|
||||
|
||||
use App\Domains\Commerce\Catalog\Models\Category;
|
||||
use Illuminate\Http\Request;
|
||||
use Illuminate\Http\Resources\Json\JsonResource;
|
||||
|
||||
/** @mixin Category */
|
||||
class CategoryConfigurationResource extends JsonResource
|
||||
{
|
||||
public function toArray(Request $request): array
|
||||
{
|
||||
return [
|
||||
'id' => $this->id,
|
||||
'nombre' => $this->nombre,
|
||||
'is_enabled' => $this->is_enabled,
|
||||
'banner_enabled' => $this->banner_enabled,
|
||||
'banner_key' => $this->banner?->key,
|
||||
'banner_name' => $this->banner?->filename,
|
||||
'banner_url' => $this->banner?->getTemporaryUrl(1440),
|
||||
'subcategories' => self::collection($this->subCategories),
|
||||
];
|
||||
}
|
||||
}
|
||||
24
app/Domains/Commerce/Catalog/Resources/CategoryResource.php
Normal file
24
app/Domains/Commerce/Catalog/Resources/CategoryResource.php
Normal file
@@ -0,0 +1,24 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Commerce\Catalog\Resources;
|
||||
|
||||
use App\Domains\Commerce\Catalog\Models\Category;
|
||||
use Illuminate\Http\Request;
|
||||
use Illuminate\Http\Resources\Json\JsonResource;
|
||||
|
||||
/** @mixin Category */
|
||||
class CategoryResource extends JsonResource
|
||||
{
|
||||
/** @return array<string, mixed> */
|
||||
public function toArray(Request $request): array
|
||||
{
|
||||
return [
|
||||
'id' => $this->id,
|
||||
'nombre' => $this->nombre,
|
||||
'categoria_id' => $this->categoria_id,
|
||||
'banner_url' => $this->banner_enabled
|
||||
? $this->banner?->getTemporaryUrl(1440)
|
||||
: null,
|
||||
];
|
||||
}
|
||||
}
|
||||
@@ -64,6 +64,7 @@ class CatalogInventoryService
|
||||
$selection->loadMissing('variants.inventory');
|
||||
|
||||
return $selection->variants
|
||||
->each(fn (Variant $variant) => $variant->setRelation('catalogItem', $selection))
|
||||
->filter(fn (Variant $variant): bool => $variant->isSellable())
|
||||
->unique(fn (Variant $variant): string => $variant->inventory_id === null
|
||||
? 'object:'.spl_object_id($variant->inventory)
|
||||
@@ -153,7 +154,7 @@ class CatalogInventoryService
|
||||
|
||||
if ($operation === 'commit'
|
||||
&& $requirement['tracks_inventory']
|
||||
&& $inventory->real_stock - $inventory->entry_reserved_stock < $requiredQuantity) {
|
||||
&& $inventory->availableStock() < 0) {
|
||||
throw new \InvalidArgumentException('No hay suficiente stock real para confirmar la compra.');
|
||||
}
|
||||
}
|
||||
|
||||
@@ -370,9 +370,12 @@ class CatalogService
|
||||
|
||||
private function createInventory(int $realStock): Inventory
|
||||
{
|
||||
return Inventory::query()->create([
|
||||
$inventory = Inventory::query()->create([
|
||||
'real_stock' => $realStock,
|
||||
]);
|
||||
$inventory->recordInitialization();
|
||||
|
||||
return $inventory;
|
||||
}
|
||||
|
||||
/**
|
||||
|
||||
@@ -0,0 +1,141 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Commerce\Catalog\Services;
|
||||
|
||||
use App\Domains\Commerce\Catalog\Models\Category;
|
||||
use App\Domains\Commerce\Catalog\Models\FeaturedGroup;
|
||||
use App\Domains\Core\Tenant\Models\Tenant;
|
||||
use App\Shared\Attachable\Enums\AttachmentType;
|
||||
use App\Shared\Attachable\Models\Attachment;
|
||||
use App\Shared\Attachable\Services\AttachmentService;
|
||||
use Illuminate\Support\Collection;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
use Illuminate\Support\Facades\Storage;
|
||||
use Illuminate\Support\Str;
|
||||
use Illuminate\Validation\ValidationException;
|
||||
use Throwable;
|
||||
|
||||
class CategoryConfigurationService
|
||||
{
|
||||
public function __construct(private readonly AttachmentService $attachments) {}
|
||||
|
||||
/** @return Collection<int, Category> */
|
||||
public function forTenant(Tenant $tenant): Collection
|
||||
{
|
||||
$all = $tenant->categories()->with('banner')->orderBy('sort_order')->orderBy('id')->get();
|
||||
$children = $all->groupBy('categoria_id');
|
||||
foreach ($all as $category) {
|
||||
$category->setRelation('subCategories', $children->get($category->id, collect()));
|
||||
}
|
||||
|
||||
return $all->filter(fn (Category $category) => $category->categoria_id === null)->values();
|
||||
}
|
||||
|
||||
/** @param array<string, mixed> $data */
|
||||
public function update(Tenant $tenant, array $data): void
|
||||
{
|
||||
$created = [];
|
||||
try {
|
||||
DB::transaction(function () use ($tenant, $data, &$created): void {
|
||||
// Serialize saves for this tenant, including creation of new categories.
|
||||
Tenant::query()->whereKey($tenant->id)->lockForUpdate()->firstOrFail();
|
||||
$existing = $tenant->categories()->with('banner')->lockForUpdate()->get()->keyBy('id');
|
||||
$deleted = array_map('intval', $data['deleted_ids']);
|
||||
$seen = [];
|
||||
$allowedBannerKeys = $existing->pluck('banner.key')->filter()->all();
|
||||
$this->validateNodes($data['categories'], $existing, $deleted, $seen, $allowedBannerKeys);
|
||||
|
||||
foreach ($deleted as $id) {
|
||||
$category = $existing->get($id);
|
||||
if ($category === null) {
|
||||
$this->invalid('deleted_ids', 'Una categoría a eliminar no pertenece a esta tienda.');
|
||||
}
|
||||
if ($category->catalogItems()->withTrashed()->exists()
|
||||
|| FeaturedGroup::query()->where('category_id', $id)->exists()) {
|
||||
$this->invalid('deleted_ids', "No se puede eliminar «{$category->nombre}» porque tiene productos o grupos destacados asociados. Podés ocultarla.");
|
||||
}
|
||||
}
|
||||
|
||||
$this->saveNodes($tenant, $data['categories'], null, $existing, $created);
|
||||
$remaining = $tenant->categories()->whereNotIn('id', $deleted)->get();
|
||||
$parents = $remaining->pluck('categoria_id', 'id');
|
||||
foreach ($remaining as $category) {
|
||||
$visited = [$category->id => true];
|
||||
$parentId = $category->categoria_id;
|
||||
while ($parentId !== null) {
|
||||
if (isset($visited[$parentId]) || ! $parents->has($parentId)) {
|
||||
$this->invalid('categories', 'La jerarquía contiene un ciclo o una categoría padre eliminada.');
|
||||
}
|
||||
$visited[$parentId] = true;
|
||||
$parentId = $parents->get($parentId);
|
||||
}
|
||||
}
|
||||
|
||||
// Detach only explicitly deleted nodes before removing parents and children together.
|
||||
$tenant->categories()->whereIn('id', $deleted)->update(['categoria_id' => null]);
|
||||
$tenant->categories()->whereIn('id', $deleted)->delete();
|
||||
});
|
||||
} catch (Throwable $error) {
|
||||
foreach ($created as $attachment) {
|
||||
Storage::disk('s3')->delete($attachment->path);
|
||||
}
|
||||
throw $error;
|
||||
}
|
||||
}
|
||||
|
||||
private function validateNodes(array $nodes, Collection $existing, array $deleted, array &$seen, array $bannerKeys, string $path = 'categories'): void
|
||||
{
|
||||
foreach ($nodes as $index => $node) {
|
||||
$field = "{$path}.{$index}";
|
||||
if ($node['id'] !== null) {
|
||||
$id = (int) $node['id'];
|
||||
if (! $existing->has($id) || isset($seen[$id]) || in_array($id, $deleted, true)) {
|
||||
$this->invalid("{$field}.id", 'La categoría es ajena a la tienda, está repetida o fue marcada para eliminar.');
|
||||
}
|
||||
$seen[$id] = true;
|
||||
}
|
||||
if (trim($node['nombre']) === '') {
|
||||
$this->invalid("{$field}.nombre", 'Completá el nombre de la categoría.');
|
||||
}
|
||||
if (is_string($node['banner']) && Str::isUuid($node['banner'])
|
||||
&& ! in_array($node['banner'], $bannerKeys, true)) {
|
||||
$this->invalid("{$field}.banner", 'El banner no pertenece a las categorías de esta tienda.');
|
||||
}
|
||||
$this->validateNodes($node['subcategories'], $existing, $deleted, $seen, $bannerKeys, "{$field}.subcategories");
|
||||
}
|
||||
}
|
||||
|
||||
private function saveNodes(Tenant $tenant, array $nodes, ?int $parentId, Collection $existing, array &$created): void
|
||||
{
|
||||
foreach (array_values($nodes) as $order => $node) {
|
||||
$category = $node['id'] === null ? new Category : $existing->get((int) $node['id']);
|
||||
$banner = null;
|
||||
if ($node['banner'] !== null) {
|
||||
if (is_string($node['banner']) && Str::isUuid($node['banner'])) {
|
||||
$banner = Attachment::query()->where('key', $node['banner'])->firstOrFail();
|
||||
if ($banner->type !== AttachmentType::Image) {
|
||||
$this->invalid('categories', 'El banner debe ser una imagen.');
|
||||
}
|
||||
} else {
|
||||
$banner = $this->attachments->store($node['banner'], "tenants/{$tenant->codigo}/categories");
|
||||
$created[] = $banner;
|
||||
}
|
||||
}
|
||||
$category->fill([
|
||||
'tenant_code' => $tenant->codigo,
|
||||
'categoria_id' => $parentId,
|
||||
'nombre' => trim($node['nombre']),
|
||||
'is_enabled' => $node['is_enabled'],
|
||||
'banner_id' => $banner?->id,
|
||||
'banner_enabled' => $node['banner_enabled'],
|
||||
'sort_order' => $order,
|
||||
])->save();
|
||||
$this->saveNodes($tenant, $node['subcategories'], $category->id, $existing, $created);
|
||||
}
|
||||
}
|
||||
|
||||
private function invalid(string $field, string $message): never
|
||||
{
|
||||
throw ValidationException::withMessages([$field => $message]);
|
||||
}
|
||||
}
|
||||
@@ -225,7 +225,7 @@ class StockReservationService
|
||||
$inventory = $inventories->get($line->inventory_id)
|
||||
?? throw new \InvalidArgumentException('No se encontró el inventario reservado.');
|
||||
if ($inventory->reserved_stock < $line->quantity
|
||||
|| ($line->tracks_inventory && $inventory->real_stock - $inventory->entry_reserved_stock < $line->quantity)) {
|
||||
|| ($line->tracks_inventory && $inventory->availableStock() < 0)) {
|
||||
throw new \InvalidArgumentException('La reserva de stock no alcanza para confirmar la compra.');
|
||||
}
|
||||
}
|
||||
|
||||
@@ -194,6 +194,7 @@ class VariantReplacementService
|
||||
'entry_reserved_stock' => $sourceInventory->entry_reserved_stock,
|
||||
'real_stock' => $sourceInventory->real_stock,
|
||||
]);
|
||||
$replacementInventory->recordTransferInitialization();
|
||||
|
||||
if ($activeLines->isNotEmpty()) {
|
||||
StockReservationLine::query()
|
||||
@@ -202,7 +203,10 @@ class VariantReplacementService
|
||||
}
|
||||
EntryReservation::query()->where('inventory_id', $sourceInventory->id)
|
||||
->update(['inventory_id' => $replacementInventory->id]);
|
||||
$sourceInventory->update(['reserved_stock' => 0, 'entry_reserved_stock' => 0]);
|
||||
$sourceInventory->transferCounters([
|
||||
'reserved_stock' => -$sourceInventory->reserved_stock,
|
||||
'entry_reserved_stock' => -$sourceInventory->entry_reserved_stock,
|
||||
]);
|
||||
|
||||
return $replacementInventory;
|
||||
}
|
||||
@@ -236,13 +240,14 @@ class VariantReplacementService
|
||||
throw new \LogicException('El inventario reservado de la variante es inconsistente.');
|
||||
}
|
||||
|
||||
$destinationInventory->update([
|
||||
'real_stock' => $destinationInventory->real_stock + $sourceInventory->real_stock,
|
||||
'reserved_stock' => $destinationInventory->reserved_stock + $sourceInventory->reserved_stock,
|
||||
'entry_reserved_stock' => $destinationInventory->entry_reserved_stock + $sourceInventory->entry_reserved_stock,
|
||||
'sold_units' => $destinationInventory->sold_units + $sourceInventory->sold_units,
|
||||
'refunded_units' => $destinationInventory->refunded_units + $sourceInventory->refunded_units,
|
||||
]);
|
||||
$transferredCounters = [
|
||||
'real_stock' => $sourceInventory->real_stock,
|
||||
'reserved_stock' => $sourceInventory->reserved_stock,
|
||||
'entry_reserved_stock' => $sourceInventory->entry_reserved_stock,
|
||||
'sold_units' => $sourceInventory->sold_units,
|
||||
'refunded_units' => $sourceInventory->refunded_units,
|
||||
];
|
||||
$destinationInventory->transferCounters($transferredCounters);
|
||||
if ($activeLines->isNotEmpty()) {
|
||||
StockReservationLine::query()
|
||||
->whereKey($activeLines->modelKeys())
|
||||
@@ -250,13 +255,10 @@ class VariantReplacementService
|
||||
}
|
||||
EntryReservation::query()->where('inventory_id', $sourceInventory->id)
|
||||
->update(['inventory_id' => $destinationInventory->id]);
|
||||
$sourceInventory->update([
|
||||
'real_stock' => 0,
|
||||
'reserved_stock' => 0,
|
||||
'entry_reserved_stock' => 0,
|
||||
'sold_units' => 0,
|
||||
'refunded_units' => 0,
|
||||
]);
|
||||
$sourceInventory->transferCounters(array_map(
|
||||
fn (int $value): int => -$value,
|
||||
$transferredCounters,
|
||||
));
|
||||
}
|
||||
|
||||
/** @return list<string> */
|
||||
|
||||
@@ -31,6 +31,16 @@ Bajo `/tenants/{tenant:codigo}` se publican catálogo, búsqueda, categoría, de
|
||||
|
||||
Bajo `/v1/adminapp/tenant/featured-groups`, con `auth:sanctum` y `adminapp.tenant`, se listan, crean y actualizan grupos destacados.
|
||||
|
||||
### Configuración de categorías de producto
|
||||
|
||||
`GET /v1/adminapp/tenant/categories` devuelve un árbol ordenado de las categorías del tenant autenticado, incluidas las ocultas. Cada nodo contiene `id`, `nombre`, `is_enabled`, `banner_enabled`, `banner_key`, `banner_name`, `banner_url` y `subcategories`. La URL administrativa se devuelve incluso si el banner está deshabilitado.
|
||||
|
||||
`PUT /v1/adminapp/tenant/categories` recibe `categories` y `deleted_ids`. Cada nodo enviado contiene `id` (null para altas), `nombre`, `is_enabled`, `banner_enabled`, `banner` y `subcategories`. `banner` es una clave UUID de un banner ya asociado a las categorías del tenant, una imagen base64/archivo para reemplazarlo o null para quitarlo. Deshabilitar un banner conserva el adjunto. Duplicar una categoría puede compartir su banner; los adjuntos previos no se eliminan al quitar o reemplazar esa referencia.
|
||||
|
||||
La posición de cada nodo en su lista determina `sort_order`; este campo no se expone en las respuestas públicas ni administrativas. La migración inicial conserva el orden alfabético existente. El bootstrap del storefront ordena por `sort_order` e ID y no muestra categorías ocultas ni sus descendientes.
|
||||
|
||||
El guardado es transaccional. Solo se eliminan los IDs explícitos, se rechazan IDs y banners ajenos, categorías repetidas y jerarquías inválidas. No se pueden eliminar categorías con productos (incluidos los archivados) o grupos destacados asociados. Los archivos recién subidos se limpian si falla la transacción. La respuesta devuelve el árbol persistido y los IDs asignados a las altas.
|
||||
|
||||
## Dependencias y reglas
|
||||
|
||||
Usa `Attachable` para imágenes/archivos, `Tenant` para aislamiento y `Ticket`/`Event` para vigencia y fechas. `Cart` y `Purchase` consumen sus precios, variantes e inventario. Los cambios de stock deben pasar por `CatalogInventoryService` para conservar reservas y disponibilidad.
|
||||
|
||||
@@ -1,11 +1,14 @@
|
||||
<?php
|
||||
|
||||
use App\Domains\Commerce\Catalog\Controllers\AdminApp\CategoryConfigurationController;
|
||||
use App\Domains\Commerce\Catalog\Controllers\AdminApp\OnTicketFeaturedGroupController;
|
||||
use Illuminate\Support\Facades\Route;
|
||||
|
||||
Route::prefix('v1/adminapp/tenant')
|
||||
->middleware(['auth:sanctum', 'adminapp.tenant'])
|
||||
->group(function (): void {
|
||||
Route::get('categories', [CategoryConfigurationController::class, 'index']);
|
||||
Route::put('categories', [CategoryConfigurationController::class, 'update']);
|
||||
Route::get('featured-groups', [OnTicketFeaturedGroupController::class, 'index'])
|
||||
->name('adminapp.featured-groups.index');
|
||||
Route::post('featured-groups', [OnTicketFeaturedGroupController::class, 'store'])
|
||||
|
||||
@@ -2,6 +2,7 @@
|
||||
|
||||
namespace App\Domains\Commerce\Purchase\Services;
|
||||
|
||||
use App\Domains\Commerce\Catalog\Models\Inventory;
|
||||
use App\Domains\Commerce\Purchase\Models\Purchase;
|
||||
use Illuminate\Database\Query\Builder;
|
||||
use Illuminate\Support\Collection;
|
||||
@@ -69,15 +70,12 @@ class TenantTransactionResetService
|
||||
'users_preserved' => DB::table('users')->where('tenant_codigo', $tenantCode)->count(),
|
||||
];
|
||||
|
||||
DB::table('inventories')
|
||||
->whereIn('id', $scope['inventory_ids'])
|
||||
->update([
|
||||
'real_stock' => DB::raw('real_stock + sold_units - refunded_units'),
|
||||
'reserved_stock' => 0,
|
||||
'entry_reserved_stock' => 0,
|
||||
'sold_units' => 0,
|
||||
'refunded_units' => 0,
|
||||
]);
|
||||
Inventory::query()
|
||||
->whereKey($scope['inventory_ids'])
|
||||
->orderBy('id')
|
||||
->lockForUpdate()
|
||||
->get()
|
||||
->each(fn (Inventory $inventory) => $inventory->resetTransactionCounters());
|
||||
|
||||
return $summary;
|
||||
});
|
||||
|
||||
47
app/Domains/Core/Address/Models/Address.php
Normal file
47
app/Domains/Core/Address/Models/Address.php
Normal file
@@ -0,0 +1,47 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Core\Address\Models;
|
||||
|
||||
use App\Domains\Core\Tenant\Models\Tenant;
|
||||
use App\Domains\Ticketing\Event\Models\Event;
|
||||
use Illuminate\Database\Eloquent\Model;
|
||||
use Illuminate\Database\Eloquent\Relations\BelongsToMany;
|
||||
use Illuminate\Database\Eloquent\Relations\HasMany;
|
||||
|
||||
class Address extends Model
|
||||
{
|
||||
protected $fillable = ['label', 'address_text', 'latitude', 'longitude'];
|
||||
|
||||
protected function casts(): array
|
||||
{
|
||||
return [
|
||||
'latitude' => 'decimal:7',
|
||||
'longitude' => 'decimal:7',
|
||||
];
|
||||
}
|
||||
|
||||
/** @return array{latitude: float, longitude: float}|null */
|
||||
public function coordinates(): ?array
|
||||
{
|
||||
if ($this->latitude === null || $this->longitude === null) {
|
||||
return null;
|
||||
}
|
||||
|
||||
return ['latitude' => (float) $this->latitude, 'longitude' => (float) $this->longitude];
|
||||
}
|
||||
|
||||
/** @return HasMany<Event, $this> */
|
||||
public function events(): HasMany
|
||||
{
|
||||
return $this->hasMany(Event::class);
|
||||
}
|
||||
|
||||
/** @return BelongsToMany<Tenant, $this> */
|
||||
public function tenants(): BelongsToMany
|
||||
{
|
||||
return $this->belongsToMany(Tenant::class, 'tenant_addresses', 'address_id', 'tenant_codigo', 'id', 'codigo')
|
||||
->using(TenantAddress::class)
|
||||
->withPivot(['id', 'is_main'])
|
||||
->withTimestamps();
|
||||
}
|
||||
}
|
||||
33
app/Domains/Core/Address/Models/TenantAddress.php
Normal file
33
app/Domains/Core/Address/Models/TenantAddress.php
Normal file
@@ -0,0 +1,33 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Core\Address\Models;
|
||||
|
||||
use App\Domains\Core\Tenant\Models\Tenant;
|
||||
use Illuminate\Database\Eloquent\Relations\BelongsTo;
|
||||
use Illuminate\Database\Eloquent\Relations\Pivot;
|
||||
|
||||
class TenantAddress extends Pivot
|
||||
{
|
||||
protected $table = 'tenant_addresses';
|
||||
|
||||
public $incrementing = true;
|
||||
|
||||
protected $fillable = ['tenant_codigo', 'address_id', 'is_main'];
|
||||
|
||||
protected function casts(): array
|
||||
{
|
||||
return ['is_main' => 'boolean'];
|
||||
}
|
||||
|
||||
/** @return BelongsTo<Tenant, $this> */
|
||||
public function tenant(): BelongsTo
|
||||
{
|
||||
return $this->belongsTo(Tenant::class, 'tenant_codigo', 'codigo');
|
||||
}
|
||||
|
||||
/** @return BelongsTo<Address, $this> */
|
||||
public function address(): BelongsTo
|
||||
{
|
||||
return $this->belongsTo(Address::class);
|
||||
}
|
||||
}
|
||||
22
app/Domains/Core/Address/Resources/AddressResource.php
Normal file
22
app/Domains/Core/Address/Resources/AddressResource.php
Normal file
@@ -0,0 +1,22 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Core\Address\Resources;
|
||||
|
||||
use App\Domains\Core\Address\Models\Address;
|
||||
use Illuminate\Http\Request;
|
||||
use Illuminate\Http\Resources\Json\JsonResource;
|
||||
|
||||
/** @mixin Address */
|
||||
class AddressResource extends JsonResource
|
||||
{
|
||||
public function toArray(Request $request): array
|
||||
{
|
||||
return [
|
||||
'id' => $this->id,
|
||||
'label' => $this->label,
|
||||
'address_text' => $this->address_text,
|
||||
'latitude' => $this->latitude === null ? null : (float) $this->latitude,
|
||||
'longitude' => $this->longitude === null ? null : (float) $this->longitude,
|
||||
];
|
||||
}
|
||||
}
|
||||
@@ -11,6 +11,9 @@ class AdminAppContextService
|
||||
{
|
||||
$tenant = $user->tenant()
|
||||
->with([
|
||||
'socialMedia',
|
||||
'addresses',
|
||||
'phoneNumbers',
|
||||
'menues' => fn ($query) => $query
|
||||
->whereHas(
|
||||
'roles',
|
||||
|
||||
@@ -33,12 +33,17 @@ class TenantBootstrapService
|
||||
$tenant,
|
||||
[
|
||||
'eventDateChanges',
|
||||
'menues' => fn ($query) => $query->whereHas(
|
||||
'roles',
|
||||
fn ($query) => $query->where('codigo', RoleCode::User->value)
|
||||
),
|
||||
$tenant->storefront_website_type_code === 'onticket_multi_event'
|
||||
? 'eventCategories' : 'categories' => fn ($query) => $query->orderBy('nombre'),
|
||||
'menues' => fn ($query) => $query
|
||||
->where(fn ($query) => $query
|
||||
->where('menues.code', 'help.contact')
|
||||
->orWhere('tenants_menues.is_enabled', true))
|
||||
->whereHas(
|
||||
'roles',
|
||||
fn ($query) => $query->where('codigo', RoleCode::User->value)
|
||||
),
|
||||
...($tenant->storefront_website_type_code === 'onticket_multi_event'
|
||||
? ['eventCategories' => fn ($query) => $query->orderBy('nombre')]
|
||||
: ['categories' => fn ($query) => $query->orderBy('sort_order')->orderBy('id')]),
|
||||
]
|
||||
);
|
||||
}
|
||||
|
||||
@@ -76,7 +76,7 @@ class Menu extends Model
|
||||
'codigo'
|
||||
)
|
||||
->using(TenantMenu::class)
|
||||
->withPivot('static_content')
|
||||
->withPivot('static_content', 'is_enabled')
|
||||
->withTimestamps();
|
||||
}
|
||||
|
||||
|
||||
@@ -16,12 +16,14 @@ class TenantMenu extends Pivot
|
||||
'tenant_code',
|
||||
'menu_code',
|
||||
'static_content',
|
||||
'is_enabled',
|
||||
];
|
||||
|
||||
protected function casts(): array
|
||||
{
|
||||
return [
|
||||
'static_content' => 'array',
|
||||
'is_enabled' => 'boolean',
|
||||
];
|
||||
}
|
||||
|
||||
|
||||
61
app/Domains/Core/PhoneNumber/Models/PhoneNumber.php
Normal file
61
app/Domains/Core/PhoneNumber/Models/PhoneNumber.php
Normal file
@@ -0,0 +1,61 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Core\PhoneNumber\Models;
|
||||
|
||||
use App\Domains\Core\Tenant\Models\Tenant;
|
||||
use Illuminate\Database\Eloquent\Model;
|
||||
use Illuminate\Database\Eloquent\Relations\BelongsToMany;
|
||||
|
||||
class PhoneNumber extends Model
|
||||
{
|
||||
protected $attributes = ['country_code' => '+54', 'mobile_prefix' => '9'];
|
||||
|
||||
protected $fillable = ['label', 'country_code', 'mobile_prefix', 'area_code', 'local_number'];
|
||||
|
||||
public function getNumberAttribute(?string $legacyNumber): string
|
||||
{
|
||||
if ($this->local_number === null) {
|
||||
return $legacyNumber ?? '';
|
||||
}
|
||||
|
||||
$areaCode = $this->mobile_prefix && $this->area_code
|
||||
? '('.$this->area_code.')'
|
||||
: $this->area_code;
|
||||
|
||||
return implode(' ', array_filter([
|
||||
$this->country_code,
|
||||
$this->mobile_prefix,
|
||||
$areaCode,
|
||||
$this->local_number,
|
||||
], fn ($part): bool => $part !== null && $part !== ''));
|
||||
}
|
||||
|
||||
public static function dialableNumber(string $number): string
|
||||
{
|
||||
return preg_replace('/[^0-9+]/', '', $number);
|
||||
}
|
||||
|
||||
public function telUrl(): string
|
||||
{
|
||||
if ($this->country_code === null || $this->local_number === null) {
|
||||
return 'tel:'.self::dialableNumber($this->number);
|
||||
}
|
||||
|
||||
$areaCode = $this->area_code ?? '';
|
||||
if ($this->country_code === '+54') {
|
||||
$areaCode = ltrim($areaCode, '0');
|
||||
}
|
||||
|
||||
return 'tel:'.self::dialableNumber(
|
||||
$this->country_code.($this->mobile_prefix ?? '').$areaCode.$this->local_number
|
||||
);
|
||||
}
|
||||
|
||||
public function tenants(): BelongsToMany
|
||||
{
|
||||
return $this->belongsToMany(Tenant::class, 'tenant_phone_numbers', 'phone_number_id', 'tenant_codigo', 'id', 'codigo')
|
||||
->using(TenantPhoneNumber::class)
|
||||
->withPivot(['id', 'is_main'])
|
||||
->withTimestamps();
|
||||
}
|
||||
}
|
||||
31
app/Domains/Core/PhoneNumber/Models/TenantPhoneNumber.php
Normal file
31
app/Domains/Core/PhoneNumber/Models/TenantPhoneNumber.php
Normal file
@@ -0,0 +1,31 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Core\PhoneNumber\Models;
|
||||
|
||||
use App\Domains\Core\Tenant\Models\Tenant;
|
||||
use Illuminate\Database\Eloquent\Relations\BelongsTo;
|
||||
use Illuminate\Database\Eloquent\Relations\Pivot;
|
||||
|
||||
class TenantPhoneNumber extends Pivot
|
||||
{
|
||||
protected $table = 'tenant_phone_numbers';
|
||||
|
||||
public $incrementing = true;
|
||||
|
||||
protected $fillable = ['tenant_codigo', 'phone_number_id', 'is_main'];
|
||||
|
||||
protected function casts(): array
|
||||
{
|
||||
return ['is_main' => 'boolean'];
|
||||
}
|
||||
|
||||
public function tenant(): BelongsTo
|
||||
{
|
||||
return $this->belongsTo(Tenant::class, 'tenant_codigo', 'codigo');
|
||||
}
|
||||
|
||||
public function phoneNumber(): BelongsTo
|
||||
{
|
||||
return $this->belongsTo(PhoneNumber::class);
|
||||
}
|
||||
}
|
||||
@@ -0,0 +1,24 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Core\PhoneNumber\Resources;
|
||||
|
||||
use Illuminate\Http\Request;
|
||||
use Illuminate\Http\Resources\Json\JsonResource;
|
||||
|
||||
class PhoneNumberResource extends JsonResource
|
||||
{
|
||||
public function toArray(Request $request): array
|
||||
{
|
||||
return [
|
||||
'id' => $this->id,
|
||||
'label' => $this->label,
|
||||
'country_code' => $this->country_code,
|
||||
'mobile_prefix' => $this->mobile_prefix,
|
||||
'area_code' => $this->area_code,
|
||||
'local_number' => $this->local_number,
|
||||
'number' => $this->number,
|
||||
'tel_url' => $this->resource->telUrl(),
|
||||
'is_main' => $this->whenPivotLoaded('tenant_phone_numbers', fn () => (bool) $this->pivot->is_main),
|
||||
];
|
||||
}
|
||||
}
|
||||
@@ -0,0 +1,31 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Core\Tenant\Controllers\AdminApp;
|
||||
|
||||
use App\Domains\Core\Tenant\Requests\AdminApp\UpdateBrandRequest;
|
||||
use App\Domains\Core\Tenant\Resources\AdminApp\BrandResource;
|
||||
use App\Domains\Core\Tenant\Services\BrandService;
|
||||
use App\Domains\Core\Tenant\Services\TenantInformationService;
|
||||
use App\Http\Controllers\Controller;
|
||||
use Illuminate\Http\Request;
|
||||
|
||||
class BrandController extends Controller
|
||||
{
|
||||
public function show(Request $request, TenantInformationService $tenantInformationService): BrandResource
|
||||
{
|
||||
$tenant = $request->user()->tenant()->firstOrFail();
|
||||
|
||||
return BrandResource::make($tenantInformationService->load($tenant));
|
||||
}
|
||||
|
||||
public function update(
|
||||
UpdateBrandRequest $request,
|
||||
BrandService $brandService,
|
||||
TenantInformationService $tenantInformationService,
|
||||
): BrandResource {
|
||||
$tenant = $request->user()->tenant()->firstOrFail();
|
||||
$brandService->update($tenant, $request->validated());
|
||||
|
||||
return BrandResource::make($tenantInformationService->load($tenant->fresh()));
|
||||
}
|
||||
}
|
||||
@@ -0,0 +1,22 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Core\Tenant\Controllers\AdminApp;
|
||||
|
||||
use App\Domains\Core\Tenant\Requests\AdminApp\UpdateContactRequest;
|
||||
use App\Domains\Core\Tenant\Resources\AdminApp\ContactResource;
|
||||
use App\Domains\Core\Tenant\Services\ContactService;
|
||||
use App\Http\Controllers\Controller;
|
||||
use Illuminate\Http\Request;
|
||||
|
||||
class ContactController extends Controller
|
||||
{
|
||||
public function show(Request $request, ContactService $service): ContactResource
|
||||
{
|
||||
return ContactResource::make($service->load($request->user()->tenant()->firstOrFail()));
|
||||
}
|
||||
|
||||
public function update(UpdateContactRequest $request, ContactService $service): ContactResource
|
||||
{
|
||||
return ContactResource::make($service->update($request->user()->tenant()->firstOrFail(), $request->validated()));
|
||||
}
|
||||
}
|
||||
@@ -0,0 +1,90 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Core\Tenant\Controllers\AdminApp;
|
||||
|
||||
use App\Domains\Core\Tenant\Requests\AdminApp\UpdateHelpMenuContentRequest;
|
||||
use App\Http\Controllers\Controller;
|
||||
use Illuminate\Http\JsonResponse;
|
||||
use Illuminate\Http\Request;
|
||||
|
||||
class HelpMenuController extends Controller
|
||||
{
|
||||
private const MENU_CODES = [
|
||||
'help.faq',
|
||||
'help.terms-and-conditions',
|
||||
];
|
||||
|
||||
public function index(Request $request): JsonResponse
|
||||
{
|
||||
$tenant = $request->user()->tenant()->firstOrFail();
|
||||
$menus = $tenant->menues()
|
||||
->whereIn('menues.code', self::MENU_CODES)
|
||||
->get()
|
||||
->keyBy('code');
|
||||
|
||||
return response()->json([
|
||||
'data' => collect(self::MENU_CODES)->mapWithKeys(
|
||||
fn (string $code): array => [$code => [
|
||||
'code' => $code,
|
||||
'is_enabled' => (bool) ($menus->get($code)?->pivot?->is_enabled ?? false),
|
||||
'static_content' => $menus->get($code)?->pivot?->static_content
|
||||
?? $this->emptyContent($code),
|
||||
]]
|
||||
),
|
||||
]);
|
||||
}
|
||||
|
||||
public function toggle(
|
||||
Request $request,
|
||||
string $menuCode,
|
||||
): JsonResponse {
|
||||
abort_unless(in_array($menuCode, self::MENU_CODES, true), 404);
|
||||
|
||||
$tenant = $request->user()->tenant()->firstOrFail();
|
||||
$tenantMenu = $tenant->menues()
|
||||
->where('menues.code', $menuCode)
|
||||
->firstOrFail();
|
||||
$isEnabled = ! $tenantMenu->pivot->is_enabled;
|
||||
|
||||
$tenant->menues()->updateExistingPivot($menuCode, [
|
||||
'is_enabled' => $isEnabled,
|
||||
]);
|
||||
|
||||
return response()->json([
|
||||
'data' => [
|
||||
'code' => $tenantMenu->code,
|
||||
'is_enabled' => $isEnabled,
|
||||
],
|
||||
]);
|
||||
}
|
||||
|
||||
public function updateContent(
|
||||
UpdateHelpMenuContentRequest $request,
|
||||
string $menuCode,
|
||||
): JsonResponse {
|
||||
abort_unless(in_array($menuCode, self::MENU_CODES, true), 404);
|
||||
|
||||
$tenant = $request->user()->tenant()->firstOrFail();
|
||||
$tenantMenu = $tenant->menues()
|
||||
->where('menues.code', $menuCode)
|
||||
->firstOrFail();
|
||||
$staticContent = $request->validated('static_content');
|
||||
|
||||
$tenant->menues()->updateExistingPivot($menuCode, [
|
||||
'static_content' => $staticContent,
|
||||
]);
|
||||
|
||||
return response()->json([
|
||||
'data' => [
|
||||
'code' => $tenantMenu->code,
|
||||
'is_enabled' => (bool) $tenantMenu->pivot->is_enabled,
|
||||
'static_content' => $staticContent,
|
||||
],
|
||||
]);
|
||||
}
|
||||
|
||||
private function emptyContent(string $menuCode): array
|
||||
{
|
||||
return $menuCode === 'help.faq' ? [] : ['html' => ''];
|
||||
}
|
||||
}
|
||||
@@ -6,6 +6,10 @@ use App\Domains\Commerce\Catalog\Enums\GroupLayout;
|
||||
use App\Domains\Commerce\Catalog\Enums\ProductLayout;
|
||||
use App\Domains\Commerce\Catalog\Models\CatalogItem;
|
||||
use App\Domains\Commerce\Catalog\Models\Category;
|
||||
use App\Domains\Core\Address\Models\Address;
|
||||
use App\Domains\Core\Address\Models\TenantAddress;
|
||||
use App\Domains\Core\PhoneNumber\Models\PhoneNumber;
|
||||
use App\Domains\Core\PhoneNumber\Models\TenantPhoneNumber;
|
||||
use App\Domains\Core\Client\Models\Client;
|
||||
use App\Domains\Core\Menu\Models\Menu;
|
||||
use App\Domains\Core\Menu\Models\TenantMenu;
|
||||
@@ -22,6 +26,7 @@ use Illuminate\Database\Eloquent\Model;
|
||||
use Illuminate\Database\Eloquent\Relations\BelongsTo;
|
||||
use Illuminate\Database\Eloquent\Relations\BelongsToMany;
|
||||
use Illuminate\Database\Eloquent\Relations\HasMany;
|
||||
use Illuminate\Database\Eloquent\Relations\HasOneThrough;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
|
||||
#[Fillable([
|
||||
@@ -308,6 +313,39 @@ class Tenant extends Model
|
||||
return $this->hasMany(WebsiteExtra::class, 'website_code', 'codigo');
|
||||
}
|
||||
|
||||
/** @return BelongsToMany<Address, $this> */
|
||||
public function addresses(): BelongsToMany
|
||||
{
|
||||
return $this->belongsToMany(Address::class, 'tenant_addresses', 'tenant_codigo', 'address_id', 'codigo', 'id')
|
||||
->using(TenantAddress::class)
|
||||
->withPivot(['id', 'is_main'])
|
||||
->withTimestamps()
|
||||
->orderByPivot('id');
|
||||
}
|
||||
|
||||
/** @return HasOneThrough<Address, TenantAddress, $this> */
|
||||
public function mainAddress(): HasOneThrough
|
||||
{
|
||||
return $this->hasOneThrough(Address::class, TenantAddress::class, 'tenant_codigo', 'id', 'codigo', 'address_id')
|
||||
->where('tenant_addresses.is_main', true);
|
||||
}
|
||||
|
||||
public function phoneNumbers(): BelongsToMany
|
||||
{
|
||||
return $this->belongsToMany(PhoneNumber::class, 'tenant_phone_numbers', 'tenant_codigo', 'phone_number_id', 'codigo', 'id')
|
||||
->using(TenantPhoneNumber::class)
|
||||
->withPivot(['id', 'is_main'])
|
||||
->withTimestamps()
|
||||
->orderByPivot('is_main', 'desc')
|
||||
->orderByPivot('id');
|
||||
}
|
||||
|
||||
public function mainPhoneNumber(): HasOneThrough
|
||||
{
|
||||
return $this->hasOneThrough(PhoneNumber::class, TenantPhoneNumber::class, 'tenant_codigo', 'id', 'codigo', 'phone_number_id')
|
||||
->where('tenant_phone_numbers.is_main', true);
|
||||
}
|
||||
|
||||
public function menues(): BelongsToMany
|
||||
{
|
||||
return $this->belongsToMany(
|
||||
@@ -319,7 +357,7 @@ class Tenant extends Model
|
||||
'code'
|
||||
)
|
||||
->using(TenantMenu::class)
|
||||
->withPivot('static_content')
|
||||
->withPivot('static_content', 'is_enabled')
|
||||
->withTimestamps();
|
||||
}
|
||||
}
|
||||
|
||||
@@ -0,0 +1,31 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Core\Tenant\Requests\AdminApp;
|
||||
|
||||
use App\Shared\Rules\CroppedImageOrBase64Rule;
|
||||
use App\Shared\Rules\ImageOrBase64Rule;
|
||||
use Illuminate\Foundation\Http\FormRequest;
|
||||
|
||||
class UpdateBrandRequest extends FormRequest
|
||||
{
|
||||
public function authorize(): bool
|
||||
{
|
||||
return true;
|
||||
}
|
||||
|
||||
/** @return array<string, mixed> */
|
||||
public function rules(): array
|
||||
{
|
||||
$shopit = $this->user()->tenant()->firstOrFail()->storefront_website_type_code === 'shopit';
|
||||
|
||||
return [
|
||||
'nombre' => ['required', 'string', 'max:255'],
|
||||
'primary_color' => ['required', 'regex:/^#[0-9a-fA-F]{6}$/'],
|
||||
'footer_bg_color' => ['required', 'regex:/^#[0-9a-fA-F]{6}$/'],
|
||||
'header_logo' => ['present', 'nullable', new ImageOrBase64Rule],
|
||||
'footer_logo' => ['present', 'nullable', new ImageOrBase64Rule],
|
||||
'banner_images' => [$shopit ? 'present' : 'prohibited', 'array', 'max:10'],
|
||||
'banner_images.*' => ['required', new CroppedImageOrBase64Rule],
|
||||
];
|
||||
}
|
||||
}
|
||||
@@ -0,0 +1,71 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Core\Tenant\Requests\AdminApp;
|
||||
|
||||
use Illuminate\Foundation\Http\FormRequest;
|
||||
use Illuminate\Validation\Rule;
|
||||
|
||||
class UpdateContactRequest extends FormRequest
|
||||
{
|
||||
public function authorize(): bool
|
||||
{
|
||||
return true;
|
||||
}
|
||||
|
||||
public function rules(): array
|
||||
{
|
||||
$tenantCode = $this->user()->tenant_codigo;
|
||||
|
||||
return [
|
||||
'social_media' => ['present', 'array', 'max:30'],
|
||||
'social_media.*' => ['array:code,url'],
|
||||
'social_media.*.code' => ['required', 'string', 'distinct', Rule::exists('social_media', 'code')],
|
||||
'social_media.*.url' => ['required', 'url:http,https', 'max:255'],
|
||||
'addresses' => ['present', 'array', 'list', 'max:50'],
|
||||
'addresses.*' => ['array:id,address_text,is_main'],
|
||||
'addresses.*.id' => ['nullable', 'integer', 'distinct', Rule::exists('tenant_addresses', 'address_id')->where('tenant_codigo', $tenantCode)],
|
||||
'addresses.*.address_text' => ['required', 'string', 'max:1000'],
|
||||
'addresses.*.is_main' => ['sometimes', 'boolean'],
|
||||
'phone_numbers' => ['present', 'array', 'list', 'max:50'],
|
||||
'phone_numbers.*' => ['array:id,country_code,mobile_prefix,area_code,local_number,is_main'],
|
||||
'phone_numbers.*.id' => ['nullable', 'integer', 'distinct', Rule::exists('tenant_phone_numbers', 'phone_number_id')->where('tenant_codigo', $tenantCode)],
|
||||
'phone_numbers.*.country_code' => ['present', 'nullable', 'regex:/^\+[0-9]{1,4}$/'],
|
||||
'phone_numbers.*.mobile_prefix' => ['present', 'nullable', 'regex:/^[0-9]{1,4}$/'],
|
||||
'phone_numbers.*.area_code' => ['present', 'nullable', 'regex:/^[0-9]{1,8}$/'],
|
||||
'phone_numbers.*.local_number' => ['required', 'string', 'max:50', 'regex:/^[0-9+() .-]+$/', 'regex:/[0-9]/'],
|
||||
'phone_numbers.*.is_main' => ['sometimes', 'boolean'],
|
||||
];
|
||||
}
|
||||
|
||||
public function attributes(): array
|
||||
{
|
||||
return [
|
||||
'social_media' => 'redes sociales',
|
||||
'social_media.*.code' => 'red social',
|
||||
'social_media.*.url' => 'URL de la red social',
|
||||
'addresses' => 'direcciones',
|
||||
'addresses.*.id' => 'dirección',
|
||||
'addresses.*.address_text' => 'dirección',
|
||||
'addresses.*.is_main' => 'dirección principal',
|
||||
'phone_numbers' => 'teléfonos',
|
||||
'phone_numbers.*.id' => 'teléfono',
|
||||
'phone_numbers.*.country_code' => 'código de país',
|
||||
'phone_numbers.*.mobile_prefix' => 'prefijo móvil',
|
||||
'phone_numbers.*.area_code' => 'código de área',
|
||||
'phone_numbers.*.local_number' => 'número de teléfono',
|
||||
'phone_numbers.*.is_main' => 'teléfono principal',
|
||||
];
|
||||
}
|
||||
|
||||
public function messages(): array
|
||||
{
|
||||
return [
|
||||
'required' => 'Completá :attribute.',
|
||||
'url' => 'La URL debe ser válida y comenzar con http:// o https://.',
|
||||
'regex' => 'El formato de :attribute no es válido.',
|
||||
'exists' => 'El valor de :attribute no está disponible para este comercio.',
|
||||
'distinct' => 'Hay un valor duplicado en :attribute.',
|
||||
'max.string' => 'El campo :attribute admite hasta :max caracteres.',
|
||||
];
|
||||
}
|
||||
}
|
||||
@@ -0,0 +1,31 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Core\Tenant\Requests\AdminApp;
|
||||
|
||||
use Illuminate\Foundation\Http\FormRequest;
|
||||
|
||||
class UpdateHelpMenuContentRequest extends FormRequest
|
||||
{
|
||||
public function authorize(): bool
|
||||
{
|
||||
return true;
|
||||
}
|
||||
|
||||
/** @return array<string, mixed> */
|
||||
public function rules(): array
|
||||
{
|
||||
return match ($this->route('menuCode')) {
|
||||
'help.faq' => [
|
||||
'static_content' => ['required', 'array'],
|
||||
'static_content.*.pregunta' => ['required', 'string'],
|
||||
'static_content.*.respuesta' => ['required', 'string'],
|
||||
'static_content.*.is_active' => ['required', 'boolean'],
|
||||
],
|
||||
'help.terms-and-conditions' => [
|
||||
'static_content' => ['required', 'array'],
|
||||
'static_content.html' => ['present', 'nullable', 'string'],
|
||||
],
|
||||
default => [],
|
||||
};
|
||||
}
|
||||
}
|
||||
104
app/Domains/Core/Tenant/Resources/AdminApp/BrandResource.php
Normal file
104
app/Domains/Core/Tenant/Resources/AdminApp/BrandResource.php
Normal file
@@ -0,0 +1,104 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Core\Tenant\Resources\AdminApp;
|
||||
|
||||
use App\Domains\Core\Tenant\Models\Tenant;
|
||||
use App\Shared\Attachable\Models\Attachment;
|
||||
use App\Shared\Attachable\Models\AttachmentCrop;
|
||||
use Illuminate\Http\Request;
|
||||
use Illuminate\Http\Resources\Json\JsonResource;
|
||||
|
||||
/** @mixin Tenant */
|
||||
class BrandResource extends JsonResource
|
||||
{
|
||||
/** @return array<string, mixed> */
|
||||
public function toArray(Request $request): array
|
||||
{
|
||||
return [
|
||||
'nombre' => $this->nombre,
|
||||
'primary_color' => $this->primary_color,
|
||||
'header_bg_color' => $this->header_bg_color,
|
||||
'footer_color' => $this->footerColor(),
|
||||
'header_logo' => $this->headerLogo?->getTemporaryUrl(1440),
|
||||
'header_logo_key' => $this->headerLogo?->key,
|
||||
'footer_logo' => $this->footerLogo?->getTemporaryUrl(1440),
|
||||
'footer_logo_key' => $this->footerLogo?->key,
|
||||
'can_edit_carousel' => $this->canEditCarousel(),
|
||||
'banner_images' => $this->bannerImages(),
|
||||
];
|
||||
}
|
||||
|
||||
private function footerColor(): string
|
||||
{
|
||||
$footerColor = strtolower(trim((string) $this->footer_bg_color));
|
||||
$primaryColor = strtolower(trim((string) $this->primary_color));
|
||||
|
||||
if ($footerColor !== '' && $footerColor === $primaryColor) {
|
||||
return 'primary';
|
||||
}
|
||||
|
||||
if (in_array($footerColor, ['#000', '#000000', 'black'], true)) {
|
||||
return 'black';
|
||||
}
|
||||
|
||||
if ($footerColor === '' || in_array($footerColor, ['#fff', '#ffffff', 'white'], true)) {
|
||||
return 'white';
|
||||
}
|
||||
|
||||
return 'primary';
|
||||
}
|
||||
|
||||
/** @return array<int, array<string, mixed>> */
|
||||
private function bannerImages(): array
|
||||
{
|
||||
if (! $this->canEditCarousel()) {
|
||||
return [];
|
||||
}
|
||||
|
||||
$extra = $this->websiteExtras->first(
|
||||
fn ($extra) => $extra->is_enabled && $extra->websiteTypeExtra->codigo === 'carousel'
|
||||
);
|
||||
|
||||
if ($extra === null) {
|
||||
return [];
|
||||
}
|
||||
|
||||
$images = $extra->resolvedConfig();
|
||||
|
||||
if (! is_array($images)) {
|
||||
return [];
|
||||
}
|
||||
|
||||
return collect($images)
|
||||
->filter(fn ($image) => $image instanceof Attachment)
|
||||
->map(function (Attachment $image): array {
|
||||
$desktopCrop = $image->cropVariants
|
||||
->firstWhere('variant', AttachmentCrop::DESKTOP);
|
||||
|
||||
return [
|
||||
'key' => $image->key,
|
||||
'url' => ($desktopCrop?->croppedAttachment ?? $image)->getTemporaryUrl(1440),
|
||||
'original_url' => $image->getTemporaryUrl(1440),
|
||||
'crop' => $desktopCrop === null ? null : [
|
||||
'crop_horizontal' => $desktopCrop->crop_horizontal,
|
||||
'crop_vertical' => $desktopCrop->crop_vertical,
|
||||
],
|
||||
];
|
||||
})
|
||||
->values()
|
||||
->all();
|
||||
}
|
||||
|
||||
private function canEditCarousel(): bool
|
||||
{
|
||||
if ($this->storefront_website_type_code !== 'shopit') {
|
||||
return false;
|
||||
}
|
||||
|
||||
$extra = $this->websiteExtras->first(
|
||||
fn ($extra) => $extra->websiteTypeExtra->codigo === 'carousel'
|
||||
);
|
||||
|
||||
return $extra === null || $extra->is_enabled;
|
||||
}
|
||||
}
|
||||
@@ -0,0 +1,23 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Core\Tenant\Resources\AdminApp;
|
||||
|
||||
use App\Domains\Core\PhoneNumber\Resources\PhoneNumberResource;
|
||||
use App\Domains\Core\Tenant\Resources\TenantAddressResource;
|
||||
use Illuminate\Http\Request;
|
||||
use Illuminate\Http\Resources\Json\JsonResource;
|
||||
|
||||
class ContactResource extends JsonResource
|
||||
{
|
||||
public function toArray(Request $request): array
|
||||
{
|
||||
return [
|
||||
'social_media' => $this->socialMedia->map(fn ($network) => [
|
||||
'code' => $network->code,
|
||||
'url' => $network->pivot->url,
|
||||
])->values(),
|
||||
'addresses' => TenantAddressResource::collection($this->addresses),
|
||||
'phone_numbers' => PhoneNumberResource::collection($this->phoneNumbers),
|
||||
];
|
||||
}
|
||||
}
|
||||
14
app/Domains/Core/Tenant/Resources/TenantAddressResource.php
Normal file
14
app/Domains/Core/Tenant/Resources/TenantAddressResource.php
Normal file
@@ -0,0 +1,14 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Core\Tenant\Resources;
|
||||
|
||||
use App\Domains\Core\Address\Resources\AddressResource;
|
||||
use Illuminate\Http\Request;
|
||||
|
||||
class TenantAddressResource extends AddressResource
|
||||
{
|
||||
public function toArray(Request $request): array
|
||||
{
|
||||
return [...parent::toArray($request), 'is_main' => (bool) $this->pivot->is_main];
|
||||
}
|
||||
}
|
||||
@@ -3,7 +3,9 @@
|
||||
namespace App\Domains\Core\Tenant\Resources;
|
||||
|
||||
use App\Domains\Commerce\Catalog\Models\Category;
|
||||
use App\Domains\Core\Address\Resources\AddressResource;
|
||||
use App\Domains\Core\Menu\Models\Menu;
|
||||
use App\Domains\Core\PhoneNumber\Resources\PhoneNumberResource;
|
||||
use App\Domains\Core\Tenant\Models\StorefrontWebsiteType;
|
||||
use App\Domains\Core\Tenant\Models\Tenant;
|
||||
use App\Domains\Ticketing\Event\Models\Event;
|
||||
@@ -41,7 +43,11 @@ class TenantResource extends JsonResource
|
||||
'site_title' => $this->site_title ?? 'ShopitFront',
|
||||
'asset_url' => config('filesystems.disks.s3.url'),
|
||||
'address' => $this->address,
|
||||
'addresses' => $this->whenLoaded('addresses', fn () => TenantAddressResource::collection($this->addresses)),
|
||||
'main_address' => $this->whenLoaded('mainAddress', fn () => AddressResource::make($this->mainAddress)),
|
||||
'phone' => $this->phone,
|
||||
'phone_numbers' => $this->whenLoaded('phoneNumbers', fn () => PhoneNumberResource::collection($this->phoneNumbers)),
|
||||
'main_phone_number' => $this->whenLoaded('mainPhoneNumber', fn () => PhoneNumberResource::make($this->mainPhoneNumber)),
|
||||
'favicon' => $this->favicon?->getTemporaryUrl(1440),
|
||||
'primary_color' => $this->primary_color,
|
||||
'secondary_color' => $this->secondary_color,
|
||||
@@ -99,6 +105,13 @@ class TenantResource extends JsonResource
|
||||
])
|
||||
->values()
|
||||
),
|
||||
'tenant_social_media' => $this->whenLoaded('socialMedia', fn () => $this->socialMedia
|
||||
->map(fn ($socialMedia) => [
|
||||
'code' => $socialMedia->code,
|
||||
'icon' => $socialMedia->icon,
|
||||
'name' => $socialMedia->name,
|
||||
'url' => $socialMedia->pivot->url,
|
||||
])->values()),
|
||||
'menues' => $this->whenLoaded(
|
||||
'menues',
|
||||
fn () => $this->menuTree($this->menues)
|
||||
@@ -127,6 +140,7 @@ class TenantResource extends JsonResource
|
||||
'subtitle' => $event->subtitle,
|
||||
'description' => $event->description,
|
||||
'location' => $event->location,
|
||||
'address' => AddressResource::make($event->address),
|
||||
'date_text' => $event->date_text,
|
||||
'dates' => $event->dates
|
||||
->filter(fn (EventDate $date): bool => $date->rescheduled_to_event_date_id === null)
|
||||
@@ -193,12 +207,14 @@ class TenantResource extends JsonResource
|
||||
'nombre' => $category->nombre,
|
||||
'subcategories' => $childrenByParent
|
||||
->get($category->id, collect())
|
||||
->filter(fn (Category $child) => $child->is_enabled)
|
||||
->map($formatCategory)
|
||||
->values(),
|
||||
];
|
||||
};
|
||||
|
||||
return $categories
|
||||
->filter(fn (Category $category) => $category->is_enabled)
|
||||
->filter(fn (Category $category) => $category->categoria_id === null
|
||||
|| ! $categoryIds->has($category->categoria_id))
|
||||
->map($formatCategory)
|
||||
@@ -226,7 +242,7 @@ class TenantResource extends JsonResource
|
||||
'route' => $menu->route,
|
||||
];
|
||||
|
||||
if ($menu->pivot?->static_content !== null) {
|
||||
if ($menu->content_type === Menu::CONTENT_TYPE_STATIC && $menu->pivot?->static_content !== null) {
|
||||
$formatted['static_content'] = $menu->pivot->static_content;
|
||||
}
|
||||
|
||||
|
||||
165
app/Domains/Core/Tenant/Services/BrandService.php
Normal file
165
app/Domains/Core/Tenant/Services/BrandService.php
Normal file
@@ -0,0 +1,165 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Core\Tenant\Services;
|
||||
|
||||
use App\Domains\Core\Tenant\Models\Tenant;
|
||||
use App\Shared\Attachable\Enums\AttachmentType;
|
||||
use App\Shared\Attachable\Models\Attachment;
|
||||
use App\Shared\Attachable\Services\AttachmentService;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
use Illuminate\Support\Facades\Storage;
|
||||
use Illuminate\Support\Str;
|
||||
use Illuminate\Validation\ValidationException;
|
||||
use Throwable;
|
||||
|
||||
class BrandService
|
||||
{
|
||||
public function __construct(
|
||||
private readonly AttachmentService $attachmentService,
|
||||
private readonly WebsiteExtraService $websiteExtraService,
|
||||
) {}
|
||||
|
||||
/** @param array<string, mixed> $data */
|
||||
public function update(Tenant $tenant, array $data): void
|
||||
{
|
||||
$carousel = $tenant->storefront_website_type_code === 'shopit'
|
||||
? $tenant->websiteExtras()->whereHas('websiteTypeExtra',
|
||||
fn ($query) => $query->where('codigo', 'carousel'))->first()
|
||||
: null;
|
||||
$allowedBannerIds = is_array($carousel?->config) ? $carousel->config : [];
|
||||
if ($carousel !== null && ! $carousel->is_enabled && ($data['banner_images'] ?? []) !== []) {
|
||||
throw ValidationException::withMessages(['banner_images' => 'El carrusel está deshabilitado.']);
|
||||
}
|
||||
$seen = [];
|
||||
|
||||
foreach (['header_logo' => $tenant->header_logo_id, 'footer_logo' => $tenant->footer_logo_id] as $field => $id) {
|
||||
$this->existingImage($data[$field], $id === null ? [] : [$id], $field);
|
||||
}
|
||||
foreach ($data['banner_images'] ?? [] as $index => $item) {
|
||||
$image = is_array($item) ? $item['image'] : $item;
|
||||
$attachment = $this->existingImage($image, $allowedBannerIds, "banner_images.{$index}");
|
||||
if ($attachment !== null) {
|
||||
if (isset($seen[$attachment->id])) {
|
||||
throw ValidationException::withMessages(["banner_images.{$index}" => 'La imagen está repetida.']);
|
||||
}
|
||||
$seen[$attachment->id] = true;
|
||||
}
|
||||
}
|
||||
|
||||
$created = [];
|
||||
|
||||
try {
|
||||
DB::transaction(function () use ($tenant, $data, $carousel, &$created): void {
|
||||
$header = $this->logo($data['header_logo'], $tenant->header_logo_id, $tenant, $created);
|
||||
$footer = $this->logo($data['footer_logo'], $tenant->footer_logo_id, $tenant, $created);
|
||||
|
||||
$tenant->update([
|
||||
'nombre' => trim($data['nombre']),
|
||||
'primary_color' => $data['primary_color'],
|
||||
'footer_bg_color' => $data['footer_bg_color'],
|
||||
'header_logo_id' => $header?->id,
|
||||
'footer_logo_id' => $footer?->id,
|
||||
]);
|
||||
|
||||
if ($tenant->storefront_website_type_code !== 'shopit'
|
||||
|| ($carousel !== null && ! $carousel->is_enabled)) {
|
||||
return;
|
||||
}
|
||||
|
||||
$definition = $this->websiteExtraService->definitionForTenant($tenant, 'carousel');
|
||||
$ids = [];
|
||||
$recrops = [];
|
||||
foreach ($data['banner_images'] as $item) {
|
||||
$image = is_array($item) ? $item['image'] : $item;
|
||||
$attachment = $this->existingImage($image, $carousel?->config ?? [], 'banner_images');
|
||||
$crops = $this->crops($item);
|
||||
|
||||
if ($attachment === null) {
|
||||
$attachment = $crops === null
|
||||
? $this->attachmentService->store($image, "tenants/{$tenant->codigo}/extras/carousel")
|
||||
: $this->attachmentService->storeCroppedImageVariants(
|
||||
$image, "tenants/{$tenant->codigo}/extras/carousel", $crops
|
||||
);
|
||||
$created[] = $attachment;
|
||||
} elseif ($crops !== null) {
|
||||
$recrops[] = [$attachment, $crops];
|
||||
}
|
||||
$ids[] = $attachment->id;
|
||||
}
|
||||
|
||||
$tenant->websiteExtras()->updateOrCreate(
|
||||
['website_type_extra_id' => $definition->id],
|
||||
['config' => $ids]
|
||||
);
|
||||
|
||||
foreach ($recrops as [$attachment, $crops]) {
|
||||
$this->attachmentService->updateImageCropVariants($attachment, $crops);
|
||||
}
|
||||
});
|
||||
} catch (Throwable $error) {
|
||||
foreach ($created as $attachment) {
|
||||
$paths = [$attachment->path];
|
||||
foreach ($attachment->cropVariants as $crop) {
|
||||
if ($crop->croppedAttachment !== null) {
|
||||
$paths[] = $crop->croppedAttachment->path;
|
||||
}
|
||||
}
|
||||
Storage::disk('s3')->delete($paths);
|
||||
}
|
||||
throw $error;
|
||||
}
|
||||
}
|
||||
|
||||
/** @param array<int, int> $allowedIds */
|
||||
private function existingImage(mixed $value, array $allowedIds, string $field): ?Attachment
|
||||
{
|
||||
if (! is_string($value) || ! Str::isUuid($value)) {
|
||||
return null;
|
||||
}
|
||||
|
||||
$attachment = Attachment::query()->where('key', $value)->first();
|
||||
if ($attachment === null || $attachment->type !== AttachmentType::Image
|
||||
|| ! in_array($attachment->id, $allowedIds, true)) {
|
||||
throw ValidationException::withMessages([$field => 'La imagen no pertenece a esta marca.']);
|
||||
}
|
||||
|
||||
return $attachment;
|
||||
}
|
||||
|
||||
/** @param array<int, Attachment> $created */
|
||||
private function logo(mixed $value, ?int $currentId, Tenant $tenant, array &$created): ?Attachment
|
||||
{
|
||||
if ($value === null) {
|
||||
return null;
|
||||
}
|
||||
|
||||
$existing = $this->existingImage($value, $currentId === null ? [] : [$currentId], 'logo');
|
||||
if ($existing !== null) {
|
||||
return $existing;
|
||||
}
|
||||
|
||||
$attachment = $this->attachmentService->store($value, "tenants/{$tenant->codigo}/logos");
|
||||
$created[] = $attachment;
|
||||
|
||||
return $attachment;
|
||||
}
|
||||
|
||||
/** @return array<string, array<string, mixed>>|null */
|
||||
private function crops(mixed $item): ?array
|
||||
{
|
||||
if (! is_array($item)) {
|
||||
return null;
|
||||
}
|
||||
|
||||
if (! isset($item['crop_horizontal'], $item['crop_vertical'])) {
|
||||
return null;
|
||||
}
|
||||
|
||||
$crop = [
|
||||
'crop_horizontal' => $item['crop_horizontal'],
|
||||
'crop_vertical' => $item['crop_vertical'],
|
||||
];
|
||||
|
||||
return ['desktop' => $crop, 'mobile' => $crop];
|
||||
}
|
||||
}
|
||||
73
app/Domains/Core/Tenant/Services/ContactService.php
Normal file
73
app/Domains/Core/Tenant/Services/ContactService.php
Normal file
@@ -0,0 +1,73 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Core\Tenant\Services;
|
||||
|
||||
use App\Domains\Core\Address\Models\Address;
|
||||
use App\Domains\Core\PhoneNumber\Models\PhoneNumber;
|
||||
use App\Domains\Core\Tenant\Models\Tenant;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
use Illuminate\Validation\ValidationException;
|
||||
|
||||
class ContactService
|
||||
{
|
||||
public function load(Tenant $tenant): Tenant
|
||||
{
|
||||
return $tenant->load([
|
||||
'socialMedia',
|
||||
'addresses' => fn ($query) => $query->reorder()->orderByPivot('is_main', 'desc')->orderByPivot('id'),
|
||||
'phoneNumbers',
|
||||
]);
|
||||
}
|
||||
|
||||
public function update(Tenant $tenant, array $data): Tenant
|
||||
{
|
||||
return DB::transaction(function () use ($tenant, $data): Tenant {
|
||||
// Serialize contact writes, including changes to the principal links.
|
||||
Tenant::query()->whereKey($tenant->id)->lockForUpdate()->firstOrFail();
|
||||
$social = [];
|
||||
foreach ($data['social_media'] as $index => $item) {
|
||||
$social[$item['code']] = ['url' => $item['url'], 'orden' => $index];
|
||||
}
|
||||
$tenant->socialMedia()->sync($social);
|
||||
|
||||
foreach (['addresses', 'phone_numbers'] as $collection) {
|
||||
$relation = $collection === 'addresses' ? $tenant->addresses() : $tenant->phoneNumbers();
|
||||
$existing = $relation->get()->keyBy('id');
|
||||
$links = [];
|
||||
foreach (array_values($data[$collection]) as $index => $item) {
|
||||
$id = $item['id'] ?? null;
|
||||
if ($id !== null && ! $existing->has($id)) {
|
||||
throw ValidationException::withMessages(["{$collection}.{$index}.id" => 'El contacto no pertenece al comercio.']);
|
||||
}
|
||||
$record = $id === null
|
||||
? ($collection === 'addresses' ? new Address : new PhoneNumber)
|
||||
: $existing->get($id);
|
||||
$attributes = collect($item)->except(['id', 'is_main'])->all();
|
||||
$record->fill($attributes);
|
||||
if (! $record->exists) {
|
||||
$record->label = $collection === 'addresses' ? 'Dirección' : 'Teléfono';
|
||||
}
|
||||
if ($record->exists && $record->isDirty()) {
|
||||
$shared = $record->tenants()->where('tenants.codigo', '!=', $tenant->codigo)->exists()
|
||||
|| ($record instanceof Address && $record->events()->exists());
|
||||
if ($shared) {
|
||||
$record = $record->replicate();
|
||||
}
|
||||
// An edited street address must not retain coordinates for the old location.
|
||||
if ($record instanceof Address && $record->isDirty('address_text')) {
|
||||
$record->latitude = null;
|
||||
$record->longitude = null;
|
||||
}
|
||||
}
|
||||
$record->save();
|
||||
$links[$record->id] = ['is_main' => $index === 0];
|
||||
}
|
||||
// Clear the previous principal before sync to respect the unique index.
|
||||
$relation->newPivotStatement()->where('tenant_codigo', $tenant->codigo)->update(['is_main' => false]);
|
||||
$relation->sync($links);
|
||||
}
|
||||
|
||||
return $this->load($tenant);
|
||||
});
|
||||
}
|
||||
}
|
||||
26
app/Domains/Core/Tenant/Services/TenantAddressService.php
Normal file
26
app/Domains/Core/Tenant/Services/TenantAddressService.php
Normal file
@@ -0,0 +1,26 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Core\Tenant\Services;
|
||||
|
||||
use App\Domains\Core\Address\Models\Address;
|
||||
use App\Domains\Core\Tenant\Models\Tenant;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
|
||||
class TenantAddressService
|
||||
{
|
||||
public function setMainAddress(Tenant $tenant, Address $address): void
|
||||
{
|
||||
DB::transaction(function () use ($tenant, $address): void {
|
||||
// Serialize changes for this tenant, including when it has no principal address yet.
|
||||
Tenant::query()->where('codigo', $tenant->codigo)->lockForUpdate()->firstOrFail();
|
||||
$tenant->addresses()->where('addresses.id', $address->id)->firstOrFail();
|
||||
|
||||
DB::table('tenant_addresses')->where('tenant_codigo', $tenant->codigo)
|
||||
->where('is_main', true)->update(['is_main' => false, 'updated_at' => now()]);
|
||||
$tenant->addresses()->updateExistingPivot($address->id, ['is_main' => true]);
|
||||
});
|
||||
|
||||
$tenant->unsetRelation('addresses');
|
||||
$tenant->unsetRelation('mainAddress');
|
||||
}
|
||||
}
|
||||
@@ -18,9 +18,14 @@ class TenantInformationService
|
||||
'footerBackgroundImage',
|
||||
'storefrontWebsiteType',
|
||||
'socialMedia',
|
||||
'addresses',
|
||||
'mainAddress',
|
||||
'phoneNumbers',
|
||||
'mainPhoneNumber',
|
||||
'websiteExtras.websiteTypeExtra',
|
||||
'activeEvent.dates',
|
||||
'activeEvent.socialMedia',
|
||||
'activeEvent.address',
|
||||
];
|
||||
|
||||
/**
|
||||
|
||||
@@ -12,6 +12,7 @@ Es la raíz del modelo multi-tenant. Gestiona organizaciones/sitios, tipos de we
|
||||
- `StorefrontWebsiteTypeExtra`: definición de un extra y su configuración admitida.
|
||||
- `WebsiteExtra`: valor resuelto y estado del extra para un tenant.
|
||||
- `SocialMedia`: catálogo de redes sociales asociables.
|
||||
- `phoneNumbers` y `mainPhoneNumber`: teléfonos públicos del tenant, definidos en el dominio `Core/PhoneNumber` y vinculados por `tenant_phone_numbers`. Solo un vínculo por tenant puede ser principal.
|
||||
|
||||
## Servicios
|
||||
|
||||
@@ -27,7 +28,16 @@ El par `(dominio, base_path)` es único. Un mismo dominio puede alojar el tenant
|
||||
- `GET /tenants`, `GET /tenants/{codigo}` y `DELETE /tenants/{codigo}`.
|
||||
- La creación y actualización general de tenants se administran mediante seeders o base de datos; no se exponen por API.
|
||||
- Bajo `/v1/adminapp/tenant/website-extras`, con autenticación y contexto de tenant: consulta general, detalle, actualización y activación/desactivación.
|
||||
- `GET /v1/adminapp/tenant/contact` y `PUT /v1/adminapp/tenant/contact`, con `auth:sanctum` y `adminapp.tenant`: consulta y reemplazo completo del contacto del comercio autenticado.
|
||||
|
||||
El PUT de contacto recibe `social_media` (`code`, `url`), `addresses` (`id` opcional para existentes, `address_text`) y `phone_numbers` (`id` opcional, `country_code`, `mobile_prefix`, `area_code`, `local_number`). Las tres colecciones son obligatorias; un array vacío elimina sus vínculos. El primer elemento enviado en cada lista de direcciones o teléfonos es siempre el principal: el backend calcula `is_main` por posición e ignora las marcas enviadas por clientes anteriores. GET y PUT devuelven el principal primero para conservarlo en el siguiente guardado. Los IDs existentes deben estar vinculados al comercio autenticado. Todos los cambios se realizan en una transacción, serializada por tenant, y la respuesta devuelve los registros persistidos y sus IDs.
|
||||
|
||||
Se conservan etiquetas y coordenadas de direcciones sin modificar; al cambiar el texto se limpian las coordenadas para evitar mostrar el mapa de una ubicación anterior. Las ediciones de registros compartidos crean una copia para el comercio, preservando otros comercios y eventos. Las bajas desvinculan registros sin borrar datos compartidos.
|
||||
|
||||
Contacto administra exclusivamente las redes del comercio. `TenantResource.tenant_social_media` siempre expone esas redes y alimenta Contacto y el footer públicos. `social_media` mantiene la selección histórica del evento activo; `event.social_media` sigue disponible para las vistas de evento. Guardar Contacto no modifica redes del evento.
|
||||
|
||||
## Dependencias y reglas
|
||||
|
||||
Usa `Attachable` para logos y archivos. Es referenciado por casi todos los dominios para aislamiento. El `codigo` es clave de ruta y clave foránea heredada; no debe sustituirse por `id` sin una migración integral.
|
||||
|
||||
Los resources exponen `phone_numbers` (incluye `is_main`) y `main_phone_number`, con `id`, `label`, `number` y `tel_url`. Contacto muestra la colección y el footer usa el principal. La migración copia primero `tenants.phone` como principal y luego el teléfono de `help.contact`, si es distinto; si no existe teléfono del tenant, el del menú pasa a ser principal. Los duplicados por formato se comparan dentro de cada tenant sin inferir país ni código de área. Los campos anteriores se conservan como datos legacy, pero la tienda consume las relaciones nuevas y el adminapp las edita mediante el endpoint de contacto.
|
||||
|
||||
@@ -1,11 +1,21 @@
|
||||
<?php
|
||||
|
||||
use App\Domains\Core\Tenant\Controllers\AdminApp\BrandController;
|
||||
use App\Domains\Core\Tenant\Controllers\AdminApp\ContactController;
|
||||
use App\Domains\Core\Tenant\Controllers\AdminApp\HelpMenuController;
|
||||
use App\Domains\Core\Tenant\Controllers\AdminApp\WebsiteExtraController;
|
||||
use Illuminate\Support\Facades\Route;
|
||||
|
||||
Route::prefix('v1/adminapp/tenant')
|
||||
->middleware(['auth:sanctum', 'adminapp.tenant'])
|
||||
->group(function (): void {
|
||||
Route::get('contact', [ContactController::class, 'show']);
|
||||
Route::put('contact', [ContactController::class, 'update']);
|
||||
Route::get('brand', [BrandController::class, 'show']);
|
||||
Route::put('brand', [BrandController::class, 'update']);
|
||||
Route::get('help-menus', [HelpMenuController::class, 'index']);
|
||||
Route::patch('help-menus/{menuCode}/toggle', [HelpMenuController::class, 'toggle']);
|
||||
Route::put('help-menus/{menuCode}/content', [HelpMenuController::class, 'updateContent']);
|
||||
Route::get('website-extras', [WebsiteExtraController::class, 'show']);
|
||||
Route::get('website-extras/{websiteExtraCode}', [WebsiteExtraController::class, 'showExtra']);
|
||||
Route::put('website-extras/{websiteExtraCode}', [WebsiteExtraController::class, 'update']);
|
||||
|
||||
@@ -2,6 +2,7 @@
|
||||
|
||||
namespace App\Domains\Ticketing\Desfile\Services;
|
||||
|
||||
use App\Domains\Commerce\Catalog\Models\Inventory;
|
||||
use DateTimeInterface;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
use Illuminate\Support\Facades\Hash;
|
||||
@@ -393,14 +394,22 @@ class InvitationPurchaseProvisioner
|
||||
|
||||
$inventory = DB::table('inventories')->where('id', $variant->inventory_id)->lockForUpdate()->first();
|
||||
|
||||
if ($inventory === null || $inventory->real_stock < 1 || $inventory->reserved_stock > 0 || ($inventory->entry_reserved_stock ?? 0) > 0) {
|
||||
$available = $inventory?->available_stock
|
||||
?? ($inventory === null ? 0 : $inventory->real_stock - $inventory->reserved_stock - ($inventory->entry_reserved_stock ?? 0));
|
||||
if ($available < 1) {
|
||||
throw new RuntimeException("El asiento {$variant->descripcion} ya no está disponible.");
|
||||
}
|
||||
|
||||
DB::table('inventories')->where('id', $inventory->id)->update([
|
||||
'real_stock' => $inventory->real_stock - 1,
|
||||
'sold_units' => $inventory->sold_units + 1,
|
||||
]);
|
||||
if (property_exists($inventory, 'available_stock')) {
|
||||
Inventory::query()->findOrFail($inventory->id)->commitDirectSale(1);
|
||||
} else {
|
||||
// This provisioner is also used by historical migrations that run
|
||||
// before generated availability and the movement ledger exist.
|
||||
DB::table('inventories')->where('id', $inventory->id)->update([
|
||||
'real_stock' => $inventory->real_stock - 1,
|
||||
'sold_units' => $inventory->sold_units + 1,
|
||||
]);
|
||||
}
|
||||
|
||||
$reservationId = DB::table('compras')->where('id', $purchaseId)->value('stock_reservation_id');
|
||||
if ($reservationId === null) {
|
||||
|
||||
@@ -5,28 +5,28 @@ use App\Domains\Ticketing\Desfile\Controllers\EntryReservationController;
|
||||
use Illuminate\Support\Facades\Route;
|
||||
|
||||
Route::get('v1/adminapp/tenant/desfile/entry-reservations', [EntryReservationController::class, 'index'])
|
||||
->middleware(['auth:sanctum', 'adminapp.tenant', 'tenant.menu:adminapp.desfile.reservas'])
|
||||
->middleware(['auth:sanctum', 'adminapp.tenant', 'tenant.menu:onticket.adminapp.desfile.reservas'])
|
||||
->name('adminapp.desfile.entry-reservations.index');
|
||||
Route::get('v1/adminapp/tenant/desfile/entry-reservations/pdf', [EntryReservationController::class, 'downloadPdf'])
|
||||
->middleware(['auth:sanctum', 'adminapp.tenant', 'tenant.menu:adminapp.desfile.reservas'])
|
||||
->middleware(['auth:sanctum', 'adminapp.tenant', 'tenant.menu:onticket.adminapp.desfile.reservas'])
|
||||
->name('adminapp.desfile.entry-reservations.pdf');
|
||||
Route::get('v1/adminapp/tenant/desfile/entry-reservations/excel', [EntryReservationController::class, 'downloadExcel'])
|
||||
->middleware(['auth:sanctum', 'adminapp.tenant', 'tenant.menu:adminapp.desfile.reservas'])
|
||||
->middleware(['auth:sanctum', 'adminapp.tenant', 'tenant.menu:onticket.adminapp.desfile.reservas'])
|
||||
->name('adminapp.desfile.entry-reservations.excel');
|
||||
Route::get('v1/adminapp/tenant/desfile/entry-reservations/{reservation}/ticket/pdf', [EntryReservationController::class, 'downloadTicketPdf'])
|
||||
->whereNumber('reservation')
|
||||
->middleware(['auth:sanctum', 'adminapp.tenant', 'tenant.menu:adminapp.desfile.reservas'])
|
||||
->middleware(['auth:sanctum', 'adminapp.tenant', 'tenant.menu:onticket.adminapp.desfile.reservas'])
|
||||
->name('adminapp.desfile.entry-reservations.ticket.pdf');
|
||||
Route::post('v1/adminapp/tenant/desfile/entry-reservations', [EntryReservationController::class, 'store'])
|
||||
->middleware(['auth:sanctum', 'adminapp.tenant', 'tenant.menu:adminapp.desfile.reservas'])
|
||||
->middleware(['auth:sanctum', 'adminapp.tenant', 'tenant.menu:onticket.adminapp.desfile.reservas'])
|
||||
->name('adminapp.desfile.entry-reservations.store');
|
||||
Route::delete('v1/adminapp/tenant/desfile/entry-reservations/{reservation}', [EntryReservationController::class, 'destroy'])
|
||||
->whereNumber('reservation')
|
||||
->middleware(['auth:sanctum', 'adminapp.tenant', 'tenant.menu:adminapp.desfile.reservas'])
|
||||
->middleware(['auth:sanctum', 'adminapp.tenant', 'tenant.menu:onticket.adminapp.desfile.reservas'])
|
||||
->name('adminapp.desfile.entry-reservations.destroy');
|
||||
|
||||
Route::prefix('v1/adminapp/tenant/desfile')
|
||||
->middleware(['auth:sanctum', 'adminapp.tenant', 'tenant.menu:adminapp.desfile.entradas'])
|
||||
->middleware(['auth:sanctum', 'adminapp.tenant', 'tenant.menu:onticket.adminapp.desfile.entradas'])
|
||||
->group(function (): void {
|
||||
Route::get('entries', [EntryController::class, 'show'])
|
||||
->name('adminapp.desfile.entries.show');
|
||||
|
||||
@@ -3,6 +3,7 @@
|
||||
namespace App\Domains\Ticketing\Event\Models;
|
||||
|
||||
use App\Domains\Commerce\Catalog\Models\CatalogItem;
|
||||
use App\Domains\Core\Address\Models\Address;
|
||||
use App\Domains\Core\Client\Models\Client;
|
||||
use App\Domains\Core\Tenant\Models\SocialMedia;
|
||||
use App\Domains\Core\Tenant\Models\Tenant;
|
||||
@@ -15,14 +16,14 @@ use Illuminate\Database\Eloquent\Relations\BelongsTo;
|
||||
use Illuminate\Database\Eloquent\Relations\BelongsToMany;
|
||||
use Illuminate\Database\Eloquent\Relations\HasMany;
|
||||
|
||||
#[Fillable(['client_id', 'tenant_code', 'slug', 'event_category_id', 'title', 'subtitle', 'description', 'location', 'exact_location', 'date_text', 'published_at', 'attachment_id'])]
|
||||
#[Fillable(['client_id', 'tenant_code', 'slug', 'event_category_id', 'title', 'subtitle', 'description', 'address_id', 'location', 'exact_location', 'date_text', 'published_at', 'attachment_id'])]
|
||||
class Event extends Model
|
||||
{
|
||||
use HasFactory;
|
||||
|
||||
protected function casts(): array
|
||||
{
|
||||
return ['client_id' => 'integer', 'published_at' => 'datetime', 'exact_location' => 'array'];
|
||||
return ['client_id' => 'integer', 'address_id' => 'integer', 'published_at' => 'datetime', 'exact_location' => 'array'];
|
||||
}
|
||||
|
||||
/** @return BelongsTo<Tenant, $this> */
|
||||
@@ -37,6 +38,12 @@ class Event extends Model
|
||||
return $this->belongsTo(Client::class);
|
||||
}
|
||||
|
||||
/** @return BelongsTo<Address, $this> */
|
||||
public function address(): BelongsTo
|
||||
{
|
||||
return $this->belongsTo(Address::class);
|
||||
}
|
||||
|
||||
public function effectiveClient(): Client
|
||||
{
|
||||
return $this->client ?? $this->tenant->client;
|
||||
|
||||
@@ -2,6 +2,7 @@
|
||||
|
||||
namespace App\Domains\Ticketing\Event\Resources;
|
||||
|
||||
use App\Domains\Core\Address\Resources\AddressResource;
|
||||
use App\Domains\Ticketing\Event\Models\Event;
|
||||
use App\Domains\Ticketing\Event\Services\EventDateGroupingService;
|
||||
use Illuminate\Http\Request;
|
||||
@@ -21,6 +22,7 @@ class EventResource extends JsonResource
|
||||
'title' => $this->title,
|
||||
'subtitle' => $this->subtitle,
|
||||
'description' => $this->description,
|
||||
'address' => AddressResource::make($this->address),
|
||||
'location' => $this->location,
|
||||
'exact_location' => $this->exact_location,
|
||||
'date_text' => $this->date_text,
|
||||
|
||||
@@ -5,6 +5,7 @@ namespace App\Domains\Ticketing\Event\Resources;
|
||||
use App\Domains\Commerce\Catalog\Enums\InventoryPolicy;
|
||||
use App\Domains\Commerce\Catalog\Models\CatalogItem;
|
||||
use App\Domains\Commerce\Catalog\Models\Variant;
|
||||
use App\Domains\Core\Address\Resources\AddressResource;
|
||||
use Illuminate\Http\Request;
|
||||
use Illuminate\Http\Resources\Json\JsonResource;
|
||||
|
||||
@@ -19,6 +20,7 @@ class PublicEventResource extends JsonResource
|
||||
'title' => $this->title,
|
||||
'subtitle' => $this->subtitle,
|
||||
'description' => $this->description,
|
||||
'address' => AddressResource::make($this->address),
|
||||
'location' => $this->location,
|
||||
'exact_location' => $this->exact_location,
|
||||
'date_text' => $this->date_text,
|
||||
|
||||
37
app/Domains/Ticketing/Event/Services/EventAddressService.php
Normal file
37
app/Domains/Ticketing/Event/Services/EventAddressService.php
Normal file
@@ -0,0 +1,37 @@
|
||||
<?php
|
||||
|
||||
namespace App\Domains\Ticketing\Event\Services;
|
||||
|
||||
use App\Domains\Core\Address\Models\Address;
|
||||
use App\Domains\Ticketing\Event\Models\Event;
|
||||
|
||||
class EventAddressService
|
||||
{
|
||||
/** Called inside the event update transaction, after validating the legacy location fields. */
|
||||
public function syncLocation(Event $event, bool $coordinatesProvided = false): void
|
||||
{
|
||||
$address = $event->address;
|
||||
$coordinates = $coordinatesProvided || $address === null ? $event->exact_location : $address->coordinates();
|
||||
$values = [
|
||||
'address_text' => $event->location,
|
||||
'latitude' => $coordinates['latitude'] ?? null,
|
||||
'longitude' => $coordinates['longitude'] ?? null,
|
||||
];
|
||||
|
||||
if ($address !== null && ! (clone $address)->fill($values)->isDirty()) {
|
||||
return;
|
||||
}
|
||||
|
||||
// Editing one event must not change the location of another event or a tenant.
|
||||
if ($address === null || $address->tenants()->exists()
|
||||
|| $address->events()->where('events.id', '!=', $event->id)->exists()) {
|
||||
$address = Address::create(['label' => $address?->label ?? 'Ubicación del evento', ...$values]);
|
||||
$event->address()->associate($address);
|
||||
$event->save();
|
||||
} else {
|
||||
$address->update($values);
|
||||
}
|
||||
|
||||
$event->setRelation('address', $address);
|
||||
}
|
||||
}
|
||||
@@ -2,18 +2,18 @@
|
||||
|
||||
namespace App\Domains\Ticketing\Event\Services;
|
||||
|
||||
use App\Domains\Core\Auth\Models\User;
|
||||
use App\Domains\Commerce\Cart\Services\InvalidateEventDateCartsService;
|
||||
use App\Domains\Commerce\Catalog\Models\Variant;
|
||||
use App\Domains\Commerce\Catalog\Services\StockReservationService;
|
||||
use App\Domains\Commerce\Catalog\Services\VariantReplacementService;
|
||||
use App\Domains\Core\Auth\Models\User;
|
||||
use App\Domains\Core\Tenant\Models\Tenant;
|
||||
use App\Domains\Ticketing\Event\Enums\EventDateChangeType;
|
||||
use App\Domains\Ticketing\Event\Events\EventDateRescheduled;
|
||||
use App\Domains\Ticketing\Event\Events\EventDateSuspended;
|
||||
use App\Domains\Ticketing\Event\Models\Event;
|
||||
use App\Domains\Ticketing\Event\Models\EventDate;
|
||||
use App\Domains\Ticketing\Event\Models\EventDateChange;
|
||||
use App\Domains\Ticketing\Event\Models\Event;
|
||||
use App\Domains\Core\Tenant\Models\Tenant;
|
||||
use App\Domains\Ticketing\Ticket\Models\Ticket;
|
||||
use Illuminate\Support\Collection;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
@@ -32,11 +32,12 @@ class EventService
|
||||
private readonly AffectedEventDatePurchaseResolver $affectedPurchaseResolver,
|
||||
private readonly VariantReplacementService $variantReplacementService,
|
||||
private readonly InvalidateEventDateCartsService $invalidateEventDateCarts,
|
||||
private readonly EventAddressService $eventAddressService,
|
||||
) {}
|
||||
|
||||
public function forTenant(Tenant $tenant): Event
|
||||
{
|
||||
return $tenant->activeEvent->load(['dates.validityTime', 'socialMedia']);
|
||||
return $tenant->activeEvent->load(['dates.validityTime', 'socialMedia', 'address']);
|
||||
}
|
||||
|
||||
/** @param array<string, mixed> $data */
|
||||
@@ -49,6 +50,7 @@ class EventService
|
||||
'location' => $data['location'],
|
||||
...array_intersect_key($data, ['attachment_id' => true, 'exact_location' => true]),
|
||||
]);
|
||||
$this->eventAddressService->syncLocation($event, array_key_exists('exact_location', $data));
|
||||
$tenant->update([
|
||||
...array_intersect_key($data, array_flip([
|
||||
'allow_ticket_refund',
|
||||
@@ -64,7 +66,7 @@ class EventService
|
||||
$this->syncLegacyContact($event, $data['contact']);
|
||||
}
|
||||
|
||||
return $event->load(['dates.validityTime', 'socialMedia']);
|
||||
return $event->load(['dates.validityTime', 'socialMedia', 'address']);
|
||||
});
|
||||
}
|
||||
|
||||
|
||||
@@ -23,11 +23,12 @@ class PublicEventService
|
||||
$query->where(function ($query) use ($term): void {
|
||||
$query->where('title', 'like', '%'.$term.'%')
|
||||
->orWhere('subtitle', 'like', '%'.$term.'%')
|
||||
->orWhere('location', 'like', '%'.$term.'%');
|
||||
->orWhereHas('address', fn ($query) => $query->where('address_text', 'like', '%'.$term.'%'))
|
||||
->orWhere(fn ($query) => $query->whereNull('address_id')->where('location', 'like', '%'.$term.'%'));
|
||||
});
|
||||
}
|
||||
|
||||
return $query->with('attachment')->orderByDesc('published_at')->orderByDesc('id')->paginate(15, ['*'], 'page', $page);
|
||||
return $query->with(['attachment', 'address'])->orderByDesc('published_at')->orderByDesc('id')->paginate(15, ['*'], 'page', $page);
|
||||
}
|
||||
|
||||
public function find(Tenant $tenant, Event $event): Event
|
||||
@@ -38,6 +39,7 @@ class PublicEventService
|
||||
|
||||
return $event->load([
|
||||
'attachment',
|
||||
'address',
|
||||
'dates' => fn ($query) => $query->whereNull('rescheduled_to_event_date_id')->whereNull('suspended_at'),
|
||||
'socialMedia',
|
||||
'catalogItems.attachments',
|
||||
|
||||
@@ -13,6 +13,32 @@ mediante `event_id`. El catálogo `social_media` define las plataformas;
|
||||
`exact_location` guarda opcionalmente un objeto JSON con `latitude` (-90 a 90)
|
||||
y `longitude` (-180 a 180). `location` sigue siendo la dirección legible.
|
||||
|
||||
`events.address_id` es una referencia opcional a `addresses.id`: `Event::address()`
|
||||
obtiene su dirección y `Address::events()` permite reutilizar una dirección en varios
|
||||
eventos. Al borrar una dirección, el vínculo queda en `NULL` y se conserva el evento.
|
||||
|
||||
La migración `2026_09_30_000200_add_address_id_to_events` agrega el vínculo.
|
||||
`2026_09_30_000300_copy_event_locations_to_addresses` copia `location` a
|
||||
`address_text` y las coordenadas de `exact_location` a `latitude` y `longitude`, con
|
||||
el label `Ubicación del evento`. Solo copia eventos sin `address_id` y con texto de
|
||||
ubicación; no modifica los campos ni los timestamps originales, ni vincula la
|
||||
dirección al tenant. Si faltan texto y coordenadas, el vínculo queda en `NULL`.
|
||||
Los datos inválidos, incluidas coordenadas sin texto de dirección, detienen la
|
||||
copia y revierten las inserciones para evitar una migración parcial. Las migraciones
|
||||
deben ejecutarse explícitamente por quien administra la base.
|
||||
|
||||
Las respuestas públicas, administrativas y el evento del bootstrap incluyen
|
||||
`address` con `id`, `label`, `address_text`, `latitude` y `longitude`. Las coordenadas
|
||||
se serializan como números o `null`. Los campos anteriores de la respuesta conservan
|
||||
sus valores originales; el frontend lee la ubicación y coordenadas desde `address`.
|
||||
El guardado administrativo de
|
||||
`location` y `exact_location` también actualiza `addresses`; si una dirección está
|
||||
compartida con otro evento o con un tenant, se crea una copia para el evento editado.
|
||||
El tenant devuelve `addresses` con `is_main` y `main_address`. El storefront usa
|
||||
todas las direcciones en contacto, la principal en el footer y la propia del evento
|
||||
en sus tarjetas, cabecera y mapa. Solo se agregan al mapa las direcciones con ambas
|
||||
coordenadas.
|
||||
|
||||
La migración `2026_09_18_000500_restore_events` crea un evento por cada tenant que
|
||||
tenía datos de evento o fechas, y migra las fechas y redes correspondientes.
|
||||
`2026_09_18_000600_associate_active_event_social_media` copia al evento activo las
|
||||
|
||||
@@ -28,6 +28,7 @@ class AccommodationController extends Controller
|
||||
$this->accommodationService->upsertMany(
|
||||
$tenant,
|
||||
$request->validated('variants'),
|
||||
$request->validated('stock_adjustment_id'),
|
||||
)
|
||||
);
|
||||
}
|
||||
|
||||
@@ -29,6 +29,7 @@ class EntryController extends Controller
|
||||
$entries = $this->entryService->upsertMany(
|
||||
$tenant,
|
||||
$request->validated('entries'),
|
||||
$request->validated('stock_adjustment_id'),
|
||||
);
|
||||
|
||||
return EntryResource::collection($entries)
|
||||
|
||||
@@ -29,6 +29,7 @@ class FoodController extends Controller
|
||||
$this->foodService->upsertMany(
|
||||
$tenant,
|
||||
$request->validated('variants'),
|
||||
$request->validated('stock_adjustment_id'),
|
||||
)
|
||||
);
|
||||
}
|
||||
@@ -39,6 +40,7 @@ class FoodController extends Controller
|
||||
$this->foodService->updateHistoricalStock(
|
||||
$request->user()->tenant()->firstOrFail(),
|
||||
$request->validated('variants'),
|
||||
$request->validated('stock_adjustment_id'),
|
||||
)
|
||||
);
|
||||
}
|
||||
|
||||
@@ -28,6 +28,7 @@ class MerchandiseController extends Controller
|
||||
$items = $this->merchandiseService->upsertMany(
|
||||
$tenant,
|
||||
$request->validated('items'),
|
||||
$request->validated('stock_adjustment_id'),
|
||||
);
|
||||
|
||||
return MerchandiseResource::collection($items)
|
||||
|
||||
@@ -16,9 +16,10 @@ class UpdateHistoricalFoodStockRequest extends FormRequest
|
||||
{
|
||||
return [
|
||||
'variants' => ['required', 'array', 'min:1', 'max:500'],
|
||||
'variants.*' => ['required', 'array:id,stock'],
|
||||
'stock_adjustment_id' => ['nullable', 'uuid'],
|
||||
'variants.*' => ['required', 'array:id,stock_difference'],
|
||||
'variants.*.id' => ['required', 'integer', 'distinct'],
|
||||
'variants.*.stock' => ['required', 'integer', 'min:0'],
|
||||
'variants.*.stock_difference' => ['required', 'integer'],
|
||||
];
|
||||
}
|
||||
}
|
||||
|
||||
@@ -3,6 +3,7 @@
|
||||
namespace App\Domains\Ticketing\FiestaFutbolInfantil\Requests;
|
||||
|
||||
use Illuminate\Foundation\Http\FormRequest;
|
||||
use Illuminate\Validation\Validator;
|
||||
|
||||
class UpsertAccommodationVariantsRequest extends FormRequest
|
||||
{
|
||||
@@ -16,12 +17,42 @@ class UpsertAccommodationVariantsRequest extends FormRequest
|
||||
{
|
||||
return [
|
||||
'variants' => ['required', 'array', 'min:1', 'max:500'],
|
||||
'variants.*' => ['required', 'array:id,title,description,stock,price'],
|
||||
'stock_adjustment_id' => ['nullable', 'uuid'],
|
||||
'variants.*' => ['required', 'array:id,title,description,stock,stock_difference,price'],
|
||||
'variants.*.id' => ['sometimes', 'nullable', 'integer', 'distinct'],
|
||||
'variants.*.title' => ['required', 'string', 'max:255'],
|
||||
'variants.*.description' => ['sometimes', 'nullable', 'string'],
|
||||
'variants.*.stock' => ['required', 'integer', 'min:0'],
|
||||
'variants.*.stock' => ['sometimes', 'integer', 'min:0'],
|
||||
'variants.*.stock_difference' => ['sometimes', 'integer'],
|
||||
'variants.*.price' => ['required', 'numeric', 'min:0', 'max:99999999.99'],
|
||||
];
|
||||
}
|
||||
|
||||
/** @return array<int, callable> */
|
||||
public function after(): array
|
||||
{
|
||||
return [
|
||||
function (Validator $validator): void {
|
||||
foreach ($this->input('variants', []) as $index => $variant) {
|
||||
if (! is_array($variant)) {
|
||||
continue;
|
||||
}
|
||||
|
||||
if (isset($variant['id']) && ! array_key_exists('stock_difference', $variant)) {
|
||||
$validator->errors()->add(
|
||||
"variants.{$index}.stock_difference",
|
||||
'La diferencia de stock es obligatoria al actualizar una variante.',
|
||||
);
|
||||
}
|
||||
|
||||
if (! isset($variant['id']) && ! array_key_exists('stock', $variant)) {
|
||||
$validator->errors()->add(
|
||||
"variants.{$index}.stock",
|
||||
'El stock inicial es obligatorio al crear una variante.',
|
||||
);
|
||||
}
|
||||
}
|
||||
},
|
||||
];
|
||||
}
|
||||
}
|
||||
|
||||
@@ -20,7 +20,8 @@ class UpsertEntriesRequest extends FormRequest
|
||||
|
||||
return [
|
||||
'entries' => ['required', 'array', 'min:1', 'max:100'],
|
||||
'entries.*' => ['required', 'array:id,title,description,event_date_ids,stock,price'],
|
||||
'stock_adjustment_id' => ['nullable', 'uuid'],
|
||||
'entries.*' => ['required', 'array:id,title,description,event_date_ids,stock,stock_difference,price'],
|
||||
'entries.*.id' => [
|
||||
'sometimes',
|
||||
'nullable',
|
||||
@@ -46,7 +47,8 @@ class UpsertEntriesRequest extends FormRequest
|
||||
fn ($query) => $query->where('tenant_code', $tenantCode)
|
||||
),
|
||||
],
|
||||
'entries.*.stock' => ['required', 'integer', 'min:0'],
|
||||
'entries.*.stock' => ['sometimes', 'integer', 'min:0'],
|
||||
'entries.*.stock_difference' => ['sometimes', 'integer'],
|
||||
'entries.*.price' => ['required', 'numeric', 'min:0', 'max:99999999.99'],
|
||||
];
|
||||
}
|
||||
@@ -61,6 +63,20 @@ class UpsertEntriesRequest extends FormRequest
|
||||
continue;
|
||||
}
|
||||
|
||||
if (isset($entry['id']) && ! array_key_exists('stock_difference', $entry)) {
|
||||
$validator->errors()->add(
|
||||
"entries.{$index}.stock_difference",
|
||||
'La diferencia de stock es obligatoria al actualizar una entrada.',
|
||||
);
|
||||
}
|
||||
|
||||
if (! isset($entry['id']) && ! array_key_exists('stock', $entry)) {
|
||||
$validator->errors()->add(
|
||||
"entries.{$index}.stock",
|
||||
'El stock inicial es obligatorio al crear una entrada.',
|
||||
);
|
||||
}
|
||||
|
||||
$dateIds = $entry['event_date_ids'] ?? [];
|
||||
|
||||
if (! is_array($dateIds)) {
|
||||
|
||||
@@ -20,7 +20,8 @@ class UpsertFoodVariantsRequest extends FormRequest
|
||||
|
||||
return [
|
||||
'variants' => ['required', 'array', 'min:1', 'max:500'],
|
||||
'variants.*' => ['required', 'array:id,event_date_id,schedule,service,description,stock,price'],
|
||||
'stock_adjustment_id' => ['nullable', 'uuid'],
|
||||
'variants.*' => ['required', 'array:id,event_date_id,schedule,service,description,stock,stock_difference,price'],
|
||||
'variants.*.id' => ['sometimes', 'nullable', 'integer', 'distinct'],
|
||||
'variants.*.event_date_id' => [
|
||||
'required',
|
||||
@@ -32,7 +33,8 @@ class UpsertFoodVariantsRequest extends FormRequest
|
||||
'variants.*.schedule' => ['required', 'string', 'max:255'],
|
||||
'variants.*.service' => ['required', 'string', 'max:255'],
|
||||
'variants.*.description' => ['sometimes', 'nullable', 'string'],
|
||||
'variants.*.stock' => ['required', 'integer', 'min:0'],
|
||||
'variants.*.stock' => ['sometimes', 'integer', 'min:0'],
|
||||
'variants.*.stock_difference' => ['sometimes', 'integer'],
|
||||
'variants.*.price' => ['required', 'numeric', 'min:0', 'max:99999999.99'],
|
||||
];
|
||||
}
|
||||
@@ -49,6 +51,20 @@ class UpsertFoodVariantsRequest extends FormRequest
|
||||
continue;
|
||||
}
|
||||
|
||||
if (isset($variant['id']) && ! array_key_exists('stock_difference', $variant)) {
|
||||
$validator->errors()->add(
|
||||
"variants.{$index}.stock_difference",
|
||||
'La diferencia de stock es obligatoria al actualizar una variante.',
|
||||
);
|
||||
}
|
||||
|
||||
if (! isset($variant['id']) && ! array_key_exists('stock', $variant)) {
|
||||
$validator->errors()->add(
|
||||
"variants.{$index}.stock",
|
||||
'El stock inicial es obligatorio al crear una variante.',
|
||||
);
|
||||
}
|
||||
|
||||
$key = implode('|', [
|
||||
$variant['event_date_id'] ?? '',
|
||||
mb_strtolower(trim((string) ($variant['schedule'] ?? ''))),
|
||||
|
||||
@@ -4,6 +4,7 @@ namespace App\Domains\Ticketing\FiestaFutbolInfantil\Requests;
|
||||
|
||||
use Illuminate\Foundation\Http\FormRequest;
|
||||
use Illuminate\Validation\Rule;
|
||||
use Illuminate\Validation\Validator;
|
||||
|
||||
class UpsertMerchandiseRequest extends FormRequest
|
||||
{
|
||||
@@ -39,12 +40,49 @@ class UpsertMerchandiseRequest extends FormRequest
|
||||
'items.*.description' => ['sometimes', 'nullable', 'string'],
|
||||
'items.*.max_units_per_user' => ['required', 'integer', 'min:1'],
|
||||
'items.*.variants' => ['required', 'array', 'min:1', 'max:500'],
|
||||
'items.*.variants.*' => ['required', 'array:id,color,size,stock,price'],
|
||||
'stock_adjustment_id' => ['nullable', 'uuid'],
|
||||
'items.*.variants.*' => ['required', 'array:id,color,size,stock,stock_difference,price'],
|
||||
'items.*.variants.*.id' => ['sometimes', 'nullable', 'integer', 'distinct'],
|
||||
'items.*.variants.*.color' => ['required', 'string', 'max:255'],
|
||||
'items.*.variants.*.size' => ['required', 'string', 'max:255'],
|
||||
'items.*.variants.*.stock' => ['required', 'integer', 'min:0'],
|
||||
'items.*.variants.*.stock' => ['sometimes', 'integer', 'min:0'],
|
||||
'items.*.variants.*.stock_difference' => ['sometimes', 'integer'],
|
||||
'items.*.variants.*.price' => ['required', 'numeric', 'min:0', 'max:99999999.99'],
|
||||
];
|
||||
}
|
||||
|
||||
/** @return array<int, callable> */
|
||||
public function after(): array
|
||||
{
|
||||
return [
|
||||
function (Validator $validator): void {
|
||||
foreach ($this->input('items', []) as $itemIndex => $item) {
|
||||
if (! is_array($item)) {
|
||||
continue;
|
||||
}
|
||||
|
||||
foreach ($item['variants'] ?? [] as $variantIndex => $variant) {
|
||||
if (! is_array($variant)) {
|
||||
continue;
|
||||
}
|
||||
|
||||
$prefix = "items.{$itemIndex}.variants.{$variantIndex}";
|
||||
if (isset($variant['id']) && ! array_key_exists('stock_difference', $variant)) {
|
||||
$validator->errors()->add(
|
||||
"{$prefix}.stock_difference",
|
||||
'La diferencia de stock es obligatoria al actualizar una variante.',
|
||||
);
|
||||
}
|
||||
|
||||
if (! isset($variant['id']) && ! array_key_exists('stock', $variant)) {
|
||||
$validator->errors()->add(
|
||||
"{$prefix}.stock",
|
||||
'El stock inicial es obligatorio al crear una variante.',
|
||||
);
|
||||
}
|
||||
}
|
||||
}
|
||||
},
|
||||
];
|
||||
}
|
||||
}
|
||||
|
||||
@@ -37,7 +37,7 @@ class AccommodationResource extends JsonResource
|
||||
'title' => $options->get($value)?->label ?? $value,
|
||||
'value' => $value,
|
||||
'description' => $variant->descripcion,
|
||||
'stock' => $variant->inventory->real_stock,
|
||||
'stock' => $variant->inventory->availableStock(),
|
||||
'price' => number_format($variant->getPrice(), 2, '.', ''),
|
||||
];
|
||||
})->values(),
|
||||
|
||||
@@ -33,7 +33,7 @@ class EntryResource extends JsonResource
|
||||
'title' => $this->nombre,
|
||||
'description' => $this->descripcion,
|
||||
'event_date_ids' => $variant->selectedEventDates()->pluck('id')->values(),
|
||||
'stock' => $variant->inventory->real_stock,
|
||||
'stock' => $variant->inventory->availableStock(),
|
||||
'price' => $this->precio,
|
||||
];
|
||||
}
|
||||
|
||||
@@ -81,7 +81,7 @@ class FoodResource extends JsonResource
|
||||
'schedule' => $values->get('horario'),
|
||||
'service' => $values->get('servicio'),
|
||||
'description' => $variant->descripcion,
|
||||
'stock' => $variant->inventory->real_stock,
|
||||
'stock' => $variant->inventory->availableStock(),
|
||||
'price' => number_format($variant->getPrice(), 2, '.', ''),
|
||||
];
|
||||
}
|
||||
|
||||
@@ -44,7 +44,7 @@ class MerchandiseResource extends JsonResource
|
||||
'color_value' => $colorValue,
|
||||
'size' => $sizeOptions->get($sizeValue)?->label ?? $sizeValue,
|
||||
'size_value' => $sizeValue,
|
||||
'stock' => $variant->inventory->real_stock,
|
||||
'stock' => $variant->inventory->availableStock(),
|
||||
'price' => number_format($variant->getPrice(), 2, '.', ''),
|
||||
];
|
||||
})->values(),
|
||||
|
||||
@@ -39,9 +39,9 @@ class AccommodationService
|
||||
/**
|
||||
* @param array<int, array<string, mixed>> $variants
|
||||
*/
|
||||
public function upsertMany(Tenant $tenant, array $variants): CatalogItem
|
||||
public function upsertMany(Tenant $tenant, array $variants, ?string $stockAdjustmentId = null): CatalogItem
|
||||
{
|
||||
return DB::transaction(function () use ($tenant, $variants): CatalogItem {
|
||||
return DB::transaction(function () use ($tenant, $variants, $stockAdjustmentId): CatalogItem {
|
||||
$attribute = $this->attribute($tenant);
|
||||
$accommodation = $this->accommodation($tenant, $variants);
|
||||
$itemAttribute = $accommodation->itemAttributes()->firstOrCreate(
|
||||
@@ -70,7 +70,7 @@ class AccommodationService
|
||||
if ($variant === null) {
|
||||
$this->createVariant($attribute, $accommodation, $itemAttribute, $data);
|
||||
} else {
|
||||
$this->updateVariant($attribute, $variant, $itemAttribute, $data, $index);
|
||||
$this->updateVariant($attribute, $variant, $itemAttribute, $data, $index, $stockAdjustmentId);
|
||||
}
|
||||
}
|
||||
|
||||
@@ -169,7 +169,7 @@ class AccommodationService
|
||||
'title' => trim($variant['title']),
|
||||
'value' => $this->valueCode($variant['title']),
|
||||
'description' => $variant['description'] ?? null,
|
||||
'stock' => (int) $variant['stock'],
|
||||
...(array_key_exists('stock', $variant) ? ['stock' => (int) $variant['stock']] : []),
|
||||
])->all();
|
||||
}
|
||||
|
||||
@@ -212,6 +212,7 @@ class AccommodationService
|
||||
$this->createOption($attribute, $data['value'], $data['title']);
|
||||
|
||||
$inventory = Inventory::query()->create(['real_stock' => $data['stock']]);
|
||||
$inventory->recordInitialization();
|
||||
$variant = $accommodation->variants()->create([
|
||||
'inventory_id' => $inventory->id,
|
||||
'descripcion' => $data['description'],
|
||||
@@ -230,20 +231,13 @@ class AccommodationService
|
||||
ItemAttribute $itemAttribute,
|
||||
array $data,
|
||||
int $index,
|
||||
?string $stockAdjustmentId,
|
||||
): void {
|
||||
$inventory = Inventory::query()
|
||||
->whereKey($variant->inventory_id)
|
||||
->lockForUpdate()
|
||||
->firstOrFail();
|
||||
|
||||
if ($data['stock'] < $inventory->reserved_stock) {
|
||||
throw ValidationException::withMessages([
|
||||
"variants.{$index}.stock" => [
|
||||
'El stock no puede ser menor que la cantidad actualmente reservada.',
|
||||
],
|
||||
]);
|
||||
}
|
||||
|
||||
$definition = $variant->definitions
|
||||
->firstWhere('item_attribute_id', $itemAttribute->id);
|
||||
$option = $definition === null
|
||||
@@ -263,7 +257,10 @@ class AccommodationService
|
||||
'descripcion' => $data['description'],
|
||||
'precio' => $data['price'],
|
||||
]);
|
||||
$inventory->update(['real_stock' => $data['stock']]);
|
||||
$inventory->adjustAvailableStock(
|
||||
(int) $data['stock_difference'],
|
||||
idempotencyKey: $stockAdjustmentId,
|
||||
);
|
||||
$variant->definitions()->updateOrCreate(
|
||||
['item_attribute_id' => $itemAttribute->id],
|
||||
['value' => $data['value']],
|
||||
|
||||
@@ -43,18 +43,18 @@ class EntryService
|
||||
* @param array<int, array<string, mixed>> $entries
|
||||
* @return Collection<int, CatalogItem>
|
||||
*/
|
||||
public function upsertMany(Tenant $tenant, array $entries): Collection
|
||||
public function upsertMany(Tenant $tenant, array $entries, ?string $stockAdjustmentId = null): Collection
|
||||
{
|
||||
return DB::transaction(function () use ($tenant, $entries): Collection {
|
||||
return DB::transaction(function () use ($tenant, $entries, $stockAdjustmentId): Collection {
|
||||
$reservedSlugs = [];
|
||||
$category = Category::query()->firstOrCreate([
|
||||
'tenant_code' => $tenant->codigo,
|
||||
'nombre' => 'Entradas',
|
||||
]);
|
||||
|
||||
return collect($entries)->map(function (array $entry, int $index) use ($tenant, $category, &$reservedSlugs): CatalogItem {
|
||||
return collect($entries)->map(function (array $entry, int $index) use ($tenant, $category, $stockAdjustmentId, &$reservedSlugs): CatalogItem {
|
||||
if (isset($entry['id'])) {
|
||||
return $this->update($tenant, $category, $entry, $index);
|
||||
return $this->update($tenant, $category, $entry, $index, $stockAdjustmentId);
|
||||
}
|
||||
|
||||
$slug = $this->uniqueSlug($tenant, $entry['title'], $reservedSlugs);
|
||||
@@ -92,7 +92,7 @@ class EntryService
|
||||
}
|
||||
|
||||
/** @param array<string, mixed> $entry */
|
||||
private function update(Tenant $tenant, Category $category, array $entry, int $index): CatalogItem
|
||||
private function update(Tenant $tenant, Category $category, array $entry, int $index, ?string $stockAdjustmentId): CatalogItem
|
||||
{
|
||||
$catalogItem = CatalogItem::query()
|
||||
->whereKey($entry['id'])
|
||||
@@ -121,14 +121,6 @@ class EntryService
|
||||
->lockForUpdate()
|
||||
->firstOrFail();
|
||||
|
||||
if ((int) $entry['stock'] < $inventory->reserved_stock) {
|
||||
throw ValidationException::withMessages([
|
||||
"entries.{$index}.stock" => [
|
||||
'El stock no puede ser menor que la cantidad actualmente reservada.',
|
||||
],
|
||||
]);
|
||||
}
|
||||
|
||||
$eventDateIds = collect($entry['event_date_ids'])
|
||||
->map(fn ($id): int => (int) $id)
|
||||
->unique()
|
||||
@@ -149,7 +141,10 @@ class EntryService
|
||||
$catalogItem->itemAttributes()
|
||||
->whereHas('attribute', fn ($query) => $query->where('codigo', 'event_date'))
|
||||
->update(['allow_multi_select' => true]);
|
||||
$inventory->update(['real_stock' => $entry['stock']]);
|
||||
$inventory->adjustAvailableStock(
|
||||
(int) $entry['stock_difference'],
|
||||
idempotencyKey: $stockAdjustmentId,
|
||||
);
|
||||
|
||||
return $catalogItem->load([
|
||||
'variants.inventory',
|
||||
|
||||
@@ -11,9 +11,9 @@ use App\Domains\Commerce\Catalog\Models\Inventory;
|
||||
use App\Domains\Commerce\Catalog\Models\ItemAttribute;
|
||||
use App\Domains\Commerce\Catalog\Models\Variant;
|
||||
use App\Domains\Commerce\Catalog\Services\CatalogService;
|
||||
use App\Domains\Core\Tenant\Models\Tenant;
|
||||
use App\Domains\Ticketing\Event\Enums\EventDateStatus;
|
||||
use App\Domains\Ticketing\Event\Models\EventDate;
|
||||
use App\Domains\Core\Tenant\Models\Tenant;
|
||||
use Illuminate\Support\Collection;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
use Illuminate\Validation\ValidationException;
|
||||
@@ -50,9 +50,9 @@ class FoodService
|
||||
/**
|
||||
* @param array<int, array<string, mixed>> $variants
|
||||
*/
|
||||
public function upsertMany(Tenant $tenant, array $variants): CatalogItem
|
||||
public function upsertMany(Tenant $tenant, array $variants, ?string $stockAdjustmentId = null): CatalogItem
|
||||
{
|
||||
return DB::transaction(function () use ($tenant, $variants): CatalogItem {
|
||||
return DB::transaction(function () use ($tenant, $variants, $stockAdjustmentId): CatalogItem {
|
||||
$attributes = $this->attributes($tenant);
|
||||
$food = $this->food($tenant, $variants);
|
||||
$itemAttributes = $this->itemAttributes($food, $attributes);
|
||||
@@ -85,7 +85,7 @@ class FoodService
|
||||
if ($variant === null) {
|
||||
$this->createVariant($food, $itemAttributes, $data);
|
||||
} else {
|
||||
$this->updateVariant($variant, $itemAttributes, $data, $index);
|
||||
$this->updateVariant($variant, $itemAttributes, $data, $index, $stockAdjustmentId);
|
||||
}
|
||||
}
|
||||
|
||||
@@ -113,11 +113,11 @@ class FoodService
|
||||
}
|
||||
|
||||
/**
|
||||
* @param array<int, array{id: int, stock: int}> $variants
|
||||
* @param array<int, array{id: int, stock_difference: int}> $variants
|
||||
*/
|
||||
public function updateHistoricalStock(Tenant $tenant, array $variants): CatalogItem
|
||||
public function updateHistoricalStock(Tenant $tenant, array $variants, ?string $stockAdjustmentId = null): CatalogItem
|
||||
{
|
||||
return DB::transaction(function () use ($tenant, $variants): CatalogItem {
|
||||
return DB::transaction(function () use ($tenant, $variants, $stockAdjustmentId): CatalogItem {
|
||||
$food = CatalogItem::query()
|
||||
->forTenantCatalog($tenant)
|
||||
->where('slug', 'comida')
|
||||
@@ -142,17 +142,11 @@ class FoodService
|
||||
]);
|
||||
}
|
||||
|
||||
$stock = (int) $data['stock'];
|
||||
$inventory = $this->inventoryForHistoricalStockUpdate($variant);
|
||||
if ($stock < $inventory->reserved_stock) {
|
||||
throw ValidationException::withMessages([
|
||||
"variants.{$index}.stock" => [
|
||||
'El stock no puede ser menor que la cantidad actualmente reservada.',
|
||||
],
|
||||
]);
|
||||
}
|
||||
|
||||
$inventory->update(['real_stock' => $stock]);
|
||||
$inventory->adjustAvailableStock(
|
||||
(int) $data['stock_difference'],
|
||||
idempotencyKey: $stockAdjustmentId,
|
||||
);
|
||||
}
|
||||
|
||||
return $this->current($tenant) ?? $food;
|
||||
@@ -181,6 +175,7 @@ class FoodService
|
||||
'reserved_stock' => 0,
|
||||
'real_stock' => $inventory->real_stock,
|
||||
]);
|
||||
$historicalInventory->recordTransferInitialization();
|
||||
$variant->update(['inventory_id' => $historicalInventory->getKey()]);
|
||||
|
||||
return $historicalInventory;
|
||||
@@ -301,7 +296,7 @@ class FoodService
|
||||
'schedule' => $schedule->value,
|
||||
'service' => $service->value,
|
||||
'description' => (string) ($variant['description'] ?? ''),
|
||||
'stock' => (int) $variant['stock'],
|
||||
...(array_key_exists('stock', $variant) ? ['stock' => (int) $variant['stock']] : []),
|
||||
];
|
||||
})->all();
|
||||
}
|
||||
@@ -384,6 +379,7 @@ class FoodService
|
||||
private function createVariant(CatalogItem $food, Collection $itemAttributes, array $data): void
|
||||
{
|
||||
$inventory = Inventory::query()->create(['real_stock' => $data['stock']]);
|
||||
$inventory->recordInitialization();
|
||||
$variant = $food->variants()->create([
|
||||
'event_date_id' => $data['event_date_id'],
|
||||
'inventory_id' => $inventory->id,
|
||||
@@ -400,27 +396,23 @@ class FoodService
|
||||
Collection $itemAttributes,
|
||||
array $data,
|
||||
int $index,
|
||||
?string $stockAdjustmentId,
|
||||
): void {
|
||||
$inventory = Inventory::query()
|
||||
->whereKey($variant->inventory_id)
|
||||
->lockForUpdate()
|
||||
->firstOrFail();
|
||||
|
||||
if ($data['stock'] < $inventory->reserved_stock) {
|
||||
throw ValidationException::withMessages([
|
||||
"variants.{$index}.stock" => [
|
||||
'El stock no puede ser menor que la cantidad actualmente reservada.',
|
||||
],
|
||||
]);
|
||||
}
|
||||
|
||||
$variant->update([
|
||||
'event_date_id' => $data['event_date_id'],
|
||||
'descripcion' => $data['description'],
|
||||
'precio' => $data['price'],
|
||||
]);
|
||||
$variant->eventDates()->sync([$data['event_date_id']]);
|
||||
$inventory->update(['real_stock' => $data['stock']]);
|
||||
$inventory->adjustAvailableStock(
|
||||
(int) $data['stock_difference'],
|
||||
idempotencyKey: $stockAdjustmentId,
|
||||
);
|
||||
$this->syncDefinitions($variant, $itemAttributes, $data);
|
||||
}
|
||||
|
||||
|
||||
@@ -43,9 +43,9 @@ class MerchandiseService
|
||||
* @param array<int, array<string, mixed>> $items
|
||||
* @return Collection<int, CatalogItem>
|
||||
*/
|
||||
public function upsertMany(Tenant $tenant, array $items): Collection
|
||||
public function upsertMany(Tenant $tenant, array $items, ?string $stockAdjustmentId = null): Collection
|
||||
{
|
||||
return DB::transaction(function () use ($tenant, $items): Collection {
|
||||
return DB::transaction(function () use ($tenant, $items, $stockAdjustmentId): Collection {
|
||||
$attributes = $this->attributes($tenant);
|
||||
$category = Category::query()->firstOrCreate([
|
||||
'tenant_code' => $tenant->codigo,
|
||||
@@ -57,6 +57,7 @@ class MerchandiseService
|
||||
$tenant,
|
||||
$attributes,
|
||||
$category,
|
||||
$stockAdjustmentId,
|
||||
&$reservedSlugs,
|
||||
): CatalogItem {
|
||||
$item = isset($data['id'])
|
||||
@@ -101,7 +102,7 @@ class MerchandiseService
|
||||
if ($variant === null) {
|
||||
$this->createVariant($item, $itemAttributes, $variantData);
|
||||
} else {
|
||||
$this->updateVariant($variant, $itemAttributes, $variantData, $index, $variantIndex);
|
||||
$this->updateVariant($variant, $itemAttributes, $variantData, $index, $variantIndex, $stockAdjustmentId);
|
||||
}
|
||||
}
|
||||
|
||||
@@ -244,7 +245,7 @@ class MerchandiseService
|
||||
...$variant,
|
||||
'color' => $color->value,
|
||||
'size' => $size->value,
|
||||
'stock' => (int) $variant['stock'],
|
||||
...(array_key_exists('stock', $variant) ? ['stock' => (int) $variant['stock']] : []),
|
||||
];
|
||||
})->all();
|
||||
}
|
||||
@@ -342,6 +343,7 @@ class MerchandiseService
|
||||
array $data,
|
||||
): void {
|
||||
$inventory = Inventory::query()->create(['real_stock' => $data['stock']]);
|
||||
$inventory->recordInitialization();
|
||||
$variant = $item->variants()->create([
|
||||
'inventory_id' => $inventory->id,
|
||||
'precio' => $data['price'],
|
||||
@@ -359,22 +361,18 @@ class MerchandiseService
|
||||
array $data,
|
||||
int $itemIndex,
|
||||
int $variantIndex,
|
||||
?string $stockAdjustmentId,
|
||||
): void {
|
||||
$inventory = Inventory::query()
|
||||
->whereKey($variant->inventory_id)
|
||||
->lockForUpdate()
|
||||
->firstOrFail();
|
||||
|
||||
if ($data['stock'] < $inventory->reserved_stock) {
|
||||
throw ValidationException::withMessages([
|
||||
"items.{$itemIndex}.variants.{$variantIndex}.stock" => [
|
||||
'El stock no puede ser menor que la cantidad actualmente reservada.',
|
||||
],
|
||||
]);
|
||||
}
|
||||
|
||||
$variant->update(['precio' => $data['price']]);
|
||||
$inventory->update(['real_stock' => $data['stock']]);
|
||||
$inventory->adjustAvailableStock(
|
||||
(int) $data['stock_difference'],
|
||||
idempotencyKey: $stockAdjustmentId,
|
||||
);
|
||||
$this->syncDefinitions($variant, $itemAttributes, $data);
|
||||
}
|
||||
|
||||
|
||||
@@ -19,48 +19,48 @@ Route::prefix('v1/adminapp/tenant')
|
||||
->middleware("tenant.menu:{$menuCode}");
|
||||
};
|
||||
|
||||
$visibilityRoutes('entries', 'entries', 'adminapp.fiesta-futbol-infantil.entradas');
|
||||
$visibilityRoutes('foods', 'foods', 'adminapp.fiesta-futbol-infantil.comida');
|
||||
$visibilityRoutes('accommodations', 'accommodations', 'adminapp.fiesta-futbol-infantil.alojamientos');
|
||||
$visibilityRoutes('merchandise', 'merchandise', 'adminapp.fiesta-futbol-infantil.merchandising');
|
||||
$visibilityRoutes('entries', 'entries', 'onticket.adminapp.fiesta-futbol-infantil.entradas');
|
||||
$visibilityRoutes('foods', 'foods', 'onticket.adminapp.fiesta-futbol-infantil.comida');
|
||||
$visibilityRoutes('accommodations', 'accommodations', 'onticket.adminapp.fiesta-futbol-infantil.alojamientos');
|
||||
$visibilityRoutes('merchandise', 'merchandise', 'onticket.adminapp.fiesta-futbol-infantil.merchandising');
|
||||
|
||||
Route::get('entries', [EntryController::class, 'index'])
|
||||
->middleware('tenant.menu:adminapp.fiesta-futbol-infantil.entradas')
|
||||
->middleware('tenant.menu:onticket.adminapp.fiesta-futbol-infantil.entradas')
|
||||
->name('adminapp.fiesta-futbol-infantil.entries.index');
|
||||
Route::post('entries', [EntryController::class, 'store'])
|
||||
->middleware('tenant.menu:adminapp.fiesta-futbol-infantil.entradas')
|
||||
->middleware('tenant.menu:onticket.adminapp.fiesta-futbol-infantil.entradas')
|
||||
->name('adminapp.fiesta-futbol-infantil.entries.store');
|
||||
Route::delete('entries/{entry}', [EntryController::class, 'destroy'])
|
||||
->middleware('tenant.menu:adminapp.fiesta-futbol-infantil.entradas')
|
||||
->middleware('tenant.menu:onticket.adminapp.fiesta-futbol-infantil.entradas')
|
||||
->name('adminapp.fiesta-futbol-infantil.entries.destroy');
|
||||
Route::get('foods', [FoodController::class, 'index'])
|
||||
->middleware('tenant.menu:adminapp.fiesta-futbol-infantil.comida')
|
||||
->middleware('tenant.menu:onticket.adminapp.fiesta-futbol-infantil.comida')
|
||||
->name('adminapp.fiesta-futbol-infantil.foods.index');
|
||||
Route::post('foods', [FoodController::class, 'store'])
|
||||
->middleware('tenant.menu:adminapp.fiesta-futbol-infantil.comida')
|
||||
->middleware('tenant.menu:onticket.adminapp.fiesta-futbol-infantil.comida')
|
||||
->name('adminapp.fiesta-futbol-infantil.foods.store');
|
||||
Route::patch('foods/history-stock', [FoodController::class, 'updateHistoricalStock'])
|
||||
->middleware('tenant.menu:adminapp.fiesta-futbol-infantil.comida')
|
||||
->middleware('tenant.menu:onticket.adminapp.fiesta-futbol-infantil.comida')
|
||||
->name('adminapp.fiesta-futbol-infantil.foods.history-stock.update');
|
||||
Route::delete('foods/{food}', [FoodController::class, 'destroy'])
|
||||
->middleware('tenant.menu:adminapp.fiesta-futbol-infantil.comida')
|
||||
->middleware('tenant.menu:onticket.adminapp.fiesta-futbol-infantil.comida')
|
||||
->name('adminapp.fiesta-futbol-infantil.foods.destroy');
|
||||
Route::get('accommodations', [AccommodationController::class, 'index'])
|
||||
->middleware('tenant.menu:adminapp.fiesta-futbol-infantil.alojamientos')
|
||||
->middleware('tenant.menu:onticket.adminapp.fiesta-futbol-infantil.alojamientos')
|
||||
->name('adminapp.fiesta-futbol-infantil.accommodations.index');
|
||||
Route::post('accommodations', [AccommodationController::class, 'store'])
|
||||
->middleware('tenant.menu:adminapp.fiesta-futbol-infantil.alojamientos')
|
||||
->middleware('tenant.menu:onticket.adminapp.fiesta-futbol-infantil.alojamientos')
|
||||
->name('adminapp.fiesta-futbol-infantil.accommodations.store');
|
||||
Route::delete('accommodations/{accommodation}', [AccommodationController::class, 'destroy'])
|
||||
->middleware('tenant.menu:adminapp.fiesta-futbol-infantil.alojamientos')
|
||||
->middleware('tenant.menu:onticket.adminapp.fiesta-futbol-infantil.alojamientos')
|
||||
->name('adminapp.fiesta-futbol-infantil.accommodations.destroy');
|
||||
Route::get('merchandise', [MerchandiseController::class, 'index'])
|
||||
->middleware('tenant.menu:adminapp.fiesta-futbol-infantil.merchandising')
|
||||
->middleware('tenant.menu:onticket.adminapp.fiesta-futbol-infantil.merchandising')
|
||||
->name('adminapp.fiesta-futbol-infantil.merchandise.index');
|
||||
Route::post('merchandise', [MerchandiseController::class, 'store'])
|
||||
->middleware('tenant.menu:adminapp.fiesta-futbol-infantil.merchandising')
|
||||
->middleware('tenant.menu:onticket.adminapp.fiesta-futbol-infantil.merchandising')
|
||||
->name('adminapp.fiesta-futbol-infantil.merchandise.store');
|
||||
Route::delete('merchandise/{merchandise}', [MerchandiseController::class, 'destroy'])
|
||||
->middleware('tenant.menu:adminapp.fiesta-futbol-infantil.merchandising')
|
||||
->middleware('tenant.menu:onticket.adminapp.fiesta-futbol-infantil.merchandising')
|
||||
->name('adminapp.fiesta-futbol-infantil.merchandise.destroy');
|
||||
});
|
||||
|
||||
@@ -225,13 +225,13 @@ class AdminAppTicketService
|
||||
'amount' => number_format($refundAmount, 2, '.', ''),
|
||||
]);
|
||||
|
||||
$this->restoreInventory($ticket, $purchaseItem);
|
||||
$this->restoreInventory($ticket, $purchaseItem, $createdBy);
|
||||
|
||||
return $ticket->refresh()->load(self::RELATIONS);
|
||||
});
|
||||
}
|
||||
|
||||
private function restoreInventory(Ticket $ticket, PurchaseItem $purchaseItem): void
|
||||
private function restoreInventory(Ticket $ticket, PurchaseItem $purchaseItem, ?User $createdBy): void
|
||||
{
|
||||
$catalogItem = $ticket->sourceCatalogItem;
|
||||
if ($catalogItem === null) {
|
||||
@@ -269,11 +269,7 @@ class AdminAppTicketService
|
||||
throw ValidationException::withMessages(['ticket' => 'No se encontró el inventario del ticket.']);
|
||||
}
|
||||
|
||||
if ($catalogItem->inventory_policy === InventoryPolicy::Tracked) {
|
||||
$inventory->real_stock++;
|
||||
}
|
||||
$inventory->refunded_units++;
|
||||
$inventory->save();
|
||||
$inventory->refundStock(1, $createdBy);
|
||||
}
|
||||
|
||||
private function refundedAmountForPurchaseItem(PurchaseItem $purchaseItem): float
|
||||
|
||||
@@ -2,6 +2,7 @@
|
||||
|
||||
namespace App\Domains\Ticketing\Ticket\Services;
|
||||
|
||||
use App\Domains\Commerce\Catalog\Models\Inventory;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
use Illuminate\Support\Facades\Log;
|
||||
use RuntimeException;
|
||||
@@ -64,14 +65,9 @@ class BackfillRefundedUnitsService
|
||||
}, 'refunds.id', 'id');
|
||||
|
||||
foreach ($counts as $inventoryId => $count) {
|
||||
$updates = ['refunded_units' => DB::raw('refunded_units + '.$count['refunded'])];
|
||||
if (($count['stock'] ?? 0) > 0) {
|
||||
$updates['real_stock'] = DB::raw('real_stock + '.$count['stock']);
|
||||
}
|
||||
|
||||
if (DB::table('inventories')->where('id', $inventoryId)->update($updates) !== 1) {
|
||||
throw new RuntimeException("No se encontró el inventario {$inventoryId} para reponerlo.");
|
||||
}
|
||||
$inventory = Inventory::query()->lockForUpdate()->find($inventoryId)
|
||||
?? throw new RuntimeException("No se encontró el inventario {$inventoryId} para reponerlo.");
|
||||
$inventory->refundStock($count['refunded']);
|
||||
}
|
||||
|
||||
$refundedUnitsAdded = array_sum(array_column($counts, 'refunded'));
|
||||
@@ -82,7 +78,8 @@ class BackfillRefundedUnitsService
|
||||
'bundles_skipped' => $bundlesSkipped,
|
||||
'inventories_updated' => count($counts),
|
||||
'refunded_units_added' => $refundedUnitsAdded,
|
||||
'real_stock_added' => array_sum(array_column($counts, 'stock')),
|
||||
'real_stock_added' => 0,
|
||||
'available_stock_added' => $refundedUnitsAdded,
|
||||
];
|
||||
});
|
||||
|
||||
|
||||
@@ -82,7 +82,7 @@ Bajo `/tenants/{tenant:codigo}`, protegidos por `auth:sanctum`:
|
||||
- `POST /tickets/pdf`.
|
||||
|
||||
Bajo `/v1/adminapp/tenant`, protegido por `auth:sanctum`, `adminapp.tenant` y el menú
|
||||
`adminapp.tickets`:
|
||||
`onticket.adminapp.tickets`:
|
||||
|
||||
- `GET /tickets`, paginado y con búsqueda opcional mediante `q`. La respuesta incluye
|
||||
`scanned_tickets` y `total_tickets` para el tenant autenticado.
|
||||
|
||||
@@ -7,24 +7,24 @@ Route::prefix('v1/adminapp/tenant')
|
||||
->middleware(['auth:sanctum', 'adminapp.tenant'])
|
||||
->group(function (): void {
|
||||
Route::get('tickets', [TicketController::class, 'index'])
|
||||
->middleware('tenant.menu:adminapp.tickets')
|
||||
->middleware('tenant.menu:onticket.adminapp.tickets')
|
||||
->name('adminapp.tickets.index');
|
||||
Route::post('tickets/{ticket}/cancel', [TicketController::class, 'cancel'])
|
||||
->whereNumber('ticket')
|
||||
->middleware('tenant.menu:adminapp.tickets')
|
||||
->middleware('tenant.menu:onticket.adminapp.tickets')
|
||||
->name('adminapp.tickets.cancel');
|
||||
Route::get('tickets/{ticket}/refund', [TicketController::class, 'calculateRefund'])
|
||||
->whereNumber('ticket')
|
||||
->middleware('tenant.menu:adminapp.tickets')
|
||||
->middleware('tenant.menu:onticket.adminapp.tickets')
|
||||
->name('adminapp.tickets.calculate-refund');
|
||||
Route::post('tickets/{ticket}/refund', [TicketController::class, 'refund'])
|
||||
->whereNumber('ticket')
|
||||
->middleware('tenant.menu:adminapp.tickets')
|
||||
->middleware('tenant.menu:onticket.adminapp.tickets')
|
||||
->name('adminapp.tickets.refund');
|
||||
Route::get('tickets/pdf', [TicketController::class, 'downloadPdf'])
|
||||
->middleware('tenant.menu:adminapp.tickets')
|
||||
->middleware('tenant.menu:onticket.adminapp.tickets')
|
||||
->name('adminapp.tickets.pdf');
|
||||
Route::get('tickets/excel', [TicketController::class, 'downloadExcel'])
|
||||
->middleware('tenant.menu:adminapp.tickets')
|
||||
->middleware('tenant.menu:onticket.adminapp.tickets')
|
||||
->name('adminapp.tickets.excel');
|
||||
});
|
||||
|
||||
@@ -13,6 +13,9 @@ class EnsureTenantHasMenu
|
||||
$tenant = $request->user()?->tenant()->first();
|
||||
$hasMenu = $tenant?->menues()
|
||||
->where('menues.code', $menuCode)
|
||||
->where(fn ($query) => $query
|
||||
->where('menues.code', 'help.contact')
|
||||
->orWhere('tenants_menues.is_enabled', true))
|
||||
->exists() ?? false;
|
||||
|
||||
abort_unless($hasMenu, 404);
|
||||
|
||||
@@ -18,12 +18,12 @@ Route::prefix('v1/adminapp/forms')
|
||||
Route::get(
|
||||
'desfile/entry-reservation',
|
||||
DesfileEntryReservationFormController::class
|
||||
)->middleware('tenant.menu:adminapp.desfile.reservas')
|
||||
)->middleware('tenant.menu:onticket.adminapp.desfile.reservas')
|
||||
->name('adminapp.forms.desfile.entry-reservation');
|
||||
Route::get('sale', SaleFormController::class);
|
||||
Route::get('staff', StaffFormController::class);
|
||||
Route::get('tickets-filter', TicketFilterFormController::class)
|
||||
->middleware('tenant.menu:adminapp.tickets')
|
||||
->middleware('tenant.menu:onticket.adminapp.tickets')
|
||||
->name('adminapp.forms.tickets-filter');
|
||||
Route::get(
|
||||
'fiesta-futbol-infantil/ticket',
|
||||
|
||||
@@ -41,7 +41,7 @@ return new class extends Migration
|
||||
return;
|
||||
}
|
||||
|
||||
$sourcePath = public_path('images/website_types/'.self::FILENAME);
|
||||
$sourcePath = public_path('images/website_types/onticket/'.self::FILENAME);
|
||||
|
||||
if (! is_file($sourcePath)) {
|
||||
throw new RuntimeException("Favicon not found at path: {$sourcePath}");
|
||||
|
||||
@@ -0,0 +1,89 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Database\Schema\Blueprint;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
public $withinTransaction = false;
|
||||
|
||||
private const FORMULA = 'CAST(real_stock AS SIGNED) - CAST(sold_units AS SIGNED) - CAST(reserved_stock AS SIGNED) - CAST(entry_reserved_stock AS SIGNED) + CAST(refunded_units AS SIGNED)';
|
||||
|
||||
public function up(): void
|
||||
{
|
||||
$conversion = 'CAST(real_stock AS SIGNED) + CAST(sold_units AS SIGNED) - CAST(refunded_units AS SIGNED)';
|
||||
$this->assertNonNegative($conversion, 'la conversión produciría un stock real negativo');
|
||||
$this->assertNonNegative(
|
||||
"({$conversion}) - CAST(sold_units AS SIGNED) - CAST(reserved_stock AS SIGNED) - CAST(entry_reserved_stock AS SIGNED) + CAST(refunded_units AS SIGNED)",
|
||||
'el stock disponible actual es negativo',
|
||||
);
|
||||
|
||||
if (DB::getDriverName() === 'sqlite') {
|
||||
Schema::table('inventories', function (Blueprint $table): void {
|
||||
$table->bigInteger('available_stock')->virtualAs(self::FORMULA);
|
||||
});
|
||||
DB::table('inventories')->update(['real_stock' => DB::raw($conversion)]);
|
||||
} else {
|
||||
Schema::table('inventories', function (Blueprint $table): void {
|
||||
$table->unsignedBigInteger('real_stock')->default(0)->change();
|
||||
$table->bigInteger('available_stock')->storedAs(self::FORMULA);
|
||||
});
|
||||
DB::table('inventories')->update(['real_stock' => DB::raw($conversion)]);
|
||||
}
|
||||
}
|
||||
|
||||
public function down(): void
|
||||
{
|
||||
$conversion = 'CAST(real_stock AS SIGNED) - CAST(sold_units AS SIGNED) + CAST(refunded_units AS SIGNED)';
|
||||
$this->assertNonNegative($conversion, 'el rollback produciría un stock real negativo');
|
||||
|
||||
if (DB::getDriverName() === 'sqlite') {
|
||||
DB::table('inventories')->update(['real_stock' => DB::raw($conversion)]);
|
||||
Schema::table('inventories', fn (Blueprint $table) => $table->dropColumn('available_stock'));
|
||||
|
||||
return;
|
||||
}
|
||||
|
||||
DB::table('inventories')->update(['real_stock' => DB::raw($conversion)]);
|
||||
Schema::table('inventories', fn (Blueprint $table) => $table->dropColumn('available_stock'));
|
||||
}
|
||||
|
||||
private function assertNonNegative(string $expression, string $reason): void
|
||||
{
|
||||
$invalidInventories = DB::table('inventories')
|
||||
->select([
|
||||
'id',
|
||||
'real_stock',
|
||||
'sold_units',
|
||||
'refunded_units',
|
||||
'reserved_stock',
|
||||
'entry_reserved_stock',
|
||||
])
|
||||
->selectRaw("({$expression}) as calculated_stock")
|
||||
->whereRaw("({$expression}) < 0")
|
||||
->orderBy('id')
|
||||
->limit(20)
|
||||
->get();
|
||||
|
||||
if ($invalidInventories->isNotEmpty()) {
|
||||
$details = $invalidInventories
|
||||
->map(static fn (object $inventory): string => sprintf(
|
||||
'id=%d [real=%d, vendidas=%d, reintegradas=%d, reservadas=%d, reservas_entradas=%d, resultado=%d]',
|
||||
$inventory->id,
|
||||
$inventory->real_stock,
|
||||
$inventory->sold_units,
|
||||
$inventory->refunded_units,
|
||||
$inventory->reserved_stock,
|
||||
$inventory->entry_reserved_stock,
|
||||
$inventory->calculated_stock,
|
||||
))
|
||||
->implode('; ');
|
||||
|
||||
throw new RuntimeException(
|
||||
"Hay inventarios inconsistentes: {$reason}. Inventarios detectados (máximo 20): {$details}."
|
||||
);
|
||||
}
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,33 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Database\Schema\Blueprint;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
public function up(): void
|
||||
{
|
||||
Schema::create('inventory_movements', function (Blueprint $table): void {
|
||||
$table->id();
|
||||
$table->foreignId('inventory_id')->constrained('inventories')->restrictOnDelete();
|
||||
$table->string('operation', 40);
|
||||
$table->bigInteger('available_stock_delta');
|
||||
$table->bigInteger('available_stock_before');
|
||||
$table->bigInteger('available_stock_after');
|
||||
$table->json('counter_deltas');
|
||||
$table->foreignId('responsible_user_id')->nullable()->constrained('users')->restrictOnDelete();
|
||||
$table->uuid('idempotency_key')->nullable();
|
||||
$table->timestamps();
|
||||
|
||||
$table->unique(['inventory_id', 'idempotency_key']);
|
||||
$table->index(['inventory_id', 'created_at']);
|
||||
$table->index(['operation', 'created_at']);
|
||||
});
|
||||
}
|
||||
|
||||
public function down(): void
|
||||
{
|
||||
Schema::dropIfExists('inventory_movements');
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,47 @@
|
||||
<?php
|
||||
|
||||
use App\Domains\Core\Tenant\Models\AdminWebsiteType;
|
||||
use App\Domains\Core\Tenant\Services\AdminWebsiteTypeService;
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Http\UploadedFile;
|
||||
use Illuminate\Support\Facades\Storage;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
public function up(): void
|
||||
{
|
||||
if (app()->environment('testing')) {
|
||||
Storage::fake('s3');
|
||||
}
|
||||
|
||||
if (! AdminWebsiteType::query()->where('codigo', 'shopit')->exists()) {
|
||||
return;
|
||||
}
|
||||
|
||||
app(AdminWebsiteTypeService::class)->updateOrCreate(
|
||||
['codigo' => 'shopit'],
|
||||
[
|
||||
'primary_color' => '#2FD3AC',
|
||||
'site_logo' => $this->uploadedImage('shopit_logo.png', 'image/png'),
|
||||
'footer_logo' => $this->uploadedImage('shopit_footer_logo.png', 'image/png'),
|
||||
'favicon' => $this->uploadedImage('shopit-favicon.svg', 'image/svg+xml'),
|
||||
],
|
||||
);
|
||||
}
|
||||
|
||||
public function down(): void
|
||||
{
|
||||
// Brand assets are operational data and are intentionally preserved.
|
||||
}
|
||||
|
||||
private function uploadedImage(string $filename, string $mimeType): UploadedFile
|
||||
{
|
||||
$path = public_path("images/website_types/shopit/{$filename}");
|
||||
|
||||
if (! is_file($path)) {
|
||||
throw new RuntimeException("ShopIt image not found at path: {$path}");
|
||||
}
|
||||
|
||||
return new UploadedFile($path, $filename, $mimeType, null, true);
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,236 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
private const ONTICKET_MENUS = [
|
||||
'adminapp.event' => ['onticket.adminapp.event', 'Eventos', '/admin/event'],
|
||||
'adminapp.inicio' => ['onticket.adminapp.inicio', 'Inicio', '/admin/inicio'],
|
||||
'adminapp.catalog' => ['onticket.adminapp.catalog', 'Catálogo', '/admin/catalog'],
|
||||
'adminapp.combos' => ['onticket.adminapp.combos', 'Combos', '/admin/combos'],
|
||||
'adminapp.categories' => ['onticket.adminapp.categories', 'Categorías', '/admin/categories'],
|
||||
'adminapp.ventas' => ['onticket.adminapp.ventas', 'Ventas', '/admin/ventas'],
|
||||
'adminapp.staff' => ['onticket.adminapp.staff', 'Usuarios', '/admin/staff'],
|
||||
'adminapp.tickets' => ['onticket.adminapp.tickets', 'Tickets', '/admin/tickets'],
|
||||
'adminapp.fiesta-futbol-infantil.entradas' => [
|
||||
'onticket.adminapp.fiesta-futbol-infantil.entradas',
|
||||
'Entradas',
|
||||
'/admin/entradas',
|
||||
],
|
||||
'adminapp.fiesta-futbol-infantil.alojamientos' => [
|
||||
'onticket.adminapp.fiesta-futbol-infantil.alojamientos',
|
||||
'Alojamientos',
|
||||
'/admin/alojamientos',
|
||||
],
|
||||
'adminapp.fiesta-futbol-infantil.merchandising' => [
|
||||
'onticket.adminapp.fiesta-futbol-infantil.merchandising',
|
||||
'Merchandising',
|
||||
'/admin/merchandising',
|
||||
],
|
||||
'adminapp.fiesta-futbol-infantil.comida' => [
|
||||
'onticket.adminapp.fiesta-futbol-infantil.comida',
|
||||
'Comida',
|
||||
'/admin/comidas',
|
||||
],
|
||||
'adminapp.desfile.entradas' => [
|
||||
'onticket.adminapp.desfile.entradas',
|
||||
'Entradas',
|
||||
'/admin/desfile/entradas',
|
||||
],
|
||||
'adminapp.desfile.reservas' => [
|
||||
'onticket.adminapp.desfile.reservas',
|
||||
'Reserva de Tickets',
|
||||
'/admin/desfile/reservas',
|
||||
],
|
||||
];
|
||||
|
||||
private const SHOPIT_MENUS = [
|
||||
'shopit.adminapp.marca' => ['Marca', '/admin/marca'],
|
||||
'shopit.adminapp.contacto' => ['Contacto', '/admin/contacto'],
|
||||
'shopit.adminapp.productos' => ['Productos', '/admin/productos'],
|
||||
'shopit.adminapp.categorias' => ['Categorías', '/admin/categorias'],
|
||||
'shopit.adminapp.transacciones' => ['Transacciones', '/admin/transacciones'],
|
||||
'shopit.adminapp.reportes' => ['Reportes', '/admin/reportes'],
|
||||
'shopit.adminapp.usuarios_roles' => ['Usuarios y roles', '/admin/usuarios-roles'],
|
||||
];
|
||||
|
||||
private const LEGACY_SHOPIT_ADMIN_MENUS = [
|
||||
'adminapp.event',
|
||||
'adminapp.inicio',
|
||||
'adminapp.catalog',
|
||||
'adminapp.combos',
|
||||
'adminapp.categories',
|
||||
'adminapp.ventas',
|
||||
'adminapp.staff',
|
||||
];
|
||||
|
||||
public function up(): void
|
||||
{
|
||||
DB::transaction(function (): void {
|
||||
if (! DB::table('menues')->where('code', 'main.adminapp')->exists()) {
|
||||
return;
|
||||
}
|
||||
|
||||
foreach (self::ONTICKET_MENUS as $legacyCode => [$code, $label, $route]) {
|
||||
$this->replaceMenuCode($legacyCode, $code, $label, $route);
|
||||
$this->assignMenuToAdminRoles($code);
|
||||
}
|
||||
|
||||
foreach (self::SHOPIT_MENUS as $code => [$label, $route]) {
|
||||
$this->upsertMenu($code, $label, $route);
|
||||
$this->assignMenuToAdminRoles($code);
|
||||
}
|
||||
|
||||
$shopItTenantCodes = DB::table('tenants')
|
||||
->where('admin_website_type_code', 'shopit')
|
||||
->pluck('codigo');
|
||||
|
||||
if ($shopItTenantCodes->isEmpty()) {
|
||||
return;
|
||||
}
|
||||
|
||||
$adminMenuCodes = DB::table('menues')
|
||||
->where('parent_menu_code', 'main.adminapp')
|
||||
->pluck('code');
|
||||
|
||||
DB::table('tenants_menues')
|
||||
->whereIn('tenant_code', $shopItTenantCodes)
|
||||
->whereIn('menu_code', $adminMenuCodes)
|
||||
->delete();
|
||||
|
||||
foreach ($shopItTenantCodes as $tenantCode) {
|
||||
$this->assignMenuToTenant($tenantCode, 'main.adminapp');
|
||||
|
||||
foreach (array_keys(self::SHOPIT_MENUS) as $menuCode) {
|
||||
$this->assignMenuToTenant($tenantCode, $menuCode);
|
||||
}
|
||||
}
|
||||
});
|
||||
}
|
||||
|
||||
public function down(): void
|
||||
{
|
||||
DB::transaction(function (): void {
|
||||
if (! DB::table('menues')->where('code', 'main.adminapp')->exists()) {
|
||||
return;
|
||||
}
|
||||
|
||||
$shopItTenantCodes = DB::table('tenants')
|
||||
->where('admin_website_type_code', 'shopit')
|
||||
->pluck('codigo');
|
||||
|
||||
DB::table('tenants_menues')
|
||||
->whereIn('tenant_code', $shopItTenantCodes)
|
||||
->whereIn('menu_code', array_keys(self::SHOPIT_MENUS))
|
||||
->delete();
|
||||
DB::table('roles_menues')
|
||||
->whereIn('menu_codigo', array_keys(self::SHOPIT_MENUS))
|
||||
->delete();
|
||||
DB::table('menues')
|
||||
->whereIn('code', array_keys(self::SHOPIT_MENUS))
|
||||
->delete();
|
||||
|
||||
foreach (self::ONTICKET_MENUS as $legacyCode => [$code, $label, $route]) {
|
||||
$this->replaceMenuCode($code, $legacyCode, $label, $route);
|
||||
}
|
||||
|
||||
foreach ($shopItTenantCodes as $tenantCode) {
|
||||
foreach (self::LEGACY_SHOPIT_ADMIN_MENUS as $menuCode) {
|
||||
$this->assignMenuToTenant($tenantCode, $menuCode);
|
||||
}
|
||||
}
|
||||
});
|
||||
}
|
||||
|
||||
private function replaceMenuCode(
|
||||
string $sourceCode,
|
||||
string $targetCode,
|
||||
string $label,
|
||||
string $route,
|
||||
): void {
|
||||
$source = DB::table('menues')->where('code', $sourceCode)->first();
|
||||
|
||||
$this->upsertMenu($targetCode, $label, $route, $source);
|
||||
|
||||
if ($source === null) {
|
||||
return;
|
||||
}
|
||||
|
||||
DB::table('tenants_menues')
|
||||
->where('menu_code', $sourceCode)
|
||||
->get()
|
||||
->each(function (object $assignment) use ($targetCode): void {
|
||||
DB::table('tenants_menues')->updateOrInsert(
|
||||
[
|
||||
'tenant_code' => $assignment->tenant_code,
|
||||
'menu_code' => $targetCode,
|
||||
],
|
||||
[
|
||||
'static_content' => $assignment->static_content,
|
||||
'created_at' => $assignment->created_at ?? now(),
|
||||
'updated_at' => now(),
|
||||
],
|
||||
);
|
||||
});
|
||||
|
||||
DB::table('roles_menues')
|
||||
->where('menu_codigo', $sourceCode)
|
||||
->pluck('rol_codigo')
|
||||
->each(fn (string $roleCode) => DB::table('roles_menues')->updateOrInsert([
|
||||
'rol_codigo' => $roleCode,
|
||||
'menu_codigo' => $targetCode,
|
||||
]));
|
||||
|
||||
DB::table('tenants_menues')->where('menu_code', $sourceCode)->delete();
|
||||
DB::table('roles_menues')->where('menu_codigo', $sourceCode)->delete();
|
||||
DB::table('menues')->where('code', $sourceCode)->delete();
|
||||
}
|
||||
|
||||
private function upsertMenu(
|
||||
string $code,
|
||||
string $label,
|
||||
string $route,
|
||||
?object $source = null,
|
||||
): void {
|
||||
DB::table('menues')->updateOrInsert(
|
||||
['code' => $code],
|
||||
[
|
||||
'label' => $source->label ?? $label,
|
||||
'parent_menu_code' => 'main.adminapp',
|
||||
'content_type' => $source->content_type ?? 'dynamic',
|
||||
'static_content_schema' => $source->static_content_schema ?? null,
|
||||
'route' => $source->route ?? $route,
|
||||
'created_at' => $source->created_at ?? now(),
|
||||
'updated_at' => now(),
|
||||
],
|
||||
);
|
||||
}
|
||||
|
||||
private function assignMenuToAdminRoles(string $menuCode): void
|
||||
{
|
||||
DB::table('roles')
|
||||
->whereIn('codigo', ['admin', 'adminapp'])
|
||||
->pluck('codigo')
|
||||
->each(fn (string $roleCode) => DB::table('roles_menues')->updateOrInsert([
|
||||
'rol_codigo' => $roleCode,
|
||||
'menu_codigo' => $menuCode,
|
||||
]));
|
||||
}
|
||||
|
||||
private function assignMenuToTenant(string $tenantCode, string $menuCode): void
|
||||
{
|
||||
DB::table('tenants_menues')->updateOrInsert(
|
||||
[
|
||||
'tenant_code' => $tenantCode,
|
||||
'menu_code' => $menuCode,
|
||||
],
|
||||
[
|
||||
'static_content' => null,
|
||||
'created_at' => now(),
|
||||
'updated_at' => now(),
|
||||
],
|
||||
);
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,22 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Database\Schema\Blueprint;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
public function up(): void
|
||||
{
|
||||
Schema::table('tenants_menues', function (Blueprint $table): void {
|
||||
$table->boolean('is_enabled')->default(true);
|
||||
});
|
||||
}
|
||||
|
||||
public function down(): void
|
||||
{
|
||||
Schema::table('tenants_menues', function (Blueprint $table): void {
|
||||
$table->dropColumn('is_enabled');
|
||||
});
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,29 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
public function up(): void
|
||||
{
|
||||
DB::table('menues')
|
||||
->where('code', 'help.terms-and-conditions')
|
||||
->update([
|
||||
'content_type' => 'static',
|
||||
'static_content_schema' => json_encode([
|
||||
'html' => 'present|nullable|string',
|
||||
], JSON_THROW_ON_ERROR),
|
||||
]);
|
||||
}
|
||||
|
||||
public function down(): void
|
||||
{
|
||||
DB::table('menues')
|
||||
->where('code', 'help.terms-and-conditions')
|
||||
->update([
|
||||
'content_type' => 'dynamic',
|
||||
'static_content_schema' => null,
|
||||
]);
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,57 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Database\Schema\Blueprint;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
public function up(): void
|
||||
{
|
||||
$driver = DB::connection()->getDriverName();
|
||||
|
||||
if (! in_array($driver, ['mysql', 'mariadb', 'sqlite', 'pgsql', 'sqlsrv'], true)) {
|
||||
throw new RuntimeException("Unsupported address database driver: {$driver}");
|
||||
}
|
||||
|
||||
Schema::create('addresses', function (Blueprint $table): void {
|
||||
$table->id();
|
||||
$table->string('label');
|
||||
$table->text('address_text');
|
||||
$table->decimal('latitude', 10, 7)->nullable();
|
||||
$table->decimal('longitude', 10, 7)->nullable();
|
||||
$table->timestamps();
|
||||
});
|
||||
|
||||
Schema::create('tenant_addresses', function (Blueprint $table) use ($driver): void {
|
||||
$table->id();
|
||||
$table->string('tenant_codigo');
|
||||
$table->foreignId('address_id')->constrained('addresses')->cascadeOnDelete();
|
||||
$table->boolean('is_main')->default(false);
|
||||
$table->timestamps();
|
||||
|
||||
$table->foreign('tenant_codigo')->references('codigo')->on('tenants')->cascadeOnDelete();
|
||||
$table->unique(['tenant_codigo', 'address_id']);
|
||||
|
||||
if (in_array($driver, ['mysql', 'mariadb'], true)) {
|
||||
// NULL allows many secondary addresses, while a tenant code can occur only once.
|
||||
$table->string('main_tenant_codigo')->nullable()
|
||||
->virtualAs('CASE WHEN is_main = 1 THEN tenant_codigo ELSE NULL END');
|
||||
$table->unique('main_tenant_codigo', 'tenant_addresses_one_main_per_tenant');
|
||||
}
|
||||
});
|
||||
|
||||
if (! in_array($driver, ['mysql', 'mariadb'], true)) {
|
||||
$condition = $driver === 'pgsql' ? 'is_main = true' : 'is_main = 1';
|
||||
DB::statement('CREATE UNIQUE INDEX tenant_addresses_one_main_per_tenant '
|
||||
."ON tenant_addresses (tenant_codigo) WHERE {$condition}");
|
||||
}
|
||||
}
|
||||
|
||||
public function down(): void
|
||||
{
|
||||
Schema::dropIfExists('tenant_addresses');
|
||||
Schema::dropIfExists('addresses');
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,108 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
public function up(): void
|
||||
{
|
||||
DB::transaction(function (): void {
|
||||
DB::table('tenants_menues')
|
||||
->where('menu_code', 'help.contact')
|
||||
->whereNotNull('static_content')
|
||||
->orderBy('id')
|
||||
->chunkById(100, function ($menus): void {
|
||||
foreach ($menus as $menu) {
|
||||
$content = json_decode($menu->static_content, true, flags: JSON_THROW_ON_ERROR);
|
||||
|
||||
if ($content === null) {
|
||||
continue;
|
||||
}
|
||||
|
||||
if (! is_array($content) || ! is_array($content['locations'] ?? [])) {
|
||||
throw new RuntimeException("Invalid contact locations for tenant {$menu->tenant_code}");
|
||||
}
|
||||
|
||||
foreach ($content['locations'] ?? [] as $location) {
|
||||
if (! is_array($location) || ! is_array($location['addresses'] ?? [])) {
|
||||
throw new RuntimeException("Invalid contact addresses for tenant {$menu->tenant_code}");
|
||||
}
|
||||
|
||||
foreach ($location['addresses'] ?? [] as $address) {
|
||||
$this->copyAddress($menu->tenant_code, $location, $address);
|
||||
}
|
||||
}
|
||||
}
|
||||
});
|
||||
});
|
||||
}
|
||||
|
||||
private function copyAddress(string $tenantCode, array $location, mixed $address): void
|
||||
{
|
||||
if (! is_array($address) || ! is_string($address['address'] ?? null)
|
||||
|| trim($address['address']) === '') {
|
||||
throw new RuntimeException("Invalid contact address text for tenant {$tenantCode}");
|
||||
}
|
||||
|
||||
$coordinates = $address['coordinates'] ?? null;
|
||||
|
||||
if ($coordinates !== null && (! is_array($coordinates) || count($coordinates) !== 2
|
||||
|| ! is_numeric($coordinates[0] ?? null) || ! is_numeric($coordinates[1] ?? null)
|
||||
|| ! is_finite((float) $coordinates[0]) || ! is_finite((float) $coordinates[1])
|
||||
|| abs((float) $coordinates[0]) > 90 || abs((float) $coordinates[1]) > 180)) {
|
||||
throw new RuntimeException("Invalid contact coordinates for tenant {$tenantCode}");
|
||||
}
|
||||
|
||||
$label = $address['label'] ?? $location['label'] ?? 'Dirección';
|
||||
|
||||
if (! is_string($label) || trim($label) === '' || mb_strlen($label) > 255) {
|
||||
throw new RuntimeException("Invalid contact address label for tenant {$tenantCode}");
|
||||
}
|
||||
|
||||
$values = [
|
||||
'label' => $label,
|
||||
'address_text' => $address['address'],
|
||||
'latitude' => $coordinates === null ? null : number_format((float) $coordinates[0], 7, '.', ''),
|
||||
'longitude' => $coordinates === null ? null : number_format((float) $coordinates[1], 7, '.', ''),
|
||||
];
|
||||
|
||||
// Reuse only within this tenant; equal legacy addresses in different tenants stay independent.
|
||||
$existing = DB::table('addresses')
|
||||
->join('tenant_addresses', 'tenant_addresses.address_id', '=', 'addresses.id')
|
||||
->where('tenant_addresses.tenant_codigo', $tenantCode)
|
||||
->where(array_combine(
|
||||
array_map(fn (string $field): string => 'addresses.'.$field, array_keys($values)),
|
||||
array_values($values),
|
||||
))
|
||||
->first(['addresses.id', 'tenant_addresses.id as link_id']);
|
||||
|
||||
if ($existing !== null) {
|
||||
return;
|
||||
}
|
||||
|
||||
$now = now();
|
||||
$isMain = ! DB::table('tenant_addresses')
|
||||
->where('tenant_codigo', $tenantCode)
|
||||
->where('is_main', true)
|
||||
->exists();
|
||||
$addressId = DB::table('addresses')->insertGetId([
|
||||
...$values,
|
||||
'created_at' => $now,
|
||||
'updated_at' => $now,
|
||||
]);
|
||||
|
||||
DB::table('tenant_addresses')->insert([
|
||||
'tenant_codigo' => $tenantCode,
|
||||
'address_id' => $addressId,
|
||||
'is_main' => $isMain,
|
||||
'created_at' => $now,
|
||||
'updated_at' => $now,
|
||||
]);
|
||||
}
|
||||
|
||||
public function down(): void
|
||||
{
|
||||
// Keep copies: they may already have been edited or reused. Legacy menus were never changed.
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,22 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Database\Schema\Blueprint;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
public function up(): void
|
||||
{
|
||||
Schema::table('events', function (Blueprint $table): void {
|
||||
$table->foreignId('address_id')->nullable()->constrained('addresses')->nullOnDelete();
|
||||
});
|
||||
}
|
||||
|
||||
public function down(): void
|
||||
{
|
||||
Schema::table('events', function (Blueprint $table): void {
|
||||
$table->dropConstrainedForeignId('address_id');
|
||||
});
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,57 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
public function up(): void
|
||||
{
|
||||
DB::transaction(function (): void {
|
||||
DB::table('events')->whereNull('address_id')->orderBy('id')->lockForUpdate()
|
||||
->chunkById(100, function ($events): void {
|
||||
foreach ($events as $event) {
|
||||
$coordinates = $event->exact_location === null
|
||||
? null
|
||||
: json_decode($event->exact_location, true, flags: JSON_THROW_ON_ERROR);
|
||||
|
||||
if ($coordinates !== null && (! is_array($coordinates)
|
||||
|| ! is_numeric($coordinates['latitude'] ?? null)
|
||||
|| ! is_numeric($coordinates['longitude'] ?? null)
|
||||
|| ! is_finite((float) $coordinates['latitude'])
|
||||
|| ! is_finite((float) $coordinates['longitude'])
|
||||
|| abs((float) $coordinates['latitude']) > 90
|
||||
|| abs((float) $coordinates['longitude']) > 180)) {
|
||||
throw new RuntimeException("Invalid location coordinates for event {$event->id}");
|
||||
}
|
||||
|
||||
if ($event->location === null || trim($event->location) === '') {
|
||||
if ($coordinates !== null) {
|
||||
throw new RuntimeException("Missing address text for event {$event->id}");
|
||||
}
|
||||
|
||||
continue;
|
||||
}
|
||||
|
||||
$now = now();
|
||||
$addressId = DB::table('addresses')->insertGetId([
|
||||
'label' => 'Ubicación del evento',
|
||||
'address_text' => $event->location,
|
||||
'latitude' => $coordinates === null ? null : $coordinates['latitude'],
|
||||
'longitude' => $coordinates === null ? null : $coordinates['longitude'],
|
||||
'created_at' => $now,
|
||||
'updated_at' => $now,
|
||||
]);
|
||||
|
||||
// Update only the new link, preserving the original fields and timestamps.
|
||||
DB::table('events')->where('id', $event->id)->update(['address_id' => $addressId]);
|
||||
}
|
||||
});
|
||||
});
|
||||
}
|
||||
|
||||
public function down(): void
|
||||
{
|
||||
// Copies may already have been edited or shared; keep them and the legacy data.
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,48 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Database\Schema\Blueprint;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
public function up(): void
|
||||
{
|
||||
$driver = DB::connection()->getDriverName();
|
||||
if (! in_array($driver, ['mysql', 'mariadb', 'sqlite', 'pgsql', 'sqlsrv'], true)) {
|
||||
throw new RuntimeException("Unsupported phone number database driver: {$driver}");
|
||||
}
|
||||
|
||||
Schema::create('phone_numbers', function (Blueprint $table): void {
|
||||
$table->id();
|
||||
$table->string('label');
|
||||
$table->string('number');
|
||||
$table->timestamps();
|
||||
});
|
||||
Schema::create('tenant_phone_numbers', function (Blueprint $table) use ($driver): void {
|
||||
$table->id();
|
||||
$table->string('tenant_codigo');
|
||||
$table->foreignId('phone_number_id')->constrained('phone_numbers')->cascadeOnDelete();
|
||||
$table->boolean('is_main')->default(false);
|
||||
$table->timestamps();
|
||||
$table->foreign('tenant_codigo')->references('codigo')->on('tenants')->cascadeOnDelete();
|
||||
$table->unique(['tenant_codigo', 'phone_number_id']);
|
||||
if (in_array($driver, ['mysql', 'mariadb'], true)) {
|
||||
$table->string('main_tenant_codigo')->nullable()
|
||||
->virtualAs('CASE WHEN is_main = 1 THEN tenant_codigo ELSE NULL END');
|
||||
$table->unique('main_tenant_codigo', 'tenant_phones_one_main');
|
||||
}
|
||||
});
|
||||
if (! in_array($driver, ['mysql', 'mariadb'], true)) {
|
||||
$condition = $driver === 'pgsql' ? 'is_main = true' : 'is_main = 1';
|
||||
DB::statement("CREATE UNIQUE INDEX tenant_phones_one_main ON tenant_phone_numbers (tenant_codigo) WHERE {$condition}");
|
||||
}
|
||||
}
|
||||
|
||||
public function down(): void
|
||||
{
|
||||
Schema::dropIfExists('tenant_phone_numbers');
|
||||
Schema::dropIfExists('phone_numbers');
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,65 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
public function up(): void
|
||||
{
|
||||
DB::transaction(function (): void {
|
||||
DB::table('tenants')->orderBy('id')->chunkById(100, function ($tenants): void {
|
||||
foreach ($tenants as $tenant) {
|
||||
$this->copyPhone($tenant->codigo, $tenant->phone, true);
|
||||
}
|
||||
});
|
||||
DB::table('tenants_menues')->where('menu_code', 'help.contact')
|
||||
->whereNotNull('static_content')->orderBy('id')->chunkById(100, function ($menus): void {
|
||||
foreach ($menus as $menu) {
|
||||
$content = json_decode($menu->static_content, true, flags: JSON_THROW_ON_ERROR);
|
||||
if ($content === null) {
|
||||
continue;
|
||||
}
|
||||
if (! is_array($content)) {
|
||||
throw new RuntimeException("Invalid contact content for tenant {$menu->tenant_code}");
|
||||
}
|
||||
$this->copyPhone($menu->tenant_code, $content['phone'] ?? null, false);
|
||||
}
|
||||
});
|
||||
});
|
||||
}
|
||||
|
||||
private function copyPhone(string $tenantCode, mixed $number, bool $fromTenant): void
|
||||
{
|
||||
if ($number === null || (is_string($number) && trim($number) === '')) {
|
||||
return;
|
||||
}
|
||||
if (! is_string($number) || mb_strlen($number) > 255 || ! preg_match('/[0-9]/', $number)) {
|
||||
throw new RuntimeException("Invalid phone number for tenant {$tenantCode}");
|
||||
}
|
||||
$numbers = DB::table('phone_numbers')
|
||||
->join('tenant_phone_numbers', 'phone_numbers.id', '=', 'tenant_phone_numbers.phone_number_id')
|
||||
->where('tenant_codigo', $tenantCode)->get(['phone_numbers.number']);
|
||||
$dialable = preg_replace('/[^0-9]/', '', $number);
|
||||
foreach ($numbers as $existing) {
|
||||
if (preg_replace('/[^0-9]/', '', $existing->number) === $dialable) {
|
||||
return;
|
||||
}
|
||||
}
|
||||
$isMain = ! DB::table('tenant_phone_numbers')->where('tenant_codigo', $tenantCode)->where('is_main', true)->exists();
|
||||
$now = now();
|
||||
$id = DB::table('phone_numbers')->insertGetId([
|
||||
'label' => $fromTenant ? 'Principal' : 'Contacto',
|
||||
'number' => trim($number), 'created_at' => $now, 'updated_at' => $now,
|
||||
]);
|
||||
DB::table('tenant_phone_numbers')->insert([
|
||||
'tenant_codigo' => $tenantCode, 'phone_number_id' => $id, 'is_main' => $isMain,
|
||||
'created_at' => $now, 'updated_at' => $now,
|
||||
]);
|
||||
}
|
||||
|
||||
public function down(): void
|
||||
{
|
||||
// Preserve copies that may have been edited. The legacy sources were not changed.
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,39 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
public function up(): void
|
||||
{
|
||||
DB::table('menues')->where('code', 'help.contact')->update([
|
||||
'content_type' => 'dynamic',
|
||||
'static_content_schema' => null,
|
||||
]);
|
||||
// Preserve legacy pivot content for rollback; dynamic menus do not expose it.
|
||||
}
|
||||
|
||||
public function down(): void
|
||||
{
|
||||
DB::table('menues')->where('code', 'help.contact')->update([
|
||||
'content_type' => 'static',
|
||||
'static_content_schema' => json_encode([
|
||||
'whatsapp' => 'required|array',
|
||||
'whatsapp.whatsapp_url' => 'required|url',
|
||||
'whatsapp.whatsapp_label' => 'required|string',
|
||||
'phone' => 'required|string',
|
||||
'locations' => 'required|array|min:1',
|
||||
'locations.*.label' => 'required|string',
|
||||
'locations.*.addresses' => 'required|array|min:1',
|
||||
'locations.*.addresses.*' => 'required|array:label,address,coordinates',
|
||||
'locations.*.addresses.*.label' => 'required|string',
|
||||
'locations.*.addresses.*.address' => 'required|string',
|
||||
'locations.*.addresses.*.coordinates' => 'required|array|size:2',
|
||||
'locations.*.addresses.*.coordinates.0' => 'required|numeric|between:-90,90',
|
||||
'locations.*.addresses.*.coordinates.1' => 'required|numeric|between:-180,180',
|
||||
'map_locations' => 'prohibited',
|
||||
], JSON_THROW_ON_ERROR),
|
||||
]);
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,94 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Database\Schema\Blueprint;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
public function up(): void
|
||||
{
|
||||
Schema::table('phone_numbers', function (Blueprint $table): void {
|
||||
$table->string('country_code', 8)->nullable()->default('+54');
|
||||
$table->string('mobile_prefix', 4)->nullable()->default('9');
|
||||
$table->string('area_code', 8)->nullable();
|
||||
$table->string('local_number')->nullable();
|
||||
});
|
||||
|
||||
DB::table('phone_numbers')->orderBy('id')->chunkById(100, function ($numbers): void {
|
||||
foreach ($numbers as $phone) {
|
||||
DB::table('phone_numbers')->where('id', $phone->id)
|
||||
->update($this->components($phone->number));
|
||||
}
|
||||
});
|
||||
|
||||
Schema::table('phone_numbers', function (Blueprint $table): void {
|
||||
$table->dropColumn('number');
|
||||
});
|
||||
}
|
||||
|
||||
public function down(): void
|
||||
{
|
||||
Schema::table('phone_numbers', function (Blueprint $table): void {
|
||||
$table->string('number')->nullable();
|
||||
});
|
||||
|
||||
DB::table('phone_numbers')->orderBy('id')->chunkById(100, function ($numbers): void {
|
||||
foreach ($numbers as $phone) {
|
||||
$parts = array_filter([
|
||||
$phone->country_code,
|
||||
$phone->mobile_prefix,
|
||||
$phone->area_code,
|
||||
$phone->local_number,
|
||||
], fn ($part): bool => $part !== null && $part !== '');
|
||||
DB::table('phone_numbers')->where('id', $phone->id)
|
||||
->update(['number' => implode(' ', $parts)]);
|
||||
}
|
||||
});
|
||||
|
||||
Schema::table('phone_numbers', function (Blueprint $table): void {
|
||||
$table->dropColumn(['country_code', 'mobile_prefix', 'area_code', 'local_number']);
|
||||
});
|
||||
}
|
||||
|
||||
/** @return array{country_code: ?string, mobile_prefix: ?string, area_code: ?string, local_number: string} */
|
||||
private function components(string $number): array
|
||||
{
|
||||
$number = trim($number);
|
||||
|
||||
if (preg_match('/^(\+?\d{1,3})\s+(?:(9)\s+)?\(?(\d{2,5})\)?[\s-]+([\d\s-]+)$/', $number, $match)) {
|
||||
return [
|
||||
'country_code' => '+'.ltrim($match[1], '+'),
|
||||
'mobile_prefix' => ($match[2] ?? '') ?: null,
|
||||
'area_code' => $match[3],
|
||||
'local_number' => preg_replace('/\D/', '', $match[4]),
|
||||
];
|
||||
}
|
||||
|
||||
if (preg_match('/^\(?(0\d{2,5})\)?[\s-]+([\d\s-]+)$/', $number, $match)) {
|
||||
return [
|
||||
'country_code' => null,
|
||||
'mobile_prefix' => null,
|
||||
'area_code' => $match[1],
|
||||
'local_number' => preg_replace('/\D/', '', $match[2]),
|
||||
];
|
||||
}
|
||||
|
||||
if (preg_match('/^\+54(9?)(\d+)$/', $number, $match)) {
|
||||
return [
|
||||
'country_code' => '+54',
|
||||
'mobile_prefix' => $match[1] === '9' ? '9' : null,
|
||||
'area_code' => null,
|
||||
'local_number' => $match[2],
|
||||
];
|
||||
}
|
||||
|
||||
return [
|
||||
'country_code' => null,
|
||||
'mobile_prefix' => null,
|
||||
'area_code' => null,
|
||||
'local_number' => $number,
|
||||
];
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,27 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Database\Schema\Blueprint;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
public function up(): void
|
||||
{
|
||||
Schema::table('categorias', function (Blueprint $table): void {
|
||||
$table->foreignId('banner_id')
|
||||
->nullable()
|
||||
->constrained('attachments')
|
||||
->nullOnDelete();
|
||||
$table->boolean('banner_enabled')->default(false);
|
||||
});
|
||||
}
|
||||
|
||||
public function down(): void
|
||||
{
|
||||
Schema::table('categorias', function (Blueprint $table): void {
|
||||
$table->dropConstrainedForeignId('banner_id');
|
||||
$table->dropColumn('banner_enabled');
|
||||
});
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,24 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
public function up(): void
|
||||
{
|
||||
DB::table('admin_website_types')
|
||||
->where('codigo', 'shopit')
|
||||
->update([
|
||||
'secondary_color' => '#ADADAD',
|
||||
'danger_color' => '#FF8888',
|
||||
'success_color' => '#58B341',
|
||||
'updated_at' => now(),
|
||||
]);
|
||||
}
|
||||
|
||||
public function down(): void
|
||||
{
|
||||
// Presentation settings are operational data; preserve them on rollback.
|
||||
}
|
||||
};
|
||||
@@ -0,0 +1,34 @@
|
||||
<?php
|
||||
|
||||
use Illuminate\Database\Migrations\Migration;
|
||||
use Illuminate\Database\Schema\Blueprint;
|
||||
use Illuminate\Support\Facades\DB;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
|
||||
return new class extends Migration
|
||||
{
|
||||
public function up(): void
|
||||
{
|
||||
Schema::table('categorias', function (Blueprint $table): void {
|
||||
$table->unsignedInteger('sort_order')->default(0);
|
||||
$table->index(['tenant_code', 'categoria_id', 'sort_order']);
|
||||
});
|
||||
|
||||
// Preserve the alphabetical navigation order until an administrator reorders it.
|
||||
$orders = [];
|
||||
foreach (DB::table('categorias')->orderBy('nombre')->orderBy('id')->get() as $category) {
|
||||
$group = json_encode([$category->tenant_code, $category->categoria_id]);
|
||||
$order = $orders[$group] ?? 0;
|
||||
DB::table('categorias')->where('id', $category->id)->update(['sort_order' => $order]);
|
||||
$orders[$group] = $order + 1;
|
||||
}
|
||||
}
|
||||
|
||||
public function down(): void
|
||||
{
|
||||
Schema::table('categorias', function (Blueprint $table): void {
|
||||
$table->dropIndex(['tenant_code', 'categoria_id', 'sort_order']);
|
||||
$table->dropColumn('sort_order');
|
||||
});
|
||||
}
|
||||
};
|
||||
@@ -14,6 +14,7 @@ use App\Shared\Enums\FieldType;
|
||||
use Illuminate\Database\Seeder;
|
||||
use Illuminate\Http\UploadedFile;
|
||||
use Illuminate\Support\Carbon;
|
||||
use Illuminate\Support\Facades\Schema;
|
||||
use Illuminate\Support\Facades\Storage;
|
||||
use RuntimeException;
|
||||
|
||||
@@ -51,14 +52,19 @@ class FiestaTradicionArrufoSeeder extends Seeder
|
||||
['tenant_code' => $tenant->codigo, 'title' => self::TITLE],
|
||||
['published_at' => now()],
|
||||
);
|
||||
$event->update([
|
||||
'client_id' => $client->id,
|
||||
$eventData = [
|
||||
'subtitle' => 'Una noche para celebrar nuestras raíces y mantener viva la tradición gaucha.',
|
||||
'description' => 'La 26.º Fiesta de la Tradición y 4.º Encuentro de Agrupaciones Gauchas reunirá a agrupaciones, artesanos, pilcheros y público en general para compartir una jornada dedicada a nuestras costumbres y cultura.'
|
||||
."\n\n".'Un encuentro para disfrutar de la tradición, la identidad gaucha y el espíritu de camaradería, en el Predio de Doma del Club Unión Deportiva Arrufó.'
|
||||
."\n\n".'Organiza: Biblioteca Popular Miguel Ángel Sosa.',
|
||||
'location' => 'Predio de Doma del Club Unión Deportiva Arrufó',
|
||||
]);
|
||||
];
|
||||
|
||||
if (Schema::hasColumn('events', 'client_id')) {
|
||||
$eventData['client_id'] = $client->id;
|
||||
}
|
||||
|
||||
$event->update($eventData);
|
||||
|
||||
$eventImage = $event->attachment;
|
||||
if ($eventImage === null || ! Storage::disk('s3')->exists($eventImage->path)) {
|
||||
|
||||
@@ -53,89 +53,131 @@ class MenuSeeder extends Seeder
|
||||
'route' => '/scanner/detail/:id',
|
||||
],
|
||||
[
|
||||
'code' => 'adminapp.event',
|
||||
'code' => 'onticket.adminapp.event',
|
||||
'label' => 'Eventos',
|
||||
'parent_menu_code' => 'main.adminapp',
|
||||
'route' => '/admin/event',
|
||||
],
|
||||
[
|
||||
'code' => 'adminapp.inicio',
|
||||
'code' => 'onticket.adminapp.inicio',
|
||||
'label' => 'Inicio',
|
||||
'parent_menu_code' => 'main.adminapp',
|
||||
'route' => '/admin/inicio',
|
||||
],
|
||||
[
|
||||
'code' => 'adminapp.catalog',
|
||||
'code' => 'onticket.adminapp.catalog',
|
||||
'label' => 'Catálogo',
|
||||
'parent_menu_code' => 'main.adminapp',
|
||||
'route' => '/admin/catalog',
|
||||
],
|
||||
[
|
||||
'code' => 'adminapp.combos',
|
||||
'code' => 'onticket.adminapp.combos',
|
||||
'label' => 'Combos',
|
||||
'parent_menu_code' => 'main.adminapp',
|
||||
'route' => '/admin/combos',
|
||||
],
|
||||
[
|
||||
'code' => 'adminapp.categories',
|
||||
'code' => 'onticket.adminapp.categories',
|
||||
'label' => 'Categorías',
|
||||
'parent_menu_code' => 'main.adminapp',
|
||||
'route' => '/admin/categories',
|
||||
],
|
||||
[
|
||||
'code' => 'adminapp.ventas',
|
||||
'code' => 'onticket.adminapp.ventas',
|
||||
'label' => 'Ventas',
|
||||
'parent_menu_code' => 'main.adminapp',
|
||||
'route' => '/admin/ventas',
|
||||
],
|
||||
[
|
||||
'code' => 'adminapp.staff',
|
||||
'code' => 'onticket.adminapp.staff',
|
||||
'label' => 'Usuarios',
|
||||
'parent_menu_code' => 'main.adminapp',
|
||||
'route' => '/admin/staff',
|
||||
],
|
||||
[
|
||||
'code' => 'adminapp.tickets',
|
||||
'code' => 'onticket.adminapp.tickets',
|
||||
'label' => 'Tickets',
|
||||
'parent_menu_code' => 'main.adminapp',
|
||||
'route' => '/admin/tickets',
|
||||
],
|
||||
[
|
||||
'code' => 'adminapp.fiesta-futbol-infantil.entradas',
|
||||
'code' => 'onticket.adminapp.fiesta-futbol-infantil.entradas',
|
||||
'label' => 'Entradas',
|
||||
'parent_menu_code' => 'main.adminapp',
|
||||
'route' => '/admin/entradas',
|
||||
],
|
||||
[
|
||||
'code' => 'adminapp.fiesta-futbol-infantil.alojamientos',
|
||||
'code' => 'onticket.adminapp.fiesta-futbol-infantil.alojamientos',
|
||||
'label' => 'Alojamientos',
|
||||
'parent_menu_code' => 'main.adminapp',
|
||||
'route' => '/admin/alojamientos',
|
||||
],
|
||||
[
|
||||
'code' => 'adminapp.fiesta-futbol-infantil.merchandising',
|
||||
'code' => 'onticket.adminapp.fiesta-futbol-infantil.merchandising',
|
||||
'label' => 'Merchandising',
|
||||
'parent_menu_code' => 'main.adminapp',
|
||||
'route' => '/admin/merchandising',
|
||||
],
|
||||
[
|
||||
'code' => 'adminapp.fiesta-futbol-infantil.comida',
|
||||
'code' => 'onticket.adminapp.fiesta-futbol-infantil.comida',
|
||||
'label' => 'Comida',
|
||||
'parent_menu_code' => 'main.adminapp',
|
||||
'route' => '/admin/comidas',
|
||||
],
|
||||
[
|
||||
'code' => 'adminapp.desfile.entradas',
|
||||
'code' => 'onticket.adminapp.desfile.entradas',
|
||||
'label' => 'Entradas',
|
||||
'parent_menu_code' => 'main.adminapp',
|
||||
'route' => '/admin/desfile/entradas',
|
||||
],
|
||||
[
|
||||
'code' => 'adminapp.desfile.reservas',
|
||||
'code' => 'onticket.adminapp.desfile.reservas',
|
||||
'label' => 'Reserva de Tickets',
|
||||
'parent_menu_code' => 'main.adminapp',
|
||||
'route' => '/admin/desfile/reservas',
|
||||
],
|
||||
[
|
||||
'code' => 'shopit.adminapp.marca',
|
||||
'label' => 'Marca',
|
||||
'parent_menu_code' => 'main.adminapp',
|
||||
'route' => '/admin/marca',
|
||||
],
|
||||
[
|
||||
'code' => 'shopit.adminapp.contacto',
|
||||
'label' => 'Contacto',
|
||||
'parent_menu_code' => 'main.adminapp',
|
||||
'route' => '/admin/contacto',
|
||||
],
|
||||
[
|
||||
'code' => 'shopit.adminapp.productos',
|
||||
'label' => 'Productos',
|
||||
'parent_menu_code' => 'main.adminapp',
|
||||
'route' => '/admin/productos',
|
||||
],
|
||||
[
|
||||
'code' => 'shopit.adminapp.categorias',
|
||||
'label' => 'Categorías',
|
||||
'parent_menu_code' => 'main.adminapp',
|
||||
'route' => '/admin/categorias',
|
||||
],
|
||||
[
|
||||
'code' => 'shopit.adminapp.transacciones',
|
||||
'label' => 'Transacciones',
|
||||
'parent_menu_code' => 'main.adminapp',
|
||||
'route' => '/admin/transacciones',
|
||||
],
|
||||
[
|
||||
'code' => 'shopit.adminapp.reportes',
|
||||
'label' => 'Reportes',
|
||||
'parent_menu_code' => 'main.adminapp',
|
||||
'route' => '/admin/reportes',
|
||||
],
|
||||
[
|
||||
'code' => 'shopit.adminapp.usuarios_roles',
|
||||
'label' => 'Usuarios y roles',
|
||||
'parent_menu_code' => 'main.adminapp',
|
||||
'route' => '/admin/usuarios-roles',
|
||||
],
|
||||
[
|
||||
'code' => 'account',
|
||||
'label' => 'Mi cuenta',
|
||||
@@ -182,23 +224,8 @@ class MenuSeeder extends Seeder
|
||||
'code' => 'help.contact',
|
||||
'label' => 'Contacto',
|
||||
'parent_menu_code' => 'help',
|
||||
'content_type' => Menu::CONTENT_TYPE_STATIC,
|
||||
'static_content_schema' => [
|
||||
'whatsapp' => 'required|array',
|
||||
'whatsapp.whatsapp_url' => 'required|url',
|
||||
'whatsapp.whatsapp_label' => 'required|string',
|
||||
'phone' => 'required|string',
|
||||
'locations' => 'required|array|min:1',
|
||||
'locations.*.label' => 'required|string',
|
||||
'locations.*.addresses' => 'required|array|min:1',
|
||||
'locations.*.addresses.*' => 'required|array:label,address,coordinates',
|
||||
'locations.*.addresses.*.label' => 'required|string',
|
||||
'locations.*.addresses.*.address' => 'required|string',
|
||||
'locations.*.addresses.*.coordinates' => 'required|array|size:2',
|
||||
'locations.*.addresses.*.coordinates.0' => 'required|numeric|between:-90,90',
|
||||
'locations.*.addresses.*.coordinates.1' => 'required|numeric|between:-180,180',
|
||||
'map_locations' => 'prohibited',
|
||||
],
|
||||
'content_type' => Menu::CONTENT_TYPE_DYNAMIC,
|
||||
'static_content_schema' => null,
|
||||
'route' => '/ayuda/contacto',
|
||||
],
|
||||
[
|
||||
@@ -219,7 +246,10 @@ class MenuSeeder extends Seeder
|
||||
'code' => 'help.terms-and-conditions',
|
||||
'label' => 'Términos y condiciones',
|
||||
'parent_menu_code' => 'help',
|
||||
'content_type' => Menu::CONTENT_TYPE_DYNAMIC,
|
||||
'content_type' => Menu::CONTENT_TYPE_STATIC,
|
||||
'static_content_schema' => [
|
||||
'html' => 'present|nullable|string',
|
||||
],
|
||||
'route' => '/ayuda/terminos-y-condiciones',
|
||||
],
|
||||
];
|
||||
@@ -255,6 +285,10 @@ class MenuSeeder extends Seeder
|
||||
])
|
||||
->delete();
|
||||
|
||||
Menu::query()
|
||||
->where('code', 'like', 'adminapp.%')
|
||||
->delete();
|
||||
|
||||
$allRoleMenuCodes = Menu::query()->pluck('code');
|
||||
$adminAppMenuCodes = Menu::query()
|
||||
->where('code', 'main.adminapp')
|
||||
@@ -299,24 +333,32 @@ class MenuSeeder extends Seeder
|
||||
'mutual_smep',
|
||||
];
|
||||
$ticketAdminMenuCodes = [
|
||||
'adminapp.tickets',
|
||||
'onticket.adminapp.tickets',
|
||||
];
|
||||
$fiestaCategoryMenuCodes = [
|
||||
'adminapp.fiesta-futbol-infantil.entradas',
|
||||
'adminapp.fiesta-futbol-infantil.alojamientos',
|
||||
'adminapp.fiesta-futbol-infantil.merchandising',
|
||||
'adminapp.fiesta-futbol-infantil.comida',
|
||||
'onticket.adminapp.fiesta-futbol-infantil.entradas',
|
||||
'onticket.adminapp.fiesta-futbol-infantil.alojamientos',
|
||||
'onticket.adminapp.fiesta-futbol-infantil.merchandising',
|
||||
'onticket.adminapp.fiesta-futbol-infantil.comida',
|
||||
];
|
||||
$fiestaExcludedAdminMenuCodes = [
|
||||
'adminapp.inicio',
|
||||
'adminapp.catalog',
|
||||
'adminapp.categories',
|
||||
'adminapp.combos',
|
||||
'onticket.adminapp.inicio',
|
||||
'onticket.adminapp.catalog',
|
||||
'onticket.adminapp.categories',
|
||||
'onticket.adminapp.combos',
|
||||
];
|
||||
$desfileMenuCodes = [
|
||||
'adminapp.desfile.entradas',
|
||||
'adminapp.desfile.reservas',
|
||||
'onticket.adminapp.desfile.entradas',
|
||||
'onticket.adminapp.desfile.reservas',
|
||||
];
|
||||
$shopItAdminMenuCodes = Menu::query()
|
||||
->where('code', 'like', 'shopit.adminapp.%')
|
||||
->pluck('code')
|
||||
->all();
|
||||
$onTicketAdminMenuCodes = Menu::query()
|
||||
->where('code', 'like', 'onticket.adminapp.%')
|
||||
->pluck('code')
|
||||
->all();
|
||||
$onTicketMenuCodes = [
|
||||
'event.index',
|
||||
'event.category',
|
||||
@@ -342,30 +384,6 @@ class MenuSeeder extends Seeder
|
||||
'is_active' => false,
|
||||
],
|
||||
];
|
||||
$contactContent = [
|
||||
'whatsapp' => [
|
||||
'whatsapp_url' => 'https://wa.me/543412602222',
|
||||
'whatsapp_label' => 'Chatea con nosotros',
|
||||
],
|
||||
'phone' => '+54 9 (0341) 6658247',
|
||||
'locations' => [
|
||||
'rosario' => [
|
||||
'label' => 'Rosario',
|
||||
'addresses' => [
|
||||
[
|
||||
'label' => 'Gigante de Arroyito',
|
||||
'address' => 'Av. Génova 640, Rosario',
|
||||
'coordinates' => [-32.913997, -60.674567],
|
||||
],
|
||||
[
|
||||
'label' => 'Telepagos',
|
||||
'address' => 'Rioja 1150, piso 12, dpto. 3, Rosario',
|
||||
'coordinates' => [-32.946820, -60.639320],
|
||||
],
|
||||
],
|
||||
],
|
||||
],
|
||||
];
|
||||
$mutualSmepFrequentlyAskedQuestions = [
|
||||
[
|
||||
'pregunta' => '¿Hay algún límite de compra?',
|
||||
@@ -383,29 +401,17 @@ class MenuSeeder extends Seeder
|
||||
'is_active' => false,
|
||||
],
|
||||
];
|
||||
$mutualSmepContactContent = [
|
||||
'whatsapp' => [
|
||||
'whatsapp_url' => 'https://wa.me/5493412474530',
|
||||
'whatsapp_label' => 'Chateá con Mutual SMEP',
|
||||
],
|
||||
'phone' => '+54 9 341 247-4530',
|
||||
'locations' => [
|
||||
'rosario' => [
|
||||
'label' => 'Rosario',
|
||||
'addresses' => [
|
||||
[
|
||||
'label' => 'Mutual SMEP',
|
||||
'address' => 'San Lorenzo 1543, Rosario, Santa Fe',
|
||||
'coordinates' => [-32.9431184, -60.6437991],
|
||||
],
|
||||
],
|
||||
],
|
||||
],
|
||||
];
|
||||
|
||||
foreach ($tenants as $tenant) {
|
||||
$menuCodes = $allMenus;
|
||||
|
||||
$menuCodes = array_diff(
|
||||
$menuCodes,
|
||||
$tenant->admin_website_type_code === 'shopit'
|
||||
? $onTicketAdminMenuCodes
|
||||
: $shopItAdminMenuCodes,
|
||||
);
|
||||
|
||||
if ($tenant->codigo === 'sonder') {
|
||||
// Sonder NO tiene tickets
|
||||
$menuCodes = array_diff($menuCodes, ['account.tickets']);
|
||||
@@ -447,11 +453,6 @@ class MenuSeeder extends Seeder
|
||||
? $mutualSmepFrequentlyAskedQuestions
|
||||
: $frequentlyAskedQuestions,
|
||||
]);
|
||||
$tenant->menues()->updateExistingPivot('help.contact', [
|
||||
'static_content' => $tenant->codigo === 'mutual_smep'
|
||||
? $mutualSmepContactContent
|
||||
: $contactContent,
|
||||
]);
|
||||
}
|
||||
}
|
||||
}
|
||||
|
||||
@@ -40,7 +40,7 @@ class WebsiteTypeSeeder extends Seeder
|
||||
|
||||
public function run(): void
|
||||
{
|
||||
$shopIt = $this->websiteTypeService->updateOrCreate(
|
||||
$this->websiteTypeService->updateOrCreate(
|
||||
['codigo' => 'shopit'],
|
||||
[
|
||||
'nombre' => 'ShopIt',
|
||||
@@ -48,9 +48,13 @@ class WebsiteTypeSeeder extends Seeder
|
||||
'scanner_domain' => 'scanner.localhost',
|
||||
'site_title' => 'ShopIt',
|
||||
...self::PRESENTATION,
|
||||
'site_logo' => $this->onTicketLogo(),
|
||||
'footer_logo' => $this->onTicketFooterLogo(),
|
||||
'favicon' => $this->onTicketFavicon(),
|
||||
'primary_color' => '#2FD3AC',
|
||||
'secondary_color' => '#ADADAD',
|
||||
'danger_color' => '#FF8888',
|
||||
'success_color' => '#58B341',
|
||||
'site_logo' => $this->shopItLogo(),
|
||||
'footer_logo' => $this->shopItFooterLogo(),
|
||||
'favicon' => $this->shopItFavicon(),
|
||||
],
|
||||
);
|
||||
|
||||
@@ -83,7 +87,7 @@ class WebsiteTypeSeeder extends Seeder
|
||||
...self::PRESENTATION,
|
||||
'site_logo' => $this->onTicketLogo(),
|
||||
'footer_logo' => $this->onTicketFooterLogo(),
|
||||
'favicon' => $shopIt->favicon()->firstOrFail()->key,
|
||||
'favicon' => $this->onTicketFavicon(),
|
||||
],
|
||||
);
|
||||
|
||||
@@ -204,7 +208,7 @@ class WebsiteTypeSeeder extends Seeder
|
||||
|
||||
private function onTicketLogo(): UploadedFile
|
||||
{
|
||||
$path = public_path('images/website_types/onticket_logo.png');
|
||||
$path = public_path('images/website_types/onticket/onticket_logo.png');
|
||||
|
||||
if (! file_exists($path)) {
|
||||
throw new RuntimeException("OnTicket logo not found at path: {$path}");
|
||||
@@ -221,7 +225,7 @@ class WebsiteTypeSeeder extends Seeder
|
||||
|
||||
private function onTicketFooterLogo(): UploadedFile
|
||||
{
|
||||
$path = public_path('images/website_types/onticket_footer_logo.png');
|
||||
$path = public_path('images/website_types/onticket/onticket_footer_logo.png');
|
||||
|
||||
if (! file_exists($path)) {
|
||||
throw new RuntimeException("OnTicket footer logo not found at path: {$path}");
|
||||
@@ -238,7 +242,7 @@ class WebsiteTypeSeeder extends Seeder
|
||||
|
||||
private function onTicketFavicon(): UploadedFile
|
||||
{
|
||||
$path = public_path('images/website_types/onticket_favicon.svg');
|
||||
$path = public_path('images/website_types/onticket/onticket_favicon.svg');
|
||||
|
||||
if (! file_exists($path)) {
|
||||
throw new RuntimeException("OnTicket favicon not found at path: {$path}");
|
||||
@@ -252,4 +256,30 @@ class WebsiteTypeSeeder extends Seeder
|
||||
true,
|
||||
);
|
||||
}
|
||||
|
||||
private function shopItLogo(): UploadedFile
|
||||
{
|
||||
return $this->uploadedImage('shopit', 'shopit_logo.png', 'image/png');
|
||||
}
|
||||
|
||||
private function shopItFooterLogo(): UploadedFile
|
||||
{
|
||||
return $this->uploadedImage('shopit', 'shopit_footer_logo.png', 'image/png');
|
||||
}
|
||||
|
||||
private function shopItFavicon(): UploadedFile
|
||||
{
|
||||
return $this->uploadedImage('shopit', 'shopit-favicon.svg', 'image/svg+xml');
|
||||
}
|
||||
|
||||
private function uploadedImage(string $websiteType, string $filename, string $mimeType): UploadedFile
|
||||
{
|
||||
$path = public_path("images/website_types/{$websiteType}/{$filename}");
|
||||
|
||||
if (! file_exists($path)) {
|
||||
throw new RuntimeException("Website type image not found at path: {$path}");
|
||||
}
|
||||
|
||||
return new UploadedFile($path, $filename, $mimeType, null, true);
|
||||
}
|
||||
}
|
||||
|
||||
|
Before Width: | Height: | Size: 422 B After Width: | Height: | Size: 422 B |
Some files were not shown because too many files have changed in this diff Show More
Reference in New Issue
Block a user