unit uFrmMain;

interface

uses
  Winapi.Windows, Winapi.Messages, Winapi.ShellAPI, System.SysUtils,
  System.StrUtils, System.Math, System.UITypes, System.Classes, Vcl.Graphics, Vcl.Controls, Vcl.Forms,
  Vcl.Dialogs, Vcl.StdCtrls, Vcl.ExtCtrls, Vcl.ComCtrls, Vcl.Grids, Vcl.DBGrids,
  Vcl.Imaging.jpeg, Data.DB, FireDAC.Stan.Intf, FireDAC.Stan.Option,
  FireDAC.Stan.Param, FireDAC.Stan.Error, FireDAC.DatS, FireDAC.Phys.Intf,
  FireDAC.DApt.Intf, FireDAC.Stan.Async, FireDAC.DApt, FireDAC.Comp.DataSet,
  FireDAC.Comp.Client,
  uSecurityCrypto, uDMMain, uFrmConfigDB, uFrmLogin;

type
  TfrmMain = class(TForm)
    pnlTopBar: TPanel;
    lblAppTitle: TLabel;
    lblDoctorInfo: TLabel;
    chkPrivacidad: TCheckBox;
    btnConfigBD: TButton;
    btnBloquearSesion: TButton;
    pgcMain: TPageControl;
    tsPacientes: TTabSheet;
    pnlPacientesTop: TPanel;
    lblBuscarPac: TLabel;
    edtBuscarPaciente: TEdit;
    btnBuscarPaciente: TButton;
    btnNuevoPaciente: TButton;
    btnIrHistoria: TButton;
    btnIrDocumentosPac: TButton;
    dbgPacientes: TDBGrid;
    pnlFichaPaciente: TPanel;
    lblFichaTitulo: TLabel;
    lblHist: TLabel;
    lblDNI: TLabel;
    lblFNaci: TLabel;
    lblNombrePac: TLabel;
    lblApp1Pac: TLabel;
    lblApp2Pac: TLabel;
    lblSexoPac: TLabel;
    lblGSPac: TLabel;
    lblDirPac: TLabel;
    lblPobPac: TLabel;
    lblCPPac: TLabel;
    lblProvPac: TLabel;
    lblTelPac: TLabel;
    lblMovilPac: TLabel;
    lblEmailPac: TLabel;
    lblPolizaPac: TLabel;
    lblAlergias: TLabel;
    lblObsPac: TLabel;
    pnlFotoMarco: TPanel;
    imgFotoPaciente: TImage;
    edtHist: TEdit;
    edtDNI: TEdit;
    edtFNaci: TEdit;
    edtNombre: TEdit;
    cmbSexo: TComboBox;
    edtGrupoSang: TEdit;
    edtApp1: TEdit;
    edtApp2: TEdit;
    edtDireccion: TEdit;
    edtPoblacion: TEdit;
    edtCP: TEdit;
    edtProvincia: TEdit;
    edtTelefono: TEdit;
    edtMovil: TEdit;
    edtEmail: TEdit;
    edtPoliza: TEdit;
    chkLOPD: TCheckBox;
    memAlergias: TMemo;
    memObsPaciente: TMemo;
    btnGuardarPaciente: TButton;
    tsHistoria: TTabSheet;
    pnlHistTop: TPanel;
    lblPacienteActivoHist: TLabel;
    chkSoloPacienteActualVis: TCheckBox;
    edtBuscarVisita: TEdit;
    btnFiltrarVisitas: TButton;
    btnNuevaVisita: TButton;
    pnlVisitasLeft: TPanel;
    dbgVisitas: TDBGrid;
    grpDetalleVisita: TGroupBox;
    lblMotivoVis: TLabel;
    edtMotivoVisita: TEdit;
    btnGuardarVisita: TButton;
    memObsVisita: TMemo;
    grpResultadosSeccion: TGroupBox;
    dbgResultados: TDBGrid;
    pnlResultadoEditor: TPanel;
    lblSeccionParrafo: TLabel;
    cmbParrafoSeccion: TComboBox;
    btnGuardarResultado: TButton;
    memResultadoTexto: TMemo;
    tsAgenda: TTabSheet;
    pnlAgendaTop: TPanel;
    lblFiltroCita: TLabel;
    edtBuscarCita: TEdit;
    btnFiltrarCitas: TButton;
    btnMarcarVisto: TButton;
    dbgAgenda: TDBGrid;
    tsDocumentos: TTabSheet;
    pnlDocsTop: TPanel;
    lblBuscarDoc: TLabel;
    edtBuscarDoc: TEdit;
    chkSoloPacienteActualDoc: TCheckBox;
    btnFiltrarDocs: TButton;
    btnAdjuntarDoc: TButton;
    btnExportarDoc: TButton;
    dbgDocumentos: TDBGrid;
    pnlVisorDoc: TPanel;
    lblInfoVisorDoc: TLabel;
    imgDocumento: TImage;
    tsFacturacion: TTabSheet;
    grpFacturas: TGroupBox;
    dbgFacturas: TDBGrid;
    dbgLineasFactura: TDBGrid;
    grpServicios: TGroupBox;
    dbgServicios: TDBGrid;
    tsAuditoria: TTabSheet;
    pnlAuditTop: TPanel;
    lblBuscarAudit: TLabel;
    edtBuscarAuditoria: TEdit;
    btnFiltrarAuditoria: TButton;
    dbgAuditoria: TDBGrid;
    pnlStatusBar: TPanel;
    lblStatusLeft: TLabel;
    qryPacientes: TFDQuery;
    dsPacientes: TDataSource;
    qryVisitas: TFDQuery;
    dsVisitas: TDataSource;
    qryResultados: TFDQuery;
    dsResultados: TDataSource;
    qryAgenda: TFDQuery;
    dsAgenda: TDataSource;
    qryDocumentos: TFDQuery;
    dsDocumentos: TDataSource;
    qryFacturas: TFDQuery;
    dsFacturas: TDataSource;
    qryLineasFactura: TFDQuery;
    dsLineasFactura: TDataSource;
    qryServicios: TFDQuery;
    dsServicios: TDataSource;
    qryAuditoria: TFDQuery;
    dsAuditoria: TDataSource;
    tmrInactividad: TTimer;
    OpenDialogDoc: TOpenDialog;
    SaveDialogDoc: TSaveDialog;
    procedure FormCreate(Sender: TObject);
    procedure FormShow(Sender: TObject);
    procedure chkPrivacidadClick(Sender: TObject);
    procedure btnConfigBDClick(Sender: TObject);
    procedure btnBloquearSesionClick(Sender: TObject);
    procedure pgcMainChange(Sender: TObject);
    procedure edtBuscarPacienteKeyDown(Sender: TObject; var Key: Word; Shift: TShiftState);
    procedure btnBuscarPacienteClick(Sender: TObject);
    procedure btnNuevoPacienteClick(Sender: TObject);
    procedure btnGuardarPacienteClick(Sender: TObject);
    procedure btnIrHistoriaClick(Sender: TObject);
    procedure btnIrDocumentosPacClick(Sender: TObject);
    procedure qryPacientesAfterScroll(DataSet: TDataSet);
    procedure chkSoloPacienteActualVisClick(Sender: TObject);
    procedure btnFiltrarVisitasClick(Sender: TObject);
    procedure btnNuevaVisitaClick(Sender: TObject);
    procedure btnGuardarVisitaClick(Sender: TObject);
    procedure qryVisitasAfterScroll(DataSet: TDataSet);
    procedure qryResultadosAfterScroll(DataSet: TDataSet);
    procedure btnGuardarResultadoClick(Sender: TObject);
    procedure btnFiltrarCitasClick(Sender: TObject);
    procedure btnMarcarVistoClick(Sender: TObject);
    procedure chkSoloPacienteActualDocClick(Sender: TObject);
    procedure btnFiltrarDocsClick(Sender: TObject);
    procedure btnAdjuntarDocClick(Sender: TObject);
    procedure btnExportarDocClick(Sender: TObject);
    procedure qryDocumentosAfterScroll(DataSet: TDataSet);
    procedure qryFacturasAfterScroll(DataSet: TDataSet);
    procedure btnFiltrarAuditoriaClick(Sender: TObject);
    procedure tmrInactividadTimer(Sender: TObject);
  private
    FCurrentHistoria: Integer;
    FCurrentPacienteNombre: string;
    FCurrentVisitaID: Integer;
    FIsNewPaciente: Boolean;
    procedure UpdateHeaderDoctorUI;
    procedure LoadParrafosCombo;
    procedure LoadPacientes;
    procedure LoadFichaPacienteDetalle(AHistoria: Integer);
    procedure LoadVisitas;
    procedure LoadResultadosVisita(AVisitaID: Integer);
    procedure LoadAgenda;
    procedure LoadDocumentos;
    procedure LoadPreviewBlobIntoImage(const ABytes: TBytes; AImage: TImage; out AInfoText: string);
    procedure LoadFacturacionYServicios;
    procedure LoadAuditoriaRGPD;

    // Eventos OnGetText de TField (declarados como métodos de clase of object según Regla 01)
    procedure FieldDNIGetText(Sender: TField; var Text: string; DisplayText: Boolean);
    procedure FieldPhoneGetText(Sender: TField; var Text: string; DisplayText: Boolean);
  protected
    procedure CreateParams(var Params: TCreateParams); override;
  public
  end;

