source: temp/trunk/html/test/nakatest/test.php @ 1328

<?php

require_once("../../require.php");

sfGetParentsArray("dtb_category","parent_category_id", "category_id", 230);
sfGetChildrenArray("dtb_category","parent_category_id", "category_id", 6);

/* ³¬Áع½Â¤¤Î¥Æ¡¼¥Ö¥ë¤«¤é»ÒIDÇÛÎó¤ò¼èÆÀ¤¹¤ë */
function sfGetChildrenArray($table, $pid_name, $id_name, $id) {
    $objQuery = new SC_Query();
    $col = $pid_name . "," . $id_name;
    $arrData = $objQuery->select($col, $table);
    
    $arrPID = array();
    $arrPID[] = $id;
    $arrChildren = array();
    $arrChildren[] = $id;
    
    $arrRet = sfGetChildrenArraySub($arrData, $pid_name, $id_name, $arrPID);
    
    while(count($arrRet) > 0) {
        $arrChildren = array_merge($arrChildren, $arrRet);
        $arrRet = sfGetChildrenArraySub($arrData, $pid_name, $id_name, $arrRet);
    }
    
    return $arrChildren;
}

/* ¿ÆIDľ²¼¤Î»ÒID¤ò¤¹¤Ù¤Æ¼èÆÀ¤¹¤ë */
function sfGetChildrenArraySub($arrData, $pid_name, $id_name, $arrPID) {
    $arrChildren = array();
    $max = count($arrData);
    
    for($i = 0; $i < $max; $i++) {
        foreach($arrPID as $val) {
            if($arrData[$i][$pid_name] == $val) {
                $arrChildren[] = $arrData[$i][$id_name];
            }
        }
    }
    return $arrChildren;
}


/* ³¬Áع½Â¤¤Î¥Æ¡¼¥Ö¥ë¤«¤é¿ÆIDÇÛÎó¤ò¼èÆÀ¤¹¤ë */
function sfGetParentsArray($table, $pid_name, $id_name, $id) {
    $objQuery = new SC_Query();
    $col = $pid_name . "," . $id_name;
    $arrData = $objQuery->select($col, $table);
    
    $arrParents = array();
    $arrParents[] = $id;
    $child = $id;
    
    $ret = sfGetParentsArraySub($arrData, $pid_name, $id_name, $child);
    
    while($ret != "") {
        $arrParents = array_merge($arrParents, $ret);
        $ret = sfGetParentsArraySub($arrData, $pid_name, $id_name, $ret);
    }
    
    $arrParents = array_reverse($arrParents);
    
    return $arrParents;
}

/* »ÒID½ê°¤¹¤ë¿ÆID¤ò¼èÆÀ¤¹¤ë */
function sfGetParentsArraySub($arrData, $pid_name, $id_name, $child) {
    $max = count($arrData);
    $parent = "";
    for($i = 0; $i < $max; $i++) {
        if($arrData[$i][$id_name] == $child) {
            $parent = $arrData[$i][$pid_name];
            break;
        }
    }
    return $parent;
}


?>