Design company

Another small website I did for one of my client.

The hardest part was to do a custom page with custom SQL for each pages (Communication, Website, Logotypes and Packaging)

Here is an example of the code I did:

http://www.7340.be/exnihilo/logotypes.exn -> page-node-5.tpl.php
8<.....

			<?php print $content ?>

			
			
			
			<?php
			
			$num_per_page=9;
			
			$count_query = "SELECT COUNT(term_node.tid)
						FROM term_node
						JOIN term_data ON term_data.tid = term_node.tid
						WHERE term_node.tid
						IN (

						SELECT term_data.tid
						FROM term_data
						WHERE vid =6
						)
						AND term_node.nid
						IN (

						SELECT nid
						FROM node
						WHERE TYPE = 'contrat'
						)
						AND term_node.nid
						IN (

						SELECT nid
						FROM term_node
						WHERE tid = '40'
						)
			";
			
        	$result = pager_query("SELECT term_node.tid, term_data.name, GROUP_CONCAT( term_node.nid ) nid
			FROM term_node
			JOIN term_data ON term_data.tid = term_node.tid
			WHERE term_node.tid
			IN (

			SELECT term_data.tid
			FROM term_data
			WHERE vid =6
			)
			AND term_node.nid
			IN (

			SELECT nid
			FROM node
			WHERE TYPE = 'contrat'
			)
			AND term_node.nid
			IN (

			SELECT nid
			FROM term_node
			WHERE tid = '40'
			)
			GROUP BY term_node.tid
			ORDER BY name",$num_per_page,0,$count_query);
			
		$i=0;
		while ($record = db_fetch_object($result))
	    	{
			$node_list = explode(",",$record->nid);
			$src[$i] = taxonomy_image_display($record->tid,"onclick='loadme(this)'");
			$j=0;
			foreach ($node_list AS $nid) {
				$node  = node_load($nid);
				$image = $node->field_image; 
				$title = $node->title;
				$body  = $node->body;
				$filepath = $image[0]['filepath'];
			    $subsrc[$i][$j]=theme('imagecache','medium',$filepath,$title,$title,array("class"=>"image")); 					
				$j++;
			} 
			$i++;
	        }
		
				echo '<script type="text/javascript" charset="utf-8">';

					echo "img   = new Array();";
					echo "infos = new Array();";
					if (count($src)>=1) {
						foreach ($src as $key => $value) {
							preg_match('/src=("[^"]*")/i',$value,$matches);
							$src = str_replace("\"","",$matches[1]);
							echo "img[{$key}] = '$src';\n";
							preg_match('/alt=("[^"]*")/i',$value,$matches);
							$alt = str_replace("\"","",$matches[1]);

							echo "infos[{$key}] = '$alt';\n";
							echo "img_{$key} = new Array();\n";
						}
					}

					if (count($subsrc)>=1) {
						foreach ($subsrc as $key => $value) {
							foreach ($value as $subkey => $src) {
								preg_match('/src=("[^"]*")/i',$src,$matches);
								$src = str_replace("\"","",$matches[1]);
								echo "img_{$key}[{$subkey}] = '$src';\n";
							}
						}
					}

				echo '</script>';		
		
?>

...>8

Those pages have to display taxonomy images in a fancy way and display nodes attached to them as a small icon. Try to click and browse through images...

I will not copy paste the Javascript here, it's a bit long. The Javascript script is used to display the fancy gallery.

Enjoy ;-)