$TIPI = array(1 => 'AVVR', 2 => 'CLIE', 3 => 'COLL', 4 => 'CONS', 5 => 'CORR', 6 => 'FORN'); $q = $DB->Execute(" SELECT * \r\n FROM contact \r\n WHERE {$where}\r\n ORDER BY codice ASC"); while ($l = $q->FetchRow()) { utf8_encode_array($l); if ($l[data] == '0000-00-00') { $l[data] = ''; } add_table_row('Tabella1', array($l[codice], $rapida ? $l[nome] : "{$l['nome']}\n" . "{$l['indirizzo']}\n" . "{$l['cap']}\t{$l['citta']}\n" . "{$l['stato']}\t- {$l['leg_rap']}\n" . EXPORT_SXW_TYPE . ": " . $TIPI[$l[tipo]] . "\n" . EXPORT_SXW_DCOST . ": {$l['data']} - {$l['luogo']}", $rapida ? $l[telefono] : "{$l['telefono']}\n" . EXPORT_SXW_FAX . ":\t{$l['fax']}\n" . EXPORT_SXW_CFIS . "\t{$l['cod_fis']}\n" . EXPORT_SXW_PIVA . "\t{$l['piva']}\n" . EXPORT_SXW_ISCRCIAAA . ": {$l['iscr_ccia']}\n" . EXPORT_SXW_ISCRTRIB . ": {$l['iscr_trib']}\n" . EXPORT_SXW_PERSFIS . ": " . ($l[tipo_contatto] ? EXPORT_SXW_PERSFIS_NO : EXPORT_SXW_PERSFIS_YES) . "\n"), array($oo_def, $oo_def, $oo_def)); // note if ($l[note] && in_array(1, $P[print_note]) && !$rapida) { add_table_row('Tabella1', array(EXPORT_SXW_NOTE . ": " . $l[note]), $oo_def); } } // create content $OO_PAGE_STYLE = set_page_style($PAGE_STYLE); $OO_PAGE_HEADER = set_page_header("#DATA#\t\t\t" . EXPORT_SXW_TIT_ANA . "\t\t" . EXPORT_SXW_TIT_PG . ": #PAGINA#"); $OO_PAGE_FOOTER = ''; // set_page_footer('#DATA# #ORA#'); $header_style = array(color => '#000000', size => '12pt', align => 'start', face => 'Verdana'); //$footer_style = array(color => '#ffff00', size => '12pt', align => 'end', face => 'Verdana'); $OO_HEADER_STYLE = set_header_style($header_style); $OO_FOOTER_STYLE = ''; // set_footer_style($footer_style); $OO_TABLE_STYLES = gen_table_style(); $OO_TEXT .= render_table('Tabella1'); $OO_FONT_STYLES = gen_font_style(); $url = make_sxw($filename); print '<a href="../output_sxw.php?file=' . $filename . '">' . EXPORT_SXW_CLICK . '</a><br>'; } } else { print draw_form($thissearch[form], $module, $error, $_GET);
$valore = 'Indeterminato'; if ($l[pr_valore] == -2) { $valore = 'Indet/Extra'; } if ($l[pr_valore] > 0) { $valore = nform($l[pr_valore]); } add_table_row('Tabella1', array($l[pr_codice] . "\n\nN. " . (int) $l[pr_numero], "Repertorio n. " . $l[pr_repertorio] . "\t\t" . "Cliente: " . $l[codice] . " (" . $l[nome] . ")\n" . $l[pr_oggetto] . "\n" . "Tipo: " . $l[pr_tipo] . " (" . $PRTIPO[$l[pr_tipo]] . ")\t\t" . "Operatore: " . $oper . "\n" . "Valore: {$valore}\t\tCrit.: " . $l[pr_criterio] . "\t\tFido:" . nform($l[pr_fido]) . "\n" . "Aut. C.: " . $l[pr_comp_cod] . " . " . $l[pr_comp_desc] . "\tN.Prov: " . $l[pr_nprovv] . "\n" . "Giud: " . $l[pr_giudice] . "\t\tN.Ruol: " . $l[pr_nruolo], "Ape: " . mysql_to_date($l[pr_data_inizio]) . "\n" . "Ins: " . mysql_to_date($l[pr_data_ins]) . "\n" . "Agg: " . mysql_to_date($l[pr_data_mod])), array($oo_ar10, $oo_ar10, $oo_ar10e)); // note if ($l[note] && in_array(1, $P[print_note]) && !$rapida) { add_table_row('Tabella1', array("NOTE: " . $l[note]), $oo_ar10); } } // create content $OO_PAGE_STYLE = set_page_style($PAGE_STYLE); $OO_PAGE_HEADER = set_page_header("#DATA#\t\t\t\tELENCO PRATICHE\t\tPag.: #PAGINA#"); $OO_PAGE_FOOTER = ''; // set_page_footer('#DATA# #ORA#'); $header_style = array(color => '#000000', size => '12pt', align => 'start', face => 'Verdana'); //$footer_style = array(color => '#ffff00', size => '12pt', align => 'end', face => 'Verdana'); $OO_HEADER_STYLE = set_header_style($header_style); $OO_FOOTER_STYLE = ''; // set_footer_style($footer_style); $OO_TABLE_STYLES = gen_table_style(); $OO_TEXT .= render_table('Tabella1'); $OO_FONT_STYLES = gen_font_style(); $url = make_sxw($filename); print '<a href="../output_sxw.php?file=' . $filename . '">Fare click per visualizzare il file</a><br>'; } else { print 'selezionare almeno un parametro di ricerca'; }
add_table_header('Tabella1', array('nome', 'cognome', 'indirizzo'), $ver_12, false); add_table_row('Tabella1', array('valerio', 'morettini', 'via pratesi'), $ver_12); add_table_row('Tabella1', array('mario', 'rossi', 'via rossi d fsd fsd fds fd sfsd fsdf'), $ver_12_b); add_table_row('Tabella1', array('mar2io', 'ross2i', 'via ross2i'), $ar_20_b_u); add_table_row('Tabella1', array('valerio', 'morettini', 'via pratesi'), $ver_12); add_table_row('Tabella1', array('mario'), $ver_12_b); add_table_row('Tabella1', array('mar2io', 'ross2i', 'via ross2i'), $ar_20_b_u); add_table_row('Tabella1', array('valerio', 'm', 'via pratesi'), $ver_12); add_table_row('Tabella1', array('mario', 'rossi', 'via rossi d fsd fsd fds fd sfsd fsdf'), $ver_12_b); add_table_row('Tabella1', array('mar2io', 'ross2i', 'via ross2i'), $ar_20_b_u); add_table_row('Tabella1', array('valerio', 'morettini', 'via pratesi'), $ver_12); add_table_row('Tabella1', array('mario', 'rossi', 'via rossi d fsd fsd fds fd sfsd fsdf'), $ver_12_b); add_table_row('Tabella1', array('mar2io', 'ross2i', 'via ross2i'), $ar_20_b_u); // create content $OO_PAGE_STYLE = set_page_style($PAGE_STYLE); $OO_PAGE_HEADER = set_page_header('Pagina #PAGINA# di #PAGINE#'); $OO_PAGE_FOOTER = set_page_footer('#DATA# #ORA#'); $header_style = array(color => '#ff0000', size => '12pt', align => 'end', face => 'Verdana'); $footer_style = array(color => '#ffff00', size => '12pt', align => 'end', face => 'Verdana'); $OO_HEADER_STYLE = set_header_style($header_style); $OO_FOOTER_STYLE = set_footer_style($footer_style); $OO_TABLE_STYLES = gen_table_style(); $OO_TEXT = print_text("Prova prova prova \t\t pd fsfd dsfds fsd fds s fds \nfds sd sd s fs frova prova", $ver_12_b); $OO_TEXT .= render_table('Tabella1'); $OO_FONT_STYLES = gen_font_style(); $content = read_file('modello/content.xml'); $styles = read_file('modello/styles.xml'); $styles = ereg_replace("\t*<OO_PAGE_STYLE/>\r?\n?", $OO_PAGE_STYLE, $styles); $styles = ereg_replace("\t*<OO_HEADER_STYLE/>\r?\n?", $OO_HEADER_STYLE, $styles); $styles = ereg_replace("\t*<OO_FOOTER_STYLE/>\r?\n?", $OO_FOOTER_STYLE, $styles); $styles = ereg_replace("\t*<OO_PAGE_HEADER/>\r?\n?", $OO_PAGE_HEADER, $styles);