"; $sgprcoc = ""; $sgsumoc = number_format($sgsumo) . "
"; $couponstring = "
$cpn 사용"; } else { $sgprcoc = ""; $sgsumoc = ""; $couponstring = ""; } $sgprcc = number_format($sgprc); $sgsumc = number_format($sgsum); $shoprecordlist .= << $count $gdn $couponstring $sgprcoc $sgprcc
($gdbnsc) $sgq $sgsumoc $sgsumc
($gdbonusc) EOS; } function mkShopRecord(&$document, &$script, &$init, $said) { global $PSYCHEID, $PsycheAdmin; // Sales $result = mysql_query("select sa.usid, us.usname, us.ustel1, us.ustel3, us.usmail1, sa.sadate, sa.satime, sa.sasum, sa.sapoint, sa.saduedate, sa.pmid, pm.pmname, pm.pmnumber, pm.pmetc, pm.pmtype, sa.sapayer, sa.samemo, sa.sastat from sales as sa left join users as us on sa.usid = us.usid left join paymethods as pm on sa.pmid = pm.pmid where sa.said = '$said'"); list( $usid, $usname, $ustel1, $ustel3, $usmail1, $sadate, $satime, $sasum, $sapoint, $saduedate, $pmid, $pmname, $pmnumber, $pmetc, $pmtype, $sapayer, $samemo, $sastat ) = mysql_fetch_row($result); if ($usid != $PSYCHEID && !$PsycheAdmin) { header("Location: shophistory.php"); return; } $sasum += 0; $sapoint += 0; $sadate2 = str_replace("-", "", $sadate); // Delivery $result = mysql_query("select dl.dlname, dl.dltel1, dl.dltel3, dl.dlzipcode, dl.dladdress, dl.dlmemo, dl.dcid, dc.dcname, dl.dlnumber from delivery as dl left join dlcompany as dc on dl.dcid = dc.dcid where dl.said = '$said'"); list($dlname, $dltel1, $dltel3, $dlzipcode, $dladdress, $dlmemo, $dcid, $dcname, $dlnumber) = mysql_fetch_row($result); // SaGoods $result = mysql_query("select sg.gdid, gd.gdname, gd.gdtype, sg.sgpriceo, sg.sgprice, sg.sgqty, sg.sgsumo, sg.sgsum, gd.gdbonus, sg.ciid, cp.cpname from sagoods as sg left join goods as gd on sg.gdid = gd.gdid left join cpissue as ci on sg.ciid = ci.ciid left join coupon as cp on ci.cpid = cp.cpid where sg.said = '$said'"); $hasESD = false; $hasPACK = false; $count = 0; $sgtotal = 0; while ( list($gdid, $gdn, $gdtp, $sgprco, $sgprc, $sgq, $sgsumo, $sgsum, $gdbns, $cii, $cpn) = mysql_fetch_row($result) ) { $sgprco += 0; $sgprc += 0; $sgq += 0; $sgsumo += 0; $sgsum += 0; $gdbns += 0; switch ($gdtp) { case "P": $hasPACK = true; break; case "E": $hasESD = true; break; case "M": $hasESD = true; $hasPACK = true; break; } $totalsumo += $sgsumo; $gdbonus = $gdbns * $sgq; $totalgdbonus += $gdbonus; $sgtotal += $sgsum; mkShopRecordRow( $shoprecordlist, $gdid, $gdn, $sgprco, $sgprc, $sgq, $sgsumo, $sgsum, $gdbns, $gdbonus, $cpn, $cii, $cpprc, $cprt, $idx, ++$count, $usid ); } $totaloff = $totalsumo - $sgtotal; $totalsumoc2 = number_format($totalsumo); $sasumc = number_format($sasum); $totaloffc = number_format($totaloff); $totalgdbonusc = number_format($totalgdbonus); if ($sasum == $totalsumo) { $totalsumoc = ""; $totaloffstring = ""; } else { $totalsumoc = number_format($totalsumo) . "
"; if ($totaloff) { $totaloffstring = " - 할인금액 " . number_format($totaloff) . "원"; } if ($sapoint) { $sapointc = number_format($sapoint); $sapointstring = " - 적립금 {$sapointc}원"; $usingpointstring = <<
사용 적립금 {$sapointc}원
EOS; } } # sastat: O 주문접수, C 승인, # G 배송중(택배 시스템과 연계되면 활용), # F 배송완료, X 취소 switch ($sastat) { case "O": $dlstatstring = "배송전"; $ststatstring = "결제전"; $dlimagearray = array( "delivery_011.gif", "delivery_02.gif", "delivery_03.gif", "delivery_04.gif" ); break; case "C": $dlstatstring = "상품준비중"; $ststatstring = "결제완료"; $dlimagearray = array( "delivery_011.gif", "delivery_021.gif", "delivery_031.gif", "delivery_04.gif" ); break; case "F": $dlstatstring = "배송완료"; $ststatstring = "결제완료"; $dlimagearray = array( "delivery_011.gif", "delivery_021.gif", "delivery_031.gif", "delivery_041.gif" ); break; default: // "X" $dlstatstring = "주문취소"; $ststatstring = "주문취소"; $dlimagearray = array( "delivery_01.gif", "delivery_02.gif", "delivery_03.gif", "delivery_04.gif" ); } $settleinfo = << 결제상황 $ststatstring 총결제금액 {$sasumc}원 ( = 상품합계 {$totalsumoc2}원{$totaloffstring}{$sapointstring}) EOS; if ($pmtype == "C") { $pmidstring = "$pmname ($pmetc)"; if ($sastat == "O" && $sasum > 0) { $pmidstring .= <<[다시 결제하기] EOS; } $script .= << 결제방법 $pmidstring EOS; } else { $pmidstring = "$pmname ($pmnumber   $pmetc)"; $settleinfo .= << 결제방법 무통장입금 입금은행 $pmidstring 입금예정일 $saduedate 입금자성명 $sapayer EOS; } if ($hasESD) { $hasesdstring = <<
고객님께서 현재 주문하신 상품에는 다운로드 상품이 포함되어 있습니다.

