您的位置:1010cc时时彩经典版 > 1010cc安卓版 > 1010cc时时彩经典版查找事物处理来源,百度音乐

1010cc时时彩经典版查找事物处理来源,百度音乐

发布时间:2019-10-06 21:50编辑:1010cc安卓版浏览(175)

    设若将来有表结构:

    百度公开有二个音乐接口,里面分好了频道种类。上面是3个接口的叁个url地址。

    招来事物管理来自

    ***.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");
    }
    }

    table a(id, type):

    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;
    
    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->歌曲信息
    

    CREATE OR REPLACE FUNCTION cux_trans_source(p_trans_id NUMBER) RETURN VARCHAR2 IS
       ln_type_id               NUMBER;
       ln_source_line_id        NUMBER;
       ln_trx_source_line_id    NUMBER;
       ln_source_type_id        NUMBER;
       ln_transaction_source_id NUMBER;
       ls_type_name             VARCHAR2(80);
       ls_result                VARCHAR2(80);
    BEGIN
       SELECT mmt.transaction_type_id,
              mmt.source_line_id,
              mtt.transaction_type_name,
              mmt.trx_source_line_id,
              mmt.transaction_source_type_id,
              mmt.transaction_source_id
         INTO ln_type_id,
              ln_source_line_id,
              ls_type_name,
              ln_trx_source_line_id,
              ln_source_type_id,
              ln_transaction_source_id
         FROM mtl_material_transactions mmt,
              mtl_transaction_types     mtt
        WHERE mmt.transaction_type_id = mtt.transaction_type_id
          AND mmt.transaction_id = p_trans_id;

    /**
    * 复选过滤条件
    **/
    $(document).ready(function(){
    var bo = true;//是不是选择了标签
    var hidden = $("#type_filter_form").find("input[type=hidden]");//隐藏域
    var root_name = "";//选择的总分类的称呼
    var select_tag = "";//接纳的标签
    hidden.each(function(i){
    var type = hidden.eq(i).val();
    if(notNull(type)){
    bo = false;

    id     type

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

     

    访问每一种url都会回来二个JSON的新闻,通过解析JSON来获取其中的音讯。
    流程就如url地址同样,分为3步:

       IF ln_source_type_id = 1 THEN
          IF ln_type_id = 18 THEN
             --接收入库
             SELECT '购销订单号码' || '.' || ph.segment1 ||
                    nvl(ph.comments, ' no comments')
               INTO ls_result
               FROM rcv_transactions rt,
                    po_headers_all   ph
              WHERE rt.transaction_id = ln_source_line_id
                AND rt.po_header_id = ph.po_header_id;
          END IF;
          IF ln_type_id = 71 THEN
             --交货调治
             SELECT '买卖订单' || '.' || ph.segment1 ||
                    nvl(ph.comments, ' no comments')
               INTO ls_result
               FROM rcv_transactions rt,
                    po_headers_all   ph
              WHERE rt.transaction_id = ln_source_line_id
                AND rt.po_header_id = ph.po_header_id;
          END IF;
          IF ln_type_id = 36 THEN
             --退货
             SELECT '购销订单' || '.' || ph.segment1 ||
                    nvl(ph.comments, ' no comments')
               INTO ls_result
               FROM rcv_transactions rt,
                    po_headers_all   ph
              WHERE rt.transaction_id = ln_source_line_id
                AND rt.po_header_id = ph.po_header_id;
          END IF;
          IF ln_type_id = 74 THEN
             --转移至正规指标地
             ls_result := ls_type_name;
          END IF;
       END IF;

    var types = type.split("|");
    var type_id = types[1];

    id    class

    1      1
    2      2
    sql语句1:select a.*, b.* from a left join b on a.id = b.id and a.type = 1;
    sql语句2:select a.*, b.* from a left join b on a.id = b.id where a.type = 1;
    sql语句3:select a.*, b.* from a left join b on a.id = b.id and b.class = 1;

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

      查询全体项目内部仿效消息最大id,可用如下sql: 

    1. 获得频道列表。
      无条件访谈 http://fm.baidu.com/dev/api/?tn=channellist 。
      此处能够收获到全部的频段新闻,如下:
      {"hash_code":"ef54151ee31553c05329ac7e66aaedc4","channel_list": [{"channel_id":"public_tuijian_spring","channel_name":"u6f2bu6b65u6625u5929","channel_order":0,"cate_id":"tuijian","cate":"u63a8u8350u9891u9053","cate_order":1,"source_type":1,"source_id":0,"pv_order":11},{"channel_id":"public_tuijian_autumn","channel_name":"u79cbu65e5u79c1u8bed","channel_order":0,"cate_id":"tuijian","cate":"u63a8u8350u9891u9053","cate_order":1,"source_type":1,"source_id":0,"pv_order":12},{"channel_id":"public_tuijian_winter","channel_name":"u6e29u6696u51acu65e5","channel_order":10101,"cate_id":"tuijian","cate":"u63a8u8350u9891u9053","cate_order":1,"source_type":1,"source_id":0,"pv_order":10},{"channel_id":"public_tuijian_rege","channel_name":"u70edu6b4c","channel_order":10105,"cate_id":"tuijian","cate":"u63a8u8350u9891u9053","cate_order":1,"source_type":4,"source_id":0,"pv_order":1},{"channel_id":"public_tuijian_ktv","channel_name":"KTVu91d1u66f2","channel_order":10106,"cate_id":"tuijian","cate":"u63a8u8350u9891u9053","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":"u63a8u8350u9891u9053","cate_order":1,"source_type":1,"source_id":0,"pv_order":6},{"channel_id":"public_tuijian_chengmingqu","channel_name":"u6210u540du66f2","channel_order":10108,"cate_id":"tuijian","cate":"u63a8u8350u9891u9053","cate_order":1,"source_type":1,"source_id":0,"pv_order":3},{"channel_id":"public_tuijian_wangluo","channel_name":"u7f51u7edcu6b4cu66f2","channel_order":10109,"cate_id":"tuijian","cate":"u63a8u8350u9891u9053","cate_order":1,"source_type":2,"source_id":0,"pv_order":4},{"channel_id":"public_tuijian_kaiche","channel_name":"u5f00u8f66","channel_order":10110,"cate_id":"tuijian","cate":"u63a8u8350u9891u9053","cate_order":1,"source_type":1,"source_id":0,"pv_order":7},{"channel_id":"public_tuijian_yingshi","channel_name":"u5f71u89c6","channel_order":10113,"cate_id":"tuijian","cate":"u63a8u8350u9891u9053","cate_order":1,"source_type":1,"source_id":0,"pv_order":8},{"channel_id":"public_tuijian_suibiantingting","channel_name":"u968fu4fbfu542cu542c","channel_order":10114,"cate_id":"tuijian","cate":"u63a8u8350u9891u9053","cate_order":1,"source_type":1,"source_id":0,"pv_order":5},{"channel_id":"public_shiguang_jingdianlaoge","channel_name":"u7ecfu5178u8001u6b4c","channel_order":10201,"cate_id":"shiguang","cate":"u65f6u5149u9891u9053","cate_order":2,"source_type":2,"source_id":0,"pv_order":1},{"channel_id":"public_shiguang_70hou","channel_name":"70u540e","channel_order":10202,"cate_id":"shiguang","cate":"u65f6u5149u9891u9053","cate_order":2,"source_type":1,"source_id":0,"pv_order":6},{"channel_id":"public_shiguang_80hou","channel_name":"80u540e","channel_order":10203,"cate_id":"shiguang","cate":"u65f6u5149u9891u9053","cate_order":2,"source_type":2,"source_id":0,"pv_order":2},{"channel_id":"public_shiguang_90hou","channel_name":"90u540e","channel_order":10204,"cate_id":"shiguang","cate":"u65f6u5149u9891u9053","cate_order":2,"source_type":2,"source_id":0,"pv_order":3},{"channel_id":"public_shiguang_xinge","channel_name":"u706bu7206u65b0u6b4c","channel_order":10205,"cate_id":"shiguang","cate":"u65f6u5149u9891u9053","cate_order":2,"source_type":3,"source_id":33,"pv_order":4},{"channel_id":"public_shiguang_erge","channel_name":"u513fu6b4c","channel_order":10206,"cate_id":"shiguang","cate":"u65f6u5149u9891u9053","cate_order":2,"source_type":1,"source_id":0,"pv_order":7},{"channel_id":"public_shiguang_lvxing","channel_name":"u65c5u884c","channel_order":10208,"cate_id":"shiguang","cate":"u65f6u5149u9891u9053","cate_order":2,"source_type":2,"source_id":0,"pv_order":8},{"channel_id":"public_shiguang_yedian","channel_name":"u591cu5e97","channel_order":10209,"cate_id":"shiguang","cate":"u65f6u5149u9891u9053","cate_order":2,"source_type":2,"source_id":0,"pv_order":5},{"channel_id":"public_fengge_liuxing","channel_1010cc时时彩经典版,name":"u6d41u884c","channel_order":10301,"cate_id":"fengge","cate":"u98ceu683cu9891u9053","cate_order":3,"source_type":1,"source_id":0,"pv_order":1},{"channel_id":"public_fengge_yaogun","channel_name":"u6447u6eda","channel_order":10302,"cate_id":"fengge","cate":"u98ceu683cu9891u9053","cate_order":3,"source_type":2,"source_id":0,"pv_order":5},{"channel_id":"public_fengge_minyao","channel_name":"u6c11u8c23","channel_order":10303,"cate_id":"fengge","cate":"u98ceu683cu9891u9053","cate_order":3,"source_type":3,"source_id":50,"pv_order":8},{"channel_id":"public_fengge_qingyinyue","channel_name":"u8f7bu97f3u4e50","channel_order":10304,"cate_id":"fengge","cate":"u98ceu683cu9891u9053","cate_order":3,"source_type":2,"source_id":0,"pv_order":3},{"channel_id":"public_fengge_xiaoqingxin","channel_name":"u5c0fu6e05u65b0","channel_order":10305,"cate_id":"fengge","cate":"u98ceu683cu9891u9053","cate_order":3,"source_type":2,"source_id":0,"pv_order":4},{"channel_id":"public_fengge_zhongguofeng","channel_name":"u4e2du56fdu98ce","channel_order":10306,"cate_id":"fengge","cate":"u98ceu683cu9891u9053","cate_order":3,"source_type":2,"source_id":0,"pv_order":7},{"channel_id":"public_fengge_dj","channel_name":"DJu821eu66f2","channel_order":10308,"cate_id":"fengge","cate":"u98ceu683cu9891u9053","cate_order":3,"source_type":2,"source_id":0,"pv_order":2},{"channel_id":"public_fengge_dianyingyuansheng","channel_name":"u7535u5f71","channel_order":10309,"cate_id":"fengge","cate":"u98ceu683cu9891u9053","cate_order":3,"source_type":2,"source_id":0,"pv_order":6},{"channel_id":"public_xinqing_qingsongjiari","channel_name":"u8f7bu677eu5047u65e5","channel_order":10401,"cate_id":"xinqing","cate":"u5fc3u60c5u9891u9053","cate_order":4,"source_type":1,"source_id":0,"pv_order":4},{"channel_id":"public_xinqing_huankuai","channel_name":"u6b22u5febu65cbu5f8b","channel_order":10402,"cate_id":"xinqing","cate":"u5fc3u60c5u9891u9053","cate_order":4,"source_type":1,"source_id":0,"pv_order":1},{"channel_id":"public_xinqing_tianmi","channel_name":"u751cu871cu611fu53d7","channel_order":10403,"cate_id":"xinqing","cate":"u5fc3u60c5u9891u9053","cate_order":4,"source_type":1,"source_id":0,"pv_order":6},{"channel_id":"public_xinqing_jimo","channel_name":"u5bc2u5bde","channel_order":10404,"cate_id":"xinqing","cate":"u5fc3u60c5u9891u9053","cate_order":4,"source_type":2,"source_id":0,"pv_order":7},{"channel_id":"public_xinqing_qingge","channel_name":"u5355u8eabu60c5u6b4c","channel_order":10405,"cate_id":"xinqing","cate":"u5fc3u60c5u9891u9053","cate_order":4,"source_type":1,"source_id":0,"pv_order":8},{"channel_id":"public_xinqing_shuhuan","channel_name":"u8212u7f13u8282u594f","channel_order":10406,"cate_id":"xinqing","cate":"u5fc3u60c5u9891u9053","cate_order":4,"source_type":1,"source_id":0,"pv_order":2},{"channel_id":"public_xinqing_yonglanwuhou","channel_name":"u6175u61d2u5348u540e","channel_order":10407,"cate_id":"xinqing","cate":"u5fc3u60c5u9891u9053","cate_order":4,"source_type":3,"source_id":15,"pv_order":5},{"channel_id":"public_xinqing_shanggan","channel_name":"u4f24u611f","channel_order":10408,"cate_id":"xinqing","cate":"u5fc3u60c5u9891u9053","cate_order":4,"source_type":2,"source_id":0,"pv_order":3},{"channel_id":"public_yuzhong_huayu","channel_name":"u534eu8bed","channel_order":10501,"cate_id":"yuzhong","cate":"u8bedu79cdu9891u9053","cate_order":5,"source_type":1,"source_id":0,"pv_order":1},{"channel_id":"public_yuzhong_oumei","channel_name":"u6b27u7f8e","channel_order":10502,"cate_id":"yuzhong","cate":"u8bedu79cdu9891u9053","cate_order":5,"source_type":1,"source_id":0,"pv_order":2},{"channel_id":"public_yuzhong_riyu","channel_name":"u65e5u8bed","channel_order":10503,"cate_id":"yuzhong","cate":"u8bedu79cdu9891u9053","cate_order":5,"source_type":2,"source_id":0,"pv_order":3},{"channel_id":"public_yuzhong_hanyu","channel_name":"u97e9u8bed","channel_order":10504,"cate_id":"yuzhong","cate":"u8bedu79cdu9891u9053","cate_order":5,"source_type":1,"source_id":0,"pv_order":4},{"channel_id":"public_yuzhong_yueyu","channel_name":"u7ca4u8bed","channel_order":10505,"cate_id":"yuzhong","cate":"u8bedu79cdu9891u9053","cate_order":5,"source_type":1,"source_id":0,"pv_order":5}],"status":0}

       IF ln_source_type_id = 2 THEN
          --出卖订单来源 
          IF ln_type_id = 33 THEN
             --发卖订单发运
             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 = 52 THEN
             -- 发卖订单挑库
             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;
       IF ln_source_type_id = 3 THEN
          --Account
          IF ln_type_id = 1 THEN
             --Account issue
             ls_result := ls_type_name;
          END IF;
          IF ln_type_id = 40 THEN
             --Account receipt
             ls_result := ls_type_name;
          END IF;
       END IF;

    if(notNull(type_id)){
    var type_name = hidden.eq(i).attr("name");
    if(showSelected(type_name)){
    //选中过滤的小标签规范
    $("#" type_name "_" types[0]).addClass("selected");

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

    1        1            1        1
    2        1            2        2
    3        2              
    **
    sql语句2的举办结果为:

    本文由1010cc时时彩经典版发布于1010cc安卓版,转载请注明出处:1010cc时时彩经典版查找事物处理来源,百度音乐

    关键词:

上一篇:单表查询,基础演习

下一篇:没有了