<?php
$tbl2 = new HTML_Table('', 'data-table table table-striped table-bordered', array('data-title' => 'List of Draft Talents'));
$tbl2->addTSection('thead');
$tbl2->addRow();
$tbl2->addCell('Photo', '', 'header');
$tbl2->addCell('Full Name', '', 'header');
$tbl2->addCell('Gender', '', 'header');
$tbl2->addCell('Age', '', 'header');
$tbl2->addCell('Height', '', 'header');
$tbl2->addCell('weight', '', 'header');
$tbl2->addCell('Nationality', '', 'header');
$tbl2->addCell('Experience', '', 'header');
$tbl2->addCell('Actions', '', 'header');
$tbl2->addTSection('tbody');
$mysql = 'SELECT * FROM tams_talent_experience WHERE talent_id ="$talent_id"';
$experience = DB::queryFirstRow($mysql);
$experience_item_id = $experience['experience_item_id'];
$talent_experience_item_id = $experience['talent_experience_item_id'];
$created_on = $experience['created_on'];
$created_by = $experience['created_by'];
$last_modified_by = $experience['last_modified_by'];
$last_modified_on = $experience['last_modified_on'];
$sql = 'SELECT * FROM tams_talent WHERE talent_status = "draft"';
$get_talents = DB::query($sql);
foreach ($get_talents as $talent) {
$tbl2->addRow();
$tbl2->addCell("<a href='" . $_SERVER['PHP_SELF'] . "?route=modules/talent/view_talent_profile&talent_id=" . $talent['talent_id'] . "'><img src='" . $talent['photo1_url'] . "' alt='Photo1' width='100px' height='100px'; /></a>");
$tbl2->addCell($talent['first_name'] . " " . $talent['last_name']);
$tbl2->addCell($talent['sex']);
$tbl2->addCell(getAge($talent['dob']));
<?php
$tbl = new HTML_Table('', 'data-table table table-striped table-bordered', array('data-title' => 'List of Users'));
$tbl->addTSection('thead');
$tbl->addRow();
$tbl->addCell("<a class='pull btn btn-success btn-md' href ='" . $_SERVER['PHP_SELF'] . "?route=modules/languages/add_language'>Add New Language <span class='glyphicon glyphicon-plus'></span></a>");
$tbl->addRow();
$tbl->addCell('Language ID', '', 'header');
$tbl->addCell('Language Name', '', 'header');
$tbl->addCell('Status', '', 'header');
$tbl->addCell('Actions', '', 'header');
$tbl->addTSection('tbody');
$sql = 'SELECT * FROM tams_languages WHERE language_status = "active" ORDER BY language_name';
$get_language = DB::query($sql);
foreach ($get_language as $type) {
$tbl->addRow();
$tbl->addCell($type['language_id']);
$tbl->addCell($type['language_name']);
$tbl->addCell($type['language_status']);
$tbl->addCell("<a class='pull btn btn-danger btn-xs' href ='" . $_SERVER['PHP_SELF'] . "?route=modules/languages/edit_language&language_id=" . $type['language_id'] . "'>Edit Language <span class='glyphicon glyphicon-edit'></span></a>\n\t\t\t ");
}
?>
<!-- Content Header (Page header) -->
<section class="content-header">
<h1>
System Settings
<small>list of Languages. </small>
</h1>
<ol class="breadcrumb">
<li><a href="<?php
echo SITE_ROOT;
<?php
$tbl = new HTML_Table('', 'data-table table table-striped table-bordered', array('data-title' => 'List of Users'));
$tbl->addTSection('thead');
$tbl->addRow();
$tbl->addCell("<a class='pull btn btn-success btn-md' href ='" . $_SERVER['PHP_SELF'] . "?route=modules/talent/add_talent'>Add New Talent <span class='glyphicon glyphicon-plus'></span></a>");
$tbl->addRow();
$tbl->addCell('Photo', '', 'header');
$tbl->addCell('Full Name', '', 'header');
$tbl->addCell('Gender', '', 'header');
$tbl->addCell('Age', '', 'header');
$tbl->addCell('PhoneNo', '', 'header');
$tbl->addCell('Email', '', 'header');
$tbl->addCell('Nationality', '', 'header');
$tbl->addCell('Brief', '', 'header');
$tbl->addCell('Actions', '', 'header');
$tbl->addTSection('tbody');
$sql = 'SELECT * FROM tams_talent';
$get_talents = DB::query($sql);
foreach ($get_talents as $talent) {
$tbl->addRow();
$tbl->addCell("<a href='" . $_SERVER['PHP_SELF'] . "?route=modules/talent/view_talent_profile&talent_id=" . $talent['talent_id'] . "'><img src='" . $talent['photo1_url'] . "' alt='Photo1' height='100px'; /></a>");
$tbl->addCell($talent['first_name'] . " " . $talent['last_name']);
$tbl->addCell($talent['sex']);
$tbl->addCell(getAge($talent['dob']));
$tbl->addCell($talent['mobile_no']);
$tbl->addCell("<a href='mailto:" . $talent['email_id'] . "' >" . $talent['email_id'] . "</a>");
$tbl->addCell($talent['nationality']);
$tbl->addCell($talent['brief']);
$btnStr = ' onclick="';
$btnStr .= " return confirm('Are you sure you wish to delete this Record?'); ";
public function mZ_mindbody_show_schedule($atts, $account = 0)
{
require_once MZ_MINDBODY_SCHEDULE_DIR . '/lib/html_table.class.php';
global $add_mz_ajax_script;
$add_mz_ajax_script = true;
// optionally pass in a type parameter. Defaults to week.
$atts = shortcode_atts(array('type' => 'week', 'location' => '1', 'account' => '0', 'filter' => '0', 'grid' => '0', 'hide' => ''), $atts);
$type = $atts['type'];
$location = $atts['location'];
$account = $atts['account'];
$filter = $atts['filter'];
$grid = $atts['grid'];
if ($grid == 1 && $type == 'day') {
return '<div style="color:red"><h2>' . __('Grid Calendar Incompatible with Single Day Mode!', 'mz_mndbody_api') . '</h2></div>';
}
if ($grid == 0) {
$mz_date = empty($_GET['mz_date']) ? date_i18n('Y-m-d') : mz_validate_date($_GET['mz_date']);
} else {
$hide = explode(', ', $atts['hide']);
$mz_date = empty($_GET['mz_date']) ? date_i18n('Y-m-d', strtotime('last monday')) : mz_validate_date($_GET['mz_date']);
}
if ($type == __('day', 'mz-mindbody-api')) {
$mz_timeframe = array_slice(mz_getDateRange($mz_date, 1), 0, 1);
$mz_schedule_cache = "mz_schedule_day_cache_" . mt_rand(1, 10);
} else {
$mz_timeframe = array_slice(mz_getDateRange($mz_date, 7), 0, 1);
$mz_schedule_cache = "mz_schedule_week_cache_" . mt_rand(1, 10);
}
//While we still need to support php 5.2 and can't use [0] on above
$mz_timeframe = array_pop($mz_timeframe);
// START caching
$mz_cache_reset = isset($options['mz_mindbody_clear_cache']) ? "on" : "off";
if ($mz_cache_reset == "on") {
delete_transient($mz_schedule_cache);
}
$mz_schedule_data = get_transient($mz_schedule_cache);
mz_pr('' == $mz_schedule_data);
if (isset($_GET['mz_date']) || '' == $mz_schedule_data) {
//Send the timeframe to the GetClasses class, unless already cached
$mb = instantiate_mbo_API();
if ($account == 0) {
$mz_schedule_data = $mb->GetClasses($mz_timeframe);
} else {
$mb->sourceCredentials['SiteIDs'][0] = $account;
$mz_schedule_data = $mb->GetClasses($mz_timeframe);
}
//Cache the mindbody call for 24 hours
// TODO make cache timeout configurable.
set_transient($mz_schedule_cache, $mz_schedule_data, 60 * 60 * 24);
}
$return = '';
if (!empty($mz_schedule_data['GetClassesResult']['Classes']['Class'])) {
$mz_days = $this->makeNumericArray($mz_schedule_data['GetClassesResult']['Classes']['Class']);
if ($grid == 0) {
$mz_days = sortClassesByDate($mz_days, $this->time_format, $location);
} else {
$mz_days = sortClassesByTimeThenDay($mz_days, $this->time_format, $location);
}
$return .= '<div id="mz_mbo_schedule" class="mz_mbo_schedule">';
if ($type == __('week', 'mz-mindbody-api')) {
$return .= mz_mbo_schedule_nav($mz_date, __('Week', 'mz-mindbody-api'));
}
if ($filter == 1) {
$tbl = new HTML_Table('', 'mz-schedule-filter');
} else {
$tbl = new HTML_Table('', 'mz-schedule-table');
}
if ($grid == 0) {
foreach ($mz_days as $classDate => $mz_classes) {
$tbl->addRow('header');
// arguments: cell content, class, type (default is 'data' for td, pass 'header' for th)
// can include associative array of optional additional attributes
$tbl->addCell(date_i18n($this->mz_date_display, strtotime($classDate)), '', 'header', array('scope' => 'header'));
$tbl->addCell(__('Class Name', 'mz-mindbody-api'), '', 'header', array('scope' => 'header'));
$tbl->addCell(__('Instructor', 'mz-mindbody-api'), '', 'header', array('scope' => 'header'));
$tbl->addCell(__('Class Type', 'mz-mindbody-api'), '', 'header', array('scope' => 'header'));
$tbl->addTSection('tbody');
foreach ($mz_classes as $class) {
// mz_pr($class);
$sDate = date_i18n('m/d/Y', strtotime($class['StartDateTime']));
$sLoc = $class['Location']['ID'];
$sTG = $class['ClassDescription']['Program']['ID'];
$studioid = $class['Location']['SiteID'];
$sclassid = $class['ClassScheduleID'];
$sclassidID = $class['ID'];
$classDescription = $class['ClassDescription']['Description'];
$sType = -7;
$showCancelled = $class['IsCanceled'] == 1 ? '<div class="mz_cancelled_class">' . __('Cancelled', 'mz-mindbody-api') . '</div>' : '';
$className = $class['ClassDescription']['Name'];
$startDateTime = date_i18n('Y-m-d H:i:s', strtotime($class['StartDateTime']));
$endDateTime = date_i18n('Y-m-d H:i:s', strtotime($class['EndDateTime']));
$staffName = $class['Staff']['Name'];
$sessionType = $class['ClassDescription']['SessionType']['Name'];
$isAvailable = $class['IsAvailable'];
$linkURL = "https://clients.mindbodyonline.com/ws.asp?sDate={$sDate}&sLoc={$sLoc}&sTG={$sTG}&sType={$sType}&sclassid={$sclassid}&studioid={$studioid}";
if (date_i18n('H', strtotime($startDateTime)) < 12) {
$time_of_day = __('morning', 'mz-mindbody-api');
} else {
if (date_i18n('H', strtotime($startDateTime)) > 16) {
$time_of_day = __('evening', 'mz-mindbody-api');
} else {
$time_of_day = __('afternoon', 'mz-mindbody-api');
}
}
// start building table rows
$tbl->addRow('mz_description_holder');
$tbl->addCell($time_of_day, 'hidden', 'data');
if (isset($isAvailable) && $isAvailable != 0) {
$tbl->addCell(date_i18n($this->time_format, strtotime($startDateTime)) . ' - ' . date_i18n($this->time_format, strtotime($endDateTime)) . '<br/><a class="btn" href="' . $linkURL . '" target="_blank">' . __('Sign-Up', 'mz-mindbody-api') . '</a>');
} else {
$tbl->addCell(date_i18n($this->time_format, strtotime($startDateTime)) . ' - ' . date_i18n($this->time_format, strtotime($endDateTime)));
}
$tbl->addCell('<a data-toggle="modal" data-target="#mzModal" href="' . MZ_MINDBODY_SCHEDULE_URL . 'inc/modal_descriptions.php?classDescription=' . urlencode(substr($classDescription, 0, 1000)) . '&className=' . urlencode(substr($className, 0, 1000)) . '">' . $className . '</a>' . '<br/><div id="visitMBO" class="btn visitMBO" style="display:none">' . '<a href="' . $linkURL . '" target="_blank">' . __('Manage on MindBody Site', ' mz-mindbody-api') . '</a></div>' . $showCancelled);
$tbl->addCell($staffName);
$tbl->addCell($sessionType);
}
// EOF foreach class
}
// EOF foreach day
$tbl->addTSection('tfoot');
$tbl->addRow();
$tbl->addCell('', '', '', array('colspan' => 4));
$return .= $tbl->display();
} else {
//Display grid
$week_starting = date_i18n($this->date_format, strtotime($mz_date));
//
$return .= '<h4 class="mz_grid_date">';
$return .= sprintf(__('Week of %1$s', 'mz-mindbody-api'), $week_starting);
$return .= '</h4>';
$tbl->addTSection('thead');
$tbl->addRow();
// arguments: cell content, class, type (default is 'data' for td, pass 'header' for th)
// can include associative array of optional additional attributes
$tbl->addCell('', '', 'header');
$tbl->addCell(__('Monday', 'mz-mindbody-api'), '', 'header');
$tbl->addCell(__('Tuesday', 'mz-mindbody-api'), '', 'header');
$tbl->addCell(__('Wednesday', 'mz-mindbody-api'), '', 'header');
$tbl->addCell(__('Thursday', 'mz-mindbody-api'), '', 'header');
$tbl->addCell(__('Friday', 'mz-mindbody-api'), '', 'header');
$tbl->addCell(__('Saturday', 'mz-mindbody-api'), '', 'header');
$tbl->addCell(__('Sunday', 'mz-mindbody-api'), '', 'header');
$tbl->addTSection('tbody');
foreach ($mz_days as $classDate => $mz_classes) {
if ($classDate < 12) {
$time_of_day = __('morning', 'mz-mindbody-api');
} else {
if ($classDate > 16) {
$time_of_day = __('evening', 'mz-mindbody-api');
} else {
$time_of_day = __('afternoon', 'mz-mindbody-api');
}
}
$tbl->addRow();
$tbl->addCell($time_of_day, 'hidden', 'data');
$tbl->addCell($mz_classes['display_time']);
//mz_pr($mz_classes['display_time']);
foreach ($mz_classes['classes'] as $key => $classes) {
//mz_pr($key);
//mz_pr($classes);
//die();
if (empty($classes) || null === $classes[0]['ClassDescription']['Name']) {
$class_details = '';
$num_classes_min_one = 50;
//Set to a number that won't match key
} else {
$class_details = '';
$num_classes_min_one = count($classes) - 1;
foreach ($classes as $key => $class) {
$className = $class['ClassDescription']['Name'];
if (!in_array('teacher', $hide)) {
$teacher = __('with', 'mz-mindbody-api') . ' ' . $class['Staff']['Name'] . '<br/>';
} else {
$teacher = '';
}
$showCancelled = $class['IsCanceled'] == 1 ? '<div class="mz_cancelled_class">' . __('Cancelled') . '</div>' : '';
$classDescription = $class['ClassDescription']['Description'];
$sessionTypeName = $class['ClassDescription']['SessionType']['Name'];
$showCancelled = $class['IsCanceled'] == 1 ? '<div class="mz_cancelled_class">' . __('Cancelled') . '</div>' : '';
if (!in_array('duration', $hide) && $class['IsCanceled'] != 1) {
$classStartTime = new DateTime($class['StartDateTime']);
$classEndTime = new DateTime($class['EndDateTime']);
if (phpversion() >= 5.3) {
$classLength = $classEndTime->diff($classStartTime);
$classLength = __('Duration:', 'mz-mindbody-api') . '<br/> ' . $classLength->format('%H:%I');
} else {
$classLength = round($classEndTime->format('U') - $classStartTime->format('U'));
$classLength = __('Duration:', 'mz-mindbody-api') . '<br/> ' . gmdate("H:i", $classLength);
}
} else {
$classLength = '';
}
// Initialize $signupButton
$signupButton = '';
// Variables for class URL
$sDate = date_i18n('m/d/Y', strtotime($class['StartDateTime']));
$sLoc = $class['Location']['ID'];
$sTG = $class['ClassDescription']['Program']['ID'];
$studioid = $class['Location']['SiteID'];
$sclassid = $class['ClassScheduleID'];
$sclassidID = $class['ID'];
$sType = -7;
$isAvailable = $class['IsAvailable'];
$class_separator = $key == $num_classes_min_one ? '' : '<hr/>';
$linkURL = "https://clients.mindbodyonline.com/ws.asp?sDate={$sDate}&sLoc={$sLoc}&sTG={$sTG}&sType={$sType}&sclassid={$sclassid}&studioid={$studioid}";
if (!in_array('signup', $hide)) {
$signupButton = ' <a href="' . $linkURL . '" target="_blank" title="' . __('Sign-Up', 'mz-mindbody-api') . '"><i class="fa fa-sign-in"></i></a><br/>';
} else {
$signupButton = '';
}
$class_details .= '<div class="' . 'mz_' . sanitize_html_class($sessionTypeName, 'mz_session_type') . '">' . '<a data-toggle="modal" data-target="#mzModal" href="' . MZ_MINDBODY_SCHEDULE_URL . 'inc/modal_descriptions.php?classDescription=' . urlencode(substr($classDescription, 0, 1000)) . '&className=' . urlencode(substr($className, 0, 1000)) . '">' . $className . '</a>' . '<br/>' . $teacher . $signupButton . $classLength . $showCancelled . '</div>' . $class_separator;
}
}
$tbl->addCell($class_details, 'mz_description_holder');
}
//end foreach mz_classes
}
//end foreach mz_days
$return .= $tbl->display();
}
//End if grid
if ($type == 'week') {
// schedule navigation
$return .= mz_mbo_schedule_nav($mz_date, __('Week', 'mz-mindbody-api'));
}
$return .= '<div id="mzModal" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="mzSmallModalLabel" aria-hidden="true">
<div class="modal-content">
</div>
</div>';
$return .= '</div>';
} else {
if (!empty($mz_schedule_data['GetClassesResult']['Message'])) {
$return = $mz_schedule_data['GetClassesResult']['Message'];
} else {
$return = __('Error getting classes. Try re-loading the page.', ' mz-mindbody-api') . '<br />';
$return .= '<pre>' . print_r($mz_schedule_data, 1) . '</pre>';
}
}
//EOF If Result / Else
$mz_schedule_display = 'mz_schedule_display_' . mt_rand(1, 1000000);
mz_pr($mz_schedule_display);
set_transient($mz_schedule_display, $return, 60 * 60 * 24);
return get_transient($mz_schedule_display);
}
<?php
$tbl = new HTML_Table('', 'table table-striped table-bordered');
$tbl->addRow();
$tbl->addCell('Config ID', '', 'header');
$tbl->addCell('Key', '', 'header');
$tbl->addCell('Key Label', '', 'header');
$tbl->addCell('Key Help Text', '', 'header');
$tbl->addCell('Value', '', 'header');
$tbl->addCell('Actions', '', 'header');
?>
<?php
/*
$sql = 'SELECT * FROM '.DB_PREFIX.'sys_config';
$get = DB::query($sql);
foreach($get as $config) {
$tbl->addRow();
$tbl->addCell($config['config_id']);
$tbl->addCell($config['key']);
$tbl->addCell($config['key_label']);
$tbl->addCell($config['key_help_text']);
$tbl->addCell($config['value']);
$tbl->addCell("<a data-toggle = 'modal' href ='#edit_system_configuration' class='pull btn btn-danger btn-xs' >Edit System Configrations <span class='glyphicon glyphicon-edit'></span></a>
");
}
*/
$tbl->addRow();
$tbl->addCell('');
$tbl->addCell('<input type="text" name="key" value=""/>');
$tbl->addCell('<input type="text" name="key_label" value=""/>');
$voucher_ref = "";
$voucher_date = "";
if (isset($_GET['voucher_id'])) {
$voucher_id = $_GET['voucher_id'];
}
if ($voucher_id > 0) {
$sql = "SELECT * FROM " . DB_PREFIX . $_SESSION['co_prefix'] . "journal_vouchers WHERE voucher_id=" . $voucher_id;
$voucher = DB::queryFirstRow($sql);
$voucher_ref = $voucher['voucher_ref_no'];
$voucher_date = $voucher['voucher_date'];
$voucher_desc = $voucher['voucher description'];
}
//Draft Journal Vouchers
$tbl_draft = new HTML_Table('', 'table table-striped table-bordered');
$tbl_draft->addRow();
$tbl_draft->addCell('ID', '', 'header');
$tbl_draft->addCell('Voucher Date', '', 'header');
$tbl_draft->addCell('Account', '', 'header');
$tbl_draft->addCell('Entry Description', '', 'header');
$tbl_draft->addCell('Debit', '', 'header');
$tbl_draft->addCell('Credit', '', 'header');
$tbl_draft->addCell('Action', '', 'header');
?>
<?php
$sql = 'SELECT * FROM ' . DB_PREFIX . $_SESSION['co_prefix'] . 'journal_voucher_details WHERE voucher_detail_status="draft" && voucher_id=' . $voucher_id . ' ORDER by voucher_detail_id DESC';
$draft_jv = DB::query($sql);
foreach ($draft_jv as $jv_detail) {
$tbl_draft->addRow();
$tbl_draft->addCell($jv_detail['voucher_detail_id']);
$tbl_draft->addCell($jv_detail['voucher_date']);
<?php
/********************************************************************************
* Small Time
/*******************************************************************************
* Version 0.896
* Author: IT-Master GmbH
* www.it-master.ch / info@it-master.ch
* Copyright (c), IT-Master GmbH, All rights reserved
*******************************************************************************/
?>
<div id="formular">
<form method="POST" action="?action=password">
<?php
$tbl = new HTML_Table('', 'table');
$tbl->addRow();
$tbl->addCell('altes Passwort', 'td_background_wochenende" width="200');
$tbl->addCell('<input type="password" name="old"/>', 'td_background_tag');
$tbl->addRow();
$tbl->addCell('neues Passwort', 'td_background_wochenende" width="200');
$tbl->addCell('<input type="password" name="new1"/>', 'td_background_tag');
$tbl->addRow();
$tbl->addCell('Passwort wiederholen', 'td_background_wochenende" width="200');
$tbl->addCell('<input type="password" name="new2"/>', 'td_background_tag');
$tbl->addRow();
$tbl->addCell('<input type="submit" value="senden" name="senden"/>', 'alert-error', 'data', array('colspan' => 2));
echo $tbl->display();
?>
</form>
</div>
$draft_jvs = DB::query($sql);
foreach ($draft_jvs as $draft_jv) {
$tbl_draft->addRow();
$tbl_draft->addCell($draft_jv['voucher_id']);
$tbl_draft->addCell(getDateTime($draft_jv['voucher_date'], "dShort"));
$tbl_draft->addCell($draft_jv['voucher_ref_no']);
$tbl_draft->addCell($draft_jv['voucher description']);
$tbl_draft->addCell($draft_jv['debits_total']);
$tbl_draft->addCell($draft_jv['credits_total']);
$tbl_draft->addCell("More info here like created on, last modify etc");
$tbl_draft->addCell("<a class='pull btn btn-primary btn-xs' href ='" . SITE_ROOT . "?route=modules/gl/transactions/journal_vouchers/add_journal_voucher_detail&voucher_id=" . $draft_jv['voucher_id'] . "'>Edit <span class='glyphicon glyphicon-edit'></span></a> <a class='pull btn btn-danger btn-xs' href ='#'>Delete <span class='glyphicon glyphicon-trash'></span></a>");
}
//Journal Vouchers Pending Approvel
$tbl_pending = new HTML_Table('', 'table table-striped table-bordered');
$tbl_pending->addRow();
$tbl_pending->addCell('Voucher ID', '', 'header');
$tbl_pending->addCell('Ref #', '', 'header');
$tbl_pending->addCell('Voucher Description', '', 'header');
$tbl_pending->addCell('Total Amount', '', 'header');
$tbl_pending->addCell('Voucher Approved By', '', 'header');
$tbl_pending->addCell('Voucher Status', '', 'header');
$tbl_pending->addCell('Actions', '', 'header');
?>
<?php
$sql = 'SELECT * FROM ' . DB_PREFIX . $_SESSION['co_prefix'] . 'journal_vouchers WHERE voucher_status = "pending" ORDER by voucher_id DESC';
$pending_jvs = DB::query($sql);
foreach ($pending_jvs as $pending_jv) {
$tbl_pending->addRow();
$tbl_pending->addCell($pending_jv['voucher_id']);
$tbl_pending->addCell($pending_jv['voucher_ref_no']);
<?php
$tbl = new HTML_Table('', 'table table-striped table-bordered');
$tbl->addRow();
$tbl->addCell('Fiscal Year', '', 'header');
$tbl->addCell('Period Description', '', 'header');
$tbl->addCell('Start Date', '', 'header');
$tbl->addCell('End Date', '', 'header');
$tbl->addCell('Status', '', 'header');
$tbl->addCell('Actions', '', 'header');
?>
<?php
$sql = 'SELECT * FROM ' . DB_PREFIX . $_SESSION['co_prefix'] . 'reporting_periods ORDER by reporting_period_start_date';
$get_rp = DB::query($sql);
foreach ($get_rp as $rp) {
$fiscal_year = DB::queryFirstField("SELECT fiscal_year_desc FROM " . DB_PREFIX . $_SESSION['co_prefix'] . "fiscal_years WHERE fiscal_year_id =" . $rp['fiscal_year_id']);
$tbl->addRow();
$tbl->addCell($fiscal_year);
$tbl->addCell($rp['reporting_period_desc']);
$tbl->addCell(getDateTime($rp['reporting_period_start_date'], "dLong"));
$tbl->addCell(getDateTime($rp['reporting_period_end_date'], "dLong"));
$tbl->addCell($rp['rp_status']);
$tbl->addCell("<a class='pull btn btn-danger btn-xs' href ='" . $_SERVER['PHP_SELF'] . "?route=modules/gl/setup/financial_periods/edit_reporting_period&reporting_period_id=" . $rp['reporting_period_id'] . "'>Edit Reporting Period <span class='glyphicon glyphicon-edit'></span></a>\n\t\t\t ");
}
?>
<!-- Content Header (Page header) -->
<section class="content-header">
<h1>
Reporting Periods
<small>Defined Reporting Periods In Fiscal Years.</small>
<?php
$tbl = new HTML_Table('', 'data-table table table-striped table-bordered', array('data-title' => 'List of Users'));
$tbl->addTSection('thead');
$tbl->addRow();
$tbl->addCell('User ID', '', 'header');
$tbl->addCell('Username', '', 'header');
$tbl->addCell('First Name', '', 'header');
$tbl->addCell('Last Name', '', 'header');
$tbl->addCell('email', '', 'header');
$tbl->addCell('User Type', '', 'header');
$tbl->addCell('Actions', '', 'header');
$tbl->addTSection('tbody');
?>
<?php
$company_id = $_SESSION['company_id'];
$sql = 'SELECT * FROM ' . DB_PREFIX . 'users WHERE company_id = ' . $company_id . ' AND status = 1 AND user_group_id > 2';
$get_users = DB::query($sql);
foreach ($get_users as $user) {
$tbl->addRow();
$tbl->addCell($user['user_id']);
$tbl->addCell($user['username']);
$tbl->addCell($user['firstname']);
$tbl->addCell($user['lastname']);
$tbl->addCell($user['email']);
$tbl->addCell(get_user_group_name($user['user_id']));
$tbl->addCell("<a class='pull btn btn-danger btn-xs' href ='" . $_SERVER['PHP_SELF'] . "?route=users/edit_user&user_id=" . $user['user_id'] . "'>Edit User <span class='glyphicon glyphicon-edit'></span></a>\n\t\t\t ");
}
?>
<!-- Content Header (Page header) -->
<?php
$tbl = new HTML_Table('', 'data-table table table-striped table-bordered', array('data-title' => 'List of Users'));
$tbl->addTSection('thead');
$tbl->addRow();
$tbl->addCell("<a class='pull btn btn-success btn-md' href ='" . $_SERVER['PHP_SELF'] . "?route=modules/clients/add_client'>Add New Client <span class='glyphicon glyphicon-plus'></span></a>");
$tbl->addRow();
$tbl->addCell(' Company Logo', '', 'header');
$tbl->addCell(' Company Name', '', 'header');
$tbl->addCell(' Contact Person Name', '', 'header');
$tbl->addCell('Title/Position', '', 'header');
$tbl->addCell('Country', '', 'header');
$tbl->addCell('Phone No', '', 'header');
$tbl->addCell('Email', '', 'header');
$tbl->addCell('Notes', '', 'header');
$tbl->addCell('Actions', '', 'header');
$tbl->addTSection('tbody');
$mysql = 'SELECT * FROM tams_client_comments WHERE client_id ="$client_id"';
$client_comment = DB::queryFirstRow($mysql);
$client_comment_id = $client_comment['client_comment_id'];
$client_id = $client_comment['client_id'];
$comment = $client_comment['comment'];
$created_on = $client_comment['created_on'];
$created_by = $client_comment['created_by'];
$last_modified_by = $client_comment['last_modified_by'];
$last_modified_on = $client_comment['last_modified_on'];
$sql = 'SELECT * FROM tams_clients WHERE client_status = "active"';
$get_client_name = DB::query($sql);
foreach ($get_client_name as $client) {
$tbl->addRow();
$tbl->addCell('<img src="' . $client['logo_url'] . '" alt="Logo" width="100px" height="100px"; />');
<?php
$tbl = new HTML_Table('', 'data-table table table-striped table-bordered', array('data-title' => 'User Roles'));
$tbl->addTSection('thead');
$tbl->addRow();
$tbl->addCell("<a class='pull btn btn-success btn-md' href ='" . $_SERVER['PHP_SELF'] . "?route=modules/user_roles/add_user_role'>Add New Role <span class='glyphicon glyphicon-plus'></span></a>");
$tbl->addRow();
$tbl->addCell('RoleID', '', 'header');
$tbl->addCell('Role Name', '', 'header');
$tbl->addCell('Description', '', 'header');
$tbl->addCell('Hostory', '', 'header');
$tbl->addCell('Actions', '', 'header');
$tbl->addTSection('tbody');
?>
<?php
$sql = "SELECT * FROM tams_user_roles";
$roles = DB::query($sql);
foreach ($roles as $role) {
$tbl->addRow();
$tbl->addCell($role['role_id']);
$tbl->addCell($role['role_name']);
$tbl->addCell($role['role_description']);
$tbl->addCell("<p>Created on: <strong> " . getDateTime($role['created_on'], 'dtLong') . " </strong> by <strong>" . get_user_name($role['created_by']) . "</strong></p> <p>Last Modified: <strong>" . getDateTime($role['last_modified_on'], "dtLong") . " </strong> by <strong>" . get_user_name($role['last_modified_by']) . "</strong></p> ");
$tbl->addCell("<a class='pull btn btn-danger btn-xs' href ='" . $_SERVER['PHP_SELF'] . "?route=modules/user_roles/edit_user_role&role_id=" . $role['role_id'] . "'>Edit Role <span class='glyphicon glyphicon-edit'></span></a>\n\t\t\t ");
}
?>
<!-- Content Header (Page header) -->
<section class="content-header">
<h1> System Settings
<small>User Roles Setup</small>
<?php
$tbl = new HTML_Table('', 'table table-striped table-bordered');
$tbl->addRow();
$tbl->addCell('Group Code', '', 'header');
$tbl->addCell('Group Description', '', 'header');
$tbl->addCell('Type', '', 'header');
$tbl->addCell('Side', '', 'header');
$tbl->addCell('Status', '', 'header');
$tbl->addCell('Actions', '', 'header');
?>
<?php
$sql = 'SELECT * FROM ' . DB_PREFIX . $_SESSION['co_prefix'] . 'coa_groups ORDER by group_code';
$get_coa = DB::query($sql);
foreach ($get_coa as $coa) {
$tbl->addRow();
$tbl->addCell($coa['group_code'] . "<a class='btn pull-right btn-info btn-xs' href ='" . $_SERVER['PHP_SELF'] . "?route=modules/gl/setup/coa/list_coa&view=bygroupid&group_id=" . $coa['group_id'] . "'>Sub Accounts <span class='fa fa-search-plus'></span></a>");
$tbl->addCell($coa['group_description']);
$tbl->addCell(get_coa_group_type($coa['group_id']));
$tbl->addCell(get_coa_group_side($coa['group_id']));
$tbl->addCell($coa['group_status']);
$tbl->addCell("<a class='pull btn btn-danger btn-xs' href ='" . $_SERVER['PHP_SELF'] . "?route=modules/gl/setup/coa_groups/edit_coa_group&group_id=" . $coa['group_id'] . "'>Edit Group <span class='glyphicon glyphicon-edit'></span></a>\n\t\t\t ");
}
?>
<!-- Content Header (Page header) -->
<section class="content-header">
<h1>
Chart of Account Groups
<small>list of major chart of account groups .</small>
</h1>
<?php
$tbl = new HTML_Table('', 'data-table table table-striped table-bordered', array('data-title' => 'Saved Talent Lists'));
$tbl->addTSection('thead');
$tbl->addRow();
$tbl->addCell("<a class='pull btn btn-success btn-md' href ='" . $_SERVER['PHP_SELF'] . "?route=modules/talent_lists/create_talent_list'>Create New Talent List <span class='glyphicon glyphicon-plus'></span></a>");
$tbl->addRow();
$tbl->addCell('Title', '', 'header');
$tbl->addCell('Count', '', 'header');
$tbl->addCell('Talents Included', '', 'header');
$tbl->addCell('Actions', '', 'header');
$tbl->addTSection('tbody');
$sql = 'SELECT * FROM tams_talent_lists';
$get_saved_lists = DB::query($sql);
foreach ($get_saved_lists as $list) {
$tbl->addRow();
$tbl->addCell($list['talent_list_title']);
$dbh = 'SELECT COUNT(*)
FROM tams_talent_list_items
WHERE talent_list_id =' . $list['talent_list_id'];
$get_count = DB::queryFirstField($dbh);
$tbl->addCell("<span class='center-block'>" . $get_count . "</span>");
$tbl->addCell(list_talents_name($list['talent_list_id']));
$btnStr = ' onclick="';
$btnStr .= " return confirm('Are you sure you wish to delete this Record?'); ";
$btnStr .= ' " ';
$tbl->addCell("<a class=' btn btn-info btn-xs' href ='" . $_SERVER['PHP_SELF'] . "?route=modules/talent_lists/view_a_talent_list&talent_list_id=" . $list['talent_list_id'] . "'>View List <span class='glyphicon glyphicon-list'></span></a> \n\t\t\t <a class=' btn btn-danger btn-xs' href ='" . $_SERVER['PHP_SELF'] . "?route=modules/talent_lists/edit_talent_list&talent_list_id=" . $list['talent_list_id'] . "'>Edit List <span class='glyphicon glyphicon-edit'></span></a> \n\t\t\t <a class='btn btn-warning btn-xs' href ='process_delete_talent_list.php?action=delete_talent_list&id=" . $list['talent_list_id'] . "' " . $btnStr . " >Delete <span class='glyphicon glyphicon-trash'></span></a><br/>");
}
?>
<!-- Content Header (Page header) -->
<section class="content-header">
<?php
$tbl = new HTML_Table('', 'data-table table table-striped table-bordered', array('data-title' => 'List of Users'));
$tbl->addTSection('thead');
$tbl->addRow();
$tbl->addCell("<a class='pull btn btn-success btn-md' href ='" . $_SERVER['PHP_SELF'] . "?route=modules/document_types/add_document_type'>Add New Document Type <span class='glyphicon glyphicon-plus'></span></a>");
$tbl->addRow();
$tbl->addCell('Type ID', '', 'header');
$tbl->addCell('Type Name', '', 'header');
$tbl->addCell('Description', '', 'header');
$tbl->addCell('Status', '', 'header');
$tbl->addCell('Actions', '', 'header');
$tbl->addTSection('tbody');
$sql = 'SELECT * FROM tams_document_types WHERE document_type_status = "active"';
$get_document_types = DB::query($sql);
foreach ($get_document_types as $type) {
$tbl->addRow();
$tbl->addCell($type['document_type_id']);
$tbl->addCell($type['document_type_name']);
$tbl->addCell($type['document_type_desc']);
$tbl->addCell($type['document_type_status']);
$tbl->addCell("<a class='pull btn btn-danger btn-xs' href ='" . $_SERVER['PHP_SELF'] . "?route=modules/document_types/edit_document_type&document_type_id=" . $type['document_type_id'] . "'>Edit Document Type <span class='glyphicon glyphicon-edit'></span></a>\n\t\t\t ");
}
?>
<!-- Content Header (Page header) -->
<section class="content-header">
<h1>
System Settings
<small>list of Document Types. </small>
</h1>
<ol class="breadcrumb">
<?php
$tbl = new HTML_Table('', 'data-table table table-striped table-bordered', array('data-title' => 'List of Users'));
$tbl->addTSection('thead');
$tbl->addRow();
$tbl->addCell("<a class='pull btn btn-success btn-md' href ='" . $_SERVER['PHP_SELF'] . "?route=modules/users/add_user'>Add New User <span class='glyphicon glyphicon-plus'></span></a>");
$tbl->addRow();
$tbl->addCell('Login Name', '', 'header');
$tbl->addCell('Avatar', '', 'header');
$tbl->addCell('Full Name', '', 'header');
$tbl->addCell('Email', '', 'header');
$tbl->addCell('User Role', '', 'header');
$tbl->addCell('Status', '', 'header');
$tbl->addCell('Actions', '', 'header');
$tbl->addTSection('tbody');
function get_user_role_name($role_id)
{
$user_role_name = DB::queryFirstField("SELECT role_name from tams_user_roles WHERE role_id = {$role_id}");
return $user_role_name;
}
$sql = 'SELECT * FROM tams_users WHERE user_status = "active"';
$get_users = DB::query($sql);
foreach ($get_users as $user) {
$tbl->addRow();
$tbl->addCell($user['user_name'] . " (" . $user['user_id'] . ") ");
$tbl->addCell('<img src="' . $user['user_avatar_url'] . '" alt="avatar" />');
$tbl->addCell($user['user_title'] . " " . $user['first_name'] . " " . $user['last_name']);
$tbl->addCell("<a href='mailto:" . $user['user_email'] . "' >" . $user['user_email'] . "</a>");
$tbl->addCell(get_user_role_name($user['role_id']));
$tbl->addCell($user['user_status']);
$tbl->addCell("<a class='pull btn btn-danger btn-xs' href ='" . $_SERVER['PHP_SELF'] . "?route=modules/users/edit_user&user_id=" . $user['user_id'] . "'>Edit User <span class='glyphicon glyphicon-edit'></span></a>\n\t\t\t ");
<?php
$tbl = new HTML_Table('', 'table table-striped table-bordered');
$tbl->addRow();
$tbl->addCell('Config ID', '', 'header');
$tbl->addCell('Key', '', 'header');
$tbl->addCell('Key Label', '', 'header');
$tbl->addCell('Key Help Text', '', 'header');
$tbl->addCell('Value', '', 'header');
$tbl->addCell('Actions', '', 'header');
?>
<?php
$sql = 'SELECT * FROM ' . DB_PREFIX . 'sys_config';
$get = DB::query($sql);
foreach ($get as $config) {
$tbl->addRow();
$tbl->addCell($config['config_id']);
$tbl->addCell($config['key']);
$tbl->addCell($config['key_label']);
$tbl->addCell($config['key_help_text']);
$tbl->addCell($config['value']);
$tbl->addCell("<a data-toggle = 'modal' href ='#edit_system_configuration' class='pull btn btn-danger btn-xs' >Edit System Configrations <span class='glyphicon glyphicon-edit'></span></a>\n\t\t\t ");
}
$tbl->addRow();
$tbl->addCell('');
$tbl->addCell('<input type="text" name="key" value=""/>');
$tbl->addCell('<input type="text" name="key_label" value=""/>');
$tbl->addCell('<input type="text" name="key_help_text" value=""/>');
$tbl->addCell('<input type="text" name="value" value=""/>');
$tbl->addCell("<a class='btn btn-primary' href ='#'>Save <span class='glyphicon glyphicons-disk-saved'></span></a>");
<?php
$tbl = new HTML_Table('', 'table table-striped table-bordered');
$tbl->addRow();
$tbl->addCell('FY ID', '', 'header');
$tbl->addCell('FY Description', '', 'header');
$tbl->addCell('Start Date', '', 'header');
$tbl->addCell('End Date', '', 'header');
$tbl->addCell('Status', '', 'header');
$tbl->addCell('Actions', '', 'header');
?>
<?php
$sql = 'SELECT * FROM ' . DB_PREFIX . $_SESSION['co_prefix'] . 'fiscal_years ORDER by fiscal_year_start_date';
$get_fy = DB::query($sql);
foreach ($get_fy as $fy) {
$tbl->addRow();
$tbl->addCell($fy['fiscal_year_id']);
$tbl->addCell($fy['fiscal_year_desc']);
$tbl->addCell(getDateTime($fy['fiscal_year_start_date'], "dLong"));
$tbl->addCell(getDateTime($fy['fiscal_year_end_date'], "dLong"));
$tbl->addCell($fy['fy_status']);
$tbl->addCell("<a class='pull btn btn-danger btn-xs' href ='" . $_SERVER['PHP_SELF'] . "?route=modules/gl/setup/financial_periods/edit_fiscal_year&fisca_year_id=" . $fy['fiscal_year_id'] . "'>Edit Fiscal Year <span class='glyphicon glyphicon-edit'></span></a>\n\t\t\t ");
}
?>
<!-- Content Header (Page header) -->
<section class="content-header">
<h1>
Fiscal Years
<small>Defined Fiscal Years for Company Accounts.</small>
</h1>
function getTable($res, $width = '850', $obj = '')
{
$extra_table_attr = array('width' => $width);
$tbl = new HTML_Table(get_class($this), 'display', 0, 0, 2, $extra_table_attr);
$frm = new HTML_Form();
$kk_trick = array();
$tbl->addRow('', $kk_trick, '<tfoot>');
$tbl->addCell(tableFooter($obj), NULL, 'data', array('colspan' => '5'));
$tbl->addRow('main_table');
$tbl->addCell($frm->addInput('checkbox', 'checkboxall', '', array('class' => 'check-all')), 'first', 'header');
$tbl->addCell('Location', null, 'header');
$tbl->addCell('Time on site', null, 'header');
$tbl->addCell('User', null, 'header');
$tbl->addCell('On-Page', null, 'header');
$tbl->addCell('Referer', null, 'header');
$tbl->addCell('', null, 'header');
if ($res) {
$objGeoIP = new GeoIP();
while ($res->fetch($res)) {
$objGeoIP->search_ip($res->ip);
if ($objGeoIP->found()) {
$country = $objGeoIP->getCountryName();
} else {
$country = $res->ip;
}
$check_this = $frm->addInput('checkbox', 'check_row[]', $res->id, array('id' => 'check_row[]'));
$tbl->addRow($class);
$tbl->addCell($check_this);
$tbl->addCell('<a href="http://www.geoiptool.com/es/?IP=' . $res->ip . '" target="_blank">' . $country . '</a>');
$tbl->addCell(round(($res->hora - $res->conected_from) / 60, 2) . ' Min.');
$tbl->addCell($res->user != '' ? $res->user : '******');
$tbl->addCell('<a href="http://www.' . $web->domain . $res->page . '" target="_blank">' . $res->page . '</a>');
$tbl->addCell('<a href="' . $res->referer . '" target="_blank">' . substr($res->referer, 0, 20) . '</a>');
$tbl->addCell('<a href="admin-generic-edit.php?id=' . $res->id . '&fld=' . strtolower(get_class()) . '">
<img src="/template/kadmin/images/icons/pencil.png" alt="Edit" />
</a>
<a href="admin-generic-list.php?id=' . $res->id . '&fld=' . strtolower(get_class()) . '&action=delete"
onClick="return confirmDel();">
<img src="/template/kadmin/images/icons/cross.png" alt="Delete" />
</a>');
}
}
return $tbl->display();
}
