require_once "/home/work/daiyuanpei/db.php";
$db = conn('FNDB_SCRIPT');
$file = file("front-code.txt");
$map = array();
foreach($file as &$line){
$line = explode("\t", $line);
$name = trim($line[0]);
$codeStr = trim($line[1]);
if(empty($codeStr)){
continue;
}
$codeArr = explode(',', $codeStr);
foreach($codeArr as $value){
$map[$value] = $name;
}
}
$outFile = file("data.txt");
foreach($outFile as $line){
$lineArr = explode("\t", $line);
if(trim($lineArr[2]) == ''){
$recvIds[] = "'".$lineArr[0]."'";
}
}
$recvIdArray = array_chunk($recvIds, 3000);
$recvMap = array();
foreach($recvIdArray as $vvv){
$recvIdsStr = implode(',', $vvv);
$recvSql = "select f_bank_card_num,f_recvable_id from bfb_db_finance.t_recvables where f_recvable_id in ($recvIdsStr) and f_create_time>='2019-08-01' and f_create_time < '2019-11-01'";
$recvData = queryInfo($recvSql, $db);
foreach($recvData as $v){
$recvMap[$v['f_recvable_id']] = $v['f_bank_card_num'];
}
}
foreach($outFile as $line){
$lineArr = explode("\t", $line);
$code = trim($lineArr[1]);
if(isset($map[$code])){
$name = $map[$code];
}else{
$name = '-';
}
if(trim($lineArr[2]) == ''){
$lineArr[2] = empty($recvMap[$lineArr[0]])?'-':$recvMap[$lineArr[0]];
$lineArr[3] = $name;
$str = implode("\t", $lineArr);
}else{
$str = rtrim($line)."\t".$name;
}
file_put_contents('t_top_info', $str."\n", FILE_APPEND);
}