<?php  if (!defined('BASEPATH')) exit('No direct script access allowed');

function generate_stu_code($data){
    if(!empty($data['student_code_settings'])){
        if ($data['student_code_settings']=='college_code/course_code/session/student_number') {
            $stu_user_code=strtoupper($data['user_code'].'/'.$data['course_code']).'/'.$data['session_start_year'].'-'.$data['session_end_year'].'/'.$data['student_id_val'];
        }
    }else{
        $stu_user_code=strtoupper($data['user_code'].'/'.$data['course_code']).'/'.$data['session_start_year'].'-'.$data['session_end_year'].'/'.$data['student_id_val'];
    }

    return $stu_user_code;
}

function check_duplicate_students_data($ph_no){
    $student_data=CI()->um->_get_duplicate_student(array('stu_ph_no'=>$ph_no));

    if($student_data->counted>0){
        return true;
    }  else{
        return false;
    }
}

function booking_impt_data($inst_id,$session,$course,$db_group){
    $course_data=CI()->cm->get_course(array('course_id'=>$course,'course_inst_id'=>$inst_id),TRUE,$db_group);
    $session_data=CI()->sessm->get_session(array('session_id'=>$session,'session_inst_id'=>$inst_id),TRUE,$db_group);
    $course_session_data=CI()->sessm->get_session_course(array('session_inst_id'=>$inst_id,'session_id'=>$session,'session_course_id'=>$course),TRUE,$db_group);
    $subject_data=CI()->cm->get_subject(array('subject_inst_id'=>$inst_id,'subject_course_id'=>$course),TRUE,$db_group);
    $get_college_seat_settings=CI()->sm->get_college_seat_settings(array('seats_inst_id'=>$inst_id,'seats_sess_id'=>$session,'seats_course_id'=>$course),TRUE,$db_group);

    return ['session_data'=>$session_data,'course_data'=>$course_data,'course_session_data'=>$course_session_data,'subject_data'=>$subject_data,'get_college_seat_settings'=>$get_college_seat_settings];
}

function store_students_academics($data){
    $academic_data=array(
        'acad_stu_id'=>$data['student_user_id'],
        'acad_stu_inst_id'=>$data['college_id'],
        'acad_stu_inst_parent_id'=>$data['parent_inst_id'],
        'acad_10th_board'=>$data['stu_10th_board'],
        'acad_10th_yop'=>$data['stu_10th_yop'],
        'acad_10th_total_marks'=>$data['stu_10th_total_marks'],
        'acad_10th_percentage'=>$data['stu_10th_percentage_marks'],
        'acad_10th_division'=>$data['stu_10th_division'],
        'acad_10th_subjects'=>$data['stu_10th_subjects'],
        'acad_12th_board'=>$data['stu_10_2_board'],
        'acad_12th_yop'=>$data['stu_10_2_yop'],
        'acad_12th_total_marks'=>$data['stu_10_2_total_marks'],
        'acad_12th_percentage'=>$data['stu_10_2_percentage_marks'],
        'acad_12th_division'=>$data['stu_10_2_division'],
        'acad_12th_subjects'=>$data['stu_10_2_subjects'],
        'acad_grad_board'=>$data['stu_grad_board'],
        'acad_grad_yop'=>$data['stu_grad_yop'],
        'acad_grad_total_marks'=>$data['stu_grad_total_marks'],
        'acad_grad_percentage'=>$data['stu_grad_percentage_marks'],
        'acad_grad_division'=>$data['stu_grad_division'],
        'acad_grad_subjects'=>$data['stu_grad_subjects'],
        'acad_pgd_board'=>$data['stu_post_grad_board'],
        'acad_pgd_yop'=>$data['stu_post_grad_yop'],
        'acad_pgd_total_marks'=>$data['stu_post_grad_total_marks'],
        'acad_pgd_percentage'=>$data['stu_post_grad_percentage_marks'],
        'acad_pgd_division'=>$data['stu_post_grad_division'],
        'acad_pgd_subjects'=>$data['stu_post_grad_subjects'],
        'acad_others_board'=>$data['stu_other_grad_board'],
        'acad_others_yop'=>$data['stu_other_grad_yop'],
        'acad_others_total_marks'=>$data['stu_other_grad_total_marks'],
        'acad_others_percentage'=>$data['stu_other_grad_percentage_marks'],
        'acad_others_division'=>$data['stu_other_grad_division'],
        'acad_others_subjects'=>$data['stu_other_grad_subjects'],
        'created_by'=>$data['user_id'],
        'created_at'=>date('Y-m-d')
    );

    CI()->um->store_students_academics($academic_data);
}

function store_students_academics_minimal($data){
    $academic_details=array(
        'acad_stu_id'=>$data['student_user_id'],
        'acad_stu_inst_id'=>$data['inst_id'],
        'acad_stu_inst_parent_id'=>$data['parent_inst_id'],
        'acad_12th_board'=>$data['booking_last_qualification_board'],
        'acad_12th_total_marks'=>$data['total_marks'],
        'acad_12th_yop'=>$data['passing_year'],
        'acad_12th_percentage'=>$data['passing_percentage'],
        'created_by'=>$data['created_by'],
        'created_at'=>date('Y-m-d H:i:s'),
    );

    CI()->um->store_students_academics($academic_details);
}

