芝麻web文件管理V1.00

编辑当前文件:/home/prismawe/clients/_syntaxis.fr/wp-content/plugins/pw-upload-formation/pw-upload-formation.php

<?php
/*
  Plugin Name: Upload Formation
  Description: Upload des archive zip contenant les formation e-learning
  Version: 1.0.0
  Author: <a href="http://www.prisma-web.pro/">Romain Le Mercier</a>
  Author URI: http://www.prisma-web.pro/
 */
if (!function_exists("pw-upload-formation")) {

function pwuploadformationmenu() {
        global $inst_pwuploadformation;
        if (!isset($inst_pwuploadformation)) {
            return;
        }
        add_menu_page('E-learning', 'E-learning', 10, basename(__FILE__), array(&$inst_pwuploadformation, 'printAdminPage'));
        
    }

}
if (!class_exists("pwuploadformation")) {

class pwuploadformation {
        var $adminOptionsName = 'pwuploadformationAdminOptions';
        /**
         * Constructor 
         */
        function pwuploadformation() {
            //global $wpdb;
        }
        /*
        function init() {
            $this->getAdminOptions();
        }//*/

function printAdminPage($param = array()) {
            global $wpdb;
			wp_enqueue_media();
            echo '<div><h2>E-learning - Upload formation</h2></div>';
            echo '<div class="filters">
				<label class="description" for="setfilters">Ajouter</label>
				<form id="setfilters" action="admin.php?page=pw-upload-formation.php&action=ajouter" method="post">
					<p>
						<label class="group-id-filter" for="group_id" style="margin-right : 31px;">Nom</label>
						<input class="group-id-filter" name="nom" id="group_id" type="text" value=""><br />
						<label class="group-name-filter" for="fichier_zip">Fichier ZIP</label>
						<input class="group-name-filter" name="fichier_zip" name="fichier_zip" id="fichier_zip" type="text" value="" size="30"><a href="#" class="button customaddphoto" onclick="chooseFormation();">Choisir une image</a>
					</p>
					<p><input class="button" type="submit" value="Envoyer"></p>
				</form>
			</div>';
			if(!empty($_POST) || !empty($_GET)){
				$action = htmlspecialchars($_GET['action']);
				if($action == 'ajouter'){
					$this->saveFormation();
				}else if($action == 'supprimer'){
					$id = htmlspecialchars($_GET['id']);
					$this->deleteFormation($id);
				}
			}
			echo $this->displayList();
        }
        
        public function saveFormation(){
            global $wpdb;
            $nom = htmlspecialchars($_POST['nom']);
            $file = preg_replace('/http:\/\/www.syntaxis.fr/', '', htmlspecialchars($_POST['fichier_zip']));
			$path = pathinfo(realpath('../'.$file));
			$zip = new ZipArchive();
			$res = $zip->open($path['dirname'].'/'.$path['basename']);
			if ($res === TRUE) {
				//on vérifie que le répertoire d'upload du module existe
				if(!is_dir($path['dirname'].'/../../pw-upload-formation')){
					mkdir($path['dirname'].'/../../pw-upload-formation');
				}
				//création du répertoire pour extraire la formation
				$randDirectory = md5(uniqid(rand(), true));
				$fullPath = $path['dirname'].'/../../pw-upload-formation/'.$randDirectory;
				mkdir($fullPath);
				chmod($fullPath, 0777);
				$zip->extractTo($fullPath);
				$zip->close();
				$wpdb->insert($wpdb->prefix.'mod_upload_formation',
                            array('nom'=>$nom, 'url'=>'http://www.syntaxis.fr/wp-content/uploads/pw-upload-formation/'.$randDirectory.'/story.html'));
			} else {
				echo 'Erreur lors l\'ouverture de l\'archive. Vérifiez qu\'elle n\'est pas corrompue.';
			}
            return true;
        }
        
		public function deleteFormation($id){
            global $wpdb;
			$formation = $wpdb->get_row($wpdb->prepare( 'SELECT * FROM '.$wpdb->prefix.'mod_upload_formation WHERE id = '.$id ), ARRAY_A);
			if($formation['id']){
				$file = preg_replace('/http:\/\/www.syntaxis.fr/', '', htmlspecialchars($formation['url']));
				$path = pathinfo(realpath('../'.$file));
				$path = $path['dirname'];
				//si le dossier existe on le supprime
				if (is_dir($path)) {
					pwuploadformation::delTree($path);
					//si il existe encore ça n'a pas marché
					if (is_dir($path)) {
						echo 'Erreur lors de la suppression du répertoire<br />';
					}else{
						//ça a marché, on supprime de la bdd
						$deleted = $wpdb->query("DELETE FROM ".$wpdb->prefix."mod_upload_formation WHERE id = ".$id);
						if($deleted){
							echo 'Formation supprimée.<br />';
						}else{
							echo 'Erreur lors de la suppression de la bdd.<br />';
						}
					}
				}else{
					$deleted = $wpdb->query("DELETE FROM ".$wpdb->prefix."mod_upload_formation WHERE id = ".$id);
					if($deleted){
						echo 'Formation supprimée mais pas le dossier.<br />';
					}else{
						echo 'Erreur lors de la suppression de la bdd.<br />';
					}
				}
			}else{
				echo 'Erreur : formatin introuvable.<br />';
			}
			
			return true;
		}
        
        public function displayList(){
            global $wpdb;
			$str = '
				<table id="" class="wp-list-table widefat fixed" cellspacing="0">
					<thead>
						<tr>
							<th scope="col" class="group_id manage-column sortable"><span>Id</span></th>
							<th scope="col" class="name manage-column sorted asc"><span>Nom</span></th>
							<th scope="col" class="description manage-column sortable"><span>Shortcode</span></th>
							<th scope="col" class="remove">Supprimer</th>
						</tr>
					</thead>
					<tbody>';
			$sql = $wpdb->prepare("SELECT * FROM ".$wpdb->prefix."mod_upload_formation");
			$formations = $wpdb->get_results($sql, ARRAY_A);
			//on affiche le html
			foreach($formations as $formation){
				$str .= '
				<tr class="even">
					<td class="group-id" title="1">'.$formation['id'].'</td>
					<td class="group-name" title="Registered">'.$formation['nom'].'</td>
					<td class="group-description" title="">[formation id="'.$formation['id'].'"]</td>
					<td class="capabilities"><a href="admin.php?page=pw-upload-formation.php&action=supprimer&id='.$formation['id'].'">Supprimer</a></td>
				</tr>';
			}
			$str .= '</tbody></table>';
            
            return $str;
        }
		
		public static function delTree($dir) { 
		   $files = array_diff(scandir($dir), array('.','..')); 
			foreach ($files as $file) { 
			  (is_dir("$dir/$file")) ? pwuploadformation::delTree("$dir/$file") : unlink("$dir/$file"); 
			} 
			return rmdir($dir); 
		  } 
	}

}

