/** * Generates statistics page for the given period * * @param iMSCP_pTemplate $tpl template engine instance * @return void */ function generatePage($tpl) { if (isset($_GET['month']) && isset($_GET['year'])) { $year = intval($_GET['year']); $month = intval($_GET['month']); } else { if (isset($_POST['month']) && isset($_POST['year'])) { $year = intval($_POST['year']); $month = intval($_POST['month']); } else { $month = date('m'); $year = date('y'); } } $stmt = exec_query('SELECT traff_time FROM server_traffic ORDER BY traff_time ASC LIMIT 1'); if ($stmt->rowCount()) { $row = $stmt->fetchRow(PDO::FETCH_ASSOC); $numberYears = date('y') - date('y', $row['traff_time']); $numberYears = $numberYears ? $numberYears + 1 : 1; } else { $numberYears = 1; } generateMonthsAndYearsHtmlList($tpl, $month, $year, $numberYears); $stmt = exec_query('SELECT bytes_in FROM server_traffic WHERE traff_time BETWEEN ? AND ? LIMIT 1', array(getFirstDayOfMonth($month, $year), getLastDayOfMonth($month, $year))); if ($stmt->rowCount()) { if ($month == date('m') && $year == date('y')) { $curday = date('j'); } else { $curday = date('j', getLastDayOfMonth($month, $year)); } $all = array_fill(0, 8, 0); for ($day = 1; $day <= $curday; $day++) { $beginDate = mktime(0, 0, 0, $month, $day, $year); $endDate = mktime(23, 59, 59, $month, $day, $year); list($webIn, $webOut, $smtpIn, $smtpOut, $popIn, $popOut, $otherIn, $otherOut, $allIn, $allOut) = _getServerTraffic($beginDate, $endDate); $tpl->assign(array('DAY' => tohtml($day), 'YEAR' => tohtml($year), 'MONTH' => tohtml($month), 'WEB_IN' => tohtml(bytesHuman($webIn)), 'WEB_OUT' => tohtml(bytesHuman($webOut)), 'SMTP_IN' => tohtml(bytesHuman($smtpIn)), 'SMTP_OUT' => tohtml(bytesHuman($smtpOut)), 'POP_IN' => tohtml(bytesHuman($popIn)), 'POP_OUT' => tohtml(bytesHuman($popOut)), 'OTHER_IN' => tohtml(bytesHuman($otherIn)), 'OTHER_OUT' => tohtml(bytesHuman($otherOut)), 'ALL_IN' => tohtml(bytesHuman($allIn)), 'ALL_OUT' => tohtml(bytesHuman($allOut)), 'ALL' => tohtml(bytesHuman($allIn + $allOut)), 'DAY_STATS_QSTRING' => tohtml("year={$year}&month={$month}&day={$day}", 'htmlAttr'))); $all[0] += $webIn; $all[1] += $webOut; $all[2] += $smtpIn; $all[3] += $smtpOut; $all[4] += $popIn; $all[5] += $popOut; $all[6] += $allIn; $all[7] += $allOut; $tpl->parse('DAY_SERVER_STATISTICS_BLOCK', '.day_server_statistics_block'); } $allOtherIn = $all[6] - ($all[0] + $all[2] + $all[4]); $allOtherOut = $all[7] - ($all[1] + $all[3] + $all[5]); $tpl->assign(array('WEB_IN_ALL' => tohtml(bytesHuman($all[0])), 'WEB_OUT_ALL' => tohtml(bytesHuman($all[1])), 'SMTP_IN_ALL' => tohtml(bytesHuman($all[2])), 'SMTP_OUT_ALL' => tohtml(bytesHuman($all[3])), 'POP_IN_ALL' => tohtml(bytesHuman($all[4])), 'POP_OUT_ALL' => tohtml(bytesHuman($all[5])), 'OTHER_IN_ALL' => tohtml(bytesHuman($allOtherIn)), 'OTHER_OUT_ALL' => tohtml(bytesHuman($allOtherOut)), 'ALL_IN_ALL' => tohtml(bytesHuman($all[6])), 'ALL_OUT_ALL' => tohtml(bytesHuman($all[7])), 'ALL_ALL' => tohtml(bytesHuman($all[6] + $all[7])))); } else { set_page_message(tr('No statistics found for the given period. Try another period.'), 'static_info'); $tpl->assign('SERVER_STATISTICS_BLOCK', ''); } }
/** * Generate statistics for the given period * * @param iMSCP_pTemplate $tpl Template engine instance * @return void */ function generatePage($tpl) { $domainId = get_user_domain_id($_SESSION['user_id']); if (isset($_POST['month']) && isset($_POST['year'])) { $year = intval($_POST['year']); $month = intval($_POST['month']); } else { if (isset($_GET['month']) && isset($_GET['year'])) { $month = intval($_GET['month']); $year = intval($_GET['year']); } else { $month = date('m'); $year = date('Y'); } } $stmt = exec_query('SELECT dtraff_time FROM domain_traffic WHERE domain_id = ? ORDER BY dtraff_time ASC LIMIT 1', $domainId); if ($stmt->rowCount()) { $row = $stmt->fetchRow(PDO::FETCH_ASSOC); $numberYears = date('y') - date('y', $row['dtraff_time']); $numberYears = $numberYears ? $numberYears + 1 : 1; } else { $numberYears = 1; } generateMonthsAndYearsHtmlList($tpl, $month, $year, $numberYears); $stmt = exec_query('SELECT domain_id FROM domain_traffic WHERE domain_id = ? AND dtraff_time >= ? AND dtraff_time <= ? LIMIT 1', array($domainId, getFirstDayOfMonth($month, $year), getLastDayOfMonth($month, $year))); if ($stmt->rowCount()) { $requestedPeriod = getLastDayOfMonth($month, $year); $toDay = $requestedPeriod < time() ? date('j', $requestedPeriod) : date('j'); $all = array_fill(0, 8, 0); $dateFormat = iMSCP_Registry::get('config')->DATE_FORMAT; for ($fromDay = 1; $fromDay <= $toDay; $fromDay++) { $beginTime = mktime(0, 0, 0, $month, $fromDay, $year); $endTime = mktime(23, 59, 59, $month, $fromDay, $year); list($webTraffic, $ftpTraffic, $smtpTraffic, $popTraffic) = _getUserTraffic($domainId, $beginTime, $endTime); $tpl->assign(array('DATE' => tohtml(date($dateFormat, strtotime($year . '-' . $month . '-' . $fromDay))), 'WEB_TRAFF' => tohtml(bytesHuman($webTraffic)), 'FTP_TRAFF' => tohtml(bytesHuman($ftpTraffic)), 'SMTP_TRAFF' => tohtml(bytesHuman($smtpTraffic)), 'POP_TRAFF' => tohtml(bytesHuman($popTraffic)), 'SUM_TRAFF' => tohtml(bytesHuman($webTraffic + $ftpTraffic + $smtpTraffic + $popTraffic)))); $all[0] += $webTraffic; $all[1] += $ftpTraffic; $all[2] += $smtpTraffic; $all[3] += $popTraffic; $tpl->parse('TRAFFIC_TABLE_ITEM', '.traffic_table_item'); } $tpl->assign(array('WEB_ALL' => tohtml(bytesHuman($all[0])), 'FTP_ALL' => tohtml(bytesHuman($all[1])), 'SMTP_ALL' => tohtml(bytesHuman($all[2])), 'POP_ALL' => tohtml(bytesHuman($all[3])), 'SUM_ALL' => tohtml(bytesHuman(array_sum($all))))); } else { set_page_message(tr('No statistics found for the given period. Try another period.'), 'static_info'); $tpl->assign('STATISTICS_BLOCK', ''); } }
/** * Generates page * * @param iMSCP_pTemplate $tpl Template instance engine * @param int $domainId Domain unique identifier * @return void */ function admin_generatePage($tpl, $domainId) { $stmt = exec_query('SELECT domain_admin_id FROM domain WHERE domain_id = ?', $domainId); if (!$stmt->rowCount()) { showBadRequestErrorPage(); } $domainAdminId = $stmt->fields['domain_admin_id']; $domainProperties = get_domain_default_props($domainAdminId); // Domain IP address info $stmt = exec_query("SELECT ip_number FROM server_ips WHERE ip_id = ?", $domainProperties['domain_ip_id']); if (!$stmt->rowCount()) { $domainIpAddr = tr('Not found.'); } else { $domainIpAddr = $stmt->fields['ip_number']; } $domainStatus = $domainProperties['domain_status']; // Domain status if ($domainStatus == 'ok' || $domainStatus == 'disabled' || $domainStatus == 'todelete' || $domainStatus == 'toadd' || $domainStatus == 'torestore' || $domainStatus == 'tochange' || $domainStatus == 'toenable' || $domainStatus == 'todisable') { $domainStatus = '<span style="color:green">' . tohtml(translate_dmn_status($domainStatus)) . '</span>'; } else { $domainStatus = '<b><font size="3" color="red">' . $domainStatus . "</font></b>"; } // Get total domain traffic usage in bytes $query = "\n\t\tSELECT\n\t\t\tIFNULL(SUM(dtraff_web), 0) AS dtraff_web, IFNULL(SUM(dtraff_ftp), 0) AS dtraff_ftp,\n\t\t\tIFNULL(SUM(dtraff_mail), 0) AS dtraff_mail, IFNULL(SUM(dtraff_pop), 0) AS dtraff_pop\n\t\tFROM\n\t\t\tdomain_traffic\n\t\tWHERE\n\t\t\tdomain_id = ?\n\t\tAND\n\t\t\tdtraff_time BETWEEN ? AND ?\n\t"; $stmt = exec_query($query, array($domainProperties['domain_id'], getFirstDayOfMonth(), getLastDayOfMonth())); if ($stmt->rowCount()) { $trafficUsageBytes = $stmt->fields['dtraff_web'] + $stmt->fields['dtraff_ftp'] + $stmt->fields['dtraff_mail'] + $stmt->fields['dtraff_pop']; } else { $trafficUsageBytes = 0; } // Get limits in bytes $trafficLimitBytes = $domainProperties['domain_traffic_limit'] * 1048576; $diskspaceLimitBytes = $domainProperties['domain_disk_limit'] * 1048576; // Get usages in percent $trafficUsagePercent = make_usage_vals($trafficUsageBytes, $trafficLimitBytes); $diskspaceUsagePercent = make_usage_vals($domainProperties['domain_disk_usage'], $diskspaceLimitBytes); // Get Email quota info list($quota, $quotaLimit) = admin_gen_mail_quota_limit_mgs($domainAdminId); # Features $tpl->assign(array('DOMAIN_ID' => $domainId, 'VL_DOMAIN_NAME' => tohtml(decode_idna($domainProperties['domain_name'])), 'VL_DOMAIN_IP' => tohtml($domainIpAddr), 'VL_STATUS' => $domainStatus, 'VL_PHP_SUPP' => translate_limit_value($domainProperties['domain_php']), 'VL_PHP_EDITOR_SUPP' => translate_limit_value($domainProperties['phpini_perm_system']), 'VL_CGI_SUPP' => translate_limit_value($domainProperties['domain_cgi']), 'VL_DNS_SUPP' => translate_limit_value($domainProperties['domain_dns']), 'VL_EXT_MAIL_SUPP' => translate_limit_value($domainProperties['domain_external_mail']), 'VL_SOFTWARE_SUPP' => translate_limit_value($domainProperties['domain_software_allowed']), 'VL_BACKUP_SUP' => translate_limit_value($domainProperties['allowbackup']), 'VL_TRAFFIC_PERCENT' => $trafficUsagePercent, 'VL_TRAFFIC_USED' => bytesHuman($trafficUsageBytes), 'VL_TRAFFIC_LIMIT' => bytesHuman($trafficLimitBytes), 'VL_DISK_PERCENT' => $diskspaceUsagePercent, 'VL_DISK_USED' => bytesHuman($domainProperties['domain_disk_usage']), 'VL_DISK_LIMIT' => bytesHuman($diskspaceLimitBytes), 'VL_MAIL_ACCOUNTS_USED' => get_domain_running_mail_acc_cnt($domainId), 'VL_MAIL_ACCOUNTS_LIMIT' => translate_limit_value($domainProperties['domain_mailacc_limit']), 'VL_MAIL_QUOTA_USED' => $quota, 'VL_MAIL_QUOTA_LIMIT' => $domainProperties['domain_mailacc_limit'] != '-1' ? $quotaLimit : tr('Disabled'), 'VL_FTP_ACCOUNTS_USED' => get_customer_running_ftp_acc_cnt($domainAdminId), 'VL_FTP_ACCOUNTS_LIMIT' => translate_limit_value($domainProperties['domain_ftpacc_limit']), 'VL_SQL_DB_ACCOUNTS_USED' => get_domain_running_sqld_acc_cnt($domainId), 'VL_SQL_DB_ACCOUNTS_LIMIT' => translate_limit_value($domainProperties['domain_sqld_limit']), 'VL_SQL_USER_ACCOUNTS_USED' => get_domain_running_sqlu_acc_cnt($domainId), 'VL_SQL_USER_ACCOUNTS_LIMIT' => translate_limit_value($domainProperties['domain_sqlu_limit']), 'VL_SUBDOM_ACCOUNTS_USED' => get_domain_running_sub_cnt($domainId), 'VL_SUBDOM_ACCOUNTS_LIMIT' => translate_limit_value($domainProperties['domain_subd_limit']), 'VL_DOMALIAS_ACCOUNTS_USED' => get_domain_running_als_cnt($domainId), 'VL_DOMALIAS_ACCOUNTS_LIMIT' => translate_limit_value($domainProperties['domain_alias_limit']))); }
define('DEFAULT_SICK_LEAVE_HRS', 320); define('DEFAULT_REGULAR_LEAVE_DAYS', 21); define('DEFAULT_SICK_LEAVE_DAYS', 4); define('HOURS_IN_DAY', 8); define('HOURS_IN_WEEK', 40); define('DEFAULT_WORKING_DAYS', '1,2,3,4,5'); define('DEFAULT_COMPANYID', 1); define('PAYEID', 2); define('NSSFID', 3); define('ADVANCE', 5); define('TPID', 9); define('DEFAULT_NSSF_EMP', 5); define('DEFAULT_NSSF_COM', 10); define('DEFAULT_LUNCH_DURATION', 1); define('DEFAULT_APPNAME_CHARS', 12); define('YEAR_START', getFirstDayOfMonth(1, date('Y'))); define('YEAR_END', getLastDayOfMonth(12, date('Y'))); function companiesRequireApproval() { $config = Zend_Registry::get("config"); return $config->system->approvalrequired == 'on' || $config->system->approvalrequired == '1' ? true : false; } function getDefaultCharsForAppName() { $config = Zend_Registry::get("config"); return $config->system->appnamechars; } function getTrialDays() { $config = Zend_Registry::get("config"); return $config->system->daysoftrial;
public function init() { parent::init(); $current_timestamp = strtotime('now'); $now_iso = date('Y-m-d H:i:s', $current_timestamp); $this->view->now_iso = $now_iso; //debugMessage('now '.$now_iso.'-'.$current_timestamp); $onehourago_timestamp = strtotime('-1 hour'); $onehourago_iso = date('Y-m-d H:i:s', $onehourago_timestamp); $this->view->onehourago_iso = $onehourago_iso; $this->view->onehourago_timestamp = $onehourago_timestamp; // debugMessage('now '.$onehourago_iso.'-'.$onehourago_timestamp); $sixhourago_timestamp = strtotime('-6 hour'); $sixhourago_iso = date('Y-m-d H:i:s', $sixhourago_timestamp); $this->view->sixhourago_iso = $sixhourago_iso; $this->view->sixhourago_timestamp = $sixhourago_timestamp; $twelvehourago_timestamp = strtotime('-12 hour'); $twelvehourago_iso = date('Y-m-d H:i:s', $twelvehourago_timestamp); $this->view->twelvehourago_timestamp = $twelvehourago_timestamp; $this->view->twelvehourago_iso = $twelvehourago_iso; // debugMessage($logged_today_sql); $today_iso = date('Y-m-d'); $today = changeMySQLDateToPageFormat($today_iso); $this->view->today_iso = $today_iso; //debugMessage('today '.$today_iso); $today_iso_short = date('M j', $current_timestamp); $yestday_iso = date('Y-m-d', strtotime('1 day ago')); $yestday = changeMySQLDateToPageFormat($yestday_iso); $this->view->yestday_iso = $yestday_iso; //debugMessage('yesterday '.$yestday_iso); $yestday_iso_short = date('M j', strtotime($yestday_iso)); $weekday = date("N"); // monday of week $mondaythisweek_iso = date('Y-m-d', strtotime('monday this week')); $mondaythisweek = changeMySQLDateToPageFormat($mondaythisweek_iso); if ($weekday == 1) { $mondaythisweek_iso = $today_iso; $mondaythisweek = $today; } if ($weekday == 7) { $mondaythisweek_iso = date('Y-m-d', strtotime('monday last week')); $mondaythisweek = changeMySQLDateToPageFormat($mondaythisweek_iso); } $this->view->mondaythisweek_iso = $mondaythisweek_iso; //debugMessage('monday this week '.$mondaythisweek_iso); // sunday of week $sundaythisweek_iso = date('Y-m-d', strtotime('sunday this week')); $sundaythisweek = changeMySQLDateToPageFormat($sundaythisweek_iso); if ($weekday == 1) { $sundaythisweek_iso = date('Y-m-d', strtotime('today + 7 days')); $sundaythisweek = changeMySQLDateToPageFormat($sundaythisweek_iso); } if ($weekday == 7) { $sundaythisweek_iso = $today_iso; $sundaythisweek = $today; } $this->view->sundaythisweek_iso = $sundaythisweek_iso; // debugMessage('sunday this week '.$sundaythisweek_iso); // monday last week $mondaylastweek_iso = date('Y-m-d', strtotime('-7 days', strtotime($mondaythisweek_iso))); //debugMessage('monday last week '.$mondaylastweek_iso); $this->view->mondaylastweek_iso = $mondaylastweek_iso; // sunday last week $sundaylastweek_iso = date('Y-m-d', strtotime('-7 days', strtotime($sundaythisweek_iso))); // debugMessage('sunday last week '.$sundaylastweek_iso); $this->view->sundaylastweek_iso = $sundaylastweek_iso; // firstday this month $firstdayofthismonth_iso = getFirstDayOfCurrentMonth(); //debugMessage('1st day this month '.$firstdayofthismonth_iso); $this->view->firstdayofthismonth_iso = $firstdayofthismonth_iso; // lastday this month $lastdayofthismonth_iso = getLastDayOfCurrentMonth(); //debugMessage('last day this month '.$lastdayofthismonth_iso); $this->view->lastdayofthismonth_iso = $lastdayofthismonth_iso; // firstday last month $firstdayoflastmonth_iso = getFirstDayOfMonth(date('m') - 1, date('Y')); //debugMessage('1st day last month '.$firstdayoflastmonth_iso); $this->view->firstdayoflastmonth_iso = $firstdayoflastmonth_iso; // lastday last month $lastdayoflastmonth_iso = getLastDayOfMonth(date('m') - 1, date('Y')); //debugMessage('last day last month '.$lastdayoflastmonth_iso); $this->view->lastdayoflastmonth_iso = $lastdayoflastmonth_iso; // firstday 2 month ago $firstdayof2monthago_iso = getFirstDayOfMonth(date('m') - 2, date('Y')); //debugMessage('1st day 2 month ago '.$firstdayof2monthago_iso); $this->view->firstdayof2monthago_iso = $firstdayof2monthago_iso; // lastday 2 month ago $lastdayof2monthago_iso = getLastDayOfMonth(date('m') - 2, date('Y')); //debugMessage('last day last month '.$lastdayof2monthago_iso); $this->view->lastdayof2monthago_iso = $lastdayof2monthago_iso; // firstday 3 month ago $firstdayof3monthago_iso = getFirstDayOfMonth(date('m') - 3, date('Y')); //debugMessage('1st day 3 month ago '.$firstdayof3monthago_iso); $this->view->firstdayof3monthago_iso = $firstdayof3monthago_iso; // lastday 3 month ago $lastdayof3monthago_iso = getLastDayOfMonth(date('m') - 3, date('Y')); //debugMessage('last day last month '.$lastdayof3monthago_iso); $this->view->lastdayof3monthago_iso = $lastdayof3monthago_iso; // firstday this year $firstdayofyear_iso = getFirstDayOfMonth(1, date('Y')); //debugMessage('1st day this year '.$firstdayofyear_iso); $this->view->firstdayofyear_iso = $firstdayofyear_iso; // lastday this year $lastdayofyear_iso = getLastDayOfMonth(12, date('Y')); //debugMessage('last day this year '.$lastdayofyear_iso); $this->view->lastdayofyear_iso = $lastdayofyear_iso; // first day of month one year ago $startofmonth_oneyearago = getFirstDayOfMonth(date('m', strtotime('1 year ago')), date('Y', strtotime('1 year ago'))); $this->view->startofmonth_oneyearago = $startofmonth_oneyearago; $firstsystemday_iso = '2013-01-01'; $this->view->firstsystemday_iso = $firstsystemday_iso; }
/** * Generate page * * @param iMSCP_pTemplate $tpl Template engine instance * @param int $userId User unique identifier * @return void */ function generatePage($tpl, $userId) { $stmt = exec_query(' SELECT admin_name, domain_id FROM admin INNER JOIN domain ON(domain_admin_id = admin_id) WHERE admin_id = ? ', $userId); if (!$stmt->rowCount()) { showBadRequestErrorPage(); } $row = $stmt->fetchRow(PDO::FETCH_ASSOC); $domainId = $row['domain_id']; $adminName = decode_idna($row['admin_name']); if (isset($_POST['month']) && isset($_POST['year'])) { $year = intval($_POST['year']); $month = intval($_POST['month']); } else { $month = date('m'); $year = date('y'); } $stmt = exec_query('SELECT dtraff_time FROM domain_traffic WHERE domain_id = ? ORDER BY dtraff_time ASC LIMIT 1', $domainId); if ($stmt->rowCount()) { $row = $stmt->fetchRow(PDO::FETCH_ASSOC); $numberYears = date('y') - date('y', $row['dtraff_time']); $numberYears = $numberYears ? $numberYears + 1 : 1; } else { $numberYears = 1; } generateMonthsAndYearsHtmlList($tpl, $month, $year, $numberYears); $stmt = exec_query('SELECT domain_id FROM domain_traffic WHERE domain_id = ? AND dtraff_time BETWEEN ? AND ? LIMIT 1', array($domainId, getFirstDayOfMonth($month, $year), getLastDayOfMonth($month, $year))); if ($stmt->rowCount()) { $requestedPeriod = getLastDayOfMonth($month, $year); $toDay = $requestedPeriod < time() ? date('j', $requestedPeriod) : date('j'); $all = array_fill(0, 8, 0); $dateFormat = iMSCP_Registry::get('config')->DATE_FORMAT; for ($fromDay = 1; $fromDay <= $toDay; $fromDay++) { $beginTime = mktime(0, 0, 0, $month, $fromDay, $year); $endTime = mktime(23, 59, 59, $month, $fromDay, $year); list($webTraffic, $ftpTraffic, $smtpTraffic, $popTraffic) = _getUserTraffic($domainId, $beginTime, $endTime); $tpl->assign(array('DATE' => date($dateFormat, strtotime($year . '-' . $month . '-' . $fromDay)), 'WEB_TRAFFIC' => tohtml(bytesHuman($webTraffic)), 'FTP_TRAFFIC' => tohtml(bytesHuman($ftpTraffic)), 'SMTP_TRAFFIC' => tohtml(bytesHuman($smtpTraffic)), 'POP3_TRAFFIC' => tohtml(bytesHuman($popTraffic)), 'ALL_TRAFFIC' => tohtml(bytesHuman($webTraffic + $ftpTraffic + $smtpTraffic + $popTraffic)))); $all[0] += $webTraffic; $all[1] += $ftpTraffic; $all[2] += $smtpTraffic; $all[3] += $popTraffic; $tpl->parse('TRAFFIC_TABLE_ITEM', '.traffic_table_item'); } $tpl->assign(array('USER_ID' => tohtml($userId), 'USERNAME' => tohtml($adminName), 'ALL_WEB_TRAFFIC' => tohtml(bytesHuman($all[0])), 'ALL_FTP_TRAFFIC' => tohtml(bytesHuman($all[1])), 'ALL_SMTP_TRAFFIC' => tohtml(bytesHuman($all[2])), 'ALL_POP3_TRAFFIC' => tohtml(bytesHuman($all[3])), 'ALL_ALL_TRAFFIC' => tohtml(bytesHuman(array_sum($all))))); } else { set_page_message(tr('No statistics found for the given period. Try another period.'), 'static_info'); $tpl->assign(array('USERNAME' => tohtml($adminName), 'USER_ID' => tohtml($userId), 'RESELLER_USER_STATISTICS_DETAIL_BLOCK' => '')); } }
public function setTableDefinition() { parent::setTableDefinition(); $this->setTableName('company'); # override the not null and not blank properties for the createdby column in the BaseEntity $this->hasColumn('createdby', 'integer', 11, array('default' => NULL)); $this->hasColumn('refno', 'string', 15); $this->hasColumn('name', 'string', 255, array('notblank' => true)); $this->hasColumn('appname', 'string', 255); $this->hasColumn('headertype', 'integer', null, array('default' => 0)); $this->hasColumn('slogan', 'string', 255); $this->hasColumn('username', 'string', 255); $this->hasColumn('abbrv', 'string', 255); $this->hasColumn('status', 'integer', null, array('default' => NULL)); $this->hasColumn('contactperson', 'string', 255); $this->hasColumn('email', 'string', 255); $this->hasColumn('phone', 'string', 15); $this->hasColumn('country', 'string', 2, array('default' => 'UG')); $this->hasColumn('addressline1', 'string', 255); $this->hasColumn('addressline2', 'string', 255); $this->hasColumn('city', 'string', 255); $this->hasColumn('postalcode', 'string', 10); $this->hasColumn('industrycode', 'string', 15); $this->hasColumn('description', 'string', 1000); $this->hasColumn('remarks', 'string', 255); $this->hasColumn('yearstart', 'date', null, array('default' => getFirstDayOfMonth(1, date('Y')))); $this->hasColumn('yearend', 'date', null, array('default' => getLastDayOfMonth(12, date('Y')))); $this->hasColumn('ipsubnets', 'string', 255); $this->hasColumn('hoursinday', 'string', 50, array('default' => HOURS_IN_DAY)); $this->hasColumn('openinghour', 'string', 50, array('default' => '08:00 AM')); $this->hasColumn('closinghour', 'string', 50, array('default' => '05:00 PM')); $this->hasColumn('lunchduration', 'string', 50, array('default' => DEFAULT_LUNCH_DURATION)); $this->hasColumn('payspaye', 'string', 50, array('default' => 1)); $this->hasColumn('paysnssf', 'string', 50, array('default' => 1)); $this->hasColumn('nssfemployeerate', 'string', 50, array('default' => DEFAULT_NSSF_EMP)); $this->hasColumn('nssfcompanyrate', 'string', 50, array('default' => DEFAULT_NSSF_COM)); $this->hasColumn('workingdays', 'string', 50); $this->hasColumn('maxhoursperday', 'string', 50, array('default' => HOURS_IN_DAY)); $this->hasColumn('maxhoursperweek', 'string', 50, array('default' => HOURS_IN_WEEK)); $this->hasColumn('defaultuserid', 'integer', null, array('default' => NULL)); $this->hasColumn('dateapproved', 'date', null, array('default' => NULL)); $this->hasColumn('approvedbyid', 'integer', null, array('default' => NULL)); $this->hasColumn('isinvited', 'integer', null, array('default' => NULL)); $this->hasColumn('invitedbyid', 'integer', null); $this->hasColumn('hasacceptedinvite', 'integer', null, array('default' => 0)); $this->hasColumn('dateinvited', 'date'); $this->hasColumn('startdate', 'date', null, array('default' => NULL)); $this->hasColumn('enddate', 'date', null, array('default' => NULL)); $this->hasColumn('layout', 'string', 25, array('default' => getDefaultLayout())); $this->hasColumn('topbar', 'string', 25, array('default' => getDefaultTopBar())); $this->hasColumn('sidebar', 'string', 25, array('default' => getDefaultSideBar())); $this->hasColumn('colortheme', 'string', 25, array('default' => getDefaultTheme())); $this->hasColumn('showsidebar', 'string', 25, array('default' => getDefaultShowSideBar())); $this->hasColumn('logo', 'string', 255); $this->hasColumn('defaultadminname', 'string', 255, array('default' => getDefaultAdminName())); $this->hasColumn('defaultadminemail', 'string', 255, array('default' => getDefaultAdminEmail())); $this->hasColumn('currencysymbol', 'string', 15, array('default' => getCountryCurrencySymbol())); $this->hasColumn('currencycode', 'string', 15, array('default' => getCountryCurrencyCode())); $this->hasColumn('currencydecimalplaces', 'string', 15, array('default' => getCurrencyDecimalPlaces())); $this->hasColumn('numberdecimalplaces', 'string', 15, array('default' => getNumberDecimalPlaces())); $this->hasColumn('countryisocode', 'string', 15, array('default' => getCountryCode())); $this->hasColumn('phonemaxlength', 'string', 15, array('default' => getMaxPhoneLength())); $this->hasColumn('phoneminlength', 'string', 15, array('default' => getMinPhoneLength())); $this->hasColumn('nationalidminlength', 'string', 15, array('default' => getNationalIDMaxLength())); $this->hasColumn('nationalidmaxlength', 'string', 15, array('default' => getNationalIDMinLength())); $this->hasColumn('countryphonecode', 'string', 15, array('default' => getDefaultPhoneCode())); $this->hasColumn('timezone', 'string', 255, array('default' => getTimeZine())); }
$line = fgets($fp, 1024); eregi('<B>([0-9]*)</B>', $line, $out); $visits = $out[1]; do { $line = fgets($fp, 1024); // Finds the KBytes using regular expressions } while (!feof($fp) && !eregi('Total KBytes', $line, $out)); $line = fgets($fp, 1024); eregi('<B>([0-9]*)</B>', $line, $out); $kbytes = $out[1]; do { $line = fgets($fp, 1024); // Finds the Sites using regular expressions } while (!feof($fp) && !eregi('Unique Sites', $line, $out)); $line = fgets($fp, 1024); eregi('<B>([0-9]*)</B>', $line, $out); $sites = $out[1]; fclose($fp); } echo "{$monthn} {$year} {$hits} {$files} {$sites} {$kbytes} " . getFirstDayOfMonth($yearmonth, $year) . ' ' . getLastDayOfMonth($yearmonth, $year) . " {$pages} {$visits}\n"; //echo "$monthn $year\n"; $yearmonth--; if ($yearmonth == 0) { $yearmonth = 12; $year--; } // Year goes backwards until 2000 if ($year == 2000) { break; } }
function showMonth($month, $year, $unterkunft_id, $zimmer_id, $link, $saAktiviert, $sprache) { //anzahl der tage des monats: $anzahlTage = getNumberOfDays($month, $year); $firstDay = getFirstDayOfMonth($month, $year); $MO = getUebersetzung("MO", $sprache, $link); $DI = getUebersetzung("DI", $sprache, $link); $MI = getUebersetzung("MI", $sprache, $link); $DO = getUebersetzung("DO", $sprache, $link); $FR = getUebersetzung("FR", $sprache, $link); $SA = getUebersetzung("SA", $sprache, $link); $SO = getUebersetzung("SO", $sprache, $link); //erste tag im monat ist ein montag: if ($firstDay == "Mon") { ?> <table width="100%" border="0" class="tableColor"> <tr> <td colspan="7" class="standardSchriftBold"><?php echo getUebersetzung(parseMonthName($month), $sprache, $link) . " " . $year; ?> </td> </tr> <tr> <td class="tableColor"><?php echo $MO; ?> </td> <td class="tableColor"><?php echo $DI; ?> </td> <td class="tableColor"><?php echo $MI; ?> </td> <td class="tableColor"><?php echo $DO; ?> </td> <td class="tableColor"><?php echo $FR; ?> </td> <td class="tableColor"><?php echo $SA; ?> </td> <td class="tableColor"><?php echo $SO; ?> </td> </tr> <tr> <?php for ($i = 1; $i <= 7; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 8; $i <= 14; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 15; $i <= 21; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 22; $i <= 28; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <td class="<?php if ($anzahlTage >= 29) { echo getStatusString($zimmer_id, 29, $month, $year, $saAktiviert, $link); } else { echo "tableColor"; } ?> "><?php if ($anzahlTage >= 29) { printRes($zimmer_id, 29, $month, $year, $saAktiviert, $link); } else { echo " "; } ?> </td> <td class="<?php if ($anzahlTage >= 30) { echo getStatusString($zimmer_id, 30, $month, $year, $saAktiviert, $link); } else { echo "tableColor"; } ?> "><?php if ($anzahlTage >= 30) { printRes($zimmer_id, 30, $month, $year, $saAktiviert, $link); } else { echo " "; } ?> </td> <td class="<?php if ($anzahlTage >= 31) { echo getStatusString($zimmer_id, 31, $month, $year, $saAktiviert, $link); } else { echo "tableColor"; } ?> "><?php if ($anzahlTage >= 31) { printRes($zimmer_id, 31, $month, $year, $saAktiviert, $link); } else { echo " "; } ?> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> </tr> <tr> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> </tr> </table><?php } elseif ($firstDay == "Tue") { ?> <table width="100%" border="0" class="tableColor"> <tr> <td colspan="7" class="standardSchriftBold"><?php echo getUebersetzung(parseMonthName($month), $sprache, $link) . " " . $year; ?> </td> </tr> <tr> <td class="tableColor"><?php echo $MO; ?> </td> <td class="tableColor"><?php echo $DI; ?> </td> <td class="tableColor"><?php echo $MI; ?> </td> <td class="tableColor"><?php echo $DO; ?> </td> <td class="tableColor"><?php echo $FR; ?> </td> <td class="tableColor"><?php echo $SA; ?> </td> <td class="tableColor"><?php echo $SO; ?> </td> </tr> <tr> <td class="tableColor"> </td> <?php for ($i = 1; $i <= 6; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 7; $i <= 13; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 14; $i <= 20; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 21; $i <= 27; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <td class="<?php if ($anzahlTage >= 29) { echo getStatusString($zimmer_id, 29, $month, $year, $saAktiviert, $link); } else { echo "tableColor"; } ?> "><?php if ($anzahlTage >= 29) { printRes($zimmer_id, 29, $month, $year, $saAktiviert, $link); } else { echo " "; } ?> </td> <td class="<?php if ($anzahlTage >= 30) { echo getStatusString($zimmer_id, 30, $month, $year, $saAktiviert, $link); } else { echo "tableColor"; } ?> "><?php if ($anzahlTage >= 30) { printRes($zimmer_id, 30, $month, $year, $saAktiviert, $link); } else { echo " "; } ?> </td> <td class="<?php if ($anzahlTage >= 31) { echo getStatusString($zimmer_id, 31, $month, $year, $saAktiviert, $link); } else { echo "tableColor"; } ?> "><?php if ($anzahlTage >= 31) { printRes($zimmer_id, 31, $month, $year, $saAktiviert, $link); } else { echo " "; } ?> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> </tr> <tr> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> </tr> </table><?php } elseif ($firstDay == "Wed") { ?> <table width="100%" border="0" class="tableColor"> <tr> <td colspan="7" class="standardSchriftBold"><?php echo getUebersetzung(parseMonthName($month), $sprache, $link) . " " . $year; ?> </td> </tr> <tr> <td class="tableColor"><?php echo $MO; ?> </td> <td class="tableColor"><?php echo $DI; ?> </td> <td class="tableColor"><?php echo $MI; ?> </td> <td class="tableColor"><?php echo $DO; ?> </td> <td class="tableColor"><?php echo $FR; ?> </td> <td class="tableColor"><?php echo $SA; ?> </td> <td class="tableColor"><?php echo $SO; ?> </td> </tr> <tr> <td class="tableColor"> </td> <td class="tableColor"> </td> <?php for ($i = 1; $i <= 5; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 6; $i <= 12; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 13; $i <= 19; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 20; $i <= 26; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 27; $i <= 28; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> <td class="<?php if ($anzahlTage >= 29) { echo getStatusString($zimmer_id, 29, $month, $year, $saAktiviert, $link); } else { echo "tableColor"; } ?> "><?php if ($anzahlTage >= 29) { printRes($zimmer_id, 29, $month, $year, $saAktiviert, $link); } else { echo " "; } ?> </td> <td class="<?php if ($anzahlTage >= 30) { echo getStatusString($zimmer_id, 30, $month, $year, $saAktiviert, $link); } else { echo "tableColor"; } ?> "><?php if ($anzahlTage >= 30) { printRes($zimmer_id, 30, $month, $year, $saAktiviert, $link); } else { echo " "; } ?> </td> <td class="<?php if ($anzahlTage >= 31) { echo getStatusString($zimmer_id, 31, $month, $year, $saAktiviert, $link); } else { echo "tableColor"; } ?> "><?php if ($anzahlTage >= 31) { printRes($zimmer_id, 31, $month, $year, $saAktiviert, $link); } else { echo " "; } ?> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> </tr> <tr> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> </tr> </table><?php } elseif ($firstDay == "Thu") { ?> <table width="100%" border="0" class="tableColor"> <tr> <td colspan="7" class="standardSchriftBold"><?php echo getUebersetzung(parseMonthName($month), $sprache, $link) . " " . $year; ?> </td> </tr> <tr> <td class="tableColor"><?php echo $MO; ?> </td> <td class="tableColor"><?php echo $DI; ?> </td> <td class="tableColor"><?php echo $MI; ?> </td> <td class="tableColor"><?php echo $DO; ?> </td> <td class="tableColor"><?php echo $FR; ?> </td> <td class="tableColor"><?php echo $SA; ?> </td> <td class="tableColor"><?php echo $SO; ?> </td> </tr> <tr> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <?php for ($i = 1; $i <= 4; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 5; $i <= 11; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 12; $i <= 18; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 19; $i <= 25; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 26; $i <= 28; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> <td class="<?php if ($anzahlTage >= 29) { echo getStatusString($zimmer_id, 29, $month, $year, $saAktiviert, $link); } else { echo "tableColor"; } ?> "><?php if ($anzahlTage >= 29) { printRes($zimmer_id, 29, $month, $year, $saAktiviert, $link); } else { echo " "; } ?> </td> <td class="<?php if ($anzahlTage >= 30) { echo getStatusString($zimmer_id, 30, $month, $year, $saAktiviert, $link); } else { echo "tableColor"; } ?> "><?php if ($anzahlTage >= 30) { printRes($zimmer_id, 30, $month, $year, $saAktiviert, $link); } else { echo " "; } ?> </td> <td class="<?php if ($anzahlTage >= 31) { echo getStatusString($zimmer_id, 31, $month, $year, $saAktiviert, $link); } else { echo "tableColor"; } ?> "><?php if ($anzahlTage >= 31) { printRes($zimmer_id, 31, $month, $year, $saAktiviert, $link); } else { echo " "; } ?> </td> <td class="tableColor"> </td> </tr> <tr> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> </tr> </table><?php } elseif ($firstDay == "Fri") { ?> <table width="100%" border="0" class="tableColor"> <tr> <td colspan="7" class="standardSchriftBold"><?php echo getUebersetzung(parseMonthName($month), $sprache, $link) . " " . $year; ?> </td> </tr> <tr> <td class="tableColor"><?php echo $MO; ?> </td> <td class="tableColor"><?php echo $DI; ?> </td> <td class="tableColor"><?php echo $MI; ?> </td> <td class="tableColor"><?php echo $DO; ?> </td> <td class="tableColor"><?php echo $FR; ?> </td> <td class="tableColor"><?php echo $SA; ?> </td> <td class="tableColor"><?php echo $SO; ?> </td> </tr> <tr> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <?php for ($i = 1; $i <= 3; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 4; $i <= 10; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 11; $i <= 17; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 18; $i <= 24; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 25; $i <= 28; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> <td class="<?php if ($anzahlTage >= 29) { echo getStatusString($zimmer_id, 29, $month, $year, $saAktiviert, $link); } else { echo "tableColor"; } ?> "><?php if ($anzahlTage >= 29) { printRes($zimmer_id, 29, $month, $year, $saAktiviert, $link); } else { echo " "; } ?> </td> <td class="<?php if ($anzahlTage >= 30) { echo getStatusString($zimmer_id, 30, $month, $year, $saAktiviert, $link); } else { echo "tableColor"; } ?> "><?php if ($anzahlTage >= 30) { printRes($zimmer_id, 30, $month, $year, $saAktiviert, $link); } else { echo " "; } ?> </td> <td class="<?php if ($anzahlTage >= 31) { echo getStatusString($zimmer_id, 31, $month, $year, $saAktiviert, $link); } else { echo "tableColor"; } ?> "><?php if ($anzahlTage >= 31) { printRes($zimmer_id, 31, $month, $year, $saAktiviert, $link); } else { echo " "; } ?> </td> </tr> <tr> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> </tr> </table><?php } elseif ($firstDay == "Sat") { ?> <table width="100%" border="0" class="tableColor"> <tr> <td colspan="7" class="standardSchriftBold"><?php echo getUebersetzung(parseMonthName($month), $sprache, $link) . " " . $year; ?> </td> </tr> <tr> <td class="tableColor"><?php echo $MO; ?> </td> <td class="tableColor"><?php echo $DI; ?> </td> <td class="tableColor"><?php echo $MI; ?> </td> <td class="tableColor"><?php echo $DO; ?> </td> <td class="tableColor"><?php echo $FR; ?> </td> <td class="tableColor"><?php echo $SA; ?> </td> <td class="tableColor"><?php echo $SO; ?> </td> </tr> <tr> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <?php for ($i = 1; $i <= 2; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 3; $i <= 9; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 10; $i <= 16; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 17; $i <= 23; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 24; $i <= 28; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> <td class="<?php if ($anzahlTage >= 29) { echo getStatusString($zimmer_id, 29, $month, $year, $saAktiviert, $link); } else { echo "tableColor"; } ?> "><?php if ($anzahlTage >= 29) { printRes($zimmer_id, 29, $month, $year, $saAktiviert, $link); } else { echo " "; } ?> </td> <td class="<?php if ($anzahlTage >= 30) { echo getStatusString($zimmer_id, 30, $month, $year, $saAktiviert, $link); } else { echo "tableColor"; } ?> "><?php if ($anzahlTage >= 30) { printRes($zimmer_id, 30, $month, $year, $saAktiviert, $link); } else { echo " "; } ?> </td> </tr> <tr> <td class="<?php if ($anzahlTage >= 31) { echo getStatusString($zimmer_id, 31, $month, $year, $saAktiviert, $link); } else { echo "tableColor"; } ?> "><?php if ($anzahlTage >= 31) { printRes($zimmer_id, 31, $month, $year, $saAktiviert, $link); } else { echo " "; } ?> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> </tr> </table><?php } elseif ($firstDay == "Sun") { ?> <table width="100%" border="0" class="tableColor"> <tr> <td colspan="7" class="standardSchriftBold"><?php echo getUebersetzung(parseMonthName($month), $sprache, $link) . " " . $year; ?> </td> </tr> <tr> <td class="tableColor"><?php echo $MO; ?> </td> <td class="tableColor"><?php echo $DI; ?> </td> <td class="tableColor"><?php echo $MI; ?> </td> <td class="tableColor"><?php echo $DO; ?> </td> <td class="tableColor"><?php echo $FR; ?> </td> <td class="tableColor"><?php echo $SA; ?> </td> <td class="tableColor"><?php echo $SO; ?> </td> </tr> <tr> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="<?php echo getStatusString($zimmer_id, 1, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, 1, $month, $year, $saAktiviert, $link); ?> </td> </tr> <tr> <?php for ($i = 2; $i <= 8; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 9; $i <= 15; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 16; $i <= 22; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> </tr> <tr> <?php for ($i = 23; $i <= 28; $i++) { ?> <td class="<?php echo getStatusString($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> "><?php printRes($zimmer_id, $i, $month, $year, $saAktiviert, $link); ?> </td> <?php } ?> <td class="<?php if ($anzahlTage >= 29) { echo getStatusString($zimmer_id, 29, $month, $year, $saAktiviert, $link); } else { echo "tableColor"; } ?> "><?php if ($anzahlTage >= 29) { printRes($zimmer_id, 29, $month, $year, $saAktiviert, $link); } else { echo " "; } ?> </td> </tr> <tr> <td class="<?php if ($anzahlTage >= 30) { echo getStatusString($zimmer_id, 30, $month, $year, $saAktiviert, $link); } else { echo "tableColor"; } ?> "><?php if ($anzahlTage >= 30) { printRes($zimmer_id, 30, $month, $year, $saAktiviert, $link); } else { echo " "; } ?> </td> <td class="<?php if ($anzahlTage >= 31) { echo getStatusString($zimmer_id, 31, $month, $year, $saAktiviert, $link); } else { echo "tableColor"; } ?> "><?php if ($anzahlTage >= 31) { printRes($zimmer_id, 31, $month, $year, $saAktiviert, $link); } else { echo " "; } ?> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> <td class="tableColor"> </td> </tr> </table><?php } //ende if sonntag }
/** * Generates server traffic bar * * @param iMSCP_pTemplate $tpl iMSCP_pTemplate instance * @return void */ function admin_generateServerTrafficInfo($tpl) { $cfg = iMSCP_Registry::get('config'); $trafficLimitBytes = intval($cfg['SERVER_TRAFFIC_LIMIT']) * 1048576; $trafficWarningBytes = intval($cfg['SERVER_TRAFFIC_WARN']) * 1048576; if (!$trafficWarningBytes) { $trafficWarningBytes = $trafficLimitBytes; } // Get server traffic usage value in bytes for the current month $stmt = exec_query(' SELECT IFNULL((SUM(bytes_in) + SUM(bytes_out)), 0) AS serverTrafficUsage FROM server_traffic WHERE traff_time BETWEEN ? AND ? ', array(getFirstDayOfMonth(), getLastDayOfMonth())); if ($stmt->rowCount()) { $row = $stmt->fetchRow(); $trafficUsageBytes = $row['serverTrafficUsage']; } else { $trafficUsageBytes = 0; } // Get traffic usage in percent $trafficUsagePercent = make_usage_vals($trafficUsageBytes, $trafficLimitBytes); if ($trafficLimitBytes) { $trafficMessage = tr('%1$s%% [%2$s of %3$s]', $trafficUsagePercent, bytesHuman($trafficUsageBytes), bytesHuman($trafficLimitBytes)); } else { $trafficMessage = tr('%1$s%% [%2$s of unlimited]', $trafficUsagePercent, bytesHuman($trafficUsageBytes)); } // Warning message about traffic if ($trafficUsageBytes && ($trafficWarningBytes && $trafficUsageBytes > $trafficWarningBytes || $trafficLimitBytes && $trafficUsageBytes > $trafficLimitBytes)) { set_page_message(tr('You are exceeding the monthly server traffic limit.'), 'static_warning'); } $tpl->assign(array('TRAFFIC_WARNING' => $trafficMessage, 'TRAFFIC_PERCENT' => $trafficUsagePercent)); }
$endDate = null; $message = ""; if ($calType == $ACTION_TYPE_CALENDAR_DAY) { $startDate = standardSQLDateFromSeconds(getDayStartFromSeconds($calTime)); $endDate = standardSQLDateFromSeconds(getDayEndFromSeconds($calTime)); $message = "day"; } else { if ($calType == $ACTION_TYPE_CALENDAR_WEEK) { $firstDayOfWeek = getFirstMondayOfWeek($calTime); $lastDayOfWeek = getLastSundayOfWeek($calTime); $startDate = standardSQLDateFromSeconds(getDayStartFromSeconds($firstDayOfWeek)); $endDate = standardSQLDateFromSeconds(getDayEndFromSeconds($lastDayOfWeek)); $message = "week"; } else { if ($calType == $ACTION_TYPE_CALENDAR_MONTH) { $firstDayOfMonth = getFirstDayOfMonth($calTime); $lastDayOfMonth = getLastDayOfMonth($calTime); $startDate = standardSQLDateFromSeconds(getDayStartFromSeconds($firstDayOfMonth)); $endDate = standardSQLDateFromSeconds(getDayEndFromSeconds($lastDayOfMonth)); $message = "month"; } else { echo '{ "status":"error", "message":"invalid type" }'; return; } } } if ($calOption == $ACTION_TYPE_CALENDAR_OPTION_SELF && $ACTION_VALUE_USER_ID > 0) { $calOption = ' and shifts.user_id="' . $ACTION_VALUE_USER_ID . '" '; } else { $calOption = ''; }