File "financial.php"

Full path: /var/www/krbed.in/application618/views/financial.php
File size: 1.27 KiB (1297 bytes)
MIME-type: text/html
Charset: utf-8

Download   Open   Back

<div class="col1">
	<h2 class="hpad">Financial Details
	</h2>
	<h5 class="blue"><strong></strong></h5>
	<p class="stext">
		<?php
		$this->db->select('c.*,d.financial_type,a.financial_from_year,a.financial_to_year');
		$this->db->from('financial_details c');
		$this->db->join('financial_type d', 'd.financial_type_id =c.financial_type_id', 'left');
		$this->db->join('financial_year a', 'a.financial_year_id =c.financial_year_id', 'left');
		$this->db->group_by('c.financial_year_id');
		$this->db->where('c.status', 1);
		$sql =  $this->db->get();
		if ($sql->num_rows() > 0) {
			foreach ($sql->result_array() as $row) {
				$facilty_details = $row['financial_year_id'];
				$academic_from_year = $row['financial_from_year'];
				$financial_type = $row['financial_type'];
				$academic_to_year = $row['financial_to_year'];
		?>
				<a href="<?php echo base_url("additional/financialdetail/$facilty_details"); ?>" style="color:#3b8dcf;">Click here to view the financial details (<?php echo $academic_from_year ?> - <?php echo $academic_to_year ?>) </a> <br>
		<?php  }
		}  ?>
	</p>
</div>
<div class="col2">
	<?php $this->load->view('include/req_form'); ?>
	<div class="rtab">
		<?php $this->load->view('include/stud_navi'); ?>
	</div>
	<?php $this->load->view('include/clg_gallery'); ?>
</div>