/** * Returns SQL header data */ public function getHeader() { $dbConfig = $this->_read->getConfig(); $versionRow = $this->_read->fetchRow('SHOW VARIABLES LIKE \'version\''); $header = "-- Magento DB backup\n" . "--\n" . "-- Host: {$dbConfig['host']} Database: {$dbConfig['dbname']}\n" . "-- ------------------------------------------------------\n" . "-- Server version: {$versionRow['Value']}\n\n" . "/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;\n" . "/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;\n" . "/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;\n" . "/*!40101 SET NAMES utf8 */;\n" . "/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;\n" . "/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;\n" . "/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;\n" . "/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;\n"; return $header; }
protected function getLikeExistItem($newItem, $ignoreTitle = true, $attributeSet = NULL) { $whereSql = ''; foreach ($newItem as $key => $value) { if ($ignoreTitle && $key == 'title') { continue; } if ($whereSql == '') { $whereSql .= ' '; } else { $whereSql .= ' AND '; } $whereSql .= ' `' . $key . '` '; is_null($value) && ($whereSql .= ' IS NULL '); is_string($value) && ($whereSql .= ' = ' . $this->mySqlReadConnection->quote($value) . ' '); (is_integer($value) || is_float($value)) && ($whereSql .= ' = ' . $value . ' '); } $dbSelect = $this->mySqlReadConnection->select()->from($this->tableNameNew, '*'); $whereSql != '' && $dbSelect->where($whereSql); $row = $this->mySqlReadConnection->fetchRow($dbSelect); if ($row === false) { return NULL; } if (!is_null($attributeSet)) { $templateId = (int) $row['id']; $templateType = (int) $attributeSet['template_type']; $attributeSetId = (int) $attributeSet['attribute_set_id']; $tasTable = Mage::getResourceModel('M2ePro/TemplatesAttributeSets')->getMainTable(); $dbSelect = $this->mySqlReadConnection->select()->from($tasTable, '*')->where('template_type = ?', $templateType)->where('template_id = ?', $templateId); $rowsAttributesSets = $this->mySqlReadConnection->fetchAll($dbSelect); if ($rowsAttributesSets === false || count($rowsAttributesSets) != 1) { return NULL; } $rowAttributeSet = $rowsAttributesSets[0]; if ((int) $rowAttributeSet['attribute_set_id'] != $attributeSetId) { return NULL; } } return $row; }
/** * Retrieve table status * * @param string $tableName * @return Varien_Object */ public function getTableStatus($tableName) { $row = $this->_write->showTableStatus($tableName); if ($row) { $statusObject = new Varien_Object(); $statusObject->setIdFieldName('name'); foreach ($row as $field => $value) { $statusObject->setData(strtolower($field), $value); } $cntRow = $this->_write->fetchRow($this->_write->select()->from($tableName, 'COUNT(1) as rows')); $statusObject->setRows($cntRow['rows']); return $statusObject; } return false; }
/** * Retrieve row or field from table by id or string and parent id * * @param string $table * @param string $idField * @param string|integer $id * @param string $field * @param string $parentField * @param string|integer $parentId * @return mixed|boolean */ public function getTableRow($table, $idField, $id, $field = null, $parentField = null, $parentId = 0) { if (strpos($table, '/') !== false) { $table = $this->getTable($table); } if (empty($this->_setupCache[$table][$parentId][$id])) { $sql = "select * from {$table} where {$idField}=?"; if (!is_null($parentField)) { $sql .= $this->_conn->quoteInto(" and {$parentField}=?", $parentId); } $this->_setupCache[$table][$parentId][$id] = $this->_conn->fetchRow($sql, $id); } if (is_null($field)) { return $this->_setupCache[$table][$parentId][$id]; } return isset($this->_setupCache[$table][$parentId][$id][$field]) ? $this->_setupCache[$table][$parentId][$id][$field] : false; }
public function refund(Varien_Object $payment, $amount) { // fetch order and transaction info $order = $payment->getOrder(); $row = $this->_mysqlr->fetchRow('SELECT * FROM `' . $this->_table . '` WHERE `order_id` = ' . intval($order->entity_id), array(), Zend_Db::FETCH_ASSOC); $transaction_id = $row['transaction_id']; // fetch payment info $mollie = $this->_api->_getMollieAPI(); $mollie_payment = $mollie->payments->get($transaction_id); // attempt a refund try { $mollie->payments->refund($mollie_payment, $amount); } catch (Exception $e) { Mage::throwException('Impossible to create a refund for this transaction. Details: ' . $e->getMessage() . '<br />'); } return $this; }