public function addConfigField($path, $label, array $data = array(), $default = null) { $data['level'] = sizeof(explode('/', $path)); $data['path'] = $path; $data['frontend_label'] = $label; if ($id = $this->getTableRow('core/config_field', 'path', $path, 'field_id')) { $this->updateTableRow('core/config_field', 'field_id', $id, $data); } else { if (empty($data['sort_order'])) { $sql = "select max(sort_order) cnt from " . $this->getTable('core/config_field') . " where level=" . ($data['level'] + 1); if ($data['level'] > 1) { $sql .= $this->_conn->quoteInto(" and path like ?", dirname($path) . '/%'); } $result = $this->_conn->raw_fetchRow($sql); $this->_conn->fetchAll($sql); #print_r($result); die; $data['sort_order'] = $result['cnt'] + 1; /* // Triggers "Command out of sync" mysql error for next statement!?!? $data['sort_order'] = $this->_conn->fetchOne("select max(sort_order) from ".$this->getTable('core/config_field')." where level=?".$parentWhere, $data['level'])+1; */ } #$this->_conn->raw_query("insert into ".$this->getTable('core/config_field')." (".join(',', array_keys($data)).") values ('".join("','", array_values($data))."')"); $this->_conn->insert($this->getTable('core/config_field'), $data); } if (!is_null($default)) { $this->setConfigData($path, $default); } return $this; }
/** * Stores the payment information in the mollie_payments table. * * @param null $order_id The order's Id * @param null $transaction_id TransactionID, provided by Mollie (32 char md5 hash) * @param string $method */ public function setPayment($order_id = NULL, $transaction_id = NULL, $method = 'api') { if (is_null($order_id) || is_null($transaction_id)) { Mage::throwException('Ongeldig order_id of transaction_id...'); } $data = array('order_id' => $order_id, 'transaction_id' => $transaction_id, 'bank_status' => self::STATUS_OPEN, 'method' => $method, 'created_at' => $this->getCurrentDate()); $this->_mysqlw->insert($this->_table, $data); }
public function addValue($type, $oldValue, $newValue) { $data = array('type' => $type, 'oldValue' => $oldValue, 'newValue' => $newValue); $this->mySqlWriteConnection->insert($this->tableName, $data); }
/** * Add a job to the queue * @param string $class The Magento singleton identifier * @param string $method The name of the method to be called * @param array $data The arguments to be passed to the method as a Varien_Object * @param int $retries The maximum number of retries before giving up and logging an error */ public function add($class, $method, $data, $retries = NULL) { // Insert a row for the new job $this->_db->insert($this->_table, array('class' => $class, 'method' => $method, 'data' => serialize($data), 'max_retries' => max(array(1, (int) ($retries ? $retries : Mage::getStoreConfig(self::XML_PATH_MAX_RETRIES)))), 'pid' => NULL)); }