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); }