1
|
|
|
from datetime import date, datetime, timedelta |
2
|
|
|
from enum import StrEnum |
3
|
|
|
|
4
|
|
|
import PySimpleGUI as sg |
5
|
|
|
from satcfdi.pacs.sat import TipoDescargaMasivaTerceros |
6
|
|
|
# noinspection PyUnresolvedReferences |
7
|
|
|
from satcfdi.transform.catalog import CATALOGS |
8
|
|
|
from satdigitalinvoice.gui_functions import mf_pago_fmt, CALENDAR_FECHA_FMT |
9
|
|
|
|
10
|
|
|
from .log_tools import * |
11
|
|
|
|
12
|
|
|
FORMA_PAGO = CATALOGS['{http://www.sat.gob.mx/sitio_internet/cfd/catalogos}c_FormaPago'] |
13
|
|
|
TEXT_PADDING = ((5, 0), 3) |
14
|
|
|
|
15
|
|
|
# 24 x 24 |
16
|
|
|
FOLDER_ICON = "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAAsTAAALEwEAmpwYAAAAqElEQVR4nO3UsQnCYBRF4U/EAcRJtHUJcQddwQlsxcpVLF0hOoY2FlaC+SUQQWI0PmwscuF0j3PhFZc2" \ |
17
|
|
|
"/5QR9siRnjhhid6vBVlFXGWHwS8Ft4aCHLPydozFGybo1BV8kl8wLe/muDbcryIFBwzRxbpB/OAcfV8f2y/lD17y7qcbHIPy2oKoILUFqX1RdCpSgMIVHrsUoHDVznVWM9cpQF46imlp8ye5AyE7C1To4" \ |
18
|
|
|
"/HLAAAAAElFTkSuQmCC" |
19
|
|
|
|
20
|
|
|
EXCEL_ICON = "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAAsTAAALEwEAmpwYAAAA7klEQVR4nN2VQQqCUBCGv2pfFyhv0FmC7hGFq1bhrgi6gi1cBK6CdhFtvYdCi6CgrZsXwgTyUNOnLmrgBx31" \ |
21
|
|
|
"/+DNOAP/HkNgCqyBK3AHLsDA1HAELIEjcANUjuYm5hbwKDBVKTnyjZ5/ATugkwWwS5qrAsBHkyyA0yBg1SQgAraiSHueCwgBL3V" \ |
22
|
|
|
"/kFwWwAd6Ir8swJXcSZTEvsIRfQXEwFg6y5LruElAogDoioKma1AF4JvUoPUjctsucqi1qVfQpsY1KPuj+SY1qDsqnLaH3SJvF9Qd1wp4ilethTOT9zea7CLzsivzDPSrmPx2vAFRfA9plcmcVwAAAABJRU5ErkJggg==" |
23
|
|
|
|
24
|
|
|
HTML_ICON = "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAAsTAAALEwEAmpwYAAAA/ElEQVR4nN2VOwoCMRCGPz2HB7ARHyfwBN5EsLOxWKzs7Ox0e69gYbOtoK2dZ7BVRwZGWJbsJvuw0IGfDUkmX" \ |
25
|
|
|
"/gzm8A/xgi4AC9AHNLo1gGccxaWFCAC1lUBz0CAVIVICYAYpPVNgJSF+ABtYOHoXzcF6AMdYAmsMuo1ATgZpJTvZQAScEa5ETcAiIsA+vcmDm9XgUpsjUJ7tASnGV1tTL8z26VeKTdgAOwz5esFqA6mKDX2WUR3ebe" \ |
26
|
|
|
"+MXCsAkhMLsAGmNQBZC3C7MHRpxY9rO0FvMyWeUUdfIe8a6BMt9S8rqVAmlv7wZECaa43RjYx78kUh3Su5gxDAL8Vb7wE7yjidnvCAAAAAElFTkSuQmCC" |
27
|
|
|
|
28
|
|
|
PDF_ICON = "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAAsTAAALEwEAmpwYAAAA+0lEQVR4nN3VPUrEQBQA4E89gCBio7WI" \ |
29
|
|
|
"+INbeAbxAoI3ESzEysoFd21tbe28QixE7a2t7dxGRwKvWCTrTpJNoQ9ek5k3X8hM5vEfo4cXfCFVZBkbbYDnCQunMeAM" \ |
30
|
|
|
"/abAZyaQmiKpBpACmesSSHWRacA8Tiue92cF7GIN57j4kduzAB4DqfXdc4ACQ3xk7FEjYBk7GHQFrOMQl10BJ3GC7roC3mL8vivgNsYXsYmlyKIt8IojLOAYV1jFQWz6sA1QxOnZwv" \ |
31
|
|
|
"7YFf6OG1xj1AYYRH9YwVPGT5jqXtejeMuHzMXL2tYNJ/2SZe3U6MXESS0zVWQ5t6zZywH+VnwDCQv1frFQIlYAAAAASUVORK5CYII=" |
32
|
|
|
|
33
|
|
|
ABOUT_ICON = "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAAsTAAALEwEAmpwYAAABP0lEQVR4nOWVTU7DMBCFvxuwKmrX0G4o5QLtQboDFXEbwrLkGNDucwB" \ |
34
|
|
|
"+VvQObS5ApCxAIz1LCNmOG68QTxopst882y/jMfwHnAIroAQ2ilJjgxzhkYRa4AvYA6" \ |
35
|
|
|
"+KvcZacYx7FBZADXwC98DUw7GxAmjEXRwjbkkfwHkCfyyu5cy7yCPtxhJOUnckruUcgGGMWMqWs8D8UhE6iZ3iMVYtrTwPoVKEUEjDW123qowL" \ |
36
|
|
|
"+uNSGjche6z8YlhGLHI4hGzaAi8dyVWHReiePPsmNprMXeAdeOprUZWwQB2yaKUfNM1Y4Eoa17EyLTIWeIiVqbOp0aXx4U7hw0S565RWsevRKnYpreJ3sxsniE8kntTsHObaTaN" \ |
37
|
|
|
"/MvNwZvK8ETdZ3GGocnMPjom8KeofD846xZYYBuotJmQ31MK+bSzryfwb+AbymF7gpXVM1QAAAABJRU5ErkJggg==" |
38
|
|
|
|
39
|
|
|
REFRESH_ICON = "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAAsTAAALEwEAmpwYAAABGUlEQVR4nO3VzSqFURTG8Z8JYmRiJN9yDQYiKbdhYqDO9OQWyMSQDGRISoYMlHIJJEWZ" \ |
40
|
|
|
"+v4oysTRrqU4nePdZej91+ptt3frWWu31/NS8kdaMINNXOANLzjFGia/ne3CdHyzGMUxarjBNpawgt0QSnsHGA6xWp1oU8bxhGvMorXBmQ5UQugO1VyBITziBD0ZxQziCh+5Aoe4z0y+ELEeyQsF0r2" \ |
41
|
|
|
"/Y14etQZR2EE32jIFSv4Z7fFAfuVr3Osjh0o88ZFcgS0sRhTRF9OffEmOQBr7S/RnJO/FWUz" \ |
42
|
|
|
"/QK5ANQzsOVrvbHA2DeMcbvGAsYxiflhuMr39WCfH3AurXsZOFJD2joruXcFPYwKr4a6po1ecYwNTuYlLNOMTqXpPNQBv/ywAAAAASUVORK5CYII=" |
43
|
|
|
|
44
|
|
|
PREVIEW_ICON = "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAAsTAAALEwEAmpwYAAABKElEQVR4nO2VMU8CQRCFP6WAQksqOxJ/A6WJUFFprJSEilARWgsa" \ |
45
|
|
|
"/4IVLYUNFZ0WVECwNxpCIDQYfwEVGj0zycNcCOTulqMxvGQze2/eztub3O3Cf0QJ6IQYD8CRi8Ed4AUUn0rTczFZGoTRfLmYRDG4Aj6BAXC8C4M80NC8H/ZNohh4K6Mel0FGu" \ |
46
|
|
|
"/cPT2tjMViHvUEg9i0KxBmQjeszPVSxCnCrmBW/lUECqAKzDX/yTPmEi0EaeFauq0JDzU+BG809HX7pKAYnwAiYA9fi7qVr+jZgKEo30rqNBh2dlAe65Yx7BJLStX2teQFa4i3/JN7WBV6Z5+JrwA/wKu4S" \ |
47
|
|
|
"+FYhixdADniTzvSRUQDeVXSsNiwUJ+ItbzpnpICy2vAhA4v2bLzl//ALOtSCJzC7jH4AAAAASUVORK5CYII=" |
48
|
|
|
|
49
|
|
|
SEARCH_ICON = "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAAsTAAALEwEAmpwYAAABM0lEQVR4nOXTuytAYRzG8Y8RJTPJ5jJIitwGoxiZGSTZDAaDTQaJhYWBf0A" \ |
50
|
|
|
"WRDHjD7BIMrkUg2wol079lEGc1yXJU2c4b8/5Pu/vfZ/Df1MjJrGKLSyjHyVfBZdjE0+4wwH2cB5rVxj8LLwmQNcYeWO3TdiOoJlUeDGOcIbqd3wFmI2QgZSAcTyiPYc3C9nBZcq" \ |
51
|
|
|
"dnGAjYUPNMUVfHnNlmIcSArIpLrCUx9wSAZ3StB8V/lD1EdCTGJBVeCVvg+4wlQAvxT0m8n6wERUtyukfjakb8ga04QELOby1uMGaxFbsxq4W49jeUke05xRlKfD5gO/GJBlkGr3" \ |
52
|
|
|
"ownA0JvsZD1H1Gfh8vLdiHbex/vIcYwyFX4G/VnbhdRFYIVEZbO7VmRekAn4Nnqn7nWP5NnX9JNyf1DM+Yku7BVpvYgAAAABJRU5ErkJggg==" |
53
|
|
|
|
54
|
|
|
CONFIG_ICON = "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAAsTAAALEwEAmpwYAAABPElEQVR4nOWVvWoCQRSFP5NCSJHOdGkECaa3s" \ |
55
|
|
|
"/MtUu6CYOcTaGMZU2efwNYtrKwkWPgK9nmAEC38IRMGTmCZrIMru6B44MLOmXPP7N6ZvQPXgiowdcJyueEFMMBMYcTlhjfgG7hR2OfhqWYB0AEqQBnoA1/APKGZi" \ |
56
|
|
|
"+tLU1GOzfXiEVirBDvgE9gA70A9oauL20izU85aHgcxAlZACxgAH0DDo29IM1DOSh6paAI/QJQyVwJCIFaE4lxE8rBe//AALIA90HbMY5VgqTDikou0lbuQVyrugIkMnsSFGttN/ENHnJ1DWqNc6+FFV" \ |
57
|
|
|
"+J7jWO9tYul5pDWKJc8FxhnXSBriQKNa8eUqPBNbh5xTMeK4JRjWviP5msVkdMqnsVts7aKtGbX8zS7XtZmdwhDff5tol2/ckkXTrXoK/N88Qvnr38CSEQRlwAAAABJRU5ErkJggg==" |
58
|
|
|
|
59
|
|
|
EDIT_ICON = "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAAsTAAALEwEAmpwYAAAA10lEQVR4nO3UPUpDQRSG4cfCQgn" \ |
60
|
|
|
"+LSPLSCcEC1u3EXdgEXdg3EC2IXYS0N4itZWWGkGvDHyBkE45Npq3usyB95tz5s6w4ZfZwwQveMIFtqvkB5jhDZe4xmdCyuQdxivrk3RSIl/gAe84Ta118oytCvkQPdwmZJxxXVXJl/TSSZd6O/hvs4+7yE" \ |
61
|
|
|
"/Wasd4xT2ONvIl/3gsuys3dLRWGyZ0ll/2RwwiX2SnZ5XyxnkerD5uEjKqkjemmOe7H3FXJW885rGaR9xVyg/xkZBpxjXIwZewU7VTf4ovf6VSMafchm4AAAAASUVORK5CYII=" |
62
|
|
|
|
63
|
|
|
ZIP_ICON = "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAAsTAAALEwEAmpwYAAAAt0lEQVR4nOXVPQrCQBCG4Qd7wTPYWtulsPAa5hq2KS0svYRnSKuNvZ3aWXgDESQibBECgWQl4s8HA8vAzMs3u" \ |
64
|
|
|
"+zwi0qRR0baBJChiGhehNrGgLYq/gcwxSICsAi1n6NJsF1U7FfPz9hj1BYwDLa3ocmsBrDBBesYF32csUOvBnDCFasYwBJ3jEu5KuAYmg9iRnTDAXMkNYBGT/OVS858mpIwkraal8b4439R9i5A3tXC6Xxl" \ |
65
|
|
|
"+io9AMiJawPDOx2QAAAAAElFTkSuQmCC" |
66
|
|
|
|
67
|
|
|
IMPORT_CSV = "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAAsTAAALEwEAmpwYAAABVElEQVR4nN3Vv0scYRDG8U+EQApjl4AIAYMIFqIEhGAnpLBJIRZ2goV" \ |
68
|
|
|
"/gZIiIqY8rkklIb2VlWjAYq1yXGVvlzSSIlqKkZjIhoM5OJaL9+6qCTgwsDs7z3zfeff9wX20RWQJvoX+KoB3yHsU/xI5n6tA2oCUnF9VIGUA87hEE4/vAvAKH+K5kdpJGUBe8LXbAjyP0Xd6HtrkZVrWstD+f+vDW" \ |
69
|
|
|
"+xiLmLj2MZHPCl0WbrjhZjPb7EEh3CEU/zAOpYiZxKf8LUMYCPEI6jFDz3DYfhYdPEb7/ET9TKAbqtoGt9xheWINWInt3KnygDehKjWIR7GaxzjIPJW43treh5EbBY7eHQdoFXsJMRNPMRmvJ" \ |
70
|
|
|
"/jZeSNRqzeUfwiYvu9IAN4EcXFCCcwWMibwdNC8bwXpL1LU+0Z9grHePtYX6l6VPzNkrQpF07WxZMBqVdmVhVwE/v3gD+of4e/h7E8SwAAAABJRU5ErkJggg==" |
71
|
|
|
|
72
|
|
|
BUTTON_COLOR = (sg.theme_background_color(), sg.theme_background_color()) |
73
|
|
|
LARGE_FONT = ("Courier New", 11, "bold") |
74
|
|
|
PERIODO_FMT = "%Y-%m" |
75
|
|
|
|
76
|
|
|
|
77
|
|
|
class TipoRecuperar(StrEnum): |
78
|
|
|
Emitidas = 'Emitidas' |
79
|
|
|
Recibidas = 'Recibidas' |
80
|
|
|
|
81
|
|
|
|
82
|
|
|
class SearchOptions(StrEnum): |
83
|
|
|
PorPagar = 'Por Pagar' |
84
|
|
|
PorEnviar = 'Por Enviar' |
85
|
|
|
Hoy = datetime.now().strftime(CALENDAR_FECHA_FMT) |
86
|
|
|
Mes = datetime.now().strftime(PERIODO_FMT) |
87
|
|
|
Anio = datetime.now().strftime("%Y") |
88
|
|
|
|
89
|
|
|
|
90
|
|
|
class MyTable(sg.Table): |
91
|
|
|
def __init__(self, key, headings, row_fn): |
92
|
|
|
super().__init__( |
93
|
|
|
values=[], |
94
|
|
|
key=key, |
95
|
|
|
headings=headings, |
96
|
|
|
expand_x=True, |
97
|
|
|
expand_y=True, |
98
|
|
|
select_mode=sg.TABLE_SELECT_MODE_EXTENDED, |
99
|
|
|
enable_events=True, |
100
|
|
|
text_color="black", |
101
|
|
|
background_color="white", |
102
|
|
|
# headings=HEADINGS, |
103
|
|
|
# values=[], |
104
|
|
|
# auto_size_columns=False, |
105
|
|
|
# col_widths=COL_WIDTHS, |
106
|
|
|
# justification="center", |
107
|
|
|
# num_rows=20, |
108
|
|
|
alternating_row_color="grey95", # "aliceblue", |
109
|
|
|
# row_height=ROW_HEIGHT, |
110
|
|
|
# header_text_color="white", |
111
|
|
|
# header_background_color="darkblue", |
112
|
|
|
# font=FONT, |
113
|
|
|
# bind_return_key=True, |
114
|
|
|
# tooltip="Doble click para ver factura", |
115
|
|
|
# right_click_menu=RIGHT_CLICK_MENU |
116
|
|
|
metadata=True |
117
|
|
|
) |
118
|
|
|
self.row_fn = row_fn |
119
|
|
|
|
120
|
|
|
def selected_items(self): |
121
|
|
|
return [self.metadata[i] for i in self.SelectedRows] |
122
|
|
|
|
123
|
|
|
def select_all(self): |
124
|
|
|
self.update( |
125
|
|
|
select_rows=list(range(len(self.metadata))) |
126
|
|
|
) |
127
|
|
|
|
128
|
|
|
def delete_selected(self): |
129
|
|
|
|
130
|
|
|
def iter_metadata(): |
131
|
|
|
s = 0 |
132
|
|
|
for i in self.SelectedRows + [len(self.metadata)]: |
133
|
|
|
for j in range(s, i): |
134
|
|
|
yield self.metadata[j] |
135
|
|
|
s = i + 1 |
136
|
|
|
|
137
|
|
|
self.update( |
138
|
|
|
values=list(iter_metadata()) |
139
|
|
|
) |
140
|
|
|
|
141
|
|
|
def update(self, values=None, **kwargs): |
142
|
|
|
if values is not None: |
143
|
|
|
super().update( |
144
|
|
|
values=[ |
145
|
|
|
self.row_fn(i, item) |
146
|
|
|
for i, item in enumerate(values, start=1) |
147
|
|
|
], |
148
|
|
|
**kwargs |
149
|
|
|
) |
150
|
|
|
self.metadata = values |
151
|
|
|
else: |
152
|
|
|
super().update(**kwargs) |
153
|
|
|
|
154
|
|
|
def refresh(self): |
155
|
|
|
self.update( |
156
|
|
|
self.metadata, |
157
|
|
|
select_rows=self.SelectedRows |
158
|
|
|
) |
159
|
|
|
|
160
|
|
|
|
161
|
|
|
def make_layout(has_fiel, local_db): |
162
|
|
|
# ----- Full layout ----- |
163
|
|
|
return [ |
164
|
|
|
[ |
165
|
|
|
sg.TabGroup( |
166
|
|
|
[[ |
167
|
|
|
sg.Tab( |
168
|
|
|
'Emitidas '.center(13), |
169
|
|
|
[ |
170
|
|
|
[ |
171
|
|
|
sg.Column([[ |
172
|
|
|
sg.ButtonMenu( |
173
|
|
|
image_data=SEARCH_ICON, button_text="", key="buscar_facturas", border_width=0, button_color=BUTTON_COLOR, |
174
|
|
|
menu_def=[ |
175
|
|
|
[], |
176
|
|
|
[str(o) for o in SearchOptions], |
177
|
|
|
], |
178
|
|
|
), |
179
|
|
|
sg.Input(datetime.now().strftime(PERIODO_FMT), size=(40, 1), key="emitidas_search"), |
180
|
|
|
sg.Push(), |
181
|
|
|
sg.Button(image_data=IMPORT_CSV, key="importar_emitidas", border_width=0, button_color=BUTTON_COLOR), |
182
|
|
|
]], |
183
|
|
|
expand_x=True |
184
|
|
|
) |
185
|
|
|
], |
186
|
|
|
[ |
187
|
|
|
sg.HorizontalSeparator(color="black"), |
188
|
|
|
], |
189
|
|
|
[ |
190
|
|
|
sg.Column([[ |
191
|
|
|
sg.Button("".ljust(10), key="status_sat", border_width=0, button_color=sg.theme_background_color()), |
192
|
|
|
sg.Button("".ljust(10), key="email_notificada", border_width=0, button_color=sg.theme_background_color()), |
193
|
|
|
sg.Button("".ljust(10), key="pendiente_pago", border_width=0, button_color=sg.theme_background_color()), |
194
|
|
|
]]), |
195
|
|
|
sg.VSeparator(color="black"), |
196
|
|
|
sg.Column([[ |
197
|
|
|
sg.CalendarButton("FechaPago:", format=CALENDAR_FECHA_FMT, title="FechaPago", no_titlebar=False, target="fecha_pago", pad=TEXT_PADDING, |
198
|
|
|
border_width=0), |
199
|
|
|
sg.Input(datetime.now().strftime(CALENDAR_FECHA_FMT), size=(12, 1), key="fecha_pago"), |
200
|
|
|
sg.Text("FormaPago:", pad=TEXT_PADDING, border_width=0), |
201
|
|
|
sg.Combo([Code(k, v) for k, v in FORMA_PAGO.items()], |
202
|
|
|
default_value=Code("03", FORMA_PAGO["03"]), key="forma_pago", size=(35, 1)), |
203
|
|
|
sg.Text("ImpPagado:", pad=TEXT_PADDING, border_width=0), |
204
|
|
|
sg.Input("", size=(12, 1), key="importe_pago"), |
205
|
|
|
]], visible=False, key="ppd_action_items"), |
206
|
|
|
], |
207
|
|
|
[ |
208
|
|
|
MyTable( |
209
|
|
|
key="emitidas_table", |
210
|
|
|
headings=[ |
211
|
|
|
'#', |
212
|
|
|
'Receptor Razon Social', |
213
|
|
|
'Recep. Rfc', |
214
|
|
|
'Factura', |
215
|
|
|
"Fecha", |
216
|
|
|
"Total", |
217
|
|
|
"Pendiente", |
218
|
|
|
"Status", |
219
|
|
|
"Tipo", |
220
|
|
|
"Folio" |
221
|
|
|
], |
222
|
|
|
row_fn=lambda i, r: [ |
223
|
|
|
i, |
224
|
|
|
r['Receptor'].get('Nombre', ''), |
225
|
|
|
r['Receptor']['Rfc'], |
226
|
|
|
r.name, |
227
|
|
|
r["Fecha"].strftime(CALENDAR_FECHA_FMT), |
228
|
|
|
r["Total"], |
229
|
|
|
r.saldo_pendiente if r.saldo_pendiente else "", |
230
|
|
|
str(local_db.liquidated_state(r)) + str(" 📧" if local_db.notified(r) else " "), |
231
|
|
|
mf_pago_fmt(r), |
232
|
|
|
r.uuid |
233
|
|
|
] |
234
|
|
|
) |
235
|
|
|
]], |
236
|
|
|
key='emitidas_tab', |
237
|
|
|
), |
238
|
|
|
sg.Tab( |
239
|
|
|
'Facturas '.center(13), |
240
|
|
|
[ |
241
|
|
|
[ |
242
|
|
|
sg.Button(image_data=EDIT_ICON, key="editar_facturas", border_width=0, button_color=BUTTON_COLOR), |
243
|
|
|
sg.Text("Periodo:", pad=TEXT_PADDING), |
244
|
|
|
sg.Input(date.today().strftime(PERIODO_FMT), size=(11, 1), key="facturas_periodo"), |
245
|
|
|
sg.Text("", pad=TEXT_PADDING, key="preparar_facturas_text", font=LARGE_FONT), |
246
|
|
|
], |
247
|
|
|
[ |
248
|
|
|
MyTable( |
249
|
|
|
key="facturas_table", |
250
|
|
|
headings=[ |
251
|
|
|
'#', |
252
|
|
|
'EReg', |
253
|
|
|
'Receptor Razon Social', |
254
|
|
|
'Recep. Rfc', |
255
|
|
|
"Tipo", |
256
|
|
|
"Subtotal", |
257
|
|
|
"Total" |
258
|
|
|
], |
259
|
|
|
row_fn=lambda i, r: [ |
260
|
|
|
i, |
261
|
|
|
r['Emisor']['RegimenFiscal'].code, |
262
|
|
|
r['Receptor']['Nombre'], |
263
|
|
|
r['Receptor']['Rfc'], |
264
|
|
|
mf_pago_fmt(r), |
265
|
|
|
r['SubTotal'], |
266
|
|
|
r['Total'] |
267
|
|
|
] |
268
|
|
|
) |
269
|
|
|
]], |
270
|
|
|
key='facturas_tab', |
271
|
|
|
), |
272
|
|
|
sg.Tab( |
273
|
|
|
'Correos'.center(13), |
274
|
|
|
[ |
275
|
|
|
[ |
276
|
|
|
sg.Text("", pad=TEXT_PADDING), |
277
|
|
|
], |
278
|
|
|
[ |
279
|
|
|
MyTable( |
280
|
|
|
key="correos_table", |
281
|
|
|
headings=[ |
282
|
|
|
'#', |
283
|
|
|
'Receptor Razon Social', |
284
|
|
|
'Recep. Rfc', |
285
|
|
|
'Facturas', |
286
|
|
|
'Pendientes Emitidas Meses Anteriores' |
287
|
|
|
], |
288
|
|
|
row_fn=lambda i, r: [ |
289
|
|
|
i, |
290
|
|
|
r[0]["RazonSocial"], |
291
|
|
|
r[0]["Rfc"], |
292
|
|
|
",".join(n.name for n in r[1]), |
293
|
|
|
",".join(n.name for n in r[2]) |
294
|
|
|
] |
295
|
|
|
) |
296
|
|
|
]], |
297
|
|
|
key='correos_tab', |
298
|
|
|
), |
299
|
|
|
sg.Tab( |
300
|
|
|
'Ajustes'.center(13), |
301
|
|
|
[ |
302
|
|
|
[ |
303
|
|
|
sg.Button(image_data=EDIT_ICON, key="editar_ajustes", border_width=0, button_color=BUTTON_COLOR), |
304
|
|
|
sg.Text("Periodo:", pad=TEXT_PADDING), |
305
|
|
|
sg.Input(date.today().strftime(PERIODO_FMT), size=(11, 1), key="ajustes_periodo"), |
306
|
|
|
sg.Text("", pad=TEXT_PADDING, key="preparar_ajustes_text", font=LARGE_FONT), |
307
|
|
|
], |
308
|
|
|
[ |
309
|
|
|
MyTable( |
310
|
|
|
key="ajustes_table", |
311
|
|
|
headings=[ |
312
|
|
|
"#", |
313
|
|
|
"Receptor Razon Social", |
314
|
|
|
"Recep. Rfc", |
315
|
|
|
"Actual", |
316
|
|
|
"Nuevo", |
317
|
|
|
"Ajuste %", |
318
|
|
|
"Periodo", |
319
|
|
|
"Meses", |
320
|
|
|
"Ajuste Efectivo" |
321
|
|
|
], |
322
|
|
|
row_fn=lambda i, r: [ |
323
|
|
|
i, |
324
|
|
|
r["receptor"]["RazonSocial"], |
325
|
|
|
r["receptor"]["Rfc"], |
326
|
|
|
r["valor_unitario"], |
327
|
|
|
r["valor_unitario_nuevo"], |
328
|
|
|
r["ajuste_porcentaje"], |
329
|
|
|
r["periodo"], |
330
|
|
|
r["meses"], |
331
|
|
|
r["efectivo_periodo_desc"] |
332
|
|
|
] |
333
|
|
|
) |
334
|
|
|
]], |
335
|
|
|
key='ajustes_tab' |
336
|
|
|
), |
337
|
|
|
sg.Tab( |
338
|
|
|
'Clientes '.center(13), |
339
|
|
|
[ |
340
|
|
|
[ |
341
|
|
|
sg.Button(image_data=EDIT_ICON, key="editar_clientes", border_width=0, button_color=BUTTON_COLOR), |
342
|
|
|
sg.Push(), |
343
|
|
|
sg.Button("Exportar", key="exportar_clientes", border_width=0), |
344
|
|
|
], |
345
|
|
|
[ |
346
|
|
|
MyTable( |
347
|
|
|
key="clientes_table", |
348
|
|
|
headings=[ |
349
|
|
|
"#", |
350
|
|
|
"Razon Social", |
351
|
|
|
"Rfc", |
352
|
|
|
"Reg", |
353
|
|
|
"CP", |
354
|
|
|
"IdCIF" |
355
|
|
|
], |
356
|
|
|
row_fn=lambda i, r: [ |
357
|
|
|
i, |
358
|
|
|
r["RazonSocial"], |
359
|
|
|
r["Rfc"], |
360
|
|
|
r["RegimenFiscal"].code, |
361
|
|
|
r["CodigoPostal"], |
362
|
|
|
r["IdCIF"] |
363
|
|
|
] |
364
|
|
|
) |
365
|
|
|
]], |
366
|
|
|
key='clientes_tab', |
367
|
|
|
), |
368
|
|
|
sg.Tab( |
369
|
|
|
'Solicitudes'.center(13), |
370
|
|
|
[ |
371
|
|
|
[ |
372
|
|
|
sg.Column([[ |
373
|
|
|
sg.Button(image_data=ZIP_ICON, key="cargar_zip", border_width=0, button_color=BUTTON_COLOR), |
374
|
|
|
sg.Text("Recuperar:", pad=TEXT_PADDING), |
375
|
|
|
sg.Combo([TipoRecuperar.Recibidas, TipoRecuperar.Emitidas], default_value=TipoRecuperar.Recibidas, key="tipo_recuperar", size=(10, 1)), |
376
|
|
|
|
377
|
|
|
sg.CalendarButton("Inicio:", format=CALENDAR_FECHA_FMT, title="Inicio", no_titlebar=False, target="fecha_inicial", pad=TEXT_PADDING, |
378
|
|
|
border_width=0), |
379
|
|
|
sg.Input((datetime.now() - timedelta(days=40)).strftime(CALENDAR_FECHA_FMT), size=(12, 1), key="fecha_inicial"), |
380
|
|
|
|
381
|
|
|
sg.CalendarButton("Final:", format=CALENDAR_FECHA_FMT, title="Final", no_titlebar=False, target="fecha_final", pad=TEXT_PADDING, |
382
|
|
|
border_width=0), |
383
|
|
|
sg.Input(datetime.now().strftime(CALENDAR_FECHA_FMT), size=(12, 1), key="fecha_final"), |
384
|
|
|
|
385
|
|
|
sg.Text("Tipo:", pad=TEXT_PADDING), |
386
|
|
|
sg.Combo([TipoDescargaMasivaTerceros.CFDI, TipoDescargaMasivaTerceros.Metadata], default_value=TipoDescargaMasivaTerceros.CFDI, |
387
|
|
|
key="tipo_solicitud", size=(10, 1)), |
388
|
|
|
|
389
|
|
|
sg.Button("Nueva Solicitud", key="nueva_solicitud", border_width=0), |
390
|
|
|
]], |
391
|
|
|
expand_x=True |
392
|
|
|
) |
393
|
|
|
], |
394
|
|
|
[ |
395
|
|
|
MyTable( |
396
|
|
|
key="solicitudes_table", |
397
|
|
|
headings=[ |
398
|
|
|
"#", |
399
|
|
|
"IdSolicitud", |
400
|
|
|
"Mensaje", |
401
|
|
|
"EstadoSolicitud", |
402
|
|
|
"FechaInicial", |
403
|
|
|
"FechaFinal", |
404
|
|
|
"TipoSolicitud", |
405
|
|
|
"RfcReceptor", |
406
|
|
|
"RfcEmisor", |
407
|
|
|
], |
408
|
|
|
row_fn=lambda i, r: [ |
409
|
|
|
i, |
410
|
|
|
r["response"]["IdSolicitud"], |
411
|
|
|
r["response"]["Mensaje"], |
412
|
|
|
r["response"].get("EstadoSolicitud", ""), |
413
|
|
|
r["request"]["fecha_inicial"].strftime(CALENDAR_FECHA_FMT), |
414
|
|
|
r["request"]["fecha_final"].strftime(CALENDAR_FECHA_FMT), |
415
|
|
|
r["request"]["tipo_solicitud"], |
416
|
|
|
r["request"]["rfc_receptor"] or "", |
417
|
|
|
r["request"]["rfc_emisor"] or "", |
418
|
|
|
] |
419
|
|
|
) |
420
|
|
|
] |
421
|
|
|
], |
422
|
|
|
key='solicitudes_tab', |
423
|
|
|
# visible=has_fiel |
424
|
|
|
), |
425
|
|
|
sg.Tab( |
426
|
|
|
'Contabilidad '.center(13), |
427
|
|
|
[[ |
428
|
|
|
sg.Column([[ |
429
|
|
|
sg.Button(image_data=EDIT_ICON, key="editar_configurar", border_width=0, button_color=BUTTON_COLOR), |
430
|
|
|
sg.Text("Periodo:", pad=TEXT_PADDING), |
431
|
|
|
sg.Input(date.today().strftime(PERIODO_FMT), size=(11, 1), key="periodo"), |
432
|
|
|
sg.Button(image_data=EXCEL_ICON, key="ver_excel", border_width=0, button_color=BUTTON_COLOR), |
433
|
|
|
sg.Button(image_data=FOLDER_ICON, key="ver_carpeta", border_width=0, button_color=BUTTON_COLOR), |
434
|
|
|
sg.Button("SAT Status", key="sat_status_todas", border_width=0), |
435
|
|
|
]]) |
436
|
|
|
]], |
437
|
|
|
key='contabilidad_tab', |
438
|
|
|
), |
439
|
|
|
sg.Tab( |
440
|
|
|
'Consola'.center(13), |
441
|
|
|
[ |
442
|
|
|
[ |
443
|
|
|
sg.Push(), |
444
|
|
|
sg.Button(image_data=ABOUT_ICON, key="about", border_width=0, button_color=BUTTON_COLOR), |
445
|
|
|
], |
446
|
|
|
[sg.Multiline( |
447
|
|
|
expand_x=True, |
448
|
|
|
expand_y=True, |
449
|
|
|
key="console", |
450
|
|
|
write_only=True, |
451
|
|
|
autoscroll=True, |
452
|
|
|
reroute_stdout=True |
453
|
|
|
)] |
454
|
|
|
], |
455
|
|
|
key='console_tab', |
456
|
|
|
), |
457
|
|
|
sg.Tab( |
458
|
|
|
'Configuracion'.center(13), |
459
|
|
|
[ |
460
|
|
|
[ |
461
|
|
|
sg.Column([[ |
462
|
|
|
sg.Button(image_data=CONFIG_ICON, key="ver_config", border_width=0, button_color=BUTTON_COLOR), |
463
|
|
|
sg.Text("Proxima Factura:", pad=TEXT_PADDING), |
464
|
|
|
sg.Text("Serie:", pad=TEXT_PADDING), |
465
|
|
|
sg.Input("", key="serie", size=(8, 1)), |
466
|
|
|
sg.Text("Folio:", pad=TEXT_PADDING), |
467
|
|
|
sg.Input("", key="folio", size=(8, 1)), |
468
|
|
|
]], |
469
|
|
|
expand_x=True |
470
|
|
|
) |
471
|
|
|
], |
472
|
|
|
[ |
473
|
|
|
sg.Column([[ |
474
|
|
|
sg.Button("Organizar Facturas", key="organizar_facturas", border_width=0), |
475
|
|
|
]], |
476
|
|
|
expand_x=True |
477
|
|
|
) |
478
|
|
|
], |
479
|
|
|
[ |
480
|
|
|
sg.Column([[ |
481
|
|
|
sg.Button("Exportar Metadata", key="exportar_metadata", border_width=0), |
482
|
|
|
sg.Button("Importar Metadata", key="importar_metadata", border_width=0), |
483
|
|
|
]], |
484
|
|
|
expand_x=True |
485
|
|
|
) |
486
|
|
|
] |
487
|
|
|
], |
488
|
|
|
key='configuracion_tab', |
489
|
|
|
), |
490
|
|
|
]], |
491
|
|
|
expand_x=True, |
492
|
|
|
expand_y=True, |
493
|
|
|
enable_events=True, |
494
|
|
|
key="main_tab_group", |
495
|
|
|
) |
496
|
|
|
], |
497
|
|
|
[ |
498
|
|
|
sg.Column([[ |
499
|
|
|
sg.Push(), |
500
|
|
|
sg.Text("Factura:", pad=TEXT_PADDING), |
501
|
|
|
sg.Text("", key="serie_folio", pad=TEXT_PADDING), |
502
|
|
|
sg.Button(image_data=PREVIEW_ICON, key="ver_preview", border_width=0, button_color=BUTTON_COLOR, disabled=True), |
503
|
|
|
sg.Button("".center(22), disabled=True, key="crear_facturas", border_width=0, button_color=sg.theme_background_color()), |
504
|
|
|
sg.Sizegrip(), |
505
|
|
|
]], |
506
|
|
|
expand_x=True, |
507
|
|
|
), |
508
|
|
|
] |
509
|
|
|
] |
510
|
|
|
|
511
|
|
|
|
512
|
|
|
class ActionButtonManager: |
513
|
|
|
def __init__(self, button, preview): |
514
|
|
|
self.name = "" |
515
|
|
|
self.items = [] |
516
|
|
|
self.button = button |
517
|
|
|
self.preview = preview |
518
|
|
|
|
519
|
|
|
def set_items(self, name, items): |
520
|
|
|
self.name = name |
521
|
|
|
self.items = items |
522
|
|
|
self.style_button() |
523
|
|
|
|
524
|
|
|
def clear(self): |
525
|
|
|
self.name = "" |
526
|
|
|
self.items = [] |
527
|
|
|
self.style_button() |
528
|
|
|
|
529
|
|
|
def text(self): |
530
|
|
|
header = "Procesar" |
531
|
|
|
if self.name == "clientes": |
532
|
|
|
header = "Validar" |
533
|
|
|
elif self.name in ("facturas", "pago"): |
534
|
|
|
header = "Crear" |
535
|
|
|
elif self.name == "correos": |
536
|
|
|
header = "Enviar" |
537
|
|
|
elif self.name == "ajustes": |
538
|
|
|
header = "Enviar" |
539
|
|
|
|
540
|
|
|
if self.items: |
541
|
|
|
return f"{header} {len(self.items)} {self.name.capitalize()}" |
542
|
|
|
else: |
543
|
|
|
return "" |
544
|
|
|
|
545
|
|
|
def style_button(self): |
546
|
|
|
self.preview.update( |
547
|
|
|
disabled=not (bool(self.items) and self.name in ("facturas", "pago")), |
548
|
|
|
) |
549
|
|
|
self.button.update( |
550
|
|
|
self.text().center(22), |
551
|
|
|
disabled=not self.items, |
552
|
|
|
button_color=sg.theme_button_color() if self.items else sg.theme_background_color() |
553
|
|
|
) |
554
|
|
|
|