AttoDato_stampa_etichette_OLD.php

/branches/messigdp/gui/AttoDato_stampa_etichette_OLD.php

http://antilophpe.googlecode.com/
PHP | 332 lines | 287 code | 35 blank | 10 comment | 25 complexity | 12e4f6075219f5cbdaec3483b250e175 MD5 | raw file
Possible License(s): LGPL-2.1, LGPL-3.0, GPL-3.0

<?php

/**

 * File NotificaDato.php

 *

 * This file contains the definition of the gui for the object

 * type NotificaDato.

 * @author Marco Novo <mnovo@ncfsistemi.com>

 * @version 1.0

 */

include_once("../config/config.inc.php");

include_once("../include/Session/SessionController.class.php");

include_once("../include/Database/DatabaseConnection.class.php");

include_once("../include/Database/QueryBuilder.class.php");

include_once("../include/Design/Design.class.php");

include_once("../include/Navbar/Navbar.class.php");

include_once("../include/Date/Date.class.php");

include_once("../include/Object/NotificaDato.class.php");

include_once('../include/Pdf/fpdf.php');



$moduleId=55;



$SessionController = new SessionController();

if (!isset($_SESSION['Mask'][$moduleId])){

  echo '

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

    <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="it-IT">

      <head><title>Session intrusion</title></head>

      <body>

        <script>top.location.href=\'_LoginOperations.php?operation=logout&message=intrusion\'</script>

      </body>

    </html>

  ';

  exit;

}



$DatabaseConnection = new DatabaseConnection($db_param);

$resourceLinkID=$DatabaseConnection->getResourceLinkId();



$query='

  SELECT "numero"

  FROM "ant_AttoDato" WHERE "id"='.$_REQUEST['AttoDato__id'];





$result=oci_parse($resourceLinkID, $query) or die('Query:<hr/> '.$query.'<hr/>Error during selection in table `ant_NotificaDato`: '.var_dump(oci_error()));

oci_execute($result, OCI_DEFAULT);

$notificaDato_array=oci_fetch_array($result);

$numero=$notificaDato_array[numero];





$query_esito = 'SELECT *  FROM "ant_NotificaDato" WHERE  "deleted"=0 AND "active"=1 AND "idAtto"='.$_REQUEST['AttoDato__id'];



$notifiche=0;

$result_esito=oci_parse($resourceLinkID, $query_esito) or die('Query:<hr/> '.$query_esito.'<hr/>Error during selection in table `ant_AttoDato`: '.var_dump(oci_error()));

oci_execute($result_esito, OCI_DEFAULT);

while($spese=oci_fetch_array($result_esito)){

	$spese_postali+=$spese[spesePostali];

	$spese_139+=$spese[spesa139];

	$spese_140+=$spese[spesa140];

	$spese_645+=$spese[spesa645];

	$spese_660+=$spese[spesa660];

	$spese_postali_aggiuntive+=$spese[spesePostaliAggiuntive];

	$notifiche++;

	$totale+=$spese[spesePostali]+$spese[spesa139]+$spese[spesa140]+$spese[spesa645]+$spese[spesa660]+$spese[spesePostaliAggiuntive];

}









$colonna1=110;

$colonna2=280;

$colonna3=390;

$colonna4=570;

$riga1=50;

$riga2=75;

$riga3=120;

$riga4=145;

$riga5=170;

$riga6=205;





$dict[1]='Integrazione Spese di Notifica';

$dict[2]='N. '.$numero.' cron.';





