/* ============================================================
顧客一覧 / 顧客詳細
============================================================ */
/* 会社名の正規化（法人格・空白を除去）＝重複判定のキー */
function custNorm(s) {
return String(s || '').replace(/株式会社|（株）|\(株\)|㈱|有限会社|合同会社|合資会社|一般社団法人|一般財団法人|公益社団法人|学校法人|医療法人社団|医療法人|社会福祉法人|特定非営利活動法人|NPO法人|\s| /gi, '').trim().toLowerCase();
}
/* 意義のない顧客＝社名が伏字（***）・非公開・（社名不明）・空だけ。ReadyCrew取込で社名が取れなかった/非公開の行＝一覧に出さない */
function custIsMeaningless(c) {
const s = String((c && c.company) || '').trim();
if (!s || /非公開|社名不明/.test(s)) return true;
return /^[\*＊?？_＿\-—…・.。\s ]+$/.test(s); // 記号・伏字のみ
}
const CUST_FILLED_FIELDS = ['contact', 'contactDept', 'tel', 'email', 'address', 'url', 'industry', 'employees', 'companyOverview', 'note'];
/* 重複顧客グループを検出：会社名（正規化）が一致する2件以上をまとめ、各グループで
案件数最多→情報が埋まっている→id順 の顧客を残す候補(primaryId)にする */
function findCustomerDupGroups(customers, cases) {
const caseCnt = {}; (cases || []).forEach(k => { if (k.customerId) caseCnt[k.customerId] = (caseCnt[k.customerId] || 0) + 1; });
const filled = (c) => CUST_FILLED_FIELDS.reduce((n, k) => n + (String(c[k] || '').trim() ? 1 : 0), 0);
const groups = {};
// マスク名（*** 等の社名非公開プレースホルダ）は別会社同士なのでグルーピング対象外（2026-07-07 誤結合の再発防止）
const masked = (s) => /^[\*＊?？_＿\-—…・.\s]+$/.test(s) || /非公開/.test(s);
(customers || []).forEach(c => { const n = custNorm(c.company); if (n.length >= 2 && !masked(n)) (groups[n] = groups[n] || []).push(c); });
return Object.entries(groups).filter(([n, arr]) => arr.length > 1).map(([n, arr]) => {
const members = arr.map(c => ({ ...c, _cases: caseCnt[c.id] || 0, _filled: filled(c) }))
.sort((a, b) => b._cases - a._cases || b._filled - a._filled || String(a.id).localeCompare(String(b.id)));
return { key: n, name: members[0].company, members, primaryId: members[0].id };
}).sort((a, b) => b.members.length - a.members.length);
}
function Customers() {
const { cases, navigate, meetings, customers, addCustomer, currentUser, can } = useStore();
const D = window.APP_DATA;
const isMobile = useIsMobile();
const [q, setQ] = React.useState('');
const [openForm, setOpenForm] = React.useState(false);
const [openMerge, setOpenMerge] = React.useState(false);
const [activeOnly, setActiveOnly] = React.useState(false);
const [mineOnly, setMineOnly] = React.useState(false);
const [followupOnly, setFollowupOnly] = React.useState(false);
const [sort, setSort] = React.useState({ key: 'company', dir: 'asc' }); // key: company|cases|active|won|last
const dupGroups = React.useMemo(() => findCustomerDupGroups(customers, cases), [customers, cases]);
// 顧客ごとの集計を一度に算出（案件数・進行中・成約・失注・成約額・最終商談）。全顧客ぶんを O(案件+商談) で。
// 進行中＝結案でない（成約won/受注done・失注lost を除く）。成約＝isCaseWonStatus（won＋done）。
const stats = React.useMemo(() => {
const uid = currentUser && currentUser.id;
const by = {};
customers.forEach(c => (by[c.id] = { n: 0, active: 0, won: 0, lost: 0, amount: 0, lastM: null, mine: false, idle: 0, owner: null, _own: {} }));
const now = today() + 'T23:59';
const meetByCase = {};
meetings.forEach(m => { (meetByCase[m.caseId] = meetByCase[m.caseId] || []).push(m.datetime); });
cases.forEach(k => {
const s = by[k.customerId]; if (!s) return;
s.n++;
const closed = isCaseWonStatus(k.status) || k.status === 'lost';
if (isCaseWonStatus(k.status)) { s.won++; s.amount += caseWonAmount(k); }
else if (k.status === 'lost') s.lost++;
else s.active++;
// アカウント担当＝案件のメイン担当の最頻（進行中案件を2倍加重）
if (k.ownerId) s._own[k.ownerId] = (s._own[k.ownerId] || 0) + (closed ? 1 : 2);
// 自分の顧客＝自分がメイン/サポートの案件を持つ
if (uid && (k.ownerId === uid || (k.subIds || []).includes(uid))) s.mine = true;
// 放置＝進行中案件の caseIdleInfo（ダッシュボードと同一の単一真実）。顧客の idle は最大日数
const info = caseIdleInfo(k); if (info && info.idleDays > s.idle) s.idle = info.idleDays;
const times = [...(meetByCase[k.id] || []), ...((k.meetingDocs || []).map(d => d.datetime))];
const mt = caseMeetingAt(k); if (mt && mt <= now) times.push(mt);
times.forEach(tt => { if (tt && (!s.lastM || tt > s.lastM)) s.lastM = tt; });
});
Object.keys(by).forEach(id => { const o = by[id]._own; by[id].owner = Object.keys(o).sort((a, b) => o[b] - o[a])[0] || null; });
return by;
}, [customers, cases, meetings, currentUser]);
// 並び替え：ヘッダ/セレクトで key を選択。同キー再クリックで昇降トグル、別キーは自然な既定方向
const naturalDir = { company: 'asc', last: 'desc', cases: 'desc', active: 'desc', won: 'desc' };
const onSort = (k) => setSort(s => s.key === k ? { key: k, dir: s.dir === 'asc' ? 'desc' : 'asc' } : { key: k, dir: naturalDir[k] });
const cmp = {
company: (a, b) => String(a.company).localeCompare(String(b.company)),
last: (a, b) => String(stats[a.id].lastM || '').localeCompare(String(stats[b.id].lastM || '')),
cases: (a, b) => stats[a.id].n - stats[b.id].n,
active: (a, b) => stats[a.id].active - stats[b.id].active,
won: (a, b) => stats[a.id].won - stats[b.id].won,
};
const hiddenN = customers.filter(custIsMeaningless).length; // 一覧から除外した「社名不明/非公開」件数（透明性のため件数表示）
let rows = customers.filter(c => {
const s = stats[c.id];
if (custIsMeaningless(c)) return false; // 社名が伏字/非公開/未取得の意義のない行は出さない
if (q && !(c.company.includes(q) || c.shortName.includes(q) || (c.contact || '').includes(q))) return false;
if (activeOnly && s.active === 0) return false;
if (mineOnly && !s.mine) return false;
if (followupOnly && s.idle === 0) return false;
return true;
});
rows = rows.slice().sort((a, b) => cmp[sort.key](a, b) * (sort.dir === 'asc' ? 1 : -1));
// ページネーション（20件/ページ）。ページ番号はURL(?page=N)に反映＝詳細から戻っても同じページに戻る。検索/フィルタ/並替の変更で1ページ目へ
const PER_PAGE = 20;
const [page, setPage] = useUrlPage([q, activeOnly, mineOnly, followupOnly, sort.key, sort.dir]);
const totalPages = Math.max(1, Math.ceil(rows.length / PER_PAGE));
const safePage = Math.min(page, totalPages);
syncUrlPage(safePage);
const pageRows = rows.slice((safePage - 1) * PER_PAGE, safePage * PER_PAGE);
// 並び替えヘッダ（デスクトップ表）。矢印はテキスト＝アイコン名依存を避ける（feature-local）
const SortTh = ({ label, k, align }) => (
onSort(k)} title={t('cust.sortBy')}
style={{ cursor: 'pointer', userSelect: 'none', display: 'flex', alignItems: 'center', gap: 3, justifyContent: align === 'right' ? 'flex-end' : 'flex-start', color: sort.key === k ? '#4a5af0' : '#9aa1ab' }}>
{label}{sort.key === k ? (sort.dir === 'asc' ? '▲' : '▼') : ''}
);
// スマホ用カード（一覧をカード化＝cases/apo と同じ規約）
const renderCustomerCard = (c) => {
const s = stats[c.id];
return (
navigate('customer', c.id)}
style={{ background: '#fff', border: '1px solid #ecedf0', borderRadius: 12, padding: 14, cursor: 'pointer', boxShadow: '0 1px 2px rgba(20,22,40,.04)' }}>
{c.shortName.charAt(0)}
{c.company}
{s.idle > 0 && {t('cust.followup.badge', { d: s.idle })}}
{c.shortName}{c.industry ? ' · ' + c.industry : ''}{c.contact ? ' · ' + c.contact : ''}
{s.owner && D.user(s.owner) &&
}
{t('cust.col.cases')} {s.n}
{t('cust.col.active')} {s.active}
{s.won > 0 && {t('an.col.won')} {s.won}}
{s.lastM ? fmtDate(s.lastM, true) : '—'}
setQ(e.target.value)} placeholder={t('cust.searchPlaceholder')} style={{ border: 'none', outline: 'none', fontSize: 13, width: '100%', fontFamily: 'inherit', background: 'transparent' }} />
{/* フィルタ：進行中のみ / 自分の顧客 / 要フォロー */}
{/* スマホは並び替えをセレクトで（デスクトップは表ヘッダでソート） */}
{isMobile && (
)}
{rows.length} {t('unit.company')}{hiddenN > 0 && {t('cust.hiddenMeaningless', { n: hiddenN })}}
{isMobile ? (
{pageRows.map(c => renderCustomerCard(c))}
{rows.length === 0 &&
{t('cust.empty')}
}
{pageRows.map((c, i) => {
const s = stats[c.id];
return (
navigate('customer', c.id)}
style={{ display: 'grid', gridTemplateColumns: '1fr 132px 76px 76px 76px 112px 64px', padding: '12px 18px', alignItems: 'center', minWidth: 620,
borderBottom: i === pageRows.length - 1 ? 'none' : '1px solid #f4f5f7', cursor: 'pointer' }}>
{c.shortName.charAt(0)}
{c.company}
{s.idle > 0 && {t('cust.followup.badge', { d: s.idle })}}
{c.shortName}{c.industry ? ' · ' + c.industry : ''}
{c.contact}
{s.n}
0 ? '#4a5af0' : '#c4c9d0' }}>{s.active}
0 ? '#15803d' : '#c4c9d0' }}>{s.won}
{s.lastM ? fmtDate(s.lastM, true) : '—'}
{s.owner && D.user(s.owner) ?
: null}
);
})}
{rows.length === 0 &&
{t('cust.empty')}
}
)}
{/* ページャー（20件/ページ） */}
{totalPages > 1 && (
{t('cases.pageOf', { p: safePage, t: totalPages })} {t('cases.totalCustomers', { n: rows.length })}
)}
{openForm && setOpenForm(false)} onSaved={(id) => { setOpenForm(false); navigate('customer', id); }} />}
{openMerge && setOpenMerge(false)} />}
);
}
/* 重複顧客の統合モーダル：会社名が重複する顧客をグループ表示し、残す顧客を選んで統合。
統合＝案件を残す顧客へ付け替え＋重複を mergedInto で一覧から隠す（可逆・railway不要）。 */
function MergeDuplicatesModal({ onClose }) {
const { customers, allCustomers, cases, mergeCustomers, unmergeCustomer } = useStore();
const D = window.APP_DATA;
const groups = React.useMemo(() => findCustomerDupGroups(customers, cases), [customers, cases]);
const merged = (allCustomers || []).filter(c => c.mergedInto);
const [primarySel, setPrimarySel] = React.useState({});
const primaryOf = (g) => primarySel[g.key] || g.primaryId;
const doGroup = (g) => { const pid = primaryOf(g); mergeCustomers(pid, g.members.filter(m => m.id !== pid).map(m => m.id)); };
const doAll = () => {
if (!window.confirm(t('cust.merge.runAllConfirm', { n: groups.length }))) return;
groups.forEach(g => { const pid = primaryOf(g); mergeCustomers(pid, g.members.filter(m => m.id !== pid).map(m => m.id)); });
};
return (
{groups.length > 0 && }}>
{groups.length === 0 ? (
) : (
{t('cust.merge.foundGroups', { n: groups.length })}
{groups.map(g => {
const pid = primaryOf(g);
return (
);
})}
)}
{merged.length > 0 && (
{t('cust.merge.mergedTitle', { n: merged.length })}
{merged.map(m => {
const into = D.customer(m.mergedInto);
return (
{m.company}
{t('cust.merge.mergedInto2', { name: into ? into.company : m.mergedInto })}
);
})}
)}
);
}
/* 未登録フィールドのプレースホルダ */
function Empty() {
return {t('cust2.unregistered')};
}
function FormSection({ title, children }) {
return (
);
}
const CUSTOMER_INDUSTRIES = ['製造業', 'IT・ソフトウェア', '卸売・商社', '通信・ネットワーク', '小売・流通', '建設・不動産', '金融・保険', '医療・福祉', 'その他'];
const CUSTOMER_SIZES = ['〜50名', '50〜100名', '100〜300名', '300〜500名', '500〜1,000名', '1,000名以上'];
function CustomerFormModal({ onClose, onSaved, editCustomer, initialCompany }) {
const { addCustomer, updateCustomer } = useStore();
const isEdit = !!editCustomer;
const init = (k, d = '') => (editCustomer && editCustomer[k]) || d;
const [f, setF] = React.useState({
company: init('company', initialCompany || ''), shortName: init('shortName'), industry: init('industry'), employees: init('employees'),
founded: init('founded'), capital: init('capital'), sales: init('sales'), fiscalMonth: init('fiscalMonth'), companyOverview: init('companyOverview'),
url: init('url'), address: init('address'),
contact: init('contact'), contactDept: init('contactDept'), contactGender: init('contactGender'), contactRole: init('contactRole'), tel: init('tel'), email: init('email'), contactNote: init('contactNote'),
note: init('note'),
});
const set = (k) => (e) => setF(s => ({ ...s, [k]: e.target.value }));
const submit = () => {
if (!f.company.trim()) return;
if (isEdit) { updateCustomer(editCustomer.id, f); onSaved(editCustomer.id); }
else { const id = addCustomer(f); onSaved(id); }
};
return (
}>
);
}
function CustomerDetail() {
const { route, navigate, cases, meetings, currentUser, can } = useStore();
const isMobile = useIsMobile();
const D = window.APP_DATA;
const isAdmin = currentUser.role === 'admin';
const [openEdit, setOpenEdit] = React.useState(false);
const c = D.customer(route.id);
if (!c) return {t('cust2.notFound')}
;
const ks = cases.filter(k => k.customerId === c.id);
const cids = ks.map(k => k.id);
// 顧客サマリー（進行中・成約・失注・成約額）＋最終商談。進行中＝結案でない／成約＝isCaseWonStatus（won＋done）
const stat = { active: 0, won: 0, lost: 0, amount: 0 };
ks.forEach(k => { if (isCaseWonStatus(k.status)) { stat.won++; stat.amount += caseWonAmount(k); } else if (k.status === 'lost') stat.lost++; else stat.active++; });
const nowD = today() + 'T23:59';
const lastM = [...meetings.filter(m => cids.includes(m.caseId)).map(m => m.datetime), ...ks.flatMap(k => (k.meetingDocs || []).map(d => d.datetime)), ...ks.map(k => caseMeetingAt(k)).filter(mt => mt && mt <= nowD)].filter(Boolean).sort().slice(-1)[0] || null;
// アカウント担当（案件メイン担当の最頻・進行中2倍加重）＋放置日数（進行中案件の caseIdleInfo の最大）
const ownCnt = {};
ks.forEach(k => { if (k.ownerId) ownCnt[k.ownerId] = (ownCnt[k.ownerId] || 0) + ((isCaseWonStatus(k.status) || k.status === 'lost') ? 1 : 2); });
const acctOwner = Object.keys(ownCnt).sort((a, b) => ownCnt[b] - ownCnt[a])[0] || null;
const custIdle = ks.reduce((mx, k) => { const info = caseIdleInfo(k); return info && info.idleDays > mx ? info.idleDays : mx; }, 0);
// 案件リストは 進行中→成約→失注 の順、同順内は次回商談/更新日の新しい順
const caseRank = (k) => isCaseWonStatus(k.status) ? 1 : (k.status === 'lost' ? 2 : 0);
const ksSorted = ks.slice().sort((a, b) => caseRank(a) - caseRank(b) || String(caseMeetingAt(b) || b.updatedAt || '').localeCompare(String(caseMeetingAt(a) || a.updatedAt || '')));
// タイムライン = 商談記録 + 会議記録（Fireflies取り込み分）。同一通話の重複は商談記録を優先
const docEntries = ks.flatMap(k => (k.meetingDocs || []).map(d => ({
id: 'md-' + d.id, caseId: k.id, datetime: d.datetime, method: 'online', authorId: k.ownerId,
summary: (d.bullets && d.bullets[0]) || d.summary || t('cust2.docSummaryFallback', { title: d.title, duration: d.duration }), isDoc: true,
})));
const tl = [...meetings.filter(m => cids.includes(m.caseId)),
...docEntries.filter(d => !meetings.some(m => m.caseId === d.caseId && (m.datetime || '').slice(0, 10) === (d.datetime || '').slice(0, 10)))]
.sort((a, b) => (b.datetime || '').localeCompare(a.datetime || ''));
const methodIcon = { visit: 'mapPin', phone: 'phone', online: 'video', email: 'mail' };
return (
setOpenEdit(true)}>{t('btn.edit')} : null}>
{c.shortName.charAt(0)}
{c.company}
{c.shortName}{c.industry ? ` · ${c.industry}` : ''}{c.employees ? ` · ${c.employees}` : ''} · {t('cust2.caseCount', { n: ks.length })}{acctOwner && D.user(acctOwner) ? ` · ${t('cust.owner')} ${D.user(acctOwner).short || D.user(acctOwner).name || ''}` : ''}
{/* 放置（ご無沙汰）警告：進行中案件があるのに一定日数動きなし＝要フォロー */}
{custIdle > 0 && (
{t('cust.followup.detail', { d: custIdle })}
)}
{/* 顧客サマリーKPI（案件数・進行中・成約・失注・成約額・最終商談）。成約額と最終商談は値があるときだけ */}
{[
[t('cust.col.cases'), ks.length, '#1f2430'],
[t('cust.col.active'), stat.active, '#4a5af0'],
[t('an.col.won'), stat.won, '#15803d'],
[t('cust.stat.lost'), stat.lost, '#9aa1ab'],
...(stat.amount > 0 ? [[t('cust.stat.wonAmount'), '¥' + stat.amount.toLocaleString(), '#0f766e']] : []),
...(lastM ? [[t('cust.col.last'), fmtDate(lastM, true), '#4a5af0']] : []),
].map(([lb, val, col]) => (
))}
{c.industry || }
{c.employees || }
{c.founded && {c.founded}}
{c.capital && {c.capital}}
{c.sales && {c.sales}}
{c.fiscalMonth && {c.fiscalMonth}}
{c.url && (/^https?:\/\//.test(c.url) || /[\w-]+\.[\w-]{2,}/.test(c.url)) ? {c.url.replace(/^https?:\/\//, '')} : }
{c.address || }
{c.companyOverview &&
{t('cust2.label.companyOverview')}
{c.companyOverview}
}
{c.contact ? <>{c.contact}{c.contactDept && {c.contactDept}
} : }
{c.contactGender && {c.contactGender}}
{c.tel || }{c.contactTel ? {window.t("extra.case.directPhone")}{c.contactTel}
: null}
{c.email ? {c.email} : }
{c.contactRole && {c.contactRole}}
{c.contactNote &&
{t('cust2.label.contactNote')}
{c.contactNote}
}
{c.note && (
{c.note}
)}
{ksSorted.map((k, i) => (
navigate('case', k.id)} style={{ display: 'flex', alignItems: 'center', gap: 12, padding: '13px 18px', cursor: 'pointer', borderBottom: i === ksSorted.length - 1 ? 'none' : '1px solid #f4f5f7' }}>
{k.title}
{(() => { const mt = caseMeetingAt(k); return (mt && mt.slice(0, 10) >= today()) ? <>{t('cd.nextMeeting')} {fmtDate(mt)} · : null; })()}
{t('cust2.due')} {caseDue(k) ? {fmtDate(caseDue(k))} : '—'} · {t('cust2.updated')} {relTime(k.updatedAt)}
{k.ownerId &&
}
{tl.length > 0 &&
}
{tl.map(m => {
const k = D.caseById(m.caseId); const au = D.user(m.authorId);
return (
{fmtDateFull(m.datetime)} {fmtTime(m.datetime)}
navigate('case', m.caseId)} style={{ fontSize: 12, color: '#4a5af0', background: '#eef0fe', padding: '1px 8px', borderRadius: 5, cursor: 'pointer', fontWeight: 600 }}>{k.title}
{m.summary}
{au ? au.short + ' · ' : ''}{(D.METHODS[m.method] || {}).label || t('cust2.methodFallbackOnline')}{m.isDoc && · Fireflies}
);
})}
{tl.length === 0 &&
{t('cust2.noTimeline')}
}
{openEdit && setOpenEdit(false)} onSaved={() => setOpenEdit(false)} />}
);
}
Object.assign(window, { Customers, CustomerDetail, CustomerFormModal, FormSection, MergeDuplicatesModal, findCustomerDupGroups, custNorm });