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