while (list($k, $v) = each($_POST["itens2"])) {
$db->executa($db->getAll("catprodutos_itens", "cpi_id={$v}", '', 0), true, "ext");
$campos2 = array("ext_iteid" => $item, "ext_cipid" => $v, "ext_valor" => str_replace(".", ",", $db->ext["cpi_valor"]));
$db->executa($db->insert($campos2, "comanda_itensextra"));
$obs .= $vi . $db->ext["cpi_item"];
$vi = ", ";
}
}
$db->executa($db->update(array("cti_obs" => $obs), "comanda_itens", "cti_id", $item));
$db->commit();
//echo "<script>parent.consulta.location.reload();</script>";
}
if (isset($_POST["btnfecha"])) {
$db->executa("select sum(cti_qtde*pro_preco)+coalesce(sum(ext_valor),0) as vltotal\n\t from comanda_itens inner join produtos on pro_id = cti_proid\n left outer join comanda_itensextra on cti_id = ext_iteid\n\t where cti_comid= " . $_POST["com_id"], true, "vlt");
$db->executa("update comandas set com_vltotal =" . $db->vlt["vltotal"] . " where com_id = " . $_POST["com_id"]);
$nota = new atendimento($_POST["com_id"], $db);
$nota->emite();
echo "<script>parent.location.href='ate_mapamesas.php';</script>";
}
if (isset($_POST["btnexcluir"])) {
$db->executa("delete from comandas where com_id= " . $_POST["com_id"]);
echo "<script>parent.location.href='ate_mapamesas.php';</script>";
}
$form->Makeform("form1", "post", "", "", "", true, "Pedido");
if ($_GET["cli_id"] != '') {
$db->executa($db->getJoinRecord("clientes(+)ruas|cli_ruaid=rua_id\n\t\t (+)bairros|bai_id=cli_baiid", "cli_id=" . $_GET["cli_id"], '', 0), true, "cli");
}
$form->linha(true);
$comanda = $comanda == '' ? $_POST["com_id"] : $comanda;
$form->Append("<input type='hidden' value='" . $comanda . "' name='com_id'>");
$form->Append("<input type='hidden' value='" . $gravado . "' name='gravado'>");
<?php
//require_once("libs/fc_sessoes.php");
require_once "libs/form2.class";
require_once "libs/funcoes.php";
require_once "libs/class_dbgrid.php";
require_once "libs/classes.class";
require_once "libs/class_interface.php";
require "classes/class_atendimento.php";
$db = new db();
$ate = new atendimento(26, $db);
$ate->emite();
