magento 使用视图

最新推荐文章于 2017-11-05 11:20:34 发布

TerryWater

最新推荐文章于 2017-11-05 11:20:34 发布

阅读量1.2k

点赞数

CC 4.0 BY-SA版权

分类专栏： MAGENTO

本文链接：https://blog.youkuaiyun.com/terry_water/article/details/17223425

MAGENTO 专栏收录该内容

186 篇文章

订阅专栏

本文详细介绍了如何使用PHP代码创建MySQL视图，并通过配置文件实现与模型的集成，以便于后续操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysql文件代码：

<?php

$installer = $this;

$installer->startSetup();
try {
	$installer->run("

		CREATE
		VIEW `wailian_order_item` 
		AS
		(
		SELECT
		`a`.`item_id` AS `id`,
		`a`.`order_id` AS `order_id`,
		
		`a`.`product_options` AS `product_options`,
		`a`.`created_at` AS `created_at`,
		`a`.`product_id` AS `product_id`,
		`a`.`name` AS `name`,
		`a`.`qty_ordered` AS `qty`,
		`a`.`price` AS `price`,
		
		`b`.`status` AS `status`,
		`b`.`increment_id` AS `increment_id`
		FROM `sales_flat_order_item` `a`
		LEFT JOIN `sales_flat_order` `b`
		ON `a`.`order_id` = `b`.`entity_id`
		
		);
	
	
	");
} catch (Exception $e) {

}



$installer->endSetup();

配置文件代码：

<models>
      <wailian>
         <class>Lon_Wailian_Model</class>
         <resourceModel>wailian_mysql4</resourceModel>
      </wailian> 
       <wailian_mysql4>
                <class>Lon_Wailian_Model_Mysql4</class>
                <entities>
                    <item>
                        <table>wailian_order_item</table>
                    </item>
                 </entities>
        </wailian_mysql4>
    </models>

OK直接使用即可，用起来和对表的使用没有2样