代码 ``` /** * 2020年7月4日17:10:38 卓良晟 * 获取公积金差额月份 * @param int $jsdw_id * @param int $ygid * @return array * @throws DataNotFoundException * @throws ModelNotFoundException * @throws DbException */ public static function GjjGetCeyf($jsdw_id,$ygid=0){ $data=array(); $GjjJbxxModel_data=GjjJbxxModel::where('jituanid',session('jituanid')) ->where('jbxx_yuangong_pid',$jsdw_id) ->where(function (Query $query) use ($ygid){ if (!empty($ygid)){ $query->where('jbxx_yuangong_id',$ygid);//员工ID } }) ->where('jbxx_dz_status','>',1)//已执行过对账的 ->where('jbxx_iscedq',1)//未调取过的差额 ->field('jbxx_jsdata') ->group('jbxx_jsdata') ->select()->toArray(); foreach ($GjjJbxxModel_data as $k=>$v){ $data[]=date('Y-m',$v['jbxx_jsdata']); } return $data; } ``` 使用方法 ``` use app\gongjijin\zhuoliangsheng\GongjijinPublicModel; GongjijinPublicModel::GjjGetCeyf($jsdw_id,$ygid=0) ```