Grid not displaying

Dev Shed Forums Sponsor:

February 26th, 2013, 08:15 AM

samyx

Registered User

Join Date: Feb 2013

Posts: 5

Time spent in forums: 55 m 56 sec
Reputation Power: 0

Grid not displaying

Hello Everyone,

I am having problems trying to display a grid in the same page as 2 graphs. The grid displays no problems when I put the code in a separate file, but when I combine with the graph file it only display the grid headers. I used the element inspect and I can see the data is being capture by the grid with no problem. So the issue is strictly the display. Can anyone help me? Please see code below.

PS: sorry if the code is not very clean, efficient or organized. I am a beginner in the web development world.

PHP Code:


		
			
<!DOCTYPE html>

<html >

<head>

<meta http-equiv="Content-Type" content="text/html" charset="UTF-8">



<body class="Wetland">



<center><img src="./images/lacrn.jpg"></center>

<center    



<?php

$studynum = $_GET['studynum'];

$datestamp = date("Y-m-d");

$datestampnotime = date("l, F d, Y");

echo "<center><h1>US-LA CRN OpenClinica Dashboard</h1></center>";

echo "<center><h2>Data for Study: $studynum</h2></center>";

echo "<center><h4>Data Current as of: $datestampnotime</h4></center>";



//connect to database

$db = pg_connect('host=localhost dbname=dash_xc user=postgres password=postgres') or die('Sorry, could not connect to database server');



    

    //total number of participants

    $query1 = "select ar from data_review.dash_pivot_metadata m, data_review.dash_pivot_history d

where d.date_imported = '$studynum' and  m.sequences=d.sequences and d.sequences in (3)";

    //number of participants in neoadjuvant chemoterapy

    $query2 = "select ar from data_review.dash_pivot_metadata m, data_review.dash_pivot_history d

where d.date_imported = '$studynum' and  m.sequences=d.sequences and d.sequences in (4)";

    //number of participants in surgery

    $query3 = "select ar from data_review.dash_pivot_metadata m, data_review.dash_pivot_history d

where d.date_imported = '$studynum' and  m.sequences=d.sequences and d.sequences in (5)";

    //number of participants off study

    $query4 = "select ar from data_review.dash_pivot_metadata m, data_review.dash_pivot_history d

where d.date_imported = '$studynum' and  m.sequences=d.sequences and d.sequences in (33)";

    //number of participants expected

    $query5 = "select ar from data_review.dash_pivot_metadata m, data_review.dash_pivot_history d

where d.date_imported = '$studynum' and  m.sequences=d.sequences and d.sequences in (7)";

    //number of participants unassigned

    $query6="select ar from data_review.dash_pivot_metadata m, data_review.dash_pivot_history d

where d.date_imported = '$studynum' and  m.sequences=d.sequences and d.sequences in (6)";

    



    //total number of CRFs

    $query7="select ar from data_review.dash_pivot_metadata m, data_review.dash_pivot_history d

where d.date_imported = '$studynum' and  m.sequences=d.sequences and d.sequences in (9)";

    //number of neo chemo CRFs

    $query8="select ar from data_review.dash_pivot_metadata m, data_review.dash_pivot_history d

where d.date_imported = '$studynum' and  m.sequences=d.sequences and d.sequences in (10)";

    //number of surgery CRFs

    $query9="select ar from data_review.dash_pivot_metadata m, data_review.dash_pivot_history d

where d.date_imported = '$studynum' and  m.sequences=d.sequences and d.sequences in (11)";

    //number of CRFs expected

    $query11="select ar from data_review.dash_pivot_metadata m, data_review.dash_pivot_history d

where d.date_imported = '$studynum' and  m.sequences=d.sequences and d.sequences in (7)";

    //number of unassigned CRFs

    $query12="select ar from data_review.dash_pivot_metadata m, data_review.dash_pivot_history d

where d.date_imported = '$studynum' and  m.sequences=d.sequences and d.sequences in (13)";

    

    $result1 = pg_query($query1) or die ('Could not find total');

    $res1= pg_fetch_array($result1);

    $totalp = $res1[0];

    //$totalp=json_encode($totalp);

    //echo ($totalp);

        

    $result2 =pg_query($query2) or die ('Could not find neo chemoterapy');

    $res2 = pg_fetch_array($result2);

    $chemop = $res2[0];

    //$chemop= json_encode($chemop);

    

    $result3 = pg_query($query3) or die ('Could not find surgery');

    $res3 = pg_fetch_array($result3);

    $surgeryp = $res3[0];

    //$surgeryp = json_encode($surgeryp);

        

    $result4 = pg_query($query4) or die ('Could not find off study');

    $res4 = pg_fetch_array($result4);

    $offp = $res4[0];

    //$offp = json_encode($offp);

    //print_r($offp);

    

    $result5 = pg_query($query5) or die ('Could not find expected');

    $res5 = pg_fetch_array($result5);

    $expectp = $res5[0];

    //$expectp = json_encode($expectp);

    //print_r($expectp);

    

    $result6 = pg_query($query6) or die ('Could not find unassigned');

    $res6 = pg_fetch_array($result6);

    $unassignp = $res6[0];

    //$unassignp= json_encode($unassignp);

    //print_r($unassignp);



    $result7 = pg_query($query7) or die ('Could not find total CRF');

    $res7 = pg_fetch_array($result7);

    $totalp1 = $res7[0];



    $result8 = pg_query($query8) or die ('Could not find neo chemo CRF');

    $res8 = pg_fetch_array($result8);

    $chemop1 = $res8[0];



    $result9 = pg_query($query9) or die ('Could not find surgery CRF');

    $res9 = pg_fetch_array($result9);

    $surgeryp1 = $res9[0];



    $result11 = pg_query($query11) or die ('Could not find expected CRF');

    $res11 = pg_fetch_array($result11);

    $expectp1 = $res11[0];



    $result12 = pg_query($query12) or die ('Could not find unassigned CRF');

    $res12 = pg_fetch_array($result12);

    $unassignp1 = $res12[0];

