001.package com.project2556.project;
002.
003.import java.util.ArrayList;
004.import com.projectDB.project.DBTime;
005.
006.import android.app.Activity;
007.import android.content.Intent;
008.import android.database.Cursor;
009.import android.database.sqlite.SQLiteDatabase;
010.import android.os.Bundle;
011.import android.util.Log;
012.import android.view.View;
013.import android.widget.ArrayAdapter;
014.import android.widget.Button;
015.import android.widget.EditText;
016.import android.widget.ImageView;
017.import android.widget.LinearLayout;
018.import android.widget.ListView;
019.import android.widget.SimpleCursorAdapter;
020.import android.widget.Spinner;
021.import android.widget.TextView;
022.import android.widget.Toast;
023.
024. public class Concludemonth extends Activity {
025.
026. Cursor myData;
027. SQLiteDatabase mDb;
028. ListView listView1;
029.
030. private Spinner pntmonth;
031. private Spinner pntYear;
032.
033. private String datamonth;
034. private String dataYear;
035.
036. @Override
037. protected void onCreate(Bundle savedInstanceState) {
038. super.onCreate(savedInstanceState);
039. setContentView(R.layout.concludemonth);
040.
041. month();
042. monthSpinner();
043.
044. Year();
045. YearSpinner();
046.
047. final DBTime myDb = new DBTime(this);
048. mDb = myDb.getWritableDatabase();
049.
050. ss();
051.
052. ImageView ko = (ImageView) findViewById(R.id.btnko);
053. ko.setOnClickListener(new View.OnClickListener() {
054. public void onClick(View v) {
055.
056. ss();
057.
058. }
059. });
060.
061.
062. final ImageView btnback = (ImageView) findViewById(R.id.btnback);
063. btnback.setOnClickListener(new View.OnClickListener() {
064. public void onClick(View v) {
065.
066. Intent newActivity = new Intent(Concludemonth.this,Conclude.class);
067. startActivity(newActivity);
068.
069. }
070. });
071.
072.
073.}
074.
075.
076. private void ss() {
077.
078. datamonth = String.valueOf(pntmonth.getSelectedItem());
079. if (datamonth=="ม.ค.") {datamonth = "1"; }
080. if (datamonth=="ก.พ.") {datamonth = "2"; }
081. if (datamonth=="มี.ค.") {datamonth = "3"; }
082. if (datamonth=="เม.ย.") {datamonth = "4"; }
083. if (datamonth=="พ.ค.") {datamonth = "5"; }
084. if (datamonth=="มิ.ย.") {datamonth = "6"; }
085. if (datamonth=="ก.ค.") {datamonth = "7"; }
086. if (datamonth=="ส.ค.") {datamonth = "8"; }
087. if (datamonth=="ก.ย.") {datamonth = "9"; }
088. if (datamonth=="ต.ค.") {datamonth = "10"; }
089. if (datamonth=="พ.ย.") {datamonth = "11"; }
090. if (datamonth=="ธ.ค.") {datamonth = "12"; }
091.
092.
093.
094.
095. dataYear = String.valueOf(pntYear.getSelectedItem());
096.
097. myData = mDb.rawQuery("SELECT ID_Day As _id , Du_MorningTime+Du_MiddayTime+Du_EveningTime As sum , * FROM " + DBTime.TABLE_data
098. + " WHERE " + DBTime.Month + "='" + datamonth + "'"
099. + " AND " + DBTime.Year + "='" + dataYear + "'" ,null);
100.
101.
102. listView1 = (ListView) findViewById(R.id.listView5);
103.
104.
105. SimpleCursorAdapter adapter;
106. adapter = new SimpleCursorAdapter(Concludemonth.this, R.layout.column2,
107. myData, new String[] { "Day","Month","Year", "Du_MorningTime", "Du_MiddayTime",
108. "Du_EveningTime","sum"
109. }, new int[] { R.id.Colname,R.id.Colname2,R.id.Colname3,
110. R.id.Colc1,R.id.Colc2, R.id.Colc3, R.id.sumTime
111. });
112. listView1.setAdapter(adapter);
113.
114.
115.
116. }
117.
118.
119.
120.
121.
122. private void month() {
123. pntmonth= (Spinner) findViewById(R.id.sMo);
124.
125. }
126.
127. private void monthSpinner() {
128. ArrayList<String> strmonth = new ArrayList<String>();
129. strmonth.add("ม.ค.");
130. strmonth.add("ก.พ.");
131. strmonth.add("มี.ค.");
132. strmonth.add("เม.ย.");
133. strmonth.add("พ.ค.");
134. strmonth.add("มิ.ย.");
135. strmonth.add("ก.ค.");
136. strmonth.add("ส.ค.");
137. strmonth.add("ก.ย.");
138. strmonth.add("ต.ค.");
139. strmonth.add("พ.ย.");
140. strmonth.add("ธ.ค.");
141.
142. ArrayAdapter<String> varmonth = new ArrayAdapter<String>(this,
143. android.R.layout.simple_spinner_item, strmonth);
144. varmonth
145. .setDropDownViewResource(android.R.layout.simple_spinner_item);
146.
147. pntmonth.setAdapter(varmonth);
148. }
149.
150.
151. private void Year() {
152. pntYear= (Spinner) findViewById(R.id.sY1);
153.
154. }
155.
156. private void YearSpinner() {
157. ArrayList<String> strYear = new ArrayList<String>();
158. strYear.add("2013");
159. strYear.add("2014");
160. strYear.add("2015");
161. strYear.add("2016");
162. strYear.add("2017");
163. strYear.add("2018");
164. strYear.add("2019");
165. strYear.add("2020");
166. strYear.add("2021");
167. strYear.add("2022");
168. strYear.add("2023");
169. strYear.add("2034");
170.
171. ArrayAdapter<String> varYear = new ArrayAdapter<String>(this,
172. android.R.layout.simple_spinner_item, strYear);
173. varYear
174. .setDropDownViewResource(android.R.layout.simple_spinner_item);
175.
176. pntYear.setAdapter(varYear);
177. }
178. }
