회원님이 기부하신 후원내역을 보실 수 있습니다. 기부하신 강원대학교 발전기금은 학교와 교육발전을 위해 투명하게 운영되고 있습니다. 다시한번 깊은 감사 드립니다.
님의 납입내역조회 결과입니다. ※ 아래금액은 귀하가 현재까지 납부한 금액입니다.
번호
구분
영수증일련번호
총약정금액
총납부금액
출연일자
영수증
0){
$last=$last-1;
}else{
$last=$total_record-1;
}
}
$total_page=ceil($total_record/$num_per_page);
$total_block=ceil($total_page/$page_per_block);
$current_block=ceil($page/$page_per_block);
$first_page=$page_per_block*($current_block-1);
$last_page=$page_per_block*$current_block;
if($last_page>=$total_page) $last_page=$total_page;
$total_page=$total_record/$num_per_page;
$first = ($page-1) * $num_per_page + 1;
$last = $page * $num_per_page;
//echo $total_record."/".$total_page."/".$total_block."/".$current_block."/".$first_page."/".$last_page."/".$first."/".$last." ";
/*
$sql = "select *
from (select t.*, rownum r from
(select
A.NO_GIBUJA, A.DT_GIBU, A.GM_GIBU, A.NO_BALGEUB,
B.CD_CHAMYEO, B.CD_GIGEUM_CHUL, B.GM_YAKJEONG,
C.NM_GIBUJA
from JBJ121 A inner join JBJ114 B on A.NO_GIBUJA=B.NO_GIBUJA
inner join JBJ113 C ON A.NO_GIBUJA=C.NO_GIBUJA
where A.NO_GIBUJA=B.NO_GIBUJA and A.NO_SEQ=B.NO_SEQ $wh
order by A.NO_SEQ desc) t
where rownum <= $last )
where r >= $first
order by DT_GIBU desc
";
*/
//중복 영수증번호 제거시 활용
$sql = "select *
from (select t.*, rownum as r from
(select
A.NO_GIBUJA, A.DT_GIBU, A.GM_GIBU, A.NO_BALGEUB,
B.CD_CHAMYEO, B.CD_GIGEUM_CHUL, B.GM_YAKJEONG, row_number() over (partition by A.NO_BALGEUB order by A.DT_GIBU desc) rn
from JBJ121 A inner join JBJ114 B on A.NO_GIBUJA=B.NO_GIBUJA
where A.NO_GIBUJA=B.NO_GIBUJA and A.NO_SEQ=B.NO_SEQ $wh and A.NO_BALGEUB !='NULL'
order by A.DT_GIBU desc) t
where rownum <= $last and rn=1 )
where r >= $first
order by DT_GIBU desc
";
/*
//row_number() over (partition by A.NO_BALGEUB order by A.DT_GIBU desc) rn // and rn=1
$sql = "select *
from (select t.*, rownum as r from
(select
A.NO_GIBUJA, A.DT_GIBU, A.GM_GIBU, A.NO_BALGEUB,
B.CD_CHAMYEO, B.CD_GIGEUM_CHUL, B.GM_YAKJEONG
from JBJ121 A inner join JBJ114 B on A.NO_GIBUJA=B.NO_GIBUJA
where A.NO_GIBUJA=B.NO_GIBUJA and A.NO_SEQ=B.NO_SEQ $wh
order by A.DT_GIBU desc) t
where rownum <= $last )
where r >= $first
order by DT_GIBU desc
";
*/
$res = OCIParse($oracon, $sql);
OCIExecute($res);
$listnum=$total_record-$num_per_page*($page-1);
while(OCIFetchInto($res, &$row, OCI_ASSOC)) {
$idx = $row[NO_GIBUJA];
$paydate = $row[DT_GIBU];
$price = $row[GM_GIBU];
$receipt = $row[NO_BALGEUB];
$join_code = $row[CD_CHAMYEO];
$pay_code = $row[CD_GIGEUM_CHUL];
$yakjeong = $row[GM_YAKJEONG];
$name = $row[NM_GIBUJA];
$paydate = date("Y.m.d", strtotime($paydate));
if($receipt) {
//$receipt_msg = " ";
$receipt_msg = " ";
} else {
$receipt_msg = " ";
$receipt = " ";
}
?>
기부참여|영수증출력