Subversion Repositories SmartDukaan

-- Set distinct ElegantIcons for each parent menu item in the sidebar
UPDATE auth.menu SET icon_class = CASE display_text
    WHEN 'Product'             THEN 'icon_bag_alt'
    WHEN 'Sales Management'    THEN 'icon_cart_alt'
    WHEN 'Partner Acquisition' THEN 'icon_group'
    WHEN 'Credit Control'      THEN 'icon_creditcard'
    WHEN 'Admin Control'       THEN 'icon_cog'
    WHEN 'Fin Services'        THEN 'icon_currency'
    WHEN 'Finance'             THEN 'icon_wallet'
    WHEN 'HRMS'                THEN 'icon_profile'
    WHEN 'Ticket'              THEN 'icon_tag_alt'
    WHEN 'Vendor'              THEN 'icon_briefcase'
    WHEN 'Referrals'           THEN 'icon_gift_alt'
    WHEN 'Purchase Order'      THEN 'icon_clipboard'
    WHEN 'Analysis'            THEN 'icon_piechart'
    WHEN 'Catalog'             THEN 'icon_grid-3x3'
    WHEN 'Prebookings'         THEN 'icon_calendar'
    WHEN 'Technology'          THEN 'icon_desktop'
    WHEN 'Recharge'            THEN 'icon_mobile'
    WHEN 'Logistics'           THEN 'icon_map_alt'
    WHEN 'Online'              THEN 'icon_globe'
    WHEN 'Stock Management'    THEN 'icon_archive_alt'
    WHEN 'Partner Reports'     THEN 'icon_datareport'
    WHEN 'Users List'          THEN 'icon_contacts_alt'
    WHEN 'Upselling'           THEN 'icon_lightbulb_alt'
    WHEN 'Retailer'            THEN 'icon_building'
    WHEN 'Smart Seller'        THEN 'icon_star_alt'
    WHEN 'Bulletin'            THEN 'icon_comment_alt'
    ELSE icon_class
END
WHERE parent_menu_id IS NULL;