<?php

# This form requires wfpl. See: http://sametwice.com/wfpl

define('ADMIN_IMAGES_DB_FIELDS', 'image,name,caption,sizes');

require_once(DOCROOT . 'inc/wfpl/format.php');
require_once(DOCROOT . 'inc/wfpl/upload.php');

# example: 200x300
function format_width_height($str) {
	$fields = explode('x', $str);
	if(count($fields) != 2) {
		return '';
	}

	list($width, $height) = $fields;
	$width = format_int_0($width);
	$height = format_int_0($height);

	return "${width}x$height";
}

function admin_images_get_fields() {
	$data = array();

	$data['name'] = format_oneline(_REQUEST_cut('name'));
	$data['caption'] = format_oneline(_REQUEST_cut('caption'));

	if($_FILES['image'] && $_FILES['image']['error'] == 0 && file_exists($_FILES['image']['tmp_name'])) {
		$image_fn_ext = path_or_mime_to_ext($_FILES['image']['name'], $_FILES['image']['type']);
		$image_fn_ext = ext_to_web_image_ext($image_fn_ext);
		$image_fn_base = sha1_file($_FILES['image']['tmp_name']);
		if (strlen($image_fn_base) == 40) {
			$image_fn_base = substr($image_fn_base, 0, 16);
			$image_filename = 'cms_images/' . $image_fn_base . '.' . $image_fn_ext;
			$data['image'] = convert_uploaded_image('image', $image_filename);
		}
	} else {
		if(_REQUEST_cut('delete_image') == 'Yes') {
			$data['image'] = '';
		} else {
			$data['image'] = format_image_w_h(_REQUEST_cut('old_image'));
		}
	}
	unset($_FILES['image']);

	return $data;
}


function admin_images_main() {
	session_auth_must('admin_images');

	$id = _REQUEST_cut('edit_id');
	if($id) {
		return admin_images_main_form($id);
	}

	$id = _REQUEST_cut('admin_images_delete_id');
	if($id) {
		return admin_images_main_delete($id);
	}

	if(_REQUEST_cut('new')) {
		return admin_images_main_form();
	}

	if(_REQUEST_cut('list')) {
		return admin_images_main_listing();
	}

	$id = _REQUEST_cut('id');
	if($id) {
		return admin_images_main_display($id);
	}

	if(isset($_POST['name'])) {
		return admin_images_main_form();
	}

	# default action:
	return admin_images_main_listing();
}

function admin_images_main_display($id) {
	$data = db_get_assoc('cms_images', 'id,'.ADMIN_IMAGES_DB_FIELDS, 'where id=%i', $id);
	if(!$data) {
		message("Error: Broken Link (Image #$id not found)");
		return './admin_images';
	}

	# Find pages that have this image on it
	if($data['image']) {
		$references = db_get_assocs('cms_pages', 'title,filename', 'where content like "%%%s%%" order by concat(nav_title,title)', substr(enc_image_src($data['image']), 0, -4));
		if($references) {
			$data['references'] = array(
				'data' => $references,
				'count' => count($references));
		}
	}

	tem_set('display', $data);
}

function admin_images_main_delete($id) {
	$data = db_get_assoc('cms_images', 'image,sizes', 'where id=%i', $id);
	if ($data) {
		$src = enc_image_src($data['image']);
		if ($src) {
			$filenames = array($src);
			foreach ($GLOBALS['wfpl_image_widths'] as $w) {
				$filenames [] = substr($src, 0, -4) . 'w' . $w . substr($src, -4);
			}
			foreach ($filenames as $filename) {
				if (file_exists($filename)) {
					unlink($filename);
				}
			}
		}
		db_delete('cms_images', 'where id=%i', $id);
		message('Image deleted.');
	} else {
		message("Couldn't find image to delete. Maybe it's already been deleted?");
	}
	return './admin_images';
}

function admin_images_main_listing() {
	$sort_by = 'name';
	$sorts = array(
		'age' => 'created_at desc',
		'name' => "coalesce(nullif(name, ''), caption), created_at",
		'caption' => "coalesce(nullif(caption, ''), name), created_at"
	);
	if (isset($_REQUEST['sort'])) {
		foreach ($sorts as $s => $sql) {
			if ($_REQUEST['sort'] == $s) {
				$sort_by = $s;
				break;
			}
		}
	}
	tem_set("sort_by_$sort_by");
	$listing_rows = db_get_assocs('cms_images', 'id,image,name,caption', 'order by ' . $sorts[$sort_by]);
	tem_set('listings', $listing_rows);
}

function admin_images_main_form($id = false) {
	if($id) {
		tem_set('id', $id);
	}

	if(isset($_POST['name'])) {
		$data = admin_images_get_fields();

		# save anything
		# Note: If you change this to re-display the form in some cases, be sure to handle image uploads well (don't make them upload it again.)

		# save to database
		if($id) {
			db_update_assoc('cms_images', $data, 'where id=%i', $id);
			message('Image updated.');
			$saved_id = $id;
		} else {
			db_insert_assoc('cms_images', $data);
			message('Image saved. Next time you open a page editor, this image will be availble in the "Insert Image" dialog.');
			$saved_id = db_auto_id();
		}

		# return user to display page where they can see instructions, etc
		return "./admin_images";

	} elseif($id) {
		# we've recieved an edit id, but no data. So we grab the values to be edited from the database
		$data = db_get_assoc('cms_images', ADMIN_IMAGES_DB_FIELDS, 'where id=%i', $id);
	} else {
		# form not submitted, set default values:
		$data = array('sizes' => '275x500');
	}

	tem_set('upload_max_filesize', upload_max_filesize());

	tem_set('form', $data);
}