I'm doing on my page of my client, which I assumed from another developer, a section to search for events registered in the MySQL database. How is this page:
<div id="detalhesBusca" class="textDescricaoSobre font13" style="display: none">
<b>BUSCA DE EVENTO</b><br><br>
<div class="BoxForm1"><span class="titNomeInputs"><b>Digite o número do evento:</b></span>
<div class="inputMGM">
<input name="buscaNumero" id="buscaNumero" class="validate[required]" title=""></input>
</div>
<input id="buscaNoBanco" name="buscaNoBanco" type="button" class="textDescricaoSobre font13" value="Buscar Evento" onclick="buscaBanco(document.getElementById('buscaNumero').value);" style="cursor: pointer; width: 93px;" />
</div>
<div id="resultadoBusca" class="textDescricaoSobre font13" style="display: none">
<b>RESULTADO DA BUSCA</b><br><br>
<i>Código:</i> <label id="resultCodigo"></label><br>
<i>Modelo:</i> <label id="resultModelo"></label><br>
<i>Evento:</i> <label id="resultEvento"></label><br>
<i>Local:</i> <label id="resultLocal"></label><br>
<i>Data e Hora:</i> <label id="resultData"></label> <label id="resultHora"></label><br>
<i>Carga Horária:</i> <label id="resultCarga"></label><br>
<i>Conteúdos Abordados:</i> <label id="resultConteudos"></label><br>
<i>Indicadores de Performance:</i> <label id="resultIndicadores"></label><br>
<i>Materiais:</i> <label id="resultMateriais"></label><br>
<i>Facilitadores: </i> <label id="resultFacilitadores"></label><br>
<i>Lista de Presença: <label id="resultLista"></label></i>
</div>
<label id="voltaMenu2" class="SpaceEnviar" style="cursor: pointer; decoration: underline">VOLTAR AO MENU INICIAL</label>
</div>
SearchBank has been defined as follows:
function buscaBanco(numero){
if (numero == '') {
alert('Nenhum resultado encontrado!');
$('#resultadoBusca').hide();
}
else {
// Executa a consulta SQL. Se houver resultado, mostra na tela
$('#resultadoBusca').show();
<?php
// class_exists('Servico') || include_once CLASS_PATH . 'Servico.class.php';
$data['evento'] = Servico::getRetornosEventos();
$event = $data['evento'];
?>
document.getElementById('resultCodigo').textContent = <?php echo $event['id'] ?>
document.getElementById('resultModelo').textContent = <?php echo $event['modelonome'] ?>
document.getElementById('resultEvento').textContent = <?php echo $event['evento'] ?>
document.getElementById('resultLocal').textContent = <?php echo $event['localevento'] ?>
document.getElementById('resultData').textContent = <?php echo $event['dataevento'] ?>
document.getElementById('resultHora').textContent = <?php echo $event['horaevento'] ?>
document.getElementById('resultCarga').textContent = <?php echo $event['cargahoraria'] ?>
document.getElementById('resultConteudos').textContent = <?php echo $event['conteudos'] ?>
document.getElementById('resultIndicadores').textContent = <?php echo $event['indicadores'] ?>
document.getElementById('resultMateriais').textContent = <?php if($event['chkapostila']=='1'){ echo "Apostila"; } else { echo "Nenhum"; } ?>
document.getElementById('resultFacilitadores').textContent = <?php if($event['facilitadores']=='Externos'){ echo $event['externosnomes']; } else { echo $event['internosnomes']; } ?>
document.getElementById('resultLista').textContent = <?php echo $event['listapresenca'] ?>
}
}
And the getReturnEvent () function that gets in the servic.class.php file (with doctrine query) works like this:
public static function getRetornosEventos(){
return self::$evento = self::setRetornosEventos();
}
public static function setRetornosEventos(){
$sql = Doctrine_Query::create()
->select('e.id,u.nome AS usuarionome,
(CASE WHEN modelo = 1 THEN "Sala de Aula"
WHEN modelo = 2 THEN "On The Job"
WHEN modelo = 3 THEN "Palestra"
WHEN modelo = 4 THEN "Workshop"
WHEN modelo = 5 THEN "Programas Institucionais"
WHEN modelo = 6 THEN "Outro" ELSE modelo END) as modelonome,
(CASE WHEN programa = 1 THEN "Eu Faço Parte"
WHEN programa = 2 THEN "PDG"
WHEN programa = 3 THEN "PDL Unidades"
WHEN programa = 4 THEN "PDL Corporativo"
WHEN programa = 5 THEN "Jeito de Ser" ELSE programa END) as programa,
outromodelo,evento,localevento,DATE_FORMAT(dataevento, "%d/%m/%Y") as dataevento,horaevento,
cargahoraria,conteudos,indicadores,chkapostila,chkcopia,chkoutro,chknenhum,outromaterial,
(CASE WHEN facilitadores = "E" THEN "Externos"
WHEN facilitadores = "I" THEN "Internos" ELSE facilitadores END) as facilitadores,
externosnomes,externosempresas,internosnomes,internosempresas,listapresenca')
->from('WtEducEventos e')
->addFrom('WtUsuario u')
->where('e.usua_id = u.id')
->addWhere('e.id = ' . $_POST['buscaNumero']);
$data = $sql->fetchArray();
return $data;
}
However, the page is unconfigured and is not possible to test the search. What could be wrong? Any semicolons missing in the SearchBank function? Is the Class_Exists declaration (usually in Controller files) mandatory in this case? Or suddenly some error in blending PHP in java script or even with the SQL query (doctrine query).
I accept aids and suggestions.