def search_Product(self):
connection = con_db()
cursor1 = connection.cursor()
#cursor2 = connection.cursor()
cursor1.execute("SELECT * FROM productmaster")
#cursor2.execute("SELECT * FROM productmaster")
#cursor1.execute ("SELECT * FROM productmaster AS p INNER JOIN categorymaster AS c ON p.`product_categoryId` = c.`categoryId`")
#cursor1.execute("SELECT product_subcategoryId FROM productmaster INNER JOIN subcategorymaster ON productmaster.product_subcategoryId = subcategorymaster.subcategoryId")
cursor1.execute(
"SELECT * FROM subcategorymaster INNER JOIN productmaster ON product_subcategoryId = subcategoryId INNER JOIN categorymaster ON categoryId=subcategory_categoryId"
)
#cursor1.execute("SELECT * FROM productmaster INNER JOIN subcategorymaster ON productmaster.'product_subcategoryId' = subcatrgorymaster.'subcategoryId'")
data1 = cursor1.fetchall()
#data = cursor2.fetchall()
print(data1)
#print(data)
connection.commit()
connection.close()
cursor1.close()
#cursor2.close()
return data1
def update_data(self, firstname, lastname, username, password, id):
con_db_obj = con_db()
cursor = con_db_obj.connection.cursor()
cursor.execute(
'''update register_master_mvc set firstname=%s, lastname=%s, username=%s, password=%s
where id=%s''', (firstname, lastname, username, password, id))
cursor.connection.commit()
cursor.close()
def updateLogin(self,loginVO):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute("UPDATE loginmaster SET loginEmailId = '{}',loginActiveStatus='{}' WHERE loginId = '{}'".format(loginVO.loginEmailId,loginVO.loginActiveStatus,loginVO.loginId))
connection.commit()
cursor1.close()
connection.close()
def insert_data(self, firstname, lastname, username, password):
con_db_obj = con_db()
cursor = con_db_obj.connection.cursor()
cursor.execute(
'''Insert into register_master_mvc (firstname, lastname, username, password)
values(%s, %s, %s, %s)''', (firstname, lastname, username, password))
cursor.connection.commit()
cursor.close()
def getMaxId(self):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute("SELECT MAX(loginId) from loginmaster")
loginDict = cursor1.fetchall()
cursor1.close()
connection.close()
return loginDict
def deleteCategory(self, categoryVO):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute("UPDATE categorymaster SET WHERE categoryId='" +
categoryVO.categoryId + "'")
connection.commit()
connection.close()
cursor1.close()
def updateState(self, stateVO):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute(
"UPDATE statemaster SET stateName='{}', stateDescription='{}' WHERE stateId = '{}' "
.format(stateVO.stateName, stateVO.stateDescription,
stateVO.stateId))
connection.commit()
cursor1.close()
connection.close()
def searchState(self):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute(
"select * from statemaster WHERE stateActiveStatus='active' ")
stateDict = cursor1.fetchall()
cursor1.close()
connection.close()
return stateDict
def deleteProduct(self, productVO):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute(
"UPDATE productmaster SET productActiveStatus='deactive' WHERE productId='"
+ productVO.productId + "'")
connection.commit()
connection.close()
cursor1.close()
def deleteseller(self, registerVO):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute(
"UPDATE sellerregistermaster SET registerActivestatus='deactive' WHERE registerId='"
+ registerVO.registerId + "'")
connection.commit()
cursor1.close()
connection.close()
def insertLogin(self,loginVO):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute("INSERT INTO loginmaster (loginRole,loginEmailId,loginPassword,\
loginActiveStatus) VALUES('{}','{}','{}','{}')".format\
(loginVO.loginRole,loginVO.loginEmailId,loginVO.loginPassword,loginVO.loginActiveStatus))
connection.commit()
cursor1.close()
connection.close()
def deleteSubcategory(self, subcategoryVO):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute(
"UPDATE subcategorymaster SET subcategoryActiveStatus='deactive' WHERE subcategoryId='"
+ subcategoryVO.subcategoryId + "'")
connection.commit()
connection.close()
cursor1.close()
def deletebuyer(self, loginVO):
connection = con_db()
cursor1 = connection.cursor()
#cursor1.execute("UPDATE userregistermaster SET userregisterActivestatus='deactive' WHERE userregisterId='" + registerVO.userregisterId + "' ")
cursor1.execute(
"UPDATE loginmaster SET loginActivestatus='deactive' WHERE loginId='"
+ loginVO.loginId + "'")
connection.commit()
connection.close()
cursor1.close()
def insertCategory(self, categoryVO):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute(
"INSERT INTO categorymaster (categoryName,categoryDescription,categoryActiveStatus) VALUES ('"
+ categoryVO.categoryName + "','" +
categoryVO.categoryDescription + "','" +
categoryVO.categoryActiveStatus + "')")
connection.commit()
cursor1.close()
connection.close()
def searchFeedback(self, feedbackVO):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute(
"SELECT * FROM feedbackmaster JOIN loginmaster ON feedbackmaster.feedbackFrom_loginId=loginmaster.loginId WHERE feedbackActiveStatus='active' "
)
data = cursor1.fetchall()
connection.commit()
cursor1.close()
connection.close()
return data
def deleteState(self, stateVO):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute(
"UPDATE statemaster SET stateActiveStatus='{}' WHERE stateId = '{}' "
.format(stateVO.stateActiveStatus, stateVO.stateId))
connection.commit()
cursor1.close()
connection.close()
def insertState(self, stateVO):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute(
"INSERT INTO statemaster (stateName,stateDescription,stateActiveStatus) VALUES ('{}','{}','{}')"
.format(stateVO.stateName, stateVO.stateDescription,
stateVO.stateActiveStatus))
connection.commit()
cursor1.close()
connection.close()
def searchCategory(self):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute(
"SELECT * FROM categorymaster WHERE categoryActiveStatus='active'")
data = cursor1.fetchall()
connection.commit()
connection.close()
cursor1.close()
return data
def editState(self, stateVO):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute(
" SELECT * FROM statemaster WHERE stateId = '{}' ".format(
stateVO.stateId))
stateDict = cursor1.fetchall()
cursor1.close()
connection.close()
return stateDict
def ajaxSubcategoryProduct(self, subcategoryVO):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute(
"SELECT * FROM subcategorymaster WHERE subcategory_categoryId='" +
str(subcategoryVO.subcategory_categoryId) + "' ")
subcategoryJsonDict = cursor1.fetchall()
connection.close()
cursor1.close()
return subcategoryJsonDict
def searchLoginDetailsById(self,loginVO):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute("SELECT * FROM loginmaster AS lm INNER JOIN registermaster AS rm ON lm.loginId = rm.register_LoginId WHERE loginId ='{}'".format(loginVO.loginId))
loginDict = cursor1.fetchall()
connection.commit()
cursor1.close()
connection.close()
return loginDict
def searchLoginByEmailId(self,loginVO):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute("SELECT * FROM loginmaster WHERE loginEmailId ='{}'".format(loginVO.loginEmailId))
loginDict = cursor1.fetchall()
connection.commit()
cursor1.close()
connection.close()
return loginDict
def search_data(self, id=None):
con_db_obj = con_db()
cursor = con_db_obj.connection.cursor()
if id is not None:
cursor.execute('select * from register_master_mvc where id=%s',
str(id))
return_data = cursor.fetchone()
else:
cursor.execute('select * from register_master_mvc')
return_data = cursor.fetchall()
cursor.close()
return return_data
def searchCategoryId(self, categoryVO):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute(
"SELECT * FROM categorymaster WHERE categoryName LIKE '" +
categoryVO.categoryName + "%'")
data = cursor1.fetchall()
connection.commit()
connection.close()
cursor1.close()
return data
def forheadersubcategorymen(self):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute(
"SELECT * FROM subcategorymaster AS s INNER JOIN categorymaster AS c ON s.`subcategory_categoryId` = c.`categoryId` WHERE s.subcategoryActiveStatus='active' and c.categoryName='men'"
)
data = cursor1.fetchall()
print("data=", data)
connection.commit()
connection.close()
cursor1.close()
return data
def insertFeedback(self, feedbackVO):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute(
"INSERT INTO feedbackmaster (feedbackSubject,feedbackDescription,feedbackRating,feedbackDate,feedbackTime,feedbackActiveStatus, feedbackFrom_loginId)VALUES ('"
+ feedbackVO.feedbackSubject + "','" +
feedbackVO.feedbackDescription + "','" +
feedbackVO.feedbackRating + "','" + feedbackVO.feedbackDate +
"','" + feedbackVO.feedbackTime + "','" +
feedbackVO.feedbackActivestatus + "','" +
str(feedbackVO.feedbackFrom_loginId) + "')")
connection.commit()
cursor1.close()
connection.close()
def searchSubcategory(self):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute("SELECT * FROM subcategorymaster")
cursor1.execute(
"SELECT * FROM subcategorymaster AS s INNER JOIN categorymaster AS c ON s.`subcategory_categoryId` = c.`categoryId`"
)
data = cursor1.fetchall()
connection.commit()
connection.close()
cursor1.close()
return data
def viewbuyer(self):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute("SELECT * FROM userregistermaster")
data1 = cursor1.fetchall()
connection.commit()
connection.close()
return data1
def ajaxLoadheadersubcategory(self, subcategoryVO):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute(
"SELECT * FROM subcategorymaster WHERE subcategory_categoryId= '" +
str(subcategoryVO.subcategory_categoryId) + "'")
ajaxheadersubcategoryDict = cursor1.fetchall()
connection.close()
cursor1.close()
return ajaxheadersubcategoryDict
def insertSubcategory(self, subcategoryVO):
connection = con_db()
cursor1 = connection.cursor()
cursor1.execute(
"INSERT INTO subcategorymaster (subcategoryName,subcategoryDescription,subcategoryActiveStatus,subcategory_categoryId) VALUES ('"
+ subcategoryVO.subcategoryName + "','" +
subcategoryVO.subcategoryDescription + "','" +
subcategoryVO.subcategoryActiveStatus + "','" +
str(subcategoryVO.subcategory_categoryId) + "')")
connection.commit()
print(subcategoryVO.subcategoryName,
subcategoryVO.subcategoryDescription,
subcategoryVO.subcategoryActiveStatus,
subcategoryVO.subcategory_categoryId)
cursor1.close()
connection.close()
