500 lines
25 KiB
PHP
500 lines
25 KiB
PHP
@extends($layout)
|
||
@section('content')
|
||
|
||
@php
|
||
$bom = $detail['bom'] ?? [];
|
||
$columns = $detail['columns'] ?? [];
|
||
$items = $detail['items'] ?? [];
|
||
$sources = $detail['sources'] ?? [];
|
||
$hiddenColumns = $detail['hiddenColumns'] ?? [];
|
||
$imageColumns = $detail['imageColumns'] ?? [];
|
||
$fileColumns = $detail['fileColumns'] ?? [];
|
||
$bomId = (int)($bom['id'] ?? 0);
|
||
@endphp
|
||
|
||
<div class="pageheader" style="display:flex; align-items:center; justify-content:space-between; flex-wrap:wrap; gap:8px;">
|
||
<div style="display:flex; align-items:center; gap:10px;">
|
||
<div class="pageicon"><span class="fa fa-fw fa-list-check"></span></div>
|
||
<div class="pagetitle" style="margin:0;">
|
||
<h1 style="margin:0;">{{ $bom['productName'] ?? $bom['bomNo'] ?? __('menu.bom') }}</h1>
|
||
<p style="margin:0;">{{ __('text.bom_subtitle', 'BOM 明细') }} — {{ $bom['bomNo'] ?? '' }}</p>
|
||
</div>
|
||
</div>
|
||
|
||
<div style="white-space:nowrap;">
|
||
<button type="button" class="btn btn-primary" id="btnEdit"><i class="fa fa-pencil"></i> 编辑</button>
|
||
<button type="button" class="btn btn-success" id="btnSave"><i class="fa fa-save"></i> 保存</button>
|
||
|
||
{{-- 插入图片/附件 --}}
|
||
<div class="btn-group" style="position:relative;display:inline-block;">
|
||
<button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
|
||
<i class="fa fa-paperclip"></i> 插入 <span class="caret"></span>
|
||
</button>
|
||
<ul class="dropdown-menu dropdown-menu-right">
|
||
<li><a href="javascript:void(0)" id="btnInsertImage"><i class="fa fa-image"></i> 插入图片</a></li>
|
||
<li><a href="javascript:void(0)" id="btnInsertAttach"><i class="fa fa-file"></i> 插入附件</a></li>
|
||
</ul>
|
||
</div>
|
||
|
||
{{-- 一级菜单：导入导出 --}}
|
||
<div class="btn-group" style="position:relative;display:inline-block;">
|
||
<button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
|
||
<i class="fa fa-exchange"></i> 导入导出 <span class="caret"></span>
|
||
</button>
|
||
<ul class="dropdown-menu dropdown-menu-right">
|
||
<li class="dropdown-header"><i class="fa fa-cloud-download"></i> Teable 导入</li>
|
||
<li><a href="javascript:void(0)" id="btnTeableImport"><i class="fa fa-refresh"></i> 从数据源导入</a></li>
|
||
<li><a href="javascript:void(0)" id="btnTeablePaste"><i class="fa fa-paste"></i> 粘贴 API 导入</a></li>
|
||
<li><a href="javascript:void(0)" id="btnSourceManager"><i class="fa fa-database"></i> 数据源管理</a></li>
|
||
<li class="divider"></li>
|
||
<li class="dropdown-header"><i class="fa fa-upload"></i> Excel 导入</li>
|
||
<li><a href="javascript:void(0)" id="btnExcelImport"><i class="fa fa-upload"></i> 导入数据</a></li>
|
||
<li><a href="javascript:void(0)" id="btnExcelTemplate"><i class="fa fa-download"></i> 模板导出</a></li>
|
||
<li class="divider"></li>
|
||
<li class="dropdown-header"><i class="fa fa-file-export"></i> 数据导出</li>
|
||
<li><a href="javascript:void(0)" id="btnExcelExport"><i class="fa fa-file-excel-o"></i> 导出数据 (xlsx)</a></li>
|
||
<li><a href="javascript:void(0)" id="btnExcelExportCsv"><i class="fa fa-file"></i> 导出数据 (csv)</a></li>
|
||
</ul>
|
||
</div>
|
||
|
||
<button type="button" class="btn btn-default" id="btnFullscreen"><i class="fa fa-expand"></i> 全屏</button>
|
||
<a href="{{ BASE_URL }}/bom/show" class="btn btn-default"><i class="fa fa-arrow-left"></i> {{ __('links.back', '返回') }}</a>
|
||
</div>
|
||
</div>
|
||
|
||
<div class="maincontent">
|
||
<div class="maincontentinner">
|
||
|
||
<div id="bomAlert" class="alert" style="display:none;"></div>
|
||
<div id="bomError" class="alert alert-danger" style="display:none;"></div>
|
||
|
||
{{-- Univer 表格容器（动态铺满屏幕，自适应缩放） --}}
|
||
<div id="bomHot" style="width:100%;height:calc(100vh - 200px);min-height:400px;border:1px solid #e5e5e5;"></div>
|
||
|
||
</div>
|
||
</div>
|
||
|
||
{{-- Teable API 粘贴导入弹窗 --}}
|
||
<div id="teablePasteModal" style="display:none;position:fixed;top:0;left:0;right:0;bottom:0;background:rgba(0,0,0,.45);z-index:9999;overflow:auto;">
|
||
<div style="max-width:760px;margin:6% auto;background:#fff;border-radius:4px;padding:18px;">
|
||
<h4 style="margin-top:0;"><i class="fa fa-paste"></i> 粘贴 Teable API 文档</h4>
|
||
<p class="text-muted">直接粘贴整段 API 文档或 curl 命令，自动解析连接信息；解析不全时可手动补齐下方字段。</p>
|
||
<textarea id="teablePasteText" style="width:100%;height:180px;font-family:monospace;font-size:12px;" placeholder="# Table: UAGP350B curl -X GET "https://table.universal-onebot.com/api/table/tblXXX/record?fieldKeyType=name" \ -H "Authorization: Bearer teable_...""></textarea>
|
||
<div style="margin-top:10px;">
|
||
<div class="row">
|
||
<div class="col-md-12"><label style="font-size:12px;">表名/别名</label><input type="text" id="pasteName" class="form-control"></div>
|
||
</div>
|
||
<div class="row" style="margin-top:6px;">
|
||
<div class="col-md-12"><label style="font-size:12px;">Base URL</label><input type="text" id="pasteBaseUrl" class="form-control" placeholder="https://table.universal-onebot.com"></div>
|
||
</div>
|
||
<div class="row" style="margin-top:6px;">
|
||
<div class="col-md-5"><label style="font-size:12px;">Table ID</label><input type="text" id="pasteTableId" class="form-control" placeholder="tbl..."></div>
|
||
<div class="col-md-7"><label style="font-size:12px;">Token</label><input type="text" id="pasteToken" class="form-control" placeholder="teable_acc..."></div>
|
||
</div>
|
||
</div>
|
||
<div id="teableParseResult" style="display:none;margin:10px 0;padding:10px;background:#f5f5f5;border:1px solid #ddd;border-radius:4px;font-size:13px;"></div>
|
||
<div style="text-align:right;margin-top:12px;">
|
||
<button type="button" class="btn btn-default" id="btnTeableParse"><i class="fa fa-search"></i> 解析</button>
|
||
<button type="button" class="btn btn-primary" id="btnTeablePasteGo"><i class="fa fa-cloud-download"></i> 导入</button>
|
||
<button type="button" class="btn btn-default" id="btnTeablePasteClose">取消</button>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
|
||
{{-- 数据源管理弹窗 --}}
|
||
<div id="sourceManagerModal" style="display:none;position:fixed;top:0;left:0;right:0;bottom:0;background:rgba(0,0,0,.45);z-index:9999;overflow:auto;">
|
||
<div style="max-width:640px;margin:6% auto;background:#fff;border-radius:4px;padding:18px;">
|
||
<h4 style="margin-top:0;"><i class="fa fa-database"></i> Teable 数据源管理</h4>
|
||
<div id="sourceList" style="margin-bottom:10px;">
|
||
@forelse ($sources as $s)
|
||
<span class="label label-info" style="margin-right:6px;">
|
||
{{ $s['name'] ?: $s['tableId'] }}
|
||
<a href="javascript:void(0)" class="btnDelSource" data-id="{{ $s['id'] }}" style="color:#fff;">×</a>
|
||
</span>
|
||
@empty
|
||
<em class="text-muted">{{ __('text.no_sources', '未配置数据源') }}</em>
|
||
@endforelse
|
||
</div>
|
||
<div class="row">
|
||
<div class="col-md-3"><input type="text" id="srcName" class="form-control" placeholder="{{ __('label.source_name', '表名/别名') }}"></div>
|
||
<div class="col-md-3"><input type="text" id="srcBaseUrl" class="form-control" placeholder="https://table.universal-onebot.com"></div>
|
||
<div class="col-md-2"><input type="text" id="srcTableId" class="form-control" placeholder="tbl..."></div>
|
||
<div class="col-md-3"><input type="text" id="srcToken" class="form-control" placeholder="teable_acc..."></div>
|
||
<div class="col-md-1"><button type="button" class="btn btn-default" id="btnAddSource">{{ __('links.add', '添加') }}</button></div>
|
||
</div>
|
||
<div style="text-align:right;margin-top:12px;">
|
||
<button type="button" class="btn btn-default" id="btnSourceManagerClose">关闭</button>
|
||
</div>
|
||
</div>
|
||
</div>
|
||
|
||
{{-- 隐藏文件输入 --}}
|
||
<input type="file" id="excelFile" accept=".xlsx,.csv" style="display:none;">
|
||
<input type="file" id="attachFile" accept="image/*,.pdf,.doc,.docx,.xls,.xlsx,.zip,.rar,.7z,.txt,.csv" style="display:none;">
|
||
|
||
<script src="{{ BASE_URL }}/dist/js/compiled-univer-component.3.9.8.min.js"></script>
|
||
|
||
@once
|
||
@push('scripts')
|
||
<script>
|
||
jQuery(document).ready(function () {
|
||
var BOM_ID = {{ $bomId }};
|
||
var BASE = '{{ BASE_URL }}';
|
||
var FIXED = {!! json_encode(array_keys($fixedColumns)) !!};
|
||
var FIXED_LABELS = {!! json_encode($fixedColumns) !!};
|
||
var COLUMNS = {!! json_encode(array_map(function($c){ return ['key'=>$c['key'],'label'=>$c['label']]; }, $columns)) !!};
|
||
var IMAGE_COLS = {!! json_encode(array_values($imageColumns)) !!};
|
||
var FILE_COLS = {!! json_encode(array_values($fileColumns)) !!};
|
||
var RAW_ITEMS = {!! json_encode($items, JSON_UNESCAPED_UNICODE | JSON_HEX_TAG | JSON_HEX_APOS | JSON_HEX_QUOT | JSON_HEX_AMP) !!};
|
||
|
||
var ALL_KEYS = FIXED.concat(COLUMNS.map(function (c) { return c.key; }));
|
||
var csrf = function () { return jQuery('meta[name="csrf-token"]').attr('content') || ''; };
|
||
|
||
function showAlert(msg, type) {
|
||
var el = jQuery('#bomAlert');
|
||
el.attr('class', 'alert alert-' + (type || 'info')).text(msg).show();
|
||
}
|
||
function showError(msg) { jQuery('#bomError').text(msg).show(); }
|
||
|
||
function api(method, url, data, cb) {
|
||
var opts = { url: url, method: method, headers: { 'X-CSRF-TOKEN': csrf() }, dataType: 'json' };
|
||
if (data !== undefined) { opts.contentType = 'application/json'; opts.data = JSON.stringify(data); }
|
||
return jQuery.ajax(opts).done(function (res) { cb && cb(res); }).fail(function (xhr) {
|
||
var m = xhr.responseJSON && xhr.responseJSON.message ? xhr.responseJSON.message : ('HTTP ' + xhr.status);
|
||
showAlert(m, 'danger');
|
||
});
|
||
}
|
||
|
||
// 数据：附件列已在后端转成显示文本（image.png 等），直接用
|
||
var data = RAW_ITEMS.map(function (it) {
|
||
var o = { _id: it.id || null };
|
||
ALL_KEYS.forEach(function (k) { o[k] = (it[k] === undefined || it[k] === null) ? '' : it[k]; });
|
||
return o;
|
||
});
|
||
|
||
var dirtyRows = {}; // 0-based 数据行索引 -> true
|
||
|
||
// 初始化 Univer
|
||
var host = document.getElementById('bomHot');
|
||
var inst;
|
||
try {
|
||
inst = window.createOneBotSheet({
|
||
container: host,
|
||
data: data,
|
||
columns: ALL_KEYS,
|
||
fixedLabels: FIXED_LABELS,
|
||
imageColumns: IMAGE_COLS,
|
||
fileColumns: FILE_COLS,
|
||
onCellChange: function (row, col, value) {
|
||
// 全量对比方案：事件回调不做任何 data 修改（否则 data 基线被污染，对比永远相等）
|
||
// 只做行标记，供潜在 UI 提示用
|
||
if (row >= 0 && row < data.length) {
|
||
dirtyRows[row] = true;
|
||
}
|
||
},
|
||
onCellClick: function (row, col) {
|
||
handleAttachmentClick(row, col);
|
||
}
|
||
});
|
||
} catch (e) {
|
||
showError('Univer 初始化失败: ' + e.message);
|
||
return;
|
||
}
|
||
|
||
var sheet = inst.sheet;
|
||
|
||
// 读取某 sheet 行（0-based 数据行索引）为 payload
|
||
function buildPayload(dataRowIndex) {
|
||
var payload = {};
|
||
ALL_KEYS.forEach(function (k, c) {
|
||
var v = sheet.getRange(dataRowIndex + 1, c).getDisplayValue();
|
||
payload[k] = (v === undefined || v === null) ? '' : String(v);
|
||
});
|
||
return payload;
|
||
}
|
||
|
||
function saveRow(dataRowIndex) {
|
||
var payload = buildPayload(dataRowIndex);
|
||
// 已有 data 条目（有 _id）则更新，否则新建
|
||
if (data[dataRowIndex] && data[dataRowIndex]._id) {
|
||
payload.itemId = data[dataRowIndex]._id;
|
||
}
|
||
api('POST', BASE + '/bom/api/' + BOM_ID + '/item', payload, function (res) {
|
||
if (res.itemId && (!data[dataRowIndex] || !data[dataRowIndex]._id)) {
|
||
if (!data[dataRowIndex]) { data[dataRowIndex] = {}; }
|
||
data[dataRowIndex]._id = res.itemId;
|
||
}
|
||
});
|
||
}
|
||
|
||
// 判断某 sheet 行是否有任何非空值
|
||
function rowHasValue(dataRowIndex) {
|
||
for (var c = 0; c < ALL_KEYS.length; c++) {
|
||
var v = sheet.getRange(dataRowIndex + 1, c).getDisplayValue();
|
||
if (v !== undefined && v !== null && String(v).trim() !== '') { return true; }
|
||
}
|
||
return false;
|
||
}
|
||
|
||
// 编辑 / 保存
|
||
jQuery('#btnEdit').on('click', function () {
|
||
showAlert('表格已解锁，可编辑数据；完成后点「保存」提交', 'info');
|
||
});
|
||
jQuery('#btnSave').on('click', function () {
|
||
// 先结束编辑态，让编辑器把值提交进 sheet
|
||
var endPromise = (inst.endEditing && typeof inst.endEditing === 'function')
|
||
? inst.endEditing().catch(function () { return true; })
|
||
: Promise.resolve(true);
|
||
|
||
endPromise.then(function () {
|
||
setTimeout(function () {
|
||
// 遍历 sheet 实际数据行（非 data 数组），空表/新行都能保存
|
||
// 注意：FWorksheet facade 没有 getRowCount()，必须用 inst.getRowCount()（内部走 getMaxRows）
|
||
var sheetRowCount = inst.getRowCount ? inst.getRowCount() : 0;
|
||
var saved = 0;
|
||
for (var r = 0; r < sheetRowCount - 1; r++) {
|
||
if (rowHasValue(r)) { saveRow(r); saved++; }
|
||
}
|
||
if (saved > 0) {
|
||
showAlert('已保存 ' + saved + ' 行', 'success');
|
||
} else {
|
||
showAlert('没有需要保存的改动', 'info');
|
||
}
|
||
}, 500);
|
||
});
|
||
});
|
||
|
||
// ---- 全屏切换 ----
|
||
jQuery('#btnFullscreen').on('click', function () {
|
||
var el = document.getElementById('bomHot');
|
||
if (document.fullscreenElement) {
|
||
document.exitFullscreen();
|
||
} else if (el.requestFullscreen) {
|
||
el.requestFullscreen();
|
||
}
|
||
});
|
||
document.addEventListener('fullscreenchange', function () {
|
||
var btn = jQuery('#btnFullscreen');
|
||
if (document.fullscreenElement) {
|
||
btn.html('<i class="fa fa-compress"></i> 退出全屏');
|
||
} else {
|
||
btn.html('<i class="fa fa-expand"></i> 全屏');
|
||
}
|
||
});
|
||
|
||
// ---- 表格自适应布满屏幕 ----
|
||
function resizeBomHot() {
|
||
var host = document.getElementById('bomHot');
|
||
if (!host) { return; }
|
||
// 非全屏时：高度 = 视口高 - 顶部工具栏约 200px；全屏时铺满
|
||
if (document.fullscreenElement === host) {
|
||
host.style.height = '100vh';
|
||
host.style.width = '100vw';
|
||
} else {
|
||
host.style.height = 'calc(100vh - 200px)';
|
||
host.style.width = '100%';
|
||
}
|
||
// 容器尺寸变化后，让表格缩放适配宽度
|
||
if (inst && typeof inst.fitToContainer === 'function') {
|
||
setTimeout(function () { inst.fitToContainer(); }, 50);
|
||
}
|
||
}
|
||
jQuery(window).on('resize', resizeBomHot);
|
||
resizeBomHot();
|
||
|
||
// ---- 插入图片/附件（上传到 /bom/api/{id}/attachment，图片插浮动缩略图，附件写单元格链接） ----
|
||
var attachKind = 'image'; // 'image' | 'file'
|
||
function doInsertAttach() {
|
||
var cell = inst.getActiveCell ? inst.getActiveCell() : null;
|
||
var row = cell ? cell.getRow() : 0;
|
||
var col = cell ? cell.getColumn() : 0;
|
||
// 表头行（第 0 行）不允许插附件，回退到第一数据行
|
||
if (row < 1) { row = 1; }
|
||
jQuery('#attachFile').off('change').on('change', function () {
|
||
var file = this.files[0];
|
||
if (!file) { return; }
|
||
var fd = new FormData();
|
||
fd.append('file', file);
|
||
jQuery.ajax({
|
||
url: BASE + '/bom/api/' + BOM_ID + '/attachment',
|
||
method: 'POST',
|
||
headers: { 'X-CSRF-TOKEN': csrf() },
|
||
data: fd, processData: false, contentType: false, dataType: 'json'
|
||
}).done(function (res) {
|
||
var d = (res && res.data) || {};
|
||
if (!d.url) { showAlert('上传失败：未返回地址', 'danger'); return; }
|
||
var isImage = (attachKind === 'image' && d.image);
|
||
// 图片：插入浮动缩略图
|
||
if (isImage) {
|
||
try { inst.insertImageAt(row, col, d.url, 'URL', 0); } catch (e) {}
|
||
}
|
||
// 持久化：把 {url,name,image} 追加到当前单元格的附件 JSON 数组，并保存（刷新后可重渲染，避免黑圈/丢失）
|
||
var existing = [];
|
||
try {
|
||
var cur = sheet.getRange(row, col).getDisplayValue();
|
||
if (cur) { existing = JSON.parse(cur); }
|
||
} catch (e) { existing = []; }
|
||
if (!Array.isArray(existing)) { existing = []; }
|
||
existing.push({ url: d.url, name: d.name, image: isImage });
|
||
try { sheet.getRange(row, col).setValue(JSON.stringify(existing)); } catch (e) {}
|
||
saveRow(row - 1);
|
||
showAlert((isImage ? '图片' : '附件') + '已插入并保存：' + d.name, 'success');
|
||
}).fail(function (xhr) {
|
||
var m = xhr.responseJSON && xhr.responseJSON.message ? xhr.responseJSON.message : ('HTTP ' + xhr.status);
|
||
showAlert(m, 'danger');
|
||
});
|
||
jQuery(this).val('');
|
||
});
|
||
jQuery('#attachFile').click();
|
||
}
|
||
jQuery('#btnInsertImage').on('click', function () { attachKind = 'image'; doInsertAttach(); });
|
||
jQuery('#btnInsertAttach').on('click', function () { attachKind = 'file'; doInsertAttach(); });
|
||
|
||
// ---- 附件点击：PDF 弹窗预览，图片新窗口放大，其它下载 ----
|
||
function isExt(url, exts) {
|
||
var m = /\.([a-zA-Z0-9]+)(?:[?#].*)?$/.exec((url || '').split('?')[0]);
|
||
if (!m) { return false; }
|
||
return exts.indexOf(m[1].toLowerCase()) >= 0;
|
||
}
|
||
function handleAttachmentClick(row, col) {
|
||
// row 是 0-based sheet 行号；第 0 行表头不处理
|
||
if (row < 1 || col < 0 || col >= ALL_KEYS.length) { return; }
|
||
var key = ALL_KEYS[col];
|
||
var isFileCol = FILE_COLS.indexOf(key) >= 0;
|
||
var isImageCol = IMAGE_COLS.indexOf(key) >= 0;
|
||
if (!isFileCol && !isImageCol) { return; }
|
||
|
||
var v = null;
|
||
try { v = sheet.getRange(row, col).getDisplayValue(); } catch (e) {}
|
||
if (!v || typeof v !== 'string') { return; }
|
||
|
||
var arr = null;
|
||
try { arr = JSON.parse(v); } catch (e) { arr = null; }
|
||
if (!Array.isArray(arr) || arr.length === 0) {
|
||
// 单元格直接存了 URL 文本（插入附件写入的「名称 + URL」）
|
||
var mUrl = /https?:\/\/[^\s]+/.exec(v);
|
||
if (mUrl) { arr = [{ url: mUrl[0], name: v.replace(mUrl[0], '').trim() || '附件' }]; }
|
||
else { return; }
|
||
}
|
||
|
||
var item = arr[0];
|
||
var url = item && item.url;
|
||
if (!url) { return; }
|
||
var name = item.name || '附件';
|
||
|
||
if (isExt(url, ['pdf'])) {
|
||
// PDF 弹窗预览
|
||
if (window.__onebotOpenPdf) { window.__onebotOpenPdf(url, name); }
|
||
else { window.open(url, '_blank'); }
|
||
} else if (isImageCol || /^image\//i.test(item.mime || '') || isExt(url, ['png', 'jpg', 'jpeg', 'gif', 'webp', 'bmp'])) {
|
||
// 图片：新窗口放大查看
|
||
window.open(url, '_blank');
|
||
} else {
|
||
// 其它附件：触发下载
|
||
var a = document.createElement('a');
|
||
a.href = url;
|
||
a.download = name || '';
|
||
a.target = '_blank';
|
||
document.body.appendChild(a);
|
||
a.click();
|
||
document.body.removeChild(a);
|
||
}
|
||
}
|
||
|
||
// ---- Teable 源管理 ----
|
||
jQuery('#btnSourceManager').on('click', function () { jQuery('#sourceManagerModal').show(); });
|
||
jQuery('#btnSourceManagerClose').on('click', function () { jQuery('#sourceManagerModal').hide(); });
|
||
jQuery('#btnAddSource').on('click', function () {
|
||
api('POST', BASE + '/bom/api/' + BOM_ID + '/source', {
|
||
name: jQuery('#srcName').val(),
|
||
baseUrl: jQuery('#srcBaseUrl').val(),
|
||
tableId: jQuery('#srcTableId').val(),
|
||
token: jQuery('#srcToken').val()
|
||
}, function () { location.reload(); });
|
||
});
|
||
jQuery('#sourceList').on('click', '.btnDelSource', function () {
|
||
if (!confirm("{{ __('text.confirm_delete') }}")) { return; }
|
||
api('DELETE', BASE + '/bom/api/source/' + jQuery(this).data('id'), null, function () { location.reload(); });
|
||
});
|
||
|
||
// ---- Teable 从数据源导入 ----
|
||
jQuery('#btnTeableImport').on('click', function () {
|
||
if (!confirm("{{ __('text.teable_import_confirm', '从 Teable 拉取最新数据并导入为明细？') }}")) { return; }
|
||
api('POST', BASE + '/bom/api/' + BOM_ID + '/import/teable', {}, function (res) {
|
||
showAlert("{{ __('text.imported', '已导入') }} " + (res.imported || 0) + " {{ __('label.rows', '行') }}", 'success');
|
||
setTimeout(function () { location.reload(); }, 800);
|
||
});
|
||
});
|
||
|
||
// ---- Teable API 粘贴导入 ----
|
||
jQuery('#btnTeablePaste').on('click', function () {
|
||
jQuery('#teablePasteText').val('');
|
||
jQuery('#pasteName').val(''); jQuery('#pasteBaseUrl').val(''); jQuery('#pasteTableId').val(''); jQuery('#pasteToken').val('');
|
||
jQuery('#teableParseResult').hide().empty();
|
||
jQuery('#teablePasteModal').show();
|
||
jQuery('#teablePasteText').trigger('focus');
|
||
});
|
||
jQuery('#btnTeablePasteClose').on('click', function () { jQuery('#teablePasteModal').hide(); });
|
||
|
||
jQuery('#btnTeableParse').on('click', function () {
|
||
var text = jQuery('#teablePasteText').val();
|
||
jQuery('#btnTeableParse').prop('disabled', true);
|
||
api('POST', BASE + '/bom/api/teable/parse', { text: text }, function (res) {
|
||
var d = res.data || {};
|
||
if (d.baseUrl) { jQuery('#pasteBaseUrl').val(d.baseUrl); }
|
||
if (d.tableId) { jQuery('#pasteTableId').val(d.tableId); }
|
||
if (d.token) { jQuery('#pasteToken').val(d.token); }
|
||
if (d.name) { jQuery('#pasteName').val(d.name); }
|
||
jQuery('#teableParseResult').html('<strong>解析完成</strong>，已回填到上方输入框，可手动修改后导入。').show();
|
||
}).always(function () { jQuery('#btnTeableParse').prop('disabled', false); });
|
||
});
|
||
|
||
jQuery('#btnTeablePasteGo').on('click', function () {
|
||
var baseUrl = jQuery('#pasteBaseUrl').val().trim();
|
||
var tableId = jQuery('#pasteTableId').val().trim();
|
||
var token = jQuery('#pasteToken').val().trim();
|
||
var name = jQuery('#pasteName').val().trim();
|
||
if (!baseUrl || !tableId || !token) { showAlert('请先点「解析」，或手动填写 Base URL / Table ID / Token', 'warning'); return; }
|
||
var text = jQuery('#teablePasteText').val() ||
|
||
('# Table: ' + (name || tableId) + '\n' +
|
||
'curl "' + baseUrl + '/api/table/' + tableId + '/record?fieldKeyType=name" \\\n' +
|
||
' -H "Authorization: Bearer ' + token + '"');
|
||
jQuery('#btnTeablePasteGo').prop('disabled', true);
|
||
api('POST', BASE + '/bom/api/' + BOM_ID + '/import/teable-paste', { text: text }, function (res) {
|
||
jQuery('#teablePasteModal').hide();
|
||
showAlert('已导入 ' + (res.imported || 0) + ' 行', 'success');
|
||
setTimeout(function () { location.reload(); }, 800);
|
||
}).always(function () { jQuery('#btnTeablePasteGo').prop('disabled', false); });
|
||
});
|
||
|
||
// ---- Excel ----
|
||
jQuery('#btnExcelTemplate').on('click', function () { window.location.href = BASE + '/bom/api/' + BOM_ID + '/export-template'; });
|
||
jQuery('#btnExcelImport').on('click', function () { jQuery('#excelFile').click(); });
|
||
jQuery('#excelFile').on('change', function () {
|
||
var file = this.files[0];
|
||
if (!file) { return; }
|
||
var fd = new FormData();
|
||
fd.append('file', file);
|
||
jQuery.ajax({
|
||
url: BASE + '/bom/api/' + BOM_ID + '/import/excel',
|
||
method: 'POST',
|
||
headers: { 'X-CSRF-TOKEN': csrf() },
|
||
data: fd, processData: false, contentType: false, dataType: 'json'
|
||
}).done(function (res) {
|
||
showAlert("{{ __('text.imported', '已导入') }} " + (res.imported || 0) + " {{ __('label.rows', '行') }}", 'success');
|
||
setTimeout(function () { location.reload(); }, 800);
|
||
}).fail(function (xhr) {
|
||
var m = xhr.responseJSON && xhr.responseJSON.message ? xhr.responseJSON.message : ('HTTP ' + xhr.status);
|
||
showAlert(m, 'danger');
|
||
});
|
||
jQuery(this).val('');
|
||
});
|
||
jQuery('#btnExcelExport').on('click', function () { window.location.href = BASE + '/bom/api/' + BOM_ID + '/export?format=xlsx'; });
|
||
jQuery('#btnExcelExportCsv').on('click', function () { window.location.href = BASE + '/bom/api/' + BOM_ID + '/export?format=csv'; });
|
||
});
|
||
</script>
|
||
@endpush
|
||
@endonce
|
||
|
||
@endsection
|