Changeset 16801 for branches/beta/html/admin/basis/mail_edit.php

Timestamp:

2007/11/22 14:32:35 (19 years ago)

Author:

satou

Message:

#132
複数のバグが混在していました。
修正完了です。

File:

• branches/beta/html/admin/basis/mail_edit.php (moved) (moved from branches/beta/html/admin/basis/mail.php) (5 diffs)

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

@@ -11 +11 @@
     var $tpl_mode;
     function LC_Page() {
-        $this->tpl_mainpage = 'basis/mail.tpl';
-        $this->tpl_subnavi = 'basis/subnavi.tpl';
-        $this->tpl_mainno = 'basis';
-        $this->tpl_subno = 'mail';
-        $this->tpl_subtitle = '¥á¡¼¥ëÀßÄê';
+        $this->tpl_mainpage = "basis/mail_edit.tpl";
+        $this->tpl_subnavi = "basis/subnavi.tpl";
+        $this->tpl_mainno = "basis";
+        $this->tpl_subno = "mail";
+        $this->tpl_subtitle = "¥á¡¼¥ëÀßÄê";
     }
 }
 
-$conn = new SC_DBConn();
 $objQuery = new SC_Query();
 $objPage = new LC_Page();
@@ -29 +28 @@
 
 $objPage->arrMailTEMPLATE = $arrMAILTEMPLATE;
+$objPage->arrSendType = $arrMailType;
 
-$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($_GET['template_id']) );
-        if ( $result ){
+// ÊÔ½¸/¿·µ¬
+if ($_POST['mode'] == "edit") {
+    if (sfCheckNumLength($_POST['template_id']) === true) {
+        $result = $objQuery->select("*", "dtb_mailtemplate", "template_id = ?", array($_POST['template_id']));
+        if ($result) {
             $objPage->arrForm = $result[0];
         } else {
-            $objPage->arrForm['template_id'] = $_GET['template_id'];
+            $objPage->arrForm['template_id'] = $_POST['template_id'];
         }
+    } else {
+        $objPage->arrForm['template_id'] = 0;
     }
-} elseif ( $_POST['mode'] == 'regist' && sfCheckNumLength( $_POST['template_id']) ){
+
+// ÅÐÏ¿
+} elseif ($_POST['mode'] == "regist" && sfCheckNumLength($_POST['template_id']) === true) {
     // POST¥Ç¡¼¥¿¤Î°ú¤­·Ñ¤®
     $objPage->arrForm = lfConvertParam($_POST);
     $objPage->arrErr = fnErrorCheck($objPage->arrForm);
-    if ( $objPage->arrErr ){
+    if ($objPage->arrErr) {
         // ¥¨¥é¡¼¥á¥Ã¥»¡¼¥¸
         $objPage->tpl_msg = "¥¨¥é¡¼¤¬È¯À¸¤·¤Þ¤·¤¿";
     } else {
         // Àµ¾ï
-        lfRegist($conn, $objPage->arrForm);
-        // ´°Î»¥á¥Ã¥»¡¼¥¸
-        $objPage->tpl_onload = "window.alert('¥á¡¼¥ëÀßÄ꤬´°Î»¤·¤Þ¤·¤¿¡£');";
+        lfRegist($objQuery, $objPage->arrForm, $_POST['template_id']);
+        // ´°Î»¥Ú¡¼¥¸
+        $objPage->tpl_mainpage = "basis/mail_complete.tpl";
     }
 }
@@ -62 +64 @@
 //-----------------------------------------------------------------------------------------------------------------------------------
 
-function lfRegist( $conn, $data ){
+function lfRegist($objQuery, $arrVal, $id) {
+    $sqlval['template_name'] = $arrVal['template_name'];
+    $sqlval['subject'] = $arrVal['subject'];
+    $sqlval['creator_id'] = $_SESSION['member_id'];
+    $sqlval['body'] = $arrVal['body'];
+    $sqlval['send_type'] = $arrVal['send_type'];
+    $sqlval['update_date'] = "now()";
     
-    $data['creator_id'] = $_SESSION['member_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 send_type = ?,template_id = ?, template_name = ?,subject = ?,body = ?,creator_id = ?, update_date = now() WHERE ".$sql_where, $data);
-    }else{
-        $conn->query("INSERT INTO dtb_mailtemplate (send_type,template_id,template_name,subject,body,creator_id,update_date,create_date) values ( ?,?,?,?,?,?,now(),now() )", $data);
+    $result = $objQuery->count("dtb_mailtemplate", "template_id=?", array($id));
+    if ($result > 0) {
+        $objQuery->update("dtb_mailtemplate", $sqlval, "template_id=?", array($id));
+    } else {
+        $sqlval['create_date'] = "now()";
+        $objQuery->insert("dtb_mailtemplate", $sqlval);
     }
-
 }
 
 function lfConvertParam($array) {
-    
     $new_array["send_type"] = $array["send_type"];
     $new_array["template_id"] = $array["template_id"];
@@ -90 +93 @@
 /* ÆþÎÏ¥¨¥é¡¼¤Î¥Á¥§¥Ã¥¯ */
 function fnErrorCheck($array) {
-    
     $objErr = new SC_CheckError($array);
     $objErr->doFunc(array("¥á¡¼¥ë¤Î¼ïÎà",'send_type'), array("EXIST_CHECK"));
@@ -97 +99 @@
     $objErr->doFunc(array("¥á¡¼¥ë¥¿¥¤¥È¥ë",'subject',MTEXT_LEN,"BIG"), array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
     $objErr->doFunc(array("¥á¡¼¥ë¤ÎÆâÍÆ",'body',LTEXT_LEN,"BIG"), array("MAX_LENGTH_CHECK","EXIST_CHECK"));
-
+    
     return $objErr->arrErr;
 }