source: temp/branches/ec-cube-beta/html/admin/contents/campaign.php @ 11333

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

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

//---- ¥Ú¡¼¥¸É½¼¨¥¯¥é¥¹
class LC_Page {
    
    function LC_Page() {
        $this->tpl_mainpage = 'contents/campaign.tpl';
        $this->tpl_subnavi = 'contents/subnavi.tpl';
        $this->tpl_subno = "campaign";
        $this->tpl_mainno = 'contents';
        $this->tpl_subtitle = '¥­¥ã¥ó¥Ú¡¼¥ó´ÉÍý';
        // ¥«¡¼¥È¤Ë¾¦Éʤ¬Æþ¤Ã¤Æ¤¤¤ë¤Ë¥Á¥§¥Ã¥¯¤¬Æþ¤Ã¤Æ¤¤¤ë¤«¥Á¥§¥Ã¥¯
        $this->tpl_onload = "fnIsCartOn();";
    }
}


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

// ǧ¾Ú²ÄÈݤÎȽÄê
sfIsSuccess($objSess);

// ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½
lfInitParam();
// ¥Õ¥©¡¼¥à¤ÎÃͤò¥»¥Ã¥È
$objFormParam->setParam($_POST);

// ¥Õ¥©¡¼¥à¤ÎÃͤò¥Æ¥ó¥×¥ì¡¼¥È¤ØÅϤ¹
$objPage->arrForm = $objFormParam->getHashArray();
$campaign_id = $_POST['campaign_id'];

switch($_POST['mode']) {
    // ¿·µ¬ÅÐÏ¿/ÊÔ½¸ÅÐÏ¿
    case 'regist':
        // ¥¨¥é¡¼¥Á¥§¥Ã¥¯
        $objPage->arrErr = lfErrorCheck($campaign_id);
        
        if(count($objPage->arrErr) <= 0) {
            // ÅÐÏ¿
            lfRegistCampaign($campaign_id);
            // ¥­¥ã¥ó¥Ú¡¼¥óTOP¤Ø¥ê¥À¥¤¥ì¥¯¥È
            header("location: ".URL_CAMPAIGN_TOP);
        }
        break;
    // ÊÔ½¸²¡²¼»þ
    case 'update':
        // ¥­¥ã¥ó¥Ú¡¼¥ó¾ðÊó¤ò¼èÆÀ
        $objPage->arrForm = lfGetCampaign($campaign_id);
        break;
    // ºï½ü²¡²¼»þ
    case 'delete':
        // ºï½ü
        lfDeleteCampaign($campaign_id);
        // ¥­¥ã¥ó¥Ú¡¼¥óTOP¤Ø¥ê¥À¥¤¥ì¥¯¥È
        header("location: ".URL_CAMPAIGN_TOP);
        break;
    // CSV½ÐÎÏ
    case 'csv':
        // ¥ª¥×¥·¥ç¥ó¤Î»ØÄê
        $option = "ORDER BY create_date DESC";
            
        // CSV½ÐÎÏ¥¿¥¤¥È¥ë¹Ô¤ÎºîÀ®
        $arrCsvOutput = sfSwapArray(sfgetCsvOutput(4, " WHERE csv_id = 4 AND status = 1"));
            
        if (count($arrCsvOutput) <= 0) break;
            
        $arrCsvOutputCols = $arrCsvOutput['col'];
        $arrCsvOutputTitle = $arrCsvOutput['disp_name'];
        $head = sfGetCSVList($arrCsvOutputTitle);
        $data = lfGetCSV("dtb_campaign_order", "campaign_id = ?", $option, array($campaign_id), $arrCsvOutputCols);
            
        // CSV¤òÁ÷¿®¤¹¤ë¡£
        sfCSVDownload($head.$data);
        exit;
        break;
    default:
        break;
}

// ¥­¥ã¥ó¥Ú¡¼¥ó°ìÍ÷¼èÆÀ
$objPage->arrCampaign = lfGetCampaignList();
$objPage->campaign_id = $campaign_id;

// ¥­¥ã¥ó¥Ú¡¼¥ó´ü´ÖÍÑ
$objDate = new SC_Date();
$objPage->arrYear = $objDate->getYear();
$objPage->arrMonth = $objDate->getMonth();
$objPage->arrDay = $objDate->getDay();
$objPage->arrHour = $objDate->getHour();
$objPage->arrMinutes = $objDate->getMinutes();

//----¡¡¥Ú¡¼¥¸É½¼¨
$objView->assignobj($objPage);
$objView->display(MAIN_FRAME);


