<?php
/* $Id$ */
namespace MCMS\_\Modx\MCMS\Gallery\_\Service;

(defined('MCMS') && (basename(__FILE__) != basename($_SERVER['PHP_SELF']))) or die('ACCESS DENIED');

use Mammut\DB\Sql\Expression\SQLFunction;

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;

/**
 * Gallery Repository
 * @author Stefan Daurer <s.daurer@q-spot.org>
 */
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 Gallery
	 */
	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), Gallery::clazz(), array(), -1, 0);
	}
	
	public static function getGalleryPicCount($id) {
		$db = System::getInstance()->getDB();
		$sql = $db->select()
		->column(['c' => SQLFunction::count()])
		->from(self::PICINFOTABLE)
		->where(['id' => $id]);
		return $db->getObject($sql)->c;
	}

	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(PicInfo $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
	}

}