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