BPM 数据列表管理JavaScript代码
-- BPM 数据列表管理JavaScript代码
//排序字段设置，在发布表单的时候该数据项会自动和当前表中的索引校验，缺失索引则会自动创建。
sort= " create_time desc ";
sort= " update_time desc ";
size = 20;//页面的 page_size
isview = 1;//可查看详情-Lock按钮
isdel = 1;//可删除-Lock按钮
isedt = 1;//可以编辑保存
var x1 = get_current_user_name();//当前用户登录名称
var x2 = get_current_user_post_path();//当前用户部门层级路径名称
var x3 = this_view_total_count //当前查询的列表数量
currentid = "当前选择的数据id，点击右边select按钮的时候";
get_current_user_id(); //获取当前用户id
//删除前的操作,表格右边的删除按钮事件
function do_something_before_delete_data_in_portal_list(id) {
var trdata = $("#tr_data_" + id).html();
if (trdata.indexOf("yes") > -1 && trdata.indexOf("account ok") > -1) {
alert("该数据已被使用，不可删除！");
return false;
}
return true;
}
//列表中点击select按钮调用该方法，如果返回false则不执行后面的代码
function do_something_before_edit_data_in_portal_list() {
return true;
}
//列表中点击select按钮调用接口数据绑定显示完成后调用的方法，可以不用返回值。
function do_something_after_edit_data_loaded_in_portal_list(id) {
//do something
}
//默认过滤查询条件
if (get_current_user_post_path().indexOf("admin") === -1) {
$("#lab_limit_userid").val("@define_team_users");
}
//数据列表加载完成后调用的方法-点击链接打开地址
function get_portal_data_list_done_back() {
$("#listprodata").find("a").click(function () {
var xnum = $(this).html();
if (xnum.startsWith("http")) {
window.open(xnum);
} else {
window.open("https://www.amazon.com/dp/" + xnum);
}
});
$("#listprodata").find(".auto_fit_width_td").click(function () {
var val = $(this).html();
if (val !== null && val !== undefined && val.startsWith("http")) {
window.open(val);
}
});
}
// modal窗口显示
// 其中@time_calc后面的值为秒 比如：@time_calc-86400 返回则是当前时刻往前减去86400秒（也就是一天）,可用：@time_calc-200,@time_calc+500,@time_calc300
function get_portal_data_list_done_back() {
$("#listprodata").find("a").click(function () {
var xnum = $(this).html();
$(".labnumber").html(xnum)
common_post.postPortal({
"ac": "get_data_by_sql_back_data_table_from_portal_with_table_id",
"sql": " SELECT * from table_id where asin='" + xnum + "' and create_time>'@time_calc-259200' order by create_time asc ",
"table_id": "5e126b01f4cb40f786fa28a1c6b79510"
}).then(function (data) {
try {
arr = data.arr;
var tmp = "";
for (var i = 0; i < arr.length; i++) {
tmp += "<tr>";
tmp += "<td>" + arr[i].asin + "</td>";
tmp += "<td>" + arr[i].star + "</td>";
tmp += "<td>" + arr[i].ratings + "</td>";
tmp += "<td>" + arr[i].create_time + "</td>";
tmp += "</tr>";
}
$("#tbody_log").html(tmp);
$("#div_log").modal({closeViaDimmer: 1, width: 1116, height: 790});
} catch (ex) {
msg_info("no logs");
}
});
});
$("#listprodata").find(".auto_fit_width_td").click(function () {
var val = $(this).html();
if (val !== null && val !== undefined && val.startsWith("http")) {
window.open(val);
}
});
}
//设置数据列表的表头，显示上次表数据变化的时间
var base_title_html = $(".fsbpm_user_other_title_or_desc_info_style").html();
function get_sync_time() {
var settings = {
"url": "http://xxxxxx:8008/api/dependency/get_sync_data_status_by_table_id/" + tableid,
"method": "GET",
"timeout": 0,
};
$.ajax(settings).done(function (response) {
$(".fsbpm_user_other_title_or_desc_info_style").html(base_title_html + '<a style="font-size: 11px;">last sync time:' + response.msg + '</a>');
setTimeout("get_sync_time()", 1200);
});
}
get_sync_time();
//设置数据列表的表头：账号情况 --20241225
var base_title_html = $(".fsbpm_user_other_title_or_desc_info_style").html();
function get_ok_account() {
common_post.postPortal({
"ac": "get_data_by_sql_back_data_table_from_portal_with_table_id",
"sql": " SELECT count(*) as count from table_id where dp_count>0 ",
"table_id": "03bb2cb9b2eb4074a20dac8xxx"
}).then(function (data) {
$(".fsbpm_user_other_title_or_desc_info_style").html(base_title_html + '<a style="font-size: 12px;">当前可用账号:' + data.arr[0]["count"] + '个</a>');
});
}
get_ok_account();
//指定部门的id，获取部门下的用户名称 --20250213
var settings = {
"url": "../api/portal/get_group_users_by_group_id/group_id_xxx",
"method": "GET",
"timeout": 0,
};
$.ajax(settings).done(function (response) {
var tmp = "";
for (var i = 0; i < response.arr.length; i++) {
tmp += "<span class='am-badge am-badge-primary am-round am-text-lg' onclick='make_user_texted(this)'>" + response.arr[i].usernamenike + "</span> ";
}
$("#div_badge_users").html(tmp);
});
//添加，新增-数据到表中 --20250213
var create_by = get_current_user_name();
var settings = {
"url": "../api/portal/save_data_to_database_by_json_and_table_id_and_token_api",
"type": 'post',
"timeout": 0,
"headers": {
"Content-Type": "application/json"
},
"data": JSON.stringify({
"table_id": "3da7411a771549deb1d1baaf6d7xxx",
"data": [
{
"id": "abc_" + new Date().getTime(),
"order_number": "order_number",
"store_id": "shop_code",
"remarks": "shop_rmk",
"create_by": create_by
}
]
})
};
$.ajax(settings).done(function (response) {
console.log(response);
});
//新增或者修改数据的时候给输入控件绑定下拉值。
function load_suoshugaoxiao() {
common_post.postPortal({
"ac": "get_data_by_sql_back_data_table_from_portal_with_table_id",
"sql": "select mingchen from table_id where gongjiandanweileixing='高校' ",
"table_id": "f1e14f985e5949fba1aa5d54dbec1663"
}).then(function (data) {
var tmp = "<option value=''>请选择</option>";
for (var i = 0; i < data.arr.length; i++) {
tmp += "<option value='" + data.arr[i].mingchen + "' >" + data.arr[i].mingchen + "</option>";
}
$("#suoshugaoxiao").html(tmp);
});
}
load_suoshugaoxiao();
//加载银行数据
function load_bank_data() {
common_post.postPortal({
"ac": "get_data_by_sql_back_data_table_from_portal_with_table_id",
"sql": "select * from table_id",
"table_id": "bce6cf90409f43f3876028479ad72edf"
}).then(function (data) {
var tmp = "<option value='' mykey='bank_code' mycalc='equals'>请选择</option>";
for (var i = 0; i < data.arr.length; i++) {
tmp += "<option value='" + data.arr[i].yinhangbianma + "' mykey='bank_code' mycalc='equals' >" + data.arr[i].yinhangbianma + "->" + data.arr[i].yinhangmingchen + "</option>";
}
$("#sl_bank").html(tmp);
});
}
function submit_or_reject_for_review(val) {
var cdt = get_portal_search_conditions();
var ps = {
"ac": "modify_data_through_sql_and_conditions",
"sql": "update table_id set status=" + val + ",check_user=@current_user_name,check_time=now()",
"table_id": tableid,
"cdt": JSON.stringify(cdt)
}
if (val == 2) {
if (confirm("Are you sure the review has passed.确定审核通过吗？") == false) return;
}
if (val == 0) {
if (confirm("Are you sure you want to reject it.确定驳回吗？") == false) return;
ps = {
"ac": "modify_data_through_sql_and_conditions",
"sql": "update table_id set status=" + val + ",check_user='',check_time=null",
"table_id": tableid,
"cdt": JSON.stringify(cdt)
}
}
common_post.postPortal(ps).then(function (data) {
if (data.errorcode !== 0) {
msg_error(data.msg);
return false;
}
msg_success(data.msg);
});
}
//订单中心xls
$(function () {
$(".am-btn-primary").hide();
$("input[name='file']").hide();
$("img[alt='add new data']").hide();
$(".fsbpm_user_other_title_or_desc_info_style").append('<a style="font-size: 11px;">订单管理的数据来自于采购方发起的订单流程，此处不支持新增的操作。</a>');
});
$(function () {
$("input[name='myansbtn']").click(function () {
var arr_btn = $("input[name='myansbtn']");
$(arr_btn).each(function () {
$(this).css("background", "#e9e9ed");
});
$(this).css("background", "#9dc7f1");
});
});
function ans_data_by_sql_zhuxingtu(sql) {
var cdt = get_portal_search_conditions();
common_post.postPortal({
"ac": "get_data_by_sql_back_data_table_from_portal_with_table_id",
"sql": sql,
"table_id": "c78ff823f22d47e687f47c532f54bfae",
"cdt": JSON.stringify(cdt)
}).then(function (data) {
var datax = [];
for (var i = 0; i < data.arr.length; i++) {
datax.push([data.arr[i].name, data.arr[i].data])
}
Highcharts.chart('container', {
chart: {
type: 'column'
},
title: {
text: '利润统计分析'
},
subtitle: {
text: ''
},
xAxis: {
type: 'category',
labels: {
rotation: -45 //设置轴标签旋转角度
}
},
yAxis: {
min: 0,
title: {
text: '利润/元'
}
},
legend: {
enabled: false
},
tooltip: {
pointFormat: '总利润: <b>{point.y:.2f} 元</b>'
},
series: [{
name: '总利润',
data: datax,
dataLabels: {
enabled: true,
rotation: -90,
color: '#FFFFFF',
align: 'right',
format: '{point.y:.2f}', // :.1f 为保留 1 位小数
y: 10
}
}]
});
});
}
function ans_data_by_sql_zhexianmianji(sql) {
var cdt = get_portal_search_conditions();
common_post.postPortal({
"ac": "get_data_by_sql_back_data_table_from_portal_with_table_id",
"sql": sql,
"table_id": "c78ff823f22d47e687f47c532f54bfae",
"cdt": JSON.stringify(cdt)
}).then(function (data) {
var datax = [];
for (var i = 0; i < data.arr.length; i++) {
datax.push([data.arr[i].name, data.arr[i].data])
}
Highcharts.chart('container', {
chart: {
zoomType: 'x'
},
title: {
text: '利润分析'
},
subtitle: {
text: ''
},
xAxis: {
type: 'category',
labels: {
rotation: -45
}
},
tooltip: {
type: 'text'
},
yAxis: {
title: {
text: '总利润'
}
},
legend: {
enabled: false
},
series: [{
type: 'area',
name: '总利润',
data: datax
}]
});
});
}
//xiaoshoufuzeren
function ans_data_by_user() {
ans_data_by_sql_zhuxingtu("select ROUND(sum(maoli),2) as data,xiaoshoufuzeren as name from table_id group by xiaoshoufuzeren");
}
ans_data_by_user();
//pingtai
function ans_pingtai() {
ans_data_by_sql_zhuxingtu("select ROUND(sum(maoli),2) as data,pingtai as name from table_id group by pingtai");
}
//dianpuyingwenming
function ans_data_by_dianpuyingwenming() {
ans_data_by_sql_zhuxingtu("select ROUND(sum(maoli),2) as data,dianpuyingwenming as name from table_id group by dianpuyingwenming");
}
//zhandian
function ans_data_by_zhandian() {
ans_data_by_sql_zhuxingtu("select ROUND(sum(maoli),2) as data,zhandian as name from table_id group by zhandian");
}
//yijipinlei
function and_data_by_yijipinlei() {
ans_data_by_sql_zhuxingtu("select ROUND(sum(maoli),2) as data,yijipinlei as name from table_id group by yijipinlei");
}
//ejipinlei
function ans_ejipinlei() {
ans_data_by_sql_zhuxingtu("select ROUND(sum(maoli),2) as data,ejipinlei as name from table_id group by ejipinlei");
}
//cangku
function and_data_by_cangku() {
ans_data_by_sql_zhuxingtu("select ROUND(sum(maoli),2) as data,cangku as name from table_id group by cangku");
}
//fukuanshijian
function ans_fukuanshijian() {
ans_data_by_sql_zhexianmianji("select ROUND(sum(maoli),2) as data,DATE_FORMAT(fukuanshijian,'%Y%m%d') as name from table_id group by name");
}
//chuangjianshijian
function ans_chuangjianshijian() {
ans_data_by_sql_zhuxingtu("select ROUND(sum(maoli),2) as data,DATE_FORMAT(chuangjianshijian,'%Y%m%d') as name from table_id group by name");
}
function op_sku_data_status() {
var cdt = get_portal_search_conditions();
var ps = {
"ac": "modify_data_through_sql_and_conditions",
"sql": "update table_id set `status`='0'; update table_id set `status`='1' where sku!='' and name!='' and product!='' and project!='' and category_1!=''",
"table_id": table_id,
"cdt": ""
}
common_post.postPortal(ps).then(function (data) {
});
}
op_sku_data_status();
//数据列表加载完成后调用的方法
function get_portal_data_list_done_back() {
$("#listprodata").find("a").click(function () {
var xnum = $(this).html();
$(".labnumber").html(xnum)
common_post.postPortal({
"ac": "get_data_by_sql_back_data_table_from_portal_with_table_id",
"sql": " SELECT track_info from table_id where tracking_number='" + xnum + "'",
"table_id": "ce31e81500854a0388ed1c042eb7332c"
}).then(function (data) {
try {
var sa = JSON.parse(data.arr[0].track_info);
var track_info = sa.data.accepted[0].track_info;
var shipping_info = track_info.shipping_info;
var xfrom = shipping_info.shipper_address.city + " " + shipping_info.shipper_address.state + " " + shipping_info.shipper_address.country;
var xto = shipping_info.recipient_address.city + " " + shipping_info.recipient_address.state + " " + shipping_info.recipient_address.country;
var xcarrier = track_info.tracking.providers[0].provider.name;
xfrom = xfrom.replaceAll("null", "").replaceAll(" ", "");
xto = xto.replaceAll("null", "").replaceAll(" ", "");
var events = track_info.tracking.providers[0].events;
var tmpx = ""
for (var i = 0; i < events.length; i++) {
tmpx += "<tr> ";
tmpx += " <td> ";
tmpx += " <a>" + events[i].time_utc + "</a> ";
tmpx += " </td> ";
tmpx += " <td>" + events[i].location + " " + events[i].description + "</td> ";
tmpx += "</tr> ";
}
$(".labfrom").html(xfrom);
$(".labto").html(xto);
if (xfrom === "") {
$(".labfrom,.labto").hide();
} else {
$(".labfrom,.labto").show();
}
$(".labcarrier").html(xcarrier);
$("#tbody_event").html(tmpx);
$("#div_track").modal({closeViaDimmer: 1, width: 1010, height: 600});
} catch (ex) {
msg_info("暂无跟踪信息");
}
});
});
}
done at 20250414
浙公网安备 33010602011771号