Algorithm for Preparing Summary Report on Implementation Status of Consulting Contracts


CLASSIFICATION

Nvarchar

50

Customer classification

THE_PERSON_OF_THE_EXCHANGE

Nvarchar

50

Representative

Congratulations

Nvarchar

30

Position

Tax_Code

Nvarchar

50

Tax code

ACCOUNT

Nvarchar

255

Account

NOTES

Nvarchar

255

Note

Maybe you are interested!

CONG_TRINH (List of projects)


School name

Type

school

Wide range

Interpretation

PROJECT_ID

Int


Project code

PROJECT_NAME

Nvarchar

255

Name of construction project

SITES

Nvarchar

255

Location

TYPE OF PROJECT

Nvarchar

50

Type of project

CONSTRUCTION_CAP

Nvarchar

50

Project level

GROUP_OF_PROJECT

Nvarchar

50

Construction group

MANAGEMENT

Nvarchar

50

Management level

SOURCE

Nvarchar

50

Capital

TINH_THANH_ID

Int


Province/City Code

ANGLE

Int


Number of floors

CONSTRUCTION AREA

Float


Construction area

AREA

Float


Floor area

AMOUNT OF_SIZE

Int


Number of basements

AREA

Float


Basement area

Value

Money


Project value

STANDARD

Nvarchar

50

Standard

NOTES

Nvarchar

255

Note

DON_VI (List of company's subsidiaries)


School name

Field type

Wide range

Interpretation

DON_VI_ID

DON_NAME

Int

Nvarchar


255

Department code

Unit name

LOAI_HINH (List of consulting types)


School name

Field type

Wide range

Interpretation

TYPE_IMAGE_ID

TYPE_OF_IMAGE

Int

Nvarchar


50

Consulting type code

Name of construction consulting type

STAFF (List of staff)


School name

Field type

Wide range

Interpretation

EMPLOYEE_ID

NAME

Int

Nvarchar


50

Employee code

Full name


DATE OF BIRTH

DateTime


Date of birth

sex

Nvarchar

1

Sex

Congratulations

Nvarchar

50

Position

PROFESSIONAL_EXPERIENCE

Nvarchar

50

Professional qualifications

NAM_COAT

Int


Years of service

DON_VI_ID

Int


Unit code

QUOC_TICH

Nvarchar

50

Nationality

LISTENING

Nvarchar

50

Job

NOTES

Nvarchar

255

Note

TINH_THANH (List of Provinces/Cities)


School name

Field type

Wide range

Interpretation

TINH_THANH_ID

TITLE NAME

Int

Nvarchar


50

Province/city code

Province/city name

Document Grouping Table


School name

Field type

Wide range

Interpretation

GROUP_DOCUMENT_ID

GROUP_NAME

Int

Nvarchar


50

Document group code

Document group name



Figure 13. DSD diagram of construction consulting contract subsystem


May

Notification

S

§

Check

Total1; Total2;

Total3; Total Product Value

KT


Real Estate

Sort by m units

Total number of contracts = 0; Total1 = 0; Total2 = 0;

Sum3 = 0; i = 1

Number of units=n; j=1

Month(Signing date)=Month

and Year(Signing date)=Year

S

§

§

M units[i] = tg


S

SP value = TGT - TTU - TTL

Unit name; TGT; TTU; TTL;

Value of product

S

j<=n

§

Tg = M units[i] Number of contracts=0; TGT = 0; TTU = 0; TTL = 0

Contract Number = Contract Number + 1; Total Value = Total Value + Contract Value;

TTU = TTU + Advance value; TTL = TTL + Liquidation value

Total1=Total1+TGT; Total2=Total2+TTU; Total3=Total3+TTL; Total SP Value=Total1- Total2- Total3

j = j + 1

i = i + 1

Figure 14 - Algorithm for generating a summary report on the implementation status of consulting contracts



B


Unit code to print


Are not

Find


Have

TGT=0; TTU=0; TTL=0;

i=1


Day 1

Day 2


E


Are not

Have

Next


Check

S

Unit name

Notification


TGT; TTU; TTL

D

S

End of file?


TGT=TGT+Contract value; TTU=TTU+Advance value; TTL=TTL+Liquidation value

S

Unit code = Code


D


Date of implementation>=

Day 1 S

D


Contract number; Project name; Consulting type; Contract value; Provisional value

i = i +1

Liquidation value;

Implementation date <=

Day 2


Figure 15: Algorithm for creating a summary table of construction consulting contracts by unit


Open contract details file Sort by consulting type

B


Year


S

Check

D


Notification


T1=0; T2=0; T3=0; i =1


TGT=0; TTU=0; TTL=0

TG = Consulting Type i Consulting Type Name


B

Are not

Have

Next


j = 1



S

Year of implementation

= Year


D


Contract number; Construction name; Project name; Contract value; Advance payment value; Liquidation value

TGT; TTU; TTL


S D

End of file?


i = i +1



T1 = T1 + TGT T2 = T2 + TTU T3 = T3 + TTL

TGT=TGT+Contract value; TTU=TTU+Advance value; TTL=TTL+Liquidation value

D


j = j +1

Consulting Type = TG

TGT; TTU; TTL S



Figure 16: Algorithm for generating detailed reports of construction consulting contracts by consulting type


i = i +1


B

Day 1; Day 2

S

Check

D

Implementation date >= Day 1

S

D

S

Implementation date <=

Day 2


D


Contract number; Construction name; Project name; Implementing unit; Contract value; Advance payment value; Liquidation value

S

End of file?


D

E

TGT=0; TTU=0; TTL=0

i=0

TGT=TGT+Contract value; TTU=TTU+Advance value; TTL=TTL+Liquidation value

TGT; TTU; TTL

Figure 17. Algorithm for creating a list of consulting contracts over time


B



i = i +1


Start Date <= Current Date

S

D


Completion date >= Current date

S

D


Contract number; Construction name; Project name; Consulting type; Contract value; Advance payment value; Liquidation value

B

End of file?

TGT; TTU; TTL

S

Have

Are not

Next

TGT=0; TTU=0; TTL=0

i = 1

Ratio = Liquidation value/Contract value

TGT=TGT+Contract value; TTU=TTU+Advance value; TTL=TTL+Liquidation value

Figure 18: Algorithm for creating a list of ongoing consulting contracts


SOME INTERFACES OF THE PROGRAM


The administration interface has functions such as adding new and searching for users.



- File management interface



- Interface for managing documents in a tree or table structure

Comment


Agree Privacy Policy *