<?php

global $wpdb;

define('GIGS_DB_PREFIX', apply_filters('gigCal_db_prefix', $wpdb->prefix));

define('TABLE_VENUES', GIGS_DB_PREFIX . 'gigs_venue');

define('TABLE_GIGS', GIGS_DB_PREFIX . 'gigs_gig');

define('TABLE_PERFORMANCES', GIGS_DB_PREFIX . 'gigs_performance');

define('TABLE_TOURS', GIGS_DB_PREFIX . 'gigs_tour');

class dtcGigs {

	function generateSlug($x) {

		$x = strtolower($x);

		$x = str_replace(' ', '-', $x);

		$x = preg_replace('#[^a-z\-0-9]#', '', $x);

		return $x;

	}

	function escapeForInput($x) {

		if ( '0000-00-00' == $x ) {

			$x = '';

		}

		echo htmlspecialchars($x);

	}

	function dateFormat($date, $type = 'short') {

		if ( is_null($date) || $date == '0000-00-00' ) return null;

		$options = get_option('gigs-calendar');

		if ( isset($options['date'][$type]) ) {

			return mysql2date($options['date'][$type], $date);

		} else {

			return mysql2date($type, $date);

		}

	}

	function selectFields($fields, $g) {

		$options = get_option('gigs-calendar');

		$result = '';

		foreach ( $options['gigs-table-show'] as $f ) {

			if ( isset($fields[$f]) ) {

				$tmp = $fields[$f];

				if ( $f == 'venue' && $options['list-venue-link'] && !empty($g->venueLink) ) {

					$tmp = preg_replace("~\{(.*?)\}~", '<a href="' . $g->venueLink . '">\1</a>', $tmp);

				} elseif ( $f == $options['gig-link-field'] ) {

					$tmp = preg_replace("~\{(.*?)\}~", '<a href="' . $g->permalink . '">\1</a>', $tmp);

				} else {

					$tmp = preg_replace("~\{(.*?)\}~", '\1', $tmp);

				}

				$result .= $tmp;

			}

		}

		return $result;

	}

	function timeFormat($time, $format = false) {

		$options = get_option('gigs-calendar');

		if ( is_null($time) ) {

			return $options['tbd-text'];

		}

		if ( $options['time-12h'] || $format === "12h" ) {

			return mysql2date("g:ia", '2008-01-01 ' . $time);

		} else {

			return mysql2date("H:i", '2000-01-01 ' . $time);

		}

	}

	function mapLink($gig) {

		global $options;

		if ( empty($gig->customMap) ) {

			$a = array();

			if ( empty($gig->address) ) 

				$a[] = $gig->name . ' near:';

			else {}

				$a[] = str_replace("\n", ", ", $gig->address);

			if ( !empty($gig->city) ) $a[] = $gig->city;

			if ( !empty($gig->state) ) $a[] = $gig->state;

			if ( !empty($gig->country) ) $a[] = $gig->country;

			if ( !empty($gig->postalCode) ) $a[] = $gig->postalCode;

			return 'http://maps.google.com/?q=' . urlencode(str_replace('near:,', 'near:', implode(', ', $a)));

		} else {

			if ( preg_match("/^https?:\/\//", $gig->customMap) ) {

				return $gig->customMap;

			} else {

				return 'http://maps.google.com/?q=' . urlencode($gig->customMap);

			}

		}

	}

	function getAttribution() {

		$options = get_option('gigs-calendar');

		?>

			<div class="attribution">

				<?php if ( $options['b4b-link'] ) : ?>

					<span class="b4b">Powered by <a target="_blank" href="http://blogsforbands.com">Blogs for Bands</a></span>

				<?php endif; ?>

				<?php if ( $options['silk-link'] ) : ?>

					<span class="silk">Silk icons by <a target="_blank" href="http://www.famfamfam.com/lab/icons/silk/">Mark James</a></span>

				<?php endif; ?>

			</div>

		<?php

	}

	function loadTemplate($file, $template = null, $data = array()) {

		$options = get_option('gigs-calendar');

		global $gcd;

		if ( is_null($template) ) {

			$template = $options['template'];

		}

		$folder = dtc_gigs::get_url();

		extract($data);

		if ( is_file(dirname(__FILE__) . '/templates/' . $template . '/' . $file . '.php') ) {

			include(dirname(__FILE__) . '/templates/' . $template . '/' . $file . '.php');

		} elseif ( is_file(ABSPATH . 'wp-content/gigs-templates/' . $template . '/' . $file . '.php') ) {

			include(ABSPATH . 'wp-content/gigs-templates/' . $template . '/' . $file . '.php');

		} else {

			include(dirname(__FILE__) . '/templates/basic/' . $file . '.php');				

		}

	}

