HizmetlerimizBina ÖzelliklerimizOda Özelliklerimiz
@procedure{"id":"hizmet","name":"TanimHizmetleri as B", "property":["case when YB.Aciklama = '' then '
'+ B.Adi +'' else '
'+ ' '+ B.Adi +'' +'
'+ YB.Aciklama+'
' end cnt"], "where":"YB.YurtID=475", "orderby":[{"sort":"asc","property":"YB.Aciklama,B.Adi"}], "relation":[ {"type":"join","name":"YurtHizmetleri as YB","on":"YB.HizmetID=B.ID"}, {"type":"join","name":"SEO as S","on":"S.HizmetID=B.ID"}, {"type":"join","name":"SEOCeviri as SC","on":"SC.SEOID=S.ID"} ] }@/procedure @forcode[hizmet]{ @hizmet.cnt }[hizmet]@/forcode
@procedure{"id":"bina","name":"TanimBinaOzellikleri as B", "property":["case when YB.Aciklama = '' then '
'+ B.Adi +'' else '
'+ ' '+ B.Adi +'' +'
'+ YB.Aciklama+'
' end cnt"], "where":"YB.YurtID=475", "orderby":[{"sort":"asc","property":"YB.Aciklama,B.Adi"}], "relation":[ {"type":"join","name":"YurtBinaOzellikleri as YB","on":"YB.BinaOzellikID=B.ID"}, {"type":"join","name":"SEO as S","on":"S.BinaOzellikID=B.ID"}, {"type":"join","name":"SEOCeviri as SC","on":"SC.SEOID=S.ID"} ] }@/procedure @forcode[bina]{ @bina.cnt }[bina]@/forcode
@procedure{"id":"oda","name":"TanimOdaOzellikleri as B", "property":["case when YB.Aciklama = '' then '
'+ B.Adi +'' else '
'+ ' '+ B.Adi +'' +'
'+ YB.Aciklama+'
' end cnt"], "where":"YB.YurtID=475", "orderby":[{"sort":"asc","property":"YB.Aciklama,B.Adi"}], "relation":[ {"type":"join","name":"YurtOdaOzellikleri as YB","on":"YB.OdaOzellikID=B.ID"}, {"type":"join","name":"SEO as S","on":"S.OdaOzelliKID=B.ID"}, {"type":"join","name":"SEOCeviri as SC","on":"SC.SEOID=S.ID"} ] }@/procedure @forcode[oda]{ @oda.cnt }[oda]@/forcode