- Timestamp:
- 2007/09/04 15:14:47 (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/feature-module-update/data/class/util/SC_Utils.php
r15578 r15586 1000 1000 } 1001 1001 1002 function sfGetDelivTime($payment_id = "") {1003 $objQuery = new SC_Query();1004 1005 $deliv_id = "";1006 1007 if($payment_id != "") {1008 $where = "del_flg = 0 AND payment_id = ?";1009 $arrRet = $objQuery->select("deliv_id", "dtb_payment", $where, array($payment_id));1010 $deliv_id = $arrRet[0]['deliv_id'];1011 }1012 1013 if($deliv_id != "") {1014 $objQuery->setorder("time_id");1015 $where = "deliv_id = ?";1016 $arrRet= $objQuery->select("time_id, deliv_time", "dtb_delivtime", $where, array($deliv_id));1017 }1018 1019 return $arrRet;1020 }1021 1022 1023 // 都道府県、支払い方法から配送料金を取得する1024 function sfGetDelivFee($pref, $payment_id = "") {1025 $objQuery = new SC_Query();1026 1027 $deliv_id = "";1028 1029 // 支払い方法が指定されている場合は、対応した配送業者を取得する1030 if($payment_id != "") {1031 $where = "del_flg = 0 AND payment_id = ?";1032 $arrRet = $objQuery->select("deliv_id", "dtb_payment", $where, array($payment_id));1033 $deliv_id = $arrRet[0]['deliv_id'];1034 // 支払い方法が指定されていない場合は、先頭の配送業者を取得する1035 } else {1036 $where = "del_flg = 0";1037 $objQuery->setOrder("rank DESC");1038 $objQuery->setLimitOffset(1);1039 $arrRet = $objQuery->select("deliv_id", "dtb_deliv", $where);1040 $deliv_id = $arrRet[0]['deliv_id'];1041 }1042 1043 // 配送業者から配送料を取得1044 if($deliv_id != "") {1045 1046 // 都道府県が指定されていない場合は、東京都の番号を指定しておく1047 if($pref == "") {1048 $pref = 13;1049 }1050 1051 $objQuery = new SC_Query();1052 $where = "deliv_id = ? AND pref = ?";1053 $arrRet= $objQuery->select("fee", "dtb_delivfee", $where, array($deliv_id, $pref));1054 }1055 return $arrRet[0]['fee'];1056 }1057 1058 1002 /* 配列をキー名ごとの配列に変更する */ 1059 1003 function sfSwapArray($array) {
Note: See TracChangeset
for help on using the changeset viewer.