def checkAllIfs(self):
#fact and leg adresses
if(not self.FalseTrueInfo['sameLegFactAdr']):
self.dictOne['13:1'] = self.questionDict['factAddress'].split(", ")[0]
self.dictOne['13:2'] = self.questionDict['factAddress'].split(", ")[1]
self.dictOne['13:3'] = self.questionDict['factAddress'].split(", ")[2]
self.dictOne['15:1'] = self.questionDict['factAddress'].split(", ")[3]
self.dictOne['15:2'] = self.questionDict['factAddress'].split(", ")[4]
self.dictOne['15:3'] = self.questionDict['factAddress'].split(", ")[5]
else:
self.doTableMarks(table = 0, cellR = 13, cellC = 0, num = 0)
#is director individual ent
if(self.FalseTrueInfo['isDirIE']):
self.dictThree['3:2'] = smfun.getOnlyString(self.highPersonArr[0][12])
self.dictThree['4:2'] = smfun.getOnlyNumber(self.highPersonArr[0][12])
self.dictThree['5:2'] = self.highPersonArr[0][13]
self.doTableMarks(table = 2, cellR = 2, cellC = 2, num = 1)
else:
self.doTableMarks(table = 2, cellR = 2, cellC = 2, num = 0)
if(self.highPersonArr[0][14].lower() == 'да'): #dir and counter is the same?
self.doTableMarks(table = 2, cellR = 40, cellC = 3) #yes
else:
self.doTableMarks(table = 2, cellR = 40, cellC = 8)#No, counter and dir aren`t the same
self.dictThree['43:2'] = self.highPersonArr[1][1].split()[0]#data about accounter
self.dictThree['43:4'] = self.highPersonArr[1][1].split()[1]
self.dictThree['43:8'] = self.highPersonArr[1][1].split()[2]
self.dictThree['44:2'] = self.highPersonArr[1][9]
self.dictThree['45:2'] = self.highPersonArr[1][0]
self.dictThree['47:2'] = self.highPersonArr[1][10]
self.dictThree['47:4'] = self.highPersonArr[1][11]
self.dictThree['49:2'] = self.highPersonArr[1][8].split(',')[0]
self.dictThree['49:4'] = self.highPersonArr[1][8].split(',')[1]
self.dictThree['51:2'] = self.highPersonArr[1][8].split(',')[2]
self.dictThree['53:2'] = ', '.join(self.highPersonArr[1][8].split(',')[3:])
self.dictThree['55:2'] = self.highPersonArr[1][2]
self.dictThree['55:6'] = self.highPersonArr[1][4]
self.dictThree['57:2'] = self.highPersonArr[1][3]
self.dictThree['57:6'] = self.highPersonArr[1][5]
self.dictThree['59:2'] = self.highPersonArr[1][6]
self.dictThree['59:6'] = self.highPersonArr[1][7]
if(self.FalseTrueInfo['isCountIE']): #if accounter is IE
self.dictThree['60:2'] = smfun.getOnlyString(self.highPersonArr[1][12])
self.dictThree['61:2'] = smfun.getOnlyNumber(self.highPersonArr[1][12])
self.dictThree['63:2'] = self.highPersonArr[1][13]
self.doTableMarks(table = 2, cellR = 41, cellC = 2, num = 1)
else:
self.doTableMarks(table = 2, cellR = 41, cellC = 2, num = 0)
self.insertTableData(0, self.dictOne, self.size, self.fontFamily)
self.insertTableData(1, self.dictTwo, self.size, self.fontFamily)
self.insertTableData(2, self.dictThree, self.size, self.fontFamily)
self.insertTableData(5, self.dictSix, self.size, self.fontFamily)
def fillTables(self): tables = self.doc.tables #about director tables[4].cell(1,0).text = self.highPersonArr[0][9] tables[4].cell(1,1).text = self.highPersonArr[0][10] +", "+self.highPersonArr[0][11] tables[4].cell(1,2).text = self.highPersonArr[0][8] tables[4].cell(1,3).text = (self.highPersonArr[0][2]+", "+ self.highPersonArr[0][3]+", выдан "+ self.highPersonArr[0][4]+" "+ self.highPersonArr[0][5]+", годен до "+ self.highPersonArr[0][7]+", идентификационный "+ self.highPersonArr[0][6]) #about accounter if (self.FalseTrueInfo['isDirCountsame']): tables[5].cell(2,0).text = self.mark else: if (self.FalseTrueInfo['isCountIE']): tables[6].cell(0,0).text = self.mark tables[8].cell(1,0).text = self.highPersonArr[1][1] tables[8].cell(1,1).text = self.highPersonArr[1][8] tables[8].cell(1,2).text = smfun.getOnlyNumber(self.highPersonArr[1][12]) else: tables[5].cell(0,0).text = self.mark self.reDict['9. Фамилия, собственное имя, отчество'] = self.highPersonArr[1][1] #about shareholders for i,person in enumerate(self.shareholders): tables[9].cell(1+i, 0).text = self.shareholders[i][1] tables[9].cell(1+i, 1).text = self.shareholders[i][9] tables[9].cell(1+i, 2).text = self.shareholders[i][10]+", "+self.shareholders[i][11] tables[9].cell(1+i, 3).text = self.shareholders[i][8] tables[9].cell(1+i, 4).text = (self.shareholders[i][2]+", "+ self.shareholders[i][3]+", выдан "+ self.shareholders[i][4]+" "+ self.shareholders[i][5]+", годен до "+ self.shareholders[i][7]+", идентификационный "+ self.shareholders[i][6]) tables[9].cell(1+i, 5).text = self.shareholders[i][13] tables[9].cell(1+i, 6).text = self.shareholders[i][0]
def __init__(self, template, document, savePath):
super(Dabrabyt, self).__init__(template, document, savePath)
self.size = 9
self.fontFamily = 'Times new roman'
self.dictOne = {'5:28' : self.questionDict['fullName'],
'9:28' : self.questionDict['regNum'],
'11:28' : self.questionDict['regDate'],
'13:28' : self.questionDict['nameOfRegAuth'],
'15:28' : self.questionDict['regNum'],
'18:28' : self.questionDict['legAddress'],
'19:28' : self.questionDict['factAddress'],
'23:28' : self.questionDict['phoneNum'],
'25:28' : self.questionDict['email'],
'27:28' : self.questionDict['webSite'],
'30:21' : self.questionDict['purpos'],
'35:5' : smfun.getOnlyNumber(self.questionDict['sizeOfAuthCap']),
'35:11' : smfun.getOnlyString(self.questionDict['sizeOfAuthCap']),
'39:24' : smfun.getOnlyNumber(self.questionDict['codeOfActive'])[0], #ОКЭД
'39:30' : smfun.getOnlyNumber(self.questionDict['codeOfActive'])[1],
'39:33' : smfun.getOnlyNumber(self.questionDict['codeOfActive'])[2],
'39:37' : smfun.getOnlyNumber(self.questionDict['codeOfActive'])[3],
'39:38' : smfun.getOnlyNumber(self.questionDict['codeOfActive'])[4],#End oked
'47:1' : smfun.getOnlyNumber(self.questionDict['planedMonthlyTurnover']),
'51:1' : smfun.getOnlyNumber(self.questionDict['plannedMonthlyTurnoverCash']),
'54:1' : smfun.getOnlyNumber(self.questionDict['annualRevenue']),
##счета, открытые в других банках вставить сюда
##
'70:1' : self.fillShIndCol(5, 0),#Бенефициарный владелец
'77:1' : self.questionDict['manageStructure'],
'80:1' : smfun.getOnlyNumber(self.questionDict['membersNum']),
#director
'84:1' : self.highPersonArr[0][1]+', '+self.highPersonArr[0][9],
'84:20' : self.highPersonArr[0][10]+', '+self.highPersonArr[0][11],
'84:30' : self.highPersonArr[0][8],
'84:45' : (self.highPersonArr[0][2]+" "+
self.highPersonArr[0][3]+", ВЫДАН "+
self.highPersonArr[0][4]+", "+
self.highPersonArr[0][5]+", СРОК ДЕЙСТВИЯ ДО "+
self.highPersonArr[0][7]),
'85:30' : self.highPersonArr[0][6],
'86:30' : self.questionDict['phoneNum'],
#accounter
'94:1' : self.highPersonArr[1][1]+', '+self.highPersonArr[1][9],
'94:20' : self.highPersonArr[1][10]+', '+self.highPersonArr[1][11],
'94:30' : self.highPersonArr[1][8],
'94:45' : (self.highPersonArr[1][2]+" "+
self.highPersonArr[1][3]+", ВЫДАН "+
self.highPersonArr[1][4]+", "+
self.highPersonArr[1][5]+", СРОК ДЕЙСТВИЯ ДО "+
self.highPersonArr[1][7]),
'95:30' : self.highPersonArr[1][6],
'96:30' : self.questionDict['phoneNum'],
#
'141:40' : self.highPersonArr[0][1].split()[0]+" "+self.highPersonArr[0][1].split()[1][0]+"."+self.highPersonArr[0][1].split()[2][0]+'.',
'143:2' : str(datetime.datetime.now().strftime("%d.%m.%Y"))
}
self.fillIndividualSharehold()
self.insertTableData(0, self.dictOne, self.size, self.fontFamily)
self.doc.save(self.savePath)
def getRegNum(self, personIndex): return ', УНП: '+smfun.getOnlyNumber(self.highPersonArr[personIndex][12]) if self.highPersonArr[personIndex][12] else ''
def __init__(self, template, document, savePath):
super(Alfa, self).__init__(template, document, savePath)
self.size = 9
self.fontFamily = 'Times new roman'
self.dictOne = {'0:1' : self.questionDict['fullName'],
'1:1' : self.questionDict['shortName'],
'2:1' : tools.transl.translit1(self.questionDict['fullName']),
'3:1' : self.questionDict['regNum'],
'4:1' : "",
'6:1' : self.questionDict['legAddress'].split(", ")[0],
'6:2' : self.questionDict['legAddress'].split(", ")[1],
'6:3' : self.questionDict['legAddress'].split(", ")[2],
'8:1' : self.questionDict['legAddress'].split(", ")[3],
'8:2' : self.questionDict['legAddress'].split(", ")[4],
'8:3' : self.questionDict['legAddress'].split(", ")[5],
'9:1' : self.questionDict['phoneNum'],
'10:1' : self.questionDict['email'],
'11:1' : self.questionDict['webSite'],
'18:0' : self.questionDict['regDate'],
'18:2' : self.questionDict['regNum'],
'18:3' : self.questionDict['nameOfRegAuth'],
'20:2' : smfun.getOnlyNumber(self.questionDict['sizeOfAuthCap']),
'20:3' : smfun.getOnlyString(self.questionDict['sizeOfAuthCap'])}
self.dictTwo = {'0:3' : self.questionDict['regDate'],
#ОКЭД start
'2:8' : smfun.getOnlyNumber(self.questionDict['codeOfActive'])[0],
'2:9' : smfun.getOnlyNumber(self.questionDict['codeOfActive'])[1],
'2:10' : smfun.getOnlyNumber(self.questionDict['codeOfActive'])[2],
'2:12' : smfun.getOnlyNumber(self.questionDict['codeOfActive'])[3],
'2:13' : smfun.getOnlyNumber(self.questionDict['codeOfActive'])[4],
#ОКЭД end
'6:3' : self.questionDict['membersNum'],
'7:3' : self.questionDict['annualRevenue'],
'10:1' : self.questionDict['history'],
'12:1' : self.questionDict['purpos'],
}
self.dictThree = {'0:2' : self.questionDict['manageStructure'], #about director
'7:2' : self.highPersonArr[0][1].split()[0],#Name
'7:4' : self.highPersonArr[0][1].split()[1],
'7:8' : self.highPersonArr[0][1].split()[2],
'8:2' : self.highPersonArr[0][9],
'9:2' : self.highPersonArr[0][0],
'11:2' : self.highPersonArr[0][10],
'11:4' : self.highPersonArr[0][11],
'13:2' : self.highPersonArr[0][8].split(',')[0],
'13:4' : self.highPersonArr[0][8].split(',')[1],
'15:2' : self.highPersonArr[0][8].split(',')[2],
'17:2' : ', '.join(self.highPersonArr[0][8].split(',')[3:]),
'19:2' : self.highPersonArr[0][2],
'19:6' : self.highPersonArr[0][4],
'21:2' : self.highPersonArr[0][3],
'21:6' : self.highPersonArr[0][5],
'23:2' : self.highPersonArr[0][6],
'23:6' : self.highPersonArr[0][7]
}
self.dictSix = {'1:0': self.shareholders[0][1],
'1:13': self.shareholders[0][9],
'1:15': self.shareholders[0][10],
'3:0': self.shareholders[0][11],
'3:13': self.shareholders[0][8],
'5:2': self.shareholders[0][2],
'6:2': self.shareholders[0][3],
'7:2': self.shareholders[0][6],
'5:15': self.shareholders[0][4],
'6:15': self.shareholders[0][5],
'7:15': self.shareholders[0][7],
'9:10': self.shareholders[0][13],
'9:4': self.shareholders[0][14],
#роль юр лица или бенефициара
'9:15': self.shareholders[0][0]}
self.highlightArr = ['2.3. Укажите Ваших постоянных ',
'2.4. Предполагаемые среднемесячные обороты ',
'2.5. Открыты ли у Вашей организации счета ',
'4. Информация о связанных с клиентом организациях',
'5.1. Планируете ли Вы осуществлять в Банке финан',
'5.2. Являются ли руководители, главный бухгалтер организации и \(или\) ',
'5.3. Являются ли учредители \(участники, члены',
'5.4. Имеются ли у Вашей '
'5.5. Имеются ли организации \(к',
'5.6. Имеются ли организации \(кроме ранее ',
'Настоящей подписью ']
self.highlight(self.highlightArr)
self.checkAllIfs()
self.doc.save(self.savePath)
def __init__(self, template, document, savePath):
super(BelGazProm, self).__init__(template, document, savePath)
# '': self.questionDict[''],
self.reDict = {'1. Наименование \(ор':self.questionDict['fullName'],
'1.1.* Сокращенное наимен':self.questionDict['shortName'],
'2.* Учетный номер плательщика ': self.questionDict['regNum'],
'3.1. сведения о первоначал': self.questionDict['firstReg'],
'3.2. сведения о последней ': self.questionDict['lastReg'],
'4.1. юридический адрес': self.questionDict['legAddress'],
'7. Структура органов управления ': self.questionDict['manageStructure'],
'10. Фамилия, собственное имя, отчество': "", #от имени организации
'11. Контактные телефоны': self.questionDict['phoneNum'],
'14. Виды деятельности организации ': (self.questionDict['activityType']+", ОКЭД "+smfun.getOnlyNumber(self.questionDict['codeOfActive'])),
'15.\*\*Цели установления и предполагаемый характер отношений ': self.questionDict['purpos'],
'16. Код налоговой инспекции по месту': self.questionDict['taxNum']}
self.highlightArr = ['5. Объем выручки за предыдущий отчетный год в экв', '9. Фамилия, собственное имя, отчество \(',
'12.3. сведения о наличии учредителей (участников) организации, каждый из которых ',
'13.1. сведения о бенефициарных владельцах организаций',
'Настоящим подтверждаю, что документы']
self.highlight(self.highlightArr)
self.doMarks()
self.fillTables()
self.doTextReplacement(self.reDict)
self.doc.save(self.savePath)