$i=3;

	if($spese_postali>0){

	  $dict[$i]='Spese Postali';

	  $i++;

	  $dict[$i]=number_format($spese_postali,2,',','.');

	  if($dict[$i]<10) $dict[$i]='E  '.number_format($spese_postali,2,',','.');

	  else $dict[$i]='E '.number_format($spese_postali,2,',','.');

	  $i++;

	}

	if($spese_139>0){

	  $dict[$i]='Spese 139';

	  $i++;

	  $dict[$i]=number_format($spese_139,2,',','.');

	  if($dict[$i]<10) $dict[$i]='E  '.number_format($spese_139,2,',','.');

	  else $dict[$i]='E '.number_format($spese_139,2,',','.');

	  $i++;

	}

	if($spese_140>0){

	  $dict[$i]='Spese 140';

	  $i++;

	  $dict[$i]=number_format($spese_140,2,',','.');

	  if($dict[$i]<10) $dict[$i]='E  '.number_format($spese_140,2,',','.');

	  else $dict[$i]='E '.number_format($spese_140,2,',','.');

	  $i++;

	}

	if($spese_645>0){

	  $dict[$i]='Spese 645';

	  $i++;

	  $dict[$i]=number_format($spese_645,2,',','.');

	  if($dict[$i]<10) $dict[$i]='E  '.number_format($spese_645,2,',','.');

	  else $dict[$i]='E '.number_format($spese_645,2,',','.');

	  $i++;

	}

	if($spese_660>0){

	  $dict[$i]='Spese 660';

	  $i++;

	  $dict[$i]=number_format($spese_660,2,',','.');

	  if($dict[$i]<10) $dict[$i]='E  '.number_format($spese_660,2,',','.');

	  else $dict[$i]='E '.number_format($spese_660,2,',','.');

	  $i++;

	}

	if($spese_postali_aggiuntive>0){

	  $dict[$i]='Spese Pos.Agg.';

	  $i++;

	  $dict[$i]=number_format($spese_postali_aggiuntive,2,',','.');

	  if($dict[$i]<10) $dict[$i]='E  '.number_format($spese_postali_aggiuntive,2,',','.');

	  else $dict[$i]='E '.number_format($spese_postali_aggiuntive,2,',','.');

	  $i++;

	}

	



$totale=number_format($totale,2,',','.');

if($totale<10) $totale=' '.$totale;

$dict[$i]="Totale";

$i++;

$dict[$i]='E '.$totale;



$id=time();



$copie=1;





$insert='';



for($j=1;$j<=$i;$j++){

  $insert.='

	  <member>

	    <name>';

  if($j<10) $insert.='0'.$j;

  else $insert.=$j;

  $insert.='</name>

	    <value><string>'.$dict[$j].'</string></value>

	  </member>';

}

// $request = xmlrpc_encode_request("queue_one_genericlabel", array($id, $copie, $dict, $template));

 



$template[6]='



N

ZB

A'.$colonna1.','.$riga1.',0,3,1,1,N,"%s"

A'.$colonna1.','.$riga2.',0,3,1,1,N,"%s"

A'.$colonna1.','.$riga3.',0,2,1,1,N,"%s"

A'.$colonna2.','.$riga3.',0,2,1,1,N,"%s"

A'.$colonna1.','.$riga6.',0,2,1,1,N,"%s"

A'.$colonna2.','.$riga6.',0,2,1,1,N,"%s"

P1



';

$template[8]='



N

ZB

A'.$colonna1.','.$riga1.',0,3,1,1,N,"%s"

A'.$colonna1.','.$riga2.',0,3,1,1,N,"%s"

A'.$colonna1.','.$riga3.',0,2,1,1,N,"%s"

A'.$colonna2.','.$riga3.',0,2,1,1,N,"%s"

A'.$colonna1.','.$riga4.',0,2,1,1,N,"%s"

A'.$colonna2.','.$riga4.',0,2,1,1,N,"%s"

A'.$colonna1.','.$riga6.',0,2,1,1,N,"%s"

A'.$colonna2.','.$riga6.',0,2,1,1,N,"%s"

P1



';

$template[10]='



N

ZB

A'.$colonna1.','.$riga1.',0,3,1,1,N,"%s"

A'.$colonna1.','.$riga2.',0,3,1,1,N,"%s"

A'.$colonna1.','.$riga3.',0,2,1,1,N,"%s"

A'.$colonna2.','.$riga3.',0,2,1,1,N,"%s"

A'.$colonna1.','.$riga4.',0,2,1,1,N,"%s"

A'.$colonna2.','.$riga4.',0,2,1,1,N,"%s"

A'.$colonna1.','.$riga5.'0,2,1,1,N,"%s"

A'.$colonna2.','.$riga5.',0,2,1,1,N,"%s"

A'.$colonna1.','.$riga6.',0,2,1,1,N,"%s"

A'.$colonna2.','.$riga6.',0,2,1,1,N,"%s"

P1



';

$template[12]='



N

ZB

A'.$colonna1.','.$riga1.',0,3,1,1,N,"%s"

A'.$colonna1.','.$riga2.',0,3,1,1,N,"%s"

A'.$colonna1.','.$riga3.',0,2,1,1,N,"%s"

A'.$colonna2.','.$riga3.',0,2,1,1,N,"%s"

A'.$colonna1.','.$riga4.',0,2,1,1,N,"%s"

