Tul xxx Tul

Viewing: InventoryMovementModel.php

<?php

namespace App\Models;

use CodeIgniter\Model;

class InventoryMovementModel extends Model
{
    protected $table            = 'inventory_movements';
    protected $primaryKey       = 'id';
    protected $useAutoIncrement = true;
    protected $returnType       = 'array';
    protected $useSoftDeletes   = false;
    protected $protectFields    = true;
    protected $allowedFields    = [
        'product_id',
        'product_name',
        'warehouse_id',
        'type',
        'quantity',
        'document_number',
        'supplier_id',
        'payment_form',
        'user_id',
        'notes',
        'created_at',
        'updated_at'
    ];

    protected $useTimestamps = true;
    protected $createdField  = 'created_at';
    protected $updatedField  = 'updated_at';

    /**
     * Obtiene el historial de movimientos con detalles de productos y bodegas
     */
    public function getHistory($filters = [])
    {
        $builder = $this->select('inventory_movements.*, warehouses.name as warehouse_name, users.name as user_name, suppliers.company_name as supplier_name')
            ->join('warehouses', 'warehouses.id = inventory_movements.warehouse_id', 'left')
            ->join('users', 'users.id = inventory_movements.user_id', 'left')
            ->join('suppliers', 'suppliers.id = inventory_movements.supplier_id', 'left');

        if (!empty($filters['desde'])) {
            $builder->where('inventory_movements.created_at >=', $filters['desde'] . ' 00:00:00');
        }
        if (!empty($filters['hasta'])) {
            $builder->where('inventory_movements.created_at <=', $filters['hasta'] . ' 23:59:59');
        }
        if (!empty($filters['warehouse_id'])) {
            $builder->where('inventory_movements.warehouse_id', $filters['warehouse_id']);
        }

        return $builder->orderBy('inventory_movements.created_at', 'desc')->findAll();
    }
}

User / IP	: 216.73.216.191
Host / Server	: 45.84.207.204 / aircan.me
System	: Linux lt-bnk-web1726.main-hosting.eu 5.14.0-611.36.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 3 11:23:52 EST 2026 x86_64