{"id":30,"date":"2026-03-31T07:03:19","date_gmt":"2026-03-31T07:03:19","guid":{"rendered":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151002\/?p=30"},"modified":"2026-04-14T03:51:16","modified_gmt":"2026-04-14T03:51:16","slug":"3%ec%a3%bc%ec%b0%a8-%ec%a3%bc%ea%b0%84%eb%b3%b4%ea%b3%a0%ec%84%9c","status":"publish","type":"post","link":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151002\/2026\/03\/31\/3%ec%a3%bc%ec%b0%a8-%ec%a3%bc%ea%b0%84%eb%b3%b4%ea%b3%a0%ec%84%9c\/","title":{"rendered":"3\uc8fc\ucc28 \uc8fc\uac04\ubcf4\uace0\uc11c"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\" style=\"font-size:27px\"><strong>\ud504\ub85c\uc81d\ud2b8\uba85: FF POS<\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li class=\"has-large-font-size\"><strong>\uae08\uc8fc \uc9c4\ud589 \uc0ac\ud56d<\/strong><\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\uc2e4\uc2dc\uac04 \ud3d0\uae30 \uc784\ubc15 \uc54c\ub9bc \uc2dc\uc2a4\ud15c \uad6c\ucd95<\/strong>\n<ul class=\"wp-block-list\">\n<li>\uae30\ub2a5 \uc815\uc758: \uc720\ud1b5\uae30\ud55c\uc774 1\uc2dc\uac04 \uc774\ub0b4\ub85c \ub0a8\uc740 \uc2e0\uc120\uc2dd\ud488\uc744 \uc790\ub3d9\uc73c\ub85c \ucd94\ucd9c\ud558\uc5ec \ub9ac\uc2a4\ud2b8\uc5c5\ud558\ub294 \uae30\ub2a5.<\/li>\n\n\n\n<li>\uae30\uc220\uc801 \uad6c\ud604:\n<ul class=\"wp-block-list\">\n<li>MySQL\uc758 <code>TIMESTAMPDIFF<\/code> \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud604\uc7ac \uc2dc\uac04\uacfc \uc720\ud1b5\uae30\ud55c\uc758 \ucc28\uc774\ub97c \ubd84 \ub2e8\uc704\ub85c \uacc4\uc0b0.<\/li>\n\n\n\n<li>\ud310\ub9e4\uc911\uc778 \uc0c1\ud488\ub9cc \ud544\ud130\ub9c1\ud558\uc5ec \ubd88\ud544\uc694\ud55c \ub370\uc774\ud130 \ub178\ucd9c\uc744 \ubc29\uc9c0.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\ud310\ub9e4 \uc2e4\uc801 \ubd84\uc11d \uc2dc\uc2a4\ud15c<\/strong>\n<ul class=\"wp-block-list\">\n<li>\uae30\ub2a5 \uc815\uc758: \ud3d0\uae30\uc728 \uc704\uc8fc\uc758 \uc218\ub3d9\uc801\uc778 \ubd84\uc11d\uc5d0\uc11c \ud0c8\ud53c\ud558\uc5ec, \ud310\ub9e4\uc728 \uc911\uc2ec\uc758 \ub2a5\ub3d9\uc801\uc778 \uacbd\uc601 \uc9c0\ud45c\ub97c \uc81c\uacf5.<\/li>\n\n\n\n<li>\ud575\uc2ec \uc9c0\ud45c: \uc0c1\ud488\ubcc4\ub85c <strong>[\uc785\uace0\ub7c9 \/ \ud310\ub9e4\ub7c9 \/ \ud310\ub9e4\uc728]<\/strong>\uc744 \ud55c\ub208\uc5d0 \ubcfc \uc218 \uc788\ub3c4\ub85d \ud14c\uc774\ube14\uc744 \uad6c\uc131<\/li>\n\n\n\n<li>\ub370\uc774\ud130 \ub85c\uc9c1:\n<ul class=\"wp-block-list\">\n<li><code>ORDER BY sales_rate DESC<\/code> \ucffc\ub9ac\ub97c \uc801\uc6a9\ud558\uc5ec \uac00\uc7a5 \uc798 \ud314\ub9ac\ub294 \uc778\uae30 \uc0c1\ud488\uc774 \uc0c1\ub2e8\uc5d0 \ubc30\uce58\ub418\ub3c4\ub85d \uad6c\ud604.<\/li>\n\n\n\n<li>\uc774\ub97c \ud1b5\ud574 \uc810\uc8fc\uac00 \uacb0\ud488(\ud488\uc808) \uac00\ub2a5\uc131\uc744 \uc0ac\uc804\uc5d0 \ud30c\uc545\ud558\uace0 \ubc1c\uc8fc\ub7c9\uc744 \uc720\uc5f0\ud558\uac8c \uc870\uc808\ud560 \uc218 \uc788\ub294 \uc758\uc0ac\uacb0\uc815 \uadfc\uac70\ub97c \ub9c8\ub828.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\ubaa8\ubc14\uc77c \ucd5c\uc801\ud654 \ubc0f UI \uace0\ub3c4\ud654<\/strong>\n<ul class=\"wp-block-list\">\n<li>\uc0ac\uc774\ub4dc\ubc14 \ub0b4\ube44\uac8c\uc774\uc158: \ubc84\ud2bc\uc2dd \ub124\ube44\uac8c\uc774\uc158\uc744 \ub3c4\uc785\ud558\uc5ec \uc881\uc740 \ubaa8\ubc14\uc77c \ud654\uba74\uc5d0\uc11c\ub3c4 \uac80\uc218, \ud310\ub9e4, \ubd84\uc11d \uba54\ub274\ub97c \ud3b8\ub9ac\ud558\uac8c \uc774\ub3d9\ud560 \uc218 \uc788\ub3c4\ub85d \uac1c\uc120.<\/li>\n\n\n\n<li>\ub9ac\uc18c\uc2a4 \ucd5c\uc801\ud654: \ubd84\uc11d \ubc0f \uc54c\ub9bc \ud398\uc774\uc9c0 \ub4f1 \uce74\uba54\ub77c\uac00 \ud544\uc694 \uc5c6\ub294 \uad6c\uac04\uc5d0\uc11c\ub294 QR \uc2a4\uce90\ub108\ub97c \uc790\ub3d9\uc73c\ub85c \uc815\uc9c0\uc2dc\ucf1c \uc2a4\ub9c8\ud2b8\ud3f0\uc758 \ubc1c\uc5f4\uacfc \ubc30\ud130\ub9ac \uc18c\ubaa8\ub97c \ucd5c\uc18c\ud654\ud588\uc2b5\ub2c8\ub2e4.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\uc2e4\ubb34 \uc2dc\ub098\ub9ac\uc624 \ud14c\uc2a4\ud2b8 \uacb0\uacfc<\/strong><\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"220\" src=\"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151002\/wp-content\/uploads\/sites\/95\/2026\/03\/unnamed.png\" alt=\"\" class=\"wp-image-31\" srcset=\"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151002\/wp-content\/uploads\/sites\/95\/2026\/03\/unnamed.png 512w, https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151002\/wp-content\/uploads\/sites\/95\/2026\/03\/unnamed-300x129.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"220\" src=\"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151002\/wp-content\/uploads\/sites\/95\/2026\/03\/unnamed-1.png\" alt=\"\" class=\"wp-image-32\" srcset=\"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151002\/wp-content\/uploads\/sites\/95\/2026\/03\/unnamed-1.png 512w, https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151002\/wp-content\/uploads\/sites\/95\/2026\/03\/unnamed-1-300x129.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/figure>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"has-large-font-size\"><strong>2. \ud5a5\ud6c4 \uacc4\ud68d<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\ub9e4\ucd9c\uc561 \ud1b5\uacc4 \uae30\ub2a5: \ud310\ub9e4\ub41c \uc0c1\ud488\uc758 \uac00\uaca9 \ub370\uc774\ud130\ub97c \uacb0\ud569\ud558\uc5ec &#8216;\uc77c\uc77c \ucd1d \ub9e4\ucd9c\uc561&#8217; \uc9d1\uacc4 \uae30\ub2a5 \ucd94\uac00.<\/li>\n\n\n\n<li>\ub370\uc774\ud130 \uc2dc\uac01\ud654: \ud14c\uc774\ube14 \ud615\ud0dc\uc758 \ub9ac\ud3ec\ud2b8\ub97c \ub118\uc5b4\uc11c \ucc28\ud2b8\ub97c \ud65c\uc6a9\ud55c \uc2dc\uac01\uc801 \ub300\uc2dc\ubcf4\ub4dc \uac80\ud1a0.<\/li>\n<\/ul>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>\ud504\ub85c\uc81d\ud2b8\uba85: FF POS<\/p>\n","protected":false},"author":67,"featured_media":31,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-30","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-3"],"jetpack_featured_media_url":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151002\/wp-content\/uploads\/sites\/95\/2026\/03\/unnamed.png","_links":{"self":[{"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151002\/wp-json\/wp\/v2\/posts\/30","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151002\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151002\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151002\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151002\/wp-json\/wp\/v2\/comments?post=30"}],"version-history":[{"count":3,"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151002\/wp-json\/wp\/v2\/posts\/30\/revisions"}],"predecessor-version":[{"id":57,"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151002\/wp-json\/wp\/v2\/posts\/30\/revisions\/57"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151002\/wp-json\/wp\/v2\/media\/31"}],"wp:attachment":[{"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151002\/wp-json\/wp\/v2\/media?parent=30"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151002\/wp-json\/wp\/v2\/categories?post=30"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/infognu.ansan.ac.kr\/PortFolio\/202151002\/wp-json\/wp\/v2\/tags?post=30"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}