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

<?php

require_once("../require.php");

require_once("../order/index_csv.php");

$arrCVSCOL = array( 
        
                );
                        
$arrCVSTITLE = array(
                '²óÅúID',
                '¼ÁÌäID',
                '²óÅúÆü»þ',
                '²óÅú̾',
                '¸ÜµÒ̾1',
                '¸ÜµÒ̾2',
                '¸ÜµÒ̾¥«¥Ê1',
                '¸ÜµÒ̾¥«¥Ê2',
                '͹ÊØÈÖ¹æ1',
                '͹ÊØÈÖ¹æ2',
                'ÅÔÆ»Éܸ©',
                '½»½ê1',
                '½»½ê2',
                'ÅÅÏÃÈÖ¹æ1',
                'ÅÅÏÃÈÖ¹æ2',
                'ÅÅÏÃÈÖ¹æ3',
                '¥á¡¼¥ë¥¢¥É¥ì¥¹',
                '²óÅú1',
                '²óÅú2',
                '²óÅú3',
                '²óÅú4',
                '²óÅú5',
                '²óÅú6'             
            );





class LC_Page {
    var $cnt_question;

    var $ERROR;
    var $ERROR_COLOR;
    var $MESSAGE;
    
    var $QUESTION_ID;
    
    var $arrActive;
    var $arrQuestion;
    var $arrSession;
    
    function LC_Page() {
        $this->tpl_mainpage = 'contents/inquiry.tpl';
        $this->tpl_mainno = 'contents';
        $this->tpl_subnavi = 'contents/subnavi.tpl';
        $this->tpl_subno = "inquiry";
        $this->tpl_subtitle = '¥¢¥ó¥±¡¼¥È´ÉÍý';
    }
}

$conn = new SC_DBConn();
$objPage = new LC_Page();
$objView = new SC_AdminView();
$objSess = new SC_Session();

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


$arrActive = array( "0"=>"²ÔƯ", "1"=>"Èó²ÔƯ" );
$arrQuestion = array( "0"=>"»ÈÍѤ·¤Ê¤¤", "1"=>"¥Æ¥­¥¹¥È¥¨¥ê¥¢", "2"=>"¥Æ¥­¥¹¥È¥Ü¥Ã¥¯¥¹"
                    , "3"=>"¥Á¥§¥Ã¥¯¥Ü¥Ã¥¯¥¹", "4"=>"¥é¥¸¥ª¥Ü¥¿¥ó" 
                );


$sql = "SELECT *, to_char( create_date, 'YYYY/MM/DD' ) as disp_date FROM dtb_question WHERE delete = 0 ORDER BY question_id";
$result = $conn->getAll($sql);
$objPage->list_data = $result;
                        
if ( $_GET['mode'] == 'regist' ){

    for ( $i=0; $i<count($_POST["question"]); $i++ ) {
        $_POST['question'][$i]['name'] = mb_convert_kana( trim ( $_POST['question'][$i]['name'] ), "K" );
        for ( $j=0; $j<count( $_POST['question'][$i]['option'] ); $j++ ){
            $_POST['question'][$i]['option'][$j] = mb_convert_kana( trim ( $_POST['question'][$i]['option'][$j] ) );
        }
    }
    
    $error = lfErrCheck();
        
    if ( ! $error  ){
        
        if ( ! is_numeric($_POST['question_id']) ){
            //ÅÐÏ¿
            $sql = "select nextval('dtb_question_question_id_seq');";
            $question_id = $conn->getOne($sql);
            
            $value = serialize($_POST);
            $sql_val = array( $value, $_POST['title'] ,$question_id );
            $conn->query("INSERT INTO dtb_question ( question, question_name, question_id ) VALUES (?, ?, ?)", $sql_val );
            $objPage->MESSAGE = "ÅÐÏ¿¤¬´°Î»¤·¤Þ¤·¤¿";
            $objPage->QUESTION_ID = $question_id;
            sfReload();
        } else {
            //ÊÔ½¸
            $value = serialize($_POST);
            $sql_val = array( $value, $_POST['title'] ,$_POST['question_id'] );
            $conn->query("UPDATE dtb_question SET question = ?, question_name = ? WHERE question_id = ?", $sql_val );
            $objPage->MESSAGE = "ÊÔ½¸¤¬´°Î»¤·¤Þ¤·¤¿";
            $objPage->QUESTION_ID = $_POST['question_id'];
            sfReload();
        }
    } else {
        //¥¨¥é¡¼É½¼¨
        $objPage->ERROR = $error;
        $objPage->QUESTION_ID = $_REQUEST['question_id'];
        $objPage->ERROR_COLOR = lfGetErrColor($error, ERR_COLOR);

    }
} elseif ( ( $_GET['mode'] == 'delete' ) && ( sfCheckNumLength($_GET['question_id']) )  ){

    $sql = "UPDATE dtb_question SET delete = 1 WHERE question_id = ?";
    $conn->query( $sql, array( $_GET['question_id'] ) );
    sfReload();
    
} elseif ( ( $_GET['mode'] == 'csv' ) && ( sfCheckNumLength($_GET['question_id']) ) ){ 

            $head = sfGetCSVList($arrCVSTITLE);
            $list_data = $conn->getAll("SELECT result_id,question_id,question_date,question_name,name01,name02,kana01,kana02,zip01,zip02,pref,addr01,addr02,tel01,tel02,tel03,mail01,question01,question02,question03,question04,question05,question06 FROM dtb_question_result WHERE delete = 0 ORDER BY result_id ASC");
            $data = "";
            for($i = 0; $i < count($list_data); $i++) {
                // ³Æ¹àÌܤòCSV½ÐÎÏÍѤËÊÑ´¹¤¹¤ë¡£
                $data .= lfMakeCSV($list_data[$i]);
            }
            // CSV¤òÁ÷¿®¤¹¤ë
            sfCSVDownload($head.$data);
            exit;

} else {
    
    if ( is_numeric($_GET['question_id']) ){
    
        $sql = "SELECT question FROM dtb_question WHERE question_id = ?";
        $result = $conn->getOne($sql, array($_GET['question_id']));
        
        if ( $result ){
            $_POST = unserialize( $result );
            $objPage->QUESTION_ID = $_GET['question_id'];
        }
    }
} 




