def set_data_for(self, on, end): self.data = [(rap.type_, rap.store.name, rap.product, formatted_number(rap.qty_use), formatted_number(rap.remaining), show_date(rap.date), rap.id) for rap in Reports.filter(deleted=False, date__gte=on, date__lte=end) .order_by(Reports.date.desc())]
def update_report(report): """ Supression """ try: p = Reports.filter(deleted=False, date__gt=report.date).get() p.save() except Exception as e: print("update_report", e) pass report.delete_instance()
def lastes_reports(): list_rep = [] for store in Store.select(): for prod in Product.select(): try: list_rep.append(Reports.filter(deleted=False, store=store, product=prod) .order_by(Reports.date.desc()).get()) except Exception as e: # print(e) pass return list_rep
def changed_value(self, refresh=False): """ Calcule les Resultat """ current_store = self.parent.liste_store[ self.parent.box_store.currentIndex()] for row_num in xrange(0, self.data.__len__()): self.isvalid = True try: last_report = Reports.filter(store=current_store, product__name=str(self.item(row_num, 1) .text())).order_by(Reports.date.desc()).get() qtremaining = last_report.remaining date_out = str(self.parent.date_out.text()) if last_report.date > date_on_or_end(date_out, on=False): self.parent.date_out.setStyleSheet("font-size:15px;" "color:red") self.parent.date_out.setToolTip(u"Cette date est " u"Inférieure à la date " u"de la dernière rapport" u" (%s) " % last_report.date) self.isvalid = False return False except Exception as e: print(e) qtremaining = 0 qtsaisi = is_int(self.cellWidget(row_num, 0).text()) self._update_data(row_num, [qtsaisi]) viderreur_qtsaisi = "" stylerreur = "background-color: rgb(255, 235, 235);" + \ "border: 3px double SeaGreen" if qtsaisi == 0: viderreur_qtsaisi = stylerreur self.cellWidget(row_num, 0).setToolTip(u"obligatoire") self.isvalid = False self.cellWidget(row_num, 0).setStyleSheet(viderreur_qtsaisi) self.cellWidget(row_num, 0).setToolTip("") if qtremaining < qtsaisi: self.cellWidget(row_num, 0).setStyleSheet("font-size:20px;" " color: red") self.cellWidget(row_num, 0).setToolTip(u"%s est > %s (stock" u" remaining)" % (qtsaisi, qtremaining)) self.isvalid = False return False
def annulation(self): reply = QMessageBox.question(self, 'Confirmation', u"<h2 style='color:red;'>Voulez vous vraiment annuler cette" u" facture?</h2>", QMessageBox.Yes | QMessageBox.No, QMessageBox.No) if reply == QMessageBox.Yes: from ui.dashboard import DashbordViewWidget rep = Reports() rep.store = 1 for item in Reports.filter(invoice=self.invoice): item.delete_instance() self.invoice.delete_instance() self.change_main_context(DashbordViewWidget)