示例#1
0
 /**
  * @return Connection
  */
 public function getConnection()
 {
     if (!$this->connection) {
         $this->connection = Database::connection();
     }
     return $this->connection;
 }
 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 setAttributes($attributes)
 {
     if (is_array($attributes)) {
         $db = Database::connection();
         $db->Execute('DELETE FROM AttributeFormTypeAttributes WHERE aftID = ?', array($this->getID()));
         $sortOrder = 1;
         foreach ($attributes as $akID) {
             $data = ['aftID' => $this->getID(), 'akID' => $akID, 'sortOrder' => $sortOrder++];
             $db->insert('AttributeFormTypeAttributes', $data);
         }
     }
 }
 public function delete()
 {
     parent::delete();
     $db = Database::connection();
     $r = $db->Execute('select avID from AttributeFormsAttributeValues where akID = ?', array($this->getAttributeKeyID()));
     while ($row = $r->FetchRow()) {
         $db->Execute('delete from AttributeValues where avID = ?', array($row['avID']));
     }
     $db->Execute('delete from AttributeFormsAttributeValues where akID = ?', array($this->getAttributeKeyID()));
 }
 public function deleteValue()
 {
     $db = Database::connection();
     $db->Execute('delete from atAttributeSwitcher where avID = ?', array($this->getAttributeValueID()));
 }
 public function getAttributeValueObject($ak, $createIfNotFound = false)
 {
     $db = Database::connection();
     $av = false;
     $v = array($this->getID(), $ak->getAttributeKeyID());
     $avID = $db->GetOne("select avID from AttributeFormsAttributeValues where afID = ? and akID = ?", $v);
     if ($avID > 0) {
         $av = AttributeFormValue::getByID($avID);
         if (is_object($av)) {
             $av->setAttributeForm($this);
             $av->setAttributeKey($ak);
         }
     }
     if ($createIfNotFound) {
         $cnt = 0;
         // Is this avID in use ?
         if (is_object($av)) {
             $cnt = $db->GetOne("select count(avID) from AttributeFormsAttributeValues where avID = ?", $av->getAttributeValueID());
         }
         if (!is_object($av) || $cnt > 1) {
             $av = $ak->addAttributeValue();
         }
     }
     return $av;
 }