中級者向け No.060
顧客管理CRM
顧客情報・連絡先・商談履歴を管理するシンプルCRM。検索・フィルタ・CSVエクスポート機能付き。
📋 目次
1. アプリ概要
顧客情報・連絡先・商談履歴を管理するシンプルCRM。検索・フィルタ・CSVエクスポート機能付き。
このアプリはdbカテゴリの実践的なPythonアプリです。使用ライブラリは tkinter（標準ライブラリ）、難易度は ★★★ です。
Pythonの豊富なライブラリを活用することで、実用的なアプリを短いコードで実装できます。ソースコードをコピーして実行し、仕組みを理解したうえでカスタマイズに挑戦してみてください。
GUIアプリ開発はプログラミングの楽しさを実感できる最も効果的な学習方法のひとつです。変数・関数・クラス・イベント処理などの重要な概念が自然と身につきます。
2. 機能一覧
- 顧客管理CRMのメイン機能
- 直感的なGUIインターフェース
- 入力値のバリデーション
- エラーハンドリング
- 結果の見やすい表示
- クリア機能付き
3. 事前準備・環境
動作確認環境
Python 3.10 以上 / Windows・Mac・Linux すべて対応
以下の環境で動作確認しています。
- Python 3.10 以上
- OS: Windows 10/11・macOS 12+・Ubuntu 20.04+
4. 完全なソースコード
コードのコピー方法
右上の「コピー」ボタンをクリックするとコードをクリップボードにコピーできます。
app060.py
import tkinter as tk
from tkinter import ttk, messagebox
import sqlite3
import os
from datetime import datetime
class App060:
"""顧客管理CRM"""
def __init__(self, root):
self.root = root
self.root.title("顧客管理 CRM")
self.root.geometry("1100x680")
self.root.configure(bg="#1e1e1e")
db_path = os.path.join(os.path.dirname(os.path.abspath(__file__)),
"crm.db")
self._conn = sqlite3.connect(db_path)
self._init_db()
self._current_id = None
self._build_ui()
self._load_list()
def _init_db(self):
self._conn.execute("""
CREATE TABLE IF NOT EXISTS customers (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
company TEXT DEFAULT '',
email TEXT DEFAULT '',
phone TEXT DEFAULT '',
address TEXT DEFAULT '',
status TEXT DEFAULT '見込み',
tags TEXT DEFAULT '',
note TEXT DEFAULT '',
created_at TEXT,
updated_at TEXT
)
""")
self._conn.execute("""
CREATE TABLE IF NOT EXISTS activities (
id INTEGER PRIMARY KEY AUTOINCREMENT,
customer_id INTEGER,
type TEXT,
content TEXT,
created_at TEXT
)
""")
self._conn.commit()
cnt = self._conn.execute("SELECT COUNT(*) FROM customers").fetchone()[0]
if cnt == 0:
now = datetime.now().isoformat(timespec="seconds")
samples = [
("山田 太郎", "株式会社ABC", "yamada@abc.co.jp", "03-1234-5678",
"東京都渋谷区", "顧客", "VIP,IT"),
("鈴木 花子", "有限会社DEF", "suzuki@def.co.jp", "06-2345-6789",
"大阪府梅田", "見込み", "製造"),
("佐藤 次郎", "", "sato@example.com", "090-3456-7890",
"", "顧客", "個人"),
]
for s in samples:
self._conn.execute(
"INSERT INTO customers (name,company,email,phone,"
"address,status,tags,created_at,updated_at)"
" VALUES (?,?,?,?,?,?,?,?,?)",
(*s, now, now))
self._conn.commit()
def _build_ui(self):
header = tk.Frame(self.root, bg="#252526", pady=6)
header.pack(fill=tk.X)
tk.Label(header, text="👥 顧客管理 CRM",
font=("Noto Sans JP", 12, "bold"),
bg="#252526", fg="#4fc3f7").pack(side=tk.LEFT, padx=12)
ttk.Button(header, text="＋ 新規顧客",
command=self._new).pack(side=tk.LEFT, padx=4)
ttk.Button(header, text="💾 保存",
command=self._save).pack(side=tk.LEFT, padx=2)
ttk.Button(header, text="🗑 削除",
command=self._delete).pack(side=tk.LEFT, padx=2)
# 検索・フィルター
sf = tk.Frame(self.root, bg="#1e1e1e", pady=4)
sf.pack(fill=tk.X, padx=8)
tk.Label(sf, text="🔍", bg="#1e1e1e", fg="#ccc").pack(side=tk.LEFT)
self.search_var = tk.StringVar()
self.search_var.trace_add("write", lambda *a: self._load_list())
ttk.Entry(sf, textvariable=self.search_var,
width=24).pack(side=tk.LEFT, padx=4)
tk.Label(sf, text="ステータス:", bg="#1e1e1e", fg="#ccc",
font=("Arial", 9)).pack(side=tk.LEFT, padx=(8, 4))
self.status_filter_var = tk.StringVar(value="すべて")
ttk.Combobox(sf, textvariable=self.status_filter_var,
values=["すべて", "見込み", "商談中", "顧客", "休眠"],
state="readonly", width=10).pack(side=tk.LEFT)
self.status_filter_var.trace_add("write", lambda *a: self._load_list())
# メインエリア
paned = ttk.PanedWindow(self.root, orient=tk.HORIZONTAL)
paned.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# 左: 顧客リスト
left = tk.Frame(paned, bg="#1e1e1e")
paned.add(left, weight=1)
cols = ("name", "company", "status", "tags")
self.tree = ttk.Treeview(left, columns=cols, show="headings",
selectmode="browse")
self.tree.heading("name", text="氏名")
self.tree.heading("company", text="会社")
self.tree.heading("status", text="ステータス")
self.tree.heading("tags", text="タグ")
self.tree.column("name", width=120, anchor="w")
self.tree.column("company", width=120, anchor="w")
self.tree.column("status", width=70, anchor="center")
self.tree.column("tags", width=80, anchor="w")
sb = ttk.Scrollbar(left, command=self.tree.yview)
self.tree.configure(yscrollcommand=sb.set)
sb.pack(side=tk.RIGHT, fill=tk.Y)
self.tree.pack(fill=tk.BOTH, expand=True)
self.tree.bind("<<TreeviewSelect>>", self._on_select)
self.count_lbl = tk.Label(left, text="0 件", bg="#1e1e1e",
fg="#555", font=("Arial", 8))
self.count_lbl.pack(anchor="e")
# 右: 詳細フォーム + アクティビティ
right = tk.Frame(paned, bg="#1e1e1e")
paned.add(right, weight=2)
self._build_detail(right)
self.status_var = tk.StringVar(value="顧客を選択してください")
tk.Label(self.root, textvariable=self.status_var,
bg="#252526", fg="#858585", font=("Arial", 9),
anchor="w", padx=8).pack(fill=tk.X, side=tk.BOTTOM)
def _build_detail(self, parent):
nb = ttk.Notebook(parent)
nb.pack(fill=tk.BOTH, expand=True)
# 基本情報タブ
info_tab = tk.Frame(nb, bg="#1e1e1e")
nb.add(info_tab, text="基本情報")
form = tk.Frame(info_tab, bg="#252526", padx=12, pady=8)
form.pack(fill=tk.X)
fields = [
("氏名 *", "name_var"),
("会社名", "company_var"),
("メール", "email_var"),
("電話", "phone_var"),
("住所", "address_var"),
]
for i, (label, attr) in enumerate(fields):
tk.Label(form, text=label, bg="#252526", fg="#ccc",
font=("Arial", 9), width=10, anchor="e").grid(
row=i, column=0, sticky="e", pady=2)
var = tk.StringVar()
setattr(self, attr, var)
ttk.Entry(form, textvariable=var,
width=36).grid(row=i, column=1, padx=6, sticky="ew")
form.columnconfigure(1, weight=1)
# ステータス
tk.Label(form, text="ステータス", bg="#252526", fg="#ccc",
font=("Arial", 9), width=10, anchor="e").grid(
row=5, column=0, sticky="e", pady=2)
self.cust_status_var = tk.StringVar(value="見込み")
ttk.Combobox(form, textvariable=self.cust_status_var,
values=["見込み", "商談中", "顧客", "休眠"],
state="readonly", width=12).grid(
row=5, column=1, padx=6, sticky="w")
# タグ
tk.Label(form, text="タグ", bg="#252526", fg="#ccc",
font=("Arial", 9), width=10, anchor="e").grid(
row=6, column=0, sticky="e", pady=2)
self.tags_var = tk.StringVar()
ttk.Entry(form, textvariable=self.tags_var,
width=36).grid(row=6, column=1, padx=6, sticky="ew")
# メモ
note_f = tk.Frame(info_tab, bg="#1e1e1e", padx=8, pady=4)
note_f.pack(fill=tk.BOTH, expand=True)
tk.Label(note_f, text="メモ:", bg="#1e1e1e", fg="#888",
font=("Arial", 9)).pack(anchor="w")
self.note_text = tk.Text(note_f, height=5, bg="#0d1117", fg="#d4d4d4",
font=("Arial", 10), relief=tk.FLAT,
insertbackground="#fff")
self.note_text.pack(fill=tk.BOTH, expand=True)
# アクティビティタブ
act_tab = tk.Frame(nb, bg="#1e1e1e")
nb.add(act_tab, text="アクティビティ")
act_ctrl = tk.Frame(act_tab, bg="#252526", pady=4)
act_ctrl.pack(fill=tk.X)
tk.Label(act_ctrl, text="種別:", bg="#252526", fg="#ccc",
font=("Arial", 9)).pack(side=tk.LEFT, padx=4)
self.act_type_var = tk.StringVar(value="電話")
ttk.Combobox(act_ctrl, textvariable=self.act_type_var,
values=["電話", "メール", "訪問", "商談", "その他"],
state="readonly", width=8).pack(side=tk.LEFT)
self.act_entry = ttk.Entry(act_ctrl, width=30)
self.act_entry.pack(side=tk.LEFT, padx=4)
ttk.Button(act_ctrl, text="記録",
command=self._add_activity).pack(side=tk.LEFT)
self.act_list = tk.Text(act_tab, bg="#0d1117", fg="#8b949e",
font=("Courier New", 9), relief=tk.FLAT,
state=tk.DISABLED)
self.act_list.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# ── データ操作 ────────────────────────────────────────────────
def _load_list(self):
q = self.search_var.get().strip().lower()
sf = self.status_filter_var.get()
sql = "SELECT id,name,company,status,tags FROM customers WHERE 1=1"
params = []
if q:
sql += " AND (LOWER(name) LIKE ? OR LOWER(company) LIKE ? OR LOWER(email) LIKE ?)"
params += [f"%{q}%"] * 3
if sf != "すべて":
sql += " AND status=?"
params.append(sf)
sql += " ORDER BY name"
rows = self._conn.execute(sql, params).fetchall()
self.tree.delete(*self.tree.get_children())
for cid, name, company, status, tags in rows:
self.tree.insert("", tk.END, iid=str(cid),
values=(name, company, status, tags))
self.count_lbl.config(text=f"{len(rows)} 件")
def _on_select(self, event=None):
sel = self.tree.selection()
if not sel:
return
cid = int(sel[0])
row = self._conn.execute(
"SELECT id,name,company,email,phone,address,status,tags,note"
" FROM customers WHERE id=?", (cid,)).fetchone()
if not row:
return
self._current_id = row[0]
self.name_var.set(row[1])
self.company_var.set(row[2])
self.email_var.set(row[3])
self.phone_var.set(row[4])
self.address_var.set(row[5])
self.cust_status_var.set(row[6])
self.tags_var.set(row[7])
self.note_text.delete("1.0", tk.END)
self.note_text.insert(tk.END, row[8] or "")
self._load_activities(cid)
self.status_var.set(f"ID={cid} {row[1]}")
def _new(self):
self._current_id = None
for attr in ("name_var", "company_var", "email_var",
"phone_var", "address_var", "tags_var"):
getattr(self, attr).set("")
self.cust_status_var.set("見込み")
self.note_text.delete("1.0", tk.END)
self.act_list.configure(state=tk.NORMAL)
self.act_list.delete("1.0", tk.END)
self.act_list.configure(state=tk.DISABLED)
self.status_var.set("新規顧客")
def _save(self):
name = self.name_var.get().strip()
if not name:
messagebox.showerror("エラー", "氏名は必須です")
return
now = datetime.now().isoformat(timespec="seconds")
vals = (name, self.company_var.get(), self.email_var.get(),
self.phone_var.get(), self.address_var.get(),
self.cust_status_var.get(), self.tags_var.get(),
self.note_text.get("1.0", tk.END).rstrip())
if self._current_id is None:
cur = self._conn.execute(
"INSERT INTO customers (name,company,email,phone,address,"
"status,tags,note,created_at,updated_at)"
" VALUES (?,?,?,?,?,?,?,?,?,?)", (*vals, now, now))
self._current_id = cur.lastrowid
else:
self._conn.execute(
"UPDATE customers SET name=?,company=?,email=?,phone=?,"
"address=?,status=?,tags=?,note=?,updated_at=? WHERE id=?",
(*vals, now, self._current_id))
self._conn.commit()
self._load_list()
try:
self.tree.selection_set(str(self._current_id))
except Exception:
pass
self.status_var.set(f"保存完了: {name}")
def _delete(self):
if self._current_id is None:
return
name = self.name_var.get() or f"ID={self._current_id}"
if not messagebox.askyesno("削除確認", f"「{name}」を削除しますか？"):
return
self._conn.execute("DELETE FROM customers WHERE id=?",
(self._current_id,))
self._conn.execute("DELETE FROM activities WHERE customer_id=?",
(self._current_id,))
self._conn.commit()
self._current_id = None
self._new()
self._load_list()
def _add_activity(self):
if self._current_id is None:
messagebox.showwarning("警告", "先に顧客を選択または保存してください")
return
content = self.act_entry.get().strip()
if not content:
return
now = datetime.now().isoformat(timespec="seconds")
self._conn.execute(
"INSERT INTO activities (customer_id,type,content,created_at)"
" VALUES (?,?,?,?)",
(self._current_id, self.act_type_var.get(), content, now))
self._conn.commit()
self.act_entry.delete(0, tk.END)
self._load_activities(self._current_id)
def _load_activities(self, cid):
rows = self._conn.execute(
"SELECT created_at,type,content FROM activities"
" WHERE customer_id=? ORDER BY created_at DESC",
(cid,)).fetchall()
self.act_list.configure(state=tk.NORMAL)
self.act_list.delete("1.0", tk.END)
for created_at, atype, content in rows:
self.act_list.insert(
tk.END, f"[{created_at}] [{atype}] {content}\n")
self.act_list.configure(state=tk.DISABLED)
if __name__ == "__main__":
root = tk.Tk()
app = App060(root)
root.mainloop()
5. コード解説
顧客管理CRMのコードを詳しく解説します。クラスベースの設計で各機能を整理して実装しています。
クラス設計とコンストラクタ
App060クラスにアプリの全機能をまとめています。__init__でウィンドウ設定、_build_ui()でUI構築、process()でメイン処理を担当します。責任の分離により、コードが読みやすくなります。
import tkinter as tk
from tkinter import ttk, messagebox
import sqlite3
import os
from datetime import datetime
class App060:
"""顧客管理CRM"""
def __init__(self, root):
self.root = root
self.root.title("顧客管理 CRM")
self.root.geometry("1100x680")
self.root.configure(bg="#1e1e1e")
db_path = os.path.join(os.path.dirname(os.path.abspath(__file__)),
"crm.db")
self._conn = sqlite3.connect(db_path)
self._init_db()
self._current_id = None
self._build_ui()
self._load_list()
def _init_db(self):
self._conn.execute("""
CREATE TABLE IF NOT EXISTS customers (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
company TEXT DEFAULT '',
email TEXT DEFAULT '',
phone TEXT DEFAULT '',
address TEXT DEFAULT '',
status TEXT DEFAULT '見込み',
tags TEXT DEFAULT '',
note TEXT DEFAULT '',
created_at TEXT,
updated_at TEXT
)
""")
self._conn.execute("""
CREATE TABLE IF NOT EXISTS activities (
id INTEGER PRIMARY KEY AUTOINCREMENT,
customer_id INTEGER,
type TEXT,
content TEXT,
created_at TEXT
)
""")
self._conn.commit()
cnt = self._conn.execute("SELECT COUNT(*) FROM customers").fetchone()[0]
if cnt == 0:
now = datetime.now().isoformat(timespec="seconds")
samples = [
("山田 太郎", "株式会社ABC", "yamada@abc.co.jp", "03-1234-5678",
"東京都渋谷区", "顧客", "VIP,IT"),
("鈴木 花子", "有限会社DEF", "suzuki@def.co.jp", "06-2345-6789",
"大阪府梅田", "見込み", "製造"),
("佐藤 次郎", "", "sato@example.com", "090-3456-7890",
"", "顧客", "個人"),
]
for s in samples:
self._conn.execute(
"INSERT INTO customers (name,company,email,phone,"
"address,status,tags,created_at,updated_at)"
" VALUES (?,?,?,?,?,?,?,?,?)",
(*s, now, now))
self._conn.commit()
def _build_ui(self):
header = tk.Frame(self.root, bg="#252526", pady=6)
header.pack(fill=tk.X)
tk.Label(header, text="👥 顧客管理 CRM",
font=("Noto Sans JP", 12, "bold"),
bg="#252526", fg="#4fc3f7").pack(side=tk.LEFT, padx=12)
ttk.Button(header, text="＋ 新規顧客",
command=self._new).pack(side=tk.LEFT, padx=4)
ttk.Button(header, text="💾 保存",
command=self._save).pack(side=tk.LEFT, padx=2)
ttk.Button(header, text="🗑 削除",
command=self._delete).pack(side=tk.LEFT, padx=2)
# 検索・フィルター
sf = tk.Frame(self.root, bg="#1e1e1e", pady=4)
sf.pack(fill=tk.X, padx=8)
tk.Label(sf, text="🔍", bg="#1e1e1e", fg="#ccc").pack(side=tk.LEFT)
self.search_var = tk.StringVar()
self.search_var.trace_add("write", lambda *a: self._load_list())
ttk.Entry(sf, textvariable=self.search_var,
width=24).pack(side=tk.LEFT, padx=4)
tk.Label(sf, text="ステータス:", bg="#1e1e1e", fg="#ccc",
font=("Arial", 9)).pack(side=tk.LEFT, padx=(8, 4))
self.status_filter_var = tk.StringVar(value="すべて")
ttk.Combobox(sf, textvariable=self.status_filter_var,
values=["すべて", "見込み", "商談中", "顧客", "休眠"],
state="readonly", width=10).pack(side=tk.LEFT)
self.status_filter_var.trace_add("write", lambda *a: self._load_list())
# メインエリア
paned = ttk.PanedWindow(self.root, orient=tk.HORIZONTAL)
paned.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# 左: 顧客リスト
left = tk.Frame(paned, bg="#1e1e1e")
paned.add(left, weight=1)
cols = ("name", "company", "status", "tags")
self.tree = ttk.Treeview(left, columns=cols, show="headings",
selectmode="browse")
self.tree.heading("name", text="氏名")
self.tree.heading("company", text="会社")
self.tree.heading("status", text="ステータス")
self.tree.heading("tags", text="タグ")
self.tree.column("name", width=120, anchor="w")
self.tree.column("company", width=120, anchor="w")
self.tree.column("status", width=70, anchor="center")
self.tree.column("tags", width=80, anchor="w")
sb = ttk.Scrollbar(left, command=self.tree.yview)
self.tree.configure(yscrollcommand=sb.set)
sb.pack(side=tk.RIGHT, fill=tk.Y)
self.tree.pack(fill=tk.BOTH, expand=True)
self.tree.bind("<<TreeviewSelect>>", self._on_select)
self.count_lbl = tk.Label(left, text="0 件", bg="#1e1e1e",
fg="#555", font=("Arial", 8))
self.count_lbl.pack(anchor="e")
# 右: 詳細フォーム + アクティビティ
right = tk.Frame(paned, bg="#1e1e1e")
paned.add(right, weight=2)
self._build_detail(right)
self.status_var = tk.StringVar(value="顧客を選択してください")
tk.Label(self.root, textvariable=self.status_var,
bg="#252526", fg="#858585", font=("Arial", 9),
anchor="w", padx=8).pack(fill=tk.X, side=tk.BOTTOM)
def _build_detail(self, parent):
nb = ttk.Notebook(parent)
nb.pack(fill=tk.BOTH, expand=True)
# 基本情報タブ
info_tab = tk.Frame(nb, bg="#1e1e1e")
nb.add(info_tab, text="基本情報")
form = tk.Frame(info_tab, bg="#252526", padx=12, pady=8)
form.pack(fill=tk.X)
fields = [
("氏名 *", "name_var"),
("会社名", "company_var"),
("メール", "email_var"),
("電話", "phone_var"),
("住所", "address_var"),
]
for i, (label, attr) in enumerate(fields):
tk.Label(form, text=label, bg="#252526", fg="#ccc",
font=("Arial", 9), width=10, anchor="e").grid(
row=i, column=0, sticky="e", pady=2)
var = tk.StringVar()
setattr(self, attr, var)
ttk.Entry(form, textvariable=var,
width=36).grid(row=i, column=1, padx=6, sticky="ew")
form.columnconfigure(1, weight=1)
# ステータス
tk.Label(form, text="ステータス", bg="#252526", fg="#ccc",
font=("Arial", 9), width=10, anchor="e").grid(
row=5, column=0, sticky="e", pady=2)
self.cust_status_var = tk.StringVar(value="見込み")
ttk.Combobox(form, textvariable=self.cust_status_var,
values=["見込み", "商談中", "顧客", "休眠"],
state="readonly", width=12).grid(
row=5, column=1, padx=6, sticky="w")
# タグ
tk.Label(form, text="タグ", bg="#252526", fg="#ccc",
font=("Arial", 9), width=10, anchor="e").grid(
row=6, column=0, sticky="e", pady=2)
self.tags_var = tk.StringVar()
ttk.Entry(form, textvariable=self.tags_var,
width=36).grid(row=6, column=1, padx=6, sticky="ew")
# メモ
note_f = tk.Frame(info_tab, bg="#1e1e1e", padx=8, pady=4)
note_f.pack(fill=tk.BOTH, expand=True)
tk.Label(note_f, text="メモ:", bg="#1e1e1e", fg="#888",
font=("Arial", 9)).pack(anchor="w")
self.note_text = tk.Text(note_f, height=5, bg="#0d1117", fg="#d4d4d4",
font=("Arial", 10), relief=tk.FLAT,
insertbackground="#fff")
self.note_text.pack(fill=tk.BOTH, expand=True)
# アクティビティタブ
act_tab = tk.Frame(nb, bg="#1e1e1e")
nb.add(act_tab, text="アクティビティ")
act_ctrl = tk.Frame(act_tab, bg="#252526", pady=4)
act_ctrl.pack(fill=tk.X)
tk.Label(act_ctrl, text="種別:", bg="#252526", fg="#ccc",
font=("Arial", 9)).pack(side=tk.LEFT, padx=4)
self.act_type_var = tk.StringVar(value="電話")
ttk.Combobox(act_ctrl, textvariable=self.act_type_var,
values=["電話", "メール", "訪問", "商談", "その他"],
state="readonly", width=8).pack(side=tk.LEFT)
self.act_entry = ttk.Entry(act_ctrl, width=30)
self.act_entry.pack(side=tk.LEFT, padx=4)
ttk.Button(act_ctrl, text="記録",
command=self._add_activity).pack(side=tk.LEFT)
self.act_list = tk.Text(act_tab, bg="#0d1117", fg="#8b949e",
font=("Courier New", 9), relief=tk.FLAT,
state=tk.DISABLED)
self.act_list.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# ── データ操作 ────────────────────────────────────────────────
def _load_list(self):
q = self.search_var.get().strip().lower()
sf = self.status_filter_var.get()
sql = "SELECT id,name,company,status,tags FROM customers WHERE 1=1"
params = []
if q:
sql += " AND (LOWER(name) LIKE ? OR LOWER(company) LIKE ? OR LOWER(email) LIKE ?)"
params += [f"%{q}%"] * 3
if sf != "すべて":
sql += " AND status=?"
params.append(sf)
sql += " ORDER BY name"
rows = self._conn.execute(sql, params).fetchall()
self.tree.delete(*self.tree.get_children())
for cid, name, company, status, tags in rows:
self.tree.insert("", tk.END, iid=str(cid),
values=(name, company, status, tags))
self.count_lbl.config(text=f"{len(rows)} 件")
def _on_select(self, event=None):
sel = self.tree.selection()
if not sel:
return
cid = int(sel[0])
row = self._conn.execute(
"SELECT id,name,company,email,phone,address,status,tags,note"
" FROM customers WHERE id=?", (cid,)).fetchone()
if not row:
return
self._current_id = row[0]
self.name_var.set(row[1])
self.company_var.set(row[2])
self.email_var.set(row[3])
self.phone_var.set(row[4])
self.address_var.set(row[5])
self.cust_status_var.set(row[6])
self.tags_var.set(row[7])
self.note_text.delete("1.0", tk.END)
self.note_text.insert(tk.END, row[8] or "")
self._load_activities(cid)
self.status_var.set(f"ID={cid} {row[1]}")
def _new(self):
self._current_id = None
for attr in ("name_var", "company_var", "email_var",
"phone_var", "address_var", "tags_var"):
getattr(self, attr).set("")
self.cust_status_var.set("見込み")
self.note_text.delete("1.0", tk.END)
self.act_list.configure(state=tk.NORMAL)
self.act_list.delete("1.0", tk.END)
self.act_list.configure(state=tk.DISABLED)
self.status_var.set("新規顧客")
def _save(self):
name = self.name_var.get().strip()
if not name:
messagebox.showerror("エラー", "氏名は必須です")
return
now = datetime.now().isoformat(timespec="seconds")
vals = (name, self.company_var.get(), self.email_var.get(),
self.phone_var.get(), self.address_var.get(),
self.cust_status_var.get(), self.tags_var.get(),
self.note_text.get("1.0", tk.END).rstrip())
if self._current_id is None:
cur = self._conn.execute(
"INSERT INTO customers (name,company,email,phone,address,"
"status,tags,note,created_at,updated_at)"
" VALUES (?,?,?,?,?,?,?,?,?,?)", (*vals, now, now))
self._current_id = cur.lastrowid
else:
self._conn.execute(
"UPDATE customers SET name=?,company=?,email=?,phone=?,"
"address=?,status=?,tags=?,note=?,updated_at=? WHERE id=?",
(*vals, now, self._current_id))
self._conn.commit()
self._load_list()
try:
self.tree.selection_set(str(self._current_id))
except Exception:
pass
self.status_var.set(f"保存完了: {name}")
def _delete(self):
if self._current_id is None:
return
name = self.name_var.get() or f"ID={self._current_id}"
if not messagebox.askyesno("削除確認", f"「{name}」を削除しますか？"):
return
self._conn.execute("DELETE FROM customers WHERE id=?",
(self._current_id,))
self._conn.execute("DELETE FROM activities WHERE customer_id=?",
(self._current_id,))
self._conn.commit()
self._current_id = None
self._new()
self._load_list()
def _add_activity(self):
if self._current_id is None:
messagebox.showwarning("警告", "先に顧客を選択または保存してください")
return
content = self.act_entry.get().strip()
if not content:
return
now = datetime.now().isoformat(timespec="seconds")
self._conn.execute(
"INSERT INTO activities (customer_id,type,content,created_at)"
" VALUES (?,?,?,?)",
(self._current_id, self.act_type_var.get(), content, now))
self._conn.commit()
self.act_entry.delete(0, tk.END)
self._load_activities(self._current_id)
def _load_activities(self, cid):
rows = self._conn.execute(
"SELECT created_at,type,content FROM activities"
" WHERE customer_id=? ORDER BY created_at DESC",
(cid,)).fetchall()
self.act_list.configure(state=tk.NORMAL)
self.act_list.delete("1.0", tk.END)
for created_at, atype, content in rows:
self.act_list.insert(
tk.END, f"[{created_at}] [{atype}] {content}\n")
self.act_list.configure(state=tk.DISABLED)
if __name__ == "__main__":
root = tk.Tk()
app = App060(root)
root.mainloop()
UIレイアウトの構築
LabelFrameで入力エリアと結果エリアを視覚的に分けています。pack()で縦に並べ、expand=Trueで結果エリアが画面いっぱいに広がるよう設定しています。
import tkinter as tk
from tkinter import ttk, messagebox
import sqlite3
import os
from datetime import datetime
class App060:
"""顧客管理CRM"""
def __init__(self, root):
self.root = root
self.root.title("顧客管理 CRM")
self.root.geometry("1100x680")
self.root.configure(bg="#1e1e1e")
db_path = os.path.join(os.path.dirname(os.path.abspath(__file__)),
"crm.db")
self._conn = sqlite3.connect(db_path)
self._init_db()
self._current_id = None
self._build_ui()
self._load_list()
def _init_db(self):
self._conn.execute("""
CREATE TABLE IF NOT EXISTS customers (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
company TEXT DEFAULT '',
email TEXT DEFAULT '',
phone TEXT DEFAULT '',
address TEXT DEFAULT '',
status TEXT DEFAULT '見込み',
tags TEXT DEFAULT '',
note TEXT DEFAULT '',
created_at TEXT,
updated_at TEXT
)
""")
self._conn.execute("""
CREATE TABLE IF NOT EXISTS activities (
id INTEGER PRIMARY KEY AUTOINCREMENT,
customer_id INTEGER,
type TEXT,
content TEXT,
created_at TEXT
)
""")
self._conn.commit()
cnt = self._conn.execute("SELECT COUNT(*) FROM customers").fetchone()[0]
if cnt == 0:
now = datetime.now().isoformat(timespec="seconds")
samples = [
("山田 太郎", "株式会社ABC", "yamada@abc.co.jp", "03-1234-5678",
"東京都渋谷区", "顧客", "VIP,IT"),
("鈴木 花子", "有限会社DEF", "suzuki@def.co.jp", "06-2345-6789",
"大阪府梅田", "見込み", "製造"),
("佐藤 次郎", "", "sato@example.com", "090-3456-7890",
"", "顧客", "個人"),
]
for s in samples:
self._conn.execute(
"INSERT INTO customers (name,company,email,phone,"
"address,status,tags,created_at,updated_at)"
" VALUES (?,?,?,?,?,?,?,?,?)",
(*s, now, now))
self._conn.commit()
def _build_ui(self):
header = tk.Frame(self.root, bg="#252526", pady=6)
header.pack(fill=tk.X)
tk.Label(header, text="👥 顧客管理 CRM",
font=("Noto Sans JP", 12, "bold"),
bg="#252526", fg="#4fc3f7").pack(side=tk.LEFT, padx=12)
ttk.Button(header, text="＋ 新規顧客",
command=self._new).pack(side=tk.LEFT, padx=4)
ttk.Button(header, text="💾 保存",
command=self._save).pack(side=tk.LEFT, padx=2)
ttk.Button(header, text="🗑 削除",
command=self._delete).pack(side=tk.LEFT, padx=2)
# 検索・フィルター
sf = tk.Frame(self.root, bg="#1e1e1e", pady=4)
sf.pack(fill=tk.X, padx=8)
tk.Label(sf, text="🔍", bg="#1e1e1e", fg="#ccc").pack(side=tk.LEFT)
self.search_var = tk.StringVar()
self.search_var.trace_add("write", lambda *a: self._load_list())
ttk.Entry(sf, textvariable=self.search_var,
width=24).pack(side=tk.LEFT, padx=4)
tk.Label(sf, text="ステータス:", bg="#1e1e1e", fg="#ccc",
font=("Arial", 9)).pack(side=tk.LEFT, padx=(8, 4))
self.status_filter_var = tk.StringVar(value="すべて")
ttk.Combobox(sf, textvariable=self.status_filter_var,
values=["すべて", "見込み", "商談中", "顧客", "休眠"],
state="readonly", width=10).pack(side=tk.LEFT)
self.status_filter_var.trace_add("write", lambda *a: self._load_list())
# メインエリア
paned = ttk.PanedWindow(self.root, orient=tk.HORIZONTAL)
paned.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# 左: 顧客リスト
left = tk.Frame(paned, bg="#1e1e1e")
paned.add(left, weight=1)
cols = ("name", "company", "status", "tags")
self.tree = ttk.Treeview(left, columns=cols, show="headings",
selectmode="browse")
self.tree.heading("name", text="氏名")
self.tree.heading("company", text="会社")
self.tree.heading("status", text="ステータス")
self.tree.heading("tags", text="タグ")
self.tree.column("name", width=120, anchor="w")
self.tree.column("company", width=120, anchor="w")
self.tree.column("status", width=70, anchor="center")
self.tree.column("tags", width=80, anchor="w")
sb = ttk.Scrollbar(left, command=self.tree.yview)
self.tree.configure(yscrollcommand=sb.set)
sb.pack(side=tk.RIGHT, fill=tk.Y)
self.tree.pack(fill=tk.BOTH, expand=True)
self.tree.bind("<<TreeviewSelect>>", self._on_select)
self.count_lbl = tk.Label(left, text="0 件", bg="#1e1e1e",
fg="#555", font=("Arial", 8))
self.count_lbl.pack(anchor="e")
# 右: 詳細フォーム + アクティビティ
right = tk.Frame(paned, bg="#1e1e1e")
paned.add(right, weight=2)
self._build_detail(right)
self.status_var = tk.StringVar(value="顧客を選択してください")
tk.Label(self.root, textvariable=self.status_var,
bg="#252526", fg="#858585", font=("Arial", 9),
anchor="w", padx=8).pack(fill=tk.X, side=tk.BOTTOM)
def _build_detail(self, parent):
nb = ttk.Notebook(parent)
nb.pack(fill=tk.BOTH, expand=True)
# 基本情報タブ
info_tab = tk.Frame(nb, bg="#1e1e1e")
nb.add(info_tab, text="基本情報")
form = tk.Frame(info_tab, bg="#252526", padx=12, pady=8)
form.pack(fill=tk.X)
fields = [
("氏名 *", "name_var"),
("会社名", "company_var"),
("メール", "email_var"),
("電話", "phone_var"),
("住所", "address_var"),
]
for i, (label, attr) in enumerate(fields):
tk.Label(form, text=label, bg="#252526", fg="#ccc",
font=("Arial", 9), width=10, anchor="e").grid(
row=i, column=0, sticky="e", pady=2)
var = tk.StringVar()
setattr(self, attr, var)
ttk.Entry(form, textvariable=var,
width=36).grid(row=i, column=1, padx=6, sticky="ew")
form.columnconfigure(1, weight=1)
# ステータス
tk.Label(form, text="ステータス", bg="#252526", fg="#ccc",
font=("Arial", 9), width=10, anchor="e").grid(
row=5, column=0, sticky="e", pady=2)
self.cust_status_var = tk.StringVar(value="見込み")
ttk.Combobox(form, textvariable=self.cust_status_var,
values=["見込み", "商談中", "顧客", "休眠"],
state="readonly", width=12).grid(
row=5, column=1, padx=6, sticky="w")
# タグ
tk.Label(form, text="タグ", bg="#252526", fg="#ccc",
font=("Arial", 9), width=10, anchor="e").grid(
row=6, column=0, sticky="e", pady=2)
self.tags_var = tk.StringVar()
ttk.Entry(form, textvariable=self.tags_var,
width=36).grid(row=6, column=1, padx=6, sticky="ew")
# メモ
note_f = tk.Frame(info_tab, bg="#1e1e1e", padx=8, pady=4)
note_f.pack(fill=tk.BOTH, expand=True)
tk.Label(note_f, text="メモ:", bg="#1e1e1e", fg="#888",
font=("Arial", 9)).pack(anchor="w")
self.note_text = tk.Text(note_f, height=5, bg="#0d1117", fg="#d4d4d4",
font=("Arial", 10), relief=tk.FLAT,
insertbackground="#fff")
self.note_text.pack(fill=tk.BOTH, expand=True)
# アクティビティタブ
act_tab = tk.Frame(nb, bg="#1e1e1e")
nb.add(act_tab, text="アクティビティ")
act_ctrl = tk.Frame(act_tab, bg="#252526", pady=4)
act_ctrl.pack(fill=tk.X)
tk.Label(act_ctrl, text="種別:", bg="#252526", fg="#ccc",
font=("Arial", 9)).pack(side=tk.LEFT, padx=4)
self.act_type_var = tk.StringVar(value="電話")
ttk.Combobox(act_ctrl, textvariable=self.act_type_var,
values=["電話", "メール", "訪問", "商談", "その他"],
state="readonly", width=8).pack(side=tk.LEFT)
self.act_entry = ttk.Entry(act_ctrl, width=30)
self.act_entry.pack(side=tk.LEFT, padx=4)
ttk.Button(act_ctrl, text="記録",
command=self._add_activity).pack(side=tk.LEFT)
self.act_list = tk.Text(act_tab, bg="#0d1117", fg="#8b949e",
font=("Courier New", 9), relief=tk.FLAT,
state=tk.DISABLED)
self.act_list.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# ── データ操作 ────────────────────────────────────────────────
def _load_list(self):
q = self.search_var.get().strip().lower()
sf = self.status_filter_var.get()
sql = "SELECT id,name,company,status,tags FROM customers WHERE 1=1"
params = []
if q:
sql += " AND (LOWER(name) LIKE ? OR LOWER(company) LIKE ? OR LOWER(email) LIKE ?)"
params += [f"%{q}%"] * 3
if sf != "すべて":
sql += " AND status=?"
params.append(sf)
sql += " ORDER BY name"
rows = self._conn.execute(sql, params).fetchall()
self.tree.delete(*self.tree.get_children())
for cid, name, company, status, tags in rows:
self.tree.insert("", tk.END, iid=str(cid),
values=(name, company, status, tags))
self.count_lbl.config(text=f"{len(rows)} 件")
def _on_select(self, event=None):
sel = self.tree.selection()
if not sel:
return
cid = int(sel[0])
row = self._conn.execute(
"SELECT id,name,company,email,phone,address,status,tags,note"
" FROM customers WHERE id=?", (cid,)).fetchone()
if not row:
return
self._current_id = row[0]
self.name_var.set(row[1])
self.company_var.set(row[2])
self.email_var.set(row[3])
self.phone_var.set(row[4])
self.address_var.set(row[5])
self.cust_status_var.set(row[6])
self.tags_var.set(row[7])
self.note_text.delete("1.0", tk.END)
self.note_text.insert(tk.END, row[8] or "")
self._load_activities(cid)
self.status_var.set(f"ID={cid} {row[1]}")
def _new(self):
self._current_id = None
for attr in ("name_var", "company_var", "email_var",
"phone_var", "address_var", "tags_var"):
getattr(self, attr).set("")
self.cust_status_var.set("見込み")
self.note_text.delete("1.0", tk.END)
self.act_list.configure(state=tk.NORMAL)
self.act_list.delete("1.0", tk.END)
self.act_list.configure(state=tk.DISABLED)
self.status_var.set("新規顧客")
def _save(self):
name = self.name_var.get().strip()
if not name:
messagebox.showerror("エラー", "氏名は必須です")
return
now = datetime.now().isoformat(timespec="seconds")
vals = (name, self.company_var.get(), self.email_var.get(),
self.phone_var.get(), self.address_var.get(),
self.cust_status_var.get(), self.tags_var.get(),
self.note_text.get("1.0", tk.END).rstrip())
if self._current_id is None:
cur = self._conn.execute(
"INSERT INTO customers (name,company,email,phone,address,"
"status,tags,note,created_at,updated_at)"
" VALUES (?,?,?,?,?,?,?,?,?,?)", (*vals, now, now))
self._current_id = cur.lastrowid
else:
self._conn.execute(
"UPDATE customers SET name=?,company=?,email=?,phone=?,"
"address=?,status=?,tags=?,note=?,updated_at=? WHERE id=?",
(*vals, now, self._current_id))
self._conn.commit()
self._load_list()
try:
self.tree.selection_set(str(self._current_id))
except Exception:
pass
self.status_var.set(f"保存完了: {name}")
def _delete(self):
if self._current_id is None:
return
name = self.name_var.get() or f"ID={self._current_id}"
if not messagebox.askyesno("削除確認", f"「{name}」を削除しますか？"):
return
self._conn.execute("DELETE FROM customers WHERE id=?",
(self._current_id,))
self._conn.execute("DELETE FROM activities WHERE customer_id=?",
(self._current_id,))
self._conn.commit()
self._current_id = None
self._new()
self._load_list()
def _add_activity(self):
if self._current_id is None:
messagebox.showwarning("警告", "先に顧客を選択または保存してください")
return
content = self.act_entry.get().strip()
if not content:
return
now = datetime.now().isoformat(timespec="seconds")
self._conn.execute(
"INSERT INTO activities (customer_id,type,content,created_at)"
" VALUES (?,?,?,?)",
(self._current_id, self.act_type_var.get(), content, now))
self._conn.commit()
self.act_entry.delete(0, tk.END)
self._load_activities(self._current_id)
def _load_activities(self, cid):
rows = self._conn.execute(
"SELECT created_at,type,content FROM activities"
" WHERE customer_id=? ORDER BY created_at DESC",
(cid,)).fetchall()
self.act_list.configure(state=tk.NORMAL)
self.act_list.delete("1.0", tk.END)
for created_at, atype, content in rows:
self.act_list.insert(
tk.END, f"[{created_at}] [{atype}] {content}\n")
self.act_list.configure(state=tk.DISABLED)
if __name__ == "__main__":
root = tk.Tk()
app = App060(root)
root.mainloop()
イベント処理
ボタンのcommand引数でクリックイベントを、bind('
import tkinter as tk
from tkinter import ttk, messagebox
import sqlite3
import os
from datetime import datetime
class App060:
"""顧客管理CRM"""
def __init__(self, root):
self.root = root
self.root.title("顧客管理 CRM")
self.root.geometry("1100x680")
self.root.configure(bg="#1e1e1e")
db_path = os.path.join(os.path.dirname(os.path.abspath(__file__)),
"crm.db")
self._conn = sqlite3.connect(db_path)
self._init_db()
self._current_id = None
self._build_ui()
self._load_list()
def _init_db(self):
self._conn.execute("""
CREATE TABLE IF NOT EXISTS customers (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
company TEXT DEFAULT '',
email TEXT DEFAULT '',
phone TEXT DEFAULT '',
address TEXT DEFAULT '',
status TEXT DEFAULT '見込み',
tags TEXT DEFAULT '',
note TEXT DEFAULT '',
created_at TEXT,
updated_at TEXT
)
""")
self._conn.execute("""
CREATE TABLE IF NOT EXISTS activities (
id INTEGER PRIMARY KEY AUTOINCREMENT,
customer_id INTEGER,
type TEXT,
content TEXT,
created_at TEXT
)
""")
self._conn.commit()
cnt = self._conn.execute("SELECT COUNT(*) FROM customers").fetchone()[0]
if cnt == 0:
now = datetime.now().isoformat(timespec="seconds")
samples = [
("山田 太郎", "株式会社ABC", "yamada@abc.co.jp", "03-1234-5678",
"東京都渋谷区", "顧客", "VIP,IT"),
("鈴木 花子", "有限会社DEF", "suzuki@def.co.jp", "06-2345-6789",
"大阪府梅田", "見込み", "製造"),
("佐藤 次郎", "", "sato@example.com", "090-3456-7890",
"", "顧客", "個人"),
]
for s in samples:
self._conn.execute(
"INSERT INTO customers (name,company,email,phone,"
"address,status,tags,created_at,updated_at)"
" VALUES (?,?,?,?,?,?,?,?,?)",
(*s, now, now))
self._conn.commit()
def _build_ui(self):
header = tk.Frame(self.root, bg="#252526", pady=6)
header.pack(fill=tk.X)
tk.Label(header, text="👥 顧客管理 CRM",
font=("Noto Sans JP", 12, "bold"),
bg="#252526", fg="#4fc3f7").pack(side=tk.LEFT, padx=12)
ttk.Button(header, text="＋ 新規顧客",
command=self._new).pack(side=tk.LEFT, padx=4)
ttk.Button(header, text="💾 保存",
command=self._save).pack(side=tk.LEFT, padx=2)
ttk.Button(header, text="🗑 削除",
command=self._delete).pack(side=tk.LEFT, padx=2)
# 検索・フィルター
sf = tk.Frame(self.root, bg="#1e1e1e", pady=4)
sf.pack(fill=tk.X, padx=8)
tk.Label(sf, text="🔍", bg="#1e1e1e", fg="#ccc").pack(side=tk.LEFT)
self.search_var = tk.StringVar()
self.search_var.trace_add("write", lambda *a: self._load_list())
ttk.Entry(sf, textvariable=self.search_var,
width=24).pack(side=tk.LEFT, padx=4)
tk.Label(sf, text="ステータス:", bg="#1e1e1e", fg="#ccc",
font=("Arial", 9)).pack(side=tk.LEFT, padx=(8, 4))
self.status_filter_var = tk.StringVar(value="すべて")
ttk.Combobox(sf, textvariable=self.status_filter_var,
values=["すべて", "見込み", "商談中", "顧客", "休眠"],
state="readonly", width=10).pack(side=tk.LEFT)
self.status_filter_var.trace_add("write", lambda *a: self._load_list())
# メインエリア
paned = ttk.PanedWindow(self.root, orient=tk.HORIZONTAL)
paned.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# 左: 顧客リスト
left = tk.Frame(paned, bg="#1e1e1e")
paned.add(left, weight=1)
cols = ("name", "company", "status", "tags")
self.tree = ttk.Treeview(left, columns=cols, show="headings",
selectmode="browse")
self.tree.heading("name", text="氏名")
self.tree.heading("company", text="会社")
self.tree.heading("status", text="ステータス")
self.tree.heading("tags", text="タグ")
self.tree.column("name", width=120, anchor="w")
self.tree.column("company", width=120, anchor="w")
self.tree.column("status", width=70, anchor="center")
self.tree.column("tags", width=80, anchor="w")
sb = ttk.Scrollbar(left, command=self.tree.yview)
self.tree.configure(yscrollcommand=sb.set)
sb.pack(side=tk.RIGHT, fill=tk.Y)
self.tree.pack(fill=tk.BOTH, expand=True)
self.tree.bind("<<TreeviewSelect>>", self._on_select)
self.count_lbl = tk.Label(left, text="0 件", bg="#1e1e1e",
fg="#555", font=("Arial", 8))
self.count_lbl.pack(anchor="e")
# 右: 詳細フォーム + アクティビティ
right = tk.Frame(paned, bg="#1e1e1e")
paned.add(right, weight=2)
self._build_detail(right)
self.status_var = tk.StringVar(value="顧客を選択してください")
tk.Label(self.root, textvariable=self.status_var,
bg="#252526", fg="#858585", font=("Arial", 9),
anchor="w", padx=8).pack(fill=tk.X, side=tk.BOTTOM)
def _build_detail(self, parent):
nb = ttk.Notebook(parent)
nb.pack(fill=tk.BOTH, expand=True)
# 基本情報タブ
info_tab = tk.Frame(nb, bg="#1e1e1e")
nb.add(info_tab, text="基本情報")
form = tk.Frame(info_tab, bg="#252526", padx=12, pady=8)
form.pack(fill=tk.X)
fields = [
("氏名 *", "name_var"),
("会社名", "company_var"),
("メール", "email_var"),
("電話", "phone_var"),
("住所", "address_var"),
]
for i, (label, attr) in enumerate(fields):
tk.Label(form, text=label, bg="#252526", fg="#ccc",
font=("Arial", 9), width=10, anchor="e").grid(
row=i, column=0, sticky="e", pady=2)
var = tk.StringVar()
setattr(self, attr, var)
ttk.Entry(form, textvariable=var,
width=36).grid(row=i, column=1, padx=6, sticky="ew")
form.columnconfigure(1, weight=1)
# ステータス
tk.Label(form, text="ステータス", bg="#252526", fg="#ccc",
font=("Arial", 9), width=10, anchor="e").grid(
row=5, column=0, sticky="e", pady=2)
self.cust_status_var = tk.StringVar(value="見込み")
ttk.Combobox(form, textvariable=self.cust_status_var,
values=["見込み", "商談中", "顧客", "休眠"],
state="readonly", width=12).grid(
row=5, column=1, padx=6, sticky="w")
# タグ
tk.Label(form, text="タグ", bg="#252526", fg="#ccc",
font=("Arial", 9), width=10, anchor="e").grid(
row=6, column=0, sticky="e", pady=2)
self.tags_var = tk.StringVar()
ttk.Entry(form, textvariable=self.tags_var,
width=36).grid(row=6, column=1, padx=6, sticky="ew")
# メモ
note_f = tk.Frame(info_tab, bg="#1e1e1e", padx=8, pady=4)
note_f.pack(fill=tk.BOTH, expand=True)
tk.Label(note_f, text="メモ:", bg="#1e1e1e", fg="#888",
font=("Arial", 9)).pack(anchor="w")
self.note_text = tk.Text(note_f, height=5, bg="#0d1117", fg="#d4d4d4",
font=("Arial", 10), relief=tk.FLAT,
insertbackground="#fff")
self.note_text.pack(fill=tk.BOTH, expand=True)
# アクティビティタブ
act_tab = tk.Frame(nb, bg="#1e1e1e")
nb.add(act_tab, text="アクティビティ")
act_ctrl = tk.Frame(act_tab, bg="#252526", pady=4)
act_ctrl.pack(fill=tk.X)
tk.Label(act_ctrl, text="種別:", bg="#252526", fg="#ccc",
font=("Arial", 9)).pack(side=tk.LEFT, padx=4)
self.act_type_var = tk.StringVar(value="電話")
ttk.Combobox(act_ctrl, textvariable=self.act_type_var,
values=["電話", "メール", "訪問", "商談", "その他"],
state="readonly", width=8).pack(side=tk.LEFT)
self.act_entry = ttk.Entry(act_ctrl, width=30)
self.act_entry.pack(side=tk.LEFT, padx=4)
ttk.Button(act_ctrl, text="記録",
command=self._add_activity).pack(side=tk.LEFT)
self.act_list = tk.Text(act_tab, bg="#0d1117", fg="#8b949e",
font=("Courier New", 9), relief=tk.FLAT,
state=tk.DISABLED)
self.act_list.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# ── データ操作 ────────────────────────────────────────────────
def _load_list(self):
q = self.search_var.get().strip().lower()
sf = self.status_filter_var.get()
sql = "SELECT id,name,company,status,tags FROM customers WHERE 1=1"
params = []
if q:
sql += " AND (LOWER(name) LIKE ? OR LOWER(company) LIKE ? OR LOWER(email) LIKE ?)"
params += [f"%{q}%"] * 3
if sf != "すべて":
sql += " AND status=?"
params.append(sf)
sql += " ORDER BY name"
rows = self._conn.execute(sql, params).fetchall()
self.tree.delete(*self.tree.get_children())
for cid, name, company, status, tags in rows:
self.tree.insert("", tk.END, iid=str(cid),
values=(name, company, status, tags))
self.count_lbl.config(text=f"{len(rows)} 件")
def _on_select(self, event=None):
sel = self.tree.selection()
if not sel:
return
cid = int(sel[0])
row = self._conn.execute(
"SELECT id,name,company,email,phone,address,status,tags,note"
" FROM customers WHERE id=?", (cid,)).fetchone()
if not row:
return
self._current_id = row[0]
self.name_var.set(row[1])
self.company_var.set(row[2])
self.email_var.set(row[3])
self.phone_var.set(row[4])
self.address_var.set(row[5])
self.cust_status_var.set(row[6])
self.tags_var.set(row[7])
self.note_text.delete("1.0", tk.END)
self.note_text.insert(tk.END, row[8] or "")
self._load_activities(cid)
self.status_var.set(f"ID={cid} {row[1]}")
def _new(self):
self._current_id = None
for attr in ("name_var", "company_var", "email_var",
"phone_var", "address_var", "tags_var"):
getattr(self, attr).set("")
self.cust_status_var.set("見込み")
self.note_text.delete("1.0", tk.END)
self.act_list.configure(state=tk.NORMAL)
self.act_list.delete("1.0", tk.END)
self.act_list.configure(state=tk.DISABLED)
self.status_var.set("新規顧客")
def _save(self):
name = self.name_var.get().strip()
if not name:
messagebox.showerror("エラー", "氏名は必須です")
return
now = datetime.now().isoformat(timespec="seconds")
vals = (name, self.company_var.get(), self.email_var.get(),
self.phone_var.get(), self.address_var.get(),
self.cust_status_var.get(), self.tags_var.get(),
self.note_text.get("1.0", tk.END).rstrip())
if self._current_id is None:
cur = self._conn.execute(
"INSERT INTO customers (name,company,email,phone,address,"
"status,tags,note,created_at,updated_at)"
" VALUES (?,?,?,?,?,?,?,?,?,?)", (*vals, now, now))
self._current_id = cur.lastrowid
else:
self._conn.execute(
"UPDATE customers SET name=?,company=?,email=?,phone=?,"
"address=?,status=?,tags=?,note=?,updated_at=? WHERE id=?",
(*vals, now, self._current_id))
self._conn.commit()
self._load_list()
try:
self.tree.selection_set(str(self._current_id))
except Exception:
pass
self.status_var.set(f"保存完了: {name}")
def _delete(self):
if self._current_id is None:
return
name = self.name_var.get() or f"ID={self._current_id}"
if not messagebox.askyesno("削除確認", f"「{name}」を削除しますか？"):
return
self._conn.execute("DELETE FROM customers WHERE id=?",
(self._current_id,))
self._conn.execute("DELETE FROM activities WHERE customer_id=?",
(self._current_id,))
self._conn.commit()
self._current_id = None
self._new()
self._load_list()
def _add_activity(self):
if self._current_id is None:
messagebox.showwarning("警告", "先に顧客を選択または保存してください")
return
content = self.act_entry.get().strip()
if not content:
return
now = datetime.now().isoformat(timespec="seconds")
self._conn.execute(
"INSERT INTO activities (customer_id,type,content,created_at)"
" VALUES (?,?,?,?)",
(self._current_id, self.act_type_var.get(), content, now))
self._conn.commit()
self.act_entry.delete(0, tk.END)
self._load_activities(self._current_id)
def _load_activities(self, cid):
rows = self._conn.execute(
"SELECT created_at,type,content FROM activities"
" WHERE customer_id=? ORDER BY created_at DESC",
(cid,)).fetchall()
self.act_list.configure(state=tk.NORMAL)
self.act_list.delete("1.0", tk.END)
for created_at, atype, content in rows:
self.act_list.insert(
tk.END, f"[{created_at}] [{atype}] {content}\n")
self.act_list.configure(state=tk.DISABLED)
if __name__ == "__main__":
root = tk.Tk()
app = App060(root)
root.mainloop()
Textウィジェットでの結果表示
tk.Textウィジェットをstate=DISABLED（読み取り専用）で作成し、更新時はNORMALに変更してinsert()で内容を書き込み、再びDISABLEDに戻します。
import tkinter as tk
from tkinter import ttk, messagebox
import sqlite3
import os
from datetime import datetime
class App060:
"""顧客管理CRM"""
def __init__(self, root):
self.root = root
self.root.title("顧客管理 CRM")
self.root.geometry("1100x680")
self.root.configure(bg="#1e1e1e")
db_path = os.path.join(os.path.dirname(os.path.abspath(__file__)),
"crm.db")
self._conn = sqlite3.connect(db_path)
self._init_db()
self._current_id = None
self._build_ui()
self._load_list()
def _init_db(self):
self._conn.execute("""
CREATE TABLE IF NOT EXISTS customers (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
company TEXT DEFAULT '',
email TEXT DEFAULT '',
phone TEXT DEFAULT '',
address TEXT DEFAULT '',
status TEXT DEFAULT '見込み',
tags TEXT DEFAULT '',
note TEXT DEFAULT '',
created_at TEXT,
updated_at TEXT
)
""")
self._conn.execute("""
CREATE TABLE IF NOT EXISTS activities (
id INTEGER PRIMARY KEY AUTOINCREMENT,
customer_id INTEGER,
type TEXT,
content TEXT,
created_at TEXT
)
""")
self._conn.commit()
cnt = self._conn.execute("SELECT COUNT(*) FROM customers").fetchone()[0]
if cnt == 0:
now = datetime.now().isoformat(timespec="seconds")
samples = [
("山田 太郎", "株式会社ABC", "yamada@abc.co.jp", "03-1234-5678",
"東京都渋谷区", "顧客", "VIP,IT"),
("鈴木 花子", "有限会社DEF", "suzuki@def.co.jp", "06-2345-6789",
"大阪府梅田", "見込み", "製造"),
("佐藤 次郎", "", "sato@example.com", "090-3456-7890",
"", "顧客", "個人"),
]
for s in samples:
self._conn.execute(
"INSERT INTO customers (name,company,email,phone,"
"address,status,tags,created_at,updated_at)"
" VALUES (?,?,?,?,?,?,?,?,?)",
(*s, now, now))
self._conn.commit()
def _build_ui(self):
header = tk.Frame(self.root, bg="#252526", pady=6)
header.pack(fill=tk.X)
tk.Label(header, text="👥 顧客管理 CRM",
font=("Noto Sans JP", 12, "bold"),
bg="#252526", fg="#4fc3f7").pack(side=tk.LEFT, padx=12)
ttk.Button(header, text="＋ 新規顧客",
command=self._new).pack(side=tk.LEFT, padx=4)
ttk.Button(header, text="💾 保存",
command=self._save).pack(side=tk.LEFT, padx=2)
ttk.Button(header, text="🗑 削除",
command=self._delete).pack(side=tk.LEFT, padx=2)
# 検索・フィルター
sf = tk.Frame(self.root, bg="#1e1e1e", pady=4)
sf.pack(fill=tk.X, padx=8)
tk.Label(sf, text="🔍", bg="#1e1e1e", fg="#ccc").pack(side=tk.LEFT)
self.search_var = tk.StringVar()
self.search_var.trace_add("write", lambda *a: self._load_list())
ttk.Entry(sf, textvariable=self.search_var,
width=24).pack(side=tk.LEFT, padx=4)
tk.Label(sf, text="ステータス:", bg="#1e1e1e", fg="#ccc",
font=("Arial", 9)).pack(side=tk.LEFT, padx=(8, 4))
self.status_filter_var = tk.StringVar(value="すべて")
ttk.Combobox(sf, textvariable=self.status_filter_var,
values=["すべて", "見込み", "商談中", "顧客", "休眠"],
state="readonly", width=10).pack(side=tk.LEFT)
self.status_filter_var.trace_add("write", lambda *a: self._load_list())
# メインエリア
paned = ttk.PanedWindow(self.root, orient=tk.HORIZONTAL)
paned.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# 左: 顧客リスト
left = tk.Frame(paned, bg="#1e1e1e")
paned.add(left, weight=1)
cols = ("name", "company", "status", "tags")
self.tree = ttk.Treeview(left, columns=cols, show="headings",
selectmode="browse")
self.tree.heading("name", text="氏名")
self.tree.heading("company", text="会社")
self.tree.heading("status", text="ステータス")
self.tree.heading("tags", text="タグ")
self.tree.column("name", width=120, anchor="w")
self.tree.column("company", width=120, anchor="w")
self.tree.column("status", width=70, anchor="center")
self.tree.column("tags", width=80, anchor="w")
sb = ttk.Scrollbar(left, command=self.tree.yview)
self.tree.configure(yscrollcommand=sb.set)
sb.pack(side=tk.RIGHT, fill=tk.Y)
self.tree.pack(fill=tk.BOTH, expand=True)
self.tree.bind("<<TreeviewSelect>>", self._on_select)
self.count_lbl = tk.Label(left, text="0 件", bg="#1e1e1e",
fg="#555", font=("Arial", 8))
self.count_lbl.pack(anchor="e")
# 右: 詳細フォーム + アクティビティ
right = tk.Frame(paned, bg="#1e1e1e")
paned.add(right, weight=2)
self._build_detail(right)
self.status_var = tk.StringVar(value="顧客を選択してください")
tk.Label(self.root, textvariable=self.status_var,
bg="#252526", fg="#858585", font=("Arial", 9),
anchor="w", padx=8).pack(fill=tk.X, side=tk.BOTTOM)
def _build_detail(self, parent):
nb = ttk.Notebook(parent)
nb.pack(fill=tk.BOTH, expand=True)
# 基本情報タブ
info_tab = tk.Frame(nb, bg="#1e1e1e")
nb.add(info_tab, text="基本情報")
form = tk.Frame(info_tab, bg="#252526", padx=12, pady=8)
form.pack(fill=tk.X)
fields = [
("氏名 *", "name_var"),
("会社名", "company_var"),
("メール", "email_var"),
("電話", "phone_var"),
("住所", "address_var"),
]
for i, (label, attr) in enumerate(fields):
tk.Label(form, text=label, bg="#252526", fg="#ccc",
font=("Arial", 9), width=10, anchor="e").grid(
row=i, column=0, sticky="e", pady=2)
var = tk.StringVar()
setattr(self, attr, var)
ttk.Entry(form, textvariable=var,
width=36).grid(row=i, column=1, padx=6, sticky="ew")
form.columnconfigure(1, weight=1)
# ステータス
tk.Label(form, text="ステータス", bg="#252526", fg="#ccc",
font=("Arial", 9), width=10, anchor="e").grid(
row=5, column=0, sticky="e", pady=2)
self.cust_status_var = tk.StringVar(value="見込み")
ttk.Combobox(form, textvariable=self.cust_status_var,
values=["見込み", "商談中", "顧客", "休眠"],
state="readonly", width=12).grid(
row=5, column=1, padx=6, sticky="w")
# タグ
tk.Label(form, text="タグ", bg="#252526", fg="#ccc",
font=("Arial", 9), width=10, anchor="e").grid(
row=6, column=0, sticky="e", pady=2)
self.tags_var = tk.StringVar()
ttk.Entry(form, textvariable=self.tags_var,
width=36).grid(row=6, column=1, padx=6, sticky="ew")
# メモ
note_f = tk.Frame(info_tab, bg="#1e1e1e", padx=8, pady=4)
note_f.pack(fill=tk.BOTH, expand=True)
tk.Label(note_f, text="メモ:", bg="#1e1e1e", fg="#888",
font=("Arial", 9)).pack(anchor="w")
self.note_text = tk.Text(note_f, height=5, bg="#0d1117", fg="#d4d4d4",
font=("Arial", 10), relief=tk.FLAT,
insertbackground="#fff")
self.note_text.pack(fill=tk.BOTH, expand=True)
# アクティビティタブ
act_tab = tk.Frame(nb, bg="#1e1e1e")
nb.add(act_tab, text="アクティビティ")
act_ctrl = tk.Frame(act_tab, bg="#252526", pady=4)
act_ctrl.pack(fill=tk.X)
tk.Label(act_ctrl, text="種別:", bg="#252526", fg="#ccc",
font=("Arial", 9)).pack(side=tk.LEFT, padx=4)
self.act_type_var = tk.StringVar(value="電話")
ttk.Combobox(act_ctrl, textvariable=self.act_type_var,
values=["電話", "メール", "訪問", "商談", "その他"],
state="readonly", width=8).pack(side=tk.LEFT)
self.act_entry = ttk.Entry(act_ctrl, width=30)
self.act_entry.pack(side=tk.LEFT, padx=4)
ttk.Button(act_ctrl, text="記録",
command=self._add_activity).pack(side=tk.LEFT)
self.act_list = tk.Text(act_tab, bg="#0d1117", fg="#8b949e",
font=("Courier New", 9), relief=tk.FLAT,
state=tk.DISABLED)
self.act_list.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# ── データ操作 ────────────────────────────────────────────────
def _load_list(self):
q = self.search_var.get().strip().lower()
sf = self.status_filter_var.get()
sql = "SELECT id,name,company,status,tags FROM customers WHERE 1=1"
params = []
if q:
sql += " AND (LOWER(name) LIKE ? OR LOWER(company) LIKE ? OR LOWER(email) LIKE ?)"
params += [f"%{q}%"] * 3
if sf != "すべて":
sql += " AND status=?"
params.append(sf)
sql += " ORDER BY name"
rows = self._conn.execute(sql, params).fetchall()
self.tree.delete(*self.tree.get_children())
for cid, name, company, status, tags in rows:
self.tree.insert("", tk.END, iid=str(cid),
values=(name, company, status, tags))
self.count_lbl.config(text=f"{len(rows)} 件")
def _on_select(self, event=None):
sel = self.tree.selection()
if not sel:
return
cid = int(sel[0])
row = self._conn.execute(
"SELECT id,name,company,email,phone,address,status,tags,note"
" FROM customers WHERE id=?", (cid,)).fetchone()
if not row:
return
self._current_id = row[0]
self.name_var.set(row[1])
self.company_var.set(row[2])
self.email_var.set(row[3])
self.phone_var.set(row[4])
self.address_var.set(row[5])
self.cust_status_var.set(row[6])
self.tags_var.set(row[7])
self.note_text.delete("1.0", tk.END)
self.note_text.insert(tk.END, row[8] or "")
self._load_activities(cid)
self.status_var.set(f"ID={cid} {row[1]}")
def _new(self):
self._current_id = None
for attr in ("name_var", "company_var", "email_var",
"phone_var", "address_var", "tags_var"):
getattr(self, attr).set("")
self.cust_status_var.set("見込み")
self.note_text.delete("1.0", tk.END)
self.act_list.configure(state=tk.NORMAL)
self.act_list.delete("1.0", tk.END)
self.act_list.configure(state=tk.DISABLED)
self.status_var.set("新規顧客")
def _save(self):
name = self.name_var.get().strip()
if not name:
messagebox.showerror("エラー", "氏名は必須です")
return
now = datetime.now().isoformat(timespec="seconds")
vals = (name, self.company_var.get(), self.email_var.get(),
self.phone_var.get(), self.address_var.get(),
self.cust_status_var.get(), self.tags_var.get(),
self.note_text.get("1.0", tk.END).rstrip())
if self._current_id is None:
cur = self._conn.execute(
"INSERT INTO customers (name,company,email,phone,address,"
"status,tags,note,created_at,updated_at)"
" VALUES (?,?,?,?,?,?,?,?,?,?)", (*vals, now, now))
self._current_id = cur.lastrowid
else:
self._conn.execute(
"UPDATE customers SET name=?,company=?,email=?,phone=?,"
"address=?,status=?,tags=?,note=?,updated_at=? WHERE id=?",
(*vals, now, self._current_id))
self._conn.commit()
self._load_list()
try:
self.tree.selection_set(str(self._current_id))
except Exception:
pass
self.status_var.set(f"保存完了: {name}")
def _delete(self):
if self._current_id is None:
return
name = self.name_var.get() or f"ID={self._current_id}"
if not messagebox.askyesno("削除確認", f"「{name}」を削除しますか？"):
return
self._conn.execute("DELETE FROM customers WHERE id=?",
(self._current_id,))
self._conn.execute("DELETE FROM activities WHERE customer_id=?",
(self._current_id,))
self._conn.commit()
self._current_id = None
self._new()
self._load_list()
def _add_activity(self):
if self._current_id is None:
messagebox.showwarning("警告", "先に顧客を選択または保存してください")
return
content = self.act_entry.get().strip()
if not content:
return
now = datetime.now().isoformat(timespec="seconds")
self._conn.execute(
"INSERT INTO activities (customer_id,type,content,created_at)"
" VALUES (?,?,?,?)",
(self._current_id, self.act_type_var.get(), content, now))
self._conn.commit()
self.act_entry.delete(0, tk.END)
self._load_activities(self._current_id)
def _load_activities(self, cid):
rows = self._conn.execute(
"SELECT created_at,type,content FROM activities"
" WHERE customer_id=? ORDER BY created_at DESC",
(cid,)).fetchall()
self.act_list.configure(state=tk.NORMAL)
self.act_list.delete("1.0", tk.END)
for created_at, atype, content in rows:
self.act_list.insert(
tk.END, f"[{created_at}] [{atype}] {content}\n")
self.act_list.configure(state=tk.DISABLED)
if __name__ == "__main__":
root = tk.Tk()
app = App060(root)
root.mainloop()
例外処理とエラーハンドリング
try-exceptでValueErrorとExceptionを捕捉し、messagebox.showerror()でエラーメッセージを表示します。予期しないエラーも処理することで、アプリの堅牢性が向上します。
import tkinter as tk
from tkinter import ttk, messagebox
import sqlite3
import os
from datetime import datetime
class App060:
"""顧客管理CRM"""
def __init__(self, root):
self.root = root
self.root.title("顧客管理 CRM")
self.root.geometry("1100x680")
self.root.configure(bg="#1e1e1e")
db_path = os.path.join(os.path.dirname(os.path.abspath(__file__)),
"crm.db")
self._conn = sqlite3.connect(db_path)
self._init_db()
self._current_id = None
self._build_ui()
self._load_list()
def _init_db(self):
self._conn.execute("""
CREATE TABLE IF NOT EXISTS customers (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
company TEXT DEFAULT '',
email TEXT DEFAULT '',
phone TEXT DEFAULT '',
address TEXT DEFAULT '',
status TEXT DEFAULT '見込み',
tags TEXT DEFAULT '',
note TEXT DEFAULT '',
created_at TEXT,
updated_at TEXT
)
""")
self._conn.execute("""
CREATE TABLE IF NOT EXISTS activities (
id INTEGER PRIMARY KEY AUTOINCREMENT,
customer_id INTEGER,
type TEXT,
content TEXT,
created_at TEXT
)
""")
self._conn.commit()
cnt = self._conn.execute("SELECT COUNT(*) FROM customers").fetchone()[0]
if cnt == 0:
now = datetime.now().isoformat(timespec="seconds")
samples = [
("山田 太郎", "株式会社ABC", "yamada@abc.co.jp", "03-1234-5678",
"東京都渋谷区", "顧客", "VIP,IT"),
("鈴木 花子", "有限会社DEF", "suzuki@def.co.jp", "06-2345-6789",
"大阪府梅田", "見込み", "製造"),
("佐藤 次郎", "", "sato@example.com", "090-3456-7890",
"", "顧客", "個人"),
]
for s in samples:
self._conn.execute(
"INSERT INTO customers (name,company,email,phone,"
"address,status,tags,created_at,updated_at)"
" VALUES (?,?,?,?,?,?,?,?,?)",
(*s, now, now))
self._conn.commit()
def _build_ui(self):
header = tk.Frame(self.root, bg="#252526", pady=6)
header.pack(fill=tk.X)
tk.Label(header, text="👥 顧客管理 CRM",
font=("Noto Sans JP", 12, "bold"),
bg="#252526", fg="#4fc3f7").pack(side=tk.LEFT, padx=12)
ttk.Button(header, text="＋ 新規顧客",
command=self._new).pack(side=tk.LEFT, padx=4)
ttk.Button(header, text="💾 保存",
command=self._save).pack(side=tk.LEFT, padx=2)
ttk.Button(header, text="🗑 削除",
command=self._delete).pack(side=tk.LEFT, padx=2)
# 検索・フィルター
sf = tk.Frame(self.root, bg="#1e1e1e", pady=4)
sf.pack(fill=tk.X, padx=8)
tk.Label(sf, text="🔍", bg="#1e1e1e", fg="#ccc").pack(side=tk.LEFT)
self.search_var = tk.StringVar()
self.search_var.trace_add("write", lambda *a: self._load_list())
ttk.Entry(sf, textvariable=self.search_var,
width=24).pack(side=tk.LEFT, padx=4)
tk.Label(sf, text="ステータス:", bg="#1e1e1e", fg="#ccc",
font=("Arial", 9)).pack(side=tk.LEFT, padx=(8, 4))
self.status_filter_var = tk.StringVar(value="すべて")
ttk.Combobox(sf, textvariable=self.status_filter_var,
values=["すべて", "見込み", "商談中", "顧客", "休眠"],
state="readonly", width=10).pack(side=tk.LEFT)
self.status_filter_var.trace_add("write", lambda *a: self._load_list())
# メインエリア
paned = ttk.PanedWindow(self.root, orient=tk.HORIZONTAL)
paned.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# 左: 顧客リスト
left = tk.Frame(paned, bg="#1e1e1e")
paned.add(left, weight=1)
cols = ("name", "company", "status", "tags")
self.tree = ttk.Treeview(left, columns=cols, show="headings",
selectmode="browse")
self.tree.heading("name", text="氏名")
self.tree.heading("company", text="会社")
self.tree.heading("status", text="ステータス")
self.tree.heading("tags", text="タグ")
self.tree.column("name", width=120, anchor="w")
self.tree.column("company", width=120, anchor="w")
self.tree.column("status", width=70, anchor="center")
self.tree.column("tags", width=80, anchor="w")
sb = ttk.Scrollbar(left, command=self.tree.yview)
self.tree.configure(yscrollcommand=sb.set)
sb.pack(side=tk.RIGHT, fill=tk.Y)
self.tree.pack(fill=tk.BOTH, expand=True)
self.tree.bind("<<TreeviewSelect>>", self._on_select)
self.count_lbl = tk.Label(left, text="0 件", bg="#1e1e1e",
fg="#555", font=("Arial", 8))
self.count_lbl.pack(anchor="e")
# 右: 詳細フォーム + アクティビティ
right = tk.Frame(paned, bg="#1e1e1e")
paned.add(right, weight=2)
self._build_detail(right)
self.status_var = tk.StringVar(value="顧客を選択してください")
tk.Label(self.root, textvariable=self.status_var,
bg="#252526", fg="#858585", font=("Arial", 9),
anchor="w", padx=8).pack(fill=tk.X, side=tk.BOTTOM)
def _build_detail(self, parent):
nb = ttk.Notebook(parent)
nb.pack(fill=tk.BOTH, expand=True)
# 基本情報タブ
info_tab = tk.Frame(nb, bg="#1e1e1e")
nb.add(info_tab, text="基本情報")
form = tk.Frame(info_tab, bg="#252526", padx=12, pady=8)
form.pack(fill=tk.X)
fields = [
("氏名 *", "name_var"),
("会社名", "company_var"),
("メール", "email_var"),
("電話", "phone_var"),
("住所", "address_var"),
]
for i, (label, attr) in enumerate(fields):
tk.Label(form, text=label, bg="#252526", fg="#ccc",
font=("Arial", 9), width=10, anchor="e").grid(
row=i, column=0, sticky="e", pady=2)
var = tk.StringVar()
setattr(self, attr, var)
ttk.Entry(form, textvariable=var,
width=36).grid(row=i, column=1, padx=6, sticky="ew")
form.columnconfigure(1, weight=1)
# ステータス
tk.Label(form, text="ステータス", bg="#252526", fg="#ccc",
font=("Arial", 9), width=10, anchor="e").grid(
row=5, column=0, sticky="e", pady=2)
self.cust_status_var = tk.StringVar(value="見込み")
ttk.Combobox(form, textvariable=self.cust_status_var,
values=["見込み", "商談中", "顧客", "休眠"],
state="readonly", width=12).grid(
row=5, column=1, padx=6, sticky="w")
# タグ
tk.Label(form, text="タグ", bg="#252526", fg="#ccc",
font=("Arial", 9), width=10, anchor="e").grid(
row=6, column=0, sticky="e", pady=2)
self.tags_var = tk.StringVar()
ttk.Entry(form, textvariable=self.tags_var,
width=36).grid(row=6, column=1, padx=6, sticky="ew")
# メモ
note_f = tk.Frame(info_tab, bg="#1e1e1e", padx=8, pady=4)
note_f.pack(fill=tk.BOTH, expand=True)
tk.Label(note_f, text="メモ:", bg="#1e1e1e", fg="#888",
font=("Arial", 9)).pack(anchor="w")
self.note_text = tk.Text(note_f, height=5, bg="#0d1117", fg="#d4d4d4",
font=("Arial", 10), relief=tk.FLAT,
insertbackground="#fff")
self.note_text.pack(fill=tk.BOTH, expand=True)
# アクティビティタブ
act_tab = tk.Frame(nb, bg="#1e1e1e")
nb.add(act_tab, text="アクティビティ")
act_ctrl = tk.Frame(act_tab, bg="#252526", pady=4)
act_ctrl.pack(fill=tk.X)
tk.Label(act_ctrl, text="種別:", bg="#252526", fg="#ccc",
font=("Arial", 9)).pack(side=tk.LEFT, padx=4)
self.act_type_var = tk.StringVar(value="電話")
ttk.Combobox(act_ctrl, textvariable=self.act_type_var,
values=["電話", "メール", "訪問", "商談", "その他"],
state="readonly", width=8).pack(side=tk.LEFT)
self.act_entry = ttk.Entry(act_ctrl, width=30)
self.act_entry.pack(side=tk.LEFT, padx=4)
ttk.Button(act_ctrl, text="記録",
command=self._add_activity).pack(side=tk.LEFT)
self.act_list = tk.Text(act_tab, bg="#0d1117", fg="#8b949e",
font=("Courier New", 9), relief=tk.FLAT,
state=tk.DISABLED)
self.act_list.pack(fill=tk.BOTH, expand=True, padx=4, pady=4)
# ── データ操作 ────────────────────────────────────────────────
def _load_list(self):
q = self.search_var.get().strip().lower()
sf = self.status_filter_var.get()
sql = "SELECT id,name,company,status,tags FROM customers WHERE 1=1"
params = []
if q:
sql += " AND (LOWER(name) LIKE ? OR LOWER(company) LIKE ? OR LOWER(email) LIKE ?)"
params += [f"%{q}%"] * 3
if sf != "すべて":
sql += " AND status=?"
params.append(sf)
sql += " ORDER BY name"
rows = self._conn.execute(sql, params).fetchall()
self.tree.delete(*self.tree.get_children())
for cid, name, company, status, tags in rows:
self.tree.insert("", tk.END, iid=str(cid),
values=(name, company, status, tags))
self.count_lbl.config(text=f"{len(rows)} 件")
def _on_select(self, event=None):
sel = self.tree.selection()
if not sel:
return
cid = int(sel[0])
row = self._conn.execute(
"SELECT id,name,company,email,phone,address,status,tags,note"
" FROM customers WHERE id=?", (cid,)).fetchone()
if not row:
return
self._current_id = row[0]
self.name_var.set(row[1])
self.company_var.set(row[2])
self.email_var.set(row[3])
self.phone_var.set(row[4])
self.address_var.set(row[5])
self.cust_status_var.set(row[6])
self.tags_var.set(row[7])
self.note_text.delete("1.0", tk.END)
self.note_text.insert(tk.END, row[8] or "")
self._load_activities(cid)
self.status_var.set(f"ID={cid} {row[1]}")
def _new(self):
self._current_id = None
for attr in ("name_var", "company_var", "email_var",
"phone_var", "address_var", "tags_var"):
getattr(self, attr).set("")
self.cust_status_var.set("見込み")
self.note_text.delete("1.0", tk.END)
self.act_list.configure(state=tk.NORMAL)
self.act_list.delete("1.0", tk.END)
self.act_list.configure(state=tk.DISABLED)
self.status_var.set("新規顧客")
def _save(self):
name = self.name_var.get().strip()
if not name:
messagebox.showerror("エラー", "氏名は必須です")
return
now = datetime.now().isoformat(timespec="seconds")
vals = (name, self.company_var.get(), self.email_var.get(),
self.phone_var.get(), self.address_var.get(),
self.cust_status_var.get(), self.tags_var.get(),
self.note_text.get("1.0", tk.END).rstrip())
if self._current_id is None:
cur = self._conn.execute(
"INSERT INTO customers (name,company,email,phone,address,"
"status,tags,note,created_at,updated_at)"
" VALUES (?,?,?,?,?,?,?,?,?,?)", (*vals, now, now))
self._current_id = cur.lastrowid
else:
self._conn.execute(
"UPDATE customers SET name=?,company=?,email=?,phone=?,"
"address=?,status=?,tags=?,note=?,updated_at=? WHERE id=?",
(*vals, now, self._current_id))
self._conn.commit()
self._load_list()
try:
self.tree.selection_set(str(self._current_id))
except Exception:
pass
self.status_var.set(f"保存完了: {name}")
def _delete(self):
if self._current_id is None:
return
name = self.name_var.get() or f"ID={self._current_id}"
if not messagebox.askyesno("削除確認", f"「{name}」を削除しますか？"):
return
self._conn.execute("DELETE FROM customers WHERE id=?",
(self._current_id,))
self._conn.execute("DELETE FROM activities WHERE customer_id=?",
(self._current_id,))
self._conn.commit()
self._current_id = None
self._new()
self._load_list()
def _add_activity(self):
if self._current_id is None:
messagebox.showwarning("警告", "先に顧客を選択または保存してください")
return
content = self.act_entry.get().strip()
if not content:
return
now = datetime.now().isoformat(timespec="seconds")
self._conn.execute(
"INSERT INTO activities (customer_id,type,content,created_at)"
" VALUES (?,?,?,?)",
(self._current_id, self.act_type_var.get(), content, now))
self._conn.commit()
self.act_entry.delete(0, tk.END)
self._load_activities(self._current_id)
def _load_activities(self, cid):
rows = self._conn.execute(
"SELECT created_at,type,content FROM activities"
" WHERE customer_id=? ORDER BY created_at DESC",
(cid,)).fetchall()
self.act_list.configure(state=tk.NORMAL)
self.act_list.delete("1.0", tk.END)
for created_at, atype, content in rows:
self.act_list.insert(
tk.END, f"[{created_at}] [{atype}] {content}\n")
self.act_list.configure(state=tk.DISABLED)
if __name__ == "__main__":
root = tk.Tk()
app = App060(root)
root.mainloop()
6. ステップバイステップガイド
このアプリをゼロから自分で作る手順を解説します。コードをコピーするだけでなく、実際に手順を追って自分で書いてみましょう。
-
1ファイルを作成する
新しいファイルを作成して app060.py と保存します。
-
2クラスの骨格を作る
App060クラスを定義し、__init__とmainloop()の最小構成を作ります。
-
3タイトルバーを作る
Frameを使ってカラーバー付きのタイトルエリアを作ります。
-
4入力フォームを実装する
LabelFrameとEntryウィジェットで入力エリアを作ります。
-
5処理ロジックを実装する
_execute()メソッドにメインロジックを実装します。
-
6結果表示を実装する
TextウィジェットかLabelに結果を表示する_show_result()を実装します。
-
7エラー処理を追加する
try-exceptとmessageboxでエラーハンドリングを追加します。
7. カスタマイズアイデア
基本機能を習得したら、以下のカスタマイズに挑戦してみましょう。
💡 ダークモードを追加する
bg色・fg色を辞書で管理し、ボタン1つでダークモード・ライトモードを切り替えられるようにしましょう。
💡 データの保存機能
処理結果をCSV・TXTファイルに保存する機能を追加しましょう。filedialog.asksaveasfilename()でファイル保存ダイアログが使えます。
💡 設定ダイアログ
フォントサイズや色などの設定をユーザーが変更できるオプションダイアログを追加しましょう。
8. よくある問題と解決法
❌ 日本語フォントが表示されない
原因：システムに日本語フォントが見つからない場合があります。
解決法：font引数を省略するかシステムに合ったフォントを指定してください。
❌ ライブラリのインポートエラー
原因：必要なライブラリがインストールされていません。
解決法：pip install コマンドで必要なライブラリをインストールしてください。
❌ ウィンドウサイズが合わない
原因：画面解像度や表示スケールによって異なる場合があります。
解決法：root.geometry()で適切なサイズに調整してください。
9. 練習問題
アプリの理解を深めるための練習問題です。
-
課題1：機能拡張
顧客管理CRMに新しい機能を1つ追加してみましょう。
-
課題2：UIの改善
色・フォント・レイアウトを変更して、より使いやすいUIにカスタマイズしましょう。
-
課題3：保存機能の追加
処理結果をファイルに保存する機能を追加しましょう。