1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 <?php
/**
***********************************************************************************************
* Class manages access to database table adm_invent
*
* @copyright 2004-2016 The Admidio Team
* @see http://www.admidio.org/
* @license https://www.gnu.org/licenses/gpl-2.0.html GNU General Public License v2.0 only
***********************************************************************************************
*/
/**
* @class TableInventory
* this Class is used to create an object from Inventory.
* an item can be managed from this class
*
* Beside the methods of the parent class there are the following additional methods:
*/
class TableInventory extends TableAccess
{
/**
* Constructor that will create an object of a recordset of the table adm_invent.
* If the id is set than the specific item will be loaded.
* @param \Database $database Object of the class Database. This should be the default global object @b $gDb.
* @param int $itemId The recordset of the item with this id will be loaded. If id isn't set than an empty object of the table is created.
*/
public function __construct(&$database, $itemId = 0)
{
parent::__construct($database, TBL_INVENT, 'inv', $itemId);
}
/**
* Additional to the parent method the item will be set @b valid per default.
*/
public function clear()
{
parent::clear();
// new item should be valid
$this->setValue('inv_valid', 1);
$this->columnsValueChanged = false;
}
/**
* Deletes the selected item of the table and all the many references in other tables.
* After that the class will be initialize.
* @return bool @b true if no error occurred
*/
public function delete()
{
$this->db->startTransaction();
$sql = 'DELETE FROM '.TBL_INVENT_DATA.' WHERE ind_itm_id = '. $this->getValue('inv_id');
$this->db->query($sql);
$return = parent::delete();
$this->db->endTransaction();
return $return;
}
}