Myu: Qtによる家計簿アプリ公開

　まだ、インポート関係で多少バグもありそうな気もしますが、念のため、インポート失敗したら、インポート直前にUndoできるようメニュー追加しました。いったん公開したいと思います。また、セルの編集がすぐ反映しないときは、再計算をクリックする仕様にしました。
　こちらにあります。（マニュアル・ヘルプ等はまだつくっていませんが。）
　1 銀行からのCSVインポート機能（極力汎用性もたせて、現段階では３～４つぐらいのところには対応させました）　2 スマホで入力したデータの転記機能
など追加しました。
　2のためには、 raspiのbottleとandroid studioが必要です。参考までにコードは以下のとおり。

bottle

@app.route('/py/vckake')
def vckake():
    key = request.query.key 
    date = request.query.date
    if key == "":
        f = open("vckakeMemo.txt") 
        data=f.read()
        f.close
    else:
        if key == "delete":
                with open("vckakeMemo.txt", 'w') as open_file:
                    pass
                data="deleted!"
        else:
            try:
          # ファイルに書き込む処理
                with open("vckakeMemo.txt", 'a') as open_file:
                    open_file.write(","+key + "_" + date )  # 改行を追加して新しい行として追加
                data="added!"
            except Exception as e:
        # ファイル操作でエラーが発生した場合
                data=f"Error occurred: {str(e)}"
    return template('vckake.html',txt=data)
    
# DB 接続関数
def get_db():
    conn = sqlite3.connect(DB_FILE)
    conn.row_factory = sqlite3.Row
    return conn

# DB 初期化関数
def init_db():
    if not os.path.exists(DB_FILE):
        conn = get_db()
        conn.execute("""
            CREATE TABLE expenses (
                id INTEGER PRIMARY KEY AUTOINCREMENT,
                amount REAL,
                memo TEXT,
                date TEXT,
                category TEXT,
                payee TEXT,
                method TEXT
            )
        """)
        conn.commit()
        conn.close()

# 初回アクセス時に DB 初期化
def init_db_once():
    global db_initialized
    if not db_initialized:
        init_db()
        db_initialized = True

# GET API
@app.get('/api/items')
def get_items():
    init_db_once()  # 初回だけ DB 作成
    conn = get_db()
    cur = conn.execute("SELECT * FROM expenses ORDER BY date DESC")
    rows = [dict(row) for row in cur.fetchall()]
    conn.close()
    response.content_type = 'application/json'
    return json.dumps(rows)

# POST API
@app.post('/api/items')
def create_item():
    init_db_once()  # 初回だけ DB 作成
    data = request.json
    if not data:
        response.status = 400
        return {"error": "Invalid JSON"}

conn = get_db()
    cur = conn.cursor()
    cur.execute(
        "INSERT INTO expenses (amount, memo, date, category, payee, method) VALUES (?,?,?,?,?,?)",
        (
            data.get("amount", 0),
            data.get("memo", ""),
            data.get("date", ""),
            data.get("category", ""),
            data.get("payee", ""),
            data.get("method", "")
        )
    )
    conn.commit()
    last_id = cur.lastrowid
    conn.close()
    response.content_type = 'application/json'
    return {"id": last_id}

# DB接続用関数
def get_db():
    conn = sqlite3.connect(DB_FILE)
    conn.row_factory = sqlite3.Row
    return conn

@app.delete('/api/items/<item_id:int>')
def delete_item(item_id):
    conn = get_db()
    cur = conn.cursor()
    cur.execute("DELETE FROM expenses WHERE id=?", (item_id,))
    conn.commit()
    conn.close()

response.content_type = 'application/json'
    return {"status": "ok"}
    
@app.put('/api/items/<item_id:int>')
def update_item(item_id):
    data = request.json
    if not data:
        response.status = 400
        return {"error": "Invalid JSON"}

conn = get_db()
    cur = conn.cursor()
    cur.execute(
        "UPDATE expenses SET amount=?, memo=? ,date=? ,category=?,method=? WHERE id=?",
        (data.get("amount", 0), data.get("memo", ""), data.get("date", ""),data.get("category", ""),data.get("method", ""),item_id)
    )
    conn.commit()
    conn.close()

response.content_type = 'application/json'
    return {"status": "ok"}

