首页  思维导图  详情

h5接口业务

2016-11-18 17:59:15   0  举报





仅支持查看

AI智能生成

h5接口业务

工作资料

作者其他创作

大纲/内容

<div>/h5ser/checkPhone</div><div>(接口入口 H5服务（手机验证））</div>

saveUserIden

UPDATE TB_H5_USER SET USERIDEN=? WHERE USERPHONE = ?

根据手机号更新用户身份

成功返回1,失败返回0

getUserIdByUserPhone

根据用户手机号获取用户id,查到手机号返回id,否则新建一条数据返回id

如果用户为大卡用户从tb_h5_user中没有手机号，保存用户时需要获取大卡用户的用户身份、大卡身份是否认证、开放平台用户身份

 TB_H5_USER 

调用大卡的service

<div><span class="Apple-tab-span" style="white-space: pre;"> </span>@Autowired</div><div><span class="Apple-tab-span" style="white-space: pre;"> </span>private RmUserService rmUserService;</div>

pom.xml关联的jar

<div><dependency></div><div><span class="Apple-tab-span" style="white-space: pre;"> </span><groupId>com.sinoiov.lhjh.lhjh-rm</groupId></div><div><span class="Apple-tab-span" style="white-space: pre;"> </span><artifactId>rm-interface</artifactId></div><div><span class="Apple-tab-span" style="white-space: pre;"> </span><version>1.0.0</version></div><div></dependency></div>

phone

微信公众号整合-登录回调接口（微信公众号菜单配置的链接地址中的redirect_uri）手机是否验证

1.调用微信认证API获取openId

微信id获取配置

<div>api_weixin_access_token=https://api.weixin.qq.com/sns/oauth2/access_token?appid=wx8e30a8c5ce9bfe11&secret=dd6ad71883f3bbce49c1e96f30229472&grant_type=authorization_code&code=#code#</div><div><br></div>

AuthAccessToken  javaBean

微信授权-通过code换取网页授权access_token请求返回JSON实体

2.微信id是否已经验证了手机号

SELECT USERPHONE FROM TB_H5_USER WHERE WXUID= ? 

3.微信手机号加密加密

4.#h5用户令牌  1是微信token<div>user_token=1_E050A8C072665D81D285881399F20003,2_C81D2E050A5399F8C072682000365881,3_C81D2E050A5399F8D285881399F20003,4_0C92C771A4ED4291A482B87C70763AA1_123,4_116E9BF068114ACDA0EBB1BA4FCF60BB_456,5_A7ACCEE74D644FB5B66F032EDE540129_789</div>

5.根据serviceCode判断是找车页面还是找货页面

<table border="0" cellpadding="0" cellspacing="0" width="1269" style="border-collapse: collapse;width:952pt"> <colgroup><col width="72" style="width:54pt"> <col width="154" style="mso-width-source:userset;mso-width-alt:4928;width:116pt"> <col width="1043" style="mso-width-source:userset;mso-width-alt:33376; width:782pt"> </colgroup><tbody><tr height="26" style="mso-height-source:userset;height:19.5pt"> <td height="26" class="xl65" width="72" style="height:19.5pt;width:54pt">　</td> <td class="xl66" width="154" style="width:116pt">首页页面</td> <td class="xl66" width="1043" style="width:782pt">url+参数</td> </tr> <tr height="18" style="height:13.5pt"> <td height="18" align="right" style="height:13.5pt">1</td> <td>找车页面带我的货源</td> <td class="xl67"><a href="https://wxbeta.95155.com/vehicles.html?token=C81D2E050A5399F8D285881399F20003&flag=3&show=1&userPhone=18810441007">https://wxbeta.95155.com/vehicles.html?token=C81D2E050A5399F8D285881399F20003&flag=3&show=1&userPhone=18810441007</a></td> </tr> <tr height="18" style="height:13.5pt"> <td height="18" align="right" style="height:13.5pt">2</td> <td>找货页面带我的车源</td> <td class="xl67"><a href="https://wxbeta.95155.com/index.html?token=C81D2E050A5399F8D285881399F20003&flag=3&show=1&userPhone=18810441007">https://wxbeta.95155.com/index.html?token=C81D2E050A5399F8D285881399F20003&flag=3&show=1&userPhone=18810441007</a></td> </tr> <tr height="18" style="height:13.5pt"> <td height="18" align="right" style="height:13.5pt">3</td> <td>找车页面</td> <td class="xl67"><a href="https://wxbeta.95155.com/vehicles.html?token=C81D2E050A5399F8D285881399F20003&flag=3&show=0&userPhone=18810441007">https://wxbeta.95155.com/vehicles.html?token=C81D2E050A5399F8D285881399F20003&flag=3&show=0&userPhone=18810441007</a></td> </tr> <tr height="18" style="height:13.5pt"> <td height="18" align="right" style="height:13.5pt">4</td> <td>找货页面</td> <td class="xl67"><a href="https://wxbeta.95155.com/index.html?token=C81D2E050A5399F8D285881399F20003&flag=3&show=0&userPhone=18810441007">https://wxbeta.95155.com/index.html?token=C81D2E050A5399F8D285881399F20003&flag=3&show=0&userPhone=18810441007</a></td> </tr> <tr height="18" style="height:13.5pt"> <td height="18" align="right" style="height:13.5pt">5</td> <td>我的货源页面</td> <td class="xl67"><a href="https://wxbeta.95155.com/page-cargo/mycargo.html?token=C81D2E050A5399F8D285881399F20003&flag=3&index=1&userPhone=18810441007">https://wxbeta.95155.com/page-cargo/mycargo.html?token=C81D2E050A5399F8D285881399F20003&flag=3&index=1&userPhone=18810441007</a></td> </tr> <tr height="18" style="height:13.5pt"> <td height="18" align="right" style="height:13.5pt">6</td> <td>我的车源页面</td> <td class="xl67"><a href="https://wxbeta.95155.com/page-vehicles/mine-vehicles.html?token=C81D2E050A5399F8D285881399F20003&flag=3&index=1&userPhone=18810441007">https://wxbeta.95155.com/page-vehicles/mine-vehicles.html?token=C81D2E050A5399F8D285881399F20003&flag=3&index=1&userPhone=18810441007</a></td> </tr> <tr height="18" style="height:13.5pt"> <td height="18" style="height:13.5pt"></td> <td></td> <td></td> </tr> <tr height="18" style="height:13.5pt"> <td height="18" style="height:13.5pt"></td> <td></td> <td></td> </tr> <tr height="18" style="height:13.5pt"> <td height="18" class="xl68" style="height:13.5pt">参数说明</td> <td></td> <td></td> </tr> <tr height="18" style="height:13.5pt"> <td height="18" colspan="3" style="height:13.5pt;mso-ignore:colspan">show=1或无此参数：当前首页嵌入我的货源/我的车源按钮；</td> </tr> <tr height="18" style="height:13.5pt"> <td height="18" colspan="2" style="height:13.5pt;mso-ignore:colspan">show=0：单独的找车页面；</td> <td></td> </tr> <tr height="18" style="height:13.5pt"> <td height="18" style="height:13.5pt"></td> <td></td> <td></td> </tr> <tr height="18" style="height:13.5pt"> <td height="18" colspan="2" style="height:13.5pt;mso-ignore:colspan">index=1：当前页面为首页；</td> <td></td> </tr> <tr height="18" style="height:13.5pt"> <td height="18" colspan="3" style="height:13.5pt;mso-ignore:colspan">index=0或无此参数：当前页面不是首页；</td> </tr></tbody></table>

<div>#微信跳转页面的时候添加https头部</div><div>WX_SKIP_URL=https://wxbeta.95155.com</div>

6.response.sendRedirect(url);

sendCode

手机验证页面请求验证码，发送验证码接口

redis db (openAPIDB )  table（weixinPhone）存储验证码

规则

phoneCode = (int)(Math.random()*9000+1000) + "";

String key = uid + "_" + phone;

<div>//存储验证码  到  缓存</div><div>checkPhoneDao.addPhoneCodetoRedis(key, PHONECODE_VALID_TIME, phoneCode);</div>

 com.sinoiov.h5ser.hessian.service;   private SMSService smsService;

<div>#发送短信调用路径</div><div>smsService.hessianURL=http://192.168.110.141:8082/MessageCenter/hessian/smsService</div>

phoneCode

手机验证码验证接口

<div>#微信用新手机号绑定，将原来绑定关系中的微信id置空</div><div>delWXidByUserWXid=UPDATE TB_H5_USER SET WXUID='' WHERE WXUID = ?</div>

一个用户对应多个手机号，每个手机号对应一个h5用户，微信id只能绑定用户其中一个手机号。

<div>H5UserBean h5UserBean = publicDao.queryUserInfoByPhone(phone);</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>if(h5UserBean==null){</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>//直接保存微信用户信息，先清掉当前wxid对应记录中的微信id,置为空</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>publicDao.delWXidByUserWXid(uid);</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>publicDao.saveWXUserInfo(uid, phone);</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>//删除验证码</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>RedisCacheManager.INSTANCE.delPhoneCode(key);</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>}else{</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>if(!uid.equals(h5UserBean.getWxUid())){</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>//更换微信id</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>publicDao.updateWXidByUserWXid(uid,phone);</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>}</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>}</div>

checkIden

查询用户身份接口

<div>queryUserInfoByPhone=SELECT * FROM TB_H5_USER WHERE USERPHONE = ?</div><div><br></div>

<span class="Apple-tab-span" style="white-space:pre"> </span>userIden = list.get(0).get("USERIDEN")+"";

<div>/h5ser/queryCargo</div><div>业务接口接口入口 H5服务（找货）</div>

queryTruckNoList

 1.10.车主的车牌号列表查询接口

<div>queryTruckNoList=SELECT T.VEHICLE_NO, T.VID, T.VEHICLE_OWNER_NAME, T.VEHICLE_OWNER_PHONE FROM TB_TRUCK T, SYS_GENERAL_CODE VTYPE WHERE T.VEHICLE_TYPE = VTYPE.GENERAL_CODE AND VTYPE.PARENT_GENERAL_CODE = 'SYS_VEHICLE_TYPE' AND T.VEHICLE_OWNER_PHONE = ? ORDER BY VID DESC</div><div><br></div>

queryTruckList

车辆列表查询接口

1.微信sql

<div>SELECT *</div><div>  FROM (SELECT A.*, ROWNUM RN</div><div>          FROM (SELECT T.VEHICLE_NO AS VNO,</div><div>                       T.VID AS VID,</div><div>                       A.ATTACH_URL AS VIMG,</div><div>                       T.VEHICLE_LENGTH AS VOLEN,</div><div>                       T.BOX_LENGTH AS VLEN,</div><div>                       VTYPE.CODE_NAME AS VTYPE,</div><div>                       DECODE(S.VID, NULL, 1, 2) AS VSTATE,</div><div>                       T.VEHICLE_OWNER_NAME AS VEHICLEOWNERNAME,</div><div>                       T.VEHICLE_OWNER_PHONE AS VEHICLEOWNERPHONE</div><div>                  FROM TB_TRUCK          T,</div><div>                       TB_TRUCK_SOURCE   S,</div><div>                       SYS_GENERAL_CODE  VTYPE,</div><div>                       TB_VEHICLE_ATTACH A</div><div>                 WHERE T.VEHICLE_NO = S.VEHICLE_NO(+)</div><div>                   AND T.VID = A.VID(+)</div><div>                   AND T.VEHICLE_TYPE = VTYPE.GENERAL_CODE</div><div>                   AND VTYPE.PARENT_GENERAL_CODE = 'SYS_VEHICLE_TYPE'</div><div>                   AND A.ATTACH_URL_TYPE(+) = '3'</div><div>                   AND T.VEHICLE_OWNER_PHONE = ?</div><div>                 ORDER BY VID DESC) A</div><div>         WHERE ROWNUM <= ?)</div><div> WHERE RN >= ?</div><div><br></div>

2 大卡

<div><span class="Apple-tab-span" style="white-space:pre"> </span>@Autowired</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>private UserTruckService userTruckService;// 大卡用户ID查询车辆列表hessian接口</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>@Autowired</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>private IVehicleService iVehicleService;// 大卡用户ID查询车辆列表hessian接口</div>

queryTruckInfo

车辆详细信息查询接口

1.微信sql

<div>queryTruckInfo=SELECT T.ROAD_TRANSPORT AS ROADTRANSPORT, T.COMPANYNAME AS COMPANYNAME, T.VEHICLE_OWNER_NAME AS VEHICLEOWNERNAME, T.VEHICLE_OWNER_PHONE AS VEHICLEOWNERPHONE, (SELECT I.AREA_NAME FROM SYS_AREA_INFO I WHERE T.AREA_CODE = I.AREA_CODE) || '-' || (SELECT I.AREA_NAME FROM SYS_AREA_INFO I WHERE T.CITY_ID = I.AREA_CODE) AS AREACODE, T.VIN_CODE AS VINCODE, SPT.PROD_NAME AS TYPENO, T.VEHICLE_TON AS VEHICLETON, SGC.CODE_NAME AS VEHICLETYPE, SGC2.CODE_NAME AS VBRANDCODE, T.LOAD_TON AS LOADTON, T.VEHICLE_DRAW_TON AS VEHICLEDRAWTON, T.BOX_LENGTH AS INSIDESIZELENGTH, T.BOX_WIDTH AS INSIDESIZEWIDTH, T.BOX_HEIGHT AS INSIDESIZEHEIGHT, T.VEHICLE_NO AS VEHICLENO, T.VEHICLE_LENGTH AS VEHICLELENGTH, T.VEHICLE_WIDTH AS VEHICLEWIDTH, T.VEHICLE_HEIGHT AS VEHICLEHEIGHT, T.VEHICLE_AXIS AS VEHICLEAXIS, T.VEHICLE_TYRE_NUMBER AS VEHICLETYRENUMBER, T.VEHICLE_TYRE_SIZE AS VEHICLETYRESIZE, T.VEHICLE_BUSINESS_SCOPE AS VEHICLEBUSINESSSCOPE, T.OUT_FACTORY_TIME AS OUTFACTORYTIME, T.VEHICLE_COLOR AS VEHICLECOLOR, T.PURCHASE_TYPE AS PURCHASETYPE, T.INSURANCE_EXPIRATE_TIME AS INSURANCEEXPIRATETIME, T.CORP_ROAD_TRANSPORT AS CORPROADTRANSPORT, T.INSURANCE_TYPE AS INSURANCETYPE, T.INSURANCE_TYPE_OTHER AS INSURANCETYPEOTHER, B.URLS AS VIMG FROM TB_TRUCK T, SYS_GENERAL_CODE SGC, SYS_GENERAL_CODE SGC2, SYS_PRODUCT_TYPE SPT, (SELECT A.VID, WMSYS.WM_CONCAT(A.ATTACH_URL_TYPE || '#' || A.ATTACH_URL) AS URLS FROM TB_VEHICLE_ATTACH A GROUP BY A.VID) B WHERE (SGC.GENERAL_CODE = T.VEHICLE_TYPE AND SGC.PARENT_GENERAL_CODE = 'SYS_VEHICLE_TYPE') AND (SGC2.GENERAL_CODE = T.VBRAND_CODE AND SGC2.PARENT_GENERAL_CODE = 'SYS_VEHICLE_BRAND') AND SPT.PROD_CODE = T.PROD_CODE AND T.VID = B.VID(+) AND T.VID = ?</div><div><br></div>

2.大卡

<div><span class="Apple-tab-span" style="white-space:pre"> </span>@Autowired</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>private IVehicleService iVehicleService;// 大卡用户ID查询车辆列表hessian接口</div>

<div>QueryVehicleDetailResult queryVehicleDetailResult = iVehicleService.queryVehicleDetailById(vid, userCode);</div><div><br></div>

/publishTruckInfo/loadTruckInfo

加载车源信息接口

<div style="font-size: 17px;">queryTruckSourceInfo=SELECT S.AREACODE AS AREACODE, S.CARGO AS CARGO, S.LENGTH AS LENGTH, S.WEIGHT AS WEIGHT, S.TRUCKBAK AS TRUCKBAK, S.VEHICLEOWNERNAME AS VEHICLEOWNERNAME, S.VEHICLEOWNERPHONE AS VEHICLEOWNERPHONE FROM TB_TRUCK_SOURCE S WHERE S.VEHICLE_NO = ?</div><div><br></div>

/publishTruckInfo/queryCargo

查询常载货物接口

<div>#查询常载货物</div><div>queryCargoInfo=SELECT CARGO_ID,CARGO_NAME FROM TB_CARGO_WITH</div>

/publishTruckInfo/queryCity

查询常跑城市接口 

SELECT CARGO_CITY FROM TB_CARGO_CITY WHERE VEHICLE_NO=?

子主题

loadTruckInfoDaka

加载大卡车源信息接口

tb_truck_source车源表有vid返回车源信息，没有从tb_truck中查询出车牌号、车主手机号、车主姓名；修改2，新增1

/publishTruckInfo

发布车源接口

<div>openapi-datainfoser<br></div><div>https://zhiyunopenapitest.95155.com/apis/publishTruckSourceInfo/</div>

StaticInfoController

com.sinoiov.datainfo.service.apis.PublishTruckSourceInfo

execute

<div><br></div><div>#保存车源</div><div>saveTruckSourceInfo=INSERT INTO TB_TRUCK_SOURCE (TSID, USERID, VID, UFLAG, AREACODE, CARGO, LENGTH, WEIGHT, VEHICLEOWNERNAME, VEHICLEOWNERPHONE, TRUCKBAK, VEHICLE_NO, CREATE_TIME, UPDATE_TIME, H5UID) VALUES (SYS_GUID(), ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</div><div>#修改车源</div><div>updateTruckSourceInfo=UPDATE TB_TRUCK_SOURCE SET USERID = ?, AREACODE = ?, CARGO = ?, LENGTH = ?, WEIGHT = ?, VEHICLEOWNERNAME = ?, VEHICLEOWNERPHONE = ?, TRUCKBAK = ?, UFLAG = ?, UPDATE_TIME = ?, H5UID =? WHERE VEHICLE_NO = ?</div><div><br></div>

/savePriceDetail

保存车主对货源报价接口

有车无车

1：有车

 2：无车

 查询货运库是否有车接口

<span style="font-size: 17px;">String retVid = publicService.getcheckTruck(vno);// 有车返回vid,无车返回null</span>

redis openAPIDB  vehicleNoVidTable_STATUS

<span style="font-size: 17px;">通过车牌号从VehicleNoVidTable A/B表中取VID</span>

该车主对此货源是否报价

否

<div>#保存车主对货源的报价详情--</div><div>savePriceDetail=INSERT INTO TB_H5_BID_PRICE (ID, USERID, VID,GOODSID, VNO, CONTACT, CONTEL, INSTATUS, BIDPRICE, BAK, BIDTYPE, CREATTIME, UPDATETIME,BAKSTATUS,MSGSTATUS,TRUCKFLAG) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?)   </div><div><br></div>

是

<div>#保存报价信息时判断此车主是否已经对此货源报过价</div><div>queryBidCount=select count(*) from tb_h5_bid_price where goodsid=? and userid=?</div>

保存报价时，给货主发送一条短信

<div>#车主留言</div><div>H5_SMS_LEAVE_WORD=您好，您在【@1】平台上发布的【@2-@3】的货源被车主【联系电话：@4】抢单了，请登陆系统确认，如有疑问请致电 13366850042 </div>

/queryPriceDetail

查询报价详情接口(车主端)

<div>queryPriceDetail=SELECT P.BIDPRICE, P.BIDTYPE, P.VNO, P.CONTACT, P.CONTEL, P.BAK, S.GBIDTYPE FROM TB_H5_BID_PRICE P ,TB_H5_GOODS_SOURCE S WHERE P.ID = ? AND S.ID=P.GOODSID</div><div><br></div>

queryMsgList

车主消息列表查看接口

<div>queryTruckOwnMsg=SELECT BAK, GOODSOWNERPHONE, ID, READFLAG, CREATTIME FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM TB_H5_TRUCK_OWNER_MSG WHERE VCLUSERID = ? and BAKSTATUS = '1' ORDER BY CREATTIME DESC) A WHERE ROWNUM <= ?) WHERE RN >= ?</div><div><br></div>

