You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
411 lines
16 KiB
Plaintext
411 lines
16 KiB
Plaintext
2 months ago
|
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="TJ_MoneyCount.aspx.cs" Inherits="TradeManage.TongJi.TJ_MoneyCount" %>
|
||
|
|
|
||
|
|
|
||
|
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN">
|
||
|
|
<html xmlns="http://www.w3.org/1999/xhtml">
|
||
|
|
<head id="Head1">
|
||
|
|
<title>利润分析</title>
|
||
|
|
<link rel="stylesheet" type="text/css" href="../themes/default/easyui.css" />
|
||
|
|
<link rel="stylesheet" type="text/css" href="../themes/icon.css" />
|
||
|
|
<link rel="stylesheet" type="text/css" href="../themes/New.css" />
|
||
|
|
<link rel="stylesheet" type="text/css" href="../themes/DataGrid.css" />
|
||
|
|
|
||
|
|
<script src="../Scripts/jquery.min.js" type="text/javascript"></script>
|
||
|
|
|
||
|
|
<script type="text/javascript" src="../Scripts/highcharts.js"></script>
|
||
|
|
|
||
|
|
<script type="text/javascript" src="../Scripts/exporting.js"></script>
|
||
|
|
<script src="../Scripts/MicrosoftAjax.js" type="text/javascript"></script>
|
||
|
|
|
||
|
|
<script src="../Scripts/jquery.easyui.min.js" type="text/javascript"></script>
|
||
|
|
<script src="../Scripts/DataGrid.js" type="text/javascript"></script>
|
||
|
|
<script src="../Scripts/DataPager.js" type="text/javascript"></script>
|
||
|
|
|
||
|
|
<script src="../Scripts/jquery.bgiframe.min.js" type="text/javascript"></script>
|
||
|
|
<script src="../Scripts/Global.js" type="text/javascript"></script>
|
||
|
|
<script src="../Scripts/WindowLoad.js" type="text/javascript"></script>
|
||
|
|
<script src="../Scripts/DatePicker/WdatePicker.js" type="text/javascript"></script>
|
||
|
|
|
||
|
|
<script type="text/javascript">
|
||
|
|
var datagrid1 = new nblf.ui.DataGrid("DataGrid1");
|
||
|
|
var WindowLoadModel = new WindowLoad();
|
||
|
|
$(document).ready(function () {
|
||
|
|
ajaxInit(WindowLoadModel);
|
||
|
|
|
||
|
|
$("#btn_sch").bind("click", function () {
|
||
|
|
//GetOrderCountItem();
|
||
|
|
GetOrderNumCount();
|
||
|
|
|
||
|
|
});
|
||
|
|
|
||
|
|
GetBasePlat();
|
||
|
|
GetShopList();
|
||
|
|
$("#select_plat").bind("change", function () {
|
||
|
|
GetShopList();
|
||
|
|
});
|
||
|
|
$("#rad_1").bind("click", function () {
|
||
|
|
$("#div_date").html("<input id='txt_SDate' class='editTextbox' onfocus='WdatePicker()' style='width: 120px;' type='text' />-<input id='txt_EDate' class='editTextbox' onfocus='WdatePicker()' style='width: 120px;' type='text' />");
|
||
|
|
});
|
||
|
|
$("#rad_2").bind("click", function () {
|
||
|
|
$("#div_date").empty();
|
||
|
|
for (var i = 1; i < 13; i++) {
|
||
|
|
$("#div_date").append("<input no='" + i + "' type='checkbox' id='chk_'" + i.toString() + "' checked='checked'/><label for='chk_'" + i.toString() + "'>" + i.toString() + "月 </label>");
|
||
|
|
}
|
||
|
|
});
|
||
|
|
$("#rad_3").bind("click", function () {
|
||
|
|
$("#div_date").empty();
|
||
|
|
for (var i = 1; i < 5; i++) {
|
||
|
|
$("#div_date").append("<input no='" + i + "' type='checkbox' id='chk_'" + i.toString() + "' checked='checked'/><label for='chk_'" + i.toString() + "' >" + i.toString() + "季度 </label>");
|
||
|
|
}
|
||
|
|
});
|
||
|
|
$("#chk_all").live("click", function () {
|
||
|
|
if ($(this).is(":checked") == true)
|
||
|
|
$("#div_shop input").attr("checked", "checked");
|
||
|
|
else
|
||
|
|
$("#div_shop input").removeAttr("checked");
|
||
|
|
|
||
|
|
|
||
|
|
});
|
||
|
|
});
|
||
|
|
function GetBasePlat() {
|
||
|
|
$("#select_plat").empty();
|
||
|
|
$("#select_plat").append("<option value='0'>全部</option>");
|
||
|
|
var param = new Object();
|
||
|
|
param.CompanyID = 0;
|
||
|
|
param.KeyName = "ptlx";
|
||
|
|
WindowLoadModel.Show();
|
||
|
|
$.ajax({
|
||
|
|
url: "../UserService.asmx/GetPlatBaseCode",
|
||
|
|
data: Sys.Serialization.JavaScriptSerializer.serialize(param),
|
||
|
|
success: function (data) {
|
||
|
|
WindowLoadModel.Hide();
|
||
|
|
|
||
|
|
if (data.d != null) {
|
||
|
|
$(data.d).each(function () {
|
||
|
|
$("#select_plat").append("<option value='" + this.SortNo + "'>" + this.Name + "</option>");
|
||
|
|
});
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
}
|
||
|
|
});
|
||
|
|
}
|
||
|
|
function GetShopList() {
|
||
|
|
$("#select_shop").empty();
|
||
|
|
$("#select_shop").append("<option value='0'>全部</option>");
|
||
|
|
var param = new Object();
|
||
|
|
|
||
|
|
param.PlatType = $("#select_plat").val();
|
||
|
|
|
||
|
|
WindowLoadModel.Show();
|
||
|
|
$.ajax({
|
||
|
|
url: "../BaseData.asmx/GetShopList",
|
||
|
|
data: Sys.Serialization.JavaScriptSerializer.serialize(param),
|
||
|
|
success: function (data) {
|
||
|
|
WindowLoadModel.Hide();
|
||
|
|
|
||
|
|
if (data.d != null) {
|
||
|
|
|
||
|
|
$(data.d).each(function () {
|
||
|
|
|
||
|
|
$("#select_shop").append("<option value='" + this.ShopId + "'>" + this.ShopName + "</option>");
|
||
|
|
|
||
|
|
});
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
}
|
||
|
|
});
|
||
|
|
}
|
||
|
|
var itemlist = new Array();
|
||
|
|
function GetOrderCountItem() {
|
||
|
|
var param = new Object();
|
||
|
|
param.PlatType = $("#select_plat").val();
|
||
|
|
param.SDate = $("#txt_SDate").val();
|
||
|
|
param.EDate = $("#txt_EDate").val();
|
||
|
|
|
||
|
|
$.ajax({
|
||
|
|
url: "TJ_CountServer.asmx/GetOrderCountItem",
|
||
|
|
data: Sys.Serialization.JavaScriptSerializer.serialize(param),
|
||
|
|
dataType: "json",
|
||
|
|
async: false,
|
||
|
|
success: function (data) {
|
||
|
|
if (data.d != null) {
|
||
|
|
itemlist = data.d;
|
||
|
|
CreateDataGrid();
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
}
|
||
|
|
});
|
||
|
|
|
||
|
|
|
||
|
|
}
|
||
|
|
var cate = new Array();
|
||
|
|
var datas = "";
|
||
|
|
var arr1 = new Array();
|
||
|
|
function GetOrderNumCount() {
|
||
|
|
var param = new Object();
|
||
|
|
|
||
|
|
if ($("#rad_1").is(":checked") == true) {
|
||
|
|
|
||
|
|
if ($("#txt_SDate").val() == "" || $("#txt_EDate").val() == "") {
|
||
|
|
alert("请填写要统计的日期");
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
param.PlatId = $("#select_plat").val();;
|
||
|
|
param.ShopId = $("#select_shop").val();
|
||
|
|
param.SDate = null;
|
||
|
|
param.EDate = null;
|
||
|
|
|
||
|
|
param.CountType = $("#select_counttype").val();
|
||
|
|
param.DateType = 1;
|
||
|
|
var DateList = new Array();
|
||
|
|
if ($("#rad_1").is(":checked") == true) {
|
||
|
|
subTitle = "按日期统计";
|
||
|
|
param.SDate = $("#txt_SDate").val();
|
||
|
|
param.EDate = $("#txt_EDate").val();
|
||
|
|
}
|
||
|
|
else if ($("#rad_2").is(":checked") == true) {
|
||
|
|
subTitle = "按月统计";
|
||
|
|
param.DateType = 2;
|
||
|
|
}
|
||
|
|
else
|
||
|
|
if ($("#rad_3").is(":checked") == true) {
|
||
|
|
subTitle = "按季度统计";
|
||
|
|
param.DateType = 3;
|
||
|
|
}
|
||
|
|
if (param.DateType > 1) {
|
||
|
|
$("#div_date input[no]:checked").each(function () {
|
||
|
|
var md1 = new Object();
|
||
|
|
md1.DateValue = $(this).attr("no");
|
||
|
|
md1.DateName = $(this).next("label").html();
|
||
|
|
Array.add(DateList, md1);
|
||
|
|
});
|
||
|
|
if (param.DateType == 2 && DateList.length <= 0) {
|
||
|
|
alert("请选择要统计的月份");
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
else
|
||
|
|
if (param.DateType == 3 && DateList.length <= 0) {
|
||
|
|
alert("请选择要统计的季度");
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
param.DateList = DateList;
|
||
|
|
|
||
|
|
|
||
|
|
$.ajax({
|
||
|
|
url: "TJ_CountServer.asmx/GetOrderPriceCount",
|
||
|
|
data: Sys.Serialization.JavaScriptSerializer.serialize(param),
|
||
|
|
dataType: "json",
|
||
|
|
async: true,
|
||
|
|
success: function (data) {
|
||
|
|
if (data.d != null) {
|
||
|
|
if (data.d.Error != null && data.d.Error != "") {
|
||
|
|
alert(data.d.Error);
|
||
|
|
return;
|
||
|
|
}
|
||
|
|
cate = data.d.categories;
|
||
|
|
|
||
|
|
datas = data.d.Data;
|
||
|
|
$("#DataGrid1").empty();
|
||
|
|
itemlist = data.d.listItem;
|
||
|
|
if (itemlist != null)
|
||
|
|
CreateDataGrid();
|
||
|
|
DgData = data.d.listData;
|
||
|
|
BindData();
|
||
|
|
SetChart();
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
}
|
||
|
|
});
|
||
|
|
|
||
|
|
|
||
|
|
}
|
||
|
|
var DgData = new Array();
|
||
|
|
function BindData() {
|
||
|
|
|
||
|
|
if (DgData != null) {
|
||
|
|
var shtmls = "";
|
||
|
|
for(var i=1;i<4;i++)
|
||
|
|
{
|
||
|
|
shtmls += "<tr>";
|
||
|
|
var shopId = 1;
|
||
|
|
var tdname = "销售额";
|
||
|
|
if (i == 2)
|
||
|
|
tdname = "成本";
|
||
|
|
if (i ==3)
|
||
|
|
tdname = "利润";
|
||
|
|
shtmls += "<td align='center'>" + tdname + "</td>";
|
||
|
|
|
||
|
|
$(DgData).each(function () {
|
||
|
|
var DId = this.DayId;
|
||
|
|
var SId = this.ShopId;
|
||
|
|
var data = this.Data;
|
||
|
|
$(itemlist).each(function () {
|
||
|
|
var dname = this.dataname;
|
||
|
|
if (DId == dname && shopId == SId) {
|
||
|
|
shtmls += "<td align='center'>" + data + "</td>";
|
||
|
|
}
|
||
|
|
});
|
||
|
|
});
|
||
|
|
shtmls += "</tr>";
|
||
|
|
}
|
||
|
|
$("#" + datagrid1.TableID).append(shtmls);
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
}
|
||
|
|
function getData() {
|
||
|
|
|
||
|
|
//var data = "[{name: '速卖通',data: [7.0, 6.9, 9.5, 14.5, 18.2, 21.5, 25.2, 26.5, 23.3, 18.3, 13.9, 9.6]}, {name: '亚马逊',data: [5, 5.5, 5.7, 11.3, 17.0, 22.0, 24.8, 24.1, 20.1, 14.1, 8.6, 2.5]}, {name: 'EBay',data: [3, 3, 3.5, 8.4, 13.5, 17.0, 18.6, 17.9, 14.3, 9.0, 3.9, 1.0]}, {name: 'Wish',data: [3.9, 4.2, 5.7, 8.5, 11.9, 15.2, 17.0, 16.6, 14.2, 10.3, 6.6, 4.8]}]";
|
||
|
|
var dataJsonobj = eval("(" + datas + ")");//转换成json对象
|
||
|
|
|
||
|
|
return dataJsonobj;
|
||
|
|
|
||
|
|
}
|
||
|
|
var Title = "销售利润报表";
|
||
|
|
var subTitle = "2015年04月15日--2015年04月20日";
|
||
|
|
var secondTitle = "订单量";
|
||
|
|
|
||
|
|
function SetChart()
|
||
|
|
{
|
||
|
|
$('#container').highcharts({
|
||
|
|
chart: {
|
||
|
|
type: 'column'
|
||
|
|
},
|
||
|
|
title: {
|
||
|
|
text: Title
|
||
|
|
},
|
||
|
|
subtitle: {
|
||
|
|
text: subTitle
|
||
|
|
},
|
||
|
|
xAxis: {
|
||
|
|
categories: cate
|
||
|
|
},
|
||
|
|
yAxis: {
|
||
|
|
min: 0,
|
||
|
|
title: {
|
||
|
|
text: ' 元'
|
||
|
|
}
|
||
|
|
},
|
||
|
|
tooltip: {
|
||
|
|
headerFormat: '<span style="font-size: 10px;">{point.key}</span>',
|
||
|
|
pointFormat: '' +
|
||
|
|
'',
|
||
|
|
footerFormat: '<table><tbody><tr><td style="padding: 0px;">{series.name}: </td><td style="padding: 0px;"><b>{point.y:.1f} 元</b></td></tr></tbody></table>',
|
||
|
|
shared: true,
|
||
|
|
useHTML: true
|
||
|
|
},
|
||
|
|
plotOptions: {
|
||
|
|
column: {
|
||
|
|
pointPadding: 0.2,
|
||
|
|
borderWidth: 0
|
||
|
|
}
|
||
|
|
},
|
||
|
|
series: getData()
|
||
|
|
});
|
||
|
|
}
|
||
|
|
|
||
|
|
function CreateDataGrid() {
|
||
|
|
Array.clear(datagrid1.Columns);
|
||
|
|
var col = new nblf.ui.DataGridColumn();
|
||
|
|
col.HeaderText = "店铺平台";
|
||
|
|
col.CellTemplate = "<a>{Bind ShopName}</a>";
|
||
|
|
Array.add(datagrid1.Columns, col);
|
||
|
|
$(itemlist).each(function () {
|
||
|
|
col = new nblf.ui.DataGridColumn();
|
||
|
|
col.HeaderText = this.name;
|
||
|
|
col.CellTemplate = "<span>{Bind " + this.dataname + "}</span>";
|
||
|
|
Array.add(datagrid1.Columns, col);
|
||
|
|
|
||
|
|
});
|
||
|
|
|
||
|
|
|
||
|
|
datagrid1.IsFixHeader = false;
|
||
|
|
datagrid1.ShowIndexColumn = false;
|
||
|
|
datagrid1.AllowPaging = false;
|
||
|
|
datagrid1.Width = "100%";
|
||
|
|
datagrid1.SelectMode = nblf.ui.SelectMode.None;
|
||
|
|
datagrid1.Init();
|
||
|
|
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
</script>
|
||
|
|
|
||
|
|
</head>
|
||
|
|
<body class="headbody">
|
||
|
|
|
||
|
|
<div class="title_ico">
|
||
|
|
利润分析</div>
|
||
|
|
|
||
|
|
<table border="1" cellpadding="0" cellspacing="0" style="width:99%;" align="center" class="tableAll">
|
||
|
|
|
||
|
|
|
||
|
|
<tr>
|
||
|
|
|
||
|
|
<td colspan="5">
|
||
|
|
<input id="rad_1" type="radio" value="" name="tj" checked="checked"/><label for="rad_1">按天统计</label> <input id="rad_2" name="tj" type="radio" value="" /><label for="rad_2">按月统计</label> <input id="rad_3" name="tj" type="radio" value="" /><label for="rad_3">按季度统计</label></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
<tr>
|
||
|
|
<td class="f1" width="13%">统计内容：</td>
|
||
|
|
<td colspan="3" width="65%"><select id="select_plat" class="selectClass" style="width: 120px" name="D5">
|
||
|
|
|
||
|
|
|
||
|
|
</select><select id="select_shop" class="selectClass" style="width: 120px" name="D6">
|
||
|
|
|
||
|
|
|
||
|
|
</select></td>
|
||
|
|
<td></td>
|
||
|
|
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
|
||
|
|
<td class="f1" width="13%">统计日期：</td>
|
||
|
|
<td colspan="3">
|
||
|
|
<div id="div_date"> <input id="txt_SDate" class="editTextbox" onfocus="WdatePicker()" style="width: 120px;" type="text" />-
|
||
|
|
<input id="txt_EDate" class="editTextbox" onfocus="WdatePicker()" style="width: 120px;" type="text" /></div> </td>
|
||
|
|
<td><input id="btn_sch" class="btnClass btnClassFind" type="button" value="查询" /></td>
|
||
|
|
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
<td valign="top" colspan="5">
|
||
|
|
<div id="DataGrid1" class="DataGridStyle"></div>
|
||
|
|
</td>
|
||
|
|
</tr>
|
||
|
|
<tr>
|
||
|
|
|
||
|
|
<td colspan="5">
|
||
|
|
<div id="container">
|
||
|
|
</div>
|
||
|
|
</td>
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
</table>
|
||
|
|
|
||
|
|
</body>
|
||
|
|
</html>
|
||
|
|
|
||
|
|
|