var
  frmMain: TfrmMain;

implementation

{$R *.dfm}

procedure TfrmMain.CreateParams(var Params: TCreateParams);
begin
  inherited CreateParams(Params);
  Params.ExStyle := Params.ExStyle or WS_EX_APPWINDOW;
end;

procedure TfrmMain.FormCreate(Sender: TObject);
begin
  FCurrentHistoria := 0;
  FCurrentVisitaID := 0;
  FIsNewPaciente := False;
  pgcMain.ActivePage := tsPacientes;
end;

procedure TfrmMain.FormShow(Sender: TObject);
begin
  chkPrivacidad.Checked := dmMain.PrivacyMode;
  UpdateHeaderDoctorUI;
  LoadParrafosCombo;
  LoadPacientes;
end;

procedure TfrmMain.UpdateHeaderDoctorUI;
begin
  lblDoctorInfo.Caption := Format('Facultativo Activo: %s (%s | Col: %s) — Equipo: %s (%s)',
    [dmMain.CurrentDoctorName,
     IfThen(dmMain.CurrentDoctorSpecialty <> '', dmMain.CurrentDoctorSpecialty, 'General'),
     IfThen(dmMain.CurrentDoctorColegiado <> '', dmMain.CurrentDoctorColegiado, 'S/N'),
     dmMain.LocalPCName, dmMain.LocalIP4]);
  lblStatusLeft.Caption := Format(
    'Seguridad Activa: Config BD Encriptada (DPAPI + HMAC-SHA256) | Bloqueo Inactividad: %d min | Trazabilidad RGPD (gl_tabla): ACTIVA',
    [dmMain.Config.InactivityMinutes]);
end;

procedure TfrmMain.FieldDNIGetText(Sender: TField; var Text: string; DisplayText: Boolean);
begin
  Text := TSecurityCrypto.MaskDNI(Sender.AsString, dmMain.PrivacyMode);
end;

procedure TfrmMain.FieldPhoneGetText(Sender: TField; var Text: string; DisplayText: Boolean);
begin
  Text := TSecurityCrypto.MaskPhone(Sender.AsString, dmMain.PrivacyMode);
end;

procedure TfrmMain.chkPrivacidadClick(Sender: TObject);
begin
  dmMain.TouchActivity;
  dmMain.PrivacyMode := chkPrivacidad.Checked;
  dbgPacientes.Invalidate;
  dbgAgenda.Invalidate;
end;

procedure TfrmMain.btnConfigBDClick(Sender: TObject);
var
  LFrmCfg: TfrmConfigDB;
begin
  dmMain.TouchActivity;
  LFrmCfg := TfrmConfigDB.Create(Self);
  try
    if LFrmCfg.ShowModal = mrOk then
    begin
      chkPrivacidad.Checked := dmMain.PrivacyMode;
      UpdateHeaderDoctorUI;
      LoadPacientes;
    end;
  finally
    LFrmCfg.Free;
  end;
end;

procedure TfrmMain.btnBloquearSesionClick(Sender: TObject);
var
  LFrmLogin: TfrmLogin;
begin
  dmMain.RegistrarAuditoria(ACCION_LOGOUT,
    Format('BLOQUEO_CONSULTA MEDICO=%d', [dmMain.CurrentDoctorID]));
  Self.Hide;
  LFrmLogin := TfrmLogin.Create(nil);
  try
    if LFrmLogin.ShowModal = mrOk then
    begin
      UpdateHeaderDoctorUI;
      Self.Show;
      dmMain.TouchActivity;
    end
    else
      Application.Terminate;
  finally
    LFrmLogin.Free;
  end;
end;

procedure TfrmMain.tmrInactividadTimer(Sender: TObject);
begin
  if Self.Showing and dmMain.IsSessionExpired then
  begin
    tmrInactividad.Enabled := False;
    try
      MessageDlg('Sesión clínica bloqueada automáticamente por inactividad para proteger los datos médicos (RGPD).',
        mtInformation, [mbOK], 0);
      btnBloquearSesionClick(nil);
    finally
      tmrInactividad.Enabled := True;
    end;
  end;
end;

procedure TfrmMain.LoadParrafosCombo;
var
  LQry: TFDQuery;
