Changeset 22566 for branches/version-2_12-dev/data/class/helper/SC_Helper_Delivery.php

Timestamp:

2013/02/18 19:00:58 (14 years ago)

Author:

pineray

Message:

#2136 #2134 get した値をそのまま save できるように調整.

File:

• branches/version-2_12-dev/data/class/helper/SC_Helper_Delivery.php (modified) (14 diffs)

branches/version-2_12-dev/data/class/helper/SC_Helper_Delivery.php

@@ -29 +29 @@
  * @version $Id:$
  */
-class SC_Helper_Delivery
-{
+class SC_Helper_Delivery {
+
     /**
      * 配送方法の情報を取得.
@@ -42 +42 @@
 
         // 配送業者一覧の取得
-        $col = 'deliv_id, name, service_name, remark, confirm_url, product_type_id';
+        $col = '*';
         $where = 'deliv_id = ?';
         if (!$has_deleted) {
@@ -58 +58 @@
 
         // 配送料金の取得
-        $arrDeliv['fee'] = $this->getDelivFeeList($deliv_id);
+        $arrDeliv['deliv_fee'] = $this->getDelivFeeList($deliv_id);
 
         // 支払方法
@@ -116 +116 @@
         unset($sqlval['payment_ids']);
 
+        $sqlval['update_date'] = 'CURRENT_TIMESTAMP';
+
         // deliv_id が決まっていた場合
         if ($sqlval['deliv_id'] != '') {
+            unset($sqlval['creator_id']);
+            unset($sqlval['create_date']);
             $deliv_id = $sqlval['deliv_id'];
             $where = 'deliv_id = ?';
@@ -126 +130 @@
             $where = 'deliv_id = ? AND time_id = ?';
             for ($cnt = 1; $cnt <= DELIVTIME_MAX; $cnt++) {
-                $keyname = 'deliv_time'.$cnt;
                 $arrWhereVal = array($deliv_id, $cnt);
                 // 既存データの有無を確認
@@ -132 +135 @@
 
                 if (isset($sqlval_deliv_time[$cnt])) {
-                    $deliv_time = $sqlval_deliv_time[$cnt];
+                    $deliv_time = array();
+                    $deliv_time['deliv_time'] = $sqlval_deliv_time[$cnt];
 
                     // 入力が空ではなく、DBに情報があれば更新
@@ -146 +150 @@
                 }
                 // 入力が空で、DBに情報がある場合は削除
-                else if (count($curData)) {
+                elseif (count($curData)) {
                     $objQuery->delete($table, $where, $arrWhereVal);
                 }
@@ -153 +157 @@
             // 配送料の登録
             if (INPUT_DELIV_FEE) {
-                foreach ($sqlval_deliv_fee as $cnt => $deliv_fee) {
-                    $objQuery->update('dtb_delivfee', array('fee' => $deliv_fee['fee']), 'deliv_id = ? AND fee_id = ?', array($deliv_id, $cnt));
+                foreach ($sqlval_deliv_fee as $deliv_fee) {
+                    $objQuery->update('dtb_delivfee', array('fee' => $deliv_fee['fee']), 'deliv_id = ? AND fee_id = ?', array($deliv_id, $deliv_fee['fee_id']));
                 }
             }
@@ -176 +180 @@
             if (INPUT_DELIV_FEE) {
                 // 配送料金の設定
-                foreach ($sqlval_deliv_fee as $cnt => $deliv_fee) {
+                foreach ($sqlval_deliv_fee as $deliv_fee) {
                     $deliv_fee['deliv_id'] = $deliv_id;
-                    $deliv_fee['fee_id'] = $cnt;
                     // INSERTの実行
                     $objQuery->insert('dtb_delivfee', $deliv_fee);
@@ -187 +190 @@
         // 支払い方法
         $objQuery->delete('dtb_payment_options', 'deliv_id = ?', array($deliv_id));
-        foreach ($sqlval_payment_ids as $payment_ids) {
-            $payment_ids['deliv_id'] = $deliv_id;
-            $objQuery->insert('dtb_payment_options', $payment_ids);
+        $i = 1;
+        foreach ($sqlval_payment_ids as $payment_id) {
+            $sqlval_payment_id = array();
+            $sqlval_payment_id['deliv_id'] = $deliv_id;
+            $sqlval_payment_id['payment_id'] = $payment_id;
+            $sqlval_payment_id['rank'] = $i;
+            $objQuery->insert('dtb_payment_options', $sqlval_payment_id);
+            $i++;
         }
 
@@ -243 +251 @@
         } else {
             $objQuery =& SC_Query_Ex::getSingletonInstance();
-            $ret = (($objQuery->count('dtb_deliv', 'deliv_id != ? AND service_name = ? ', array($arrDeliv['deliv_id'], $arrDeliv['service_name'])) > 0)? true : false);
+            $ret = (($objQuery->count('dtb_deliv', 'deliv_id != ? AND service_name = ? ', array($arrDeliv['deliv_id'], $arrDeliv['service_name'])) > 0) ? true : false);
         }
         return $ret;
@@ -267 +275 @@
         $objQuery =& SC_Query_Ex::getSingletonInstance();
         $objQuery->setOrder('time_id');
-        $results = $objQuery->select('time_id, deliv_time',
-                                     'dtb_delivtime',
-                                     'deliv_id = ?', array($deliv_id));
+        $results = $objQuery->select('time_id, deliv_time', 'dtb_delivtime', 'deliv_id = ?', array($deliv_id));
         $arrDelivTime = array();
         foreach ($results as $val) {
@@ -286 +292 @@
         $objQuery =& SC_Query_Ex::getSingletonInstance();
         $objQuery->setOrder('rank');
-        return $objQuery->getCol('payment_id', 'dtb_payment_options',
-                                 'deliv_id = ?',
-                                 array($deliv_id), MDB2_FETCHMODE_ORDERED);
+        return $objQuery->getCol('payment_id', 'dtb_payment_options', 'deliv_id = ?', array($deliv_id), MDB2_FETCHMODE_ORDERED);
     }
 
@@ -328 +332 @@
         $objQuery =& SC_Query_Ex::getSingletonInstance();
         $objQuery->setOrder('pref');
-        $col = 'fee';
+        $col = 'fee_id, fee, pref';
         $where = 'deliv_id = ?';
         $table = 'dtb_delivfee';
-        return $objQuery->getCol($col, $table, $where, array($deliv_id),
-                                 MDB2_FETCHMODE_ORDERED);
+        return $objQuery->select($col, $table, $where, array($deliv_id));
     }
 }