?>

    

<link rel="stylesheet" type="text/css"

 href="../dijit/themes/claro/claro.css" />



<link rel="stylesheet" type="text/css"

 href="../dojox/grid/resources/Grid.css" />



 <link rel="stylesheet" type="text/css"

 href="../dojox/grid/resources/claroGrid.css" />



<script>dojoConfig = {parseOnLoad: true,locale:'en-us',extraLocale: ['es-es','pt-br']}</script>

<script src="//ajax.googleapis.com/ajax/libs/dojo/1.8.1/dojo/dojo.js" charset="utf-8"

               data-dojo-config="async: true"></script>





<script type="text/javascript">

    dojo.require("dojox.grid.DataGrid");

    dojo.require("dojo.data.ItemFileReadStore");

</script>







<?php

 // $studynum = $_GET['studynum'].'%';

   if (empty($studynum)){

     $studynum = "";

    }else{

     $studynum = $_GET['studynum'];}

?>



<script type="text/javascript">

dojo.ready(function() {

    var query99{

        items: [ 

        <?php require_once '../webroot/lacrndb3.php';

          fquery99($studynum); ?>



               ]

    };



    var dataStore =

    new dojo.data.ItemFileReadStore(

        { data:query99}

    );

    var grid = dijit.byId("query99");

    grid.setStore(dataStore);

});

</script>

<script>

require([

     // Require the basic chart class

    "dojox/charting/Chart", 

    // Require the theme of our choosing

    "dojox/charting/themes/MiamiNice", 

    // Charting plugins: 

    //  We want to plot Columns

    "dojox/charting/plot2d/Columns",    

    //  We want to plot StackedColumns

    "dojox/charting/plot2d/StackedColumns", 

    //  We want to use Markers

    "dojox/charting/plot2d/Markers", 

    //  We'll use default x/y axes

    "dojox/charting/axis2d/Default",

    //We'll use highlight

    "dojox/charting/action2d/Highlight",

    //we'll use tooltip

    "dojox/charting/action2d/Tooltip",    

    //we'll use Legend

    "dojox/charting/widget/Legend", 

     // Wait until the DOM is ready

    "dojo/domReady!"

],

 function(Chart, theme, Highlight, Tooltip) {

 

    // Define the data

    

    var total= <?php print_r ($totalp); ?>;

    //alert(total);

    var chemo = <?php echo ($chemop); ?>;

    //alert(chemo);

    var surgery = <?php echo ($surgeryp); ?>;

    //alert(surgery);

    var offstudy = <?php echo ($offp); ?>;

    //alert(offstudy);

    var expected = <?php echo ($expectp); ?>;

    //alert(expected);

    var unassigned = <?php echo ($unassignp); ?>;

    //alert(unassigned);



    var total1= <?php print_r ($totalp1); ?>;

    //alert(total);

    var chemo1 = <?php echo ($chemop1); ?>;

    //alert(chemo);

    var surgery1 = <?php echo ($surgeryp1); ?>;

    //alert(surgery);

    var expected1 = <?php echo ($expectp1); ?>;

    //alert(expected);

    var unassigned1 = <?php echo ($unassignp1); ?>;

    //alert(unassigned);



    

    // Create the chart within it's "holding" node

    var chart = new Chart("chartNode");

    var chart2 = new Chart("chartNode2");

    

    // Set the theme

    chart.setTheme(theme);

    chart2.setTheme(theme);

 

    // Add the only/default plot

    chart.addPlot("default", {

       type: "Columns",

       markers: true,

       shadows: {dx:2, dy:2, dw:2},

       gap: 2

    });

    chart2.addPlot("default", {

       type: "Columns",

       markers: true,

       shadows: {dx:2, dy:2, dw:2},

       gap: 2

    });



     

     

    // Add axes

    chart.addAxis("x", {title:"Arms", titleOrientation: "away", minorLabels: false, labels:[{value:0, text:""}, {value:1, text:"NeoAdj Chemo"}, {value:2, text:"Surgery"},{value:3, text: "Unassigned"}, {value:4, text:"Off Study"}, {value:5, text:"Total (Actual)"}, {value:6, text:"Total (Expected)"}], rotation:-45});

    chart.addAxis("y", {title: "Participants", vertical: true, includeZero: true, ticks:true, majorLabels:true, minorLabels: false });

    

    chart2.addAxis("x", {title:"Arms", titleOrientation: "away", minorLabels: false, labels:[{value:0, text:""}, {value:1, text:"NeoAdj Chemo"}, {value:2, text:"Surgery"},{value:3, text: "Unassigned"}, {value:4, text:"Total (Actual)"}, {value:5, text:"Total (Expected)"}], rotation:-45});

    chart2.addAxis("y", {title: "CRFs", vertical: true, includeZero: true, ticks:true, majorLabels:true, minorLabels: false });

     

    // Add the series of data for graph1-Participants

    chart.addSeries("NeoAdj Chemo", [chemo,0,0,0,0,0], {stroke:"#FF0099", fill:"#FEA9F3"});

    chart.addSeries("Surgery", [0,surgery,0,0,0,0], {stroke:"#FFFF00", fill:"#FFFF33"});

    chart.addSeries("Unassigned", [0,0,unassigned,0,0,0], {stroke:"#FF0000", fill:"#CC6600"});

        chart.addSeries("Off-Study", [0,0,0,offstudy,0,0], {stroke: "black", fill:"gray"});

    chart.addSeries("Total (Actual)",[0,0,0,0,total,0], {stroke:"black", fill:"black"});

    chart.addSeries("Total (Expected)", [0,0,0,0,0,expected], {stroke: "black", fill:"blue"});

    

   //Add the series of data for graph2-CRFs

    chart2.addSeries("NeoAdj Chemo", [chemo1,0,0,0,0], {stroke:"#FF0099", fill:"#FEA9F3"});

    chart2.addSeries("Surgery ", [0,surgery1,0,0,0], {stroke:"#FFFF00", fill:"#FFFF33"});

    chart2.addSeries("Unassigned ", [0,0,unassigned1,0,0], {stroke:"#FF0000", fill:"#CC6600"});

     chart2.addSeries("Total(Actual)",[0,0,0,total1,0], {stroke:"black", fill:"black"});

    chart2.addSeries("Total(Expected)", [0,0,0,0,expected1], {stroke: "black", fill:"blue"});

 





    var mag = new dojox.charting.action2d.Highlight(chart,"default");

    var mag2 = new dojox.charting.action2d.Highlight(chart2,"default");



   // new Tooltip(chart, "default");

   // new Tooltip(chart2, "default");

    // Render the chart!

    chart.render();

    chart2.render();



    

    

    //var legend1 = new dojox.charting.widget.Legend({chart: chart, horizontal:true}, "legend1");

    //var legend2 = new dojox.charting.widget.Legend({chart: chart2, horizontal:true}, "legend2");

    

 

});

 

