'101904' " . $wh;
$res = OCIParse($oracon, $sql);
OCIDefineByName($res, "TOTAL_RECORD", &$tot_rec);
OCIExecute($res);
OCIFetch($res);
$total_record = $tot_rec;
OCIFreeStatement($res);
if($total_record==0){
$first=1;
$last=0;
}else{
$first=$num_per_page*($page-1);
$last=$num_per_page*$page;
$IsNext=$total_record-$last;
if($IsNext>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 ";
$sql = "SELECT *
FROM (
select AA.*, rownum r from
( SELECT A.NO_GIBUJA , A.NO_YAKJEONG, B.NM_GIBUJA , A.CONT_ETC_YONGDO, A.GM_YAKJEONG, A.CNT_GUJWA, A.DT_YAKJEONG ,B.CD_GWANGYE_HAKGYO
FROM JBJ114 A INNER JOIN JBJ113 B ON A.NO_GIBUJA = B.NO_GIBUJA
WHERE A.NO_GIBUJA <> '101904' $wh
ORDER BY A.DT_YAKJEONG DESC
) AA where rownum <= $last
) where r >= $first";
$res = OCIParse($oracon, $sql);
OCIExecute($res);
$listnum=$total_record-$num_per_page*($page-1);
while(OCIFetchInto($res, &$row, OCI_ASSOC)) {
$NO_GIGEUM = $row[NO_GIBUJA];
$NM_GIBU = $row[NM_GIBUJA];
$NO_YAKJEONG = $row[NO_YAKJEONG];
$TXT_ETC_YONGDO = $row[CONT_ETC_YONGDO];
$GM_YAKJEONG = $row[GM_YAKJEONG];
$CNT_GUJOWA = $row[CNT_GUJWA];
$DT_YAKJEONG = $row[DT_YAKJEONG];
$CD_GWANGYE_HAKGYO = $row[CD_GWANGYE_HAKGYO];
$DT_YAKJEONG = substr($DT_YAKJEONG,0,4)."-".substr($DT_YAKJEONG,4,2)."-".substr($DT_YAKJEONG,6,2);
if(trim($TXT_ETC_YONGDO) == "") {
$TXT_ETC_YONGDO = " ";
}
?>
| ** |
|
0 원 |
