* Number not alowed!

* You can book only {$total} events on particular date!

";
	      //print_r($_SERVER);
	  $html.='
';
	  $html.='';
   
	  foreach($data as $key => $val){
	        $st=$val->status;
	        if(isset($_REQUEST['appid']) && $_REQUEST['appid']==$val->app_id)
	        {
	          $id=$_REQUEST['appid'];

	          $html.='';
	            $html.='';

	        }
	        else{

	    $html.='';
	    $html.='';
	    $html.='';  
		}
	  }
    }
    else
	 {
	      echo "* No records found!";
	      exit();
	 }
 }

	 $html.='

	  

	      
ID
	      
Name of Appointments
	      
Date of Appointments
	      
Email
	      
Phone
	      
Status
	      
Options
	  

	            
'.$val->app_id.'
	            
	            

	            

	            

	            
';
	            if($st=='Pending'){$html.='Pending';}
	            if($st=='Approved'){$html.='Approved';}
	            if($st=='Rejected'){$html.='Rejected';}
	            if($st=='Completed'){$html.='Completed';}
	        	$html.='
	            

	            
	            
	            
	          

	    
'.$val->app_id.'
	    
'.$val->title.'
	    
'.$val->start.'
	    
'.$email.'
	    
'.$val->phone.'
';
	    if($st=='Pending'){$html.='Pending';}
	    elseif($st=='Approved'){$html.='Approved';}
	    elseif($st=='Rejected'){$html.='Rejected';}
	    elseif($st=='Completed'){$html.='Completed';}
		$html.='
';
	    if($st!='Rejected')
	    {
		    $html.='Edit |';
		    $html.='Delete';
		}
		$html.='
'; 
	 $html.='
