===> '.$strSQL.'

'; break; case "PROJE_ARA" : $strSQL=" select amt.proje_id, amt.proje_adi as pro_adi, (SELECT max(trim(initcap(replace((select min(aunvan.adi) from xxdeu.unvan aunvan where aunvan.sinif=p.akad_unv1 and aunvan.unvan=p.akad_unv2)||k.adi,'I','i'))||' '||k.soyadi)) FROM xxper.kisi k, xxper.perskim p WHERE k.tc_kimlik_no=amt.giren_tckimlikno AND k.tc_kimlik_no=p.tc_kimlik_no and p.kurum not in (888,999)) as yi, amt.baslama_ay||'/'||amt.baslama_yil||' - '||amt.bitis_ay||'/'||amt.bitis_yil as tarih, amt.GIREN_TCKIMLIKNO as tc, amt.yarisma_derece, amt.yurtici_yurtdisi, amt.koordinator_ismi, amt.sponsor_kurulus, amt.proje_konusu, amt.baslama_ay, amt.baslama_yil, amt.bitis_ay, amt.bitis_yil, amt.ARAS_DANIS_HIZMET, amt.PROJE_TURU, amt.PROJE_TURU from akd_proje_tanim amt where NVL(amt.web_yayin_evet,'E') = 'E'and lower(replace(amt.proje_adi||' '||amt.proje_konusu||' '||amt.anahtar_sozcuk1||' '||amt.anahtar_sozcuk2,'I','i')) like lower(replace('%$param[KEY]%','I','i')) order by baslama_yil desc"; break; case "PROJE_TC" : $strSQL=" select amt.proje_adi as pro_adi, (SELECT max(trim(initcap(replace((select min(aunvan.adi) from xxdeu.unvan aunvan where aunvan.sinif=p.akad_unv1 and aunvan.unvan=p.akad_unv2)||k.adi,'I','i'))||' '||k.soyadi)) FROM xxper.kisi k, xxper.perskim p WHERE k.tc_kimlik_no=amt.giren_tckimlikno AND k.tc_kimlik_no=p.tc_kimlik_no and p.kurum not in (888,999)) as yi, amt.baslama_ay||'/'||amt.baslama_yil||' - '||amt.bitis_ay||'/'||amt.bitis_yil as tarih, amt.GIREN_TCKIMLIKNO as tc, amt.yarisma_derece, amt.yurtici_yurtdisi, amt.koordinator_ismi, amt.sponsor_kurulus, amt.proje_konusu, amt.baslama_ay, amt.baslama_yil, amt.bitis_ay, amt.bitis_yil, decode(amt.ARAS_DANIS_HIZMET,'A','Research Project','D','consultancy Project','Y','Competition project','H','Service project') as ARAS_DANIS_HIZMET, amt.PROJE_TURU from akd_proje_tanim amt, akd_proje_kisi pk where NVL(amt.web_yayin_evet,'E') = 'E' and pk.proje_id = amt.proje_id and pk.proje_giristar = amt.proje_giristar and trim(pk.projeden_cikis) is null and pk.GIREN_TCKIMLIKNO = amt.GIREN_TCKIMLIKNO and pk.tc_kimlik_no = '$param[TC]' order by baslama_yil desc"; break; case "SERGI_ARA" : $strSQL=" select amt.sergi_adi||decode(kods.kodu,0,null,', '||kods.adi) as ser_adi, amt.sergi_bas_tar||' - '||amt.sergi_bit_tar as tarih, (SELECT max(trim(initcap(replace((select min(aunvan.adi) from xxdeu.unvan aunvan where aunvan.sinif=p.akad_unv1 and aunvan.unvan=p.akad_unv2)||k.adi,'I','i'))||' '||k.soyadi)) FROM xxper.kisi k, xxper.perskim p WHERE k.tc_kimlik_no=amt.tc_kimlik_no AND k.tc_kimlik_no=p.tc_kimlik_no and p.kurum not in (888,999)) as yi, amt.TC_KIMLIK_NO as tc, amt.jurili_sergi, amt.uluslararasi, amt.sergi_mekan, amt.sergi_bas_tar, amt.sergi_bit_tar, amt.eser_sayisi, amt.ulke_kodu, amt.ilce_kodu, amt.il_kodu from akd_sanat_sergi amt, AKD_KOD_SERGI kods where NVL(amt.web_yayin_evet,'E') = 'E' and amt.sergi_bicimi=kods.kodu(+) and lower(replace(amt.sergi_adi||' '||amt.anahtar_sozcuk1||' '||amt.anahtar_sozcuk2||' '||amt.sergi_mekan||' '||amt.sergi_duzenleyen_kurum,'I','i')) like lower(replace('%$param[KEY]%','I','i')) order by sergi_bas_tar desc"; break; case "SERGI_TC" : $strSQL=" select amt.sergi_adi||decode(kods.kodu,0,null,', '||kods.adi) as ser_adi, amt.sergi_bas_tar||' - '||amt.sergi_bit_tar as tarih, (SELECT max(trim(initcap(replace((select min(aunvan.adi) from xxdeu.unvan aunvan where aunvan.sinif=p.akad_unv1 and aunvan.unvan=p.akad_unv2)||k.adi,'I','i'))||' '||k.soyadi)) FROM xxper.kisi k, xxper.perskim p WHERE k.tc_kimlik_no=amt.tc_kimlik_no AND k.tc_kimlik_no=p.tc_kimlik_no and p.kurum not in (888,999)) as yi, amt.TC_KIMLIK_NO as tc, amt.jurili_sergi, amt.uluslararasi, amt.sergi_mekan, amt.sergi_bas_tar, amt.sergi_bit_tar, amt.eser_sayisi, amt.ulke_kodu, amt.ilce_kodu, amt.il_kodu from akd_sanat_sergi amt, AKD_KOD_SERGI kods where NVL(amt.web_yayin_evet,'E') = 'E' and amt.sergi_bicimi=kods.kodu(+) and amt.TC_KIMLIK_NO ='$param[TC]' order by sergi_bas_tar desc"; break; case "TIYATRO_ARA" : $strSQL=" select amt.urun_adi ||decode(kods.kodu,0,null,', '||kods.adi) as tiy_adi, amt.yapim_yili as tarih, (SELECT max(trim(initcap(replace((select min(aunvan.adi) from xxdeu.unvan aunvan where aunvan.sinif=p.akad_unv1 and aunvan.unvan=p.akad_unv2)||k.adi,'I','i'))||' '||k.soyadi)) FROM xxper.kisi k, xxper.perskim p WHERE k.tc_kimlik_no=amt.tc_kimlik_no AND k.tc_kimlik_no=p.tc_kimlik_no and p.kurum not in (888,999)) as yi, amt.yapim_yili, amt.odul_sayisi, amt.satin_alindi, amt.satin_alan_kurum, amt.* from akd_sanat_sinema amt, AKD_KOD_SINEMA kods where NVL(amt.web_yayin_evet,'E') = 'E' and amt.URUN_TIP=kods.kodu(+) and lower(replace(amt.urun_adi||' '||amt.satin_alan_kurum||' '||amt.ilave_aciklama,'I','i')) like lower(replace('%$param[KEY]%','I','i')) order by amt.yapim_yili desc"; break; case "TIYATRO_TC" : $strSQL=" select amt.urun_adi ||decode(kods.kodu,0,null,', '||kods.adi) as tiy_adi, amt.yapim_yili as tarih, (SELECT max(trim(initcap(replace((select min(aunvan.adi) from xxdeu.unvan aunvan where aunvan.sinif=p.akad_unv1 and aunvan.unvan=p.akad_unv2)||k.adi,'I','i'))||' '||k.soyadi)) FROM xxper.kisi k, xxper.perskim p WHERE k.tc_kimlik_no=amt.tc_kimlik_no AND k.tc_kimlik_no=p.tc_kimlik_no and p.kurum not in (888,999)) as yi, amt.TC_KIMLIK_NO as tc, amt.yapim_yili, amt.odul_sayisi, amt.satin_alindi, amt.satin_alan_kurum, (select max(english) from AKD_KOD_SINEMA_GORTIP where kodu=amt.gorev_tip1 and kodu not in ('0','999')) as gorev1, (select max(english) from AKD_KOD_SINEMA_GORTIP where kodu=amt.gorev_tip2 and kodu not in ('0','999')) as gorev2, (select max(english) from AKD_KOD_SINEMA_GORTIP where kodu=amt.gorev_tip3 and kodu not in ('0','999')) as gorev3, (select max(english) from AKD_KOD_SINEMA_GORTIP where kodu=amt.gorev_tip4 and kodu not in ('0','999')) as gorev4, (select max(english) from AKD_KOD_SINEMA_GORTIP where kodu=amt.gorev_tip5 and kodu not in ('0','999')) as gorev5, amt.* from akd_sanat_sinema amt, AKD_KOD_SINEMA kods where NVL(amt.web_yayin_evet,'E') = 'E' and amt.URUN_TIP=kods.kodu(+) and amt.TC_KIMLIK_NO ='$param[TC]' order by amt.yapim_yili desc"; break; case "OPERA_ARA" : $strSQL=" select amt.dinleti_adi||decode(kodd.kodu,0,null,', '||kodd.adi) as muz_adi, amt.seri_bastar as tarih, (SELECT max(trim(initcap(replace((select min(aunvan.adi) from xxdeu.unvan aunvan where aunvan.sinif=p.akad_unv1 and aunvan.unvan=p.akad_unv2)||k.adi,'I','i'))||' '||k.soyadi)) FROM xxper.kisi k, xxper.perskim p WHERE k.tc_kimlik_no=amt.tc_kimlik_no AND k.tc_kimlik_no=p.tc_kimlik_no and p.kurum not in (888,999)) as yi, amt.dinleti_mekan, decode(amt.solist_kull_alet,0,null,s_alet.adi) as alet_adi, amt.dunyada_ilk_seslendirilis, amt.turkiyede_ilk_seslendirilis, amt.yerli_yapim_yorum, amt.seri_bittar, amt.seri_bastar, amt.orkestra_adi, amt.gorevlendiren_kurum_var, amt.gorevlendiren_aciklama, amt.ulke_kodu, amt.ilce_kodu, amt.il_kodu from akd_sanat_muzik amt, KOD_DINLETI_TIP kodd, KOD_SOLIST_ALET s_alet where NVL(amt.web_yayin_evet,'E') = 'E' and amt.DINLETI_TIPI=kodd.kodu(+) and amt.solist_kull_alet=s_alet.kodu(+) and lower(replace(amt.dinleti_adi||' '||amt.dinleti_mekan||' '||amt.orkestra_adi,'I','ı')) like lower(replace('%$param[KEY]%','I','ı')) order by seri_bastar desc"; break; case "OPERA_TC" : $strSQL=" select amt.dinleti_adi||decode(kodd.kodu,0,null,','||kodd.adi) as muz_adi, amt.seri_bastar as tarih, (SELECT max(trim(initcap(replace((select min(aunvan.adi) from xxdeu.unvan aunvan where aunvan.sinif=p.akad_unv1 and aunvan.unvan=p.akad_unv2)||k.adi,'I','ı'))||' '||k.soyadi)) FROM xxper.kisi k, xxper.perskim p WHERE k.tc_kimlik_no=amt.tc_kimlik_no AND k.tc_kimlik_no=p.tc_kimlik_no and p.kurum not in (888,999)) as yi, amt.TC_KIMLIK_NO as tc, amt.dinleti_mekan, decode(amt.solist_kull_alet,0,null,s_alet.adi) as alet_adi, amt.dunyada_ilk_seslendirilis, amt.turkiyede_ilk_seslendirilis, amt.yerli_yapim_yorum, amt.seri_bittar, amt.seri_bastar, amt.orkestra_adi, amt.gorevlendiren_kurum_var, amt.gorevlendiren_aciklama, amt.ulke_kodu, amt.ilce_kodu, amt.il_kodu from akd_sanat_muzik amt, KOD_DINLETI_TIP kodd, KOD_SOLIST_ALET s_alet where NVL(amt.web_yayin_evet,'E') = 'E' and amt.DINLETI_TIPI=kodd.kodu(+) and amt.TC_KIMLIK_NO ='$param[TC]' and amt.solist_kull_alet=s_alet.kodu(+) order by seri_bastar desc"; break; case "ODUL_TC": $strSQL=" select null as yi, ako.TC_KIMLIK_NO as tc, ako.ODUL_ADI_DERECE, ako.ODULU_VEREN_KURULUS, ako.ODUL_NITELIGI, ako.GRUP_BIREYSEL_ODUL, ako.KAZANDIGI_YIL, ako.ULUSAL_ULUSLARARASI, ako.ULKE_KODU from akd_kazanilan_odul ako where ako.TC_KIMLIK_NO ='$param[TC]' and NVL(ako.web_yayin_evet,'E') = 'E' "; break; case "BURS_TC": $strSQL=" select null as yi, ako.TC_KIMLIK_NO as tc, ako.BURS_VEREN_KURULUS, ako.burs_aciklama, ako.KAZANDIGI_YIL, (ako.sure||' '||ako.sure_tip) as sure, ako.ULKE_KODU, ako.YURTICI_YURTDISI, ako.KARSILIKLI_BURS, ako.KARSILIK_ACIKLAMA, ako.DEVAM_EDIYOR, ako.YABANCI_UNIV, DECODE(ako.ULKE_KODU,NULL,'TURKEY',2425,'TURKEY', (SELECT max(ulke.adi) from xxdeu.ulke ulke where ulke.uyruk_kodu=ako.ulke_kodu)) as ulke_adi_GRANT, DECODE(ako.YABANCI_ULKE_KODU,NULL,'TURKEY',2425,'TURKEY',(SELECT max(ulke.adi) from xxdeu.ulke ulke where ulke.uyruk_kodu=ako.YABANCI_ULKE_KODU)) as ulke_adi_YABANCI from akd_kazanilan_burs ako where ako.TC_KIMLIK_NO ='$param[TC]' and NVL(ako.web_yayin_evet,'E') = 'E' "; break; case "IDARIGOREV_TC": $strSQL=" select ig.TC_KIMLIK_NO as tc, ig.GOR_UNVAN gorevunvani, replace(replace(replace(ig.GOR_BIRIM,' And ',' and '),' Of ',' of '),'Deü ','DEÜ ') as birimi, replace(replace(replace(ig.GOR_ANABILIM,' And ',' and '),' Of ',' of '),'Deü ','DEÜ ') as anabilimi, ig.TARIH_ARALIGI suresi from VN_IDARI_GOREV_eng ig, xxper.perskim p where trim(ig.CV_LISTELENMESIN) is null and p.TC_KIMLIK_NO ='".$param[TC]."' and p.TC_KIMLIK_NO=ig.tc_kimlik_no and p.arsiv_yil=ig.arsiv_yil and p.arsiv_no=ig.arsiv_no and p.kadro_durumu in (1,3,7,8,15,29) "; break; case "PER_ARA": $strSQL=" select k.tc_kimlik_no, (select min(trim(aunvan.adi)) from xxdeu.unvan aunvan where aunvan.sinif=p.akad_unv1 and aunvan.unvan=p.akad_unv2) as aunv, initcap(replace(trim(kunvan.adi),'I','i')) as kunv, trim(k.soyadi||' '||k.adi||decode(p.calis_durum,'0',' (Retirement Date : '||to_char(p.ayr_tarih,'DD/MM/YYYY')||' )',null)) as adi, decode((select count(*) from xxakademik.liste_olagandisi lo where lo.tc_kimlik_no = p.tc_kimlik_no and ltrim(rtrim(lo.gorevyeri)) is not null),0,kk.adi, (select min(lo.gorevyeri) from xxakademik.liste_olagandisi lo where lo.tc_kimlik_no = p.tc_kimlik_no)) as birim, p.arsiv_yil as ayil, (select min(debis_id) from xxdeu.kullanici k where k.arsiv_yil = to_number(substr(p.arsiv_yil,3,2)) and k.arsiv_no=p.arsiv_no) as debis_id, p.arsiv_no as ano, p.arsiv_yil*10000+p.arsiv_no as akod from xxper.kisi k, xxper.perskim p, xxdeu.unvan kunvan, xxper.kod_kurum kk where k.tc_kimlik_no=p.tc_kimlik_no and p.kadro_durumu in (1,3,7,8,15,29) and (p.calis_durum='1' or (p.ayr_neden_kodu in (3,11,20) and p.calis_durum='0')) and p.islem_kod<>'2' and p.CV_listelenmesin is null and p.kadro_unv1=kunvan.sinif and p.kadro_unv2=kunvan.unvan and p.kurum not in (999,888) and p.kurum=kk.kurum and k.soyadi like '$param[HARF]%' order by adi"; if($_SERVER["REMOTE_ADDR"]=="193.140.151.185") { print "==>>>>>".$strSQL."<========="; } break; case "PER_ARA_2": $strSQL=" select k.tc_kimlik_no, (select min(trim(aunvan.adi)) from xxdeu.unvan aunvan where aunvan.sinif=p.akad_unv1 and aunvan.unvan=p.akad_unv2) as aunv, initcap(replace(trim(kunvan.adi),'I','i')) as kunv, trim(k.soyadi||' '||k.adi||decode(p.calis_durum,'0',' (Retirement Date : '||to_char(p.ayr_tarih,'DD/MM/YYYY')||' )',null)) as adi, lo.gorevyeri as birim, p.arsiv_yil as ayil, p.arsiv_no as ano from xxper.kisi k, xxper.perskim p, xxdeu.unvan kunvan, xxper.kod_kurum kk, xxakademik.Liste_Olagandisi lo where k.tc_kimlik_no=p.tc_kimlik_no and p.kadro_durumu in (1,3,7,8,15,29) and p.CV_listelenmesin is null and (p.calis_durum='1' or (p.ayr_neden_kodu in (3,11,20) and p.calis_durum='0')) and p.kadro_unv1=kunvan.sinif and p.kadro_unv2=kunvan.unvan and lo.tc_kimlik_no = p.tc_kimlik_no and p.kurum not in (999,888) and p.kurum=kk.kurum and k.soyadi like '$param[HARF]%'".$param[ORDER]; if($_SERVER["REMOTE_ADDR"]=="193.140.151.185") print $strSQL; break; case "PERSONEL": $strSQL=" select trim(initcap(nvl(u.adi_ing,u.adi)))||' '||k.adi||' '||k.soyadi||decode(p.calis_durum,'0',' (Retirement Date : '||to_char(p.ayr_tarih,'DD/MM/YYYY')||' )',null) as adi, decode(nvl(a.WEB_HANGI_TEL,'I'),'C',decode(substr(trim(a.CEP_TEL),1,1),'0','+90 '||substr(trim(a.CEP_TEL),2,(length(trim(a.CEP_TEL))-1)),'+90 '||trim(a.CEP_TEL)), 'I',decode(p.calis_durum,'0',null,'+90 232 - '||a.is_tel ||' - '||a.is_tel_ic),'H',decode(substr(trim(a.CEP_TEL),1,1),'0','+90 '||substr(trim(a.CEP_TEL),2,(length(trim(a.CEP_TEL))-1)),'+90 '||trim(a.CEP_TEL))||decode(p.calis_durum,'0',null,' / +90 232 - '||a.is_tel||' - '||a.is_tel_ic)) as tel, trim(decode((select count(*) from xxakademik.liste_olagandisi lo where lo.tc_kimlik_no = p.tc_kimlik_no and ltrim(rtrim(lo.gorevyeri)) is not null),0, trim(upper(nvl(kkur.adi_ing,kkur.uzun_adi)||decode(p.anabilim3+p.anabilim4,0,null,decode(p.anabilim3,0,null,(select max(' '||nvl(ana.adi_ing,ana.uzun_adi)) from xxper.anabilim ana where ana.sanal is null and ana.iptal_tarihi is null and ana.kurum_kodu=p.anabilim1 and ana.okul_kodu=p.anabilim2 and ana.bolum_kodu=p.anabilim3 and ana.anabilim_kodu=0 and ana.bilim_kodu=0 and ana.uzun_adi not like '%REKTÖRLÜK%'))|| decode(p.anabilim4,0,null,(select max(' '||nvl(ana.adi_ing,ana.uzun_adi)) from xxper.anabilim ana where ana.sanal is null and ana.iptal_tarihi is null and ana.kurum_kodu=p.anabilim1 and ana.okul_kodu=p.anabilim2 and ana.bolum_kodu=p.anabilim3 and ana.anabilim_kodu=p.anabilim4 and ana.bilim_kodu=0 and ana.uzun_adi not like '%REKTÖRLÜK%')))|| decode(p.anabilim11,null,null,(select max(' '||nvl(ana.adi_ing,ana.uzun_adi)) from xxper.anabilim ana where ana.kurum_kodu=p.anabilim11 and ana.okul_kodu=p.anabilim22 and ana.bolum_kodu=p.anabilim33 and ana.anabilim_kodu=p.anabilim44 and ana.bilim_kodu=p.anabilim55)) ||decode(p.ABD2_1,null,null,(select max(' & '||nvl(ana.adi_ing,ana.uzun_adi)) from xxper.anabilim ana where ana.kurum_kodu=p.ABD2_1 and ana.okul_kodu=p.ABD2_2 and ana.bolum_kodu=p.ABD2_3 and ana.anabilim_kodu=p.ABD2_4 and ana.bilim_kodu=p.ABD2_5)))), (select min(lo.gorevyeri) from xxakademik.liste_olagandisi lo where lo.tc_kimlik_no = p.tc_kimlik_no))) as anabilim, (select e.email from xxper.email e where e.tc_kimlik_no=k.tc_kimlik_no and e.sira_no=1) as email, decode(p.kadro_unv1*100+p.kadro_unv2,201,'Instructor',202,'Lecturer',301,'Research Assistant',302,'Specialist',1104,'Instructor in Art',null) as detay_kunv from xxper.kisi k, xxper.perskim p, xxdeu.unvan u, xxper.adres_bilgileri a, xxper.kod_kurum kkur where k.tc_kimlik_no='$param[TC]' and k.tc_kimlik_no=p.tc_kimlik_no and p.akad_unv1=u.sinif(+) and p.akad_unv2=u.unvan(+) and (p.calis_durum='1' or (p.ayr_neden_kodu in (3,11,20) and p.calis_durum='0')) and p.kadro_durumu in (1,3,7,8,15,29) and p.islem_kod<>'2' and k.tc_kimlik_no=a.tc_kimlik_no (+) and p.CV_listelenmesin is null and p.kurum=kkur.kurum"; break; case "PER_EG": $strSQL=" select decode(po.ogr_kod,55,nvl(to_number(to_char(po.kadro_tar,'YYYY')),po.diploma_yil),58,po.diploma_yil,nvl(po.diploma_yil,to_number(to_char(po.kadro_tar,'YYYY')))) as diploma_yil, decode(po.ogr_kod,54,decode(po.DOKTORA_TIP,'D','PhD (Doctorate)','T','Specialization in Medicine','S','Competency in Arts','Y','Masters Degree + PhD'),ko.aciklama_ing) as aciklama, decode(po.ogr_kod,58,trim(decode(po.UNI_KODU,0,null,889,null,990,null,nvl(trim(uk.adi_en),trim(okudugu_univ)))||' '||trim(okul_fak_adi)||' '||trim(okudugu_bolum))||decode(po.diploma_yil,null,', '||to_char(po.kadro_tar,'YYYY'),null), 57,decode((select count(*) from xxakademik.liste_olagandisi lo where lo.tc_kimlik_no = po.tc_kimlik_no and trim(PROF_SATIRI) is not null),0, trim(decode(po.UNI_KODU,0,null,889,null,990,null,nvl(trim(uk.adi_en),trim(okudugu_univ)))||' '||trim(okul_fak_adi)||' '||trim(okudugu_bolum)), (select min(trim(PROF_SATIRI)) from xxakademik.liste_olagandisi lo where lo.tc_kimlik_no = po.tc_kimlik_no)), 56,trim(decode((select count(*) from xxakademik.liste_olagandisi lo where lo.tc_kimlik_no = po.tc_kimlik_no and trim(DOC_SATIRI) is not null),0, decode(po.kadro_tar,null,null,decode(po.uni_kodu,889,null,990,null,0,'Turkish Inter-Universities Board',nvl(trim(uk.adi_en),trim(okudugu_univ))))||' '||decode(po.uni_kodu,0,null,null,null,decode(po.kadro_tar,null,'Turkish Inter-Universities Board',trim(okul_fak_adi)))||' '||trim(replace(replace(po.okudugu_bolum,'Anabilim Dalı',null),'Anasanat Dalı',null)), (select min(trim(DOC_SATIRI)) from xxakademik.liste_olagandisi lo where lo.tc_kimlik_no = po.tc_kimlik_no))), 61,decode((select count(*) from xxakademik.liste_olagandisi lo where lo.tc_kimlik_no = po.tc_kimlik_no and trim(YRDOC_SATIRI) is not null),0, trim(decode(po.UNI_KODU,0,null,889,null,990,null,nvl(trim(uk.adi_en),trim(okudugu_univ)))||' '||trim(okul_fak_adi)||' '||trim(okudugu_bolum)), (select min(trim(YRDOC_SATIRI)) from xxakademik.liste_olagandisi lo where lo.tc_kimlik_no = po.tc_kimlik_no)), 55,decode((select count(*) from xxakademik.liste_olagandisi lo where lo.tc_kimlik_no = po.tc_kimlik_no and trim(YRDOC_SATIRI) is not null),0, trim(decode(po.UNI_KODU,0,null,889,null,990,null,nvl(trim(uk.adi_en),trim(okudugu_univ)))||' '||trim(okul_fak_adi)||' '||trim(okudugu_bolum)), (select min(trim(YRDOC_SATIRI)) from xxakademik.liste_olagandisi lo where lo.tc_kimlik_no = po.tc_kimlik_no)), 52,decode((select count(*) from xxakademik.liste_olagandisi lo where lo.tc_kimlik_no = po.tc_kimlik_no and trim(LISANS_SATIRI) is not null),0, trim(decode(po.UNI_KODU,0,null,889,null,990,null,nvl(trim(uk.adi_en),trim(okudugu_univ)))||' '||trim(okul_fak_adi)||' '||trim(okudugu_bolum)), (select min(trim(LISANS_SATIRI)) from xxakademik.liste_olagandisi lo where lo.tc_kimlik_no = po.tc_kimlik_no)), 53,decode((select count(*) from xxakademik.liste_olagandisi lo where lo.tc_kimlik_no = po.tc_kimlik_no and trim(YLISANS_SATIRI) is not null),0, trim(decode(po.UNI_KODU,0,null,889,null,990,null,nvl(trim(uk.adi_en),trim(okudugu_univ)))||' '||trim(okul_fak_adi)||' '||trim(okudugu_bolum)), (select min(trim(YLISANS_SATIRI)) from xxakademik.liste_olagandisi lo where lo.tc_kimlik_no = po.tc_kimlik_no)), 54,decode((select count(*) from xxakademik.liste_olagandisi lo where lo.tc_kimlik_no = po.tc_kimlik_no and trim(DOKTORA_SATIRI) is not null),0, trim(decode(po.UNI_KODU,0,null,889,null,990,null,nvl(trim(uk.adi_en),trim(okudugu_univ)))||' '||trim(okul_fak_adi)||' '||trim(okudugu_bolum)), (select min(trim(DOKTORA_SATIRI)) from xxakademik.liste_olagandisi lo where lo.tc_kimlik_no = po.tc_kimlik_no)), trim(decode(po.UNI_KODU,0,null,889,null,990,null,nvl(trim(uk.adi_en),trim(okudugu_univ)))||' '||trim(okul_fak_adi)||' '||trim(okudugu_bolum)) ) as yer from xxper.persogr po, xxper.kod_ogr ko, xxdeu.universite_kodu uk where po.tc_kimlik_no='$param[TC]' and po.ogr_kod=ko.kod and trim(po.CV_LISTELENMESIN) is null and po.uni_kodu=uk.universite_kodu(+) and po.ogr_kod>50 order by 1,ogr_kod"; break; case "RESIM": $strSQL=" select resim from xxper.resimler where resimno not in (select lo.tc_kimlik_no from xxakademik.liste_olagandisi lo where trim(lo.FOTO_GORUNMESIN) is not null) and resimno='$param[TC]'"; break; case "ILCE": $strSQL=" select adi from xxdeu.ilce where ilce_kodu = '$param[ILCE]' and il_kodu = '$param[IL]' "; break; case "IL": $strSQL=" select adi from xxdeu.il where il_kodu = '$param[IL]' "; break; case "ULKE": $strSQL=" select adi from xxdeu.ulke where uyruk_kodu = '$param[ULKE]' "; break; }//end switch //if($_SERVER["REMOTE_ADDR"]=="193.140.151.185") print $id." ========> ".$strSQL.'


'; $stmt = ociparse($conn,$strSQL); ociexecute($stmt,OCI_DEFAULT); return $stmt; }//end function get ?>