source: temp/trunk/html/admin/contents/csv.php @ 1328

<?php

require_once("../../require.php");
require_once(ROOT_DIR."data/include/csv_output.inc");

class LC_Page {
    var $arrForm;
    var $arrHidden;

    function LC_Page() {
        $this->tpl_mainpage = 'contents/csv.tpl';
        $this->tpl_subnavi = 'contents/subnavi.tpl';
        $this->tpl_subno = 'csv';
        $this->tpl_subno_csv = $this->arrSubnavi[1];
        $this->tpl_mainno = "contents";
        $this->tpl_subtitle = 'CSV½ÐÎÏÀßÄê';
    }
}
$objPage = new LC_Page();
$objView = new SC_AdminView();
$objSess = new SC_Session();

$objPage->arrSubnavi = $arrSubnavi;
$objPage->arrSubnaviName = $arrSubnaviName;

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

$arrOutput = array();
$arrChoice = array();

$get_tpl_subno_csv = $_GET['tpl_subno_csv'];
// GET¤ÇÃͤ¬Á÷¤é¤ì¤Æ¤¤¤ë¾ì¹ç¤Ë¤Ï¤½¤ÎÃͤò¸µ¤Ë²èÌÌɽ¼¨¤òÀÚ¤êÂؤ¨¤ë
if ($get_tpl_subno_csv != ""){
    // Á÷¤é¤ì¤Æ¤­¤¿Ãͤ¬ÇÛÎó¤ËÅÐÏ¿¤µ¤ì¤Æ¤¤¤Ê¤±¤ì¤ÐTOP¤òɽ¼¨
    if (in_array($get_tpl_subno_csv,$objPage->arrSubnavi)){
        $subno_csv = $get_tpl_subno_csv;
    }else{
        $subno_csv = $objPage->arrSubnavi[1];
    }
} else {
    // GET¤ÇÃͤ¬¤Ê¤±¤ì¤ÐPOST¤ÎÃͤò»ÈÍѤ¹¤ë
    if ($_POST['tpl_subno_csv'] != ""){
        $subno_csv = $_POST['tpl_subno_csv'];
    }else{
        $subno_csv = $objPage->arrSubnavi[1];
    }
}

// subno¤ÎÈÖ¹æ¤ò¼èÆÀ
$subno_id = array_keys($objPage->arrSubnavi,$subno_csv);
$subno_id = $subno_id[0];
// ¥Ç¡¼¥¿¤ÎÅÐÏ¿
if ($_POST["mode"] == "confirm") {
    
    // ¥¨¥é¡¼¥Á¥§¥Ã¥¯
    $objPage->arrErr = lfCheckError($_POST['output_list']);
    
    if (count($objPage->arrErr) <= 0){
        // ¥Ç¡¼¥¿¤Î¹¹¿·
        lfUpdCsvOutput($subno_id, $_POST['output_list']);
        
        // ²èÌ̤Υê¥í¡¼¥É
        sfReload("tpl_subno_csv=$subno_csv");
    }
}

// ½ÐÎϹàÌܤμèÆÀ
$arrOutput = sfSwapArray(sfgetCsvOutput($subno_csv, "WHERE csv_id = ? AND status = 1", array($subno_id)));
$arrOutput = sfarrCombine($arrOutput['col'], $arrOutput['disp_name']);

// Èó½ÐÎϹàÌܤμèÆÀ
$arrChoice = sfSwapArray(sfgetCsvOutput($subno_csv, "WHERE csv_id = ? AND status = 2", array($subno_id)));
$arrChoice = sfarrCombine($arrChoice['col'], $arrChoice['disp_name']);

$objPage->arrOutput=$arrOutput;
$objPage->arrChoice=$arrChoice;


$objPage->SubnaviName = $objPage->arrSubnaviName[$subno_id];
$objPage->tpl_subno_csv = $subno_csv;

// ²èÌ̤Îɽ¼¨
$objView->assignobj($objPage);
$objView->display(MAIN_FRAME);

//---------------------------------------------------------------------------------------------------------------------------------------------------------
/**************************************************************************************************************
 * ´Ø¿ô̾   ¡§lfUpdCsvOutput
 * ½èÍýÆâÍÆ ¡§CSV½ÐÎϹàÌܤò¹¹¿·¤¹¤ë
 * °ú¿ô     ¡§¤Ê¤·
 **************************************************************************************************************/
function lfUpdCsvOutput($csv_id, $arrData = array()){
    $objQuery = new SC_Query();

    // ¤Ò¤È¤Þ¤º¡¢Á´Éô»ÈÍѤ·¤Ê¤¤¤Ç¹¹¿·¤¹¤ë
    $upd_sql = "UPDATE dtb_csv SET status = 2, rank = NULl WHERE csv_id = ?";
    $objQuery->query($upd_sql, array($csv_id));

    // »ÈÍѤ¹¤ë¤â¤Î¤À¤±¡¢ºÆ¹¹¿·¤¹¤ë¡£
    if (is_array($arrData)) {
        foreach($arrData as $key => $val){
            $upd_sql = "UPDATE dtb_csv SET status = 1, rank = ? WHERE csv_id = ? AND col = ? ";
            $objQuery->query($upd_sql, array($key+1, $csv_id,$val));
        }
    }
}

/**************************************************************************************************************
 * ´Ø¿ô̾   ¡§lfUpdCsvOutput
 * ½èÍýÆâÍÆ ¡§CSV½ÐÎϹàÌܤò¹¹¿·¤¹¤ë
 * °ú¿ô     ¡§¤Ê¤·
 * ÌáÃÍ     ¡§¤Ê¤·
 **************************************************************************************************************/
function lfCheckError($data){
    $objErr = new SC_CheckError();
    $objErr->doFunc( array("½ÐÎϹàÌÜ", "output_list"), array("EXIST_CHECK") );
    
    return $objErr->arrErr;

}