';
	 return $html;	
}
	
	public function manage_front_action()
	{
		global $wpdb;
    	$table_name = $wpdb->prefix . 'Appointments';
    	//$tb=$wpdb->prefix.'events';
    	
    	$a=$_SERVER['REQUEST_URI'];
		 // die($a);
		$sb= explode("?", $a);


    	if(is_user_logged_in()){

			if(isset($_REQUEST['apid'])){

				//require_once dirname(__FILE__).'/templates/appointment_delete(user).php';
	    		
			    $id=$_REQUEST['apid'];
			    $userid=get_current_user_id();

			    $url=$_SERVER['REQUEST_URI'];

			    $arr=explode("&", $url);

			    $res=$wpdb->update($table_name,array('status'=>'Rejected'),
		    			array('app_id'=>$id,'user_id'=>$userid),
		    			array('%s'),
		    			array('%d','%d')
		    	 );

			    if($res==true){
			    	require_once dirname(__FILE__).'/templates/appointment_delete(user).php';
			        echo '';
			    }
			}

		if(isset($_REQUEST['btnup'])){
			
		    $userid=get_current_user_id();
		    $total=$this->options['booking_perday']; // Total no of events perday booked

		    $e_id=$_REQUEST['txtid'];
		    $name=trim($_REQUEST['txteappname']);
		    $dt=date('Y-m-d',strtotime(trim($_REQUEST['txtedate'])));
		   // die($dt);
		    $em=trim($_REQUEST['txteemail']);
		    $ph=trim($_REQUEST['txtephone']);

		   // die($e_id);

		    if($dt* Date must be today or grater than today date!
";
		      exit();
		    }
		    if(!preg_match("/^[a-zA-Z -]+$/", $name)){ /* match only string not numeric value */
		        echo "
* Number not alowed!
";
		        exit();
		    }

		    $abc=$wpdb->get_var("SELECT count(start) from $table_name WHERE start='".$dt."' and user_id='$userid'");
		  
		    if($abc>=$total){
		        echo "
* You can book only {$total} events on particular date!
";
		        exit();
		    }
		    else
		    {
		   	$udata = wp_update_user( array( 'ID' => $userid, 'user_email' => $em ) ); 
		   
		    $query=$wpdb->update($table_name,array('title'=>trim($name),'start'=>$dt,'email'=>sanitize_email($em),'phone'=>trim($ph)),
		    				array('app_id'=>$e_id,'user_id'=>$userid),
		    				array('%s','%s','%s','%s'),
		    				array('%d','%d')
		    			); 
		   
		    if($query==true && $udata==true){
		       require_once dirname(__FILE__).'/templates/appointment_update(user).php';

		       print "";
		       print '';
		    }
		    else{
		          print '';
		    }
		  }
		 
		 }

		 if(isset($_REQUEST['btncan']))  // Redirect to page
		 {
		 	print '';
		 	exit();
		 }

		}		 
	}

	public function user_validation($username, $password, $email, $first_name, $last_name, $nickname, $bio)
	{
		global $reg_errors,$html;
		extract($_POST);
		$reg_errors = new WP_Error;
		if ( isset($register) ) {
		if ( empty( $username ) || empty( $password ) || empty( $email ) ) {
    		$reg_errors->add('field', 'Required form field is missing');
		}

		if ( 4 > strlen( $username ) ) {
    		$reg_errors->add( 'username_length', 'Username too short. At least 4 characters is required' );
		}

		if ( username_exists( $username ) ){
    		$reg_errors->add('user_name', 'Sorry, that username already exists!');

		} 

		if ( ! validate_username( $username ) ) {
    		$reg_errors->add( 'username_invalid', 'Sorry, the username you entered is not valid' );
		}

		if ( 5 > strlen( $password ) ) {
        	$reg_errors->add( 'password', 'Password length must be greater than 5' );
    	}

    	if ( !is_email( $email ) ) {
    		$reg_errors->add( 'email_invalid', 'Email is not valid' );
		}

		if ( email_exists( $email ) ) {
   			 $reg_errors->add( 'email', 'Email Already in use' );
		}


		if ( is_wp_error( $reg_errors ) ) {
 
    	foreach ( $reg_errors->get_error_messages() as $error ) {
     
        echo '
';
        echo 'ERROR:';
        echo $error . '
';
        echo '
';
         
    	}
    	}
	}
}	

	public function confirm_mail($email,$admin_email,$userid)
	{
		$img = $this->options['upload_image'];
		$data = get_userdata($userid);
		$username = $data->user_firstname;
		//echo "user = ".$username;

		$to      = $email;
	    $from    = $admin_email; 
	    $subject = "Confirmation mail";
	    $content = 
	    ' 

	    	  
	    
'.  
	   '
'. 
	       '
Hi '.$username.'
'.
	       '
Please click here Link to confirm mail. 
'. 
	       '
Thank you.
'.  
	   '
'.   
	'
'.
	      $headers.= "From: {$from} \r\n"; 
		  $headers.= "Reply-To: {$from}\r\n"; 
		  $headers.= "MIME-Version: 1.0\r\n";
		  $headers.= "Content-Type: text/html; charset=ISO-8859-1\r\n";

		  wp_mail($to, $subject, $content, $headers);
	}

	public function complete_registration() 
	{
	    global $reg_errors, $username, $password, $email, $first_name, $last_name, $nickname, $bio;
	    extract($_POST);

	    if ( isset($register) ) {
	    $admin_email = get_option('admin_email');      

	    if ( 1 > count( $reg_errors->get_error_messages() ) ) {
	        $userdata = array(
	        'user_login'    =>   $username,
	        'user_email'    =>   sanitize_email($email),
	        'user_pass'     =>   $password,
	        'first_name'    =>   $first_name,
	        'last_name'     =>   $last_name,
	        'nickname'      =>   $nickname,
	        'description'   =>   $bio,
	        );

	      // Confirmation mail send
	        
	      $user    =  wp_insert_user($userdata);
	      if( !is_wp_error($user) ) {
	      		echo '* Registration complete. Please check your mail to confirm email adress. 
* Click here to Wp-login.'; 
	  			$this->confirm_mail($email,$admin_email,$user);
	  		}
	    }
  }
}

public function get_user_name()
{
 	global $current_user;
 	get_currentuserinfo();
    $name = $current_user->user_login;
    return $name;
}
public function get_user_email()
{
 	global $current_user;
 	get_currentuserinfo();
    $email = $current_user->user_email;
    return $email;
}
	
