source: branches/comu-euc/html/admin/order/mail.php @ 16350

<?php
/*
 * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved.
 *
 * http://www.lockon.co.jp/
 */
require_once("../require.php");

// ǧ¾Ú²ÄÈݤÎȽÄê
sfIsSuccess(new SC_Session());

// order_id¤Î¸¡¾Ú
if (lfIsValidOrderID() !== true) {
    sfDispError('');
}

class LC_Page {
    var $arrMAILTEMPLATE;

    function LC_Page() {
        $this->tpl_mainpage = 'order/mail.tpl';
        $this->tpl_subnavi = 'order/subnavi.tpl';
        $this->tpl_mainno = 'order';
        $this->tpl_subno = 'index';
        $this->tpl_subtitle = '¼õÃí´ÉÍý';
    }
}

$objPage = new LC_Page();
$objView = new SC_AdminView();
$objFormParam = new SC_FormParam();

// ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½
lfInitParam();

// ¸¡º÷¥Ñ¥é¥á¡¼¥¿¤Î°ú¤­·Ñ¤®
foreach ($_POST as $key => $val) {
    if (ereg("^search_", $key)) {
        $objPage->arrSearchHidden[$key] = $val;
    }
}

$objPage->tpl_order_id = $_POST['order_id'];

// DB¤«¤é¼õÃí¾ðÊó¤òÆɤ߹þ¤à
lfGetOrderData($_POST['order_id']);

//¥Æ¥ó¥×¥ì¡¼¥È¥Õ¥¡¥¤¥ë¤Ø¥Ç¡¼¥¿¤òÂåÆþ
$objPage->arrMAILTEMPLATE = lfCreateTemplateList();

$mode = isset($_POST['mode']) ? $_POST['mode'] : '';
switch($mode) {
// ¼õÃí¸¡º÷¤«¤é¤ÎÁ«°Ü
case 'pre_edit':
    break;
// ³Îǧ²èÌ̤«¤éÌá¤ë.
case 'return':
    // POSTÃͤμèÆÀ
    $objFormParam->setParam($_POST);
    break;
case 'send':
    // POSTÃͤμèÆÀ
    $objFormParam->setParam($_POST);
    // ÆþÎÏÃͤÎÊÑ´¹
    $objFormParam->convParam();
    $objPage->arrErr = $objFormParam->checkerror();
    // ¥á¡¼¥ë¤ÎÁ÷¿®
    if (count($objPage->arrErr) == 0) {
        // Ãíʸ¼õÉե᡼¥ë
        sfSendOrderMail($_POST['order_id'], $_POST['template_id'], $_POST['subject'], $_POST['body']);
    }
    header("Location: " . URL_SEARCH_ORDER);
    exit;
    break;
case 'confirm':
    // POSTÃͤμèÆÀ
    $objFormParam->setParam($_POST);
    // ÆþÎÏÃͤÎÊÑ´¹
    $objFormParam->convParam();
    // ÆþÎÏÃͤΰú¤­·Ñ¤®
    $objPage->arrHidden = $objFormParam->getHashArray();
    $objPage->arrErr = $objFormParam->checkerror();
    // ¥á¡¼¥ë¤ÎÁ÷¿®
    if (count($objPage->arrErr) == 0) {
        // Ãíʸ¼õÉե᡼¥ë(Á÷¿®¤Ê¤·)
        $objSendMail = sfSendOrderMail($_POST['order_id'], $_POST['template_id'], $_POST['subject'], $_POST['body'], false);
        // ³Îǧ¥Ú¡¼¥¸¤Îɽ¼¨
        $objPage->tpl_subject = $objSendMail->subject;
        $objPage->tpl_body = mb_convert_encoding( $objSendMail->body, "EUC-JP", "auto" );
        $objPage->tpl_to = $objSendMail->tpl_to;
        $objPage->tpl_mainpage = 'order/mail_confirm.tpl';

        $objView->assignobj($objPage);
        $objView->display(MAIN_FRAME);

        exit;
    }
    break;
case 'change':
    $objFormParam->setValue('template_id', $_POST['template_id']);

    if(sfIsInt($_POST['template_id'])) {
        $objQuery = new SC_Query();
        $where = "template_id = ?";
        $arrRet = $objQuery->select("subject, body", "dtb_mailtemplate", $where, array($_POST['template_id']));
        $objFormParam->setParam($arrRet[0]);
    }
    break;
}

if(sfIsInt($_POST['order_id'])) {
    $objPage->arrMailHistory = lfGetMailHistory($_POST['order_id']);
}

$objPage->arrForm = $objFormParam->getFormParamList();
$objView->assignObj($objPage);
$objView->display(MAIN_FRAME);
//-----------------------------------------------------------------------------------------------------------------------------------
/* ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ */
function lfInitParam() {
    global $objFormParam;
    $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("ËÜʸ", "body", 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];
    }
}

/**
 * POST¤µ¤ì¤ëorder_id¤ò¸¡¾Ú¤¹¤ë.
 *
 * @param void
 * @return boolean
 */
function lfIsValidOrderID() {
    if (isset($_POST['order_id']) && sfIsint($_POST['order_id'])) {
        return true;
    }
    return false;
}

/**
 * ¥Æ¥ó¥×¥ì¡¼¥È¥×¥ë¥À¥¦¥ó¥á¥Ë¥å¡¼¤ÎÇÛÎó¤òºîÀ®¤¹¤ë.
 * array(
 *   array(template_id => template_name),
 *   array(template_id => template_name),
 *   ...
 * )
 *
 * @param void
 * @return array
 */
function lfCreateTemplateList() {
    $objQuery = new SC_Query;
    $objQuery->setOrder('template_id ASC');
    $arrTemp = $objQuery->select('template_id, template_name', 'dtb_mailtemplate', 'del_flg = 0');

    $arrRet = array();
    foreach($arrTemp as $val) {
        $arrRet[$val['template_id']] = $val['template_name'];
    }

    return $arrRet;
}

/**
 * ¥á¡¼¥ëÇÛ¿®ÍúÎò¤ò¼èÆÀ¤¹¤ë.
 *
 * @param integer $order_id
 * @return array
 */
function lfGetMailHistory($order_id) {
    $cols  = "send_date, subject, template_id, send_id";
    $where = "order_id = ?";
    $objQuery = new SC_Query();
    $objQuery->setorder("send_date DESC");

    $arrRet = $objQuery->select($cols, "dtb_mail_history", $where, array($order_id));
    return $arrRet;
}