1#@!#!123s

file_get_contents 1#@!#!123s
: / home3 / wwwcraftenterpri / www / admin /
Filename : manage_products.php
back
<?php
  ini_set('display_errors',1);
  session_start();
  include('config.php');
  
  if(!isset($_SESSION['user'])){
    header("Location: index.php"); 
  }
  if(isset($_POST["submit_product"])){
    
    $product_name = mysqli_real_escape_string($conn,$_POST['product_name']);
    $product_description = mysqli_real_escape_string($conn,$_POST['product_description']);
    $product_image = $_FILES['product_image']['name'];
    $product_rate = mysqli_real_escape_string($conn,$_POST['product_rate']);
    $min_order_qty = mysqli_real_escape_string($conn,$_POST['min_order_qty']);
    $Insert_query = "INSERT INTO products (product_name,product_description,product_image,product_rate,min_order_qty) VALUES ('$product_name','$product_description', '$product_image','$product_rate','$min_order_qty')";
    
    $conn->query($Insert_query);
    if(isset($conn->error) && $conn->error != '')
    {
        header("Location: manage_products.php?error=".$conn->error);
    }
    $target_file_product =  $target_dir_product_images . basename($_FILES["product_image"]["name"]);
    move_uploaded_file($_FILES["product_image"]["tmp_name"], $target_file_product);
    
    $Sucess = true;
    
    header("Location: manage_products.php?success=Products has been added successfully");
  }
  
  if(isset($_POST['importSubmit'])){
    
    // Allowed mime types
    $csvMimes = array('text/x-comma-separated-values', 'text/comma-separated-values', 'application/octet-stream', 'application/vnd.ms-excel', 'application/x-csv', 'text/x-csv', 'text/csv', 'application/csv', 'application/excel', 'application/vnd.msexcel', 'text/plain');
    
    // Validate whether selected file is a CSV file
    if(!empty($_FILES['file']['name']) && in_array($_FILES['file']['type'], $csvMimes)){
        
        // If the file is uploaded
        if(is_uploaded_file($_FILES['file']['tmp_name'])){
            
            // Open uploaded CSV file with read-only mode
            $csvFile = fopen($_FILES['file']['tmp_name'], 'r');
            
            // Skip the first line
            fgetcsv($csvFile);
            
            // Parse data from CSV file line by line
            while(($line = fgetcsv($csvFile)) !== FALSE){
                // Get row data
                $product_name   = $line[0];
                $product_description  = $line[1];
                
                $url=$line[2];
                $url_rev = strrev($line[2]);
                $url_rev = explode('.',$url_rev);
                $extension = strrev($url_rev[0]);
                if(!empty($url))
                {
                    $data = file_get_contents($url);
                    $new_image_name = explode('/',strrev($url_rev[1]));
                    $new_image = $new_image_name[count($new_image_name)-1].'.'.$extension;  
                    file_put_contents('./images/product_images/'.$new_image, $data);
                    $product_image  = $new_image;
                }
                else
                {
                    $product_image  = '';    
                }
                
                
                
 
                
                $product_rate  = $line[3];
                $min_order_qty = $line[4];
                
                $prevQuery = "SELECT id FROM products WHERE product_name = '".$line[0]."'";
                $prevResult = $conn->query($prevQuery);
                
                if($prevResult->num_rows > 0){
                   
                    $conn->query("UPDATE products SET product_description = '".$product_description."', product_image = '".$product_image."', product_rate = '".$product_rate."', min_order_qty = '".$min_order_qty."' WHERE product_name = '".$product_name."'");
                }else{
                        $Insert_query = "INSERT INTO products (product_name,product_description,product_image,product_rate,min_order_qty) VALUES ('$product_name','$product_description', '$product_image','$product_rate','$min_order_qty')";
        
                        $conn->query($Insert_query);
                }
            }
            
            // Close opened CSV file
            fclose($csvFile);
            
            $qstring = '?status=succ';
        }else{
            $qstring = '?status=err';
        }
    }else{
        $qstring = '?status=invalid_file';
    }
    
    header("Location: manage_products.php".$qstring);
}


  
  if(isset($_POST['delete'])){
    
    $value = $_POST['delete'];
    $Delete_query = "DELETE FROM products WHERE Id = $value";
   
    
    $auto_increment = "ALTER TABLE products AUTO_INCREMENT = 1";
    
    $get_imagename_query  = "SELECT * from products WHERE Id = $value";
    
    $result_banner_name = $conn->query($get_imagename_query);
    while($row = $result_banner_name->fetch_assoc())
    {
      $product_image =  $row['product_image'];
      $check_product_image = "SELECT COUNT(product_image) from products WHERE product_image LIKE '$product_image' ";
      $result_product_image = $conn->query($check_product_image);
      $product_image_count = $result_product_image->fetch_row();
      if($product_image_count[0] <= 1){
        unlink($target_dir_product_images . $row['product_image']);
      }
     
    }
    $conn->query($Delete_query);
    $conn->query($auto_increment);
    $Delete_Sucess = true;
    
    header("Location: manage_products.php?delete_success=Product deleted successfully");
  }