</script>

 



<table BORDER="2" BORDERCOLOR="#336699" CELLPADDING="2" CELLSPACING="2" WIDTH="100%">

<tr>

    <td>    

    <div id="chartNode" style="float:left">    

       </div>

            

    </td>

    <td>    

    <div id="chartNode2" style="float:left">    

       </div>

            

    </td>

    </tr>

</table>



<center>

<table border ="2" width="100%" heightt="10">

<tr>

    <td> "Testing"</td>

</tr>

</table>

</center>



<center>

    <FORM name="lacrn1" action="lacrnv3.php" method="get">

    <SELECT name="studynum">

    <?php require_once '../webroot/lacrndb3.php';

    studylist();

    

 

    ?>

    </SELECT>

    <INPUT TYPE="submit" value="Submit">

    </FORM>



 <form><input type="button" value="Download the CSV File" onClick="/hello.php"></form> 

<table border="0" cellspacing="20px">

<tr><td>

<style>

p {text-indent:30px;}

</style>

        <br><h3><!--Subjects Enrolled to Unassigned Arm--></h3>

        <div style="width: 1150px; height: 768px">

        <table id="query99" dojoType="dojox.grid.DataGrid" escapeHTMLInData="false" canSort="function(){return false}">

        

              

            <thead>

                <tr>

                      <th field="Parameter" width="550px">Parameter</th>

                      <th field="ar" width="80"><center> BR</center></th>

                <th field="cl" width="80"><center> CL</center></th>

                                <th field="mxjal" width="80"><center> MX-JAL</center></th>

                                <th field="mxson" width="80"><center> MX-SON</center></th>

                                <th field="uy" width="80"><center><a UY</center></th>

                <th field="total" width="100"><center>TOTAL</center></th>

                </tr>

              </thead>

            

        </table>

    </div>

      

</table>

</center>







</body>

</html>

Last edited by ManiacDan : February 26th, 2013 at 08:48 AM. Reason: PHP tags

February 26th, 2013, 09:23 AM

Jacques1

pollyanna

Join Date: Jul 2012

Location: Germany

Posts: 1,867

Time spent in forums: 1 Month 2 Weeks 1 Day 22 h 33 m 20 sec
Reputation Power: 813

Hi,

check the JavaScript console of your browser. Maybe there's some error. Also check the HTML source code to see if evey echo outputs the right data.

Apart from that, it's difficult to help when we don't have any data to actually try it out.

In any case, you have several massive security holes that you should fix immediately: The 6 worst sins of security. And you should start structuring your code and getting rid of the useless repetitions. When you find yourself copying the same line over and over again, there's clearly a more intelligent way. I mean, what's the point of making a separate query for every possible value of sequences? Make one query for all values and then loop over the rows to output what you want.

__________________
The 6 worst sins of security • The mystery of errors and exceptions

February 26th, 2013, 02:10 PM

samyx

Registered User

Join Date: Feb 2013

Posts: 5

Time spent in forums: 55 m 56 sec
Reputation Power: 0

I know the code is not the most efficient one, but it is getting the data correctly, both the queries and the grid is getting the correct data. They both work just fine when in separate files. However, when I combine both the grid doesnt display. I used Firebug to check for the java script code and everything looks fine. Is it possible that some of the css is orverlapping and preventing the grid from displaying?

Quote:

Originally Posted by Jacques1

Hi,

check the JavaScript console of your browser. Maybe there's some error. Also check the HTML source code to see if evey echo outputs the right data.

Apart from that, it's difficult to help when we don't have any data to actually try it out.

In any case, you have several massive security holes that you should fix immediately: The 6 worst sins of security[/URL]. And you should start structuring your code and getting rid of the useless repetitions. When you find yourself copying the same line over and over again, there's clearly a more intelligent way. I mean, what's the point of making a separate query for every possible value of sequences? Make one query for all values and then loop over the rows to output what you want.

February 26th, 2013, 02:47 PM

Jacques1

pollyanna

Join Date: Jul 2012

Location: Germany

Posts: 1,867

Time spent in forums: 1 Month 2 Weeks 1 Day 22 h 33 m 20 sec
Reputation Power: 813

Quote:

Originally Posted by samyx

I know the code is not the most efficient one, but it is getting the data correctly, both the queries and the grid is getting the correct data.

If you actually want to learn programming, then "it's working" isn't enough.

Whether or not code "works" doesn't tell you anything about its quality. Terrible code can (seemingly) work, while excellent code can fail because of some minor issue. The difference is that good code can be fixed, but bad code will cause all kind of problems and waste your time until you finally rewrite it.

So your goal should be to write good code, not "working" code.

Quote:

Originally Posted by samyx

