1#@!#!123s

file_get_contents 1#@!#!123s
: / proc / self / root / home / ujaneybc / jogiagroup.com / admin /
Filename : product-list2.php
back
<?php include'loginQuery/session_start.php';
include'dbc.php';
$pageTitle="List of Products";
$pageName="Product List";
$tableName="tbl_product";
$addPageUrl="product.php";
$deleteMode="deleteProduct";
?>
<!DOCTYPE html>
<html>
    <head>
        <meta charset="utf-8">
            <meta content="width=device-width, initial-scale=1.0" name="viewport">
                <meta content="IE=edge" http-equiv="X-UA-Compatible">
                    <!-- Page title -->
                    <title>
                        <?php echo $pageTitle;?>
                    </title>
                    <!-- Place favicon.ico and apple-touch-icon.png in the root directory -->
                    <!--<link rel="shortcut icon" type="image/ico" href="favicon.ico" />-->
                    <!-- Vendor styles -->
                    <?php include'include/header-file.php';?>
                    <!--select feild css-->                    
                    <link rel="stylesheet" href="vendor/select2-3.5.2/select2.css" />
                    <link rel="stylesheet" href="vendor/select2-bootstrap/select2-bootstrap.css" />
                    <link rel="stylesheet" href="vendor/bootstrap-touchspin/dist/jquery.bootstrap-touchspin.min.css" />
                    
                         <?php include'message.php';?>


                </meta>
            </meta>
        </meta>
        <style>
        .small-header .panel-body h2 {
        margin-top:3px;
        }
        .hbreadcrumb {
        margin-top:0;
        }
        
        </style>
    </head>
    
    <body>
        <!-- ================ Model Window =========================== -->
<div class="modal fade" id="myModal" tabindex="-1" role="dialog" aria-hidden="true">
  <div class="modal-dialog">
    <div class="modal-content">
      <div class="color-line"></div>
        <div class="modal-header text-center">
          <h4 class="modal-title">Add Variant </h4>
            
        </div>
          <div class="modal-body">
            
              <input type="hidden" name="action" value="directOrderPlace">
                <div class="form-group row">
                  <div class="col-xs-12 " id="colormode">
                  </div>
                </div>
                <div class="form-group row">
                    <div class="col-xs-12 col-xs-4">
                        <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                    </div>
                    <div class="col-xs-12 col-xs-4">
                        <a href="" id="setvarienturl" class="btn btn-primary">Add Variant</a>
                    </div>
                    <div class="col-xs-12 col-xs-4">
                        <a href="" id="setvarienturl" class="btn btn-primary">Add New</a>
                    </div>
                </div>
                
                    
              </div>
          </div>
        
        
        </form>
      </div>
    </div>
  </div>
</div>
<!-- ========== Model Window ============= -->

        <!-- Simple splash screen-->
       
        <!--[if lt IE 7]>
<p class="alert alert-danger">You are using an <strong>outdated</strong> browser. Please <a href="http://browsehappy.com/">upgrade your browser</a> to improve your experience.</p>
<![endif]-->
        <!-- Header -->
        <?php include'include/header.php';?>
        <!-- Header End-->

        <!-- Navigation -->
        <?php include'include/side-menu.php';?>
        <!-- Navigation -->
        
        <!-- Main Wrapper -->
        <div id="wrapper">
<!----------------start top normal header--------------------->
    <div class="small-header">
        <div class="hpanel">
            <div class="panel-body">
                <div id="hbreadcrumb" class="pull-right">
                    <ol class="hbreadcrumb ">
                        <li><a class="btn btn-danger" href="<?php echo $addPageUrl?>"><strong>Add New Product</strong></a></li>
                        
                    </ol>
                </div>
                <h2 class="font-light m-b-xs">
               <?php echo $pageName;?>
               
            </h2>
            <small><?php echo $pageTitle;?></small>
            </div>
        </div>
    </div>
<!----------------end top normal header--------------------->        

<!--model window-->

