/**
* Get the full caption value for the slider with the 'hours' step type
* @param Array dateArray
* @param Boolean isLower
* @return String
*/
protected function getHoursCaption($dateArray, $isLower)
{
global $locale_info;
$hours = $this->getAdjustedHoursValue($dateArray[3], $dateArray[4], $isLower);
$dateArray[3] = $dateArray[4] = $dateArray[5] = 0;
$dateArray = addHours($dateArray, $hours);
$timeFormatString = str_replace($locale_info["LOCALE_STIME"] . "ss", "", $locale_info["LOCALE_STIMEFORMAT"]);
return format_datetime_custom($dateArray, $timeFormatString);
}
function buildControl($value, $mode, $fieldNum, $validate, $additionalCtrlParams, $data)
{
global $locale_info;
parent::buildControl($value, $mode, $fieldNum, $validate, $additionalCtrlParams, $data);
if ($fieldNum) {
$this->cfield = "value" . $fieldNum . "_" . GoodFieldName($this->field) . '_' . $this->id;
}
echo '<input id="' . $this->ctype . '" type="hidden" name="' . $this->ctype . '" value="date' . $this->pageObject->pSetEdit->getDateEditType($this->field) . '">';
if ($this->pageObject->pageType == PAGE_LIST) {
$pSet = new ProjectSettings($this->pageObject->tName, PAGE_SEARCH);
} else {
$pSet = $this->pageObject->pSetEdit;
}
$tvalue = $value;
$time = db2time($tvalue);
if (!count($time)) {
$time = array(0, 0, 0, 0, 0, 0);
}
$dp = 0;
$hasImgCal = true;
$showTime = $pSet->dateEditShowTime($this->field);
switch ($pSet->getDateEditType($this->field)) {
case EDIT_DATE_SIMPLE_INLINE:
$hasImgCal = false;
case EDIT_DATE_SIMPLE_DP:
$ovalue = $value;
if ($locale_info["LOCALE_IDATE"] == 1) {
$fmt = "dd" . $locale_info["LOCALE_SDATE"] . "MM" . $locale_info["LOCALE_SDATE"] . "yyyy";
} else {
if ($locale_info["LOCALE_IDATE"] == 0) {
$fmt = "MM" . $locale_info["LOCALE_SDATE"] . "dd" . $locale_info["LOCALE_SDATE"] . "yyyy";
} else {
$fmt = "yyyy" . $locale_info["LOCALE_SDATE"] . "MM" . $locale_info["LOCALE_SDATE"] . "dd";
}
}
if ($showTime || $time[3] || $time[4] || $time[5]) {
$fmt .= " HH:mm:ss";
}
if ($time[0]) {
$ovalue = format_datetime_custom($time, $fmt);
}
$ovalue1 = $time[2] . "-" . $time[1] . "-" . $time[0];
if ($showTime || $time[3] || $time[4] || $time[5]) {
$ovalue1 .= " " . $time[3] . ":" . $time[4] . ":" . $time[5];
}
// need to create date control object to use it with datePicker
$ret = '<input id="' . $this->cfield . '" ' . $this->inputStyle . ' type="Text" name="' . $this->cfield . '" value="' . $ovalue . '">';
$ret .= '<input id="ts' . $this->cfield . '" type="Hidden" name="ts' . $this->cfield . '" value="' . $ovalue1 . '">';
if ($hasImgCal) {
$ret .= ' <a href="#" id="imgCal_' . $this->cfield . '" data-icon="calendar" title="Click Here to Pick up the date" ></a>';
}
echo $ret;
break;
case EDIT_DATE_DD_INLINE:
case EDIT_DATE_DD_DP:
$dp = 1;
case EDIT_DATE_DD:
$controlWidth = $pSet->getControlWidth($this->field);
if ($controlWidth > 0) {
$controlWidth -= 10;
$yearWidth = floor($controlWidth * 0.3);
$yearStyle = 'style="min-width: ' . $yearWidth . 'px; ';
$dayWidth = floor($controlWidth * 0.2);
$dayStyle = 'style="min-width: ' . $dayWidth . 'px; margin-right:5px;" ';
$mothWidth = $controlWidth - $yearWidth - $dayWidth;
$monthStyle = 'style="min-width: ' . $mothWidth . 'px; margin-right:5px;" ';
} else {
$dayStyle = '';
$monthStyle = '';
$yearStyle = '';
}
$alt = ($mode == MODE_INLINE_EDIT || $mode == MODE_INLINE_ADD) && $this->is508 ? 'alt="' . $this->strLabel . '" ' : '';
$retday = '<select id="day' . $this->cfield . '" ' . $dayStyle . $alt . 'name="day' . $this->cfield . '" ></select>';
$retmonth = '<select id="month' . $this->cfield . '" ' . $monthStyle . $alt . 'name="month' . $this->cfield . '" ></select>';
$retyear = '<select id="year' . $this->cfield . '" ' . $yearStyle . $alt . 'name="year' . $this->cfield . '" ></select>';
$space = $controlWidth > 0 ? '' : " ";
if ($locale_info["LOCALE_ILONGDATE"] == 1) {
$ret = $retday . $space . $retmonth . $space . $retyear;
} else {
if ($locale_info["LOCALE_ILONGDATE"] == 0) {
$ret = $retmonth . $space . $retday . $space . $retyear;
} else {
$ret = $retyear . $space . $retmonth . $space . $retday;
}
}
if ($time[0] && $time[1] && $time[2]) {
$ret .= "<input id=\"" . $this->cfield . "\" type=hidden name=\"" . $this->cfield . "\" value=\"" . $time[0] . "-" . $time[1] . "-" . $time[2] . "\">";
} else {
$ret .= "<input id=\"" . $this->cfield . "\" type=hidden name=\"" . $this->cfield . "\" value=\"\">";
}
// calendar handling for three DD
if ($dp) {
$ret .= ' <a href="#" id="imgCal_' . $this->cfield . '" data-icon="calendar" title="Click Here to Pick up the date"></a>' . '<input id="ts' . $this->cfield . '" type=hidden name="ts' . $this->cfield . '" value="' . $time[2] . '-' . $time[1] . '-' . $time[0] . '">';
}
echo $ret;
break;
default:
// case EDIT_DATE_SIMPLE:
$ovalue = $value;
if ($time[0]) {
if ($showTime || $time[3] || $time[4] || $time[5]) {
$ovalue = str_format_datetime($time);
} else {
$ovalue = format_shortdate($time);
}
}
echo '<input id="' . $this->cfield . '" type=text name="' . $this->cfield . '" ' . $this->inputStyle . ' value="' . runner_htmlspecialchars($ovalue) . '">';
}
$this->buildControlEnd($validate);
}
function LogAddEvent($message, $description = "", $str_table = "")
{
global $globalEvents;
$retval = true;
$table = $str_table;
$arr = array();
if ($globalEvents->exists("OnAuditLog")) {
$retval = $globalEvents->OnAuditLog($message, $this->params, $table, $arr, $arr, $arr);
}
if ($retval) {
$fp = $this->CreateLogFile();
$str = format_datetime_custom(db2time(now()), "MMM dd,yyyy") . chr(9) . format_datetime_custom(db2time(now()), "HH:mm:ss") . chr(9) . $params[0] . chr(9) . $params[1] . chr(9) . $table . chr(9) . $message . chr(9) . $description . "\r\n";
if ($fp) {
fputs($fp, $str);
fclose($fp);
}
}
return $retval;
}
function UnlockAdmin($strtable, $keys, $startEdit)
{
$skeys = "";
foreach ($keys as $ind => $val) {
if (strlen($skeys)) {
$skeys .= "&";
}
$skeys .= rawurlencode($val);
}
$sdate = now();
if ($startEdit) {
// add a record - lock
$this->TableObj->startdatetime = $sdate;
$this->TableObj->confirmdatetime = $sdate;
$this->TableObj->sessionid = session_id();
$this->TableObj->table = $strtable;
$this->TableObj->keys = $skeys;
$this->TableObj->userid = $this->UserID;
$this->TableObj->action = 1;
$this->TableObj->Add();
}
// delete all other locking records
$rstmp = CustomQuery("delete from " . AddTableWrappers($this->lockTableName) . " where " . AddFieldWrappers("table") . "=" . db_prepare_string($strtable) . " and " . AddFieldWrappers("keys") . "=" . db_prepare_string($skeys) . " and " . AddFieldWrappers("action") . "=1 and " . AddFieldWrappers("sessionid") . "<>'" . session_id() . "' ");
// inform other users that their locking were removed by locking
$rstmp = CustomQuery("delete from " . AddTableWrappers($this->lockTableName) . " where " . AddFieldWrappers("startdatetime") . "<'" . format_datetime_custom(adddays(db2time(now()), -2), "yyyy-MM-dd HH:mm:ss") . "' and " . AddFieldWrappers("action") . "=2");
$this->TableObj->startdatetime = $sdate;
$this->TableObj->confirmdatetime = $sdate;
$this->TableObj->sessionid = session_id();
$this->TableObj->table = $strtable;
$this->TableObj->keys = $skeys;
$this->TableObj->userid = $this->UserID;
$this->TableObj->action = 2;
$this->TableObj->Add();
}
/**
* @intellisense
*/
function format_longdate($time)
{
global $locale_info;
return format_datetime_custom($time, $locale_info["LOCALE_SLONGDATE"]);
}
/**
* Get value for field edit as time and get dpTime settings
* @param integer $convention - 24 or 12 hours format for timePicker
* @param string $type - type of field
* @param string $value - value of field
* @param boolean $useTimePicker - use timePicker or not
* @return array
*/
function getValForTimePicker($type, $value, $locale)
{
$val = "";
$dbtime = array();
if (IsDateFieldType($type)) {
$dbtime = db2time($value);
if (count($dbtime)) {
$val = format_datetime_custom($dbtime, $locale);
}
} else {
$arr = parsenumbers($value);
if (count($arr)) {
while (count($arr) < 3) {
$arr[] = 0;
}
$dbtime = array(0, 0, 0, $arr[0], $arr[1], $arr[2]);
$val = format_datetime_custom($dbtime, $locale);
}
}
return array('val' => $val, 'dbTime' => $dbtime);
}
/**
* Get date-time formatted string
* @param Array dateArray
* @return String
*/
protected function getDateTimeString($dateArray)
{
global $locale_info;
//to avoid locale-specific formatting
$formatString = $locale_info["LOCALE_SSHORTDATE"] . " HH:mm:ss";
return format_datetime_custom($dateArray, $formatString);
}
function UnlockAdmin($strtable, $keys, $startEdit)
{
$skeys = "";
foreach ($keys as $ind => $val) {
if (strlen($skeys)) {
$skeys .= "&";
}
$skeys .= rawurlencode($val);
}
$sdate = now();
if ($startEdit) {
// add a record - lock
$this->insert($strtable, $sdate, $sdate, $skeys, session_id(), $this->UserID, 1);
}
// delete all other locking records
$where = $this->connection->addFieldWrappers("table") . "=" . $this->connection->prepareString($strtable) . " AND " . $this->connection->addFieldWrappers("keys") . "=" . $this->connection->prepareString($skeys) . " AND " . $this->connection->addFieldWrappers("action") . "=1 AND " . $this->connection->addFieldWrappers("sessionid") . "<>" . $this->connection->prepareString(session_id());
$this->delete($where);
// inform other users that their locking were removed by locking
$where = $this->connection->addFieldWrappers("startdatetime") . "<" . $this->connection->addDateQuotes(format_datetime_custom(adddays(db2time(now()), -2), "yyyy-MM-dd HH:mm:ss")) . " AND " . $this->connection->addFieldWrappers("action") . "=2";
$this->delete($where);
$this->insert($strtable, $sdate, $sdate, $skeys, session_id(), $this->UserID, 2);
}
