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

Timestamp:

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

Author:

adati

Message:

1.4.0a-betaのマージ

File:

• branches/beta/html/admin/order/mail.php (modified) (8 diffs)

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

@@ -8 +8 @@
 
 class LC_Page {
+    
+    var $mailTemp;
+    var $arrMAILTEMPLATE;
     function LC_Page() {
         $this->tpl_mainpage = 'order/mail.tpl';
@@ -14 +17 @@
         $this->tpl_subno = 'index';
         $this->tpl_subtitle = '¼õÃí´ÉÍý';
-        global $arrMAILTEMPLATE;
-        $this->arrMAILTEMPLATE = $arrMAILTEMPLATE;
+        
+        
     }
 }
@@ -22 +25 @@
 $objView = new SC_AdminView();
 $objSess = new SC_Session();
+
+// ¥Ñ¥é¥á¡¼¥¿´ÉÍý¥¯¥é¥¹
+$objFormParam = new SC_FormParam();
+// ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½
+lfInitParam();
+
+// ǧ¾Ú²ÄÈݤÎȽÄê
 sfIsSuccess($objSess);
 
@@ -32 +42 @@
 
 $objPage->tpl_order_id = $_POST['order_id'];
+// DB¤«¤é¼õÃí¾ðÊó¤òÆɤ߹þ¤à
+lfGetOrderData($_POST['order_id']);
 
-// ¥Ñ¥é¥á¡¼¥¿´ÉÍý¥¯¥é¥¹
-$objFormParam = new SC_FormParam();
-// ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½
-lfInitParam();
+// --¥Æ¥ó¥×¥ì¡¼¥È¡¿¥×¥ë¥À¥¦¥ó¥á¥Ë¥å¡¼¤ÎºîÀ®
+$conn = new SC_DbConn();
+$sql = "SELECT * FROM dtb_mailtemplate WHERE del_flg=0 ORDER BY template_id ASC";
+
+$Temp = $conn->getAll($sql);//$Temp¤Ë¼èÆÀ¤·¤¿¥Ç¡¼¥¿¤ò°ì»þŪ¤Ë³ÊǼ
+//¥Æ¥ó¥×¥ì¡¼¥È¥Õ¥¡¥¤¥ë¤Ë½ÐÎϤ¹¤ë¤¿¤á¤ËÆ󼡸µÇÛÎó¤ËÂåÆþ¤¹¤ë
+for($i = 0;$i < count($Temp);$i++){
+    $arrTemplate[0][$i] = $Temp[$i]['template_id'];
+    $arrTemplate[1][$i] = $Temp[$i]['template_name'];
+}
+
+//¥Æ¥ó¥×¥ì¡¼¥È¥Õ¥¡¥¤¥ë¤Ø¥Ç¡¼¥¿¤òÂåÆþ
+$objPage->mailTemp = $arrTemplate;
+$objPage->arrMAILTEMPLATE = $arrTemplate[1];
 
 switch($_POST['mode']) {
@@ -54 +76 @@
     if (count($objPage->arrErr) == 0) {
         // Ãíʸ¼õÉե᡼¥ë
-        sfSendOrderMail($_POST['order_id'], $_POST['template_id'], $_POST['subject'], $_POST['header'], $_POST['footer']);
+        sfSendOrderMail($_POST['order_id'], $_POST['template_id'], $_POST['subject'], $_POST['body']);
     }
     header("Location: " . URL_SEARCH_ORDER);
@@ -70 +92 @@
     if (count($objPage->arrErr) == 0) {
         // Ãíʸ¼õÉե᡼¥ë(Á÷¿®¤Ê¤·)
-        $objSendMail = sfSendOrderMail($_POST['order_id'], $_POST['template_id'], $_POST['subject'], $_POST['header'], $_POST['footer'], false);
+        $objSendMail = sfSendOrderMail($_POST['order_id'], $_POST['template_id'], $_POST['subject'], $_POST['body'], false);
         // ³Îǧ¥Ú¡¼¥¸¤Îɽ¼¨
         $objPage->tpl_subject = $objSendMail->subject;
@@ -85 +107 @@
 case 'change':
     // POSTÃͤμèÆÀ
+    
     $objFormParam->setValue('template_id', $_POST['template_id']);
-    if(sfIsInt($_POST['template_id'])) {
-        $objQuery = new SC_Query();
+    
+    //¥Æ¥ó¥×¥ì¡¼¥È¥Õ¥¡¥¤¥ë¤ÇÁªÂò¤µ¤ì¤¿¥Æ¥ó¥×¥ì¡¼¥È̾¤ò¥Æ¥ó¥×¥ì¡¼¥ÈID¤È´ØÏ¢ÉÕ¤±¤ë
+    $_POST['template_id'] = $arrTemplate[0][$_POST['template_id']];
+    if(sfIsInt($_POST['template_id'])) {
+        $objQuery = new SC_Query();
         $where = "template_id = ?";
-        $arrRet = $objQuery->select("subject, header, footer", "dtb_mailtemplate", $where, array($_POST['template_id']));
-        $objFormParam->setParam($arrRet[0]);
+        $arrRet = $objQuery->select("subject, body", "dtb_mailtemplate", $where, array($_POST['template_id']));
+        $objFormParam->setParam($arrRet[0]);
     }
     break;
@@ -113 +139 @@
     $objFormParam->addParam("¥Æ¥ó¥×¥ì¡¼¥È", "template_id", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"));
     $objFormParam->addParam("¥á¡¼¥ë¥¿¥¤¥È¥ë", "subject", STEXT_LEN, "KVa",  array("EXIST_CHECK", "MAX_LENGTH_CHECK", "SPTAB_CHECK"));
-    $objFormParam->addParam("¥Ø¥Ã¥À¡¼", "header", LTEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "SPTAB_CHECK"));
-    $objFormParam->addParam("¥Õ¥Ã¥¿¡¼", "footer", LTEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "SPTAB_CHECK"));
+    $objFormParam->addParam("¥Ø¥Ã¥À¡¼", "body", LTEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "SPTAB_CHECK"));
+    //$objFormParam->addParam("¥Õ¥Ã¥¿¡¼", "footer", LTEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "SPTAB_CHECK"));
 }
+
+function lfGetOrderData($order_id) {
+    global $objFormParam;
+    global $objPage;
+    if(sfIsInt($order_id)) {
+        // DB¤«¤é¼õÃí¾ðÊó¤òÆɤ߹þ¤à
+        $objQuery = new SC_Query();
+        $where = "order_id = ?";
+        $arrRet = $objQuery->select("*", "dtb_order", $where, array($order_id));
+        $objFormParam->setParam($arrRet[0]);
+        list($point, $total_point) = sfGetCustomerPoint($order_id, $arrRet[0]['use_point'], $arrRet[0]['add_point']);
+        $objFormParam->setValue('total_point', $total_point);
+        $objFormParam->setValue('point', $point);
+        $objPage->arrDisp = $arrRet[0];
+    }
+}