begin
  cmbParrafoSeccion.Items.Clear;
  if not dmMain.FDConn.Connected then
    Exit;
  LQry := TFDQuery.Create(nil);
  try
    LQry.Connection := dmMain.FDConn;
    LQry.SQL.Text :=
      'SELECT ID, NOMBRE FROM gm_parrafos ' +
      'WHERE ID > 0 AND NOMBRE IS NOT NULL AND TRIM(NOMBRE) <> '''' ' +
      'ORDER BY ID ASC';
    LQry.Open;
    while not LQry.Eof do
    begin
      cmbParrafoSeccion.Items.AddObject(
        Format('[%d] %s', [LQry.FieldByName('ID').AsInteger, Trim(LQry.FieldByName('NOMBRE').AsString)]),
        TObject(LQry.FieldByName('ID').AsInteger));
      LQry.Next;
    end;
    if cmbParrafoSeccion.Items.Count > 0 then
      cmbParrafoSeccion.ItemIndex := 0;
  finally
    LQry.Free;
  end;
end;

procedure TfrmMain.pgcMainChange(Sender: TObject);
begin
  dmMain.TouchActivity;
  if pgcMain.ActivePage = tsPacientes then
  begin
    if not qryPacientes.Active then
      LoadPacientes;
  end
  else if pgcMain.ActivePage = tsHistoria then
    LoadVisitas
  else if pgcMain.ActivePage = tsAgenda then
    LoadAgenda
  else if pgcMain.ActivePage = tsDocumentos then
    LoadDocumentos
  else if pgcMain.ActivePage = tsFacturacion then
    LoadFacturacionYServicios
  else if pgcMain.ActivePage = tsAuditoria then
    LoadAuditoriaRGPD;
end;

procedure TfrmMain.LoadPacientes;
var
  LFiltro: string;
  F: TField;
begin
  if not dmMain.FDConn.Connected then
    Exit;
  Screen.Cursor := crHourGlass;
  try
    LFiltro := Trim(edtBuscarPaciente.Text);
    qryPacientes.DisableControls;
    try
      qryPacientes.Close;
      if LFiltro = '' then
      begin
        qryPacientes.SQL.Text :=
          'SELECT HISTORIA, APPNOM, DNI, FNACI, TELEFONO, MOVIL, POBLACION, LOPD ' +
          'FROM gm_pacientes ORDER BY HISTORIA DESC LIMIT 300';
      end
      else
      begin
        qryPacientes.SQL.Text :=
          'SELECT HISTORIA, APPNOM, DNI, FNACI, TELEFONO, MOVIL, POBLACION, LOPD ' +
          'FROM gm_pacientes ' +
          'WHERE CAST(HISTORIA AS CHAR) = :exact ' +
          '   OR APPNOM LIKE :filtro ' +
          '   OR DNI LIKE :filtro ' +
          '   OR TELEFONO LIKE :filtro ' +
          '   OR MOVIL LIKE :filtro ' +
          '   OR POBLACION LIKE :filtro ' +
          'ORDER BY HISTORIA DESC LIMIT 300';
        dmMain.SetParamString(qryPacientes.ParamByName('exact'), LFiltro);
        dmMain.SetParamString(qryPacientes.ParamByName('filtro'), '%' + LFiltro + '%');
      end;
      qryPacientes.Open;

      F := qryPacientes.FindField('DNI');
      if F <> nil then
        F.OnGetText := FieldDNIGetText;
      F := qryPacientes.FindField('TELEFONO');
      if F <> nil then
        F.OnGetText := FieldPhoneGetText;
      F := qryPacientes.FindField('MOVIL');
      if F <> nil then
        F.OnGetText := FieldPhoneGetText;
    finally
      qryPacientes.EnableControls;
    end;

    if not qryPacientes.IsEmpty then
      qryPacientesAfterScroll(qryPacientes);
  finally
    Screen.Cursor := crDefault;
  end;
end;

procedure TfrmMain.edtBuscarPacienteKeyDown(Sender: TObject; var Key: Word; Shift: TShiftState);
begin
  if Key = VK_RETURN then
  begin
    Key := 0;
    btnBuscarPacienteClick(nil);
  end;
end;

procedure TfrmMain.btnBuscarPacienteClick(Sender: TObject);
begin
  dmMain.TouchActivity;
  LoadPacientes;
end;

procedure TfrmMain.qryPacientesAfterScroll(DataSet: TDataSet);
begin
  if DataSet.IsEmpty then
    Exit;
  FIsNewPaciente := False;
  FCurrentHistoria := DataSet.FieldByName('HISTORIA').AsInteger;
  FCurrentPacienteNombre := Trim(DataSet.FieldByName('APPNOM').AsString);
  lblPacienteActivoHist.Caption := Format('Paciente Activo: [%d] %s',
    [FCurrentHistoria, FCurrentPacienteNombre]);
  LoadFichaPacienteDetalle(FCurrentHistoria);
end;

procedure TfrmMain.LoadFichaPacienteDetalle(AHistoria: Integer);
var
  LQry: TFDQuery;
  LBlobBytes: TBytes;
  LInfo: string;
begin
  LQry := TFDQuery.Create(nil);
  try
    LQry.Connection := dmMain.FDConn;
    LQry.SQL.Text :=
      'SELECT HISTORIA, NOMBRE, APP1, APP2, FNACI, SEXO, GS1, GS2, DNI, ' +
      'DIRECCION, POBLACION, CP, PROVINCIA, TELEFONO, MOVIL, EMAIL, POLIZA, ' +
      'LOPD, ALER, OBS, FOTO ' +
      'FROM gm_pacientes WHERE HISTORIA = :h';
    LQry.ParamByName('h').AsInteger := AHistoria;
    LQry.Open;
    if LQry.IsEmpty then
      Exit;

    edtHist.Text := IntToStr(LQry.FieldByName('HISTORIA').AsInteger);
    edtNombre.Text := Trim(LQry.FieldByName('NOMBRE').AsString);
    edtApp1.Text := Trim(LQry.FieldByName('APP1').AsString);
    edtApp2.Text := Trim(LQry.FieldByName('APP2').AsString);
    edtDNI.Text := Trim(LQry.FieldByName('DNI').AsString);
    if not LQry.FieldByName('FNACI').IsNull then
      edtFNaci.Text := FormatDateTime('yyyy-mm-dd', LQry.FieldByName('FNACI').AsDateTime)
    else
      edtFNaci.Text := '';
    cmbSexo.Text := Trim(LQry.FieldByName('SEXO').AsString);
    edtGrupoSang.Text := Trim(LQry.FieldByName('GS1').AsString) + Trim(LQry.FieldByName('GS2').AsString);
    edtDireccion.Text := Trim(LQry.FieldByName('DIRECCION').AsString);
    edtPoblacion.Text := Trim(LQry.FieldByName('POBLACION').AsString);
    edtCP.Text := Trim(LQry.FieldByName('CP').AsString);
    edtProvincia.Text := Trim(LQry.FieldByName('PROVINCIA').AsString);
    edtTelefono.Text := Trim(LQry.FieldByName('TELEFONO').AsString);
    edtMovil.Text := Trim(LQry.FieldByName('MOVIL').AsString);
    edtEmail.Text := Trim(LQry.FieldByName('EMAIL').AsString);
    edtPoliza.Text := Trim(LQry.FieldByName('POLIZA').AsString);
    chkLOPD.Checked := SameText(Trim(LQry.FieldByName('LOPD').AsString), 'S');
    memAlergias.Lines.Text := TSecurityCrypto.RtfToPlainText(LQry.FieldByName('ALER').AsString);
    memObsPaciente.Lines.Text := TSecurityCrypto.RtfToPlainText(LQry.FieldByName('OBS').AsString);

    imgFotoPaciente.Picture := nil;
    if not LQry.FieldByName('FOTO').IsNull then
    begin
      LBlobBytes := LQry.FieldByName('FOTO').AsBytes;
      if Length(LBlobBytes) > 0 then
        LoadPreviewBlobIntoImage(LBlobBytes, imgFotoPaciente, LInfo);
    end;
  finally
    LQry.Free;
  end;
end;

procedure TfrmMain.btnNuevoPacienteClick(Sender: TObject);
begin
  dmMain.TouchActivity;
  FIsNewPaciente := True;
  edtHist.Text := IntToStr(dmMain.GetNextId('gm_pacientes', 'HISTORIA'));
  edtNombre.Clear;
  edtApp1.Clear;
  edtApp2.Clear;
  edtDNI.Clear;
  edtFNaci.Text := FormatDateTime('yyyy-mm-dd', Date);
  cmbSexo.Text := 'M';
  edtGrupoSang.Clear;
  edtDireccion.Clear;
  edtPoblacion.Text := 'ASPE';
  edtCP.Text := '03680';
  edtProvincia.Text := 'ALICANTE';
  edtTelefono.Clear;
  edtMovil.Clear;
  edtEmail.Clear;
  edtPoliza.Clear;
  chkLOPD.Checked := True;
  memAlergias.Clear;
  memObsPaciente.Clear;
  imgFotoPaciente.Picture := nil;
  if edtNombre.CanFocus then
    edtNombre.SetFocus;
end;

procedure TfrmMain.btnGuardarPacienteClick(Sender: TObject);
var
  LQry: TFDQuery;
  LHist: Integer;
  LApellidos, LAppNom: string;
begin
  dmMain.TouchActivity;
  if Trim(edtNombre.Text) = '' then
  begin
    MessageDlg('El nombre del paciente es obligatorio.', mtWarning, [mbOK], 0);
    Exit;
  end;

  LHist := StrToIntDef(edtHist.Text, 0);
  if LHist <= 0 then
    LHist := dmMain.GetNextId('gm_pacientes', 'HISTORIA');

  LApellidos := Trim(Trim(edtApp1.Text) + ' ' + Trim(edtApp2.Text));
  LAppNom := Trim(LApellidos + ', ' + Trim(edtNombre.Text));

  LQry := TFDQuery.Create(nil);
  try
    LQry.Connection := dmMain.FDConn;
    if FIsNewPaciente then
      LQry.SQL.Text :=
        'INSERT INTO gm_pacientes (HISTORIA, NOMBRE, APP1, APP2, APELLIDOS, APPNOM, ' +
        'DNI, SEXO, DIRECCION, POBLACION, CP, PROVINCIA, TELEFONO, MOVIL, EMAIL, ' +
        'POLIZA, LOPD, ALER, OBS, SEGURO, TARIFA) ' +
        'VALUES (:hist, :nom, :app1, :app2, :apellidos, :appnom, ' +
        ':dni, :sexo, :dir, :pob, :cp, :prov, :tel, :mov, :email, ' +
        ':poliza, :lopd, :aler, :obs, 1, 0)'
    else
      LQry.SQL.Text :=
        'UPDATE gm_pacientes SET NOMBRE=:nom, APP1=:app1, APP2=:app2, ' +
        'APELLIDOS=:apellidos, APPNOM=:appnom, DNI=:dni, SEXO=:sexo, ' +
        'DIRECCION=:dir, POBLACION=:pob, CP=:cp, PROVINCIA=:prov, ' +
        'TELEFONO=:tel, MOVIL=:mov, EMAIL=:email, POLIZA=:poliza, ' +
        'LOPD=:lopd, ALER=:aler, OBS=:obs ' +
        'WHERE HISTORIA=:hist';

    LQry.ParamByName('hist').AsInteger := LHist;
    dmMain.SetParamString(LQry.ParamByName('nom'), Trim(edtNombre.Text));
    dmMain.SetParamString(LQry.ParamByName('app1'), Trim(edtApp1.Text));
    dmMain.SetParamString(LQry.ParamByName('app2'), Trim(edtApp2.Text));
    dmMain.SetParamString(LQry.ParamByName('apellidos'), Copy(LApellidos, 1, 61));
    dmMain.SetParamString(LQry.ParamByName('appnom'), Copy(LAppNom, 1, 93));
    dmMain.SetParamString(LQry.ParamByName('dni'), Trim(edtDNI.Text));
    dmMain.SetParamString(LQry.ParamByName('sexo'), Copy(Trim(cmbSexo.Text), 1, 1));
    dmMain.SetParamString(LQry.ParamByName('dir'), Trim(edtDireccion.Text));
    dmMain.SetParamString(LQry.ParamByName('pob'), Trim(edtPoblacion.Text));
    dmMain.SetParamString(LQry.ParamByName('cp'), Copy(Trim(edtCP.Text), 1, 5));
    dmMain.SetParamString(LQry.ParamByName('prov'), Trim(edtProvincia.Text));
    dmMain.SetParamString(LQry.ParamByName('tel'), Trim(edtTelefono.Text));
    dmMain.SetParamString(LQry.ParamByName('mov'), Trim(edtMovil.Text));
    dmMain.SetParamString(LQry.ParamByName('email'), Trim(edtEmail.Text));
    dmMain.SetParamString(LQry.ParamByName('poliza'), Trim(edtPoliza.Text));
    dmMain.SetParamString(LQry.ParamByName('lopd'), IfThen(chkLOPD.Checked, 'S', 'N'));
    dmMain.SetParamMemo(LQry.ParamByName('aler'), memAlergias.Lines.Text);
    dmMain.SetParamMemo(LQry.ParamByName('obs'), memObsPaciente.Lines.Text);
    LQry.ExecSQL;

    FIsNewPaciente := False;
    FCurrentHistoria := LHist;
    dmMain.RegistrarAuditoria(ACCION_GUARDAR_PACIENTE,
      Format('HIST=%d PACIENTE=%s', [LHist, LAppNom]));
    MessageDlg('Ficha clínica de paciente guardada y auditada correctamente.', mtInformation, [mbOK], 0);
    LoadPacientes;
  finally
    LQry.Free;
  end;
end;

procedure TfrmMain.btnIrHistoriaClick(Sender: TObject);
begin
  dmMain.TouchActivity;
  chkSoloPacienteActualVis.Checked := True;
  pgcMain.ActivePage := tsHistoria;
  LoadVisitas;
  if FCurrentHistoria > 0 then
    dmMain.RegistrarAuditoria(ACCION_VER_PACIENTE, Format('HIST=%d CONSULTA_HISTORIA', [FCurrentHistoria]));
end;

procedure TfrmMain.btnIrDocumentosPacClick(Sender: TObject);
begin
  dmMain.TouchActivity;
  chkSoloPacienteActualDoc.Checked := True;
  pgcMain.ActivePage := tsDocumentos;
  LoadDocumentos;
end;

procedure TfrmMain.chkSoloPacienteActualVisClick(Sender: TObject);
begin
  dmMain.TouchActivity;
  LoadVisitas;
end;

procedure TfrmMain.btnFiltrarVisitasClick(Sender: TObject);
begin
  dmMain.TouchActivity;
  LoadVisitas;
end;

procedure TfrmMain.LoadVisitas;
var
  LFiltro: string;
begin
  if not dmMain.FDConn.Connected then
    Exit;
  LFiltro := Trim(edtBuscarVisita.Text);
  qryVisitas.DisableControls;
  try
    qryVisitas.Close;
    qryVisitas.SQL.Text :=
      'SELECT v.ID, v.HISTORIA, p.APPNOM AS PACIENTE, v.FECHA, ' +
      '       m.NOMBRE AS FACULTATIVO, v.MOTIVOC, v.VISTO ' +
      'FROM gm_visitas v ' +
      'LEFT JOIN gm_pacientes p ON p.HISTORIA = v.HISTORIA ' +
      'LEFT JOIN gm_medicos m ON m.ID = v.MEDICO ' +
      'WHERE (:solo_pac = 0 OR v.HISTORIA = :hist) ' +
      '  AND (:filtro = '''' OR p.APPNOM LIKE :like_f OR v.MOTIVOC LIKE :like_f OR m.NOMBRE LIKE :like_f) ' +
      'ORDER BY v.ID DESC LIMIT 250';
    qryVisitas.ParamByName('solo_pac').AsInteger := IfThen(chkSoloPacienteActualVis.Checked and (FCurrentHistoria > 0), 1, 0);
    qryVisitas.ParamByName('hist').AsInteger := FCurrentHistoria;
    dmMain.SetParamString(qryVisitas.ParamByName('filtro'), LFiltro);
    dmMain.SetParamString(qryVisitas.ParamByName('like_f'), '%' + LFiltro + '%');
    qryVisitas.Open;
  finally
    qryVisitas.EnableControls;
  end;

  if not qryVisitas.IsEmpty then
    qryVisitasAfterScroll(qryVisitas)
  else
  begin
    FCurrentVisitaID := 0;
    edtMotivoVisita.Clear;
    memObsVisita.Clear;
    qryResultados.Close;
    memResultadoTexto.Clear;
  end;
