def ordering_list(): id = request.args.get('id') action = request.args.get('action') order = request.args.get('order') oder_step = "" print(id, order, action) try: country_database.connects() if action == 'up': oder_step = str(float(order) - 1.5) else: oder_step = str(float(order) + 1.5) sql = "UPDATE slider_manager SET order_id=%s WHERE id=%s" val = ( oder_step, id, ) country_database.cur.execute(sql, val) country_database.conn.commit() update_query() except Exception as err: print(err) country_database.conn.rollback() finally: country_database.conn.close() return json.dumps({"type": "error"})
def cat_list(): result_cat_list = "" result_ordering = "" try: page = request.args.get('page') print("page", page) country_database.connects() sql = "SELECT count(id) from category_manager" country_database.cur.execute(sql) total_row = country_database.cur.fetchall() print("total row") print(total_row) no_of_row = total_row[0]['count(id)'] page_size = 3 total_page = ceil(no_of_row / page_size) starting_row = page_size * int(page) country_database.cur.execute("SELECT * FROM category_manager LIMIT " + str(page_size) + " OFFSET " + str(starting_row)) result_cat_list = country_database.cur.fetchall() country_database.conn.commit() print(result_cat_list) except: country_database.conn.rollback() finally: country_database.conn.close() return render_template('category_list.html', result_cat_list=result_cat_list, total_page=total_page)
def list_article(): record="" try: country_database.connects() sql="SELECT * from article_manager" country_database.cur.execute(sql) record=country_database.cur.fetchall() print(record) for i in record: t=(i['modified_date']) x=(i['description']) u=x.split() v=u[0:10] s = ' '.join(v) y = t.strftime("%y") + "-" + t.strftime("%b") + "-" + t.strftime("%d") print(y) print(s) print(record.modified_date()) country_database.conn.commit() except: country_database.conn.rollback() finally: country_database.conn.close() return render_template('article_manager_list.html', record=record, y=y, s=s)
def login_image_link_view(slug): result="" record="" try: print("in edit") slug = slug print(slug) result = result_front('slider_manager') country_database.connects() flag = 0 sql = "SELECT * FROM article_manager where slug=%s" val = (slug,) country_database.cur.execute(sql, val) record= country_database.cur.fetchone() record_file =record['file'] print("$$$$4",record_file) a=record['category_id'] x=record['id'] country_database.conn.commit() sql= "Select category_id FROM article_manager where slug=%s" val=(slug,) country_database.cur.execute(sql,val) result_s=country_database.cur.fetchone() c_ti=result_s['category_id'] print(c_ti) country_database.conn.commit() sql="Select * FROM article_manager where category_id IN (%s) AND id NOT IN (%s)" val=(c_ti,x,) country_database.cur.execute(sql,val) result_final=country_database.cur.fetchall() print("$$$$", result_final) country_database.conn.commit() country_database.conn.commit() except Exception as err: print(err) country_database.conn.rollback() finally: country_database.conn.close() return render_template('login_image_link.html', record=record, result=result, record_final=result_final)
def add_category(): error = {} val = {} if request.method == 'POST': title = request.form['title'] print("here $$$$", title) t = slugify(title) if title == '': error['t_er'] = "no title" val['title'] = title file_upload = "" img_upload = "" if request.files: file_upload = request.files['image'] else: error['file_upload_error'] = "Image is not selected" if file_upload: new_file = file_upload.filename.split('.') file_upload.filename = "image" + str( datetime.now()) + "." + new_file[-1] img_upload = file_upload.filename f = os.path.join(cat.config['UPLOAD_FOLDER'], file_upload.filename) file_upload.save(f) print(f) if len(error) != 0: return render_template('add_category.html', error=error) else: try: print("hellooo this coming") country_database.connects() sql = "INSERT INTO category_manager(title, image, created_date, modified_date) VALUES (%s, %s, %s, %s)" print("hellooo this coming") print("i am after sql") value = (t, img_upload, str(datetime.now()), str(datetime.now())) print(title) country_database.cur.execute(sql, value) country_database.conn.commit() return redirect(url_for('cat_manager.cat_list')) except: country_database.conn.rollback() finally: country_database.conn.close() else: return render_template('add_category.html', error=error, val=val) return redirect(url_for('cat_manager.cat_list'))
def cat_img(tables): try: country_database.connects() sql = "select * from " + tables country_database.cur.execute(sql) myresult = country_database.cur.fetchall() except Exception as err: print(err) country_database.conn.rollback() finally: country_database.conn.close() return myresult
def sld_list(): try: country_database.connects() sql = "SELECT * FROM slider_manager ORDER BY order_id ASC" country_database.cur.execute(sql) record = country_database.cur.fetchall() country_database.conn.commit() except: country_database.conn.rollback() finally: country_database.conn.close() return render_template("slider_manager_list.html", record=record)
def delete(): try: user = request.args.get('em') country_database.connects() sql = "DELETE FROM form WHERE email=%s" val = (user, ) country_database.cur.execute(sql, val) country_database.conn.commit() except Exception as err: print('err', err) country_database.conn.rollback() finally: country_database.conn.close() return json.dumps({'type': 'success'})
def list_page(): record = "" try: country_database.connects() sql = "Select * from page_manager" country_database.cur.execute(sql) record = country_database.cur.fetchall() country_database.conn.commit() except Exception as err: country_database.conn.rollback() finally: country_database.conn.close() return render_template('page_manager_list.html', record=record)
def cat_list(): result_cat_list = "" try: country_database.connects() sql = "SELECT * from category_manager" country_database.cur.execute(sql) result_cat_list = country_database.cur.fetchall() country_database.conn.commit() print(result_cat_list) except: country_database.conn.rollback() finally: country_database.conn.close() return render_template('category_list.html', result_cat_list=result_cat_list)
def login_activate(slug): error={} result="" print("above") results = result_front('slider_manager') status = "true" try: country_database.connects() sql= "select * from form where OTP=%s" val=(slug,) country_database.cur.execute(sql, val, ) result_final = country_database.cur.fetchone() country_database.conn.commit() except Exception as err: print(err) country_database.conn.rollback() finally: country_database.conn.close() if result_final is not None: try: print("slug is not none") country_database.connects() sql = "UPDATE form set status =%s, OTP=%s where OTP=%s" status="true" empty=" " val = (status,empty, slug,) print("val is", val) country_database.cur.execute(sql, val, ) country_database.conn.commit() return redirect(url_for('login_reg.login')) except Exception as err: print(err) country_database.conn.rollback() finally: country_database.conn.close() else: print("OTP is blank") error['cccc']='link expired!' print("erro is", error) return render_template('login.html', error=error)
def city(): recordcity = '' country = request.args.get('snm') val = (country, ) print(val) try: country_database.connects() state = "SELECT * FROM cities WHERE state_id=%s" country_database.cur.execute(state, val) recordcity = country_database.cur.fetchall() print(recordcity) except: country_database.conn.rollback() print(recordcity) return json.dumps({"type": "get_city", "result": recordcity})
def state(): recordcity = '' country = request.args.get('cnm') val = (country, ) print(val) try: country_database.connects() state = "SELECT * FROM states WHERE country_id=%s" country_database.cur.execute(state, val) recordcity = country_database.cur.fetchall() print(recordcity) except: country_database.conn.rolback() finally: country_database.conn.close() return json.dumps({"type": "get_state1", "result": recordcity})
def delete_page(): try: id = request.args.get('idi') print(id) country_database.connects() sql = "delete from page_manager where id = %s" # sql = "delete from page_manager where id = %s" val = (id, ) country_database.cur.execute(sql, val) country_database.conn.commit() except Exception as err: print(err) country_database.conn.rollback() finally: country_database.conn.close() flash('Content deleted successfully') return json.dumps({"type": "success"})
def add_category(): error = {} val = {} if request.method == 'POST': title = request.form['title'] if title == '': error['t_er'] = "no title" val['title'] = title file = request.files['file'] if file and allowed_file(file.filename): filename = secure_filename(file.filename) file.save(os.path.join(app.config['UPLOAD_FOLDER'], filename)) print("================") print(filename) print("===============") return redirect(url_for('uploaded_file', filename=filename)) else: error['file_upload_error'] = "Image is not selected" if len(error) != 0: return render_template('add_category.html', error=error) else: try: print("hellooo this coming") country_database.connects() sql = "INSERT INTO category_manager(title, image, created_date, modified_date) VALUES (%s, %s, %s, %s)" print("hellooo this coming") print("i am after sql") value = (title, str(datetime.now()), str(datetime.now())) print(title) country_database.cur.execute(sql, value) country_database.conn.commit() except: country_database.conn.rollback() finally: country_database.conn.close() else: return render_template('add_category.html', error=error, val=val) return render_template('login.html')
def contact_us(): error = {} val = {} if request.method == 'POST': name = request.form['name'] subject = request.form['subject'] email = request.form['email'] message = request.form['message'] print(name) print(email) if name == "": error['a'] = "Your name is required" if subject == "": error['b'] = "subject is required" if email == "": error['c'] = "Email is required" else: if re.match("^\w+@[a-zA-Z_]+?\.[a-zA-Z]{2,3}$", email) is None: error['ie'] = "Invalid EmailId" if message == "": error['d'] = "Please write your message" if len(error) == 0: try: country_database.connects() sql = "INSERT INTO contact_us(name,subject ,email , message) VALUES (%s, %s, %s, %s)" val = ( name, subject, email, message, ) country_database.cur.execute(sql, val) country_database.conn.commit() flash('We will contact you soon!') return render_template('contact.html', error=error) except Exception as err: print(err) country_database.conn.rollback() finally: country_database.conn.close() return render_template('contact.html', error=error) return render_template('contact.html', error=error)
def check_title(): record ='' title = request.args.get('eml') val = (title, ) print(val) try: country_database.connects() sql ="SELECT * FROM article_manager where title=%s" country_database.cur.execute(sql, val) record = country_database.cur.fetchone() print("sql value is", sql) print("val value is", val) print(record) except: country_database.conn.rolback() finally: country_database.conn.close() return json.dumps({"type": "check_title", "record": record})
def myemail(): recordemail = '' email = request.args.get('eml') val = (email, ) print(val) try: country_database.connects() sql = "SELECT * FROM form where email=%s" country_database.cur.execute(sql, val) recordemail = country_database.cur.fetchone() print("sql value is", sql) print("val value is", val) print(recordemail) except: country_database.conn.rolback() finally: country_database.conn.close() return json.dumps({"type": "get_email1", "recordemail": recordemail})
def delete_article(): print("in delete article") id=request.args.get('idi') print("here is your id", id) try: country_database.connects() sql = "DELETE FROM article_manager WHERE id=%s" val=(id,) country_database.cur.execute(sql,val) country_database.conn.commit() except Exception as err: print(err) country_database.conn.rollback() finally: country_database.conn.close() flash('Article has been deleted successfully!') return json.dumps({"type": "success"})
def add_slider(): val = "" error = "" fileupload = "" if request.method == 'POST': title = request.form['title'] ck = request.form['ck'] if title == "": error['a'] = "title is required" if request.files: fileupload = request.files['image'] if fileupload and allowed_file(fileupload.filename): filename = secure_filename(fileupload.filename) fileupload.save( os.path.join(sld.config['UPLOAD_FOLDER'], filename)) image = fileupload.filename else: error['im'] = "Images is empty" if len(error) == 0: try: country_database.connects() sql="insert into slider_manager(title,image,status," \ "created_date,modified_date)" \ " value(%s,%s,%s,%s,%s)" val = (title, image, ck, str(datetime.now()), str(datetime.now())) print(val) country_database.cur.execute(sql, val) country_database.conn.commit() update_query() return redirect(url_for('sld_manager.sld_list')) except Exception as err: print(err) country_database.conn.rollback() finally: country_database.conn.close() return render_template('slider_manager.html', error=error, val=val) return render_template('slider_manager.html')
def first(): val = {} record1 = "" record2 = "" try: print("hello") country_database.connects() country_database.cur.execute("SELECT * FROM form") record1 = country_database.cur.fetchall() print("jdfk") country_database.conn.commit() except Exception as err: print(err) country_database.conn.rollback() finally: country_database.conn.close() return render_template('list_user.html', record1=record1)
def sld_delete(): print("here") try: id = request.args.get('idi') print(id) country_database.connects() sql = "delete from slider_manager where id = %s" print("sqlllllllll") val = (id, ) print(val) country_database.cur.execute(sql, val) country_database.conn.commit() except Exception as err: print(err) country_database.conn.rollback() finally: country_database.conn.close() flash('Slider has been deleted successfully!') return json.dumps({"type": "success"})
def result_front(tables): result = "" try: country_database.connects() sql = '' if tables is 'page_tbl' or tables is 'category_tbl': sql = "select * from " + tables country_database.excute(sql) else: print(tables) status = ('Publish', ) sql = "select * from " + tables + " WHERE status = %s" country_database.cur.execute(sql, status) result = country_database.cur.fetchall() except Exception as err: print(err) country_database.conn.rollback() finally: country_database.conn.close() return result
def user_list_article(): result = result_front('slider_manager') try: id = request.args.get('id') country_database.connects() sql = "select * from article_manager where user_id = %s" val = (session['user']['id'], ) print("val value is", val) country_database.cur.execute(sql, val) record = country_database.cur.fetchall() print("ghdfs", result) country_database.conn.commit() except Exception as err: print(err) country_database.conn.rollback() finally: country_database.conn.close() return render_template('/frontend/article/user_list_article.html', result=result, record=record)
def add_page(): error = {} if request.method == 'POST': title = request.form['title'] slug = request.form['slug'] s = slugify(slug) decs = request.form['decs'] if title == "": error['a'] = "title is required" if decs == "": error['b'] = "description is required" if len(error) == 0: try: country_database.connects() sql = "INSERT INTO page_manager (title, slug, description) VALUES(%s, %s, %s)" val = ( title, s, decs, ) country_database.cur.execute(sql, val) country_database.conn.commit() return redirect(url_for('page_manager.list_page')) except Exception as err: print(err) country_database.conn.rollback() finally: country_database.conn.close() return render_template('page_manager.html')
def admin_login(): error = {} result = "" if request.method == 'POST': user = request.form['email'] password = request.form['password'] if user == '': error['a'] = "email required" if password == '': error['b'] = "password required" if len(error) == 0: try: country_database.connects() val = (user, password) country_database.cur.execute( "SELECT id FROM form WHERE email=%s and password=%s", val) result = country_database.cur.fetchone() session['user'] = result print(result) print(session['user']) print(session['user']['id']) country_database.conn.commit() except: country_database.conn.rollback() finally: country_database.conn.close() if result is not None: print("result is not none") if session['user']['id'] is not 1: print("user and password not match") error['em'] = 'USER AND PASSWORD NOT MATCH' print('desfetgrt') return render_template('admin_login.html', error=error) return render_template('index.html') return render_template('admin_login.html', error=error) return render_template('admin_login.html')
def login_view(): record="" result="" result = result_front('slider_manager') # print("#@#@#@",result) if 'user' in session: try: country_database.connects() print("session_user",session['user']) sql="select * from article_manager where user_id = %s" val=(session['user']['id'],) print("val value is",val) country_database.cur.execute(sql,val) record=country_database.cur.fetchall() print("ghdfs",record) country_database.conn.commit() except Exception as err: print(err) country_database.conn.rollback() finally: country_database.conn.close() return render_template('login_view.html', result=result, record=record )
def update_query(): result = "" count = 0 try: country_database.connects() sql = "SELECT * FROM slider_manager ORDER BY order_id ASC" country_database.cur.execute(sql) result = country_database.cur.fetchall() for row in result: count = count + 1 sql = "UPDATE slider_manager SET order_id=%s WHERE id=%s" val = ( str(count), row['id'], ) country_database.cur.execute(sql, val) country_database.conn.commit() except Exception as err: print(err) country_database.conn.rollback() finally: country_database.conn.close() return True
def add_article(): error={} myresult="" fileupload="" user_id = session['user']['id'] print(user_id) try: country_database.connects() sql = "SELECT * FROM category_manager " country_database.cur.execute(sql) myresult = country_database.cur.fetchall() except: country_database.conn.rollback() finally: country_database.conn.close() if request.method=="POST": title = request.form['title'] slug=request.form['title'] s = slugify(slug) print(s) description = request.form['summernote'] status = request.form['ck'] cat_id = request.form['cat_id'] if title=="": error['tt']="title is required" if slug=="": error['b']="slug is required" if description=="": error['c'] = "please enter some description" if cat_id=='': error['e']="select category id" print(request.files) if request.files: # file_upload = request.files['image'] fileupload = request.files['image'] if fileupload and allowed_file(fileupload.filename): filename = secure_filename(fileupload.filename) fileupload.save(os.path.join(art.config['UPLOAD_FOLDER'], filename)) image=fileupload.filename else: error['as']="image not selected" try: country_database.connects() t = str(datetime.now()) # y = t.strftime("%y") + "-" + t.strftime("%b") + "-" + t.strftime("%d") print("here is date time format") print(user_id) s=slugify(slug) sql = "insert into article_manager(title,slug,description,file,category_id ," \ "status ,created_date,modified_date,user_id)" \ " value(%s,%s,%s,%s,%s,%s,%s,%s,%s)" val=(title, s, description,image,cat_id,status, t,t,user_id,) print(val) # user_id=session['user'['id']] country_database.cur.execute(sql,val) country_database.conn.commit() return redirect(url_for('article_manager_reg.list_article')) except Exception as err: print(err) country_database.conn.rollback() finally: country_database.conn.close() return render_template("article_manager.html", error=error,myresult=myresult)
def edit_article(): myresult="" files="" error={} record="" oldimage="" id = request.args.get('id') record='' try: print("fsdijdfsjidfsj") country_database.connects() sql = "SELECT * FROM category_manager " country_database.cur.execute(sql) myresult = country_database.cur.fetchall() country_database.conn.commit() sql="SELECT * from article_manager WHERE id =%s" val=(id,) country_database.cur.execute(sql,val) record=country_database.cur.fetchone() print("record ffff", record) print("$$$$$$$",record['category_id'], record['id']) oldimage=record['file'] country_database.conn.commit() except: country_database.conn.rollback() finally: country_database.conn.close() if request.method=='POST': flag=0 title = request.form['title'] slug = request.form['title'] s = slugify(slug) print(s) description = request.form['decs'] status = request.form['ck'] cat_id = request.form['cat_id'] if title=="": error['ti']="title is required" if description=='': error['de_er']="description is required" if request.files: files = request.files['image'] if files and allowed_file(files.filename): filename = secure_filename(files.filename) files.save(os.path.join(art.config['UPLOAD_FOLDER'], filename)) flag = 1 if len(error)==0: if flag==1: try: print("here is flag 1") country_database.connects() # os.remove(art.config['UPLOAD_FOLDER'] + "/" + oldimage) print("here is flag 2") sql="UPDATE article_manager SET title=%s,slug=%s, description=%s, file=%s, category_id=%s,"\ "status=%s, modified_date=%s where id=%s" val=(title,s,description,files.filename, cat_id, status, str(datetime.now()),id,) print("val is",val) country_database.cur.execute(sql,val) country_database.conn.commit() flash('Article has been updated successfully!') return redirect(url_for('article_manager_reg.list_article')) except Exception as err: print(err) country_database.conn.rollback() finally: country_database.conn.close() flash('Article has been updated successfully!') return render_template('article_manager_list_edit.html', record=record, myresult=myresult, error=error) else: try: country_database.connects() if 'pt' in request.form and request.form['pt'] == 'on': print("file%%%",oldimage) os.remove(art.config['UPLOAD_FOLDER'] + "/" + oldimage) sql = "UPDATE article_manager SET title=%s, slug=%s, description=%s, category_id=%s," \ " status=%s, modified_date=%s where id=%s" val = (title,s,description, cat_id, status,str(datetime.now()), id,) print("val is in flag o side", val) country_database.cur.execute(sql, val) country_database.conn.commit() flash('Article has been updated successfully!') return redirect(url_for('article_manager_reg.list_article')) except Exception as err: print(err) country_database.conn.rollback() finally: country_database.conn.close() return render_template('article_manager_list_edit.html', record=record, myresult=myresult, error=error)