//---------------------------------------------------------------------------------------------------------------------------------------------------------
/* 
 * ´Ø¿ô̾¡§lfInitParam
 * ÀâÌÀ¡¡¡§ÆþÎϾðÊó¤Î½é´ü²½
 */
function lfInitParam() {
    global $objFormParam;
        
    $objFormParam->addParam("¥­¥ã¥ó¥Ú¡¼¥ó̾", "campaign_name", MTEXT_LEN, "KVa", array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
    
    $objFormParam->addParam("³«»ÏÆü»þ", "start_year", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
    $objFormParam->addParam("³«»ÏÆü»þ", "start_month", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
    $objFormParam->addParam("³«»ÏÆü»þ", "start_day", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
    $objFormParam->addParam("³«»ÏÆü»þ", "start_hour", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
    $objFormParam->addParam("³«»ÏÆü»þ", "start_minute", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));

    $objFormParam->addParam("Ää»ßÆü»þ", "end_year", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
    $objFormParam->addParam("Ää»ßÆü»þ", "end_month", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
    $objFormParam->addParam("Ää»ßÆü»þ", "end_day", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
    $objFormParam->addParam("Ää»ßÆü»þ", "end_hour", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
    $objFormParam->addParam("Ää»ßÆü»þ", "end_minute", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));

    $objFormParam->addParam("¥Ç¥£¥ì¥¯¥È¥ê̾", "directory_name", MTEXT_LEN, "KVa", array("EXIST_CHECK","ALNUM_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
    $objFormParam->addParam("¿½¹þ¿ôÀ©¸æ", "limit_count", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
    $objFormParam->addParam("½ÅÊ£¿½¹þÀ©¸æ", "orverlapping_flg", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
    $objFormParam->addParam("¥«¡¼¥È¤Ë¾¦ÉʤòÆþ¤ì¤ë", "cart_flg", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
    $objFormParam->addParam("Á÷ÎÁ̵ÎÁÀßÄê", "deliv_free_flg", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));

}

/* 
 * ´Ø¿ô̾¡§lfErrorCheck()
 * °ú¿ô1 ¡§¥­¥ã¥ó¥Ú¡¼¥óID
 * ÀâÌÀ¡¡¡§¥¨¥é¡¼¥Á¥§¥Ã¥¯
 * Ìá¤êÃÍ¡§¥¨¥é¡¼Ê¸»ú³ÊǼÇÛÎó
 */
function lfErrorCheck($campaign_id = "") {
    
    global $objQuery;
    global $objFormParam;

    $arrList = $objFormParam->getHashArray();
    $objErr = new SC_CheckError($arrList);
    $objErr->arrErr = $objFormParam->checkError();
    
    $objErr->doFunc(array("³«»ÏÆü»þ", "start_year", "start_month", "start_day", "start_hour", "start_minute", "0"), array("CHECK_DATE2"));
    $objErr->doFunc(array("Ää»ßÆü»þ", "end_year", "end_month", "end_day", "end_hour", "end_minute", "0"), array("CHECK_DATE2"));
    $objErr->doFunc(array("³«»ÏÆü»þ", "Ää»ßÆü»þ", "start_year", "start_month", "start_day", "start_hour", "start_minute", "00", "end_year", "end_month", "end_day", "end_hour", "end_minute", "59"), array("CHECK_SET_TERM2"));
    
    if(count($objErr->arrErr) <= 0) {

        // ÊÔ½¸»þÍѤ˸µ¤Î¥Ç¥£¥ì¥¯¥È¥ê̾¤ò¼èÆÀ¤¹¤ë¡£
        if($campaign_id != "") {
            $directory_name = $objQuery->get("dtb_campaign", "directory_name", "campaign_id = ?", array($campaign_id));
        } else {
            $directory_name = "";
        }

        // Ʊ̾¤Î¥Õ¥©¥ë¥À¤¬Â¸ºß¤¹¤ë¾ì¹ç¤Ï¥¨¥é¡¼
        if(file_exists(CAMPAIGN_TEMPLATE_PATH.$arrList['directory_name']) && $directory_name != $arrList['directory_name']) {
            $objErr->arrErr['directory_name'] = "¢¨ Ʊ̾¤Î¥Ç¥£¥ì¥¯¥È¥ê¤¬¤¹¤Ç¤Ë¸ºß¤·¤Þ¤¹¡£<br/>";
        }
        $ret = $objQuery->get("dtb_campaign", "directory_name", "directory_name = ? AND del_flg = 0", array($arrList['directory_name']));               
        // DB¤Ë¤¹¤Ç¤ËÅÐÏ¿¤µ¤ì¤Æ¤¤¤Ê¤¤¤«¥Á¥§¥Ã¥¯
        if($ret != "" && $directory_name != $arrList['directory_name']) {
            $objErr->arrErr['directory_name'] = "¢¨ ¤¹¤Ç¤ËÅÐÏ¿¤µ¤ì¤Æ¤¤¤ë¥Ç¥£¥ì¥¯¥È¥ê̾¤Ç¤¹¡£<br/>";
        }
    }
    
    return $objErr->arrErr;
}

/* 
 * ´Ø¿ô̾¡§lfRegistCampaign()
 * °ú¿ô1 ¡§¥­¥ã¥ó¥Ú¡¼¥óID(¥¢¥Ã¥×¥Ç¡¼¥È»þ¤Ë»ØÄê)
 * ÀâÌÀ¡¡¡§¥­¥ã¥ó¥Ú¡¼¥óÅÐÏ¿/¹¹¿·
 * Ìá¤êÃÍ¡§Ìµ¤·
 */
function lfRegistCampaign($campaign_id = "") {

    global $objFormParam;
    global $objQuery;
    
    $objSiteInfo = new SC_SiteInfo();
    $arrInfo = $objSiteInfo->data;
    $arrList = $objFormParam->getHashArray();   

    // ³«»ÏÆü»þ¡¦½ªÎ»Æü»þÀ°·Á
    $start_date = $arrList['start_year']."-".sprintf("%02d", $arrList['start_month'])."-".sprintf("%02d", $arrList['start_day'])." ".sprintf("%02d", $arrList['start_hour']).":".sprintf("%02d", $arrList['start_minute']).":00";
    $end_date = $arrList['end_year']."-".sprintf("%02d", $arrList['end_month'])."-".sprintf("%02d", $arrList['end_day'])." ".sprintf("%02d", $arrList['end_hour']).":".sprintf("%02d", $arrList['end_minute']).":00";

    // ¥Ý¥¤¥ó¥È¥ì¡¼¥È¤ÏÀßÄꤵ¤ì¤Æ¤¤¤Ê¤±¤ì¤Ð0¤òÁÞÆþ
    if($arrInfo['point_rate'] == "") $arrInfo['point_rate'] = "0";
    // ¥Õ¥é¥°¤ÏÀßÄꤵ¤ì¤Æ¤¤¤Ê¤±¤ì¤Ð0¤òÁÞÆþ
    if(!$arrList['limit_count']) $arrList['limit_count'] = "0";
    if(!$arrList['orverlapping_flg']) $arrList['orverlapping_flg'] = "0";
    if(!$arrList['cart_flg']) $arrList['cart_flg'] = "0";
    if(!$arrList['deliv_free_flg']) $arrList['deliv_free_flg'] = "0";
    
    $sqlval['campaign_name'] = $arrList['campaign_name'];
    $sqlval['campaign_point_rate'] = $arrInfo['point_rate'];
    $sqlval['start_date'] = $start_date;
    $sqlval['end_date'] = $end_date;
    $sqlval['directory_name'] = $arrList['directory_name'];
    $sqlval['limit_count'] = $arrList['limit_count'];
    $sqlval['orverlapping_flg'] = $arrList['orverlapping_flg'];
    $sqlval['cart_flg'] = $arrList['cart_flg'];
    $sqlval['deliv_free_flg'] = $arrList['deliv_free_flg'];
    $sqlval['update_date'] = "now()";
    
    // ¥­¥ã¥ó¥Ú¡¼¥óID¤Ç»ØÄꤵ¤ì¤Æ¤¤¤ë¾ì¹ç¤Ïupdate
    if($campaign_id != "") {

        // ¸µ¤Î¥Ç¥£¥ì¥¯¥È¥ê̾¤ò¼èÆÀ̾       
        $directory_name = $objQuery->get("dtb_campaign", "directory_name", "campaign_id = ?", array($campaign_id));
        // ¥Õ¥¡¥¤¥ë̾¤òÊѹ¹
        @rename(CAMPAIGN_TEMPLATE_PATH . $directory_name , CAMPAIGN_TEMPLATE_PATH . $arrList['directory_name']);
        @rename(CAMPAIGN_PATH . $directory_name , CAMPAIGN_PATH . $arrList['directory_name']);

        // update
        $objQuery->update("dtb_campaign", $sqlval, "campaign_id = ?", array($campaign_id)); 
        
    } else {

        // ¥­¥ã¥ó¥Ú¡¼¥ó¥Ú¡¼¥¸¥Ç¥£¥ì¥¯¥È¥êºîÀ®
        lfCreateTemplate(CAMPAIGN_TEMPLATE_PATH, $arrList['directory_name']);

        $sqlval['create_date'] = "now()";   
        // insert
        $objQuery->insert("dtb_campaign", $sqlval);     
    }
}

/* 
 * ´Ø¿ô̾¡§lfGetCampaignList()
 * ÀâÌÀ¡¡¡§¥­¥ã¥ó¥Ú¡¼¥ó°ìÍ÷¤ò¼èÆÀ
 * Ìá¤êÃÍ¡§¥­¥ã¥ó¥Ú¡¼¥ó°ìÍ÷ÇÛÎó
 */
function lfGetCampaignList() {
    
    global $objQuery;
    
    $col = "campaign_id,campaign_name,directory_name,total_count";
    $objQuery->setorder("update_date DESC");
    $arrRet = $objQuery->select($col, "dtb_campaign", "del_flg = 0");

    return $arrRet;
}

/* 
 * ´Ø¿ô̾¡§lfGetCampaign()
 * °ú¿ô1 ¡§¥­¥ã¥ó¥Ú¡¼¥óID
 * ÀâÌÀ¡¡¡§¥­¥ã¥ó¥Ú¡¼¥ó¾ðÊó¼èÆÀ
 * Ìá¤êÃÍ¡§¥­¥ã¥ó¥Ú¡¼¥ó¾ðÊóÇÛÎó
 */
function lfGetCampaign($campaign_id) {
    
    global $objQuery;
    
    $col = "campaign_id,campaign_name,start_date,end_date,directory_name,limit_count,orverlapping_flg,cart_flg,deliv_free_flg";
    $arrRet = $objQuery->select($col, "dtb_campaign", "campaign_id = ?", array($campaign_id));

    // ³«»ÏÆü»þ¡¦Ää»ßÆü»þ¤òʬ²ò
    $start_date = (date("Y/m/d/H/i/s" , strtotime($arrRet[0]['start_date'])));
    list($arrRet[0]['start_year'],$arrRet[0]['start_month'],$arrRet[0]['start_day'],$arrRet[0]['start_hour'], $arrRet[0]['start_minute'], $arrRet[0]['start_second']) = split("/", $start_date);
    $end_date = (date("Y/m/d/H/i/s" , strtotime($arrRet[0]['end_date'])));
    list($arrRet[0]['end_year'],$arrRet[0]['end_month'],$arrRet[0]['end_day'],$arrRet[0]['end_hour'], $arrRet[0]['end_minute'], $arrRet[0]['end_second']) = split("/", $end_date);
    
    return $arrRet[0];
}

/* 
 * ´Ø¿ô̾¡§lfDeleteCampaign()
 * °ú¿ô1 ¡§¥­¥ã¥ó¥Ú¡¼¥óID
 * ÀâÌÀ¡¡¡§¥­¥ã¥ó¥Ú¡¼¥óºï½ü
 * Ìá¤êÃÍ¡§Ìµ¤·
 */
function lfDeleteCampaign($campaign_id) {

    global $objQuery;
    
    // ¥Ç¥£¥ì¥¯¥È¥ê̾¤ò¼èÆÀ̾       
    $directory_name = $objQuery->get("dtb_campaign", "directory_name", "campaign_id = ?", array($campaign_id));
    // ¥Õ¥¡¥¤¥ë¤òºï½ü
    sfDeleteDir(CAMPAIGN_TEMPLATE_PATH . $directory_name);
    sfDeleteDir(CAMPAIGN_PATH . $directory_name);

    $sqlval['del_flg'] = 1; 
    $sqlval['update_date'] = "now()";   
    // delete
    $objQuery->update("dtb_campaign", $sqlval, "campaign_id = ?", array($campaign_id));     
}

/* 
 * ´Ø¿ô̾¡§lfCreateTemplate()
 * °ú¿ô1 ¡§¥Ç¥£¥ì¥¯¥È¥ê¥Ñ¥¹
 * °ú¿ô2 ¡§ºîÀ®¥Õ¥¡¥¤¥ë̾
 * ÀâÌÀ¡¡¡§¥­¥ã¥ó¥Ú¡¼¥ó¤Î½é´ü¥Æ¥ó¥×¥ì¡¼¥ÈºîÀ®
 * Ìá¤êÃÍ¡§Ìµ¤·
 */
function lfCreateTemplate($dir, $file) {
    
    global $objFormParam;
    $arrRet = $objFormParam->getHashArray();

    
    // ºîÀ®¥Õ¥¡¥¤¥ë¥Ç¥£¥ì¥¯¥È¥ê
    $create_dir = $dir . $file;
    $create_active_dir = $create_dir . "/" . CAMPAIGN_TEMPLATE_ACTIVE;
    $create_end_dir = $create_dir . "/" . CAMPAIGN_TEMPLATE_END;
    // ¥Ç¥Õ¥©¥ë¥È¥Õ¥¡¥¤¥ë¥Ç¥£¥ì¥¯¥È¥ê
    $default_dir = $dir . "default";
    $default_active_dir = $default_dir . "/" . CAMPAIGN_TEMPLATE_ACTIVE;
    $default_end_dir = $default_dir . "/" . CAMPAIGN_TEMPLATE_END;
    
    $ret = sfCreateFile($create_dir, 0755); 
    $ret = sfCreateFile($create_active_dir, 0755);  
    $ret = sfCreateFile($create_end_dir, 0755);
        
    // ¥­¥ã¥ó¥Ú¡¼¥ó¼Â¹ÔPHP¤ò¥³¥Ô¡¼
    sfCreateFile(CAMPAIGN_PATH . $file);
    copy(CAMPAIGN_PATH . "default/index.php", CAMPAIGN_PATH . $file . "/index.php");
    copy(CAMPAIGN_PATH . "default/application.php", CAMPAIGN_PATH . $file . "/application.php");
    copy(CAMPAIGN_PATH . "default/complete.php", CAMPAIGN_PATH . $file . "/complete.php");
    copy(CAMPAIGN_PATH . "default/entry.php", CAMPAIGN_PATH . $file . "/entry.php");
    
    // ¥Ç¥Õ¥©¥ë¥È¥Æ¥ó¥×¥ì¡¼¥ÈºîÀ®(¥­¥ã¥ó¥Ú¡¼¥óÃæ)
    $header = lfGetFileContents($default_active_dir."header.tpl");
    sfWriteFile($header, $create_active_dir."header.tpl", "w");
    $contents = lfGetFileContents($default_active_dir."contents.tpl");
    if(!$arrRet['cart_flg']) {
        $contents .= '<!--{*¥í¥°¥¤¥ó¥Õ¥©¡¼¥à*}-->
                        <!--{include file=`$smarty.const.CAMPAIGN_BLOC_PATH`login.tpl}-->
                        <!--{*²ñ°÷ÅÐÏ¿¥Õ¥©¡¼¥à*}-->
                        <!--{include file=`$smarty.const.CAMPAIGN_BLOC_PATH`entry.tpl}-->';
    }
    sfWriteFile($contents, $create_active_dir."contents.tpl", "w");
    $footer = lfGetFileContents($default_active_dir."footer.tpl");
    sfWriteFile($footer, $create_active_dir."footer.tpl", "w");
    
    // ¥µ¥¤¥È¥Õ¥ì¡¼¥àºîÀ®
    $site_frame  = $header."\n";
    $site_frame .= '<script type="text/javascript" src="<!--{$smarty.const.URL_DIR}-->js/navi.js"></script>'."\n";
    $site_frame .= '<script type="text/javascript" src="<!--{$smarty.const.URL_DIR}-->js/site.js"></script>'."\n";
    $site_frame .= '<!--{include file=$tpl_mainpage}-->'."\n";
    $site_frame .= $footer."\n";
    sfWriteFile($site_frame, $create_active_dir."site_frame.tpl", "w");

    /* ¥Ç¥Õ¥©¥ë¥È¥Æ¥ó¥×¥ì¡¼¥ÈºîÀ®(¥­¥ã¥ó¥Ú¡¼¥ó½ªÎ») */
    $header = lfGetFileContents($default_end_dir."header.tpl");
    sfWriteFile($header, $create_end_dir."header.tpl", "w");
    $contents = lfGetFileContents($default_end_dir."contents.tpl");
    sfWriteFile($contents, $create_end_dir."contents.tpl", "w");
    $footer = lfGetFileContents($default_end_dir."footer.tpl");
    sfWriteFile($footer, $create_end_dir."footer.tpl", "w");
}

/* 
 * ´Ø¿ô̾¡§lfGetFileContents()
 * °ú¿ô1 ¡§¥Õ¥¡¥¤¥ë¥Ñ¥¹
 * ÀâÌÀ¡¡¡§¥Õ¥¡¥¤¥ëÆɹþ
 * Ìá¤êÃÍ¡§Ìµ¤·
 */
function lfGetFileContents($read_file) {
    
    if(file_exists($read_file)) {
        $contents = file_get_contents($read_file);
    } else {
        $contents = "";     
    }
    
    return $contents;
}
?>