	function extraFields($fields, &$data, $gig = "new") {

		foreach ( $fields as $key => $field ) {

			if ( isset($data[$field['name']]) ) {

				$value = array_pop($data[$field['name']]);

				if ( empty($data[$field['name']]) ) unset($data[$field['name']]);

			} else {

				$value = $field['default'];

			}

			?>

				<tr class="<?php echo addslashes($field['name']) ?>">

					<td valign="top" class="<?php echo addslashes($field['name']) ?>">

						<input type="hidden" value="<?php echo addslashes($field['name']) ?>" name="custom-key[<?php echo $key ?>]" />

						<label for="custom-<?php echo $gig ?>-<?php echo $key ?>"><?php echo $field['label'] ?></label>

						<textarea style="display:none;" rows="1" name="old-custom-value[<?php echo $key ?>]"><?php echo htmlspecialchars((is_array($value) ? serialize($value) : $value)) ?></textarea>

						<input class="delete" type="hidden" name="deletecustom[<?php echo $key ?>]" value="0" />

					</td>

					<td>

						<?php if ( $field['type'] == 'text' ) : ?>

							<input name="custom-value[<?php echo $key ?>]" type="text" id="custom-<?php echo $gig ?>-<?php echo $key ?>" value="<?php echo addslashes($value); ?>" />

						<?php elseif ( $field['type'] == 'date' ) : ?>

							<input class="date-field" name="custom-value[<?php echo $key ?>]" type="text" id="custom-<?php echo $gig ?>-<?php echo $key ?>" value="<?php echo addslashes($value); ?>" />

						<?php elseif ( $field['type'] == 'textarea' ) : ?>

							<textarea rows="1" id="custom-<?php echo $gig ?>-<?php echo $key ?>" name="custom-value[<?php echo $key ?>]"><?php echo htmlspecialchars($value) ?></textarea>

						<?php elseif ( $field['type'] == 'select' ) : ?>

							<select id="custom-<?php echo $gig ?>-<?php echo $key ?>" name="custom-value[<?php echo $key ?>]">

								<?php foreach ( $field['options'] as $oKey => $oValue ) : ?>

									<option value="<?php echo addslashes($oKey) ?>"<?php if ( $oKey == $value ) echo ' selected="selected"' ?>><?php echo $oValue ?></option>

								<?php endforeach; ?>

							</select>

						<?php elseif ( $field['type'] == 'radio' ) : ?>

							<?php foreach ( $field['options'] as $oKey => $oValue ) : ?>

								<input type="radio" id="custom-<?php echo $gig ?>-<?php echo $key ?>-<?php echo addslashes($oKey) ?>" name="custom-value[<?php echo $key ?>]" value="<?php echo addslashes($oKey) ?>" <?php if ( $value == $oKey ) echo 'checked="checked"' ?> /> 

								<label for="custom-<?php echo $gig ?>-<?php echo $key ?>-<?php echo addslashes($oKey) ?>">

									<?php echo $oValue ?>

								</label>

								<br />

							<?php endforeach; ?>

						<?php elseif ( $field['type'] == 'checkbox' ) : ?>

							<?php $values = is_array($value) ? $value : unserialize($value); ?>

							<?php foreach ( $field['options'] as $oKey => $oValue ) : ?>

								<input type="checkbox" id="custom-<?php echo $gig ?>-<?php echo $key ?>-<?php echo addslashes($oKey) ?>" name="custom-value[<?php echo $key ?>][]" value="<?php echo addslashes($oKey) ?>" <?php if ( in_array($oKey, $values) ) echo 'checked="checked"' ?> /> 

								<label for="custom-<?php echo $gig ?>-<?php echo $key ?>-<?php echo addslashes($oKey) ?>">

									<?php echo $oValue ?>

								</label>

								<input type="hidden" name="custom-value[<?php echo $key ?>][]" value="" /> 

								<br />

							<?php endforeach; ?>

						<?php endif; ?>

					</td>

				</tr>

			<?php

		}

	}

	function get_gig_css_classes($gig) {

		if ( is_object($gig) && isset($gig->id) ) {

			$gig = $gig->id;

		} elseif ( is_array($gig) && isset($gig['id']) ) {

			$gig = $gig['id'];

		}

		$g = new gig();

		if ( !$g->get($gig) ) {

			return false;

		}

		$classes = array(

			'gig',

			mysql2date('\yY', $g->date),

			mysql2date('\mm', $g->date),

			( $g->date >= date('Y-m-d') ? 'upcoming' : 'archive' ),

		);

		$classes = array_merge($classes, $g->getTags(true, 'gc-'));

		return implode(' ', apply_filters('gigCal_gigs_css_classes', $classes, $g));

	}

}

