Changeset 14676 for branches/beta/html/admin/basis/mail.php

Timestamp:

2007/06/14 22:01:13 (17 years ago)

Author:

adati

Message:

1.4.0a-betaのマージ

File:

• branches/beta/html/admin/basis/mail.php (modified) (3 diffs)

branches/beta/html/admin/basis/mail.php

@@ -20 +20 @@
 
 $conn = new SC_DBConn();
+$objQuery = new SC_Query();
 $objPage = new LC_Page();
 $objView = new SC_AdminView();
 $objSess = new SC_Session();
 
-// ǧ¾Ú²ÄÈݤÎȽÄê
+//ǧ¾Ú²ÄÈݤÎȽÄê
 sfIsSuccess($objSess);
 
 $objPage->arrMailTEMPLATE = $arrMAILTEMPLATE;
 
-if ( $_POST['mode'] == 'id_set'){
-    // ¥Æ¥ó¥×¥ì¡¼¥È¥×¥ë¥À¥¦¥óÊѹ¹»þ
-    
-    if ( sfCheckNumLength( $_POST['template_id']) ){
+$objPage->arrSendType = array("¥Ñ¥½¥³¥ó","·ÈÂÓ");
+
+if ( $_GET['mode'] == 'edit' && sfCheckNumLength($_GET['template_id']) === true ){
+    if ( sfCheckNumLength( $_GET['template_id']) ){
         $sql = "SELECT * FROM dtb_mailtemplate WHERE template_id = ?";
-        $result = $conn->getAll($sql, array($_POST['template_id']) );
+        $result = $conn->getAll($sql, array($_GET['template_id']) );
         if ( $result ){
             $objPage->arrForm = $result[0];
         } else {
-            $objPage->arrForm['template_id'] = $_POST['template_id'];
+            $objPage->arrForm['template_id'] = $_GET['template_id'];
         }
     }
-    
 } elseif ( $_POST['mode'] == 'regist' && sfCheckNumLength( $_POST['template_id']) ){
-
     // POST¥Ç¡¼¥¿¤Î°ú¤­·Ñ¤®
     $objPage->arrForm = lfConvertParam($_POST);
     $objPage->arrErr = fnErrorCheck($objPage->arrForm);
-    
     if ( $objPage->arrErr ){
         // ¥¨¥é¡¼¥á¥Ã¥»¡¼¥¸
         $objPage->tpl_msg = "¥¨¥é¡¼¤¬È¯À¸¤·¤Þ¤·¤¿";
-        
     } else {
         // Àµ¾ï
         lfRegist($conn, $objPage->arrForm);
-        
         // ´°Î»¥á¥Ã¥»¡¼¥¸
-        $objPage->tpl_onload = "window.alert('¥á¡¼¥ëÀßÄ꤬´°Î»¤·¤Þ¤·¤¿¡£¥Æ¥ó¥×¥ì¡¼¥È¤òÁªÂò¤·¤ÆÆâÍƤò¤´³Îǧ¤¯¤À¤µ¤¤¡£');";
-        unset($objPage->arrForm);
+        $objPage->tpl_onload = "window.alert('¥á¡¼¥ëÀßÄ꤬´°Î»¤·¤Þ¤·¤¿¡£');";
     }
-
 }
 
@@ -72 +66 @@
     $data['creator_id'] = $_SESSION['member_id'];
     
-    $sql = "SELECT * FROM dtb_mailtemplate WHERE template_id = ?";
+    $sql = "SELECT * FROM dtb_mailtemplate WHERE template_id = ? AND del_flg = 0";
     $result = $conn->getAll($sql, array($_POST['template_id']) );
     if ( $result ){
         $sql_where = "template_id = ". addslashes($_POST['template_id']);
-        $conn->query("UPDATE dtb_mailtemplate SET template_id = ?, subject = ?,header = ?, footer = ?,creator_id = ?, update_date = now() WHERE ".$sql_where, $data);
+        $conn->query("UPDATE dtb_mailtemplate SET send_type = ?,template_id = ?, template_name = ?,subject = ?,body = ?,creator_id = ?, update_date = now() WHERE ".$sql_where, $data);
     }else{
-        $conn->query("INSERT INTO dtb_mailtemplate (template_id,subject,header,footer,creator_id,update_date,create_date) values ( ?,?,?,?,?,now(),now() )", $data);
+        $conn->query("INSERT INTO dtb_mailtemplate (send_type,template_id,template_name,subject,body,creator_id,update_date,create_date) values ( ?,?,?,?,?,?,now(),now() )", $data);
     }
 
 }
 
-
 function lfConvertParam($array) {
     
+    $new_array["send_type"] = $array["send_type"];
     $new_array["template_id"] = $array["template_id"];
+    $new_array["template_name"] = mb_convert_kana($array["template_name"],"KV");
     $new_array["subject"] = mb_convert_kana($array["subject"] ,"KV");
-    $new_array["header"] = mb_convert_kana($array["header"] ,"KV");
-    $new_array["footer"] = mb_convert_kana($array["footer"] ,"KV");
+    $new_array["body"] = mb_convert_kana($array["body"] ,"KV");
     
     return $new_array;
@@ -98 +92 @@
     
     $objErr = new SC_CheckError($array);
-    
+    $objErr->doFunc(array("¥á¡¼¥ë¤Î¼ïÎà",'send_type'), array("EXIST_CHECK"));
     $objErr->doFunc(array("¥Æ¥ó¥×¥ì¡¼¥È",'template_id'), array("EXIST_CHECK"));
+    $objErr->doFunc(array("¥Æ¥ó¥×¥ì¡¼¥È",'template_name'), array("EXIST_CHECK"));
     $objErr->doFunc(array("¥á¡¼¥ë¥¿¥¤¥È¥ë",'subject',MTEXT_LEN,"BIG"), array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
-    $objErr->doFunc(array("¥Ø¥Ã¥À¡¼",'header',LTEXT_LEN,"BIG"), array("MAX_LENGTH_CHECK"));
-    $objErr->doFunc(array("¥Õ¥Ã¥¿¡¼",'footer',LTEXT_LEN,"BIG"), array("MAX_LENGTH_CHECK"));
+    $objErr->doFunc(array("¥á¡¼¥ë¤ÎÆâÍÆ",'body',LTEXT_LEN,"BIG"), array("MAX_LENGTH_CHECK","EXIST_CHECK"));
 
     return $objErr->arrErr;