Category: TOOLS

LOGO CARI BANKA HESAP NO DOVIZE GORE AL FONKSIYONU

On By semt20In TOOLSLeave a comment 
CREATE FUNCTION BMSF_120_MM_GETHESAPNOFROMCLCARD (@CARIKOD varchar(17) ,
@PARACINSI varchar (3))
returns VARCHAR( 255)
BEGIN
declare @HESAPNO VARCHAR( 255) ;
declare @PARACINSITONR int=(CASE
WHEN @PARACINSI='TL' then 0
WHEN @PARACINSI='USD' then 1
WHEN @PARACINSI='GBP' then 17
when @PARACINSI='EUR' then 20
ELSE 160 END)
set @HESAPNO = (SELECT CASE 
WHEN LEN(H1)>2 AND RIGHT(H1,2)=@PARACINSITONR THEN BANKACCOUNTS1 
WHEN LEN(H2)>2 AND RIGHT(H2,2)=@PARACINSITONR THEN BANKACCOUNTS2 
WHEN LEN(H3)>2 AND RIGHT(H3,2)=@PARACINSITONR THEN BANKACCOUNTS3 
WHEN LEN(H4)>2 AND RIGHT(H4,2)=@PARACINSITONR THEN BANKACCOUNTS4 
WHEN LEN(H5)>2 AND RIGHT(H5,2)=@PARACINSITONR THEN BANKACCOUNTS5 
WHEN LEN(H6)>2 AND RIGHT(H6,2)=@PARACINSITONR THEN BANKACCOUNTS6 
WHEN LEN(H7)>2 AND RIGHT(H7,2)=@PARACINSITONR THEN BANKACCOUNTS7
ELSE '' END FROM (
SELECT 
C.BANKACCOUNTS1+CASE WHEN LEN(CAST(C.DBSBANKCURRENCY1 AS VARCHAR))=1 THEN '0'+CAST(C.DBSBANKCURRENCY1 AS VARCHAR) ELSE CAST(C.DBSBANKCURRENCY1 AS VARCHAR) END H1,
C.BANKACCOUNTS2+CASE WHEN LEN(CAST(C.DBSBANKCURRENCY2 AS VARCHAR))=1 THEN '0'+CAST(C.DBSBANKCURRENCY2 AS VARCHAR) ELSE CAST(C.DBSBANKCURRENCY2 AS VARCHAR) END H2,
C.BANKACCOUNTS3+CASE WHEN LEN(CAST(C.DBSBANKCURRENCY3 AS VARCHAR))=1 THEN '0'+CAST(C.DBSBANKCURRENCY3 AS VARCHAR) ELSE CAST(C.DBSBANKCURRENCY3 AS VARCHAR) END H3,
C.BANKACCOUNTS4+CASE WHEN LEN(CAST(C.DBSBANKCURRENCY4 AS VARCHAR))=1 THEN '0'+CAST(C.DBSBANKCURRENCY4 AS VARCHAR) ELSE CAST(C.DBSBANKCURRENCY4 AS VARCHAR) END H4,
C.BANKACCOUNTS5+CASE WHEN LEN(CAST(C.DBSBANKCURRENCY5 AS VARCHAR))=1 THEN '0'+CAST(C.DBSBANKCURRENCY5 AS VARCHAR) ELSE CAST(C.DBSBANKCURRENCY5 AS VARCHAR) END H5,
C.BANKACCOUNTS6+CASE WHEN LEN(CAST(C.DBSBANKCURRENCY6 AS VARCHAR))=1 THEN '0'+CAST(C.DBSBANKCURRENCY6 AS VARCHAR) ELSE CAST(C.DBSBANKCURRENCY6 AS VARCHAR) END H6,
C.BANKACCOUNTS7+CASE WHEN LEN(CAST(C.DBSBANKCURRENCY7 AS VARCHAR))=1 THEN '0'+CAST(C.DBSBANKCURRENCY7 AS VARCHAR) ELSE CAST(C.DBSBANKCURRENCY7 AS VARCHAR) END H7,
C.BANKACCOUNTS1,C.BANKACCOUNTS2,C.BANKACCOUNTS3,C.BANKACCOUNTS4,C.BANKACCOUNTS5,C.BANKACCOUNTS6,C.BANKACCOUNTS7
FROM LG_101_CLCARD C
WHERE C.CODE=@CARIKOD ) AS T)
RETURN @HESAPNO
END

