port:".$port; echo "

strcd:".$strcd; echo "

frdt:".$frdt; echo "

vencd:".$vencd; echo "

grpcd:".$grpcd; echo "

pn:".$pn; */ include "./../comon/dbconn.inc"; $qr = "SELECT A.ITM_CODE, B.ITM_CODEX POSCD, B.ITM_NAME, A.SAL_QTY SAL_QTY, A.SAL_AMT " . "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 = '$saledt' AND A.GRP_CODE = '$grpcd' AND A.SAL_QTY <> 0 " . "ORDER BY A.SAL_QTY DESC, A.POS_CODE "; $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"]=urlencode("ÀÚ·á°¡ ¾ø½À´Ï´Ù."); $retData = json_encode($arr); echo $retData; mssql_free_result($ret); mssql_close(); exit(); } $dataArray = array(); while( $row = mssql_fetch_array( $ret ) ) { $rowArray = array(); $rowArray["ITM_NAME"] = urlencode($row["ITM_NAME"]); $rowArray["ITM_CODE"] = $row["ITM_CODE"]; $rowArray["POSCD"] = $row["POSCD"]; $rowArray["SAL_QTY"] = $row["SAL_QTY"]; $rowArray["SAL_AMT"] = $row["SAL_AMT"]; array_push($dataArray, $rowArray); } $arr["DATA"] = $dataArray; $retData = json_encode($arr); echo $retData; mssql_free_result($ret); mssql_close(); ?>