order_package.php

Go to the documentation of this file.

<?php

class Order_Package extends oxAdminDetails
{
    public function myarray_search ($needle, $haystick)
    {    // uses key instead of value

        foreach ($haystick as $key => $val) {
            if ($needle === $key) {
                return($key);
            }
        }

        return false;
    }

    public function render()
    {
        $myConfig = $this->getConfig();
        parent::render();

        $oDB = oxDb::getDb();
        $OldMode = $oDB->setFetchMode( ADODB_FETCH_ASSOC);

        $sSelect  = "select * from oxwrapping";
        $rs = $oDB->selectLimit( $sSelect, 5000, 0);

        $aWrappings = array();
        if ($rs != false && $rs->recordCount() > 0) {
            while ( !$rs->EOF) {
                $key = $rs->fields['OXID'];
                $aWrappings[$key] = new oxStdClass();
                $aWrappings[$key]->fields = $rs->fields;
                $rs->moveNext();
            }
        }

        $sSelect  = "select oxorder.*, oxorderarticles.*, oxorder.oxid as orderid, oxorderarticles.oxid as orderartid from oxorder left join oxorderarticles on oxorder.oxid = oxorderarticles.oxorderid where oxorder.oxsenddate = '0000-00-00 00:00:00' and oxorder.oxshopid = '".$myConfig->getShopId()."' and oxorderarticles.oxstorno != '1' order by oxorder.oxorderdate asc";
        $rs = $oDB->selectLimit( $sSelect, 5000, 0);

        $iCnt = 0;

        $aOrders = array();

        if ($rs != false && $rs->recordCount() > 0) {
            while ( !$rs->EOF) {
                $key = $rs->fields['orderid'];

                if ( !$aOrders[$key] ) {
                    $aOrders[$key] = new oxStdClass();
                }
                $aOrders[$key]->fields = $rs->fields;
                if ( !$aOrders[$key]->articles ) {
                    $aOrders[$key]->articles = array();
                }
                $aOrders[$key]->articles[$rs->fields['orderartid']] = $rs->fields;

                $sLangAppend = '';
                if ($rs->fields['OXLANG'])
                    $sLangAppend = '_'.$rs->fields['OXLANG'];

                if ($rs->fields['OXCARDID'] && isset($aWrappings[$rs->fields['OXCARDID']]))
                    $aOrders[$key]->sPostCardName = $aWrappings[$rs->fields['OXCARDID']]->fields['OXNAME'.$sLangAppend];
                else
                    $aOrders[$key]->oPostCard = "";

                $aArticle =  & $aOrders[$key]->articles[$rs->fields['orderartid']];
                if ($rs->fields['OXWRAPID'] && isset($aWrappings[$rs->fields['OXWRAPID']]))
                    $aArticle['sPostCardName'] = $aWrappings[$rs->fields['OXWRAPID']]->fields['OXNAME'.$sLangAppend];
                else
                    $aArticle['sPostCardName'] = '';

                $rs->moveNext();
                $iCnt++;
            }
        }

        $oDB->setFetchMode( $OldMode);

        $this->_aViewData['resultset']     = @$aOrders;

        return "order_package.tpl";
    }
}

---