/** * 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); }