unit CallerDM;

interface

uses
  SysUtils, Classes, ImgList, Controls, DB, ADODB, ActnList, Forms, ExtCtrls;

type
  // 通道結構
  TChannel = packed record
    ChannelID: Integer;
    ChannelType: Integer;
    AttachTTS: Boolean;
    Step: Integer;
    Busying: Boolean;
    PlayingWaterfee: Boolean;
    RingdelectReset: Boolean;
    MeterID: string; // 水表編號
    Ownerdata: string;
    CallerID: Pchar;
    DtmfID: string;
  end;
  PChannel = ^TChannel;

  // 催繳狀態
  TDun = (tdFree, tdDial, tdCheckSignal, tdPlayWaterfee, tdOnhook, tdConnect,
         	tdOffhook, tdBusy, tdNobody, tdNoSignal, tdNoDialtone, tdNoResult);

  TdmCaller = class(TDataModule)
    ilChannel: TImageList;
    conCaller: TADOConnection;
    qryWaterfeeQuery: TADOQuery;
    qryDunlog: TADOQuery;
    dsDunlog: TDataSource;
    qryDundetails: TADOQuery;
    dsDundetails: TDataSource;
    qryDundetailsSbbh: TStringField;
    qryDundetailsYhmc: TStringField;
    qryDundetailsYhdz: TStringField;
    qryDundetailsPhoneNumber: TStringField;
    qryDundetailsCallCount: TIntegerField;
    qryDundetailsCallDatetime: TDateTimeField;
    qryDundetailsCallStatus: TStringField;
    qryDundetailsWaterfee: TBCDField;
    qryDundetailsSewage: TBCDField;
    qryDundetailsTotalsum: TBCDField;
    qryDundetailsCbrq: TDateTimeField;
    qryDundetailsLatedays: TIntegerField;
    actlstCaller: TActionList;
    actStartDun: TAction;
    qryWaterfeedun: TADOQuery;
    actRefreshTellist: TAction;
    spDunlog: TADOStoredProc;
    spDun_Insert: TADOStoredProc;
    qryDunlogLogID: TAutoIncField;
    qryDunlogChannel: TIntegerField;
    qryDunlogChannelType: TStringField;
    qryDunlogAction: TStringField;
    qryDunlogDescription: TStringField;
    qryDunlogResult: TStringField;
    qryDunlogLogDatetime: TDateTimeField;
    tmrRefresh: TTimer;
    qryDundetailsIndexNumber: TStringField;
    procedure DataModuleCreate(Sender: TObject);
    procedure DataModuleDestroy(Sender: TObject);
    procedure actStartDunExecute(Sender: TObject);
    procedure actRefreshTellistExecute(Sender: TObject);
    procedure tmrRefreshTimer(Sender: TObject);
  private
    FStartdunflag: Boolean;
    FDuntaskCount: Integer;
    
    procedure RefreshTellist;
    procedure SetStartdunflag(const Value: Boolean);
  public
    procedure DunInsert(AmeterID, Adhhm: string; ACallCount: Integer; Astatus: string);
    procedure Dunlog(Achl: Integer; Achnltype: string; Action, Adesc, AResult: string);
    function  GetWaterfee(AmeterID: string): string;
    function  GetDunWaterfee(AmeterID: string): string;
    procedure RefreshDundetails;
    procedure RefreshDunlog;

    property Startdunflag: Boolean read FStartdunflag write SetStartdunflag default False;
    property DuntaskCount: Integer read FDuntaskCount default 0;
  end;

var
  dmCaller: TdmCaller;

implementation

uses mainform, Channels, RegExpr, DunThread;

{$R *.dfm}

procedure TdmCaller.DataModuleCreate(Sender: TObject);
begin
  FStartdunflag := False;
  conCaller.Connected := True;
end;

procedure TdmCaller.DataModuleDestroy(Sender: TObject);
begin
  conCaller.Connected := False;
end;

