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)