<?php 
require_once("../../../../../config.php");

require_once("$CFG->dirroot/local/badiunetclient/lib/locallib.php");
require_once("$CFG->dirroot/local/badiunetclient/lib/freport.php");
require_once("$CFG->dirroot/local/badiunet/lib/netlib.php"); //review  call it by factorycontent
require_login();


$netlib=new local_badiunet_netlib(); //instanciar a classe
$page = optional_param('page',0,PARAM_INT); //receber parametro de paginacao
$fc=new local_badiunetclient_locallib(); //instanciar a classe de API
$fc->addParamdefault('_key','badiu.system.core.report.dynamicp.index'); //parametro da chave de relatorio dinamico
$fc->addParamdefault('_dkey','badiu.moodle.mreport.grade.grade.index'); //parametro da chave do relatorio
$fc->addParamdefault('_datasource','servicesql'); //parametro padrao da fonte de dados
$fc->addParamdefault('parentid',$netlib->getModuleInstance()); // parametro de instancia do Moodle registrado na plataforma de servico
$fc->addParamdefault('_page',$page); //parametro de paginacao
$fc->exec();  //execucao de consulta
 
function makeTable($data) {
    $utildata=new local_badiunet_utildata();
    $table        = new html_table();
    $columns=$utildata->getVaueOfArray($data, 'message.content.badiu_table1.columns', true);
    $rows=$utildata->getVaueOfArray($data, 'message.content.badiu_table1.rows', true);
     $rowsviews=array();
     if(is_array($rows) && is_array($columns)){
       foreach ($rows as $row){         
         $newrow=array();
		foreach ($columns as $kc => $vc){
			$rkvalue=$utildata->getVaueOfArray($row, $kc);
            $newrow[$kc]=$rkvalue;
         }
         array_push($rowsviews,$newrow);
      }
    }
    $table->head =$columns;
    $table->data=$rowsviews;
    return html_writer::table($table);
 }


function pagingReport($data){
   global $OUTPUT,$CFG;
   $utildata=new local_badiunet_utildata();
   $pageindex=$utildata->getVaueOfArray($data,'message.content.badiu_table1.pageindex', true);
   $countrow=$utildata->getVaueOfArray($data,'message.content.badiu_table1.countrow', true);
   $pagemaxrow=$utildata->getVaueOfArray($data,'message.content.badiu_table1.pagemaxrow', true);
   $url=$CFG->httpswwwroot.'/local/badiunetclient/examples/mreport/grade/general.php';
  echo  $OUTPUT->paging_bar($countrow, $pageindex,$pagemaxrow, $url);
}

$PAGE->set_context($context);
$PAGE->set_url('/local/badiunetclient/fcservice/index.php');
$PAGE->set_pagelayout('standard');
$PAGE->set_title('Relatorio de nota');
$PAGE->set_heading('Relatorio de nota');
$PAGE->navbar->add("Relatorio de nota", new moodle_url($CFG->httpswwwroot.'/local/badiunetclient/examples/mreport/grade/general.php'));
echo $OUTPUT->header();

pagingReport($fc->getContent());
echo makeTable($fc->getContent());
pagingReport($fc->getContent());

echo $OUTPUT->footer();


?>