<?php
 /*
  *     日向グルメ情報
  *     2009-04-06 Yutaka Kawano
  */

    require_once("./common.php");
    require_once("XML/RSS.php");

    $PlusFunc = new PlusFunc();






    // ページング
    define("PERPAGE",   "5");



    $act   = htmlspecialchars($_POST["act"]);
    if ( !$act ){ $act   = htmlspecialchars($_GET["act"]); }

    $gid   = htmlspecialchars($_POST["gid"]);
    if ( !$gid ){ $gid   = htmlspecialchars($_GET["gid"]); }

    $dpa   = htmlspecialchars($_POST["dpa"]);
    if ( !$dpa ){ $dpa  = htmlspecialchars($_GET["dpa"]); }



    if ( $term ){
    	// 携帯からのアクセス
        switch($act){
            case 's':
                $a = mob_spot_search();
                break;
            case 'r':
                $a = mob_spot_result();
                break;
            case 'd':
                $a = mob_spot_detail();
                break;
                
            default:
                // TOPページ
                $a = mob_top();
                break;
        }
    }else{
        switch($act){
            case 'd':
                $a = DispDetail($gid);
                break;
            case 'logout':
                $a = Logout();
                break;
            case 'tabelog':
        	    $a = tabelog();
        	    break;
            default:
                // 一覧表示
                $a = DispAll();
                break;
        }
    }

    end;
	


