unit uFrmLogin;

interface

uses
  Winapi.Windows, Winapi.Messages, System.SysUtils, System.StrUtils, System.UITypes, System.Classes,
  Vcl.Graphics, Vcl.Controls, Vcl.Forms, Vcl.Dialogs, Vcl.StdCtrls, Vcl.ExtCtrls,
  FireDAC.Comp.Client, FireDAC.Stan.Param, Data.DB,
  uSecurityCrypto, uDMMain, uFrmConfigDB;

type
  TfrmLogin = class(TForm)
    pnlTop: TPanel;
    lblTitle: TLabel;
    lblSub: TLabel;
    pnlBody: TPanel;
    lblMedico: TLabel;
    lblEspecialidad: TLabel;
    lblPassword: TLabel;
    lblEstadoBD: TLabel;
    cmbMedico: TComboBox;
    chkMostrarTodos: TCheckBox;
    edtPassword: TEdit;
    chkUpgradeSHA256: TCheckBox;
    pnlBottom: TPanel;
    btnConfigDB: TButton;
    btnEntrar: TButton;
    btnSalir: TButton;
    procedure FormShow(Sender: TObject);
    procedure chkMostrarTodosClick(Sender: TObject);
    procedure cmbMedicoChange(Sender: TObject);
    procedure btnConfigDBClick(Sender: TObject);
    procedure btnEntrarClick(Sender: TObject);
  private
    FFailedAttempts: Integer;
    procedure LoadDoctorsList;
    procedure EnsureDatabaseConnected;
  protected
    procedure CreateParams(var Params: TCreateParams); override;
  public
  end;

implementation

{$R *.dfm}

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

procedure TfrmLogin.FormShow(Sender: TObject);
begin
  FFailedAttempts := 0;
  EnsureDatabaseConnected;
end;

procedure TfrmLogin.EnsureDatabaseConnected;
var
  LErr: string;
  LFrmCfg: TfrmConfigDB;
begin
  if dmMain.ConnectDatabase(LErr) then
  begin
    lblEstadoBD.Font.Color := $00287D1E;
    lblEstadoBD.Caption := Format('Conectado de forma segura a %s (%s) | Config: santias_db.enc',
      [dmMain.Config.Database, dmMain.Config.Host]);
    LoadDoctorsList;
  end
  else
  begin
    lblEstadoBD.Font.Color := clRed;
    lblEstadoBD.Caption := 'Sin conexión a BD. Configure las credenciales encriptadas.';
    MessageDlg('No se pudo establecer conexión con la base de datos clínica:' + sLineBreak +
      LErr + sLineBreak + sLineBreak +
      'Se abrirá el asistente de Configuración Encriptada de Base de Datos.',
      mtWarning, [mbOK], 0);
    LFrmCfg := TfrmConfigDB.Create(Self);
    try
      if LFrmCfg.ShowModal = mrOk then
        LoadDoctorsList;
    finally
      LFrmCfg.Free;
    end;
  end;
end;

procedure TfrmLogin.LoadDoctorsList;
var
  LQry: TFDQuery;
  LLabel: string;
begin
  cmbMedico.Items.BeginUpdate;
  try
    cmbMedico.Items.Clear;
    if not dmMain.FDConn.Connected then
      Exit;

    LQry := TFDQuery.Create(nil);
    try
      LQry.Connection := dmMain.FDConn;
      if chkMostrarTodos.Checked then
        LQry.SQL.Text :=
          'SELECT ID, NOMBRE, ESPECIALIDAD, COLEGIADO, ACTIVO ' +
          'FROM gm_medicos ORDER BY ACTIVO DESC, NOMBRE ASC'
      else
        LQry.SQL.Text :=
          'SELECT ID, NOMBRE, ESPECIALIDAD, COLEGIADO, ACTIVO ' +
          'FROM gm_medicos WHERE ACTIVO = ''S'' ORDER BY NOMBRE ASC';
      LQry.Open;
      while not LQry.Eof do
      begin
        LLabel := Trim(LQry.FieldByName('NOMBRE').AsString);
        if Trim(LQry.FieldByName('ESPECIALIDAD').AsString) <> '' then
          LLabel := LLabel + ' — ' + Trim(LQry.FieldByName('ESPECIALIDAD').AsString);
        cmbMedico.Items.AddObject(LLabel, TObject(LQry.FieldByName('ID').AsInteger));
        LQry.Next;
      end;
    finally
      LQry.Free;
    end;

    cmbMedico.Items.AddObject('ADMINISTRACIÓN GENERAL / DIRECCIÓN MÉDICA', TObject(0));
    if cmbMedico.Items.Count > 0 then
    begin
      cmbMedico.ItemIndex := 0;
      cmbMedicoChange(nil);
    end;
  finally
    cmbMedico.Items.EndUpdate;
  end;
