PHPWebDm.pas 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982
  1. {*******************************************************************************
  2. 单元名称: PHPWebDm.pas
  3. 单元说明: Delphi 同PHP web服务器通信接口。 计量的PHP比造价的PHP多了很多
  4. 作者时间: Chenshilong, 2012-5-13
  5. *******************************************************************************}
  6. unit PHPWebDm;
  7. interface
  8. uses
  9. SysUtils, Classes, IdBaseComponent, IdComponent, IdTCPConnection,
  10. IdTCPClient, IdHTTP, CslJson;
  11. type
  12. // Web连接成功、Web连接失败、登录失败、旧用户需要升级、资料不全
  13. TLoginType = (ltCon, ltDisCon, ltLoginFail, ltUpdate, ltIncomplete);
  14. TPHPWeb = class(TDataModule)
  15. procedure DataModuleCreate(Sender: TObject);
  16. private
  17. // 远程服务器上时间
  18. FServerDateTime: TDateTime;
  19. FUserID: Integer;
  20. FAccount: string;
  21. FRealName: string;
  22. FUserFlag: Integer; // 用户标志位,用于区分出一部分用户进行特殊控制。
  23. FMeasureURL: string; // http://d.jl.smartcost.com.cn/api/client/
  24. FLoginURL: string;
  25. FLoginBannerURL: string;
  26. FCheckOnLineURL: string;
  27. FPassportURL: string;
  28. FPwdURL: string;
  29. FRegURL: string;
  30. FWebLoginURL: string;
  31. FServerDateTimeURL: string;
  32. FWebSoftURL: string;
  33. FLogoutURL: string;
  34. FRole: string;
  35. FCompany: string;
  36. FUserImageURL: string;
  37. FLoginCloudURL: string;
  38. procedure SetUserID(const Value: Integer);
  39. procedure SetAccount(const Value: string);
  40. procedure SetRealName(const Value: string);
  41. {-------------------------------------------------------------------------------
  42. 方法: CustomSearch()
  43. 描述: 通用的查询接口,集各种复杂情况之大成,宇宙级牛B综合算法,哦耶! ^__^
  44. 【函数返回值】
  45. -1: 网络不通;
  46. 0: 网络通,但登录或查询出错、网页出错等,无法返回约定的
  47. Json格式,通常返回一篇乱码;
  48. 1: 成功(包括返回零记录)
  49. 【参数】
  50. AURL: 请求的网址。
  51. AInFields: 请求的键名字。
  52. AInValues: 请求的键值。
  53. AResultType: 返回值类型:0 返回一维数组;1 返回二维数组;2 两者都。
  54. AOutStrs: 用于存储返回的零散值。需要赋字段名传入。
  55. AOutRecords: 用于存储返回的多条记录、数据表。只需声明,无需定义大
  56. 小和赋值,返回Json的数组,数组的值为'info'对象的值。
  57. 【要求】
  58. ①返回的Json数据中必须有status、msg两个键名字(约定格式)。
  59. ②AResults至少有一个元素,用来存储当返回值为0时查询出错的原因。
  60. 作者: Chenshilong, 2014-07-13
  61. -------------------------------------------------------------------------------}
  62. function CustomSearch(AURL: string; AInFields, AInValues: array of string;
  63. AResultType: Integer; var AOutStrs: array of string;
  64. var AOutRecords: TOVArr): Integer;
  65. public
  66. function SystemDateTime: TDateTime;
  67. function Search(AURL: string; var AOutStrs: array of string): Integer; overload;
  68. function Search(AURL: string; var AOutRecords: TOVArr): Integer; overload;
  69. function Search(AURL: string; AInFields, AInValues: array of string; var AOutStrs: array of string): Integer; overload;
  70. function Search(AURL: string; AInFields, AInValues: array of string; var AOutRecords: TOVArr): Integer; overload;
  71. function Search(AURL: string; AInFields, AInValues: array of string; var AOutStrs: array of string ; var AOutRecords: TOVArr): Integer; overload;
  72. function Search(AURL: string; AInFields, AInValues: array of string; AResultType: Integer; var AOutStrs: array of string ; var AOutRecords: TOVArr): Integer; overload;
  73. // ALoginType, 登录类型,1 正常情况下的用户名密码;2 紫光平台调用仅用户名无密码
  74. function Login(AAccount, APW: string; ALoginType: Integer; var AInfo, ANewExeURL: string): TLoginType;
  75. function ConnectServer(AIP: string; var ACompanyName: string): Integer; // 新装软件,先弹出设置IP窗口
  76. function UpDataFile(AUserID, ATenderID, APhaseNo: Integer; AFile, AMD5_JL: string;
  77. AIsSubmit: Boolean; var AResultStr: string; ACheckPassed: Boolean; ACheckerMemo: string): Boolean;
  78. function UpAttachment(AUperID, AWebID, ABillID, APhase: Integer; AFile, ACategory, AMemo: string; var ANewFileName, AFileID, ADownURL: string): Boolean;
  79. function UpAttachmentOnLine(AWebID, ABillID, APhase: Integer; AIDAry: array of string): Boolean;
  80. function DeleteAttachment(AFileID: Integer): Integer;
  81. function GetAttachmentList(AWebID: Integer; var vArr: TOVArr): Boolean;
  82. function zip(AFileArr: array of string): string;
  83. function CheckZip(AZipFile: string; AFileCount: Integer): Boolean; // 检测zip是否能够正确解压出所有文件。
  84. function TempName(ALength: Integer = 12): string;
  85. function WebPath: string;
  86. function UserPath: string;
  87. // 下载文件:源文件网址;存储到本地的位置
  88. function DownFile(ASourceURL: string; var ALocalFile: string): Boolean;
  89. // 用于调试输出值,解决灵异现象(有些现象调试环境正常,运行环境时有时无)
  90. procedure Debug(AFileName, AStr: string); overload;
  91. procedure Debug(AFileName: string; AInFields, AInValues: array of string); overload;
  92. function NetError(AMid: string): string;
  93. function PageError(AMid: string): string;
  94. function ExistInServer(AWebID: Integer): Boolean;
  95. function GetNameFromURLProtocol(AURLProtocol: string): string;
  96. function UploadFile(AUrl: string; AInFields, AInValues: array of string;
  97. AFileName: string; var ErrorMessage: string): Boolean;
  98. function UploadFiles(AUrl: string; AInFields, AInValues: array of string;
  99. AUpFileFields, AUpFileNames: array of string; var ErrorMessage: string): Boolean;
  100. function UrlGet(AUrl: string; APostParam: TStrings; var AResult: string): Integer; overload;
  101. function UrlGet(AUrl: string; APostParam: TStrings; var AResult: TStrings): Integer; overload;
  102. procedure ReadIniValues;
  103. property Account: string read FAccount write SetAccount;
  104. property UserID: Integer read FUserID write SetUserID;
  105. property RealName: string read FRealName write SetRealName;
  106. property UserFlag: Integer read FUserFlag write FUserFlag;
  107. property Company: string read FCompany write FCompany;
  108. property Role: string read FRole write FRole;
  109. property MeasureURL: string read FMeasureURL;
  110. property WebSoftURL: string read FWebSoftURL;
  111. property PassportURL: string read FPassportURL;
  112. property LoginURL: string read FLoginURL;
  113. property WebLoginURL: string read FWebLoginURL;
  114. property LoginBannerURL: string read FLoginBannerURL;
  115. property LogoutURL: string read FLogoutURL;
  116. property RegURL: string read FRegURL;
  117. property PwdURL: string read FPwdURL;
  118. property CheckOnLineURL: string read FCheckOnLineURL;
  119. property ServerDateTimeURL: string read FServerDateTimeURL;
  120. property UserImageURL: string read FUserImageURL write FUserImageURL;
  121. property LoginCloudURL: string read FLoginCloudURL write FLoginCloudURL;
  122. end;
  123. function PHPWeb: TPHPWeb;
  124. // 全国 广东 标后预算 定额排版 港口水工 内河航运 疏浚 清单编制
  125. function ExeCategoryName: string;
  126. implementation
  127. uses
  128. MD5Unit, IdMultipartFormData, VCLUnZip, VCLZip,
  129. IniFiles, Forms, UtilMethods, Variants, ConstUnit, ScUtils, superobject;{, Controls, Windows}
  130. var g_PHPWeb: TPHPWeb;
  131. {$R *.dfm}
  132. { TPHPWeb }
  133. function PHPWeb: TPHPWeb;
  134. begin
  135. if g_PHPWeb = nil then
  136. g_PHPWeb := TPHPWeb.Create(nil);
  137. Result := g_PHPWeb;
  138. end;
  139. function ExeCategoryName: string;
  140. begin
  141. Result := 'JLZF';
  142. end;
  143. function TPHPWeb.Login(AAccount, APW: string; ALoginType: Integer; var AInfo, ANewExeURL: string): TLoginType;
  144. var vArr: array of string;
  145. begin
  146. vArr := VarArrayOf(['uid', 'name', 'email', 'ucompany', 'jobtitle', 'avatar', 'msg']);
  147. case Search(FMeasureURL + 'signin', ['v4name', 'v4pass', 'version', 'logintype'],
  148. [AnsiToUtf8(AAccount), APW, GetVersion{'0.0.0.0'}, IntToStr(ALoginType)], vArr) of
  149. -1: Result := ltDisCon;
  150. 0:
  151. begin
  152. AInfo := vArr[0];
  153. Result := ltLoginFail;
  154. end;
  155. 1:
  156. begin
  157. FUserID := StrToInt(vArr[0]);
  158. FRealName := vArr[1];
  159. FAccount := AAccount; // vArr[2]
  160. FCompany := vArr[3];
  161. FRole := vArr[4];
  162. FUserImageURL := vArr[5];
  163. AInfo := vArr[6];
  164. Result := ltCon;
  165. end;
  166. 2:
  167. begin
  168. AInfo := '版本有更新,请点击“确定”下载新版本。';
  169. ANewExeURL := vArr[1];
  170. Result := ltUpdate;
  171. end;
  172. end;
  173. end;
  174. procedure TPHPWeb.SetUserID(const Value: Integer);
  175. begin
  176. FUserID := Value;
  177. end;
  178. procedure TPHPWeb.SetAccount(const Value: string);
  179. begin
  180. FAccount := Value;
  181. end;
  182. procedure TPHPWeb.DataModuleCreate(Sender: TObject);
  183. begin
  184. FServerDateTime := -1;
  185. ReadIniValues;
  186. end;
  187. procedure TPHPWeb.SetRealName(const Value: string);
  188. begin
  189. FRealName := Value;
  190. end;
  191. function TPHPWeb.zip(AFileArr: array of string): string;
  192. var vZip: TVCLZip;
  193. sAppFile, sZipFile: string;
  194. i: Integer;
  195. begin
  196. Result := 'Error';
  197. sAppFile := AFileArr[Low(AFileArr)];
  198. sZipFile := ExtractFilePath(sAppFile) + ExtractFileNameWithoutExt(sAppFile) + '.up';
  199. if FileExists(sZipFile) then
  200. DeleteFile(sZipFile);
  201. vZip := TVCLZip.Create(nil);
  202. try
  203. for i := Low(AFileArr) to High(AFileArr) do
  204. begin
  205. if FileExists(AFileArr[i]) then
  206. vZip.FilesList.Add(AFileArr[i]);
  207. end;
  208. vZip.ZipName := sZipFile;
  209. // PHP不支持解压加密zip文件
  210. //vZip.Password := 'jlzf.Sc.2014';
  211. vZip.Recurse := True;
  212. vZip.ZipComment := '纵横计量支付';
  213. vZip.OverwriteMode := Always;
  214. vZip.Zip;
  215. Result := sZipFile;
  216. for i := Low(AFileArr) to High(AFileArr) do
  217. DeleteFile(AFileArr[i]);
  218. finally
  219. vZip.Free;
  220. end;
  221. end;
  222. function TPHPWeb.CheckZip(AZipFile: string; AFileCount: Integer): Boolean;
  223. var vUnZip: TVCLUnZip;
  224. begin
  225. vUnZip := TVCLUnZip.Create(nil);
  226. try
  227. vUnZip.ZipName := AZipFile;
  228. vUnZip.DestDir := 'C:\Temp\MeasureTemp\';
  229. vUnZip.DoAll := True;
  230. vUnZip.RecreateDirs := True;
  231. vUnZip.RetainAttributes := True;
  232. vUnZip.OverwriteMode := Always;
  233. Result := (AFileCount = vUnZip.UnZip);
  234. finally
  235. DeleteFolder(vUnZip.DestDir);
  236. vUnZip.Free;
  237. end;
  238. end;
  239. function TPHPWeb.UpDataFile(AUserID, ATenderID, APhaseNo: Integer; AFile, AMD5_JL: string;
  240. AIsSubmit: Boolean; var AResultStr: string; ACheckPassed: Boolean; ACheckerMemo: string): Boolean;
  241. var
  242. IdDataStream: TIdMultiPartFormDataStream;
  243. sResult, sURL: string;
  244. J: TCslJson;
  245. sZipMD5: string;
  246. vIdHttp: TIdHTTP;
  247. begin
  248. Result := False;
  249. if not FileExists(AFile) then Exit;
  250. IdDataStream := TIdMultiPartFormDataStream.Create;
  251. vIdHTTP := TIdHTTP.Create(nil);
  252. try
  253. if ACheckPassed then // 审核通过
  254. begin
  255. if AIsSubmit then
  256. begin
  257. sURL := Format('%speriod/%d/%d/%d/creat', [FMeasureURL, AUserID, ATenderID, APhaseNo])
  258. end
  259. else
  260. begin
  261. sURL := FMeasureURL + 'user/audit/measure';
  262. IdDataStream.AddFormField('userid', IntToStr(AUserID));
  263. IdDataStream.AddFormField('tenderid', IntToStr(ATenderID));
  264. IdDataStream.AddFormField('phaseno', IntToStr(APhaseNo));
  265. IdDataStream.AddFormField('CheckerMemo', ReplaceCharsForJson(ACheckerMemo));
  266. end;
  267. end
  268. else // 审核不通过
  269. begin
  270. sURL := Format('%suser/set/%d/%d/%d/checkno', [FMeasureURL, AUserID, ATenderID, APhaseNo]);
  271. IdDataStream.AddFormField('CheckerMemo', ReplaceCharsForJson(ACheckerMemo));
  272. end;
  273. IdDataStream.AddFile('upfile', AFile, 'text/plain');
  274. IdDataStream.AddFormField('upfile', AFile);
  275. IdDataStream.AddFormField('MD5_JL', AMD5_JL);
  276. sZipMD5 := MD5_File(AFile);
  277. IdDataStream.AddFormField('MD5_Zip', sZipMD5);
  278. IdDataStream.Position := 0;
  279. try
  280. sResult := vIdHTTP.Post(sURL, IdDataStream);
  281. except
  282. Abort;
  283. end;
  284. finally
  285. IdDataStream.Free;
  286. vIdHttp.Free;
  287. DeleteFile(AFile);
  288. end;
  289. J := TCslJson.Create;
  290. try
  291. J.Text := Utf8ToAnsi(sResult);
  292. if SameText(J.Value['status'], 'true') then
  293. Result := True
  294. else
  295. begin
  296. Result := False;
  297. AResultStr := J.Value['msg'];
  298. end;
  299. finally
  300. J.Free;
  301. end;
  302. end;
  303. function TPHPWeb.Search(AURL: string; AInFields, AInValues: array of string; var AOutStrs: array of string): Integer;
  304. var vA: TOVArr;
  305. begin
  306. Result := CustomSearch(AURL, AInFields, AInValues, 0, AOutStrs, vA);
  307. end;
  308. function TPHPWeb.Search(AURL: string; AInFields, AInValues: array of string; var AOutRecords: TOVArr): Integer;
  309. var vA: array of string;
  310. begin
  311. Result := CustomSearch(AURL, AInFields, AInValues, 1, vA, AOutRecords);
  312. end;
  313. function TPHPWeb.Search(AURL: string; AInFields, AInValues: array of string; var AOutStrs: array of string; var AOutRecords: TOVArr): Integer;
  314. begin
  315. Result := CustomSearch(AURL, AInFields, AInValues, 2, AOutStrs, AOutRecords);
  316. end;
  317. function TPHPWeb.Search(AURL: string; AInFields, AInValues: array of string; AResultType: Integer; var AOutStrs: array of string; var AOutRecords: TOVArr): Integer;
  318. begin
  319. Result := CustomSearch(AURL, AInFields, AInValues, 3, AOutStrs, AOutRecords);
  320. end;
  321. function TPHPWeb.TempName(ALength: Integer): string;
  322. const
  323. CodedBuf: array[0..35] of Char = ('0', '1', '2', '3', '4', '5',
  324. '6', '7', '8', '9', 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I',
  325. 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V',
  326. 'W', 'X', 'Y', 'Z');
  327. begin
  328. Result := '';
  329. Randomize;
  330. while Length(Result) < ALength do
  331. Result := Result + CodedBuf[Random(36)];
  332. end;
  333. function TPHPWeb.WebPath: string;
  334. begin
  335. Result := ExtractFilePath(Application.ExeName) + 'Web\';
  336. if not DirectoryExists(Result) then
  337. ForceDirectories(Result);
  338. end;
  339. function TPHPWeb.UserPath: string;
  340. begin
  341. Result := ExtractFilePath(Application.ExeName) + 'Web\Users\' + IntToStr(FUserID) + '\';
  342. if not DirectoryExists(Result) then
  343. ForceDirectories(Result);
  344. end;
  345. function TPHPWeb.DownFile(ASourceURL: string; var ALocalFile: string): Boolean;
  346. var
  347. vStream: TMemoryStream;
  348. iFlag: Integer;
  349. bOK: Boolean;
  350. vIdHTTP: TIdHTTP;
  351. procedure SafeDownFile(ASourceURL: string; var ALocalFile: string);
  352. begin
  353. Inc(iFlag);
  354. bOK := False;
  355. try
  356. vIdHTTP.Get(ASourceURL, vStream);
  357. vStream.SaveToFile(ALocalFile);
  358. bOK := True;
  359. except
  360. bOK := False;
  361. end;
  362. end;
  363. begin
  364. iFlag := 0;
  365. bOK := False;
  366. Result := False;
  367. if Trim(ASourceURL) = '' then Exit;
  368. if Trim(ALocalFile) = '' then Exit;
  369. if (ExtractFileExt(ALocalFile) = '.rmf') and FileExists(ALocalFile) then
  370. DeleteFile(ALocalFile);
  371. vStream := TMemoryStream.Create;
  372. vIdHTTP := TIdHTTP.Create(nil);
  373. try
  374. while (not bOK) and (iFlag < 2) do // 尝试2次
  375. SafeDownFile(ASourceURL, ALocalFile);
  376. Result := bOK;
  377. finally
  378. vStream.Free;
  379. vIdHTTP.Free;
  380. end;
  381. end;
  382. function TPHPWeb.CustomSearch(AURL: string; AInFields,
  383. AInValues: array of string; AResultType: Integer;
  384. var AOutStrs: array of string; var AOutRecords: TOVArr): Integer;
  385. var
  386. i: Integer;
  387. postList: TStrings;
  388. ssResponse: TStringStream;
  389. bDone: Boolean;
  390. vJson: TCslJson;
  391. vIdHTTP: TIdHTTP;
  392. begin
  393. Result := -1;
  394. postList := TStringList.Create;
  395. ssResponse := TStringStream.Create('');
  396. vIdHTTP := TIdHTTP.Create(nil);
  397. try
  398. try
  399. for i := Low(AInFields) to High(AInFields) do
  400. postList.Add(Format('%s=%s', [AInFields[i], AInValues[i]]));
  401. vIdHTTP.Post(AURL, postList, ssResponse);
  402. bDone := True;
  403. except
  404. bDone := False;
  405. end;
  406. if (bDone) and (Pos('200 OK', vIdHTTP.ResponseText) <> 0) then // 网络已通
  407. begin
  408. vJson := TCslJson.Create;
  409. try
  410. vJson.Text := Utf8ToAnsi(ssResponse.DataString);
  411. if SameText(vJson.Value['status'], 'true') then // 数据读取成功
  412. begin
  413. case AResultType of
  414. 0:
  415. begin
  416. for i := Low(AOutStrs) to High(AOutStrs) do
  417. AOutStrs[i] := vJson.Value[AOutStrs[i]];
  418. end;
  419. 1:
  420. begin
  421. AOutRecords := vJson.ArrayValues('info');
  422. end;
  423. 2:
  424. begin
  425. for i := Low(AOutStrs) to High(AOutStrs) do
  426. AOutStrs[i] := vJson.Value[AOutStrs[i]];
  427. AOutRecords := vJson.ArrayValues('info');
  428. end;
  429. 3:
  430. begin
  431. vJson.ChildValues('info', AOutStrs);
  432. AOutRecords := vJson.ArrayValues('auditinfo');
  433. end;
  434. end;
  435. Result := 1;
  436. end
  437. else if SameText(vJson.Value['status'], 'false') then // 数据读取失败
  438. begin
  439. case AResultType of
  440. 0:
  441. begin
  442. AOutStrs[Low(AOutStrs)] := vJson.Value['msg'];
  443. end;
  444. 1:
  445. begin
  446. SetLength(AOutRecords, 1, 1);
  447. AOutRecords[0, 0] := vJson.Value['msg'];
  448. end;
  449. 2, 3:
  450. begin
  451. AOutStrs[Low(AOutStrs)] := vJson.Value['msg'];
  452. SetLength(AOutRecords, 1, 1);
  453. AOutRecords[0, 0] := vJson.Value['msg'];
  454. end;
  455. end;
  456. Result := 0;
  457. end
  458. else if SameText(vJson.Value['status'], 'upgrade') then
  459. begin
  460. AOutStrs[Low(AOutStrs)] := vJson.Value['msg'];
  461. AOutStrs[Low(AOutStrs) + 1] := vJson.Value['url'];
  462. Result := 2;
  463. end;
  464. finally
  465. vJson.Free;
  466. end;
  467. end;
  468. finally
  469. postList.Free;
  470. ssResponse.Free;
  471. vIdHTTP.Free;
  472. end;
  473. end;
  474. function TPHPWeb.SystemDateTime: TDateTime;
  475. begin
  476. Result := Now;
  477. end;
  478. function TPHPWeb.NetError(AMid: string): string;
  479. begin
  480. Result := Format('当前网络状态较差(-1),%s,请重新尝试或重新登录后再尝试!', [AMid]);
  481. end;
  482. function TPHPWeb.PageError(AMid: string): string;
  483. begin
  484. Result := Format('Web页返回错误(000J),%s,请重新尝试或联系纵横客服。', [AMid]);
  485. end;
  486. procedure TPHPWeb.Debug(AFileName, AStr: string);
  487. var vSL: TStringList;
  488. sAdd: string;
  489. begin
  490. vSL := TStringList.Create;
  491. try
  492. sAdd := Format('%s%d %s %s', [#10#13#10#13#10#13#10#13#10#13,
  493. UserID, RealName, Account]);
  494. vSL.Add(AStr + sAdd);
  495. if Pos('Debug_', AFileName) = 0 then
  496. AFileName := 'Debug_' + AFileName;
  497. vSL.SaveToFile(WebPath + AFileName + '.txt');
  498. finally
  499. vSL.Free;
  500. end;
  501. end;
  502. procedure TPHPWeb.Debug(AFileName: string; AInFields, AInValues: array of string);
  503. var vSL: TStringList;
  504. sAdd: string;
  505. i: Integer;
  506. begin
  507. if G_IsTest then
  508. begin
  509. vSL := TStringList.Create;
  510. try
  511. sAdd := Format('%s%d %s %s', [#10#13#10#13#10#13#10#13#10#13, UserID, RealName, Account]);
  512. for i := Low(AInFields) to High(AInFields) do
  513. vSL.Add(AInFields[i] + #9#9 + AInValues[i]);
  514. vSL.Add(sAdd);
  515. if Pos('Debug_', AFileName) = 0 then
  516. AFileName := 'Debug_' + AFileName;
  517. vSL.SaveToFile(WebPath + AFileName + '.txt');
  518. finally
  519. vSL.Free;
  520. end;
  521. end;
  522. end;
  523. function TPHPWeb.ConnectServer(AIP: string; var ACompanyName: string): Integer;
  524. var vArr: array of string;
  525. sURL: string;
  526. begin
  527. sURL := Format('http://%s/api/client/software/title', [AIP]);
  528. vArr := VarArrayOf(['msg']);
  529. Result := Search(sURL, [], [], vArr);
  530. case Result of
  531. -1: ACompanyName := '地址不存在';
  532. 0: ACompanyName := '服务器Web页错误';
  533. 1: ACompanyName := vArr[0];
  534. end;
  535. end;
  536. function TPHPWeb.UpAttachment(AUperID, AWebID, ABillID, APhase: Integer; AFile,
  537. ACategory, AMemo: string; var ANewFileName, AFileID, ADownURL: string): Boolean;
  538. var
  539. vMPFDS: TIdMultiPartFormDataStream;
  540. sResult, sURL: string;
  541. J: TCslJson;
  542. vArr: array of string;
  543. vIdHTTP: TIdHTTP;
  544. begin
  545. Result := False;
  546. if not FileExists(AFile) then
  547. begin
  548. // Application.MessageBox(PChar(AFile + ' 文件不存在!'), '错误', MB_OK + MB_ICONERROR);
  549. Exit;
  550. end;
  551. vMPFDS := TIdMultiPartFormDataStream.Create;
  552. vIdHTTP := TIdHTTP.Create(nil);
  553. try
  554. sURL := Format('%stender/attachment/%d/%d/upload', [FMeasureURL, AWebID, AUperID]);
  555. // 如果文件已被打开,这里会报错。
  556. try
  557. vMPFDS.AddFile('upitem', AFile, 'text/plain');
  558. except
  559. MessageHint(0, '当前文件处于打开状态,请关闭文件,重新上传。');
  560. Exit;
  561. end;
  562. vMPFDS.AddFormField('itemid', IntToStr(ABillID));
  563. vMPFDS.AddFormField('category', ACategory);
  564. vMPFDS.AddFormField('memo', ReplaceCharsForJson(AMemo));
  565. vMPFDS.AddFormField('phase', IntToStr(APhase));
  566. vMPFDS.Position := 0;
  567. try
  568. sResult := vIdHTTP.Post(sURL, vMPFDS);
  569. except
  570. Abort;
  571. end;
  572. finally
  573. vMPFDS.Free;
  574. vIdHTTP.Free;
  575. end;
  576. J := TCslJson.Create;
  577. try
  578. J.Text := Utf8ToAnsi(sResult);
  579. if SameText(J.Value['status'], 'true') then
  580. begin
  581. Result := True;
  582. vArr := VarArrayOf(['onlinefilename', 'imnid', 'fileurl']);
  583. J.ChildValues('iteminfo', vArr);
  584. ANewFileName := vArr[0];
  585. AFileID := vArr[1];
  586. ADownURL := vArr[2];
  587. end
  588. else
  589. begin
  590. Result := False;
  591. end;
  592. finally
  593. J.Free;
  594. end;
  595. end;
  596. function TPHPWeb.GetAttachmentList(AWebID: Integer; var vArr: TOVArr): Boolean;
  597. var sURL: string;
  598. begin
  599. sURL := Format('%stender/attachment/%d/list', [FMeasureURL, AWebID]);
  600. Result := Search(sURL, [], [], vArr) = 1;
  601. end;
  602. function TPHPWeb.ExistInServer(AWebID: Integer): Boolean;
  603. var vArr: array of string;
  604. iResult: Integer;
  605. sSearchURL: string;
  606. begin
  607. sSearchURL := Format('%stender/get/%d/exist', [PHPWeb.MeasureURL, AWebID]);
  608. vArr := VarArrayOf(['id', 'name']);
  609. iResult := PHPWeb.Search(sSearchURL, [''], [''], vArr);
  610. if (iResult = 1) and (High(vArr) >= 0) then
  611. Result := True
  612. else
  613. Result := False;
  614. end;
  615. // 格式为 Measure:chen
  616. function TPHPWeb.GetNameFromURLProtocol(AURLProtocol: string): string;
  617. begin
  618. if Trim(AURLProtocol) = '' then
  619. Result := ''
  620. else
  621. Result := Copy(AURLProtocol, 9, Length(AURLProtocol) - 8);
  622. end;
  623. function TPHPWeb.DeleteAttachment(AFileID: Integer): Integer;
  624. var sURL: string;
  625. vArr: array of string;
  626. begin
  627. vArr := VarArrayOf(['msg']);
  628. sURL := Format('%stender/attachment/%d/del', [FMeasureURL, AFileID]);
  629. Result := Search(sURL, [], [], vArr);
  630. end;
  631. function TPHPWeb.UpAttachmentOnLine(AWebID, ABillID, APhase: Integer; AIDAry: array of string): Boolean;
  632. //var
  633. // vMPFDS: TIdMultiPartFormDataStream;
  634. // sResult, sURL: string;
  635. // J: TCslJson;
  636. // vArr: array of string;
  637. begin
  638. { Result := False;
  639. vMPFDS := TIdMultiPartFormDataStream.Create;
  640. try
  641. sURL := Format('%stender/attachment/%d/%d/upload', [FMeasureURL, AWebID, PHPWeb.UserID]);
  642. vMPFDS.AddFormField('itemid', IntToStr(ABillID));
  643. vMPFDS.AddFormField('phase', IntToStr(APhase));
  644. vMPFDS.Position := 0;
  645. try
  646. sResult := IdHTTP.Post(sURL, vMPFDS);
  647. except
  648. Abort;
  649. end;
  650. finally
  651. vMPFDS.Free;
  652. end;
  653. J := TCslJson.Create;
  654. try
  655. J.Text := Utf8ToAnsi(sResult);
  656. if SameText(J.Value['status'], 'true') then
  657. begin
  658. Result := True;
  659. vArr := VarArrayOf(['onlinefilename']);
  660. J.ChildValues('iteminfo', vArr);
  661. ANewFileName := vArr[0];
  662. end
  663. else
  664. begin
  665. Result := False;
  666. end;
  667. finally
  668. J.Free;
  669. end; }
  670. end;
  671. function TPHPWeb.UploadFile(AUrl: string; AInFields,
  672. AInValues: array of string; AFileName: string; var ErrorMessage: string): Boolean;
  673. var
  674. IdDataStream: TIdMultiPartFormDataStream;
  675. i: Integer;
  676. sPostResult: string;
  677. J: TCslJson;
  678. vIdHttp: TIdHTTP;
  679. begin
  680. Result := False;
  681. if not FileExists(AFileName) then Exit;
  682. IdDataStream := TIdMultiPartFormDataStream.Create;
  683. vIdHTTP := TIdHTTP.Create(nil);
  684. try
  685. for i := Low(AInFields) to High(AInFields) do
  686. IdDataStream.AddFormField(AInFields[i], AInValues[i]);
  687. IdDataStream.AddFile('upfile', AFileName, 'text/plain');
  688. IdDataStream.Position := 0;
  689. try
  690. sPostResult := vIdHTTP.Post(MeasureURL + AUrl, IdDataStream);
  691. J := TCslJson.Create;
  692. J.Text := Utf8ToAnsi(sPostResult);
  693. Result := SameText(J.Value['status'], 'true');
  694. if not Result then
  695. ErrorMessage := J.Value['msg'];
  696. finally
  697. J.Free;
  698. end;
  699. finally
  700. IdDataStream.Free;
  701. vIdHttp.Free;
  702. end;
  703. end;
  704. function TPHPWeb.UploadFiles(AUrl: string; AInFields, AInValues,
  705. AUpFileFields, AUpFileNames: array of string;
  706. var ErrorMessage: string): Boolean;
  707. var
  708. IdDataStream: TIdMultiPartFormDataStream;
  709. i: Integer;
  710. sPostResult: string;
  711. J: TCslJson;
  712. vIdHttp: TIdHTTP;
  713. begin
  714. Result := False;
  715. for i := Low(AUpFileNames) to High(AUpFileNames) do
  716. if not FileExists(AUpFileNames[i]) then Exit;
  717. IdDataStream := TIdMultiPartFormDataStream.Create;
  718. vIdHTTP := TIdHTTP.Create(nil);
  719. try
  720. for i := Low(AInFields) to High(AInFields) do
  721. IdDataStream.AddFormField(AInFields[i], AInValues[i]);
  722. for i := Low(AUpFileFields) to High(AUpFileFields) do
  723. IdDataStream.AddFile(AUpFileFields[i], AUpFileNames[i], 'text/plain');
  724. IdDataStream.Position := 0;
  725. J := TCslJson.Create;
  726. try
  727. sPostResult := vIdHTTP.Post(MeasureURL + AUrl, IdDataStream);
  728. J.Text := Utf8ToAnsi(sPostResult);
  729. Result := SameText(J.Value['status'], 'true');
  730. if not Result then
  731. ErrorMessage := J.Value['msg'];
  732. finally
  733. J.Free;
  734. end;
  735. finally
  736. IdDataStream.Free;
  737. vIdHttp.Free;
  738. end;
  739. end;
  740. function TPHPWeb.UrlGet(AUrl: string; APostParam: TStrings;
  741. var AResult: TStrings): Integer;
  742. var
  743. i: Integer;
  744. postList: TStrings;
  745. ssResponse: TStringStream;
  746. bDone: Boolean;
  747. vJson: TCslJson;
  748. vIdHTTP: TIdHTTP;
  749. begin
  750. Result := -1;
  751. ssResponse := TStringStream.Create('');
  752. vIdHTTP := TIdHTTP.Create(nil);
  753. try
  754. vIdHTTP.Post(AUrl, APostParam, ssResponse);
  755. if (Pos('200 OK', vIdHTTP.ResponseText) <> 0) then
  756. begin
  757. // Analyse Result Json
  758. vJson := TCslJson.Create;
  759. try
  760. vJson.Text := Utf8ToAnsi(ssResponse.DataString);
  761. if SameText(vJson.Value['status'], 'true') then
  762. begin
  763. vJson.ValueStrings('info', AResult);
  764. Result := 1;
  765. end
  766. else if SameText(vJson.Value['status'], 'false') then
  767. begin
  768. AResult.Add(vJson.Value['msg']);
  769. Result := 0;
  770. end
  771. else
  772. begin
  773. AResult.Add('查询数据出错, 请重试');
  774. Result := 0;
  775. end;
  776. finally
  777. vJson.Free;
  778. end;
  779. end;
  780. finally
  781. vIdHTTP.Free;
  782. ssResponse.Free;
  783. end;
  784. end;
  785. function TPHPWeb.UrlGet(AUrl: string; APostParam: TStrings;
  786. var AResult: string): Integer;
  787. var
  788. i: Integer;
  789. ssResponse: TStringStream;
  790. vJ: ISuperObject;
  791. vIdHTTP: TIdHTTP;
  792. begin
  793. Result := -1;
  794. AResult := '';
  795. ssResponse := TStringStream.Create('');
  796. vIdHTTP := TIdHTTP.Create(nil);
  797. try
  798. vIdHTTP.Post(AUrl, APostParam, ssResponse);
  799. if (Pos('200 OK', vIdHTTP.ResponseText) <> 0) then
  800. begin
  801. // Analyse Result Json
  802. try
  803. vJ := SO(Utf8ToAnsi(ssResponse.DataString));
  804. if SameText(vJ['status'].AsString, 'true') then
  805. begin
  806. AResult := vJ['info'].AsString;
  807. Result := 1;
  808. end
  809. else if SameText(vJ['status'].AsString, 'false') then
  810. begin
  811. AResult := vJ['msg'].AsString;
  812. Result := 0;
  813. end
  814. else
  815. begin
  816. AResult := '查询数据出错, 请重试';
  817. Result := 0;
  818. end;
  819. finally
  820. vJ := nil;
  821. end;
  822. end;
  823. finally
  824. vIdHTTP.Free;
  825. ssResponse.Free;
  826. end;
  827. end;
  828. function TPHPWeb.Search(AURL: string; var AOutStrs: array of string): Integer;
  829. var vA: TOVArr;
  830. begin
  831. Result := CustomSearch(AURL, [], [], 0, AOutStrs, vA);
  832. end;
  833. function TPHPWeb.Search(AURL: string; var AOutRecords: TOVArr): Integer;
  834. var vA: array of string;
  835. begin
  836. Result := CustomSearch(AURL, [], [], 1, vA, AOutRecords);
  837. end;
  838. procedure TPHPWeb.ReadIniValues;
  839. var ini: TIniFile;
  840. begin
  841. ini := TIniFile.Create(ExtractFilePath(Application.ExeName) + 'Cloud.ini');
  842. try
  843. // FMeasureURL := ini.ReadString('URL', 'MeasureURL', '');
  844. FMeasureURL := 'http://' + ini.ReadString('URL', 'Server', '') +
  845. ini.ReadString('URL', 'MeasureURL', '');
  846. FWebSoftURL := ini.ReadString('URL', 'WebSoftURL', '');
  847. FPassportURL := ini.ReadString('URL', 'PassportURL', '');
  848. FLoginCloudURL := ini.ReadString('URL', 'LoginCloudURL', '');
  849. FLoginURL := FWebSoftURL + ini.ReadString('URL', 'LoginURL', '');
  850. FWebLoginURL := FWebSoftURL + ini.ReadString('URL', 'FWebLoginURL', '');
  851. FLoginBannerURL := FWebSoftURL + ini.ReadString('URL', 'LoginBannerURL', '');
  852. FLogoutURL := FWebSoftURL + ini.ReadString('URL', 'LogoutURL', '');
  853. FRegURL := FPassportURL + ini.ReadString('URL', 'RegURL', '');
  854. FPwdURL := FPassportURL + ini.ReadString('URL', 'PwdURL', '');
  855. FCheckOnLineURL := FWebSoftURL + ini.ReadString('URL', 'CheckOnLineURL', '');
  856. FServerDateTimeURL := FWebSoftURL + ini.ReadString('URL', 'ServerDateTimeURL', '');
  857. finally
  858. ini.Free;
  859. end;
  860. end;
  861. initialization
  862. finalization
  863. if g_PHPWeb <> nil then
  864. g_PHPWeb.Free;
  865. end.