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); } } }