CREATE OR REPLACE FUNCTION "SC_Tag".functionparse (
)
RETURNS trigger AS
$body$
DECLARE
t1 timestamp;
t2 timestamp;
dt interval;
tc timestamp;
delta integer;
curval real;
cursum real;
presum real;
result text;
BEGIN
	SELECT * FROM(
	SELECT 	"F_Date", 
			"ID_TagData"
	INTO t1 
	FROM 
	  "SC_Tag"."T_TagData" 
	WHERE "F_TagName_ID" = 3   
	ORDER BY "ID_TagData" DESC LIMIT 2)
	AS foo ORDER BY "ID_TagData" ASC LIMIT 1;
	  
	SELECT  "F_Date", 
			"ID_TagData"
	INTO t2 
	FROM 
	  "SC_Tag"."T_TagData" 
	WHERE "F_TagName_ID" = 3   
	ORDER BY "ID_TagData" DESC LIMIT 1;

	
	IF(t1 >  date(t2)+ time '08:00' AND t1 < date(t2) + time '20:00' 
	AND
    t2 >  date(t2)+ time '08:00' AND t2 < date(t2) + time '20:00')
	THEN
		SELECT 		"F_Date", 
					"ID_TagData"
			INTO tc 
			FROM 	"SC_Tag"."T_TagData" 
			WHERE "F_TagName_ID" = 2  
			ORDER BY "ID_TagData" DESC LIMIT 1;
			IF (tc >  date(t2)+ time '08:00' AND tc < date(t2) + time '20:00' )
				THEN					  	
					  dt = t2 - t1;
					  result = dt;
					  --RETURN ('2 смена '||result);
					  IF (dt <= '00:00:35')
						THEN 
														
							SELECT 	"F_ConvertedValue", 
									"ID_TagData"
							INTO curval 
							FROM 	"SC_Tag"."T_TagData" 
							WHERE "F_TagName_ID" = 3   
							ORDER BY "ID_TagData" DESC LIMIT 1;
						  
							SELECT 	"F_ConvertedValue", 
									"ID_TagData"
							INTO presum 	
							FROM 	"SC_Tag"."T_TagData" 
							WHERE "F_TagName_ID" = 2   AND  "F_ConvertedValue" IS NOT NULL 
							ORDER BY "ID_TagData" DESC LIMIT 1;
						
								IF (tc <t2)
								  THEN
									SELECT EXTRACT (EPOCH FROM dt) 
									INTO delta;
									cursum = curval/delta;
									cursum = presum + cursum;
									INSERT INTO 
										"SC_Tag"."T_TagData"
									  (
										"F_TagName_ID",
										"F_ConvertedValue",
										"F_Date" 
									  )
									VALUES (
										2,
										cursum,
										t2
									  );  
									result = cursum;
									RETURN NEW;
								END IF;
							--return ('hz');
                            RETURN OLD;
						END IF;
			ELSE 
			--t1 записываем за 0	
				INSERT INTO 
										"SC_Tag"."T_TagData"
									  (
										"F_TagName_ID",
										"F_ConvertedValue",
										"F_Date" 
									  )
									VALUES (
										2,
										0,
										t1
									  ); 
                RETURN NEW;
			END IF;
	  
	ELSEIF (t1 > date(t2) - interval '24 hours'+ time '20:00' AND t1 < date(t2) + time '8:00'
	AND
	t2 > date(t2) - interval '24 hours'+ time '20:00' AND t2 < date(t2) + time '8:00')
	THEN
		SELECT 		"F_Date", 
					"ID_TagData"
			INTO tc 
			FROM 	"SC_Tag"."T_TagData" 
			WHERE "F_TagName_ID" = 2  
			ORDER BY "ID_TagData" DESC LIMIT 1;
			IF (tc > date(t2) - interval '24 hours'+ time '20:00' AND tc < date(t2) + time '8:00' )
				THEN					  	
					  dt = t2 - t1;
					  result = dt;
					  --RETURN ('1 смена '||result);
					  IF (dt <= '00:00:35')
						THEN 
														
							SELECT 	"F_ConvertedValue", 
									"ID_TagData"
							INTO curval 
							FROM 	"SC_Tag"."T_TagData" 
							WHERE "F_TagName_ID" = 3   
							ORDER BY "ID_TagData" DESC LIMIT 1;
						  
							SELECT 	"F_ConvertedValue", 
									"ID_TagData"
							INTO presum 
							FROM 	"SC_Tag"."T_TagData" 
							WHERE "F_TagName_ID" = 2   AND  "F_ConvertedValue" IS NOT NULL
							ORDER BY "ID_TagData" DESC LIMIT 1;
						
								IF (tc <t2)
								  THEN
									SELECT EXTRACT (EPOCH FROM dt) 
									INTO delta;
									cursum = curval/delta;
									cursum = presum + cursum;
									INSERT INTO 
										"SC_Tag"."T_TagData"
									  (
										"F_TagName_ID",
										"F_ConvertedValue",
										"F_Date" 
									  )
									VALUES (
										2,
										cursum,
										t2
									  );  
									result = cursum;
									RETURN NEW;
								END IF;
							--return ('hz2');
                            RETURN OLD;
						END IF;
			ELSE 
			--t1 записываем за 0	
				INSERT INTO 
										"SC_Tag"."T_TagData"
									  (
										"F_TagName_ID",
										"F_ConvertedValue",
										"F_Date" 
									  )
									VALUES (
										2,
										0,
										t1
									  ); 
                RETURN NEW;
			END IF;
            
	ELSEIF (t1 > date(t2) - interval '24 hours'+ time '20:00' AND t1 < date(t2) + time '8:00'
    AND
    t2 >  date(t2)+ time '08:00' AND t2 < date(t2) + time '20:00')
	THEN	 
      --t2 записываем за 0	
      INSERT INTO 
										"SC_Tag"."T_TagData"
									  (
										"F_TagName_ID",
										"F_ConvertedValue",
										"F_Date" 
									  )
									VALUES (
										2,
										0,
										t2
									  ); 
	  result = t2;
	  RETURN NEW;
	  
	ELSEIF (t1 >  date(t1)+ time '08:00' AND t1 < date(t1) + time '20:00'
    AND
    t2 > date(t1) + time '20:00' AND t2 < date(t1) +interval '24 hours' + time '8:00')
	THEN
	  --t2 записываем за 0	
      INSERT INTO 
										"SC_Tag"."T_TagData"
									  (
										"F_TagName_ID",
										"F_ConvertedValue",
										"F_Date" 
									  )
									VALUES (
										2,
										0,
										t2
									  ); 
	  result = t1;
	  RETURN NEW;
	  
	END IF;
	
END;
$body$
LANGUAGE 'plpgsql'
VOLATILE
CALLED ON NULL INPUT
SECURITY INVOKER
COST 100;