public function getQuery()
{
$query = parent::getQuery();
$query->addBinding('customer_id', 'entity_id');
$query->addBinding('email', 'email');
return $query;
}
public function getQuery()
{
$query = parent::getQuery();
$query->addBinding('order_id', 'order_id');
$query->addBinding('product_id', 'product_id');
$query->addBinding('order_item_id', 'item_id');
return $query;
}
public function getQuery()
{
$query = parent::getQuery();
$query->addBinding('customer_id', 'customer_id');
$query->addBinding('email', 'subscriber_email');
$query->addBinding('subscriber_status', 'subscriber_status');
return $query;
}
public function getQuery()
{
$query = parent::getQuery();
$query->addBinding('recipient_id', 'recipient_id');
$query->addBinding('recipient_sent_at', 'sent_at');
$query->addBinding('campaign_id', 'campaign_id');
$query->addBinding('variation_id', 'variation_id');
return $query;
}
public function getQuery()
{
$query = parent::getQuery();
$query->addBinding('store_id', 'store_id');
$query->addBinding('order_id', 'entity_id');
$query->addBinding('quote_id', 'quote_id');
$query->addBinding('ordered_at', 'created_at');
$query->addBinding('goal_time', 'created_at');
$query->addBinding('customer_id', 'customer_id');
$query->addBinding('email', 'customer_email');
return $query;
}
public function getQuery()
{
$query = parent::getQuery();
$query->where('`main_table`.`is_active` = 1');
$query->where('`main_table`.`items_count` > 0');
// @todo Should be medium ?
$query->where('`main_table`.`customer_email` > ""');
$query->addBinding('store_id', 'store_id');
$query->addBinding('quote_id', 'entity_id');
$query->addBinding('customer_id', 'customer_id');
$query->addBinding('email', 'customer_email');
return $query;
}
public function getQuery()
{
$query = parent::getQuery();
$query->addBinding('region', 'region');
$query->addBinding('country_id', 'country_id');
$query->addBinding('postcode', 'postcode');
$query->addBinding('street', 'street');
$query->addBinding('city', 'city');
$query->addBinding('telephone', 'telephone');
$query->addBinding('company', 'company');
$query->addBinding('firstname', 'firstname');
$query->addBinding('lastname', 'lastname');
$query->addBinding('email', 'email');
return $query;
}
public function getQuery()
{
$query = parent::getQuery();
$query->addBinding('product_id', $this->getIdFieldName());
return $query;
}
