<?php
    defined('BASEPATH') OR exit('No direct script access allowed');

    class ContactModel extends CI_Model
    {

        public function __construct()
        {
            parent::__construct();
        }

        public function getContactMessages()
        {
            $results = $this->db->query('SELECT * FROM contact_messages ORDER BY isUnread DESC')->result_array();
            $results = $this->mergeUserName($results);
            return $results;
        }

        private function mergeUserName($results)
        {
            foreach ($results as $i => $result) {
                $result['username'] = null;
                $result['displayname'] = null;
                if ($result['userID'] == null)
                    goto next;

                $user = $this->db->query('SELECT displayname, username FROM users WHERE ID = ?', [$result['userID']])->result_array();
                if (empty($user)) {
                    $result['userID'] = null;
                    goto next;
                }

                $user = $user[0];
                $result['username'] = $user['username'];
                $result['displayname'] = $user['displayname'];

                next: $results[$i] = $result;
            }
            return $results;
        }
    }