prefix."wpsp_student"; $users_table = $wpdb->prefix."users"; $tfees = $wpdb->prefix."wpsp_fees"; $class_id=''; if( isset($_POST['ClassID'] ) && $_POST['ClassID'] != 'all' ) { $class_id=intval($_POST['ClassID']); $stl = []; $studentlists = $wpdb->get_results("select class_id, sid from $student_table"); foreach ($studentlists as $stu) { if(is_numeric($stu->class_id) ){ if($stu->class_id == $class_id){ $stl[] = $stu->sid; } }else{ $class_id_array = unserialize( $stu->class_id ); if(is_array($class_id_array)){ if(in_array($class_id, $class_id_array)){ $stl[] = $stu->sid; } } } } }else if(!isset($_POST['ClassID']) || $_POST['ClassID'] == 'all' ){ $studentlists = $wpdb->get_results("select sid from $student_table"); foreach ($studentlists as $stu) { $stl[] = $stu->sid; } } if (!empty($stl)) { $key =0; foreach ($stl as $id ) { $id = esc_sql($id); // $students = $wpdb->get_results("select * from $student_table s, $users_table u where u.ID=s.wp_usr_id AND sid = '$id' and user_login != 'student' order by sid desc"); $students = $wpdb->get_results($wpdb->prepare("SELECT * FROM $student_table s, $users_table u where u.ID=s.wp_usr_id AND sid = %d and user_login != %s ORDER BY sid desc",$id,'student')); $plugins_url=plugins_url(); $pendingcount =0; foreach($students as $stinfo){ if($stinfo->class_id != ''){ if(is_numeric($stinfo->class_id) ){ $cid[] = $stinfo->class_id; }else{ $class_id_array = unserialize( $stinfo->class_id ); $cid = $class_id_array; } } $cidds = implode(",",$cid); // $subject_ids = explode(',', $cidds); // $subject_ids = array_map('intval', $subject_ids); // $placeholders = implode(',', array_fill(0, count($subject_ids), '%d')); // $teacherId = $wpdb->get_var("select teacher_id from $class_table WHERE cid IN($cidds)"); // $teacherId = $wpdb->prepare("SELECT teacher_id FROM $class_table WHERE cid IN ($placeholders)",...$subject_ids); $courses = get_user_meta( $stinfo->parent_wp_usr_id, '_pay_woocommerce_enrolled_class_access_counter', true ); $results = $wpdb->get_results("SELECT s.wp_usr_id,f.student_id,f.order_id FROM $student_table AS s INNER JOIN $tfees AS f ON f.student_id = s.wp_usr_id"); foreach($results as $res){ $siid[] = $res->wp_usr_id; } if(empty($siid)){ $paid = esc_html("Pending","wpschoolpress"); }else{ if (in_array($stinfo->wp_usr_id,$siid)){ $paid = esc_html("Paid","wpschoolpress"); }else{ $paid = esc_html("Pending","wpschoolpress"); } } $key++; if($proversion1['status']){?> s_lname == "") {echo "style='background-color:#fcdddd'";} else { echo "style='background-color:#c9f7c9'";}?>>

	s_rollno);?>	s_mname; $lname = $stinfo->s_lname; echo esc_html($stinfo->s_fname .' '. $mname .' '. $lname);?>	p_fname." ".$stinfo->p_lname); ?>	s_country ) ? ", ".$stinfo->s_country : ''; $city = !empty( $stinfo->s_city ) ? ", ".$stinfo->s_city : ''; $zipcode = !empty( $stinfo->s_zipcode ) ? ", ".$stinfo->s_zipcode : ''; echo esc_html($stinfo->s_address.' '.$city. ' ' . $country.' '.$zipcode); ?>		class_id != ''){ if(is_numeric($stinfo->class_id) ){ $stl[] = $stinfo->class_id; }else{ $class_id_array = unserialize($stinfo->class_id); foreach ($class_id_array as $id) { $stl[] = $id; } } }else{ $stl[] = 0; } if($stl[0] == 0 ){ echo esc_html("Unassigned","wpschoolpress"); } else { echo esc_html("Assigned","wpschoolpress"); } ?>	s_phone);?>