Is it possible that some of the css is orverlapping and preventing the grid from displaying?

How's that possible when you haven't changed the CSS?

You do know the procedure, right? The webserver interprets the PHP code in order to generate HTML. The whole HTML document is then sent to the browser, which interprets it and also executed the JavaScript code.

So if you haven't changed any of the HTML, CSS or JavaScript, then obviously the PHP code does not work correctly. It's up to you to check it (by looking at the HTML source code).

March 1st, 2013, 01:53 PM

samyx

Registered User

Join Date: Feb 2013

Posts: 5

Time spent in forums: 55 m 56 sec
Reputation Power: 0

The code for the graph works fine when in an individual file
The code for the grid works fine when in an individual file
When combining both it does not display the grid but the graphs display

I tried creating like an index.php file and include those two files in it, but it still doesnt display the graph.

Do you mean that the php code for both conflict?

From the view page source:

<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html" charset="UTF-8">
<title>US-LA CRN Dashboard</title>
</head>

<center><img src="./images/lacrn.jpg"></center>

<center><h1>US-LA CRN OpenClinica Dashboard</h1></center><center><h2>Data for Study: 2013-03-01</h2></center><center><h4>Data Current as of: Friday, March 01, 2013</h4></center>
<body class="claro">

<div id ="graphs">
<link rel="stylesheet" type="text/css" href="../dijit/themes/claro/claro.css" />

<script>dojoConfig = {parseOnLoad: true}</script>
<script src="//ajax.googleapis.com/ajax/libs/dojo/1.8.1/dojo/dojo.js"
data-dojo-config="async: true"></script>

<script>
require([
// Require the basic chart class
"dojox/charting/Chart",
// Require the theme of our choosing
"dojox/charting/themes/MiamiNice",
// Charting plugins:
// We want to plot Columns
"dojox/charting/plot2d/Columns",
// We want to plot StackedColumns
"dojox/charting/plot2d/StackedColumns",
// We want to use Markers
"dojox/charting/plot2d/Markers",
// We'll use default x/y axes
"dojox/charting/axis2d/Default",
//We'll use highlight
"dojox/charting/action2d/Highlight",
//we'll use tooltip
"dojox/charting/action2d/Tooltip",
//we'll use Legend
"dojox/charting/widget/Legend",
// Wait until the DOM is ready
"dojo/domReady!"
],
function(Chart, theme, Highlight, Tooltip) {

// Define the data

var total= 167;
//alert(total);
var chemo = 90;
//alert(chemo);
var surgery = 77;
//alert(surgery);
var offstudy = 8;
//alert(offstudy);
var expected = 660;
//alert(expected);
var unassigned = 0;
//alert(unassigned);

var total1= 6470;
//alert(total);
var chemo1 = 3193;
//alert(chemo);
var surgery1 = 3277;
//alert(surgery);
var expected1 = 660;
//alert(expected);
var unassigned1 = 24;
//alert(unassigned);

// Create the chart within it's "holding" node
var chart = new Chart("chartNode");
var chart2 = new Chart("chartNode2");

// Set the theme
chart.setTheme(theme);
chart2.setTheme(theme);

// Add the only/default plot
chart.addPlot("default", {
type: "Columns",
markers: true,
shadows: {dx:2, dy:2, dw:2},
gap: 2
});
chart2.addPlot("default", {
type: "Columns",
markers: true,
shadows: {dx:2, dy:2, dw:2},
gap: 2
});

// Add axes
chart.addAxis("x", {title:"Arms", titleOrientation: "away", minorLabels: false, labels:[{value:0, text:""}, {value:1, text:"NeoAdj Chemo"}, {value:2, text:"Surgery"},{value:3, text: "Unassigned"}, {value:4, text:"Off Study"}, {value:5, text:"Total (Actual)"}, {value:6, text:"Total (Expected)"}], rotation:-45});
chart.addAxis("y", {title: "Participants", vertical: true, includeZero: true, ticks:true, majorLabels:true, minorLabels: false });

chart2.addAxis("x", {title:"Arms", titleOrientation: "away", minorLabels: false, labels:[{value:0, text:""}, {value:1, text:"NeoAdj Chemo"}, {value:2, text:"Surgery"},{value:3, text: "Unassigned"}, {value:4, text:"Total (Actual)"}, {value:5, text:"Total (Expected)"}], rotation:-45});
chart2.addAxis("y", {title: "CRFs", vertical: true, includeZero: true, ticks:true, majorLabels:true, minorLabels: false });

// Add the series of data for graph1-Participants
chart.addSeries("NeoAdj Chemo", [chemo,0,0,0,0,0], {stroke:"#FF0099", fill:"#FEA9F3"});
chart.addSeries("Surgery", [0,surgery,0,0,0,0], {stroke:"#FFFF00", fill:"#FFFF33"});
chart.addSeries("Unassigned", [0,0,unassigned,0,0,0], {stroke:"#FF0000", fill:"#CC6600"});
chart.addSeries("Off-Study", [0,0,0,offstudy,0,0], {stroke: "black", fill:"gray"});
chart.addSeries("Total (Actual)",[0,0,0,0,total,0], {stroke:"black", fill:"black"});
chart.addSeries("Total (Expected)", [0,0,0,0,0,expected], {stroke: "black", fill:"blue"});

//Add the series of data for graph2-CRFs
chart2.addSeries("NeoAdj Chemo", [chemo1,0,0,0,0], {stroke:"#FF0099", fill:"#FEA9F3"});
chart2.addSeries("Surgery ", [0,surgery1,0,0,0], {stroke:"#FFFF00", fill:"#FFFF33"});
chart2.addSeries("Unassigned ", [0,0,unassigned1,0,0], {stroke:"#FF0000", fill:"#CC6600"});
chart2.addSeries("Total(Actual)",[0,0,0,total1,0], {stroke:"black", fill:"black"});
chart2.addSeries("Total(Expected)", [0,0,0,0,expected1], {stroke: "black", fill:"blue"});

var mag = new dojox.charting.action2d.Highlight(chart,"default");
var mag2 = new dojox.charting.action2d.Highlight(chart2,"default");

// Render the chart!
chart.render();
chart2.render();

});

