/**
 * Astra functions and definitions
 *
 * @link https://developer.wordpress.org/themes/basics/theme-functions/
 *
 * @package Astra
 * @since 1.0.0
 */

if ( ! defined( 'ABSPATH' ) ) {
	exit; // Exit if accessed directly.
}

/**
 * Define Constants
 */
define( 'ASTRA_THEME_VERSION', '3.7.6' );
define( 'ASTRA_THEME_SETTINGS', 'astra-settings' );
define( 'ASTRA_THEME_DIR', trailingslashit( get_template_directory() ) );
define( 'ASTRA_THEME_URI', trailingslashit( esc_url( get_template_directory_uri() ) ) );


/**
 * Minimum Version requirement of the Astra Pro addon.
 * This constant will be used to display the notice asking user to update the Astra addon to the version defined below.
 */
define( 'ASTRA_EXT_MIN_VER', '3.6.3' );

/**
 * Setup helper functions of Astra.
 */
require_once ASTRA_THEME_DIR . 'inc/core/class-astra-theme-options.php';
require_once ASTRA_THEME_DIR . 'inc/core/class-theme-strings.php';
require_once ASTRA_THEME_DIR . 'inc/core/common-functions.php';
require_once ASTRA_THEME_DIR . 'inc/core/class-astra-icons.php';

/**
 * Update theme
 */
require_once ASTRA_THEME_DIR . 'inc/theme-update/class-astra-theme-update.php';
require_once ASTRA_THEME_DIR . 'inc/theme-update/astra-update-functions.php';
require_once ASTRA_THEME_DIR . 'inc/theme-update/class-astra-theme-background-updater.php';
require_once ASTRA_THEME_DIR . 'inc/theme-update/class-astra-pb-compatibility.php';


/**
 * Fonts Files
 */
require_once ASTRA_THEME_DIR . 'inc/customizer/class-astra-font-families.php';
if ( is_admin() ) {
	require_once ASTRA_THEME_DIR . 'inc/customizer/class-astra-fonts-data.php';
}

require_once ASTRA_THEME_DIR . 'inc/lib/webfont/class-astra-webfont-loader.php';
require_once ASTRA_THEME_DIR . 'inc/customizer/class-astra-fonts.php';

require_once ASTRA_THEME_DIR . 'inc/dynamic-css/custom-menu-old-header.php';
require_once ASTRA_THEME_DIR . 'inc/dynamic-css/container-layouts.php';
require_once ASTRA_THEME_DIR . 'inc/dynamic-css/astra-icons.php';
require_once ASTRA_THEME_DIR . 'inc/dynamic-css/block-editor-compatibility.php';
require_once ASTRA_THEME_DIR . 'inc/core/class-astra-walker-page.php';
require_once ASTRA_THEME_DIR . 'inc/core/class-astra-enqueue-scripts.php';
require_once ASTRA_THEME_DIR . 'inc/core/class-gutenberg-editor-css.php';
require_once ASTRA_THEME_DIR . 'inc/dynamic-css/inline-on-mobile.php';
require_once ASTRA_THEME_DIR . 'inc/dynamic-css/content-background.php';
require_once ASTRA_THEME_DIR . 'inc/class-astra-dynamic-css.php';
require_once ASTRA_THEME_DIR . 'inc/class-astra-global-palette.php';

/**
 * Custom template tags for this theme.
 */
require_once ASTRA_THEME_DIR . 'inc/core/class-astra-attr.php';
require_once ASTRA_THEME_DIR . 'inc/template-tags.php';

require_once ASTRA_THEME_DIR . 'inc/widgets.php';
require_once ASTRA_THEME_DIR . 'inc/core/theme-hooks.php';
require_once ASTRA_THEME_DIR . 'inc/admin-functions.php';
require_once ASTRA_THEME_DIR . 'inc/core/sidebar-manager.php';

/**
 * Markup Functions
 */
