/**
* Instantiate the table object
*
* @param string $table Param
* @param string $key Param
* @param JDatabase &$db The Joomla! database object
*/
public function __construct($table, $key, &$db)
{
parent::__construct('#__autotweet_automator', 'id', $db);
$this->xtform = new JRegistry();
$this->unix_mhdmd = null;
$this->repeat_until = null;
}
public function __construct($table, $key, &$db, $config = array())
{
$table = "#__j2store_productimages";
//important
$key = "j2store_productimage_id";
parent::__construct($table, $key, $db, $config);
}
/**
* Public constructor. Overrides the parent constructor, making sure there are lft/rgt columns which make it
* compatible with nested sets.
*
* @param string $table Name of the database table to model.
* @param string $key Name of the primary key field in the table.
* @param JDatabaseDriver &$db Database driver
* @param array $config The configuration parameters array
*
* @throws \RuntimeException When lft/rgt columns are not found
*/
public function __construct($table, $key, &$db, $config = array())
{
parent::__construct($table, $key, $db, $config);
if (!$this->hasField('lft') || !$this->hasField('rgt')) {
throw new \RuntimeException("Table " . $this->getTableName() . " is not compatible with F0FTableNested: it does not have lft/rgt columns");
}
}
public function __construct($table, $key, &$db, $config = array())
{
$table = "#__j2store_product_options";
$query = $db->getQuery(true)->select($db->qn('#__j2store_options') . '.option_name', $db->qn('#__j2store_options') . '.type')->leftJoin('#__j2store_options ON #__j2store_options.j2store_option_id = #__j2store_product_options.option_id');
$this->setQueryJoin($query);
parent::__construct($table, $key, $db, $config);
}
public function __construct($table, $key, &$db, $config = array())
{
parent::__construct($table, $key, $db, $config);
$this->addKnownField('_dontCheckPaymentID', false);
$this->addKnownField('_dontNotify', false);
$this->addKnownField('_noemail', false);
}
public function __construct($table, $key, &$db)
{
$table = '#__users';
$key = 'id';
$query = $db->getQuery(true)->select($db->qn('#__j2store_vendors') . '.j2store_vendor_id')->select($db->qn('#__j2store_vendors') . '.j2store_user_id')->select($db->qn('#__j2store_vendors') . '.address_id')->select($db->qn('#__j2store_addresses') . '.j2store_address_id')->select($db->qn('#__j2store_addresses') . '.first_name')->select($db->qn('#__j2store_addresses') . '.last_name')->select($db->qn('#__j2store_addresses') . '.address_1')->select($db->qn('#__j2store_addresses') . '.address_2')->select($db->qn('#__j2store_addresses') . '.user_id')->select($db->qn('#__j2store_addresses') . '.email')->select($db->qn('#__j2store_addresses') . '.city')->select($db->qn('#__j2store_addresses') . '.zip')->select($db->qn('#__j2store_addresses') . '.zone_id')->select($db->qn('#__j2store_addresses') . '.country_id')->select($db->qn('#__j2store_addresses') . '.phone_1')->select($db->qn('#__j2store_addresses') . '.phone_2')->select($db->qn('#__j2store_addresses') . '.fax')->select($db->qn('#__j2store_addresses') . '.type')->select($db->qn('#__j2store_addresses') . '.company')->select($db->qn('#__j2store_addresses') . '.tax_number')->select($db->qn('#__j2store_countries') . '.country_name')->select($db->qn('#__j2store_zones') . '.zone_name')->leftJoin('#__j2store_vendors ON #__j2store_vendors.j2store_user_id = #__users.id')->leftJoin('#__j2store_addresses ON #__j2store_addresses.j2store_address_id = #__j2store_vendors.address_id')->leftJoin('#__j2store_countries ON #__j2store_countries.j2store_country_id = #__j2store_addresses.country_id')->leftJoin('#__j2store_zones ON #__j2store_zones.j2store_zone_id = #__j2store_addresses.zone_id');
$this->setQueryJoin($query);
parent::__construct($table, $key, $db);
}
public function __construct($table, $key, &$db, $config = array())
{
$table = '#__j2store_addresses';
$key = 'j2store_address_id';
parent::__construct($table, $key, $db, $config);
$session = JFactory::getSession();
if ($session->has('is_vat_valid', 'j2store')) {
$vat_result = $session->get('is_vat_valid', 'invalid', 'j2store');
if (strtolower($vat_result == 'valid')) {
$this->set_is_vat_exempt(1);
}
}
}
public function __construct($table, $key, &$db)
{
$query = JFactory::getDbo()->getQuery(true);
$query->leftJoin('#__j2store_countries as billingcountry ON billingcountry.j2store_country_id = #__j2store_orderinfos.billing_country_id');
$query->select('billingcountry.country_name as billing_country_name');
$query->leftJoin('#__j2store_countries as shippingcountry ON shippingcountry.j2store_country_id = #__j2store_orderinfos.shipping_country_id');
$query->select('shippingcountry.country_name as shipping_country_name');
$query->leftJoin('#__j2store_zones as billingzone ON billingzone.j2store_zone_id = #__j2store_orderinfos.billing_zone_id');
$query->select('billingzone.zone_name as billing_zone_name');
$query->leftJoin('#__j2store_zones as shippingzone ON shippingzone.j2store_zone_id = #__j2store_orderinfos.shipping_zone_id');
$query->select('shippingzone.zone_name as shipping_zone_name');
$this->setQueryJoin($query);
parent::__construct($table, $key, $db);
}
public function __construct($table, $key, &$db, $config = array())
{
$query = $db->getQuery(true)->select($db->qn('#__j2store_productimages') . '.' . $db->qn('j2store_productimage_id'))->select($db->qn('#__j2store_productimages') . '.' . $db->qn('main_image'))->select($db->qn('#__j2store_productimages') . '.' . $db->qn('thumb_image'))->select($db->qn('#__j2store_productimages') . '.' . $db->qn('additional_images'))->join('LEFT OUTER', $db->qn('#__j2store_productimages') . ' ON ' . $db->qn('#__j2store_products') . '.' . $db->qn('j2store_product_id') . ' = ' . $db->qn('#__j2store_productimages') . '.' . $db->qn('product_id'));
//manufacturer
$query->join('LEFT OUTER', $db->qn('#__j2store_manufacturers') . ' ON ' . $db->qn('#__j2store_products') . '.' . $db->qn('manufacturer_id') . ' = ' . $db->qn('#__j2store_manufacturers.j2store_manufacturer_id'));
//vendors
$query->join('LEFT OUTER', $db->qn('#__j2store_vendors') . ' ON ' . $db->qn('#__j2store_products') . '.' . $db->qn('vendor_id') . ' = ' . $db->qn('#__j2store_vendors.j2store_vendor_id'));
//now join manufacturer address id with address table
$query->select($db->qn('#__j2store_addresses') . '.' . $db->qn('first_name') . ' AS manufacturer_first_name')->select($db->qn('#__j2store_addresses') . '.' . $db->qn('last_name') . ' AS manufacturer_last_name')->select($db->qn('#__j2store_addresses') . '.' . $db->qn('company') . ' AS manufacturer')->join('LEFT OUTER', $db->qn('#__j2store_addresses') . ' ON ' . $db->qn('#__j2store_manufacturers') . '.' . $db->qn('address_id') . ' = ' . $db->qn('#__j2store_addresses') . '.' . $db->qn('j2store_address_id'));
//now join vendor address id with address table
/* $query
->select('vendoraddress.first_name as vendor_first_name')
->select('vendoraddress.last_name as vendor_last_name')
->select('vendoraddress.company as vendor')
->join('LEFT_OUTER', '#__j2store_addresses AS vendoraddress ON #__j2store_vendors.address_id = vendoraddress.j2store_address_id'); */
$this->setQueryJoin($query);
parent::__construct($table, $key, $db, $config);
}
public function __construct($table, $key, &$db)
{
parent::__construct('#__admintools_badwords', 'id', $db);
}
public function __construct($table, $key, &$db)
{
parent::__construct('#__ak_stats', 'id', $db);
}
/**
* Instantiate the table object
*
* @param string $table Param
* @param string $key Param
* @param JDatabase &$db The Joomla! database object
*/
public function __construct($table, $key, &$db)
{
parent::__construct('#__content', 'id', $db, array('behaviors' => array('tags', 'autotweetcontentassets')));
$this->_columnAlias = array('enabled' => 'published', 'created_on' => 'created', 'modified_on' => 'modified', 'locked_on' => 'checked_out_time', 'locked_by' => 'checked_out');
$this->id = 0;
}
public function __construct($table, $key, &$db)
{
parent::__construct('#__admintools_wafblacklists', 'id', $db);
}
public function __construct($table, $key, &$db)
{
$table = "#__extensions";
$key = "extension_id";
parent::__construct($table, $key, $db);
}
/**
* Instantiate the table object
*
* @param string $table Param
* @param string $key Param
* @param JDatabase &$db The Joomla! database object
*/
public function __construct($table, $key, &$db)
{
parent::__construct('#__autotweet_requests', 'id', $db);
$this->_columnAlias = array('enabled' => 'published', 'created_on' => 'created', 'modified_on' => 'modified', 'locked_on' => 'checked_out_time', 'locked_by' => 'checked_out');
$this->_trackAssets = true;
}
public function __construct($table, $key, &$db, $config = array())
{
parent::__construct($table, $key, $db, $config);
$this->addKnownField('localformat', false);
}
public function __construct($table, $key, &$db, $config = array())
{
parent::__construct($table, $key, $db, $config = array());
}
public function __construct($table, $key, &$db, $config = array())
{
$query = $db->getQuery(true)->select($db->qn('#__j2store_productquantities') . '.j2store_productquantity_id ')->select($db->qn('#__j2store_productquantities') . '.quantity')->join('LEFT OUTER', '#__j2store_productquantities ON #__j2store_productquantities.variant_id = #__j2store_variants.j2store_variant_id')->select($db->qn('#__j2store_lengths') . '.length_title')->select($db->qn('#__j2store_lengths') . '.length_unit')->select($db->qn('#__j2store_lengths') . '.length_value')->join('LEFT OUTER', '#__j2store_lengths ON #__j2store_lengths.j2store_length_id = #__j2store_variants.length_class_id')->select($db->qn('#__j2store_weights') . '.weight_title')->select($db->qn('#__j2store_weights') . '.weight_unit')->select($db->qn('#__j2store_weights') . '.weight_value')->join('LEFT OUTER', '#__j2store_weights ON #__j2store_weights.j2store_weight_id = #__j2store_variants.weight_class_id');
$this->setQueryJoin($query);
parent::__construct($table, $key, $db, $config);
}
public function __construct($table, $key, &$db)
{
parent::__construct('#__admintools_ipautoban', 'ip', $db);
}
/**
* Class Constructor.
*
* @param string $table Name of the database table to model.
* @param string $key Name of the primary key field in the table.
* @param JDatabaseDriver &$db Database driver
* @param array $config The configuration parameters array
*/
public function __construct($table, $key, &$db, $config = array())
{
parent::__construct('#__j2store_orderitems', 'j2store_orderitem_id', $db);
}
/**
* Instantiate the table object
*
* @param string $table Param
* @param string $key Param
* @param JDatabase &$db The Joomla! database object
*/
public function __construct($table, $key, &$db)
{
parent::__construct('#__autotweet_feedarticles', 'id', $db);
$this->_columnAlias = array('enabled' => 'published', 'created_on' => 'created', 'modified_on' => 'modified', 'locked_on' => 'checked_out_time', 'locked_by' => 'checked_out');
$this->id = 0;
}
public function __construct($table, $key, &$db)
{
$table = '#__j2store_orders';
$key = 'j2store_order_id';
parent::__construct($table, $key, $db);
}
function __construct($table, $key, &$db)
{
$table = '#__akeebasubs_invoices';
$key = 'akeebasubs_subscription_id';
parent::__construct($table, $key, $db);
}
/**
* Instantiate the table object
*
* @param string $table Param
* @param string $key Param
* @param JDatabase &$db The Joomla! database object
*/
public function __construct($table, $key, &$db)
{
parent::__construct('#__autotweet_advanced_attrs', 'id', $db);
}
/**
* Instantiate the table object
*
* @param string $table Param
* @param string $key Param
* @param JDatabase &$db The Joomla! database object
*/
public function __construct($table, $key, &$db)
{
parent::__construct('#__extensions', 'extension_id', $db);
$this->_columnAlias = array('enabled' => 'state');
}
public function __construct($table, $key, &$db)
{
parent::__construct($table, $key, $db);
}
public function __construct($table, $key, &$db)
{
parent::__construct('#__admintools_customperms', 'id', $db);
}
function __construct($table, $key, &$db)
{
$table = '#__users';
$key = 'id';
parent::__construct($table, $key, $db);
}
public function __construct($table, $key, &$db)
{
$table = "#__j2store_productprice_index";
$key = "product_id";
parent::__construct($table, $key, $db);
}
public function __construct($table, $key, &$db)
{
$table = "#__j2store_product_optionvalues";
$key = "j2store_product_optionvalue_id";
parent::__construct($table, $key, $db);
}
