port:".$port; echo "

strcd:".$strcd; echo "

frdt:".$frdt; echo "

todt:".$todt; echo "

pn:".$pn; */ include "./../comon/dbconn.inc"; //=========================================================================== //=========================================================================== //=========================================================================== if ( permissionCheck($dbconn, $pn, "FEESALE") == false ) { $arr["RET"] = "ER_PM"; $arr["ROWCNT"] = 0; $arr["ERMSG"] = urlencode("±ÇÇÑÀÌ ¾ø½À´Ï´Ù."); goto go_finish_return; } $admin = "0"; $qr = "SELECT ISNULL(ADMINU, '0') admin FROM MOBUSER WHERE PHNUMBER = '$pn' AND AENABLED = '1'"; $ret = mssql_query($qr, $dbconn); $row = mssql_fetch_array( $ret ); if ( mssql_num_rows($ret) > 0 ) { $admin = $row["admin"]; } mssql_free_result($ret); $qr = "SELECT SUBSTRING(SAL_DATE, 7, 2) ADAY, ". "SUM(SAL_QTYA) TOTCUST, ". "ROUND(CASE SUM(SAL_QTYA) WHEN 0 THEN 0 ELSE SUM(SAL_AMT)/SUM(SAL_QTYA) END, 0) CUSTUNIT, ". "SUM(SAL_AMT) TOTSALE ". "FROM MSISAH WHERE STR_CODE = '$strcd' AND SAL_DATE BETWEEN '$frdt' AND '$todt' AND VEN_CODE = '$vencd' ". "GROUP BY SAL_DATE ORDER BY SAL_DATE "; // echo $qr; $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"] = "0"; $arr["RETCNT"] = $cnt; $arr["ERMSG"]=""; } else { $arr["RET"] = "1"; $arr["RETCNT"] = 0; $arr["ERMSG"]=urlencode("ÀÚ·á°¡ ¾ø½À´Ï´Ù."); goto go_finish_return; } $dataArray = array(); while( $row = mssql_fetch_array( $ret ) ) { $rowArray = array(); $rowArray["ADAY"] = $row["ADAY"]; $rowArray["TOTCUST"] = $row["TOTCUST"]; $rowArray["CUSTUNIT"] = $row["CUSTUNIT"]; $rowArray["TOTSALE"] = $row["TOTSALE"]; array_push($dataArray, $rowArray); } $arr["MONTH_DATA"] = $dataArray; go_finish_return: $retData = json_encode($arr); echo $retData; mssql_free_result($ret); mssql_close(); ?>