app.py

from flask import Flask, render_template, request,send_from_directory, jsonify, url_for
from flask import redirect
# import gspread
# from oauth2client.service_account import ServiceAccountCredentials

import sys
sys.path.insert(0,'util/')
# from filename import function

import datetime
import pytz
from send_otp import send_otp_sms,send_otp_general_sms
from validate_phone import validate_phone

from read_sheet import get_sheet
from mumbai_helper import insert_into_gsheet_mumbai

from datetime import date


application = Flask(__name__)

# column number where status is mentioned in the sheet
request_status_index=8


# column number where benificiary number is mentioned in the sheet
beneficiary_contact_index=11
beneficiary_name_index=16
beneficiary_type_index=17




def convert_list_to_dict(the_request):
    dict_request={}
    dict_request["request_id"]=the_request[0]

    dict_request["name"]=the_request[1]
    dict_request["contact_num"]=the_request[2]
    # dict_request["lat"]=int(float(the_request[3]))
    # dict_request["lon"]=int(float(the_request[4]))
    dict_request["requestor_address"]=the_request[3]
    dict_request["city"]=the_request[4]
    dict_request["locality"]=the_request[5]
    dict_request["landmark"]=the_request[6]
    dict_request["request_status"]=the_request[7]

    dict_request["num_needy"]=the_request[8]
    dict_request["type_help"]=the_request[9]

    # a gap for beneficiary
    dict_request["volunteer_name"]=the_request[11]
    dict_request["vol_contact_num"]=the_request[12]

    
    dict_request["date_of_entry"]=the_request[13]
    # gap for remarks
    dict_request["beneficiary_name"]=the_request[15]
    dict_request["beneficiary_type"]=the_request[16]


    print(dict_request)
    return dict_request


def convert_ngoItem_to_dict(the_request):
    dict_request={}
    dict_request["ngo_name"]=the_request[0]

    dict_request["cat_help"]=the_request[1]
    dict_request["city"]=the_request[2]
    # dict_request["lat"]=int(float(the_request[3]))
    # dict_request["lon"]=int(float(the_request[4]))
    dict_request["target_area"]=the_request[3]
    dict_request["contact"]=the_request[4]
    dict_request["bank_detail"]=the_request[5]

    print(dict_request)
    return dict_request


def get_requests(sheetname,sheetType,need_status):
    '''
    insert into the google sheet in the order
    name, contact_num,lat, lon, address,
    rice_qty, wheat_qty, oil_qty, daal_qty,
    request_status
    '''

    # if need_status=="Completed":
    #     sheetname="Daily_Completed"
    # elif need_status=="Pending":
    #     sheetname="Details_People"

    status,sheet=get_sheet(sheetname)
    if status == False:
        return sheet
    list_of_requests=(sheet.get_all_values())
    print("number of rows ",len(sheet.get_all_values()))
    print("number of columns ",len(sheet.get_all_values()[0]))

    list_requests=[]

    if sheetType=="ngo":
        for req in list_of_requests[1:]:
            list_requests.append(convert_ngoItem_to_dict(req))
        return list_requests
            
    # skip the first request since it is heading
    for the_request in list_of_requests[1:]:
        print("status is ",the_request[request_status_index-1],need_status)


        if the_request[request_status_index-1]==need_status:

            # dict_request={}
            # dict_request["request_id"]=the_request[0]

            # dict_request["name"]=the_request[1]
            # dict_request["contact_num"]=the_request[2]
            # # dict_request["lat"]=int(float(the_request[3]))
            # # dict_request["lon"]=int(float(the_request[4]))
            # dict_request["requestor_address"]=the_request[3]
            # dict_request["request_status"]=the_request[4]

            # dict_request["rice_qty"]=the_request[5]
            # dict_request["wheat_qty"]=the_request[6]
            # dict_request["oil_qty"]=the_request[7]
            # dict_request["daal_qty"]=the_request[8]
            # # a gap for beneficiary
            # dict_request["volunteer_name"]=the_request[10]
            # dict_request["vol_contact_num"]=the_request[11]

            dict_request=convert_list_to_dict(the_request)


            list_requests.append(dict_request)

    return list_requests




###################### begin ####################################
###################### mumbai code###############################
#################################################################



@application.route('/')
def show_home_mumbai():
    return render_template('base_mumbai.html')


@application.route('/addmumbaimeal')
def addmumbaimeal():
    return render_template('addmumbaimeal.html')

@application.route('/contactmumbai')
def contactmumbai():
    return render_template('contactmumbai.html')


@application.route('/intermediate-register-confirmation-mumbai')
def intermediate_register_confirmation_mumbai():
    return render_template('intermediate-register-confirmation-mumbai.html')


@application.route('/thank-you-mumbai')
def thank_you_mumbai():
    return render_template("thank-you-mumbai.html")




@application.route('/pendingmumbai')
def pendingmumbai():

    '''
    this function shows pending requests
    '''
    list_requests=get_requests(sheetname="Details_People_Mumbai",sheetType="common",need_status="Pending")
    print("requests are ",list_requests)

    return render_template("pendingmumbai.html", items=list_requests)


@application.route('/completedmumbai',methods=["GET"])
def completedmumbai():
    '''
    this function shows completed requests
    '''
    list_requests=get_requests(sheetname="Details_People_Mumbai",sheetType="common",need_status="Completed")
    print("requests are ",list_requests)

    return render_template("completedmumbai.html", items=list_requests)

@application.route('/ngomumbai',methods=["GET"])
def ngomumbai():
    '''
    this function shows completed requests
    '''
    # list_requests=get_requests(sheetname="NGO_Donation",need_status="Verified")
    list_requests=get_requests(sheetname="NGO_Donation",sheetType="ngo",need_status="Verified")
    print("requests are ",list_requests)

    return render_template("ngomumbai.html", items=list_requests)




