Izvjestaji SQL:  sedmični izvještaji INDEKSI
math
0|0
82
Enapravi_tabele_izvjestaj=7
Tnapredak_bargraf	E0
TODBC_rezultat_BRISANJE	EODBCExecuteSQL( numhandler,"DELETE * FROM T_I0_D")
Tnapredak_bargraf	E2
TODBC_rezultat_BRISANJE	EODBCExecuteSQL( numhandler,"DELETE * FROM T_I1_D")
Tnapredak_bargraf	E4
TODBC_rezultat_BRISANJE	EODBCExecuteSQL( numhandler,"DELETE * FROM T_I2_D")
Tnapredak_bargraf	E6
TODBC_rezultat_BRISANJE	EODBCExecuteSQL( numhandler,"DELETE * FROM T_I3_D")
Tnapredak_bargraf	E8
TODBC_rezultat_BRISANJE	EODBCExecuteSQL( numhandler,"DELETE * FROM T_I4_D")
Tnapredak_bargraf	E10
TODBC_rezultat_BRISANJE	EODBCExecuteSQL( numhandler,"DELETE * FROM T_I5_D")
Tnapredak_bargraf	E12
TODBC_rezultat_BRISANJE	EODBCExecuteSQL( numhandler,"DELETE * FROM T_I6_D")
Tnapredak_bargraf	E14
TODBC_rezultat_BRISANJE	EODBCExecuteSQL( numhandler,"DELETE * FROM T_I7_D")
Tnapredak_bargraf	E16
TODBC_rezultat_BRISANJE	EODBCExecuteSQL( numhandler,"DELETE * FROM T_I8_D")
Tnapredak_bargraf	E18
TODBC_rezultat_BRISANJE	EODBCExecuteSQL( numhandler,"DELETE * FROM T_I9_D")
Tnapredak_bargraf	E20
TODBC_rezultat_BRISANJE	EODBCExecuteSQL( numhandler,"DELETE * FROM T_I10_D")
Tnapredak_bargraf	E22
TODBC_rezultat_BRISANJE	EODBCExecuteSQL( numhandler,"DELETE * FROM T_I11_D")
Tnapredak_bargraf	E24
TODBC_rezultat_BRISANJE	EODBCExecuteSQL( numhandler,"DELETE * FROM T_I12_D")
Tnapredak_bargraf	E26
TODBC_rezultat_BRISANJE	EODBCExecuteSQL( numhandler,"DELETE * FROM T_I13_D")
Tnapredak_bargraf	E28
TODBC_rezultat_BRISANJE	EODBCExecuteSQL( numhandler,"DELETE * FROM T_I14_D")
Tnapredak_bargraf	E30
TODBC_rezultat_BRISANJE	EODBCExecuteSQL( numhandler,"DELETE * FROM T_I15_D")
Tnapredak_bargraf	E31
TODBC_rezultat_BRISANJE	EODBCExecuteSQL( numhandler,"DELETE * FROM T_I16_D")
Tnapredak_bargraf	E32
TODBC_rezultat_BRISANJE	EODBCExecuteSQL( numhandler,"DELETE * FROM T_I17_D")
Tnapredak_bargraf	E33
TODBC_rezultat	EODBCExecuteSQL( numhandler,"INSERT INTO T_I0_D  (DATUM_VRIJEME,PROSJECNA,[MAX],[Min]) SELECT Format(t1.time_stamp,'dd\.mm\.yyyy'),Avg(T1.I0),Max(T1.I0),Min(T1.I0)FROM T1 WHERE (((Day(Date())-Day([t1].[time_stamp]))<=7)) GROUP BY Format(t1.time_stamp,'dd\.mm\.yyyy');")
Tnapredak_bargraf	E34
TODBC_rezultat	EODBCExecuteSQL( numhandler,"INSERT INTO T_I1_D  (DATUM_VRIJEME,PROSJECNA,[MAX],[Min]) SELECT Format(t1.time_stamp,'dd\.mm\.yyyy'),Avg(T1.I1),Max(T1.I1),Min(T1.I1)FROM T1 WHERE (((Day(Date())-Day([t1].[time_stamp]))<=7)) GROUP BY Format(t1.time_stamp,'dd\.mm\.yyyy');")
Tnapredak_bargraf	E35
TODBC_rezultat	EODBCExecuteSQL( numhandler,"INSERT INTO T_I2_D  (DATUM_VRIJEME,PROSJECNA,[MAX],[Min]) SELECT Format(t1.time_stamp,'dd\.mm\.yyyy'),Avg(T1.I2),Max(T1.I2),Min(T1.I2)FROM T1 WHERE (((Day(Date())-Day([t1].[time_stamp]))<=7)) GROUP BY Format(t1.time_stamp,'dd\.mm\.yyyy');")
Tnapredak_bargraf	E36
TODBC_rezultat	EODBCExecuteSQL( numhandler,"INSERT INTO T_I3_D  (DATUM_VRIJEME,PROSJECNA,[MAX],[Min]) SELECT Format(t1.time_stamp,'dd\.mm\.yyyy'),Avg(T1.I3),Max(T1.I3),Min(T1.I3)FROM T1 WHERE (((Day(Date())-Day([t1].[time_stamp]))<=7)) GROUP BY Format(t1.time_stamp,'dd\.mm\.yyyy');")
Tnapredak_bargraf	E38
TODBC_rezultat	EODBCExecuteSQL( numhandler,"INSERT INTO T_I4_D  (DATUM_VRIJEME,PROSJECNA,[MAX],[Min]) SELECT Format(t1.time_stamp,'dd\.mm\.yyyy'),Avg(T1.I4),Max(T1.I4),Min(T1.I4)FROM T1 WHERE (((Day(Date())-Day([t1].[time_stamp]))<=7)) GROUP BY Format(t1.time_stamp,'dd\.mm\.yyyy');")
Tnapredak_bargraf	E40
TODBC_rezultat	EODBCExecuteSQL( numhandler,"INSERT INTO T_I5_D  (DATUM_VRIJEME,PROSJECNA,[MAX],[Min]) SELECT Format(t1.time_stamp,'dd\.mm\.yyyy'),Avg(T1.I5),Max(T1.I5),Min(T1.I5)FROM T1 WHERE (((Day(Date())-Day([t1].[time_stamp]))<=7)) GROUP BY Format(t1.time_stamp,'dd\.mm\.yyyy');")
Tnapredak_bargraf	E45
TODBC_rezultat	EODBCExecuteSQL( numhandler,"INSERT INTO T_I6_D  (DATUM_VRIJEME,PROSJECNA,[MAX],[Min]) SELECT Format(t1.time_stamp,'dd\.mm\.yyyy'),Avg(T1.I6),Max(T1.I6),Min(T1.I6)FROM T1 WHERE (((Day(Date())-Day([t1].[time_stamp]))<=7)) GROUP BY Format(t1.time_stamp,'dd\.mm\.yyyy');")
Tnapredak_bargraf	E50
TODBC_rezultat	EODBCExecuteSQL( numhandler,"INSERT INTO T_I7_D  (DATUM_VRIJEME,PROSJECNA,[MAX],[Min]) SELECT Format(t1.time_stamp,'dd\.mm\.yyyy'),Avg(T1.I7),Max(T1.I7),Min(T1.I7)FROM T1 WHERE (((Day(Date())-Day([t1].[time_stamp]))<=7)) GROUP BY Format(t1.time_stamp,'dd\.mm\.yyyy');")
Tnapredak_bargraf	E55
TODBC_rezultat	EODBCExecuteSQL( numhandler,"INSERT INTO T_I8_D  (DATUM_VRIJEME,PROSJECNA,[MAX],[Min]) SELECT Format(t1.time_stamp,'dd\.mm\.yyyy'),Avg(T1.I8),Max(T1.I8),Min(T1.I8)FROM T1 WHERE (((Day(Date())-Day([t1].[time_stamp]))<=7)) GROUP BY Format(t1.time_stamp,'dd\.mm\.yyyy');")
Tnapredak_bargraf	E60
TODBC_rezultat	EODBCExecuteSQL( numhandler,"INSERT INTO T_I9_D  (DATUM_VRIJEME,PROSJECNA,[MAX],[Min]) SELECT Format(t1.time_stamp,'dd\.mm\.yyyy'),Avg(T1.I9),Max(T1.I9),Min(T1.I9)FROM T1 WHERE (((Day(Date())-Day([t1].[time_stamp]))<=7)) GROUP BY Format(t1.time_stamp,'dd\.mm\.yyyy');")
Tnapredak_bargraf	E65
TODBC_rezultat	EODBCExecuteSQL( numhandler,"INSERT INTO T_I10_D  (DATUM_VRIJEME,PROSJECNA,[MAX],[Min]) SELECT Format(t1.time_stamp,'dd\.mm\.yyyy'),Avg(T1.I10),Max(T1.I10),Min(T1.I10)FROM T1 WHERE (((Day(Date())-Day([t1].[time_stamp]))<=7)) GROUP BY Format(t1.time_stamp,'dd\.mm\.yyyy');")
Tnapredak_bargraf	E70
TODBC_rezultat	EODBCExecuteSQL( numhandler,"INSERT INTO T_I11_D  (DATUM_VRIJEME,PROSJECNA,[MAX],[Min]) SELECT Format(t1.time_stamp,'dd\.mm\.yyyy'),Avg(T1.I11),Max(T1.I11),Min(T1.I11)FROM T1 WHERE (((Day(Date())-Day([t1].[time_stamp]))<=7)) GROUP BY Format(t1.time_stamp,'dd\.mm\.yyyy');")
Tnapredak_bargraf	E75
TODBC_rezultat	EODBCExecuteSQL( numhandler,"INSERT INTO T_I12_D  (DATUM_VRIJEME,PROSJECNA,[MAX],[Min]) SELECT Format(t1.time_stamp,'dd\.mm\.yyyy'),Avg(T1.I12),Max(T1.I12),Min(T1.I12)FROM T1 WHERE (((Day(Date())-Day([t1].[time_stamp]))<=7)) GROUP BY Format(t1.time_stamp,'dd\.mm\.yyyy');")
Tnapredak_bargraf	E80
TODBC_rezultat	EODBCExecuteSQL( numhandler,"INSERT INTO T_I13_D  (DATUM_VRIJEME,PROSJECNA,[MAX],[Min]) SELECT Format(t1.time_stamp,'dd\.mm\.yyyy'),Avg(T1.I13),Max(T1.I13),Min(T1.I13)FROM T1 WHERE (((Day(Date())-Day([t1].[time_stamp]))<=7)) GROUP BY Format(t1.time_stamp,'dd\.mm\.yyyy');")
Tnapredak_bargraf	E85
TODBC_rezultat	EODBCExecuteSQL( numhandler,"INSERT INTO T_I14_D  (DATUM_VRIJEME,PROSJECNA,[MAX],[Min]) SELECT Format(t1.time_stamp,'dd\.mm\.yyyy'),Avg(T1.I14),Max(T1.I14),Min(T1.I14)FROM T1 WHERE (((Day(Date())-Day([t1].[time_stamp]))<=7)) GROUP BY Format(t1.time_stamp,'dd\.mm\.yyyy');")
Tnapredak_bargraf	E90
TODBC_rezultat	EODBCExecuteSQL( numhandler,"INSERT INTO T_I15_D  (DATUM_VRIJEME,PROSJECNA,[MAX],[Min]) SELECT Format(t1.time_stamp,'dd\.mm\.yyyy'),Avg(T1.I15),Max(T1.I15),Min(T1.I15)FROM T1 WHERE (((Day(Date())-Day([t1].[time_stamp]))<=7)) GROUP BY Format(t1.time_stamp,'dd\.mm\.yyyy');")
Tnapredak_bargraf	E91
TODBC_rezultat	EODBCExecuteSQL( numhandler,"INSERT INTO T_I16_D  (DATUM_VRIJEME,PROSJECNA,[MAX],[Min]) SELECT Format(t1.time_stamp,'dd\.mm\.yyyy'),Avg(T1.I16),Max(T1.I16),Min(T1.I16)FROM T1 WHERE (((Day(Date())-Day([t1].[time_stamp]))<=7)) GROUP BY Format(t1.time_stamp,'dd\.mm\.yyyy');")
Tnapredak_bargraf	E92
TODBC_rezultat	EODBCExecuteSQL( numhandler,"INSERT INTO T_I17_D  (DATUM_VRIJEME,PROSJECNA,[MAX],[Min]) SELECT Format(t1.time_stamp,'dd\.mm\.yyyy'),Avg(T1.I17),Max(T1.I17),Min(T1.I17)FROM T1 WHERE (((Day(Date())-Day([t1].[time_stamp]))<=7)) GROUP BY Format(t1.time_stamp,'dd\.mm\.yyyy');")
Tnapredak_bargraf	E93
TODBC_rezultat_BRISANJE	EODBCExecuteSQL( numhandler,"DELETE * FROM PI;")
Tnapredak_bargraf	E95
TODBC_rezultat	EODBCExecuteSQL( numhandler,"INSERT INTO PI ( vrsta ) SELECT 7;")
Tnapredak_bargraf	E98
Ttrazenje	EFindFile("C:\SPSS\Project07\Grupa01\Bloomberg\web\sedmicni_izvjestaj_indeksi.htm")
T	Eif(trazenje>0,FileDelete("C:\SPSS\Project07\Grupa01\Bloomberg\web\sedmicni_izvjestaj_indeksi.htm"))
Trezultat_winexec	Eif(aktivna_baza=1,WinExec(excel+" "+iindeksi,1,1),if(aktivna_baza=2,WinExec(excel+" "+iindeksi2,1,1)))
Tnapredak_bargraf	E100
Tnapravi_tabele_izvjestaj	E-7
