MultiSelectList in Script Report

NCP · April 29, 2024, 4:52pm

Please check the default report example for a better understanding.

frappe/erpnext/blob/version-15/erpnext/selling/report/sales_order_analysis/sales_order_analysis.js#L31-L45


      
          		{
          			fieldname: "sales_order",
          			label: __("Sales Order"),
          			fieldtype: "MultiSelectList",
          			width: "80",
          			options: "Sales Order",
          			get_data: function (txt) {
          				return frappe.db.get_link_options("Sales Order", txt);
          			},
          			get_query: () => {
          				return {
          					filters: { docstatus: 1 },
          				};
          			},
          		},

github.com

frappe/erpnext/blob/version-15/erpnext/selling/report/sales_order_analysis/sales_order_analysis.py#L42-L59


      
          def get_conditions(filters):
          	conditions = ""
          	if filters.get("from_date") and filters.get("to_date"):
          		conditions += " and so.transaction_date between %(from_date)s and %(to_date)s"
          
          	if filters.get("company"):
          		conditions += " and so.company = %(company)s"
          
          	if filters.get("sales_order"):
          		conditions += " and so.name in %(sales_order)s"
          
          	if filters.get("status"):
          		conditions += " and so.status in %(status)s"
          
          	if filters.get("warehouse"):
          		conditions += " and soi.warehouse = %(warehouse)s"
          
          	return conditions

github.com

frappe/erpnext/blob/version-15/erpnext/selling/report/sales_order_analysis/sales_order_analysis.py#L62-L99


      
          def get_data(conditions, filters):
          	data = frappe.db.sql(
          		f"""
          		SELECT
          			so.transaction_date as date,
          			soi.delivery_date as delivery_date,
          			so.name as sales_order,
          			so.status, so.customer, soi.item_code,
          			DATEDIFF(CURRENT_DATE, soi.delivery_date) as delay_days,
          			IF(so.status in ('Completed','To Bill'), 0, (SELECT delay_days)) as delay,
          			soi.qty, soi.delivered_qty,
          			(soi.qty - soi.delivered_qty) AS pending_qty,
          			IFNULL(SUM(sii.qty), 0) as billed_qty,
          			soi.base_amount as amount,
          			(soi.delivered_qty * soi.base_rate) as delivered_qty_amount,
          			(soi.billed_amt * IFNULL(so.conversion_rate, 1)) as billed_amount,
          			(soi.base_amount - (soi.billed_amt * IFNULL(so.conversion_rate, 1))) as pending_amount,
          			soi.warehouse as warehouse,
          			so.company, soi.name,
          			soi.description as description

This file has been truncated. show original