1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
|
<?php defined("SYSPATH") or die("No direct script access.");
/**
* Gallery - a web based photo album viewer and editor
* Copyright (C) 2000-2008 Bharat Mediratta
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or (at
* your option) any later version.
*
* This program is distributed in the hope that it will be useful, but
* WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street - Fifth Floor, Boston, MA 02110-1301, USA.
*/
class exif_task_Core {
static function available_tasks() {
$db = Database::instance();
// Delete extra exif_records
$db->query(
"DELETE {exif_records}.* FROM {exif_records} " .
"LEFT JOIN {items} ON ({exif_records}.`item_id` = {items}.`id`) " .
"WHERE {items}.`id` IS NULL");
// Insert missing exif_records
$db->query(
"INSERT INTO {exif_records}(`item_id`) (" .
" SELECT {items}.`id` FROM {items} " .
" LEFT JOIN {exif_records} ON ({exif_records}.`item_id` = {items}.`id`) " .
" WHERE {exif_records}.`id` IS NULL)");
list ($remaining, $total, $percent) = self::_get_stats();
return array(Task_Definition::factory()
->callback("exif_task::extract_exif")
->name(t("Extract EXIF data"))
->description($remaining
? t2("1 photo needs to be scanned",
"%count (%percent%) of your photos need to be scanned",
$remaining, array("percent" => (100 - $percent)))
: t("EXIF data is up-to-date"))
->severity($remaining ? log::WARNING : log::SUCCESS));
}
static function extract_exif($task) {
$completed = $task->get("completed", 0);
$start = microtime(true);
foreach (ORM::factory("item")
->join("exif_records", "items.id", "exif_records.item_id")
->where("exif_records.dirty", 1)
->limit(10)
->find_all() as $item) {
if (microtime(true) - $start > 1) {
break;
}
$completed++;
exif::extract($item);
}
list ($remaining, $total, $percent) = self::_get_stats();
if ($remaining + $completed) {
$task->percent_complete = round(100 * $completed / ($remaining + $completed));
$task->status = t2("one record updated, index is %percent% up-to-date",
"%count records updated, index is %percent% up-to-date",
$completed, array("percent" => $percent));
} else {
$task->percent_complete = 100;
}
$task->set("completed", $completed);
if ($remaining == 0) {
$task->done = true;
$task->state = "success";
}
}
private static function _get_stats() {
$missing_exif = ORM::factory("exif_record")->where("dirty", 1)->count_all();
$total_items = ORM::factory("item")->count_all();
return array($missing_exif, $total_items,
round(100 * (($total_items - $missing_exif) / $total_items)));
}
}
|
