Obter dados de 2 tabelas em forms diferentes automaticamente
Seguinte galera, meu conhecimento em PHP é de iniciante. Faz dias que tento resolver essa questão.
Preciso obter dados da tabela 1 no form 1 e tabela 2 no form 2, isto é, na mesma pagina.
Atualmente para eu obter dados do segundo form, preciso clicar no botão.
Segue meu script:
<script type="application/javascript" language="javascript" src="../../../assets/js/mascaras.js"></script>
<html>
<link rel="stylesheet" href="<?php echo base_url();?>assets/js/jquery-ui/css/smoothness/jquery-ui-1.9.2.custom.css" />
<script type="text/javascript" src="<?php echo base_url()?>assets/js/jquery-ui/js/jquery-ui-1.9.2.custom.js"></script>
<script type="text/javascript" src="<?php echo base_url()?>assets/js/jquery.validate.js"></script>
<div class="form-actions">
<div class="span12" style="padding: 1%; margin-left: 0;">
<div class="widget-box">
<div class="widget-title">
<span class="icon">
<i class="icon-tags"></i>
</span>
<input id="idtiOS2" class="span2" type="hidden" name="idtiOS2" value="<?php echo $result->idtiOs ?>" />
<?php echo form_hidden('idtiOs',$result->idtiOs) ?> <h5>Edição TI OS: <?php echo $result->idtiOs ?></h5>
</div>
<div class="widget-content nopadding">
<?php if($custom_error == true){ ?>
<div class="span12 alert alert-danger" id="divInfo" style="padding: 1%;">Dados incompletos, verifique os campos.</div>
<?php } ?>
<form action="<?php echo current_url(); ?>" method="post" id="formTIOs">
<div class="span12" style="padding: 1%; margin-left: 0;">
<table cellpadding="5%" cellspacing="5%" border="0" align="center" width="100%" bgcolor="#E97F02">
<tbody>
<tr>
<td>
<input id="dataInicial" disabled="disabled" class="span1 datepicker" type="text" name="dataInicial" value="<?php echo date(('d/m/Y'),strtotime($result->dataInicial)) ?>" />
<input id="horaInicial" disabled="disabled" class="span1" type="text" name="horaInicial" onKeyPress="mascara(this, '##:##')" maxlength="5" value="<?php echo $result->horaInicial?>" />
</td>
</tr>
<tr>
<td>
<input id="equipamento" disabled="disabled" class="span6" type="text" name="equipamento" value="<?php echo $result->patEquip ?>" />
<input id="equipamentos_id" class="span2" type="hidden" name="equipamentos_id" value="<?php echo $result->equipamentos_id ?>" />
<input id="cliente_id" disabled="disabled" class="span2" type="hidden" name="cliente_id" value="<?php echo $result->clientes_id ?>" />
<input id="setor_id" disabled="disabled" class="span2" type="hidden" name="setor_id" value="<?php echo $result->setor_id ?>" />
</td>
</tr>
<tr>
<td>
<input id="tecnico" disabled="disabled" class="span2" type="text" name="tecnico" value="<?php echo $result->nome ?>" />
<input id="usuarios_id" disabled="disabled" class="span2" type="hidden" name="usuarios_id" value="<?php echo $result->usuarios_id ?>" />
</td>
</tr>
<tr>
<td>
<input id="solicitante" disabled="disabled" class="span2" type="text" name="solicitante" value="<?php echo $result->solicitante ?>" />
</td>
</tr>
<tr>
<td>
<textarea class="span4" disabled="disabled" name="defeito" id="defeito" cols="70" rows="3"><?php echo $result->defeito ?></textarea>
<textarea class="span4" disabled="disabled" name="laudoTecnico" id="laudoTecnico" cols="70" rows="3"><?php echo $result->laudoTecnico ?></textarea>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
<!--Obtem dados da tabela serviços-->
<form method="get" id="formauto" name="formauto" action="<?php echo base_url(); ?>index.php/tios/editar/<?php echo $result->idtiOs; ?>">
<table cellpadding="5%" cellspacing="5%" border="0" align="center" width="100%" bgcolor="#E97F02">
<tr>
<td>
<input type="text" name="idserv" id="idserv" placeholder="idserver" class="" value="<?php echo $result->idtiOs; ?>">
<button onclick="submeter" class="span4 btn"> <i class="icon-search"></i> </button>
</td>
</tr>
</table>
</form>
<div class="row-fluid" style="margin-top: 0">
<div class="span12" style="margin-left: 0">
<div class="widget-box">
<div class="widget-title"><span class="icon"><i class="icon-signal"></i></span><h5>TIOS Em Aberto</h5></div>
<div class="widget-content">
<table class="table table-bordered">
<thead>
<tr>
<th>#</th>
<th>Data</th>
<th>Hora</th>
<th>Descrição</th>
<th>Status</th>
<th>Atendimento</th>
<th></th>
</tr>
</thead>
<tbody>
<?php
if($funtios != null){
foreach ($funtios as $t) {
echo '<tr>';
echo '<td>'.$t->idServicos.'</td>';
echo '<td>'.$t->dataServicos.'</td>';
echo '<td>'.$t->horaServicos.'</td>';
echo '<td>'.$t->descricaoServicos.'</td>';
echo '<td>'.$t->statusServicos.'</td>';
echo '<td>'.$t->tipoatendimentoServicos.'</td>';
echo '<td>';
if($this->permission->checkPermission($this->session->userdata('permissao'),'vtiOs')){
echo '<a href="'.base_url().'index.php/tios/visualizar/'.$t->idtiOs.'" class="btn"> <i class="icon-eye-open" ></i> </a> ';
}
echo '</td>';
echo '</tr>';
}
}
else{
echo '<tr><td colspan="3">Nenhuma tios em aberto.</td></tr>';
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>Discussão (2)
Carregando comentários...