public static function getRemainingTime($question)
{
if (!empty($question)) {
$end_at = CDateTime::createFromTimeStamp(strtotime($question->end_at));
$now = CDateTime::now();
$diff_in_seconds = $now->diffInSeconds($end_at, true);
$hrs = sprintf("%02s", floor($diff_in_seconds / 3600));
$min = sprintf("%02s", floor($diff_in_seconds / 60 % 60));
$sec = sprintf("%02s", $diff_in_seconds % 60);
$due_date = $end_at->formatLocalized('%d %B - %A');
$due_date_day = $end_at->formatLocalized('%d') + 1;
$due_date_short_month = $end_at->formatLocalized('%b');
$due_date_long_month = $end_at->formatLocalized('%B');
$due_date_year = $end_at->formatLocalized('%Y');
$remaining_time = ['hrs' => $hrs, 'min' => $min, 'sec' => $sec, 'due_date' => $due_date, 'due_date_day' => $due_date_day, 'due_date_short_month' => $due_date_short_month, 'due_date_long_month' => $due_date_long_month, 'due_date_year' => $due_date_year];
} else {
$remaining_time = '';
}
return $remaining_time;
}
/**
* @return string
*/
function SelectAllAccounts($pageNumber, $accountPerPage, $sortField, $sortOrder, $searchText)
{
$nom = $pageNumber > 0 ? ($pageNumber - 1) * $accountPerPage : 0;
$dopstr = '';
$search = trim($searchText);
if (strlen($searchText) > 0) {
$search = ' AND (id_acct LIKE %1$s OR email LIKE %1$s OR %2$s LIKE %1$s
OR logins_count LIKE %1$s OR mail_inc_host LIKE %1$s
OR mail_out_host LIKE %1$s) ';
$search = sprintf($search, $this->_escapeString('%' . $searchText . '%'), CDateTime::GetMsSqlDateFormat('last_login'));
}
if ($nom > 0) {
$dopstr = ' AND id_acct NOT IN
(SELECT id_acct FROM
(SELECT TOP %d id_acct, acct1.id_user as id_user, deleted, email,
mail_inc_host, mail_out_host, %s AS nlast_login, logins_count,
mailbox_size, mailbox_limit, def_acct
FROM %sawm_accounts AS acct1
INNER JOIN %sawm_settings AS sett1 ON acct1.id_user = sett1.id_user
WHERE id_acct > -1 %s
ORDER BY %s %s, def_acct DESC) AS stable) ';
$dopstr = sprintf($dopstr, $nom, CDateTime::GetMsSqlDateFormat('last_login'), $this->_settings->DbPrefix, $this->_settings->DbPrefix, $search, $sortField, $sortOrder ? 'DESC' : 'ASC');
}
$sql = 'SELECT TOP %d id_acct, acct.id_user as id_user, deleted, email,
mail_inc_host, mail_out_host, %s AS nlast_login, logins_count,
mailbox_size, mailbox_limit, def_acct
FROM %sawm_accounts AS acct
INNER JOIN %sawm_settings AS sett ON acct.id_user = sett.id_user
WHERE id_acct > -1 %s%s
ORDER BY %s %s, def_acct DESC';
return sprintf($sql, $accountPerPage, CDateTime::GetMsSqlDateFormat('last_login'), $this->_settings->DbPrefix, $this->_settings->DbPrefix, $search, $dopstr, $sortField, $sortOrder ? 'DESC' : 'ASC');
}
/**
* @param CDateTime $date
*/
function SetDate(&$date)
{
$this->Headers->SetHeader(new Header(MIMEConst_Date, $date->GetAsStr(), true));
}
<div class="col-md-4 col-md-offset-4 col-lg-4 col-lg-offset-4">
<h2>Edit Question</h2>
</div>
<div class="col-md-12 col-lg-15">
<div class="row">
<div class="col-lg-3">
@include('profile.dashboard.sidebarnav')
@include('elements.submit')
</div>
<div class="col-lg-9">
<div class="panel-wrapper">
@foreach ($questions as $q)
<?php
$end_at = CDateTime::createFromTimeStamp(strtotime($q->end_at));
$start_at = CDateTime::createFromTimeStamp(strtotime($q->start_at));
$display_end_at = $end_at->formatLocalized('%Y-%m-%d');
$display_start_at = $start_at->formatLocalized('%Y-%m-%d');
?>
{{ Form::open(['route' => ['admin.question.update', $q->id], 'class' => 'form-horizontal form-w-bg']) }}
<div class="form-group">
{{ Form::label('question', 'Question', ['class' => 'col-sm-2 control-label']) }}
<div class="col-sm-10">
{{ Form::text('question', Tools::fallBack(Input::old('question'), $q->question), ['class' => 'form-control']) }}
{{ $errors->first('question', '<span class="text-danger">:message</span>') }}
</div>
</div>
<div class="form-group">
{{ Form::label('slug', 'Slug', ['class' => 'col-sm-2 control-label']) }}
<div class="col-sm-10">
/**
* @param obj $row
* return WebMailMessage|null
*/
function &_rowToWebMailMessage($row)
{
$msg = null;
if ($row) {
$msg = new WebMailMessage();
$msg->SetFromAsString($row->from_msg);
$msg->SetToAsString($row->to_msg);
$msg->SetCcAsString($row->cc_msg);
$msg->SetBccAsString($row->bcc_msg);
$date = new CDateTime();
$date->SetFromANSI($row->nmsg_date);
$date->TimeStamp += $date->GetServerTimeZoneOffset();
$msg->SetDate($date);
$msg->SetSubject($row->subject);
$msg->IdMsg = $row->id_msg;
$msg->IdFolder = $row->id_folder_db;
$msg->Uid = $row->uid;
$msg->Size = $row->size;
$msg->DbPriority = $row->priority;
$msg->DbXSpam = (bool) abs($row->x_spam);
$msg->DbHasAttachments = $row->attachments;
$msg->Sensitivity = $row->sensitivity;
$msg->Flags = 0;
if ($row->seen) {
$msg->Flags |= MESSAGEFLAGS_Seen;
}
if ($row->flagged) {
$msg->Flags |= MESSAGEFLAGS_Flagged;
}
if ($row->deleted) {
$msg->Flags |= MESSAGEFLAGS_Deleted;
}
if ($row->replied) {
$msg->Flags |= MESSAGEFLAGS_Answered;
}
if ($row->forwarded) {
$msg->Flags |= MESSAGEFLAGS_Forwarded;
}
if ($row->grayed) {
$msg->Flags |= MESSAGEFLAGS_Grayed;
}
$msg->Charset = $row->charset;
}
return $msg;
}
<h2>Archives</h2>
</div>
<div class="col-md-12 col-lg-12">
<div class="row">
<div class="col-lg-9">
<div class="archive-list scrollable" data-height="500px">
<ul class="list-unstyled">
@foreach ($show_questions as $q)
<?php
$t_bants = Post::getTopBants($q->id);
if ($t_bants) {
foreach ($t_bants as $top_bant) {
if (is_numeric($top_bant->id)) {
$user = User::getUserProfile($top_bant->user_id);
$votes = Vote::getPostVotes($top_bant->id);
$post_date = CDateTime::createFromTimeStamp(strtotime($top_bant->created_at));
$display_post_date = $post_date->formatLocalized('%b %d, %Y');
?>
<li>
<div class="row">
<div class="col-lg-3">
<div class="avatar">
<a href="#">
<img src="{{ Avatar::display('default_avatar.jpg') }}" alt="...">
<?php
echo '<span class="user-name">' . $user[0]->full_name . '</span>';
echo '@' . $top_bant->username;
echo '<div class="profile-info">';
echo '<span class="address"><i class="fa fa-map-marker"></i>' . $user[0]->city . ', ' . $user[0]->state . '</span>';
echo '<span class="post-date">' . $display_post_date . '</span>';
echo '<span class="votes">' . count($votes) . ' votes</span>';
/**
* @param int $id
* @return Account
*/
function &SelectAccountData($id)
{
$null = null;
if (!$this->_dbConnection->Execute($this->_commandCreator->SelectAccountData($id))) {
return $null;
}
$account =& new Account();
if ($row = $this->_dbConnection->GetNextRecord()) {
$account->Id = (int) $row->id_acct;
$account->IdUser = (int) $row->id_user;
$account->DefaultAccount = (bool) abs($row->def_acct);
$account->Deleted = (bool) abs($row->deleted);
$account->Email = $row->email;
$account->MailProtocol = (int) $row->mail_protocol;
$account->MailIncHost = $row->mail_inc_host;
$account->MailIncLogin = $row->mail_inc_login;
$account->MailIncPort = (int) $row->mail_inc_port;
$account->MailOutHost = $row->mail_out_host;
$account->MailOutLogin = $row->mail_out_login;
$account->MailOutPort = (int) $row->mail_out_port;
$account->MailOutAuthentication = (int) $row->mail_out_auth;
$account->FriendlyName = $row->friendly_nm;
$account->UseFriendlyName = (bool) abs($row->use_friendly_nm);
$account->DefaultOrder = (int) $row->def_order;
$account->GetMailAtLogin = (bool) abs($row->getmail_at_login);
$account->MailMode = (int) $row->mail_mode;
$account->MailsOnServerDays = (int) $row->mails_on_server_days;
$account->Signature = $row->signature;
$account->SignatureType = (int) $row->signature_type;
$account->SignatureOptions = (int) $row->signature_opt;
$account->HideContacts = (bool) abs($row->hide_contacts);
$account->MailsPerPage = (int) $row->msgs_per_page > 0 ? (int) $row->msgs_per_page : 20;
$account->Delimiter = $row->delimiter;
$account->WhiteListing = (bool) abs($row->white_listing);
$account->XSpam = (bool) abs($row->x_spam);
$account->LastLogin = (int) $row->last_login;
$account->LoginsCount = (int) $row->logins_count;
$account->DefaultSkin = $row->def_skin;
$account->DefaultLanguage = $row->def_lang;
$account->DefaultIncCharset = ConvertUtils::GetCodePageName((int) $row->def_charset_inc);
$account->DefaultOutCharset = ConvertUtils::GetCodePageName((int) $row->def_charset_out);
$account->DefaultTimeZone = (int) $row->def_timezone;
$account->DefaultDateFormat = CDateTime::GetDateFormatFromBd($row->def_date_fmt);
$account->DefaultTimeFormat = CDateTime::GetTimeFormatFromBd($row->def_date_fmt);
$account->HideFolders = (bool) abs($row->hide_folders);
$account->MailboxLimit = (int) $row->mailbox_limit;
$account->MailboxSize = (int) $row->mailbox_size;
$account->AllowChangeSettings = (bool) abs($row->allow_change_settings);
$account->AllowDhtmlEditor = (bool) abs($row->allow_dhtml_editor);
$account->AllowDirectMode = (bool) abs($row->allow_direct_mode);
$account->DbCharset = ConvertUtils::GetCodePageName((int) $row->db_charset);
$account->HorizResizer = (int) $row->horiz_resizer;
$account->VertResizer = (int) $row->vert_resizer;
$account->Mark = (int) $row->mark;
$account->Reply = (int) $row->reply;
$account->ContactsPerPage = (int) $row->contacts_per_page > 0 ? (int) $row->contacts_per_page : 20;
$account->ViewMode = (int) $row->view_mode;
$account->MailIncPassword = ConvertUtils::DecodePassword($row->mail_inc_pass, $account);
$account->MailOutPassword = ConvertUtils::DecodePassword($row->mail_out_pass, $account);
$this->_dbConnection->FreeResult();
} else {
$account = $null;
}
if (!is_object($account) || !$this->_dbConnection->Execute($this->_commandCreator->SelectAccountColumnsData($account->IdUser))) {
return $null;
}
while ($row = $this->_dbConnection->GetNextRecord()) {
if (!is_object($row)) {
continue;
}
$account->Columns[(int) $row->id_column] = $row->column_value;
}
return $account;
}
/**
* @param string $strDate
* @return int
*/
function GetTimeFromString($strDate)
{
$dt = time() - CDateTime::GetServerTimeZoneOffset();
$matches = array();
$zone = null;
$off = null;
$datePattern = '/^(([a-z]*),[\\s]*){0,1}(\\d{1,2}).([a-z]*).(\\d{2,4})[\\s]*(\\d{1,2}).(\\d{1,2}).(\\d{1,2})([\\s]+([+-]?\\d{1,4}))?([\\s]*(\\(?(\\w+)\\)?))?/i';
if (preg_match($datePattern, $strDate, $matches)) {
$year = $matches[5];
$month = ConvertUtils::GetMonthIndex(strtolower($matches[4]));
if ($month == -1) {
$month = 1;
}
$day = $matches[3];
$hour = $matches[6];
$minute = $matches[7];
$second = $matches[8];
$dt = ConvertUtils::GmtMkTime($hour, $minute, $second, $month, $day, $year);
if (isset($matches[13])) {
$zone = strtolower($matches[13]);
}
if (isset($matches[10])) {
$off = strtolower($matches[10]);
}
}
$dt = ConvertUtils::ApplyOffsetForDate($dt, $off, $zone);
return $dt;
}
/**
* @param int $pageNumber
* @param string $condition
* @param FolderCollection $folders
* @param bool $inHeadersOnly
* @param Account $account
* @return WebMailMessageCollection
*/
function SearchMessages($pageNumber, $condition, &$folders, $inHeadersOnly, &$account)
{
$tempstr = '';
$foldersId = array();
$_foldersKeys = array_keys($folders->Instance());
foreach ($_foldersKeys as $key) {
$folder =& $folders->Get($key);
if (!$folder->Hide) {
$foldersId[] = $folder->IdDb;
}
unset($folder);
}
unset($folders, $_foldersKeys);
$filter = '';
$asc = true;
$this->_setSortOrder($account->DefaultOrder, $filter, $asc);
$condition = str_replace('[', '[[]', $condition);
$condition = $this->_escapeString('%' . $condition . '%');
$str_foldersId = implode(',', $foldersId);
if ($inHeadersOnly) {
if (($pageNumber - 1) * $account->MailsPerPage > 0) {
$tempstr = ' AND id_msg NOT IN
(SELECT TOP %d id_msg FROM %sawm_messages
WHERE id_acct = %d AND id_folder_db ' . $this->_inOrNot($foldersId) . ' AND
(from_msg LIKE %s OR to_msg LIKE %s OR cc_msg LIKE %s OR bcc_msg
LIKE %s OR subject LIKE %s) ORDER BY %s %s)';
$tempstr = sprintf($tempstr, ($pageNumber - 1) * $account->MailsPerPage, $this->_settings->DbPrefix, $account->Id, $str_foldersId, $condition, $condition, $condition, $condition, $condition, $filter, $asc ? 'ASC' : 'DESC');
}
$sql = 'SELECT TOP %d id_msg, %s AS uid, id_folder_db, from_msg, to_msg, cc_msg,
bcc_msg, subject, %s AS nmsg_date, size, priority, x_spam,
attachments, seen, flagged, deleted, replied, forwarded, grayed, charset, sensitivity
FROM %sawm_messages
WHERE id_acct = %d AND id_folder_db ' . $this->_inOrNot($foldersId) . ' AND
(from_msg LIKE %s OR to_msg LIKE %s OR cc_msg LIKE %s OR bcc_msg
LIKE %s OR subject LIKE %s)%s
ORDER BY %s %s';
return sprintf($sql, $account->MailsPerPage, $this->_getMsgIdUidFieldName(true, $account->MailProtocol), CDateTime::GetMsSqlDateFormat('msg_date'), $this->_settings->DbPrefix, $account->Id, $str_foldersId, $condition, $condition, $condition, $condition, $condition, $tempstr, $filter, $asc ? 'ASC' : 'DESC');
} else {
if (($pageNumber - 1) * $account->MailsPerPage > 0) {
$tempstr = ' AND id_msg NOT IN
(SELECT TOP %d id_msg FROM %sawm_messages
WHERE id_acct = %d AND id_folder_db ' . $this->_inOrNot($foldersId) . ' AND
(from_msg LIKE %s OR to_msg LIKE %s OR cc_msg LIKE %s OR bcc_msg
LIKE %s OR subject LIKE %s OR body_text LIKE %s) ORDER BY %s %s)';
$tempstr = sprintf($tempstr, ($pageNumber - 1) * $account->MailsPerPage, $this->_settings->DbPrefix, $account->Id, $str_foldersId, $condition, $condition, $condition, $condition, $condition, $condition, $filter, $asc ? 'ASC' : 'DESC');
}
$sql = 'SELECT TOP %d id_msg, %s AS uid, id_folder_db, from_msg, to_msg, cc_msg,
bcc_msg, subject, %s AS nmsg_date, size, priority, x_spam,
attachments, seen, flagged, deleted, replied, forwarded, grayed, charset, sensitivity
FROM %sawm_messages
WHERE id_acct = %d AND id_folder_db ' . $this->_inOrNot($foldersId) . ' AND
(from_msg LIKE %s OR to_msg LIKE %s OR cc_msg LIKE %s OR bcc_msg
LIKE %s OR subject LIKE %s OR body_text LIKE %s)%s
ORDER BY %s %s';
return sprintf($sql, $account->MailsPerPage, $this->_getMsgIdUidFieldName(true, $account->MailProtocol), CDateTime::GetMsSqlDateFormat('msg_date'), $this->_settings->DbPrefix, $account->Id, $str_foldersId, $condition, $condition, $condition, $condition, $condition, $condition, $tempstr, $filter, $asc ? 'ASC' : 'DESC');
}
}
