oxdeliveryset.php

Go to the documentation of this file.

<?php

class oxDeliverySet extends oxI18n
{
    protected $_sCoreTbl = 'oxdeliveryset';

    protected $_sClassName = 'oxdeliveryset';

    public function __construct()
    {
        parent::__construct();
        $this->init( 'oxdeliveryset' );
    }

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


        $oDb = oxDb::getDb();

        $sOxidQuoted = $oDb->quote($sOxId);
        $oDb->execute( 'delete from oxobject2payment where oxobjectid = '.$sOxidQuoted );
        $oDb->execute( 'delete from oxobject2delivery where oxdeliveryid = '.$sOxidQuoted);
        $oDb->execute( 'delete from oxdel2delset where oxdelsetid = '.$sOxidQuoted);

        return parent::delete( $sOxId );
    }

    public function getIdByName( $sTitle )
    {
        $sQ = "SELECT `oxid` FROM `" . getViewName( 'oxdeliveryset' ) . "` WHERE  `oxtitle` = " . oxDb::getDb()->quote( $sTitle );
        $sId = oxDb::getDb()->getOne( $sQ );

        return $sId;
    }
}