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; } $feeSalePerm = 0; $qr = "SELECT OPTIONA FROM NMConfig WHERE XKEY = 'MARTGRP'"; //OptionA == 1 À϶§ ±ÇÇÑ»ç¿ë. $ret = mssql_query($qr, $dbconn); if ( mssql_num_rows($ret) > 0 ) { $row = mssql_fetch_row( $ret ); $feeSalePerm = $row[0]; } if ( isNRdev($pn) == true ) { $admin = "T"; } else { $admin = "0"; if ($feeSalePerm == 1) { $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); } else { $admin = "1"; } } $wh1 = ""; if ($admin == "1" or $admin == "S" or $admin == "T") { $wh1 = " AND MCH_TYP = 'K' "; } else { $wh1 = " AND VEN_CODE IN ( SELECT VENCD FROM MOBUSER_VEN WHERE PHNUMBER='$pn' ) "; } $qr = "SELECT A.VEN_CODE VENCD, ISNULL(MIN(C.VEN_NAME), '¹Ìµî·Ï') VENNM, ". "SUM(ITMQTY) ITMQTY, SUM(SALEQTY) SALEQTY, ". "SUM(A.COST_AMT) COSTAMT, SUM(A.SAL_AMT) SALEAMT, ". "CASE SUM(A.SAL_AMT) ". "WHEN 0 THEN 0 ". "ELSE ROUND((((SUM(A.SAL_AMT) - SUM(A.COST_AMT))/SUM(A.SAL_AMT)) * 100), 1) ". "END MARGINE, ". "ROUND((SUM(A.SAL_AMT)/MIN(B.TOT))*100, 1) DRATE, ". "ROUND((SUM(A.SAL_AMT)/MIN(X.TOT))*100, 1) TDRATE ". "FROM (SELECT STR_CODE, VEN_CODE, ". "COUNT(*) ITMQTY, SUM(SAL_QTY) SALEQTY, ". "SUM(ISNULL(COST_AMT,0)) COST_AMT, SUM(ISNULL(SAL_AMT,0)) SAL_AMT ". "FROM MSISAH WITH (NOLOCK) ". "WHERE STR_CODE = '$strcd' AND SAL_DATE BETWEEN '$frdt' AND '$todt' AND ". "POS_CODE >= '0' AND ". "SAL_AMT <> 0 $wh1 ". "GROUP BY STR_CODE, VEN_CODE, MCH_TYP ) A ". "LEFT OUTER JOIN (SELECT STR_CODE, SUM(ISNULL(SAL_AMT,0)) TOT ". "FROM MSISAH WITH (NOLOCK) ". "WHERE STR_CODE = '$strcd' AND SAL_DATE BETWEEN '$frdt' AND '$todt' AND POS_CODE >= '0' ". "GROUP BY STR_CODE) B ON (A.STR_CODE = B.STR_CODE) ". "LEFT OUTER JOIN (SELECT STR_CODE, SUM(ISNULL(SAL_AMT,0)) TOT ". "FROM MSISAH WITH (NOLOCK) ". "WHERE STR_CODE = '$strcd' AND SAL_DATE BETWEEN '$frdt' AND '$todt' AND POS_CODE >= '0' ". "GROUP BY STR_CODE) X ON (A.STR_CODE = B.STR_CODE) ". "LEFT OUTER JOIN MMSVEM C ON (A.STR_CODE = C.STR_CODE AND ". "A.VEN_CODE = C.VEN_CODE) ". "GROUP BY A.STR_CODE, A.VEN_CODE ". "ORDER BY A.STR_CODE, SALEAMT DESC "; // 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"] = "OK"; $arr["ROWCNT"] = $cnt; $arr["ERMSG"]="OK"; } else { $arr["RET"] = "NODATA"; $arr["ROWCNT"] = 0; $arr["ERMSG"]=urlencode("ÀÚ·á°¡ ¾ø½À´Ï´Ù."); goto go_finish_return; } $dataArray = array(); while( $row = mssql_fetch_array( $ret ) ) { $rowArray = array(); $rowArray["VENCD"] = $row["VENCD"]; // $rowArray["VENNM"] = urlencode($row["VENNM"]); // $rowArray["VENNM"] = urlencode( iconv("UTF-8", "EUC-KR", $row["VENNM"]) ); $rowArray["VENNM"] = urlencode( iconv("CP949", "EUC-KR", $row["VENNM"]) ); // $rowArray["VENNM"] = $row["VENNM"]; // $rowArray["VENNM"] = urlencode( "Å×½ºÆ®" ); // $vennm = $row["VENNM"]; // $detected = mb_detect_encoding($vennm, array("UTF-8", "EUC-KR", "CP949"), true); // $vennm = mb_convert_encoding($vennm, "EUC-KR", $detected); // $rowArray["VENNM"] = $detected; $rowArray["ITMQTY"] = $row["ITMQTY"]; $rowArray["SALEQTY"] = $row["SALEQTY"]; $rowArray["COSTAMT"] = $row["COSTAMT"]; $rowArray["SALEAMT"] = $row["SALEAMT"]; $rowArray["MARGINE"] = $row["MARGINE"]; $rowArray["DRATE"] = $row["DRATE"]; $rowArray["TDRATE"] = $row["TDRATE"]; array_push($dataArray, $rowArray); } $arr["DATA"] = $dataArray; go_finish_return: $retData = json_encode($arr); echo $retData; mssql_free_result($ret); mssql_close(); ?>