* @license GPL-2.0+
* @link https://arlo.co
* @copyright 2018 Arlo
*/
require_once 'class-arlo-for-wordpress-lists.php';
class Arlo_For_Wordpress_Templates extends Arlo_For_Wordpress_Lists {
const TABLENAME = 'arlo_eventtemplates';
public function __construct() {
$this->singular = __( 'Template', 'arlo-for-wordpress' );
$this->plural = __( 'Templates', 'arlo-for-wordpress' );
parent::__construct();
}
public function set_table_name() {
$this->table_name = $this->wpdb->prefix . self::TABLENAME . ' AS et';
}
public function get_columns() {
return $columns = [
'et_code' => __( 'Code', 'arlo-for-wordpress' ),
'et_name' => __( 'Name', 'arlo-for-wordpress' ),
'et_descriptionsummary' => __( 'Description', 'arlo-for-wordpress' ),
'et_registerinteresturi' => __( 'Register interest', 'arlo-for-wordpress' ),
'et_event_num' => __( 'Num. of events', 'arlo-for-wordpress' ),
'et_region' => __( 'Regions', 'arlo-for-wordpress' ),
];
}
public function get_hidden_columns() {
return array();
}
public function get_sortable_columns() {
return array(
'et_code' => array( 'et_code', true ),
'et_name' => array( 'et_name', true ),
'et_descriptionsummary' => array( 'et_descriptionsummary', true ),
'et_registerinteresturi' => array( 'et_registerinteresturi', true ),
'et_event_num' => array( 'et_event_num', true ),
);
}
public function column_default($item, $column_name) {
switch ($column_name) {
case 'et_code':
case 'et_region':
return esc_html($item->$column_name);
case 'et_name':
case 'et_descriptionsummary':
if (!empty($item->$column_name))
return '' . strip_tags($item->$column_name) . '
';
break;
case 'et_registerinteresturi':
if (!empty($item->$column_name))
return '' . __( 'Register interest', 'arlo-for-wordpress' ) . '';
break;
case 'et_event_num':
$retval = '0';
if (intval($item->$column_name) > 0)
$retval = '' . esc_html($item->$column_name) . '';
if (intval($item->oa_id) > 0) {
$retval .= ' / ' . __( 'OA', 'arlo-for-wordpress' ) . '';
}
return $retval;
default:
return '';
}
}
function column_et_code($item) {
$actions = array(
'edit' => sprintf('Edit', esc_url(sprintf("https://%s/management/Courses/Course.aspx?id=%d", $this->platform_url, $item->et_arlo_id))),
'view' => sprintf('View', $item->guid),
);
return sprintf('%1$s %2$s', esc_html($item->et_code), $this->row_actions($actions) );
}
protected function get_sql_where_array() {
return ["et.import_id = " . $this->import_id];
}
protected function get_searchable_fields() {
return [
'et.et_name',
'et.et_code',
'et.et_descriptionsummary',
];
}
public function get_sql_query() {
$where = $this->get_sql_where_expression();
return "
SELECT
guid,
et.et_arlo_id,
et.et_code,
et.et_name,
et.et_descriptionsummary,
et.et_registerinteresturi,
COUNT(DISTINCT e_arlo_id) AS et_event_num,
oa_id,
GROUP_CONCAT(DISTINCT et.et_region) AS et_region
FROM
" . $this->table_name . "
LEFT JOIN
" . $this->wpdb->prefix . "arlo_events AS e
ON
et.et_arlo_id = e.et_arlo_id
AND
et.et_region = e.e_region
AND
e_parent_arlo_id = 0
LEFT JOIN
" . $this->wpdb->prefix . "arlo_onlineactivities AS oa
ON
et.et_arlo_id = oat_arlo_id
LEFT JOIN
" . $this->wpdb->prefix . "posts
ON
ID = et_post_id
WHERE
" . $where . "
GROUP BY
et.et_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) );
}
}