Create Tree View and a Tree Browser for any DocType

revant_one · April 23, 2016, 5:45am

I created reference / tutorial app for creating Tree/Chart views for doctype

http://revant.github.io/tree_view

Useful Posts:

Fields in Doctype : Tree

tree_name - Data
parent_tree - Link:Tree
is_group - Select:Yes/No
lft - Int
rgt - Int
old_parent - Link:Tree

tree.py

github.com

revant/tree_view/blob/master/tree_view/tree_view/doctype/tree/tree.py

# -*- coding: utf-8 -*-
# Copyright (c) 2015, MN Tech and contributors
# For license information, please see license.txt

from __future__ import unicode_literals
import frappe
from frappe import _
from frappe.model.document import Document
from frappe.utils.nestedset import NestedSet

class Tree(NestedSet):
	nsm_parent_field = 'parent_tree'

Tree Browser Page:

revant_one · June 30, 2016, 1:20pm

wale · September 2, 2017, 7:17am

Hi @revant_one

Thanks a lot for this great work. I think it really should be part of the core. Have you considered contributing this?

Kind regards,

revant_one · September 2, 2017, 7:56am

This is part of core after Version 7 Update: Common tree view

Any doctype which inherits NestedSet and has _tree.js will have a tree view.

tmatteson · October 18, 2017, 9:27pm

Is it possible to render a tree view in a dialog? I think that makes sense for navigating a warehouse with a lot of children and locations (EG Aisle 001 and bin 001) from stock entry, for example.

Tropicalrambler · September 27, 2018, 11:54pm

Bringing this one back to life!

We have been working on creating a tree view for the Animal Group DocType in agriculture module as per @tmatteson’s suggestions.

So far we are able to create the tree view just fine.
Each animal group has two child tables.

One child table contains the “serialized” animals and their weights and weight uom’s.

The second one “unserialized” contains one row with a quantity, weight and weight uom’s as well.

What we want to do is load the individual child table rows for both serialized and unserialized animals as nodes under the Animal Group DocType, perhaps with a for loop or similar.

Any other ideas to accomplish this (aside from Revant’s excellent reference)?

max_morais_dmm · September 28, 2018, 12:05am

@Tropicalrambler

take an look on how the chart of accounts that the data for the account tree

github.com

frappe/erpnext/blob/develop/erpnext/accounts/utils.py#L733


      
          					pe,
          				),
          			)
          
          
		frappe.msgprint(_("Payment Entries {0} are un-linked").format("\n".join(linked_pe)))
          
          

          
@frappe.whitelist()
          def get_company_default(company, fieldname, ignore_validation=False):
          	value = frappe.get_cached_value("Company", company, fieldname)
          
          
	if not ignore_validation and not value:
          		throw(
          			_("Please set default {0} in Company {1}").format(
          				frappe.get_meta("Company").get_label(fieldname), company
          			)
          		)
          
          
	return value

My suggestion, you can create one list, to return, distinct than the acc, and while you is looping the acc you check if it have childrens, if it have children, you can append the childrens into the tree.

Note: It’s an suggestion, and may not work properly in ERPNext.

Tropicalrambler · September 28, 2018, 12:06am

Thanks Max, we were exploring that with Mario, and your post reinforces our search for solutions in the methods available there. Thanks for the prompt reply!

Update: Found this gem which helped us do a workaround to run some calculations on data in tree view. Ultimately, it will be in the _tree.js for the Animal Group DocType when it is finally Pulled into the Core.

djangons · October 15, 2018, 3:22pm

Boa tarde!
Max, li alguns dos seus post, e percebi que você é o programador mais ativo no grupo na adaptação do ERPNEXT para o Brasil, você ainda esta empenhado no projeto?
Desculpe por comentar seu post, mas não tinha como eu mandar uma msg no privado.

max_morais_dmm · October 15, 2018, 4:08pm

@djangons Sim ainda trabalho com ERPNext, mas em 90% do tempo com projetos fora do mercado brasileiro.

Apesar de eu ter uma experiencia sólida com ERPNext para o mercado Brasileiro, a nossa burocracia tem dificultado a tração do projeto em terras tupiniquins

djangons · October 15, 2018, 5:21pm

Gostaria do seu contato de e-mail, só para trocar uma ideia com você, sobre um projeto de um erp para industria de calçados.

vivek22793 · January 22, 2019, 1:01pm

@revant_one
Sir i successfully implemented tree structure for my custom doctype using your reference.
Thank you so much
Sir i want to hide add_child, edit and delete button from tree view i just want only tree structure. So how i should hide that button. please help me out.
Thanks in advance.

Kipngetich33 · May 2, 2019, 12:13pm

@revant_one I have successfully implemented a tree structure for my custom doctype too thanks I, however, went through quite a hurdle. I will further elaborate how i did it

I created a custom doctype the normal way as shown in the screenshot

name_of_doctype1286×625 40.9 KB
Add the fields:
(i) test_name - Data (this field should be Mandatory)
(ii)parent_test - Link:Tree
(iii)is_group - Select:Yes/No
(iv) lft - Int (this field should be hidden)
(v)rgt - Int (this field should be hidden)
(vi)old_parent - Link:Test (this field should be hidden)
as shown in the screenshot below

fields_to_add1286×576 42.2 KB
Save the doctype
From your text edit open the doctype test and edit the test.py file as shown in the screenshot below

inherit_nested574×574 40.6 KB
Now Create new file test_tree.js and add the code shown in the screenshot below

test_tree_js732×732 36.4 KB
Run bench migrate you are done now when you visit the test list you will see the tree view as shown in the screenshot below:

tree_view1286×576 30.3 KB

If you want to look at the code arrangement for this doctype checkout GitHub - Kipngetich33/Tree-View

0Pranav · August 13, 2019, 7:32am

Added a new Wiki Page for this.

Manan_Shah · December 9, 2019, 6:40am

Hi
I am not able to see the “Is Tree” flag on the New Doctype form.

ERPNext: v12.0.4 (version-12)
Frappe Framework: v12.0.4 (version-12)

I am trying to create a New Doctype in a Custom App.
Is there anything that I am missing?

leoleonel · December 15, 2021, 4:44pm

Boa tarde Max, ainda mexendo com o ERPNext?

max_morais_dmm · December 15, 2021, 7:54pm

@leoleonel sim, como sempre!

leoleonel · December 16, 2021, 7:08pm

Estou tentando implementar ele, tem alguma dica? conhece alguma consultoria? Pelo pouco que eu vi, me parece que a curva de aprendizagem no inicio é bem complicada.

Julian.Dumitrascu · August 28, 2023, 7:33pm

I’ve checked this box.
When I go to the list of documents (before creating the first one), Frappe displays the text “undefined” to the right of the folder symbol. It creates no document when I press the button “New child” or the button “New”.
These look like issues to me. How do we solve them?