쪽지 리스트를 대화상대별로 출력 (1) - 대화상대 리스트 뽑아봅기

<query id="getMessagesByMemberSrl" action="select">
    <tables>
        <table name="member_message" />
    </tables>
    <columns>
        <column name="*" />
    </columns>
    <conditions>
        <group>
            <group>
                <condition operation="equal" column="receiver_srl" var="member_srl" notnull="notnull" />
                <condition operation="in" column="message_type" default="R, T" />
            </group>
            <group pipe="or">
                <condition operation="equal" column="sender_srl" var="member_srl" notnull="notnull" />
                <condition operation="equal" column="message_type" default="S" />
            </group>
        </group>
        <group>
            <condition operation="search" column="title" var="s_title" />
            <condition operation="search" column="content" var="s_content" />
            <group>
                <condition operation="search" column="title" var="s_title_content" />
                <condition operation="search" column="content" var="s_title_content" pipe="or" />
            </group>
        </group>
    </conditions>
</query>

/**
 * get a message list by member_srl
 * @param int $member_srl
 * @param string $search_target
 * @param string $search_keyword
 * @return Object
 */
public static function getMessageListByMemberSrl($member_srl = null, $search_target = null, $search_keyword = null)
{
    if(!$member_srl)
    {
        $logged_info = Context::get('logged_info');
        $member_srl = $logged_info->member_srl;
    }
 

    $args = new stdClass();

    // Search conditions
    if ($search_target && $search_keyword)
    {
        $args->{'s_' . $search_target} = $search_keyword;
    }

    // Other variables
    $args->member_srl = $member_srl;

    // Get messages from DB
    $output = executeQueryArray('communication.getMessagesByMemberSrl', $args);

    return $output;
}

/**
 * get a message list by last_message_srl
 * @param int $member_srl
 * @return Object
 */
public static function getMessageHeadList($member_srl = null, $search_target = null, $search_keyword = null)
{
    if(!$member_srl)
    {
        $logged_info = Context::get('logged_info');
        $member_srl = $logged_info->member_srl;
    }

    $output = self::getMessagesByMemberSrl($member_srl, $search_target, $search_keyword);
    if (!$output->toBool())
    {
        return $output;
    }

    $message_list = array();
    foreach ($output->data as $val)
    {
        $partner_srl = ($val->message_type === 'S') ? $val->receiver_srl: $val->sender_srl;
        if (!isset($message_list[$partner_srl]))
        {
            $message_list[$partner_srl] = new stdClass();
            $message_list[$partner_srl]->member_srl = $member_srl;
            $message_list[$partner_srl]->partner_srl = $partner_srl;
            $message_list[$partner_srl]->message_count = 0;
            $message_list[$partner_srl]->unread_count = 0;
        }

        if (!isset($message_list[$partner_srl]->last_message_srl))
        {
            $message_list[$partner_srl]->last_message_srl = $val->message_srl;
            $message_list[$partner_srl]->message_type = $val->message_type;
            $message_list[$partner_srl]->regdate = $val->regdate;
        }
        else
        {
            if ($val->message_srl > $message_list[$partner_srl]->last_message_srl)
            {
                $message_list[$partner_srl]->last_message_srl = $val->message_srl;
                $message_list[$partner_srl]->message_type = $val->message_type;
                $message_list[$partner_srl]->regdate = $val->regdate;
            }
        }
        if (!isset($message_list[$partner_srl]->first_message_srl))
        {
            $message_list[$partner_srl]->first_message_srl = $val->message_srl;
        }
        else
        {
            $message_list[$partner_srl]->first_message_srl = min($val->message_srl, $message_list[$partner_srl]->first_message_srl);
        }

        $message_list[$partner_srl]->message_count++;
        if ($val->readed === 'N')
        {
            $message_list[$partner_srl]->unread_count++;
        }
    }

    $last_message_srl_list = array_column($message_list, 'last_message_srl');
    array_multisort($last_message_srl_list, SORT_DESC, $message_list);
    return $message_list;
}

// TEST
$message_head_list = CommunicationModel::getMessageHeadList($logged_info->member_srl, $search_target, $search_keyword);
if (!empty($message_head_list))
{
    foreach ($message_head_list as $key => $val)
    {
        $message_head_list[$key]->message = CommunicationModel::getSelectedMessage($val->last_message_srl);
    }
}
debugPrint($message_head_list);