Passed
Push — main ( ec7388...a0079b )
by Sat CFDI
01:46
created

satdigitalinvoice.layout.MyTable.select_all()   A

Complexity

Conditions 1

Size

Total Lines 3
Code Lines 3

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
eloc 3
dl 0
loc 3
rs 10
c 0
b 0
f 0
cc 1
nop 1
1
from datetime import date, datetime
2
3
import PySimpleGUI as sg
4
# noinspection PyUnresolvedReferences
5
from satcfdi.transform.catalog import CATALOGS
6
from satdigitalinvoice.gui_functions import mf_pago_fmt
7
8
from .log_tools import *
9
10
FORMA_PAGO = CATALOGS['{http://www.sat.gob.mx/sitio_internet/cfd/catalogos}c_FormaPago']
11
TEXT_PADDING = ((5, 0), 3)
12
13
# 24 x 24
14
FOLDER_ICON = "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAAsTAAALEwEAmpwYAAAAqElEQVR4nO3UsQnCYBRF4U/EAcRJtHUJcQddwQlsxcpVLF0hOoY2FlaC+SUQQWI0PmwscuF0j3PhFZc2" \
15
              "/5QR9siRnjhhid6vBVlFXGWHwS8Ft4aCHLPydozFGybo1BV8kl8wLe/muDbcryIFBwzRxbpB/OAcfV8f2y/lD17y7qcbHIPy2oKoILUFqX1RdCpSgMIVHrsUoHDVznVWM9cpQF46imlp8ye5AyE7C1To4" \
16
              "/HLAAAAAElFTkSuQmCC"
17
18
EXCEL_ICON = "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAAsTAAALEwEAmpwYAAAA7klEQVR4nN2VQQqCUBCGv2pfFyhv0FmC7hGFq1bhrgi6gi1cBK6CdhFtvYdCi6CgrZsXwgTyUNOnLmrgBx31" \
19
             "/+DNOAP/HkNgCqyBK3AHLsDA1HAELIEjcANUjuYm5hbwKDBVKTnyjZ5/ATugkwWwS5qrAsBHkyyA0yBg1SQgAraiSHueCwgBL3V" \
20
             "/kFwWwAd6Ir8swJXcSZTEvsIRfQXEwFg6y5LruElAogDoioKma1AF4JvUoPUjctsucqi1qVfQpsY1KPuj+SY1qDsqnLaH3SJvF9Qd1wp4ilethTOT9zea7CLzsivzDPSrmPx2vAFRfA9plcmcVwAAAABJRU5ErkJggg=="
21
22
HTML_ICON = "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAAsTAAALEwEAmpwYAAAA/ElEQVR4nN2VOwoCMRCGPz2HB7ARHyfwBN5EsLOxWKzs7Ox0e69gYbOtoK2dZ7BVRwZGWJbsJvuw0IGfDUkmX" \
23
            "/gzm8A/xgi4AC9AHNLo1gGccxaWFCAC1lUBz0CAVIVICYAYpPVNgJSF+ABtYOHoXzcF6AMdYAmsMuo1ATgZpJTvZQAScEa5ETcAiIsA+vcmDm9XgUpsjUJ7tASnGV1tTL8z26VeKTdgAOwz5esFqA6mKDX2WUR3ebe" \
24
            "+MXCsAkhMLsAGmNQBZC3C7MHRpxY9rO0FvMyWeUUdfIe8a6BMt9S8rqVAmlv7wZECaa43RjYx78kUh3Su5gxDAL8Vb7wE7yjidnvCAAAAAElFTkSuQmCC"
25
26
PDF_ICON = "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAAsTAAALEwEAmpwYAAAA+0lEQVR4nN3VPUrEQBQA4E89gCBio7WI" \
27
           "+INbeAbxAoI3ESzEysoFd21tbe28QixE7a2t7dxGRwKvWCTrTpJNoQ9ek5k3X8hM5vEfo4cXfCFVZBkbbYDnCQunMeAM" \