<!--model window-->       
        
            <div class="content ">
                <div class="row">
                    <div class="col-lg-12">
                        <div class="hpanel">
                            <div class="panel-heading">
                                <div class="panel-tools">
                                    <!--<a class="showhide">
                                        <i class="fa fa-chevron-up">
                                        </i>
                                    </a>
                                    <a class="closebox">
                                        <i class="fa fa-times">
                                        </i>
                                    </a>-->
                                </div>
                                
                            </div>
                            <div class="panel-body">
                            
                            <!---------------------------
                            
                        <br>
                        <div class="panel-body">
 <!------------------------------------------------>     
  <?php 
  // SELECT p.id, p.name,p.mrp,p.sale_price,p.color_name,p.size_id,p.variant_code,p.category_id,p.sub_category_id,p.thumb1 , (SELECT count(*) FROM tbl_product WHERE variant_code=p.variant_code) as total_product  FROM tbl_product p where variant_status='p'

        $queryString="";
       $typeString="";
       if(isset($_GET['search'])){
            $queryString.="";
       }else{
            $queryString.="   ";
       }
       
       ?>
       
      
       <!--<input type="hidden" id="getbackurl" value="<?php //echo $finalBackURL;?>">-->
       <input type="hidden" id="getquerystring" value="<?php echo $queryString;?>">
 
 <style type="text/css">
 .getstatus{ margin:10px; cursor:pointer}
  .l{ margin-right:10px; cursor:pointer}
 </style>    
 <div style="float:left">
 
 </div>
 <?php  
$limit = 50;  
if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; };  
$start_from = ($page-1) * $limit;  
//======================================                
$rs_result = mysqli_query($conn,"SELECT COUNT(id) FROM  $tableName $queryString ") or die(mysqli_error($conn));  
$row = mysqli_fetch_row($rs_result);  
$total_records = $row[0];  
echo  " Total Record ".$total_records2 = $row[0];  
$total_pages = ceil($total_records / $limit);  
$pagLink = "<nav style='float:right'><ul class='pagination'>";  
for ($i=1; $i<=$total_pages; $i++) {  
             $pagLink .= "<li><a href='tbl_product.php?page=".$i."'>".$i."</a></li>";  
};  
echo $pagLink . "</ul></nav>";  
?>        

<?php 
$sql=mysqli_query($conn,"select * from tbl_department")or die(mysqli_error($conn));
while($row=mysqli_fetch_assoc($sql)){
    $departmentNameAry[$row['id']]=$row['name'];
}

$sql=mysqli_query($conn,"select * from tbl_category")or die(mysqli_error($conn));
while($row2=mysqli_fetch_assoc($sql)){
    $categoryAry2[$row2['id']] =$row2['name'];
    $departmentAry[$row2['id']] = $row2['department_id'];;
    
}
?>

