def saveOrUpdatePrepareCourse(self):
stageComment = self.params.safeGetStringParam("stageComment")
if stageComment == None or stageComment == "":
self.printer.addMessage(u"请输入讨论内容。")
return self.printer.printMessage(
"manage/course/createPreCourse3.py?prepareCourseId=" +
str(self.prepareCourseId), "")
pcStageStartDate = SimpleDateFormat("yyyy-M-d").parse(stageStartDate)
pcEndDateTime = SimpleDateFormat("yyyy-M-d").parse(stageEndDate)
maxOrder = self.pc_svc.getMaxCourseStageOrderIndex(
self.prepareCourseId)
prepareCourseStage = PrepareCourseStage()
prepareCourseStage.setPrepareCourseId(self.prepareCourseId)
prepareCourseStage.setTitle(stageTitle)
prepareCourseStage.setBeginDate(pcStageStartDate)
prepareCourseStage.setFinishDate(pcEndDateTime)
prepareCourseStage.setDescription(stageDescription)
prepareCourseStage.setOrderIndex(maxOrder + 1)
self.pc_svc.createPrepareCourseStage(prepareCourseStage)
self.printer.addMessage(u"创建 " + prepareCourseStage.title + u" 阶段成功。")
return self.printer.printMessage(
"manage/course/createPreCourse3.py?prepareCourseId=" +
str(self.prepareCourseId), "")
def saveOrUpdatePrepareCourse(self):
if self.prepareCourse == None:
self.prepareCourse = PrepareCourse()
self.prepareCourse.setPrepareCoursePlanId(self.prepareCoursePlan.prepareCoursePlanId)
else:
# 只有admin 和 主备人进行修改
if not(self.accessControlService.isSystemAdmin(self.loginUser) or self.loginUser.userId == self.prepareCourse.createUserId ):
self.printer.msg = u"只有 admin 或者创建人、主备人才能进行修改。<br/><br/><a href='createPreCourse.py'>返回</a>"
return self.printer.printError()
pcTitle = self.params.safeGetStringParam("pcTitle")
pcStartDate = self.params.safeGetStringParam("pcStartDate")
pcEndDate = self.params.safeGetStringParam("pcEndDate")
pcGradeId = self.params.getIntParamZeroAsNull("pcGrade")
pcMetaSubjectId = self.params.getIntParamZeroAsNull("pcMetaSubject")
pcDescription = self.params.safeGetStringParam("pcDescription")
pcLeader = self.params.safeGetIntParam("pcLeader")
pcTags = self.params.safeGetStringParam("pcTags")
if pcLeader == 0:
user_leader = self.loginUser
else:
user_leader = self.user_svc.getUserById(pcLeader)
if user_leader == None:
self.printer.msg = u"该用户不存在。<br/><br/><a href='createPreCourse.py'>返回</a>"
return self.printer.printError()
if pcGradeId == None or pcGradeId == 0:
self.printer.msg = u"你必须选择一个学段。"
return self.printer.printError()
if pcMetaSubjectId == None or pcMetaSubjectId == 0:
self.printer.msg = u"你必须选择一个学科。"
return self.printer.printError()
pcStartDateTime = SimpleDateFormat("yyyy-MM-dd").parse(pcStartDate)
pcEndDateTime = SimpleDateFormat("yyyy-MM-dd").parse(pcEndDate)
self.prepareCourse.setTitle(pcTitle)
self.prepareCourse.setStartDate(pcStartDateTime)
self.prepareCourse.setEndDate(pcEndDateTime)
self.prepareCourse.setDescription(pcDescription)
self.prepareCourse.setMetaSubjectId(int(pcMetaSubjectId))
self.prepareCourse.setGradeId(int(pcGradeId))
self.prepareCourse.setCreateUserId(self.loginUser.userId)
self.prepareCourse.setCreateDate(Date())
self.prepareCourse.setLockedDate(Date())
self.prepareCourse.setLeaderId(user_leader.getUserId())
self.prepareCourse.setLockedUserId(0)
self.prepareCourse.setPrepareCourseEditId(0)
self.prepareCourse.setTags(pcTags)
if self.prepareCourseId > 0:
self.pc_svc.updatePrepareCourse(self.prepareCourse)
self.printer.msg = u"您的 <span style='color:#f00'>" + pcTitle + u"</span> 修改成功。<br/><br/><a href='showPrepareCourse.py?prepareCourseId=" + str(self.prepareCourse.prepareCourseId) + "'>返回</a>"
return self.printer.printError()
else:
self.pc_svc.createPrepareCourse(self.prepareCourse)
self.printer.msg = u"您的 <span style='color:#f00'>" + pcTitle + u"</span> 创建成功。<br/><br/><a href='showPrepareCourse.py?prepareCourseId=" + str(self.prepareCourse.prepareCourseId) + "'>返回</a>"
return self.printer.printError()
def applyWhereCondition(self, qctx):
#print "--self.subjectId="+str(self.subjectId)
if self.enabled != None:
qctx.addAndWhere("ev.enabled = :enabled")
qctx.setBoolean("enabled", self.enabled)
if self.ValidPlan == True:
nowDate = SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime())
qctx.addAndWhere("(:nowDate >= ev.startDate) And (:nowDate <= ev.endDate)")
qctx.setString("nowDate", nowDate)
qctx.setString("nowDate", nowDate)
if self.title !=None :
newKey = self.title.replace("%","[%]").replace("_","[_]").replace("[","[[]")
qctx.addAndWhere("ev.evaluationCaption LIKE :title")
qctx.setString("title", "%" + newKey + "%")
if self.subjectId != None:
qctx.addAndWhere("ev.metaSubjectId = :subjectId")
qctx.setInteger("subjectId", self.subjectId)
if self.gradeId != None:
qctx.addAndWhere("ev.metaGradeId = :gradeId")
qctx.setInteger("gradeId", self.gradeId)
if self.teacherName != None:
tName = self.teacherName.replace("%","[%]").replace("_","[_]").replace("[","[[]")
qctx.addAndWhere("ev.teacherName LIKE :teacherName")
qctx.setString("teacherName", "%" + tName +"%")
if self.listType == 0:
#已经完成的评课
nowDate = SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime())
qctx.addAndWhere(":nowDate > ev.endDate")
qctx.setString("nowDate", nowDate)
if self.userId>0:
qctx.addAndWhere("ev.teacherId = :userId")
qctx.setInteger("userId", self.userId)
elif self.listType == 1:
#进行中的评课
nowDate = SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(Calendar.getInstance().getTime())
qctx.addAndWhere("(:nowDate >= ev.startDate) And (:nowDate <= ev.endDate)")
qctx.setString("nowDate", nowDate)
qctx.setString("nowDate", nowDate)
if self.userId>0:
qctx.addAndWhere("ev.teacherId = :userId")
qctx.setInteger("userId", self.userId)
elif self.listType == 2:
#我发起的评课
qctx.addAndWhere("ev.createrId=:userId")
qctx.setInteger("userId", self.userId)
elif self.listType == 3:
#我参与的评课
qctx.addAndWhere(" ev.evaluationPlanId IN(SELECT ec.evaluationPlanId FROM EvaluationContent as ec WHERE ec.publishUserId=:userId)")
qctx.setInteger("userId", self.userId)
def show_action_edit(self):
now = Date()
sdf = SimpleDateFormat("yyyy")
year = int(sdf.format(now))
sdf = SimpleDateFormat("M")
month = int(sdf.format(now))
sdf = SimpleDateFormat("d")
day = int(sdf.format(now))
request.setAttribute("default_year", year)
request.setAttribute("default_month", month)
request.setAttribute("default_day", day)
return "/WEB-INF/ftl/course/show_preparecourse_action_create.ftl"
def getQuery(self):
sql = "Select dp From DocumentPosition dp Where (dp.debitZpk.id = :did or dp.creditZpk.id = :cid) and dp.bookingPeriod.defaultPeriod = 1 and dp.createdAt >= :from and dp.createdAt <= :to Order By dp.createdAt ASC"
query = self._entityManager.createQuery(sql)
query.setParameter("did", self._zpk.getId())
query.setParameter("cid", self._zpk.getId())
query.setParameter("from",
SimpleDateFormat('dd-MM-yyyy').parse(self._from),
TemporalType.DATE)
query.setParameter("to",
SimpleDateFormat('dd-MM-yyyy').parse(self._to),
TemporalType.DATE)
return query
def editPrepareCourseStage(self):
prepareCourseStageId = self.params.getIntParam("prepareCourseStageId")
if prepareCourseStageId > 0:
prepareCourseStage = self.pc_svc.getPrepareCourseStage(
prepareCourseStageId)
if prepareCourseStage == None:
errDesc = u"加载备课流程失败。"
response.getWriter().write(errDesc)
return
else:
errDesc = u"无效的标识。"
response.getWriter().write(errDesc)
return
stageTitle = self.params.safeGetStringParam("stageTitle")
stageStartDate = self.params.safeGetStringParam("stageStartDate")
stageEndDate = self.params.safeGetStringParam("stageEndDate")
stageDescription = self.params.getStringParam("stageDescription")
stageOrderIndex = self.params.getIntParam("stageOrderIndex")
if stageTitle == None or stageTitle == "":
errDesc = u"请输入一个流程名。<a href='#' onclick='window.history.back();return false;'>返回</a>"
response.getWriter().write(errDesc)
return
if stageStartDate == None or stageStartDate == "":
errDesc = u"请输入一个开始日期。<a href='#' onclick='window.history.back();return false;'>返回</a>"
response.getWriter().write(errDesc)
return
if stageEndDate == None or stageEndDate == "":
errDesc = u"请输入一个结束日期。<a href='#' onclick='window.history.back();return false;'>返回</a>"
response.getWriter().write(errDesc)
return
stageStartDate = stageStartDate.replace("—", "-")
stageEndDate = stageEndDate.replace("—", "-")
pcStageStartDate = SimpleDateFormat("yyyy-MM-dd").parse(stageStartDate)
pcEndDate = SimpleDateFormat("yyyy-MM-dd").parse(stageEndDate)
if DateUtil.compareDateTime(pcStageStartDate, pcEndDate) > 0:
errDesc = u"结束时间不能早于开始时间。<a href='#' onclick='window.history.back();return false;'>返回</a>"
response.getWriter().write(errDesc)
return
prepareCourseStage.setTitle(stageTitle)
prepareCourseStage.setBeginDate(pcStageStartDate)
prepareCourseStage.setFinishDate(pcEndDate)
prepareCourseStage.setDescription(stageDescription)
prepareCourseStage.setOrderIndex(stageOrderIndex)
self.pc_svc.updatePrepareCourseStage(prepareCourseStage)
errDesc = u"修改 " + prepareCourseStage.title + u" 流程成功。"
response.getWriter().write(errDesc)
return
def dateformat(t, format, language=None):
"""
Format python date to string using Java SimpleDateFormat.
:param t: Python date.
:returns: Format string of the date
"""
jt = jdate(t)
if language is None:
df = SimpleDateFormat(format)
else:
locale = Locale(language)
df = SimpleDateFormat(format, locale)
return df.format(jt)
def process_record(self):
content = {}
self.set_from_task_vars('u_request', content)
self.set_from_task_vars('u_application_name', content)
self.set_from_task_vars('cmdb_ci', content)
self.set_from_task_vars('priority', content)
self.set_from_task_vars('state', content)
self.set_from_task_vars('assignment_group', content)
self.set_from_task_vars('assigned_to', content)
self.set_from_task_vars('due_date', content)
self.set_from_task_vars('short_description', content)
self.set_from_task_vars('description', content)
# Dates need to be converted
sdf = SimpleDateFormat("MM-dd-yyyy HH:mm:ss")
content['due_date'] = sdf.format(self.task_vars['due_date'])
# Also sending release info.
content['x_xlbv_xl_release_identifier'] = str(release.id)
content['x_xlbv_xl_release_state'] = str(release.status)
logger.debug('process_record : send create_record request...')
logger.debug('process_record : table name: ' + self.table_name)
logger.debug('process_record : content... ')
logger.debug(content)
response = self.sn_client.create_record(self.table_name, content,
getCurrentTask().getId())
logger.debug('process_record : response...')
logger.debug(response)
return response
def __newDoc(self):
self.oid = self.object.getId()
self.pid = self.payload.getId()
metadataPid = self.params.getProperty("metaPid", "DC")
self.utils.add(self.index, "storage_id", self.oid)
if self.pid == metadataPid:
self.itemType = "object"
else:
self.oid += "/" + self.pid
self.itemType = "datastream"
self.utils.add(self.index, "identifier", self.pid)
self.utils.add(self.index, "id", self.oid)
self.utils.add(self.index, "item_type", self.itemType)
self.utils.add(self.index, "last_modified", self.last_modified)
self.utils.add(self.index, "harvest_config",
self.params.getProperty("jsonConfigOid"))
self.utils.add(self.index, "harvest_rules",
self.params.getProperty("rulesOid"))
self.item_security = []
self.owner = self.params.getProperty("owner", "guest")
formatter = SimpleDateFormat('yyyyMMddHHmmss')
self.params.setProperty("last_modified", formatter.format(Date()))
self.utils.add(self.index, "date_object_created",
self.params.getProperty("date_object_created"))
self.params.setProperty(
"date_object_modified",
time.strftime("%Y-%m-%dT%H:%M:%SZ", time.localtime()))
self.utils.add(self.index, "date_object_modified",
self.params.getProperty("date_object_modified"))
def processCertInfo():
certInfo = {}
dtFormat = SimpleDateFormat("E MMM dd HH:mm:ss yyyy")
logFile = open("logs/cert.log", "w")
for line in open('logs/expiringCerts.txt'):
if 'App Stripe' in line:
certInfo['appStripe'] = line.split('=')[1].strip()
if 'Keystore' in line:
certInfo['keystore'] = line.split('=')[1].strip()
if 'Alias' in line:
certInfo['alias'] = line.split('=')[1].strip()
if 'Certificate status' in line:
certInfo['status'] = line.split('=')[1].strip()
if 'Expiration Date' in line: #Expiration Date record marks the end of certificate info. Below block processes currrent cert.
certInfo['expiryDt'] = line.split('=')[1].strip()
expiryDtFmtd = str(certInfo['expiryDt']).replace(
"UTC ",
"") # Removes UTC from date string to build date object.
expiryDtObj = dtFormat.parse(expiryDtFmtd)
currDtObj = Date() #Get current date.
timeDiff = expiryDtObj.getTime() - currDtObj.getTime()
daysBetween = (timeDiff / (1000 * 60 * 60 * 24))
if daysBetween >= 0 and daysBetween <= int(
alertDays
) and certInfo['keystore'] in keystoresList and certInfo[
'alias'] not in certAliasExcptList: #Only concerned about keystores mentioned in the properties file.
logFile.write("Certificate in app stripe \"" +
certInfo['appStripe'] + "\" and keystore \"" +
certInfo['keystore'] + "\" with alias name \"" +
certInfo['alias'] + "\" is expiring on " +
certInfo['expiryDt'] + "\n")
logFile.write("\n")
certInfo = {}
logFile.close()
def __init__(self, selectFields):
BaseQuery.__init__(self, selectFields)
self.params = ParamUtil(request)
self.prepareCourseId = None
self.createUserId = None
self.k = self.params.getStringParam("k") #查询关键字
self.ktype = self.params.getStringParam("ktype") #查询类型[关键字对应的类型]
if self.ktype == None:
self.ktype = "1" #默认关键字查询标题
self.unit = self.params.getStringParam("unit") #主备人所属机构
self.course_BeginDate = self.params.getStringParam("course_BeginDate")
self.course_EndDate = self.params.getStringParam("course_EndDate")
self.subjectId = self.params.getIntParamZeroAsNull("subjectId")
self.gradeId = self.params.getIntParamZeroAsNull("gradeId")
request.setAttribute("subjectId", self.subjectId)
request.setAttribute("gradeId", self.gradeId)
request.setAttribute("k", self.k)
request.setAttribute("ktype", self.ktype)
request.setAttribute("unit", self.unit)
request.setAttribute("course_BeginDate", self.course_BeginDate)
request.setAttribute("course_EndDate", self.course_EndDate)
self.orderType = 0
self.status = None
self.stage = None #集备执行的阶段，正在进行running；已经完成finishaed；还未进行will ;recommend 推荐的
self.containChild = None #准确学科的查询
self.prepareCoursePlanId = None
self.prepareCourseGenerated = True
self.custormAndWhere = None #自定义条件查询
sft = SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
self.nowDate = sft.format(Date())
def flowFileDates(hmsRunName):
#will not be accurate if there is more than one set of data--specify start date in config file?
"""Find the dates of any FLOW files in the DSS catalog"""
from java.text import SimpleDateFormat
dateFormat = SimpleDateFormat("ddMMMyyyy")
print("Getting dates from " + hmsRunName + "...")
dates = []
#print(dss.getCatalogedPathnames())
flowFiles = filter(
lambda f:
((f.split('/')[3] == 'FLOW') and (f.split('/')[6] ==
('RUN:' + hmsRunName.upper()))),
dss.getCatalogedPathnames())
#print(flowFiles)
candidateDates = map(lambda x: x.split('/')[4], flowFiles)
#print(candidateDates)
for d in candidateDates:
if d[0:2].isdigit() and d[2:5].isalpha() and d[5:9].isdigit():
date = dateFormat.parse(d)
dateAlreadyFound = any(lambda x: x.equals(date), dates)
if not dateAlreadyFound:
dates.append(date)
dates.sort(lambda a, b: a.compareTo(b))
return map(lambda d: dateFormat.format(d).upper(), dates)
def save_post(self):
st = self.params.safeGetStringParam("st")
if st == "":
self.addActionError(u"请输入专题标题。")
return ActionResult.ERROR
so = self.params.safeGetStringParam("so")
sd = self.params.safeGetStringParam("sd")
se = self.params.safeGetStringParam("se")
expire_date = Date()
try:
expire_date = SimpleDateFormat("yyyy-MM-dd").parse(se)
except:
actionErrors = [u"输入的日期格式不正确，应当是: '年年年年-月月-日日' 格式"]
request.setAttribute("actionErrors", actionErrors)
return self.ERROR
specialSubject = SpecialSubject()
specialSubject.setTitle(st)
if so != "":
specialSubject.setLogo(so)
if sd != "":
specialSubject.setDescription(sd)
specialSubject.setObjectType("system")
specialSubject.setObjectId(0)
specialSubject.setCreateDate(Date())
specialSubject.setCreateUserId(self.loginUser.userId)
specialSubject.setExpiresDate(expire_date)
self.specialSubject_svc.saveOrUpdateSpecialSubject(specialSubject)
return ActionResult.SUCCESS
def stringToDate(value):
"""
Information about how to build your own date pattern is here:
http://java.sun.com/j2se/1.5.0/docs/api/java/text/SimpleDateFormat.html
"""
dateFormat = SimpleDateFormat("dd MMM yyyy HH:mm")
return dateFormat.parse(value)
def change_view(self):
self.vlayout.removeAllViews()
self.vlayout.addView(self.text_result)
calendar = Calendar.getInstance()
dateformat = SimpleDateFormat('yyyy / MM / dd')
now = dateformat.format(calendar.getTime())
self.text_result.setText(now)
def chargePossession(self, possession):
if not self.alreadyCharged(possession) and possession.getElements().size() > 0:
self._logger.info("Charging possession: %d" % possession.getId())
self._svars.put("communityId", possession.getCommunity().getId())
charging = self.initDocument(self._type)
charging.setPossession(possession)
charging.putAttribute("CREATE_DATE", str(SimpleDateFormat('dd-MM-yyyy').format(charging.getCreatedAt())))
for possessionElement in possession.getElements():
element = possessionElement.getElement()
element.setGlobalValue(self.discoverValue(possessionElement))
self._svars.put("value", str(self._calculator.calculate(element, possession)))
chargingPosition = self.initPosition(charging)
chargingPosition.setDescription(possessionElement.getElement().getName())
chargingPosition.putAttribute("ELEMENT_GROUP_ID", str(possessionElement.getElement().getGroup().getId()))
chargingPosition.putAttribute("ELEMENT_GROUP_NAME", str(possessionElement.getElement().getGroup().getValue()))
if self.isRepairFundElement(element):
chargingPosition.setCreditZpk(self.findZpk(charging.getCommunity().getZpks(), 'CHARGING_RENT'))
chargingPosition.setDebitZpk(self.findZpk(possession.getZpks(), 'POSSESSION'))
else:
chargingPosition.setCreditZpk(self.findZpk(charging.getCommunity().getZpks(), 'CHARGING_REPAIR_FUND'))
chargingPosition.setDebitZpk(self.findZpk(possession.getZpks(), 'POSSESSION_REPAIR_FUND'))
self.bound(charging, chargingPosition)
return self.saveDocument(charging)
else:
self._logger.info("Possession %d omitted, reason:" % possession.getId())
self._logger.info("Already charged: %s" % str(self.alreadyCharged(possession)))
self._logger.info("Elements: %d" % possession.getElements().size())
def __activate__(self, context):
self.auth = context["page"].authentication
self.errorMsg = ""
self.request = context["request"]
self.response = context["response"]
self.fromDtTxt = self.request.getParameter("from")
self.toDtTxt = self.request.getParameter("to")
self.reportName = self.request.getParameter("reportName")
self.dateFormatter = SimpleDateFormat("d/M/yyyy")
self.systemConfig = context["systemConfig"]
if (self.fromDtTxt is None or self.toDtTxt is None):
curCal = Calendar.getInstance()
self.fromDtTxt = "1/1/%s" % curCal.get(Calendar.YEAR)
self.toDtTxt = "%s/%s/%s" % (curCal.get(Calendar.DAY_OF_MONTH), curCal.get(Calendar.MONTH)+1,curCal.get(Calendar.YEAR))
if (self.reportName is None):
self.reportName = "Dashboard Report"
if (self.auth.is_logged_in()):
if (self.auth.is_admin()==True):
self.action = self.request.getParameter("action")
if self.action == "export":
self.exportDashboard(context)
else:
self.buildDashboard(context)
else:
self.errorMsg = "Requires Admin / Librarian / Reviewer access."
else:
self.errorMsg = "Please login."
def hbase_setupjob(job, args):
"""
Set up a job to run on telemetry date ranges using data from HBase
Telemetry jobs expect two arguments, startdate and enddate, both in yyyymmdd format.
"""
import java.text.SimpleDateFormat as SimpleDateFormat
import java.util.Calendar as Calendar
import com.mozilla.hadoop.hbase.mapreduce.MultiScanTableMapReduceUtil as MSTMRU
import com.mozilla.util.Pair
if len(args) != 2:
raise Exception("Usage: <startdate-YYYYMMDD> <enddate-YYYYMMDD>")
sdf = SimpleDateFormat(dateformat)
startdate = Calendar.getInstance()
startdate.setTime(sdf.parse(args[0]))
enddate = Calendar.getInstance()
enddate.setTime(sdf.parse(args[1]))
columns = [com.mozilla.util.Pair('data', 'json')]
scans = MSTMRU.generateBytePrefixScans(startdate, enddate, dateformat,
columns, 500, False)
MSTMRU.initMultiScanTableMapperJob('telemetry', scans, None, None, None,
job)
# inform HadoopDriver about the columns we expect to receive
job.getConfiguration().set("org.mozilla.jydoop.hbasecolumns", "data:json")
def create_sale(self, sale):
values = ContentValues()
values.put("person", sale['person'].lower())
values.put("total", sale['value'])
values.put("description", sale['description'].replace('\n',
' ').lower())
values.put("paid", sale['paid'])
calendar = Calendar.getInstance()
dateformat = SimpleDateFormat('yyyy/MM/dd HH:mm')
now = dateformat.format(calendar.getTime())
values.put("date", now)
db = self.getWritableDatabase()
db.insertWithOnConflict("sale", None, values,
SQLiteDatabase.CONFLICT_REPLACE)
#remove quantity from products
products = sale['description'].split('\n')
for product in products:
name, quantity = product.split(':')
quantity = int(quantity)
db.execSQL(
"UPDATE product SET quantity = quantity - %d WHERE name='%s'" %
(quantity, name))
db.close()
def btnGuardar_click(self, *e):
fechaDeCierre = self.fechaPicker.get()
if fechaDeCierre != None:
fechaDeCierre = SimpleDateFormat("dd/MM/yyyy").format(
fechaDeCierre)
self.workspace.set('CEGESEV.accidentes.fecha_de_cierre', fechaDeCierre)
self.hide()
def cardSave(context,
main=None,
add=None,
filterinfo=None,
session=None,
elementId=None,
xformsdata=None):
u'''Сохранение карточки. '''
exam_cur = ExampleCursor(context)
xformsdata = json.loads(xformsdata)['schema']['context']
if add == 'add':
exam_cur.guid = str(uuid.uuid4())
exam_cur.first_column = None if xformsdata[
'first_column'] == "" else xformsdata['first_column']
exam_cur.second_column = None if xformsdata[
'second_column'] == "" else xformsdata['second_column']
exam_cur.third_column = None if xformsdata[
'third_column'] == "" else xformsdata['third_column']
exam_cur.fourth_column = True if xformsdata[
'fourth_column'] == 'true' else False
exam_cur.fifth_column = None if xformsdata[
'fifth_column'] == "" else SimpleDateFormat("yyyy-MM-dd").parse(
xformsdata['fifth_column'])
if add == 'add':
exam_cur.insert()
def getCreateDate(self, document):
if document.getAttribute("CREATE_DATE") != None:
return document.getAttribute("CREATE_DATE").getValue()
for position in document.getPositions():
if position.getAttribute("CREATE_DATE") != None:
return position.getAttribute("CREATE_DATE").getValue()
return str(
SimpleDateFormat('dd-MM-yyyy').format(document.getCreatedAt()))
def _parseStartDate(self, date):
r'@types: str -> java.util.Date or None'
try:
dateFormat = SimpleDateFormat("HHmmss yyyyMMdd")
return dateFormat.parse(date)
except:
logger.warnException('Failed to convert start date: %s'
' to HHmmss yyyyMMdd' % date)
def __init__(self, name, value):
self._name = name
if not value:
self._value = value
else:
if len(value) == 10:
# date format
parsed_value = SimpleDateFormat('yyyy-MM-dd').parse(value)
else:
# assume datetime format
# remove microseconds if necessary
if len(value) == 27:
value = '%sZ' % value[:19]
sdf = SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss'Z'")
sdf.setTimeZone(TimeZone.getTimeZone("UTC"))
parsed_value = sdf.parse(value)
self._value = parsed_value
def parse_time(time):
r'@types: str->java.util.Date or None'
try:
from java.text import SimpleDateFormat
s = SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
return s.parse(time)
except:
logger.debug('Failed to parse time: %s' % time)
def editPrepareCourseStage(self):
prepareCourseStageId = self.params.getIntParam("prepareCourseStageId")
if prepareCourseStageId > 0:
prepareCourseStage = self.pc_svc.getPrepareCourseStage(
prepareCourseStageId)
if prepareCourseStage == None:
operation_result = u"加载备课流程失败。"
request.setAttribute("operation_result", operation_result)
return "/WEB-INF/ftl/course/show_preparecourse_ok_info.ftl"
else:
operation_result = u"无效的标识。"
request.setAttribute("operation_result", operation_result)
return "/WEB-INF/ftl/course/show_preparecourse_ok_info.ftl"
stageTitle = self.params.safeGetStringParam("stageTitle")
stageStartDate = self.params.safeGetStringParam("stageStartDate")
stageEndDate = self.params.safeGetStringParam("stageEndDate")
stageDescription = self.params.getStringParam("stageDescription")
stageOrderIndex = self.params.getIntParam("stageOrderIndex")
if stageTitle == None or stageTitle == "":
operation_result = u"请输入一个流程名。"
request.setAttribute("operation_result", operation_result)
return "/WEB-INF/ftl/course/show_preparecourse_ok_info.ftl"
if stageStartDate == None or stageStartDate == "":
operation_result = u"请输入一个开始日期。"
request.setAttribute("operation_result", operation_result)
return "/WEB-INF/ftl/course/show_preparecourse_ok_info.ftl"
if stageEndDate == None or stageEndDate == "":
operation_result = u"请输入一个结束日期。"
request.setAttribute("operation_result", operation_result)
return "/WEB-INF/ftl/course/show_preparecourse_ok_info.ftl"
pcStageStartDate = SimpleDateFormat("yyyy-MM-dd").parse(stageStartDate)
pcEndDateTime = SimpleDateFormat("yyyy-MM-dd").parse(stageEndDate)
prepareCourseStage.setTitle(stageTitle)
prepareCourseStage.setBeginDate(pcStageStartDate)
prepareCourseStage.setFinishDate(pcEndDateTime)
prepareCourseStage.setDescription(stageDescription)
prepareCourseStage.setOrderIndex(stageOrderIndex)
self.pc_svc.updatePrepareCourseStage(prepareCourseStage)
operation_result = u"修改 " + prepareCourseStage.title + " 流程成功。"
request.setAttribute("operation_result", operation_result)
return "/WEB-INF/ftl/course/show_preparecourse_ok_info.ftl"
def editPrepareCourseStage(self):
prepareCourseStageId = self.params.getIntParam("prepareCourseStageId")
if prepareCourseStageId > 0:
prepareCourseStage = self.pc_svc.getPrepareCourseStage(prepareCourseStageId)
if prepareCourseStage == None:
errDesc = u"加载备课流程失败。<br /><br /><a href='createPreCourse3.py?prepareCourseId=" + str(self.prepareCourseId) + "'>返回</a>"
self.printer.msg = errDesc
return self.printer.printError()
else:
errDesc = u"无效的标识。<br /><br /><a href='createPreCourse3.py?prepareCourseId=" + str(self.prepareCourseId) + "'>返回</a>"
self.printer.msg = errDesc
return self.printer.printError()
stageTitle = self.params.safeGetStringParam("stageTitle")
stageStartDate = self.params.safeGetStringParam("stageStartDate")
stageEndDate = self.params.safeGetStringParam("stageEndDate")
stageDescription = self.params.getStringParam("stageDescription")
stageOrderIndex = self.params.getIntParam("stageOrderIndex")
if stageTitle == None or stageTitle == "":
errDesc = u"请输入一个流程名。<br /><br /><a href='createPreCourse3.py?prepareCourseId=" + str(self.prepareCourseId) + "'>返回</a>"
self.printer.msg = errDesc
return self.printer.printError()
if stageStartDate == None or stageStartDate == "":
errDesc = u"请输入一个开始日期。<br /><br /><a href='createPreCourse3.py?prepareCourseId=" + str(self.prepareCourseId) + "'>返回</a>"
self.printer.msg = errDesc
return self.printer.printError()
if stageEndDate == None or stageEndDate == "":
errDesc = u"请输入一个结束日期。<br /><br /><a href='createPreCourse3.py?prepareCourseId=" + str(self.prepareCourseId) + "'>返回</a>"
self.printer.msg = errDesc
return self.printer.printError()
pcStageStartDate = SimpleDateFormat("yyyy-MM-dd").parse(stageStartDate)
pcEndDateTime = SimpleDateFormat("yyyy-MM-dd").parse(stageEndDate)
prepareCourseStage.setTitle(stageTitle)
prepareCourseStage.setBeginDate(pcStageStartDate)
prepareCourseStage.setFinishDate(pcEndDateTime)
prepareCourseStage.setDescription(stageDescription)
prepareCourseStage.setOrderIndex(stageOrderIndex)
self.pc_svc.updatePrepareCourseStage(prepareCourseStage)
errDesc = u"修改 " + prepareCourseStage.title + u" 流程成功。<br /><br /><a href='createPreCourse3.py?prepareCourseId=" + str(self.prepareCourseId) + "'>返回</a>"
self.printer.msg = errDesc
return self.printer.printError()
def getVigentStretchesQuery(store, fecha):
#query = getCarreterasManager().getVigentStretchesQuery(store, fecha)
dateFormatter = SimpleDateFormat("dd/MM/yyyy")
formatedDate = dateFormatter.format(fecha)
filtro = "( fecha_entrada <= '%s' OR fecha_entrada IS NULL) AND ('%s' <= fecha_salida OR fecha_salida IS NULL)" % (
formatedDate, formatedDate)
query = store.createFeatureQuery()
query.addFilter(filtro)
return query
def getDate(self):
calendar = GregorianCalendar()
date = calendar.getTime()
dayFormat = SimpleDateFormat("dd")
monthFormat = SimpleDateFormat("MM")
yearFormat = SimpleDateFormat("yyyy")
DAY = int(dayFormat.format(date))
MONTH = int(monthFormat.format(date))
YEAR = int(yearFormat.format(date))
if MONTH < 10:
TEMP1 = "%d0%d" % (YEAR, MONTH)
else:
TEMP1 = "%d%d" % (YEAR, MONTH)
if DAY < 10:
CURRENTDATE = "%d0%d" % (TEMP1, DAY)
else:
CURRENTDATE = "%d%d" % (TEMP1, DAY)
return CURRENTDATE
def __init__(self, selectFields):
BaseQuery.__init__(self, selectFields)
self.params = ParamUtil(request)
self.prepareCourseId = None
self.userId = None
self.privateContentExist = None #是否只显示有内容的个案 默认None,全部显示 True,查询有内容的,False 查询无内容的
self.stage = None #集备执行的阶段，正在进行running；已经完成finishaed；还未进行will
sft = SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
self.nowDate = sft.format(Date())
