1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / jeffautomobileinc.com / dealer /
Filename : add-product.php
back
<?php ob_start(); ?>
<?php
session_start();
error_reporting(0);
include('../../config/jaconfig.php');
include('include/checklogin.php');
check_login();
$title="Add Product";

$dealer_id =$_SESSION['id'];


if (isset($_POST['submit'])) {
    // Collect form data
    $category = mysqli_real_escape_string($con, $_POST['category']);
    $brand = mysqli_real_escape_string($con, $_POST['brand']);
    $stock = intval($_POST['stock']);
	$product_tag = intval($_POST['product_tag']);
    $description = mysqli_real_escape_string($con, $_POST['description']);
    $productname = mysqli_real_escape_string($con, $_POST['productName']);
    $productprice = floatval($_POST['productprice']);
    $productkeywords = mysqli_real_escape_string($con, $_POST['product_keywords']);
    $product_image = $_FILES["product_image"]["name"];
    $asOfDate = $_POST['as_of_date'];
    $pricePerUnit = floatval($_POST['price_per_unit']);
    $minimumStock = intval($_POST['minimum_stock']);
    $itemLocation = mysqli_real_escape_string($con, $_POST['item_location']);
    $discountType = mysqli_real_escape_string($con, $_POST['discount_type']);
    $discountValue = floatval($_POST['discount_value']);
    $finalPrice = $productprice; // Default to original price

    // Calculate final price based on discount
    if ($discountType === 'percentage' && $discountValue > 0 && $discountValue <= 100) {
        $finalPrice = $productprice - ($productprice * ($discountValue / 100));
    } elseif ($discountType === 'fixed' && $discountValue > 0 && $discountValue <= $productprice) {
        $finalPrice = $productprice - $discountValue;
    }

    // Prepare to upload the main image
    $target_dir = "../admin/uploads/";
    $target_file = $target_dir . basename($_FILES["product_image"]["name"]);
    $filename = mysqli_real_escape_string($con, basename($_FILES["product_image"]["name"]));
    $uploadOk = 1;
    $imageFileType = strtolower(pathinfo($target_file, PATHINFO_EXTENSION));

	 // Get file extension
	 $imageFileType = strtolower(pathinfo($_FILES["product_image"]["name"], PATHINFO_EXTENSION));
	 // Create a unique filename for the main product image
	 $newFileName = "product_" . $productid . "_" . time() . "." . $imageFileType;
	 $target_file = $target_dir . $newFileName; 

    // Check if image file is an actual image
    $check = getimagesize($_FILES["product_image"]["tmp_name"]);
    if ($check !== false) {
        $uploadOk = 1;
    } else {
        $msg = "File is not an image.";
        $uploadOk = 0;
    }

    // Check if file already exists
    if (file_exists($target_file)) {
        $msg = "File already exists.";
        $uploadOk = 0;
    }

    // Check file size
    if ($_FILES["product_image"]["size"] > 500000) {
        $msg = "Sorry, your file is too large.";
        $uploadOk = 0;
    }

    // Allow certain file formats2
    if ($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg" && $imageFileType != "gif") {
        $msg = "Sorry, only JPG, JPEG, PNG & GIF files are allowed.";
        $uploadOk = 0;
    }

    // Attempt to upload file
    if ($uploadOk == 0) {
        $msg = "Sorry, your file was not uploaded.";
    } else {
        if (move_uploaded_file($_FILES["product_image"]["tmp_name"], $target_file)) {
            $msg = "Product image has been uploaded.";

            // Execute database insert for new product
            $sql = "INSERT INTO products (dealer_id, product_cat_id, product_brand_id, stock, product_title, product_price, product_desc, product_keywords, 
                    product_image, as_of_date, price_per_unit, minimum_stock, item_location, discount_type, discount_value, final_price,product_tag) 
                    VALUES ('$dealer_id', '$category', '$brand', '$stock', '$productname', '$productprice', '$description', '$productkeywords', 
                    '$newFileName', '$asOfDate', '$pricePerUnit', '$minimumStock', '$itemLocation', '$discountType', '$discountValue', '$finalPrice','$product_tag')";

            $result = mysqli_query($con, $sql);

            if ($result) {
                $msg = "New Product Added Successfully !!";
                $type = "success";
                
				// Get the ID of the newly inserted product
				$productid = mysqli_insert_id($con); 

				// If there are additional images, process them
				if (!empty($_FILES['other_product_images']['name'][0])) {
					foreach ($_FILES['other_product_images']['name'] as $key => $value) {
						// Original image name from the input
						$originalImageName = $_FILES['other_product_images']['name'][$key];
						// Temporary file name for the image
						$imageTmpName = $_FILES['other_product_images']['tmp_name'][$key];
						
						// Retrieve file extension
						$imageFileType = strtolower(pathinfo($originalImageName, PATHINFO_EXTENSION));
						// Create a unique filename for each additional product image
						$newImageName = "additional_product_" . $productid . "_" . time() . "_" . $key . "." . $imageFileType;
						$imageTarget = $target_dir . $newImageName;

						// Ensure no duplicate file names (although unlikely due to timestamp and key)
						if (file_exists($imageTarget)) {
							continue;  // Skip this file as it already exists
						}

						// Move the uploaded file to the new target location
						if (move_uploaded_file($imageTmpName, $imageTarget)) {
							// Insert the new unique image name into the product_images table
							$insertImageSql = "INSERT INTO product_images (product_id, thumb, created_at) VALUES ('$productid', '$newImageName', NOW())";
							mysqli_query($con, $insertImageSql);
						}
					}
				}


            } else {
                $msg = "Failed to add product: " . mysqli_error($con);
                $type = "error";
            }
        } else {
            $msg = "Sorry, there was an error uploading your file.";
        }
    }
}


