<?php
/*
Plugin Name: Kalkulaator
Plugin URI: http://htk.tlu.ee
Description: Kalkuleerib koerte toiduvajaduse.
Version: 1.0
Author: Janari Kaskmaa
Author URI: http://htk.tlu.ee
*/

/* Runs when plugin is activated */
register_activation_hook(__FILE__,'calculator_install'); 

/* Runs on plugin deactivation*/
register_deactivation_hook( __FILE__, 'calculator_remove' );

function calculator_install() {
    global $wpdb;
    $the_page_title = 'Kalkulaator';
    $the_page_name = 'kalkulaator';
    // the menu entry...
    delete_option("my_plugin_page_title");
    add_option("my_plugin_page_title", $the_page_title, '', 'yes');
    // the slug...
    delete_option("my_plugin_page_name");
    add_option("my_plugin_page_name", $the_page_name, '', 'yes');
    // the id...
    delete_option("my_plugin_page_id");
    add_option("my_plugin_page_id", '0', '', 'yes');
    $the_page = get_page_by_title( $the_page_title );
    if ( ! $the_page ) {
        // Create post object
        $_p = array();
        $_p['post_title'] = $the_page_title;
        $_p['post_content'] = "See siin on kalkulaatori leht.";
        $_p['post_status'] = 'publish';
        $_p['post_type'] = 'page';
        $_p['comment_status'] = 'closed';
        $_p['ping_status'] = 'closed';
        $_p['post_category'] = array(1); // the default 'Uncatrgorised'
        // Insert the post into the database
        $the_page_id = wp_insert_post( $_p );
    }
    else {
        // the plugin may have been previously active and the page may just be trashed...
        $the_page_id = $the_page->ID;
        //make sure the page is not trashed...
        $the_page->post_status = 'publish';
        $the_page_id = wp_update_post( $the_page );
    }
    delete_option( 'my_plugin_page_id' );
    add_option( 'my_plugin_page_id', $the_page_id );
}

function calculator_remove() {
    global $wpdb;
    $the_page_title = get_option( "my_plugin_page_title" );
    $the_page_name = get_option( "my_plugin_page_name" );
    //  the id of our page...
    $the_page_id = get_option( 'my_plugin_page_id' );
    if( $the_page_id ) {
        wp_delete_post( $the_page_id ); // this will trash, not delete
    }
    delete_option("my_plugin_page_title");
    delete_option("my_plugin_page_name");
    delete_option("my_plugin_page_id");
}

function kalkulaator($content){
	global $post;
	if($post->post_title=='Kalkulaator'){
		global $current_user;
		get_currentuserinfo();
		/* add food into storage */
		if($_POST['add-kilo']){
			$queryaddstorage = mysql_query('SELECT * FROM wp_food_storage WHERE owner_id="'.$current_user->ID.'" LIMIT 1');
			$row = mysql_fetch_array($queryaddstorage);
			$totalstorage = $row['quantity'];
			if(mysql_num_rows($queryaddstorage)==0){
				mysql_query('INSERT INTO wp_food_storage SET owner_id="'.$current_user->ID.'", quantity="1", date_added="'.time().'"');
			} else {
				$totalstorage=$totalstorage+1;
				mysql_query('UPDATE wp_food_storage SET quantity='.$totalstorage.' WHERE owner_id="'.$current_user->ID.'"');
			}
		}
		/* end of adding food into storage */
		/* subtract food from storage */
		if($_POST['subtract-kilo']){
			$queryaddstorage = mysql_query('SELECT * FROM wp_food_storage WHERE owner_id="'.$current_user->ID.'" LIMIT 1');
			$row = mysql_fetch_array($queryaddstorage);
			$totalstorage = $row['quantity'];
			$totalstorage=$totalstorage-1;
			mysql_query('UPDATE wp_food_storage SET quantity='.$totalstorage.' WHERE owner_id="'.$current_user->ID.'"');
		}
		/* end of subtracting food from storage */
		/* add custom food storage */
		if($_POST['save-custom-storage']){
			$queryaddstorage = mysql_query('SELECT * FROM wp_food_storage WHERE owner_id="'.$current_user->ID.'" LIMIT 1');
			if(mysql_num_rows($queryaddstorage)==0){
				mysql_query('INSERT INTO wp_food_storage SET owner_id="'.$current_user->ID.'", quantity="'.$_POST['custom-storage'].'", date_added="'.time().'"');
			} else {
				mysql_query('UPDATE wp_food_storage SET quantity='.$_POST['custom-storage'].' WHERE owner_id="'.$current_user->ID.'"');
			}
		}
		/* end of adding custom food storage */
	?>
	<div id="calculator">
		<?php
		if($current_user->nickname!=''){
		?>
		<h3>Toiduvajadus teie koertel (kuus)</h3>
		<?php
			$query = mysql_query('SELECT wdb.dog_name, wdb.dog_pregnant, wdb.dog_age, wdbr.breed FROM wp_dog_base AS wdb INNER JOIN wp_dog_breed AS wdbr ON wdb.dog_breed=wdbr.id WHERE owners_id='.$current_user->ID.'');
			while($row = mysql_fetch_array($query)){
				$birthdate = $row['dog_age'];
				$agestamp = time()-$birthdate;
				$age = ceil($agestamp/60/60/24/365);
				if($age<2){
					if($row['dog_pregnant']==1){
						$puppy .= $row['dog_name'].', '.$row['breed'].' '.$age.'a (tiine) - ('.($age*10).' kg)<br/>';
					} else {
						$puppy .= $row['dog_name'].', '.$row['breed'].' '.$age.'a - ('.($age*10).' kg)<br/>';
					}
				} else {
					if($row['dog_pregnant']==1){
						$adult .= $row['dog_name'].', '.$row['breed'].' '.$age.'a (tiine) - ('.($age*10).' kg)<br/>';
					} else {
						$adult .= $row['dog_name'].', '.$row['breed'].' '.$age.'a - ('.($age*10).' kg)<br/>';
					}
				}
			}
		?>
		<br/>
		<?php if($puppy!=''){ echo 'Kutsikad:<br/>'.$puppy; } ?><br/>
		<?php if($adult!=''){ echo 'Täiskasvanud:<br/>'.$adult; } ?><br/>
		<form method="post" id="save-dog-info-1">
		Arvestuslikult on toitu veel alles
		<?php
		$querystorage = mysql_query('SELECT quantity FROM wp_food_storage WHERE owner_id='.$current_user->ID.' LIMIT 1');
		$row = mysql_fetch_array($querystorage);
		if($row['quantity']>0){
			echo '<input type="submit" class="form-submit-button" name="subtract-kilo" value="-" />';
		} else {
			$row['quantity']=0;
		}
		echo ' <input type="text" name="custom-storage" id="food-in-storage" onkeyup="addcustomvalue(this.value);" value="'.$row['quantity'].'" />
		<input type="submit" class="form-submit-button" name="add-kilo" value="+" /> kilogrammi (seisuga '.date('d.m.Y'.$row['date_added']).')';
		?>
		<br/><input type="submit" class="form-submit-button" id="save-custom-storage" name="save-custom-storage" value="Salvesta" />
		</form><br/>
		<?php
		} else {
			echo '<h2>Logige sisse!</h2>';
		}
		?>
	</div>
	<?php
	} else {
		echo $post->post_content;
	}
}
add_filter('the_content', 'kalkulaator');
?>