<% 'id_zakaznik '[kr_zakaznik] if request.servervariables("SERVER_NAME") <> "localhost" then 'počet objednávek strSQL = "update zakaznik set objednavek = (SELECT COUNT(*) from obj where stav = 2 and obj.id_zakaznik = zakaznik.id_zakaznik) WHERE zakaznik.id_zakaznik = " & id_zakaznik conn.execute strSQL 'počet objednávek - storno strSQL = "update zakaznik set objednavek_storno = (SELECT COUNT(*) from obj where stav = 3 and obj.id_zakaznik = zakaznik.id_zakaznik) WHERE zakaznik.id_zakaznik = " & id_zakaznik conn.execute strSQL 'částka prodejek strSQL = "update zakaznik set objednano = (SELECT SUM(cena * ks) FROM s_prodejka2 WHERE id_s_prodejka = ANY (SELECT id_s_prodejka FROM s_prodejka WHERE id_obj = ANY (SELECT id_obj FROM obj WHERE stav = 2 AND obj.id_zakaznik = zakaznik.id_zakaznik))) WHERE zakaznik.id_zakaznik = " & id_zakaznik conn.execute strSQL 'částka prodejek - zisk strSQL = "update zakaznik set objednano_zisk = (SELECT SUM(round((cena - (round((cena_vazena/100)*(dph_cena_vazena+100),1)))*ks,1)) FROM s_prodejka2 WHERE id_s_prodejka = ANY (SELECT id_s_prodejka FROM s_prodejka WHERE id_obj = ANY (SELECT id_obj FROM obj WHERE stav = 2 AND obj.id_zakaznik = zakaznik.id_zakaznik))) WHERE zakaznik.id_zakaznik = " & id_zakaznik conn.execute strSQL 'částka objednávek - storno strSQL = "update zakaznik set objednano_storno = (SELECT SUM(cena * ks) FROM obj2 WHERE id_obj = ANY (SELECT id_obj FROM obj WHERE stav = 3 AND obj.id_zakaznik = zakaznik.id_zakaznik)) WHERE zakaznik.id_zakaznik = " & id_zakaznik conn.execute strSQL end if if kr_zakaznik <> "" then strSQL = "update zakaznik set kr = kr + " & kr_zakaznik & " WHERE id_zakaznik = " & id_zakaznik conn.execute strSQL end if %>