<?php

/**

* Created by PhpStorm.

* User: Fernan

* Date: 26/05/2016

* Time: 00:45

*/

function base64_to_jpeg($base64_string, $output_file)

}

$data = json_decode(file_get_contents('php://input'), true);

require("config/database.php");

if (isset($data["id_delete"])) {

try {

$sql = $db->prepare('DELETE FROM pictures WHERE id = :id AND user_id = :user_id');

$sql->bindParam(':id', $data["id_delete"]);

$sql->bindParam(':user_id', $data["user_id"]);

$db->beginTransaction();

$sql->execute();

$db->commit();

if ($sql)

echo "success";

else

echo "fail";

} catch (PDOException $ex) {

echo "An Error occured! : " . $ex->getMessage();

}

}

if (isset($data["title"])) {

$username = $_SESSION['username'];

$fp = fopen('temp/blend.png', 'rb'); // read binary

try {

$sql = $db->prepare('INSERT INTO pictures (user_id, src, title, date) VALUES ((SELECT id FROM user WHERE username = :username), :src, :title, :date)');

$sql->bindParam(':username', $username, PDO::PARAM_STR);

$sql->bindParam(':src', $fp, PDO::PARAM_LOB);

$sql->bindParam(':title', $data["title"]);

$sql->bindParam(':date', $data["date"]);

//$records = $db->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));

$db->beginTransaction();

$sql->execute();

$db->commit();

if ($sql)

echo "success";

else

echo "fail";

} catch (PDOException $ex) {

echo "An Error occured! : " . $ex->getMessage();

}

}

if (isset($data['picture_src'])) {

//fetch pictures src

$sql = $db->prepare('SELECT src FROM pictures WHERE id = :id');

$sql->bindParam(':id', $data["picture_src"]);

$sql->execute();

$picture = $sql->fetchAll();

echo ('data:image/png;base64,' . base64_encode($picture[0]["src"]));

}

if (isset($data["test"])) {

//fetch pictures first

$sql = 'SELECT pic.id, pic.src, pic.title, pic.date, us.username

FROM pictures pic INNER JOIN user us ON pic.user_id = us.id';

$records = $db->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));

$records->execute();

$pictures = $records->fetchAll();

$limit = count($pictures) + 1;

$i = $data['position'];

function countLikes($index, $likes)

}

$node_to_add = '<div class="columns" id="column-card">

<div class="card">

<div class="image">

<div class="image-wrapper overlay-fade-in">

<img width="527px" id="' . $pictures[$i]["id"] . '" height="350" src="data:image/png;base64,' . base64_encode($pictures[$i]["src"]) . '">

<span class="title" id="image-title' . $i . '">' . htmlspecialchars($pictures[$i]["title"], ENT_QUOTES, "UTF-8") . '</span>

<div onmouseenter="mouseEnter(\'' . $i . '\')" onmouseleave="mouseLeave(\'' . $i . '\')" class="image-overlay-content" onclick="sendAjaxToOpenModal(

\'' . $pictures[$i]["id"] . '\'

)">

<h2>' . htmlspecialchars($pictures[$i]["title"], ENT_QUOTES, "UTF-8") . '</h2>

<p style="top: 0px !important" class="title">Posted by ' . htmlspecialchars($pictures[$i]["username"], ENT_QUOTES, "UTF-8") . ' on ' . $pictures[$i]["date"] . '</p>

<p class="title">' . countLikes($pictures[$i]["id"], $likes) . ' likes / ' . countLikes($pictures[$i]["id"], $comments) . ' Comments</p><br>

</div>

</div>

</div>

</div>

</div>';

$resp_infinite = array();

$resp_infinite[0] = $node_to_add;

$resp_infinite[1] = $limit;

echo json_encode($resp_infinite);

}

if (isset($data["url"])) {

$face = $data["face"];

$pictureName = $data["url"];

$facePicture = 'faces/' . $face . '.png';

base64_to_jpeg($pictureName, 'temp/preview.png');

$dest = imagecreatefrompng("temp/preview.png");

$src = imagecreatefrompng($facePicture);

// imagealphablending($image_1, true);

// imagesavealpha($image_1, true);

// imagecopy($image_1, $image_2, 0, 0, 0, 0, 100, 100);

// imagepng($image_1, 'image_3.png')

imagealphablending($dest, true);

imagesavealpha($dest, true);

imagecopy($dest, $src, 100, 0, 0, 0, 100, 142); //have to play with these numbers for it to work for you, etc.

header('Content-Type: image/png');

imagepng($dest, 'temp/blend.png');

imagedestroy($dest);

imagedestroy($src);

echo('temp/blend.png');

}

