| <?php | |
| //error_reporting(E_ALL); ini_set("display_errors", true); | |
| require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/app.class.php"); require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/nav.class.php"); require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/menu.class.php"); $App = new App(); $Nav = new Nav(); $Menu = new Menu(); include("_projectCommon.php"); # All on the same line to unclutter the user's desktop' | |
| #***************************************************************************** | |
| # | |
| # Author: Donald Smith | |
| # Date: 2005-11-11 | |
| #**************************************************************************** | |
| # | |
| # Begin: page-specific settings. Change these. | |
| $pageTitle = "Eclipse Membership Logos"; | |
| $pageKeywords = "Type, page, keywords, here"; | |
| $pageAuthor = "Type your name here"; | |
| require_once("./scripts/db_access.php"); | |
| require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/smartconnection.class.php"); | |
| require_once("./lookup_exceptions.php"); | |
| $dbc = new DBConnection(); | |
| $dbc->connect(); | |
| $_ORDER = $_POST['order'] ? $_POST['order'] : $_GET['order']; | |
| $_TYPE = $_POST['type'] ? $_POST['type'] : $_GET['type']; | |
| $valid = array("SD", "SC", "AP", "AS", "ENTRP"); | |
| if(!in_array($_TYPE, $valid)) { | |
| unset($_TYPE); | |
| } | |
| $_NUMCOLS = 8; | |
| if (isset($_GET['numcols'])) { | |
| $count = (int)$_GET['numcols']; | |
| $_NUMCOLS = max(8, min(64, $count)); | |
| } | |
| switch ($_ORDER) { | |
| case "type": $order_by = "ORG.member_type desc, ORG.name1"; break; | |
| case "complete": $order_by = "COMPLETE, ORG.name1"; break; | |
| default: $order_by = "ORG.name1"; | |
| } | |
| if ($_TYPE != "") | |
| $where_clause = "WHERE ORG.member_type = '" . $_TYPE . "'"; | |
| else | |
| $where_clause = "WHERE ORG.member_type in ('SD', 'SC', 'AP', 'AS', 'ENTRP')"; | |
| //WTB: Modified to exclude organizations that have not provided a small logo. | |
| $selectall = "SELECT ORGI.OrganizationID, ORG.name1, ORGI.short_description, ORG.member_type, ORGI.company_url IS NULL AS COMPLETE | |
| from OrganizationInformation as ORGI | |
| RIGHT JOIN organizations as ORG on ORGI.OrganizationID = ORG.organization_id | |
| " . $where_clause . " and ORGI.small_logo is not null | |
| ORDER BY | |
| " . $order_by; | |
| // echo "SQL: " . $selectall; | |
| $MATCHES = mysql_evaluate_rows($selectall); | |
| $LIST = '<table><tr>'; | |
| $count=1; | |
| foreach ($MATCHES as $a) { | |
| $org_id = $a[0]; | |
| $org_name = $a[1]; | |
| $org_short_desc = $a[2]; | |
| $org_type = $a[3]; | |
| $LIST .= '<td><img src="./scripts/get_image.php?id=' . $org_id. '&size=small" style="padding:1px;" alt="'. $org_name . '"></td>'; | |
| if ( ($count++ % $_NUMCOLS) == 0 ) { | |
| $LIST .= '</tr><tr>'; | |
| } | |
| } | |
| $LIST .= '</tr></table>'; | |
| ?> | |
| <html> | |
| <head> | |
| <title>Eclipse Member Company Logos</title> | |
| <style> | |
| img {max-width:120px;max-height:120px} | |
| td {text-align:center;vertical-align:middle;} | |
| </style> | |
| </head> | |
| <body> | |
| <?php echo $LIST; ?> | |
| </body> | |
| </html> |