source: branches/comu/html/admin/basis/delivery_input.php @ 2

<?php
/*
 * Copyright(c) 2000-2006 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/delivery_input.tpl';
        $this->tpl_subnavi = 'basis/subnavi.tpl';
        $this->tpl_subno = 'delivery';
        $this->tpl_mainno = 'basis';
        global $arrPref;
        $this->arrPref = $arrPref;
        $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);

switch($_POST['mode']) {
case 'edit':
    // ÆþÎÏÃͤÎÊÑ´¹
    $objFormParam->convParam();
    $objPage->arrErr = lfCheckError();
    if(count($objPage->arrErr) == 0) {
        $objPage->tpl_deliv_id = lfRegistData();
        $objPage->tpl_onload = "window.alert('ÇÛÁ÷¶È¼ÔÀßÄ꤬´°Î»¤·¤Þ¤·¤¿¡£');";
    }
    break;
case 'pre_edit':
    if($_POST['deliv_id'] != "") {
        lfGetDelivData($_POST['deliv_id']);
        $objPage->tpl_deliv_id = $_POST['deliv_id'];
    }
    break;
default:
    break;
}

$objPage->arrForm = $objFormParam->getFormParamList();
$objView->assignobj($objPage);
$objView->display(MAIN_FRAME);
//--------------------------------------------------------------------------------------------------------------------------------------
/* ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ */
function lfInitParam() {
    global $objFormParam;
    $objFormParam->addParam("ÇÛÁ÷¶È¼Ô̾", "name", STEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK"));
    $objFormParam->addParam("ÅÁɼNo.³ÎǧURL", "confirm_url", STEXT_LEN, "n", array("URL_CHECK", "MAX_LENGTH_CHECK"), "http://");
    
    for($cnt = 1; $cnt <= DELIVTIME_MAX; $cnt++) {
        $objFormParam->addParam("ÇÛÁ÷»þ´Ö$cnt", "deliv_time$cnt", STEXT_LEN, "KVa", array("MAX_LENGTH_CHECK"));
    }
    
    if(INPUT_DELIV_FEE) {
        for($cnt = 1; $cnt <= DELIVFEE_MAX; $cnt++) {
            $objFormParam->addParam("ÇÛÁ÷ÎÁ¶â$cnt", "fee$cnt", PRICE_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"));
        }
    }
}

/* DB¤ËÅÐÏ¿¤¹¤ë */
function lfRegistData() {
    global $objFormParam;
    $arrRet = $objFormParam->getHashArray();
    $objQuery = new SC_Query();
    $objQuery->begin();

    // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£
    $sqlval['name'] = $arrRet['name'];
    $sqlval['service_name'] = $arrRet['name'];
    $sqlval['confirm_url'] = $arrRet['confirm_url'];
    $sqlval['creator_id'] = $_SESSION['member_id'];
    $sqlval['update_date'] = 'Now()';
    
    if($_POST['deliv_id'] != "") {
        $deliv_id = $_POST['deliv_id'];
        $where = "deliv_id = ?";
        $objQuery->update("dtb_deliv", $sqlval, $where, array($deliv_id));
        $objQuery->delete("dtb_delivfee", $where, array($deliv_id));
        $objQuery->delete("dtb_delivtime", $where, array($deliv_id));
    } else {
        // ÅÐÏ¿¤¹¤ëÇÛÁ÷¶È¼ÔID¤Î¼èÆÀ

        if (DB_TYPE == "pgsql") {
            $deliv_id = $objQuery->nextval('dtb_deliv', 'deliv_id');
            $sqlval['deliv_id'] = $deliv_id;
        }
        
        $sqlval['rank'] = $objQuery->max("dtb_deliv", "rank") + 1;
        $sqlval['create_date'] = 'Now()';
        // INSERT¤Î¼Â¹Ô
        $objQuery->insert("dtb_deliv", $sqlval);
        
        if (DB_TYPE == "mysql") {
            $deliv_id = $objQuery->nextval('dtb_deliv', 'deliv_id');            
        }
    }
    
    $sqlval = array();
    // ÇÛÁ÷»þ´Ö¤ÎÀßÄê
    for($cnt = 1; $cnt <= DELIVTIME_MAX; $cnt++) {
        $keyname = "deliv_time$cnt";
        if($arrRet[$keyname] != "") {
            $sqlval['deliv_id'] = $deliv_id;
            $sqlval['deliv_time'] = $arrRet[$keyname];
            // INSERT¤Î¼Â¹Ô
            $objQuery->insert("dtb_delivtime", $sqlval);
        }
    }
    
    if(INPUT_DELIV_FEE) {
        $sqlval = array();
        // ÇÛÁ÷ÎÁ¶â¤ÎÀßÄê
        for($cnt = 1; $cnt <= DELIVFEE_MAX; $cnt++) {
            $keyname = "fee$cnt";
            if($arrRet[$keyname] != "") {
                $sqlval['deliv_id'] = $deliv_id;
                $sqlval['fee'] = $arrRet[$keyname];
                $sqlval['pref'] = $cnt;
                // INSERT¤Î¼Â¹Ô
                $objQuery->insert("dtb_delivfee", $sqlval);
            }
        }
    }
    $objQuery->commit();
    return $deliv_id;
}

/* ÇÛÁ÷¶È¼Ô¾ðÊó¤Î¼èÆÀ */
function lfGetDelivData($deliv_id) {
    global $objFormParam;
    $objQuery = new SC_Query();
    // ÇÛÁ÷¶È¼Ô°ìÍ÷¤Î¼èÆÀ
    $col = "deliv_id, name, service_name, confirm_url";
    $where = "deliv_id = ?";
    $table = "dtb_deliv";
    $arrRet = $objQuery->select($col, $table, $where, array($deliv_id));
    $objFormParam->setParam($arrRet[0]);
    // ÇÛÁ÷»þ´Ö¤Î¼èÆÀ
    $col = "deliv_time";
    $where = "deliv_id = ?  ORDER BY time_id";
    $table = "dtb_delivtime";
    $arrRet = $objQuery->select($col, $table, $where, array($deliv_id));
    $objFormParam->setParamList($arrRet, 'deliv_time');
    // ÇÛÁ÷ÎÁ¶â¤Î¼èÆÀ
    $col = "fee";
    $where = "deliv_id = ? ORDER BY pref";
    $table = "dtb_delivfee";
    $arrRet = $objQuery->select($col, $table, $where, array($deliv_id));
    $objFormParam->setParamList($arrRet, 'fee');
}

/* ÆþÎÏÆâÍƤΥÁ¥§¥Ã¥¯ */
function lfCheckError() {
    global $objFormParam;
    // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£
    $arrRet =  $objFormParam->getHashArray();
    $objErr = new SC_CheckError($arrRet);
    $objErr->arrErr = $objFormParam->checkError();
    
    if(!isset($objErr->arrErr['name']) && $_POST['deliv_id'] == "") {
        // ´û¸¥Á¥§¥Ã¥¯
        $ret = sfIsRecord("dtb_deliv", "service_name", array($arrRet['service_name']));
        if ($ret) {
            $objErr->arrErr['name'] = "¢¨ Ʊ¤¸Ì¾¾Î¤ÎÁȤ߹ç¤ï¤»¤ÏÅÐÏ¿¤Ç¤­¤Þ¤»¤ó¡£<br>";
        }
    }
    
    return $objErr->arrErr;
}