Esempio n. 1
0
def index():
    if os.path.exists('tempstore.txt'):
        os.remove("tempstore.txt")
    form = IndividualForm()
    global batternameone
    global pitchernameone
    if form.validate_on_submit():
        batternameone=form.battername.data
        pitchernameone=form.pitchername.data
        return redirect('/matchup1')
    return render_template('index.html', form = form)
Esempio n. 2
0
def individual_submit(request):
    if request.method == 'POST':
        print request.POST
        individual_form = IndividualForm(request.POST, instance=Individual())
        req = Individual()
        req.individual_id = request.POST['individual_id']
        req.gender = request.POST['gender']
        if individual_form.is_valid():
            try:
                Individual.objects_get(indvidual_id=request.POST['individual_id'])
            except:
                individual_form.save(commit=True)
            ind = Individual.objects.all()
            context = {'individual': ind}
            return render(request, 'viewer/individuals/view_individual.html', context)
    else:
        individual_form = IndividualForm(instance=Individual())
        context = {
            'individual_form': individual_form
        }
        context.update(csrf(request))
        return render(request, 'viewer/individuals/individual_submit.html', context)
Esempio n. 3
0
def addindividual():
    form = IndividualForm()
    print(session, file=sys.stderr)
    if request.method == "GET":
        return render_template('addindividual.html', form=form, session=session)
    if request.method == "POST":
        print(session, file=sys.stderr)
        if form.validate() == True:
            cursor = mysql.connection.cursor()
            query = "INSERT INTO customer (customer_id, phone_number, email, street, city, state, postal_code) VALUES (NULL, %s, %s, %s, %s, %s, %s)"
            variables = [form.phone_number.data, form.email.data, form.street.data, form.city.data, form.state.data, form.postal_code.data]
            cursor.execute(query, variables)
            mysql.connection.commit()
            
            cursor = mysql.connection.cursor()
            cursor.execute("SELECT LAST_INSERT_ID()")
            last_customer_id = cursor.fetchall()
            query = "INSERT INTO individual (driver_license_number, customer_id, individual_first_name, individual_last_name) VALUES (%s, %s, %s, %s)"
            variables = [form.driver_license_number.data, last_customer_id, form.individual_first_name.data, form.individual_last_name.data]
            cursor.execute(query, variables)
            mysql.connection.commit()
            # print(previous_page, file=sys.stderr)
            if session["previous_page"] == "purchase":
              session["customer"] = {
                "customer_id": last_customer_id,
                "customer_type": "Individual",
                "customer_name": "{} {}".format(form.individual_first_name.data, form.individual_last_name.data)
              }
              return redirect(url_for("purchasevehicle"))
            else:
              session["customer"] = {
                "customer_id": last_customer_id,
                "customer_type": "Individual",
                "customer_name": "{} {}".format(form.individual_first_name.data, form.individual_last_name.data)
              }
              return redirect(url_for("sellvehicle", vin=session["vin"]))
        else:
            return render_template('addindividual.html', form=form)
