def edit_activity(self, activity_id,
details_list): #Can change name, desc and priority
dbb.execute(" UPDATE \"ACTIVITIES\" set activity_name=\'" +
details_list[0] + "\' ,priority=\'" + details_list[1] +
"\' ,username=\'" + str(details_list[2]) +
"\' where activity_id=" + str(activity_id))
return True
def edit_deliverable(self, del_id,
details_list): #Can change name, desc and priority
dbb.execute(" UPDATE \"DELIVERABLES\" set del_name=\'" +
details_list[0] + "\' ,del_desc=\'" + details_list[1] +
"\' ,priority=\'" + str(details_list[2]) +
"\' where del_id=" + str(del_id))
return True
def close_project(self,project_id):
try:
dbb.execute(" UPDATE \"PROJECTS\" set status='Completed' where project_id="+str(project_id))
return True
except:
print("Error")
return False
def mark_completed(self, project_id):
try:
dbb.execute(
" UPDATE \"PROJECTS\" set phase='Closure' where project_id=" +
str(project_id))
return True
except:
print("Error")
return False
def assign_activity(self, activity_id, username):
# try:
dbb.execute(" UPDATE \"ACTIVITIES\" set username=\'" + username +
"\' where activity_id=" + str(activity_id) +
"and username is null")
now = datetime.datetime.now()
dbb.execute(" UPDATE \"ACTIVITIES\" set start_date=\'" +
now.strftime("%Y-%m-%d") + "\' where activity_id=" +
str(activity_id))
return True
def approve_activity(self, project_id, del_id, activity_id):
try:
dbb.execute(
" UPDATE \"ACTIVITIES\" set status='Completed' where project_id="
+ str(project_id) + "and del_id=" + str(del_id) +
"and activity_id=" + str(activity_id))
now = datetime.datetime.now()
dbb.execute(" UPDATE \"ACTIVITIES\" set end_date=\'" +
now.strftime("%Y-%m-%d") + "\' where project_id=" +
str(project_id) + "and del_id=" + str(del_id) +
"and activity_id=" + str(activity_id))
return True
except:
print("Error")
return False
def request_PO(self,project_id,list):
try:
result_set = dbb.execute("SELECT MAX(serial_num) FROM \"PO\"") # Serial id for new project
for r in result_set:
serial_num = r[0] + 1
result_set = dbb.execute("SELECT MAX(po_id) FROM \"PO\"") # Purchase order id for new project
for r in result_set:
po_id = r[0] + 1
for orders in list:
resource = RESOURCES.query.with_entities(RESOURCES.r_id).filter_by(resource_name=orders[0]).first()
po=PO(serial_num,po_id,project_id,resource[0],orders[1],'N')
db.session.add(po)
db.session.commit()
serial_num+=1
return True
except:
db.session.rollback()
return False
def create_deliverable(self, project_id, details_list):
# try:
result_set = dbb.execute("SELECT MAX(del_id) FROM \"DELIVERABLES\""
) # Deliverable id for new project
for r in result_set:
del_id = r[0] + 1
new_del = DELIVERABLES(del_id, project_id, details_list[0],
details_list[1], details_list[2])
db.session.add(new_del)
db.session.commit()
return True
def create_project(self,details_list):
try:
result_set = dbb.execute("SELECT MAX(project_id) FROM \"PROJECTS\"") # Project id for new project
for r in result_set:
project_id = r[0] + 1
new_proj = PROJECTS(project_id, details_list[0], details_list[1], details_list[2], None, None,
details_list[3], "In Process", "Initiation", details_list[4], 1, details_list[5], 0, 0,
details_list[6])
db.session.add(new_proj)
db.session.commit()
return True
except:
db.session.rollback()
return False
def create_activity(self, project_id, del_id, details_list, username=None):
try:
result_set = dbb.execute(
"SELECT MAX(activity_id) FROM \"ACTIVITIES\""
) # Activity id for new project
for r in result_set:
activity_id = r[0] + 1
if (username == None):
activity = ACTIVITIES(activity_id, details_list[0], project_id,
None, None, details_list[1], del_id,
details_list[2], username, 'In Process')
else:
now = datetime.datetime.now()
activity = ACTIVITIES(activity_id, details_list[0], project_id,
now.strftime("%Y-%m-%d"), None,
details_list[1], del_id, details_list[2],
username, 'In Process')
db.session.add(activity)
db.session.commit()
except:
db.session.rollback()
return False
def mps(start_date,end_date):
return dbb.execute('SELECT pf.portfolio_name, p.project_name, p.start_date, p.end_date, p.quantity FROM \"PROJECTS\" as p,\"PORTFOLIO\" as pf where (CAST(end_date as text) BETWEEN \'2017-10%%\' AND \'2018-01%%\') AND (p.portfolio_id = pf.portfolio_id) ORDER BY pf.portfolio_name')
def get_portfolios():
return dbb.execute('select pf.portfolio_name,p.project_name,SUM(p.quantity) as qty from \"PROJECTS\" as p,\"PORTFOLIO\" as pf where p.portfolio_id = pf.portfolio_id AND (CAST (end_date as text) BETWEEN \'2017-10%%\' AND \'2018-01%%\') GROUP BY pf.portfolio_name,p.project_name ORDER BY pf.portfolio_name')
def get_project_edit_details(proj_id):
return dbb.execute('SELECT project_name,project_desc,priority FROM \"PROJECTS\" where project_id=' + str(proj_id))
def get_del_edit_details(proj_id,del_id):
return dbb.execute('SELECT del_name,del_desc,priority FROM \"DELIVERABLES\" where del_id=' + str(del_id) + 'and project_id=' + str(proj_id))
def edit_project(self, project_id, details_list): #Can change name, desc and priority
dbb.execute(" UPDATE \"PROJECTS\" set project_name=\'" + details_list[0] + "\' ,project_desc=\'" + details_list[1] + "\' ,priority=\'" + str(details_list[2]) + "\' where project_id=" + str(project_id))
return True
