osCommerce

osCommerce is a e-commerce community. More information can be found at:
http://www.oscommerce.org/

Triplify Configuration for osCommerce-2.2rc2a

<?php

include('../admin/includes/configure.php');

$triplify['db']=new PDO('mysql:host=' .DB_SERVER.
';dbname=' .DB_DATABASE,DB_SERVER_USERNAME,DB_SERVER_PASSWORD);

$triplify['namespaces']=array(
    'vocabulary'=>'http://triplify.org/vocabulary/oscommerce#',
    'rdf'=>'http://www.w3.org/1999/02/22-rdf-syntax-ns#',
    'rdfs'=>'http://www.w3.org/2000/01/rdf-schema#',
    'owl'=>'http://www.w3.org/2002/07/owl#',
    'foaf'=>'http://xmlns.com/foaf/0.1/',
    'sioc'=>'http://rdfs.org/sioc/ns#',
    'sioctypes'=>'http://rdfs.org/sioc/types#',
    'dc'=>'http://purl.org/dc/elements/1.1/',
    'dcterms'=>'http://purl.org/dc/terms/',
    'skos'=>'http://www.w3.org/2004/02/skos/core#',
    'xsd'=>'http://www.w3.org/2001/XMLSchema#',
    'osd'=>'http://triplify.org/vocabulary/oscommerce/currency/',
    'gr'=>'http://purl.org/goodrelations/v1#',
    'update'=>'http://triplify.org/vocabulary/update#',

);

$default_currency = $triplify['db']->query("SELECT configuration_id, configuration_value
                     FROM configuration
                     WHERE configuration_key = 'DEFAULT_CURRENCY'");
if($row=$default_currency->fetch()) {
     $currency=$row[1];
}else {
  echo "<!-- SQL Error ".mysql_error()." -->";
}

$triplify['queries']=array(

 'category'=>array( "SELECT categories_id id, parent_id AS 'sioc:has_parent',
                       date_added 'dcterms:created^^xsd:date',
                       last_modified 'dcterms:modified^^xsd:dateTime'
                       FROM categories" ,
                       "SELECT categories_id id, categories_name 'rdfs:label'
                       FROM categories_description"
                      ),

 'manufacturer'=>array("SELECT manufacturers_id id, manufacturers_name 'rdfs:label',
                         date_added 'dcterms:dateSubmitted^^xsd:dateTime',
                         last_modified 'dcterms:modified^^xsd:dateTime'
                         FROM manufacturers",
                         "SELECT manufacturers_id id, manufacturers_url 'foaf:homepage',
                         date_last_click 'dcterms:date^^xsd:date'
                         FROM manufacturers_info"
                         ),

 'product'=>array("SELECT products_id id, 
                   products_quantity  'vocabulary:num_Product^^xsd:integer',
                   products_model 'gr:hasMakeAndModel',
                   products_price 'vocabulary:price^^osd:$currency',
                   products_date_added 'dcterms:dateSubmitted^^xsd:date',
                   products_last_modified 'dcterms:modified^^xsd:dateTime',
                   products_date_available 'dcterms:issue^^xsd:date',
                   products_weight 'vocabulary:products_weight^^xsd:decimal',
                   products_tax_class_id 'sioc:has_container'
                   FROM products",
                   "SELECT products_id id, products_name 'rdfs:label',
                   products_description 'gr:description',
                   products_url 'foaf:homepage', products_viewed 'sioc:num_views'
                   FROM products_description",
                   "SELECT products_id id, categories_id 'sioc:has_container'
                   FROM products_to_categories"
                   ),
             
 'review'=>array("SELECT reviews_id id,products_id 'sioc:has_container',
                 reviews_rating 'vocabulary:reviews_rating^^xsd:integer',
                 date_added 'dcterms:date^^xsd:date'
                 FROM reviews",
                 "SELECT reviews_id id, reviews_text 'vocabulary:reviews_text'
                 FROM reviews_description"
                 ),

 'newsletter'=>"SELECT newsletters_id id, title 'rdfs:label',
                date_added 'dcterms:dateSubmitted^^xsd:dateTime',
                FROM newsletters",
                
 'special'=>"SELECT specials_id id, products_id 'sioc:has_container',
              specials_new_products_price 'vocabulary:price^^osd:$currency',
              specials_date_added 'dcterms:date^^xsd:date',
              specials_last_modified 'dcterms:modified^^xsd:dateTime',
              expires_date 'gr:validThrough^^xsd:dateTime'
              FROM specials",

 'tax'=>"SELECT tax_class_id id, tax_class_title 'rdfs:label',
         tax_class_description 'gr:description',
         last_modified 'dcterms:modified^^xsd:dateTime', date_added 'dcterms:date^^xsd:date'
         FROM tax_class",
         
 'update'=>"SELECT p.products_last_modified AS id,
            p.products_id 'update:updatedResource->product'
            FROM products p",
            "SELECT r.date_added AS id,
            r.reviews_id 'update:updatedResource->review'
            FROM reviews r",
            "SELECT s.specials_last_modified AS id,
            s.specials_id 'update:updatedResource->special'
            FROM specials s",

);

$triplify['objectProperties']=array(
    'sioc:has_parent'=>'category',
    'gr:hasMakeAndModel'=>'product',
    'gr:description'=>'product',
    'sioc:num_views'=>'product',
);        

$triplify['classMap']=array(

    'category'=>'skos:Concept',
    'manufacturer'=>'gr:BusinessEntity',
    'product'=>'gr:ActualProductOrServiceInstance',
    'review'=>'Review',
    'newsletter'=>'Newsletter',
    'special'=>'gr:Offering',
    'tax'=>'Tax',
    'update'=>'Update',
);

$triplify['license']= 'http://creativecommons.org/licenses/by/3.0/us/';

$triplify['register']=true;

$triplify['TTL']=0;

$triplify['LinkedDataDepth']='0';

?>


 
There are no files on this page. [Display files/form]
There is no comment on this page. [Display comments/form]

Information

Last Modification: 2008-11-03 23:59:52 by Elias Theodorou