Please Login

Title

PHP Code

<?php /** * Spread all sales over the last 2 months (demo data re-dating). * Distributes sales evenly across 2026-07-05 → 2026-09-04, preserving * sale_id order (older invoices get earlier dates). Adds varied * business-hours timestamps for realism. */ $arrSales = \Components\Commerce\Sales::getAll([ 'order' => [['sale_id', 'asc']], 'limit' => 100000 ]); $iCount = count($arrSales); echo "Found {$iCount} sales.\n"; if ($iCount === 0) { echo "Nothing to update.\n"; return; } $iStart = strtotime('2026-07-05 09:00:00'); $iEnd = strtotime('2026-09-04 18:30:00'); $fSpan = $iEnd - $iStart; $iUpdated = 0; $iBatch = 0; foreach ($arrSales as $iIndex => $arrSale) { // Even spread + small jitter so timestamps look natural $fFrac = $iCount > 1 ? $iIndex / ($iCount - 1) : 0; $iBase = (int) round($iStart + $fFrac * $fSpan); $iNew = $iBase + rand(-5400, 5400); // ±1.5h jitter $sNew = date('Y-m-d H:i:s', $iNew); $arrSale['sale_datetime'] = $sNew; \Components\Commerce\Sales::save($arrSale); $iUpdated++; if ($iUpdated % 50 === 0) { \Components\Settings\Developer\Threads::setCurrentProgressStatus("Updated {$iUpdated} / {$iCount} sales…"); } } echo "Updated {$iUpdated} of {$iCount} sales.\n"; // Sample of first and last few new dates foreach (array_slice($arrSales, 0, 3, true) as $iIndex => $arrSale) { echo "sample early: sale_id {$arrSale['sale_id']} -> {$arrSale['sale_datetime']}\n"; } foreach (array_slice($arrSales, -3, 3, true) as $arrSale) { echo "sample late: sale_id {$arrSale['sale_id']} -> {$arrSale['sale_datetime']}\n"; } echo "Range: " . date('d M Y', $iStart) . " to " . date('d M Y', $iEnd) . "\n";

Run Log

▼ Today 4:53am ✗ Error 1.5s

Found 172 sales.

Contact with id -7817 does not exist.
$arrEntity: {"sale_id":"1078","sale_invoice_id":null,"sale_type":"sale","sale_datetime":"2026-07-31 04:37:38","sale_updated_datetime":"2026-09-04 10:20:44","sale_title":null,"sale_comments":"Sale made through Event RSVP system.","sale_currency_id":"AUD","sale_country_id":"AUS","sale_tax_label":"GST","sale_total_tax":"0.9090909091","sale_total":"10.0000","sale_receipt_status":"paid","sale_receipt_balance":"0.0000","sale_receipt_rounding":"0.0000","shipping_method_id":"0","shipping_method_data":"a:11:{s:21:\"...
$arrContact: null
#0 /usr/lib/php/Oncord/beta/Components/Commerce/Sales/Sales.inc.php(531): Components\Commerce\Sales::{closure:Components\Commerce\Sales::_save():491}()
#1 /usr/lib/php/Oncord/beta/Framework/Components/DataABC/DataABC.inc.php(4048): Components\Commerce\Sales::_save(Array)
#2 /usr/lib/php/Oncord/beta/Framework/functions.inc.php(1281) : eval()'d code(54): Framework\Components\DataABC::save(Array)
#3 /usr/lib/php/Oncord/beta/Framework/functions.inc.php(1281): eval()
#4 /usr/lib/php/Oncord/beta/Components/Settings/Developer/Scripts/Scripts.inc.php(761): evalOuter('\nif (!function_...')
#5 [internal function]: Components\Settings\Developer\Scripts::execute('s6WFkTPQc70lDpR...', 'f6U8h8DLuR0deR5...')
#6 /usr/lib/php/Oncord/beta/Scr/FnCall/FnCall.inc.php(148): call_user_func_array(Array, Array)
#7 /usr/lib/php/Oncord/beta/Scr/OpStatic/OpStatic.inc.php(62): Scr\FnCall->evaluate('\\Components\\Set...')
#8 /usr/lib/php/Oncord/beta/Components/Settings/Developer/Threads/_resources/runner.php(121): Scr\OpStatic->evaluate()
#9 /usr/lib/php/Oncord/beta/Components/Settings/Developer/Threads/_resources/runner.php(160): runCode()
#10 {main}