财务核算核销系统的快速开发落地使用;物流、电商、等行业均可适用。

需求:

数据自动上传程序解析原理:自动搜索文件夹下面的子文件夹和对应的文件.
匹配:交易报告,移除订单,仓储费,库存分类账,入库配置服务费用,广告活动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

 

posted @ 2025-07-10 16:14  liskov_design  阅读(11)  评论(0)    收藏  举报