Changeset 22796 for branches/version-2_12-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Mail.php

Timestamp:

2013/05/02 18:11:36 (11 years ago)

Author:

h_yoshimoto

Message:

#2236 2.12.3リリース以降の2.12-devへのコミット差し戻し

File:

• branches/version-2_12-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Mail.php (modified) (7 diffs)

branches/version-2_12-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Mail.php

@@ -32 +32 @@
  * @version $Id$
  */
-class LC_Page_Admin_Basis_Mail extends LC_Page_Admin_Ex 
-{
+class LC_Page_Admin_Basis_Mail extends LC_Page_Admin_Ex {
 
     // }}}
@@ -43 +42 @@
      * @return void
      */
-    function init()
-    {
+    function init() {
         parent::init();
         $this->tpl_mainpage = 'basis/mail.tpl';
@@ -58 +56 @@
      * @return void
      */
-    function process()
-    {
+    function process() {
         $this->action();
         $this->sendResponse();
@@ -69 +66 @@
      * @return void
      */
-    function action()
-    {
+    function action() {
 
         $masterData = new SC_DB_MasterData_Ex();
-        $objMailtemplate = new SC_Helper_Mailtemplate_Ex();
 
         $mode = $this->getMode();
@@ -91 +86 @@
         switch ($mode) {
             case 'id_set':
-                    $mailtemplate = $objMailtemplate->get($post['template_id']);
-                    if ($mailtemplate) {
-                        $this->arrForm = $mailtemplate;
+                    $result = $this->lfGetMailTemplateByTemplateID($post['template_id']);
+                    if ($result) {
+                        $this->arrForm = $result[0];
                     } else {
                         $this->arrForm['template_id'] = $post['template_id'];
@@ -107 +102 @@
                     } else {
                         // 正常
-                        $this->lfRegistMailTemplate($this->arrForm, $_SESSION['member_id'], $objMailtemplate);
+                        $this->lfRegistMailTemplate($this->arrForm, $_SESSION['member_id']);
 
                         // 完了メッセージ
@@ -125 +120 @@
      * @return void
      */
-    function destroy()
-    {
+    function destroy() {
         parent::destroy();
     }
 
-    function lfRegistMailTemplate($post, $member_id, SC_Helper_Mailtemplate_Ex $objMailtemplate)
-    {
-        $post['creator_id'] = $member_id;
-        $objMailtemplate->save($post);
+    function lfGetMailTemplateByTemplateID($template_id) {
+        $objQuery =& SC_Query_Ex::getSingletonInstance();
+
+        $sql = 'SELECT * FROM dtb_mailtemplate WHERE template_id = ?';
+        return $objQuery->getAll($sql, array($template_id));
     }
 
-    function lfInitParam($mode, &$objFormParam)
-    {
+    function lfRegistMailTemplate($post, $member_id) {
+        $objQuery =& SC_Query_Ex::getSingletonInstance();
+
+        $post['creator_id'] = $member_id;
+        $post['update_date'] = 'CURRENT_TIMESTAMP';
+
+        $sql = 'SELECT * FROM dtb_mailtemplate WHERE template_id = ?';
+        $template_data = $objQuery->getAll($sql, array($post['template_id']));
+        if ($template_data) {
+            $sql_where = 'template_id = ?';
+            $objQuery->update('dtb_mailtemplate', $post, $sql_where, array(addslashes($post['template_id'])));
+        } else {
+            $objQuery->insert('dtb_mailtemplate', $post);
+        }
+
+    }
+
+    function lfInitParam($mode, &$objFormParam) {
         switch ($mode) {
             case 'regist':
                 $objFormParam->addParam('メールタイトル', 'subject', MTEXT_LEN, 'KVa', array('EXIST_CHECK','SPTAB_CHECK','MAX_LENGTH_CHECK'));
-                $objFormParam->addParam('ヘッダー', 'header', LTEXT_LEN, 'KVa', array('SPTAB_CHECK','MAX_LENGTH_CHECK'));
-                $objFormParam->addParam('フッター', 'footer', LTEXT_LEN, 'KVa', array('SPTAB_CHECK','MAX_LENGTH_CHECK'));
+                $objFormParam->addParam('ヘッダー', 'header', LTEXT_LEN, 'KVa', array('EXIST_CHECK','SPTAB_CHECK','MAX_LENGTH_CHECK'));
+                $objFormParam->addParam('フッター', 'footer', LTEXT_LEN, 'KVa', array('EXIST_CHECK','SPTAB_CHECK','MAX_LENGTH_CHECK'));
                 $objFormParam->addParam('テンプレート', 'template_id', INT_LEN, 'n', array('EXIST_CHECK', 'NUM_CHECK', 'MAX_LENGTH_CHECK'));
             case 'id_set':