<?php

use go\core\model\Acl;
use go\core\util\StringUtil;
use go\modules\community\notes\model\Note;


class goNote extends GoBaseBackendDiff {

	public function DeleteMessage($folderid, $id, $contentparameters) {
		ZLog::Write(LOGLEVEL_DEBUG, 'goNote->DeleteMessage('.$folderid.','.$id.')');
		$note = Note::findById($id);
		
		if($note && $note->hasPermissionLevel(Acl::LEVEL_DELETE)) {
			return $note->delete($note->primaryKeyValues());
		} else {
			return true;
		}
	}
	
	/**
	 * Get the item object that needs to be synced to the phone.
	 * This information will be send to the phone.
	 * 
	 * Direction: SERVER -> PHONE
	 * 
	 * @param int $folderid
	 * @param int $id
	 * @param array $contentparameters
	 * @return \SyncNote
	 */
	public function GetMessage($folderid, $id, $contentparameters) {
		ZLog::Write(LOGLEVEL_DEBUG, 'goNote->GetMessage('.$folderid.','.$id.')');
		$note = Note::findById($id);
		
		if(!$note) {
			return false;
		}
		
		if(!$note->hasPermissionLevel(Acl::LEVEL_READ)) {
			return false;
		}

		$message = new SyncNote();
	
		$bpReturnType = GoSyncUtils::getBodyPreferenceMatch($contentparameters->GetBodyPreference());

		if (Request::GetProtocolVersion() >= 12.0) {
			$sbBody = new SyncBaseBody();

			$asBodyData = StringUtil::normalizeCrlf($note->content);

			if ($bpReturnType == SYNC_BODYPREFERENCE_HTML) {
				$sbBody->type = SYNC_BODYPREFERENCE_HTML;
				$asBodyData = $note->content;
			} else {

				$sbBody->type = SYNC_BODYPREFERENCE_PLAIN;
				$asBodyData = StringUtil::htmlToText($note->content);
			}
			ZLog::Write(LOGLEVEL_DEBUG, $asBodyData);

			$sbBody->estimatedDataSize = strlen($asBodyData);
			$sbBody->data = StringStreamWrapper::Open($asBodyData);
			$sbBody->truncated = 0;
			
			$message->asbody = $sbBody;

		} else {
			$message->body = StringUtil::normalizeCrlf($note->content);
			$message->bodysize = strlen($message->body);
			$message->bodytruncated = 0;

		}

		$message->lastmodified		=		$note->modifiedAt->format('U');
		$message->subject					=		$note->name;
	

		return $message;
	}

	/**
	 * Save the information from the phone to Group-Office.
	 * 
	 * Direction: PHONE -> SERVER
	 * 
	 * @param int $folderid
	 * @param int $id
	 * @param \SyncNote $message
	 * @return array
	 */
	public function ChangeMessage($folderid, $id, $message, $contentParameters) {
		ZLog::Write(LOGLEVEL_DEBUG, 'goNote->ChangeMessage('.$folderid.','.$id.')');
		
		ZLog::Write(LOGLEVEL_DEBUG, var_export($message, TRUE));
	
		$note = Note::findById($id);

		if(!$note) {
			$note = new Note ();
			$note->noteBookId = (new \go\core\db\Query)->selectSingleValue('noteBookId')->from('sync_user_note_book')->where(['userId' => go()->getUserId()])->orderBy(['isDefault' => 'DESC'])->single();
		}

		if(!$note->hasPermissionLevel(Acl::LEVEL_WRITE)) {
			throw new StatusException(SYNC_ITEMOPERATIONSSTATUS_DL_ACCESSDENIED);
		}

		$note->content = GoSyncUtils::getBodyFromMessage($message);

		if(isset($message->asbody) && isset($message->asbody->type)){
			switch($message->asbody->type){
				case SYNC_BODYPREFERENCE_PLAIN:
					$note->content = StringUtil::textToHtml($note->content);
			}
		}

		$note->name	= !empty($message->subject) ? $message->subject : StringUtil::cutString(strip_tags($note->content), 20);

		$note->cutPropertiesToColumnLength();

		if(!$note->save()){
			ZLog::Write(LOGLEVEL_WARN, 'ZPUSH2NOTE::Could not save ' . $note->id);				
			ZLog::Write(LOGLEVEL_WARN, var_export($note->getValidationErrors(), true));
			throw new StatusException(SYNC_STATUS_SERVERERROR);
		}			

		
		return $this->StatMessage($folderid, $note->id);
	}
			
	/**
	 * Get the status of an item
	 * 
	 * @param int $folderid
	 * @param int $id
	 * @return array
	 */
	public function StatMessage($folderid, $id) {
		ZLog::Write(LOGLEVEL_DEBUG, 'goNote->StatMessage('.$folderid.','.$id.')');
		
		return Note::find()
						->select('id,unix_timestamp(modifiedAt) AS `mod`, "1" AS `flags`')
						->fetchMode(PDO::FETCH_ASSOC)
						->where(['id' => $id])->single();	
	}
	
	/**
	 * Get the list of the items that need to be synced
	 * 
	 * @param int $folderid
	 * @param int $cutoffdate
	 * @return array
	 */
	public function GetMessageList($folderid, $cutoffdate) {		
		ZLog::Write(LOGLEVEL_DEBUG, 'goNote->GetMessageList('.$folderid.','.$cutoffdate.')');
		//if(!go()->getUser()->hasModule('notes')) {
		//TODO refactor
		if (!\GO::modules()->notes) {
			return [];
		}
		$query = Note::find()
						->select('id,unix_timestamp(modifiedAt) AS `mod`, "1" AS `flags`')
						->fetchMode(PDO::FETCH_ASSOC)
						->join("sync_user_note_book", 's', 'n.noteBookId = s.noteBookId')
						->where(['s.userId' => go()->getUserId(), 'password' => ""]);
//		ZLog::Write(LOGLEVEL_DEBUG, $query->debugQueryString);
		$notes = $query->all();	
		
		
//		ZLog::Write(LOGLEVEL_DEBUG, var_export($notes, true));
		
		return $notes;
	}
	
	/**
	 * Get the syncFolder that is attached to the given id
	 * 
	 * @param int $id
	 * @return \SyncFolder
	 */
	public function GetFolder($id) {

		if ($id != BackendGoConfig::NOTESBACKENDFOLDER) {
			ZLog::Write(LOGLEVEL_WARN, "Note folder '$id' not found");
			return false;
		}

		$folder = new SyncFolder();
		$folder->serverid = $id;
		$folder->parentid = "0";
		$folder->displayname = 'Notes';
		$folder->type = SYNC_FOLDER_TYPE_NOTE;

		return $folder;
	}

	/**
	 * Get a list of folders that are located in the current folder
	 * 
	 * @return array
	 */
	public function GetFolderList() {
		$folders = array();
		$folder = $this->StatFolder(BackendGoConfig::NOTESBACKENDFOLDER);
		$folders[] = $folder;

		return $folders;
	}
	
	
	public function getNotification($folder=null) {
	
		$record = Note::find()
						->fetchMode(PDO::FETCH_ASSOC)
						->select('COALESCE(count(*), 0) AS count, COALESCE(max(modifiedAt), 0) AS modifiedAt')
						->join("sync_user_note_book", 's', 'n.noteBookId = s.noteBookId')
						->where(['s.userId' => go()->getUserId()])
						->single();
		
		$newstate = 'M'.$record['modifiedAt'].':C'.$record['count'];
		ZLog::Write(LOGLEVEL_DEBUG,'goNote->getNotification() State: '.$newstate);

		return $newstate;
	}
	
}