search

omar733 / company-time-sheet

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

CREATE SP FOR USER/ADMIN DAILY REPORT ENTRY #80

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
CREATE SP FOR USER/ADMIN DAILY REPORT ENTRY FORM.

SP PROCEDURE UPDATED IN BELOW LINK

https://docs.google.com/a/ssomens.com/spreadsheets/d/1-iMaAl89HmVHO0ZqdQoPENGPyK
yL7pH_RYdVsWCkMIs/edit#gid=518367718

Original issue reported on code.google.com by SAFIYULL...@ssomens.com on 20 Aug 2014 at 4:27

GoogleCodeExporter commented 9 years ago 
TASK OWNER:RAJA

Original comment by dhivya.a...@ssomens.com on 20 Aug 2014 at 4:41

GoogleCodeExporter commented 9 years ago

Original comment by RAJALAKS...@ssomens.com on 3 Sep 2014 at 5:30

GoogleCodeExporter commented 9 years ago

Original comment by bhavani....@ssomens.com on 3 Sep 2014 at 5:35

GoogleCodeExporter commented 9 years ago 
create sp for report search/update form

Original comment by SAFIYULL...@ssomens.com on 4 Sep 2014 at 4:44

GoogleCodeExporter commented 9 years ago

Original comment by bhavani....@ssomens.com on 4 Sep 2014 at 4:46

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT 3 COMPLETED INSERTION SP FOR DAILY REPORT FORM BY THE FOLLOWING 
SPREADSHEET.

FOLDER NAME: TS-REPORT PROJECT

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

FILE NAME : 1. SP_TS_DAILY_REPORT_INSERT_VER_0.1_80_3_08092014.SQL

SS NAME: TIMESHEET SPEC

SS LINK: 
https://docs.google.com/a/ssomens.com/spreadsheets/d/1-iMaAl89HmVHO0ZqdQoPENGPyK
yL7pH_RYdVsWCkMIs/edit#gid=518367718

Original comment by bhavani....@ssomens.com on 8 Sep 2014 at 5:34

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT 5 COMPLETED UPDATION SP FOR DAILY REPORT FORM.

FOLDER NAME : TS-REPORT PROJECT

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

FILE NAME : SP_TS_DAILY_REPORT_SEARCH_UPDATE_VER_0.1_80_5_08092014.SQL

Original comment by bhavani....@ssomens.com on 8 Sep 2014 at 5:36

GoogleCodeExporter commented 9 years ago 
test the delivery in comment no#6,7

Original comment by RAJALAKS...@ssomens.com on 8 Sep 2014 at 5:38

GoogleCodeExporter commented 9 years ago 
In updation sp, add date cloumn also to update

Original comment by SAFIYULL...@ssomens.com on 15 Sep 2014 at 9:10

GoogleCodeExporter commented 9 years ago

Original comment by SAFIYULL...@ssomens.com on 15 Sep 2014 at 11:01

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO 10 ADDED THE DATE COLUMN IN REPORT SEARCH AND UPDATE SP FOR 
UPDATION.

FILE NAME:
SP_TS_DAILY_REPORT_SEARCH_UPDATE_VER_0.2_80_10_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 12:40

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 15 Sep 2014 at 12:55

GoogleCodeExporter commented 9 years ago 
update report entry form sp to save the report for given data range also.

if one date means one report
if date range means for that range need to save report for that login id

Original comment by SAFIYULL...@ssomens.com on 17 Sep 2014 at 8:49

GoogleCodeExporter commented 9 years ago 
NOTE:

ENTERING REPORT FROM 1/9/2014 TO 10/09/2014, FOR THESE 10 DAYS FROM FORM U LL 
GET ONE REASON AND TWO DAYS, BUT UR SP SHLD INSERT THESE 10 DAYS SEPARATELY.
ALSO THIS SHLD APPLICABLE FOR ONLY ABSENT/ONDUTY.

Original comment by DHANDAPA...@ssomens.com on 17 Sep 2014 at 9:00

GoogleCodeExporter commented 9 years ago

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

GoogleCodeExporter commented 9 years ago 
raja,

Deliver this without defect asap. dont take 100 days!!!!!!!!!!!!!!!!

Original comment by DHANDAPA...@ssomens.com on 18 Sep 2014 at 5:16

GoogleCodeExporter commented 9 years ago 
K SIR

Original comment by raja.gun...@ssomens.com on 18 Sep 2014 at 5:18

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO 10 MODIFIED THE DAILY REPORT INSERT SP FOR INSERT REPORT FOR 
GIVEN DATE RANGE.

FILE NAME:
SP_TS_DAILY_REPORT_INSERT_VER_0.2_80_13_17092014

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

Original comment by raja.gun...@ssomens.com on 18 Sep 2014 at 10:22

GoogleCodeExporter commented 9 years ago 
I NEED TO CHECK THE CONDITION FOR MULTIPLE DATE ENTRY IN DAILY REPORT ENTRY FOR 
ONLY IN ONDUTY AND ABSENT

Original comment by raja.gun...@ssomens.com on 19 Sep 2014 at 4:09

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO 10 CHECKED THE CONDITION FOR MULTIPLE DATE ENTRY IN DAILY 
REPORT ENTRY FOR ONLY IN ONDUTY AND ABSENT.

FILE NAME:
SP_TS_DAILY_REPORT_INSERT_VER_0.3_80_19_19092014

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

Original comment by raja.gun...@ssomens.com on 19 Sep 2014 at 5:00

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 19 Sep 2014 at 5:02

GoogleCodeExporter commented 9 years ago 
need trigger for after delete (USER_ADMIN_REPORT_DETAILS)-need to update 
tickler history

