zhaowenxuan
7 天以前 74ea6779bd941167afcd8c120dc2ac68f886aa67
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
package com.ltkj.web.controller.system;
 
import java.math.BigDecimal;
import java.math.RoundingMode;
import java.util.*;
import java.util.stream.Collectors;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletResponse;
 
import cn.hutool.extra.pinyin.PinyinUtil;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.ltkj.common.core.redis.RedisCache;
import com.ltkj.hosp.domain.*;
import com.ltkj.hosp.service.*;
import com.ltkj.mall.domain.MallCategory;
import com.ltkj.mall.domain.MallKeyword;
import com.ltkj.mall.service.IMallCategoryService;
import com.ltkj.mall.service.IMallKeywordService;
import com.ltkj.system.service.ISysConfigService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import io.swagger.annotations.ApiParam;
import jodd.util.StringUtil;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.security.access.prepost.PreAuthorize;
import org.springframework.web.bind.annotation.*;
import com.ltkj.common.annotation.Log;
import com.ltkj.common.core.controller.BaseController;
import com.ltkj.common.core.domain.AjaxResult;
import com.ltkj.common.enums.BusinessType;
import com.ltkj.common.utils.poi.ExcelUtil;
import com.ltkj.common.core.page.TableDataInfo;
 
/**
 * 体检套餐Controller
 *
 * @author ltkj
 * @date 2022-11-17
 */
@RestController
@RequestMapping("/system/package")
@Api(tags = "体检套餐管理")
@Slf4j
public class TjPackageController extends BaseController {
    @Resource
    private ITjPackageService tjPackageService;
    @Resource
    private ITjPackageProjectService ppservice;
    @Resource
    private ITjProjectService tjProjectService;
    @Resource
    private TjProConsumablesService tjProConsumablesService;
    @Resource
    private ITjConsumablesService tjConsumablesService;
    @Resource
    private ISysConfigService configService;
    @Autowired
    private IMallKeywordService mallKeywordService;
    @Autowired
    private IMallCategoryService mallCategoryService;
 
