real_escape_string($_GET['from_date']); $to_date = $conn->real_escape_string($_GET['to_date']); $search_conditions[] = "DATE(date) BETWEEN '$from_date' AND '$to_date'"; } elseif (!empty($_GET['from_date'])) { $from_date = $conn->real_escape_string($_GET['from_date']); $search_conditions[] = "DATE(date) >= '$from_date'"; } elseif (!empty($_GET['to_date'])) { $to_date = $conn->real_escape_string($_GET['to_date']); $search_conditions[] = "DATE(date) <= '$to_date'"; } // Handle challan_no if (!empty($_GET['challan_no'])) { $challan_no = $conn->real_escape_string($_GET['challan_no']); $search_conditions[] = "challan_no LIKE '%$challan_no%'"; } if (!empty($search_conditions)) { $where_sql = " WHERE " . implode(" AND ", $search_conditions); } $query = "SELECT * FROM `road_challans` $where_sql ORDER BY `id` DESC"; $result = $conn->query($query); ?>

Transit Loss Report

num_rows > 0) { $index = 1; while ($row = $result->fetch_assoc()) { $qty = is_numeric($row['quantity']) ? (float)$row['quantity'] : 0; $qty_billed = is_numeric($row['quantity_billed']) ? (float)$row['quantity_billed'] : 0; $difference = $qty - $qty_billed; echo ""; $index++; } } else { echo ''; } ?>

Select All	#	Seller Company	Purchaser Company	Challan No.	Challan Date	Quantity Dispatch	Quantity Unloaded	Difference (Kgs)	Action
	{$index}	{$row['consignorName']}	{$row['name']}	{$row['challan_no']}	{$row['date']}	{$row['quantity']}	{$row['quantity_billed']}	{$difference}	View
No records found.