File indexing completed on 2025-02-09 07:14:34
0001 <?php 0002 0003 /** 0004 * ocs-webserver 0005 * 0006 * Copyright 2016 by pling GmbH. 0007 * 0008 * This file is part of ocs-webserver. 0009 * 0010 * This program is free software: you can redistribute it and/or modify 0011 * it under the terms of the GNU Affero General Public License as 0012 * published by the Free Software Foundation, either version 3 of the 0013 * License, or (at your option) any later version. 0014 * 0015 * This program is distributed in the hope that it will be useful, 0016 * but WITHOUT ANY WARRANTY; without even the implied warranty of 0017 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 0018 * GNU Affero General Public License for more details. 0019 * 0020 * You should have received a copy of the GNU Affero General Public License 0021 * along with this program. If not, see <http://www.gnu.org/licenses/>. 0022 **/ 0023 class Default_Model_DbTable_MemberSettingValue extends Local_Model_Table 0024 { 0025 0026 protected $_name = "member_setting_value"; 0027 0028 protected $_keyColumnsForRow = array('member_setting_value_id'); 0029 0030 protected $_key = 'member_setting_value_id'; 0031 0032 public function init() 0033 { 0034 parent::init(); 0035 } 0036 0037 0038 0039 0040 public function delete($where) 0041 { 0042 $where = parent::_whereExpr($where); 0043 0044 /** 0045 * Build the DELETE statement 0046 */ 0047 $sql = "UPDATE " . parent::getAdapter()->quoteIdentifier($this->_name, true) . " SET `is_active` = 0, `deleted_at` = NOW() " . (($where) ? " WHERE $where" : ''); 0048 0049 /** 0050 * Execute the statement and return the number of affected rows 0051 */ 0052 $stmt = parent::getAdapter()->query($sql); 0053 $result = $stmt->rowCount(); 0054 0055 return $result; 0056 } 0057 0058 }