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;
