Ghost Exploiter Team Official

/home/ramdevpcb/public_html/admin.ramdevpcb.com/

<?php
session_start();
	require_once 'include/db.php';
    error_reporting(0);

$sessionWatts = $_SESSION['Watts'];
    $sessioncolor = $_SESSION['ColorID'];
    $sessiondriver = $_SESSION['Driver'];
    // echo $sessionModelID;
?>
<!doctype html>
<html lang="en" dir="ltr">
	<head>
		
		<meta charset="UTF-8">
		<meta name='viewport' content='width=device-width, initial-scale=1.0, user-scalable=0'>
		<meta http-equiv="X-UA-Compatible" content="IE=edge">
		<meta name="description" content="Ramdev PCB Admin">
		<meta name="author" content="Ramdev PCB Admin">
		<meta name="keywords" content="Ramdev PCB">
		
		<link rel="shortcut icon" type="image/x-icon" href="assets/images/brand/favicon.ico" />
		
		<title>Stock Report </title>
		
		<link id="style" href="assets/plugins/bootstrap/css/bootstrap.min.css" rel="stylesheet" />
		
		<link href="assets/css/style.css" rel="stylesheet" />
		<link href="assets/css/dark-style.css" rel="stylesheet" />
		<link href="assets/css/transparent-style.css" rel="stylesheet">
		<link href="assets/css/skin-modes.css" rel="stylesheet" />
		
		<link href="assets/css/icons.css" rel="stylesheet" />
		
		<link id="theme" rel="stylesheet" type="text/css" media="all" href="assets/colors/color1.css" />
        <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
        <link rel="stylesheet" type="text/css" href="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.css" />
<link href="https://cdn.jsdelivr.net/npm/select2@4.1.0-rc.0/dist/css/select2.min.css" rel="stylesheet" />

<?php
                                            $sql1="SELECT * FROM ProductColors";
                                            $result1=mysqli_query($conn,$sql1);
                                            ?>

<div class="col-md-2">
                                                <label>Select Color</label>
                                                <select name="color2" id="color2"  style="padding:9px 0px; border-radius:6px;" onchange="update_watts2(this.value)">
                                                
                                                <option value=''<?php if($sessioncolor== '' ) {echo 'selected';}?>>All</option>
                                                <?php
                                                 while($row1=mysqli_fetch_array($result1))
                                                {
                                                    // $ModelID=$row1['Watts'];
                                                    $colorid=$row1['ColorID'];
                                                    $color=$row1['ColorName'];
   
                                                if($colorid ==$sessioncolor){
                                                echo '<option value="'.$colorid.'" selected>'.$color.'</option>';
                                                }else{
                                                    echo '<option value="'.$colorid.'" >'.$color.'</option>';}
                                                }
                                                ?>
                                                </select>
                                            </div>

<?php
                                            $sql1="SELECT * FROM `productdetails` where Driver!='' and is_deleted='0' group by Driver;";
                                            $result1=mysqli_query($conn,$sql1);
                                            ?>

<div class="col-md-2">
                                                <label>Select Driver</label>
                                                <select name="driver2" id="driver2"  style="padding:9px 0px; border-radius:6px;" onchange="update_watts3(this.value)">
                                                
                                                <option value=''<?php if($sessiondriver== '' ) {echo 'selected';}?>>All</option>
                                                <?php
                                                 while($row1=mysqli_fetch_array($result1))
                                                {
                                                    // $ModelID=$row1['Watts'];
                                                    // $colorid=$row1['ColorID'];
                                                    $driver=$row1['Driver'];
   
                                                if($driver ==$sessiondriver){
                                                echo '<option value="'.$driver.'" selected>'.$driver.'</option>';
                                                }else{
                                                    echo '<option value="'.$driver.'" >'.$driver.'</option>';}
                                                }
                                                ?>
                                                </select>
                                            </div>

