<?php error_reporting(0);
require("../includes/config.php");
include("../includes/validate_data.php"); session_start();
if(isset($_SESSION['admin_login'])) {
$error = "";
$querySelectRetailer = "SELECT *,area.area_id AS area_id FROM retailer,area WHERE retailer.area_id = area.area_id";
$resultSelectRetailer = mysqli_query($con,$querySelectRetailer); if($_SERVER['REQUEST_METHOD']
== "POST") {
if(isset($_POST['cmbFilter'])) { if(!empty($_POST['txtInvoiceId']))
{
$result = validate_number($_POST['txtInvoiceId']); if($result
== 1) {
$invoice_id = $_POST['txtInvoiceId'];
$query_selectInvoice = "SELECT * FROM invoice,retailer,area WHERE invoice.retailer_id=retailer.retailer_id AND
retailer.area_id=area.area_id AND invoice_id='$invoice_id'";
$result_selectInvoice = mysqli_query($con,$query_selectInvoice); $row_selectInvoice
= mysqli_fetch_array($result_selectInvoice); if(empty($row_selectInvoice)){
$error = "* No invoice was found with this ID";
} else
{
mysqli_data_seek($result_selectInvoice,0);
} }
else {
$error = "* Invalid ID";
} }
else if(!empty($_POST['txtOrderId'])) {
$result = validate_number($_POST['txtOrderId']); if($result
== 1) {
$order_id = $_POST['txtOrderId'];
$query_selectInvoice = "SELECT * FROM invoice,retailer,area WHERE invoice.retailer_id=retailer.retailer_id AND
retailer.area_id=area.area_id AND order_id='$order_id'";
$result_selectInvoice = mysqli_query($con,$query_selectInvoice); $row_selectInvoice
= mysqli_fetch_array($result_selectInvoice); if(empty($row_selectInvoice)){
$error = "* No invoice was found with this ID";
} else
{
mysqli_data_seek($result_selectInvoice,0);
} }
else {
$error = "* Invalid ID";
} }
else if(!empty($_POST['cmbRetailer'])) {
$retailer_id = $_POST['cmbRetailer'];
$query_selectInvoice = "SELECT * FROM invoice,retailer,area WHERE invoice.retailer_id=retailer.retailer_id AND
retailer.area_id=area.area_id AND invoice.retailer_id='$retailer_id' ORDER BY invoice_id DESC";
$result_selectInvoice = mysqli_query($con,$query_selectInvoice); $row_selectInvoice
= mysqli_fetch_array($result_selectInvoice); if(empty($row_selectInvoice)){
$error = "* No invoice was found of the selected Retailer";
} else
{
mysqli_data_seek($result_selectInvoice,0);
} }
else if(!empty($_POST['txtDate'])) {
$date = $_POST['txtDate'];
$query_selectInvoice = "SELECT * FROM invoice,retailer,area WHERE invoice.retailer_id=retailer.retailer_id AND
retailer.area_id=area.area_id AND invoice.date='$date'";
$result_selectInvoice = mysqli_query($con,$query_selectInvoice); $row_selectInvoice
= mysqli_fetch_array($result_selectInvoice); if(empty($row_selectInvoice)){
$error = "* No invoice was found with the selected Date";
} else
{
mysqli_data_seek($result_selectInvoice,0);
}
} else
{
$error = "* Please enter the data to search for.";
} }
else {
$error = "Please choose an option to search for.";
} }
else {
$query_selectInvoice = "SELECT * FROM invoice,retailer,area WHERE invoice.retailer_id=retailer.retailer_id AND
retailer.area_id=area.area_id";
$result_selectInvoice = mysqli_query($con,$query_selectInvoice);
} }
else {
header('Location:../index.php');
}
?>