def get_sub_name(obj): try: return model_to_dict( SubSite.objects.get(id=obj.sub_site.id))['name'] except Exception as e: common_util.debug(e) return ""
def sync_guarantee(request): if request.method == 'POST': day_start = eval(request.body).get('day_start', None) day_end = eval(request.body).get('day_end', None) common_util.debug(day_start) common_util.debug(day_end) platform_util.do_sync_gurantee(day_start, day_end) return common_util.json_response(True, message="同步成功")
def get_platform_car_info(request): from util import platform_util VIN = request.GET.get("VIN", "") common_util.debug(VIN) if VIN: data = platform_util.get_info(VIN) if data is None: return common_util.json_response(False, message="该底盘号未获取到车辆信息") common_util.debug(data) return common_util.json_response(True, data=data, message="更新车辆信息成功") else: return common_util.json_response(False, message="未获取到车辆底盘号")
def _guarantee_to_xls(): common_util.debug(day_start) common_util.debug(day_end) data = Gurantee.objects.filter(apply_date__range=(day_start, day_end)).order_by('apply_date') if not data: return style_del = xlwt.XFStyle() style_del.alignment.wrap = 1 header = ['申请日期', '审核状态', 'VIN', '车型', '配件名称', '配件费', '工时费', '总金额', '维修站', '同步', '自增', '备注', '审核日期', '配件代码', '配件数', '工时数', '维修类型', '索赔类型', '活动费', '辅料费', '特殊费'] param_list = ["apply_date", "check_state", "car_sn", "car_type", "acc_name", "acc_fee", "guarantee_time_fee", "total_fee", "sub_site", "is_sync", "is_fake", "remark", "acc_sn", "acc_count", "guarantee_time", "repair_type", "gurantee_type", "event_fee", "material_fee", "special_fee", "total_fee"] xls = xlwt.Workbook(style_compression=2) sheet = xls.add_sheet("Sheet1") sheet.col(2).width = (20 * 367) # 设置表格的宽度 sheet.col(4).width = (20 * 367) # sheet.col(9).width = (10 * 367) # sheet.col(10).width = (10 * 367) i = 0 row = 1 # 写表头 for each_header in header: sheet.write(0, i, each_header) i += 1 for model in data: i = 0 item = model_to_dict(model) item['apply_date'] = item['apply_date'].strftime('%m-%d') item['is_sync'] = "是" if item['is_sync'] else "否" item['is_fake'] = "是" if item['is_fake'] else "否" common_util.debug(item) common_util.debug(item['sub_site']) try: item['sub_site'] = SubSite.objects.get(id=item['sub_site']).name except Exception as e: pass for key in param_list: sheet.write(row, i, item[key]) i += 1 row += 1 xls.save(os.path.join(main_dir, 'templates/media/data/三包.xls'))
class StationViewSet(viewsets.ModelViewSet): common_util.debug('this is a log') ''' 站点列表,分页,搜索,过滤,权限,排序 ''' queryset = Station.objects.all() # 分页 pagination_class = StationPagination # 序列化 serializer_class = StationSerializer # 权限 permission_classes = (permissions.DjangoModelPermissionsOrAnonReadOnly,) # 排序 filter_backends = (DjangoFilterBackend, filters.SearchFilter, filters.OrderingFilter) # 过滤 filter_class = StationFilter # 搜索 search_fields = ('name',) # 排序 ordering_fields = ('id',)
def get_fix_man_detail(obj): try: return model_to_dict(EmployeeManage.objects.get(id=obj.fix_man.id)) except Exception as e: common_util.debug(e) return {}
def get_car_detail(obj): try: return model_to_dict(CarInfoManage.objects.get(id=obj.car.id)) except Exception as e: common_util.debug(e) return {}
i = 0 item = model_to_dict(model) item['apply_date'] = item['apply_date'].strftime('%m-%d') item['is_sync'] = "是" if item['is_sync'] else "否" item['is_fake'] = "是" if item['is_fake'] else "否" common_util.debug(item) common_util.debug(item['sub_site']) try: item['sub_site'] = SubSite.objects.get(id=item['sub_site']).name except Exception as e: pass for key in param_list: sheet.write(row, i, item[key]) i += 1 row += 1 xls.save(os.path.join(main_dir, 'templates/media/data/三包.xls')) if __name__ == '__main__': try: _, day_start, day_end = sys.argv except Exception as e: day_start = common_util.get_today() day_end = common_util.get_today(1) read_excel() try: _guarantee_to_xls() except Exception as e: common_util.debug(e)