</div>
                                   
											<div class="table-responsive">
                        
														<?php
                                                        if (!empty($_GET['date_range'])) {
                                                            $date_range = $_GET['date_range'];
                                                           
                                                            $date_range_parts = explode(" - ", $date_range);
                                                            $start_date = date('Y-m-d', strtotime($date_range_parts[0]));
                                                            $end_date = date('Y-m-d', strtotime($date_range_parts[1]));
                                     $query1 = "SELECT * FROM stockslog a,productdetails b, ProductColors c, BrandModel d WHERE a.ProductNumber=b.ProductNumber AND b.ModelID=d.ModelID AND c.ColorID=b.ProductColorID AND b.is_deleted=0  AND a.AddedDate BETWEEN '$start_date' and '$end_date 23:59:59' ";
                                                        }
                                                        else {
                                                           $query1 = "SELECT * FROM stockslog a,productdetails b, ProductColors c, BrandModel d WHERE a.ProductNumber=b.ProductNumber AND b.ModelID=d.ModelID AND c.ColorID=b.ProductColorID AND b.is_deleted=0 ORDER BY `a`.`StockAddedDate` DESC";
                                                        }
                                    
                                        if (!empty($sessionWatts)) {
                                            $query1 .= " AND b.Watts='$sessionWatts'";
                                        }
                                        if (!empty($sessiondriver)){
                                            $query1 .= " AND b.Driver='$sessiondriver'";
                                        }
                                        if (!empty($sessioncolor)){
                                            $query1 .= " AND a.ColorID='$sessioncolor'";
                                        }
                                    
                                    // echo $query1;
                                      
                                                        // $query1 = "SELECT * FROM stockslog a,productdetails b, ProductColors c, brandmodel d WHERE a.ProductNumber=b.ProductNumber AND b.ModelID=d.ModelID AND c.ColorID=b.ProductColorID AND b.is_deleted=0";
															$result = mysqli_query($conn, $query1) or die(mysqli_error($conn));
															$i = 1;
                                                            if(mysqli_affected_rows($conn))
                                                            {
                                                                
                                                                echo '<table id="stock" class="table table-bordered text-nowrap key-buttons border-bottom">';
                                                                        echo'<thead>';
                                                                        echo'<tr>';
                                                                        
                                                                        
                                                                      echo '<th>Sr No.</th>';
                                                                      echo '<th>Date</th>';
                                                                      echo '<th>Product Number</th>';
                                                                      echo '<th>Color</th>';
                                                                    //   echo '<th>Model</th>';
                                                                      echo '<th>Watts</th>';
                                                                      echo '<th>Driver</th>';
                                                                      echo '<th>stock</th>';
                                                                       
                                
                                                                
                                                                        echo '</tr>';
                                                                    echo '</thead>';
                                                                    echo '<tbody>';
                                                                    $counter = 0;
                                                                    while($row=mysqli_fetch_array($result))
                                                                    {
                                                                        
                                                                        $id=$row['id'];
                                                                           $date=$row['StockAddedDate'];
                                                                           $product=$row['ProductNumber'];
                                                                           $color=$row['ColorName'];
                                                                        //    $model=$row['Model'];
                                                                           $Watts=$row['Watts'];
                                                                           $Driver=$row['Driver'];
                                                                           $Stock=$row['Stock'];

echo'<td>'.++$counter.'</td>';  
                                                                            echo'<td>'.$date.'</td>';
                                                                            echo'<td>'.$product.'</td>';
                                                                            echo'<td>'.$color.'</td>';
                                                                            // echo'<td>'.$model.'</td>';
                                                                            echo'<td>'.$Watts.'</td>';
                                                                            echo'<td>'.$Driver.'</td>';
                                                                            echo'<td>'.$Stock.'</td>';
                                                                        
                                                                        echo'</tr>';
                                                                    }
                                                                    echo'</tbody>';
                                                                echo'</table>';
                                                            }
                                                            // mysqli_close($con);
                                                            ?>
                                                
											</div>
										</div>
									</div>
								</div>
							</div>
						</div>
						
					</div>
				</div>
				
			</div>
			
			<?php include('include/footer.php');?>
			
		</div>
		
		<a href="#top" id="back-to-top"><i class="fa fa-angle-up"></i></a>

