<?php
/* $Id$ */ /* generated file, do not modify */
namespace MCMS\Service;

(defined('MCMS') && (basename(__FILE__) != basename($_SERVER['PHP_SELF']))) or die('ACCESS DENIED');

use \MCMS\System;
use \MCMS\Model\Website;
use \MCMS\Model\WebsiteSetting;
use \MCMS\Model\ModuleInstance;
use \MCMS\Model\Menu;
use \MCMS\Model\MenuItem;
use \MCMS\Model\MenuBlock;
use \MCMS\Model\ModuleInstanceACL;
use \MCMS\Model\Block;
use \MCMS\Model\Content;
use \MCMS\Model\Comment;
use \MCMS\UserBase;

abstract class ContentSvcBase {
	/**
	 * fetches an entry
	 * @return \MCMS\Model\Content the stored entry 
	 */
	public static function getContent($id) {
		$db = System::getInstance()->getDB();

		$class = '\\MCMS\\Model\\Content';

		$result = $db->table('content')->getObject(array('id' => $id), false, $class);

		return $result;
	}
	/**
	 * stores an entry
	 * update done if no row matching row for the follwing fields is found: id
	 * @return stdClass the stored entry 
	 */
	public static function storeContent(\MCMS\Model\Content $c) {
		$db = System::getInstance()->getDB();
		
		$db->isTransactionSupported() and $db->startTransaction();
		$keyfields = array('id' => $c->id);
		$oldSearch = $db->table('content')->select($keyfields);
		$doUpdate = $oldSearch->getRowCount() > 0;
		$oldSearch->close();
		unset($oldSearch);
		
		// transient fields and sequence fields needs to be excluded
		$ignore = array('id');
		
		if ($doUpdate) {
			$db->table('content')->update(
											$c,
											array('id' => $c->id),
											$ignore
											);
		}
		else {
			$db->table('content')->insert(
											$c,
											$ignore
											);
			$c->id = $db->getInsertId('id');
		}
		$db->isTransactionSupported() and $db->commit();
		return $c;
	}
}