public function delete()
{
$db = Database::connection();
$db->Execute('delete from AttributeFormsAttributeValues where afID = ? and akID = ? and avID = ?', array($this->item->getID(), $this->attributeKey->getAttributeKeyID(), $this->getAttributeValueID()));
// Before we run delete() on the parent object, we make sure that attribute value isn't being referenced in the table anywhere else
$num = $db->GetOne('select count(avID) from AttributeFormsAttributeValues where avID = ?', array($this->getAttributeValueID()));
if ($num < 1) {
parent::delete();
}
}
public function delete()
{
$db = Loader::db();
$db->Execute('delete from UserAttributeValues where uID = ? and akID = ? and avID = ?', array($this->u->getUserID(), $this->attributeKey->getAttributeKeyID(), $this->getAttributeValueID()));
// Before we run delete() on the parent object, we make sure that attribute value isn't being referenced in the table anywhere else
$num = $db->GetOne('select count(avID) from UserAttributeValues where avID = ?', array($this->getAttributeValueID()));
if ($num < 1) {
parent::delete();
}
}
protected function getAttributeValueID()
{
if (is_object($this->attributeValue)) {
return $this->attributeValue->getAttributeValueID();
}
}
/**
* Adds a generic attribute record (with this type) to the AttributeValues table
*/
public function addAttributeValue()
{
$db = Loader::db();
$u = new User();
$dh = Loader::helper('date');
$uID = $u->isRegistered() ? $u->getUserID() : 0;
$avDate = $dh->getOverridableNow();
$v = array($this->atID, $this->akID, $uID, $avDate);
$db->Execute('insert into AttributeValues (atID, akID, uID, avDateAdded) values (?, ?, ?, ?)', $v);
$avID = $db->Insert_ID();
return AttributeValue::getByID($avID);
}
/**
* Adds a generic attribute record (with this type) to the AttributeValues table.
*/
public function addAttributeValue()
{
$db = Database::connection();
$u = new User();
$dh = Core::make('helper/date');
$uID = $u->isRegistered() ? $u->getUserID() : 0;
$avDate = $dh->getOverridableNow();
$v = array($this->atID, $this->akID, $uID, $avDate);
$db->executeQuery('insert into AttributeValues (atID, akID, uID, avDateAdded) values (?, ?, ?, ?)', $v);
$avID = $db->lastInsertId();
return AttributeValue::getByID($avID);
}
public function __destruct()
{
parent::__destruct();
unset($this->form);
}
