SetDocVaultIndex.php

Go to the documentation of this file.

<?php
/**
 * Construct vault index database
 *
 * @author Anakeen 2004
 * @version $Id: SetDocVaultIndex.php.in,v 1.2 2008/05/07 10:24:02 jerome Exp $
 * @license http://creativecommons.org/licenses/by-nc-sa/2.0/fr/ Anakeen - licence CC
 * @package FDL
 * @subpackage 
 */
 /**
 */
ini_set("include_path", ".:/usr/share/what:/usr/share/what/WHAT:/usr/share/php");
ini_set("max_execution_time", "36000");

include_once('Class.Action.php');
include_once('Class.Application.php');
include_once('Class.Session.php');
include_once('Class.Log.php');

include_once('FDL/Class.Doc.php');
include_once('FDL/Class.DocVaultIndex.php');

$appl = new Application();
$appl->Set("FDL", $core);
$dbaccess=$appl->GetParam("FREEDOM_DB");
if ($dbaccess == "") {
  print "Database not found : param FREEDOM_DB";
  exit;
}


$dvi = new DocVaultIndex($dbaccess);

$doc = new_Doc($dbaccess);
$doc->exec_query("select * from doc where id > 0 and doctype!='Z'");
$idoc = $doc->numrows();

loclog("Base $dbaccess, ".$idoc." document".($idoc?"s":"")." to process");
$dvi->exec_query("select * from docvaultindex");
loclog("Doc/Vault Index contains ".$dvi->numrows()." associations");


for ($c=0; $c < $idoc; $c++) {
  $row = $doc->fetch_array($c,PGSQL_ASSOC);
  $tdoc = new_Doc($dbaccess, $row["id"]);
  UpdateVaultIndex($c, $tdoc, $dvi);
  unset($tdoc);
}
$dvi->exec_query("select * from docvaultindex");
loclog("Doc/Vault Index contains ".$dvi->numrows()." associations");

exit;


function UpdateVaultIndex($i, &$doc, &$dvi) {
  $vl = ""; $vic=0;
  $err = $dvi->DeleteDoc($doc->id);
  $fa = $doc->GetFileAttributes();
  foreach ($fa as $aid=>$oattr) {
    if ($oattr->inArray()) {
      $ta=$doc->getTValue($aid);
    } else {
      $ta=array($doc->getValue($aid));
    }
    foreach ($ta as $k=>$v) {
      $vid="";
      if (preg_match("/(.*)\|(.*)/", $v, $reg)) {
        $vid=$reg[2];
        $dvi->docid = $doc->id;
        $dvi->vaultid = $vid;
        $dvi->Add();
        $vl .= " ".$vid;
        $vic++;
      }
    }
  }
  if ($vic>0)  loclog("[$i] document [".$doc->id."::".$doc->title."]  added vault file".($vic>1?"s":"")." ".$vl);
  
}


function loclog($s) {
  echo "SetDocVaultIndex> $s\n";
}

?>