$sql .= 'WHERE 1=1 ';
$sql .= 'AND (gosn = "' . $sn . '" OR bksn = "' . $sn . '")';
$sql .= ' AND (LEFT(rtime, 10) = "' . $trade_day . '" OR LEFT(rtime, 10) = "' . $refund_day . '")';
$sql .= ' AND (AES_DECRYPT(goid, "' . KEY . '") = "' . $id . '"';
$sql .= ' OR AES_DECRYPT(bkid, "' . KEY . '") = "' . $id . '")';
$sql .= ' AND RIGHT(card8, 4) = "' . $card4 . '"';
$sql .= ' ORDER BY amount DESC';
// Query railway detail
$detail = $mysql->query($sql);
// Generate a report row
if (count($detail) > 0) {
$pay_amount = $detail[0]['amount'];
$refund_amount = $detail[1]['amount'];
$fee = $pay_amount + $refund_amount;
$pay_day = ClassDate::format($csv_format, $detail[0]['rtime']);
$refund_day = ClassDate::format($csv_format, $detail[1]['rtime']);
// Set the check fields
$temp_data = [];
foreach ($check_fields as $field) {
if ($detail[0][$field] === $detail[1][$field]) {
array_push($temp_data, $detail[0][$field]);
}
}
// Set the rest fields
foreach ($set_fields as $field) {
array_push($temp_data, ${$field});
}
// Write to new CSV
$csv->setData($new_csv_path, $temp_data, true);
}
}
