<?php
require_once ('inc/core.php');

include_once( 'password_protect.php' );


if($_POST){
	$copy_to = PROJECT_DIR.DIRECTORY_SEPARATOR.FILES_PREFIX_DIR.DIRECTORY_SEPARATOR;
	$file_name = basename($_FILES['userfile']['name']); 
	$path = $copy_to.$file_name;
	if (move_uploaded_file($_FILES['userfile']['tmp_name'], $path)) {
	  $msg = "Plik został załadowany poprawnie.";
	
		## pobrac id max+1
		$sql2 = 'SELECT GREATEST( MAX(file_id)+1, 1 ) AS new_id FROM t_files';	
		$stmt = $dbh -> prepare( $sql2 );
		$stmt->execute();
		$count = $stmt->rowCount();

	  if ( $count > 0 ) {
  		foreach($dbh->query($sql2) as $row ){
  			$new_id = $row['new_id'];
  		}
  	}else{
		  $new_id=1;
		}
		if( $new_id == '' ) $new_id=1;
		  if($_POST['file_title'] == "") $_POST['file_title'] = $_FILES['userfile']['name'];
		  
		  /* poprawak dotyczaca roszerzenia pliku */
		  
		  if( strpos($file_name, '.pdf') > 0 ){
		    $type ='application/pdf';
		  }else if( strpos($file_name, '.doc') > 0 ){
		    $type ='application/doc';
      }else{
		    $type = $_FILES['userfile']['type'];
		  }
		  
	     $sql_insert = "INSERT INTO t_files(
	            file_id, menu_id, file_title, file_type, file_path)
	    		VALUES (".$new_id.", 
                  ".$_POST['menu_id'].", 
                  '".$_POST['file_title']."', 
                  '".$type."', 
                  '".$path."' );";
	    
		//echo $sql_insert;
    		$sth = $dbh->prepare($sql_insert);
        $sth->execute();
	   	   
	} else {
	   $msg = '<b style="color:red;">Plik nie został załadowany...</b>';
	}
	
	
	


}


# ustawienie jezyka
if( ! isset( $_SESSION['S_LangId']  ) ){
	$_SESSION['S_LangId'] = 1; // pol
}
$_SESSION['S_LangId'] = ( isset($_POST['lang']) ? $_POST['lang'] : $_SESSION['S_LangId'] );

$sql = "SELECT lang_id, lang_name FROM t_langs ORDER BY lang_name"; 
$sth = $dbh->prepare($sql);
$sth->execute();
$arrLangs = $sth->fetchAll();

$sql = "SELECT lang_id, menu_name,menu_id FROM t_menu ORDER BY sort_order, menu_name"; 
$sth = $dbh->prepare($sql);
$sth->execute();
$arrMenus = $sth->fetchAll();


/* tamplate */
?>
<script>
function filtr_menu(lang_id){

  var _selectMenu = document.getElementById('menu');
  if( _selectMenu ){
    for(var i=1; i < _selectMenu.options.length ; i++){
      var _opt = _selectMenu.options[i];
      if( _opt.title != lang_id ){
        _opt.style.display = 'none';
      }else{
        _opt.style.display = 'block';
      }
    
    }
  }

}
</script>
<form action="admin_file_add.php" method="post" enctype="multipart/form-data">
<table>
<tr>
  <td><b> Dodawanie plików </b></td>
</tr>
<tr>
  <td><?php echo $msg;?></td>
</tr>
<tr>
  <td> 
    <select name="lang_id" id="lang" onchange="filtr_menu(this.value)">
      <option value="-1">--Wybierz--</option>
      <?php
        foreach( $arrLangs as $key => $val ){
          echo '<option value="'.$val['lang_id'].'" >'.$val['lang_name'].'</option>';
        }
      ?>
    </select>
  </td>
</tr>
<tr>
  <td>
    <select name="menu_id" id="menu">
      <option value="-1">--Wybierz--</option>
      <?php
        foreach( $arrMenus as $key => $val ){
          echo '<option value="'.$val['menu_id'].'" title="'.$val['lang_id'].'" >'.$val['menu_name'].'</option>';
        }
      ?>
    </select>
  </td>
</tr>
<tr>
  <td><input type="file" name="userfile" /></td>
</tr>
<tr>
  <td><input type="text" name="file_title" style="width: 150px;" /></td>
</tr>
<tr>
  <td colspan="3"><input type="submit" value="Dodaj"/></td>
</tr>
</form>
