<?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(); }