unit Ufrom_letter;

interface

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

type
  Tform_letter = class(TForm)
    Panel1: TPanel;
    Image1: TImage;
    Label2: TLabel;
    Label1: TLabel;
    Bevel1: TBevel;
    Image2: TImage;
    Label3: TLabel;
    Label4: TLabel;
    Label5: TLabel;
    Label6: TLabel;
    Label7: TLabel;
    Label8: TLabel;
    Label9: TLabel;
    Label10: TLabel;
    Label11: TLabel;
    Label12: TLabel;
    Label13: TLabel;
    Label14: TLabel;
    Label15: TLabel;
    Label16: TLabel;
    Label17: TLabel;
    Label18: TLabel;
    Label19: TLabel;
    Label20: TLabel;
    Bevel2: TBevel;
    Label22: TLabel;
    Label23: TLabel;
    Label24: TLabel;
    ImageList1: TImageList;
    recordset_temp2: TADOQuery;
    Panel2: TPanel;
    ListView1: TListView;
    Panel3: TPanel;
    Panel4: TPanel;
    BitBtn3: TBitBtn;
    BitBtn2: TBitBtn;
    BitBtn1: TBitBtn;
    BitBtn4: TBitBtn;
    BitBtn5: TBitBtn;
    Label21: TLabel;
    recordset_temp: TADOQuery;
    recordset_temp3: TADOQuery;
    Panel5: TPanel;
    QuickRep1: TQuickRep;
    ColumnHeaderBand1: TQRBand;
    DetailBand1: TQRBand;
    PageFooterBand1: TQRBand;
    SummaryBand1: TQRBand;
    PageHeaderBand1: TQRBand;
    TitleBand1: TQRBand;
    QRShape1: TQRShape;
    QRLabel1: TQRLabel;
    QRDBText1: TQRDBText;
    QRDBText2: TQRDBText;
    QRDBText3: TQRDBText;
    QRDBText4: TQRDBText;
    QRShape2: TQRShape;
    QRLabel2: TQRLabel;
    QRDBText5: TQRDBText;
    QRDBText6: TQRDBText;
    QRDBText7: TQRDBText;
    QRDBText8: TQRDBText;
    QRShape3: TQRShape;
    QRLabel3: TQRLabel;
    QRDBText9: TQRDBText;
    QRDBText10: TQRDBText;
    QRDBText11: TQRDBText;
    QRDBText12: TQRDBText;
    procedure FormShow(Sender: TObject);
    procedure BitBtn2Click(Sender: TObject);
    procedure BitBtn1Click(Sender: TObject);
    procedure ListView1Click(Sender: TObject);
    procedure BitBtn3Click(Sender: TObject);
    procedure BitBtn4Click(Sender: TObject);
    procedure BitBtn5Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
        sdate:tdate;
    edate:tdate;
    smoney:integer;
    emoney:integer;
  end;

var
  form_letter: Tform_letter;

implementation

uses Uform_xf_limit, Uform_ljxf_one, Uform_main;

{$R *.dfm}

procedure Tform_letter.FormShow(Sender: TObject);
begin
     label22.Caption :='';
     label24.Caption :='';
     label4.Caption :='' ;
     label5.Caption :='';
     label7.Caption :='';
     label10.Caption :='';
     label12.Caption :='';
     label14.Caption :='';
     label15.Caption :='';
     label17.Caption :='';
     label19.Caption :='';
     form_main.Dconnect.Execute('delete * from [LE]');
     
     listview1.Clear ;
end;

procedure Tform_letter.BitBtn2Click(Sender: TObject);
var
   i:integer;
   ListItem: TListItem;
   p:^integer;
   mm:real;
   pp:integer;
begin

   form_xf_limit.ShowModal ;

   pp:=1;

   if form_xf_limit.yesno =false then
   begin
      exit;
   end;

   form_main.Dconnect.Execute('delete * from [LE]');
   sdate:=form_xf_limit.sdate ;
   edate:=form_xf_limit.edate ;
   smoney:=form_xf_limit.smoney ;
   emoney:=form_xf_limit.emoney ;

   label22.Caption :=datetostr(sdate) + ' - ' + datetostr(edate);
   label24.Caption :=inttostr(smoney) + '￥ - ' + inttostr(emoney) + '￥';

   listview1.Clear ;

   recordset_temp3.Close ;
   recordset_temp3.SQL.Clear ;
   recordset_temp3.SQL.Add('select * from [LE]');
   recordset_temp3.Open ;

   recordset_temp.SQL.Clear ;
   recordset_temp.SQL.Add('select * from [CUSTOM]');
   recordset_temp.open;
   for i:=1 to recordset_temp.RecordCount do
   begin
      recordset_temp2.SQL.Clear ;
      recordset_temp2.SQL.Add('select sum([JY_ALLDOLLOR]) from [JY] where [JY_DATE]>#'
                        + datetostr(sdate) + '# and [JY_DATE]<#' + datetostr(edate)
                        + '# and [JY_CUSTOMID]='
                        + inttostr(recordset_temp.Fields[0].asinteger));
      recordset_temp2.Open ;
      if recordset_temp2.RecordCount <>0 then
      begin
         mm:=recordset_temp2.Fields[0].AsFloat ;
      end;


      if ((mm>smoney) and (mm<emoney)) then
      begin

         listitem:=listview1.Items.Add ;
         listitem.Caption :=recordset_temp.Fields[1].AsString ;
         listitem.ImageIndex :=0;
         listitem.SubItems.Add(recordset_temp.Fields[2].asstring);
         listitem.SubItems.Add(recordset_temp.Fields[3].asstring);
         listitem.SubItems.Add(format( '%8.2f￥',[mm]));
         new(p);
         p^ := recordset_temp.Fields[0].AsInteger ;
         listitem.Data :=p;
         case pp of
            1:
               begin
                  recordset_temp3.Insert;
                  recordset_temp3.fields[1].asstring:=recordset_temp.Fields[6].AsString ;
                  recordset_temp3.Fields[2].AsString :=recordset_temp.Fields [8].AsString ;
                  recordset_temp3.Fields[3].AsString :=recordset_temp.Fields [2].AsString ;
                  recordset_temp3.Fields[4].AsString :=recordset_temp.Fields [3].AsString ;
                  recordset_temp3.Post ;
                  pp:=2;
               end;
            2:
               begin
                  recordset_temp3.edit;
                  recordset_temp3.fields[5].asstring:=recordset_temp.Fields[6].AsString ;
                  recordset_temp3.Fields[6].AsString :=recordset_temp.Fields [8].AsString ;
                  recordset_temp3.Fields[7].AsString :=recordset_temp.Fields [2].AsString ;
                  recordset_temp3.Fields[8].AsString :=recordset_temp.Fields [3].AsString ;
                  recordset_temp3.Post ;
                  pp:=3;
               end;
            3:
               begin
                  recordset_temp3.edit;
                  recordset_temp3.fields[9].asstring:=recordset_temp.Fields[6].AsString ;
                  recordset_temp3.Fields[10].AsString :=recordset_temp.Fields [8].AsString ;
                  recordset_temp3.Fields[11].AsString :=recordset_temp.Fields [2].AsString ;
                  recordset_temp3.Fields[12].AsString :=recordset_temp.Fields [3].AsString ;
                  recordset_temp3.Post ;
                  pp:=3;
               end;
         end;
      end;
      recordset_temp2.Close ;
      recordset_temp.Next;
   end;
   recordset_temp.Close ;