</script>

<table BORDER="2" BORDERCOLOR="#336699" CELLPADDING="2" CELLSPACING="2" WIDTH="100%">
<tr>
<td>
<div id="chartNode" style="float:left">
</div>

</td>
<td>
<div id="chartNode2" style="float:left">
</div>

</td>
</tr>
</table>

</div>
</body>

<body class="other">
<div id ="dashGrid"> <link rel="stylesheet" type="text/css"
href="./dijit/themes/claro/claro.css" />

<link rel="stylesheet" type="text/css"
href="./dojox/grid/resources/Grid.css" />

<link rel="stylesheet" type="text/css"
href="./dojox/grid/resources/claroGrid.css" />

<center>
<table BORDER="2" BORDERCOLOR="#336699" CELLPADDING="2" CELLSPACING="2" WIDTH="auto">

<tr><td><center>
<FORM name="lacrn1" action="lacrnv3.php" method="get">
<SELECT name="studynum">
<OPTION value="">--Selecione uma Data--</OPTION><OPTION value="2013-03-01">2013-03-01</OPTION>, <OPTION value="2013-02-28">2013-02-28</OPTION>, <OPTION value="2013-02-27">2013-02-27</OPTION>, <OPTION value="2013-02-26">2013-02-26</OPTION>, <OPTION value="2013-02-25">2013-02-25</OPTION>, <OPTION value="2013-02-24">2013-02-24</OPTION>, <OPTION value="2013-02-23">2013-02-23</OPTION>, <OPTION value="2013-02-22">2013-02-22</OPTION>, <OPTION value="2013-02-21">2013-02-21</OPTION>, <OPTION value="2013-02-20">2013-02-20</OPTION>, <OPTION value="2013-02-19">2013-02-19</OPTION>, <OPTION value="2013-02-18">2013-02-18</OPTION>, <OPTION value="2013-02-17">2013-02-17</OPTION>, <OPTION value="2013-02-16">2013-02-16</OPTION>, <OPTION value="2013-02-15">2013-02-15</OPTION>, <OPTION value="2013-02-14">2013-02-14</OPTION>, <OPTION value="2013-02-13">2013-02-13</OPTION>, <OPTION value="2013-02-12">2013-02-12</OPTION>, <OPTION value="2013-02-11">2013-02-11</OPTION>, <OPTION value="2013-02-10">2013-02-10</OPTION>, <OPTION value="2013-02-09">2013-02-09</OPTION>, <OPTION value="2013-02-08">2013-02-08</OPTION>, <OPTION value="2013-02-07">2013-02-07</OPTION>, <OPTION value="2013-02-06">2013-02-06</OPTION>, <OPTION value="2013-02-05">2013-02-05</OPTION>, <OPTION value="2013-02-04">2013-02-04</OPTION>, <OPTION value="2013-02-03">2013-02-03</OPTION>, <OPTION value="2013-02-02">2013-02-02</OPTION>, <OPTION value="2013-02-01">2013-02-01</OPTION>, <OPTION value="2013-01-31">2013-01-31</OPTION>, <OPTION value="2013-01-30">2013-01-30</OPTION>, <OPTION value="2013-01-29">2013-01-29</OPTION>, <OPTION value="2013-01-28">2013-01-28</OPTION>, <OPTION value="2013-01-27">2013-01-27</OPTION>, <OPTION value="2013-01-26">2013-01-26</OPTION>, <OPTION value="2013-01-25">2013-01-25</OPTION>, <OPTION value="2013-01-24">2013-01-24</OPTION>, <OPTION value="2013-01-23">2013-01-23</OPTION>, <OPTION value="2013-01-22">2013-01-22</OPTION>, <OPTION value="2013-01-21">2013-01-21</OPTION>, <OPTION value="2013-01-20">2013-01-20</OPTION>, <OPTION value="2013-01-19">2013-01-19</OPTION>, <OPTION value="2013-01-18">2013-01-18</OPTION>, <OPTION value="2013-01-17">2013-01-17</OPTION>, <OPTION value="2013-01-16">2013-01-16</OPTION>, <OPTION value="2013-01-15">2013-01-15</OPTION>, <OPTION value="2013-01-14">2013-01-14</OPTION>, <OPTION value="2013-01-13">2013-01-13</OPTION>, <OPTION value="2013-01-12">2013-01-12</OPTION>, <OPTION value="2013-01-11">2013-01-11</OPTION>, <OPTION value="2013-01-10">2013-01-10</OPTION>, <OPTION value="2013-01-09">2013-01-09</OPTION>, <OPTION value="2013-01-08">2013-01-08</OPTION>, <OPTION value="2013-01-07">2013-01-07</OPTION>, <OPTION value="2013-01-06">2013-01-06</OPTION>, <OPTION value="2013-01-05">2013-01-05</OPTION>, <OPTION value="2013-01-04">2013-01-04</OPTION>, <OPTION value="2013-01-03">2013-01-03</OPTION>, <OPTION value="2013-01-02">2013-01-02</OPTION>, <OPTION value="2013-01-01">2013-01-01</OPTION>, <OPTION value="2012-12-31">2012-12-31</OPTION>, <OPTION value="2012-12-29">2012-12-29</OPTION>, <OPTION value="2012-12-28">2012-12-28</OPTION>, <OPTION value="2012-12-27">2012-12-27</OPTION>, <OPTION value="2012-12-26">2012-12-26</OPTION>, <OPTION value="2012-12-25">2012-12-25</OPTION>, <OPTION value="2012-12-24">2012-12-24</OPTION>, <OPTION value="2012-12-23">2012-12-23</OPTION>, <OPTION value="2012-12-22">2012-12-22</OPTION>, <OPTION value="2012-12-21">2012-12-21</OPTION>, <OPTION value="2012-12-20">2012-12-20</OPTION>, <OPTION value="2012-12-19">2012-12-19</OPTION>, <OPTION value="2012-12-18">2012-12-18</OPTION>, <OPTION value="2012-12-17">2012-12-17</OPTION>, <OPTION value="2012-12-16">2012-12-16</OPTION>, <OPTION value="2012-12-15">2012-12-15</OPTION>, <OPTION value="2012-12-14">2012-12-14</OPTION>, <OPTION value="2012-12-13">2012-12-13</OPTION>, <OPTION value="2012-12-12">2012-12-12</OPTION>, <OPTION value="2012-12-11">2012-12-11</OPTION>, <OPTION value="2012-12-10">2012-12-10</OPTION>, <OPTION value="2012-12-09">2012-12-09</OPTION>, <OPTION value="2012-12-08">2012-12-08</OPTION>, <OPTION value="2012-12-07">2012-12-07</OPTION>, <OPTION value="2012-12-06">2012-12-06</OPTION>, <OPTION value="2012-12-05">2012-12-05</OPTION>, <OPTION value="2012-12-04">2012-12-04</OPTION>, <OPTION value="2012-12-03">2012-12-03</OPTION>, <OPTION value="2012-12-02">2012-12-02</OPTION>, <OPTION value="2012-12-01">2012-12-01</OPTION>, <OPTION value="2012-11-30">2012-11-30</OPTION>, <OPTION value="2012-11-14">2012-11-14</OPTION>, <OPTION value="2012-10-31">2012-10-31</OPTION>, <OPTION value="2012-10-17">2012-10-17</OPTION>, <OPTION value="2012-10-10">2012-10-10</OPTION>, <OPTION value="2012-10-04">2012-10-04</OPTION> </SELECT>
<INPUT TYPE="submit" value="Submit">
</FORM>