android

**********ApiClient**********
  import android.content.Context;
import android.net.ConnectivityManager;
import android.net.NetworkCapabilities;
import android.util.Log;
import android.widget.Toast;

import retrofit2.Retrofit;
import retrofit2.converter.gson.GsonConverterFactory;

public class ApiClient {
//private static final String BASE_URL = "https://ホスト名.ドメイン/api/";
    private static Retrofit retrofit = null;

/*public static ApiService getApiService(Context context) {
        if (retrofit == null) {
            retrofit = new Retrofit.Builder()
                    //.baseUrl(BASE_URL)
                    .baseUrl(getBaseUrl(context))
                    .addConverterFactory(GsonConverterFactory.create())
                    .build();
        }
        return retrofit.create(ApiService.class);
    }*/
    public static ApiService getApiService(Context context) {
        Retrofit retrofit = new Retrofit.Builder()
                .baseUrl(getBaseUrl(context))
                .addConverterFactory(GsonConverterFactory.create())
                .build();
        // URL を取得
        String url = getBaseUrl(context);

// Toast も渡された Context を使う
        Toast.makeText(context, "URL: " + url, Toast.LENGTH_LONG).show();

return retrofit.create(ApiService.class);
    }

private static String getBaseUrl(Context context) {

if (isWifi(context)) {
            Log.d("NETWORK_TYPE", "現在の接続は: WIFI");
            return "http://ローカルアドレス/api/";

} else {
            Log.d("NETWORK_TYPE", "現在の接続は: MOBILE");
            return "https://ホスト名/api/";
        }
    }
    private static boolean isWifi(Context context) {
        ConnectivityManager cm =
                (ConnectivityManager) context.getSystemService(Context.CONNECTIVITY_SERVICE);
        if (cm == null) return false;  // 予期せぬ null 対策

NetworkCapabilities caps =
                cm.getNetworkCapabilities(cm.getActiveNetwork());

return caps != null &&
                caps.hasTransport(NetworkCapabilities.TRANSPORT_WIFI);
    }

}
  
  ******************ApiService**********
  package com.example.vckake5.api;

import com.example.vckake5.model.Expense;
import retrofit2.Call;
import retrofit2.http.Body;
import retrofit2.http.DELETE;
import retrofit2.http.GET;
import retrofit2.http.POST;
import retrofit2.http.PUT;
import retrofit2.http.Path;

import java.util.List;

public interface ApiService {

@POST("items")
    Call<ExpenseResponse> addExpense(@Body Expense expense);

@GET("items")
    Call<List<Expense>> getExpenses();

@DELETE("/api/items/{id}")
    Call<Void> deleteExpense(@Path("id") int id);

@PUT("/api/items/{id}")
    Call<ExpenseResponse> updateExpense(@Path("id") int id, @Body Expense expense);

}

*****************ExpenseResponse***********
  package com.example.vckake5.api;

public class ExpenseResponse {
    private int id;

public int getId() { return id; }
    public void setId(int id) { this.id = id; }
}
  
  ***************Expnese*******
  example.vckake5.model;

public class Expense {
    private int id;
    private int amount;
    private String memo;
    private String date;
    private String category;
    private String method;
    private String payee;   // 支払先

public Expense(int amount, String memo, String date, String category, String method, String payee) {
        this.amount = amount;
        this.memo = memo;
        this.date = date;
        this.category = category;
        this.method = method;
        this.payee = payee;
    }

// getter / setter
    public int getAmount() { return amount; }
    public void setAmount(int amount) { this.amount = amount; }

public String getMemo() { return memo; }
    public void setMemo(String memo) { this.memo = memo; }

public String getDate() { return date; }
    public void setDate(String date) { this.date = date; }

public String getCategory() { return category; }
    public void setCategory(String category) { this.category = category; }

public String getMethod() { return method; }
    public void setMethod(String method) { this.method = method; }

public String getPayee() { return payee; }
    public void setPayee(String payee) { this.payee = payee; }
    public void setId(int id) {
        this.id = id;
    }

public int getId() {
        return id;
    }
}

**************ExpneseAdapter**********
  package com.example.vckake5;

import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.TextView;
import android.widget.Toast;