28
           "/abAZyaQmiKpBpACmesSSHWRacA8Tiue92cF7GIN57j4kduzAB4DqfXdc4ACQ3xk7FEjYBk7GHQFrOMQl10BJ3GC7roC3mL8vivgNsYXsYmlyKIt8IojLOAYV1jFQWz6sA1QxOnZwv" \
29
           "7YFf6OG1xj1AYYRH9YwVPGT5jqXtejeMuHzMXL2tYNJ/2SZe3U6MXESS0zVWQ5t6zZywH+VnwDCQv1frFQIlYAAAAASUVORK5CYII="
30
31
ABOUT_ICON = "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAAsTAAALEwEAmpwYAAABP0lEQVR4nOWVTU7DMBCFvxuwKmrX0G4o5QLtQboDFXEbwrLkGNDucwB" \
32
             "+VvQObS5ApCxAIz1LCNmOG68QTxopst882y/jMfwHnAIroAQ2ilJjgxzhkYRa4AvYA6" \
33
             "+KvcZacYx7FBZADXwC98DUw7GxAmjEXRwjbkkfwHkCfyyu5cy7yCPtxhJOUnckruUcgGGMWMqWs8D8UhE6iZ3iMVYtrTwPoVKEUEjDW123qowL" \
34
             "+uNSGjche6z8YlhGLHI4hGzaAi8dyVWHReiePPsmNprMXeAdeOprUZWwQB2yaKUfNM1Y4Eoa17EyLTIWeIiVqbOp0aXx4U7hw0S565RWsevRKnYpreJ3sxsniE8kntTsHObaTaN" \
35
             "/MvNwZvK8ETdZ3GGocnMPjom8KeofD846xZYYBuotJmQ31MK+bSzryfwb+AbymF7gpXVM1QAAAABJRU5ErkJggg=="
36
37
REFRESH_ICON = "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAAsTAAALEwEAmpwYAAABGUlEQVR4nO3VzSqFURTG8Z8JYmRiJN9yDQYiKbdhYqDO9OQWyMSQDGRISoYMlHIJJEWZ" \
38
               "+v4oysTRrqU4nePdZej91+ptt3frWWu31/NS8kdaMINNXOANLzjFGia/ne3CdHyzGMUxarjBNpawgt0QSnsHGA6xWp1oU8bxhGvMorXBmQ5UQugO1VyBITziBD0ZxQziCh+5Aoe4z0y+ELEeyQsF0r2" \
39
               "/Y14etQZR2EE32jIFSv4Z7fFAfuVr3Osjh0o88ZFcgS0sRhTRF9OffEmOQBr7S/RnJO/FWUz" \
40
               "/QK5ANQzsOVrvbHA2DeMcbvGAsYxiflhuMr39WCfH3AurXsZOFJD2joruXcFPYwKr4a6po1ecYwNTuYlLNOMTqXpPNQBv/ywAAAAASUVORK5CYII="
41
42
PREVIEW_ICON = "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAAsTAAALEwEAmpwYAAABKElEQVR4nO2VMU8CQRCFP6WAQksqOxJ/A6WJUFFprJSEilARWgsa" \
43
               "/4IVLYUNFZ0WVECwNxpCIDQYfwEVGj0zycNcCOTulqMxvGQze2/eztub3O3Cf0QJ6IQYD8CRi8Ed4AUUn0rTczFZGoTRfLmYRDG4Aj6BAXC8C4M80NC8H/ZNohh4K6Mel0FGu" \
44
               "/cPT2tjMViHvUEg9i0KxBmQjeszPVSxCnCrmBW/lUECqAKzDX/yTPmEi0EaeFauq0JDzU+BG809HX7pKAYnwAiYA9fi7qVr+jZgKEo30rqNBh2dlAe65Yx7BJLStX2teQFa4i3/JN7WBV6Z5+JrwA/wKu4S" \
45
               "+FYhixdADniTzvSRUQDeVXSsNiwUJ+ItbzpnpICy2vAhA4v2bLzl//ALOtSCJzC7jH4AAAAASUVORK5CYII="
