and not a.objednavka like '___4%' and ! empty (a.ter_ov)
Prob
r dat z objedn
vek ...
select a.ico_urceni as ico, a.zav_urceni as zav, a.ident, a.objednavka, a.rok_obj as rok, b.mena as mena, 'O' as puvod, sum(a.ks_pozad) as ks_pozad, sum(a.ks_potvrz) as ks_potvrz, sum(a.ks_dodane) as ks_dodane, sum(a.cena * a.ks_dodane) as dodano_men, sum(a.cena * a.ks_potvrz) as potvrz_men FROM m2_por a, m2_zcen b WHERE a.ter_ov BETWEEN odobd .and. doobd and a.typ_por = 'V' and not inlist (a.stav_por, 'S') and a.objednavka = b.objednavka and a.rok_obj = b.rok_obj and a.poradi = b.poradi &QpodmQ ORDER by 1,2,3,4,5,6 GROUP by 1,2,3,4,5,6 INTO DBF c2_stat1
Prob
r dat z archivu objedn
vek ...
select a.ico_urceni as ico, a.zav_urceni as zav, a.ident, a.objednavka, a.rok_obj as rok, b.mena as mena, 'A' as puvod, sum(a.ks_pozad) as ks_pozad, sum(a.ks_potvrz) as ks_potvrz, sum(a.ks_dodane) as ks_dodane, sum(a.cena * a.ks_dodane) as dodano_men, sum(a.cena * a.ks_potvrz) as potvrz_men FROM a2_por a, a2_zcen b WHERE a.ter_ov BETWEEN odobd .and. doobd and a.typ_por = 'V' and not inlist (a.stav_por, 'S') and a.objednavka = b.objednavka and a.rok_obj = b.rok_obj and a.poradi = b.poradi &QpodmQ ORDER by 1,2,3,4,5,6 GROUP by 1,2,3,4,5,6 INTO DBF c2_stat3
select ico_urceni as ico, zav_urceni as zav, ident, objednavka, rok_obj as rok, ' ' as mena, 'O' as puvod, sum(ks_pozad) as ks_pozad, sum(ks_potvrz) as ks_potvrz, sum(ks_dodane) as ks_dodane, sum(cena*ks_dodane) as dodano_men, sum(cena*ks_potvrz) as potvrz_men FROM m2_por WHERE ter_ov BETWEEN odobd .and. doobd and typ_por = 'V' and not inlist (stav_por, 'S') &QpodmQ ORDER by 1,2,3,4,5,6 GROUP by 1,2,3,4,5,6 INTO DBF c2_stat1
Prob
r dat z archivu objedn
vek ...
select ico_urceni as ico, zav_urceni as zav, ident, objednavka, rok_obj as rok, ' ' as mena, 'A' as puvod, sum(ks_pozad) as ks_pozad, sum(ks_potvrz) as ks_potvrz, sum(ks_dodane) as ks_dodane, sum(cena*ks_dodane) as dodano_men, sum(cena*ks_potvrz) as potvrz_men FROM a2_por WHERE ter_ov BETWEEN odobd .and. doobd and typ_por = 'V' and not inlist (stav_por, 'S') &QpodmQ ORDER by 1,2,3,4,5,6 GROUP by 1,2,3,4,5,6 INTO DBF c2_stat3
select ident, nazev, sum(ks_pozad) as ks_pozad, sum(ks_potvrz) as ks_potvrz, sum(ks_dodane) as ks_dodane, sum(dodano_kc) as dodano_kc, sum(potvrz_kc) as potvrz_kc, sum(dodano_men) as dodano_men, sum(potvrz_men) as potvrz_men, mena FROM c2y WHERE &filt GROUP by ident, mena INTO DBF c2pol
select ico, zav, nazev_org, sum(dodano_kc) as dodano_kc, sum(potvrz_kc) as potvrz_kc, sum(dodano_men) as dodano_men, sum(potvrz_men) as potvrz_men, mena FROM c2y WHERE &filt GROUP by ico, zav, mena INTO DBF c2org
Statistika objedn
vek:
Celkov
ty - potvrz.celkem: FF
, dod
no celkem:
mod22f
RIIS 2.2
Sumace
Zadejte n
zev organizace:
Objed.
Objednavky
zev z
c2org.nazev_org
c2org.nazev_org
c2org.ico
c2org.ico
c2org.zav
c2org.zav
Potvrzeno-K
str(c2org.potvrz_kc,12,2)
c2org.potvrz_kc
Dod
str(c2org.dodano_kc,12,2)
c2org.dodano_kc
Potvrz.-m
str(c2org.potvrz_men,12,2)
c2org.potvrz_men
str(c2org.dodano_men,12,2)
c2org.dodano_men
c2org.mena + ' '
c2org.mena
RIIS 2.2
M_DBF
M_REC
LFILT
KAPOLEX
TVRZPROCX
RZRBOT
CLEFT
ALCRIGHT
AFREEZE
ORDER
FFDOL
ETURN
OFFPRAVA
AVKANADPIS
JMENO
O_MENTITLE
_MENTITLECOLORPOC0
TINCT
AVKAF2
EV_ORG
ANO_KC
VRZ_KC
EF_MENF0PRG
IF1ON
ENIF1PRG
LF4_JM
RF4PRG
TISKPRG
F7_JM
ENF7PRG
F9PRG
F9KEY
_PRNF9KEY1
F10_JM
F10PRG
ORRAMECEK
KLRIIS
NAZEVT
KLICO
FFKLNAZ
UALSPACEBAR
RTR_HL1
FFTR_HL2
TR_HL3
OFFTR_HL4
TR_HL5
FTR_HL6
TR_HL7
_ TR_HL8
LORTR_HL9
RNDET_JM
ENTER
DETAIL
DETPRG
PS_LINE
PS_RETURN
PS_ZAZN
MMENACIZ
NAZEV_ORG
DODANO_KC
POTVRZ_KC
DODANO_MENPOTVRZ_MENMENA
Z_MENC2Y
RZ_MENC2ORG
_MENNAZEV
CELKPOTVRZCELKDOD
ZMOD_PSV
ty po
adavk
za objedn
vky a m
ty po
adavk
za objedn
c2obj
ty po
adavk
za objedn
vky a m
ny (v
ty po
adavk
za objedn
vky (v
select objednavka, rok, sum(ks_pozad) as ks_pozad, sum(ks_potvrz) as ks_potvrz, sum(ks_dodane) as ks_dodane, sum(dodano_kc) as dodano_kc, sum(potvrz_kc) as potvrz_kc, sum(dodano_men) as dodano_men, sum(potvrz_men) as potvrz_men, mena FROM c2y WHERE &filt GROUP by objednavka, rok INTO DBF c2obj
Statistika objedn
vek:
Celkov
ty - potvrz.celkem: FF
, dod
no celkem:
mod22f
RIIS 2.2
Sumace
Zadejte objedn
vku:
|...........
Objedn
c2obj.objednavka
c2obj.objednavka
str(c2obj.ks_pozad,10,3)
c2obj.ks_pozad
.pot.
str(c2obj.ks_potvrz,10,3)
c2obj.ks_potvrz
.dod.
str(c2obj.ks_dodane,10,3)
c2obj.ks_dodane
Potvrzeno-K
str(c2obj.potvrz_kc,12,2)
c2obj.potvrz_kc
Dod
str(c2obj.dodano_kc,12,2)
c2obj.dodano_kc
Vyrobit-K
str(c2obj.potvrz_kc-c2obj.dodano_kc,13,2)
c2obj.potvrz_kc-c2obj.dodano_kc
Potvrz.-m
str(c2obj.potvrz_men,12,2)
c2obj.potvrz_men
str(c2obj.dodano_men,12,2)
c2obj.dodano_men
c2obj.mena + ' '
c2obj.mena
Vyrobit-m
str(c2obj.potvrz_men-c2obj.dodano_men,13,2)
c2obj.potvrz_men-c2obj.dodano_men
RIIS 2.2
M_DBF
M_REC
LFILT
KAPOLEX
TVRZPROCX
RZRBOT
CLEFT
ALCRIGHT
AFREEZE
ORDER
FFDOL
ETURN
OFFPRAVA
AVKANADPIS
JMENO
O_MENTITLE
_MENTITLECOLORPOC0
TINCT
AVKAF2
EV_ORG
ANO_KC
VRZ_KC
EF_MENF0PRG
IF1ON
ENIF1PRG
LF4_JM
RF4PRG
TISKPRG
F7_JM
ENF7PRG
F9PRG
F9KEY
_PRNF9KEY1
F10_JM
F10PRG
ORRAMECEK
KLRIIS
NAZEVT
KLICO
FFKLNAZ
UALSPACEBAR
RTR_HL1
FFTR_HL2
TR_HL3
OFFTR_HL4
TR_HL5
FTR_HL6
TR_HL7
_ TR_HL8
LORTR_HL9
RNDET_JM
ENTER
DETAIL
DETPRG
PS_LINE
PS_RETURN
PS_ZAZN
MMENACIZ
OBJEDNAVKAROK
DNAVKAKS_POZAD
KS_POTVRZ
KS_DODANE
DODANO_KC
POTVRZ_KC
DODANO_MENPOTVRZ_MENMENA
Z_MENC2Y
C2OBJ
AVKACELKPOTVRZCELKDOD
ZMOD_PSV
vyb_er
Objedn
vky pro: F
Statistika objedn
vek:
seek &m_dbf..ico + &m_dbf..zav
copy to c2q while ico + zav = &m_dbf..ico + &m_dbf..zav
Poradi
Poradi
mod22f
slo obj.
c2q.objednavka
'/' +c2q.rok
Zdroj
IIF(c2q.puvod='A','Archiv','Objed.')
RIIS 2.2
OBRB2
M_DBF
LM_REC
KAPOLEX
TVRZPROCX
RZRBOT
CLEFT
ALCRIGHT
AFREEZE
ORDER
FFDOL
ETURN
OFFPRAVA
AVKANADPIS
JMENO
O_MENTITLE
_MENTITLECOLORPOC0
TINCT
AVKAF2
EV_ORG
ANO_KC
VRZ_KC
EF_MENF0PRG
IF1ON
ENIF1PRG
LF4_JM
RF4PRG
TISKPRG
F7_JM
ENF7PRG
F9PRG
F9KEY
_PRNF9KEY1
F10_JM
F10PRG
ORRAMECEK
KLRIIS
NAZEVT
KLICO
FFKLNAZ
UALSPACEBAR
RTR_HL1
FFTR_HL2
TR_HL3
OFFTR_HL4
TR_HL5
FTR_HL6
TR_HL7
_ TR_HL8
LORTR_HL9
RNDET_JM
ENTER
DETAIL
DETPRG
PS_LINE
PS_RETURN
PS_ZAZN
W_DLRADY
NAZEV_ORG
ODOBD
AVKADOOBD
ODANE
HELP3
MOD_PSV
a2_por
objednavka
a2_pozak
objednavka
m2_por
objednavka
m2_pozak
objednavka
cislo = &m_dbf..objednavka
rok = &M_dbf..rok
c2_pobj+
c2_pobj
znam!
RIIS 2.2
ehled po
objedn
vky F
mod22f
str(c2_pobj.poradi,3)
c2_pobj.poradi
c2_pobj.typ_por
c2_pobj.typ_por
c2_pobj.stav_por
c2_pobj.stav_por
robku
c2_pobj.ident
c2_pobj.ident
str(c2_pobj.ks_pozad,10,3)
c2_pobj.ks_pozad
.pot.
str(c2_pobj.ks_potvrz,10,3)
c2_pobj.ks_potvrz
tran(c2_pobj.ter_ov,'@E')
c2_pobj.ter_ov
Cena/MJC
str(c2_pobj.cena,13,2)
c2_pobj.cena
Da
str(c2_pobj.dan,13,2)
c2_pobj.dan
.dod.
str(c2_pobj.ks_dodane,10,3)
c2_pobj.ks_dodane
RIIS 2.2
M_DBF
M_REC
LOBR1
KAMOD_SYS
RZPS_LINE
RZPUVOD
A2_POR
ALOBJEDNAVKAPORADI
A2_POZAK
TEXTY
AVKAM2_POR
M2_POZAK
ACISLO
VKAROK
C2_POBJ
ROK_OBJ
KAOBJEDNAV
ATYP_POR
KAIDENT
_MENTEXT_TX
ORHLASKA
PS_RETURN
POLEX
AVKAPROCX
ARTOP
ARBOT
CLEFT
KACRIGHT
FREEZE
ORDER
_MENHOR
ENILEVA
LPRAVA
RNADPIS
JMENO
ENHODN
TITLE
_PRNTITLECOLORPOC0
UALF7
CEBAR
FFF10
F0PRG
OFFF1ON
F1PRG
FF4_JM
F4PRG
_ TISKPRG
ORF7_JM
RNF7PRG
F9PRG
F9KEY
F9KEY1
F10_JM
F10PRG
RAMECEK
NAZEVT
KLICO
AVKAKLNAZ
SPACEBAR
TR_HL1
TR_HL2
TR_HL3
TR_HL4
ENTR_HL5
TR_HL6
MENTR_HL7
TR_HL8
VKATR_HL9
VRZDET_JM
ZENTER
ZDETAIL
DETPRG
PS_ZAZN
W_DLRADY
MOD_PSV
Konec
Pohyb
-Enter
,PgUp,PgDn
COLORa
L_COLOR
colora
MCOLOR
stat_odb
te disketu do
achty
konec
! &f_adr\test_d a:
! &f_adr\test_d b:
ERROR
Disketa nebyla vlo
ena!
Prob
enos dat ...
copy to &sach\&_soub
RIIS 2.2
M_DBF
M_REC
LM_SCR
KA_SOUB
_LINE
SACHTA
RZSACH
NAVKAMOD_SYS
PANACEK
PS_RETURN
ESPOF
objedn
vek p
v obdob
(Auftragseingang)
z potvrzen
objedn
vek z
, kter
byly p
ijaty v obdob
te obdob
'OD', pros
and not a.objednavka like '___4%' and ! empty (a.ter_ov)
Prob
r dat z objedn
vek ...
m2_zcen
objednavka
select a.ico_urceni as ico, a.zav_urceni as zav, a.ident, a.stav_por, a.objednavka, a.rok_obj as rok, a.poradi, ' ' as mena, 'O' as puvod, a.ks_pozad, a.ks_potvrz, a.ks_dodane, a.cena * a.ks_dodane as dodano_men, a.cena * a.ks_potvrz as potvrz_men, b.dat_vyst, b.dat_prij, space(35) as nazev_org, space(25) as nazev, qq as dodano_kc, qq as potvrz_kc FROM m2_por a, m2_hlava b WHERE b.dat_prij BETWEEN odobd .and. doobd and a.typ_por = 'V' and a.objednavka = b.objednavka and a.rok_obj = b.rok_obj &QpodmQ ORDER by 1,2,3,4,5 INTO DBF c2_stat1
Prob
r dat z archivu objedn
vek ...
a2_zcen
objednavka
select a.ico_urceni as ico, a.zav_urceni as zav, a.ident, a.stav_por, a.objednavka, a.rok_obj as rok, a.poradi, ' ' as mena, 'A' as puvod, a.ks_pozad, a.ks_potvrz, a.ks_dodane, a.cena * a.ks_dodane as dodano_men, a.cena * a.ks_potvrz as potvrz_men, b.dat_vyst, b.dat_prij, space(35) as nazev_org, space(25) as nazev, qq as dodano_kc, qq as potvrz_kc FROM a2_por a, a2_hlava b WHERE b.dat_prij BETWEEN odobd .and. doobd and a.typ_por = 'V' and a.objednavka = b.objednavka and a.rok_obj = b.rok_obj &QpodmQ ORDER by 1,2,3,4,5 INTO DBF c2y
c2_stat1
V zadan
m obdob
nebyla nalezena
objedn
vka.
m7_kurz
aktual
m1_ident
ident
M4_organ
Objedn
vky s term
nem p
mod22f
RIIS 2.2
Detail
Zadejte n
zev organizace:
Funkce
Funkce
Objedn
c2y.objednavka
c2y.objednavka
str (c2y.poradi,3)
c2y.poradi
c2y.stav_por
c2y.stav_por
Identifikace
c2y.ident
c2y.ident
Ext. ident.
m1_ident.ident_odb
m1_ident.ident_odb
c2y.nazev
c2y.nazev
m1_ident.typ
m1_ident.typ
Pot.-K
str(c2y.potvrz_kc,12,2)
c2y.potvrz_kc
Dod.-K
str(c2y.dodano_kc,12,2)
c2y.dodano_kc
Pot.m
str(c2y.potvrz_men,12,2)
c2y.potvrz_men
Dod.m
str(c2y.dodano_men,12,2)
c2y.dodano_men
c2y.mena+' '
c2y.mena
str(c2y.ks_pozad,10,3)
c2y.ks_pozad
.pot.
str(c2y.ks_potvrz,10,3)
c2y.ks_potvrz
.dod.
str(c2y.ks_dodane,10,3)
c2y.ks_dodane
c2y.ico
c2y.ico
c2y.zav
c2y.zav
zev z
c2y.nazev_org
c2y.nazev_org
Dat.vyst.
tran(c2y.dat_vyst,'@E')+' '
c2y.dat_vyst
Dat.p
tran(c2y.dat_prij,'@E')+' '
c2y.dat_prij
PODNIK
ODOBD
LDOOBD
KAHLASKA
RZID_ORG
QPODMQ
RZMOD_SYS
NAVKAM2_ZCEN
OBJEDNAVKAROK
DNAVKAPORADI
AMENA
VKAA2_ZCEN
C2_STAT1
ADISTINCT
KAPUVOD
AVKAC2Y
ORC2Z
W_KOEF_MENM7_KURZ
KAAKTUAL
AM1_IDENT
AIDENT
M4_ORGAN
AW_DOD_MEN
W_POT_MEN
MMENACIZ
NNAKUP
ENMNOZ
NIDODANO_MENPOTVRZ_MENNAZEV_ORG
NAZEV
DODANO_KC
POTVRZ_KC
POLEX
PROCX
_PRNRTOP
COLORRBOT
CLEFT
ORCRIGHT
KLFREEZE
ORDER
FFDOL
UALLEVA
RPRAVA
FFNADPIS
OFFJMENO
FSOUC
TITLE
_ TITLECOLORPOC0
F0PRG
AVKAF1ON
F1PRG
F4_JM
F4PRG
TISKPRG
F7_JM
ENF7PRG
F9PRG
MENF9KEY
F9KEY1
VKAF10_JM
VRZF10PRG
ZRAMECEK
ZRIIS
NAZEVT
KLICO
KLNAZ
_SPACEBAR
TR_HL1
TR_HL2
TR_HL3
_TR_HL4
TR_HL5
_TR_HL6
TR_HL7
TR_HL8
TR_HL9
DET_JM
AENTER
ADETAIL
ADETPRG
KAPS_LINE
APS_RETURN
PS_ZAZN
_MOD_PSV
ESPOF
Nedodan
objedn
(Auftragsbestand) k datu:
r nespln
ch po
objedn
(tj.nebere se k
d 'S')a vystaven
dodac
ch list
k zadan
mu term
vyskladn
. Bere se i archiv.
(Jde o mno
ce do budoucna.)
n expedice:
te obdob
, pros
m7_kurz
aktual
m1_ident
ident
M4_organ
Prob
r dat z objedn
vek a DL ...
and not a.objednavka like '___4%' and ! empty (a.ter_ov)
ESPOF
select a.objednavka, a.rok_obj as rok, a.poradi, b.mena as mena, 'O' as puvod, a.ico_urceni as ico, a.zav_urceni as zav, a.ident, a.stav_por, a.ks_pozad, a.ks_potvrz, sum (d.ks_faktur ) as ks_dodane, a.cena * sum (d.ks_faktur) as dodano_men, a.cena * a.ks_potvrz as potvrz_men, c.dat_vyst, c.dat_prij, space(35) as nazev_org, space(25) as nazev, qq as dodano_kc, qq as potvrz_kc, a.ter_poz, a.ter_poz_tt, a.ter_ov, a.ter_ov_tt FROM m2_por a, m2_zcen b, m2_hlava c, m2_pfakt d, m2_hfakt e WHERE d.faktura = e.faktura and e.dat_odesl <=odobd and not inlist (a.stav_por, 'S') and a.objednavka = c.objednavka and a.rok_obj = c.rok_obj and a.objednavka = b.objednavka and a.rok_obj = b.rok_obj and a.objednavka = e.objednavka and a.rok_obj = e.rok_obj and c.dat_prij <=odobd and a.poradi = b.poradi and a.poradi = d.poradi &QpodmQ GROUP BY 1,2,3 INTO DBF c2_vyb
select a.objednavka, a.rok_obj as rok, a.poradi, b.mena as mena, 'O' as puvod, a.ico_urceni as ico, a.zav_urceni as zav, a.ident, a.stav_por, a.ks_pozad, a.ks_potvrz, qq as ks_dodane, qq as dodano_men, a.ks_potvrz * a.cena as potvrz_men, c.dat_vyst, c.dat_prij, space(35) as nazev_org, space(25) as nazev, qq as dodano_kc, qq as potvrz_kc, a.ter_poz, a.ter_poz_tt, a.ter_ov, a.ter_ov_tt FROM m2_por a, m2_zcen b, m2_hlava c WHERE a.objednavka = c.objednavka and a.rok_obj = c.rok_obj and a.objednavka = b.objednavka and a.rok_obj = b.rok_obj and c.dat_prij <=odobd and a.poradi = b.poradi and not (a.stav_por = 'S') &QpodmQ INTO DBF c2y
select a.objednavka, a.rok_obj as rok, a.poradi, b.mena as mena, 'O' as puvod, a.ico_urceni as ico, a.zav_urceni as zav, a.ident, a.stav_por, a.ks_pozad, a.ks_potvrz, sum (d.ks_faktur ) as ks_dodane, a.cena * sum (d.ks_faktur) as dodano_men, a.cena * a.ks_potvrz as potvrz_men, c.dat_vyst, c.dat_prij, space(35) as nazev_org, space(25) as nazev, qq as dodano_kc, qq as potvrz_kc, a.ter_poz, a.ter_poz_tt, a.ter_ov, a.ter_ov_tt FROM m2_por a, m2_zcen b, m2_hlava c, m2_pfakt d, m2_hfakt e WHERE d.faktura = e.faktura and e.dat_odesl <=odobd and not inlist (a.stav_por, 'S') and a.objednavka = c.objednavka and a.rok_obj = c.rok_obj and a.objednavka = b.objednavka and a.rok_obj = b.rok_obj and a.objednavka = e.objednavka and a.rok_obj = e.rok_obj and a.ter_ov <=odobd and a.poradi = b.poradi and a.poradi = d.poradi &QpodmQ GROUP BY 1,2,3 INTO DBF c2_vyb
select a.objednavka, a.rok_obj as rok, a.poradi, b.mena as mena, 'O' as puvod, a.ico_urceni as ico, a.zav_urceni as zav, a.ident, a.stav_por, a.ks_pozad, a.ks_potvrz, qq as ks_dodane, qq as dodano_men, a.ks_potvrz * a.cena as potvrz_men, c.dat_vyst, c.dat_prij, space(35) as nazev_org, space(25) as nazev, qq as dodano_kc, qq as potvrz_kc, a.ter_poz, a.ter_poz_tt, a.ter_ov, a.ter_ov_tt FROM m2_por a, m2_zcen b, m2_hlava c WHERE a.objednavka = c.objednavka and a.rok_obj = c.rok_obj and a.objednavka = b.objednavka and a.rok_obj = b.rok_obj and a.ter_ov <=odobd and a.poradi = b.poradi and not (a.stav_por = 'S') &QpodmQ INTO DBF c2y
Prob
r dat z archivu objedn
vek a DL ...
ESPOF
a2_por
a2_zcen
a2_hlava
a2_pfakt
a2_hfakt
a2_vyb
a2_por
a2_zcen
a2_hlava
a2_por
a2_zcen
a2_hlava
a2_pfakt
a2_hfakt
a2_vyb
a2_por
a2_zcen
a2_hlava
Nedodan
objedn
vek ke dni: F
mod22f
RIIS 2.2
Detail
Zadejte objedn
vku:
Funkce
Funkce
Objedn
c2y.objednavka
c2y.objednavka
str (c2y.poradi,3)
c2y.poradi
c2y.stav_por
c2y.stav_por
Identifikace
c2y.ident
c2y.ident
Ext. ident.
m1_ident.ident_odb
m1_ident.ident_odb
c2y.nazev
c2y.nazev
m1_ident.typ
m1_ident.typ
Vyrobit-K
str(c2y.potvrz_kc -c2y.dodano_kc,12,2)
c2y.potvrz_kc -c2y.dodano_kc
Vyrobit
str(c2y.ks_potvrz- c2y.ks_dodane,10,3)
c2y.ks_potvrz- c2y.ks_dodane
Vyrobit-m
str(c2y.potvrz_men -c2y.dodano_men,12,2)
c2y.potvrz_men -c2y.dodano_men
Pot.-K
str(c2y.potvrz_kc,12,2)
c2y.potvrz_kc
Dod.-K
str(c2y.dodano_kc,12,2)
c2y.dodano_kc
Pot.m
str(c2y.potvrz_men,12,2)
c2y.potvrz_men
str(c2y.dodano_men,12,2)
c2y.dodano_men
c2y.mena+' '
c2y.mena
str(c2y.ks_pozad,10,3)
c2y.ks_pozad
.pot.
str(c2y.ks_potvrz,10,3)
c2y.ks_potvrz
.dod.
str(c2y.ks_dodane,10,3)
c2y.ks_dodane
c2y.ico
c2y.ico
c2y.zav
c2y.zav
zev z
c2y.nazev_org
c2y.nazev_org
Dat.vyst.
tran(c2y.dat_vyst,'@E')+' '
c2y.dat_vyst
Dat.p
tran(c2y.dat_prij,'@E')+' '
c2y.dat_prij
Term.po
tran(c2y.ter_poz,'@E')
c2y.ter_poz
RT-po
' ' +c2y.ter_poz_tt + ' '
c2y.ter_poz_tt
Term.pot
tran(c2y.ter_ov,'@E')
c2y.ter_ov
RT-pot
' ' +c2y.ter_ov_tt + ' '
c2y.ter_ov_tt
PODNIK
ODOBD
LHLASKA
KAW_KOEF_MENM7_KURZ
AKTUAL
RZM1_IDENT
IDENT
ALM4_ORGAN
DOOBD
AVKAMOD_SYS
KAMESS
AID_ORG
VKAQPODMQ
OBJEDNAVKAROK
APORADI
KAC2_VYB
VKAKLW
ORC2Y
VKAKS_DODANE
DODANO_MENM2_POR
MENM2_ZCEN
AM2_HLAVA
M2_PFAKT
AM2_HFAKT
W_DOD_MEN
W_POT_MEN
MMENACIZ
IMENA
ENNAKUP
ENMNOZ
POTVRZ_MENNAZEV_ORG
NAZEV
DODANO_KC
POTVRZ_KC
JEDNAVKAROK_OBJ
ORPUVOD
KLICO_URCENIZAV_URCENISTAV_POR
FKS_POZAD
LKS_POTVRZ
KS_FAKTUR
TVRZ_MENDAT_VYST
DAT_PRIJ
FTER_POZ
TER_POZ_TTTER_OV
LORTER_OV_TT
A2_POR
A2_ZCEN
A2_HLAVA
A2_PFAKT
A2_HFAKT
FAKTURA
DAT_ODESL
A2_VYB
RZ_MENDISTINCT
AVKAPOLEX
PROCX
ENRTOP
MENCLEFT
CRIGHT
VKAFREEZE
VRZORDER
PRAVA
NADPIS
_ZAHL
JMENO
_TITLE
TITLECOLORPOC0
ETURN
F0PRG
AF1ON
_F1PRG
F4_JM
F4PRG
_ TISKPRG
F7_JM
F7PRG
F9PRG
F9KEY
F9KEY1
F10_JM
F10PRG
ERAMECEK
KARIIS
NAZEVT
_KLICO
KLNAZ
SPACEBAR
TR_HL1
_TR_HL2
_ TR_HL3
_TR_HL4
_ TR_HL5
TR_HL6
_ TR_HL7
TTR_HL8
TR_HL9
DET_JM
(ENTER
%DETAIL
DETPRG
PS_LINE
PS_RETURN
PS_ZAZN
MOD_PSV
ESPOF
Potvrzen
a nedodan
objedn
vek k dne
mu dni.
Pokra
ovat
Ukon
objedn
vek (neberou se
dy 'E' a 'S'), kter
nejsou k
mu dni spln
ny (expedov
ny).
Jen aktu
soubor (bez archivu)!
Pokra
ovat
Ukon
Prob
r dat z objedn
vek ...
and not a.objednavka like '___4%' and ! empty (a.ter_ov)
select a.ico_urceni as ico, a.zav_urceni as zav, a.ident, a.stav_por, a.objednavka, a.rok_obj as rok, a.poradi, b.mena as mena, 'O' as puvod, a.ks_pozad, a.ks_potvrz, a.ks_dodane, a.cena * a.ks_dodane as dodano_men, a.cena * a.ks_potvrz as potvrz_men, c.dat_vyst, c.dat_prij, space(35) as nazev_org, space(25) as nazev, qq as dodano_kc, qq as potvrz_kc, a.ter_ov, a.ter_ov_tt FROM m2_por a, m2_zcen b, m2_hlava c WHERE not inlist (a.stav_por, 'E', 'S') and a.ter_ov <= odobd and a.ks_potvrz > a.ks_dodane and a.objednavka = c.objednavka and a.rok_obj = c.rok_obj and a.objednavka = b.objednavka and a.rok_obj = b.rok_obj and a.poradi = b.poradi &QpodmQ ORDER by 1,2,3,4,5,6 INTO DBF c2y
m7_kurz
aktual
m1_ident
ident
M4_organ
Skluzy dod
vek k datu: F
mod22f
RIIS 2.2
Detail
Zadejte n
zev organizace:
Funkce
Funkce
Objedn
c2y.objednavka
c2y.objednavka
str (c2y.poradi,3)
c2y.poradi
c2y.stav_por
c2y.stav_por
Identifikace
c2y.ident
c2y.ident
Ext. ident.
m1_ident.ident_odb
m1_ident.ident_odb
c2y.nazev
c2y.nazev
m1_ident.typ
m1_ident.typ
Dat.OV
tran(c2y.ter_ov,'@E')
c2y.ter_ov
OV-RRtt
c2y.ter_ov_tt+' '
c2y.ter_ov_tt
Vyrobit
str(c2y.ks_potvrz- c2y.ks_dodane,10,3)
c2y.ks_potvrz- c2y.ks_dodane
Vyrobit-m
str(c2y.potvrz_men -c2y.dodano_men,12,2)
c2y.potvrz_men -c2y.dodano_men
Pot.-K
str(c2y.potvrz_kc,12,2)
c2y.potvrz_kc
Dod.-K
str(c2y.dodano_kc,12,2)
c2y.dodano_kc
Pot.m
str(c2y.potvrz_men,12,2)
c2y.potvrz_men
str(c2y.dodano_men,12,2)
c2y.dodano_men
c2y.mena+' '
c2y.mena
str(c2y.ks_pozad,10,3)
c2y.ks_pozad
.pot.
str(c2y.ks_potvrz,10,3)
c2y.ks_potvrz
.dod.
str(c2y.ks_dodane,10,3)
c2y.ks_dodane
c2y.ico
c2y.ico
c2y.zav
c2y.zav
zev z
c2y.nazev_org
c2y.nazev_org
Dat.vyst.
tran(c2y.dat_vyst,'@E')+' '
c2y.dat_vyst
Dat.p
tran(c2y.dat_prij,'@E')+' '
c2y.dat_prij
PODNIK
LODOBD
KADOOBD
_MENMOD_SYS
IDENT
ID_ORG
ALQPODMQ
ADISTINCT
KAOBJEDNAVKAROK
APUVOD
VKAC2Y
DNAVKAW_KOEF_MENM7_KURZ
AAKTUAL
KAM1_IDENT
AIDENT
ORM4_ORGAN
AW_DOD_MEN
W_POT_MEN
MMENACIZ
NMENA
ANAKUP
ENMNOZ
ADODANO_MENPOTVRZ_MENNAZEV_ORG
NAZEV
DODANO_KC
POTVRZ_KC
POLEX
PROCX
Z_MENRBOT
CLEFT
CRIGHT
FREEZE
ORDER
AVKAHOR
KADOL
ORLEVA
KLPRAVA
CENINADPIS
ENIZAHL
FJMENO
LHODN
TITLE
TITLECOLORPOC0
_PRIJ
_POZ_TTF3
LORF4
_OV_TT
HLAVA
F0PRG
F1PRG
F4_JM
F4PRG
TISKPRG
AF7_JM
AF7PRG
_MENF9PRG
AF9KEY
AVKAF9KEY1
F10_JM
ENF10PRG
RAMECEK
ENRIIS
NAZEVT
VKAKLICO
VRZKLNAZ
ZSPACEBAR
ZTR_HL1
TR_HL2
TR_HL3
TR_HL4
_TR_HL5
TR_HL6
TR_HL7
TR_HL8
_TR_HL9
DET_JM
LORENTER
DETAIL
DETPRG
PS_LINE
PS_RETURN
PS_ZAZN
AMOD_PSV
FILTERz
Celkov
et v m
Celkov
et v m
ch - v
Celkov
et v m
ch - v
Celkov
et v m
ch - v
Celkov
et v m
ch - v
AND
c2men
copy to c_sql for &filt
c_sql
c2men
SoucMen
Zadejte m
mod22f
Celkov
et v m
RIIS 2.2
c2men.mena+' '
c2men.mena
Potvrzeno-K
str(c2men.potvrz_kc,13,2)
c2men.potvrz_kc
Dod
str(c2men.dodano_kc,13,2)
c2men.dodano_kc
Potvrz.-m
str(c2men.potvrz_men,13,2)
c2men.potvrz_men
Dod
str(c2men.dodano_men,13,2)
c2men.dodano_men
Vyrobit-K
str(c2men.potvrz_kc-c2men.dodano_kc,13,2)
c2men.potvrz_kc-c2men.dodano_kc
Vyrobit-m
str(c2men.potvrz_men-c2men.dodano_men,13,2)
c2men.potvrz_men-c2men.dodano_men
RIIS 2.2
POLEX
LPROCX
KARTOP
_MENRBOT
CLEFT
RZCRIGHT
FREEZE
ALORDER
ALEVA
KAPRAVA
AVKANADPIS
AZAHL
VKAJMENO
NAVKASOUC
F_MENTITLE
ATITLECOLORPOC0
ORGAN
OD_MEN
OT_MEN
NACIZ
NO_MENF0PRG
_MENF1ON
F1PRG
F4_JM
F4PRG
TISKPRG
F7_JM
F7PRG
_MENF9PRG
F9KEY
F9KEY1
F10_JM
F10PRG
VKARAMECEK
KARIIS
ORNAZEVT
KLKLICO
CENIKLNAZ
ENISPACEBAR
FTR_HL1
LTR_HL2
TR_HL3
TR_HL4
TR_HL5
LORTR_HL6
TR_HL7
FTR_HL8
TR_HL9
_TTDET_JM
LORENTER
DETAIL
DETPRG
PS_LINE
PS_RETURN
PS_ZAZN
QQW_AL
QQW_ZAZ
VETARECNO
FILT1
FILT2
AFILT
AANSI
MENSUM
ADODANO_KC
POTVRZ_KC
DODANO_MENPOTVRZ_MENMENA
Z_MENC2Y
C2MEN
VKAC_SQL
_MENF5
CEBAR
MOD_PSV
ZPETRECNO
colorz
sum potvrz_kc, dodano_kc to CelkPotvrz, CelkDod for &filt
(.txt)