public function delete($id) { $db = $this->getAdapter(); $where = $db->quoteInto("id in(?)", $id); $deletedRows = parent::delete($where); return $deletedRows ? true : false; }
public function delete($where) { $rows_affected = parent::delete($where); if ($rows_affected == 0) { throw new Respondenci_Exception('Podany adres e-mail nie istnieje w bazie danych.'); } }
public function delete($id, $log = true) { $where = $this->getAdapter()->quoteInto('id = ?', $id); parent::delete($where); if ($log) { log_sql($this->_name, $id, 'deleted'); set_session('notice', 'last record deleted'); } }
/** * Del new setting and return ID of the setting */ public function del($setting, $table) { global $logger; $oTable = new Zend_Db_Table($table); $where = $oTable->getAdapter()->quoteInto('id = ?', $setting->id); $result = $oTable->delete($where); $logger->log("Del setting {$table}={$setting->id}", Zend_Log::INFO); return $result; }
/** * delete с учётом удаления таблицы с публикациями * * @param array|string $where SQL WHERE clause(s). * @return int The number of rows deleted. */ public function delete($where) { $resultSet = $this->fetchAll($where); if (sizeof($resultSet)) { foreach ($resultSet as $row) { $_migrationManager = new Modules_Dbmigrations_Framework_Manager(); $_migrationManager->downTo('Modules_Publications_Migrations_CreatePublicationAbstractTable', $row->table_name); } } return parent::delete($where); }
/** * Stores information about trusted/untrusted site for given user * * @param string $id user identity URL * @param string $site site URL * @param mixed $trusted trust data from extensions or just a boolean value * @return bool */ public function addSite($id, $site, $trusted) { if (is_null($trusted)) { $this->_sitesTable->select()->where('site = ?', $site); $this->_sitesTable->delete($where); return true; } $row = $this->_sitesTable->createRow(); $row->openid = $id; $row->site = $site; $row->time = date('Y-m-d H:i:s O'); $row->trusted = serialize($trusted); $row->save(); return true; }
/** * delete с учётом удаления поля из таблицы публикаций * * @param array|string $where SQL WHERE clause(s). * @return int The number of rows deleted. */ public function delete($where) { $resultSet = $this->fetchAll($where); if (sizeof($resultSet)) { $modelList = new Modules_Publications_Model_List(); foreach ($resultSet as $row) { $tableInfo = $modelList->fetchRow($modelList->select()->where('rubric_id = ?', $row->rubric_id)); $tableName = $tableInfo->table_name; $filedName = $row->name; $_migrationManager = new Modules_Dbmigrations_Framework_Manager(); $_migrationManager->downTo('Modules_Publications_Migrations_CreatePublicationAbstractFieled', array($tableName, $filedName)); } } return parent::delete($where); }
/** * Handle product delete * * @param $event * @return AW_Advancedreports_Model_Observer */ public function productDeleteBefore($event) { /** @var Mage_Catalog_Model_Product $product */ $product = $event->getProduct(); $searchSku = $product->getSku(); $sku = $product->getSku; /** @var AW_Advancedreports_Model_Sku $skuRelevance */ $sku = Mage::getModel('advancedreports/sku'); $tableName = $sku->getResource()->getMainTable(); $writeAdapter = $this->_helper()->getWriteAdapter(); try { $writeAdapter->beginTransaction(); $tableConnection = new Zend_Db_Table(array(Zend_Db_Table::ADAPTER => $writeAdapter, Zend_Db_Table::NAME => $tableName)); $tableConnection->delete("sku = '{$searchSku}'"); $writeAdapter->commit(); } catch (Exception $e) { Mage::logException($e); } return $this; }
/** * Deletes a new thread, by marking it as deleted. If both users deleted it * it is phisically deleted as well * * @param array $data: thread_id and user_id who is deleting */ public function deleteThread(array $data) { /* Fetch thread */ $threads_table = new Zend_Db_Table('threads'); $select = $threads_table->select()->where('id = ?', $data['thread_id']); $thread = $threads_table->fetchRow($select); /* Update flags */ if ($thread->user_from == $data['user_id']) { $thread->deleted_from = 1; } elseif ($thread->user_to == $data['user_id']) { $thread->deleted_to = 1; } else { return null; } $thread->save(); /* If both deleted, delete physically */ if ($thread->deleted_from && $thread->deleted_to) { $messages_table = new Zend_Db_Table('messages'); $whereM = $messages_table->getAdapter()->quoteInto('id = ?', $data['thread_id']); $messages_table->delete($whereM); $thread->delete(); } return; }
public function saveUserAttributes(Application_Model_Models_User $user) { $paramsCount = func_num_args(); if ($paramsCount === 1) { list($user) = func_get_args(); $attribs = $user->getAttributes(); } elseif ($paramsCount === 2) { list($user, $attribs) = func_get_args(); } elseif ($paramsCount === 3) { $params = func_get_args(); $user = array_shift($params); $attribs = array($params[0] => $params[1]); unset($params); } $dbTable = new Zend_Db_Table('user_attributes'); $userId = $user->getId(); $dbTable->delete(array('user_id = ?' => $userId)); if (is_array($attribs) && !empty($attribs)) { foreach ($attribs as $name => $value) { $dbTable->insert(array('user_id' => $userId, 'attribute' => $name, 'value' => $value)); } $user->setAttributes($attribs); } return $user; }
/** * 删除新闻 * * @param array $arrayID */ public function delete($arrayID) { try { //开启事务 $this->getAdapter()->beginTransaction(); //遍历所有ID foreach ($arrayID as $id) { //清除指定标识的缓存 $this->_cache->clean(Zend_Cache::CLEANING_MODE_MATCHING_TAG, array(strtolower($this->_name))); $this->_cache->clean(Zend_Cache::CLEANING_MODE_MATCHING_TAG, array(strtolower($this->_name . '_findById_' . $id))); } //指定查询条件 $where = $this->getAdapter()->quoteInto('id in(?)', $arrayID); parent::delete($where); //提交查询 $this->getAdapter()->commit(); } catch (Zend_Exception $e) { echo $e->getMessage(); //如果出错则事务回滚 $this->getAdapter()->rollBack(); } }
/** * delete data overloaded to log the action */ public function delete($where) { $toreturn = parent::delete($where); if ($toreturn > 0) { $this->log('DELETE:' . $toreturn . ' row(s) deleted'); } else { $this->log('DELETE:no row(s) deleted', Zend_Log::ERR); } return $toreturn; }
/** * 删除ID所在行 * @param int or array $id * @param string $column 字段名 * @see Zend_Db_Table_Abstract::delete() * @return boolean 更新成功返回true,否则false */ public function delete($id, $column = 'id') { $db = $this->getAdapter(); $wherePre = $column . " in(?)"; $where = $db->quoteInto($wherePre, $id); $deletedRows = parent::delete($where); return $deletedRows ? true : false; }
/** * Unregisters plugin custom recipients * @param $pluginName * @return Application_Model_Mappers_EmailTriggersMapper */ public function unregisterRecipients($pluginName) { $recipients = $this->_getRecipients($pluginName); if (is_array($recipients) && !empty($recipients)) { $recipientsTable = new Zend_Db_Table('email_triggers_recipient'); foreach ($recipients as $recipient) { $recipientsTable->delete(array('recipient = ?' => $recipient)); } } return $this; }
public function delete($where) { $this->_db = CrFramework_Db_Control::getAdapter('write'); $this->setDefaultAdapter($this->_db); logStd(get_class($this) . '->delete()', 'Write to MASTER'); return parent::delete($where); }
public function deleteAllByPk($id = array()) { $ids = is_array($id) ? implode(',', $id) : $id; $res = parent::delete($this->pkname . ' in (' . $ids . ')'); return $res ? json_encode(explode(',', $ids)) : $res; }
public function deleteAction() { $calendar = new Zend_Db_Table('calendar'); $id = Zend_Filter::filterStatic($this->_getParam('id'), 'int'); if (!$id) { $this->_redirect('calendar/index/'); } $calendar->delete(array('id = ?' => $id)); $this->_helper->_flashMessenger->addMessage('Success'); $this->_redirect('calendar/index/'); }
public function deleteAd($id) { $table = new Zend_Db_Table('ads'); return $table->delete('id =' . (int) $id); }
public function deleteUser($id) { $table = new Zend_Db_Table('users'); $table->delete('id =' . (int) $id); }
public function delete($where, $role_id = null) { if (empty($role_id)) { throw new Exception(__METHOD__ . ' : "Empty input parameters"'); } /* * если есть ссылки из таблиц: webacula_roles или webacula_users * то удаление не производить */ Zend_Loader::loadClass('Wbusers'); $users = new Wbusers(); // $select = $this->select()->where('inherit_id = ?', $role_id)->where('inherit_id != id'); $rows = $this->fetchAll($select); if ($users->fetchRow($this->getAdapter()->quoteInto('role_id = ?', $role_id)) || $rows->count() > 0) { $translate = Zend_Registry::get('translate'); throw new Zend_Exception($translate->_('Can not delete. Role is used.')); } else { /* * delete cascade */ $arr_table = array('WbCommandACL', 'Wbresources', 'WbStorageACL', 'WbPoolACL', 'WbClientACL', 'WbFilesetACL', 'WbJobACL', 'WbWhereACL'); $where_tbl = $this->getAdapter()->quoteInto('role_id = ?', $role_id); foreach ($arr_table as $tbl) { Zend_Loader::loadClass($tbl); $table = new $tbl(); $table->delete($where_tbl); unset($table); } // delete main record return parent::delete($where); } }
public function delete($where) { $params['where'] = $where; $params = $this->_rivety_plugin->doFilter('rivetycore_db_table_abstract_before_delete', $params); // FILTER HOOK $where = $params['where']; $output = parent::delete($where); $params['output'] = $output; $this->_rivety_plugin->doAction('rivetycore_db_table_abstract_after_delete', $params); // ACTION HOOK return $output; }
public function delete($where) { return parent::delete($where); }
/** * Удаляем элемент меню * * @param int $item_id */ public function deleteItem($item_id) { $where = $this->_modelItems->getAdapter()->quoteInto('item_id = ?', $item_id); $this->_modelItems->delete($where); }