    @GetMapping("/getPacList")
    @ApiOperation(value = "查询体检套餐列表(自带有分页)(新)")
    //@PreAuthorize("@ss.hasPermi('hosp:package:list')")
    public TableDataInfo getPacList(@ApiParam(value = "体检套餐对象") TjPackage tjPackage) {
        startPage();
        List<TjPackage> list = tjPackageService.selectTjPackageList(tjPackage);
        if (null != list && !list.isEmpty()) {
            for (TjPackage aPackage : list) {
                aPackage.setAllProName(tjPackageService.getTjPacProNames(String.valueOf(aPackage.getPacId())));
                final String keywords = aPackage.getKeywords();
                if (keywords != null) {
                    final String[] strings = keywords.split(",");
                    aPackage.setKeyNames(mallKeywordService.getKeyNames(strings));
                    aPackage.setKeyIds(mallKeywordService.getKeyIds(strings));
                }
 
                final MallCategory byId = mallCategoryService.getById(aPackage.getCategoryId());
                if (byId != null) {
                    aPackage.setCategoryNames(byId.getName());
                }
            }
        }
        return getDataTable(list);
    }
 
 
    @GetMapping("/getPacInFo")
    @ApiOperation(value = "查询体检套餐列表(详细)(自带有分页)(新)")
    //@PreAuthorize("@ss.hasPermi('hosp:package:list')")
    public AjaxResult getPacInFo(@ApiParam(value = "体检套餐对象id") String pacId) {
        TjPackage aPackage = tjPackageService.getById(pacId);
        if (null != aPackage) {
                List<TjPackageProject> pplist = ppservice.getTjPackageProjectListByPacId(String.valueOf(aPackage.getPacId()));
                if (null != pplist) {
                    for (TjPackageProject packageProject : pplist) {
                        TjProject tjProject = tjProjectService.getById(packageProject.getProId());
                        if (null != tjProject) {
                            packageProject.setProName(tjProject.getProName());
                        }
                    }
                }
                aPackage.setPackageProjects(pplist);
            return AjaxResult.success(aPackage);
        }
        return AjaxResult.error();
    }
 
 
    /**
     * 查询体检套餐列表
     */
    @GetMapping("/list")
    @ApiOperation(value = "查询体检套餐列表(自带有分页)")
    //@PreAuthorize("@ss.hasPermi('hosp:package:list')")
    public TableDataInfo list(@ApiParam(value = "体检套餐对象") TjPackage tjPackage) {
        startPage();
        List<TjPackage> list = tjPackageService.selectTjPackageList(tjPackage);
        if (null != list && !list.isEmpty()) {
            for (TjPackage aPackage : list) {
                StringBuilder allProName = new StringBuilder();
                StringBuilder allSonName = new StringBuilder();
 
                List<TjProject> tjProjectList = new ArrayList<>();
                List<TjPackageProject> pplist = ppservice.getTjPackageProjectListByPacId(String.valueOf(aPackage.getPacId()));
                if (null != pplist) {
                    for (TjPackageProject packageProject : pplist) {
                        StringBuilder allSonProName = new StringBuilder();   //2023.2.7 套餐内每一父项目的子项目字符串
                        TjProject tjProject = tjProjectService.getById(packageProject.getProId());
                        if (null != tjProject) {
                            allProName.append(tjProject.getProName()).append(";");
                            List<TjProject> listBySoneId = tjProjectService.getTjProjectListBySoneId(String.valueOf(packageProject.getProId()));
                            for (TjProject project : listBySoneId) {
                                allSonProName.append(project.getProName()).append(";");  //2023.2.7 套餐内每一父项目的子项目字符串
                                allSonName.append(project.getProName()).append(";");
                            }
                            tjProject.setAllSonProName(allSonProName.toString());   //2023.2.7 套餐内每一父项目的子项目字符串
                            tjProjectList.add(tjProject);
                            //现价赋值判断null赋原价  2023.2.8
                            if (packageProject.getPriceNow() != null) {
                                tjProject.setPriceNow(packageProject.getPriceNow());
                            } else {
                                tjProject.setPriceNow(tjProject.getProPrice());
                            }
 
                        }
                    }
                }
                aPackage.setTjProjectList(tjProjectList);
                aPackage.setAllProName(allProName.toString());
//                aPackage.setAllSonName(allSonName.toString());
 
                StringBuffer a = new StringBuffer();
                List<String> b = new ArrayList<>();
                final String keywords = aPackage.getKeywords();
                if (keywords != null) {
                    final String[] strings = keywords.split(",");
                    for (String string : strings) {
                        final MallKeyword byId = mallKeywordService.getById(string);
                        if (byId != null) {
                            a.append(byId.getKeyword());
                            a.append(";");
                            b.add((byId.getId()).toString());
                        }
                    }
                    aPackage.setKeyNames(String.valueOf(a));
                    aPackage.setKeyIds(b);
                }
 
                final MallCategory byId = mallCategoryService.getById(aPackage.getCategoryId());
                if (byId != null) {
                    aPackage.setCategoryNames(byId.getName());
                }
            }
        }
        return getDataTable(list);
    }
 
