Changeset 11729 for branches/comu/html/admin/contents/index.php

Timestamp:

2007/03/10 21:35:02 (19 years ago)

Author:

nanasess

Message:

UTF-8 へ変換

File:

• branches/comu/html/admin/contents/index.php (modified) (14 diffs)

branches/comu/html/admin/contents/index.php

@@ -7 +7 @@
 require_once("../require.php");
 
-//---- ǧ¾Ú²ÄÈݤÎȽÄê
+//---- 認証可否の判定
 $objSess = new SC_Session();
 sfIsSuccess($objSess);
 
-//---- ¥Ú¡¼¥¸É½¼¨¥¯¥é¥¹
+//---- ページ表示クラス
 class LC_Page {
     
@@ -40 +40 @@
         $this->selected_month = date("n");
         $this->selected_day = date("j");
-        $this->tpl_subtitle = '¿·Ãå¾ðÊó´ÉÍý';
-    }
-}
-
-
-//---- ¥Ú¡¼¥¸½é´üÀßÄê
+        $this->tpl_subtitle = '新着情報管理';
+    }
+}
+
+
+//---- ページ初期設定
 $conn = new SC_DbConn();
 $objPage = new LC_Page();
@@ -51 +51 @@
 $objDate = new SC_Date(ADMIN_NEWS_STARTYEAR);
 
-//----¡¡ÆüÉÕ¥×¥ë¥À¥¦¥óÀßÄê
+//----　日付プルダウン設定
 $objPage->arrYear = $objDate->getYear();
 $objPage->arrMonth = $objDate->getMonth();
 $objPage->arrDay = $objDate->getDay();
 
-//----¡¡¿·µ¬ÅÐÏ¿/ÊÔ½¸ÅÐÏ¿
+//----　新規登録/編集登録
 if ( $_POST['mode'] == 'regist'){
     $_POST = lfConvData($_POST);
 
-    if ($objPage->arrErr = lfErrorCheck()) {        // ÆþÎÏ¥¨¥é¡¼¤Î¥Á¥§¥Ã¥¯
+    if ($objPage->arrErr = lfErrorCheck()) {        // 入力エラーのチェック
         foreach($_POST as $key => $val) {
             $objPage->$key = $val;
@@ -76 +76 @@
         $registDate = $_POST['year'] ."/". $_POST['month'] ."/". $_POST['day'];
 
-        //-- ÊÔ½¸ÅÐÏ¿
+        //-- 編集登録
         if (strlen($_POST["news_id"]) > 0 && is_numeric($_POST["news_id"])) {
 
             lfNewsUpdate();
 
-        //--¡¡¿·µ¬ÅÐÏ¿
+        //--　新規登録
         } else {
             lfNewsInsert();
         }
 
-        $objPage->tpl_onload = "window.alert('ÊÔ½¸¤¬´°Î»¤·¤Þ¤·¤¿');";
-    }
-}
-
-//----¡¡ÊÔ½¸¥Ç¡¼¥¿¼èÆÀ
+        $objPage->tpl_onload = "window.alert('編集が完了しました');";
+    }
+}
+
+//----　編集データ取得
 if ($_POST["mode"] == "search" && is_numeric($_POST["news_id"])) {
     $sql = "SELECT *, cast(substring(news_date,1, 10) as date) as cast_news_date FROM dtb_news WHERE news_id = ? ";
@@ -106 +106 @@
 }
 
-//----¡¡¥Ç¡¼¥¿ºï½ü
+//----　データ削除
 if ( $_POST['mode'] == 'delete' && is_numeric($_POST["news_id"])) {
     
-    // rank¤ò¼èÆÀ
+    // rankを取得
     $pre_rank = $conn->getone(" SELECT rank FROM dtb_news WHERE del_flg = 0 AND news_id = ? ", array( $_POST['news_id']  ));
 
-    //-- ºï½ü¤¹¤ë¿·Ãå¾ðÊó°Ê¹ß¤Îrank¤ò1¤Ä·«¤ê¾å¤²¤Æ¤ª¤¯
+    //-- 削除する新着情報以降のrankを1つ繰り上げておく
     $conn->query("BEGIN");
     $sql = "UPDATE dtb_news SET rank = rank - 1, update_date = NOW() WHERE del_flg = 0 AND rank > ?";
@@ -121 +121 @@
     $conn->query("COMMIT");
 
-    sfReload();             //¼«Ê¬¤Ë¥ê¥À¥¤¥ì¥¯¥È¡ÊºÆÆɹþ¤Ë¤è¤ë¸íÆ°ºîËɻߡË
-}
-
-//----¡¡É½¼¨½ç°Ì°ÜÆ°
+    sfReload();             //自分にリダイレクト（再読込による誤動作防止）
+}
+
+//----　表示順位移動
 
 if ( $_POST['mode'] == 'move' && is_numeric($_POST["news_id"]) ) {
@@ -136 +136 @@
 }
 
