roles[0];
if( $current_user_role=='administrator' || $current_user_role=='teacher'){
wpsp_topbar();
wpsp_sidebar();
wpsp_body_start();
$filename = '';
$header = 'Classes';
if( isset($_GET['tab'] ) && sanitize_text_field($_GET['tab']) == 'addclass' ) {
if($current_user_role=='administrator'){
$header = $label = __( 'Add New Class', 'wpschoolpress');
$filename = WPSP_PLUGIN_PATH .'includes/wpsp-classForm.php';
}
}elseif((isset($_GET['id']) && is_numeric($_GET['id']))) {
if($current_user_role=='administrator'){
$header = $label = __( 'Update Class', 'wpschoolpress');
$filename = WPSP_PLUGIN_PATH .'includes/wpsp-classForm.php';
}
}
if( !empty( $filename) ) {
include_once ( $filename );
} else {
?>
| # |
|
|
|
|
|
|
|
prefix."wpsp_class";
$stable=$wpdb->prefix."wpsp_student";
$wpsp_classes =$wpdb->get_results("select * from $ctable order by cid DESC");
$sno=1;
$teacher_table= $wpdb->prefix."wpsp_teacher";
$teacher_data = $wpdb->get_results("select wp_usr_id,CONCAT_WS(' ', first_name, middle_name, last_name ) AS full_name from $teacher_table order by tid");
$teacherlist = array();
if( !empty( $teacher_data ) ) {
foreach( $teacher_data as $value )
$teacherlist[$value->wp_usr_id] = $value->full_name;
}
foreach ($wpsp_classes as $wpsp_class) {
$cid=intval($wpsp_class->cid);
$studentlists = $wpdb->get_results("select class_id, sid from $stable");
$stl = [];
foreach ($studentlists as $stu) {
if(is_numeric($stu->class_id) ){
if($stu->class_id == $cid){
$stl[] = $stu->sid;
}
}else{
$class_id_array = unserialize( $stu->class_id );
if(!empty($class_id_array)){
if(in_array($cid, $class_id_array)){
$stl[] = $stu->sid;
}
}
}
}
$class_students_count = count($stl);
$teach_id= intval($wpsp_class->teacher_id);
$teachername = '';
?>
| c_numb);?> |
c_name);?> |
|
|
c_capacity);?> |
c_loc);?> |
|
| # |
|
|
|
|
|
prefix."wpsp_class";
$stable=$wpdb->prefix."wpsp_student";
$teacher_table= $wpdb->prefix."wpsp_teacher";
$teacher_data = $wpdb->get_results("select wp_usr_id,CONCAT_WS(' ', first_name, middle_name, last_name ) AS full_name from $teacher_table order by tid");
$teacherlist = array();
if( !empty( $teacher_data ) ) {
foreach( $teacher_data as $value )
$teacherlist[$value->wp_usr_id] = $value->full_name;
}
if( $current_user_role=='student' ) {
// $wpsp_classes =$wpdb->get_results("SELECT cls.* FROM $ctable cls, $stable st where st.wp_usr_id = '".esc_sql($current_user->ID)."' AND st.class_id=cls.cid");
// $wpsp_classes = $wpdb->get_results($wpdb->prepare("SELECT cls.* FROM $ctable cls, $stable st WHERE st.wp_usr_id = %d AND st.class_id=cls.cid",$current_user->ID));
$wpsp_classes = $wpdb->get_results($wpdb->prepare("SELECT cls.* FROM $ctable AS cls INNER JOIN $stable AS st ON st.class_id = cls.cid WHERE st.wp_usr_id = %d",$current_user->ID));
} else {
// $wpsp_classes =$wpdb->get_results("SELECT DISTINCT cls.* FROM $ctable cls, $stable st where st.parent_wp_usr_id = '".esc_sql($current_user->ID)."' AND st.class_id=cls.cid");
$wpsp_classes = $wpdb->get_results($wpdb->prepare("SELECT DISTINCT cls.* FROM $ctable AS cls INNER JOIN $stable AS st ON st.class_id = cls.cid WHERE st.parent_wp_usr_id = %d",$current_user->ID));
}
$sno=1;
foreach ($wpsp_classes as $wpsp_class){
$cid = intval($wpsp_class->cid);
//$class_students_count = $wpdb->get_var( "SELECT COUNT(`wp_usr_id`) FROM $stable WHERE class_id = '".esc_sql($cid)."'" );
$class_students_count = $wpdb->get_var($wpdb->prepare("SELECT COUNT(`wp_usr_id`) FROM $stable WHERE class_id = %d",$cid));
$teach_id= intval($wpsp_class->teacher_id);
$teacher=get_userdata($teach_id);
?>
| c_numb);?> |
c_name);?> |
|
|
c_loc);?> |