    /**
     * 查询体检套餐列表
     */
    @GetMapping("getList")
    @ApiOperation(value = "查询体检套餐列表")
    public TableDataInfo getList(@RequestParam(required = false) @ApiParam(value = "性别") String cusSex) {
//        List<TjPackage> tjPackageList = null;
//        List<TjPackage> list = null;
//        if (cusSex == null || cusSex.equals("2")) {
//            if (redisCache.hasKey("getTjPackageListBySex")) {
//                list = redisCache.getCacheMapValue("getTjPackageListBySex", "getTjPackageListByManAndWoMan");
//            } else {
//                tjPackageList = tjPackageService.list(new LambdaQueryWrapper<TjPackage>().eq(TjPackage::getPacStatus,0));
//            }
//        } else {
//            if (cusSex.equals("0")) {
//                if (redisCache.hasKey("getTjPackageListBySex")) {
//                    list = redisCache.getCacheMapValue("getTjPackageListBySex", "getTjPackageListByMan");
//                } else {
//                    tjPackageList = tjPackageService.getTjPackageListByMan();
//                }
//            } else {
//                if (redisCache.hasKey("getTjPackageListBySex")) {
//                    list = redisCache.getCacheMapValue("getTjPackageListBySex", "getTjPackageListByWoMan");
//                } else {
//                    tjPackageList = tjPackageService.getTjPackageListByWoMan();
//                }
//            }
//        }
//        asyncService.getTjPackageList();
//        if (null != list && list.size() > 0) {
//            return getDataTable(list);
//        } else {
//            getTjPackageList(tjPackageList);
//            return getDataTable(tjPackageList);
//        }
        String pacName="";
        if (cusSex==null || cusSex.equals("2")) {
            final List<TjPackage> pacListBySqlAndAll = tjPackageService.getPacListBySqlAndAll(pacName);
            if (pacListBySqlAndAll!=null){
                for (TjPackage tjPackage : pacListBySqlAndAll) {
                    List<TjProject> res=new ArrayList<>();
                    LambdaQueryWrapper<TjPackageProject> wqq=new LambdaQueryWrapper<>();
                    wqq.eq(TjPackageProject::getPacId,tjPackage.getPacId());
                    final List<TjPackageProject> list = ppservice.list(wqq);
                    if (list!=null){
                        for (TjPackageProject tjPackageProject : list) {
                            final TjProject byId = tjProjectService.getById(tjPackageProject.getProId());
                            res.add(byId);
                        }
                        tjPackage.setTjProjectList(res);
                    }
                }
            }
            return getDataTable(pacListBySqlAndAll);
        } else {
            if (cusSex.equals("0")) {
                final List<TjPackage> pacListBySqlAndMan = tjPackageService.getPacListBySqlAndMan(pacName);
                if (pacListBySqlAndMan!=null){
                    for (TjPackage tjPackage : pacListBySqlAndMan) {
                        List<TjProject> res=new ArrayList<>();
                        LambdaQueryWrapper<TjPackageProject> wqq=new LambdaQueryWrapper<>();
                        wqq.eq(TjPackageProject::getPacId,tjPackage.getPacId());
                        final List<TjPackageProject> list = ppservice.list(wqq);
                        if (list!=null){
                            for (TjPackageProject tjPackageProject : list) {
                                final TjProject byId = tjProjectService.getById(tjPackageProject.getProId());
                                res.add(byId);
                            }
                            tjPackage.setTjProjectList(res);
                        }
                    }
                }
                return getDataTable(pacListBySqlAndMan);
            }else {
                final List<TjPackage> pacListBySqlAndWomen = tjPackageService.getPacListBySqlAndWomen(pacName);
                if (pacListBySqlAndWomen!=null){
                    for (TjPackage tjPackage : pacListBySqlAndWomen) {
                        List<TjProject> res=new ArrayList<>();
                        LambdaQueryWrapper<TjPackageProject> wqq=new LambdaQueryWrapper<>();
                        wqq.eq(TjPackageProject::getPacId,tjPackage.getPacId());
                        final List<TjPackageProject> list = ppservice.list(wqq);
                        if (list!=null){
                            for (TjPackageProject tjPackageProject : list) {
                                final TjProject byId = tjProjectService.getById(tjPackageProject.getProId());
                                res.add(byId);
                            }
                            tjPackage.setTjProjectList(res);
                        }
                    }
                }
                return getDataTable(pacListBySqlAndWomen);
            }
        }
    }
 
