unit frm_SelectCodigosCajaStock;

interface

uses
  Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes,
  System.Math, System.UITypes, Vcl.Graphics, Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Vcl.StdCtrls, Vcl.ExtCtrls,
  Vcl.Grids, Vcl.DBGrids, Vcl.Clipbrd, System.Generics.Collections,
  Data.DB, FireDAC.Comp.Client, FireDAC.Stan.Param, FireDAC.Stan.Intf,
  FireDAC.Stan.Option, FireDAC.Stan.Error, FireDAC.DatS, FireDAC.Phys.Intf, FireDAC.DApt.Intf;

type
  TfrmSelectCodigosCajaStock = class(TForm)
    pnlHeader: TPanel;
    lblTitle: TLabel;
    lblSubtitle: TLabel;
    lblCount: TLabel;
    pnlFiltro: TPanel;
    lblFiltro: TLabel;
    edtFiltro: TEdit;
    btnLimpiarFiltro: TButton;
    dbgCodigos: TDBGrid;
    pnlBottom: TPanel;
    lblTip: TLabel;
    btnUsarCaja6: TButton;
    btnUsarCaja4: TButton;
    btnUsarIndividual: TButton;
    btnUsarOtraCaja: TButton;
    btnCopiar: TButton;
    btnCancelar: TButton;
    dsStock: TDataSource;
    mtStock: TFDMemTable;

    procedure FormCreate(Sender: TObject);
    procedure FormDestroy(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure edtFiltroChange(Sender: TObject);
    procedure btnLimpiarFiltroClick(Sender: TObject);
    procedure dbgCodigosDblClick(Sender: TObject);
    procedure dbgCodigosKeyDown(Sender: TObject; var Key: Word; Shift: TShiftState);
    procedure btnUsarCaja6Click(Sender: TObject);
    procedure btnUsarCaja4Click(Sender: TObject);
    procedure btnUsarIndividualClick(Sender: TObject);
    procedure btnUsarOtraCajaClick(Sender: TObject);
    procedure btnCopiarClick(Sender: TObject);
    procedure mtStockFilterRecord(DataSet: TDataSet; var Accept: Boolean);
  private
    FPedidoId: string;
    FAlbaranId: Integer;
    FClienteId: Integer;
    FAlmacenId: Integer;
    FArticulosIds: TArray<Integer>;
    FSelectedBarcode: string;
    FSelectedArticuloId: Integer;
    FSelectedLoteId: Integer;
    FSelectedLote: string;

    procedure ConfigurarMemTable;
    procedure CargarStockArticulosPedido;
    function FormatGS1128(const AGtin: string; ACaducidad: TDateTime; const ALote: string): string;
    procedure ActualizarContador;
    procedure UsarCodigoCaja(const AFieldName, AEmptyMsg: string);
  public
    procedure SetArticulosIds(const AIds: TArray<Integer>);
    property PedidoId: string read FPedidoId write FPedidoId;
    property AlbaranId: Integer read FAlbaranId write FAlbaranId;
    property ClienteId: Integer read FClienteId write FClienteId;
    property AlmacenId: Integer read FAlmacenId write FAlmacenId;
    property SelectedBarcode: string read FSelectedBarcode;
    property SelectedArticuloId: Integer read FSelectedArticuloId;
    property SelectedLoteId: Integer read FSelectedLoteId;
    property SelectedLote: string read FSelectedLote;
  end;

var
  frmSelectCodigosCajaStock: TfrmSelectCodigosCajaStock;

implementation

uses
  dmg_Main, uAppTheme, uGS1BarcodeParser;

{$R *.dfm}

procedure TfrmSelectCodigosCajaStock.FormCreate(Sender: TObject);
begin
  FPedidoId := '';
  FAlbaranId := 0;
  FClienteId := 0;
  FAlmacenId := 0;
  SetLength(FArticulosIds, 0);
  FSelectedBarcode := '';
  FSelectedArticuloId := 0;
  FSelectedLoteId := 0;
  FSelectedLote := '';

  ConfigurarMemTable;
  mtStock.OnFilterRecord := mtStockFilterRecord;
end;

procedure TfrmSelectCodigosCajaStock.FormDestroy(Sender: TObject);
begin
  if mtStock.Active then
    mtStock.Close;
end;

procedure TfrmSelectCodigosCajaStock.FormShow(Sender: TObject);
begin
  TAppTheme.ApplyToForm(Self);
  if (FAlbaranId <= 0) and (Length(FArticulosIds) = 0) then
  begin
    Caption := 'Lotes y Stock Envasado Disponible';
    lblTitle.Caption := '📦 Lotes y Existencias Disponibles en Stock Envasado';
    lblSubtitle.Caption := 'Doble clic en un lote para seleccionarlo y transferirlo al movimiento.';
  end;
  CargarStockArticulosPedido;
  if Assigned(edtFiltro) and edtFiltro.CanFocus then
    edtFiltro.SetFocus;
end;

procedure TfrmSelectCodigosCajaStock.SetArticulosIds(const AIds: TArray<Integer>);
begin
  FArticulosIds := Copy(AIds);
end;

procedure TfrmSelectCodigosCajaStock.ConfigurarMemTable;
begin
  mtStock.Close;
  mtStock.FieldDefs.Clear;

  // Orden de los campos: primero caja 6, luego caja 4, luego individual, luego resto de cajas
  mtStock.FieldDefs.Add('cod_caja_6', ftWideString, 80);
  mtStock.FieldDefs.Add('cod_caja_4', ftWideString, 80);
  mtStock.FieldDefs.Add('cod_individual', ftWideString, 80);
  mtStock.FieldDefs.Add('resto_codigos_caja', ftWideString, 500);
  mtStock.FieldDefs.Add('articulo_desc', ftWideString, 250);
  mtStock.FieldDefs.Add('lote_codigo', ftWideString, 50);
  mtStock.FieldDefs.Add('caducidad_str', ftWideString, 20);
  mtStock.FieldDefs.Add('stock_disp', ftFloat);

  // Campos internos auxiliares
  mtStock.FieldDefs.Add('id_articulo', ftInteger);
  mtStock.FieldDefs.Add('id_lote', ftInteger);
  mtStock.FieldDefs.Add('raw_resto_primero', ftWideString, 80);
  mtStock.FieldDefs.Add('fecha_caducidad', ftDate);

  mtStock.CreateDataSet;
  dsStock.DataSet := mtStock;
end;

function TfrmSelectCodigosCajaStock.FormatGS1128(const AGtin: string; ACaducidad: TDateTime; const ALote: string): string;
var
  LGtin14, LCadStr, LDigitsOnly: string;
  C: Char;
begin
  Result := '';
  LDigitsOnly := '';
  for C in Trim(AGtin) do
    if CharInSet(C, ['0'..'9']) then
      LDigitsOnly := LDigitsOnly + C;

  if LDigitsOnly = '' then Exit;

  LGtin14 := LDigitsOnly;
  while Length(LGtin14) < 14 do
    LGtin14 := '0' + LGtin14;
  if Length(LGtin14) > 14 then
    LGtin14 := Copy(LGtin14, 1, 14);

  if ACaducidad > 0 then
    LCadStr := FormatDateTime('yymmdd', ACaducidad)
  else
    LCadStr := '000000';

  Result := Format('(01)%s(17)%s(10)%s', [LGtin14, LCadStr, Trim(ALote)]);
end;

procedure TfrmSelectCodigosCajaStock.CargarStockArticulosPedido;
var
  QryStock, QryEan, QryCli: TFDQuery;
  LArtId: Integer;
  LArtDesc, LBaseEan, LLote: string;
  LCaducidad: TDateTime;
  LStockDisp: Double;
  LCodCaja6, LCodCaja4, LCodIndividual, LRawRestoPrimero: string;
  LRestoList: TList<string>;
  LHasItems: Boolean;
  i: Integer;
begin
  mtStock.DisableControls;
  try
    mtStock.EmptyDataSet;
    LHasItems := False;

    QryStock := TFDQuery.Create(nil);
    QryEan := TFDQuery.Create(nil);
    QryCli := TFDQuery.Create(nil);
    LRestoList := TList<string>.Create;
    try
      QryStock.Connection := dmgMain.dbConn;
      QryEan.Connection := dmgMain.dbConn;
      QryCli.Connection := dmgMain.dbConn;

      // Consulta de stock envasado disponible para los artículos del pedido
      QryStock.SQL.Text :=
        'SELECT ' +
        '  se.id_articulo, ' +
        '  art.descripcion AS articulo_desc, ' +
        '  COALESCE(art.ean, '''') AS articulo_ean, ' +
        '  COALESCE(art.dias_vida, 0) AS dias_vida, ' +
        '  l.id AS lote_id, ' +
        '  COALESCE(NULLIF(l.codigo_antiguo, ''''), l.codigo) AS lote_codigo, ' +
        '  l.fecha AS lote_fecha, ' +
        '  (CASE ' +
        '     WHEN l.fecha IS NOT NULL AND art.dias_vida > 0 THEN DATE_ADD(l.fecha, INTERVAL art.dias_vida DAY) ' +
        '     ELSE NULL ' +
        '   END) AS fecha_caducidad, ' +
        '  SUM(se.cantidad_unidades) AS stock_disponible ' +
        'FROM ge_stock_envasado se ' +
        'JOIN ge_articulos art ON se.id_articulo = art.id ' +
        'JOIN ge_lotes l ON se.id_lote = l.id ' +
        'WHERE se.cantidad_unidades > 0 ';

      if FAlmacenId > 0 then
      begin
        QryStock.SQL.Add('  AND se.id_almacen = :alm ');
        QryStock.ParamByName('alm').AsInteger := FAlmacenId;
      end;

      if Length(FArticulosIds) > 0 then
      begin
        var LParamNames := TStringList.Create;
        try
          for i := 0 to High(FArticulosIds) do
            LParamNames.Add(':art' + IntToStr(i));
          QryStock.SQL.Add('  AND se.id_articulo IN (' + LParamNames.CommaText + ') ');
          for i := 0 to High(FArticulosIds) do
            QryStock.ParamByName('art' + IntToStr(i)).AsInteger := FArticulosIds[i];
        finally
          LParamNames.Free;
        end;
      end
      else if FAlbaranId > 0 then
      begin
        QryStock.SQL.Add('  AND se.id_articulo IN (SELECT DISTINCT articulo_id FROM ge_albaranes_lineas WHERE albaran_id = :alb AND articulo_id > 0) ');
        QryStock.ParamByName('alb').AsInteger := FAlbaranId;
      end;

      QryStock.SQL.Add(
        'GROUP BY se.id_articulo, art.descripcion, art.ean, art.dias_vida, l.id, lote_codigo, l.fecha, fecha_caducidad ' +
        'ORDER BY art.descripcion ASC, fecha_caducidad ASC, lote_codigo ASC'
      );

      QryStock.Open;

      while not QryStock.Eof do
      begin
        LArtId := QryStock.FieldByName('id_articulo').AsInteger;
        LArtDesc := QryStock.FieldByName('articulo_desc').AsString;
        LBaseEan := Trim(QryStock.FieldByName('articulo_ean').AsString);
        LLote := Trim(QryStock.FieldByName('lote_codigo').AsString);

        if not QryStock.FieldByName('fecha_caducidad').IsNull then
          LCaducidad := QryStock.FieldByName('fecha_caducidad').AsDateTime
        else
          LCaducidad := TGS1BarcodeParser.ResolverCaducidadLote(LLote, IntToStr(LArtId));

        LStockDisp := QryStock.FieldByName('stock_disponible').AsFloat;

        LCodCaja6 := '';
        LCodCaja4 := '';
        LCodIndividual := '';
        LRawRestoPrimero := '';
        LRestoList.Clear;

        // 1. Buscar códigos en ge_articulos_ean
        QryEan.Close;
        QryEan.SQL.Text := 'SELECT ean, unidades FROM ge_articulos_ean WHERE articulo_id = :art ORDER BY unidades ASC';
        QryEan.ParamByName('art').AsInteger := LArtId;
        QryEan.Open;

        while not QryEan.Eof do
        begin
          var LEan := Trim(QryEan.FieldByName('ean').AsString);
          var LUds := QryEan.FieldByName('unidades').AsFloat;

          if SameValue(LUds, 6.0, 0.001) then
          begin
            if LCodCaja6 = '' then
              LCodCaja6 := FormatGS1128(LEan, LCaducidad, LLote);
          end
          else if SameValue(LUds, 4.0, 0.001) then
          begin
            if LCodCaja4 = '' then
              LCodCaja4 := FormatGS1128(LEan, LCaducidad, LLote);
          end
          else if SameValue(LUds, 1.0, 0.001) then
          begin
            // Para el producto individual, el código debe ser el DUN-14 que empieza por 0
            var LGtin0 := TGS1BarcodeParser.CalcularGTIN14(LEan, '0');
            if LGtin0 <> '' then
              LCodIndividual := FormatGS1128(LGtin0, LCaducidad, LLote)
            else
              LCodIndividual := FormatGS1128(LEan, LCaducidad, LLote);

            // Si en ge_articulos_ean había un código con indicador distinto de 0 (ej. 1...), guardarlo también en resto
            var LGtinClean := TGS1BarcodeParser.CalcularGTIN14(LEan, '0');
            var LRawFmt := FormatGS1128(LEan, LCaducidad, LLote);
            if (LRawFmt <> '') and (LRawFmt <> LCodIndividual) then
              LRestoList.Add(Format('[%.0f uds] %s', [LUds, LRawFmt]));
          end
          else
          begin
            var LFormattedResto := FormatGS1128(LEan, LCaducidad, LLote);
            if LFormattedResto <> '' then
            begin
              if LRawRestoPrimero = '' then
                LRawRestoPrimero := LFormattedResto;
              LRestoList.Add(Format('[%.0f uds] %s', [LUds, LFormattedResto]));
            end;
          end;

          QryEan.Next;
        end;

        // 2. Si no había código individual en ge_articulos_ean, derivarlo de art.ean con indicador 0
        if (LCodIndividual = '') and (LBaseEan <> '') then
        begin
          var LGtin0 := TGS1BarcodeParser.CalcularGTIN14(LBaseEan, '0');
          if LGtin0 <> '' then
            LCodIndividual := FormatGS1128(LGtin0, LCaducidad, LLote)
          else
            LCodIndividual := FormatGS1128(LBaseEan, LCaducidad, LLote);
        end;

        // 3. Si no había caja de 6 en ge_articulos_ean, verificar ge_clientes_articulos
        if LCodCaja6 = '' then
        begin
          QryCli.Close;
          QryCli.SQL.Text :=
            'SELECT ca.dun14, ca.ean13 FROM ge_clientes_articulos ca ' +
            'WHERE ca.id_articulo = :art AND ca.activo = 1 ' +
            'ORDER BY (CASE WHEN :cli > 0 AND ca.id_cliente = :cli THEN 0 ELSE 1 END) ASC LIMIT 1';
          QryCli.ParamByName('art').AsInteger := LArtId;
          QryCli.ParamByName('cli').AsInteger := FClienteId;
          QryCli.Open;
          if not QryCli.IsEmpty then
          begin
            var LDunCli := Trim(QryCli.FieldByName('dun14').AsString);
            if LDunCli <> '' then
              LCodCaja6 := FormatGS1128(LDunCli, LCaducidad, LLote);
          end;
        end;

        // Insertar registro en el MemTable
        mtStock.Append;
        mtStock.FieldByName('cod_caja_6').AsString := LCodCaja6;
        mtStock.FieldByName('cod_caja_4').AsString := LCodCaja4;
        mtStock.FieldByName('cod_individual').AsString := LCodIndividual;
        
        var LRestoStr: string := '';
        for var s in LRestoList do
        begin
          if LRestoStr <> '' then
            LRestoStr := LRestoStr + '  |  ' + s
          else
            LRestoStr := s;
        end;
        mtStock.FieldByName('resto_codigos_caja').AsString := LRestoStr;

        mtStock.FieldByName('articulo_desc').AsString := LArtDesc;
        mtStock.FieldByName('lote_codigo').AsString := LLote;

        if LCaducidad > 0 then
          mtStock.FieldByName('caducidad_str').AsString := FormatDateTime('dd/mm/yyyy', LCaducidad)
        else
          mtStock.FieldByName('caducidad_str').AsString := '—';

        mtStock.FieldByName('stock_disp').AsFloat := LStockDisp;
        mtStock.FieldByName('id_articulo').AsInteger := LArtId;
        mtStock.FieldByName('id_lote').AsInteger := QryStock.FieldByName('lote_id').AsInteger;
        mtStock.FieldByName('raw_resto_primero').AsString := LRawRestoPrimero;
        if LCaducidad > 0 then
          mtStock.FieldByName('fecha_caducidad').AsDateTime := LCaducidad;

        mtStock.Post;
        LHasItems := True;

        QryStock.Next;
      end;

    finally
      QryStock.Free;
      QryEan.Free;
      QryCli.Free;
      LRestoList.Free;
    end;

    if not mtStock.IsEmpty then
      mtStock.First;

    ActualizarContador;

    if not LHasItems then
    begin
      if FAlbaranId > 0 then
        lblSubtitle.Caption := '⚠️ No se encontraron lotes con stock envasado disponible para los artículos de este pedido.'
      else
        lblSubtitle.Caption := '⚠️ No se encontraron lotes con stock envasado disponible en este almacén / ubicación.';
      lblSubtitle.Font.Color := TColor($002B49B8); // Rojo informativo
    end
    else
    begin
      if FAlbaranId > 0 then
        lblSubtitle.Caption := 'Lotes disponibles para los artículos del pedido. Haga doble clic para seleccionar un código.'
      else
        lblSubtitle.Caption := 'Doble clic en un lote para seleccionarlo y transferirlo al movimiento.';
      lblSubtitle.Font.Color := clWhite;
    end;

  finally
    mtStock.EnableControls;
  end;
end;

procedure TfrmSelectCodigosCajaStock.ActualizarContador;
begin
  if Assigned(lblCount) then
    lblCount.Caption := Format('%d lote(s) encontrado(s)', [mtStock.RecordCount]);
end;

procedure TfrmSelectCodigosCajaStock.mtStockFilterRecord(DataSet: TDataSet; var Accept: Boolean);
var
  LFilter: string;
begin
  LFilter := Trim(AnsiUpperCase(edtFiltro.Text));
  if LFilter = '' then
  begin
    Accept := True;
    Exit;
  end;

  Accept :=
    (Pos(LFilter, AnsiUpperCase(DataSet.FieldByName('articulo_desc').AsString)) > 0) or
    (Pos(LFilter, AnsiUpperCase(DataSet.FieldByName('lote_codigo').AsString)) > 0) or
    (Pos(LFilter, AnsiUpperCase(DataSet.FieldByName('cod_caja_6').AsString)) > 0) or
    (Pos(LFilter, AnsiUpperCase(DataSet.FieldByName('cod_caja_4').AsString)) > 0) or
    (Pos(LFilter, AnsiUpperCase(DataSet.FieldByName('cod_individual').AsString)) > 0) or
    (Pos(LFilter, AnsiUpperCase(DataSet.FieldByName('resto_codigos_caja').AsString)) > 0) or
    (Pos(LFilter, AnsiUpperCase(DataSet.FieldByName('caducidad_str').AsString)) > 0);
end;

procedure TfrmSelectCodigosCajaStock.edtFiltroChange(Sender: TObject);
begin
  mtStock.DisableControls;
  try
    if Trim(edtFiltro.Text) = '' then
      mtStock.Filtered := False
    else
    begin
      mtStock.Filtered := False;
      mtStock.Filtered := True;
    end;
    ActualizarContador;
  finally
    mtStock.EnableControls;
  end;
end;

procedure TfrmSelectCodigosCajaStock.btnLimpiarFiltroClick(Sender: TObject);
begin
  edtFiltro.Text := '';
  mtStock.Filtered := False;
  ActualizarContador;
  if edtFiltro.CanFocus then
    edtFiltro.SetFocus;
end;

procedure TfrmSelectCodigosCajaStock.UsarCodigoCaja(const AFieldName, AEmptyMsg: string);
var
  LCode: string;
begin
  if mtStock.IsEmpty then Exit;
  LCode := Trim(mtStock.FieldByName(AFieldName).AsString);
  FSelectedBarcode := LCode;
  FSelectedArticuloId := mtStock.FieldByName('id_articulo').AsInteger;
  FSelectedLoteId := mtStock.FieldByName('id_lote').AsInteger;
  FSelectedLote := mtStock.FieldByName('lote_codigo').AsString;

  if (LCode = '') and
     (Trim(mtStock.FieldByName('cod_caja_6').AsString) = '') and
     (Trim(mtStock.FieldByName('cod_caja_4').AsString) = '') and
     (Trim(mtStock.FieldByName('cod_individual').AsString) = '') then
  begin
    // Si no tiene código de barras GS1 pero se seleccionó el lote, permitir selección directa
    ModalResult := mrOk;
    Exit;
  end;

  if LCode = '' then
  begin
    MessageDlg(AEmptyMsg, mtWarning, [mbOK], 0);
    Exit;
  end;
  ModalResult := mrOk;
end;

procedure TfrmSelectCodigosCajaStock.btnUsarCaja6Click(Sender: TObject);
begin
  UsarCodigoCaja('cod_caja_6', '⚠️ El artículo seleccionado no tiene configurado código para caja de 6 unidades.');
end;

procedure TfrmSelectCodigosCajaStock.btnUsarCaja4Click(Sender: TObject);
begin
  UsarCodigoCaja('cod_caja_4', '⚠️ El artículo seleccionado no tiene configurado código para caja de 4 unidades.');
end;

procedure TfrmSelectCodigosCajaStock.btnUsarIndividualClick(Sender: TObject);
var
  LCode: string;
begin
  if mtStock.IsEmpty then Exit;
  LCode := Trim(mtStock.FieldByName('cod_individual').AsString);
  FSelectedBarcode := LCode;
  FSelectedArticuloId := mtStock.FieldByName('id_articulo').AsInteger;
  FSelectedLoteId := mtStock.FieldByName('id_lote').AsInteger;
  FSelectedLote := mtStock.FieldByName('lote_codigo').AsString;
  ModalResult := mrOk;
end;

procedure TfrmSelectCodigosCajaStock.btnUsarOtraCajaClick(Sender: TObject);
var
  LCode: string;
begin
  if mtStock.IsEmpty then Exit;
  LCode := Trim(mtStock.FieldByName('raw_resto_primero').AsString);
  if LCode = '' then
    LCode := Trim(mtStock.FieldByName('resto_codigos_caja').AsString);

  FSelectedBarcode := LCode;
  FSelectedArticuloId := mtStock.FieldByName('id_articulo').AsInteger;
  FSelectedLoteId := mtStock.FieldByName('id_lote').AsInteger;
  FSelectedLote := mtStock.FieldByName('lote_codigo').AsString;

  if LCode = '' then
  begin
    MessageDlg('⚠️ No hay otros códigos de caja configurados para este artículo.', mtWarning, [mbOK], 0);
    Exit;
  end;

  ModalResult := mrOk;
end;

procedure TfrmSelectCodigosCajaStock.btnCopiarClick(Sender: TObject);
var
  LCodeToCopy: string;
begin
  if mtStock.IsEmpty then Exit;
  LCodeToCopy := '';
  if Assigned(dbgCodigos.SelectedField) and (Trim(dbgCodigos.SelectedField.AsString) <> '') then
    LCodeToCopy := Trim(dbgCodigos.SelectedField.AsString);

  if LCodeToCopy = '' then
    LCodeToCopy := Trim(mtStock.FieldByName('cod_caja_6').AsString);
  if LCodeToCopy = '' then
    LCodeToCopy := Trim(mtStock.FieldByName('cod_caja_4').AsString);
  if LCodeToCopy = '' then
    LCodeToCopy := Trim(mtStock.FieldByName('cod_individual').AsString);

  if LCodeToCopy <> '' then
  begin
    Clipboard.AsText := LCodeToCopy;
    MessageDlg('✓ Código copiado al portapapeles:' + sLineBreak + sLineBreak + LCodeToCopy, mtInformation, [mbOK], 0);
  end;
end;

procedure TfrmSelectCodigosCajaStock.dbgCodigosDblClick(Sender: TObject);
begin
  if mtStock.IsEmpty then Exit;
  if Assigned(dbgCodigos.SelectedField) then
  begin
    if dbgCodigos.SelectedField.FieldName = 'cod_individual' then
    begin
      btnUsarIndividual.Click;
      Exit;
    end
    else if dbgCodigos.SelectedField.FieldName = 'resto_codigos_caja' then
    begin
      btnUsarOtraCaja.Click;
      Exit;
    end
    else if dbgCodigos.SelectedField.FieldName = 'cod_caja_6' then
    begin
      btnUsarCaja6.Click;
      Exit;
    end
    else if dbgCodigos.SelectedField.FieldName = 'cod_caja_4' then
    begin
      btnUsarCaja4.Click;
      Exit;
    end;
  end;

  // Por defecto en doble clic sobre cualquier otra columna: preferir caja de 6 si existe, si no caja de 4, si no individual, si no otra caja, si no selección directa
  if Trim(mtStock.FieldByName('cod_caja_6').AsString) <> '' then
    btnUsarCaja6.Click
  else if Trim(mtStock.FieldByName('cod_caja_4').AsString) <> '' then
    btnUsarCaja4.Click
  else if Trim(mtStock.FieldByName('cod_individual').AsString) <> '' then
    btnUsarIndividual.Click
  else if Trim(mtStock.FieldByName('raw_resto_primero').AsString) <> '' then
    btnUsarOtraCaja.Click
  else
  begin
    FSelectedBarcode := '';
    FSelectedArticuloId := mtStock.FieldByName('id_articulo').AsInteger;
    FSelectedLoteId := mtStock.FieldByName('id_lote').AsInteger;
    FSelectedLote := mtStock.FieldByName('lote_codigo').AsString;
    ModalResult := mrOk;
  end;
end;

procedure TfrmSelectCodigosCajaStock.dbgCodigosKeyDown(Sender: TObject; var Key: Word; Shift: TShiftState);
begin
  if Key = VK_RETURN then
  begin
    Key := 0;
    dbgCodigosDblClick(Sender);
  end
  else if Key = VK_ESCAPE then
  begin
    Key := 0;
    ModalResult := mrCancel;
  end;
end;

end.
