src/ShopBundle/objects/db/TShopModuleArticleListFilter/TShopModuleArticlelistFilterNoticeList.class.php
protected function CreateTempNotice($aNoticeList)
    {
        $sTmpTableName = MySqlLegacySupport::getInstance()->real_escape_string('_tmp'.session_id().'noticelist');
        $query = "CREATE TEMPORARY  TABLE `{$sTmpTableName}` (
                              `date_added` datetime NOT NULL,
                              `shop_article_id` char(36) NOT NULL,
                              `amount` decimal(10,2) NOT NULL default '1.00',
                              KEY `shop_article_id` (`shop_article_id`),
                              KEY `date_added` (`date_added`)
                            ) ENGINE=MEMORY  DEFAULT CHARSET=utf8";
        MySqlLegacySupport::getInstance()->query($query);
        reset($aNoticeList);
        foreach ($aNoticeList as $iArticleId => $oNoteItem) {
            /** @var $oNoteItem TdbShopUserNoticeList */
            $query = "INSERT INTO `{$sTmpTableName}`
                  	                  SET `date_added` = '".MySqlLegacySupport::getInstance()->real_escape_string($oNoteItem->fieldDateAdded)."',
                  	                      `shop_article_id` = '".MySqlLegacySupport::getInstance()->real_escape_string($oNoteItem->fieldShopArticleId)."',
                  	                      `amount` = '".MySqlLegacySupport::getInstance()->real_escape_string($oNoteItem->fieldAmount)."'
                  	         ";
            MySqlLegacySupport::getInstance()->query($query);
        }

        return $sTmpTableName;
    }
protected function CreateTempNotice($aNoticeList)
    {
        $sTmpTableName = MySqlLegacySupport::getInstance()->real_escape_string('_tmp'.session_id().'noticelist');
        $query = "CREATE TEMPORARY  TABLE `{$sTmpTableName}` (
                              `date_added` datetime NOT NULL,
                              `shop_article_id` char(36) NOT NULL,
                              `amount` decimal(10,2) NOT NULL default '1.00',
                              KEY `shop_article_id` (`shop_article_id`),
                              KEY `date_added` (`date_added`)
                            ) ENGINE=MEMORY  DEFAULT CHARSET=utf8";
        MySqlLegacySupport::getInstance()->query($query);
        reset($aNoticeList);
        foreach ($aNoticeList as $iArticleId => $oNoteItem) {
            /** @var $oNoteItem TdbShopUserNoticeList */
            $query = "INSERT INTO `{$sTmpTableName}`
                  	                  SET `date_added` = '".MySqlLegacySupport::getInstance()->real_escape_string($oNoteItem->fieldDateAdded)."',
                  	                      `shop_article_id` = '".MySqlLegacySupport::getInstance()->real_escape_string($oNoteItem->fieldShopArticleId)."',
                  	                      `amount` = '".MySqlLegacySupport::getInstance()->real_escape_string($oNoteItem->fieldAmount)."'
                  	         ";
            MySqlLegacySupport::getInstance()->query($query);
        }

        return $sTmpTableName;
    }
protected function CreateTempNotice ( $ aNoticeList ) { $ sTmpTableName = MySqlLegacySupport :: getInstance ( ) -> real_escape_string ( '_tmp' . session_id ( ) . 'noticelist' ) ; $ query = "CREATE TEMPORARY  TABLE `{$sTmpTableName}` (
                              `date_added` datetime NOT NULL,
                              `shop_article_id` char(36) NOT NULL,
                              `amount` decimal(10,2) NOT NULL default '1.00',
                              KEY `shop_article_id` (`shop_article_id`),
                              KEY `date_added` (`date_added`)
                            ) ENGINE=MEMORY  DEFAULT CHARSET=utf8" ; MySqlLegacySupport :: getInstance ( ) -> query ( $ query ) ; reset ( $ aNoticeList ) ; foreach ( $ aNoticeList as $ iArticleId => $ oNoteItem ) { /** @var $oNoteItem TdbShopUserNoticeList */ $ query = "INSERT INTO `{$sTmpTableName}`
                  	                  SET `date_added` = '" . MySqlLegacySupport :: getInstance ( ) -> real_escape_string ( $ oNoteItem -> fieldDateAdded ) . "',
                  	                      `shop_article_id` = '" . MySqlLegacySupport :: getInstance ( ) -> real_escape_string ( $ oNoteItem -> fieldShopArticleId ) . "',
                  	                      `amount` = '" . MySqlLegacySupport :: getInstance ( ) -> real_escape_string ( $ oNoteItem -> fieldAmount ) . "'
                  	         " ; MySqlLegacySupport :: getInstance ( ) -> query ( $ query ) ; } return $ sTmpTableName ; }
Crete temp notice list table for guest users and
returns temp table name.

@param array $aNoticeList

@return string
Crete temp notice list table for guest users and returns temp table name .