* impressão * * Mostra o total já registrado * SELECT SUM(amount*labels) AS qtd, SUM(netweight*labels) AS peso FROM `movements` WHERE `op_id`='67450' */ use Webetiq\DBase\DBase; use Webetiq\Ops; use Webetiq\Movements; use Webetiq\Labels\Label; use Webetiq\Printers; use Webetiq\Units; $config = json_encode(['host' => 'localhost', 'user' => 'root', 'pass' => 'monitor5', 'db' => 'blabel']); $dbase = new DBase($config); $oPrinters = new Printers($dbase); $oOPs = new Ops($dbase); $oMovements = new Movements($dbase); $oUnits = new Units($dbase); $lbl = new Label(); $remoteip = $_SERVER['REMOTE_ADDR']; $numop = filter_input(INPUT_POST, 'numop', FILTER_SANITIZE_STRING); $copias = 1; $emissao = date('d/m/Y'); //carrega impressoras $aPrint = $oPrinters->all(); $selPrintGroup = '<div class="form-group"><label for=\\"printer\\">Selecione a impressora</label><select class="form-control" name="printer">'; foreach ($aPrint as $printer) { $selp = ''; if ($printer->name == 'newZebra') { $selp = 'selected'; } $selPrintGroup .= '<option value="' . $printer->name . '" ' . $selp . '>' . $printer->name . '</option>';
//carrega o dados da etiqueta enviados pelo etiqueta.php $lbl = new Label(); $propNames = get_object_vars($lbl); foreach ($propNames as $key => $value) { $lbl->{$key} = filter_input(INPUT_POST, $key, FILTER_SANITIZE_STRING); } //carrega o modelo de impressora $printer = filter_input(INPUT_POST, 'printer', FILTER_SANITIZE_STRING); //carrega dados da impressora $oPrinters = new Printers($dbase); $printer = $oPrinters->get($printer); //renderiza as etiquetas $rend = new Render($lbl, $printer); $aLbs = $rend->renderize(); //grava os dados $mov = new Movements($dbase); if ($mov->insertLabel($lbl, $aLbs)) { $divalert = "alert-success"; //imprime $job = new Job($printer); $job->send($aLbs); $msg = "Sucesso !!"; } else { $divalert = "alert-danger"; $msg = "Houve falha na gravação dos dados. Verifque se não errou no numero do volume."; } $script = "<script src=\"js/printback.js\"></script>"; $title = "Impressão Etiquetas"; $body = "<center>" . "<div class=\"container\">" . "<h3>{$title}</h3><br><br>" . "<div class=\"row\">" . "<div class=\"col-md-3\">" . "</div>" . "<div class=\"col-md-6\">" . "<div class=\"alert {$divalert}\" role=\"alert\"><h3>{$msg}</h3></div>" . "</div>" . "<div class=\"col-md-3\">" . "</div>" . "</div>" . "<div class=\"row\">" . "<div class=\"col-md-3\">" . "</div>" . "<div class=\"col-md-6\">" . "<button type=\"button\" class=\"btn btn-default \" id=\"btnback\" name=\"btnback\"><span class=\"glyphicon glyphicon glyphicon-repeat\"></span> Voltar</button>" . "</div>" . "<div class=\"col-md-3\">" . "</div>" . "</div>" . "</div>" . "</center>{$script}"; //retorna informação em caso de erro e volta para a pagina inicial $html = file_get_contents('assets/main.html');