end;

procedure TfrmMain.qryVisitasAfterScroll(DataSet: TDataSet);
var
  LQry: TFDQuery;
begin
  if DataSet.IsEmpty then
    Exit;
  FCurrentVisitaID := DataSet.FieldByName('ID').AsInteger;
  LQry := TFDQuery.Create(nil);
  try
    LQry.Connection := dmMain.FDConn;
    LQry.SQL.Text := 'SELECT MOTIVOC, OBS FROM gm_visitas WHERE ID = :id';
    LQry.ParamByName('id').AsInteger := FCurrentVisitaID;
    LQry.Open;
    if not LQry.IsEmpty then
    begin
      edtMotivoVisita.Text := Trim(LQry.FieldByName('MOTIVOC').AsString);
      memObsVisita.Lines.Text := TSecurityCrypto.RtfToPlainText(LQry.FieldByName('OBS').AsString);
    end;
  finally
    LQry.Free;
  end;
  LoadResultadosVisita(FCurrentVisitaID);
end;

procedure TfrmMain.LoadResultadosVisita(AVisitaID: Integer);
begin
  qryResultados.DisableControls;
  try
    qryResultados.Close;
    qryResultados.SQL.Text :=
      'SELECT r.ID, r.VISITA, r.PARRAFO, pa.NOMBRE AS SECCION, r.FECHA, m.NOMBRE AS MEDICO_NOM ' +
      'FROM gm_resultados r ' +
      'LEFT JOIN gm_parrafos pa ON pa.ID = r.PARRAFO ' +
      'LEFT JOIN gm_medicos m ON m.ID = r.MEDICO ' +
      'WHERE r.VISITA = :vis ' +
      'ORDER BY r.PARRAFO ASC, r.ID ASC';
    qryResultados.ParamByName('vis').AsInteger := AVisitaID;
    qryResultados.Open;
  finally
    qryResultados.EnableControls;
  end;

  if not qryResultados.IsEmpty then
    qryResultadosAfterScroll(qryResultados)
  else
    memResultadoTexto.Clear;