Esempio n. 4
0
def matchup4():
    xoneed = 1
    xtwoed = 1
    xthreeed = 1
    if os.path.exists('tempstore.txt'):
        with open('tempstore.txt', 'r') as f:
            read_data = f.read()
            f.closed
        read_data = list(read_data)
        if '1' in read_data:
            xoneed = 0
        if '2' in read_data:
            xtwoed = 0
        if '3' in read_data:
            xthreeed = 0
    
    form = IndividualForm()
    bcluster = bclusterlookup(batternamefour)
    pcluster = pclusterlookup(pitchernamefour)
    global favratingfour
    favratingfour = getrating(bcluster, pcluster)

    global zerofour
    zerofour = 0
    global onefour
    onefour = 0
    global twofour
    twofour = 0
    global threefour
    threefour = 0
    global fourfour
    fourfour = 0
    global fivefour
    fivefour = 0
    global sixfour
    sixfour = 0
    global sevenfour
    sevenfour = 0
    global eightfour
    eightfour = 0
    global ninefour
    ninefour = 0
    global tenfour
    tenfour = 0
    if favratingfour< 5:
        zerofour = 1
    elif favratingfour < 15:
        onefour = 1
    elif favratingfour< 25:
        twofour = 1
    elif favratingfour< 35:
        threefour = 1
    elif favratingfour < 45:
        fourfour = 1
    elif favratingfour< 55:
        fivefour = 1
    elif favratingfour < 65:
        sixfour = 1
    elif favratingfour < 75:
        sevenfour = 1
    elif favratingfour< 85:
        eightfour = 1
    elif favratingfour< 95:
        ninefour = 1
    else:
        tenfour = 1

    walks = pd.read_csv('walks.csv', na_values=[' '], header=None)
    hits = pd.read_csv('hits.csv', na_values=[' '], header=None)
    hrs = pd.read_csv('hrs.csv', na_values=[' '], header=None)
    plateapps = pd.read_csv('plateapps.csv', na_values=[' '], header=None)
    walks = np.array(walks)
    hits = np.array(hits)
    hrs = np.array(hrs)
    plateapps = np.array(plateapps)
    if plateapps[bcluster-1, pcluster-1] == 0:
        plateapps[bcluster-1, pcluster-1] = 1
    awalkf = walks[bcluster-1, pcluster-1]/plateapps[bcluster-1, pcluster-1] * 100
    global awalkfour
    if bcluster == 0 or pcluster == 0:
        awalkfour = 0
    else:
        awalkfour = int(awalkf)
    ahrf = hrs[bcluster-1, pcluster-1]/plateapps[bcluster-1, pcluster-1] * 100
    global ahrfour
    if bcluster == 0 or pcluster == 0:
        ahrfour = 0
    else:
        ahrfour = int(ahrf)
    ahitf = hits[bcluster-1, pcluster-1]/plateapps[bcluster-1, pcluster-1] * 100
    global ahitfour
    if bcluster == 0 or pcluster == 0:
        ahitfour = 0
    else:
        ahitfour = int(ahitf)

    if form.validate_on_submit():
        return redirect('/index')

    return render_template('matchup4.html', zeroone = zeroone, oneone = oneone, twoone = twoone, threeone = threeone, fourone = fourone,
                           fiveone = fiveone, sixone = sixone, sevenone = sevenone, eightone = eightone, nineone = nineone, tenone = tenone,
                           batternameone = batternameone, pitchernameone = pitchernameone,
                           favratingone = favratingone, awalkone = awalkone, ahitone = ahitone, ahrone = ahrone,
                           zerotwo = zerotwo, onetwo = onetwo, twotwo = twotwo, threetwo = threetwo, fourtwo = fourtwo,
                           fivetwo = fivetwo, sixtwo = sixtwo, seventwo = seventwo, eighttwo = eighttwo, ninetwo = ninetwo, tentwo = tentwo,
                           batternametwo = batternametwo, pitchernametwo = pitchernametwo,
                           favratingtwo = favratingtwo, awalktwo = awalktwo, ahittwo = ahittwo, ahrtwo = ahrtwo,
                           zerothree = zerothree, onethree = onethree, twothree = twothree, threethree = threethree, fourthree = fourthree,
                           fivethree = fivethree, sixthree = sixthree, seventhree = seventhree, eightthree = eightthree, ninethree = ninethree, tenthree = tenthree,
                           batternamethree = batternamethree, pitchernamethree = pitchernamethree,
                           favratingthree = favratingthree, awalkthree = awalkthree, ahitthree = ahitthree, ahrthree = ahrthree,
                           zerofour = zerofour, onefour = onefour, twofour = twofour, threefour = threefour, fourfour = fourfour,
                           fivefour = fivefour, sixfour = sixfour, sevenfour = sevenfour, eightfour = eightfour, ninefour = ninefour, tenfour = tenfour,
                           batternamefour = batternamefour, pitchernamefour = pitchernamefour,
                           favratingfour = favratingfour, awalkfour = awalkfour, ahitfour = ahitfour, ahrfour = ahrfour,
                           xoneed = xoneed, xtwoed = xtwoed, xthreeed = xthreeed, form = form)
