Untitled

ALTER TABLE md_fetal_period_info
ADD fruit varchar(30);
ALTER TABLE md_fetal_period_info
ADD image_fruit nvarchar(100);


UPDATE md_fetal_period_info
SET fruit = CASE
WHEN fetal_week = 1 THEN '--'
WHEN fetal_week = 2 THEN '--'
WHEN fetal_week = 3 THEN '--'
WHEN fetal_week = 4 THEN 'Hạt chia'
WHEN fetal_week = 5 THEN 'Hạt cam'
WHEN fetal_week = 6 THEN 'Hạt lựu'
WHEN fetal_week = 7 THEN 'Quả việt quất nhỏ'
WHEN fetal_week = 8 THEN 'Quả mâm xôi'
WHEN fetal_week = 9 THEN 'Quả anh đào'
WHEN fetal_week = 10 THEN 'Quả quất'
WHEN fetal_week = 11 THEN 'Quả sung'
WHEN fetal_week = 12 THEN 'Quả mận'
WHEN fetal_week = 13 THEN 'Quả chanh vàng'
WHEN fetal_week = 14 THEN 'Quả đào'
WHEN fetal_week = 15 THEN 'Quả táo'
WHEN fetal_week = 16 THEN 'Quả bơ'
WHEN fetal_week = 17 THEN 'Quả lê'
WHEN fetal_week = 18 THEN 'Củ khoai lang'
WHEN fetal_week = 19 THEN 'Quả xoài'
WHEN fetal_week = 20 THEN 'Quả chuối'
WHEN fetal_week = 21 THEN 'Củ cà rốt'
WHEN fetal_week = 22 THEN 'Quả đu đủ'
WHEN fetal_week = 23 THEN 'Cà tím'
WHEN fetal_week = 24 THEN 'Bắp ngô'
WHEN fetal_week = 25 THEN 'Bí đỏ Acorn'
WHEN fetal_week = 26 THEN 'Bí ngòi'
WHEN fetal_week = 27 THEN 'Súp lơ'
WHEN fetal_week = 28 THEN 'Bí Kabocha'
WHEN fetal_week = 29 THEN 'Bí đao'
WHEN fetal_week = 30 THEN 'Bắp cải lớn'
WHEN fetal_week = 31 THEN 'Bó tỏi tây'
WHEN fetal_week = 32 THEN 'Bắp cải Napa'
WHEN fetal_week = 33 THEN 'Quả dứa'
WHEN fetal_week = 34 THEN 'Quả dưa lưới'
WHEN fetal_week = 35 THEN 'Quả dưa mật'
WHEN fetal_week = 36 THEN 'Quả dưa vàng'
WHEN fetal_week = 37 THEN 'Cải cầu vồng'
WHEN fetal_week = 38 THEN 'Thân cây đại hoàng'
WHEN fetal_week = 39 THEN 'Quả dưa hấu'
WHEN fetal_week = 40 THEN 'Quả dưa hấu'
ELSE NULL
END;


