unit frm_SelectProvFactura;

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
  TfrmSelectProvFactura = class(TfrmBaseSelect)
  private
    FProveedorId: Integer;
    FEmpresaId: Integer;
    FSelectedDoc: string;
  protected
    procedure DoSearch; override;
    procedure DoSelect; override;
  public
    property ProveedorId: Integer read FProveedorId write FProveedorId;
    property EmpresaId: Integer read FEmpresaId write FEmpresaId;
    property SelectedDoc: string read FSelectedDoc write FSelectedDoc;
  end;

var
  frmSelectProvFactura: TfrmSelectProvFactura;

implementation

uses
  dmg_Main;

{$R *.dfm}

procedure TfrmSelectProvFactura.DoSearch;
var
  LSql: string;
  LSearch: string;
begin
  dmgMain.qryExec.Close;
  LSql := 'SELECT id, documento, fecha, base, totaliva, totalentrada, comprobado, pagada ' +
          'FROM ge_prov_facturas ' +
          'WHERE 1=1 ';

  if FProveedorId > 0 then
    LSql := LSql + 'AND idproveedor = :idprov ';

  if FEmpresaId > 0 then
    LSql := LSql + 'AND idempresa = :idempresa ';

  LSearch := Trim(edtSearch.Text);
  if LSearch <> '' then
    LSql := LSql + 'AND (documento LIKE :search OR DATE_FORMAT(fecha, ''%d/%m/%Y'') LIKE :search) ';

  LSql := LSql + 'ORDER BY fecha DESC, documento DESC';

  dmgMain.qryExec.SQL.Text := LSql;
  if FProveedorId > 0 then
    dmgMain.qryExec.ParamByName('idprov').AsInteger := FProveedorId;

  if FEmpresaId > 0 then
    dmgMain.qryExec.ParamByName('idempresa').AsInteger := FEmpresaId;

  if LSearch <> '' then
    dmgMain.qryExec.ParamByName('search').AsString := '%' + LSearch + '%';

  dmgMain.qryExec.Open;

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

  if dmgMain.qryExec.FindField('documento') <> nil then
  begin
    dmgMain.qryExec.FieldByName('documento').DisplayLabel := 'Nº Factura';
    dmgMain.qryExec.FieldByName('documento').DisplayWidth := 15;
  end;

  if dmgMain.qryExec.FindField('fecha') <> nil then
  begin
    dmgMain.qryExec.FieldByName('fecha').DisplayLabel := 'Fecha';
    dmgMain.qryExec.FieldByName('fecha').DisplayWidth := 12;
  end;

  if dmgMain.qryExec.FindField('base') <> nil then
  begin
    dmgMain.qryExec.FieldByName('base').DisplayLabel := 'Base Imp.';
    dmgMain.qryExec.FieldByName('base').DisplayWidth := 12;
    TNumericField(dmgMain.qryExec.FieldByName('base')).DisplayFormat := '#,##0.00 €';
  end;

  if dmgMain.qryExec.FindField('totaliva') <> nil then
  begin
    dmgMain.qryExec.FieldByName('totaliva').DisplayLabel := 'IVA';
    dmgMain.qryExec.FieldByName('totaliva').DisplayWidth := 10;
    TNumericField(dmgMain.qryExec.FieldByName('totaliva')).DisplayFormat := '#,##0.00 €';
  end;

  if dmgMain.qryExec.FindField('totalentrada') <> nil then
  begin
    dmgMain.qryExec.FieldByName('totalentrada').DisplayLabel := 'Total Factura';
    dmgMain.qryExec.FieldByName('totalentrada').DisplayWidth := 14;
    TNumericField(dmgMain.qryExec.FieldByName('totalentrada')).DisplayFormat := '#,##0.00 €';
  end;

  if dmgMain.qryExec.FindField('comprobado') <> nil then
  begin
    dmgMain.qryExec.FieldByName('comprobado').DisplayLabel := 'Validada';
    dmgMain.qryExec.FieldByName('comprobado').DisplayWidth := 8;
  end;

  if dmgMain.qryExec.FindField('pagada') <> nil then
  begin
    dmgMain.qryExec.FieldByName('pagada').DisplayLabel := 'Pagada';
    dmgMain.qryExec.FieldByName('pagada').DisplayWidth := 8;
  end;
end;

procedure TfrmSelectProvFactura.DoSelect;
begin
  if not dmgMain.qryExec.IsEmpty then
  begin
    SelectedId := dmgMain.qryExec.FieldByName('id').AsString;
    SelectedDoc := dmgMain.qryExec.FieldByName('documento').AsString;
    SelectedCode := SelectedDoc;
    SelectedDesc := SelectedDoc;
    ModalResult := mrOk;
  end;
end;

end.