Esempio n. 5
0
def matchup2():
    xoneed = 1
    if os.path.exists('tempstore.txt'):
        with open('tempstore.txt', 'r') as f:
            read_data = f.read()
            f.closed
        read_data = list(read_data)
        if '1' in read_data:
            xoneed = 0
        
    form = IndividualForm()
    bcluster = bclusterlookup(batternametwo)
    pcluster = pclusterlookup(pitchernametwo)
    global favratingtwo
    favratingtwo = getrating(bcluster, pcluster)

    global zerotwo
    zerotwo = 0
    global onetwo
    onetwo = 0
    global twotwo
    twotwo = 0
    global threetwo
    threetwo = 0
    global fourtwo
    fourtwo = 0
    global fivetwo
    fivetwo = 0
    global sixtwo
    sixtwo = 0
    global seventwo
    seventwo = 0
    global eighttwo
    eighttwo = 0
    global ninetwo
    ninetwo = 0
    global tentwo
    tentwo = 0
    if favratingtwo< 5:
        zerotwo = 1
    elif favratingtwo < 15:
        onetwo = 1
    elif favratingtwo< 25:
        twotwo = 1
    elif favratingtwo< 35:
        threetwo = 1
    elif favratingtwo < 45:
        fourtwo = 1
    elif favratingtwo< 55:
        fivetwo = 1
    elif favratingtwo < 65:
        sixtwo = 1
    elif favratingtwo < 75:
        seventwo = 1
    elif favratingtwo< 85:
        eighttwo = 1
    elif favratingtwo< 95:
        ninetwo = 1
    else:
        tentwo = 1

    walks = pd.read_csv('walks.csv', na_values=[' '], header=None)
    hits = pd.read_csv('hits.csv', na_values=[' '], header=None)
    hrs = pd.read_csv('hrs.csv', na_values=[' '], header=None)
    plateapps = pd.read_csv('plateapps.csv', na_values=[' '], header=None)
    walks = np.array(walks)
    hits = np.array(hits)
    hrs = np.array(hrs)
    plateapps = np.array(plateapps)
    if plateapps[bcluster-1, pcluster-1] == 0:
        plateapps[bcluster-1, pcluster-1] = 1
    awalkf = walks[bcluster-1, pcluster-1]/plateapps[bcluster-1, pcluster-1] * 100
    global awalktwo
    if bcluster == 0 or pcluster == 0:
        awalktwo = 0
    else:
        awalktwo = int(awalkf)
    ahrf = hrs[bcluster-1, pcluster-1]/plateapps[bcluster-1, pcluster-1] * 100
    global ahrtwo
    if bcluster == 0 or pcluster == 0 :
        ahrtwo = 0
    else:
        ahrtwo = int(ahrf)
    ahitf = hits[bcluster-1, pcluster-1]/plateapps[bcluster-1, pcluster-1] * 100
    global ahittwo
    if bcluster == 0 or pcluster == 0:
        ahittwo = 0
    else:
        ahittwo = int(ahitf)

    global batternamethree
    global pitchernamethree
    if form.validate_on_submit():
        batternamethree=form.battername.data
        pitchernamethree=form.pitchername.data
        return redirect('/matchup3')
    return render_template('matchup2.html', zeroone = zeroone, oneone = oneone, twoone = twoone, threeone = threeone, fourone = fourone,
                           fiveone = fiveone, sixone = sixone, sevenone = sevenone, eightone = eightone, nineone = nineone, tenone = tenone,
                           batternameone = batternameone, pitchernameone = pitchernameone,
                           favratingone = favratingone, awalkone = awalkone, ahitone = ahitone, ahrone = ahrone,
                           zerotwo = zerotwo, onetwo = onetwo, twotwo = twotwo, threetwo = threetwo, fourtwo = fourtwo,
                           fivetwo = fivetwo, sixtwo = sixtwo, seventwo = seventwo, eighttwo = eighttwo, ninetwo = ninetwo, tentwo = tentwo,
                           batternametwo = batternametwo, pitchernametwo = pitchernametwo,
                           favratingtwo = favratingtwo, awalktwo = awalktwo, ahittwo = ahittwo, ahrtwo = ahrtwo,
                           xoneed = xoneed, form = form)
