<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[djq8080的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/djq8080</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; djq8080]]></copyright><item><title><![CDATA[mysql 老人类型逗号隔开多个，类型分类统计数量，分组排序]]></title><link>https://blog.youkuaiyun.com/djq8080/article/details/128923449</link><guid>https://blog.youkuaiyun.com/djq8080/article/details/128923449</guid><author>djq8080</author><pubDate>Tue, 07 Feb 2023 18:08:08 +0800</pubDate><description><![CDATA[老人类型逗号隔开多个，类型分类统计数量，分组排序]]></description><category></category></item><item><title><![CDATA[计算指定日期向后推几天的日期]]></title><link>https://blog.youkuaiyun.com/djq8080/article/details/121860282</link><guid>https://blog.youkuaiyun.com/djq8080/article/details/121860282</guid><author>djq8080</author><pubDate>Fri, 10 Dec 2021 16:55:04 +0800</pubDate><description><![CDATA[指定日期向后推几天的日期
public static Date plusDay2(Date d,int num){
        SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
        Calendar ca = Calendar.getInstance();
        ca.add(Calendar.DATE, num);// num为增加的天数，可以改变的
        d = ca.getT]]></description><category></category></item><item><title><![CDATA[判断cron表达式是否在当前时间（或者指定时间）执行]]></title><link>https://blog.youkuaiyun.com/djq8080/article/details/121860024</link><guid>https://blog.youkuaiyun.com/djq8080/article/details/121860024</guid><author>djq8080</author><pubDate>Fri, 10 Dec 2021 16:52:35 +0800</pubDate><description><![CDATA[1.判断cron 表达式是否在当前时间执行
例如： cron（0 0 0 * * ? *） 是否在今天执行
public static boolean getLastRunTimeByCron(String cron) {
        List&lt;Date&gt; dates = null;
        try {
            CronTriggerImpl cronTriggerImpl = new CronTriggerImpl();
            cronTrigge]]></description><category></category></item><item><title><![CDATA[长者信息树]]></title><link>https://blog.youkuaiyun.com/djq8080/article/details/121750417</link><guid>https://blog.youkuaiyun.com/djq8080/article/details/121750417</guid><author>djq8080</author><pubDate>Mon, 06 Dec 2021 16:43:05 +0800</pubDate><description><![CDATA[public List&lt;TreeNode&gt; getServiceElderTree() {
        LoginUser user = (LoginUser) SecurityUtils.getSubject().getPrincipal();
        //获取服务中心数据
        List&lt;TreeNode&gt; orgTreeNodes = this.baseMapper.selectByOrgId(user.getOrgId());
        //获取.]]></description><category></category></item><item><title><![CDATA[mysql如何将字符串按分隔符拆分]]></title><link>https://blog.youkuaiyun.com/djq8080/article/details/119864192</link><guid>https://blog.youkuaiyun.com/djq8080/article/details/119864192</guid><author>djq8080</author><pubDate>Mon, 23 Aug 2021 10:37:12 +0800</pubDate><description><![CDATA[mysql将字符串按分隔符拆分的示例：
1.字符串拆分： SUBSTRING_INDEX（pressure 136/70 血压），例如：
SUBSTRING_INDEX(pressure ,',',1)     #截取第一个逗号（,）号以前的字符串
SUBSTRING_INDEX(pressure ,',',-1)    #截取倒数第一个逗号（,）号以后的字符串

2.替换函数：replace( str, from_str, to_str)。例如：
UPDATE bgs_building_copy1 SET]]></description><category></category></item><item><title><![CDATA[spring boot导出数据（条件筛选、字典项过滤）]]></title><link>https://blog.youkuaiyun.com/djq8080/article/details/115453789</link><guid>https://blog.youkuaiyun.com/djq8080/article/details/115453789</guid><author>djq8080</author><pubDate>Tue, 06 Apr 2021 09:18:57 +0800</pubDate><description><![CDATA[1、inspectionRecordVo传入筛选条件
	 @AutoLog(value = "导出excel")
	 @ApiOperation(value="导出excel", notes="导出excel")
	 @RequestMapping(value = "/exportInspectionXls")
	 public ModelAndView exportInspectionXls( InspectionRecordVo inspectionRecordVo,HttpServletRequest]]></description><category></category></item><item><title><![CDATA[更新和添加判断]]></title><link>https://blog.youkuaiyun.com/djq8080/article/details/113946232</link><guid>https://blog.youkuaiyun.com/djq8080/article/details/113946232</guid><author>djq8080</author><pubDate>Mon, 22 Feb 2021 17:49:23 +0800</pubDate><description><![CDATA[//判断是新增还是修改
  //2.再保存体温表格中的血压数据
            CareTemperatureTable old = careTemperatureTableService.queryOldDate(c.getCareDate(),c.getElderId());
            if (old != null) {
                //更新
                careTemperatureTableService.updateById(this]]></description><category></category></item><item><title><![CDATA[2021-01-21]]></title><link>https://blog.youkuaiyun.com/djq8080/article/details/112966379</link><guid>https://blog.youkuaiyun.com/djq8080/article/details/112966379</guid><author>djq8080</author><pubDate>Thu, 21 Jan 2021 16:39:59 +0800</pubDate><description><![CDATA[mybatis sql查询语句
