File: //www/exchange0old/cmws/scripts/TK60916-update-sell-rate-part2.php
<?php
// custom script for updating Sell Rate for specific TTE transaction data from Exchange 2.0 to Credebt Machine
// list of specific TTE transactions to update with new Sell Rate (in array format)
$idListToSync = array(
'210330158931' => array('sell_rate' => 1.271, 'adjustment' => -4.33),
'210406159130' => array('sell_rate' => 1.271, 'adjustment' => -14.98),
'210406159131' => array('sell_rate' => 1.271, 'adjustment' => -66.13),
'210406159133' => array('sell_rate' => 1.271, 'adjustment' => -30.42),
'210414159488' => array('sell_rate' => 1.271, 'adjustment' => -8.78),
'210414159489' => array('sell_rate' => 1.271, 'adjustment' => -4.51),
'210414159490' => array('sell_rate' => 1.271, 'adjustment' => -25.13),
'210414159491' => array('sell_rate' => 1.271, 'adjustment' => -28.03),
'210414159492' => array('sell_rate' => 1.271, 'adjustment' => -20.94),
'210414159493' => array('sell_rate' => 1.271, 'adjustment' => -25.32),
'210414159495' => array('sell_rate' => 1.271, 'adjustment' => -0.89),
'210414159497' => array('sell_rate' => 1.271, 'adjustment' => -14.31),
'210414159498' => array('sell_rate' => 1.271, 'adjustment' => -2.55),
'210414159499' => array('sell_rate' => 1.271, 'adjustment' => -91.31),
'210414159500' => array('sell_rate' => 1.271, 'adjustment' => -31.96),
'210414159501' => array('sell_rate' => 1.271, 'adjustment' => -311.89),
'210414159502' => array('sell_rate' => 1.271, 'adjustment' => -165.22),
'210414159503' => array('sell_rate' => 1.271, 'adjustment' => -30.01),
'210415159565' => array('sell_rate' => 1.271, 'adjustment' => -43),
'210415159566' => array('sell_rate' => 1.271, 'adjustment' => -22.91),
'210419159639' => array('sell_rate' => 1.271, 'adjustment' => -3.21),
'210419159640' => array('sell_rate' => 1.271, 'adjustment' => -14.94),
'210419159641' => array('sell_rate' => 1.271, 'adjustment' => -25.56),
'210419159642' => array('sell_rate' => 1.271, 'adjustment' => -332.4),
'210422159828' => array('sell_rate' => 1.271, 'adjustment' => -9.57),
'210422159829' => array('sell_rate' => 1.271, 'adjustment' => -8.61),
'210422159830' => array('sell_rate' => 1.271, 'adjustment' => -55.29),
'210426159904' => array('sell_rate' => 1.271, 'adjustment' => -103.26),
'210426159905' => array('sell_rate' => 1.271, 'adjustment' => -64.03),
'210428160035' => array('sell_rate' => 1.271, 'adjustment' => -26.56),
'210429160082' => array('sell_rate' => 1.271, 'adjustment' => -26.03),
'210429160083' => array('sell_rate' => 1.271, 'adjustment' => -19.55),
'210504160299' => array('sell_rate' => 1.271, 'adjustment' => -370.03),
'210504160300' => array('sell_rate' => 1.271, 'adjustment' => -2.75),
'210504160302' => array('sell_rate' => 1.271, 'adjustment' => -177.36),
'210504160303' => array('sell_rate' => 1.271, 'adjustment' => -227.17),
'210506160376' => array('sell_rate' => 1.271, 'adjustment' => -4.32),
'210506160377' => array('sell_rate' => 1.271, 'adjustment' => -23.63),
'210511160602' => array('sell_rate' => 1.271, 'adjustment' => -30.46),
'210511160603' => array('sell_rate' => 1.271, 'adjustment' => -26.83),
'210512160669' => array('sell_rate' => 1.271, 'adjustment' => -21.95),
'210512160670' => array('sell_rate' => 1.271, 'adjustment' => -22.99),
'210512160671' => array('sell_rate' => 1.271, 'adjustment' => -100.19),
'210517160787' => array('sell_rate' => 1.271, 'adjustment' => -20.11),
'210517160848' => array('sell_rate' => 1.271, 'adjustment' => -3.28),
'210517160849' => array('sell_rate' => 1.271, 'adjustment' => -24.73),
'210517160850' => array('sell_rate' => 1.271, 'adjustment' => -22.44),
'210518160857' => array('sell_rate' => 1.271, 'adjustment' => -3.03),
'210518160890' => array('sell_rate' => 1.271, 'adjustment' => -24.14),
'210519160946' => array('sell_rate' => 1.271, 'adjustment' => -3.88),
'210520161001' => array('sell_rate' => 1.271, 'adjustment' => -57.52),
'210520161003' => array('sell_rate' => 1.271, 'adjustment' => -13.42),
'210521161009' => array('sell_rate' => 1.271, 'adjustment' => -30.15),
'210524161136' => array('sell_rate' => 1.271, 'adjustment' => -310.45),
'210525161248' => array('sell_rate' => 1.271, 'adjustment' => -93.55),
'210525161249' => array('sell_rate' => 1.271, 'adjustment' => -7.32),
'210527161395' => array('sell_rate' => 1.271, 'adjustment' => -18.15),
'210527161396' => array('sell_rate' => 1.271, 'adjustment' => -2.44),
'210527161397' => array('sell_rate' => 1.271, 'adjustment' => -14.51),
'210527161398' => array('sell_rate' => 1.271, 'adjustment' => -16.54),
'210528161439' => array('sell_rate' => 1.271, 'adjustment' => -28.92),
'210528161440' => array('sell_rate' => 1.271, 'adjustment' => -17.87),
'210528161441' => array('sell_rate' => 1.271, 'adjustment' => -76.42),
'210601161594' => array('sell_rate' => 1.271, 'adjustment' => -232.34),
'210608161773' => array('sell_rate' => 1.271, 'adjustment' => -98.85),
'210608161774' => array('sell_rate' => 1.271, 'adjustment' => -65.9),
'210609161914' => array('sell_rate' => 1.271, 'adjustment' => -35.46),
'210609161915' => array('sell_rate' => 1.271, 'adjustment' => -2.81),
'210610161919' => array('sell_rate' => 1.271, 'adjustment' => -252.53),
'210610161969' => array('sell_rate' => 1.271, 'adjustment' => -19.83),
'210610161970' => array('sell_rate' => 1.271, 'adjustment' => -31.01),
'210610161971' => array('sell_rate' => 1.271, 'adjustment' => -12.96),
'210610161973' => array('sell_rate' => 1.271, 'adjustment' => -148),
'210611162032' => array('sell_rate' => 1.271, 'adjustment' => -3.24),
'210614162057' => array('sell_rate' => 1.271, 'adjustment' => -2.24),
'210614162058' => array('sell_rate' => 1.271, 'adjustment' => -9.86),
'210614162132' => array('sell_rate' => 1.271, 'adjustment' => -30.16),
'210614162133' => array('sell_rate' => 1.271, 'adjustment' => -47.98),
'210615162191' => array('sell_rate' => 1.271, 'adjustment' => -195.29),
'210615162193' => array('sell_rate' => 1.271, 'adjustment' => -13.5),
'210615162194' => array('sell_rate' => 1.271, 'adjustment' => -46.88),
'210616162213' => array('sell_rate' => 1.271, 'adjustment' => -42.47),
'210616162214' => array('sell_rate' => 1.271, 'adjustment' => -39.52),
'210616162226' => array('sell_rate' => 1.271, 'adjustment' => -19.76),
'210616162238' => array('sell_rate' => 1.271, 'adjustment' => -365.92),
'210616162242' => array('sell_rate' => 1.271, 'adjustment' => -65.4),
'210617162260' => array('sell_rate' => 1.271, 'adjustment' => -44.01),
'210617162268' => array('sell_rate' => 1.271, 'adjustment' => -44.01),
'210618162354' => array('sell_rate' => 1.271, 'adjustment' => -19.5),
'210618162355' => array('sell_rate' => 1.271, 'adjustment' => -22.51),
'210622162415' => array('sell_rate' => 1.271, 'adjustment' => -6.91),
'220717174659' => array('sell_rate' => 1.398, 'adjustment' => -499.74),
'220717174660' => array('sell_rate' => 1.398, 'adjustment' => -65.84),
'220721174777' => array('sell_rate' => 1.398, 'adjustment' => -2492.92),
'220721174778' => array('sell_rate' => 1.398, 'adjustment' => -472.48),
'220722174822' => array('sell_rate' => 1.398, 'adjustment' => -4.55),
'220722174823' => array('sell_rate' => 1.398, 'adjustment' => -4.63),
'220722174829' => array('sell_rate' => 1.398, 'adjustment' => -4.74),
'220722174835' => array('sell_rate' => 1.398, 'adjustment' => -34.93),
'220722174837' => array('sell_rate' => 1.398, 'adjustment' => -1516.7),
'220725174844' => array('sell_rate' => 1.398, 'adjustment' => -43.57),
'220725174893' => array('sell_rate' => 1.398, 'adjustment' => -84.47),
'220726174897' => array('sell_rate' => 1.398, 'adjustment' => -7.44),
'220729174992' => array('sell_rate' => 1.398, 'adjustment' => -108.46),
'220729175026' => array('sell_rate' => 1.398, 'adjustment' => -23.98),
'220729175027' => array('sell_rate' => 1.398, 'adjustment' => -0.11),
'220729175028' => array('sell_rate' => 1.398, 'adjustment' => -94.76),
'220804175103' => array('sell_rate' => 1.398, 'adjustment' => -28.92),
'220804175108' => array('sell_rate' => 1.398, 'adjustment' => -170.27),
'220805175138' => array('sell_rate' => 1.398, 'adjustment' => -12.36),
'220808175170' => array('sell_rate' => 1.398, 'adjustment' => -233.36),
'220808175171' => array('sell_rate' => 1.398, 'adjustment' => -403.64),
'220808175173' => array('sell_rate' => 1.398, 'adjustment' => -2779.72),
'220811175309' => array('sell_rate' => 1.398, 'adjustment' => -16.35),
'220811175315' => array('sell_rate' => 1.398, 'adjustment' => -5.02)
);
if (PHP_SAPI !== "cli") {
echo "The script should be run only from CLI.";
exit;
}
$memoryLimit = '1024M';
if (ini_set('memory_limit', $memoryLimit) === false) {
echo "Unable to set the required memory limit: " . $memoryLimit . ".\n";
exit;
}
if (is_null($argv)) {
echo "Please enable \$argv variable in PHP configuration.";
exit;
}
// required includes
require_once("../../exchange/Bin/constants.php");
require_once("../../exchange/Bin/init.php");
require_once(ROOT_FOLDER . "Bin/Security.php");
require_once(ROOT_FOLDER . "admin/classes/Model/base_actions.php");
require_once(ROOT_FOLDER . "admin/classes/Model/CMSync.php");
$cmSync = new CMSync(MYSQL_ENGINE_IMPROVED);
if (!$cmSync->cmSyncTransactionEnable) {
echo "Transaction Sync is disabled. Please first enable Transaction Sync in Exchange 2.0 Site Settings.\n";
exit;
}
echo $cmSync->showMemoryUsage();
if ($cmSync->initLogFile(CM_SYNC_TRANSACTION) === false) {
echo "Log File write error: Unable to create log file. Please check folder permissions.\n";
exit;
}
// script is used for specific transaction(s)
foreach ($idListToSync as $idVal => $updateArr) {
echo "\nChecking if transaction: ". $idVal . " exists...\n";
$basicTransactionData = $cmSync->getBasicTransactionData($idVal);
$transactionSyncList = array();
if (count($basicTransactionData) > 0) {
$transactionSyncList = $cmSync->getTransactionListForSync($basicTransactionData[0]['dataEntity'],
$basicTransactionData[0]['transactionType'], null, null, $idVal);
}
$countList = count($transactionSyncList);
$counter = 0;
echo "Record(s) to sync: " . $countList . "\n";
echo $cmSync->showMemoryUsage();
foreach ($transactionSyncList as $transactionEntry) {
$transTitle = $cmSync->getBasicTransactionTitle($basicTransactionData[0]['dataEntity'],
$basicTransactionData[0]['transactionType']);
echo "\nSyncing " . $transTitle .
" (type: " . $basicTransactionData[0]['transactionType'] . ") " . "transaction " . ++$counter .
" out of ". $countList . "; Ref. ID: " . $transactionEntry['exchange_ref_id'] . " \t";
$cmSync->clearSyncState();
$tteArray = $cmSync->prepareTransactionData($transactionEntry);
$dataToSyncArr = array(
'exchange_ref_id' => $transactionEntry['exchange_ref_id'],
'field_values' => array(
CM_SYNC_TTE_FIELD_SELL_RATE => $transactionEntry['sell_rate'])
);
$cmSync->setTransactionData($dataToSyncArr, $tteArray['type_field_mapping_id'], CM_SYNC_TTETRANS_EDIT);
echo ($cmSync->doEditTransaction($transactionEntry['exchange_ref_id'])) === true ? "Success\n" : "Error\n";
echo "\n" . $cmSync->showMemoryUsage();
}
unset($basicTransactionData, $transactionSyncList);
}