Ignore:
Timestamp:
2010/08/03 14:06:25 (14 years ago)
Author:
nanasess
bzr:base-revision:
ohkouchi@loop-az.jp-20100803024346-cpwzialqa7f40fo9
bzr:committer:
Kentaro Ohkouchi <ohkouchi@loop-az.jp>
bzr:file-ids:

data/class/SC_Customer.php 15078@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2FSC_Customer.php
data/class/helper/SC_Helper_Mobile.php 15277@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fhelper%2FSC_Helper_Mobile.php
data/class/pages/LC_Page_Sitemap.php 16385@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2FLC_Page_Sitemap.php
data/class/pages/admin/contents/LC_Page_Admin_Contents.php 15659@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fcontents%2FLC_Page_Admin_Contents.php
data/class/pages/admin/contents/LC_Page_Admin_Contents_CsvSql.php 16449@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fcontents%2FLC_Page_Admin_Contents_CsvSql.php
data/class/pages/admin/design/LC_Page_Admin_Design.php 15680@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fdesign%2FLC_Page_Admin_Design.php
data/class/pages/admin/design/LC_Page_Admin_Design_Bloc.php 15687@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fdesign%2FLC_Page_Admin_Design_Bloc.php
data/class/pages/admin/design/LC_Page_Admin_Design_MainEdit.php 15682@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fdesign%2FLC_Page_Admin_Design_MainEdit.php
data/class/pages/admin/mail/LC_Page_Admin_Mail_Sendmail.php 16321@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fmail%2FLC_Page_Admin_Mail_Sendmail.php
data/class/pages/admin/system/LC_Page_Admin_System_Rank.php 16829@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fadmin%2Fsystem%2FLC_Page_Admin_System_Rank.php
data/class/pages/entry/LC_Page_Entry.php 15141@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fentry%2FLC_Page_Entry.php
data/class/pages/mypage/LC_Page_Mypage_Change.php 16070@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fmypage%2FLC_Page_Mypage_Change.php
data/class/pages/mypage/LC_Page_Mypage_Favorite.php 17162@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Fcomu-ver2%2Fdata%2Fclass%2Fpages%2Fmypage%2FLC_Page_Mypage_Favorite.php
data/class/pages/products/LC_Page_Products_Detail.php 15154@1e3b908f-19a9-db11-a64c-001125224ba8:branches%2Ffeature-module-update%2Fdata%2Fclass%2Fpages%2Fproducts%2FLC_Page_Products_Detail.php
bzr:mapping-version:
v4
bzr:repository-uuid:
1e3b908f-19a9-db11-a64c-001125224ba8
bzr:revision-id:
ohkouchi@loop-az.jp-20100803050621-j3gswdse0qsqamvw
bzr:revno:
2253
bzr:revprop:branch-nick:
branches/version-2_5-dev
bzr:root:
branches/version-2_5-dev
bzr:text-parents:

