article_crossselling.php

Go to the documentation of this file.

<?php

class Article_Crossselling extends oxAdminDetails
{

    public function render()
    {
        parent::render();

        $this->_aViewData['edit'] = $oArticle = oxNew( 'oxarticle' );

        // crossselling
        $sChosenArtCat = $this->_getCategoryTree( "artcattree", oxConfig::getParameter( "artcat"));

        // accessoires
        $sChosenArtCat2 = $this->_getCategoryTree( "artcattree2", oxConfig::getParameter( "artcat2"));

        $soxId = oxConfig::getParameter( "oxid");
        if ( $soxId != "-1" && isset( $soxId ) ) {   // load object
            $oArticle->load( $soxId);

            if ($oArticle->isDerived())
                $this->_aViewData['readonly'] = true;
        }

        $aColumns = array();
        $iAoc = oxConfig::getParameter("aoc");
        if ( $iAoc == 1 ) {

            include_once 'inc/article_crossselling.inc.php';
            $this->_aViewData['oxajax'] = $aColumns;

            return "popups/article_crossselling.tpl";
        } elseif ( $iAoc == 2 ) {

            include_once 'inc/article_accessories.inc.php';
            $this->_aViewData['oxajax'] = $aColumns;

            return "popups/article_accessories.tpl";
        }
        return "article_crossselling.tpl";
    }

    public function setSorting( $sTable = null)
    {
        if ( $sTable == null)
            $sTable = oxConfig::getParameter("stable");
        $soxId     = oxConfig::getParameter("oxid");
        $sSorting  = oxConfig::getParameter("sorting");
        $sTarget   = oxConfig::getParameter("starget");
        $aObjectId = oxConfig::getParameter( $sTarget);


        if ( !isset($soxId) || $soxId == "-1" || $sTable == null || !$sTable)
            return 0;

        //means appending article to the end, sorting number will be last number
        if ( !isset($sSorting) || !$sSorting) {
            $sSelect = "select count(*) from $sTable where $sTable.oxarticlenid = '".$soxId."' ";
            $oDB = oxDb::getDb();
            return $oDB->getOne( $sSelect);
        } else if ( count($aObjectId) > 0) {
            if ( $sSorting == "up") {
                $aList = $this->_getSortingList( $sTable);
                $sFItmId = $aObjectId[0];
                foreach ( $aList as $iNum => $aItem) {
                    if ( $aItem[2] == $sFItmId && $iNum > 0) {
                        $oDB = oxDb::getDb();
                        $sSelect = "update $sTable set $sTable.oxsort=".( $iNum + count($aObjectId) - 1 )." where $sTable.oxobjectid='".$aList[$iNum-1][2]."'";
                        $oDB->execute( $sSelect);
                        foreach ( $aObjectId as $iSNum => $sItem) {
                            $sSelect = "update $sTable set $sTable.oxsort=".( $iNum + $iSNum - 1 )." where $sTable.oxobjectid='".$sItem."'";
                            $oDB->execute( $sSelect);
                        }
                        break;
                    }
                }
            } elseif ( $sSorting == "down") {
                $aList = $this->_getSortingList( $sTable);
                $sFItmId = $aObjectId[count($aObjectId)-1];
                foreach ( $aList as $iNum => $aItem) {
                    if ( $aItem[2] == $sFItmId && $iNum < (count($aList)-1)) {
                        $oDB = oxDb::getDb();
                        $sSelect = "update $sTable set $sTable.oxsort=".( $iNum - count($aObjectId) + 1 )." where $sTable.oxobjectid='".$aList[$iNum+1][2]."'";
                        $oDB->execute( $sSelect);
                        foreach ( $aObjectId as $iSNum => $sItem) {
                            $sSelect = "update $sTable set $sTable.oxsort=".( $iNum - $iSNum + 1 )." where $sTable.oxobjectid='".$sItem."'";
                            $oDB->execute( $sSelect);
                        }
                        break;
                    }
                }
            }
            $this->updateSorting( $sTable );
        }
    }


    public function updateSorting( $sTable )
    {
        $soxId = oxConfig::getParameter( "oxid");
        if ( !isset($soxId) && $soxId == "-1")
            return;

        $aList = $this->_getSortingList( $sTable);
        // updates sorting
        $oDB = oxDb::getDb();
        foreach ( $aList as $iNum => $aItem) {
            if ( $aItem[1] != $iNum) {
                $sSelect = "update $sTable set $sTable.oxsort=$iNum where $sTable.oxid='".$aItem[0]."'";
                $oDB->execute( $sSelect);
            }
        }
    }


    protected function _getSortingList( $sTable)
    {
        $soxId    = oxConfig::getParameter( "oxid");


        if ( !isset($soxId) && $soxId == "-1")
            return;
        $sSelect  = "select $sTable.oxid, $sTable.oxsort, $sTable.oxobjectid , ";
        $sSelect .= "$sTable.oxarticlenid from $sTable where $sTable.oxarticlenid = '".$soxId."' order by $sTable.oxsort";
        $oDB = oxDb::getDb();
        $aList = array();
        $rs = $oDB->selectLimit( $sSelect, 1000, 0);
        //fetches assigned article list
        if ($rs != false && $rs->recordCount() > 0) {
            while (!$rs->EOF) {
                $aList[] = array($rs->fields[0], $rs->fields[1], $rs->fields[2], $rs->fields[3]);
                $rs->moveNext();
            }
        }
        return $aList;
    }

}

---