# wpschoolpress/2.2.43/includes/wpsp-studentList.php

School Management System – WPSchoolPress, version 2.2.43. 310 lines.

- Page: https://pluginprobe.com/plugins/wpschoolpress/2.2.43/code/includes/wpsp-studentList.php
- Raw: https://pluginprobe.com/plugins/wpschoolpress/2.2.43/raw/includes/wpsp-studentList.php
- Modified: 2025-11-04T11:03:58+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/wpschoolpress/2.2.43/code/includes/wpsp-studentList.php#L10-L20`.

```php
<?php
if (!defined( 'ABSPATH' ) )exit('No Such File');
$proversion	=	wpsp_check_pro_version();
$proclass		=	!$proversion['status'] && isset( $proversion['class'] )? $proversion['class'] : '';
$protitle		=	!$proversion['status'] && isset( $proversion['message'] )? $proversion['message']	: '';
$prodisable	=	!$proversion['status'] ? 'disabled="disabled"'	: '';
$studentFieldList =  array(	's_rollno'			=>	__('Roll Number', 'wpschoolpress'),
  's_fname'			=>	__('Student First Name', 'wpschoolpress'),
	's_mname'			=>	__('Student Middle Name', 'wpschoolpress'),
	's_lname'			=>	__('Student Last Name', 'wpschoolpress'),
	's_zipcode'			=>	__('Zip Code', 'wpschoolpress'),
	's_country'			=>	__('Country', 'wpschoolpress'),
	's_gender'			=>	__('Gender', 'wpschoolpress'),
	's_address'			=>	__('Current Address', 'wpschoolpress'),
	's_paddress'		=>	__('Permanent Address', 'wpschoolpress'),
	'p_fname '			=>	__('Parent First Name', 'wpschoolpress'),
	's_bloodgrp'		=>	__('Blood Group', 'wpschoolpress'),
	's_dob'				=>	__('Date Of Birth', 'wpschoolpress'),
	's_doj'				=>	__('Date Of Join', 'wpschoolpress'),
	's_phone'			=>	__('Phone Number', 'wpschoolpress'),
);
$teacherId	=	0;
global $current_user;
$role		=	 $current_user->roles;
$cuserId	=	 $current_user->ID;
$proversion1    =    wpsp_check_pro_version('wpsp_addon_version');
$prodisable1    =    !$proversion1['status'] ? 'notinstalled'    : 'installed';
$propayment    =    wpsp_check_pro_version('pay_WooCommerce');
$propayment    =    !$propayment['status'] ? 'notinstalled'    : 'installed';
$prohistory    =    wpsp_check_pro_version('wpsp_mc_version');
$prodisablehistory    =    !$prohistory['status'] ? 'notinstalled'    : 'installed';
?>
<div class="wpsp-card">
  <div class="wpsp-card-head">
    <div class="subject-inner wpsp-left wpsp-class-filter">
      <form name="StudentClass" id="StudentClass" method="post" action="">
        <label class="wpsp-labelMain"><?php esc_html_e( 'Select Class Name', 'wpschoolpress' ); ?></label>
        <select name="ClassID" id="ClassID" class="wpsp-form-control">
          <?php
					$sel_classid	=	isset( $_POST['ClassID'] ) ? intval($_POST['ClassID']) : '';
					$class_table	=	$wpdb->prefix."wpsp_class";
					$sel_class		=	$wpdb->get_results("select cid,c_name from $class_table Order By cid ASC");
					?>
          <?php if($current_user_role=='administrator' ||  $current_user_role=='teacher') { ?>
          <option value="all" <?php if($sel_classid=='all') echo esc_html("selected","wpschoolpress"); ?>><?php esc_html_e( 'All', 'wpschoolpress' ); ?></option>
          <?php } foreach( $sel_class as $classes ) {
					?>
          <option value="<?php echo esc_attr($classes->cid);?>" <?php if($sel_classid==$classes->cid) echo esc_html("selected","wpschoolpress"); ?>><?php echo esc_html($classes->c_name);?></option>
          <?php } ?>
        </select>
      </form>
    </div>
    <div class="wpsp-right wpsp-import-export">
      <div class="wpsp-btn-lists" <?php echo esc_html($prodisable);?> title="<?php echo esc_attr($protitle);?>">
        <div class="wpsp-btn-list" <?php if($proversion['status'] != "1") {?> wpsp-tooltip="<?php echo esc_attr($protitle);?>" <?php } ?>>
          <div class="wpsp-button-group wpsp-dropdownmain wpsp-left">
            <button type="button" class="wpsp-btn wpsp-btn-success print" id="PrintStudent" <?php echo esc_html($prodisable);?> title="<?php //echo esc_attr($protitle);?>">
              <i class="fa fa-print"></i> <?php esc_html_e( 'Print', 'wpschoolpress'); ?>
            </button>
            <button type="button" class="wpsp-btn wpsp-btn-success wpsp-dropdown-toggle" <?php echo esc_html($prodisable);?> title="<?php //echo esc_attr($protitle);?>">
              <!-- <span class="sr-only"><?php esc_html_e( 'Toggle Dropdown', 'wpschoolpress' );?></span> -->
            </button>
            <div class="wpsp-dropdown wpsp-dropdown-md">
              <ul>
                <li class="wpsp-drop-title wpsp-checkList"><?php esc_html_e( 'Select Columns to Print', 'wpschoolpress' );?> </li>
                <form id="StudentColumnForm" name="StudentColumnForm" method="POST">
                  <?php foreach( $studentFieldList as $key=>$value ) { ?>
                  <li class="wpsp-checkList">
                    <input type="checkbox" name="StudentColumn[]" value="<?php echo esc_attr($key); ?>" id="<?php echo esc_attr($key); ?>" checked="checked">
                    <label for="<?php echo esc_attr($key); ?>"><?php echo esc_html($value); ?></label>
                  </li>
                  <?php } ?>
                  <?php $currentSelectClass =	isset($_POST['ClassID']) ? intval($_POST['ClassID']) : '0'; ?>
                  <input type="hidden" name="ClassID" value="<?php  echo esc_attr($currentSelectClass); ?>">
                  <input type="hidden" name="exportstudent" value="exportstudent">
                </form>
              </ul>
            </div>
          </div>
        </div>
        <?php if ( in_array( 'administrator', $role ) ) {?>
        <div class="wpsp-btn-list" <?php if($proversion['status'] != "1") {?> wpsp-tooltip="<?php echo esc_attr($protitle);?>" <?php } ?>>
          <button id="ImportStudent" class="wpsp-btn wpsp-dark-btn wpsp-popclick impt" <?php echo esc_html($prodisable);?> title="<?php //echo esc_attr($protitle);?>" data-pop="ImportModal"><i class="fa fa-upload"></i> <?php echo esc_html("Import","wpschoolpress");?> </button>
        </div>
        <?php }?>
        <div class="wpsp-btn-list" <?php if($proversion['status'] != "1") {?> wpsp-tooltip="<?php echo esc_attr($protitle);?>" <?php } ?>>
          <div class="wpsp-dropdownmain wpsp-button-group">
            <button type="button" class="wpsp-btn print" id="ExportStudents" <?php echo esc_html($prodisable);?> title="<?php //echo esc_attr($protitle);?>"><i class="fa fa-download"></i> <?php esc_html_e( 'Export', 'wpschoolpress'); ?> </button>
            <button type="button" class="wpsp-btn wpsp-btn-blue wpsp-dropdown-toggle" <?php echo esc_html($prodisable);?> title="<?php //echo esc_attr($protitle);?>">
              <!-- <span class="sr-only"><?php esc_html_e( 'Toggle Dropdown', 'wpschoolpress' );?></span> -->
            </button>
            <div id="exportcontainer" style="display:none;"></div>
            <div class="wpsp-dropdown wpsp-dropdown-md wpsp-dropdown-right">
              <ul>
                <li class="wpsp-drop-title wpsp-checkList"><?php esc_html_e( 'Select Columns to Export', 'wpschoolpress' );?> </li>
                <form id="ExportColumnForm" name="ExportStudentColumn" method="POST">
                  <?php foreach( $studentFieldList as $key=>$value ) {?>
                  <li class="wpsp-checkList">
                    <input type="checkbox" name="StudentColumn[]" value="<?php echo esc_attr($key); ?>" id="<?php echo esc_attr($key); ?>" checked="checked">
                    <label class="wpsp-label" for="<?php echo esc_attr($key); ?>"><?php echo esc_html($value); ?></label>
                  </li>
                  <?php }?>
                  <input type="hidden" name="ClassID" value="<?php echo esc_html($currentSelectClass); ?>">
                  <input type="hidden" name="exportstudent" value="exportstudent">
                </form>
              </ul>
            </div>
          </div>
        </div>
      </div>
    </div>
  </div>
  <div class="wpsp-card-body">
    <div class="subject-head">
      <?php if ( in_array( 'administrator', $role ) ) { ?>
      <div class="wpsp-bulkaction">
        <select name="bulkaction" class="wpsp-form-control" id="bulkaction">
          <option value=""><?php echo esc_html("Select Action","wpschoolpress");?></option>
          <option value="bulkUsersDelete"><?php echo esc_html("Delete","wpschoolpress");?></option>
        </select>
      </div>
      <?php } ?>
      <table id="student_table" class="wpsp-table" cellspacing="0" width="100%" style="width:100%">
        <thead>
          <tr>
            <th class="nosort">
              <?php if ( in_array( 'administrator', $role ) ) { ?><input type="checkbox" id="selectall" name="selectall" class="ccheckbox"><?php } else echo esc_html('Sr. No.','wpschoolpress'); ?>
            </th>
            <th><?php echo esc_html__('Roll No.','wpschoolpress');?></th>
            <th><?php echo esc_html__('Full Name','wpschoolpress');?></th>
            <th><?php echo esc_html__('Parent','wpschoolpress');?></th>
            <th><?php echo esc_html__('Street Address','wpschoolpress');?></th>
            <?php  if($propayment =='installed'){?>
            <th><?php echo esc_html__('Payment Status','wpschoolpress');?></th>
            <?php } ?>
            <?php if($proversion1['status']){?>
            <th><?php echo esc_html__('Class Status','wpschoolpress');?></th>
            <?php } ?>
            <th><?php echo esc_html__('Phone','wpschoolpress');?></th>
            <th align="center" class="nosort"><?php echo esc_html__('Action','wpschoolpress');?></th>
          </tr>
        </thead>
        <tbody>
          <?php
						$student_table	=	$wpdb->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']){?>
                    <tr <?php if($stinfo->s_lname == "") {echo "style='background-color:#fcdddd'";} else {
										echo "style='background-color:#c9f7c9'";}?>>
                  <?php }else {?>
                    <tr>
                  <?php } ?>
                  <td>
                    <?php if ( in_array( 'administrator', $role ) ) { ?>
                      <input type="checkbox" class="ccheckbox strowselect" name="UID[]" value="<?php echo esc_attr($stinfo->wp_usr_id);?>">
                    <?php }else echo esc_html($key); ?>
                  </td>
                  <td><?php echo esc_html($stinfo->s_rollno);?></td>
                  <td><?php
										$mname = $stinfo->s_mname;
							      $lname = $stinfo->s_lname;
									  echo esc_html($stinfo->s_fname .' '. $mname .' '.  $lname);?>
                  </td>
                  <td><?php echo esc_html($stinfo->p_fname." ".$stinfo->p_lname); ?>
                  </td>
                  <td><?php
										$country = !empty( $stinfo->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);
									  ?>
                  </td>
                  <?php if($propayment == 'installed'){?>
                    <td><?php echo esc_html($paid); ?>
                      <a href="<?php echo esc_url(wpsp_admin_url().'sch-payment&id='.base64_encode(intval($stinfo->wp_usr_id)));?>" class="wpsp-popclick1" title="View"><i class="icon dashicons dashicons-visibility wpsp-view-icon"></i></a>
                    </td>
                  <?php } ?>
                  <?php if($proversion1['status']){?>
                    <td>
                      <?php
                      $stl = array();
                      if($stinfo->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"); }
                      ?>
                    </td>
                  <?php } ?>
                  <td><?php echo esc_html($stinfo->s_phone);?></td>
                  <td align="center">
                    <div class="wpsp-action-col">
                      <a href="javascript:;" class="ViewStudent wpsp-popclick" data-pop="ViewModal" data-id="<?php echo esc_attr($stinfo->wp_usr_id);?>" title="View"><i class="icon dashicons dashicons-visibility wpsp-view-icon"></i></a>
                      <a href="<?php echo "?id=".esc_attr($stinfo->wp_usr_id);?>javascript:;" data-id="<?php echo esc_attr($stinfo->wp_usr_id);?>" data-pop="ViewModal" class="viewAttendance wpsp-popclick" title="Attendance">
                        <i class="icon dashicons dashicons-admin-users wpsp-attendance-icon"></i>
                      </a>
                      <a href="<?php echo esc_url(wpsp_admin_url().'sch-student&id='. esc_attr($stinfo->wp_usr_id).'&edit=true');?>" title="Edit"><i class="icon dashicons dashicons-edit wpsp-edit-icon"></i></a>
                      <?php if ( in_array( 'administrator', $role )) { ?>
                        <a href="javascript:;" id="d_teacher" class="wpsp-popclick" data-pop="DeleteModal" title="Delete" data-id="<?php echo esc_attr($stinfo->sid);?>">
                          <i class="icon dashicons dashicons-trash wpsp-delete-icon" data-id="<?php echo esc_attr($stinfo->sid);?>"></i>
                        </a>
                      <?php }
								      if($prodisablehistory == "installed"){?>
                        <a href="<?php echo esc_url(wpsp_admin_url().'sch-history&id='.base64_encode($stinfo->wp_usr_id));?>" title="History">
                          <i class="icon dashicons dashicons-image-rotate wpsp-view-icon" data-id="<?php echo esc_attr($stinfo->sid);?>"></i>
                        </a>
                      <?php } ?>
                    </div>
                  </td>
                </tr>
                <?php
							}
            }
          }
					?>
        </tbody>
        <tfoot>
          <tr>
            <th><?php if ( in_array( 'administrator', $role ) ) { }
								else esc_html_e("Sr. No","wpschoolpress"); ?></th>
            <th><?php esc_html_e("Roll No.","wpschoolpress");?></th>
            <th><?php esc_html_e("Full Name","wpschoolpress");?></th>
            <th><?php esc_html_e("Parent","wpschoolpress");?></th>
            <th><?php esc_html_e("Street Address","wpschoolpress");?></th>
            <?php  if($propayment =='installed'){?>
            <th><?php esc_html_e("Payment Status","wpschoolpress");?></th>
            <?php } ?>
            <?php  if($proversion1['status']){?>
            <th><?php esc_html_e("Class Status","wpschoolpress");?></th>
            <?php } ?>
            <th><?php esc_html_e("Phone","wpschoolpress");?></th>
            <th align="center"><?php esc_html_e("Action","wpschoolpress");?></th>
          </tr>
        </tfoot>
      </table>
    </div>
  </div><!-- /.box-body -->
</div>
```