コード例 #1
0
  public ReceiptImage getReceiptWithPhotoname(String photoname) throws ParseException {
    Log.d("MyQuittiDatasource", "getReceiptWithPhotoname: " + photoname);
    ReceiptImage receipt = null;
    this.open();

    Log.d("MyQuittiDatasource", "photoname: " + photoname);
    Cursor cursor =
        database.rawQuery("SELECT * FROM receiptinfo WHERE photoname = '" + photoname + "'", null);
    // Cursor cursor = database.query(MySQLiteHelper.TABLE_RECEIPTINFO,
    //    allColumns,  MySQLiteHelper.COLUMN_PHOTONAME + " LIKE " + photoname, null, null, null,
    // null);

    cursor.moveToFirst();
    // Comment newComment = cursorToComment(cursor);
    // cursor.close();
    if (cursor.getCount() > 0) {

      receipt = cursorToReceiptImage(cursor);
      receipt.setCategory(getCategory(receipt.getReceiptId()));
    }

    System.out.println("*********************");

    // cursor.moveToNext();

    // make sure to close the cursor
    cursor.close();
    // and database connection
    this.close();
    Log.d("MyQuittiDatasource", "getReceiptWithPhotoname End");
    return receipt;
  }
コード例 #2
0
  private ReceiptImage cursorToReceiptImage(Cursor cursor) throws ParseException {
    System.out.println("*******************cursorToReceiptImage************************");
    ReceiptImage newReceipt = new ReceiptImage();
    newReceipt.setReceiptId(cursor.getLong(0));
    newReceipt.setPhotoname(cursor.getString(1));
    newReceipt.setRootDirectory(cursor.getString(2));
    newReceipt.setDirectory(cursor.getString(3));
    // newReceipt.setCreateDate(dateFormat.parse(cursor.getString(8)));

    return newReceipt;
  }
コード例 #3
0
  /**
   * Returns a list of all receipts in phones memory with specific category SELECT
   * receiptinfo.receiptId, receiptinfo.photoname,category.categorytext FROM receiptinfo,category
   * WHERE receiptinfo.receiptid=category.fk_category_receiptinfo and category.categorytext like
   * 'Business' @Sami Nurmi
   *
   * @return List
   * @throws ParseException
   */
  public List<ReceiptImage> getAllReceipts(String category) throws ParseException {
    List<ReceiptImage> receipts = new ArrayList<ReceiptImage>();

    Cursor cursor =
        database.query(MySQLiteHelper.TABLE_RECEIPTINFO, allColumns, null, null, null, null, null);

    cursor.moveToFirst();
    while (!cursor.isAfterLast()) {
      ReceiptImage receipt = cursorToReceiptImage(cursor);
      receipt.setCategory(getCategory(receipt.getReceiptId()));
      receipts.add(receipt);
      cursor.moveToNext();
    }
    // make sure to close the cursor
    cursor.close();
    return receipts;
  }
コード例 #4
0
  public ReceiptImage createReceiptWithCategories(
      String rootDirectory,
      String directory,
      String Extrainfo,
      String photoName,
      String isChecked,
      String latitude,
      String longitude,
      String categories[])
      throws ParseException {
    Log.d("createReceiptWithCategories", "--createReceiptWithCategories--");
    Log.v("MyQuittiDataSource", "--categories LENGTH----->" + categories.length);

    ContentValues values = new ContentValues();
    values.put(MySQLiteHelper.COLUMN_PHOTONAME, photoName);
    values.put(MySQLiteHelper.COLUMN_ROOTDIRECTORY, rootDirectory);
    values.put(MySQLiteHelper.COLUMN_DIRECTORY, directory);
    values.put(MySQLiteHelper.COLUMN_EXTRAINFO, Extrainfo);
    values.put(MySQLiteHelper.COLUMN_ISCHECKED, isChecked);
    values.put(MySQLiteHelper.COLUMN_LATITUDE, isChecked);
    values.put(MySQLiteHelper.COLUMN_LONGITUDE, isChecked);

    long insertId = database.insert(MySQLiteHelper.TABLE_RECEIPTINFO, null, values);
    System.out.println("insertIdinsertIdinsertIdinsertId--->" + insertId);
    Cursor cursor =
        database.query(
            MySQLiteHelper.TABLE_RECEIPTINFO,
            allColumns,
            MySQLiteHelper.COLUMN_RECEIPTID + " = " + insertId,
            null,
            null,
            null,
            null);
    cursor.moveToFirst();
    ReceiptImage newReceipt = cursorToReceiptImage(cursor);
    cursor.close();
    // TODO: This is stupid way, but we were hurry
    for (int i = 0; i < categories.length; i++) {
      this.addCategory(categories[i], newReceipt.getReceiptId());
    }

    Log.v("MyQuittiDataSource", "--createReceipt--END");
    return newReceipt;
  }
コード例 #5
0
  /**
   * Returns a list of all receipts in phones memory @Sami Nurmi
   *
   * @return List
   * @throws ParseException
   */
  public List<ReceiptImage> getAllReceipts() throws ParseException {
    System.out.println("**********getAllReceipts getAllReceipts ************");
    List<ReceiptImage> receipts = new ArrayList<ReceiptImage>();

    Cursor cursor =
        database.query(MySQLiteHelper.TABLE_RECEIPTINFO, allColumns, null, null, null, null, null);

    cursor.moveToFirst();
    while (!cursor.isAfterLast()) {
      ReceiptImage receipt = cursorToReceiptImage(cursor);
      // Category category = this.getCategory(receipt.getReceiptId());
      List<Category> categories = this.getAllCategories(receipt.getReceiptId());
      System.out.println("RECEIPTID----->" + receipt.getReceiptId());
      receipt.setCategories(categories);
      receipts.add(receipt);
      cursor.moveToNext();
    }
    // make sure to close the cursor
    cursor.close();
    return receipts;
  }
コード例 #6
0
 /**
  * Method for deleting the ReceiptImage @Sami Nurmi
  *
  * @param receipt
  */
 public void deleteReceipt(ReceiptImage receipt) {
   long id = receipt.getReceiptId();
   System.out.println("Receipt deleted with id: " + id);
   database.delete(
       MySQLiteHelper.TABLE_RECEIPTINFO, MySQLiteHelper.COLUMN_RECEIPTID + " = " + id, null);
 }