// =================================================================== 
// 物件一覧表示
// =================================================================== 
    function DispAll(){
        global $PlusFunc,$smarty,$cb_name,$shizai_list,$dpa;

        $chk_stl  = htmlspecialchars($_POST["stl"]);
        if ( !$chk_stl ){ $chk_stl  = htmlspecialchars($_GET["stl"]); }
        $chk_jnr  = htmlspecialchars($_POST["jnr"]);
        if ( !$chk_jnr ){ $chk_jnr  = htmlspecialchars($_GET["jnr"]); }
        $chk_budget  = htmlspecialchars($_POST["budget"]);
        if ( !$chk_budget ){ $chk_budget  = htmlspecialchars($_GET["budget"]); }
        $query  = htmlspecialchars($_POST["query"]);
        if ( !$query ){ $query  = htmlspecialchars($_GET["query"]); }


        // MAIN DATA LOAD
        // カテゴリーでデータを絞り込む
        // カテゴリの指定がなかったら"0"


        // 基本情報 LOAD
        $Data = file(C_MAINDATA);
        $PixData  = file(PIXDATA);
        
        // ２次元配列でソートし再度joinで連結。
        $list = array();
        for($i=0;$i<sizeof($Data);$i++){
            $list[$i]=explode(",",$Data[$i]);
        }
        $sort_key_no = '28';
        foreach ( $list as $key => $row ) {
            $sort_key[$key] =$row[$sort_key_no];
        }
        array_multisort( $sort_key , SORT_DESC , $list );
        // join 
        for($i=0;$i<sizeof($Data);$i++){
            $Data[$i] = join(",",$list[$i]);
        }


        // データの抽出
        $line = array();
        $a    = array();
        $stl  = array();
        $jnr  = array();
        $m_cnt = array();

        for( $i=0; $i<sizeof($Data); $i++ ){
            $a = trim($Data[$i]);
            $a = explode(',',$Data[$i]);
            

            // 表示非表示チェック
            if ($a[16]){continue;}
            // 検索文字があれば
            if ( $query && ( !strstr($Data[$i], $query))){ continue; }

                // スタイル
                $find_stl = '';
                $n = explode('-',trim($a[26]));
                if ($n){
                    foreach ($n as $key => $value){
                        $stl[$value]++;
                        if ($value == $chk_stl){ $find_stl=1; }
                    }
                }
                // ジャンル
                $find_jnr = '';
                $n = explode('-',trim($a[27]));
                if ($n){
                    foreach ($n as $key => $value){
                        $jnr[$value]++;
                        if ($value == $chk_jnr){ $find_jnr=1; }
                    }
                }
                // 予算
                $find_budget = '';
                $n = explode('-',trim($a[29]));
                if ($n){
                    foreach ($n as $key => $value){
                        $budget[$value]++;
                        if ($value == $chk_budget){ $find_budget=1; }
                    }
                }
                
                if ($chk_stl&&(!$find_stl)){ continue; }
                if ($chk_jnr&&(!$find_jnr)){ continue; }
                if ($chk_budget&&(!$find_budget)){ continue; }
                
                
                // 画像セット
                $pixname = array();
                for($pi=0;$pi<sizeof($PixData);$pi++){
                    $pa = explode( ",",$PixData[$pi] );
                    $pa[2] = trim( $pa[2] );
                    if ( ($a[0]==$pa[0]) ){
			            array_push( $pixname , $pa[2] );
                    }
                }
                if (!$pixname){ $pixname[0] = '/cat.gif'; }
                
                if ($a[15]){ $ymd = date('Y/m/d',$a[15]); }else{ $ymd = ""; } 
                $note = ereg_replace("&lt;br/&gt;","<br/>",$a[14]);
                $desc = ereg_replace("&lt;br/&gt;","<br/>",$a[18]);

             $line[$i] = array(
                gid         => $a[0],
                c_id        => $a[0],
                c_name      => trim( $a[1] ),
                c_zip       => trim( $a[3] ),
                c_pref      => $PREF{$a[4]},
                c_adrs1     => trim( $a[5] ),
                c_adrs2     => trim( $a[6] ),
                c_tel       => trim( $a[7] ),
                c_mtel      => trim( $a[8] ),
                c_hp        => trim( $a[10] ),
                c_blog      => trim( $a[11] ),
                c_x         => trim( $a[12] ),
                c_y         => trim( $a[13] ),
                c_note      => trim( $note ),
                c_utc       => trim( $ymd ),
                c_disp      => trim( $a[16] ),
                c_catch     => trim( $a[17] ),
                c_desc      => trim( $desc ),
                c_ontime    => trim( $a[19] ),
                c_offtime   => trim( $a[20] ),
                c_access    => trim( $a[21] ),
                pixname     => $pixname,
             );
                
        }

        // 最新更新情報
        // 最新の更新順でソートし再度joinで連結。
        $sort_key_no = '15';
        foreach ( $list as $key => $row ) {
            $sort_key[$key] =$row[$sort_key_no];
        }
        array_multisort( $sort_key , SORT_DESC , $list );
        // join 
        for($i=0;$i<sizeof($Data);$i++){
            $Data[$i] = join(",",$list[$i]);
        }
        $n = 0;
        for( $i=0; $i<sizeof($Data); $i++ ){
            $a = trim($Data[$i]);
            $a = explode(',',$Data[$i]);
            if ($a[16]){continue;}
            $renew_item[$n] = array(
                c_id        => $a[0],
                c_name      => trim( $a[1] ),
                c_utc       => date('m/d',$a[15]),
                c_catch     => trim( $a[17] ),
            );
            $n++;
            if ($n==5){ break; }
        }


        // スタイル
        $keywords = array();
        $Data = file(STLDATA);
        $stl_html="";
        if ($stl){
            foreach ($stl as $key => $value){
                if ( $key && $value ) {
                    $stl_html.= "<a href='./index.php5?stl=".$key."'>".$Data[($key-1)] ."(".$value.")</a>　";
                }
            }
        }
        if ( $chk_stl&&$Data[($chk_stl-1)] ){ array_push($keywords,$Data[($chk_stl-1)]); }
        
        // ジャンル
        $Data = file(JNRDATA);
        $jnr_html="";
        if ($jnr){
            foreach ($jnr as $key => $value){
                if ( $key && $value ) {
                    $jnr_html.= "<a href='./index.php5?jnr=".$key."'>".$Data[($key-1)] ."(".$value.")</a>　";
                }
            }
        }
        if ( $chk_jnr&&$Data[($chk_jnr-1)] ){ array_push($keywords,$Data[($chk_jnr-1)]); }
        
        // 予算
        $Data = file(BUDGETDATA);
        $budget_html="";
        if ($budget){
            foreach ($budget as $key => $value){
                if ( $key && $value ) {
                	$a = explode( "-",$Data[($key-1)]);
                	if ( $a[0] ){ $bu = number_format($a[0]); }
                	if ( $a[1] ){ $bu.= "-".number_format($a[1]); }else{ $bu.= "-"; }
                    $budget_html.= "<a href='./index.php5?budget=".$key."'>".$bu ."円(".$value.")</a>　";
                }
            }
        }
        if ( $chk_budget&&$Data[($chk_budget-1)] ){ array_push($keywords,$Data[($chk_budget-1)]); }
        // フリーワード
        if ( $query ){ array_push($keywords,$query); }

        // ページジングパラメータセット
        $perPage = PERPAGE;
        $p = htmlspecialchars($_GET["p"]);
        $DataVol = sizeof($line);
        $p1 = ( $p-1 )  * $perPage;if ($p1 < 0){ $p1 = 0; }
        $p2 = $p1 + $perPage;if ($p2 > $DataVol){$p2 = $DataVol;}

        $pager = $PlusFunc->pager($perPage, $DataVol, $p, $param);

        // ファイル最終更新時刻
        $LastUpdated = date( 'Y/m/d', filemtime(C_MAINDATA) );


        // 一覧表 Ajax csv2tableに渡すデータを作成
        // ajax に住所を渡すcadrs
        // $csvdata = '会員名,会員住所,電話番号\n';
                
        $i = 0;
        $n = 0;
        $cid = $cname = $cadrs = $cmapx = $cmapy = $cno = $ctel = '';
        if ($line) {
            foreach ($line as $key => $value){
                if ( !$dpa ) {
              	  if (( $i < $p1 )||( $p2 < $i )){ $i++; continue; }
                }
                if ($i==0){
                	$desc = mb_strimwidth ($value['c_desc'] ,0,120,"...","UTF-8");
               	
                    $csvdata = '<table><tr>';
                    $csvdata.= '<tr><td class="pp"><img src="./images/oss.gif" align="right"><a href="./sub.php5?gid='.$value['c_id'].'"><img src="./data/img'.$value['pixname'][0].'" class="pp_pix40"></a>'.
                	           '<p class="pp"><div class="pp_catch">'.$value['c_catch'].'</div><br/>'.
                	           '<a href="./sub.php5?gid='.$value['c_id'].'"><div style="font-size:30px;font-weight:bold;margin:0 0 10px 0;">'. $value['c_name'].'</a></div>'.
                               '<div class="pp_map"><a href="./sub.php5?gid='.$value['c_id'].'">詳細</a> | '.
                               $desc.'<br/>'.
                               '<div class="pp_tel"><img src="./images/icon_tel.gif"> '.$value['c_tel'].'</div>'.
                               '</p>';
                               
                    if ( $value['pixname'][1] ) {
                        $csvdata.= '<div>';
                        $csvdata.= '<img src="./data/img'.$value['pixname'][1].'" class="pp_pix20">';
                    }
                    if ( $value['pixname'][2] ) { $csvdata.= '<img src="./data/img'.$value['pixname'][2].'" class="pp_pix20">'; }
                    // if ( $value['pixname'][3] ) { $csvdata.= '<img src="./data/img'.$value['pixname'][3].'" class="pp_pix20">'; }
                    if ( $value['pixname'][1] ) { $csvdata.= '</div><br clear="both">'; }
                    
                    if ( $value['c_access'] ){ $csvdata.= '<font color="#2AABE4">■</font>アクセス　'.$value['c_access'].'<br/>'; }
                    if ( $value['c_ontime'] ){ $csvdata.= '<font color="#2AABE4">■</font>営業時間　'.$value['c_ontime'].'<br/>'; }
                    if ( $value['c_offtime']){ $csvdata.= '<font color="#2AABE4">■</font>定 休 日　'.$value['c_offtime'].'<br/>'; }
                    if ( $value['c_adrs1'])  { $csvdata.= '<font color="#2AABE4">■</font>住　　所　'.$value['c_adrs1'].$value['c_adrs2'].'<br/>'; }
                    
                    $csvdata.= '</td></tr></table>';
                    $pickup_flg = '1';
                }
                if ( ($pickup_flg&&($n==1)) || (!$pickup_flg&&($n==0)) ){
                    $csvdata .= '<table class="sortable resizable"><thead><tr>';
                    $csvdata .= '<th id="m_pix"><img src="./images/icon_file.png" border="0"></th>';
                    $csvdata .= '<th id="m_name">店舗名</th>';
                    $csvdata .= '<th id="m_tel">電話番号</th>';
                    $csvdata .= '<th id="m_adrs">住所</th>';
                    $csvdata .= '</tr></thead><tbody>';
                    $table_flg = '1';
                }
                if ( (!$pickup_flg) || ($pickup_flg&&($n>0)) ){
                    $csvdata.='<tr><td><a href="./sub.php5?gid='.$value['c_id'].'"><img src="./data/img'.$value['pixname'][0].'" width="80" border="0" ></a></td>'.
                	      '<td><div style="font-size:normal;font-weight:bold;"><a href="./sub.php5?gid='.$value['c_id'].'">'.$value['c_name'].'</a></div></td>'.
                          '<td align="center"><div style="font-size:large;font-weight:bold;color:#EF1F15">'. $value['c_tel'].'</div></td>'.
                          '</td><td>'.$value['c_adrs1'].$value['c_adrs2'].
                          '<div style="font-size:xx-small"><a href="javascript:void(0)" onmouseover="showCloseUp('.$n.')"> <img src="./images/icon_map_s.png" align="absmidde" border="0">'.($i+1).'</a></div></td>'.
                          '</tr>';
                }
                
                if ($cadrs){ $cid.=','; $cname.=','; $cadrs.=','; $cmapx.=','; $cmapy.=','; $cno.=','; $ctel.=',';}
                $cid.= '"'.$value['c_id'].'"';
                $cname.= '"'.$value['c_name'].'"';
                $cadrs.= '"'.$value['c_adrs1'].$value['c_adrs2'].'"';
                $ctel.= '"'.$value['c_tel'].'"';
                $cmapx.= $value['c_x'];
                $cmapy.= $value['c_y'];
                $cno.= $i+1;
                $i++;
                $n++;
            }
            if ( $table_flg ){
                $csvdata .= '</tbody></table>';
                $csvdata .= '<p align="right">上部の項目名をクリックすると並べ替えができます。</p>';
            }
        }

        // Navi
        $cnt="";
        for($i=0;$i<sizeof($keywords);$i++){
            $search_keywords.=$cnt.$keywords[$i];
            $cnt=" ";
        }
        if ( !$keywords ){ array_push($keywords,"日向市"); }
        
        if ($chk_stl){ $navi = "■スタイルでえらぶ > ".$search_keywords; }
        if ($chk_jnr){ $navi = "■メニューでえらぶ > ".$search_keywords; }
        if ($chk_budget){ $navi = "■予算でえらぶ > " .$search_keywords."円"; }
        if ($query){ $navi = "■フリーワード検索 > " .$search_keywords; }

        // RSS
        $googleblog_search_keywords = rawurlencode("日向市");
        $cnt= "+AND+";
        for($i=0;$i<sizeof($keywords);$i++){
            $googleblog_search_keywords.=$cnt.rawurlencode($keywords[$i]);
            $cnt = "+OR+";
        }
        $rss =& new XML_RSS("http://blogsearch.google.co.jp/blogsearch_feeds?hl=ja&lr=lang_ja&q=".$googleblog_search_keywords."&ie=utf-8&num=5&output=rss");
        $rss->parse();
        $smarty->assign('rss_items', $rss->getItems()  );
        $smarty->assign('keywords', $keywords  );

        // Yahoo! 知恵袋
        $CHIE_SEARCH_API_HOST  = 'chiebukuro.yahooapis.jp';
        $CHIE_SEARCH_API_URL   = '/Chiebukuro/V1/questionSearch';
        $CHIE_SEARCH_API_APPID = 'KUVgfIexg65H872xdUOAY0gHHd0CC14UQ2sMiKfbdXAbfmIXH6962Bqlh_FeeLgLhqbTWw--';

        $chie_search_keywords = '';
        $cnt = '';
        for($i=0;$i<sizeof($keywords);$i++){
            $chie_search_keywords.=$cnt.rawurlencode($keywords[$i]);
            $cnt = "+";
        }
        

       
        $responseXML = '';
        $curl = curl_init();
        curl_setopt($curl, CURLOPT_URL, "http://${CHIE_SEARCH_API_HOST}${CHIE_SEARCH_API_URL}?appid=${CHIE_SEARCH_API_APPID}&categoryid=2078297962&type=any&query=".$chie_search_keywords);
        curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
        $responseXML = curl_exec($curl);
        curl_close($curl);
        $xmlObj = simplexml_load_string($responseXML);
        $i=0;
        $c=array();
        if ( $xmlObj->{'Result'}->{'Question'} ){
            foreach($xmlObj->{'Result'}->{'Question'} as $que) {
                $c[$i] = array(
              	    Content    => $que->{'Content'},
                    Url        => $que->{'Url'},
                );
                $i++;
            }
        }
        $smarty->assign('chie_bukuro', $c  );


        // 表示
        $smarty->clear_cache('index.html');

        $smarty->assign('THIS_URL',THIS_URL);
        $smarty->assign('pager', $pager);
        $smarty->assign('perpage', PERPAGE);
        $smarty->assign('lastupdated', $LastUpdated);
        $smarty->assign('csvdata', $csvdata);
        $smarty->assign('GMAP_API_KEY', GMAP_API_KEY );
        $smarty->assign('ggl_x', 131.6278839111328 );
        $smarty->assign('ggl_y', 32.42532588248989 );
        
        $smarty->assign('stl_html', $stl_html);
        $smarty->assign('jnr_html', $jnr_html);
        $smarty->assign('budget_html', $budget_html);
        
        $qq = $PlusFunc->tabelog($keywords);
        $smarty->assign('tabelog', $qq);
        
        $smarty->assign('navi', $navi);
        $smarty->assign('renew_item', $renew_item);
        $smarty->assign('cid'  ,$cid);
        $smarty->assign('cname',$cname);
        $smarty->assign('cadrs',$cadrs);
        $smarty->assign('ctel' ,$ctel );
        $smarty->assign('cmapx',$cmapx);
        $smarty->assign('cmapy',$cmapy);
        $smarty->assign('cno'  ,$cno  );

        $smarty->assign('v_id'  ,'1'  );

        $smarty->display('index.html');


    }