?>
<html>
    <head>
      <title>Manage Products </title>
      <script src="https://code.jquery.com/jquery-1.11.1.min.js"></script>
      <link rel="stylesheet"  href="https://cdn.datatables.net/1.10.22/css/jquery.dataTables.min.css"></style>
      <script type="text/javascript" src="https://cdn.datatables.net/1.10.22/js/jquery.dataTables.min.js"></script>
      <link href="https://maxcdn.bootstrapcdn.com/font-awesome/4.6.3/css/font-awesome.min.css" rel="stylesheet" integrity="sha384-T8Gy5hrqNKT+hzMclPo118YTQO6cYprQmhrYwIiQ/3axmI1hQomh7Ud2hPOy8SP1" crossorigin="anonymous">
      <script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-modal/2.2.6/js/bootstrap-modalmanager.min.js" integrity="sha512-/HL24m2nmyI2+ccX+dSHphAHqLw60Oj5sK8jf59VWtFWZi9vx7jzoxbZmcBeeTeCUc7z1mTs3LfyXGuBU32t+w==" crossorigin="anonymous"></script>
      <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.0/js/bootstrap.min.js"></script>
      <link href = "./css/dashboard.css" rel = "stylesheet">
      <link href = "./css/main.css" rel = "stylesheet"> 
      <link rel="stylesheet" href="https://fonts.googleapis.com/icon?family=Material+Icons">
      <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.0/css/bootstrap.min.css">
          <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.0/css/bootstrap-theme.min.css">
          <link href="https://maxcdn.bootstrapcdn.com/font-awesome/4.6.3/css/font-awesome.min.css" rel="stylesheet" integrity="sha384-T8Gy5hrqNKT+hzMclPo118YTQO6cYprQmhrYwIiQ/3axmI1hQomh7Ud2hPOy8SP1" crossorigin="anonymous">
          
    <style>
        #importFrm {
            text-align: center;
            margin-bottom: 10px;
            padding: 10px;
            border: 2px dashed #007bff;
        }
        #importFrm input[type=file] {
            display: inline-block;
        }
        .btn-import
        {
            margin: 30px auto;
            width: 300px;
            display: block;
        }
    </style>      
        
    </head>
    <body class="home">
      <div class="container-fluid display-table">
          <div class="row display-table-row">
              <div class="col-md-2 col-sm-1 hidden-xs display-table-cell v-align box" id="navigation">
                  <div class="navi">
                      <ul>
                        <li><br></li>
                        <li ><a href="manage_brands.php"><i class="fa fa-tasks" aria-hidden="true"></i><span class="hidden-xs hidden-sm">  Manage Brands</span></a></li>
                        <li class = "active" ><a href="manage_products.php"><i class="fa fa-tasks" aria-hidden="true"></i><span class="hidden-xs hidden-sm">  Manage Products</span></a></li>
                        <li ><a href="manage_clientele.php"><i class="fa fa-user" aria-hidden="true"></i><span class="hidden-xs hidden-sm">  Manage Clientele</span></a></li>
                        <li><a href="change_details.php"><i class="fa fa-key" aria-hidden="true"></i><span class="hidden-xs hidden-sm">  Change Password</span></a></li>
                      </ul>
                  </div>
              </div>
              <div class="col-md-10 col-sm-11 display-table-cell v-align">
                  <div class="row">
                      <header>
                        <div class="brand_logo_dashboard">
                          <a href="dashboard.php"><img src="../images/logo_1.png" class="img-fluid" alt=""></a>
                        </div>
                        <div class="col-md-7">
                          <nav class="navbar-default pull-left">
                            <div class="navbar-header">
                              <button type="button" class="navbar-toggle collapsed" data-toggle="offcanvas" data-target="#side-menu" aria-expanded="false">
                                <span class="sr-only">Toggle navigation</span>
                                <span class="icon-bar"></span>
                                <span class="icon-bar"></span>
                                <span class="icon-bar"></span>
                              </button>
                            </div>
                          </nav>
                        </div>
                        <div class="col-md-5">
                          <div class="header-rightside">
                            <ul class="list-inline header-top pull-right">                                    
                              <li class="dropdown">    
                                <a href="index.php" class="view btn-sm active">Log out</a>  
                              </li>
                            </ul>
                          </div>
                        </div>
                      </header>
                  </div>
                  <div class="user-dashboard">
                   <div class="container">
                     <br>
                      <div class="col-lg-12">
                       <?php
                        if(isset($_REQUEST['success'])){
                       ?>

                          <div class="alert alert-success alert-dismissible" role="alert">
                              <?php echo $_REQUEST['success']; ?>
                              <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                                <span aria-hidden="true">&times;</span>
                              </button>
                            </div>
                        <?php }
                        if(isset($_REQUEST['delete_success'])){
                        ?>  
                          <div class="alert alert-success alert-dismissible" role="alert">
                                <?php echo $_REQUEST['delete_success']; ?>
                                <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                                    <span aria-hidden="true">&times;</span>
                                </button>
                            </div>
                        <?php }
                        
                        if(isset($_REQUEST['error'])){
                        ?>  
                          <div class="alert alert-success alert-dismissible" role="alert">
                                <?php echo $_REQUEST['error']; ?>
                                <button type="button" class="close" data-dismiss="alert" aria-label="Close">
                                    <span aria-hidden="true">&times;</span>
                                </button>
                            </div>
                        <?php }
                        
                        if(!empty($_GET['status'])){
                        switch($_GET['status']){
                            case 'succ':
                                $statusType = 'alert-success';
                                $statusMsg = 'Products data has been imported successfully.';
                                break;
                            case 'err':
                                $statusType = 'alert-danger';
                                $statusMsg = 'Some problem occurred, please try again.';
                                break;
                            case 'invalid_file':
                                $statusType = 'alert-danger';
                                $statusMsg = 'Please upload a valid CSV file.';
                                break;
                            default:
                                $statusType = '';
                                $statusMsg = '';
                        }
                    }
                    
                        ?>
                        <!-- Display status message -->
                        <?php if(!empty($statusMsg)){ ?>
                        <div class="col-xs-12">
                            <div class="alert <?php echo $statusType; ?>"><?php echo $statusMsg; ?></div>
                        </div>
                        <?php } ?>
                      <div class="section_title text-center">
                        <h2> Manage Products </h2 >
                      </div>
                      <div class="row">
                        <!-- Import link -->
                        <div class="col-md-12 head">
                            <div class="float-right">
                                <a href="javascript:void(0);" class="btn btn-success btn-import btn-lg" onclick="formToggle('importFrm');"> Import Bulk Products </a>
                            </div>
                        </div>
                        <!-- CSV file upload form -->
                        <div class="col-md-12" id="importFrm" style="display: none;">
                            <form action="manage_products.php" method="post" enctype="multipart/form-data">
                                <label for="product_name" >Upload CSV:</label>
                                <input type="file" name="file" />
                                <input type="submit" class="btn btn-primary" name="importSubmit" value="IMPORT">
                                <p><a href="/admin/images/sample-csv-products.csv" download="">download sample file</a></p>
                            </form>
                        </div>
                    
                        <!-- Data list table --> 
                        
                    </div>
                    </div>
                    
                    <form method = "POST" enctype="multipart/form-data" >
                      <div class="form-group">
                          <label for="product_name" >Product Name:</label>
                          <input type="text" class="form-control" id="text"  name="product_name">    
                      </div>
                      <div class="form-group">
                          <label for="product_description" >Product Description:</label>
                          <input type="text" class="form-control" id="text"  name="product_description">    
                      </div>
                      <div class="form-group">
                          <label for="product-logo">Product Image:</label>
                          <input  class="form-control file_selector" type="file" name="product_image">    
                          <span>image size: 370 x 250px</span>
                      </div>
                      <div class="form-group">
                          <label for="rate">Rate:</label>
                          <input class="form-control" type="number" name="product_rate" id="product_rate">
                      </div>
                      <div class="form-group">
                          <label for="min_order_qty">Min Order Quantity:</label>
                          <input type class="form-control" type="text"  name="min_order_qty" id="min_order_qty">
                      </div>
                        <button type="submit" name="submit_product" class="btn btn-lg deneb_btn">Submit Now</button>
                    </form>
                  </div> 
                  <div class="modal " id="delete" role="dialog" aria-labelledby="edit" aria-hidden="true">
                    <div class="modal-dialog modal-confirm">
                      <div class="modal-content">
                        <div class="modal-header flex-column">
                          <div class="icon-box">
                            <i class="material-icons">&#xE5CD;</i>
                          </div>						
                          <h4 class="modal-title w-100">Are you sure?</h4>	
                          <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times;</button>
                        </div>
                      <div class="modal-body">
                      <p>Do you really want to delete these records? This process cannot be undone.</p>
                    </div>
                    <div class="modal-footer justify-content-center">
                      <form method = "POST" >
                        <button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>
                        <button type="submit" class="btn btn-danger" name = "delete" id  = "Delete_yes">Delete</button>
                      </form>
                    </div>
                  </div>
                </div>
              </div>
              <div class="container">
                <div class="row">
                  <div class="col-md-12">
                    <div class="table-responsive">
                      <table id="myTable" class="table table-striped">  
                        <thead>  
                          <tr>  
                            <th>Sr. no</th>  
                            <th>Product Name</th>
                            <th>Product Rate</th>
                            <th>Min Order Quantity</th>
                            <th>Actions</th>  
                          </tr>  
                        </thead>  
                        
                        <tbody>  
                          <?php 
                          $fetch_query = "SELECT * FROM products ORDER BY id DESC";
                          $result = $conn->query($fetch_query);
                          $id  = 0;
                          while($rows = $result->fetch_assoc())  
                            {
                          ?>
                            <tr>  
                              <td><?php echo ++$id ?></td>  
                              
                              <td><?php echo $rows['product_name']; ?></td>
                              <td><?php echo 'Rs. '.$rows['product_rate']; ?></td>
                              <td><?php echo $rows['min_order_qty']; ?></td>
                              <form  name = "myForm" method = "GET" action = "update-products.php">
                                <td><button   class="btn btn-primary btn-xs edit_btn" name = "edit" data-toggle="modal" data-target="#edit"   value = "<?php echo $rows['id']?>" ><span class="glyphicon  glyphicon-pencil"></span></button>
                                <button type = "button" class="btn btn-danger btn-xs Delete delete_btn" data-toggle="modal"   data-target="#delete"  value = "<?php echo $rows['id']?>" onclick="getid(this,'one')"><span class="glyphicon glyphicon-trash"></span></button></td>
                                </form>
                            </tr>  
                          <?php } ?>
                        </tbody>   
                      </table>      
                    </div>
                  </div>
              </div>          
          </div>
      </div>
      <script>
        $(document).ready(function(){
            $('#myTable').dataTable();
        });

          function preventsubmit() {
            event.preventDefault();
          };
          function getid(obj,value){
            var id = obj.value;
            document.getElementById("Delete_yes").value = id;
          }

        $('.openbtn').click(function() {
          $('.sidenav').toggleClass('active');
          $('.main').toggleClass('active');
        })
      </script>
      <!-- Show/hide CSV upload form -->
    <script>
    function formToggle(ID){
        var element = document.getElementById(ID);
        if(element.style.display === "none"){
            element.style.display = "block";
        }else{
            element.style.display = "none";
        }
    }
    </script>
    </body>
</html>