__('Emp. Code', 'wpschoolpress'), 'first_name' => __('First Name', 'wpschoolpress'), 'middle_name' => __('Middle Name', 'wpschoolpress'), 'last_name' => __('Last Name', 'wpschoolpress'), 'user_email' => __('Teacher Email', 'wpschoolpress'), 'zipcode' => __('Zip Code', 'wpschoolpress'), 'country' => __('Country', 'wpschoolpress'), 'gender' => __('Gender', 'wpschoolpress'), 'address' => __('Address', 'wpschoolpress'), 'dob' => __('Date Of Birth', 'wpschoolpress'), 'doj' => __('Date Of Join', 'wpschoolpress'), 'dol' => __('Date Of Releaving', 'wpschoolpress'), 'phone' => __('Phone Number', 'wpschoolpress'), 'qualification' => __('Qualification', 'wpschoolpress'), 'gender' => __('Gender', 'wpschoolpress'), 'bloodgrp' => __('Blood Group', 'wpschoolpress'), 'position' => __('Position', 'wpschoolpress'), 'whours' => __('Working Hours', 'wpschoolpress'), ); $teacher_table = $wpdb->prefix."wpsp_teacher"; $class_table = $wpdb->prefix."wpsp_class"; $subjects_table = $wpdb->prefix."wpsp_subject"; $role = sanitize_text_field( $current_user->roles); $sel_classid = isset( $_POST['ClassID'] ) ? intval($_POST['ClassID']) : ''; $sub_handling = $cincharge = $teacher = array(); $classquery = $teacherQuery = ''; if( !empty( $sel_classid ) && $sel_classid!='all' ){ $classquery = " AND c.cid='".esc_sql($sel_classid)."' "; } $sub_han = $wpdb->get_results($wpdb->prepare("select sub_name,sub_teach_id,c.c_name from $subjects_table s, $class_table c where sub_teach_id>0 AND c.cid=s.class_id $classquery order by c.cid")); foreach($sub_han as $subhan) { $sub_handling[$subhan->sub_teach_id][]=$subhan->sub_name.' ('.$subhan->c_name.')'; $teacher[] = $subhan->sub_teach_id; } $incharges=$wpdb->get_results($wpdb->prepare("select c.c_name,c.teacher_id from $class_table c LEFT JOIN $teacher_table t ON t.wp_usr_id=c.teacher_id where c.teacher_id>0 $classquery")); foreach($incharges as $incharge){ $cincharge[$incharge->teacher_id][]=$incharge->c_name; } if( !empty( $teacher ) && !empty( $sel_classid ) && $sel_classid!='all' ) { $teacherQuery = 'WHERE wp_usr_id IN ('.implode( "," , $teacher ).") AND"; } else{ $teacherQuery = 'WHERE'; } $query = "SELECT * FROM $teacher_table $teacherQuery first_name != %s ORDER BY tid DESC"; $teachers = $wpdb->get_results($wpdb->prepare($query, 'teacher')); // $teachers=$wpdb->get_results($wpdb->prepare("select * from $teacher_table $teacherQuery first_name != 'teacher' order by tid DESC")); // echo "

";print_r($sel_classid);
$plugins_url=plugins_url();
?>

		
            
				
					
					
				
			
			
				 title="">
					
					 wpsp-tooltip="" >
						
							
							
							
							
								 
								
									$value ) { ?>
										
											">
                                            " checked="checked">
										
									
									
								
							
						
						
					
					
					
					 wpsp-tooltip="" >
						
							
							
							
							
								 
								
									$value ) { ?>
										
											">" checked="checked">
										
									
									
								
							
						
						
					
					
					
						 wpsp-tooltip="" >
							
						
						
					
					 wpsp-tooltip="" >
						
							
							
							 
							
								
									 
									
										$value ) { ?>
										
											 " checked="checked"> 
										
										
										
										
										
									
								
							
						
					

				
			
        
	    
	    	
	    		
				
					
				
			
			$tinfo) { ?>
							
				
					
						
							
							
							
								
							
						
						 
						  
						 
						 
						 
						
					
				
				
					
								
									
									
									
								
								empcode); ?>
								first_name." ".$tinfo->last_name);?>
								wp_usr_id] ) ) { echo esc_html(implode( ", ", $cincharge[$tinfo->wp_usr_id] )); } else { echo '-';} ?>
								wp_usr_id] ) ) { echo wp_kses_post(implode( "
 ", $sub_handling[$tinfo->wp_usr_id] )); } else { echo '-';} ?>
								phone); ?>
								
									
									
									
										" title="Edit">


	empcode); ?>	first_name." ".$tinfo->last_name);?>	wp_usr_id] ) ) { echo esc_html(implode( ", ", $cincharge[$tinfo->wp_usr_id] )); } else { echo '-';} ?>	wp_usr_id] ) ) { echo wp_kses_post(implode( " ", $sub_handling[$tinfo->wp_usr_id] )); } else { echo '-';} ?>	phone); ?>	" title="Edit">