<?php 
/* $Id$ */
(defined('MCMS') && (basename(__FILE__) != basename($_SERVER['PHP_SELF']))) or die('ACCESS DENIED');

use \MCMS\Response;
use \MCMS\System;
class PIAMMPILayoutXLayout extends \MCMS\Plugin\PluginAdminBase {

	/**
	 * shows the basic website settings
	 */
	public function runSettings(Response $response) {
		$system = System::getInstance();
		$part = $system->getTarget('part');
		$action = $system->getTarget('action');
		
		ob_start();
		include (__DIR__ . __DS__ . 'page.' . $part . '.' . $action . '.php');
		$response->setFragment('CONTENT', ob_get_clean());
	}

	/**
	 * update the basic website settings
	 */
	public function runUpdateLayoutSettings(Response $response) {
		$system = System::getInstance();
		$db = $system->getDB();
		$param = $system->getRequest()->getParam();
		
		$code = 1;
		
		$where = array();
		$where['id'] = $param['site'];
		
		$data = array();
		$data['online'] = $param['online'];
		$db->table('websites')->update($data, $where);
		
		unset($where);
		
		$data = array();
		$data['site_id'] = $param['site'];
		$data['instance'] = '';
		$db->isTransactionSupported() and $db->startTransaction();
		foreach(array('layout' => $param['layout']) as $key=>$value) {
			$data['key'] = $key;
			$test = $db->table('websitesettings')->select($data);
			if($test->getRowCount() != 0)
				$db->table('websitesettings')->update(array('value' => $value), $data);
			else
				$db->table('websitesettings')->insert(array_merge($data, array('value' => $value)));
			$test->close();
		}
		$db->isTransactionSupported() and $db->commit();
		
		if(isset($param['field'])) {
			$data = array();
			$data['site_id'] = $param['site'];
			$data['instance'] = '?layout';
			
			$db->isTransactionSupported() and $db->startTransaction();
			foreach($param['field'] as $key=>$value) {
				
				$data['key'] = $key . ':value';
				$test = $db->table('websitesettings')->select($data);
				if($test->getRowCount() != 0)
					$db->table('websitesettings')->update(array('value' => $value), $data);
				else
						$db->table('websitesettings')->insert(array_merge($data,array('value' => $value)));
				$test->close();
			}
			$db->isTransactionSupported() and $db->commit();
		}
		
		$system->cacheClean();
		$response->setRedirectURL(_SELF_ . '?cat=' . $this->getMyRef() . '&site=' . $param['site'] . '&action=settings&code=' . $code);
	}

	/**
	 * shows the added layout fields
	 */
	public function runFields(Response $response) {
		$system = System::getInstance();
		$part = $system->getTarget('part');
		$action = $system->getTarget('action');
		
		ob_start();
		include (__DIR__ . __DS__ . 'page.' . $part . '.' . $action . '.php');
		$response->setFragment('CONTENT', ob_get_clean());
	}

	/**
	 * update the layout layout field settings
	 */
	public function runUpdateFieldSettings( $response) {
		$system = System::getInstance();
		$db = $system->getDB();
		$param = $system->getRequest()->getParam();
		
		$code = 1;
		
		$db->isTransactionSupported() and $db->startTransaction();
		if(!empty($param['newfieldname'])) {
			
			$data = array();
			$data['site_id'] = $param['site'];
			$data['name'] = $param['newfieldname'];
			$data['plugin'] = 'mcms.mmpilayoutx';
			$data['start'] = NULL;
			$data['end'] = NULL;
			
			$db->table('blocks')->insert($data);
			
			$data = array();
			$data['site_id'] = $param['site'];
			$data['instance'] = '?layout';
			$data['key'] = $param['newfieldname'] . ':type';
			$data['value'] = $param['newfieldtype'];
			
			$db->table('websitesettings')->insert($data);
		}
		$db->isTransactionSupported() and $db->commit();
		
		$system->cacheClean();
		$response->setRedirectURL(_SELF_ . '?cat=' . $this->getMyRef() . '&site=' . $param['site'] . '&action=fields&code=' . $code);
	}

	/**
	 *
	 */
	public function runFieldDelAsk( $response) {
		$system = System::getInstance();
		$part = $system->getTarget('part');
		$action = $system->getTarget('action');
		
		ob_start();
		include (__DIR__ . __DS__ . 'page.' . $part . '.' . $action . '.php');
		$response->setFragment('CONTENT', ob_get_clean());
	}

	/**
	 * update the layout layout field settings
	 */
	public function runRemoveField(Response $response) {
		$system = System::getInstance();
		$db = $system->getDB();
		$param = $system->getRequest()->getParam();
		
		$code = 1;
		
		$db->isTransactionSupported() and $db->startTransaction();
		
		$data = array();
		$data['site_id'] = $param['site'];
		$data['name'] = $param['field'];
		$data['plugin'] = 'mcms.mmpilayoutx';
		$db->table('blocks')->delete($data);
		
		$data = array();
		$data['site_id'] = $param['site'];
		$data['instance'] = '?layout';
		$data['key'] = $param['field'] . ':type';
		$db->table('websitesettings')->delete($data);
		
		$data = array();
		$data['site_id'] = $param['site'];
		$data['instance'] = '?layout';
		$data['key'] = $param['field'] . ':value';
		$db->table('websitesettings')->delete($data);
		
		$db->isTransactionSupported() and $db->commit();
		
		$system->cacheClean();
		$response->setRedirectURL(_SELF_ . '?cat=' . $this->getMyRef() . '&site=' . $param['site'] . '&action=fields&code=' . $code);
	}
}