Mudar a cor de um list view

[Matheus_Tavares1]

Estou fazendo algumas alterações em um app, e preciso que na minha consulta de clientes os clientes que não estão ativos devem aparecer em vermelho, mas a unica forma que achei seria criando um adpter, existe outra forma mais simples para fazer isso? segue minha classe:

package br.com.premiumweb.UI;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import android.app.Activity;
import android.app.AlertDialog;
import android.app.Dialog;
import android.content.DialogInterface;
import android.content.DialogInterface.OnClickListener;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.os.Environment;
import android.text.Editable;
import android.text.InputFilter;
import android.text.TextWatcher;
import android.view.View;
import android.view.View.OnFocusChangeListener;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.ArrayAdapter;
import android.widget.AutoCompleteTextView;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.RadioGroup;
import android.widget.SimpleAdapter;
import android.widget.TextView;
import br.com.premiumweb.UTIL.BuscaLocalidade;
import br.com.premiumweb.UTIL.FormatarDataValores;

public class ConsultaCliente extends Activity {

ListView listCli;
List<Map<String, String>> clientesList;
SQLiteDatabase database;
EditText editList, editCod;
AutoCompleteTextView editMunicipio;
SimpleAdapter adapter, adapterMun;
TextView totalReg, cnpj, textCodCli, pressItem, textCodNome, textCnpjCpf;
String codCli, razao, fantasia, situacao, cnpjCpf, ddd, telefone, endereco, municipio,
		complemento, bairro, recCodVend, texto, diaDaSemana, vendRestrito, txtMun = "", mult_vend,
		verCliInat = "", verCliInatE = "", codigoCli, recCnpjEmp;
int t;
private AlertDialog alert;
AlertDialog.Builder builder, builderAtend;
BuscaLocalidade gps;


@Override
protected void onCreate(Bundle savedInstanceState) {
	super.onCreate(savedInstanceState);
	setContentView(R.layout.consulta_cliente);
	
	
	
	diaDaSemana = "";
	
	editMunicipio = (AutoCompleteTextView) findViewById(R.id.editFiltroMunicipio);
	editMunicipio.setFilters(new InputFilter[] { new InputFilter.AllCaps() });
	editMunicipio.setHint("Filtrar por Município!");

	editList = (EditText) findViewById(R.id.editListCliente);
	editList.setFilters(new InputFilter[] { new InputFilter.AllCaps() });
	editList.setHint("Pesquisa Ativada Após 2 Letras!");
	editList.requestFocus();
	
	editCod = (EditText) findViewById(R.id.editCodCliente);
	editCod.setFilters(new InputFilter[] { new InputFilter.AllCaps() });
	editCod.setHint("Cod.");
	
	textCodNome = (TextView) findViewById(R.id.textListCodNome);
	
	recCodVend = getIntent().getStringExtra("codVendA");

	pressItem = (TextView) findViewById(R.id.textPressItemCli);
	pressItem.setText("PRESSIONE O REGISTRO PARA ALTERAR O CLIENTE!");
			
	clientesList = new ArrayList<Map<String, String>>();

	builder = new AlertDialog.Builder(this);
	builderAtend = new AlertDialog.Builder(this);

	listCli = (ListView) findViewById(R.id.listCliente);
	
	editList.addTextChangedListener(new TextWatcher() {

		@Override
		public void onTextChanged(CharSequence s, int start, int before,
				int count) {
			
			texto = editList.getText().toString();
			if(texto.equals("")){
				listCli.setAdapter(null);
			}else if(texto.length() >= 2){
				consulta();
			}
		}

		@Override
		public void afterTextChanged(Editable s) {}

		@Override
		public void beforeTextChanged(CharSequence s, int start, int count,
				int after) {}
	});
	editCod.addTextChangedListener(new TextWatcher() {

		@Override
		public void onTextChanged(CharSequence s, int start, int before,
				int count) {
			
			texto = editCod.getText().toString();
			if(texto.equals("")){
				listCli.setAdapter(null);
			}else if(texto.length() >= 1){
				consultaCod();
			}
		}

		@Override
		public void afterTextChanged(Editable s) {}

		@Override
		public void beforeTextChanged(CharSequence s, int start, int count,
				int after) {}
	});

	editMunicipio.addTextChangedListener(new TextWatcher() {

		@Override
		public void onTextChanged(CharSequence s, int start, int before,
				int count) {
			txtMun = editMunicipio.getText().toString();

			if (!txtMun.equals("") && txtMun.length() >= 2) {
				autoCompleteMunicipio();
			} 
		}

		@Override
		public void afterTextChanged(Editable s) {}

		@Override
		public void beforeTextChanged(CharSequence s, int start, int count,	int after) {}
	});
	
	listCli.setOnItemClickListener(new OnItemClickListener() {
		public void onItemClick(AdapterView<?> parent, View v,
				int position, long id) {

			String recTeste = getIntent().getStringExtra("testeClick");
			

			textCodCli = (TextView) v.findViewById(R.id.textListCodNome);
			textCnpjCpf = (TextView) v.findViewById(R.id.textListCnpjCpf);
			
			String codigoRazao = textCodCli.getText().toString();
			int cod = codigoRazao.indexOf("| ");
			codigoCli = codigoRazao.substring(0, cod);
			codigoCli = codigoCli.trim();
			
			int tamText = codigoRazao.length();
			String razaoCli = codigoRazao.substring(cod+2, tamText);
			
			String cnpjCpf = textCnpjCpf.getText().toString().replace(".", "").replace("/", "").replace("-", "");
			int n = cnpjCpf.length();
			cnpjCpf = cnpjCpf.substring(9, n);
			cnpjCpf = cnpjCpf.trim();
			
			if(recTeste == null){
				
				alert = builder.setCancelable(false).setPositiveButton("Sim", new OnClickListener() {
				
					@Override
					public void onClick(DialogInterface dialog,	int which) {
								
						alert.dismiss();

						String consulta = "tela";
															
						Intent prox = new Intent(ConsultaCliente.this, ClienteFornUI.class);
						prox.putExtra("teste", "teste");
						prox.putExtra("codVendA", recCodVend);
						prox.putExtra("codigoCli", codigoCli);
						prox.putExtra("consulta", consulta);
						prox.putExtra("autoC", "");
						startActivity(prox);
						finish();
					}
				}).setTitle("Deseja Editar o Cliente?").setNegativeButton("Não", new OnClickListener() {
					@Override
					public void onClick(DialogInterface dialog, int which) {
								
						alert.dismiss();
					}
				}).create();
				
				alert.show();
				
			}else if(recTeste.equals("atendimento")){
				
				try {
					
					database = SQLiteDatabase.openDatabase(Environment.getExternalStorageDirectory() + "/PremiumWeb/"
							+ "premiumweb.db", null, SQLiteDatabase.OPEN_READWRITE);
							
					String dataInicio = FormatarDataValores.getDate1();
					String horaInicio = FormatarDataValores.getDateTime();
					recCnpjEmp = getIntent().getStringExtra("cnpjEmp");
					recCodVend = getIntent().getStringExtra("codVendA");
					
					double latitude, longitude;
					
					gps = new BuscaLocalidade(ConsultaCliente.this);
					   
	                if(gps.canGetLocation()){
	                     
	                    latitude = gps.getLatitude();
	                    longitude = gps.getLongitude();

	                }else{
	                	latitude = 0;
	                	longitude = 0;
	                }
					
					String scriptInsert = "insert into localidade (cnpj_emp, tipo_prog, cod_vendedor, data_inicio, " 
						+" hora_inicio, lat_inicio, long_inicio, lat_pedido, long_pedido, num_pedido, cod_cliente," 
						+" cnpj_cli, razao_cli ) values ('"+recCnpjEmp+"', 'PREMIUMESTWEB', "+recCodVend+", '"+dataInicio
						+"', '"+horaInicio+"', "+latitude+", "+ longitude+", 0, 0, 0, "+codigoCli+", '"+cnpjCpf+"', '"
						+razaoCli+"')";
					
					database.execSQL(scriptInsert);
					database.close();
					
					builderAtend.setMessage("Atendimento Aberto!").setCancelable(false).setNeutralButton("OK", new OnClickListener() {
						
						@Override
						public void onClick(DialogInterface dialog,	int which) {
							finish();
						}
					}).create().show();							
				} catch (Exception e) {
					e.printStackTrace();
				}								
			}else{
				
				Intent data = new Intent();
				data.putExtra("codigoCli", codigoCli);
				data.putExtra("cliente", razaoCli);
				setResult(2, data);
				finish();
			}
		}
	});	
	
	database = SQLiteDatabase.openDatabase(Environment.getExternalStorageDirectory() + "/PremiumWeb/"
			+ "premiumweb.db", null, SQLiteDatabase.OPEN_READONLY);

	Cursor cParWeb = database.rawQuery("select * from parametros_web_tab",null);
	cParWeb.moveToFirst();
	
	vendRestrito = cParWeb.getString(cParWeb.getColumnIndex("blq_cli_vend"));
	mult_vend = cParWeb.getString(cParWeb.getColumnIndex("blq_cli_vend_mult"));
	String cliInativo = cParWeb.getString(cParWeb.getColumnIndex("ver_cli_inativo"));
	
	cParWeb.close();
	database.close();
	
	if(cliInativo.equals("N")){
		verCliInat = " and situacao <> 'I' and situacao <>'B' and situacao <>'F'";
		verCliInatE = " and c.situacao <> 'I' and situacao <>'B' and situacao <>'F'";
	}
	
	onFocus();
}

public void onFocus() {

	editList.setOnFocusChangeListener(new OnFocusChangeListener() {

		public void onFocusChange(View v, boolean hasFocus) {
			if (hasFocus) {

				if(!editMunicipio.getText().toString().equals("")){
					
					String vMun = editMunicipio.getText().toString();
					boolean recTest = testaMunicipio(vMun);
					
					if(recTest == false){
						return;
					}
				}
			}
		}
	});
}

public List<Map<String, String>> consulta() {

	Cursor c;
	
	if(texto == null){
		texto = "";
	}
	
	String diaSemana = "";
	
	if(!diaDaSemana.equals("")){
		diaSemana = " and c.diadasemana_cli like '%"+diaDaSemana+"%'";
	}
	
	String filtroMunic = editMunicipio.getText().toString();
	
	if(!filtroMunic.equals("")){
		filtroMunic = " and e.descric_mun = '"+filtroMunic+"'";
	}
	
	database = SQLiteDatabase.openDatabase(Environment.getExternalStorageDirectory() + "/PremiumWeb/" 
			+ "premiumweb.db", null, SQLiteDatabase.OPEN_READONLY);
	
	List<Map<String, String>> clientes = new ArrayList<Map<String, String>>();

	if(vendRestrito.equals("S")){
		     
		if(mult_vend.equals("S")){
			
			c = database.rawQuery("select c.cod_cliente, c.razaosocial, c.nomefant, c.situacao, c.cnpjcpf, e.ddd, "
				+" e.fone1, e.descricao, e.descric_mun, e.complemento, e.descricao_bai from clienteforn c, enderecogeral e"
				+" where c.cod_cliente = e.cod_endcad1 and c.cod_cliente = e.cod_endcad2 and e.tipoend = 'N'"
				+" and (c.razaosocial like '%"+texto+"%' or c.nomefant like '%"+texto+"%')"+ diaSemana + filtroMunic
				+verCliInatE+" and (c.cod_vendedor = "+recCodVend+ " or c.cod_vendedor2 = "+ recCodVend
				+" or c.cod_vendedor3 = "+ recCodVend+" or c.cod_vendedor4 = "+recCodVend+" ) order by c.razaosocial", null);
		}else{
			c = database.rawQuery("select c.cod_cliente, c.razaosocial, c.nomefant, c.situacao, c.cnpjcpf, e.ddd, "
				+" e.fone1, e.descricao, e.descric_mun, e.complemento, e.descricao_bai from clienteforn c, enderecogeral e"
				+" where c.cod_cliente = e.cod_endcad1 and c.cod_cliente = e.cod_endcad2 and c.cod_vendedor = "+recCodVend
				+ " and e.tipoend = 'N'"+" and (c.razaosocial like '%"+texto+"%' or c.nomefant like '%"+texto+"%')" 
				+ diaSemana + filtroMunic + verCliInatE + " order by c.razaosocial", null);
		}			
	}else{
		
		c = database.rawQuery("select c.cod_cliente, c.razaosocial, c.nomefant, c.situacao, c.cnpjcpf, e.ddd, "
			+" e.fone1, e.descricao, e.descric_mun, e.complemento, e.descricao_bai from clienteforn c, enderecogeral e"
			+" where c.cod_cliente = e.cod_endcad1 and c.cod_cliente = e.cod_endcad2 and e.tipoend = 'N'"
			+" and (c.razaosocial like '%"+texto+"%' or c.nomefant like '%"+texto+"%')"+ diaSemana+filtroMunic+verCliInatE
			+" order by c.razaosocial", null);
	}
			
	if (c.moveToFirst()) {
		while (!c.isAfterLast()) {
			
			codCli = c.getString(c.getColumnIndex("cod_cliente"));
			razao = c.getString(c.getColumnIndex("razaosocial"));
			fantasia = c.getString(c.getColumnIndex("nomefant"));
			situacao = c.getString(c.getColumnIndex("situacao"));
			cnpjCpf = c.getString(c.getColumnIndex("cnpjcpf"));
			ddd = c.getString(c.getColumnIndex("ddd"));
			telefone = c.getString(c.getColumnIndex("fone1"));
			endereco = c.getString(c.getColumnIndex("descricao"));
			municipio = c.getString(c.getColumnIndex("descric_mun"));
			complemento = c.getString(c.getColumnIndex("complemento"));
			bairro = c.getString(c.getColumnIndex("descricao_bai"));	
			
			if (cnpjCpf == null) {
				cnpjCpf = "";
			}

			if (endereco == null) {
				endereco = "";
			}
			
			if (bairro == null) {
				bairro = "";
			}
			
			if (complemento == null) {
				complemento = "";
			}
			
			if (ddd == null) {
				ddd = "";
			}
			
			if (municipio == null) {
				municipio = "";
			}
			
			if (telefone == null) {
				telefone = "";
			}
			
			if (fantasia == null) {
				fantasia = "";
			}else if (fantasia.length() > 20){
				fantasia = fantasia.substring(0, 20);
			}
			
			if (situacao.equals("A")) {
				situacao = "Ativo";
			}else if(situacao.equals("B")){
				situacao = "Bloqueado";
			}else if(situacao.equals("I")){
				situacao = "Inativo";
			}else if(situacao.equals("F")) {
				situacao = "Ativ.Encerrada";
			}
			
			Map<String, String> datum = new HashMap<String, String>(2);

			datum.put("campo1", codCli+ " | " + razao);
			datum.put("campo2", "Fantasia: "+fantasia);
			datum.put("campo3", "  Situação: "+situacao);

			int t = cnpjCpf.length();
			if (t == 11) {

				datum.put("campo4",	"CNPJ/CPF: " + cnpjCpf.replaceAll("(\\d{3})(\\d{3})(\\d{3})(\\d{2})", "$1.$2.$3-$4"));

			} else if (t == 14) {
				
				datum.put("campo4",	"CNPJ/CPF: " + cnpjCpf.replaceAll("(\\d{2})(\\d{3})(\\d{3})(\\d{4})(\\d{2})",
												"$1.$2.$3/$4-$5"));
			} else {

				datum.put("campo4", "CNPJ/CPF: " + cnpjCpf);
			}
			
			datum.put("campo5",	"  Tel: " + ddd.replaceAll("(\\d{2})", "($1)"));
			datum.put("campo6", " " + telefone);
			datum.put("campo7", "Endereço: " + endereco);
			datum.put("campo8", "Município: " + municipio);
			datum.put("campo9", "  Bairro: " + bairro);
			datum.put("campo10", "Complemento: " + complemento);

			clientes.add(datum);

			c.moveToNext();
		}
	}
	
	
	
		clientesList = clientes;


	
	
	adapter = new SimpleAdapter(this, clientesList,	R.layout.row_consulta_cliente, new String[] { "campo1",
		"campo2", "campo3", "campo4", "campo5", "campo6", "campo7", "campo8", "campo9", "campo10" }, new int[] { 
		R.id.textListCodNome, R.id.textListFantasia, R.id.textListSituacao, R.id.textListCnpjCpf, R.id.textListDDD, 
		R.id.textListTelefone1, R.id.textListEndereco, R.id.textListMunicipio, R.id.textListBairro,R.id.textListComplemento});
	listCli.setAdapter(adapter);
	
	
	
	c.close();
	database.close();
	return clientes;
}

public List<Map<String, String>> consultaCod() {

	Cursor c;
	
	if(texto == null){
		texto = "";
	}
	
	String diaSemana = "";
	
	if(!diaDaSemana.equals("")){
		diaSemana = " and c.diadasemana_cli like '%"+diaDaSemana+"%'";
	}
	
	String filtroMunic = editMunicipio.getText().toString();
	
	if(!filtroMunic.equals("")){
		filtroMunic = " and e.descric_mun = '"+filtroMunic+"'";
	}
	
	database = SQLiteDatabase.openDatabase(Environment.getExternalStorageDirectory() + "/PremiumWeb/" 
			+ "premiumweb.db", null, SQLiteDatabase.OPEN_READONLY);
	
	List<Map<String, String>> clientes = new ArrayList<Map<String, String>>();

	if(vendRestrito.equals("S")){
		     
		if(mult_vend.equals("S")){
			
			c = database.rawQuery("select c.cod_cliente, c.razaosocial, c.nomefant, c.situacao, c.cnpjcpf, e.ddd, "
				+" e.fone1, e.descricao, e.descric_mun, e.complemento, e.descricao_bai from clienteforn c, enderecogeral e"
				+" where c.cod_cliente = e.cod_endcad1 and c.cod_cliente = e.cod_endcad2 and e.tipoend = 'N'"
				+" and (c.cod_cliente like '"+texto+"%')"+ diaSemana + filtroMunic
				+verCliInatE+" and (c.cod_vendedor = "+recCodVend+ " or c.cod_vendedor2 = "+ recCodVend
				+" or c.cod_vendedor3 = "+ recCodVend+" or c.cod_vendedor4 = "+recCodVend+" ) order by c.cod_cliente", null);
		}else{
			c = database.rawQuery("select c.cod_cliente, c.razaosocial, c.nomefant, c.situacao, c.cnpjcpf, e.ddd, "
				+" e.fone1, e.descricao, e.descric_mun, e.complemento, e.descricao_bai from clienteforn c, enderecogeral e"
				+" where c.cod_cliente = e.cod_endcad1 and c.cod_cliente = e.cod_endcad2 and c.cod_vendedor = "+recCodVend
				+ " and e.tipoend = 'N'"+" and (c.cod_cliente like '"+texto+"%')" 
				+ diaSemana + filtroMunic + verCliInatE + " order by c.cod_cliente", null);
		}			
	}else{
		
		c = database.rawQuery("select c.cod_cliente, c.razaosocial, c.nomefant, c.situacao, c.cnpjcpf, e.ddd, "
			+" e.fone1, e.descricao, e.descric_mun, e.complemento, e.descricao_bai from clienteforn c, enderecogeral e"
			+" where c.cod_cliente = e.cod_endcad1 and c.cod_cliente = e.cod_endcad2 and e.tipoend = 'N'"
			+" and (c.cod_cliente like '"+texto+"%')"+ diaSemana+filtroMunic+verCliInatE
			+" order by c.cod_cliente", null);
	}
			
	if (c.moveToFirst()) {
		while (!c.isAfterLast()) {
			
			codCli = c.getString(c.getColumnIndex("cod_cliente"));
			razao = c.getString(c.getColumnIndex("razaosocial"));
			fantasia = c.getString(c.getColumnIndex("nomefant"));
			situacao = c.getString(c.getColumnIndex("situacao"));
			cnpjCpf = c.getString(c.getColumnIndex("cnpjcpf"));
			ddd = c.getString(c.getColumnIndex("ddd"));
			telefone = c.getString(c.getColumnIndex("fone1"));
			endereco = c.getString(c.getColumnIndex("descricao"));
			municipio = c.getString(c.getColumnIndex("descric_mun"));
			complemento = c.getString(c.getColumnIndex("complemento"));
			bairro = c.getString(c.getColumnIndex("descricao_bai"));	
			
			if (cnpjCpf == null) {
				cnpjCpf = "";
			}

			if (endereco == null) {
				endereco = "";
			}
			
			if (bairro == null) {
				bairro = "";
			}
			
			if (complemento == null) {
				complemento = "";
			}
			
			if (ddd == null) {
				ddd = "";
			}
			
			if (municipio == null) {
				municipio = "";
			}
			
			if (telefone == null) {
				telefone = "";
			}
			
			if (fantasia == null) {
				fantasia = "";
			}else if (fantasia.length() > 20){
				fantasia = fantasia.substring(0, 20);
			}
			
			if (situacao.equals("A")) {
				situacao = "Ativo";
			}else if(situacao.equals("B")){
				situacao = "Bloqueado";
			}else if(situacao.equals("I")){
				situacao = "Inativo";
			}else if(situacao.equals("F")) {
				situacao = "Ativ.Encerrada";
			}
			
			Map<String, String> datum = new HashMap<String, String>(2);

			datum.put("campo1", codCli+ " | " + razao);
			datum.put("campo2", "Fantasia: "+fantasia);
			datum.put("campo3", "  Situação: "+situacao);

			int t = cnpjCpf.length();
			if (t == 11) {

				datum.put("campo4",	"CNPJ/CPF: " + cnpjCpf.replaceAll("(\\d{3})(\\d{3})(\\d{3})(\\d{2})", "$1.$2.$3-$4"));

			} else if (t == 14) {
				
				datum.put("campo4",	"CNPJ/CPF: " + cnpjCpf.replaceAll("(\\d{2})(\\d{3})(\\d{3})(\\d{4})(\\d{2})",
												"$1.$2.$3/$4-$5"));
			} else {

				datum.put("campo4", "CNPJ/CPF: " + cnpjCpf);
			}
			
			datum.put("campo5",	"  Tel: " + ddd.replaceAll("(\\d{2})", "($1)"));
			datum.put("campo6", " " + telefone);
			datum.put("campo7", "Endereço: " + endereco);
			datum.put("campo8", "Município: " + municipio);
			datum.put("campo9", "  Bairro: " + bairro);
			datum.put("campo10", "Complemento: " + complemento);

			clientes.add(datum);

			c.moveToNext();
		}
	}

	clientesList = clientes;
	
	adapter = new SimpleAdapter(this, clientesList,	R.layout.row_consulta_cliente, new String[] { "campo1",
		"campo2", "campo3", "campo4", "campo5", "campo6", "campo7", "campo8", "campo9", "campo10" }, new int[] { 
		R.id.textListCodNome, R.id.textListFantasia, R.id.textListSituacao, R.id.textListCnpjCpf, R.id.textListDDD, 
		R.id.textListTelefone1, R.id.textListEndereco, R.id.textListMunicipio, R.id.textListBairro,R.id.textListComplemento});
	listCli.setAdapter(adapter);
	
	c.close();
	database.close();
	return clientes;
}

public void dialogDiaDaSemana(){
				
	final Dialog dialog = new Dialog(this);

	dialog.setContentView(R.layout.opcoes_dia_da_semana);

	dialog.setTitle("Escolha o Dia da Semana!");
	
	final Button btnOkDia = (Button) dialog.findViewById(R.id.btnOkOptionsCli);		
	final Button btnSairDia = (Button) dialog.findViewById(R.id.btnSairOptionCli);
	
	dialog.show();

	btnOkDia.setOnClickListener(new View.OnClickListener() {
		public void onClick(View v) {
							
			final RadioGroup  radGrupDiaSemana = (RadioGroup) dialog.findViewById(R.id.radGrupOptionDiaSemana);
			
			int op = radGrupDiaSemana.getCheckedRadioButtonId();
			
			if (op == R.id.radBtnSegunda) {
				
				diaDaSemana = "1";
				consulta();
								
			}else if (op == R.id.radBtnTerca){
				
				diaDaSemana = "2";
				consulta();
				
			}else if(op == R.id.radBtnQuarta){

				diaDaSemana = "3";
				consulta();
				
			}else if(op == R.id.radBtnQuinta){
					
				diaDaSemana = "4";
				consulta();
				
			}else if(op == R.id.radBtnSexta){
				
				diaDaSemana = "5";
				consulta();
				
			}else if(op == R.id.radBtnSabado){
				
				diaDaSemana = "6";
				consulta();
									
			}else if(op == R.id.radBtnDomingo){
				
				diaDaSemana = "7";
				consulta();
				
			}else if(op == R.id.radBtnTodos){
				
				diaDaSemana = "8";
				consulta();
				
			}else if(op == R.id.radBtnTodosCli){
				diaDaSemana = "";
				consulta();
			}

			dialog.dismiss();
		}
	});
	
	btnSairDia.setOnClickListener(new View.OnClickListener() {
		public void onClick(View v) {
							
			dialog.dismiss();
		}
	});

	dialog.show();	
}

public void autoCompleteMunicipio(){
	
	database = SQLiteDatabase.openDatabase(Environment.getExternalStorageDirectory() + "/PremiumWeb/"
			+ "premiumweb.db", null, SQLiteDatabase.OPEN_READONLY);

	Cursor c = database.rawQuery("select distinct descric_mun from enderecogeral where descric_mun <> ''"
			+ " and descric_mun like '%"+txtMun+"%'", null);
	
	ArrayList<String> results = new ArrayList<String>();
	
	while (c.moveToNext()) {
		results.add(c.getString(0));
	}
	
	ArrayAdapter<String> adapter = new ArrayAdapter<String>(this,R.layout.simple_dropdown, results);
	editMunicipio.setAdapter(adapter);
	
	c.close();
	database.close();
}
			
public boolean testaMunicipio(String vMun) {

	boolean tstMun;
	
	database = SQLiteDatabase.openDatabase(Environment.getExternalStorageDirectory() + "/PremiumWeb/"
					+ "premiumweb.db", null, SQLiteDatabase.OPEN_READONLY);

	Cursor c = database.rawQuery("select * from enderecogeral where descric_mun = '" + vMun	+ "'", null);

	int registros = c.getCount();
	if (registros != 0) {
		c.moveToFirst();

		txtMun = c.getString(c.getColumnIndex("descric_mun"));
		tstMun = true;

	} else {
		
		new AlertDialog.Builder(this).setMessage("Município Inválido!")
				.setCancelable(false).setNeutralButton("OK", null).show();
		editMunicipio.setText("");
		tstMun = false;
		
	}

	c.close();
	database.close();
	return tstMun;
}

public void imgBtnPesqCliente_click(View v){
	
	if(!editMunicipio.getText().toString().equals("")){
		
		String vMun = editMunicipio.getText().toString();
		boolean recTest = testaMunicipio(vMun);
		
		if(recTest == true){
			consulta();
		}
	}
}
	
public void imgBtnRelatCli_click(View v){
	editList.setText("");
	
	if(!editMunicipio.getText().toString().equals("")){
		
		String vMun = editMunicipio.getText().toString();
		boolean recTest = testaMunicipio(vMun);
		
		if(recTest == true){
			dialogDiaDaSemana();
		}
		
	}else{
		dialogDiaDaSemana();
	}		
}
	
public void imgBtnSairConsCli_click(View v){
	ConsultaCliente.super.onBackPressed();
}	

}