File Manager

✏️ Edit File: /home/coemyoza/public_html/portal/admin/payment_schedule.php

<?php include "header.php"?>
        
        <div class="main-panel">
          <div class="content-wrapper">
          <div class="page-header flex-wrap">
              <div class="header-left">
              <h3 class="page-title">Payment Schedule </h3>
              </div>
              <div class="header-right d-flex flex-wrap mt-2 mt-sm-0">
                <div class="d-flex align-items-center">
                  <a href="#">
                    <p class="m-0 pe-3"> <i class="mdi mdi-currency-ngn menu-icon"></i> Payment Schedule</p>
                  </a>
                  <a class="ps-3 me-4" href="#">
                    <p class="m-0">Page</p>
                  </a>
                </div>
              </div>
            </div>
            <div class="row">
              <div class="col-12">
                <div class="card">
                  <div class="card-body">
                  <div class="row">
                    <center><button class="btn btn-primary pull-center" data-bs-toggle="modal" data-bs-target="#exampleModal-4"><b>Add Payment</b> <i class=" mdi mdi-plus "></i></button></center>
                      </div>
                      
                    <h4 class="card-title">List</h4>
                    <div class="row overflow-auto">
                      <div class="col-12">
                      <?php  
                      if(isset($_POST["schedulebtn"]))
                      {
                        $progv = $_POST["prog_id"];
                        // Split the string into an array using the hyphen as the delimiter
                        $parts = explode('-', $progv);
                        // Assign the values to individual variables
                        $school_id = $parts[0];
                        $dept_id = $parts[1];
                        $prog_id = $parts[2];
                        $level = $_POST["level"];
                        $category = $_POST["category"];
                        $session = $_POST["session"];
                        $semester = $_POST["semester"];
                        $amountind = $_POST["amountind"];
                        $amountnon = $_POST["amountnon"];

$payexist = $pdo->query("SELECT id FROM `payment_schedule` WHERE `prog_id`=? AND `category`=? AND `session`=? AND `semester`=? AND `level`=?");
                        if($payexist->rowcount() == 0){
                        $addsched = $pdo->prepare("INSERT INTO `payment_schedule`(`school_id`, `dept_id`, `prog_id`, `category`, `session`, `semester`, `level`, `amount_indigene`, `amount_nonindigene`) VALUES (?,?,?,?,?,?,?,?,?)");
                        $addsched->execute([$school_id,$dept_id,$prog_id,$category,$session,'1,2',$level,$amountind,$amountnon]);
		                    echo '<div class="alert alert-info">record added!!</div><script>setTimeout(function(){location.href="payment_schedule"},10000)</script>';
                        }
                        else
                        {
		                    echo '<div class="alert alert-info">record already exist!!</div><script>setTimeout(function(){location.href="payment_schedule"},10000)</script>';
                        }

}
                      if(isset($_GET["paydl"]))
                      {
                        $id = encryptor('decrypt',$_GET["id"]);
                        $paydel = $pdo->query("DELETE FROM `payment_schedule` WHERE `id`='$id'");
		                    echo '<div class="alert alert-danger">record delete!!</div><script>setTimeout(function(){location.href="payment_schedule"},1000)</script>';
                      }
                      $fetchpay = $pdo->prepare("SELECT * FROM `payment_schedule`");
                      $fetchpay->execute(); ?>
                        <table id="order-listing" class="table" cellspacing="0" width="100%">
                          <thead>
                            <tr class="bg-success text-white">
                              <th>SN</th>
                              <th>COMB</th>
                              <th>Type</th>
                              <th>Session</th>
                              <th>Level</th>
                              <th>Semester</th>
                              <th>Amount (Ind)</th>
                              <th>other</th>
                              <th>Action</th>
                            </tr>
                          </thead>
                          <tbody>
                            <?php $sn=0;
                            while($payrow = $fetchpay->fetch()){ $sn++;
                           // $abvp = $pdo->query("SELECT `abv` FROM `programmes` WHERE `prog_id` = '".$payrow["prog_id"]."'");
                            //$prgabv=$abvp->fetch();

?>
                            <tr>
                              <td><?php echo $sn;?></td>
                              <td><?php echo $payrow["prog_code"];?></td>
                              <td><?php echo $payrow["category"];?></td>
                              <td><?php echo $payrow["session"];?></td>
                              <td><?php echo $payrow["level"];?></td>
                              <td><?php echo $payrow["semester"];?></td>
                              <td><?php echo $payrow["amount_indigene"];?></td>
                              <td><?php echo $payrow["other_charges"];?></td>
                              <td class="text-right">
                                <button class="btn btn-light" data-bs-toggle="modal" data-bs-target="#EditModal<?php echo $sn;?>">
                                  <i class="mdi mdi-eye text-primary"></i> Detail </button>                                
                                  
                                    <div class="modal fade" id="EditModal<?php echo $sn;?>" tabindex="-1" role="dialog" aria-labelledby="ModalLabel" aria-hidden="true">
                                      <div class="modal-dialog" role="document">
                                        <div class="modal-content">
                                          <div class="modal-header">
                                            <h5 class="modal-title" id="ModalLabel"> Payment Details</h5>
                                            <button type="button" class="close" data-bs-dismiss="modal" aria-label="Close">
                                              <span aria-hidden="true">&times;</span>
                                            </button>
                                          </div>
                                          <div class="modal-body">
                                           <p> School: <?php echo @$payrow["school_id"];?></p>
                                           <p> Department: <?php echo @$payrow["dept_id"];?></p>
                                           <p> Programme: <?php echo @$payrow["prog_id"];?></p>
                                            <hr>
                                           Fee Type:  <?php echo $payrow["category"];?><br>
                                            Session: <?php echo $payrow["session"];?><br>
                                            Semester: <?php echo $payrow["semester"];?><br>
                                            Level: <?php echo $payrow["level"];?><br>
                                           <hr> 
                                           Amount for Indigene: <?php echo $payrow["amount_indigene"];?>
                                          <p> Transaction ID: <?php echo $payrow["amount_nonindigene"];?></p>
                                          </div>
                                          <div class="modal-footer">
                                            <a href="?paydl=&id=<?php echo encryptor('encrypt',$payrow["id"]);?>" class="btn"><i class=" mdi mdi-delete text-danger"></i>Delete</a>
                                            <button type="button" class="btn btn-warning" data-bs-dismiss="modal">Close</button>
                                          </div>
                                        </div>
                                      </div>
                                    </div>
                                  
                                
                              </td>
                            </tr>
                            <?php }?>
                          </tbody>
                        </table>
                      </div>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
                
         
                    <div class="modal fade" id="exampleModal-4" tabindex="-1" role="dialog" aria-labelledby="ModalLabel" aria-hidden="true">
                      <div class="modal-dialog" role="document">
                        <div class="modal-content">
                          <div class="modal-header">
                            <h5 class="modal-title" id="ModalLabel">Add New Payment</h5>
                            <button type="button" class="close" data-bs-dismiss="modal" aria-label="Close">
                              <span aria-hidden="true">&times;</span>
                            </button>
                          </div>
                          <div class="modal-body">
                          <form method="post" name="scehduefee">
                              <div class="row">
                                <div class="col-8">
                              <div class="form-group">
                                <label for="recipient-name" class="col-form-label">Course Comnination:</label>
                                <select type="text" name="prog_id" class="form-control">
                                    <option>Choose</option>
                                    <?php 
                                    $getprg = $pdo->query("SELECT * FROM `programmes`");
                                    while($fndprg = $getprg->fetch()){
                                      echo '<option value="'.$fndprg["school_id"].'-'.$fndprg["dept_id"].'-'.$fndprg["prog_id"].'">'.$fndprg["abv"].'-'.$fndprg["programme"].'</option>'; }                             
                                    ?>
                                </select>
                              </div>
                              </div>
                              <div class="col-4">
                              <div class="form-group">
                                <label for="recipient-name" class="col-form-label">Category:</label>
                                <select type="text" name="category" class="form-control">
                                    <option selected value="">Choose</option>
                                    <option>ALL</option>
                                    <option>Application fee</option>
                                    <option>Acceptance fee</option>
                                    <option>School Fees</option>
                                    <option>Screening fee</option>
                                    <option>Late Registration</option>
                                </select>
                              </div>
                              </div>
                              <div class="col-4">
                              <div class="form-group">
                                <label for="recipient-name" class="col-form-label">Session:</label>
                                <select type="text" name="session" class="form-control">
                                    <option selected value="">Choose</option>
                                    <option>2023/2024</option>
                                    <option>2024/2025</option>
                                    <option>2025/2026</option>
                                    <option>2026/2027</option>
                                </select>
                              </div>
                              </div>
                              <div class="col-4">
                              <div class="form-group">
                                <label for="recipient-name" class="col-form-label">Level:</label>
                                <select type="text" name="level" class="form-control">
                                    <option selected value="">Choose</option>
                                    <option>PRENCE</option>
                                    <option>100</option>
                                    <option>200</option>
                                    <option>300</option>
                                    <option>SPILL</option>
                                </select>
                              </div>
                              </div>
                              <div class="col-4">
                              <div class="form-group">
                                <label for="recipient-name" name="occupied" class="col-form-label">Semester:</label>
                                <select type="text" name="semester" class="form-control">
                                    <option>Choose</option>
                                    <option>1</option>
                                    <option>2</option>
                                    <option>3</option>
                                </select>
                              </div>
                              </div>
                              
                              <div class="col-6">
                              <div class="form-group">
                                <label for="recipient-name" class="col-form-label">Amount (Indigene):</label>
                                <input type="number" class="form-control" name="amountind">
                              </div>
                              </div>
                              
                              <div class="col-6">
                              <div class="form-group">
                                <label for="recipient-name" class="col-form-label">Amount (Non-indigene):</label>
                                <input type="number" class="form-control" name="amountnon">
                              </div>
                              </div>
                              </div>
                            <div class="modal-footer">
                              <button type="submit" class="btn btn-success" name="schedulebtn">Submit</button>
                              <button type="button" class="btn btn-warning" data-bs-dismiss="modal">Close</button>
                            </div>
                            </form>
                          </div>
                        </div>
                      </div>
                    </div>
                
         <?php include "footer.php"?>

