my TV experiment with xPDO: doc-clickcounter for 096

<?php

$host=$modx->dbConfig['host'];
$dbname=str_replace("`", "", $modx->dbConfig['dbase']);
$dbusername=$modx->dbConfig['user'];
$dbpassword=$modx->dbConfig['pass'];
$dbprefix=$modx->dbConfig['table_prefix'];
	
define('XPDO_MODE', 2);
include_once ( $modx->config['base_path'] . 'core/xpdo/xpdo.class.php');

$xpdo= new xPDO('mysql:host='.$host.';dbname='.$dbname, $dbusername, $dbpassword, $dbprefix);
$xpdo->setPackage('modx095',XPDO_CORE_PATH .'../model/');
$xpdo->setDebug(false);
$xpdo->loadClass('modElement');
//
//  get the docid of your choice, here its the actuell doc
//
$id=$modx->documentIdentifier;
$criteria= $xpdo->newQuery('modResource', $id);
$criteria->limit(1);
$docm= $xpdo->getObject('modResource', $criteria);

if ($docm) { 
$output.= "DOC OK <br/>";
$content= $docm->get('content');
$pagetitle= $docm->get('pagetitle');
$longtitle= $docm->get('longtitle');
$output.= '<br/>Content   : '.$content;
$output.= '<br/>PageTitle : '.$pagetitle.'<br/>';

$tvname= $xpdo->getObject('modTemplateVar', array ('name' => 'test'));
$tv_criteria=array ('tmplvarid' =>$tvname->get('id'), 'contentid'=> $docm->get('id'));

//print_r($param);
if ($tvname) { $output.= "TVname OK <br/>";

//$docm->getMany('modTemplateVarDocument');
$tvs= $xpdo->getObject('modTemplateVarDocument', $tv_criteria);
//print_r($docm);
if ($tvs) { 
  $value=$tvs->get('value');
  $value++;
  $tvs->set('value', $value);
  $tvs->save(); 
  $output.= 'TV edited to '.$value.' <br/>';
} else {
	$tvs=$xpdo->newObject('modTemplateVarDocument');
  if ($tvs) { 
  $tvs->set('value', '0');
  $tvs->fromArray($tv_criteria); 
  $tvs->save();
  $output.= "new TV created <br/>";
} else {$output.= "TV could not be created <br/>";}	
}
} 
  else {$output.= "TVname NOT OK <br/>";}
   
} else {$output.= "DOC NOT found";}   

?>

$xpdo->loadClass('modElement');

<?php

$host = $modx->dbConfig['host'];
$dbname = str_replace("`", "", $modx->dbConfig['dbase']);
$dbusername = $modx->dbConfig['user'];
$dbpassword = $modx->dbConfig['pass'];
$dbprefix = $modx->dbConfig['table_prefix'];

define('XPDO_MODE', 2);
include_once ($modx->config['base_path'].'core/xpdo/xpdo.class.php');

$xpdo = new xPDO('mysql:host='.$host.';dbname='.$dbname, $dbusername, $dbpassword, $dbprefix);
$xpdo->setPackage('modx095', XPDO_CORE_PATH.'../model/');
$xpdo->setDebug(false);

//  get the docid of your choice, here its the actuell doc
$id = $modx->documentIdentifier;
$tvname = 'test2';

//get the tmplvarid of the TV with given name
$tvobj = $xpdo->getObject('modTemplateVar', array ('name'=>$tvname));
if ($tvobj)
{
    $tmplvarid = $tvobj->get('id');

    //get the document
    $docm = $xpdo->getObject('modResource', $id);

    //get the TVs related to the document
    $tvs2 = $docm->getMany('modTemplateVarResource');

    //make an array of all TVs related to the document for access with given tmplvarid
    //key -> tmplvarid, value -> id
    $tvarr = array ();
    foreach ($tvs2 as $key=>$tv)
    {
        $tvarr[$tv->get('tmplvarid')] = $tv->get('id');
    }

    //check if tv exists, if not create a new one
    if ( isset ($tvarr[$tmplvarid]))
    {
        //get the id for given TV from the array
        $tvid = $tvarr[$tmplvarid];
        $value = $tvs2[$tvid]->get('value');
        $value++;
        $tvs2[$tvid]->set('value', $value);
        $output .= 'TV edited to '.$value.' <br/>';
    }
    else
    {
        echo 'TV not found - must create new one';
        $newtv = $xpdo->newObject('modTemplateVarResource');
        $newtv->set('value', '1');
        $newtv->set('tmplvarid', $tmplvarid);
        $docm->addmany($newtv);

    }
    //echo 'class:'.get_parent_class($tvs2[$tvid]).'<br/>';
    //echo $tvs2[$tvid]->get('tvarid').':'.$tvs2[$tvid]->get('value').'<br/>';
}
else
{
    $output .= "TVname NOT OK <br/>";
}

//save the doc and related TVs
$docm->save();

?>