Exemplo n.º 1
0
def create():
    form = UserForm()
    if form.validate_on_submit():
        try:
            m = hashlib.md5()
            password = form.data['password'].encode('utf-8')
            m.update(password)
            hashpass = m.hexdigest()
            insert('users', {'username': form.data['username'], 'password': hashpass})
        except IntegrityError:
            getattr(form, 'username').errors = (
                    'User with given name already exists.',
                )
    return render_template('users/create.html', form=form)
Exemplo n.º 2
0
def save_order(data):
    data_orders = {'client_id': data['client'], 'user_id': session.get('user')}
    statuses = select('order_statuses', {'status_name': data['status']})
    if statuses:
        data_orders['status_id'] = statuses[0].id

    order_id = insert('orders', data_orders)
    for product in data['products']:
        data_products = {
            'order_id': order_id,
            'product_id': product['product'],
            'price': product['price'],
            'quantity': product['quantity'],
        }
        insert('order_products', data_products)
Exemplo n.º 3
0
def edit_client(form, client_id):
    client_data = {
        'name': form.data['name'],
        'surname': form.data['surname'],
        'email': form.data['email'],
    }

    utils.run_custom_query(
            """DELETE FROM CLIENT_PHONES WHERE CLIENT_ID = {}""".format(
                client_id
            ),
            fetch=False
        )
    utils.update('clients', {'id': client_id},  client_data)
    for phone in form.data['phones']:
        if phone['phone']:
            utils.insert(
                'client_phones',
                {'client_id': client_id, 'phone': phone['phone']}
            )
    if form.data['billing_address']:
        billing = utils.select('client_addresses', {'client_id': client_id, 'type': 'billing'})
        data = form.data['billing_address']
        utils.update(
            'addresses',
            {
                'id': billing[0].id,
            },
            {
                'country': data['country'],
                'city': data['city'],
                'street': data['street']
            }
        )
    if form.data['delivery_address']:
        delivery = utils.select('client_addresses', {'client_id': client_id, 'type': 'delivery'})
        data = form.data['delivery_address']
        utils.update(
            'addresses',
            {
                'id': delivery[0].id,
            },
            {
                'country': data['country'],
                'city': data['city'],
                'street': data['street']
            }
        )
Exemplo n.º 4
0
def create_client(form):
    client_data = {
        'name': form.data['name'],
        'surname': form.data['surname'],
        'email': form.data['email']
    }

    client_id = utils.insert('clients', client_data)
    for phone in form.data['phones']:
        if phone['phone']:
            utils.insert(
                'client_phones',
                {'client_id': client_id, 'phone': phone['phone']}
            )

    if form.data['billing_address']:
        data = form.data['billing_address']
        address_id = utils.insert(
            'addresses',
            {
                'country': data['country'],
                'city': data['city'],
                'street': data['street']
            }
        )
        utils.insert(
            'client_addresses',
            {
                'client_id': client_id,
                'address_id': address_id,
                'type': 'billing'
            }
        )
    if form.data['delivery_address']:
        data = form.data['delivery_address']
        address_id = utils.insert(
            'addresses',
            {
                'country': data['country'],
                'city': data['city'],
                'street': data['street']
            }
        )
        utils.insert(
            'client_addresses',
            {
                'client_id': client_id,
                'address_id': address_id,
                'type': 'delivery'
            }
        )
Exemplo n.º 5
0
def create():
    form = UserForm()
    if form.validate_on_submit():
        try:
            m = hashlib.md5()
            password = form.data['password'].encode('utf-8')
            m.update(password)
            hashpass = m.hexdigest()
            insert('users', {
                'username': form.data['username'],
                'password': hashpass
            })
        except IntegrityError:
            getattr(
                form,
                'username').errors = ('User with given name already exists.', )
    return render_template('users/create.html', form=form)