Batal

⬅ Naik ke portal 72 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁assets	dir	—	2024-07-21 13:45	📂 Buka
📁demo_1	dir	—	2024-07-21 13:45	📂 Buka
🐘-add-staff.php	php	12.5 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘-add_courses.php	php	12.3 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘-allocat_page.php	php	12.2 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘-allocate_c.php	php	3.5 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘-courses.php	php	15.3 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘-my_course.php	php	4.1 KB	2024-07-21 13:45	✏️ Edit 👁️ View
📄.DS_Store	ds_store	10 KB	2024-07-21 13:45	✏️ Edit 👁️ View
📄.htaccess	htaccess	361 B	2024-07-21 13:45	✏️ Edit 👁️ View
🐘accommodation.php	php	3.7 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘add-staff.php	php	12.7 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘add-user.php	php	9.7 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘add_courses.php	php	12.2 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘add_scores.php	php	7.8 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘add_student.php	php	702 B	2025-02-18 18:32	✏️ Edit 👁️ View
🐘admitted.php	php	12.2 KB	2026-01-06 09:48	✏️ Edit 👁️ View
🐘allocat_page.php	php	12.1 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘allocate_c.php	php	3.5 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘app_change_programme.php	php	22.1 KB	2026-01-06 10:07	✏️ Edit 👁️ View
🐘appl_download.php	php	5.3 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘applicant.php	php	15.1 KB	2025-01-22 06:26	✏️ Edit 👁️ View
🐘applicant_list_dwnld.php	php	701 B	2024-07-21 13:45	✏️ Edit 👁️ View
🐘changehostel.php	php	13.3 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘courses.php	php	15.3 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘entered_scores.php	php	6.1 KB	2024-07-21 13:45	✏️ Edit 👁️ View
📄error_log	file	5 MB	2026-04-21 10:58	✏️ Edit 👁️ View
🐘footer.php	php	2.9 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘give_offer.php	php	75 B	2024-07-21 13:45	✏️ Edit 👁️ View
🐘header.php	php	8.1 KB	2025-04-01 10:24	✏️ Edit 👁️ View
🐘header_copy.php	php	8.4 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘hostel.php	php	20.4 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🖼️idacrd100.jpeg	jpeg	138.2 KB	2026-04-06 18:34	✏️ Edit 👁️ View
🖼️idcard.jpeg	jpeg	139.3 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘idcard.php	php	10.4 KB	2026-04-06 18:43	✏️ Edit 👁️ View
🖼️idcard100back.jpeg	jpeg	100.7 KB	2026-04-06 18:34	✏️ Edit 👁️ View
🖼️idcard_back.jpeg	jpeg	114.9 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘idcard_detail.php	php	3.7 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘idcard_detail_100.php	php	4.3 KB	2026-04-06 18:55	✏️ Edit 👁️ View
🐘idcard_details_new.php	php	3.9 KB	2025-04-14 21:07	✏️ Edit 👁️ View
🐘idcard_old.php	php	4.7 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🖼️idcards.jpeg	jpeg	123.1 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘index.php	php	4.8 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘my_course.php	php	4 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘payment.php	php	12.9 KB	2025-01-22 06:42	✏️ Edit 👁️ View
🐘payment_schedule.php	php	15.2 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘profile.php	php	6.1 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🖼️profile_image.jpg	jpg	93.8 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘programmes.php	php	15 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘registered_stnd_list.php	php	5.7 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘report.php	php	23.1 KB	2025-11-10 16:54	✏️ Edit 👁️ View
🐘report_applicant_list.php	php	4.5 KB	2024-11-27 05:42	✏️ Edit 👁️ View
🐘report_course_list.php	php	3.8 KB	2025-11-10 17:00	✏️ Edit 👁️ View
🐘report_payment_list.php	php	4.5 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘report_schedule_list.php	php	4 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘report_student_list.php	php	3.8 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘screening.php	php	7.4 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘setup.php	php	28.5 KB	2025-04-23 08:21	✏️ Edit 👁️ View
🐘sidebar_acadsec.php	php	2.1 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘sidebar_admin.php	php	5.2 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘sidebar_admin_copy.php	php	1.6 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘sidebar_bursary.php	php	1.4 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘sidebar_examoffice.php	php	1.9 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘sidebar_main.php	php	6.8 KB	2024-07-21 13:49	✏️ Edit 👁️ View
🐘sidebar_staff.php	php	1.4 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘sidebar_studentsaffair.php	php	4.3 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘staff.php	php	19.7 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘student.php	php	9.2 KB	2025-02-18 18:31	✏️ Edit 👁️ View
🐘student0.php	php	6.8 KB	2025-02-18 18:14	✏️ Edit 👁️ View
🐘student_data.php	php	17.1 KB	2024-10-09 06:23	✏️ Edit 👁️ View
🐘user.php	php	3.5 KB	2024-07-21 13:45	✏️ Edit 👁️ View
🐘user_privilege.php	php	10.1 KB	2024-07-21 13:45	✏️ Edit 👁️ View