def post(self):
user = users.get_current_user()
if user:
project_key = self.request.get('project_key')
function_type = self.request.get('function_type')
if project_key <> '':
func_entity = FunctionEntity(
project_key=project_key,
function_type=function_type,
function_name='',
measurement_index1=0,
measurement_index2=0,
sort_order=99,
);
func_entity.put()
return self.response.out.write(json.write(func_entity.to_dict()))
else:
err = {'error':common.message('project_not_selected')}
return self.response.out.write(json.write(err))
else:
err = {'error':common.message('login_err',common.AppSettings('/fp'))}
return self.response.out.write(json.write(err))
err = {'error':'Unknown Error'}
return self.response.out.write(json.write(err))
def post(self):
user = users.get_current_user()
if user:
project_key = self.request.get('project_key')
function_type = self.request.get('function_type')
if project_key <> '':
func_entity = FunctionEntity(
project_key=project_key,
function_type=function_type,
function_name='',
measurement_index1=0,
measurement_index2=0,
sort_order=99,
)
func_entity.put()
return self.response.out.write(
json.write(func_entity.to_dict()))
else:
err = {'error': common.message('project_not_selected')}
return self.response.out.write(json.write(err))
else:
err = {
'error': common.message('login_err', common.AppSettings('/fp'))
}
return self.response.out.write(json.write(err))
err = {'error': 'Unknown Error'}
return self.response.out.write(json.write(err))
def post(self):
user = users.get_current_user()
if user:
key_str = self.request.get('key')
key = db.Key(key_str)
func_entity = None
q = FunctionEntity.gql("WHERE __key__ = :1", key)
results = q.fetch(1)
for result in results:
result.delete()
func_entity = result
if func_entity:
return self.response.out.write(json.write({'key': key_str}))
else:
err = {'error': 'Entity is not found.'}
return self.response.out.write(json.write(err))
else:
err = {
'error': common.message('login_err', common.AppSettings('/fp'))
}
return self.response.out.write(json.write(err))
err = {'error': 'Unknown Error'}
return self.response.out.write(json.write(err))
def post(self):
user = users.get_current_user()
if user:
key_str = self.request.get('project_profile_key')
key = db.Key(key_str)
q_parent = FunctionPointProject.gql("WHERE __key__ =:1", key)
projects = q_parent.fetch(1)
for project in projects:
q_child = FunctionEntity.gql("WHERE project_key =:1", key_str)
entities = q_child.fetch(MAX_FUNCTION)
for entity in entities:
entity.delete()
project.delete()
projects = list_projects(user)
return self.response.out.write(json.write({'items': projects}))
else:
err = {
'error': common.message('login_err', common.AppSettings('/fp'))
}
return self.response.out.write(json.write(err))
err = {'error': 'Unknown Error'}
return self.response.out.write(json.write(err))
def post(self):
user = users.get_current_user()
if user:
project_key = self.request.get('project_key')
key_str = self.request.get('key')
q = FunctionEntity.gql("WHERE project_key=:1 ORDER BY sort_order", project_key)
functions = q.fetch(MAX_FUNCTION)
for i, func in enumerate(functions):
if key_str == str(func.key()):
if i > 0:
tmp = functions[i - 1]
functions[i - 1] = functions[i]
functions[i] = tmp
functions[i - 1].put()
functions[i].put()
break
sort_order = 1
for func in functions:
func.sort_order = sort_order
func.put()
sort_order += 1
result = list_functions(project_key)
return self.response.out.write(json.write({'items':result}))
else:
err = {'error':common.message('login_err',common.AppSettings('/fp'))}
return self.response.out.write(json.write(err))
err = {'error':'Unknown Error'}
return self.response.out.write(json.write(err))
def post(self):
user = users.get_current_user()
if user:
key_str = self.request.get('key')
key = db.Key(key_str);
func_entity = None
q = FunctionEntity.gql("WHERE __key__ = :1", key)
results = q.fetch(1)
for result in results:
result.delete()
func_entity = result
if func_entity:
return self.response.out.write(json.write({'key':key_str}))
else:
err = {'error':'Entity is not found.'}
return self.response.out.write(json.write(err))
else:
err = {'error':common.message('login_err',common.AppSettings('/fp'))}
return self.response.out.write(json.write(err))
err = {'error':'Unknown Error'}
return self.response.out.write(json.write(err))
def list_functions(project_key):
functions = []
q = FunctionEntity.gql("WHERE project_key=:1 ORDER BY sort_order", project_key)
results = q.fetch(MAX_FUNCTION)
sort_order = 1
for result in results:
result.sort_order = sort_order
sort_order += 1
functions.append(result.to_dict())
result.put()
return functions
def list_functions(project_key):
functions = []
q = FunctionEntity.gql("WHERE project_key=:1 ORDER BY sort_order",
project_key)
results = q.fetch(MAX_FUNCTION)
sort_order = 1
for result in results:
result.sort_order = sort_order
sort_order += 1
functions.append(result.to_dict())
result.put()
return functions
def post(self):
user = users.get_current_user()
if user:
key_str = self.request.get('key')
function_name = self.request.get('function_name')
function_category = self.request.get('function_category')
measurement_index1_str = self.request.get('measurement_index1')
measurement_index2_str = self.request.get('measurement_index2')
try:
measurement_index1 = int(measurement_index1_str.strip())
measurement_index2 = int(measurement_index2_str.strip())
except:
err = {'error': 'Invalid number.'}
return self.response.out.write(json.write(err))
key = db.Key(key_str)
func_entity = None
q = FunctionEntity.gql("WHERE __key__ = :1", key)
results = q.fetch(1)
for result in results:
result.function_name = function_name
result.function_category = function_category
result.measurement_index1 = measurement_index1
result.measurement_index2 = measurement_index2
result.put()
func_entity = result
if func_entity:
return self.response.out.write(
json.write(func_entity.to_dict()))
else:
err = {'error': 'Entity is not found.'}
return self.response.out.write(json.write(err))
else:
err = {
'error': common.message('login_err', common.AppSettings('/fp'))
}
return self.response.out.write(json.write(err))
err = {'error': 'Unknown Error'}
return self.response.out.write(json.write(err))
def post(self):
user = users.get_current_user()
if user:
key_str = self.request.get('key')
function_name = self.request.get('function_name')
function_category = self.request.get('function_category')
measurement_index1_str = self.request.get('measurement_index1')
measurement_index2_str = self.request.get('measurement_index2')
try:
measurement_index1 = int(measurement_index1_str.strip())
measurement_index2 = int(measurement_index2_str.strip())
except:
err = {'error':'Invalid number.'}
return self.response.out.write(json.write(err))
key = db.Key(key_str);
func_entity = None
q = FunctionEntity.gql("WHERE __key__ = :1", key)
results = q.fetch(1)
for result in results:
result.function_name = function_name
result.function_category = function_category
result.measurement_index1 = measurement_index1
result.measurement_index2 = measurement_index2
result.put()
func_entity = result
if func_entity:
return self.response.out.write(json.write(func_entity.to_dict()))
else:
err = {'error':'Entity is not found.'}
return self.response.out.write(json.write(err))
else:
err = {'error':common.message('login_err',common.AppSettings('/fp'))}
return self.response.out.write(json.write(err))
err = {'error':'Unknown Error'}
return self.response.out.write(json.write(err))
def post(self):
user = users.get_current_user()
if user:
project_key = self.request.get('project_key')
key_str = self.request.get('key')
q = FunctionEntity.gql("WHERE project_key=:1 ORDER BY sort_order",
project_key)
functions = q.fetch(MAX_FUNCTION)
for i, func in enumerate(functions):
if key_str == str(func.key()):
if i > 0:
tmp = functions[i - 1]
functions[i - 1] = functions[i]
functions[i] = tmp
functions[i - 1].put()
functions[i].put()
break
sort_order = 1
for func in functions:
func.sort_order = sort_order
func.put()
sort_order += 1
result = list_functions(project_key)
return self.response.out.write(json.write({'items': result}))
else:
err = {
'error': common.message('login_err', common.AppSettings('/fp'))
}
return self.response.out.write(json.write(err))
err = {'error': 'Unknown Error'}
return self.response.out.write(json.write(err))
def post(self):
user = users.get_current_user()
if user:
key_str = self.request.get('project_profile_key')
key = db.Key(key_str)
q_parent = FunctionPointProject.gql("WHERE __key__ =:1", key)
projects = q_parent.fetch(1)
for project in projects:
q_child = FunctionEntity.gql("WHERE project_key =:1", key_str)
entities = q_child.fetch(MAX_FUNCTION)
for entity in entities:
entity.delete()
project.delete()
projects = list_projects(user)
return self.response.out.write(json.write({'items':projects}))
else:
err = {'error':common.message('login_err',common.AppSettings('/fp'))}
return self.response.out.write(json.write(err))
err = {'error':'Unknown Error'}
return self.response.out.write(json.write(err))
def post(self):
user = users.get_current_user()
if user:
project_key = self.request.get('project_key')
if project_key.strip() == "":
html = "<html><head></head><body><span style='color:red'>エラー! プロジェクトが選択されていません。</span></body></html>"
return self.response.out.write(html)
key = db.Key(project_key)
q = FunctionPointProject.gql("WHERE __key__ =:1", key)
project = None
projects = q.fetch(1)
for project in projects:
break
if project == None:
html = "<html><head></head><body><span style='color:red'>エラー! 選択されたプロジェクトが見つかりません。</span></body></html>"
return self.response.out.write(html)
self.response.headers.add_header("Content-Disposition",
'attachment; filename="fp.xls"')
#
font_title = xlwt.Font()
font_title.bold = True
style_title = xlwt.XFStyle()
style_title.font = font_title
#
font_num = xlwt.Font()
font_num.colour_index = 4
style_num = xlwt.XFStyle()
style_num.num_format_str = '0.00'
style_num.font = font_num
#
font_link = xlwt.Font()
font_link.colour_index = 4
font_link.underline = xlwt.Font.UNDERLINE_DOUBLE
style_link = xlwt.XFStyle()
style_link.font = font_link
#
font_link = xlwt.Font()
font_link.colour_index = 4
font_link.underline = xlwt.Font.UNDERLINE_DOUBLE
style_link = xlwt.XFStyle()
style_link.font = font_link
wb = xlwt.Workbook(encoding='utf-8')
ws = wb.add_sheet(u'FUNCTION POINT')
#
base_col = 1
r = 1
col_w = (0x0500, 0x0500, 0x2800, 0x2400, 0x0a00, 0x0a00, 0x0a00,
0x0a00)
for i, v in enumerate(col_w):
ws.col(i).width = v
ws.write(r, base_col, u'ファンクションポイント', style_title)
#
n = "HYPERLINK"
ws.write(
r, base_col + 2,
xlwt.Formula(
n +
'("http://typea-service.appspot.com/fp";"function point")'
), style_link)
r = 3
ws.write(r, base_col + 0, u'システム', style_title)
ws.write(r, base_col + 2, u'アプリケーション', style_title)
ws.write(r, base_col + 3, u'計測タイプ', style_title)
r = 4
ws.write(r, base_col + 0, project.system_name)
ws.write(r, base_col + 2, project.application_name)
ws.write(r, base_col + 3, project.mesurement_type_name())
r = 6
ws.write(r, base_col + 0, u'No', style_title)
ws.write(r, base_col + 1, u'要素処理名', style_title)
ws.write(r, base_col + 2, u'区分', style_title)
ws.write(r, base_col + 3, u'DET', style_title)
ws.write(r, base_col + 4, u'RET/FTR', style_title)
ws.write(r, base_col + 5, u'複雑度', style_title)
ws.write(r, base_col + 6, u'FP', style_title)
non_adjust_fp = 0.0
q = FunctionEntity.gql("WHERE project_key=:1 ORDER BY sort_order",
project_key)
functions = q.fetch(MAX_FUNCTION)
for i, func in enumerate(functions):
r += 1
ws.write(r, base_col + 0, i + 1)
ws.write(r, base_col + 1, func.function_name)
ws.write(r, base_col + 2, func.function_category_name())
ws.write(r, base_col + 3, func.measurement_index1, style_num)
ws.write(r, base_col + 4, func.measurement_index2, style_num)
ws.write(r, base_col + 5, func.complexity())
ws.write(r, base_col + 6, to_float(func.function_point()),
style_num)
non_adjust_fp = non_adjust_fp + to_float(func.function_point())
r += 1
ws.write(r, base_col + 3, u'未調整FP値 計', style_title)
ws.write(r, base_col + 6, non_adjust_fp, style_num)
r += 1
ws.write(r, base_col + 3, u'調整係数 計', style_title)
ws.write(r, base_col + 6, project.total_adjust_points(), style_num)
r += 1
ws.write(r, base_col + 3, u'FP 値', style_title)
ws.write(r, base_col + 6,
non_adjust_fp + project.total_adjust_points(), style_num)
r += 1
dat = (
(u'データ通信(Data Communications)', project.data_communications),
(u'分散処理(Distributed Data Processing)',
project.distoributed_processing),
(u'性能(Performance)', project.performance),
(u'高負荷構成(Heavily Used Configuration)',
project.heavily_used_configuration),
(u'トランザクション量(Transaction Rate)', project.transaction_rate),
(u'オンライン入力(Online Data Entry)', project.online_data_entry),
(u'エンドユーザー効率(End-User Efficiency)',
project.enduser_efficiency),
(u'オンライン更新(Online Update)', project.online_update),
(u'複雑な処理(Complex Processing)', project.complex_processing),
(u'再利用可能性(Reusability)', project.reusability),
(u'インストール容易性(Installation Ease)', project.installation_ease),
(u'運用性(Operational Ease)', project.operational_ease),
(u'複数サイト(Multiple Sites)', project.multiple_sites),
(u'変更容易性(Facilitate Change)', project.facilitate_change),
)
r = r + 2
ws.write(r, base_col + 2, u'調整係数', style_title)
for (k, d) in enumerate(dat):
r = r + 1
ws.write(r, base_col + 1, k + 1)
ws.write(r, base_col + 2, d[0])
ws.write(r, base_col + 3, d[1], style_num)
wb.save(self.response.out)
return None
else:
html = "<html><head></head><body><span style='color:red'>エラー! ログインされていません。ログインしてください。</span></body></html>"
return self.response.out.write(html)
err = {'error': 'Unknown Error'}
return self.response.out.write(json.write(err))
def post(self):
user = users.get_current_user()
if user:
project_key = self.request.get('project_key')
if project_key.strip() == "":
html = "<html><head></head><body><span style='color:red'>エラー! プロジェクトが選択されていません。</span></body></html>"
return self.response.out.write(html)
key = db.Key(project_key)
q = FunctionPointProject.gql("WHERE __key__ =:1", key)
project = None
projects = q.fetch(1)
for project in projects:
break
if project == None:
html = "<html><head></head><body><span style='color:red'>エラー! 選択されたプロジェクトが見つかりません。</span></body></html>"
return self.response.out.write(html)
self.response.headers.add_header("Content-Disposition", 'attachment; filename="fp.xls"' )
#
font_title = xlwt.Font()
font_title.bold = True
style_title = xlwt.XFStyle()
style_title.font = font_title
#
font_num = xlwt.Font()
font_num.colour_index = 4
style_num = xlwt.XFStyle()
style_num.num_format_str = '0.00'
style_num.font = font_num
#
font_link = xlwt.Font()
font_link.colour_index = 4
font_link.underline = xlwt.Font.UNDERLINE_DOUBLE
style_link = xlwt.XFStyle()
style_link.font = font_link
#
font_link = xlwt.Font()
font_link.colour_index = 4
font_link.underline = xlwt.Font.UNDERLINE_DOUBLE
style_link = xlwt.XFStyle()
style_link.font = font_link
wb = xlwt.Workbook(encoding='utf-8')
ws = wb.add_sheet(u'FUNCTION POINT')
#
base_col = 1
r = 1
col_w = (0x0500,0x0500,0x2800,0x2400,0x0a00,0x0a00,0x0a00,0x0a00)
for i, v in enumerate(col_w):
ws.col(i).width = v
ws.write(r, base_col, u'ファンクションポイント', style_title)
#
n = "HYPERLINK"
ws.write(r, base_col+2, xlwt.Formula(n + '("http://typea-service.appspot.com/fp";"function point")'), style_link)
r = 3
ws.write(r, base_col + 0, u'システム' , style_title)
ws.write(r, base_col + 2, u'アプリケーション' , style_title)
ws.write(r, base_col + 3, u'計測タイプ' , style_title)
r = 4
ws.write(r, base_col + 0, project.system_name)
ws.write(r, base_col + 2, project.application_name)
ws.write(r, base_col + 3, project.mesurement_type_name())
r = 6
ws.write(r, base_col + 0, u'No' , style_title)
ws.write(r, base_col + 1, u'要素処理名' , style_title)
ws.write(r, base_col + 2, u'区分' , style_title)
ws.write(r, base_col + 3, u'DET' , style_title)
ws.write(r, base_col + 4, u'RET/FTR' , style_title)
ws.write(r, base_col + 5, u'複雑度' , style_title)
ws.write(r, base_col + 6, u'FP' , style_title)
non_adjust_fp = 0.0
q = FunctionEntity.gql("WHERE project_key=:1 ORDER BY sort_order", project_key)
functions = q.fetch(MAX_FUNCTION)
for i, func in enumerate(functions):
r += 1
ws.write(r, base_col + 0, i + 1)
ws.write(r, base_col + 1, func.function_name)
ws.write(r, base_col + 2, func.function_category_name())
ws.write(r, base_col + 3, func.measurement_index1 , style_num)
ws.write(r, base_col + 4, func.measurement_index2 , style_num)
ws.write(r, base_col + 5, func.complexity())
ws.write(r, base_col + 6, to_float(func.function_point()), style_num)
non_adjust_fp = non_adjust_fp + to_float(func.function_point())
r += 1
ws.write(r, base_col + 3, u'未調整FP値 計' , style_title)
ws.write(r, base_col + 6, non_adjust_fp, style_num)
r += 1
ws.write(r, base_col + 3, u'調整係数 計' , style_title)
ws.write(r, base_col + 6, project.total_adjust_points(), style_num)
r += 1
ws.write(r, base_col + 3, u'FP 値' , style_title)
ws.write(r, base_col + 6, non_adjust_fp + project.total_adjust_points(), style_num)
r += 1
dat = ((u'データ通信(Data Communications)' ,project.data_communications),
(u'分散処理(Distributed Data Processing)' ,project.distoributed_processing),
(u'性能(Performance)' ,project.performance),
(u'高負荷構成(Heavily Used Configuration)' ,project.heavily_used_configuration),
(u'トランザクション量(Transaction Rate)' ,project.transaction_rate),
(u'オンライン入力(Online Data Entry)' ,project.online_data_entry),
(u'エンドユーザー効率(End-User Efficiency)' ,project.enduser_efficiency ),
(u'オンライン更新(Online Update)' ,project.online_update),
(u'複雑な処理(Complex Processing)' ,project.complex_processing),
(u'再利用可能性(Reusability)' ,project.reusability),
(u'インストール容易性(Installation Ease)' ,project.installation_ease),
(u'運用性(Operational Ease)' ,project.operational_ease),
(u'複数サイト(Multiple Sites)' ,project.multiple_sites),
(u'変更容易性(Facilitate Change)' ,project.facilitate_change),
)
r = r + 2
ws.write(r, base_col + 2, u'調整係数', style_title)
for (k, d) in enumerate(dat):
r = r + 1
ws.write(r, base_col + 1, k + 1)
ws.write(r, base_col + 2, d[0])
ws.write(r, base_col + 3, d[1], style_num)
wb.save(self.response.out)
return None
else:
html = "<html><head></head><body><span style='color:red'>エラー! ログインされていません。ログインしてください。</span></body></html>"
return self.response.out.write(html)
err = {'error':'Unknown Error'}
return self.response.out.write(json.write(err))