0 AND' . ' t01.deposit IS NOT NULL AND' . ' t01.receipt IS NOT NULL AND' . ' t01.del IS NULL;'; $res1 = pg_query($conn, $sql); if(!$res1 || pg_num_rows($res1) == 0){ pg_close($conn); $message = mb_convert_encoding('クエリが実行できません。', 'SJIS-win', 'auto'); die($message); } $rec1 = pg_fetch_assoc($res1); $own_fname = setHtmlEscapeString(basename($_SERVER['PHP_SELF'])); //if($domestic){ //日本語 print << ITF 販売店専用サイト — 領収書

領収書


TAG_HTML; echo "\n"; echo sprintf(" No. %s
\n", setHtmlEscapeString($rec1['receipt'])); echo sprintf(" %s\n", setHtmlEscapeString( date('Y/m/d', strtotime($rec1['deposit'])) )); print <<

下記、正に領収いたしました。

TAG_HTML; echo "\n"; echo sprintf(" \n", setHtmlEscapeString($rec1['dealer_nam'])); print << TAG_HTML; echo "\n"; echo sprintf(" \n", setHtmlEscapeString($_REQUEST['oid'])); print << TAG_HTML; echo "\n"; echo sprintf(" \n", setHtmlEscapeString( date('Y/m/d', strtotime($rec1['deposit'])) )); print <<
宛先%s 様
金額 TAG_HTML; echo "\n"; $product = ''; $price = 0; $sql = 'SELECT' . ' pid,nam,als,price,amount,pkg_price,pkg_amount,discount ' . 'FROM' . ' odr_detail ' . 'WHERE' . sprintf(" oid='%s' ", pg_escape_string($conn, $_REQUEST['oid'])) . 'ORDER BY' . ' num ASC;'; $res2 = pg_query($conn, $sql); if($res2){ if(pg_num_rows($res2) > 1){ while($rec2 = pg_fetch_assoc($res2)){ if(strlen($product) == 0){ $product = setHtmlEscapeString($rec2['nam']); if(strlen($rec2['als']) > 0) $product .= sprintf(" %s", setHtmlEscapeString($rec2['als'])); $product .= sprintf(" × %s 他", setSeparatorNumeric($rec2['amount'])); } $price += ((int)$rec2['price'] * (int)$rec2['amount'] + (int)$rec2['pkg_price'] * (int)$rec2['pkg_amount']) - (int)$rec2['discount']; } } else{ $rec2 = pg_fetch_assoc($res2); $product = setHtmlEscapeString($rec2['nam']); if(strlen($rec2['als']) > 0) $product .= sprintf(" %s", setHtmlEscapeString($rec2['als'])); $product .= sprintf(" × %s", setSeparatorNumeric($rec2['amount'])); $price = ((int)$rec2['price'] * (int)$rec2['amount'] + (int)$rec2['pkg_price'] * (int)$rec2['pkg_amount']) - (int)$rec2['discount']; } } $method = '銀行振込'; if((int)$rec1['pay_method'] == 1) $method = 'クレジット'; echo sprintf("¥%s.- (税込み)\n", setSeparatorNumeric($price)); echo sprintf("
お支払い方法: %s
\n", setHtmlEscapeString($method)); print <<
注文番号%s
摘要 商品代金として
ご購入商品:  TAG_HTML; echo "\n"; echo sprintf("
%s
\n", $product); print <<
領収日%s
TAG_HTML; echo "\n"; /*} else{ //英語 print <<