    private void getTjPackageList(List<TjPackage> tjPackageList) {
        if (null != tjPackageList && !tjPackageList.isEmpty()) {
            for (TjPackage aPackage : tjPackageList) {
                List<TjProject> tjProjectList = new ArrayList<>();
                List<TjPackageProject> pplist = ppservice.getTjPackageProjectListByPacId(String.valueOf(aPackage.getPacId()));
                StringBuilder allProName = new StringBuilder();
                String allSonName = null;
                if (null != pplist) {
                    for (TjPackageProject packageProject : pplist) {
                        TjProject tjProject = tjProjectService.selectTjProjectByProId(packageProject.getProId());
                        if (null != tjProject) {
                            allProName.append(tjProject.getProName()).append(";");
                            String name = tjProjectService.appendTjProjectName(String.valueOf(packageProject.getProId()));
                            allSonName = name;
                            tjProject.setAllSonProName(name);
                            tjProjectList.add(tjProject);
                            List<TjConsumables> list1 = tjConsumablesService.getTjConsumablesList(String.valueOf(packageProject.getProId()));
                            tjProject.setConsumablesList(list1);
                        }
                    }
                }
                aPackage.setTjProjectList(tjProjectList);
                aPackage.setAllProName(allProName.toString());
                aPackage.setAllSonName(allSonName);
            }
        }
    }
 
 
    /**
     * 导出体检套餐列表
     */
    @Log(title = "体检套餐", businessType = BusinessType.EXPORT)
    @PostMapping("/export")
    @ApiOperation(value = "导出体检套餐列表")
    //@PreAuthorize("@ss.hasPermi('system:package:export')")
    public void export(HttpServletResponse response, TjPackage tjPackage) {
        List<TjPackage> list = tjPackageService.selectTjPackageList(tjPackage);
        ExcelUtil<TjPackage> util = new ExcelUtil<TjPackage>(TjPackage.class);
        util.exportExcel(response, list, "体检套餐数据");
    }
 
 
    /**
     * 根据套餐id获取项目集合
     */
    @GetMapping("/listByPacId")
    @ApiOperation(value = "根据套餐id获取体检套餐详细信息")
    //@PreAuthorize("@ss.hasPermi('system:package:Seach')")
    public AjaxResult listByPacId(@ApiParam(value = "体检套餐id") @RequestParam Long pacId) {
        if (pacId != null) {
            TjPackage tjPackage = tjPackageService.getById(pacId);
            LambdaQueryWrapper<TjPackageProject> wq = new LambdaQueryWrapper<>();
            wq.eq(TjPackageProject::getPacId, pacId);
            List<TjPackageProject> packageProjectList = ppservice.list(wq);
            StringBuilder allName = new StringBuilder();
            StringBuilder allSonName = new StringBuilder();
            if (null != packageProjectList && packageProjectList.size() > 0) {
                List<TjProject> projectList = new ArrayList<>();
                for (TjPackageProject tjPackageProject : packageProjectList) {
                    LambdaQueryWrapper<TjProject> wq1 = new LambdaQueryWrapper<>();
                    wq1.eq(TjProject::getProId, tjPackageProject.getProId());
                    wq1.eq(TjProject::getProParentId, 0);
                    if (null != tjProjectService.getOne(wq1)) {
                        projectList.add(tjProjectService.getOne(wq1));
                        allName.append(tjProjectService.getOne(wq1).getProName()).append(";");
                    }
                }
                tjPackage.setAllProName(allName.toString());
                for (TjProject tjProject : projectList) {
                    LambdaQueryWrapper<TjProject> wq2 = new LambdaQueryWrapper<>();
                    wq2.eq(TjProject::getProParentId, tjProject.getProId());
                    tjProject.setTjProjectList(tjProjectService.list(wq2));
                    for (TjProject project : tjProjectService.list(wq2)) {
                        allSonName.append(project.getProName()).append(";");
                    }
                    tjProject.setAllSonProName(allSonName.toString());
                }
                tjPackage.setTjProjectList(projectList);
 
                return AjaxResult.success(tjPackage);
            }
            return success("暂时没有数据");
        }
        return error("套餐ID不能为空");
    }
 
 
    /**
     * 新增体检套餐
     */
    @Log(title = "体检套餐", businessType = BusinessType.INSERT)
    @PostMapping
    @ApiOperation(value = "新增体检套餐")
    //@PreAuthorize("@ss.hasPermi('system:package:add')")
    public AjaxResult add(@RequestBody @ApiParam(value = "体检套餐对象") TjPackage tjPackage) {
        if (null != tjPackage.getPrice()) {
            BigDecimal money = new BigDecimal("0.00");
            tjPackage.setPrice(money);
        }
        tjPackage.setPym(PinyinUtil.getFirstLetter(tjPackage.getPacName(),""));
        if (tjPackageService.save(tjPackage)) {
            List<TjProject> tjProjectList = tjPackage.getTjProjectList();
            if (null != tjProjectList && !tjProjectList.isEmpty()) {
                BigDecimal money = new BigDecimal("0.00");
                for (TjProject tjProject : tjProjectList) {
                    TjPackageProject tjpp = new TjPackageProject();
//                    if (null != tjProject.getPriceNow()) {
//                        tjpp.setPriceNow(tjProject.getPriceNow().setScale(Integer.parseInt(configService.selectConfigByKey("sys.price.save")), Integer.parseInt(configService.selectConfigByKey("sys.price"))));
//                    } else {
//                        tjpp.setPriceNow(tjProject.getProPrice());
//                    }
                    tjpp.setPriceNow(tjProject.getProPrice());
                    tjpp.setProId(tjProject.getProId());
                    tjpp.setPacId(tjPackage.getPacId());
                    //判断当前套餐下有没有这个项目  有的话跳过添加
                    LambdaQueryWrapper<TjPackageProject> wqq=new LambdaQueryWrapper<>();
                    wqq.eq(TjPackageProject::getPacId,tjPackage.getPacId());
                    wqq.eq(TjPackageProject::getProId,tjProject.getProId());
                    final TjPackageProject one = ppservice.getOne(wqq);
                    if (one!=null){
                        continue;
                    }
                    ppservice.save(tjpp);
                    if (null != tjProject.getProPrice()) {
                        money = money.add(tjProject.getProPrice());
                    }
                }
                tjPackage.setPrice(money.setScale(Integer.parseInt(configService.selectConfigByKey("sys.price.save")), Integer.parseInt(configService.selectConfigByKey("sys.price"))));
                tjPackageService.updateById(tjPackage);
            }
            return AjaxResult.success();
        }
        return AjaxResult.error("新增失败");
    }
 
