$objPHPExcel->setActiveSheetIndex(0);
$url = 'https://www.vfbank.ru/garant/calcdo';
$fz = "1";
$program = "2";
$avans = "0";
$time_array = array("30", "60", "90", "120", "150", "180", "210", "240", "270", "300", "330", "360", "390", "420", "450", "480", "510", "540", "570", "600", "630", "660", "690", "720", "760");
$amount_array = array("100000", "200000", "300000", "400000", "500000", "600000", "700000", "800000", "900000", "1000000", "1100000", "1200000", "1300000", "1400000", "1500000", "1600000", "1700000", "1800000", "1900000", "2000000", "2100000", "2200000", "2300000", "2400000", "2500000", "2600000", "2700000", "2800000", "2900000", "3000000", "3100000", "3200000", "3300000", "3400000", "3500000", "3600000", "3700000", "3800000", "3900000", "4000000", "4100000", "4200000", "4300000", "4400000", "4500000", "4600000", "4700000", "4800000", "4900000", "5000000", "5100000", "5200000", "5300000", "5400000", "5500000", "5600000", "5700000", "5800000", "5900000");
/* Set header */
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(0, 1, 'сумма');
set_header_style(0, 1);
set_leftside_style(0, 1);
$row = 1;
$col = 1;
foreach ($time_array as $time) {
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $time);
set_header_style($col, $row);
$col += 1;
}
/* Set left side */
$row = 2;
$col = 0;
foreach ($amount_array as $amount) {
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $amount);
set_leftside_style($col, $row);
$row += 1;
}
/* Populate commision table */
$row = 2;
foreach ($amount_array as $amount) {
$col = 1;
foreach ($time_array as $time) {
$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';
}
} else {
print draw_form($thissearch[form], $module, $error, $_GET);
}
} else {
print draw_form($thissearch[form], $module, "", $_GET);