package com.api;
import java.text.DecimalFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import android.annotation.SuppressLint;
import android.app.Activity;
import android.app.AlertDialog;
import android.content.Context;
import android.content.DialogInterface;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.graphics.Color;
import android.os.Bundle;
import android.os.CountDownTimer;
import android.os.SystemClock;
import android.view.View;
import android.widget.Button;
import android.widget.Chronometer;
import android.widget.Toast;
@SuppressLint("ParserError")
public class PCRoom extends Activity {
private SQLiteOpenHelper mOpenHelper;
private SQLiteDatabase db;
private DatabaseHelper dbHelper;
private static final String MY_DATABASE_NAME = "time.db";
private static final String MY_DATABASE_TABLE = "time_table";
private static final int MY_DATABASE_VERSION = 2;
String[] arr;
SimpleDateFormat sdf = new SimpleDateFormat("HH:mm");
long time = System.currentTimeMillis();
Date dd = new Date(time);
Button button1;
int dialog2_selected;
int on_off;
CountDownTimer timer;
Cursor c1;
int hour;
int check;
long exit_time;
long current_time =System.currentTimeMillis();
private class DatabaseHelper extends SQLiteOpenHelper{
public DatabaseHelper(Context context) {
super(context, MY_DATABASE_NAME , null,MY_DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
try{
db.execSQL("CREATE TABLE " + MY_DATABASE_TABLE + "(" +
"_id INTEGER PRIMARY KEY autoincrement ," +
"time String, " +
"on_off INT, " +
"bunho INT, "+
"current_time LONG, "+
"sun_ho INT);");
}catch(Exception ex){
ex.printStackTrace();
}
// TODO Auto-generated method stub
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int currentVersion) {
db.execSQL("DROP TABLE IF EXISTS " + MY_DATABASE_TABLE);
onCreate(db);
// TODO Auto-generated method stub
}
}
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main4);
dbHelper = new DatabaseHelper(this);
db = dbHelper.getWritableDatabase();
dbHelper.onCreate(db);
arr = getResources().getStringArray(R.array.singers);
final Button exit_button = (Button)findViewById(R.id.exit);
String update = "select time, on_off, bunho, current_time, sun_ho " + " from " + MY_DATABASE_TABLE;
final Cursor c1 = db.rawQuery(update, null);
button1 = (Button)findViewById(R.id.button1);
c1.moveToFirst();
for(int i=0;i<c1.getCount();i++){
if(c1.getInt(1)==1 &&c1.getInt(2)==1){
button1.setBackgroundColor(Color.RED);
timer = new CountDownTimer(c1.getLong(0)-current_time, 1) {
public void onTick(long minutesUntilFinished) {
button1.setText("남은 시간 :" + minutesUntilFinished/(1000 * 60)+"분");
// Toast.makeText(PCRoom.this, Integer.toString(check), Toast.LENGTH_SHORT).show();
}
public void onFinish() {
button1.setText("finshed");
}
}.start();
}
if(c1.getInt(1)==1 &&c1.getInt(2)==1 && c1.getInt(4)==2){
SimpleDateFormat forma = new SimpleDateFormat("HH:mm");
String printime = forma.format(c1.getLong(3));
// Toast.makeText(PCRoom.this, Long.toString(c1.getLong(3)), Toast.LENGTH_SHORT).show();
button1.setText(printime);
button1.setBackgroundColor(Color.RED);
}
if(c1.getInt(1)==0 &&c1.getInt(2)==1 ){
button1.setText("1");
button1.setBackgroundColor(Color.parseColor("#FFFFFF"));
//timer.cancel();
//timer.onFinish();
}
c1.moveToNext();
}
c1.moveToFirst();
exit_button.setOnClickListener(new Button.OnClickListener(){
@Override
public void onClick(View v) {
new AlertDialog.Builder(PCRoom.this).setTitle("종료").setMessage("종료하시겠습니까?").setCancelable(false)
.setPositiveButton("종료", new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
//Intent intent = new Intent(PCRoom.this,MainActivity.class);
Toast.makeText(PCRoom.this, "종료되었습니다.", Toast.LENGTH_SHORT).show();
// startActivity(intent);
finish();
}
})
.setNegativeButton("취소", new DialogInterface.OnClickListener(){
@Override
public void onClick(DialogInterface dialog, int which) {
// TODO Auto-generated method stub
}
}).show();
}
});
button1 = (Button)findViewById(R.id.button1);
button1.setOnClickListener(new Button.OnClickListener(){
@Override
public void onClick(View v) {
if(button1.getText().toString().equals("1"))
{
new AlertDialog.Builder(PCRoom.this).setTitle("PC 1").setMessage("PC 1 사용가능")
.setPositiveButton("선불", new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
// TODO Auto-generated method stub
//button1.setText(sdf.format(dd));
//button1.setBackgroundColor(Color.RED);
new AlertDialog.Builder(PCRoom.this).setTitle("PC 1")
.setSingleChoiceItems(R.array.singers, 0, new DialogInterface.OnClickListener() {
public void onClick(DialogInterface dialog, int which) {
dialog2_selected = which;
}
}).setPositiveButton("확인",new DialogInterface.OnClickListener() {
public void onClick(DialogInterface dialog, int which) {
int bunhoo=1;
int sun_ho=1;
insertQuery(arr[dialog2_selected] , on_off, bunhoo, current_time,sun_ho);
String update = "UPDATE time_table SET on_off = 1 where bunho = ";
db.execSQL(update+"'"+bunhoo+"'");
String update2 = "UPDATE time_table SET sun_ho = 1 where bunho = ";
db.execSQL(update2+"'"+bunhoo+"'");
if(dialog2_selected ==0)
hour=1* 1000 * 60 * 60;
if(dialog2_selected ==1)
hour=2* 1000 * 60 * 60;
if(dialog2_selected ==2)
hour=3* 1000 * 60 * 60;
if(dialog2_selected ==3)
hour=5* 1000 * 60 * 60;
if(dialog2_selected ==4)
hour=7* 1000 * 60 * 60;
exit_time = hour+current_time;
String time_update = "UPDATE time_table Set time = ";
String time_update2 = "where bunho = ";
db.execSQL(time_update+"'"+exit_time+"'"+time_update2+"'"+bunhoo+"'");
timer = new CountDownTimer(exit_time-current_time, 1) {
public void onTick(long minutesUntilFinished) {
button1.setText("남은 시간 :" + minutesUntilFinished/(1000 * 60)+"분");
}
public void onFinish() {
button1.setText("finshed");
}
}.start();
button1.setText(sdf.format(dd));
button1.setBackgroundColor(Color.RED);
Toast.makeText(PCRoom.this, "사용시작", Toast.LENGTH_SHORT).show();
}
}).setNegativeButton("취소",null)
.create()
.show();
}
}).setNeutralButton("종료", new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
}
})
.setNegativeButton("후불", new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
new AlertDialog.Builder(PCRoom.this).setTitle("PC 1").setMessage("PC 1 사용가능")
.setPositiveButton("확인", new DialogInterface.OnClickListener() {
public void onClick(DialogInterface dialog, int which) {
int bunhoo =1;
int sun_ho=2;
insertQuery(arr[dialog2_selected] , on_off, bunhoo, current_time, sun_ho);
String update = "UPDATE time_table SET on_off = 1 where bunho = ";
db.execSQL(update+"'"+bunhoo+"'");
String update2 = "UPDATE time_table SET sun_ho = 2 where bunho = ";
db.execSQL(update2+"'"+bunhoo+"'");
String current_time_update = "UPDATE time_table Set current_time = ";
String current_time_update2 = "where bunho = ";
db.execSQL(current_time_update+"'"+current_time+"'"+current_time_update2+"'"+bunhoo+"'");
SimpleDateFormat forma = new SimpleDateFormat("HH:mm");
String printime = forma.format(current_time);
button1.setText(printime);
button1.setBackgroundColor(Color.RED);
}
}).setNegativeButton("취소", new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
}
}).show();
}
}).show();
}else
{
new AlertDialog.Builder(PCRoom.this).setTitle("사용중지").setMessage("사용중지")
.setNeutralButton("OK", new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
// TODO Auto-generated method stub
timer.cancel();
check =1 ;
int bun =1;
String update = "UPDATE time_table SET on_off = 0 where bunho = ";
db.execSQL(update+"'"+bun+"'");
button1.setText("1");
button1.setBackgroundColor(Color.parseColor("#FFFFFF"));
Toast.makeText(PCRoom.this, "사용중지", Toast.LENGTH_SHORT).show();
//Toast.makeText(PCRoom.this, Integer.toString(c1.getInt(4)), Toast.LENGTH_SHORT).show();
}
})
.setNegativeButton("NO", new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
// TODO Auto-generated method stub
}
}).show();
}
}
});
System.currentTimeMillis();
//후불 카운터
/*ct.setOnChronometerTickListener(new Chronometer.OnChronometerTickListener(){
public void onChronometerTick(Chronometer chronometer){
long elapsedMillis = SystemClock.elapsedRealtime() - chronometer.getBase();
DecimalFormat numFormatter = new DecimalFormat("###,###");
String output = numFormatter.format(elapsedMillis);
button1.setText("Total MiliSec. : "+output);
}
});*/
}
private void insertQuery(String time, int on_off, int bunho,long current_time, int sun_ho){
String insertMe = "INSERT INTO " + MY_DATABASE_TABLE +
"(time, on_off, bunho, current_time, sun_ho) " +
"VALUES ";
db.execSQL(insertMe + "( '"+ time +"'" + ", '"+on_off +"'"+ ", '"+bunho+"', '"+current_time+"', '"+sun_ho+"');");
}
private void updateSQL(String inputed_time, int inputed_on_off, int inputed_bunho,long current_time){
String update = "select time, on_off, bunho " + " from " + MY_DATABASE_TABLE;
Cursor c1 = db.rawQuery(update, null);
c1.close();
}
}
위에 소스에서 버튼을 누르면 선불 할 건지 후불 할건지 나옵니다. 그래서 선불을 누르면 시간 설정 하는게 나오고 시간을 선택해 확인을 누르면 시간 타이머가 작동 돼는데요 여기서 다시 버튼을 누르면 사용중지 할건지 안할건지 나옵니다 사용 중지를 나오면 처음 버튼 이름인 1 이 뜨는데 프로그램을 껏다가 다시 키면 사용중지 버튼은 먹는데 timer.cancel()이 되지 않아 버튼 이름이 1로 셋팅이 되지 않습니다.
그리고 DataBase 3번째에 get.Long(3) 에 현재 시간을 저장 해놨는데
onCreate문 바로 안에 if문에서 갔다 쓰려니까 불러와지질 않습니다... 도와주세요