diff options
| -rw-r--r-- | FOSSEE/FOSSEE-dynamic-website.rst | 228 |
1 files 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 + |