$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 $PHPJasperXML->outpage("I", date("dmYhis")); //page output method I:standard output D:Download file
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); $result = $_adPeca->getOrdemProducaoPorJob($job);