$q = "SELECT DISTINCT pr.`reminder_level`, o.`jng_sp_orders_id`,o.customer_billing_address, c.* FROM `payone_invoice` p\nINNER JOIN `payone_reminder` pr ON pr.invoice_id = p.invoice_id\nINNER JOIN `jng_sp_orders` o ON o.`jng_sp_orders_id` = p.`invoice_order_id`\nINNER JOIN `jng_sp_customers` c ON c.`customer_id` = o.`customer_billing_id`\nWHERE pr.`reminder_level` = (SELECT reminder_level FROM payone_reminder WHERE invoice_id = p.invoice_id and reminder_level in ('5','A') ORDER BY info_received DESC LIMIT 1)\nAND o.`jng_sp_id` = 2\nand c.jng_sp_customers_id not in (14402,14433)\norder by c.customer_firstname";
$dbq = tep_db_query($q);
echo "<table border='1'>\n <tr>\n <td><b>NO.</b></td>\n <td><b>REMINDER LEVEL</b></td>\n <td><b>ORDERS ID</b></td>\n <td><b>FIRSTNAME</b></td>\n <td><b>LASTNAME</b></td>\n <td><b>ADDRESS</b></td>\n <td><b>BAC</b></td>\n <td><b>AC</b></td>\n <td><b>CS</b></td>\n </tr>";
$n = 0;
$bac = null;
$ac = null;
$cs = null;
while ($r = tep_db_fetch_array($dbq)) {
$order_id = $r['jng_sp_orders_id'];
$n++;
echo "<tr>";
echo "<td>{$n}</td>";
echo "<td>{$r['reminder_level']}</td>";
echo "<td>{$r['jng_sp_orders_id']}</td>";
echo "<td>{$r['customer_firstname']}</td>";
echo "<td>{$r['customer_lastname']}</td>";
echo "<td>{$r['customer_billing_address']}</td>";
$bac = $class_payone->payoneCustomerBankAccountCheck($order_id);
echo is_null($bac) ? "<td> </td>" : "<td>{$bac['status']}</td>";
$ac = $class_payone->payoneCustomerAddressCheck($order_id);
echo $ac['status'] == 'VALID' ? "<td>{$ac['secstatus']}</td>" : "<td> </td>";
$cs = $class_payone->payoneCustomerConsumerScore($order_id);
echo $cs['status'] == 'VALID' ? "<td>{$cs['secstatus']} ( {$cs['score']} )</td>" : "<td> </td>";
echo "</tr>";
}
echo "</table>";
//echo $str;
//$result_test = $class_payone->payoneCustomerBankAccountCheck('6806');//14876
//$result_test = $class_payone->payoneCustomerAddressCheck('20820');
//$result_test = $class_payone->payoneCustomerConsumerScore('6806');
//echo "<pre>";var_dump($result_test);
