$q = "SELECT invoice_id FROM `payone_invoice_status_history`
WHERE status = 'P'
GROUP BY invoice_id
HAVING DATEDIFF(CURDATE(), MAX(status_date)) > 7";
*
*/
$q = "SELECT invoice_id FROM payone_invoice WHERE invoice_complete_status = 'P' ORDER BY invoice_id";
$dbq = tep_db_query($q);
$counter = 0;
$arr_success = array();
$arr_failed = array();
while ($r = tep_db_fetch_array($dbq)) {
$counter++;
$invoice_id = $r['invoice_id'];
$class_payi = new payone_invoice('invoice_id', $r['invoice_id']);
$cek = $class_payone->getUpdateStatusDate($invoice_id, 'P');
//CLEAN AFTER A WEEK
if ($cek['duration'] > 7) {
$status = '1';
$class_payi->updateCompleteStatus($status);
$arr_success[] = $invoice_id;
}
}
echo "Total 'expired' with status 'P' (Paid) : {$counter} \n";
if (count($arr_success) > 0) {
echo count($arr_success) . " invoice(s) successfully update to '1 = Payone Complete' invoice_id's (" . implode(",", $arr_success) . ") \n";
}
$q = "SELECT invoice_id FROM payone_invoice WHERE invoice_complete_status = 'D' ORDER BY invoice_id";
$dbq = tep_db_query($q);
$counter = 0;
$arr_success = array();
