hm-lok

PVOList.java (5695B)

---

 package de.jandankert.hansemerkur;
 
 import java.io.IOException;
 
 import android.app.AlertDialog;
 import android.app.ListActivity;
 import android.content.Context;
 import android.content.Intent;
 import android.database.Cursor;
 import android.database.sqlite.SQLiteDatabase;
 import android.location.Location;
 import android.location.LocationManager;
 import android.os.Bundle;
 import android.view.Menu;
 import android.view.MenuInflater;
 import android.view.MenuItem;
 import android.view.View;
 import android.widget.AdapterView;
 import android.widget.CursorAdapter;
 import android.widget.ListView;
 import android.widget.TextView;
 import android.widget.Toast;
 import android.widget.AdapterView.OnItemClickListener;
 import android.widget.AdapterView.OnItemLongClickListener;
 import de.jandankert.hansemerkur.adapter.PVOCursorAdapter;
 import de.jandankert.hansemerkur.db.DataBaseHelper;
 
 public class PVOList extends ListActivity
 {
 	private static final int MAX_ENTFERNUNG = 100;
 
 	/** Called when the activity is first created. */
 	@Override
 	public void onCreate(Bundle savedInstanceState)
 	{
 		super.onCreate(savedInstanceState);
 		setContentView(R.layout.pvo);
 
 		/*
 		 * 
 		 * DataBaseHelper myDbHelper = new DataBaseHelper(); myDbHelper = new
 		 * DataBaseHelper(this);
 		 * 
 		 * try {
 		 * 
 		 * myDbHelper.createDataBase();
 		 * 
 		 * } catch (IOException ioe) {
 		 * 
 		 * throw new Error("Unable to create database");
 		 * 
 		 * }
 		 * 
 		 * try {
 		 * 
 		 * myDbHelper.openDataBase();
 		 * 
 		 * }catch(SQLException sqle){
 		 * 
 		 * throw sqle;
 		 * 
 		 * }
 		 */
 
 		Location loc = getLocation();
 
 		DataBaseHelper db = new DataBaseHelper(this);
 		try
 		{
 			db.createDataBase();
 		} catch (IOException e)
 		{
 			throw new RuntimeException(e);
 		}
 		db.openDataBase();
 		SQLiteDatabase database = db.getReadableDatabase();
 
 		double lat = 50.0;
 		double lon = 10.3;
 		if (loc != null)
 		{
 
 			lat = loc.getLatitude();
 			lon = loc.getLongitude();
 		} else
 		{
 			new AlertDialog.Builder(this).setTitle(
 					getResources().getString(R.string.no_location_available))
 					.show();
 			// Toast.makeText(this,
 			// getResources().getString(R.string.no_location_available),
 			// Toast.LENGTH_LONG).show();
 		}
 		Toast.makeText(this, "Suche wird gestartet", Toast.LENGTH_SHORT).show();
 
 		double laengeLaengengrad = 40000 / 360;
 		double laengeBreitengrad = laengeLaengengrad
 				* Math.cos(Math.cos(Math.toRadians(lat)));
 		laengeBreitengrad = 67;
 
 		final String sql = "SELECT *,"
 				+ "(? * (?-vms.lat)* ? * (?-vms.lat)) + (? * (? - vms.lon)*(? * (? - vms.lon))) AS entfernung,"
 				// + "vms.strasse,vms.plz,vms.ort,vms.vorname,vms.nachname,"
 				+ " vms.plz as _id" + " FROM vms"
 				+ " where lon is not null and entfernung < (" + MAX_ENTFERNUNG
 				+ "*" + MAX_ENTFERNUNG + ")" + " order by entfernung";
 
 		String[] param = new String[] { "" + laengeBreitengrad, "" + lat,
 				"" + laengeBreitengrad, "" + lat, "" + laengeLaengengrad,
 				"" + lon, "" + laengeLaengengrad, "" + lon };
 
 		Cursor cursor = database.rawQuery(sql, param);
 
 		startManagingCursor(cursor);
 		
 		// Now create an array adapter and set it to display using our row
 		CursorAdapter pvoAdapter = new PVOCursorAdapter(this, cursor);
 
 		ListView list = getListView();
 		
 		list.setOnItemLongClickListener(new OnItemLongClickListener()
 		{
 
 			@Override
 			public boolean onItemLongClick(AdapterView<?> parent, View view,
 					int position, long id)
 			{
 				Toast.makeText(PVOList.this,
 						"Item in position " + position + " long clicked",
 						Toast.LENGTH_LONG).show();
 				// Return true to consume the click event. In this case the
 				// onListItemClick listener is not called anymore.
 				return true;
 			}
 		});
 		list.setOnItemClickListener(new OnItemClickListener()
 		{
 
 			@Override
 			public void onItemClick(AdapterView<?> parent, View view,
 					int position, long id)
 			{
 				final Intent i = new Intent(PVOList.this, PVODetail.class);
 				i.putExtra("id",id);
 				i.putExtra("ort",((TextView)view.findViewById(R.id.pvo_ort)).getText());
 				startActivity(i);
 			}
 		});
 
 		// list.setItemsCanFocus(false);
 		setListAdapter(pvoAdapter);
 
 	}
 
 	// @Override
 	// protected void onStop()
 	// {
 	// super.stop();
 	// }
 
 	private Location getLocation()
 	{
 		LocationManager lm = (LocationManager) getSystemService(Context.LOCATION_SERVICE);
 		Location loc = lm
 				.getLastKnownLocation(LocationManager.NETWORK_PROVIDER);
 
 		return loc;
 	}
 
 	@Override
 	public boolean onSearchRequested()
 	{
 		// TODO Auto-generated method stub
 		return super.onSearchRequested();
 	}
 
 	@Override
 	protected void onListItemClick(ListView l, View v, int position, long id)
 	{
 		super.onListItemClick(l, v, position, id);
 		// Get the item that was clicked
 		Object o = this.getListAdapter().getItem(position);
 		String keyword = o.toString();
 		Toast.makeText(this, "You selected with short click: " + keyword,
 				Toast.LENGTH_LONG).show();
 
 		// Intent i = new Intent(Intent.ACTION_VIEW, Uri
 		// .parse("google.navigation:q=New+York"));
 		// startActivity(i);
 
 		// Intent callIntent = new Intent(Intent.ACTION_CALL);
 		// callIntent.setData(Uri.parse("tel:123456789"));
 		// startActivity(callIntent);
 
 		// String uri = "geo:"+ latitude + "," + longitude;
 		// startActivity(new Intent(android.content.Intent.ACTION_VIEW,
 		// Uri.parse(uri)));
 	}
 
 	public boolean onCreateOptionsMenu(Menu menu)
 	{
 		super.onCreateOptionsMenu(menu);
 		MenuInflater mi = new MenuInflater(getApplication());
 		mi.inflate(R.menu.menu, menu);
 
 		return true;
 	}
 
 	public boolean onOptionsItemSelected(MenuItem item)
 	{
 		switch (item.getItemId())
 		{
 		case R.id.item01:
 			super.finish();
 			break;
 		default:
 
 		}
 		return true;
 	}
 
 }