| | |
| | | Assert.jsonObjectHaveKey(paramIn, "sex", "请求报文中未包含sex"); |
| | | Assert.jsonObjectHaveKey(paramIn, "ownerTypeCd", "请求报文中未包含sex"); |
| | | Assert.jsonObjectHaveKey(paramIn, "communityId", "请求报文中未包含communityId"); |
| | | Assert.jsonObjectHaveKey(paramIn, "idCard", "请求报文中未包含身份证号"); |
| | | |
| | | } |
| | | |
| | | /** |
| | |
| | | Assert.jsonObjectHaveKey(paramIn, "sex", "请求报文中未包含sex"); |
| | | Assert.jsonObjectHaveKey(paramIn, "ownerTypeCd", "请求报文中未包含sex"); |
| | | Assert.jsonObjectHaveKey(paramIn, "communityId", "请求报文中未包含communityId"); |
| | | Assert.jsonObjectHaveKey(paramIn, "idCard", "请求报文中未包含身份证号"); |
| | | |
| | | JSONObject paramObj = JSONObject.parseObject(paramIn); |
| | | |
| | |
| | | businessOwnerInfo.put("memberId", businessOwnerInfo.get("member_id")); |
| | | businessOwnerInfo.put("ownerTypeCd", businessOwnerInfo.get("owner_type_cd")); |
| | | businessOwnerInfo.put("communityId", businessOwnerInfo.get("community_id")); |
| | | businessOwnerInfo.put("idCard", businessOwnerInfo.get("id_card")); |
| | | businessOwnerInfo.remove("bId"); |
| | | businessOwnerInfo.put("statusCd", statusCd); |
| | | } |
| | |
| | | currentOwnerInfo.put("memberId", currentOwnerInfo.get("member_id")); |
| | | currentOwnerInfo.put("ownerTypeCd", currentOwnerInfo.get("owner_type_cd")); |
| | | currentOwnerInfo.put("communityId", currentOwnerInfo.get("community_id")); |
| | | currentOwnerInfo.put("idCard", currentOwnerInfo.get("id_card")); |
| | | |
| | | |
| | | currentOwnerInfo.put("operate", StatusConstant.OPERATE_DEL); |
| | |
| | | //Assert.jsonObjectHaveKey(pd.getReqData(), "ownerTypeCd", "请求报文中未包含ownerTypeCd节点"); |
| | | Assert.jsonObjectHaveKey(pd.getReqData(), "link", "请求报文中未包含link"); |
| | | Assert.jsonObjectHaveKey(pd.getReqData(), "sex", "请求报文中未包含sex"); |
| | | Assert.jsonObjectHaveKey(pd.getReqData(), "idCard", "请求报文中未包含身份证号"); |
| | | Assert.jsonObjectHaveKey(pd.getReqData(), "remark", "未包含小区楼备注"); |
| | | } |
| | | |
| | |
| | | Assert.jsonObjectHaveKey(pd.getReqData(), "name", "请求报文中未包含name"); |
| | | Assert.jsonObjectHaveKey(pd.getReqData(), "link", "请求报文中未包含link"); |
| | | Assert.jsonObjectHaveKey(pd.getReqData(), "sex", "请求报文中未包含sex"); |
| | | Assert.jsonObjectHaveKey(pd.getReqData(), "idCard", "请求报文中未包含身份证号"); |
| | | Assert.jsonObjectHaveKey(pd.getReqData(), "remark", "未包含小区楼备注"); |
| | | } |
| | | |
| | |
| | | placeholder="必填,请填写年龄" class="form-control"></div> |
| | | </div> |
| | | <div class="form-group row"> |
| | | <label class="col-sm-2 col-form-label">身份证</label> |
| | | <div class="col-sm-10"><input v-model="addOwnerInfo.idCard" type="number" |
| | | placeholder="必填,请填写身份证" class="form-control"></div> |
| | | </div> |
| | | <div class="form-group row"> |
| | | <label class="col-sm-2 col-form-label">手机</label> |
| | | <div class="col-sm-10"><input v-model="addOwnerInfo.link" type="number" |
| | | placeholder="必填,请填写联系方式" class="form-control"></div> |
| | |
| | | remark:'', |
| | | ownerId:'', |
| | | ownerPhoto:'', |
| | | idCard:'', |
| | | videoPlaying:false |
| | | } |
| | | }, |
| | |
| | | errInfo:"性别不能为空" |
| | | } |
| | | ], |
| | | 'addOwnerInfo.idCard':[ |
| | | { |
| | | limit:"required", |
| | | param:"", |
| | | errInfo:"身份证号不能为空" |
| | | }, |
| | | { |
| | | limit:"idCard", |
| | | param:"", |
| | | errInfo:"不是有效的身份证号" |
| | | } |
| | | ], |
| | | 'addOwnerInfo.link':[ |
| | | { |
| | | limit:"required", |
| | |
| | | placeholder="必填,请填写年龄" class="form-control"></div> |
| | | </div> |
| | | <div class="form-group row"> |
| | | <label class="col-sm-2 col-form-label">身份证</label> |
| | | <div class="col-sm-10"><input v-model="editOwnerInfo.idCard" type="number" |
| | | placeholder="必填,请填写身份证" class="form-control"></div> |
| | | </div> |
| | | <div class="form-group row"> |
| | | <label class="col-sm-2 col-form-label">手机</label> |
| | | <div class="col-sm-10"><input v-model="editOwnerInfo.link" type="number" |
| | | placeholder="必填,请填写联系方式" class="form-control"></div> |
| | |
| | | (function(vc){ |
| | | var _fileUrl = 'https://hc.demo.winqi.cn/callComponent/download/getFile/fileByObjId'; |
| | | //var _fileUrl = 'https://hc.demo.winqi.cn/callComponent/download/getFile/fileByObjId'; |
| | | var _fileUrl = '/callComponent/download/getFile/fileByObjId'; |
| | | vc.extends({ |
| | | propTypes: { |
| | | notifyLoadDataComponentName:vc.propTypes.string |
| | |
| | | sex:'', |
| | | remark:'', |
| | | ownerPhoto:'', |
| | | idCard:'', |
| | | videoPlaying:false |
| | | } |
| | | }, |
| | |
| | | errInfo:"性别不能为空" |
| | | } |
| | | ], |
| | | 'editOwnerInfo.idCard':[ |
| | | { |
| | | limit:"required", |
| | | param:"", |
| | | errInfo:"身份证号不能为空" |
| | | }, |
| | | { |
| | | limit:"idCard", |
| | | param:"", |
| | | errInfo:"不是有效的身份证号" |
| | | } |
| | | ], |
| | | 'editOwnerInfo.link':[ |
| | | { |
| | | limit:"required", |
| | |
| | | <th data-hide="phone">名称</th> |
| | | <th data-hide="phone">性别</th> |
| | | <th data-hide="phone">年龄</th> |
| | | <th data-hide="phone">身份证</th> |
| | | <th data-hide="phone">联系方式</th> |
| | | <th data-hide="phone">创建员工</th> |
| | | <th data-hide="phone">备注</th> |
| | |
| | | {{owner.age}} |
| | | </td> |
| | | <td> |
| | | {{owner.idCard}} |
| | | </td> |
| | | <td> |
| | | {{owner.link}} |
| | | </td> |
| | | <td> |
| | |
| | | <div class="ibox-title"> |
| | | <h5>查询条件</h5> |
| | | <div class="ibox-tools" style="top:10px;"> |
| | | <!-- <button type="button" class="btn btn-link btn-sm" style="margin-right:10px;" |
| | | v-on:click="_moreCondition()">更多 |
| | | </button>--> |
| | | <div class="ibox-tools" style="top:10px;"> |
| | | <button type="button" class="btn btn-link btn-sm" style="margin-right:10px;" |
| | | v-on:click="_moreCondition()">{{listOwnerInfo.moreCondition == true?'隐藏':'更多'}} |
| | | </button> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div class="ibox-content"> |
| | |
| | | </div> |
| | | |
| | | </div> |
| | | <div class="row" v-if="listOwnerInfo.moreCondition == true"> |
| | | |
| | | <div class="col-sm-4"> |
| | | <div class="form-group"> |
| | | <input type="text" placeholder="请输入业主身份证号" |
| | | v-model="listOwnerInfo.conditions.idCard" class=" form-control"> |
| | | </div> |
| | | </div> |
| | | |
| | | |
| | | </div> |
| | | |
| | | |
| | | </div> |
| | |
| | | <th data-hide="phone">名称</th> |
| | | <th data-hide="phone">性别</th> |
| | | <th data-hide="phone">年龄</th> |
| | | <th data-hide="phone">身份证</th> |
| | | <th data-hide="phone">联系方式</th> |
| | | <th data-hide="phone">创建员工</th> |
| | | <th class="text-right">操作</th> |
| | |
| | | {{owner.age}} |
| | | </td> |
| | | <td> |
| | | {{owner.idCard}} |
| | | </td> |
| | | <td> |
| | | {{owner.link}} |
| | | </td> |
| | | <td> |
| | |
| | | owners:[], |
| | | total:0, |
| | | records:1, |
| | | moreCondition: false, |
| | | _currentOwnerId:'', |
| | | _eventName:'', |
| | | conditions:{ |
| | | ownerTypeCd:'1001', |
| | | ownerId:'', |
| | | name:'', |
| | | link:'' |
| | | link:'', |
| | | idCard:'' |
| | | } |
| | | } |
| | | }, |
| | |
| | | console.log('请求失败处理'); |
| | | } |
| | | ); |
| | | }, |
| | | _moreCondition: function () { |
| | | if (vc.component.listOwnerInfo.moreCondition) { |
| | | vc.component.listOwnerInfo.moreCondition = false; |
| | | } else { |
| | | vc.component.listOwnerInfo.moreCondition = true; |
| | | } |
| | | } |
| | | } |
| | | }) |
| | |
| | | <div class="row"> |
| | | <div class="col-sm-3"> |
| | | <div class="form-group"> |
| | | <label class="col-form-label">身份证:</label> |
| | | <label class="">{{ownerInfo.idCard}}</label> |
| | | </div> |
| | | </div> |
| | | <div class="col-sm-3"> |
| | | <div class="form-group"> |
| | | <label class="col-form-label">联系方式:</label> |
| | | <label class="">{{ownerInfo.link}}</label> |
| | | </div> |
| | |
| | | <label class="">{{ownerInfo.userName}}</label> |
| | | </div> |
| | | </div> |
| | | <div class="col-sm-6"> |
| | | <div class="col-sm-3"> |
| | | <div class="form-group"> |
| | | <label class="col-form-label">备注:</label> |
| | | <label class="">{{ownerInfo.remark}}</label> |
| | |
| | | sex:"", |
| | | userName:"", |
| | | remark:"", |
| | | idCard:"", |
| | | link:"", |
| | | sexName:'' |
| | | } |
| | |
| | | <th>名称</th> |
| | | <th>性别</th> |
| | | <th>年龄</th> |
| | | <th>身份证</th> |
| | | <th>联系方式</th> |
| | | <th>创建员工</th> |
| | | <th>备注</th> |
| | | <th>操作</th> |
| | | </tr> |
| | | </thead> |
| | |
| | | {{owner.age}} |
| | | </td> |
| | | <td> |
| | | {{owner.idCard}} |
| | | </td> |
| | | <td> |
| | | {{owner.link}} |
| | | </td> |
| | | <td> |
| | | {{owner.userName}} |
| | | </td> |
| | | <td> |
| | | {{owner.remark}} |
| | | </td> |
| | | <td> |
| | | <button class="btn btn-primary btn-xs" v-on:click="chooseOwner(owner)">选择 |
| | |
| | | <div class="ibox-content"> |
| | | <div class="row"> |
| | | <div class="col-sm-3"> |
| | | <div class="form-group"> |
| | | <label class="col-form-label">业主ID:</label> |
| | | <label class="">{{viewOwnerInfo.ownerId}}</label> |
| | | </div> |
| | | <image width="120px" height="140px" src="viewOwnerInfo.ownerPhoto"/> |
| | | </div> |
| | | <div class="col-sm-3"> |
| | | <div class="form-group"> |
| | | <label class="col-form-label">名称:</label> |
| | | <label class="">{{viewOwnerInfo.name}}</label> |
| | | <div class="col-sm-9"> |
| | | <div class="row"> |
| | | <div class="col-sm-3"> |
| | | <div class="form-group"> |
| | | <label class="col-form-label">业主ID:</label> |
| | | <label class="">{{viewOwnerInfo.ownerId}}</label> |
| | | </div> |
| | | </div> |
| | | <div class="col-sm-3"> |
| | | <div class="form-group"> |
| | | <label class="col-form-label">名称:</label> |
| | | <label class="">{{viewOwnerInfo.name}}</label> |
| | | </div> |
| | | </div> |
| | | <div class="col-sm-3"> |
| | | <div class="form-group"> |
| | | <label class="col-form-label">性别:</label> |
| | | <label class="">{{viewOwnerInfo.sex == 0 ? '男' : '女'}}</label> |
| | | </div> |
| | | </div> |
| | | <div class="col-sm-3"> |
| | | <div class="form-group"> |
| | | <label class="col-form-label">年龄:</label> |
| | | <label class="">{{viewOwnerInfo.age}}</label> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | <div class="col-sm-3"> |
| | | <div class="form-group"> |
| | | <label class="col-form-label">性别:</label> |
| | | <label class="">{{viewOwnerInfo.sex == 0 ? '男' : '女'}}</label> |
| | | </div> |
| | | </div> |
| | | <div class="col-sm-3"> |
| | | <div class="form-group"> |
| | | <label class="col-form-label">年龄:</label> |
| | | <label class="">{{viewOwnerInfo.age}}</label> |
| | | </div> |
| | | </div> |
| | | |
| | | <div class="row"> |
| | | <div class="col-sm-3"> |
| | | <div class="form-group"> |
| | | <label class="col-form-label">身份证:</label> |
| | | <label class="">{{viewOwnerInfo.idCard}}</label> |
| | | </div> |
| | | </div> |
| | | <div class="col-sm-3"> |
| | | <div class="form-group"> |
| | | <label class="col-form-label">联系方式:</label> |
| | | <label class="">{{viewOwnerInfo.link}}</label> |
| | | </div> |
| | | </div> |
| | | <div class="col-sm-3"> |
| | | <div class="form-group"> |
| | | <label class="col-form-label">创建员工:</label> |
| | | <label class="">{{viewOwnerInfo.userName}}</label> |
| | | </div> |
| | | </div> |
| | | <div class="col-sm-3"> |
| | | <div class="form-group"> |
| | | <label class="col-form-label">备注:</label> |
| | | <label class="">{{viewOwnerInfo.remark}}</label> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | | |
| | | <div class="row"> |
| | | <div class="col-sm-3"> |
| | | <div class="form-group"> |
| | | <label class="col-form-label">联系方式:</label> |
| | | <label class="">{{viewOwnerInfo.link}}</label> |
| | | </div> |
| | | </div> |
| | | <div class="col-sm-3"> |
| | | <div class="form-group"> |
| | | <label class="col-form-label">创建员工:</label> |
| | | <label class="">{{viewOwnerInfo.userName}}</label> |
| | | </div> |
| | | </div> |
| | | <div class="col-sm-6"> |
| | | <div class="form-group"> |
| | | <label class="col-form-label">备注:</label> |
| | | <label class="">{{viewOwnerInfo.remark}}</label> |
| | | </div> |
| | | </div> |
| | | |
| | | </div> |
| | | </div> |
| | | </div> |
| | | </div> |
| | |
| | | sex:"", |
| | | userName:"", |
| | | remark:"", |
| | | idCard:"", |
| | | link:"", |
| | | ownerPhoto:"/img/noPhoto.gif", |
| | | showCallBackButton:$props.showCallBackButton |
| | | } |
| | | }, |
| | |
| | | function(json,res){ |
| | | var listOwnerData =JSON.parse(json); |
| | | vc.copyObject(listOwnerData.owners[0],vc.component.viewOwnerInfo); |
| | | //加载图片 |
| | | vc.component._loadOwnerPhoto(); |
| | | },function(errInfo,error){ |
| | | console.log('请求失败处理'); |
| | | } |
| | |
| | | }, |
| | | _callBackListOwner:function(_ownerId){ |
| | | vc.jumpToPage("/flow/ownerFlow?ownerId="+_ownerId); |
| | | }, |
| | | _loadOwnerPhoto:function(){ |
| | | vc.component.viewOwnerInfo.ownerPhoto = _fileUrl+"?objId="+ |
| | | vc.component.viewOwnerInfo.ownerId +"&communityId="+vc.getCurrentCommunity().communityId+"&fileTypeCd=10000&time="+new Date(); |
| | | } |
| | | |
| | | } |
| | |
| | | private String roomNum; |
| | | private String psId; |
| | | private String num; |
| | | private String idCard; |
| | | |
| | | private String bId; |
| | | |
| | |
| | | public void setbId(String bId) { |
| | | this.bId = bId; |
| | | } |
| | | |
| | | public String getIdCard() { |
| | | return idCard; |
| | | } |
| | | |
| | | public void setIdCard(String idCard) { |
| | | this.idCard = idCard; |
| | | } |
| | | } |
| | |
| | | |
| | | private String ownerTypeCd; |
| | | |
| | | private String idCard; |
| | | |
| | | public String getOwnerId() { |
| | | return ownerId; |
| | | } |
| | |
| | | public void setOwnerTypeCd(String ownerTypeCd) { |
| | | this.ownerTypeCd = ownerTypeCd; |
| | | } |
| | | |
| | | public String getIdCard() { |
| | | return idCard; |
| | | } |
| | | |
| | | public void setIdCard(String idCard) { |
| | | this.idCard = idCard; |
| | | } |
| | | } |
| | |
| | | <!-- 保存业主信息 add by wuxw 2018-07-03 --> |
| | | <insert id="saveBusinessOwnerInfo" parameterType="Map"> |
| | | insert into business_building_owner( |
| | | operate,sex,name,link,remark,owner_id,b_id,user_id,age,member_id,owner_type_cd,community_id |
| | | operate,sex,name,link,remark,owner_id,b_id,user_id,age,member_id,owner_type_cd,community_id,id_card |
| | | ) values ( |
| | | #{operate},#{sex},#{name},#{link},#{remark},#{ownerId},#{bId},#{userId},#{age},#{memberId},#{ownerTypeCd},#{communityId} |
| | | #{operate},#{sex},#{name},#{link},#{remark},#{ownerId},#{bId},#{userId},#{age},#{memberId},#{ownerTypeCd},#{communityId},#{idCard} |
| | | ) |
| | | </insert> |
| | | |
| | |
| | | <!-- 查询业主信息(Business) add by wuxw 2018-07-03 --> |
| | | <select id="getBusinessOwnerInfo" parameterType="Map" resultType="Map"> |
| | | select t.operate,t.sex,t.name,t.link,t.remark,t.owner_id,t.owner_id ownerId,t.b_id,t.b_id bId, |
| | | t.user_id,t.user_id userId,t.age,t.member_id,t.member_id memberId,t.owner_type_cd,t.owner_type_cd ownerTypeCd,t.community_id,t.community_id communityId |
| | | t.user_id,t.user_id userId,t.age,t.member_id,t.member_id memberId,t.owner_type_cd, |
| | | t.owner_type_cd ownerTypeCd,t.community_id,t.community_id communityId, |
| | | t.id_card, t.id_card idCard |
| | | from business_building_owner t |
| | | where 1 =1 |
| | | <if test="operate !=null and operate != ''"> |
| | |
| | | <if test="communityId !=null and communityId != ''"> |
| | | and t.community_id= #{communityId} |
| | | </if> |
| | | <if test="idCard !=null and idCard != ''"> |
| | | and t.id_card = #{idCard} |
| | | </if> |
| | | <if test="bId !=null and bId != ''"> |
| | | and t.b_id= #{bId} |
| | | </if> |
| | |
| | | <!-- 保存业主信息至 instance表中 add by wuxw 2018-07-03 --> |
| | | <insert id="saveOwnerInfoInstance" parameterType="Map"> |
| | | insert into building_owner( |
| | | sex,name,link,status_cd,remark,owner_id,b_id,user_id,age,member_id,owner_type_cd,community_id |
| | | ) select t.sex,t.name,t.link,'0',t.remark,t.owner_id,t.b_id,t.user_id,t.age,t.member_id,t.owner_type_cd,t.community_id communityId |
| | | sex,name,link,status_cd,remark,owner_id,b_id,user_id,age,member_id,owner_type_cd,community_id,id_card |
| | | ) select t.sex,t.name,t.link,'0',t.remark,t.owner_id,t.b_id,t.user_id,t.age,t.member_id,t.owner_type_cd, |
| | | t.community_id communityId,t.id_card |
| | | from business_building_owner t where 1=1 |
| | | and t.operate= 'ADD' |
| | | <if test="sex !=null"> |
| | |
| | | </if> |
| | | <if test="communityId !=null and communityId != ''"> |
| | | and t.community_id= #{communityId} |
| | | </if> |
| | | <if test="idCard !=null and idCard != ''"> |
| | | and t.id_card = #{idCard} |
| | | </if> |
| | | <if test="bId !=null and bId != ''"> |
| | | and t.b_id= #{bId} |
| | |
| | | <select id="getOwnerInfo" parameterType="Map" resultType="Map"> |
| | | select t.sex,t.name,t.link,t.status_cd,t.status_cd statusCd,t.remark, |
| | | t.owner_id,t.owner_id ownerId,t.b_id,t.b_id bId, |
| | | t.user_id,t.user_id userId,t.age,t.member_id,t.member_id memberId,t.owner_type_cd,t.owner_type_cd ownerTypeCd,t.create_time createTime,t.community_id,t.community_id communityId |
| | | t.user_id,t.user_id userId,t.age,t.member_id,t.member_id memberId,t.owner_type_cd, |
| | | t.owner_type_cd ownerTypeCd,t.create_time createTime,t.community_id, |
| | | t.community_id communityId,t.id_card, t.id_card idCard |
| | | from building_owner t |
| | | where 1 =1 |
| | | <if test="sex !=null"> |
| | |
| | | </if> |
| | | <if test="communityId !=null and communityId != ''"> |
| | | and t.community_id= #{communityId} |
| | | </if> |
| | | <if test="idCard !=null and idCard != ''"> |
| | | and t.id_card = #{idCard} |
| | | </if> |
| | | <if test="bId !=null and bId != ''"> |
| | | and t.b_id= #{bId} |
| | |
| | | <if test="communityId !=null and communityId != ''"> |
| | | and t.community_id= #{communityId} |
| | | </if> |
| | | <if test="idCard !=null and idCard != ''"> |
| | | and t.id_card = #{idCard} |
| | | </if> |
| | | <if test="bId !=null and bId != ''"> |
| | | and t.b_id= #{bId} |
| | | </if> |
| | |
| | | <if test="age !=null and age != ''"> |
| | | , t.age= #{age} |
| | | </if> |
| | | <if test="idCard !=null and idCard != ''"> |
| | | , t.id_card = #{idCard} |
| | | </if> |
| | | where 1=1 |
| | | <if test="bId !=null and bId != ''"> |
| | | and t.b_id= #{bId} |
| | |
| | | </if> |
| | | <if test="communityId !=null and communityId != ''"> |
| | | and t.community_id= #{communityId} |
| | | </if> |
| | | <if test="idCard !=null and idCard != ''"> |
| | | and t.id_card = #{idCard} |
| | | </if> |
| | | <if test="bId !=null and bId != ''"> |
| | | and t.b_id= #{bId} |
| | |
| | | <if test="communityId !=null and communityId != ''"> |
| | | and t.community_id= #{communityId} |
| | | </if> |
| | | <if test="idCard !=null and idCard != ''"> |
| | | and t.id_card = #{idCard} |
| | | </if> |
| | | <if test="bId !=null and bId != ''"> |
| | | and t.b_id= #{bId} |
| | | </if> |
| | |
| | | <select id="getOwnerInfoByCondition" parameterType="Map" resultType="Map"> |
| | | select t.sex,t.name,t.link,t.status_cd,t.status_cd statusCd,t.remark,t.owner_id,t.owner_id ownerId,t.b_id,t.b_id |
| | | bId, |
| | | t.user_id,t.user_id userId,t.age,t.member_id,t.member_id memberId,t.owner_type_cd,t.owner_type_cd ownerTypeCd,t.community_id,t.community_id communityId |
| | | t.user_id,t.user_id userId,t.age,t.member_id,t.member_id memberId, |
| | | t.owner_type_cd,t.owner_type_cd ownerTypeCd,t.community_id, |
| | | t.community_id communityId,t.id_card, t.id_card idCard |
| | | FROM building_owner t , s_community_member cm |
| | | WHERE t.`member_id` = cm.`member_id` |
| | | AND cm.`community_id` = #{communityId} |
| | |
| | | </if> |
| | | <if test="communityId !=null and communityId != ''"> |
| | | and t.community_id= #{communityId} |
| | | </if> |
| | | <if test="idCard !=null and idCard != ''"> |
| | | and t.id_card = #{idCard} |
| | | </if> |
| | | <if test="bId !=null and bId != ''"> |
| | | and t.b_id= #{bId} |
| | |
| | | SELECT t.sex,t.name,t.link,t.status_cd,t.status_cd statusCd,t.remark,t.owner_id,t.owner_id ownerId,t.b_id,t.b_id |
| | | bId, |
| | | t.user_id,t.user_id userId,t.age,t.member_id,t.member_id memberId,t.owner_type_cd,t.owner_type_cd ownerTypeCd, |
| | | r.`room_id` roomId,r.`room_num` roomNum,t.community_id,t.community_id communityId |
| | | r.`room_id` roomId,r.`room_num` roomNum,t.community_id,t.community_id communityId,t.id_card, t.id_card idCard |
| | | FROM building_room r,building_owner_room_rel orr,building_owner t |
| | | WHERE r.`room_id` = orr.`room_id` |
| | | AND orr.`owner_id` = t.`owner_id` |
| | |
| | | |
| | | select ps.num,ps.ps_id psId,t.sex,t.name,t.link,t.status_cd,t.status_cd statusCd,t.remark,t.owner_id,t.owner_id |
| | | ownerId,t.b_id,t.b_id bId, |
| | | t.user_id,t.user_id userId,t.age,t.member_id,t.member_id memberId,t.owner_type_cd,t.owner_type_cd ownerTypeCd |
| | | t.user_id,t.user_id userId,t.age,t.member_id,t.member_id memberId, |
| | | t.owner_type_cd,t.owner_type_cd ownerTypeCd,t.id_card, t.id_card idCard |
| | | from p_parking_space ps , owner_car oc,building_owner t |
| | | where ps.ps_id = oc.ps_id |
| | | and oc.owner_id = t.owner_id |
| | |
| | | money:function(text){ |
| | | var regMoney = /^\d+\.?\d{0,2}$/; |
| | | return regMoney.test(text); |
| | | }, |
| | | idCard:function(num){ |
| | | num = num.toUpperCase(); |
| | | //身份证号码为15位或者18位,15位时全为数字,18位前17位为数字,最后一位是校验位,可能为数字或字符X。 |
| | | if (!(/(^\d{15}$)|(^\d{17}([0-9]|X)$)/.test(num))) { |
| | | return false; |
| | | } |
| | | //校验位按照ISO 7064:1983.MOD 11-2的规定生成,X可以认为是数字10。 |
| | | //下面分别分析出生日期和校验位 |
| | | var len, re; |
| | | len = num.length; |
| | | if (len == 15) { |
| | | re = new RegExp(/^(\d{6})(\d{2})(\d{2})(\d{2})(\d{3})$/); |
| | | var arrSplit = num.match(re); |
| | | |
| | | //检查生日日期是否正确 |
| | | var dtmBirth = new Date('19' + arrSplit[2] + '/' + arrSplit[3] + '/' + arrSplit[4]); |
| | | var bGoodDay; |
| | | bGoodDay = (dtmBirth.getYear() == Number(arrSplit[2])) && ((dtmBirth.getMonth() + 1) == Number(arrSplit[3])) && (dtmBirth.getDate() == Number(arrSplit[4])); |
| | | if (!bGoodDay) { |
| | | return false; |
| | | } |
| | | else { |
| | | //将15位身份证转成18位 |
| | | //校验位按照ISO 7064:1983.MOD 11-2的规定生成,X可以认为是数字10。 |
| | | var arrInt = new Array(7, 9, 10, 5, 8, 4, 2, 1, 6, 3, 7, 9, 10, 5, 8, 4, 2); |
| | | var arrCh = new Array('1', '0', 'X', '9', '8', '7', '6', '5', '4', '3', '2'); |
| | | var nTemp = 0, i; |
| | | num = num.substr(0, 6) + '19' + num.substr(6, num.length - 6); |
| | | for (i = 0; i < 17; i++) { |
| | | nTemp += num.substr(i, 1) * arrInt[i]; |
| | | } |
| | | num += arrCh[nTemp % 11]; |
| | | return true; |
| | | } |
| | | } |
| | | if (len == 18) { |
| | | re = new RegExp(/^(\d{6})(\d{4})(\d{2})(\d{2})(\d{3})([0-9]|X)$/); |
| | | var arrSplit = num.match(re); |
| | | |
| | | //检查生日日期是否正确 |
| | | var dtmBirth = new Date(arrSplit[2] + "/" + arrSplit[3] + "/" + arrSplit[4]); |
| | | var bGoodDay; |
| | | bGoodDay = (dtmBirth.getFullYear() == Number(arrSplit[2])) && ((dtmBirth.getMonth() + 1) == Number(arrSplit[3])) && (dtmBirth.getDate() == Number(arrSplit[4])); |
| | | if (!bGoodDay) { |
| | | // alert(dtmBirth.getYear()); |
| | | // alert(arrSplit[2]); |
| | | return false; |
| | | } |
| | | else { |
| | | //检验18位身份证的校验码是否正确。 |
| | | //校验位按照ISO 7064:1983.MOD 11-2的规定生成,X可以认为是数字10。 |
| | | var valnum; |
| | | var arrInt = new Array(7, 9, 10, 5, 8, 4, 2, 1, 6, 3, 7, 9, 10, 5, 8, 4, 2); |
| | | var arrCh = new Array('1', '0', 'X', '9', '8', '7', '6', '5', '4', '3', '2'); |
| | | var nTemp = 0, i; |
| | | for (i = 0; i < 17; i++) { |
| | | nTemp += num.substr(i, 1) * arrInt[i]; |
| | | } |
| | | valnum = arrCh[nTemp % 11]; |
| | | if (valnum != num.substr(17, 1)) { |
| | | return false; |
| | | } |
| | | return true; |
| | | } |
| | | } |
| | | return false; |
| | | } |
| | | |
| | | }; |
| | |
| | | if(configObj.limit == 'money'){ |
| | | validate.setState(validate.money(tmpDataObj),configObj.errInfo); |
| | | } |
| | | |
| | | if(configObj.limit == 'idCard'){ |
| | | validate.setState(validate.idCard(tmpDataObj),configObj.errInfo); |
| | | } |
| | | }); |
| | | |
| | | } |