<?php
/**
 * Created by PhpStorm.
 * User: pierrickmartos
 * Date: 27/10/14
 * Time: 12:06
 */

class DBManager
{
    protected static $instance = null;

    public static function getInstance()
    {
        if (!self::$instance)
            self::$instance = new DBManager();

        return self::$instance;
    }

    /**
     * Insert photo in wordpress table
     *
     * @param Photo $photo
     * @param $wordpressMediaId
     */
    public function insertPhoto(Photo $photo, $wordpressMediaId)
    {
        global $wpdb;

        $table_name = $wpdb->prefix . ADENTIFY_SQL_TABLE_PHOTOS;

        $wpdb->insert(
            $table_name,
            array(
                'time' => current_time( 'mysql' ),
                'wordpress_photo_id' => $wordpressMediaId,
                'adentify_photo_id' => $photo->getId(),
                'thumb_url' => $photo->getSmallUrl()
            )
        );
    }

    /**
     * Insert photos in wordpress table
     *
     * @param $photos
     */
    public function insertPhotos($photos) {
        global $wpdb;

        $table_name = $wpdb->prefix . ADENTIFY_SQL_TABLE_PHOTOS;

        $ids = array();
        foreach($photos as $photo)
            $ids[] = $photo->id;

        $ids = implode(',', $ids);

        $alreadyAddedPhotos = $wpdb->get_results("SELECT adentify_photo_id FROM $table_name WHERE adentify_photo_id IN($ids)");
        foreach($alreadyAddedPhotos as &$photo)
            $photo = $photo->adentify_photo_id;

        foreach($photos as $photo) {
            if (in_array((string)$photo->id, $alreadyAddedPhotos))
                continue;

            if (property_exists($photo, 'small_url') && $photo->small_url) {
                $wpdb->insert(
                    $table_name,
                    array(
                        'time' => current_time( 'mysql' ),
                        'adentify_photo_id' => $photo->id,
                        'thumb_url' => $photo->small_url
                    )
                );
            }
        }
    }

    public function getPhotos()
    {
        global $wpdb;

        $table_name = $wpdb->prefix . ADENTIFY_SQL_TABLE_PHOTOS;
        return $wpdb->get_results("SELECT adentify_photo_id, thumb_url, wordpress_photo_id FROM $table_name");
    }

    public function deletePhoto($wp_photo_id)
    {
        global $wpdb;

        $table_name = $wpdb->prefix . ADENTIFY_SQL_TABLE_PHOTOS;
        return $wpdb->delete($table_name, array('wordpress_photo_id' => $wp_photo_id));
    }
}