访问每个url都会返回一个JSON的信息新葡京32450网址:

发布时间:2019-10-06  栏目:数据  评论:0 Comments

 

const QString url_getOnlineChannel = "http://fm.baidu.com/dev/api/?tn=channellist";             //url->频道ID
const QString url_getOnlineSheet = "http://fm.baidu.com/dev/api/?tn=playlist&format=json&id=";  //频道ID->歌曲ID
const QString url_getOnlineMusic = "http://music.baidu.com/data/music/fmlink?type=mp3&rate=320&songIds=";  //歌曲ID->歌曲信息

   IF ln_source_type_id = 13 THEN
      –库存
      IF ln_type_id = 2 THEN
         –子库存转移
         SELECT nvl(mmt1.transaction_reference, ‘no reference’)
           INTO ls_result
           FROM mtl_material_transactions mmt1
          WHERE mmt1.transaction_id = p_trans_id;
      END IF;
      IF ln_type_id = 3 THEN
         –组织间直接转移
         SELECT nvl(mmt.waybill_airbill, ‘无陆运单号’)
           INTO ls_result
           FROM mtl_material_transactions mmt
          WHERE mmt.transaction_id = p_trans_id;
      END IF;
      IF ln_type_id = 12 THEN
         –Intransit Receipt
         ls_result := ls_type_name;
      END IF;
      IF ln_type_id = 21 THEN
         –Intransit Shipment
         ls_result := ls_type_name;
      END IF;
      IF ln_type_id = 42 THEN
         –杂项接收
         ls_result := ls_type_name;
      END IF;
   
      IF ln_type_id = 32 THEN
         –Miscellaneous issue
         ls_result := ls_type_name;
      END IF;
   
      IF ln_type_id = 51 THEN
         –Backflush Transfer
         ls_result := ls_type_name;
      END IF;
   
      IF ln_type_id = 66 THEN
         –Project Borrow
         ls_result := ls_type_name;
      END IF;
      IF ln_type_id = 67 THEN
         –Project Transfer
         ls_result := ls_type_name;
      END IF;
      IF ln_type_id = 68 THEN
         –Project Payback
         ls_result := ls_type_name;
      END IF;
      IF ln_type_id = 70 THEN
         –Shipment Rcpt Adjust
         ls_result := ls_type_name;
      END IF;
   
      IF ln_type_id = 73 THEN
         –Planning Transfer
         ls_result := ls_type_name;
      END IF;
   
      IF ln_type_id = 75 THEN
         –Transfer to Consigned
         ls_result := ls_type_name;
      END IF;
      IF ln_type_id = 80 THEN
         –平均费用更新
         ls_result := ls_type_name;
      END IF;
      IF ln_type_id = 82 THEN
         –Inventory Lot Split
         ls_result := ls_type_name;
      END IF;
      IF ln_type_id = 83 THEN
         –Inventory Lot Merge
         ls_result := ls_type_name;
      END IF;
      IF ln_type_id = 84 THEN
         –Inventory Lot Translate
         ls_result := ls_type_name;
      END IF;
      IF ln_type_id = 86 THEN
         –Cost Group Transfer
         ls_result := ls_type_name;
      END IF;
      IF ln_type_id = 87 THEN
         –Container Pack
         ls_result := ls_type_name;
      END IF;
      IF ln_type_id = 88 THEN
         –Container Unpack
         ls_result := ls_type_name;
      END IF;
      IF ln_type_id = 89 THEN
         –Container Split
         ls_result := ls_type_name;
      END IF;
      IF ln_type_id = 93 THEN
         –Field Service Usage
         ls_result := ls_type_name;
      END IF;
      IF ln_type_id = 94 THEN
         –Field Service Recovery
         ls_result := ls_type_name;
      END IF;
   END IF;

