public function update($id, $state, $info)
{
$data = array('state' => $state, 'info' => $info, 'lastupdate' => time());
$found = $this->find($id);
if ($found) {
$data = array_merge($found, $data);
unset($data['id']);
$this->dbTable->update($data, array('id = ?' => $id));
} else {
$data['id'] = $id;
$data['sticked'] = 0;
$this->dbTable->insert($data);
}
}
/**
* Insert
*
* Calculates a unique ID and commits the new data
*
* @param array $data
* @return string
*/
public function insert(array $data)
{
$adapter = $this->getAdapter();
$adapter->beginTransaction();
do {
$uniqId = uniqid();
$select = $adapter->select()->from($this->_name, 'COUNT(*)')->where('id = ?', $uniqId);
$found = $adapter->fetchOne($select);
} while ($found > 0);
$data['id'] = $uniqId;
$data['created'] = date('Y-m-d H:i:s');
$created = strtotime($data['created']);
if (array_key_exists('expires', $data) && (is_int($data['expires']) || $data['expires'] == intval($data['expires']))) {
$expires = $data['expires'];
if (0 < $expires && $expires < $created) {
$data['expires'] = date('Y-m-d H:i:s', $created + $expires);
}
} elseif (array_key_exists('expires', $data) && is_string($data['expires'])) {
$expires = strtotime($data['expires']);
if (0 < $expires && $expires < $created) {
unset($data['expires']);
}
} elseif (array_key_exists('expires', $data)) {
unset($data['expires']);
}
parent::insert($data);
$adapter->commit();
return $uniqId;
}
public function insert(array $data)
{
if (empty($data['created_at'])) {
$data['created_at'] = new Zend_Db_Expr('NOW()');
}
return parent::insert($data);
}
public function insert($feedbackdata)
{
$data['name'] = $feedbackdata['name'];
$data['email'] = $feedbackdata['email'];
$data['message'] = $feedbackdata['message'];
return parent::insert($data);
}
/**
* Make sure the created timestamp is always set
*
* @param array &$data
* @return integer
*/
public function insert(&$data)
{
if (!isset($data['created'])) {
$data['created'] = time();
}
return parent::insert($data);
}
public function insert(array $data)
{
$data['dateins'] = date('Y-m-d H:i:s');
$data['dateco'] = date('Y-m-d H:i:s');
$data['IP'] = $_SERVER["REMOTE_ADDR"];
return parent::insert($data);
}
public function saveSupportRequest($data)
{
$input['name'] = $data['support_name'];
$input['email'] = $data['support_email'];
$input['query'] = $data['support_query'];
return parent::insert($input);
}
public function insert(array $data)
{
$date = new Zend_Date();
$data['datebug'] = $date->toString('Y-MM-d');
$data['statut'] = "Non lu";
return parent::insert($data);
}
public function insert(array $data)
{
require_once 'models/Session.php';
$data['timestamp_created'] = new Zend_Db_Expr('NOW()');
$data['created_by'] = Session::getCurrentUserId();
//don't set is_deleted
return Zend_Db_Table_Abstract::insert($data);
}
public function insert(array $data)
{
if (empty($data['guid'])) {
$guidMan = new Pandamp_Core_Guid();
$data['guid'] = $guidMan->generateGuid();
}
return parent::insert($data);
}
/**
* Add user_id to insert query.
*/
public function insert(array $params)
{
$auth = Zend_Auth::getInstance();
$identity = $auth->getIdentity();
$params['user_id'] = $identity->id;
$params['created'] = new Zend_Db_Expr('NOW()');
return parent::insert($params);
}
public function insert(array $data)
{
$data['date_s'] = date('Y-m-d H:i:s');
$data['vu'] = 0;
$data['visible'] = 1;
$data['IP'] = $_SERVER["REMOTE_ADDR"];
return parent::insert($data);
}
public function insert($data)
{
$extra = $this->_getExtraValues($data);
$string = $this->_encodeExtraValues($extra);
$data = $this->_getMainValues($data);
$data[self::TABLE_COLUMN_NAME_EXTRAVALUES] = $string;
return parent::insert($data);
}
/**
* insert row into DB
*
* @param array $data ''
* @return void
* @throws Zend_Exception if row cannot be inserted
*/
private function _insert($data)
{
try {
$this->obj->insert($data);
} catch (\Zend_Exception $e) {
throw $e;
}
}
/**
* Вставляет новую строку в таблицу.
* Все значения '' (пустая строка) в массиве $data заменяются на null.
*
* @param array $data Массив пар "поле => значение".
* @return mixed Значение первичного ключа вставленной строки.
*/
public function insert(array $data)
{
if ($keys = array_keys($data, '')) {
foreach ($keys as $key) {
$data[$key] = null;
}
}
return parent::insert($data);
}
public function add($marca_id, $nome)
{
try {
$dados = array('marca_id' => $marca_id, 'nome' => $nome);
parent::insert($dados);
} catch (Exception $e) {
echo 'Opa... algum problema aconteceu.';
}
}
public function insert($userdata)
{
$data['user_name'] = $userdata['user_name'];
$data['role_id'] = $userdata['role_id'];
$data['email'] = $userdata['email'];
$data['password'] = $userdata['password'];
// $data['mobile'] = $userdata['mobile'];
return parent::insert($data);
}
public function add($titulo, $comentario, $entrevista, $foto, $data, $entrevistado, $reporter, $ativo)
{
try {
$dados = array('titulo' => $titulo, 'comentario' => $comentario, 'entrevista' => $entrevista, 'foto' => $foto, 'data' => $data, 'entrevistado' => $entrevistado, 'reporter' => $reporter, 'ativo' => $ativo);
parent::insert($dados);
} catch (Exception $e) {
echo 'Opa... algum problema aconteceu.';
}
}
public function add($titulo, $comentario, $noticia, $foto, $data, $fonte, $ativo, $categoria_noticia_id)
{
try {
$dados = array('titulo' => $titulo, 'comentario' => $comentario, 'noticia' => $noticia, 'foto' => $foto, 'data' => $data, 'fonte' => $fonte, 'ativo' => $ativo, 'categoria_noticia_id' => $categoria_noticia_id);
parent::insert($dados);
} catch (Exception $e) {
echo 'Opa... algum problema aconteceu.';
}
}
public function add($sigla, $unidade)
{
try {
$dados = array('sigla' => $sigla, 'nome' => $unidade);
parent::insert($dados);
} catch (Exception $e) {
echo 'Opa... algum problema aconteceu.';
}
}
public function insert(array $params)
{
$params['created'] = new Zend_Db_Expr('NOW()');
$params['updated'] = new Zend_Db_Expr('NOW()');
$params['last_login'] = new Zend_Db_Expr('NOW()');
// generate a confirmation code
$params['confirm'] = $this->getVerificationCode($params);
return parent::insert($params);
}
public function insert(array $data)
{
$data = $this->filter($data);
if (count($data) <= 0) {
return false;
}
parent::insert($data);
return $this->getAdapter()->lastInsertId();
}
/**
* Override the insert to try and not throw an exception back if it fails, also re-using
* getByName code
* @param $data array associative array of vars to go in the db
* @return $row Zend_Db_Table_Row the row of the Ingredient table
*/
function insert(array $data)
{
try {
parent::insert($data);
} catch (Exception $e) {
// Doesnt matter if we cannot insert the ingredient
}
return $this->getByName($data['name']);
}
public function add($cod_gen, $genero)
{
try {
$dados = array('cod_gen' => $cod_gen, 'genero' => $genero);
parent::insert($dados);
} catch (Exception $e) {
echo 'Opa... algum problema aconteceu.';
}
}
public function insert(array $data)
{
if (empty($data['promotionid'])) {
Zend_Loader::loadClass('Kutu_Core_Guid');
$guid = new Kutu_Core_Guid();
$data['promotionid'] = $guid->generateGuid();
}
return parent::insert($data);
}
/**
* Override the insert to try and throw an exception back if it fails
* @param $data array associative array of vars to go in the db
* @return $row Zend_Db_Table_Row the row of the Ingredient table
*/
function insert(array $data)
{
try {
parent::insert($data);
$this->getDefaultAdapter()->update('recipes', array('ingredients_count' => new Zend_Db_Expr('ingredients_count + 1')));
} catch (Exception $e) {
throw new Zend_Db_Table_Exception($e->getMessage());
}
}
public function insert(array $data)
{
// хешируем пароль
if (isset($data['password'])) {
$data['salt'] = $salt = self::generateSalt();
$data['password'] = self::getPasswordHash($data['password'], $salt);
}
return parent::insert($data);
}
public function add($cod_tipi, $descricao)
{
try {
$dados = array('cod_tipi' => $cod_tipi, 'descricao' => $descricao);
parent::insert($dados);
} catch (Exception $e) {
echo 'Opa... algum problema aconteceu.';
}
}
/**
* Overide the insert function to ensure the relevant fields get filled in
*
* @param array $params
* @return unknown
*/
public function insert(array $params)
{
$auth = Zend_Auth::getInstance();
$identity = $auth->getIdentity();
$params['user_id'] = $identity->id;
$params['created'] = new Zend_Db_Expr('NOW()');
$params['updated'] = new Zend_Db_Expr('NOW()');
$params['total_time'] = $params['preparation_time'] + $params['cooking_time'];
return parent::insert($params);
}
public function insert(array $data)
{
if (!isset($data['created_at'])) {
$data['created_at'] = date('Y-m-d H:i:s');
}
if (!isset($data['updated_at'])) {
$data['updated_at'] = date('Y-m-d H:i:s');
}
return parent::insert($data);
}