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')