end;

procedure TfrmMain.qryResultadosAfterScroll(DataSet: TDataSet);
var
  LQry: TFDQuery;
  LParrafoID, I: Integer;
begin
  if DataSet.IsEmpty then
    Exit;
  LParrafoID := DataSet.FieldByName('PARRAFO').AsInteger;
  for I := 0 to cmbParrafoSeccion.Items.Count - 1 do
    if Integer(cmbParrafoSeccion.Items.Objects[I]) = LParrafoID then
    begin
      cmbParrafoSeccion.ItemIndex := I;
      Break;
    end;

  LQry := TFDQuery.Create(nil);
  try
    LQry.Connection := dmMain.FDConn;
    LQry.SQL.Text := 'SELECT MEMO FROM gm_resultados WHERE ID = :id';
    LQry.ParamByName('id').AsInteger := DataSet.FieldByName('ID').AsInteger;
    LQry.Open;
    if not LQry.IsEmpty then
      memResultadoTexto.Lines.Text := TSecurityCrypto.RtfToPlainText(LQry.FieldByName('MEMO').AsString);
  finally
    LQry.Free;
  end;
end;

procedure TfrmMain.btnNuevaVisitaClick(Sender: TObject);
var
  LQry: TFDQuery;
  LNewVisID, LMedID: Integer;
