Magento 开发过程中常用的使用技巧与方法

今天药忘吃喽~ 2022-06-14 04:52 217阅读 0赞

资料来自网络，大部分没有经过验证，仅供参考：

1.属性Attribute 
 
 产品属性操作： 
 
 $product = Mage::getModel('catalog/product')->getCollection()->getFirstItem(); 
 
 foreach($product->getAttributes() as $att) { 
 
 $group_id = $att->getData('attribute_group_id'); 
 
 $group = Mage::getModel('eav/entity_attribute_group')->load($group_id); 
 
 var_dump($group); 
 
 } 
 
 $attrSetName = 'my_custom_attribute'; 
 
 $attributeSetId = Mage::getModel('eav/entity_attribute_set') ->load($attrSetName, 'attribute_set_name') ->getAttributeSetId(); 
 
 1.1 得到Product的属性id，即catalog_product_entity表的entity_type_id字段 
 
 $productAttributeSets = $this->getProductAttributeSets(); 
 
 1.2 前台页面获取商品属性 
 
 $_product->getResource()->getAttribute('cost')->getFrontend()->getValue($_product); 
 
 Magento的产品属性，在catalog.xml中已经写进去了。你可以在product view中找到 
 
 <block type="catalog/product_view_attributes" name="product.attributes" as="additional" template="catalog/product/view/attributes.phtml"> 
 
 <action method="addToParentGroup"><group>detailed_info</group></action> 
 
 </block> 
 
 现在只要在产品详细页（view.phtml）中想要的位置插入 
 
 <?php echo $this->getChildHtml('additional') ?> 
 
 1.3获取产品属性集 
 
 $sets = Mage::getResourceModel('eav/entity_attribute_set_collection') ->setEntityTypeFilter(Mage::getModel('catalog/product')->getResource()->getTypeId()) ->load() ->toOptionHash(); 
 
 1.4 加载某个attribute： 
 
 $attributeCode=Mage::getModel('catalog/resource_eav_attribute') ->load($attrbuteId) ->getData("attribute_code"); 
 
 1.5 获取所有的产品属性的attribute： 
 
 $attributes = Mage::getResourceModel ( 'catalog/product_attribute_collection' ) ->addFieldToFilter ( "frontend_input", "select" ) ->load (); 
 
 1.6 获取某个product的所有attribute： 
 
 注：如果是在 collection 中获取自定义的attribute，必须加 addAttributeToSelect(), 如下： 
 
 $product=Mage::getModel('catalog/product')->getCollection()->addAttributeToSelect("dropdownlistone") 
 
 1.7 获取某个种类的所有attribute： 
 
 $entityTypeId = Mage::getSingleton('eav/config') ->getEntityType('catalog_product') ->getEntityTypeId(); 
 
 $items = Mage::getResourceSingleton('catalog/product_attribute_collection') ->setEntityTypeFilter($entityTypeId) ->getItems(); 
 
 1.8 获取某个attribute的所有option： 
 
 $attributeObject=Mage::getModel('eav/config')->getAttribute('catalog_product')->load($attributeId); 
 
 $options = $attributeObject->setStoreId(Mage::app()->getStore()->getId())->getSource()->getAllOptions(false); 
 
 $table = $attributeObject->getBackend()->getTable(); 
 
 public function getAttributeOptionsByAttributeCode($entityType, $attributeCode){ 
 
 $entityType = Mage::getSingleton('eav/config')->getEntityType($entityType); 
 
 $attributeObject = Mage::getModel('customer/attribute')->loadByCode($entityType, $attributeCode); 
 
 return $attributeObject->setStoreId(Mage::app()->getStore()->getId())->getSource()->getAllOptions(false); 
 
 } 
 
 或者： 
 
 $optionCollection = Mage::getResourceModel('eav/entity_attribute_option_collection') ->setAttributeFilter($attr_model->getId()) ->setStoreFilter($storeId, false) ->load(); 
 
 1.9 获取某个attribute的所有多语言label： 
 
 $attributeLabelsArray= Mage::getResourceModel('eav/entity_attribute') ->getStoreLabelsByAttributeId($attrbuteId); 
 
 1.10 获取某个attribute_set的所有attribute： 
 
 $attributes = Mage::getResourceModel('catalog/product_attribute_collection') ->setAttributeSetFilter($attribute_set_id) ->load(); 
 
 $attributeSetCollection = Mage::getResourceModel('eav/entity_attribute_set_collection') ->load(); 
 
 1.11 获取attribute 对象 by attribute code 
 
 $muarqspFrom = Mage::getSingleton('eav/config')->getAttribute('catalog_product', ' muarqsp_from'); 
 
 $attrCollection = Mage::getResourceModel('eav/entity_attribute_collection') ->setCodeFilter($attributeCode) ->load() 
 
 1.12 通过attributeName得到 attributeSetId 
 
 Mage::getResourceModel('eav/entity_attribute_set_collection') ->addFieldToFilter('attribute_set_name',$attributSetName) ->getFirstItem()->getId(); 
 
 1.13 通过 attributeSetId得到attributeSetName 
 
 Mage::getModel('eav/entity_attribute_set') ->load($id)->getData("attribute_set_name"); 
 
 2. 产品相关操作 
 
 2.1 产品缩略图 
 
 $_thumb = Mage::helper('catalog/image')->init($product, 'thumbnail')->resize(50, 50)->setWatermarkSize('30x10'); 
 
 2.2 product collection 
 
 $collection = Mage::getResourceModel('catalog/product_collection') ->addStoreFilter() ->addAttributeToSelect("*") ->addAttributeToFilter('entity_id', array('in' => $products)) ->setPageSize(10) ->setCurPage(1); 
 
 2.3 删除一个product的所有的images//Get products gallery attribute 
 
 $attributes = $product->getTypeInstance()->getSetAttributes(); 
 
 if (isset($attributes['media_gallery'])) { 
 
 $gallery = $attributes['media_gallery']; 
 
 //Get the images 
 
 $galleryData = $product->getMediaGallery(); 
 
 foreach($galleryData['images'] as $image){ 
 
 //If image exists 
 
 if ($gallery->getBackend()->getImage($product, $image['file'])) { $gallery->getBackend()->removeImage($product, $image['file']); 
 
 $filename = Mage::getBaseDir('media') . DS . 'catalog'. DS .'product' . $image['file']; 
 
 debug('<< unlinked previous image '.$image['file'].' from product '.$product->getSku().''); 
 
 if (file_exists($filename) && is_file($filename) && is_writeable($filename)){ 
 
 @unlink($filename); 
 
 debug('(and deleted file '.$filename.')'); 
 
 }else 
 
 debug('(but couldn\'t delete file '.$filename.')'); 
 
 } 
 
 } 
 
 } 
 
 3. website 
 
 获取对象的方法:get_class_methods($object) 
 
 返回对象的类名:get_class($object) 
 
 3.1得到store id 
 
 $store_id=Mage::getModel('core/store') ->getCollection() ->addFieldToFilter ( "code", "france_fr" ) ->getFirstItem()->getData('store_id'); 
 
 or 
 
 Mage::getModel('core/store')->load('france_fr')->getId() 
 
 3.2 得到website config 
 
 //$website can be string or id 
 
 $import_type = Mage::getModel('core/website')->load($website)->getConfig('maps/stock_import/stock_limit'); 
 
 if( $import_type===false ){ 
 
 //get admin config 
 
 $import_type=Mage::getStoreConfig('maps/stock_import/import_type'，0); 
 
 } 
 
 获取后台的配置 
 
 Mage::getStoreConfig("clientnumber/total_config/service_ip",0); //get admin config 
 
 3.3 generate skin url 
 
 Mage::getDesign()->getSkinUrl('images/our_shops/shop_logo_default.jpg'); 
 
 3.4 generate select html 
 
 $html = $this->getLayout()->createBlock('core/html_select') ->setName($name) ->setId($id) ->setTitle(Mage::helper('directory')->__($title)) ->setClass('validate-select') ->setValue($defValue) ->setOptions($options) ->getHtml(); 
 
 3.5 获取这个网站所代表的国家的代号（如：FR） 
 
 Mage::getModel('directory/country') ->load(Mage::getStoreConfig('general/country/default'))->getIso2Code(), 
 
 3.6 获取登录的用户信息 
 
 Mage::getSingleton('customer/session')->getCustomer() 
 
 3.7 session,cookie 
 
 1) 获取session 
 
 $session = Mage::getSingleton('customer/session'); 
 
 2) session,cookie设置 
 
 (1) Model： 
 
 Mage::getModel(‘core/cookie’); Mage::getModel(‘core/session’); 
 
 (2)Set Method: 
 
 Mage::getSingleton(‘core/cookie’)->set(‘name’,'value’); Mage::getSingleton(‘core/session’)->set(‘name’,'value’); (3)Get method: Mage::getSingleton(‘core/cookie’)->get(‘name’); Mage::getSingleton(‘core/session’)->get(‘name’); 
 
 3.8 Request对象 
 
 Mage::app()->getRequest() 
 
 3.9 调用Model对象 
 
 Mage::getModel('infinity/model'); 
 
 3.10 输出配置文件 
 
 //header(‘Content-Type: text/xml’); 
 
 header(‘Content-Type: text/plain’); 
 
 echo $config = Mage::getConfig() ->loadModulesConfiguration(‘system.xml’) ->getNode() ->asXML(); 
 
 exit; 
 
 3.11 得到Magento分类的URL 
 
 Mage::getModel('catalog/category')->load(17)->getUrl(); 
 
 3.12 build your URL with valid keys 
 
 Mage::helper("adminhtml")->getUrl("mymodule/adminhtml_mycontroller/myaction/",array("param1"=>1,"param2"=>2)); 
 
 3.13 create key values 
 
 Mage::getSingleton('adminhtml/url')->getSecretKey("adminhtml_mycontroller","myaction"); 
 
 3.14 disable security feature in the admin panel 在管理面板中禁用安全功能 
 
 admin panel -> System -> Configuration -> Admin section: “Add Secret key to Urls”. 
 
 3.15 后台模块跳转： 
 
 Mage::app()->getResponse()->setRedirect(Mage::helper('adminhtml')->getUrl("adminhtml/promo_quote/index")); 3.16 get a drop down lists options for a mulit-select attribute 多属性选择下拉列表 $attribute = Mage::getModel('eav/config')->getAttribute('catalog_product', 'attribute_id'); 
 
 foreach ( $attribute->getSource()->getAllOptions(true, true) as $option) { $attributeArray[$option['value']] = $option['label']; } 3.17 获取栏目图片 public function getImageUrl($category) { return Mage::getModel('catalog/category')->load($category->getId())->getImageUrl(); 
 
 } 
 
 public function getThumbnailUrl($category) { 
 
 $image=Mage::getModel('catalog/category')->load($category->getId())->getThumbnail(); 
 
 if ($image) { 
 
 $url = Mage::getBaseUrl('media').'catalog/category/'.$image; 
 
 } 
 
 return $url; 
 
 } 
 
 3.18 判断是否首页：$this->getIsHomePage() 
 
 Mage::getSingleton('cms/page')->getIdentifier() == 'home' && Mage::app()->getFrontController()->getRequest()->getRouteName() == 'cms' ) 
 
 3.19 主题颜色 
 
 $attributes = $_product->getAttributes(); 
 
 $themeColor = $attributes['theme_color']->getFrontend()->getValue($_product); 
 
 3.20 获取configurable产品simple product 
 
 if($_product->getTypeId() == "configurable"): 
 
 $ids = $_product->getTypeInstance()->getUsedProductIds(); 
 
 foreach ($ids as $id) : 
 
 $simpleproduct = Mage::getModel('catalog/product')->load($id); 
 
 $simpleproduct->getName()." - ".(int)Mage::getModel('cataloginventory/stock_item')->loadByProduct($simpleproduct)->getQty(); 
 
 $childProducts = Mage::getModel('catalog/product_type_configurable')->getUsedProducts(null, $product); 
 
 endforeach； 
 
 endif； 
 
 3.21 get the attributes of Configurable Product. 
 
 $attributes = $product->getTypeInstance(true)->getConfigurableAttributes($product); 
 
 3.22 当前路径 
 
 $currentUrl = $this->helper('core/url')->getCurrentUrl(); 
 
 3.23 通过资源配置方式创建目录 
 
 $installer = $this; $installer->startSetup(); // make directory for font cache 
 
 try { 
 
 $domPdfFontCacheDir = join(DS, array('lib', 'Symmetrics', 'dompdf', 'fonts')); 
 
 $domPdfFontCacheDir = Mage::getBaseDir('var') . DS . $domPdfFontCacheDir; 
 
 if (!file_exists($domPdfFontCacheDir)) { 
 
 mkdir($domPdfFontCacheDir, 0777, true); 
 
 } 
 
 } catch(Exception $e) { 
 
 throw new Exception( 'Directory ' . $domPdfFontCacheDir . ' is not writable or couldn\'t be ' . 'created. Please do it manually.' . $e->getMessage() ); 
 
 } 
 
 $installer->endSetup(); 
 
 3.24 在controllers 实现跳转 
 
 Mage::app()->getFrontController() ->getResponse() ->setRedirect('http://your-url.com'); 
 
 ××××× 
 
 $cms_id = Mage::getSingleton('cms/page')->getIdentifier(); 
 
 $cms_title = Mage::getSingleton('cms/page')->getTitle(); 
 
 $cms_content = Mage::getSingleton('cms/page')->getContent(); 
 
 3.25 获取当前站点货币符号 
 
 $storeId = (int) $this->getRequest()->getParam('store', 0); 
 
 $store=Mage::app()->getStore($storeId); 
 
 $currencyCode=$store->getBaseCurrency()->getCode(); 
 
 $attribute = Mage::getModel('catalog/resource_eav_attribute')->load($attributeId); 
 
 $attributeData = $attribute->getData(); 
 
 $frontEndLabel = $attributeData['frontend_label']; 
 
 $attributeOptions = $attribute->getSource()->getAllOptions(); 
 
 3.26 设置meta信息 
 
 $template = Mage::getConfig()->getNode('global/page/layouts/'.Mage::getStoreConfig("featuredproducts/general/layout").'/template'); 
 
 this->loadLayout(); $this->getLayout()->getBlock('root')->setTemplate($template); 
 
 $this->getLayout()->getBlock('head')->setTitle($this->__(Mage::getStoreConfig("featuredproducts/general/meta_title"))); 
 
 $this->getLayout()->getBlock('head')->setDescription($this->__(Mage::getStoreConfig("featuredproducts/general/meta_description"))); 
 
 $this->getLayout()->getBlock('head')->setKeywords($this->__(Mage::getStoreConfig("featuredproducts/general/meta_keywords"))); 
 
 $this->renderLayout(); 
 
 4. 
 
 magento中调用static block(静态块)的几种方法 
 
 通常情况下，在magento程序中使用静态块用来创建广告、促销图片及静态的内容等等 
 
 以下以在magento中利用静态块来创建首页两侧的广告 
 
 在后台创建一个ad1静态块 
 
 (1)如果要在.phtml文件中直接调用这个静态块，那可以采用以下方法 
 
 <?php 
 
 $block = Mage::getModel(‘cms/block’) ->setStoreId(Mage::app()->getStore()->getId()) ->load(‘ad1′); 
 
 $content = $block->getContent(); // Block的原始内容已经获得 
 
 $processor = Mage::getModel(‘core/email_template_filter’); 
 
 echo $html = $processor->filter($content); 
 
 ?> 
 
 Mage::getModel(‘core/email_template_filter’)->filter()是必须的，因为Static Block里可能包含Magento的模板语言（如:{
 {store url=”"}}），fiter将翻译成实际的值 Magento中调用静态Block主要有两个地方。 是否感觉这代码太长了呢，那你还可以这么写 <?php echo $this->getLayout()->createBlock('cms/block')->setBlockId('order_form')->toHtml() ?> (2)在CMS页面的Content中调用这个静态块呢？你可以采用以下方法 { {block type=”cms/block” name=”cms_ad1_block” block_id=”ad1″ }} (3)在layout中调用静态块 <reference name=”footer”> <block type=”cms/block” name=”ad1″ before=”-”> <action method=”setBlockId”><block_id>ad1</block_id></action> </block> </reference> 5. 时间 5.1 获取当前的时间 1) $date = Mage::app()->getLocale()->date(Mage::getSingleton('core/date')->gmtTimestamp(), null, null); $date = $date->toString('yyyy-MM-dd hh:m:s'); 2) Mage::getModel('core/date')->date(); date("Y-m-d", Mage::getModel('core/date')->timestamp(time())); Magento中默认时区为GMT, 不能直接使用time(), date()等方法，否则会出现时间差。 用下面的方法取当前时间（和后台设置的时区一致）： date("Y-m-d", Mage::getModel('core/date')->timestamp(time())); 获得UTC时间的方法 $date = Mage::app()->getLocale()->utcDate($store, $value, true, Varien_Date::DATETIME_INTERNAL_FORMAT); $this->setData(‘date_start’, $date->toString(Varien_Date::DATETIME_INTERNAL_FORMAT)); $date = Mage::app()->getLocale()->date(); $dStr = $date->toString(Varien_Date::DATETIME_INTERNAL_FORMAT); //$dStr 可以用于存储到数据库的datetime字段. 5.2 格式化时间 Mage::app()->getLocale()->date($creditMemo->getCreatedAt())->toString('YYYY-MM-dd'); 或： $this->_filterDates($data, array('date_expires')); protected function _filterDates($array, $dateFields) { if (empty($dateFields)) { return $array; } $filterInput = new Zend_Filter_LocalizedToNormalized(array( 'date_format' => Mage::app()->getLocale()->getDateFormat(Mage_Core_Model_Locale::FORMAT_TYPE_SHORT) )); $filterInternal = new Zend_Filter_NormalizedToLocalized(array( 'date_format' => Varien_Date::DATE_INTERNAL_FORMAT )); foreach ($dateFields as $dateField) { if (array_key_exists($dateField, $array) && !empty($dateField)) { $array[$dateField] = $filterInput->filter($array[$dateField]); $array[$dateField] = $filterInternal->filter($array[$dateField]); } } return $array; } 5.3 加减日期 Mage::app()->getLocale()->date()->sub("3",Zend_Date::DAY)->toString('YYYY-MM-dd HH:mm:ss'); 5.4 日期过滤 $todayDate = Mage::app()->getLocale()->date()->toString(Varien_Date::DATETIME_INTERNAL_FORMAT); $this->_getProductCollection() ->addAttributeToFilter('news_from_date', array('or'=> array( 0 => array('date' => true, 'to' => $todayDate), 1 => array('is' => new Zend_Db_Expr('null'))) ), 'left') ->addAttributeToFilter('news_to_date', array('or'=> array( 0 => array('date' => true, 'from' => $todayDate), 1 => array('is' => new Zend_Db_Expr('null'))) ), 'left') ->addAttributeToFilter( array( array('attribute' => 'news_from_date', 'is'=>new Zend_Db_Expr('not null')), array('attribute' => 'news_to_date', 'is'=>new Zend_Db_Expr('not null')) ) ) ->addAttributeToFilter('visibility', array('in' => array(2, 4))) ->addAttributeToSort('news_from_date', 'desc') ->setPage(1, 4); 5.5 判断日期是否有效 Mage::app()->getLocale()->isStoreDateInInterval(Mage::app()->getStore(), $special_from_date, $special_to_date) 6. collection 6.1 在Configuation中添加validate <validate>validate-number</validate> 6.2 获取当前的controller $moduleName=Mage::app()->getRequest()->getModuleName(); $controllerName=Mage::app()->getRequest()->getControllerName(); $actionName=Mage::app()->getRequest()->getActionName(); $fullActionName=$moduleName."_".$controllerName."_".$actionName; 6.3 controller 中 添加block $this->getLayout() ->createBlock('clientnumber/inputform', 'checkout.cart.inputclientnumber') ->setTemplate('clientnumber/input.phtml') ->toHtml() 6.5添加breadcrumbs在 controller中(为前端页面添加面包屑,如 Category/product这里的导航 )： 在controller文件中填充面包屑数据，在block的phtml文件中显示 1). 在controller的Action方法中 //判断是否存在名字为breadcrumbs的Block（默认都存在，后面有说明） if ($breadcrumbsBlock = $this->getLayout()->getBlock('breadcrumbs')) { // 该条目有目标链接地址 $breadcrumbsBlock->addCrumb('category', array( 'label' => 'Category', 'title' => 'Category Title', 'link' => 'http://www.google.com', 'readonly' => true, )); // 该条目没有链接地址，一般作为最后一个条目 $breadcrumbsBlock->addCrumb('product', array('label' => Mage::helper('catalog')->__('Product'))); } 2). 在该action对应的Layout文件中添加Block Xml代码: <block type="page/html_breadcrumbs" name="breadcrumbs" as="breadcrumbs"/> 
 
 相应的在你的Block的合适位置输出面包屑 
 
 <?php echo $this->getChildHtml('breadcrumbs'); ?> 
 
 以上描述的是面包屑的一般原理，Magento实际上已经默认声明了Block 
 
 Xml代码: 
 
 <block type="page/html_breadcrumbs" name="breadcrumbs" as="breadcrumbs"/> 
 
 而且默认的几个layout模板文件(page/1column.phtml,page/2columns-left.phtml..等)已经做了 
 
 <?php echo $this->getChildHtml('breadcrumbs'); ?> 
 
 6.6 filter in collection 
 
 $collection = Mage::getModel('sales/order')->getCollection() ->addFieldToFilter('status', array('eq'=>'pending')) ->addFieldToFilter('created_at', array('datetime' => true, 'from'=>"2011-10-10 00:00:00",'to' => Mage::app()->getLocale()->date()->sub("3",Zend_Date::DAY)->toString('YYYY-MM-dd HH:mm:ss'))); 6.7 在controllers 实现跳转 Mage::app()->getFrontController() ->getResponse() ->setRedirect('http://your-url.com'); 
 
 7. 获取quote中的所有的item 
 
 $quote=Mage::getSingleton('checkout/session')->getQuote(); 
 
 foreach ($quote->getAllItems() as $item) { 
 
 $proId[]=$item->getProduct()->getId(); 
 
 } 
 
 8. 发送邮件 
 
 $mailTransport = new Zend_Mail_Transport_Smtp( '192.168.0.1' ); 
 
 $mail = new Zend_Mail(); 
 
 $mail->setBodyText($content); 
 
 $mail->setFrom("hello@example.com", 'Webmaster'); 
 
 $mail->addTo("bysoftgz@gmail.com", ''); 
 
 $mail->setSubject('Import attribute logs'); 
 
 $mail->send($mailTransport); 
 
 9. block 
 
 9.1 用block创建一个template 
 
 <?php echo Mage::getBlockSingleton('inseecode/form')->getInseeFormHtml($this->getAddress(), 'customer');?> 
 
 public function getInseeFormHtml($address, $type) { 
 
 $this->setTemplate('inseecode/form.phtml'); 
 
 return $this->toHtml(); 
 
 } 
 
 9.2 利用静态block 
 
 <?php echo $this->getLayout()->createBlock('clientnumber/widget_name') ->setObject($this->getAddress()) ->toHtml() 
 
 ?> 
 
 9.3 调用static block 
 
 1) 如果要在.phtml文件中直接调用这个静态块，那可以采用以下方法 
 
 <?php $block = Mage::getModel('cms/block') ->setStoreId(Mage::app()->getStore()->getId()) ->load('order_form'); 
 
 $content = $block->getContent(); // Block的原始内容已经获得 
 
 $processor = Mage::getModel('core/email_template_filter'); 
 
 echo $html = $processor->filter($content); 
 
 ?> 
 Mage::getModel(‘core/email_template_filter’)->filter()是必须的， 
 
 因为Static Block里可能包含Magento的模板语言（如:{
 {store url=”"}}），fiter将翻译成实际的值 Magento中调用静态Block主要有两个地方。 是否感觉这代码太长了呢，那你还可以这么写 <?php echo $this->getLayout()->createBlock(‘cms/block’)->setBlockId(‘order_form’)->toHtml() ?> 2) magento中的CMS功能,可以让我们很方便的在PHP中嵌入经常要更改的内容,这样我们可以通过在CMS中直接修改文章内容, 而不需要去修改源代码,最经典的就是我们的首页就是写在CMS Static block中的。 如何在CMS页面的Content中调用这个静态块呢？你可以采用以下方法 { {block type=”cms/block” name=”cms_test_block” block_id=”order_form” }} 将里面order_form改成你的静态块对应的block_id则可 3) 怎么样在layout中调用静态块呢？ <reference name=”footer”> <block type=”cms/block” name=”order_form” before=”-”> <action method=”setBlockId”><block_id>order_form</block_id></action> </block> </reference> magento中调用CMS静态块(Static Block)教程到此就结束了，你应该能够灵活的运用magento中的静态块了吧！ 10. 获取指定level目录 $parent = Mage::app()->getStore()->getRootCategoryId(); $categoryModel = Mage::getModel('catalog/category'); $storeCategories = $categoryModel->getCategories($parent, 2); //获取level 2 11. 数据库 11.1 修改数据库结构 $installer->getConnection()->addColumn( $installer->getTable('enterprise_giftcardaccount/giftcardaccount'), 'gift_card_type', "VARCHAR(200) DEFAULT ''"); $installer->getConnection()->addColumn( $installer->getTable('enterprise_giftcardaccount/giftcardaccount'), 'gift_card_type', "TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0'"); $installer->getConnection()->dropColumn($installer->getTable('eav_attribute'), 'use_in_super_product'); $installer->run("ALTER TABLE `sales_flat_order` CHANGE `is_synced` `is_synced` INT( 4 ) NOT NULL "); 11.2 magento操作数据库 eg.1 $this->getSelect() ->from(array('e' => $this->getEntity()->getFlatTableName()), null) ->columns(array('status' => new Zend_Db_Expr(Mage_Catalog_Model_Product_Status::STATUS_ENABLED))); $this->addAttributeToSelect(array('entity_id', 'type_id', 'attribute_set_id')); if ($this->getFlatHelper()->isAddChildData()) { $this->getSelect() ->where('e.is_child=?', 0); $this->addAttributeToSelect(array('child_id', 'is_child')); } $select=$this->getSelect()->from(array('e'=>$this->getEntity()->getEntityTable())); $select->joinRight( array('t'=>'test_product'), 'e.entity_id = t.entity_id', array() ); eg.2 $resource = Mage::getSingleton('core/resource'); $read= $resource->getConnection('read'); $tempTable = $resource->getTableName('eav_attribute'); //用其他表也是可以的 $wheres = "`entity_type_id` =4 "; //SELECT count(*) as num FROM `eav_attribute` WHERE (`entity_type_id` =4 ) //$select = $read->select() ->from($tempTable, array('count(*) as num')) ->where($wheres); //SELECT `eav_attribute`.* FROM `eav_attribute` WHERE (`entity_type_id` =4 ) //$select = $read->select() ->from($tempTable) ->where($wheres); //SELECT `eav_attribute`.`attribute_code` FROM `eav_attribute` WHERE (`entity_type_id` =4 ) $select = $read->select() ->from($tempTable, array('attribute_code')) ->where($wheres); $result = $read->fetchAll($select); eg.3 $resource = Mage::getSingleton('core/resource'); $read= $resource->getConnection('read'); $select = "select * from catalog_product_entity where entity_id =5"; $result = $read->fetchAll($select); //$result = $read->fetchOne($select); $instructors = array(); foreach($result as $item){ $instructors[$item['entity_id']] = array('position' => $item['sku']); } $dbw = Mage::getSingleton('core/resource')->getConnection('write'); $sql="update catalog_product_entity set sku='sku11' where entity_id=5"; $dbw->query( $sql ); magento--调用数据库的步骤--使用magento机制访问数据库 在后台附加一个属性，譬如品牌.然后，在产品详细页面，把同个品牌的产品都调用出来！下面是程序代码 public function getOtherProduct(){ $_producty = $this->getProduct(); $_biaoshi = $_producty['biaoshi']; $resource = Mage::getSingleton('core/resource'); $read = $resource->getConnection('catalog_read'); $categoryProductTable = $resource->getTableName('catalog/category_product'); //$productEntityIntTable = $resource->getTableName('catalog/product_entity_int'); // doesn't work $productEntityIntTable = (string)Mage::getConfig()->getTablePrefix().'catalog_product_entity_int'; $eavAttributeTable = $resource->getTableName('eav/attribute'); $product_attribute_valueTable = (string)Mage::getConfig()->getTablePrefix().'catalog_product_entity_varchar'; //return $product_attribute_valueTable; // var_dump($productEntityIntTable); exit; // Query database for featured product $select = $read->select() ->from(array('cp'=>$categoryProductTable)) // ->join(array('pei'=>$productEntityIntTable),'pei.entity_id=cp.product_id', array()) ->join(array('pss'=>$product_attribute_valueTable),'pss.entity_id=cp.product_id',array()) ->joinNatural(array('ea'=>$eavAttributeTable)) // ->joinNatural(array('pss'=>$product_attribute_valueTable)) // ->where('cp.category_id=?', $categoryId) ->where('pss.value=?',$_biaoshi) // ->where('ea.a') ->where('ea.attribute_code="biaoshi"'); $rows = $read->fetchAll($select); $ids = array(); foreach($rows AS $row) { $ids[] = $row['product_id']; } $ret = implode(',', $ids); $ids = array_unique($ids); // return $ids; $productList = array(); foreach($ids as $idq){ $product = Mage::getModel('catalog/product')->load($idq); $productList[] = $product; } // $product = Mage::getModel('catalog/product')->load($this->getProductId()); // $collection = Mage::getModel('catalog/product')->getCollection(); // $collection->getSelect()->where('e.entity_id in (?)', $ids); // $collection->addAttributeToSelect('*'); // $productList = $collection->load(); return $productList; // return $ids; } 如果你想成为一个magento二次开发程序员，上面的代码，你会感兴趣 12. 打印php调试信息的代码 $array = debug_backtrace(); //print_r($array);//信息很齐全 unset($array[0]); foreach($array as $row) { $html .= $row['file'].':'.$row['line'].'行,调用方法:'.$row['function'].""; } echo $html; exit(); 13. test code for quote $quote=Mage::getSingleton('checkout/session')->getQuote(); foreach ($quote->getAllVisibleItems() as $item) { echo $item->getProductId(); }