unit frm_OrdenesProduccion;

interface

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

type
  TfrmOrdenesProduccion = class(TfrmBaseList)
    lblFiltroEstado: TLabel;
    cbFiltroEstado: TComboBox;
    lblFiltroObrador: TLabel;
    cbFiltroObrador: TComboBox;
    procedure FormShow(Sender: TObject);
    procedure FormDestroy(Sender: TObject);
    procedure btnRefreshClick(Sender: TObject); override;
    procedure btnNewClick(Sender: TObject); override;
    procedure btnEditClick(Sender: TObject); override;
    procedure btnDeleteClick(Sender: TObject); override;
    procedure cbFiltroEstadoChange(Sender: TObject);
    procedure cbFiltroObradorChange(Sender: TObject);
    procedure dbGridMainDrawColumnCell(Sender: TObject; const Rect: TRect;
      DataCol: Integer; Column: TColumn; State: TGridDrawState);
  private
    procedure CargarObradores;
  public
    { Public declarations }
  end;

var
  frmOrdenesProduccion: TfrmOrdenesProduccion;

implementation

uses
  dmg_Main, frm_OrdenProduccionEditor;

{$R *.dfm}

procedure TfrmOrdenesProduccion.FormShow(Sender: TObject);
begin
  inherited;
  frmOrdenesProduccion := Self;
  OnDestroy := FormDestroy;
  pnlSearch.Visible := True;
  lblSearch.Caption := 'Buscar Orden/Cliente:';

  if Assigned(cbFiltroEstado) and (cbFiltroEstado.ItemIndex < 0) then
    cbFiltroEstado.ItemIndex := 0;

  CargarObradores;
  btnRefreshClick(nil);
end;

procedure TfrmOrdenesProduccion.FormDestroy(Sender: TObject);
begin
  if frmOrdenesProduccion = Self then
    frmOrdenesProduccion := nil;
end;

procedure TfrmOrdenesProduccion.CargarObradores;
var
  Qry: TFDQuery;
  LId: Integer;
  LNom: string;
begin
  if not Assigned(cbFiltroObrador) then Exit;

  cbFiltroObrador.Items.BeginUpdate;
  try
    cbFiltroObrador.Items.Clear;
    cbFiltroObrador.Items.AddObject('[Todos los Obradores]', TObject(IntPtr(0)));

    Qry := TFDQuery.Create(nil);
    try
      Qry.Connection := dmgMain.dbConn;
      Qry.SQL.Text := 'SELECT id, nombre FROM ge_obradores WHERE activo = 1 ORDER BY nombre ASC';
      Qry.Open;
      while not Qry.Eof do
      begin
        LId := Qry.FieldByName('id').AsInteger;
        LNom := Qry.FieldByName('nombre').AsString;
        cbFiltroObrador.Items.AddObject(LNom, TObject(IntPtr(LId)));
        Qry.Next;
      end;
    finally
      Qry.Free;
    end;

    cbFiltroObrador.ItemIndex := 0;
  finally
    cbFiltroObrador.Items.EndUpdate;
  end;
end;

procedure TfrmOrdenesProduccion.cbFiltroEstadoChange(Sender: TObject);
begin
  btnRefreshClick(nil);
end;

procedure TfrmOrdenesProduccion.cbFiltroObradorChange(Sender: TObject);
begin
  btnRefreshClick(nil);
end;

procedure TfrmOrdenesProduccion.btnRefreshClick(Sender: TObject);
var
  LSql: string;
  LObrId: Integer;
