You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
12 lines
815 B
12 lines
815 B
3 years ago
|
import frappe
|
||
|
from frappe.model.document import Document
|
||
|
import json
|
||
|
|
||
|
@frappe.whitelist()
|
||
|
def get_repair_manual(vehicle,variant,fuel,transmission,drive):
|
||
|
key_dict = frappe.db.sql('''SELECT name as variantkey, vehicle, variant, fuel, transmission, drive FROM _d6463952657fa86c.`tabVariant Mapping` where vehicle='{0}' and variant='{1}' and fuel='{2}' and transmission='{3}' and drive='{4}';'''.format(vehicle,variant,fuel,transmission,drive), as_dict=True)
|
||
|
key_dict=key_dict[0]
|
||
|
variantkey=key_dict['variantkey']
|
||
|
manual_out=frappe.db.sql('''SELECT parent as variant, language, attach_file as file FROM _d6463952657fa86c.`tabVariant Mapping_Assets` where parent='{0}' and category='Technical Manual' and parentfield = 'assets';'''.format(variantkey), as_dict=True)
|
||
|
|
||
|
return manual_out
|