begin
  dmMain.TouchActivity;
  if FCurrentHistoria <= 0 then
  begin
    MessageDlg('Seleccione primero un paciente en la pestaña de Pacientes.', mtWarning, [mbOK], 0);
    Exit;
  end;

  LNewVisID := dmMain.GetNextId('gm_visitas', 'ID');
  LMedID := IfThen(dmMain.CurrentDoctorID > 0, dmMain.CurrentDoctorID, 3);
  LQry := TFDQuery.Create(nil);
  try
    LQry.Connection := dmMain.FDConn;
    LQry.SQL.Text :=
      'INSERT INTO gm_visitas (ID, HISTORIA, FECHA, MEDICO, SEGURO, TARIFA, VISTO, MOTIVOC, OBS, USRINS, FECINS) ' +
      'VALUES (:id, :hist, NOW(), :med, 1, 0, ''S'', :mot, :obs, :usr, NOW())';
    LQry.ParamByName('id').AsInteger := LNewVisID;
    LQry.ParamByName('hist').AsInteger := FCurrentHistoria;
    LQry.ParamByName('med').AsInteger := LMedID;
    dmMain.SetParamString(LQry.ParamByName('mot'), 'CONSULTA EN CLÍNICA');
    dmMain.SetParamMemo(LQry.ParamByName('obs'), '');
    LQry.ParamByName('usr').AsInteger := LMedID;
    LQry.ExecSQL;

    dmMain.RegistrarAuditoria(ACCION_GUARDAR_VISITA,
      Format('HIST=%d VISITA=%d NUEVA_VISITA', [FCurrentHistoria, LNewVisID]));
    LoadVisitas;
  finally
    LQry.Free;
  end;
end;

procedure TfrmMain.btnGuardarVisitaClick(Sender: TObject);
var
  LQry: TFDQuery;
begin
  dmMain.TouchActivity;
  if FCurrentVisitaID <= 0 then
    Exit;
  LQry := TFDQuery.Create(nil);
  try
    LQry.Connection := dmMain.FDConn;
    LQry.SQL.Text :=
      'UPDATE gm_visitas SET MOTIVOC = :mot, OBS = :obs, USRMOD = :usr, FECMOD = NOW() ' +
      'WHERE ID = :id';
    dmMain.SetParamString(LQry.ParamByName('mot'), Trim(edtMotivoVisita.Text));
    dmMain.SetParamMemo(LQry.ParamByName('obs'), memObsVisita.Lines.Text);
    LQry.ParamByName('usr').AsInteger := dmMain.CurrentDoctorID;
    LQry.ParamByName('id').AsInteger := FCurrentVisitaID;
    LQry.ExecSQL;

    dmMain.RegistrarAuditoria(ACCION_GUARDAR_VISITA,
      Format('HIST=%d VISITA=%d MOD_EVOLUCION', [FCurrentHistoria, FCurrentVisitaID]));
    MessageDlg('Evolución clínica de la visita actualizada y auditada.', mtInformation, [mbOK], 0);
    LoadVisitas;
  finally
    LQry.Free;
  end;
end;

procedure TfrmMain.btnGuardarResultadoClick(Sender: TObject);
var
  LQry: TFDQuery;
  LParrafoID, LNewResID, LMedID: Integer;
begin
  dmMain.TouchActivity;
  if (FCurrentVisitaID <= 0) or (cmbParrafoSeccion.ItemIndex < 0) then
  begin
    MessageDlg('Seleccione una visita activa y una sección clínica.', mtWarning, [mbOK], 0);
    Exit;
  end;

  LParrafoID := Integer(cmbParrafoSeccion.Items.Objects[cmbParrafoSeccion.ItemIndex]);
  LMedID := IfThen(dmMain.CurrentDoctorID > 0, dmMain.CurrentDoctorID, 3);

  LQry := TFDQuery.Create(nil);
  try
    LQry.Connection := dmMain.FDConn;
    if (not qryResultados.IsEmpty) and (qryResultados.FieldByName('PARRAFO').AsInteger = LParrafoID) then
    begin
      LQry.SQL.Text := 'UPDATE gm_resultados SET MEMO = :memo, FECHA = NOW() WHERE ID = :id';
      dmMain.SetParamMemo(LQry.ParamByName('memo'), memResultadoTexto.Lines.Text);
      LQry.ParamByName('id').AsInteger := qryResultados.FieldByName('ID').AsInteger;
      LQry.ExecSQL;
    end
    else
    begin
      LNewResID := dmMain.GetNextId('gm_resultados', 'ID');
      LQry.SQL.Text :=
        'INSERT INTO gm_resultados (ID, VISITA, MEDICO, PARRAFO, FECHA, ACTIVO, MEMO) ' +
        'VALUES (:id, :vis, :med, :par, NOW(), ''S'', :memo)';
      LQry.ParamByName('id').AsInteger := LNewResID;
      LQry.ParamByName('vis').AsInteger := FCurrentVisitaID;
      LQry.ParamByName('med').AsInteger := LMedID;
      LQry.ParamByName('par').AsInteger := LParrafoID;
      dmMain.SetParamMemo(LQry.ParamByName('memo'), memResultadoTexto.Lines.Text);
      LQry.ExecSQL;
    end;

    dmMain.RegistrarAuditoria(ACCION_VER_VISITA,
      Format('HIST=%d VISITA=%d SECCION=%d GUARDADA', [FCurrentHistoria, FCurrentVisitaID, LParrafoID]));
    LoadResultadosVisita(FCurrentVisitaID);
  finally
    LQry.Free;
  end;
end;

procedure TfrmMain.LoadAgenda;
var
  LFiltro: string;
  F: TField;
