search

omar733 / company-time-sheet

Automatically exported from code.google.com/p/company-time-sheet
0 stars 0 forks source link

NEED SP FOR ABSENT TRIGGER. #85

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
CREATE SP TO PUT ABSENT REPORT.

TAKE ALL ACTIVE LOGIN ID , NOT ENTERED REPORT AND PUT ABSENT FOR THAT LOGIN 
ID'S

Original issue reported on code.google.com by SAFIYULL...@ssomens.com on 11 Sep 2014 at 8:44

GoogleCodeExporter commented 9 years ago 

need SP or view to give absent count for given month for all active login 
id.count that absent flag.

Original comment by SAFIYULL...@ssomens.com on 12 Sep 2014 at 10:27

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 12 Sep 2014 at 11:20

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO 2 CREATED THE SP TO PUT ABSENT FOR ACTIVE USERS IF USERS NOT 
ENTER DAILY REPORT.

FILE NAME:
SP_TS_REPORT_AUTO_ABSENT_INSERT_VER_0.1_85_2_13092014.sql

DRIVE LINK:
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0B_f0d7mdbV_UZ3pXN24yOW1a
YVU

Original comment by raja.gun...@ssomens.com on 13 Sep 2014 at 9:44

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 15 Sep 2014 at 3:49

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO 2 CREATED SP FOR COUNT THE ABSENT FLAG ON GIVEN MONTH FOR ALL 
ACTIVE USERS.

FILE NAME:
SP_TS_REPORT_COUNT_ABSENT_FLAG_VER_0.1_85_2_15092014

DRIVE LINK:
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0B_f0d7mdbV_UZ3pXN24yOW1a
YVU

Original comment by raja.gun...@ssomens.com on 15 Sep 2014 at 10:41

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 15 Sep 2014 at 10:45

GoogleCodeExporter commented 9 years ago 
need out put table for who are all absent that day.in auto_absent_insert sp.

Original comment by SAFIYULL...@ssomens.com on 15 Sep 2014 at 12:53

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO 7 CREATED OUTPUT TEMP TABLE IN THE ABSENT INSERT SP FOR 
SHOWING ABSENT ACTIVE USERS.

FILE NAME:
SP_TS_REPORT_AUTO_ABSENT_INSERT_VER_0.2_85_7_16092014

DRIVE LINK:
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0B_f0d7mdbV_UZ3pXN24yOW1a
YVU

Original comment by raja.gun...@ssomens.com on 16 Sep 2014 at 7:14

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 16 Sep 2014 at 7:17

GoogleCodeExporter commented 9 years ago

Original comment by SAFIYULL...@ssomens.com on 17 Sep 2014 at 3:47

GoogleCodeExporter commented 9 years ago 
sp for absent count for selected month for all login id presented that selected 
month.update that sp

Original comment by SAFIYULL...@ssomens.com on 17 Sep 2014 at 10:01

GoogleCodeExporter commented 9 years ago 
sp for absent count for selected month for all login id presented that selected 
month.update that sp

Original comment by SAFIYULL...@ssomens.com on 17 Sep 2014 at 10:01

GoogleCodeExporter commented 9 years ago

Original comment by raja.gun...@ssomens.com on 17 Sep 2014 at 10:04

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO 2 CHANGED SP FOR COUNT ABSENT FLAG FOR ALL USER IN THE GIVEN 
MONTH.

FILE NAME:
SP_TS_REPORT_COUNT_ABSENT_FLAG_VER_0.2_85_12_17092014

DRIVE LINK:
https://drive.google.com/a/ssomens.com/#folders/0B_f0d7mdbV_UZ3pXN24yOW1aYVU

Original comment by raja.gun...@ssomens.com on 17 Sep 2014 at 11:37

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 17 Sep 2014 at 11:43

GoogleCodeExporter commented 9 years ago

Original comment by SAFIYULL...@ssomens.com on 17 Sep 2014 at 11:50

GoogleCodeExporter commented 9 years ago 
in absent trigger change the reason as 'REPORT MISSED TO ENTER' INSTEAD OF 
'ABSENT'

Original comment by SAFIYULL...@ssomens.com on 12 Dec 2014 at 12:15

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 13 Dec 2014 at 4:01

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT #17 CHANGED ABSENT TRIGGER SP

DRIVE 
LINK:https://drive.google.com/a/ssomens.com/?tab=mo#folders/0Bwv4Rd7ZecjPTUloOXg
wOVhOdFU

FILE NAME:SP_TS_REPORT_AUTO_ABSENT_INSERT_VER_0.3_85_17_13122014.SQL

Original comment by dhivya.a...@ssomens.com on 13 Dec 2014 at 5:07

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 13 Dec 2014 at 5:09