require_once "../class/PHPJasperXML.inc.php"; //require_once("class/PHPJasperXMLSubReport.inc.php"); require_once '../../setup.php'; require_once '../../models/tb_pcp_etiqueta.php'; date_default_timezone_set('America/Sao_Paulo'); $co_pcp_apontamento = $_GET['co_pcp_apontamento']; error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE); $server = DSN; $db = "extranet"; $user = USER; $pass = PASS; $version = "0.8b"; $pgport = 5432; $pchartfolder = "../class/pchart2"; $timestamp = date("d/m/Y") . " " . date("h:i:s"); $co_usuario = $_SESSION['codigoUsuario']; $_etiqueta = new tb_pcp_etiqueta($conexaoERP); $_etiqueta->proc_etiqueta_peca($co_pcp_apontamento, $co_usuario); $xml = simplexml_load_file("etiqueta_peca.jrxml"); $PHPJasperXML = new PHPJasperXML(); //$PHPJasperXML->debugsql=true; $PHPJasperXML->arrayParameter = array("CO_PCP_APONTAMENTO" => $co_pcp_apontamento, "CO_USUARIO" => $co_usuario); $PHPJasperXML->xml_dismantle($xml); //$PHPJasperXML->transferDBtoArray($server,$user,$pass,$db); * use this line if you want to connect with mysql //if you want to use universal odbc connection, please create a dsn connection in odbc first $PHPJasperXML->transferDBtoArray($server, $user, $pass, $db); //$PHPJasperXML->outpage("F",APP_PATH.'barcodes'.DS.date("dmYhis").".pdf"); //page output method I:standard output D:Download file $PHPJasperXML->outpage("I", date("dmYhis")); //page output method I:standard output D:Download file $_etiqueta->limparTemporariaEtiquetaPeca($co_usuario); $data = true;
function gerar($co_pcp_ac, $co_usuario) { date_default_timezone_set('America/Sao_Paulo'); require_once '../GerarCodigoDeBarra128.class.php'; require_once '../../setup.php'; require_once '../../models/tb_pcp_etiqueta.php'; require_once '../../models/tb_pcp_pecas.php'; $_etiqueta = new tb_pcp_etiqueta(CONEXAOERP); $_barcode128 = new GerarCodigoDeBarra128(); $_peca = new tb_pcp_pecas(CONEXAOERP); $result = $_etiqueta->listaCodigoBarra($co_pcp_ac); try { while ($dados = mysql_fetch_array($result)) { $_barcode128->gerar($dados["NU_PCP_OP"], APP_PATH . 'barcodes' . DS . $co_usuario . '_' . $dados['NU_PCP_OP'] . '.gif', 10, 10, 125, 275, 30, 2, 180, 300, 300, 300, 300); } } catch (Exception $e) { $data = false; echo json_encode($data); exit; } $data = true; }
require_once '../class/tcpdf/tcpdf.php'; require_once "../class/PHPJasperXML.inc.php"; //require_once("class/PHPJasperXMLSubReport.inc.php"); require_once '../../setup.php'; require_once '../../models/tb_pcp_etiqueta.php'; date_default_timezone_set('America/Sao_Paulo'); $co_pcp_ad = $_GET['co_pcp_ad']; error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE); $server = DSN; $db = "extranet"; $user = USER; $pass = PASS; $version = "0.8b"; $pgport = 5432; $pchartfolder = "../class/pchart2"; $co_usuario = $_SESSION['codigoUsuario']; $_etiqueta = new tb_pcp_etiqueta($conexaoERP); $_etiqueta->proc_etiqueta_peca_pi($co_pcp_ad, $co_usuario); $xml = simplexml_load_file("pcp_etiqueta_peca_pi.jrxml"); $PHPJasperXML = new PHPJasperXML(); //$PHPJasperXML->debugsql=true; $PHPJasperXML->arrayParameter = array("CO_PCP_AD" => $co_pcp_ad, "CO_USUARIO" => $co_usuario); $PHPJasperXML->xml_dismantle($xml); //$PHPJasperXML->transferDBtoArray($server,$user,$pass,$db); * use this line if you want to connect with mysql //if you want to use universal odbc connection, please create a dsn connection in odbc first $PHPJasperXML->transferDBtoArray($server, $user, $pass, $db); $_etiqueta->limparTemporariaPiPcp($co_usuario); //$PHPJasperXML->outpage("F",APP_PATH.'barcodes'.DS.date("dmYhis").".pdf"); //page output method I:standard output D:Download file $PHPJasperXML->outpage("I", date("dmYhis")); //page output method I:standard output D:Download file $data = true;
require_once '../../setup.php'; require_once '../../models/tb_pcp_etiqueta.php'; require_once APP_PATH . 'sistema/models/tb_pcp_pecas.php'; date_default_timezone_set('America/Sao_Paulo'); $nu_op = $_GET['nu_op']; error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE); $server = DSN; $db = "extranet"; $user = USER; $pass = PASS; $version = "0.8b"; $pgport = 5432; $pchartfolder = "../class/pchart2"; $timestamp = date("d/m/Y") . " " . date("h:i:s"); $co_usuario = $_SESSION['codigoUsuario']; $_etiqueta = new tb_pcp_etiqueta($conexaoERP); $_etiqueta->proc_etiqueta_relatorio_pacote($nu_op, $co_usuario); $xml = simplexml_load_file("pcp_etiqueta_pacote_bravo.jrxml"); $PHPJasperXML = new PHPJasperXML(); //$PHPJasperXML->debugsql=true; $PHPJasperXML->arrayParameter = array("CO_USUARIO" => $co_usuario, "PATH" => APP_PATH . 'barcodes' . DS); $PHPJasperXML->xml_dismantle($xml); //$PHPJasperXML->transferDBtoArray($server,$user,$pass,$db); * use this line if you want to connect with mysql //if you want to use universal odbc connection, please create a dsn connection in odbc first $PHPJasperXML->transferDBtoArray($server, $user, $pass, $db); //$PHPJasperXML->outpage("F",APP_PATH.'barcodes'.DS.date("dmYhis").".pdf"); //page output method I:standard output D:Download file $PHPJasperXML->outpage("I", date("dmYhis")); //page output method I:standard output D:Download file $_etiqueta->limparTemporariaEtiquetaPacote($co_usuario); unlink(APP_PATH . 'barcodes' . DS . $co_usuario . '_relatorio_pacote_encantos_' . $nu_op . '.gif'); $data = true;
<?php session_start(); date_default_timezone_set('America/Sao_Paulo'); require_once '../GerarCodigoDeBarra128.class.php'; require_once '../../setup.php'; require_once '../../models/tb_pcp_etiqueta.php'; $_etiqueta = new tb_pcp_etiqueta($conexaoERP); $_barcode128 = new GerarCodigoDeBarra128(); $data = false; function gerar($nu_op, $co_usuario) { date_default_timezone_set('America/Sao_Paulo'); require_once '../GerarCodigoDeBarra128.class.php'; require_once '../../setup.php'; require_once '../../models/tb_pcp_etiqueta.php'; require_once '../../models/tb_pcp_pecas.php'; $_barCasaDei = new GerarCodigoDeBarra128(); try { $_barCasaDei->gerar($nu_op, APP_PATH . 'barcodes' . DS . $co_usuario . '_casadei_' . $nu_op . '.gif', 10, 0, 75, 40, 20, 1, 180, 150, 50, 300, 300); } catch (Exception $e) { $data = false; echo json_encode($data); exit; } $data = true; } $co_pcp_apontamento = $_POST['co_pcp_apontamento']; $row = $_etiqueta->getOPFind($co_pcp_apontamento); $nu_op = $row[0]; $co_usuario = $_SESSION['codigoUsuario'];
date_default_timezone_set('America/Sao_Paulo'); $_peca = new tb_pcp_pecas($conexaoERP); $co_pcp_apontamento = $_GET['co_pcp_apontamento']; $onde = $_GET['onde']; //de onde esta vindo error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE); $server = "localhost"; $db = "extranet"; $user = "******"; $pass = ""; $version = "0.8b"; $pgport = 5432; $pchartfolder = "../class/pchart2"; $timestamp = date("dmY") . date("his"); $co_usuario = $_SESSION['codigoUsuario']; $_etiqueta = new tb_pcp_etiqueta($conexaoERP); if ($onde == '1') { $_etiqueta->proc_etiqueta_casadei_relatorio($co_pcp_apontamento, $co_usuario); } else { $_etiqueta->proc_etiqueta_casadei($co_pcp_apontamento, $co_usuario); } $row = $_etiqueta->getOPFind($co_pcp_apontamento); $xml = simplexml_load_file("etiqueta_casadei.jrxml"); $PHPJasperXML = new PHPJasperXML(); //$PHPJasperXML->debugsql=true; $PHPJasperXML->arrayParameter = array("co_pcp_apontamento" => $co_pcp_apontamento, "co_usuario" => $co_usuario, "PATH" => APP_PATH . 'barcodes' . DS); $PHPJasperXML->xml_dismantle($xml); //$PHPJasperXML->transferDBtoArray($server,$user,$pass,$db); * use this line if you want to connect with mysql //if you want to use universal odbc connection, please create a dsn connection in odbc first $PHPJasperXML->transferDBtoArray($server, $user, $pass, $db); //$PHPJasperXML->outpage("F",APP_PATH.'barcodes'.DS.date("dmYhis").".pdf"); //page output method I:standard output D:Download file
} catch (Exception $e) { $data = false; echo json_encode($data); exit; } error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE); $server = "localhost"; $db = "extranet"; $user = "******"; $pass = ""; $version = "0.8b"; $pgport = 5432; $pchartfolder = "../class/pchart2"; $timestamp = date("d/m/Y") . " " . date("h:i:s"); $co_usuario = $_SESSION['codigoUsuario']; $_etiqueta = new tb_pcp_etiqueta($conexaoERP); $no_pcp_ad = $_etiqueta->getJob($co_pcp_ad); //if($no_pcp_ad[1]==0){ $xml = simplexml_load_file("pcp_etiqueta_pilha.jrxml"); //}else{ //$xml = simplexml_load_file("pcp_etiqueta_pilha_tokstok.jrxml"); //} $PHPJasperXML = new PHPJasperXML(); //$PHPJasperXML->debugsql=true; $PHPJasperXML->arrayParameter = array("CO_PCP_AC" => $co_pcp_ac, "CO_USUARIO" => $co_usuario, "NO_PCP_AD" => $no_pcp_ad[0], "CODIGO_BARRA" => APP_PATH . 'barcodes' . DS, "TIMESTAMP" => $timestamp); $PHPJasperXML->xml_dismantle($xml); //$PHPJasperXML->transferDBtoArray($server,$user,$pass,$db); * use this line if you want to connect with mysql //if you want to use universal odbc connection, please create a dsn connection in odbc first $PHPJasperXML->transferDBtoArray($server, $user, $pass, $db); //$PHPJasperXML->outpage("F",APP_PATH.'barcodes'.DS.date("dmYhis").".pdf"); //page output method I:standard output D:Download file $PHPJasperXML->outpage("I", date("dmYhis"));
//require_once("class/PHPJasperXMLSubReport.inc.php"); require_once '../../setup.php'; require_once '../../models/tb_pcp_etiqueta.php'; require_once APP_PATH . 'sistema/models/tb_pcp_pecas.php'; date_default_timezone_set('America/Sao_Paulo'); $nu_op = $_GET['nu_op']; error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE); $server = DSN; $db = "extranet"; $user = USER; $pass = PASS; $version = "0.8b"; $pgport = 5432; $pchartfolder = "../class/pchart2"; $timestamp = date("d/m/Y") . " " . date("h:i:s"); $co_usuario = $_SESSION['codigoUsuario']; $_etiqueta = new tb_pcp_etiqueta($conexaoERP); $_etiqueta->proc_etiqueta_peca_relatorio($nu_op, $co_usuario); $xml = simplexml_load_file("pcp_etiqueta_peca.jrxml"); $PHPJasperXML = new PHPJasperXML(); //$PHPJasperXML->debugsql=true; $PHPJasperXML->arrayParameter = array("CO_USUARIO" => $co_usuario); $PHPJasperXML->xml_dismantle($xml); //$PHPJasperXML->transferDBtoArray($server,$user,$pass,$db); * use this line if you want to connect with mysql //if you want to use universal odbc connection, please create a dsn connection in odbc first $PHPJasperXML->transferDBtoArray($server, $user, $pass, $db); //$PHPJasperXML->outpage("F",APP_PATH.'barcodes'.DS.date("dmYhis").".pdf"); //page output method I:standard output D:Download file $PHPJasperXML->outpage("I", date("dmYhis")); //page output method I:standard output D:Download file $_etiqueta->limparTemporariaEtiquetaPeca($co_usuario); $data = true;
require_once APP_PATH . 'sistema/models/tb_pcp_pecas.php'; require_once APP_PATH . 'sistema/models/tb_pcp_ad_peca.php'; date_default_timezone_set('America/Sao_Paulo'); $_peca = new tb_pcp_pecas($conexaoERP); $job = $_GET['job']; error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE); $server = "localhost"; $db = "extranet"; $user = "******"; $pass = ""; $version = "0.8b"; $pgport = 5432; $pchartfolder = "../class/pchart2"; $timestamp = date("dmY") . date("his"); $co_usuario = $_SESSION['codigoUsuario']; $_etiqueta = new tb_pcp_etiqueta($conexaoERP); $_etiqueta->proc_etiqueta_casadei_relatorio($job, $co_usuario); $xml = simplexml_load_file("pcp_etiqueta_casadei.jrxml"); $PHPJasperXML = new PHPJasperXML(); //$PHPJasperXML->debugsql=true; $PHPJasperXML->arrayParameter = array("co_usuario" => $co_usuario, "PATH" => APP_PATH . 'barcodes' . DS); $PHPJasperXML->xml_dismantle($xml); //$PHPJasperXML->transferDBtoArray($server,$user,$pass,$db); * use this line if you want to connect with mysql //if you want to use universal odbc connection, please create a dsn connection in odbc first $PHPJasperXML->transferDBtoArray($server, $user, $pass, $db); //$PHPJasperXML->outpage("F",APP_PATH.'barcodes'.DS.date("dmYhis").".pdf"); //page output method I:standard output D:Download file $PHPJasperXML->outpage("I", date("dmYhis")); //page output method I:standard output D:Download file $_etiqueta->limparTemporaria($co_usuario); //APP_PATH.'barcodes'.DS.'casadei_'.$nu_op.'.gif' $_adPeca = new tb_pcp_ad_peca($conexaoERP);
require_once APP_PATH . 'sistema/models/tb_pcp_ad_peca.php'; date_default_timezone_set('America/Sao_Paulo'); $_peca = new tb_pcp_pecas($conexaoERP); $co_pcp_ad = $_GET['co_pcp_ad']; $onde = $_GET['onde']; //de onde esta vindo error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE); $server = "localhost"; $db = "extranet"; $user = "******"; $pass = ""; $version = "0.8b"; $pgport = 5432; $pchartfolder = "../class/pchart2"; $co_usuario = $_SESSION['codigoUsuario']; $_etiqueta = new tb_pcp_etiqueta($conexaoERP); $_adPeca = new tb_pcp_ad_peca($conexaoERP); $_etiqueta->proc_etiqueta_casadei_pcp($co_pcp_ad, $co_usuario); $xml = simplexml_load_file("pcp_etiqueta_casadei.jrxml"); $PHPJasperXML = new PHPJasperXML(); //$PHPJasperXML->debugsql=true; $PHPJasperXML->arrayParameter = array("co_pcp_ad" => $co_pcp_ad, "co_usuario" => $co_usuario, "PATH" => APP_PATH . 'barcodes' . DS); $PHPJasperXML->xml_dismantle($xml); //$PHPJasperXML->transferDBtoArray($server,$user,$pass,$db); * use this line if you want to connect with mysql //if you want to use universal odbc connection, please create a dsn connection in odbc first $PHPJasperXML->transferDBtoArray($server, $user, $pass, $db); //$PHPJasperXML->outpage("F",APP_PATH.'barcodes'.DS.date("dmYhis").".pdf"); //page output method I:standard output D:Download file $PHPJasperXML->outpage("I", date("dmYhis")); //page output method I:standard output D:Download file $_etiqueta->limparTemporariaCasadeiPcp($co_usuario); $result = $_adPeca->getOPbyAD($co_pcp_ad);
<?php require_once '../../setup.php'; require_once APP_PATH . 'sistema/helper.class.php'; require_once APP_PATH . 'sistema/models/tb_pcp_pecas.php'; require_once APP_PATH . 'sistema/models/tb_pcp_op.php'; require_once APP_PATH . 'sistema/models/tb_pcp_etiqueta.php'; $co_pcp_ad = $_POST['co_pcp_ad']; $no_pcp_ad = $_POST['no_pcp_ad']; //$TOKEN = md5(SHA1(date('Ymd'))); $_peca = new tb_pcp_pecas($conexaoERP); $_op = new tb_pcp_op($conexaoERP); $_etiqueta = new tb_pcp_etiqueta($conexaoERP); $result = $_peca->findPecasByAD($co_pcp_ad); $dados = mysql_fetch_array($result); $row = $_peca->findPecasByAD($co_pcp_ad); $gerouEtiqueta = $_etiqueta->findByAc($dados['CO_PCP_AC']); $co_pcp_ac = $dados['CO_PCP_AC']; $data = false; if ($gerouEtiqueta == 0) { //se nao tiver gerado etiqueta while ($PECA = mysql_fetch_array($row)) { $fator = 1; $fatorl = 1; $ORDEM_PRODUCAO = $_op->getProduto($PECA['CO_PCP_OP']); $qtd_peca_por_pilha = floor(MAX_PILHA / $ORDEM_PRODUCAO['NU_ESPESSURA']); $tmp_empilhamento_maximo_diferenciado = $qtd_peca_por_pilha; $qtd_etiqueta = 1; if ($ORDEM_PRODUCAO['NU_COMPRIMENTO'] >= 238) { $fator = 1; } elseif ($ORDEM_PRODUCAO['NU_COMPRIMENTO'] >= 100 && $ORDEM_PRODUCAO['NU_COMPRIMENTO'] < 238) {