function store_students($data){
    $student_data=array(
        'stu_inst_id'=>$data['college_id'],
        'stu_inst_parent_id'=>$data['parent_inst_id'],
        'stu_first_name'=>$data['stu_first_name'],
        'stu_mid_name'=>$data['stu_middle_name'],
        'stu_last_name'=>$data['stu_last_name'],
        'stu_email'=>$data['stu_email_address'],
        'stu_ph_no'=>$data['stu_ph_no'],
        'stu_whatsapp_no'=>$data['stu_whatsapp_no'],
        'stu_aadhar'=>$data['stu_aadhar_no'],
        'stu_dob'=>date('Y-m-d',strtotime($data['stu_dob'])),
        'stu_gender'=>$data['stu_gender'],
        'stu_religion'=>$data['stu_religion'],
        'stu_caste'=>$data['stu_caste'],
        'stu_blood_group'=>$data['stu_blood_grp'],
        'stu_nationality'=>$data['stu_nationality'],
        'stu_has_illness'=>$data['stu_has_illness'],
        'stu_illness_remarks'=>$data['stu_illness_remarks'],
        'stu_identity_marks'=>$data['stu_identiy_mark'],
        'stu_father_first_name'=>$data['stu_father_first_name'],
        'stu_father_mid_name'=>$data['stu_father_mid_name'],
        'stu_father_last_name'=>$data['stu_father_last_name'],
        'stu_father_ph_no'=>$data['stu_father_mobile'],
        'stu_father_email'=>$data['stu_father_email_address'],
        'stu_father_income'=>$data['stu_father_income'],
        'stu_father_occupation'=>$data['stu_father_occupation'],
        'stu_mother_first_name'=>$data['stu_mother_first_name'],
        'stu_mother_mid_name'=>$data['stu_mother_mid_name'],
        'stu_mother_last_name'=>$data['stu_mother_last_name'],
        'stu_mother_ph_no'=>$data['stu_mother_mobile'],
        'stu_mother_email'=>$data['stu_mother_email_address'],
        'stu_mother_income'=>$data['stu_mother_income'],
        'stu_mother_occupation'=>$data['stu_mother_occupation'],
        'stu_guardian_first_name'=>$data['stu_guardian_first_name'],
        'stu_guardian_mid_name'=>$data['stu_guardian_mid_name'],
        'stu_guardian_last_name'=>$data['stu_guardian_last_name'],
        'stu_guardian_ph_no'=>$data['stu_guardian_mobile'],
        'stu_guardian_email'=>$data['stu_guardian_email_address'],
        'stu_guardian_income'=>$data['stu_guardian_income'],
        'stu_guardian_occupation'=>$data['stu_guardian_occupation'],
        'stu_cur_addr_co'=>$data['stu_c_o'],
        'stu_cur_addr_country'=>$data['stu_nationality'],
        'stu_cur_state'=>$data['stu_state'],
        'stu_cur_city'=>$data['stu_city_village'],
        'stu_cur_district'=>$data['stu_district'],
        'stu_cur_pincode'=>$data['stu_pincode'],
        'stu_cur_ps'=>$data['stu_p_s'],
        'stu_cur_po'=>$data['stu_p_o'],
        'stu_cur_address_line'=>'',
        'stu_cur_address_landmark'=>$data['stu_address_landmark'],
        'stu_perma_addr_co'=>$data['stu_perma_c_o'],
        'stu_perma_addr_country'=>$data['stu_nationality'],
        'stu_perma_state'=>$data['stu_perma_state'],
        'stu_perma_city'=>$data['stu_perma_city_village'],
        'stu_perma_district'=>$data['stu_perma_district'],
        'stu_perma_pincode'=>$data['stu_perma_pincode'],
        'stu_perma_ps'=>$data['stu_perma_p_s'],
        'stu_perma_po'=>$data['stu_perma_p_o'],
        'stu_perma_address_line'=>'',
        'stu_perma_address_landmark'=>$data['stu_perma_address_landmark'],
        'stu_same_address'=>$data['address_same_as'],
        'stu_regster_mode'=>$data['admission_type'],
        'stu_last_qualification'=>null,
        'stu_passing_year'=>null,
        'stu_passing_percentage'=>null,
        'stu_avail_hostel'=>$data['avail_hostel'],
        'created_by'=>$data['user_id'],
        'created_at'=>date('Y-m-d')
    );

    //print_obj($student_data);die;

    $student_id=CI()->um->store_students($student_data);

    return $student_id;
}


function store_students_minimal($data){
    $student_data=array(  
        'stu_inst_type'=>$data['inst_type'],                      
        'stu_inst_id'=>$data['inst_id'],
        'stu_inst_parent_id'=>$data['parent_inst_id'],
        'stu_user_id'=>$data['student_user_id'],
        'stu_first_name'=>$data['first_name'],
        'stu_mid_name'=>$data['middle_name'],
        'stu_last_name'=>$data['last_name'],
        'stu_email'=>$data['email_address'],
        'stu_ph_no'=>$data['ph_no'],
        'stu_whatsapp_no'=>$data['whatsapp_no'],
        'stu_dob'=>date('Y-m-d',strtotime($data['booking_dob'])),
        'stu_gender'=>$data['gender'],
        'stu_nationality'=>$data['nationality'],
        'stu_last_qualification_board'=>$data['booking_last_qualification_board'],
        'stu_last_qualification'=>$data['last_qualification'],
        'stu_passing_year'=>$data['passing_year'],
        'stu_passing_percentage'=>$data['passing_percentage'],
        'stu_record_old'=>$data['is_record_old'],
        'created_by'=>$data['created_by'],
        'created_at'=>date('Y-m-d')
    );

    $student_id=CI()->um->store_students($student_data);

    return $student_id;
}

function store_admission_data($data){
    $admission_application_type=$data['admission_application_type'];
    $admission_details=array(
        'admission_seat_booking_converted'=>(isset($data['booking_type']) && $data['booking_type']=='seat_booking_convert')?'yes':'no',
        'admission_seat_booking_id'=>($data['booking_id']>0)?$data['booking_id']:NULL,
        'admission_stu_id'=>$data['student_user_id'],
        'admission_inst_id'=>$data['college_id'],
        'admission_inst_parent_id'=>$data['parent_inst_id'],
        'admission_sess_id'=>$data['admission_session'],
        'admission_course_id'=>$data['admission_course'],
        'admission_subject_id'=>$data['admission_subject_id'],
        'admission_section_id'=>$data['admission_section'],
        'admission_type'=>$data['admission_type'],
        'admission_application_type'=>$admission_application_type,
        'admission_agent_id'=>$data['admission_agent'],
        'admission_code'=>$data['admission_code'],
        'admission_avail_hostel'=>$data['avail_hostel'],
        'admission_hostel_id'=>$data['hostel_id'],
        'admission_date'=>(!empty($data['admission_date']))?date('Y-m-d',strtotime($data['admission_date'])):null,
        'created_by'=>$data['user_id'],
        'created_at'=>date('Y-m-d')
    );

    $admission_id=CI()->adm->store_admission_data($admission_details);

    return $admission_id;
}

