oxactions.php

Go to the documentation of this file.

<?php

class oxActions extends oxBase
{
    protected $_sClassName = "oxactions";

    public function __construct()
    {
        parent::__construct();
        $this->init( "oxactions" );
    }

    public function addArticle( $sOxId )
    {
        $oNewGroup = oxNew( 'oxbase' );
        $oNewGroup->init( 'oxactions2article' );
        $oNewGroup->oxactions2article__oxshopid = new oxField($this->getShopId());
        $oNewGroup->oxactions2article__oxactionid = new oxField($this->getId());
        $oNewGroup->oxactions2article__oxartid = new oxField($sOxId);
        $oNewGroup->oxactions2article__oxsort = new oxField(((int) oxDb::getDb(true)->getOne("select max(oxsort) from oxactions2article where oxactionid = '".$this->getId()."' and oxshopid = '".$this->getShopId()."'") + 1 ));
        $oNewGroup->save();
    }

    public function removeArticle( $sOxId )
    {
        // remove actions from articles also
        $oDB = oxDb::getDb(true);
        $sDelete = "delete from oxactions2article where oxactionid = '".$this->getId()."' and oxartid = '$sOxId' and oxshopid = '" . $this->getShopId() . "'";
        $oDB->execute( $sDelete );

        return ( bool ) $oDB->affected_Rows();
    }

    public function delete( $sOxId = null )
    {
        if ( !$sOxId ) {
            $sOxId = $this->getId();
        }
        if ( !$sOxId ) {
            return false;
        }


        // remove actionss from articles also
        $oDB = oxDb::getDb(true);
        $sDelete = "delete from oxactions2article where oxactionid = '$sOxId' and oxshopid = '" . $this->getShopId() . "'";
        $oDB->execute( $sDelete );

        return parent::delete( $sOxId );
    }
}

---