<?php
//user_fetch.php
include('db_con.php');
if (isset($_SESSION['user_id'])) {
    $user_type = $_SESSION['user_type'];
    $user_id = $_SESSION['user_id'];
    $user_name = $_SESSION['user_name'];
    $branch_id = $_SESSION['branch_id'];
    $branch_name = $_SESSION['branch_name'];
    $store_id = $_SESSION['store_id'];
    $store_name = $_SESSION['store_name'];
}else{
  header('Location: login');
  die();
}
			$sql = "SELECT doc_status FROM user_rights WHERE user_id = '".$user_id."' and doc_name = 'wholesale_invoices_edit'";
            $statement = $connect->prepare($sql);
            $statement->execute(); // no need to add `$sql` here, you can take that out
            $wholesale_invoices_edit = $statement->fetchColumn();
     
              $sql = "SELECT doc_status FROM user_rights WHERE user_id = '".$user_id."' and doc_name = 'wholesale_invoices_print'";
            $statement = $connect->prepare($sql);
            $statement->execute(); // no need to add `$sql` here, you can take that out
            $wholesale_invoices_print = $statement->fetchColumn();
             $sql = "SELECT doc_status FROM user_rights WHERE user_id = '".$user_id."' and doc_name = 'wholesale_invoices_delete'";
            $statement = $connect->prepare($sql);
            $statement->execute(); // no need to add `$sql` here, you can take that out
            $wholesale_invoices_delete = $statement->fetchColumn();
$query = '';
$output = array();
$query .= "
select m.s_id,m.inv_no,m.dated, v.acc_name,m.description, u.user_name,FORMAT(sum(d.qty*d.rate - d.rate * d.dis_pr / 100 * d.qty) + sum(d.qty*d.rate - d.rate * d.dis_pr / 100 * d.qty) * m.gst_pr / 100 + sum(d.qty*d.rate - d.rate * d.dis_pr / 100 * d.qty) * m.fst_pr / 100 + sum(d.qty*d.rate - d.rate * d.dis_pr / 100 * d.qty) * m.ast_pr / 100 + m.freight - m.discount,2)  amount from  sale m,sale_detail d,accounts v, user_detail u where m.s_id = d.s_id and m.cust_id=v.acc_no AND m.user_id=u.user_id AND m.inv_type = 'Credit' AND m.gst = 'OFF' AND
";
if(isset($_POST["search"]["value"]))
{
	$query .= '(m.s_id LIKE "%'.$_POST["search"]["value"].'%" ';
	$query .= 'OR m.dated LIKE "%'.$_POST["search"]["value"].'%" ';
	
	$query .= 'OR user_name LIKE "%'.$_POST["search"]["value"].'%" ';
	$query .= 'OR acc_name LIKE "%'.$_POST["search"]["value"].'%")';
	
	
}
if(isset($_POST["order"]))
{
	$query .= 'group by s_id ORDER BY '.$_POST['order']['0']['column'].' '.$_POST['order']['0']['dir'].' ';
}
else
{
	$query .= 'group by s_id ORDER BY s_id DESC ';
}
$statement = $connect->prepare($query);
$statement->execute();
$result = $statement->fetchAll();
$data = array();
$filtered_rows = $statement->rowCount();
foreach($result as $row)
{
	
	
	$sub_array = array();
	$sub_array[] = $row['s_id'];
	
	$sub_array[] = $row['dated'];
	$sub_array[] = $row['inv_no'];
	$sub_array[] = $row['acc_name'];
	
	
	$sub_array[] = $row['user_name'];
	
	$sub_array[] = $row['amount'];
	
	 
	
	
	if($wholesale_invoices_edit=='ON'){
	$sub_array[] = '<a style=""href="sales_edit?update=1&id='.$row["s_id"].'" class="btn btn-warning"><i class="fa fa-edit"></i></a>';
	}
	$sub_array[] = '
	<a href="sale_invoice_a5?print=1&id='.$row["s_id"].'"><span class="btn btn-success"><i class="fa fa-print"></i></span></a>
	
	';
	if($wholesale_invoices_delete=='ON'){
	$sub_array[] = '<button type="button" name="delete" id="'.$row["s_id"].'" class="btn btn-danger delete" ><i class="fa fa-close"></i></button>';
	}
	$data[] = $sub_array;
}
$output = array(
	"draw"				=>	intval($_POST["draw"]),
	"recordsTotal"  	=>  $filtered_rows,
	"recordsFiltered" 	=> 	get_total_all_records($connect),
	"data"    			=> 	$data
);
echo json_encode($output);
function get_total_all_records($connect)
{
	$statement = $connect->prepare("SELECT * FROM sale where gst = 'OFF' and inv_type = 'Credit'");
	$statement->execute();
	return $statement->rowCount();
}
?>