if (class_exists("pwuploadformation")) {
    $inst_pwuploadformation = new pwuploadformation();
    register_activation_hook(__FILE__, 'pvl_install');  
    //register_deactivation_hook(__FILE__, 'pvl_uninstall');  
    add_action('admin_menu', 'pwuploadformationmenu');
    //define shortcode
    add_shortcode("formation", "formation_display");
    
if (is_admin()) {
	wp_enqueue_script('customadminjs',  plugin_dir_url('pw-upload-formation').'pw-upload-formation/pw-upload-formation.js');

}

}
// [formatin id="1"]
function formation_display($atts){
    global $wpdb;
	extract( shortcode_atts( array(
		'id' => null
	), $atts ) );
    //on récupère les points
    $sql = $wpdb->prepare("SELECT * FROM ".$wpdb->prefix."mod_upload_formation where id =".$id);
    $points = $wpdb->get_results($sql, ARRAY_A);
    //on affiche le html
    $returnHtml = '';
    foreach($points as $point){
        $returnHtml .= '<iframe src="'.$point['url'].'" width="1200" height="660"></iframe>';
    }
    return $returnHtml;
}

function pvl_install() {
    global $wpdb;
    $wpdb->query('SET FOREIGN_KEY_CHECKS=0;');
    $sql = 'CREATE TABLE IF NOT EXISTS `'.$wpdb->prefix.'mod_upload_formation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;';
    if(!$wpdb->query($sql)) {
        die(mysql_error().__FILE__.'::'.__LINE__);
    }
    $wpdb->query('SET FOREIGN_KEY_CHECKS=1;');
}

function pvl_uninstall() {
    global $wpdb;
    $wpdb->query('SET FOREIGN_KEY_CHECKS=0;');
    $deletequery = 'DROP TABLE IF EXISTS '.$wpdb->prefix.'mod_upload_formation';
    if(!$wpdb->query($deletequery)) {
        die(mysql_error().__FILE__.'::'.__LINE__);
    }
    $wpdb->query('SET FOREIGN_KEY_CHECKS=1;');
}