public function execute($type_report = '', $id_report = '') { $selected_id = ($type_report == "grafico" ? "chart_" : "report_") . $id_report; $this->showDashboard($selected_id); switch ($type_report) { case "relatorio": include "Report.php"; $obj = new Report($id_report); break; case "grafico": include "Chart.php"; $obj = new Chart($id_report); break; } $obj->execute(); }
<div class="col-md-12 col-sm-6"> <?php $chart = new Chart(); $params = array("type" => Chart::CHARTTYPE_LINE); $data = array(); $data["labels"] = array(); $data["datasets"] = array("label" => date('Y'), "fillColor" => "rgba(151,187,205,0.2)", "strokeColor" => "rgba(151,187,205,1)", "pointColor" => "rgba(151,187,205,1)", "pointStrokeColor" => "#fff", "pointHighlightFill" => "#fff", "pointHighlightStroke" => "rgba(151,187,205,1)", "data" => []); $dbobj = $chart->getLoadedModel()->executeQuery("select MONTHNAME(dt_inicio) as month_name, count(id) as job_count\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t FROM easy_trabalhos\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t GROUP BY MONTH(dt_inicio)"); if (count($dbobj->result_array()) > 1) { foreach ($dbobj->result_array() as $row) { $data["labels"][] = $row["month_name"]; $data["datasets"][0]["data"][] = $row["job_count"]; } $params["data"] = json_encode($data); } $chart->execute($params); ?> </div> </div> </div> </div> <div class="col-md-6 col-sm-6"> <div class="ls-box ls-board-box"> <header class="ls-info-header"> <h2 class="ls-title-3 col-md-12 ls-ico-calendar-check"> Aniversáriantes do <span class='birthday-legend-toggle'>dia</span> <!-- <div class='ls-float-right'> <button class='ls-btn ls-tooltip ls-tooltip-left' aria-label='Exibir mês' href='#' data-display_month="false" onClick='$futuri.displayMonthBirthdays(this);'><i class='ls-ico-calendar'></i></button> </div> --> <small>Listagem de aniversáriantes do <span class='birthday-legend-toggle'>dia</span> (casting e usuários do sistema)</small>