$render=explode(" ",$_POST["partial_render"]);
if($render[0]=="dropArea"){
$cod = explode(":",$_POST["arrastar_dragId"]);
$cod = $cod[1];
$result = "SELECT * FROM produtos WHERE id_produto="".$cod.""";
$result = $pdo->query($result);
$linha = $result->fetch(PDO::FETCH_ASSOC);
$rslt = $pdo->prepare("INSERT INTO dddtemp (id_produto,codigo,categoria,produto,quantidade) VALUES (:id_produto,:codigo,:categoria,:produto,:quantidade)");
$rslt->bindParam(":id_produto",$linha["id_produto"]);
$rslt->bindParam(":codigo",$linha["codigo"]);
$rslt->bindParam(":categoria",$linha["categoria"]);
$rslt->bindParam(":produto",$linha["produto"]);
$rslt->bindParam(":quantidade",$linha["quantidade"]);
$rslt->execute();
$cesta = array();
$resposta="
<div id="dropArea" class="ui-outputpanel ui-widget">
<div id="selectedProductsTable" class="ui-datatable ui-widget">
<div class="ui-datatable-tablewrapper">
<table role="grid">
<thead id="selectedProductsTable_head">
<tr role="row">
<th class="ui-state-default" role="columnheader" aria-label="Code" scope="col"><span class="ui-column-title">Código</span></th>
<th class="ui-state-default" role="columnheader" aria-label="Name" scope="col"><span class="ui-column-title">Nome</span></th>
<th class="ui-state-default" role="columnheader" aria-label="Category" scope="col"><span class="ui-column-title">Categoria</span></th>
<th class="ui-state-default" role="columnheader" aria-label="Quantity" scope="col"><span class="ui-column-title">Quantidade</span></th>
<th class="ui-state-default" role="columnheader" scope="col" style="width:32px"><span class="ui-column-title"></span></th>
</tr>
</thead>
<tbody id="selectedProductsTable_data" class="ui-datatable-data ui-widget-content">";
$result = "SELECT * FROM dddtemp p INNER JOIN categorias c ON p.categoria=c.id_categoria LIMIT 10";
$result = $pdo->query($result);
while ($linha = $result->fetch(PDO::FETCH_ASSOC)){
$resposta.="
<tr data-ri="".$linha["id_produto"]."" class="ui-widget-content ui-datatable-even" role="row">
<td role="gridcell" class="">".$linha["codigo"]."</td>
<td role="gridcell" class="">".$linha["produto"]."</td>
<td role="gridcell" class="">".$linha["categoria"]."</td>
<td role="gridcell" class="">".$linha["quantidade"]."</td>
<td role="gridcell" style="width:32px" class=""><button id="selectedProductsTable:".$linha["id_produto"]."" name="selectedProductsTable:".$linha["id_produto"]."" class="ui-button ui-widget ui-state-default ui-corner-all ui-button-icon-only" onclick="DinarteCoelho.ab({s:"selectedProductsTable:".$linha["id_produto"]."",f:"productForm",u:"display",onco:function(xhr,status,args,data){DC(\"productDialog\").show();}});return false;" type="submit"><span class="ui-button-icon-left ui-icon ui-c pi pi-search"></span><span class="ui-button-text ui-c">ui-button</span></button>
<script id="selectedProductsTable:".$linha["id_produto"]."_s" type="text/javascript">
DinarteCoelho.cw("CommandButton", "widget_selectedProductsTable_".$linha["id_produto"]."", { id: "selectedProductsTable:".$linha["id_produto"]."" });
</script>
</td>
</tr>";
array_push($cesta, $linha["id_produto"]);
}
$resposta.="
</tbody>
</table>
</div>
</div>
<script id="selectedProductsTable_s" type="text/javascript">
DinarteCoelho.cw("DataTable", "widget_selectedProductsTable", { id: "selectedProductsTable", groupColumnIndexes: [], disableContextMenuIfEmpty: false });
</script>
</div>
";
$resposta1="
<div id="availableProducts" class="ui-datatable ui-widget">
<div class="ui-datatable-tablewrapper">
<table role="grid">
<thead id="availableProducts_head">
<tr role="row">
<th class="ui-state-default" role="columnheader" scope="col" style="width:20px"><span class="ui-column-title"></span></th>
<th class="ui-state-default" role="columnheader" aria-label="Código" scope="col"><span class="ui-column-title">Código</span></th>
<th class="ui-state-default" role="columnheader" aria-label="Nome" scope="col"><span class="ui-column-title">Nome</span></th>
<th class="ui-state-default" role="columnheader" aria-label="Categoria" scope="col"><span class="ui-column-title">Categoria</span></th>
<th class="ui-state-default" role="columnheader" aria-label="Quantidade" scope="col"><span class="ui-column-title">Quantidade</span></th>
</tr>
</thead>
<tbody id="availableProducts_data" class="ui-datatable-data ui-widget-content">";
$in_values = implode(",", $cesta);
$result = "SELECT * FROM produtos p INNER JOIN categorias c ON p.categoria=c.id_categoria WHERE p.id_produto NOT IN ($in_values) LIMIT 10";
$result = $pdo->query($result);
while ($dados = $result->fetch(PDO::FETCH_ASSOC)){
$resposta1.="
<tr data-ri="".$dados["id_produto"]."" class="ui-widget-content ui-datatable-even" role="row">
<td role="gridcell" style="width:20px" class=""><span id="availableProducts:".$dados["id_produto"].":dragIcon" class="ui-icon pi pi-plus"></span>
<div id="availableProducts:".$dados["id_produto"]."" style="display: none;"></div>
<script id="availableProducts:".$dados["id_produto"]."_s" type="text/javascript">
DinarteCoelho.cw("Draggable", "widget_availableProducts_".$dados["id_produto"]."", { id: "availableProducts:".$dados["id_produto"]."", target: "availableProducts:".$dados["id_produto"].":dragIcon", cursor: "crosshair", helper: "clone", revert: "invalid" });
</script>
</td>
<td role="gridcell" class="">".$dados["codigo"]."</td>
<td role="gridcell" class="">".$dados["produto"]."</td>
<td role="gridcell" class="">".$dados["categoria"]."</td>
<td role="gridcell" class="">".$dados["quantidade"]."</td>
</tr>";
}
$resposta1.="
</tbody>
</table>
</div>
</div>
<script id="availableProducts_s" type="text/javascript">
DinarteCoelho.cw("DataTable", "widget_availableProducts", { id: "availableProducts", groupColumnIndexes: [], disableContextMenuIfEmpty: false });
</script>
";
}
if($render[0]=="display"){
$cod=explode(":",$_POST["source"]);
$cod=$cod[1];
$result = "SELECT * FROM produtos p INNER JOIN categorias c ON p.categoria=c.id_categoria INNER JOIN estoque e ON p.estoque=e.id_estoque WHERE p.id_produto="".$cod.""";
$result = $pdo->query($result);
$dados = $result->fetch(PDO::FETCH_ASSOC);
$avaliacao="";
for ($i = 1; $i <= 5; $i++) { $avaliacao.="<div class="ui-rating-star"; if($i<$dados["avaliacoes"]){ $avaliacao.= " ui-rating-star-on";} $avaliacao.=""><a></a></div>"; }
$resposta="
<div id="display" class="ui-outputpanel ui-widget">
<div class="product">
<div class="product-grid-item card" style="margin-bottom: 0">
<div class="product-grid-item-top">
<div>
<i class="pi pi-tag product-category-icon"></i>
<span class="product-category">".$dados["categoria"]."</span>
</div>
<span class="product-badge status-lowstock">".$dados["estoque"]."</span>
</div>
<div class="product-grid-item-content"><img src="/sistema/resource/demo/images/product/".$dados["foto"].".jpg" alt="" />
<div class="product-name">".$dados["produto"]."</div>
<div class="product-description">".$dados["descricao"]."</div>
<div id="votos" class="ui-rating">
<div class="ui-helper-hidden-accessible"><input id="votos_input" name="votos_input" type="text" autocomplete="off" value="3" tabindex="0" role="slider" aria-valuemin="1" aria-valuemax="5" aria-valuenow="3" /></div>
".$avaliacao."
</div>
<script id="votos_s" type="text/javascript">
DinarteCoelho.cw("Rating", "widget_votos", {
id: "votos",
readonly: true
});
</script>
</div>
<div class="product-grid-item-bottom"><span class="product-price">R$ ".$dados["preco"].",00</span>
<button id="BtnAdicionar" name="BtnAdicionar" class="ui-button ui-widget ui-state-default ui-corner-all ui-button-text-icon-left" onclick="DinarteCoelho.ab({s:"BtnAdicionar",f:"productForm"});return false;" type="submit"><span class="ui-button-icon-left ui-icon ui-c pi pi-shopping-cart"></span><span class="ui-button-text ui-c">Adicinar</span></button>
<script id="BtnAdicionar_s" type="text/javascript">
DinarteCoelho.cw("CommandButton", "widget_BtnAdicionar", {
id: "BtnAdicionar"
});
</script>
</div>
</div>
</div>
</div>
";
}
dc.cw("Draggable", "widget_availableProducts", {
id: "availableProducts",
target: "availableProducts:dragIcon",
cursor: "crosshair",
helper: "clone",
revert: "invalid"
});
dc.cw("DataTable", "widget_availableProducts", {
id: "availableProducts",
groupColumnIndexes: [],
disableContextMenuIfEmpty: false
});
dc.cw("Fieldset", "widget_selectedProducts", {
id: "selectedProducts"
});
dc.cw("Droppable", "widget_arrastar", {
id: "arrastar",
target: "selectedProducts",
activeClass: "ui\-state\-highlight",
tolerance: "touch",
onDrop: handleDrop,
behaviors: {
drop: function(ext, event) {
dc.ab({
s: "arrastar",
e: "drop",
f: "productForm",
p: "arrastar",
u: "dropArea availableProducts"
}, ext);
}
}
});
dc.cw("Dialog", "productDialog", {
id: "painel",
draggable: false,
resizable: false,
modal: true,
showEffect: "fade",
hideEffect: "fade"
});