// =================================================================== 
// 携帯用 
// =================================================================== 

// =================================================================== 
// 携帯用  TOP 
// =================================================================== 
    function mob_top(){
        global $PlusFunc,$smarty,$cb_name,$shizai_list,$dpa,$sel,$SEL_FILE;

        // 表示
        $smarty->clear_cache('mob_index.html');

        $smarty->display('mob_index.html');

    }
    
// =================================================================== 
// 携帯用  スポット検索画面
// =================================================================== 
    function mob_spot_search(){
        global $PlusFunc,$smarty,$cb_name,$shizai_list,$dpa,$sel,$SEL_FILE;

        for($i=0;$i<sizeof($sel);$i++){
            $chk[$i] = htmlspecialchars($_POST[ $sel[$i] ]);
            if ( !$chk[$i] ){ $chk[$i]  = htmlspecialchars($_GET[ $sel[$i] ]); }
        }

        $query  = htmlspecialchars($_POST["query"]);
        if ( !$query ){ $query  = htmlspecialchars($_GET["query"]); }

        // MAIN DATA LOAD
        // 基本情報 LOAD
        $Data = file(C_MAINDATA);
        $PixData  = file(PIXDATA);
        
        // データの抽出
        $line = array();
        $a    = array();
        $find = array();
        
        for( $i=0; $i<sizeof($Data); $i++ ){
            $a = trim($Data[$i]);
            $a = explode(',',$Data[$i]);

            // 表示非表示チェック
            if ($a[16]){continue;}
            // 検索文字があれば
            if ( $query && ( !strstr($Data[$i], $query))){ continue; }

            // スタイル
                $find_stl = '';
                $n = explode('-',trim($a[26]));
                if ($n){
                    foreach ($n as $key => $value){
                        $stl[$value]++;
                        if ($value == $chk_stl){ $find_stl=1; }
                    }
                }
            // ジャンル
                $find_jnr = '';
                $n = explode('-',trim($a[27]));
                if ($n){
                    foreach ($n as $key => $value){
                        $jnr[$value]++;
                        if ($value == $chk_jnr){ $find_jnr=1; }
                    }
                }
            // 予算
                $find_budget = '';
                $n = explode('-',trim($a[29]));
                if ($n){
                    foreach ($n as $key => $value){
                        $budget[$value]++;
                        if ($value == $chk_budget){ $find_budget=1; }
                    }
                }

       }


        // スタイル
        $keywords = array();
        $Data = file(STLDATA);
        $stl_html="";
        if ($stl){
            foreach ($stl as $key => $value){
                if ( $key && $value ) {
                    $stl_html.= "<a href='./?act=r&stl=".$key."'>".$Data[($key-1)]."(".$value.")</a>　";
                }
            }
        }
        if ( $chk_stl&&$Data[($chk_stl-1)] ){ array_push($keywords,$Data[($chk_stl-1)]); }
        
        // ジャンル
        $Data = file(JNRDATA);
        $jnr_html="";
        if ($jnr){
            foreach ($jnr as $key => $value){
                if ( $key && $value ) {
                    $jnr_html.= "<a href='./?act=r&jnr=".$key."'>".$Data[($key-1)]."(".$value.")</a>　";
                }
            }
        }
        if ( $chk_jnr&&$Data[($chk_jnr-1)] ){ array_push($keywords,$Data[($chk_jnr-1)]); }
        
        // 予算
        $Data = file(BUDGETDATA);
        $budget_html="";
        if ($budget){
            foreach ($budget as $key => $value){
                if ( $key && $value ) {
                	$a = explode( "-",$Data[($key-1)]);
                	if ( $a[0] ){ $bu = number_format($a[0]); }
                	if ( $a[1] ){ $bu.= "-".number_format($a[1]); }else{ $bu.= "-"; }
                    $budget_html.= "<a href='./?act=r&budget=".$key."'>".$bu ."円(".$value.")</a><br/>";
                }
            }
        }

        // 表示
        $smarty->clear_cache('mob_spot_search.html');
        $smarty->assign('stl_html', $stl_html);
        $smarty->assign('jnr_html', $jnr_html);
        $smarty->assign('budget_html', $budget_html);

        $smarty->display('mob_spot_search.html');

    }
    