<div class="clearfix"></div>    
    
   <div id="showrecord">                                  
    
                    <table cellpadding="1" cellspacing="1" class="table table-bordered table-striped">
                    <thead>
                    <tr>
                        <th width="30">#</th>
                        <th  width="80">Department</th>
                        <th  width="80">Category</th>
                        <th width="80">Name</th>
                        <th width="50">Price</th>                       
                        <th width="80">Image 1</th>                     
                        <th width="80">Control</th>
                    </tr>
                    </thead>
                    <tbody>
                   <?php  
                   $i=1;
                   // echo "SELECT p.id, p.name,p.mrp,p.sale_price,p.color_name,p.size_id,p.variant_code,p.category_id,p.sub_category_id,p.thumb1 , (SELECT count(*) FROM tbl_product WHERE variant_code=p.variant_code) as total_product  FROM $tableName $queryString ORDER BY id desc LIMIT $start_from, $limit";
                   $sql=mysqli_query($conn,"SELECT *   FROM $tableName $queryString ORDER BY id desc LIMIT $start_from, $limit")or die(mysqli_error($conn));
                while($row=mysqli_fetch_assoc($sql))
                {
                   extract($row)
                ?>
                    <tr>
                        <td><?php echo $i++;?></td>
                        <td><?php echo $departmentNameAry[$departmentAry[$category_id]];?></td> 
                        <td><?php echo $categoryAry2[$category_id];?></td>                       
                        <td>
                            <?php echo $name;?><br>
                            <!-- data-target="#myModal" data-toggle="modal" addvarient-->
                            
                        </td>                        

                        
                         <td>
                            <a class="btn btn-primary" href="price.php?pid=<?php echo $id;?>"> 
                                Add New Price
                            </a><br>
                            <?php //echo $sale_price;?></td>
                        <td><img height="50" width="50" src="../media/product/thumb/<?php echo $thumb1;?>"></td>                       
                        
                       <td style="position:relative">   
                       <a class="dropdown-toggle" href="#" data-toggle="dropdown"><strong>Action</strong></a>
                            <ul class="dropdown-menu animated flipInX m-t-xs" role="menu" style="top:0;">
                                <li><a href="<?php echo $addPageUrl ?>?id=<?php echo $id;?>"><i class="fa fa-pencil"> </i> Edit</a></li>
                                <li><a class="demo3" path="dataQuery/process.php?action2=<?php echo $deleteMode ?>&id=<?php echo $id?>" ><i class="fa fa-trash"> </i> Remove</a></li>
                                <li class="divider"></li>
                                <li><a ><i class="fa "> </i> Cancel</a></li>
                            </ul>
                    </td>
                    </tr>
                    <?php }?>
                    </tbody>
                </table>
                
 
                            </div>
                            
                            <?php  echo $pagLink . "<ul></ul>";  ?>  
                            
                            
                        </div>
                    </div>
                </div>
            </div>
            
            <!-- Footer-->
         



 <?php include'include/footer-file.php';?>

<!--select feild css-->                    
<script src="vendor/bootstrap-touchspin/dist/jquery.bootstrap-touchspin.min.js"></script>
<script src="vendor/select2-3.5.2/select2.min.js"></script>

 






<!-- App scripts -->


    </body>
</html>
<link rel="stylesheet" href="vendor/sweetalert/lib/sweet-alert.css" />
<script src="vendor/sweetalert/lib/sweet-alert.min.js"></script>

    <script>

   $(document).on('click','.demo3',function(){
        var path=$(this).attr('path');

            swal({
                        title: "Are you sure?",
                        text: "Your will not be able to recover this imaginary file!",
                        type: "warning",
                        showCancelButton: true,
                        confirmButtonColor: "#DD6B55",
                        confirmButtonText: "Yes, delete it!"
                    },
                    function () {
                        window.location.href=path
                    });
    });

</script>

<script type="text/javascript">
//======================= add name start ==================================*/

//======================= add name end ==================================*/
$(document).on('click','.page-link',function(){
    var pageID=$(this).attr("pageid");
    var status=$(this).attr("pageid2");
    var getbackurl=$("#getbackurl").val();
    
    $("#showrecord").html('<center><i  class="fa fa-spinner fa-spin" aria-hidden="true"></i></center>');
    var cid= $("#applicationid").val();
    var getquerystring= $("#getquerystring").val();

        $.ajax({
            type: "POST",
            url: "function/getProductPageList.php",
            data: "pageID="+ pageID+"&getquerystring="+getquerystring,
            success: function(html){

            $("#showrecord").html(html);
        }
    });
    return false;
});
</script>

<!--<script type="text/javascript" charset="utf8" src="http://ajax.aspnetcdn.com/ajax/jQuery/jquery-2.0.3.js"></script>-->


<script type="text/javascript">

$(document).ready(function(){
$('.pagination').pagination({
        items: <?php echo $total_records;?>,
        itemsOnPage: <?php echo $limit;?>,
        cssStyle: 'light-theme',
        currentPage : <?php echo $page;?>,
        hrefTextPrefix : 'brands-list.php?page='
    });
    });
