Esempio n. 1
0
def resendVerifcaiton(UserID):

    #Clean the Passed UserID
    UserID = Checking.RemoveUnwantedChar(UserID)

    # Connect to the SQL server
    dbConn = SqlConn.ConnectToDB()

    # Check if the user exisits and get its data
    para = {"userID": UserID}
    ur = SqlConn.SendSQL(dbConn, "SELECT ourusers.`email` as email, `firstname`, `lastname` FROM ourusers, `employee` " + \
                      "WHERE ourusers.`userid`=%(userID)s AND verified = 0 AND ourusers.userid = employee.userid", para)

    if ur == None:
        print("Fail")
        return beecFunc.ReturnResponse("Fail")

    # Create new Verifcation code
    VirifcationCode = str(SqlConn.GenerateRadom(3))
    VirifcationCode = Hashing.sha3_256(
        VirifcationCode.encode()).hexdigest()[2:10]
    VirifcationCode = VirifcationCode.upper()

    # Update the code to the database
    para = {"vcode": VirifcationCode, "userID": UserID}
    SqlConn.InsertSQL(
        dbConn,
        "UPDATE `verifications` SET `vercode`= %(vcode)s WHERE `UserID`=%(userID)s",
        para, False)

    # Close DB Connection
    SqlConn.CloseConnection(dbConn)

    # Send the email
    try:
        beecFunc.SendEmail(emailSubject="Avtivate you account with eCards", emailTo=ur[0][0],
                       emailBody="Hi Mr. " + ur[0][1] + " " + ur[0][2] + \
                                 ", \n You have register with us and complete your registration please click the line bellow or use this Code:\n" + \
                                 VirifcationCode + " \n Thank you ...")
    except:
        print("Email Failer")
        return beecFunc.ReturnResponse("EmailFail")

    return beecFunc.ReturnResponse("OK")
