Collaboration diagram for ILIAS\Mail\Message\MailBoxQuery:

Public Member Functions
	__construct (private readonly int $user_id,)

	withFolderId (?int $folder_id)

	withSender (?string $sender)

	withRecipients (?string $recipients)

	withSubject (?string $subject)

	withBody (?string $body)

	withIsUnread (?bool $is_unread)

	withIsSystem (?bool $is_system)

	withHasAttachment (?bool $has_attachment)

	withPeriodStart (?DateTimeImmutable $period_start)

	withPeriodEnd (?DateTimeImmutable $period_end)

	withFilteredIds (?array $filtered_ids)

	withLimit (int $limit)

	withOffset (int $offset)

	withOrderColumn (?MailBoxOrderColumn $order_column)

	withOrderDirection (?string $order_direction)

	countUnread ()
	Count the number of unread mails with applied filter. More...

	count ()
	Count the number of all mails with applied filter. More...

	queryMailIds ()
	Get a list of mail ids. More...

	query ($short)
	Query for mail data with applied filter. More...

Private Member Functions
	getFrom ()

	getWhere ()

Private Attributes
const MailBoxOrderColumn	DEFAULT_ORDER_COLUMN = MailBoxOrderColumn::SEND_TIME

const string	DEFAULT_ORDER_DIRECTION = Order::ASC

ilDBInterface	$db

int	$folder_id = null

string	$sender = null

string	$recipients = null

string	$subject = null

string	$body = null

bool	$is_unread = null

bool	$is_system = null

bool	$has_attachment = null

DateTimeImmutable	$period_start = null

DateTimeImmutable	$period_end = null

array	$filtered_ids = null

int	$limit = 999999

int	$offset = 0

MailBoxOrderColumn	$order_column = self::DEFAULT_ORDER_COLUMN

string	$order_direction = self::DEFAULT_ORDER_DIRECTION

Detailed Description

Definition at line 30 of file MailBoxQuery.php.

Constructor & Destructor Documentation

◆ __construct()

ILIAS\Mail\Message\MailBoxQuery::__construct ( private readonly int $user_id )

Definition at line 53 of file MailBoxQuery.php.

References $DIC.

       {
         global $DIC;
         $this->db = $DIC->database();
     }

Member Function Documentation

◆ count()

ILIAS\Mail\Message\MailBoxQuery::count ( )

Count the number of all mails with applied filter.

Definition at line 202 of file MailBoxQuery.php.

References $res, ILIAS\Mail\Message\MailBoxQuery\getFrom(), and ILIAS\Mail\Message\MailBoxQuery\getWhere().

                            : int
     {
         if ($this->filtered_ids === []) {
             return 0;
         }
 
         $query = 'SELECT COUNT(m.mail_id) cnt '
             . $this->getFrom()
             . $this->getWhere();
 
         $res = $this->db->query($query);
         if ($row = $this->db->fetchAssoc($res)) {
             return (int) $row['cnt'];
         }
 
         return 0;
     }

Here is the call graph for this function:

◆ countUnread()

ILIAS\Mail\Message\MailBoxQuery::countUnread ( )

Count the number of unread mails with applied filter.

Definition at line 194 of file MailBoxQuery.php.

References ILIAS\Mail\Message\MailBoxQuery\withIsUnread().

                                  : int
     {
         return $this->withIsUnread(true)->count();
     }

Here is the call graph for this function:

◆ getFrom()

ILIAS\Mail\Message\MailBoxQuery::getFrom ( )

private

Definition at line 306 of file MailBoxQuery.php.

Referenced by ILIAS\Mail\Message\MailBoxQuery\count(), ILIAS\Mail\Message\MailBoxQuery\query(), and ILIAS\Mail\Message\MailBoxQuery\queryMailIds().

     {
         return " FROM mail m
             LEFT JOIN usr_data u ON u.usr_id = m.sender_id
             LEFT JOIN usr_pref p ON p.usr_id = m.sender_id AND p.keyword = 'public_profile'";
     }

Here is the caller graph for this function:

◆ getWhere()

ILIAS\Mail\Message\MailBoxQuery::getWhere ( )

private

Definition at line 313 of file MailBoxQuery.php.

