Files
2025-10-01 09:29:34 +09:00

279 lines
11 KiB
Plaintext

<!-- #include Virtual = "/Lib/config.asp" -->
<html leng="ko">
<!--#include virtual="/Include/Head.asp"-->
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.10.20/css/dataTables.bootstrap.min.css">
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/buttons/1.6.1/css/buttons.bootstrap.min.css">
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/fixedcolumns/3.3.0/css/fixedColumns.bootstrap.min.css">
<!--#include virtual="/Include/Top.asp"-->
<div class="col-xs-12 col-sm-10">
<br/>
<div class="row">
<div class="panel">
<div class="panel-body">
<div class="table-responsive">
<table class="table table-bordered table-hover nowrap" id="Q_List" style="width:100%;">
<thead>
<tr class="active">
<th class="text-center" rowspan="2">지역</th>
<th class="text-center" rowspan="2">권역</th>
<th class="text-center" colspan="4">현재쿼터</th>
</tr>
<tr class="active">
<th class="text-center">조장</th>
<th class="text-center">조원</th>
<th class="text-center">롱폼</th>
<th class="text-center">감독관</th>
<th class="text-center sumTh">합계</th>
</tr>
</thead>
<tbody>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
<!--#include virtual="/Include/Bottom.asp"-->
<script src="https://cdn.datatables.net/1.10.20/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/1.10.20/js/dataTables.bootstrap.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.6.1/js/dataTables.buttons.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.6.1/js/buttons.bootstrap.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
<script src="https://cdn.datatables.net/buttons/1.6.1/js/buttons.html5.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.6.1/js/buttons.print.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.6.1/js/buttons.colVis.min.js"></script>
<style>
#Q_List td{
font-size: 14px;
padding: 0;
text-align: right;
}
#Q_List .areaLabel, #Q_List .distLabel{
text-align:center;
vertical-align:middle;
}
#Q_List td .cnt, #Q_List td .sls{
display:inline-block;
z-index: 10;
position: relative;
}
#Q_List td .sls{
margin:0 2px;
}
#Q_List td .rate{
display:inline-block;
margin-right:10px;
z-index: 10;
position: relative;
}
#Q_List .sumTh{
background-color: #ccc;
padding: 0;
text-align: center;
vertical-align: middle;
}
#Q_List .sumTd{
background-color: #f8f6ff91;
}
#Q_List .bgProgress{
position:relative;
top:0;
left:0;
width:100%;
height:108%;
line-height:30px;
}
#Q_List .bgProgressBar{
position:absolute;
top:0;
left:0;
height:100%;
background-color:#b3d4ff;
opacity:0.7;
filter:alpha(opacity=70);
}
#Q_List .bgProgressBar.comple{
background-color:#80ff9f;
}
#Q_List .bgProgressBar.over{
background-color:#97d62a;
}
</style>
<script>
function qSet(qjsonArr){
var d_Arr = uniq(qjsonArr, ["a_cd", "a_nm", "d_cd", "d_nm"]);
var a_Arr = groupBySum(d_Arr, ["a_cd", "a_nm"]);
var tmpHtml = "";
$.each(a_Arr, function(ai, aobj){
tmpHtml += "<tr>";
tmpHtml += "<td class='areaLabel' rowspan='" + aobj.groupByCount + "'>" + aobj.a_nm + "</td>";
var tmpD_Arr = $.grep(d_Arr, function(obj){ return obj.a_cd == aobj.a_cd; });
$.each(tmpD_Arr, function(di, dobj){
tmpHtml += "<td class='distLabel'>" + dobj.d_nm + "</td>";
var qCntArr = $.grep(qjsonArr, function(obj){ return obj.a_cd == aobj.a_cd && obj.d_cd == dobj.d_cd; });
$.each(qCntArr, function(qi, qo){
var tmpRate = qo.Qu != 0 ? qo.Cnt / qo.Qu * 100 : 0;
tmpHtml += "<td data-a_cd='" + aobj.a_cd + "' data-d_cd='" + dobj.d_cd + "' data-p_cd='" + qo.p_cd + "'>"
tmpHtml += "<div class='bgProgress'>";
tmpHtml += "<span class='cnt'>" + qo.Cnt + "</span><span class='sls'>/</span><span class='cnt'>" + qo.Qu + "</span> <span class='rate'>(" + cof(tmpRate, 1) + "%)</span>";
tmpHtml += "<div class='bgProgressBar " + (+tmpRate == 100 ? "comple" : (+tmpRate > 100 ? "over" : "")) + "' style='width:" + (+tmpRate > 100 ? 100 : tmpRate) + "%;'></div>";
tmpHtml += "</div>";
tmpHtml += "</td>";
});
var qSum = groupBySum(qCntArr, ["a_cd", "d_cd"], ["Qu", "Cnt"])[0];
//console.log(qSum);
var tmpRate = qSum.Qu != 0 ? qSum.Cnt / qSum.Qu * 100 : 0;
tmpHtml += "<td class='sumTd' data-a_cd='" + aobj.a_cd + "' data-d_cd='" + dobj.d_cd + "' data-p_cd=''>";
tmpHtml += "<div class='bgProgress'>";
tmpHtml += "<span class='cnt'>" + qSum.Cnt + "</span><span class='sls'>/</span><span class='cnt'>" + qSum.Qu + "</span> <span class='rate'>(" + cof(tmpRate, 1) + "%)</span>";
tmpHtml += "<div class='bgProgressBar " + (+tmpRate == 100 ? "comple" : (+tmpRate > 100 ? "over" : "")) + "' style='width:" + (+tmpRate > 100 ? 100 : tmpRate) + "%;'></div>";
tmpHtml += "</div>";
tmpHtml += "</td>";
tmpHtml += "</tr>";
if(tmpD_Arr.length - 1 != di){
tmpHtml += "<tr>";
}
});
if(a_Arr.length - 1 == ai){
tmpHtml += "</tr>";
}
});
tmpHtml += "<tr>";
tmpHtml += "<th class='sumTh' colspan='2'>합계</td>";
var qCntArr = groupBySum(qjsonArr, ["p_cd"], ["Qu", "Cnt"]);
//console.log(qCntArr);
$.each(qCntArr, function(qi, qo){
var tmpRate = qo.Qu != 0 ? qo.Cnt / qo.Qu * 100 : 0;
tmpHtml += "<td class='sumTd' data-a_cd='' data-d_cd='' data-p_cd='" + qo.p_cd + "'>"
tmpHtml += "<div class='bgProgress'>";
tmpHtml += "<span class='cnt'>" + qo.Cnt + "</span><span class='sls'>/</span><span class='cnt'>" + qo.Qu + "</span> <span class='rate'>(" + cof(tmpRate, 1) + "%)</span>";
tmpHtml += "<div class='bgProgressBar " + (+tmpRate == 100 ? "comple" : (+tmpRate > 100 ? "over" : "")) + "' style='width:" + (+tmpRate > 100 ? 100 : tmpRate) + "%;'></div>";
tmpHtml += "</div>";
tmpHtml += "</td>";
});
var qSum = groupBySum(qCntArr, [], ["Qu", "Cnt"])[0];
var tmpRate = qSum.Qu != 0 ? qSum.Cnt / qSum.Qu * 100 : 0;
tmpHtml += "<td class='sumTd' data-a_cd='' data-d_cd='' data-p_cd=''>";
tmpHtml += "<div class='bgProgress'>";
tmpHtml += "<span class='cnt'>" + qSum.Cnt + "</span><span class='sls'>/</span><span class='cnt'>" + qSum.Qu + "</span> <span class='rate'>(" + cof(tmpRate, 1) + "%)</span>";
tmpHtml += "<div class='bgProgressBar " + (+tmpRate == 100 ? "comple" : (+tmpRate > 100 ? "over" : "")) + "' style='width:" + (+tmpRate > 100 ? 100 : tmpRate) + "%;'></div>";
tmpHtml += "</div>";
tmpHtml += "</td>";
tmpHtml += "</tr>";
$("#Q_list > tbody").html(tmpHtml);
}
function groupBySum(jsonArr, groupArr, sumArr_opt){
var sumArr = sumArr_opt || [];
var newJsonArr = groupArr.length != 0 ? uniq(jsonArr, groupArr) : [{}];
$.each(newJsonArr, function(i, obj){
$.each(sumArr, function(idx, sumCol){
obj[sumCol] = 0;
});
obj["groupByCount"] = 0;
});
$.each(newJsonArr, function(idx, obj){
$.each($.grep(jsonArr, function(o, i){
var nStr = "";
var pStr = "";
$.each(groupArr, function(ix, groupCol){
nStr += obj[groupCol] + "|";
pStr += o[groupCol] + "|";
});
return nStr == pStr;
}), function(i, o){
$.each(sumArr, function(ix, sumCol){
obj[sumCol] += +o[sumCol];
});
obj["groupByCount"]++;
});
});
return newJsonArr;
}
function uniq(arr, item){
var retArr = [];
if(Array.isArray(item) == true){
retArr = unique($.map(arr, function(obj){
var tmpArr = [];
for(var i=0; i<item.length; i++){
tmpArr.push(obj[item[i]]);
}
return tmpArr.join("|");
}).sort());
retArr = $.map(retArr, function(obj){
var tmpObj = {};
var tmpVal = obj.split("|");
for(var i=0; i<item.length; i++){
tmpObj[item[i]] = tmpVal[i];
}
return tmpObj;
});
return retArr;
}else{
retArr = unique($.map(arr, function(obj){ return obj[item]; }).sort());
}
return retArr;
}
function unique(array) {
return $.grep(array, function(el, index) {
return index == $.inArray(el, array);
});
}
function cof(pnum, fixVal) {
var num = pnum + "";
var retNum = num.replace(/[^-\.0-9]/gi, "");
if(isNaN(retNum)) return "";
var option = new Object();
option.minimumFractionDigits = fixVal;
option.maximumFractionDigits = fixVal;
return (+retNum).toLocaleString(undefined, option);
}
$(function(){
AjaxQu();
$("#Q_list").DataTable({
dom:'lBfrtip',
lengthCange:false,
"scrollX": true,
"scrollY": "700px",
scrollCollapse: true,
paging:false,
fixedColumns: true
})
function AjaxQu(){
$.ajax({
url:"/Ajax/AjaxQu.asp",
type:"POST",
dataType:"json",
async:false,
data:{"gubun":"Qu"},
success:function(res){
qSet(res);
},
error:function(err){
alert("System Error");
return false;
}
});
}
});
</script>