代碼 ``` /** * 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) ```