function update_stu_course_cost($data){
	$prev_cost_data=CI()->um->get_course_cost(array('cost_inst_id'=>$data['inst_id'],
        'cost_inst_parent_id'=>$data['parent_inst_id'],
        'cost_stu_id'=>$data['student_user_id'],
        'cost_session_id'=>$data['session'],
        'cost_cousre_id'=>$data['course']));

    if(!empty($prev_cost_data)){

        $stu_course_revised_cost=array(
            'cost_inst_id'=>$data['inst_id'],
            'cost_inst_parent_id'=>$data['parent_inst_id'],
            'cost_inst_type'=>$data['inst_type'],
            'cost_stu_id'=>$data['student_user_id'],
            'cost_session_id'=>$data['session'],
            'cost_cousre_id'=>$data['course'],
            'cost_value'=>$data['stu_course_fees'],
            'cost_last_value'=>$prev_cost_data->cost_value,
            'cost_revised'=>'yes',
            'revised_by'=>$data['created_by'],
            'created_by'=>$data['created_by'],
            'revised_at'=>date('Y-m-d'),
            'created_at'=>date('Y-m-d')
        );

        CI()->um->update_course_cose($stu_course_revised_cost,array('cost_id'=>$prev_cost_data->cost_id));
    }else{
        $stu_course_revised_cost=array(
            'cost_inst_id'=>$data['inst_id'],
            'cost_inst_parent_id'=>$data['parent_inst_id'],
            'cost_inst_type'=>$data['inst_type'],
            'cost_stu_id'=>$data['student_user_id'],
            'cost_session_id'=>$data['session'],
            'cost_cousre_id'=>$data['course'],
            'cost_value'=>$data['stu_course_fees'],
            'cost_last_value'=>$data['stu_course_last_fees'],
            'cost_revised'=>'yes',
            'revised_by'=>$data['created_by'],
            'updated_by'=>$data['created_by'],
            'revised_at'=>date('Y-m-d'),
            'updated_at'=>date('Y-m-d')
        );

        CI()->um->store_course_cost($stu_course_revised_cost);
    } 
}


function store_seat_booking_payment_data($data){

	$booking_payment_data=array(
        'booking_pk_id'=>$data['booking_id'],
        'booking_inst_id'=>$data['inst_id'],
        'booking_inst_parent_id'=>$data['parent_inst_id'],
        'booking_stu_id'=>$data['student_user_id'],
        'booking_course_id'=>$data['course'],
        'booking_subject_id'=>$data['booking_subject_id'],
        'booking_sess_id'=>$data['session'],
        'booking_payment'=>$data['booking_amount'],
        'booking_pay_mode'=>$data['pay_mode'],
        'booking_payment_bank'=>$data['pay_bank_name'],
        'booking_payment_checq_no'=>$data['pay_bank_cheque_no'],
        'booking_payment_checq_files_ids'=>$data['booking_payment_checq_files_ids'],
        'booking_payment_deposite_bank'=>$data['pay_deposite_bank'],
        'booking_payment_paid'=>$data['paid'],
        'booking_payment_recieved_date'=>$data['booking_payment_date'],
        'created_at'=>date('Y-m-d'),
        'created_by'=>$data['created_by']
    );

	$payment_id=CI()->adm->store_seat_booking_payment_data($booking_payment_data);

	return $payment_id;
}


function store_agent_payment($data,$booking_type='seat_booking'){
    //echo $booking_type;
    //print_obj($data);
	$inst_id=$data['inst_id'];
	$parent_inst_id=$data['parent_inst_id'];
	$student_user_id=$data['student_user_id'];
	
    if($booking_type=='admission'){
        $course=$data['admission_course'];
        $booking_subject_id=$data['admission_subject_id'];
        $session=$data['admission_session'];
        $booking_id=$data['admission_id'];
        $booking_code=$data['admission_code'];
        $pay_booking_agent=$data['admission_agent'];
    }else if($booking_type=='seat_booking'){
        $course=$data['course'];
        $booking_subject_id=$data['booking_subject_id'];
        $session=$data['session'];
        $booking_id=$data['booking_id'];
        $booking_code=$data['booking_code'];
        $pay_booking_agent=$data['pay_booking_agent'];        
    }	
	
	$booking_agent_payout_amount=$data['booking_agent_payout_amount'];

	if($booking_subject_id==null){
        $agent_payment_found_param=array('inst_id'=>$inst_id,'inst_parent_id'=>$parent_inst_id,'agent_id'=>$pay_booking_agent,'session_id'=>$session,'course_id'=>$course,'stu_id'=>$student_user_id,'booking_type'=>$booking_type);
    }else{
        $agent_payment_found_param=array('inst_id'=>$inst_id,'inst_parent_id'=>$parent_inst_id,'agent_id'=>$pay_booking_agent,'session_id'=>$session,'course_id'=>$course,'subject_id'=>$booking_subject_id,'stu_id'=>$student_user_id,'booking_type'=>$booking_type);
    }

    $agent_payment_found=CI()->fm->get_agent_payment($agent_payment_found_param);

    

    if(empty($agent_payment_found)){
        $agent_payment_data=array(
            'booking_id'=>$booking_id,
            'booking_code'=>$booking_code,
            'inst_id'=>$inst_id,
            'inst_parent_id'=>$parent_inst_id,
            'stu_id'=>$student_user_id,
            'agent_id'=>$pay_booking_agent,
            'booking_type'=>$booking_type,
            'session_id'=>$session,
            'course_id'=>$course,
            'subject_id'=>$booking_subject_id,
            'amount_value'=>$booking_agent_payout_amount,
            'amount_paid'=>'no',
            'amount_created_at'=>date('Y-m-d')
        );

        // print_obj($agent_payment_data);
        CI()->fm->store_agent_payment($agent_payment_data);
    }
}


