package by.idev.android.ownsqlitedb.activity;

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

import android.app.Activity;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.ListView;
import android.widget.SimpleAdapter;
import by.idev.android.ownsqlitedb.R;
import by.idev.android.ownsqlitedb.dbhelper.ExternalDbOpenHelper;

public class AndroidListViewActivity extends Activity{
    private static final String DB_NAME = "new.sqlite";
    // Хорошей практикой является задание имен полей БД константами
    private static final String TABLE_NAME = "friends";
    private static final String PREPOD_ID = "_id";
    private static final String PREPOD_FIO = "name";
    private static final String PREPOD_PHOTO = "photo";
    private static final String PREPOD_ayditoriya = "ayditoriya";
    private static final String PREPOD_STAT = "stat";

    private SQLiteDatabase database;
    private ListView listView;
    private ArrayList<String> stat, prepods;
    final String LOG_TAG = "myLogs";
    // private ArrayList<String> prepods, stat, prepods1, prepods2, prepods3,
    // prepods4;

    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);

        // Наш ключевой хелпер
        ExternalDbOpenHelper dbOpenHelper = new ExternalDbOpenHelper(this,
                DB_NAME);
        database = dbOpenHelper.openDataBase();
        // Все, база открыта!
        //fillName();
        setContentView(R.layout.list);
        ArrayList<Map<String, Object>> data = new ArrayList<Map<String, Object>>();
        final String name = "name";
        final String photo = "photo";
        final String ayditoriya = "ayditoriya";
        final String stat = "stat";

        Cursor friendCursor = database.query(TABLE_NAME, new String[] {
                PREPOD_ID, PREPOD_FIO, PREPOD_PHOTO, PREPOD_ayditoriya, PREPOD_STAT }, null, null, null, null, PREPOD_ID);
        friendCursor.moveToFirst();
        Map<String, Object> m;
        if (!friendCursor.isAfterLast()) {
            do {

                m = new HashMap<String, Object>();
                m.put(name, friendCursor.getString(1));
                m.put(photo, friendCursor.getInt(2));
                //m.put(ayditoriya, friendCursor.getString(3));
                m.put(stat, friendCursor.getString(4));
                data.add(m);
            } while (friendCursor.moveToNext());
        }
        friendCursor.close();

        String[] from = {name, photo, stat };
        int[] to = {R.id.label, R.id.foto, R.id.label1 };

        SimpleAdapter sAdapter = new SimpleAdapter(this, data,
                R.layout.list_item, from, to);
        listView = (ListView) findViewById(R.id.list);
        listView.setAdapter(sAdapter);




        listView.setOnItemClickListener(new OnItemClickListener() {
            public void onItemClick(AdapterView<?> parent, View view,
                    int position, long id) {
                  //Log.d(LOG_TAG, "itemClick: position = " + position + ", id = "
                      //+ id);

                Intent intent = new Intent(AndroidListViewActivity.this , proverka.class);


                }
              });
}
        //setUpList();



}