#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2013
    Posts
    5
    Rep 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');
        
    $res1pg_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
  2. #2
  3. --
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Jul 2012
    Posts
    3,957
    Rep Power
    1046
    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 ē How to (properly) access a MySQL database with PHP

    Why canít I use certain words like "drop" as part of my Security Question answers?
    There are certain words used by hackers to try to gain access to systems and manipulate data; therefore, the following words are restricted: "select," "delete," "update," "insert," "drop" and "null".
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2013
    Posts
    5
    Rep 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?





    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.
  6. #4
  7. --
    Devshed Expert (3500 - 3999 posts)

    Join Date
    Jul 2012
    Posts
    3,957
    Rep Power
    1046
    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.



    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).
    The 6 worst sins of security ē How to (properly) access a MySQL database with PHP

    Why canít I use certain words like "drop" as part of my Security Question answers?
    There are certain words used by hackers to try to gain access to systems and manipulate data; therefore, the following words are restricted: "select," "delete," "update," "insert," "drop" and "null".
  8. #5
  9. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2013
    Posts
    5
    Rep 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><!--Subjects Enrolled to Unassigned Arm--></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>

IMN logo majestic logo threadwatch logo seochat tools logo