/**
* @author Markus �hler
* @author Max Milbers
* @param JDataBase $db
*/
function __construct(&$db)
{
parent::__construct('#__virtuemart_shoppergroups', 'virtuemart_shoppergroup_id', $db);
$this->setUniqueName('shopper_group_name');
$this->setLoggable();
$this->setTableShortCut('sg');
}
/**
* @author Max Milbers
* @param $db A database connector object
*/
function __construct(&$db)
{
parent::__construct('#__virtuemart_currencies', 'virtuemart_currency_id', $db);
$this->setUniqueName('currency_name');
$this->setLoggable();
$this->setOrderable();
}
/**
* @author Max Milbers
* @param $db A database connector object
*/
function __construct(&$db)
{
parent::__construct('#__virtuemart_rating_votes', 'virtuemart_rating_vote_id', $db);
$this->setPrimaryKey('virtuemart_product_id');
// $this->setObligatoryKeys('vote');
$this->setLoggable();
}
/**
* @author Max Milbers
* @param JDataBase $db
*/
function __construct(&$db)
{
parent::__construct('#__virtuemart_rating_reviews', 'virtuemart_rating_review_id', $db);
$this->setPrimaryKey('virtuemart_rating_review_id');
$this->setObligatoryKeys('comment');
$this->setLoggable();
}
function __construct(&$db)
{
parent::__construct('#__virtuemart_calcs', 'virtuemart_calc_id', $db);
$this->setObligatoryKeys('calc_name');
$this->setObligatoryKeys('calc_kind');
$this->setLoggable();
}
/**
*
* @author Max Milbers
* @param $db Class constructor; connect to the database
*
*/
function __construct($db)
{
parent::__construct('#__virtuemart_invoices', 'virtuemart_invoice_id', $db);
$this->setUniqueName('invoice_number');
$this->setLoggable();
$this->setTableShortCut('inv');
}
/**
* @author Max Milbers
* @param JDataBase $db
*/
function __construct(&$db)
{
parent::__construct('#__virtuemart_manufacturercategories', 'virtuemart_manufacturercategories_id', $db);
$this->setUniqueName('mf_category_name');
$this->setLoggable();
$this->setTranslatable(array('mf_category_name', 'mf_category_desc'));
$this->setSlug('mf_category_name');
}
/**
* @author RickG
* @author Max Milbers
* @param JDataBase $db
*/
function __construct(&$db)
{
parent::__construct('#__virtuemart_states', 'virtuemart_state_id', $db);
$this->setUniqueName('state_name');
$this->setObligatoryKeys('state_2_code');
$this->setObligatoryKeys('state_3_code');
$this->setLoggable();
}
/**
* @author Patrick Kohl
* @param JDataBase $db
*/
function __construct(&$db)
{
parent::__construct('#__virtuemart_customs', 'virtuemart_custom_id', $db);
$this->setUniqueName('custom_title');
$this->setObligatoryKeys('field_type');
$this->setLoggable();
$this->setOrderable('ordering', false);
}
/**
* @author Max Milbers
* @param JDataBase $db
*/
function __construct(&$db)
{
parent::__construct('#__virtuemart_medias', 'virtuemart_media_id', $db);
//In a VmTable the primary key is the same as the _tbl_key and therefore not needed
// $this->setPrimaryKey('virtuemart_media_id');
// $this->setUniqueName('file_title');
$this->setLoggable();
}
/**
* @author Max Milbers
* @param $db A database connector object
*/
function __construct(&$db)
{
parent::__construct('#__virtuemart_product_customfields', 'virtuemart_customfield_id', $db);
$this->setPrimaryKey('virtuemart_product_id');
// $this->setSecondaryKey('virtuemart_customfield_id');
$this->setLoggable();
$this->setOrderable();
}
/**
* @param $db Class constructor; connect to the database
*/
function __construct(&$db)
{
parent::__construct('#__virtuemart_orderstates', 'virtuemart_orderstate_id', $db);
$this->setObligatoryKeys('order_status_code');
$this->setObligatoryKeys('order_status_name');
$this->setObligatoryKeys('order_stock_handle');
$this->setLoggable();
}
/**
* @author Max Milbers
* @param JDataBase $db
*/
function __construct(&$db)
{
parent::__construct('#__virtuemart_ratings', 'virtuemart_rating_id', $db);
//In a VmTable the primary key is the same as the _tbl_key and therefore not needed
$this->setPrimaryKey('virtuemart_rating_id');
// $this->setObligatoryKeys('virtuemart_product_id');
$this->setLoggable();
$this->setTableShortCut('r');
}
/**
* @author Max Milbers
* @param JDataBase $db
*/
function __construct(&$db)
{
parent::__construct('#__virtuemart_manufacturers', 'virtuemart_manufacturer_id', $db);
$this->setUniqueName('mf_name');
$this->setLoggable();
$this->setTranslatable(array('mf_name', 'mf_email', 'mf_desc', 'mf_url'));
$this->setSlug('mf_name');
$this->setTableShortCut('m');
}
/**
* @author Max Milbers
* @param $db A database connector object
*/
function __construct(&$db)
{
parent::__construct('#__virtuemart_countries', 'virtuemart_country_id', $db);
$this->setUniqueName('country_name');
$this->setObligatoryKeys('country_2_code');
$this->setObligatoryKeys('country_3_code');
$this->setLoggable();
$this->setOrderable('ordering', false);
}
/**
* @param $db Class constructor; connect to the database
*/
function __construct(&$db)
{
parent::__construct('#__virtuemart_userfields', 'virtuemart_userfield_id', $db);
parent::loadFields();
$this->setUniqueName('name');
$this->setObligatoryKeys('title');
$this->setLoggable();
$this->setOrderable('ordering', false);
}
/**
* @author Max Milbers
* @param JDataBase $db
*/
function __construct(&$db)
{
parent::__construct('#__virtuemart_paymentmethods', 'virtuemart_paymentmethod_id', $db);
$this->setObligatoryKeys('payment_jplugin_id');
$this->setObligatoryKeys('payment_name');
$this->setLoggable();
$this->setTranslatable(array('payment_name', 'payment_desc'));
$this->setSlug('payment_name');
// $this->setUniqueName('ordering');
}
/**
* @author Max Milbers
* @param $db A database connector object
*/
function __construct(&$db)
{
parent::__construct('#__virtuemart_shipmentmethods', 'virtuemart_shipmentmethod_id', $db);
// we can have several time the same shipment name. It is the vendor problem to set up correctly his shipment rate.
// $this->setUniqueName('shipment_name');
$this->setObligatoryKeys('shipment_jplugin_id');
$this->setObligatoryKeys('shipment_name');
$this->setLoggable();
$this->setTranslatable(array('shipment_name', 'shipment_desc'));
$this->setSlug('shipment_name');
}
/**
* @param $db Class constructor; connect to the database
*/
function __construct(&$db)
{
parent::__construct('#__virtuemart_userfields', 'virtuemart_userfield_id', $db);
parent::showFullColumns();
$this->setPrimaryKey('virtuemart_userfield_id');
$this->setUniqueName('name');
$this->setObligatoryKeys('title');
$this->setLoggable();
$this->setOrderable('ordering', false);
$this->_xParams = 'userfield_params';
}
/**
* Class contructor
*
* @author Max Milbers
* @param $db database connector object
*/
public function __construct($db)
{
parent::__construct('#__virtuemart_categories', 'virtuemart_category_id', $db);
//In a VmTable the primary key is the same as the _tbl_key and therefore not needed
// $this->setPrimaryKey('virtuemart_category_id');
$this->setObligatoryKeys('category_name');
$this->setLoggable();
$this->setTranslatable(array('category_name', 'category_description', 'metadesc', 'metakey', 'customtitle'));
$this->setSlug('category_name');
$this->setTableShortCut('c');
}
function __construct(&$db)
{
parent::__construct('#__virtuemart_shoppergroups', 'virtuemart_shoppergroup_id', $db);
$this->setUniqueName('shopper_group_name');
$this->setLoggable();
$this->setTableShortCut('sg');
$myfields = array('basePrice', 'variantModification', 'basePriceVariant', 'basePriceWithTax', 'basePriceWithTax', 'discountedPriceWithoutTax', 'salesPrice', 'priceWithoutTax', 'salesPriceWithDiscount', 'discountAmount', 'taxAmount', 'unitPrice');
$varsToPushParam = array('show_prices' => array(0, 'int'));
foreach ($myfields as $field) {
$varsToPushParam[$field] = array(1, 'int');
$varsToPushParam[$field . 'Text'] = array(1, 'int');
$varsToPushParam[$field . 'Rounding'] = array(-1, 'int');
}
$this->setParameterable('price_display', $varsToPushParam);
}
/**
*
* @author Max Milbers
* @param $db Class constructor; connect to the database
*
*/
function __construct($db)
{
parent::__construct('#__virtuemart_orders', 'virtuemart_order_id', $db);
$this->setUniqueName('order_number');
$this->setLoggable();
$this->setTableShortCut('o');
}
/**
* @param $db Class constructor; connect to the database
*/
function __construct(&$db)
{
parent::__construct('#__virtuemart_userfield_values', 'virtuemart_userfield_value_id', $db);
$this->setPrimaryKey('virtuemart_userfield_id');
}
/**
* @author RickG, Max Milbers
* @param JDataBase $db
*/
function __construct(&$db)
{
parent::__construct('#__virtuemart_coupons', 'virtuemart_coupon_id', $db);
$this->setObligatoryKeys('coupon_code');
$this->setLoggable();
}
/**
* @author Max Milbers
* @param $db A database connector object
*/
function __construct(&$db)
{
parent::__construct('#__virtuemart_worldzones', 'virtuemart_worldzone_id', $db);
$this->setUniqueName('zone_name');
$this->setLoggable();
}
function __construct(&$db)
{
parent::__construct('#__virtuemart_permgroups', 'virtuemart_permgroup_id', $db);
$this->setUniqueName('group_name');
$this->setLoggable();
}
/**
* @param $db Class constructor; connect to the database
*/
function __construct($db)
{
parent::__construct('#__virtuemart_order_histories', 'virtuemart_order_history_id', $db);
$this->setObligatoryKeys('virtuemart_order_id');
$this->setLoggable();
}
/**
* @param $db Class constructor; connect to the database
*/
function __construct($db)
{
parent::__construct('#__virtuemart_order_items', 'virtuemart_order_item_id', $db);
$this->setLoggable();
}
/**
* @author Max Milbers
* @param JDataBase $db
*/
function __construct(&$db)
{
parent::__construct('#__virtuemart_waitingusers', 'virtuemart_waitinguser_id', $db);
$this->setLoggable();
}
/**
* @author Max Milbers
* @param $db A database connector object
*/
function __construct($db)
{
parent::__construct('#__virtuemart_products', 'virtuemart_product_id', $db);
//In a VmTable the primary key is the same as the _tbl_key and therefore not needed
// $this->setPrimaryKey('virtuemart_product_id');
$this->setObligatoryKeys('product_name');
$this->setLoggable();
$this->setTranslatable(array('product_name', 'product_s_desc', 'product_desc', 'metadesc', 'metakey', 'customtitle'));
$this->setSlug('product_name');
$this->setTableShortCut('p');
//We could put into the params also the product_availability and the low_stock_notification
$varsToPushParam = array('min_order_level' => array(0.0, 'float'), 'max_order_level' => array(0.0, 'float'));
$this->setParameterable('product_params', $varsToPushParam);
}