data/class/SC_Customer.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/helper/SC_Helper_Mobile.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/LC_Page_Sitemap.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/admin/contents/LC_Page_Admin_Contents.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/admin/contents/LC_Page_Admin_Contents_CsvSql.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/admin/design/LC_Page_Admin_Design.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/admin/design/LC_Page_Admin_Design_Bloc.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/admin/design/LC_Page_Admin_Design_MainEdit.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/admin/mail/LC_Page_Admin_Mail_Sendmail.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/admin/system/LC_Page_Admin_System_Rank.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/entry/LC_Page_Entry.php ohkouchi@loop-az.jp-20100623032937-dhwktuevjyk0jv13
data/class/pages/mypage/LC_Page_Mypage_Change.php ohkouchi@loop-az.jp-20100623032937-dhwktuevjyk0jv13
data/class/pages/mypage/LC_Page_Mypage_Favorite.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
data/class/pages/products/LC_Page_Products_Detail.php ohkouchi@loop-az.jp-20100614082857-g3n9wn9zakpc7a0m
bzr:timestamp:
2010-08-03 14:06:21.516999960 +0900
bzr:user-agent:
bzr2.1.2+bzr-svn1.0.2
svn:original-date:
2010-08-03T05:06:21.517000Z
Message:
  • SC_DbConn のインスタンスを直接使用している個所を SC_Query に変更(#565)
    • 削除予定の機能については未対応
  • SC_Customer で未使用の処理を削除
File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_5-dev/data/class/pages/admin/contents/LC_Page_Admin_Contents.php

    r18701 r18770  
    6262 
    6363        //---- ページ初期設定 
    64         $conn = new SC_DbConn(); 
     64        $objQuery = new SC_Query(); 
    6565        $objView = new SC_AdminView(); 
    6666        $objDate = new SC_Date(ADMIN_NEWS_STARTYEAR); 
     
    9393                if (strlen($_POST["news_id"]) > 0 && is_numeric($_POST["news_id"])) { 
    9494 
    95                     $this->lfNewsUpdate($conn); 
     95                    $this->lfNewsUpdate($objQuery); 
    9696 
    9797                    //-- 新規登録 
    9898                } else { 
    99                     $this->lfNewsInsert($conn); 
     99                    $this->lfNewsInsert($objQuery); 
    100100                } 
    101101 
     
    107107        if ($_POST["mode"] == "search" && is_numeric($_POST["news_id"])) { 
    108108            $sql = "SELECT *, cast(news_date as date) as cast_news_date FROM dtb_news WHERE news_id = ? "; 
    109             $result = $conn->getAll($sql, array($_POST["news_id"])); 
     109            $result = $objQuery->getAll($sql, array($_POST["news_id"])); 
    110110            $this->arrForm = $result[0]; 
    111111 
     
    122122 
    123123            // rankを取得 
    124             $pre_rank = $conn->getOne(" SELECT rank FROM dtb_news WHERE del_flg = 0 AND news_id = ? ", array( $_POST['news_id']  )); 
     124            $pre_rank = $objQuery->getOne(" SELECT rank FROM dtb_news WHERE del_flg = 0 AND news_id = ? ", array( $_POST['news_id']  )); 
    125125 
    126126            //-- 削除する新着情報以降のrankを1つ繰り上げておく 
    127             $conn->query("BEGIN"); 
     127            $objQuery->begin(); 
    128128            $sql = "UPDATE dtb_news SET rank = rank - 1, update_date = NOW() WHERE del_flg = 0 AND rank > ?"; 
    129             $conn->query( $sql, array( $pre_rank  ) ); 
     129            $objQuery->query( $sql, array( $pre_rank  ) ); 
    130130 
    131131            $sql = "UPDATE dtb_news SET rank = 0, del_flg = 1, update_date = NOW() WHERE news_id = ?"; 
    132             $conn->query( $sql, array( $_POST['news_id'] ) ); 
    133             $conn->query("COMMIT"); 
     132            $objQuery->query( $sql, array( $_POST['news_id'] ) ); 
     133            $objQuery->commit(); 
    134134 
    135135            $this->reload();             //自分にリダイレクト(再読込による誤動作防止) 
     
    160160        //---- 全データ取得 
    161161        $sql = "SELECT *, cast(news_date as date) as cast_news_date FROM dtb_news WHERE del_flg = '0' ORDER BY rank DESC"; 
    162         $this->list_data = $conn->getAll($sql); 
     162        $this->list_data = $objQuery->getAll($sql); 
    163163        $this->line_max = count($this->list_data); 
    164164        $sql = "SELECT MAX(rank) FROM dtb_news WHERE del_flg = '0'";        // rankの最大値を取得 
    165         $this->max_rank = $conn->getOne($sql); 
     165        $this->max_rank = $objQuery->getOne($sql); 
    166166 
    167167        //---- ページ表示 
     
    208208 
    209209    //---- 指定順位へ移動 
    210     function sf_setRankPosition(&$conn, $tableName, $keyIdColumn, $keyId, $position) { 
     210    function sf_setRankPosition(&$objQuery, $tableName, $keyIdColumn, $keyId, $position) { 
    211211 
    212212        // 自身のランクを取得する 
    213         $conn->query("BEGIN"); 
    214         $rank = $conn->getOne("SELECT rank FROM $tableName WHERE $keyIdColumn = ?", array($keyId)); 
     213        $objQuery->begin(); 
     214        $rank = $objQuery->getOne("SELECT rank FROM $tableName WHERE $keyIdColumn = ?", array($keyId)); 
    215215 
    216216        if( $position > $rank ) $term = "- 1";  //入れ替え先の順位が入れ換え元の順位より大きい場合 
     
    219219        //-- 指定した順位の商品から移動させる商品までのrankを1つずらす 
    220220        $sql = "UPDATE $tableName SET rank = rank $term, update_date = NOW() WHERE rank BETWEEN ? AND ? AND del_flg = 0"; 
    221         if( $position > $rank ) $conn->query( $sql, array( $rank + 1, $position ) ); 
    222         if( $position < $rank ) $conn->query( $sql, array( $position, $rank - 1 ) ); 
     221        if( $position > $rank ) $objQuery->query( $sql, array( $rank + 1, $position ) ); 
     222        if( $position < $rank ) $objQuery->query( $sql, array( $position, $rank - 1 ) ); 
    223223 
    224224        //-- 指定した順位へrankを書き換える。 
    225225        $sql  = "UPDATE $tableName SET rank = ?, update_date = NOW() WHERE $keyIdColumn = ? AND del_flg = 0 "; 
    226         $conn->query( $sql, array( $position, $keyId ) ); 
    227         $conn->query("COMMIT"); 
     226        $objQuery->query( $sql, array( $position, $keyId ) ); 
     227        $objQuery->commit(); 
    228228    } 
    229229 
    230230    //---- 入力エラーチェック(順位移動用) 
    231     function sf_errorCheckPosition(&$conn, $tableName, $position, $keyIdColumn, $keyId) { 
     231    function sf_errorCheckPosition(&$objQuery, $tableName, $position, $keyIdColumn, $keyId) { 
    232232 
    233233        $objErr = new SC_CheckError(); 
     
    235235 
    236236        // 自身のランクを取得する。 
    237         $rank = $conn->getOne("SELECT rank FROM $tableName WHERE $keyIdColumn = ?", array($keyId)); 
     237        $rank = $objQuery->getOne("SELECT rank FROM $tableName WHERE $keyIdColumn = ?", array($keyId)); 
    238238        if ($rank == $position ) $objErr->arrErr["moveposition"] .= "※ 指定した移動順位は現在の順位です。"; 
    239239 
     
    241241        if( ! $objErr->arrErr["position"] ) { 
    242242            $sql = "SELECT MAX( rank ) FROM " .$tableName. " WHERE del_flg = 0"; 
    243             $result = $conn->getOne($sql); 
     243            $result = $objQuery->getOne($sql); 
    244244            if( $position > $result ) $objErr->arrErr["moveposition"] .= "※ 入力された順位は、登録数の最大値を超えています。"; 
    245245        } 
     
    265265 
    266266    //INSERT文 
    267     function lfNewsInsert(&$conn){ 
     267    function lfNewsInsert(&$objQuery){ 
    268268 
    269269        if ($_POST["link_method"] == "") { 
     
    272272 
    273273        //rankの最大+1を取得する 
    274         $rank_max = $conn->getOne("SELECT MAX(rank) + 1 FROM dtb_news WHERE del_flg = '0'"); 
     274        $rank_max = $objQuery->getOne("SELECT MAX(rank) + 1 FROM dtb_news WHERE del_flg = '0'"); 
    275275 
    276276        $sql = "INSERT INTO dtb_news (news_date, news_title, creator_id, news_url, link_method, news_comment, rank, create_date, update_date) 
     
    278278        $arrRegist = array($this->registDate, $_POST["news_title"], $_SESSION['member_id'],  $_POST["news_url"], $_POST["link_method"], $_POST["news_comment"], $rank_max); 
    279279 
    280         $conn->query($sql, $arrRegist); 
     280        $objQuery->query($sql, $arrRegist); 
    281281 
    282282        // 最初の1件目の登録はrankにNULLが入るので対策 
    283283        $sql = "UPDATE dtb_news SET rank = 1 WHERE del_flg = 0 AND rank IS NULL"; 
    284         $conn->query($sql); 
    285     } 
    286  
    287     function lfNewsUpdate(&$conn){ 
     284        $objQuery->query($sql); 
     285    } 
     286 
     287    function lfNewsUpdate(&$objQuery){ 
    288288 
    289289        if ($_POST["link_method"] == "") { 
     
    294294        $arrRegist = array($this->registDate, $_POST['news_title'], $_SESSION['member_id'], $_POST['news_url'], $_POST["link_method"], $_POST['news_comment'], $_POST['news_id']); 
    295295 
    296         $conn->query($sql, $arrRegist); 
     296        $objQuery->query($sql, $arrRegist); 
    297297    } 
    298298} 
Note: See TracChangeset for help on using the changeset viewer.