Go to the documentation of this file.00001 <?php
00002
00006 class discount_groups_ajax extends ajaxListComponent
00007 {
00013 protected $_aColumns = array( 'container1' => array(
00014 array( 'oxtitle', 'oxgroups', 1, 0, 0 ),
00015 array( 'oxid', 'oxgroups', 0, 0, 0 ),
00016 array( 'oxid', 'oxgroups', 0, 0, 1 ),
00017 ),
00018 'container2' => array(
00019 array( 'oxtitle', 'oxgroups', 1, 0, 0 ),
00020 array( 'oxid', 'oxgroups', 0, 0, 0 ),
00021 array( 'oxid', 'oxobject2discount', 0, 0, 1 ),
00022 )
00023 );
00024
00030 protected function _getQuery()
00031 {
00032
00033 $sGroupTable = $this->_getViewName('oxgroups');
00034 $oDb = oxDb::getDb();
00035 $sId = oxConfig::getParameter( 'oxid' );
00036 $sSynchId = oxConfig::getParameter( 'synchoxid' );
00037
00038
00039 if ( !$sId) {
00040 $sQAdd = " from $sGroupTable where 1 ";
00041 } else {
00042 $sQAdd .= " from oxobject2discount, $sGroupTable where $sGroupTable.oxid=oxobject2discount.oxobjectid ";
00043 $sQAdd .= " and oxobject2discount.oxdiscountid = ".$oDb->quote( $sId )." and oxobject2discount.oxtype = 'oxgroups' ";
00044 }
00045
00046 if ( $sSynchId && $sSynchId != $sId) {
00047 $sQAdd .= " and $sGroupTable.oxid not in ( select $sGroupTable.oxid from oxobject2discount, $sGroupTable where $sGroupTable.oxid=oxobject2discount.oxobjectid ";
00048 $sQAdd .= " and oxobject2discount.oxdiscountid = ".$oDb->quote( $sSynchId )." and oxobject2discount.oxtype = 'oxgroups' ) ";
00049 }
00050
00051 return $sQAdd;
00052 }
00053
00059 public function removeDiscGroup()
00060 {
00061 $aRemoveGroups = $this->_getActionIds( 'oxobject2discount.oxid' );
00062 if ( oxConfig::getParameter( 'all' ) ) {
00063
00064 $sQ = $this->_addFilter( "delete oxobject2discount.* ".$this->_getQuery() );
00065 oxDb::getDb()->Execute( $sQ );
00066
00067 } elseif ( $aRemoveGroups && is_array( $aRemoveGroups ) ) {
00068 $sQ = "delete from oxobject2discount where oxobject2discount.oxid in (" . implode( ", ", oxDb::getInstance()->quoteArray( $aRemoveGroups ) ) . ") ";
00069 oxDb::getDb()->Execute( $sQ );
00070 }
00071 }
00072
00078 public function addDiscGroup()
00079 {
00080 $aChosenCat = $this->_getActionIds( 'oxgroups.oxid' );
00081 $soxId = oxConfig::getParameter( 'synchoxid' );
00082
00083 if ( oxConfig::getParameter( 'all' ) ) {
00084 $sGroupTable = $this->_getViewName('oxgroups');
00085 $aChosenCat = $this->_getAll( $this->_addFilter( "select $sGroupTable.oxid ".$this->_getQuery() ) );
00086 }
00087 if ( $soxId && $soxId != "-1" && is_array( $aChosenCat ) ) {
00088 foreach ( $aChosenCat as $sChosenCat) {
00089 $oObject2Discount = oxNew( "oxbase" );
00090 $oObject2Discount->init( 'oxobject2discount' );
00091 $oObject2Discount->oxobject2discount__oxdiscountid = new oxField($soxId);
00092 $oObject2Discount->oxobject2discount__oxobjectid = new oxField($sChosenCat);
00093 $oObject2Discount->oxobject2discount__oxtype = new oxField("oxgroups");
00094 $oObject2Discount->save();
00095 }
00096 }
00097 }
00098 }