rendered paste body<?php
// returns an array of menu (reference to determine an active page)
function generate_menu($menuPage='') {
$menu = array();
$menu['menuProduct'] = ($menuPage=='menuProduct') ? 'active' : 'normal';
$menu['menuStone'] = ($menuPage=='menuStone') ? 'active' : 'normal';
$menu['menuFeatured'] = ($menuPage=='menuFeatured') ? 'active' : 'normal';
$menu['menuTechnical'] = ($menuPage=='menuTechnical') ? 'active' : 'normal';
$menu['menuSolutions'] = ($menuPage=='menuSolutions') ? 'active' : 'normal';
$menu['menuSamples'] = ($menuPage=='menuSamples') ? 'active' : 'normal';
$menu['menuLab'] = ($menuPage=='menuLab') ? 'active' : 'normal';
return $menu;
}
// returns an array of info like 'color' and 'type_of_stone' (for Stone Select module)
function get_info($type='color') {
switch($type) {
case 'type_of_stone': // type_of_stone
$sql = "
SELECT DISTINCT `type_of_stone`
FROM `stones`
ORDER BY `type_of_stone`
";
break;
default: // color
$sql = "
SELECT DISTINCT `color`
FROM `stones`
ORDER BY `color`
";
}
$result = mysql_query($sql);
$info = array();
if(mysql_num_rows($result)) {
while($row = mysql_fetch_assoc($result)) {
$info[] = $row[$type];
}
}
return $info;
}
function get_stone_info() {
$sql = " SELECT * FROM `stones` WHERE `clean_url` = '{$_REQUEST['stone']}'";
$result = mysql_query($sql);
$info = array();
if($result)
$info = mysql_fetch_assoc($result);
return $info;
}
// returns an array of stone results
function get_result() {
$condition = isset($_POST['stone_color']) ? "WHERE `color` LIKE '%{$_POST['stone_color']}%'" : "WHERE 1 = 1";
$condition .= isset($_POST['stone_type']) ? "AND `type_of_stone` LIKE '%{$_POST['stone_type']}%'" : '';
$sql = "
SELECT `title`, `picture`, `country_of_origin`, `type_of_stone`, `clean_url`
FROM `stones`
$condition
GROUP BY `title`
";
$result = mysql_query($sql);
$info = array();
if(mysql_num_rows($result)) {
while($row = mysql_fetch_assoc($result)) {
$info[] = $row;
}
}
return $info;
}
// returns an HTML code to display stone results
function generate_result() {
$data = get_result();
$str = '';
foreach($data as $key=>$val) {
$stoneLink = "stones/{$val['clean_url']}";
//$stoneLink = "individualstones.php?stone={$val['clean_url']}";
$class = ($key%2) ? 'row2' : 'row1';
$str .= "
<tr class=\"$class\">
<td> <a href=\"$stoneLink\">{$val['title']}</a></td>
<td><img src=\"../stonepics/{$val['picture']}\" width=\"153\" height=\"65\"></td>
<td>{$val['country_of_origin']}</td>
<td>{$val['type_of_stone']}</td>
</tr>
";
}
return $str;
}
// return an array of CAD details given a type
function get_cad($type) {
$condition = !empty($type) ? "WHERE `type` = '$type'" : "";
$sql = "SELECT * FROM `cad` $condition ORDER BY `filename`";
$result = mysql_query($sql);
$info = array();
if(mysql_num_rows($result)) {
while($row = mysql_fetch_assoc($result)) {
$info[] = $row;
}
}
return $info;
}
// returns an HTML code to display CAD details given a type
function generate_cad($type) {
$data = get_cad($type);
$str = '';
foreach($data as $key=>$val) {
$class = ($key%2) ? 'row2' : 'row1';
$str .= "
<tr class=\"$class\">
<td>{$val['filename']}</td>
<td>{$val['description']}</td>
<td><a rel=\"lightbox\" href=\"../cad/large/{$val['filename']}.jpg\"><img class=\"thumb\" src=\"../cad/thumbs_new/{$val['filename']}.jpg\" alt=\"StonePly drawing\"></a></td>
<td><a href=\"../cad/pdf/{$val['filename']}.pdf\" target=\"_blank\"><img src=\"../images/pdf.gif\" alt=\"PDF file\" border=\"0\"></a></td>
<td><a href=\"../cad/dwg/{$val['filename']}.dwg\"><img src=\"../images/dwg.gif\" alt=\"AutoCAD file\" border=\"0\"></td>
</tr>
";
}
return $str;
}
function generate_extra_cad() {
$data = array();
$data[] = array(
'filename' => 'SLP-001',
'description' => 'Floor Mounted Lavatory Partition Mounting Details'
);
$data[] = array(
'filename' => 'SLP-002',
'description' => 'Floor and Ceiling Mounted Lavatory Partition Mounting Details'
);
$data[] = array(
'filename' => 'SLP-003',
'description' => 'Wall Hung Urinal Screen Mounting Details'
);
$data[] = array(
'filename' => 'SLP-004',
'description' => 'Lavatory Partition Dimension Details'
);
$data[] = array(
'filename' => 'SLP-005',
'description' => 'Urinal Screen Dimension Details'
);
$data[] = array(
'filename' => 'SLP-006',
'description' => 'Shower Partition Dimension Details'
);
$data[] = array(
'filename' => 'SLP-007',
'description' => 'Changing Room Partition Dimension Details'
);
$str = '';
foreach($data as $key=>$val) {
$class = ($key%2) ? 'row2' : 'row1';
$str .= "
<tr class=\"$class\">
<td>{$val['filename']}</td>
<td>{$val['description']}</td>
<td><a rel=\"lightbox\" href=\"../files/details/{$val['filename']}.jpg\"><img class=\"thumb\" src=\"../files/details/{$val['filename']}.jpg\" alt=\"StonePly drawing\"></a></td>
<td><a href=\"../files/details/{$val['filename']}.pdf\" target=\"_blank\"><img src=\"../images/pdf.gif\" alt=\"PDF file\" border=\"0\"></a></td>
</tr>
";
}
return $str;
}
// returns an array of stones as shown in Stone Options page
function get_stones() {
$maxRows_sOptions = 20;
$pageNum_sOptions = (isset($_REQUEST['pageNum_sOptions'])) ? $_REQUEST['pageNum_sOptions'] : 0;
$startRow_sOptions = $pageNum_sOptions * $maxRows_sOptions;
$condition = (isset($_REQUEST['letter'])) ? "WHERE `title` LIKE '{$_REQUEST['letter']}%'" : "";
$sql = "
SELECT `ID`, `title`, `picture`, `country_of_origin`, `type_of_stone`, `clean_url`
FROM `stones`
$condition
GROUP BY `title`
LIMIT $startRow_sOptions, $maxRows_sOptions
";
$result = mysql_query($sql);
$info = array();
if(mysql_num_rows($result)) {
while($row = mysql_fetch_assoc($result)) {
$info[] = $row;
}
}
return $info;
}
// returns an HTML code to display stone results
function generate_stones() {
$data = get_stones();
$str = '';
if(!empty($data)) {
foreach($data as $key=>$val) {
$stoneLink = "stones/{$val['clean_url']}";
//$stoneLink = "individualstones.php?stone={$val['clean_url']}";
$class = ($key%2) ? 'row2' : 'row1';
$str .= "
<tr class=\"$class\">
<td> <a href=\"$stoneLink\">{$val['title']}</a></td>
<td><img src=\"../stonepics/{$val['picture']}\" width=\"153\" height=\"65\"></td>
<td>{$val['country_of_origin']}</td>
</tr>
";
}
}
else {
$str .= "
<tr class=\"row1\">
<td colspan=\"3\" align=\"center\">No record found!</td>
</tr>
";
}
return $str;
}
// returns an array to display page navigation and records counter
function generate_navigation() {
$condition = (isset($_REQUEST['letter'])) ? "WHERE `title` LIKE '{$_REQUEST['letter']}%'" : "";
$sql = "
SELECT `ID`, `title`, `picture`, `country_of_origin`, `type_of_stone`, `clean_url`
FROM `stones`
$condition
GROUP BY `title`
";
$result = mysql_query($sql);
$maxRows = 20;
$pageNum = (isset($_REQUEST['pageNum_sOptions'])) ? $_REQUEST['pageNum_sOptions'] : 0;
$totalRows = mysql_num_rows($result);
$startRow = ($pageNum * $maxRows) + 1;
$startRow = ($startRow > $totalRows) ? 0 : $startRow;
$endRow = ($pageNum * $maxRows) + $maxRows;
$endRow = ($endRow > $totalRows) ? $totalRows : $endRow;
$totalPages = ceil($totalRows/$maxRows) - 1;
// << grab counter
$prev = $pageNum - 1;
$next = $pageNum + 1;
$letterFilter = (isset($_REQUEST['letter'])) ? "[beginning with the letter '{$_REQUEST['letter']}']" : "";
$letterParam = (isset($_REQUEST['letter'])) ? "&letter={$_REQUEST['letter']}" : "";
$pageNavigator = array();
if($pageNum > 0) {
$pageNavigator[] = '<a href="stone_options.php?pageNum_sOptions=0'.$letterParam.'">First</a>';
$pageNavigator[] = '<a href="stone_options.php?pageNum_sOptions='.$prev.$letterParam.'">Previous</a>';
}
if($pageNum < $totalPages) {
$pageNavigator[] = '<a href="stone_options.php?pageNum_sOptions='.$next.$letterParam.'">Next</a>';
$pageNavigator[] = '<a href="stone_options.php?pageNum_sOptions='.$totalPages.$letterParam.'">Last</a>';
}
$info = array();
$info['result_counter'] = "Stones $startRow through $endRow of $totalRows $letterFilter";
$info['page_navigator'] = implode(" | ", $pageNavigator);
return $info;
}
// returns an HTML code useful for option list
function generate_option($info) {
$str = '';
foreach($info as $val) {
$str .= "<option value=\"$val\">$val</option>\r\n";
}
return $str;
}
// returns an HTML code for banner
function load_banner($type='image', $project='') {
switch($type) {
case 'rotate':
return '<img src="http://www.stoneply.com/rimages/rotate.php" border="0" />';
break;
case 'flash':
return '<iframe marginheight="0" marginwidth="0" align="center" frameborder="0" scrolling="no" src ="/gallery.html" width="700" height="350"></iframe>';
break;
case 'project':
return '<img src="rimages/'.$project.'.jpg" border="0" />';
default:
return '<img src="images/banner.jpg" border="0" />';
}
}
?>