    /**
     * 修改体检套餐
     */
    @Log(title = "体检套餐", businessType = BusinessType.UPDATE)
    @PutMapping
    @ApiOperation(value = "修改体检套餐")
    //@PreAuthorize("@ss.hasPermi('system:package:edit')")
    public AjaxResult edit(@RequestBody @ApiParam(value = "体检套餐对象") TjPackage tjPackage) {
        tjPackage.setPym(PinyinUtil.getFirstLetter(tjPackage.getPacName(),""));
        if (tjPackageService.updateById(tjPackage)) {
            List<TjProject> tjProjectList = tjPackage.getTjProjectList();
            if (null != tjProjectList && !tjProjectList.isEmpty()) {
                LambdaQueryWrapper<TjPackageProject> wq = new LambdaQueryWrapper<>();
                wq.eq(TjPackageProject::getPacId, tjPackage.getPacId());
                ppservice.remove(wq);
                BigDecimal money = new BigDecimal(0);
                for (TjProject tjProject : tjProjectList) {
                    //判断当前套餐下有没有这个项目  有的话跳过添加
                    LambdaQueryWrapper<TjPackageProject> wqq=new LambdaQueryWrapper<>();
                    wqq.eq(TjPackageProject::getPacId,tjPackage.getPacId());
                    wqq.eq(TjPackageProject::getProId,tjProject.getProId());
                    final TjPackageProject one = ppservice.getOne(wqq);
                    if (one!=null){
                        continue;
                    }
 
                    TjPackageProject tjpp = new TjPackageProject();
//                    if (null != tjProject.getPriceNow()) {
//                        tjpp.setPriceNow(tjProject.getPriceNow());
//                    } else {
//                        tjpp.setPriceNow(new BigDecimal(0).setScale(Integer.parseInt(configService.selectConfigByKey("sys.price.save")), Integer.parseInt(configService.selectConfigByKey("sys.price"))));
//                    }
                    tjpp.setPriceNow(tjProject.getProPrice());
                    tjpp.setProId(tjProject.getProId());
                    tjpp.setPacId(tjPackage.getPacId());
                    ppservice.save(tjpp);
                    if (null != tjProject.getProPrice()) {
                        money = money.add(tjProject.getProPrice());
                    }
                }
                tjPackage.setPrice(money.setScale(Integer.parseInt(configService.selectConfigByKey("sys.price.save")), Integer.parseInt(configService.selectConfigByKey("sys.price"))));
                tjPackageService.updateById(tjPackage);
            }
            return AjaxResult.success();
        }
        return AjaxResult.error();
    }
 
 
    @PostMapping("/updateStatus")
    @ApiOperation(value = "修改套餐状态按钮接口")
    public AjaxResult updateStatus(@RequestBody TjPackage tjPackage) {
        if (null != tjPackage) {
//            if (tjPackage.getPacStatus().equals("1")) {
//                List<TjPackageProject> list = ppservice.getTjPackageProjectListByPacId(String.valueOf(tjPackage.getPacId()));
//                if(null !=list && list.size()>0){
//                    return AjaxResult.error("该套餐下有项目正在使用不能停用!!!");
//                }
//            }
            final TjPackage byId = tjPackageService.getById(tjPackage.getPacId());
            byId.setPacStatus(tjPackage.getPacStatus());
            tjPackageService.updateById(byId);
            return AjaxResult.success("操作成功!!!!");
        }
        return AjaxResult.error();
    }
 
 
    /**
     * 删除体检套餐
     */
    @Log(title = "体检套餐", businessType = BusinessType.DELETE)
    @DeleteMapping("/{pacIds}")
    @ApiOperation(value = "删除体检套餐")
    //@PreAuthorize("@ss.hasPermi('system:package:remove')")
    public AjaxResult remove(@PathVariable Long[] pacIds) {
        if (null != pacIds && pacIds.length > 0) {
            for (Long pacId : pacIds) {
                TjPackage byId = tjPackageService.getById(pacId);
                if (null != byId) {
                    if (byId.getPacStatus().equals(0)) {
                        return AjaxResult.error("该套餐正在使用中不能删除");
                    }
                    if (tjPackageService.removeById(pacId)) {
                        LambdaQueryWrapper<TjPackageProject> wq = new LambdaQueryWrapper<>();
                        wq.eq(TjPackageProject::getPacId, pacId);
                        ppservice.remove(wq);
                    }
                }
            }
            return AjaxResult.success("删除成功");
        }
        return AjaxResult.error("请选择要删除的套餐");
    }
 
 
    /**
     * 更改体检套餐和其中的项目
     */
    @GetMapping("/updateProject")
    @ApiOperation(value = "更改体检套餐 和 其中的项目")
    //@PreAuthorize("@ss.hasPermi('system:package:updateProject')")
    public AjaxResult updateProject(@RequestParam TjPackage tjPackage, @RequestParam TjProject[] proIds) {
        if (tjPackage == null) {
            return AjaxResult.error();
        }
        tjPackageService.updateTjPackage(tjPackage);
        if (proIds.length <= 0) {
            return AjaxResult.error();
        }
        LambdaQueryWrapper<TjPackageProject> wq = new LambdaQueryWrapper<>();
        wq.eq(TjPackageProject::getPacId, tjPackage.getPacId());
        boolean remove = ppservice.remove(wq);
        if (!remove) {
            return AjaxResult.error();
        }
        for (TjProject project : proIds) {
            TjPackageProject packageProject = new TjPackageProject();
            packageProject.setPacId(tjPackage.getPacId());
            packageProject.setProId(project.getProId());
            packageProject.setPriceNow(project.getPriceNow());
            ppservice.save(packageProject);
        }
        return AjaxResult.success();
    }
 
 
    /**
     * 根据拼音码或套餐名称搜索套餐
     */
 
