report permission merge
diff --git a/patches/january_2013/report_permission.py b/patches/january_2013/report_permission.py
index 5e69229..1465352 100644
--- a/patches/january_2013/report_permission.py
+++ b/patches/january_2013/report_permission.py
@@ -2,9 +2,13 @@
def execute():
webnotes.reload_doc("core", "doctype", "docperm")
webnotes.conn.sql("""update tabDocPerm set `report`=`write`""")
+
+ # no report for singles
webnotes.conn.sql("""update tabDocPerm, tabDocType set tabDocPerm.`report`=0
where tabDocPerm.`parent` = tabDocType.name
and ifnull(tabDocType.issingle,0) = 1""")
+
+ # no submit for not submittables
webnotes.conn.sql("""update tabDocPerm, tabDocType set tabDocPerm.`submit`=0
where tabDocPerm.`parent` = tabDocType.name
and ifnull(tabDocType.is_submittable,0) = 0""")
\ No newline at end of file