- Timestamp:
- 2013/05/02 18:11:36 (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/helper/SC_Helper_Payment.php
r22568 r22796 35 35 * 36 36 * @param integer $payment_id 支払方法ID 37 * @param boolean $has_deleted 削除された支払方法も含む場合 true; 初期値 false38 37 * @return array 39 38 */ 40 public function get($payment_id, $has_deleted = false) 41 { 39 public function get($payment_id) { 42 40 $objQuery =& SC_Query_Ex::getSingletonInstance(); 43 41 $where = 'payment_id = ?'; 44 if (!$has_deleted) {45 $where .= ' AND del_flg = 0';46 }47 42 $arrRet = $objQuery->select('*', 'dtb_payment', $where, array($payment_id)); 48 43 return $arrRet[0]; … … 52 47 * 支払方法一覧の取得. 53 48 * 54 * @param boolean $has_deleted 削除された支払方法も含む場合 true; 初期値 false55 49 * @return array 56 50 */ 57 public function getList($has_deleted = false) 58 { 51 public function getList() { 59 52 $objQuery =& SC_Query_Ex::getSingletonInstance(); 60 $col = 'payment_id, payment_method, payment_image, charge, rule_max, upper_rule, note, fix, charge_flg'; 61 $where = ''; 62 if (!$has_deleted) { 63 $where .= 'del_flg = 0'; 64 } 53 $col = 'payment_id, payment_method, charge, rule_max, upper_rule, note, fix, charge_flg'; 54 $where = 'del_flg = 0'; 65 55 $table = 'dtb_payment'; 66 56 $objQuery->setOrder('rank DESC'); 67 57 $arrRet = $objQuery->select($col, $table, $where); 68 58 return $arrRet; 69 }70 71 /**72 * 購入金額に応じた支払方法を取得する.73 *74 * @param integer $total 購入金額75 * @return array 購入金額に応じた支払方法の配列76 */77 function getByPrice($total)78 {79 // 削除されていない支払方法を取得80 $payments = $this->getList();81 $arrPayment = array();82 foreach ($payments as $data) {83 // 下限と上限が設定されている84 if (strlen($data['rule_max']) != 0 && strlen($data['upper_rule']) != 0) {85 if ($data['rule_max'] <= $total && $data['upper_rule'] >= $total) {86 $arrPayment[] = $data;87 }88 }89 // 下限のみ設定されている90 elseif (strlen($data['rule_max']) != 0) {91 if ($data['rule_max'] <= $total) {92 $arrPayment[] = $data;93 }94 }95 // 上限のみ設定されている96 elseif (strlen($data['upper_rule']) != 0) {97 if ($data['upper_rule'] >= $total) {98 $arrPayment[] = $data;99 }100 }101 // いずれも設定なし102 else {103 $arrPayment[] = $data;104 }105 }106 return $arrPayment;107 59 } 108 60 … … 113 65 * @return void 114 66 */ 115 public function save($sqlval) 116 { 67 public function save($sqlval) { 68 $payment_id = $sqlval['payment_id']; 69 117 70 $objQuery =& SC_Query_Ex::getSingletonInstance(); 118 119 $payment_id = $sqlval['payment_id'];120 $sqlval['update_date'] = 'CURRENT_TIMESTAMP';121 71 // 新規登録 122 72 if ($payment_id == '') { … … 129 79 } else { 130 80 unset($sqlval['creator_id']); 131 unset($sqlval['create_date']);132 81 $where = 'payment_id = ?'; 133 82 $objQuery->update('dtb_payment', $sqlval, $where, array($payment_id)); … … 141 90 * @return void 142 91 */ 143 public function delete($payment_id) 144 { 92 public function delete($payment_id) { 145 93 $objDb = new SC_Helper_DB_Ex(); 146 94 // ランク付きレコードの削除 … … 154 102 * @return void 155 103 */ 156 public function rankUp($payment_id) 157 { 104 public function rankUp($payment_id) { 158 105 $objDb = new SC_Helper_DB_Ex(); 159 106 $objDb->sfRankUp('dtb_payment', 'payment_id', $payment_id); … … 166 113 * @return void 167 114 */ 168 public function rankDown($payment_id) 169 { 115 public function rankDown($payment_id) { 170 116 $objDb = new SC_Helper_DB_Ex(); 171 117 $objDb->sfRankDown('dtb_payment', 'payment_id', $payment_id); … … 180 126 * @return boolean 決済モジュールを使用する支払い方法の場合 true 181 127 */ 182 public static function useModule($payment_id) 183 { 128 public static function useModule($payment_id) { 184 129 $objQuery =& SC_Query_Ex::getSingletonInstance(); 185 130 $memo03 = $objQuery->get('memo03', 'dtb_payment', 'payment_id = ?', array($payment_id)); 186 131 return !SC_Utils_Ex::isBlank($memo03); 187 132 } 188 189 /**190 * 支払方法IDをキー, 名前を値とする配列を取得.191 *192 * @return array193 */194 public static function getIDValueList()195 {196 return SC_Helper_DB_Ex::sfGetIDValueList('dtb_payment', 'payment_id', 'payment_method');197 }198 133 }
Note: See TracChangeset
for help on using the changeset viewer.