Gecko [ italicatiles.com ]

Name	Size	Permission
ajax	[ DIR ]	drwxr-xr-x
app-assets	[ DIR ]	drwxr-xr-x
include	[ DIR ]	drwxr-xr-x
module	[ DIR ]	drwxr-xr-x
PhpXlsxGenerator.php	54.22 KB	-rw-r--r--
ad_contact_details.php	14.65 KB	-rw-r--r--
add_360_category.php	4.56 KB	-rw-r--r--
add_360_products.php	7.11 KB	-rw-r--r--
add_application.php	5.06 KB	-rw-r--r--
add_blogs.php	8.72 KB	-rw-r--r--
add_brands.php	6.56 KB	-rw-r--r--
add_catalogues.php	7.02 KB	-rw-r--r--
add_collections.php	12.59 KB	-rw-r--r--
add_division.php	8.29 KB	-rw-r--r--
add_effects.php	4.95 KB	-rw-r--r--
add_events.php	10.41 KB	-rw-r--r--
add_gallery.php	8.79 KB	-rw-r--r--
add_main_event.php	8.63 KB	-rw-r--r--
add_multiple_products.php	10.54 KB	-rw-r--r--
add_products.php	28.81 KB	-rw-r--r--
add_series.php	7.45 KB	-rw-r--r--
add_thickness.php	6.63 KB	-rw-r--r--
all_360_category.php	9.63 KB	-rw-r--r--
all_360_products.php	7.63 KB	-rw-r--r--
all_application.php	10.43 KB	-rw-r--r--
all_blogs.php	10.91 KB	-rw-r--r--
all_brands.php	7.07 KB	-rw-r--r--
all_catalogues.php	10.05 KB	-rw-r--r--
all_collections.php	7.01 KB	-rw-r--r--
all_division.php	7.38 KB	-rw-r--r--
all_effects.php	10.26 KB	-rw-r--r--
all_events.php	10.29 KB	-rw-r--r--
all_gallery.php	10.48 KB	-rw-r--r--
all_main_events.php	10 KB	-rw-r--r--
all_products.php	18.18 KB	-rw-r--r--
all_products_new.php	13.4 KB	-rw-r--r--
all_series.php	10.23 KB	-rw-r--r--
all_sub_collections.php	7.4 KB	-rw-r--r--
all_sub_division.php	7.76 KB	-rw-r--r--
all_thickness.php	7.64 KB	-rw-r--r--
divisions.php	486 B	-rw-r--r--
edit_360_category.php	5.04 KB	-rw-r--r--
edit_360_products.php	7.9 KB	-rw-r--r--
edit_application.php	5.88 KB	-rw-r--r--
edit_blogs.php	9.46 KB	-rw-r--r--
edit_brands.php	7.4 KB	-rw-r--r--
edit_catalogue.php	7.95 KB	-rw-r--r--
edit_collections.php	16.95 KB	-rw-r--r--
edit_gallery.php	8.85 KB	-rw-r--r--
edit_main_events.php	9.79 KB	-rw-r--r--
edit_product.php	35.18 KB	-rw-r--r--
edit_series.php	8.98 KB	-rw-r--r--
edit_sub_collections.php	17.26 KB	-rw-r--r--
edit_sub_event.php	10.73 KB	-rw-r--r--
edit_thickness.php	7.58 KB	-rw-r--r--
export_excel.php	4.21 KB	-rw-r--r--
functions.php	523 B	-rw-r--r--
index.php	3.77 KB	-rw-r--r--
login.php	6.83 KB	-rw-r--r--
logout.php	92 B	-rw-r--r--

Code Editor : all_products_new.php

<?php
    include("include/header.php");
?>
<style type="text/css">
  .dataTables_filter, .dataTables_info { display: none; }
</style>
      <div class="main-panel">
        
        <div class="main-content">
          <div class="content-wrapper">
<div class="row">
  <div class="col-12">
    <div class="content-header">All Products</div>
    <p class="content-sub-header"> </p>

</div>
</div>
<section id="extended">

<div class="row">
    <div class="col-sm-12">
      <div class="card">
         <?php if($_SERVER['QUERY_STRING'] == "success")
          {
              echo '<div class="alert alert-primary mb-2" role="alert"> <strong>Deleted! </strong>Your selected product is deleted.</div>';

}
          if($_SERVER['QUERY_STRING'] == "del")
          {
              echo '<div class="alert alert-warning mb-2" role="alert"> <strong>Warning! </strong>Please check your action. </div>';
          }
          ?>
        
          <div class="card-content">
            <div class="card-body table-responsive">

<div class="form-actions" style="float: right;">
              <button type="button" id="delete_multiple" name="delete_multiple" class="btn btn-raised btn-raised btn-warning mr-1">
                <i class="ft-x"></i> Delete Multiple
              </button>
            </div>

<th>Product Name (ID)</th>
                    <th>Collection (ID)</th>
                    <th>Size (ID)</th>
                    <th>Finish (ID)</th>
                    <th>Image</th>
                    
                    <th>Actions</th>
                    <th>Check</th>
                  </tr>
                </thead>
                <tbody class="">

<?php

$count=1;
                        $sel_query="SELECT * from tbl_product where collection_id not in ('62','63')";
                        $result = mysqli_query($conn,$sel_query);

