def create(): form = CreateAgentForm() if form.validate_on_submit(): flash('Login requested for OpenID="%s"' % form.name) insert(form) # Insert agent return redirect('/index') return render_template('create.html', title='Sign In', form=form)
def add_bank(): form = Addbank() if(form.validate_on_submit()): length = query_db('select count(*) from bank') new_id = 'B_' + str(int(length[0][0]) + 1) insert('bank',('bid', 'lat', 'long', 'rateoffr'),(new_id,float(form.lat.data),float(form.long.data),float(form.rateoffr.data))) flash("Successfully added") return redirect(url_for('add_bank')) return render_template('bank.html',title="bank",form=form)
def insertintoshopinv(): insert('shop_inv', ('svid', 'item_name', 'item_price', 'units'), ('SV_191', 'rice', 150.00, 100)) insert('shop_inv', ('svid', 'item_name', 'item_price', 'units'), ('SV_191', 'Chicken', 250.00, 123)) insert('shop_inv', ('svid', 'item_name', 'item_price', 'units'), ('SV_192', 'rice', 100.00, 232)) insert('shop_inv', ('svid', 'item_name', 'item_price', 'units'), ('SV_192', 'cotton', 80.00, 111)) insert('shop_inv', ('svid', 'item_name', 'item_price', 'units'), ('SV_193', 'rice', 300.00, 111))
def insertintosvcrop(): insert('svcrop', ('svid', 'cid', 'amount_bought'), ('C_101', 'SV_191', 100)) insert('svcrop', ('svid', 'cid', 'amount_bought'), ('C_101', 'SV_192', 232)) insert('svcrop', ('svid', 'cid', 'amount_bought'), ('C_102', 'SV_193', 111)) insert('svcrop', ('svid', 'cid', 'amount_bought'), ('C_103', 'SV_192', 111)) insert('svcrop', ('svid', 'cid', 'amount_bought'), ('C_102', 'SV_191', 123))
def add_shop_inv(): form = AddShopInv() if form.validate_on_submit(): length = query_db(('Select COUNT(*) from shop_inv where svid=\'{}\' and item_name=\'{}\'').format(form.svid.data,form.item_name.data)) if(length[0][0] == 0): insert('shop_inv',('svid','item_name','item_price','units'),(form.svid.data,form.item_name.data,float(form.item_price.data),float(form.units.data))) else: update_shopinv_amount(float(form.units.data),form.svid.data,form.item_name.data) flash("Successfully added") return redirect(url_for('add_shop_inv')) return render_template('shop_inv.html',title="shop inventory",form=form)
def add_storagefac(): form = AddStoragefac() if form.validate_on_submit(): length = query_db('Select COUNT(*) from storagefacloc') new_id = 'S_' + str(int(length[0][0]) + 1) insert('storagefacloc',('sid', 'suitcond', 'size', 'unit', 'price', 'lat', 'long', 'typeoffarming', 'spaceleft', 'availability'), (new_id,form.suitcond.data,float(form.size.data),form.unit.data,float(form.price.data),float(form.lat.data),float(form.long.data),form.typeoffarming.data,float(float(form.spaceleft.data)),form.availability.data)) insert('spstorage',('sid','spid'),(new_id,form.Storageprov_id.data)) flash("Successfully added") return redirect(url_for('add_storagefac')) return render_template('storagefac.html',title="storage facility location",form = form)
def add_crop(): form = AddCrop() if form.validate_on_submit(): store_length= query_db('Select COUNT(*) from crop') print('Total records before a crop was added: ', store_length[0][0]) new_id= 'C_'+str(int(store_length[0][0])+1) print('New ID allocated to the transporter is: ', new_id) insert('crop', ('cid', 'cname', 'units', 'typeoffarming', 'quantity', 'price'), (new_id, form.name.data, int(float(form.units.data)), form.farming.data, float(float(form.quantity.data)), float(float(form.price.data)))) print('All records for the crop are: ') print(query_db("Select * from crop")) insert('landcrop',('lid','cid'),(form.land_id.data,new_id)) flash("Successfully added new crop {}!".format(new_id)) return redirect(url_for('add_crop')) return render_template('crop.html', title="Crop", form=form)
def add_shopvendor(): form = AddShopVendor() if form.validate_on_submit(): print('\n\nIncoming Data: ', (form.name.data, int(form.contact.data), float(float(form.lat.data)), float(float(form.long.data)), 0)) store_length= query_db('Select COUNT(*) from shopvendor') print('Total records before a shopvendor was added: ', store_length[0][0]) new_id= 'SV_'+str(int(store_length[0][0])+1) print('New ID allocated to the transporter is: ', new_id) insert('shopvendor', ('svid', 'svname', 'scontact', 'lat', 'long', 'authorized'), (new_id, form.name.data, int(form.contact.data), float(float(form.lat.data)), float(float(form.long.data)), 0)) print('All records for the shopvendor are: ') print(query_db("Select * from shopvendor")) flash("Successfully added new shopvendor {}!".format(form.name.data)) return redirect(url_for('add_shopvendor')) return render_template('shopvendor.html', title="Shop Vendor", form=form)
def add_storage_provider(): form = AddStorageProvider() if form.validate_on_submit(): store_length= query_db('Select COUNT(*) from storageprov') print('Total records before a storageprov was added: ', store_length[0][0]) new_id= 'SP_'+str(int(store_length[0][0])+1) print('New ID allocated to the storageprov is: ', new_id) insert('storageprov', ('spid','sname','contact','lat','long','authorized'), (new_id, form.name.data, int(form.contact.data), float(float(form.lat.data)), float(float(form.long.data)), 0)) print('All records for the storageprov are: ') print(query_db("Select * from storageprov")) flash("Successfully added new storageprov {}!".format(new_id)) return redirect(url_for('add_storage_provider')) store_length= query_db('Select COUNT(*) from storageprov') print('Total records before loading storageprov: ', store_length[0][0]) return render_template('storageprov.html', title="Storageprov", form=form)
def add_transporter(): form = AddTransporter() if form.validate_on_submit(): store_length= query_db('Select COUNT(*) from transporter') print('Total records before a transporter was added: ', store_length[0][0]) new_id= 'T_'+str(int(store_length[0][0])+1) print('New ID allocated to the transporter is: ', new_id) insert('transporter', ('tid', 'tname', 'price', 'mintwht' , 'maxtwht', 'lat', 'long', 'resavl', 'authorized'), (new_id, form.tname.data, float(float(form.price.data)), float(form.mintwht.data), float(form.maxtwht.data), float(float(form.lat.data)), float(float(form.long.data)), float(form.resavl.data), 0)) print('All records for the transporter are: ') print(query_db("Select * from transporter")) flash("Successfully added new transporter {}!".format(new_id)) return redirect(url_for('add_transporter')) store_length= query_db('Select COUNT(*) from transporter') print('Total records before loading transporter: ', store_length[0][0]) return render_template('transporter.html', title="Transporter", form=form)
def insertintofarmer(): insert('farmer', ('fid', 'fname', 'fcontact', 'authorized', 'lat', 'long'), ('F_102', 'Ramu', 9997712345, 1, 28.613459, 77.176208)) insert('farmer', ('fid', 'fname', 'fcontact', 'authorized', 'lat', 'long'), ('F_104', 'Sahu', 9412345678, 0, 28.603212, 77.188439)) insert('farmer', ('fid', 'fname', 'fcontact', 'authorized', 'lat', 'long'), ('F_105', 'Sid', 7771122333, 1, 28.596580, 77.181745))
def insertintoland(): insert('land', ('lid', 'areaocc', 'lat', 'long'), ('LD_1321', 44.12, 28.605548, 77.199597)) insert('land', ('lid', 'areaocc', 'lat', 'long'), ('LD_5412', 12.89, 28.603212, 77.203631)) insert('land', ('lid', 'areaocc', 'lat', 'long'), ('LD_3498', 23.01, 28.598238, 77.207236))
def insertintobank(): insert('bank', ('bid', 'lat', 'long', 'rateoffr', 'authorized'), ("B_101", 28.614929, 77.217944, 1500, 1)) insert('bank', ('bid', 'lat', 'long', 'rateoffr', 'authorized'), ("B_103", 28.614062, 77.220604, 2309, 0)) insert('bank', ('bid', 'lat', 'long', 'rateoffr', 'authorized'), ("B-104", 28.610445, 77.222106, 3400, 1))
def add_package(): if request.method == 'POST': data = request.form for i, j in data.items(): if j: pass else: return redirect(url_for('register', error='All the fields are required!') ) add = insert() id = add.add_package(uid=session['user'], **data) return redirect(url_for('succ_reg', track_id=id)) return redirect(url_for('register', error="Unsuccesfull"))
def add_admin(): if request.method == 'POST': data = request.form if data['password1'] == data['password2']: add = insert() x = add.add_admin(**data) if x: return redirect(url_for('admin', error="success")) else: return redirect(url_for('admin', error="Username already exist")) else: return redirect(url_for('admin', error="Passwords do not match"))
def post_user_suggestion(request_data): try: user_name = request_data['user_name'] except KeyError as _: raise BlankException( f'''There is no field [user_name] in the request body''') try: suggestion = request_data['suggestion'] except KeyError as _: raise BlankException( f'''There is no field [suggestion] in the request body''') return insert('user_suggestions', user_name=user_name, suggestion=suggestion)
def insertintoshopv(): insert('shopvendor', ('svid', 'svname', 'scontact', 'lat', 'long', 'authorized'), ('SV_191', 'Shop Benndor', 9898989898, 28.605133, 77.202709, 1)) insert('shopvendor', ('svid', 'svname', 'scontact', 'lat', 'long', 'authorized'), ('SV_192', 'Shop Vendoe', 9898989898, 28.604116, 77.204254, 1)) insert('shopvendor', ('svid', 'svname', 'scontact', 'lat', 'long', 'authorized'), ('SV_193', 'Shop LOL', 9898989898, 28.598012, 77.204812, 0))
def insertintocrop(): insert('crop', ('cid', 'cname', 'units', 'typeoffarming', 'quantity', 'price'), ('C_101', 'rice', 'kg', 'commercial farming', 1.6, 30)) insert('crop', ('cid', 'cname', 'units', 'typeoffarming', 'quantity', 'price'), ('C_103', 'cotton', 'kg', 'Extensive farming', 34.2, 10)) insert('crop', ('cid', 'cname', 'units', 'typeoffarming', 'quantity', 'price'), ('C_102', 'Chicken', 'kg', 'poultry farming', 39.7, 120))
def insertintostorageprov(): insert('storageprov', ('spid', 'sname', 'contact', 'lat', 'long', 'authorized'), ('SP_101', 'Madhav Thakur', 9999999999, 28.615268, 77.193353, 0)) insert('storageprov', ('spid', 'sname', 'contact', 'lat', 'long', 'authorized'), ('SP_102', 'Rajesh Prasad', 9999999888, 28.615155, 77.198460, 1)) insert('storageprov', ('spid', 'sname', 'contact', 'lat', 'long', 'authorized'), ('SP_103', 'Astha Malik', 9997879333, 28.613949, 77.202237, 1))
def insertintoloan(): insert('loan', ('lid', 'rateoffr', 'dateoffr', 'offrto', 'iniamt', 'pendamt'), ('L_1586', 10.35, '22-04-10', 'F_102', 13500.00, 11000.00)) insert('loan', ('lid', 'rateoffr', 'dateoffr', 'offrto', 'iniamt', 'pendamt'), ('L_2000', 8.00, '10-04-10', 'F_104', 50000.00, 49000.00)) insert('loan', ('lid', 'rateoffr', 'dateoffr', 'offrto', 'iniamt', 'pendamt'), ('L_2314', 9.35, '18-04-10', 'F_105', 20500.00, 20500.00))
def add_loan(): form = AddLoan() if form.validate_on_submit(): length = query_db('Select COUNT(*) from loan') new_id= 'L_'+str(int(length[0][0])+1) insert('loan',('lid', 'rateoffr', 'dateoffr', 'offrto', 'iniamt', 'pendamt'),(new_id,float(form.rateoffr.data),form.date.data,form.fid.data,float(form.iniamt.data),float(form.pendamt.data))) insert('loantrans',('lid','transid'),(new_id,form.trans_id.data)) insert('bankfloan',('lid','bid','fid'),(new_id,form.bid.data,form.fid.data)) flash("Successfully added") return redirect(url_for('add_loan')) return render_template('loan.html',title="loan",form=form)
def insertintotransporter(): insert('transporter', ('tid', 'tname', 'price', 'mintwht', 'maxtwht', 'resavl', 'authorized', 'lat', 'long'), ('T_101', 'Hardik Kapoor', 1800.00, 100, 1000, 1000, 1, 28.593113, 77.202516)) insert('transporter', ('tid', 'tname', 'price', 'mintwht', 'maxtwht', 'resavl', 'authorized', 'lat', 'long'), ('T_102', 'Raunaq Jha', 4200.00, 1000, 5000, 5000, 1, 28.593867, 77.193418)) insert('transporter', ('tid', 'tname', 'price', 'mintwht', 'maxtwht', 'resavl', 'authorized', 'lat', 'long'), ('T_103', 'Randeep Singh', 1300.00, 10, 500, 500, 0, 28.594018, 77.198825))
def insertintostoragefacloc(): insert('storagefacloc', ('sid', 'suitcond', 'size', 'unit', 'price', 'lat', 'long', 'typeoffarming', 'spaceleft', 'availability'), ('S_145', 'dry', 146, 'kg', 150, 28.600122, 77.210691, 'poultry', 23, 1)) insert('storagefacloc', ('sid', 'suitcond', 'size', 'unit', 'price', 'lat', 'long', 'typeoffarming', 'spaceleft', 'availability'), ('S_132', 'room temperature', 2345, 'litre', 450, 28.599218, 77.215326, 'poultry', 300, 0)) insert('storagefacloc', ('sid', 'suitcond', 'size', 'unit', 'price', 'lat', 'long', 'typeoffarming', 'spaceleft', 'availability'), ('S_123', 'cold', 560, 'kg', 786, 28.594508, 77.215540, 'wheat', '20', 1))
def add_registerland(): form = AddLand() if form.validate_on_submit(): print('\n\nIncoming Data: ', (float(form.areaocc.data), float(float(form.lat.data)), float(float(form.long.data)))) store_length= query_db('Select COUNT(*) from land') print('Total records before a land was added: ', store_length[0][0]) new_id= 'LD_'+str(int(store_length[0][0])+1) print('New ID allocated to the transporter is: ', new_id) insert('land', ('lid', 'areaocc', 'lat', 'long'), (new_id, float(float(form.areaocc.data)), float(float(form.lat.data)), float(float(form.long.data)))) print('All records for the land are: ') print(query_db("Select * from land")) flash("Successfully added new land {}!".format(new_id)) insert('landcrop',('cid','lid'),(form.Crop_id.data,new_id)) insert('farmerland',('fid','lid'),(form.Farmer_id.data,new_id)) return redirect(url_for('add_registerland')) return render_template('registerland.html', title="Land", form=form)
def insertintostoragecrop(): insert('storagecrop', ('sid', 'cid'), ('S_145', 'C_101')) insert('storagecrop', ('sid', 'cid'), ('S_132', 'C_102')) insert('storagecrop', ('sid', 'cid'), ('S_123', 'C_103'))
def insertintofspt(): insert('fspt', ('transid', 'fid', 'spid'), ('TR_101', 'F_102', 'SP_101')) insert('fspt', ('transid', 'fid', 'spid'), ('TR_102', 'F_104', 'SP_102')) insert('fspt', ('transid', 'fid', 'spid'), ('TR_103', 'F_105', 'SP_103'))
def add_trans(): form = Addtrans() if(form.validate_on_submit()): length = query_db('select count(*) from transactions') new_id = 'TR_' + str(int(length[0][0])+1) insert('transactions',('transid', 'amount', 'method'),(new_id,float(form.amount.data),form.method.data)) if(form.identity_from.data == 'Farmer'): if(form.identity_to.data == 'transporter'): insert('ftt',('transid','fid','tid'),(new_id,form.from_id.data,form.to_id.data)) if(form.identity_to.data == 'shopvendor'): insert('fsvt',('transid','fid','svid'),(new_id,form.from_id.data,form.to_id.data)) if(form.identity_to.data == 'storage provider'): insert('fspt',('transid','fid','spid'),(new_id,form.from_id.data,form.to_id.data)) else: if(form.identity_from.data == 'transporter'): insert('ftt',('transid','fid','tid'),(new_id,form.to_id.data,form.from_id.data)) if(form.identity_from.data == 'shopvendor'): insert('fsvt',('transid','fid','svid'),(new_id,form.to_id.data,form.from_id.data)) if(form.identity_from.data == 'storage provider'): insert('fspt',('transid','fid','spid'),(new_id,form.to_id.data,form.from_id.data)) return redirect(url_for('add_trans')) flash("Successfully Added") return render_template('trans.html',title="trans",form=form)
def insertintoftt(): insert('ftt', ('transid', 'fid', 'tid'), ('TR_110', 'F_102', 'T_101')) insert('ftt', ('transid', 'fid', 'tid'), ('TR_111', 'F_104', 'T_102')) insert('ftt', ('transid', 'fid', 'tid'), ('TR_112', 'F_105', 'T_103'))
def insertintofsvt(): insert('fsvt', ('transid', 'fid', 'svid'), ('TR_101', 'F_102', 'SV_191')) insert('fsvt', ('transid', 'fid', 'svid'), ('TR_102', 'F_104', 'SV_192')) insert('fsvt', ('transid', 'fid', 'svid'), ('TR_103', 'F_105', 'SV_193'))
def insertintospstorage(): insert('spstorage', ('sid', 'spid'), ('S_145', 'SP_101')) insert('spstorage', ('sid', 'spid'), ('S_132', 'SP_102')) insert('spstorage', ('sid', 'spid'), ('S_123', 'SP_103'))