|
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/toadmin/cal_good/ |
Upload File : |
<?
include "../include/top_iframe.html";
include "_common.html";
// 행사,여행예약 정산 클래스
$classGoodResEvCal = new GoodResEvCal();
// 예약정보
$res_data = res_good_master(" and res_no='{$res_no}' ");
$row = $res_data[0];
// 정산정보
//$acc_data = acc_good_date_res($res_no);
$acc_data = $classGoodResEvCal->acc_good_date_res($res_no);
// 행사정보
$data_ev = date_list("","none"," and d_uid='{$row[ev_uid]}' ");
$row_ev = $data_ev[0];
// 정산 수지계산 정보
$dataAccPaper = $classGoodResEvCal->to_paper_acc_report("",$res_no);
?>
<div class="iframe ma0">
<div class="popbox">
<!-- 본문 -->
<div class="title">예약정보</div>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="setting_write tbl_center mb30">
<colgroup>
<col width="10%" />
<col />
<col />
<col width="10%" />
<col width="8%" />
<col width="8%" />
<col width="4%" />
</colgroup>
<tr>
<th>예약번호</th>
<th>상품명</th>
<th>행사명</th>
<th>출발일</th>
<th>예약자명</th>
<th>입금액</th>
<th>인원</th>
</tr>
<tr>
<td><?=$row['res_no']?></td>
<td class="txt_l"><?=$row['g_title']?></td>
<td class="txt_l"><?=$row['ev_title']?></td>
<td><?=$row['ev_start']?></td>
<td><?=$row['res_cust_nm']?></td>
<td><?=number_format($row['account']['price_total'])?></td>
<td><?=$row['inwon']?></td>
</tr>
<tr>
<th>판매액</th>
<td style="font-weight:bold;color:red;" colspan="10" class="txt_r"><?=number_format($row['price_total'])?></td>
</tr>
</table>
<div class="title">정산정보</div>
<!-- <div class="p_rel">
<span class="btn_area2">
<input class="Table_btn gray" onclick="to_dialog.ajax('good_date_res_reg.html?res_no=<?=$res_no?>','정산기장','600','400',true,true);" type="button" value="정산 기장">
</span>
</div> -->
<div class="p_rel">
<span class="btn_area2">
<input class="Table_btn gray" onclick="to_dialog.ajax('good_date_res_reg.html?res_no=<?=$res_no?>&type=TOLN','지상비','600','400',true,true);" type="button" value="지상비 정산">
<input class="Table_btn gray" onclick="to_dialog.ajax('good_date_res_reg.html?res_no=<?=$res_no?>&type=TOAI','항공비','600','400',true,true);" type="button" value="항공비 정산">
<input class="Table_btn gray" onclick="to_dialog.ajax('good_date_res_reg.html?res_no=<?=$res_no?>&type=TOET','기타경비','600','400',true,true);" type="button" value="기타경비 정산">
<input class="Table_btn gray" onclick="to_dialog.ajax('good_date_res_reg.html?res_no=<?=$res_no?>&type=TOAS','항공수익','600','400',true,true);" type="button" value="항공수익 정산">
<input class="Table_btn gray" onclick="to_dialog.ajax('good_date_res_reg.html?res_no=<?=$res_no?>&type=TOSU','기타수익','600','400',true,true);" type="button" value="기타수익 정산">
</span>
</div>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="setting_write">
<colgroup>
<col width="30px" />
<col width="150px" />
<col width="90px" />
<col width="90px" />
<col width="90px" />
<col width="90px" />
<col width="90px" />
<col width="150px" />
<col width="45px" />
</colgroup>
<tr>
<th>No.</th>
<th>거래처</th>
<th>거래발생일</th>
<th>수익항목</th>
<th>수익액</th>
<th>비용항목</th>
<th>비용액</th>
<th>출금</th>
<th>-</th>
</tr>
<?
for($i=0 ; $i<count($acc_data['list']) ; $i++)
{
$num = count($acc_data['list']) - $i;
$row = $acc_data['list'][$i];
?>
<tr>
<td><?=$num?></td>
<td><?=$row['agent_nm']?></td>
<td><?=$row['acc_dt']?></td>
<td><?=$row['revn_nm']?></td>
<td ><?=number_format($row['revn_price'])?></td>
<td><?=$row['exes_nm']?></td>
<td><?=number_format($row['exes_price'])?></td>
<td><?=$row['avnk_nm']?> <?=$row['avnk_number']?> <?=$row['avnk_owner']?></td>
<td><img src="../image/btn/icon_write.gif" style="cursor:pointer;" onclick="to_dialog.ajax('good_date_res_reg.html?res_no=<?=$res_no?>&seq=<?=$row['seq']?>','정산수정','600','400',true,true);" > <img src="../image/btn/icon_del.gif" style="cursor:pointer;" onclick="if(!confirm('정말 삭제하시겠습니까?'))return;ajax_loader('good_date_res_proc.html?SqlType=good_date_res_dele&res_no=<?=$res_no?>&seq=<?=$row['seq']?>');"></td>
</tr>
<?
}
?>
<tr>
<td colspan="4" style="text-align:center;">계</td>
<td style="font-weight:bold;color:red;text-align:center;"><?=number_format($acc_data['calu']['revn_tot'])?></td>
<td></td>
<td colspan="6" style="font-weight:bold;color:red;text-align:center;"><?=number_format($acc_data['calu']['exes_tot'])?></td>
</tr>
<tr>
<th colspan="2"><b>알선수수료</b>(=판매금액-지출(직접경비)-부가세)</th>
<td style="font-weight:bold;color:red;" colspan="10" class="txt_r"><?=number_format($dataAccPaper['알선수수료'])?></td>
</tr>
<tr>
<th colspan="2"><b>총수익</b>(=알선수수료+항공수익+기타수익-기타경비)</th>
<td style="font-weight:bold;color:red;" colspan="10" class="txt_r"><?=number_format($dataAccPaper['총수익'])?></td>
</tr>
</table>
<!-- /본문 -->
</div>
</div>
<?
include "../include/footer_iframe.html";
?>