refreshUserAccount.php

Go to the documentation of this file.

<?php
/*
 * @author Anakeen
 * @package FDL
*/
/**
 * Generated Header (not documented yet)
 *
 * @subpackage
 */
/**
 */
// refreah for a classname
// use this only if you have changed title attributes
include_once ("FDL/Class.Doc.php");
include_once ("FDL/Lib.Dir.php");

$appl = new Application();
$appl->Set("FDL", $core);

$dbaccess = $appl->dbaccess;
if ($dbaccess == "") {
    print "Database not found : appl->dbaccess";
    return;
}

$usage = new ApiUsage();

$usage->setDefinitionText("Update usercard");
$whatid = $usage->addOptionalParameter("whatid", "document"); // document
$fbar = $usage->addOptionalParameter("bar", "for progress bar"); // for progress bar
$onlygroup = ($usage->addOptionalParameter("onlygroup", "for progress bar") != ""); // for progress bar
$usage->verify();

$query = new QueryDb("", "Account");

if ($whatid > 0) {
    $query->AddQuery("id=$whatid");
} else {
    $query->order_by = "accounttype desc,id";
}

if ($onlygroup) $query->AddQuery("accounttype='G'");

$table1 = $query->Query(0, 0, "TABLE");

if ($query->nb > 0) {
    
    printf("\n%d user to update\n", count($table1));
    $card = count($table1);
    $doc = new Doc($dbaccess);
    $reste = $card;
    foreach ($table1 as $k => $v) {
        $fid = 0;
        
        $reste--;
        // search already created card
        $title = strtolower($v["lastname"] . " " . $v["firstname"]);
        $mail = getMailAddr($v["id"]);
        // first in IUSER
        unset($tdoc);
        $udoc = false;
        $foundoc = false;
        $fid = $v["fid"];
        if ($fid > 0) {
            $udoc = new_doc($dbaccess, $fid);
            $foundoc = $udoc->isAlive();
        }
        
        if (!$foundoc) {
            // search same doc with us_what id
            if ($v["accounttype"] == "G") {
                $filter = array(
                    "us_whatid = '" . $v["id"] . "'"
                );
                $tdoc = internalGetDocCollection($dbaccess, 0, 0, "ALL", $filter, 1, "TABLE", "IGROUP");
            } else {
                $filter = array(
                    "us_whatid = '" . $v["id"] . "'"
                );
                $tdoc = internalGetDocCollection($dbaccess, 0, 0, "ALL", $filter, 1, "TABLE", "IUSER");
            }
            
            if (count($tdoc) > 0) {
                $fid = $tdoc["id"];
                $udoc = new_doc($dbaccess, $fid);
                $foundoc = $udoc->isAlive();
            }
        }
        if ($foundoc) {
            /**
             * @var \Dcp\Family\IUSER|\Dcp\Family\IGROUP $udoc
             */
            if (method_exists($udoc, "RefreshGroup")) $udoc->RefreshGroup();
            else if (method_exists($udoc, "RefreshDocUser")) $udoc->RefreshDocUser();
            //if (method_exists($tdoc[0],"SetGroupMail")) $tdoc[0]->SetGroupMail();
            //$tdoc[0]->refresh();
            //$tdoc[0]->postModify();
            $err = $udoc->modify();
            if ($err != "") print "$err\n";
            else {
                print "$reste)";
                printf(_("%s updated\n") , $udoc->title);
                $fid = $udoc->id;
            }
        } else {
            // search in all usercard same title
            if ($mail != "") $filter = array(
                "us_mail = '" . pg_escape_string($mail) . "'"
            );
            else $filter = array(
                "lower(title) = '" . pg_escape_string($title) . "'"
            );
            $tdoc = internalGetDocCollection($dbaccess, 0, 0, "ALL", $filter, 1, "LIST", getFamIdFromName($dbaccess, "IUSER"));
            if (count($tdoc) > 0) {
                if (count($tdoc) > 1) {
                    printf(_("find %s more than one, created aborded\n") , $title);
                } else {
                    
                    $udoc = new_Doc($dbaccess, $tdoc[0]->id);
                    /**
                     * @var \Dcp\Family\IUSER $udoc
                     */
                    $udoc->setValue("US_WHATID", $v["id"]);
                    $udoc->refresh();
                    $udoc->RefreshDocUser();
                    $udoc->modify();
                    $fid = $udoc->id;
                    print "$reste)";
                    printf(_("%s updated\n") , $title);
                    unset($udoc);
                }
            } else {
                // create new card
                if ($v["accounttype"] == "G") {
                    $iuser = createDoc($dbaccess, getFamIdFromName($dbaccess, "IGROUP"));
                    $iuser->setValue("US_WHATID", $v["id"]);
                    $iuser->Add();
                    $iuser->refresh();
                    $iuser->postStore();
                    $iuser->modify();
                    print "$reste)";
                    printf(_("%s igroup created\n") , $title);
                } else {
                    $iuser = createDoc($dbaccess, getFamIdFromName($dbaccess, "IUSER"));
                    $iuser->setValue("US_WHATID", $v["id"]);
                    $err = $iuser->Add();
                    if ($err == "") {
                        //$iuser->refresh();
                        //$iuser->RefreshDocUser();
                        //$iuser->modify();
                        print "$reste)";
                        printf(_("%s iuser created\n") , $title);
                    } else {
                        print "$reste)$err";
                        printf(_("%s iuser aborded\n") , $title);
                    }
                }
                $fid = $iuser->id;
                unset($iuser);
            }
        }
        
        if (($v["fid"] == 0) && ($fid > 0)) {
            $u = new Account("", $v["id"]);
            $u->fid = $fid;
            $u->modify();
            unset($u);
        }
        
        wbar($reste, $card, $title);
    }
    
    $doc->exec_query("update doc127 set name='GADMIN'     where us_whatid='4'");
    $doc->exec_query("update doc127 set name='GDEFAULT'   where us_whatid='2'");
    $doc->exec_query("update doc128 set name='USER_ADMIN' where us_whatid='1'");
    $doc->exec_query("update doc128 set name='USER_GUEST' where us_whatid='3'");
    $doc->exec_query("update doc128 set cvid=508          where us_whatid='1'");
    $doc->exec_query("update doc128 set cvid=508          where us_whatid='3'");
}