include ("forixinc.php"); include ("ng_util.php"); include ("nc_util.php"); include ("pi_util.php"); include ("co_util.php"); include ("mo_util.php"); include ("pn_util.php"); include ("pi_sel.php"); include ("util.php"); $rpi=intval(get_arg("r")); $cmd=intval(get_arg("c")); $ate=intval(get_arg("a")); $val=intval(get_arg("v")); $ano=intval(get_arg("y")); $rng=intval(get_arg("g")); $rnc=intval(get_arg("i")); $rco=intval(get_arg("m")); $rma=intval(get_arg("e")); $rpn=intval(get_arg("t")); if ($rpi<=0) { if (post_arg("pi")!="") { $npi=trim(post_arg("pi")); if (substr($npi,strlen($npi)-(1))!="?") { $rpi= PIref(post_arg("pi")); } } } log_page($REF_PIPAR,$rpi,$cmd); $pi_nome= PInome($rpi); if (strlen($pi_nome)>0) { fxhead("Forix: ".$pi_nome.", ".$titulo[$N_PARS]); } else { fxhead("Forix: ".$titulo[$N_DRIVS].", ".$titulo[$N_PARS]); } if (strlen($pi_nome)>0) { $SQLQuery="SELECT papi.*, ngn.nome as ng_nome, can.nome as co_nome, mon.nome as mo_nome, tpar.nome as ncpar, tabd.nome as ncaba FROM ((((ngn INNER JOIN papi ON papi.rng = ngn.rng) inner join can on papi.rco=can.rco) inner join mon on papi.rma=mon.rma) INNER JOIN tpar ON papi.cpar=tpar.cod) INNER JOIN tabd ON papi.caba=tabd.cod WHERE ngn.lin=".$lin." and papi.rpi=".$rpi." and can.lin=".$linx." and mon.lin=".$linx." and tpar.lin=".$lin." and tabd.lin=".$lin." "; if ($cmd==$cmdPiParCla) $SQLQuery=$SQLQuery."and (papi.cla=".$val.")"; if ($cmd==$cmdPiParGre) $SQLQuery=$SQLQuery."and (papi.gre=".$val.")"; if ($cmd==$cmdPiParVmr) $SQLQuery=$SQLQuery."and (papi.vmr=".$val.")"; // Podios if ($cmd==$cmdPiParPod) $SQLQuery=$SQLQuery."and (papi.cla>0 and papi.cla<4)"; // Primeira linha da grelha if ($cmd==$cmdPiParPli) $SQLQuery=$SQLQuery."and (papi.pli=1)"; // Nao qualificacoes if ($cmd==$cmdPiParNqu) $SQLQuery=$SQLQuery."and (papi.nqu=1)"; // Nao pre-qualificacoes if ($cmd==$cmdPiParNpq) $SQLQuery=$SQLQuery."and (papi.npq=1)"; // Comando if ($cmd==$cmdPiParCom) $SQLQuery=$SQLQuery."and (papi.cnv>0)"; if ($ano>0) { if ($ate==1) $SQLQuery=$SQLQuery."and (papi.rpa<".(($ano-1899)*100000).")"; else $SQLQuery=$SQLQuery."and (papi.rpa>=".(($ano-1900)*100000)." and papi.rpa<".(($ano-1899)*100000).")"; } if ($rng>0) $SQLQuery=$SQLQuery."and (papi.rng=".$rng.")"; if ($rnc>0) $SQLQuery=$SQLQuery."and (papi.rnc=".$rnc.")"; if ($rco>0) $SQLQuery=$SQLQuery."and (papi.rco=".$rco.")"; if ($rma>0) $SQLQuery=$SQLQuery."and (papi.rma=".$rma.")"; if ($rpn>0) $SQLQuery=$SQLQuery."and (papi.cpne=".$rpn.")"; $SQLQuery=$SQLQuery." order by papi.rpa"; tab_ini(); tab_bar(4); ?>
if ($RSList["ini"]==1) { $seq=$seq+1; ?> echo $seq; ?> } else { ?>- } ?> | } else { include("seq.php"); } include("cp_ano.php"); include("gp_nome.php"); include("pa_num.php"); include("cm_nome.php"); if ($cmd == $cmdPiParCom) echo("".$RSList["cnv"]." | "); include("pa_gre.php"); include("pa_cla.php"); include("pa_vmr.php"); ?>
echo $titulo[$N_NOPA]; ?> |
---|