# Copyright (c) 2013, VHRS and contributors
# For license information, please see license.txt

from __future__ import unicode_literals
import frappe
from frappe import _, msgprint
from frappe.utils import (cint, cstr, date_diff, flt, getdate, money_in_words,
                          nowdate, rounded, today)
from datetime import datetime
from datetime import date
import datetime
from calendar import monthrange


def execute(filters=None):
    columns = get_columns()
    data = []
    row = []
    filters
    applicant = applicants(filters)
    for app in applicant:
        row = [app.customer, app.ref_id, app.candidate_name,
                app.in_date, app.status, app.checks_group]
        if app.status != "Entry Pending":
            cg = frappe.get_doc("Checks Group", app.checks_group)
            if cg.employment_check1 == 1:
                emp = frappe.get_doc("Employment Check1", {
                    "applicant_id": app.ref_id})
                if emp.status != "Allocation Completed":
                    row += [emp.status]
                else:
                    vemp = frappe.get_doc("Verify Employment Check1", {
                        "applicant_id": app.ref_id})
                    row += [vemp.status]
            else:
                row += ["-"]
            if cg.employment_check2 == 1:
                emp = frappe.get_doc("Employment Check2", {
                    "applicant_id": app.ref_id})
                if emp.status != "Allocation Completed":
                    row += [emp.status]
                else:
                    vemp = frappe.get_doc("Verify Employment Check2", {
                        "applicant_id": app.ref_id})
                    row += [vemp.status]
            else:
                row += ["-"]
            if cg.employment_check3 == 1:
                emp = frappe.get_doc("Employment Check3", {
                    "applicant_id": app.ref_id})
                if emp.status != "Allocation Completed":
                    row += [emp.status]
                else:
                    vemp = frappe.get_doc("Verify Employment Check3", {
                        "applicant_id": app.ref_id})
                    row += [vemp.status]
            else:
                row += ["-"]
            if cg.employment_check4 == 1:
                emp = frappe.get_doc("Employment Check4", {
                    "applicant_id": app.ref_id})
                if emp.status != "Allocation Completed":
                    row += [emp.status]
                else:
                    vemp = frappe.get_doc("Verify Employment Check4", {
                        "applicant_id": app.ref_id})
                    row += [vemp.status]
            else:
                row += ["-"]
            if cg.education_check1 == 1:
                if frappe.db.exists("Education Check1", {
                        "applicant_id": app.ref_id}):
                    emp = frappe.get_doc("Education Check1", {
                        "applicant_id": app.ref_id})
                    if emp.status != "Allocation Completed":
                        row += [emp.status]
                    else:
                        vemp = frappe.get_doc("Verify Education Check1", {
                            "applicant_id": app.ref_id})
                        row += [vemp.status]
            else:
                row += ["-"]
            if cg.education_check2 == 1:
                emp = frappe.get_doc("Education Check2", {
                    "applicant_id": app.ref_id})
                if emp.status != "Allocation Completed":
                    row += [emp.status]
                else:
                    vemp = frappe.get_doc("Verify Education Check2", {
                        "applicant_id": app.ref_id})
                    row += [vemp.status]
            else:
                row += ["-"]
            if cg.education_check3 == 1:
                emp = frappe.get_doc("Education Check3", {
                    "applicant_id": app.ref_id})
                if emp.status != "Allocation Completed":
                    row += [emp.status]
                else:
                    vemp = frappe.get_doc("Verify Education Check3", {
                        "applicant_id": app.ref_id})
                    row += [vemp.status]
            else:
                row += ["-"]
            if cg.education_check4 == 1:
                emp = frappe.get_doc("Education Check4", {
                    "applicant_id": app.ref_id})
                if emp.status != "Allocation Completed":
                    row += [emp.status]
                else:
                    vemp = frappe.get_doc("Verify Education Check4", {
                        "applicant_id": app.ref_id})
                    row += [vemp.status]
            else:
                row += ["-"]
            if cg.address_check1 == 1:
                emp = frappe.get_doc("Address Check1", {
                    "applicant_id": app.ref_id})
                if emp.status != "Allocation Completed":
                    row += [emp.status]
                else:
                    vemp = frappe.get_doc("Verify Address Check1", {
                        "applicant_id": app.ref_id})
                    row += [vemp.status]
            else:
                row += ["-"]
            if cg.address_check2 == 1:
                emp = frappe.get_doc("Address Check2", {
                    "applicant_id": app.ref_id})
                if emp.status != "Allocation Completed":
                    row += [emp.status]
                else:
                    vemp = frappe.get_doc("Verify Address Check2", {
                        "applicant_id": app.ref_id})
                    row += [vemp.status]
            else:
                row += ["-"]
            if cg.address_check3 == 1:
                emp = frappe.get_doc("Address Check3", {
                    "applicant_id": app.ref_id})
                if emp.status != "Allocation Completed":
                    row += [emp.status]
                else:
                    vemp = frappe.get_doc("Verify Address Check3", {
                        "applicant_id": app.ref_id})
                    row += [vemp.status]
            else:
                row += ["-"]
            if cg.address_check4 == 1:
                emp = frappe.get_doc("Address Check4", {
                    "applicant_id": app.ref_id})
                if emp.status != "Allocation Completed":
                    row += [emp.status]
                else:
                    vemp = frappe.get_doc("Verify Address Check4", {
                        "applicant_id": app.ref_id})
                    row += [vemp.status]
            else:
                row += ["-"]
            if cg.family_check1 == 1:
                emp = frappe.get_doc("Family Check1", {
                    "applicant_id": app.ref_id})
                if emp.status != "Allocation Completed":
                    row += [emp.status]
                else:
                    vemp = frappe.get_doc("Verify Family Check1", {
                        "applicant_id": app.ref_id})
                    row += [vemp.status]
            else:
                row += ["-"]
            if cg.reference_check1 == 1:
                emp = frappe.get_doc("Reference Check1", {
                    "applicant_id": app.ref_id})
                if emp.status != "Allocation Completed":
                    row += [emp.status]
                else:
                    vemp = frappe.get_doc("Verify Reference Check1", {
                        "applicant_id": app.ref_id})
                    row += [vemp.status]
            else:
                row += ["-"]
            if cg.reference_check2 == 1:
                emp = frappe.get_doc("Reference Check2", {
                    "applicant_id": app.ref_id})
                if emp.status != "Allocation Completed":
                    row += [emp.status]
                else:
                    vemp = frappe.get_doc("Verify Reference Check2", {
                        "applicant_id": app.ref_id})
                    row += [vemp.status]
            else:
                row += ["-"]
            if cg.reference_check3 == 1:
                emp = frappe.get_doc("Reference Check3", {
                    "applicant_id": app.ref_id})
                if emp.status != "Allocation Completed":
                    row += [emp.status]
                else:
                    vemp = frappe.get_doc("Verify Reference Check3", {
                        "applicant_id": app.ref_id})
                    row += [vemp.status]
            else:
                row += ["-"]
            if cg.reference_check4 == 1:
                emp = frappe.get_doc("Reference Check4", {
                    "applicant_id": app.ref_id})
                if emp.status != "Allocation Completed":
                    row += [emp.status]
                else:
                    vemp = frappe.get_doc("Verify Reference Check4", {
                        "applicant_id": app.ref_id})
                    row += [vemp.status]
            else:
                row += ["-"]
            if cg.civil_check == 1:
                emp = frappe.get_doc("Civil Check", {
                    "applicant_id": app.ref_id})
                if emp.status != "Allocation Completed":
                    row += [emp.status]
                else:
                    vemp = frappe.get_doc("Verify Civil Check", {
                        "applicant_id": app.ref_id})
                    row += [vemp.status]
            else:
                row += ["-"]
            if cg.criminal_check == 1:
                emp = frappe.get_doc("Criminal Check", {
                    "applicant_id": app.ref_id})
                if emp.status != "Allocation Completed":
                    row += [emp.status]
                else:
                    vemp = frappe.get_doc("Verify Criminal Check", {
                        "applicant_id": app.ref_id})
                    row += [vemp.status]
            else:
                row += ["-"]
            if cg.id_check1 == 1:
                emp = frappe.get_doc("ID Check1", {
                    "applicant_id": app.ref_id})
                if emp.status != "Allocation Completed":
                    row += [emp.status]
                else:
                    vemp = frappe.get_doc("Verify ID Check1", {
                        "applicant_id": app.ref_id})
                    row += [vemp.status]
            else:
                row += ["-"]
            if cg.id_check2 == 1:
                emp = frappe.get_doc("ID Check2", {
                    "applicant_id": app.ref_id})
                if emp.status != "Allocation Completed":
                    row += [emp.status]
                else:
                    vemp = frappe.get_doc("Verify ID Check2", {
                        "applicant_id": app.ref_id})
                    row += [vemp.status]
            else:
                row += ["-"]
            if cg.id_check3 == 1:
                emp = frappe.get_doc("ID Check3", {
                    "applicant_id": app.ref_id})
                if emp.status != "Allocation Completed":
                    row += [emp.status]
                else:
                    vemp = frappe.get_doc("Verify ID Check3", {
                        "applicant_id": app.ref_id})
                    row += [vemp.status]
            else:
                row += ["-"]
            if cg.id_check4 == 1:
                emp = frappe.get_doc("ID Check4", {
                    "applicant_id": app.ref_id})
                if emp.status != "Allocation Completed":
                    row += [emp.status]
                else:
                    vemp = frappe.get_doc("Verify ID Check4", {
                        "applicant_id": app.ref_id})
                    row += [vemp.status]
            else:
                row += ["-"]
            if cg.id_check5 == 1:
                emp = frappe.get_doc("ID Check5", {
                    "applicant_id": app.ref_id})
                if emp.status != "Allocation Completed":
                    row += [emp.status]
                else:
                    vemp = frappe.get_doc("Verify ID Check5", {
                        "applicant_id": app.ref_id})
                    row += [vemp.status]
            else:
                row += ["-"]
            if cg.id_check6 == 1:
                emp = frappe.get_doc("ID Check6", {
                    "applicant_id": app.ref_id})
                if emp.status != "Allocation Completed":
                    row += [emp.status]
                else:
                    vemp = frappe.get_doc("Verify ID Check6", {
                        "applicant_id": app.ref_id})
                    row += [vemp.status]
            else:
                row += ["-"]
        data.append(row)
    return columns, data


