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; }
$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")); //page output method I:standard output D:Download file $result = $_etiqueta->listaCodigoBarra($co_pcp_ac); while ($dados = mysql_fetch_array($result)) { unlink(APP_PATH . 'barcodes' . DS . $co_usuario . '_' . $dados['NU_PCP_OP'] . '.gif'); } $data = true;