begin
  FQryMain.Close;
  LSql :=
    'SELECT op.id, op.numero_orden, op.fecha_orden, op.fecha_produccion, op.fecha_entrega_prevista, ' +
    '       op.id_pedido, p.numero_pedido, ' +
    '       COALESCE(NULLIF(c.nombre_comercial, ''''), c.nombre_fiscal, '''') AS cliente_nombre, ' +
    '       op.id_obrador, o.nombre AS obrador_nombre, ' +
    '       op.estado, op.prioridad, op.observaciones, ' +
    '       (SELECT COUNT(*) FROM ge_ordenes_produccion_lineas opl WHERE opl.id_orden = op.id) AS total_lineas, ' +
    '       (SELECT COALESCE(SUM(opl.cantidad), 0) FROM ge_ordenes_produccion_lineas opl WHERE opl.id_orden = op.id) AS total_unidades ' +
    'FROM ge_ordenes_produccion op ' +
    'LEFT JOIN ge_pedidos p ON op.id_pedido = p.id ' +
    'LEFT JOIN ge_clientes c ON p.cliente_id = c.id ' +
    'LEFT JOIN ge_obradores o ON op.id_obrador = o.id ' +
    'WHERE (op.empresa_id = :emp OR :emp = 0) ';

  if Trim(edtSearch.Text) <> '' then
  begin
    LSql := LSql + 'AND (op.numero_orden LIKE :search OR p.numero_pedido LIKE :search OR ' +
                   '     c.nombre_comercial LIKE :search OR c.nombre_fiscal LIKE :search OR ' +
                   '     o.nombre LIKE :search OR op.observaciones LIKE :search) ';
  end;

  if Assigned(cbFiltroEstado) and (cbFiltroEstado.ItemIndex > 0) then
  begin
    LSql := LSql + 'AND op.estado = ' + QuotedStr(cbFiltroEstado.Text) + ' ';
  end;

  if Assigned(cbFiltroObrador) and (cbFiltroObrador.ItemIndex > 0) then
  begin
    LObrId := Integer(IntPtr(cbFiltroObrador.Items.Objects[cbFiltroObrador.ItemIndex]));
    if LObrId > 0 then
      LSql := LSql + 'AND op.id_obrador = :id_obrador ';
  end;

  LSql := LSql + 'ORDER BY op.fecha_produccion DESC, op.id DESC';

  FQryMain.SQL.Text := LSql;
  FQryMain.ParamByName('emp').AsInteger := StrToIntDef(dmgMain.CurrentCompanyId, 0);

  if Trim(edtSearch.Text) <> '' then
    FQryMain.ParamByName('search').AsString := '%' + Trim(edtSearch.Text) + '%';

  if Assigned(cbFiltroObrador) and (cbFiltroObrador.ItemIndex > 0) then
  begin
    LObrId := Integer(IntPtr(cbFiltroObrador.Items.Objects[cbFiltroObrador.ItemIndex]));
    if LObrId > 0 then
      FQryMain.ParamByName('id_obrador').AsInteger := LObrId;
  end;

  FQryMain.Open;

  dbGridMain.Columns.Clear;
  with dbGridMain.Columns.Add do
  begin
    FieldName := 'numero_orden';
    Title.Caption := 'Nº Orden';
    Width := 115;
  end;
  with dbGridMain.Columns.Add do
  begin
    FieldName := 'fecha_produccion';
    Title.Caption := 'F. Producción';
    Width := 95;
    Alignment := taCenter;
    Title.Alignment := taCenter;
  end;
  with dbGridMain.Columns.Add do
  begin
    FieldName := 'fecha_entrega_prevista';
    Title.Caption := 'F. Entrega';
    Width := 95;
    Alignment := taCenter;
    Title.Alignment := taCenter;
  end;
  with dbGridMain.Columns.Add do
  begin
    FieldName := 'numero_pedido';
    Title.Caption := 'Nº Pedido';
    Width := 105;
  end;
  with dbGridMain.Columns.Add do
  begin
    FieldName := 'cliente_nombre';
    Title.Caption := 'Cliente';
    Width := 200;
  end;
  with dbGridMain.Columns.Add do
  begin
    FieldName := 'obrador_nombre';
    Title.Caption := 'Obrador';
    Width := 140;
  end;
  with dbGridMain.Columns.Add do
  begin
    FieldName := 'estado';
    Title.Caption := 'Estado';
    Width := 115;
    Alignment := taCenter;
    Title.Alignment := taCenter;
  end;
  with dbGridMain.Columns.Add do
  begin
    FieldName := 'prioridad';
    Title.Caption := 'Prioridad';
    Width := 85;
    Alignment := taCenter;
    Title.Alignment := taCenter;
  end;
  with dbGridMain.Columns.Add do
  begin
    FieldName := 'total_lineas';
    Title.Caption := 'Líneas';
    Width := 60;
    Alignment := taRightJustify;
    Title.Alignment := taRightJustify;
  end;
  with dbGridMain.Columns.Add do
  begin
    FieldName := 'total_unidades';
    Title.Caption := 'Total Uds.';
    Width := 75;
    Alignment := taRightJustify;
    Title.Alignment := taRightJustify;
  end;
  with dbGridMain.Columns.Add do
  begin
    FieldName := 'fecha_orden';
    Title.Caption := 'F. Emisión';
    Width := 90;
    Alignment := taCenter;
    Title.Alignment := taCenter;
  end;
  with dbGridMain.Columns.Add do
  begin
    FieldName := 'observaciones';
    Title.Caption := 'Observaciones';
    Width := 220;
  end;
end;

procedure TfrmOrdenesProduccion.dbGridMainDrawColumnCell(Sender: TObject;
  const Rect: TRect; DataCol: Integer; Column: TColumn; State: TGridDrawState);
var
  LEstado, LPrioridad: string;
  LBadgeRect: TRect;
  LText: string;
