<?php

// Copyright (C) 2005-2008 SpheraIT
$filename = "speeddial_" . date("d-m-Y");
header('Content-Disposition: attachment; filename="' . $filename . '.csv"');
header('content-type: text/csv');
require_once 'functions.php';
require_once './classes/speeddial/Datasource.php';
require_once './classes/speeddial/SpeedEntry.php';
require_once './classes/speeddial/SpeedEntryDAO.php';
$amp_conf = parse_amportal_conf("/etc/amportal.conf");
$ds = new DatasourceSpeeddial($amp_conf['AMPDBHOST'], $amp_conf['AMPDBNAME'], $amp_conf['AMPDBUSER'], $amp_conf['AMPDBPASS']);
$dao = new SpeedEntryDAO();
//echo "<pre>"; print_r($amp_conf);
$results = $dao->readAll($ds);
$stdout = fopen('php://output', 'w');
if (count($results) > 0) {
    fwrite($stdout, '"Number";"Callerid";"Forward";"Permission"' . "\n");
    foreach ($results as $r) {
        $permission = $r->getPermission();
        if ($permission == "") {
            $permission = "NO";
        }
        if ($permission == "CHECKED") {
            $permission = "YES";
        }
        fwrite($stdout, '"' . $r->getNumber() . '";"' . $r->getDescription() . '";"' . $r->getTelnr() . '";"' . $permission . '"' . "\n");
    }
    //foreach
}
//if $results>0
Exemple #2
0
<?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");