<?php
/**
 * CustomTables Joomla! 3.x/4.x/5.x Component
 * @package Custom Tables
 * @author Ivan Komlev <[email protected]>
 * @link https://joomlaboat.com
 * @copyright (C) 2018-2024. Ivan Komlev
 * @license GNU/GPL Version 2 or later - https://www.gnu.org/licenses/gpl-2.0.html
 **/

// no direct access
defined('_JEXEC') or die();

use CustomTables\common;
use CustomTables\CT;
use CustomTables\CTMiscHelper;
use CustomTables\database;
use CustomTables\Field;
use CustomTables\Fields;

use CustomTables\MySQLWhereClause;
use Joomla\CMS\Factory;
use Joomla\CMS\MVC\Model\BaseDatabaseModel;

class CustomTablesModelEditFiles extends BaseDatabaseModel
{
	var CT $ct;
	var ?array $row;
	var $filemethods;
	var $fileboxname;
	var $FileBoxTitle;
	var $fileboxfolder;
	var $fileboxfolderweb;
	var int $maxfilesize;
	var $fileboxtablename;
	var string $allowedExtensions;
	var Field $field;

	function __construct()
	{
		$this->ct = new CT(null, false);
		parent::__construct();

		$this->allowedExtensions = 'doc docx pdf rtf txt xls xlsx psd ppt pptx webp png mp3 jpg jpeg csv accdb pages';

		$this->maxfilesize = CTMiscHelper::file_upload_max_size();
		$this->filemethods = new CustomTablesFileMethods;

		$this->ct->getTable($this->ct->Params->tableName, null);

		if ($this->ct->Table->tablename === null) {
			Factory::getApplication()->enqueueMessage('Table not selected (63).', 'error');
			return false;
		}

		if (!common::inputGetCmd('fileboxname'))
			return false;

		$this->fileboxname = common::inputGetCmd('fileboxname');
		$this->row = $this->ct->Table->loadRecord($this->ct->Params->listing_id);

		if (!$this->getFileBox())
			return false;

		$this->fileboxtablename = '#__customtables_filebox_' . $this->ct->Table->tablename . '_' . $this->fileboxname;

		parent::__construct();
		return true;
	}

	function getFileBox(): bool
	{
		$fieldrow = Fields::FieldRowByName($this->fileboxname, $this->ct->Table->fields);
		$this->field = new Field($this->ct, $fieldrow, $this->row);

		$this->fileboxfolderweb = 'images/' . $this->field->params[1];

		$this->fileboxfolder = JPATH_SITE . DIRECTORY_SEPARATOR . str_replace('/', DIRECTORY_SEPARATOR, $this->fileboxfolderweb);
		//Create folder if not exists
		if (!file_exists($this->fileboxfolder))
			mkdir($this->fileboxfolder, 0755, true);

		$this->FileBoxTitle = $this->field->title;

		return true;
	}

	function getFileList()
	{
		$whereClause = new MySQLWhereClause();
		$whereClause->addCondition('listingid', $this->ct->Params->listing_id);
		return database::loadObjectList($this->fileboxtablename, ['fileid', 'file_ext'], $whereClause, 'fileid');
	}

	/**
	 * @throws Exception
	 * @since 3.2.2
	 */
	function delete(): bool
	{
		$fileIds = common::inputPostString('fileids', '', 'create-edit-record');
		$file_arr = explode('*', $fileIds);

		foreach ($file_arr as $fileid) {
			if ($fileid != '') {
				$file_ext = CustomTablesFileMethods::getFileExtByID($this->ct->Table->tablename, $this->fileboxname, $fileid);
				CustomTablesFileMethods::DeleteExistingFileBoxFile($this->fileboxfolder, $this->ct->Table->tableid, $this->fileboxname, $fileid, $file_ext);
				database::deleteRecord($this->fileboxtablename, 'fileid', $fileid);
			}
		}

		$this->ct->Table->saveLog($this->ct->Params->listing_id, 9);

		return true;
	}

	function add(): bool
	{
		$file = common::inputFiles('uploadedfile'); //not zip -  regular Joomla input method will be used

		$uploadedFile = "tmp/" . basename($file['name']);

		if (!move_uploaded_file($file['tmp_name'], $uploadedFile)) {
			common::enqueueMessage('Cannot move uploaded file.');
			return false;
		}

		if (common::inputGetCmd('base64ecnoded', '') == "true") {
			$src = $uploadedFile;
			$dst = "tmp/decoded_" . basename($file['name']);
			common::base64file_decode($src, $dst);
			$uploadedFile = $dst;
		}

		//Save to DB
		$file_ext = CustomTablesFileMethods::FileExtension($uploadedFile, $this->allowedExtensions);
		if ($file_ext == '') {
			//unknown file extension (type)
			unlink($uploadedFile);
			common::enqueueMessage('Unknown file extensions.');
			return false;
		}

		$filenameParts = explode('/', $uploadedFile);
		$filename = end($filenameParts);
		$title = str_replace('.' . $file_ext, '', $filename);

		try {
			$fileId = $this->addFileRecord($file_ext, $title);
		} catch (Exception $e) {
			common::enqueueMessage('Cannot add new file record: ' . $e->getMessage());
		}

		$newfilename = $this->fileboxfolder . DIRECTORY_SEPARATOR . $this->ct->Table->tableid . '_' . $this->fileboxname . '_' . $fileId . "." . $file_ext;

		if (!copy($uploadedFile, $newfilename)) {
			unlink($uploadedFile);
			common::enqueueMessage('Cannot copy file');
			return false;
		}

		unlink($uploadedFile);
		$this->ct->Table->saveLog($this->ct->Params->listing_id, 8);
		return true;
	}


	/**
	 * @throws Exception
	 * @since 3.2.2
	 */
	function addFileRecord(string $file_ext, string $title): int
	{
		$data = [
			'file_ext' => $file_ext,
			'ordering' => 0,
			'listingid' => $this->ct->Params->listing_id,
			'title' => $title
		];

		try {
			database::insert($this->fileboxtablename, $data);
		} catch (Exception $e) {
			common::enqueueMessage('Caught exception: ' . $e->getMessage());
			return -1;
		}

		$whereClause = new MySQLWhereClause();
		$whereClause->addCondition('listingid', $this->ct->Params->listing_id);

		$rows = database::loadObjectList($this->fileboxtablename, ['fileid'], $whereClause, 'fileid', 'DESC', 1);

		if (count($rows) == 1) {
			return $rows[0]->fileid;
		}
		return -1;
	}
}