public function postPurchasePartyLedgerReportResult()
{
$date1 = Input::get('from_date');
$date2 = Input::get('to_date');
$date3 = date('Y-m-d', strtotime($date1));
$date4 = date('Y-m-d', strtotime($date2));
$party_id = Input::get('party_id');
$report = new Report();
$results = $report->getSalesPartyLedgerReport($date1, $date2, $party_id);
$credit = $report->getCredit($date1, $date2, $party_id);
$debit = $report->getDebit($date1, $date2, $party_id);
$sql = "SELECT * FROM (SELECT A.detail_invoice_id particular, SUM(A.price * A.quantity) amount, A.created_at FROM (\nSELECT purchase_invoice_details.detail_invoice_id, purchase_invoice_details.price, purchase_invoice_details.quantity, purchase_invoices.created_at FROM `purchase_invoices` purchase_invoices LEFT JOIN purchase_invoice_details purchase_invoice_details ON purchase_invoices.invoice_id = purchase_invoice_details.detail_invoice_id WHERE purchase_invoices.party_id = " . $party_id . " AND purchase_invoices.created_at BETWEEN '{$date3}' AND '{$date4}')\n A GROUP BY A.detail_invoice_id\nUNION\n\nSELECT IF(transactions.payment_method='Check', CONCAT(transactions.payment_method,' - ',transactions.cheque_no), transactions.payment_method) particular,transactions.amount, transactions.created_at FROM `purchase_invoices` purchase_invoices\n\nJOIN transactions transactions ON purchase_invoices.invoice_id = transactions.invoice_id\n\nWHERE purchase_invoices.party_id = " . $party_id . " AND IF(transactions.payment_method='Check', transactions.cheque_status, 1 ) = 1 AND transactions.created_at BETWEEN '{$date3}' AND '{$date4}') allData\nORDER BY allData.created_at";
$results2 = DB::select(DB::raw($sql));
return view('Reports.purchasePartyLedgerReportResult', compact('results', 'results2'))->with('party_id', $party_id)->with('date1', $date1)->with('credit', $credit)->with('debit', $debit)->with('date2', $date2);
// return view('Reports.purchasePartyLedgerReportResult',compact('results'))
// ->with('party_id',$party_id)
// ->with('date1',$date1)
// ->with('credit',$credit)
// ->with('debit',$debit)
// ->with('date2',$date2);
}
