search

omar733 / company-time-sheet

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

NEED SP TO CALCULATE ATTENDANCE (FOR GIVEN EMPLOYEE FOR SELECTED MONTH) #88

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
NEED SP TO CALCULATE ATTENDANCE (FOR GIVEN EMPLOYEE FOR SELECTED MONTH)- 
CALCULATE PERSENT , ABSENT,ONDUTY AND PERMISSION.

Original issue reported on code.google.com by SAFIYULL...@ssomens.com on 25 Sep 2014 at 4:18

GoogleCodeExporter commented 9 years ago

Original comment by RAJALAKS...@ssomens.com on 25 Sep 2014 at 4:20

GoogleCodeExporter commented 9 years ago 
also need to calculate attendance for all ( for selected month)

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

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO 1 CREATED SP FOR CALCULATE ATTENDANCE FOR GIVEN USER AND ALL 
USERS FOR SELECTED MONTH AND CALCULATE NO OF DAYS,PERSENT,ABSENT,ONDUTY AND 
PERMISSION.

FILE NAME:
SP_TS_ATTENDANCE_CALCULATION_VER_0.1_88_1_26092014

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

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

GoogleCodeExporter commented 9 years ago 
for given login id and month- need present absent for individual day

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

GoogleCodeExporter commented 9 years ago

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

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO 4 SHOWN ALL THE ATTENDANCE RECORDS IN TEMP TABLE FOR SELECTED 
MONTH FOR THE GIVEN USER.

FILE NAME:
SP_TS_ATTENDANCE_CALCULATION_VER_0.2_88_4_29092014

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

Original comment by raja.gun...@ssomens.com on 29 Sep 2014 at 12:45

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

Original comment by dhivya.a...@ssomens.com on 30 Sep 2014 at 3:54

GoogleCodeExporter commented 9 years ago 
SHOW THE DATE WITH DAY(30-09-2014,TUE) LIKE THAT, CHANGE AND DELIVER

Original comment by SAFIYULL...@ssomens.com on 30 Sep 2014 at 11:47

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO 8 DISPLAYED THE WEEKDAYS FOR THE DATES IN THE SINGE USER 
REPORT TABLE AND RETURN THE NO OF DAYS IN A MONTH.

FILE NAME:
SP_TS_ATTENDANCE_CALCULATION_VER_0.3_88_8_30092014

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

Original comment by raja.gun...@ssomens.com on 30 Sep 2014 at 2:02

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 1 Oct 2014 at 5:52

GoogleCodeExporter commented 9 years ago

Original comment by SAFIYULL...@ssomens.com on 1 Oct 2014 at 5:53

GoogleCodeExporter commented 9 years ago 
WRITE SP TO SHOW
1. FOR SELECTED PROJECT , HOW MANY DAYS WORKED AND WHO ARE WORKED IN THAT 
PROJECT
2. FOR SELECTED EMPLOYEE , WHAT ARE THE PROJECT THEY WORKED WITH DATE

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

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 3 Oct 2014 at 11:44

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT #12 COMPLETED SP 

1.FOR SELECTED PROJECT , HOW MANY DAYS WORKED AND WHO ARE WORKED IN THAT PROJECT
2.FOR SELECTED EMPLOYEE , WHAT ARE THE PROJECT THEY WORKED WITH DATE

DRIVE 
LINK:https://drive.google.com/a/ssomens.com/?tab=mo#folders/0B_f0d7mdbV_UczE3STU
3TTRtYzg

FILE NAME: SP_PROJECT_REVENUE_BY_EMPLOYEE_VER0.1_88_12_06102014.SQL
FILE NAME: SP_PROJECT_REVENUE_BY_PROJECT_NAME_VER_0.1_88_12_06102014.SQL

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

GoogleCodeExporter commented 9 years ago

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

GoogleCodeExporter commented 9 years ago 
need to calculate 
total of days worked for selection project,
show only worked employee for selected project,
how many days employee worked on selected project and how many project they 
worked.

Original comment by SAFIYULL...@ssomens.com on 9 Oct 2014 at 1:13

GoogleCodeExporter commented 9 years ago

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

GoogleCodeExporter commented 9 years ago

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

GoogleCodeExporter commented 9 years ago 
CALCULATE BANDWIDTH AS PER UPDATED IN BELOW LINK:

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

Original comment by SAFIYULL...@ssomens.com on 15 Oct 2014 at 10:14

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 15 Oct 2014 at 10:31

GoogleCodeExporter commented 9 years ago 
AS PER cmt 16 project revenue sp updated

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

file name:SP_PROJECT_REVENUE_BY_EMPLOYEE_VER0.2_88_16_16102014.SQL
file name:SP_PROJECT_REVENUE_BY_PROJECT_NAME_VER_0.2_88_16_13102014.SQL

Original comment by dhivya.a...@ssomens.com on 16 Oct 2014 at 7:52

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 16 Oct 2014 at 7:52

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO 19 COMPLETED SP FOR CALCULATE BANDWIDTH USAGE BY EMPLOYEES.

FILE NAME:
SP_TS_REPORT_BANDWIDTH_CALCULATION_VER_0.1_88_19_15102014

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 Oct 2014 at 8:13

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 16 Oct 2014 at 8:45

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 16 Oct 2014 at 9:27