require_once ASTRA_THEME_DIR . 'inc/markup-extras.php';
require_once ASTRA_THEME_DIR . 'inc/extras.php';
require_once ASTRA_THEME_DIR . 'inc/blog/blog-config.php';
require_once ASTRA_THEME_DIR . 'inc/blog/blog.php';
require_once ASTRA_THEME_DIR . 'inc/blog/single-blog.php';

/**
 * Markup Files
 */
require_once ASTRA_THEME_DIR . 'inc/template-parts.php';
require_once ASTRA_THEME_DIR . 'inc/class-astra-loop.php';
require_once ASTRA_THEME_DIR . 'inc/class-astra-mobile-header.php';

/**
 * Functions and definitions.
 */
require_once ASTRA_THEME_DIR . 'inc/class-astra-after-setup-theme.php';

// Required files.
require_once ASTRA_THEME_DIR . 'inc/core/class-astra-admin-helper.php';

require_once ASTRA_THEME_DIR . 'inc/schema/class-astra-schema.php';

if ( is_admin() ) {

	/**
	 * Admin Menu Settings
	 */
	require_once ASTRA_THEME_DIR . 'inc/core/class-astra-admin-settings.php';
	require_once ASTRA_THEME_DIR . 'inc/lib/astra-notices/class-astra-notices.php';

}

/**
 * Metabox additions.
 */
require_once ASTRA_THEME_DIR . 'inc/metabox/class-astra-meta-boxes.php';

require_once ASTRA_THEME_DIR . 'inc/metabox/class-astra-meta-box-operations.php';

/**
 * Customizer additions.
 */
require_once ASTRA_THEME_DIR . 'inc/customizer/class-astra-customizer.php';

/**
 * Astra Modules.
 */
require_once ASTRA_THEME_DIR . 'inc/modules/related-posts/class-astra-related-posts.php';

/**
 * Compatibility
 */
require_once ASTRA_THEME_DIR . 'inc/compatibility/class-astra-gutenberg.php';
require_once ASTRA_THEME_DIR . 'inc/compatibility/class-astra-jetpack.php';
require_once ASTRA_THEME_DIR . 'inc/compatibility/woocommerce/class-astra-woocommerce.php';
require_once ASTRA_THEME_DIR . 'inc/compatibility/edd/class-astra-edd.php';
require_once ASTRA_THEME_DIR . 'inc/compatibility/lifterlms/class-astra-lifterlms.php';
require_once ASTRA_THEME_DIR . 'inc/compatibility/learndash/class-astra-learndash.php';
require_once ASTRA_THEME_DIR . 'inc/compatibility/class-astra-beaver-builder.php';
require_once ASTRA_THEME_DIR . 'inc/compatibility/class-astra-bb-ultimate-addon.php';
require_once ASTRA_THEME_DIR . 'inc/compatibility/class-astra-contact-form-7.php';
require_once ASTRA_THEME_DIR . 'inc/compatibility/class-astra-visual-composer.php';
require_once ASTRA_THEME_DIR . 'inc/compatibility/class-astra-site-origin.php';
require_once ASTRA_THEME_DIR . 'inc/compatibility/class-astra-gravity-forms.php';
require_once ASTRA_THEME_DIR . 'inc/compatibility/class-astra-bne-flyout.php';
require_once ASTRA_THEME_DIR . 'inc/compatibility/class-astra-ubermeu.php';
require_once ASTRA_THEME_DIR . 'inc/compatibility/class-astra-divi-builder.php';
require_once ASTRA_THEME_DIR . 'inc/compatibility/class-astra-amp.php';
require_once ASTRA_THEME_DIR . 'inc/compatibility/class-astra-yoast-seo.php';
require_once ASTRA_THEME_DIR . 'inc/addons/transparent-header/class-astra-ext-transparent-header.php';
require_once ASTRA_THEME_DIR . 'inc/addons/breadcrumbs/class-astra-breadcrumbs.php';
require_once ASTRA_THEME_DIR . 'inc/addons/heading-colors/class-astra-heading-colors.php';
require_once ASTRA_THEME_DIR . 'inc/builder/class-astra-builder-loader.php';