?>

<?php include('include/header.php');?>
		
<?php include('include/sidebar.php');?>

  <!-- Content wrapper -->
  <div class="content-wrapper">
            <!-- Content -->

<div class="container-xxl flex-grow-1 container-p-y">
<h4 class="fw-bold py-3 mb-4"><span class="text-muted fw-light">New/</span> Add Product</h4>
 
 <div class="card mb-4">
                    <h5 class="card-header">New Product</h5>
                    <!-- Account -->
                    <hr class="my-0" />
                    <div class="card-body">
					<?php if(isset($msg)){ ?>
                    <div class="alert alert-<?php echo $type?>">
                          <h6 class="alert-heading fw-bold mb-1"><?php echo $type?></h6>
                          <p class="mb-0"><?php echo $msg?></p>
                        </div>
                        <?php }?>
						
        
  <div class="text-box">			

  <form class="form-horizontal row-fluid" name="insertproduct" method="post" enctype="multipart/form-data">

<div class="mb-3 col-md-6">
<label class="" for="basicinput">Category</label>
<div class="">
<select name="category" class="form-control" onChange="getSubcat(this.value);"  required>
<option value="">--Select Category--</option> 
<?php $query=mysqli_query($con,"select * from categories");
while($row=mysqli_fetch_array($query))
{?>

<option value="<?php echo $row['cat_id'];?>"><?php echo $row['cat_title'];?></option>
<?php } ?>
</select>
</div>
</div>

<div class="mb-3 col-md-6">
<label class="" for="basicinput">Brand</label>
<div class="">
<select name="brand" class="form-control" required>
<option value="">--Select Brand--</option> 
<?php $query=mysqli_query($con,"select * from brands");
while($row=mysqli_fetch_array($query))
{?>

<option value="<?php echo $row['brand_id'];?>"><?php echo $row['brand_title'];?></option>
<?php } ?>
</select>
</div>
</div>

<div class="mb-3 col-md-6">
<label class="" for="basicinput">Product Tag (Optional)</label>
<div class="">
<select name="product_tag" class="form-control" >
<option value="">--Select Tag--</option> 
<option value="HOT">Trending</option> 
<option value="LATEST">Just In</option> 
<option value="NEW">Recommendation</option> 

</select>
</div>
</div>


<div class="mb-3 col-md-6">
<label class="control-label" for="basicinput"> Name</label>
<div class="">
<input type="text" class="form-control" name="productName"  placeholder="Enter Name of Product" class="span8 tip" required>
</div>
</div>

