style24
/
style24.admin


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449
							<!DOCTYPE html>
<html lang="ko"
	xmlns:th="http://www.thymeleaf.org">
<!--
 *******************************************************************************
 * @source  : BrandTradingForm.html
 * @desc    : 브랜드별주문 Page
 *============================================================================
 * STYLE24
 * Copyright(C) 2020 TSIT, All rights reserved.
 *============================================================================
 * VER  DATE         AUTHOR      DESCRIPTION
 * ===  ===========  ==========  =============================================
 * 1.0  2021-09-16 목   lmc        최초 작성
 *******************************************************************************
 -->
	<div id="main">
		<!-- 메인타이틀 영역 -->
		<div class="main-title"></div>
		<!-- //메인타이틀 영역 -->

		<!-- 메뉴 설명 -->
		<div class="infoBox menu-desc"></div>
		<!-- //메뉴 설명 -->

		<!-- 검색조건 영역 -->
		<div class="panelStyle">
			<form id="searchForm" name="searchForm" action="#" th:action="@{'/statistics/brand/order/list'}" onsubmit="$('#btnSearch').trigger('click'); return false;">
				<input type="hidden" name="dayGb" value="D"/>

				<table class="frmStyle" aria-describedby="검색조건">
					<colgroup>
						<col style="width:10%;"/>
						<col style="width:25%;"/>
						<col style="width:10%;"/>
						<col/>
					</colgroup>
					<tr>
						<th>기간<i class="required" title="필수" aria-hidden="true"></i></th>
						<td colspan="3" id="terms"></td>
					</tr>
					<tr>
						<th>디바이스</th>
						<td>
							<label class="chkBox checked"><input type="checkbox" name="multiFrontGb" value="P" checked="checked"/>PC웹</label>
							<label class="chkBox checked"><input type="checkbox" name="multiFrontGb" value="M" checked="checked"/>모바일웹</label>
							<label class="chkBox checked"><input type="checkbox" name="multiFrontGb" value="A" checked="checked"/>APP</label>
						</td>
						<th>제휴몰</th>
						<td>
							<input type="text" class="w100" name="extmallIdSearchTxt" id="extmallIdSearchTxt" maxlength="20"/>
							<button type="button" class="btn icn" onclick="cfnOpenExtmallListPopup('fnSetExtmallInfo', 'M');"><i class="fa fa-search"></i></button>
							<span id="extmallIdTxt"></span>
							<input type="hidden" name="extmallIdList"/>
						</td>
					</tr>
					<tr>
						<th>물류구분</th>
						<td colspan="3">
							<label class="chkBox checked"><input type="checkbox" name="multiDistributionGb" value="SCM" checked="checked"/>입점</label>
							<label class="chkBox checked"><input type="checkbox" name="multiDistributionGb" value="WMS" checked="checked"/>위탁</label>
						</td>
					</tr>
					<tr>
						<th>공급업체</th>
						<td>
							<input type="text" class="w100" name="supplyCompCdSearchTxt" id="supplyCompCdSearchTxt" maxlength="20"/>
							<button type="button" class="btn icn" onclick="cfnOpenCompanyListPopup('fnSetSupplyCompInfo', 'M');"><i class="fa fa-search"></i></button>
							<span id="supplyCompCdTxt"></span>
							<input type="hidden" name="supplyCompCdList"/>
						</td>
						<th>제휴채널</th>
						<td>
							<input type="text" class="w100" name="afLinkCdSearchTxt" id="afLinkCdSearchTxt" maxlength="20" />
							<button type="button" class="btn icn" onclick="cfnOpenAfLinkListPopup('fnSetAfLinkInfo', 'M');"><i class="fa fa-search"></i></button>
							<span id="afLinkCdTxt"></span>
							<input type="hidden" name="afLinkCdList"/>
						</td>
					</tr>
					<tr>
						<th>브랜드</th>
						<td>
							<input type="text" class="w100" name="brandCdSearchTxt" id="brandCdSearchTxt" maxlength="20" />
							<button type="button" class="btn icn" onclick="cfnOpenBrandListPopup('fnSetBrandInfo', 'M');"><i class="fa fa-search"></i></button>
							<span id="brandCdTxt"></span>
							<input type="hidden" name="brandCdList"/>
						</td>
						<th>품목</th>
						<td>
							<input type="text" class="w100" name="itemkindCdSearchTxt" id="itemkindCdSearchTxt" maxlength="20" />
							<button type="button" class="btn icn" onclick="cfnOpenItemkindListPopup('fnSetItemkindInfo', 'M');"><i class="fa fa-search"></i></button>
							<span id="itemkindCdTxt"></span>
							<input type="hidden" name="itemkindCdList"/>
						</td>
					</tr>
				</table>

				<ul class="panelBar">
					<li class="center">
						<button type="button" class="btn btn-base btn-lg" id="btnSearch">조회</button>
						<button type="button" class="btn btn-gray btn-lg" id="btnInit">초기화</button>
					</li>
				</ul>
			</form>
		</div>
		<!-- 검색조건 영역 -->

		<!-- 리스트 영역 -->
		<div class="panelStyle">
			<ul class="panelBar">
				<li>
					<button type="button" class="btn btn-default btn-lg" onclick="fnExcelDownLoad();">엑셀다운로드</button>
				</li>
			</ul>
			<div id="gridList" style="width: 100%; height: 470px" class="ag-theme-balham"></div>
		</div>
		<!-- //리스트 영역 -->
	</div>

