# Copyright (c) 2013, Web Notes Technologies Pvt. Ltd. and Contributors and contributors
# For license information, please see license.txt

from __future__ import unicode_literals
import frappe
from frappe import _
from frappe.utils import flt
from frappe.model.document import Document
import json

class PaymentTool(Document):
	def make_journal_voucher(self):
		from erpnext.accounts.utils import get_balance_on
		total_payment_amount = 0.00
		invoice_voucher_type = {
			'Sales Invoice': 'against_invoice',
			'Purchase Invoice': 'against_voucher',
			'Journal Voucher': 'against_jv',
			'Sales Order': 'against_sales_order',
			'Purchase Order': 'against_purchase_order',
		}

		jv = frappe.new_doc('Journal Voucher')
		jv.voucher_type = 'Journal Entry'
		jv.company = self.company
		jv.cheque_no = self.reference_no
		jv.cheque_date = self.reference_date

		if not self.total_payment_amount:
			frappe.throw(_("Please enter Payment Amount in atleast one row"))

		for v in self.get("payment_tool_details"):
			if not frappe.db.get_value(v.against_voucher_type, {"name": v.against_voucher_no}):
				frappe.throw(_("Row {0}: {1} is not a valid {2}").format(v.idx, v.against_voucher_no,
					v.against_voucher_type))

			if v.payment_amount:
				d1 = jv.append("entries")
				d1.account = self.party_account
				d1.balance = get_balance_on(self.party_account)
				d1.set("debit" if self.received_or_paid=="Paid" else "credit", flt(v.payment_amount))
				d1.set(invoice_voucher_type.get(v.against_voucher_type), v.against_voucher_no)
				d1.set('is_advance', 'Yes' if v.against_voucher_type in ['Sales Order', 'Purchase Order'] else 'No')
				total_payment_amount = flt(total_payment_amount) + flt(d1.debit) - flt(d1.credit)

		d2 = jv.append("entries")
		d2.account = self.payment_account
		d2.set('debit' if total_payment_amount < 0 else 'credit', abs(total_payment_amount))
		if self.payment_account:
			d2.balance = get_balance_on(self.payment_account)

		return jv.as_dict()

@frappe.whitelist()
def get_party_account(party_type, party_name):
	return frappe.db.get_value("Account", {"master_type": party_type, "master_name": party_name})

@frappe.whitelist()
def get_outstanding_vouchers(args):
	from erpnext.accounts.utils import get_outstanding_invoices

	if not frappe.has_permission("Payment Tool"):
		frappe.throw(_("No permission to use Payment Tool"), frappe.PermissionError)

	args = json.loads(args)

	if args.get("party_type") == "Customer" and args.get("received_or_paid") == "Received":
		amount_query = "ifnull(debit, 0) - ifnull(credit, 0)"
	elif args.get("party_type") == "Supplier" and args.get("received_or_paid") == "Paid":
		amount_query = "ifnull(credit, 0) - ifnull(debit, 0)"
	else:
		frappe.throw(_("Please enter the Against Vouchers manually"))

	# Get all outstanding sales /purchase invoices
	outstanding_invoices = get_outstanding_invoices(amount_query, args.get("party_account"))

	# Get all SO / PO which are not fully billed or aginst which full advance not paid
	orders_to_be_billed = get_orders_to_be_billed(args.get("party_type"), args.get("party_name"))
	return outstanding_invoices + orders_to_be_billed

def get_orders_to_be_billed(party_type, party_name):
	voucher_type = 'Sales Order' if party_type == "Customer" else 'Purchase Order'
	orders = frappe.db.sql("""
		select
			name as voucher_no,
			ifnull(grand_total, 0) as invoice_amount,
			(ifnull(grand_total, 0) - ifnull(advance_paid, 0)) as outstanding_amount,
			transaction_date as posting_date
		from
			`tab%s`
		where
			%s = %s
			and docstatus = 1
			and ifnull(status, "") != "Stopped"
			and ifnull(grand_total, 0) > ifnull(advance_paid, 0)
			and abs(100 - ifnull(per_billed, 0)) > 0.01
		""" % (voucher_type, 'customer' if party_type == "Customer" else 'supplier', '%s'),
		party_name, as_dict = True)

	order_list = []
	for d in orders:
		d["voucher_type"] = voucher_type
		order_list.append(d)

	return order_list

@frappe.whitelist()
def get_against_voucher_amount(against_voucher_type, against_voucher_no):
	if against_voucher_type in ["Sales Order", "Purchase Order"]:
		select_cond = "grand_total as total_amount, ifnull(grand_total, 0) - ifnull(advance_paid, 0) as outstanding_amount"
	elif against_voucher_type in ["Sales Invoice", "Purchase Invoice"]:
		select_cond = "grand_total as total_amount, outstanding_amount"
	elif against_voucher_type == "Journal Voucher":
		select_cond = "total_debit as total_amount"

	details = frappe.db.sql("""select {0} from `tab{1}` where name = %s"""
		.format(select_cond, against_voucher_type), against_voucher_no, as_dict=1)

	return details[0] if details else {}