代码 ``` /** * 2020年7月4日17:10:38 卓良晟 * 获取社保差额月份 * @param int $jsdw_id * @param int $ygid * @return bool * @throws DataNotFoundException * @throws ModelNotFoundException * @throws DbException */ public static function SbGetCeyf($jsdw_id,$ygid=0){ $SbJbxxModel_data=SbJbxxModel::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 ($SbJbxxModel_data as $k=>$v){ $data[]=date('Y-m',$v['jbxx_jsdata']); } if (isset($data)){ return $data; }else{ return false; } } ``` 使用方法 ``` use app\shebao\zhuoliangsheng\SheBaoPublicModel; SheBaoPublicModel::SbGetCeyf($jsdw_id,$ygid=0); ```