def exportToExcel(self, rowdata):
key = [
'id', 'create_time', 'update_time', 'create_id', 'update_id',
'msg_list_id', 'sender_type', 'sender_name', 'sender_code',
'send_date', 'send_time', 'sender_addr', 'receiver_type',
'receiver_name', 'receiver_code', 'receive_date', 'receive_time',
'receiver_addr', 'message_type', 'message_sn', 'content_type',
'bin_content', 'text_content', 'send_status'
]
messageList = []
for i, item in enumerate(rowdata):
messageInfo = dict(zip(key, item))
messageList.append(messageInfo)
cur = self.db.getCursor()
utils.getDataDict(cur, messageList, "send_status",
"PROGRAM_SEND_STATUS", "send_status_name")
utils.getDataDict(cur, messageList, "message_type",
"MSG_TYPE_CONTROLLER", "message_type_name")
data = []
sn = 1
for item in messageList:
if 'send_status_name' not in item:
item['send_status_name'] = "未发送"
if 'apply_status_name' not in item:
item['apply_status_name'] = "未提交"
itemData = []
itemData.append(sn)
sn = sn + 1
itemData.append(messageInfo['sender_name'])
itemData.append(messageInfo['send_date'])
itemData.append(messageInfo['send_time'])
itemData.append(messageInfo['receiver_name'])
itemData.append(messageInfo['receive_date'])
itemData.append(messageInfo['receive_time'])
itemData.append(messageInfo['message_type'])
itemData.append(messageInfo['message_sn'])
itemData.append(messageInfo['text_content'])
data.append(itemData)
struct = "SN, 发送方名称, 发送日期, 发送时间, 接收方名称, 接收日期, 接收时间, 消息类别, 消息序号, 消息正文"
path = {}
path = excel.createTempFile("xls")
excel.saveExcel(path['path'], struct, data)
logInfo = " %s 下载了消息发送详单 " % self.objUserInfo['name']
operation_log(self.db).addLog(self.GetUserInfo(), "messageManage",
logInfo, 0)
self.response(path)
def exportToExcel(self, rowdata):
key = [
'id', 'create_time', 'update_time', 'create_id', 'update_id',
'code', 'name', 'valid_date', 'apply_id', 'apply_name',
'apply_date', 'checker_id', 'checker_name', 'check_date',
'apply_status', 'video_type', 'sender_id', 'sender_name',
'send_date', 'send_time', 'send_status'
]
messageList = []
for i, item in enumerate(rowdata):
messageInfo = dict(zip(key, item))
messageList.append(messageInfo)
cur = self.db.getCursor()
utils.getDataDict(cur, messageList, "send_status",
"PROGRAM_SEND_STATUS", "send_status_name")
utils.getDataDict(cur, messageList, "apply_status",
"PROGRAM_APPLY_STATUS", "apply_status_name")
data = []
sn = 1
for item in messageList:
if 'send_status_name' not in item:
item['send_status_name'] = "未发送"
if 'apply_status_name' not in item:
item['apply_status_name'] = "未提交"
itemData = []
itemData.append(sn)
sn = sn + 1
itemData.append(item['name']) # 节目单名称
itemData.append(item['valid_date']) # 生效日期
itemData.append(item['apply_name']) # 申请人姓名
itemData.append(item['apply_date']) # 申请日期
itemData.append(item['checker_name'])
itemData.append(item['check_date']) # 审核日期
itemData.append(item['apply_status_name']) # 申请状态
itemData.append(item['sender_name']) # 发送人姓名
itemData.append(item['send_date']) # 发送日期
itemData.append(item['send_time']) # 发送日期
itemData.append(item['send_status_name']) # 发送状态
data.append(itemData)
struct = "SN, 节目单名称, 生效日期, 申请人姓名, 申请日期, 审核人姓名, 审核日期, 申请状态, 发送者姓名, 发送日期, 发送时间, 发送状态"
path = {}
path = excel.createTempFile("xls")
excel.saveExcel(path['path'], struct, data)
logInfo = " %s 下载了节目单清单 " % self.objUserInfo['name']
operation_log(self.db).addLog(self.GetUserInfo(), "listManage",
logInfo, 0)
self.response(path)
def exportToExcel(self, rowdata):
key = ['id', 'operation_id1', 'operation_id2', 'message_type', 'content', 'sender_id', 'sender_name', 'send_date', 'send_time', 'send_status']
messageList = []
for i, item in enumerate(rowdata):
messageInfo = dict(zip(key, item))
messageList.append(messageInfo)
cur = self.db.getCursor()
utils.getDataDict(cur, messageList, "send_status", "PROGRAM_SEND_STATUS", "send_status_name")
utils.getDataDict(cur, messageList, "message_type", "MESSAGE_TYPE", "message_type_name")
data = []
sn = 1
for messageInfo in messageList:
itemData = []
itemData.append( sn )
sn = sn + 1
itemData.append( messageInfo['sender_name'] )
itemData.append( messageInfo['send_date'] )
itemData.append( messageInfo['send_time'])
itemData.append( messageInfo['message_type_name'] )
itemData.append( messageInfo['content'] )
itemData.append( messageInfo['send_status_name'] )
data.append(itemData)
struct = "SN, 发送方名称, 发送日期, 发送时间, 消息类别, 消息正文, 发送状态"
path = {}
path = excel.createTempFile("xls")
excel.saveExcel(path['path'], struct, data )
logInfo = " %s 下载了消息清单 "%self.objUserInfo['name']
operation_log(self.db).addLog(self.GetUserInfo(), "messageListManage", logInfo, 0)
self.response(path)
def exportToExcel(self, rowdata):
key = [
'id', 'name', 'code', 'serial_no', 'device_type', 'vendor',
'mac_addr', 'install_date', 'install_batch', 'install_type',
'install_id', 'status', 'addr'
]
moduleList = []
for i, item in enumerate(rowdata):
logInfo = dict(zip(key, item))
moduleList.append(logInfo)
cur = self.db.getCursor()
utils.getDataDict(cur, moduleList, "device_type",
"GPS_MODULE_DEVICE_TYPE", "device_type_name")
utils.getDataDict(cur, moduleList, "install_type",
"GPS_MODULE_INSTALL_TYPE", "install_type_name")
utils.getDataDict(cur, moduleList, "status", "GPS_MODULE_STATUS",
"status_name")
data = []
sn = 1
for module in moduleList:
itemData = []
itemData.append(sn)
sn = sn + 1
itemData.append(module['name'])
itemData.append(module['code'])
itemData.append(module['serial_no'])
itemData.append(module['device_type_name'])
itemData.append(module['vendor'])
itemData.append(module['mac_addr'])
itemData.append(module['install_date'])
itemData.append(module['install_batch'])
itemData.append(module['install_type_name'])
itemData.append(module['status_name'])
itemData.append(module['addr'])
data.append(itemData)
struct = "SN, 名称, 编号, 序列号, 设备类型, 厂家, MAC地址, 安装日期, 安装批次, 安装类型, 状态, 最新位置"
path = {}
path = excel.createTempFile("xls")
excel.saveExcel(path['path'], struct, data)
logInfo = " %s 下载了定位模块清单 " % self.objUserInfo['name']
operation_log(self.db).addLog(self.GetUserInfo(), "gpsModuleManage",
logInfo, 0)
return path
def exportToExcel(self, structs, rowdata):
bulletinList = []
bulletinList = ConvertDataToTuple(structs, rows)
cur = self.db.getCursor()
utils.getDataDict(cur, bulletinList, "device_type",
"GPS_MODULE_DEVICE_TYPE", "device_type_name")
utils.getDataDict(cur, bulletinList, "install_type",
"GPS_MODULE_INSTALL_TYPE", "install_type_name")
utils.getDataDict(cur, bulletinList, "status", "GPS_MODULE_STATUS",
"status_name")
data = []
sn = 1
for module in bulletinList:
itemData = []
itemData.append(sn)
sn = sn + 1
itemData.append(module['name'])
itemData.append(module['code'])
itemData.append(module['serial_no'])
itemData.append(module['device_type_name'])
itemData.append(module['vendor'])
itemData.append(module['mac_addr'])
itemData.append(module['install_date'])
itemData.append(module['install_batch'])
itemData.append(module['install_type_name'])
itemData.append(module['status_name'])
itemData.append(module['addr'])
data.append(itemData)
struct = "SN, 名称, 编号, 序列号, 设备类型, 厂家, MAC地址, 安装日期, 安装批次, 安装类型, 状态, 最新位置"
path = {}
path = excel.createTempFile("xls")
excel.saveExcel(path['path'], struct, data)
logInfo = " %s 下载了定位模块清单 " % self.objUserInfo['name']
operation_log(self.db).addLog(self.GetUserInfo(),
"oaBulletinBoardManager", logInfo, 0)
return path
def exportToExcel(self, rowdata):
key = [
'id',
'create_time',
'update_time',
'create_id',
'update_id',
'controller',
'date',
'time',
'type',
'content',
'controller_code',
'log_id',
'level',
'title',
]
logList = []
for i, item in enumerate(rowdata):
logInfo = dict(zip(key, item))
logList.append(logInfo)
cur = self.db.getCursor()
utils.getDataDict(cur, logList, "type", "CTRL_LOG_TYPE", "type_name")
utils.getDataDict(cur, logList, "level", "CTRL_LOG_LEVEL",
"level_name")
data = []
sn = 1
for logInfo in logList:
if 'type_name' not in logInfo:
logInfo['type_name'] = ""
if 'level_name' not in logInfo:
logInfo['level_name'] = ""
itemData = []
itemData.append(sn)
sn = sn + 1
itemData.append(logInfo['controller_code']) # 控制器编号
itemData.append(logInfo['date'] + ' ' + logInfo['time']) # 日志日期
itemData.append(logInfo['level_name']) # 日志级别
itemData.append(logInfo['type_name']) # 日志类型
itemData.append(logInfo['title']) # 日志标题
itemData.append(logInfo['content']) # 日志内容
data.append(itemData)
struct = "SN, 控制器编号, 时间, 级别, 类型, 标题, 内容"
path = {}
path = excel.createTempFile("xls")
excel.saveExcel(path['path'], struct, data)
logInfo = " %s 下载了控制器日志清单 " % self.objUserInfo['name']
operation_log(self.db).addLog(self.GetUserInfo(), "logManage", logInfo,
0)
self.response(path)
def exportToExcel(self, rowdata, flag):
if flag:
key = [
'id', 'create_time', 'update_time', 'create_id', 'update_id',
'code', 'name', 'uploader_id', 'uploader_name', 'upload_date',
'file_path', 'file_name', 'sender_id', 'sender_name',
'send_date', 'send_time', 'send_status'
]
else:
key = [
'id', 'create_time', 'update_time', 'create_id', 'update_id',
'code', 'name', 'uploader_id', 'uploader_name', 'upload_date',
'file_path', 'file_name'
]
messageList = []
for item in rowdata:
messageInfo = dict(zip(key, item))
messageList.append(messageInfo)
if flag == False:
cur = self.db.getCursor()
utils.getDataDict(cur, messageList, "send_status",
"PROGRAM_SEND_STATUS", "send_status_name")
data = []
sn = 1
for item in messageList:
if 'send_status_name' not in item:
item['send_status_name'] = "未发送"
itemData = []
itemData.append(sn)
sn = sn + 1
itemData.append(item['name'])
itemData.append(item['uploader_name'])
itemData.append(item['upload_date'])
if flag == False:
itemData.append(item['sender_name'])
itemData.append(item['send_date'])
itemData.append(item['send_time'])
itemData.append(item['send_status_name'])
data.append(itemData)
struct = "SN, 文件名称, 上传人姓名, 上传日期 "
if flag == False:
struct += ", 下发人姓名, 发送日期, 发送时间, 发送状态"
path = {}
path = excel.createTempFile("xlsx")
# logI("exportToExcel path:", path)
excel.saveExcel(path['path'], struct, data)
logInfo = " %s 下载了版式文件清单 " % self.objUserInfo['name']
operation_log(self.db).addLog(self.GetUserInfo(), "listManage",
logInfo, 0)
self.response(path)