Examples with Condition tk.mybatis.mapper.entity.Condition used on opensource projects

Example 21 with Condition

use of tk.mybatis.mapper.entity.Condition in project new-cloud by xie-summer.

the class PanoramicIntoTheFactoryRecordsServiceImpl method listByDate.

@Override
@Transactional(propagation = Propagation.NOT_SUPPORTED, rollbackFor = Exception.class)
public List<PanoramicIntoTheFactoryRecords> listByDate(String date) {
    Condition condition = new Condition(PanoramicIntoTheFactoryRecords.class, false);
    condition.createCriteria().andCondition(" delete_flag=1  and status=1 and date_format(snapshot_time,'%Y%m%d') = date_format('" + date + "','%Y%m%d')");
    condition.setOrderByClause(" snapshot_time desc ");
    List<PanoramicIntoTheFactoryRecords> factoryRecords = intoTheFactoryRecordsMapper.selectByCondition(condition);
    return factoryRecords;
}

Example 22 with Condition

use of tk.mybatis.mapper.entity.Condition in project new-cloud by xie-summer.

the class PanoramicProductOfflineMeasurementServiceImpl method productOfflineSummaryTask.

/**
 * 产品消耗数据实时汇总
 * @param name
 * @param code
 * @param date
 */
private void productOfflineSummaryTask(String name, String code, String date) {
    // 
    Condition condition = new Condition(PanoramicProductOfflineMeasurement.class, false);
    condition.createCriteria().andCondition("	code = '" + code + "' " + "AND f_id=2 AND delete_flag=1 " + "AND date_format(utime,'%Y%m%d%H') = date_format('" + date + "','%Y%m%d%H')");
    List<PanoramicProductOfflineMeasurement> offlineMeasurementList = panoramicProductOfflineMeasurementMapper.selectByCondition(condition);
    PanoramicProductOfflineMeasurement record = new PanoramicProductOfflineMeasurement();
    record.setCode(code);
    record.setName(name);
    record.setValue(String.valueOf("0.0"));
    record.setCtime(DateUtil.getCurFullTimestamp());
    record.setId(null);
    record.setOperator("auto_task");
    record.setfId("2");
    record.setUnit("吨");
    record.setDeleteFlag(1);
    final double[] sumValue = { 0.0 };
    if (null != offlineMeasurementList && offlineMeasurementList.size() > 0) {
        offlineMeasurementList.forEach(e -> {
            sumValue[0] += Double.valueOf(e.getValue()).doubleValue();
            record.setUtime(e.getUtime());
            record.setDtime(null);
            record.setOperator(e.getOperator());
            record.setfId(e.getfId());
            record.setName(e.getName());
            record.setDeleteFlag(e.getDeleteFlag());
            record.setCtime(e.getCtime());
            record.setId(null);
        });
    }
    PanoramicRealTimeConsumptionGather selectOne = realTimeConsumptionGatherMapper.selectByGatherTime(code, date);
    Optional<PanoramicRealTimeConsumptionGather> one = Optional.ofNullable(selectOne);
    if (one.isPresent()) {
        selectOne.setValue(sumValue[0]);
        selectOne.setUtime(DateUtil.getCurFullTimestamp());
        selectOne.setCtime(selectOne.getUtime());
        selectOne.setOperator("auto_task_update");
        selectOne.setGatherTime(date);
        realTimeConsumptionGatherMapper.updateByPrimaryKeySelective(selectOne);
    } else {
        PanoramicRealTimeConsumptionGather gather = new PanoramicRealTimeConsumptionGather();
        gather.setCode(code);
        gather.setName(name);
        gather.setDeleteFlag(record.getDeleteFlag());
        gather.setfId(record.getfId());
        gather.setGatherTime(date);
        gather.setId(null);
        gather.setCtime(DateUtil.getCurFullTimestamp());
        gather.setName(record.getName());
        gather.setOperator(record.getOperator());
        gather.setUnit(record.getUnit());
        gather.setDtime(record.getDtime());
        gather.setUtime(gather.getCtime());
        gather.setValue(sumValue[0]);
        realTimeConsumptionGatherMapper.insert(gather);
    }
}

Example 23 with Condition

use of tk.mybatis.mapper.entity.Condition in project new-cloud by xie-summer.

the class PanoramicRealTimeConsumptionServiceImpl method realtimeConsumptionSummaryTask.