//------------------------------------------------------------------------------
// 獲取客戶當前要繳水費的總金額
//------------------------------------------------------------------------------
function TdmCaller.GetWaterfee(AmeterID: string): string;
const
  Asql = 'select Sbbh, Sum(Waterfee + Sewage) As Totalsum from VUnPaiedWaterfee where Isnull(Zzbz, '''') <> ''V'' and Sbbh = ''%s'' group by Sbbh';
var
  ATotalsum: Double;
begin
  ATotalsum := 0.00;
  with qryWaterfeeQuery do
  try
    Close;
    SQL.Clear;
    SQL.Text := Format(Asql, [AmeterID]);
    try
      Open;
      if not IsEmpty then
        ATotalsum := FieldByname('Totalsum').AsFloat
    except end;
    if ATotalsum <> 0.00 then
      Result := Format('您當前的總共有 %f 元水費未繳，請就近到自來水公司營業網點繳費。', [ATotalsum])
    else
      Result := '您當前沒有未繳水費，歡迎您下次使用本系統。';
  finally
    Close;
  end;
end;

procedure TdmCaller.actStartDunExecute(Sender: TObject);
begin
  Startdunflag := not Startdunflag;
end;

//------------------------------------------------------------------------------
// 獲取待催繳用戶的電話列表
//------------------------------------------------------------------------------
procedure TdmCaller.RefreshTellist;

  function Getdialnumlist(Astr: string): string;
  var
    ARegex: TRegExpr; // (13\d{9}|[2-8]\d{6,7})
  begin
    Result := '';
    ARegex := TRegExpr.Create;
    try
      ARegex.Expression := '(13\d{9}|[2-8]\d{6,7})';
      if ARegex.Exec(Astr) and (ARegex.SubExprMatchCount > 0) then
        Result := ARegex.Match[0];
      if (Length(Result) = 7) then
        if Copy(Result, 1, 1) = '2' then
          Result := '2' + Result
        else
          Result := '8' + Result;
    finally
      ARegex.Free;
    end;
  end;
var
  Aduninfo: TDunInfo;
  Atmp: string;
  I: Integer;
begin
  with Mainfrm, Mainfrm.telebox.Items, qryWaterfeedun do
  try
    Screen.Cursor := crHourGlass;
    Clear();
    Close;
    try
      Open();
    except end;

    // 添加待催繳的電話列表
    I := 0;
    while not Eof do
    begin
      Atmp := Getdialnumlist(FieldByName('dhhm').AsString);
      if Atmp <> '' then
      begin
        Aduninfo         := TDunInfo.Create;
        Aduninfo.Sbbh    := FieldByName('Sbbh').AsString;
        {if I mod 2 = 0 then
          Aduninfo.Dialnum := '22574262'//Atmp; // 以一個特定號碼進行測試
        else
          Aduninfo.Dialnum := '22305779';}
        Aduninfo.Dialnum := Atmp;
        AddObject(Aduninfo.Dialnum, Aduninfo);
      end;
      Inc(I);
      Next();
    end;
    First();
    FDuntaskCount := Count;
    Progressbar.Position := 0;
  finally
    Screen.Cursor := crDefault;
  end;
end;

{-------------------------------------------------------------------------------
  Procedure: TdmCaller.RefreshDundetails
  Author:    Xsp
  DateTime:  2006.05.09
  Arguments: None
  Result:    None
  Popose:    刷新催繳歷史記錄
-------------------------------------------------------------------------------}
procedure TdmCaller.RefreshDundetails;
begin
  with qryDundetails do
  try
    Screen.Cursor := crHourGlass;
    Close;
    try
      Open;
    except end;
  finally
    Screen.Cursor := crDefault;
  end;
end;

procedure TdmCaller.RefreshDunlog;
begin
  with qryDunlog do
  try
    Screen.Cursor := crHourGlass;
    Close();
    try
      Open();
    except end;
  finally
    Screen.Cursor := crDefault;
  end;
end;

procedure TdmCaller.actRefreshTellistExecute(Sender: TObject);
begin
  RefreshTellist;
end;

//------------------------------------------------------------------------------
// 添加催繳日志記錄
//------------------------------------------------------------------------------
procedure TdmCaller.Dunlog(Achl: Integer; Achnltype, Action, Adesc,
  AResult: string);
var
  Athread: TDunlogThread;
begin
  Athread := TDunlogThread.Create(True);
  Athread.SetConnection(conCaller);
  Athread.Channel := Achl;
  Athread.Channeltype := Achnltype;
  Athread.Action := Action;
  Athread.Description := Adesc;
  Athread.ActionResult := AResult;
  Athread.Resume;
end;

//------------------------------------------------------------------------------
// 查詢客戶當前欠費的總金額
//------------------------------------------------------------------------------
function TdmCaller.GetDunWaterfee(AmeterID: string): string;
const
  cstr = '尊敬的客戶您好，這里是東莞市自來水公司，經核實您尚有 %f 元水費未繳，請在接到通知后就近到自來水公司營業網點繳費，以免給您帶來不便，更詳細的信息請撥打電話''pho22237717。';
begin
  Result := '';
  qryWaterfeedun.First();
  if qryWaterfeedun.Locate('Sbbh', AmeterID, []) then
    Result := Format(cstr, [qryWaterfeedun.FieldByName('Totalsum').AsFloat]);
end;

//------------------------------------------------------------------------------
// 向系統中插入已催繳的記錄
//------------------------------------------------------------------------------
procedure TdmCaller.DunInsert(AmeterID, Adhhm: string; ACallCount: Integer;
  Astatus: string);
var
  Athread: TDundetailsThread;
begin
  Athread := TDundetailsThread.Create(True);
  Athread.SetConnection(conCaller);
  Athread.MeterID := AmeterID;
  Athread.Dhhm := Adhhm;
  Athread.DunCount := ACallCount;
  Athread.DunStatus := Astatus;
  Athread.Resume;
end;

procedure TdmCaller.tmrRefreshTimer(Sender: TObject);
begin
  RefreshDundetails;
  RefreshDunlog;
end;

{-------------------------------------------------------------------------------
  Procedure: TdmCaller.SetStartdunflag
  Author:    Xsp
  DateTime:  2006.05.09
  Arguments: const Value: Boolean
  Result:    None
  Popose:    設置催繳標志，如果催繳標志為假則停止所有的催繳操作
-------------------------------------------------------------------------------}
procedure TdmCaller.SetStartdunflag(const Value: Boolean);
var
  I: Integer;
begin
  if FStartdunflag <> Value then
  begin
    FStartdunflag := Value;
    if FStartdunflag then
    begin
      RefreshTellist;
      actRefreshTellist.Enabled := False;
      actStartDun.Caption := '停止催繳(&P)';
    end else
    begin
      for I := 0 to TTSChannel - 1 do // 重置通道信息
        ResetChannel(I);
      actRefreshTellist.Enabled := True;
      actStartDun.Caption := '開始催繳(&S)';
    end;
  end;
end;

end.