db_obj->get_items();
$all_items = CBFunctions()->get_all_charts_count();
$chart_count_per_page = count($items) > 0 ? $all_items/$this->db_obj->get_pagination_count() : 0;
$chart_paged = isset($_GET['paged']) && $_GET['paged'] != '' ? absint( sanitize_text_field($_GET['paged'])) : '';
$search = $this->db_obj->get_search_value();
$chart_max_id = Chart_Builder_Admin::get_max_id('charts');
$this->settings_obj = new Chart_Builder_Settings_DB_Actions($this->plugin_name);
$chart_title_length = $this->settings_obj->get_listtables_title_length();
$filter_by_type = (isset($_GET['filterbytype']) && $_GET['filterbytype'] != "") ? intval(sanitize_text_field($_GET['filterbytype'])) : '';
$filter_by_source = (isset($_GET['filterbysource']) && $_GET['filterbysource'] != "") ? intval(sanitize_text_field($_GET['filterbysource'])) : '';
$filter_by_chart_source = (isset($_GET['filterbychartsource']) && $_GET['filterbychartsource'] != "") ? intval(sanitize_text_field($_GET['filterbychartsource'])) : '';
$filter_by_date = (isset($_GET['filterbydate']) && $_GET['filterbydate'] != "") ? sanitize_text_field($_GET['filterbydate']) : '';
$order_by = (isset($_GET['orderby']) && $_GET['orderby'] != "") ? sanitize_text_field($_GET['orderby']) : '';
$order = (isset($_GET['order']) && $_GET['order'] != "") ? sanitize_text_field($_GET['order']) : 'desc';
$chart_types = array(
"Line Chart",
"Bar Chart",
"Pie Chart",
"Column Chart",
"Org Chart",
"Donut Chart",
);
$chart_sources = array(
"Manual",
"Quiz Maker",
"File Import",
"Google Sheet",
"Database Query",
"Woocommerce",
);
$chart_source_types = array(
"Google Charts",
"Chart.js",
);
$chart_dates = array(
'today' => __("Today", "chart-builder"),
'yesterday' => __("Yesterday", "chart-builder"),
'last_week' => __("Last Week", "chart-builder"),
'last_month' => __("Last Month", "chart-builder"),
'last_year' => __("Last Year", "chart-builder"),
);
$order_by_values = array(
'title' => __("Title", "chart-builder"),
'date_created' => __("Date created", "chart-builder"),
'date_modified' => __("Date modified", "chart-builder"),
);
$order_values = array(
'asc' => __("Ascending", "chart-builder"),
'desc' => __("Descending", "chart-builder"),
);
$filter_by_author_data = $this->db_obj->get_searched_author_info();
$plus_icon_svg = "";
$youtube_icon_svg = "
";
?>