function store_seatbooking_payment_details($data){
    $booking_code=ge_rand_code('SB');
    $payment_details=array(
        'details_type'=>'seat_booking',
        'details_type_text'=>'Seat Booking Fees '.$data['course_code'].'/'.$data['session_start_year'].'-'.$data['session_end_year'].' - '.$booking_code,
        'details_payment_type'=>'seatbooking_fees',
        'details_payment_id'=>$data['seat_booking_payment_id'],
        'details_type_id'=>$data['booking_id'],
        'details_inst_id'=>$data['inst_id'],
        'details_parent_inst_id'=>$data['parent_inst_id'],
        'details_stu_id'=>$data['student_user_id'],
        'details_agent_id'=>($data['pay_booking_agent']>0)?$data['pay_booking_agent']:null,
        'details_sess_id'=>$data['session'],
        'details_course_id'=>$data['course'],
        'details_subject_id'=>$data['booking_subject_id'],
        'details_payment_platform'=>$data['pay_mode'],
        'details_amount'=>$data['booking_amount'],
        'details_discount_amount'=>'0',
        'details_txn_id'=>$data['txn'],
        'details_utr_id'=>$data['utr'],
        'details_cheque_no'=>($data['pay_mode']==='cheque')?$data['pay_bank_cheque_no']:null,
        'details_pay_checq_files_ids'=>($data['pay_mode']==='cheque')?$data['booking_payment_checq_files_ids']:null,
        'details_order_id'=>$booking_code.'_stuinst',
        'details_order_code'=>$booking_code,
        'details_accounting_type'=>'income',
        'details_accounting_type_id'=>'1',
        'details_status'=>$data['details_status'],
        'details_msg'=>$data['details_msg'],
        'details_created_by_type'=>$data['user_type'],
        'details_msg'=>($data['pay_mode']!=='online')?ucwords($data['pay_mode'].' recieved'):'',
        'details_created_by'=>$data['created_by'],
        'details_created_at'=>date('Y-m-d H:i:s')
    );

    $payment_details_id=CI()->fm->store_payment_details($payment_details);

    return $payment_details_id;
}

function _store_payment_details($data){
	$payment_details=array(
        'details_type'=>$data['details_type'],
        'details_type_text'=>$data['details_type_text'],
        'details_payment_type'=>$data['details_payment_type'],
        'details_payment_id'=>$data['payment_id'],
        'details_type_id'=>$data['booking_id'],
        'details_inst_id'=>$data['inst_id'],
        'details_parent_inst_id'=>$data['parent_inst_id'],
        'details_stu_id'=>$data['student_user_id'],
        'details_agent_id'=>($data['pay_booking_agent']>0)?$data['pay_booking_agent']:null,
        'details_sess_id'=>$data['session'],
        'details_course_id'=>$data['course'],
        'details_subject_id'=>$data['booking_subject_id'],
        'details_payment_platform'=>$data['pay_mode'],
        'details_amount'=>$data['booking_amount'],
        'details_discount_amount'=>$data['details_discount_amount'],
        'details_txn_id'=>$data['txn'],
        'details_utr_id'=>$data['utr'],
        'details_order_id'=>$data['booking_order_id'],
        'details_order_code'=>$data['booking_code'],
        'details_created_by_type'=>$data['user_type'],
        'details_accounting_type'=>$data['details_accounting_type'],
        'details_status'=>$data['details_status'],
        'details_msg'=>$data['details_msg'],
        'details_created_by'=>$data['created_by'],
        'details_created_at'=>date('Y-m-d')
    );

    if(isset($data['details_parent_id'])){
        $payment_details['details_parent_id']=$data['details_parent_id'];
    }

    $payment_details_id=CI()->fm->store_payment_details($payment_details);

    return $payment_details_id;
}


function store_seat_booking_data($data){
    $booking_code=ge_rand_code('SB');
	$booking_data_to_store=array(
        'booking_stu_id'=>$data['student_user_id'],
        'booking_stu_profile_id'=>$data['student_profile_id'],
        'booking_inst_id'=>$data['inst_id'],
        'booking_inst_parent_id'=>$data['parent_inst_id'],
        'booking_sess_id'=>$data['session'],
        'booking_course_id'=>$data['course'],
        'booking_subject_id'=>$data['booking_subject_id'],
        'booking_code'=>$booking_code,
        'booking_agent_id'=>$data['pay_booking_agent'],
        'is_lateral'=>$data['is_lateral'],
        'created_by'=>$data['created_by'],
        'created_at'=>date('Y-m-d H:i:s')
    );

    $booking_id=CI()->adm->store_seat_booking_data($booking_data_to_store);

    return $booking_id;
}


function store_users($data){

    $get_user=CI()->um->get_user(array('user_name'=>$data['user_name']),$data['user_type']);

   // print_obj($get_user);

    if(empty($get_user)){
        $_userdata=array(
            'user_name'=>$data['user_name'],
            'user_code'=>$data['user_code'],
            'user_password'=>$data['password'],
            'user_password_visible'=>encode_data($data['password_visible']),
            'user_type'=>$data['user_type'],
            'user_permissions'=>$data['permissions'],
            'user_status'=>$data['user_status'],
            'created_by_type'=>$data['created_by_type'],
            'created_by'=>$data['user_id'],
            'created_at'=>date('Y-m-d')
        );

        $student_user_id=CI()->um->store_users($_userdata);
    }else{
        if($get_user->is_deleted=='yes'){
            $_userdata=array(
                'user_name'=>$data['user_name'],
                'user_code'=>$data['user_code'],
                'user_password'=>$data['password'],
                'user_password_visible'=>encode_data($data['password_visible']),
                'user_type'=>$data['user_type'],
                'user_permissions'=>$data['permissions'],
                'user_status'=>$data['user_status'],
                'is_deleted'=>'no',
                'updated_by_type'=>$data['created_by_type'],
                'updated_by'=>$data['user_id'],
                'updated_at'=>date('Y-m-d')
            );

            CI()->um->delete_users(array('user_id'=>$get_user->user_id));
            

            if($data['user_type']=='student'){
                CI()->um->delete_students(array('stu_user_id'=>$get_user->stu_user_id));
            }


            $student_user_id=CI()->um->store_users($_userdata);
        }else{
            $student_user_id=$get_user->user_id;
        }        
    }
        

    return $student_user_id;
}


function change_course_amount($data){
    $stu_booking_fees=$data['stu_booking_fees'];
    $stu_course_fees=$data['stu_course_fees'];
    $inst_id=$data['inst_id'];
    $course=$data['course'];
    $session=$data['session'];
    $course_amount_changed=$data['course_amount_changed'];
    $stu_user_id=$data['stu_user_id'];

    $booking_amount_data=CI()->sessm->get_session_courses(array('session_id'=>$session,'session_inst_id'=>$inst_id,'session_course_id'=>$course));

    //$booking_amount_data=CI()->sessm->__get_session_course_student_wise(array('session_stu_id'=>$data['student_user_id']),'session_course_id,session_course_fees',TRUE);

    if(!empty($booking_amount_data)){
       
        if($course_amount_changed=='yes'){
            $course_booking_amount=($stu_booking_fees>0)?$stu_booking_fees:$stu_course_fees;
        }if($course_amount_changed=='no'){
            $stu_course_fees= $booking_amount_data->session_course_fees;                                 
            $course_booking_amount=($booking_amount_data->session_course_booking_fee>0)?$booking_amount_data->session_course_booking_fee:$booking_amount_data->session_course_fees;
        }

        CI()->sessm->store_session_course_student_wise(array('session_id'=>$session,'session_inst_id'=>$inst_id,'session_stu_id'=>$data['student_user_id'],'session_course_id'=>$course,'session_course_fees'=>$stu_course_fees,'session_course_booking_fee'=>$course_booking_amount));

    }

    return $booking_amount_data;

   
}


