<?php
        $hostname="localhost";
        $cUserName="basicng_root";
        $cPassword ="iq160acada";
        $myDbName = "basicng_hrorbn_12we12";
        $options  = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING,PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC);
        $dbConn= new PDO("mysql:host=localhost;dbname=$myDbName", $cUserName, $cPassword, $options);
        $sql = "SELECT SUM(ri.number_of_payers) as number_of_students, pay_semester, pay_session, is_manual_payment FROM remita_invoices ri WHERE being_pay_for='REGISTRATION'  AND pay_session =? AND pay_semester IN('OCTOBER', 'JULY','FEBRUARY') AND payment_status =? GROUP BY pay_semester, pay_session, is_manual_payment ORDER BY pay_session, pay_semester DESC";
             $stmt = $dbConn->prepare($sql);
             $stmt->execute(['2023/2024', '1']);
            
                $data=[];
                $regSessionAndMonths =[];
                $statisticData = [];
                while($fetch  = $stmt->fetch()){
            
                    $numberOfStudents	    = $fetch['number_of_students'];
                    $paySemester            = $fetch['pay_semester'];
                    $paySession             = $fetch['pay_session'];
                    $isManualPayment        = $fetch['is_manual_payment'];
                    $examsYear = substr($paySession, 5);
                    $monthYear = "$paySemester-$examsYear";
            
                    $statisticData[$monthYear][] = [
                        "year" => $examsYear,
                        "month"=> $paySemester,
                        "numberOfStudents"=>$numberOfStudents,
                        "isManualPayment"=>$isManualPayment
            
            
                    ]; 
                }
?>

