public function __construct()
{
parent::__construct(Mage::getSingleton('core/resource')->getConnection('newsletter_read'));
$this->_templateTable = Mage::getSingleton('core/resource')->getTableName('newsletter/template');
$this->_select->from($this->_templateTable, array('template_id', 'template_code', 'template_type', 'template_subject', 'template_sender_name', 'template_sender_email', 'added_at', 'modified_at'));
$this->setItemObjectClass(Mage::getConfig()->getModelClassName('newsletter/template'));
}
public function __construct()
{
parent::__construct(Mage::getSingleton('core/resource')->getConnection('review_read'));
$this->_setIdFieldName('status_id');
$this->_reviewStatusTable = Mage::getSingleton('core/resource')->getTableName('review/review_status');
$this->_select->from($this->_reviewStatusTable);
}
public function __construct()
{
parent::__construct(AO::getSingleton('core/resource')->getConnection('admin_read'));
$this->_roleTable = AO::getSingleton('core/resource')->getTableName('admin/role');
$this->_select->from($this->_roleTable);
$this->setItemObjectClass(AO::getConfig()->getModelClassName('admin/acl_role'));
}
public function __construct()
{
parent::__construct(Mage::getSingleton('core/resource')->getConnection('directory_read'));
$this->_countryTable = Mage::getSingleton('core/resource')->getTableName('directory/country');
$this->_select->from(array('country' => $this->_countryTable));
$this->setItemObjectClass(Mage::getConfig()->getModelClassName('directory/country'));
}
/**
* Collection constructor
*
* @param Mage_Core_Model_Mysql4_Abstract $resource
*/
public function __construct($resource = null)
{
parent::__construct();
$this->_construct();
$this->setConnection($this->getEntity()->getReadConnection());
$this->_initSelect();
}
public function __construct()
{
parent::__construct(Mage::getSingleton('core/resource')->getConnection('rating_read'));
$this->_ratingOptionTable = Mage::getSingleton('core/resource')->getTableName('rating/rating_option');
$this->_ratingVoteTable = Mage::getSingleton('core/resource')->getTableName('rating/rating_vote');
$this->_select->from($this->_ratingOptionTable);
$this->setItemObjectClass(Mage::getConfig()->getModelClassName('rating/rating_option'));
}
public function __construct()
{
parent::__construct(Mage::getSingleton('core/resource')->getConnection('shipping_read'));
$this->_shipTable = Mage::getSingleton('core/resource')->getTableName('av5_correios_shipping/correios');
$this->_select->from(array("s" => $this->_shipTable))->order("valor");
$this->_setIdFieldName('id');
return $this;
}
public function __construct()
{
$resources = Mage::getSingleton('core/resource');
$this->_setIdFieldName('primary_id');
parent::__construct($resources->getConnection('review_read'));
$this->_summaryTable = $resources->getTableName('review/review_aggregate');
$this->_select->from($this->_summaryTable);
}
public function __construct()
{
$resources = Mage::getSingleton('core/resource');
parent::__construct($resources->getConnection('tag_read'));
$this->_usersTable = $resources->getTableName('admin/user');
$this->_roleTable = $resources->getTableName('admin/role');
$this->_ruleTable = $resources->getTableName('admin/rule');
}
public function __construct()
{
$resources = Mage::getSingleton('core/resource');
parent::__construct($resources->getConnection('livechat_read'));
$this->_livechatTable = $resources->getTableName('livechat/livechat');
$this->_select->from(array('livechat' => $this->_livechatTable), array('*'));
$this->setItemObjectClass(Mage::getConfig()->getModelClassName('livechat/livechat'));
}
public function __construct()
{
parent::__construct(Mage::getSingleton('core/resource')->getConnection('prescriptioncheckout_read'));
$this->_shipTable = Mage::getSingleton('core/resource')->getTableName('ecommage_prescription');
$this->_select->from(array("s" => $this->_shipTable))->order(array("prescription_id"));
$this->_setIdFieldName('prescription_id');
return $this;
}
public function __construct()
{
$resources = Mage::getSingleton('core/resource');
parent::__construct($resources->getConnection('approveorder_read'));
$this->_kitchenTable = $resources->getTableName('approveorder/kitchen');
$this->_select->from(array('e' => $this->_kitchenTable), array('*'));
$this->setItemObjectClass(Mage::getConfig()->getModelClassName('approveorder/kitchen'));
}
/**
* Constructor
*
* Configures collection
*/
public function __construct()
{
parent::__construct(Mage::getSingleton('core/resource')->getConnection('newsletter_read'));
$this->_subscriberTable = Mage::getSingleton('core/resource')->getTableName('newsletter/subscriber');
$this->_queueLinkTable = Mage::getSingleton('core/resource')->getTableName('newsletter/queue_link');
$this->_storeTable = Mage::getSingleton('core/resource')->getTableName('core/store');
$this->_select->from(array('main_table' => $this->_subscriberTable));
$this->setItemObjectClass(Mage::getConfig()->getModelClassName('newsletter/subscriber'));
}
public function __construct()
{
$resources = AO::getSingleton('core/resource');
$this->_setIdFieldName('primary_id');
parent::__construct($resources->getConnection('review_read'));
$this->_summaryTable = $resources->getTableName('review/review_aggregate');
$this->_select->from($this->_summaryTable);
$this->setItemObjectClass(AO::getConfig()->getModelClassName('review/review_summary'));
}
/**
* Enter description here ...
*
*/
public function __construct()
{
$resources = Mage::getSingleton('Mage_Core_Model_Resource');
$this->_setIdFieldName('primary_id');
parent::__construct($resources->getConnection('review_read'));
$this->_summaryTable = $resources->getTableName('review_entity_summary');
$this->_select->from($this->_summaryTable);
$this->setItemObjectClass(Mage::getConfig()->getModelClassName('Mage_Review_Model_Review_Summary'));
}
public function __construct($idFieldName = NULL)
{
$connRead = Mage::getResourceModel('core/config')->getReadConnection();
parent::__construct($connRead);
if (!is_null($idFieldName)) {
$this->_idFieldName = $idFieldName;
}
$table = Mage::getSingleton('core/resource')->getTableName('m2epro_ebay_dictionary_motor_ktype');
$this->getSelect()->reset()->from(array('main_table' => $table));
}
public function __construct()
{
parent::__construct(Mage::getSingleton('core/resource')->getConnection('shipping_read'));
$this->_shipTable = Mage::getSingleton('core/resource')->getTableName('matrixrate_shipping/matrixrate');
// $this->_countryTable = Mage::getSingleton('core/resource')->getTableName('directory/country');
// $this->_regionTable = Mage::getSingleton('core/resource')->getTableName('directory/country_region');
$this->_select->from(array("s" => $this->_shipTable))->order(array("zone"));
$this->_setIdFieldName('pk');
return $this;
}
public function __construct()
{
parent::__construct(Mage::getSingleton('core/resource')->getConnection('shipping_read'));
$this->_shipTable = Mage::getSingleton('core/resource')->getTableName('matrixrate_shipping/matrixrate');
$this->_countryTable = Mage::getSingleton('core/resource')->getTableName('directory/country');
$this->_regionTable = Mage::getSingleton('core/resource')->getTableName('directory/country_region');
$this->_select->from(array("s" => $this->_shipTable))->joinLeft(array("c" => $this->_countryTable), 'c.country_id = s.dest_country_id', 'iso3_code AS dest_country')->joinLeft(array("r" => $this->_regionTable), 'r.region_id = s.dest_region_id', 'code AS dest_region')->order(array("dest_country", "dest_region", "dest_zip"));
$this->_setIdFieldName('pk');
return $this;
}
public function __construct()
{
parent::__construct(Mage::getSingleton('core/resource')->getConnection('tag_read'));
$this->_roleTable = Mage::getSingleton('core/resource')->getTableName('admin/role');
$this->_userTable = Mage::getSingleton('core/resource')->getTableName('admin/user');
$this->_select->from($this->_userTable, array('*'))->where("user_id > 0");
$this->_setIdFieldName('user_id');
/*$this->_select->from($this->_roleTable, array('role_id', 'role_name', 'tree_level', 'sort_order', 'role_type'))
->joinLeft(array('usr' => $this->_userTable), "(usr.user_id = `{$this->_roleTable}`.user_id)", array('*'));
$this->_select->where("{$this->_roleTable}.role_type='U'");*/
}
public function __construct()
{
parent::__construct(Mage::getSingleton('core/resource')->getConnection('directory_read'));
$this->_countryTable = Mage::getSingleton('core/resource')->getTableName('directory/country');
$this->_regionTable = Mage::getSingleton('core/resource')->getTableName('directory/country_region');
$this->_regionNameTable = Mage::getSingleton('core/resource')->getTableName('directory/country_region_name');
$locale = Mage::app()->getLocale()->getLocaleCode();
$this->_select->from(array('region' => $this->_regionTable), array('region_id' => 'region_id', 'country_id' => 'country_id', 'code' => 'code', 'default_name' => 'default_name'));
$this->_select->joinLeft(array('rname' => $this->_regionNameTable), "region.region_id=rname.region_id AND rname.locale='{$locale}'", array('name'));
$this->setItemObjectClass(Mage::getConfig()->getModelClassName('directory/region'));
}
public function __construct()
{
$resources = Mage::getSingleton('core/resource');
parent::__construct($resources->getConnection('tag_read'));
$this->_usersTable = $resources->getTableName('admin/user');
$this->_roleTable = $resources->getTableName('admin/role');
$this->_ruleTable = $resources->getTableName('admin/rule');
$this->_select->from($this->_roleTable, '*');
$this->_select->where("{$this->_roleTable}.role_type='G'");
$this->_setIdFieldName('role_id');
}
public function __construct()
{
$resource = Mage::getSingleton('core/resource');
parent::__construct($resource->getConnection('directory_read'));
$this->_currencyTable = $resource->getTableName('directory/currency');
$this->_currencyNameTable = $resource->getTableName('directory/currency_name');
$this->_currencyRateTable = $resource->getTableName('directory/currency_rate');
$this->_select->from(array('main_table' => $this->_currencyNameTable));
/*$this->_select->join(array('name_table'=>$this->_currencyNameTable),
"main_table.currency_code=name_table.currency_code");*/
$this->setItemObjectClass(Mage::getConfig()->getModelClassName('directory/currency'));
}
public function __construct()
{
$resources = Mage::getSingleton('core/resource');
parent::__construct($resources->getConnection('review_read'));
$this->_reviewTable = $resources->getTableName('review/review');
$this->_reviewDetailTable = $resources->getTableName('review/review_detail');
$this->_reviewStatusTable = $resources->getTableName('review/review_status');
$this->_reviewEntityTable = $resources->getTableName('review/review_entity');
$this->_reviewStoreTable = $resources->getTableName('review/review_store');
$this->_select->from(array('main_table' => $this->_reviewTable))->join(array('detail' => $this->_reviewDetailTable), 'main_table.review_id=detail.review_id');
$this->setItemObjectClass(Mage::getConfig()->getModelClassName('review/review'));
}
/**
* Construct
*
*/
function __construct()
{
$resource = Mage::getSingleton('core/resource');
parent::__construct($resource->getConnection('log_read'));
$this->_visitorTable = $resource->getTableName('log/visitor');
$this->_visitorInfoTable = $resource->getTableName('log/visitor_info');
$this->_urlTable = $resource->getTableName('log/url_table');
$this->_urlInfoTable = $resource->getTableName('log/url_info_table');
$this->_customerTable = $resource->getTableName('log/customer');
$this->_summaryTable = $resource->getTableName('log/summary_table');
$this->_summaryTypeTable = $resource->getTableName('log/summary_type_table');
$this->_quoteTable = $resource->getTableName('log/quote_table');
$this->setItemObjectClass(Mage::getConfig()->getModelClassName('log/visitor'));
}
public function __construct()
{
$resources = Mage::getSingleton('core/resource');
parent::__construct($resources->getConnection('tag_read'));
$this->_usersTable = $resources->getTableName('admin/user');
$this->_roleTable = $resources->getTableName('admin/role');
$this->_ruleTable = $resources->getTableName('admin/rule');
/*
$this->_select->from($this->_tagTable, array('total' => "COUNT(*)", $this->_tagTable.'.*'))
->join($this->_tagRelTable, $this->_tagTable.'.tag_id='.$this->_tagRelTable.'.tag_id')
->group($this->_tagRelTable.'.tag_id');
$this->setItemObjectClass(Mage::getConfig()->getModelClassName('tag/tag'));
*/
$this->_select->from($this->_ruleTable);
$this->_setIdFieldName('rule_id');
}
public function inicializar()
{
parent::__construct(Mage::getSingleton('core/resource')->getConnection('mtshipping_read'));
}
public function __construct($conn = null)
{
parent::__construct($conn);
$this->setItemObjectClass('Mage_Eav_Model_Entity_Attribute_Backend_Gallery_Image');
}
public function __construct()
{
parent::__construct();
$this->setItemObjectClass('mzax_emarketing/object_collection_item');
}
