def manufacture_main():
object_rows = Rows()
if current_user.is_authenticated:
print(current_user)
return render_template('manufacture.html',
specific_list=None,
object=object_rows)
else:
return render_template('error.html',
title='405 method not allowed :(',
str='Please... re try the login.',
url='main_login'), 404
def product_main():
row_object = Rows()
if current_user.is_authenticated:
print(current_user)
return render_template('production_main.html',
specific_list=None,
object=row_object)
else:
return render_template('error.html',
title='405 method not allowed :(',
str='Please... re try the login.',
url='main_login'), 404
def statistics_main():
row_object = Rows()
return render_template('statistics_main.html',
specific_rows=None,
object=row_object)
def shipment_main():
row_object = Rows()
return render_template('shipment_main.html', rows=None, object=row_object)
def chartTable_main():
row_object = Rows()
return render_template('chart_table_main.html', object=row_object)
def test():
user = USERS["user01"]
login_user(user)
object = Rows()
return render_template('test.html', object=object)
def filtering():
_filter = request.values.get('filter')
_sub_filter = request.values.get('sub_filter')
_sDate = request.values.get('sDate')
_eDate = request.values.get('eDate')
print("Filtering1 Get value : ")
print(_filter + ' ' + _sub_filter + ' ' + _sDate + ' ' + _eDate)
_sDate = _sDate.split('-')
_eDate = _eDate.split('-')
for i in range(0, 3):
_sDate[i] = int(_sDate[i])
_eDate[i] = int(_eDate[i])
s_week = week_num(_sDate[0], _sDate[1], _sDate[2])
e_week = week_num(_eDate[0], _eDate[1], _eDate[2])
query = {
"$and": [{
u"week": {
u"$gte": s_week
}
}, {
u"week": {
u"$lte": e_week
}
}, {
u"show": {
u"$eq": '1'
}
}]
}
try:
_DB_object = MongodbConnection()
rows_collection = _DB_object.db_conn(_DB_object.db_client(),
'product_info')
rows_list = list(
rows_collection.find(query)) # cursor type -> list type
except Exception as e:
print("DB_error : Class Rows.manufacture()", end=" >> ")
print(e)
finally:
_DB_object.db_close()
model_rows = []
model_coll = _DB_object.db_conn(_DB_object.db_client(), 'model')
for row in rows_list:
query = {"_id": {'$eq': ObjectId(row['model_id'])}}
model_rows.extend(list(
model_coll.find(query))) # cursor type -> list type
history_rows = []
history_coll = _DB_object.db_conn(_DB_object.db_client(), 'history')
for row in rows_list:
query = {
"$and": [{
"product_id": {
'$eq': str(row['_id'])
}
}, {
'show': {
'$eq': '1'
}
}]
}
history_rows.extend(list(
history_coll.find(query))) # cursor type -> list type
print("Date match rows :")
for row in rows_list:
print(row)
print("Reference model rows :")
for row in model_rows:
print(row)
print("Reference history rows :")
for row in history_rows:
print(row)
merge_list = []
for i in range(0, len(rows_list)):
new_dic = {}
new_dic.update(rows_list[i])
new_dic.update(model_rows[i])
new_dic.update(history_rows[i])
merge_list.append(new_dic)
print("Merge List")
for lis in merge_list:
print(lis)
if _filter == '전체':
m_value = None
l_value = None
s_value = None
elif _filter == '모델':
m_value = _sub_filter
l_value = None
s_value = None
elif _filter == '위치':
m_value = None
l_value = _sub_filter
s_value = None
elif _filter == '상태':
m_value = None
l_value = None
s_value = _sub_filter
else:
m_value = _sub_filter
l_value = _sub_filter
s_value = _sub_filter
_filter_dic = {'model': m_value, 'location': l_value, 'state': s_value}
print(_filter_dic)
first_filtering_list = []
second_filtering_list = []
third_filtering_list = []
print("> Model Filtering")
if _filter_dic['model'] is not None:
for idx, merge_row in enumerate(merge_list):
if merge_row.get('model') == _filter_dic['model']:
print(idx, merge_row)
first_filtering_list.append(merge_row)
else:
print("Delete : ", end='')
print(idx, merge_row)
else:
first_filtering_list = merge_list
print(">> Location Filtering")
if _filter_dic['location'] is not None:
for idx, merge_row in enumerate(first_filtering_list):
if merge_row.get('location') == _filter_dic['location']:
print(idx, merge_row)
second_filtering_list.append(merge_row)
else:
print("Delete : ", end='')
print(idx, merge_row)
else:
second_filtering_list = first_filtering_list
print(">>> State Filtering")
if _filter_dic['state'] is not None:
for idx, merge_row in enumerate(second_filtering_list):
if merge_row.get('state') == _filter_dic['state']:
print(idx, merge_row)
third_filtering_list.append(merge_row)
else:
print("Delete : ", end='')
print(idx, merge_row)
else:
third_filtering_list = second_filtering_list
print("After Filtering")
if not third_filtering_list:
print("After filtering . . . List is Empty")
else:
for lis in third_filtering_list:
print(lis)
row_object = Rows()
return render_template('production_main.html',
specific_list=third_filtering_list,
object=row_object)