var start = moment(<?php if(!empty($start_date)){ echo '"'.$start_date.'"'; }?>);
        var end = moment(<?php if(!empty($end_date)){  echo '"'.$end_date.'"' ;}?>);

function cb(start, end) {
            //$('#reportrange span').html(start.format('DD/MM/YYYY') + ' - ' + end.format('DD/MM/YYYY'));

// Update start based on selected range
            if (end.isSame(moment(), 'day')) {
                // If the selected range is "Today"
                start = moment().subtract(1, 'days');
            } else if (end.isSame(moment().subtract(29, 'days'), 'day')) {
                // If the selected range is "Last 30 Days"
                start = moment().subtract(29, 'days');
            } else if (end.isSame(moment().subtract(6, 'days'), 'day')) {
                // If the selected range is "Last 7 Days"
                start = moment().subtract(6, 'days');
            } else {
                // Custom range selection
                start = start.clone();
            }

// Update your code here with the adjusted start and end variables
            // ...

}

$('#reportrange').daterangepicker({
            startDate: start.format('YYYY/MM/DD') ,
            endDate: end.format('YYYY/MM/DD') ,
            ranges: {
                'Today': [moment(), moment()],
                'Yesterday': [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
                'Last 7 Days': [moment().subtract(6, 'days'), moment()],
                'Last 30 Days': [moment().subtract(29, 'days'), moment()],
                'This Month': [moment().startOf('month'), moment().endOf('month')],
                'Last Month': [
                    moment().subtract(1, 'month').startOf('month'),
                    moment().subtract(1, 'month').endOf('month')
                ]
            },
            locale: {
        format: "YYYY/MM/DD"
    }
        }, cb);

cb(start, end);
    });
</script>

<script src="assets/js/jquery.min.js"></script>
		
		<script src="assets/plugins/bootstrap/js/popper.min.js"></script>
		<script src="assets/plugins/bootstrap/js/bootstrap.min.js"></script>
		
		<script src="assets/js/jquery.sparkline.min.js"></script>
		
		<script src="assets/js/sticky.js"></script>
		
		<script src="assets/js/circle-progress.min.js"></script>
		
		
		<script src="assets/plugins/sidebar/sidebar.js"></script>
		
		<script src="assets/plugins/p-scroll/perfect-scrollbar.js"></script>
		<script src="assets/plugins/p-scroll/pscroll.js"></script>
		<script src="assets/plugins/p-scroll/pscroll-1.js"></script>
		
		<script src="assets/plugins/chart/Chart.bundle.js"></script>
		<script src="assets/plugins/chart/rounded-barchart.js"></script>
		<script src="assets/plugins/chart/utils.js"></script>
		
		<script src="assets/plugins/select2/select2.full.min.js"></script>
		
		<script src="assets/plugins/datatable/js/jquery.dataTables.min.js"></script>
		<script src="assets/plugins/datatable/js/dataTables.bootstrap5.js"></script>
		<script src="assets/plugins/datatable/js/dataTables.buttons.min.js"></script>
		<script src="assets/plugins/datatable/js/buttons.bootstrap5.min.js"></script>
		<script src="assets/plugins/datatable/js/jszip.min.js"></script>
		<script src="assets/plugins/datatable/pdfmake/pdfmake.min.js"></script>
		<script src="assets/plugins/datatable/pdfmake/vfs_fonts.js"></script>
		<script src="assets/plugins/datatable/js/buttons.html5.min.js"></script>
		<script src="assets/plugins/datatable/js/buttons.print.min.js"></script>
		<script src="assets/plugins/datatable/js/buttons.colVis.min.js"></script>
		<script src="assets/plugins/datatable/dataTables.responsive.min.js"></script>
		<script src="assets/plugins/datatable/responsive.bootstrap5.min.js"></script>
		<script src="assets/js/table-data.js"></script>
		
		<script src="assets/js/apexcharts.js"></script>
		<script src="assets/plugins/apexchart/irregular-data-series.js"></script>
		
		<script src="assets/plugins/charts-c3/d3.v5.min.js"></script>
		<script src="assets/plugins/charts-c3/c3-chart.js"></script>
		
		<script src="assets/js/charts.js"></script>
		
		<script src="assets/plugins/flot/jquery.flot.js"></script>
		<script src="assets/plugins/flot/jquery.flot.fillbetween.js"></script>
		<script src="assets/plugins/flot/chart.flot.sampledata.js"></script>
		<script src="assets/plugins/flot/dashboard.sampledata.js"></script>
		
		<script src="assets/plugins/jvectormap/jquery-jvectormap-2.0.2.min.js"></script>
		<script src="assets/plugins/jvectormap/jquery-jvectormap-world-mill-en.js"></script>
		
		<script src="assets/plugins/sidemenu/sidemenu.js"></script>
		
		<script src="assets/js/index1.js"></script>
		
		<script src="assets/js/themeColors.js"></script>
		
		<script src="assets/js/custom.js"></script>
        <script type="text/javascript" src="https://cdn.jsdelivr.net/momentjs/latest/moment.min.js"></script>
