unit frm_SelectReceta;

interface

uses
  Winapi.Windows, Winapi.Messages, System.SysUtils, System.Variants, System.Classes, Vcl.Graphics,
  Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Vcl.StdCtrls, Vcl.ExtCtrls, Vcl.Grids, Vcl.DBGrids,
  Data.DB, FireDAC.Comp.Client, FireDAC.Stan.Param, uAppTheme, frm_BaseSelect;

type
  TfrmSelectReceta = class(TfrmBaseSelect)
  private
    FSelectedPrefijoLote: string;
    FSelectedProductos: string;
  protected
    procedure DoSearch; override;
    procedure DoSelect; override;
  public
    constructor Create(AOwner: TComponent); override;
    property SelectedPrefijoLote: string read FSelectedPrefijoLote;
    property SelectedProductos: string read FSelectedProductos;
  end;

var
  frmSelectReceta: TfrmSelectReceta;

implementation

uses
  dmg_Main;

{$R *.dfm}

constructor TfrmSelectReceta.Create(AOwner: TComponent);
begin
  inherited Create(AOwner);
  FSelectedPrefijoLote := '';
  FSelectedProductos := '';
end;

procedure TfrmSelectReceta.DoSearch;
var
  LSql: string;
begin
  dmgMain.qryExec.Close;
  LSql :=
    'SELECT r.id, r.id AS codigo_str, r.descripcion, ' +
    '       COALESCE(r.prefijo_lote, '''') AS prefijo_lote, ' +
    '       COALESCE(r.version, ''1.0'') AS version, ' +
    '       (SELECT GROUP_CONCAT(CONCAT(a.descripcion, '' ('', COALESCE(rp.formato, ''Estándar''), '')'') SEPARATOR '', '') ' +
    '        FROM ob_recetas_productos rp ' +
    '        JOIN ge_articulos a ON rp.articulo_id = a.id ' +
    '        WHERE rp.receta_id = r.id AND rp.activo = 1) AS productos_asociados ' +
    'FROM ob_recetas r ' +
    'WHERE r.activo = 1 ';

  if Trim(edtSearch.Text) <> '' then
  begin
    LSql := LSql + 'AND (r.descripcion LIKE :search OR CAST(r.id AS CHAR) LIKE :search OR r.prefijo_lote LIKE :search) ';
  end;

  LSql := LSql + 'ORDER BY r.descripcion';
  dmgMain.qryExec.SQL.Text := LSql;

  if Trim(edtSearch.Text) <> '' then
  begin
    dmgMain.qryExec.ParamByName('search').DataType := ftWideString;
    dmgMain.qryExec.ParamByName('search').AsWideString := '%' + Trim(edtSearch.Text) + '%';
  end;

  dmgMain.qryExec.Open;

  // Ajustar visibilidad y anchos de columnas
  if dmgMain.qryExec.FindField('id') <> nil then
    dmgMain.qryExec.FieldByName('id').Visible := False;

  if dmgMain.qryExec.FindField('codigo_str') <> nil then
    dmgMain.qryExec.FieldByName('codigo_str').Visible := False;

  if dmgMain.qryExec.FindField('descripcion') <> nil then
  begin
    dmgMain.qryExec.FieldByName('descripcion').DisplayLabel := 'Receta de Elaboración';
    dmgMain.qryExec.FieldByName('descripcion').DisplayWidth := 35;
  end;

  if dmgMain.qryExec.FindField('prefijo_lote') <> nil then
  begin
    dmgMain.qryExec.FieldByName('prefijo_lote').DisplayLabel := 'Prefijo';
    dmgMain.qryExec.FieldByName('prefijo_lote').DisplayWidth := 10;
  end;

  if dmgMain.qryExec.FindField('version') <> nil then
  begin
    dmgMain.qryExec.FieldByName('version').DisplayLabel := 'Versión';
    dmgMain.qryExec.FieldByName('version').DisplayWidth := 10;
  end;

  if dmgMain.qryExec.FindField('productos_asociados') <> nil then
  begin
    dmgMain.qryExec.FieldByName('productos_asociados').DisplayLabel := 'Artículos / Formatos que genera';
    dmgMain.qryExec.FieldByName('productos_asociados').DisplayWidth := 45;
  end;
end;

procedure TfrmSelectReceta.DoSelect;
begin
  if not dmgMain.qryExec.IsEmpty then
  begin
    if dmgMain.qryExec.FindField('prefijo_lote') <> nil then
      FSelectedPrefijoLote := dmgMain.qryExec.FieldByName('prefijo_lote').AsString
    else
      FSelectedPrefijoLote := '';

    if dmgMain.qryExec.FindField('productos_asociados') <> nil then
      FSelectedProductos := dmgMain.qryExec.FieldByName('productos_asociados').AsString
    else
      FSelectedProductos := '';
  end;

  inherited;
end;

end.
