oxerptype_orderstatus.php

Go to the documentation of this file.

<?php

require_once( 'oxerptype.php');

class oxERPType_OrderStatus extends oxERPType
{
    public function __construct()
    {
        parent::__construct();

        $this->_sTableName = 'oxorderarticles';

        $this->_aFieldList = array(
            'OXID'          => 'OXID',
            'OXERPSTATUS_STATUS'   => 'OXERPSTATUS_STATUS',
            'OXERPSTATUS_TIME'     => 'OXERPSTATUS_TIME',
            'OXERPSTATUS_TRACKID'  => 'OXERPSTATUS_TRACKID'
        );
    }

    public function getSQL( $sWhere, $iLanguage = 0, $iShopID = 1)
    {
         if( strstr( $sWhere, 'where'))
            $sWhere .= ' and ';
        else
            $sWhere .= ' where ';

        $sWhere .= 'oxordershopid = \''.$iShopID.'\'';

        return parent::getSQL($sWhere, $iLanguage, $iShopID);
    }

    public function checkWriteAccess($sOxid)
    {
        $myConfig = oxConfig::getInstance();

        $oDB = oxDb::getDb();

        $sSql = "select oxordershopid from ". $this->getTableName($myConfig->getShopId()) ." where oxid = '". $sOxid ."'";
        $sRes = $oDB->getOne($sSql);

        if($sRes && $sRes != $myConfig->getShopId()){
            throw new Exception( oxERPBase::$ERROR_USER_NO_RIGHTS);
        }
    }

    protected function _preAssignObject($oShopObject, $aData, $blAllowCustomShopId)
    {
        $aData = parent::_preAssignObject($oShopObject, $aData, $blAllowCustomShopId);
        if (isset($aData['OXERPSTATUS_STATUS'])
            && isset($aData['OXERPSTATUS_TIME'])
            && isset($aData['OXERPSTATUS_TRACKID']))
            {
            $oStatus = new stdClass();
            $oStatus->STATUS        = $aData['OXERPSTATUS_STATUS'];
            $oStatus->date          = $aData['OXERPSTATUS_TIME'];
            $oStatus->trackingid    = $aData['OXERPSTATUS_TRACKID'];
            $aData['OXERPSTATUS']   = serialize( $oStatus );
        }
        return $aData;
    }

    public function addExportData( $aFields)
    {
        if ($aFields['OXERPSTATUS']) {
            $oStatus = @unserialize($aFields['OXERPSTATUS']);
            unset($aFields['OXERPSTATUS']);
            if (is_object($oStatus)) {
                $aFields['OXERPSTATUS_STATUS']  = $oStatus->STATUS;
                $aFields['OXERPSTATUS_TIME']    = $oStatus->date;
                $aFields['OXERPSTATUS_TRACKID'] = $oStatus->trackingid;
            }
        }
        return $aFields;
    }


    protected function getSqlFieldName($sField, $iLanguage = 0, $iShopID = 1)
    {
        switch ($sField) {
            case 'OXERPSTATUS_STATUS':
                return "(OXERPSTATUS) as OXERPSTATUS";
            case 'OXERPSTATUS_TIME':
            case 'OXERPSTATUS_TRACKID':
                return "'' as $sField";
        }

        return parent::getSqlFieldName($sField, $iLanguage, $iShopID);
    }


}

---