PHP BloqueadaDao::Listar Examples

Example #1

File: index.php Project: hexti/troncal

						
						<table class="table table-bordered table-striped table-condensed">
						  <thead>
							  <tr>
							  	  <td>Medi&ccedil;&atilde;o</td>
							  	  <td>Grupo</td>
								  <th>Estabelecimento</th>
								  <th>NF/Recibo</th>
								  <th>Valor</th>
								  <th>Emp. do Cons&oacute;rcio</th>
								  <th width="15%">A&ccedil;&atilde;o</th>
							  </tr>
						  </thead>   
						  <tbody>
							<?php 
$request = $DAO->Listar();
?>
						  </tbody>
					 </table>             
					</div>
				</div>
			</div>
					
					<!-- content ends -->
			</div><!--/#content.span10-->
				</div><!--/fluid-row-->
				
		<hr>

		<?php 
include_once INTERNAL_ROOT_PORTAL . '/footer.php';

Example #2

File: view.php Project: hexti/troncal

							<table class="table table-bordered table-striped table-condensed">
								  <thead>
									  <tr>
									  	  <td>Medi&ccedil;&atilde;o</td>
									  	  <td>Ref.</td>
									  	  <td>Grupo</td>
										  <th>Estabelecimento</th>
										  <th>Comprovante</th>
										  <th>NF/Recibo</th>
										  <th>Valor</th>
										  <th>Emp. do Cons&oacute;rcio</th>
									  </tr>
								  </thead>   
								  <tbody>
									<?php 
$request = $DAO->Listar("SELECT mai.id, mai.empresa, mai.valor, e.nome, mai.file, mai.moeda, ma.grupo, mai.nf_recibo, ci.grupo, m.ref_inicio, m.id as m_id FROM " . MYSQL_BASE_MEDICAO_ANEXO_ITENS . " mai, " . MYSQL_BASE_CONTRATO_ITEM . " ci, " . MYSQL_BASE_MEDICAO_ITEM . " mi,\r\n\t\t\t\t\t\t\t\t\t\t\t\t" . MYSQL_BASE_EMPRESAS . " e, " . MYSQL_BASE_MEDICAO_ANEXOS . " ma, " . MYSQL_BASE_MEDICAO . " m WHERE m.id = mi.id_medicao AND ci.id = mi.id_contrato_item AND mai.id_medicao_item = mi.id AND mai.status = 'S' \r\n\t\t\t\t\t\t\t\t\t\t\t\tAND e.id = mai.id_empresa AND ma.id = mai.id_medicao_anexo\tAND mai.nf_recibo = " . $anexoItem->getNfRecibo() . " AND mai.id !=" . $anexoItem->getId());
$confirm = "return confirm('Deseja remover esse registro?');";
$total = 0;
$conversao = 0;
$validador = 0;
$valor_iene = 0;
$count = 0;
foreach ($request as $item) {
    $ref_inicio = $item['ref_inicio'];
    $ex = explode("-", $ref_inicio);
    $referencia = "";
    if ($ex[1] == 1) {
        $referencia = "Jan - " . $ex[0];
    }
    if ($ex[1] == 2) {
        $referencia = "Fev - " . $ex[0];