@,;:".\\\\\[\]\000-\037\x80-\xff]+(?![^(\040)<>@,;:".\\\\\[\]\000-\037\x80-\xff])|"[^\\\\\x80-\xff\n\015"]*(?:\\\\[^\x80-\xff][^\\\\\x80-\xff\n\015"]*)*")(?:\.(?:[^(\040)<>@,;:".\\\\\[\]\000-\037\x80-\xff]+(?![^(\040)<>@,;:".\\\\\[\]\000-\037\x80-\xff])|"[^\\\\\x80-\xff\n\015"]*(?:\\\\[^\x80-\xff][^\\\\\x80-\xff\n\015"]*)*"))*@(?:[^(\040)<>@,;:".\\\\\[\]\000-\037\x80-\xff]+(?![^(\040)<>@,;:".\\\\\[\]\000-\037\x80-\xff])|\[(?:[^\\\\\x80-\xff\n\015\[\]]|\\\\[^\x80-\xff])*\])(?:\.(?:[^(\040)<>@,;:".\\\\\[\]\000-\037\x80-\xff]+(?![^(\040)<>@,;:".\\\\\[\]\000-\037\x80-\xff])|\[(?:[^\\\\\x80-\xff\n\015\[\]]|\\\\[^\x80-\xff])*\]))*$/', $email)){ return 1; }else{ return 0; } } session_start(); $title = "和家具 家具の七福市 注文確定"; require("./admin/common.php"); //クラスファイル取り込み require_once("./admin/my_sql.php"); //クラスインスタンス作成 $class_sql = new class_MySQL; //POSTされたとき if($_SERVER["REQUEST_METHOD"] == "POST"){ $c_code = $_POST['c_code']; $cart_no = $_POST['cart_no']; $pay_type = $_POST['pay_type']; $price_sum_s = $_POST['price_sum_s']; $carriage_s = $_POST['carriage_s']; $daibiki_s = $_POST['daibiki_s']; $all_price_s = $_POST['all_price_s']; if(isset($_POST["submit_order"])){ //注文確定 $pay_str = $_POST['pay_str']; $mail = $_POST['mail']; $name_kanji = $_POST['name_kanji']; $name_kana = $_POST['name_kana']; $post_no = $_POST['post_no']; $pref = $_POST['pref']; $addr1 = $_POST['addr1']; $addr2 = $_POST['addr2']; $tel1 = $_POST['tel1']; $tel2 = $_POST['tel2']; $bikou = $_POST['bikou']; $name_kanji2 = $_POST['name_kanji2']; $name_kana2 = $_POST['name_kana2']; $post_no2 = $_POST['post_no2']; $pref2 = $_POST['pref2']; $addr12 = $_POST['addr12']; $addr22 = $_POST['addr22']; $tel12 = $_POST['tel12']; $tel22 = $_POST['tel22']; $pay_type = $_POST['pay_type']; $card_type = $_POST['card_type']; $card_no1 = $_POST['card_no1']; $card_no2 = $_POST['card_no2']; $card_no3 = $_POST['card_no3']; $card_no4 = $_POST['card_no4']; $card_mm = $_POST['card_mm']; $card_yy = $_POST['card_yy']; $card_pay_no = $_POST['card_pay_no']; $card_name = $_POST['card_name']; $price_sum = 0; $condi_str = " WHERE (T_Cart.CCode=" . $c_code . ") AND (T_Cart.CartNo=" . $cart_no . ")"; $class_sql->sql_query("SELECT T_Cart.SeqNo,No,T_Cart.ItemCode,T_Cart.Color,T_Cart.Price,MakerItemCode,ItemName" . " FROM T_Cart LEFT JOIN TM_Item ON T_Cart.ItemSeqNo=TM_Item.SeqNo" . $condi_str . " ORDER BY T_Cart.SeqNo"); //カート内容を配列に読み込む $idx = 0; while($row = $class_sql->sql_fetch()){ $c_seq_no[$idx] = $row["SeqNo"]; $c_no[$idx] = $row["No"]; $c_item_code[$idx] = $row["ItemCode"]; $c_maker_item_cd[$idx] = $row["MakerItemCode"]; $c_item_name[$idx] = $row["ItemName"]; $c_item_color[$idx] = $row["Color"]; $c_type1[$idx] = ""; $price = $row["Price"]; $c_one_price[$idx] = $price;// + floor($price * $tax_rasio / 100); $c_price[$idx] = $c_one_price[$idx] * $c_no[$idx]; $price_sum += $c_price[$idx]; $idx += 1; } //注文ヘッダーを登録 $sql = "INSERT INTO T_Order (OrderDate,CCode,CartNo,Charge,Carriage,Expense,PayType,Mail, NameKanji,NameKana,PostNo,AddrPref,Addr1,Addr2,Tel1,Tel2, NameKanji2,NameKana2,PostNo2,AddrPref2,Addr12,Addr22,Tel12,Tel22, CardType,CardNo,CardM,CardY,CardPayCount,CardName) VALUES ( '" . date( 'Y-m-d H:i:s' ) . "', " . get_sql_string_int_0($c_code) . ", " . get_sql_string_int_0($cart_no) . ", " . get_sql_string_int_0($charge) . ", " . get_sql_string_int_0($carriage) . ", " . get_sql_string_int_0($expense) . ", " . get_sql_string_int_0($pay_type) . ", " . get_sql_string_text($mail) . ", " . get_sql_string_text($name_kanji) . ", " . get_sql_string_text($name_kana) . ", " . get_sql_string_text($post_no) . ", " . get_sql_string_text($pref) . ", " . get_sql_string_text($addr1) . ", " . get_sql_string_text($addr2) . ", " . get_sql_string_text($tel1) . ", " . get_sql_string_text($tel2) . ", " . get_sql_string_text($name_kanji2) . ", " . get_sql_string_text($name_kana2) . ", " . get_sql_string_text($post_no2) . ", " . get_sql_string_text($pref2) . ", " . get_sql_string_text($addr12) . ", " . get_sql_string_text($addr22) . ", " . get_sql_string_text($tel12) . ", " . get_sql_string_text($tel22) . ", " . get_sql_string_text($card_type) . ", " . get_sql_string_text($card_no1 . "-" . $card_no2 . "-" . $card_no3 . "-" .$card_no4) . ", " . get_sql_string_text($card_mm) . ", " . get_sql_string_text($card_yy) . ", " . get_sql_string_int_0($card_pay_no) . ", " . get_sql_string_text($card_name) . ")"; $class_sql->sql_query($sql); $order_no = mysql_insert_id(); //注文詳細を登録 $idx2 = 0; while($idx2 < $idx){ $sql = "INSERT INTO T_OrderDetail (OrderNo,CCode,CartNo,ItemCode,Color,Type1,No,OnePrice,Price) VALUES ( " . get_sql_string_int_0($order_no) . ", " . get_sql_string_int_0($c_code) . ", " . get_sql_string_int_0($cart_no) . ", " . get_sql_string_text($c_item_code[$idx2]) . ", " . get_sql_string_text($c_item_color[$idx2]) . ", " . get_sql_string_text($c_type1[$idx2]) . ", " . get_sql_string_int_0($c_no[$idx2]) . ", " . get_sql_string_text($c_one_price[$idx2]) . ", " . get_sql_string_text($c_price[$idx2]) . ")"; $class_sql->sql_query($sql); $idx2 += 1; } //カート内容を削除 $idx2 = 0; while($idx2 < $idx){ $sql = "DELETE FROM T_Cart WHERE SeqNo=$c_seq_no[$idx2]"; $class_sql->sql_query($sql); $idx2 += 1; } //メール送信 $admin_subject = "七福市売上\r\n"; $subject = "ご注文ありがとうございます。【七福市】\r\n"; $headers = "From: $support_mail\r\n"; // $body = $name_kanji . " 様\r\n\r\n" . "この度はご注文いただきまして誠にありがとうございました。\r\n"; $body .= "以下はご注文の内容です。\r\nもし誤りや変更がございましたら末尾の連絡先までご連絡ください。\r\n\r\n"; //$admin_body = $name_kanji . " 様\r\n"; $addr_str = "Mail:" . $mail . "\r\n\r\n"; $addr_str .= "〒" . $post_no . "\r\n"; $addr_str .= $pref . " " . $addr1 . "\r\n"; if($addr2 != ""){ $addr_str .= $addr2 . "\r\n"; } if($tel1 != ""){ $addr_str .= "TEL:" . $tel1 . "\r\n"; } if($tel2 != ""){ $addr_str .= "TEL:" . $tel2 . "\r\n"; } $addr_str .= $name_kanji . " 様\r\n\r\n"; if(($name_kanji2 != "") || ($addr12 != "")){ $addr_str .= "送り先\r\n"; $addr_str .= "〒" . $post_no2 . "\r\n"; $addr_str .= $pref2 . " " . $addr12 . "\r\n"; if($addr22 != ""){ $addr_str .= $addr22 . "\r\n"; } if($tel12 != ""){ $addr_str .= "TEL:" . $tel12 . "\r\n"; } if($tel22 != ""){ $addr_str .= "TEL:" . $tel22 . "\r\n"; } $addr_str .= $name_kanji2 . " 様\r\n\r\n"; } if($bikou != ""){ $addr_str .= "特記事項:" . $bikou . "\r\n"; } $body .= $addr_str; $admin_body = $addr_str; $idx2 = 0; while($idx2 < $idx){ $price_one_s = get_num_string_3sp($c_one_price[$idx2]); $price_all_s = get_num_string_3sp($c_price[$idx2]); $body .= "商品番号:". $c_item_code[$idx2] . "‐" . $c_item_name[$idx2]; $admin_body .= "商品番号:" . $c_item_code[$idx2] . "\r\n"; $admin_body .= "仕入品番:" . $c_maker_item_cd[$idx2] . "\r\n"; $admin_body .= $c_item_name[$idx2] . "\r\n"; if($c_type1[$idx2] != ""){ $body .= "‐" . $c_type1[$idx2]; $admin_body .= "‐" . $c_type1[$idx2] . "\r\n"; } if($c_item_color[$idx2] != "-"){ $body .= "‐色:" . $c_item_color[$idx2]; $admin_body .= "色:" . $c_item_color[$idx2] . "\r\n"; } $body .= "\r\n(単価:\\" . $price_one_s . ") × (数量:" . $c_no[$idx2] . ") = (金額:\\" . $price_all_s .")\r\n"; $admin_body .= "\\" . $price_one_s . " * " . $c_no[$idx2] . " = \\" . $price_all_s . "\r\n"; $idx2 += 1; } $body .= "\r\nお買上合計額:\\" . $price_sum_s; $body .= "\r\n送料    :\\" . $carriage_s; $admin_body .= "\r\n送料:\\" . $carriage_s; if($pay_type == 0){ $body .= "\r\n代引き手数料:\\" . $daibiki_s; $admin_body .= "\r\n代手:\\" . $daibiki_s; } $body .= "\r\n税込合計金額:\\" . $all_price_s; $admin_body .= "\r\n合計:\\" . $all_price_s; $body .= "\r\n\r\nお支払方法:" . $pay_str. "\r\n"; $admin_body .= "\r\n支払:" . $pay_str. "\r\n"; if($pay_type == 1){ $body .= "お振込み先は下記のいずれかにお願いいたします。\r\n"; $body .= "商品は、ご入金確認後の発送になります。\r\n\r\n"; $body .= $leaf_bank_1_1 . "\r\n"; $body .= $leaf_bank_1_2 . "\r\n\r\n"; $body .= $leaf_bank_2_1 . "\r\n"; $body .= $leaf_bank_2_2 . "\r\n\r\n"; }elseif($pay_type == 2){ $body .= "カード:" . $card_type; $admin_body .= $card_no1 . "-" . $card_no2 . "-" . $card_no3 . "-" . $card_no4 . "\r\n"; $admin_body .= "期限:" . $card_mm . "/" . $card_yy . " 回数:" . $card_pay_no . "\r\n"; $admin_body .= $card_type . ":" . $card_name . "\r\n"; } $body .= "\r\nスタッフが在庫を確認しましたのち、注文確定のご案内をメール送信致します。" . "\r\nこの時点で正式な注文確定になります。" . "\r\n銀行振込の方は万一の行き違いを防ぐため、注文確定のご案内までお振込せずにお待ちください。" . "\r\nまた、在庫切れ等で納期に期間を要するような場合はこちらからご連絡申し上げます。" . "\r\n\r\nご利用頂きましてありがとうございました。\r\n"; $body .= "\r\n(株)りーふ TEL:0463-97-2250 FAX:0463-97-2251\r\n"; $body .= "〒259-1117 神奈川県伊勢原市東成瀬35-10アミューズ1F\r\n"; $body .= "メール:$support_mail \r\n"; $body .= "七福市:$site_url \r\n"; mb_language("ja"); mb_internal_encoding("utf-8") ; //顧客へ if($mail != ""){ mb_send_mail($mail, $subject, $body, $headers); } //管理用メール $adm_mail_1 = "k-nagatomo@lclauto.com"; if($adm_mail_1 != ""){ mb_send_mail($adm_mail_1, $subject, $body, $headers); } //管理用メール $class_sql->sql_query("SELECT Mail,Name FROM T_AdminMail WHERE Active = 1"); while($row = $class_sql->sql_fetch()){ $admin_mail = $row["Mail"]; $admin_name = $row["Name"]; if($admin_mail != ""){ mb_send_mail($admin_mail, $admin_subject, $admin_body, $headers); } } $_SESSION['err'] = ""; header( "Location: " . $ssl_url . "thanks.php"); exit; }else{ //最終確認 $mail = $_POST['mail']; $name_kanji = $_POST['name_kanji']; $name_kana = $_POST['name_kana']; $post_no = $_POST['post_no']; $pref = $_POST['pref']; $addr1 = $_POST['addr1']; $addr2 = $_POST['addr2']; $tel1 = $_POST['tel1']; $tel2 = $_POST['tel2']; $bikou = $_POST['bikou']; $name_kanji2 = $_POST['name_kanji2']; $name_kana2 = $_POST['name_kana2']; $post_no2 = $_POST['post_no2']; $pref2 = $_POST['pref2']; $addr12 = $_POST['addr12']; $addr22 = $_POST['addr22']; $tel12 = $_POST['tel12']; $tel22 = $_POST['tel22']; $pay_type = $_POST['pay_type']; $_SESSION['PriceSum'] = $price_sum_s; $_SESSION['Carriage'] = $carriage_s; $_SESSION['Daibiki'] = $daibiki_s; $_SESSION['AllPrice'] = $all_price_s; $_SESSION['Mail'] = $mail; $_SESSION['NameKanji'] = $name_kanji; $_SESSION['NameKana'] = $name_kana; $_SESSION['PostNo'] = $post_no; $_SESSION['AddrPref'] = $pref; $_SESSION['Addr1'] = $addr1; $_SESSION['Addr2'] = $addr2; $_SESSION['Tel1'] = $tel1; $_SESSION['Tel2'] = $tel2; $_SESSION['Bikou'] = $bikou; $_SESSION['NameKanji2'] = $name_kanji2; $_SESSION['NameKana2'] = $name_kana2; $_SESSION['PostNo2'] = $post_no2; $_SESSION['AddrPref2'] = $pref2; $_SESSION['Addr12'] = $addr12; $_SESSION['Addr22'] = $addr22; $_SESSION['Tel12'] = $tel12; $_SESSION['Tel22'] = $tel22; if($pay_type == 0){ $pay_str = "代引き"; }elseif($pay_type == 1){ $pay_str = "お振込み"; }else{ $pay_str = "カード"; $card_type = $_POST['card_type']; $card_no1 = $_POST['card_no1']; $card_no2 = $_POST['card_no2']; $card_no3 = $_POST['card_no3']; $card_no4 = $_POST['card_no4']; $card_mm = $_POST['card_mm']; $card_yy = $_POST['card_yy']; $card_pay_no = $_POST['card_pay_no']; $card_name = $_POST['card_name']; $_SESSION['card_type'] = $card_type; $_SESSION['card_no1'] = $card_no1; $_SESSION['card_no2'] = $card_no2; $_SESSION['card_no3'] = $card_no3; $_SESSION['card_no4'] = $card_no4; $_SESSION['card_mm'] = $card_mm; $_SESSION['card_yy'] = $card_yy; $_SESSION['card_pay_no'] = $card_pay_no; $_SESSION['card_name'] = $card_name; if(($card_mm == 0) || ($card_yy == 0) || ($card_pay_no == 0)){ $_SESSION['err'] = "card"; header( "Location: " . "payment.php?mode=2"); exit; } if(($card_type == "") || ($card_no1 == "") || ($card_no2 == "") || ($card_no3 == "") || ($card_no4 == "") || ($card_mm == "") || ($card_yy == "") || ($card_pay_no == "") || ($card_name == "")){ $_SESSION['err'] = "card"; header( "Location: " . "payment.php?mode=2"); exit; } } if(($mail == "") || ($name_kanji == "") || ($pref == "") || ($addr1 == "")){ $_SESSION['err'] = "sp"; header( "Location: " . "payment.php?mode=2"); exit; } if(valid_mail($mail) == 0){ $_SESSION['err'] = "mail"; header( "Location: " . "payment.php?mode=2"); exit; } if(($tel1 == "") && ($tel2 == "")){ $_SESSION['err'] = "sp"; header( "Location: " . "payment.php?mode=2"); exit; } $_SESSION['err'] = ""; } } require('pref_tbl.php'); require('headder_n.php'); ?>
sql_query("SELECT T_Cart.SeqNo,No,T_Cart.ItemCode,T_Cart.Color,T_Cart.Price,ItemName FROM T_Cart LEFT JOIN TM_Item ON T_Cart.ItemCode=TM_Item.ItemCode" . $condi_str . " ORDER BY T_Cart.SeqNo"); while($row = $class_sql->sql_fetch()){ $seq_no = $row["SeqNo"]; $no = $row["No"]; $item_code = $row["ItemCode"]; $item_name = $row["ItemName"]; $item_color = $row["Color"]; $price = $row["Price"]; //$price += floor($price * $tax_rasio / 100); $price_k = $price * $no; $price_sum += $price_k; $price_s = get_num_string_3sp($price); $price_k_s = get_num_string_3sp($price_k); echo << EOT; } ?>
商品コード品名単価(税込)数量金額
$item_code $item_name $item_color $price_s $no $price_k_s
 送料
 代引手数料
 税込合計金額
" method="post">
お支払い方法
カード
カード番号 ****-
カード有効期限(月/年) /
お支払い回数
カード名義

お客様情報
メールアドレス
姓名(漢字)
姓名(かな)
郵便番号
都道府県
住所1
住所2
電話
携帯
特記事項

発送先
発送先 名(漢字)
発送先 名(かな)
郵便番号
都道府県
住所1
住所2
電話
携帯




<== 前のページへ戻る