| Server IP : 212.252.79.165 / Your IP : 216.73.216.24 [ Web Server : Apache System : Linux 212-252-79-165.cprapid.com 5.15.0-153-generic #163-Ubuntu SMP Thu Aug 7 16:37:18 UTC 2025 x86_64 User : cehaburo ( 1001) PHP Version : 8.1.33 Disable Function : exec,passthru,shell_exec,system Domains : 48 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/cehaburo/public_html/admin/ |
Upload File : |
<?php
include 'lib/include.php';
if ($_SERVER['REQUEST_METHOD'] == 'POST'){
$product_id = $_POST['selected-product'];
}else{
$product_id = $_GET['selected-product'];
}
$product_result = $ceha->query("SELECT * FROM tbl_product WHERE id='$product_id' AND active='1'");
$product = $product_result->fetch_array();
$select_category = $ceha->query("SELECT * FROM tbl_product_category WHERE active='1' AND parent_id='0' ORDER BY sequence");
$select_product_gallery = $ceha->query("SELECT * FROM tbl_product_gallery WHERE active='1' AND product_id='$product_id' ORDER BY sequence");
$select_product_properties = $ceha->query("SELECT * FROM tbl_product_properties WHERE active='1' AND product_id='$product_id' ORDER BY sequence");
$icons_result = $ceha->query("SELECT * FROM tbl_icons WHERE active='1'");
$product_icon_result = $ceha->query("SELECT icon_id FROM tbl_product_icons WHERE product_id='$product_id' AND active='1'");
$product_icon_array = array();
while($product_icon = $product_icon_result->fetch_assoc()){
$product_icon_array[$product_icon['icon_id']] = $product_icon['icon_id'];
}
include 'header.php';
?>
<div class="row">
<div class="col-md-12 grid-margin stretch-card">
<div class="card">
<div class="card-body">
<h4 class="card-title">Ürün</h4>
<p class="card-description">
Güncelle
</p>
<form action="dba/product-update.php?selected-product=<?php echo $product_id; ?>" method="post" enctype="multipart/form-data" class="forms-sample">
<div class="form-group">
<label>Kategori Seçimi</label>
<select class="form-control" name="category_id">
<option value="0">Kategori Seçiniz</option>
<?php
while($category = $select_category->fetch_assoc()){
?>
<option value="<?php echo $category['id']; ?>" disabled><?php echo $category['title_tr']; ?></option>
<?php
$select_sub_category = $ceha->query("SELECT * FROM tbl_product_category WHERE active='1' AND parent_id='".$category['id']."' ORDER BY sequence");
while($sub_category = $select_sub_category->fetch_assoc()){
?>
<option value="<?php echo $sub_category['id']; ?>" <?php if($sub_category['id']==$product['category_id']){echo "selected";} ?> > <?php echo $sub_category['title_tr']; ?></option>
<?php } } ?>
</select>
</div>
<ul class="nav nav-tabs" role="tablist">
<?php
$i = 1;
foreach($languages as $language){
?>
<li class="nav-item">
<a class="nav-link <?php if($i == 1){echo("active");} ?>" id="tab<?php echo $i; ?>-tab" data-toggle="tab" href="#tab<?php echo $i; ?>" role="tab" aria-controls="tab<?php echo $i; ?>" aria-selected="<?php if($i == 1){echo("true");}else{echo "false";} ?>"><?php echo $language['name']; ?></a>
</li>
<?php
$i = $i + 1;
}
?>
</ul>
<div class="tab-content">
<?php
$i = 1;
foreach($languages as $language){
?>
<div class="tab-pane fade <?php if($i == 1){echo("show active");} ?>" id="tab<?php echo $i; ?>" role="tabpanel" aria-labelledby="tab<?php echo $i; ?>-tab">
<div class="row">
<div class="col-md-6">
<div class="form-group">
<label>Ürün Adı</label>
<input type="text" class="form-control" name="title_<?php echo $language['key']; ?>" value="<?php echo $product['title_'.$language['key']]; ?>">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label>Seri Adı</label>
<input type="text" class="form-control" name="serie_name_<?php echo $language['key']; ?>" value="<?php echo $product['serie_name_'.$language['key']]; ?>">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label>Açıklama</label>
<textarea class="tinyMceExample" name="content_<?php echo $language['key']; ?>"><?php echo $product['content_'.$language['key']]; ?></textarea>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label>Özellikler</label>
<textarea class="tinyMceExample" name="features_<?php echo $language['key']; ?>"><?php echo $product['features_'.$language['key']]; ?></textarea>
</div>
</div>
<div class="col-md-12">
<div class="form-group">
<label>Teknik Döküman</label>
<div class="row">
<div class="col-12">
<?php
if($product['file_url_'.$language['key']]!=null or $product['file_url_'.$language['key']]!=""){
echo "<a href='dba/product-tech-doc-delete.php?product_id=".$product_id."&lang=".$language['key']."' class='btn btn-light'>Teknik Döküman Sil</a>";
}
?>
<a href="../<?php echo $product['file_url_'.$language['key']]; ?>" target="_blank"><?php echo $product['file_url_'.$language['key']]; ?></a>
</div>
<div class="col-12">
<input type="file" class="dropify" name="file_url_<?php echo $language['key']; ?>" src="" />
</div>
</div>
</div>
</div>
</div>
</div>
<?php
$i = $i + 1;
}
?>
</div>
<button type="submit" class="btn btn-primary mr-2">Kaydet</button>
</form>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-12 grid-margin stretch-card">
<div class="card">
<div class="card-body">
<h4 class="card-title">Ürün İkonları</h4>
<p class="card-description">
Güncelle
</p>
<form action="dba/product-icon-update.php?product_id=<?php echo $product_id; ?>" method="post" enctype="multipart/form-data" class="forms-sample">
<div class="row" style="margin-top: 30px;">
<div class="col-md-12">
<div class="form-group row">
<?php
while($icon = $icons_result->fetch_array()){
?>
<div class="form-check">
<label class="form-check-label">
<input type="checkbox" class="form-check-input" name="product_icon_list[]" value="<?php echo $icon['id']; ?>" <?php if(array_search($icon['id'],$product_icon_array)){echo "checked";} ?> >
<?php echo $icon['title_tr']; ?>
</label>
</div>
<?php
}
?>
</div>
</div>
</div>
<button type="submit" class="btn btn-primary mr-2">Güncelle</button>
</form>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-4 grid-margin stretch-card">
<div class="card">
<div class="card-body">
<h4 class="card-title">Ürün Galeri</h4>
<p class="card-description">
Fotoğraf Ekle
</p>
<form action="dba/product-gallery-insert.php?product_id=<?php echo $product_id; ?>" method="post" enctype="multipart/form-data" class="forms-sample">
<div class="form-group">
<label>Sıralama</label>
<input type="number" class="form-control" name="sequence">
</div>
<div class="row" style="margin-top: 30px;">
<div class="col-md-12">
<div class="form-group">
<label>Fotoğraf</label>
<div class="row">
<div class="col-12">
<input type="file" class="dropify" name="image_url" src="" />
</div>
</div>
</div>
</div>
</div>
<button type="submit" class="btn btn-primary mr-2">Ekle</button>
</form>
</div>
</div>
</div>
<div class="col-md-8 grid-margin stretch-card">
<div class="card">
<div class="card-body" style="flex: none;">
<h4 class="card-title">Ürün Galeri</h4>
<p class="card-description">
Fotoğraf Düzenle/Sil
</p>
</div>
<div class="card-columns six-columns">
<?php
while($product_gallery = $select_product_gallery->fetch_assoc()){
?>
<div class="card">
<img class="card-img-top" src="../<?php echo $product_gallery['image_url']; ?>" alt="Slider image cap">
<div class="card-body">
<form action="dba/product-gallery-update.php?gallery_id=<?php echo $product_gallery['id']; ?>&product_id=<?php echo $product_id; ?>" method="post" enctype="multipart/form-data" class="forms-sample">
<div class="form-group">
<label>Sıralama</label>
<input type="number" class="form-control" name="sequence" value="<?php echo $product_gallery['sequence']; ?>">
</div>
<button type="submit" class="btn btn-light">Güncelle</button>
<a href="dba/product-gallery-delete.php?gallery_id=<?php echo $product_gallery['id']; ?>&product_id=<?php echo $product_id; ?>" class="btn btn-light">Sil</a>
</form>
</div>
</div>
<?php } ?>
</div>
</div>
</div>
</div>
<div class="row">
<div class="col-md-4 grid-margin stretch-card">
<div class="card">
<div class="card-body">
<h4 class="card-title">Renk Seçenekleri</h4>
<p class="card-description">
Ekle
</p>
<form action="dba/product-properties-insert.php?product_id=<?php echo $product_id; ?>" method="post" enctype="multipart/form-data" class="forms-sample">
<div class="form-group">
<label>Sıralama</label>
<input type="number" class="form-control" name="sequence">
</div>
<ul class="nav nav-tabs" role="tablist">
<?php
$i = 11;
foreach($languages as $language){
?>
<li class="nav-item">
<a class="nav-link <?php if($i == 11){echo("active");} ?>" id="tab<?php echo $i; ?>-tab" data-toggle="tab" href="#tab<?php echo $i; ?>" role="tab" aria-controls="tab<?php echo $i; ?>" aria-selected="<?php if($i == 11){echo("true");}else{echo "false";} ?>"><?php echo $language['name']; ?></a>
</li>
<?php
$i = $i + 1;
}
?>
</ul>
<div class="tab-content">
<?php
$i = 11;
foreach($languages as $language){
?>
<div class="tab-pane fade <?php if($i == 11){echo("show active");} ?>" id="tab<?php echo $i; ?>" role="tabpanel" aria-labelledby="tab<?php echo $i; ?>-tab">
<div class="row">
<div class="col-md-12">
<div class="form-group">
<label>Başlık</label>
<input type="text" class="form-control" name="title_<?php echo $language['key']; ?>">
</div>
</div>
</div>
</div>
<?php
$i = $i + 1;
}
?>
</div>
<button type="submit" class="btn btn-primary mr-2">Ekle</button>
</form>
</div>
</div>
</div>
<div class="col-md-8 grid-margin stretch-card">
<div class="card">
<div class="card-body">
<h4 class="card-title">Renk Seçenekleri</h4>
<p class="card-description">
Ekle/Sil
</p>
<?php
$i=1;
while($product_properties = $select_product_properties->fetch_assoc()){
?>
<div class="row">
<div class="col-4">
<a href="dba/product-properties-delete.php?properties_id=<?php echo $product_properties['id']; ?>&product_id=<?php echo $product_id; ?>" class="btn btn-light btn-sm">Sil</a>
<a class="btn btn-primary btn-sm text-white" data-toggle="modal" data-target="#productPropertiesModal<?php echo $i; ?>">Seçenek Ekle</a>
</div>
<div class="col-3">
<p><?php echo $product_properties['title_tr']; ?></p>
</div>
<div class="col-3">
<div class="modal fade" id="productPropertiesModal<?php echo $i; ?>" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" style="display: none;" aria-hidden="true">
<div class="modal-dialog modal-lg" role="document">
<form action="dba/product-properties-detail-update.php?product_id=<?php echo $product_id; ?>&properties_id=<?php echo $product_properties['id']; ?>" method="post" enctype="multipart/form-data" class="forms-sample">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="exampleModalLabel"><?php echo $product_properties['title_tr']; ?> Seçenekleri</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<div class="row">
<?php
$colors_result = $ceha->query("SELECT * FROM tbl_product_colors WHERE active='1'");
$product_properties_detail_result = $ceha->query("SELECT color_id FROM tbl_product_properties_detail WHERE properties_id='".$product_properties['id']."' AND active='1'");
$product_properties_detail_array = array();
while($product_properties_detail = $product_properties_detail_result->fetch_assoc()){
$product_properties_detail_array[$product_properties_detail['color_id']] = $product_properties_detail['color_id'];
}
while($color = $colors_result->fetch_array()){
?>
<div class="col-1">
<div class="form-check">
<label class="form-check-label">
<input type="checkbox" class="form-check-input" name="product_properties_color_list[]" value="<?php echo $color['id']; ?>" <?php if(array_search($color['id'],$product_properties_detail_array)){echo "checked";} ?> >
<?php echo $color['title_tr']; ?>
<?php
if($color['type']==1){
$bg = "background-color: ".$color['content'].";";
}else{
$bg = "background-image: url(../".$color['content'].");";
}
?>
</label>
<div style="position: relative; width: 40px; height: 40px; <?php echo $bg; ?>"></div>
</div>
</div>
<?php
}
?>
</div>
</div>
<div class="modal-footer">
<button type="submit" class="btn btn-primary">Kaydet</button>
<button type="button" class="btn btn-light" data-dismiss="modal">Vazgeç</button>
</div>
</div>
</form>
</div>
</div>
</div>
<div class="col-12">
<div class="product-colors">
<?php
$product_colors_result = $ceha->query("SELECT * FROM tbl_product_properties_detail WHERE active='1' AND properties_id='".$product_properties['id']."'");
while($product_color = $product_colors_result->fetch_array()){
$colors_result = $ceha->query("SELECT * FROM tbl_product_colors WHERE active='1' AND id='".$product_color['color_id']."'");
$color = $colors_result->fetch_array();
if($color['type']==1){
$bg = "background-color: ".$color['content'].";";
}else{
$bg = "background-image: url(../".$color['content'].");";
}
?>
<a style="<?php echo $bg; ?>"><span><?php echo $color['title_tr']; ?></span></a>
<?php } ?>
</div>
</div>
</div>
<hr>
<?php $i=$i+1; } ?>
</div>
</div>
</div>
</div>
<?php include 'footer.php'; ?>