SentezDYE Tekstil Terbiye Takip Sistemi

SentezDYE Tekstil Terbiye Takip Sistemi SQL Sorgusu

• Termin Kontrol Listesi
  Select SIPFD.TERMIN As Termin, SIPFD.FISNO As [Fiş No],  ISNULL((Select CKART.ADI From CKART Where CKART.SIRKET = SIPFD.SIRKET And CKART.KOD = SIPFD.CKOD), '') As Müşteri
  ,SIPFD.MKOD As Stok, SIPFD.OZEL5 As Varyant, SIPFD.MIKTAR As Miktar,SIPFD.DOVIZ As Döviz
  ,SIPFD.DFIYAT As [Döviz Fiyat],SIPFD.TARIH As Tarih
  From SIPFD
  Where SIPFD.SIRKET = '01' And SIPFD.TIP = 2 And SIPFD.AK = 0 And
  FLOOR(Cast(SIPFD.TERMIN As Float)) <= floor(cast(GETDATE() AS float))
  Order By SIPFD.TERMIN, SIPFD.FISNO

• Günlük Üretim Durumu
  select PD.ISLEM AS [İşlem Kodu],ISNULL(I.ADI,'') as [İşlem Adı], SUM(CIKAN) as [Üretim Miktarı]
  FROM PARTID PD
  left join ISLEM I ON (PD.SIRKET=I.SIRKET AND PD.ISLEM=I.KOD)
  WHERE PD.SIRKET='01' AND floor(cast(PD.CTGERCEK AS float))=floor(cast(GETDATE() AS float))
  GROUP BY PD.ISLEM,I.ADI
  ORDER BY PD.ISLEM

• Günlük Boyama Üretimi (boya işlem kodu 8 olarak kabul edilmiştir)
  select PD.MAKINA AS [Makina],PD.PNO as [Parti No],PD.CZGERCEK as [Çıkış Saati],PD.CIKAN as [Miktar]
  FROM PARTID PD
  WHERE PD.SIRKET='01' AND floor(cast(PD.CTGERCEK AS float))=floor(cast(GETDATE() AS float)) and PD.ISLEM=8
  ORDER BY PD.CZGERCEK desc

• Günlük Ram Üretimi (ram işlem kodu 19 olarak kabul edilmiştir)
  select PD.MAKINA AS [Makina],PD.PNO as [Parti No],PD.CZGERCEK as [Çıkış Saati],PD.CIKAN as [Miktar]
  FROM PARTID PD
  WHERE PD.SIRKET='01' AND floor(cast(PD.CTGERCEK AS float))=floor(cast(GETDATE() AS float)) and PD.ISLEM=19
  ORDER BY PD.CZGERCEK desc

• Günlük Partileme Üretimi  (partileme işlem kodu 1 olarak kabul edilmiştir)
  select PD.MAKINA AS [Makina],PD.PNO as [Parti No],PD.CZGERCEK as [Çıkış Saati],PD.CIKAN as [Miktar]
  FROM PARTID PD
  WHERE PD.SIRKET='01' AND floor(cast(PD.CTGERCEK AS float))=floor(cast(GETDATE() AS float)) and PD.ISLEM=1
  ORDER BY PD.CZGERCEK desc

• Günlük Şardon Üretimi (şardon işlem kodu 12 olarak kabul edilmiştir)
  select PD.MAKINA AS [Makina],PD.PNO as [Parti No],PD.CZGERCEK as [Çıkış Saati],PD.CIKAN as [Miktar]
  FROM PARTID PD
  WHERE PD.SIRKET='01' AND floor(cast(PD.CTGERCEK AS float))=floor(cast(GETDATE() AS float)) and PD.ISLEM=12
  ORDER BY PD.CZGERCEK desc

• Günlük Sipariş Listesi
  Select FISNO AS [Fiş No],ISNULL((SELECT ADI FROM CKART WHERE CKART.SIRKET=SIPFD.SIRKET AND CKART.KOD=SIPFD.CKOD),'') AS [Müşteri]
  ,MKOD AS [Stok],OZEL5 AS [Varyant],TERMIN AS [Termin],MIKTAR AS [Miktar],DOVIZ AS [Döviz],DFIYAT AS [Döviz Fiyat]
  FROM SIPFD
  WHERE SIRKET='01' AND TIP=2 AND floor(cast(TARIH AS float))=floor(cast(GETDATE() AS float))
  ORDER BY FISNO

• Günlük Sevkiyat Listesi
  Select FISNO AS [Fiş No],ISNULL((SELECT ADI FROM CKART WHERE CKART.SIRKET=SFISD.SIRKET AND CKART.KOD=SFISD.CKOD),'') AS [Müşteri]
  ,MKOD AS [Stok],OZEL5 AS [Varyant],MIKTAR AS [Miktar]
  FROM SFISD
  WHERE SIRKET='01' AND (TIP=20 OR TIP=25) AND floor(cast(TARIH AS float))=floor(cast(GETDATE() AS float))
  ORDER BY TIP,FISNO

• Günlük Stok Hareketleri
  Select case when TIP=1 then 'Alım' when TIP=11 then 'Fason Giriş' when TIP=12 then 'Fason İade' when TIP=34 then 'Fason Çıkış' else 'Stok Fişi' end As [Hareket Tipi]
  ,FISNO AS [Fiş No],ISNULL((SELECT ADI FROM CKART WHERE CKART.SIRKET=SFISD.SIRKET AND CKART.KOD=SFISD.CKOD),'') AS [Müşteri]
  ,MKOD AS [Stok],OZEL5 AS [Varyant],MIKTAR AS [Miktar]
  FROM SFISD
  WHERE SIRKET='01' AND (TIP=1 OR TIP=11 or TIP=12 or TIP=34) AND floor(cast(TARIH AS float))=floor(cast(GETDATE() AS float))
  ORDER BY TIP,FISNO