File: D:/HostingSpaces/SBogers25/superbedrukt.nl/wwwroot/kms/artikel_toevoegen.php
<?php
include_once('resizer.inc.php');
include("ckeditor/ckeditor.php");
if(isset($_POST['verzenden'])){
$verzenden = true;
}
if(isset($_POST['naam'])){
$naam = $_POST['naam'];
$naam = trim($naam);
$lengte_naam = strlen($naam);
if(($lengte_naam > 1) && ($lengte_naam < 100)){
$valid_naam = true;
$te_lang_naam = false;
}else{
$valid_naam = false;
if($lengte_naam != 0){
$te_lang_naam = true;
}
}
}else{
$valid_naam = false;
}
if($verzenden && $valid_naam){
$test_url = friendlyURL($naam);
$q_cases = sprintf("SELECT kms_articles.url FROM kms_articles WHERE url='%s'", $test_url);
$r_cases = mysql_query($q_cases);
$rec_cases = mysql_fetch_array($r_cases);
$uitkomst = $rec_cases['url'];
if($test_url == $uitkomst){
$bestaat_niet = false;
}else{
$bestaat_niet = true;
}
}
//check if al bestaat
if(isset($_POST['artikelnr'])){
$artikelnr = $_POST['artikelnr'];
$artikelnr = trim($artikelnr);
$lengte_artikelnr= strlen($artikelnr);
if(($lengte_artikelnr > 1) && ($lengte_artikelnr < 20)){
$valid_artikelnr = true;
$te_lang_artikelnr = false;
}else{
$valid_artikelnr = false;
if($lengte_artikelnr != 0){
$te_lang_artikelnr = true;
}
}
}else{
$valid_artikelnr = false;
}
if($verzenden && $valid_artikelnr){
$artikelnr = strtoupper($artikelnr );
$q_cases = sprintf("SELECT kms_articles.article_number FROM kms_articles WHERE article_number='%s'", $artikelnr);
$r_cases = mysql_query($q_cases);
$rec_cases = mysql_fetch_array($r_cases);
$uitkomst = $rec_cases['article_number'];
if($artikelnr == $uitkomst){
$bestaat_niet_artikel = false;
}else{
$bestaat_niet_artikel = true;
}
}
//check if al bestaat
if(isset($_POST['subcategorie'])){
$subcategorie = $_POST['subcategorie'];
}
if(isset($_POST['geslacht'])){
$geslacht = $_POST['geslacht'];
}
if(isset($_POST['merk'])){
$merk = $_POST['merk'];
}
if(isset($_POST['maat_van'])){
$maat_van = $_POST['maat_van'];
}
if(isset($_POST['maat_tot'])){
$maat_tot = $_POST['maat_tot'];
}
if(isset($_POST['populair'])){
$populair = $_POST['populair'];
if($populair == "yes" && !empty($subcategorie)){
$q_populair = sprintf("SELECT COUNT(popular) AS totaal_populair FROM kms_articles WHERE kms_articles.popular = 'yes' AND kms_articles.subcategorie_id = '%s'", $subcategorie);
$r_populair = mysql_query($q_populair);
$rec_populair = mysql_fetch_array($r_populair);
$totaal_populair = $rec_populair['totaal_populair'];
if($totaal_populair > 1){
$populair = "no";
$teveel_populair = true;
}else{
$teveel_populair = false;
}
}
}
if(isset($_POST['omschrijving'])){
$omschrijving = $_POST['omschrijving'];
$omschrijving = trim($omschrijving);
$lengte_omschrijving = strlen($omschrijving);
if(($lengte_omschrijving > 1)){
$valid_omschrijving = true;
}else{
$valid_omschrijving = false;
}
}else{
$valid_omschrijving = false;
}
if($_FILES['image_file']['tmp_name']){
if($_FILES['image_file']['size'] < 1200000){
$file_tegroot = false;
$valid_file = true;
$extensions = array("image/jpg", "image/jpeg", "image/pjpeg");
if(in_array($_FILES['image_file']['type'], $extensions)) {
$valid_type = true;
}else{
$valid_type = false;
}
}else{
$file_tegroot = true;
}
}else{
$valid_file = false;
$valid_type = false;
}
if($verzenden && $valid_naam && $bestaat_niet && $valid_artikelnr && $bestaat_niet_artikel && $valid_omschrijving && $valid_type && !$file_tegroot &&
!empty($subcategorie) && !empty($geslacht) && !empty($merk) && !empty($maat_van) && !empty($maat_tot) && $teveel_populair == false){
$root = $_SERVER['DOCUMENT_ROOT']."/";
if($valid_file && ($_FILES['image_file']['size'] < 1200000) && $_FILES['image_file']['tmp_name']){
$dirname = time();
$extensions = array("image/jpg", "image/jpeg", "image/pjpeg");
if(in_array($_FILES['image_file']['type'], $extensions))
{
if($_FILES['image_file']['type'] == "image/jpg"){
$ext = ".jpg";
}else if($_FILES['image_file']['type'] == "image/jpeg"){
$ext = ".jpg";
}else if($_FILES['image_file']['type'] == "image/pjpeg"){
$ext = ".jpg";
}
mkdir ($root . '/article_images/' . $dirname);
//chmod ($root . '/article_images/' . $dirname, 0777);
$picture = $_FILES['image_file']['tmp_name'];
list($width, $height) = getimagesize($picture);
$objResize = new RVJ_ImageResize($_FILES['image_file']['tmp_name'], $root . '/article_images/'. $dirname . '/image.jpg', 'W', '295');
$objResize = new RVJ_ImageResize($_FILES['image_file']['tmp_name'], $root . '/article_images/'. $dirname . '/populair.jpg', 'W', '204');
$objResize = new RVJ_ImageResize($_FILES['image_file']['tmp_name'], $root . '/article_images/'. $dirname . '/thumb.jpg', 'W', '125');
}
}
$url = friendlyURL($naam);
$naam = utf8_decode($naam);
$naam = htmlentities($naam);
$artikelnr = utf8_decode($artikelnr);
$artikelnr = htmlentities($artikelnr);
$naam = checkData($naam);
$artikelnr = checkData($_POST['artikelnr']);
$omschrijving = checkData($_POST['omschrijving']);
$image = $dirname;
$subcategorie = checkData($subcategorie);
$geslacht = checkData($geslacht);
$merk = checkData($merk);
$maat_van = checkData($maat_van);
$maat_tot = checkData($maat_tot);
$populair = checkData($populair);
if($populair != "yes"){ $populair = "no"; }
$artikelnr = strtoupper($artikelnr );
$q_sort = sprintf("SELECT MAX(sort_order) as sort_value FROM kms_articles WHERE kms_articles.subcategorie_id='%s'", $subcategorie);
$r_sort = mysql_query($q_sort);
$rec_sort = mysql_fetch_array($r_sort);
$sort_order = $rec_sort['sort_value'] + 1;
$q_nieuws = sprintf("INSERT INTO kms_articles (article_name, article_number, brand_id, subcategorie_id, gender_id, description, size_from, size_to, image_dir, popular, url, sort_order) VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')",
$naam,
$artikelnr,
$merk,
$subcategorie,
$geslacht,
$omschrijving,
$maat_van,
$maat_tot,
$image,
$populair,
$url,
$sort_order);
$r_nieuws = mysql_query($q_nieuws);
if($r_nieuws){
$q_artikel_id = sprintf("SELECT kms_articles.article_id FROM kms_articles WHERE url='%s'", $url);
$r_artikel_id = mysql_query($q_artikel_id);
$rec_artikel_id = mysql_fetch_array($r_artikel_id);
echo("Artikel succesvol gewijzigd!<br /><br />");
echo("<a href=\"index.php?p=kleur_overzicht&artikel_id=".$rec_artikel_id['article_id']."\" title=\"Kleuren beheren\">Klik hier als u de kleuren van dit artikel wilt beheren</a>");
echo(" | <a href=\"index.php?p=artikel_overzicht\" title=\"Terug naar het overzicht\">Terug naar het overzicht</a>");
}else{
echo("Er is iets fout gegaan.");
}
}else{
?>
<h1>Artikel toevoegen</h1>
<p>Vul onderstaande gegevens in om een artikel toe te voegen.</p>
<span class="label">* = verplicht</span><br /><br />
<form enctype="multipart/form-data" action="<?php $_SERVER['PHP_SELF']; ?>" id="aanmelden" name="aanmelden" method="post">
<div>
<label>Naam*</label>
<input name="naam" type="text" value="<?php echo(htmlspecialchars($naam)); ?>" />
<?php if(!$valid_naam && $verzenden){ print("<span class=\"error\"> (foutieve invoer)</span>"); }?>
<?php if(!$valid_naam && $verzenden && $te_lang_naam){ print("<span class=\"error\"><br />(invoer te lang)</span>"); }?>
<?php if($valid_naam && $verzenden && !$bestaat_niet){ print("<span class=\"error\"><br />(de naam bestaat al)</span>"); }?><br />
<br />
<label>Artikelnummer*</label>
<input name="artikelnr" type="text" value="<?php echo(htmlspecialchars($artikelnr)); ?>" />
<?php if(!$valid_artikelnr && $verzenden){ print("<span class=\"error\"> (foutieve invoer)</span>"); }?>
<?php if(!$valid_artikelnr && $verzenden && $te_lang_artikelnr){ print("<span class=\"error\"><br />(invoer te lang)</span>"); }?>
<?php if($valid_artikelnr && $verzenden && !$bestaat_niet_artikel){ print("<span class=\"error\"><br />(artikelnummer bestaat al)</span>"); }?><br />
<br />
<label>Subcategorie:*</label>
<select name="subcategorie" >
<option></option>
<?php
$q_categorieen = "SELECT kms_subcategories.subcategorie_id, kms_subcategories.subcategorie_name FROM kms_subcategories ORDER BY subcategorie_name ASC";
$r_categorieen = mysql_query($q_categorieen);
while($rec_categorieen = mysql_fetch_array($r_categorieen)){ ?>
<option value="<?php echo($rec_categorieen[0]); ?>" <?php if ($subcategorie == $rec_categorieen[0]) { echo("selected=\"selected\"");} ?>><?php echo(html_entity_decode($rec_categorieen[1])); ?></option>
<?php } ?>
</select>
<?php if(empty($subcategorie) && $verzenden){ echo("<span class=\"error\"> (selecteer een subcategorie)</span>"); }?>
<br /><br />
<label>Geslacht:*</label>
<select name="geslacht" >
<option></option>
<?php
$q_genders = "SELECT kms_genders.gender_id, kms_genders.gender_name FROM kms_genders ORDER BY gender_name ASC";
$r_genders = mysql_query($q_genders);
while($rec_genders = mysql_fetch_array($r_genders)){ ?>
<option value="<?php echo($rec_genders[0]); ?>" <?php if ($geslacht == $rec_genders[0]) { echo("selected=\"selected\"");} ?>><?php echo(html_entity_decode($rec_genders[1])); ?></option>
<?php } ?>
</select>
<?php if(empty($geslacht) && $verzenden){ echo("<span class=\"error\"> (selecteer een geslacht)</span>"); }?>
<br /><br />
<label>Merk:*</label>
<select name="merk" >
<option></option>
<?php
$q_merken = "SELECT kms_brands.brand_id, kms_brands.brand_name FROM kms_brands ORDER BY brand_name ASC";
$r_merken = mysql_query($q_merken);
while($rec_merken = mysql_fetch_array($r_merken)){ ?>
<option value="<?php echo($rec_merken[0]); ?>" <?php if ($merk == $rec_merken[0]) { echo("selected=\"selected\"");} ?>><?php echo(html_entity_decode($rec_merken[1])); ?></option>
<?php } ?>
</select>
<?php if(empty($merk) && $verzenden){ echo("<span class=\"error\"> (selecteer een merk)</span>"); }?>
<br /><br />
<label>Maat van:*</label>
<select name="maat_van" >
<option></option>
<optgroup label="- Volwassen -">
<option value="XXS" <?php if ($maat_van == "XXS") { echo("selected=\"selected\"");} ?>>XXS</option>
<option value="XS" <?php if ($maat_van == "XS") { echo("selected=\"selected\"");} ?>>XS</option>
<option value="S" <?php if ($maat_van == "S") { echo("selected=\"selected\"");} ?>>S</option>
<option value="M" <?php if ($maat_van == "M") { echo("selected=\"selected\"");} ?>>M</option>
<option value="L" <?php if ($maat_van == "L") { echo("selected=\"selected\"");} ?>>L</option>
<option value="XL" <?php if ($maat_van == "XL") { echo("selected=\"selected\"");} ?>>XL</option>
<option value="XXL" <?php if ($maat_van == "XXL") { echo("selected=\"selected\"");} ?>>XXL</option>
<option value="3Xl" <?php if ($maat_van == "3XL") { echo("selected=\"selected\"");} ?>>3XL</option>
<option value="4XL" <?php if ($maat_van == "4XL") { echo("selected=\"selected\"");} ?>>4XL</option>
</optgroup>
<optgroup label="- Kinderen - ">
<option value="98/104" <?php if ($maat_van == "98/104") { echo("selected=\"selected\"");} ?>>98/104</option>
<option value="110/116" <?php if ($maat_van == "110/116") { echo("selected=\"selected\"");} ?>>110/116</option>
<option value="122/128" <?php if ($maat_van == "122/128") { echo("selected=\"selected\"");} ?>>122/128</option>
<option value="134/146" <?php if ($maat_van == "134/146") { echo("selected=\"selected\"");} ?>>134/146</option>
<option value="152/164" <?php if ($maat_van == "152/164") { echo("selected=\"selected\"");} ?>>152/164</option>
</optgroup>
<optgroup label="- Babys- ">
<option value="53/60" <?php if ($maat_van == "53/60") { echo("selected=\"selected\"");} ?>>53/60</option>
<option value="60/66" <?php if ($maat_van == "60/66") { echo("selected=\"selected\"");} ?>>60/66</option>
<option value="66/76" <?php if ($maat_van == "66/76") { echo("selected=\"selected\"");} ?>>66/76</option>
<option value="76/86" <?php if ($maat_van == "76/86") { echo("selected=\"selected\"");} ?>>76/86</option>
<option value="86/93" <?php if ($maat_van == "86/93") { echo("selected=\"selected\"");} ?>>86/93</option>
</optgroup>
</select>
<?php if(empty($maat_van) && $verzenden){ echo("<span class=\"error\"> (selecteer een categorie)</span>"); }?>
<br /><br />
<label>Maat tot:*</label>
<select name="maat_tot" >
<option></option>
<optgroup label="- Volwassen -">
<option value="XXS" <?php if ($maat_tot == "XXS") { echo("selected=\"selected\"");} ?>>XXS</option>
<option value="XS" <?php if ($maat_tot == "XS") { echo("selected=\"selected\"");} ?>>XS</option>
<option value="S" <?php if ($maat_tot == "S") { echo("selected=\"selected\"");} ?>>S</option>
<option value="M" <?php if ($maat_tot == "M") { echo("selected=\"selected\"");} ?>>M</option>
<option value="L" <?php if ($maat_tot == "L") { echo("selected=\"selected\"");} ?>>L</option>
<option value="XL" <?php if ($maat_tot == "XL") { echo("selected=\"selected\"");} ?>>XL</option>
<option value="XXL" <?php if ($maat_tot == "XXL") { echo("selected=\"selected\"");} ?>>XXL</option>
<option value="3Xl" <?php if ($maat_tot == "3XL") { echo("selected=\"selected\"");} ?>>3XL</option>
<option value="4XL" <?php if ($maat_tot == "4XL") { echo("selected=\"selected\"");} ?>>4XL</option>
</optgroup>
<optgroup label="- Kinderen - ">
<option value="98/104" <?php if ($maat_tot == "98/104") { echo("selected=\"selected\"");} ?>>98/104</option>
<option value="110/116" <?php if ($maat_tot == "110/116") { echo("selected=\"selected\"");} ?>>110/116</option>
<option value="122/128" <?php if ($maat_tot == "122/128") { echo("selected=\"selected\"");} ?>>122/128</option>
<option value="134/146" <?php if ($maat_tot == "134/146") { echo("selected=\"selected\"");} ?>>134/146</option>
<option value="152/164" <?php if ($maat_tot == "152/164") { echo("selected=\"selected\"");} ?>>152/164</option>
</optgroup>
<optgroup label="- Babys- ">
<option value="53/60" <?php if ($maat_tot == "53/60") { echo("selected=\"selected\"");} ?>>53/60</option>
<option value="60/66" <?php if ($maat_tot == "60/66") { echo("selected=\"selected\"");} ?>>60/66</option>
<option value="66/76" <?php if ($maat_tot == "66/76") { echo("selected=\"selected\"");} ?>>66/76</option>
<option value="76/86" <?php if ($maat_tot == "76/86") { echo("selected=\"selected\"");} ?>>76/86</option>
<option value="86/93" <?php if ($maat_tot == "86/93") { echo("selected=\"selected\"");} ?>>86/93</option>
</optgroup>
</select>
<?php if(empty($maat_tot) && $verzenden){ echo("<span class=\"error\"> (selecteer een categorie)</span>"); }?>
<br /><br />
<label>Omschrijving* <?php if(!$valid_omschrijving && $verzenden){ echo("<span class=\"error\"> (foutieve invoer)</span>"); }?></label><br /><br />
<?php
// Create class instance.
$CKEditor = new CKEditor();
// Do not print the code directly to the browser, return it instead
$CKEditor->returnOutput = true;
// Path to CKEditor directory, ideally instead of relative dir, use an absolute path:
// $CKEditor->basePath = '/ckeditor/'
// If not set, CKEditor will try to detect the correct path.
$CKEditor->basePath = 'ckeditor/';
// Set global configuration (will be used by all instances of CKEditor).
$CKEditor->config['width'] = 600;
$CKEditor->config['toolbar'] = 'Basic';
// Change default textarea attributes
$CKEditor->textareaAttributes = array("cols" => 80, "rows" => 10);
// The initial value to be displayed in the editor.
$initialValue = $omschrijving;
// Create first instance.
$code = $CKEditor->editor("omschrijving", $initialValue);
echo $code;
?>
<br />
<p style="width:560px;"><em><strong>Opmerkingen:</strong> Door in de editor op "enter" te drukken wordt een nieuwe paragraaf gestart.
Wanneer u een "normale enter" wilt zetten kan dit via de combinatie "shift" + "enter".</em></p>
<br />
<br /><br />
<label>Afbeelding selecteren <br />(.jpg en max. 1 MB)</label>
<input class="file_input" type="file" name="image_file" />
<br />
<?php if(!$valid_type && !$valid_file && $verzenden && !$file_tegroot){ print("<span class=\"error\"><br />(Selecteer een afbeelding)</span>"); }?>
<?php if(!$valid_type && $valid_file && $verzenden && !$file_tegroot){ print("<span class=\"error\"><br />(Alleen jpg bestanden)</span>"); }?>
<?php if($file_tegroot && $verzenden){ print("<span class=\"error\"><br />(Uw bestand is te groot. Max 1 MB)</span>"); }?><br />
<br />
<label>Populair</label>
<input type="checkbox" name="populair" value="yes" <?php if ($populair == "yes") { echo("checked=\"checked\"");} ?> /><br />
<?php if($teveel_populair && $verzenden){ echo("<span class=\"error\"> (er zijn al 2 populaire artikelen in de geselecteerde categorie)</span>"); }?>
<br /><br />
<input name="verzenden" type="submit" value="Toevoegen" class="submit" />
<a class="submit_annuleren" href="index.php?p=artikel_overzicht" title="Annuleren">Annuleren</a>
</div>
</form>
<?php
}
?>