A'.$colonna2.','.$riga4.',0,2,1,1,N,"%s"

A'.$colonna1.','.$riga5.',0,2,1,1,N,"%s"

A'.$colonna2.','.$riga5.',0,2,1,1,N,"%s"

A'.$colonna3.','.$riga3.',0,2,1,1,N,"%s"

A'.$colonna4.','.$riga3.',0,2,1,1,N,"%s"

A'.$colonna3.','.$riga6.',0,2,1,1,N,"%s"

A'.$colonna4.','.$riga6.',0,2,1,1,N,"%s"

P1



';

$template[14]='



N

ZB

A'.$colonna1.','.$riga1.',0,3,1,1,N,"%s"

A'.$colonna1.','.$riga2.',0,3,1,1,N,"%s"

A'.$colonna1.','.$riga3.',0,2,1,1,N,"%s"

A'.$colonna2.','.$riga3.',0,2,1,1,N,"%s"

A'.$colonna1.','.$riga4.',0,2,1,1,N,"%s"

A'.$colonna2.','.$riga4.',0,2,1,1,N,"%s"

A'.$colonna1.','.$riga5.',0,2,1,1,N,"%s"

A'.$colonna2.','.$riga5.',0,2,1,1,N,"%s"

A'.$colonna3.','.$riga3.',0,2,1,1,N,"%s"

A'.$colonna4.','.$riga3.',0,2,1,1,N,"%s"

A'.$colonna3.','.$riga4.',0,2,1,1,N,"%s"

A'.$colonna4.','.$riga4.',0,2,1,1,N,"%s"

A'.$colonna3.','.$riga6.',0,2,1,1,N,"%s"

A'.$colonna4.','.$riga6.',0,2,1,1,N,"%s"

P1



';

$template[16]='



N

ZB

A'.$colonna1.','.$riga1.',0,3,1,1,N,"%s"

A'.$colonna1.','.$riga2.',0,3,1,1,N,"%s"

A'.$colonna1.','.$riga3.',0,2,1,1,N,"%s"

A'.$colonna2.','.$riga3.',0,2,1,1,N,"%s"

A'.$colonna1.','.$riga4.',0,2,1,1,N,"%s"

A'.$colonna2.','.$riga4.',0,2,1,1,N,"%s"

A'.$colonna1.','.$riga5.',0,2,1,1,N,"%s"

A'.$colonna2.','.$riga5.',0,2,1,1,N,"%s"

A'.$colonna3.','.$riga3.',0,2,1,1,N,"%s"

A'.$colonna4.','.$riga3.',0,2,1,1,N,"%s"

A'.$colonna3.','.$riga4.',0,2,1,1,N,"%s"

A'.$colonna4.','.$riga4.',0,2,1,1,N,"%s"

A'.$colonna3.','.$riga5.',0,2,1,1,N,"%s"

A'.$colonna4.','.$riga5.',0,2,1,1,N,"%s"

A'.$colonna3.','.$riga6.',0,2,1,1,N,"%s"

A'.$colonna4.','.$riga6.',0,2,1,1,N,"%s"

P1



';

 

 

$request = '<?xml version="1.0" encoding="iso-8859-1"?>

<methodCall>

<methodName>queue_one_genericlabel</methodName>

<params>

 <param>

  <value>

   <int>'.$id.'</int>

  </value>

 </param>

 <param>

  <value>

   <int>'.$copie.'</int>

  </value>

 </param>

 <param>

  <value>

	<struct>'.$insert.'

	</struct>

  </value>

 </param>

 <param>

  <value>

   <string>'.$template[$i].'</string>

  </value>

 </param>

</params>

</methodCall>';



 $context = stream_context_create(array('http' => array(

     'method' => "POST",

     'header' => "Content-Type: text/xml",

     'content' => $request

 )));

 

 $file = file_get_contents("http://".$_SERVER['REMOTE_ADDR'].":1000", false, $context); 

 

 $response = xmlrpc_decode($file);

 

 if (xmlrpc_is_fault($response)) {

     trigger_error("xmlrpc: $response[faultString] ($response[faultCode])");

 }

 else {

     // print_r($response);

 }

?>





<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>Stampa Etichette</title>

</head>



<body>

<p align="center">Stampa etichetta in corso</p>

<p align="right"><a href="#" onclick="window.close();">chiudi [X]</a></p>

<script>setTimeout('window.close()', 2000);</script>

</body>

</html>