/**
* Do query
*
* @since 1.1.0
*
* @access protected
*
* @param $wpdb
* @param $sql
*
* @return array
*/
protected static function query($wpdb, $sql)
{
$results = $wpdb->get_results($sql, ARRAY_A);
if (is_array($results)) {
return group::bulk_results($results);
}
return [];
}
/**
* Get all destination tests
*
* @since 1.1.0
*
* @param bool $ids Optional. If true, the ID of found groups is returned. If false, full group configs are returned
*
* @return array|null|object
*/
public static function get_destination_tests($ids = true)
{
global $wpdb;
if ($ids) {
$select = '`ID`';
} else {
$select = '*';
}
$tablename = group::get_table_name();
$sql = sprintf("SELECT %s FROM `%s` WHERE `type` = 'click' AND `sub_type` = 'destination'", $select, $tablename);
$results = $wpdb->get_results($sql, ARRAY_A);
if (!empty($results)) {
if ($ids) {
$results = wp_list_pluck($results, 'ID');
} else {
$results = group::bulk_results($results);
}
}
return $results;
}