{"id":218,"date":"2014-09-10T11:59:45","date_gmt":"2014-09-10T08:59:45","guid":{"rendered":"http:\/\/www.ozgurguler.net\/?p=218"},"modified":"2014-09-16T13:12:15","modified_gmt":"2014-09-16T10:12:15","slug":"kampanya-kartlarinda-sqlinfo-kullanimi","status":"publish","type":"post","link":"https:\/\/www.ozgurguler.net\/blog\/kampanya-kartlarinda-sqlinfo-kullanimi\/","title":{"rendered":"Kampanya Kartlar\u0131nda SQLINFO Kullan\u0131m\u0131"},"content":{"rendered":"
\n

Kampanya Kartlar\u0131nda SQLINFO Kullan\u0131m\u0131<\/a><\/h2>\n

 <\/p>\n

<\/div>\n<\/div>\n

<\/p>\n\n\n\n
Kampanya kart\u0131 i\u00e7erisinde olmayan alanlar yada ba\u015fka bir tabloda de\u011fer getirmek i\u00e7in SQLINFO fonksiyonu kullan\u0131labilir.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\u00d6rnek : Sipari\u015f yada Fatura i\u00e7erisinde birden fazla malzemeye ayn\u0131 indirimi yapmak i\u00e7in SQLINFO fonksiyonu kullan\u0131lmas\u0131.Malzeme Kodu\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Malzeme Ad\u0131\u00a0\u00a0\u00a0<\/strong>———————-\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0———————-<\/strong><\/p>\n

PG.001\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0A<\/p>\n

PG.002\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 B<\/p>\n

PG.003\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0C<\/p>\n

PG.004\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 D<\/p>\n

PG.005\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0 E<\/p>\n

 <\/p>\n

MS Kodu\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 MS A\u00e7\u0131klamas\u0131<\/strong><\/p>\n

———————-\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ———————-<\/strong><\/p>\n

PG\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PG<\/p>\n

 <\/td>\n<\/tr>\n

\"kampanyasql01\"<\/td>\n<\/tr>\n
Ortak kampanya uygulanacak malzeme kartlar\u0131 Malzeme s\u0131n\u0131f\u0131 a\u00e7\u0131larak ba\u011flant\u0131 yap\u0131lmal\u0131d\u0131r.<\/td>\n<\/tr>\n
MALZEME \u2013 MALZEME SINIF BA\u00d0LANTISINI LISTELEYEN QUERY<\/strong>SELECTCOUNT(*)<\/p>\n

FROM<\/p>\n

LG_010_ITEMS I (NOLOCK)<\/p>\n

LEFT OUTER JOIN<\/p>\n

LG_010_ITMCLSAS C (NOLOCK) ON I.LOGICALREF=C.CHILDREF AND C.UPLEVEL=0<\/p>\n

LEFT OUTER JOIN<\/p>\n

LG_010_ITEMS S (NOLOCK) ON C.PARENTREF=S.LOGICALREF<\/p>\n

WHERE<\/p>\n

I.CODE LIKE ‘PG.001’<\/p>\n

AND S.CODE LIKE ‘PG’<\/p>\n

 <\/p>\n

\u00a0<\/strong>QUERY\u2019 NIN FONKS\u0130YON HAL\u0130NE GET\u0130R\u0130LMES\u0130<\/strong><\/p>\n

 <\/p>\n

CREATE FUNCTION [dbo].[FN_MS_KAMPANYA_010] (@MALZ VARCHAR(21), @SINIF VARCHAR(21))<\/p>\n

RETURNS FLOAT<\/p>\n

AS<\/p>\n

BEGIN<\/p>\n

DECLARE @LG_FN_LINETOPLAM FLOAT<\/p>\n

 <\/p>\n

SET @LG_FN_LINETOPLAM=(<\/p>\n

SELECT<\/p>\n

COUNT(*)<\/p>\n

FROM<\/p>\n

LG_010_ITEMS I (NOLOCK)<\/p>\n

LEFT OUTER JOIN LG_010_ITMCLSAS C (NOLOCK) ON I.LOGICALREF=C.CHILDREF AND C.UPLEVEL=0<\/p>\n

LEFT OUTER JOIN<\/p>\n

LG_010_ITEMS S (NOLOCK) ON C.PARENTREF=S.LOGICALREF<\/p>\n

WHERE<\/p>\n

I.CODE LIKE @MALZ+’%’<\/p>\n

AND S.CODE LIKE @SINIF+’%’\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/p>\n

)<\/p>\n

;<\/p>\n

RETURN(@LG_FN_LINETOPLAM)<\/p>\n

END<\/p>\n

 <\/p>\n

Not :<\/strong> Fonksiyon SQL\u2019 de bir kez \u00e7al\u0131\u015ft\u0131r\u0131larak sql taraf\u0131na fonksiyon olarak eklenmesi sa\u011flanmal\u0131d\u0131r.<\/p>\n

 <\/p>\n

FONKS\u0130YON\u2019 UN QUERY \u0130LE \u00c7ALI\u015eTIRILMASI<\/strong><\/p>\n

SELECT DBO.FN_MS_KAMPANYA_010(‘PG.004′,’PG’) FROM L_CAPIFIRM WHERE NR=10<\/p>\n

 <\/p>\n

FONKS\u0130YON\u2019 UN SQLINFO HAL\u0130NE GET\u0130R\u0130LMES\u0130<\/strong><\/p>\n

VAL(_SQLINFO(“DBO.FN_MS_KAMPANYA_010(‘”+P101+”‘,’PG’)”,”L_CAPIFIRM”,”NR=10″))<\/td>\n<\/tr>\n

\"kampanyasql02\"<\/td>\n<\/tr>\n
Kampanya kart\u0131 i\u00e7erisinde SQLINFO fonksiyonunun kullan\u0131lmas\u0131P101 :<\/strong> Malzeme Kodu bilgisidir.Ko\u015ful alan\u0131nda IF(V5>0,1,0) fonksiyonu kullan\u0131larak V5<\/strong> de\u011fi\u015fkeninden 1 de\u011feri d\u00f6nd\u00fc\u011f\u00fc zaman kampanya uygulanmas\u0131 sa\u011flanmaktad\u0131r.V5 de\u011fi\u015fkeni i\u00e7erisinde bulunan PG<\/strong>\u00a0 alan\u0131 yerine malzemelerin ba\u011fl\u0131 bulundu\u011fu kampanya uygulanacak \u00fcst malzeme s\u0131n\u0131f kodu belirtilmelidir<\/td>\n<\/tr>\n
\"kampanyasql03\"<\/td>\n<\/tr>\n
Fatura i\u00e7erisinde kampanya uyguland\u0131\u011f\u0131 zaman;<\/td>\n<\/tr>\n
\"kampanyasql04\"<\/td>\n<\/tr>\n
\u015feklinde listelenmektedir.<\/td>\n<\/tr>\n
<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

Kampanya Kartlar\u0131nda SQLINFO Kullan\u0131m\u0131  <\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-218","post","type-post","status-publish","format-standard","hentry","category-logo-genel-destek"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/218","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=218"}],"version-history":[{"count":4,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/218\/revisions"}],"predecessor-version":[{"id":249,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/218\/revisions\/249"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}