function gerar($job, $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'; require_once '../../models/tb_pcp_ad_peca.php'; $_barCasaDei = new GerarCodigoDeBarra128(); $_adPeca = new tb_pcp_ad_peca(CONEXAOERP); $result = $_adPeca->getOrdemProducaoPorJob($job); while ($dados = mysql_fetch_array($result)) { $nu_op = $dados[4]; try { $_barCasaDei->gerar($nu_op, APP_PATH . 'barcodes' . DS . $co_usuario . '_relatorio_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; }
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); while ($dados = mysql_fetch_array($result)) { unlink(APP_PATH . 'barcodes' . DS . $co_usuario . '_relatorio_casadei_' . $dados[4] . '.gif'); } $data = true;