&lt;select id="queryDetailByElderId" resultType="org.jeecg.modules.cost.pojo.CostBillingDetailPojo"&gt;
        SELECT
            t1.id AS elderId,
            t1.elder_number AS elderNumber,
            t1.`name` AS elderName,
           ]]></description><category></category></item><item><title><![CDATA[navicat导入excal数据时，时间导入问题]]></title><link>https://blog.youkuaiyun.com/djq8080/article/details/112318857</link><guid>https://blog.youkuaiyun.com/djq8080/article/details/112318857</guid><author>djq8080</author><pubDate>Thu, 07 Jan 2021 16:31:50 +0800</pubDate><description><![CDATA[navicat导入时间的时候可能会变成1900-10-01这样的结构
这种问题解决办法
1、将excal时间列变成转成yyyy/mm
2、Navicate中将时间字段类型改为varchar类型，然后将数据导入，查看导入时间正确，然后在将表中字段类型改回去，时间还是正确，问题解决

...]]></description><category></category></item><item><title><![CDATA[excal差单元格自动生成UUID]]></title><link>https://blog.youkuaiyun.com/djq8080/article/details/112310685</link><guid>https://blog.youkuaiyun.com/djq8080/article/details/112310685</guid><author>djq8080</author><pubDate>Thu, 07 Jan 2021 14:53:13 +0800</pubDate><description><![CDATA[1、有好几种方式这里展示我用的几种
1、Excel 生成 guid，uuid 格式：600d65bc-948a-1260-2217-fd8dfeebb1cd:
=CONCATENATE(IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEEN(1,2)=1,CHAR(RANDBETWEEN(0,9)+48),CHAR(RANDBETWEEN(0,5)+97)),IF(RANDBETWEE]]></description><category></category></item><item><title><![CDATA[java-pdf-itext7、itextpdf 生成pdf 文档 定制票据打印]]></title><link>https://blog.youkuaiyun.com/djq8080/article/details/111688981</link><guid>https://blog.youkuaiyun.com/djq8080/article/details/111688981</guid><author>djq8080</author><pubDate>Fri, 25 Dec 2020 16:47:25 +0800</pubDate><description><![CDATA[1、如果是收据或者其他不是A4大小的票据，首先将票据用打印机扫描成图片格式，用ps等工具裁剪成实际票据的大小备用。

2、设计一张实际票据大小的空白pdf模板，备用。
3、用Adobe 等pdf编辑工具打开上面制作的空白模板，点击编辑，在更多-&gt;背景-&gt;添加-&gt;选文件-&gt;浏览，选中步骤1制作的票据点击确定。
4、在菜单栏中选择准备表单，点击开始，保存到相应的文件夹。

5、在需要填入值的地方添加文本域，设置域名称，需要注意的一点

设置外观-&gt;文字大小选项中，一定设置文字大小和]]></description><category></category></item><item><title><![CDATA[redis问题解决]]></title><link>https://blog.youkuaiyun.com/djq8080/article/details/108730386</link><guid>https://blog.youkuaiyun.com/djq8080/article/details/108730386</guid><author>djq8080</author><pubDate>Tue, 22 Sep 2020 13:44:35 +0800</pubDate><description><![CDATA[先看问题：

Caused by: io.lettuce.core.RedisException: io.lettuce.core.RedisConnectionException: DENIED Redis is running in protected mode because protected mode is enabled, no bind address was specifie

一般搜寻之后的解决办法是
vim redis.conf
修改 protected-mode  yes
改为
pro]]></description><category></category></item><item><title><![CDATA[sql拼接查询]]></title><link>https://blog.youkuaiyun.com/djq8080/article/details/108596866</link><guid>https://blog.youkuaiyun.com/djq8080/article/details/108596866</guid><author>djq8080</author><pubDate>Tue, 15 Sep 2020 11:53:08 +0800</pubDate><description><![CDATA[&lt;!--月度考勤汇总list列表--&gt;
    &lt;select id="queryAttendanceSummaryList" resultType="org.jeecg.modules.oa.vo.AttendanceSummaryMonthVo"&gt;
        SELECT
            a1.id AS employeeId,
            a1.organization_id AS organizationId,
            a1.dep.]]></description><category></category></item><item><title><![CDATA[传入map、page分页]]></title><link>https://blog.youkuaiyun.com/djq8080/article/details/108530482</link><guid>https://blog.youkuaiyun.com/djq8080/article/details/108530482</guid><author>djq8080</author><pubDate>Fri, 11 Sep 2020 11:15:42 +0800</pubDate><description><![CDATA[controller 传入分页
