def save_changes(self):
if not sqlite_requests.get_products_not_in_table('personal_products', USER.name, [self.parent_product.name]):
sqlite_requests.sqlite_update_record('personal_products',
{'name': self.ids.name.text,
'units': self.ids.units.text,
'rating': self.ids.rating.text,
'quality': self.ids.quality.text,
'note': self.ids.note.text
},
{'name': self.parent_product.name,
'user': USER.name
})
else:
sqlite_requests.sqlite_fill_table('personal_products',
self.parent_product.name,
'шт',
USER.name,
self.parent_product.rating,
0,
0,
self.parent_product.quality,
0,
self.parent_product.note)
self.parent_product.parent_allproducts.on_pre_open()
self.dismiss()
def update_record_bd(self):
self.selected = self.ids.selected.active
if self.selected:
self.last_use = round(time.time())
self.frequency_of_use += 1
if (not sqlite_requests.get_products_not_in_table('current_products', USER.name,
[self.name], self.parent_listrepresentation)) is self.selected:
return # If called by creating of Product in on_pre_open of AllProductsList
# Че это ваще за хуйня выше? Можно как-то перестроить работу проги, чтобы не было этот ебанины?
# Она ваще всё еще есть? Разве я не переделал это? ._.
if not sqlite_requests.get_products_not_in_table('personal_products', USER.name, [self.name]):
sqlite_requests.sqlite_update_record('personal_products',
{
'frequency_of_use': self.frequency_of_use,
'last_use': self.last_use
},
{'user': USER.name, 'name': self.name})
else:
sqlite_requests.sqlite_fill_table('personal_products', self.name, self.units, user=USER.name,
frequency_of_use=1, last_use=round(time.time()), is_category=True)
if self.selected:
sqlite_requests.sqlite_fill_table('current_products', self.name, self.units, user=USER.name,
products_list=self.parent_listrepresentation, price=self.current_price,
quantity=self.quantity, bought='False')
else:
sqlite_requests.sqlite_delete_record('current_products', name=self.name, user=USER.name,
products_list=self.parent_listrepresentation)
def add_product(self, instance):
sqlite_requests.sqlite_fill_table('personal_products',
self.current_product,
user=USER.name,
category=instance.text)
self.new_products.remove(self.current_product)
self.on_pre_open(
) # Не нравится на пре опен ссылаться, мб вынести в еще одну функцию? Хотя тогда
def add_list(self,
text='No name'
): # Adds List (Product list) in List of Products list
self.LR.ids.name.text = str(text)
self.LR.parent_box = self.parentlist
self.parentlist.ids.list_of_products_lists.add_widget(self.LR)
sqlite_requests.sqlite_fill_table('lists', str(text), user=USER.name)
self.dismiss()
def add_category(self):
sqlite_requests.sqlite_fill_table('personal_products',
self.ids.search.text[0].upper() +
self.ids.search.text[1:],
'шт',
USER.name,
0,
0,
0,
0,
round(time.time()),
'',
is_category=True)
self.search()
def add_product(self):
sqlite_requests.sqlite_fill_table('personal_products',
self.ids.search.text[0].upper() +
self.ids.search.text[1:],
'шт',
USER.name,
0,
0,
0,
0,
round(time.time()),
'',
is_category=True)
self.ids.search.text = ''
# test пизда говно решение но я хочу спать переделай нормальн
self.ids.last_sorting.state = 'down'
self.ids.popular_sorting.state = 'normal'
self.ids.abc_sorting.state = 'normal'
self.update_sort('last')
from global_variables import USER
with open('13.json', 'r', encoding='utf-8') as read_json:
data = json.load(read_json)
print(data)
date = data['date']
shop_name = data['shopName']
shop_address = data['shopAddress']
sum = data['totalSum']
products = data['products']
products_names = [prod['name'] for prod in products]
new_products = sqlite_requests.get_products_not_in_table(
'personal_products', USER.name, products_names)
for prod in new_products:
sqlite_requests.sqlite_fill_table('personal_products',
prod,
user=USER.name,
category=1)
a = sqlite_requests.get_all_products(USER.name,
search='',
only_categories=True)
print(new_products)
# for prod in products:
# sqlite_requests.