| Server IP : 109.234.164.53 / Your IP : 216.73.216.110 Web Server : Apache System : Linux cervelle.o2switch.net 4.18.0-553.32.1.lve.el8.x86_64 #1 SMP Thu Dec 19 13:14:03 UTC 2024 x86_64 User : computer3 ( 1098) PHP Version : 7.1.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/computer3/litsolide.com/cp-admin/ |
Upload File : |
<?php
include_once('includes/header.php');
$id_volet ="4";
include('includes/volet.php');
/****************************/
if (isset($_GET['cat'])) {
if (empty($_GET['cat'])) { $cat= $_POST['cat']; } else { $cat= $_GET['cat']; }
$requete = $bdd->query("SELECT * FROM " . $GLOBALS['db_table']['categories'] . " WHERE id = " . $_GET['cat']);
$category = $requete->fetch();
}
if (isset($_POST['add'])) {
if ($_POST['tva'] == $T_0_valeur) { $cle_tva = "0"; }
if ($_POST['tva'] == $T_1_valeur) { $cle_tva = "1"; }
if ($_POST['tva'] == $T_2_valeur) { $cle_tva = "2"; }
if ($_POST['tva'] == $T_3_valeur) { $cle_tva = "3"; }
///////////////////////////
$price= $_POST['price'];
///////////////////////////
$isFeatured = ($_POST['featuredPage'] == 'on') ? 1 : 0;
$isslidepromo = ($_POST['slidepromo'] == 'on') ? 1 : 0;
$ishstock = ($_POST['hstock'] == 'on') ? 1 : 0;
$qid = $bdd->prepare("INSERT INTO " . $GLOBALS['db_table']['products'] . " (seo, reference, name, short_desc, long_desc, date_insere, price, weight, cle_tva, featured, meta_caption, meta_keywords)
VALUES (:seo, :reference, :name, :short_desc, :long_desc, :date_insere, :price, :weight, :cle_tva, :featured, :meta_caption, :meta_keywords)");
$qid->execute(array(
'seo' => text2url($_POST['name']),
'reference' => $_POST['reference'],
'name' => $_POST['name'],
'short_desc' => $_POST['short_desc'],
'long_desc' => $_POST['long_desc'],
'date_insere' => date('Y-m-d'),
'price' => $_POST['price'],
'weight' => $_POST['weight'],
'cle_tva' => $cle_tva,
'featured' => $isFeatured,
'meta_caption' => $_POST['meta_caption'],
'meta_keywords' => $_POST['meta_keywords']
));
/* récupère l'id du produit créé */
$id_product = $bdd->lastInsertId();
if(isset($_FILES['picture']['name']) && $_FILES['picture']['name'] != '') {
// Enregistrement des images sur le serveur
$desired_dir="../uploadfiles/products/";
$file_name = str_replace(array(' ', '-'), array('_','_'), $_FILES['picture']['name']);
$file_name = explode('.', $file_name);
$ext = array_pop($file_name);
$ext = strtolower($ext);
$file_name = implode('.', $file_name);
if(file_exists($desired_dir . $file_name . '.' . $ext))
{
$file_name .= time();
}
$result = upload_image($_FILES['picture'], array('file_name'=>$file_name, 'file_path'=>$desired_dir, 'image_ratio_pixels'=>1500000, 'max_file_size'=>4000000));
clone_pictures(array('source_file_full_path'=>$desired_dir.$result['file_name'], 'destination_folder'=>$desired_dir.'mini/', 'image_ratio_pixels'=>100000));
$file_name .= '.' . $ext;
}
if(!isset($file_name))
$file_name = '';
if($file_name !=='') {
$qid = $bdd->prepare("INSERT INTO " . $GLOBALS['db_table']['products_pictures'] . " (id_product, picture, position) VALUES (:id_product, :picture, :position)");
$qid->execute(array(
'id_product' => $id_product,
'picture' => $file_name,
'position' => 1
));
}
/* ajoute le produit sous les catégories spécifiées */
for ($i = 0; $i < count($_POST["categories"]); $i++) {
$qid = $bdd->exec("INSERT INTO " . $GLOBALS['db_table']['products_categories'] . " (id_category, id_product) VALUES ('" . $_POST["categories"][$i] . "', '$id_product')");
}
/* ajoute le produit sous les marques spécifiées */
for ($i = 0; $i < count($_POST["marques"]); $i++) {
$qid = $bdd->exec("INSERT INTO " . $GLOBALS['db_table']['products_marques'] . " (id_marque, id_product) VALUES ('" . $_POST["marques"][$i] . "', '$id_product')");
}
/* ajoute les associations de produit */
for ($i = 0; $i < count($_POST["products_associated"]); $i++) {
$qid = $bdd->exec("INSERT INTO " . $GLOBALS['db_table']['products_associated'] . " (id_product, id_product_asso) VALUES ('$id_product', '" . $_POST["products_associated"][$i] . "')");
}
/* ajoute les attributs du produit */
for ($i = 0; $i < count($_POST["product_attributes"]); $i++) {
$qid = $bdd->exec("INSERT INTO " . $GLOBALS['db_table']['products_attributes'] . " (id_product, id_attribute) VALUES ('$id_product', '" . $_POST["product_attributes"][$i] . "')");
}
/* ajoute les transporteurs du produit */
for ($i = 0; $i < count($_POST["product_carriers"]); $i++) {
$qid = $bdd->exec("INSERT INTO " . $GLOBALS['db_table']['products_carriers'] . " (id_product, id_carrier) VALUES ('$id_product', '" . $_POST["product_carriers"][$i] . "')");
}
echo '<script>';
if (isset($_POST['category']))
echo 'window.location = "./edit_product.php?id=' . $id_product . '&cat='.$cat.'"';
else
echo 'window.location = "./edit_product.php?id=' . $id_product . '&cat='.$cat.'"';
echo '</script>';
}
?>
<div class="container">
<form class="form-horizontal" method="post" action="#" enctype="multipart/form-data">
<div class="row">
<div class="span12">
<div class="page-header">
<h1>Ajouter Produit<?php if (isset($category['id'])) echo ' dans la catégorie ' . $category['name']; ?>
<div class="pull-right">
<button type="submit" name="add" class="btn btn-success"><i class="icon-ok"></i> Enregistrer</button>
<?php
if (isset($category['id']))
echo '<input type="hidden" name="category" value="' . $category['id'] . '"><a href="details_category.php?id=' . $category['id'] . '" class="btn btn-primary"><i class="icon-arrow-left"></i> Retour</a>';
else
echo '<a href="products.php" class="btn btn-primary"><i class="icon-arrow-left"></i> Retour</a>';
?>
</div>
</h1>
</div>
</div>
</div>
<input name="cat" type="hidden" value="<?php echo$_GET['cat']; ?>" />
<?php
echo '<div id="form-content" style="">';
echo '<div class="row-fluid">';
echo '<div class="span6">';
/*
echo '<div class="control-group">';
echo '<label class="control-label" for="marques">'.$marq_name.' :</label>';
echo '<div class="controls">';
echo '<select name="marques" data-placeholder="Veuillez faire une sélection !" class="chosen-select" style="width:300px;">';
echo '<option value=""></option>';
echo '<option';
echo ' value="">Aucune sélection</option>';
$requete = $bdd->query("SELECT id, name FROM " . $GLOBALS['db_table']['marques']);
while ($row = $requete->fetch()) {
echo '<option';
if ($row['id'] == $marques['id'])
echo ' selected';
echo ' value="'.$row['id'].'">'.stripcslashes($row['name']).'</option>';
}
echo '</select>';
echo '</div>';
echo '</div>';
*/
echo '<div class="control-group">';
echo '<label class="control-label" for="categories[]">Catégorie(s) :</label>';
echo '<div class="controls">';
echo '<select required multiple name="categories[]" data-placeholder="Veuillez sélectionner une catégorie !" class="chosen-select" style="width:300px;">';
echo '<option value=""></option>';
$requete = $bdd->query("SELECT id, name FROM " . $GLOBALS['db_table']['categories']);
while ($row = $requete->fetch()) {
echo '<option';
if ($row['id'] == $category['id'])
echo ' selected';
echo ' value="'.$row['id'].'">'.stripcslashes($row['name']).'</option>';
}
echo '</select>';
echo '</div>';
echo '</div>';
echo '<div class="control-group">';
echo '<label class="control-label" for="reference">Reference :</label>';
echo '<div class="controls">';
echo '<input style="width:287px" name="reference" type="text">';
echo '</div>';
echo '</div>';
echo '<div class="control-group">';
echo '<label class="control-label" for="name">Nom :</label>';
echo '<div class="controls">';
echo '<input required style="width:287px" name="name" type="text">';
echo '</div>';
echo '</div>';
echo '<div class="control-group">';
echo '<label class="control-label" for="poids">Poids (grammes) :</label>';
echo '<div class="controls">';
echo '<input required style="width:287px" name="weight" type="number" min="0">';
echo '</div>';
echo '</div>';
echo '<div class="control-group">';
echo '<label class="control-label" for="tva">TVA (%) :</label>';
echo '<div class="controls">';
echo '<select required name="tva" data-placeholder="Veuillez sélectionner un taux de tva !" class="chosen-select" style="width:300px;">';
echo '<option value="'.$T_1_valeur.'">'.$T_1_text.'</option>';
echo '<option value="'.$T_2_valeur.'">'.$T_2_text.'</option>';
echo '<option value="'.$T_3_valeur.'">'.$T_3_text.'</option>';
echo '<option value="'.$T_0_valeur.'">'.$T_0_text.'</option>';
echo '</select>';
//echo '<input required style="width:287px" name="tva" type="text" min="0" step="0.1">';
echo '</div>';
echo '</div>';
echo '<div class="control-group">';
echo '<label class="control-label" for="price">Prix (€) :</label>';
echo '<div class="controls">';
echo '<input required style="width:287px" name="price" type="number" min="0" step="0.01">';
echo '</div>';
echo '</div>';
echo '<div class="control-group">';
echo '<label class="control-label" for="promoPage">Page à la une :</label>';
echo '<div class="controls">';
echo '<input name="featuredPage" type="checkbox">';
echo '</div>';
echo '</div>';
////////////////////////////////////////////////////////////////////////////////////
echo '<div class="control-group">';
echo '<label class="control-label" for="slidepromo">Slideshow promo :</label>';
echo '<div class="controls">';
echo '<input name="slidepromo" type="checkbox">';
echo '</div>';
echo '</div>';
/////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////
echo '<div class="control-group">';
echo '<label class="control-label" for="hstock">Hors stock :</label>';
echo '<div class="controls">';
echo '<input name="hstock" type="checkbox">';
echo '</div>';
echo '</div>';
/////////////////////////////////////////////////////////////////////////////////////
echo '</div>';
echo '<div class="span6">';
/*
echo '<div class="control-group">';
echo '<label class="control-label" for="picture">Photo :</label>';
echo '<div class="controls">';
echo '<input type="file" name="picture"/>';
echo '</div>';
echo '</div>';
echo '<div class="control-group">';
echo '<label class="control-label" for="products_associated[]">Produit(s) associé(s) :</label>';
echo '<div class="controls">';
echo '<select multiple name="products_associated[]" data-placeholder="Veuillez sélectionner un produit !" class="chosen-select" style="width:300px;">';
$requete = $bdd->query("SELECT id, name FROM " . $GLOBALS['db_table']['products']);
while ($row = $requete->fetch()) {
echo '<option value="'.$row['id'].'">'.stripcslashes($row['name']).'</option>';
}
echo '</select>';
echo '</div>';
echo '</div>';
echo '<div class="control-group">';
echo '<label class="control-label" for="product_attributes[]">Attribut(s) du produit :</label>';
echo '<div class="controls">';
echo '<select multiple name="product_attributes[]" data-placeholder="Veuillez sélectionner un attribut !" class="chosen-select" style="width:300px;">';
$requete = $bdd->query("SELECT * FROM " . $GLOBALS['db_table']['attribute']);
while ($row = $requete->fetch()) {
echo '<option value="'.$row['id'].'">'.stripcslashes($row['name']).'</option>';
}
echo '</select>';
echo '</div>';
echo '</div>';
echo '<div class="control-group">';
echo '<label class="control-label" for="product_carriers[]">Transporteur(s) :</label>';
echo '<div class="controls">';
echo '<select multiple name="product_carriers[]" data-placeholder="Veuillez sélectionner un transporteur !" class="chosen-select" style="width:300px;">';
$requete = $bdd->query("SELECT * FROM " . $GLOBALS['db_table']['carrier']);
while ($row = $requete->fetch()) {
echo '<option value="'.$row['id'].'">'.stripcslashes($row['name']).'</option>';
}
echo '</select>';
echo '</div>';
echo '</div>';
echo '<div class="control-group">';
echo '<label class="control-label" for="promo"><b>Soit Remise (%)</b> :</label>';
echo '<div class="controls">';
echo '<input style="width:150px" name="promo" type="number" min="0" max="100" step="0.00001">';
echo ' <i>Optionnel</i>';
echo '</div>';
echo '</div>';
//////////////////////////////////////////////////////
echo '<div class="control-group">';
echo '<label class="control-label" for="price_promo"><b>Soit Prix remisé (€)</b> :</label>';
echo '<div class="controls">';
echo '<input style="width:150px" name="price_promo" type="number" min="0" step="0.01" >';
echo ' <i>Optionnel</i>';
echo '</div>';
echo '</div>';
/////////////////////////////////////////////////////
*/
echo '<div class="control-group">';
echo '<label class="control-label" for="meta_caption">meta-description :</label>';
echo '<div class="controls">';
echo '<input style="width:287px" name="meta_caption" type="text">';
echo '</div>';
echo '</div>';
echo '<div class="control-group">';
echo '<label class="control-label" for="meta_keywords">Mots-clés :</label>';
echo '<div class="controls">';
echo '<input style="width:287px" name="meta_keywords" type="text">';
echo '</div>';
echo '</div>';
echo '</div>';
echo '</div>';
echo '</div>';
echo '<div class="control-group">';
echo '<label class="control-label" for="description">Description courte :</label>';
echo '<div class="controls">';
echo '<textarea rows="7" name="short_desc" id="short_desc" style="width: 900px; height: 300px;"></textarea>';
echo '<script>
var ckedit = CKEDITOR.replace( \'short_desc\' ,{
filebrowserBrowseUrl : \'includes/filemanager/dialog.php?type=2&editor=ckeditor&fldr=\',
filebrowserUploadUrl : \'includes/filemanager/dialog.php?type=2&editor=ckeditor&fldr=\',
filebrowserImageBrowseUrl : \'includes/filemanager/dialog.php?type=1&editor=ckeditor&fldr=\'
});
</script>';
echo '</div>';
echo '</div>';
echo '<div class="control-group">';
echo '<label class="control-label" for="description">Description longue :</label>';
echo '<div class="controls">';
echo '<textarea rows="7" name="long_desc" id="long_desc" style="width: 900px; height: 300px;"></textarea>';
echo '<script>
var ckedit = CKEDITOR.replace( \'long_desc\' ,{
filebrowserBrowseUrl : \'includes/filemanager/dialog.php?type=2&editor=ckeditor&fldr=\',
filebrowserUploadUrl : \'includes/filemanager/dialog.php?type=2&editor=ckeditor&fldr=\',
filebrowserImageBrowseUrl : \'includes/filemanager/dialog.php?type=1&editor=ckeditor&fldr=\'
});
</script>';
echo '</div>';
echo '</div>';
?>
</form>
</div>
<script type="text/javascript" src="assets/js/chosen.jquery.js" ></script>
<script type="text/javascript">
var config = {
'.chosen-select' : {},
'.chosen-select-deselect' : {allow_single_deselect:true},
'.chosen-select-no-single' : {disable_search_threshold:10},
'.chosen-select-no-results': {no_results_text:'Oops, nothing found!'},
'.chosen-select-width' : {width:"95%"}
}
for (var selector in config) {
$(selector).chosen(config[selector]);
}
</script>
<?
include_once('includes/footer.php');
?>