source: branches/comu/html/admin/mail/htmlmail_select.php @ 2

Revision 2, 3.3 KB checked in by root, 17 years ago (diff)

new import

Line 
1<?php
2/*
3 * Copyright(c) 2000-2006 LOCKON CO.,LTD. All Rights Reserved.
4 *
5 * http://www.lockon.co.jp/
6 */
7require_once("../require.php");
8
9class LC_Page {
10   
11    var $arrForm;
12   
13    function LC_Page() {
14        $this->tpl_mainpage = 'mail/htmlmail_select.tpl';
15        $this->tpl_mainno = 'mail';
16    }
17}
18
19$conn = new SC_DBConn();
20$objPage = new LC_Page();
21$objView = new SC_AdminView();
22$objSess = new SC_Session();
23
24// ǧ¾Ú²ÄÈݤÎȽÄê
25sfIsSuccess($objSess);
26
27if ($_POST['mode'] == "search") {
28   
29    // POSTÃͤΰú¤­·Ñ¤®
30    $objPage->arrForm = $_POST;
31    // ÆþÎÏʸ»ú¤Î¶¯À©ÊÑ´¹
32    lfConvertParam();
33   
34    // ºï½ü¤µ¤ì¤Æ¤¤¤Ê¤¤¡£¸ø³«¾¦ÉʤǤ¢¤ë¡£
35    $where = "del_flg = 0 AND status = 1";
36   
37    /* ÆþÎÏ¥¨¥é¡¼¤Ê¤· */
38    foreach ($objPage->arrForm as $key => $val) {
39        if($val == "") {
40            continue;
41        }
42       
43        switch ($key) {
44            case 'search_name':
45                $where .= " AND name ILIKE ?";
46                $arrval[] = "%$val%";
47                break;
48            case 'search_category_id':
49                // »Ò¥«¥Æ¥´¥êID¤Î¼èÆÀ
50                $arrRet = sfGetChildsID("dtb_category", "parent_category_id", "category_id", $val);
51                $tmp_where = "";
52                foreach ($arrRet as $val) {
53                    if($tmp_where == "") {
54                        $tmp_where.= " AND ( category_id = ?";
55                    } else {
56                        $tmp_where.= " OR category_id = ?";
57                    }
58                    $arrval[] = $val;
59                }
60                $where.= $tmp_where . " )";
61                break;
62            case 'search_product_code':
63                $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? GROUP BY product_id)";
64                $where .= " OR product_code ILIKE ?";
65                $arrval[] = "%$val%";
66                $arrval[] = "%$val%";
67                break;
68            default:
69                break;
70        }
71    }
72   
73    $order = "update_date DESC";
74   
75    // Æɤ߹þ¤àÎó¤È¥Æ¡¼¥Ö¥ë¤Î»ØÄê
76    $col = "product_id, name, category_id, main_list_image, status, product_code, price01, stock, stock_unlimited";
77    $from = "vw_products_nonclass AS noncls ";
78       
79    $objQuery = new SC_Query();
80    // ¹Ô¿ô¤Î¼èÆÀ
81    $linemax = $objQuery->count($from, $where, $arrval);
82    $objPage->tpl_linemax = $linemax;               // ²¿·ï¤¬³ºÅö¤·¤Þ¤·¤¿¡£É½¼¨ÍÑ
83   
84    // ¥Ú¡¼¥¸Á÷¤ê¤Î½èÍý
85    if(is_numeric($_POST['search_page_max'])) {
86        $page_max = $_POST['search_page_max'];
87    } else {
88        $page_max = SEARCH_PMAX;
89    }
90   
91    // ¥Ú¡¼¥¸Á÷¤ê¤Î¼èÆÀ
92    $objNavi = new SC_PageNavi($_POST['search_pageno'], $linemax, $page_max, "fnNaviSearchPage", NAVI_PMAX);
93    $objPage->tpl_strnavi = $objNavi->strnavi;      // ɽ¼¨Ê¸»úÎó
94    $startno = $objNavi->start_row;
95   
96    // ¼èÆÀÈϰϤλØÄê(³«»Ï¹ÔÈֹ桢¹Ô¿ô¤Î¥»¥Ã¥È)
97    $objQuery->setlimitoffset($page_max, $startno);
98
99    // ɽ¼¨½ç½ø
100    $objQuery->setorder($order);
101    // ¸¡º÷·ë²Ì¤Î¼èÆÀ
102    $objPage->arrProducts = $objQuery->select($col, $from, $where, $arrval);
103       
104}
105
106$objPage->arrCatList = sfGetCategoryList();
107$objPage->name = $_GET['name'];
108
109
110$objView->assignobj($objPage);
111$objView->display($objPage->tpl_mainpage);
112
113/* ¼èÆÀʸ»úÎó¤ÎÊÑ´¹ */
114function lfConvertParam() {
115    global $objPage;
116    /*
117     *  ʸ»úÎó¤ÎÊÑ´¹
118     *  K :  ¡ÖȾ³Ñ(ŽÊŽÝŽ¶Ž¸)ÊÒ²¾Ì¾¡×¤ò¡ÖÁ´³ÑÊÒ²¾Ì¾¡×¤ËÊÑ´¹
119     *  C :  ¡ÖÁ´³Ñ¤Ò¤é²¾Ì¾¡×¤ò¡ÖÁ´³Ñ¤«¤¿²¾Ì¾¡×¤ËÊÑ´¹
120     *  V :  ÂùÅÀÉÕ¤­¤Îʸ»ú¤ò°ìʸ»ú¤ËÊÑ´¹¡£"K","H"¤È¶¦¤Ë»ÈÍѤ·¤Þ¤¹ 
121     *  n :  ¡ÖÁ´³Ñ¡×¿ô»ú¤ò¡ÖȾ³Ñ(ŽÊŽÝŽ¶Ž¸)¡×¤ËÊÑ´¹
122     */
123    $arrConvList['search_name'] = "KVa";
124    $arrConvList['search_product_code'] = "KVa";
125   
126    // ʸ»úÊÑ´¹
127    foreach ($arrConvList as $key => $val) {
128        // POST¤µ¤ì¤Æ¤­¤¿ÃͤΤßÊÑ´¹¤¹¤ë¡£
129        if(isset($objPage->arrForm[$key])) {
130            $objPage->arrForm[$key] = mb_convert_kana($objPage->arrForm[$key] ,$val);
131        }
132    }
133}
134
135?>
Note: See TracBrowser for help on using the repository browser.