end;

procedure TfrmLogin.chkMostrarTodosClick(Sender: TObject);
begin
  LoadDoctorsList;
end;

procedure TfrmLogin.cmbMedicoChange(Sender: TObject);
var
  LDocID: Integer;
  LQry: TFDQuery;
  LHasEmptyPwd: Boolean;
begin
  if cmbMedico.ItemIndex < 0 then
    Exit;
  LDocID := Integer(cmbMedico.Items.Objects[cmbMedico.ItemIndex]);
  if LDocID = 0 then
  begin
    lblEspecialidad.Caption := 'Perfil: Administración y Auditoría RGPD de Clínica';
    Exit;
  end;

  if not dmMain.FDConn.Connected then
    Exit;

  LQry := TFDQuery.Create(nil);
  try
    LQry.Connection := dmMain.FDConn;
    LQry.SQL.Text := 'SELECT ESPECIALIDAD, COLEGIADO, CONTRAS FROM gm_medicos WHERE ID = :id';
    LQry.ParamByName('id').AsInteger := LDocID;
    LQry.Open;
    if not LQry.IsEmpty then
    begin
      LHasEmptyPwd := TSecurityCrypto.VerifyDoctorPassword('', LQry.FieldByName('CONTRAS').AsString);
      lblEspecialidad.Caption := Format('Especialidad: %s | Colegiado: %s | Clave: %s',
        [ IfThen(Trim(LQry.FieldByName('ESPECIALIDAD').AsString) <> '', Trim(LQry.FieldByName('ESPECIALIDAD').AsString), 'General'),
         IfThen(Trim(LQry.FieldByName('COLEGIADO').AsString) <> '', Trim(LQry.FieldByName('COLEGIADO').AsString), 'S/N'),
         IfThen(LHasEmptyPwd, 'Sin clave requerida', 'Protegido con clave')]);
    end;
  finally
    LQry.Free;
  end;
end;

procedure TfrmLogin.btnConfigDBClick(Sender: TObject);
var
  LFrmCfg: TfrmConfigDB;
begin
  LFrmCfg := TfrmConfigDB.Create(Self);
  try
    if LFrmCfg.ShowModal = mrOk then
      EnsureDatabaseConnected;
  finally
    LFrmCfg.Free;
  end;
end;

procedure TfrmLogin.btnEntrarClick(Sender: TObject);
var
  LDocID: Integer;
  LQry, LQryUpd: TFDQuery;
  LStoredContras, LNewHash: string;
  LValid: Boolean;
