25 lines
No EOL
1.3 KiB
PHP
25 lines
No EOL
1.3 KiB
PHP
<?php
|
|
$jahr = (int)date('Y');
|
|
$timecall=mktime(0, 0, 0, 1, 1,date('Y'));
|
|
//----------------------------------------------- Abfrage Menge SMS dieses Jahr
|
|
$abfrage1 = $GLOBALS['mysql']->query_single("SELECT * FROM log_sms WHERE logtime>'".$timecall."'");
|
|
$template->assign('summejahr',$abfrage1['num_rows']);
|
|
//-----------------------------------------------
|
|
$abfrage2 = $GLOBALS['mysql']->query_single("SELECT * FROM log_sms WHERE logtime>'".$timecall."' and status=20");
|
|
$template->assign('warten',$abfrage2['num_rows']);
|
|
//-----------------------------------------------
|
|
$abfrage3 = $GLOBALS['mysql']->query_single("SELECT * FROM log_sms WHERE logtime>'".$timecall."' and errorId>0");
|
|
$template->assign('fehler',$abfrage3['num_rows']);
|
|
//-----------------------------------------------
|
|
$abfrage4 = $GLOBALS['mysql']->query_single("SELECT * FROM log_sms WHERE logtime>'".$timecall."' and status=2");
|
|
$template->assign('fertig',$abfrage4['num_rows']);
|
|
//-----------------------------------------------
|
|
$abfrage5 = $GLOBALS['mysql']->query_single("SELECT * FROM log_sms WHERE logtime>'".$timecall."' and status!=2");
|
|
$template->assign('unklar',$abfrage5['num_rows']);
|
|
//-----------------------------------------------
|
|
|
|
|
|
|
|
|
|
//-----------------------------------------------
|
|
$template->assign('content', 'tpl/ajax/smslog.tpl'); |