From 661e5595c4f5844cec94f4fb304c16650fa3b211 Mon Sep 17 00:00:00 2001
From: tike <timflex@gmx.de>
Date: Fri, 5 Feb 2016 22:57:57 +0100
Subject: issue #242 - make app caluclate number of vouchers for angels

---
 includes/model/ShiftEntry_model.php | 17 +++++++++++++++++
 includes/model/User_model.php       | 15 +++++++++++++++
 2 files changed, 32 insertions(+)

(limited to 'includes/model')

diff --git a/includes/model/ShiftEntry_model.php b/includes/model/ShiftEntry_model.php
index 008531ff..6324c3bf 100644
--- a/includes/model/ShiftEntry_model.php
+++ b/includes/model/ShiftEntry_model.php
@@ -84,6 +84,23 @@ function ShiftEntries_upcoming_for_user($user) {
       ");
 }
 
+/**
+ * Returns shifts completed by the given user.
+ *
+ * @param User $user          
+ */
+function ShiftEntries_finished_by_user($user){
+	  return sql_select("
+      SELECT *
+      FROM `ShiftEntry`
+      JOIN `Shifts` ON (`Shifts`.`SID` = `ShiftEntry`.`SID`)
+      JOIN `ShiftTypes` ON `ShiftTypes`.`id` = `Shifts`.`shifttype_id`
+      WHERE `ShiftEntry`.`UID`=" . sql_escape($user['UID']) . "
+      AND `Shifts`.`end` < " . sql_escape(time()) . "
+      ORDER BY `Shifts`.`end`
+      ");
+}
+
 /**
  * Returns all shift entries in given shift for given angeltype.
  *
diff --git a/includes/model/User_model.php b/includes/model/User_model.php
index e1bb2733..00c3bfdd 100644
--- a/includes/model/User_model.php
+++ b/includes/model/User_model.php
@@ -260,4 +260,19 @@ function User_generate_password_recovery_token(&$user) {
   return $user['password_recovery_token'];
 }
 
+
+function User_get_eligable_voucher_count(&$user) {
+  global $voucher_settings;
+  
+	$shifts_done = count(ShiftEntries_finished_by_user($user));
+	
+	$earned_vouchers = $user['got_voucher'] - $voucher_settings['initial_vouchers'];
+	$elegible_vouchers = $shifts_done / $voucher_settings['shifts_per_voucher'] - $earned_vouchers;
+	if ( $elegible_vouchers < 0) {
+		return 0;
+	}
+	
+	return $elegible_vouchers;
+}
+
 ?>
-- 
cgit v1.2.3-54-g00ecf