<?php
/* $Id: cls.mmmodgalleryrepossvc.php 1407 2011-01-21 15:41:06Z kiu345 $ */
namespace MCMS\_\Modx\MCMS\Gallery\_\Service;

(defined('MCMS') && (basename(__FILE__) != basename($_SERVER['PHP_SELF']))) or die('ACCESS DENIED');

use \MCMS\System;
use \MCMS\_\Modx\MCMS\Gallery\_\Model\Gallery;
use \MCMS\_\Modx\MCMS\Gallery\_\Model\PicInfo;
use \MCMS\_\Modx\MCMS\Gallery\_\Model\PicMeta;
use \MCMS\_\Modx\MCMS\Gallery\_\Model\PicData;
use \MCMS\_\Modx\MCMS\Gallery\_\Model\PicComment;
use \MCMS\_\Modx\MCMS\Gallery\_\Model\PicVote;

require_once(__DIR__.__DS__.'cls.repossvcbase.php');

/**
 * Gallery Repository
 * @author Stefan Daurer
 */
class ReposSvc extends ReposSvcBase {

	const GALLERYTABLE = 'm_mcms#gallery_gallerys';
	const PICINFOTABLE = 'm_mcms#gallery_picinfos';
	const PICDATATABLE = 'm_mcms#gallery_picdatas';

	/**
	 * @return array of MMModGuestbookEntry
	 */
	public static function getGalleryPageEntries($site, $instance, $page, $pagesize) {
		$db = System::getInstance()->getDB();
		$start = $page*$pagesize;
		$sql = 'SELECT * FROM '.$db->escapeTableName(self::GALLERYTABLE);
		$sql .= ' WHERE site_id=? AND instance=? ORDER BY gallerydate DESC';
		return $db->getObjectListP($sql,array($site,$instance),'\\MCMS\\_\\Modx\\MCMS\\Gallery\\_\\Model\\Gallery',array(),-1,0);
	}

	public static function removeGallery(Gallery $gallery) {
		$db = System::getInstance()->getDB();

		$db->isTransactionSupported() and $db->startTransaction();
		$db->table(self::GALLERYTABLE)->delete(array('id' => $gallery->id));
		$db->table(self::PICTABLE)->delete(array('gallery_id' => $gallery->id));

		$db->isTransactionSupported() and $db->commit();
	}

	public static function storePic(Gallery $gallery,PicInfo $info,$data) {
		$db = System::getInstance()->getDB();

		$db->isTransactionSupported() and $db->startTransaction();
		$gid = $gallery->id;

		$db->isTransactionSupported() and $db->commit();
	}

	public static function updatePicBinData(MMModGalleryPicInfo $info,$data) {
		$db = System::getInstance()->getDB();

		// TODO: Implement
	}

	public static function getPicList($gallery,$page,$pageSize) {
		$db = System::getInstance()->getDB();

		// TODO: Implement
	}

	public static function getPicInfo($picId) {
		$db = System::getInstance()->getDB();

		// TODO: Implement
	}

	public static function getPicBinData($picId) {
		$db = System::getInstance()->getDB();

		// TODO: Implement
	}

	public static function removePic(Gallery $gallery,PicInfo $info) {
		$db = System::getInstance()->getDB();

		// TODO: Implement
	}

}