From 4c07eca4a8a4a012dfe4806d0514dfc7d61b1fcb Mon Sep 17 00:00:00 2001
From: priyankabhagwat
Date: Thu, 25 May 2017 13:50:49 +0530
Subject: Added other views

---
 FOSSEE/FOSSEE-dynamic-website.rst | 228 +++++++++++++++++++++++++++++++++++++-
 1 file changed, 226 insertions(+), 2 deletions(-)

diff --git a/FOSSEE/FOSSEE-dynamic-website.rst b/FOSSEE/FOSSEE-dynamic-website.rst
index ee2a3c6..d0d53e4 100644
--- a/FOSSEE/FOSSEE-dynamic-website.rst
+++ b/FOSSEE/FOSSEE-dynamic-website.rst
@@ -78,9 +78,9 @@ SMTP Authentication Support
 
 -  *CDN Starterkit* <https://drupal-bootstrap.org/api/bootstrap/starterkits%21cdn%21README.md/group/subtheme_cdn/7>
 
--   *Less Starterkit* <https://drupal-bootstrap.org/api/bootstrap/starterkits%21less%21README.md/group/subtheme_less/7>`__
+-  *Less Starterkit* <https://drupal-bootstrap.org/api/bootstrap/starterkits%21less%21README.md/group/subtheme_less/7>
 
--  *Sass Starterkit* <https://drupal-bootstrap.org/api/bootstrap/starterkits%21sass%21README.md/group/subtheme_sass/7>`_
+-  *Sass Starterkit* <https://drupal-bootstrap.org/api/bootstrap/starterkits%21sass%21README.md/group/subtheme_sass/7>
 
 
 Here we are using the CDN Starterkit.
@@ -210,6 +210,184 @@ Activities
 
 |image13|
 
+**Contact ID**
+
+**Query**
+
+ SELECT node.nid AS nid, node.created AS node\_created, 'node' AS
+  field\_data\_field\_project\_contact\_node\_entity\_type, 'node' AS
+  field\_data\_field\_contact\_email\_id\_node\_entity\_type
+ FROM
+ {node} node
+ WHERE (( (node.status = '1') AND (node.type IN
+ ('fossee\_projects\_contact\_id')) ))
+ ORDER BY node\_created ASC
+
+|image14|
+
+**Output**
+
+|image15|
+
+**Generic Content**
+
+**BLOCK - Footer-data Files **
+
+**Query**
+
+ SELECT node.title AS node\_title, node.nid AS nid, node.created AS
+ node\_created, 'node' AS
+ field\_data\_field\_generic\_image\_link\_node\_entity\_type, 'node'
+ AS field\_data\_field\_generic\_image\_node\_entity\_type
+ FROM
+ {node} node
+ INNER JOIN {field\_data\_field\_tags} field\_data\_field\_tags ON
+ node.nid = field\_data\_field\_tags.entity\_id AND
+ (field\_data\_field\_tags.entity\_type = 'node' AND
+ field\_data\_field\_tags.deleted = '0')
+ WHERE (( (node.status = '1') AND (node.type IN ('generic\_images'))
+ AND (field\_data\_field\_tags.field\_tags\_tid = '5') ))
+ ORDER BY node\_created DESC
+ LIMIT 5 OFFSET 0
+
+|image16|
+
+**BLOCK- Sponsor Section **
+
+**Query**
+
+ SELECT node.title AS node\_title, node.nid AS nid, node.created AS
+ node\_created, 'node' AS
+ field\_data\_field\_generic\_image\_link\_node\_entity\_type, 'node'
+ AS field\_data\_field\_generic\_image\_node\_entity\_type
+ FROM
+ {node} node
+ INNER JOIN {field\_data\_field\_tags} field\_data\_field\_tags ON
+ node.nid = field\_data\_field\_tags.entity\_id AND
+ (field\_data\_field\_tags.entity\_type = 'node' AND
+ field\_data\_field\_tags.deleted = '0')
+ WHERE (( (node.status = '1') AND (node.type IN ('generic\_images'))
+ AND (field\_data\_field\_tags.field\_tags\_tid = '6') ))
+ ORDER BY node\_created DESC
+ LIMIT 5 OFFSET 0
+
+|image17|
+
+**Output**
+
+|image18|
+
+**Resources**
+
+**Query**
+
+ SELECT node.nid AS nid, node.created AS node\_created, 'node' AS
+ field\_data\_field\_project\_resources\_node\_entity\_type, 'node' AS
+ field\_data\_field\_project\_resocurces\_link\_node\_entity\_type
+ FROM
+ {node} node
+ WHERE (( (node.status = '1') AND (node.type IN ('resources')) ))
+ ORDER BY node\_created ASC
+
+|image19|
+
+**Output**
+
+|image20|
+
+**Top Slider**
+
+**Query**
+
+ SELECT node.nid AS nid, node.title AS node\_title, node.created AS
+ node\_created, 'node' AS field\_data\_field\_image\_node\_entity\_type
+ FROM
+ {node} node
+ INNER JOIN {taxonomy\_index} taxonomy\_index ON node.nid =
+ taxonomy\_index.nid
+ WHERE (( (node.status = '1') AND (node.type IN ('article')) AND
+ (taxonomy\_index.tid = '4') ))
+ ORDER BY node\_created DESC
+ LIMIT 5 OFFSET 0
+
+|image21|
+
+**Rewrite results**
+
+|image22|
+
+**Output**
+
+|image23|
+
+**Site Content**
+
+**Query**
+
+**BLOCK -News**
+
+ SELECT node.title AS node\_title, node.nid AS nid, node.created AS
+ node\_created, 'node' AS field\_data\_field\_link\_node\_entity\_type
+ FROM
+ {node} node
+ INNER JOIN {field\_data\_field\_tags} field\_data\_field\_tags ON
+ node.nid = field\_data\_field\_tags.entity\_id AND
+ (field\_data\_field\_tags.entity\_type = 'node' AND
+ field\_data\_field\_tags.deleted = '0')
+ WHERE (( (node.status = '1') AND (node.type IN ('article')) AND
+ (field\_data\_field\_tags.field\_tags\_tid = '2') ))
+ ORDER BY node\_created DESC
+ LIMIT 5 OFFSET 0
+
+|image24|
+
+**BLOCK- Events**
+
++--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+ SELECT node.title AS node\_title, node.nid AS nid, node.created AS node\_created                                                                                                                                     FROM
+ {node} node                                                                                                                                                                                                       
+INNER JOIN {field\_data\_field\_tags} field\_data\_field\_tags ON node.nid = field\_data\_field\_tags.entity\_id AND (field\_data\_field\_tags.entity\_type = 'node' AND field\_data\_field\_tags.deleted = '0')   |
+ WHERE (( (node.status = '1') AND (node.type IN ('article')) AND (field\_data\_field\_tags.field\_tags\_tid = '3') ))                                                                               
+ORDER BY node\_created DESC                                                                                                                                                                                     
+LIMIT 5 OFFSET 0                                                                                                                                                                                                   
++====================================================================================================================================================================================================================+
++--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+
+|image25|
+
+**BLOCK- News Page**
+
+ SELECT node.title AS node\_title, node.nid AS nid, node.created AS
+ node\_created
+ FROM
+ {node} node
+ WHERE (( (node.status = '1') AND (node.type IN ('article')) ))
+ ORDER BY node\_created DESC
+ LIMIT 15 OFFSET 0
+
+**Output**
+
+|image26|
+
+Team Members
+
+Query
+
++-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+ SELECT node.nid AS nid, node.created AS node\_created, 'node' AS field\_data\_field\_team\_members\_name\_node\_entity\_type, 'node' AS field\_data\_field\_member\_designation\_node\_entity\_type, 'node' AS field\_data\_field\_projects\_node\_entity\_type            
+FROM                                                                                                                                                                                                                                                                        {node} node                                                                                                                                                                                                                                                                 
+ LEFT JOIN {field\_data\_field\_employment\_type\_} field\_data\_field\_employment\_type\_\_value\_0 ON node.nid = field\_data\_field\_employment\_type\_\_value\_0.entity\_id AND field\_data\_field\_employment\_type\_\_value\_0.field\_employment\_type\_\_value = '0'   
+ WHERE (( (node.status = '1') AND (node.type IN ('team\_members')) AND( (field\_data\_field\_employment\_type\_\_value\_0.field\_employment\_type\_\_value = '0') )))                                                                                                        
+ORDER BY node\_created ASC                                                                                                                                                                                                                                                  
++=============================================================================================================================================================================================================================================================================+
++-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+
+|image27|
+
+**Output**
+
+|image28|
+
 .. |image0| image:: media/designation.png
    :width: 6.92188in
    :height: 1.45833in
