summaryrefslogtreecommitdiffstats
path: root/public/month.php
diff options
context:
space:
mode:
authorFilipp Lepalaan <filipp@mac.com>2010-04-11 20:54:06 +0300
committerFilipp Lepalaan <filipp@mac.com>2010-04-11 20:54:06 +0300
commit6f2e6899cc404f314648782920e343c8529885d3 (patch)
tree7d0129a6818f9554e76b60c913ce89a888b9f964 /public/month.php
downloadatwork-6f2e6899cc404f314648782920e343c8529885d3.tar.gz
atwork-6f2e6899cc404f314648782920e343c8529885d3.tar.bz2
atwork-6f2e6899cc404f314648782920e343c8529885d3.zip
First commit
Diffstat (limited to 'public/month.php')
-rw-r--r--public/month.php58
1 files changed, 58 insertions, 0 deletions
diff --git a/public/month.php b/public/month.php
new file mode 100644
index 0000000..a3cd47e
--- /dev/null
+++ b/public/month.php
@@ -0,0 +1,58 @@
+<?php
+
+ ////
+ // atwork/month.php
+
+ require_once '../system/init.php';
+
+ // Get month total
+ $sql = "SELECT SUM(strftime('%s', finish)-strftime('%s', start)) AS thesum
+ FROM atwork
+ WHERE user = ?
+ AND strftime('%m', start) = ?";
+
+ $stmt_tot = $db->prepare($sql);
+
+ // Get total hours for each day
+ $sql = "SELECT strftime('%s', finish) - strftime('%s', start) AS done
+ FROM atwork
+ WHERE user = ?
+ AND date(finish) = ?";
+
+ $stmt = $db->prepare($sql);
+
+ if (!$_POST['m']) {
+ $_SESSION['m'] = date('n');
+ }
+
+ $_SESSION['m'] = $_SESSION['m'] + $_POST['m'];
+ $month = sprintf('%02d', $_SESSION['m']);
+ $stmt_tot->execute(array($_SESSION['user'], $month));
+ $total = current($stmt_tot->fetchAll());
+ $first = mktime(0, 0, 0, $_SESSION['m'], 0);
+ $last = mktime(0, 0, 0, $_SESSION['m']+1, 0);
+ $days = ($last-$first)/3600/24;
+
+?>
+
+ <img src="images/cal_16.png" class="icon" alt=""/>
+ <h2><?= date('F Y', $last); ?> (<?= $total['thesum']/3600; ?>h)</h2>
+
+<?php
+
+ foreach(range(1, $days) as $d):
+
+ $current = $first+3600*24*$d;
+ $txt = date('D, d', $current);
+ $stmt->execute(array($_SESSION['user'], date('Y-m-d', $current)));
+ $tmp = current($stmt->fetchAll());
+ $work = $tmp['done']/3600;
+
+?>
+
+ <div class="day" title="<?= date('d.m.Y', $current); ?>">
+ <?= $txt; ?>
+ <div class="hours"><?= $work; ?>h</div>
+ </div>
+
+<?php endforeach ?>