if (isset($data["picture_to_like"])) {

$username = $_SESSION['username'];

try {

$sql = $db->prepare('INSERT INTO likes (username, picture_id) VALUES(:username, :picture_id)');

$sql->bindParam(':username', $username, PDO::PARAM_STR);

$sql->bindParam(':picture_id', $data["picture_to_like"]);

$db->beginTransaction();

$sql->execute();

$db->commit();

if ($sql)

echo "success";

else

echo "fail";

} catch (PDOException $ex) {

echo "An Error occured! : " . $ex->getMessage();

}

}

if (isset($data["picture_to_unlike"])) {

$username = $_SESSION['username'];

try {

$sql = $db->prepare('DELETE FROM likes WHERE picture_id = :picture_id AND username = :username');

$sql->bindParam(':username', $username, PDO::PARAM_STR);

$sql->bindParam(':picture_id', $data["picture_to_unlike"]);

$db->beginTransaction();

$sql->execute();

$db->commit();

if ($sql)

echo "success";

else

echo "fail";

} catch (PDOException $ex) {

echo "An Error occured! : " . $ex->getMessage();

}

}

if (isset($data["comment"])) {

$username = $_SESSION['username'];

try {

$sql = $db->prepare('INSERT INTO Comments (username, picture_id, comment, date_published) VALUES(:username, :picture_id, :comment, :date_published)');

$sql->bindParam(':username', $username, PDO::PARAM_STR);

$sql->bindParam(':picture_id', $data["picture_id"]);

$sql->bindParam(':comment', $data["comment"]);

$sql->bindParam(':date_published', $data["date"]);

$db->beginTransaction();

$sql->execute();

$db->commit();

$records_init = $db->prepare('SELECT username, email FROM user WHERE username = :username');

$records_init->bindParam(':username', $data['owner']);

$records_init->execute();

$results_1 = $records_init->fetchAll();

if (count($results_1[0]) > 0) {

$user_target = $results_1[0]['username'];

$email = $results_1[0]['email'];

$headers = "From: test@mydomain.com";

$msg = "Hello " . $user_target . "\r\n" .

$username . " just commented your picture " . $data['pic_title'] . " on " . $data['date']

. "\r\n" . "\r\n" .

"comment : " . "\r\n" .

"\" " . $data['comment'] . " \"" . "\r\n" . "\r\n" .

"Thank you," . "\r\n" .

"The Camagru Team";

mail($email, "Camagru : One of your picture has a new comment !", $msg, $headers);

}

if ($sql)

echo "success";

else

echo "fail";

} catch (PDOException $e) {

echo "An Error occured! : " . $e->getMessage();

}

}

if (isset($data["modal_id"])) {

function fetchLikes($index, $likes)

}

function fetchComments($index, $comments)

}

$pic_id = $data["modal_id"];

//fetch pictures first

$sql = 'SELECT pic.id, pic.src, pic.title, pic.date, us.username

FROM pictures pic INNER JOIN user us ON pic.user_id = us.id';

$records = $db->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));

$records->execute();

$pictures = $records->fetchAll();

//then likes

$sql2 = 'SELECT username, picture_id FROM likes';

$records2 = $db->prepare($sql2, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));

$records2->execute();

$likes = $records2->fetchAll();

//and finally comments

$sql3 = 'SELECT username, picture_id, comment, date_published FROM Comments';

$records3 = $db->prepare($sql3, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));

$records3->execute();

$comments = $records3->fetchAll();

$found = -1;

for ($index = 0; $index < count($pictures); $index++) {

if ($pictures[$index]["id"] == $pic_id) {

$found = $index;

$pic_likes = fetchLikes($pictures[$index]["id"], $likes);

$pic_comments = fetchComments($pictures[$index]["id"], $comments);

break;

}

}

if ($found > -1) {

$username = $_SESSION['username'];

$response = array();

$response[0] = $username;

$response[1] = $pictures[$found]["title"];

$response[2] = $pictures[$found]["date"];

$response[3] = $pictures[$found]["username"];

$response[4] = $pictures[$found]["id"];

$response[5] = $pic_likes;

$response[6] = $pic_comments;

echo json_encode($response);

} else

echo "fail";

}

?>