Ticket #909: SC_Model.php

<?php
/*
 * This file is part of EC-CUBE
 *
 * Copyright(c) 2000-2010 LOCKON CO.,LTD. All Rights Reserved.
 *
 * http://www.lockon.co.jp/
 *
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License
 * as published by the Free Software Foundation; either version 2
 * of the License, or (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
 */

class SC_Model {
    
    var $arrRegistColumn;
    var $select_key;
    var $select_key_seq;
    var $select_table;
    var $insert_table;
    
    function __construct() {
        $this->objQuery = new SC_Query();
        if (!$this->insert_table) {
            $this->insert_table = array($this->select_table);
        }
        if (!$this->select_key_seq) {
            $this->select_key_seq = $this->select_table . '_' . $this->select_key;
        }
    }
    
    function regist($array) {

        //-- 編集登録実行
        $this->objQuery->begin();
        
        $regist_key = $this->objQuery->nextVal($this->select_key_seq);
        
        foreach ($this->insert_table as $key => $table) {
            $arrRegist = array();
            foreach ($this->arrRegistColumn as $data) {
                if ($data["db"] == $table) {
                    $arrRegist[$data["column"]] = ($array[$data["column"]] != "") ? $array[$data["column"]] : NULL;
                }
            }
            
            $arrRegist["update_date"] = "Now()";
            $arrRegist[$this->select_key] = $regist_key;
            
            $this->objQuery->insert($table, $arrRegist);
        }
        
        $this->objQuery->commit();
    }
    
    function update($array) {
        
        //-- 編集登録実行
        $this->objQuery->begin();
        
        foreach ($this->insert_table as $table) {
            $arrRegist = array();
            foreach ($this->arrRegistColumn as $data) {
                if ($data["db"] == $table) {
                    $arrRegist[$data["column"]] = ($array[$data["column"]] != "") ? $array[$data["column"]] : NULL;
                }
            }
            
            $arrRegist["update_date"] = "Now()";
            $id = $array[$this->select_key];
            $where = $this->select_key ." = ?";
            $arrval = array($id);
            $this->objQuery->update($table, $arrRegist, $where, $arrval);
        }
        
        $this->objQuery->commit();
    }
    
    function getData($id) {        
        $col = "*";
        $table = $this->select_table;
        $where = $this->select_key ." = ?";
        $arrval = array($id);
        $result = $this->objQuery->select($col, $table, $where , $arrval);
        return $result[0];
    }
    
    function getList($search_condition, $page_max, $offset) {        
        $col = "*";
        $table = $this->select_table;
        $this->arrval = array();
        $this->setWhere($search_condition);
        $this->objQuery->setLimitOffset($page_max, $offset);
        $this->setOrder();
        $result = $this->objQuery->select($col, $table, $this->where , $this->arrval);
        return $result;
    }
    
    function setWhere($search_condition) {
    }
    
    function setOrder() {
        $this->objQuery->setOrder($this->select_key . " DESC");
    }
    
    function delete($id) {        
        $arrRegist = array(
            "del_flg" => 1,
            "update_date" => "NOW()",
        );
        
        //-- 編集登録実行
        $this->objQuery->begin();
        foreach ($this->insert_table as $table) {
            $where = $this->select_key ." = ?";
            $arrval = array($id);
            $this->objQuery->update($table, $arrRegist, $where, $arrval);
        }
        $this->objQuery->commit();
    }
    
    //----　取得文字列の変換
    function convertParam($array) {
        /*
         *    文字列の変換
         *    K :  「半角(ﾊﾝｶｸ)片仮名」を「全角片仮名」に変換
         *    C :  「全角ひら仮名」を「全角かた仮名」に変換
         *    V :  濁点付きの文字を一文字に変換。"K","H"と共に使用します
         *    n :  「全角」数字を「半角(ﾊﾝｶｸ)」に変換
         *  a :  全角英数字を半角英数字に変換する
         */
        // カラム名とコンバート情報
        foreach ($this->arrRegistColumn as $data) {
            $arrConvList[ $data["column"] ] = $data["convert"];
        }
        // 文字変換
        foreach ($arrConvList as $key => $val) {
            // POSTされてきた値のみ変換する。
            if(strlen(($array[$key])) > 0) {
                $array[$key] = mb_convert_kana($array[$key] ,$val);
            }
        }
        return $array;
    }
    
    //---- 入力エラーチェック
    function errorCheck($array) {
        $this->arrForm = $array;
        $this->objErr = new SC_CheckError($this->arrForm);

        foreach ($this->arrRegistColumn as $column) {
            if (!empty($column['check'])) {
                $value = ($column['length']) ? array($column['name'], $column['column'], $column['length']) : array($column['name'], $column['column']);
                $this->objErr->doFunc($value, $column['check']);
            }
        }
        
        $this->customErrorCheck();
        return $this->objErr->arrErr;

    }
    
    function customErrorCheck() {
    }
}
?>