Changeset 17076 for branches/comu-ver2/data/class/pages/admin/basis/LC_Page_Admin_Basis_Holiday.php

Timestamp:

2008/02/25 19:34:42 (15 years ago)

Author:

Yammy

Message:

定休日設定クラスの入力値チェックを修正

File:

• branches/comu-ver2/data/class/pages/admin/basis/LC_Page_Admin_Basis_Holiday.php (modified) (1 diff)

branches/comu-ver2/data/class/pages/admin/basis/LC_Page_Admin_Basis_Holiday.php

@@ -200 +200 @@
         if(!isset($objErr->arrErr['date'])) {
             $objQuery = new SC_Query();
-            $arrRet = $objQuery->select("count(holiday_id)", "dtb_holiday", "del_flg = 0 AND month = ? AND day = ?", array($_POST['month'], $_POST['day']));
-            // 編集中のレコード以外に同じ名称が存在する場合
+            $where = "del_flg = 0 AND month = ? AND day = ?";
+            $arrval = array($_POST['month'], $_POST['day']);
+            if (!empty($_POST['holiday_id'])) {
+                $where .= " AND holiday_id <> ?";
+                $arrval[] = $_POST['holiday_id'];
+            }
+            $arrRet = $objQuery->select("count(holiday_id)", "dtb_holiday", $where, $arrval);
+            // 編集中のレコード以外に同じ日付が存在する場合
             if ($arrRet[0]['count'] > 0) {
-                $objErr->arrErr['date'] = "※ 既に同じ内容の登録が存在します。<br>";
+                $objErr->arrErr['date'] = "※ 既に同じ日付の登録が存在します。<br>";
             }
         }