/**
* @return bool
* @author Nicolas Juen
*/
private function getCampaigns()
{
/* @var $wpdb wpdb */
global $wpdb;
$cols = $wpdb->get_col("SELECT id FROM {$wpdb->bea_s_campaigns} WHERE current_status IN( '" . implode("','", Bea_Sender_Campaign::getAuthStatuses()) . "' ) AND scheduled_from <= '" . current_time('mysql') . "' ORDER BY add_date ASC");
$this->log->log_this(sprintf('%d campaigns to send', count($cols)));
if (!isset($cols) || empty($cols)) {
$this->campaigns = array();
return false;
}
$this->campaigns = array_map('absint', $cols);
return true;
}
/**
* @return string
* @author Nicolas Juen
*/
private static function get_status_filter()
{
global $wpdb;
return !isset($_GET['current_status']) || empty($_GET['current_status']) || !in_array($_GET['current_status'], Bea_Sender_Campaign::getAuthStatuses()) ? '' : $wpdb->prepare(' AND c.current_status = %s', $_GET['current_status']);
}