setMsgStatus

车主消息状态设置接口

UPDATE TB_H5_TRUCK_OWNER_MSG set READFLAG = 2 WHERE ID in (:ids)

<div>queryGoodsInfo<br></div>

查看货源详情接口(车主端和货主端)

queryGoodsInfo=SELECT THGS.STARTAREA, THGS.STARTINFO, THGS.ENDAREA, THGS.ENDINFO, THGS.VTYPE, THGS.VLEN, THGS.VTON, THGS.EXPIRETIME, THGS.SENDFREQ, THGS.CARGOID, THGS.GTON, THGS.GVOL, THGS.CONTACT, THGS.CONTEL, THGS.BAK, THGS.BELEUP, THGS.REFERPRICE, THGS.GBIDTYPE, THGS.PRICETYPE, THGS.DATASTATUS, THGS.INSTATUS, TCW.CARGO_NAME FROM TB_H5_GOODS_SOURCE THGS LEFT JOIN TB_CARGO_WITH TCW ON THGS.CARGOID = TCW.CARGO_ID WHERE ID = ?

车辆常载货物表   TB_CARGO_WITH

queryGoodsList

查询货源列表接口

实时货源

<div>SELECT Z.*</div><div>  FROM (SELECT ROWNUM AS ROWDD, Y.*</div><div>          FROM (SELECT A.ID            AS GOODSID,</div><div>                       A.STARTAREA     AS STARTAREA,</div><div>                       A.ENDAREA       AS ENDAREA,</div><div>                       A.VTYPE         AS VEHICLETYPE,</div><div>                       A.VLEN          AS VEHICLELEN,</div><div>                       A.VTON          AS VEHICLETON,</div><div>                       A.EXPIRETIME    AS EXPIRETIME,</div><div>                       A.SENDFREQ      AS SENDFREQ,</div><div>                       C.CARGO_NAME    AS GOODSTYPE,</div><div>                       A.UPDATETIME    AS PUBLISHTIME,</div><div>                       A.INSTATUS      AS INSTATUS,</div><div>                       A.CONTEL        AS GOODSOWNERPHONE,</div><div>                       A.BELEUP        AS BELEUP,</div><div>                       A.GOODSSORCAUTH AS GOODSSORCAUTH,</div><div>                       U.USERLOGO      AS USERLOGO,</div><div>                       U.LOGOFLAG      AS LOGOFLAG,</div><div>                       A.PRICETYPE     AS PRICETYPE,</div><div>                       A.GBIDTYPE      AS GBIDTYPE,</div><div>                       A.REFERPRICE    AS REFERPRICE,</div><div>                       A.BAK           AS BAK</div><div>                  FROM TB_H5_GOODS_SOURCE A</div><div>                  LEFT JOIN TB_H5_USER U ON A.USERID = U.ID</div><div>                  LEFT JOIN TB_CARGO_WITH C ON A.CARGOID = C.CARGO_ID</div><div>                 WHERE A.INSTATUS = '1'</div><div>                   AND A.LTGOODS = '0'</div><div>                   AND A.DATASTATUS = '1'</div><div>                   AND (A.STARTAREA LIKE :STARTAREA OR :STARTAREA IS NULL)</div><div>                   AND (A.ENDAREA LIKE :ENDAREA OR :ENDAREA IS NULL)</div><div>                   AND (A.VTYPE = :VEHICLETYPE OR :VEHICLETYPE IS NULL)</div><div>                   AND (A.VLEN = :VEHICLELEN OR :VEHICLELEN IS NULL)</div><div>                   AND A.ID NOT IN (SELECT GOODSID</div><div>                                      FROM TB_H5_BID_PRICE</div><div>                                     WHERE USERID = :UID)</div><div>                 ORDER BY A.UPDATETIME DESC) Y</div><div>         WHERE ROWNUM <= (:PAGENO * 20)) Z</div><div> WHERE Z.ROWDD > ((:PAGENO - 1) * 20)</div><div><br></div>

