1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / app.eltorofashions.com /
Filename : get_agent_vise_report.php
back
<?php 
session_start();
if(isset($_SESSION['login'])){
include "main.php";

	$from_date = $_POST['from_date'];
	$from_date = date("Y-m-d H:i:s", strtotime($from_date));

	$to_date = $_POST['to_date'];
	$to_date = date("Y-m-d H:i:s", strtotime($to_date));

	$agent_code = $_POST['agent_code'];

	if($agent_code == ""){
		$sql ="select * from invoice where del='1' and status in('Paid','Partially Paid','Not paid') and actualdate BETWEEN '$from_date' AND '$to_date' order by agent_code asc";
	}else{
		 $sql ="select * FROM `invoice` where trim(agent_code) =trim('$agent_code') and del =1 and status in('Paid','Partially Paid','Not paid') and actualdate BETWEEN '$from_date' AND '$to_date' order by invoice_id asc";
		
	}

	$res=$conn->query($sql);

	$main_array = array();
	while ($row = $res->fetch_assoc()) {
		$sub_array['agent_code'] = $row['agent_code'];
		$sub_array['invoice'] = $row['invoice'];

		$pid = $row['party'];
        $get_pname = "SELECT party FROM `party_inv` WHERE id = '$pid'";
        $pname_res = $conn->query($get_pname);
        $pname_row = $pname_res->fetch_assoc();
        
		$sub_array['party'] = $pname_row['party'];
		$sub_array['actualdate'] = date('d-m-Y', strtotime($row['actualdate']));
		$sub_array['amount'] = $row['amount'];
		$sub_array['balance'] = $row['balance'];

		array_push($main_array, $sub_array);
	}
	echo json_encode($main_array);

}
else
{
    header ('location:index.php');
}

?>