Changeset 6333 for temp/trunk/data/update

Timestamp:

2006/10/13 18:25:45 (20 years ago)

Author:

naka

Message:

* empty log message *

File:

• temp/trunk/data/update/admin/products/category.php (modified) (1 diff)

temp/trunk/data/update/admin/products/category.php

@@ -142 +142 @@
 //-----------------------------------------------------------------------------------------------------------------------------------
 
-// ¥«¥Æ¥´¥ê¤Î¿·µ¬ÄɲÃ
-function lfInsertCat($parent_category_id) {
-    global $objFormParam;
-    
-    $objQuery = new SC_Query();
-    $objQuery->begin(); // ¥È¥é¥ó¥¶¥¯¥·¥ç¥ó¤Î³«»Ï
-    
-    
-    if($parent_category_id == 0) {
-        // ROOT³¬ÁؤǺÇÂç¤Î¥é¥ó¥¯¤ò¼èÆÀ¤¹¤ë¡£       
-        $where = "parent_category_id = ?";
-        $rank = $objQuery->max("dtb_category", "rank", $where, array($parent_category_id)) + 1;
-    } else {
-        // ¿Æ¤Î¥é¥ó¥¯¤ò¼«Ê¬¤Î¥é¥ó¥¯¤È¤¹¤ë¡£
-        $where = "category_id = ?";
-        $rank = $objQuery->get("dtb_category", "rank", $where, array($parent_category_id));
-        // Äɲå쥳¡¼¥É¤Î¥é¥ó¥¯°Ê¾å¤Î¥ì¥³¡¼¥É¤ò°ì¤Ä¤¢¤²¤ë¡£
-        $sqlup = "UPDATE dtb_category SET rank = (rank + 1) WHERE rank >= ?";
-        $objQuery->exec($sqlup, array($rank));
-    }
-    
-    $where = "category_id = ?";
-    // ¼«Ê¬¤Î¥ì¥Ù¥ë¤ò¼èÆÀ¤¹¤ë(¿Æ¤Î¥ì¥Ù¥ë + 1)   
-    $level = $objQuery->get("dtb_category", "level", $where, array($parent_category_id)) + 1;
-    
-    // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£
-    $sqlval = $objFormParam->getHashArray();
-    $sqlval['create_date'] = "Now()";
-    $sqlval['update_date'] = "Now()";
-    $sqlval['creator_id'] = $_SESSION['member_id'];
-    $sqlval['parent_category_id'] = $parent_category_id;
-    $sqlval['rank'] = $rank;
-    $sqlval['level'] = $level;
-    
-    // INSERT¤Î¼Â¹Ô
-    $objQuery->insert("dtb_category", $sqlval);
-    
-    $objQuery->commit();    // ¥È¥é¥ó¥¶¥¯¥·¥ç¥ó¤Î½ªÎ»
-}
-
-// ¥«¥Æ¥´¥ê¤ÎÊÔ½¸
-function lfUpdateCat($category_id) {
-    global $objFormParam;
-    $objQuery = new SC_Query();
-    // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£
-    $sqlval = $objFormParam->getHashArray();
-    $sqlval['update_date'] = "Now()";
-    $where = "category_id = ?";
-    $objQuery->update("dtb_category", $sqlval, $where, array($category_id));
-}
-
-// ¥«¥Æ¥´¥ê¤Î¼èÆÀ
-function lfGetCat($parent_category_id) {
-    $objQuery = new SC_Query();
-    $col = "category_id, category_name, level, rank";
-    $where = "del_flg = 0 AND parent_category_id = ?";
-    $objQuery->setoption("ORDER BY rank DESC");
-    $arrRet = $objQuery->select($col, "dtb_category", $where, array($parent_category_id));
-    return $arrRet;
-}
-
-/* ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ */
-function lfInitParam() {
-    global $objFormParam;
-    $objFormParam->addParam("¥«¥Æ¥´¥ê̾", "category_name", STEXT_LEN, "KVa", array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
-}
-
-/* ÆþÎÏÆâÍƤΥÁ¥§¥Ã¥¯ */
-function lfCheckError($array) {
-    global $objFormParam;
-    $objErr = new SC_CheckError($array);
-    $objErr->arrErr = $objFormParam->checkError();
-    
-    // ³¬ÁØ¥Á¥§¥Ã¥¯
-    if(!isset($objErr->arrErr['category_name'])) {
-        $objQuery = new SC_Query();
-        $level = $objQuery->get("dtb_category", "level", "category_id = ?", array($_POST['parent_category_id']));
-        
-        if($level >= LEVEL_MAX) {
-            $objErr->arrErr['category_name'] = "¢¨ ".LEVEL_MAX."³¬Áذʾå¤ÎÅÐÏ¿¤Ï¤Ç¤­¤Þ¤»¤ó¡£<br>";
-        }
-    }
-        
-    // ½ÅÊ£¥Á¥§¥Ã¥¯
-    if(!isset($objErr->arrErr['category_name'])) {
-        $objQuery = new SC_Query();
-        $where = "parent_category_id = ? AND category_name = ?";
-        $arrRet = $objQuery->select("category_id, category_name", "dtb_category", $where, array($_POST['parent_category_id'], $array['category_name']));
-        // ÊÔ½¸Ãæ¤Î¥ì¥³¡¼¥É°Ê³°¤ËƱ¤¸Ì¾¾Î¤¬Â¸ºß¤¹¤ë¾ì¹ç
-        if ($arrRet[0]['category_id'] != $_POST['category_id'] && $arrRet[0]['category_name'] == $_POST['category_name']) {
-            $objErr->arrErr['category_name'] = "¢¨ ´û¤ËƱ¤¸ÆâÍƤÎÅÐÏ¿¤¬Â¸ºß¤·¤Þ¤¹¡£<br>";
-        }
-    }
-
-    return $objErr->arrErr;
-}
-
-
-// ʤӤ¬1¤Ä²¼¤ÎID¤ò¼èÆÀ¤¹¤ë¡£
-function lfGetDownRankID($objQuery, $table, $pid_name, $id_name, $id) {
-    // ¿ÆID¤ò¼èÆÀ¤¹¤ë¡£
-    $col = "$pid_name";
-    $where = "$id_name = ?";
-    $pid = $objQuery->get($table, $col, $where, $id);
-    // ¤¹¤Ù¤Æ¤Î»Ò¤ò¼èÆÀ¤¹¤ë¡£
-    $col = "$id_name";
-    $where = "del_flg = 0 AND $pid_name = ? ORDER BY rank DESC";
-    $arrRet = $objQuery->select($col, $table, $where, array($pid));
-    $max = count($arrRet);
-    $down_id = "";
-    for($cnt = 0; $cnt < $max; $cnt++) {
-        if($arrRet[$cnt][$id_name] == $id) {
-            $down_id = $arrRet[($cnt + 1)][$id_name];
-            break;
-        }
-    }
-    return $down_id;
-}
-
-// ʤӤ¬1¤Ä¾å¤ÎID¤ò¼èÆÀ¤¹¤ë¡£
-function lfGetUpRankID($objQuery, $table, $pid_name, $id_name, $id) {
-    // ¿ÆID¤ò¼èÆÀ¤¹¤ë¡£
-    $col = "$pid_name";
-    $where = "$id_name = ?";
-    $pid = $objQuery->get($table, $col, $where, $id);
-    // ¤¹¤Ù¤Æ¤Î»Ò¤ò¼èÆÀ¤¹¤ë¡£
-    $col = "$id_name";
-    $where = "del_flg = 0 AND $pid_name = ? ORDER BY rank DESC";
-    $arrRet = $objQuery->select($col, $table, $where, array($pid));
-    $max = count($arrRet);
-    $up_id = "";
-    for($cnt = 0; $cnt < $max; $cnt++) {
-        if($arrRet[$cnt][$id_name] == $id) {
-            $up_id = $arrRet[($cnt - 1)][$id_name];
-            break;
-        }
-    }
-    return $up_id;
-}
-
-function lfCountChilds($objQuery, $table, $pid_name, $id_name, $id) {
-    // »ÒID°ìÍ÷¤ò¼èÆÀ
-    $arrRet = sfGetChildrenArray($table, $pid_name, $id_name, $id); 
-    return count($arrRet);
-}
-
-function lfUpRankChilds($objQuery, $table, $pid_name, $id_name, $id, $count) {
-    // »ÒID°ìÍ÷¤ò¼èÆÀ
-    $arrRet = sfGetChildrenArray($table, $pid_name, $id_name, $id); 
-    $line = sfGetCommaList($arrRet);
-    $sql = "UPDATE $table SET rank = (rank + $count) WHERE $id_name IN ($line) ";
-    $sql.= "AND del_flg = 0";
-    $ret = $objQuery->exec($sql);
-    return $ret;
-}
-
-function lfDownRankChilds($objQuery, $table, $pid_name, $id_name, $id, $count) {
-    // »ÒID°ìÍ÷¤ò¼èÆÀ
-    $arrRet = sfGetChildrenArray($table, $pid_name, $id_name, $id); 
-    $line = sfGetCommaList($arrRet);
-    $sql = "UPDATE $table SET rank = (rank - $count) WHERE $id_name IN ($line) ";
-    $sql.= "AND del_flg = 0";
-    $ret = $objQuery->exec($sql);
-    return $ret;
-}
 ?>