package endqr.sales.admin;



import java.io.File;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.FileOutputStream;



import java.io.IOException;

import java.io.InputStream;

import java.net.HttpURLConnection;

import java.net.URL;

import java.net.URLConnection;



import android.app.Activity;

import android.content.Intent;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.os.Bundle;

import android.os.Environment;

import android.view.View;

import android.view.View.OnClickListener;

import android.widget.Button;

import android.widget.EditText;

import android.widget.TextView;

import android.widget.Toast;



public class C_home extends Activity{

String xuser_name, isi_data;

mySqlHelper dbHelper;

protected Cursor cursor;



//private String fileName = "SampleSavingFile.txt";





 @Override

 public void onCreate(Bundle savedInstanceState){

 super.onCreate(savedInstanceState);

 setContentView(R.layout.home);

 

 Intent myIntent = this.getIntent();

 final TextView home_user = (TextView) findViewById(R.id.home_user);

 home_user.setText(myIntent.getStringExtra("xuser_name"));

 

 Button home_skip = (Button) findViewById(R.id.home_skip);

 home_skip.setOnClickListener(new OnClickListener() {

 

 @Override

 public void onClick(View v) {

 // TODO Auto-generated method stub

 xuser_name = home_user.getText().toString();

 Intent myIntent = new Intent(C_home.this, C_form_list_outlet.class);

 myIntent.putExtra("xuser_name", home_user.getText().toString());

 startActivity(myIntent);

 }

 });

 

 Button home_import = (Button) findViewById(R.id.home_import);

 home_import.setOnClickListener(new OnClickListener() {

 

 @Override

 public void onClick(View v) {

 // TODO Auto-generated method stub

 //login();

 }

 });

 



 Button home_call = (Button) findViewById(R.id.home_call);

 home_call.setOnClickListener(new OnClickListener() {

 

 @Override

 public void onClick(View v) {

 // TODO Auto-generated method stub

 Intent myIntent = new Intent(C_home.this, C_form_list_outlet.class);

 myIntent.putExtra("xuser_name", home_user.getText().toString());

 startActivity(myIntent);

 }

 });



 Button home_xcall = (Button) findViewById(R.id.home_xcall);

 home_xcall.setOnClickListener(new OnClickListener() {

 

 @Override

 public void onClick(View v) {

 // TODO Auto-generated method stub

 Intent myIntent = new Intent(C_home.this, C_form_list_outlet_xtra.class);

 myIntent.putExtra("xuser_name", home_user.getText().toString());

 startActivity(myIntent);

 }

 });

 

 Button home_lap_call = (Button) findViewById(R.id.home_lap_call);

 home_lap_call.setOnClickListener(new OnClickListener() {

 

 @Override

 public void onClick(View v) {

 // TODO Auto-generated method stub

 Intent myIntent = new Intent(C_home.this, C_form_lap_call.class);

 myIntent.putExtra("xuser_name", home_user.getText().toString());

 startActivity(myIntent);

 }

 });



 Button home_export = (Button) findViewById(R.id.home_export);

 home_export.setOnClickListener(new OnClickListener() {

 

 @Override

 public void onClick(View v) {

 // TODO Auto-generated method stub

 // final String name = txtName.getText().toString();

 //saveFile("Test Tulis", fileName);

 //cek_database();

// export_database();

 tulis();

 

 

 }

 });

 }

 

 



public void login(){

 setContentView(R.layout.main);

 final EditText main_user = (EditText) findViewById(R.id.main_user);

 final EditText main_pass = (EditText) findViewById(R.id.main_pass);

 

 Button main_login = (Button) findViewById(R.id.main_login);

 main_login.setOnClickListener(new OnClickListener() {

 

 @Override

 public void onClick(View v) {

 // TODO Auto-generated method stub

 final String user_name, pass;

 user_name = main_user.getText().toString();

 pass = main_pass.getText().toString();

 String urlSite = "http://192.168.0.1/pos/sambung.php?user_name="+user_name+"&pass;="+pass;

 String str = downloadTeks (urlSite);

// Toast.makeText(getBaseContext(), str, Toast.LENGTH_LONG).show();



 if(str.compareTo("Tersambung") == 0 ){

 Toast.makeText(getBaseContext(), "Selamat Datang "+user_name, Toast.LENGTH_LONG).show();

// method_form_list_outlet();

 import_database();

 }else{

 Toast.makeText(getBaseContext(), user_name+" Belum Terdaftar...", Toast.LENGTH_LONG).show();

 }



 

 }



 

 private String downloadTeks(String URL) {

 // TODO Auto-generated method stub

 InputStream in = null;

 try{

 in = openHttpConnection(URL);

 }catch(IOException e){}

 int charRead;

 StringBuffer data = new StringBuffer();

 String str = "";

 

 try{

 while ((charRead = in.read()) != -1){

 data.append((char) charRead);

 }

 str = data.toString();

 in.close();

 }catch(IOException e){}

 return str;

 }



 private InputStream openHttpConnection(String urlString) throws IOException {

 // TODO Auto-generated method stub

 InputStream in = null;

 int response = -1;

 URL url = new URL(urlString);

 URLConnection conn = url.openConnection();

 try{

 HttpURLConnection httpConn = (HttpURLConnection) conn;

 httpConn.setAllowUserInteraction(false);

 httpConn.setInstanceFollowRedirects(true);

 httpConn.setRequestMethod("GET");

 httpConn.connect();

 

 response = httpConn.getResponseCode();

 if(response == HttpURLConnection.HTTP_OK){

 in = httpConn.getInputStream();

 }

 }catch(Exception ex){

 throw new IOException("Error connecting");

 }

 return in;

 }

 });



}