end;

procedure Tform_letter.BitBtn1Click(Sender: TObject);
var
   p:^integer;
begin
   if listview1.selected=nil then
   begin
      exit;
   end;

   p:=listview1.Selected.Data ;
   form_ljxf_one.userid :=p^;
   form_ljxf_one.sdate:=sdate ;
   form_ljxf_one.edate:=edate ;
   form_ljxf_one.ShowModal ;
end;

procedure Tform_letter.ListView1Click(Sender: TObject);
var
   p:^integer;
begin
   if listview1.selected=nil then
   begin
     label4.Caption :='' ;
     label5.Caption :='';
     label7.Caption :='';
     label10.Caption :='';
     label12.Caption :='';
     label14.Caption :='';
     label15.Caption :='';
     label17.Caption :='';
     label19.Caption :='';
      exit;
   end;

   p:=listview1.Selected.Data;

   //show the custom's information
   recordset_temp.SQL.Clear;
   recordset_temp.SQL.Add('select [CUSTOM_CODE],[CUSTOM_MNAME],[CUSTOM_FNAME],[CUSTOM_TEL]'
   + ',[AREA_NAME],[CUSTOM_ADD],[FROM_NAME],[CUSTOM_POST],[CUSTOM_DATE] from [CUSTOM],[AREA],[FROM] where [FROM_ID]=[CUSTOM_FROM] and [AREA_ID]=[CUSTOM_AREA] and [CUSTOM_ID]=' + inttostr(p^)
   );
   recordset_temp.Open ;
   if recordset_temp.recordcount<>0 then
   begin
      label4.Caption :=recordset_temp.Fields[0].AsString ;
      label5.Caption :=recordset_temp.Fields[1].AsString;
      label7.Caption :=recordset_temp.Fields[2].AsString;
      label10.Caption :=recordset_temp.Fields[3].AsString;
      label12.Caption :=recordset_temp.Fields[4].AsString;
      label14.Caption :=recordset_temp.Fields [5].AsString ;
      label15.Caption :=recordset_temp.Fields [6].AsString;
      label17.Caption :=recordset_temp.Fields [7].AsString;
      label19.Caption :=datetostr(recordset_temp.Fields [8].AsDateTime );
   end;
end;

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

procedure Tform_letter.BitBtn4Click(Sender: TObject);
begin
    qrdbtext1.DataField :='LE_AD1';
    qrdbtext2.DataField :='LE_POST1';
    qrdbtext3.DataField :='LE_NN1';
    qrdbtext4.DataField :='LE_FN1';

    qrdbtext5.DataField :='LE_AD2';
    qrdbtext6.DataField :='LE_POST2';
    qrdbtext7.DataField :='LE_NN2';
    qrdbtext8.DataField :='LE_FN2';

    qrdbtext9.DataField :='LE_AD3';
    qrdbtext10.DataField :='LE_POST3';
    qrdbtext11.DataField :='LE_NN3';
    qrdbtext12.DataField :='LE_FN3';

    recordset_temp3.Open ;
    quickrep1.Preview ;
end;

procedure Tform_letter.BitBtn5Click(Sender: TObject);
begin
   qrdbtext1.DataField :='LE_AD1';
    qrdbtext2.DataField :='LE_POST1';
    qrdbtext3.DataField :='LE_NN1';
    qrdbtext4.DataField :='LE_FN1';

    qrdbtext5.DataField :='LE_AD2';
    qrdbtext6.DataField :='LE_POST2';
    qrdbtext7.DataField :='LE_NN2';
    qrdbtext8.DataField :='LE_FN2';

    qrdbtext9.DataField :='LE_AD3';
    qrdbtext10.DataField :='LE_POST3';
    qrdbtext11.DataField :='LE_NN3';
    qrdbtext12.DataField :='LE_FN3';

    quickrep1.Print;
end;

end.