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; }