Exemplo n.º 1
0
def do_register():
    email = request.forms.get('email')
    name = request.forms.get('name')
    password = request.forms.get('password')
    destination_url = request.headers.get('Referer', '/').strip()

    if not mail_exist(email):
        import crypt
        salt = '$6$FIXEDS'
        pass_hash = crypt.crypt(password, salt)
        if debug: print colors.OKBLUE, pass_hash, colors.ENDC
        sql = "INSERT INTO users (login, email, password, p_hash) VALUES ('{}', '{}', '{}', '{}')".format(
            name, email, password, pass_hash)
        if debug: print colors.OKBLUE, sql, colors.ENDC
        db.query(sql)
        send_email('./mails/grats_to_register.txt', 'register_grats', email)
        send_email('./mails/admin_registered_notify.txt',
                   'admin_register_notify', email)
        ###
        redirect('/')
    else:
        return template('register',
                        user_exist=1,
                        menu_data=menu(),
                        settings=get_settings())
Exemplo n.º 2
0
def send_email(message_file, mtype, mailto):
    # Import smtplib for the actual sending function
    import smtplib
    # Import the email modules we'll need
    from email.mime.text import MIMEText

    # Open a plain text file for reading.  For this example, assume that
    # the text file contains only ASCII characters.
    #    fp = open(message_file, 'rb')
    # Create a text/plain message
    #    msg = MIMEText(fp.read())
    #    fp.close()

    # me == the sender's email address
    # you == the recipient's email address
    if mtype == 'register_grats':
        cur = db.query("SELECT login FROM users WHERE email = '%s'" % mailto)
        text = 'Thanks for register\\n \
        %s' % mailto
        msg = MIMEText(text)
        msg['Subject'] = 'Thanks for register %s' % cur.fetchone()
        msg['From'] = '*****@*****.**'
        msg['To'] = mailto
    elif mtype == 'admin_register_notify':
        text = 'New user registered\\n \
        %s' % mailto
        msg = MIMEText(text)
        msg['Subject'] = 'Mew user registered %s' % mailto
        msg['From'] = '*****@*****.**'
        msg['To'] = '*****@*****.**'
    elif mtype == 'order_grats':
        cur = db.query("SELECT login FROM users WHERE email = '%s'" % mailto)
        user = cur.fetchone()[0]
        print colors.HEADER, 'DBG:', colors.OKBLUE, message_file, colors.OKGREEN, user, colors.ENDC
        text = "{} thanks for new order in queue {}".format(user, message_file)
        msg = MIMEText(text)
        msg['Subject'] = 'Thanks for order %s' % message_file
        msg['From'] = '*****@*****.**'
        msg['To'] = '*****@*****.**'
    elif mtype == 'admin_order_notify':
        text = "New order queued\\r\\n \
        {} by {}".format(message_file, mailto)
        msg = MIMEText(text)
        msg['Subject'] = 'New order queued %s' % mailto
        msg['From'] = '*****@*****.**'
        msg['To'] = '*****@*****.**'

    if debug:
        print colors.HEADER, 'Try MAIL sending'
        #        print colors.HEADER, 'From:', colors.FAIL, msg['From']
        #        print colors.HEADER, 'To:', colors.FAIL, msg['To']
        print colors.OKBLUE, msg.as_string(), colors.ENDC
    # Send the message via our own SMTP server, but don't include the
    # envelope header.
    s = smtplib.SMTP('localhost')
    s.sendmail(msg['From'], msg['To'], msg.as_string())
    if debug: print colors.HEADER, 'End MAIL sending', colors.ENDC
    s.quit()
Exemplo n.º 3
0
def send_email(message_file, mtype, mailto):
    # Import smtplib for the actual sending function
    import smtplib
    # Import the email modules we'll need
    from email.mime.text import MIMEText

    # Open a plain text file for reading.  For this example, assume that
    # the text file contains only ASCII characters.
#    fp = open(message_file, 'rb')
    # Create a text/plain message
#    msg = MIMEText(fp.read())
#    fp.close()

    # me == the sender's email address
    # you == the recipient's email address
    if mtype == 'register_grats':
        cur = db.query("SELECT login FROM users WHERE email = '%s'" % mailto)
        text = 'Thanks for register\\n \
        %s' % mailto
        msg = MIMEText(text)
        msg['Subject'] = 'Thanks for register %s' % cur.fetchone()
        msg['From'] = '*****@*****.**'
        msg['To'] = mailto
    elif mtype == 'admin_register_notify':
        text = 'New user registered\\n \
        %s' % mailto
        msg = MIMEText(text)
        msg['Subject'] = 'Mew user registered %s' % mailto
        msg['From'] = '*****@*****.**'
        msg['To'] = '*****@*****.**'
    elif mtype == 'order_grats' :
        cur = db.query("SELECT login FROM users WHERE email = '%s'" % mailto)
        user = cur.fetchone()[0]
        print colors.HEADER, 'DBG:', colors.OKBLUE, message_file, colors.OKGREEN, user, colors.ENDC
        text = "{} thanks for new order in queue {}".format(user, message_file)
        msg = MIMEText(text)
        msg['Subject'] = 'Thanks for order %s' % message_file
        msg['From'] = '*****@*****.**'
        msg['To'] = '*****@*****.**'
    elif mtype == 'admin_order_notify':
        text = "New order queued\\r\\n \
        {} by {}".format(message_file, mailto)
        msg = MIMEText(text)
        msg['Subject'] = 'New order queued %s' % mailto
        msg['From'] = '*****@*****.**'
        msg['To'] = '*****@*****.**'

    if debug:
        print colors.HEADER, 'Try MAIL sending'
