--- a/busui/owa/modules/base/entities/commerce_line_item_fact.php +++ b/busui/owa/modules/base/entities/commerce_line_item_fact.php @@ -1,1 +1,123 @@ - +<?php + +// +// Open Web Analytics - An Open Source Web Analytics Framework +// +// Copyright 2006 Peter Adams. All rights reserved. +// +// Licensed under GPL v2.0 http://www.gnu.org/copyleft/gpl.html +// +// Unless required by applicable law or agreed to in writing, software +// distributed under the License is distributed on an "AS IS" BASIS, +// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. +// See the License for the specific language governing permissions and +// limitations under the License. +// +// $Id$ +// + +/** + * Commerce Transaction Line Item Fact Entity + * + * @author Peter Adams <peter@openwebanalytics.com> + * @copyright Copyright © 2006 Peter Adams <peter@openwebanalytics.com> + * @license http://www.gnu.org/copyleft/gpl.html GPL v2.0 + * @category owa + * @package owa + * @version $Revision$ + * @since owa 1.4.0 + */ + +class owa_commerce_line_item_fact extends owa_entity { + + function __construct() { + + $this->setTableName('commerce_line_item_fact'); + + $id = new owa_dbColumn('id', OWA_DTD_BIGINT); + $id->setPrimaryKey(); + $this->setProperty($id); + + $visitor_id = new owa_dbColumn('visitor_id', OWA_DTD_BIGINT); + $visitor_id->setForeignKey('base.visitor'); + $this->setProperty($visitor_id); + + $session_id = new owa_dbColumn('session_id', OWA_DTD_BIGINT); + $session_id->setForeignKey('base.session'); + $this->setProperty($session_id); + + $document_id = new owa_dbColumn('document_id', OWA_DTD_BIGINT); + $document_id->setForeignKey('base.document'); + $this->setProperty($document_id); + + $site_id = new owa_dbColumn('site_id', OWA_DTD_VARCHAR255); + $site_id->setForeignKey('base.site', 'site_id'); + $this->setProperty($site_id); + + $ua_id = new owa_dbColumn('ua_id', OWA_DTD_BIGINT); + $ua_id->setForeignKey('base.ua'); + $this->setProperty($ua_id); + + $host_id = new owa_dbColumn('host_id', OWA_DTD_BIGINT); + $host_id->setForeignKey('base.host'); + $this->setProperty($host_id); + + $os_id = new owa_dbColumn('os_id', OWA_DTD_BIGINT); + $os_id->setForeignKey('base.os'); + $this->setProperty($os_id); + + $location_id = new owa_dbColumn('location_id', OWA_DTD_BIGINT); + $location_id->setForeignKey('base.location_dim'); + $this->setProperty($location_id); + + $medium = new owa_dbColumn('medium',OWA_DTD_VARCHAR255); + $this->setProperty($medium); + + $source_id = new owa_dbColumn('source_id', OWA_DTD_BIGINT); + $source_id->setForeignKey('base.source_dim'); + $this->setProperty($source_id); + + $ad_id = new owa_dbColumn('ad_id', OWA_DTD_BIGINT); + $ad_id->setForeignKey('base.ad_dim'); + $this->setProperty($ad_id); + + $campaign_id = new owa_dbColumn('campaign_id', OWA_DTD_BIGINT); + $campaign_id->setForeignKey('base.campaign_dim'); + $this->setProperty($campaign_id); + + $referring_search_term_id = new owa_dbColumn('referring_search_term_id', OWA_DTD_BIGINT); + $referring_search_term_id->setForeignKey('base.search_term_dim'); + $this->setProperty($referring_search_term_id); + + $timestamp = new owa_dbColumn('timestamp', OWA_DTD_INT); + $this->setProperty($timestamp); + + $yyyymmdd = new owa_dbColumn('yyyymmdd', OWA_DTD_INT); + $this->setProperty($yyyymmdd); + + $order_id = new owa_dbColumn('order_id', OWA_DTD_VARCHAR255); + $order_id->setIndex(); + $this->setProperty($order_id); + + $sku = new owa_dbColumn('sku', OWA_DTD_VARCHAR255); + $this->setProperty($sku); + + $product_name = new owa_dbColumn('product_name', OWA_DTD_VARCHAR255); + $this->setProperty($product_name); + + $category = new owa_dbColumn('category', OWA_DTD_VARCHAR255); + $this->setProperty($category); + + $unit_price = new owa_dbColumn('unit_price', OWA_DTD_BIGINT); + $this->setProperty($unit_price); + + $quantity = new owa_dbColumn('quantity', OWA_DTD_INT); + $this->setProperty($quantity); + + $item_revenue = new owa_dbColumn('item_revenue', OWA_DTD_BIGINT); + $this->setProperty($item_revenue); + + } +} + +?>