port:".$port; echo "
strcd:".$strcd; echo "
frdt:".$frdt; echo "
vencd:".$vencd; echo "
pn:".$pn; */ include "./../comon/dbconn.inc"; $qr = "SELECT GRP_CODE, CONVERT(VARBINARY(200), GRP_NAME) GRP_NAME ". "FROM MMGRPM ORDER BY GRP_CODE"; $ret = mssql_query($qr, $dbconn); if (! $ret) { echo (urlencode('{"RET":"QRY", "ERMSG":"대분류 조회 오류입니다."}')); mssql_close(); exit(); } $arr = array(); $arr["RET"] = "OK"; $arr["ERMSG"] = ""; $grpArray = array(); while( $row = mssql_fetch_array( $ret ) ) { $rowAry = array(); $rowArray["GRPCD"] = $row["GRP_CODE"]; $rowArray["GRPNM"] = BinToKor($row["GRP_NAME"]); array_push($grpArray, $rowArray); } $arr["GRP_CODE"] = $grpArray; //========================== DPT_CODE $qr = "SELECT GRP_CODE, DPT_CODE, CONVERT(VARBINARY(200), DPT_NAME) DPT_NAME FROM MMDPTM ORDER BY GRP_CODE, DPT_CODE"; $ret = mssql_query($qr, $dbconn); if (! $ret) { echo (urlencode('{"RET":"QRY", "ERMSG":"중분류 조회 오류입니다."}')); mssql_close(); exit(); } $dptArray = array(); while( $row = mssql_fetch_array( $ret ) ) { $rowAry = array(); $rowArray["GRPCD"] = $row["GRP_CODE"]; $rowArray["DPTCD"] = $row["DPT_CODE"]; $rowArray["DPTNM"] = BinToKor($row["DPT_NAME"]); array_push($dptArray, $rowArray); } $arr["DPT_CODE"] = $dptArray; //========================== DPT_CODE $qr = "SELECT GRP_CODE, DPT_CODE, LINE_CODE, CONVERT(VARBINARY(200), LINE_NAME) LINE_NAME FROM MMLINM ORDER BY GRP_CODE, DPT_CODE"; $ret = mssql_query($qr, $dbconn); if (! $ret) { echo (urlencode('{"RET":"QRY", "ERMSG":"소분류 조회 오류입니다."}')); mssql_close(); exit(); } $lineArray = array(); while( $row = mssql_fetch_array( $ret ) ) { $rowAry = array(); $rowArray["GRPCD"] = $row["GRP_CODE"]; $rowArray["DPTCD"] = $row["DPT_CODE"]; $rowArray["LINCD"] = $row["LINE_CODE"]; $rowArray["LINNM"] = BinToKor($row["LINE_NAME"]); array_push($lineArray, $rowArray); } $arr["LIN_CODE"] = $lineArray; $retData = json_encode($arr); echo $retData; mssql_free_result($ret); mssql_close(); ?>