begin
  if not dmMain.FDConn.Connected then
    Exit;
  LFiltro := Trim(edtBuscarCita.Text);
  qryAgenda.DisableControls;
  try
    qryAgenda.Close;
    qryAgenda.SQL.Text :=
      'SELECT ID, IDAGENDA, DATE(FECHA) AS DIA, CONCAT(HORAINI, '':'', MININI) AS HORA, ' +
      '       HISTORIA, NOMBRE, APP1, APP2, TELEFONO, MOTIVOC, VISTO ' +
      'FROM gm_apuntes ' +
      'WHERE (:f = '''' OR NOMBRE LIKE :lf OR APP1 LIKE :lf OR APP2 LIKE :lf OR MOTIVOC LIKE :lf OR CAST(FECHA AS CHAR) LIKE :lf) ' +
      'ORDER BY FECHA DESC, HORAINI DESC, MININI DESC LIMIT 300';
    dmMain.SetParamString(qryAgenda.ParamByName('f'), LFiltro);
    dmMain.SetParamString(qryAgenda.ParamByName('lf'), '%' + LFiltro + '%');
    qryAgenda.Open;

    F := qryAgenda.FindField('TELEFONO');
    if F <> nil then
      F.OnGetText := FieldPhoneGetText;
  finally
    qryAgenda.EnableControls;
  end;
end;

procedure TfrmMain.btnFiltrarCitasClick(Sender: TObject);
begin
  dmMain.TouchActivity;
  LoadAgenda;
end;

procedure TfrmMain.btnMarcarVistoClick(Sender: TObject);
var
  LQry: TFDQuery;
  LID: Integer;
  LNuevoVisto: string;
begin
  dmMain.TouchActivity;
  if qryAgenda.IsEmpty then
    Exit;
  LID := qryAgenda.FieldByName('ID').AsInteger;
  if SameText(Trim(qryAgenda.FieldByName('VISTO').AsString), 'S') then
    LNuevoVisto := 'N'
  else
    LNuevoVisto := 'S';

  LQry := TFDQuery.Create(nil);
  try
    LQry.Connection := dmMain.FDConn;
    LQry.SQL.Text := 'UPDATE gm_apuntes SET VISTO = :v, FECMOD = NOW() WHERE ID = :id';
    dmMain.SetParamString(LQry.ParamByName('v'), LNuevoVisto);
    LQry.ParamByName('id').AsInteger := LID;
    LQry.ExecSQL;
    LoadAgenda;
  finally
    LQry.Free;
  end;
end;

procedure TfrmMain.LoadDocumentos;
var
  LFiltro: string;
begin
  if not dmMain.FDConn.Connected then
    Exit;
  LFiltro := Trim(edtBuscarDoc.Text);
  qryDocumentos.DisableControls;
  try
    qryDocumentos.Close;
    qryDocumentos.SQL.Text :=
      'SELECT d.ID, d.FECHA, d.IDTIPO1 AS HISTORIA, p.APPNOM AS PACIENTE, ' +
      '       d.ORIGEN, d.ARCHIVO, d.DESCRIPCION, ROUND(LENGTH(d.DOCUMENTO)/1024, 1) AS KB ' +
      'FROM gd_documentos d ' +
      'LEFT JOIN gm_pacientes p ON p.HISTORIA = d.IDTIPO1 ' +
      'WHERE (:solo_pac = 0 OR d.IDTIPO1 = :hist) ' +
      '  AND (:f = '''' OR d.DESCRIPCION LIKE :lf OR d.ARCHIVO LIKE :lf OR CAST(d.IDTIPO1 AS CHAR) = :f) ' +
      'ORDER BY d.ID DESC LIMIT 250';
    qryDocumentos.ParamByName('solo_pac').AsInteger := IfThen(chkSoloPacienteActualDoc.Checked and (FCurrentHistoria > 0), 1, 0);
    qryDocumentos.ParamByName('hist').AsInteger := FCurrentHistoria;
    dmMain.SetParamString(qryDocumentos.ParamByName('f'), LFiltro);
    dmMain.SetParamString(qryDocumentos.ParamByName('lf'), '%' + LFiltro + '%');
    qryDocumentos.Open;
  finally
    qryDocumentos.EnableControls;
  end;

  if not qryDocumentos.IsEmpty then
    qryDocumentosAfterScroll(qryDocumentos)
  else
    imgDocumento.Picture := nil;
end;

procedure TfrmMain.chkSoloPacienteActualDocClick(Sender: TObject);
begin
  dmMain.TouchActivity;
  LoadDocumentos;
end;

procedure TfrmMain.btnFiltrarDocsClick(Sender: TObject);
begin
  dmMain.TouchActivity;
  LoadDocumentos;
end;

procedure TfrmMain.LoadPreviewBlobIntoImage(const ABytes: TBytes; AImage: TImage; out AInfoText: string);
var
  LMem: TMemoryStream;
  LJpg: TJPEGImage;
  LBmp: Vcl.Graphics.TBitmap;
begin
  AImage.Picture := nil;
  AInfoText := '';
  if Length(ABytes) < 4 then
    Exit;

  LMem := TMemoryStream.Create;
  try
    LMem.WriteBuffer(ABytes[0], Length(ABytes));
    LMem.Position := 0;

    // Detectar cabecera JPEG ($FF $D8)
    if (ABytes[0] = $FF) and (ABytes[1] = $D8) then
    begin
      LJpg := TJPEGImage.Create;
      try
        LJpg.LoadFromStream(LMem);
        AImage.Picture.Assign(LJpg);
        AInfoText := Format('Imagen JPEG en memoria (%d KB) — Acceso Auditado RGPD', [Length(ABytes) div 1024]);
      finally
        LJpg.Free;
      end;
    end
    // Detectar cabecera BMP ('BM')
    else if (ABytes[0] = Ord('B')) and (ABytes[1] = Ord('M')) then
    begin
      LBmp := Vcl.Graphics.TBitmap.Create;
      try
        LBmp.LoadFromStream(LMem);
        AImage.Picture.Assign(LBmp);
        AInfoText := Format('Imagen BMP en memoria (%d KB) — Acceso Auditado RGPD', [Length(ABytes) div 1024]);
      finally
        LBmp.Free;
      end;
    end
    // Detectar PDF ('%PDF')
    else if (ABytes[0] = Ord('%')) and (ABytes[1] = Ord('P')) and (ABytes[2] = Ord('D')) then
      AInfoText := Format('Documento PDF (%d KB) — Pulse "Exportar / Abrir Auditado" para visualizar', [Length(ABytes) div 1024])
    else
      AInfoText := Format('Documento binario (%d KB) — Pulse "Exportar / Abrir Auditado"', [Length(ABytes) div 1024]);
  finally
    LMem.Free;
  end;
end;

procedure TfrmMain.qryDocumentosAfterScroll(DataSet: TDataSet);
var
  LQry: TFDQuery;
  LBytes: TBytes;
  LInfo: string;
begin
  if DataSet.IsEmpty then
    Exit;
  LQry := TFDQuery.Create(nil);
  try
    LQry.Connection := dmMain.FDConn;
    LQry.SQL.Text := 'SELECT DOCUMENTO, ARCHIVO, DESCRIPCION FROM gd_documentos WHERE ID = :id';
    LQry.ParamByName('id').AsInteger := DataSet.FieldByName('ID').AsInteger;
    LQry.Open;
    if not LQry.IsEmpty and (not LQry.FieldByName('DOCUMENTO').IsNull) then
    begin
      LBytes := LQry.FieldByName('DOCUMENTO').AsBytes;
      LoadPreviewBlobIntoImage(LBytes, imgDocumento, LInfo);
      lblInfoVisorDoc.Caption := Format('[ID %d] %s — %s',
        [DataSet.FieldByName('ID').AsInteger,
         Trim(LQry.FieldByName('ARCHIVO').AsString),
         LInfo]);
    end;
  finally
    LQry.Free;
  end;
end;

procedure TfrmMain.btnAdjuntarDocClick(Sender: TObject);
var
  LQry: TFDQuery;
  LNewID: Integer;
  LDesc: string;
