xt eCommerce Templates Module SEO Support: Open Source Shoppingcart ERP CRM: Admin Übersicht Statistik

[kunigunde]

ist bisher noch recht einfach gehalten, kann aber nat. von jedem erweitert werden. :D

in der Datei:
admin/start.php

nach der zeile:
<?php include(DIR_WS_MODULES.FILENAME_SECURITY_CHECK); ?>

einfügen:

<?php
**$customers_query = xtc_db_query("select count( ) as count from " . TABLE_CUSTOMERS);
**$customers = xtc_db_fetch_array($customers_query);
**$newsletter_query = xtc_db_query("select count( ) as count from " . TABLE_CUSTOMERS. " where customers_newsletter = '1'");
**$newsletter = xtc_db_fetch_array($newsletter_query);
**$products_query = xtc_db_query("select count( ) as count from " . TABLE_PRODUCTS . " where products_status = '1'");
**$products = xtc_db_fetch_array($products_query);
**$products1_query = xtc_db_query("select count( ) as count from " . TABLE_PRODUCTS . " where products_status = '0'");
**$products1 = xtc_db_fetch_array($products1_query);
**$products2_query = xtc_db_query("select count( ) as count from " . TABLE_PRODUCTS . "");
**$products2 = xtc_db_fetch_array($products2_query);
**$orders0_query = xtc_db_query("select count( ) as count from " . TABLE_ORDERS . " where orders_status = '0'");
**$orders0 = xtc_db_fetch_array($orders0_query);
**$orders1_query = xtc_db_query("select count( ) as count from " . TABLE_ORDERS . " where orders_status = '1'");
**$orders1 = xtc_db_fetch_array($orders1_query);
**$orders2_query = xtc_db_query("select count( ) as count from " . TABLE_ORDERS . " where orders_status = '2'");
**$orders2 = xtc_db_fetch_array($orders2_query);
**$orders3_query = xtc_db_query("select count( ) as count from " . TABLE_ORDERS . " where orders_status = '3'");
**$orders3 = xtc_db_fetch_array($orders3_query);
**$specials_query = xtc_db_query("select count( ) as count from " . TABLE_SPECIALS);
**$specials = xtc_db_fetch_array($specials_query);
**
?>
<div align="center">
<h2>Statistik Übersnicht</h2>
****<table width="30%" border="1">
********<tr>
************<td align="center" colspan="2">Kunden</td>
********</tr>
********<tr>
************<td>Kunden:</td>
************<td><?php echo $customers['count']; ?></td>
********</tr>
********<tr>
************<td>Newsletter Abo:</td>
************<td><?php echo $newsletter['count']; ?></td>
********</tr>
********<tr>
************<td colspan="2">*</td>
********</tr>
********<tr>
************<td align="center" colspan="2">Artikel</td>
********</tr>
********<tr>
************<td>Aktive Artikel:</td>
************<td><?php echo $products['count']; ?></td>
********</tr>
********<tr>
************<td>Inaktive Artikel:</td>
************<td><?php echo $products1['count']; ?></td>
********</tr>
********<tr>
************<td>Artikel gesamt:</td>
************<td><?php echo $products2['count']; ?></td>
********</tr>
********<tr>
************<td>Sonderangebote:</td>
************<td><?php echo $specials['count']; ?></td>
********</tr>
********<tr>
************<td colspan="2">*</td>
********</tr>
********<tr>
************<td align="center" colspan="2">Bestellungen</td>
********</tr>
********<tr>
************<td>Offen:</td>
************<td><?php echo $orders1['count']; ?></td>
********</tr>
********<tr>
************<td>In Bearbeitung:</td>
************<td><?php echo $orders2['count']; ?></td>
********</tr>
********<tr>
************<td>Versendet:</td>
************<td><?php echo $orders3['count']; ?></td>
********</tr>
********<tr>
************<td>nicht Bestätigt:</td>
************<td><?php echo $orders0['count']; ?></td>
********</tr>
****</table>
</div>


falls jemand bereits die geburtstag überprüfung integriert hat, einfach genau danach einfügen nach: