示例#1
0
 def delete_items_slot(self, answer):
     if answer:
         selection = self.jednostki.selectedItems()
         if selection:
             res = []
             for x in selection:
                 res.append(self.jednostki.item(x.row(), 0).text())
             res = list(dict.fromkeys(res))
             Connector.delete_items("jednostki", res, "identyfikator", int)
             self.set_jednostki()
 def delete_items_slot(self, answer):
     if answer:
         selection = self.equipment.selectedItems()
         if selection:
             res = []
             for x in selection:
                 res.append(self.equipment.item(x.row(), 0).text())
             res = list(dict.fromkeys(res))
             Connector.delete_items("ekwipunek", res, "numer_seryjny", int)
             self.refresh_eq()
示例#3
0
 def delete_officers_slot(self, answer):
     if answer:
         selection = self.tabela_oficerowie.selectedItems()
         if selection:
             res = []
             for x in selection:
                 res.append(self.tabela_oficerowie.item(x.row(), 2).text())
             res = list(dict.fromkeys(res))
             Connector.delete_items("oficerowie", res, "pesel", str)
             self.refresh_officers()
示例#4
0
 def delete_vehicles_slot(self, answer):
     if answer:
         selection = self.tabela_pojazdy.selectedItems()
         if selection:
             res = []
             for x in selection:
                 res.append(self.tabela_pojazdy.item(x.row(), 0).text())
             res = list(dict.fromkeys(res))
             Connector.delete_items("pojazdy", res, "id_pojazdu", int)
             self.refresh_vehicles()
示例#5
0
 def delete_building_slot(self, answer):
     if answer:
         selection = self.tabela_budynki.selectedItems()
         if selection:
             res = []
             for x in selection:
                 res.append(self.tabela_budynki.item(x.row(), 0).text())
             res = list(dict.fromkeys(res))
             Connector.delete_items("budynki", res, "oznaczenie", str)
             self.refresh_buildings()
示例#6
0
 def delete_vh_order_slot(self, answer):
     if answer:
         selection = self.tabela_pojazdy.selectedItems()
         if selection:
             rows = []
             for x in selection:
                 rows.append(x.row())
             rows = list(dict.fromkeys(rows))
             res = []
             for x in rows:
                 res.append(self.tabela_pojazdy.item(x, 0).text())
             Connector.delete_items('pojazdy', res, "id_zamowienia", int)
             Connector.delete_items('"Zamowienie-pojazd"', res,
                                    "id_zamowienia", int)
             self.refresh_vh_orders()
示例#7
0
 def finish_vh_order_slot(self, answer):
     if answer:
         selection = self.tabela_pojazdy.selectedItems()
         if selection:
             rows = []
             for x in selection:
                 rows.append(x.row())
             rows = list(dict.fromkeys(rows))
             res = []
             for x in rows:
                 res.append(self.tabela_pojazdy.item(x, 0).text())
             if len(res) == 1:
                 Connector.update_row('pojazdy',
                                      ["id_zamowienia", "status"],
                                      [None, "Dostępny"], res[0],
                                      "id_zamowienia", int)
                 Connector.delete_items('"Zamowienie-pojazd"', res,
                                        "id_zamowienia", int)
             self.refresh_vh_orders()
示例#8
0
 def delete_vh_assignment_slot(self, answer):
     if answer:
         selection = self.tabela_pojazdy.selectedItems()
         if selection:
             rows = []
             for x in selection:
                 rows.append(x.row())
             rows = list(dict.fromkeys(rows))
             res = []
             for x in rows:
                 res.append("'" + self.tabela_pojazdy.item(x, 0).text() +
                            "' AND pesel_oficera = '" +
                            self.tabela_pojazdy.item(x, 2).text() +
                            "' AND id_pojazdu = " +
                            self.tabela_pojazdy.item(x, 3).text())
             Connector.delete_items('"Przydzial-pojazd"', res, "data_od",
                                    int)
             for x in rows:
                 Connector.update_row("pojazdy", ["status"], ["Dostępny"],
                                      self.tabela_pojazdy.item(x, 3).text(),
                                      "id_pojazdu", int)
             self.refresh_vh_assignments()
示例#9
0
 def delete_eq_assignment_slot(self, answer):
     if answer:
         selection = self.tabela_eq.selectedItems()
         if selection:
             rows = []
             for x in selection:
                 rows.append(x.row())
             rows = list(dict.fromkeys(rows))
             res = []
             for x in rows:
                 res.append("'" + self.tabela_eq.item(x, 0).text() +
                            "' AND pesel_oficera = '" +
                            self.tabela_eq.item(x, 2).text() +
                            "' AND numer_seryjny = " +
                            self.tabela_eq.item(x, 3).text())
             Connector.delete_items('"Przydzial-ekwipunek"', res, "data_od",
                                    int)
             for x in rows:
                 Connector.update_row("ekwipunek", ["status"], ["Dostępny"],
                                      self.tabela_eq.item(x, 3).text(),
                                      "numer_seryjny", int)
             self.refresh_eq_assignments()