<?php

    /*  Adiciona um novo link   */

    require '../others/session.php';
    require '../others/xmlConverter.php';

    $db = new PDO('sqlite:../../LTW_Trabalho1.db');

    $link = $db->prepare('SELECT * FROM links WHERE url_link = :url_link');
    $link->bindParam(':url_link', $_GET['url_link'], PDO::PARAM_STR);
    $link->execute();
    $resultLink = $link->fetch();

    echo $resultLink['url_link'], "<br>";

    $book = $db->prepare('SELECT * FROM bookmarks WHERE name = :name');
    $book->bindParam(':name', $_GET['name'], PDO::PARAM_STR);
    $book->execute();
    $resultBook = $book->fetch();

    echo $resultBook['name'], "<br>";

    $tag = $db->prepare('SELECT * FROM tags WHERE tagName = :tagName');
    $tag->bindParam(':tagName', $_GET['tagName'], PDO::PARAM_STR);
    $tag->execute();
    $resultTag = $tag->fetch();

    echo $resultTag['tagName'], "<br>";

    if($_GET['url_link'] == null || $_GET['name'] == null || $_GET['tagName'] == null) {       //se o algum parametro nao existir
        $addBook = false;
        if($_GET['xml'] == 1){
            $response = 'miss parameter';
            $root = 'response';
            echo textToXML($response,$root);
        } else {
            $response['response'] = 'miss parameter';
        }
    } else {
        if(!$resultTag){
            $stmt = $db->prepare('INSERT INTO tags (tagName) VALUES (?)');
            $stmt->execute(array($_GET['tagName']));

            echo "tag adicionada <br>";
        }
        if(!$resultLink){
            $addLink = $db->prepare('INSERT INTO links (url_link) VALUES (?)');
            $addLink->execute(array($_GET['url_link']));

            echo "link adicionado <br>";
        }
        if(!$resultBook){
            $link = $db->prepare('SELECT idLink FROM links WHERE url_link = :url_link');
            $link->bindParam(':url_link', $_GET['url_link'], PDO::PARAM_STR);
            $link->execute();
            $result = $link->fetch();

            $idL = $result['idLink'];

            $addBook = $db->prepare('INSERT INTO bookmarks (idUser,idLink,name) VALUES (?,?,?)');
            $addBook->execute(array($_SESSION['idUser'],$idL,$_GET['name']));


            echo "bookmark adicionado <br>";
        }
    }

        $idTag = $db->prepare('SELECT idTag FROM tags WHERE tagName = :tagName');
        $idTag->bindParam(':tagName', $_GET['tagName'], PDO::PARAM_STR);
        $idTag->execute();
        $resultIdTag = $idTag->fetch();

        $idT = $resultTag['idTag'];

        echo $idT,  "<br>";

        $idBook = $db->prepare('SELECT idBookmark FROM bookmarks WHERE name = :Name');
        $idBook->bindParam(':name', $_GET['Name'], PDO::PARAM_STR);
        $idBook->execute();
        $resultIdBook = $idBook->fetch();

        $idB = $resultBook['idBookmark'];

        echo $idB, "<br>";

        $bTag = $db->prepare('SELECT * FROM book_tag WHERE idBookmark = '.$idB.' AND idTag = '.$idT.'');
        $bTag->execute();
        $resultBtag = $bTag->fetch();

        echo $resultBtag['idTag'], "<br>";

        if($resultBtag){

            echo "tag ja associada <br>";

        } else {
            $addBt = $db->prepare('INSERT INTO book_tag (idBookmark, idTag) VALUES (?,?)');
            $addBt->execute(array($idB, $idT));

                echo "tag foi associada <br>";
        }

?>