<form><input type="button" value="Download the CSV File" onClick="window.location.href='hello.php'"></form>
</center></td></tr></table></center>

<center>
<table border="0" BORDERCOLOR="#336699" CELLPADDING="2" cellspacing="2" width = "auto">
<tr><td>
<style>
p {text-indent:30px;}
</style>
<br><h3></h3>
<div style="width: 1150px; height: 768px">
<table id="query99" dojoType="dojox.grid.DataGrid">

<thead>
<tr>
<th field="Parameter" width="550px">Parameter</th>
<th field="ar" width="80"><center><a href="dash_ar.php">AR</a></center></th>
<th field="br" width="80"><center><a href="dash.php">BR</center></th>
<th field="cl" width="80"><center><a href="dash.php">CL</center></th>
<th field="mxjal" width="80"><center><a href="dash.php">MX-JAL</center></th>
<th field="mxson" width="80"><center><a href="dash.php">MX-SON</center></th>
<th field="uy" width="80"><center><a href="dash.php">UY</center></th>
<th field="total" width="100"><center>TOTAL</center></th>
</tr>
</thead>

</table>
</div>

</table>
</center>
</table>
</center>

<script type="text/javascript"
src="./dojo/dojo.js" charset="utf-8"
djConfig="parseOnLoad:true,locale:'en-us',extraLocale: ['es-es','pt-br']"></script>

<script type="text/javascript">
dojo.require("dojox.grid.DataGrid");
dojo.require("dojo.data.ItemFileReadStore");
</script>