<div class="mb-3 col-md-6">
    <label class="control-label" for="basicinput">Sale Price</label>
    <div class="">
        <input type="text" class="form-control" name="productprice" placeholder="Enter Product Sale Price" required>
    </div>
</div>

<div class="mb-3 col-md-6">
    <label class="control-label" for="discount_type">Discount Type and Value</label>
    <div class="">
        <select name="discount_type" class="form-control" id="discount_type" onchange="toggleDiscountInput();">
            <option value="">--Select Discount Type--</option>
            <option value="percentage">Percentage</option>
            <option value="fixed">Fixed Amount</option>
        </select>
        <input type="number" class="form-control mt-2" name="discount_value" id="discount_value" placeholder="Enter Discount Value" min="0" step="any" style="display: none;">
    </div>
</div>



<div class="mb-3 col-md-6">
        <label class="control-label" for="basicinput">Qty in Stock (Opening Stock)</label>
        <div class="controls">
            <input type="number" class="form-control" name="stock" placeholder="Opening Stock" required>
        </div>
    </div>

    <div class="mb-3 col-md-6">
        <label class="control-label" for="basicinput">As of Date</label>
        <div class="controls">
            <input type="date" class="form-control" name="as_of_date" required>
        </div>
    </div>

    <div class="mb-3 col-md-6">
        <label class="control-label" for="basicinput">Price per Unit</label>
        <div class="controls">
            <input type="text" class="form-control" name="price_per_unit" placeholder="Price per Unit" required>
        </div>
    </div>

    <div class="mb-3 col-md-6">
        <label class="control-label" for="basicinput">Minimum Stock</label>
        <div class="controls">
            <input type="number" class="form-control" name="minimum_stock" placeholder="Minimum Stock" required>
        </div>
    </div>

    <div class="mb-3 col-md-6">
        <label class="control-label" for="basicinput">Item Location</label>
        <div class="controls">
            <input type="text" class="form-control" name="item_location" placeholder="Item Location" required>
        </div>
    </div>

<div class="mb-3 col-md-6">
<label class="control-label" for="basicinput"> Description</label>
<div class="controls">
<textarea name="description" class="form-control"  >
</textarea>
</div>
</div>

<div class="mb-3 col-md-6">
<label class="control-label" for="basicinput"> Keywords(for search)</label>
<div class="controls">
<input type="text" class="form-control"   name="product_keywords"  placeholder="Enter Keywords and seperate them with a comma(,)" class="span8 tip" required>
</div>
</div>


<div class="mb-3 col-md-6">
<label class="control-label" for="basicinput">Main Image</label>
<div class="controls">
<input type="file"  name="product_image" id="product_image" value="" class="form-control" required>
</div>
</div>

<div class="mb-3 col-md-6">
        <label class="control-label" for="other_product_images">Other Images</label>
        <div class="controls">
            <input type="file" name="other_product_images[]" id="other_product_images" class="form-control" multiple>
        </div>
    </div>


	<div class="">
											<div class="mb-3 col-md-6">
												<button type="submit" name="submit" class="btn btn-o btn-primary" >Upload Product</button>
											</div>
										</div>
									</form>
							</div>
						</div>


	
						
						
					</div><!--/.content-->
				</div><!--/.span9-->
			</div>
		</div><!--/.container-->
	</div><!--/.wrapper-->
	</div><!--/.content-->
				</div><!--/.span9-->
			</div>
		</div><!--/.container-->
	</div><!--/.wrapper-->

	<script>
function toggleDiscountInput() {
    var discountType = document.getElementById('discount_type').value;
    var discountInput = document.getElementById('discount_value');
    if (discountType === 'percentage' || discountType === 'fixed') {
        discountInput.style.display = '';  // Show the input field
        discountInput.placeholder = (discountType === 'percentage' ? 'Enter Discount Percentage' : 'Enter Discount Amount'); // Change placeholder
    } else {
        discountInput.style.display = 'none'; // Hide the input field
    }
}
</script>


<?php include('include/footer.php');?>