    @GetMapping("/getPackageListByPyName")
    @ApiOperation(value = "根据拼音码或套餐名称搜索套餐")
    public AjaxResult getPackageListByPyName(@RequestParam @ApiParam(value = "拼音码或名称") String name) {
        if (null != name) {
            LambdaQueryWrapper<TjPackage> wq0 = new LambdaQueryWrapper<>();
            wq0.like(TjPackage::getPacName, name);
            List<TjPackage> packageList = tjPackageService.list(wq0);
            if (null != packageList && !packageList.isEmpty()) {
                for (TjPackage aPackage : packageList) {
                    List<TjProject> tjProjectList = new ArrayList<>();
                    LambdaQueryWrapper<TjPackageProject> wq = new LambdaQueryWrapper<>();
                    wq.eq(TjPackageProject::getPacId, aPackage.getPacId());
                    List<TjPackageProject> pplist = ppservice.list(wq);
                    StringBuilder allProName = new StringBuilder();
                    StringBuilder allSonName = new StringBuilder();
                    if (null != pplist) {
                        for (TjPackageProject packageProject : pplist) {
                            StringBuilder allSonProName = new StringBuilder();
                            TjProject tjProject = tjProjectService.getById(packageProject.getProId());
                            if (null != tjProject) {
                                allProName.append(tjProject.getProName()).append(";");
                                LambdaQueryWrapper<TjProject> wq2 = new LambdaQueryWrapper<>();
                                wq2.eq(TjProject::getProParentId, packageProject.getProId());
                                for (TjProject project : tjProjectService.list(wq2)) {
                                    allSonProName.append(project.getProName()).append(";");
                                    allSonName.append(project.getProName()).append(";");
                                    tjProject.setAllSonProName(allSonProName.toString());
                                }
                                tjProjectList.add(tjProject);
                                LambdaQueryWrapper<TjProConsumables> wrapper1 = new LambdaQueryWrapper<>();
                                wrapper1.eq(TjProConsumables::getProId, packageProject.getProId());
                                List<TjProConsumables> list = tjProConsumablesService.list(wrapper1);
                                List<TjConsumables> list1 = new ArrayList<>();
                                for (TjProConsumables tjProConsumables : list) {
                                    list1.add(tjConsumablesService.getById(tjProConsumables.getConsumablesId()));
                                }
                                tjProject.setConsumablesList(list1);
                            }
                        }
                    }
                    aPackage.setTjProjectList(tjProjectList);
                    aPackage.setAllProName(allProName.toString());
                    aPackage.setAllSonName(allSonName.toString());
                }
                return AjaxResult.success(packageList);
            }
 
            List<TjPackage> tjPackageList = tjPackageService.list();
            if (null != tjPackageList && !tjPackageList.isEmpty()) {
                List<TjPackage> lisi = new ArrayList<>();
                for (TjPackage aPackage : tjPackageList) {
                    String pinyin = PinyinUtil.getFirstLetter(aPackage.getPacName(), "");
                    if (pinyin.contains(name)) {
                        List<TjProject> tjProjectList = new ArrayList<>();
                        LambdaQueryWrapper<TjPackageProject> wq = new LambdaQueryWrapper<>();
                        wq.eq(TjPackageProject::getPacId, aPackage.getPacId());
                        List<TjPackageProject> pplist = ppservice.list(wq);
                        StringBuilder allProName = new StringBuilder();
                        StringBuilder allSonName = new StringBuilder();
 
                        if (null != pplist) {
                            for (TjPackageProject packageProject : pplist) {
                                StringBuilder allSonProName = new StringBuilder();
                                TjProject tjProject = tjProjectService.getById(packageProject.getProId());
                                if (null != tjProject) {
                                    allProName.append(tjProject.getProName()).append(";");
                                    LambdaQueryWrapper<TjProject> wq2 = new LambdaQueryWrapper<>();
                                    wq2.eq(TjProject::getProParentId, packageProject.getProId());
                                    for (TjProject project : tjProjectService.list(wq2)) {
                                        allSonProName.append(project.getProName()).append(";");
                                        allSonName.append(project.getProName()).append(";");
                                        tjProject.setAllSonProName(allSonProName.toString());
                                    }
                                    tjProjectList.add(tjProject);
                                    LambdaQueryWrapper<TjProConsumables> wrapper1 = new LambdaQueryWrapper<>();
                                    wrapper1.eq(TjProConsumables::getProId, packageProject.getProId());
                                    List<TjProConsumables> list = tjProConsumablesService.list(wrapper1);
                                    List<TjConsumables> list1 = new ArrayList<>();
                                    for (TjProConsumables tjProConsumables : list) {
                                        list1.add(tjConsumablesService.getById(tjProConsumables.getConsumablesId()));
                                    }
                                    tjProject.setConsumablesList(list1);
                                }
                            }
                        }
                        aPackage.setTjProjectList(tjProjectList);
                        aPackage.setAllProName(allProName.toString());
                        aPackage.setAllSonName(allSonName.toString());
                        lisi.add(aPackage);
                    }
                }
                return AjaxResult.success(lisi);
            }
        }
        return AjaxResult.error("请输入你要查询的内容");
    }
 
 
    @PostMapping("/saveOreditTjPacNew")
    @ApiOperation(value = "体检套餐新增修改接口")
    public AjaxResult saveOreditTjPacNew(@RequestBody @ApiParam(value = "体检套餐对象") TjPackage tjPackage) {
        tjPackage.setPym(PinyinUtil.getFirstLetter(tjPackage.getPacName(),""));
        if (tjPackageService.saveOrUpdate(tjPackage)) {
            List<TjPackageProject> projectList = tjPackage.getPackageProjects();
            if (null != projectList && !projectList.isEmpty()) {
                if(StringUtil.isNotBlank(tjPackage.getPacId())){
                    ppservice.deleteTjPackageProjectByPacId(tjPackage.getPacId());
                    for (TjPackageProject project : projectList) {
                        project.setPacId(tjPackage.getPacId());
                        ppservice.save(project);
                    }
                }
            }
            return AjaxResult.success();
        }
        return AjaxResult.error();
    }
}