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);
}
