def signup():
if request.method == 'GET':
return render_template('/SignupForm.html')
CustomerId = request.form.get('CustomerId')
LName = request.form.get('LName')
FName = request.form.get('FName')
Address = request.form.get('Address')
City = request.form.get('City')
State = request.form.get('State')
ZipCode = request.form.get('ZipCode')
Telephone = request.form.get('Telephone')
Email = request.form.get('Email')
AccountId = request.form.get('AccountId')
AccountType = request.form.get('AccountType')
CreditCard = request.form.get('CreditCard')
credate = datetime.datetime.now().strftime("%Y-%m-%d")
if not (CustomerId and LName and FName and Address and City and State
and ZipCode and Telephone and Email and AccountId and AccountType
and CreditCard):
return redirect('/signup')
db_class = dbModule.Database()
sql = "INSERT INTO gmmovie.customers(CustomerId, LName, FName, Address, City, State, ZipCode, Telephone, Email, \
CreditCard, AccountId, AccountType, AccCreateDate, Rating) \
VALUES('%s','%s','%s','%s','%s','%s','%s','%s','%s','%s', '%d','%s', '%s', %d)" % \
(CustomerId, LName, FName, Address, City, State, ZipCode, Telephone, Email,
CreditCard, int(AccountId), AccountType, credate, 1)
db_class.execute(sql)
db_class.commit()
return redirect('/')
def mypage():
if 'user' in session:
chk = True
db_class = dbModule.Database()
sql = "select account_num, account_type, account_crdate \
from customer \
where customer_id='%s'" % session['user']
db_class.execute(sql)
accinfo = db_class.cursor.fetchall()
sql = "select M.movie_name, M.movie_type, M.number_of_copy, M.rating, M.movie_id \
from ORDER_DATA O, CUSTOMER C, MOVIE M \
where O.customer_id=C.customer_id and C.customer_id='%s' and O.movie_id=M.movie_id and O.return_time is null" % session[
'user']
db_class.execute(sql)
ordmovie = db_class.cursor.fetchall()
sql = "select M.movie_name, M.movie_type, M.number_of_copy, M.rating \
from customer C, movie M, queue Q \
where C.customer_id='%s' and C.customer_id=Q.customer_id and M.movie_id=Q.movie_id" % session[
'user']
db_class.execute(sql)
movieque = db_class.cursor.fetchall()
return render_template('/main/index.html',
ordmovie=ordmovie,
movieque=movieque,
accinfo=accinfo,
fbtn=chk)
else:
return render_template('/main/login.html')
def send():
input_url = check_intro(request.form['input_u'])
if (input_url == ''):
return render_template('/main/index.html',
result='please input URL!')
ascii_url = string_to_myNum(input_url)
shorten = make_shorten(ascii_url)
db_class = dbModule.Database()
sql1 = "SELECT shorten FROM shortenDB.shortenTable WHERE origin_url = '%s'" % input_url;
check = db_class.executeAll(sql1)
result_msg = ''
if check: # 이미 존재하는 url
result_msg = 'already done!'
else: # 존재하지 않는 url인 경우 새로 추가
print('check 0')
check_already = "SELECT count(*) FROM shortenDB.shortenTable WHERE shorten = '%s'" % shorten;
sameShortenCnt = db_class.executeAll(check_already)
sql = "INSERT INTO shortenDB.shortenTable VALUES('%s','%s',%d)" % (
input_url, shorten, sameShortenCnt[0]['count(*)'])
db_class.execute(sql)
db_class.commit()
result_msg = 'insert is done!'
db_class.commit()
return render_template('/main/index.html',
searchURL='http://' + input_url,
result=result_msg,
shorten_url='http://127.0.0.1:5000/main/' + shorten)
def register():
if request.method == 'GET':
return render_template('/main/register.html')
else:
db_class = dbModule.Database()
cid = request.form['cid']
lname = request.form['lname']
fname = request.form['fname']
address = request.form['address']
city = request.form['city']
state = request.form['state']
zipcode = request.form['zipcode']
telephone = request.form['telephone']
eaddress = request.form['eaddress']
cardnum = request.form['cardnum']
crating = request.form['crating']
accnum = request.form['accnum']
atype = request.form['atype']
crdate = datetime.datetime.now().strftime("%Y-%m-%d")
sql = "INSERT INTO DBProject.customer(customer_id, Lname, Fname, address, city, \
state, zipcode, telephone, Email_address, card_num, rating, account_num, \
account_type, account_crdate) \
VALUES('%s', '%s', '%s', '%s', '%s', '%s', '%d', '%s','%s', '%s', '%d', '%d', '%s', '%s')" % (
cid, lname, fname, address, city, state, int(zipcode), telephone,
eaddress, cardnum, int(crating), int(accnum), atype, crdate)
db_class.execute(sql)
db_class.commit()
return redirect('/')
def post(self):
try:
parser = reqparse.RequestParser()
parser.add_argument('o_result', type=int)
parser.add_argument('o_msg', type=str)
parser.add_argument('p_machine_id', type=int)
parser.add_argument('p_file_name', type=str)
args = parser.parse_args()
_result = args['o_result']
_msg = args['o_msg']
_machine_id = args['p_machine_id']
_file_name = args['p_file_name']
db_class = dbModule.Database()
data = db_class.executeSp('sp_delete_update_process',
(_result, _msg, _machine_id, _file_name))
print(data)
if data[0]['O_RESULT'] is 0:
return {
'o_result': str(data[0]['O_RESULT']),
'o_msg': str(data[0]['O_MESSAGE'])
}
else:
return {
'o_result': str(data[0]['O_RESULT']),
'o_msg': str(data[0]['O_MESSAGE'])
}
except Exception as e:
return {'o_result': 99, 'o_msg': str(e)}
def findMoviebyword():
if request.method == 'GET':
return render_template('/main/findbyword.html')
else:
if request.form['word']=='':
return'''
<script> alert("단어를 입력해 주세요");
location.href="/"
</script>
'''
else:
db_class= dbModule.Database()
words=request.form['word'].split(',')
result=[]
if(len(words)==1):
sql = "select movie_name from movie where movie_name like '%%"+words[0]+"%%'"
db_class.execute(sql)
result = db_class.cursor.fetchall()
else:
sql = "select movie_name from movie where movie_name like '%%"+words[0]+"%%' and movie_name like '%%"+words[1]+"%%'"
db_class.execute(sql)
result = db_class.cursor.fetchall()
return render_template('/main/index.html',findmovieword=result, words=words)
def PriceChange():
db_class = dbModule.Database()
#평균값.
avg_tmon = []
avg_naver = []
avg_auction = []
avg_interpark = []
for i in range(7):
print(sevenWeek[i])
avg_tmon.append(
db_class.selectAvgDataAsShopPerDay('Nintendo_TB', 'TMON',
sevenWeek[i]))
avg_naver.append(
db_class.selectAvgDataAsShopPerDay('Nintendo_TB', 'SSG',
sevenWeek[i]))
avg_auction.append(
db_class.selectAvgDataAsShopPerDay('Nintendo_TB', 'Auction',
sevenWeek[i]))
avg_interpark.append(
db_class.selectAvgDataAsShopPerDay('Nintendo_TB', 'Interpark',
sevenWeek[i]))
return render_template('main/PriceChange.html',
resultTmon=avg_tmon,
resultNaver=avg_naver,
resultAuction=avg_auction,
resultInterpark=avg_interpark)
def post(self):
try:
parser = reqparse.RequestParser()
parser.add_argument('o_result', type=int)
parser.add_argument('o_msg', type=str)
parser.add_argument('p_machine_id', type=int)
parser.add_argument('p_error_cd', type=str)
parser.add_argument('p_error_msg', type=str)
parser.add_argument('p_fix_yn', type=str)
args = parser.parse_args()
_result = args['o_result']
_msg = args['o_msg']
_machine_id = args['p_machine_id']
_error_cd = args['p_error_cd']
_error_msg = args['p_error_msg']
_fix_yn = args['p_fix_yn']
db_class = dbModule.Database()
data = db_class.executeSp('sp_insert_errer_info', (_result, _msg, _machine_id, _error_cd, _error_msg,
_fix_yn))
print(data)
if data[0]['O_RESULT'] is 0:
return {'o_result': str(data[0]['O_RESULT']), 'o_msg': str(data[0]['O_MESSAGE'])}
else:
return {'o_result': str(data[0]['O_RESULT']), 'o_msg': str(data[0]['O_MESSAGE'])}
except Exception as e:
return {'o_result': 99, 'o_msg': str(e)}
def register():
if request.method=='GET':
return render_template('/main/register.html')
else:
db_class= dbModule.Database()
customerid=request.form['customerid']
lastname=request.form['lastname']
firstname=request.form['firstname']
address=request.form['address']
city=request.form['city']
state=request.form['state']
zipcode=request.form['zipcode']
telephone=request.form['telephone']
accountnum=request.form['accountnum']
accounttype=request.form['accounttype']
email=request.form['email']
creditcard=request.form['creditcard']
createdate=datetime.datetime.now().strftime("%Y-%m-%d")
sql = "INSERT INTO movie.customer(customer_id, Lname, Fname, address, city, state, zip_code, telephone, account_num, account_type,customer_email,credit_card,acc_create_date) \
VALUES('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%d', '%s', '%s', '%s', '%s')"% (customerid,lastname,firstname,address,city,state,zipcode,telephone,int(accountnum),accounttype,email,creditcard,createdate)
db_class.execute(sql)
db_class.commit()
return redirect('/')
def findMoviebyActor():
if request.method == 'GET':
return render_template('/main/findbyactor.html')
else:
if request.form['actor']=='':
return'''
<script> alert("배우 이름을 입력해 주세요");
location.href="/"
</script>
'''
else:
db_class= dbModule.Database()
actors=request.form['actor'].split(',')
result=[]
if len(actors)==1:
sql = "select m.movie_name, a.actor_name from movie m, actor_movie_table amt, actor a \
where m.movie_id=amt.movie_id and amt.actor_id=a.actor_id and a.actor_name='%s'"%actors[0]
else:
sql = "select distinct m.movie_name, a1.actor_name, a2.actor_name from movie m, actor_movie_table amt, actor a1, actor a2 where m.movie_id=amt.movie_id and \
m.movie_id in(select amt1.movie_id from actor_movie_table amt1 where a1.actor_id=amt1.actor_id and a1.actor_name='%s') and \
m.movie_id in(select amt2.movie_id from actor_movie_table amt2 where a2.actor_id=amt2.actor_id and a2.actor_name='%s')"%(actors[0],actors[1])
db_class.execute(sql)
result = db_class.cursor.fetchall()
return render_template('/main/index.html',findmovieactor=result,actors=actors)
def post(self):
try:
parser = reqparse.RequestParser()
parser.add_argument('o_result', type=int)
parser.add_argument('o_msg', type=str)
parser.add_argument('p_machine_id', type=int)
parser.add_argument('p_version_info', type=str)
args = parser.parse_args()
_result = args['o_result']
_msg = args['o_msg']
_machine_id = args['p_machine_id']
_version_info = args['p_version_info']
db_class = dbModule.Database()
data = db_class.executeSp(
'sp_select_update_process',
(_result, _msg, _machine_id, _version_info))
print(data)
if len(data) > 0:
return data
else:
return [{'machine_id': -1}]
except Exception as e:
return {'o_result': 99, 'o_msg': str(e)}
def post(self):
try:
parser = reqparse.RequestParser()
parser.add_argument('o_result', type=int)
parser.add_argument('o_msg', type=str)
parser.add_argument('p_file_info_list', type=str)
args = parser.parse_args()
_result = args['o_result']
_msg = args['o_msg']
_file_info_list = args['p_file_info_list']
db_class = dbModule.Database()
json_data = json.loads(_file_info_list)
for item in json_data:
print(item)
data = db_class.executeSp(
'sp_update_del_yn', (_result, _msg, item['filename'], 'Y'))
if data[0]['O_RESULT'] is 0:
return {
'o_result': str(data[0]['O_RESULT']),
'o_msg': str(data[0]['O_MESSAGE'])
}
else:
return {
'o_result': str(data[0]['O_RESULT']),
'o_msg': str(data[0]['O_MESSAGE'])
}
except Exception as e:
return {'o_result': 99, 'o_msg': str(e)}
def rateMovie():
order_id = request.form.get('OrderId')
rating = request.form.get('Rating')
db_class = dbModule.Database()
sql = "UPDATE ORDERS SET ORating = " + rating + " WHERE OrderId=" + order_id + ";"
db_class.cursor.execute(sql)
db_class.commit()
return redirect('/')
def post(self, machine_id, status):
db_class = dbModule.Database()
db_class.execute('''
update master set machine_status = "%s", upd_dt = now() where machine_id = %d
''' % (status, machine_id))
db_class.commit()
def dataremove():
db_class = dbModule.Database()
sql = "DELETE FROM coffee"
db_class.execute(sql)
db_class.commit()
return render_template('/main/index.html')
def showMovieList():
sql = "SELECT * FROM MOVIES"
db_class = dbModule.Database()
cnt = db_class.cursor.execute(sql)
if cnt > 0:
movie = db_class.cursor.fetchall()
return render_template('/MovieForm.html', result=movie)
return render_template('/MovieForm.html', result='')
def select_data():
db_class = dbModule.Database()
sql = "SELECT idx, test \
FROM testTable"
row = db_class.executeAll(sql)
# print(row)
return row
def select():
db_class = dbModule.Database()
row = select_data()
return render_template('/test/test.html',
result=row,
resultData=row if len(row) < 1 else row[0],
resultUPDATE=None)
def handle_shorten(name):
db_class = dbModule.Database()
sql1 = "SELECT origin_url FROM shortenDB.shortenTable WHERE shorten = '%s'" % name;
check = db_class.executeAll(sql1)
if(check):
print('http://'+check[0]['origin_url'])
return redirect('http://'+check[0]['origin_url'])
else:
return render_template('/main/index.html')
def findBestsellerMovie():
db_class= dbModule.Database()
sql = "select movie_name, number_of_copy from movie where number_of_copy > 4"
db_class.execute(sql)
result= db_class.cursor.fetchall()
return render_template('/main/index.html',bestsellingmovies=result)
def index():
db_class= dbModule.Database()
sql = "SELECT * FROM movie"
db_class.execute(sql)
movielist= db_class.cursor.fetchall()
return render_template('/main/index.html',movielist=movielist)
def index():
chk = True
db_class = dbModule.Database()
sql = "SELECT * FROM movie"
db_class.execute(sql)
entmovie = db_class.cursor.fetchall()
return render_template('/main/index.html',
entmovie=entmovie,
initstate=chk)
def select():
db_class = dbModule.Database()
sql = "SELECT density, target \
FROM ISIADB.coffee"
row = db_class.executeAll(sql)
print(row)
return render_template('/main/index.html', result=None, densityData=row[0])
def post(self):
try:
parser = reqparse.RequestParser()
parser.add_argument('o_result', type=int)
parser.add_argument('o_msg', type=str)
parser.add_argument('p_machine_id', type=int)
parser.add_argument('p_design_type', type=int)
parser.add_argument('p_total_print_cnt', type=int)
parser.add_argument('p_print_cnt', type=int)
parser.add_argument('p_print_file_name', type=str)
parser.add_argument('p_file_name_1', type=str)
parser.add_argument('p_file_name_2', type=str)
parser.add_argument('p_file_name_3', type=str)
parser.add_argument('p_file_name_4', type=str)
parser.add_argument('p_file_name_5', type=str)
parser.add_argument('p_file_name_6', type=str)
parser.add_argument('p_file_name_7', type=str)
parser.add_argument('p_file_name_8', type=str)
parser.add_argument('p_file_name_9', type=str)
parser.add_argument('p_file_name_10', type=str)
args = parser.parse_args()
_result = args['o_result']
_msg = args['o_msg']
_machine_id = args['p_machine_id']
_design_type = args['p_design_type']
_total_print_cnt = args['p_total_print_cnt']
_print_cnt = args['p_print_cnt']
_print_file_name = args['p_print_file_name']
_file_name_1 = args['p_file_name_1']
_file_name_2 = args['p_file_name_2']
_file_name_3 = args['p_file_name_3']
_file_name_4 = args['p_file_name_4']
_file_name_5 = args['p_file_name_5']
_file_name_6 = args['p_file_name_6']
_file_name_7 = args['p_file_name_7']
_file_name_8 = args['p_file_name_8']
_file_name_9 = args['p_file_name_9']
_file_name_10 = args['p_file_name_10']
db_class = dbModule.Database()
data = db_class.executeSp('sp_insert_print_info', (_result, _msg, _machine_id, _design_type,
_total_print_cnt, _print_cnt, _print_file_name,
_file_name_1, _file_name_2, _file_name_3, _file_name_4,
_file_name_5, _file_name_6, _file_name_7, _file_name_8,
_file_name_9, _file_name_10))
print(data)
if data[0]['O_RESULT'] is 0:
return {'o_result': str(data[0]['O_RESULT']), 'o_msg': str(data[0]['O_MESSAGE'])}
else:
return {'o_result': str(data[0]['O_RESULT']), 'o_msg': str(data[0]['O_MESSAGE'])}
except Exception as e:
return {'o_result': 99, 'o_msg': str(e)}
def showOrder():
db_class = dbModule.Database()
sql = "select AccountId from customers where CustomerId=%s;"
db_class.cursor.execute(sql, session['logged_in']['CustomerId'])
account_id = db_class.cursor.fetchone()
sql2 = "select OrderId, MovieName, Date_Time, Return_Date, ORating from movies, " \
"orders where MovieId=OmovieId and OAccountId ="+str(account_id['AccountId'])+" ORDER BY OrderId;"
cnt = db_class.cursor.execute(sql2)
if cnt > 0:
order = db_class.cursor.fetchall()
return render_template('/RateForm.html', result=order)
return render_template('/RateForm.html', result='noorder')
def insert():
db_class = dbModule.Database()
sql = "INSERT INTO testDB.testTable(test) \
VALUES('%s')" % ('testData')
db_class.execute(sql)
db_class.commit()
return render_template('/layout.html',
result='insert is done!',
resultData=None,
resultUPDATE=None)
def insert():
db_class= dbModule.Database()
sql = "INSERT INTO flask_test.testTable(test) VALUES('테스트');"
db_class.execute(sql)
db_class.commit()
return render_template('/test/test.html',
result='insert is done!',
resultData=None,
resultUPDATE=None)
def insert():
db_class = dbModule.Database()
sql = ("INSERT INTO testDB.testTable(test) \
VALUES('%s')" % ("testData"))
db_class.execute(sql)
db_class.commit()
return render_template("/test/test.html",
result="insert is done!",
resultData=None,
resultUPDATE=None)
def showBestSeller():
sql = "SELECT MovieName FROM MOVIES WHERE NumCopies > 2;"
db_class = dbModule.Database()
cnt = db_class.cursor.execute(sql)
if cnt > 0:
movie = db_class.cursor.fetchall()
movieList = ''
for i in range(0, cnt):
if i == (cnt - 1): movieList += movie[i]['MovieName']
else: movieList += movie[i]['MovieName'] + ', '
return render_template('/Result.html', result=movieList, method='best')
return render_template('/Result.html', result='nomovie')
def select():
db_class = dbModule.Database()
sql = "SELECT * \
FROM team02.board_qna"
row = db_class.executeAll(sql)
return render_template(
'/main/index.html',
result=None,
resultDatas=row, # 해당 지점에서 전송
resultUPDATE=None)