Exemplo n.º 6
0
def save_order(data):
    data_orders = {
        'client_id': data['client'],
        'user_id': session.get('user')
    }
    statuses = select('order_statuses', {'status_name': data['status']})
    if statuses:
        data_orders['status_id'] = statuses[0].id

    order_id = insert('orders', data_orders)
    for product in data['products']:
        data_products = {
            'order_id': order_id,
            'product_id': product['product'],
            'price': product['price'],
            'quantity': product['quantity'],
        }
        insert('order_products', data_products)
Exemplo n.º 7
0
def edit_client(form, client_id):
    client_data = {
        'name': form.data['name'],
        'surname': form.data['surname'],
        'email': form.data['email'],
    }

    utils.run_custom_query(
        """DELETE FROM CLIENT_PHONES WHERE CLIENT_ID = {}""".format(client_id),
        fetch=False)
    utils.update('clients', {'id': client_id}, client_data)
    for phone in form.data['phones']:
        if phone['phone']:
            utils.insert('client_phones', {
                'client_id': client_id,
                'phone': phone['phone']
            })
    if form.data['billing_address']:
        billing = utils.select('client_addresses', {
            'client_id': client_id,
            'type': 'billing'
        })
        data = form.data['billing_address']
        utils.update('addresses', {
            'id': billing[0].id,
        }, {
            'country': data['country'],
            'city': data['city'],
            'street': data['street']
        })
    if form.data['delivery_address']:
        delivery = utils.select('client_addresses', {
            'client_id': client_id,
            'type': 'delivery'
        })
        data = form.data['delivery_address']
        utils.update('addresses', {
            'id': delivery[0].id,
        }, {
            'country': data['country'],
            'city': data['city'],
            'street': data['street']
        })
Exemplo n.º 8
0
def update_order(order_id, data):
    order_data = {
        'client_id': data['client'],
    }
    statuses = select('order_statuses', {'status_name': data['status']})
    if statuses:
        order_data['status_id'] = statuses[0].id
    update('orders', {'id': order_id}, order_data)

    delete('order_products', {'order_id': order_id})

    for product in data['products']:
        data_products = {
            'order_id': order_id,
            'product_id': product['product'],
            'price': product['price'],
            'quantity': product['quantity'],
        }
        insert('order_products', data_products)
Exemplo n.º 9
0
def update_order(order_id, data):
    order_data = {
        'client_id': data['client'],
    }
    statuses = select('order_statuses', {'status_name': data['status']})
    if statuses:
        order_data['status_id'] = statuses[0].id
    update('orders', {'id': order_id}, order_data)

    delete('order_products', {'order_id': order_id})

    for product in data['products']:
        data_products = {
            'order_id': order_id,
            'product_id': product['product'],
            'price': product['price'],
            'quantity': product['quantity'],
        }
        insert('order_products', data_products)
Exemplo n.º 10
0
def create_client(form):
    client_data = {
        'name': form.data['name'],
        'surname': form.data['surname'],
        'email': form.data['email']
    }

    client_id = utils.insert('clients', client_data)
    for phone in form.data['phones']:
        if phone['phone']:
            utils.insert('client_phones', {
                'client_id': client_id,
                'phone': phone['phone']
            })

    if form.data['billing_address']:
        data = form.data['billing_address']
        address_id = utils.insert(
            'addresses', {
                'country': data['country'],
                'city': data['city'],
                'street': data['street']
            })
        utils.insert('client_addresses', {
            'client_id': client_id,
            'address_id': address_id,
            'type': 'billing'
        })
    if form.data['delivery_address']:
        data = form.data['delivery_address']
        address_id = utils.insert(
            'addresses', {
                'country': data['country'],
                'city': data['city'],
                'street': data['street']
            })
        utils.insert('client_addresses', {
            'client_id': client_id,
            'address_id': address_id,
            'type': 'delivery'
        })
Exemplo n.º 11
0
def create_status(data):
    utils.insert('order_statuses', data)
Exemplo n.º 12
0
def create_status(data):
    utils.insert("order_statuses", data)