Add standing offers
[contractdashboard.git] / displayConfidentialities.php
blob:a/displayConfidentialities.php -> blob:b/displayConfidentialities.php
--- a/displayConfidentialities.php
+++ b/displayConfidentialities.php
@@ -13,9 +13,9 @@
 $query = '
 SELECT SUM(value) as value,count(*), reason
 FROM 
-(select value, unnest(string_to_array(replace("confidentialityContractReason",\'Other - \',\'\'),\';\')) reason from contractnotice where "confidentialityContractReason" != \'\' and "confidentialityContractReason" != "confidentialityOutputsReason" 
-union select value, unnest(string_to_array(replace("confidentialityOutputsReason",\'Other - \',\'\'),\';\')) reason from contractnotice where "confidentialityOutputsReason" != \'\' and "confidentialityContractReason" != "confidentialityOutputsReason" 
-union select value, unnest(string_to_array(replace("confidentialityOutputsReason",\'Other - \',\'\'),\';\')) reason from contractnotice where "confidentialityOutputsReason" != \'\' and "confidentialityContractReason" = "confidentialityOutputsReason") a
+(select value, unnest(string_to_array(replace("confidentialityContractReason",\'Other - \',\'\'),\';\')) reason from contractnotice where "confidentialityContractReason" != \'\' and "confidentialityContractReason" != "confidentialityOutputsReason" and '.$yearQ.' '.$standardQ.'
+union select value, unnest(string_to_array(replace("confidentialityOutputsReason",\'Other - \',\'\'),\';\')) reason from contractnotice where "confidentialityOutputsReason" != \'\' and "confidentialityContractReason" != "confidentialityOutputsReason" and '.$yearQ.' '.$standardQ.'
+union select value, unnest(string_to_array(replace("confidentialityOutputsReason",\'Other - \',\'\'),\';\')) reason from contractnotice where "confidentialityOutputsReason" != \'\' and "confidentialityContractReason" = "confidentialityOutputsReason" and '.$yearQ.' '.$standardQ.') a
 GROUP BY reason ORDER BY value desc
 ';