<?php /** * Created by PhpStorm. * User: Allan Wiz * Date: 4/17/15 * Time: 4:48 PM */ include '../classes/aardb_conn.php'; include '../charts/JSClass/FusionCharts_Gen.php'; global $session, $database; global $conn; $FC = new FusionCharts("FC_Line.swf", "900", "450"); $FC->setDataBaseType("Oracle"); $FC->setSwfPath("../Charts/"); $strParam = "caption=INTEREST VIEW REPORT (for the last 14 days);subCaption=BY APPLICABLE DATE ; showNames='1';pieSliceDepth=30;showBorder=1;numberSuffix= %; formatNumberScale='0'; xAxisName=Date; pYAxisName=Net Asset Value;sYAxisName=BalancedFund"; $FC->setChartParams($strParam); $start = date("d/M/Y", strtotime('-50 days')); $today = date("d/M/Y"); $sql = "SELECT I_RATES.RATE_ID, I_RATES.RATE_DATE AS DATEY, I_RATES.RATE AS RATE, SECURITIES.DESCRIPT AS DESCRIPTION FROM I_RATES INNER JOIN\r SECURITIES ON I_RATES.SECURITY_CODE = SECURITIES.SECURITY_CODE WHERE I_RATES.CONFIRMD = 1 AND I_RATES.RATE_DATE BETWEEN '{$start}' AND '{$today}' ORDER BY I_RATES.RATE_DATE"; $result = oci_parse($conn, $sql) or die(""); oci_execute($result); if ($result) { //$FC->addCategoryFromDatabase($result,"DESCRIPTION"); $FC->addDataFromDatabase($result, "RATE", "DATEY"); } print $FC->getXML();