- Timestamp:
- 2012/11/06 12:03:56 (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/helper/SC_Helper_Payment.php
r22076 r22078 32 32 { 33 33 /** 34 * 支払方法の情報を取得. 35 * 36 * @param integer $payment_id 支払方法ID 37 * @return array 38 */ 39 public function get($payment_id) { 40 $objQuery =& SC_Query_Ex::getSingletonInstance(); 41 $where = 'payment_id = ?'; 42 $arrRet = $objQuery->select('*', 'dtb_payment', $where, array($payment_id)); 43 return $arrRet[0]; 44 } 45 46 /** 47 * 支払方法一覧の取得. 48 * 49 * @return array 50 */ 51 public function getList() { 52 $objQuery =& SC_Query_Ex::getSingletonInstance(); 53 $col = 'payment_id, payment_method, charge, rule_max, upper_rule, note, fix, charge_flg'; 54 $where = 'del_flg = 0'; 55 $table = 'dtb_payment'; 56 $objQuery->setOrder('rank DESC'); 57 $arrRet = $objQuery->select($col, $table, $where); 58 return $arrRet; 59 } 60 61 /** 62 * 支払方法の登録. 63 * 64 * @param array $sqlval 65 * @return void 66 */ 67 public function save($sqlval) { 68 $payment_id = $sqlval['payment_id']; 69 70 $objQuery =& SC_Query_Ex::getSingletonInstance(); 71 // 新規登録 72 if ($payment_id == '') { 73 // INSERTの実行 74 $sqlval['rank'] = $objQuery->max('rank', 'dtb_payment') + 1; 75 $sqlval['create_date'] = 'CURRENT_TIMESTAMP'; 76 $sqlval['payment_id'] = $objQuery->nextVal('dtb_payment_payment_id'); 77 $objQuery->insert('dtb_payment', $sqlval); 78 // 既存編集 79 } else { 80 unset($sqlval['creator_id']); 81 $where = 'payment_id = ?'; 82 $objQuery->update('dtb_payment', $sqlval, $where, array($payment_id)); 83 } 84 } 85 86 /** 87 * 支払方法の削除. 88 * 89 * @param integer $payment_id 支払方法ID 90 * @return void 91 */ 92 public function delete($payment_id) { 93 $objDb = new SC_Helper_DB_Ex(); 94 // ランク付きレコードの削除 95 $objDb->sfDeleteRankRecord('dtb_payment', 'payment_id', $payment_id); 96 } 97 98 /** 99 * 支払方法の表示順をひとつ上げる. 100 * 101 * @param integer $payment_id 支払方法ID 102 * @return void 103 */ 104 public function rankUp($payment_id) { 105 $objDb = new SC_Helper_DB_Ex(); 106 $objDb->sfRankUp('dtb_payment', 'payment_id', $payment_id); 107 } 108 109 /** 110 * 支払方法の表示順をひとつ下げる. 111 * 112 * @param integer $payment_id 支払方法ID 113 * @return void 114 */ 115 public function rankDown($payment_id) { 116 $objDb = new SC_Helper_DB_Ex(); 117 $objDb->sfRankDown('dtb_payment', 'payment_id', $payment_id); 118 } 119 120 /** 34 121 * 決済モジュールを使用するかどうか. 35 122 *
Note: See TracChangeset
for help on using the changeset viewer.