begin
  if FQryMain.Active and not FQryMain.IsEmpty then
  begin
    if SameText(Column.FieldName, 'estado') then
    begin
      LEstado := FQryMain.FieldByName('estado').AsString;
      if not (gdSelected in State) then
      begin
        dbGridMain.Canvas.FillRect(Rect);
        LBadgeRect := Rect;
        InflateRect(LBadgeRect, -3, -2);

        if LEstado = 'PLANIFICADA' then
        begin
          dbGridMain.Canvas.Brush.Color := $00FBEAE0; // Azul suave pastel
          dbGridMain.Canvas.Font.Color := $007A3B12;
        end
        else if LEstado = 'EN_PROCESO' then
        begin
          dbGridMain.Canvas.Brush.Color := $00FFF3D6; // Ámbar suave pastel
          dbGridMain.Canvas.Font.Color := $00663300;
        end
        else if LEstado = 'COMPLETADA' then
        begin
          dbGridMain.Canvas.Brush.Color := $00DCF8DC; // Verde esmeralda suave
          dbGridMain.Canvas.Font.Color := $000D5A0D;
        end
        else if LEstado = 'CANCELADA' then
        begin
          dbGridMain.Canvas.Brush.Color := $00E0E0FF; // Rojo suave pastel
          dbGridMain.Canvas.Font.Color := $000000B0;
        end
        else
        begin
          dbGridMain.Canvas.Brush.Color := $00F0F0F0;
          dbGridMain.Canvas.Font.Color := clWindowText;
        end;

        dbGridMain.Canvas.Pen.Color := dbGridMain.Canvas.Brush.Color;
        dbGridMain.Canvas.RoundRect(LBadgeRect.Left, LBadgeRect.Top, LBadgeRect.Right, LBadgeRect.Bottom, 6, 6);
        dbGridMain.Canvas.Font.Style := [fsBold];
        LText := LEstado;
        DrawText(dbGridMain.Canvas.Handle, PChar(LText), Length(LText), LBadgeRect, DT_CENTER or DT_VCENTER or DT_SINGLELINE);
        Exit;
      end;
    end
    else if SameText(Column.FieldName, 'prioridad') then
    begin
      LPrioridad := FQryMain.FieldByName('prioridad').AsString;
      if (LPrioridad = 'URGENTE') or (LPrioridad = 'ALTA') then
      begin
        if not (gdSelected in State) then
          dbGridMain.Canvas.Font.Color := clRed;
        dbGridMain.Canvas.Font.Style := [fsBold];
      end;
    end;
  end;

  dbGridMain.DefaultDrawColumnCell(Rect, DataCol, Column, State);
end;

procedure TfrmOrdenesProduccion.btnNewClick(Sender: TObject);
var
  LFrm: TfrmOrdenProduccionEditor;
begin
  LFrm := TfrmOrdenProduccionEditor.Create(Self);
  try
    LFrm.OrdenId := 0;
    if LFrm.ShowModal = mrOk then
      btnRefreshClick(nil);
  finally
    LFrm.Free;
  end;
end;

procedure TfrmOrdenesProduccion.btnEditClick(Sender: TObject);
var
  LFrm: TfrmOrdenProduccionEditor;
begin
  if FQryMain.IsEmpty then Exit;

  LFrm := TfrmOrdenProduccionEditor.Create(Self);
  try
    LFrm.OrdenId := FQryMain.FieldByName('id').AsInteger;
    if LFrm.ShowModal = mrOk then
      btnRefreshClick(nil);
  finally
    LFrm.Free;
  end;
end;

procedure TfrmOrdenesProduccion.btnDeleteClick(Sender: TObject);
var
  LNumOrden: string;
  LId: Integer;
begin
  if FQryMain.IsEmpty then Exit;

  LNumOrden := FQryMain.FieldByName('numero_orden').AsString;
  LId := FQryMain.FieldByName('id').AsInteger;

  if MessageDlg(Format('¿Está seguro de que desea eliminar la orden de producción %s?', [LNumOrden]),
     mtConfirmation, [mbYes, mbNo], 0) = mrYes then
  begin
    dmgMain.dbConn.StartTransaction;
    try
      dmgMain.qryExec.Close;
      dmgMain.qryExec.SQL.Text := 'DELETE FROM ge_ordenes_produccion_lineas WHERE id_orden = :id';
      dmgMain.qryExec.ParamByName('id').AsInteger := LId;
      dmgMain.qryExec.ExecSQL;

      dmgMain.qryExec.Close;
      dmgMain.qryExec.SQL.Text := 'DELETE FROM ge_ordenes_produccion WHERE id = :id';
      dmgMain.qryExec.ParamByName('id').AsInteger := LId;
      dmgMain.qryExec.ExecSQL;

      dmgMain.dbConn.Commit;
      btnRefreshClick(nil);
    except
      on E: Exception do
      begin
        dmgMain.dbConn.Rollback;
        ShowMessage('Error al eliminar la orden de producción: ' + E.Message);
      end;
    end;
  end;
end;

end.