class dtc_gigs_baseAR {

	var $wpdb, $_rows, $_row, $_new = true, $_table, $_count;

	function dtc_gigs_baseAR($id = null){

		global $wpdb;

		$this->wpdb = $wpdb;

		if ( $id !== null ) {

			$this->get($id);

		}

	}

	function fetch() {

		if ( count($this->_rows) ) {

			$this->_row = each($this->_rows);

			if ( $this->_row ) {

				$this->load();

				return true;

			} else {

				return false;

			}

		} else {

			return false;

		}

	}

	function generate_slug() {

		if ( isset($this->slug) ) {

			$first = true;

			$name = $this->_name;

			do {

				if ( $first ) {

					$this->slug = dtcGigs::generateSlug($this->$name);

					$first = false;

				} else {

					ereg('[0-9]*$', $this->slug, $match);

					$match = ((int) $match[0]) + 1;

					if ( 1 == $match ) $match++;

					$this->slug = preg_replace('/[0-9]*$/', '', $this->slug);

					$this->slug .= $match;

				}

			} while ( $this->wpdb->get_var('SELECT COUNT(*) FROM `' . $this->_table . '` WHERE slug = "' . $this->slug . '"') );

		}

	}

	function get($id) {

		$this->search('`id` = ' . (int) $id);

		return $this->fetch();

	}

	function getRow() {

		$row = array();

		foreach ( $this->_fields as $f ) {

			$row[$f]  = $this->$f;

		}

		return $row;

	}

	function getTags($slugs = false, $prefix = '') {

		if ( function_exists('wp_get_post_tags') ) {

			$tags = wp_get_post_tags($this->postID);

			foreach ( $tags as $key => $tag ) {

				$tags[$key] = $prefix . ($slugs ? $tag->slug : $tag->name);

			}

			return $tags;

		} else {

			return array();

		}

	}

	function getCustom() {

		if ( !empty($this->postID) ) {

			return get_post_custom($this->postID);

		}

	}

	function setTags($tags) {

		if ( function_exists('wp_set_post_tags') )

			wp_set_post_tags($this->postID, $tags, false);

	}

	function load() {

		foreach ( $this->_fields as $f ) {

			if ( is_null($this->_row['value']->$f) ) {

				$this->$f = null;

			} else {

				$this->$f = stripslashes($this->_row['value']->$f);

			}

		}

	}

	function search($where = null, $order = null) {

		$this->_new = false;

		$this->_rows = $this->wpdb->get_results('SELECT * FROM `' . $this->_table . '` ' . ($where !== null ? 'WHERE ' . $where : '') . ($order !== null ? ' ORDER BY ' . $order : ''));

		$this->_count = count($this->_rows);

		return count($this->_rows);

	}

	function save($get_after = true) {

		$first = true;

		$name = $this->_name;

		$this->generate_slug();

		if ( $this->_new ) {

			$fields = $this->_fields;

			$values = array();

			unset($fields[0]);

			$this->pre_insert();

			foreach ( $fields as $f ) {

				if ( is_null($this->$f) ) {

					$values[$f] = 'null';

				} else {

					$values[$f] = '"' . $this->wpdb->escape(stripslashes($this->$f)) . '"';

				}

			}

			if ( !$this->wpdb->query('INSERT INTO `' . $this->_table . '` (`' . implode('`, `', $fields) . '`) VALUES (' . implode(', ', $values) . ')') ) {

				return false;

			}

			$this->id = $this->wpdb->insert_id;

			$this->post_insert();

			if ( $get_after ) 

				$this->get((int) $this->id);

			return true;

		} else {

			$fields = $this->_fields;

			$values = array();

			unset($fields[0]);

			$this->pre_update();

			foreach ( $fields as $f ) {

				if ( is_null($this->$f) ) {

					$values[$f] = '`' . $f . '` = null';

				} else {

					$values[$f] = '`' . $f . '` = "' . $this->wpdb->escape(stripslashes($this->$f)) . '"';

				}

			}

			$result = (bool) $this->wpdb->query('UPDATE `' . $this->_table . '` SET ' . implode(', ', $values) . ' WHERE `id` = ' . (int) $this->id);

			if ( $result ) $this->post_update();

			if ( $get_after ) 

				$this->get((int) $this->id);

			return $result;

		}

	}

	function pre_insert(){}

	function post_insert(){}

	function pre_update(){}

	function post_update(){}

	function extraJSON() {return array();}

	function delete() {

		if ( !empty($this->id) ) {

			return (bool) $this->wpdb->query('DELETE FROM `' . $this->_table . '` WHERE `id` = ' . (int) $this->id);