import androidx.annotation.NonNull;
import androidx.recyclerview.widget.RecyclerView;
import com.example.vckake5.model.Expense;
import java.util.List;

public class ExpenseAdapter extends RecyclerView.Adapter<ExpenseAdapter.ExpenseViewHolder> {
    private List<Expense> expenseList;
    private OnItemLongClickListener longClickListener;
    public interface OnItemLongClickListener {
        void onItemLongClick(Expense expense);
    }
    public void setOnItemLongClickListener(OnItemLongClickListener listener) {
        this.longClickListener = listener;
    }

public ExpenseAdapter(List<Expense> expenseList) {
        this.expenseList = expenseList;
    }

@NonNull
    @Override
    public ExpenseViewHolder onCreateViewHolder(@NonNull ViewGroup parent, int viewType) {
        View view = LayoutInflater.from(parent.getContext())
                .inflate(R.layout.item_expense, parent, false);
        return new ExpenseViewHolder(view);
    }

@Override
    public void onBindViewHolder(@NonNull ExpenseViewHolder holder, int position) {
        Expense expense = expenseList.get(position);
        holder.tvDate.setText(expense.getDate());
        holder.tvCategory.setText(expense.getCategory());
        holder.tvAmount.setText(String.valueOf(expense.getAmount()));
        holder.tvMemo.setText(expense.getMemo());  // ←追加
        holder.tvMethod.setText(expense.getMethod());  // ←追加

holder.itemView.setOnLongClickListener(v -> {
            if (longClickListener != null) {
                longClickListener.onItemLongClick(expense); // IDを含むExpenseオブジェクトを渡す
            }
            return true; // イベントを消費
        });

// 長押し操作の案内を表示（1回だけでもOK）
        holder.itemView.setOnClickListener(v -> {
            Toast.makeText(v.getContext(), "長押しで編集・削除可能", Toast.LENGTH_SHORT).show();
        });

}

@Override
    public int getItemCount() {
        return expenseList.size();
    }

public static class ExpenseViewHolder extends RecyclerView.ViewHolder {
        TextView tvDate, tvCategory, tvAmount,tvMemo,tvMethod;

public ExpenseViewHolder(@NonNull View itemView) {
            super(itemView);
            tvDate = itemView.findViewById(R.id.tvDate);
            tvCategory = itemView.findViewById(R.id.tvCategory);
            tvAmount = itemView.findViewById(R.id.tvAmount);
            tvMemo = itemView.findViewById(R.id.tvMemo);  // ←追加
            tvMethod = itemView.findViewById(R.id.tvMethod);  // ←追加
        }
    }

}

**************MainAcitivity
  package com.example.vckake5;

import android.app.AlertDialog;
import android.app.DatePickerDialog;

import android.os.Bundle;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;
import androidx.appcompat.app.AppCompatActivity;

import com.example.vckake5.api.ApiService;
import com.example.vckake5.api.ApiClient;
import com.example.vckake5.api.ExpenseResponse;
import com.example.vckake5.model.Expense;

import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.List;

import retrofit2.Call;
import retrofit2.Callback;
import retrofit2.Response;

import androidx.recyclerview.widget.RecyclerView;
import androidx.recyclerview.widget.LinearLayoutManager;
import java.util.ArrayList;
import java.util.Locale;

import android.widget.Spinner;
import android.widget.ArrayAdapter;

