source: temp/trunk/html/admin/mail/htmlmail_select.php @ 4608

<?php

require_once("../require.php");

class LC_Page {
    
    var $arrForm;
    
    function LC_Page() {
        $this->tpl_mainpage = 'mail/htmlmail_select.tpl';
        $this->tpl_mainno = 'mail';
    }
}

$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 AND status = 1";
    
    /* ÆþÎÏ¥¨¥é¡¼¤Ê¤· */
    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";
    
    // Æɤ߹þ¤àÎó¤È¥Æ¡¼¥Ö¥ë¤Î»ØÄê
    $col = "product_id, name, category_id, main_list_image, status, product_code, price01, stock, stock_unlimited";
    $from = "vw_products_nonclass";
        
    $objQuery = new SC_Query();
    // ¹Ô¿ô¤Î¼èÆÀ
    $linemax = $objQuery->count($from, $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, "fnNaviSearchPage", NAVI_PMAX);
    $objPage->tpl_strnavi = $objNavi->strnavi;      // ɽ¼¨Ê¸»úÎó
    $startno = $objNavi->start_row;
    
    // ¼èÆÀÈϰϤλØÄê(³«»Ï¹ÔÈֹ桢¹Ô¿ô¤Î¥»¥Ã¥È)
    $objQuery->setlimitoffset($page_max, $startno);

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

$objPage->arrCatList = sfGetCategoryList();
$objPage->name = $_GET['name'];


$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);
        }
    }
}

?>