- Timestamp:
- 2012/03/09 21:14:46 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/helper/SC_Helper_DB.php
r21582 r21623 1196 1196 1197 1197 /** 1198 * 都道府県から配送料金を取得する.1199 *1200 * @param integer|array $pref_id 都道府県ID 又は都道府県IDの配列1201 * @param integer $deliv_id 配送業者ID1202 * @return string 指定の都道府県, 配送業者の配送料金1203 */1204 function sfGetDelivFee($pref_id, $deliv_id = 0) {1205 $objQuery =& SC_Query_Ex::getSingletonInstance();1206 if (!is_array($pref_id)) {1207 $pref_id = array($pref_id);1208 }1209 $sql = <<< __EOS__1210 SELECT T1.fee AS fee1211 FROM dtb_delivfee T11212 JOIN dtb_deliv T21213 ON T1.deliv_id = T2.deliv_id1214 WHERE T1.pref = ?1215 AND T1.deliv_id = ?1216 AND T2.del_flg = 01217 __EOS__;1218 $result = 0;1219 foreach ($pref_id as $pref) {1220 $result += $objQuery->getOne($sql, array($pref, $deliv_id));1221 }1222 return $result;1223 }1224 1225 /**1226 1198 * レコードの存在チェックを行う. 1227 1199 *
Note: See TracChangeset
for help on using the changeset viewer.