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

class calculadora_model extends CI_Model {
    function getDistribuidoras() {
        $data = array();
        $query = $this->db->query('select * from distribuidoras');
        if ($query->num_rows() > 0) {
        //  print_r($query);
            foreach ($query->result_array() as $row){
                    $data[] = $row;
                }
        }
        $query->free_result();
        return $data;
    }

    function getDepartamentos() {
        $data = array();
        $query = $this->db->query('select * from datos_x_depto');
        if ($query->num_rows() > 0) {
        //  print_r($query);
            foreach ($query->result_array() as $row){
                    $data[] = $row;
                }
        }
        $query->free_result();
        return $data;
    }

    function getDepartamento($nombreDepto) {
        $data = array();
        $query = $this->db->query('select * from datos_x_depto where departamento = ?',array($nombreDepto));
        if ($query->num_rows() > 0) {
        //  print_r($query);
            foreach ($query->result_array() as $row){
                    $data[] = $row;
                }
        }
        $query->free_result();
        return $data;
    }

    function getDatoPanel($datoPanel) {
        $data = array();
        $query = $this->db->query('select * from datosPanel where parametro = ?',array($datoPanel));
        if ($query->num_rows() > 0) {
        //  print_r($query);
            foreach ($query->result_array() as $row){
                    $data[] = $row;
                }
        }
        $query->free_result();
        return $data;
    }

    function getDistribuidora($distribuidora) {
        $data = array();
        $query = $this->db->query('select * from distribuidoras where distribuidora = ?', array($distribuidora));
        if ($query->num_rows() > 0) {
        //  print_r($query);
            foreach ($query->result_array() as $row){
                    $data[] = $row;
                }
        }
        $query->free_result();
        return $data;
    }


}
?>