$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'>"); $form->AbreCelula("Item");
<?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();