source: temp/trunk/html/admin/basis/tradelaw.php @ 1328

<?php

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

class LC_Page {
    var $arrSession;
    var $tpl_mode;
    function LC_Page() {
        $this->tpl_mainpage = 'basis/tradelaw.tpl';
        $this->tpl_subnavi = 'basis/subnavi.tpl';
        $this->tpl_subno = 'tradelaw';
        $this->tpl_mainno = 'basis';
        global $arrPref;
        $this->arrPref = $arrPref;
        global $arrTAXRULE;
        $this->arrTAXRULE = $arrTAXRULE;
        $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 = lfCheckError($arrRet);
    
    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");
    // DBÃͤμèÆÀ
    $objFormParam->setParam($arrRet[0]);
}

$objPage->arrForm = $objFormParam->getFormParamList();
$objView->assignobj($objPage);
$objView->display(MAIN_FRAME);
//--------------------------------------------------------------------------------------------------------------------------------------
/* ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ */
function lfInitParam() {
    global $objFormParam;
    $objFormParam->addParam("ÈÎÇä¶È¼Ô", "law_company", STEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
    $objFormParam->addParam("±¿±ÄÀÕǤ¼Ô", "law_manager", STEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
    $objFormParam->addParam("͹ÊØÈÖ¹æ1", "law_zip01", ZIP01_LEN, "n", array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK"));
    $objFormParam->addParam("͹ÊØÈÖ¹æ2", "law_zip02", ZIP02_LEN, "n", array("EXIST_CHECK", "NUM_CHECK", "NUM_COUNT_CHECK"));
    $objFormParam->addParam("ÅÔÆ»Éܸ©", "law_pref", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"));
    $objFormParam->addParam("½»½ê1", "law_addr01", STEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
    $objFormParam->addParam("½»½ê2", "law_addr02", STEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
    $objFormParam->addParam("ÅÅÏÃÈÖ¹æ1", "law_tel01", TEL_ITEM_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK" ,"NUM_CHECK"));
    $objFormParam->addParam("ÅÅÏÃÈÖ¹æ2", "law_tel02", TEL_ITEM_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK" ,"NUM_CHECK"));
    $objFormParam->addParam("ÅÅÏÃÈÖ¹æ3", "law_tel03", TEL_ITEM_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK" ,"NUM_CHECK"));
    $objFormParam->addParam("FAXÈÖ¹æ1", "law_fax01", TEL_ITEM_LEN, "n", array("MAX_LENGTH_CHECK" ,"NUM_CHECK"));
    $objFormParam->addParam("FAXÈÖ¹æ2", "law_fax02", TEL_ITEM_LEN, "n", array("MAX_LENGTH_CHECK" ,"NUM_CHECK"));
    $objFormParam->addParam("FAXÈÖ¹æ3", "law_fax03", TEL_ITEM_LEN, "n", array("MAX_LENGTH_CHECK" ,"NUM_CHECK"));
    $objFormParam->addParam("¥á¡¼¥ë¥¢¥É¥ì¥¹", "law_email", STEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "EMAIL_CHECK", "EMAIL_CHAR_CHECK"));
    $objFormParam->addParam("URL", "law_url", STEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "URL_CHECK"));
    $objFormParam->addParam("ɬÍ×ÎÁ¶â", "law_term01", MTEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
    $objFormParam->addParam("ÃíʸÊýË¡", "law_term02", MTEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
    $objFormParam->addParam("»ÙʧÊýË¡", "law_term03", MTEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
    $objFormParam->addParam("»Ùʧ´ü¸Â", "law_term04", MTEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
    $objFormParam->addParam("°ú¤­ÅϤ·»þ´ü", "law_term05", MTEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
    $objFormParam->addParam("ÊÖÉÊ¡¦¸ò´¹¤Ë¤Ä¤¤¤Æ", "law_term06", MTEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_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);
}

/* ÆþÎÏÆâÍƤΥÁ¥§¥Ã¥¯ */
function lfCheckError() {
    global $objFormParam;
    // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£
    $arrRet =  $objFormParam->getHashArray();
    $objErr = new SC_CheckError($arrRet);
    $objErr->arrErr = $objFormParam->checkError();
    
    // ÅÅÏÃÈÖ¹æ¥Á¥§¥Ã¥¯
    $objErr->doFunc(array("TEL", "law_tel01", "law_tel02", "law_tel03", TEL_ITEM_LEN), array("TEL_CHECK"));
    $objErr->doFunc(array("FAX", "law_fax01", "law_fax02", "law_fax03", TEL_ITEM_LEN), array("TEL_CHECK"));
    $objErr->doFunc(array("͹ÊØÈÖ¹æ", "law_zip01", "law_zip02"), array("ALL_EXIST_CHECK"));
    
    return $objErr->arrErr;
}

?>