<script type="text/javascript">
dojo.ready(function() {
var query99 = {
items: [
{ "Parameter":"<b>Number of Participants Enrolled</b>", "ar":"<center>167</center>" , "br":"<center>132</center>" , "cl":"<center>77</center>" ,"mxjal":"<center>127</center>" ,"mxson":"<center>64</center>" ,"uy":"<center>80</center>" , "total":"<center>647</center>" }, { "Parameter":"<BLOCKQUOTE> Number of Participants Enrolled in Neoadjuvant Chemotherapy Arm</BLOCKQUOTE>", "ar":"<center>90</center>" , "br":"<center>58</center>" , "cl":"<center>29</center>" ,"mxjal":"<center>63</center>" ,"mxson":"<center>20</center>" ,"uy":"<center>26</center>" , "total":"<center>286</center>" }, { "Parameter":"<BLOCKQUOTE> Number of Participants Enrolled in Primary Surgery Arm</BLOCKQUOTE>", "ar":"<center>77</center>" , "br":"<center>74</center>" , "cl":"<center>40</center>" ,"mxjal":"<center>64</center>" ,"mxson":"<center>41</center>" ,"uy":"<center>54</center>" , "total":"<center>350</center>" }, { "Parameter":"<BLOCKQUOTE> Number of Participants Enrolled to Unassigned Arm</BLOCKQUOTE>", "ar":"<center>0</center>" , "br":"<center>0</center>" , "cl":"<center>8</center>" ,"mxjal":"<center>0</center>" ,"mxson":"<center>3</center>" ,"uy":"<center>0</center>" , "total":"<center>11</center>" }, { "Parameter":"<b>Number of Expected Enrollment</b>", "ar":"<center>660</center>" , "br":"<center>600</center>" , "cl":"<center>400</center>" ,"mxjal":"<center>460</center>" ,"mxson":"<center>385</center>" ,"uy":"<center>120</center>" , "total":"<center>2625</center>" }, { "Parameter":"<br><b>Percent of Expected Enrollment (%)</b>", "ar":"<center>25%</center>" , "br":"<center>22%</center>" , "cl":"<center>19%</center>" , "mxjal":"<center>27%</center>" ,"mxson":"<center>16%</center>" ,"uy":"<center>66%</center>" , "total":"<center>24%</center>" }, { "Parameter":"<br><b>Number of CRFs Started</b>", "ar":"<center>6470</center>" , "br":"<center>3870</center>" , "cl":"<center>2074</center>" , "mxjal":"<center>6467</center>" , "mxson":"<center>1530</center>" , "uy":"<center>3548</center>" , "total":"<center>23959</center>" }, { "Parameter":"<BLOCKQUOTE> Number of CRFs Started In Neoadjuvant Chemotherapy Arm</BLOCKQUOTE>", "ar":"<center>3193</center>" , "br":"<center>2479</center>" , "cl":"<center>818</center>" ,"mxjal":"<center>4279</center>" ,"mxson":"<center>552</center>" ,"uy":"<center>1078</center>" , "total":"<center>12399</center>" }, { "Parameter":"<BLOCKQUOTE> Number of CRFs Started In Primary Surgery Arm</BLOCKQUOTE>", "ar":"<center>3277</center>" , "br":"<center>1391</center>" , "cl":"<center>1100</center>" ,"mxjal":"<center>2188</center>" ,"mxson":"<center>903</center>" ,"uy":"<center>2470</center>" , "total":"<center>11329</center>" }, { "Parameter":"<BLOCKQUOTE> Number of CRFs Started In Unassigned Participants</BLOCKQUOTE>", "ar":"<center>0</center>" , "br":"<center>0</center>" , "cl":"<center>156</center>" ,"mxjal":"<center>0</center>" ,"mxson":"<center>75</center>" ,"uy":"<center>0</center>" , "total":"<center>231</center>" }, { "Parameter":"<b>Percent CRFs Started (%)</b>", "ar":"<center>24%</center>" , "br":"<center>19%</center>" , "cl":"<center>20%</center>" ,"mxjal":"<center>33%</center>" ,"mxson":"<center>18%</center>" ,"uy":"<center>32%</center>" , "total":"<center>25%</center>" }, { "Parameter":"<BLOCKQUOTE> Percent CRFs Started In Neoadjuvant Chemotherapy Arm (%)</BLOCKQUOTE>", "ar":"<center>16%</center>" , "br":"<center>20%</center>" , "cl":"<center>13%</center>" ,"mxjal":"<center>32%</center>" ,"mxson":"<center>13%</center>" ,"uy":"<center>19%</center>" , "total":"<center>20%</center>" }, { "Parameter":"<BLOCKQUOTE> Percent CRFs Started In Primary Surgery Arm (%)</BLOCKQUOTE>", "ar":"<center>43%</center>" , "br":"<center>19%</center>" , "cl":"<center>28%</center>" ,"mxjal":"<center>34%</center>" ,"mxson":"<center>22%</center>" ,"uy":"<center>46%</center>" , "total":"<center>33%</center>" }, { "Parameter":"<BLOCKQUOTE> Percent CRFs Started in Unassigned Participant (%)</BLOCKQUOTE>", "ar":"<center>0%</center>" , "br":"<center>0%</center>" , "cl":"<center>19%</center>" ,"mxjal":"<center>0%</center>" ,"mxson":"<center>25%</center>" ,"uy":"<center>0%</center>" , "total":"<center>44%</center>" }, { "Parameter":"<b>Number of CRFs Marked as Completed by Data Entry</b>", "ar":"<center>5828</center>" , "br":"<center>3497</center>" , "cl":"<center>1822</center>" ,"mxjal":"<center>5933</center>" ,"mxson":"<center>1020</center>" ,"uy":"<center>3273</center>" , "total":"<center>21373</center>" }, { "Parameter":"<BLOCKQUOTE> Number of CRFs in Neoadjuvant Chemotherapy Arm Marked as Completed By Data Entry</BLOCKQUOTE>", "ar":"<center>2870</center>" , "br":"<center>2301</center>" , "cl":"<center>794</center>" ,"mxjal":"<center>3997</center>" ,"mxson":"<center>425</center>" ,"uy":"<center>973</center>" , "total":"<center>11360</center>" }, { "Parameter":"<BLOCKQUOTE> Number of CRFs in Primary Surgery Arm Marked as Completed By Data Entry</BLOCKQUOTE>", "ar":"<center>2958</center>" , "br":"<center>1196</center>" , "cl":"<center>900</center>" ,"mxjal":"<center>1936</center>" ,"mxson":"<center>550</center>" ,"uy":"<center>2300</center>" , "total":"<center>9840</center>" }, { "Parameter":"<BLOCKQUOTE> Number of CRFs in Unassigned Participants Marked as Completed by Data Entry</BLOCKQUOTE>", "ar":"<center>0</center>" , "br":"<center>0</center>" , "cl":"<center>128</center>" ,"mxjal":"<center>0</center>" ,"mxson":"<center>45</center>" ,"uy":"<center>0</center>" , "total":"<center>173</center>" }, { "Parameter":"<b>Percent Started CRFs Marked as Completed by Data Entry (%)</b>", "ar":"<center>90%</center>" , "br":"<center>90%</center>" , "cl":"<center>87%</center>" ,"mxjal":"<center>91%</center>" ,"mxson":"<center>66%</center>" ,"uy":"<center>92%</center>" , "total":"<center>89%</center>" }, { "Parameter":"<BLOCKQUOTE> Percent Started Neoadjuvant Chemotherapy CRFs Marked as Completed By Data Entry (%)</BLOCKQUOTE>", "ar":"<center>89%</center>" , "br":"<center>92%</center>" , "cl":"<center>97%</center>" ,"mxjal":"<center>93%</center>" ,"mxson":"<center>76%</center>" ,"uy":"<center>90%</center>" , "total":"<center>91%</center>" }, { "Parameter":"<BLOCKQUOTE> Percent Started Primary Surgery CRFs Marked as Completed By Data Entry (%)</BLOCKQUOTE>", "ar":"<center>90%</center>" , "br":"<center>85%</center>" , "cl":"<center>81%</center>" ,"mxjal":"<center>88%</center>" ,"mxson":"<center>60%</center>" ,"uy":"<center>93%</center>" , "total":"<center>86%</center>" }, { "Parameter":"<BLOCKQUOTE> Percent Unassigned Participant CRFs Marked as Completed by Data Entry (%)</BLOCKQUOTE>", "ar":"<center>0%</center>" , "br":"<center>0%</center>" , "cl":"<center>0%</center>" ,"mxjal":"<center>0%</center>" ,"mxson":"<center>0%</center>" ,"uy":"<center>0%</center>" , "total":"<center>0%</center>" }, { "Parameter":"<b>Number of CRFs Approved by Data Manager</b>", "ar":"<center>3701</center>" , "br":"<center>1425</center>" , "cl":"<center>1058</center>" ,"mxjal":"<center>5865</center>" ,"mxson":"<center>557</center>" ,"uy":"<center>2019</center>" , "total":"<center>14625</center>" }, { "Parameter":"<BLOCKQUOTE> Number of Neoadjuvant Chemotherapy CRFs Approved by Data Manager</BLOCKQUOTE>", "ar":"<center>1957</center>" , "br":"<center>898</center>" , "cl":"<center>573</center>" ,"mxjal":"<center>3950</center>" ,"mxson":"<center>171</center>" ,"uy":"<center>640</center>" , "total":"<center>8189</center>" }, { "Parameter":"<BLOCKQUOTE> Number of Primary Surgery CRFs Approved by Data Manager</BLOCKQUOTE>", "ar":"<center>1744</center>" , "br":"<center>527</center>" , "cl":"<center>472</center>" ,"mxjal":"<center>1915</center>" ,"mxson":"<center>386</center>" ,"uy":"<center>1379</center>" , "total":"<center>6423</center>" }, { "Parameter":"<BLOCKQUOTE> Number of Unassigned Subject CRFs Approved by Data Manager</BLOCKQUOTE>", "ar":"<center>0</center>" , "br":"<center>0</center>" , "cl":"<center>13</center>" ,"mxjal":"<center>0</center>" ,"mxson":"<center>0</center>" ,"uy":"<center>0</center>" , "total":"<center>13</center>" }, { "Parameter":"<b>Percent CRFs Approved by Data Manager (%)</b>", "ar":"<center>63%</center>" , "br":"<center>40%</center>" , "cl":"<center>58%</center>" ,"mxjal":"<center>98%</center>" ,"mxson":"<center>54%</center>" ,"uy":"<center>61%</center>" , "total":"<center>68%</center>" }, { "Parameter":"<BLOCKQUOTE> Percent Neoadjuvant Chemotherapy CRFs approved by Data Manager (%)</BLOCKQUOTE>", "ar":"<center>68%</center>" , "br":"<center>39%</center>" , "cl":"<center>72%</center>" ,"mxjal":"<center>98%</center>" ,"mxson":"<center>40%</center>" ,"uy":"<center>65%</center>" , "total":"<center>72%</center>" }, { "Parameter":"<BLOCKQUOTE> Percent Primary Surgery CRFs approved by Data Manager (%)</BLOCKQUOTE>", "ar":"<center>58%</center>" , "br":"<center>44%</center>" , "cl":"<center>52%</center>" ,"mxjal":"<center>98%</center>" ,"mxson":"<center>70%</center>" ,"uy":"<center>59%</center>" , "total":"<center>65%</center>" }, { "Parameter":"<BLOCKQUOTE> Percent Unassigned Participant CRFs approved by Data Manager (%)</BLOCKQUOTE>", "ar":"<center>0%</center>" , "br":"<center>0%</center>" , "cl":"<center>0%</center>" ,"mxjal":"<center>0%</center>" ,"mxson":"<center>0%</center>" ,"uy":"<center>0%</center>" , "total":"<center>0%</center>" }, { "Parameter":"<b>Number of Participants Off Study</b>", "ar":"<center>8</center>" , "br":"<center>17</center>" , "cl":"<center>21</center>" ,"mxjal":"<center>36</center>" ,"mxson":"<center>17</center>" ,"uy":"<center>10</center>" , "total":"<center>109</center>" }, { "Parameter":"<BLOCKQUOTE> Number of Neoadjuvant Chemotherapy Participants Off Study</BLOCKQUOTE>", "ar":"<center>4</center>" , "br":"<center>9</center>" , "cl":"<center>5</center>" ,"mxjal":"<center>20</center>" ,"mxson":"<center>3</center>" ,"uy":"<center>4</center>" , "total":"<center>45</center>" }, { "Parameter":"<BLOCKQUOTE> Number of Primary Surgery Participants Off Study</BLOCKQUOTE>", "ar":"<center>4</center>" , "br":"<center>8</center>" , "cl":"<center>16</center>" ,"mxjal":"<center>16</center>" ,"mxson":"<center>14</center>" ,"uy":"<center>6</center>" , "total":"<center>64</center>" }, { "Parameter":"<BLOCKQUOTE> Number of Unassigned Participants Off Study</BLOCKQUOTE>", "ar":"<center>0</center>" , "br":"<center>0</center>" , "cl":"<center>0</center>" ,"mxjal":"<center>0</center>" ,"mxson":"<center>0</center>" ,"uy":"<center>0</center>" , "total":"<center>0</center>" }, { "Parameter":"<b>Number of of Participants Currently On-Study</b>", "ar":"<center>159</center>" , "br":"<center>115</center>" , "cl":"<center>56</center>" ,"mxjal":"<center>91</center>" ,"mxson":"<center>47</center>" ,"uy":"<center>70</center>" , "total":"<center>538</center>" }
]
};

var dataStore =
new dojo.data.ItemFileReadStore(
{ data:query99}
);
var grid = dijit.byId("query99");
grid.setStore(dataStore);
});
</script>

</div>

</body>
</html>

Grid not displaying

Developer Shed Advertisers and Affiliates