<?php
	class Banking_model extends CI_Model{

		public function add_benificiary($data){

            $this->db->insert('ci_account_benificiary', $data);
			return true;
        }
        
        public function update_benificiary($data,$id){
            $this->db->where(array('id'=>$id));
            $this->db->insert('ci_account_benificiary', $data);
			return true;
            
        }

		//---------------------------------------------------
		// get all users for server-side datatable processing (ajax based)

		public function get_all_benifici(){

			$this->db->select('*');
			if($this->session->userdata('is_supper')){
				//$this->db->where('status',1);
				return $this->db->get('ci_account_benificiary')->result_array();
			}
			else{
				$this->db->where('is_user', 1);
				$this->db->where('added_by',($this->session->userdata('user_id')));
                //$this->db->where('status',1);
				return $this->db->get('ci_account_benificiary')->result_array();
			}
		}

        public function get_account_holder_name($account_id){

            $query = $this->db->get_where('ci_bank_account', array('id' => $account_id));
			return $result = $query->row_array();

        }

		public function add_account($data){

			$this->db->insert('ci_bank_account', $data);
			return true;

		}

        public function get_all_account_list(){

            $this->db->select('*');
			if($this->session->userdata('is_supper')){
				$this->db->where('status',1);
				return $this->db->get('ci_bank_account')->result_array();
			}
			else{
				$this->db->where('is_user', 1);
				$this->db->where('added_by',($this->session->userdata('user_id')));
                $this->db->where('status',1);
				return $this->db->get('ci_bank_account')->result_array();
			}

        }



		public function get_all_statement($accno,$formdate,$todate){
		    
		    //	echo "select * from  ci_transaction where from_account_id='".$accno."' and (doe>='".$formdate."' or doe<='".$todate."') order by doe asc ";
			

			return  $this->db->query("select * from  ci_transaction where from_account_id='".$accno."' and (doe>='".$formdate."' and doe<='".$todate."') order by doe asc ")->result();
		
		}


		public function add_credit_transaction($data, $data2){

			$this->db->insert('ci_transaction', $data2);
   			$insert_id = $this->db->insert_id();
			$data['transaction_id'] = $insert_id ; 


			$this->db->insert('ci_credit', $data);
			return true;

		}

		public function add_debit_transaction($data,$data2){

			$this->db->insert('ci_transaction', $data2);
   			$insert_id = $this->db->insert_id();
			$data['transaction_id'] = $insert_id ;

			$this->db->insert('ci_debit', $data);
			return true;

		}
		
		public function change_benificary_status()
		{		
			$this->db->set('status', $this->input->post('status'));
			$this->db->where('id', $this->input->post('id'));
			$this->db->update('ci_account_benificiary');
		} 
		
		public function get_benifi_details_info($id){
		    
		    $this->db->where(array('id'=>$id));
		    return $this->db->get('ci_account_benificiary')->result()[0];
		}


		

	}

?>