<!DOCTYPE html>
<html class=" flexbox flexwrap"><head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8"><link rel="stylesheet" href="remita-files/view-rrr-details-bundle.min.css">








    
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">

        
        
        <title>Remita Report</title>

        <link href="https://login.remita.net/custom/img/favicon-remita.png" rel="shortcut icon" type="image/x-icon">

        <style type="text/css">@font-face {font-family:Raleway;font-style:normal;font-weight:100;src:url(/cf-fonts/s/raleway/5.0.16/cyrillic-ext/100/normal.woff2);unicode-range:U+0460-052F,U+1C80-1C88,U+20B4,U+2DE0-2DFF,U+A640-A69F,U+FE2E-FE2F;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:100;src:url(/cf-fonts/s/raleway/5.0.16/vietnamese/100/normal.woff2);unicode-range:U+0102-0103,U+0110-0111,U+0128-0129,U+0168-0169,U+01A0-01A1,U+01AF-01B0,U+0300-0301,U+0303-0304,U+0308-0309,U+0323,U+0329,U+1EA0-1EF9,U+20AB;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:100;src:url(/cf-fonts/s/raleway/5.0.16/cyrillic/100/normal.woff2);unicode-range:U+0301,U+0400-045F,U+0490-0491,U+04B0-04B1,U+2116;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:100;src:url(/cf-fonts/s/raleway/5.0.16/latin-ext/100/normal.woff2);unicode-range:U+0100-02AF,U+0304,U+0308,U+0329,U+1E00-1E9F,U+1EF2-1EFF,U+2020,U+20A0-20AB,U+20AD-20CF,U+2113,U+2C60-2C7F,U+A720-A7FF;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:100;src:url(/cf-fonts/s/raleway/5.0.16/latin/100/normal.woff2);unicode-range:U+0000-00FF,U+0131,U+0152-0153,U+02BB-02BC,U+02C6,U+02DA,U+02DC,U+0304,U+0308,U+0329,U+2000-206F,U+2074,U+20AC,U+2122,U+2191,U+2193,U+2212,U+2215,U+FEFF,U+FFFD;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:300;src:url(/cf-fonts/s/raleway/5.0.16/cyrillic-ext/300/normal.woff2);unicode-range:U+0460-052F,U+1C80-1C88,U+20B4,U+2DE0-2DFF,U+A640-A69F,U+FE2E-FE2F;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:300;src:url(/cf-fonts/s/raleway/5.0.16/cyrillic/300/normal.woff2);unicode-range:U+0301,U+0400-045F,U+0490-0491,U+04B0-04B1,U+2116;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:300;src:url(/cf-fonts/s/raleway/5.0.16/latin-ext/300/normal.woff2);unicode-range:U+0100-02AF,U+0304,U+0308,U+0329,U+1E00-1E9F,U+1EF2-1EFF,U+2020,U+20A0-20AB,U+20AD-20CF,U+2113,U+2C60-2C7F,U+A720-A7FF;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:300;src:url(/cf-fonts/s/raleway/5.0.16/latin/300/normal.woff2);unicode-range:U+0000-00FF,U+0131,U+0152-0153,U+02BB-02BC,U+02C6,U+02DA,U+02DC,U+0304,U+0308,U+0329,U+2000-206F,U+2074,U+20AC,U+2122,U+2191,U+2193,U+2212,U+2215,U+FEFF,U+FFFD;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:300;src:url(/cf-fonts/s/raleway/5.0.16/vietnamese/300/normal.woff2);unicode-range:U+0102-0103,U+0110-0111,U+0128-0129,U+0168-0169,U+01A0-01A1,U+01AF-01B0,U+0300-0301,U+0303-0304,U+0308-0309,U+0323,U+0329,U+1EA0-1EF9,U+20AB;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:400;src:url(/cf-fonts/s/raleway/5.0.16/latin/400/normal.woff2);unicode-range:U+0000-00FF,U+0131,U+0152-0153,U+02BB-02BC,U+02C6,U+02DA,U+02DC,U+0304,U+0308,U+0329,U+2000-206F,U+2074,U+20AC,U+2122,U+2191,U+2193,U+2212,U+2215,U+FEFF,U+FFFD;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:400;src:url(/cf-fonts/s/raleway/5.0.16/cyrillic/400/normal.woff2);unicode-range:U+0301,U+0400-045F,U+0490-0491,U+04B0-04B1,U+2116;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:400;src:url(/cf-fonts/s/raleway/5.0.16/latin-ext/400/normal.woff2);unicode-range:U+0100-02AF,U+0304,U+0308,U+0329,U+1E00-1E9F,U+1EF2-1EFF,U+2020,U+20A0-20AB,U+20AD-20CF,U+2113,U+2C60-2C7F,U+A720-A7FF;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:400;src:url(/cf-fonts/s/raleway/5.0.16/cyrillic-ext/400/normal.woff2);unicode-range:U+0460-052F,U+1C80-1C88,U+20B4,U+2DE0-2DFF,U+A640-A69F,U+FE2E-FE2F;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:400;src:url(/cf-fonts/s/raleway/5.0.16/vietnamese/400/normal.woff2);unicode-range:U+0102-0103,U+0110-0111,U+0128-0129,U+0168-0169,U+01A0-01A1,U+01AF-01B0,U+0300-0301,U+0303-0304,U+0308-0309,U+0323,U+0329,U+1EA0-1EF9,U+20AB;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:500;src:url(/cf-fonts/s/raleway/5.0.16/cyrillic-ext/500/normal.woff2);unicode-range:U+0460-052F,U+1C80-1C88,U+20B4,U+2DE0-2DFF,U+A640-A69F,U+FE2E-FE2F;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:500;src:url(/cf-fonts/s/raleway/5.0.16/cyrillic/500/normal.woff2);unicode-range:U+0301,U+0400-045F,U+0490-0491,U+04B0-04B1,U+2116;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:500;src:url(/cf-fonts/s/raleway/5.0.16/latin/500/normal.woff2);unicode-range:U+0000-00FF,U+0131,U+0152-0153,U+02BB-02BC,U+02C6,U+02DA,U+02DC,U+0304,U+0308,U+0329,U+2000-206F,U+2074,U+20AC,U+2122,U+2191,U+2193,U+2212,U+2215,U+FEFF,U+FFFD;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:500;src:url(/cf-fonts/s/raleway/5.0.16/latin-ext/500/normal.woff2);unicode-range:U+0100-02AF,U+0304,U+0308,U+0329,U+1E00-1E9F,U+1EF2-1EFF,U+2020,U+20A0-20AB,U+20AD-20CF,U+2113,U+2C60-2C7F,U+A720-A7FF;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:500;src:url(/cf-fonts/s/raleway/5.0.16/vietnamese/500/normal.woff2);unicode-range:U+0102-0103,U+0110-0111,U+0128-0129,U+0168-0169,U+01A0-01A1,U+01AF-01B0,U+0300-0301,U+0303-0304,U+0308-0309,U+0323,U+0329,U+1EA0-1EF9,U+20AB;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:700;src:url(/cf-fonts/s/raleway/5.0.16/cyrillic-ext/700/normal.woff2);unicode-range:U+0460-052F,U+1C80-1C88,U+20B4,U+2DE0-2DFF,U+A640-A69F,U+FE2E-FE2F;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:700;src:url(/cf-fonts/s/raleway/5.0.16/latin-ext/700/normal.woff2);unicode-range:U+0100-02AF,U+0304,U+0308,U+0329,U+1E00-1E9F,U+1EF2-1EFF,U+2020,U+20A0-20AB,U+20AD-20CF,U+2113,U+2C60-2C7F,U+A720-A7FF;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:700;src:url(/cf-fonts/s/raleway/5.0.16/latin/700/normal.woff2);unicode-range:U+0000-00FF,U+0131,U+0152-0153,U+02BB-02BC,U+02C6,U+02DA,U+02DC,U+0304,U+0308,U+0329,U+2000-206F,U+2074,U+20AC,U+2122,U+2191,U+2193,U+2212,U+2215,U+FEFF,U+FFFD;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:700;src:url(/cf-fonts/s/raleway/5.0.16/cyrillic/700/normal.woff2);unicode-range:U+0301,U+0400-045F,U+0490-0491,U+04B0-04B1,U+2116;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:700;src:url(/cf-fonts/s/raleway/5.0.16/vietnamese/700/normal.woff2);unicode-range:U+0102-0103,U+0110-0111,U+0128-0129,U+0168-0169,U+01A0-01A1,U+01AF-01B0,U+0300-0301,U+0303-0304,U+0308-0309,U+0323,U+0329,U+1EA0-1EF9,U+20AB;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:800;src:url(/cf-fonts/s/raleway/5.0.16/cyrillic/800/normal.woff2);unicode-range:U+0301,U+0400-045F,U+0490-0491,U+04B0-04B1,U+2116;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:800;src:url(/cf-fonts/s/raleway/5.0.16/latin/800/normal.woff2);unicode-range:U+0000-00FF,U+0131,U+0152-0153,U+02BB-02BC,U+02C6,U+02DA,U+02DC,U+0304,U+0308,U+0329,U+2000-206F,U+2074,U+20AC,U+2122,U+2191,U+2193,U+2212,U+2215,U+FEFF,U+FFFD;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:800;src:url(/cf-fonts/s/raleway/5.0.16/latin-ext/800/normal.woff2);unicode-range:U+0100-02AF,U+0304,U+0308,U+0329,U+1E00-1E9F,U+1EF2-1EFF,U+2020,U+20A0-20AB,U+20AD-20CF,U+2113,U+2C60-2C7F,U+A720-A7FF;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:800;src:url(/cf-fonts/s/raleway/5.0.16/vietnamese/800/normal.woff2);unicode-range:U+0102-0103,U+0110-0111,U+0128-0129,U+0168-0169,U+01A0-01A1,U+01AF-01B0,U+0300-0301,U+0303-0304,U+0308-0309,U+0323,U+0329,U+1EA0-1EF9,U+20AB;font-display:swap;}@font-face {font-family:Raleway;font-style:normal;font-weight:800;src:url(/cf-fonts/s/raleway/5.0.16/cyrillic-ext/800/normal.woff2);unicode-range:U+0460-052F,U+1C80-1C88,U+20B4,U+2DE0-2DFF,U+A640-A69F,U+FE2E-FE2F;font-display:swap;}</style>
        
            <link rel="stylesheet" href="remita-files/external-base-bundle.min.css">
        
            <link rel="stylesheet" href="remita-files/view-rrr-details-bundle.min_002.css">
        
        

        <link href="remita-files/font-awesome.min.css" rel="stylesheet" integrity="sha384-wvfXpqpZZVQGK6TAh5PVlGOfQNHSoD2xbE+QkPxCAFlNEevoEH3Sl0sibVcOQVnN" crossorigin="anonymous">
              <link href="remita-files/toastr.min.css" rel="stylesheet">

        <!--[if IE]>
        <script src="http://css3-mediaqueries-js.googlecode.com/svn/trunk/css3-mediaqueries.js"></script>
        <![endif]-->
        <!-- Global site tag (gtag.js) - Google Analytics -->
        <script type="text/javascript" async="" src="remita-files/analytics.js"></script><script type="text/javascript" async="" src="remita-files/js_002"></script><script async="" src="remita-files/js"></script>
        <script>
            window.dataLayer = window.dataLayer || [];

            function gtag() {
                dataLayer.push(arguments);
            }

            gtag('js', new Date());

            gtag('config', 'UA-109989744-1');
        </script>
    </head>

    <body>
        <div class="row" style="width:100%; margin:0 auto;">
            <div class="col-12 col-md-8" style="margin:0 auto; padding-right:0; padding-left:0;">
                <div class="view-receipt-page-wrapper">
