1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 | <?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); } } ?> |