3 require_once "phpfspot_cfg.php";
4 require_once "phpfspot_db.php";
5 require_once "phpfspot_tmpl.php";
17 public function __construct()
19 $this->cfg = new PHPFSPOT_CFG;
21 $this->db = new PHPFSPOT_DB(&$this, $this->cfg->fspot_db);
23 $this->cfg_db = new PHPFSPOT_DB(&$this, $this->cfg->phpfspot_db);
24 $this->check_config_table();
26 $this->tmpl = new PHPFSPOT_TMPL($this);
32 if(!isset($_SESSION['tag_condition']))
33 $_SESSION['tag_condition'] = 'or';
35 if(!isset($_SESSION['searchfor']))
36 $_SESSION['searchfor'] = '';
40 public function __destruct()
45 public function show()
47 $this->tmpl->assign('searchfor', $_SESSION['searchfor']);
48 $this->tmpl->assign('page_title', $this->cfg->page_title);
49 $this->tmpl->assign('current_condition', $_SESSION['tag_condition']);
50 $this->tmpl->show("index.tpl");
54 private function get_tags()
56 $this->avail_tags = Array();
59 $result = $this->db->db_query("
62 ORDER BY sort_priority ASC
65 while($row = $this->db->db_fetch_object($result)) {
68 $tag_name = $row['name'];
70 /* check if config requests to ignore this tag */
71 if(in_array($row['name'], $this->cfg->hide_tags))
74 $this->tags[$tag_id] = $tag_name;
75 $this->avail_tags[$count] = $tag_id;
83 public function get_photo_details($idx)
85 $result = $this->db->db_query("
91 return $this->db->db_fetch_object($result);
93 } // get_photo_details
95 public function translate_path($path, $width = 0)
97 return str_replace($this->cfg->path_replace_from, $this->cfg->path_replace_to, $path);
101 public function showPhoto($photo)
103 $all_photos = $this->getPhotoSelection();
105 foreach($all_photos as $all_photo) {
108 $next_img = $all_photo;
112 if($all_photo == $photo) {
116 $previous_img = $all_photo;
121 $details = $this->get_photo_details($photo);
122 $meta = $this->get_meta_informations($this->translate_path($details['directory_path']) ."/". $details['name']);
123 $info = getimagesize($this->translate_path($details['directory_path']) ."/thumbs/". $this->cfg->photo_width ."_". $details['name']);
125 $this->tmpl->assign('width', $info[0]);
126 $this->tmpl->assign('height', $info[1]);
127 $this->tmpl->assign('c_date', $meta['DateTime']);
128 $this->tmpl->assign('madewith', $meta['Make'] ." ". $meta['Model']);
129 $this->tmpl->assign('image_name', $details['name']);
130 $this->tmpl->assign('image_url', 'phpfspot_img.php?idx='. $photo ."&width=". $this->cfg->photo_width);
131 $this->tmpl->assign('image_url_full', 'phpfspot_img.php?idx='. $photo);
134 $this->tmpl->assign('previous_url', "javascript:showImage(". $previous_img .");");
138 $this->tmpl->assign('next_url', "javascript:showImage(". $next_img .");");
141 $this->tmpl->show("single_photo.tpl");
145 public function getAvailableTags()
147 foreach($this->avail_tags as $tag)
149 if(isset($_SESSION['selected_tags']) && in_array($tag, $_SESSION['selected_tags']))
152 // return all available (= not selected) tags
153 print "<a href=\"javascript:Tags('add', ". $tag .");\">". $this->tags[$tag] ."</a> ";
157 } // getAvailableTags()
159 public function getSelectedTags()
161 foreach($this->avail_tags as $tag)
163 // return all selected tags
164 if(isset($_SESSION['selected_tags']) && in_array($tag, $_SESSION['selected_tags'])) {
165 print "<a href=\"javascript:Tags('del', ". $tag .");\">". $this->tags[$tag] ."</a> ";
170 } // getSelectedTags()
172 public function addTag($tag)
174 if(!isset($_SESSION['selected_tags']))
175 $_SESSION['selected_tags'] = Array();
177 array_push($_SESSION['selected_tags'], $tag);
181 public function delTag($tag)
183 if(isset($_SESSION['selected_tags'])) {
184 $key = array_search($tag, $_SESSION['selected_tags']);
185 unset($_SESSION['selected_tags'][$key]);
190 public function resetTags()
192 unset($_SESSION['selected_tags']);
196 public function getPhotoSelection()
198 $tagged_photos = Array();
200 /* return a search result */
201 if(isset($_SESSION['searchfor']) && $_SESSION['searchfor'] != '') {
202 $result = $this->db->db_query("
203 SELECT DISTINCT photo_id
209 WHERE t.name LIKE '%". $_SESSION['searchfor'] ."%'
212 while($row = $this->db->db_fetch_object($result)) {
213 array_push($tagged_photos, $row['photo_id']);
215 return $tagged_photos;
218 /* return according the selected tags */
219 if(isset($_SESSION['selected_tags'])) {
221 foreach($_SESSION['selected_tags'] as $tag)
222 $selected.= $tag .",";
223 $selected = substr($selected, 0, strlen($selected)-1);
225 if($_SESSION['tag_condition'] == 'or') {
226 $result = $this->db->db_query("
227 SELECT DISTINCT photo_id
231 WHERE pt.tag_id IN (". $selected .")
234 while($row = $this->db->db_fetch_object($result)) {
235 array_push($tagged_photos, $row['photo_id']);
238 elseif($_SESSION['tag_condition'] == 'and') {
239 $result = $this->db->db_query("
240 SELECT DISTINCT photo_id, tag_id
244 WHERE pt.tag_id IN (". $selected .")
248 /* now we need to check if each object fulfills the condition
249 and has all the selected tags assigned
251 $match_object = Array();
252 $matches_needed = count($_SESSION['selected_tags']);
253 while($row = $this->db->db_fetch_object($result)) {
254 /* set the counter for this object */
255 if(!isset($match_object[$row['photo_id']]))
256 $match_object[$row['photo_id']] = $matches_needed;
258 /* we have a match? decrement the counter */
259 if(in_array($row['tag_id'], $_SESSION['selected_tags']))
260 $match_object[$row['photo_id']]--;
262 /* if the object has all necessary tags, add it to the result */
263 if($match_object[$row['photo_id']] == 0)
264 array_push($tagged_photos, $row['photo_id']);
267 return $tagged_photos;
270 /* return all available photos */
271 $result = $this->db->db_query("
272 SELECT DISTINCT photo_id
278 while($row = $this->db->db_fetch_object($result)) {
279 array_push($tagged_photos, $row['photo_id']);
281 return $tagged_photos;
283 } // getPhotoSelection()
285 public function showPhotoIndex()
287 $photos = $this->getPhotoSelection();
289 $count = count($photos);
293 $images[$rows] = Array();
295 for($i = 0; $i < $count; $i++) {
297 $images[$rows][$cols] = $photos[$i];
299 if($cols == $this->cfg->thumbs_per_row-1) {
302 $images[$rows] = Array();
309 // +1 for for smarty's selection iteration
312 //$images.= "<img src=\"phpfspot_img.php?idx=". $photo ."&width=". $this->cfg->thumb_width ."\" /><br />\n";
314 $this->tmpl->assign('count', $count);
315 $this->tmpl->assign('width', $this->cfg->thumb_width);
316 $this->tmpl->assign('images', $images);
317 $this->tmpl->assign('rows', $rows);
318 $this->tmpl->assign('columns', $this->cfg->thumbs_per_row);
319 $this->tmpl->show("photo_index.tpl");
322 } // showPhotoIndex()
324 public function showBubbleDetails($photo, $direction)
326 if($direction == "up")
327 $direction = "bubbleimg_up";
329 $direction = "bubbleimg_down";
331 $details = $this->get_photo_details($photo);
333 $image_url = "phpfspot_img.php?idx=". $photo ."&width=". $this->cfg->bubble_width;
335 $filesize = filesize($this->translate_path($details['directory_path']) ."/". $details['name']);
336 $filesize = rand($filesize/1024, 2);
338 $img = getimagesize($this->translate_path($details['directory_path']) ."/". $details['name']);
340 $this->tmpl->assign('file_size', $filesize);
341 $this->tmpl->assign('width', $img[0]);
342 $this->tmpl->assign('height', $img[1]);
343 $this->tmpl->assign('file_name', $details['name']);
344 $this->tmpl->assign('image_id', $direction);
345 $this->tmpl->assign('image_url', $image_url);
346 $this->tmpl->show("bubble_details.tpl");
348 } // showBubbleDetails()
350 public function showCredits()
352 $this->tmpl->assign('version', $this->cfg->version);
353 $this->tmpl->assign('product', $this->cfg->product);
354 $this->tmpl->show("credits.tpl");
358 public function create_thumbnail($image, $width)
360 // if thumbnail already exists, don't recreate it
361 if(file_exists(dirname($image) ."/thumbs/". $width ."_". basename($image)))
364 $src_img = @imagecreatefromjpeg($image);
368 /* grabs the height and width */
369 $new_w = imagesx($src_img);
370 $new_h = imagesy($src_img);
372 // If requested width is more then the actual image width,
373 // do not generate a thumbnail
375 if($width >= $new_w) {
376 imagedestroy($src_img);
380 /* calculates aspect ratio */
381 $aspect_ratio = $new_h / $new_w;
385 $new_h = abs($new_w * $aspect_ratio);
387 /* creates new image of that size */
388 $dst_img = imagecreatetruecolor($new_w,$new_h);
390 imagefill($dst_img, 0, 0, ImageColorAllocate($dst_img, 255, 255, 255));
392 /* copies resized portion of original image into new image */
393 imagecopyresampled($dst_img,$src_img,0,0,0,0,$new_w,$new_h,imagesx($src_img),imagesy($src_img));
395 /* write down new generated file */
397 if(!file_exists(dirname($image) ."/thumbs"))
398 mkdir(dirname($image) ."/thumbs");
400 $newfile = dirname($image) ."/thumbs/". $width ."_". basename($image);
401 imagejpeg($dst_img, $newfile, 75);
404 imagedestroy($dst_img);
405 imagedestroy($src_img);
408 } // create_thumbnail()
410 public function get_meta_informations($file)
413 return exif_read_data($file);
415 } // get_meta_informations()
417 public function check_config_table()
419 // if the config table doesn't exist yet, create it
420 if(!$this->cfg_db->db_check_table_exists("images")) {
421 $this->cfg_db->db_exec("
422 CREATE TABLE images (
423 img_idx int primary key,
429 } // check_config_table
431 public function gen_thumbs($idx = 0, $fromcmd = 0)
434 /* get all available photos */
435 $all = $this->getPhotoSelection();
440 foreach($all as $photo) {
442 $details = $this->get_photo_details($photo);
444 $full_path = $this->translate_path($details['directory_path']) ."/". $details['name'];
445 $file_md5 = md5_file($full_path);
447 if($fromcmd) print "Image ". $details['name'] ." Thumbnails:";
449 /* if the file hasn't changed there is no need to regen the thumb */
450 if($file_md5 == $this->getMD5($photo)) {
451 if($fromcmd) print " file has not changed - skipping\n";
455 /* set the new/changed MD5 sum for the current photo */
456 $this->setMD5($photo, $file_md5);
458 $resolutions = Array(
459 $this->cfg->thumb_width,
460 $this->cfg->bubble_width,
461 $this->cfg->photo_width
464 /* create thumbnails for the requested resolutions */
465 foreach($resolutions as $resolution) {
466 if($fromcmd) print " ". $resolution ."px";
467 $this->create_thumbnail($full_path, $resolution);
470 if($fromcmd) print "\n";
476 private function getMD5($idx)
478 $result = $this->cfg_db->db_query("
481 WHERE img_idx='". $idx ."'
487 $img = $this->cfg_db->db_fetch_object($result);
488 return $img['img_md5'];
492 private function setMD5($idx, $md5)
494 $result = $this->cfg_db->db_exec("
495 REPLACE INTO images (img_idx, img_md5)
496 VALUES ('". $idx ."', '". $md5 ."')
501 public function setTagCondition($mode)
503 $_SESSION['tag_condition'] = $mode;
505 } // setTagCondition()
507 public function startSearch($searchfor)
509 $_SESSION['searchfor'] = $searchfor;