<?php

include_once('../wp-config.php');
global $wpdb;

$PSY_TEST_GEN_TEST_TAKEN = $wpdb->prefix . PSY_TEST_GEN_TEST_TAKEN;
$PSY_SCHOOL_STUDENT = $wpdb->prefix . PSY_SCHOOL_STUDENT;

$getUser = $wpdb->get_results("SELECT id,school_id,name,email,class,section,user_id,reg_status FROM $PSY_SCHOOL_STUDENT as s order by s.id");

?>
<table border="1">
    <tr>
        <td>Id</td>
        <td>School</td>
        <td>Name</td>
        <td>Email</td>
        <td>CLass</td>
        <td>Section</td>
        <td>PortalId</td>
        <td>Reg.Status</td>
        <td>Test</td>
    </tr>
<?php
$i=1;
foreach($getUser as $u){

    if($u->school_id == 1) {
        $school = 'Noida';
    } else if($u->school_id == 2) {
        $school = 'Vaishali';
    } else if($u->school_id == 3) {
        $school = 'Delhi';
    }
    
    if($u->user_id !='' && $u->reg_status == 1) {
        $tests = $wpdb->get_var("SELECT GROUP_CONCAT(test_type) FROM $PSY_TEST_GEN_TEST_TAKEN where user_id='$u->user_id' group by user_id");
        if($tests !=''){ $testTake = $tests; } else {$testTake = 'No test'; }
    } else {
        $testTake = 'Not registered';
    }
    ?>
    <tr>
        <td><?php echo $i; ?></td>
        <td><?php echo 'Fr. Agnel School, '.$school; ?></td>
        <td><?php echo $u->name; ?></td>
        <td><?php echo $u->email; ?></td>
        <td><?php echo $u->class; ?></td>
        <td><?php echo $u->section; ?></td>
        <td><?php echo $u->user_id; ?></td>
        <td><?php echo $u->reg_status; ?></td>
        <td><?php echo $testTake; ?></td>
    </tr>
    <?php
 $i++;       
}
?>
</table>