<?php // Copyright (C) 2005-2008 SpheraIT $filename = "phonebook_" . date("d-m-Y"); header('Content-Disposition: attachment; filename="' . $filename . '.csv"'); header('Content-Type: application/csv'); require_once 'functions.php'; require_once './classes/phonebook/Datasource.php'; require_once './classes/phonebook/PhoneEntry.php'; require_once './classes/phonebook/PhoneEntryDAO.php'; $amp_conf = parse_amportal_conf("/etc/amportal.conf"); $ds = new Datasource($amp_conf['PHONEBOOKDBHOST'], $amp_conf['PHONEBOOKDBNAME'], $amp_conf['PHONEBOOKDBUSER'], $amp_conf['PHONEBOOKDBPASS']); $dao = new PhoneEntryDAO(); //echo "<pre>"; print_r($amp_conf); $results = $dao->readAll($ds); $stdout = fopen('php://output', 'w'); if (count($results) > 0) { fwrite($stdout, '"Description";"Number"' . "\n"); foreach ($results as $r) { $number = $r->getNumber(); settype($number, 'string'); // fputcsv($stdout,array(0=>$number,1=>' '.$r->getDescription())); fwrite($stdout, '"' . $r->getDescription() . '";"' . $r->getNumber() . '"' . "\n"); } //foreach } //if $results>0 fclose($stdout);
<?php // Copyright (C) 2005-2008 SpheraIT require_once './classes/phonebook/Datasource.php'; require_once './classes/phonebook/PhoneEntry.php'; require_once './classes/phonebook/PhoneEntryDAO.php'; $ds = new Datasource($amp_conf['PHONEBOOKDBHOST'], $amp_conf['PHONEBOOKDBNAME'], $amp_conf['PHONEBOOKDBUSER'], $amp_conf['PHONEBOOKDBPASS']); $dao = new PhoneEntryDAO(); //echo "<pre>"; print_r($dao->readAll($ds)); //echo "<pre>"; print_r($amp_conf); ?> <script language="JavaScript"> function deleteCheck(f2) { cancel = false; ok = true; if (confirm("Are you sure to delete this phonebook entry?")) return ! cancel; else return ! ok; } </script> <?php isset($_REQUEST['action']) ? $action = $_REQUEST['action'] : ($action = ''); isset($_REQUEST['phdisplay']) ? $phdisplay = $_REQUEST['phdisplay'] : ($phdisplay = ''); $skip = $_REQUEST['skip'];
<?php // Copyright (C) 2005-2008 SpheraIT require_once './classes/phonebook/Datasource.php'; require_once './classes/phonebook/PhoneEntry.php'; require_once './classes/phonebook/PhoneEntryDAO.php'; require_once './classes/speeddial/Datasource.php'; require_once './classes/speeddial/SpeedEntry.php'; require_once './classes/speeddial/SpeedEntryDAO.php'; $ds = new Datasource($amp_conf['PHONEBOOKDBHOST'], $amp_conf['PHONEBOOKDBNAME'], $amp_conf['PHONEBOOKDBUSER'], $amp_conf['PHONEBOOKDBPASS']); $dao = new PhoneEntryDAO(); $dsspeed = new DatasourceSpeeddial($amp_conf['AMPDBHOST'], $amp_conf['AMPDBNAME'], $amp_conf['AMPDBUSER'], $amp_conf['AMPDBPASS']); $daospeed = new SpeedEntryDAO(); //echo "<pre>"; print_r($amp_conf); ?> <?php $delimiter = isset($_REQUEST['delimiter']) ? $_REQUEST['delimiter'] : ''; $action = isset($_REQUEST['action']) ? $_REQUEST['action'] : ''; $wScript = rtrim($_SERVER['SCRIPT_FILENAME'], $currentFile) . 'retrieve_speeddial_from_mysql.pl'; $display = 3; ?> </div> <div class="rnav"> <li><a onFocus="this.blur()" href="config.php?mode=tools&display=<?php echo $display; ?> &action=import_phonebook" onclick="return confirm('Warning: The phonebook will be overwritten! please do an export now.')"><?php echo _("Import Phonebook");