长期货源

<div>SELECT Z.*</div><div>  FROM (SELECT ROWNUM AS ROWDD, Y.*</div><div>          FROM (SELECT A.ID            AS GOODSID,</div><div>                       A.STARTAREA     AS STARTAREA,</div><div>                       A.ENDAREA       AS ENDAREA,</div><div>                       A.VTYPE         AS VEHICLETYPE,</div><div>                       A.VLEN          AS VEHICLELEN,</div><div>                       A.VTON          AS VEHICLETON,</div><div>                       A.EXPIRETIME    AS EXPIRETIME,</div><div>                       A.SENDFREQ      AS SENDFREQ,</div><div>                       C.CARGO_NAME    AS GOODSTYPE,</div><div>                       A.UPDATETIME    AS PUBLISHTIME,</div><div>                       A.INSTATUS      AS INSTATUS,</div><div>                       A.CONTEL        AS GOODSOWNERPHONE,</div><div>                       A.BELEUP        AS BELEUP,</div><div>                       A.GOODSSORCAUTH AS GOODSSORCAUTH,</div><div>                       U.USERLOGO      AS USERLOGO,</div><div>                       U.LOGOFLAG      AS LOGOFLAG,</div><div>                       A.PRICETYPE     AS PRICETYPE,</div><div>                       A.GBIDTYPE      AS GBIDTYPE,</div><div>                       A.REFERPRICE    AS REFERPRICE,</div><div>                       A.BAK           AS BAK</div><div>                  FROM TB_H5_GOODS_SOURCE A</div><div>                  LEFT JOIN TB_H5_USER U ON A.USERID = U.ID</div><div>                  LEFT JOIN TB_CARGO_WITH C ON A.CARGOID = C.CARGO_ID</div><div>                 WHERE A.INSTATUS = '1'</div><div>                   AND A.DATASTATUS = '1'</div><div>                   AND A.LTGOODS = '1'</div><div>                   AND (A.STARTAREA LIKE :STARTAREA OR :STARTAREA IS NULL)</div><div>                   AND (A.ENDAREA LIKE :ENDAREA OR :ENDAREA IS NULL)</div><div>                   AND (A.VTYPE = :VEHICLETYPE OR :VEHICLETYPE IS NULL)</div><div>                   AND (A.VLEN = :VEHICLELEN OR :VEHICLELEN IS NULL)</div><div>                   AND A.ID NOT IN (SELECT GOODSID</div><div>                                      FROM TB_H5_BID_PRICE</div><div>                                     WHERE USERID = :UID)</div><div>                 ORDER BY A.UPDATETIME DESC) Y</div><div>         WHERE ROWNUM <= (:PAGENO * 20)) Z</div><div> WHERE Z.ROWDD > ((:PAGENO - 1) * 20)</div><div><br></div>