GoogleCodeExporter commented 9 years ago

Original comment by bhavani....@ssomens.com on 16 Oct 2014 at 9:30

GoogleCodeExporter commented 9 years ago 
in revenue sp include search by between date also for selected project.

Original comment by SAFIYULL...@ssomens.com on 16 Oct 2014 at 9:56

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 16 Oct 2014 at 10:01

GoogleCodeExporter commented 9 years ago 
WORKING ON ISSUE 78 CMT 168

Original comment by dhivya.a...@ssomens.com on 16 Oct 2014 at 11:22

GoogleCodeExporter commented 9 years ago

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

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT 25 COMPLETED TESTING SP_TS_REPORT_BANDWIDTH_CALCULATION AND IS 
WORKING FINE.

Original comment by bhavani....@ssomens.com on 16 Oct 2014 at 12:13

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT 19 CREATED VIEW FOR CALCULATE BANDWIDTH USER FOR GIVEN MONTH FOR 
USER

FILE NAME:
TS_VW_REPORT_BANDWIDTH_CALCULATION_VER_0.1_88_19_17102014

DRIVE LINK:
https://drive.google.com/drive/#folders/0B_f0d7mdbV_Ud0RKSGpJZ0V3enM/0B_f0d7mdbV
_Ub
jFlb1dheFctdmM/0B_f0d7mdbV_UN2RlVHEzMmppaU0/0B_f0d7mdbV_UZ3pXN24yOW1aYVU

Original comment by raja.gun...@ssomens.com on 17 Oct 2014 at 2:05

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 18 Oct 2014 at 4:46

GoogleCodeExporter commented 9 years ago

Original comment by bhavani....@ssomens.com on 18 Oct 2014 at 4:52

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT 34 COMPLETED TESTING TS_VW_REPORT_BANDWIDTH_CALCULATION AND IS 
WORKING FINE.

Original comment by bhavani....@ssomens.com on 18 Oct 2014 at 6:49

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT #27 PROJECT REVENUE SP UPDATED 

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

FILE NAME:SP_PROJECT_REVENUE_BY_PROJECT_NAME_VER_0.3_88_27_17102014.S

Original comment by dhivya.a...@ssomens.com on 18 Oct 2014 at 9:19

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 18 Oct 2014 at 9:20

GoogleCodeExporter commented 9 years ago

Original comment by bhavani....@ssomens.com on 18 Oct 2014 at 9:23

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT 37 COMPLETED TESTING 
SP_PROJECT_REVENUE_BY_PROJECT_NAME_VER_0.3_88_27_17102014 AND IS WORKING FINE.

Original comment by bhavani....@ssomens.com on 18 Oct 2014 at 11:51

GoogleCodeExporter commented 9 years ago 
Need sp to drop temp table. REUse EI temp table drop sp and update,sp will call 
daily

Original comment by SAFIYULL...@ssomens.com on 6 Nov 2014 at 4:34

GoogleCodeExporter commented 9 years ago

Original comment by RAJALAKS...@ssomens.com on 6 Nov 2014 at 4:40

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO#40 TEMP TABLE DROP SP COMPLETED

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

FILE NAME : SP_TS_DROP_PROD_TEMP_TABLE_VER_0.1_88_40_06112014.SQL

Original comment by RAJALAKS...@ssomens.com on 6 Nov 2014 at 6:46

GoogleCodeExporter commented 9 years ago 
TEST THE DELIVERY IN COMMENT NO#42

Original comment by RAJALAKS...@ssomens.com on 6 Nov 2014 at 6:46

GoogleCodeExporter commented 9 years ago 
 REVENUE sp need to calculate like this

IF A STAFF WORKED IN 3 PROJECT IN A DAY, WE SHLD SHARE THE DAY , DONT SHOW 3 
DAYS FOR EACH PROJECT.

Original comment by SAFIYULL...@ssomens.com on 10 Nov 2014 at 4:04

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 10 Nov 2014 at 6:35

GoogleCodeExporter commented 9 years ago 
STARTED WORKING AS PER COMMENT NO#44

Original comment by RAJALAKS...@ssomens.com on 10 Nov 2014 at 6:37

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT #44

SEARCH BY EMPLOYEE REVENUE- DIV
SEARCH BY PROJECT NAME REVENUE-RL

Original comment by dhivya.a...@ssomens.com on 12 Nov 2014 at 7:01

GoogleCodeExporter commented 9 years ago 
AS PER SN SIR INSTRUCTION

FOR REVENUE CALCULATION. 8 HRS SHOULD TAKE AS ONE DAY.IN A DAY IF EMPLOYEE 
WORKED IN 2 PROJECTS, EACH PROJECT SHOULD CALCULATE LIKE THIS 8/2 =4 HRS.

Original comment by dhivya.a...@ssomens.com on 12 Nov 2014 at 10:01

GoogleCodeExporter commented 9 years ago 
as per comment 47 & 48

search by employee project revenue sp updated(added one put for showing which r 
the project employee worked & how many days they worked in that project)

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

file name:SP_PROJECT_REVENUE_BY_EMPLOYEE_VER0.3_88_47_16102014.sql

Original comment by dhivya.a...@ssomens.com on 13 Nov 2014 at 6:52

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 13 Nov 2014 at 6:52