port:".$port; echo "

strcd:".$strcd; echo "

frdt:".$frdt; echo "

vencd:".$vencd; echo "

pn:".$pn; */ include "./../comon/dbconn.inc"; $qr = "SELECT LEFT(TRTIME, 4) TRTIME, POSNO, " . "CASE TRTYPE WHEN '00' THEN QTY ELSE QTY*-1 END QTY, " . "SPRC, " . "CASE TRTYPE WHEN '00' THEN SAMT ELSE SAMT*-1 END SAMT " . "FROM NMTR02 ". "WHERE STRCD = '$strcd' AND SALEDT='$frdt' AND ITMCD=$itmcd AND TRTYPE IN ('00', '02') AND CFLAG = '0' ". "ORDER BY TRDATE, TRTIME"; $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 { echo ('{"RET":"NODATA", "ROWCNT":"0", "ERMSG":"ÀÚ·á°¡ ¾ø½À´Ï´Ù."}'); mssql_free_result($ret); mssql_close(); exit(); } $dataArray = array(); while( $row = mssql_fetch_array( $ret ) ) { $rowAry = array(); $rowArray["TRTIME"] = $row["TRTIME"]; $rowArray["POSNO"] = $row["POSNO"]; $rowArray["QTY"] = $row["QTY"]; $rowArray["SPRC"] = $row["SPRC"]; $rowArray["SAMT"] = $row["SAMT"]; array_push($dataArray, $rowArray); } $arr["DATA"] = $dataArray; $retData = json_encode($arr); echo $retData; mssql_free_result($ret); mssql_close(); ?>