'); date_default_timezone_set('Europe/Paris'); // error_reporting(E_ALL); // ini_set('display_errors', 1); $IP = toSQL($_SERVER["REMOTE_ADDR"]); if (isset($_REQUEST["rate"]) && $_REQUEST["rate"]!="") { $rate = $_REQUEST["rate"]; } else { $rate = 3.0; } if (isset($_REQUEST["years"]) && $_REQUEST["years"]!="") { $years = $_REQUEST["years"]; $default_mens = intval($years) * 12 . " mensualités"; $nb_months = $years * 12; } else { $years = 20; $default_mens = "240 mensualités"; $nb_months = $years * 12; } if (isset($_REQUEST["amount"]) && $_REQUEST["amount"]!="") { $amount = $_REQUEST["amount"]; } else { $amount = ""; } if (isset($_REQUEST["currency"]) && $_REQUEST["currency"]!="") { $currency = $_REQUEST["currency"]; } else { $currency = ""; } // On sauvegarde la simulation $sql = "INSERT into SIMULATIONS values (getdate(), '$IP', '$amount', $years, '$rate', '$currency')"; odbc_exec($connection, $sql); // On recupere l'ID $sql = "SELECT max(SIM_ID) as M from SIMULATIONS"; $que = odbc_exec($connection, $sql); if (odbc_fetch_row($que)) { $M = odbc_result($que, "M"); } else { $M = 26; } $float_mensu = floatval(str_replace(",", "", $_REQUEST["mensu"])); $total = $float_mensu * $nb_months; // On récupère le nom de chaque mensualité for ($x=0; $x<$nb_months; $x++) { $sql = "select datepart(month, dateadd(month, $x, getdate())) as MOIS, datepart(year, dateadd(month, $x, getdate())) as ANNEE"; $que = odbc_exec($connection, $sql); $monthname[] = $NAMEMONTHS[ (odbc_result($que, "MOIS")-1) ]; $yearname[] = odbc_result($que, "ANNEE"); $mensu[] = $_REQUEST["mensu"] . " " . $currency; $total = $total - $float_mensu; $cumul[] = number_format($total,2) . " " . $currency; } $TITLE = "SIMULATEUR CREDIT ZEN"; $objPHPExcel = new PHPExcel(); $objPHPExcel->getProperties()->setCreator('Credit Zen') ->setLastModifiedBy('Credit Zen') ->setTitle('Credit Zen') ->setSubject('Credit Zen') ->setDescription('Credit Zen') ->setKeywords('Credit Zen') ->setCategory('Credit Zen'); $objPHPExcel->setActiveSheetIndex(0); $objPHPExcel->getActiveSheet()->setCellValue('A1', 'MOIS') ->setCellValue('B1', 'MONTANT') ->setCellValue('C1', 'SOLDE'); for ($x=0; $xgetActiveSheet()->getStyle('A1:C1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('FF99CCFF'); $objPHPExcel->getActiveSheet()->setTitle($TITLE); } catch(Exception $e) { print_r($e); exit(); } $FILENAME = "CreditZen_" . str_pad($M, 5, "0", STR_PAD_LEFT) . ".xls"; $PATHNAME = "Simulations/" . $FILENAME; try { $objPHPExcel->getActiveSheet()->fromArray($dataArray, NULL, 'A2'); $objPHPExcel->getActiveSheet()->getStyle('A1:C1')->getFont()->setBold(true); } catch(Exception $e) { print_r($e); exit(); } try { $objPHPExcel->getActiveSheet()->setAutoFilter($objPHPExcel->getActiveSheet()->calculateWorksheetDimension()); $objPHPExcel->setActiveSheetIndex(0); } catch(Exception $e) { print_r($e); exit(); } $callStartTime = microtime(true); try { $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); } catch(Exception $e) { print_r($e); exit(); } try { $objWriter->save($PATHNAME); } catch(Exception $e) { print_r($e); exit(); } header("Location: " . $PATHNAME); exit(); ?>