port:".$port; echo "

strcd:".$strcd; echo "

frdt:".$frdt; echo "

vencd:".$vencd; echo "

pn:".$pn; */ include "./../comon/dbconn.inc"; $qr = "SELECT B.ITM_NAME, A.ITM_CODE, B.ITM_CODEX POSCD, A.SAL_AMT, A.SAL_QTY " . "FROM MSISAH A LEFT OUTER JOIN MMSTMM B ON (A.STR_CODE = B.STR_CODE AND A.ITM_CODE=B.ITM_CODE) " . "WHERE A.STR_CODE = '$strcd' AND A.SAL_DATE = '$frdt' AND A.VEN_CODE = '$vencd' " . "ORDER BY B.ITM_NAME"; $ret = mssql_query($qr, $dbconn); if (! $ret) { echo ('{"RET":"QRY", "ERMSG":"Á¶È¸ ¿À·ùÀÔ´Ï´Ù."}'); mssql_close(); exit(); } $arr = array(); $cnt = mssql_num_rows($ret); if ($cnt > 0) { $arr["RET"] = "OK"; $arr["ROWCNT"] = $cnt; $arr["ERMSG"]="OK"; } else { $arr["RET"] = "NODATA"; $arr["ROWCNT"] = 0; $arr["ERMSG"]="ÀÚ·á°¡ ¾ø½À´Ï´Ù."; mssql_free_result($ret); mssql_close(); exit(); } $dataArray = array(); while( $row = mssql_fetch_array( $ret ) ) { $rowAry = array(); $rowArray["ITM_NAME"] = urlencode($row["ITM_NAME"]); $rowArray["ITM_CODE"] = $row["ITM_CODE"]; $rowArray["POSCD"] = $row["POSCD"]; $rowArray["SAL_AMT"] = $row["SAL_AMT"]; $rowArray["SAL_QTY"] = $row["SAL_QTY"]; array_push($dataArray, $rowArray); } $arr["DATA"] = $dataArray; $retData = json_encode($arr); echo $retData; mssql_free_result($ret); mssql_close(); ?>