Esempio n. 2
0
def RegisterNewUser():
    if request.method == 'POST':
        # Convert the input to JSON object
        FullInData = json.dumps(request.form)
        FullInData = json.loads(FullInData)

        # print("Resived:", FullInData)

        try:
            # return FullInData;

            # Check email format
            if Checking.CheckEamilFormat(FullInData['email']):
                # Check email Match
                if (FullInData['email']) == (FullInData['Reenter']
                                             or 'WEB' not in FullInData):
                    print("email check passed")
                    pass
                else:
                    if 'WEB' not in FullInData:
                        return beecFunc.ReturnResponse("Email Match")
                    else:
                        return Msgs.getErrorMessage(0, "EN")
            else:
                if 'WEB' not in FullInData:
                    return beecFunc.ReturnResponse("Email Format")
                else:
                    return Msgs.getErrorMessage(1, "EN")

            # Check Password Match
            if FullInData['Passowrd'] == FullInData[
                    'pReenter'] or 'WEB' not in FullInData:
                # Password Complexity
                d = Checking.passwordComplexity(FullInData['Passowrd'])

                if d == "OK":
                    print("Password Complexity Passed")
                    pass
                else:
                    print("Password Complexity FAILD")
                    if 'WEB' not in FullInData:
                        return beecFunc.ReturnResponse("Pwd Complexity")
                    else:
                        return Msgs.getErrorMessage(2, "EN")
            else:
                if 'WEB' not in FullInData:
                    return beecFunc.ReturnResponse("Pwd Match")
                else:
                    return Msgs.getErrorMessage(3, "EN")

            # Virify the username
            # FullInData['UserName'] = Checking.RemoveUnwantedChar(FullInData['UserName'])

            # Clean all input data
            for x in FullInData:
                if x != "Passowrd" and x != "email":
                    FullInData[x] = Checking.RemoveUnwantedChar(FullInData[x])
        except KeyError:
            if 'WEB' not in FullInData:
                return beecFunc.ReturnResponse("Passed Key error: " +
                                               str(KeyError))
            else:
                return "Passed Key error: " + str(KeyError)
        except:
            if 'WEB' not in FullInData:
                return beecFunc.ReturnResponse("Other Error")
            else:
                return "Some error in you request"

        # ----------------------------------------
        #   Everything is ok
        # ----------------------------------------

        print("Everything is OK")

        ErrorArray = []

        # Create User ID
        FullInData['userid'] = str(SqlConn.GenerateRadom(8))
        FullInData['password'] = beecFunc.hasPassword(FullInData['Passowrd'])

        # Connect to the SQL serer
        dbConn = SqlConn.ConnectToDB()

        # 1 Insert the user
        ResultData = SqlConn.InsertSQL(
            dbConn,
            "INSERT INTO `ourusers`(`CanLogin`,`points`,`userroleid`,`userid`, `email`,`password`) VALUES (1, 0, 122, %(userid)s, %(email)s, %(password)s )",
            FullInData, False)

        # Check if result is ok
        if ResultData == None or ResultData[0] != "OK":

            # If the error was becuse exisiting email, change the 'err' title to exisit
            # This is to dispaly the correct error message on the app

            if 'WEB' not in FullInData:
                if "exisits" in ResultData[1]:
                    return beecFunc.ReturnResponse("Exisit")
                else:
                    return beecFunc.ReturnResponse(ResultData[1])
            else:
                return str(ResultData)

        # 2 Get the new created Licese ID
        # LicSQL = SqlConn.SendSQL(dbConn, "SELECT `licencesid` FROM `licences` WHERE `type`='E' AND `CreatedFor`=' " + str(UserID) + "'")

        para = {"username": FullInData['userid']}
        LicSQL = SqlConn.SendSQL(
            dbConn,
            "SELECT `licencesid` FROM `licences` WHERE `type`='E' AND `CreatedFor`=%(username)s",
            para)
        # print(FullInData['userid'])
        FullInData["LicenceID"] = str(LicSQL[0][0])

        # 3 Create and employee

        # print("FullInData[1LicenceID1]=", FullInData["LicenceID"])
        myInsert = "INSERT INTO `employee`(`empid`, `nickname`, `firstname`, `middlename`, `grandname`, `lastname`, `abuname`, " + \
                   "`phone`, `mobile`, `hometel`, `email`, `workphone`, `notes`, `userid`, `licencesid`) VALUES ('1'," + \
                   " %(Nickname)s , %(FirstName)s, %(MiddleName)s , %(GrandFatherName)s , %(FamilyName)s ,%(AbuName)s , %(PhoneNumber)s" + \
                   ", %(MobileNumber)s , %(HomePhone)s , %(email)s , %(Workphone)s , %(notes)s , %(userid)s , %(LicenceID)s )"

        ResultData = SqlConn.InsertSQL(dbConn, myInsert, FullInData, True)

        # ------------
        # 4 SEND EMAIL

        if ResultData[0] == "OK":
            # Create the Verifcation code
            VirifcationCode = str(SqlConn.GenerateRadom(3))
            VirifcationCode = Hashing.sha3_256(
                VirifcationCode.encode()).hexdigest()[2:10]
            VirifcationCode = VirifcationCode.upper()

            # Save the code to the database
            para = {"vcode": VirifcationCode, "userID": FullInData['userid']}
            SqlConn.InsertSQL(
                dbConn,
                "INSERT INTO `verifications`(`vercode`, `UserID`) VALUES (%(vcode)s,%(userID)s )",
                para, False)

            # Send the email
            try:
                beecFunc.SendEmail(emailSubject="Avtivate you account with eCards", emailTo=FullInData['email'],
                               emailBody="Hi Mr. " + FullInData['FirstName'] + \
                                         ", \n You have register with us and complete your registration please click the line bellow or use this Code:\n" + \
                                         VirifcationCode + " \n Thank you ...")
            except:
                ErrorArray.append("Email")

            # Close DB Connection
            SqlConn.CloseConnection(dbConn)

            # 5 Redirect to verificaiton
            RR = flask.send_from_directory("HTML", "EmailVerifcation.html")
            if 'WEB' not in FullInData:
                if len(ErrorArray) > 0:
                    if "Email" in ErrorArray:
                        return beecFunc.ReturnResponse(
                            {
                                "Result": "Email",
                                "UserID": ResultData[1]
                            }, True)
                else:
                    return beecFunc.ReturnResponse(
                        {
                            "Result": "OK",
                            "UserID": ResultData[1]
                        }, True)
            else:
                return str(RR)

        # Close DB Connection
        SqlConn.CloseConnection(dbConn)

        if 'WEB' not in FullInData:
            return beecFunc.ReturnResponse(ResultData)
        else:
            return str(ResultData)

        # return Msgs.getErrorMessage(4, "EN") + FullInData['UserName']

    elif request.method == 'GET':
        # If it get, simply return the registration form
        return flask.send_from_directory("HTML", "Register.html")