PHP ewrpt_SortChartData Examples

Example #1

File: Report20smry.php Project: asmirasurianie/xaminer-v10

    $Report20->Chart1->SetChartParam("showAlternateVGridColor", "0", TRUE);
    // showAlternateVGridColor
    $Report20->Chart1->SetChartParam("hoverCapSepChar", ":", TRUE);
    // hoverCapSepChar
    // Define trend lines
    $SqlSelect = $Report20->SqlSelect();
    $SqlChartSelect = $Report20->Chart1->SqlSelect;
    $sSqlChartBase = "(" . ewrpt_BuildReportSql($SqlSelect, $Report20->SqlWhere(), $Report20->SqlGroupBy(), $Report20->SqlHaving(), $Report20->SqlOrderBy(), $Report20_summary->Filter, "") . ") EW_TMP_TABLE";
    // Load chart data from sql directly
    $sSql = $SqlChartSelect . $sSqlChartBase;
    $sSql = ewrpt_BuildReportSql($sSql, "", $Report20->Chart1->SqlGroupBy, "", $Report20->Chart1->SqlOrderBy, "", "");
    if (EWRPT_DEBUG_ENABLED) {
        echo "(Chart SQL): " . $sSql . "<br>";
    }
    ewrpt_LoadChartData($sSql, $Report20->Chart1);
    ewrpt_SortChartData($Report20->Chart1->Data, 0, "");
    // Call Chart_Rendering event
    $Report20->Chart_Rendering($Report20->Chart1);
    $chartxml = $Report20->Chart1->ChartXml();
    // Call Chart_Rendered event
    $Report20->Chart_Rendered($Report20->Chart1, $chartxml);
    echo $Report20->Chart1->ShowChartFCF($chartxml);
    ?>
<a href="#top"><?php 
    echo $ReportLanguage->Phrase("Top");
    ?>
