<?php

namespace TrackModel;

 
/**
 * Tracking_Model
 * 
 * @package Affiliate Hoover
 * @author Andy Walpole
 * @copyright Andy Walpole
 * @link http://andywalpole.me/
 * @version development
 * @access public
 * @license GPLv2: http://www.gnu.org/licenses/gpl-2.0.html
 * 
 * Wordpress functions:
 * 
 * wp_verify_nonce()
 * http://codex.wordpress.org/Function_Reference/wp_verify_nonce
 * 
 * update_post_meta()
 * http://codex.wordpress.org/Function_Reference/update_post_meta
 * 
 * add_post_meta()
 * http://codex.wordpress.org/Function_Reference/add_post_meta
 * 
 */
 
class Tracking_Model {

    function __construct() {


    }

    /**
     * Tracking_Model::update_tracking()
     * Used for AJAX updates tracking table when user clicks on an affiliate link
     * 
     * @return no return or the AJAX fucks up
     */
    public static function update_tracking() {

        if (!wp_verify_nonce($_REQUEST['nonce'], 'myajax-nonce')) die('Busted!');

        $digit = preg_replace('/[^0-9]|,[0-9]*$/', '', $_REQUEST['post']);

        $digit = (int)$digit;

        $meta = get_post_meta($digit, '_tracking');

        if ($meta) {

            // if post exists then add to previous total
            $new_total = (int)$meta + 1;

            update_post_meta($digit, '_tracking', (string )$new_total);

        } else {

            // if it doesn't exist then create one
            add_post_meta($digit, '_tracking', "1");

        }

        global $wpdb;

        $wpdb->query($wpdb->prepare("INSERT INTO ".AH_TRACKING_TABLE.
            " (date, post_id, ip) VALUES (now(), %d, %s)", $digit, (string )$_SERVER['REMOTE_ADDR']));

        die();

    }

    /**
     * Tracking_Model::get_all()
     * 
     * @param mixed $limit - for pagination
     * @return
     */
    public function get_all($limit) {

        global $wpdb;
        return $wpdb->get_results("SELECT ip,post_id,date FROM ".AH_TRACKING_TABLE.
            " ORDER BY date DESC ".$limit);
    }

    /**
     * Tracking_Model::total_entries()
     * Finds total entries of posts in ah_tracking table and that which are currently still live
     * 
     * @return
     */
    public function total_entries() {

        global $wpdb;
        $total = $wpdb->get_results("SELECT id, post_id FROM ".AH_TRACKING_TABLE);
        static $i = 1;
        $new_total = NULL;
        foreach ($total as $result) {

            $post = (int)$result->post_id;
            $post = get_post($post, OBJECT);
            if ($post === NULL) continue;
            $new_total = $i++;
        }

        return $new_total;
    }

    /**
     * Tracking_Model::update_options()
     * 
     * Changes option field for ah_tracking
     * 
     * @param mixed $var
     */
    public function update_options($var) {

        if (isset($var) && $var === TRUE) {

            $option = get_option('ah_tracking');

            if ($option) {

                update_option('ah_tracking', TRUE);

            } else {

                update_option('ah_tracking', TRUE);

            }

        } else {

            $option = get_option('ah_tracking');

            if ($option) {

                update_option('ah_tracking', FALSE);

            } else {

                update_option('ah_tracking', FALSE);

            }

        } // end if

    }

}

?>