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