function __construct()
{
self::$userDAO = new UserDAO();
self::$dayDAO = new DayDAO();
self::$contentTypeId = self::$userDAO->getIdForSharedContentType('picture');
self::$securityService = new SecurityService();
}
public function saveFileToDB($filepath, $userid)
{
ini_set('exif.encode_unicode', 'UTF-8');
error_log($filepath);
try {
try {
$exif_ifd0 = read_exif_data($filepath, 'IFD0', 0);
$exif_exif = read_exif_data($filepath, 'EXIF', 0);
$exif_file = read_exif_data($filepath, 'FILE', 0);
} catch (Exception $e) {
}
$timetaken = null;
$filename = $exif_file['FileName'];
if (isset($exif_exif['DateTimeOriginal'])) {
//We get the date and time the picture was taken
try {
$exif_date = $exif_exif['DateTimeOriginal'];
error_log("EXIF TIME TAKEN : " . $exif_date);
$exif_timetaken = date("Y-m-d H:i:s", strtotime($exif_date));
} catch (Exception $e) {
error_log($e->getMessage());
}
}
if (isset($exif_ifd0['DateTime'])) {
//We get the date and time the picture was taken
try {
$ifd0_date = $exif_ifd0['DateTime'];
error_log("IFDO TIME TAKEN : " . $ifd0_date);
$ifd0_timetaken = date("Y-m-d H:i:s", strtotime($ifd0_date));
} catch (Exception $e) {
error_log($e->getMessage());
}
}
//We chose the earliest date of the 2
if (isset($exif_date) && isset($ifd0_date)) {
$rawTimeTaken = $exif_date < $ifd0_date ? $exif_date : $ifd0_date;
error_log("FINAL TIME TAKEN : " . $rawTimeTaken);
$timetaken = date("Y-m-d H:i:s", strtotime($rawTimeTaken));
} else {
if (isset($exif_date)) {
$rawTimeTaken = $exif_date;
error_log("FINAL TIME TAKEN : " . $rawTimeTaken);
$timetaken = date("Y-m-d H:i:s", strtotime($rawTimeTaken));
} else {
if (isset($ifd0_date)) {
$rawTimeTaken = $ifd0_date;
error_log("FINAL TIME TAKEN : " . $rawTimeTaken);
$timetaken = date("Y-m-d H:i:s", strtotime($rawTimeTaken));
} else {
$rawTimeTaken = $exif_file['FileDateTime'];
$timetaken = date("Y-m-d H:i:s", $rawTimeTaken);
}
}
}
error_log("TIME TAKEN : " . $timetaken);
$fileType = $exif_file['MimeType'];
//$payload = file_get_contents($filepath);
$picture = new Picture(0, "", "", $timetaken, $fileType, null, $filename);
$picture->latitude = "";
$picture->longitude = "";
$dao = new PictureDAO();
$dayId = $dao->createDay($userid, $timetaken);
$dao->savePicture($dayId, $picture);
error_log("File saved successfully.");
//unlink($filepath);
} catch (Exception $e3) {
print "Error!: " . $e3->getMessage() . "<br/>";
//unlink($filepath);
}
}
<?php
require_once dirname(dirname(__FILE__)) . '/dao/PictureDAO.php';
require_once dirname(dirname(__FILE__)) . '/dao/UserDAO.php';
//error_reporting(E_ERROR | E_PARSE);
session_start();
//var_dump($_SESSION);
if (isset($_SESSION['name'])) {
$userid = $_SESSION["userid"];
$username = $_SESSION['username'];
$loggedIn = true;
$dayToDisplay = $_SESSION['dayToDisplay'];
}
$userDAO = new UserDAO();
$fbToken = $userDAO->getUserToken($userid);
$pictureDAO = new PictureDAO();
$pictures = $pictureDAO->getAllPicturesForDay($dayToDisplay);
?>
<style>
.ui-autocomplete-loading { background: white url('images/ui-anim_basic_16x16.gif') right center no-repeat; }
#city { width: 25em; }
</style>
<script>
var picShareOverlay = {};
picShareOverlay.fbToken = "<?php
echo $fbToken;
?>
";
}
}
error_log("date : " . $dayToDisplay);
if ($dayToDisplay === 0) {
$chosenDate = date("Y-m-d", strtotime($theDate));
$diplayDate = date("Y F j l", strtotime($theDate));
} else {
$chosenDate = date("Y-m-d", strtotime($dayDAO->getDateForDayId($userid, $dayToDisplay)));
$diplayDate = date("Y F j l", strtotime($dayDAO->getDateForDayId($userid, $dayToDisplay)));
}
error_log("chosenDate : " . $chosenDate);
$_SESSION['chosenDate'] = $chosenDate;
$_SESSION['diplayDate'] = $diplayDate;
//used when we share content for a day
$_SESSION['dayToDisplay'] = $dayToDisplay;
$pictureDAO = new PictureDAO();
$pictures = $pictureDAO->getAllPicturesForDay($dayToDisplay);
$sharedpictures = $pictureDAO->getSharedPicturesForUser($userid, $chosenDate);
error_log("ID: " . sizeof($sharedpictures));
$pictures = array_merge($pictures, $sharedpictures);
//Facebook Statuses
$userDAO = new UserDAO();
$statusUpdate = $userDAO->retrieveRandomStatusUpdateForDay($userid, $dayToDisplay);
$statusUpdateFound = false;
if (isset($statusUpdate)) {
$statusUpdateFound = true;
}
$picturesFound = sizeof($pictures) > 0;
?>
<script type="text/javascript">
<?php
require_once dirname(dirname(__FILE__)) . '/bootstrap.php';
require_once dirname(dirname(__FILE__)) . '/services/DropboxService.php';
require_once dirname(dirname(__FILE__)) . '/dao/PictureDAO.php';
error_reporting(E_ERROR | E_PARSE);
session_start();
$filePath = "";
if (isset($_GET["filename"])) {
$filePath = $_GET["filename"];
}
$OAuth = new \Dropbox\OAuth\Consumer\Curl($key, $secret, $storage, $callback);
$dropbox = new \Dropbox\API($OAuth);
$service = new DropboxService();
$pictureDAO = new PictureDAO();
if (!$pictureDAO->isPictureForUserExistingByFile($_SESSION['userid'], Util::getFileNameFromPath($filePath))) {
$service->fetchFile($dropbox, $filePath, $_SESSION['username'], $_SESSION['userid']);
}
private function saveFileToDB($filepath)
{
ini_set('exif.encode_unicode', 'UTF-8');
error_log($filepath);
try {
try {
$exif_ifd0 = read_exif_data($filepath, 'IFD0', 0);
$exif_exif = read_exif_data($filepath, 'EXIF', 0);
$exif_file = read_exif_data($filepath, 'FILE', 0);
} catch (Exception $e) {
}
$timetaken = null;
$filename = $exif_file['FileName'];
if (isset($exif_ifd0['DateTime'])) {
//We get the date and time the picture was taken
try {
$rawTimeTaken = $exif_ifd0['DateTime'];
error_log("IFDO TIME TAKEN : " . $rawTimeTaken);
$timetaken = date("Y-m-d H:i:s", strtotime($rawTimeTaken));
} catch (Exception $e) {
}
} else {
if (isset($exif_exif['DateTimeOriginal'])) {
//We get the date and time the picture was taken
try {
$rawTimeTaken = $exif_exif['DateTimeOriginal'];
error_log("EXIF TIME TAKEN : " . $rawTimeTaken);
$timetaken = date("Y-m-d H:i:s", strtotime($rawTimeTaken));
} catch (Exception $e) {
}
} else {
$rawTimeTaken = $exif_file['FileDateTime'];
$timetaken = date("Y-m-d H:i:s", $rawTimeTaken);
}
}
error_log("NEW TIME TAKEN : " . $timetaken);
$fileType = $exif_file['MimeType'];
/* $exif = exif_read_data($filepath, 'IFD0');
foreach ($exif as $key => $section) {
foreach ($section as $name => $val) {
error_log("$key.$name: $val");
}
} */
//Reduce file size
$img = imagecreatefromjpeg($filepath);
$quality = 100;
$currentFileSize = filesize($filepath);
switch ($currentFileSize) {
case $currentFileSize > 3500000:
$quality = 15;
break;
case $currentFileSize > 2000000:
$quality = 30;
break;
case $currentFileSize > 1000000:
$quality = 60;
break;
case $currentFileSize > 500000:
$quality = 70;
break;
}
imagejpeg($img, $filepath, $quality);
imagedestroy($img);
$payload = file_get_contents($filepath);
$picture = new Picture(0, "", "", $timetaken, $fileType, $payload, $filename);
$picture->latitude = "";
$picture->longitude = "";
$dao = new PictureDAO();
$dayId = $dao->createDay(1, $timetaken);
$dao->savePicture($dayId, $picture);
unlink($filepath);
} catch (Exception $e) {
error_log("Exception!!! --- " . $e);
//unlink($filepath);
}
}
private function saveFileToDB($filepath)
{
ini_set('exif.encode_unicode', 'UTF-8');
error_log($filepath);
try {
try {
$exif_ifd0 = read_exif_data($filepath, 'IFD0', 0);
$exif_exif = read_exif_data($filepath, 'EXIF', 0);
$exif_file = read_exif_data($filepath, 'FILE', 0);
} catch (Exception $e) {
}
var_dump($exif_ifd0);
var_dump($exif_exif);
$timetaken = null;
$filename = $exif_file['FileName'];
if (isset($exif_exif['DateTimeOriginal'])) {
//We get the date and time the picture was taken
try {
$exif_date = $exif_exif['DateTimeOriginal'];
error_log("EXIF TIME TAKEN : " . $exif_date);
$exif_timetaken = date("Y-m-d H:i:s", strtotime($exif_date));
} catch (Exception $e) {
error_log($e->getMessage());
}
}
if (isset($exif_ifd0['DateTime'])) {
//We get the date and time the picture was taken
try {
$ifd0_date = $exif_ifd0['DateTime'];
error_log("IFDO TIME TAKEN : " . $ifd0_date);
$ifd0_timetaken = date("Y-m-d H:i:s", strtotime($ifd0_date));
} catch (Exception $e) {
error_log($e->getMessage());
}
}
//We chose the earliest date of the 2
if (isset($exif_date) && isset($ifd0_date)) {
$rawTimeTaken = $exif_date < $ifd0_date ? $exif_date : $ifd0_date;
error_log("FINAL TIME TAKEN : " . $rawTimeTaken);
$timetaken = date("Y-m-d H:i:s", strtotime($rawTimeTaken));
} else {
if (isset($exif_date)) {
$rawTimeTaken = $exif_date;
error_log("FINAL TIME TAKEN : " . $rawTimeTaken);
$timetaken = date("Y-m-d H:i:s", strtotime($rawTimeTaken));
} else {
if (isset($ifd0_date)) {
$rawTimeTaken = $ifd0_date;
error_log("FINAL TIME TAKEN : " . $rawTimeTaken);
$timetaken = date("Y-m-d H:i:s", strtotime($rawTimeTaken));
} else {
$rawTimeTaken = $exif_file['FileDateTime'];
$timetaken = date("Y-m-d H:i:s", $rawTimeTaken);
}
}
}
error_log("TIME TAKEN : " . $timetaken);
$fileType = $exif_file['MimeType'];
/* $exif = exif_read_data($filepath, 'IFD0');
foreach ($exif as $key => $section) {
foreach ($section as $name => $val) {
error_log("$key.$name: $val");
}
} */
//Reduce file size
$img = imagecreatefromjpeg($filepath);
$quality = 100;
$currentFileSize = filesize($filepath);
switch ($currentFileSize) {
case $currentFileSize > 3000000:
$quality = 7;
break;
case $currentFileSize > 2000000:
$quality = 14;
break;
case $currentFileSize > 1000000:
$quality = 21;
break;
case $currentFileSize > 500000:
$quality = 70;
break;
}
imagejpeg($img, $filepath, $quality);
imagedestroy($img);
//$payload = file_get_contents($filepath);
$picture = new Picture(0, "", "", $timetaken, $fileType, null, $filename);
$picture->latitude = "";
$picture->longitude = "";
$dao = new PictureDAO();
if (isset($_SESSION['name'])) {
$userid = $_SESSION["userid"];
$dayId = $dao->createDay($userid, $timetaken);
$dao->savePicture($dayId, $picture);
} else {
error_log("COULD NOT SAVE PICTURES, NO USER IN SESSION!!!");
unlink($filepath);
}
//unlink($filepath);
} catch (Exception $e3) {
print "Error!: " . $e3->getMessage() . "<br/>";
unlink($filepath);
}
}
$quality = 14;
break;
case $currentFileSize > 1000000:
$quality = 21;
break;
case $currentFileSize > 500000:
$quality = 50;
break;
}
imagejpeg($img, $filepath, $quality);
imagedestroy($img);
$payload = file_get_contents($filepath);
$picture = new Picture(0, "", "", $timetaken, $fileType, $payload, $filename);
$picture->latitude = "";
$picture->longitude = "";
$dao = new PictureDAO();
error_reporting(E_ERROR | E_PARSE);
session_start();
if (isset($_SESSION['name'])) {
$userid = $_SESSION["userid"];
$dayId = $dao->createDay($userid, $timetaken);
$dao->savePicture($dayId, $picture);
} else {
error_log("COULD NOT SAVE PICTURES, NO USER IN SESSION!!!");
}
//unlink($filepath);
} catch (Exception $e) {
error_log("Exception!!! --- " . $e);
unlink($filepath);
}
}
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = $theValue != "" ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = $theValue != "" ? intval($theValue) : "NULL";
break;
case "double":
$theValue = $theValue != "" ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = $theValue != "" ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = $theValue != "" ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$colname_getImage = "-1";
if (isset($_GET['image_id'])) {
$colname_getImage = $_GET['image_id'];
}
$pictureDAO = new PictureDAO();
$picture = $pictureDAO->getPictureById($colname_getImage);
header('Content-type: ' . $picture->fileType);
echo $picture->payload;