function upload_cheque($data,$obj){
    if(!empty($pay_bank_cheque_no) && !empty($pay_bank_name) && $pay_deposite_bank>0){
        if(isset($_FILES['cheque_scan_frontcopy_file']) && $_FILES['cheque_scan_frontcopy_file']['name']!=''){

            $cheque_scan_frontcopy_file=array(
                'file_size'=>'5',
                'file_name'=>'cheque_scan_frontcopy_file',
                'file_types'=>'png,jpg,jpeg',
                'file_storage_type'=>'cheque_scan_frontcopy_file',
                'file_storage_dir'=>$data['storage_dir'],
                'file_storage_type_id'=>$data['student_user_id'],
                'file_parent_id'=>$data['inst_id'],
                'file_compress'=>false,
                'file_operation_type'=>'new',
                'file_uploaded_by'=>$data['user_id']
            );

            $cheque_scan_frontcopy_file_id=$obj->onUploadFiles($cheque_scan_frontcopy_file);
        }


        if(isset($_FILES['cheque_scan_backcopy_file']) && $_FILES['cheque_scan_backcopy_file']['name']!=''){

            $cheque_scan_backcopy_file=array(
                'file_size'=>'5',
                'file_name'=>'cheque_scan_backcopy_file',
                'file_types'=>'png,jpg,jpeg',
                'file_storage_type'=>'cheque_scan_backcopy_file',
                'file_storage_dir'=>$data['storage_dir'],
                'file_storage_type_id'=>$data['student_user_id'],
                'file_parent_id'=>$data['inst_id'],
                'file_compress'=>false,
                'file_operation_type'=>'new',
                'file_uploaded_by'=>$data['user_id']
            );

            $cheque_scan_backcopy_file_id=$obj->onUploadFiles($cheque_scan_backcopy_file);
        }
    }

    return ['cheque_scan_frontcopy_file_id'=>$cheque_scan_frontcopy_file_id,'cheque_scan_backcopy_file_id'=>$cheque_scan_backcopy_file_id];
}

function store_cheque_details($data){
    
    $cheque_details_to_add=array(
        'cheque_details_payment_id'=>$data['payment_id'],//PK of nt_institute_payments_details
        'cheque_details_inst_id'=>$data['inst_id'],
        'cheque_details_inst_parent_id'=>$data['parent_inst_id'],
        'cheque_details_stu_id'=>$data['student_user_id'],
        'cheque_details_agent_id'=>'0',
        'cheque_details_deposite_bank_id'=>$data['pay_deposite_bank'],
        'cheque_details_bank_name'=>$data['pay_bank_name'],
        'cheque_details_no'=>$data['pay_bank_cheque_no'],
        'cheque_details_amount'=>$data['booking_amount'],
        'cheque_details_bounce_amount'=>'0',
        'cheque_is_cleared'=>'no',
        'cheque_is_bounced'=>'no',
        'cheque_details_recieved_date'=>date('Y-m-d H:i:s'),
        'cheque_details_deposite_date'=>null,
        'cheque_details_cash_date'=>null,
        'cheque_details_created_by'=>$data['created_by']
    );


    CI()->fm->store_cheque_details($cheque_details_to_add);
}