<script type="text/javascript" src="https://cdn.jsdelivr.net/npm/daterangepicker/daterangepicker.min.js"></script>

</script>
		
<script type="text/javascript">
    function update_watts2(value) {
        $.ajax({
            type: "POST",
            url: 'changesession.php', // change url as your
            data: 'color2=' + value,
            dataType: 'json',
            success: function (data) {
                
            }
        });
        window.location.reload()
    }

</script>

</script>
	</body>
</html>

Nama File / Folder	Size	Action
.well-known	--	NONE
Data_	--	NONE
assets	--	NONE
cgi-bin	--	NONE
include	--	NONE
uploads	--	NONE
.htaccess	0.274KB	Hapus Edit Rename
8Products.php	15.674KB	Hapus Edit Rename
MonthlyProducts.php	15.686KB	Hapus Edit Rename
add-brand.php	27.782KB	Hapus Edit Rename
b-bclients1.php	9.329KB	Hapus Edit Rename
category.php	13.583KB	Hapus Edit Rename
color.php	11.327KB	Hapus Edit Rename
company.php	14.712KB	Hapus Edit Rename
delete_product_pdf.php	0.618KB	Hapus Edit Rename
discount-b2b.php	9.862KB	Hapus Edit Rename
discount-b2c.php	8.333KB	Hapus Edit Rename
discount-list.php	10.272KB	Hapus Edit Rename
generate-invoice-server.php	3.183KB	Hapus Edit Rename
invoice-list.php	10.6KB	Hapus Edit Rename
invoice22222.php	31.864KB	Hapus Edit Rename
invoicenew1.php	17.683KB	Hapus Edit Rename
offline-order-add.php	2.254KB	Hapus Edit Rename
offline-order-delete.php	0.338KB	Hapus Edit Rename
offline-order-server.php	1.695KB	Hapus Edit Rename
offline-order.php	30.544KB	Hapus Edit Rename
order-details.php	14.237KB	Hapus Edit Rename
order-item-details.php	7.875KB	Hapus Edit Rename
paidd.png	27.518KB	Hapus Edit Rename
product-list.php	8.904KB	Hapus Edit Rename
productreport.php	28.885KB	Hapus Edit Rename
save_image_order.php	1.284KB	Hapus Edit Rename
sms.js	2.603KB	Hapus Edit Rename
stockreport.php	24.525KB	Hapus Edit Rename
subcategory.php	13.671KB	Hapus Edit Rename
update-order-status.php	2.562KB	Hapus Edit Rename
update-user-role.php	0.306KB	Hapus Edit Rename
vijayinvoice.php	17.683KB	Hapus Edit Rename