|
<?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 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_transaction_fact extends owa_entity { |
|
|
|
function __construct() { |
|
|
|
$this->setTableName('commerce_transaction_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); |
|
|
|
$referer_id = new owa_dbColumn('referer_id', OWA_DTD_BIGINT); |
|
$referer_id->setForeignKey('base.referer'); |
|
$this->setProperty($referer_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); |
|
|
|
$order_source = new owa_dbColumn('order_source', OWA_DTD_VARCHAR255); |
|
$this->setProperty($order_source); |
|
|
|
$gateway = new owa_dbColumn('gateway', OWA_DTD_VARCHAR255); |
|
$this->setProperty($gateway); |
|
|
|
$total = new owa_dbColumn('total_revenue', OWA_DTD_BIGINT); |
|
$this->setProperty($total); |
|
|
|
$tax = new owa_dbColumn('tax_revenue', OWA_DTD_BIGINT); |
|
$this->setProperty($tax); |
|
|
|
$shipping = new owa_dbColumn('shipping_revenue', OWA_DTD_BIGINT); |
|
$this->setProperty($shipping); |
|
|
|
$days_since_first_session = new owa_dbColumn('days_since_first_session', OWA_DTD_INT); |
|
$this->setProperty($days_since_first_session); |
|
|
|
$nps = new owa_dbColumn('num_prior_sessions', OWA_DTD_INT); |
|
$this->setProperty($nps); |
|
} |
|
} |
|
|
|
?> |