Guest User

Untitled

a guest
Aug 22nd, 2018
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 25.65 KB | None | 0 0
  1. custom listview using cursor and it should display image as listitem
  2. dbHelper = new DatabaseHelper(this);
  3. try {
  4. String strDrSearchName = etSearchVisitDr.getText().toString();
  5. Cursor c = dbHelper.getViewAllDoctorSearch(strDrSearchName);
  6. Log.d("Search", "Search");
  7. startManagingCursor(c);
  8. from = new String[] {
  9. DatabaseHelper.colvarDrCode,
  10. DatabaseHelper.colvarDrName,
  11. DatabaseHelper.colvarCategory,
  12. DatabaseHelper.colvarCityName,
  13. DatabaseHelper.colvarSpeciality };
  14. to = new int[] {
  15. R.id.txtDrCode,
  16. R.id.txtDrName,
  17. R.id.txtDrCat,
  18. R.id.txtDrCity,
  19. R.id.txtDrSpec };
  20. SimpleCursorAdapter sca = new SimpleCursorAdapter(this,
  21. R.layout.gridvisitdoctor, c, from, to);
  22. list.setAdapter(sca);
  23.  
  24. package pkg.ecpTablet;
  25.  
  26. import java.text.SimpleDateFormat;
  27. import java.util.Date;
  28.  
  29. import android.app.Activity;
  30. import android.app.AlertDialog;
  31. import android.content.Context;
  32. import android.content.Intent;
  33. import android.database.Cursor;
  34. import android.database.sqlite.SQLiteCursor;
  35. import android.graphics.Color;
  36. import android.graphics.Path.FillType;
  37. import android.os.Bundle;
  38. import android.text.Editable;
  39. import android.text.TextWatcher;
  40. import android.view.LayoutInflater;
  41. import android.view.View;
  42. import android.view.ViewGroup;
  43. import android.view.View.OnClickListener;
  44. import android.webkit.WebChromeClient.CustomViewCallback;
  45. import android.widget.AdapterView;
  46. import android.widget.Button;
  47. import android.widget.EditText;
  48. import android.widget.ImageView;
  49. import android.widget.ListView;
  50. import android.widget.SimpleCursorAdapter;
  51. import android.widget.AdapterView.OnItemClickListener;
  52. import android.widget.TextView;
  53. import android.widget.Toast;
  54.  
  55. public class CurrentVisitDoctor extends Activity {
  56.  
  57. Button btnToggleAP;
  58. Button btnDrVisitback;
  59.  
  60. EditText etSearchDrVisit;
  61.  
  62. ListView listDrCurrentVisit;
  63.  
  64. TextView txtDate;
  65. TextView txtPlanned;
  66. TextView txtVisited;
  67. TextView txtTotal;
  68.  
  69. DatabaseHelper dbHelper;
  70. String strDate;
  71. String strCTDay;
  72.  
  73. ListView list;
  74.  
  75. String[] from;
  76. int[] to;
  77.  
  78. @Override
  79. protected void onCreate(Bundle savedInstanceState) {
  80. super.onCreate(savedInstanceState);
  81. setContentView(R.layout.currentvisitdoctor);
  82.  
  83. btnToggleAP = (Button) findViewById(R.id.btnToggleAP);
  84. btnDrVisitback = (Button) findViewById(R.id.btnDrVisitback);
  85.  
  86. etSearchDrVisit = (EditText) findViewById(R.id.etSearchDrVisit);
  87.  
  88. listDrCurrentVisit = (ListView) findViewById(R.id.listDrCurrentVisit);
  89.  
  90. txtDate = (TextView) findViewById(R.id.txtDate);
  91.  
  92. txtPlanned = (TextView) findViewById(R.id.txtPlanned);
  93. txtVisited = (TextView) findViewById(R.id.txtVisited);
  94. txtTotal = (TextView) findViewById(R.id.txtTotal);
  95.  
  96. btnDrVisitback.setOnClickListener(new OnClickListener() {
  97.  
  98. public void onClick(View arg0) {
  99. Intent iBack = new Intent(CurrentVisitDoctor.this,
  100. VisitHome.class);
  101. startActivity(iBack);
  102.  
  103. }
  104. });
  105.  
  106. // LoadGridTourPlanDr();
  107. fillDataTourPlannedDr();
  108. Bundle b = new Bundle();
  109. b = getIntent().getExtras();
  110.  
  111. final int flag = b.getInt("flag");
  112.  
  113. if (flag == 0) {
  114.  
  115. strDate = b.getString("ydate");
  116. txtDate.setText(strDate);
  117.  
  118. }
  119. if (flag == 1) {
  120. strDate = b.getString("date");
  121. txtDate.setText(strDate);
  122. }
  123. if (flag == 2) {
  124. strDate = b.getString("Date");
  125. txtDate.setText(strDate);
  126. }
  127.  
  128. try {
  129.  
  130. String strVisitDate = txtDate.getText().toString().trim();
  131.  
  132. SimpleDateFormat dateFormatMessage = new SimpleDateFormat(
  133. "dd/MM/yyyy");
  134. Date dtVisitDate = dateFormatMessage.parse(strVisitDate);
  135.  
  136. SimpleDateFormat postFormater = new SimpleDateFormat("yyyy-MM-dd");
  137. String dtMsgDate = postFormater.format(dtVisitDate);
  138.  
  139. // Toast.makeText(this,dtMsgDate, 30).show();
  140.  
  141. int CountTourPlan = dbHelper.CountTourPlanDr(dtMsgDate);
  142. int CountTotalVisited = dbHelper.CountTotalVisited(dtMsgDate);
  143. int CountVisit = dbHelper.getTodayDoneVisitDr(dtMsgDate);
  144.  
  145. txtPlanned.setText("Planned(" + CountTourPlan + ")");
  146. txtTotal.setText("Total(" + CountTotalVisited + ")");
  147. txtVisited.setText("Visit(" + CountVisit + ")");
  148.  
  149. /*
  150. * txtPlanned.setText(CountTourPlan); txtTotal.setText(CountVisit);
  151. * txtVisited.setText(CountTotalVisited);
  152. */
  153.  
  154. } catch (Exception e) {
  155. Alerts.ShowMessageAlert(CurrentVisitDoctor.this, "",
  156. String.valueOf(e));
  157. }
  158.  
  159. // Toast.makeText(CurrentVisitDoctor.this, String.valueOf(flag),
  160. // 30).show();
  161. btnToggleAP.setOnClickListener(new OnClickListener() {
  162.  
  163. public void onClick(View arg0) {
  164. etSearchDrVisit.setText("");
  165.  
  166. if (btnToggleAP.getText().toString().equals("P")) {
  167. btnToggleAP.setText("A");
  168. // LoadGridAllDr();
  169. fillDataAllDr();
  170.  
  171. } else {
  172. btnToggleAP.setText("P");
  173. // LoadGridTourPlanDr();
  174. fillDataTourPlannedDr();
  175.  
  176. }
  177.  
  178. }
  179.  
  180. });
  181.  
  182. etSearchDrVisit.addTextChangedListener(new TextWatcher() {
  183.  
  184. public void onTextChanged(CharSequence arg0, int arg1, int arg2,
  185. int arg3) {
  186. if (btnToggleAP.getText().toString().equals("P")) {
  187.  
  188. LoadGridTourPlanDrSearch();
  189. } else {
  190.  
  191. // LoadGridAllDrSearch();
  192. fillDataAllDrSearch();
  193. }
  194.  
  195. }
  196.  
  197. public void beforeTextChanged(CharSequence arg0, int arg1,
  198. int arg2, int arg3) {
  199. if (btnToggleAP.getText().toString().equals("P")) {
  200.  
  201. // LoadGridTourPlanDrSearch();
  202. fillDataTourPlannedDrSearch();
  203. } else {
  204.  
  205. // LoadGridAllDrSearch();
  206. fillDataAllDrSearch();
  207. }
  208.  
  209. }
  210.  
  211. public void afterTextChanged(Editable arg0) {
  212. if (btnToggleAP.getText().toString().equals("P")) {
  213.  
  214. // LoadGridTourPlanDrSearch();
  215. fillDataTourPlannedDrSearch();
  216. } else {
  217.  
  218. // LoadGridAllDrSearch();
  219. fillDataAllDrSearch();
  220. }
  221.  
  222. }
  223. });
  224.  
  225. listDrCurrentVisit.setOnItemClickListener(new OnItemClickListener() {
  226.  
  227. public void onItemClick(AdapterView<?> parent, View v,
  228. int position, long id) {
  229. // TODO Auto-generated method stub
  230. SQLiteCursor cr = (SQLiteCursor) parent
  231. .getItemAtPosition(position);
  232.  
  233. String DrName = cr.getString(cr
  234. .getColumnIndex(DatabaseHelper.colvarDrName));
  235. String DrCode = cr.getString(cr
  236. .getColumnIndex(DatabaseHelper.colvarDrCode));
  237. int intDrcode = Integer.parseInt(DrCode);
  238. int drGlCode = dbHelper.GetDrID(DrName);
  239.  
  240. String DrCategory = cr.getString(cr
  241. .getColumnIndex(DatabaseHelper.colvarCategory));
  242. String DrCityname = cr.getString(cr
  243. .getColumnIndexOrThrow(DatabaseHelper.colvarCityName));
  244.  
  245. String DrSpeciality = cr.getString(cr
  246. .getColumnIndex(DatabaseHelper.colvarSpeciality));
  247.  
  248. Bundle b = new Bundle();
  249. Intent deviatedvisits = new Intent(CurrentVisitDoctor.this,
  250. DoctorVisit.class);
  251. b.putInt("drGlCode", drGlCode);
  252. b.putString("drname", DrName);
  253. b.putString("drcode", DrCode);
  254. b.putString("drspeciality", DrSpeciality);
  255. b.putString("drcity", DrCityname);
  256. b.putString("drcategory", DrCategory);
  257. b.putInt("flag", flag);
  258.  
  259. b.putString("Date", txtDate.getText().toString());
  260.  
  261. deviatedvisits.putExtras(b);
  262. startActivity(deviatedvisits);
  263.  
  264. }
  265. });
  266.  
  267. }
  268.  
  269. public void LoadGridAllDr() {
  270. dbHelper = new DatabaseHelper(this);
  271. try {
  272.  
  273. // Cursor c=dbHelper.getTourPlan();
  274.  
  275. Cursor c = dbHelper.getViewAllDoctor();
  276. // Cursor
  277. // c=dbHelper.getViewAllDoctor(strDrSearchCode,strDrSearchName,strDrSearchCat,strDrSearchCity,strDrSearchSpec);
  278. startManagingCursor(c);
  279.  
  280. // int no = Integer.valueOf((String.valueOf(cr.toString())));
  281.  
  282. // txtVisitToday.setText(String.valueOf(cr.getColumnIndex("TodayPlan")));
  283.  
  284. // txtVisitToday.setText(String.valueOf(c.getColumnCount()));
  285. String[] from = new String[] { DatabaseHelper.colvarDrCode,
  286. DatabaseHelper.colvarDrName, DatabaseHelper.colvarCategory,
  287. DatabaseHelper.colvarCityName,
  288. DatabaseHelper.colvarSpeciality };
  289. int[] to = new int[] { R.id.txtDrCode, R.id.txtDrName,
  290. R.id.txtDrCat, R.id.txtDrCity, R.id.txtDrSpec };
  291. SimpleCursorAdapter sca = new SimpleCursorAdapter(this,
  292. R.layout.gridcurrentvisitdoctor, c, from, to);
  293. listDrCurrentVisit.setAdapter(sca);
  294. // Toast.makeText(VisitDoctor.this,
  295. // String.valueOf(dbHelper.getTodayPlanDrVisit()),
  296. // Toast.LENGTH_LONG).show();
  297.  
  298. } catch (Exception ex) {
  299. // AlertDialog.Builder b=new AlertDialog.Builder(this);
  300. // b.setMessage(ex.toString());
  301. // b.show();
  302. }
  303. }
  304.  
  305. public void LoadGridTourPlanDr() {
  306. dbHelper = new DatabaseHelper(this);
  307. try {
  308.  
  309. String strVisitDate = txtDate.getText().toString().trim();
  310. // Toast.makeText(CurrentVisitDoctor.this, strVisitDate, 30).show();
  311.  
  312. SimpleDateFormat dateFormatMessage = new SimpleDateFormat(
  313. "dd/MM/yyyy");
  314. Date dtVisitDate = dateFormatMessage.parse(strVisitDate);
  315.  
  316. SimpleDateFormat postFormater = new SimpleDateFormat("yyyy-MM-dd");
  317. String dtMsgDate = postFormater.format(dtVisitDate);
  318. // Cursor c=dbHelper.getTourPlan();
  319.  
  320. Cursor c = dbHelper.getViewPlanDoctor(dtMsgDate);
  321. // Cursor
  322. // c=dbHelper.getViewAllDoctor(strDrSearchCode,strDrSearchName,strDrSearchCat,strDrSearchCity,strDrSearchSpec);
  323. startManagingCursor(c);
  324.  
  325. // int intTourPlanToday = dbHelper.getTodayPlanDrVisit();
  326. // int no = Integer.valueOf((String.valueOf(cr.toString())));
  327.  
  328. // txtVisitToday.setText(String.valueOf(cr.getColumnIndex("TodayPlan")));
  329.  
  330. // txtVisitToday.setText(String.valueOf(c.getColumnCount()));
  331. String[] from = new String[] { DatabaseHelper.colvarDrCode,
  332. DatabaseHelper.colvarDrName, DatabaseHelper.colvarCategory,
  333. DatabaseHelper.colvarCityName,
  334. DatabaseHelper.colvarSpeciality };
  335. int[] to = new int[] { R.id.txtDrCode, R.id.txtDrName,
  336. R.id.txtDrCat, R.id.txtDrCity, R.id.txtDrSpec };
  337. SimpleCursorAdapter sca = new SimpleCursorAdapter(this,
  338. R.layout.gridcurrentvisitdoctor, c, from, to);
  339. listDrCurrentVisit.setAdapter(sca);
  340. // Toast.makeText(VisitDoctor.this,
  341. // String.valueOf(dbHelper.getTodayPlanDrVisit()),
  342. // Toast.LENGTH_LONG).show();
  343.  
  344. } catch (Exception ex) {
  345. // AlertDialog.Builder b=new AlertDialog.Builder(this);
  346. // b.setMessage(ex.toString());
  347. // b.show();
  348. }
  349. }
  350.  
  351. public void LoadGridAllDrSearch() {
  352. dbHelper = new DatabaseHelper(this);
  353. try {
  354.  
  355. String strDrSearchName = etSearchDrVisit.getText().toString();
  356.  
  357. String strDrName = etSearchDrVisit.getText().toString();
  358. String finaleDrNameSearch = strDrName;
  359. Cursor c = dbHelper.getViewAllDoctorSearch(finaleDrNameSearch);
  360.  
  361. // Cursor c=dbHelper.getViewAllDoctorSearch(strDrSearchCode,
  362. // strDrSearchName, strDrSearchCat, strDrSearchCity,
  363. // strDrSearchSpec);
  364.  
  365. startManagingCursor(c);
  366.  
  367. // int no = Integer.valueOf((String.valueOf(cr.toString())));
  368.  
  369. // txtVisitToday.setText(String.valueOf(cr.getColumnIndex("TodayPlan")));
  370.  
  371. // txtVisitToday.setText(String.valueOf(c.getColumnCount()));
  372. String[] from = new String[] { DatabaseHelper.colvarDrCode,
  373. DatabaseHelper.colvarDrName, DatabaseHelper.colvarCategory,
  374. DatabaseHelper.colvarCityName,
  375. DatabaseHelper.colvarSpeciality };
  376. int[] to = new int[] { R.id.txtDrCode, R.id.txtDrName,
  377. R.id.txtDrCat, R.id.txtDrCity, R.id.txtDrSpec };
  378. SimpleCursorAdapter sca = new SimpleCursorAdapter(this,
  379. R.layout.gridcurrentvisitdoctor, c, from, to);
  380. listDrCurrentVisit.setAdapter(sca);
  381. // Toast.makeText(VisitDoctor.this,
  382. // String.valueOf(dbHelper.getTodayPlanDrVisit()),
  383. // Toast.LENGTH_LONG).show();
  384.  
  385. } catch (Exception ex) {
  386. AlertDialog.Builder b = new AlertDialog.Builder(this);
  387. b.setMessage(ex.toString());
  388. b.show();
  389. }
  390. }
  391.  
  392. public void LoadGridTourPlanDrSearch() {
  393. dbHelper = new DatabaseHelper(this);
  394. try {
  395.  
  396. String strVisitDate = txtDate.getText().toString().trim();
  397.  
  398. SimpleDateFormat dateFormatMessage = new SimpleDateFormat(
  399. "dd/MM/yyyy");
  400. Date dtVisitDate = dateFormatMessage.parse(strVisitDate);
  401.  
  402. SimpleDateFormat postFormater = new SimpleDateFormat("yyyy-MM-dd");
  403. String dtMsgDate = postFormater.format(dtVisitDate);
  404.  
  405. String strDrName = etSearchDrVisit.getText().toString();
  406. String finaleDrNameSearch = strDrName;
  407. Cursor c = dbHelper.getViewPlanDoctorSearch(finaleDrNameSearch,
  408. dtMsgDate);
  409.  
  410. // Cursor c=dbHelper.getViewPlanDoctorSearch(strDrSearchCode,
  411. // strDrSearchName, strDrSearchCat, strDrSearchCity,
  412. // strDrSearchSpec);
  413.  
  414. startManagingCursor(c);
  415.  
  416. // int no = Integer.valueOf((String.valueOf(cr.toString())));
  417.  
  418. // txtVisitToday.setText(String.valueOf(cr.getColumnIndex("TodayPlan")));
  419.  
  420. // txtVisitToday.setText(String.valueOf(c.getColumnCount()));
  421. String[] from = new String[] { DatabaseHelper.colvarDrCode,
  422. DatabaseHelper.colvarDrName, DatabaseHelper.colvarCategory,
  423. DatabaseHelper.colvarCityName,
  424. DatabaseHelper.colvarSpeciality };
  425. int[] to = new int[] { R.id.txtDrCode, R.id.txtDrName,
  426. R.id.txtDrCat, R.id.txtDrCity, R.id.txtDrSpec };
  427. SimpleCursorAdapter sca = new SimpleCursorAdapter(this,
  428. R.layout.gridcurrentvisitdoctor, c, from, to);
  429. listDrCurrentVisit.setAdapter(sca);
  430. // Toast.makeText(VisitDoctor.this,
  431. // String.valueOf(dbHelper.getTodayPlanDrVisit()),
  432. // Toast.LENGTH_LONG).show();
  433.  
  434. } catch (Exception ex) {
  435. AlertDialog.Builder b = new AlertDialog.Builder(this);
  436. b.setMessage(ex.toString());
  437. b.show();
  438. }
  439. }
  440.  
  441. @Override
  442. protected void onStart() {
  443. // TODO Auto-generated method stub
  444. super.onStart();
  445.  
  446. btnToggleAP = (Button) findViewById(R.id.btnToggleAP);
  447. btnDrVisitback = (Button) findViewById(R.id.btnDrVisitback);
  448.  
  449. etSearchDrVisit = (EditText) findViewById(R.id.etSearchDrVisit);
  450.  
  451. listDrCurrentVisit = (ListView) findViewById(R.id.listDrCurrentVisit);
  452.  
  453. txtDate = (TextView) findViewById(R.id.txtDate);
  454.  
  455. // LoadGridTourPlanDr();
  456. fillDataTourPlannedDr();
  457. Bundle b = new Bundle();
  458. b = getIntent().getExtras();
  459.  
  460. final int flag = b.getInt("flag");
  461.  
  462. if (flag == 0) {
  463.  
  464. strDate = b.getString("ydate");
  465. txtDate.setText(strDate);
  466.  
  467. }
  468. if (flag == 1) {
  469. strDate = b.getString("date");
  470. txtDate.setText(strDate);
  471. }
  472. if (flag == 2) {
  473. strDate = b.getString("Date");
  474. txtDate.setText(strDate);
  475. }
  476. }
  477.  
  478. protected void fillDataAllDr() {
  479.  
  480. dbHelper = new DatabaseHelper(this);
  481.  
  482. Cursor c = dbHelper.getViewAllDoctor();
  483. startManagingCursor(c);
  484.  
  485. from = new String[] { DatabaseHelper.colvarDrCode,
  486. DatabaseHelper.colvarDrName, DatabaseHelper.colvarCategory,
  487. DatabaseHelper.colvarCityName, DatabaseHelper.colvarSpeciality };
  488. to = new int[] { R.id.txtDrCode, R.id.txtDrName, R.id.txtDrCat,
  489. R.id.txtDrCity, R.id.txtDrSpec };
  490. // SimpleCursorAdapter sca = new SimpleCursorAdapter(this,
  491. // R.layout.gridvisitdoctor, c, from, to);
  492.  
  493. customCursorAdapter cca = new customCursorAdapter(this,
  494. R.layout.gridvisitdoctor, c, from, to);
  495. listDrCurrentVisit.setAdapter(cca);
  496. }
  497.  
  498. protected void fillDataTourPlannedDr() {
  499.  
  500. dbHelper = new DatabaseHelper(this);
  501. try {
  502. // Cursor c = dbHelper.getViewAllDoctor();
  503. // startManagingCursor(c);
  504.  
  505. String strVisitDate = txtDate.getText().toString().trim();
  506. // Toast.makeText(CurrentVisitDoctor.this, strVisitDate, 30).show();
  507.  
  508. SimpleDateFormat dateFormatMessage = new SimpleDateFormat(
  509. "dd/MM/yyyy");
  510. Date dtVisitDate = dateFormatMessage.parse(strVisitDate);
  511.  
  512. SimpleDateFormat postFormater = new SimpleDateFormat("yyyy-MM-dd");
  513. String dtMsgDate = postFormater.format(dtVisitDate);
  514. // Cursor c=dbHelper.getTourPlan();
  515.  
  516. Cursor c = dbHelper.getViewPlanDoctor(dtMsgDate);
  517. // Cursor
  518. // c=dbHelper.getViewAllDoctor(strDrSearchCode,strDrSearchName,strDrSearchCat,strDrSearchCity,strDrSearchSpec);
  519. startManagingCursor(c);
  520.  
  521. // int intTourPlanToday = dbHelper.getTodayPlanDrVisit();
  522.  
  523. from = new String[] { DatabaseHelper.colvarDrCode,
  524. DatabaseHelper.colvarDrName, DatabaseHelper.colvarCategory,
  525. DatabaseHelper.colvarCityName,
  526. DatabaseHelper.colvarSpeciality };
  527. to = new int[] { R.id.txtDrCode, R.id.txtDrName, R.id.txtDrCat,
  528. R.id.txtDrCity, R.id.txtDrSpec };
  529. // SimpleCursorAdapter sca = new SimpleCursorAdapter(this,
  530. // R.layout.gridvisitdoctor, c, from, to);
  531.  
  532. customCursorAdapter cca = new customCursorAdapter(this,
  533. R.layout.gridvisitdoctor, c, from, to);
  534. listDrCurrentVisit.setAdapter(cca);
  535. } catch (Exception ex) {
  536. // AlertDialog.Builder b=new AlertDialog.Builder(this);
  537. // b.setMessage(ex.toString());
  538. // b.show();
  539. }
  540.  
  541. }
  542.  
  543. protected void fillDataAllDrSearch() {
  544.  
  545. dbHelper = new DatabaseHelper(this);
  546. try {
  547.  
  548. String strDrSearchName = etSearchDrVisit.getText().toString();
  549.  
  550. String strDrName = etSearchDrVisit.getText().toString();
  551. String finaleDrNameSearch = strDrName;
  552. Cursor c = dbHelper.getViewAllDoctorSearch(finaleDrNameSearch);
  553.  
  554. // Cursor c=dbHelper.getViewAllDoctorSearch(strDrSearchCode,
  555. // strDrSearchName, strDrSearchCat, strDrSearchCity,
  556. // strDrSearchSpec);
  557.  
  558. startManagingCursor(c);
  559. // Cursor c = dbHelper.getViewAllDoctor();
  560. // startManagingCursor(c);
  561.  
  562. from = new String[] { DatabaseHelper.colvarDrCode,
  563. DatabaseHelper.colvarDrName, DatabaseHelper.colvarCategory,
  564. DatabaseHelper.colvarCityName,
  565. DatabaseHelper.colvarSpeciality };
  566. to = new int[] { R.id.txtDrCode, R.id.txtDrName, R.id.txtDrCat,
  567. R.id.txtDrCity, R.id.txtDrSpec };
  568. // SimpleCursorAdapter sca = new SimpleCursorAdapter(this,
  569. // R.layout.gridvisitdoctor, c, from, to);
  570.  
  571. customCursorAdapter cca = new customCursorAdapter(this,
  572. R.layout.gridcurrentvisitdoctor, c, from, to);
  573. listDrCurrentVisit.setAdapter(cca);
  574. } catch (Exception ex) {
  575. AlertDialog.Builder b = new AlertDialog.Builder(this);
  576. b.setMessage(ex.toString());
  577. b.show();
  578. }
  579.  
  580. }
  581.  
  582. protected void fillDataTourPlannedDrSearch() {
  583.  
  584. dbHelper = new DatabaseHelper(this);
  585. try {
  586.  
  587. String strVisitDate = txtDate.getText().toString().trim();
  588.  
  589. SimpleDateFormat dateFormatMessage = new SimpleDateFormat(
  590. "dd/MM/yyyy");
  591. Date dtVisitDate = dateFormatMessage.parse(strVisitDate);
  592.  
  593. SimpleDateFormat postFormater = new SimpleDateFormat("yyyy-MM-dd");
  594. String dtMsgDate = postFormater.format(dtVisitDate);
  595.  
  596. String strDrName = etSearchDrVisit.getText().toString();
  597. String finaleDrNameSearch = strDrName;
  598. Cursor c = dbHelper.getViewPlanDoctorSearch(finaleDrNameSearch,
  599. dtMsgDate);
  600.  
  601. // Cursor c=dbHelper.getViewPlanDoctorSearch(strDrSearchCode,
  602. // strDrSearchName, strDrSearchCat, strDrSearchCity,
  603. // strDrSearchSpec);
  604.  
  605. startManagingCursor(c);
  606.  
  607. // int intTourPlanToday = dbHelper.getTodayPlanDrVisit();
  608.  
  609. from = new String[] { DatabaseHelper.colvarDrCode,
  610. DatabaseHelper.colvarDrName, DatabaseHelper.colvarCategory,
  611. DatabaseHelper.colvarCityName,
  612. DatabaseHelper.colvarSpeciality };
  613. to = new int[] { R.id.txtDrCode, R.id.txtDrName, R.id.txtDrCat,
  614. R.id.txtDrCity, R.id.txtDrSpec };
  615. // SimpleCursorAdapter sca = new SimpleCursorAdapter(this,
  616. // R.layout.gridvisitdoctor, c, from, to);
  617.  
  618. customCursorAdapter cca = new customCursorAdapter(this,
  619. R.layout.gridcurrentvisitdoctor, c, from, to);
  620. listDrCurrentVisit.setAdapter(cca);
  621. } catch (Exception ex) {
  622. // AlertDialog.Builder b=new AlertDialog.Builder(this);
  623. // b.setMessage(ex.toString());
  624. // b.show();
  625. }
  626.  
  627. }
  628.  
  629. } // class complete
  630.  
  631. // ListView Adapter Class
  632.  
  633. class customCursorAdapter extends SimpleCursorAdapter {
  634. private int layout;
  635. Context context;
  636.  
  637. public customCursorAdapter(Context context, int layout, Cursor cursor,
  638. String[] from, int[] to) {
  639. super(context, layout, cursor, from, to);
  640. this.layout = layout;
  641. this.context = context;
  642.  
  643. }
  644.  
  645. @Override
  646. public void bindView(View view, Context context, Cursor cursor) {
  647. ViewHolder holder;
  648. int flag = 1;
  649. if (view != null) {
  650. holder = new ViewHolder();
  651. holder.txtViewDrname = (TextView) view.findViewById(R.id.txtDrName);
  652. holder.txtViewDrCode = (TextView) view.findViewById(R.id.txtDrCode);
  653. holder.txtViewDrSpec = (TextView) view.findViewById(R.id.txtDrSpec);
  654. holder.txtViewDrCity = (TextView) view.findViewById(R.id.txtDrCity);
  655. holder.txtViewDrCat = (TextView) view.findViewById(R.id.txtDrCat);
  656. holder.imgbullet = (ImageView) view.findViewById(R.id.imgVisited);
  657.  
  658. view.setTag(holder);
  659. } else {
  660. holder = (ViewHolder) view.getTag();
  661. }
  662.  
  663. String DrName = cursor.getString(cursor
  664. .getColumnIndex(DatabaseHelper.colvarDrName));
  665. // String name = cursor.;
  666.  
  667. if (holder.txtViewDrname != null) {
  668. holder.txtViewDrname.setText(DrName);
  669. holder.txtViewDrname.setTextColor(Color.RED);
  670. }
  671.  
  672. String DrCode = cursor.getString(cursor
  673. .getColumnIndex(DatabaseHelper.colvarDrCode));
  674. holder.txtViewDrCode.setText(DrCode);
  675.  
  676. String DrSpeciality = cursor.getString(cursor
  677. .getColumnIndex(DatabaseHelper.colvarSpeciality));
  678. holder.txtViewDrSpec.setText(DrSpeciality);
  679.  
  680. String DrCityName = cursor.getString(cursor
  681. .getColumnIndex(DatabaseHelper.colvarCityName));
  682. holder.txtViewDrCity.setText(DrCityName);
  683.  
  684. String DrCategory = cursor.getString(cursor
  685. .getColumnIndex(DatabaseHelper.colvarCategory));
  686. holder.txtViewDrCat.setText(DrCategory);
  687.  
  688. if (DrName.equals("A. B. Mehta")) {
  689. holder.imgbullet.setBackgroundResource(R.drawable.yellow_bulet);
  690. }
  691. }
  692.  
  693. @Override
  694. public View newView(Context context, Cursor cursor, ViewGroup parent) {
  695.  
  696. LayoutInflater inflater = LayoutInflater.from(context);
  697. final View view = inflater.inflate(layout, parent, false);
  698.  
  699. return view;
  700. }
  701.  
  702. @Override
  703. public long getItemId(int id) {
  704. return id;
  705. }
  706.  
  707. @Override
  708. public Object getItem(int position) {
  709. return position;
  710. }
  711.  
  712. }
  713.  
  714. class ViewHolder {
  715. TextView txtViewDrname;
  716. TextView txtViewDrCode;
  717. TextView txtViewDrCity;
  718. TextView txtViewDrSpec;
  719. TextView txtViewDrCat;
  720. ImageView imgbullet;
  721.  
  722. }
Add Comment
Please, Sign In to add comment