/branches/messigdp/gui/AttoDato_stampa_etichette_OLD.php
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>