[Svn-src-all:1275] [version-2_5-dev 20164] #964 DB操作クラスの生成をシングルトンに変更
coelacanth
admin ＠ mail.ec-cube.net
2011年 2月 14日 (月) 14:58:24 JST
Subversion committed to /home/svn/open 20164
http://svn.ec-cube.net/open_trac/changeset/20164
┌────────────────────────────┐
│更新者 : coelacanth │
│更新日時: 2011-02-14 14:58:23 +0900 (月, 14 2月 2011)│
└────────────────────────────┘
Log:
--------------------------------------------------------
#964 DB操作クラスの生成をシングルトンに変更
Changed: [U:修正，A:追加，D:削除]
--------------------------------------------------------
U branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis.php
U branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Control.php
U branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Delivery.php
U branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Delivery_Input.php
U branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Holiday.php
U branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Kiyaku.php
U branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Mail.php
U branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Payment.php
U branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Payment_Input.php
U branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Point.php
U branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Seo.php
U branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Tradelaw.php
U branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_ZipInstall.php
変更: branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis.php
===================================================================
--- branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis.php 2011-02-14 04:34:44 UTC (rev 20163)
+++ branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis.php 2011-02-14 05:58:23 UTC (rev 20164)
@@ -79,7 +79,7 @@
*/
function action() {
$objSess = new SC_Session();
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
// 認証可否の判定
SC_Utils_Ex::sfIsSuccess($objSess);
@@ -180,7 +180,7 @@
}
function lfUpdateData($array) {
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
$arrCol = $this->lfGetCol();
foreach($arrCol as $val) {
//配列の場合は、パイプ区切りの文字列に変換
@@ -196,7 +196,7 @@
}
function lfInsertData($array) {
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
$arrCol = $this->lfGetCol();
foreach($arrCol as $val) {
$sqlval[$val] = $array[$val];
変更: branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Control.php
===================================================================
--- branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Control.php 2011-02-14 04:34:44 UTC (rev 20163)
+++ branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Control.php 2011-02-14 05:58:23 UTC (rev 20164)
@@ -135,7 +135,7 @@
// サイト管理情報の取得
function lfGetControlList() {
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
// サイト管理情報の取得
$sql = "SELECT * FROM dtb_site_control ";
$sql .= "WHERE del_flg = 0";
@@ -160,7 +160,7 @@
/* DBへデータを登録する */
function lfSiteControlData($control_id = "") {
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
$sqlval = $this->objFormParam->getHashArray();
$sqlval['update_date'] = 'Now()';
変更: branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Delivery.php
===================================================================
--- branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Delivery.php 2011-02-14 04:34:44 UTC (rev 20163)
+++ branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Delivery.php 2011-02-14 05:58:23 UTC (rev 20164)
@@ -70,7 +70,7 @@
*/
function action() {
$objSess = new SC_Session();
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
$objDb = new SC_Helper_DB_Ex();
// 認証可否の判定
変更: branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Delivery_Input.php
===================================================================
--- branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Delivery_Input.php 2011-02-14 04:34:44 UTC (rev 20163)
+++ branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Delivery_Input.php 2011-02-14 05:58:23 UTC (rev 20164)
@@ -164,7 +164,7 @@
*/
function lfRegistData() {
$arrRet = $this->objFormParam->getHashArray();
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
$objQuery->begin();
// 入力データを渡す。
@@ -280,7 +280,7 @@
/* 配送業者情報の取得 */
function lfGetDelivData($deliv_id) {
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
// パラメータ情報の初期化
$this->lfInitParam('edit');
変更: branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Holiday.php
===================================================================
--- branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Holiday.php 2011-02-14 04:34:44 UTC (rev 20163)
+++ branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Holiday.php 2011-02-14 05:58:23 UTC (rev 20164)
@@ -67,7 +67,7 @@
*/
function action() {
$objSess = new SC_Session();
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
$objDb = new SC_Helper_DB_Ex();
$objDate = new SC_Date();
@@ -150,7 +150,7 @@
/* DBへの挿入 */
function lfInsertClass($arrData) {
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
// INSERTする値を作成する。
$sqlval['title'] = $arrData['title'];
$sqlval['month'] = $arrData['month'];
@@ -167,7 +167,7 @@
/* DBへの更新 */
function lfUpdateClass($arrData) {
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
// UPDATEする値を作成する。
$sqlval['title'] = $arrData['title'];
$sqlval['month'] = $arrData['month'];
@@ -202,7 +202,7 @@
$objErr->doFunc(array("月", "month", INT_LEN), array("SELECT_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
$objErr->doFunc(array("日", "day", INT_LEN), array("SELECT_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
if(!isset($objErr->arrErr['date'])) {
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
$where = "del_flg = 0 AND month = ? AND day = ?";
$arrval = array($_POST['month'], $_POST['day']);
if (!empty($_POST['holiday_id'])) {
変更: branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Kiyaku.php
===================================================================
--- branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Kiyaku.php 2011-02-14 04:34:44 UTC (rev 20163)
+++ branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Kiyaku.php 2011-02-14 05:58:23 UTC (rev 20164)
@@ -67,7 +67,7 @@
*/
function action() {
$objSess = new SC_Session();
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
$objDb = new SC_Helper_DB_Ex();
// 認証可否の判定
@@ -145,7 +145,7 @@
/* DBへの挿入 */
function lfInsertClass($arrData) {
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
// INSERTする値を作成する。
$sqlval['kiyaku_title'] = $arrData['kiyaku_title'];
$sqlval['kiyaku_text'] = $arrData['kiyaku_text'];
@@ -161,7 +161,7 @@
/* DBへの更新 */
function lfUpdateClass($arrData) {
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
// UPDATEする値を作成する。
$sqlval['kiyaku_title'] = $arrData['kiyaku_title'];
$sqlval['kiyaku_text'] = $arrData['kiyaku_text'];
@@ -193,7 +193,7 @@
$objErr->doFunc(array("規約タイトル", "kiyaku_title", SMTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
$objErr->doFunc(array("規約内容", "kiyaku_text", MLTEXT_LEN), array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
if(!isset($objErr->arrErr['name'])) {
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
$arrRet = $objQuery->select("kiyaku_id, kiyaku_title", "dtb_kiyaku", "del_flg = 0 AND kiyaku_title = ?", array($_POST['kiyaku_title']));
// 編集中のレコード以外に同じ名称が存在する場合
if ($arrRet[0]['kiyaku_id'] != $_POST['kiyaku_id'] && $arrRet[0]['kiyaku_title'] == $_POST['kiyaku_title']) {
変更: branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Mail.php
===================================================================
--- branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Mail.php 2011-02-14 04:34:44 UTC (rev 20163)
+++ branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Mail.php 2011-02-14 05:58:23 UTC (rev 20164)
@@ -66,7 +66,7 @@
* @return void
*/
function action() {
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
$objSess = new SC_Session();
$masterData = new SC_DB_MasterData_Ex();
変更: branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Payment.php
===================================================================
--- branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Payment.php 2011-02-14 04:34:44 UTC (rev 20163)
+++ branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Payment.php 2011-02-14 05:58:23 UTC (rev 20164)
@@ -108,7 +108,7 @@
* 支払方法一覧の取得.
*/
function lfGetPaymentList() {
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
$col = "payment_id, payment_method, charge, rule, upper_rule, note, fix, charge_flg";
$where = "del_flg = 0";
$table = "dtb_payment";
変更: branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Payment_Input.php
===================================================================
--- branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Payment_Input.php 2011-02-14 04:34:44 UTC (rev 20163)
+++ branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Payment_Input.php 2011-02-14 05:58:23 UTC (rev 20164)
@@ -178,7 +178,7 @@
/* DBからデータを読み込む */
function lfGetData($payment_id) {
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
$where = "payment_id = ?";
$arrRet = $objQuery->select("*", "dtb_payment", $where, array($payment_id));
return $arrRet[0];
@@ -187,7 +187,7 @@
/* DBへデータを登録する */
function lfRegistData($payment_id = "") {
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
$sqlval = $this->objFormParam->getHashArray();
$arrRet = $this->objUpFile->getDBFileList(); // ファイル名の取得
$sqlval = array_merge($sqlval, $arrRet);
変更: branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Point.php
===================================================================
--- branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Point.php 2011-02-14 04:34:44 UTC (rev 20163)
+++ branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Point.php 2011-02-14 05:58:23 UTC (rev 20164)
@@ -72,7 +72,7 @@
*/
function action() {
$objSess = new SC_Session();
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
// 認証可否の判定
SC_Utils_Ex::sfIsSuccess($objSess);
@@ -142,7 +142,7 @@
// 入力データを渡す。
$sqlval = $this->objFormParam->getHashArray();
$sqlval['update_date'] = 'Now()';
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
// UPDATEの実行
$ret = $objQuery->update("dtb_baseinfo", $sqlval);
}
@@ -151,7 +151,7 @@
// 入力データを渡す。
$sqlval = $this->objFormParam->getHashArray();
$sqlval['update_date'] = 'Now()';
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
// INSERTの実行
$ret = $objQuery->insert("dtb_baseinfo", $sqlval);
}
変更: branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Seo.php
===================================================================
--- branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Seo.php 2011-02-14 04:34:44 UTC (rev 20163)
+++ branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Seo.php 2011-02-14 05:58:23 UTC (rev 20164)
@@ -136,7 +136,7 @@
* @return integer 更新結果
*/
function lfUpdPageData($arrUpdData = array()){
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
$sql = "";
// SQL生成
変更: branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Tradelaw.php
===================================================================
--- branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Tradelaw.php 2011-02-14 04:34:44 UTC (rev 20163)
+++ branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_Tradelaw.php 2011-02-14 05:58:23 UTC (rev 20164)
@@ -75,7 +75,7 @@
*/
function action() {
$objSess = new SC_Session();
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
// 認証可否の判定
SC_Utils_Ex::sfIsSuccess($objSess);
@@ -164,7 +164,7 @@
// 入力データを渡す。
$sqlval = $this->objFormParam->getHashArray();
$sqlval['update_date'] = 'Now()';
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
// UPDATEの実行
$ret = $objQuery->update("dtb_baseinfo", $sqlval);
}
@@ -173,7 +173,7 @@
// 入力データを渡す。
$sqlval = $this->objFormParam->getHashArray();
$sqlval['update_date'] = 'Now()';
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
// INSERTの実行
$ret = $objQuery->insert("dtb_baseinfo", $sqlval);
}
変更: branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_ZipInstall.php
===================================================================
--- branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_ZipInstall.php 2011-02-14 04:34:44 UTC (rev 20163)
+++ branches/version-2_5-dev/data/class/pages/admin/basis/LC_Page_Admin_Basis_ZipInstall.php 2011-02-14 05:58:23 UTC (rev 20164)
@@ -89,7 +89,7 @@
* @return void
*/
function action() {
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
SC_Utils_Ex::sfIsSuccess(new SC_Session);
@@ -163,7 +163,7 @@
* @return void
*/
function insertMtbZip($start = 1) {
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
$objSess = new SC_Session();
// 認証可否の判定
@@ -300,7 +300,7 @@
}
function countMtbZip() {
- $objQuery = new SC_Query();
+ $objQuery =& SC_Query::getSingletonInstance();
return $objQuery->count('mtb_zip');
}
Svn-src-all メーリングリストの案内