<div class="water-mark remita-logo"></div>
<div class="water-mark-collector-name">
    <p class="text-center text-uppercase">HEALTH RECORDS OFFICERS REGISTRATION BOARD OF NIGERIA</p>
</div>
<div class="">
    <div class="company-details">
        <p class="company-name text-center">HEALTH RECORDS OFFICERS REGISTRATION BOARD OF NIGERIA</p>
    </div>

    <div class="receipt-section--rrr-inbbfo" align="center">
        <div class="rrr-details" >
            <div class="rrr-details-wrapper" >
                <span class="receipt-type-label">e-Report</span>
                <span class="payment-date">Generated On <?php echo date("d M, Y"); ?></span>
            </div>
            <p class="text-center rrr-label">Credited Account Number</p>
            <p class="rrr-number text-center">2301-1686-1017</p>
            <p class="text-center">Central Bank of Nigeria</p>
        </div>
    </div>


    <!-- BILLER INFORMATION -->
      <div class="info-section-wrapper rrr-biller-information">
          <p class="section-title">Biller Information</p>
          <div>
              <div class="info-row">
                  <span class="label-section">Name</span>
                  <span class="label-value" style="font-weight:bold;">HEALTH RECORDS OFFICERS REGISTRATION BOARD OF NIGERIA</span>
              </div>
              <div class="info-row">
                  <span class="label-section">Address</span>
                  <span class="label-value">C/O LAGOS UNIVERISTY TEACHING HOSPITAL, HARVY ROAD, YABA LAGOS</span>
              </div>
              <div class="info-row">
                  <span class="label-section">Phone Number</span>
                  <span class="label-value"></span>
              </div>
              <div class="info-row">
                  <span class="label-section">Email</span>
                  <span class="label-value"></span>
              </div>
              <div class="info-row">
                  <span class="label-section">Tax Number (TIN)</span>
                  <span class="label-value">10559960-0001</span>
              </div>
          </div>
      </div>

    <!-- PAYER INFORMATION SECTION -->
    

      <div class="info-section-wrapper sp-items-wrapper">
          <p class="section-title">Payment Details</p>
          <div class="table-responsive">
              <table class="table table-striped">
                  <thead>
                    <tr>
                         <th>Description</th>
                         <th></th>
                         <th class="text-right">Registered Candidates</th>
                    </tr>
                  </thead>
                  <tbody>
                      <?php
                       foreach($statisticData as $row){
                                $monthYearReg = $row[0]['month'].", ".$row[0]['year'];
                                $totalReg =  $row[0]['numberOfStudents']+$row[1]['numberOfStudents'];
                      ?>
                      <tr>
                          <td>
                              Being number of candidates paid in respect of <?php echo $monthYearReg; ?> Examination
                          </td>
                          <td></td>
                          <td class="text-right">
                              <?php echo number_format($row[0]['numberOfStudents']); ?>
                          </td>
                      </tr>
                      <?php
                       }
                      ?>
                      
                      <!--<tr>-->
                      <!--    <td>-->
                      <!--      <span style="font-size:.8rem;">Total amount in words</span> <br>-->
                      <!--      <strong>Four thousand Six Hundred Sixty-One Naira Twenty-Five Kobo Only</strong>-->
                      <!--    </td>-->
                      <!--    <td class="font-weight-bold">Total</td>-->
                      <!--    <td class="text-right font-weight-bold">4,661.25</td>-->
                      <!--</tr>-->
                  </tbody>
              </table>
          </div>
        </div>

    <!-- BILLER REQUIRED INFORMATION -->

    <!--<p class="additional-msg"><span class="important-text">*</span> Additional Charges May Apply Depending on Channel of Payment.</p>-->
    <p class="additional-msg"><span class="important-text">*</span> You can visit <a href="https://remita.net/">www.remita.net</a> You 
