77 lines
2.6 KiB
HTML
77 lines
2.6 KiB
HTML
<!DOCTYPE html>
|
|
<html>
|
|
<head>
|
|
<title>zdy</title>
|
|
<script type="text/javascript" src="js/jquery.min.js"></script>
|
|
<script type="text/javascript" src="js/jquery-ui.min.js"></script>
|
|
|
|
<!-- PivotTable.js libs from ../dist -->
|
|
<link rel="stylesheet" type="text/css" href="js/pivot.css">
|
|
<script type="text/javascript" src="js/pivot.js"></script>
|
|
<style>
|
|
body {font-family: Verdana;}
|
|
table{
|
|
width:100%;
|
|
}
|
|
.pvtRenderer{
|
|
zoom:130%;
|
|
width:100%;
|
|
display:none;
|
|
}
|
|
</style>
|
|
|
|
<!-- optional: mobile support with jqueryui-touch-punch -->
|
|
<script type="text/javascript" src="js/jquery.ui.touch-punch.js"></script>
|
|
</head>
|
|
<body>
|
|
<script type="text/javascript">
|
|
|
|
$(function(){
|
|
//var derivers = $.pivotUtilities.derivers;
|
|
var timestamp=new Date().getTime();
|
|
var utils = $.pivotUtilities;
|
|
var tpl = $.pivotUtilities.aggregatorTemplates;
|
|
|
|
$.getJSON("cache/mps.json?v="+timestamp, function(mps) {
|
|
parent.document.getElementById("data_time").innerHTML=mps.gettime;
|
|
|
|
$("#output").pivotUI(mps.data, {
|
|
//rows: ["Age"],
|
|
//cols: ["Party"],
|
|
hiddenFromDragDrop: ["金额","数量"],
|
|
hiddenFromAggregators: ["区域","代理","店铺属性","上下装","品牌"]
|
|
//aggregators: {
|
|
// "数量":
|
|
// function() { return tpl.sum()(["num"]) },
|
|
// "金额":
|
|
// function() { return tpl.sum()(["je"]) },
|
|
// "Count Unique Values":
|
|
// function() { return $.pivotUtilities .aggregators["Count Unique Values"](["no"])}
|
|
//}
|
|
|
|
});
|
|
setTimeout(function(){
|
|
if($(".pvtAggregator").val()=="个数"){
|
|
$(".pvtAttrDropdown").html('<option value=""></option><option value="店铺">店铺</option><option value="款号">款号</option><option value="款色">款色</option>');
|
|
}else{
|
|
$(".pvtAttrDropdown").html('<option value="金额">金额</option><option value="数量">数量</option>');
|
|
}
|
|
}, 100);
|
|
$(".pvtAggregator").bind("change", function() {
|
|
if($(".pvtAggregator").val()=="个数"){
|
|
$(".pvtAttrDropdown").html('<option value="款号">款号</option><option value="款色">款色</option><option value="店铺">店铺</option>');
|
|
}else{
|
|
$(".pvtAttrDropdown").html('<option value="金额">金额</option><option value="数量">数量</option>');
|
|
}
|
|
});
|
|
|
|
});
|
|
});
|
|
</script>
|
|
<div id="output" style="margin: 30px;"></div>
|
|
|
|
</body>
|
|
|
|
</html>
|
|
|