unit Uform_report_fy;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Buttons, ComCtrls, DB, ADODB, ImgList, ExtCtrls,
  QRCtrls, QuickRpt;

type
  Tform_report_fy = class(TForm)
    Panel1: TPanel;
    Image1: TImage;
    Label2: TLabel;
    Label1: TLabel;
    Bevel1: TBevel;
    Image2: TImage;
    Label5: TLabel;
    Label6: TLabel;
    Label3: TLabel;
    Label4: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    ImageList1: TImageList;
    recordset_temp: TADOQuery;
    recordset_temp2: TADOQuery;
    Panel2: TPanel;
    apart_list: TListView;
    Panel3: TPanel;
    Panel4: TPanel;
    BitBtn3: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn1: TBitBtn;
    BitBtn4: TBitBtn;
    BitBtn5: TBitBtn;
    Panel5: TPanel;
    QuickRep1: TQuickRep;
    ColumnHeaderBand1: TQRBand;
    QRShape5: TQRShape;
    QRShape6: TQRShape;
    QRShape7: TQRShape;
    QRShape8: TQRShape;
    QRLabel1: TQRLabel;
    QRLabel2: TQRLabel;
    QRLabel4: TQRLabel;
    QRLabel6: TQRLabel;
    DetailBand1: TQRBand;
    QRShape1: TQRShape;
    QRShape2: TQRShape;
    QRShape3: TQRShape;
    QRShape4: TQRShape;
    QRDBText1: TQRDBText;
    QRDBText2: TQRDBText;
    QRDBText3: TQRDBText;
    QRDBText4: TQRDBText;
    PageFooterBand1: TQRBand;
    SummaryBand1: TQRBand;
    PageHeaderBand1: TQRBand;
    QRLabel11: TQRLabel;
    TitleBand1: TQRBand;
    recordset_temp3: TADOQuery;
    procedure FormShow(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure BitBtn4Click(Sender: TObject);
    procedure BitBtn5Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
    intCount:integer;
    sdate:tdate;
    edate:tdate;
  end;

var
  form_report_fy: Tform_report_fy;

implementation

uses Uform_fw_limit, Uform_fw_one, Uform_main;

{$R *.dfm}

procedure Tform_report_fy.FormShow(Sender: TObject);
var
   i:integer;
   ListItem: TListItem;
   p:^integer;
begin
   //add the fw into the list 2002-2-1

   //CLEAR ALL INFORMATION
   apart_list.Items.Clear ;
   label8.Caption :='未限定';
   label4.Caption :='未限定';
   label10.Caption :=format('%8.2f￥',[0.0]);
   sdate:=now;
   edate:=now;

   //add the fw into imagelist
   recordset_temp.SQL.Clear ;
   recordset_temp.SQL.Add ('select * from [FW]');
   recordset_temp.Open ;
   intCount:=recordset_temp.RecordCount ;
   Label5.Caption :=inttostr(intCount) + '個';
   form_main.Dconnect.Execute('delete * from [FF]');
   recordset_temp3.SQL.Clear ;
   recordset_temp3.SQL.Add('select * from [FF]');
   recordset_temp3.Open ;
   for i:=1 to recordset_temp.RecordCount do
   begin
      listitem:=apart_LIST.Items.Add ;
      listitem.Caption :=recordset_temp.Fields[1].AsString ;
      listitem.SubItems.Add(format( '%8.2f￥',[recordset_temp.fields[2].asfloat]));
      listitem.SubItems.Add('0');
      listitem.SubItems.Add (format('%8.2f￥',[0.0]));
      listitem.ImageIndex :=0;
      new(p);
      p^ := recordset_temp.Fields[0].AsInteger ;
      listitem.Data :=p;

      recordset_temp3.Insert ;
      recordset_temp3.Fields[1].AsString :=recordset_temp.Fields[1].AsString ;
      recordset_temp3.Fields[2].AsString :=format( '%8.2f￥',[recordset_temp.fields[2].asfloat]);
      recordset_temp3.Fields[3].AsString :='0';
      recordset_temp3.Fields[4].AsString :=format('%8.2f￥',[0.0]);
      recordset_temp3.Post ;


      recordset_temp.Next;
      
   end;

   recordset_temp3.Close ;
end;

procedure Tform_report_fy.BitBtn2Click(Sender: TObject);
var
   i:integer;
   ListItem: TListItem;
   p:^integer;
   money:real;
begin
   //limit the fw 2002-2-1
   form_fw_limit.ShowModal ;
   if form_fw_limit.yesno =false then exit;
   sdate:=form_fw_limit.sdate ;
   edate:=form_fw_limit.edate ;
   //CLEAR ALL INFORMATION
   apart_list.Items.Clear ;
   label8.Caption :=datetostr(sdate);
   label4.Caption :=datetostr(edate);
   money:=0;


   //add the fw into imagelist
   recordset_temp.SQL.Clear ;
   recordset_temp.SQL.Add ('select * from [FW]');
   recordset_temp.Open ;
   intCount:=recordset_temp.RecordCount ;
   Label5.Caption :=inttostr(intCount) + '個';

   form_main.Dconnect.Execute('delete * from [FF]');
   recordset_temp3.SQL.Clear ;
   recordset_temp3.SQL.Add('select * from [FF]');
   recordset_temp3.Open ;

   for i:=1 to recordset_temp.RecordCount do
   begin
      listitem:=apart_LIST.Items.Add ;
      listitem.Caption :=recordset_temp.Fields[1].AsString ;
      listitem.SubItems.Add(format( '%8.2f￥',[recordset_temp.fields[2].asfloat]));
      listitem.ImageIndex :=0;

      recordset_temp2.SQL.Clear;
      recordset_temp2.SQL.Add('select sum([JY_FWCOUNT]),sum([JY_ALLDOLLOR]) from [JY] where [JY_FWID]='
        + inttostr(recordset_temp.Fields[0].AsInteger) + ' and [JY_DATE]>=#' + datetostr(sdate) + '# and [JY_DATE]<=#' + datetostr(edate+1) + '#');
      recordset_temp2.Open ;
      
      recordset_temp3.Insert ;
      recordset_temp3.Fields[1].AsString :=recordset_temp.Fields[1].AsString ;
      recordset_temp3.Fields[2].AsString :=format( '%8.2f￥',[recordset_temp.fields[2].asfloat]);



      if recordset_temp.RecordCount <>0 then
      begin
         listitem.SubItems.Add(inttostr(recordset_temp2.Fields[0].asinteger));
         listitem.SubItems.Add (format('%8.2f￥',[recordset_temp2.Fields[1].asfloat]));
         money:=money+recordset_temp2.Fields[1].asfloat;
         recordset_temp3.Fields[3].AsString :=inttostr(recordset_temp2.Fields[0].asinteger);
         recordset_temp3.Fields[4].AsString :=format('%8.2f￥',[recordset_temp2.Fields[1].asfloat]);
      end
      else
      begin
         listitem.SubItems.Add('0');
         listitem.SubItems.Add (format('%8.2f￥',[0.0]));
         recordset_temp3.Fields[3].AsString :='0';
         recordset_temp3.Fields[4].AsString :=format('%8.2f￥',[0.0]);
      end;
      recordset_temp2.Close;

      new(p);
      p^ := recordset_temp.Fields[0].AsInteger ;
      listitem.Data :=p;
      recordset_temp3.Post ;
      recordset_temp.Next;
   end;

   label10.Caption :=format('%8.2f￥',[money]);
end;

procedure Tform_report_fy.BitBtn1Click(Sender: TObject);
var
   p:^integer;
begin
   if apart_list.Selected =nil then exit ;
   p:=Apart_list.Selected.Data;
   form_fw_one.id :=p^;
   form_fw_one.stime:=datetostr(sdate) + '-' + datetostr(edate);
   form_fw_one.fw_name :=apart_list.Selected.Caption ;

   recordset_temp2.SQL.Clear;
   recordset_temp2.SQL.Add('select sum([JY_FWCOUNT]),sum([JY_ALLDOLLOR]) from [JY] where [JY_FWID]='
        + inttostr(p^) + ' and [JY_DATE]>=#' + datetostr(sdate) + '# and [JY_DATE]<=#' + datetostr(edate+1) + '#');
   recordset_temp2.Open ;
   if recordset_temp.RecordCount <>0 then
   begin
         form_fw_one.cc:=inttostr(recordset_temp2.Fields[0].asinteger) + '套/' +
         format('%8.2f￥',[recordset_temp2.Fields[1].asfloat]);
   end
   else
   begin
         form_fw_one.cc:='0套/'+ format('%8.2f￥',[0.0]);
   end;
   recordset_temp2.Close;

   form_fw_one.sdate:=sdate;
   form_fw_one.edate:=edate;

   form_fw_one.ShowModal ;
end;

procedure Tform_report_fy.BitBtn3Click(Sender: TObject);
begin
   close;
end;

procedure Tform_report_fy.BitBtn4Click(Sender: TObject);
begin
   recordset_temp3.SQL.Clear ;
   recordset_temp3.SQL.Add('select * from [FF]');
   recordset_temp3.Open  ;

   qrdbtext1.DataField :='FF_NAME';
   qrdbtext2.DataField :='FF_OMONEY';
   qrdbtext3.DataField :='FF_COUNT';
   qrdbtext4.DataField :='FF_ALLMONEY';

   quickrep1.Preview ;
   recordset_temp3.Close ;
end;

procedure Tform_report_fy.BitBtn5Click(Sender: TObject);
begin
   recordset_temp3.SQL.Clear ;
   recordset_temp3.SQL.Add('select * from [FF]');
   recordset_temp3.Open  ;

   qrdbtext1.DataField :='FF_NAME';
   qrdbtext2.DataField :='FF_OMONEY';
   qrdbtext3.DataField :='FF_COUNT';
   qrdbtext4.DataField :='FF_ALLMONEY';

   quickrep1.Print ;
   recordset_temp3.Close ;
end;

end.