1. /***************根据简标题获取相关的资讯***************/
    2.     function shorttitle($typename,$temp=0)
    3.     {
    4.         global $dsql;
    5.         $sql = "SELECT arc.* FROM `dede_archives` arc LEFT JOIN `dede_arctype` tp ON arc.typeid = tp.id  WHERE (tp.id=2 or tp.id=9 or tp.id=10) and arc.title like '%$typename%'and (arc.title like '%费%' or arc.title like '%条件%')  ORDER BY arc.pubdate desc limit 0,8";
    6.         $dsql->Execute('me', $sql);
    7.         while ($row = $dsql->GetArray()) {
    8.             $list .= " <li class='cocoyp-ys-per-ppzx2 cocoyp-o-h cocoyp-fl cocoyp-font16'>
    9.                     <div class='cocoyp-fl cocoyp-ys-ppzx2-time'>
    10.                         <p class='cocoyp-color-242424 cocoyp-font-weight'>".strftime("%Y-%m-%d",$row['pubdate'])."</p>
    11.                         <p class=cocoyp-'color-242424'><img src='/public/images/jmfy/time-icon.png'>".strftime("%H:%M:%S",$row['pubdate'])."</p>
    12.                     </div>
    13.                     <a href='".$arcurl."' class='cocoyp-fl cocoyp-ys-ppzx2-title'>".$row['title']."</a>
    14.                 </li> ";
    15.             $ids.= $row['id'].',';
    16.         }
    17.     if($ids==""){
    18.         $sql = "SELECT arc.* FROM `dede_archives` arc LEFT JOIN `dede_arctype` tp ON arc.typeid = tp.id  WHERE (tp.id=2 or tp.id=9 or tp.id=10) and (arc.title like '%费%' or arc.title like '%条件%')  ORDER BY arc.pubdate desc limit 0,8";
    19.         $dsql->Execute('me', $sql);
    20.         while ($row = $dsql->GetArray()) {
    21.             $list .= " <li class='cocoyp-ys-per-ppzx2 cocoyp-o-h cocoyp-fl cocoyp-font16'>
    22.                     <div class='cocoyp-fl cocoyp-ys-ppzx2-time'>
    23.                         <p class='cocoyp-color-242424 cocoyp-font-weight'>".strftime("%Y-%m-%d",$row['pubdate'])."</p>
    24.                         <p class=cocoyp-'color-242424'><img src='/public/images/jmfy/time-icon.png'>".strftime("%H:%M:%S",$row['pubdate'])."</p>
    25.                     </div>
    26.                     <a href='".$arcurl."' class='cocoyp-fl cocoyp-ys-ppzx2-title'>".$row['title']."</a>
    27.                 </li> ";
    28.             $ids.= $row['id'].',';
    29.         }
    30.     }
    31.     if($temp==1){
    32.         return $ids;
    33.     }
    34.         return $list;
    35.     }
    36. /***************获取当前城市相关资讯***************/
    37.    function getchengshi($typename,$temp=0) {
    38.    $ids1 = shorttitle($typename,1);
    39.    $a = rtrim($ids1,',');
    40.         global $dsql;
    41.         $sql = "SELECT arc.* FROM `dede_archives` arc LEFT JOIN `dede_arctype` tp ON arc.typeid = tp.id  WHERE (tp.id=2 or tp.id=9 or tp.id=10) and arc.title like '%$typename%' ORDER BY arc.pubdate desc limit 0,8";
    42.         $dsql->Execute('me', $sql);
    43.         while ($row = $dsql->GetArray()) {
    44.             $list .= " <li class='cocoyp-ys-per-ppzx2 cocoyp-o-h cocoyp-fl cocoyp-font16'>
    45.                     <div class='cocoyp-fl cocoyp-ys-ppzx2-time'>
    46.                         <p class='cocoyp-color-242424 cocoyp-font-weight'>".strftime("%Y-%m-%d",$row['pubdate'])."</p>
    47.                         <p class=cocoyp-'color-242424'><img src='/public/images/jmfy/time-icon.png'>".strftime("%H:%M:%S",$row['pubdate'])."</p>
    48.                     </div>
    49.                     <a href='".$arcurl."' class='cocoyp-fl cocoyp-ys-ppzx2-title'>".$row['title']."</a>
    50.                 </li> ";
    51.             $ids.= $row['id'].',';
    52.         }
    53.     if($ids==""){
    54.         $sql = "SELECT arc.* FROM `dede_archives` arc LEFT JOIN `dede_arctype` tp ON arc.typeid = tp.id  WHERE (tp.id=2 or tp.id=9 or tp.id=10) and (arc.title like '%钱%' or arc.title like '%条件%')  ORDER BY arc.pubdate desc limit 0,8";
    55.         $dsql->Execute('me', $sql);
    56.         while ($row = $dsql->GetArray()) {
    57.             $list .= " <li class='cocoyp-ys-per-ppzx2 cocoyp-o-h cocoyp-fl cocoyp-font16'>
    58.                     <div class='cocoyp-fl cocoyp-ys-ppzx2-time'>
    59.                         <p class='cocoyp-color-242424 cocoyp-font-weight'>".strftime("%Y-%m-%d",$row['pubdate'])."</p>
    60.                         <p class=cocoyp-'color-242424'><img src='/public/images/jmfy/time-icon.png'>".strftime("%H:%M:%S",$row['pubdate'])."</p>
    61.                     </div>
    62.                     <a href='".$arcurl."' class='cocoyp-fl cocoyp-ys-ppzx2-title'>".$row['title']."</a>
    63.                 </li> ";
    64.             $ids.= $row['id'].',';
    65.         }
    66.     }
    67.     if($temp==1){
    68.         return $ids;
    69.     }
    70.         return $list;
    71.     }
    72. /***************获取利润分析相关资讯***************/
    73.    function Getjmlr($typename) {
    74.    $ids1 = shorttitle($typename,1);
    75.    $ids2 = getchengshi($typename,1);
    76.    $a = rtrim($ids1.$ids2,',');
    77.         global $dsql;
    78.         $sql = "SELECT arc.* FROM `dede_archives` arc LEFT JOIN `dede_arctype` tp ON arc.typeid = tp.id  WHERE (tp.id=2 or tp.id=9) and arc.title like '%利%' ORDER BY arc.pubdate desc limit 0,8";
    79.         $dsql->Execute('me', $sql);
    80.         while ($row = $dsql->GetArray()) {
    81.             $list .= " <li class='cocoyp-ys-per-ppzx2 cocoyp-o-h cocoyp-fl cocoyp-font16'>
    82.                          <div class='cocoyp-fl cocoyp-ys-ppzx2-time'>
    83.                           <p class='cocoyp-color-242424 cocoyp-font-weight'>".strftime("%Y-%m-%d",$row['pubdate'])."</p>
    84.                           <p class=cocoyp-'color-242424'><img src='/public/images/jmfy/time-icon.png'>".strftime("%H:%M:%S",$row['pubdate'])."</p>
    85.                          </div>
    86.                            <a href='".$arcurl."' class='cocoyp-fl cocoyp-ys-ppzx2-title'>".$row['title']."</a>
    87.                        </li> ";
    88.             $ids.= $row['id'].',';
    89.         }
    90.     if($ids==""){
    91.         $sql = "SELECT arc.* FROM `dede_archives` arc LEFT JOIN `dede_arctype` tp ON arc.typeid = tp.id  WHERE (tp.id=2 or tp.id=9) and (arc.title like '%条件%' or arc.title like '%费%')  ORDER BY arc.pubdate desc limit 0,8";
    92.         $dsql->Execute('me', $sql);
    93.         while ($row = $dsql->GetArray()) {
    94.             $list .= " <li class='cocoyp-ys-per-ppzx2 cocoyp-o-h cocoyp-fl cocoyp-font16'>
    95.                     <div class='cocoyp-fl cocoyp-ys-ppzx2-time'>
    96.                         <p class='cocoyp-color-242424 cocoyp-font-weight'>".strftime("%Y-%m-%d",$row['pubdate'])."</p>
    97.                         <p class=cocoyp-'color-242424'><img src='/public/images/jmfy/time-icon.png'>".strftime("%H:%M:%S",$row['pubdate'])."</p>
    98.                     </div>
    99.                     <a href='".$arcurl."' class='cocoyp-fl cocoyp-ys-ppzx2-title'>".$row['title']."</a>
    100.                 </li> ";
    101.             $ids.= $row['id'].',';
    102.         }
    103.     }
    104.     if($temp==1){
    105.         return $ids;
    106.     }
    107.         return $list;
    108.     }
    110. /***************获取品牌介绍相关资讯***************/
    111.    function getppjs($typename,$temp=0) {
    112.    $ids1 = shorttitle($typename,1);
    113.    $ids2 = getchengshi($typename,1);
    114.    $ids3 = Getjmlr($typename,1);
    115.    $a = rtrim($ids1.$ids2.$ids3,',');
    116.         global $dsql;
    117.         $sql = "SELECT arc.* FROM `dede_archives` arc LEFT JOIN `dede_arctype` tp ON arc.typeid = tp.id  WHERE (tp.id=2 or tp.id=9 or tp.id=10) and arc.title like '%$typename%' ORDER BY arc.pubdate desc limit 0,8";
    118.         $dsql->Execute('me', $sql);
    119.         while ($row = $dsql->GetArray()) {
    120.             $list .= " <li class='cocoyp-ys-per-ppzx2 cocoyp-o-h cocoyp-fl cocoyp-font16'>
    121.                     <div class='cocoyp-fl cocoyp-ys-ppzx2-time'>
    122.                         <p class='cocoyp-color-242424 cocoyp-font-weight'>".strftime("%Y-%m-%d",$row['pubdate'])."</p>
    123.                         <p class=cocoyp-'color-242424'><img src='/public/images/jmfy/time-icon.png'>".strftime("%H:%M:%S",$row['pubdate'])."</p>
    124.                     </div>
    125.                     <a href='".$arcurl."' class='cocoyp-fl cocoyp-ys-ppzx2-title'>".$row['title']."</a>
    126.                 </li> ";
    127.             $ids.= $row['id'].',';
    128.         }
    129.     if($ids==""){
    130.         $sql = "SELECT arc.* FROM `dede_archives` arc LEFT JOIN `dede_arctype` tp ON arc.typeid = tp.id  WHERE (tp.id=2 or tp.id=9 or tp.id=10) and (arc.title like '%怎%' or arc.title like '%优势%')  ORDER BY arc.pubdate desc limit 0,8";
    131.         $dsql->Execute('me', $sql);
    132.         while ($row = $dsql->GetArray()) {
    133.             $list .= " <li class='cocoyp-ys-per-ppzx2 cocoyp-o-h cocoyp-fl cocoyp-font16'>
    134.                     <div class='cocoyp-fl cocoyp-ys-ppzx2-time'>
    135.                         <p class='cocoyp-color-242424 cocoyp-font-weight'>".strftime("%Y-%m-%d",$row['pubdate'])."</p>
    136.                         <p class=cocoyp-'color-242424'><img src='/public/images/jmfy/time-icon.png'>".strftime("%H:%M:%S",$row['pubdate'])."</p>
    137.                     </div>
    138.                     <a href='".$arcurl."' class='cocoyp-fl cocoyp-ys-ppzx2-title'>".$row['title']."</a>
    139.                 </li> ";
    140.             $ids.= $row['id'].',';
    141.         }
    142.     }
    143.     if($temp==1){
    144.         return $ids;
    145.     }
    146.         return $list;
    147.     }
    148. /***************获取加盟条件相关资讯***************/
    149.    function getjmtj($typename,$temp=0) {
    150.    $ids1 = shorttitle($typename,1);
    151.    $ids2 = getchengshi($typename,1);
    152.    $ids3 = Getjmlr($typename,1);
    153.    $ids4 = Getppjs($typename,1);
    154.    $a = rtrim($ids1.$ids2.$ids3.$ids4,',');
    155.         global $dsql;
    156.         $sql = "SELECT arc.* FROM `dede_archives` arc LEFT JOIN `dede_arctype` tp ON arc.typeid = tp.id  WHERE (tp.id=2 or tp.id=9 or tp.id=10) and arc.title like '%条件%'  ORDER BY arc.pubdate desc limit 0,8";
    157.         $dsql->Execute('me', $sql);
    158.         while ($row = $dsql->GetArray()) {
    159.             $list .= " <li class='cocoyp-ys-per-ppzx2 cocoyp-o-h cocoyp-fl cocoyp-font16'>
    160.                     <div class='cocoyp-fl cocoyp-ys-ppzx2-time'>
    161.                         <p class='cocoyp-color-242424 cocoyp-font-weight'>".strftime("%Y-%m-%d",$row['pubdate'])."</p>
    162.                         <p class=cocoyp-'color-242424'><img src='/public/images/jmfy/time-icon.png'>".strftime("%H:%M:%S",$row['pubdate'])."</p>
    163.                     </div>
    164.                     <a href='".$arcurl."' class='cocoyp-fl cocoyp-ys-ppzx2-title'>".$row['title']."</a>
    165.                 </li> ";
    166.             $ids.= $row['id'].',';
    167.         }
    168.     if($ids==""){
    169.         $sql = "SELECT arc.* FROM `dede_archives` arc LEFT JOIN `dede_arctype` tp ON arc.typeid = tp.id  WHERE (tp.id=2 or tp.id=9 or tp.id=10) and (arc.title like '%怎么%' or arc.title like '%费%')  ORDER BY arc.pubdate desc limit 0,8";
    170.         $dsql->Execute('me', $sql);
    171.         while ($row = $dsql->GetArray()) {
    172.             $list .= " <li class='cocoyp-ys-per-ppzx2 cocoyp-o-h cocoyp-fl cocoyp-font16'>
    173.                     <div class='cocoyp-fl cocoyp-ys-ppzx2-time'>
    174.                         <p class='cocoyp-color-242424 cocoyp-font-weight'>".strftime("%Y-%m-%d",$row['pubdate'])."</p>
    175.                         <p class=cocoyp-'color-242424'><img src='/public/images/jmfy/time-icon.png'>".strftime("%H:%M:%S",$row['pubdate'])."</p>
    176.                     </div>
    177.                     <a href='".$arcurl."' class='cocoyp-fl cocoyp-ys-ppzx2-title'>".$row['title']."</a>
    178.                 </li> ";
    179.             $ids.= $row['id'].',';
    180.         }
    181.     }
    182.     if($temp==1){
    183.         return $ids;
    184.     }
    185.         return $list;
    186.     }
    187. /***************获取加盟费用相关资讯***************/
    188.    function getjmfy($typename,$temp=0) {
    189.    $ids1 = shorttitle($typename,1);
    190.    $ids2 = getchengshi($typename,1);
    191.    $ids3 = Getjmlr($typename,1);
    192.    $ids4 = Getppjs($typename,1);
    193.    $ids5 = Getjmtj($typename,1);
    194.    $a = rtrim($ids1.$ids2.$ids3.$ids4.$ids5,',');
    195.         global $dsql;
    196.         $sql = "SELECT arc.* FROM `dede_archives` arc LEFT JOIN `dede_arctype` tp ON arc.typeid = tp.id  WHERE (tp.id=2 or tp.id=9 or tp.id=10) and arc.title like '%$typename%' ORDER BY arc.pubdate desc limit 0,8";
    197.         $dsql->Execute('me', $sql);
    198.         while ($row = $dsql->GetArray()) {
    199.             $list .= " <li class='cocoyp-ys-per-ppzx2 cocoyp-o-h cocoyp-fl cocoyp-font16'>
    200.                     <div class='cocoyp-fl cocoyp-ys-ppzx2-time'>
    201.                         <p class='cocoyp-color-242424 cocoyp-font-weight'>".strftime("%Y-%m-%d",$row['pubdate'])."</p>
    202.                         <p class=cocoyp-'color-242424'><img src='/public/images/jmfy/time-icon.png'>".strftime("%H:%M:%S",$row['pubdate'])."</p>
    203.                     </div>
    204.                     <a href='".$arcurl."' class='cocoyp-fl cocoyp-ys-ppzx2-title'>".$row['title']."</a>
    205.                 </li> ";
    206.             $ids.= $row['id'].',';
    207.         }
    208.     if($ids==""){
    209.         $sql = "SELECT arc.* FROM `dede_archives` arc LEFT JOIN `dede_arctype` tp ON arc.typeid = tp.id  WHERE (tp.id=2 or tp.id=9 or tp.id=10) and (arc.title like '%怎%' or arc.title like '%条件%')  ORDER BY arc.pubdate desc limit 0,8";
    210.         $dsql->Execute('me', $sql);
    211.         while ($row = $dsql->GetArray()) {
    212.             $list .= " <li class='cocoyp-ys-per-ppzx2 cocoyp-o-h cocoyp-fl cocoyp-font16'>
    213.                     <div class='cocoyp-fl cocoyp-ys-ppzx2-time'>
    214.                         <p class='cocoyp-color-242424 cocoyp-font-weight'>".strftime("%Y-%m-%d",$row['pubdate'])."</p>
    215.                         <p class=cocoyp-'color-242424'><img src='/public/images/jmfy/time-icon.png'>".strftime("%H:%M:%S",$row['pubdate'])."</p>
    216.                     </div>
    217.                     <a href='".$arcurl."' class='cocoyp-fl cocoyp-ys-ppzx2-title'>".$row['title']."</a>
    218.                 </li> ";
    219.             $ids.= $row['id'].',';
    220.         }
    221.     }
    222.     if($temp==1){
    223.         return $ids;
    224.     }
    225.         return $list;
    226.     }
    227. /***************获取加盟流程相关资讯***************/
    228.    function getjmlc($typename,$temp=0) {
    229.    $ids1 = shorttitle($typename,1);
    230.    $ids2 = getchengshi($typename,1);
    231.    $ids3 = Getjmlr($typename,1);
    232.    $ids4 = Getppjs($typename,1);
    233.    $ids5 = Getjmtj($typename,1);
    234.    $ids6 = Getjmfy($typename,1);
    235.    $a = rtrim($ids1.$ids2.$ids3.$ids4.$ids5.$ids6,',');
    236.         global $dsql;
    237.         $sql = "SELECT arc.* FROM `dede_archives` arc LEFT JOIN `dede_arctype` tp ON arc.typeid = tp.id  WHERE (tp.id=2 or tp.id=9 or tp.id=10) and arc.title like '%流程%' ORDER BY arc.pubdate desc limit 0,8";
    238.         $dsql->Execute('me', $sql);
    239.         while ($row = $dsql->GetArray()) {
    240.             $list .= " <li class='cocoyp-ys-per-ppzx2 cocoyp-o-h cocoyp-fl cocoyp-font16'>
    241.                     <div class='cocoyp-fl cocoyp-ys-ppzx2-time'>
    242.                         <p class='cocoyp-color-242424 cocoyp-font-weight'>".strftime("%Y-%m-%d",$row['pubdate'])."</p>
    243.                         <p class=cocoyp-'color-242424'><img src='/public/images/jmfy/time-icon.png'>".strftime("%H:%M:%S",$row['pubdate'])."</p>
    244.                     </div>
    245.                     <a href='".$arcurl."' class='cocoyp-fl cocoyp-ys-ppzx2-title'>".$row['title']."</a>
    246.                 </li> ";
    247.             $ids.= $row['id'].',';
    248.         }
    249.     if($ids==""){
    250.         $sql = "SELECT arc.* FROM `dede_archives` arc LEFT JOIN `dede_arctype` tp ON arc.typeid = tp.id  WHERE (tp.id=2 or tp.id=9 or tp.id=10) and (arc.title like '%如何%' or arc.title like '%怎样%')  ORDER BY arc.pubdate desc limit 0,8";
    251.         $dsql->Execute('me', $sql);
    252.         while ($row = $dsql->GetArray()) {
    253.             $list .= " <li class='cocoyp-ys-per-ppzx2 cocoyp-o-h cocoyp-fl cocoyp-font16'>
    254.                     <div class='cocoyp-fl cocoyp-ys-ppzx2-time'>
    255.                         <p class='cocoyp-color-242424 cocoyp-font-weight'>".strftime("%Y-%m-%d",$row['pubdate'])."</p>
    256.                         <p class=cocoyp-'color-242424'><img src='/public/images/jmfy/time-icon.png'>".strftime("%H:%M:%S",$row['pubdate'])."</p>
    257.                     </div>
    258.                     <a href='".$arcurl."' class='cocoyp-fl cocoyp-ys-ppzx2-title'>".$row['title']."</a>
    259.                 </li> ";
    260.             $ids.= $row['id'].',';
    261.         }
    262.     }
    263.     if($temp==1){
    264.         return $ids;
    265.     }
    266.         return $list;
    267.     }
    268. /***************获取产品展示相关资讯***************/
    269.    function getcpzs($typename,$temp=0) {
    270.    $ids1 = shorttitle($typename,1);
    271.    $ids2 = getchengshi($typename,1);
    272.    $ids3 = Getjmlr($typename,1);
    273.    $ids4 = Getppjs($typename,1);
    274.    $ids5 = Getjmtj($typename,1);
    275.    $ids6 = Getjmfy($typename,1);
    276.    $ids7 = Getjmlc($typename,1);
    277.    $a = rtrim($ids1.$ids2.$ids3.$ids4.$ids5.$ids6.$ids7,',');
    278.         global $dsql;
    279.         $sql = "SELECT arc.* FROM `dede_archives` arc LEFT JOIN `dede_arctype` tp ON arc.typeid = tp.id  WHERE (tp.id=2 or tp.id=9 or tp.id=10) and arc.title like '%$typename%' ORDER BY arc.pubdate desc limit 0,8";
    280.         $dsql->Execute('me', $sql);
    281.         while ($row = $dsql->GetArray()) {
    282.             $list .= " <li class='cocoyp-ys-per-ppzx2 cocoyp-o-h cocoyp-fl cocoyp-font16'>
    283.                     <div class='cocoyp-fl cocoyp-ys-ppzx2-time'>
    284.                         <p class='cocoyp-color-242424 cocoyp-font-weight'>".strftime("%Y-%m-%d",$row['pubdate'])."</p>
    285.                         <p class=cocoyp-'color-242424'><img src='/public/images/jmfy/time-icon.png'>".strftime("%H:%M:%S",$row['pubdate'])."</p>
    286.                     </div>
    287.                     <a href='".$arcurl."' class='cocoyp-fl cocoyp-ys-ppzx2-title'>".$row['title']."</a>
    288.                 </li> ";
    289.             $ids.= $row['id'].',';
    290.         }
    291.     if($ids==""){
    292.         $sql = "SELECT arc.* FROM `dede_archives` arc LEFT JOIN `dede_arctype` tp ON arc.typeid = tp.id  WHERE (tp.id=2 or tp.id=9 or tp.id=10) and (arc.title like '%怎么%' or arc.title like '%条件%')  ORDER BY arc.pubdate desc limit 0,8";
    293.         $dsql->Execute('me', $sql);
    294.         while ($row = $dsql->GetArray()) {
    295.             $list .= " <li class='cocoyp-ys-per-ppzx2 cocoyp-o-h cocoyp-fl cocoyp-font16'>
    296.                     <div class='cocoyp-fl cocoyp-ys-ppzx2-time'>
    297.                         <p class='cocoyp-color-242424 cocoyp-font-weight'>".strftime("%Y-%m-%d",$row['pubdate'])."</p>
    298.                         <p class=cocoyp-'color-242424'><img src='/public/images/jmfy/time-icon.png'>".strftime("%H:%M:%S",$row['pubdate'])."</p>
    299.                     </div>
    300.                     <a href='".$arcurl."' class='cocoyp-fl cocoyp-ys-ppzx2-title'>".$row['title']."</a>
    301.                 </li> ";
    302.             $ids.= $row['id'].',';
    303.         }
    304.     }
    305.     if($temp==1){
    306.         return $ids;
    307.     }
    308.         return $list;
    309.     }