财务核算核销系统的快速开发落地使用;物流、电商、等行业均可适用。
需求:
数据自动上传程序解析原理:自动搜索文件夹下面的子文件夹和对应的文件.
匹配:交易报告,移除订单,仓储费,库存分类账,入库配置服务费用,广告活动xlsx或者csv文件.
自动匹配规则(店铺后台导出的表格文件无需任何手动加工或者处理,
程序自动识别数据开始的位置并且进行读取)获取xlsx和csv的数据.\n对数据特征进行唯一哈希指纹处理确保数据重复导入不会重复。
提供系统可查看,筛选,下载到本地。
目标:解放财务人员手动复制粘贴各个店铺的数据,并且手工纯在操作失误的情况。从而改为机器全自动化操作。
实际开发周期:3天 一个人。
----->实现步骤:
模型包:

数据模型总揽:

交易报告为eg:

生成系统的代码:
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=edge"/>
<title>交易报告</title>
<meta name="description" content="交易报告"/>
<meta name="keywords" content="index"/>
<meta name="viewport" content="width=device-width, initial-scale=1"/>
<meta name="renderer" content="webkit"/>
<link rel="icon" type="image/png" href="assets/i/favicon.png"/>
<link rel="apple-touch-icon-precomposed" href="assets/i/app-icon72x72@2x.png"/>
<meta name="apple-mobile-web-app-title" content="sassos"/>
<link rel="stylesheet" href="assets/css/amazeui.min.css?v=20250710160615"/>
<link rel="stylesheet" href="assets/css/admin.css?v=20250710160615"/>
<link rel="stylesheet" href="assets/css/app.css?v=20250710160615"/>
<script type="text/javascript" src="assets/js/jquery-2.1.1.js"></script>
<script type="text/javascript" src="../js/jquery-1.8.0.js"></script>
<link rel="stylesheet" type="text/css" href="../js/asyncbox/skins/ZCMS/asyncbox.css"/>
<script type="text/javascript" src="../js/asyncbox/AsyncBox.v1.4.5.js?v=20250710160615"></script>
<link href="../script/validationEngine/css/validationEngine.jquery.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="../script/validationEngine/languages/jquery.validationEngine-zh_CN.js?v=js7a036713a9f043cfb55dafb1626f0efa"></script>
<script type="text/javascript" src="../script/validationEngine/jquery.validationEngine.js?v=js7a036713a9f043cfb55dafb1626f0efa"></script>
<script type="text/javascript" src="../script/ajax_upload_xls.js?v=20250710160615"></script>
<script type="text/javascript" src="../script/fileup_portal.js?v=20250710160615"></script>
<script type="text/javascript" src="assets/home.js?v=20250710160615"></script>
<link href="../css/chosen/chosen.min.xls.css" rel="stylesheet"/>
<script src="../css/chosen/chosen.jquery.js"></script>
</head>
<body>
<header class="am-topbar am-topbar-inverse admin-header">
<div class="am-topbar-brand">
<h2 style="font-size:20px;"><img id="imglogo" class="headerlogo" src="assets/img/logonew.png"/>SaSSOA</h2>
</div>
<div class="am-collapse am-topbar-collapse" id="topbar-collapse">
<ul class="lineslideUp am-dropdown" data-am-dropdown data-am-dropdown-toggle></ul>
<ul class="am-nav am-nav-pills am-topbar-nav am-topbar-left admin-header-list tpl-header-list" id="ul_menu_top_head">
</ul>
<ul class="am-nav am-nav-pills am-topbar-nav am-topbar-right admin-header-list tpl-header-list">
<li class="am-dropdown" data-am-dropdown data-am-dropdown-toggle>
<a class="am-dropdown-toggle tpl-header-list-link" href="javascript:">
<span class="am-icon-bell-o"></span>待办任务 <span class="am-badge tpl-badge-danger am-round todocount">0</span>
</a>
<ul class="am-dropdown-content tpl-dropdown-content" id="divtodolist">
<li class="tpl-dropdown-content-external">
<h3>你有 <span class="tpl-color-danger todocount">0</span> 待办</h3>
<a target="_blank" href="todo.html">查看全部</a>
</li>
</ul>
</li>
<li class="am-dropdown" data-am-dropdown data-am-dropdown-toggle>
<a class="am-dropdown-toggle tpl-header-list-link" href="javascript:">
<span class="am-icon-comment-o"></span>待阅 <span class="am-badge tpl-badge-success am-round readcount">0</span>
</a>
<ul class="am-dropdown-content tpl-dropdown-content" id="divtoreadlist">
<li class="tpl-dropdown-content-external">
<h3>你有 <span class="tpl-color-success readcount">0</span> 条待阅</h3>
<a target="_blank" href="toview.html">查看全部</a>
</li>
</ul>
</li>
<li class="am-dropdown" data-am-dropdown data-am-dropdown-toggle>
<a class="am-dropdown-toggle tpl-header-list-link" href="javascript:">
<span class="tpl-header-list-user-nick"></span>
<span class="tpl-header-list-user-ico">
<img src="assets/img/user01.png" style="width: 24px;height: 24px;"/>
</span>
</a>
<ul class="am-dropdown-content">
<li><a class="personinfo" style="cursor:pointer"><span class="am-icon-user"></span> 个人信息 </a></li>
<li><a class="settinginfo" style="cursor:pointer"><span class="am-icon-cog am-icon-spin"></span> 个人设置 </a></li>
<li><a id="labloginout" style="cursor:pointer;"><span class="am-icon-power-off"></span> 退出登录</a></li>
</ul>
</li>
</ul>
</div>
</header>
<div class="tpl-page-container tpl-page-header-fixed">
<div class="tpl-content-wrapper">
<script type="text/javascript" src="../script/My97DatePicker/WdatePicker.js"></script>
<!--ProjectEditor-->
<div class="tpl-portlet-components" id="divone" style="display:none;">
<div class="portlet-title">
<div class="caption font-green bold">
<span class="am-icon-code"></span> 编辑
</div>
</div>
<div class="tpl-block">
<div class="am-g tpl-amazeui-form">
<div class="am-u-sm-12 am-u-md-12">
<form class="am-form am-form-horizontal">
<div class="am-form-group">
<div class="am-u-sm-1 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">店铺</label>
<input myt="txt" class="validate[maxSize[30],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="shop_code" type="text" />
</div> <div class="am-u-sm-4 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">datetime</label>
<input myt="txt" class="validate[maxSize[128],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="datetime" type="text" /></div> <div class="am-u-sm-1 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">settlementid</label>
<input myt="txt" class="validate[maxSize[30],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="settlementid" type="text" />
</div> <div class="am-u-sm-4 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">type</label>
<input myt="txt" class="validate[maxSize[124],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="type" type="text" /></div> <div class="am-u-sm-2"></div>
</div>
<div class="am-form-group">
<div class="am-u-sm-4 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">orderid</label>
<input myt="txt" class="validate[maxSize[136],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="orderid" type="text" /></div> <div class="am-u-sm-4 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">sku</label>
<input myt="txt" class="validate[maxSize[121],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="sku" type="text" /></div> <div class="am-u-sm-4 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">description</label>
<input myt="txt" class="validate[maxSize[500],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="description" type="text" /></div>
</div>
<div class="am-form-group">
<div class="am-u-sm-1 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">quantity</label>
<input myt="txt" class="validate[custom[integer]] sassoa_portal_list_edit_detail_per_input_obj" id="quantity" type="text" />
</div> <div class="am-u-sm-4 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">marketplace</label>
<input myt="txt" class="validate[maxSize[220],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="marketplace" type="text" /></div> <div class="am-u-sm-4 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">accounttype</label>
<input myt="txt" class="validate[maxSize[300],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="accounttype" type="text" /></div> <div class="am-u-sm-1 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">fulfillment</label>
<input myt="txt" class="validate[maxSize[50],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="fulfillment" type="text" />
</div> <div class="am-u-sm-2"></div>
</div>
<div class="am-form-group">
<div class="am-u-sm-4 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">ordercity</label>
<input myt="txt" class="validate[maxSize[222],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="ordercity" type="text" /></div> <div class="am-u-sm-4 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">orderstate</label>
<input myt="txt" class="validate[maxSize[200],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="orderstate" type="text" /></div> <div class="am-u-sm-2 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">orderpostal</label>
<input myt="txt" class="validate[maxSize[100],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="orderpostal" type="text" /></div> <div class="am-u-sm-2"></div>
</div>
<div class="am-form-group">
<div class="am-u-sm-4 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">taxcollectionmodel</label>
<input myt="txt" class="validate[maxSize[222],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="taxcollectionmodel" type="text" /></div> <div class="am-u-sm-2 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">productsales</label>
<input myt="txt" class="validate[maxSize[100],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="productsales" type="text" /></div> <div class="am-u-sm-2 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">productsalestax</label>
<input myt="txt" class="validate[maxSize[100],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="productsalestax" type="text" /></div> <div class="am-u-sm-4 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">shippingcredits</label>
<input myt="txt" class="validate[maxSize[110],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="shippingcredits" type="text" /></div>
</div>
<div class="am-form-group">
<div class="am-u-sm-4 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">shippingcreditstax</label>
<input myt="txt" class="validate[maxSize[110],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="shippingcreditstax" type="text" /></div> <div class="am-u-sm-1 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">giftwrapcredits</label>
<input myt="txt" class="validate[custom[integer]] sassoa_portal_list_edit_detail_per_input_obj" id="giftwrapcredits" type="text" />
</div> <div class="am-u-sm-1 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">giftwrapcreditstax</label>
<input myt="txt" class="validate[custom[integer]] sassoa_portal_list_edit_detail_per_input_obj" id="giftwrapcreditstax" type="text" />
</div> <div class="am-u-sm-1 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">RegulatoryFee</label>
<input myt="txt" class="validate[custom[integer]] sassoa_portal_list_edit_detail_per_input_obj" id="regulatoryfee" type="text" />
</div> <div class="am-u-sm-1 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">TaxOnRegulatoryFee</label>
<input myt="txt" class="validate[custom[integer]] sassoa_portal_list_edit_detail_per_input_obj" id="taxonregulatoryfee" type="text" />
</div> <div class="am-u-sm-4 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">promotionalrebates</label>
<input myt="txt" class="validate[maxSize[110],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="promotionalrebates" type="text" /></div>
</div>
<div class="am-form-group">
<div class="am-u-sm-1 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">promotionalrebatestax</label>
<input myt="txt" class="validate[custom[integer]] sassoa_portal_list_edit_detail_per_input_obj" id="promotionalrebatestax" type="text" />
</div> <div class="am-u-sm-4 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">marketplacewithheldtax</label>
<input myt="txt" class="validate[maxSize[110],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="marketplacewithheldtax" type="text" /></div> <div class="am-u-sm-4 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">sellingfees</label>
<input myt="txt" class="validate[maxSize[110],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="sellingfees" type="text" /></div> <div class="am-u-sm-3"></div>
</div>
<div class="am-form-group">
<div class="am-u-sm-4 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">fbafees</label>
<input myt="txt" class="validate[maxSize[110],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="fbafees" type="text" /></div> <div class="am-u-sm-4 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">othertransactionfees</label>
<input myt="txt" class="validate[maxSize[110],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="othertransactionfees" type="text" /></div> <div class="am-u-sm-4 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">other</label>
<input myt="txt" class="validate[maxSize[200],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="other" type="text" /></div>
</div>
<div class="am-form-group">
<div class="am-u-sm-4 sassoa_portal_list_edit_detail_per_panel_hover">
<label class="am-form-label">total</label>
<input myt="txt" class="validate[maxSize[200],custom[noSpecialCaracters]] sassoa_portal_list_edit_detail_per_input_obj" id="total" type="text" /></div> <div class="am-u-sm-8"></div>
</div>
</form>
</div>
</div>
</div>
<div class="div_btn_save_cancel_location_in_edit">
<button onclick="cancel()" type="button" class="am-btn am-btn-cancel btn_control_location_area btn_edit_cancel_button"><i class="am-icon-undo"></i> Undo</button>
<button onclick="reload_data_in_click_one_item()" type="button" class="am-btn am-btn-primary btn_control_location_area btn_edit_reload_button"><i class="am-icon-refresh"></i> Reload</button>
<button onclick="save()" type="button" class="am-btn am-btn-warning btn_control_location_area btn_edit_save_button"><i class="am-icon-save"></i> Save</button>
</div>
</div>
<!--ProjectList-->
<div class="tpl-portlet-components" id="divlist">
<div class="portlet-title">
<div class="caption font-green bold fsbpm_user_other_title_or_desc_info_style">
<span class="am-icon-wpforms"></span> 交易报告
</div>
<div class="tpl-portlet-input tpl-fz-ml">
<img name="fileup" src="../images/upload_data_from_xls.png" style="width:32px;height:32px;cursor:pointer;" alt="import xlsx files" class="btn_import_xlsx_file_portal_list_head" />
<img src="../images/adddata.png" style="width:26px;height:26px;cursor:pointer;" alt="add new data" onclick="newsinki()" class="btn_add_new_data_portal_list_head" />
<div class="portlet-input input-small input-inline">
<div class="input-icon right">
<i class="am-icon-search"></i>
<input type="text" class="form-control form-control-solid fsbpmserachcontrol" myts="txt" mykey="shop_code" mycalc="like" placeholder="关键字..." />
</div>
</div>
</div>
</div>
<div class="div_search_condition">
店铺:<input type="text" class="fsbpmserachcontrol search_txt" myts="txt" mykey="shop_code" mycalc="equals" placeholder="equals" />
结算ID:<input type="text" class="fsbpmserachcontrol search_txt" myts="txt" mykey="settlementid" mycalc="equals" placeholder="equals" />
订单ID:<input type="text" class="fsbpmserachcontrol search_txt" myts="txt" mykey="orderid" mycalc="equals" placeholder="equals" />
SKU:<input type="text" class="fsbpmserachcontrol search_txt" myts="txt" mykey="sku" mycalc="equals" placeholder="equals" />
数据上传时间:<input type="text" class="fsbpmserachcontrol search_txt" myts="txt" mykey="create_time" mycalc="big_than" onClick="WdatePicker()" placeholder="from"/>
~<input type="text" class="fsbpmserachcontrol search_txt" myts="txt" mykey="create_time" mycalc="less_than" onClick="WdatePicker()" placeholder="to"/>
<button onclick='get_portal_data_list()' type='button' class='am-btn am-btn-xs am-btn-primary btn_control_location_area btn_get_portal_data_list'><i class='am-icon-search'></i> Search</button>
</div>
<div class="tpl-block">
<div class="am-g">
<div class="am-u-sm-12">
<form id="form_data_list_view" class="am-form" onsubmit="return false;">
<table id="table_data_list_view" class="am-table am-table-hover table-main">
<thead style="font-size:1.1rem;">
<tr>
<th class="table-id">NO</th>
<th class="table-title">店铺</th>
<th class="table-date am-hide-sm-only bind_header_columns_x_datetime">datetime</th>
<th class="table-date am-hide-sm-only bind_header_columns_x_settlementid">settlementid</th>
<th class="table-date am-hide-sm-only bind_header_columns_x_type">type</th>
<th class="table-date am-hide-sm-only bind_header_columns_x_orderid">orderid</th>
<th class="table-date am-hide-sm-only bind_header_columns_x_sku">sku</th>
<th class="table-date am-hide-sm-only bind_header_columns_x_sellingfees">sellingfees</th>
<th class="table-date am-hide-sm-only bind_header_columns_x_fbafees">fbafees</th>
<th class="table-date am-hide-sm-only bind_header_columns_x_total">total</th>
<th class="table-date am-hide-sm-only bind_header_columns_x_create_time">创建时间</th>
<th class="table-date am-hide-sm-only bind_header_columns_x_create_by">创建人</th>
<th class="table-set sass_oa_portal_list_data_right_table_set">ACTION</th>
</tr>
</thead>
<tbody id="listprodata">
</tbody>
</table>
<div class="am-cf sassoa_portal_list_ul_calc_page_etc_class">
<div class="am-fr">
<ul class="am-pagination tpl-pagination" id="ulcalcpage">
</ul>
</div>
</div>
</form>
</div>
</div>
</div>
<!-- 底部20250616 导入xls -->
<div class="div_bottom_control_location_area" align="left" style="text-align: left;width: 60%;font-size: 13px;display: none;" id="div_notes_for_all">
<div style="text-align: right">
<button id="btn_cont_close" type="button" class="am-btn am-btn-sm am-btn-primary am-round">Close</button>
</div>
<div id="div_op">
操作说明: 请先填写店铺名称,比如:A49。<input type="text" id="shop_name" placeholder="比如:A49" class="am-form-field am-round" style="width: 200px;background-color: white;text-align: center;">
<br/>
点击上传文件之前请删除交易报告文件的第1行到第7行的描述文字。
<br/>
点击图标,上传xlsx文件。
<img name="fileup" src="../images/upload_data_from_xls.png" style="width:64px;height:62px;cursor:pointer;" alt="import xlsx files" class="btn_import_xlsx_file_portal_list_head_new_1"/>
</div>
</div>
<script>
$(".btn_import_xlsx_file_portal_list_head").hover(function () {
$("#div_notes_for_all").show();
});
$("#btn_cont_close").click(function () {
$("#div_notes_for_all").hide();
});
</script>
<!-- 底部20250616 -->
</div>
<script type="text/javascript">
var tableid = "xxxxxxxxxxxxxxxxxxxxxxxx";
var size = 20, cindex = 0, isview = 1, isdel = 1, isedt=1;
var sort = "";
//QueryListField
var arrs = [];
//InterfaceInputField
var allkey = [];
arrs.push("shop_code");
arrs.push("datetime");
arrs.push("settlementid");
arrs.push("type");
arrs.push("orderid");
arrs.push("sku");
arrs.push("sellingfees");
arrs.push("fbafees");
arrs.push("total");
arrs.push("create_time");
arrs.push("create_by");
allkey.push({ "key": "shop_code", "val": "" });
allkey.push({ "key": "datetime", "val": "" });
allkey.push({ "key": "settlementid", "val": "" });
allkey.push({ "key": "type", "val": "" });
allkey.push({ "key": "orderid", "val": "" });
allkey.push({ "key": "sku", "val": "" });
allkey.push({ "key": "description", "val": "" });
allkey.push({ "key": "quantity", "val": "" });
allkey.push({ "key": "marketplace", "val": "" });
allkey.push({ "key": "accounttype", "val": "" });
allkey.push({ "key": "fulfillment", "val": "" });
allkey.push({ "key": "ordercity", "val": "" });
allkey.push({ "key": "orderstate", "val": "" });
allkey.push({ "key": "orderpostal", "val": "" });
allkey.push({ "key": "taxcollectionmodel", "val": "" });
allkey.push({ "key": "productsales", "val": "" });
allkey.push({ "key": "productsalestax", "val": "" });
allkey.push({ "key": "shippingcredits", "val": "" });
allkey.push({ "key": "shippingcreditstax", "val": "" });
allkey.push({ "key": "giftwrapcredits", "val": "" });
allkey.push({ "key": "giftwrapcreditstax", "val": "" });
allkey.push({ "key": "regulatoryfee", "val": "" });
allkey.push({ "key": "taxonregulatoryfee", "val": "" });
allkey.push({ "key": "promotionalrebates", "val": "" });
allkey.push({ "key": "promotionalrebatestax", "val": "" });
allkey.push({ "key": "marketplacewithheldtax", "val": "" });
allkey.push({ "key": "sellingfees", "val": "" });
allkey.push({ "key": "fbafees", "val": "" });
allkey.push({ "key": "othertransactionfees", "val": "" });
allkey.push({ "key": "other", "val": "" });
allkey.push({ "key": "total", "val": "" });
</script>
<script type="text/javascript" src="assets/xls.js?v=20250710160615"></script>
<script type="text/javascript">
//-- 列表数据加载完成后的调用void
// function get_portal_data_list_done_back() {
//
// }
//-- 列表编辑前调用,返回true则继续,false则取消后面的执行
// function do_something_before_edit_data_in_portal_list(id) {
// return true;
// }
//-- 列表编辑后加载数据后调用void
// function do_something_after_edit_data_loaded_in_portal_list(id) {
//
// }
//-- 列表删除前调用,返回true则继续,false则取消后面的执行
// function do_something_before_delete_data_in_portal_list(id) {
// return true;
// }
function do_some_thing() {
var ps = {"ac": "dosomething"};
common_post.postPortal(ps).then(function (data, status) {
if (status === "success") {
}
});
}
//auto_code_from_user_design_or_engine_product
function callback_after_upload_file_xls_to_database() {
var val = $("#shop_name").val();
var ps = {
"ac": "modify_data_through_sql_and_conditions",
"sql": "update table_id set shop_code='" + val + "' where (shop_code is null or shop_code='') and create_by=@current_user_name",
"table_id": tableid,
"cdt": "[]"
}
common_post.postPortal(ps).then(function (data, status) {
if (status === "success") {
$("#shop_name").val("");
get_portal_data_list();
}
});
}
</script>
</div>
</div>
<script type="text/javascript" src="assets/js/amazeui.min.js"></script></script>
</body>
</html>
系统展示:

done

浙公网安备 33010602011771号