Problem in if...else code
Posted: Thu Jul 09, 2009 12:13 am
Dear Sir,
I want to show multiple lines by chartdirector but problem in my if ... else loop. When I select multiple items from selection bars, it show the seleted items but problem is that the lines are looped one another. The lines should show individual line. Please see my codes: may be problem in If...else loop.
<?php
require_once("Chartdirector/lib/phpchartdir.php");
$dbhost = "localhost";
$dblogin = "root";
$dbpass = "";
$db = "radio";
mysql_connect($dbhost, $dblogin, $dbpass);
@mysql_select_db($db) or die('Could not select db');
$c = new XYChart(1000, 600, brushedSilverColor(), Transparent, 2);
# Set the plotarea at (45, 35) and of size 240 x 120 pixels, with white background.
# Turn on both horizontal and vertical grid lines with light grey color (0xc0c0c0)
$c->setPlotArea(50, 100, 900, 410, brushedSilverColor(), Transparent, -1, -2, -2);
# Add a legend box at (45, 12) (top of the chart) using horizontal layout and 8 pts
# Arial font Set the background and border color to Transparent.
$legendObj = $c->addLegend(80, 30, false, "", 10);
$legendObj->setBackground(Transparent);
# Add a title to the chart using 9 pts Arial Bold/white font. Use a 1 x 2 bitmap
# pattern as the background.
$textBoxObj = $c->addTitle(
"<*block,valign=absmiddle*><*img=star.png*><*img=star.png*> DAILY ".
"Radio Performance<*img=star.png*><*img=star.png*><*/*>", "timesbi.ttf", 15);
$textBoxObj->setBackground(0xcf4040, 0, glassEffect());
# Set the y axis label format to nn%
$c->yAxis->setLabelFormat("{value}");
# Add a line layer to the chart
$layer = $c->addLineLayer();
$layer1 = $c->addLineLayer();
$layer2 = $c->addLineLayer();
$layer3 = $c->addLineLayer();
$textBoxObj = $c->xAxis->setLabelStyle("arialbd.ttf", 07, 0x000000);
$textBoxObj->setFontAngle(60);
$colors = array(0xcf4040,0xcfaa40,0xFF8000, 0x0080ff, 0xcf4ff0, 0x4cffff, 0x009999, 0x8fff44, 0x9999FF, 0xcff000, 0xffcc00, 0xccffcc, 0xeeccaa);
$MaximumDatesShow = 10;
//////////////////////////////////////////////////////////
// Date Wise request //////
/////////////////////////////////////////////////////////
if($_REQUEST['Category']!="ALL"){
if($_REQUEST['dateFrom']!= "" && $_REQUEST['dateTo']!= ""){
$qry = mysql_query("SELECT Date, `".$_REQUEST['Category']."` FROM radio WHERE date>='".$_REQUEST['dateFrom']."' AND date<='".$_REQUEST['dateTo']."' ORDER BY date DESC");
} else {
$qry = mysql_query("SELECT Date, `".$_REQUEST['Category']."` FROM radio ORDER BY date DESC LIMIT $MaximumDatesShow");
}
$dates = array();
while ($array = mysql_fetch_array($qry)){
$dates[]= $array['Date'];
$displayColumnsAr[] = $array[1];
}
$dataSetObj = $layer->addDataSet(array_reverse($displayColumnsAr), $colors[1], $_REQUEST['Category'] );
$dataSetObj->setDataSymbol(SquareSymbol, 7);
$layer->setDataLabelFormat("");
$c->xAxis->setLabels(array_reverse($dates));
}
else {
$displayColumns = array("Calling_Minutes", "Combined(GPRS & EDGE)Throughput", "SDCCH_Availability", "PDCH_Allocation_Success_Rate", "GPRS_Throughput", "EDGE_Throughput", "SMS_Delivery_Success_Rate", "MCA_Call_Connection_Success_Rate", "Voice_SMS_Success_Rate", "MPD");
if($_REQUEST['dateFrom']!= "" && $_REQUEST['dateTo']!= ""){
$qry = mysql_query("SELECT * FROM radio WHERE date>='".$_REQUEST['dateFrom']."' AND date<='".$_REQUEST['dateTo']."' ORDER BY date DESC");
} else {
$qry = mysql_query("SELECT * FROM radio ORDER BY date DESC LIMIT $MaximumDatesShow");
}
$dates = array();
while ($array = mysql_fetch_array($qry)){
$dates[]= $array['Date'];
foreach($displayColumns as $dc){
$displayColumnsAr[$dc][] = $array[$dc];
}
}
$i=0;
foreach($displayColumnsAr as $srv => $data){
$dataSetObj = $layer->addDataSet(array_reverse($data), $colors[$i++], $srv );
$dataSetObj->setDataSymbol(GlassSphere2Shape, 9);
$layer->setDataLabelFormat("");
}
$c->xAxis->setLabels(array_reverse($dates));
}
if($_REQUEST['Category1']!="ALL"){
if($_REQUEST['dateFrom']!= "" && $_REQUEST['dateTo']!= ""){
$qry = mysql_query("SELECT Date, `".$_REQUEST['Category1']."` FROM radio WHERE date>='".$_REQUEST['dateFrom']."' AND date<='".$_REQUEST['dateTo']."' ORDER BY date DESC");
} else {
$qry = mysql_query("SELECT Date, `".$_REQUEST['Category1']."` FROM radio ORDER BY date DESC LIMIT $MaximumDatesShow");
}
$dates = array();
while ($array = mysql_fetch_array($qry)){
$dates[]= $array['Date'];
$displayColumnsAr[] = $array[1];
}
$dataSetObj = $layer1->addDataSet(array_reverse($displayColumnsAr), $colors[1], $_REQUEST['Category1'] );
$dataSetObj->setDataSymbol(SquareSymbol, 7);
$layer1->setDataLabelFormat("");
$c->xAxis->setLabels(array_reverse($dates));
}
if($_REQUEST['Category2']!="ALL"){
if($_REQUEST['dateFrom']!= "" && $_REQUEST['dateTo']!= ""){
$qry2 = mysql_query("SELECT Date, `".$_REQUEST['Category2']."` FROM radio WHERE date>='".$_REQUEST['dateFrom']."' AND date<='".$_REQUEST['dateTo']."' ORDER BY date DESC");
} else {
$qry2 = mysql_query("SELECT Date, `".$_REQUEST['Category2']."` FROM radio ORDER BY date DESC LIMIT $MaximumDatesShow");
}
$dates = array();
while ($array = mysql_fetch_array($qry2)){
$dates[]= $array['Date'];
$displayColumnsAr[] = $array[1];
}
$dataSetObj = $layer2->addDataSet(array_reverse($displayColumnsAr), $colors[1], $_REQUEST['Category2'] );
$dataSetObj->setDataSymbol(SquareSymbol, 7);
$layer2->setDataLabelFormat("");
$c->xAxis->setLabels(array_reverse($dates));
}
if($_REQUEST['Category']!="ALL"){
if($_REQUEST['dateFrom']!= "" && $_REQUEST['dateTo']!= ""){
$qry3 = mysql_query("SELECT Date, `".$_REQUEST['Category3']."` FROM radio WHERE date>='".$_REQUEST['dateFrom']."' AND date<='".$_REQUEST['dateTo']."' ORDER BY date DESC");
} else {
$qry3 = mysql_query("SELECT Date, `".$_REQUEST['Category3']."` FROM radio ORDER BY date DESC LIMIT $MaximumDatesShow");
}
$dates = array();
while ($array = mysql_fetch_array($qry3)){
$dates[]= $array['Date'];
$displayColumnsAr[] = $array[1];
}
$dataSetObj = $layer3->addDataSet(array_reverse($displayColumnsAr), $colors[1], $_REQUEST['Category3'] );
$dataSetObj->setDataSymbol(SquareSymbol, 7);
$layer3->setDataLabelFormat("");
$c->xAxis->setLabels(array_reverse($dates));
}
# Output the chart
/*header("Content-type: image/png");
print($c->makeChart2(PNG));
?>*/
# Create the image and save it in a temporary location
$chart1URL = $c->makeSession("chart1");
# Create an image map for the chart
$imageMap = $c->getHTMLImageMap("", "", "title='{dataSetName}: {value}'");
?>
<html>
<img src="chartdirector/phpdemo/getchart.php?
<?php echo $chart1URL?>" border="0" usemap="#map1">
<map name="map1">
<?php echo $imageMap?>
</map>
</body>
</html>
I want to show multiple lines by chartdirector but problem in my if ... else loop. When I select multiple items from selection bars, it show the seleted items but problem is that the lines are looped one another. The lines should show individual line. Please see my codes: may be problem in If...else loop.
<?php
require_once("Chartdirector/lib/phpchartdir.php");
$dbhost = "localhost";
$dblogin = "root";
$dbpass = "";
$db = "radio";
mysql_connect($dbhost, $dblogin, $dbpass);
@mysql_select_db($db) or die('Could not select db');
$c = new XYChart(1000, 600, brushedSilverColor(), Transparent, 2);
# Set the plotarea at (45, 35) and of size 240 x 120 pixels, with white background.
# Turn on both horizontal and vertical grid lines with light grey color (0xc0c0c0)
$c->setPlotArea(50, 100, 900, 410, brushedSilverColor(), Transparent, -1, -2, -2);
# Add a legend box at (45, 12) (top of the chart) using horizontal layout and 8 pts
# Arial font Set the background and border color to Transparent.
$legendObj = $c->addLegend(80, 30, false, "", 10);
$legendObj->setBackground(Transparent);
# Add a title to the chart using 9 pts Arial Bold/white font. Use a 1 x 2 bitmap
# pattern as the background.
$textBoxObj = $c->addTitle(
"<*block,valign=absmiddle*><*img=star.png*><*img=star.png*> DAILY ".
"Radio Performance<*img=star.png*><*img=star.png*><*/*>", "timesbi.ttf", 15);
$textBoxObj->setBackground(0xcf4040, 0, glassEffect());
# Set the y axis label format to nn%
$c->yAxis->setLabelFormat("{value}");
# Add a line layer to the chart
$layer = $c->addLineLayer();
$layer1 = $c->addLineLayer();
$layer2 = $c->addLineLayer();
$layer3 = $c->addLineLayer();
$textBoxObj = $c->xAxis->setLabelStyle("arialbd.ttf", 07, 0x000000);
$textBoxObj->setFontAngle(60);
$colors = array(0xcf4040,0xcfaa40,0xFF8000, 0x0080ff, 0xcf4ff0, 0x4cffff, 0x009999, 0x8fff44, 0x9999FF, 0xcff000, 0xffcc00, 0xccffcc, 0xeeccaa);
$MaximumDatesShow = 10;
//////////////////////////////////////////////////////////
// Date Wise request //////
/////////////////////////////////////////////////////////
if($_REQUEST['Category']!="ALL"){
if($_REQUEST['dateFrom']!= "" && $_REQUEST['dateTo']!= ""){
$qry = mysql_query("SELECT Date, `".$_REQUEST['Category']."` FROM radio WHERE date>='".$_REQUEST['dateFrom']."' AND date<='".$_REQUEST['dateTo']."' ORDER BY date DESC");
} else {
$qry = mysql_query("SELECT Date, `".$_REQUEST['Category']."` FROM radio ORDER BY date DESC LIMIT $MaximumDatesShow");
}
$dates = array();
while ($array = mysql_fetch_array($qry)){
$dates[]= $array['Date'];
$displayColumnsAr[] = $array[1];
}
$dataSetObj = $layer->addDataSet(array_reverse($displayColumnsAr), $colors[1], $_REQUEST['Category'] );
$dataSetObj->setDataSymbol(SquareSymbol, 7);
$layer->setDataLabelFormat("");
$c->xAxis->setLabels(array_reverse($dates));
}
else {
$displayColumns = array("Calling_Minutes", "Combined(GPRS & EDGE)Throughput", "SDCCH_Availability", "PDCH_Allocation_Success_Rate", "GPRS_Throughput", "EDGE_Throughput", "SMS_Delivery_Success_Rate", "MCA_Call_Connection_Success_Rate", "Voice_SMS_Success_Rate", "MPD");
if($_REQUEST['dateFrom']!= "" && $_REQUEST['dateTo']!= ""){
$qry = mysql_query("SELECT * FROM radio WHERE date>='".$_REQUEST['dateFrom']."' AND date<='".$_REQUEST['dateTo']."' ORDER BY date DESC");
} else {
$qry = mysql_query("SELECT * FROM radio ORDER BY date DESC LIMIT $MaximumDatesShow");
}
$dates = array();
while ($array = mysql_fetch_array($qry)){
$dates[]= $array['Date'];
foreach($displayColumns as $dc){
$displayColumnsAr[$dc][] = $array[$dc];
}
}
$i=0;
foreach($displayColumnsAr as $srv => $data){
$dataSetObj = $layer->addDataSet(array_reverse($data), $colors[$i++], $srv );
$dataSetObj->setDataSymbol(GlassSphere2Shape, 9);
$layer->setDataLabelFormat("");
}
$c->xAxis->setLabels(array_reverse($dates));
}
if($_REQUEST['Category1']!="ALL"){
if($_REQUEST['dateFrom']!= "" && $_REQUEST['dateTo']!= ""){
$qry = mysql_query("SELECT Date, `".$_REQUEST['Category1']."` FROM radio WHERE date>='".$_REQUEST['dateFrom']."' AND date<='".$_REQUEST['dateTo']."' ORDER BY date DESC");
} else {
$qry = mysql_query("SELECT Date, `".$_REQUEST['Category1']."` FROM radio ORDER BY date DESC LIMIT $MaximumDatesShow");
}
$dates = array();
while ($array = mysql_fetch_array($qry)){
$dates[]= $array['Date'];
$displayColumnsAr[] = $array[1];
}
$dataSetObj = $layer1->addDataSet(array_reverse($displayColumnsAr), $colors[1], $_REQUEST['Category1'] );
$dataSetObj->setDataSymbol(SquareSymbol, 7);
$layer1->setDataLabelFormat("");
$c->xAxis->setLabels(array_reverse($dates));
}
if($_REQUEST['Category2']!="ALL"){
if($_REQUEST['dateFrom']!= "" && $_REQUEST['dateTo']!= ""){
$qry2 = mysql_query("SELECT Date, `".$_REQUEST['Category2']."` FROM radio WHERE date>='".$_REQUEST['dateFrom']."' AND date<='".$_REQUEST['dateTo']."' ORDER BY date DESC");
} else {
$qry2 = mysql_query("SELECT Date, `".$_REQUEST['Category2']."` FROM radio ORDER BY date DESC LIMIT $MaximumDatesShow");
}
$dates = array();
while ($array = mysql_fetch_array($qry2)){
$dates[]= $array['Date'];
$displayColumnsAr[] = $array[1];
}
$dataSetObj = $layer2->addDataSet(array_reverse($displayColumnsAr), $colors[1], $_REQUEST['Category2'] );
$dataSetObj->setDataSymbol(SquareSymbol, 7);
$layer2->setDataLabelFormat("");
$c->xAxis->setLabels(array_reverse($dates));
}
if($_REQUEST['Category']!="ALL"){
if($_REQUEST['dateFrom']!= "" && $_REQUEST['dateTo']!= ""){
$qry3 = mysql_query("SELECT Date, `".$_REQUEST['Category3']."` FROM radio WHERE date>='".$_REQUEST['dateFrom']."' AND date<='".$_REQUEST['dateTo']."' ORDER BY date DESC");
} else {
$qry3 = mysql_query("SELECT Date, `".$_REQUEST['Category3']."` FROM radio ORDER BY date DESC LIMIT $MaximumDatesShow");
}
$dates = array();
while ($array = mysql_fetch_array($qry3)){
$dates[]= $array['Date'];
$displayColumnsAr[] = $array[1];
}
$dataSetObj = $layer3->addDataSet(array_reverse($displayColumnsAr), $colors[1], $_REQUEST['Category3'] );
$dataSetObj->setDataSymbol(SquareSymbol, 7);
$layer3->setDataLabelFormat("");
$c->xAxis->setLabels(array_reverse($dates));
}
# Output the chart
/*header("Content-type: image/png");
print($c->makeChart2(PNG));
?>*/
# Create the image and save it in a temporary location
$chart1URL = $c->makeSession("chart1");
# Create an image map for the chart
$imageMap = $c->getHTMLImageMap("", "", "title='{dataSetName}: {value}'");
?>
<html>
<img src="chartdirector/phpdemo/getchart.php?
<?php echo $chart1URL?>" border="0" usemap="#map1">
<map name="map1">
<?php echo $imageMap?>
</map>
</body>
</html>