tb_pcp_etiqueta PHP Code Examples

Example #1

1

Show file

File: etiqueta_peca.php Project: rjib/extranet-bravo

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;

Example #2

0

Show file

File: gerarBarCode128.php Project: rjib/extranet-bravo

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;
}

Example #3

0

Show file

File: pcp_etiqueta_peca_pi.php Project: rjib/extranet-bravo

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;

Example #4

0

Show file

File: pcp_etiqueta_pacote_bravo.php Project: rjib/extranet-bravo

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;

Example #5

0

Show file

File: gerarCodeBarEtiquetaPecaCasadei.php Project: rjib/extranet-bravo

<?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'];

Example #6

0

Show file

File: etiqueta_casadei.php Project: rjib/extranet-bravo

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

Example #7

0

Show file

File: pcp_etiqueta_pilha.php Project: rjib/extranet-bravo

} 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"));

Example #8

0

Show file

File: pcp_etiqueta_peca.php Project: rjib/extranet-bravo

//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;

Example #9

0

Show file

File: pcp_etiqueta_casadei.php Project: rjib/extranet-bravo

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);

Example #10

0

Show file

File: pcp_etiqueta_casadei.php Project: rjib/extranet-bravo

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);

Example #11

0

Show file

File: gerarEtiqueta.php Project: rjib/extranet-bravo

<?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) {

PHP tb_pcp_etiqueta Examples