#        print colors.HEADER, 'From:', colors.FAIL, msg['From']
#        print colors.HEADER, 'To:', colors.FAIL, msg['To']
        print colors.OKBLUE, msg.as_string(), colors.ENDC 
    # Send the message via our own SMTP server, but don't include the
    # envelope header.
    s = smtplib.SMTP('localhost')
    s.sendmail(msg['From'], msg['To'], msg.as_string())
    if debug: print colors.HEADER, 'End MAIL sending', colors.ENDC 
    s.quit()
Exemplo n.º 4
0
def menu():
    menu_content = []
    sections = []
    counter = 0
    menu_sections = db.query("SELECT section_id,title,targetclass,link FROM menu_sections")
    for section in menu_sections:
        menu_element = []
        sections.append(section)
        if debug: print colors.HEADER, 'MENU SECTION ID:', colors.FAIL, section[0] , colors.ENDC
        mc = db.query("SELECT * FROM menu_content WHERE section_id = %d" % section[0])
        cur = db.query("SELECT count(*) FROM menu_content WHERE section_id = %d" % section[0])
        menu_column_nums = int(cur.fetchone()[0])
        if debug: print colors.HEADER, 'MENU COLUMN NUMBER:', colors.FAIL, menu_column_nums , colors.ENDC
        for n in range(menu_column_nums):
            menu_content_cache = mc.fetchone()
            try:
                menu_content_column = {'title': 'bla'} ## Initializing
                menu_content_column['title'] = menu_content_cache[0]
                menu_content_column['description'] = menu_content_cache[1]
                menu_content_column['price'] = menu_content_cache[2]
                menu_content_column['link'] = menu_content_cache[3]
                menu_content_column['section_id'] = menu_content_cache[5]
                menu_element.append(menu_content_column)

                if debug == 'off':
                  print '============Begin+=========='
                  print colors.OKBLUE,section[0], colors.HEADER,'title      ', colors.OKGREEN, menu_content_column['title'], colors.ENDC
                  print colors.OKBLUE,section[0], colors.HEADER,'description', colors.OKGREEN, menu_content_column['description'], colors.ENDC
                  print colors.OKBLUE,section[0], colors.HEADER,'price      ', colors.OKGREEN, menu_content_column['price'], colors.ENDC
                  print colors.OKBLUE,section[0], colors.HEADER,'link       ', colors.OKGREEN, menu_content_column['link'], colors.ENDC
                  print colors.OKBLUE,section[0], colors.HEADER,'section_id ', colors.OKGREEN, menu_content_column['section_id'], colors.ENDC
                  print '============End============='

            except TypeError:
                if debug: print colors.HEADER, 'SKIPPING ', colors.FAIL, menu_content_cache , colors.ENDC
                continue
                #pass

        if not menu_element == []: #not empty
            menu_content.append(menu_element)
        else:
            if debug: print colors.HEADER, 'SKIPPING append', colors.FAIL, menu_element , colors.ENDC

    menu_data = [sections, menu_content]
    if debug: 
        for data in menu_data[1]:
            print colors.HEADER, 'RESULT ', colors.FAIL, data[0]['title'] , colors.ENDC

    return menu_data
Exemplo n.º 5
0
def get_settings():
    settings = {'logo_path': '..'}
    cur = db.query(
        "SELECT path,width,height FROM settings WHERE option_name='logo'")
    settings['logo_path'], settings['logo_width'], settings[
        'logo_height'] = cur.fetchone()
    return settings
Exemplo n.º 6
0
def get_username():
    user_id = request.cookies.get('id')
    if user_id:
        cur = db.query("SELECT login FROM users WHERE user_id=%d" % int(user_id))
        return cur.fetchone()[0]

    return "LOL"
Exemplo n.º 7
0
def get_username():
    user_id = request.cookies.get('id')
    if user_id:
        cur = db.query("SELECT login FROM users WHERE user_id=%d" %
                       int(user_id))
        return cur.fetchone()[0]

    return "LOL"
