public static function deleteTestsOrders(IniParams $iniParams, Db $db)
{
$selectOkOrdersId = "SELECT orders_id FROM orders WHERE channels_id = :channelId";
$sqlParams = array("channelId" => $iniParams->get("channelId"));
$okOrdersIdArray = $db->getAll($selectOkOrdersId, $sqlParams);
if ($okOrdersIdArray) {
foreach ($okOrdersIdArray as $okOrderId) {
$sqlParams = array("okOrderId" => $okOrderId->orders_id);
$deleteSql = "DELETE FROM orders WHERE orders_id = :okOrderId";
$db->execute($deleteSql, $sqlParams);
$deleteSql = "DELETE FROM orders_products WHERE orders_id = :okOrderId";
$db->execute($deleteSql, $sqlParams);
$deleteSql = "DELETE FROM orders_status_history WHERE orders_id = :okOrderId";
$db->execute($deleteSql, $sqlParams);
$deleteSql = "DELETE FROM orders_total WHERE orders_id = :okOrderId";
$db->execute($deleteSql, $sqlParams);
}
}
}