@AutoLog(value = "安全照护-报警列表")
	 @ApiOperation(value="安全照护-报警列表", notes="安全照护-报警列表")
	 @GetMapping(value = "/queryPageInfoList")
	 public Result&lt;IPage&lt;SafetyFenceInfoVo&gt;&gt; queryPageInfoList(@RequestParam(name="safetyTime" ,require]]></description><category></category></item><item><title><![CDATA[vue 页面电话号码或者手机号验证]]></title><link>https://blog.youkuaiyun.com/djq8080/article/details/108361854</link><guid>https://blog.youkuaiyun.com/djq8080/article/details/108361854</guid><author>djq8080</author><pubDate>Wed, 02 Sep 2020 14:40:49 +0800</pubDate><description><![CDATA[//输入手机号或者座机号
&lt;a-col :md="12" :sm="8"&gt;
          &lt;a-form-item
            :labelCol="labelCol"
            :wrapperCol="wrapperCol"
            label="电话"&gt;
            &lt;a-input placeholder="请输入电话" v-decorator="['phone', validatorRules.phone ]]]></description><category></category></item><item><title><![CDATA[VUE 页面时间查询、重置后数据加载]]></title><link>https://blog.youkuaiyun.com/djq8080/article/details/108356490</link><guid>https://blog.youkuaiyun.com/djq8080/article/details/108356490</guid><author>djq8080</author><pubDate>Wed, 02 Sep 2020 10:05:17 +0800</pubDate><description><![CDATA[&lt;template&gt;
  &lt;a-card :bordered="false"&gt;

    &lt;!-- 查询区域 --&gt;
    &lt;div class="table-page-search-wrapper"&gt;
      &lt;a-form layout="inline"&gt;
        &lt;a-row :gutter="24"&gt;

          &lt;a-col :md="6" :sm="8"&gt;
            &lt;]]></description><category></category></item><item><title><![CDATA[日期区间查询处理String日期]]></title><link>https://blog.youkuaiyun.com/djq8080/article/details/108343195</link><guid>https://blog.youkuaiyun.com/djq8080/article/details/108343195</guid><author>djq8080</author><pubDate>Tue, 01 Sep 2020 15:35:44 +0800</pubDate><description><![CDATA[时间查询 _输入框提示信息“开始时间”
@RequestParam(name="startTime" ,required = false) @ApiParam(value = "开始时间") @DateTimeFormat(pattern = "yyyy-MM-dd") String startTime,
@RequestParam(name="endTime" ,required = false) @ApiParam(value = "结束时间") @DateTimeFormat(pattern = "y]]></description><category></category></item><item><title><![CDATA[单个信息翻译字典项]]></title><link>https://blog.youkuaiyun.com/djq8080/article/details/108099326</link><guid>https://blog.youkuaiyun.com/djq8080/article/details/108099326</guid><author>djq8080</author><pubDate>Wed, 19 Aug 2020 14:04:43 +0800</pubDate><description><![CDATA[public Result&lt;IPage&gt; queryById(@RequestParam(name=“id”,required=true) String id) {
	Result&lt;IPage&lt;StorageInventoryDetail&gt;&gt; result = new Result&lt;IPage&lt;StorageInventoryDetail&gt;&gt;();
	
	Page&lt;StorageInventoryDetail&gt; page = new P]]></description><category></category></item><item><title><![CDATA[嵌套返回result ,返回success]]></title><link>https://blog.youkuaiyun.com/djq8080/article/details/107357049</link><guid>https://blog.youkuaiyun.com/djq8080/article/details/107357049</guid><author>djq8080</author><pubDate>Wed, 15 Jul 2020 11:32:25 +0800</pubDate><description><![CDATA[public Result readUnread(@RequestParam(name=“employeeId”,required=true) String employeeId) {
Result result = new Result();
int num = 0;
QueryWrapper queryWrapper = new QueryWrapper&lt;&gt;();
queryWrapper.eq(“user_ids”,employeeId);
queryWrapper.eq(“del_fla]]></description><category></category></item><item><title><![CDATA[Result「?」  返回类型拼接]]></title><link>https://blog.youkuaiyun.com/djq8080/article/details/107333642</link><guid>https://blog.youkuaiyun.com/djq8080/article/details/107333642</guid><author>djq8080</author><pubDate>Tue, 14 Jul 2020 10:59:09 +0800</pubDate><description><![CDATA[Result&lt;?&gt;
@AutoLog(value = “app消息通知-已读”)
@ApiOperation(value=“app消息通知-已读”, notes=“app消息通知-已读”)
@GetMapping(value = “/queryMessageRead”)
public Result&lt;?&gt; queryMessageRead(@RequestParam(name = “sysId”) String sysId) {
SysAnnouncementSend announce]]></description><category></category></item></channel></rss>