Exemplo n.º 8
0
def db_check(name):
    cur = db.query("SELECT login,password FROM users WHERE login = '******'" % name)
    ret = 'User not Found'
    for row in cur.fetchall():
        if row:
            ret = row[1]

    return ret
Exemplo n.º 9
0
def do_login():
    # !!! NEED VALIDATE INPUT !!!
    username = request.forms.get('username')
    password = request.forms.get('password')
    destination_url = request.headers.get('Referer','/').strip()

    if check_passwd(username, password):
        auth_hash = id_generator()
        cur = db.query("SELECT user_id FROM users WHERE login='******'" % username)
        user_id = int(cur.fetchone()[0])
        response.set_cookie('id', str(user_id))
        response.set_cookie('hash', str(auth_hash))
        response.set_cookie('logged_at', str(datetime.now()))
        cur = db.query("UPDATE users SET cookies='%s' WHERE login='******'" % (auth_hash, username))
        redirect(destination_url)
    else:
        return "<p>Login failed.</p>"
Exemplo n.º 10
0
def mail_exist(email):
    cur = db.query("SELECT user_id FROM users WHERE email = '%s'" % email)
    user_exists = cur.fetchone()
    if user_exists:
        return 1
    else:
        if debug: print colors.HEADER,"No user found:", colors.OKGREEN, email, colors.ENDC
        return 0
Exemplo n.º 11
0
def do_login():
    # !!! NEED VALIDATE INPUT !!!
    username = request.forms.get('username')
    password = request.forms.get('password')
    destination_url = request.headers.get('Referer', '/').strip()

    if check_passwd(username, password):
        auth_hash = id_generator()
        cur = db.query("SELECT user_id FROM users WHERE login='******'" % username)
        user_id = int(cur.fetchone()[0])
        response.set_cookie('id', str(user_id))
        response.set_cookie('hash', str(auth_hash))
        response.set_cookie('logged_at', str(datetime.now()))
        cur = db.query("UPDATE users SET cookies='%s' WHERE login='******'" %
                       (auth_hash, username))
        redirect(destination_url)
    else:
        return "<p>Login failed.</p>"
Exemplo n.º 12
0
def db_check(name):
    cur = db.query("SELECT login,password FROM users WHERE login = '******'" %
                   name)
    ret = 'User not Found'
    for row in cur.fetchall():
        if row:
            ret = row[1]

    return ret
Exemplo n.º 13
0
def mail_exist(email):
    cur = db.query("SELECT user_id FROM users WHERE email = '%s'" % email)
    user_exists = cur.fetchone()
    if user_exists:
        return 1
    else:
        if debug:
            print colors.HEADER, "No user found:", colors.OKGREEN, email, colors.ENDC
        return 0
Exemplo n.º 14
0
def do_register():
    email = request.forms.get('email')
    name = request.forms.get('name')
    password = request.forms.get('password')
    destination_url = request.headers.get('Referer','/').strip()

    if not mail_exist(email):
        import crypt;  
        salt = '$6$FIXEDS'
        pass_hash = crypt.crypt(password, salt)
        if debug: print colors.OKBLUE, pass_hash, colors.ENDC
        sql = "INSERT INTO users (login, email, password, p_hash) VALUES ('{}', '{}', '{}', '{}')".format(name, email, password, pass_hash)
        if debug: print colors.OKBLUE, sql, colors.ENDC
        db.query(sql)
        send_email('./mails/grats_to_register.txt', 'register_grats', email)
        send_email('./mails/admin_registered_notify.txt', 'admin_register_notify', email)
        ###
        redirect('/')
    else:
        return template('register', user_exist=1, menu_data=menu(), settings=get_settings())
Exemplo n.º 15
0
def logined():
    user_id = request.cookies.get('id')
    user_hash = request.cookies.get('hash')
    if user_id:
        if debug: print colors.HEADER, 'USER ID:', colors.FAIL, user_id , colors.ENDC
        cur = db.query("SELECT cookies FROM users WHERE user_id=%d" % int(user_id))
        cookie = cur.fetchone()[0]
        if debug: print colors.HEADER, 'COOKIE:', colors.FAIL, cookie, user_hash , colors.ENDC
        if cookie == user_hash:
            return 1

    return 0
Exemplo n.º 16
0
def logined():
    user_id = request.cookies.get('id')
    user_hash = request.cookies.get('hash')
    if user_id:
        if debug:
            print colors.HEADER, 'USER ID:', colors.FAIL, user_id, colors.ENDC
        cur = db.query("SELECT cookies FROM users WHERE user_id=%d" %
                       int(user_id))
        cookie = cur.fetchone()[0]
        if debug:
            print colors.HEADER, 'COOKIE:', colors.FAIL, cookie, user_hash, colors.ENDC
        if cookie == user_hash:
            return 1

    return 0
