<?php
date_default_timezone_set('Asia/Kolkata');
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
include '../../../include/conf.php';
$start_date = date('Y-m-d', strtotime($_POST['start_date']));
$end_date = date('Y-m-d', strtotime($_POST['end_date']));


require '../vendor/autoload.php'; // Import the necessary classes from the library

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
set_time_limit(0);
$filename = Time().".xlsx";
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$spreadsheet
    ->getActiveSheet()
    ->getStyle('A1')
    ->getFill()
    ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
    ->getStartColor()
    ->setARGB('FFFF00');

$spreadsheet
    ->getActiveSheet()
    ->getStyle('B1')
    ->getFill()
    ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
    ->getStartColor()
    ->setARGB('FFFF00');

$spreadsheet
    ->getActiveSheet()
    ->getStyle('C1')
    ->getFill()
    ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
    ->getStartColor()
    ->setARGB('FFFF00');

$spreadsheet
    ->getActiveSheet()
    ->getStyle('D1')
    ->getFill()
    ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
    ->getStartColor()
    ->setARGB('FFFF00');

$spreadsheet
    ->getActiveSheet()
    ->getStyle('E1')
    ->getFill()
    ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
    ->getStartColor()
    ->setARGB('FFFF00');

$spreadsheet
    ->getActiveSheet()
    ->getStyle('F1')
    ->getFill()
    ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
    ->getStartColor()
    ->setARGB('FFFF00');
$spreadsheet
    ->getActiveSheet()
    ->getStyle('G1')
    ->getFill()
    ->setFillType(\PhpOffice\PhpSpreadsheet\Style\Fill::FILL_SOLID)
    ->getStartColor()
    ->setARGB('FFFF00');


$k=2;
$x=1;
$sheet->setCellValue('A1', 'S.No.');
$sheet->setCellValue('B1', 'Product Name');
$sheet->setCellValue('C1', 'Sales Date');
$sheet->setCellValue('D1', 'Old Stock');
$sheet->setCellValue('E1', 'New Stock');
$sheet->setCellValue('F1', 'Sales');
$sheet->setCellValue('G1', 'Current Stock');


$get_prod = "SELECT * from shop_product where (product_id!='173' AND product_id!='172' AND product_id!='174' AND product_id!='175' AND product_id!='176' AND product_id!='177' AND product_id!='178' ) and v_s='0'  order by name asc";
	$get_prod_det = mysqli_query($conn, $get_prod );
$x=2;
$y = 0;
while ($get_prod_data = mysqli_fetch_array($get_prod_det, MYSQLI_ASSOC)){
$y=$y+1;
$get_stock_sum = mysqli_query($conn, "select (sum(qty)+ sum(free_qty)) as total from stock_log_entry where product_id ='".$get_prod_data['product_id']."' and DATE(created_at)='$start_date'");
	$get_stock_total = mysqli_fetch_array($get_stock_sum, MYSQLI_ASSOC);
	if($get_stock_total['total'] == ''){
		$today_sales = 0;
	}else{
	$today_sales = $get_stock_total['total'];	
	}
	
$get_stock_da = mysqli_query($conn, "select * from stock_log_entry where product_id ='".$get_prod_data['product_id']."' and DATE(created_at)='$start_date' order by id desc limit 1");
	$set_stock_da = mysqli_fetch_array($get_stock_da, MYSQLI_ASSOC);
	
$get_update_sto = mysqli_query($conn, "select * from tbl_india_update_stock where id ='".$set_stock_da['stock_entry_id']."'");
	$set_update_sto = mysqli_fetch_array($get_update_sto, MYSQLI_ASSOC);
		if($set_update_sto['old_stock'] == ''){
		$old_stock = 0;
	}else{
	$old_stock = $set_update_sto['old_stock'];	
	}
		if($set_update_sto['new_stock'] == ''){
		$new_stock = 0;
	}else{
	$new_stock = $set_update_sto['new_stock'];	
	}
	if($set_update_sto['current_stock'] == ''){
		$current_stock = 0;
	}else{
	$current_stock = $set_update_sto['current_stock'];	
	}
   $sheet->setCellValue("A$x", $y);
    $sheet->setCellValue("B$x", $get_prod_data['name']);
	 $sheet->setCellValue("C$x", $start_date);
	 $sheet->setCellValue("D$x", $old_stock);
	 $sheet->setCellValue("E$x", $new_stock);
	 $sheet->setCellValue("F$x", $today_sales);
	 $sheet->setCellValue("G$x", $current_stock);
	$x++;
}


$writer = new Xlsx($spreadsheet);
$writer->save("../stock_report/$filename");
$file_path = "./stock_report/$filename";

echo $file_path;
sleep(5);
?>