* -- interacts with Roo and _lock = id..
*
*
+ * call :
+ * try and lock it..
+ * baseURL + /Core/Lock/lock?on_id=...&on_table=...
+ * - returns id or an array of who has the locks.
+ *
+ * Force an unlock after a warning..
+ * baseURL + /Core/Lock/lock?on_id=...&on_table=...&force=1
+ * - returns id..
+ *
+ * Unlock - call when window is closed..
+ * baseURL + /Core/Lock/unlock?on_id=...&on_table=...&force=1
+ * - returns jerr or jok
*/
require_once 'Pman.php';
}
function get($action)
+ {
+ // should we allow url links to lock things???
+ // only for debugging??
+ $this->post($action);
+ //
+ $this->jerr("invalid request");
+ }
+
+ function post($action)
{
// default action is to attempt to lock..
- $action = empty($action) ? 'lock' : 'unlock';
- $this->$action($curlock);
-
-
-
+ $action = empty($action) || $action == 'lock' ? 'lock' : 'unlock';
+ $this->$action();
}
- function unlock($curlock)
+ function unlock()
{
if (empty($_REQUEST['id'])) {
));
-
- if ($curlock->count() && empty($_REQUEST['force'])) {
- $curlock->selectAdd();
- $curlock->selectAdd('distinct(person_id)');
- $ar = $curlock->fetchAll('person_id');
+ $nlocks = $curlock->count() ;
+ if ($nlocks && empty($_REQUEST['force'])) {
+ // DB_DataObjecT::debugLevel(1);
+ $ar = $curlock->fetchAll('person_id', 'created');
$p = DB_DataObject::factory('Person');
+ $p->selectAdd();
+ $p->selectAdd('id,name,email');
+ $p->whereAddIn('id', array_keys($ar), 'int');
+ $p->find();
+ $ret = array();
+ while ($p->fetch()) {
+ $ret[$p->id] = $p->toArray();
+ $ret[$p->id]['lock_created'] = $ar[$p->id];
+ }
+ $this->jok(array_values($ret));
- $err = $this->canUnlock();
- if ($err !== true) {
- $this->jerr($err);
+ }
+ if ($nlocks) {
+ // trash all the locks..
+ $curlock->find();
+ while($curlock->fetch()) {
+ $cc =clone($curlock);
+ $cc->delete();
}
}
+
// make a lock..
$curlock = DB_DataObject::factory('Core_locking');