16-06-2021, Saat: 17:07
Merhaba,
Firebird içindir!
Aşağıdaki SP ile girilen kimlik numarasının validasyon kontrolü yapılarak doğru ise sonucu 1 yanlış ise 0 döndürmektedir.
İyi Çalışmalar.
Kullanımı;
Firebird içindir!
Aşağıdaki SP ile girilen kimlik numarasının validasyon kontrolü yapılarak doğru ise sonucu 1 yanlış ise 0 döndürmektedir.
İyi Çalışmalar.
create or alter procedure SP_KIMLIKNO_VALIDASYON ( PI_KIMLIKNO varchar(25) not null collate PXW_TURK) returns ( RESULT smallint) as declare variable N smallint; declare variable KONTROL varchar(25); declare variable SONUC varchar(11) collate PXW_TURK; declare variable S1 varchar(1) collate PXW_TURK; declare variable S2 varchar(1) collate PXW_TURK; declare variable S3 varchar(1) collate PXW_TURK; declare variable S4 varchar(1) collate PXW_TURK; declare variable S5 varchar(1) collate PXW_TURK; declare variable S6 varchar(1) collate PXW_TURK; declare variable S7 varchar(1) collate PXW_TURK; declare variable S8 varchar(1) collate PXW_TURK; declare variable S9 varchar(1) collate PXW_TURK; declare variable S10 varchar(1) collate PXW_TURK; declare variable Q1 varchar(1) collate PXW_TURK; declare variable Q2 varchar(1) collate PXW_TURK; declare variable Q3 varchar(1) collate PXW_TURK; declare variable Q4 varchar(1) collate PXW_TURK; declare variable Q5 varchar(1) collate PXW_TURK; declare variable Q6 varchar(1) collate PXW_TURK; declare variable Q7 varchar(1) collate PXW_TURK; declare variable Q9 varchar(1) collate PXW_TURK; declare variable Q8 varchar(1) collate PXW_TURK; declare variable S11 varchar(1) collate PXW_TURK; declare variable TOPLAM smallint; begin KONTROL=''; RESULT=0; N=1; WHILE (N <= CHAR_LENGTH(PI_KIMLIKNO)) DO BEGIN S1 = SUBSTRING( PI_KIMLIKNO FROM N FOR 1 ); IF ((S1 >= '0') AND (S1 <= '9')) THEN KONTROL=KONTROL|| S1; N = N + 1; END -- Gelen veri kontrol ediliyor. Rakam dışındaki verileri temizleyerek sadece rakamlar işleme alınıyor. IF (char_length(KONTROL) = 11) then -- Gerçek Kişi T.C. Kimlik No Kontrolü Begin s1=(substring(:KONTROL from 1 for 1)); s2=(substring(:KONTROL from 2 for 1)); s3=(substring(:KONTROL from 3 for 1)); s4=(substring(:KONTROL from 4 for 1)); s5=(substring(:KONTROL from 5 for 1)); s6=(substring(:KONTROL from 6 for 1)); s7=(substring(:KONTROL from 7 for 1)); s8=(substring(:KONTROL from 8 for 1)); s9=(substring(:KONTROL from 9 for 1)); s10=CAST(MOD((((CAST(S1 AS SMALLINT)+ CAST(S3 AS SMALLINT)+ CAST(S5 AS SMALLINT)+ CAST(S7 AS SMALLINT)+ CAST(S9 AS SMALLINT))*7)-( CAST(S2 AS SMALLINT)+ CAST(S4 AS SMALLINT)+ CAST(S6 AS SMALLINT)+ CAST(S8 AS SMALLINT))),10) as varchar(1)); s11=CAST(MOD((CAST(S1 AS SMALLINT)+ CAST(S2 AS SMALLINT)+ CAST(S3 AS SMALLINT)+ CAST(S4 AS SMALLINT)+ CAST(S5 AS SMALLINT)+ CAST(S6 AS SMALLINT)+ CAST(S7 AS SMALLINT)+ CAST(S8 AS SMALLINT)+ CAST(S9 AS SMALLINT)+ CAST(S10 AS SMALLINT)),10) as varchar(1)); SONUC=s1|| '' ||s2|| '' ||s3|| '' ||s4|| '' ||s5|| '' || s6|| '' ||s7|| '' ||s8|| '' ||s9|| '' ||s10|| '' ||s11; if (SONUC=:KONTROL) then result=1; ELSE RESULT=0; End IF (char_length(KONTROL) = 10) then -- Tüzel Kişi Vergi Kimlik No Kontrolü Begin s1= CAST( MOD(cast((substring(:KONTROL from 1 for 1)) as smallint)+9,10) as varchar(1)); s2= CAST( MOD(cast((substring(:KONTROL from 2 for 1)) as smallint)+8,10) as varchar(1)); s3= CAST( MOD(cast((substring(:KONTROL from 3 for 1)) as smallint)+7,10) as varchar(1)); s4= CAST( MOD(cast((substring(:KONTROL from 4 for 1)) as smallint)+6,10) as varchar(1)); s5= CAST( MOD(cast((substring(:KONTROL from 5 for 1)) as smallint)+5,10) as varchar(1)); s6= CAST( MOD(cast((substring(:KONTROL from 6 for 1)) as smallint)+4,10) as varchar(1)); s7= CAST( MOD(cast((substring(:KONTROL from 7 for 1)) as smallint)+3,10) as varchar(1)); s8= CAST( MOD(cast((substring(:KONTROL from 8 for 1)) as smallint)+2,10) as varchar(1)); s9= CAST( MOD(cast((substring(:KONTROL from 9 for 1)) as smallint)+1,10) as varchar(1)); s10=(substring(:KONTROL from 10 for 1)); if (s1<>'9') then q1=CAST( mod(CAST(S1 AS SMALLINT)*512,9) as varchar(1)); else q1=s1; if (s2<>'9') then q2=CAST( mod(CAST(S2 AS SMALLINT)*256,9) as varchar(1)); else q2=s2; if (s3<>'9') then q3=CAST( mod(CAST(S3 AS SMALLINT)*128,9) as varchar(1)); else q3=s3; if (s4<>'9') then q4=CAST( mod(CAST(S4 AS SMALLINT)*64,9) as varchar(1)); else q4=s4; if (s5<>'9') then q5=CAST( mod(CAST(S5 AS SMALLINT)*32,9) as varchar(1)); else q5=s5; if (s6<>'9') then q6=CAST( mod(CAST(S6 AS SMALLINT)*16,9) as varchar(1)); else q6=s6; if (s7<>'9') then q7=CAST( mod(CAST(S7 AS SMALLINT)*8,9) as varchar(1)); else q7=s7; if (s8<>'9') then q8=CAST( mod(CAST(S8 AS SMALLINT)*4,9) as varchar(1)); else q8=s8; if (s9<>'9') then q9=CAST( mod(CAST(S9 AS SMALLINT)*2,9) as varchar(1)); else q9=s9; n=CAST( 10-MOD((CAST(Q1 AS SMALLINT)+CAST(Q2 AS SMALLINT)+ CAST(Q3 AS SMALLINT)+CAST(Q4 AS SMALLINT)+ CAST(Q5 AS SMALLINT)+CAST(Q6 AS SMALLINT)+ CAST(Q7 AS SMALLINT)+CAST(Q8 AS SMALLINT)+ CAST(Q9 AS SMALLINT) ),10) as smallint); TOPLAM=mod(N-0,10); if (TOPLAM=CAST(S10 AS SMALLINT)) then RESULT=1; ELSE RESULT=0; END suspend; end
Kullanımı;
Select RESULT From SP_KIMLIKNO_VALIDASYON(0000000001)
