<?php

/**
 * i-doit
 *
 * DAO: ObjectType list for Emergency plans
 *
 * @package     i-doit
 * @subpackage  CMDB_Category_lists
 * @copyright   synetics GmbH
 * @license     http://www.i-doit.com/license
 */
class isys_cmdb_dao_list_catg_assigned_subscriptions extends isys_component_dao_category_table_list implements isys_cmdb_dao_list_interface
{
    /**
     * Return constant of category
     *
     * @return  integer
     */
    public function get_category()
    {
        return defined_or_default('C__CATG__ASSIGNED_SUBSCRIPTIONS');
    }

    /**
     * Return constant of category type
     *
     * @return  integer
     */
    public function get_category_type()
    {
        return C__CMDB__CATEGORY__TYPE_GLOBAL;
    }

    /**
     * Gets result list.
     *
     * @param   string  $p_str
     * @param   integer $p_obj_id
     * @param   integer $p_record_status
     *
     * @return  isys_component_dao_result
     */
    public function get_result($p_str = null, $p_obj_id = null, $p_record_status = null)
    {
        $l_status = $p_record_status ?: $this->get_rec_status();
        $l_object = $p_obj_id ?: $this->m_cat_dao->get_object_id();

        $l_sql = 'SELECT cat.*, o.isys_obj__id as connectedObjectId, o.isys_obj__title as connectedObjectTitle,
                    s.isys_catg_cloud_subscriptions_list__uuid as uuid
            FROM isys_catg_assigned_subscriptions_list as cat
            INNER JOIN isys_connection as conn on conn.isys_connection__id = cat.isys_catg_assigned_subscriptions_list__isys_connection__id
            INNER JOIN isys_obj as o on o.isys_obj__id = conn.isys_connection__isys_obj__id
            LEFT JOIN isys_catg_cloud_subscriptions_list as s on s.isys_catg_cloud_subscriptions_list__id = cat.isys_catg_assigned_subscriptions_list__cloud_subscr__id
			WHERE TRUE';

        if ($l_object) {
            $l_sql .= ' AND isys_catg_assigned_subscriptions_list__isys_obj__id = ' . $this->convert_sql_int($l_object);
        }

        if ($l_status) {
            $l_sql .= ' AND isys_catg_assigned_subscriptions_list__status = ' . $this->convert_sql_int($l_status);
        }

        return $this->retrieve($l_sql);
    }

    /**
     * Method for retrieving the field-names.
     *
     * @return  array
     */
    public function get_fields()
    {
        return [
            'connectedObjectTitle'                                  => 'LC__CMDB__CATG__ASSIGNED_SUBSCRIPTIONS__ASSIGNED_OBJECT',
            'uuid'                                                  => 'LC__CMDB__CATG__ASSIGNED_SUBSCRIPTIONS__UUID',
            'isys_catg_assigned_subscriptions_list__description'    => 'LC__CMDB__CATG__DESCRIPTION',
        ];
    }

    /**
     * Order condition
     *
     * @param string $p_column
     * @param string $p_direction
     *
     * @return string
     */
    public function get_order_condition($p_column, $p_direction)
    {
        return $p_column . " " . $p_direction;
    }
}