// Elementor Compatibility requires PHP 5.4 for namespaces.
if ( version_compare( PHP_VERSION, '5.4', '>=' ) ) {
	require_once ASTRA_THEME_DIR . 'inc/compatibility/class-astra-elementor.php';
	require_once ASTRA_THEME_DIR . 'inc/compatibility/class-astra-elementor-pro.php';
	require_once ASTRA_THEME_DIR . 'inc/compatibility/class-astra-web-stories.php';
}

// Beaver Themer compatibility requires PHP 5.3 for anonymus functions.
if ( version_compare( PHP_VERSION, '5.3', '>=' ) ) {
	require_once ASTRA_THEME_DIR . 'inc/compatibility/class-astra-beaver-themer.php';
}

require_once ASTRA_THEME_DIR . 'inc/core/markup/class-astra-markup.php';

/**
 * Load deprecated functions
 */
require_once ASTRA_THEME_DIR . 'inc/core/deprecated/deprecated-filters.php';
require_once ASTRA_THEME_DIR . 'inc/core/deprecated/deprecated-hooks.php';
require_once ASTRA_THEME_DIR . 'inc/core/deprecated/deprecated-functions.php';


add_shortcode( 'admin-login','login_admin' );
function login_admin ( $atts ) {
    ob_start();
    include 'admin-login.php';
     $html=ob_get_contents();
     ob_end_clean();
     return $html;
}

add_shortcode( 'client_login','client_login' );
function client_login ( $atts ) {
    ob_start();
    include 'student-search.php';
     $html=ob_get_contents();
     ob_end_clean();
     return $html;
}




add_action('wp_ajax_filter_data', 'filter_data_by_ajax_callback');
add_action('wp_ajax_nopriv_filter_data', 'filter_data_by_ajax_callback');


function filter_data_by_ajax_callback() {
 global $wpdb;
		$paged = $_REQUEST['page'];
		$term_id = $_REQUEST['term_id'];
		$register_id = $_REQUEST['register_id'];
		
	//$paged = (get_query_var('paged')) ? get_query_var('paged') : 1;

	if(	$register_id !="") {
	    $results = $wpdb->get_results( "SELECT * FROM certificate where registration='$register_id'"); // Query to fetch data from database table and storing in $results
      
      //print_r($results);
        echo "<table width='100%' border='0'>"; // Adding <table> and <tbody> tag outside foreach loop so that it wont create again and again
        echo "<tbody>";      
        foreach($results as $row){   
        $userip = $row->user_ip;               //putting the user_ip field value in variable to use it later in update query
        /*echo "<tr>";                           // Adding rows of table inside foreach loop
         echo "<th>ID</th><th>Register No</th><th>Center</th><th>Student Name</th><th>Father Name</th><th>Mother Name</th><th>Course Name</th><th>Course Duration</th><th>Course Start Date</th><th>Obtained Marks</th><th>Grade</th><th>Image</th>";
         echo "</tr>"; 
        echo "<tr>"; 
        echo "<th>ID</th>";
        echo "<td>" . $row->id . "</td>";
        echo "</tr>";*/
        echo "<tr>"; 
        echo "<th>Student Image</th>";
        echo "<td><img style='width:100px;position:absolute' src='https://www.nameandfameinstitute.com/".$row->studentimage."'/><img style='position: relative;top: 38px;left: 52px;width: 100px;' src='/wp-content/uploads/2022/03/stamp-png-verified-2.png'/></td>";
        echo "</tr>";
        echo "<th>Roll No</th>";
        echo  "<td>" . $row->registration . "</td>";
        echo "</tr>";
        echo "<tr>"; 
        echo "<th>Center</th>";
        echo "<td>" . $row->center . "</td>";
        echo "</tr>";
        echo "<tr>"; 
        echo "<th>Student Name</th>";
        echo "<td>" . $row->studentname . "</td>";
        echo "</tr>";
        echo "<tr>"; 
        echo "<th>Father Name</th>";
        echo "<td>" . $row->fathername . "</td>";
        echo "</tr>";
        echo "<tr>"; 
        echo "<th>DoB</th>";
        echo "<td>" . $row->mothername . "</td>";
        echo "</tr>";
        echo "<tr>"; 
        echo "<th>Course Name</th>";
        echo "<td>" . $row->coursename . "</td>";
        echo "</tr>";
        echo "<tr>"; 
        echo "<th>Course Duration</th>";
        echo "<td>" . $row->courseduration . "</td>";
        echo "</tr>";
        echo "<tr>"; 
        echo "<th>End of Date</th>";
        echo "<td>" . $row->coursestartdate . "</td>";
        echo "</tr>";
        echo "<tr>"; 
        echo "<th>Obtained Marks</th>";
        echo "<td>" . $row->obtainedmarks . "</td>";
        echo "</tr>";
        echo "<th>Grade</th>";
        echo "<td>" . $row->grade . "</td>";
        echo "</tr>";
        echo "<tr>"; 
        echo "<th>Download</th>";
        echo "<td><a style='color: #fff;background-color: #000;padding: 5px 10px;display:inline-block;margin-top: 15px;' download='Certificate' href='https://www.nameandfameinstitute.com/".$row->image."'>Downlaod Now</a></td>";
        echo "</tr>";
        }
        echo "</tbody>";
        echo "</table>"; 

	
	}
  wp_die();
}


