erpsuiteandroid/Apex/src/com/usai/apex/ResultActivity.java

package com.usai.apex;

import java.util.ArrayList;
import java.util.HashMap;

import org.json.JSONException;
import org.json.JSONObject;

import com.usai.util.Network;
import com.usai.util.dbUtil;

import android.R.bool;
import android.R.integer;
import android.os.AsyncTask;
import android.os.Build;
import android.os.Bundle;
import android.animation.Animator;
import android.animation.AnimatorListenerAdapter;
import android.app.Activity;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.util.Log;
import android.view.Gravity;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.widget.Button;
import android.widget.TableRow;
import android.widget.TextView;
import android.widget.Toast;

public class ResultActivity extends Activity
{
	String user = null;
	String password = null;
	String function_name = null;
	private SearchTask m_task = null;

	Bundle searchParms = null;
	SearchResult searchresult = new SearchResult();

	HashMap<String, Integer> showfieldmap = new HashMap<String, Integer>();
	private TextView mStatusMessageView;
	private View mSearchFormView;
	private View mStatusView;

	@Override
	protected void onCreate(Bundle savedInstanceState)
	{
		user = getIntent().getStringExtra("user");
		password = getIntent().getStringExtra("password");
		function_name = getIntent().getStringExtra("function_name");
		searchParms = getIntent().getBundleExtra("searchParms");
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_result);
		mSearchFormView = findViewById(R.id.search_form);
		mStatusView = findViewById(R.id.status);
		mStatusMessageView = (TextView) findViewById(R.id.status_message);
		initTable();
		requestdata(true);

	}

	void initTable()
	{
		SQLiteDatabase db = dbUtil.OpenDB(this, null, false);
		Cursor cursor = db.query("fields_info",
				new String[] { "aname", "_id" }, "function_name='"
						+ function_name + "' and user='" + user
						+ "' and behavior=" + Network.BEHAVIOR_RESULT
						+ " and show = 1", null, null, null,
				"priority , aname", null);
		TableRow headerRow = (TableRow) findViewById(R.id.tr_header);
		int pos = 0;
		showfieldmap.clear();
		headerRow.removeAllViews();
		while (cursor.moveToNext())
		{
			String aname = cursor.getString(0);
			Button btn = new Button(this);
			btn.setText(aname);
			headerRow.addView(btn);
			showfieldmap.put(aname, pos);
		}
		dbUtil.CloseCursor(cursor);
		dbUtil.CloseDB(db);
	}

	@Override
	public boolean onCreateOptionsMenu(Menu menu)
	{
		// Inflate the menu; this adds items to the action bar if it is present.
		getMenuInflater().inflate(R.menu.result, menu);
		return true;
	}

	@Override
	public boolean onOptionsItemSelected(MenuItem item)
	{
		switch (item.getItemId())
		{
		case R.id.action_custom_fields:
			Intent intent = new Intent();
			intent.setClass(this, CustomizeFieldsActivity.class);
			intent.putExtra("user", user);
			// intent.putExtra("password", password);
			intent.putExtra("function_name", function_name);
			intent.putExtra("behavior", Network.BEHAVIOR_RESULT);
			startActivity(intent);
			break;

		default:
			break;
		}
		return super.onOptionsItemSelected(item);
	}

	public void requestdata(boolean requestcount)
	{
		if (m_task != null)
		{
			return;
		}
		mStatusMessageView.setText(R.string.login_progress_signing_in);
		showProgress(true);
		m_task = new SearchTask();
		m_task.execute(requestcount);

	}

	private void showProgress(final boolean show)
	{
		// On Honeycomb MR2 we have the ViewPropertyAnimator APIs, which allow
		// for very easy animations. If available, use these APIs to fade-in
		// the progress spinner.
		if (Build.VERSION.SDK_INT >= Build.VERSION_CODES.HONEYCOMB_MR2)
		{
			int shortAnimTime = getResources().getInteger(
					android.R.integer.config_shortAnimTime);

			mStatusView.setVisibility(View.VISIBLE);
			mStatusView.animate().setDuration(shortAnimTime)
					.alpha(show ? 1 : 0)
					.setListener(new AnimatorListenerAdapter()
					{
						@Override
						public void onAnimationEnd(Animator animation)
						{
							mStatusView.setVisibility(show ? View.VISIBLE
									: View.INVISIBLE);
						}
					});

			mSearchFormView.setVisibility(View.VISIBLE);
			mSearchFormView.animate().setDuration(shortAnimTime)
					.alpha(show ? 0 : 1)
					.setListener(new AnimatorListenerAdapter()
					{
						@Override
						public void onAnimationEnd(Animator animation)
						{
							mSearchFormView.setVisibility(show ? View.INVISIBLE
									: View.VISIBLE);
						}
					});
		}
		else
		{
			// The ViewPropertyAnimator APIs are not available, so simply show
			// and hide the relevant UI components.
			mStatusView.setVisibility(show ? View.VISIBLE : View.INVISIBLE);
			mSearchFormView.setVisibility(show ? View.INVISIBLE : View.VISIBLE);
		}
	}

	public class SearchTask extends AsyncTask<Boolean, Void, Boolean>
	{
		// int err_code = ERR_CODE_NONE;
		int errorcode;

		@Override
		protected Boolean doInBackground(Boolean... params)
		{

			if (!Network.NetworkIsAvailable())

			{
				errorcode = Network.RESULT_NET_NOTAVAILABLE;
				return false;
			}

			if (params[0])
			{
				int ret = Network.get_recordcount(user, password, searchParms);
				if (ret >= 0)
				{
					searchresult.put_totalcount(ret);
				}
				else
				{
					errorcode = ret;
					return false;
				}
			}

			String jstr = Network.get_records(user, password, searchParms);
			if (jstr == null || jstr.length() <= 0)
			{
				// Log.d(TAG, "json is wrong");
				errorcode = Network.RESULT_NET_ERROR;
				return false;
			}

			JSONObject jsobj;
			//
			// array = new JSONArray(json);
			try
			{
				jsobj = new JSONObject(jstr);
				if (searchresult.get_fieldscount() == 0)
				{
					JSONObject objfields = jsobj.getJSONObject("fields");
					searchresult.init_fields(objfields.toString());
				}
				JSONObject objrecords = jsobj.getJSONObject("records");
				searchresult.add_records(objrecords.toString());
				errorcode = Network.RESULT_TRUE;
				return true;

			}
			catch (JSONException e)
			{
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			errorcode = Network.RESULT_NET_ERROR;
			return false;

		}

		@Override
		protected void onPostExecute(final Boolean success)
		{
			Log.i("onPostExecute", "entry");
			m_task = null;
			showProgress(false);

			switch (errorcode)
			{
			case Network.RESULT_NET_NOTAVAILABLE:
			{
				Toast toast = Toast.makeText(getApplicationContext(),
						getText(R.string.msg_connection_none),
						Toast.LENGTH_LONG);
				toast.setGravity(Gravity.CENTER, 0, 0);
				toast.show();
				return;
			}
			case Network.RESULT_NET_ERROR:
			{
				Toast toast = Toast.makeText(getApplicationContext(),
						getText(R.string.msg_net_error), Toast.LENGTH_LONG);
				toast.setGravity(Gravity.CENTER, 0, 0);
				toast.show();
				return;
			}
			case Network.RESULT_ERROR:
			// case Network.RESULT_RESPONSE_NULL:
			{
				Toast toast = Toast.makeText(getApplicationContext(),
						getText(R.string.msg_net_resulterror),
						Toast.LENGTH_LONG);
				toast.setGravity(Gravity.CENTER, 0, 0);
				toast.show();
				return;
			}

			default:
				break;
			}

			if (success)
			{

				TextView tv_head = (TextView) findViewById(R.id.tv_head);
				tv_head.setText(searchresult.get_totalcount()+"");
				// SharedPreferences.Editor editor = RunOnce.edit();
				// editor.putBoolean("FirstRun"+globalUtil.getVerName(this),
				// false);
				// // Don't forget to commit your edits!!!
				// editor.commit();

				// Intent intent = new Intent();
				// intent.setClass(getActivity(), FunctionSelectActivity.class);
				// intent.putExtra("user", m_sUser);
				// intent.putExtra("password", m_sPassword);
				// startActivity(intent);
				// getActivity().finish();
			}
			else
			{
				// m_etPassword
				// .setError(getString(R.string.error_incorrect_password));
				// m_etPassword.requestFocus();
			}
		}

		@Override
		protected void onCancelled()
		{
			 m_task = null;
			 showProgress(false);
		}
	}

	private class SearchResult
	{
		int total_count = 0;
		// int count = 0;
		ArrayList<record> records = new ArrayList<record>();
		ArrayList<field> fields = new ArrayList<field>();

		public void init_fields(String jsonfields)
		{
			String TAG = "init_fields@ResultActivity.SearchResult";
			Log.d(TAG, jsonfields);

		}

		public void add_records(String records)
		{
			String TAG = "init_fields@ResultActivity.SearchResult";
			Log.d(TAG, records);
		}

		public int get_totalcount()
		{
			return total_count;
		}

		public void put_totalcount(int c)
		{
			total_count = c;
		}

		public int get_count()
		{
			return records.size();
		}

		public int get_fieldscount()
		{
			return fields.size();
		}

		private class record
		{
			ArrayList<Object> values;

		}

		private class field
		{
			String name = null;
			String aliasname = null;
			String type = null;

			public String get_name()
			{
				return name;
			}

			public String get_aliasname()
			{
				return aliasname;
			}

			public String get_type()
			{
				return type;
			}

		}

	}
}