46
47
SEARCH_ICON = "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAAsTAAALEwEAmpwYAAABM0lEQVR4nOXTuytAYRzG8Y8RJTPJ5jJIitwGoxiZGSTZDAaDTQaJhYWBf0A" \
48
              "WRDHjD7BIMrkUg2wol079lEGc1yXJU2c4b8/5Pu/vfZ/Df1MjJrGKLSyjHyVfBZdjE0+4wwH2cB5rVxj8LLwmQNcYeWO3TdiOoJlUeDGOcIbqd3wFmI2QgZSAcTyiPYc3C9nBZcq" \
49
              "dnGAjYUPNMUVfHnNlmIcSArIpLrCUx9wSAZ3StB8V/lD1EdCTGJBVeCVvg+4wlQAvxT0m8n6wERUtyukfjakb8ga04QELOby1uMGaxFbsxq4W49jeUke05xRlKfD5gO/GJBlkGr3" \
50
              "ownA0JvsZD1H1Gfh8vLdiHbex/vIcYwyFX4G/VnbhdRFYIVEZbO7VmRekAn4Nnqn7nWP5NnX9JNyf1DM+Yku7BVpvYgAAAABJRU5ErkJggg=="
51
52
CONFIG_ICON = "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAAsTAAALEwEAmpwYAAABPElEQVR4nOWVvWoCQRSFP5NCSJHOdGkECaa3s" \
53
              "/MtUu6CYOcTaGMZU2efwNYtrKwkWPgK9nmAEC38IRMGTmCZrIMru6B44MLOmXPP7N6ZvQPXgiowdcJyueEFMMBMYcTlhjfgG7hR2OfhqWYB0AEqQBnoA1/APKGZi" \
54
              "+tLU1GOzfXiEVirBDvgE9gA70A9oauL20izU85aHgcxAlZACxgAH0DDo29IM1DOSh6paAI/QJQyVwJCIFaE4lxE8rBe//AALIA90HbMY5VgqTDikou0lbuQVyrugIkMnsSFGttN/ENHnJ1DWqNc6+FFV" \
55
              "+J7jWO9tYul5pDWKJc8FxhnXSBriQKNa8eUqPBNbh5xTMeK4JRjWviP5msVkdMqnsVts7aKtGbX8zS7XtZmdwhDff5tol2/ckkXTrXoK/N88Qvnr38CSEQRlwAAAABJRU5ErkJggg=="
56
57
EDIT_ICON = "iVBORw0KGgoAAAANSUhEUgAAABgAAAAYCAYAAADgdz34AAAACXBIWXMAAAsTAAALEwEAmpwYAAAA10lEQVR4nO3UPUpDQRSG4cfCQgn" \
58
            "+LSPLSCcEC1u3EXdgEXdg3EC2IXYS0N4itZWWGkGvDHyBkE45Npq3usyB95tz5s6w4ZfZwwQveMIFtqvkB5jhDZe4xmdCyuQdxivrk3RSIl/gAe84Ta118oytCvkQPdwmZJxxXVXJl/TSSZd6O/hvs4+7yE" \
59
            "/Wasd4xT2ONvIl/3gsuys3dLRWGyZ0ll/2RwwiX2SnZ5XyxnkerD5uEjKqkjemmOe7H3FXJW885rGaR9xVyg/xkZBpxjXIwZewU7VTf4ovf6VSMafchm4AAAAASUVORK5CYII="
60
61
BUTTON_COLOR = (sg.theme_background_color(), sg.theme_background_color())
62
63
64
class MyTable(sg.Table):
65
    def __init__(self, key, headings, row_fn):
66
        super().__init__(
67
            values=[],
68
            key=key,
69
            headings=headings,
70
            expand_x=True,
71
            expand_y=True,
72
            select_mode=sg.TABLE_SELECT_MODE_EXTENDED,
73
            enable_events=True,
74
            text_color="black",
75
            background_color="white",
76
            # headings=HEADINGS,
77
            # values=[],
78
            # auto_size_columns=False,
79
            # col_widths=COL_WIDTHS,
80
            # justification="center",
81
            # num_rows=20,
82
            alternating_row_color="grey95", #"aliceblue",
83
            # row_height=ROW_HEIGHT,
84
            # header_text_color="white",
85
            # header_background_color="darkblue",
86
            # font=FONT,
87
            # bind_return_key=True,
88
            tooltip="Doble click para ver factura",
89
            # right_click_menu=RIGHT_CLICK_MENU
90
            metadata=[]
91
        )