<style>
.ag-header-group-text{
	margin-left: calc(50% - 25px);
}
</style>
<script th:inline="javascript">
/*<![CDATA[*/
	let columnDefs = [
		{ headerName: "브랜드번호", field: "brandCd", width: 100, cellClass: 'text-center' },
		{ headerName: "브랜드명", field: "brandEnm", width: 180, cellClass: 'text-center'},
		{ headerName: "브랜드 매출액", field: "", width: 120, cellClass: 'text-right',
			children: [
				{headerName: "총매출액(A+B+C)", field: "totAmt", width: 120, cellClass: 'text-center',
					cellRenderer: function(params) {
						return !gagajf.isNull(params.value) ? params.value.addComma() : '0';
					}
				},
				{headerName: "판매 개수", field: "sellQty", width: 120, cellClass: 'text-right',
					cellRenderer: function(params) {
						return !gagajf.isNull(params.value) ? params.value.addComma() : '0';
					}
				},
				{headerName: "YOY(%)", field: "yoyRate", width: 100, cellClass: 'text-right',
					cellRenderer: function(params) {
						return params.value +'%';
					}
				},
			]
		},
		{ headerName: "매출 현황", field: "", width: 100, cellClass: 'text-center',
			children: [
				{headerName: "자사몰 매출액(A)", field: "selfmallAmt", width: 120, cellClass: 'text-right',
					cellRenderer: function (params) {
						return !gagajf.isNull(params.value) ? params.value.addComma() : '0';
					}
				},
				{headerName: "제휴몰 매출액(B)", field: "extmallAmt", width: 150, cellClass: 'text-right',
					cellRenderer: function (params) {
						return !gagajf.isNull(params.value) ? params.value.addComma() : '0';
					}
				},
				{headerName: "취/반품액(C)", field: "cnclAmt", width: 150, cellClass: 'text-right',
					cellRenderer: function (params) {
						return !gagajf.isNull(params.value) ? params.value.addComma() : '0';
					}
				},
			]
		},
		{ headerName: "정상이월 결제비중", field: "", width: 100, cellClass: 'text-center',
			children: [
				{headerName: "정상", field: "totAmt10", width: 150, cellClass: 'text-right',
					cellRenderer: function (params) {
						return !gagajf.isNull(params.value) ? params.value.addComma() : '0';
					}
				},
				{headerName: "이월", field: "totAmt20", width: 120, cellClass: 'text-right',
					cellRenderer: function (params) {
						return !gagajf.isNull(params.value) ? params.value.addComma() : '0';
					}
				},
				{headerName: "정상비", field: "amtRate10", width: 100, cellClass: 'text-right',
					cellRenderer: function(params) {
						return params.value +'%';
					}
				}
			]
		},
	];

	let gridOptions = gagaAgGrid.getGridOptions(columnDefs);

	// Row Click
	gridOptions.onCellClicked = function(event) {
		var goodsCd = event.data.goodsCd;
		if (event.colDef.field == "goodsCd"){
			cfnOpenGoodsDetailPopup('U',goodsCd);
		}
		if (event.colDef.field == "goodsNm"){
			cfnOpenGoodsDetailPopup('U',goodsCd);
		}
	}

    gridOptions.excelStyles = [
        {
            id: 'text-center',
            dataType: 'string',
			font: {size : 10, bold: false}
        },
        {
            id: 'text-left',
            dataType: 'string',
			font: {size : 10, bold: false}
        },
        {
            id: 'text-right',
            dataType: 'number',
			font: {size : 10, bold: false}
        }
    ];

    var fnExcelDownLoad = function(){

    	var totalRows = gridOptions.api.getDisplayedRowCount();
		if(totalRows==0){
			mcxDialog.alert('조회된 내역이 없습니다.');
			return;
		}

    	var date = new Date().format("YYYYMMDDHHmmss");
		var params = {
						fileName : "브랜드별 주문목록_"+ date,
						sheetName: "DATA"
					 };
		gridOptions.api.exportDataAsExcel(params);
    }

	// 제휴몰 조회 팝업에서 호출
	var fnSetExtmallInfo = function(result) {
		var arrExtmallId = [];
		var extmallIdTxt = "";
		var sIndex = 0;
		$('#extmallIdTxt').html('');
		$('#searchForm input[name=extmallIdSearchTxt]').val('');

		result.forEach(function(extmall) {
			sIndex++;
			arrExtmallId.push(extmall.extmallId);
		});

		// 조회 값이 하나일 경우 화면에 코드 노출. 그 외는 갯수 처리
		if (sIndex == 1) {
			$('#searchForm input[name=extmallIdSearchTxt]').val(arrExtmallId[0]);
		} else {
			extmallIdTxt = sIndex + " 개";
			$('#extmallIdTxt').html(extmallIdTxt);
		}

		var jsonData = JSON.stringify(arrExtmallId);
		$("#searchForm input[name=extmallIdList]").val(arrExtmallId.join(','));
	}

	// 업체 조회 팝업에서 호출
	var fnSetSupplyCompInfo = function(result) {
		var arrSupplyCompCd = [];
		var supplyCompCdTxt = "";
		var sIndex = 0;
		$('#supplyCompCdTxt').html('');
		$('#searchForm input[name=supplyCompCdSearchTxt]').val('');

		result.forEach(function(supplyComp) {
			sIndex++;
			arrSupplyCompCd.push(supplyComp.supplyCompCd);
		});

		// 조회 값이 하나일 경우 화면에 코드 노출. 그 외는 갯수 처리
		if (sIndex == 1) {
			$('#searchForm input[name=supplyCompCdSearchTxt]').val(arrSupplyCompCd[0]);
		} else {
			supplyCompCdTxt = sIndex + " 개";
			$('#supplyCompCdTxt').html(supplyCompCdTxt);
		}

		var jsonData = JSON.stringify(arrSupplyCompCd);
		$("#searchForm input[name=supplyCompCdList]").val(arrSupplyCompCd.join(','));
	}

	// 제휴채널 조회 팝업에서 호출
	var fnSetAfLinkInfo = function(result) {
		var arrAfLinkCd = [];
		var afLinkCdTxt = "";
		var sIndex = 0;
		$('#afLinkCdTxt').html('');
		$('#searchForm input[name=afLinkCdSearchTxt]').val('');

		result.forEach(function(afLink) {
			sIndex++;
			arrAfLinkCd.push(afLink.afLinkCd);
		});

		// 조회 값이 하나일 경우 화면에 코드 노출. 그 외는 갯수 처리
		if (sIndex == 1) {
			$('#searchForm input[name=afLinkCdSearchTxt]').val(arrAfLinkCd[0]);
		} else {
			afLinkCdTxt = sIndex + " 개";
			$('#afLinkCdTxt').html(afLinkCdTxt);
		}

		var jsonData = JSON.stringify(arrAfLinkCd);
		$("#searchForm input[name=afLinkCdList]").val(arrAfLinkCd.join(","));
	}

	// 브랜드 조회 팝업에서 호출
	var fnSetBrandInfo = function(result) {
		var arrBrandCd = [];
		var brandCdTxt = "";
		var bIndex = 0;
		$('#brandCdTxt').html('');
		$('#searchForm input[name=brandCdSearchTxt]').val('');

		result.forEach(function(brand){
			bIndex++;
			arrBrandCd.push(brand.brandCd);
		});

		// 조회 값이 하나일 경우 화면에 코드 노출. 그 외는 갯수 처리
		if (bIndex == 1) {
			$('#searchForm input[name=brandCdSearchTxt]').val(arrBrandCd[0]);
		} else {
			brandCdTxt = bIndex + " 개";
			$('#brandCdTxt').html(brandCdTxt);
		}

		var jsonData = JSON.stringify(arrBrandCd);
		$("#searchForm input[name=brandCdList]").val(arrBrandCd.join(","));
	}

	// 품목 조회 팝업에서 호출
	var fnSetItemkindInfo = function(result) {
		var arrItemkindCd = [];
		var itemkindCdTxt = "";
		var bIndex = 0;
		$('#itemkindCdTxt').html('');
		$('#searchForm input[name=itemkindCdSearchTxt]').val('');

		result.forEach(function(itemkind){
			bIndex++;
			arrItemkindCd.push(itemkind.itemkindCd);
		});

		// 조회 값이 하나일 경우 화면에 코드 노출. 그 외는 갯수 처리
		if (bIndex == 1) {
			$('#searchForm input[name=itemkindCdSearchTxt]').val(arrItemkindCd[0]);
		} else {
			itemkindCdTxt = bIndex + " 개";
			$('#itemkindCdTxt').html(itemkindCdTxt);
		}

		var jsonData = JSON.stringify(arrItemkindCd);
		$("#searchForm input[name=itemkindCdList]").val(arrItemkindCd.join(','));
	}

	// 검색
	$('#btnSearch').on('click', function() {
		// 입력 값 체크
		if (!gagajf.validation($('#searchForm')))
			return false;

		gagaAgGrid.fetch($('#searchForm').prop('action'), gridOptions, '#searchForm', fnCreateTotal);
	});

	// 합계 생성
	let fnCreateTotal = function() {

		let totInfo = {};
		totInfo.brandCd     = 'TOTAL';
		totInfo.totAmt      = 0;
		totInfo.sellQty     = 0;
		totInfo.selfmallAmt = 0;
		totInfo.extmallAmt  = 0;
		totInfo.cnclAmt     = 0;
		totInfo.totAmt10    = 0;
		totInfo.totAmt20    = 0;
		totInfo.yoyRate     = 0;
		totInfo.yoyTotOrdAmt= 0;

		gridOptions.api.forEachNode(function(rowNode, index) {
			if (!rowNode.group) {
				if( typeof rowNode.data.totAmt      == 'number') { totInfo.totAmt       += rowNode.data.totAmt      ; }
				if( typeof rowNode.data.sellQty     == 'number') { totInfo.sellQty      += rowNode.data.sellQty     ; }
				if( typeof rowNode.data.selfmallAmt == 'number') { totInfo.selfmallAmt  += rowNode.data.selfmallAmt ; }
				if( typeof rowNode.data.extmallAmt  == 'number') { totInfo.extmallAmt   += rowNode.data.extmallAmt  ; }
				if( typeof rowNode.data.cnclAmt     == 'number') { totInfo.cnclAmt      += rowNode.data.cnclAmt     ; }
				if( typeof rowNode.data.totAmt10    == 'number') { totInfo.totAmt10     += rowNode.data.totAmt10    ; }
				if( typeof rowNode.data.totAmt20    == 'number') { totInfo.totAmt20     += rowNode.data.totAmt20    ; }
				if( typeof rowNode.data.yoyTotOrdAmt== 'number') { totInfo.yoyTotOrdAmt += rowNode.data.yoyTotOrdAmt; }
			}
		});

		/*if(totInfo.totAmt > 0 && totInfo.yoyTotOrdAmt > 0){
			totInfo.yoyRate = (totInfo.totAmt / totInfo.yoyTotOrdAmt * 100 - 100).toFixed(1);
		}else{
			totInfo.yoyRate = 0;
		}*/

		var mod = 1;
		if(totInfo.yoyTotOrdAmt > 0) mod = totInfo.yoyTotOrdAmt;

		totInfo.yoyRate = Math.floor(totInfo.totAmt / mod * 100 * 100) / 100;

		mod = 1;
		if(totInfo.totAmt > 0) mod = totInfo.totAmt;

		totInfo.amtRate10 = Math.floor(totInfo.totAmt10 / mod * 100 * 100) / 100;

		gagaAgGrid.setPinnedRowData(gridOptions, totInfo, 'top');
	}

	// 초기화 클릭시
	$('#btnInit').on('click', function() {
		$('#searchForm')[0].reset();

		$('#extmallIdTxt').html('');
		$('#searchForm input[name=extmallIdList]').val('');
		$('#supplyCompCdTxt').html('');
		$('#searchForm input[name=supplyCompCdList]').val('');
		$('#afLinkCdTxt').html('');
		$('#searchForm input[name=afLinkCdList]').val('');
		$('#brandCdTxt').html('');
		$('#searchForm input[name=brandCdList]').val('');
		$('#itemkindCdTxt').html('');
		$('#searchForm input[name=itemkindCdList]').val('');
	});

	// 엑셀다운로드
	$('#btnExcel').on('click', function() {
		gagaAgGrid.exportToExcel('일자별주문 목록', gridOptions);
	});

	$(document).ready(function() {
		cfnCreateCalendar('#terms', 'startDt', 'endDt', true, '주문', undefined, ['btnToday']);
		$('.btnYesterday').trigger('click');

		// Create a agGrid
		gagaAgGrid.createGrid('gridList', gridOptions);

	});
/*]]>*/
</script>

</html>