<?php
if(is_user_logged_in()){
  global $current_user;
  global $wpdb;
  $user_id = $current_user->ID;
}

$PSY_USERS_DETAILS = $wpdb->prefix . PSY_USERS_DETAILS;
$PSY_USERS = $wpdb->prefix . PSY_USERS;
$PSY_ABILITY_CLASS = $wpdb->prefix . PSY_ABILITY_CLASS;
$PSY_STATES = $wpdb->prefix . PSY_STATES; 
$PSY_CITY = $wpdb->prefix . PSY_CITY; 

$getUserDetails = $wpdb->get_row("SELECT u.user_login, u.user_email, ud.first_name, ud.last_name, ud.profile_image, ud.mobile_number, ud.email_address, ud.current_education_level, c.class_name, s.state_name, ct.city_name from $PSY_USERS as u LEFT JOIN $PSY_USERS_DETAILS as ud ON ud.user_id=u.ID LEFT JOIN $PSY_ABILITY_CLASS as c ON c.class_id=ud.current_education_level LEFT JOIN $PSY_STATES as s ON s.state_id=ud.state_id LEFT JOIN $PSY_CITY as ct ON ct.city_id=ud.city_id where u.ID='$user_id'");

$class_id = $getUserDetails->current_education_level;

?>


<!-- DASHBOARD SECTION -->
<div class="dashboard-side-bar">
	<div class="dashboard-bg-content">
		<div class="dp-img-logo-box">
			<img src="https://images.pexels.com/photos/3779677/pexels-photo-3779677.jpeg?auto=compress&cs=tinysrgb&dpr=2&h=650&w=940" alt="">
		</div>
		<h4 class="dp-name"><?php echo $getUserDetails->first_name; ?> <?php echo $getUserDetails->last_name; ?></h4>
		<p class="dp-class"><?php echo $getUserDetails->class_name; ?></p>

		<h6 class="left-bar-head">Contact <span> </h6>
       
		<ul class="contact-list-ul">
			<li><i class="fas fa-phone"></i><?php echo $getUserDetails->mobile_number; ?></li>
			<li><i class="far fa-envelope"></i><?php echo $getUserDetails->email_address; ?></li>
			<li><i class="fas fa-map-marker-alt"></i> <?php echo $getUserDetails->state_name; ?></li>
		</ul>
		
		<h6 class="left-bar-head">Social Links <span> <i class="fas fa-pencil-alt"></i> add</span></h6>
        <ul class="sociallink-list-ul">
			<li><i class="fab fa-facebook-f"></i></li>
            <li><i class="fab fa-twitter"></i></li>
            <li><i class="fab fa-google-plus-g"></i></li>
		</ul>
		
		<h6 class="left-bar-head">Hobbies <span> <i class="fas fa-pencil-alt"></i> add</span></h6>
        <div class="row hobbies-div">
			<div class="col-md-4"><h4>Writting</h4></div>
            <div class="col-md-4"><h4>Cycling</h4></div>
			<div class="col-md-4"><h4>Football</h4></div>
			<div class="col-md-4"><h4>Movies</h4></div>
			<div class="col-md-4"><h4>Travel</h4></div>
			<div class="col-md-4"><h4>Games</h4></div>
		</div>

		<h6 class="left-bar-head">Digi Locker </h6>
			<ul class="digi-ul">
                <li><i class="fas fa-link"></i> Link</li>
			</ul>

        <h6 class="left-bar-head">Friends <span> <i class="fas fa-pencil-alt"></i> add</span></h6>
		<div class="row hobbies-div">
			<div class="col-md-4"><h4>Sam</h4></div>
			<div class="col-md-4"><h4>Smith</h4></div>
			<div class="col-md-4"><h4>Adam</h4></div>
			<div class="col-md-4"><h4>Steve</h4></div>
			<div class="col-md-4"><h4>Tony</h4></div>
			<div class="col-md-4"><h4>Tom</h4></div>
		</div>
     </div>
</div>