def silder_list(): if 'username' in session: myresult = "" total_page = 0 try: page = request.args.get('page') my_db.connection() sql = "SELECT count(id) FROM slider_tbl " my_db.cur.execute(sql) total_row = my_db.cur.fetchall() no_of_row = total_row[0]['count(id)'] page_size = 2 total_page = ceil(no_of_row / page_size) starting_row = page_size * int(page) my_db.cur.execute("SELECT * FROM slider_tbl LIMIT " + str(page_size) + " OFFSET " + str(starting_row)) myresult = my_db.cur.fetchall() except: my_db.conn.rollback() finally: my_db.conn.close() return render_template('/slider-manager/list-slider.html', sec=session['username'], myresult=myresult, total_page=total_page) return render_template('homepages/login.htm')
def category_list(): if 'username' in session: myresult = '' total_page = 0 # temp=1.5 try: page = request.args.get('page') my_db.connection() sql = "SELECT count(id) FROM category_tbl " my_db.cur.execute(sql) total_row = my_db.cur.fetchall() no_of_row = total_row[0]['count(id)'] page_size = 2 total_page = ceil(no_of_row / page_size) starting_row = page_size * int(page) my_db.cur.execute("SELECT * FROM category_tbl LIMIT " + str(page_size) + " OFFSET " + str(starting_row)) myresult = my_db.cur.fetchall() except mysql.connector.Error as err: print(err) my_db.conn.rollback() finally: my_db.conn.close() return render_template('/category-manager/category-list.html', sec=session['username'], myresult=myresult, total_page=total_page) return render_template('homepages/login.htm')
def article_order(): id = request.args.get('id') action = request.args.get('title') order = request.args.get('order') oder_step = "" try: my_db.connection() if action == 'UP': oder_step = str(float(order) - 1.5) else: oder_step = str(float(order) + 1.5) sql = "UPDATE article_tbl SET order_step=%s WHERE id=%s" val = (oder_step, id) my_db.cur.execute(sql, val) my_db.conn.commit() update_query() except Exception as err: print(err) my_db.conn.rollback() finally: my_db.conn.close() return json.dumps({"type": "error"})
def get_conutry(): myresult = "" try: my_db.connection() my_db.cur.execute("SELECT * FROM countries") myresult = my_db.cur.fetchall() except: my_db.conn.rollback() finally: my_db.conn.close() return myresult
def category(): myresult = '' try: my_db.connection() sql = "SELECT * FROM category_tbl " my_db.cur.execute(sql) myresult = my_db.cur.fetchall() except: my_db.conn.rollback() finally: my_db.conn.close() return myresult
def filter_article(id): myresult = "" try: my_db.connection() sql = "select * from article_tbl where categary_id=%s" val = (id, ) my_db.cur.execute(sql, val) myresult = my_db.cur.fetchall() except Exception as err: print(err) my_db.conn.rollback() finally: my_db.conn.close() return json.dumps({"type": "fliter", "result": myresult})
def add_category(): if 'username' in session: error = {} val = {} if request.method == 'POST': title = request.form['title'] val['title'] = title file_uploads = '' if title == "": error['h'] = "title is empty" if request.files: file_uploads = request.files['image'] else: error['file_error'] = "Image is empty" if len(error) == 0: name = "" if file_uploads: name = file_upload(cat.config['UPLOAD_FOLDER'], file_uploads) print(name) try: my_db.connection() sql = "insert into category_tbl(title,image,created_date,modified_date) value(%s,%s,%s,%s)" val = ( title, name, str(datetime.now()), str(datetime.now()), ) my_db.cur.execute(sql, val) my_db.conn.commit() flash('Category has been added successfully!') return redirect(url_for('cat_manager.category_list')) except Exception as err: print(err) my_db.conn.rollback() finally: my_db.conn.close() return render_template('category-manager/add-category.html', sec=session['username'], error=error, val=val) return render_template('homepages/login.htm')
def page_delete(): id = request.args.get('id') try: my_db.connection() val = (id,) sql = "delete from page_tbl where id = %s" my_db.cur.execute(sql, val) my_db.conn.commit() except mysql.connector.Error as err: print(err) my_db.conn.rollback() finally: my_db.conn.close() return json.dumps({"type": "error"})
def add_page(): if 'username' in session: error = {} val = {} if request.method == 'POST': title = request.form['title'] decs = request.form['decs'] slugs = request.form['slug'] val['title'] = title val['decs'] = decs val['slug'] = slugs if title == "": error['h'] = "Title is empty" if decs == "": error['decs'] = "Description is empty" if slugs == "": error['slug'] = "Slug is empty" if len(error) == 0: slugfy = str(slug(slugs)) try: my_db.connection() sql = "insert into page_tbl(title,slug,description,created_date,modified_date)" \ " values(%s,%s,%s,%s,%s)" val = (title, slugfy, decs, str(datetime.now()), str(datetime.now())) my_db.cur.execute(sql, val) my_db.conn.commit() flash('Page has been added successfully!') return redirect(url_for('page.page_list')) except mysql.connector.Error as err: print(err) my_db.conn.rollback() finally: my_db.conn.close() return render_template('/page-manager/add-page.html' , error=error, val=val, sec=session['username']) return render_template('/homepages/login.htm')
def add_slider(): if 'username' in session: error = {} val = {} if request.method == 'POST': title = request.form['title'] ck = request.form['ck'] val['title'] = title fileupload = '' if title == "": error['h'] = "Title is empty" if request.files: fileupload = request.files['image'] else: error['im']="Images is empty" if len(error) == 0: image = "" if fileupload: image = file_upload(sld.config['UPLOAD_FOLDER'], fileupload) try: my_db.connection() sql = "insert into slider_tbl(title,image,status," \ "created_date,modified_date)" \ " value(%s,%s,%s,%s,%s)" val = (title, image, ck, str(datetime.now()), str(datetime.now()),) my_db.cur.execute(sql, val) my_db.conn.commit() flash('Slider has been added successfully!') return redirect(url_for('sld_manager.silder_list')) except mysql.connector.Error as err: print(err) my_db.conn.rollback() finally: my_db.conn.close() return render_template('/slider-manager/add-slider.html', error=error, sec=session['username'], val=val) return render_template('homepages/login.htm')
def login_post(): error = {} if request.method == 'POST': username = request.form['email'] passwd = request.form['psw'] if username == '': error['e'] = 'E-mail is required' if passwd == '': error['p'] = 'Enter Password' if len(error) == 0: hash_pass = hash_password(passwd) myresult = "" val = ( username, hash_pass, ) try: my_db.connection() sql = "SELECT * FROM reg_tbl where e_mail=%s and password=%s" my_db.cur.execute(sql, val) myresult = my_db.cur.fetchone() except: my_db.conn.rollback() finally: my_db.conn.close() if myresult is None: error['ep'] = "Email and password does not match" else: session['username'] = myresult '''resp = make_response(redirect('/admin/dashboard')) resp.set_cookie('userID', myresult) return resp''' return redirect(url_for('log.dashboard')) return render_template('homepages/login.htm', error=error) return redirect(url_for('log.login'))
def slider_delete(): id = request.args.get('id') try: my_db.connection() sql = "SELECT * FROM slider_tbl WHERE id =%s" val = (id,) my_db.cur.execute(sql, val) myresult = my_db.cur.fetchone() delete(sld.config['UPLOAD_FOLDER'], myresult['image']) sql = "delete from slider_tbl where id = %s" my_db.cur.execute(sql, val) my_db.conn.commit() except mysql.connector.Error as err: print(err) my_db.conn.rollback() finally: my_db.conn.close() return json.dumps({"type": "error"})
def retrive(tables): myresult = "" try: my_db.connection() sql = '' if tables is 'page_tbl' or tables is 'category_tbl': sql = "select * from " + tables my_db.cur.execute(sql) else: status = ('yes', ) sql = "select * from " + tables + " WHERE status = %s" my_db.cur.execute(sql, status) myresult = my_db.cur.fetchall() except Exception as err: print(err) my_db.conn.rollback() finally: my_db.conn.close() return myresult
def article_delete(): id = request.args.get('id') try: my_db.connection() sql = "SELECT * FROM article_tbl WHERE id =%s" val = (id, ) my_db.cur.execute(sql, val) myresult = my_db.cur.fetchone() delete(art.config['UPLOAD_FOLDER'], myresult['image']) sql = "delete from article_tbl where id = %s" my_db.cur.execute(sql, val) my_db.conn.commit() update_query() except Exception as err: print(err) my_db.conn.rollback() finally: my_db.conn.close() return json.dumps({"type": "error"})
def update_query(): result = "" count = 0 try: my_db.connection() sql = "SELECT * FROM article_tbl ORDER BY order_step ASC" my_db.cur.execute(sql) result = my_db.cur.fetchall() for row in result: count = count + 1 sql = "UPDATE article_tbl SET order_step=%s WHERE id=%s" val = ( str(count), row['id'], ) my_db.cur.execute(sql, val) my_db.conn.commit() except Exception as err: print(err) my_db.conn.rollback() finally: my_db.conn.close() return True
def article_list(): if 'username' in session: myresult = "" total_page = 0 page = 0 try: if request.args.get('page'): page = request.args.get('page') my_db.connection() sql = "SELECT count(id) FROM article_tbl " my_db.cur.execute(sql) total_row = my_db.cur.fetchall() no_of_row = total_row[0]['count(id)'] page_size = 2 total_page = ceil(no_of_row / page_size) starting_row = page_size * int(page) my_db.cur.execute( "SELECT * FROM article_tbl ORDER BY order_step ASC LIMIT " + str(page_size) + " OFFSET " + str(starting_row) + "") myresult = my_db.cur.fetchall() except Exception as err: print(err) my_db.conn.rollback() finally: my_db.conn.close() return render_template('/article-manager/article_list.html', sec=session['username'], myresult=myresult, total_page=total_page) return render_template('homepages/login.htm')
def edit(): if 'username' in session: print("entry") myresult = '' id = request.args.get('id') try: my_db.connection() sql = "SELECT * FROM page_tbl WHERE id =%s" val = (id, ) my_db.cur.execute(sql,val) myresult = my_db.cur.fetchone() except mysql.connector.Error as err: print(err) my_db.conn.rollback() finally: my_db.conn.close() print("end select") error = {} if request.method == 'POST': print('entry post') title = request.form['title'] decs = request.form['decs'] slugs = request.form['slug'] if title == "": error['h'] = "Title is empty" if decs == "": error['decs'] = "Description is empty" if slugs == "": error['slug'] = "Slug is empty" if len(error) == 0: print('entry without error') slugfy = str(slug(slugs)) try: my_db.connection() print('try') print(id) sql = "update page_tbl set title=%s , slug=%s, description=%s, " \ "modified_date=%s WHERE id =%s" val = (title, slugfy, decs, str(datetime.now()), id) my_db.cur.execute(sql, val) my_db.conn.commit() flash('Page has been Updated successfully!') return redirect(url_for('page.page_list')) except mysql.connector.Error as err: print(err) my_db.conn.rollback() finally: my_db.conn.close() return render_template('/page-manager/edit-page.html' , error=error, myresults=myresult, sec=session['username']) return render_template('/homepages/login.htm')
def edit(): if 'username' in session: id = request.args.get('id') myresult = '' old_image = '' old_file = '' try: my_db.connection() sql = "SELECT * FROM article_tbl WHERE id =%s" val = (id, ) my_db.cur.execute(sql, val) myresult = my_db.cur.fetchone() if myresult is not None: old_image = myresult['image'] old_file = myresult['file_upload'] my_db.conn.commit() except Exception as err: print(err) my_db.conn.rollback() finally: my_db.conn.close() error = {} if request.method == 'POST': title = request.form['title'] ck = request.form['ck'] decs = request.form['decs'] cat_id = request.form['cat_id'] flag = False flag_file = False fileuploads = '' files_doc = "" if title == "": error['title'] = "Title is empty" if decs == "": error['decs'] = "Description is empty" if request.files: for d in request.files: if d == 'image': fileuploads = request.files['image'] flag = True if d == 'f_load': files_doc = request.files['f_load'] flag_file = True if len(error) == 0: image = "" file_name = "" if fileuploads and flag: image = file_upload(art.config['UPLOAD_FOLDER'], fileuploads) if files_doc and flag: file_name = file_upload(art.config['UPLOAD_FOLDER'], files_doc) try: my_db.connection() if flag and not flag_file: sql = "update article_tbl set title=%s ,image=%s, description=%s, status=%s, " \ "modified_date=%s, categary_id=%s where id=%s" val = ( title, image, decs, ck, str(datetime.now()), cat_id, id, ) delete(art.config['UPLOAD_FOLDER'], old_image) elif flag_file and not flag: sql = "update article_tbl set title=%s , description=%s, status=%s, modified_date=%s ," \ " file_upload=%s,categary_id=%s where id=%s" val = ( title, decs, ck, str(datetime.now()), file_name, cat_id, id, ) delete(art.config['UPLOAD_FOLDER'], old_file) elif flag and flag_file: sql = "update article_tbl set title=%s , description=%s,image=%s, status=%s," \ " modified_date=%s, file_upload=%s,categary_id=%s where id=%s" val = ( title, decs, image, ck, str(datetime.now()), file_name, cat_id, id, ) delete(art.config['UPLOAD_FOLDER'], old_image) delete(art.config['UPLOAD_FOLDER'], old_file) else: if 'pt' in request.form and request.form['pt'] == 'on': delete(art.config['UPLOAD_FOLDER'], old_image) if 'pt_file' in request.form and request.form[ 'pt_file'] == 'on': delete(art.config['UPLOAD_FOLDER'], old_file) sql = "update article_tbl set title=%s , description=%s, status=%s, " \ "modified_date=%s, categary_id=%s where id=%s" val = ( title, decs, ck, str(datetime.now()), cat_id, id, ) my_db.cur.execute(sql, val) my_db.conn.commit() flash('Article has been updated successfully!') return redirect(url_for('art_manager.article_list')) except Exception as err: print(err) my_db.conn.rollback() finally: my_db.conn.close() return render_template('/article-manager/edit-article.html', error=error, sec=session['username'], category=category(), myresults=myresult) return render_template('homepages/login.htm')
def edit(): if 'username' in session: id = request.args.get('id') myresult = "" old_image = "" try: my_db.connection() sql = "SELECT * FROM category_tbl WHERE id =%s" val = (id, ) my_db.cur.execute(sql, val) myresult = my_db.cur.fetchone() if myresult is not None: old_image = myresult['image'] except ValueError as err: print(err) my_db.conn.rollback() finally: my_db.conn.close() error = {} if request.method == 'POST': error = {} flag = False title = request.form['title'] file_uploads = '' if title == "": error['h'] = "title is empty" if request.files: file_uploads = request.files['image'] flag = True if len(error) == 0: name = "" if file_uploads: name = file_upload(cat.config['UPLOAD_FOLDER'], file_uploads) try: my_db.connection() if flag: sql = "update category_tbl set title=%s,image=%s,modified_date=%s WHERE id =%s" val = ( title, name, str(datetime.now()), id, ) delete(cat.config['UPLOAD_FOLDER'], old_image) else: if 'pt' in request.form and request.form['pt'] == 'on': delete(cat.config['UPLOAD_FOLDER'], old_image) sql = "update category_tbl set title=%s,image=%s,modified_date=%s WHERE id =%s" val = ( title, name, str(datetime.now()), id, ) if request.form['pt']: delete(cat.config['UPLOAD_FOLDER'], old_image) else: sql = "update category_tbl set title=%s,modified_date=%s WHERE id =%s" val = ( title, str(datetime.now()), id, ) my_db.cur.execute(sql, val) my_db.conn.commit() flash('Category has been added successfully!') return redirect(url_for('cat_manager.category_list')) except Exception as err: print(err) my_db.conn.rollback() finally: my_db.conn.close() return render_template('category-manager/edit-category.html', sec=session['username'], error=error, myresults=myresult) return render_template('homepages/login.htm')
def add_article(): if 'username' in session: myresult = category() error = {} val = {} if request.method == 'POST': title = request.form['title'] ck = request.form['ck'] decs = request.form['decs'] cat_id = request.form['cat_id'] val['title'] = title val['decs'] = decs fileupload = '' files = "" if title == "": error['h'] = "Title is empty" if decs == "": error['decs'] = "Description is empty" if 'image' in request.files: fileupload = request.files['image'] else: error['img_error'] = "Image is empty" if 'f_load' in request.files: files = request.files['f_load'] else: error['file_error'] = "File is empty" if len(error) == 0: image = "" file = "" if fileupload: image = file_upload(art.config['UPLOAD_FOLDER'], fileupload) if files: file = file_upload(art.config['UPLOAD_FOLDER'], files) try: my_db.connection() sql = "insert into article_tbl(title,description,image,status," \ "created_date,modified_date,file_upload, categary_id)" \ " value(%s,%s,%s,%s,%s,%s,%s,%s)" val = (title, decs, image, ck, str(datetime.now()), str(datetime.now()), file, cat_id) my_db.cur.execute(sql, val) my_db.conn.commit() flash('Article has been added successfully!') return redirect(url_for('art_manager.article_list')) except Exception as err: print(err) my_db.conn.rollback() finally: my_db.conn.close() return render_template('/article-manager/add-article.html', error=error, myresults=myresult, sec=session['username'], val=val) return render_template('homepages/login.htm')
def edit(): if 'username' in session: id = request.args.get('id') myresult = '' old_image = '' try: my_db.connection() sql = "SELECT * FROM slider_tbl WHERE id =%s" val = (id,) my_db.cur.execute(sql, val) myresult = my_db.cur.fetchone() if myresult is not None: old_image = myresult['image'] my_db.conn.commit() except mysql.connector.Error as err: print(err) my_db.conn.rollback() finally: my_db.conn.close() error = {} if request.method == 'POST': title = request.form['title'] ck = request.form['ck'] flag = False fileuploads = '' if title == "": error['title'] = "Title is empty" if request.files: fileuploads = request.files['image'] flag = True if len(error) == 0: image = "" if fileuploads and flag: image = file_upload(sld.config['UPLOAD_FOLDER'], fileuploads) try: my_db.connection() if flag: sql = "update slider_tbl set title=%s ,image=%s, status=%s, " \ "modified_date=%s where id=%s" val = (title, image, ck, str(datetime.now()), id,) delete(sld.config['UPLOAD_FOLDER'],old_image) else: if 'pt' in request.form and request.form['pt'] == 'on': delete(sld.config['UPLOAD_FOLDER'], old_image) sql = "update slider_tbl set title=%s , status=%s, " \ "modified_date=%s where id=%s" val = (title, ck, str(datetime.now()), id,) my_db.cur.execute(sql, val) my_db.conn.commit() flash('Slider has been updated successfully!') return redirect(url_for('sld_manager.silder_list')) except mysql.connector.Error as err: print(err) my_db.conn.rollback() finally: my_db.conn.close() print(len(myresult)) return render_template('/slider-manager/edit-slider.html', error=error, sec=session['username'], myresults=myresult) return render_template('homepages/login.htm')