def get_columns():
    columns = [
        _("Project Name") + ":Link/Customer:200",
        _("VHRS Ref. No") + ":Data:150",
        _("Candidate Name") + ":Data:180",
        _("Start Date") + ":Date:150",
        _("Status") + ":Data:150",
        _("Checks Group Name") + ":Data:150",
        _("Emp Check1 Status") + ":Data:150",
        _("Emp Check2 Status") + ":Data:150",
        _("Emp Check3 Status") + ":Data:150",
        _("Emp Check4 Status") + ":Data:150",
        _("Edu Check1 Status") + ":Data:150",
        _("Edu Check2 Status") + ":Data:150",
        _("Edu Check3 Status") + ":Data:150",
        _("Edu Check4 Status") + ":Data:150",
        _("Add Check1 Status") + ":Data:150",
        _("Add Check2 Status") + ":Data:150",
        _("Add Check3 Status") + ":Data:150",
        _("Add Check4 Status") + ":Data:150",
        _("Family Check Status") + ":Data:150",
        _("Ref Check1 Status") + ":Data:150",
        _("Ref Check2 Status") + ":Data:150",
        _("Ref Check3 Status") + ":Data:150",
        _("Ref Check4 Status") + ":Data:150",
        _("Civil Check1 Status") + ":Data:150",
        _("Criminal Check2 Status") + ":Data:150",
        _("ID Check1 Status") + ":Data:150",
        _("ID Check2 Status") + ":Data:150",
        _("ID Check3 Status") + ":Data:150",
        _("ID Check4 Status") + ":Data:150",
        _("ID Check5 Status") + ":Data:150",
        _("ID Check6 Status") + ":Data:150",

    ]
    return columns