Exemplo n.º 17
0
def show_order(page_name):
    '''
    Return a page that has been rendered using a template
    '''
    if logined():
        user_id = request.cookies.get('id')
        # get mail
        cur = db.query("SELECT email FROM users WHERE user_id = %s" % user_id)
        email = cur.fetchone()[0]; 
        send_email(page_name, 'order_grats', email)
        send_email(page_name, 'admin_order_notify', email)
        return template('order', name=page_name, settings=get_settings(),
            menu_data=menu(), logined=logined(), user=get_username())
    else:
        return template('order_deny', name=page_name, settings=get_settings(),
            menu_data=menu(), logined=logined())
Exemplo n.º 18
0
def show_order(page_name):
    '''
    Return a page that has been rendered using a template
    '''
    if logined():
        user_id = request.cookies.get('id')
        # get mail
        cur = db.query("SELECT email FROM users WHERE user_id = %s" % user_id)
        email = cur.fetchone()[0]
        send_email(page_name, 'order_grats', email)
        send_email(page_name, 'admin_order_notify', email)
        return template('order',
                        name=page_name,
                        settings=get_settings(),
                        menu_data=menu(),
                        logined=logined(),
                        user=get_username())
    else:
        return template('order_deny',
                        name=page_name,
                        settings=get_settings(),
                        menu_data=menu(),
                        logined=logined())
Exemplo n.º 19
0
def customer_exist(customer_name):
    cur = db.query("SELECT p_hash FROM users WHERE login='******'" %
                   str(customer_name))
    return cur.fetchone()
Exemplo n.º 20
0
def menu():
    menu_content = []
    sections = []
    counter = 0
    menu_sections = db.query(
        "SELECT section_id,title,targetclass,link FROM menu_sections")
    for section in menu_sections:
        menu_element = []
        sections.append(section)
        if debug:
            print colors.HEADER, 'MENU SECTION ID:', colors.FAIL, section[
                0], colors.ENDC
        mc = db.query("SELECT * FROM menu_content WHERE section_id = %d" %
                      section[0])
        cur = db.query(
            "SELECT count(*) FROM menu_content WHERE section_id = %d" %
            section[0])
        menu_column_nums = int(cur.fetchone()[0])
        if debug:
            print colors.HEADER, 'MENU COLUMN NUMBER:', colors.FAIL, menu_column_nums, colors.ENDC
        for n in range(menu_column_nums):
            menu_content_cache = mc.fetchone()
            try:
                menu_content_column = {'title': 'bla'}  ## Initializing
                menu_content_column['title'] = menu_content_cache[0]
                menu_content_column['description'] = menu_content_cache[1]
                menu_content_column['price'] = menu_content_cache[2]
                menu_content_column['link'] = menu_content_cache[3]
                menu_content_column['section_id'] = menu_content_cache[5]
                menu_element.append(menu_content_column)

                if debug == 'off':
                    print '============Begin+=========='
                    print colors.OKBLUE, section[
                        0], colors.HEADER, 'title      ', colors.OKGREEN, menu_content_column[
                            'title'], colors.ENDC
                    print colors.OKBLUE, section[
                        0], colors.HEADER, 'description', colors.OKGREEN, menu_content_column[
                            'description'], colors.ENDC
                    print colors.OKBLUE, section[
                        0], colors.HEADER, 'price      ', colors.OKGREEN, menu_content_column[
                            'price'], colors.ENDC
                    print colors.OKBLUE, section[
                        0], colors.HEADER, 'link       ', colors.OKGREEN, menu_content_column[
                            'link'], colors.ENDC
                    print colors.OKBLUE, section[
                        0], colors.HEADER, 'section_id ', colors.OKGREEN, menu_content_column[
                            'section_id'], colors.ENDC
                    print '============End============='

            except TypeError:
                if debug:
                    print colors.HEADER, 'SKIPPING ', colors.FAIL, menu_content_cache, colors.ENDC
                continue
                #pass

        if not menu_element == []:  #not empty
            menu_content.append(menu_element)
        else:
            if debug:
                print colors.HEADER, 'SKIPPING append', colors.FAIL, menu_element, colors.ENDC

    menu_data = [sections, menu_content]
    if debug:
        for data in menu_data[1]:
            print colors.HEADER, 'RESULT ', colors.FAIL, data[0][
                'title'], colors.ENDC

    return menu_data
Exemplo n.º 21
0
def get_settings():
    settings = {'logo_path': '..'}
    cur = db.query("SELECT path,width,height FROM settings WHERE option_name='logo'")
    settings['logo_path'], settings['logo_width'], settings['logo_height'] = cur.fetchone()
    return settings
Exemplo n.º 22
0
def customer_exist(customer_name):
    cur = db.query("SELECT p_hash FROM users WHERE login='******'" % str(customer_name))
    return cur.fetchone()