회원정보 셀렉트박스 수정시 초기화 채택완료

<?php

//부서 테이블 관련 SQL 쿼리문

$sql = " select * from g5_part ";

$res = sql_query($sql);

for ($i=0; $row = sql_fetch_array($res); $i++) {

      $nm[$i] = $row['company'].'|1|'.$row['part'].'|2|'.$row['team'].'|3|';

}

?>

<!---SQL 셀렉트박스 시작 -->

 

                <script type="text/javascript">

                function getCataAllId(cmd){

                cmd = eval(cmd);

                cmd2 = cmd +1;

                initCataID(cmd);

                var ch = "";

                for(var idx = 1; idx < cmd2; idx++){

                    ch = ch + eval("mb_"+idx+".value") + "|"+idx+"|";

                }

                var v = 0;

                var temp = "";

                var tempv = "";

                var arg = "";

                for(var m = 0; m < menuArr.length; m ++) {

                    arg = menuArr[m].substring(menuArr[m].indexOf("|"+cmd+"|")+3,menuArr[m].indexOf("|"+cmd2+"|")) ;

                    temp = menuArr[m].substring(0, menuArr[m].indexOf("|"+cmd+"|")+3);

                    if(temp == ch && tempv != arg ){

                            v++;

                            eval("mb_"+cmd2+".length = mb_"+cmd2+".length + 1");

                            eval("mb_"+cmd2+".options["+v+"].value = arg ");

                            eval("mb_"+cmd2+".options["+v+"].text  = arg ");

                    }

                    if(temp != ch){

                        tempv = "";

                    }else{

                        tempv = menuArr[m].substring(menuArr[m].indexOf("|"+cmd+"|")+3,menuArr[m].indexOf("|"+cmd2+"|"));

                    }

                }

                }

               

                function initCataID(cmd){

                cmd = eval(cmd);

                if(cmd == 1){

                    mb_2.length = 1;

                    mb_3.length = 1;

                    mb_2.selectedIndex = 0;

                    mb_3.selectedIndex = 0;

                }

                if(cmd == 2){

                    mb_3.length = 1;

                    mb_3.selectedIndex = 0;

                }

                }


 

                </script>

                <tr>

                    <th scope="row"><label for="mb_level">회원 권한</label></th>

                    <td><?php echo get_member_level_select('mb_level', 1, $mb['mb_level'], $mb['mb_level']) ?></td>

                    <!--<th scope="row">포인트</th>

                    <td><a href="./point_list.php?sfl=mb_id&amp;stx=<?php echo $mb['mb_id'] ?>" target="_blank"><?php echo number_format($mb['mb_point']) ?></a> 점</td> -->

                    <th scope="row"><label for="mb_1">회사 구분</label></th>

                    <td>

                        <select name = 'mb_1' id='mb_1' OnChange='javascript:getCataAllId(1)' class="select1">

                        <option value='<?php echo $part['company'] ?>' selected="selected">회사 선택</option>

                        </select>

                    </td>

                </tr>

                <tr>

                    <th scope="row"><label for="mb_2">부 구분</label></th>

                    <td>

                        <select name = 'mb_2' id='mb_2' OnChange='javascript:getCataAllId(2)' class="select2">

                        <option value='<?php echo $part['part'] ?>' selected="selected">부 선택</option>

                        </select>

                    </td>

                    <th scope="row"><label for="mb_3">팀 구분</label></th>

                    <td>

                        <select name = 'mb_3' id='mb_3' OnChange='javascript:getCataAllId(3)' class="select3">

                        <option value='<?php echo $part['team'] ?>' selected="selected">팀 선택</option>

                        </select>

                    </td>

                </tr>

                <script type="text/javascript">

                /* JSON encode, parse  */

                var stuff = <?php echo json_encode($nm); ?>;

                var str = JSON.stringify(stuff);

                var menuArr = new Array();

                    menuArr= JSON.parse(str);

                var z1 = 0;

                var temp1 = 0;

                initCataID(1);

                for(var m = 0; m < menuArr.length; m ++) {

                    if ( menuArr[m].substring(0, menuArr[m].indexOf("|1|")) != temp1 ){

                        mb_1.length =  mb_1.length + 1;

                        mb_1.options[z1+1].value = menuArr[m].substring(0, menuArr[m].indexOf("|1|")) ;

                        mb_1.options[z1+1].text = menuArr[m].substring(0, menuArr[m].indexOf("|1|")) ;

                        temp1 = menuArr[m].substring(0, menuArr[m].indexOf("|1|"));

                        z1++;

                    }

                    /*  index 1에 중복 제거입니다.  */

                }

                </script>

 

                <!-- SQL 셀렉트박스 끝 -->