//³Æ¥Ú¡¼¥¸¶¦ÄÌ
$objPage->cnt_question = 6;
$objPage->arrActive = $arrActive;
$objPage->arrQuestion = $arrQuestion;


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




// ------------  ¥¨¥é¡¼¥Á¥§¥Ã¥¯½èÍýÉô ------------  

function lfGetErrColor( $arr, $err_color ){
    
    foreach ( $arr as $key=>$val ) {
        if ( is_string($val) && strlen($val) > 0 ){
            $return[$key] = $err_color;
        } elseif ( is_array( $val ) ) {
            $return[$key] = lfGetErrColor ( $val, $err_color);
        }
    }
    return $return;
}







// ------------  ¥¨¥é¡¼¥Á¥§¥Ã¥¯½èÍýÉô ------------  

function lfErrCheck (){

    $objErr = new SC_CheckError();
    $errMsg = "";

    $objErr->doFunc( array( "²ÔƯ¡¦Èó²ÔƯ", "active" ), array( "SELECT_CHECK" ) );
    
    $_POST["title"] = mb_convert_kana( trim (  $_POST["title"] ), "K" );
    $objErr->doFunc( array( "¥¢¥ó¥±¡¼¥È̾", "title" ), array( "EXIST_CHECK" ) );

    $_POST["contents"] = mb_convert_kana( trim (  $_POST["contents"] ), "K" );
    $objErr->doFunc( array( "¥¢¥ó¥±¡¼¥ÈÆâÍÆ" ,"contents" ), array( "EXIST_CHECK" ) );

    
    if ( ! $_POST['question'][0]["name"] ){
        $objErr->arrErr['question'][0]["name"] = "£±¤Ä¤á¤Î¼ÁÌä̾¤¬ÆþÎϤµ¤ì¤Æ¤¤¤Þ¤»¤ó";
    }
    
    //¡¡¥Á¥§¥Ã¥¯¥Ü¥Ã¥¯¥¹¡¢¥é¥¸¥ª¥Ü¥¿¥ó¤òÁªÂò¤·¤¿¾ì¹ç¤ÏºÇÄã1¤Ä°Ê¾å¹àÌܤòµ­Æþ¤µ¤»¤ë¡£
    for( $i = 0; $i < count( $_POST["question"] ); $i++ ) {
        
        if ( $_POST["question"][$i]["kind"] ) {
            if (strlen($_POST["question"][$i]["name"]) == 0) {
                $objErr->arrErr["question"][$i]["name"] = "¥¿¥¤¥È¥ë¤òÆþÎϤ·¤Æ²¼¤µ¤¤¡£";
            } else if ( strlen($_POST["question"][$i]["name"]) > STEXT_LEN ) {
                $objErr->arrErr["question"][$i]["name"] = "¥¿¥¤¥È¥ë¤Ï". STEXT_LEN  ."»ú°ÊÆâ¤ÇÆþÎϤ·¤Æ²¼¤µ¤¤¡£";
            }
        }
        
        if( $_POST["question"][$i]["kind"] == 3 || $_POST["question"][$i]["kind"] == 4  ) {

            $temp_data = array();
            for( $j = 0; $j < count( $_POST["question"][$i]["option"] ); $j++ ) {   

                // ¹àÌܴ֡ʥƥ­¥¹¥È¥Ü¥Ã¥¯¥¹¡Ë¤¬¤¢¤¤¤Æ¤¤¤¿¤éµÍ¤á¤Æ¤¤¤¯
                if( strlen( $_POST["question"][$i]["option"][$j] ) > 0 ) $temp_data[] = mb_convert_kana( trim ( $_POST["question"][$i]["option"][$j]  ), "asKVn" );

            }

             $_POST["question"][$i]["option"] = $temp_data;

            if( ( strlen( $_POST["question"][$i] ["option"][0] ) == 0 ) || ( strlen( $_POST["question"][$i] ["option"][0] ) > 0
             && strlen( $_POST["question"][$i] ["option"][1] ) == 0 ) ) $objErr->arrErr["question"][$i]['kind'] = "²¼µ­¤Î2¤Ä°Ê¾å¤Î¹àÌܤ˵­Æþ¤·¤Æ¤¯¤À¤µ¤¤¡£";
        }
    }

    return lfGetArrInput( $objErr->arrErr );

}


function lfGetArrInput( $arr ){
    // Ãͤ¬ÆþÎϤµ¤ì¤¿ÇÛÎó¤Î¤ß¤òÊÖ¤¹
    
    if ( is_array($arr) ){
        foreach ( $arr as $key=>$val ) {
            if ( is_string($val) && strlen($val) > 0 ){
                $return[$key] = $val;
            } elseif ( is_array( $val ) ) {
                $data = lfGetArrInput ( $val );
                if ( $data ){
                    $return[$key] = $data;
                }
            }
        }
    }
    return $return;
}
?>