$pagination->set_css_style('widefat-pagination.css'); $pagination->set_pagination_tpl_path($wpbi_url['tpl']); $pagination->set_pagination_stats($wpbi_dialog['table']['pagination']['stats']); $pagination->set_paginate_links(paginate_links(array('base' => esc_url(add_query_arg($pagination->pg_parameter, '%#%')), 'format' => '', 'prev_text' => __($wpbi_dialog['table']['pagination']['prev_text']), 'next_text' => __($wpbi_dialog['table']['pagination']['next_text']), 'total' => ceil($pagination->rows / $pagination->pg_interval), 'current' => $pagination->current_page))); $pagination->initialize(); echo $pagination->get_html(); //END page navigation //Execute query limitng the resultset $qy_queries_rows = $wpdb->get_results($query->limit_qy_to($pagination->item_start - 1, $pagination->pg_interval), 'ARRAY_N'); //Output table $column_headers = array($wpbi_dialog['header']['queries']['id'], $wpbi_dialog['header']['queries']['name'], $wpbi_dialog['header']['queries']['database'], $wpbi_dialog['header']['queries']['statement']); $single_actions = array("edit" => array("label" => $wpbi_dialog['action']['label']['edit'], "page" => $wpbi_url['slug']['queries'], "action" => $wpbi_settings['value']['edit'], "parameter" => $wpbi_settings['parameter']['qy_id']), "copy" => array("label" => $wpbi_dialog['action']['label']['copy'], "page" => $wpbi_url['slug']['queries'], "action" => $wpbi_settings['value']['copy'], "parameter" => $wpbi_settings['parameter']['qy_id']), "test" => array("label" => $wpbi_dialog['action']['label']['test'], "page" => $wpbi_url['slug']['queries'], "action" => $wpbi_settings['value']['test'], "parameter" => $wpbi_settings['parameter']['qy_id']), "drop" => array("label" => $wpbi_dialog['action']['label']['drop'], "page" => $wpbi_url['slug']['queries'], "action" => $wpbi_settings['value']['drop'], "parameter" => $wpbi_settings['parameter']['qy_id'])); $global_actions = array("drop" => array("label" => $wpbi_dialog['button']['label']['drop'], "value" => $wpbi_settings['value']['drop'])); $table_form = new table_form(); $table_form->set_css_class('widefat post fixed'); $table_form->set_rows($qy_queries_rows); $table_form->set_cols($column_headers); $table_form->has_header(true); $table_form->has_footer(true); $table_form->encode_html(true); $table_form->set_single_actions($single_actions); $table_form->set_global_actions($global_actions); $table_form->set_gobal_checkbox_id('post_all'); $table_form->set_form_action(''); $table_form->set_form_id('manage_queries'); $table_form->set_form_method('post'); echo $table_form->get_html(); } // END Condition of user testing new query //output page footer $template_site->pparse('footer');
$pagination->set_rows($total_rows); $pagination->set_css_class('widefat post fixed'); $pagination->set_pagination_stats($wpbi_dialog['table']['pagination']['stats']); $pagination->set_paginate_links(paginate_links(array('base' => esc_url(add_query_arg($pagination->pg_parameter, '%#%')), 'format' => '', 'prev_text' => __($wpbi_dialog['table']['pagination']['prev_text']), 'next_text' => __($wpbi_dialog['table']['pagination']['next_text']), 'total' => ceil($pagination->rows / $pagination->pg_interval), 'current' => $pagination->current_page))); $pagination->initialize(); echo $pagination->get_html(); //END page navigation //Execute query limitng the resultset $qy_variables_rows = $wpdb->get_results($query->limit_qy_to($pagination->item_start - 1, $pagination->pg_interval), 'ARRAY_N'); //Output table $column_headers = array('ID', $wpbi_dialog['header']['variables']['name'], $wpbi_dialog['header']['variables']['value']); $single_actions = array("edit" => array("label" => "Edit", "page" => $wpbi_url['slug']['variables'], "action" => $wpbi_settings['value']['edit'], "parameter" => $wpbi_settings['parameter']['var_id']), "drop" => array("label" => "Drop", "page" => $wpbi_url['slug']['variables'], "action" => $wpbi_settings['value']['drop'], "parameter" => $wpbi_settings['parameter']['var_id'])); $global_actions = array("drop" => array("label" => "Drop", "value" => $wpbi_settings['value']['drop'])); $table_form = new table_form(); $table_form->set_css_class('widefat post fixed'); $table_form->set_rows($qy_variables_rows); $table_form->set_cols($column_headers); $table_form->has_header(true); $table_form->has_footer(true); $table_form->encode_html(true); $table_form->set_single_actions($single_actions); $table_form->set_global_actions($global_actions); $table_form->set_gobal_checkbox_id('post_all'); $table_form->set_form_action(substr(substr(strrchr($_SERVER['REQUEST_URI'], '/'), 1), 0, strpos(substr(strrchr($_SERVER['REQUEST_URI'], '/'), 1), '&'))); $table_form->set_form_id('manage_queries'); $table_form->set_form_method('post'); echo $table_form->get_html(); } //End condition about edit action //output page footer $template_site->pparse('footer');
$pagination->set_pagination_stats($wpbi_dialog['table']['pagination']['stats']); $pagination->set_paginate_links(paginate_links(array('base' => esc_url(add_query_arg($pagination->pg_parameter, '%#%')), 'format' => '', 'prev_text' => __($wpbi_dialog['table']['pagination']['prev_text']), 'next_text' => __($wpbi_dialog['table']['pagination']['next_text']), 'total' => ceil($pagination->rows / $pagination->pg_interval), 'current' => $pagination->current_page))); $pagination->initialize(); echo $pagination->get_html(); //END page navigation //Execute query limitng the resultset $qy_charts_rows = $wpdb->get_results($query->limit_qy_to($pagination->item_start - 1, $pagination->pg_interval), 'ARRAY_N'); //Get saved queries $wpbi_chart = new chart($qy_charts_rows); //Output table $column_headers = array($wpbi_dialog['header']['charts']['id'], $wpbi_dialog['header']['charts']['name'], $wpbi_dialog['header']['charts']['type'], $wpbi_dialog['header']['charts']['query'], $wpbi_dialog['header']['queries']['statement']); $single_actions = array("edit" => array("label" => $wpbi_dialog['action']['label']['edit'], "page" => $wpbi_url['slug']['charts'], "action" => $wpbi_settings['value']['edit'], "parameter" => $wpbi_settings['parameter']['ch-id']), "copy" => array("label" => $wpbi_dialog['action']['label']['copy'], "page" => $wpbi_url['slug']['charts'], "action" => $wpbi_settings['value']['copy'], "parameter" => $wpbi_settings['parameter']['ch-id']), "test" => array("label" => $wpbi_dialog['action']['label']['test'], "page" => $wpbi_url['slug']['charts'], "action" => $wpbi_settings['value']['test'], "parameter" => $wpbi_settings['parameter']['ch-id']), "drop" => array("label" => $wpbi_dialog['action']['label']['drop'], "page" => $wpbi_url['slug']['charts'], "action" => $wpbi_settings['value']['drop'], "parameter" => $wpbi_settings['parameter']['ch-id'])); $global_actions = array("drop" => array("label" => $wpbi_dialog['button']['label']['drop'], "value" => $wpbi_settings['value']['drop'])); $table_form = new table_form(); $table_form->set_css_class('widefat post fixed'); $table_form->set_rows($qy_charts_rows); $table_form->set_cols($column_headers); $table_form->has_header(true); $table_form->has_footer(true); $table_form->encode_html(true); $table_form->set_single_actions($single_actions); $table_form->set_global_actions($global_actions); $table_form->set_gobal_checkbox_id('post_all'); $table_form->set_form_action(''); $table_form->set_form_id('manage_queries'); $table_form->set_form_method('post'); echo '<p>' . $table_form->get_html() . '</p>'; } // END Condition of user testing new chart //Print footer $template_site->pparse('footer');
$pagination->set_rows($total_rows); $pagination->set_css_class('widefat post fixed'); $pagination->set_pagination_stats($wpbi_dialog['table']['pagination']['stats']); $pagination->set_paginate_links(paginate_links(array('base' => esc_url(add_query_arg($pagination->pg_parameter, '%#%')), 'format' => '', 'prev_text' => __($wpbi_dialog['table']['pagination']['prev_text']), 'next_text' => __($wpbi_dialog['table']['pagination']['next_text']), 'total' => ceil($pagination->rows / $pagination->pg_interval), 'current' => $pagination->current_page))); $pagination->initialize(); echo $pagination->get_html(); //END page navigation //Execute query limitng the resultset $qy_tables_rows = $wpdb->get_results($query->limit_qy_to($pagination->item_start - 1, $pagination->pg_interval), 'ARRAY_N'); //Output table $column_headers = array($wpbi_dialog['header']['tables']['id'], $wpbi_dialog['header']['tables']['name'], $wpbi_dialog['header']['tables']['query'], $wpbi_dialog['header']['queries']['statement']); $single_actions = array("edit" => array("label" => $wpbi_dialog['action']['label']['edit'], "page" => $wpbi_url['slug']['tables'], "action" => $wpbi_settings['value']['edit'], "parameter" => $wpbi_settings['parameter']['tb-id']), "copy" => array("label" => $wpbi_dialog['action']['label']['copy'], "page" => $wpbi_url['slug']['tables'], "action" => $wpbi_settings['value']['copy'], "parameter" => $wpbi_settings['parameter']['tb-id']), "test" => array("label" => $wpbi_dialog['action']['label']['test'], "page" => $wpbi_url['slug']['tables'], "action" => $wpbi_settings['value']['test'], "parameter" => $wpbi_settings['parameter']['tb-id']), "drop" => array("label" => $wpbi_dialog['action']['label']['drop'], "page" => $wpbi_url['slug']['tables'], "action" => $wpbi_settings['value']['drop'], "parameter" => $wpbi_settings['parameter']['tb-id'])); $global_actions = array("drop" => array("label" => $wpbi_dialog['button']['label']['drop'], "value" => $wpbi_settings['value']['drop'])); $table_form = new table_form(); $table_form->set_css_class('widefat post fixed'); $table_form->set_rows($qy_tables_rows); $table_form->set_cols($column_headers); $table_form->has_header(true); $table_form->has_footer(true); $table_form->encode_html(true); $table_form->set_single_actions($single_actions); $table_form->set_global_actions($global_actions); $table_form->set_gobal_checkbox_id('post_all'); $table_form->set_form_action(''); $table_form->set_form_id('manage_queries'); $table_form->set_form_method('post'); echo '<p>' . $table_form->get_html() . '</p>'; } // END Condition of user testing new query //Print footer $template_site->pparse('footer');
$pagination->set_rows($total_rows); $pagination->set_css_class('widefat post fixed'); $pagination->set_pagination_stats($wpbi_dialog['table']['pagination']['stats']); $pagination->set_paginate_links(paginate_links(array('base' => esc_url(add_query_arg($pagination->pg_parameter, '%#%')), 'format' => '', 'prev_text' => __($wpbi_dialog['table']['pagination']['prev_text']), 'next_text' => __($wpbi_dialog['table']['pagination']['next_text']), 'total' => ceil($pagination->rows / $pagination->pg_interval), 'current' => $pagination->current_page))); $pagination->initialize(); echo $pagination->get_html(); //END page navigation //Execute query limitng the resultset $qy_databases_rows = $wpdb->get_results($query->limit_qy_to($pagination->item_start - 1, $pagination->pg_interval), 'ARRAY_N'); //Output table $column_headers = array('ID', $wpbi_dialog['header']['connections']['alias'], $wpbi_dialog['header']['connections']['name'], $wpbi_dialog['header']['connections']['host'], $wpbi_dialog['header']['connections']['user']); $single_actions = array("edit" => array("label" => "Edit", "page" => $wpbi_url['slug']['connections'], "action" => $wpbi_settings['value']['edit'], "parameter" => $wpbi_settings['parameter']['db_id']), "test" => array("label" => "Test", "page" => $wpbi_url['slug']['connections'], "action" => $wpbi_settings['value']['test'], "parameter" => $wpbi_settings['parameter']['db_id']), "drop" => array("label" => "Drop", "page" => $wpbi_url['slug']['connections'], "action" => $wpbi_settings['value']['drop'], "parameter" => $wpbi_settings['parameter']['db_id'])); $global_actions = array("drop" => array("label" => "Drop", "value" => $wpbi_settings['value']['drop'])); $table_form = new table_form(); $table_form->set_css_class('widefat post fixed'); $table_form->set_rows($qy_databases_rows); $table_form->set_cols($column_headers); $table_form->has_header(true); $table_form->has_footer(true); $table_form->can_download(false); $table_form->encode_html(true); $table_form->set_single_actions($single_actions); $table_form->set_global_actions($global_actions); $table_form->set_gobal_checkbox_id('post_all'); $table_form->set_form_action(substr(substr(strrchr($_SERVER['REQUEST_URI'], '/'), 1), 0, strpos(substr(strrchr($_SERVER['REQUEST_URI'], '/'), 1), '&'))); $table_form->set_form_id('manage_queries'); $table_form->set_form_method('post'); echo $table_form->get_html(); } //End condition about edit action //output page footer