92
        self.row_fn = row_fn
93
94
    def selected_items(self):
95
        return [self.metadata[i] for i in self.SelectedRows]
96
97
    def select_all(self):
98
        self.update(
99
            select_rows=list(range(len(self.metadata)))
100
        )
101
102
    def update(self, values=None, **kwargs):
103
        super().update(
104
            values=[
105
                self.row_fn(i, item)
106
                for i, item in enumerate(values, start=1)
107
            ],
108
            **kwargs
109
        )
110
        self.metadata = values
111
112
113
def make_layout(has_fiel, local_db):
114
    # LAYOUT
115
    button_column = [
116
        sg.Button(image_data=CONFIG_ICON, key="ver_config", border_width=0, button_color=BUTTON_COLOR),
117
        sg.Text("Periodo:", pad=TEXT_PADDING),
118
        sg.Input(date.today().strftime('%Y-%m'), size=(11, 1), key="periodo"),
119
        sg.Button(image_data=FOLDER_ICON, key="ver_carpeta", border_width=0, button_color=BUTTON_COLOR),
120
        sg.Button(image_data=EXCEL_ICON, key="ver_excel", border_width=0, button_color=BUTTON_COLOR),
121
        sg.Button(image_data=HTML_ICON, key="ver_html", border_width=0, button_color=BUTTON_COLOR),
122
123
        sg.Push(),
124
        sg.Text("Factura:", pad=TEXT_PADDING),
125
        sg.Text("", key="serie", pad=TEXT_PADDING, text_color="black"),
126
        sg.Input("", key="folio", size=(8, 1), enable_events=True),
127
        sg.Button("".center(22), disabled=True, key="crear_facturas", border_width=0, button_color=sg.theme_background_color()),
128
    ]
129
130
    # ----- Full layout -----