 public void tulis(){

 t_jual();

 String filename = "data_esa.txt";

 File file = new File(Environment.getExternalStorageDirectory(), filename);

 FileOutputStream fos;

 byte[] data = new String(isi_data).getBytes();

 try {

 fos = new FileOutputStream(file);

 fos.write(data);

 fos.flush();

 fos.close();

 } catch (FileNotFoundException e) {

 // handle exception

 } catch (IOException e) {

 // handle exception

 }

 Toast.makeText(getBaseContext(), "Export data berhasil", Toast.LENGTH_LONG).show();



 }

 



 public void t_jual(){

 dbHelper = new mySqlHelper(this);

 SQLiteDatabase db = dbHelper.getReadableDatabase();

 try{

 cursor = db.rawQuery("SELECT * FROM t_barang ORDER by _id", null);

 if(cursor.getCount()>0){

 cursor.moveToFirst();

 isi_data = "";

 Integer jum = 0;

 jum = cursor.getCount();

 isi_data = "'kode_barang','nama_barang','satuan_barang','harga_barang'"+"

";

 while(jum > 0){

 isi_data = isi_data + "'" + cursor.getString(1) + "','" + cursor.getString(2) + "','" + cursor.getString(3) + "','" + cursor.getString(4) + "'" + "

";

 jum = jum - 1;

 cursor.moveToNext();

 }

 }else{

 isi_data = "DATA KOSONG";

 }

 }catch (Exception e) {

 // TODO: handle exception

 }

 }

 

 public void baca(){

 String filename = "data_esa.txt";

 File file = new File(Environment.getExternalStorageDirectory(), filename);

 FileInputStream fis;

 byte[] data = new String(isi_data).getBytes();

 try {

 fis = new FileInputStream(file);

 fis.read(data);

 fis.close();

 } catch (FileNotFoundException e) {

 // handle exception

 } catch (IOException e) {

 // handle exception

 }

 Toast.makeText(getBaseContext(), "Export data berhasil", Toast.LENGTH_LONG).show();



 }



 

 private void import_database() {

 // TODO Auto-generated method stub

 

 }

 

}