@application.route('/load_in_sheet_mumbai',methods=["POST"])
def add_pending_request_mumbai():

    data_list=[]
    # print(request.form.keys)
    name=str(request.form['requestor_name'])
    contact_num=str(request.form['contact_num'])


    requestor_address=str(request.form['requestor_address'])
    
    requestor_city=str(request.form['requestor_city'])
    requestor_locality=str(request.form['requestor_locality'])
    requestor_landmark=str(request.form['requestor_landmark'])
    type_help=str(request.form['type_help'])

    request_status="Pending"

    # here get approx location from lat long

    volunteer_name=str(request.form['volunteer_name'])
    vol_contact_num=str(request.form['vol_contact_num'])
    num_needy=str(request.form['num_needy'])
    
    
    # put them in a list to be inserted into the sheet
    data_list.append(name)
    data_list.append(contact_num)
    data_list.append(requestor_address)
    data_list.append(requestor_city)
    data_list.append(requestor_locality)
    data_list.append(requestor_landmark)
    data_list.append(request_status)
    data_list.append(num_needy)
    data_list.append(type_help)
    data_list.append("")
    # above is for benificiary contact_num

    data_list.append(volunteer_name)
    data_list.append(vol_contact_num)    
    today = date.today()
    data_list.append(str(today.strftime("%d/%m/%Y")))

    status = insert_into_gsheet_mumbai(data_list)

    return redirect(url_for("intermediate_register_confirmation_mumbai"))
    # return render_template('intermediate-register-confirmation-mumbai.html')




@application.route('/checkoutmumbai',methods=["POST"])
def checkoutmumbai():

    list_ids_to_mark_complete=[]
    print(request.form.keys)
    for key,val in request.form.items():
        print(key)
        if key!="contact_num" and key!="contrib_name" and key !="contrib_type":
            list_ids_to_mark_complete.append(int(float(val)))
    print("to be completed",list_ids_to_mark_complete)

    benificiary_contact=request.form['contact_num']
    contrib_name=request.form['contrib_name']
    contrib_type=request.form['contrib_type']
    

    # some form validation here

    mobile_issue=False
    if benificiary_contact=="":
        mobile_issue=True

    if not benificiary_contact.isdecimal():
        mobile_issue=True

    if len(benificiary_contact)!=10:
        mobile_issue=True

    if mobile_issue:
        return "Please retry with proper mobile number"



    if len(list_ids_to_mark_complete)==0:
        return "Please go back and click on the check boxes \
        to select the requirements you want to fulfill."


    status,sheet=get_sheet("Details_People_Mumbai")
    if status==False:
        return sheet
    list_of_requests=(sheet.get_all_values())

    list_to_be_fulfilled=[]

    row_count=2
    for the_request in list_of_requests[1:]:
        if int(float(the_request[0])) in list_ids_to_mark_complete:
            # first create a dict out of the row

            dict_request=convert_list_to_dict(the_request)

            list_to_be_fulfilled.append(dict_request)
            # sheet.update_cell(row_count, request_status_index+1, "Completed")
            # sheet.update_cell(row_count, beneficiary_contact_index+1, str(benificiary_contact))
        row_count+=1

    print(list_to_be_fulfilled)

    dict_order={"contributor_number":str(benificiary_contact)}
    dict_order["order"]=list_to_be_fulfilled
    dict_order["contrib_name"]=contrib_name
    dict_order["contrib_type"]=contrib_type
    


    # now generate the otp
    return_str=send_otp_sms(str(benificiary_contact).strip())
    dict_order["return_message"]=return_str


    return render_template("otp_payment_mumbai.html", items=dict_order)



@application.route('/complete_payment_mumbai',methods=["POST"])
def complete_payment_mumbai():
    list_ids_to_mark_complete=[]
    print(request.form.keys)
    for key,val in request.form.items():
        print("k is ",key)
        if key!="contact_num" and key!="otp_num" and key!="return_message" and key!="contrib_name" and key!="contrib_type":
            list_ids_to_mark_complete.append(int(float(val)))
    print(list_ids_to_mark_complete)
    benificiary_contact=request.form['contact_num']
    otp_num=request.form['otp_num']
    # amount_pledged=request.form['amount_pledged']
    contrib_name=request.form['contrib_name']
    contrib_type=request.form['contrib_type']



    # now to check if otp matches with the otp mentioned in the sheet
    # also check for expired otp

    is_valid=True
    is_valid=validate_phone(benificiary_contact,otp_num)

    print("checked the otp")

    if is_valid:







        status,sheet=get_sheet("Details_People_Mumbai")
        if status==False:
            return sheet
        list_of_requests=(sheet.get_all_values())

        list_to_be_fulfilled=[]

        row_count=2


        # we'll check if the request ids match
        for the_request in list_of_requests[1:]:
            if int(float(the_request[0])) in list_ids_to_mark_complete:
                sheet.update_cell(row_count, request_status_index, "Completed")
                sheet.update_cell(row_count, beneficiary_contact_index,
                 str(benificiary_contact))
                sheet.update_cell(row_count, beneficiary_name_index,
                 str(contrib_name))
                sheet.update_cell(row_count, beneficiary_type_index,
                 str(contrib_type))
                


            row_count+=1



        return redirect(url_for("thank_you_mumbai"))
        # return render_template("thank-you-mumbai.html")
    else:
        return "Some issue with your OTP, please go back and check out again"





######################### end ###################################
###################### mumbai code###############################
#################################################################


if __name__ == "__main__":


    application.run(host="0.0.0.0", debug=True)