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