can also download the Remita App at Playstore and iOS store for future 
end-to-end processing and proper tracking of all your transactions.</p>
</div>
<div class="water-mark collector-name"></div>
</div>

                
                    <div class="button-wrapper text-center">
                      <button class="print btn btn-lg btn-success">
                        
                            
                            
                                Print Report
                            
                        
                      </button>
                    </div>
                
            </div>
        </div>

        










<script src="remita-files/polyfills.module.bundle.js"></script>

	<script src="remita-files/page-scripts-release-bundle.min.js"></script>





	















<script type="text/javascript" src="remita-files/handlebars-module-bundle.min.js"></script>



<script type="text/javascript" src="remita-files/jquery.numeric.js"></script>
<script type="text/javascript" src="remita-files/messages_en.js"></script>
<script type="text/javascript" src="remita-files/message-bundle_en.js"></script>
<script type="text/javascript" src="remita-files/sprintf.js"></script>


	<script type="text/javascript" src="remita-files/hashtable.js"></script>
	<script type="text/javascript" src="remita-files/jquery.numberformatter-1.2.3.js"></script>
	<script type="text/javascript" src="remita-files/specsMoneyUtil.js"></script>
	<script type="text/javascript">
        (function() {
            specsMoneyUtil.init({
                currencySymbol: "&#x20A6;",
                currencyName: "Naira",
                currencyKoboName: "Kobo"
            });
        })();
	</script>



<script type="text/javascript" src="remita-files/frame-manager-release.js"></script>


        <script type="text/javascript">
            var PAGE_SETTINGS = {
                status: 'H',
                receiptUrl: 'https://login.remita.net/remita/exapp/api/v1',
                additionalChargesMayApplyMsg: 'Additional Charges May Apply Depending on Channel of Payment.',
                contextPath: "/remita",
                transactionDetails: ''
            };
        </script>
        
        
            <script src="remita-files/external-base-bundle.min.js"></script>
        
            <script src="remita-files/view-rrr-details.module.bundle.js"></script>
        
        <script src="remita-files/message-bundle_en.js"></script>
        
        
    


</body></html>