begin
  if not dmMain.FDConn.Connected then
  begin
    EnsureDatabaseConnected;
    Exit;
  end;

  if cmbMedico.ItemIndex < 0 then
  begin
    MessageDlg('Seleccione un facultativo para iniciar sesión.', mtWarning, [mbOK], 0);
    Exit;
  end;

  LDocID := Integer(cmbMedico.Items.Objects[cmbMedico.ItemIndex]);
  LQry := TFDQuery.Create(nil);
  try
    LQry.Connection := dmMain.FDConn;
    if LDocID = 0 then
    begin
      LQry.SQL.Text := 'SELECT PWDADM FROM gm_config WHERE ID = 1';
      LQry.Open;
      LStoredContras := '';
      if not LQry.IsEmpty then
        LStoredContras := LQry.FieldByName('PWDADM').AsString;
      LValid := TSecurityCrypto.VerifyDoctorPassword(edtPassword.Text, LStoredContras);
      if LValid then
      begin
        dmMain.CurrentDoctorID := -1;
        dmMain.CurrentDoctorName := 'ADMINISTRADOR RGPD';
        dmMain.CurrentDoctorSpecialty := 'DIRECCIÓN CLÍNICA';
        dmMain.CurrentDoctorColegiado := 'ADM';
        dmMain.TouchActivity;
        dmMain.RegistrarAuditoria(ACCION_LOGIN, 'LOGIN_OK PERFIL=ADMINISTRADOR');
        ModalResult := mrOk;
        Exit;
      end;
    end
    else
    begin
      LQry.SQL.Text :=
        'SELECT ID, NOMBRE, ESPECIALIDAD, COLEGIADO, CONTRAS, BLOQUEADO ' +
        'FROM gm_medicos WHERE ID = :id';
      LQry.ParamByName('id').AsInteger := LDocID;
      LQry.Open;
      if not LQry.IsEmpty then
      begin
        if SameText(Trim(LQry.FieldByName('BLOQUEADO').AsString), 'S') then
        begin
          MessageDlg('Esta cuenta de facultativo se encuentra bloqueada por seguridad.', mtError, [mbOK], 0);
          Exit;
        end;
        LStoredContras := LQry.FieldByName('CONTRAS').AsString;
        LValid := TSecurityCrypto.VerifyDoctorPassword(edtPassword.Text, LStoredContras);
        if LValid then
        begin
          if chkUpgradeSHA256.Checked and (Trim(edtPassword.Text) <> '') and
             (Copy(Trim(LStoredContras), 1, 2) <> 'S$') then
          begin
            LNewHash := TSecurityCrypto.HashPasswordSHA256(edtPassword.Text);
            LQryUpd := TFDQuery.Create(nil);
            try
              LQryUpd.Connection := dmMain.FDConn;
              LQryUpd.SQL.Text := 'UPDATE gm_medicos SET CONTRAS = :c, UACPWDFECHA = NOW() WHERE ID = :id';
              dmMain.SetParamString(LQryUpd.ParamByName('c'), LNewHash);
              LQryUpd.ParamByName('id').AsInteger := LDocID;
              LQryUpd.ExecSQL;
            finally
              LQryUpd.Free;
            end;
          end;

          dmMain.CurrentDoctorID := LDocID;
          dmMain.CurrentDoctorName := Trim(LQry.FieldByName('NOMBRE').AsString);
          dmMain.CurrentDoctorSpecialty := Trim(LQry.FieldByName('ESPECIALIDAD').AsString);
          dmMain.CurrentDoctorColegiado := Trim(LQry.FieldByName('COLEGIADO').AsString);
          dmMain.TouchActivity;
          dmMain.RegistrarAuditoria(ACCION_LOGIN,
            Format('LOGIN_OK MEDICO=%d (%s)', [LDocID, dmMain.CurrentDoctorName]));
          ModalResult := mrOk;
          Exit;
        end;
      end;
    end;

    Inc(FFailedAttempts);
    dmMain.RegistrarAuditoria(ACCION_LOGIN,
      Format('LOGIN_FALLIDO MEDICO=%d INTENTO=%d', [LDocID, FFailedAttempts]));
    if FFailedAttempts >= 5 then
    begin
      MessageDlg('Se ha superado el número máximo de intentos de acceso permitidos.', mtError, [mbOK], 0);
      ModalResult := mrCancel;
    end
    else
      MessageDlg(Format('Contraseña médica incorrecta (Intento %d de 5).', [FFailedAttempts]),
        mtWarning, [mbOK], 0);
  finally
    LQry.Free;
  end;
end;

end.