-//----¡¡»ØÄêɽ¼¨½ç°Ì°ÜÆ°
+//----　指定表示順位移動
 if ($_POST['mode'] == 'moveRankSet') {
     $key = "pos-".$_POST['news_id'];
@@ -147 +147 @@
 
 
-//---- Á´¥Ç¡¼¥¿¼èÆÀ
+//---- 全データ取得
 $sql = "SELECT *, cast(substring(news_date,1, 10) as date) as cast_news_date FROM dtb_news WHERE del_flg = '0' ORDER BY rank DESC";
 $objPage->list_data = $conn->getAll($sql);
 $objPage->line_max = count($objPage->list_data);
-$sql = "SELECT MAX(rank) FROM dtb_news WHERE del_flg = '0'";        // rank¤ÎºÇÂçÃͤò¼èÆÀ
+$sql = "SELECT MAX(rank) FROM dtb_news WHERE del_flg = '0'";        // rankの最大値を取得
 $objPage->max_rank = $conn->getOne($sql);
 
 $objPage->arrForm['news_select'] = 0;
 
-//----¡¡¥Ú¡¼¥¸É½¼¨
+//----　ページ表示
 $objView->assignobj($objPage);
 $objView->display(MAIN_FRAME);
@@ -163 +163 @@
 //function --------------------------------------------------------------------------------------------- 
 
-//---- ÆþÎÏʸ»úÎó¤òÇÛÎó¤Ø
+//---- 入力文字列を配列へ
 function lfConvData( $data ){
     
-     // ʸ»úÎó¤ÎÊÑ´¹¡Êmb_convert_kana¤ÎÊÑ´¹¥ª¥×¥·¥ç¥ó¡Ë                         
+     // 文字列の変換（mb_convert_kanaの変換オプション）                         
     $arrFlag = array(
                       "year" => "n"
@@ -186 +186 @@
 }
 
-//----¡¡»ØÄê½ç°Ì¤Ø°ÜÆ°
+//----　指定順位へ移動
 function sf_setRankPosition($conn, $tableName, $keyIdColumn, $keyId, $position) {
 
-    // ¼«¿È¤Î¥é¥ó¥¯¤ò¼èÆÀ¤¹¤ë
+    // 自身のランクを取得する
     $conn->query("BEGIN");
     $rank = $conn->getOne("SELECT rank FROM $tableName WHERE $keyIdColumn = ?", array($keyId)); 
 
-    if( $position > $rank ) $term = "- 1";  //Æþ¤ìÂؤ¨Àè¤Î½ç°Ì¤¬Æþ¤ì´¹¤¨¸µ¤Î½ç°Ì¤è¤êÂ礭¤¤¾ì¹ç
-    if( $position < $rank ) $term = "+ 1";  //Æþ¤ìÂؤ¨Àè¤Î½ç°Ì¤¬Æþ¤ì´¹¤¨¸µ¤Î½ç°Ì¤è¤ê¾®¤µ¤¤¾ì¹ç
-
-    //--¡¡»ØÄꤷ¤¿½ç°Ì¤Î¾¦Éʤ«¤é°ÜÆ°¤µ¤»¤ë¾¦ÉʤޤǤÎrank¤ò£±¤Ä¤º¤é¤¹
+    if( $position > $rank ) $term = "- 1";  //入れ替え先の順位が入れ換え元の順位より大きい場合
+    if( $position < $rank ) $term = "+ 1";  //入れ替え先の順位が入れ換え元の順位より小さい場合
+
+    //--　指定した順位の商品から移動させる商品までのrankを１つずらす
     $sql = "UPDATE $tableName SET rank = rank $term, update_date = NOW() WHERE rank BETWEEN ? AND ? AND del_flg = 0";
     if( $position > $rank ) $conn->query( $sql, array( $rank + 1, $position ) );
     if( $position < $rank ) $conn->query( $sql, array( $position, $rank - 1 ) );
 
-    //-- »ØÄꤷ¤¿½ç°Ì¤Ørank¤ò½ñ¤­´¹¤¨¤ë¡£
+    //-- 指定した順位へrankを書き換える。
     $sql  = "UPDATE $tableName SET rank = ?, update_date = NOW() WHERE $keyIdColumn = ? AND del_flg = 0 ";
     $conn->query( $sql, array( $position, $keyId ) );
@@ -207 +207 @@
 }
 
-//---- ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯¡Ê½ç°Ì°ÜÆ°ÍÑ¡Ë
+//---- 入力エラーチェック（順位移動用）
 function sf_errorCheckPosition($conn, $tableName, $position, $keyIdColumn, $keyId) {
 
     $objErr = new SC_CheckError();
-    $objErr->doFunc( array("°ÜÆ°½ç°Ì", "moveposition", 4 ), array( "ZERO_CHECK", "NUM_CHECK", "EXIST_CHECK", "MAX_LENGTH_CHECK" ) );
-
-    // ¼«¿È¤Î¥é¥ó¥¯¤ò¼èÆÀ¤¹¤ë¡£
+    $objErr->doFunc( array("移動順位", "moveposition", 4 ), array( "ZERO_CHECK", "NUM_CHECK", "EXIST_CHECK", "MAX_LENGTH_CHECK" ) );
+
+    // 自身のランクを取得する。
     $rank = $conn->getOne("SELECT rank FROM $tableName WHERE $keyIdColumn = ?", array($keyId));
-    if ($rank == $position ) $objErr->arrErr["moveposition"] .= "¢¨ »ØÄꤷ¤¿°ÜÆ°½ç°Ì¤Ï¸½ºß¤Î½ç°Ì¤Ç¤¹¡£";
-    
-    // rank¤ÎºÇÂçÃͰʾå¤ÎÆþÎϤòµöÍƤ·¤Ê¤¤                                            
+    if ($rank == $position ) $objErr->arrErr["moveposition"] .= "※ 指定した移動順位は現在の順位です。";
+    
+    // rankの最大値以上の入力を許容しない                                           
     if( ! $objErr->arrErr["position"] ) {                                
         $sql = "SELECT MAX( rank ) FROM " .$tableName. " WHERE del_flg = 0";
         $result = $conn->getOne($sql);
-        if( $position > $result ) $objErr->arrErr["moveposition"] .= "¢¨ ÆþÎϤµ¤ì¤¿½ç°Ì¤Ï¡¢ÅÐÏ¿¿ô¤ÎºÇÂçÃͤòĶ¤¨¤Æ¤¤¤Þ¤¹¡£";
+        if( $position > $result ) $objErr->arrErr["moveposition"] .= "※ 入力された順位は、登録数の最大値を超えています。";
     }
 
@@ -227 +227 @@
 }
 
-//---- ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯
+//---- 入力エラーチェック
 function lfErrorCheck(){
 
     $objErr = new SC_CheckError();
 
-    $objErr->doFunc(array("ÆüÉÕ(ǯ)", "year"), array("EXIST_CHECK"));
-    $objErr->doFunc(array("ÆüÉÕ(·î)", "month"), array("EXIST_CHECK"));
-    $objErr->doFunc(array("ÆüÉÕ(Æü)", "day"), array("EXIST_CHECK"));
-    $objErr->doFunc(array("ÆüÉÕ", "year", "month", "day"), array("CHECK_DATE"));
-    $objErr->doFunc(array("¥¿¥¤¥È¥ë", 'news_title', MTEXT_LEN), array("EXIST_CHECK","MAX_LENGTH_CHECK"));
-    $objErr->doFunc(array("ËÜʸ", 'url', URL_LEN), array("MAX_LENGTH_CHECK"));
-    $objErr->doFunc(array("ËÜʸ", 'news_comment', LTEXT_LEN), array("MAX_LENGTH_CHECK"));
+    $objErr->doFunc(array("日付(年)", "year"), array("EXIST_CHECK"));
+    $objErr->doFunc(array("日付(月)", "month"), array("EXIST_CHECK"));
+    $objErr->doFunc(array("日付(日)", "day"), array("EXIST_CHECK"));
+    $objErr->doFunc(array("日付", "year", "month", "day"), array("CHECK_DATE"));
+    $objErr->doFunc(array("タイトル", 'news_title', MTEXT_LEN), array("EXIST_CHECK","MAX_LENGTH_CHECK"));
+    $objErr->doFunc(array("本文", 'url', URL_LEN), array("MAX_LENGTH_CHECK"));
+    $objErr->doFunc(array("本文", 'news_comment', LTEXT_LEN), array("MAX_LENGTH_CHECK"));
 
     return $objErr->arrErr;
 }
 
-//INSERTʸ
+//INSERT文
 function lfNewsInsert(){
     global $conn;
@@ -252 +252 @@
     }
     
-    //rank¤ÎºÇÂç+1¤ò¼èÆÀ¤¹¤ë
+    //rankの最大+1を取得する
     $rank_max = $conn->getone("SELECT MAX(rank) + 1 FROM dtb_news WHERE del_flg = '0'");
 
@@ -261 +261 @@
     $conn->query($sql, $arrRegist);
     
-    // ºÇ½é¤Î1·ïÌܤÎÅÐÏ¿¤Ïrank¤ËNULL¤¬Æþ¤ë¤Î¤ÇÂкö
+    // 最初の1件目の登録はrankにNULLが入るので対策
     $sql = "UPDATE dtb_news SET rank = 1 WHERE del_flg = 0 AND rank IS NULL";
     $conn->query($sql);