</a>
<br /><br />
<?php 
}
if ($Report20->Export == "") {

Example #2

File: Report11smry.php Project: asmirasurianie/xaminer-v10

    $Report11->Time_Taken->SetChartParam("showAlternateVGridColor", "0", TRUE);
    // showAlternateVGridColor
    $Report11->Time_Taken->SetChartParam("hoverCapSepChar", ":", TRUE);
    // hoverCapSepChar
    // Define trend lines
    $SqlSelect = $Report11->SqlSelect();
    $SqlChartSelect = $Report11->Time_Taken->SqlSelect;
    $sSqlChartBase = "(" . ewrpt_BuildReportSql($SqlSelect, $Report11->SqlWhere(), $Report11->SqlGroupBy(), $Report11->SqlHaving(), $Report11->SqlOrderBy(), $Report11_summary->Filter, "") . ") EW_TMP_TABLE";
    // Load chart data from sql directly
    $sSql = $SqlChartSelect . $sSqlChartBase;
    $sSql = ewrpt_BuildReportSql($sSql, "", $Report11->Time_Taken->SqlGroupBy, "", $Report11->Time_Taken->SqlOrderBy, "", "");
    if (EWRPT_DEBUG_ENABLED) {
        echo "(Chart SQL): " . $sSql . "<br>";
    }
    ewrpt_LoadChartData($sSql, $Report11->Time_Taken);
    ewrpt_SortChartData($Report11->Time_Taken->Data, 0, "");
    // Call Chart_Rendering event
    $Report11->Chart_Rendering($Report11->Time_Taken);
    $chartxml = $Report11->Time_Taken->ChartXml();
    // Call Chart_Rendered event
    $Report11->Chart_Rendered($Report11->Time_Taken, $chartxml);
    echo $Report11->Time_Taken->ShowChartFCF($chartxml);
    ?>
<a href="#top"><?php 
    echo $ReportLanguage->Phrase("Top");
    ?>
</a>
<br /><br />
<?php 
}
if ($Report11->Export == "") {

Example #3

File: Report16smry.php Project: asmirasurianie/xaminer-v10

    $Report16->Result->SetChartParam("showAlternateVGridColor", "0", TRUE);
    // showAlternateVGridColor
    $Report16->Result->SetChartParam("hoverCapSepChar", ":", TRUE);
    // hoverCapSepChar
    // Define trend lines
    $SqlSelect = $Report16->SqlSelect();
    $SqlChartSelect = $Report16->Result->SqlSelect;
    $sSqlChartBase = "(" . ewrpt_BuildReportSql($SqlSelect, $Report16->SqlWhere(), $Report16->SqlGroupBy(), $Report16->SqlHaving(), $Report16->SqlOrderBy(), $Report16_summary->Filter, "") . ") EW_TMP_TABLE";
    // Load chart data from sql directly
    $sSql = $SqlChartSelect . $sSqlChartBase;
    $sSql = ewrpt_BuildReportSql($sSql, "", $Report16->Result->SqlGroupBy, "", $Report16->Result->SqlOrderBy, "", "");
    if (EWRPT_DEBUG_ENABLED) {
        echo "(Chart SQL): " . $sSql . "<br>";
    }
    ewrpt_LoadChartData($sSql, $Report16->Result);
    ewrpt_SortChartData($Report16->Result->Data, 0, "");
    // Call Chart_Rendering event
    $Report16->Chart_Rendering($Report16->Result);
    $chartxml = $Report16->Result->ChartXml();
    // Call Chart_Rendered event
    $Report16->Chart_Rendered($Report16->Result, $chartxml);
    echo $Report16->Result->ShowChartFCF($chartxml);
    ?>
<a href="#top"><?php 
    echo $ReportLanguage->Phrase("Top");
    ?>
</a>
<br /><br />
<?php 
}
if ($Report16->Export == "") {

Example #4

File: Report10smry.php Project: asmirasurianie/xaminer-v10

    $Report10->Time_Taken_by_each_student->SetChartParam("showAlternateVGridColor", "0", TRUE);
    // showAlternateVGridColor
    $Report10->Time_Taken_by_each_student->SetChartParam("hoverCapSepChar", ":", TRUE);
    // hoverCapSepChar
    // Define trend lines
    $SqlSelect = $Report10->SqlSelect();
    $SqlChartSelect = $Report10->Time_Taken_by_each_student->SqlSelect;
    $sSqlChartBase = "(" . ewrpt_BuildReportSql($SqlSelect, $Report10->SqlWhere(), $Report10->SqlGroupBy(), $Report10->SqlHaving(), $Report10->SqlOrderBy(), $Report10_summary->Filter, "") . ") EW_TMP_TABLE";
    // Load chart data from sql directly
    $sSql = $SqlChartSelect . $sSqlChartBase;
    $sSql = ewrpt_BuildReportSql($sSql, "", $Report10->Time_Taken_by_each_student->SqlGroupBy, "", $Report10->Time_Taken_by_each_student->SqlOrderBy, "", "");
    if (EWRPT_DEBUG_ENABLED) {
        echo "(Chart SQL): " . $sSql . "<br>";
    }
    ewrpt_LoadChartData($sSql, $Report10->Time_Taken_by_each_student);
    ewrpt_SortChartData($Report10->Time_Taken_by_each_student->Data, 0, "");
    // Call Chart_Rendering event
    $Report10->Chart_Rendering($Report10->Time_Taken_by_each_student);
    $chartxml = $Report10->Time_Taken_by_each_student->ChartXml();
    // Call Chart_Rendered event
    $Report10->Chart_Rendered($Report10->Time_Taken_by_each_student, $chartxml);
    echo $Report10->Time_Taken_by_each_student->ShowChartFCF($chartxml);
    ?>
<a href="#top"><?php 
    echo $ReportLanguage->Phrase("Top");
    ?>
</a>
<br /><br />
<?php 
}
if ($Report10->Export == "") {

Example #5

File: Report19smry.php Project: asmirasurianie/xaminer-v10

    $Report19->Chart2->SetChartParam("showAlternateVGridColor", "0", TRUE);
    // showAlternateVGridColor
    $Report19->Chart2->SetChartParam("hoverCapSepChar", ":", TRUE);
    // hoverCapSepChar
    // Define trend lines
    $SqlSelect = $Report19->SqlSelect();
    $SqlChartSelect = $Report19->Chart2->SqlSelect;
    $sSqlChartBase = "(" . ewrpt_BuildReportSql($SqlSelect, $Report19->SqlWhere(), $Report19->SqlGroupBy(), $Report19->SqlHaving(), $Report19->SqlOrderBy(), $Report19_summary->Filter, "") . ") EW_TMP_TABLE";
    // Load chart data from sql directly
    $sSql = $SqlChartSelect . $sSqlChartBase;
    $sSql = ewrpt_BuildReportSql($sSql, "", $Report19->Chart2->SqlGroupBy, "", $Report19->Chart2->SqlOrderBy, "", "");
    if (EWRPT_DEBUG_ENABLED) {
        echo "(Chart SQL): " . $sSql . "<br>";
    }
    ewrpt_LoadChartData($sSql, $Report19->Chart2);
    ewrpt_SortChartData($Report19->Chart2->Data, 0, "");
    // Call Chart_Rendering event
    $Report19->Chart_Rendering($Report19->Chart2);
    $chartxml = $Report19->Chart2->ChartXml();
    // Call Chart_Rendered event
    $Report19->Chart_Rendered($Report19->Chart2, $chartxml);
    echo $Report19->Chart2->ShowChartFCF($chartxml);
    ?>
<a href="#top"><?php 
    echo $ReportLanguage->Phrase("Top");
    ?>
</a>
<br /><br />
<?php 
}
if ($Report19->Export == "") {

Example #6

File: Report18smry.php Project: asmirasurianie/xaminer-v10

    $Report18->No_of_students_attended_exams->SetChartParam("showAlternateVGridColor", "0", TRUE);
    // showAlternateVGridColor
    $Report18->No_of_students_attended_exams->SetChartParam("hoverCapSepChar", ":", TRUE);
    // hoverCapSepChar
    // Define trend lines
    $SqlSelect = $Report18->SqlSelect();
    $SqlChartSelect = $Report18->No_of_students_attended_exams->SqlSelect;
    $sSqlChartBase = "(" . ewrpt_BuildReportSql($SqlSelect, $Report18->SqlWhere(), $Report18->SqlGroupBy(), $Report18->SqlHaving(), $Report18->SqlOrderBy(), $Report18_summary->Filter, "") . ") EW_TMP_TABLE";
    // Load chart data from sql directly
    $sSql = $SqlChartSelect . $sSqlChartBase;
    $sSql = ewrpt_BuildReportSql($sSql, "", $Report18->No_of_students_attended_exams->SqlGroupBy, "", $Report18->No_of_students_attended_exams->SqlOrderBy, "", "");
    if (EWRPT_DEBUG_ENABLED) {
        echo "(Chart SQL): " . $sSql . "<br>";
    }
    ewrpt_LoadChartData($sSql, $Report18->No_of_students_attended_exams);
    ewrpt_SortChartData($Report18->No_of_students_attended_exams->Data, 0, "");
    // Call Chart_Rendering event
    $Report18->Chart_Rendering($Report18->No_of_students_attended_exams);
    $chartxml = $Report18->No_of_students_attended_exams->ChartXml();
    // Call Chart_Rendered event
    $Report18->Chart_Rendered($Report18->No_of_students_attended_exams, $chartxml);
    echo $Report18->No_of_students_attended_exams->ShowChartFCF($chartxml);
    ?>
<a href="#top"><?php 
    echo $ReportLanguage->Phrase("Top");
    ?>
</a>
<br /><br />
<?php 
}
if ($Report18->Export == "") {

Example #7

File: Report1smry.php Project: asmirasurianie/xaminer-v10

    $Report1->Student_Pie_Chart->SetChartParam("showAlternateVGridColor", "0", TRUE);
    // showAlternateVGridColor
    $Report1->Student_Pie_Chart->SetChartParam("hoverCapSepChar", ":", TRUE);
    // hoverCapSepChar
    // Define trend lines
    $SqlSelect = $Report1->SqlSelect();
    $SqlChartSelect = $Report1->Student_Pie_Chart->SqlSelect;
    $sSqlChartBase = "(" . ewrpt_BuildReportSql($SqlSelect, $Report1->SqlWhere(), $Report1->SqlGroupBy(), $Report1->SqlHaving(), $Report1->SqlOrderBy(), $Report1_summary->Filter, "") . ") EW_TMP_TABLE";
    // Load chart data from sql directly
    $sSql = $SqlChartSelect . $sSqlChartBase;
    $sSql = ewrpt_BuildReportSql($sSql, "", $Report1->Student_Pie_Chart->SqlGroupBy, "", $Report1->Student_Pie_Chart->SqlOrderBy, "", "");
    if (EWRPT_DEBUG_ENABLED) {
        echo "(Chart SQL): " . $sSql . "<br>";
    }
    ewrpt_LoadChartData($sSql, $Report1->Student_Pie_Chart);
    ewrpt_SortChartData($Report1->Student_Pie_Chart->Data, 0, "");
    // Call Chart_Rendering event
    $Report1->Chart_Rendering($Report1->Student_Pie_Chart);
    $chartxml = $Report1->Student_Pie_Chart->ChartXml();
    // Call Chart_Rendered event
    $Report1->Chart_Rendered($Report1->Student_Pie_Chart, $chartxml);
    echo $Report1->Student_Pie_Chart->ShowChartFCF($chartxml);
    ?>
<a href="#top"><?php 
    echo $ReportLanguage->Phrase("Top");
    ?>
</a>
<br /><br />
<?php 
}
if ($Report1->Export == "") {