Stepen: Datalab
Pridružen(a): 14/08/2009(UTC)
Komentari: 1
Was thanked: 2 time(s) in 2 post(s)
|
nadzorna ploča - pregled kadrovske evidencije,
ne popuni udio radnika koji imaju status na određeno vrijeme, kad se uradi predpriprema
|
|
|
|
|
|
Stepen: Datalab
Pridružen(a): 14/08/2009(UTC)
Komentari: 0
Was thanked: 1 time(s) in 1 post(s)
|
problem je u kodu dashboarda, buduci da broj radnika na odredjeno vuce na osnovu thr_prsn, a acemploymenttype se upisuje
u thr_prsnjob kada se izabere u parametrima.
Mozes to lako provjeriti sa:
Select p.acworker,et.acname,et.accode from tHR_Prsn P inner join tHR_SetEmployType ET on ET.acName = P.acEmploymentType
accode bi trebao biti prazan.
Dok ne sredimo sistemski najbolje da kreiras novi dashboard a saljem ti kod za njega:
Select * from (Select
(Select count(*) from tHR_Prsn P inner join tHR_SetEmployType ET on ET.acName = P.acEmploymentType where
(P.adDateExit > getdate() or P.adDateExit IS NULL) and P.adDateEnter < getdate()) as #$sqlEmp$#,
(Select count(*) from tHR_Prsnjob P inner join tHR_SetEmployType ET on ET.acName = P.acEmploymentType join thr_prsn pr on pr.acworker=p.acworker where
ET.acCode = `2` and (Pr.adDateExit > getdate() or Pr.adDateExit IS NULL) and Pr.adDateEnter < getdate()) as #$sqlEmpTemp$#,
cast((Select count(*) from tHR_Prsnjob P inner join tHR_SetEmployType ET on ET.acName = P.acEmploymentType join thr_prsn pr on pr.acworker=p.acworker where
ET.acCode = `2` and (Pr.adDateExit > getdate() or Pr.adDateExit IS NULL) and Pr.adDateEnter < getdate())*100.00/case when (Select count(*) from tHR_Prsn P inner join tHR_SetEmployType ET on IsNull(ET.acName, ``) = CASE WHEN IsNull(P.acEmploymentType, ``) = `` THEN `` ELSE P.acEmploymentType END where (P.adDateExit > getdate() or P.adDateExit IS NULL) and P.adDateEnter < getdate()) = 0 then 1 else (Select count(*) from tHR_Prsn P inner join tHR_SetEmployType ET on ET.acName = P.acEmploymentType where
(P.adDateExit > getdate() or P.adDateExit IS NULL) and P.adDateEnter < getdate()) end as decimal(5,2)) as #$msPercentage$#) T
Javi jel ok.
LP
|
|
|
|
|
|
Stepen: Datalab
Pridružen(a): 14/08/2009(UTC)
Komentari: 0
Was thanked: 1 time(s) in 1 post(s)
|
Probao sam na bazi ME, gdje se mogu kreirati elementi i nadzorna ploča,
-ne prikazuje radnike na određrno vrijeme, iako sam na jednom radniku stavio da je na određeno vrijeme
Ali kako napraviti na SE verziji Pantheona?
|
|
|
|
|
|
Stepen: Datalab
Pridružen(a): 14/08/2009(UTC)
Komentari: 0
Was thanked: 1 time(s) in 1 post(s)
|
daj remote postavi pa cemo srediti, nazovi prije toga u DL, reci da imamo dogovoreno.
LP
|
|
|
|
|
|
Stepen: Datalab
Pridružen(a): 14/08/2009(UTC)
Komentari: 0
Was thanked: 1 time(s) in 1 post(s)
|
sredili na remote, za ME verziju i custom dash nisu koristili pravo polje u kadrovima (status umjesto radno mjesto).
Za SE u tabeli tze_setdash, field Sql, zamijeni kod sa onim sto sam ti poslao.
LP
|
|
|
|
|
|
Stepen: Datalab
Pridružen(a): 14/08/2009(UTC)
Komentari: 0
Was thanked: 1 time(s) in 1 post(s)
|
|
|
|
|
|
|
Stepen: Datalab
Pridružen(a): 14/08/2009(UTC)
Komentari: 0
Was thanked: 1 time(s) in 1 post(s)
|
|
|
|
|
|
|
Brza navigacija
Ne možete dodavati nove teme.
Ne možete odgovarati na teme.
Ne možete brisati svoje objave.
Ne možete uređivati svoje objave.
Ne možete kreirati ankete.
Ne možete popunjavati ankete.