if ($acao == 'inserirCor') { if ($idCor == '') { $sql = "INSERT INTO `Cor` (`idCor`,`nome`) VALUES (NULL,'{$nomeCor}')"; $query = mysql_query($sql); } else { $sql = "UPDATE Cor SET nome='{$nomeCor}' WHERE idCor={$idCor}"; $query = mysql_query($sql); } listarCor(); } else { if ($acao == 'excluirCor') { if ($idCategoria != '') { $sql = "DELETE FROM Cor WHERE idCor='{$idCor}'"; $query = mysql_query($sql); } listarCor(); } else { if ($acao == 'verCores') { $sql = "SELECT * FROM Cor ORDER BY nome ASC"; $query = mysql_query($sql); echo "<table class='responsive-table highlight'>"; echo "<thead><tr>"; echo "<th data-field='nome'>Cor</th>"; echo "<th>Editar</th>"; echo "<th>Excluir</th>"; echo "</tr></thead>"; echo "<tbody>"; while ($temp = mysql_fetch_assoc($query)) { echo "<tr>"; echo "<td>{$temp['nome']}</td>"; echo "<td><a href='#' class='editarCor waves-effect waves-light' idCor='{$temp['idCor']}'><i class='material-icons right'>settings</i></a></td>";
/** * LISTA GRADE. */ function listarGrade($aDados) { $tjax = new Tjax(); $fg = new FrameworkGeneric(); $fg->config(""); $host = $fg->host; $html = '<div class="row padding-0"> <div class="col-lg-3 margin-bottom-10"> <label>Cor</label> <select id="cor_' . $aDados['ofe_id'] . '" name="cor[]" data-live-search="true" class="form-control selectpicker"> </select> </div> <div class="col-lg-3 margin-bottom-10"> <label>Tamanho</label> <select id="tamanho_' . $aDados['ofe_id'] . '" name="tam[]" data-live-search="true" class="form-control selectpicker"> </select> </div> <div class="col-lg-1 margin-bottom-10"> <label>Quant.</label> <input id="quantidade_' . $aDados['ofe_id'] . '" name="quant[]" type="text" value="" class="form-control" /> <input id="id_' . $aDados['ofe_id'] . '" name="idItem[]" type="hidden" value="" class="form-control" /> </div> </div>'; $tjax->addScript("\$('#template_grade').append('" . $html . "');"); $tjax->display(); listarTamanho($aDados); listarCor($aDados); }