Example #1
0
 /**
  * Inserts object details to DB, returns true on success.
  *
  * @return bool
  */
 protected function _insert()
 {
     if (!$this->oxnews__oxdate || oxRegistry::get("oxUtilsDate")->isEmptyDate($this->oxnews__oxdate->value)) {
         // if date field is empty, assigning current date
         $this->oxnews__oxdate = new oxField(date('Y-m-d'));
     } else {
         $this->oxnews__oxdate = new oxField(oxRegistry::get("oxUtilsDate")->formatDBDate($this->oxnews__oxdate->value, true));
     }
     return parent::_insert();
 }
Example #2
0
 /**
  * Inserts new category (and updates existing node oxLeft amd oxRight accordingly). Returns true on success.
  *
  * @return bool
  */
 protected function _insert()
 {
     if ($this->oxcategories__oxparentid->value != "oxrootid") {
         // load parent
         $oParent = oxNew("oxCategory");
         //#M317 check if parent is loaded
         if (!$oParent->load($this->oxcategories__oxparentid->value)) {
             return false;
         }
         $sAdd = " and oxshopid = '" . $this->getShopId() . "' ";
         // update existing nodes
         $oDb = oxDb::getDb();
         $oDb->execute("UPDATE oxcategories SET OXLEFT = OXLEFT + 2\n                                           WHERE  OXROOTID = " . $oDb->quote($oParent->oxcategories__oxrootid->value) . "\n                            AND OXLEFT >   " . (int) $oParent->oxcategories__oxright->value . "\n                            AND OXRIGHT >= " . (int) $oParent->oxcategories__oxright->value . $sAdd);
         $oDb->execute("UPDATE oxcategories SET OXRIGHT = OXRIGHT + 2\n                                           WHERE  OXROOTID = " . $oDb->quote($oParent->oxcategories__oxrootid->value) . "\n                            AND OXRIGHT >= " . (int) $oParent->oxcategories__oxright->value . $sAdd);
         if (!$this->getId()) {
             $this->setId();
         }
         $this->oxcategories__oxrootid = new oxField($oParent->oxcategories__oxrootid->value, oxField::T_RAW);
         $this->oxcategories__oxleft = new oxField($oParent->oxcategories__oxright->value, oxField::T_RAW);
         $this->oxcategories__oxright = new oxField($oParent->oxcategories__oxright->value + 1, oxField::T_RAW);
         return parent::_insert();
     } else {
         // root entry
         if (!$this->getId()) {
             $this->setId();
         }
         $this->oxcategories__oxrootid = new oxField($this->getId(), oxField::T_RAW);
         $this->oxcategories__oxleft = new oxField(1, oxField::T_RAW);
         $this->oxcategories__oxright = new oxField(2, oxField::T_RAW);
         return parent::_insert();
     }
 }
 /**
  * Inserts new category (and updates existing node oxleft amd oxright accordingly). Returns true on success.
  *
  * @return bool
  */
 protected function _insert()
 {
     if ($this->oxcategories__oxparentid->value != "oxrootid") {
         // load parent
         $oParent = oxNew("oxcategory");
         //#M317 check if parent is loaded
         if (!$oParent->load($this->oxcategories__oxparentid->value)) {
             return false;
         }
         $sAdd = " and oxshopid = '" . $this->getShopId() . "' ";
         // update existing nodes
         $oDB = oxDb::getDb();
         $oDB->execute("UPDATE oxcategories SET OXLEFT = OXLEFT + 2\n                            WHERE  OXROOTID = " . $oDB->quote($oParent->oxcategories__oxrootid->value) . "\n                            AND OXLEFT >   " . (int) $oParent->oxcategories__oxright->value . "\n                            AND OXRIGHT >= " . (int) $oParent->oxcategories__oxright->value . $sAdd);
         $oDB->execute("UPDATE oxcategories SET OXRIGHT = OXRIGHT + 2\n                            WHERE  OXROOTID = " . $oDB->quote($oParent->oxcategories__oxrootid->value) . "\n                            AND OXRIGHT >= " . (int) $oParent->oxcategories__oxright->value . $sAdd);
         //if ( !isset( $this->_sOXID) || trim( $this->_sOXID) == "")
         //    $this->_sOXID = oxUtilsObject::getInstance()->generateUID();
         //$this->oxcategories__oxid->setValue($this->_sOXID);
         //refactored to:
         if (!$this->getId()) {
             $this->setId();
         }
         $this->oxcategories__oxrootid = new oxField($oParent->oxcategories__oxrootid->value, oxField::T_RAW);
         $this->oxcategories__oxleft = new oxField($oParent->oxcategories__oxright->value, oxField::T_RAW);
         $this->oxcategories__oxright = new oxField($oParent->oxcategories__oxright->value + 1, oxField::T_RAW);
         return parent::_insert();
     } else {
         // root entry
         if (!$this->getId()) {
             $this->setId();
         }
         $this->oxcategories__oxrootid = new oxField($this->getId(), oxField::T_RAW);
         $this->oxcategories__oxleft = new oxField(1, oxField::T_RAW);
         $this->oxcategories__oxright = new oxField(2, oxField::T_RAW);
         return parent::_insert();
     }
 }
Example #4
0
 /**
  * Sets article creation date
  * (oxarticle::oxarticles__oxinsert). Then executes parent method
  * parent::_insert() and returns insertion status.
  *
  * @return bool
  */
 protected function _insert()
 {
     // set oxinsert
     $sNow = date('Y-m-d H:i:s', oxRegistry::get("oxUtilsDate")->getTime());
     $this->oxarticles__oxinsert = new oxField($sNow);
     if (!is_object($this->oxarticles__oxsubclass) || $this->oxarticles__oxsubclass->value == '') {
         $this->oxarticles__oxsubclass = new oxField('oxarticle');
     }
     return parent::_insert();
 }
 /**
  * Sets article creation date
  * (oxarticle::oxarticles__oxinsert). Then executes parent method
  * parent::_insert() and returns insertion status.
  *
  * @return bool
  */
 protected function _insert()
 {
     // set oxinsert
     $iInsertTime = time();
     $now = date('Y-m-d H:i:s', $iInsertTime);
     $this->oxarticles__oxinsert = new oxField($now);
     $this->oxarticles__oxtimestamp = new oxField($now);
     if (!is_object($this->oxarticles__oxsubclass) || $this->oxarticles__oxsubclass->value == '') {
         $this->oxarticles__oxsubclass = new oxField('oxarticle');
     }
     return parent::_insert();
 }