def get_ticket_environment(self, id_ticket, id_branch=None):
        ticket_library_dao = TicketLibraryDao(self._controller_dao.get_dict_database())
        id_environment = ticket_library_dao.get_id_environment(id_ticket)
        if id_environment:
            return id_environment

        cat_branch_dao = CatBranchDao(self._controller_dao.get_dict_database())
        return cat_branch_dao.get_environment(1)
    def process_library_ticket(self, dict_defect):
        translate_environment_dao = TranslateEnvironmentDao(self._controller_dao.get_dict_database())
        crm = dict_defect["crm"]
        environment = dict_defect["environment"]

        id_environment = translate_environment_dao.translate(crm=crm, environment=environment)
        if id_environment:
            dict_defect['dict_defect'] = dict_defect["description"][:200]
            dict_defect['id_environment'] = id_environment

            ticket_library_dao = TicketLibraryDao(self._controller_dao.get_dict_database())
            ticket_library_dao.process_ticket_library(dict_defect)

            ticket_board_dao = TicketBoardDao(self._controller_dao.get_dict_database())
            ticket_board_dao.update_environment(dict_defect['id_ticket'], id_environment)
            return {"result_code": "OK", "message": "success"}
        else:
            message_error = "couldn't find id_environment at translate_environment table, with crm=%s environment=%s" % (
                dict_defect["crm"], dict_defect["environment"])
            logger.error(message_error)
            return {"result_code": "ERROR", "message": message_error}