public function NewBillParse($s, array &$info, array &$details)
{
#账户基本信息
$date = '\\d{4}\\/\\d{2}\\/\\d{2}';
$money = '[\\-\\d\\.,]+';
$p = "/Ceiling Credit Limit # ({$money}) # 日常信用额度 Daily Credit Limit # ({$money}) # 取现额度 Cash Advance Limit # ({$money}) #/";
$r = $this->pregMatchAll($p, $s, $out);
// print_r($out);
// exit;
if ($r) {
$info['credit_limit'] = ParseUtil::formatMoney($out[1][0]);
$info['cash_advance_limit'] = ParseUtil::formatMoney($out[3][0]);
} else {
# # 信用额度 Credit Limit # 11,000 # 取现额度 Cash Advance
# Limit # 3,300 # 本期应还款总额 Total Statement Balance # RMB:4,130.41 USD:0.00
# # 本期最低还款额
$p = "/信用额度 Credit Limit # ({$money}) # 取现额度 Cash Advance Limit # ({$money}) # 本期应还款总额/";
$r = $this->pregMatchAll($p, $s, $out);
// print_r($out);
// exit;
$info['credit_limit'] = ParseUtil::formatMoney($out[1][0]);
$info['cash_advance_limit'] = ParseUtil::formatMoney($out[2][0]);
}
// print_r($info);
// exit;
$p = "/Total.*?({$money}) USD:0.00 # 本期最低还款额 Total Min Amount Due # RMB:({$money}) USD:0.00 # 到期还款日 Payment Due Date # ({$date}) #/";
//Total Statement Balance # RMB:4,035.97 # 本期最低还款额 Total Min Amount Due # RMB:675.59 # 到期还款日 Payment Due Date # 2014/08/09 # 本期积分余额 Total Points Available # 65,701 #
$r = $this->pregMatchAll($p, $s, $out);
if (!$r) {
$p = "/Total.*?({$money}) # 本期最低还款额 Total Min Amount Due # RMB:({$money}) # 到期还款日 Payment Due Date # ({$date}) #/";
//Total Statement Balance # RMB:4,035.97 # 本期最低还款额 Total Min Amount Due # RMB:675.59 # 到期还款日 Payment Due Date # 2014/08/09 # 本期积分余额 Total Points Available # 65,701 #
$r = $this->pregMatchAll($p, $s, $out);
}
if ($r) {
$info['new_balance'] = ParseUtil::formatMoney($out[1][0]);
$info['min_payment'] = ParseUtil::formatMoney($out[2][0]);
$info['payment_due_date'] = ParseUtil::formatDate($out[3][0]);
$info['payment_cur_date'] = strtotime('20 days ago', $info['payment_due_date']);
$info['statement_end_date'] = $info['payment_cur_date'];
$info['statement_start_date'] = strtotime('30 days ago', $info['statement_end_date']);
}
//本期账务说明
$p = "/Last Statement Balance # [RMB:]*({$money})[^#]*#[^#]*# [RMB:]*({$money})[^#]*#[^#]*# [RMB:]*({$money})/";
$p = "/New Charges # RMB:({$money}) USD:0.00 # # RMB:({$money}) USD:0.00 # # RMB:({$money}) USD:0.00 # # RMB:({$money}) USD:0.00 #/";
$r = $this->pregMatchAll($p, $s, $out);
// print_r($out);
// exit;
if (!$r) {
$p = "/New Charges # RMB:({$money}) # # RMB:({$money}) # # RMB:({$money}) # # RMB:({$money}) #/";
$r = $this->pregMatchAll($p, $s, $out);
}
if ($r) {
$info['last_balance'] = ParseUtil::formatMoney($out[2][0]);
$info['last_payment'] = ParseUtil::formatMoney($out[3][0]);
$info['new_charges'] = ParseUtil::formatMoney($out[4][0]);
}
//积分明细
$num = '[\\-\\d,]+';
//$p = "/Points Beginning Balance # ($num) #[^#]+# ($num) #[^#]+# ($num) #[^#]+# ($num) #[^#]+# ($num) #[^#]+# ($num)/";
$p = "/本期兑换积分 Points Redeemed This Month # ({$num}) # ({$num}) # # ({$num}) # # ({$num}) # # ({$num}) # # ({$num}) # # ({$num}) #/";
$r = $this->pregMatchAll($p, $s, $out);
// print_r($out);
// exit;
if ($r) {
$info['total_points'] = ParseUtil::formatNum($out[2][0]);
$info['last_points'] = ParseUtil::formatNum($out[3][0]);
$info['earned_points'] = ParseUtil::formatNum($out[4][0]);
$info['adjusted_points'] = ParseUtil::formatNum($out[5][0]);
$info['rewarded_points'] = ParseUtil::formatNum($out[6][0]);
$info['redeemed_points'] = ParseUtil::formatNum($out[7][0]);
$info = ParseUtil::trimArr($info);
}
//本期账务明细
$p = '/交易金额 Amount(.*)# 卡号末四位/';
$r = $this->pregMatchAll($p, $s, $out);
$d = $out[1][0];
$p = "/({$date}) # ({$date}) # ([^#]*) # (\\d{4}) # [RMB:]*({$money})/";
$r = $this->pregMatchAll($p, $d, $out);
// print_r($out);
// exit;
if ($r) {
$cards = array_unique($out[4], SORT_REGULAR);
sort($cards);
$defaultNo = array_pop($cards);
for ($i = 0; $i < count($out[0]); $i++) {
$one['trans_date'] = ParseUtil::formatDate($out[1][$i], $info['statement_end_date']);
$one['post_date'] = ParseUtil::formatDate($out[2][$i], $info['statement_end_date']);
$one['description'] = $out[3][$i];
$cardNo = empty($out[4][$i]) ? $defaultNo : $out[4][$i];
$one['card_no'] = $cardNo;
$one['rmb_amount'] = ParseUtil::formatMoney($out[5][$i]);
$details[$cardNo][] = ParseUtil::trimArr($one);
unset($one);
}
print_r($details);
}
}
public function parse($content)
{
// echo $content;
// exit;
$info = array();
$s = str_replace(' ', ' ', $content);
$s = str_replace('#', '', $s);
$s = str_replace(array('</td>', '</TD>'), ' # ', $s);
$s = strip_tags($s);
$s = preg_replace('/\\s+/', ' ', $s);
// $s = preg_replace('/(#\s)+/', '# ', $s);
// file_put_contents('/home/rong/tmp/huaxia.one.' . date('Ymd.His') . '.' . rand(0,100) . '.txt', $s);
#用户信息
$zh = '[\\x{4e00}-\\x{9fa5}]+';
$p = "/尊敬的\\s*({$zh})\\s*(先生|女士)/u";
$r = $this->pregMatchAll($p, $s, $out);
if (!$r) {
$p = "/尊敬的*({$zh})\\s*(先生|女士)/u";
$r = $this->pregMatchAll($p, $s, $out);
}
$info['name'] = $out[1][0];
$info['sex'] = $out[2][0];
$date = '\\d{4}\\/\\d{2}\\/\\d{2}';
$money = '[\\-\\d\\.,]+';
$this->pregMatchAll('/信用卡对账单[^\\d]*?(\\d.*)份/', $s, $out);
$month = $out[1][0];
#账户基本信息
$p = "/Statement Date: # 每月(\\d{2}日).*Payment Due Date: # ({$date}).*Credit Limit: # ({$money}).*Cash Advance Limit: # ({$money})/";
$r = $this->pregMatchAll($p, $s, $out);
if ($r) {
$info['payment_cur_date'] = ParseUtil::formatDate($month . $out[1][0]);
$info['payment_due_date'] = ParseUtil::formatDate($out[2][0]);
$info['credit_limit'] = ParseUtil::formatMoney($out[3][0]);
$info['cash_advance_limit'] = ParseUtil::formatMoney($out[4][0]);
$info['statement_end_date'] = $info['payment_cur_date'];
$info['payment_cur_date'] > 0 && ($info['statement_start_date'] = strtotime('last month', $info['payment_cur_date']));
}
$rmbStr = substr($s, 0, strpos($s, "美元账户"));
#账户还款计算明细（tip:中间有中文空白符）
$p = "/Amount Payable: ({$money}).*?Minimum Payment: ({$money}).*?Interest # ({$money})[\\s #]+({$money})[\\s #]+({$money})[\\s #]+({$money})[\\s #]+({$money})[\\s #]+({$money})/";
$r = $this->pregMatchAll($p, $s, $out);
if ($r) {
// print_r($out);
// exit;
$info['new_balance'] = ParseUtil::formatMoney($out[3][0]);
// Closing Balance
$info['min_payment'] = ParseUtil::formatMoney($out[2][0]);
//Minimum Payment:
$info['last_balance'] = ParseUtil::formatMoney($out[4][0]);
//Opening Balance
$info['last_payment'] = ParseUtil::formatMoney($out[5][0]);
// New Credits
$info['new_charges'] = ParseUtil::formatMoney($out[6][0]);
//New Debits
$info['adjustment'] = ParseUtil::formatMoney($out[7][0]);
//Adjustment
$info['interest'] = ParseUtil::formatMoney($out[8][0]);
//Interest
}
print_r($info);
#积分明细
$number = '[\\d,]+';
$p = "/Points Redeemed this month # ({$number})[\\s #]+({$number})[\\s #]+({$number})[\\s #]+({$number})[\\s #]+({$number})[\\s #]+({$number})/";
$r = $this->pregMatchAll($p, $s, $out);
if ($r) {
$info['total_points'] = ParseUtil::formatNum($out[1][0]);
$info['last_points'] = ParseUtil::formatNum($out[2][0]);
$info['earned_points'] = ParseUtil::formatNum($out[3][0]);
$info['rewarded_points'] = ParseUtil::formatNum($out[4][0]);
$info['adjusted_points'] = ParseUtil::formatNum($out[5][0]);
$info['redeemed_points'] = ParseUtil::formatNum($out[6][0]);
$info = ParseUtil::trimArr($info);
}
var_export($info);
//详细交易信息
$details = array();
$p = "/({$date})[^#]* # ({$date}) # ([^#]*) # ({$money}) # (\\d{4})/";
$this->pregMatchAll($p, $s, $out);
for ($j = 0; $j < count($out[0]); $j++) {
$one['trans_date'] = ParseUtil::formatDate($out[1][$j], $info['statement_end_date']);
$one['post_date'] = ParseUtil::formatDate($out[2][$j], $info['statement_end_date']);
$one['description'] = $out[3][$j];
$one['rmb_amount'] = ParseUtil::formatMoney($out[4][$j]);
$one['currency'] = ParseUtil::getCurrencyType($out[4][$j]);
$one['card_no'] = $out[5][$j];
$cardNo = $one['card_no'];
$one['orign_amount'] = $one['rmb_amount'];
$one['type'] = ParseUtil::getConsumeType($one['description']);
// 消费分类
$one['is_doubt'] = ParseUtil::isDoubtComsume($one['description']);
// 可疑消费分析
$details[$cardNo][] = ParseUtil::trimArr($one);
}
if (empty($details)) {
return $this->insert($info);
}
//区分不同的卡
foreach ($details as $cardNo => $detail) {
$oneCardInfo = $info;
$oneCardInfo['card_no'] = $cardNo;
$oneCardInfo['trans_detail'] = json_encode($detail);
$this->insert($oneCardInfo);
}
return true;
}
public function parse($content)
{
$info = array();
$s = str_replace(' ', ' ', $content);
$s = preg_replace('/<\\/td>/', ' # ', $s);
$s = strip_tags($s);
$s = preg_replace('/\\s+/', ' ', $s);
$s = preg_replace('/(#\\s)+/', '# ', $s);
// file_put_contents('/home/rong/tmp/gongshang.' .time() . '.' . rand(0,100) . '.txt', $s);
//用户信息
$zh = '[\\x{4e00}-\\x{9fa5}]+';
$p = "/尊敬的\\s*?({$zh})\\s*?(女士|先生)/u";
$r = $this->pregMatchAll($p, $s, $out);
if ($r) {
$info['name'] = $out[1][0];
$info['sex'] = $out[2][0];
}
$cardPattern = '# (\\d{4}) #';
preg_match_all("/{$cardPattern}/", $s, $cardMatch);
$card_num_arr = array();
$unique_cards_arr = array_unique($cardMatch[1]);
foreach ($unique_cards_arr as $val) {
$card_num_arr[] = substr($val, -4);
}
$cards_count = count($card_num_arr);
$all_card_no_str = implode(',', array_unique($card_num_arr));
var_dump($all_card_no_str);
var_dump($cards_count);
exit;
//用户基本信息
$p = '/贷记卡到期还款日 # ([^#]+) #.*?账单周期 ([^#]+) # 对账单生成日 ([^#]+) #/';
$r = $this->pregMatchAll($p, $s, $out);
$t = explode('—', trim($out[2][0]));
if ($t) {
$info['statement_start_date'] = ParseUtil::formatDate($t[0]);
$info['statement_end_date'] = strtotime('+ 30 days', $info['statement_start_date']);
$info['payment_cur_date'] = ParseUtil::formatDate($out[3][0]);
$info['payment_due_date'] = ParseUtil::formatDate($out[1][0]);
}
$cards = array();
$p = '/信用额度 #(.*)?合计 # 人民币/';
$r = $this->pregMatchAll($p, $s, $out);
$d = $out[1][0];
$money = '([\\d\\-\\.\\/,RMB]+)';
$p = "/(\\d+)[^#]*? # (\\S+) # {$money} # {$money} # {$money}/";
$r = $this->pregMatchAll($p, $d, $out);
// print_r($out);
// exit;
if ($out[1][0]) {
$info['card_no'] = $all_card_no_str;
}
for ($i = 0; $i < count($out[0]); $i++) {
$cardNo = $out[1][$i];
$card['new_balance'] = ParseUtil::formatMoney($out[3][$i]);
$card['min_payment'] = ParseUtil::formatMoney($out[4][$i]);
$card['credit_limit'] = ParseUtil::formatMoney($out[5][$i]);
$cards[$cardNo]['balance']['人民币'] = $card;
}
//本期交易汇总(人民币)
$p = '/本期余额 # .*?人民币(.*)?合计/';
$r = $this->pregMatchAll($p, $s, $out);
$d = $out[1][0];
$p = "/(\\d+) # {$money} # {$money} # {$money} # {$money}/";
$r = $this->pregMatchAll($p, $d, $out);
/*
for ($i = 0; $i < count($out[0]); $i++) {
$cardNo = $out[1][$i];
$one ['last_balance'] = ParseUtil::formatMoney($out[2][$i]);
$one ['last_payment'] = ParseUtil::formatMoney($out[3][$i]);
$one ['new_charges'] = ParseUtil::formatMoney($out[4][$i]);
if (is_array($cards[$cardNo]['balance']['人民币'])) {
$cards[$cardNo]['balance']['人民币'] = array_merge($cards[$cardNo]['balance']['人民币'], $one);
} else {
$cards[$cardNo]['balance']['人民币'] = $one;
}
}
*/
// print_r($out);
// exit;
if ($r) {
if ($cards_count > 1) {
$cardNo = $out[1][$i];
$last_balance = 0;
foreach ($out[2] as $val) {
$last_balance += ParseUtil::formatMoney($val);
}
$one['last_balance'] = $last_balance * -1;
//last_balance 正负号对调
$last_payment = 0;
foreach ($out[3] as $val) {
$last_payment += ParseUtil::formatMoney($val);
}
$one['last_payment'] = $last_payment;
$new_charges = 0;
foreach ($out[4] as $val) {
$new_charges += ParseUtil::formatMoney($val);
}
$one['new_charges'] = $new_charges;
if (is_array($cards[$cardNo]['balance']['人民币'])) {
$cards[$cardNo]['balance']['人民币'] = array_merge($cards[$cardNo]['balance']['人民币'], $one);
} else {
$cards[$cardNo]['balance']['人民币'] = $one;
}
// print_r($one);
// exit;
} else {
for ($i = 0; $i < count($out[0]); $i++) {
$cardNo = $out[1][$i];
$one['last_balance'] = ParseUtil::formatMoney($out[2][$i]) * -1;
//last_balance 正负号对调
$one['last_payment'] = ParseUtil::formatMoney($out[3][$i]);
$one['new_charges'] = ParseUtil::formatMoney($out[4][$i]);
if (is_array($cards[$cardNo]['balance']['人民币'])) {
$cards[$cardNo]['balance']['人民币'] = array_merge($cards[$cardNo]['balance']['人民币'], $one);
} else {
$cards[$cardNo]['balance']['人民币'] = $one;
}
}
}
// var_dump($one);
// exit;
# Yii::log(print_r($out,1).print_r($s,1)."=======gongshang0==");
}
//详细交易信息
$date = '\\d{4}\\-\\d{2}\\-\\d{2}';
$p = '/交 易 明 细 #(.*)?积 分 信 息 /';
$r = $this->pregMatchAll($p, $s, $out);
$d = $out[1][0];
// print_r($out);
// exit;
$p = "/(\\d{4}) # ({$date}) # ({$date}) # ([^#]*) # ([^#]*) # {$money} # {$money}\\((存入|支出)\\)/";
# $p = "/(\d{4}) # ($date) # ($date) # (\S+) # (\S+) # $money # $money\((存入|支出)\)/";
$r = $this->pregMatchAll($p, $d, $out);
for ($i = 0; $i < count($out[0]); $i++) {
unset($one);
$cardNo = $out[1][$i];
$one['card_no'] = $cardNo;
$one['trans_date'] = intval(strtotime($out[2][$i]));
$one['post_date'] = intval(strtotime($out[3][$i]));
$one['description'] = $out[4][$i];
$one['rmb_amount'] = ParseUtil::formatMoney($out[6][$i]);
if ($out[8][$i] == '存入') {
$one['rmb_amount'] *= -1;
}
$one['currency'] = ParseUtil::getCurrencyType($out[6][$i]);
$one['type'] = ParseUtil::getConsumeType($one['description']);
//消费分类
$one['is_doubt'] = ParseUtil::isDoubtComsume($one['description']);
//可疑消费分析
$cards[$cardNo]['trades'][] = $one;
}
// print_r($cards[$cardNo]['trades']);
// exit;
//细分明细(信用卡积分，分行特色信用卡积分，联名积分1，联名积分2)
// $p = '/分行特色信用卡积分 # 新增 ([\d,]+) # 余额 ([\d,]+)/';
$p = '/积分 # (新增 ([\\d,]+) # )?余额 ([\\d,]+)/';
$r = $this->pregMatchAll($p, $s, $out);
if ($r) {
$info['total_points'] = ParseUtil::formatNum($out[3][0]);
$info['earned_points'] = ParseUtil::formatNum($out[2][0]);
}
$info = ParseUtil::trimArr($info);
if (empty($cards)) {
return $this->insert($info);
}
//区分不同的卡
$oneCardInfo = $info;
if ($cards_count > 1) {
$detailArr = array();
foreach ($cards as $key => $detail) {
//$oneCardInfo['card_no'] = $key;
if (isset($detail['trades'])) {
$detailArr = array_merge($detailArr, $detail['trades']);
}
if (is_array($detail['balance'])) {
$oneCardInfo = array_merge($oneCardInfo, $detail['balance']);
unset($oneCardInfo['人民币']);
}
if (is_array($detail['balance']['人民币'])) {
$oneCardInfo = array_merge($oneCardInfo, $detail['balance']['人民币']);
}
if (isset($detail['balance']['美元'])) {
$oneCardInfo['credit_limit_usd'] = $detail['balance']['美元']['credit_limit'];
$oneCardInfo['new_balance_usd'] = $detail['balance']['美元']['new_balance'];
$oneCardInfo['min_payment_usd'] = $detail['balance']['美元']['min_payment'];
}
if (is_array(@$detail['points'])) {
$oneCardInfo = array_merge($oneCardInfo, $detail['points']);
}
}
$oneCardInfo['trans_detail'] = json_encode($detailArr);
print_r($oneCardInfo);
exit;
// $this->insert($oneCardInfo);
} else {
foreach ($cards as $key => $detail) {
//$oneCardInfo['card_no'] = $key;
if (isset($detail['trades'])) {
$oneCardInfo['trans_detail'] = json_encode($detail['trades']);
}
if (is_array($detail['balance'])) {
$oneCardInfo = array_merge($oneCardInfo, $detail['balance']);
unset($oneCardInfo['人民币']);
}
if (is_array($detail['balance']['人民币'])) {
$oneCardInfo = array_merge($oneCardInfo, $detail['balance']['人民币']);
}
if (isset($detail['balance']['美元'])) {
$oneCardInfo['credit_limit_usd'] = $detail['balance']['美元']['credit_limit'];
$oneCardInfo['new_balance_usd'] = $detail['balance']['美元']['new_balance'];
$oneCardInfo['min_payment_usd'] = $detail['balance']['美元']['min_payment'];
}
if (is_array(@$detail['points'])) {
$oneCardInfo = array_merge($oneCardInfo, $detail['points']);
}
// $this->insert($oneCardInfo);
// print_r($oneCardInfo);
}
}
// print_r($oneCardInfo);
exit;
return true;
}
public function newBillParse($s, array &$info, array &$details)
{
#账户基本信息
#额度基本信息(人民币)
//账单日 Statement Date # 20141127 # 信用额度 Credit Limit # 3900.00 CNY #
$money = '([\\-\\d\\.,]+)';
$date = '\\d{8}';
$p = "/账单日.*? ({$date})/";
//.*?Credit Limit # ($money) #/";
$r = $this->pregMatchAll($p, $s, $out);
if ($r) {
$info['payment_cur_date'] = ParseUtil::formatDate($out[1][0]);
//没有账单周期，自己算，当前账单日设为周期末尾一天
$info['statement_end_date'] = $info['payment_cur_date'];
$info['statement_start_date'] = strtotime('last month', $info['payment_cur_date']);
}
$p = "/到期还款日.*? ({$date}) # 还款明细 #/";
$r = $this->pregMatchAll($p, $s, $out);
if ($r) {
$info['payment_due_date'] = ParseUtil::formatDate($out[1][0]);
}
$p = "/信用额度 Credit Limit # ({$money}) CNY/";
$r = $this->pregMatchAll($p, $s, $out);
// print_r($s);
// print_r($out);
// exit;
$info['credit_limit'] = ParseUtil::formatMoney($out[1][0]);
$p = "/人民币\\(CNY\\) # ({$money}) # ({$money}) # ({$date}) # 还款明细 #/";
$r = $this->pregMatchAll($p, $s, $out);
#$info['cash_advance_limit'] = $out[5][0];
$info['new_balance'] = ParseUtil::formatMoney($out[1][0]) * -1;
$info['min_payment'] = ParseUtil::formatMoney($out[3][0]);
// $info['credit_limit_usd'] = ParseUtil::formatMoney($out[4][0]);
#账户还款计算明细(人民币)
$p = "/人民币（CNY） # {$money} # {$money} # {$money} # {$money} # {$money} #/";
$r = $this->pregMatchAll($p, $s, $out);
$info['last_balance'] = ParseUtil::formatMoney($out[1][0]) * -1;
$info['last_payment'] = ParseUtil::formatMoney($out[3][0]);
$info['new_charges'] = ParseUtil::formatMoney($out[2][0]);
$p = '/\\d{4,8} # \\d{4,8} # \\d{4} # [^#]* # [^#]* # [^#]+ # [^#]+ /';
$r = $this->pregMatchAll($p, $s, $out);
for ($i = 0; $i < count($out[0]); $i++) {
$out[$i + 1] = explode("#", $out[0][$i]);
}
for ($i = 1; $i < count($out[0]) + 1; $i++) {
$one['trans_date'] = intval(strtotime($out[$i][0]));
$one['post_date'] = intval(strtotime($out[$i][1]));
$one['card_no'] = trim($out[$i][2]);
$one['description'] = $out[$i][3];
$one['rmb_amount'] = ParseUtil::formatMoney($out[$i][6]) * -1;
$one['currency'] = ParseUtil::getCurrencyType($out[$i][5]);
#$one['trans_area'] = $out[5][0];
#$one['orign_amount'] = $out[7][0];
$one['type'] = ParseUtil::getConsumeType($one['description']);
//消费分类
$one['is_doubt'] = ParseUtil::isDoubtComsume($one['description']);
// 可疑消费分析
$details[$one['card_no']][] = ParseUtil::trimArr($one);
}
}
public function oldBillParse($s, array &$info, array &$details)
{
#2013年11月账单改版了，邮件中没有详细明细了，放到客户端查询了
$money = '[￥＄\\$\\d\\-\\., ]+';
$p = "/您 # (\\d{4}) # 年 # \\d{1,2} # 月信用卡个人卡账单已出，.*?最后还款日 # (\\d{1,2}) # 月 # (\\d{1,2}) # 日.*本期应还金额 # ({$money}) # ({$money}) # 最低还款额 # ({$money}) # ({$money})/";
//这里不用打印日志
$r = $this->pregMatchAll($p, $s, $out);
if ($r) {
$info['payment_due_date'] = ParseUtil::formatDate($out[1][0] . $out[2][0] . $out[3][0]);
$info['payment_cur_date'] = strtotime('20 days ago', $info['payment_due_date']);
$info['statement_end_date'] = $info['payment_cur_date'];
$info['statement_start_date'] = strtotime('last month', $info['payment_cur_date']);
$info['new_balance'] = ParseUtil::formatMoney($out[4][0]);
$info['new_balance_usd'] = ParseUtil::formatMoney($out[5][0]);
$info['min_payment'] = ParseUtil::formatMoney($out[6][0]);
$info['min_payment_usd'] = ParseUtil::formatMoney($out[7][0]);
}
#2013年11月之前，2012年7月之后的账单
//用户基本信息
$date = '\\d{4}\\/\\d{2}\\/\\d{2}';
$p = "/Statement Cycle # ({$date})-({$date}).*?Date # ({$date}).*?Limit # ({$money}).*?Balance # ({$money}).*?Limit # ({$money}).*?Payment # ({$money})/";
// Statement Cycle # 2012/ 09/16-2012/10/15 # 到期还款日 # Payment Due Date # 2012/11/03 # # # # # # 信用额度 # Credit Limit # ￥14,000 # 本期还款总额 #
//New Balance # ￥13,480.55 # # # # # # 预借现金额度 # Cash Advance Limit # ￥7,000 # 本期最低还款额 # Min.Payment # ￥1,348.06
$r = $this->pregMatchAll($p, $s, $out);
$statementDate = date('Ymd');
#默认时间设置
if ($r) {
print_r($out);
exit;
$info['statement_start_date'] = ParseUtil::formatDate($out[1][0]);
$info['statement_end_date'] = ParseUtil::formatDate($out[2][0]);
$statementDate = $info['statement_end_date'];
$info['payment_cur_date'] = $info['statement_end_date'];
$info['payment_due_date'] = strtotime(trim($out[3][0]));
$info['credit_limit'] = ParseUtil::formatMoney($out[4][0]);
$info['new_balance'] = ParseUtil::formatMoney($out[5][0]);
$info['cash_advance_limit'] = ParseUtil::formatMoney($out[6][0]);
$info['min_payment'] = ParseUtil::formatMoney($out[7][0]);
} else {
// 招商银行商务卡(个人承债)账单
$dateHead = '\\d{4}年\\d{2}月\\d{2}日';
$p = "/Statement Date # ({$dateHead}) # 信用额度 Credit Limit # ({$money}) .*? Payment Due Date # ({$dateHead}) .*? 人民币本期应还金额 Current Balance # ({$money})/";
$r = $this->pregMatchAll($p, $s, $out);
if ($r) {
$info['payment_cur_date'] = ParseUtil::formatDate($out[1][0]);
$info['payment_due_date'] = ParseUtil::formatDate($out[3][0]);
$info['statement_end_date'] = $info['payment_cur_date'];
$statementDate = $info['statement_end_date'];
$info['credit_limit'] = ParseUtil::formatMoney($out[2][0]);
$info['new_balance'] = ParseUtil::formatMoney($out[4][0]);
}
}
//用户还款计算明细
$p = "/循环利息 ?Interest[ #]*({$money}) # ({$money}) # ({$money}) # ({$money}) # ({$money}) # ({$money})/";
$r = $this->pregMatchAll($p, $s, $out);
if ($r) {
$info['last_balance'] = ParseUtil::formatMoney($out[2][0]);
$info['last_payment'] = ParseUtil::formatMoney($out[3][0]);
$info['new_charges'] = ParseUtil::formatMoney($out[4][0]);
$info['adjustment'] = ParseUtil::formatMoney($out[5][0]);
$info['interest'] = ParseUtil::formatMoney($out[6][0]);
} else {
return false;
}
//详细交易明细
$p = '/Trans Amount # (.*) ★ # 上述交易/';
$r = $this->pregMatchAll($p, $s, $out);
$d = $out[1][0];
$date = '\\d{4}\\-\\d{2}\\-\\d{2}';
$money = '[￥\\$\\d\\-, ]+\\.\\d{2}';
$p = "/(\\d{4})? # (\\d{4}) # ([^#]*?) # ({$money}) # (\\d{4}) # ([A-Z]*) ?# ({$money})?/";
$r = $this->pregMatchAll($p, $d, $out);
$cards = array_unique($out[5]);
sort($cards);
$defaultNo = array_pop($cards);
// print_r($out);
// exit;
for ($i = 0; $i < count($out[0]); $i++) {
//转年时会出现问题，但是客户端也不展现年份，暂时这样处理
$cardNo = trim($out[5][$i]);
if (empty($cardNo) || $cardNo == '0000') {
$cardNo = $defaultNo;
}
if (empty($out[1][$i])) {
$out[1][$i] = $out[2][$i];
}
//$one ['trans_date'] = ParseUtil::formatDate($out[1][$i], $info['statement_end_date']);
// $one ['post_date'] = ParseUtil::formatDate($out[2][$i], $info['statement_end_date']);
if (strlen($out[1][$i]) == 4) {
$one['trans_date'] = ParseUtil::formatDate($out[1][$i], $statementDate);
} else {
$one['trans_date'] = ParseUtil::formatDate($out[1][$i]);
}
// var_dump('trand_date: ' . date('Ymd', $one ['trans_date']) . '------------');
if (strlen($out[2][$i]) == 4) {
$one['post_date'] = ParseUtil::formatDate($out[2][$i], $statementDate);
} else {
$one['post_date'] = ParseUtil::formatDate($out[2][$i]);
}
// var_dump('post_datte: ' . date('Ymd', $one ['post_date']) . '------------');
// exit;
$one['description'] = $out[3][$i];
$one['rmb_amount'] = ParseUtil::formatMoney($out[4][$i]);
$one['currency'] = ParseUtil::getCurrencyType($out[4][$i]);
$one['card_no'] = $out[5][$i];
$one['trans_area'] = $out[6][$i];
$one['orign_amount'] = ParseUtil::formatMoney($out[7][$i]);
$one['type'] = ParseUtil::getConsumeType($one['description']);
// 消费分类
$one['is_doubt'] = ParseUtil::isDoubtComsume($one['description']);
// 可疑消费分析
$details[$cardNo][] = ParseUtil::trimArr($one);
}
//积分明细
$p = '/积分总数 [# ]+(\\d+) # (\\d+) # (\\d+) # (\\d+) # (\\d+) # (\\d+) #/';
$r = $this->pregMatchAll($p, $s, $out);
if ($r) {
$info['total_points'] = ParseUtil::formatNum($out[1][0]);
$info['last_points'] = ParseUtil::formatNum($out[2][0]);
$info['earned_points'] = ParseUtil::formatNum($out[3][0]);
$info['rewarded_points'] = ParseUtil::formatNum($out[4][0]);
$info['adjusted_points'] = ParseUtil::formatNum($out[5][0]);
$info['redeemed_points'] = ParseUtil::formatNum($out[6][0]);
}
$info = ParseUtil::trimArr($info);
return true;
}
public function parse($content)
{
$info = array();
$s = str_replace(' ', ' ', $content);
$s = str_replace('</td>', ' # ', $s);
$s = strip_tags($s);
$s = preg_replace('/\\s+/', ' ', $s);
$s = preg_replace('/(#\\s)+/', '# ', $s);
// file_put_contents('/home/rong/tmp/jianshe.' .time() . '.' . rand(0,100) . '.txt', $s);
// var_dump($s);
// exit;
#用户信息
$zh = '[\\x{4e00}-\\x{9fa5}]+';
$p = "/尊敬的({$zh})?，/u";
$r = $this->pregMatchAll($p, $s, $out);
// print_r($out);
// exit;
$fullCardNo = '\\d{4,}\\*{2,8}\\d{4,}';
preg_match_all("/{$fullCardNo}/", $s, $match);
//2015/06/25 added by wanghuafeng 多卡解析，合并多卡卡号
$card_num_arr = array();
$unique_cards_arr = array_unique($match[0]);
foreach ($unique_cards_arr as $val) {
$card_num_arr[] = substr($val, -4);
}
$all_card_no_str = implode(',', array_unique($card_num_arr));
$cards_count = count($card_num_arr);
// print_r($all_card_no_str);
if ($r) {
$info['name'] = $out[1][0];
$info['sex'] = @$out[2][0];
}
$lastPaymentPattern = '/金额人民币: ([0-9,]+\\.\\d{2})/';
$lpMatched = preg_match($lastPaymentPattern, $s, $lastPaymentMatch);
if ($lpMatched) {
$info['last_payment'] = ParseUtil::formatMoney($lastPaymentMatch[1]);
} else {
$info['last_payment'] = 0;
}
// print_r($info);
// exit;
#账户基本信息
#$p = '/账单周期.*?(\d\S+).*?Date # ([\d\-\/]+).*?Date # ([\d\-\/]+).*?Limit # [A-Z]*\s*([\d,]+).*?Limit # [A-Z]*\s*([\d,]+).*?Points # ([\d,]+).*?（CNY） # ([\d\.,]+) # ([\d\.,]+)/';
$circleDate = '\\d{4}年\\d{2}月\\d{2}日';
$date = '\\d{4}\\-\\d{2}\\-\\d{2}';
$money = '[CNY\\-\\d\\., ]+';
$num = '[\\d,]+';
#$p = "/Statement Date # (\d+) #[^#]*# ($date) #[^#]*# ($money) #[^#]*# ($money) #[^#]*# RMB:($money)[^#]*#[^#]*# RMB:($money)/";
$p = "/({$circleDate})\\-({$circleDate}) #[^#]*#[^#]*# ({$date}) #[^#]*# ({$date}|已逾期) #[^#]*# ({$money}) #[^#]*# ({$money}) #[^#]*# ({$num})/";
$r = $this->pregMatchAll($p, $s, $out);
// print_r($out);
// exit;
if ($r) {
$info['statement_start_date'] = ParseUtil::formatDate(trim($out[1][0]));
$info['statement_end_date'] = ParseUtil::formatDate(trim($out[2][0]));
$info['payment_cur_date'] = strtotime(trim($out[3][0]));
$info['payment_due_date'] = strtotime(trim($out[4][0]));
$info['credit_limit'] = ParseUtil::formatMoney($out[5][0]);
$info['cash_advance_limit'] = ParseUtil::formatMoney($out[6][0]);
#积分余额
$info['total_points'] = ParseUtil::formatNum($out[7][0]);
}
$p = "/Dispute Amt\\/Nbr #[^#]*# ({$money}) # ({$money})/";
// print_r($s);
$r = $this->pregMatchAll($p, $s, $out);
// print_r($out);
// exit;
if ($r) {
$info['new_balance'] = ParseUtil::formatMoney($out[1][0]);
$info['min_payment'] = ParseUtil::formatMoney($out[2][0]);
if (preg_match_all("/美元（USD） # ({$money}) # ({$money}) #/", $s, $match)) {
$info['new_balance_usd'] = ParseUtil::formatMoney($match[1][0]);
$info['min_payment_usd'] = ParseUtil::formatMoney($match[2][0]);
}
}
#账户还款计算明细
$p = "/上期账单余额\\(Previous Balance\\) # ({$money}) # (.*?)\\*\\*\\* 结束/";
$r = $this->pregMatchAll($p, $s, $out);
// print_r($out);
// exit;
$info['last_balance'] = ParseUtil::formatMoney($out[1][0]);
$d = $out[2][0];
#详细交易信息
$date = '\\d{4}\\-\\d{2}\\-\\d{2}';
$p = "/({$date}) # ({$date}) # (\\d{4}) # ([^#].*?) # ([A-Z]*) # ([-\\d\\.,]+) #/";
$details = array();
$r = $this->pregMatchAll($p, $d, $out);
if ($r) {
for ($i = 0; $i < count($out[0]); $i++) {
$one['trans_date'] = intval(strtotime($out[1][$i]));
$one['post_date'] = intval(strtotime($out[2][$i]));
$one['card_no'] = $out[3][0];
$one['description'] = $out[4][$i];
# $one['currency'] = ParseUtil::getCurrencyType($out [5] [$i]);
$one['rmb_amount'] = ParseUtil::formatMoney($out[6][$i]);
#$one['trans_area'] = $out[6][0];
#$one['orign_amount'] = format_money($out[7][0]);
$one['type'] = ParseUtil::getConsumeType($one['description']);
//TODO 消费分类
$one['is_doubt'] = ParseUtil::isDoubtComsume($one['description']);
// 可疑消费分析
$details[$one['card_no']][] = ParseUtil::trimArr($one);
}
}
#积分明细
$p = '/Total Points #[^#]*(\\d{4}) # ([\\d\\.,]+) # ([\\d\\.,]+) # ([\\d\\.,]+) # ([\\d\\.,]+) # ([\\d\\.,]+) # ([\\d\\.,]+) #/';
$r = $this->pregMatchAll($p, $s, $out);
if ($r) {
$info['total_points'] = ParseUtil::formatNum($out[7][0]);
$info['last_points'] = ParseUtil::formatNum($out[2][0]);
$info['earned_points'] = ParseUtil::formatNum($out[3][0]);
$info['rewarded_points'] = ParseUtil::formatNum($out[4][0]);
$info['adjusted_points'] = ParseUtil::formatNum($out[5][0]);
$info['redeemed_points'] = ParseUtil::formatNum($out[6][0]);
$info = ParseUtil::trimArr($info);
}
if (empty($details)) {
return $this->insert($info);
}
//区分不同的卡
foreach ($details as $cardNo => $detail) {
$oneCardInfo = $info;
$oneCardInfo['card_no'] = $all_card_no_str;
$oneCardInfo['trans_detail'] = json_encode($detail);
// $this->insert($oneCardInfo);
}
print_r($oneCardInfo);
return true;
}
public function OldBillParse($s, array &$info, array &$details)
{
#账户基本信息
#额度基本信息(人民币)
$money = '[\\-\\d\\.,]+';
$date = '\\d{4}\\-\\d{2}\\-\\d{2}';
$p = "/信用额度 # RMB ({$money}) # 取现额度 # RMB ({$money}) # 本期账单日 # ({$date}) # 本期应还金额 # RMB ({$money}) # 本期还款日 # ({$date}) # 本期最低还款额 # RMB ({$money})/";
$r = preg_match_all($p, $s, $out);
// print_r($out);
// exit;
if ($r) {
$info['credit_limit'] = ParseUtil::formatMoney($out[1][0]);
$info['cash_advance_limit'] = ParseUtil::formatMoney($out[2][0]);
$info['payment_cur_date'] = ParseUtil::formatDate($out[3][0]);
$info['payment_due_date'] = ParseUtil::formatDate($out[5][0]);
$info['statement_end_date'] = $info['payment_cur_date'];
$info['statement_start_date'] = strtotime('last month', $info['payment_cur_date']);
$info['new_balance'] = ParseUtil::formatMoney($out[4][0]);
$info['min_payment'] = ParseUtil::formatMoney($out[6][0]);
} else {
//bug-fix by shupan at 2013-11-09 19:09
$p = "/信用额度 [^#]*# RMB ({$money}) # 取现额度 [^#]*# RMB ({$money}) # 账单日 [^#]*# ({$date}) # 到期还款日 [^#]*# ({$date}) # 本期应还款金额 [^#]*# RMB ({$money}) # 最低还款金额 [^#]*# RMB ({$money})/";
$r = $this->pregMatchAll($p, $s, $out);
// print_r($s);
// print_r($out);
// exit;
if ($r) {
$info['credit_limit'] = ParseUtil::formatMoney($out[1][0]);
$info['cash_advance_limit'] = ParseUtil::formatMoney($out[2][0]);
$info['payment_cur_date'] = ParseUtil::formatDate($out[3][0]);
$info['payment_due_date'] = ParseUtil::formatDate($out[4][0]);
$info['new_balance'] = ParseUtil::formatMoney($out[5][0]);
$info['min_payment'] = ParseUtil::formatMoney($out[6][0]);
}
}
if ($r) {
//没有账单周期，自己算，当前账单日设为周期末尾一天
$info['statement_end_date'] = $info['payment_cur_date'];
$info['statement_start_date'] = strtotime('last month', $info['payment_cur_date']);
}
#账户还款计算明细(人民币)
$p = "/上期账单金额 ?RMB ({$money}) # 上期还款金额 ?RMB ({$money}) # 本期账单金额 ?RMB ({$money}) # 本期调整金额 ?RMB ({$money}) # 循环利息 ?RMB ({$money})/";
// $r = $this->pregMatchAll($p, $s, $out);
$r = preg_match_all($p, $s, $out);
// print_r($out);
// exit;
if (!$r) {
//bug-fix by shupan at 2013-11-09 19:09
$p = "/上期账单金额 [^#]* # RMB ({$money}) [^#]* # [^#]* # RMB ({$money}) [^#]* # [^#]* # RMB ({$money}) [^#]* # [^#]* # RMB ({$money}) [^#]* # [^#]* # RMB ({$money})/";
$r = $this->pregMatchAll($p, $s, $out);
// print_r($s);
// print_r($out);
// exit;
}
// print_r($out);
// exit;
if ($r) {
$info['last_balance'] = ParseUtil::formatMoney($out[1][0]);
$info['last_payment'] = ParseUtil::formatMoney($out[2][0]);
$info['new_charges'] = ParseUtil::formatMoney($out[3][0]);
$info['adjustment'] = ParseUtil::formatMoney($out[4][0]);
$info['interest'] = ParseUtil::formatMoney($out[5][0]);
}
//TODO美元
#详细交易信息
// $p = '/人民币金额 # (.*)用卡小贴士/';
$p = '/交易日期 # (.*)/';
$r = $this->pregMatchAll($p, $s, $out);
if ($r) {
$d = $out[1][0];
$p = "/({$date}) # ({$date})( # (\\d{4}))? # ([^#]*) # [RMB ]*({$money})/";
$r = $this->pregMatchAll($p, $d, $out);
// print_r($out);
// exit;
if ($r) {
//账单详细明细中可能没有卡号，那么随机分配一个，这种账单应该是一起还的（已和PM确认），
$cards = array_unique($out[4], SORT_REGULAR);
sort($cards);
$defaultNo = array_pop($cards);
for ($i = 0; $i < count($out[0]); $i++) {
$one['trans_date'] = ParseUtil::formatDate($out[1][$i], $info['statement_end_date']);
$one['post_date'] = ParseUtil::formatDate($out[2][$i], $info['statement_end_date']);
$one['card_no'] = empty($out[4][$i]) ? $defaultNo : $out[4][$i];
// $one['card_no'] = $defaultNo;
$one['description'] = $out[5][$i];
$one['rmb_amount'] = ParseUtil::formatMoney($out[6][$i]);
$one['currency'] = ParseUtil::getCurrencyType($out[6][$i]);
$one['type'] = ParseUtil::getConsumeType($one['description']);
//消费分类
$one['is_doubt'] = ParseUtil::isDoubtComsume($one['description']);
//可疑消费分析
$details[$one['card_no']][] = ParseUtil::trimArr($one);
unset($one);
}
}
// print_r($details);
// exit;
}
$info['card_no'] = $this->all_card_no_str;
// print_r($info);
// exit;
#积分明细
$num = '([\\d,]+)';
$p = "/万里通积分.*?本期余额 # ({$num}) # 本期新增 # ({$num}) # 本期调整 # ({$num})/";
$r = $this->pregMatchAll($p, $s, $out);
if ($r) {
$info['total_points'] = ParseUtil::formatNum($out[1][0]);
$info['earned_points'] = ParseUtil::formatNum($out[2][0]);
$info['adjusted_points'] = ParseUtil::formatNum($out[3][0]);
}
}
public function parse($content)
{
$info = array();
$details = array();
$s = str_replace(' ', ' ', $content);
// $s = str_replace('</td>', ' # ', $s);
print_r(strtolower($s));
exit;
$s = strip_tags($s);
$s = preg_replace('/\\s+/', ' ', $s);
$s = preg_replace('/(#\\s)+/', '# ', $s);
// file_put_contents('/home/rong/tmp/jiaotong.' .time() . '.txt' , $s);
#用户信息 没有区分先生和女士
$zh = '[\\x{4e00}-\\x{9fa5}]+';
$p = "/尊敬的\\s*({$zh})\\s*(女士|先生)/u";
$r = $this->pregMatchAll($p, $s, $out);
// print_r($out);
// exit;
if ($r) {
$info['name'] = $out[1][0];
$info['sex'] = $out[2][0];
}
//多卡问题
$cardPattern = '/\\d+\\*+(\\d{4})/';
preg_match_all($cardPattern, $s, $cardMatch);
$card_num_arr = array();
$unique_cards_arr = array_unique($cardMatch[1]);
foreach ($unique_cards_arr as $val) {
$card_num_arr[] = substr($val, -4);
}
$all_card_no_str = implode(',', array_unique($card_num_arr));
$cards_count = count($card_num_arr);
#bug-fix, by shupan, 2013-12-06 17:09。2011年x月之前账单，没有消费明细
$date = '\\d{4}\\/\\d{2}\\/\\d{2}';
$money = '[RMB￥＄\\$\\d\\-\\., ]+';
$dateOld = '[\\d\\-]{4}年[\\d\\-]{2}月[\\d\\-]{2}日';
#eg:您尾号为1034的交通银行信用卡本期账单已于2010年12月24日生成，到期还款日为----年--月--日。
$p = "/您尾号为(\\d{4})的交通银行信用卡本期账单已于({$dateOld})生成，到期还款日为({$dateOld}).*?Statement Balance # 人民币RMB # ({$money}) # 美元USD # ({$money}) # 本期最低还款额 Min.Payment Due # 人民币RMB # ({$money}) # 美元USD # ({$money}) # 本期积分余额 Available Points # 人民币账户RMB # ([\\d,]+)/";
//这里不用打印日志
$r = preg_match_all($p, $s, $out);
// print_r($s);
// exit;
if ($r) {
$info['card_no'] = $out[1][0];
$info['payment_due_date'] = ParseUtil::formatDate($out[3][0]);
$info['payment_cur_date'] = ParseUtil::formatDate($out[2][0]);
$info['statement_end_date'] = $info['payment_cur_date'];
$info['statement_start_date'] = strtotime('last month', $info['payment_cur_date']);
$info['new_balance'] = ParseUtil::formatMoney($out[4][0]);
$info['new_balance_usd'] = ParseUtil::formatMoney($out[5][0]);
$info['min_payment'] = ParseUtil::formatMoney($out[6][0]);
$info['min_payment_usd'] = ParseUtil::formatMoney($out[7][0]);
$info['total_points'] = ParseUtil::formatNum($out[8][0]);
$this->insert($info);
return true;
}
#账户基本信息
// $money = '[\-\d\.,]+';
#bug-fix, by shupan, 2013-12-06 17:09。2011年7月账单（ Min.Payment Due # 人民币RMB 0.00 ）
#$p = "/Minimum Payment Due # 人民币RMB ($money) # 美元USD ($money) # 人民币RMB ($money) # 美元USD ($money)/";
$p = "/Payment Due # 人民币RMB ({$money}) # 美元USD ({$money}) # 人民币RMB ({$money}) # 美元USD ({$money})/";
$r = $this->pregMatchAll($p, $s, $out);
// print_r($out);
// exit;
if ($r) {
$info['available_balance'] = ParseUtil::formatMoney($out[1][0]);
$info['available_balance_usd'] = ParseUtil::formatMoney($out[2][0]);
$info['min_payment'] = ParseUtil::formatMoney($out[3][0]);
$info['min_payment_usd'] = ParseUtil::formatMoney($out[4][0]);
}
#额度基本信息(人民币)
#bug-fix, by shupan, 2013-12-06 15:38, 到期还款日可能为空
$p = "/Statement Cycle # ({$date})-({$date})[^\\d]*?人民币 RMB ({$money})[^\\d]*?USD ({$money})[^\\d]*?Payment Due Day # ({$date})?[^\\d]*?人民币 RMB ({$money})[^\\d]*?USD ({$money})/";
$r = $this->pregMatchAll($p, $s, $out);
if (!$r) {
$p = "/Statement Cycle # ({$date})- ({$date})[^\\d]*?人民币 RMB ({$money})[^\\d]*?USD ({$money})[^\\d]*?Payment Due Day # ({$date})?[^\\d]*?人民币 RMB ({$money})[^\\d]*?USD ({$money})/";
$r = $this->pregMatchAll($p, $s, $out);
}
if ($r) {
$info['statement_start_date'] = ParseUtil::formatDate($out[1][0]);
$info['statement_end_date'] = ParseUtil::formatDate($out[2][0]);
$info['payment_cur_date'] = $info['statement_end_date'];
$info['credit_limit'] = ParseUtil::formatMoney($out[3][0]);
$info['credit_limit_usd'] = ParseUtil::formatMoney($out[4][0]);
$info['payment_due_date'] = ParseUtil::formatDate($out[5][0]);
$info['cash_advance_limit'] = ParseUtil::formatMoney($out[6][0]);
$info['cash_advance_limit_usd'] = ParseUtil::formatMoney($out[7][0]);
} else {
//TODO 交行新版本
$info['card_no'] = $all_card_no_str;
$statementDatePattern = "/账单周期：({$date})-({$date})/";
$statementMatched = preg_match($statementDatePattern, $s, $statementMatch);
// print_r($statementMatch);
// exit;
if ($statementMatched) {
$info['statement_start_date'] = ParseUtil::formatDate($statementMatch[1]);
//账单周期起始日
$info['statement_end_date'] = ParseUtil::formatDate($statementMatch[2]);
//账单周期结束日
$paymentDueDatePattern = "/到期还款日 ({$date})/";
preg_match($paymentDueDatePattern, $s, $paymentDueDateMatch);
print_r($s);
print_r($paymentDueDateMatch);
exit;
$info['payment_due_date'] = ParseUtil::formatDate($paymentDueDateMatch[1]);
//账单到期还款日
$info['payment_cur_date'] = $info['statement_end_date'];
}
$accountDetailPattern = "/本期应还款额 ({$money}) # ({$money}) # 最低还款额 ({$money}) # ({$money}) # 信用额度 ({$money}) # ({$money}) # 取现额度 ({$money}) # ({$money}) #/";
$accountDetailMatched = preg_match($accountDetailPattern, $s, $accountDetailMatch);
print_r($accountDetailMatch);
exit;
if ($accountDetailMatched) {
$info['new_balance'] = ParseUtil::formatMoney($accountDetailMatch[1]);
$info['new_balance_usd'] = ParseUtil::formatMoney($accountDetailMatch[2]);
$info['min_payment'] = ParseUtil::formatMoney($accountDetailMatch[3]);
$info['min_payment_usd'] = ParseUtil::formatMoney($accountDetailMatch[4]);
$info['credit_limit'] = ParseUtil::formatMoney($accountDetailMatch[5]);
$info['credit_limit_usd'] = ParseUtil::formatMoney($accountDetailMatch[6]);
$info['cash_advance_limit'] = ParseUtil::formatMoney($accountDetailMatch[7]);
$info['cash_advance_limit_usd'] = ParseUtil::formatMoney($accountDetailMatch[8]);
}
$balancePattern = "/人民币账户(?: RMB)? # ({$money}) # ({$money}) # ({$money}) # ({$money}) # 美元账户(?: USD)? # ({$money}) # ({$money}) # ({$money}) # ({$money})/";
$balanceMatched = preg_match($balancePattern, $s, $balanceMatch);
if ($balanceMatched) {
$info['new_balance'] = ParseUtil::formatMoney($balanceMatch[1]);
$info['last_balance'] = ParseUtil::formatMoney($balanceMatch[2]);
$info['last_payment'] = ParseUtil::formatMoney($balanceMatch[3]);
$info['new_charges'] = ParseUtil::formatMoney($balanceMatch[4]);
$info['new_balance_usd'] = ParseUtil::formatMoney($balanceMatch[5]);
}
$pointPattern = '/本期积分说明.*人民币账户 # ([\\-\\d]+)/';
$pointMatched = preg_match($pointPattern, $s, $pointMatch);
if ($pointMatched) {
$info['total_points'] = $pointMatch[1];
}
$transDetailPattern = "/({$date}) # ({$date}) # (.*?) # ({$money}) # ({$money})/";
$transDetailMatched = preg_match_all($transDetailPattern, $s, $transDetailMatch);
if ($transDetailMatched) {
$card_no = '****';
for ($i = 0; $i < count($transDetailMatch[0]); $i++) {
$one['trans_date'] = ParseUtil::formatDate($transDetailMatch[1][$i], $info['statement_end_date']);
$one['post_date'] = ParseUtil::formatDate($transDetailMatch[2][$i], $info['statement_end_date']);
$one['description'] = $transDetailMatch[3][$i];
$one['rmb_amount'] = ParseUtil::formatMoney($transDetailMatch[4][$i]) * -1;
$one['orign_amount'] = ParseUtil::formatMoney($transDetailMatch[5][$i]) * -1;
$details[$card_no][] = $one;
}
}
}
#账户还款计算明细(人民币)
$p = "/advance\\/Charges # 人民币账户 RMB # ({$money}) # ({$money}) # ({$money}) # ({$money}) # 美 元账户 USD # ({$money}) # ({$money}) # ({$money}) # ({$money})/";
$r = $this->pregMatchAll($p, $s, $out);
if (!$r) {
# ret = array_merge($s, $out);
# Yii::log(print_r($s,1)."==========================jiaotong2====");
}
if ($r) {
$info['new_balance'] = ParseUtil::formatMoney($out[1][0]);
$info['last_balance'] = ParseUtil::formatMoney($out[2][0]);
$info['last_payment'] = ParseUtil::formatMoney($out[3][0]);
$info['new_charges'] = ParseUtil::formatMoney($out[4][0]);
$info['new_balance_usd'] = ParseUtil::formatMoney($out[5][0]);
}
#详细交易信息 (还款、退货、返还明细)
// $details = array();
#bug-fix, by shupan, 2013-12-06 15:27, 后面可能会出现（以下是您的消费、取现及其他费用明细）
#$p = '/以下是您的还款、退货及费用返还明细.*?卡号末四位 (\d{4}) # (.*)以下是您的消费、取现及费用扣收明细/';
$p = '/以下是您的还款、退货及费用返还明细.*?卡号末四位 (\\d{4}) # (.*?)(以下是您的消费|本期积分说明)/';
$r = $this->pregMatchAll($p, $s, $out);
// print_r($out);
// exit;
if ($r) {
$card_no = $out[1][0];
$d = $out[0][0];
$p = "/({$date}) # ({$date}) # ([^#]*) # [A-Z]* # ({$money}) # [A-Z]* # ({$money})/";
$r = $this->pregMatchAll($p, $d, $out);
// print_r($out);
// exit;
for ($i = 0; $i < count($out[0]); $i++) {
$one['trans_date'] = ParseUtil::formatDate($out[1][$i], $info['statement_end_date']);
$one['post_date'] = ParseUtil::formatDate($out[2][$i], $info['statement_end_date']);
$one['description'] = $out[3][$i];
$one['rmb_amount'] = ParseUtil::formatMoney($out[4][$i]);
#$one['card_no'] = $card_no;
$one['orign_amount'] = ParseUtil::formatMoney($out[5][$i]);
$details[$card_no][] = ParseUtil::trimArr($one);
// print_r($card_no);
// exit;
unset($one);
}
// print_r($details[$card_no]);
// exit;
}
#详细交易信息 (消费、取现及费用扣收明细)added 2015-06-18
$p = '/以下是您的消费(.*)本期积分说明/';
$r = $this->pregMatchAll($p, $s, $out);
// print_r($out);
// exit;
if ($r) {
$cardNoPattern = "/卡号:\\d+.*?(\\d+)/";
$cardNoMatched = preg_match($cardNoPattern, $s, $cardNoMatch);
// print_r($cardNoMatch);
// exit;
$card_no = $cardNoMatch[1];
$d = $out[1][0];
// print_r($d);
// exit;
$p = "/({$date}) # ({$date}) # ([^#]*) # [A-Z]* # ({$money}) # [A-Z]* # ({$money})/";
$r = $this->pregMatchAll($p, $d, $out);
// print_r($out);
// exit;
for ($i = 0; $i < count($out[0]); $i++) {
$one['trans_date'] = ParseUtil::formatDate($out[1][$i], $info['statement_end_date']);
$one['post_date'] = ParseUtil::formatDate($out[2][$i], $info['statement_end_date']);
$one['description'] = $out[3][$i];
$one['rmb_amount'] = ParseUtil::formatMoney($out[4][$i]);
#$one['card_no'] = $card_no;
$one['orign_amount'] = ParseUtil::formatMoney($out[5][$i]);
$details[$card_no][] = ParseUtil::trimArr($one);
// print_r($card_no);
// exit;
unset($one);
}
}
// print_r($details);
// exit;
#积分明细
$p = '/本期积分说明.*人民币账户 ?RMB # ([\\-\\d]+)/';
$r = $this->pregMatchAll($p, $s, $out);
// print_r($out);
// exit;
if ($r) {
$info['total_points'] = ParseUtil::formatNum($out[1][0]);
}
if (empty($details)) {
// return $this->insert($info);
}
//区分不同的卡
foreach ($details as $cardNo => $detail) {
$oneCardInfo = $info;
$oneCardInfo['card_no'] = $all_card_no_str;
$oneCardInfo['trans_detail'] = json_encode($detail);
// $this->insert($oneCardInfo);
print_r($oneCardInfo);
exit;
}
return true;
}
