<?php
class Hr_methods_model extends CI_Model{
	public function get_mapped_db_column($map_id){
		$get_column_qry = 'select GROUP_CONCAT(loc_name) as loc_name,GROUP_CONCAT(db_column) as db_column from cw_payroll_function_map where trans_status=1';
		$get_column_data   = $this->db->query("CALL sp_a_run ('SELECT','$get_column_qry')");
		$get_column_result = $get_column_data->result();
		$get_column_data->next_result();
		$loc_name          = explode(",",$get_column_result[0]->loc_name);
		$db_column         = explode(",",$get_column_result[0]->db_column);
		return array_combine($loc_name,$db_column);
	}
}
?>