--SELECT dbo.BMSF_120_MM_GETHESAPNOFROMCLCARD('KK000855510','EUR')

Flutter json to dart

On By semt20In TOOLSLeave a comment

flutter json dart diline çevirmek için;
1-jsonu bu siteye yapıştır: app.quicktype.io sağ tarafta language dart olmasına dikkat et (https://youtu.be/wc8ecFSu5N8)

2-pubspece dev_dependencisin altına json_model , build_runner , json_serializable (https://youtu.be/KsZQQK1HOu8?t=119) asdasd libin altında jsons klasorunun içinde json içeriğini yapıştır ör(cari.json) ve command pallette çalıştır: flutter packages pub run json_model video: https://youtu.be/KsZQQK1HOu8

logo paytrans to branch

On By semt20In TOOLSLeave a comment 
USE [YAR2016]
GO

/****** Object:  View [dbo].[BM_301_PAYTRANSTOBRANCH]    Script Date: 06.07.2020 13:11:37 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[BM_301_PAYTRANSTOBRANCH] AS

SELECT TOP 100 PERCENT
LGMAIN.LOGICALREF,
        CASE LGMAIN.MODULENR WHEN 7 THEN BTRNS.BRANCH WHEN 4 THEN INVFC.BRANCH WHEN 5 THEN CTRNS.BRANCH
        WHEN 6 THEN  RLFIC.BRANCH WHEN 3 THEN ORFIC.BRANCH WHEN 10 THEN CASHTR.BRANCH
        WHEN 61 THEN CTRNS.BRANCH WHEN 62 THEN CTRNS.BRANCH ELSE '' END [İşyeri Kodu]

 FROM 
LG_301_01_PAYTRANS LGMAIN WITH(NOLOCK)               
LEFT OUTER JOIN LG_301_01_INVOICE INVFC WITH(NOLOCK) ON (LGMAIN.FICHEREF  =  INVFC.LOGICALREF) 
LEFT OUTER JOIN LG_301_01_CLFLINE CTRNS WITH(NOLOCK) ON (LGMAIN.FICHEREF  =  CTRNS.LOGICALREF) 
LEFT OUTER JOIN LG_301_01_CSROLL RLFIC WITH(NOLOCK) ON (LGMAIN.FICHEREF  =  RLFIC.LOGICALREF) 
LEFT OUTER JOIN LG_301_01_BNFLINE BTRNS WITH(NOLOCK) ON (LGMAIN.FICHEREF  =  BTRNS.LOGICALREF) 
LEFT OUTER JOIN LG_301_01_KSLINES CASHTR WITH(NOLOCK) ON (LGMAIN.FICHEREF  =  CASHTR.LOGICALREF) 
LEFT OUTER JOIN LG_301_01_ORFICHE ORFIC WITH(NOLOCK) ON (LGMAIN.FICHEREF  =  ORFIC.LOGICALREF)
 WHERE 
 
((((LGMAIN.MODULENR=3 AND
((ORFIC.BRANCH NOT IN (-2))))AND
(ORFIC.CANCELLED=0))OR((LGMAIN.MODULENR=4 AND
((INVFC.BRANCH NOT IN  (-2))))AND
(INVFC.CANCELLED=0))OR((LGMAIN.MODULENR IN (5,61,62) AND
((CTRNS.BRANCH NOT IN  (-2))))AND
(CTRNS.CANCELLED=0))OR((LGMAIN.MODULENR=6 AND
((RLFIC.BRANCH NOT IN  (-2))))AND
(RLFIC.CANCELLED=0))OR((LGMAIN.MODULENR=7 AND
((BTRNS.BRANCH NOT IN  (-2))))AND
(BTRNS.CANCELLED=0))OR((LGMAIN.MODULENR=10 AND
((CASHTR.BRANCH NOT IN  (-2))))AND(CASHTR.CANCELLED=0)))) AND (LGMAIN.TOTAL - LGMAIN.PAID > 0) AND (LGMAIN.PAIDINCASH = 0)
 
GO

C# LOGO OBJECTS REST PROJESİ

On By semt20In TOOLSLeave a comment

C# KISMINDA EĞER HERHANGİ BİR OBJECTIN CLASSI GEREKIRSE ONCE LOGODAN VERI AKTAR DIŞARI YAPILIR VE DOSYANIN İÇİNDEKİLER ÖNCE

http://www.utilities-online.info/xmltojson/ YAPIŞTIRILIP JSONA ÇEVİRİLİR KOPYALANIR VE https://jsonutils.com/ ‘A YAPIŞTIRILIP C# DA CLASS OLUŞTURULUR

EĞER TRANSACTIONLI BİRŞEY VARSA CLASSI DEĞİŞTİRMEK GEREKİR ALTTAKİ ÖRNEKLERDE ÖNCESİ VE SONRASI YANİ OLMASI GEREKENLER(SATIŞSİPARİŞİ İÇİN)

http://localhost:32001/api/v1/services/help?expandLevel=full&api_key=logotigerrestservice

ÖNCESİ

    public class CAMPAIGNINFOS
    {
        public object CAMPAIGN_INFO { get; set; }
    }

    public class TRANSACTION {
        public string TYPE { get; set; }
        public string MASTER_CODE { get; set; }
        public string QUANTITY { get; set; }
        public string PRICE { get; set; }
        public string TOTAL { get; set; }
        public string COST_DISTR { get; set; }
        public string DISCOUNT_DISTR { get; set; }
        public string EXPENSE_DISTR { get; set; }
        public string VAT_RATE { get; set; }
        public string VAT_AMOUNT { get; set; }
        public string VAT_BASE { get; set; }
        public string UNIT_CODE { get; set; }
        public string UNIT_CONV1 { get; set; }
        public string UNIT_CONV2 { get; set; }
        public string VAT_INCLUDED { get; set; }
        public string ORDER_RESERVE { get; set; }
        public string DUE_DATE { get; set; }
        public string CURR_PRICE { get; set; }
        public string PC_PRICE { get; set; }
        public string PAYMENT_CODE { get; set; }
        public string SOURCE_WH { get; set; }
        public string SOURCE_COST_GRP { get; set; }
        public string DIVISION { get; set; }
        public string DEPARTMENT { get; set; }
        public string TOTAL_NET { get; set; }
        public string DATA_REFERENCE { get; set; }
        public string DETAILS { get; set; }
        public CAMPAIGNINFOS CAMPAIGN_INFOS { get; set; }
        public string SALESMAN_CODE { get; set; }
        public string DEFNFLDS { get; set; }
        public string MULTI_ADD_TAX { get; set; }
        public string AFFECT_RISK { get; set; }
        public string EDT_PRICE { get; set; }
        public string EDT_CURR { get; set; }
        public string ORG_DUE_DATE { get; set; }
        public string ORG_QUANTITY { get; set; }
        public string ORG_PRICE { get; set; }
        public string RESERVE_DATE { get; set; }
        public string RESERVE_AMOUNT { get; set; }
        public string PRCLISTCODE { get; set; }
        public string PRCLISTTYPE { get; set; }
        public string PRODUCER_CODE { get; set; }
        public string GUID { get; set; }
        public string DISCOUNT_RATE { get; set; }
        public string DETAIL_LEVEL { get; set; }
        public string CALC_TYPE { get; set; }
    }

    public class TRANSACTIONS{	
								   
										 
			 
	     public IList<TRANSACTION> TRANSACTION { get; set; }										 
    }

    public class PAYMENT {
        public string DATE { get; set; }
        public string MODULENR { get; set; }
        public string TRCODE { get; set; }
        public string TOTAL { get; set; }
        public string DAYS { get; set; }
        public string PROCDATE { get; set; }
        public string DATA_REFERENCE { get; set; }
        public string DISCOUNT_DUEDATE { get; set; }
        public string PAY_NO { get; set; }
        public string DISCTRLIST { get; set; }
        public string DISCTRDELLIST { get; set; }
    }

    public class PAYMENTLIST {
        public PAYMENT PAYMENT { get; set; }
    }

    public class DEFNFLD {
        public string MODULENR { get; set; }
        public string PARENTREF { get; set; }
        public string TEXTFLDS1 { get; set; }
        public string TEXTFLDS3 { get; set; }
        public string XML_ATTRIBUTE { get; set; }
        public string DATA_REFERENCE { get; set; }
    }

    public class DEFNFLDSLIST {
        public DEFNFLD DEFNFLD { get; set; }
    }

															  
															   
																 
														   
		 
    public class ORDERSLIP {
        public string -DBOP { get; set; }
								
												  
																
			 
        public string NUMBER { get; set; }
        public string DATE { get; set; }
        public string TIME { get; set; }
        public string DOC_NUMBER { get; set; }
        public string ARP_CODE { get; set; }
        public string SOURCE_WH { get; set; }
        public string SOURCE_COST_GRP { get; set; }
        public string #text { get; set; }
        public string ADD_DISCOUNTS { get; set; }
        public string TOTAL_DISCOUNTS { get; set; }
        public string TOTAL_DISCOUNTED { get; set; }
        public string ADD_EXPENSES { get; set; }
        public string TOTAL_EXPENSES { get; set; }
        public string TOTAL_VAT { get; set; }
        public string TOTAL_GROSS { get; set; }
        public string TOTAL_NET { get; set; }
        public string PAYMENT_CODE { get; set; }
        public string PAYDEFREF { get; set; }
        public string PRINT_DATE { get; set; }
        public string DIVISION { get; set; }
        public string DEPARTMENT { get; set; }
        public string ORDER_STATUS { get; set; }
        public string CREATED_BY { get; set; }
        public string DATE_CREATED { get; set; }
        public string HOUR_CREATED { get; set; }
        public string MIN_CREATED { get; set; }
        public string SEC_CREATED { get; set; }
        public string MODIFIED_BY { get; set; }
        public string DATE_MODIFIED { get; set; }
        public string HOUR_MODIFIED { get; set; }
        public string MIN_MODIFIED { get; set; }
        public string SEC_MODIFIED { get; set; }
        public string SALESMAN_CODE { get; set; }
        public string CURRSEL_TOTAL { get; set; }
        public string TRADING_GRP { get; set; }
        public string DATA_REFERENCE { get; set; }
        public TRANSACTIONS TRANSACTIONS { get; set; }
        public string WITH_PAYMENT { get; set; }
        public PAYMENTLIST PAYMENT_LIST { get; set; }
        public DEFNFLDSLIST DEFNFLDSLIST { get; set; }
        public string UPD_CURR { get; set; }
        public string UPD_TRCURR { get; set; }
        public string AFFECT_RISK { get; set; }
        public string GUID { get; set; }
    }

    public class SALESORDERS {
        public ORDERSLIP ORDER_SLIP { get; set; }
    }

    public class MAIN {
        public SALESORDERS SALES_ORDERS { get; set; }
    }

SONRASI

   public class CAMPAIGNINFOS {
	 
            public object CAMPAIGN_INFO { get; set; }
        }

        public class Item {
            public string TYPE { get; set; }
            public string MASTER_CODE { get; set; }
            public string QUANTITY { get; set; }
            public string PRICE { get; set; }
            public string TOTAL { get; set; }
            public string COST_DISTR { get; set; }
            public string DISCOUNT_DISTR { get; set; }
            public string EXPENSE_DISTR { get; set; }
            public string VAT_RATE { get; set; }
            public string VAT_AMOUNT { get; set; }
            public string VAT_BASE { get; set; }
            public string UNIT_CODE { get; set; }
            public string UNIT_CONV1 { get; set; }
            public string UNIT_CONV2 { get; set; }
            public string VAT_INCLUDED { get; set; }
            public string ORDER_RESERVE { get; set; }
            public string DUE_DATE { get; set; }
            public string CURR_PRICE { get; set; }
            public string PC_PRICE { get; set; }
            public string PAYMENT_CODE { get; set; }
            public string SOURCE_WH { get; set; }
            public string SOURCE_COST_GRP { get; set; }
            public string DIVISION { get; set; }
            public string DEPARTMENT { get; set; }
            public string TOTAL_NET { get; set; }
            public string DATA_REFERENCE { get; set; }
            public string DETAILS { get; set; }
            public CAMPAIGNINFOS CAMPAIGN_INFOS { get; set; }
            public string SALESMAN_CODE { get; set; }
            public string DEFNFLDS { get; set; }
            public string MULTI_ADD_TAX { get; set; }
            public string AFFECT_RISK { get; set; }
            public string EDT_PRICE { get; set; }
            public string EDT_CURR { get; set; }
            public string ORG_DUE_DATE { get; set; }
            public string ORG_QUANTITY { get; set; }
            public string ORG_PRICE { get; set; }
            public string RESERVE_DATE { get; set; }
            public string RESERVE_AMOUNT { get; set; }
            public string PRCLISTCODE { get; set; }
            public string PRCLISTTYPE { get; set; }
            public string PRODUCER_CODE { get; set; }
            public string GUID { get; set; }
            public string DISCOUNT_RATE { get; set; }
            public string DETAIL_LEVEL { get; set; }
            public string CALC_TYPE { get; set; }
        }

        public class TRANSACTIONS{
            public TRANSACTIONS() {
                items = new List<Item>();
            }
            public IList<Item> items { get; set; }
        }

        public class PAYMENT {
            public string DATE { get; set; }
            public string MODULENR { get; set; }
            public string TRCODE { get; set; }
            public string TOTAL { get; set; }
            public string DAYS { get; set; }
            public string PROCDATE { get; set; }
            public string DATA_REFERENCE { get; set; }
            public string DISCOUNT_DUEDATE { get; set; }
            public string PAY_NO { get; set; }
            public string DISCTRLIST { get; set; }
            public string DISCTRDELLIST { get; set; }
        }

        public class PAYMENTLIST {
            public PAYMENT PAYMENT { get; set; }
        }

        public class DEFNFLD {
            public string MODULENR { get; set; }
            public string PARENTREF { get; set; }
            public string TEXTFLDS1 { get; set; }
            public string TEXTFLDS3 { get; set; }
            public string XML_ATTRIBUTE { get; set; }
            public string DATA_REFERENCE { get; set; }
        }

        public class DEFNFLDSLIST {
            public DEFNFLD DEFNFLD { get; set; }
        }
        public class DataObjectParameter {
            //public bool ApplyCampaignOnPreSave { get; set; }
            //public bool ApplyConditionOnPreSave { get; set; }
            //public bool FormSeriLotLinesOnPreSave { get; set; }
            public bool FillAccCodesOnPreSave { get; set; }
        }
        public class ORDERSLIP {
            public DataObjectParameter DataObjectParameter { get; set; }
            public ORDERSLIP() {
                TRANSACTIONS = new TRANSACTIONS();
                DataObjectParameter = new DataObjectParameter();
            }
            public string NUMBER { get; set; }
            public string DATE { get; set; }
            public string TIME { get; set; }
            public string DOC_NUMBER { get; set; }
            public string ARP_CODE { get; set; }
            public string SOURCE_WH { get; set; }
            public string SOURCE_COST_GRP { get; set; }
										 
            public string ADD_DISCOUNTS { get; set; }
            public string TOTAL_DISCOUNTS { get; set; }
            public string TOTAL_DISCOUNTED { get; set; }
            public string ADD_EXPENSES { get; set; }
            public string TOTAL_EXPENSES { get; set; }
            public string TOTAL_VAT { get; set; }
            public string TOTAL_GROSS { get; set; }
            public string TOTAL_NET { get; set; }
            public string PAYMENT_CODE { get; set; }
            public string PAYDEFREF { get; set; }
            public string PRINT_DATE { get; set; }
            public string DIVISION { get; set; }
            public string DEPARTMENT { get; set; }
            public string ORDER_STATUS { get; set; }
            public string CREATED_BY { get; set; }
            public string DATE_CREATED { get; set; }
            public string HOUR_CREATED { get; set; }
            public string MIN_CREATED { get; set; }
            public string SEC_CREATED { get; set; }
            public string MODIFIED_BY { get; set; }
            public string DATE_MODIFIED { get; set; }
            public string HOUR_MODIFIED { get; set; }
            public string MIN_MODIFIED { get; set; }
            public string SEC_MODIFIED { get; set; }
            public string SALESMAN_CODE { get; set; }
            public string CURRSEL_TOTAL { get; set; }
            public string TRADING_GRP { get; set; }
            public string DATA_REFERENCE { get; set; }
            public TRANSACTIONS TRANSACTIONS { get; set; }
            public string WITH_PAYMENT { get; set; }
            public PAYMENTLIST PAYMENT_LIST { get; set; }
            public DEFNFLDSLIST DEFNFLDSLIST { get; set; }
            public string UPD_CURR { get; set; }
            public string UPD_TRCURR { get; set; }
            public string AFFECT_RISK { get; set; }
            public string GUID { get; set; }
        }

        public class SALESORDERS {
            public ORDERSLIP ORDER_SLIP { get; set; }
        }

        public class MAIN {
            public SALESORDERS SALES_ORDERS { get; set; }
        }
    }