$(“#type_selected”).prepend(“<span>你挑选了:</span>”);
$(“#type_selected_box”).append(select_tag);
}else{
$(“#type_selected”).remove();
$(“#no_type”).addClass(“selected”);
}

table a(id, type):

一经现在有表结构:

  1. 获得频道列表。
    义务医治访谈
    http://fm.baidu.com/dev/api/?tn=channellist

    那边可以博获得独具的频段音讯,如下:
    {“hash_code”:”ef54151ee31553c05329ac7e66aaedc4″,”channel_list”:
    [{“channel_id”:”public_tuijian_spring”,”channel_name”:”\u6f2b\u6b65\u6625\u5929″,”channel_order”:0,”cate_id”:”tuijian”,”cate”:”\u63a8\u8350\u9891\u9053″,”cate_order”:1,”source_type”:1,”source_id”:0,”pv_order”:11},{“channel_id”:”public_tuijian_autumn”,”channel_name”:”\u79cb\u65e5\u79c1\u8bed”,”channel_order”:0,”cate_id”:”tuijian”,”cate”:”\u63a8\u8350\u9891\u9053″,”cate_order”:1,”source_type”:1,”source_id”:0,”pv_order”:12},{“channel_id”:”public_tuijian_winter”,”channel_name”:”\u6e29\u6696\u51ac\u65e5″,”channel_order”:10101,”cate_id”:”tuijian”,”cate”:”\u63a8\u8350\u9891\u9053″,”cate_order”:1,”source_type”:1,”source_id”:0,”pv_order”:10},{“channel_id”:”public_tuijian_rege”,”channel_name”:”\u70ed\u6b4c”,”channel_order”:10105,”cate_id”:”tuijian”,”cate”:”\u63a8\u8350\u9891\u9053″,”cate_order”:1,”source_type”:4,”source_id”:0,”pv_order”:1},{“channel_id”:”public_tuijian_ktv”,”channel_name”:”KTV\u91d1\u66f2″,”channel_order”:10106,”cate_id”:”tuijian”,”cate”:”\u63a8\u8350\u9891\u9053″,”cate_order”:1,”source_type”:1,”source_id”:0,”pv_order”:2},{“channel_id”:”public_tuijian_billboard”,”channel_name”:”Billboard”,”channel_order”:10107,”cate_id”:”tuijian”,”cate”:”\u63a8\u8350\u9891\u9053″,”cate_order”:1,”source_type”:1,”source_id”:0,”pv_order”:6},{“channel_id”:”public_tuijian_chengmingqu”,”channel_name”:”\u6210\u540d\u66f2″,”channel_order”:10108,”cate_id”:”tuijian”,”cate”:”\u63a8\u8350\u9891\u9053″,”cate_order”:1,”source_type”:1,”source_id”:0,”pv_order”:3},{“channel_id”:”public_tuijian_wangluo”,”channel_name”:”\u7f51\u7edc\u6b4c\u66f2″,”channel_order”:10109,”cate_id”:”tuijian”,”cate”:”\u63a8\u8350\u9891\u9053″,”cate_order”:1,”source_type”:2,”source_id”:0,”pv_order”:4},{“channel_id”:”public_tuijian_kaiche”,”channel_name”:”\u5f00\u8f66″,”channel_order”:10110,”cate_id”:”tuijian”,”cate”:”\u63a8\u8350\u9891\u9053″,”cate_order”:1,”source_type”:1,”source_id”:0,”pv_order”:7},{“channel_id”:”public_tuijian_yingshi”,”channel_name”:”\u5f71\u89c6″,”channel_order”:10113,”cate_id”:”tuijian”,”cate”:”\u63a8\u8350\u9891\u9053″,”cate_order”:1,”source_type”:1,”source_id”:0,”pv_order”:8},{“channel_id”:”public_tuijian_suibiantingting”,”channel_name”:”\u968f\u4fbf\u542c\u542c”,”channel_order”:10114,”cate_id”:”tuijian”,”cate”:”\u63a8\u8350\u9891\u9053″,”cate_order”:1,”source_type”:1,”source_id”:0,”pv_order”:5},{“channel_id”:”public_shiguang_jingdianlaoge”,”channel_name”:”\u7ecf\u5178\u8001\u6b4c”,”channel_order”:10201,”cate_id”:”shiguang”,”cate”:”\u65f6\u5149\u9891\u9053″,”cate_order”:2,”source_type”:2,”source_id”:0,”pv_order”:1},{“channel_id”:”public_shiguang_70hou”,”channel_name”:”70\u540e”,”channel_order”:10202,”cate_id”:”shiguang”,”cate”:”\u65f6\u5149\u9891\u9053″,”cate_order”:2,”source_type”:1,”source_id”:0,”pv_order”:6},{“channel_id”:”public_shiguang_80hou”,”channel_name”:”80\u540e”,”channel_order”:10203,”cate_id”:”shiguang”,”cate”:”\u65f6\u5149\u9891\u9053″,”cate_order”:2,”source_type”:2,”source_id”:0,”pv_order”:2},{“channel_id”:”public_shiguang_90hou”,”channel_name”:”90\u540e”,”channel_order”:10204,”cate_id”:”shiguang”,”cate”:”\u65f6\u5149\u9891\u9053″,”cate_order”:2,”source_type”:2,”source_id”:0,”pv_order”:3},{“channel_id”:”public_shiguang_xinge”,”channel_name”:”\u706b\u7206\u65b0\u6b4c”,”channel_order”:10205,”cate_id”:”shiguang”,”cate”:”\u65f6\u5149\u9891\u9053″,”cate_order”:2,”source_type”:3,”source_id”:33,”pv_order”:4},{“channel_id”:”public_shiguang_erge”,”channel_name”:”\u513f\u6b4c”,”channel_order”:10206,”cate_id”:”shiguang”,”cate”:”\u65f6\u5149\u9891\u9053″,”cate_order”:2,”source_type”:1,”source_id”:0,”pv_order”:7},{“channel_id”:”public_shiguang_lvxing”,”channel_name”:”\u65c5\u884c”,”channel_order”:10208,”cate_id”:”shiguang”,”cate”:”\u65f6\u5149\u9891\u9053″,”cate_order”:2,”source_type”:2,”source_id”:0,”pv_order”:8},{“channel_id”:”public_shiguang_yedian”,”channel_name”:”\u591c\u5e97″,”channel_order”:10209,”cate_id”:”shiguang”,”cate”:”\u65f6\u5149\u9891\u9053″,”cate_order”:2,”source_type”:2,”source_id”:0,”pv_order”:5},{“channel_id”:”public_fengge_liuxing”,”channel_name”:”\u6d41\u884c”,”channel_order”:10301,”cate_id”:”fengge”,”cate”:”\u98ce\u683c\u9891\u9053″,”cate_order”:3,”source_type”:1,”source_id”:0,”pv_order”:1},{“channel_id”:”public_fengge_yaogun”,”channel_name”:”\u6447\u6eda”,”channel_order”:10302,”cate_id”:”fengge”,”cate”:”\u98ce\u683c\u9891\u9053″,”cate_order”:3,”source_type”:2,”source_id”:0,”pv_order”:5},{“channel_id”:”public_fengge_minyao”,”channel_name”:”\u6c11\u8c23″,”channel_order”:10303,”cate_id”:”fengge”,”cate”:”\u98ce\u683c\u9891\u9053″,”cate_order”:3,”source_type”:3,”source_id”:50,”pv_order”:8},{“channel_id”:”public_fengge_qingyinyue”,”channel_name”:”\u8f7b\u97f3\u4e50″,”channel_order”:10304,”cate_id”:”fengge”,”cate”:”\u98ce\u683c\u9891\u9053″,”cate_order”:3,”source_type”:2,”source_id”:0,”pv_order”:3},{“channel_id”:”public_fengge_xiaoqingxin”,”channel_name”:”\u5c0f\u6e05\u65b0″,”channel_order”:10305,”cate_id”:”fengge”,”cate”:”\u98ce\u683c\u9891\u9053″,”cate_order”:3,”source_type”:2,”source_id”:0,”pv_order”:4},{“channel_id”:”public_fengge_zhongguofeng”,”channel_name”:”\u4e2d\u56fd\u98ce”,”channel_order”:10306,”cate_id”:”fengge”,”cate”:”\u98ce\u683c\u9891\u9053″,”cate_order”:3,”source_type”:2,”source_id”:0,”pv_order”:7},{“channel_id”:”public_fengge_dj”,”channel_name”:”DJ\u821e\u66f2″,”channel_order”:10308,”cate_id”:”fengge”,”cate”:”\u98ce\u683c\u9891\u9053″,”cate_order”:3,”source_type”:2,”source_id”:0,”pv_order”:2},{“channel_id”:”public_fengge_dianyingyuansheng”,”channel_name”:”\u7535\u5f71″,”channel_order”:10309,”cate_id”:”fengge”,”cate”:”\u98ce\u683c\u9891\u9053″,”cate_order”:3,”source_type”:2,”source_id”:0,”pv_order”:6},{“channel_id”:”public_xinqing_qingsongjiari”,”channel_name”:”\u8f7b\u677e\u5047\u65e5″,”channel_order”:10401,”cate_id”:”xinqing”,”cate”:”\u5fc3\u60c5\u9891\u9053″,”cate_order”:4,”source_type”:1,”source_id”:0,”pv_order”:4},{“channel_id”:”public_xinqing_huankuai”,”channel_name”:”\u6b22\u5feb\u65cb\u5f8b”,”channel_order”:10402,”cate_id”:”xinqing”,”cate”:”\u5fc3\u60c5\u9891\u9053″,”cate_order”:4,”source_type”:1,”source_id”:0,”pv_order”:1},{“channel_id”:”public_xinqing_tianmi”,”channel_name”:”\u751c\u871c\u611f\u53d7″,”channel_order”:10403,”cate_id”:”xinqing”,”cate”:”\u5fc3\u60c5\u9891\u9053″,”cate_order”:4,”source_type”:1,”source_id”:0,”pv_order”:6},{“channel_id”:”public_xinqing_jimo”,”channel_name”:”\u5bc2\u5bde”,”channel_order”:10404,”cate_id”:”xinqing”,”cate”:”\u5fc3\u60c5\u9891\u9053″,”cate_order”:4,”source_type”:2,”source_id”:0,”pv_order”:7},{“channel_id”:”public_xinqing_qingge”,”channel_name”:”\u5355\u8eab\u60c5\u6b4c”,”channel_order”:10405,”cate_id”:”xinqing”,”cate”:”\u5fc3\u60c5\u9891\u9053″,”cate_order”:4,”source_type”:1,”source_id”:0,”pv_order”:8},{“channel_id”:”public_xinqing_shuhuan”,”channel_name”:”\u8212\u7f13\u8282\u594f”,”channel_order”:10406,”cate_id”:”xinqing”,”cate”:”\u5fc3\u60c5\u9891\u9053″,”cate_order”:4,”source_type”:1,”source_id”:0,”pv_order”:2},{“channel_id”:”public_xinqing_yonglanwuhou”,”channel_name”:”\u6175\u61d2\u5348\u540e”,”channel_order”:10407,”cate_id”:”xinqing”,”cate”:”\u5fc3\u60c5\u9891\u9053″,”cate_order”:4,”source_type”:3,”source_id”:15,”pv_order”:5},{“channel_id”:”public_xinqing_shanggan”,”channel_name”:”\u4f24\u611f”,”channel_order”:10408,”cate_id”:”xinqing”,”cate”:”\u5fc3\u60c5\u9891\u9053″,”cate_order”:4,”source_type”:2,”source_id”:0,”pv_order”:3},{“channel_id”:”public_yuzhong_huayu”,”channel_name”:”\u534e\u8bed”,”channel_order”:10501,”cate_id”:”yuzhong”,”cate”:”\u8bed\u79cd\u9891\u9053″,”cate_order”:5,”source_type”:1,”source_id”:0,”pv_order”:1},{“channel_id”:”public_yuzhong_oumei”,”channel_name”:”\u6b27\u7f8e”,”channel_order”:10502,”cate_id”:”yuzhong”,”cate”:”\u8bed\u79cd\u9891\u9053″,”cate_order”:5,”source_type”:1,”source_id”:0,”pv_order”:2},{“channel_id”:”public_yuzhong_riyu”,”channel_name”:”\u65e5\u8bed”,”channel_order”:10503,”cate_id”:”yuzhong”,”cate”:”\u8bed\u79cd\u9891\u9053″,”cate_order”:5,”source_type”:2,”source_id”:0,”pv_order”:3},{“channel_id”:”public_yuzhong_hanyu”,”channel_name”:”\u97e9\u8bed”,”channel_order”:10504,”cate_id”:”yuzhong”,”cate”:”\u8bed\u79cd\u9891\u9053″,”cate_order”:5,”source_type”:1,”source_id”:0,”pv_order”:4},{“channel_id”:”public_yuzhong_yueyu”,”channel_name”:”\u7ca4\u8bed”,”channel_order”:10505,”cate_id”:”yuzhong”,”cate”:”\u8bed\u79cd\u9891\u9053″,”cate_order”:5,”source_type”:1,”source_id”:0,”pv_order”:5}],”status”:0}

   IF ln_source_type_id = 12 THEN
      — RMA 退货 ln_type_id is 15,37
      IF ln_type_id = 15 THEN
         –RMA 接收
         SELECT ott.name || ‘.’ || ooh.order_number || ‘.’ ||
                nvl(ooh.cust_po_number, ‘no cust po’)
           INTO ls_result
           FROM oe_order_lines_all      ool,
                oe_order_headers_all    ooh,
                oe_transaction_types_tl ott
          WHERE ool.header_id = ooh.header_id
            AND ool.line_id = ln_trx_source_line_id
            AND ott.LANGUAGE = userenv(‘LANG’)
            AND ooh.order_type_id = ott.transaction_type_id;
      END IF;
      IF ln_type_id = 37 THEN
         –RMA 退货
         SELECT ott.name || ‘.’ || ooh.order_number || ‘.’ ||
                nvl(ooh.cust_po_number, ‘no cust po’)
           INTO ls_result
           FROM oe_order_lines_all      ool,
                oe_order_headers_all    ooh,
                oe_transaction_types_tl ott
          WHERE ool.header_id = ooh.header_id
            AND ool.line_id = ln_trx_source_line_id
            AND ott.LANGUAGE = userenv(‘LANG’)
            AND ooh.order_type_id = ott.transaction_type_id;
      END IF;
   END IF;

/**
* 展开和吸取
**/
function showExpanMenu(data,id2,id3){
if(data && (data.length > 0)){
for(var i=0;i<data.length;i++){
$(“#” + data[i]).toggle(500);
}
}
$(“#”+id2).css(“display”,”none”);
$(“#”+id3).css(“display”,”block”);
}

**a.id    a.type    b.id    b.class

1        1            1        1
2        1            2        2
3        2              
**
sql语句2的实施结果为:

CREATE TABLE `msg_detail` (
    `id` INT(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
    `title` VARCHAR(200) NOT NULL DEFAULT '' COMMENT '标题',
    `content` TEXT NOT NULL COMMENT '内容',
    `audio_url` VARCHAR(255) NOT NULL DEFAULT '' COMMENT '音频地址',
    `type_id` TINYINT(4) NOT NULL DEFAULT '0',
     PRIMARY KEY (`id`),
    INDEX `cid` (`cid`) USING BTREE,
    INDEX `column_id` (`column_id`) USING BTREE
)
COMMENT='内参表'
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1;

拜谒每一个url都会回到多个JSON的音讯,通过深入分析JSON来取得个中的音信。
流程就好像url地址同样,分为3步:

   IF ln_source_type_id = 9 THEN
      — 周期盘点
      IF ln_type_id = 4 THEN
         –Cycle Count Adjust
         ls_result := ls_type_name;
      END IF;
      IF ln_type_id = 5 THEN
         –Cycle Count Transfer
         ls_result := ls_type_name;
      END IF;
   
   END IF;

***.js:
/**
* 收起大概实行筛选框
*/
function filterType(){
$(“#filter_box_id”).toggle(500);
var shaixuanBtn = $(“#filter_title_id”).find(“.shaixuan-btn”);
if(shaixuanBtn.length > 0){
shaixuanBtn.addClass(“shaixuan-btn1”);
shaixuanBtn.removeClass(“shaixuan-btn”);
}else{
shaixuanBtn = $(“#filter_title_id”).find(“.shaixuan-btn1”);
shaixuanBtn.addClass(“shaixuan-btn”);
shaixuanBtn.removeClass(“shaixuan-btn1”);
}
}

**a.id    a.type    b.id    b.class

1        1            1        1
2        1            2        2
**
sql语句3的实行结果为:

 

百度公开有三个音乐接口,里面分好了频道连串。下边是3个接口的二个url地址。

寻找事物处理来自

/**
* 是不是出示到“已选拔”容器内
* @param {} type_name
* @return {}
*/
function showSelected(type_name){
return ((type_name != “catalog_searchkey”)
&& (type_name != “root_type”)
&& (type_name != “group_type”)
&& (type_name != “root_id”)
&& (type_name != “root_type”)
&& (type_name != “pagesize”)
&& (type_name != “index”));
}

id     type

1      1        
2      1         
3      2         
table b(id, class):

相关文章

留下评论

网站地图xml地图