Changeset 4608 for temp/trunk/html/admin/system

Timestamp:

2006/09/11 19:37:56 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk/html/admin/system

Files:

• delete.php (modified) (2 diffs)
• index.php (modified) (1 diff)
• input.php (modified) (3 diffs)
• member_csv.php (modified) (1 diff)
• update.php (modified) (1 diff)

temp/trunk/html/admin/system/delete.php

@@ -31 +31 @@
     $rank = $oquery->get("dtb_member", "rank", $where);
     // ºï½ü¤·¤¿¥ì¥³¡¼¥É¤è¤ê¾å¤Î¥é¥ó¥­¥ó¥°¤ò²¼¤²¤ÆRANK¤Î¶õ¤­¤òËä¤á¤ë¡£
-    $sqlup = "UPDATE dtb_member SET rank = (rank - 1) WHERE rank > $rank AND delete <> 1";
+    $sqlup = "UPDATE dtb_member SET rank = (rank - 1) WHERE rank > $rank AND del_flg <> 1";
     // UPDATE¤Î¼Â¹Ô
     $ret = $conn->query($sqlup);
@@ -40 +40 @@
 function fnDeleteRecord($conn, $id) {
     // ¥é¥ó¥¯¤òºÇ²¼°Ì¤Ë¤¹¤ë¡¢DEL¥Õ¥é¥°ON
-    $sqlup = "UPDATE dtb_member SET rank = 0, delete = 1 WHERE member_id = $id";
+    $sqlup = "UPDATE dtb_member SET rank = 0, del_flg = 1 WHERE member_id = $id";
     // UPDATE¤Î¼Â¹Ô
     $ret = $conn->query($sqlup);

temp/trunk/html/admin/system/index.php

@@ -35 +35 @@
 $objSql->setSelect("SELECT member_id,name,department,login_id,authority,rank,work FROM dtb_member");
 $objSql->setOrder("rank DESC");
-$objSql->setWhere("delete <> 1 AND member_id <> ". ADMIN_ID);
+$objSql->setWhere("del_flg <> 1 AND member_id <> ". ADMIN_ID);
 
 //´Ê°×¥¯¥¨¥ê¼Â¹Ô¥ª¥Ö¥¸¥§¥¯¥È
 $oquery = new SC_Query();
 // ¹Ô¿ô¤Î¼èÆÀ
-$linemax = $oquery->count("dtb_member", "delete <> 1 AND member_id <>".ADMIN_ID);
+$linemax = $oquery->count("dtb_member", "del_flg <> 1 AND member_id <>".ADMIN_ID);
 
 // ²ÔÆ°Ãæ¤Î·ï¿ô¤ò¼èÆÀ
-$workmax = $oquery->count("dtb_member", "work = 1 AND delete <> 1 AND member_id <>".ADMIN_ID);
+$workmax = $oquery->count("dtb_member", "work = 1 AND del_flg <> 1 AND member_id <>".ADMIN_ID);
 $objPage->workmax= $workmax;
 

temp/trunk/html/admin/system/input.php

@@ -112 +112 @@
     // ÊÔ½¸¥â¡¼¥É¤Ç¤Ê¤¤¾ì¹ç¤Ï¡¢½ÅÊ£¥Á¥§¥Ã¥¯
     if (!isset($objErr->arrErr['name']) && $_POST['mode'] != 'edit') {
-        $sql = "SELECT name FROM dtb_member WHERE delete <> 1 AND name = ?";
+        $sql = "SELECT name FROM dtb_member WHERE del_flg <> 1 AND name = ?";
         $result = $conn->getOne($sql, array($_POST['name'])); 
         if ( $result ) {
@@ -125 +125 @@
     // ¿·µ¬¥â¡¼¥É¤â¤·¤¯¤Ï¡¢ÊÔ½¸¥â¡¼¥É¤Ç¥í¥°¥¤¥óID¤¬Êѹ¹¤µ¤ì¤Æ¤¤¤ë¾ì¹ç¤Ï¥Á¥§¥Ã¥¯¤¹¤ë¡£
     if (!isset($objErr->arrErr['login_id']) && $_POST['mode'] != 'edit' || ($_POST['mode'] == 'edit' && $_POST['login_id'] != $_POST['old_login_id'])) {
-        $sql = "SELECT login_id FROM dtb_member WHERE delete <> 1 AND login_id = ?";
+        $sql = "SELECT login_id FROM dtb_member WHERE del_flg <> 1 AND login_id = ?";
         $result = $conn->getOne($sql, array($_POST['login_id'])); 
         if ( $result != "" ) {
@@ -158 +158 @@
     $sqlval['rank']=  $oquery->max("dtb_member", "rank") + 1;
     $sqlval['work'] = "1"; // ²ÔƯ¤ËÀßÄê
-    $sqlval['delete'] = "0";    // ºï½ü¥Õ¥é¥°¤òOFF¤ËÀßÄê
+    $sqlval['del_flg'] = "0";   // ºï½ü¥Õ¥é¥°¤òOFF¤ËÀßÄê
     $sqlval['creator_id'] = $_SESSION['member_id'];
     // INSERT¤Î¼Â¹Ô

temp/trunk/html/admin/system/member_csv.php

@@ -16 +16 @@
     $oquery = new SC_Query();
     $cols = "authority,name,department,login_id,work";
-    $oquery->setwhere("delete <> 1");
+    $oquery->setwhere("del_flg <> 1");
     $oquery->andwhere("member_id <> ".ADMIN_ID);
     $oquery->setoption("ORDER BY rank DESC");

temp/trunk/html/admin/system/update.php

@@ -145 +145 @@
                 $sqlval['uninstall_sql'] = $arrCSV[8];              
                 $sqlval['other_files'] = $arrCSV[9];
-                $sqlval['delete'] = $arrCSV[10];
+                $sqlval['del_flg'] = $arrCSV[10];
                 $sqlval['update_date'] = "now()";
                 $sqlval['release_date'] = $arrCSV[12];