/*public function emailtemplate_validation($template_code,$template_subject,$template_text)
{
	extract($_POST);
	global $reg_errors,$html;
	$reg_errors = new WP_Error;
	if ( trim(empty( $template_code ) ))
	{
    	$reg_errors->add('Required', 'Template name field is missing');
	}
	if(trim(empty( $template_subject )))
	{
		$reg_errors->add('Required', 'Template subject field is missing');
	}
	if(trim(empty( $template_text ) ))
	{
		$reg_errors->add('Required', 'Template content field is missing');
	}
	if ( is_wp_error( $reg_errors ) ) {
 
    	foreach ( $reg_errors->get_error_messages() as $error ) {
     
        echo '
';
        echo 'ERROR:';
        echo $error . '
';
        echo '
';
         
    	}
    }
}
public function email_store()  // Template created
{
	extract($_POST);
	global $wpdb,$reg_errors;
	//$reg_errors = new WP_Error;
	$table=$wpdb->prefix."email_templates";

	if(isset($btnsubmit))
	{	
		$this->emailtemplate_validation($template_code,$template_subject,$template_text);
		if ( 1 > count( $reg_errors->get_error_messages() ) ){
		$true=$wpdb->query("INSERT INTO {$table} (`temp_code`,`temp_content`,`temp_style`,`temp_subject`) VALUES ('{$template_code}','{$template_text}','{$template_style}','{$template_subject}')");	
		if($true==true){
			echo '
* New Email Template Created.
';
		}
		else{echo mysql_error();exit();
		}
	}
}
}

public function update_template(){    // Template updated

	extract($_POST);
	global $wpdb,$reg_errors;
	//$reg_errors = new WP_Error;
	$table=$wpdb->prefix."email_templates";
	if(isset($btnupdate))
	{
		$true=$wpdb->query("UPDATE $table SET `temp_code`='{$template_code}',`temp_content`='{$template_text}',`temp_style`='{$template_styles}',`temp_subject`='{$template_subject}' WHERE `temp_id`='{$tempid}'");	
		if($true==true){
			echo '
* Template Updated
';
		}
		else{echo mysql_error();exit();
	}
}

}

public function get_templates_name()
{
	global $wpdb;
    $table=$wpdb->prefix."email_templates";

    $templates_name=$wpdb->get_results("SELECT * from {$table}");
    
    foreach ($templates_name as $key => $value) {
                echo "".$value->temp_code."";
    }
}

public function getcustomer_name(){

	global $wpdb;	
	$table=$wpdb->prefix."users";
	$users=get_userdata(1); // Admin user id
	$name=$wpdb->get_var("SELECT user_login from {$table} WHERE ID!='{$users->ID}'");
	return $name;
}

public function getcustomer_pwd(){

	global $wpdb;	
	$table=$wpdb->prefix."users";
	$users=get_userdata(1); // Admin user id
	$pwd=$wpdb->get_var("SELECT user_pass from {$table} WHERE ID!='{$users->ID}'");
	return $pwd;
}

public function getcustomer_email()
{
	global $wpdb;	
	$table=$wpdb->prefix."users";
	$users=get_userdata(1); // Admin user id
	$id=$wpdb->get_var("SELECT ID from {$table} WHERE ID!='{$users->ID}'");
	$email="Link";
	return $email;
}

public function getappname()
{
	global $wpdb;	
	$table=$wpdb->prefix."Appointments";
	//$users=get_userdata(1); // Admin user id
	$user=get_current_user_id();
	$appname=$wpdb->get_var("SELECT `appointment_name` from {$table} WHERE user_id='{$user}'");
	return $appname;
}

public function getappdate()
{
	global $wpdb;	
	$table=$wpdb->prefix."Appointments";
	//$users=get_userdata(1); // Admin user id
	$user=get_current_user_id();
	$appdate=$wpdb->get_var("SELECT `date_of_apointment` from {$table} WHERE user_id='{$user}'");
	return $appdate;
}

public function image_code() {

	$attachments = get_posts( array(
    'post_type' => 'attachment',
    'posts_per_page' => 1,
    'post_status' => null,
    'post_mime_type' => 'image'
) );

foreach ( $attachments as $attachment ) {
	$link=$attachment->guid;
}	
   // $args = shortcode_atts( array( 'url' => FALSE ), $atts  );
    $img  = esc_url( $link );
  //  $url  = $args['url'] ? esc_url( $args['url'] ) : $img;

    return "";
}*/

}
?>