function store_accounts_details($data,$payment_id){  
    $accounting_type=$data['accounting_type'];
    if($accounting_type=='income'){
        $dr_cr='credit';
    }else if($accounting_type=='expenditure'){
        $dr_cr='debit';
    }

    $category=CI()->vm->get_accounts_category_data(array('category_id'=>$data['account_head']));
    $category_parent_type=CI()->vm->get_accounts_category_types(array('type_id'=>$category->category_type_id));
    
    $data_to_add=array(
        'details_type'=>'other',
        'details_payment_type'=>'other',
        'details_type_text'=>$data['account_income_name'],
        'details_created_at_actual'=>date('Y-m-d H:i:s'),
        'details_created_at'=>date('Y-m-d',strtotime($data['account_transact_date'])),
        'details_type_id'=>'0',
        'details_emp_id'=>$data['emp_id'],
        'details_inst_id'=>$data['inst_id'],
        'details_parent_inst_id'=>$data['inst_parent_id'],
        'details_vendor_id'=>$data['vendor_id'],
        'details_payment_platform'=>$data['account_payment_method'],
        'details_payment_note'=>$data['account_transact_desc'],
        'details_cheque_no'=>$data['account_cheque_no'],
        'details_pay_currency'=>'inr',
        'details_amount'=>$data['account_amount'],
        'details_accounting_type'=>$data['accounting_type'],
        'details_accounting_type_id'=>$data['account_head'],
        'details_accounting_dr_cr'=>$dr_cr,
        'details_accounting_type_p_id'=>$category_parent_type->type_id,
        'details_status'=>'success',
        'details_created_by_type'=>$data['inst_type'],
        'details_created_by'=>$data['emp_id']
    );

    
    $amount=$data['account_amount'];
    $last_balance=0;

    $account_credit_debit=$data['account_credit_debit'];
    if($accounting_type=='income'){
        if($account_credit_debit=='cash'){
            //Cash balance update
            $balance_opening_amount=0;
            $get_balance_data=CI()->sm->get_cash_balance(array('balance_inst_id'=>$data['inst_id'],'balance_status'=>'active'));

            if(!empty($get_balance_data)){
                $last_balance=$get_balance_data->balance_opening_amount;
                $balance_opening_amount=$get_balance_data->balance_opening_amount;
            }

            $balance_amount=$last_balance+$amount;
            $cash_balance=array(
                'balance_inst_id'=>$data['inst_id'],                
                'balance_opening_amount'=>($balance_opening_amount>0)?$balance_opening_amount:$balance_amount,
                'balance_adjusted_amount'=>$amount,
                'balance_status'=>'active',
                'balance_created_by'=>$data['emp_id']
            );

            $balance_id=CI()->sm->store_cash_balance_data($cash_balance);
            if($balance_id){
                if(!empty($get_balance_data)){
                    CI()->sm->update_cash_balance_data(array('balance_status'=>'inactive','balance_updated_by'=>$data['emp_id']),array('balance_id'=>$get_balance_data->balance_id));
                }                
            }
        }else  if($account_credit_debit!='0' || $account_credit_debit!='later'){
            //Bank Balance update
            $balance_opening_amount=0;
            $get_balance_data=CI()->sm->get_bank_balance(array('balance_inst_id'=>$data['inst_id'],'balance_bank_id'=>$account_credit_debit,'balance_inst_type'=>$data['inst_type'],'balance_status'=>'active'));

            if(!empty($get_balance_data)){
                $last_balance=$get_balance_data->balance_opening_amount;
                $balance_opening_amount=$get_balance_data->balance_opening_amount;
            }

            $balance_amount=$last_balance+$amount;
            $bank_balance=array(
                'balance_inst_id'=>$data['inst_id'],
                'balance_bank_id'=>$account_credit_debit,
                'balance_opening_amount'=>$balance_amount,
                'balance_adjusted_amount'=>$amount,
                'balance_status'=>'active',
                'balance_created_by'=>$data['emp_id']
            );

            $balance_id=CI()->sm->store_bank_balance_data($bank_balance);
            if($balance_id){
                if(!empty($get_balance_data)){
                    CI()->sm->update_bank_balance_data(array('balance_status'=>'inactive','balance_updated_by'=>$data['emp_id']),array('balance_id'=>$get_balance_data->balance_id));
                }                
            }
        }        
    }else if($accounting_type=='expenditure'){
        // || $account_credit_debit!='later'
        if($account_credit_debit=='cash'){
            $get_balance_data=CI()->sm->get_cash_balance(array('balance_inst_id'=>$data['inst_id'],'balance_status'=>'active'));

            if(!empty($get_balance_data)){
                $last_balance=$get_balance_data->balance_opening_amount;
            }

            if($last_balance>=$amount){
                $balance_amount=$last_balance-$amount;
                $cash_balance=array(
                    'balance_inst_id'=>$data['inst_id'],
                    'balance_opening_amount'=>$balance_amount,
                    'balance_adjusted_amount'=>$amount,
                    'balance_status'=>'active',
                    'balance_is_credit_debit'=>'debit',
                    'balance_created_by'=>$data['emp_id']
                );

                $balance_id=CI()->sm->store_cash_balance_data($cash_balance);
            }else{
                $balance_id=$get_balance_data->balance_id;
            }
            
            if($balance_id){
                if(!empty($get_balance_data)){
                    CI()->sm->update_cash_balance_data(array('balance_status'=>'inactive'),array('balance_id'=>$get_balance_data->balance_id));
                }                
            }
        }else if($account_credit_debit!='0'){
            //Bank Balance update
            $get_balance_data=CI()->sm->get_bank_balance(array('balance_inst_id'=>$data['inst_id'],'balance_bank_id'=>$account_credit_debit,'balance_inst_type'=>$data['inst_type'],'balance_status'=>'active'));

            //print_obj($get_balance_data);die;

            if(!empty($get_balance_data)){
                $last_balance=$get_balance_data->balance_opening_amount;
            }

            if($last_balance>=$amount){
                $balance_amount=$last_balance-$amount;
                $cash_balance=array(
                    'balance_inst_id'=>$data['inst_id'],
                    'balance_bank_id'=>$account_credit_debit,
                    'balance_opening_amount'=>$balance_amount,
                    'balance_adjusted_amount'=>$amount,
                    'balance_status'=>'active',
                    'balance_is_credit_debit'=>'debit',
                    'balance_created_by'=>$data['emp_id']
                );

                $balance_id=CI()->sm->store_bank_balance_data($cash_balance);
            }else{
                $balance_id=$get_balance_data->balance_id;
            }

            if($balance_id){
                if(!empty($get_balance_data)){
                    CI()->sm->update_bank_balance_data(array('balance_status'=>'inactive','balance_updated_by'=>$data['emp_id']),array('balance_id'=>$get_balance_data->balance_id));
                }                
            }
        }else {
            $balance_id=0;
        }
    }

    if($balance_id!=0){
        if($payment_id==0){
            $details_id=CI()->fm->store_payment_details($data_to_add);
            $txn=ge_rand_code_v1('TXN'.$data['inst_id'].$details_id);
            CI()->fm->update_payment_details(array('details_txn_id'=>$txn),array('details_id'=>$details_id));
        }else{
            $data_to_add['details_updated_by_type']=$data['inst_type'];
            $data_to_add['details_updated_by']=$data['emp_id'];
            $data_to_add['details_updated_at']=date('Y-m-d H:i:s');
            CI()->fm->update_payment_details($data_to_add,array('details_id'=>$payment_id));
            $details_id=$payment_id;
        } 
    }else{
        $details_id=0;
    }       

    return $details_id;
}

function store_bank_balance_data($bank_id,$inst_id,$creator_id,$balance_amount,$transfer_id=0,$type='credit'){
    $get_balance_data=CI()->sm->get_bank_balance(array('balance_bank_id'=>$bank_id,'balance_inst_id'=>$inst_id,'balance_status'=>'active'));

    if(!empty($get_balance_data)){
        if($get_balance_data->balance_adjusted_amount>0){
            if($type=='credit'){
                $new_balance=$get_balance_data->balance_opening_amount+$balance_amount;
            }else if($type=='transfer_credit'){
                $new_balance=$get_balance_data->balance_opening_amount+$balance_amount;
            }else if($type=='debit'){
                $new_balance=$get_balance_data->balance_opening_amount-$balance_amount;
            }else if($type=='transfer_debit'){
                $new_balance=$get_balance_data->balance_opening_amount-$balance_amount;
            }
        }else{
            $new_balance=$balance_amount;
        }
        
        $balance_adjusted_amount=$balance_amount;
    }else{
        $new_balance=$balance_amount;
        $balance_adjusted_amount=0;
    }

    $data_to_insert=array(
        'balance_bank_id'=>$bank_id,
        'balance_inst_id'=>$inst_id,
        'balance_transfer_id'=>$transfer_id,
        'balance_opening_amount'=>$new_balance,
        'balance_adjusted_amount'=>$balance_adjusted_amount,
        'balance_status'=>'active',
        'balance_is_credit_debit'=>$type,
        'balance_created_by'=>$creator_id
    );

    if(!empty($get_balance_data)){
        if($get_balance_data->balance_adjusted_amount>0){
            $balance_id=CI()->sm->store_bank_balance_data($data_to_insert);
        }
        $balance_id=$get_balance_data->balance_id;
        if($get_balance_data->balance_adjusted_amount>0){
            CI()->sm->update_bank_balance_data(array('balance_status'=>'inactive','balance_updated_at'=>date('Y-m-d H:i:s'),'balance_updated_by'=>$creator_id),array('balance_bank_id'=>$bank_id,'balance_id'=>$balance_id));
        }                        
    }else if(empty($get_balance_data)){
        $balance_id=CI()->sm->store_bank_balance_data($data_to_insert);
    } 

    return $balance_id;
}