def applicants(filters):
    applicant = frappe.db.sql(
        """select app.checks_group,app.customer,app.ref_id,app.candidate_name,app.in_date,app.status from `tabApplicant` app where
        app.in_date between %(start_date)s and %(end_date)s order by app.in_date""", {
            "start_date": filters.get("from_date"),
            "end_date": filters.get("to_date")
        }, as_dict=1)
    return applicant

[((751, 799), 'frappe.get_doc', 'frappe.get_doc', (['"""Checks Group"""', 'app.checks_group'], {}), "('Checks Group', app.checks_group)\n", (765, 799), False, 'import frappe\n'), ((12871, 12888), 'frappe._', '_', (['"""Project Name"""'], {}), "('Project Name')\n", (12872, 12888), False, 'from frappe import _, msgprint\n'), ((12921, 12938), 'frappe._', '_', (['"""VHRS Ref. No"""'], {}), "('VHRS Ref. No')\n", (12922, 12938), False, 'from frappe import _, msgprint\n'), ((12962, 12981), 'frappe._', '_', (['"""Candidate Name"""'], {}), "('Candidate Name')\n", (12963, 12981), False, 'from frappe import _, msgprint\n'), ((13005, 13020), 'frappe._', '_', (['"""Start Date"""'], {}), "('Start Date')\n", (13006, 13020), False, 'from frappe import _, msgprint\n'), ((13044, 13055), 'frappe._', '_', (['"""Status"""'], {}), "('Status')\n", (13045, 13055), False, 'from frappe import _, msgprint\n'), ((13079, 13101), 'frappe._', '_', (['"""Checks Group Name"""'], {}), "('Checks Group Name')\n", (13080, 13101), False, 'from frappe import _, msgprint\n'), ((13125, 13147), 'frappe._', '_', (['"""Emp Check1 Status"""'], {}), "('Emp Check1 Status')\n", (13126, 13147), False, 'from frappe import _, msgprint\n'), ((13171, 13193), 'frappe._', '_', (['"""Emp Check2 Status"""'], {}), "('Emp Check2 Status')\n", (13172, 13193), False, 'from frappe import _, msgprint\n'), ((13217, 13239), 'frappe._', '_', (['"""Emp Check3 Status"""'], {}), "('Emp Check3 Status')\n", (13218, 13239), False, 'from frappe import _, msgprint\n'), ((13263, 13285), 'frappe._', '_', (['"""Emp Check4 Status"""'], {}), "('Emp Check4 Status')\n", (13264, 13285), False, 'from frappe import _, msgprint\n'), ((13309, 13331), 'frappe._', '_', (['"""Edu Check1 Status"""'], {}), "('Edu Check1 Status')\n", (13310, 13331), False, 'from frappe import _, msgprint\n'), ((13355, 13377), 'frappe._', '_', (['"""Edu Check2 Status"""'], {}), "('Edu Check2 Status')\n", (13356, 13377), False, 'from frappe import _, msgprint\n'), ((13401, 13423), 'frappe._', '_', (['"""Edu Check3 Status"""'], {}), "('Edu Check3 Status')\n", (13402, 13423), False, 'from frappe import _, msgprint\n'), ((13447, 13469), 'frappe._', '_', (['"""Edu Check4 Status"""'], {}), "('Edu Check4 Status')\n", (13448, 13469), False, 'from frappe import _, msgprint\n'), ((13493, 13515), 'frappe._', '_', (['"""Add Check1 Status"""'], {}), "('Add Check1 Status')\n", (13494, 13515), False, 'from frappe import _, msgprint\n'), ((13539, 13561), 'frappe._', '_', (['"""Add Check2 Status"""'], {}), "('Add Check2 Status')\n", (13540, 13561), False, 'from frappe import _, msgprint\n'), ((13585, 13607), 'frappe._', '_', (['"""Add Check3 Status"""'], {}), "('Add Check3 Status')\n", (13586, 13607), False, 'from frappe import _, msgprint\n'), ((13631, 13653), 'frappe._', '_', (['"""Add Check4 Status"""'], {}), "('Add Check4 Status')\n", (13632, 13653), False, 'from frappe import _, msgprint\n'), ((13677, 13701), 'frappe._', '_', (['"""Family Check Status"""'], {}), "('Family Check Status')\n", (13678, 13701), False, 'from frappe import _, msgprint\n'), ((13725, 13747), 'frappe._', '_', (['"""Ref Check1 Status"""'], {}), "('Ref Check1 Status')\n", (13726, 13747), False, 'from frappe import _, msgprint\n'), ((13771, 13793), 'frappe._', '_', (['"""Ref Check2 Status"""'], {}), "('Ref Check2 Status')\n", (13772, 13793), False, 'from frappe import _, msgprint\n'), ((13817, 13839), 'frappe._', '_', (['"""Ref Check3 Status"""'], {}), "('Ref Check3 Status')\n", (13818, 13839), False, 'from frappe import _, msgprint\n'), ((13863, 13885), 'frappe._', '_', (['"""Ref Check4 Status"""'], {}), "('Ref Check4 Status')\n", (13864, 13885), False, 'from frappe import _, msgprint\n'), ((13909, 13933), 'frappe._', '_', (['"""Civil Check1 Status"""'], {}), "('Civil Check1 Status')\n", (13910, 13933), False, 'from frappe import _, msgprint\n'), ((13957, 13984), 'frappe._', '_', (['"""Criminal Check2 Status"""'], {}), "('Criminal Check2 Status')\n", (13958, 13984), False, 'from frappe import _, msgprint\n'), ((14008, 14029), 'frappe._', '_', (['"""ID Check1 Status"""'], {}), "('ID Check1 Status')\n", (14009, 14029), False, 'from frappe import _, msgprint\n'), ((14053, 14074), 'frappe._', '_', (['"""ID Check2 Status"""'], {}), "('ID Check2 Status')\n", (14054, 14074), False, 'from frappe import _, msgprint\n'), ((14098, 14119), 'frappe._', '_', (['"""ID Check3 Status"""'], {}), "('ID Check3 Status')\n", (14099, 14119), False, 'from frappe import _, msgprint\n'), ((14143, 14164), 'frappe._', '_', (['"""ID Check4 Status"""'], {}), "('ID Check4 Status')\n", (14144, 14164), False, 'from frappe import _, msgprint\n'), ((14188, 14209), 'frappe._', '_', (['"""ID Check5 Status"""'], {}), "('ID Check5 Status')\n", (14189, 14209), False, 'from frappe import _, msgprint\n'), ((14233, 14254), 'frappe._', '_', (['"""ID Check6 Status"""'], {}), "('ID Check6 Status')\n", (14234, 14254), False, 'from frappe import _, msgprint\n'), ((864, 929), 'frappe.get_doc', 'frappe.get_doc', (['"""Employment Check1"""', "{'applicant_id': app.ref_id}"], {}), "('Employment Check1', {'applicant_id': app.ref_id})\n", (878, 929), False, 'import frappe\n'), ((1347, 1412), 'frappe.get_doc', 'frappe.get_doc', (['"""Employment Check2"""', "{'applicant_id': app.ref_id}"], {}), "('Employment Check2', {'applicant_id': app.ref_id})\n", (1361, 1412), False, 'import frappe\n'), ((1830, 1895), 'frappe.get_doc', 'frappe.get_doc', (['"""Employment Check3"""', "{'applicant_id': app.ref_id}"], {}), "('Employment Check3', {'applicant_id': app.ref_id})\n", (1844, 1895), False, 'import frappe\n'), ((2313, 2378), 'frappe.get_doc', 'frappe.get_doc', (['"""Employment Check4"""', "{'applicant_id': app.ref_id}"], {}), "('Employment Check4', {'applicant_id': app.ref_id})\n", (2327, 2378), False, 'import frappe\n'), ((2792, 2858), 'frappe.db.exists', 'frappe.db.exists', (['"""Education Check1"""', "{'applicant_id': app.ref_id}"], {}), "('Education Check1', {'applicant_id': app.ref_id})\n", (2808, 2858), False, 'import frappe\n'), ((3419, 3483), 'frappe.get_doc', 'frappe.get_doc', (['"""Education Check2"""', "{'applicant_id': app.ref_id}"], {}), "('Education Check2', {'applicant_id': app.ref_id})\n", (3433, 3483), False, 'import frappe\n'), ((3899, 3963), 'frappe.get_doc', 'frappe.get_doc', (['"""Education Check3"""', "{'applicant_id': app.ref_id}"], {}), "('Education Check3', {'applicant_id': app.ref_id})\n", (3913, 3963), False, 'import frappe\n'), ((4379, 4443), 'frappe.get_doc', 'frappe.get_doc', (['"""Education Check4"""', "{'applicant_id': app.ref_id}"], {}), "('Education Check4', {'applicant_id': app.ref_id})\n", (4393, 4443), False, 'import frappe\n'), ((4857, 4919), 'frappe.get_doc', 'frappe.get_doc', (['"""Address Check1"""', "{'applicant_id': app.ref_id}"], {}), "('Address Check1', {'applicant_id': app.ref_id})\n", (4871, 4919), False, 'import frappe\n'), ((5331, 5393), 'frappe.get_doc', 'frappe.get_doc', (['"""Address Check2"""', "{'applicant_id': app.ref_id}"], {}), "('Address Check2', {'applicant_id': app.ref_id})\n", (5345, 5393), False, 'import frappe\n'), ((5805, 5867), 'frappe.get_doc', 'frappe.get_doc', (['"""Address Check3"""', "{'applicant_id': app.ref_id}"], {}), "('Address Check3', {'applicant_id': app.ref_id})\n", (5819, 5867), False, 'import frappe\n'), ((6279, 6341), 'frappe.get_doc', 'frappe.get_doc', (['"""Address Check4"""', "{'applicant_id': app.ref_id}"], {}), "('Address Check4', {'applicant_id': app.ref_id})\n", (6293, 6341), False, 'import frappe\n'), ((6752, 6813), 'frappe.get_doc', 'frappe.get_doc', (['"""Family Check1"""', "{'applicant_id': app.ref_id}"], {}), "('Family Check1', {'applicant_id': app.ref_id})\n", (6766, 6813), False, 'import frappe\n'), ((7226, 7290), 'frappe.get_doc', 'frappe.get_doc', (['"""Reference Check1"""', "{'applicant_id': app.ref_id}"], {}), "('Reference Check1', {'applicant_id': app.ref_id})\n", (7240, 7290), False, 'import frappe\n'), ((7706, 7770), 'frappe.get_doc', 'frappe.get_doc', (['"""Reference Check2"""', "{'applicant_id': app.ref_id}"], {}), "('Reference Check2', {'applicant_id': app.ref_id})\n", (7720, 7770), False, 'import frappe\n'), ((8186, 8250), 'frappe.get_doc', 'frappe.get_doc', (['"""Reference Check3"""', "{'applicant_id': app.ref_id}"], {}), "('Reference Check3', {'applicant_id': app.ref_id})\n", (8200, 8250), False, 'import frappe\n'), ((8666, 8730), 'frappe.get_doc', 'frappe.get_doc', (['"""Reference Check4"""', "{'applicant_id': app.ref_id}"], {}), "('Reference Check4', {'applicant_id': app.ref_id})\n", (8680, 8730), False, 'import frappe\n'), ((9141, 9200), 'frappe.get_doc', 'frappe.get_doc', (['"""Civil Check"""', "{'applicant_id': app.ref_id}"], {}), "('Civil Check', {'applicant_id': app.ref_id})\n", (9155, 9200), False, 'import frappe\n'), ((9609, 9671), 'frappe.get_doc', 'frappe.get_doc', (['"""Criminal Check"""', "{'applicant_id': app.ref_id}"], {}), "('Criminal Check', {'applicant_id': app.ref_id})\n", (9623, 9671), False, 'import frappe\n'), ((10078, 10135), 'frappe.get_doc', 'frappe.get_doc', (['"""ID Check1"""', "{'applicant_id': app.ref_id}"], {}), "('ID Check1', {'applicant_id': app.ref_id})\n", (10092, 10135), False, 'import frappe\n'), ((10537, 10594), 'frappe.get_doc', 'frappe.get_doc', (['"""ID Check2"""', "{'applicant_id': app.ref_id}"], {}), "('ID Check2', {'applicant_id': app.ref_id})\n", (10551, 10594), False, 'import frappe\n'), ((10996, 11053), 'frappe.get_doc', 'frappe.get_doc', (['"""ID Check3"""', "{'applicant_id': app.ref_id}"], {}), "('ID Check3', {'applicant_id': app.ref_id})\n", (11010, 11053), False, 'import frappe\n'), ((11455, 11512), 'frappe.get_doc', 'frappe.get_doc', (['"""ID Check4"""', "{'applicant_id': app.ref_id}"], {}), "('ID Check4', {'applicant_id': app.ref_id})\n", (11469, 11512), False, 'import frappe\n'), ((11914, 11971), 'frappe.get_doc', 'frappe.get_doc', (['"""ID Check5"""', "{'applicant_id': app.ref_id}"], {}), "('ID Check5', {'applicant_id': app.ref_id})\n", (11928, 11971), False, 'import frappe\n'), ((12373, 12430), 'frappe.get_doc', 'frappe.get_doc', (['"""ID Check6"""', "{'applicant_id': app.ref_id}"], {}), "('ID Check6', {'applicant_id': app.ref_id})\n", (12387, 12430), False, 'import frappe\n'), ((1097, 1169), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify Employment Check1"""', "{'applicant_id': app.ref_id}"], {}), "('Verify Employment Check1', {'applicant_id': app.ref_id})\n", (1111, 1169), False, 'import frappe\n'), ((1580, 1652), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify Employment Check2"""', "{'applicant_id': app.ref_id}"], {}), "('Verify Employment Check2', {'applicant_id': app.ref_id})\n", (1594, 1652), False, 'import frappe\n'), ((2063, 2135), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify Employment Check3"""', "{'applicant_id': app.ref_id}"], {}), "('Verify Employment Check3', {'applicant_id': app.ref_id})\n", (2077, 2135), False, 'import frappe\n'), ((2546, 2618), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify Employment Check4"""', "{'applicant_id': app.ref_id}"], {}), "('Verify Employment Check4', {'applicant_id': app.ref_id})\n", (2560, 2618), False, 'import frappe\n'), ((2911, 2975), 'frappe.get_doc', 'frappe.get_doc', (['"""Education Check1"""', "{'applicant_id': app.ref_id}"], {}), "('Education Check1', {'applicant_id': app.ref_id})\n", (2925, 2975), False, 'import frappe\n'), ((3651, 3722), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify Education Check2"""', "{'applicant_id': app.ref_id}"], {}), "('Verify Education Check2', {'applicant_id': app.ref_id})\n", (3665, 3722), False, 'import frappe\n'), ((4131, 4202), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify Education Check3"""', "{'applicant_id': app.ref_id}"], {}), "('Verify Education Check3', {'applicant_id': app.ref_id})\n", (4145, 4202), False, 'import frappe\n'), ((4611, 4682), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify Education Check4"""', "{'applicant_id': app.ref_id}"], {}), "('Verify Education Check4', {'applicant_id': app.ref_id})\n", (4625, 4682), False, 'import frappe\n'), ((5087, 5156), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify Address Check1"""', "{'applicant_id': app.ref_id}"], {}), "('Verify Address Check1', {'applicant_id': app.ref_id})\n", (5101, 5156), False, 'import frappe\n'), ((5561, 5630), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify Address Check2"""', "{'applicant_id': app.ref_id}"], {}), "('Verify Address Check2', {'applicant_id': app.ref_id})\n", (5575, 5630), False, 'import frappe\n'), ((6035, 6104), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify Address Check3"""', "{'applicant_id': app.ref_id}"], {}), "('Verify Address Check3', {'applicant_id': app.ref_id})\n", (6049, 6104), False, 'import frappe\n'), ((6509, 6578), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify Address Check4"""', "{'applicant_id': app.ref_id}"], {}), "('Verify Address Check4', {'applicant_id': app.ref_id})\n", (6523, 6578), False, 'import frappe\n'), ((6981, 7049), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify Family Check1"""', "{'applicant_id': app.ref_id}"], {}), "('Verify Family Check1', {'applicant_id': app.ref_id})\n", (6995, 7049), False, 'import frappe\n'), ((7458, 7529), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify Reference Check1"""', "{'applicant_id': app.ref_id}"], {}), "('Verify Reference Check1', {'applicant_id': app.ref_id})\n", (7472, 7529), False, 'import frappe\n'), ((7938, 8009), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify Reference Check2"""', "{'applicant_id': app.ref_id}"], {}), "('Verify Reference Check2', {'applicant_id': app.ref_id})\n", (7952, 8009), False, 'import frappe\n'), ((8418, 8489), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify Reference Check3"""', "{'applicant_id': app.ref_id}"], {}), "('Verify Reference Check3', {'applicant_id': app.ref_id})\n", (8432, 8489), False, 'import frappe\n'), ((8898, 8969), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify Reference Check4"""', "{'applicant_id': app.ref_id}"], {}), "('Verify Reference Check4', {'applicant_id': app.ref_id})\n", (8912, 8969), False, 'import frappe\n'), ((9368, 9434), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify Civil Check"""', "{'applicant_id': app.ref_id}"], {}), "('Verify Civil Check', {'applicant_id': app.ref_id})\n", (9382, 9434), False, 'import frappe\n'), ((9839, 9908), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify Criminal Check"""', "{'applicant_id': app.ref_id}"], {}), "('Verify Criminal Check', {'applicant_id': app.ref_id})\n", (9853, 9908), False, 'import frappe\n'), ((10303, 10367), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify ID Check1"""', "{'applicant_id': app.ref_id}"], {}), "('Verify ID Check1', {'applicant_id': app.ref_id})\n", (10317, 10367), False, 'import frappe\n'), ((10762, 10826), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify ID Check2"""', "{'applicant_id': app.ref_id}"], {}), "('Verify ID Check2', {'applicant_id': app.ref_id})\n", (10776, 10826), False, 'import frappe\n'), ((11221, 11285), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify ID Check3"""', "{'applicant_id': app.ref_id}"], {}), "('Verify ID Check3', {'applicant_id': app.ref_id})\n", (11235, 11285), False, 'import frappe\n'), ((11680, 11744), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify ID Check4"""', "{'applicant_id': app.ref_id}"], {}), "('Verify ID Check4', {'applicant_id': app.ref_id})\n", (11694, 11744), False, 'import frappe\n'), ((12139, 12203), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify ID Check5"""', "{'applicant_id': app.ref_id}"], {}), "('Verify ID Check5', {'applicant_id': app.ref_id})\n", (12153, 12203), False, 'import frappe\n'), ((12598, 12662), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify ID Check6"""', "{'applicant_id': app.ref_id}"], {}), "('Verify ID Check6', {'applicant_id': app.ref_id})\n", (12612, 12662), False, 'import frappe\n'), ((3163, 3234), 'frappe.get_doc', 'frappe.get_doc', (['"""Verify Education Check1"""', "{'applicant_id': app.ref_id}"], {}), "('Verify Education Check1', {'applicant_id': app.ref_id})\n", (3177, 3234), False, 'import frappe\n')]