<?php

/**
 * i-doit
 *
 * DAO: Class for overview category
 *
 * @package     i-doit
 * @subpackage  CMDB_Category_lists
 * @author      Van Quyen Hoang <qhoang@i-doit.org>
 * @copyright   synetics GmbH
 * @license     http://www.i-doit.com/license
 */
class isys_cmdb_dao_list_cats_person_contact_assign extends isys_component_dao_category_table_list
{
    /**
     * @return  integer
     */
    public function get_category()
    {
        return defined_or_default('C__CATS__PERSON_CONTACT_ASSIGNMENT');
    }

    /**
     * @return  integer
     */
    public function get_category_type()
    {
        return C__CMDB__CATEGORY__TYPE_SPECIFIC;
    }

    /**
     * @param null $p_str
     * @param      $p_objID
     * @param null $p_cRecStatus
     *
     * @return isys_component_dao_result
     * @throws isys_exception_database
     * @version Dennis Blümer <dbluemer@i-doit.org>
     */
    public function get_result($p_str = null, $p_objID, $p_cRecStatus = null)
    {
        $objectId = $this->convert_sql_id($p_objID);

        $sql = "SELECT 
                isys_catg_contact_list.*, 
                o1.*, isys_contact_tag.*, isys_obj_type__title,
                (CASE WHEN isys_catg_contact_list__primary_contact = 1 THEN 'LC__UNIVERSAL__YES' 
                    WHEN isys_catg_contact_list__primary_contact = 0 THEN 'LC__UNIVERSAL__NO' 
                    ELSE 'LC__UNIVERSAL__NO' END) primaryContact
            FROM isys_catg_contact_list 
            INNER JOIN isys_connection  ON isys_connection__id = isys_catg_contact_list.isys_catg_contact_list__isys_connection__id 
            INNER JOIN isys_obj AS o1 ON isys_catg_contact_list.isys_catg_contact_list__isys_obj__id = o1.isys_obj__id 
            INNER JOIN isys_obj AS o2 ON o2.isys_obj__id = isys_connection__isys_obj__id 
            LEFT JOIN isys_obj_type ON isys_obj_type__id = o1.isys_obj__isys_obj_type__id
            LEFT JOIN isys_contact_tag ON isys_contact_tag__id = isys_catg_contact_list.isys_catg_contact_list__isys_contact_tag__id 
            WHERE isys_connection__isys_obj__id = {$objectId} ";

        $l_cRecStatus = (int)($p_cRecStatus === null) ? $this->get_rec_status() : $p_cRecStatus;

        if ($l_cRecStatus > 0) {
            $recordStatus = $this->convert_sql_int($l_cRecStatus);

            // @see  ID-8287 Only show entries as ranked, when they actually are.
            if (isys_tenantsettings::get('cmdb.only-show-ranked-entries-as-such', 0)) {
                $sql .= "AND isys_catg_contact_list__status = {$recordStatus}";
            } else {
                $sql .= "AND (
                    (o1.isys_obj__status >= isys_catg_contact_list__status AND
                        o1.isys_obj__status >= o2.isys_obj__status AND
                        o1.isys_obj__status = {$recordStatus}) OR
    
                    (o2.isys_obj__status >= isys_catg_contact_list__status AND
                        o2.isys_obj__status >= o1.isys_obj__status AND
                        o2.isys_obj__status = {$recordStatus}) OR
    
                    (isys_catg_contact_list__status >= o1.isys_obj__status AND
                        isys_catg_contact_list__status >= o2.isys_obj__status AND
                        isys_catg_contact_list__status = {$recordStatus})
                )";
            }
        }

        return $this->retrieve($sql . ';');
    }

    /**
     * Returns array with table headers
     *
     * @return array
     */
    public function get_fields()
    {
        return [
            'isys_obj__title'         => 'LC_UNIVERSAL__OBJECT',
            'isys_obj_type__title'    => 'LC__CMDB__OBJTYPE',
            'isys_contact_tag__title' => 'LC__CMDB__CONTACT_ROLE',
            'primaryContact'          => 'LC__CATG__CONTACT_LIST__PRIMARY',
            'isys_catg_contact_list__description' => 'LC__CMDB__CAT__COMMENTARY',
        ];
    }

    /**
     * @param   array $urlOverwrite
     *
     * @return  string
     * @throws isys_exception_database
     */
    public function make_row_link($urlOverwrite = null)
    {
        $l_sql = 'SELECT isys_obj__id, isys_obj_type__isys_obj_type_group__id, isys_obj__isys_obj_type__id
			FROM isys_obj
			INNER JOIN isys_obj_type ON isys_obj_type__id = isys_obj__isys_obj_type__id
			WHERE isys_obj__id = ' . $_GET[C__CMDB__GET__OBJECT] . ';';

        $l_gets = isys_module_request::get_instance()->get_gets();
        $l_catdata = $this->retrieve($l_sql)->get_row();

        $urlParameters = [
            C__CMDB__GET__VIEWMODE           => C__CMDB__VIEW__CATEGORY_GLOBAL,
            C__CMDB__GET__TREEMODE           => $l_gets[C__CMDB__GET__TREEMODE],
            C__CMDB__GET__OBJECT             => $l_catdata["isys_obj__id"],
            C__CMDB__GET__CATS               => defined_or_default('C__CATS__PERSON_CONTACT_ASSIGNMENT'),
            C__CMDB__GET__OBJECTGROUP        => $l_catdata["isys_obj_type__isys_obj_type_group__id"],
            C__GET__MAIN_MENU__NAVIGATION_ID => $l_gets["mNavID"],
            C__CMDB__GET__OBJECTTYPE         => $l_catdata["isys_obj__isys_obj_type__id"],
            C__CMDB__GET__CATLEVEL           => "[{isys_catg_contact_list__id}]"
        ];

        // Append or override from parameter array.
        if (is_array($urlOverwrite) && count($urlOverwrite)) {
            // @todo  Can this be done via array_merge?
            foreach ($urlOverwrite as $key => $value) {
                $urlParameters[$key] = $urlOverwrite[$key];
            }
        }

        return isys_helper_link::create_url($urlParameters);
    }

    /**
     * @param array $row
     */
    public function modify_row(&$row)
    {
        if ($row['isys_obj__id'] != null) {
            $row['isys_obj__title'] = isys_ajax_handler_quick_info::instance()->getQuickInfoReplacement(
                $row['isys_obj__id'],
                $row['isys_obj__title']
            );
        }
    }
}