@Override
@Transactional(readOnly = false, propagation = Propagation.REQUIRED, rollbackFor = Exception.class)
public void realtimeConsumptionSummaryTask(String name, String code, String date) {
    // 先查出来，再去更新
    Condition condition = new Condition(PanoramicRealTimeConsumption.class, false);
    condition.createCriteria().andCondition("  substring(code, 1, 12) = '" + code + "' AND f_id=2 AND delete_flag=1 " + " AND date_format(utime,'%Y%m%d%H') = date_format('" + date + "','%Y%m%d%H')");
    List<PanoramicRealTimeConsumption> consumptionList = realTimeConsumptionMapper.selectByCondition(condition);
    PanoramicRealTimeConsumption record = new PanoramicRealTimeConsumption();
    record.setCode(code);
    record.setName(name);
    record.setValue(0.0);
    record.setCtime(DateUtil.getCurFullTimestamp());
    record.setId(null);
    record.setOperator("auto_task");
    record.setfId("2");
    record.setUnit(StringUtils.containsIgnoreCase(code, "0004A4000009") ? "度" : "吨");
    record.setDeleteFlag(1);
    final double[] sumValue = { 0.0 };
    if (null != consumptionList && consumptionList.size() > 0) {
        consumptionList.forEach(e -> {
            sumValue[0] += e.getValue();
            record.setUtime(e.getUtime());
            record.setDtime(null);
            record.setOperator("auto_task");
            record.setfId(e.getfId());
            record.setName(e.getName());
            record.setDeleteFlag(e.getDeleteFlag());
            record.setCtime(e.getCtime());
            record.setId(null);
        });
    }
    PanoramicRealTimeConsumptionGather selectOne = realTimeConsumptionGatherMapper.selectByGatherTime(code, date);
    Optional<PanoramicRealTimeConsumptionGather> one = Optional.ofNullable(selectOne);
    if (one.isPresent()) {
        selectOne.setValue(sumValue[0]);
        selectOne.setUtime(DateUtil.getCurFullTimestamp());
        selectOne.setCtime(selectOne.getUtime());
        selectOne.setOperator("auto_task_update");
        selectOne.setGatherTime(date);
        realTimeConsumptionGatherMapper.updateByPrimaryKeySelective(selectOne);
    } else {
        PanoramicRealTimeConsumptionGather gather = new PanoramicRealTimeConsumptionGather();
        gather.setCode(code);
        gather.setName(name);
        gather.setDeleteFlag(record.getDeleteFlag());
        gather.setfId(record.getfId());
        gather.setGatherTime(date);
        gather.setId(null);
        gather.setCtime(DateUtil.getCurFullTimestamp());
        gather.setName(record.getName());
        gather.setOperator(record.getOperator());
        gather.setUnit(record.getUnit());
        gather.setDtime(record.getDtime());
        gather.setUtime(gather.getCtime());
        gather.setValue(sumValue[0]);
        realTimeConsumptionGatherMapper.insert(gather);
    }
}

Example 24 with Condition

use of tk.mybatis.mapper.entity.Condition in project new-cloud by xie-summer.

the class PanoramicRealTimeConsumptionGatherServiceImpl method listByCodeAndDate.

@Override
@Transactional(propagation = Propagation.NOT_SUPPORTED, rollbackFor = Exception.class)
public List<PanoramicRealTimeConsumptionGather> listByCodeAndDate(String date, String code) {
    Condition condition = new Condition(PanoramicRealTimeConsumptionGather.class, false);
    condition.createCriteria().andCondition(" code ='" + code + "' and f_id=2 and delete_flag=1 and gather_time > '" + DateUtil.parseTimestamp(date.concat(" 07:00"), "yyyy-MM-dd HH:mm") + "' and  gather_time < '" + DateUtil.parseTimestamp(DateUtil.getSpecifiedDayBefor(date, -1).concat(" 08:00"), "yyyy-MM-dd HH:mm") + "'");
    condition.setOrderByClause(" gather_time asc ");
    List<PanoramicRealTimeConsumptionGather> recordList = realTimeConsumptionGatherMapper.selectByCondition(condition);
    return recordList;
}

Example 25 with Condition

use of tk.mybatis.mapper.entity.Condition in project new-cloud by xie-summer.

the class PanoramicRealTimeConsumptionGatherServiceImpl method queryStatisticsForDay.

private PanoramicRealTimeConsumptionGatherDto queryStatisticsForDay(String date, String code) {
    PanoramicRealTimeConsumptionGatherDto gather = new PanoramicRealTimeConsumptionGatherDto();
    gather.setCode(code);
    gather.setValue(0.0);
    gather.setRecordValues(0.0);
    gather.setCtime(DateUtil.parseTimestamp(date, "yyyy-MM-dd"));
    gather.setGatherTime(date);
    gather.setName(StringUtils.equalsIgnoreCase(code, HG_01_XY_7505) ? "磷钙" : "普钙");
    gather.setDeleteFlag(1);
    gather.setDtime(null);
    gather.setfId("2");
    gather.setId(null);
    Condition condition = new Condition(PanoramicProductMaterials.class, false);
    condition.createCriteria().andCondition("code ='" + code + "' and in_or_out =1 and delete_flag =1 " + " AND date_format(utime,'%Y%m%d') = date_format('" + date + "','%Y%m%d')");
    List<PanoramicProductMaterials> productMaterials = productMaterialsService.findByCondition(condition);
    if (null != productMaterials && productMaterials.size() > 0) {
        productMaterials.forEach(e -> {
            gather.setValue(Double.parseDouble(e.getValue()) + gather.getValue());
            gather.setDeleteFlag(e.getDeleteFlag());
            gather.setfId(e.getfId());
            gather.setId(null);
            gather.setName(e.getName());
            gather.setOperator(e.getOperator());
            gather.setUnit(e.getUnit());
            gather.setDtime(null);
            gather.setUtime(e.getUtime());
        });
    }
    Condition cond = new Condition(PanoramicInventoryEntry.class, false);
    cond.createCriteria().andCondition(" code ='" + code + "' and in_or_out =1 and delete_flag =1  " + " AND date_format(utime,'%Y%m%d') = date_format('" + date + "','%Y%m%d')");
    List<PanoramicInventoryEntry> inventoryEntries = inventoryEntryService.findByCondition(cond);
    if (null != inventoryEntries && inventoryEntries.size() > 0) {
        inventoryEntries.forEach(e -> {
            gather.setRecordValues(Double.parseDouble(e.getValue()) + gather.getRecordValues());
        });
    }
    return gather;
}