<?php

	if (isset($_GET['subcategorie_id']))
	{
		$subcategorie_id = $_GET['subcategorie_id'];
	}
	if (isset($_POST['subcategorie_id']))
	{
		$subcategorie_id = $_POST['subcategorie_id'];
	}
	
/* on form submission */
if(isset($_POST['do_submit']))  {
	/* split the value of the sortation */
  	$ids = explode(',',$_POST['sort_order']);
	echo("test");
  	/* run the update query for each id */
  	foreach($ids as $index=>$id) {
    	$id = (int) $id;
    	if($id != '') {
      		$query = 'UPDATE kms_articles SET sort_order = '.($index + 1).' WHERE kms_articles.article_id = '.$id;
      		$result = mysql_query($query) or die(mysql_error().': '.$query);
			echo($query);
    	}
  	}
  
 	 /* now what? */
 	 if($_POST['byajax']) { die(); } else { $message = 'Sortation has been saved.'; }
}

	$q_subcategorie = sprintf("SELECT kms_subcategories.subcategorie_name FROM kms_subcategories WHERE kms_subcategories.subcategorie_id='%s'", $subcategorie_id);
	$r_subcategorie = mysql_query($q_subcategorie);
	$rec_subcategorie = mysql_fetch_array($r_subcategorie);
	
	$subcategorie_naam = html_entity_decode($rec_subcategorie['subcategorie_name']);
	
?>

<h1><?php echo($subcategorie_naam);?> ordenen</h1>

<?php
  
  $query = sprintf("SELECT kms_articles.article_id, kms_articles.article_name, kms_articles.sort_order FROM kms_articles WHERE kms_articles.subcategorie_id ='%s' ORDER BY kms_articles.sort_order ASC", $subcategorie_id );
  $result = mysql_query($query);
  if(mysql_num_rows($result)) {
  
?>
<p>Sleep de onderstaande artikelen in de volgorde dat u ze op de subcategorie pagina wilt hebben.</p>

<div id="message-box"><?php echo $message; ?> Pagina wacht op herordening...</div>

<form id="dd-form" action="/kms/index.php?p=ordenen_subcategorie" method="post">
<p class="autoSubmit">
  <input type="checkbox" value="1" name="autoSubmit" id="autoSubmit" <?php if($_POST['autoSubmit']) { echo 'checked="checked"'; } ?> />
  <label for="autoSubmit">Wijzigen meteen toevoegen na het slepen</label>
</p>

<ul id="sortable-list">
  <?php 
    $order = array();
    while($item = mysql_fetch_assoc($result)) {
      echo '<li title="',$item['article_id'],'">',html_entity_decode($item['article_name']),'</li>';
      $order[] = $item['article_id'];
    }
  ?>
</ul>
<br />
<input type="hidden" name="sort_order" id="sort_order" value="<?php echo implode(',',$order); ?>" />
<input type="hidden" name="subcategorie_id" id="subcategorie_id" value="<?php echo($subcategorie_id); ?>" />
<input type="submit" name="do_submit" value="Wijzigingen opslaan" class="button submit" />
</form>
<?php } else { ?>
  
  <p>Sorry!  Er zijn geen artikelen in deze categorie.</p>
  
<?php } ?>