// =================================================================== 
// 携帯用  スポット検索結果
// =================================================================== 
    function mob_spot_result(){
        global $PlusFunc,$smarty,$cb_name,$shizai_list,$dpa,$sel,$SEL_FILE;

        $chk_stl  = htmlspecialchars($_POST["stl"]);
        if ( !$chk_stl ){ $chk_stl  = htmlspecialchars($_GET["stl"]); }
        $chk_jnr  = htmlspecialchars($_POST["jnr"]);
        if ( !$chk_jnr ){ $chk_jnr  = htmlspecialchars($_GET["jnr"]); }
        $chk_budget  = htmlspecialchars($_POST["budget"]);
        if ( !$chk_budget ){ $chk_budget  = htmlspecialchars($_GET["budget"]); }
        $query  = htmlspecialchars($_POST["query"]);
        if ( !$query ){ $query  = htmlspecialchars($_GET["query"]); }


        // MAIN DATA LOAD
        // カテゴリーでデータを絞り込む

        // 基本情報 LOAD
        $Data = file(C_MAINDATA);
        $PixData  = file(PIXDATA);
        
        // ２次元配列でソートし再度joinで連結。
        $list = array();
        for($i=0;$i<sizeof($Data);$i++){
            $list[$i]=explode(",",$Data[$i]);
        }
        $sort_key_no = '28';
        foreach ( $list as $key => $row ) {
            $sort_key[$key] =$row[$sort_key_no];
        }
        array_multisort( $sort_key , SORT_DESC , $list );
        // join 
        for($i=0;$i<sizeof($Data);$i++){
            $Data[$i] = join(",",$list[$i]);
        }


        // データの抽出
        $line = array();
        $a    = array();
        $bb   = array();
        
        for( $i=0; $i<sizeof($Data); $i++ ){
            $a = trim($Data[$i]);
            $a = explode(',',$Data[$i]);

            // 表示非表示チェック
            if ($a[16]){continue;}
            // 検索文字があれば
            if ( $query && ( !strstr($Data[$i], $query))){ continue; }
            
                // スタイル
                $find_stl = '';
                $n = explode('-',trim($a[26]));
                if ($n){
                    foreach ($n as $key => $value){
                        $stl[$value]++;
                        if ($value == $chk_stl){ $find_stl=1; }
                    }
                }
                // ジャンル
                $find_jnr = '';
                $n = explode('-',trim($a[27]));
                if ($n){
                    foreach ($n as $key => $value){
                        $jnr[$value]++;
                        if ($value == $chk_jnr){ $find_jnr=1; }
                    }
                }
                // 予算
                $find_budget = '';
                $n = explode('-',trim($a[29]));
                if ($n){
                    foreach ($n as $key => $value){
                        $budget[$value]++;
                        if ($value == $chk_budget){ $find_budget=1; }
                    }
                }
                
                if ($chk_stl&&(!$find_stl)){ continue; }
                if ($chk_jnr&&(!$find_jnr)){ continue; }
                if ($chk_budget&&(!$find_budget)){ continue; }
                

            $line[$i] = array(
                gid         => $a[0],
                c_id        => $a[0],
                c_name      => trim( $a[1] ),
                c_zip       => trim( $a[3] ),
                c_pref      => $PREF{$a[4]},
                c_adrs1     => trim( $a[5] ),
                c_adrs2     => trim( $a[6] ),
                c_tel       => trim( $a[7] ),
                c_mtel      => trim( $a[8] ),
                c_hp        => trim( $a[10] ),
                c_blog      => trim( $a[11] ),
                c_x         => trim( $a[12] ),
                c_y         => trim( $a[13] ),
                c_note      => trim( $note ),
                c_utc       => trim( $ymd ),
                c_disp      => trim( $a[16] ),
                c_catch     => trim( $a[17] ),
                c_desc      => trim( $desc ),
                c_ontime    => trim( $a[19] ),
                c_offtime   => trim( $a[20] ),
                c_access    => trim( $a[21] ),
                pixname     => $pixname,
             );
                
        }

        // 最新更新情報
        // 最新の更新順でソートし再度joinで連結。
        $sort_key_no = '15';
        foreach ( $list as $key => $row ) {
            $sort_key[$key] =$row[$sort_key_no];
        }
        array_multisort( $sort_key , SORT_DESC , $list );
        // join 
        for($i=0;$i<sizeof($Data);$i++){
            $Data[$i] = join(",",$list[$i]);
        }
        $n = 0;
        for( $i=0; $i<sizeof($Data); $i++ ){
            $a = trim($Data[$i]);
            $a = explode(',',$Data[$i]);
            if ($a[16]){continue;}
            if ($a[15]){ $ymd = date('m/d',$a[15]); }
            $renew_item[$n] = array(
                c_id        => $a[0],
                c_name      => trim( $a[1] ),
                c_utc       => $ymd,
                c_catch     => trim( $a[17] ),
            );
            $n++;
            if ($n==5){ break; }
        }


        // ページジングパラメータセット
        $perPage = PERPAGE;
        $p = htmlspecialchars($_GET["p"]);
        $DataVol = sizeof($line);
        $p1 = ( $p-1 )  * $perPage;if ($p1 < 0){ $p1 = 0; }
        $p2 = $p1 + $perPage;if ($p2 > $DataVol){$p2 = $DataVol;}

        $pager = $PlusFunc->pager($perPage, $DataVol, $p, $param);


        // Navi
        // 検索タイプ
        $keywords = array();
        $Data = file(STLDATA);
        if ( $chk_stl&&$Data[($chk_stl-1)] ){ $search_keywords = $Data[($chk_stl-1)]; }
        $Data = file(JNRDATA);
        if ( $chk_jnr&&$Data[($chk_jnr-1)] ){ $search_keywords = $Data[($chk_jnr-1)]; }
        $Data = file(BUDGETDATA);
        if ( $chk_budget&&$budget ){
             $a = explode( "-",$Data[($chk_budget-1)]);
             if ( $a[0] ){ $bu = number_format($a[0]); }
             if ( $a[1] ){ $bu.= "-".number_format($a[1]); }else{ $bu.= "-"; }
             $search_keywords = $bu ."円";
        }
        if ($chk_stl)   { $navi = " スタイルでえらぶ : ".$search_keywords; $chk_sel_name = 'stl'; $chk_no = $chk_stl; }
        if ($chk_jnr)   { $navi = " メニューでえらぶ : ".$search_keywords; $chk_sel_name = 'jnr'; $chk_no = $chk_jnr;}
        if ($chk_budget){ $navi = " 予算でえらぶ : "    .$search_keywords; $chk_sel_name = 'budget'; $chk_no = $chk_budget;}
        if ($query)     { $navi = " フリーワード検索 : ".$search_keywords; }


        // 一覧表 Ajax csv2tableに渡すデータを作成
        $i = 0;
        if ($line) {
            foreach ($line as $key => $value){
        	if (( $i < $p1 )||( $p2 < $i )){ $i++; continue; }
                $csvdata.= '<li><a href="./sub.php5?gid='.$value['c_id'].'&navi='.urlencode($navi).'&csn='.$chk_sel_name.'&cn='.$chk_no.'">'. $value['c_name'].'</a></li>';
                $i++;
            }
        }


        // 表示
        $smarty->clear_cache('mob_search_result.html');

        $smarty->assign('THIS_URL',THIS_URL);
        $smarty->assign('pager', $pager);
        $smarty->assign('perpage', PERPAGE);
        $smarty->assign('csvdata', $csvdata);
        
        $smarty->assign('navi', $navi );
        
        $smarty->display('mob_search_result.html');
    }

?>