php 正则问题 求大师兄们帮忙

[偶滴神啊]

请教各位师兄们 php正则如何取出所有回调失败的金额的值然后相加 方便统计总结果

DD_belatedPNG.fix('*');



















订单管理
首页>订单管理>订单流水
日期范围：--支付类型-
微信WAP
微信扫码
支付宝WAP
支付宝扫码
搜订单
共有数据：49条我方单号
商户单号
总金额
已付金额
商品描述
订单状态
商户回调状态
下单时间
支付完成时间
2017110500092917
T20171105053051710397
22.00
22.00支付完成已回调2017-11-0505:29:49
2017-11-0505:30:12
2017110500092914
T20171105053049636396
22.00
22.00支付完成已回调2017-11-0505:29:48
2017-11-0505:30:20
2017110500092870
T20171105053026034389
28.00
28.00支付完成已回调2017-11-0505:29:23
2017-11-0505:30:26
2017110500092837
T20171105053014009387
28.00
28.00支付完成已回调2017-11-0505:29:11
2017-11-0505:30:42
2017110500092826
T20171105053008755385
22.00
22.00支付完成已回调2017-11-0505:29:06
2017-11-0505:30:19
2017110500092815
T20171105053003076382
22.00
22.00支付完成已回调2017-11-0505:29:01
2017-11-0505:29:46
2017110500092806
T20171105053001374381
39.00
39.00支付完成
回调失败
2017-11-0505:29:00
2017-11-0505:29:26
2017110500092781
T20171105052953184030
66.00
66.00支付完成已回调2017-11-0505:28:51
2017-11-0505:29:09
2017110500092769
T20171105052947220028
20.00
20.00支付完成已回调2017-11-0505:28:45
2017-11-0505:30:03
2017110500092723
T20171105052917370374
18.00
18.00支付完成已回调2017-11-0505:28:16
2017-11-0505:28:55
2017110500092715
T20171105052915185373
20.00
20.00支付完成已回调2017-11-0505:28:13
2017-11-0505:28:44
2017110500092703
T20171105052908549023
28.00
28.00支付完成已回调2017-11-0505:28:06
2017-11-0505:29:18
2017110500092695
T20171105052903484021
39.00
39.00支付完成已回调2017-11-0505:28:01
2017-11-0505:29:10
2017110500092637
T20171105052832362014
18.00
18.00支付完成已回调2017-11-0505:27:30
2017-11-0505:28:29
2017110500092542
T20171105052756575005
22.00
22.00支付完成已回调2017-11-0505:26:54
2017-11-0505:27:37
2017110500092537
T20171105052753123354
22.00
22.00支付完成已回调2017-11-0505:26:51
2017-11-0505:27:26
2017110500092521
T20171105052746184002
22.00
22.00支付完成已回调2017-11-0505:26:45
2017-11-0505:29:39
2017110500092495
T20171105052733941000
28.00
28.00支付完成已回调2017-11-0505:26:31
2017-11-0505:26:49
2017110500092448
T20171105052712994348
22.00
22.00支付完成已回调2017-11-0505:26:11
2017-11-0505:26:58
2017110500092443
T20171105052710284347
72.00
72.00支付完成已回调2017-11-0505:26:08
2017-11-0505:27:02
2017110500092372
T20171105052635100985
20.00
20.00支付完成已回调2017-11-0505:25:33
2017-11-0505:27:13
2017110500092358
T20171105052629308983
22.00
22.00支付完成已回调2017-11-0505:25:27
2017-11-0505:25:56
2017110500092356
T20171105052629289343
39.00
39.00支付完成已回调2017-11-0505:25:27
2017-11-0505:25:52
2017110500092353
T20171105052627313981
15.00
15.00支付完成已回调2017-11-0505:25:25
2017-11-0505:29:44
2017110500092327
T20171105052612102341
22.00
22.00支付完成已回调2017-11-0505:25:11
2017-11-0505:26:16
2017110500092270
T20171105052545292335
28.00
28.00支付完成已回调2017-11-0505:24:43
2017-11-0505:25:28
2017110500092227
T20171105052520901333
28.00
28.00支付完成
回调失败
2017-11-0505:24:20
2017-11-0505:25:03
2017110500092203
T20171105052511804330
20.00
20.00支付完成已回调2017-11-0505:24:10
2017-11-0505:24:29
2017110500092185
T20171105052501848328
22.00
22.00支付完成已回调2017-11-0505:23:59
2017-11-0505:24:11
2017110500092154
T20171105052449100323
39.00
39.00支付完成已回调2017-11-0505:23:48
2017-11-0505:26:49
2017110500092144
T20171105052443271958
18.00
18.00支付完成已回调2017-11-0505:23:42
2017-11-0505:24:25
2017110500092143
T20171105052443599321
18.00
18.00支付完成已回调2017-11-0505:23:41
2017-11-0505:24:28
2017110500092095
T20171105052415577951
20.00
20.00支付完成已回调2017-11-0505:23:14
2017-11-0505:23:36
2017110500092011
T20171105052342923939
28.00
28.00支付完成已回调2017-11-0505:22:40
2017-11-0505:23:43
2017110500091986
T20171105052332887307
28.00
28.00支付完成已回调2017-11-0505:22:30
2017-11-0505:25:50
2017110500091985
T20171105052331343306
22.00
22.00支付完成已回调2017-11-0505:22:30
2017-11-0505:23:13
2017110500091922
T20171105052254416926
20.00
20.00支付完成
回调失败
2017-11-0505:21:52
2017-11-0505:22:01
2017110500091918
T20171105052252791297
20.00
20.00支付完成已回调2017-11-0505:21:50
2017-11-0505:21:56
2017110500091913
T20171105052249944923
39.00
39.00支付完成已回调2017-11-0505:21:48
2017-11-0505:23:11
2017110500091908
T20171105052246740296
20.00
20.00支付完成已回调2017-11-0505:21:45
2017-11-0505:22:29
2017110500091904
T20171105052245720294
39.00
39.00支付完成
回调失败
2017-11-0505:21:44
2017-11-0505:22:12
2017110500091877
T20171105052233800918
18.00
18.00支付完成
回调失败
2017-11-0505:21:31
2017-11-0505:21:59
2017110500091870
T20171105052232492917
22.00
22.00支付完成已回调2017-11-0505:21:30
2017-11-0505:22:10
2017110500091834
T20171105052218663912
22.00
22.00支付完成已回调2017-11-0505:21:17
2017-11-0505:22:11
2017110500091816
T20171105052208879908
66.00
66.00支付完成已回调2017-11-0505:21:07
2017-11-0505:21:22
2017110500091811
T20171105052206873286
39.00
39.00支付完成已回调2017-11-0505:21:04
2017-11-0505:26:35
2017110500091795
T20171105052157984906
28.00
28.00支付完成已回调2017-11-0505:20:55
2017-11-0505:21:08
2017110500091713
T20171105052127179898
20.00
20.00支付完成已回调2017-11-0505:20:25
2017-11-0505:20:50
2017110500091712
T20171105052126822275
22.00
22.00支付完成已回调2017-11-0505:20:24
2017-11-0505:21:40$(function(){
/*$('.table-sort').dataTable({
"aaSorting":[[1,"desc"]],//默认第几个排序
"bStateSave":true,//状态保存
"aoColumnDefs":[
//{"bVisible":false,"aTargets":[3]}//控制列的隐藏显示
{"orderable":false,"aTargets":[0,6]}//制定列不参与排序
]
});*/
layui.use('laypage',function(){
varlaypage=layui.laypage;
//总页数大于页码总数
laypage.render({
elem:'pageUC'
,theme:'#5A98DE'
,count:"49"//数据总数
,curr:"1"
,jump:function(obj,first){
console.log(obj);
$("#currentPage").val(obj.curr);
if(!first){
layer.load(2);
$("form").submit();
}
}
});
});
$('.table-sorttbody').on('click','tr',function(){
if($(this).hasClass('selected')){
$(this).removeClass('selected');
}
else{
table.$('tr.selected').removeClass('selected');
$(this).addClass('selected');
}
});
});
functionchangePage(){
layer.load(2);
$("#currentPage").val(1);
$("form").submit();
}

