<?php
/**
 * Table Definition for usrgrp
 */
require_once 'DB/DataObject.php';

class Pman_Xtuple_DataObjects_Usrgrp extends DB_DataObject 
{
    ###START_AUTOCODE
    /* the code below is auto generated do not remove the above tag */

    public $__table = 'usrgrp';              // table name
    public $usrgrp_id;                       // int4(4)  not_null default_nextval%28usrgrp_usrgrp_id_seq%29 primary_key
    public $usrgrp_grp_id;                   // int4(4)  not_null
    public $usrgrp_username;                 // text(-1)  not_null

    
   /**
    * Getter / Setter for $usrgrp_grp_id
    *
    * @param    mixed   (optional) value to assign
    * @access   public
    */
    public function grp() {
        return func_num_args() ? $this->link('usrgrp_grp_id', func_get_arg(0)) : $this->link('usrgrp_grp_id');
    }


    /* the code above is auto generated do not remove the tag below */
    ###END_AUTOCODE
    
    function syncGroups($person)
    {
        $name = $person->pgname();
        
        $gm = DB_DataObject::Factory('group_members');
        $new = $gm->listGroupMembership($person, 'name');
        
        
        $g = DB_DataObject::Factory('grp');
        $grps  = $g->fetchAll('grp_id', 'grp_name');
        $gmap = array_flip($grps);
        
        
        $cur = DB_DataObject::Factory('usrgrp');
        $cur->usrgrp_username = $name;
        $oldids = $cur->fetchAll('usrgrp_grp_id');
        $old = array();
        foreach($oldids as $id) {
            $old[$grps[$id]] = true;
        }
        
        foreach($new as $i=> $n) {
            if ($n == 'Administrators') {
                $n = 'ADMIN';
            }
            
            if (isset($old[$n])) {
                unset($old[$n]);
                continue;
            }
            // skip groups we do not know about..
            if (!isset($gmap[$n])) {
                unset($new[$i]);
                continue;
            }
            $ug = DB_DataObject::Factory('usrgrp');
            $ug->usrgrp_grp_id = $gmap[$n];
            $ug->usrgrp_username = $name;
            $ug->insert();
            unset($new[$i]);
                
        }
        // finally remove from group..
        
        foreach($old as $n => $tr) {
            $ug = DB_DataObject::Factory('usrgrp');
            $ug->usrgrp_grp_id = $gmap[$n];
            $ug->usrgrp_username = $name;
            if ($ug->find(true)) {
                $ug->delete();
            }
            
        }
    }
         
}