source: branches/dev/html/admin/contents/recommend_search.php @ 17

<?php
/*
 * Copyright(c) 2000-2007 LOCKON CO.,LTD. All Rights Reserved.
 *
 * http://www.lockon.co.jp/
 */
require_once("../require.php");

class LC_Page {
    
    function LC_Page() {
        $this->tpl_mainpage = 'contents/recomend_search.tpl';
        $this->tpl_mainno = 'contents';
        $this->tpl_subnavi = '';
        $this->tpl_subno = "";
    }
}

$conn = new SC_DBConn();
$objPage = new LC_Page();
$objView = new SC_AdminView();
$objSess = new SC_Session();

// ǧ¾Ú²ÄÈݤÎȽÄê
sfIsSuccess($objSess);

if ($_POST['mode'] == "search") {
    
    // POSTÃͤΰú¤­·Ñ¤®
    $objPage->arrForm = $_POST;
    // ÆþÎÏʸ»ú¤Î¶¯À©ÊÑ´¹
    lfConvertParam();
    
    
    $where = "del_flg = 0";
    
    /* ÆþÎÏ¥¨¥é¡¼¤Ê¤· */
    foreach ($objPage->arrForm as $key => $val) {
        if($val == "") {
            continue;
        }
        
        switch ($key) {
            case 'search_name':
                
                $where .= " AND name ILIKE ?";
                $arrval[] = "%$val%";
                break;
            case 'search_category_id':
                // »Ò¥«¥Æ¥´¥êID¤Î¼èÆÀ
                $arrRet = sfGetChildsID("dtb_category", "parent_category_id", "category_id", $val);
                $tmp_where = "";
                foreach ($arrRet as $val) {
                    if($tmp_where == "") {
                        $tmp_where.= " AND ( category_id = ?";
                    } else {
                        $tmp_where.= " OR category_id = ?";
                    }
                    $arrval[] = $val;
                }
                $where.= $tmp_where . " )";
                break;
            case 'search_product_code':
                $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? GROUP BY product_id)";
                $where .= " OR product_code ILIKE ?";
                $arrval[] = "%$val%";
                $arrval[] = "%$val%";
                break;
            default:
                break;
        }
    }
    
    $order = "update_date DESC, product_id DESC";
    
    // Æɤ߹þ¤àÎó¤È¥Æ¡¼¥Ö¥ë¤Î»ØÄê
    $col = "product_id, name, category_id, main_list_image, status, product_code, price01, stock, stock_unlimited";
    $from = "vw_products_nonclass AS noncls ";
        
    $objQuery = new SC_Query();
    // ¹Ô¿ô¤Î¼èÆÀ
    $linemax = $objQuery->count("dtb_products", $where, $arrval);
    $objPage->tpl_linemax = $linemax;               // ²¿·ï¤¬³ºÅö¤·¤Þ¤·¤¿¡£É½¼¨ÍÑ

    // ¥Ú¡¼¥¸Á÷¤ê¤Î½èÍý
    if(is_numeric($_POST['search_page_max'])) { 
        $page_max = $_POST['search_page_max'];
    } else {
        $page_max = SEARCH_PMAX;
    }

    // ¥Ú¡¼¥¸Á÷¤ê¤Î¼èÆÀ
    $objNavi = new SC_PageNavi($_POST['search_pageno'], $linemax, $page_max, "fnNaviSearchOnlyPage", NAVI_PMAX);
    $objPage->tpl_strnavi = $objNavi->strnavi;      // ɽ¼¨Ê¸»úÎó
    $startno = $objNavi->start_row;

    // ¼èÆÀÈϰϤλØÄê(³«»Ï¹ÔÈֹ桢¹Ô¿ô¤Î¥»¥Ã¥È)
    if(DB_TYPE != "mysql") $objQuery->setlimitoffset($page_max, $startno);
    // ɽ¼¨½ç½ø
    $objQuery->setorder($order);

    // view¤â¹Ê¹þ¤ß¤ò¤«¤±¤ë(mysqlÍÑ)
    sfViewWhere("&&noncls_where&&", $where, $arrval, $objQuery->order . " " .  $objQuery->setlimitoffset($page_max, $startno, true));

    // ¸¡º÷·ë²Ì¤Î¼èÆÀ
    $objPage->arrProducts = $objQuery->select($col, $from, $where, $arrval);
}

// ¥«¥Æ¥´¥ê¼èÆÀ
$objPage->arrCatList = sfGetCategoryList();






//----¡¡¥Ú¡¼¥¸É½¼¨
$objView->assignobj($objPage);
$objView->display($objPage->tpl_mainpage);



//---------------------------------------------------------------------------------------------------------------------------------------------------------

/* ¼èÆÀʸ»úÎó¤ÎÊÑ´¹ */
function lfConvertParam() {
    global $objPage;
    /*
     *  ʸ»úÎó¤ÎÊÑ´¹
     *  K :  ¡ÖȾ³Ñ(ŽÊŽÝŽ¶Ž¸)ÊÒ²¾Ì¾¡×¤ò¡ÖÁ´³ÑÊÒ²¾Ì¾¡×¤ËÊÑ´¹
     *  C :  ¡ÖÁ´³Ñ¤Ò¤é²¾Ì¾¡×¤ò¡ÖÁ´³Ñ¤«¤¿²¾Ì¾¡×¤ËÊÑ´¹
     *  V :  ÂùÅÀÉÕ¤­¤Îʸ»ú¤ò°ìʸ»ú¤ËÊÑ´¹¡£"K","H"¤È¶¦¤Ë»ÈÍѤ·¤Þ¤¹  
     *  n :  ¡ÖÁ´³Ñ¡×¿ô»ú¤ò¡ÖȾ³Ñ(ŽÊŽÝŽ¶Ž¸)¡×¤ËÊÑ´¹
     */
    $arrConvList['search_name'] = "KVa";
    $arrConvList['search_product_code'] = "KVa";
    
    // ʸ»úÊÑ´¹
    foreach ($arrConvList as $key => $val) {
        // POST¤µ¤ì¤Æ¤­¤¿ÃͤΤßÊÑ´¹¤¹¤ë¡£
        if(isset($objPage->arrForm[$key])) {
            $objPage->arrForm[$key] = mb_convert_kana($objPage->arrForm[$key] ,$val);
        }
    }
}


?>