[偶滴神啊]

没人会吗？

[tottyandbaty]

这个不需要用正则啊，逐行读取啊，逐行判断啊。

[小熊开发]

        preg_match_all('/回调失败[\s\S]+?(\d+?\.\d{2})/' ,  $str, $matchs);
        var_dump($matchs[1]);
        var_dump(array_sum($matchs[1]));

[hongmei85]

 $str = <<<TEXT
 订单管理
首页>订单管理>订单流水
日期范围：--支付类型-
微信WAP
微信扫码
支付宝WAP
支付宝扫码
搜订单
共有数据：49条我方单号
商户单号
总金额
已付金额
商品描述
订单状态
商户回调状态
下单时间
支付完成时间
2017110500092917
T20171105053051710397
22.00
22.00支付完成已回调2017-11-0505:29:49
2017-11-0505:30:12
2017110500092914
T20171105053049636396
22.00
22.00支付完成已回调2017-11-0505:29:48
2017-11-0505:30:20
2017110500092870
T20171105053026034389
28.00
28.00支付完成已回调2017-11-0505:29:23
2017-11-0505:30:26
2017110500092837
T20171105053014009387
28.00
28.00支付完成已回调2017-11-0505:29:11
2017-11-0505:30:42
2017110500092826
T20171105053008755385
22.00
22.00支付完成已回调2017-11-0505:29:06
2017-11-0505:30:19
2017110500092815
T20171105053003076382
22.00
22.00支付完成已回调2017-11-0505:29:01
2017-11-0505:29:46
2017110500092806
T20171105053001374381
39.00
39.00支付完成
回调失败
2017-11-0505:29:00
2017-11-0505:29:26
2017110500092781
T20171105052953184030
66.00
66.00支付完成已回调2017-11-0505:28:51
2017-11-0505:29:09
2017110500092769
T20171105052947220028
20.00
20.00支付完成已回调2017-11-0505:28:45
2017-11-0505:30:03
2017110500092723
T20171105052917370374
18.00
18.00支付完成已回调2017-11-0505:28:16
2017-11-0505:28:55
2017110500092715
T20171105052915185373
20.00
20.00支付完成已回调2017-11-0505:28:13
2017-11-0505:28:44
2017110500092703
T20171105052908549023
28.00
28.00支付完成已回调2017-11-0505:28:06
2017-11-0505:29:18
2017110500092695
T20171105052903484021
39.00
39.00支付完成已回调2017-11-0505:28:01
2017-11-0505:29:10
2017110500092637
T20171105052832362014
18.00
18.00支付完成已回调2017-11-0505:27:30
2017-11-0505:28:29
2017110500092542
T20171105052756575005
22.00
22.00支付完成已回调2017-11-0505:26:54
2017-11-0505:27:37
2017110500092537
T20171105052753123354
22.00
22.00支付完成已回调2017-11-0505:26:51
2017-11-0505:27:26
2017110500092521
T20171105052746184002
22.00
22.00支付完成已回调2017-11-0505:26:45
2017-11-0505:29:39
2017110500092495
T20171105052733941000
28.00
28.00支付完成已回调2017-11-0505:26:31
2017-11-0505:26:49
2017110500092448
T20171105052712994348
22.00
22.00支付完成已回调2017-11-0505:26:11
2017-11-0505:26:58
2017110500092443
T20171105052710284347
72.00
72.00支付完成已回调2017-11-0505:26:08
2017-11-0505:27:02
2017110500092372
T20171105052635100985
20.00
20.00支付完成已回调2017-11-0505:25:33
2017-11-0505:27:13
2017110500092358
T20171105052629308983
22.00
22.00支付完成已回调2017-11-0505:25:27
2017-11-0505:25:56
2017110500092356
T20171105052629289343
39.00
39.00支付完成已回调2017-11-0505:25:27
2017-11-0505:25:52
2017110500092353
T20171105052627313981
15.00
15.00支付完成已回调2017-11-0505:25:25
2017-11-0505:29:44
2017110500092327
T20171105052612102341
22.00
22.00支付完成已回调2017-11-0505:25:11
2017-11-0505:26:16
2017110500092270
T20171105052545292335
28.00
28.00支付完成已回调2017-11-0505:24:43
2017-11-0505:25:28
2017110500092227
T20171105052520901333
28.00
28.00支付完成
回调失败
2017-11-0505:24:20
2017-11-0505:25:03
2017110500092203
T20171105052511804330
20.00
20.00支付完成已回调2017-11-0505:24:10
2017-11-0505:24:29
2017110500092185
T20171105052501848328
22.00
22.00支付完成已回调2017-11-0505:23:59
2017-11-0505:24:11
2017110500092154
T20171105052449100323
39.00
39.00支付完成已回调2017-11-0505:23:48
2017-11-0505:26:49
2017110500092144
T20171105052443271958
18.00
18.00支付完成已回调2017-11-0505:23:42
2017-11-0505:24:25
2017110500092143
T20171105052443599321
18.00
18.00支付完成已回调2017-11-0505:23:41
2017-11-0505:24:28
2017110500092095
T20171105052415577951
20.00
20.00支付完成已回调2017-11-0505:23:14
2017-11-0505:23:36
2017110500092011
T20171105052342923939
28.00
28.00支付完成已回调2017-11-0505:22:40
2017-11-0505:23:43
2017110500091986
T20171105052332887307
28.00
28.00支付完成已回调2017-11-0505:22:30
2017-11-0505:25:50
2017110500091985
T20171105052331343306
22.00
22.00支付完成已回调2017-11-0505:22:30
2017-11-0505:23:13
2017110500091922
T20171105052254416926
20.00
20.00支付完成
回调失败
2017-11-0505:21:52
2017-11-0505:22:01
2017110500091918
T20171105052252791297
20.00
20.00支付完成已回调2017-11-0505:21:50
2017-11-0505:21:56
2017110500091913
T20171105052249944923
39.00
39.00支付完成已回调2017-11-0505:21:48
2017-11-0505:23:11
2017110500091908
T20171105052246740296
20.00
20.00支付完成已回调2017-11-0505:21:45
2017-11-0505:22:29
2017110500091904
T20171105052245720294
39.00
39.00支付完成
回调失败
2017-11-0505:21:44
2017-11-0505:22:12
2017110500091877

T20171105052233800918
18.00
18.00支付完成
回调失败
2017-11-0505:21:31
2017-11-0505:21:59
2017110500091870
TEXT;
  
preg_match_all('/(\d+?\.\d{2})支付完成[\n\r]+?回调失败/' ,  $str, $matchs);
var_dump($matchs[1]);
var_dump(array_sum($matchs[1]));