|
Server : Apache System : Linux ruga7-004.fmcity.com 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : tkt_travelbus ( 1137) PHP Version : 7.0.0p1 Disable Function : mysql_pconnect Directory : /tkt_travelbus/www/admin/res_good/ |
Upload File : |
<?php
include "../../Lib/config.php";
if (($_COOKIE['MemberLevel'] == $cf['agent_level'] || $_COOKIE['MemberLevel'] == $cf['trade_level'])) {
include "../include/top_agent.html";
} else {
include "../include/top.html";
}
//모바일 전환
/*if(is_mobile()){
echo "<script>location.href='/admin/res_good/res_cal_m.html'</script>";
exit;
}*/
if (!$viewType) {
$viewType = "month";
}
/***** 달력 환경설정 (시작) *****/
// 달력 배경 설정
$cal_bg = "/js/ajaxcalendar/cal_bg.gif"; // 요일 영문 (기본)
// 달력 글자 색상
$cal_day_color = "#464646"; // 평일
// $cal_day_color = "#fff"; // 평일
$cal_sat_color = "#0066CC"; // 토요일
$cal_sat_color = "#FF0000"; // 토요일
$cal_sun_color = "#FF0000"; // 일요일(공휴일)
$cal_today_color = "#2C852C"; // 오늘
$cal_today_color = "#464646"; // 오늘
$cal_none_color = "#BBBBBB"; // 비활성일
// 마지막 날,요일 설정
$cal_lastday = array(1 => 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31); // 각 달의 마지막 날 지정
$yyoil = array("일", "월", "화", "수", "목", "금", "토"); // 요일명 지정
/***** 달력 초기화 *****/
// 오늘
$cal_now_yy = (int)date("Y");
$cal_now_mm = (int)date("m");
$cal_now_dd = (int)date("d");
// 파라메터
if (!$yy) $yy = (int)date("Y");
if (!$mm) $mm = (int)date("m");
$sdate = $sdate; // 달력 시작일
$edate = $edate; // 달력 종료일
$format = $format; // 출력 포멧
// 공통 파라메터
$cal_param = "&sdate={$sdate}&edate={$edate}&format={$format}";
// 윤년 계산을 통해 2월의 마지막 날 계산
if ($yy % 4 == 0 && $yy % 100 != 0 || $yy % 400 == 0) {
$cal_lastday[2] = 29;
}
// 전해까지 평년 기준으로 날짜수 계산 및 윤년의 횟수를 더함
$cal_total = ($yy - 1) * 365 + (int)(($yy - 1) / 4) - (int)(($yy - 1) / 100) + (int)(($yy - 1) / 400);
// 해당월의 1일
for ($i = 1; $i < $mm; $i++) {
$cal_total += $cal_lastday[$i]; // 전달까지의 날짜수 더함
}
$cal_total++; // 그 달의 1일
$cal_startday = $cal_total % 7; // 시작 요일을 구함 (0:일요일,...,6:토요일)
// 해당월의 마지막 날짜
$cal_endday = $cal_lastday[$mm];
// DB용 년월 (YYYY-MM);
$cur_month = $yy . "-" . str_pad($mm, 2, "0", STR_PAD_LEFT);
/***** 이전달, 다음달 *****/
if ($mm == 12) {
$cal_ny = $yy + 1; // 다음년
$cal_nm = 1; // 다음월
$cal_py = $yy; // 이전년
$cal_pm = $mm - 1; // 이전월
} elseif ($mm == 1) {
$cal_ny = $yy;
$cal_nm = $mm + 1;
$cal_py = $yy - 1;
$cal_pm = 12;
} else {
$cal_ny = $yy;
$cal_nm = $mm + 1;
$cal_py = $yy;
$cal_pm = $mm - 1;
}
//p($cal_ny);
//p($cal_nm);
//p($cal_py);
//p($cal_pm);
// 링크
$cal_prev_href = "document.location.href = '{$PHP_SELF}?yy={$cal_py}&mm={$cal_pm}';"; // 이전달
$cal_next_href = "document.location.href ='{$PHP_SELF}?yy={$cal_ny}&mm={$cal_nm}';"; // 다음달
//거래처 목록 가져오기
$tbName = "TB_RES_GOOD";
// p($yy);
// p($mm);
$srchMm = $mm;
if(strlen($srchMm) == 1){
$srchMm = '0'.$srchMm;
}
$srchData = $yy.'-'.$srchMm;
$data = array();
$producerNameList = array();
//공급처 목록 가져온다.
$sql = "SELECT mb_id, bz_corp_nm, bz_nat FROM TB_MEMBER WHERE mb_level = 12 AND del_flag = 'N'";
$res = db_query($sql);
$producerResList = array('tk');
$koreaCompanyList = array();
$koreaCompanyIdList = array();
$foreignCompanyList = array();
while($dataRow = db_fetch_array($res)){
array_push($producerResList, $dataRow['mb_id']);
$producerNameList[$dataRow['mb_id']] = $dataRow['bz_corp_nm'];
if($dataRow['bz_nat'] == 'KO'){
array_push($koreaCompanyIdList, $dataRow['mb_id']);
$koreaCompanyList[$dataRow['bz_corp_nm']] = $dataRow;
}else{
$foreignCompanyList[$dataRow['bz_corp_nm']] = $dataRow;
}
}
ksort($koreaCompanyList);
ksort($foreignCompanyList);
//p($koreaCompanyList);
//p($foreignCompanyList);
//exit;
//tk트래블 추가
$producerNameList['tk'] = 'TRAVEL BUS';
//p($producerResList);
//p($producerNameList);
//exit;
$profitTotal = 0;
$calcuTotal = 0;
$producerCalcuData = array();
//예약수 별 정렬위함
$sql = "SELECT agent_id, count(*) AS cnt FROM {$tbName} WHERE ev_start LIKE '{$srchData}%' AND res_stat_cd = 'C' AND order_state IN ('B','F') AND agent_id NOT IN ('tourboss') GROUP BY agent_id ORDER BY cnt DESC";
$res = db_query($sql);
while($dataRow = db_fetch_array($res)){
if($dataRow['agent_id'] == ''){
$dataRow['agent_id'] = 'tk';
}
$producerCalcuData[$dataRow['agent_id']] = array();
}
//출발일 기준 확정예악된 tk,여행대장이 아닌 데이터 가져온다.
$sql = "SELECT agent_id,sales_total,agent_total,buy_total FROM {$tbName} WHERE ev_start LIKE '{$srchData}%' AND res_stat_cd = 'C' AND order_state IN ('B','F') AND agent_id NOT IN ('tourboss')";
//if(devCookie()){
// p($sql);
// exit;
//}
$res = db_query($sql);
$producerCalcuData['tk'] = array(
'supplyPrice' => 0,
'operatingProfit' => 0,
'nation' => 'hk',
'cnt' => 0,
'companyId' => 'tk',
);
foreach($foreignCompanyList as $itemKey => $itemValue){
$producerCalcuData[$itemValue['mb_id']] = array(
'supplyPrice' => 0,
'operatingProfit' => 0,
'nation' => $itemValue['bz_nat'],
'cnt' => 0,
// 'companyId' => $itemValue['agent_id'],
);
}
//p($producerCalcuData);
//exit;
foreach($koreaCompanyList as $itemKey => $itemValue){
// p($itemValue['mb_id']);
$producerCalcuData[$itemValue['mb_id']] = array(
'supplyPrice' => 0,
'operatingProfit' => 0,
'nation' => $itemValue['bz_nat'],
'cnt' => 0,
// 'companyId' => $itemValue['agent_id'],
);
}
if(devCookie()){
// p($producerCalcuData);
// exit;
}
while($dataRow = db_fetch_array($res)){
/*if(devCookie()){
if($dataRow['agent_id'] == ''){
p($dataRow);
}
}*/
$profit = (int) $dataRow['sales_total'];
if($dataRow['sales_total'] == 0){
$profit = (int) $dataRow['agent_total'];
}
$profit = $profit - (int) $dataRow['buy_total'];
//한국은 합계제외
//$koreaCompanyIdList
if(in_array($dataRow['agent_id'], $koreaCompanyIdList)){
}else{
//합계이익
$profitTotal += $profit;
$calcuTotal += (int) $dataRow['buy_total'];
}
//tk데이터 추가
if($dataRow['agent_id'] == ''){
if(isset($producerCalcuData['tk'])){
//원가
$producerCalcuData['tk']['supplyPrice'] += (int) $dataRow['buy_total'];
//b2b or b2c - 원가
$producerCalcuData['tk']['operatingProfit'] += (int) $profit;
$producerCalcuData['tk']['cnt'] += 1;
}else{
$producerCalcuData['tk']['supplyPrice'] = 0;
$producerCalcuData['tk']['operatingProfit'] = 0;
$producerCalcuData['tk']['cnt'] = 1;
$producerCalcuData['tk']['companyId'] = 'tk';
//원가
$producerCalcuData['tk']['supplyPrice'] += (int) $dataRow['buy_total'];
//b2b or b2c - 원가
$producerCalcuData['tk']['operatingProfit'] += (int) $profit;
}
}
else if(in_array($dataRow['agent_id'], $producerResList)){
// if(devCookie()){
// p($dataRow);
// exit;
// }
if(isset($producerCalcuData[$dataRow['agent_id']])){
//원가
$producerCalcuData[$dataRow['agent_id']]['supplyPrice'] += (int) $dataRow['buy_total'];
//b2b or b2c - 원가
$producerCalcuData[$dataRow['agent_id']]['operatingProfit'] += (int) $profit;
$producerCalcuData[$dataRow['agent_id']]['cnt'] += 1;
$producerCalcuData[$dataRow['agent_id']]['companyId'] = $dataRow['agent_id'];
}else{
$producerCalcuData[$dataRow['agent_id']]['supplyPrice'] = 0;
$producerCalcuData[$dataRow['agent_id']]['operatingProfit'] = 0;
$producerCalcuData[$dataRow['agent_id']]['companyId'] = $dataRow['agent_id'];
//원가
$producerCalcuData[$dataRow['agent_id']]['supplyPrice'] += (int) $dataRow['buy_total'];
//b2b or b2c - 원가
$producerCalcuData[$dataRow['agent_id']]['operatingProfit'] += (int) $profit;
$producerCalcuData[$dataRow['agent_id']]['cnt'] = 1;
}
}
}
$producerCalcuDataTemp = $producerCalcuData;
//데이터가 없으면 제거
$producerCalcuData = array();
foreach($producerCalcuDataTemp as $itemKey => $itemValue){
if($itemValue['supplyPrice'] != 0 || $itemValue['operatingProfit'] != 0){
$producerCalcuData[$itemKey] = $itemValue;
}
}
$korProducerCalcuData = array();
$foreProducerCalcuData = array();
foreach($producerCalcuData as $key => $value){
if($value['nation'] == 'KO'){
$korProducerCalcuData[$key] = $value;
}else{
$foreProducerCalcuData[$key] = $value;
}
}
// p($korProducerCalcuData);
// p($foreProducerCalcuData);
$producerCalcuData = array();
foreach($foreProducerCalcuData as $key => $value){
$producerCalcuData[$key] = $value;
}
foreach($korProducerCalcuData as $key => $value){
$producerCalcuData[$key] = $value;
}
?>
<style>
/*.left_wrap{display:none}*/
.view_content {
clear: both;
float: left;
width: 100%;
margin-top: 5px
}
.view_content .ev_list {
clear: both;
float: left;
width: 99%;
_background: pink;
height: 18px;
margin-bottom: 1px;
overflow: hidden;
margin-left: -5px;
padding-left: 3px;
border-radius: 5px;
padding-top: 3px;
padding-bottom: 2px
}
.view_content .ev_list a {
clear: none;
float: left;
overflow: hidden;
height: 18px;
width: 88%
}
.view_content .ev_list a img {
float: left;
margin-top: 3px;
padding-bottom: 1px
}
.view_content .ev_list a .g_title {
float: left;
width: 60% !important;
height: 15px;
overflow: hidden;
padding-left: 4px
}
.view_content .ev_list a .ev_people_res_info {
float: left;
width: unset !important;
height: 15px
}
.borderBottomBlue {
border-bottom: 1px solid blue
}
.contents_detail .calendar_wrap3 .cal_t th {
background: skyblue !important;
}
/*#5ab2d9*/
.cal_t td {
position: relative;
}
.evBusResArea {
position: absolute;
top: 0;
right: 30px;
width: 175px;
height: 113px;
padding: 7px 7px 7px 6px;
border: 1px solid #f1a3a7;
border-radius: 5px;
background-color: #fff7f7;
letter-spacing: 1px;
visibility: hidden;
z-index: 1;
}
.evBusResArea textarea {
border: 1px solid #cfcfd1;
width: 100%;
height: 70px;
background: #fff;
outline-color: #40E0D0
}
.evBusResArea .saveBtn {
float: right;
border: 1px solid #000;
height: unset;
color: #fff;
background: black;
border-radius: 3px;
margin-top: 1px;
cursor: pointer
}
.closeEvBusResArea {
float: right;
border: 1px solid #000;
height: unset;
background: black;
border-radius: 3px;
width: 16px;
text-align: center;
cursor: pointer;
color: #fff;
margin-top: 1px;
margin-left: 1px
}
.checkNormalTourIcon, .checkNormalTourIconRow {
width: 20px;
margin-top: 2px
}
.normalResSettingArea {
clear: both;
float: left;
width: 100%;
padding-bottom: 2px;
padding-top: 1px;
border-bottom: 1px solid #cfcfd1
}
.normalResSettingArea .evBusResArea label, .normalResSettingArea .evBusResArea input, .normalResSettingArea .evBusResArea input[type='checkbox'] {
float: left;
}
.tm1 {
width: 21px;
height: 11px;
float: left;
margin-top: 3px;
padding-bottom: 1px;
}
/*#siteType,#srchYear,#srchMonth,#busInfoDesc ,#totalResCnt ,#privateResCnt ,#resCnt{border-radius:5px !important;padding-top:8px !important;padding-bottom:8px !important;text-align:center;background:#fff;-webkit-appearance: auto !important;}*/
#totalCalcuArea, #totalProfitArea, #siteType, #srchYear, #srchMonth, #busInfoDesc, #totalResCnt, #privateResCnt, #resCnt {
border-radius: 5px !important;
padding-top: 8px !important;
padding-bottom: 8px !important;
text-align: center;
background: #fff;
}
/*#totalResCnt ,#privateResCnt ,#resCnt{background:#fed73d}*/
/*#totalResCnt ,#privateResCnt ,#resCnt{background:rgb(252, 251, 232);}*/
/*select {
-webkit-border-radius: 0px;
background-color: #FAFAFA;
}*/
.ev_link {
width: 100%
}
.contents_detail .calendar_wrap3 .Big_cal_c {
padding-top: 14px !important;
}
.Big_cal_c {
border-bottom: 1px solid #d3d3d3;
}
.calendarBottomBoxLine {
clear: both;
float: left;
width: 100%
}
.calendarBottomBox {
float: left;
width: 100px;
height: 100px;
background: lightcoral
}
.busTourResCompletedColor {
float: left;
display: block;
z-index: 999999999;
width: 20px;
height: 20px;
margin-right: 2px;
margin-top: 2px;
cursor: pointer
}
#listArea ul li .resDataArea .dayArea .holiday {
color: red
}
#tourTypeList {
float: right;
margin-top: -38px;
margin-right: 17px;
padding: 5px 10px;
border: 1px solid #cfcfd1;
border-radius: 5px !important;
padding-top: 8px !important;
padding-bottom: 8px !important;
text-align: center;
background: #fff;
-webkit-appearance: auto !important;
}
#tourTypeList ul {
float: left;
width: 100%
}
#tourTypeList li {
float: left
}
#tourTypeList li div, #tourTypeList li p {
float: left
}
#tourTypeList li div {
width: 25px;
height: 20px;
border-radius: 5px;
margin: 0 5px;
}
#tourTypeList li p {
font-size: 13px;
position: relative;
top: 2px;
margin-right: 3px;
font-weight: bold
}
.contents_detail .calendar_wrap3 {
background-color: #edf0f5;
}
#calendarViewType {
cursor: pointer;
overflow: hidden;
margin-left: 8px;
border-radius: 5px !important;
float: right;;
padding: 0px 0px;
border: 1px solid #cfcfd1;
background: #fff;
}
#calendarViewType div {
float: left;
height: 32px;
}
#calendarViewType div p {
width: unset;
position: relative;
top: 8px;
font-size: 12px;
font-weight: bold;
}
#calendarViewType div:nth-child(1) {
border-right: 1px solid #cfcfd1;
padding-right: 14px;
padding-left: 14px
}
#calendarViewType div:nth-child(2) {
padding-left: 14px;
padding-right: 14px;
}
#calendarViewType .on {
color: #fff;
background: #1d1d1d
}
#calendarViewType .on p {
color: #fff
}
#totalProfitArea{float:right;margin-left: 8px;padding: 5px 10px;border: 1px solid #cfcfd1;}
#totalCalcuArea{float:right;margin-left: 8px;padding: 5px 10px;border: 1px solid #cfcfd1;}
#dataArea{clear:both;float:left;width:100%;position: relative;left: -16px;}
.producerAreaWrap{float:left;width:300px;;margin-left:25px;margin-top:30px}
.producerNameArea{float:left;width:100%;background:#3f4b5c;color:#fff;text-align:center;font-size:17px;padding:10px 0;border-top-left-radius:6px;border-top-right-radius:6px}
.producerPriceArea{float:left;width:100%;background:#fff;;border-bottom-left-radius:6px;border-bottom-right-radius:6px}
.producerSupplyPriceArea{float:left;width:149px;text-align:center;padding:10px 0}
.barLine{ float: left;
width: 1px;
height: 40px;
background: #ccc;
margin-top: 10px;}
.producerOperatingProfitArea{float:left;width:150px;text-align:center;padding:10px 0}
.producerSupplyPriceArea{float:left;width:149px;text-align:center;padding:10px 0}
.producerSupplyPriceArea b,.producerSupplyPriceArea p{clear:both;display:block;width:100% !important;}
.producerOperatingProfitArea{float:left;width:150px;text-align:center;padding:10px 0}
.producerOperatingProfitArea b,.producerOperatingProfitArea p{clear:both;display:block;width:100% !important;}
.producerSupplyPriceArea b, .producerOperatingProfitArea b{font-size:14px;color:#bbbccc}
.producerOperatingProfitArea p{color:blue}
.producerSupplyPriceArea p, .producerOperatingProfitArea p{margin-top:8px;font-size:16px !important; font-weight:bold}
.producerOperatingProfitArea p.minus{color:red !important}
.contents_detail .calendar_wrap3 .Big_cal_c .year_wrap{float:none !important;width:225px !important;margin:0 auto !important;left:0 !important;}
#typeDivLine{clear:both;float:left;width:99.5%;height:1px;background:#ccc;margin:55px 0 20px 1.5%}
#dateGoBtn{padding: 6px 10px;background: #515151;border: none;border-radius: 3px;color: #fff;}
.resCompanyCnt{position: absolute;
right: 10px;
top: 11px;
float: right;
display: inline;
width: 55px;
text-align:right;
/* background: red; */
color: #fff;
font-size: 12px}
</style>
<div class="contents_wrap">
<div class="contents_wrap_in">
<div class="contents_detail">
<div id="Content_box">
<div class="calendar_wrap3 no_line">
<div class="Big_cal_c">
<div style="float:left">
<select id="srchYear" style="width:80px;text-align-last: center; text-align: center; -ms-text-align-last: center; -moz-text-align-last: center;">
<?php
for ($i = date("Y") - 2; $i < (date("Y") + 5); $i++) {
?>
<option style="text-align:center"
value="<?= $i ?>" <?= (($yy == $i) ? 'selected' : '') ?>><?= $i ?></option>
<?php
}
?>
</select>
년
<select id="srchMonth" style="width:67px;text-align:center;text-align-last: center; text-align: center; -ms-text-align-last: center; -moz-text-align-last: center;">
<?php
for ($i = 1; $i <= 12; $i++) {
$is = $i;
if(strlen($is) == 1){
$is = '0'.$is;
}
?>
<option value="<?=$is?>" <?= (($mm == $i) ? 'selected' : '') ?>><?= $i ?></option>
<?php
}
?>
</select>
월
<button id="dateGoBtn">이동</button>
</div>
<span id="totalProfitArea">수익합계 : <?=number_format($profitTotal)?>원</span>
<span id="totalCalcuArea">정산합계 : <?=number_format($calcuTotal)?>원</span>
<div class="cal_info" style="position:absolute; left:200px;"></div>
<div class="year_wrap">
<i class="xi-caret-up-circle xi-rotate-270" alt="이전달" title="이전달"
style="cursor:pointer; font-size:26px; float:left; padding-top:3px; vertical-align:middle;"
onclick="<?= $cal_prev_href ?>" id="cal_pre_month"></i>
<p class="cal_year"><?= $yy ?>년 <?= $mm ?>월</p>
<i class="xi-caret-up-circle xi-rotate-90" alt="다음달" title="다음달"
style="cursor:pointer; font-size:26px; float:right; padding-top:3px; vertical-align:middle;"
onclick="<?= $cal_next_href ?>" id="cal_next_month"></i>
</div>
</div>
<?php
$mmGet = $mm;
if(strlen($mmGet) == 1){
$mmGet = '0'.$mmGet;
}
?>
<div id="dataArea">
<?php
$isKor = false;
foreach($producerCalcuData as $itemKey => $itemValue){
if($itemValue['nation'] == 'KO' && $isKor == false){
echo "<div id='typeDivLine'></div>";
$isKor = true;
}
?>
<a href="good_res_list.html?mode_period_s=ev_start&date_s1=<?=$yy?>-<?=$mmGet?>-01&date_s2=<?=$yy?>-<?=$mmGet?>-<?=$cal_endday?>&&period_yy_s=<?=$yy?>&period_mm_s=<?=$mmGet?>&agent_id=<?=(($itemKey == 'tk') ? 'onlyTk' : $itemKey)?>&res_stat_cd=C&order_state=BF&order_by_s=ev_start%20asc&list_count_s=10000">
<div class="producerAreaWrap box_shadow" style=";position:relative;">
<?
$bg_color = '';
if ($producerNameList[$itemKey] == '쿠팡')
{
$bg_color = "#e24921";
}
else if (($producerNameList[$itemKey] == 'NAVER 플레이스') || ($producerNameList[$itemKey] == 'NAVER 스토어'))
{
$bg_color = "#00ce36";
}
else if ($producerNameList[$itemKey] == '티몬')
{
$bg_color = "#f27935";
}
else if ($producerNameList[$itemKey] == '베네피아')
{
$bg_color = "#f88800";
}
?>
<div class="producerNameArea" style="background:<?=$bg_color?>">
<?=$producerNameList[$itemKey]?>
<p class="resCompanyCnt"><?=number_format($itemValue['cnt'])?>건</p>
</div>
<div class="producerPriceArea">
<div class="producerSupplyPriceArea">
<b>공급가</b>
<p><?=number_format($itemValue['supplyPrice'])?>원</p>
</div>
<div class="barLine"></div>
<div class="producerOperatingProfitArea">
<b>영업이익</b>
<?php
$plusMinus = "";
$plusMinusClassName = "";
if( (int) $itemValue['operatingProfit'] >= 0){
$plusMinus = "+";
$plusMinusClassName = "plus";
}else{
$plusMinus = "-";
$plusMinusClassName = "minus";
}
?>
<p class="<?=$plusMinusClassName?>"><?=$plusMinus?> <?=number_format($itemValue['operatingProfit'])?>원</p>
</div>
</div>
</div>
</a>
<?php
}
?>
</div>
<!-- 샘플 -->
<!-- //달력 테이블 -->
</div>
</div>
</div>
</div>
</div>
<script>
$(window).load(function(){
$('.producerNameArea').mouseenter(function(){
$(this).css('text-decoration','underline');
})
$('.producerNameArea').mouseleave(function(){
$(this).css('text-decoration','none');
})
$('#dateGoBtn').click(function(){
sryy = $('#srchYear').val();
srmm = $('#srchMonth').val();
location.href = '/admin/res_good/inbound_income.html?yy='+sryy+'&mm='+srmm;
})
})
</script>
<? include "../include/footer.html" ?>