function store_cash_balance_data($inst_id,$inst_type,$creator_id,$balance_amount,$transfer_id=0,$type='credit'){
    $get_balance_data=CI()->sm->get_cash_balance(array('balance_inst_id'=>$inst_id,'balance_status'=>'active'));

    if(!empty($get_balance_data)){
        if($get_balance_data->balance_adjusted_amount>0){
            if($type=='credit'){
                $new_balance=$get_balance_data->balance_opening_amount+$balance_amount;
            }else if($type=='transfer_credit'){
                $new_balance=$get_balance_data->balance_opening_amount+$balance_amount;
            }else if($type=='debit'){
                $new_balance=$get_balance_data->balance_opening_amount-$balance_amount;
            }else if($type=='transfer_debit'){
                $new_balance=$get_balance_data->balance_opening_amount-$balance_amount;
            }             
        }else{
            $new_balance=$balance_amount;
        }
        
        $balance_adjusted_amount=$balance_amount;
    }else{
        $new_balance=$balance_amount;
        $balance_adjusted_amount=0;
    }

    $data_to_insert=array(
        'balance_inst_id'=>$inst_id,
        'balance_inst_type'=>$inst_type,
        'balance_transfer_id'=>$transfer_id,
        'balance_opening_amount'=>$new_balance,
        'balance_adjusted_amount'=>$balance_adjusted_amount,
        'balance_status'=>'active',
        'balance_is_credit_debit'=>$type,
        'balance_created_at'=>date('Y-m-d H:i:s'),
        'balance_created_by'=>$creator_id
    );

    if(!empty($get_balance_data)){
        if($get_balance_data->balance_adjusted_amount>0){
            CI()->sm->store_cash_balance_data($data_to_insert);
        }
        $balance_id=$get_balance_data->balance_id;
        if($get_balance_data->balance_adjusted_amount>0){
            CI()->sm->update_cash_balance_data(array('balance_status'=>'inactive','balance_updated_at'=>date('Y-m-d H:i:s'),'balance_updated_by'=>$creator_id),array('balance_id'=>$balance_id));
        }                        
    }else if(empty($get_balance_data)){
        $balance_id=CI()->sm->store_cash_balance_data($data_to_insert);
    }

    return $balance_id;
}


function store_installments($data,$db_group=null){
    $installment_unique_code=generate_string(4);
    $installment_data=array(
        'installment_no'=>$data['installment_no'],
        'installment_unique_code'=>$installment_unique_code,
        'installment_stu_id'=>$data['student_user_id'],
        'installment_inst_id'=>$data['inst_id'],
        'installment_admission_id'=>$data['admission_id'],
        'installment_sess_id'=>$data['session'],
        'installment_sess_year'=>$data['session_year'],
        'installment_course_id'=>$data['course'],
        'installment_value'=>$data['amount'],
        'installment_scholarship_discount'=>(!empty($data['discount']))?$data['discount']:'0.00',
        'installment_special_discount'=>'0.00',
        'installment_scholarship_discount_reason'=>null,
        'installment_special_discount_reason'=>null,
        'installment_paid_full'=>$data['paid_full'],
        'installment_date'=>$data['installment_date'],
        'created_by'=>$data['user_id'],
        'created_at'=>$data['created_at']
    );

    $installment_id=CI()->fm->store_installments($installment_data,FALSE,$db_group);

    if($installment_id){
        if($data['paid_full']=='yes'){
            $institute_payments_admission_fees_details=array(
                'payment_stu_id'=>$data['student_user_id'],
                'payment_inst_id'=>$data['inst_id'],
                'payment_session_id'=>$data['session'],
                'payment_course_id'=>$data['course'],
                'payment_admission_id'=>$data['admission_id'],
                'payment_installment_id'=>$installment_id,
                'payment_fees_total'=>$data['amount'],
                'payment_fees_grand_total'=>$data['amount'],
                'payment_fees_admission_amount'=>$data['amount'],
                'pay_mode'=>'old_payment_before_software',
                'created_by'=>$data['user_id'],
                'created_at'=>$data['created_at']
            );

            $payment_id=CI()->fm->store_fees_details($institute_payments_admission_fees_details,FALSE,$db_group);

            //Payment details
            $details_order_id=$data['admission_code'].'_'.date('Y').'_'.$data['installment_no'].'_'.generate_string(4).'_'.$installment_unique_code.'_stuinst';
            $details_order_code=$data['admission_code'].$installment_unique_code;
            $txn_id=ge_rand_code_v1('TXN'.$data['inst_id'].$data['user_id'].$data['admission_id'].$data['installment_no']);
            $payment_details=array(
                'details_type'=>'new_admission',
                'details_payment_type'=>'installment_fees',
                'details_type_text'=>'Admission Payment',
                'details_type_id'=>$data['admission_id'],
                'details_payment_id'=>$payment_id,
                'details_created_at_actual'=>$data['created_at'],
                'details_created_at'=>$data['created_at'],
                'details_emp_id'=>$data['emp_id'],
                'details_stu_id'=>$data['student_user_id'],
                'details_agent_id'=>null,
                'details_inst_id'=>$data['inst_id'], 
                'details_installment_id'=>$installment_id,          
                'details_parent_inst_id'=>$data['inst_parent_id'],
                'details_sess_id'=>$data['session'],
                'details_course_id'=>$data['course'],
                'details_payment_platform'=>'old_payment_before_software',
                'details_amount'=>$data['amount'],
                'details_discount_amount'=>'0',
                'details_txn_id'=>$txn_id,
                'details_order_id'=>$details_order_id,
                'details_order_code'=>$details_order_code,
                'details_accounting_type'=>'income',
                'details_accounting_type_id'=>'1',
                'details_accounting_dr_cr'=>'credit',
                'details_accounting_type_p_id'=>'19',
                'details_status'=>'success',
                'details_pay_currency'=>'inr',
                'details_msg'=>$data['details_msg'],
                'details_created_by_type'=>$data['user_type'],
                'details_created_by'=>$data['user_id'],            
                'details_updated_by_type'=>$data['user_type'],
                'details_updated_by'=>$data['user_id'],
                'details_updated_at'=>date('Y-m-d H:i:s')   
            );

            CI()->fm->store_payment_details($payment_details,$db_group);
        }  
    }

    return $installment_id;
}

