MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
*/
require "glob_inc.inc.php";
filterMakeAlternatives();
print_header($day, $month, $year, $area);
$Q = mysql_query("SELECT customer_id FROM `customer` WHERE `slettet` = '0' ORDER BY customer_name");
echo '<h1>' . __('Customers') . '</h1>' . chr(10);
echo '- ' . iconHTML('group_add') . ' <a href="customer_edit.php?returnToCustomerView=1">' . __('Create new customer') . '</a><br><br>' . chr(10);
echo '<table>' . chr(10);
//echo ' <tr>'.chr(10);
//echo ' <td><b>'._('Customer').'</b></td>'.chr(10);
//echo ' <td> </td>'.chr(10);
//echo ' </tr>'.chr(10).chr(10);
while ($R = mysql_fetch_assoc($Q)) {
$customer = getCustomer($R['customer_id']);
if (count($customer)) {
$filter = addFilter(array(), 'customer_id', $customer['customer_id']);
$filters_serialized = filterSerialized($filter);
echo ' <tr>' . chr(10);
echo ' <td><b>' . $customer['customer_id'] . ' </b></td>' . chr(10);
echo ' <td><b>' . '<a href="customer.php?customer_id=' . $customer['customer_id'] . '">' . iconHTML('group') . ' ' . $customer['customer_name'] . '</a></b></td>' . chr(10);
echo ' <td><font size="1">' . '<a href="customer_edit.php?customer_id=' . $customer['customer_id'] . '&returnToCustomerList=1">' . iconHTML('group_edit') . ' ' . __('Edit') . '</a>' . ' -:- <a href="entry_list.php?filters=' . $filters_serialized . '">' . iconHTML('page_white') . ' ' . __('View entries') . '</a>' . '</font></td>' . chr(10);
echo ' </tr>' . chr(10) . chr(10);
}
}
echo '</table>' . chr(10);
function filterLink($filtertable, $return_to = '')
{
$filtertable_serialized = filterSerialized($filtertable);
echo '[ <font size="1">';
echo '<img height="12" src="./img/icons/table_multiple.png" style="border: 0px solid black; vertical-align: middle;"> ' . '<a href="entry_filters.php?filters=' . $filtertable_serialized . '&return_to=' . $return_to . '">' . __('View / Edit filters') . '</a> -:- ';
echo '<img height="12" src="./img/icons/table.png" style="border: 0px solid black; vertical-align: middle;"> ' . '<a href="entry_list.php?filters=' . $filtertable_serialized . '">' . __('Entry list') . '</a> -:- ';
echo '<img height="12" src="./img/icons/chart_bar.png" style="border: 0px solid black; vertical-align: middle;"> ' . '<a href="entry_stat.php?filters=' . $filtertable_serialized . '">' . __('Statistics') . '</a> -:- ';
echo '<img height="12" src="./img/icons/group.png" style="border: 0px solid black; vertical-align: middle;"> ' . '<a href="entry_list.php?listtype=customer_list&filters=' . $filtertable_serialized . '">' . _h('Customer list') . '</a> ';
echo '<img height="12" src="./img/icons/icon-file-excel.gif" style="border: 0px solid black; vertical-align: middle;"> ' . '<a href="entry_list_export_excel.php?filters=' . $filtertable_serialized . '">' . _h('Entry list in Excel') . '</a> ';
echo '</font> ]';
}
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
*/
// Include the datagetting (also used by charts.php)
require "include/entry_stat.php";
echo '<script src="js/jquery-1.3.2.js" type="text/javascript"></script>';
echo '<script src="js/jquery.blockUI.js" type="text/javascript"></script>';
echo '<script src="js/entry-stat.js" type="text/javascript"></script>';
echo '<div class="hiddenprint">';
echo '<a href="export_excel.php?filters=' . filterSerialized($filters) . '">' . iconFiletype('xls') . ' Eksporter til Excel</a><br><br>';
echo '</div>' . chr(10);
echo '<div style="display: none;" id="filters">' . filterSerialized($filters) . '</div>';
echo '<div class="hiddenprint"><h2>Kommunefordelt</h2>';
echo '<a id="switchlink1" href="javascript:switchView(1, \'kommunefordelt\');">Vis kommunefordelt</a><br><br>';
echo '</div>';
echo '<div style="display:none;" id="switch1">';
//echo ' <h2 class="print">Kommunefordelt</h2>';
echo ' <table cellspacing="0" style="border-collapse: collapse;">' . chr(10);
echo ' <caption>Kommunefordelt statistikk</caption>' . chr(10);
echo ' <tr>' . chr(10);
echo ' <td class="border">' . __('Municipal') . '</th>' . chr(10);
echo ' <th class="border" headers="children">' . '<img src="./img/icons/user_small.png" style="border: 0px solid black; vertical-align: middle;"> ' . __('Children') . '</th>' . chr(10);
echo ' <th class="border" headers="adults">' . '<img src="./img/icons/user_suit.png" style="border: 0px solid black; vertical-align: middle;"> ' . __('Adults') . '</th>' . chr(10);
echo ' <th class="border">' . __('Total') . '</th>' . chr(10);
echo ' <th class="border">' . '<img src="./img/icons/page_white.png" style="border: 0px solid black; vertical-align: middle;"> ' . __('Entries') . '</th>' . chr(10);
echo ' </tr>' . chr(10);
foreach ($municipals3 as $mun_num => $name) {
$c = $customer_list[$customer_id];
echo ' <tr>' . chr(10);
echo ' <td>';
if ($c['customer_id'] > 0) {
echo '<a href="customer.php?customer_id=' . $c['customer_id'] . '">';
}
echo $c['customer_name'];
if ($c['customer_id'] > 0) {
echo '</a>';
}
echo '</td>';
echo ' <td style="text-align: center;">' . $c['c'] . ' / ' . $c['a'] . '</td>' . chr(10);
echo ' <td>';
$tmpfilter = $filters;
$tmpfilter = addFilter($tmpfilter, 'customer_id', $c['customer_id']);
echo '<a href="entry_list.php?filters=' . filterSerialized($tmpfilter) . '">';
echo $c['e'] . ' boooking';
if ($c['e'] != '1') {
echo 'er';
}
echo '</a>';
echo '</td>' . chr(10);
echo ' </tr>' . chr(10);
}
}
echo '</table>';
}
if (isset($_GET['emaillist']) && $_GET['emaillist'] == 1) {
echo '<textarea rows="60" cols="150">';
echo implode("\n", $emaillist_entry);
echo '</textarea>';
