File indexing completed on 2024-06-16 05:27:01

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 }