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; }