Shell Programming and Scripting

input1

Code:

a1	1	10	1E_gx007
a1	20	30	2E_gx007
a1	50	60	3E_gx007

input2

Code:

a1	8	10	J1	100	gx007
a1	20	22	J1	120	gx007
a1	6	10	J2	200	gx007
a1	52	54	J2	220	gx007
a1	28	30	J3	300	gx007
a1	50	54	J3	320	gx007

output

Code:

a1	1	10	1E_gx007	a1	8	10	J1	100	gx007	2	connected
a1	20	30	2E_gx007	a1	20	22	J1	120	gx007	2	connected
a1	1	10	1E_gx007	a1	6	10	J2	200	gx007	2	notconnected
a1	50	60	3E_gx007	a1	52	54	J2	220	gx007	2	notconnected
a1	20	20	2E_gx007	a1	28	30	J3	300	gx007	2	connected
a1	50	60	3E_gx007	a1	50	54	J3	320	gx007	2	connected

if the 1st and 4th columns (a1 and gx007(ignore 1E_)) of input1 are similar to 1st and 6th columns of input2 (a1 and gx007)
intersect values of 2nd and 3rd columns of input1 (1 and 10) with all the values of 2nd and 3r columns of input2 and print
them in output with a specific name "connected" if they joined together (ex:1E_gx007-2E_gx007-2E_gx007-3E_gx007) and if not
"disconnected" (1E_gx007-3E_gx007)

And 11th column in output came from values of 5th column of input2 after a simple calculation. that is
connected values/connected+disconnected vaues i.e. ((100+120)+(300+320)) / (200+220) = 2

Hope evry thing is clear enough. Pardon if there is anothing confusing. Please let me know if trouble understanding the question