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