source: branches/comu-utf8/html/admin/basis/delivery_input.php @ 16094

<?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/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("名称", "service_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['service_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;
}