Original comment by SAFIYULL...@ssomens.com on 20 Sep 2014 at 12:23

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO 22 CREATED SINGLE ROW DELETION SP FOR USER ADMIN REPORT 
DETAILS INSTEAD OF AFTER DELETION BCS AFTER DELETION TRIGGER CANT ACCEPT THE 
NEW VALUES FOR USER STAMP.

FILE NAME:
SP_TS_SINGLE_TABLE_ROW_DELETION_VER_0.1_80_22_22092014

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

Original comment by raja.gun...@ssomens.com on 22 Sep 2014 at 12:39

GoogleCodeExporter commented 9 years ago 
UPDATE REPORT ENTRY FORM SP ,FOR GIVEN DATE RANGE UPDATE REASON FOR ALL ACTIVE 
LOGIN ID.

Original comment by SAFIYULL...@ssomens.com on 26 Sep 2014 at 5:00

GoogleCodeExporter commented 9 years ago 
IN REPORT SEARCH/UPDATE SP NEED TO UPDATE ABSENT FLAG, FOR ADMIN ONLY NOT FOR 
USER.

Original comment by SAFIYULL...@ssomens.com on 26 Sep 2014 at 5:42

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 26 Sep 2014 at 11:04

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 26 Sep 2014 at 11:05

GoogleCodeExporter commented 9 years ago

Original comment by raja.gun...@ssomens.com on 26 Sep 2014 at 12:28

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO 25 ADDED THE ABSENT_FLAG FIELD IN REPORT SEARCH AND UPDATE SP 
FOR UPDATE BY ADMIN ONLY NOT FOR USER.

FILE NAME:
SP_TS_DAILY_REPORT_SEARCH_UPDATE_VER_0.3_80_25_27092014

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

Original comment by raja.gun...@ssomens.com on 27 Sep 2014 at 4:34

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT #24 

COMPLETED REPORT ENTRY FORM SP,FOR GIVEN DATE RANGE UPDATE REASON FOR ALL 
ACTIVE LOGIN ID.

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

FILE NAME:SP_TS_DAILY_REPORT_INSERT_VER0.4_80_24_26092014.SQL

Original comment by dhivya.a...@ssomens.com on 29 Sep 2014 at 4:44

GoogleCodeExporter commented 9 years ago 
TEST THE DELIVERY IN THE COMMENT #30

Original comment by dhivya.a...@ssomens.com on 29 Sep 2014 at 4:45

GoogleCodeExporter commented 9 years ago 
ALL CHECK CONSTRAINTS ERROR_MSGS SHOULD IMPLEMENT IN SP SIDE ALSO

REPORT INSERT & UPDATE-DIV
PROJECT STATUS INSERT & UPDATE-RL

Original comment by dhivya.a...@ssomens.com on 29 Sep 2014 at 7:05

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 30 Sep 2014 at 9:59

GoogleCodeExporter commented 9 years ago 
WORKING ON EI TASK(UNIT UPDATE SP ISSUE 346 CMT #320)

Original comment by dhivya.a...@ssomens.com on 30 Sep 2014 at 10:38

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 1 Oct 2014 at 7:04

GoogleCodeExporter commented 9 years ago 
@RAJA

SP_TS_SINGLE_TABLE_ROW_DELETION_VER_0.1_80_22_22092014

WHILE TAKING COLUMN HEADER FROM INFORMATION SCHEMA.COLUMNS ADD 
TABLE_SCHEMA=SELECT DATABASE()

CHANGE WHICH R THE SP'S LIKE THIS U R USING IN TS SP & DELIVER

Original comment by dhivya.a...@ssomens.com on 1 Oct 2014 at 7:17

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO 36 ADDED TABLE_SCHEMA=SELECT DATABASE() IN THE SINGLE ROW 
DELETION SP.

FILE NAME:
SP_TS_SINGLE_TABLE_ROW_DELETION_VER_0.2_80_36_01102014

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

Original comment by raja.gun...@ssomens.com on 1 Oct 2014 at 10:53

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 3 Oct 2014 at 9:53

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT #32

ALL CHECK CONSTRAINTS ERROR_MSGS IMPLEMENTED IN REPORT SEARCH & UPDATE SP

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

FILE NAME:SP_TS_DAILY_REPORT_INSERT_VER_0.5_80_32_30092014.SQL
FILE NAME:SP_TS_DAILY_REPORT_SEARCH_UPDATE_VER_0.5_80_32_03102014.SQL

Original comment by dhivya.a...@ssomens.com on 3 Oct 2014 at 10:55

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 3 Oct 2014 at 10:55

GoogleCodeExporter commented 9 years ago 

UPDATE REPORT ENTRY SP

FOR GIVEN DATE RANGE UPDATE REASON FOR ALL ACTIVE LOGIN ID EXCEPT SUPER ADMIN

Original comment by dhivya.a...@ssomens.com on 6 Oct 2014 at 11:12

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 6 Oct 2014 at 12:12

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT #41

FOR GIVEN DATE RANGE UPDATED REASON FOR ALL ACTIVE LOGIN ID EXCEPT SUPER ADMIN 
IN REPORT ENTRY SP

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

FILE NAME:SP_TS_DAILY_REPORT_INSERT_VER_0.6_80_42_06102014.SQL

Original comment by dhivya.a...@ssomens.com on 6 Oct 2014 at 12:35

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 6 Oct 2014 at 12:36

GoogleCodeExporter commented 9 years ago

Original comment by SAFIYULL...@ssomens.com on 7 Oct 2014 at 5:04