public function destroyExtractedImageDupes()
{
$this->jobPhase = 4;
$this->beginJob(array('msg' => "searching extracted image-dupes in database ..."), __FUNCTION__);
$app = \Slim\Slim::getInstance();
$query = "SELECT count(id) AS itemCountTotal FROM bitmap WHERE error=0 AND trackId > 0";
$this->itemCountTotal = (int) $app->db->query($query)->fetch_assoc()['itemCountTotal'];
$query = "\n\t\t\tSELECT\n\t\t\t\tid,\n\t\t\t\ttrackId,\n\t\t\t\tembedded,\n\t\t\t\tCONCAT(albumId, '.', width, '.', height, '.', filesize) as dupes,\n\t\t\t\trelativePath,\n\t\t\t\tfilesize\n\t\t\tFROM bitmap\n\t\t\tWHERE error=0 AND embedded=1\n\t\t\tORDER BY albumId;";
$result = $app->db->query($query);
$images = array();
$previousKey = '';
$deletedFilesize = 0;
$msgKeep = $app->ll->str('importer.image.keep');
$msgDestroy = $app->ll->str('importer.image.destroy');
$msgProcessing = $app->ll->str('importer.image.dupecheck.processing');
while ($record = $result->fetch_assoc()) {
$this->updateJob(array('msg' => $msgProcessing, 'currentItem' => $record['relativePath']));
$this->itemCountChecked++;
if ($this->itemCountChecked === 1) {
$previousKey = $record['dupes'];
cliLog($app->ll->str('importer.image.keep', array($record['relativePath'])), 3);
continue;
}
if ($record['dupes'] === $previousKey) {
$msg = $app->ll->str('importer.image.destroy', array($record['relativePath']));
$bitmap = new \Slimpd\Bitmap();
$bitmap->setId($record['id']);
$bitmap->setTrackId($record['trackId']);
$bitmap->setEmbedded($record['embedded']);
$bitmap->setRelativePath($record['relativePath']);
$bitmap->destroy();
$this->itemCountProcessed++;
$deletedFilesize += $record['filesize'];
} else {
$msg = $app->ll->str('importer.image.keep', array($record['relativePath']));
}
cliLog($msg, 3);
$previousKey = $record['dupes'];
}
$msg = $app->ll->str('importer.destroyimages.result', array($this->itemCountProcessed, formatByteSize($deletedFilesize)));
cliLog($msg);
$this->finishJob(array('msg' => $msg, 'deletedFileSize' => formatByteSize($deletedFilesize)), __FUNCTION__);
return;
}
</a>
<a class="btn btn-success disabled" id="multicheckin">Check in</a>
</div>
</div>
<div id="photouploadModal" class="modal hide fade">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal">×</button>
<h3><?php
echo _('Upload New Photo');
?>
</h3>
</div>
<div class="modal-body">
<p><?php
echo sprintf(_("Uploads are limited to %s and must be in " . "jpeg or png format"), formatByteSize($photo_maxsize));
?>
</p>
<div>
<div class="thumbnail" style="width: 250px; margin: 0 auto;">
<img id="photopreview" style="width: 250px;" src="photo.php<?php
echo "?id=" . $edata["picture"];
?>
">
</div>
<img id="tarimg"></canvas>
</div>
<br>
<div id="fileselecterror" class="alert alert-error" style="display: none;">
<?php
echo _('Error: File type not supported.');
