source: branches/dev/html/admin/basis/point.php @ 17

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

class LC_Page {
    var $arrSession;
    var $tpl_mode;
    function LC_Page() {
        $this->tpl_mainpage = 'basis/point.tpl';
        $this->tpl_subnavi = 'basis/subnavi.tpl';
        $this->tpl_subno = 'point';
        $this->tpl_mainno = 'basis';
        $this->tpl_subtitle = '¥Ý¥¤¥ó¥ÈÀßÄê';
    }
}

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

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

// ¥Ñ¥é¥á¡¼¥¿´ÉÍý¥¯¥é¥¹
$objFormParam = new SC_FormParam();
// ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½
lfInitParam();
// POSTÃͤμèÆÀ
$objFormParam->setParam($_POST);

$cnt = $objQuery->count("dtb_baseinfo");

if ($cnt > 0) {
    $objPage->tpl_mode = "update";
} else {
    $objPage->tpl_mode = "insert";
}

if($_POST['mode'] != "") {
    // ÆþÎÏÃͤÎÊÑ´¹
    $objFormParam->convParam();
    $objPage->arrErr = $objFormParam->checkError();
    
    if(count($objPage->arrErr) == 0) {
        switch($_POST['mode']) {
        case 'update':
            lfUpdateData(); // ´û¸ÊÔ½¸
            break;
        case 'insert':
            lfInsertData(); // ¿·µ¬ºîÀ®
            break;
        default:
            break;
        }
        // ºÆɽ¼¨
        //sfReload();
        $objPage->tpl_onload = "window.alert('¥Ý¥¤¥ó¥ÈÀßÄ꤬´°Î»¤·¤Þ¤·¤¿¡£');";
    }
} else {
    $arrCol = $objFormParam->getKeyList(); // ¥­¡¼Ì¾°ìÍ÷¤ò¼èÆÀ
    $col    = sfGetCommaList($arrCol);
    $arrRet = $objQuery->select($col, "dtb_baseinfo");
    // POSTÃͤμèÆÀ
    $objFormParam->setParam($arrRet[0]);
}

$objPage->arrForm = $objFormParam->getFormParamList();
$objView->assignobj($objPage);
$objView->display(MAIN_FRAME);
//--------------------------------------------------------------------------------------------------------------------------------------
/* ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ */
function lfInitParam() {
    global $objFormParam;
    $objFormParam->addParam("¥Ý¥¤¥ó¥ÈÉÕͿΨ", "point_rate", PERCENTAGE_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"));
    $objFormParam->addParam("²ñ°÷ÅÐÏ¿»þÉÕÍ¿¥Ý¥¤¥ó¥È", "welcome_point", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"));
}

function lfUpdateData() {
    global $objFormParam;
    // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£
    $sqlval = $objFormParam->getHashArray();
    $sqlval['update_date'] = 'Now()';
    $objQuery = new SC_Query();
    // UPDATE¤Î¼Â¹Ô
    $ret = $objQuery->update("dtb_baseinfo", $sqlval);
}

function lfInsertData() {
    global $objFormParam;
    // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£
    $sqlval = $objFormParam->getHashArray();
    $sqlval['update_date'] = 'Now()';
    $objQuery = new SC_Query();
    // INSERT¤Î¼Â¹Ô
    $ret = $objQuery->insert("dtb_baseinfo", $sqlval);
}