upload-import-orphans.php

<?php
/**
 * Shows a list of files found on the upload/ folder that
 * are not yet on the database, meaning they were uploaded
 * via FTP.
 * Only shows files that are allowed according to the sytem
 * settings.
 * Submits an array of file names.
 *
 * @package ProjectSend
 * @subpackage Upload
 */
$load_scripts	= array(
						'footable',
					); 

$allowed_levels = array(9,8,7);
require_once('sys.includes.php');

$active_nav = 'files';

$page_title = __('Find orphan files', 'cftp_admin');
include('header.php');

?>
	<script type="text/javascript">
		$(document).ready(function() {
			$("#upload_by_ftp").submit(function() {
				var checks = $("td>input:checkbox").serializeArray(); 
				
				if (checks.length == 0) { 
					alert('<?php _e('Please select at least one file to proceed.','cftp_admin'); ?>');
					return false; 
				} 
			});
			
			/**
			 * Only select the current file when clicking an "edit" button
			 */
			$('.btn-edit-file').click(function(e) {
				$('#select_all').prop('checked', false);
				$('td .select_file_checkbox').prop('checked', false);
				$(this).parents('tr').find('td .select_file_checkbox').prop('checked', true);
				$('#upload-continue').click();
			});

		});
	</script>
<?php
/**
 * Use the folder defined on sys.vars.php
 * Composed of the absolute path to that file plus the
 * default uploads folder.
 */
$work_folder = UPLOADED_FILES_FOLDER;

		if ( false === CAN_UPLOAD_ANY_FILE_TYPE ) {
			$msg = __('This list only shows the files that are allowed according to your security settings. If the file type you need to add is not listed here, add the extension to the "Allowed file extensions" box on the options page.', 'cftp_admin');
			echo system_message('warning',$msg);
		}
	?>
	
	<?php
		/** Count clients to show an error message, or the form */
		$statement		= $dbh->query("SELECT id FROM " . TABLE_USERS . " WHERE level = '0'");
		$count_clients	= $statement->rowCount();
		$statement		= $dbh->query("SELECT id FROM " . TABLE_GROUPS);
		$count_groups	= $statement->rowCount();

		if ( ( !$count_clients or $count_clients < 1 ) && ( !$count_groups or $count_groups < 1 ) ) {
			message_no_clients();
		}

		/**
		 * Make a list of existing files on the database.
		 * When a file doesn't correspond to a record, it can
		 * be safely renamed.
		 */
		$sql = $dbh->query("SELECT original_url, url, id, public_allow FROM " . TABLE_FILES );
		$db_files = array();
		$sql->setFetchMode(PDO::FETCH_ASSOC);
		while ( $row = $sql->fetch() ) {
			$db_files[$row["url"]] = $row["id"];
			$db_files[$row["original_url"]] = $row["id"];
			if ($row['public_allow'] == 1) {$db_files_public[$row["url"]] = $row["id"];}
		}

		/** Make an array of already assigned files */
		$sql = $dbh->query("SELECT DISTINCT file_id FROM " . TABLE_FILES_RELATIONS . " WHERE client_id IS NOT NULL OR group_id IS NOT NULL OR folder_id IS NOT NULL");
		$assigned = array();
		$sql->setFetchMode(PDO::FETCH_ASSOC);
		while ( $row = $sql->fetch() ) {
			$assigned[] = $row["file_id"];
		}
		
		/** We consider public file as assigned file */
		if ( !empty( $db_files_public ) ) {
			foreach ($db_files_public as $file_id){
				$assigned[] = $file_id;
			}
		}

		$files_to_add = array();

		/** Read the temp folder and list every allowed file */
		if ($handle = opendir($work_folder)) {
			while (false !== ($filename = readdir($handle))) {
				$filename_path = $work_folder.'/'.$filename;
				if(!is_dir($filename_path)) {
					if ($filename != "." && $filename != "..") {
						/** Check types of files that are not on the database */							
						if (!array_key_exists($filename,$db_files)) {
							$file_object = new PSend_Upload_File();
							$new_filename = $file_object->safe_rename_on_disk($filename,$work_folder);
							/** Check if the filetype is allowed */
							if ($file_object->is_filetype_allowed($new_filename)) {
								/** Add it to the array of available files */
								$new_filename_path = $work_folder.'/'.$new_filename;
								//$files_to_add[$new_filename] = $new_filename_path;
								$files_to_add[] = array(
														'path'		=> $new_filename_path,
														'name'		=> $new_filename,
														'reason'	=> 'not_on_db',
													);
							}
						}
					}
				}
			}
			closedir($handle);
		}
		
		if (!empty($_GET['search'])) {
			$no_results_error = 'search';
			$search = htmlspecialchars($_GET['search']);
			
			function search_text($item) {
				global $search;
				if (stripos($item['name'], $search) !== false) {
					/**
					 * Items that match the search
					 */
					return true;
				}
				else {
					/**
					 * Remove other items
					 */
					unset($item);
				}
				return false;
			}

			$files_to_add = array_filter($files_to_add, 'search_text');
		}
		