@@ -252,3 +430,49 @@ Activities
 .. |image13| image:: media/projects.png
    :width: 6.26772in
    :height: 5.93056in
+.. |image14| image:: media/view-block-contact-id.png
+   :width: 6.73438in
+   :height: 3.15625in
+.. |image15| image:: media/output-contact-id.png
+   :width: 6.27083in
+   :height: 3.13021in
+.. |image16| image:: media/view-block-generic-footer.png
+   :width: 6.81250in
+   :height: 3.40104in
+.. |image17| image:: media/view-block-generic-sponsor.png
+   :width: 6.74479in
+   :height: 3.41667in
+.. |image18| image:: media/generic-output.png
+   :width: 6.26772in
+   :height: 2.01389in
+.. |image19| image:: media/view-block-resources.png
+   :width: 6.80729in
+   :height: 3.60417in
+.. |image20| image:: media/output-resources.png
+   :width: 6.73958in
+   :height: 3.53646in
+.. |image21| image:: media/view-block-topslider.png
+   :width: 6.26772in
+   :height: 2.93056in
+.. |image22| image:: media/view-block-topslider-rewrite.png
+   :width: 6.26772in
+   :height: 4.09722in
+.. |image23| image:: media/output-topslider.png
+   :width: 6.76563in
+   :height: 2.38542in
+.. |image24| image:: media/view-block-new.png
+   :width: 6.26772in
+   :height: 2.90278in
+.. |image25| image:: media/view-block-events.png
+   :width: 6.80208in
+   :height: 3.25521in
+.. |image26| image:: media/output-sitecontent.png
+   :width: 6.81771in
+   :height: 3.18750in
+.. |image27| image:: media/view-block-team.png
+   :width: 6.93229in
+   :height: 3.43750in
+.. |image28| image:: media/output-team.png
+   :width: 6.83854in
+   :height: 4.01042in
+
-- 
cgit