* @license GPL-2.0+
* @link https://arlo.co
* @copyright 2018 Arlo
*/
require_once 'class-arlo-for-wordpress-lists.php';
class Arlo_For_Wordpress_Sessions extends Arlo_For_Wordpress_Lists {
const TABLENAME = 'arlo_events';
public function __construct() {
$this->singular = __( 'Session', 'arlo-for-wordpress' );
$this->plural = __( 'Sessions', 'arlo-for-wordpress' );
parent::__construct();
}
public function set_table_name() {
$this->table_name = $this->wpdb->prefix . self::TABLENAME . ' AS es';
}
public function get_title() {
$title = parent::get_title();
$e_parent_id = filter_input(INPUT_GET, 'e_parent_id', FILTER_SANITIZE_STRING);
if (!empty($e_parent_id) && !empty(self::$filter_column_mapping['e_parent_id']) && intval($e_parent_id > 0) && !empty($this->items[0]->event_name)) {
$title .= ' for event: ' . $this->items[0]->event_name;
}
return $title;
}
public function get_columns() {
return $columns = [
'e_code' => __( 'Event code', 'arlo-for-wordpress' ),
'event_name' => __( 'Name', 'arlo-for-wordpress' ),
'e_startdatetime' => __( 'Start date', 'arlo-for-wordpress' ),
'e_finishdatetime' => __( 'Finish date', 'arlo-for-wordpress' ),
'v_name' => __( 'Venue name', 'arlo-for-wordpress' ),
'et_descriptionsummary,' => __( 'Summary', 'arlo-for-wordpress' ),
'e_sessiondescription' => __( 'Description', 'arlo-for-wordpress' ),
'e_region' => __( 'Regions', 'arlo-for-wordpress' ),
];
}
public function get_hidden_columns() {
return array();
}
public function get_sortable_columns() {
return array(
'e_code' => array( 'e_code', true ),
'e_startdatetime' => array( 'e_startdatetime', true ),
'e_finishdatetime' => array( 'e_finishdatetime', true ),
'v_name' => array( 'v_name', true ),
'e_locationname' => array( 'e_locationname', true ),
'e_placesremaining' => array( 'e_placesremaining', true ),
'et_descriptionsummary' => array( 'et_descriptionsummary', true ),
'e_sessiondescription' => array( 'e_sessiondescription', true ),
);
}
public function column_default($item, $column_name) {
switch ($column_name) {
case 'e_code':
case 'e_locationname':
case 'e_placesremaining':
case 'e_region':
return esc_html($item->$column_name);
case 'et_descriptionsummary':
case 'e_sessiondescription':
if (!empty($item->$column_name))
return '' . strip_tags($item->$column_name) . '
';
break;
case 'e_startdatetime':
case 'e_finishdatetime':
return esc_html($item->$column_name . " " . $item->e_timezone);
break;
case 'v_name':
$field = '';
if (!empty($item->$column_name)) {
$field = '';
}
if (!empty($item->e_locationname)) {
$field .= '' . esc_html($item->e_locationname) . (!empty($item->e_locationroomname) ? ' (' . esc_html($item->e_locationroomname) . ')' : '') . '
';
} elseif (!empty($item->e_locationroomname)) {
$field .= '' . esc_html($item->e_locationroomname) . '
';
}
return $field;
case 'event_name':
return '' . esc_html($item->e_name) . '
' . esc_html($item->event_name) . '
';
case 'e_register':
if (!empty($item->e_registeruri))
return '' . strip_tags($item->e_registermessage) . '';
break;
default:
return '';
}
}
public function column_e_code($item) {
$actions = array(
'edit' => sprintf('Edit', esc_attr($this->platform_url), $item->e_parent_arlo_id)
);
return sprintf('%1$s %2$s', esc_html($item->e_code), $this->row_actions($actions) );
}
protected function get_sql_where_array() {
return [
"es.import_id = " . $this->import_id,
"es.e_parent_arlo_id != 0"
];
}
protected function get_searchable_fields() {
return [
'e.e_name',
'es.e_code',
'es.e_name',
'es.e_locationname',
'es.e_locationroomname',
];
}
public function get_sql_query() {
$where = $this->get_sql_where_expression();
return "
SELECT
e.e_name AS event_name,
es.e_parent_arlo_id,
es.e_arlo_id,
es.e_code,
es.e_name,
es.e_startdatetime,
es.e_finishdatetime,
es.e_timezone,
v.v_name,
es.e_locationname,
es.e_locationroomname,
es.e_isfull,
es.e_placesremaining,
et.et_descriptionsummary,
es.e_sessiondescription,
GROUP_CONCAT(DISTINCT es.e_region) as e_region
FROM
" . $this->table_name . "
LEFT JOIN
" . $this->wpdb->prefix . "arlo_events AS e
ON
es.e_parent_arlo_id = e.e_arlo_id
LEFT JOIN
" . $this->wpdb->prefix . "arlo_eventtemplates AS et
ON
e.et_arlo_id = et.et_arlo_id
LEFT JOIN
" . $this->wpdb->prefix . "arlo_venues AS v
ON
es.v_id = v_arlo_id
WHERE
" . $where . "
GROUP BY
es.e_arlo_id
";
}
public function get_new_link() {
return esc_url(sprintf('https://%s/management/Console/#/events/new/', $this->platform_url) );
}
public function get_list_link() {
return esc_url(sprintf('https://%s/management/Courses/Courses2.aspx', $this->platform_url) );
}
}