begin
  dmMain.TouchActivity;
  if FCurrentHistoria <= 0 then
  begin
    MessageDlg('Seleccione un paciente antes de adjuntar documentación clínica.', mtWarning, [mbOK], 0);
    Exit;
  end;
  if not OpenDialogDoc.Execute then
    Exit;

  LDesc := InputBox('Adjuntar Documento Médico (RGPD)',
    'Descripción del documento para la Historia #' + IntToStr(FCurrentHistoria) + ':',
    ExtractFileName(OpenDialogDoc.FileName));

  LNewID := dmMain.GetNextId('gd_documentos', 'ID');
  LQry := TFDQuery.Create(nil);
  try
    LQry.Connection := dmMain.FDConn;
    LQry.SQL.Text :=
      'INSERT INTO gd_documentos (ID, DOCUMENTO, ORIGEN, ARCHIVO, DESCRIPCION, FECHA, INDICE, TIPO, IDTIPO1, IDTIPO2, IDTIPO3) ' +
      'VALUES (:id, :doc, ''Archivo'', :arch, :desc, NOW(), 0, ''VIS'', :hist, 0, 0)';
    LQry.ParamByName('id').AsInteger := LNewID;
    LQry.ParamByName('doc').LoadFromFile(OpenDialogDoc.FileName, ftBlob);
    dmMain.SetParamString(LQry.ParamByName('arch'), ExtractFileName(OpenDialogDoc.FileName));
    dmMain.SetParamString(LQry.ParamByName('desc'), LDesc);
    LQry.ParamByName('hist').AsInteger := FCurrentHistoria;
    LQry.ExecSQL;

    dmMain.RegistrarAuditoria(ACCION_ALTA_DOCUMENTO,
      Format('HIST=%d ARCH=%s DES=%s', [FCurrentHistoria, ExtractFileName(OpenDialogDoc.FileName), LDesc]));
    LoadDocumentos;
  finally
    LQry.Free;
  end;
end;

procedure TfrmMain.btnExportarDocClick(Sender: TObject);
var
  LQry: TFDQuery;
  LBytes: TBytes;
  LStream: TFileStream;
begin
  dmMain.TouchActivity;
  if qryDocumentos.IsEmpty then
    Exit;
  SaveDialogDoc.FileName := Trim(qryDocumentos.FieldByName('ARCHIVO').AsString);
  if SaveDialogDoc.FileName = '' then
    SaveDialogDoc.FileName := Format('doc_%d.jpg', [qryDocumentos.FieldByName('ID').AsInteger]);
  if not SaveDialogDoc.Execute then
    Exit;

  LQry := TFDQuery.Create(nil);
  try
    LQry.Connection := dmMain.FDConn;
    LQry.SQL.Text := 'SELECT DOCUMENTO FROM gd_documentos WHERE ID = :id';
    LQry.ParamByName('id').AsInteger := qryDocumentos.FieldByName('ID').AsInteger;
    LQry.Open;
    if not LQry.IsEmpty then
    begin
      LBytes := LQry.FieldByName('DOCUMENTO').AsBytes;
      LStream := TFileStream.Create(SaveDialogDoc.FileName, fmCreate);
      try
        if Length(LBytes) > 0 then
          LStream.WriteBuffer(LBytes[0], Length(LBytes));
      finally
        LStream.Free;
      end;
      dmMain.RegistrarAuditoria(ACCION_VER_DOCUMENTO,
        Format('HIST=%d DOC=%d EXPORTADO=%s',
          [qryDocumentos.FieldByName('HISTORIA').AsInteger,
           qryDocumentos.FieldByName('ID').AsInteger,
           ExtractFileName(SaveDialogDoc.FileName)]));
      ShellExecute(Handle, 'open', PChar(SaveDialogDoc.FileName), nil, nil, SW_SHOWNORMAL);
    end;
  finally
    LQry.Free;
  end;
end;

procedure TfrmMain.LoadFacturacionYServicios;
begin
  if not dmMain.FDConn.Connected then
    Exit;
  qryFacturas.DisableControls;
  try
    qryFacturas.Close;
    qryFacturas.SQL.Text :=
      'SELECT f.ID, e.NOMBRE AS EMPRESA_NOM, f.SERIE, f.FACTURA, f.FECHA, ' +
      '       df.NOMBRE AS CLIENTE_FISCAL, df.NIF, f.BIMP1 AS BASE, f.IRPFIMP, f.IMPORTE AS TOTAL ' +
      'FROM gm_fracab f ' +
      'LEFT JOIN gm_empresas e ON e.ID = f.IDEMPRESA ' +
      'LEFT JOIN gm_datosfactura df ON df.IDFRA = f.ID ' +
      'ORDER BY f.FECHA DESC, f.FACTURA DESC';
    qryFacturas.Open;
  finally
    qryFacturas.EnableControls;
  end;

  if not qryFacturas.IsEmpty then
    qryFacturasAfterScroll(qryFacturas);

  qryServicios.DisableControls;
  try
    qryServicios.Close;
    qryServicios.SQL.Text := 'SELECT * FROM gm_vw_sercia ORDER BY CODIGO ASC';
    qryServicios.Open;
  finally
    qryServicios.EnableControls;
  end;
end;

procedure TfrmMain.qryFacturasAfterScroll(DataSet: TDataSet);
begin
  if DataSet.IsEmpty then
    Exit;
  qryLineasFactura.DisableControls;
  try
    qryLineasFactura.Close;
    qryLineasFactura.SQL.Text :=
      'SELECT l.ID, l.CODSER, l.OBS AS CONCEPTO, l.CANT, l.PVP, m.NOMBRE AS MEDICO_NOM ' +
      'FROM gm_fralin l ' +
      'LEFT JOIN gm_medicos m ON m.ID = l.IDMEDICO ' +
      'WHERE l.IDFRA = :idfra ORDER BY l.ID ASC';
    qryLineasFactura.ParamByName('idfra').AsInteger := DataSet.FieldByName('ID').AsInteger;
    qryLineasFactura.Open;
  finally
    qryLineasFactura.EnableControls;
  end;
end;

procedure TfrmMain.LoadAuditoriaRGPD;
var
  LFiltro: string;
begin
  if not dmMain.FDConn.Connected then
    Exit;
  LFiltro := Trim(edtBuscarAuditoria.Text);
  qryAuditoria.DisableControls;
  try
    qryAuditoria.Close;
    qryAuditoria.SQL.Text :=
      'SELECT l.FECHA, l.USUARIO, COALESCE(m.NOMBRE, ''SISTEMA / ADMIN'') AS PROFESIONAL, ' +
      '       l.ACCION, l.IP4, l.PC, l.COMENTARIO ' +
      'FROM gl_tabla l ' +
      'LEFT JOIN gm_medicos m ON m.ID = l.USUARIO ' +
      'WHERE (:f = '''' OR l.COMENTARIO LIKE :lf OR l.PC LIKE :lf OR l.IP4 LIKE :lf OR m.NOMBRE LIKE :lf) ' +
      'ORDER BY l.FECHA DESC LIMIT 400';
    dmMain.SetParamString(qryAuditoria.ParamByName('f'), LFiltro);
    dmMain.SetParamString(qryAuditoria.ParamByName('lf'), '%' + LFiltro + '%');
    qryAuditoria.Open;
  finally
    qryAuditoria.EnableControls;
  end;
end;

procedure TfrmMain.btnFiltrarAuditoriaClick(Sender: TObject);
begin
  dmMain.TouchActivity;
  LoadAuditoriaRGPD;
end;

end.