while($row= mysqli_fetch_assoc($result)) {

$sel_collection="SELECT * from tbl_collection_old where `collection_id` = '".$row['collection_id']."'";
                          $collection = mysqli_query($conn,$sel_collection);
                          $collection_name = mysqli_fetch_assoc($collection);

$sel_size="SELECT * from tbl_collection_old where `collection_id` = '".$row['size_id']."'";
                          $size = mysqli_query($conn,$sel_size);
                          $size_name = mysqli_fetch_assoc($size);

$sel_finish="SELECT * from tbl_collection_old where `collection_id` = '".$row['finish_id']."'";
                          $finish = mysqli_query($conn,$sel_finish);
                          $finish_name = mysqli_fetch_assoc($finish);

<?php if ($row['finish_id'] == 0) { ?>
                        
                      <td> 0 </td>
                      <?php } else { ?>

<?php } ?>

<?php
                     if ($row['prod_image2'] != "" || $row['prod_image2'] == '0') { ?>

<td><img src="../uploads/products/<?= $row['prod_image2']; ?>" width="50px" height="50px"></td>

<?php } else { ?>

<?php } ?>
                    <!-- <?php
                     if ($row['random_image'] != "" || $row['random_image'] == '0') { ?>

<td>
                           <?php 
                              $images = explode(',',$row['random_image']);

for($i = 0; $i < count($images); $i++){ ?>

<?php } ?>
                        </td>

<?php } else { ?>

<?php } ?> -->

<td>
                      <a href="edit_product.php?id=<?php echo $row['prod_id']; ?>" id="<?php echo $row['prod_id']; ?>" target="_blank" class="success p-0 edit_collection" title="edit" >
                        <i class="ft-edit-2 font-medium-3 mr-2"></i>
                      </a>
                      <a class="danger p-0 delete_collection" data-original-title="" title="delete" id="<?php echo $row['prod_id']; ?>">
                        <i class="ft-x font-medium-3 mr-2"></i>
                      </a>
                    </td>
                      <td>
                      <div class="custom-control custom-checkbox m-0">
                        <input type="checkbox" class="custom-control-input" id="item<?= $row['prod_id']; ?>" value="<?= $row['prod_id']; ?>">
                        <label class="custom-control-label" for="item<?= $row['prod_id']; ?>"></label>
                      </div>
                    </td>
                  </tr>

<?php $count++; } ?>

// For Multiple Delete Starts
                        $('#delete_multiple').click(function(){

var post_arr = [];

// Get checked checkboxes
                        $('#recordsTable input[type=checkbox]').each(function() {
                          if (jQuery(this).is(":checked")) {
                            var id = this.id;
                            var splitid = id.split('item');
                            var postid = splitid[1];

post_arr.push(postid);

}
                        });

if(post_arr.length > 0){

// For Single Delete Starts

$(".delete_collection").click(function(){
                      $("#overLay").show();
                      var single_id = $(this).attr("id");

var isDelete = confirm("Do you really want to delete this record?");

if (isDelete == true) {
                            $.ajax({
                                  url: 'ajax/delete_product.php',
                                  type:'post',
                                  data:{"single_id":single_id},
                                  success: function(res)
                                  {
                                       $("#overLay").hide();
                                      location.href = "all_products.php?success"
                                  }
                              });
                          }
                      });

// For Single Delete Ends

// For Update
                      $(".edit_collection").click(function(){
                          var id= $(this).attr("id");
                          window.location.href = "edit_product.php?id="+id;
                      });
                          $(document).ready( function() {
                              $('#example').dataTable( {
                                  "iDisplayLength": 25
                              });
                          });
                  </script>

</tbody>
              </table>
            </div>
          </div>
        </div>
      </div>
    </div>
  </div>
</section>

</div>
        </div>
        
<?php
    include("include/footer.php");
?>

$('#brand_name').on('change',function(){

function filter_data1() {

$('.filter_data');
                var action = 'fetch_data';
                var brand_name = $('#brand_name').val();

$.ajax({
                    url: "ajax/aj_search_result.php",
                    method: "POST",
                    data: {
                        brand_name: brand_name
                    },
                    success: function(data) {
                        $('.filter_data').html(data);
                    }
                });
            }

function get_filter(class_name) {
                var filter = [];
                $('.' + class_name + ':selected').each(function() {
                    filter.push($(this).val());
                });
                return filter;
            }

// $('.filter_all1').on('click',function(){
            //     filter_data1();
            // });
            filter_data1();
   });

// Search From Collecion

$('#search_by_collection').on('change',function(){

function filter_data2() {

$('.filter_data');
                var action = 'fetch_data';
                var search_by_collection = $('#search_by_collection').val();

alert(search_by_collection);

$.ajax({
                    url: "ajax/aj_search_result.php",
                    method: "POST",
                    data: {
                        search_by_collection: search_by_collection
                    },
                    success: function(data) {
                        $('.filter_data').html(data);
                    }
                });
            }

filter_data2();
    });

$('#collection_name').on('keyup change',function(){

function filter_data3() {

$('.filter_data');
                var action = 'fetch_data';
                var collection_name = $('#collection_name').val();

$.ajax({
                    url: "ajax/aj_search_result.php",
                    method: "POST",
                    data: {
                        collection_name: collection_name
                    },
                    success: function(data) {
                        $('.filter_data').html(data);
                    }
                });
            }

// $('.filter_all1').on('click',function(){
            //     filter_data3();
            // });
            filter_data3();
   });

// $("#brand_name").change(function() {

//      var brand_id = $(this).val();
   //      if(brand_id != "") {
   //        $.ajax({
   //          url:"ajax/aj_get_collection.php",
   //          data:{brand_id:brand_id},
   //          type:'POST',
   //          success:function(response) {
   //            var resp = $.trim(response);
   //            $("#search_by_collection").html(resp);
   //          }
   //        });
   //      } else {
   //        $("#search_by_collection").html("<option value=''>--select Collection--</option>");
   //      }
   //    });
</script>

${this.title}

Code Editor : all_products_new.php