UPDATE md_fetal_period_info
SET image_fruit = CASE
when fetal_week =1 then "nothing"
when fetal_week =2 then "nothing"
when fetal_week =3 then "nothing"
WHEN fetal_week = 4 THEN "https://admmomeduapi.exsoft.vn/api/attachments/db2d46f5-739d-43cd-8b00-c3ca46b5c7ce"
WHEN fetal_week = 5 THEN "https://admmomeduapi.exsoft.vn/api/attachments/169a37e7-d7db-462c-9f81-2b9dd8f143a2"
When fetal_week = 6 then "https://admmomeduapi.exsoft.vn/api/attachments/de0eb30d-2ce5-4b1c-802d-0bc29cee152f"
when fetal_week = 7 then "https://admmomeduapi.exsoft.vn/api/attachments/227fb625-283b-467b-a6ee-e0a96c40cdd2"
when fetal_week = 8 then "https://admmomeduapi.exsoft.vn/api/attachments/7743cf6f-11e2-4b94-b516-9cc046fb4657"
when fetal_week = 9 then "https://admmomeduapi.exsoft.vn/api/attachments/69d09160-c3d7-495e-aa23-747d4b4171f6"
when fetal_week = 10 then "https://admmomeduapi.exsoft.vn/api/attachments/726adce5-c1d2-46e6-b2b0-b43270a8bdc2"
when fetal_week = 11 then "https://admmomeduapi.exsoft.vn/api/attachments/0110c58e-d3fa-49e5-b121-aa3cc02704a7"
when fetal_week =12 then "https://admmomeduapi.exsoft.vn/api/attachments/e5fbc1ac-c22c-499f-874f-085d4beb7b35"
when fetal_week = 13 then "https://admmomeduapi.exsoft.vn/api/attachments/dbae2cf8-4ab8-49e5-a2ce-bc11c4af89c0"
when fetal_week =14 then "https://admmomeduapi.exsoft.vn/api/attachments/1d803ae7-e98c-41d9-874a-97c2039d4a39"
when fetal_week = 15 then "https://admmomeduapi.exsoft.vn/api/attachments/3aabc533-8731-4385-b096-5407d641774d"
when fetal_week = 16 then "https://admmomeduapi.exsoft.vn/api/attachments/4fbf368e-6afb-4ceb-abe6-e34c398c9401"
when fetal_week = 17 then "https://admmomeduapi.exsoft.vn/api/attachments/c38a72d6-a86f-46fc-81df-de95822e09fd"
when fetal_week = 18 then "https://admmomeduapi.exsoft.vn/api/attachments/30e3a2a1-5675-4d67-a79c-e3928363087d"
when fetal_week = 19 then "https://admmomeduapi.exsoft.vn/api/attachments/dc174447-4055-4a18-a1fe-044a29bbdc64"
when fetal_week = 20 then "https://admmomeduapi.exsoft.vn/api/attachments/09ffeaf0-7ee9-45ad-b10e-3eb715620375"
when fetal_week = 21 then "https://admmomeduapi.exsoft.vn/api/attachments/97b6ba0f-e203-4a44-ae77-051fa2cd0589"
when fetal_week = 22 then "https://admmomeduapi.exsoft.vn/api/attachments/84632a6e-a886-4ae9-8f84-ef18e5d17f24"
when fetal_week = 23 then "https://admmomeduapi.exsoft.vn/api/attachments/fc3549b3-a8cd-4101-b266-3103d65c1c5d"
when fetal_week = 24 then "https://admmomeduapi.exsoft.vn/api/attachments/2db007db-8ffe-4dc8-9280-8cac36c42def"
when fetal_week = 25 then "https://admmomeduapi.exsoft.vn/api/attachments/6609052b-a637-4a33-9908-1994f67a7cea"
when fetal_week = 26 then "https://admmomeduapi.exsoft.vn/api/attachments/2327fab7-64c8-4ccf-a459-9c98c11bc8ee"
when fetal_week = 27 then "https://admmomeduapi.exsoft.vn/api/attachments/a40e54e5-ace6-44fb-a3e9-428f64fa085b"
when fetal_week = 28 then "https://admmomeduapi.exsoft.vn/api/attachments/dc17947a-2610-458f-a977-5c8d9789a266"
when fetal_week =29 then "https://admmomeduapi.exsoft.vn/api/attachments/e9057003-8837-426f-a005-5fe96323763c"
when fetal_week = 30 then "https://admmomeduapi.exsoft.vn/api/attachments/3020437a-8cef-4198-930e-c7936e959f39"
when fetal_week = 31 then "https://admmomeduapi.exsoft.vn/api/attachments/5fb635f2-9961-4bae-b6a1-0df7772e6710"
when fetal_week = 32 then "https://admmomeduapi.exsoft.vn/api/attachments/4d8d56b0-9c18-42a2-b198-69e88e884215"
when fetal_week = 33 then "https://admmomeduapi.exsoft.vn/api/attachments/8ef359ac-6a14-4cae-8d14-aaec3ac7367c"
when fetal_week = 34 then "https://admmomeduapi.exsoft.vn/api/attachments/aa4e49d2-8aaa-4eee-9fd8-60cec27fa7a9"
when fetal_week = 35 then "https://admmomeduapi.exsoft.vn/api/attachments/da3e8ee6-262e-4712-a470-8dbbe0371b9f"
when fetal_week =36 then "https://admmomeduapi.exsoft.vn/api/attachments/1872c012-7d38-472d-a3cd-c9c18a75bd51"
when fetal_week = 37 then "https://admmomeduapi.exsoft.vn/api/attachments/a66d30f6-75f0-4152-b185-34d7bc544295"
when fetal_week = 38 then "https://admmomeduapi.exsoft.vn/api/attachments/513b3214-153b-49fb-80dd-14d52862994e"
when fetal_week = 39 then "https://admmomeduapi.exsoft.vn/api/attachments/abfb8943-abda-459d-a861-8daf65eb39d1"
when fetal_week = 40 then "https://admmomeduapi.exsoft.vn/api/attachments/abfb8943-abda-459d-a861-8daf65eb39d1"
ELSE NULL
END;