public function import(PerchMailChimp_List $List)
{
$Imports = new PerchMailChimp_Imports($this->api);
$Import = $Imports->create(['importType' => 'webhooks', 'importSourceID' => $List->id(), 'importCount' => 100, 'importOffset' => 0]);
if ($Import) {
$Import->run();
}
}
public function find_subscription(PerchMailChimp_List $List, PerchMailChimp_Subscriber $Subscriber)
{
$sql = 'SELECT * FROM ' . $this->table . '
WHERE listID=' . $this->db->pdb((int) $List->id()) . ' AND subscriberID=' . $this->db->pdb((int) $Subscriber->id());
return $this->return_instance($this->db->get_row($sql));
}
public function get_latest_for_list(PerchMailChimp_List $List)
{
$sql = 'SELECT *
FROM ' . $this->table . ' s
JOIN ' . PERCH_DB_PREFIX . 'mailchimp_subscriptions subs ON s.subscriberID=subs.subscriberID
WHERE
subs.subStatus=\'subscribed\'
AND subs.listID=' . $this->db->pdb((int) $List->id()) . '
AND subs.subCreated IS NOT NULL
ORDER BY subs.subCreated DESC
LIMIT 3';
return $this->return_instances($this->db->get_rows($sql));
}