add_action('wp_ajax_filter_delete', 'filter_delete_by_ajax_callback');
add_action('wp_ajax_nopriv_filter_delete', 'filter_delete_by_ajax_callback');


function filter_delete_by_ajax_callback() {
 global $wpdb;
		$paged = $_REQUEST['page'];
		$term_id = $_REQUEST['term_id'];
		$register_id = $_REQUEST['register_id'];
		$table ='certificate';
		
	//$paged = (get_query_var('paged')) ? get_query_var('paged') : 1;

	if(	$register_id !="") {
	    $wpdb->delete( $table, array( 'id' => $register_id ) );
	    //$resultsd = $wpdb->get_results( "DELETE * FROM certificate where id=$register_id"); // Query to fetch data from database table and storing in $results
      $results = $wpdb->get_results( "SELECT * FROM certificate ORDER BY id DESC");
      
        echo "<table width='100%' border='0'>"; // Adding <table> and <tbody> tag outside foreach loop so that it wont create again and again
        
        echo "<tbody>";    
         echo "<tr>";                           // Adding rows of table inside foreach loop
        echo "<th>ID</th><th>Roll No</th><th>Center</th><th>Student Name</th><th>Father Name</th><th>Dob</th><th>Course Name</th><th>Course Duration</th><th>End of Date</th><th>Obtained Marks</th><th>Grade</th><th>Student Image</th><th>Image</th>";
        echo "</tr>"; 
        foreach($results as $row){   
        $userip = $row->user_ip;               //putting the user_ip field value in variable to use it later in update query
       
        echo "<tr>"; 
        echo "<td>" . $row->id . "</td>";
        echo  "<td>" . $row->registration . "</td>";   //fetching data from user_ip field
        
        echo "<td>" . $row->center . "</td>";
        echo "<td>" . $row->studentname . "</td>";
        echo "<td>" . $row->fathername . "</td>";
        echo "<td>" . $row->mothername . "</td>";
        echo "<td>" . $row->coursename . "</td>";
        echo "<td>" . $row->courseduration . "</td>";
        echo "<td>" . $row->coursestartdate . "</td>";
        
        echo "<td>" . $row->obtainedmarks . "</td>";
        echo "<td>" . $row->grade . "</td>";
         echo "<td>" . $row->studentimage . "</td>";
        echo "<td><img style='width:100px' src='https://www.nameandfameinstitute.com/".$row->image."'/><a class='deletecertificate' id=".$row->id." style='color: #fff;cursor:pointer;background-color: #000;padding: 5px 10px;float: right;margin-top: 15px;'>Delete</a></td>";
        echo "</tr>";
        }
        echo "</tbody>";
        echo "</table>"; 

	
	}
  wp_die();
}




<!DOCTYPE html>