131
    return [
132
        button_column,
133
        [
134
            sg.TabGroup(
135
                [[
136
                    sg.Tab(
137
                        'Consola'.center(13),
138
                        [
139
                            [
140
                                sg.Push(),
141
                                sg.Button(image_data=ABOUT_ICON, key="about", border_width=0, button_color=BUTTON_COLOR),
142
                            ],
143
                            [sg.Multiline(
144
                                expand_x=True,
145
                                expand_y=True,
146
                                key="console",
147
                                write_only=True,
148
                                autoscroll=True,
149
                                reroute_stdout=True
150
                            )]
151
                        ],
152
                        key='console_tab',
153
                    ),
154
                    sg.Tab(
155
                        'Clientes'.center(13),
156
                        [
157
                            [
158
                                sg.Button("Refrescar", key="refresh_clientes", border_width=0),
159
                                sg.Push(),
160
                                sg.Button(image_data=EDIT_ICON, key="editar_clientes", border_width=0, button_color=BUTTON_COLOR),
161
                            ],
162
                            [
163
                                MyTable(
164
                                    key="clientes_table",
165
                                    headings=[
166
                                        "#",
167
                                        "Razon Social",
168
                                        "Rfc",
169
                                        "Reg",
170
                                        "CP"
171
                                    ],
172
                                    row_fn=lambda i, r: [
173
                                        i,
174
                                        r["RazonSocial"],
175
                                        r["Rfc"],
176
                                        r["RegimenFiscal"].code,
177
                                        r["CodigoPostal"]
178
                                    ]
179
                                )
180
                            ]],
181
                        key='clients_tab',
182
                    ),
183
                    sg.Tab(
184
                        'Facturas'.center(13),
185
                        [
186
                            [
187
                                sg.Button("Refrescar", key="refresh_facturas", border_width=0, ),
188
                                sg.Text("", pad=TEXT_PADDING, key="preparar_facturas_text"),
189
                                sg.Push(),
190
                                sg.Button(image_data=EDIT_ICON, key="editar_facturas", border_width=0, button_color=BUTTON_COLOR),
191
                            ],
192
                            [
193
                                MyTable(
194
                                    key="facturas_table",
195
                                    headings=[
196
                                        '#',
197
                                        'EReg',
198
                                        'Receptor Razon Social',
199
                                        'Recep. Rfc',
200
                                        "Tipo",
201
                                        "Subtotal",
202
                                        "Total"
203
                                    ],
204
                                    row_fn=lambda i, r: [
205
                                        i,
206
                                        r['Emisor']['RegimenFiscal'].code,
207
                                        r['Receptor']['Nombre'],
208
                                        r['Receptor']['Rfc'],
209
                                        mf_pago_fmt(r),
210
                                        r['SubTotal'],
211
                                        r['Total']
212
                                    ]
213
                                )
214
                            ]],
215
                        key='facturas_tab',
216
                    ),
217
                    sg.Tab(
218
                        'Emitidas'.center(13),
219
                        [
220
                            [
221
                                sg.Button("Pendientes", key="facturas_pendientes", border_width=0),
222
                                sg.Button("Todas", key="facturas_emitidas", border_width=0),
223
                                sg.Button(image_data=SEARCH_ICON, key="emitidas_search_enter", border_width=0, button_color=BUTTON_COLOR),
224
                                sg.Input("", size=(20, 1), key="emitidas_search", border_width=0),
225
                                sg.Text("", pad=TEXT_PADDING, key="emitidas_text"),
226
                            ],
227
                            [
228
                                sg.Column([[
229
                                    sg.Button("".ljust(10), key="status_sat", border_width=0, button_color=sg.theme_background_color()),
230
                                    sg.Button("".ljust(10), key="email_notificada", border_width=0, button_color=sg.theme_background_color()),
231
                                    sg.Button("".ljust(10), key="pendiente_pago", border_width=0, button_color=sg.theme_background_color()),
232
                                ]]),
233
                                sg.VSeparator(),
234
                                sg.Column([[
235
                                    sg.CalendarButton("FechaPago:", format='%Y-%m-%d', title="FechaPago", no_titlebar=False, target="fecha_pago", pad=TEXT_PADDING,
236
                                                      border_width=0,
237
                                                      key="fecha_pago_select"),
238
                                    sg.Input(datetime.now().strftime('%Y-%m-%d'), size=(12, 1), key="fecha_pago", border_width=0),
239
                                    sg.Combo([Code(k, v) for k, v in FORMA_PAGO.items()], default_value=Code("03", FORMA_PAGO["03"]), key="forma_pago", size=(28, 1)),
0 ignored issues
show
Comprehensibility Best Practice introduced by
The variable Code does not seem to be defined.
Loading history...
240
                                    sg.Text("ImpPagado:", pad=TEXT_PADDING, key="imp_pagado_text", border_width=0),
241
                                    sg.Input("", size=(12, 1), key="importe_pago", border_width=0),
242
                                    sg.Button("Comprobante Pago", key="prepare_pago", border_width=0),
243
                                    sg.Button(image_data=PREVIEW_ICON, key="ver_html_pago", border_width=0, button_color=BUTTON_COLOR),
244
                                ]], visible=False, key="ppd_action_items"),
245
                            ],
246
                            [
247
                                MyTable(
248
                                    key="emitidas_table",
249
                                    headings=[
250
                                        '#',
251
                                        'Receptor Razon Social',
252
                                        'Recep. Rfc',
253
                                        'Factura',
254
                                        "Fecha",
255
                                        "Total",
256
                                        "Pagada",
257
                                        "Tipo",
258
                                    ],
259
                                    row_fn=lambda i, r: [
260
                                        i,
261
                                        r['Receptor'].get('Nombre', ''),
262
                                        r['Receptor']['Rfc'],
263
                                        r.name,
264
                                        r["Fecha"].strftime("%Y-%m-%d"),
265
                                        r["Total"],
266
                                        local_db.liquidated_state(r),
267
                                        mf_pago_fmt(r)
268
                                    ]
269
                                )
270
                            ]],
271
                        key='emitidas_tab',
272
                    ),
273
                    sg.Tab(
274
                        'Correos'.center(13),
275
                        [
276
                            [
277
                                sg.Button("Refrescar", key="refresh_correos", border_width=0, ),
278
                            ],
279
                            [
280
                                MyTable(
281
                                    key="correos_table",
282
                                    headings=[
283
                                        '#',
284
                                        'Receptor Razon Social',
285
                                        'Recep. Rfc',
286
                                        'Facturas',
287
                                        'Pendientes Emitidas Meses Anteriores'
288
                                    ],
289
                                    row_fn=lambda i, r: [
290
                                        i,
291
                                        r[0]["RazonSocial"][0:36],
292
                                        r[0]["Rfc"],
293
                                        ",".join(n.name for n in r[1]),
294
                                        ",".join(n.name for n in r[2])
295
                                    ]
296
                                )
297
                            ]],
298
                        key='correos_tab',
299
                    ),
300
                    sg.Tab(
301
                        'Ajustes'.center(13),
302
                        [
303
                            [
304
                                sg.Button("Refrescar", key="refresh_ajustes", border_width=0, ),
305
                                sg.Text("", pad=TEXT_PADDING, key="preparar_ajustes_text"),
306
                            ],
307
                            [
308
                                MyTable(
309
                                    key="ajustes_table",
310
                                    headings=[
311
                                        "#",
312
                                        "Receptor Razon Social",
313
                                        "Recep. Rfc",
314
                                        "Actual",
315
                                        "Nuevo",
316
                                        "Ajuste %",
317
                                        "Periodo",
318
                                        "Meses",
319
                                        "Ajuste Efectivo"
320
                                    ],
321
                                    row_fn=lambda i, r: [
322
                                        i,
323
                                        r["receptor"]["RazonSocial"],
324
                                        r["receptor"]["Rfc"],
325
                                        r["valor_unitario"],
326
                                        r["valor_unitario_nuevo"],
327
                                        r["ajuste_porcentaje"].split(' ')[0],
328
                                        r["periodo"],
329
                                        r["meses"],
330
                                        r["efectivo_periodo_desc"]
331
                                    ]
332
                                )
333
                            ]],
334
                        key='ajustes_tab'
335
                    ),
336
                    sg.Tab(
337
                        'Recuperar'.center(13),
338
                        [
339
                            [
340
                                sg.Button("SAT Status", key="sat_status_todas", border_width=0),
341
                                sg.Text("Recuperar:", pad=TEXT_PADDING),
342
                                sg.Button("Emitidas ", key="recuperar_emitidas", border_width=0),
343
                                sg.Button("Recibidas", key="recuperar_recibidas", border_width=0),
344
                                sg.Text("Dias:", pad=TEXT_PADDING),
345
                                sg.Input("40", size=(4, 1), key="recuperar_dias"),
346
                            ]
347
                        ],
348
                        key='recuperar_tab',
349
                        visible=has_fiel
350
                    ),
351
                ]],
352
                expand_x=True,
353
                expand_y=True,
354
                enable_events=True,
355
                key="main_tab_group",
356
            )
357
        ]
358
    ]
359
360
361
class ActionButtonManager:
362
    def __init__(self, button):
363
        self.name = ""
364
        self.items = []
365
        self.button = button
366
367
    def set_items(self, name, items):
368
        self.name = name
369
        self.items = items
370
        self.style_button()
371
372
    def clear(self):
373
        self.name = ""
374
        self.items = []
375
        self.style_button()
376
377
    def text(self):
378
        if self.items:
379
            return f"Procesar {len(self.items)} {self.name.capitalize()}"
380
        else:
381
            return ""
382
383
    def style_button(self):
384
        self.button.update(
385
            self.text().center(22),
386
            disabled=not self.items,
387
            button_color=sg.theme_button_color() if self.items else sg.theme_background_color()
388
        )
389