def updateStatus(LawyerID, ClientID, Status, AccusedID='', Type='', FilingNo=''): '''LAWYER: Update request status''' query = 'UPDATE Lawyer_Request SET Status = %s WHERE LawyerID = %s AND ClientID = %s' param = (Status, LawyerID, ClientID) res = insertUpdateDeleteWrapper(query, param) if (Status == 2): return res else: # CIVIL if (Type == 0): query = 'INSERT INTO Pending_Cases (FilingDate, VictimID, Victim_LawyerID, Type) VALUES (CURDATE(), %s, %s, %s)' param = (ClientID, LawyerID, Type) return insertUpdateDeleteWrapper(query, param) # CRIME else: if (not AccusedID and not FilingNo): query = 'UPDATE Lawyer_Request SET Status = 0 WHERE LawyerID = %s AND ClientID = %s' param = (LawyerID, ClientID) res = insertUpdateDeleteWrapper(query, param) return {'res': 'failed'} if (not FilingNo): query = 'INSERT INTO Pending_Cases (FilingDate, VictimID, Victim_LawyerID, AccusedID, Type) VALUES (CURDATE(), %s, %s, %s, %s)' param = (ClientID, LawyerID, AccusedID, Type) return insertUpdateDeleteWrapper(query, param) else: return attachAccusedLawyer(FilingNo, LawyerID)
def appointLawyer(FirmID, ClientID, Status, LawyerID=""): '''FIRM: Appoint a lawyer to a client''' query = "UPDATE Firm_Request SET Status = %s where FirmID = %s and ClientID = %s" param = ( Status, FirmID, ClientID, ) result = insertUpdateDeleteWrapper(query, param) if (Status == 2): return result else: query = "SELECT * from Firm_Request where FirmID = %s and ClientID = %s" param = ( FirmID, ClientID, ) res = selectWrapper(query, param) if (res['res'] == 'failed'): return res else: values = res['arr'][0] query = "INSERT into Lawyer_Request(ClientID, LawyerID, FilingNo, Client_Note, Quotation, Status) VALUES(%s,%s,%s,%s,%s,0)" param = ( ClientID, LawyerID, values['FilingNo'], values['Client_Note'], values['Quotation'], ) return insertUpdateDeleteWrapper(query, param)
def updateCaseStatements(CNRno, VictimStmnt='', AccusedStmnt='', Acts=''): '''OFFICER: Update Victime Statements, Add acts''' result = {} if (not VictimStmnt and not AccusedStmnt and not Acts): return {'res': 'failed', 'type': 'empty params'} if (VictimStmnt): query = "UPDATE Active_Cases SET VictimStmnt = %s WHERE CNRno = %s" param = (VictimStmnt, CNRno) result = insertUpdateDeleteWrapper(query, param) if (result['res'] == 'failed'): return result if (AccusedStmnt): query = "UPDATE Active_Cases SET AccusedStmnt = %s WHERE CNRno = %s" param = (AccusedStmnt, CNRno) result = insertUpdateDeleteWrapper(query, param) if (result['res'] == 'failed'): return result if (Acts): query = "UPDATE Active_Cases SET Acts = %s WHERE CNRno = %s" param = (Acts, CNRno) result = insertUpdateDeleteWrapper(query, param) if (result['res'] == 'failed'): return result return result
def firmRequest(ClientID, FirmID, Client_Note, Quotation, FilingNo=''): '''CLIENT: insert to lawyer request table''' if (FilingNo): query = 'INSERT INTO Firm_Request (ClientID, FirmID, Client_Note, Quotation, FilingNo) VALUES (%s, %s, %s, %s, %s)' param = (ClientID,FirmID,Client_Note,Quotation,FilingNo) res = insertUpdateDeleteWrapper(query, param) else: query = 'INSERT INTO Firm_Request (ClientID, FirmID, Client_Note, Quotation) VALUES (%s, %s, %s, %s)' param = (ClientID,FirmID,Client_Note,Quotation) res = insertUpdateDeleteWrapper(query, param) return res
def addHearing(CNR, PrevHearing, NextHearing, Purpose): '''OFFICER: Add hearings''' query = "UPDATE Active_Cases SET NextHearing = %s, PrevHearing = %s, Stage = Stage + 1 WHERE CNRno = %s" param = (NextHearing, PrevHearing, CNR) res = insertUpdateDeleteWrapper(query, param) if (res['res'] == 'failed'): return res query = "INSERT into Hearings(Date, CNRno, Prev_date, Purpose) VALUES(%s,%s,%s,%s)" param = (NextHearing, CNR, PrevHearing, Purpose) return insertUpdateDeleteWrapper(query, param)
def fileFIR(FilingNo, InspectorName, Description): '''OFFICER: File FIR''' query = "INSERT into FIR(FilingNo, InspectorName, Description) values(%s,%s,%s)" param = (FilingNo, InspectorName, Description) res = insertUpdateDeleteWrapper(query, param) if (res['res'] == 'failed'): return res query = "UPDATE Pending_Cases SET Fir_Uploaded = 1 WHERE FilingNo = %s" param = (FilingNo, ) return insertUpdateDeleteWrapper(query, param)
def announceVerdict(CNRno, Victim_LawyerID, CaseStmnt, FinalVerdict , WonID_Client, WonID_Lawyer, Accused_LawyerID=None): '''JUDGE: Announce final verdict for a case''' result = viewCase(CNRno) #values extracted from Active_Cases if(result['res'] == 'failed'): return result if(result['arr'][0]['Stage'] == 0): return {'res': 'failed', 'type':'Case is still at Stage 0'} if(not result['arr'][0]['Acts']): return {'res': 'failed', 'type':'No acts given'} if(result['res'] == 'success'): values = result['arr'][0] query = "INSERT INTO Closed_Cases(CNRno, FilingNo, FilingDate, JudgeID, VictimID, Victim_LawyerID, AccusedID, Accused_LawyerID, CaseStmnt, Acts, FinalVerdict, Verdict_Date, WonID_Client, WonID_Lawyer) VALUES (%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,CURDATE(),%s,%s);" param = (CNRno, values['FilingNo'], values['FilingDate'], values['JudgeID'], values['VictimID'], Victim_LawyerID, values['AccusedID'], Accused_LawyerID, CaseStmnt, values['Acts'], FinalVerdict, WonID_Client, WonID_Lawyer,) intermediate_res = insertUpdateDeleteWrapper(query, param) if(intermediate_res['res'] == 'failed'): return intermediate_res if(not Accused_LawyerID): Accused_LawyerID = None query = "SET FOREIGN_KEY_CHECKS = OFF" param = () res = insertUpdateDeleteWrapper(query, param) query = "DELETE from Active_Cases WHERE CNRno=%s" param = (CNRno,) res1 = insertUpdateDeleteWrapper(query, param) query = "SET FOREIGN_KEY_CHECKS = ON" param = () res = insertUpdateDeleteWrapper(query, param) if(res1['res'] == 'failed'): query = "DELETE FROM Closed_Cases WHERE CNRno = %s" param = (CNRno,) temp = insertUpdateDeleteWrapper(query, param) return res1 return intermediate_res return {"res": "failed"}
def addDocument(ClientID, FilingNo, Doc): '''CLIENT: insert Document''' query = 'INSERT INTO Documents (ClientID, FilingNo, Doc) VALUES (%s, %s, %s)' param = (ClientID,FilingNo,Doc) res = insertUpdateDeleteWrapper(query, param) if(res['res'] == 'failed'): return res else: query = 'UPDATE Pending_Cases SET Doc_Uploaded_Victim = 1 WHERE VictimID=%s AND FilingNo=%s' param = (ClientID,FilingNo) res = insertUpdateDeleteWrapper(query, param) if (res['res'] == 'failed'): query = 'UPDATE Pending_Cases SET Doc_Uploaded_Accused = 1 WHERE AccusedID=%s AND FilingNo=%s' param = (ClientID,FilingNo) res = insertUpdateDeleteWrapper(query, param) return res else: return res
def verifyDoc(FilingNo, Type): '''OFFICER: Verify Document''' if (Type == 0): query = "UPDATE Pending_Cases SET is_Verified = 1 WHERE FilingNo = %s AND Doc_Uploaded_Victim = 1" else: query = "UPDATE Pending_Cases SET is_Verified = 1 WHERE FilingNo = %s AND AccusedID IS NOT NULL AND Accused_LawyerID IS NOT NULL AND Fir_Uploaded = 1 AND Doc_Uploaded_Victim = 1 AND Doc_Uploaded_Accused = 1" param = (FilingNo, ) return insertUpdateDeleteWrapper(query, param)
def acceptCase(FilingNo, FirstHearing, CourtNo, JudgeID): '''JUDGE: Accept a pending case''' query = "SELECT * from Pending_Cases where is_Verified = 1 AND FilingNo = %s" param = (FilingNo,) res = selectWrapper(query, param) if(res['res'] == 'failed' or len(res['arr'])==0): return {'res': 'failed', 'type': 'some error occured please recheck param values.'} data = res['arr'][0] #delete from pending cases query = "SET FOREIGN_KEY_CHECKS = OFF" param = tuple() res = insertUpdateDeleteWrapper(query, param) query = "DELETE from Pending_Cases where FilingNo=%s" param = (FilingNo,) result = insertUpdateDeleteWrapper(query, param) query = "SET FOREIGN_KEY_CHECKS = ON" param = tuple() res = insertUpdateDeleteWrapper(query, param) if(result['res'] == 'failed'): return result #add to active cases query = "INSERT into Active_Cases(FilingNo, FilingDate, FirstHearing, NextHearing, CourtNo, JudgeID, VictimID, AccusedID) VALUES(%s,%s,%s,%s,%s,%s,%s,%s)" param = (FilingNo, data['FilingDate'], FirstHearing, FirstHearing, CourtNo, JudgeID, data['VictimID'], data['AccusedID']) result = insertUpdateDeleteWrapper(query, param) if(result['res'] == 'failed'): return result #add to lawyer client query = "SELECT CNRno from Active_Cases where FilingNo = %s" param = (FilingNo,) result = selectWrapper(query, param) if(result['res'] == 'failed'): return result res = result['arr'][0] CNR = res['CNRno'] query = "INSERT into Lawyer_Client(LawyerID, ClientID, CNRno, Side) VALUES(%s,%s,%s,0)" param = (data['Victim_LawyerID'], data['VictimID'], CNR) result = insertUpdateDeleteWrapper(query, param) if(result['res'] == 'failed'): return result if(data['Type'] == 1): query = "INSERT into Lawyer_Client(LawyerID, ClientID, CNRno, Side) VALUES(%s,%s,%s,1)" param = (data['Accused_LawyerID'], data['AccusedID'], CNR) result = insertUpdateDeleteWrapper(query, param) return result
def withdrawCase(Case_ID, VictimID): '''CLIENT: withdraw cases''' query = "SET FOREIGN_KEY_CHECKS = OFF" param = () res1 = insertUpdateDeleteWrapper(query, param) query = 'DELETE FROM Pending_Cases WHERE FilingNo = %s AND VictimID = %s AND is_Verified = 0' param = (Case_ID, VictimID) res = insertUpdateDeleteWrapper(query, param) query = "SET FOREIGN_KEY_CHECKS = ON" param = () res1 = insertUpdateDeleteWrapper(query, param) if(res['res'] == 'failed' and 'err' not in res): if('err' not in res.keys()): query = "SET FOREIGN_KEY_CHECKS = OFF" param = () res1 = insertUpdateDeleteWrapper(query, param) query = 'DELETE FROM Active_Cases WHERE CNRno = %s' param = (Case_ID,) res = insertUpdateDeleteWrapper(query, param) query = "SET FOREIGN_KEY_CHECKS = ON" param = () res1 = insertUpdateDeleteWrapper(query, param) return res return res return res
def recruitLawyer(FirmID, LawyerID): '''FIRM: recruit lawyer''' query = 'UPDATE Lawyers SET FirmID = %s WHERE ID = %s' param = (FirmID, LawyerID) return insertUpdateDeleteWrapper(query, param)
def attachAccusedLawyer(FilingNo, Accused_LawyerID): '''LAWYER: Update attach accused lawyer to pending case''' query = 'UPDATE Pending_Cases SET Accused_LawyerID = %s WHERE FilingNo = %s' param = (Accused_LawyerID, FilingNo) return insertUpdateDeleteWrapper(query, param)
def createPaymentRequest(LawyerID, ClientID, Fee, CNRno): '''LAWYER: Create payment request''' query = 'UPDATE Lawyer_Client SET isRequested = 1, Fee = %s WHERE ClientID = %s AND LawyerID = %s AND CNRno = %s' param = (Fee, ClientID, LawyerID, CNRno) return insertUpdateDeleteWrapper(query, param)
def makePayment(ClientID, LawyerID, CNRno): '''CLIENT: Make Payment''' query = 'UPDATE Lawyer_Client SET isPaid = 1, datePaid = %s WHERE ClientID = %s AND LawyerID = %s AND CNRno = %s' param = (datetime.datetime.now().strftime('%Y-%m-%d'), ClientID, LawyerID, CNRno) return insertUpdateDeleteWrapper(query, param)