{"id":16109,"date":"2023-02-14T15:11:15","date_gmt":"2023-02-14T08:11:15","guid":{"rendered":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/?post_type=ht_kb&#038;p=16109"},"modified":"2026-01-03T11:13:22","modified_gmt":"2026-01-03T04:13:22","slug":"dat-cong-thuc-tinh-thuong-sinh-nhat-cho-nhan-vien","status":"publish","type":"ht_kb","link":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/kb\/dat-cong-thuc-tinh-thuong-sinh-nhat-cho-nhan-vien\/","title":{"rendered":"\u0110\u1eb7t c\u00f4ng th\u1ee9c t\u00ednh th\u01b0\u1edfng sinh nh\u1eadt cho nh\u00e2n vi\u00ean"},"content":{"rendered":"<p><a href=\"https:\/\/amis.misa.vn\/ld\/phan-mem-nhan-su-misa-amis?source=Helptienluong&amp;medium=SEO&amp;campaign=dat-cong-thuc-tinh-thuong-sinh-nhat-cho-nhan-vien&amp;content=Banner-sapo-topphanmemnhansu&amp;term=Quynh\"><img decoding=\"async\" class=\"alignnone wp-image-16403 size-full\" src=\"\/amis-tien-luong\/wp-content\/uploads\/2021\/06\/phan-mem-nhan-su-hrm.png\" alt=\"\" width=\"3200\" height=\"977\" \/><\/a><\/p>\n<div class=\"su-accordion su-u-trim\">\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><b>1. T\u1ed5ng quan<\/b><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p><strong>M\u1ee5c \u0111\u00edch:<\/strong> H\u01b0\u1edbng d\u1eabn thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c t\u1ef1 \u0111\u1ed9ng t\u00ednh th\u01b0\u1edfng sinh nh\u1eadt cho nh\u00e2n vi\u00ean trong th\u00e1ng t\u00ednh l\u01b0\u01a1ng.<br \/>\n<strong>N\u1ed9i dung:<\/strong> S\u1eed d\u1ee5ng h\u00e0m MONTH \u0111\u1ec3 so s\u00e1nh th\u00e1ng sinh v\u00e0 th\u00e1ng t\u00ednh l\u01b0\u01a1ng, \u0111\u1eb7t c\u00f4ng th\u1ee9c trong ph\u1ea7n m\u1ec1m AMIS Ti\u1ec1n l\u01b0\u01a1ng.<br \/>\n<strong>Ph\u1ea1m vi \u00e1p d\u1ee5ng:<\/strong> HR, K\u1ebf to\u00e1n ti\u1ec1n l\u01b0\u01a1ng, Qu\u1ea3n tr\u1ecb vi\u00ean ph\u1ea7n m\u1ec1m AMIS Nh\u00e2n s\u1ef1 \u2013 Ti\u1ec1n l\u01b0\u01a1ng<\/p>\n<\/div><\/div>\n<\/div>\n<div class=\"su-accordion su-u-trim\">\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><b>2. C\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n<\/b><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p>B\u01b0\u1edbc 1: HR l\u1ea5y th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng m\u1eb7c \u0111\u1ecbnh c\u1ee7a h\u1ec7 th\u1ed1ng l\u00e0 : THANG_TINH_LUONG ra \u0111\u1ec3 s\u1eed d\u1ee5ng \u0111\u1eb7t c\u00f4ng th\u1ee9c cho th\u00e0nh ph\u1ea7n l\u01b0\u01a1ng kh\u00e1c ho\u1eb7c c\u00f4ng th\u1ee9c t\u00ednh l\u01b0\u01a1ng trong M\u1eabu b\u1ea3ng l\u01b0\u01a1ng.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-16110\" style=\"border-width: 1px; border-style: groove;\" src=\"\/amis-tien-luong\/wp-content\/uploads\/2023\/02\/5.1.SNHAT_.png\" alt=\"\" width=\"1512\" height=\"938\" \/><\/p>\n<p style=\"text-align: left;\">B\u01b0\u1edbc 2: HR c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m MONTH \u0111\u1ec3 \u0111\u1ed1i chi\u1ebfu th\u00e1ng sinh c\u1ee7a nh\u00e2n vi\u00ean v\u1edbi th\u00e1ng t\u00ednh l\u01b0\u01a1ng.<\/p>\n<p>B\u01b0\u1edbc 3: So s\u00e1nh th\u00e1ng sinh v\u1edbi th\u00e1ng t\u00ednh l\u01b0\u01a1ng b\u1eb1ng bi\u1ec3u th\u1ee9c: <strong>MONTH(NGAY_SINH) = MONTH(THANG_TINH_LUONG)<\/strong>.<\/p>\n<p>B\u01b0\u1edbc 4: Thi\u1ebft l\u1eadp c\u00f4ng th\u1ee9c ho\u00e0n ch\u1ec9nh.<\/p>\n<p><em><strong>V\u00ed d\u1ee5:<\/strong> Th\u00e1ng sinh nh\u1eadt c\u1ee7a nh\u00e2n vi\u00ean \u0111\u01b0\u1ee3c th\u01b0\u1edfng 500.000\u0111 th\u00ec HR \u0111\u1eb7t c\u00f4ng th\u1ee9c:<\/em><\/p>\n<p style=\"text-align: center;\"><em>IF(MONTH(NGAY_SINH)=MONTH(THANG_TINH_LUONG),500000,0)<\/em><\/p>\n<p>Trong \u0111\u00f3: 500000 l\u00e0 gi\u00e1 tr\u1ecb th\u01b0\u1edfng 500.000\u0111, 0 l\u00e0 kh\u00f4ng th\u01b0\u1edfng n\u1ebfu kh\u00f4ng tr\u00f9ng th\u00e1ng.<\/p>\n<\/div><\/div>\n<\/div>\n<div class=\"su-accordion su-u-trim\">\n<div class=\"su-spoiler su-spoiler-style-default su-spoiler-icon-plus\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span><\/p>\n<h3><b>3. L\u01b0u \u00fd<\/b><\/h3>\n<p><\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<p>&#8211; \u0110\u1ea3m b\u1ea3o tr\u01b0\u1eddng <strong>NGAY_SINH<\/strong> c\u1ee7a nh\u00e2n vi\u00ean \u0111\u00e3 \u0111\u01b0\u1ee3c khai b\u00e1o \u0111\u1ea7y \u0111\u1ee7 trong h\u1ed3 s\u01a1.<br \/>\n&#8211; C\u00f4ng th\u1ee9c t\u1ef1 \u0111\u1ed9ng \u00e1p d\u1ee5ng cho t\u1ea5t c\u1ea3 nh\u00e2n vi\u00ean c\u00f3 ng\u00e0y sinh trong th\u00e1ng t\u00ednh l\u01b0\u01a1ng.<\/p>\n<\/div><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":107,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_links_to":"","_links_to_target":"","footnotes":""},"ht-kb-category":[211],"ht-kb-tag":[],"class_list":["post-16109","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-r6-phat-hanh-ngay-02-02-2023"],"_links":{"self":[{"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb\/16109","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/users\/107"}],"replies":[{"embeddable":true,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/comments?post=16109"}],"version-history":[{"count":4,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb\/16109\/revisions"}],"predecessor-version":[{"id":18711,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb\/16109\/revisions\/18711"}],"wp:attachment":[{"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/media?parent=16109"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb-category?post=16109"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"http:\/\/helpamis.misa.vn\/amis-tien-luong\/wp-json\/wp\/v2\/ht-kb-tag?post=16109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}