ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ

📁 ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ-🛒 PHP v7.4.33

Current Path: home/oshofree/public_html/chbluxuries.com/chb_data/

Name	Size	Permissions	Actions
📁 ..	-	0755	🗑️
📄 config.php	7.06 KB	0444	🗑️ ⬇️ ✏️
📄 error_log	13311.22 KB	0644	🗑️ ⬇️ ✏️

Editing: itemsdownload.php

<?php
include "../connect.php";

if(isset($_POST["ExportType"])) {
    $from = $_POST['from'];
    $to = $_POST['to'];

$sql_query = "SELECT r.item, SUM(r.quantity) as quantity, SUM(r.totalprice) as total FROM refreshments r INNER JOIN saloon_orders s ON s.id=r.orderid WHERE s.pay_status='paid' AND s.date BETWEEN '$from' AND '$to' GROUP BY r.item ORDER BY r.item ASC";

$resultset = mysqli_query($con, $sql_query) or die("database error:". mysqli_error($con));
    $tasks = array();
    while ($rows = mysqli_fetch_assoc($resultset)) {
    $tasks[] = $rows;
    }

$heading = array('Stock','Quantity Sold','Total Amount');
    $filename = "orishirishistocks" . $from . "-" . $to . ".xls";

header("Content-Type: application/vnd.ms-excel");
    header("Content-Disposition: attachment; filename=\"$filename\"");
    ExportFile($tasks, $heading);
}

📁 ＳＫＹＳＨＥＬＬ ＭＡＮＡＧＥＲ-🛒 PHP v7.4.33

Editing: itemsdownload.php

📁 ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ-🛒 PHP v7.4.33