[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Fmsystem-commits] [11099] property update sql for responsible class
From: |
Sigurd Nes |
Subject: |
[Fmsystem-commits] [11099] property update sql for responsible class |
Date: |
Fri, 10 May 2013 07:24:58 +0000 |
Revision: 11099
http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=11099
Author: sigurdne
Date: 2013-05-10 07:24:54 +0000 (Fri, 10 May 2013)
Log Message:
-----------
property update sql for responsible class
Modified Paths:
--------------
trunk/property/inc/class.soresponsible.inc.php
Modified: trunk/property/inc/class.soresponsible.inc.php
===================================================================
--- trunk/property/inc/class.soresponsible.inc.php 2013-05-09 21:37:04 UTC
(rev 11098)
+++ trunk/property/inc/class.soresponsible.inc.php 2013-05-10 07:24:54 UTC
(rev 11099)
@@ -929,20 +929,25 @@
}
/**
- * Get the user_id for a particular responsibility
+ * Get the user_id for a particular responsibility at a location
*
- * @param integer $person_id the ID of the given contact
+ * @param array
*
* @return user_id
*/
- public function get_responsible_user_id($responsibility_id)
+ public function get_responsible_user_id($data = array())
{
- $responsibility_id = (int)$responsibility_id;
+ $responsibility_id = (int)$data['responsibility_id'];
+ $location_code = $data['location_code'];
$now = time();
+
$sql = "SELECT contact_id FROM
fm_responsibility_contact"
. " {$this->join} fm_responsibility ON
fm_responsibility_contact.responsibility_id = fm_responsibility.id"
- . " AND active = 1 AND active_from < {$now} AND
active_to > {$now} AND expired_on IS NULL";
+ . " WHERE fm_responsibility.id =
{$responsibility_id}"
+ . " AND active_from < {$now}"
+ . " AND expired_on IS NULL"
+ . " AND location_code = '{$location_code}'";
$this->db->query($sql, __LINE__, __FILE__);
$this->db->next_record();
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Fmsystem-commits] [11099] property update sql for responsible class,
Sigurd Nes <=