1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / app.eltorofashions.com /
Filename : get_period_vise_payment_received.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'];
	$agent_code = trim($agent_code);

	if($agent_code == ""){
		$sql ="SELECT i.party,i.agent_code,p.payment_date,p.invoice,SUM(p.amount) as received_amount FROM `invoice` i, payment p WHERE  i.invoice = p.invoice and p.payment_date BETWEEN '$from_date' and '$to_date' and p.del = 1 and i.del = 1 GROUP BY p.invoice";
	}else{
		$sql ="SELECT i.party,i.agent_code,p.payment_date,p.invoice,SUM(p.amount) as received_amount FROM `invoice` i, payment p WHERE i.agent_code = '$agent_code' and i.invoice = p.invoice and p.payment_date BETWEEN '$from_date' and '$to_date' and p.del = 1 and i.del = 1 GROUP BY p.invoice";
	}

	$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['payment_date'] = date('d-m-Y', strtotime($row['payment_date']));
		$sub_array['received_amount'] = $row['received_amount'];
		

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

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

?>