class main:
def __init__(self, master):
self.master = master
self.DicObjType = {1:'',
2:'3D полилиния',
3:'',
4:'Дуга',
5:'',
6:'',
7:'Вхождение блока',
8:'Окружность',
9:'Параллельный размер',
10:'Угловой размер',
11:'',
12:'',
13:'',
14:'',
15:'',
16:'Эллипс',
17:'Штриховка',
18:'Выноска',
19:'Линия',
20:'',
21:'',
22:'Точка',
23:'2D полилиния',
24:'Полилиния',
25:'',
26:'Маскирующая область',
27:'Луч',
28:'Область',
29:'',
30:'',
31:'Сплайн',
32:'Текст',
33:'',
34:'',
35:'',
36:'Конструктивная линия',
37:'',
38:'',
39:'',
40:'',
41:'Угловой размер',
42:'',
43:'',
44:'',
45:''
}
self.DicScales = {
0:u'Черновик',
1:'1:100',
2:'1:200',
3:'1:500',
4:'1:1 000',
5:'1:2 000',
6:'1:5 000',
7:'1:10 000',
8:'1:25 000',
9:'1:50 000',
10:'1:100 000'
}
self.DicReports = {
0:u'Классическая (№ - X - Y - Длина - Угол)',
1:u'Сокращенная (№ - X - Y)',
2:u'По РДС 30-201-98',
3:u'Для лесников (№ - Румб - Длина)',
4:u'Для схемы на КПТ (Приказ 762)'
}
self.DicAcadErrors = {
1:u'AutoCAD не запущен',
2:u'В AutoCAD нет открытых чертежей'
}
self.TplRumb = (u'СВ', u'ЮВ', u'ЮЗ', u'СЗ')
self.title = u'Экспорт координат объектов AutoCAD'
self.master.title(self.title)
self.master.geometry('360x330')
self.master.resizable(False, False)
self.LayrVar = StringVar()
self.SclVar = StringVar()
self.RepVar = StringVar()
self.RBVar = IntVar()
self.RBVar.set(1)
self.PLineCrd = []
self.nprefix = ''
self.startnumpntfrom = 1
self.startnumprclfrom = 1
self.master.LFrame = Frame(self.master, width = 280)
self.master.LFrame.pack(side = 'left', fill = 'y')
self.master.RFrame = Frame(self.master)
self.master.RFrame.pack(side = 'right', fill = 'both')
self.master.frame1=LabelFrame(self.master.RFrame, height = 80, labelanchor='nw', text=u'Слои чертежа')
self.master.frame1.pack(side = 'top', fill = 'x', expand = 0, padx=2)
self.master.frame3=Frame(self.master.RFrame, height = 80)
self.master.frame3.pack(side = 'bottom', fill = 'x', expand = 0)
self.master.frame4=LabelFrame(self.master.LFrame, width = 220, labelanchor='nw', text=u'Порядок нумерации')
self.master.frame4.pack(side = 'top', fill = 'both', expand = 1, padx=2)
self.master.frame5=Frame(self.master.LFrame, height = 80)
self.master.frame5.pack(side = 'top', fill = 'x', expand = 0)
self.master.frame6 = LabelFrame(self.master.RFrame, height = 80, labelanchor='nw', text=u'Надписи для масштаба:')
self.master.frame6.pack(side = 'bottom', fill = 'x', expand = 0, padx=2)
self.master.frame7 = LabelFrame(self.master.RFrame, height = 80, labelanchor='nw', text=u'Вид ведомости:')
self.master.frame7.pack(side = 'bottom', fill = 'x', expand = 0, padx=2)
self.master.frame2=LabelFrame(self.master.RFrame, labelanchor='nw', text=u'Объекты слоя')
self.master.frame2.pack(side = 'top', fill = 'both', expand = 1)
self.master.layers = Menubutton(self.master.frame1, indicatoron = 1, anchor = 'w', textvariable = self.LayrVar)
self.lmenu = Menu(self.master.layers, tearoff = 0, bg = 'white')
self.master.layers.configure(menu = self.lmenu)
self.master.layers.pack(side=LEFT, expand = 1, fill='x')
self.master.scales = Menubutton(self.master.frame6, indicatoron = 1, anchor = 'w', textvariable = self.SclVar)
self.smenu = Menu(self.master.scales, tearoff = 0, bg = 'white')
self.master.scales.configure(menu = self.smenu)
self.master.scales.pack(side=LEFT, expand = 1, fill='x')
for x in xrange(0,len(self.DicScales)):
self.smenu.add_command(label = self.DicScales[x], command = lambda x = x: self.SetActiveScale(x))
self.SclVar.set(self.smenu.entrycget(0, 'label'))
self.master.reports = Menubutton(self.master.frame7, indicatoron = 1, anchor = 'w', textvariable = self.RepVar)
self.rmenu = Menu(self.master.reports, tearoff = 0, bg = 'white')
self.master.reports.configure(menu = self.rmenu)
self.master.reports.pack(side=LEFT, expand = 1, fill='x')
for x in xrange(0,len(self.DicReports)):
self.rmenu.add_command(label = self.DicReports[x], command = lambda x = x: self.SetActiveReport(x))
self.RepVar.set(self.rmenu.entrycget(0, 'label'))
self.master.btn1 = Button(self.master.frame3, width = 16, height = 1, text = u'Экспорт', state=DISABLED, command=self.btn1_press)
self.master.btn2 = Button(self.master.frame3, width = 16, height = 1, text = u'Закрыть', command=self.Quit)
self.master.btn1.pack(anchor = 'n', side = 'left', padx = 2, pady = 2, expand = 1)
self.master.btn2.pack(anchor = 'n', side = 'right', padx = 2, pady = 2, expand = 1)
self.master.scrl=Scrollbar(self.master.frame2)
self.master.entitys = Listbox(self.master.frame2, yscrollcommand=(self.master.scrl, 'set'))
self.master.scrl.configure(command = self.master.entitys.yview)
self.master.scrl.pack(side = 'right', fill = 'y', pady = 1)
self.master.entitys.pack(side = 'top', fill = 'both', expand = 1)
self.master.sf1=Frame(self.master.frame4)
self.master.sf2=Frame(self.master.frame4)
self.master.sf3=Frame(self.master.frame4)
self.master.sf4=Frame(self.master.frame4)
self.master.sf5=Frame(self.master.frame4)
self.master.sf6=LabelFrame(self.master.frame5, height = 80, width = 220, labelanchor='nw', text=u'Префикс нумерации')
self.master.sf7=LabelFrame(self.master.frame5, height = 80, width = 220, labelanchor='nw', text=u'Нумерация точек с:')
self.master.sf8=LabelFrame(self.master.frame5, height = 80, width = 220, labelanchor='nw', text=u'Нумерация участков с:')
self.master.sf1.pack(pady = 1, fill = 'x')
self.master.sf2.pack(pady = 1, fill = 'x')
self.master.sf3.pack(pady = 1, fill = 'x')
self.master.sf4.pack(pady = 1, fill = 'x')
self.master.sf5.pack(pady = 1, fill = 'x')
self.master.sf6.pack(side = 'bottom', fill = 'both', expand = 1, padx=2, pady = 2)
self.master.sf7.pack(side = 'bottom', fill = 'x', expand = 0, padx=2, pady = 2)
self.master.sf8.pack(side = 'bottom', fill = 'x', expand = 0, padx=2, pady = 2)
self.master.rb1=Radiobutton(self.master.sf1, text = u'По умолчанию', variable=self.RBVar, value=1)
self.master.rb2=Radiobutton(self.master.sf2, text = u'Север - юг', variable=self.RBVar, value=2)
self.master.rb3=Radiobutton(self.master.sf3, text = u'Запад - восток', variable=self.RBVar, value=3)
self.master.rb4=Radiobutton(self.master.sf4, text = u'Юг - север', variable=self.RBVar, value=4)
self.master.rb5=Radiobutton(self.master.sf5, text = u'Восток - запад', variable=self.RBVar, value=5)
self.master.rb1.pack(side = 'left', padx = 2, fill = 'x')
self.master.rb2.pack(side = 'left', padx = 2, fill = 'x')
self.master.rb3.pack(side = 'left', padx = 2, fill = 'x')
self.master.rb4.pack(side = 'left', padx = 2, fill = 'x')
self.master.rb5.pack(side = 'left', padx = 2, fill = 'x')
self.master.etr1 = Entry(self.master.sf6)
self.master.etr2 = Entry(self.master.sf7)
self.master.etr3 = Entry(self.master.sf8)
self.master.etr1.pack(side = 'left', padx = 2, pady = 2, fill = 'both')
self.master.etr2.pack(side = 'left', padx = 2, pady = 2, fill = 'both')
self.master.etr3.pack(side = 'left', padx = 2, pady = 2, fill = 'both')
self.master.etr2.insert(0, '1')
self.master.etr3.insert(0, '1')
locale.setlocale(locale.LC_NUMERIC, 'Russian_Russia')
err = self.ConnectACAD()
if err == 0:
self.master.mainloop()
else:
showerror(title = 'Error', message = self.DicAcadErrors[err], parent = self.master)
def GetDcmlSep(self):
return locale.localeconv()['decimal_point']#str(bytes(str(3 / 2))[1])
def XlsCrdString(self, ws, row, mode, nmb, cxy, pxy, l, ang, rmb):
# ws - объект worksheet
# row - номер строки
# mode - вид ведомости
# nmb - кортеж вида (i, i) - номера точек
# cxy - кортеж вида (f, f) - координаты текущей точки
# pxy - кортеж вида (f, f) - координаты предыдущей точки
# l - длина
# ang - кортеж вида (d, m.mm) - дирекционный угол
# rmb - кортеж вида (d, m.mm) - румб
if mode == 0:
ws.Rows[row].RowHeight = 25
ws.Cells[row, 1] = str(nmb[0])
ws.Cells[row, 1].Borders[1].LineStyle = 1
ws.Cells[row, 1].Borders[1].Weight = 3
ws.Cells[row, 1].HorizontalAlignment = 3
ws.Cells[row, 1].VerticalAlignment = 1
ws.Cells[row, 3] = '{0:10.2f}'.format(cxy[0])
ws.Cells[row, 3].Borders[1].LineStyle = 1
ws.Cells[row, 3].Borders[1].Weight = 3
ws.Cells[row, 3].NumberFormat = '0'+self.GetDcmlSep()+'00'
ws.Cells[row, 3].VerticalAlignment = 1
ws.Cells[row, 2] = '{0:10.2f}'.format(cxy[1])
ws.Cells[row, 2].Borders[1].LineStyle = 1
ws.Cells[row, 2].Borders[1].Weight = 3
ws.Cells[row, 2].NumberFormat = '0'+self.GetDcmlSep()+'00'
ws.Cells[row, 2].VerticalAlignment = 1
if l > 0:
ws.Cells[row, 4] = '{0:10.2f}'.format(l)
ws.Cells[row, 4].Borders[1].LineStyle = 1
ws.Cells[row, 4].Borders[1].Weight = 3
ws.Cells[row, 4].NumberFormat = '0'+self.GetDcmlSep()+'00'
ws.Cells[row, 4].HorizontalAlignment = 3
if (ang[0] >= 0) and (ang[1] >= 0) and (ang[2] >= 0):
ws.Cells[row, 5] = u'%(deg)02d° %(mnt)02d.%(dmnt)02d\'' % {'deg':ang[0], 'mnt':ang[1], 'dmnt':ang[2]}
ws.Cells[row, 5].Borders[1].LineStyle = 1
ws.Cells[row, 5].Borders[1].Weight = 3
ws.Cells[row, 5].Borders[2].LineStyle = 1
ws.Cells[row, 5].Borders[2].Weight = 3
ws.Cells[row, 5].HorizontalAlignment = 3
return row + 1
elif mode == 1:
ws.Cells[row, 1] = str(nmb[0])
ws.Cells[row, 1].BorderAround(1,3,1,1)
ws.Cells[row, 1].HorizontalAlignment = 3
ws.Cells[row, 3] = '{0:10.2f}'.format(cxy[0])
ws.Cells[row, 3].BorderAround(1,3,1,1)
ws.Cells[row, 3].NumberFormat = '0'+self.GetDcmlSep()+'00'
ws.Cells[row, 2] = '{0:10.2f}'.format(cxy[1])
ws.Cells[row, 2].BorderAround(1,3,1,1)
ws.Cells[row, 2].NumberFormat = '0'+self.GetDcmlSep()+'00'
return row + 1
elif mode == 2:
ws.Cells[row, 1] = str(nmb[0])
ws.Cells[row, 1].Borders[1].LineStyle = 1
ws.Cells[row, 1].Borders[1].Weight = 3
ws.Cells[row, 1].Borders[2].LineStyle = 1
ws.Cells[row, 1].Borders[2].Weight = 3
ws.Cells[row, 1].HorizontalAlignment = 3
ws.Cells[row, 4] = 'X='
ws.Cells[row, 4].HorizontalAlignment = 3
ws.Cells[row, 5] = '{0:10.2f}'.format(cxy[0])
ws.Cells[row, 5].NumberFormat = '0'+self.GetDcmlSep()+'00'
ws.Cells[row, 6] = 'Y='
ws.Cells[row, 6].HorizontalAlignment = 3
ws.Cells[row, 7] = '{0:10.2f}'.format(cxy[1])
ws.Cells[row, 7].NumberFormat = '0'+self.GetDcmlSep()+'00'
ws.Cells[row, 7].Borders[2].LineStyle = 1
ws.Cells[row, 7].Borders[2].Weight = 3
if l >= 0:
for i in xrange(1,5):
ws.Cells[row+i, 1].Borders[1].LineStyle = 1
ws.Cells[row+i, 1].Borders[1].Weight = 3
ws.Cells[row+i, 1].Borders[2].LineStyle = 1
ws.Cells[row+i, 1].Borders[2].Weight = 3
ws.Cells[row+i, 7].Borders[2].LineStyle = 1
ws.Cells[row+i, 7].Borders[2].Weight = 3
for i in xrange(1,8):
ws.Cells[row+4, i].Borders[4].LineStyle = 1
ws.Cells[row+4, i].Borders[4].Weight = 3
ws.Cells[row+1, 2] = u'элемент'
ws.Cells[row+1, 2].HorizontalAlignment = 2
ws.Cells[row+1, 3] = u'прямая'
ws.Cells[row+1, 3].HorizontalAlignment = 2
ws.Cells[row+2, 2] = u'дирекционное направление'
ws.Cells[row+2, 2].HorizontalAlignment = 2
ws.Cells[row+2, 3] = u'%(deg)02d° %(mnt)02d\' %(dmnt)02d\"' % {'deg':ang[0], 'mnt':ang[1], 'dmnt':ang[2]/100*60}
ws.Cells[row+2, 3].HorizontalAlignment = 2
ws.Cells[row+3, 2] = u'расстояние'
ws.Cells[row+3, 2].HorizontalAlignment = 2
ws.Cells[row+3, 3] = '{0:10.2f}'.format(l)
ws.Cells[row+3, 3].HorizontalAlignment = 2
ws.Cells[row+4, 2] = u'точка'
ws.Cells[row+4, 2].HorizontalAlignment = 2
ws.Cells[row+4, 3] = nmb[1]
ws.Cells[row+4, 3].HorizontalAlignment = 2
ws.Cells[row+4, 4] = 'X='
ws.Cells[row+4, 4].HorizontalAlignment = 3
ws.Cells[row+4, 5] = '{0:10.2f}'.format(pxy[0])
ws.Cells[row+4, 5].NumberFormat = '0'+self.GetDcmlSep()+'00'
ws.Cells[row+4, 6] = 'Y='
ws.Cells[row+4, 6].HorizontalAlignment = 3
ws.Cells[row+4, 7] = '{0:10.2f}'.format(pxy[1])
ws.Cells[row+4, 7].NumberFormat = '0'+self.GetDcmlSep()+'00'
return row + 5
else:
for i in xrange(1,8):
ws.Cells[row, i].Borders[4].LineStyle = 1
ws.Cells[row, i].Borders[4].Weight = 3
return row + 1
elif mode == 3:
ws.Cells[row, 1] = str('\x27' + nmb[0] + ' - ' + nmb[1])
ws.Cells[row, 1].BorderAround(1,3,1,1)
ws.Cells[row, 1].HorizontalAlignment = 3
if l > 0:
ws.Cells[row, 4] = '{0:10.2f}'.format(l)
ws.Cells[row, 4].BorderAround(1,3,1,1)
ws.Cells[row, 4].NumberFormat = '0'+self.GetDcmlSep()+'00'
ws.Cells[row, 4].HorizontalAlignment = 3
if (rmb[0] >= 0) and (rmb[1] >= 0) and (rmb[2] >= 0):
ws.Cells[row, 3] = u'%(deg)02d° %(mnt)02d.%(dmnt)02d\'' % {'deg':rmb[0], 'mnt':rmb[1], 'dmnt':rmb[2]}
ws.Cells[row, 2] = rmb[3]
ws.Cells[row, 3].BorderAround(1,3,1,1)
ws.Cells[row, 3].HorizontalAlignment = 3
ws.Cells[row, 2].BorderAround(1,3,1,1)
ws.Cells[row, 2].HorizontalAlignment = 3
return row + 1
elif mode == 4:
ws.Cells[row, 1] = str('\x27' + nmb[0] + ' - ' + nmb[1])
ws.Cells[row, 1].BorderAround(1,3,1,1)
ws.Cells[row, 1].HorizontalAlignment = 3
ws.Cells[row, 1] = str(nmb[0])
ws.Cells[row, 1].BorderAround(1,3,1,1)
ws.Cells[row, 1].HorizontalAlignment = 3
ws.Cells[row, 3] = '{0:10.0f}'.format(cxy[0])
ws.Cells[row, 3].BorderAround(1,3,1,1)
ws.Cells[row, 3].NumberFormat = '0'
ws.Cells[row, 2] = '{0:10.0f}'.format(cxy[1])
ws.Cells[row, 2].BorderAround(1,3,1,1)
ws.Cells[row, 2].NumberFormat = '0'
return row + 1
def XlsUnderline(self, ws, row):
for j in xrange(1,6):
ws.Cells[row, j].Borders[4].LineStyle = 1
ws.Cells[row, j].Borders[4].Weight = 3
ws.Rows[row].RowHeight = 15
def XlsHdrString(self, ws, row, mode):
x = 1
if mode < 2:
ws.Cells[row, 1] = u'Номер точки'
ws.Cells[row, 1].BorderAround(1,3,1,1)
ws.Cells[row, 1].HorizontalAlignment = 3
ws.Cells[row, 2] = u'X, м'
ws.Cells[row, 2].BorderAround(1,3,1,1)
ws.Cells[row, 3] = u'Y, м'
ws.Cells[row, 3].BorderAround(1,3,1,1)
if mode == 0:
ws.Cells[row, 4] = u'Длина, м'
ws.Cells[row, 4].BorderAround(1,3,1,1)
ws.Cells[row, 5] = u'Дирекционный угол'
ws.Cells[row, 5].BorderAround(1,3,1,1)
elif mode == 2:
ws.Cells[row, 1] = u'№ точки'
ws.Cells[row, 1].BorderAround(1,3,1,1)
ws.Cells[row, 1].HorizontalAlignment = 3
ws.Cells[row, 2].Borders[3].LineStyle = 1
ws.Cells[row, 2].Borders[3].Weight = 3
ws.Cells[row, 2].Borders[4].LineStyle = 1
ws.Cells[row, 2].Borders[4].Weight = 3
ws.Cells[row, 3].Borders[3].LineStyle = 1
ws.Cells[row, 3].Borders[3].Weight = 3
ws.Cells[row, 3].Borders[4].LineStyle = 1
ws.Cells[row, 3].Borders[4].Weight = 3
ws.Cells[row, 4].Borders[3].LineStyle = 1
ws.Cells[row, 4].Borders[3].Weight = 3
ws.Cells[row, 4].Borders[4].LineStyle = 1
ws.Cells[row, 4].Borders[4].Weight = 3
ws.Cells[row, 5].Borders[3].LineStyle = 1
ws.Cells[row, 5].Borders[3].Weight = 3
ws.Cells[row, 5].Borders[4].LineStyle = 1
ws.Cells[row, 5].Borders[4].Weight = 3
ws.Cells[row, 6].Borders[3].LineStyle = 1
ws.Cells[row, 6].Borders[3].Weight = 3
ws.Cells[row, 6].Borders[4].LineStyle = 1
ws.Cells[row, 6].Borders[4].Weight = 3
ws.Cells[row, 7].Borders[3].LineStyle = 1
ws.Cells[row, 7].Borders[3].Weight = 3
ws.Cells[row, 7].Borders[4].LineStyle = 1
ws.Cells[row, 7].Borders[4].Weight = 3
ws.Cells[row, 7].Borders[2].LineStyle = 1
ws.Cells[row, 7].Borders[2].Weight = 3
elif mode == 3:
ws.Cells[row, 1] = u'№ точек'
ws.Cells[row, 1].BorderAround(1,3,1,1)
ws.Cells[row, 1].HorizontalAlignment = 3
ws.Cells[row, 2] = u'Направление'
ws.Cells[row, 2].BorderAround(1,3,1,1)
ws.Cells[row, 3] = u'Румб линии'
ws.Cells[row, 3].BorderAround(1,3,1,1)
ws.Cells[row, 4] = u'Длина линии, м'
ws.Cells[row, 4].BorderAround(1,3,1,1)
elif mode == 4:
ws.Cells[row, 1] = u'Обозначение характерных точек границ'
st = 'A'+str(row)+':A'+str(row+1)
ws.Range[st].Merge()
ws.Range[st].Borders[1].LineStyle = 1
ws.Range[st].Borders[1].Weight = 3
ws.Range[st].Borders[2].LineStyle = 1
ws.Range[st].Borders[2].Weight = 3
ws.Range[st].Borders[3].LineStyle = 1
ws.Range[st].Borders[3].Weight = 3
ws.Range[st].Borders[4].LineStyle = 1
ws.Range[st].Borders[4].Weight = 3
ws.Range[st].HorizontalAlignment = 3
ws.Range[st].VerticalAlignment = 2
ws.Cells[row, 2] = u'Координаты, м'
st = 'B'+str(row)+':C'+str(row)
ws.Range[st].Merge()
ws.Range[st].Borders[1].LineStyle = 1
ws.Range[st].Borders[1].Weight = 3
ws.Range[st].Borders[2].LineStyle = 1
ws.Range[st].Borders[2].Weight = 3
ws.Range[st].Borders[3].LineStyle = 1
ws.Range[st].Borders[3].Weight = 3
ws.Range[st].Borders[4].LineStyle = 1
ws.Range[st].Borders[4].Weight = 3
ws.Range[st].HorizontalAlignment = 3
ws.Cells[row+1, 2] = u'X, м'
ws.Cells[row+1, 2].BorderAround(1,3,1,1)
ws.Cells[row+1, 3] = u'Y, м'
ws.Cells[row+1, 3].BorderAround(1,3,1,1)
x += 1
return row + x
def ToExcel(self):
xls = CreateObject("Excel.Application")
xls.WorkBooks.Add()
S = xls.WorkBooks[1].WorkSheets[1]
if self.DicReports.values().index(self.RepVar.get()) < 2:
S.Columns[1].ColumnWidth = 5 + len(self.nprefix)
S.Columns[2].ColumnWidth = 10
S.Columns[3].ColumnWidth = 10
if self.DicReports.values().index(self.RepVar.get()) == 0:
S.Columns[4].ColumnWidth = 9
S.Columns[5].ColumnWidth = 15
elif self.DicReports.values().index(self.RepVar.get()) == 2:
S.Columns[1].ColumnWidth = 10 + len(self.nprefix)
S.Columns[2].ColumnWidth = 30
S.Columns[3].ColumnWidth = 10
S.Columns[4].ColumnWidth = 3
S.Columns[5].ColumnWidth = 10
S.Columns[6].ColumnWidth = 3
S.Columns[7].ColumnWidth = 10
elif self.DicReports.values().index(self.RepVar.get()) == 4:
S.Columns[1].ColumnWidth = 50
S.Columns[2].ColumnWidth = 10
S.Columns[3].ColumnWidth = 10
xls.Visible = True
ROW = 0
if self.DicReports.values().index(self.RepVar.get()) == 2:
ROW += 1
S.Cells[ROW, 1] = u'ВЕДОМОСТЬ КООРДИНАТ ТОЧЕК ГРАНИЦЫ ТЕХНИЧЕСКОЙ ЗОНЫ ЛИНЕЙНОГО ОБЪЕКТА'
elif self.DicReports.values().index(self.RepVar.get()) == 4:
ROW += 1
S.Cells[ROW, 1] = u'Схема расположения земельного участка или земельных участков'
ROW += 1
S.Cells[ROW, 1] = u'на кадастровом плане территории'
lxy = [] # Сквозная нумерация точек
pxy = [] # Список точек внутри участка для исключения дублирования строк в ведомости
i = 1 # Порядковый номер участка
_len = -1
_ra = -1
tsq = 0.0
if len(self.PLineCrd) > 1:
for crdlst in self.PLineCrd:
tsq += crdlst['sq']
st = u'Общая площадь земельных участков '
s1 = str(trunc(tsq))
s2 = '{0:'+str(len(s1))+'.0f}'
ROW += 1
S.Cells[ROW, 1] = st + s2.format(tsq) + u' кв.м.'
for crdlst in self.PLineCrd:
if self.DicReports.values().index(self.RepVar.get()) < 4:
ROW += 1
st = u'Участок '
S.Cells[ROW, 1] = st + self.nprefix + str(i + self.startnumprclfrom - 1)
ROW += 1
st = u'Площадь '
s1 = str(trunc(crdlst['sq']))
s2 = '{0:'+str(len(s1))+'.0f}'
S.Cells[ROW, 1] = st + s2.format(crdlst['sq']) + u' кв.м.'
elif self.DicReports.values().index(self.RepVar.get()) == 4:
# Ведомость для схемы на КПТ по приказу 762
if len(self.PLineCrd) > 1:
ROW += 1
st = u'Условный номер земельного участка ЗУ'
S.Cells[ROW, 1] = st + self.nprefix + str(i + self.startnumprclfrom - 1)
ROW += 1
st = u'Площадь земельного участка '
s1 = str(trunc(crdlst['sq']))
s2 = '{0:'+str(len(s1))+'.0f}'
S.Cells[ROW, 1] = st + s2.format(crdlst['sq']) + u' кв.м.'
self.MarkParcel(crdlst, self.nprefix + str(i + self.startnumprclfrom - 1), 'Numbers')
ROW += 1
ROW = self.XlsHdrString(S, ROW, self.DicReports.values().index(self.RepVar.get()))
del pxy[0:len(pxy)]
j = 1
for txy in crdlst['crd']:
if lxy.count(txy) == 0:
lxy.append(txy)
if len(str(lxy.index(txy)+self.startnumpntfrom)) > 3:
num = self.nprefix + ' ' + str(lxy.index(txy)+self.startnumpntfrom)
else:
num = self.nprefix + str(lxy.index(txy)+self.startnumpntfrom)
self.MarkPoint(txy, num, 'Numbers')
if pxy.count(txy) == 0:
pxy.append(txy)
if j == 1:
txy1 = txy
j += 1
if self.DicReports.values().index(self.RepVar.get()) < 2:
for j in xrange(0,len(pxy)):
if j < len(pxy)-1:
_len = self.Pifagor(pxy[j], pxy[j+1])
_da = self.dir_angl(pxy[j], pxy[j+1])
else:
_len = self.Pifagor(pxy[j], txy1)
_da = self.dir_angl(pxy[j], txy1)
ROW = self.XlsCrdString(S, ROW, self.DicReports.values().index(self.RepVar.get()),
(self.nprefix.encode('cp1251') + str(lxy.index(pxy[j]) + self.startnumpntfrom), '-'),
(pxy[j][0], pxy[j][1]), (-1, -1), _len, _da, (-1,-1,-1,'-'))
_len = -1
ROW = self.XlsCrdString(S, ROW, self.DicReports.values().index(self.RepVar.get()),
(self.nprefix.encode('cp1251') + str(lxy.index(txy1)+self.startnumpntfrom), '-'),
(txy1[0], txy1[1]), (-1, -1), _len, (-1,-1,-1), (-1,-1,-1,'-'))
if self.DicReports.values().index(self.RepVar.get()) == 0:
self.XlsUnderline(S, ROW-1)
elif self.DicReports.values().index(self.RepVar.get()) == 2:
for j in xrange(0,len(pxy)):
if j == 0:
_len = -1
_da = (-1,-1,-1)
else:
_len = self.Pifagor(txy1, pxy[j])
_da = self.dir_angl(txy1, pxy[j])
ROW = self.XlsCrdString(S, ROW, self.DicReports.values().index(self.RepVar.get()),
(self.nprefix.encode('cp1251') + str(lxy.index(pxy[j]) + self.startnumpntfrom), self.nprefix.encode('cp1251') + str(lxy.index(txy1) + self.startnumpntfrom)),
(pxy[j][0], pxy[j][1]), txy1, _len, _da,(-1,-1,-1,'-'))
txy1 = pxy[j]
elif self.DicReports.values().index(self.RepVar.get()) == 3:
for j in xrange(0,len(pxy)):
if j < len(pxy)-1:
_len = self.Pifagor(pxy[j], pxy[j+1])
_ra = self.rmb_angl(pxy[j], pxy[j+1])
ROW = self.XlsCrdString(S, ROW, self.DicReports.values().index(self.RepVar.get()),
(self.nprefix.encode('cp1251') + str(lxy.index(pxy[j]) + self.startnumpntfrom), self.nprefix.encode('cp1251') + str(lxy.index(pxy[j+1]) + self.startnumpntfrom)),
(pxy[j][0], pxy[j][1]), (-1, -1), _len, (-1,-1,-1), _ra)
else:
_len = self.Pifagor(pxy[j], pxy[0])
_ra = self.rmb_angl(pxy[j], pxy[0])
ROW = self.XlsCrdString(S, ROW, self.DicReports.values().index(self.RepVar.get()),
(self.nprefix.encode('cp1251') + str(lxy.index(pxy[j])+self.startnumpntfrom), self.nprefix.encode('cp1251') + str(lxy.index(pxy[0])+self.startnumpntfrom)),
(pxy[j][0], pxy[j][1]), (-1, -1), _len, (-1,-1,-1), _ra)
_len = -1
elif self.DicReports.values().index(self.RepVar.get()) == 4:
for j in xrange(0,len(pxy)):
ROW = self.XlsCrdString(S, ROW, self.DicReports.values().index(self.RepVar.get()),
(self.nprefix.encode('cp1251') + str(lxy.index(pxy[j]) + self.startnumpntfrom), self.nprefix.encode('cp1251') + str(lxy.index(pxy[j]) + self.startnumpntfrom)),
(pxy[j][0], pxy[j][1]), (-1, -1), _len, (-1,-1,-1), _ra)
i += 1
def Quit(self):
self.master.destroy()
def btn1_press(self):
self.nprefix = self.master.etr1.get()
self.startnumpntfrom = int(self.master.etr2.get())
self.startnumprclfrom = int(self.master.etr3.get())
self.SortPntList()
self.ToExcel()
def ConnectACAD(self):
# errcode - возвращаемое значение
# 0 - все Ок
# 1 - AutoCAD не запущен
# 2 - не открыто ни одного чертежа
errcode = 0
try:
self.acad = GetActiveObject("AutoCAD.Application")
except:
errcode = 1
if errcode == 0:
try:
self.dwg = self.acad.ActiveDocument
except:
errcode = 2
if errcode == 0:
self.mspace = self.dwg.ModelSpace
self.master.title(self.title+' - '+self.dwg.Name)
for x in xrange(0,self.dwg.Layers.Count):
self.lmenu.add_command(label = self.dwg.Layers[x].Name, command = lambda x = x: self.SetActiveLayer(x))
self.LayrVar.set(self.lmenu.entrycget(0, 'label'))
self.LayerObjects(self.lmenu.entrycget(0, 'label'))
try:
lay = self.dwg.Layers('Numbers')
except:
lay = self.dwg.Layers.Add('Numbers')
lay.Color = 253
lay.IsPlot = False
return errcode
def SetActiveLayer(self, idx):
self.LayrVar.set(self.lmenu.entrycget(idx, 'label'))
self.LayerObjects(self.lmenu.entrycget(idx, 'label'))
def SetActiveScale(self, idx):
self.SclVar.set(self.smenu.entrycget(idx, 'label'))
def SetActiveReport(self, idx):
self.RepVar.set(self.rmenu.entrycget(idx, 'label'))
self.LayerObjects(self.LayrVar.get())
def ResetCoord(self):
del self.PLineCrd[0:len(self.PLineCrd)]
def CollectCoord(self, coords):
dic_pl = {}
tmplst = []
if (len(coords) % 2 == 0):
if (len(coords) % 3 > 0):
# Делится на 2, не делится на 3
crdx = coords[0:len(coords)-1:2]
crdy = coords[1:len(coords):2]
else:
# Делится и на 2, и на 3
crdx = coords[0:len(coords)-2:3]
crdy = coords[1:len(coords)-1:3]
crdz = coords[2:len(coords):3]
zst = set(crdz)
if len(zst) > 1: # Если не все z одинаковые - делить на 2
crdx = coords[0:len(coords)-1:2]
crdy = coords[1:len(coords):2]
else:
# Не делится на 2
crdx = coords[0:len(coords)-2:3]
crdy = coords[1:len(coords)-1:3]
crdz = coords[2:len(coords):3]
for j in xrange(0,len(crdx)):
if self.DicReports.values().index(self.RepVar.get()) < 4:
txy = (round(crdx[j],2), round(crdy[j],2))
elif self.DicReports.values().index(self.RepVar.get()) == 4:
txy = (round(crdx[j],0), round(crdy[j],0))
tmplst.append(txy)
dic_pl['sq'] = self.area(tmplst)
dic_pl['crd'] = tmplst
self.PLineCrd.append(dic_pl)
def area(self, lxy):
area = 0
args = lxy
for i in xrange(len(args)):
x1, y1 = args[i - 1]
x2, y2 = args[i]
area += x1*y2 - x2*y1
return fabs(area / 2)
def SwapPntLst(self, lst, dir):
reslst = {}
if dir == 1:
SP = self.GetNordPnt(lst['crd'])
elif dir == 2:
SP = self.GetWestPnt(lst['crd'])
elif dir == 3:
SP = self.GetSouthPnt(lst['crd'])
else:
SP = self.GetEastPnt(lst['crd'])
j = lst['crd'].index(SP)
lst1 = lst['crd'][j:len(lst['crd'])]
lst2 = lst['crd'][0:j ]
lst3 = []
lst3.extend(lst1)
lst3.extend(lst2)
reslst['sq'] = lst['sq']
reslst['crd'] = lst3
return reslst
def SortPntList(self):
lxy = [] # Список уникальных пар X Y
tmplst = [] # Копия основного списка контуров PLineCrd
looplst = [] # Временный список текущих контуров для итерации
reslst = [] # Список отсортированных контуров
fndlst = [] # Временный список для найденных соседних контуров - живет в течение одной итерации
lidx = [] # Список индексов контуров, найденных в tmplst в ходе итерации
nmbdir = 0 # Направление нумерации: 1 - от севера, 2 - от запада, 3 - от юга, 4 - от востока
tmplst.extend(self.PLineCrd)
for crdlst in tmplst:
for txy in crdlst['crd']:
if lxy.count(txy) == 0:
lxy.append(txy)
NP = self.GetNordPnt(lxy)
SP = self.GetSouthPnt(lxy)
WP = self.GetWestPnt(lxy)
EP = self.GetEastPnt(lxy)
if self.RBVar.get() == 1: # Автоматический выбор направления
deltax = EP[0] - WP[0]
deltay = NP[1] - SP[1]
if deltay >= deltax: # Ориентация север - юг
nmbdir = 1
for crdlst in tmplst:
if NP in crdlst['crd']:
idx = tmplst.index(crdlst)
else: # Ориентация запад - восток
nmbdir = 2
for crdlst in tmplst:
if WP in crdlst['crd']:
idx = tmplst.index(crdlst)
elif self.RBVar.get() == 2: # Принудительно от севера
nmbdir = 1
for crdlst in tmplst:
if NP in crdlst['crd']:
idx = tmplst.index(crdlst)
elif self.RBVar.get() == 3: # Принудительно от запада
nmbdir = 2
for crdlst in tmplst:
if WP in crdlst['crd']:
idx = tmplst.index(crdlst)
elif self.RBVar.get() == 4: # Принудительно от юга
nmbdir = 3
for crdlst in tmplst:
if SP in crdlst['crd']:
idx = tmplst.index(crdlst)
else: # Принудительно от востока
nmbdir = 4
for crdlst in tmplst:
if EP in crdlst['crd']:
idx = tmplst.index(crdlst)
# Берем первый контур по найденному индексу
tmpcrd = self.SwapPntLst(tmplst.pop(idx), nmbdir)
reslst.insert(0,tmpcrd)
looplst.append(tmpcrd)
while len(tmplst) > 1:
del lidx[0:len(lidx)]
for tmpcrd in looplst:
idx = -1
m1 = set(tmpcrd['crd'])
for crdlst in tmplst:
m2 = set(crdlst['crd'])
if len(m1 & m2) > 0: # Если мощность пересечения больше нуля - соседний участок найден
idx = tmplst.index(crdlst)
if not idx in lidx:
lidx.append(idx)
i = 0
for idx in lidx:
idx -= i # Сдвиг индекса в случае удаления нескольких записей (на 2 шаге -1 и т.д.)
i += 1
tmpcrd = self.SwapPntLst(tmplst.pop(idx), nmbdir)
fndlst.append(tmpcrd)
if (idx == -1) and (len(lidx) == 0): # если разрыв в трассе
del lxy[0:len(lxy)]
for crdlst in tmplst:
for txy in crdlst['crd']:
if lxy.count(txy) == 0:
lxy.append(txy)
# Крайние точки оставшихся участков
NP = self.GetNordPnt(lxy)
SP = self.GetSouthPnt(lxy)
WP = self.GetWestPnt(lxy)
EP = self.GetEastPnt(lxy)
idx = 0
minlen = 100000
for tmpcrd in looplst:
for txy in tmpcrd['crd']:
nlen = self.Pifagor(txy, NP)
slen = self.Pifagor(txy, SP)
wlen = self.Pifagor(txy, WP)
elen = self.Pifagor(txy, EP)
if nlen < minlen:
minlen = nlen
PP = NP
if slen < minlen:
minlen = slen
PP = SP
if wlen < minlen:
minlen = wlen
PP = WP
if elen < minlen:
minlen = elen
PP = EP
for crdlst in tmplst:
if PP in crdlst['crd']: # если ближайшая точка принадлежит контуру - ближайший участок найден
idx = tmplst.index(crdlst)
tmpcrd = self.SwapPntLst(tmplst.pop(idx), nmbdir)
fndlst.append(tmpcrd)
del looplst[0:len(looplst)]
looplst.extend(fndlst)
del fndlst[0:len(fndlst)]
reslst.extend(looplst)
# последний оставшийся контур (если есть) также не забыть "свапнуть" и добавить в reslst
if len(tmplst) > 0:
tmpcrd = self.SwapPntLst(tmplst.pop(0), nmbdir)
reslst.append(tmpcrd)
self.ResetCoord()
self.PLineCrd.extend(reslst)
def Pifagor(self, t1, t2): # на вход - два кортежа вида (x, y), на выходе float - расстояние между точками
return sqrt((t1[0] - t2[0]) * (t1[0] - t2[0]) + (t1[1] - t2[1]) * (t1[1] - t2[1]))
def dir_angl(self, t1, t2): # на вход - два кортежа вида (x, y), на выходе кортеж вида (d, m, dm)
da = degrees(acos(fabs(t1[1] - t2[1]) / self.Pifagor(t1, t2)))
if (t1[0] < t2[0]) and (t1[1] > t2[1]): # 2 координатная четверть
da = 180 - da
elif (t1[0] >= t2[0]) and (t1[1] >= t2[1]): # 3 координатная четверть
da = 180 + da
elif (t1[0] > t2[0]) and (t1[1] <= t2[1]): # 4 координатная четверть
da = 360 - da
return (trunc(da), trunc(modf(da)[0] * 60), trunc((modf(da)[0] * 60 - modf(modf(da)[0] * 60)[1]) * 100 ))
def rmb_angl(self, t1, t2):
da = degrees(acos(fabs(t1[1] - t2[1]) / self.Pifagor(t1, t2)))
st = self.TplRumb[0]
if (t1[0] < t2[0]) and (t1[1] > t2[1]): # 2 координатная четверть
st = self.TplRumb[1]
elif (t1[0] >= t2[0]) and (t1[1] >= t2[1]): # 3 координатная четверть
st = self.TplRumb[2]
elif (t1[0] > t2[0]) and (t1[1] <= t2[1]): # 4 координатная четверть
st = self.TplRumb[3]
return (trunc(da), trunc(modf(da)[0] * 60), trunc((modf(da)[0] * 60 - modf(modf(da)[0] * 60)[1]) * 100 ), st)
def GetNordPnt(self, crdlst):
# crdlst - список кортежей вида (X, Y)
rxy = crdlst[0]
for txy in crdlst:
if txy[1] > rxy[1]:
rxy = txy
return rxy
def GetSouthPnt(self, crdlst):
rxy = crdlst[0]
for txy in crdlst:
if txy[1] < rxy[1]:
rxy = txy
return rxy
def GetEastPnt(self, crdlst):
rxy = crdlst[0]
for txy in crdlst:
if txy[0] > rxy[0]:
rxy = txy
return rxy
def GetWestPnt(self, crdlst):
rxy = crdlst[0]
for txy in crdlst:
if txy[0] < rxy[0]:
rxy = txy
return rxy
def LayerObjects(self, LName):
self.master.entitys.delete(0, END)
self.master.btn1.configure(state = DISABLED)
self.ResetCoord()
ocnt = [0]*45
for entity in self.mspace:
if entity.Layer == LName:
ocnt[entity.EntityType] += 1
if entity.EntityType in (23,24):
self.CollectCoord(entity.Coordinates)
for oc in xrange(1,len(ocnt)):
if ocnt[oc] > 0:
self.master.entitys.insert(END, self.DicObjType[oc]+' ('+str(oc)+')'+' - '+str(ocnt[oc]))
if self.master.entitys.size() > 0:
self.master.btn1.configure(state = NORMAL)
def MarkPoint(self, xy, num, lay):
'''
http://stackoverflow.com/questions/10166064/python-win32com-and-2-dimensional-arrays
# Попытка передать variant([ent,]) в AppendOuterLoop вызывает ComTypeError
import collections
def variant(data):
return VARIANT(VT_VARIANT, data)
def vararr(*data):
if ( len(data) == 1 and
isinstance(data, collections.Iterable) ):
data = data[0]
return map(variant, data)
'''
def point(*args):
lst = [0.]*3
if len(args) < 3:
lst[0:2] = [float(x) for x in args[0:2]]
else:
lst = [float(x) for x in args[0:3]]
return VARIANT(array("d",lst))
txthght = 1.0
txtshft = 0.3
crclrd = 0.3
mltplr = self.DicScales.values().index(self.SclVar.get())
if mltplr > 0:
txthght *= mltplr
txtshft *= mltplr
crclrd *= mltplr
p1 = point(xy[0], xy[1])
ent = self.mspace.AddCircle(p1, crclrd)
ent.Layer = lay
#print(ent.Handle)
#htch = self.mspace.AddHatch(0, 'SOLID', False)
#htch.AppendOuterLoop(vararr([int(ent.Handle, 16),])))
#htch.Evaluate()
#htch.Layer = lay
p1 = point(xy[0]+txtshft, xy[1]+txtshft)
sh = len(num)
if (len(self.nprefix) > 0) and (len(num.replace(self.nprefix, '')) > 3):
sh = sh // 2
th = string.Template('\H'+str(txthght)+';$n')
ent = self.mspace.AddMText(p1, sh, th.substitute(n=num))
ent.LineSpacingFactor = 0.7
ent.Layer = lay
def MarkParcel(self, lxy, num, lay):
def point(*args):
lst = [0.]*3
if len(args) < 3:
lst[0:2] = [float(x) for x in args[0:2]]
else:
lst = [float(x) for x in args[0:3]]
return VARIANT(array("d",lst))
def points(*args):
lst = [float(x) for x in args[0:len(args)]]
return VARIANT(array('d',lst))
txthght = 2.0
mltplr = self.DicScales.values().index(self.SclVar.get())
if mltplr > 0:
txthght *= mltplr
NP = self.GetNordPnt(lxy['crd'])
SP = self.GetSouthPnt(lxy['crd'])
WP = self.GetWestPnt(lxy['crd'])
EP = self.GetEastPnt(lxy['crd'])
x = (WP[0] + EP[0]) // 2
y = (NP[1] + SP[1]) // 2
p1 = point(x,y+txthght / 3)
ent = self.mspace.AddText(num, p1, txthght)
ent.Layer = lay
p1 = point(x,y-txthght-txthght / 3)
s1 = str(trunc(lxy['sq']))
s2 = '{0:'+str(len(s1))+'.0f}'
ent = self.mspace.AddText(s2.format(lxy['sq']), p1, txthght)
ent.Layer = lay
ent = self.mspace.AddPolyline(points(x,y,0.0,x+len(s1)*txthght,y,0.0))
ent.Layer = lay
menu = Menu(root)
acctMenu = Menu(menu, tearoff=0)
menu.add_command(label="Update", command=oneShotUpdate)
menu.add_command(label="Console", command=showConsole)
menu.add_command(label="Search", command=hashThreader)
menu.add_command(label="Delete last tweet", command=delThreader)
menu.add_command(label="Shorten link", command=shortThreader)
menu.add_cascade(label="Accounts", menu=acctMenu)
menu.add_separator()
menu.add_command(label="Quit", command=lambda: quit(UPDATE_THREAD))
for acct in cred_man.getScreenNames():
acctMenu.add_command(label=acct, command=lambda: switchToAcct(acct))
acctMenu.entryconfig(0, label="*" + acctMenu.entrycget(0, "label"))
acctMenu.add_command(label="Add Account", command=addAccount)
root.config(menu=menu)
#
# END OF TK GUI STUFF
#
# tries to start a thread that will keep the character count
# see the docs on the numbers function
try:
NUMBER_THREAD = upThread(1, "numbers", entry)
NUMBER_THREAD.start()
except:
