接口访问样例及返回数据样例
================== {'DData':{'Lock':'1234'}}
1.应用列表接口：
Android：
访问地址：http://127.0.0.1:8080/appstoreV0.1/serverInterfacesapps.do?value={'name':'sgm','appType':'ALL','deviceType':'1','offset':'0'}
{"apps":[{"appCurrentLevel":0,"appFul":"itms-services://?action=download-manifest&url=http://127.0.0.1:8080/appstoreV0.1/upload/apps/android/73027357302735.apk","appId":"b06161e685","appName":"PPS影音","appSize":"11319348","deviceModle":"","downUrl":"upload\\apps\\android\\73027357302735.apk","downloadCount":"0","icon":"upload/app_imgs/android/73031797303179.png","iconFul":"http://127.0.0.1:8080/appstoreV0.1/upload/app_imgs/android/73031797303179.png","iconName":"73031797303179.png","id":"9051","pacName":"tv.pps.mobile"},{"appCurrentLevel":0,"appFul":"itms-services://?action=download-manifest&url=http://127.0.0.1:8080/appstoreV0.1/upload/apps/android/74018167401816.apk","appId":"66368b5974","appName":"56视频","appSize":"9650331","deviceModle":"","downUrl":"upload\\apps\\android\\74018167401816.apk","downloadCount":"1","icon":"upload/app_imgs/android/74021327402132.png","iconFul":"http://127.0.0.1:8080/appstoreV0.1/upload/app_imgs/android/74021327402132.png","iconName":"74021327402132.png","id":"10050","pacName":"com.Android56"},{"appCurrentLevel":0,"appFul":"itms-services://?action=download-manifest&url=http://127.0.0.1:8080/appstoreV0.1/upload/apps/android/97368889736888.apk","appId":"b363359ad8","appName":"肥猫比价","appSize":"7004204","deviceModle":"","downUrl":"upload\\apps\\android\\97368889736888.apk","downloadCount":"0","icon":"upload/app_imgs/android/97369399736939.png","iconFul":"http://127.0.0.1:8080/appstoreV0.1/upload/app_imgs/android/97369399736939.png","iconName":"97369399736939.png","id":"10051","pacName":"com.mobiq.feimaor"},{"appCurrentLevel":0,"appFul":"itms-services://?action=download-manifest&url=http://127.0.0.1:8080/appstoreV0.1/upload/apps/android/99842229984222.apk","appId":"a870c9a685","appName":"当当","appSize":"4668561","deviceModle":"","downUrl":"upload\\apps\\android\\99842229984222.apk","downloadCount":"0","icon":"upload/app_imgs/android/99842669984265.png","iconFul":"http://127.0.0.1:8080/appstoreV0.1/upload/app_imgs/android/99842669984265.png","iconName":"99842669984265.png","id":"10055","pacName":"com.dangdang.buy2"},{"appCurrentLevel":5,"appFul":"itms-services://?action=download-manifest&url=http://127.0.0.1:8080/appstoreV0.1/upload/apps/android/01406180140618.apk","appId":"fadcd58605","appName":"京东商城","appSize":"4254220","deviceModle":"","downUrl":"upload\\apps\\android\\01406180140618.apk","downloadCount":"2","icon":"upload/app_imgs/android/01406750140675.png","iconFul":"http://127.0.0.1:8080/appstoreV0.1/upload/app_imgs/android/01406750140675.png","iconName":"01406750140675.png","id":"10057","pacName":"com.jingdong.app.mall"},{"appCurrentLevel":0,"appFul":"itms-services://?action=download-manifest&url=http://127.0.0.1:8080/appstoreV0.1/upload/apps/android/0371189037
1189.apk","appId":"7df84d246d","appName":"聚美优品","appSize":"5045373","deviceModle":"","downUrl":"upload\\apps\\android\\03711890371189.apk","downloadCount":"0","icon":"upload/app_imgs/android/03712510371251.png","iconFul":"http://127.0.0.1:8080/appstoreV0.1/upload/app_imgs/android/03712510371251.png","iconName":"03712510371251.png","id":"10059","pacName":"com.jm.android.jumei"},{"appCurrentLevel":0,"appFul":"itms-services://?action=download-manifest&url=http://127.0.0.1:8080/appstoreV0.1/upload/apps/android/04391160439116.apk","appId":"43447954c9","appName":"微信","appSize":"19512831","deviceModle":"","downUrl":"upload\\apps\\android\\04391160439116.apk","downloadCount":"0","icon":"upload/app_imgs/android/04398340439834.png","iconFul":"http://127.0.0.1:8080/appstoreV0.1/upload/app_imgs/android/04398340439834.png","iconName":"04398340439834.png","id":"10060","pacName":"com.tencent.mm"},{"appCurrentLevel":0,"appFul":"itms-services://?action=download-manifest&url=http://127.0.0.1:8080/appstoreV0.1/upload/apps/android/04952460495246.apk","appId":"acb4a8fca7","appName":"有道词典","appSize":"17154323","deviceModle":"","downUrl":"upload\\apps\\android\\04952460495246.apk","downloadCount":"0","icon":"upload/app_imgs/android/04957500495750.png","iconFul":"http://127.0.0.1:8080/appstoreV0.1/upload/app_imgs/android/04957500495750.png","iconName":"04957500495750.png","id":"10062","pacName":"com.youdao.dict"},{"appCurrentLevel":0,"appFul":"itms-services://?action=download-manifest&url=http://127.0.0.1:8080/appstoreV0.1/upload/apps/android/05702300570230.apk","appId":"d68b0a177d","appName":"拉手","appSize":"1896010","deviceModle":"","downUrl":"upload\\apps\\android\\05702300570230.apk","downloadCount":"0","icon":"upload/app_imgs/android/05702620570262.png","iconFul":"http://127.0.0.1:8080/appstoreV0.1/upload/app_imgs/android/05702620570262.png","iconName":"05702620570262.png","id":"10063","pacName":"https://www.360docs.net/doc/1c2102239.html,shou.privilege"},{"appCurrentLevel":0,"appFul":"itms-services://?action=download-manifest&url=http://127.0.0.1:8080/appstoreV0.1/upload/apps/android/09125610912561.apk","appId":"0890862b8e","appName":"悠悠","appSize":"7049667","deviceModle":"","downUrl":"upload\\apps\\android\\09125610912561.apk","downloadCount":"0","icon":"upload/app_imgs/android/09127000912700.png","iconFul":"http://127.0.0.1:8080/appstoreV0.1/upload/app_imgs/android/09127000912700.png","iconName":"09127000912700.png","id":"10065","pacName":"com.uu.uunavi"},{"appCurrentLevel":5,"appFul":"itms-services://?action=download-manifest&url=http://127.0.0.1:8080/appstoreV0.1/upload/apps/android/11389291138929.apk","appId":"b538e9116b","appName":"Gallery","appSize":"292807","deviceModle":"","downUrl":"upload\\apps\\android\\11389291138929.apk","downloadCount":"2","icon":"upload/app_imgs/android/11389361138936.png","iconFul":"http://127.0.0.1:8080/appstoreV0.1/upload/app_imgs/android/11389361138936.png","iconName":"11389361138936.png","id":"10066","pacName":"com.gallery"},{"appCurren
tLevel":0,"appFul":"itms-services://?action=download-manifest&url=http://127.0.0.1:8080/appstoreV0.1/upload/apps/android/26202262620226.apk","appId":"7996ae2bdc","appName":"酷我","appSize":"4912142","deviceModle":"","downUrl":"upload\\apps\\android\\26202262620226.apk","downloadCount":"0","icon":"upload/app_imgs/android/26203292620329.png","iconFul":"http://127.0.0.1:8080/appstoreV0.1/upload/app_imgs/android/26203292620329.png","iconName":"26203292620329.png","id":"10074","pacName":"com.kugou.playerHD"},{"appCurrentLevel":0,"appFul":"itms-services://?action=download-manifest&url=http://127.0.0.1:8080/appstoreV0.1/upload/apps/android/27916302791630.apk","appId":"9513cd0e69","appName":"掌中英语","appSize":"5268373","deviceModle":"","downUrl":"upload\\apps\\android\\27916302791630.apk","downloadCount":"0","icon":"upload/app_imgs/android/27917522791752.png","iconFul":"http://127.0.0.1:8080/appstoreV0.1/upload/app_imgs/android/27917522791752.png","iconName":"27917522791752.png","id":"10075","pacName":"com.zzenglish.client"},{"appCurrentLevel":4,"appFul":"itms-services://?action=download-manifest&url=http://127.0.0.1:8080/appstoreV0.1/upload/apps/android/28509342850934.apk","appId":"928b7f4a31","appName":"天猫","appSize":"6417863","deviceModle":"","downUrl":"upload\\apps\\android\\28509342850934.apk","downloadCount":"1","icon":"upload/app_imgs/android/28511592851159.png","iconFul":"http://127.0.0.1:8080/appstoreV0.1/upload/app_imgs/android/28511592851159.png","iconName":"28511592851159.png","id":"10076","pacName":"com.tmall.wireless"},{"appCurrentLevel":0,"appFul":"itms-services://?action=download-manifest&url=http://127.0.0.1:8080/appstoreV0.1/upload/apps/android/39950393995039.apk","appId":"d7650a85e3","appName":"QQ","appSize":"15128435","deviceModle":"","downUrl":"upload\\apps\\android\\39950393995039.apk","downloadCount":"0","icon":"upload/app_imgs/android/39952593995259.jpg","iconFul":"http://127.0.0.1:8080/appstoreV0.1/upload/app_imgs/android/39952593995259.jpg","iconName":"39952593995259.jpg","id":"10079","pacName":"com.tencent.mobileqq"},{"appCurrentLevel":0,"appFul":"itms-services://?action=download-manifest&url=http://127.0.0.1:8080/appstoreV0.1/upload/apps/android/40629654062965.apk","appId":"e868e18a56","appName":"优酷","appSize":"8332859","deviceModle":"","downUrl":"upload\\apps\\android\\40629654062965.apk","downloadCount":"0","icon":"upload/app_imgs/android/40631374063137.jpg","iconFul":"http://127.0.0.1:8080/appstoreV0.1/upload/app_imgs/android/40631374063137.jpg","iconName":"40631374063137.jpg","id":"10080","pacName":"com.youku.phone"},{"appCurrentLevel":0,"appFul":"itms-services://?action=download-manifest&url=http://127.0.0.1:8080/appstoreV0.1/upload/apps/android/41850854185085.apk","appId":"a0113e2c61","appName":"土豆","appSize":"10277074","deviceModle":"","downUrl":"upload\\apps\\android\\41850854185085.apk","downloadCount":"0","icon":"upload/app_imgs/android/41852694185269.jpg","iconFul":"http://127.0.0.1:8080/appstore
V0.1/upload/app_imgs/android/41852694185269.jpg","iconName":"41852694185269.jpg","id":"10082","pacName":"com.tudou.android"},{"appCurrentLevel":0,"appFul":"itms-services://?action=download-manifest&url=http://127.0.0.1:8080/appstoreV0.1/upload/apps/android/47517594751759.apk","appId":"e2a4e3cda0","appName":"猴子也疯狂","appSize":"33750811","deviceModle":"","downUrl":"upload\\apps\\android\\47517594751759.apk","downloadCount":"0","icon":"upload/app_imgs/android/47529794752979.jpg","iconFul":"http://127.0.0.1:8080/appstoreV0.1/upload/app_imgs/android/47529794752979.jpg","iconName":"47529794752979.jpg","id":"10086","pacName":"https://www.360docs.net/doc/1c2102239.html,mon"},{"appCurrentLevel":5,"appFul":"itms-services://?action=download-manifest&url=http://127.0.0.1:8080/appstoreV0.1/upload/apps/android/19278821927882.apk","appId":"375091a5ec","appName":"测试门户应用","appSize":"3185099","deviceModle":"","downUrl":"upload\\apps\\android\\19278821927882.apk","downloadCount":"0","icon":"upload/app_imgs/android/19278971927897.png","iconFul":"http://127.0.0.1:8080/appstoreV0.1/upload/app_imgs/android/19278971927897.png","iconName":"19278971927897.png","id":"11051","pacName":"com.techown.gatewaystore"}],"totalCount":19}
2.设备列表接口
http://127.0.0.1:8080/appstoreV0.1/serverInterfacesqueryUserDeviceList.do?value={'userId':'1'}
3.登录接口
http://192.168.0.159:8080/appstore/serverInterfaceslogin.do?value={'name':'sgm','pwd':'1','updateDeviceId':'sgm777','devModle':'android','deviceName':'nokia 925T','packageName':'abc'}
//emm 09
http://192.168.30.35:8080/emm2/serverInterfacesappCategory.do?value={'name':'zijinqian','deviceType':'0'}
查询语句
SELECT
c. NAME,
b.cId,
c.ICON_PATH,
c.id
FROM
tb_emm_category c,
(
SELECT
count(app.category_id) AS cId,
category_id
FROM
(
SELECT DISTINCT
a.*
FROM
tb_emm_app_info a,
tb_emm_app_org ao,
tb_emm_user u
WHERE
a.id = ao.app_id
AND https://www.360docs.net/doc/1c2102239.html,_id = u.dept_id
AND https://www.360docs.net/doc/1c2102239.html,er_code ='zijinqian'
AND a.IS_DEL = '1'
AND a. STATUS = '4'
AND a.DEVICE_OCS ='1'
AND device_Type ='1'
) app
GROUP BY
app.category_id
) b
WHERE
c.id = b.category_id
AND c.IS_DEL = '1'
02
http://192.168.30.35:8080/emm2/serverInterfacesapps.do?value={'name':'zijinqian','deviceType':'0','appType':'ALL','offset':'0'}
appv0.1 apps
http://192.168.30.35:8080/appstoreV0.1/serverInterfacesapps.do?value={'name':'apptest01','deviceType':'0','appType':'ALL','offset':'0'}
http://127.0.0.1:8080/appstoreV0.1/serverInterIOSlogin.do?name=sgm&pwd=1&updateDeviceId=sgm777&iosDevicePin=FCKKSU34&devModle=iphone&deviceName=nokia 925T&packageName=efg
http://192.168.0.159:7080/appstore/serverInterIOSlogin.do?name=sgm&pwd=1&updateDeviceId=sgm777&iosDevicePin=FCKKSU34&devModle=iphone&deviceName=nokia 925T&packageName=efg
我的设备 登录ios接口
http://127.0.0.1:8080/appstoreV0.1/serv
erInterIOSlogin.do?name=sgm&pwd=1&updateDeviceId=ff465f4de63abc27bb7895426a4d40a19d38aab8893d77143babe7433896aa28&iosDevicePin=F1DLFXCHDTWF&devModle=iphone&deviceName=iphone5
强制解绑接口：
http://127.0.0.1:8080/appstoreV0.1/serverInterIOSforceUnbound.do?sessionID='f6ad5c8ca61c4522224b46e263109f11'&loginTime='1387268058748'
获取IOS设备列表接口测试样例
http://192.168.30.35:8080/appstoreV0.1/serverInterIOSqueryUserDeviceList.do
详情接口
http://192.168.30.35:8080/appstoreV0.1/serverInterIOSappDetail.do?appId=402880ce4259e4b701425a460f3b0013&pinCode=2
更新接口EMM
http://192.168.30.35:8080/emm2/serverInterIOSappsUpgrade.do?value={'message':'clientUpdate','packageName':'com.dangdang.iphone','type':'iphone'}
=====================emm 查询 应用分类SQL ==============================================================================
SELECT https://www.360docs.net/doc/1c2102239.html,,B.CID,C.ICON_PATH,C.ID FROM TB_EMM_CATEGORY C,
(SELECT COUNT(APP.CATEGORY_ID)AS CID,CATEGORY_ID
FROM (SELECT DISTINCT A.* FROM TB_EMM_APP_INFO A ,TB_EMM_APP_ORG AO,TB_EMM_USER U WHERE A.ID = AO.APP_ID
AND https://www.360docs.net/doc/1c2102239.html,_ID = U.DEPT_ID AND https://www.360docs.net/doc/1c2102239.html,ER_CODE ='zijinqian' AND A.IS_DEL = '1' AND A.STATUS = '4' AND A.DEVICE_OCS = '1'
AND DEVICE_TYPE in ('0','1') )APP GROUP BY APP.CATEGORY_ID) B WHERE C.ID = B.CATEGORY_ID AND C.IS_DEL = '1'
http://192.168.0.78:8080/emm/serverInterfacesapps.do?value={'name':'zijinqian','deviceType':'0','appType':'402880ce428ce26801428d2406280469','offset':'0'}