//			var_dump($result);
?>
<div class="col-xs-12">
	<div class="form_actions_limit_results">
		<?php show_search_form('upload-import-orphans.php'); ?>
	</div>

	<div class="form_actions_count">
		<p class="form_count_total"><?php _e('Showing','cftp_admin'); ?>: <span><?php echo count($files_to_add); ?> <?php _e('files','cftp_admin'); ?></span></p>
	</div>


	<form action="upload-process-form.php" name="upload_by_ftp" id="upload_by_ftp" method="post" enctype="multipart/form-data">
		<?php		
			/**
			 * Generate the list of files if there is at least 1
			 * available and allowed.
			 */
			if ( isset( $files_to_add ) && count( $files_to_add ) > 0 ) {
	
				$table_attributes	= array(
											'id'				=> 'add_files_from_ftp',
											'class'				=> 'footable table',
											'data-page-size'	=> FOOTABLE_PAGING_NUMBER,
										);
				$table = new generateTable( $table_attributes );
	
				$thead_columns		= array(
											array(
												'select_all'	=> true,
												'attributes'	=> array(
																		'class'			=> array( 'td_checkbox' ),
																		'data-sortable'	=> 'false',
																	),
											),
											array(
												'content'		=> __('File name','cftp_admin'),
												'attributes'	=> array(
																		'data-sort-initial'	=> 'true',
																	),
											),
											array(
												'content'		=> __('File size','cftp_admin'),
												'hide'			=> 'phone',
												'attributes'	=> array(
																		'data-type'	=> 'numeric',
																	),
											),
											array(
												'content'		=> __('Last modified','cftp_admin'),
												'hide'			=> 'phone',
												'attributes'	=> array(
																		'data-type'	=> 'numeric',
																	),
											),
											array(
												'content'		=> __('Actions','cftp_admin'),
											),
										);
				$table->thead( $thead_columns );

				foreach ($files_to_add as $add_file) {
					$table->add_row();
					/**
					 * Add the cells to the row
					 */
					$tbody_cells = array(
											array(
													'content'		=> '<input type="checkbox" name="add[]" class="batch_checkbox select_file_checkbox" value="' . html_output( $add_file['name'] ) . '" />',
												),
											array(
													'content'		=> html_output( $add_file['name'] ),
												),
											array(
													'content'		=> html_output( format_file_size( get_real_size( $add_file['path'] ) ) ),
													'attributes'	=> array(
																			'data-value'	=> filesize( $add_file['path'] ),
																		),
												),
											array(
													'content'		=> date( TIMEFORMAT_USE, filemtime( $add_file['path'] ) ),
													'attributes'	=> array(
																			'data-value'	=> filemtime( $add_file['path'] ),
																		),
												),
											array(
													'actions'		=> true,
													'content'		=>  '<button type="button" name="file_edit" class="btn btn-primary btn-sm btn-edit-file"><i class="fa fa-pencil"></i><span class="button_label">' . __('Edit','cftp_admin') . '</span></button>' . "\n"
												),
										);

					foreach ( $tbody_cells as $cell ) {
						$table->add_cell( $cell );
					}
	
					$table->end_row();
				}

				echo $table->render();
		?>
				<nav aria-label="<?php _e('Results navigation','cftp_admin'); ?>">
					<div class="pagination_wrapper text-center">
						<ul class="pagination hide-if-no-paging"></ul>
					</div>
				</nav>
		<?php
				$msg = __('Please note that the listed files will be renamed if they contain invalid characters.','cftp_admin');
				echo system_message('info',$msg);
		?>
				<div class="after_form_buttons">
					<button type="submit" class="btn btn-wide btn-primary" id="upload-continue"><?php _e('Continue','cftp_admin'); ?></button>
				</div>
		<?php
			}

			/** No files found */
			else {
				if (isset($no_results_error)) {
					switch ($no_results_error) {
						case 'search':
							$no_results_message = __('Your search keywords returned no results.','cftp_admin');
							break;
					}
				}
				else {
					$no_results_message = __('There are no files available to add right now.','cftp_admin');
					$no_results_message .= __('To use this feature you need to upload your files via FTP to the folder','cftp_admin');
					$no_results_message .= ' <span class="format_url"><strong>'.html_output($work_folder).'</strong></span>.';
				}
	
				echo system_message('error',$no_results_message);
			}
		?>
	</form>
</div>
	
<?php
	include('footer.php');