-- 2026-04-16
-- Icones mais coerentes para a Area do Cliente
-- Objetivo:
-- 1) melhorar a leitura visual da jornada do cliente
-- 2) manter links, slugs, permissoes, parent e sort exatamente como estao
-- 3) trocar somente o campo icon dos itens do menu do cliente

START TRANSACTION;

SET @menu_id = 35;

UPDATE wpjy_menus_items
   SET icon = CASE id
       WHEN 504 THEN 'solar:user-circle-line-duotone'
       WHEN 505 THEN 'solar:home-2-line-duotone'
       WHEN 506 THEN 'ti ti-calendar-plus'
       WHEN 507 THEN 'ti ti-map-pin-search'
       WHEN 508 THEN 'ti ti-shopping-bag'
       WHEN 509 THEN 'ti ti-file-invoice'
       WHEN 510 THEN 'ti ti-wallet'
       WHEN 511 THEN 'ti ti-receipt-2'
       WHEN 512 THEN 'ti ti-stethoscope'
       WHEN 513 THEN 'ti ti-files'
       WHEN 514 THEN 'solar:user-circle-line-duotone'
       WHEN 515 THEN 'solar:user-id-line-duotone'
       WHEN 516 THEN 'ti ti-search'
       WHEN 517 THEN 'ti ti-map-search'
       WHEN 518 THEN 'ti ti-activity'
       WHEN 519 THEN 'ti ti-clipboard-list'
       WHEN 520 THEN 'ti ti-heartbeat'
       WHEN 521 THEN 'ti ti-users'
       WHEN 522 THEN 'ti ti-message-circle'
       WHEN 523 THEN 'ti ti-user-circle'
       WHEN 524 THEN 'ti ti-shield-heart'
       WHEN 525 THEN 'ti ti-pill'
       WHEN 526 THEN 'solar:lifebuoy-line-duotone'
       WHEN 527 THEN 'ti ti-building-hospital'
       WHEN 528 THEN 'ti ti-map-search'
       WHEN 529 THEN 'lucide:id-card'
       WHEN 530 THEN 'ti ti-heart'
       WHEN 548 THEN 'ti ti-shield-check'
       WHEN 549 THEN 'ti ti-lock-password'
       WHEN 550 THEN 'ti ti-credit-card'
       WHEN 591 THEN 'ti ti-ticket'
       ELSE icon
   END
 WHERE menu = @menu_id
   AND id IN (
       504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515,
       516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 527,
       528, 529, 530, 548, 549, 550, 591
   );

COMMIT;

SELECT id, label, area, parent, sort, icon, slug
  FROM wpjy_menus_items
 WHERE menu = @menu_id
   AND id IN (
       504, 505, 506, 507, 508, 509, 510, 511, 512, 513, 514, 515,
       516, 517, 518, 519, 520, 521, 522, 523, 524, 525, 526, 527,
       528, 529, 530, 548, 549, 550, 591
   )
 ORDER BY parent, sort, id;