</script>
<link rel="stylesheet" href="dist/simplePagination.css" />
<script src="dist/jquery.simplePagination.js"></script>
<!-- <script src="js/custum.js"></script> -->

<script>

    $(function(){

        

        $("#form_2").validate({
            rules: {
                name: {
                    required: true,
                    minlength: 3
                },
                username: {
                    required: true,
                    minlength: 5
                },
                url: {
                    required: true,
                    url: true
                },
                number: {
                    required: true,
                    number: true
                },
                last_name: {
                    required: true,
                    minlength: 6
                }
            },
            messages: {
                number: {
                    required: "(Please enter your phone number)",
                    number: "(Please enter valid phone number)"
                },
                last_name: {
                    required: "This is custom message for required",
                    minlength: "This is custom message for min length"
                }
            },
            submitHandler: function(form) {
                form.submit();
            },
            errorPlacement: function(error, element) {
                $( element )
                        .closest( "form" )
                        .find( "label[for='" + element.attr( "id" ) + "']" )
                        .append( error );
            },
            errorElement: "span",
        });


    });
</script>
 <script>

        $(function(){

            $('#datepicker').datepicker();
            $("#datepicker").on("changeDate", function(event) {
                $("#my_hidden_input").val(
                        $("#datepicker").datepicker('getFormattedDate')
                )
            });

            $('#datapicker2').datepicker();
            $('.input-group.date').datepicker({ });
            $('.input-daterange').datepicker({ });

            $("#demo1").TouchSpin({
                min: 0,
                max: 100,
                step: 0.1,
                decimals: 2,
                boostat: 5,
                maxboostedstep: 10,
            });

            $("#demo2").TouchSpin({
                verticalbuttons: true
            });

            $("#demo3").TouchSpin({
                postfix: '%'
            });

            $("#demo4").TouchSpin({
                postfix: "a button",
                postfix_extraclass: "btn btn-default"
            });

            $(".js-source-states").select2();
            $(".js-source-states-2").select2();

            //turn to inline mode
            $.fn.editable.defaults.mode = 'inline';

            //defaults
            $.fn.editable.defaults.url = '#';

            //editables
            $('#username').editable({
                url: '#',
                type: 'text',
                pk: 1,
                name: 'username',
                title: 'Enter username'
            });

            $('#firstname').editable({
                validate: function(value) {
                    if($.trim(value) == '') return 'This field is required';
                }
            });

            $('#sex').editable({
                prepend: "not selected",
                source: [
                    {value: 1, text: 'Male'},
                    {value: 2, text: 'Female'}
                ],
                display: function(value, sourceData) {
                    var colors = {"": "gray", 1: "green", 2: "blue"},
                            elem = $.grep(sourceData, function(o){return o.value == value;});

                    if(elem.length) {
                        $(this).text(elem[0].text).css("color", colors[value]);
                    } else {
                        $(this).empty();
                    }
                }
            });

            $('#dob').editable();

            $('#event').editable({
                placement: 'right',
                combodate: {
                    firstItem: 'name'
                }
            });

            $('#comments').editable({
                showbuttons: 'bottom'
            });

            $('#fruits').editable({
                pk: 1,
                limit: 3,
                source: [
                    {value: 1, text: 'banana'},
                    {value: 2, text: 'peach'},
                    {value: 3, text: 'apple'},
                    {value: 4, text: 'watermelon'},
                    {value: 5, text: 'orange'}
                ]
            });

            $('#user .editable').on('hidden', function(e, reason){
                if(reason === 'save' || reason === 'nochange') {
                    var $next = $(this).closest('tr').next().find('.editable');
                    if($('#autoopen').is(':checked')) {
                        setTimeout(function() {
                            $next.editable('show');
                        }, 300);
                    } else {
                        $next.focus();
                    }
                }
            });

            // ClockPicker
            $('.clockpicker').clockpicker({autoclose: true});

            // DateTimePicker
            $('#datetimepicker1').datetimepicker();

        });

    </script>