References ILIAS\Mail\Message\MailBoxQuery\$body, $parts, ILIAS\Mail\Message\MailBoxQuery\$recipients, ILIAS\Mail\Message\MailBoxQuery\$subject, ilUserSearchOptions\_isEnabled(), ANONYMOUS_USER_ID, null, ilDBConstants\T_INTEGER, ilDBConstants\T_TEXT, and ilDBConstants\T_TIMESTAMP.

Referenced by ILIAS\Mail\Message\MailBoxQuery\count(), ILIAS\Mail\Message\MailBoxQuery\query(), and ILIAS\Mail\Message\MailBoxQuery\queryMailIds().

                                : string
     {
         $parts = [];
 
         // minimum condition: only mailbox of the given user
         $parts[] = 'm.user_id = ' . $this->db->quote($this->user_id, ilDBConstants::T_INTEGER);
 
         // sender conditions have to respect searchability and visibility of profile fields
         $sender_conditions = [];
         if (($this->sender ?? '') !== '') {
             $sender_conditions[] = $this->db->like('u.login', ilDBConstants::T_TEXT, '%%' . $this->sender . '%%');
 
             if (ilUserSearchOptions::_isEnabled('firstname')) {
                 $sender_conditions[] = '(' .
                     $this->db->like('u.firstname', ilDBConstants::T_TEXT, '%%' . $this->sender . '%%')
                     . " AND p.value = 'y')";
             }
 
             if (ilUserSearchOptions::_isEnabled('lastname')) {
                 $sender_conditions[] = '(' .
                     $this->db->like('u.lastname', ilDBConstants::T_TEXT, '%%' . $this->sender . '%%')
                     . " AND p.value = 'y')";
             }
         }
         if (!empty($sender_conditions)) {
             $parts[] = '(' . implode(' OR ', $sender_conditions) . ')';
         }
 
         // other text conditions
         $text_conditions = [
             [$this->recipients, 'CONCAT(CONCAT(m.rcp_to, m.rcp_cc), m.rcp_bcc)'],
             [$this->subject, 'm.m_subject'],
             [$this->body, 'm.m_message'],
         ];
 
         foreach ($text_conditions as $cond) {
             if (($cond[0] ?? '') !== '') {
                 $parts[] = $this->db->like(
                     $cond[1],
                     ilDBConstants::T_TEXT,
                     '%%' . $cond[0] . '%%',
                     false
                 );
             }
         }
 
         if ($this->folder_id !== null) {
             $parts[] = 'm.folder_id = ' . $this->db->quote($this->folder_id, ilDBConstants::T_INTEGER);
         }
 
         if ($this->is_unread === true) {
             $parts[] = 'm.m_status = ' . $this->db->quote('unread', 'text');
         } elseif ($this->is_unread === false) {
             $parts[] = 'm.m_status != ' . $this->db->quote('unread', 'text');
         }
 
         if ($this->is_system === true) {
             $parts[] = 'm.sender_id = ' . $this->db->quote(ANONYMOUS_USER_ID, ilDBConstants::T_INTEGER);
         } elseif ($this->is_system === false) {
             $parts[] = 'm.sender_id != ' . $this->db->quote(ANONYMOUS_USER_ID, ilDBConstants::T_INTEGER);
         }
 
         if ($this->has_attachment === true) {
             $parts[] = '(m.attachments != ' . $this->db->quote(serialize(null), ilDBConstants::T_TEXT)
                 . ' AND m.attachments != ' . $this->db->quote(serialize([]), ilDBConstants::T_TEXT) . ')';
         } elseif ($this->has_attachment === false) {
             $parts[] = '(m.attachments = ' . $this->db->quote(serialize(null), ilDBConstants::T_TEXT)
                 . '  OR m.attachments = ' . $this->db->quote(serialize([]), ilDBConstants::T_TEXT) . ')';
         }
 
         if ($this->period_start !== null) {
             $parts[] = 'm.send_time >= ' . $this->db->quote(
                 // convert to server time zone (set by ilias initialisation)
                 $this->period_start
                     ->setTimezone(new DateTimeZone(date_default_timezone_get()))
                     ->format('Y-m-d H:i:s'),
                 ilDBConstants::T_TIMESTAMP
             );
         }
 
         if ($this->period_end !== null) {
             $parts[] = 'm.send_time <= ' . $this->db->quote(
                 // convert to server time zone (set by ilias initialisation)
                 $this->period_end
                     ->setTimezone(new DateTimeZone(date_default_timezone_get()))
                     ->format('Y-m-d H:i:s'),
                 ilDBConstants::T_TIMESTAMP
             );
         }
 
         if (!empty($this->filtered_ids)) {
             $parts[] = $this->db->in(
                 'm.mail_id',
                 $this->filtered_ids,
                 false,
                 ilDBConstants::T_INTEGER
             ) . ' ';
         }
 
         if ($parts !== []) {
             return ' WHERE ' . implode(' AND ', $parts);
         }
 
         return '';
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ query()

ILIAS\Mail\Message\MailBoxQuery::query ( $short )

Query for mail data with applied filter.

Parameters

bool $short get only data that is needed for a listing

Returns: list<MailRecordData>

Definition at line 248 of file MailBoxQuery.php.

References ILIAS\Mail\Message\MailBoxQuery\$order_direction, $res, ILIAS\Mail\Message\MailBoxQuery\getFrom(), ILIAS\Mail\Message\MailBoxQuery\getWhere(), and null.

                                  : array
     {
         if ($this->filtered_ids === []) {
             return [];
         }
 
         if ($short) {
             $query = 'SELECT m.mail_id, m.user_id, m.folder_id, m.sender_id, m.send_time, '
                 . 'm.m_status, m.m_subject, m.import_name, m.rcp_to, m.attachments'
                 . $this->getFrom()
                 . $this->getWhere();
         } else {
             $query = 'SELECT m.*'
                 . $this->getFrom()
                 . $this->getWhere();
         }
 
         if ($this->order_column === MailBoxOrderColumn::FROM) {
             $query .= ' ORDER BY '
                 . ' u.firstname ' . $this->order_direction . ', '
                 . ' u.lastname ' . $this->order_direction . ', '
                 . ' u.login ' . $this->order_direction . ', '
                 . ' m.import_name ' . $this->order_direction;
         } else {
             $query .= ' ORDER BY ' . $this->order_column->value . ' ' . $this->order_direction;
         }
 
         $this->db->setLimit($this->limit, $this->offset);
         $res = $this->db->query($query);
 
         $set = [];
         while ($row = $this->db->fetchAssoc($res)) {
             $set[] = new MailRecordData(
                 isset($row['mail_id']) ? (int) $row['mail_id'] : 0,
                 isset($row['user_id']) ? (int) $row['user_id'] : 0,
                 isset($row['folder_id']) ? (int) $row['folder_id'] : 0,
                 isset($row['sender_id']) ? (int) $row['sender_id'] : null,
                 isset($row['send_time']) ? new DateTimeImmutable($row['send_time']) : null,
                 isset($row['m_status']) ? (string) $row['m_status'] : null,
                 isset($row['m_subject']) ? (string) $row['m_subject'] : null,
                 isset($row['import_name']) ? (string) $row['import_name'] : null,
                 isset($row['use_placeholders']) ? (bool) $row['use_placeholders'] : false,
                 isset($row['m_message']) ? (string) $row['m_message'] : null,
                 isset($row['rcp_to']) ? (string) $row['rcp_to'] : null,
                 isset($row['rcp_cc']) ? (string) $row['rcp_cc'] : null,
                 isset($row['rcp_bcc']) ? (string) $row['rcp_bcc'] : null,
                 isset($row['attachments']) ? (array) unserialize(
                     stripslashes($row['attachments']),
                     ['allowed_classes' => false]
                 ) : [],
                 isset($row['tpl_ctx_id']) ? (string) $row['tpl_ctx_id'] : null,
                 isset($row['tpl_ctx_params']) ? (string) $row['tpl_ctx_params'] : null
             );
         }
 
         return $set;
     }

Here is the call graph for this function:

◆ queryMailIds()

ILIAS\Mail\Message\MailBoxQuery::queryMailIds ( )

Get a list of mail ids.

Returns: int[]

Definition at line 224 of file MailBoxQuery.php.

References $res, ILIAS\Mail\Message\MailBoxQuery\getFrom(), ILIAS\Mail\Message\MailBoxQuery\getWhere(), and ILIAS\Repository\int().

                                   : array
     {
         if ($this->filtered_ids === []) {
             return [];
         }
 
         $query = 'SELECT m.mail_id '
             . $this->getFrom()
             . $this->getWhere();
 
         $ids = [];
         $res = $this->db->query($query);
         while ($row = $this->db->fetchAssoc($res)) {
             $ids[] = (int) $row['mail_id'];
         }
 
         return $ids;
     }

Here is the call graph for this function:

◆ withBody()

ILIAS\Mail\Message\MailBoxQuery::withBody ( ?string $body )

Definition at line 92 of file MailBoxQuery.php.

References ILIAS\Mail\Message\MailBoxQuery\$body.

                                            : MailBoxQuery
     {
         $clone = clone $this;
         $clone->body = $body;
 
         return $clone;
     }

◆ withFilteredIds()

ILIAS\Mail\Message\MailBoxQuery::withFilteredIds ( ?array $filtered_ids )

Parameters

int[]|null $filtered_ids

Definition at line 143 of file MailBoxQuery.php.

References ILIAS\Mail\Message\MailBoxQuery\$filtered_ids.

                                                          : MailBoxQuery
     {
         $clone = clone $this;
         $clone->filtered_ids = $filtered_ids;
 
         return $clone;
     }

◆ withFolderId()

ILIAS\Mail\Message\MailBoxQuery::withFolderId ( ?int $folder_id )

Definition at line 60 of file MailBoxQuery.php.

References ILIAS\Mail\Message\MailBoxQuery\$folder_id.

                                                  : MailBoxQuery
     {
         $clone = clone $this;
         $clone->folder_id = $folder_id;
 
         return $clone;
     }

◆ withHasAttachment()

ILIAS\Mail\Message\MailBoxQuery::withHasAttachment ( ?bool $has_attachment )

Definition at line 116 of file MailBoxQuery.php.

References ILIAS\Mail\Message\MailBoxQuery\$has_attachment.

                                                             : MailBoxQuery
     {
         $clone = clone $this;
         $clone->has_attachment = $has_attachment;
 
         return $clone;
     }

◆ withIsSystem()

ILIAS\Mail\Message\MailBoxQuery::withIsSystem ( ?bool $is_system )

Definition at line 108 of file MailBoxQuery.php.

References ILIAS\Mail\Message\MailBoxQuery\$is_system.

                                                   : MailBoxQuery
     {
         $clone = clone $this;
         $clone->is_system = $is_system;
 
         return $clone;
     }

◆ withIsUnread()

ILIAS\Mail\Message\MailBoxQuery::withIsUnread ( ?bool $is_unread )

Definition at line 100 of file MailBoxQuery.php.

References ILIAS\Mail\Message\MailBoxQuery\$is_unread.

Referenced by ILIAS\Mail\Message\MailBoxQuery\countUnread().

                                                   : MailBoxQuery
     {
         $clone = clone $this;
         $clone->is_unread = $is_unread;
 
         return $clone;
     }

Here is the caller graph for this function:

◆ withLimit()

ILIAS\Mail\Message\MailBoxQuery::withLimit ( int $limit )

Definition at line 151 of file MailBoxQuery.php.

References ILIAS\Mail\Message\MailBoxQuery\$limit.

                                          : MailBoxQuery
     {
         $clone = clone $this;
         $clone->limit = $limit;
 
         return $clone;
     }

◆ withOffset()

ILIAS\Mail\Message\MailBoxQuery::withOffset ( int $offset )

Definition at line 159 of file MailBoxQuery.php.

References ILIAS\Mail\Message\MailBoxQuery\$offset.

                                            : MailBoxQuery
     {
         $clone = clone $this;
         $clone->offset = $offset;
 
         return $clone;
     }

◆ withOrderColumn()

ILIAS\Mail\Message\MailBoxQuery::withOrderColumn ( ?MailBoxOrderColumn $order_column )

Definition at line 167 of file MailBoxQuery.php.

References ILIAS\Mail\Message\MailBoxQuery\$order_column, and null.

                                                                       : MailBoxQuery
     {
         $clone = clone $this;
         if ($order_column !== null) {
             $clone->order_column = $order_column;
         } else {
             $clone->order_column = self::DEFAULT_ORDER_COLUMN;
         }
 
         return $clone;
     }

◆ withOrderDirection()

ILIAS\Mail\Message\MailBoxQuery::withOrderDirection ( ?string $order_direction )

Definition at line 179 of file MailBoxQuery.php.

References ILIAS\Mail\Message\MailBoxQuery\$order_direction, ILIAS\Data\Order\ASC, and ILIAS\Data\Order\DESC.

                                                                 : MailBoxQuery
     {
         $clone = clone $this;
         if (\in_array($order_direction, [Order::ASC, Order::DESC], true)) {
             $clone->order_direction = $order_direction;
         } else {
             $clone->order_direction = self::DEFAULT_ORDER_DIRECTION;
         }
 
         return $clone;
     }

◆ withPeriodEnd()

ILIAS\Mail\Message\MailBoxQuery::withPeriodEnd ( ?DateTimeImmutable $period_end )

Definition at line 132 of file MailBoxQuery.php.

References ILIAS\Mail\Message\MailBoxQuery\$period_end.

                                                                  : MailBoxQuery
     {
         $clone = clone $this;
         $clone->period_end = $period_end;
 
         return $clone;
     }

◆ withPeriodStart()

ILIAS\Mail\Message\MailBoxQuery::withPeriodStart ( ?DateTimeImmutable $period_start )

Definition at line 124 of file MailBoxQuery.php.

References ILIAS\Mail\Message\MailBoxQuery\$period_start.

                                                                      : MailBoxQuery
     {
         $clone = clone $this;
         $clone->period_start = $period_start;
 
         return $clone;
     }

◆ withRecipients()

ILIAS\Mail\Message\MailBoxQuery::withRecipients ( ?string $recipients )

Definition at line 76 of file MailBoxQuery.php.

References ILIAS\Mail\Message\MailBoxQuery\$recipients.

                                                        : MailBoxQuery
     {
         $clone = clone $this;
         $clone->recipients = $recipients;
 
         return $clone;
     }

◆ withSender()

ILIAS\Mail\Message\MailBoxQuery::withSender ( ?string $sender )

Definition at line 68 of file MailBoxQuery.php.

References ILIAS\Mail\Message\MailBoxQuery\$sender.

                                                : MailBoxQuery
     {
         $clone = clone $this;
         $clone->sender = $sender;
 
         return $clone;
     }

◆ withSubject()

ILIAS\Mail\Message\MailBoxQuery::withSubject ( ?string $subject )

Definition at line 84 of file MailBoxQuery.php.

References ILIAS\Mail\Message\MailBoxQuery\$subject.

                                                  : MailBoxQuery
     {
         $clone = clone $this;
         $clone->subject = $subject;
 
         return $clone;
     }

Field Documentation

◆ $body

string ILIAS\Mail\Message\MailBoxQuery::$body = null

private

Definition at line 40 of file MailBoxQuery.php.

Referenced by ILIAS\Mail\Message\MailBoxQuery\getWhere(), and ILIAS\Mail\Message\MailBoxQuery\withBody().

◆ $db

ilDBInterface ILIAS\Mail\Message\MailBoxQuery::$db

private

Definition at line 35 of file MailBoxQuery.php.

◆ $filtered_ids

array ILIAS\Mail\Message\MailBoxQuery::$filtered_ids = null

private

Definition at line 47 of file MailBoxQuery.php.

Referenced by ILIAS\Mail\Message\MailBoxQuery\withFilteredIds().

◆ $folder_id

int ILIAS\Mail\Message\MailBoxQuery::$folder_id = null

private

Definition at line 36 of file MailBoxQuery.php.

Referenced by ILIAS\Mail\Message\MailBoxQuery\withFolderId().

◆ $has_attachment

bool ILIAS\Mail\Message\MailBoxQuery::$has_attachment = null

private

Definition at line 43 of file MailBoxQuery.php.

Referenced by ILIAS\Mail\Message\MailBoxQuery\withHasAttachment().

◆ $is_system

bool ILIAS\Mail\Message\MailBoxQuery::$is_system = null

private

Definition at line 42 of file MailBoxQuery.php.

Referenced by ILIAS\Mail\Message\MailBoxQuery\withIsSystem().

◆ $is_unread

bool ILIAS\Mail\Message\MailBoxQuery::$is_unread = null

private

Definition at line 41 of file MailBoxQuery.php.

Referenced by ILIAS\Mail\Message\MailBoxQuery\withIsUnread().

◆ $limit

int ILIAS\Mail\Message\MailBoxQuery::$limit = 999999

private

Definition at line 48 of file MailBoxQuery.php.

Referenced by ILIAS\Mail\Message\MailBoxQuery\withLimit().

◆ $offset

int ILIAS\Mail\Message\MailBoxQuery::$offset = 0

private

Definition at line 49 of file MailBoxQuery.php.

Referenced by ILIAS\Mail\Message\MailBoxQuery\withOffset().

◆ $order_column

MailBoxOrderColumn ILIAS\Mail\Message\MailBoxQuery::$order_column = self::DEFAULT_ORDER_COLUMN

private

Definition at line 50 of file MailBoxQuery.php.

Referenced by ILIAS\Mail\Message\MailBoxQuery\withOrderColumn().

◆ $order_direction

string ILIAS\Mail\Message\MailBoxQuery::$order_direction = self::DEFAULT_ORDER_DIRECTION

private

Definition at line 51 of file MailBoxQuery.php.

Referenced by ILIAS\Mail\Message\MailBoxQuery\query(), and ILIAS\Mail\Message\MailBoxQuery\withOrderDirection().

◆ $period_end

DateTimeImmutable ILIAS\Mail\Message\MailBoxQuery::$period_end = null

private

Definition at line 45 of file MailBoxQuery.php.

Referenced by ILIAS\Mail\Message\MailBoxQuery\withPeriodEnd().

◆ $period_start

DateTimeImmutable ILIAS\Mail\Message\MailBoxQuery::$period_start = null

private

Definition at line 44 of file MailBoxQuery.php.

Referenced by ILIAS\Mail\Message\MailBoxQuery\withPeriodStart().

◆ $recipients

string ILIAS\Mail\Message\MailBoxQuery::$recipients = null

private

Definition at line 38 of file MailBoxQuery.php.

Referenced by ILIAS\Mail\Message\MailBoxQuery\getWhere(), and ILIAS\Mail\Message\MailBoxQuery\withRecipients().

◆ $sender

string ILIAS\Mail\Message\MailBoxQuery::$sender = null

private

Definition at line 37 of file MailBoxQuery.php.

Referenced by ILIAS\Mail\Message\MailBoxQuery\withSender().

◆ $subject

string ILIAS\Mail\Message\MailBoxQuery::$subject = null

private

Definition at line 39 of file MailBoxQuery.php.

Referenced by ILIAS\Mail\Message\MailBoxQuery\getWhere(), and ILIAS\Mail\Message\MailBoxQuery\withSubject().

◆ DEFAULT_ORDER_COLUMN

const MailBoxOrderColumn ILIAS\Mail\Message\MailBoxQuery::DEFAULT_ORDER_COLUMN = MailBoxOrderColumn::SEND_TIME

private

Definition at line 32 of file MailBoxQuery.php.

◆ DEFAULT_ORDER_DIRECTION

const string ILIAS\Mail\Message\MailBoxQuery::DEFAULT_ORDER_DIRECTION = Order::ASC

private

Definition at line 33 of file MailBoxQuery.php.

The documentation for this class was generated from the following file:

components/ILIAS/Mail/classes/Message/MailBoxQuery.php

Public Member Functions

Private Member Functions

Private Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ count()

◆ countUnread()

◆ getFrom()

◆ getWhere()

◆ query()

◆ queryMailIds()

◆ withBody()

◆ withFilteredIds()

◆ withFolderId()

◆ withHasAttachment()

◆ withIsSystem()

◆ withIsUnread()

◆ withLimit()

◆ withOffset()

◆ withOrderColumn()

◆ withOrderDirection()

◆ withPeriodEnd()

◆ withPeriodStart()

◆ withRecipients()

◆ withSender()

◆ withSubject()

Field Documentation

◆ $body

◆ $db

◆ $filtered_ids

◆ $folder_id

◆ $has_attachment

◆ $is_system

◆ $is_unread

◆ $limit

◆ $offset

◆ $order_column

◆ $order_direction

◆ $period_end

◆ $period_start

◆ $recipients

◆ $sender

◆ $subject

◆ DEFAULT_ORDER_COLUMN

◆ DEFAULT_ORDER_DIRECTION