已竞价

<div>SELECT Z.*</div><div>  FROM (SELECT ROWNUM AS ROWDD, Y.*</div><div>          FROM (SELECT B.ID            AS GOODSID,</div><div>                       B.STARTAREA     AS STARTAREA,</div><div>                       B.ENDAREA       AS ENDAREA,</div><div>                       B.VTYPE         AS VEHICLETYPE,</div><div>                       B.VLEN          AS VEHICLELEN,</div><div>                       B.VTON          AS VEHICLETON,</div><div>                       B.EXPIRETIME    AS EXPIRETIME,</div><div>                       B.SENDFREQ      AS SENDFREQ,</div><div>                       D.CARGO_NAME    AS GOODSTYPE,</div><div>                       B.UPDATETIME    AS PUBLISHTIME,</div><div>                       A.INSTATUS      AS INSTATUS,</div><div>                       A.VNO           AS BIDTRUCKNO,</div><div>                       A.BIDPRICE      AS BIDPRIC,</div><div>                       A.BIDTYPE       AS BIDPRICTYPE,</div><div>                       A.VID           AS BIDTRUCKVID,</div><div>                       A.ID            AS QUOTATIONID,</div><div>                       B.CONTEL        AS GOODSOWNERPHONE,</div><div>                       A.READFLAG      AS READFLAG,</div><div>                       B.BELEUP        AS BELEUP,</div><div>                       B.GOODSSORCAUTH AS GOODSSORCAUTH,</div><div>                       U.USERLOGO      AS USERLOGO,</div><div>                       U.LOGOFLAG      AS LOGOFLAG,</div><div>                       B.PRICETYPE     AS PRICETYPE,</div><div>                       B.GBIDTYPE      AS GBIDTYPE,</div><div>                       B.REFERPRICE    AS REFERPRICE,</div><div>                       B.BAK           AS BAK,</div><div>                       A.CONTACT       AS BIDCONTACT</div><div>                  FROM TB_H5_BID_PRICE A</div><div>                 INNER JOIN TB_H5_GOODS_SOURCE B ON A.GOODSID = B.ID</div><div>                                                AND B.DATASTATUS = '1'</div><div>                                                AND (B.STARTAREA LIKE</div><div>                                                    :STARTAREA OR</div><div>                                                    :STARTAREA IS NULL)</div><div>                                                AND (B.ENDAREA LIKE :ENDAREA OR</div><div>                                                    :ENDAREA IS NULL)</div><div>                                                AND (B.VTYPE = :VEHICLETYPE OR</div><div>                                                    :VEHICLETYPE IS NULL)</div><div>                                                AND (B.VLEN = :VEHICLELEN OR</div><div>                                                    :VEHICLELEN IS NULL)</div><div>                  LEFT JOIN TB_H5_USER U ON B.USERID = U.ID</div><div>                  LEFT JOIN TB_CARGO_WITH D ON B.CARGOID = D.CARGO_ID</div><div>                 WHERE A.USERID = :UID</div><div>                   AND A.INSTATUS in ('2', '3', '4')</div><div>                 ORDER BY A.UPDATETIME DESC) Y</div><div>         WHERE ROWNUM <= (:PAGENO * 20)) Z</div><div> WHERE Z.ROWDD > ((:PAGENO - 1) * 20)</div><div><br></div>

