.-.-.-.-.-

<?php defined('BASEPATH') or exit('No direct script access allowed');
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Csv;

class Fees_payment extends CI_Controller
{
    public function __construct()
    {
        parent::__construct();
        isLoggedIn();
        $this->load->model('fees_payment/Fees_payment_model');
        $this->load->model('college/College_model');

}

public function index()
    {
        if(hasPermission('fees_payment_create')){

$student_name = $this->Fees_payment_model->getStudents();
        $academic_year = $this->Fees_payment_model->getAcademic()->result_array();
        $page_data['page_title'] = 'Fees Payment';
        $page_data['page_name'] = 'admin/fees_payment/fees_payment';
        $page_data['student_name'] = $student_name;
        $page_data['academic_year'] = $academic_year;

$this->load->view('admin/template', $page_data);
    }else{
        redirect(base_url('dashboard'));
    
    }
    }
    //excel
   
    function fees_payment_excel_report()

{
        
        $ad_id = $this->input->post('id');
        $first_yr = $this->input->post('first_yr');
        $sec_yr = $this->input->post('sec_yr');
        $ec_yr = $this->input->post('ec_yr');
        $tt_yr = $this->input->post('tt_yr');
        $note = $this->input->post('note');

// print_r($ad_id);
        // $ad_id =416;
        if ($ad_id==''){
            $ad_id = $this->uri->segment(3);
            $first_yr = $this->uri->segment(4);
            $sec_yr = $this->uri->segment(5);
            $ec_yr = $this->uri->segment(6);
            $tt_yr = $this->uri->segment(7);
            $note = $this->uri->segment(8);
            
        }
      
       
$lists = $this->Fees_payment_model->getData($ad_id)->result_array();
$exceldata = array();

foreach ($lists as $list) {
$row = array();

// $stu_id = $list['stu_id'];
$student_name_english =ucwords($list['student_name_english']);
$date_birth = date('d-m-Y',strtotime($list['date_birth']));
$academic_from_year = ($list['academic_from_year']);
$academic_to_year = ($list['academic_to_year']);
$course = ($list['course_name']);

$ex_row = array();

// $ex_row[] = $stu_id;
$ex_row[] = $student_name_english;
$ex_row[] = $date_birth;
$ex_row[] = $academic_from_year . ' - ' . $academic_to_year;

$ex_row[] = $course;

$ex_row[] = $first_yr;
$ex_row[] = $sec_yr;
$ex_row[] = $ec_yr;
$ex_row[] = $tt_yr;
$ex_row[] = ucFirst(str_replace("%20"," ",$note));

$exceldata[] =  $ex_row;

}

$excel_report_title = "Fees Payment";
$spreadsheet = new Spreadsheet();

//Set document properties
$spreadsheet->getProperties()->setCreator("Technogenesis")
               ->setLastModifiedBy("Technogenesis")
               ->setTitle("Fees Payment Details")
               ->setSubject("Fees Payment Details")
               ->setDescription("Fees Payment Details")
               ->setKeywords("Fees Payment Details")
               ->setCategory("Fees Payment Details");

$spreadsheet->getProperties()->setCreator("technogenesis.in")
               ->setLastModifiedBy("Technognesis");

$spreadsheet->setActiveSheetIndex(0);

$sheet = $spreadsheet->getActiveSheet();

$sheet->setTitle($excel_report_title);

$sheet->setCellValue('A1', 'Name');
$sheet->setCellValue('B1', 'DOB');
$sheet->setCellValue('C1', 'Academic Year');
$sheet->setCellValue('D1', 'Course');
$sheet->setCellValue('E1', 'First Year Balance Amount');
$sheet->setCellValue('F1', 'Second Year Balance Amount');
$sheet->setCellValue('G1', 'Extra Balance Amount');
$sheet->setCellValue('H1', 'Total Balance Amount');
$sheet->setCellValue('I1', 'Notes');

$conditional1 = new \PhpOffice\PhpSpreadsheet\Style\Conditional();
$conditional1->setConditionType(\PhpOffice\PhpSpreadsheet\Style\Conditional::CONDITION_CELLIS);
$conditional1->setOperatorType(\PhpOffice\PhpSpreadsheet\Style\Conditional::OPERATOR_LESSTHAN);
$conditional1->addCondition('0');
$conditional1->getStyle()->getFont()->getColor()->setARGB(\PhpOffice\PhpSpreadsheet\Style\Color::COLOR_RED);
$conditional1->getStyle()->getFont()->setBold(true);

$conditionalStyles = $spreadsheet->getActiveSheet()->getStyle('B2')->getConditionalStyles();
$conditional1->getStyle('A1')->getAlignment()->setHorizontal(\PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER);
//make the font become bold
$conditional1->getStyle('A2')->getFont()->setBold(true);
$conditional1->getStyle('A1')->getFont()->setBold(true);
$conditional1->getStyle('B1')->getFont()->setBold(true);
$conditional1->getStyle('C3')->getFont()->setBold(true);
$conditional1->getStyle('D3')->getFont()->setBold(true);
$conditional1->getStyle('E3')->getFont()->setBold(true);
$conditional1->getStyle('F3')->getFont()->setBold(true);
$conditional1->getStyle('A3')->getFont()->setSize(16);
$conditional1->getStyle('A3')->getFill()->getStartColor()->setARGB('#333');

//make the font become bold
$sheet->getStyle('A1')->getFont()->setBold(true);
$sheet->getStyle('A1')->getFont()->setSize(16);
$sheet->getStyle('A1')->getFill()->getStartColor()->setARGB('#333');

for($col = ord('A'); $col <= ord('F'); $col++){ //set column dimension
$sheet->getColumnDimension(chr($col))->setAutoSize(true);
}
// print_r($exceldata);
$sheet->fromArray($exceldata, null, 'A2');

$writer = new Csv($spreadsheet);
$filename ="$student_name_english $date_birth";

header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="'. $filename .'.csv"'); 
header('Cache-Control: max-age=0');
// alert();
$writer->save('php://output'); // download file 
// exit;
// ($sheet) ? true : false ;
// echo  json_encode(array('id' => $ad_id));  
$result =true;
// echo json_encode(array('rs' => $result,'id' => $ad_id));
}
   
public function payment_pop(){

$ad_id = $this->input->post('id');
        $academic = $this->input->post('academic');

$pay_his_data = $this->Fees_payment_model->getPaymentHistory($ad_id,$academic);
        $callsHtmal = $this->Fees_payment_model->getTransHtml($ad_id,$academic);

echo  json_encode(array('res' => $callsHtmal));

}

public function extra_pop(){

$ad_id = $this->input->post('id');

$callsHtmal = $this->Fees_payment_model->getAllExtraFeesHtml($ad_id);

echo  json_encode(array('res' => $callsHtmal));

}
public function add(){
    if(hasPermission('fees_payment_create')){
    $course_id = $this->uri->segment(3);
      if($course_id!=''){
      $get_clg_id = $this->College_model->get_clg_idByCourseId($course_id);
      $c_id = $get_clg_id['college_id'];
      $this->session->set_userdata('college_id', $c_id);
      $this->session->set_userdata('course_id', $course_id);
      }
      $course = $this->session->userdata('course_id');
      $academic = $this->session->userdata('academic_id');
      $student_name = $this->Fees_payment_model->getStudents();
      $academic_year = $this->Fees_payment_model->getAcademic()->result_array();
    //   print_r($academic_year);
      $payment_mode = $this->Fees_payment_model->getPaymentmode()->result_array();
      $page_data['page_title'] = 'Fees Payment';
      $page_data['page_name'] = 'admin/fees_payment/fees_payment';
      $page_data['student_name'] = $student_name;
      $page_data['academic_year'] = $academic_year;
      $page_data['payment_mode'] = $payment_mode;
      if ($course > 0){
           $this->load->view('admin/template', $page_data);
      } else {
          set_alert('warning', "Please select the course.");
          redirect(base_url('dashboard'));
      }
  
}else{
    redirect(base_url('dashboard'));

}
        }
    public function getPayDeatils()
    {
        $college_id = $this->session->userdata('college_id');
        
        $course_id = $this->session->userdata('course_id');
        $academic_id = $this->session->userdata('academic_id');
        $ad_id = $this->input->post('id');
$academic_year_checkbox = $this->input->post('id');
        $yera_id = $this->input->post('yera_id');
        
        $stu_id = $this->input->post('stu_id');
        $recFirstGeneralBal = $this->Fees_payment_model->getPayDeatilsGeneral($stu_id, 1)->row_array();
        $resSecGeneralBal = $this->Fees_payment_model->getPayDeatilsGeneral($stu_id, 2)->row_array();

//get arrear fees for student
        $resarrearFeesForStudent = $this->Fees_payment_model->resarrearFeesForStudent($stu_id)->row_array();
        $resArrearAmt=0;
        $resArrearPaidAmt=0;
        if(!empty($resarrearFeesForStudent)){
          $resArrearAmt = $resarrearFeesForStudent['tot_amt'];
        }
          $resarrearPaidFeesForStudent = $this->Fees_payment_model->resarrearPaidFeesForStudent($stu_id)->row_array();
          if(!empty($resarrearPaidFeesForStudent)){
          $resArrearPaidAmt = $resarrearPaidFeesForStudent['paid_amt'];
          }
$arrearAmt = 0;
if($resArrearAmt!=$resArrearPaidAmt){
    $arrearAmt = $resArrearAmt-$resArrearPaidAmt;

}

////get scholar amount for student
$resSchFeesForStudentFirst = $this->Fees_payment_model->resSchFeesForStudentFirst($stu_id)->row_array();
$resSchFeesForStudentSec = $this->Fees_payment_model->resSchFeesForStudentSec($stu_id)->row_array();
$schFirst = 0;
if(!empty($resSchFeesForStudentFirst)){
$schFirst = $resSchFeesForStudentFirst['first_yr_sanction_amt'];
}
$schSec = 0;
if(!empty($resSchFeesForStudentSec)){
$schSec = $resSchFeesForStudentSec['sec_yr_sanction_amt'];
}

$tot_sch = $schFirst+$schSec;

$resschPaidFeesForStudent = $this->Fees_payment_model->resschPaidFeesForStudent($stu_id)->row_array();
  $resSchPaidAmt=0;
  if(!empty($resschPaidFeesForStudent)){
  $resSchPaidAmt = $resschPaidFeesForStudent['paid_amt'];
  }
$scholarAmt = 0;
if($tot_sch!=$resSchPaidAmt){
$scholarAmt = $tot_sch-$resSchPaidAmt;

}
$scholarPlusArrearBal = $arrearAmt+$scholarAmt;
$scholarPlusArrearTot = $resArrearAmt+$tot_sch;
$scholarPlusArrearPaid = $resArrearPaidAmt+$resSchPaidAmt;
        $recFirstGeneral = array();

if ($ad_id == 1) {

$recGeneral = $this->Fees_payment_model->getPayDeatilsGeneral($stu_id, $ad_id)->row_array();
            $recExtra = $this->Fees_payment_model->getPayDeatilsExtra($stu_id)->row_array();

} else if ($ad_id == 2) {

$recFirstGeneral = $this->Fees_payment_model->getPayDeatilsGeneral($stu_id, 1)->row_array();
            $recGeneral = $this->Fees_payment_model->getPayDeatilsGeneral($stu_id, $ad_id)->row_array();
            $recExtra = $this->Fees_payment_model->getPayDeatilsExtra($stu_id)->row_array();

} else if($ad_id == 3) {
            $ad_id = 0;
            $recFirstGeneral = $this->Fees_payment_model->getPayDeatilsGeneral($stu_id, 1)->row_array();
            $recGeneral = $this->Fees_payment_model->getPayDeatilsGeneral($stu_id, 2)->row_array();
            $recExtra = $this->Fees_payment_model->getPayDeatilsExtra($stu_id)->row_array();
        }

echo json_encode(array('spab'=>$scholarPlusArrearBal,'spat'=>$scholarPlusArrearTot,'spap'=>$scholarPlusArrearPaid,'recGeneral' => $recGeneral, 'recFirstGeneral' => $recFirstGeneral, 'recExtra' => $recExtra,'recfbal'=>$recFirstGeneralBal,'recsbal'=>$resSecGeneralBal,'checkbox'=>$academic_year_checkbox));

}

public function getPayDeatilsForYear()
    {
        $ad_id = $this->input->post('id');
        $yera_id = $this->input->post('yera_id');
        $term = $this->input->post('term');

if ($ad_id == 1) {
            $curr_year = date("Y");
            $next_year = date("Y", strtotime("+2 year"));
            $acdemic_id = $this->Fees_payment_model->getAcademicYear($curr_year, $next_year)->row_array();

$a_c_id = $acdemic_id['academic_year_id'];

} else if ($ad_id == 2) {

$curr_year = date("Y", strtotime("-1 year"));
            $next_year = date("Y", strtotime("+1 year"));

$acdemic_id = $this->Fees_payment_model->getAcademicYear($curr_year, $next_year)->row_array();

$a_c_id = $acdemic_id['academic_year_id'];
        } else if($ad_id == 3) {
           
            $a_c_id = $yera_id;;
        }
       
        $getStudentName = $this->Fees_payment_model->getStudentName($a_c_id,$term);
  
        echo $getStudentName;

}

public function payment_fees()
    {
        $payCodee  = 0;
        $error_type = '';
        $msg = '';
        $bill_id = '';
        $result = false;

$this->form_validation->set_rules('student_id', 'Student Name', 'trim|required');
        $this->form_validation->set_rules('pay_date', 'Payment Date', 'trim|required');

if ($this->form_validation->run() == false) {
            $error_type = 'v';
            $msg = validation_errors('<p class="error">', '</p>'); //validation_errors();
            $result = false;
        } else {

$created_by = $this->session->userdata('user_id');

$student_id = $this->input->post('student_id');
            $stu_id = $student_id;
            $pay_date = $this->input->post('pay_date');
          
           $payment_date = date('Y-m-d',strtotime($pay_date));

$today_date = date("Y-m-d H:i:s");

$total_amount = $this->input->post('total_amount');
            $gen_pay_amt = $this->input->post('gen_pay_amt');
            $angen_pay_amt = $this->input->post('gen_pay_amt');
            $gen_due_amt = $this->input->post('gen_due_amt');
            $ex_pay_amt = $this->input->post('ex_pay_amt');
            $refer_no = $this->input->post('refer_no');
            $payment_mode_id = $this->input->post('payment_mode_id');
           
            $ex_due_amt = $this->input->post('ex_due_amt');
            if($refer_no == ''){
            $refer_no = $this->input->post('extra_refer_no');
            $payment_mode_id = $this->input->post('extra_payment_mode_id');

}
           
            //  print_r($payment_mode_id);die;
           
         
          
            $conjunction_amt = $this->input->post('conjection_amount');
            $conjunction_amtt = $this->input->post('conjection_amount');
            // $academic_year = $this->input->post('academic_year');
            $academic_year = $this->input->post('year');
          // update procees to admission for payment process
          $paymentdataupdate = array(
            'payment_process' => 1,
          );
            if(!empty($paymentdataupdate)){
             $this->Fees_payment_model->paymentdataupdate($student_id,$paymentdataupdate);
            }

$conjunction_reason = $this->input->post('conjunction_reason');
            $getbill_id=0;
            if ($gen_pay_amt != "") {
                $payCodee  = 1;
                $general_amt = $this->Fees_payment_model->getGenfeesdetalsForStudent($academic_year, $student_id);
                $univgeneral_amt = $this->Fees_payment_model->getGenUnivefeesdetalsForStudent($academic_year, $student_id);

$paidManTotAmt = $this->Fees_payment_model->getPayDeatilsGeneral($student_id, $academic_year)->row_array();
              //$paidManTotAmt = $this->Fees_payment_model->getBalAmtTrans($student_id, $academic_year)->row_array();
                $manageBalAmt = $paidManTotAmt['bamt'];
                $univConAmt = $paidManTotAmt['cnj_amt'];
                //if($univConAmt!=''){

//     $manageBalAmt = $manageBalAmt;
                //}

$paidUnivTotAmt = $this->Fees_payment_model->getPayDeatilsGeneralUniv($student_id, $academic_year)->row_array();

$univBalAmt = $paidUnivTotAmt['bamt'];

$difAmt =  $manageBalAmt -  $univBalAmt;

if($gen_pay_amt>$difAmt){
                   
         
  $balForStudentUniv = $gen_pay_amt-$difAmt; 
                }

else if($gen_pay_amt<$difAmt){
$fnSub = $gen_pay_amt/4;
$balForStudent = $fnSub*3;
$balForStudentUniv = $fnSub;
$angen_pay_amt = $gen_pay_amt;

}
else if($gen_pay_amt==$difAmt){

$balForStudentUniv = $gen_pay_amt;

}

else{
    $angen_pay_amt = $gen_pay_amt;
    $balForStudentUniv = $univBalAmt;

}

// print_r($balForStudentUniv);

if (!empty($general_amt)) {
                    $billtab_data = array(

'admission_id' => $student_id,
                        'tot_amt' => $gen_pay_amt,
                        'bill_date' => $payment_date,
                        'conjunction_amt' => $conjunction_amt,
                        'conjunction_reason' => $conjunction_reason,
                        'fee_year' => $academic_year,
                        'created_on' => $today_date,
                        'payment_date' => $payment_date,
                        'created_by' => $created_by,
                        'reference_no' => $refer_no,
                        'payment_id' => $payment_mode_id,

);

$college_name = $this->session->userdata('college_id');
                    $academic_year_id = $this->session->userdata('academic_id');
                    $getCollegebill = $this->Fees_payment_model->getCollegebill($college_name)->row_array();
                  
                    $getAcademicbill = $this->Fees_payment_model->getAcademicbill($academic_year_id)->row_array();
                  
                    $getbill_id = $this->Fees_payment_model->getbillNo($student_id);
                    $bill_id = $this->Fees_payment_model->insertBill($billtab_data);
 
                    if(date('m') > 03) {
    
                        $d = date('Y-m-d', strtotime('+1 years'));
                       $finyear =  date('Y') .'-'.date('y', strtotime($d));
                      } else {
                       $d = date('Y-m-d', strtotime('-1 years'));
                      $finyear = date('Y', strtotime($d)).'-'.date('y');
                      }

$bill_no = 'KR/' .$getCollegebill['bill_prefix'] ."/". $finyear."/". str_pad($getbill_id, 3, "0", STR_PAD_LEFT);
                    $this->db->where('bill_id', $bill_id)->set('bill_no', $bill_no)->update('bill');
                    $num = $angen_pay_amt;
                    foreach ($general_amt as $gen) {
                        $tot = 0;

if ($num > 0) {
                            $amount = $gen['balance_amt'];
                            $paid_amt = $gen['paid_amt'];

$ad_id = $gen['admission_management_fees_structure_data_id'];
                            if ($num > $amount || $num == $amount) {
                                $getamt = $num - $amount;
                                $bal = 0.00;
                                $pay_amount = $amount;
                                $recent_pay = $paid_amt + $pay_amount;
                                $num = $getamt;
                                $this->db->where('admission_management_fees_structure_data_id', $ad_id)->set('balance_amt', $bal)->update('admission_management_fees_structure_data');
                                $this->db->where('admission_management_fees_structure_data_id', $ad_id)->set('paid_amt', $recent_pay)->update('admission_management_fees_structure_data');

} else if ($num < $amount) {
                                $getamt = $amount - $num;
                                $pay_amount = $num;
                                $recent_pay = $paid_amt + $pay_amount;
                                $this->db->where('admission_management_fees_structure_data_id', $ad_id)->set('balance_amt', $getamt)->update('admission_management_fees_structure_data');
                                $this->db->where('admission_management_fees_structure_data_id', $ad_id)->set('paid_amt', $recent_pay)->update('admission_management_fees_structure_data');
                                $num = 0;
                            }

$this->db->where('admission_management_fees_structure_data_id', $ad_id)->set('payment_mode_id', $payment_mode_id)->update('admission_management_fees_structure_data');

$bill_data = array(

'bill_id' => $bill_id,
                                'admission_management_fees_structure_data_id' => $ad_id,
                                'paid_amt' => $pay_amount,
                                'created_on' => $today_date,
                                'created_by' => $created_by,
                            );
                            if ($pay_amount != 0) {
                                $billdata_id = $this->Fees_payment_model->insertBillData($bill_data);
                            }

}
                    }
                }

// divided from university fees structure 
$numm1 = $balForStudentUniv;
if (!empty($univgeneral_amt)) {

$university_bill_data = array(

'bill_id' => $bill_id,
        'admission_id' => $student_id,
        'tot_amt' => $balForStudentUniv,
        'bill_date' => $payment_date,
        'conjunction_amt' => $conjunction_amt,
        'conjunction_reason' => $conjunction_reason,
        'fee_year' => $academic_year,
        'created_on' => $today_date,
        'payment_date' => $payment_date,
        'created_by' => $created_by,
        'reference_no' => $refer_no,
        'payment_id' => $payment_mode_id,

);

// print_r($university_bill_data);die;
   
    $result = $this->Fees_payment_model->insertUniversityBill($university_bill_data);
    $university_bill_id = $this->db->insert_id();
    // print_r($university_bill_id); die;

foreach ($univgeneral_amt as $gen) {
    $tot = 0;

if ($numm1 > 0) {
        $amount = $gen['balance_amt'];
        $paid_amt = $gen['paid_amt'];

$ad_id = $gen['admission_university_fees_structure_data_id'];
        if ($numm1 > $amount || $numm1 == $amount) {
            $getamt = $numm1 - $amount;
            $bal = 0.00;
            $pay_amount = $amount;
            $recent_pay = $paid_amt + $pay_amount;
            $numm1 = $getamt;
            $this->db->where('admission_university_fees_structure_data_id', $ad_id)->set('balance_amt', $bal)->update('admission_university_fees_structure_data');
            $this->db->where('admission_university_fees_structure_data_id', $ad_id)->set('paid_amt', $recent_pay)->update('admission_university_fees_structure_data');
            // $this->db->where('university_bill_id', $university_bill_id)->set('conjunction_amt', $recent_pay)->update('university_bill');

} else if ($numm1 < $amount) {
            $getamt = $amount - $numm1;
            $pay_amount = $numm1;
          
            $recent_pay = $paid_amt + $pay_amount;
           
            $this->db->where('admission_university_fees_structure_data_id', $ad_id)->set('balance_amt', $getamt)->update('admission_university_fees_structure_data');
            $this->db->where('admission_university_fees_structure_data_id', $ad_id)->set('paid_amt', $recent_pay)->update('admission_university_fees_structure_data');
            // $this->db->where('university_bill_id', $university_bill_id)->set('conjunction_amt', $recent_pay)->update('university_bill');

$numm1 = 0;
        }

$this->db->where('admission_university_fees_structure_data_id', $ad_id)->set('payment_mode_id', $payment_mode_id)->update('admission_university_fees_structure_data');

$university_bill_data = array(

'university_bill_id' => $university_bill_id,
            'admission_university_fees_structure_data_id' => $ad_id,
            'paid_amt' => $pay_amount,
            'created_on' => $today_date,
            'created_by' => $created_by,
        );

if ($pay_amount != 0) {
            $result = $this->Fees_payment_model->insertUniversityBillData($university_bill_data);
        }
   
   
   
    }
}

}
            }

// COMJECTION AMOUNT PROCESS

if($conjunction_amt!=''){
   
// update university amount 
$general_amtc = $this->Fees_payment_model->getGenfeesdetalsForStudent($academic_year, $student_id);

$cnum = $conjunction_amt;
if (!empty($general_amtc)) {
foreach ($general_amtc as $gen) {
    $tot = 0;

if ($cnum > 0) {
        $amount = $gen['balance_amt'];
        $paid_amt = $gen['paid_amt'];

$ad_id = $gen['admission_management_fees_structure_data_id'];
        if ($cnum > $amount || $cnum == $amount) {
            $getamt = $cnum - $amount;
            $bal = 0.00;
            $pay_amount = $amount;
            $recent_pay = $paid_amt + $pay_amount;
            $cnum = $getamt;
            $this->db->where('admission_management_fees_structure_data_id', $ad_id)->set('balance_amt', $bal)->update('admission_management_fees_structure_data');
            $this->db->where('admission_management_fees_structure_data_id', $ad_id)->set('paid_amt', $recent_pay)->update('admission_management_fees_structure_data');

} else if ($cnum < $amount) {
            $getamt = $amount - $cnum;
            $pay_amount = $cnum;
            $recent_pay = $paid_amt + $pay_amount;
            $this->db->where('admission_management_fees_structure_data_id', $ad_id)->set('balance_amt', $getamt)->update('admission_management_fees_structure_data');
            $this->db->where('admission_management_fees_structure_data_id', $ad_id)->set('paid_amt', $recent_pay)->update('admission_management_fees_structure_data');
            $cnum = 0;
        }

}
}

}

$paidUnivTotAmt = $this->Fees_payment_model->getPayDeatilsGeneralUniv($student_id, $academic_year)->row_array();
      $univgeneral_amtt = $this->Fees_payment_model->getGenUnivefeesdetalsForStudent($academic_year, $student_id);

//  print_r($univgeneral_amtt);

$univBalAmt = $paidUnivTotAmt['bamt'];

if($conjunction_amt>$univBalAmt){

$balForStudentUniv = $univBalAmt;
}else if($conjunction_amt<$univBalAmt){
    $balForStudentUniv = $conjunction_amt;

}else if($conjunction_amt==$univBalAmt){
    $balForStudentUniv = $conjunction_amt;
}

else{
    $balForStudentUniv = $univBalAmt;

}

$numm = $balForStudentUniv;

if (!empty($univgeneral_amtt)) {
    
foreach ($univgeneral_amtt as $gen) {
    $tot = 0;

if ($numm > 0) {
        $amount = $gen['balance_amt'];
        $paid_amt = $gen['paid_amt'];

$ad_id = $gen['admission_university_fees_structure_data_id'];
        if ($numm > $amount || $numm == $amount) {
            $getamt = $numm - $amount;
            $bal = 0.00;
            $pay_amount = $amount;
            $recent_pay = $paid_amt + $pay_amount;
            $numm = $getamt;
            $this->db->where('admission_university_fees_structure_data_id', $ad_id)->set('balance_amt', $bal)->update('admission_university_fees_structure_data');
            $this->db->where('admission_university_fees_structure_data_id', $ad_id)->set('paid_amt', $recent_pay)->update('admission_university_fees_structure_data');

} else if ($numm < $amount) {
            $getamt = $amount - $numm;
            $pay_amount = $numm;
            $recent_pay = $paid_amt + $pay_amount;
            $this->db->where('admission_university_fees_structure_data_id', $ad_id)->set('balance_amt', $getamt)->update('admission_university_fees_structure_data');
            $this->db->where('admission_university_fees_structure_data_id', $ad_id)->set('paid_amt', $recent_pay)->update('admission_university_fees_structure_data');
            $numm = 0;
        }

$this->db->where('admission_university_fees_structure_data_id', $ad_id)->set('payment_mode_id', $payment_mode_id)->update('admission_university_fees_structure_data');

}
}

}

// update consession amount #endregion for management

$get_conjection = $this->Fees_payment_model->getConjectionAmt($student_id);
            $conjAmt = $get_conjection['conjunction_amt'];
            $sec_conjAmt = $get_conjection['sec_conjunction_amt'];

if ($academic_year == 1) {
                $tot_conj = $conjAmt + $conjunction_amt;
               $this->db->where('admission_id', $student_id)->set('conjunction_amt', $tot_conj)->update('admission_fee_structure');
            }else{
                $tot_sec_conjAmt = $sec_conjAmt + $conjunction_amt;
                $this->db->where('admission_id', $student_id)->set('sec_conjunction_amt', $tot_sec_conjAmt)->update('admission_fee_structure');
            }
            // update consession amount #endregion for university

$unive_first_con_amt = $get_conjection['unive_first_con_amt'];
            $unive_sec_con_amt = $get_conjection['unive_sec_con_amt'];
            if ($academic_year == 1) {
                $tot_conjj = $unive_first_con_amt + $balForStudentUniv;
               $this->db->where('admission_id', $student_id)->set('unive_first_con_amt', $tot_conjj)->update('admission_fee_structure');
               if (!empty($univgeneral_amt)) {
               $this->db->where('university_bill_id', $university_bill_id)->set('conjunction_amt', $balForStudentUniv)->update('university_bill');
               }
        }else{
                $tot_sec_conjAmtt = $unive_sec_con_amt + $balForStudentUniv;
                $this->db->where('admission_id', $student_id)->set('unive_sec_con_amt', $tot_sec_conjAmtt)->update('admission_fee_structure');
                if (!empty($univgeneral_amt)) {
                $this->db->where('university_bill_id', $university_bill_id)->set('conjunction_amt', $balForStudentUniv)->update('university_bill');
                }
            }

}

if ($ex_pay_amt != "") {
                $getbill_id =0;
                $payCodee  = 2;
 //get arrear fees for student
 $resarrearFeesForStudent = $this->Fees_payment_model->resarrearFeesForStudent($stu_id)->row_array();
 
 if(!empty($resarrearFeesForStudent)){
   $resArrearPaidAmt = $resarrearFeesForStudent['tot_amt'];
 }
   $resarrearPaidFeesForStudent = $this->Fees_payment_model->resarrearPaidFeesForStudent($stu_id)->row_array();
   if(!empty($resarrearPaidFeesForStudent)){
   $resArrearPaid = $resarrearPaidFeesForStudent['paid_amt'];
   $resArrearPaidAmt = $resArrearPaidAmt - $resArrearPaid;
   }
$paidArrearAmt = 0;
$reamainAmt = 0;
$arearschpaidAmt = 0;
if(!empty($resarrearFeesForStudent)){

if($resArrearPaidAmt>0){
  //  print_r($resArrearPaidAmt);exit;

if($resArrearPaidAmt>$ex_pay_amt){
    $reamainmt= $resArrearPaidAmt-$ex_pay_amt;
    $paidArrearAmt = $ex_pay_amt;
    $reamainAmt =0;
  // echo 'low';
}else if($resArrearPaidAmt<$ex_pay_amt){
    $reamainAmt= $ex_pay_amt-$resArrearPaidAmt;
    $paidArrearAmt = $resArrearPaidAmt;
   // echo 'high';
}else{
    $paidArrearAmt= $ex_pay_amt;

}
$ex_pay_amt = $reamainAmt;
    $arrear_datapay = array(

'admission_id' => $student_id,
        'paid_date' => $payment_date,
        'paid_amt' => $paidArrearAmt,
       
        'created_on' => $today_date,
        'created_by' => $created_by,
    );
   $arear_id =  $this->Fees_payment_model->insertArrearPay($arrear_datapay);

$arrear_databill = array(

'admission_id' => $student_id,
        'tot_amt' => $paidArrearAmt,
        'bill_date' => $payment_date,
        'extra_payment' => 1,      
        'reference_no' => $refer_no,
        'payment_id' => $payment_mode_id,       
        'fee_year' => $academic_year,
        'created_on' => $today_date,
        'payment_date' => $payment_date,
        'created_by' => $created_by,
    );
    $getbill_id = $this->Fees_payment_model->insertBill($arrear_databill);

$universityarrear_databill = array(

'bill_id' => $getbill_id,
        'admission_id' => $student_id,
        'tot_amt' => $paidArrearAmt,
        'bill_date' => $payment_date,
        'extra_payment' => 1,       
        'reference_no' => $refer_no,
        'payment_id' => $payment_mode_id,       
        'fee_year' => $academic_year,
        'created_on' => $today_date,
        'payment_date' => $payment_date,
        'created_by' => $created_by,
    );
    $getUniv_bill_id = $this->Fees_payment_model->insertUniversityBill($universityarrear_databill);

$this->db->where('arrear_payment_id', $arear_id)->set('bill_id', $getbill_id)->update('arrear_payment');

}else{

$ex_pay_amt = $ex_pay_amt;
}
              
            }else{
                $ex_pay_amt = $ex_pay_amt;
 
               }
               
        if($ex_pay_amt!=0){

$resSchFeesForStudentFirst = $this->Fees_payment_model->resSchFeesForStudentFirst($stu_id)->row_array();
            $resSchFeesForStudentSec = $this->Fees_payment_model->resSchFeesForStudentSec($stu_id)->row_array();
            $schFirst = 0;
            if(!empty($resSchFeesForStudentFirst)){
            $schFirst = $resSchFeesForStudentFirst['first_yr_sanction_amt'];
            $scholarship_id = $resSchFeesForStudentFirst['scholarship_id'];
            }
            $schSec = 0;
            if(!empty($resSchFeesForStudentSec)){
            $schSec = $resSchFeesForStudentSec['sec_yr_sanction_amt'];
            }
            
            $tot_sch = $schFirst+$schSec;
            
           // print_r($tot_sch);exit;
              $resschPaidFeesForStudent = $this->Fees_payment_model->resschPaidFeesForStudent($stu_id)->row_array();
              $resSchPaidAmt=0;
              if(!empty($resschPaidFeesForStudent)){
              $resSchPaidAmt = $resschPaidFeesForStudent['paid_amt'];
              $tot_sch = $tot_sch-$resSchPaidAmt;

}
             // print_r($tot_sch);exit;

$scholarAmt = 0;
            if($tot_sch>0){
            $scholarAmt = $tot_sch;
            
            
            $paidArrearAmtsch = 0;
            $reamainAmtsch = 0;
            
           
            if($scholarAmt>$ex_pay_amt){
                $reamainAm= $scholarAmt-$ex_pay_amt;
                $paidArrearAmtsch = $ex_pay_amt;
                $reamainAmt =0;
               
            }else if($scholarAmt<$ex_pay_amt){
                $reamainAmt= $ex_pay_amt-$scholarAmt;
                $paidArrearAmtsch = $scholarAmt;
            }else{
                $paidArrearAmtsch= $ex_pay_amt;
            
            }
            $ex_pay_amt = $reamainAmt;
            
                $sch_datapay = array(
            
                    'admission_id' => $student_id,
                    'paid_date' => $payment_date,
                    'paid_amt' => $paidArrearAmtsch,
                    'scholarship_id' => $scholarship_id,
                   
                    'created_on' => $today_date,
                    'created_by' => $created_by,
                );
               $sch_id =  $this->Fees_payment_model->insertSchPay($sch_datapay);
            
                $sch_databill = array(
            
                    'admission_id' => $student_id,
                    'tot_amt' => $paidArrearAmtsch,
                    'bill_date' => $payment_date,
                    'extra_payment' => 1,
        'payment_id' => $payment_mode_id,
        'reference_no' => $refer_no,

'fee_year' => $academic_year,
                    'created_on' => $today_date,
                    'payment_date' => $payment_date,
                    'created_by' => $created_by,
                );

if($getbill_id!=0){
                    $arearschpaidAmt = $paidArrearAmt + $paidArrearAmtsch;
                    $this->db->where('bill_id', $getbill_id)->set('tot_amt', $arearschpaidAmt)->update('bill');

}else{
                    $arearschpaidAmt = $paidArrearAmtsch;
                    $getbill_id = $this->Fees_payment_model->insertBill($sch_databill);

}
                $this->db->where('scholarship_payment_id', $sch_id)->set('bill_id', $getbill_id)->update('scholarship_payment');
            
               
            
            
            }else{
            $arearschpaidAmt = $paidArrearAmt;
                $ex_pay_amt = $ex_pay_amt;
            }

}      
        if($ex_pay_amt!=0){

$extra_amt = $this->Fees_payment_model->getExfeesdetalsForStudent($student_id);
                $paidExTotAmt = $this->Fees_payment_model->getPayDeatilsExtra($student_id, $academic_year)->row_array();

$extraBalAmt = $paidExTotAmt['bamt'];

$finalPay =  $arearschpaidAmt+$ex_pay_amt;
                if (!empty($extra_amt)) {
                    $billex_data = array(

'admission_id' => $student_id,
                        'tot_amt' => $finalPay,
                        'bill_date' => $payment_date,
                        'extra_payment' => 1,
        'payment_id' => $payment_mode_id,
        'reference_no' => $refer_no,

'fee_year' => $academic_year,
                        'created_on' => $today_date,
                        'payment_date' => $payment_date,
                        'created_by' => $created_by,
                    );

if($getbill_id!=0){
                        $totpaidAmt = $arearschpaidAmt + $ex_pay_amt;
                        $this->db->where('bill_id', $getbill_id)->set('tot_amt', $totpaidAmt)->update('bill');
    
                    }else{
                        $getbill_id = $this->Fees_payment_model->insertBill($billex_data);
    
                    }

$college_name = $this->session->userdata('college_id');
                    $academic_year_id = $this->session->userdata('academic_id');
                    $getCollegebill = $this->Fees_payment_model->getCollegebill($college_name)->row_array();
                    $getAcademicbill = $this->Fees_payment_model->getAcademicbill($academic_year_id)->row_array();
                   // $getCountbill_id = $this->Fees_payment_model->getExbillNo($student_id);
                    if(date('m') > 03) {
    
                        $d = date('Y-m-d', strtotime('+1 years'));
                       $finyear =  date('Y') .'-'.date('y', strtotime($d));
                      } else {
                       $d = date('Y-m-d', strtotime('-1 years'));
                      $finyear = date('Y', strtotime($d)).'-'.date('y');
                      }
                   //   $bill_no = 'KR/' .$getCollegebill['bill_prefix'] ."/".'EX/'. $finyear."/". str_pad($getCountbill_id, 3, "0", STR_PAD_LEFT);

//   $exbill_no = 'KR/' .$getCollegebill['bill_prefix'] ."/". $finyear."/". str_pad($getCountbill_id, 3, "0", STR_PAD_LEFT);
                   
                   // $this->db->where('bill_id', $getbill_id)->set('bill_no', $bill_no)->update('bill');
                    $exnum = $ex_pay_amt;
                    foreach ($extra_amt as $gen) {
                        $tot = 0;

if ($exnum > 0) {
                            $amount = $gen['balance_amt'];
                            $paid_amt = $gen['paid_amt'];

$ad_id = $gen['admission_management_fees_structure_data_id'];
                            if ($exnum > $amount || $exnum == $amount) {
                                $getamt = $exnum - $amount;
                                $bal = 0.00;
                                $pay_amount = $amount;
                                $recent_pay = $paid_amt + $pay_amount;
                                $exnum = $getamt;
                                $this->db->where('admission_management_fees_structure_data_id', $ad_id)->set('balance_amt', $bal)->update('admission_management_fees_structure_data');
                                $this->db->where('admission_management_fees_structure_data_id', $ad_id)->set('paid_amt', $recent_pay)->update('admission_management_fees_structure_data');

} else if ($exnum < $amount) {
                                $getamt = $amount - $exnum;
                                $pay_amount = $exnum;
                                $recent_pay = $paid_amt + $pay_amount;
                                $this->db->where('admission_management_fees_structure_data_id', $ad_id)->set('balance_amt', $getamt)->update('admission_management_fees_structure_data');
                                $this->db->where('admission_management_fees_structure_data_id', $ad_id)->set('paid_amt', $recent_pay)->update('admission_management_fees_structure_data');
                                $exnum = 0;
                            }

$this->db->where('admission_management_fees_structure_data_id', $ad_id)->set('payment_mode_id', $payment_mode_id)->update('admission_management_fees_structure_data');

$bill_data = array(

'bill_id' => $getbill_id,
                                'admission_management_fees_structure_data_id' => $ad_id,
                                'paid_amt' => $pay_amount,
                                'created_on' => $today_date,
                                'created_by' => $created_by,
                            );
                            if ($pay_amount != 0) {
                                $billdata_id = $this->Fees_payment_model->insertBillData($bill_data);
                            }

}
                    }
                }

}
            $college_name = $this->session->userdata('college_id');
            $academic_year_id = $this->session->userdata('academic_id');
            $getCollegebill = $this->Fees_payment_model->getCollegebill($college_name)->row_array();
            //print_r($getCollegebill);
            $getAcademicbill = $this->Fees_payment_model->getAcademicbill($academic_year_id)->row_array();
            //print_r($getCollegebill);
            $getcbill_id = $this->Fees_payment_model->getExbillNo($student_id);
            if(date('m') > 03) {
    
                $d = date('Y-m-d', strtotime('+1 years'));
               $finyear =  date('Y') .'-'.date('y', strtotime($d));
              } else {
               $d = date('Y-m-d', strtotime('-1 years'));
              $finyear = date('Y', strtotime($d)).'-'.date('y');
              }
            $exbill_no = 'KR/' .$getCollegebill['bill_prefix'] ."/".'EX/'. $finyear."/". str_pad($getcbill_id, 3, "0", STR_PAD_LEFT);
        if($getbill_id!=''){
            $this->db->where('bill_id', $getbill_id)->set('bill_no', $exbill_no)->update('bill');
        }
        }

// set_alert('success', "Payment information updated successfully.");

$error_type = 'm';
            $msg = 'Payment updated successfully.';
            $result = true;

($result) ? logActivity('Payment updated [#' . $created_by . ']', LOG_FEESPAYMENT) : '';

}
        echo json_encode(array('rs' => $result, 'errType' => $error_type, 'msg' => $msg,'payCodee'=>$payCodee,'getbill_id'=>$getbill_id,'bill_id' => $bill_id));
    }

/*30-11-2019 - By indra */
    /*Update University bill details */

public function generateUniversityBill(){
        $admission_id = $this->uri->segment(3);

$generatedBills = $this->alreadyGeneratedUniversityBills($admission_id);

////bill ids are here

$bills = $this->Fees_payment_model->getNotUniversityBillGenerated($generatedBills,$admission_id)->result_array();

////bills == get university bill not generated bills      
     $extra_amt =0;
     $i =0;
     $minus_univ =0;
     foreach($bills as $row){

$univ_paid = $this->Fees_payment_model->getUnivPaid($admission_id)->row_array(); //admision univ data
          $univ_bill_paid = $this->Fees_payment_model->getUnivBillPaid($admission_id)->row_array(); //univ bill data
          $univ_paid_amt=$univ_paid['paid_amt'];
          $univ_bill_paid_amt=$univ_bill_paid['paid_amt'];
            if($univ_paid_amt != $univ_bill_paid_amt){
         
             $paid_amount =0;

$bill_id =  $row['bill_id'];

$payment_date =  $row['bill_date'];

$pay_amount =  $row['tot_amt'];

$fee_year =  $row['fee_year'];

$admission_id =  $row['admission_id'];

$payment_mode_id =  $row['payment_id'];

$refer_no =  $row['reference_no'];

$created_by =  $row['created_by'];

$conjunction_amt =  $row['conjunction_amt'];

$conjunction_reason =  $row['conjunction_reason'];

$universityTotalAmt = $this->Fees_payment_model->getUniversityTotalAmount($fee_year, $admission_id);

$management_amt = $this->Fees_payment_model->getPayDeatilsGeneral($admission_id,$fee_year)->row_array();

$university_amt_tot = $this->Fees_payment_model->getPayDeatilsGeneralUniv($admission_id,$fee_year)->row_array();
                $university_amt = $this->Fees_payment_model->getUnivBillPaid($admission_id)->row_array();

$paid = ($i ==0)? 0.00 : $pay_amount;
             if($i==0){
                $manageBalAmt = $management_amt['amt'];
                // print($manageBalAmt); 
             }else{
                $manageBalAmt = $management_amt['amt'] - $extra_amt; 
                // print_r($manageBalAmt);
             }
             if($i==0){
                $univBalAmt   = $university_amt_tot['amt'];
                // print_r($univBalAmt);

}else{
                $univBalAmt = $university_amt_tot['amt'] - $minus_univ; 
                // print_r($univBalAmt);
             }

$difAmt =  $manageBalAmt -  $univBalAmt; 
    
                if($pay_amount > $difAmt){                   
                   
         
                  $balForStudentUniv = $pay_amount-$difAmt; 
                //    print_r($balForStudentUniv);
               
                }
                else if($pay_amount < $difAmt){
                  $fnSub = $pay_amount/4;
                  $balForStudent = $fnSub*3;
                  $balForStudentUniv = $fnSub;
                 $angen_pay_amt = $pay_amount;
                //  print_r($balForStudentUniv);
               }
            else if($pay_amount == $difAmt){

$balForStudentUniv = $pay_amount;

}
               else{

$angen_pay_amt = $pay_amount;
              $balForStudentUniv = $univBalAmt;

}
///consession
// code by gopi 17/12*

//  if($conjunction_amt != 0){
             if($conjunction_amt < $univBalAmt){
                 $consession_pay = $univBalAmt - $conjunction_amt;
                //  print_r($consession_pay);
             }
             else if($conjunction_amt > $univBalAmt){
                $consession_pay = $univBalAmt;
                // print_r($consession_pay);
            }
//  }

// code on 17/12//

////increment

$minus_univ += $balForStudentUniv;  
        $extra_amt += $pay_amount;

if (!empty($universityTotalAmt)) {

// print_r($balForStudentUniv);

$university_bill_data = array(

'bill_id' => $bill_id,
        'admission_id' => $admission_id,
        'tot_amt' => $balForStudentUniv,
        'bill_date' => $payment_date,
        'conjunction_amt' => $conjunction_amt,
        'conjunction_reason' => $conjunction_reason,
        'fee_year' => $fee_year,
        'created_on' => date('Y-m-d H:i:s'),    
        'payment_date' => $payment_date,
        'created_by' => $created_by,
        'reference_no' => $refer_no,
        'payment_id' => $payment_mode_id,

);
 
   
    //$result = $this->Fees_payment_model->insertUniversityBill($university_bill_data);
    //$university_bill_id = $this->db->insert_id();
    $university_bill_id = 1;

$numm1=$balForStudentUniv;
    $p_amount = 0;
foreach($universityTotalAmt as $gen) {
  
    if ($numm1 > 0) {

$bal_amount= ($p_amount > 0)? $gen['amount'] - $p_amount : $gen['amount'];
        $amount = $bal_amount;
        $paid_amt = $gen['paid_amt'];

$ad_id = $gen['admission_university_fees_structure_data_id'];
        if ($numm1 > $amount || $numm1 == $amount) {
            $getamt = $numm1 - $amount;         
            $pay_amount = $amount;          
            $numm1 = $getamt;
         
        } else if ($numm1 < $amount) {
            $getamt = $amount - $numm1;
            $pay_amount = $numm1;            
             $numm1 = 0;
        }     
        
   
        $university_bill_data = array(

'university_bill_id' => $university_bill_id,
            'admission_university_fees_structure_data_id' => $ad_id,
            'paid_amt' => $pay_amount,
            'created_on' => date('Y-m-d H:i:s'),
            'created_by' => $created_by,
        );

$p_amount = $pay_amount;

// print_r($university_bill_data);

if($pay_amount != 0) {
            $result = $this->Fees_payment_model->insertUniversityBillData($university_bill_data);
        }
   
   
   
           }

$paid_amount += $pay_amount;

}

$i++; 
            
            
            }

echo "completed";

}

public function alreadyGeneratedUniversityBills($admission_id){

$generatedBills = $this->Fees_payment_model->universityBillsGenerated($admission_id)->result_array();

$itemarray ='';
        if(!empty($generatedBills)){
            $itemarray =[];

foreach($generatedBills as $row){

$itemarray[] = $row['bill_id'];

}

return $itemarray;

}

/*Update University bill details */

/*30-11-2019 - By indra */

}

/var/www/yapwebtv.com/../../www/krcollege.co/application/controllers/Fees_payment_old.php