source: temp/trunk/html/admin/customer/index.php @ 1869

Revision 1869, 16.6 KB checked in by kakinaka, 20 years ago (diff)

blank
  • Property svn:eol-style set to native
  • Property svn:keywords set to Author Date Id Revision
Line 
1<?php
2
3require_once("../require.php");
4require_once(ROOT_DIR."data/include/csv_output.inc");
5
6//---- ¥Ú¡¼¥¸É½¼¨ÍÑ¥¯¥é¥¹
7class LC_Page {
8    var $arrSession;
9    var $tpl_mode;
10    var $list_data;
11    var $search_data;
12    var $arrErr;
13    var $arrYear;
14    var $arrMonth;
15    var $arrDay;
16    var $arrJob;
17    var $arrSex;
18    var $arrPageMax;
19    var $count;
20    var $search_SQL;
21   
22    var $tpl_strnavi;
23   
24    var $arrHtmlmail;
25
26    function LC_Page() {
27        $this->tpl_mainpage = 'customer/index.tpl';
28        $this->tpl_mainno = 'customer';
29        $this->tpl_subnavi = 'customer/subnavi.tpl';
30        $this->tpl_subno = 'index';
31        $this->tpl_pager = ROOT_DIR . 'data/Smarty/templates/admin/pager.tpl';
32        $this->tpl_subtitle = '¸ÜµÒ¥Þ¥¹¥¿';
33       
34        global $arrPref;
35        $this->arrPref = $arrPref;
36        global $arrJob;
37        $arrJob["ÉÔÌÀ"] = "ÉÔÌÀ";
38        $this->arrJob = $arrJob;
39        global $arrSex;     
40        $this->arrSex = $arrSex;
41        global $arrPageRows;
42        $this->arrPageRows = $arrPageRows;
43       
44        global $arrMAILMAGATYPE;
45        $this->arrMAILMAGATYPE = $arrMAILMAGATYPE;
46        $this->arrHtmlmail[''] = "¤¹¤Ù¤Æ";
47        $this->arrHtmlmail[1] = $arrMAILMAGATYPE[1];
48        $this->arrHtmlmail[2] = $arrMAILMAGATYPE[2];       
49    }
50}
51
52//----¡¡CSV¥À¥¦¥ó¥í¡¼¥ÉÍÑ
53$arrColumnCSV= array(
54                        0  => array("sql" => "customer_id", "csv" => "customer_id", "header" => "¸ÜµÒID"),
55                        1  => array("sql" => "name01", "csv" => "name01", "header" => "̾Á°1"),
56                        2  => array("sql" => "name02", "csv" => "name02", "header" => "̾Á°2"),
57                        3  => array("sql" => "kana01", "csv" => "kana01", "header" => "¥Õ¥ê¥¬¥Ê1"),
58                        4  => array("sql" => "kana02", "csv" => "kana02", "header" => "¥Õ¥ê¥¬¥Ê2"),
59                        5  => array("sql" => "zip01", "csv" => "zip01", "header" => "͹ÊØÈÖ¹æ1"),
60                        6  => array("sql" => "zip02", "csv" => "zip02", "header" => "͹ÊØÈÖ¹æ2"),
61                        7  => array("sql" => "pref", "csv" => "pref", "header" => "ÅÔÆ»Éܸ©"),
62                        8  => array("sql" => "addr01", "csv" => "addr01", "header" => "½»½ê1"),
63                        9  => array("sql" => "addr02", "csv" => "addr02", "header" => "½»½ê2"),
64                        10 => array("sql" => "email", "csv" => "email", "header" => "E-MAIL"),
65                        11 => array("sql" => "tel01", "csv" => "tel01", "header" => "TEL1"),
66                        12 => array("sql" => "tel02", "csv" => "tel02", "header" => "TEL2"),
67                        13 => array("sql" => "tel03", "csv" => "tel03", "header" => "TEL3"),
68                        14 => array("sql" => "fax01", "csv" => "fax01", "header" => "FAX1"),
69                        15 => array("sql" => "fax02", "csv" => "fax02", "header" => "FAX2"),
70                        16 => array("sql" => "fax03", "csv" => "fax03", "header" => "FAX3"),
71                        17 => array("sql" => "CASE WHEN sex = 1 THEN 'ÃËÀ­' ELSE '½÷À­' END AS sex", "csv" => "sex", "header" => "À­ÊÌ"),
72                        18 => array("sql" => "job", "csv" => "job", "header" => "¿¦¶È"),
73                        19 => array("sql" => "to_char(birth, 'YYYYǯMM·îDDÆü') AS birth", "csv" => "birth", "header" => "ÃÂÀ¸Æü"),
74                        20 => array("sql" => "to_char(first_buy_date, 'YYYYǯMM·îDDÆüHH24:MI') AS first_buy_date", "csv" => "first_buy_date", "header" => "½é²ó¹ØÆþÆü"),
75                        21 => array("sql" => "to_char(last_buy_date, 'YYYYǯMM·îDDÆüHH24:MI') AS last_buy_date", "csv" => "last_buy_date", "header" => "ºÇ½ª¹ØÆþÆü"),
76                        22 => array("sql" => "buy_times", "csv" => "buy_times", "header" => "¹ØÆþ²ó¿ô"),
77                        23 => array("sql" => "point", "csv" => "point", "header" => "¥Ý¥¤¥ó¥È»Ä¹â"),
78                        24 => array("sql" => "note", "csv" => "note", "header" => "È÷¹Í"),
79                        25 => array("sql" => "to_char(create_date, 'YYYYǯMM·îDDÆüHH24:MI') AS create_date", "csv" => "create_date", "header" => "ÅÐÏ¿Æü"),
80                        26 => array("sql" => "to_char(update_date, 'YYYYǯMM·îDDÆüHH24:MI') AS update_date", "csv" => "update_date", "header" => "¹¹¿·Æü")
81                    );
82
83//---- ¥Ú¡¼¥¸½é´üÀßÄê
84$objConn = new SC_DBConn();
85$objPage = new LC_Page();
86$objView = new SC_AdminView();
87$objDate = new SC_Date(1901);
88$objPage->arrYear = $objDate->getYear();    //¡¡ÆüÉÕ¥×¥ë¥À¥¦¥óÀßÄê
89$objPage->arrMonth = $objDate->getMonth();
90$objPage->arrDay = $objDate->getDay();
91$objPage->objDate = $objDate;
92
93// ǧ¾Ú²ÄÈݤÎȽÄê
94$objSess = new SC_Session();
95sfIsSuccess($objSess);
96
97// POSTÃͤΰú¤­·Ñ¤®
98$objPage->arrForm = $_POST;
99
100// ¥Ú¡¼¥¸Á÷¤êÍÑ
101$objPage->arrHidden['search_pageno'] = $_POST['search_pageno'];
102
103// ¸¡º÷¥ï¡¼¥É¤Î°ú¤­·Ñ¤®
104foreach ($_POST as $key => $val) {
105
106    if (ereg("^search_", $key)) {
107        switch($key) {
108            case 'search_sex':
109                $objPage->arrHidden[$key] = sfMergeParamCheckBoxes($val);
110                if(!is_array($val)) {
111                    $objPage->arrForm[$key] = split("-", $val);
112                }
113                break;
114            default:
115                $objPage->arrHidden[$key] = $val;
116                break;
117        }
118    }
119}
120
121// ¸ÜµÒºï½ü
122if ($_POST['mode'] == "delete") {
123    $sql = "SELECT status,email FROM dtb_customer WHERE customer_id = ? AND delete = 0";
124    $result_customer = $objConn->getAll($sql, array($_POST["edit_customer_id"]));
125
126    if ($result_customer[0]["status"] == 2) {           //Ëܲñ°÷ºï½ü
127        $arrDel = array("delete" => 1, "update_date" => "NOW()");
128        $objConn->autoExecute("dtb_customer", $arrDel, "customer_id = " .addslashes($_POST["edit_customer_id"]) );
129    } elseif ($result_customer[0]["status"] == 1) {     //²¾²ñ°÷ºï½ü
130        $sql = "DELETE FROM dtb_customer WHERE customer_id = ?";
131        $objConn->query($sql, array($_POST["edit_customer_id"]));
132    }
133    $sql = "DELETE FROM dtb_customer_mail WHERE email = ?";
134    $objConn->query($sql, array($result_customer[0]["email"]));
135}
136
137if ($_POST['mode'] == "search" || $_POST['mode'] == "csv"  || $_POST['mode'] == "delete" || $_POST['mode'] == "delete_all") {
138    // ÆþÎÏʸ»ú¤Î¶¯À©ÊÑ´¹
139    lfConvertParam();
140    // ¥¨¥é¡¼¥Á¥§¥Ã¥¯
141    $objPage->arrErr = lfCheckError($objPage->arrForm);
142
143    $where = "delete = 0";
144
145    /* ÆþÎÏ¥¨¥é¡¼¤Ê¤· */
146    if (count($objPage->arrErr) == 0) {
147       
148       
149        sfprintr($objPage->arrForm);
150        //-- ¸¡º÷¥Ç¡¼¥¿¼èÆÀ
151        $objSelect = new SC_CustomerList($objPage->arrForm, "customer");
152        if ($_POST["mode"] == 'csv') {
153            $searchSql = $objSelect->getListCSV($arrColumnCSV);
154        }else{
155            $searchSql = $objSelect->getList();
156        }
157        $objPage->search_data = $objConn->getAll($searchSql, $objSelect->arrVal);
158
159        switch($_POST['mode']) {
160        case 'csv':
161            $i = 0;
162            $header = "";
163           
164            // CSV¥«¥é¥à¼èÆÀ
165            $arrCsvOutput = (sfgetCsvOutput(2, " WHERE csv_id = 2 AND status = 1"));
166
167            if (count($arrCsvOutput) <= 0) break;
168
169            foreach($arrCsvOutput as $data) {
170                $arrColumn[] = $data["col"];
171                if ($i != 0) $header .= ", ";
172                $header .= $data["disp_name"];
173                $i ++;
174            }
175            $header .= "\n";
176
177            //-¡¡ÅÔÆ»Éܸ©/¿¦¶È¤ÎÊÑ´¹
178            for($i = 0; $i < count($objPage->search_data); $i ++) {
179                $objPage->search_data[$i]["pref"] = $arrPref[ $objPage->search_data[$i]["pref"] ];
180                $objPage->search_data[$i]["job"]  = $arrJob[ $objPage->search_data[$i]["job"] ];
181            }
182
183            //-¡¡CSV½ÐÎÏ
184            $data = lfGetCSVData($objPage->search_data, $arrColumn);
185            sfCSVDownload($header.$data);
186            exit;
187            break;
188        case 'delete_all':
189            // ¸¡º÷·ë²Ì¤ò¤¹¤Ù¤Æºï½ü
190            $where = "product_id IN (SELECT product_id FROM vw_products_nonclass WHERE $where)";
191            $sqlval['delete'] = 1;
192            $objQuery->update("dtb_products", $sqlval, $where, $arrval);
193
194            $sql = "SELECT status,email FROM dtb_customer WHERE customer_id = ? AND delete = 0";
195            $result_customer = $objConn->getAll($sql, array($_POST["del_customer_id"]));
196
197            if ($result_customer[0]["status"] == 2) {           //Ëܲñ°÷ºï½ü
198                $arrDel = array("delete" => 1, "update_date" => "NOW()");
199                $objConn->autoExecute("dtb_customer", $arrDel, "customer_id = " .addslashes($_POST["del_customer_id"]) );
200            } elseif ($result_customer[0]["status"] == 1) {     //²¾²ñ°÷ºï½ü
201                $sql = "DELETE FROM dtb_customer WHERE customer_id = ?";
202                $objConn->query($sql, array($_POST["del_customer_id"]));
203            }
204            $sql = "DELETE FROM dtb_customer_mail WHERE email = ?";
205            $objConn->query($sql, array($result_customer[0]["email"]));
206           
207            break;
208        default:
209
210            // ¹Ô¿ô¤Î¼èÆÀ
211            $linemax = $objConn->getOne( $objSelect->getListCount(), $objSelect->arrVal);
212            $objPage->tpl_linemax = $linemax;               // ²¿·ï¤¬³ºÅö¤·¤Þ¤·¤¿¡£É½¼¨ÍÑ
213   
214            // ¥Ú¡¼¥¸Á÷¤ê¤Î½èÍý
215            if(is_numeric($_POST['search_page_max'])) {
216                $page_max = $_POST['search_page_max'];
217            } else {
218                $page_max = SEARCH_PMAX;
219            }
220            // ¥Ú¡¼¥¸Á÷¤ê¤Î¼èÆÀ
221            $objNavi = new SC_PageNavi($_POST['search_pageno'], $linemax, $page_max, "fnCustomerPage", NAVI_PMAX);
222            $startno = $objNavi->start_row;
223            $objPage->arrPagenavi = $objNavi->arrPagenavi;     
224        }
225    }
226}
227
228$objPage->arrCatList = sfGetCategoryList();
229
230//----¡¡¥Ú¡¼¥¸É½¼¨
231$objView->assignobj($objPage);
232$objView->display(MAIN_FRAME);
233
234
235//--------------------------------------------------------------------------------------------------------------------------------------
236
237//----¡¡¼èÆÀʸ»úÎó¤ÎÊÑ´¹
238function lfConvertParam() {
239    global $objPage;
240   
241    /*
242     *  ʸ»úÎó¤ÎÊÑ´¹
243     *  K :  ¡ÖȾ³Ñ(ŽÊŽÝŽ¶Ž¸)ÊÒ²¾Ì¾¡×¤ò¡ÖÁ´³ÑÊÒ²¾Ì¾¡×¤ËÊÑ´¹
244     *  C :  ¡ÖÁ´³Ñ¤Ò¤é²¾Ì¾¡×¤ò¡ÖÁ´³Ñ¤«¤¿²¾Ì¾¡×¤ËÊÑ´¹
245     *  V :  ÂùÅÀÉÕ¤­¤Îʸ»ú¤ò°ìʸ»ú¤ËÊÑ´¹¡£"K","H"¤È¶¦¤Ë»ÈÍѤ·¤Þ¤¹ 
246     *  n :  ¡ÖÁ´³Ñ¡×¿ô»ú¤ò¡ÖȾ³Ñ(ŽÊŽÝŽ¶Ž¸)¡×¤ËÊÑ´¹
247     *  a :  Á´³Ñ±Ñ¿ô»ú¤òȾ³Ñ±Ñ¿ô»ú¤ËÊÑ´¹¤¹¤ë
248     */
249    // ¥«¥é¥à̾¤È¥³¥ó¥Ð¡¼¥È¾ðÊó
250    $arrConvList['search_customer_id'] = "n" ;
251    $arrConvList['search_name'] = "aKV" ;
252    $arrConvList['search_pref'] = "n" ;
253    $arrConvList['search_kana'] = "CKV" ;
254    $arrConvList['search_b_start_year'] = "n" ;
255    $arrConvList['search_b_start_month'] = "n" ;
256    $arrConvList['search_b_start_day'] = "n" ;
257    $arrConvList['search_b_end_year'] = "n" ;
258    $arrConvList['search_b_end_month'] = "n" ;
259    $arrConvList['search_b_end_day'] = "n" ;
260    $arrConvList['search_tel'] = "n" ;
261    $arrConvList['search_birth_month'] = "n" ;
262    $arrConvList['search_email'] = "a" ;
263    $arrConvList['search_buy_total_from'] = "n" ;
264    $arrConvList['search_buy_total_to'] = "n" ;
265    $arrConvList['search_buy_times_from'] = "n" ;
266    $arrConvList['search_buy_times_to'] = "n" ;
267    $arrConvList['search_start_year'] = "n" ;
268    $arrConvList['search_start_month'] = "n" ;
269    $arrConvList['search_start_day'] = "n" ;
270    $arrConvList['search_end_year'] = "n" ;
271    $arrConvList['search_end_month'] = "n" ;
272    $arrConvList['search_end_day'] = "n" ;
273    $arrConvList['search_page_rows'] = "n" ;
274    $arrConvList['search_buy_start_year'] = "n" ;       //¡¡ºÇ½ª¹ØÆþÆü START ǯ
275    $arrConvList['search_buy_start_month'] = "n" ;      //¡¡ºÇ½ª¹ØÆþÆü START ·î
276    $arrConvList['search_buy_start_day'] = "n" ;        //¡¡ºÇ½ª¹ØÆþÆü START Æü
277    $arrConvList['search_buy_end_year'] = "n" ;         //¡¡ºÇ½ª¹ØÆþÆü END ǯ
278    $arrConvList['search_buy_end_month'] = "n" ;        //¡¡ºÇ½ª¹ØÆþÆü END ·î
279    $arrConvList['search_buy_end_day'] = "n" ;          //¡¡ºÇ½ª¹ØÆþÆü END Æü
280    $arrConvList['search_buy_product_name'] = "aKV" ;   //¡¡¹ØÆþ¾¦ÉÊ̾
281    $arrConvList['search_buy_product_code'] = "aKV" ;   //¡¡¹ØÆþ¾¦ÉÊ¥³¡¼¥É
282    $arrConvList['search_category_id'] = "" ;           //¡¡¥«¥Æ¥´¥ê
283       
284    // ʸ»úÊÑ´¹
285    foreach ($arrConvList as $key => $val) {
286        // POST¤µ¤ì¤Æ¤­¤¿ÃͤΤßÊÑ´¹¤¹¤ë¡£
287        if(isset($objPage->arrForm[$key])) {
288            $objPage->arrForm[$key] = mb_convert_kana($objPage->arrForm[$key] ,$val);
289        }
290    }
291}
292
293
294//---- ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯
295function lfCheckError($array) {
296
297    $objErr = new SC_CheckError($array);
298   
299    $objErr->doFunc(array("¸ÜµÒ¥³¡¼¥É", "search_customer_id", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));
300    $objErr->doFunc(array("ÅÔÆ»Éܸ©", "search_pref", 2), array("NUM_CHECK","MAX_LENGTH_CHECK"));
301    $objErr->doFunc(array("¸ÜµÒ̾", "search_name", STEXT_LEN), array("MAX_LENGTH_CHECK"));
302    $objErr->doFunc(array("¸ÜµÒ̾(¥«¥Ê)", "search_kana", STEXT_LEN), array("KANA_CHECK", "MAX_LENGTH_CHECK"));
303    $objErr->doFunc(array("ÃÂÀ¸Æü(³«»ÏÆü)", "search_b_start_year", "search_b_start_month", "search_b_start_day"), array("CHECK_DATE"));
304    $objErr->doFunc(array("ÃÂÀ¸Æü(½ªÎ»Æü)", "search_b_end_year", "search_b_end_month", "search_b_end_day"), array("CHECK_DATE"));
305    $objErr->doFunc(array("ÃÂÀ¸Æü(³«»ÏÆü)","ÃÂÀ¸Æü(½ªÎ»Æü)", "search_b_start_year", "search_b_start_month", "search_b_start_day", "search_b_end_year", "search_b_end_month", "search_b_end_day"), array("CHECK_SET_TERM"));
306    $objErr->doFunc(array("ÃÂÀ¸·î", "search_birth_month", 2), array("NUM_CHECK","MAX_LENGTH_CHECK"));
307    $objErr->doFunc(array('¥á¡¼¥ë¥¢¥É¥ì¥¹', "search_email", STEXT_LEN) ,array("EMAIL_CHAR_CHECK", "MAX_LENGTH_CHECK"));
308    $objErr->doFunc(array("ÅÅÏÃÈÖ¹æ", "search_tel", TEL_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));
309    $objErr->doFunc(array("¹ØÆþ¶â³Û(³«»Ï)", "search_buy_total_from", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));
310    $objErr->doFunc(array("¹ØÆþ¶â³Û(½ªÎ»)", "search_buy_total_to", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));
311    if ( (is_numeric($array["search_buy_total_from"]) && is_numeric($array["search_buy_total_to"]) ) && ($array["search_buy_total_from"] > $array["search_buy_total_to"]) ) $objErr->arrErr["search_buy_total_from"] .= "¢¨ ¹ØÆþ¶â³Û¤Î»ØÄêÈϰϤ¬ÉÔÀµ¤Ç¤¹¡£";
312    $objErr->doFunc(array("¹ØÆþ²ó¿ô(³«»Ï)", "search_buy_times_from", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));
313    $objErr->doFunc(array("¹ØÆþ²ó¿ô(½ªÎ»)", "search_buy_times_to", INT_LEN), array("NUM_CHECK","MAX_LENGTH_CHECK"));
314    if ( (is_numeric($array["search_buy_times_from"]) && is_numeric($array["search_buy_times_to"]) ) && ($array["search_buy_times_from"] > $array["search_buy_times_to"]) ) $objErr->arrErr["search_buy_times_from"] .= "¢¨ ¹ØÆþ²ó¿ô¤Î»ØÄêÈϰϤ¬ÉÔÀµ¤Ç¤¹¡£";
315    $objErr->doFunc(array("ÅÐÏ¿¡¦¹¹¿·Æü(³«»ÏÆü)", "search_start_year", "search_start_month", "search_start_day",), array("CHECK_DATE"));
316    $objErr->doFunc(array("ÅÐÏ¿¡¦¹¹¿·Æü(½ªÎ»Æü)", "search_end_year", "search_end_month", "search_end_day"), array("CHECK_DATE"));   
317    $objErr->doFunc(array("ÅÐÏ¿¡¦¹¹¿·Æü(³«»ÏÆü)","ÅÐÏ¿¡¦¹¹¿·Æü(½ªÎ»Æü)", "search_start_year", "search_start_month", "search_start_day", "search_end_year", "search_end_month", "search_end_day"), array("CHECK_SET_TERM"));
318    $objErr->doFunc(array("ɽ¼¨·ï¿ô", "search_page_rows", 3), array("NUM_CHECK","MAX_LENGTH_CHECK"));   
319    $objErr->doFunc(array("ºÇ½ª¹ØÆþÆü(³«»ÏÆü)", "search_buy_start_year", "search_buy_start_month", "search_buy_start_day",), array("CHECK_DATE"));  //ºÇ½ª¹ØÆþÆü(³«»ÏÆü)
320    $objErr->doFunc(array("ºÇ½ª¹ØÆþ(½ªÎ»Æü)", "search_buy_end_year", "search_buy_end_month", "search_buy_end_day"), array("CHECK_DATE"));           //ºÇ½ª¹ØÆþÆü(½ªÎ»Æü)
321    //¹ØÆþ¶â³Û(from) ¡ä ¹ØÆþ¶â³Û(to) ¤Î¾ì¹ç¤Ï¥¨¥é¡¼¤È¤¹¤ë
322    $objErr->doFunc(array("ºÇ½ª¹ØÆþÆü(³«»ÏÆü)","ÅÐÏ¿¡¦¹¹¿·Æü(½ªÎ»Æü)", "search_buy_start_year", "search_buy_start_month", "search_buy_start_day", "search_buy_end_year", "search_buy_end_month", "search_buy_end_day"), array("CHECK_SET_TERM"));   
323    $objErr->doFunc(array("¹ØÆþ¾¦ÉÊ¥³¡¼¥É", "search_buy_product_code", STEXT_LEN), array("MAX_LENGTH_CHECK"));                      //¹ØÆþ¾¦ÉÊ¥³¡¼¥É
324    $objErr->doFunc(array("¹ØÆþ¾¦ÉÊ̾", "search_buy_product_name", STEXT_LEN), array("MAX_LENGTH_CHECK"));                          //¹ØÆþ¾¦ÉÊ̾¾Î
325   
326    return $objErr->arrErr;
327}
328
329function lfSetWhere($arrForm){
330    foreach ($arrForm as $key => $val) {
331       
332        $val = sfManualEscape($val);
333       
334        if($val == "") continue;
335       
336        switch ($key) {
337            case 'search_product_id':
338                $where .= " AND product_id = ?";
339                $arrval[] = $val;
340                break;
341            case 'search_product_class_id':
342                $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_class_id = ?)";
343                $arrval[] = $val;
344                break;
345            case 'search_name':
346                $where .= " AND name ILIKE ?";
347                $arrval[] = "%$val%";
348                break;
349            case 'search_category_id':
350                list($tmp_where, $tmp_arrval) = sfGetCatWhere($val);
351                if($tmp_where != "") {
352                    $where.= " AND $tmp_where";
353                    $arrval = array_merge($arrval, $tmp_arrval);
354                }
355                break;
356            case 'search_product_code':
357                $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? GROUP BY product_id)";
358                $arrval[] = "%$val%";
359                break;
360            case 'search_startyear':
361                $date = sfGetTimestamp($_POST['search_startyear'], $_POST['search_startmonth'], $_POST['search_startday']);
362                $where.= " AND update_date >= ?";
363                $arrval[] = $date;
364                break;
365            case 'search_endyear':
366                $date = sfGetTimestamp($_POST['search_endyear'], $_POST['search_endmonth'], $_POST['search_endday']);
367                $where.= " AND update_date <= ?";
368                $arrval[] = $date;
369                break;
370            case 'search_product_flag':
371                global $arrSTATUS;
372                $search_product_flag = sfSearchCheckBoxes($val);
373                if($search_product_flag != "") {
374                    $where.= " AND product_flag LIKE ?";
375                    $arrval[] = $search_product_flag;                   
376                }
377                break;
378            case 'search_status':
379                $tmp_where = "";
380                foreach ($val as $element){
381                    if ($element != ""){
382                        if ($tmp_where == ""){
383                            $tmp_where.="AND (status LIKE ? ";
384                        }else{
385                            $tmp_where.="OR status LIKE ? ";
386                        }
387                        $arrval[]=$element;
388                    }
389                }
390                if ($tmp_where != ""){
391                    $tmp_where.=")";
392                    $where.= "$tmp_where";
393                }   
394                break;
395            default:
396                break;
397        }
398    }
399}
400
401//---- CSV½ÐÎÏÍѥǡ¼¥¿¼èÆÀ
402function lfGetCSVData( $array, $arrayIndex){   
403   
404    for ($i=0; $i<count($array); $i++){
405       
406        for ($j=0; $j<count($array[$i]); $j++ ){
407            if ( $j > 0 ) $return .= ",";
408            $return .= "\"";           
409            if ( $arrayIndex ){
410                $return .= mb_ereg_replace("<","¡ã",mb_ereg_replace( "\"","\"\"",$array[$i][$arrayIndex[$j]] )) ."\""; 
411            } else {
412                $return .= mb_ereg_replace("<","¡ã",mb_ereg_replace( "\"","\"\"",$array[$i][$j] )) ."\"";
413            }
414        }
415        $return .= "\n";           
416    }
417   
418    return $return;
419}
420
421
422?>
Note: See TracBrowser for help on using the repository browser.