Esempio n. 6
0
def matchup1():
    form = IndividualForm()
    bcluster = bclusterlookup(batternameone)
    pcluster = pclusterlookup(pitchernameone)
    global favratingone
    favratingone = getrating(bcluster, pcluster)

    global zeroone
    zeroone = 0
    global oneone
    oneone = 0
    global twoone
    twoone = 0
    global threeone
    threeone = 0
    global fourone
    fourone = 0
    global fiveone
    fiveone = 0
    global sixone
    sixone = 0
    global sevenone
    sevenone = 0
    global eightone
    eightone = 0
    global nineone
    nineone = 0
    global tenone
    tenone = 0
    if favratingone< 5:
        zeroone = 1
    elif favratingone < 15:
        oneone = 1
    elif favratingone< 25:
        twoone = 1
    elif favratingone< 35:
        threeone = 1
    elif favratingone < 45:
        fourone = 1
    elif favratingone< 55:
        fiveone = 1
    elif favratingone < 65:
        sixone = 1
    elif favratingone < 75:
        sevenone = 1
    elif favratingone< 85:
        eightone = 1
    elif favratingone< 95:
        nineone = 1
    else:
        tenone = 1

    walks = pd.read_csv('walks.csv', na_values=[' '], header=None)
    hits = pd.read_csv('hits.csv', na_values=[' '], header=None)
    hrs = pd.read_csv('hrs.csv', na_values=[' '], header=None)
    plateapps = pd.read_csv('plateapps.csv', na_values=[' '], header=None)
    walks = np.array(walks)
    hits = np.array(hits)
    hrs = np.array(hrs)
    plateapps = np.array(plateapps)
    if plateapps[bcluster-1, pcluster-1] == 0:
        plateapps[bcluster-1, pcluster-1] = 1
    awalkf = walks[bcluster-1, pcluster-1]/plateapps[bcluster-1, pcluster-1] * 100
    global awalkone
    if bcluster == 0 or pcluster == 0:
        awalkone = 0
    else:
        awalkone = int(awalkf)
    ahrf = hrs[bcluster-1, pcluster-1]/plateapps[bcluster-1, pcluster-1] * 100
    global ahrone
    if bcluster == 0 or pcluster == 0:
        ahrone = 0
    else:
        ahrone = int(ahrf)
    ahitf = hits[bcluster-1, pcluster-1]/plateapps[bcluster-1, pcluster-1] * 100
    global ahitone
    if bcluster == 0 or pcluster == 0:
        ahitone = 0
    else:
        ahitone = int(ahitf)

    global batternametwo
    global pitchernametwo
    if form.validate_on_submit():
        batternametwo=form.battername.data
        pitchernametwo=form.pitchername.data
        return redirect('/matchup2')    
    return render_template('matchup1.html', zeroone = zeroone, oneone = oneone, twoone = twoone, threeone = threeone, fourone = fourone,
                           fiveone = fiveone, sixone = sixone, sevenone = sevenone, eightone = eightone, nineone = nineone, tenone = tenone,
                           batternameone = batternameone, pitchernameone = pitchernameone,
                           favratingone = favratingone, awalkone = awalkone, ahitone = ahitone, ahrone = ahrone, form = form)