//Auto credit to Cash or Bank Accounts
function auto_credit($data){

    $amount_paid=$data['amount_paid'];
    
    if($data['pay_auto_credit_account']!='0' && $data['pay_auto_credit_account']!='cash'){
        //Bank Balance update
        $balance_opening_amount=0;
        $get_balance_data=CI()->sm->get_bank_balance(array('balance_inst_id'=>$data['inst_id'],'balance_bank_id'=>$data['pay_auto_credit_account'],'balance_inst_type'=>$data['inst_type'],'balance_status'=>'active'));

        if(!empty($get_balance_data)){
            $last_balance=$get_balance_data->balance_opening_amount;
            $balance_opening_amount=$get_balance_data->balance_opening_amount;
        }

        $balance_amount=$last_balance+$amount_paid;
        $bank_balance=array(
            'balance_inst_id'=>$data['inst_id'],
            'balance_bank_id'=>$data['pay_auto_credit_account'],
            'balance_opening_amount'=>$balance_amount,
            'balance_adjusted_amount'=>$amount_paid,
            'balance_status'=>'active',
            'balance_created_by'=>$data['emp_id']
        );

        $balance_id=CI()->sm->store_bank_balance_data($bank_balance);
        if($balance_id){
            CI()->fm->update_payment_details(array('details_accounting_account'=>'bank_account','details_accounting_account_id'=>$data['pay_auto_credit_account']),array('details_id'=>$data['payment_details_id']));
            if(!empty($get_balance_data)){
                CI()->sm->update_bank_balance_data(array('balance_status'=>'inactive','balance_updated_by'=>$data['emp_id']),array('balance_id'=>$get_balance_data->balance_id));
            }                
        }
    }else if($data['pay_auto_credit_account']=='cash'){
        //Cash balance update
        $balance_opening_amount=0;
        $get_balance_data=CI()->sm->get_cash_balance(array('balance_inst_id'=>$data['inst_id'],'balance_status'=>'active'));

        if(!empty($get_balance_data)){
            $last_balance=$get_balance_data->balance_opening_amount;
            $balance_opening_amount=$get_balance_data->balance_opening_amount;
        }

        $balance_amount=$last_balance+$amount_paid;
        $cash_balance=array(
            'balance_inst_id'=>$data['inst_id'],                
            'balance_opening_amount'=>$balance_amount,
            'balance_adjusted_amount'=>$amount_paid,
            'balance_status'=>'active',
            'balance_created_by'=>$data['emp_id']
        );

        $balance_id=CI()->sm->store_cash_balance_data($cash_balance);
        if($balance_id){
            CI()->fm->update_payment_details(array('details_accounting_account'=>'cash_account'),array('details_id'=>$data['payment_details_id']));
            if(!empty($get_balance_data)){
                CI()->sm->update_cash_balance_data(array('balance_status'=>'inactive','balance_updated_by'=>$data['emp_id']),array('balance_id'=>$get_balance_data->balance_id));
            }                
        }
    }
}


/*function cheque_details_upload(){
    $cheque_no=post_data('pay_bank_cheque_no');
    $cheque_bank=post_data('pay_bank_name');
    $cheque_pay_deposite_bank=post_data('pay_deposite_bank');
    $details_msg='Cheque Recieved';
    $accounting_type='not_settled';

    if($data['cheque_bank']!='' && $data['cheque_no']!='' && ($data['deposite_bank']!='' && $data['deposite_bank']>0)){
        if($data['user_type']=='institute'){
            $parent_inst_id=$data['inst_id'];
            $storage_dir='institutes/'.$data['user_code'].'/payments/'.date('Y');
        }

        if(isset($_FILES['cheque_scan_frontcopy_file']) && $_FILES['cheque_scan_frontcopy_file']['name']!==''){

            $cheque_scan_frontcopy_file=array(
                'file_size'=>'5',
                'file_name'=>'cheque_scan_frontcopy_file',
                'file_types'=>'png,jpg,jpeg',
                'file_storage_type'=>'cheque_scan_frontcopy_file',
                'file_storage_dir'=>$storage_dir,
                'file_storage_type_id'=>$data['stu_id'],
                'file_parent_id'=>$data['inst_id'],
                'file_compress'=>false,
                'file_operation_type'=>'new',
                'file_uploaded_by'=>$data['user_id']
            );
    
            $cheque_scan_frontcopy_file_id=$this->onUploadFiles($cheque_scan_frontcopy_file);
        }

        if(isset($_FILES['cheque_scan_backcopy_file']) && $_FILES['cheque_scan_backcopy_file']['name']!=''){

            $cheque_scan_backcopy_file=array(
                'file_size'=>'5',
                'file_name'=>'cheque_scan_backcopy_file',
                'file_types'=>'png,jpg,jpeg',
                'file_storage_type'=>'cheque_scan_backcopy_file',
                'file_storage_dir'=>$storage_dir,
                'file_storage_type_id'=>$data['stu_id'],
                'file_parent_id'=>$data['inst_id'],
                'file_compress'=>false,
                'file_operation_type'=>'new',
                'file_uploaded_by'=>$data['user_id']
            );
    
            $cheque_scan_backcopy_file_id=CI()->onUploadFiles($cheque_scan_backcopy_file);
        }

        if(isset($cheque_scan_frontcopy_file_id) && isset($cheque_scan_backcopy_file_id)){

            if(is_numeric($cheque_scan_frontcopy_file_id) && is_numeric($cheque_scan_backcopy_file_id)){
                $booking_payment_checq_files_ids=$cheque_scan_frontcopy_file_id.','.$cheque_scan_backcopy_file_id;
            }                           
        }                                
    }else{
        $payment_can_be_recieved=false;
        $payment_msg='Cheque No.,Bank Name and  Deposite Bank details are required.';
    }
}*/