public class MainActivity extends AppCompatActivity {

private EditText inputAmount, inputMemo, inputDate;
    private Button btnAdd, btnClear;
    private TextView txtView;

private ApiService api;

private Expense editingExpense = null;

@Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

// --- View 取得 (1回だけ) ---
        inputAmount = findViewById(R.id.inputAmount);
        inputMemo = findViewById(R.id.inputMemo);
        inputDate = findViewById(R.id.inputDate);
        btnAdd = findViewById(R.id.btnAdd);
        btnClear = findViewById(R.id.btnClear);
        txtView = findViewById(R.id.txtView);
        RecyclerView recyclerView = findViewById(R.id.recyclerView);
        Spinner spinnerCategory = findViewById(R.id.spinnerCategory);
        Spinner spinnerMethod = findViewById(R.id.spinnerMethod);

// --- Spinner セット ---
        ArrayAdapter<CharSequence> categoryAdapter = ArrayAdapter.createFromResource(
                this, R.array.categories_array, android.R.layout.simple_spinner_item);
        categoryAdapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
        spinnerCategory.setAdapter(categoryAdapter);

ArrayAdapter<CharSequence> methodAdapter = ArrayAdapter.createFromResource(
                this, R.array.method_array, android.R.layout.simple_spinner_item);
        methodAdapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
        spinnerMethod.setAdapter(methodAdapter);

// --- RecyclerView セット ---
        List<Expense> expenseList = new ArrayList<>();
        ExpenseAdapter expenseAdapter = new ExpenseAdapter(expenseList);
        recyclerView.setAdapter(expenseAdapter);
        recyclerView.setLayoutManager(new LinearLayoutManager(this));

// --- API ---
        //api = ApiClient.getApiService();
        api = ApiClient.getApiService(this);
        api.getExpenses().enqueue(new Callback<List<Expense>>() {
            @Override
            public void onResponse(Call<List<Expense>> call, Response<List<Expense>> response) {
                if (response.isSuccessful() && response.body() != null) {
                    expenseList.clear();
                    expenseList.addAll(response.body());
                    expenseAdapter.notifyDataSetChanged();
                }
            }

@Override
            public void onFailure(Call<List<Expense>> call, Throwable t) {
                t.printStackTrace();
            }
        });

// --- 初期日付セット ---
        if (editingExpense == null) {
            String today = new SimpleDateFormat("yyyy-MM-dd", Locale.getDefault())
                    .format(Calendar.getInstance().getTime());
            inputDate.setText(today);
        } else {
            inputDate.setText(editingExpense.getDate());
        }

// --- 日付ピッカー ---
        inputDate.setOnClickListener(v -> {
            Calendar calendar = Calendar.getInstance();
            int year = calendar.get(Calendar.YEAR);
            int month = calendar.get(Calendar.MONTH);
            int day = calendar.get(Calendar.DAY_OF_MONTH);

DatePickerDialog datePickerDialog = new DatePickerDialog(MainActivity.this,
                    (view, year1, month1, dayOfMonth) -> {
                        String selectedDate = String.format("%04d-%02d-%02d", year1, month1 + 1, dayOfMonth);
                        inputDate.setText(selectedDate);
                    }, year, month, day);
            datePickerDialog.show();
        });

// --- 追加 / 更新ボタン ---
        btnAdd.setOnClickListener(v -> {
            String amountStr = inputAmount.getText().toString().trim();
            String memoStr = inputMemo.getText().toString().trim();
            String dateStr = inputDate.getText().toString().trim();
            String category = spinnerCategory.getSelectedItem().toString();
            String method = spinnerMethod.getSelectedItem().toString();

// 日付が空なら今日の日付をセット
            if (dateStr.isEmpty()) {
                dateStr = new SimpleDateFormat("yyyy-MM-dd", Locale.getDefault())
                        .format(Calendar.getInstance().getTime());
                inputDate.setText(dateStr);
            }

if (!amountStr.isEmpty() && !memoStr.isEmpty()) {
                int amount = Integer.parseInt(amountStr);

if (editingExpense == null) {
                    Expense newExpense = new Expense(amount, memoStr, dateStr, category, method, "payee");
                    api.addExpense(newExpense).enqueue(new Callback<ExpenseResponse>() {
                        @Override
                        public void onResponse(Call<ExpenseResponse> call, Response<ExpenseResponse> response) {
                            if (response.isSuccessful() && response.body() != null) {
                                newExpense.setId(response.body().getId());
                                runOnUiThread(() -> {
                                    expenseList.add(newExpense);
                                    expenseAdapter.notifyItemInserted(expenseList.size() - 1);

inputMemo.setText("");
                                    inputAmount.setText("");
                                    // 日付とSpinnerは保持したまま

});
                            }
                        }

@Override
                        public void onFailure(Call<ExpenseResponse> call, Throwable t) {
                            t.printStackTrace();
                            runOnUiThread(() -> Toast.makeText(MainActivity.this, "追加に失敗", Toast.LENGTH_SHORT).show());
                        }
                    });
                } else {
                    // 編集モード
                    editingExpense.setAmount(amount);
                    editingExpense.setMemo(memoStr);
                    editingExpense.setDate(dateStr);
                    editingExpense.setCategory(category);
                    editingExpense.setMethod(method);

api.updateExpense(editingExpense.getId(), editingExpense).enqueue(new Callback<ExpenseResponse>() {
                        @Override
                        public void onResponse(Call<ExpenseResponse> call, Response<ExpenseResponse> response) {
                            if (response.isSuccessful()) {
                                runOnUiThread(() -> {
                                    expenseAdapter.notifyDataSetChanged();
                                    Toast.makeText(MainActivity.this, "更新しました", Toast.LENGTH_SHORT).show();
                                    editingExpense = null;
                                    btnAdd.setText("Add");

inputMemo.setText("");
                                    inputAmount.setText("");
                                    // 日付とSpinnerは保持したまま
                                });
                            }
                        }

@Override
                        public void onFailure(Call<ExpenseResponse> call, Throwable t) {
                            runOnUiThread(() -> Toast.makeText(MainActivity.this, "更新失敗", Toast.LENGTH_SHORT).show());
                        }
                    });
                }
            } else {
                Toast.makeText(MainActivity.this, "金額とメモを入力してください", Toast.LENGTH_SHORT).show();
            }
        });

// --- クリアボタン ---
        btnClear.setOnClickListener(v -> {
            inputAmount.setText("");
            inputMemo.setText("");
            // 日付は今日を保持
            inputDate.setText(new SimpleDateFormat("yyyy-MM-dd", Locale.getDefault()).format(Calendar.getInstance().getTime()));
            spinnerCategory.setSelection(0);
            spinnerMethod.setSelection(0);
            editingExpense = null;
            Toast.makeText(MainActivity.this, "入力欄をクリアしました", Toast.LENGTH_SHORT).show();
        });

// --- RecyclerView 長押しで編集 / 削除 ---
        expenseAdapter.setOnItemLongClickListener(expense -> {
            int id = expense.getId();
            String[] options = {"削除", "編集"};
            new AlertDialog.Builder(MainActivity.this)
                    .setTitle("操作を選択")
                    .setItems(options, (dialog, which) -> {
                        if (which == 0) {
                            new AlertDialog.Builder(MainActivity.this)
                                    .setTitle("削除確認")
                                    .setMessage("この支出を削除しますか？")
                                    .setPositiveButton("削除", (d, w) -> {
                                        api.deleteExpense(id).enqueue(new Callback<Void>() {
                                            @Override
                                            public void onResponse(Call<Void> call, Response<Void> response) {
                                                if (response.isSuccessful()) {
                                                    expenseList.remove(expense);
                                                    expenseAdapter.notifyDataSetChanged();
                                                    Toast.makeText(MainActivity.this, "削除しました", Toast.LENGTH_SHORT).show();
                                                }
                                            }

@Override
                                            public void onFailure(Call<Void> call, Throwable t) {
                                                Toast.makeText(MainActivity.this, "削除失敗", Toast.LENGTH_SHORT).show();
                                            }
                                        });
                                    })
                                    .setNegativeButton("キャンセル", null)
                                    .show();
                        } else if (which == 1) {
                            inputAmount.setText(String.valueOf(expense.getAmount()));
                            inputMemo.setText(expense.getMemo());
                            inputDate.setText(expense.getDate());

spinnerCategory.setSelection(((ArrayAdapter<String>) spinnerCategory.getAdapter()).getPosition(expense.getCategory()));
                            spinnerMethod.setSelection(((ArrayAdapter<String>) spinnerMethod.getAdapter()).getPosition(expense.getMethod()));

editingExpense = expense;
                            btnAdd.setText("Update");
                            Toast.makeText(MainActivity.this, "編集モードです", Toast.LENGTH_SHORT).show();
                        }
                    })
                    .show();
        });

}
*****************AndroidManifest.xml
  <?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools">

<uses-permission android:name="android.permission.INTERNET" />
    <uses-permission android:name="android.permission.ACCESS_NETWORK_STATE"/>

</application>
</manifest>

※今は、Windowsで使用していますが、Qtで作成したので、将来的にはLinuxでも使用することを考えています。

Myu

2026年2月1日日曜日

Qtによる家計簿アプリ公開

0 件のコメント:

コメントを投稿

ブログアーカイブ