function parseUserInfo_user_regdate($val)
{
if (strstr($val, '-')) {
return convert_date($val);
} else {
return convert_date(date('Y-m-d H:i:s', $val));
}
}
/**
* View filed transpo request.
*/
public function viewfiledtranspo()
{
$this->load->model(array('employees', 'transpoallowance'));
$this->load->library(array('transport'));
$this->load->helper(array('my_datetime_helper'));
$this->transpoallowance->load($this->uri->segment(3));
$this->employees->load($this->transpoallowance->EmployeeNumber);
$data['transpoallowance'] = $this->transpoallowance;
$data['employee'] = $this->employees;
$data['coverage'] = $this->transport->transpo_coverage($this->transpoallowance->EmployeeNumber, convert_date($this->transpoallowance->Datefrom, "Y-m-d"), convert_date($this->transpoallowance->Dateto, "Y-m-d"));
$this->load->view('transpohrapproval/viewfiledtranspo', $data);
}
function new_demande($new_debut, $new_demi_jour_deb, $new_fin, $new_demi_jour_fin, $new_nb_jours, $new_comment, $new_type, $DEBUG = FALSE)
{
//conversion des dates
$new_debut = convert_date($new_debut);
$new_fin = convert_date($new_fin);
// print_r($new_fin);
//$new_nb_jours = get_nb_jour($new_debut, $new_fin, $new_demi_jour_deb, $new_demi_jour_fin);
$PHP_SELF = $_SERVER['PHP_SELF'];
$session = session_id();
// echo " $new_debut, $new_demi_jour_deb, $new_fin, $new_demi_jour_fin, $new_nb_jours, $new_comment, $new_type<br><br>\n";
// exit;
// verif validité des valeurs saisies
$valid = verif_saisie_new_demande($new_debut, $new_demi_jour_deb, $new_fin, $new_demi_jour_fin, $new_nb_jours, $new_comment);
// verifie que le solde de conges sera encore positif après validation
if ($_SESSION['config']['solde_toujours_positif']) {
$valid = $valid && verif_solde_user($_SESSION['userlogin'], $new_type, $new_nb_jours, $DEBUG);
}
if ($valid) {
if (in_array(get_type_abs($new_type, $DEBUG), array('conges', 'conges_exceptionnels'))) {
$new_etat = 'demande';
} else {
$new_etat = 'ok';
}
$new_comment = addslashes($new_comment);
$periode_num = insert_dans_periode($_SESSION['userlogin'], $new_debut, $new_demi_jour_deb, $new_fin, $new_demi_jour_fin, $new_nb_jours, $new_comment, $new_type, $new_etat, 0, $DEBUG);
if ($periode_num != 0) {
echo schars(_('form_modif_ok')) . ' !<br><br>' . "\n";
//envoi d'un mail d'alerte au responsable (si demandé dans config de php_conges)
if ($_SESSION['config']['mail_new_demande_alerte_resp']) {
alerte_mail($_SESSION['userlogin'], ":responsable:", $periode_num, "new_demande", $DEBUG);
}
} else {
echo schars(_('form_modif_not_ok')) . ' !<br><br>' . "\n";
}
} else {
echo schars(_('resp_traite_user_valeurs_not_ok')) . ' !<br><br>' . "\n";
}
/* RETOUR PAGE PRINCIPALE */
// echo '<form action="'.$PHP_SELF.'?session='.$session.'" method="POST">';
// echo '<input type="submit" value="'. _('form_retour') .'">';
// echo '</form>';
echo "<a class=\"btn\" href=\"{$PHP_SELF}?session={$session}\">" . _('form_retour') . "</a>\n";
}
/**
* Retrieve list of sick leaves that may or may not require medical
* certificates.
*
* @param date $datefrom
* @param date $dateto
* @return string
*/
public function sick_leaves($start = NULL, $end = NULL)
{
// If date parameters are empty set it to the current date.
$sdate = iif(isset($start), $start, date('Y-m-d'));
$edate = iif(isset($end), $end, date('Y-m-d'));
$empty[] = array('No results found.', '', '', '', '', '', '');
$params = array('header' => $this->_tableheaders, 'class' => array('table table-striped table-bordered dt-table'));
$this->_ci->load->library('MY_table', $params, 'medcerts');
$sickleaves = $this->_ci->employeeleavesfiled->medcerts($sdate, $edate);
if (isset($sickleaves) && !empty($sickleaves)) {
for ($i = 0; $i < count($sickleaves); $i++) {
$tabledata[] = array(convert_date($sickleaves[$i]->DateFiled, 'M d, Y'), $sickleaves[$i]->Name, convert_date($sickleaves[$i]->LeaveFrom, 'M d, Y'), convert_date($sickleaves[$i]->LeaveTo, 'M d, Y'), $sickleaves[$i]->LeaveCount, leave_status($sickleaves[$i]), $this->_check_medcert($sickleaves[$i]->WithMedCert, $sickleaves[$i]->LeaveID));
}
if (isset($tabledata) && !empty($tabledata)) {
return $this->_ci->medcerts->generate($tabledata);
} else {
return $this->_ci->medcerts->generate($empty);
}
} else {
return $this->_ci->medcerts->generate($empty);
}
}
function maketable($result, $fields)
{
$num_papers = mysqli_num_rows($result);
if ($num_papers != 0) {
echo "<table class='papersTable'>";
//var_dump($fields);
//$fields = ["name", "filename", "author", "subject", "time"];
echo "<tr>";
for ($i = 0; $i < count($fields); $i++) {
echo "<th>";
echo $fields[$i];
echo "</th>";
}
echo "</tr>";
for ($i = 0; $i < $num_papers; $i++) {
$row = mysqli_fetch_assoc($result);
echo "<tr>";
foreach ($fields as $key) {
$val = $row[$key];
if (!in_array($key, $fields)) {
continue;
}
if ($key == "time") {
$val = convert_date($val);
}
if ($key == "filename") {
$val = "<a href='../papers/{$val}'>{$val}</a>";
$val = substr($val, 0, strrpos($val, '_'));
}
echo "<td style= 'padding: 0px 10px;'>{$val}</td>";
}
unset($val);
echo "</tr>";
//var_dump($rows[$i]);
}
echo "</table>";
}
}
/**
* Approve/ decline leave.
*/
public function update()
{
$this->load->model(array('employeeleavesfiled', 'employeeleaves', 'leavetype'));
$this->load->library('leave');
$this->load->helper(array('my_datetime_helper'));
$this->leavetype->Remarks = $this->db->escape($this->input->post('leavetype'));
$type = $this->leavetype->get();
$this->employeeleavesfiled->EmployeeNumber = $this->input->post('employeenumber');
$this->employeeleavesfiled->LeaveFrom = convert_date($this->input->post('leavefrom'), 'Y-m-d H:i:s');
$this->employeeleavesfiled->LeaveTo = convert_date($this->input->post('leaveto'), 'Y-m-d H:i:s');
$this->employeeleavesfiled->LeaveCount = $this->input->post('count');
$this->employeeleavesfiled->Type = $type[0]->LeaveType;
$this->employeeleavesfiled->Reason = $this->input->post('leavereason');
$this->employeeleavesfiled->Deleted = $this->input->post('status');
$this->employeeleavesfiled->WithPay = $this->input->post('withpay');
$this->employeeleavesfiled->AuditUser = '******';
$this->employeeleavesfiled->AuditDate = date('Y-m-d H:i:s');
$this->employeeleavesfiled->update($this->input->post('leaveid'));
// Update leave credits
// Leave is approved
if ($this->input->post('status') == 0) {
// Leave is with pay.
if ($this->input->post('withpay') == 1) {
$this->employees->load($this->input->post('employeenumber'));
// Employees hired after May 31, 2013 have no sick leave credits.
// They only earn vacation leave credits which can be used in place
// of the sick leave.
if (strtotime($this->employees->DateHired) > strtotime('May 31, 2013') && $this->input->post('leavetype') == 'Sick Leave') {
$leavetype = 'Vacation Leave';
} else {
$leavetype = $this->input->post('leavetype');
}
$this->leave->updatecredits($this->input->post('employeenumber'), $leavetype, $this->input->post('leavefrom'), $this->input->post('leaveto'));
// Update employee logs.
$this->leave->leavedetails($this->input->post('leaveid'));
}
}
}
/**
* Get leaves by date. Will return json which will be consumed by the
* fullcalendar.js plugin.
*
*/
public function leavebydate()
{
$this->load->model(array('employeeleavesfiled'));
$this->load->helper(array('my_datetime_helper'));
$start = $this->input->get('start');
$end = $this->input->get('end');
$leaves = $this->employeeleavesfiled->get_leavesfiled_bydate($this->session->userdata('employeenumber'), $start, $end);
$result = array();
for ($i = 0; $i < count($leaves); $i++) {
if ($leaves[$i]->Deleted == 1 && $leaves[$i]->WithPay == 0) {
// Pending or not approved leave.
$color = '#d6487e';
} else {
$color = '#82af6f';
}
// Notice the end date has a default time of 09:00:00, this is due
// to the nextDayTreshold in fullcalendar.js
// Refer to this link for the full explaination:
// http://fullcalendar.io/docs/event_rendering/nextDayThreshold/
$result[] = array('title' => $leaves[$i]->Reason, 'start' => convert_date($leaves[$i]->LeaveFrom, 'Y-m-d'), 'end' => convert_date($leaves[$i]->LeaveTo, 'Y-m-d 09:00:00'), 'leavetype' => trim($leaves[$i]->Type), 'color' => $color, 'leaveid' => $leaves[$i]->LeaveID);
}
echo json_encode($result);
}
function checknextfewdays($fecha, $feast, $num, $type, $month)
{
if ($fecha) {
$celebration = convert_date($fecha, $feast);
if ($type == 'month') {
$mes = explode("/", $celebration);
if ($mes[1] == $month) {
return true;
} else {
return false;
}
} elseif ($type == 'next') {
$until = check_days($celebration);
if ($until >= 0 && $until <= $num) {
$until++;
return $until;
} else {
return false;
}
}
} else {
return false;
}
}
echo "<table cellpadding=\"2\">\n";
$isData = false;
while ($row =& $dbResult->fetchRow(DB_FETCHMODE_ASSOC)) {
if (!$isData) {
require_once 'includes/convert_date.php';
echo "<tr><td valign=\"bottom\"><form action=\"gmembers.php\" method=\"post\"><input type=\"hidden\" name=\"group_id\" value=\"{$group_id}\"><input type=\"hidden\" name=\"orderby\" value=\"name\"><input type=\"submit\" class=\"{$btnUsername}\" value=\"" . T_("Username") . "\"></form></td><td valign=\"bottom\"><form action=\"gmembers.php\" method=\"post\"><input type=\"hidden\" name=\"group_id\" value=\"{$group_id}\"><input type=\"hidden\" name=\"orderby\" value=\"formatted_time\"><input type=\"submit\" class=\"{$btnDateJoin}\" value=\"" . T_("Date Joined") . "\"></form></td><td valign=\"bottom\"><form action=\"gmembers.php\" method=\"post\"><input type=\"hidden\" name=\"group_id\" value=\"{$group_id}\"><input type=\"hidden\" name=\"orderby\" value=\"priv\"><input type=\"submit\" class=\"{$btnPriv}\" value=\"" . T_("Privilege") . "\"></form></td>";
if ($partOf) {
//If the manager
echo "<td>" . T_("Delete") . "</td><td align=\"center\"><b style=\"text-decoration:underline; cursor:pointer;\" onmouseover=\"return overlib('" . T_("Select the checkbox to remove all his bookmarks") . "');\" onmouseout=\"return nd();\">?</b></td>";
}
echo "</tr>\n";
$isData = true;
}
$rec_name = "{$row["name"]}";
$rec_date_join = "{$row["formatted_time"]}";
$newDate = convert_date($rec_date_join);
$rec_priv = "{$row["priv"]}";
$priv = returnPrivName($rec_priv);
// TODO: Review privileges, not using a db cause of translations
$privn0 = returnPrivName('0');
$privn1 = returnPrivName('1');
$privn2 = returnPrivName('2');
$priv0 = "0";
$priv1 = "1";
$priv2 = "2";
switch ($rec_priv) {
case 0:
$priv0 .= "\" selected=\"selected";
break;
case 1:
$priv1 .= "\" selected=\"selected";
}
if ($topic_title == '') {
$topic_title = $l_emptyTopic;
}
if ($i > 0) {
$bg = 'tbCel1';
} else {
$bg = 'tbCel2';
}
if (isset($mod_rewrite) and $mod_rewrite) {
$urlp = "{$main_url}/{$forum}_{$topic}_";
} else {
$urlp = "{$main_url}/{$indexphp}action=vthread&forum={$forum}&topic={$topic}&page=";
}
$pageNavCell = pageNav(0, $numReplies + 1, $urlp, $forum == $CONF['forum_submittedarticles'] || $forum == $CONF['forum_gallery'] ? 10 : $viewmaxreplys, TRUE);
$whenPosted = convert_date($cols[4]);
if (trim($cols[1]) == '') {
$cols[1] = $l_emptyTopic;
}
//Forum icon
if (isset($fIcon[$forum])) {
$forumIcon = $fIcon[$forum];
} else {
$forumIcon = 'default.gif';
}
if (isset($mod_rewrite) and $mod_rewrite) {
$linkToTopic = "{$main_url}/{$forum}_{$topic}_0.html";
} else {
$linkToTopic = "{$main_url}/{$indexphp}action=vthread&forum={$forum}&topic={$topic}";
}
$list_topics .= ParseTpl($tpl);
function tzs_front_end_my_shipments_handler($atts)
{
ob_start();
global $wpdb;
$user_id = get_current_user_id();
$url = current_page_url();
$page = current_page_number();
$pp = TZS_RECORDS_PER_PAGE;
$active = isset($_GET['active']) ? trim($_GET['active']) : '1';
if ($user_id == 0) {
?>
<div>Для просмотра необходимо <a href="/account/login/">войти</a> или <a href="/account/registration/">зарегистрироваться</a></div>
<?php
} else {
$sql = "SELECT COUNT(*) as cnt FROM " . TZS_SHIPMENT_TABLE . " WHERE user_id={$user_id} AND active={$active};";
$res = $wpdb->get_row($sql);
if (count($res) == 0 && $wpdb->last_error != null) {
print_error('Не удалось отобразить список грузов. Свяжитесь, пожалуйста, с администрацией сайта');
} else {
$records = $res->cnt;
$pages = ceil($records / $pp);
if ($pages == 0) {
$pages = 1;
}
if ($page > $pages) {
$page = $pages;
}
$from = ($page - 1) * $pp;
// Добавим отбор счетов и сортировку по ним для активных записей
if ($active == 0) {
$sql = "SELECT * FROM " . TZS_SHIPMENT_TABLE . " WHERE user_id={$user_id} AND active={$active} ORDER BY time DESC LIMIT {$from},{$pp};";
} else {
$sql = "SELECT a.*,";
$sql .= " b.id AS order_id,";
$sql .= " b.number AS order_number,";
$sql .= " b.status AS order_status,";
$sql .= " b.dt_pay AS order_dt_pay,";
$sql .= " b.dt_expired AS order_dt_expired,";
$sql .= " IFNULL(b.dt_pay, a.time) AS dt_sort";
$sql .= " FROM " . TZS_SHIPMENT_TABLE . " a";
$sql .= " LEFT OUTER JOIN wp_tzs_orders b ON (b.tbl_type = 'SH' AND a.id = b.tbl_id AND ((b.status=1 AND b.dt_expired > NOW()) OR b.status=0) )";
$sql .= " WHERE a.user_id={$user_id} AND a.active={$active}";
$sql .= " ORDER BY order_status DESC, dt_sort DESC";
$sql .= " LIMIT {$from},{$pp};";
}
$res = $wpdb->get_results($sql);
if (count($res) == 0 && $wpdb->last_error != null) {
print_error('Не удалось отобразить список транспорта. Свяжитесь, пожалуйста, с администрацией сайта');
} else {
?>
<script src="/wp-content/plugins/tzs/assets/js/distance.js"></script>
<div id="my_products_wrapper">
<div id="my_products_table">
<table id="tbl_products">
<thead>
<tr id="tbl_thead_records_per_page">
<th colspan="4">
<div class="div_td_left">
<h3>Список <?php
echo $active === '1' ? 'публикуемых' : 'архивных';
?>
грузов</h3>
</div>
</th>
<th colspan="6">
<div id="my_products_button">
<?php
if ($active === '1') {
?>
<button id="view_del" onClick="javascript: window.open('/account/my-shipments/?active=0', '_self');">Показать архивные</button>
<?php
} else {
?>
<button id="view_edit" onClick="javascript: window.open('/account/my-shipments/?active=1', '_self');">Показать публикуемые</button>
<?php
}
?>
<button id="view_add" onClick="javascript: window.open('/account/add-shipment/', '_self');">Добавить груз</button>
</div>
</th>
</tr>
<tr>
<th id="tbl_trucks_id">№, дата и время заявки</th>
<th id="tbl_trucks_path" nonclickable="true">Пункты погрузки /<br>выгрузки</th>
<th id="tbl_trucks_dtc">Дата погрузки /<br>выгрузки</th>
<th id="tbl_trucks_ttr">Тип груза</th>
<th id="tbl_trucks_wv">Вес,<br>объем</th>
<th id="tbl_trucks_comm">Описание груза</th>
<th id="tbl_trucks_cost">Стоимость,<br/>цена 1 км</th>
<th id="tbl_trucks_payment">Форма оплаты</th>
<th id="comm">Комментарии</th>
<th id="actions" nonclickable="true">Действия</th>
</tr>
</thead>
<tbody>
<?php
foreach ($res as $row) {
$type = trans_types_to_str($row->trans_type, $row->tr_type);
$cost = tzs_cost_to_str($row->cost, true);
?>
<tr rid="<?php
echo $row->id;
?>
" <?php
echo $row->order_status == 1 ? ' class="top_record"' : ($row->order_status !== null && $row->order_status == 0 ? ' class="pre_top_record"' : '');
?>
>
<td>
<?php
echo $row->id;
?>
<br>
<?php
echo convert_time($row->time);
?>
</td>
<td>
<?php
echo tzs_city_to_str($row->from_cid, $row->from_rid, $row->from_sid, $row->sh_city_from);
?>
<br/><?php
echo tzs_city_to_str($row->to_cid, $row->to_rid, $row->to_sid, $row->sh_city_to);
?>
<?php
if ($row->distance > 0) {
?>
<br/>
<?php
echo tzs_make_distance_link($row->distance, false, array($row->sh_city_from, $row->sh_city_to));
?>
<?php
}
?>
</td>
<td><?php
echo convert_date($row->sh_date_from);
?>
<br/><?php
echo convert_date($row->sh_date_to);
?>
</td>
<td><?php
echo $GLOBALS['tzs_sh_types'][$row->sh_type];
?>
</td>
<td>
<?php
if ($row->sh_weight > 0) {
echo remove_decimal_part($row->sh_weight) . ' т<br>';
}
if ($row->sh_volume > 0) {
echo remove_decimal_part($row->sh_volume) . ' м³';
}
?>
</td>
<td><?php
echo htmlspecialchars($row->sh_descr);
?>
</td>
<td>
<?php
if ($row->price > 0) {
echo $row->price . ' ' . $GLOBALS['tzs_curr'][$row->price_val] . '<br><br>';
echo round($row->price / $row->distance, 2) . ' ' . $GLOBALS['tzs_curr'][$row->price_val] . '/км';
}
?>
</td>
<td><?php
echo $cost[1];
?>
</td>
<td><?php
echo htmlspecialchars($row->comment);
?>
</td>
<td>
<a href="javascript:doDisplay(<?php
echo $row->id;
?>
);" at="<?php
echo $row->id;
?>
" id="icon_set">Действия</a>
<div id="menu_set" id2="menu" for="<?php
echo $row->id;
?>
" style="display:none;">
<ul>
<a href="/account/view-shipment/?id=<?php
echo $row->id;
?>
&link=my-shipments&active=<?php
echo $active;
?>
">Смотреть</a>
<a href="/account/edit-shipment/?id=<?php
echo $row->id;
?>
">Изменить</a>
<?php
if ($row->active && $row->order_status === null) {
?>
<a href="javascript:promptPickUp(<?php
echo $row->id;
?>
, 'SH');">В ТОП</a>
<?php
}
?>
<?php
if ($row->active && $row->order_status !== null && $row->order_status == 0) {
?>
<a href="/account/view-order/?id=<?php
echo $row->order_id;
?>
">Счет ТОП</a>
<?php
}
?>
<a href="javascript: promptDelete(<?php
echo $row->id . ', ' . $row->active;
?>
);" id="red">Удалить</a>
</ul>
</div>
</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
<?php
include_once WP_PLUGIN_DIR . '/tzs/front-end/tzs.my.new_order.php';
?>
<script src="/wp-content/plugins/tzs/assets/js/jquery.stickytableheaders.min.js"></script>
<script>
jQuery(document).ready(function(){
jQuery('table').on('click', 'td', function(e) {
var nonclickable = 'true' == e.delegateTarget.rows[1].cells[this.cellIndex].getAttribute('nonclickable');
var id = this.parentNode.getAttribute("rid");
if (!nonclickable)
document.location = "/account/view-shipment/?id="+id+"&link=my-shipments&active=<?php
echo $active;
?>
";
});
jQuery("#tbl_products").stickyTableHeaders();
});
function doDisplay(id) {
var el = jQuery('div[for='+id+']');
if (el.attr('style') == null) {
el.attr('style', 'display:none;');
jQuery('a[at='+id+']').attr('id', 'icon_set');
} else {
el.removeAttr('style');
jQuery('a[at='+id+']').attr('id', 'icon_set_cur');
}
jQuery("div[id2=menu]").each(function(i) {
var id2 = this.getAttribute('for');
if (id2 != ''+id) {
this.setAttribute('style', 'display:none;');
jQuery('a[at='+id2+']').attr('id', 'icon_set');
}
});
}
function promptDelete(id, active) {
if (active === 1) {
var s_text = '<div><h2>Удалить запись '+id+' или перенести в архив ?</h2><hr/><p>Запись из архива можно в любой момент снова опубликовать.</p></div>';
buttons1 = new Object({
'В архив': function () {
jQuery(this).dialog("close");
doDelete(id, 0);
},
'Удалить': function () {
jQuery(this).dialog("close");
doDelete(id, 1);
},
'Отменить': function () {
jQuery(this).dialog("close");
}
});
} else {
var s_text = '<div><h2>Удалить запись '+id+' из архива ?</h2><hr/><p>Запись из архива можно в любой момент снова опубликовать.</p></div>';
buttons1 = new Object({
'Удалить': function () {
jQuery(this).dialog("close");
doDelete(id, 1);
},
'Отменить': function () {
jQuery(this).dialog("close");
}
});
}
jQuery('<div></div>').appendTo('body')
.html(s_text)
.dialog({
modal: true,
title: 'Удаление',
zIndex: 10000,
autoOpen: true,
width: 'auto',
resizable: false,
buttons: buttons1,
close: function (event, ui) {
jQuery(this).remove();
}
});
}
function doDelete(id, is_delete) {
var data = {
'action': 'tzs_delete_shipment',
'id': id,
'is_delete': is_delete
};
jQuery.post(ajax_url, data, function(response) {
if (response == '1') {
location.reload();
} else {
alert('Не удалось удалить: '+response);
}
});
}
</script>
<?php
build_pages_footer($page, $pages);
}
}
}
$output = ob_get_contents();
ob_end_clean();
return $output;
}
$sorting_script = true;
include 'header.php';
include 'access.php';
$access = checkAccess('a');
if ($access) {
echo "<h2>" . T_("Settings") . " -- " . T_("Online Users") . "</h2>";
echo "<p>" . sprintf(T_("You can see a list of users who have been active in the past %s minutes"), ONLINE_TIMEOUT / 60) . ".</p>\n";
include 'conn.php';
$Query = "select name, LastActivity as formatted_time from " . TABLE_PREFIX . "session where " . DATE_DIFF_SQL . " LastActivity) < " . ONLINE_TIMEOUT . " and status <> 'disabled' order by LastActivity";
$dbResult = $dblink->query($Query);
//echo($Query . "<br>");
$count = 0;
while ($row =& $dbResult->fetchRow(DB_FETCHMODE_ASSOC)) {
if ($count == 0) {
echo "<div class=\"content\"><table class='sortable'>\n<thead><tr><th>" . T_("User") . "</th><th>" . T_("Last Activity") . "</th></tr></thead><tbody>\n";
require_once 'includes/convert_date.php';
}
$user_rec = "{$row["name"]}";
$date1 = "{$row["formatted_time"]}";
$date2 = convert_date($date1);
echo "<tr><td><a href=\"userb.php?uname=" . $user_rec . "\">" . $user_rec . "</a></td><td>" . $date2 . "</td></tr>\n";
$count++;
}
if ($count == 0) {
echo "<p>" . sprintf(T_("No users have been active in the past %s minutes"), ONLINE_TIMEOUT / 60) . ".</p>\n";
} else {
echo "</tbody></table></div>\n";
}
echo "<p><a href=\"controlpanel.php\"><< " . T_("Back to Settings") . "</a></p>";
}
include 'footer.php';
$page['match'][$i]['team_visitor'] = $ligne['team_visitor_name'];
}
if ($ligne['team_home_name'] != NULL) {
$page['match'][$i]['team_home'] = $ligne['team_home_name'];
}
$page['match'][$i]['sex_visitor'] = $ligne['sex_visitor_name'];
$page['match'][$i]['sex_home'] = $ligne['sex_home_name'];
$page['match'][$i]['sex_visitor_abbreviation'] = $ligne['sex_visitor_abbreviation'];
$page['match'][$i]['sex_home_abbreviation'] = $ligne['sex_home_abbreviation'];
$page['match'][$i]['competition'] = $ligne['competition_id'];
$page['match'][$i]['competition_name'] = $ligne['competition_name'];
$page['match'][$i]['field_state'] = $ligne['field_state_id'];
$page['match'][$i]['field'] = $ligne['field_id'];
$page['match'][$i]['weather'] = $ligne['weather_id'];
$page['match'][$i]['date'] = convert_date($ligne['match_date'], $lang['match']['format_date_php']);
$page['match'][$i]['hour'] = convert_date($ligne['match_date'], $lang['match']['format_hour_php']);
if ($page['match'][$i]['hour'] == "00:00") {
$page['match'][$i]['hour'] = "";
}
$page['match'][$i]['score_visitor'] = $ligne['match_score_visitor'];
$page['match'][$i]['score_home'] = $ligne['match_score_home'];
$page['match'][$i]['spectators'] = $ligne['match_spectators'];
$page['match'][$i]['comment'] = $ligne['match_comment'];
if ($tmp_date != $page['match'][$i]['date']) {
$page['match'][$i]['show_date'] = '1';
} else {
$page['match'][$i]['show_date'] = '';
}
$tmp_date = $page['match'][$i]['date'];
$page['match'][$i]['L_details'] = $lang['match']['show_view'];
$page['match'][$i]['L_edit'] = $lang['match']['edit'];
public static function convert_date($original_date, $new_format = '')
{
$original_date = convert_date($original_date, 'Y-m-d H:i:s');
$original_date = str_replace('-', '/', $original_date);
return date_i18n($new_format, strtotime($original_date));
}
function test($s)
{
echo "<br>{$s} --> " . convert_date($s);
}
public static function Get_account_breakdown($start_date, $end_date, $account_id, &$account_list)
{
$account_list = array();
$error = '';
// convert dates into mysql dates
$start_sql = convert_date($start_date, 1);
$end_sql = convert_date($end_date, 1);
if ($account_id < 0) {
return 'You must enter a correct account id';
} elseif ($start_sql == '') {
return 'Start date is invalid.';
} elseif ($end_sql == '') {
return 'End date is invalid.';
}
$sql = "SELECT sum( ledger_amount ) AS total_amount, " . " coalesce( a2.account_id, a.account_id ) as account_id, " . " min( coalesce( a2.account_name, a.account_name ) ) as name " . "FROM Ledger_Entries le \n" . "INNER JOIN Transactions t ON t.trans_id = le.trans_id \n" . "INNER JOIN Accounts a ON le.account_id = a.account_id \n" . "LEFT JOIN Accounts a2 ON a.account_parent_id = a2.account_id " . " AND a2.account_id <> :account_id \n" . "WHERE ( a.account_parent_id= :account_id " . " OR a2.account_parent_id= :account_id OR a.account_id = :account_id ) \n" . " AND t.accounting_date >= :start_sql " . " AND t.accounting_date <= :end_sql \n" . "GROUP BY coalesce( a2.account_id, a.account_id ) \n" . "ORDER BY total_amount DESC ";
$pdo = db_connect_pdo();
$ps = $pdo->prepare($sql);
$ps->bindParam(':account_id', $account_id);
$ps->bindParam(':start_sql', $start_sql);
$ps->bindParam(':end_sql', $end_sql);
$success = $ps->execute();
if (!$success) {
return get_pdo_error($ps);
}
// account_list (account_name, account_total, account_id)
while ($row = $ps->fetch(PDO::FETCH_ASSOC)) {
$account_list[$row['account_id']] = array($row['name'], $row['total_amount'], $row['account_id']);
}
$pdo = null;
return $error;
}
value="1" style="margin-top: 5px;"></input></dt>
</dl>
</fieldset>
</div>
<div style="display: inline-block; float: left">
<fieldset>
<legend>date administrative</legend>
<dl>
<dt><label class="label" style="vertical-align: top; padding-top: 5px;">detalii</label><textarea class="standard" style="min-height: 73px;" name="ClDetalii" ><?php
echo $client->Detalii;
?>
</textarea></dt>
<dt><label class="label">data actualizare</label><input type="text" name="ClDataActualizare" id="dataactualizare" value="<?php
echo convert_date($client->DataActualizare);
?>
"></input>
<input type="button" id="calendar-trigger" value='...'/><br/>
<script>
var cal1=Calendar.setup({onSelect:function(){cal1.hide();}});
cal1.manageFields("calendar-trigger", "dataactualizare", "%d/%m/%Y");
</script>
</dt>
<dt>
<label class="label">agent</label><select name='ClidUtilizator' class="standard">
<?php
$userlist = User::find_all();
foreach ($userlist as $agent) {
echo "<option ";
if ($agent->id == $client->idUtilizator) {
$ligne = sql_fetch_array($res);
sql_free_result($res);
sql_close($sgbd);
$page['value_idurl'] = $ligne['news_idurl'];
$page['value_subhead'] = $ligne['news_subhead'];
$page['value_title'] = $ligne['news_title'];
$page['value_subtitle'] = $ligne['news_subtitle'];
$page['value_summary'] = $ligne['news_summary'];
$page['value_summary'] = stripslashes($ligne['news_summary']);
$page['value_text'] = $ligne['news_text'];
$page['value_text'] = stripslashes($ligne['news_text']);
$page['value_ps'] = $ligne['news_ps'];
$page['value_keyword'] = $ligne['news_keyword'];
$page['value_status'] = $ligne['news_status'];
$page['value_release'] = convert_date($ligne['news_release'], $lang['news']['format_date_form']);
$page['value_release_time'] = convert_date($ligne['news_release'], $lang['news']['format_time_form']);
if ($page['value_release_time'] == '00:00') {
$page['value_release_time'] = '';
}
}
/* status */
$page['status']['0']['id'] = "0";
$page['status']['0']['name'] = $lang['news']['supprime'];
$page['status']['0']['selected'] = "";
$page['status']['1']['id'] = "1";
$page['status']['1']['name'] = $lang['news']['en_attente'];
$page['status']['1']['selected'] = "";
$page['status']['2']['id'] = "2";
$page['status']['2']['name'] = $lang['news']['valid'];
$page['status']['2']['selected'] = "";
if ($page['value_status'] == "0") {
$count++;
}
/*while ( $b > 0 ) {
$keys2 = array_rand($pictures, 1);
$img2 = "$dir_thumbs/$pictures[$keys2]";
$imgsize2 = getimagesize($img2);
if ($imgsize2[1] <= 90) $b = 0;
}*/
unset($gallery);
}
/******************************************/
$result["date_formatted"] = convert_date($result["date_formatted"], '');
if ($module != 'admin' && $lang_active == 'EN') {
$result[title] = $result[title_EN];
}
if ($module != 'admin' && $lang_active == 'EN') {
$result[description] = $result[description_EN];
}
if ($module != 'admin') {
$result[description] = nl2br($result[description]);
}
if (isset($save_pages)) {
$tpl->assign("array_p", $save_pages);
$lastpage = end($save_pages);
$tpl->assign("pagesT", $lastpage['page']);
$tpl->assign("title_pagenavi", $gal_navi);
}
/**
* Get the list of employees that have filed overtime within a specified
* date range.
*
* @param string $employeenumber
* @param string $datestart
* @param string $dateend
* @return mixed
*/
public function filed_overtime($employeenumber, $startdate, $enddate)
{
$subordinates = $this->_ci->employeelogs->filed_overtime($employeenumber, $startdate, $enddate);
$tabledata = array();
$params = array('header' => $this->_filedot, 'class' => array('table table-striped table-bordered dt-table'));
$this->_ci->load->library('MY_table', $params, 'subordinate_list');
if (isset($subordinates) && !empty($subordinates)) {
for ($i = 0; $i < count($subordinates); $i++) {
$tabledata[] = array($this->_ot_modal($subordinates[$i]->UserlogID, "filedot/viewfiledovertime?logid=" . $subordinates[$i]->UserlogID), $subordinates[$i]->FirstName, $subordinates[$i]->LastName, convert_date($subordinates[$i]->TimeIn, "M d, Y h:i A"), convert_date($subordinates[$i]->Timeout, "M d, Y h:i A"), convert_date($subordinates[$i]->AuditDate, "M d, Y"), $this->_ot_status($subordinates[$i]));
}
if (isset($tabledata) && !empty($tabledata)) {
return $this->_ci->subordinate_list->generate($tabledata);
} else {
return $this->_ci->subordinate_list->generate();
}
} else {
return $this->_ci->subordinate_list->generate();
}
}
function sync_health_details($uid, $program, $pxid, $arr_tablet, $ccdev_id)
{
$arr_conflict_data = array();
$q_consult_id = mysql_query("SELECT consult_id FROM m_consult ORDER by consult_id DESC") or die("Cannot query 420: " . mysql_error());
list($consult_id) = mysql_fetch_array($q_consult_id);
$consult_id = $consult_id + 1;
$insert_made = 0;
$userid = 1;
switch ($program) {
case 'Expanded Program for Immunization':
$get_value_to_match = mysql_query("SELECT db_table, emr_field_name, tablet_field_name, value_to_match FROM m_lib_mm_data_map WHERE question_id='{$program}' AND value_to_match!=''") or die("Cannot query 421: " . mysql_error());
while (list($db_table, $emr_field_name, $tablet_field_name, $value_to_match) = mysql_fetch_array($get_value_to_match)) {
$field_name_to_compare = $db_table == 'm_consult_ccdev_vaccine' ? 'vaccine_id' : 'service_id';
$field_date = $db_table == 'm_consult_ccdev_vaccine' ? 'actual_vaccine_date' : 'ccdev_service_date';
$q_health_data = mysql_query("SELECT " . $emr_field_name . " FROM " . $db_table . " WHERE " . $field_name_to_compare . "='" . $value_to_match . "' AND patient_id='" . $pxid . "'") or die("Cannot query 425: " . mysql_error());
if (mysql_num_rows($q_health_data) == 0) {
//the vaccine_id/service_id not seen, insert the ID
//echo $db_table.'/'.$emr_field_name.'/'.$tablet_field_name.'/'.$value_to_match."<br>";
$date_given = convert_date($arr_tablet[$tablet_field_name]);
if ($date_given != "0000-00-00") {
$str_sql = "INSERT INTO " . $db_table . " SET " . $field_date . "='" . $date_given . "', consult_id='" . $consult_id . "',user_id='" . $userid . "',patient_id='" . $pxid . "', " . $field_name_to_compare . "='" . $value_to_match . "',ccdev_id='" . $ccdev_id . "'";
//echo $str_sql."<br><br>";
$q_insert_health_data = mysql_query($str_sql) or die("Cannot query 440: " . mysql_error());
$q_insert_vaccine = mysql_query("INSERT INTO m_consult_vaccine SET consult_id='{$consult_id}',patient_id='{$pxid}',user_id='{$userid}',vaccine_timestamp=NOW(),actual_vaccine_date='{$date_given}',source_module='ccdev',adr_flag='N',vaccine_id='{$value_to_match}'") or die("Cannot query 529: " . mysql_error());
$insert_made = 1;
} else {
}
} else {
list($emr_date_value) = mysql_fetch_array($q_health_data);
if ($emr_date_value != '0000-00-00') {
$tablet_date = convert_date($arr_tablet[$tablet_field_name]);
if ($emr_date_value != $tablet_date) {
//conflicting data, allow the user to select
array_push($arr_conflict_data, array($db_table, $field_name_to_compare, $emr_date_value, $tablet_date, $value_to_match, $field_date, $tablet_field_name));
}
}
}
}
if ($insert_made == 1 && !empty($_GET["uid"])) {
$healthcenter_id = $_SESSION["datanode"]["code"];
$q_insert_consult = mysql_query("INSERT INTO m_consult SET consult_id='{$consult_id}',patient_id='{$pxid}',user_id='{$userid}',healthcenter_id='{$healthcenter_id}',consult_timestamp=NOW(),consult_end=NOW(),consult_date=NOW(),see_doctor_flag='N'");
echo "<script language='Javascript'>";
echo "window.alert('The record for {$_GET['program']} was saved.')";
echo "</script>";
header("Location:" . $_SERVER["PHP_SELF"] . "?type={$_GET['type']}&title={$_GET['title']}&uid={$_GET['uid']}&program={$_GET['program']}&action={$_GET['action']}");
} else {
echo "<script language='Javascript'>";
echo "window.alert('No update found for this client record for the {$_GET['program']}')";
echo "</script>";
}
if (count($arr_conflict_data) != 0) {
echo "<script language='Javascript'>";
echo "window.alert('There was a data conflict identified. Select whether to save the mobile device or the EMR value.')";
echo "</script>";
display_conflict_date($arr_conflict_data, $uid, $pxid);
}
break;
default:
break;
}
}
while ($row_latest = mysql_fetch_array($result_latest)) {
?>
<div class="post">
<h2>
<a href="index.php?page=single&post_id=<?php
echo $row_latest['post_id'];
?>
">
<?php
echo $row_latest['title'];
?>
</a></h2>
<div class="meta"><span class="date"><?php
echo convert_date($row_latest['date']);
?>
</span><span class="cat"> in category <?php
echo $row_latest['name'];
?>
</span></div><!--END meta-->
<div class="entry"><?php
echo $row_latest['body'];
?>
</div><!--END ENTRY-->
<hr />
</div> <!--END POST-->
<?php
}
//end --while-- loop
} else {
function login($username, $pass, $passEncrypted = false)
{
global $SETTINGS;
/*
$resultArr['message'] : the message displaying either the error or success, used with p class ("error"/"success")
$resultArr['optmessage'] : the message explaining more in details the error
$resultArr['success'] : the bool saying whether or not the login was successfull
$resultArr['username'] : the "real" username of the user
*/
$resultArr = array();
$resultArr['success'] = false;
include $SETTINGS['path_mod'] . 'conn.php';
if ($username != null && $pass != null) {
require_once $SETTINGS['path_mod'] . 'includes/protection.php';
//Check if the name and pass strings are valid (for protection)
if (!(valid($username, 20) && valid($pass, 50))) {
$resultArr['message'] = T_("Please check your username and password and make sure that they are correctly spelled.");
} else {
//Check if the name exists on the database
$Query = sprintf("select name from " . TABLE_PREFIX . "session where name=%s", quote_smart($username));
//echo($Query . "<br>\n");
$dbResult = $dblink->query($Query);
if ($row =& $dbResult->fetchRow(DB_FETCHMODE_ASSOC)) {
//Check if user is demo, to avoid blocking the account
$democheck = strtoupper($username);
$logtries = 0;
if ($democheck != "DEMO") {
//Check if user is connecting more than 3 times
$Query = sprintf("select success from " . TABLE_PREFIX . "loginhits where name=%s and " . DATE_DIFF_SQL . " time) < " . WAITTIME . " order by time", quote_smart($username));
//echo($Query . "<br>\n");
$dbResult = $dblink->query($Query);
$success = 'N';
while ($row =& $dbResult->fetchRow(DB_FETCHMODE_ASSOC)) {
$success = "{$row["success"]}";
if ($success == 'N') {
$logtries++;
}
}
if ($success == 'Y') {
$logtries = 0;
}
}
//Check if user tried more than 3 times
if ($logtries < 3) {
//Encrypt password if not already
if (!$passEncrypted) {
$passencrypt = $this->encryptPassword($pass);
} else {
$passencrypt = $pass;
}
// Make a safe query
$Query = sprintf("select name, status from " . TABLE_PREFIX . "session where name=%s and pass=%s", quote_smart($username), quote_smart($passencrypt));
//echo($Query);
$dbResult = $dblink->query($Query);
if ($row =& $dbResult->fetchRow(DB_FETCHMODE_ASSOC)) {
$status = "{$row["status"]}";
$realname = "{$row["name"]}";
//Check if user is activated, if not an admin
if ($status != "admin" && $democheck != "DEMO") {
$Query = "select name, activated from " . TABLE_PREFIX . "activation where (name='" . $username . "')";
//echo($Query . "<br>\n");
$dbResult = $dblink->query($Query);
$yesno = '';
if ($row =& $dbResult->fetchRow(DB_FETCHMODE_ASSOC)) {
$yesno = "{$row["activated"]}";
}
}
if ($yesno == 'Y' || ($status == "admin" || $democheck == "DEMO")) {
$resultArr['success'] = true;
//Set the session variabless and return vars
$_SESSION['privInSession'] = "normal";
$_SESSION['nameInSession'] = $realname;
$this->usernameSession = $realname;
$resultArr['username'] = $realname;
//check if the user wants to be remember: set cookie
if (isset($_POST['remember'])) {
setcookie("gbname", $realname, time() + 60 * 60 * 24 * 100, "/");
setcookie("gbpass", $passencrypt, time() + 60 * 60 * 24 * 100, "/");
}
$resultArr['message'] = T_("Welcome back") . " <b>" . $realname . "</b>!";
$Query = "SELECT lastlog AS formatted_time, style from " . TABLE_PREFIX . "session where name='" . $username . "'";
//echo($Query . "<br>\n");
$dbResult = $dblink->query($Query);
if ($row =& $dbResult->fetchRow(DB_FETCHMODE_ASSOC)) {
$date1 = "{$row["formatted_time"]}";
require_once 'convert_date.php';
$date2 = convert_date($date1, true);
$resultArr['message'] .= " " . T_("Your last login was on") . " " . $date2;
$style = "{$row["style"]}";
}
//Check user's browser and user's preference (to do)
include 'browser.php';
$br = new Browser();
$_SESSION['browser'] = $br->Name;
$browser = $_SESSION['browser'];
if ($browser == "MSIE") {
$browser = "Internet Explorer";
}
$_SESSION['layoutInSession'] = "no_js";
$_SESSION['styleInSession'] = "";
if ($style == "Auto") {
if ($browser == "Internet Explorer") {
$_SESSION['styleInSession'] = "IE";
} else {
if ($browser == "Opera") {
$_SESSION['styleInSession'] = "Opera";
} else {
$_SESSION['styleInSession'] = "Firefox";
}
}
} else {
$_SESSION['styleInSession'] = $style;
}
$this->styleSession = $_SESSION['styleInSession'];
//Update last logging time
//$time = date('Y-m-d H:i:s');
$Query = "update " . TABLE_PREFIX . "session set LastLog = now(), LastActivity = now() where name='" . $username . "'";
$dbResult = $dblink->query($Query);
//Check for user's privileges
$Query = "select status from " . TABLE_PREFIX . "session where name='" . $username . "'";
$dbResult = $dblink->query($Query);
//echo($Query . "<br>\n");
$found = false;
$priv = "";
if ($row =& $dbResult->fetchRow(DB_FETCHMODE_ASSOC)) {
$priv = "{$row["status"]}";
$found = true;
}
// TODO: Please change the following emails below
$loginSuccess = 'Y';
if ($found && $priv == "admin") {
$_SESSION['privInSession'] = "admin";
} else {
if ($found && $priv == "disabled") {
$_SESSION['privInSession'] = "disabled";
$resultArr['success'] = false;
$_SESSION['nameInSession'] = null;
$this->usernameSession = null;
$resultArr['username'] = null;
$resultArr['message'] = T_("Your account has been disabled") . ".";
$loginSuccess = 'D';
$resultArr['optmessage'] = sprintf(T_("This has been done by our anti-spam system. If you think it is a mistake, please email <a href=\"%s\">%s</a>.<br>\n<i>Expect 1-2 days of response by email</i>"), "mailto:support@getboo.com", "*****@*****.**");
} else {
$_SESSION['privInSession'] = "normal";
}
}
$this->privSession = $_SESSION['privInSession'];
// Update loginhits table
$Query = "\r\n\t\t\t\t\t\t\t\t\t\t\tINSERT INTO " . TABLE_PREFIX . "loginhits\r\n\t\t\t\t\t\t\t\t\t\t\t(Name, Time, IP, Success)\r\n\t\t\t\t\t\t\t\t\t\t\tVALUES\r\n\t\t\t\t\t\t\t\t\t\t\t('{$realname}', now(), '" . $_SERVER['REMOTE_ADDR'] . "', '{$loginSuccess}')\r\n\t\t\t\t\t\t\t\t\t\t\t";
$dbResult = $dblink->query($Query) or die("Couldn't update the database");
} else {
$resultArr['message'] = T_("Your account is not activated") . ".";
$resultArr['optmessage'] = "" . sprintf(T_("You must first <a href=\"%s\">activate</a> your account with the code emaild to you when you registered"), "activate.php") . ".<br>\n " . sprintf(T_("Please check your email in order to get your activation code<br>\n or email <a href=\"%s\">%s</a> if you don't receive any email from us after 24h"), "mailto:registration@getboo.com", "*****@*****.**") . ".<br>\n<i>" . T_("Expect 1-2 days of response by email") . "</i>";
}
} else {
$resultArr['message'] = T_("The password is invalid") . ".";
if ($democheck != "DEMO") {
//$time = date('Y-m-d H:i:s');
$Query = "\r\n\t\t\t\t\t\t\t\t\t\tINSERT INTO " . TABLE_PREFIX . "loginhits\r\n\t\t\t\t\t\t\t\t\t\t(Name, Time, IP, Success)\r\n\t\t\t\t\t\t\t\t\t\tVALUES\r\n\t\t\t\t\t\t\t\t\t\t('{$username}', now(), '" . $_SERVER['REMOTE_ADDR'] . "', 'N')\r\n\t\t\t\t\t\t\t\t\t\t";
}
$dbResult = $dblink->query($Query);
}
} else {
$resultArr['message'] = T_("Too many login tries") . ".";
$resultArr['optmessage'] = sprintf(T_("You have tried to log in more than 3 times unsuccessfully for this account in the last %s minutes"), WAITTIME / 60) . ".<br><br>" . sprintf(T_("Please try again in %s minutes"), WAITTIME / 60) . ".";
}
} else {
$resultArr['message'] = T_("The user does not exist") . ".";
}
}
} else {
$resultArr['message'] = T_("Username or Password is missing") . "";
}
return $resultArr;
}
$match_field_num = array();
// numero des colonnes correspondants
# required for step 4 : we need existing matchs list
$match_list = array();
//if($page['value_step']=='validation') {
$var['condition'] = " ";
$var['order'] = " ORDER BY m.match_date DESC ";
$var['limit'] = " ";
$sql_match = sql_replace($sql['match']['select_match_condition'], $var);
$sgbd = sql_connect();
$res_match = sql_query($sql_match);
$nb_ligne = sql_num_rows($res_match);
if ($nb_ligne != "0") {
while ($ligne = sql_fetch_array($res_match)) {
$id = $ligne['match_id'];
$match_list[$id] = convert_date($ligne['match_date'], $lang['match']['format_date_form']) . " " . convert_date($ligne['match_date'], $lang['match']['format_hour_form']) . " : ";
if ($ligne['club_home_abbreviation'] != '') {
$match_list[$id] .= $ligne['club_home_abbreviation'];
} else {
$match_list[$id] .= $ligne['club_home_name'];
}
if ($ligne['team_home_name'] != '') {
$match_list[$id] .= ' ' . $ligne['team_home_name'];
}
if ($ligne['sex_home_abbreviation'] != '') {
$match_list[$id] .= ' [' . $ligne['sex_home_abbreviation'] . '] ';
}
$match_list[$id] .= ' - ';
if ($ligne['club_visitor_abbreviation'] != '') {
$match_list[$id] .= $ligne['club_visitor_abbreviation'];
} else {
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
***************************************************************************/
include 'header.php';
include 'access.php';
$access = checkAccess();
if ($access) {
include 'sbheader.php';
include 'includes/convert_date.php';
echo "<b>" . T_("Stats") . " -- " . T_("Searches") . "</b><br><br>\n";
$Query = "select keyword, count(*) as Count, max(time) as Time from " . TABLE_PREFIX . "searches s where s.name='{$username}' group by keyword order by Count desc";
//echo($Query . "<br>\n");
$dbResult = $dblink->query($Query);
$count = 0;
while ($row =& $dbResult->fetchRow(DB_FETCHMODE_ASSOC)) {
if ($count == 0) {
echo "<table><tr><td><u>" . T_("Keyword") . "</u></td><td><u>" . T_("Count") . "</u></td><td><u>" . T_("Last Search Date") . "</u></td></tr>\n";
}
$keyword = "{$row["keyword"]}";
$count = "{$row["count"]}";
$time = "{$row["time"]}";
$time2 = convert_date($time);
echo "<tr><td>{$keyword}</td><td>{$count}</td><td>{$time2}</td></tr>\n";
$count++;
}
echo "</table>";
if ($count == 0) {
echo '<p class="notice">' . T_("No searches") . '</p>';
}
echo "</div>";
}
include 'footer.php';
</div>
</div>
<div class="modal-body">
<?php
echo form_open($action = site_url('leaves/update'), $attributes = array('id' => 'updateleave', 'name' => 'updateleave', 'role' => 'form'));
?>
<?php
echo form_hidden(array('leaveid' => $leave->LeaveID, 'employeenumber' => $leave->EmployeeNumber));
?>
<h6>From:</h6>
<?php
echo form_input(array('name' => 'leavefrom', 'id' => 'leavefrom', 'data-date-format' => 'yyyy-mm-dd', 'class' => 'form-control date-picker'), convert_date($leave->LeaveFrom, "Y-m-d"), 'required');
?>
<h6>To:</h6>
<?php
echo form_input(array('name' => 'leaveto', 'id' => 'leaveto', 'data-date-format' => 'yyyy-mm-dd', 'class' => 'form-control date-picker'), convert_date($leave->LeaveTo, "Y-m-d"), 'required');
?>
<h6>Type:</h6>
<?php
echo form_dropdown('leavetypes', $leavetypes, $leavedescription[trim($leave->Type)], 'class="form-control" id="leavetypes"');
?>
<h6>Reason:</h6>
<?php
echo form_textarea(array('name' => 'leavereason', 'id' => 'leavereason', 'rows' => '7', 'class' => 'form-control'), $leave->Reason, 'required');
?>
<h6>Status: <strong><em><?php
echo leave_status($leave);
?>
</em></strong></h6>
<?php
/**
* Update employee leave credits. But we'll need to loop through the
* dates to check if one (or all) the dates fall on a holiday. If the
* date fall on a holiday we'll need to exclude it from the leave
* credits deduction.
*
* @param string $employeenumber
* @param string $leavetype
* @param date $start
* @param date $end
* @return void
*/
public function updatecredits($employeenumber, $leavetype, $start, $end)
{
$days = days_difference($start, $end);
$holidays = 0;
// We'll loop through the days.
for ($i = 0; $i < $days; $i++) {
if ($this->_ci->holidays->checkholiday(convert_date(date_subtract($i, date_create($end)), 'Y-m-d'))) {
$holidays++;
}
}
$this->_ci->employeeleaves->load($employeenumber);
$leavecoltype = substr($leavetype, 0, strpos($leavetype, ' '));
$remainingcredits = $this->_ci->employeeleaves->{$leavecoltype} - ($days - $holidays);
$this->_ci->employeeleaves->update_leave_count($employeenumber, $leavecoltype, $remainingcredits, $this->_ci->session->userdata('employeenumber'));
}
$tpl->assign('happier_in_past', $score_interpretation['happier_in_past']);
}
}
$time_since_last_entry = time() - $latest_entrydate;
$in_days = round($time_since_last_entry / 60 / 60 / 24);
//check time ban
$repeat_in_days = bd_min_waittime * 24 * 60 * 60;
if ($time_since_last_entry < $repeat_in_days) {
$tpl->assign('time_ban', 1);
}
$tpl->assign('score_interpretation_latest', get_score_interpretation('latest', intval($latest_score), $score_interpretation));
require_once './lib/functions/convert_date.php';
//format dates for select box
foreach ($bd_scale_dates as $key => $value) {
$select_dates[] = $value["date"];
$select_dates_formatted[] = convert_date($value["date"], 1, $getmonth);
}
$tpl->assign('in_days', $in_days);
$tpl->assign('latest_score', $latest_score);
$tpl->assign('change', $change);
$tpl->assign('select_dates', $select_dates);
$tpl->assign('select_dates_formatted', $select_dates_formatted);
$tpl->assign('getmonth', serialize($getmonth));
}
//fill template variables
$tpl->assign('head_title', $head_title['analyze']['bd_scale']['index']);
$tpl->assign('head_subtitle', $head_subtitle['analyze']['bd_scale']['index']);
$tpl->assign('datay', $bd_scale_data);
$tpl->assign('total_entries', $total_entries);
$tpl->assign('max_items_bd_scale', max_items_bd_scale);
$tpl->assign('repeat_in_days', bd_min_waittime);
if (empty($_GET['dob'])) {
echo 'Error: You must enter a date of birth.';
exit(1);
}
$first = !empty($_GET['first']) ? append_quotes($_GET['first']) : 'NULL';
$last = !empty($_GET['last']) ? append_quotes($_GET['last']) : 'NULL';
$sex = !empty($_GET['sex']) ? append_quotes($_GET['sex']) : 'NULL';
$dod = !empty($_GET['dod']) ? $_GET['dod'] : 'NULL';
if ($dod != 'NULL') {
if ($dob > $dod) {
echo 'Error: A person cannot die before they are born!';
exit(1);
}
$dod = convert_date($dod);
}
$dob = convert_date($dob);
$db_connection = connect_db();
$id_query = 'select max(id) from MaxPersonID';
$rs = mysql_query($id_query);
if (!$rs) {
echo 'MySQL Error.';
exit(1);
}
$id = mysql_fetch_row($rs)[0];
// echo "<br>$id $first $last $sex $dob $dod"; //debug
if ($type == 'Actor') {
$query = "insert into Actor(id, last, first, sex, dob, dod) values ({$id}, {$last}, {$first}, {$sex}, {$dob}, {$dod})";
$rs = mysql_query($query);
if (!$rs) {
echo 'MySQL Error.';
exit(1);
<?php
/* XAJAX - asynchronous call: retrieve updated data */
require_once 'lib/functions/convert_date.php';
$goals = new SelectEntrys();
$goals->cols = "ID, goal, progress, created, achieved";
$goals->table = $tbl_goals;
$goals->condition = " userID = '" . $user_data['ID'] . "' ";
if (!isset($goals_order)) {
$goals->order = 'created DESC';
} else {
$goals->order = $goals_order;
}
if (isset($goals_show_landing) == true) {
$goals->limit = 1;
}
//$goals->limit = 10;
$goals->multiSelect = 1;
$ay_goals = $goals->row();
$count = 0;
if (isset($ay_goals[0])) {
foreach ($ay_goals as $res2) {
$ay_goals[$count]["created"] = convert_date($res2["created"], 0, $getmonth);
$ay_goals[$count]["achieved"] = convert_date($res2["achieved"], 0, $getmonth);
$count++;
}
}