그러므로 별도의 배송 과정 없이,
구매 결제 완료 직후, [내정보] 페이지에서 다운로드 받을 수 있습니다.

구입하신 다운로드 상품의 경우, 해당 다운로드 횟수와 설치 횟수가 제한되어 있습니다. 제한 횟수를 초과하면 소정의 정품사용자 확인 과정을 거쳐 초기화 받으셔야 합니다. 이점 충분히 참고하셔서 구매와 이용에 착오없으시길 바랍니다.

EOS; } if ($hasPACK) { if ($dcid) { $deliverystring = <<($dcname $dlnumber) EOS; $script .= <<
 
 
배송상황 $dlstatstring $deliverystring
수취인이름 $dlname
전화번호 $dltel1
핸드폰번호 $dltel3
우편번호 $dlzipcode
주소 $dladdress
배송시 요청사항 $dlmemo
EOS; } $document['main'] = << {$document['leftmenu']}
홈 > 쇼핑몰 > 주문/배송 조회

$usname님께서 주문하신 상품입니다.
$shoprecordlist
$usingpointstring
$totalsumoc $sasumc    
[배송 개시 후 20일 이후에 {$totalgdbonusc}원의 적립금이 적립됩니다.]

 
주문번호 $sadate2-$said
주문일시 $sadate $satime
주문자이름 $usname
전화번호 $ustel1
핸드폰번호 $ustel3
E-Mail $usmail1

$haspackstring $hasesdstring

 
$settleinfo


{$document['rightbanner']} EOS; } ## Start if (!$PSYCHEID) { header("Location: https://www.prosigner.com/member/signin.php?from=$ReqURI"); return; } if (!$said) { header("Location: shophistory.php"); return; } mkShopRecord($document, $script, $init, $said); require "shop_template.php"; ?>