TB_H5_GOODS_SOURCE   INSTATUS   货源状态，1：进行中，2:已完成,3:已过期

TB_H5_BID_PRICE  INSTATUS  参与状态(2：竞价中，3：竞价成功，4：竞价失败)

queryMsg

检查是否有留言接口

<div>SELECT COUNT(*)</div><div>  FROM TB_H5_TRUCK_OWNER_MSG</div><div> WHERE VCLUSERID = ?</div><div>   AND READFLAG = '1'</div><div>   AND BAKSTATUS = '1'</div><div><br></div>

queryBidMsg

车主竞价状态提示接口

<div>SELECT NVL((SELECT COUNT(A.ID)</div><div>             FROM TB_H5_BID_PRICE A, TB_H5_GOODS_SOURCE B</div><div>            WHERE A.USERID = :UID</div><div>              AND A.GOODSID = B.ID</div><div>              AND B.DATASTATUS = '1'</div><div>              AND A.INSTATUS = '3'</div><div>              AND A.READFLAG = '2'</div><div>            GROUP BY A.USERID),</div><div>           0) AS BIDSUCCESS,</div><div>       NVL((SELECT COUNT(C.ID)</div><div>             FROM TB_H5_BID_PRICE C, TB_H5_GOODS_SOURCE D</div><div>            WHERE C.USERID = :UID</div><div>              AND C.GOODSID = D.ID</div><div>              AND D.DATASTATUS = '1'</div><div>              AND C.INSTATUS = '4'</div><div>              AND C.READFLAG = '2'</div><div>            GROUP BY C.USERID),</div><div>           0) AS BIDFAIL</div><div>  FROM DUAL</div><div><br></div>

sendSMS

给货主发送短信

readBidMsg

更新车主竞价提示消息为已读接口

<div>UPDATE TB_H5_BID_PRICE</div><div>   SET READFLAG = '1'</div><div> WHERE USERID = :UID</div><div>   AND (INSTATUS = :INSTATUS OR :INSTATUS IS NULL)</div><div>   AND ID IN (:BIDIDS)</div><div><br></div>

分支主题4

子主题

自由主题