Notes Number Management

• Use this page to "bag" notes.
• Only update this page on the live site, irrespective of the environment on which you are authoring content.
• The live version of this page is considered definitive.

Creating a new note

Decide on the note's grade

Super-Gold, Gold, Silver or Bronze.

Super-Gold notes are reserved for very important information.
They have numbers 1-9.

Gold notes are top-level notes: they appear at the top-level in the menu, and are used for section introductions.
They have 2-digit numbers.

Silver notes are fairly important: they appear at deeper levels in the menu (i.e. not a at the top level) and contain information that customers of dealers will want to access fairly frequently.
They have 3-digit numbers.

Bronze notes contain detailed information: they appear at deeper levels in the menu (i.e. not at the top level) and contain information that customers of dealers will want to access occasionally.
They have 4-digit numbers.

Choose a note number

Use the tables below to choose a note number. Edit this page to 'bag' the note, filling in the following details:

• Menu title
• Owner - your TLA
• Department
• Project - the project's TLA
• Date
• Comments, if any

On the authoring environment create the note

Log into prev, dev or edge1 if you are not authoring on live.

Select Content > Add Content > Note from the admin menu at the top of the page.

For more information consult the latest version of DEH-dmDrupal-Editors-HowTos (our printed guide to using this CMS).

Super Gold

Gold

Silver

Bronze

Useful SQL

# ------------------------------------------------------------
# Generate a list of notes BY change_date
# ------------------------------------------------------------

SELECT field_note_number_value, title, FROM_UNIXTIME(changed) AS change_date
    FROM field_data_field_note_number AS nn JOIN node ON nn.entity_id = node.nid
    ORDER BY change_date DESC;

# ------------------------------------------------------------
# Generate a list of notes 0001 - 9999, showing all free notes
# ------------------------------------------------------------

# Generate list of all current notes
DROP TABLE IF EXISTS ZZZZZ_all_used_notes;
CREATE TABLE ZZZZZ_all_used_notes
    SELECT field_note_number_value AS note_number, title
    FROM field_data_field_note_number AS nn JOIN node ON nn.entity_id = node.nid
    ORDER BY note_number ASC;

# Generate list of all possible notes
DROP TABLE IF EXISTS ZZZZZ_all_possible_notes;
CREATE TABLE ZZZZZ_all_possible_notes
SELECT @row := @row + 1 as possible_note_number FROM
    (SELECT 0 UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL
     SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) t,
    (SELECT 0 UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL
     SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) t2,
    (SELECT 0 UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL
     SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) t3,
    (SELECT 0 UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL
     SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) t4,
    (SELECT @row:=0) apn;

# Select note numbers in ZZZZZ_all_possible_notes that do not appear in ZZZZZ_all_notes
DROP TABLE IF EXISTS ZZZZZ_all_notes;
CREATE TABLE ZZZZZ_all_notes
SELECT  possible_note_number, title
        FROM ZZZZZ_all_possible_notes LEFT JOIN ZZZZZ_all_used_notes
             ON possible_note_number = note_number
        ORDER BY possible_note_number;
UPDATE ZZZZZ_all_notes SET title='' WHERE title IS NULL;

# Clear up
DROP TABLE ZZZZZ_all_used_notes;
DROP TABLE ZZZZZ_all_possible_notes;