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)
