Changeset 18770 for branches/version-2_5-dev/data/class/pages/admin/contents/LC_Page_Admin_Contents.php
- Timestamp:
- 2010/08/03 14:06:25 (14 years ago)
- 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
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/data/class/pages/admin/contents/LC_Page_Admin_Contents.php
r18701 r18770 62 62 63 63 //---- ページ初期設定 64 $ conn = new SC_DbConn();64 $objQuery = new SC_Query(); 65 65 $objView = new SC_AdminView(); 66 66 $objDate = new SC_Date(ADMIN_NEWS_STARTYEAR); … … 93 93 if (strlen($_POST["news_id"]) > 0 && is_numeric($_POST["news_id"])) { 94 94 95 $this->lfNewsUpdate($ conn);95 $this->lfNewsUpdate($objQuery); 96 96 97 97 //-- 新規登録 98 98 } else { 99 $this->lfNewsInsert($ conn);99 $this->lfNewsInsert($objQuery); 100 100 } 101 101 … … 107 107 if ($_POST["mode"] == "search" && is_numeric($_POST["news_id"])) { 108 108 $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"])); 110 110 $this->arrForm = $result[0]; 111 111 … … 122 122 123 123 // 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'] )); 125 125 126 126 //-- 削除する新着情報以降のrankを1つ繰り上げておく 127 $ conn->query("BEGIN");127 $objQuery->begin(); 128 128 $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 ) ); 130 130 131 131 $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(); 134 134 135 135 $this->reload(); //自分にリダイレクト(再読込による誤動作防止) … … 160 160 //---- 全データ取得 161 161 $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); 163 163 $this->line_max = count($this->list_data); 164 164 $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); 166 166 167 167 //---- ページ表示 … … 208 208 209 209 //---- 指定順位へ移動 210 function sf_setRankPosition(&$ conn, $tableName, $keyIdColumn, $keyId, $position) {210 function sf_setRankPosition(&$objQuery, $tableName, $keyIdColumn, $keyId, $position) { 211 211 212 212 // 自身のランクを取得する 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)); 215 215 216 216 if( $position > $rank ) $term = "- 1"; //入れ替え先の順位が入れ換え元の順位より大きい場合 … … 219 219 //-- 指定した順位の商品から移動させる商品までのrankを1つずらす 220 220 $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 ) ); 223 223 224 224 //-- 指定した順位へrankを書き換える。 225 225 $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(); 228 228 } 229 229 230 230 //---- 入力エラーチェック(順位移動用) 231 function sf_errorCheckPosition(&$ conn, $tableName, $position, $keyIdColumn, $keyId) {231 function sf_errorCheckPosition(&$objQuery, $tableName, $position, $keyIdColumn, $keyId) { 232 232 233 233 $objErr = new SC_CheckError(); … … 235 235 236 236 // 自身のランクを取得する。 237 $rank = $ conn->getOne("SELECT rank FROM $tableName WHERE $keyIdColumn = ?", array($keyId));237 $rank = $objQuery->getOne("SELECT rank FROM $tableName WHERE $keyIdColumn = ?", array($keyId)); 238 238 if ($rank == $position ) $objErr->arrErr["moveposition"] .= "※ 指定した移動順位は現在の順位です。"; 239 239 … … 241 241 if( ! $objErr->arrErr["position"] ) { 242 242 $sql = "SELECT MAX( rank ) FROM " .$tableName. " WHERE del_flg = 0"; 243 $result = $ conn->getOne($sql);243 $result = $objQuery->getOne($sql); 244 244 if( $position > $result ) $objErr->arrErr["moveposition"] .= "※ 入力された順位は、登録数の最大値を超えています。"; 245 245 } … … 265 265 266 266 //INSERT文 267 function lfNewsInsert(&$ conn){267 function lfNewsInsert(&$objQuery){ 268 268 269 269 if ($_POST["link_method"] == "") { … … 272 272 273 273 //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'"); 275 275 276 276 $sql = "INSERT INTO dtb_news (news_date, news_title, creator_id, news_url, link_method, news_comment, rank, create_date, update_date) … … 278 278 $arrRegist = array($this->registDate, $_POST["news_title"], $_SESSION['member_id'], $_POST["news_url"], $_POST["link_method"], $_POST["news_comment"], $rank_max); 279 279 280 $ conn->query($sql, $arrRegist);280 $objQuery->query($sql, $arrRegist); 281 281 282 282 // 最初の1件目の登録はrankにNULLが入るので対策 283 283 $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){ 288 288 289 289 if ($_POST["link_method"] == "") { … … 294 294 $arrRegist = array($this->registDate, $_POST['news_title'], $_SESSION['member_id'], $_POST['news_url'], $_POST["link_method"], $_POST['news_comment'], $_POST['news_id']); 295 295 296 $ conn->query($sql, $arrRegist);296 $objQuery->query($sql, $arrRegist); 297 297 } 298 298 }
Note: See TracChangeset
for help on using the changeset viewer.