source: temp/trunk/html/admin/basis/point.php.tpl @ 5934

Revision 5934, 9.5 KB checked in by kakinaka, 20 years ago (diff)

* empty log message *
  • Property svn:mime-type set to application/octet-stream
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    var $arrSession;
11    var $tpl_mode;
12    function LC_Page() {
13        $this->tpl_mainpage = 'basis/point.tpl';
14        $this->tpl_subnavi = 'basis/subnavi.tpl';
15        $this->tpl_subno = 'point';
16        $this->tpl_mainno = 'basis';
17        global $arrSTATUS;
18        $this->arrSTATUS = $arrSTATUS;
19        global $arrDISP;
20        $this->arrDISP = $arrDISP;
21    }
22}
23$conn = new SC_DBConn();
24$objPage = new LC_Page();
25$objView = new SC_AdminView();
26$objSess = new SC_Session();
27$objQuery = new SC_Query();
28$objDate = new SC_Date();
29
30// ÅÐÏ¿¡¦¹¹¿·¸¡º÷³«»Ïǯ
31$objDate->setStartYear(RELEASE_YEAR);
32$objDate->setEndYear(DATE("Y"));
33$objPage->arrStartYear = $objDate->getYear();
34$objPage->arrStartMonth = $objDate->getMonth();
35$objPage->arrStartDay = $objDate->getDay();
36$objPage->arrStartHour = $objDate->getHour();
37// ÅÐÏ¿¡¦¹¹¿·¸¡º÷½ªÎ»Ç¯
38$objDate->setStartYear(RELEASE_YEAR);
39$objDate->setEndYear(DATE("Y"));
40$objPage->arrEndYear = $objDate->getYear();
41$objPage->arrEndMonth = $objDate->getMonth();
42$objPage->arrEndDay = $objDate->getDay();
43$objPage->arrEndHour = $objDate->getHour();
44
45// ǧ¾Ú²ÄÈݤÎȽÄê
46sfIsSuccess($objSess);
47
48// ¥Ñ¥é¥á¡¼¥¿´ÉÍý¥¯¥é¥¹
49$objFormParam = new SC_FormParam();
50// ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½
51lfInitParam();
52// POSTÃͤμèÆÀ
53$objFormParam->setParam($_POST);
54
55$cnt = $objQuery->count("dtb_baseinfo");
56
57if ($cnt > 0) {
58    $objPage->tpl_mode = "update";
59} else {
60    $objPage->tpl_mode = "insert";
61}
62
63// ¸¡º÷¥ï¡¼¥É¤Î°ú¤­·Ñ¤®
64foreach ($_POST as $key => $val) {
65    if (ereg("^search_", $key) || ereg("^campaign", $key)) {
66        switch($key) {
67            case 'search_product_flag':
68            case 'search_status':
69                $objPage->arrSearchHidden[$key] = sfMergeParamCheckBoxes($val);
70                break;
71            default:
72                $objPage->arrSearchHidden[$key] = $val;
73                break;
74        }
75    }
76   
77}
78
79switch($_POST['mode']) {
80//Á´ÂΥݥ¤¥ó¥ÈÅÐÏ¿
81case 'update':
82case 'insert':
83    // ÆþÎÏÃͤÎÊÑ´¹
84    $objFormParam->convParam();
85    $objPage->arrErr = $objFormParam->checkError();
86    if(count($objPage->arrErr) == 0) {
87        switch($_POST['mode']) {
88        case 'update':
89            lfUpdateData(); // ´û¸ÊÔ½¸
90            break;
91        case 'insert':
92            lfInsertData(); // ¿·µ¬ºîÀ®
93            break;
94        default:
95            break;
96        }
97        // ºÆɽ¼¨
98        //sfReload();
99        $objPage->tpl_onload = "window.alert('¥Ý¥¤¥ó¥ÈÀßÄ꤬´°Î»¤·¤Þ¤·¤¿¡£');";
100    }
101    break;
102//¥­¥ã¥ó¥Ú¡¼¥ó¾¦ÉÊÁªÂò¥Ú¡¼¥¸¤«¤é¤Î¿ä°Ü
103case 'campaign_next':
104    $objPage->tpl_mainpage = 'basis/campaign_regist.tpl';
105    //ÊÔ½¸»þ
106    if(sfIsInt($_POST['campaign_id'])) {
107        //¥­¥ã¥ó¥Ú¡¼¥ó¾ðÊó¤Î¼èÆÀ
108        $arrRet = $objQuery->select("*", "dtb_campaign", "delete = 0 AND campaign_id = ? ", array($_POST['campaign_id']));
109        $arrCamp = $arrRet[0];
110        //¥­¥ã¥ó¥Ú¡¼¥ó´ü´Ö¤Î¼èÆÀ
111        if ($arrCamp['start_date'] != "" && $arrCamp['end_date']){
112            $arrSDate = sfDispDBDate($arrCamp['start_date']);
113            list($arrCamp['startyear'], $arrCamp['startmonth'], $arrCamp['startday'], $arrCamp['starthour']) = split("[/ :]", $arrSDate);
114            $arrEDate = sfDispDBDate($arrCamp['end_date']);
115            list($arrCamp['endyear'], $arrCamp['endmonth'], $arrCamp['endday'], $arrCamp['endhour']) = split("[/ :]", $arrEDate);
116        }
117        $objPage->arrCamp = $arrCamp;
118    }
119    break;
120//¥­¥ã¥ó¥Ú¡¼¥óÅÐÏ¿
121case 'campaign_regist':
122    $objPage->tpl_mainpage = 'basis/campaign_regist.tpl';
123    $objPage->arrCamp = $_POST;
124    $objPage->arrCamp['campaign_name'] = mb_convert_kana($objPage->arrCamp['campaign_name'], "KVa");
125    $objPage->arrCamp['campaign_point_rate'] = mb_convert_kana($objPage->arrCamp['campaign_point_rate'], "n");
126    //¥¨¥é¡¼¥Á¥§¥Ã¥¯
127    $objPage->arrErr = lfErrorCheck($objPage->arrCamp);
128    if(count($objPage->arrErr) == 0) {
129        //¥­¥ã¥ó¥Ú¡¼¥óÅÐÏ¿
130        lfRegistCampaign($objPage->arrCamp);
131        //¥Ý¥¤¥ó¥ÈÀßÄê¥Ú¡¼¥¸¤Ø°ÜÆ°
132        header("Location: ./point.php");
133        exit;
134    }
135    break;
136default:
137    $arrCol = $objFormParam->getKeyList(); // ¥­¡¼Ì¾°ìÍ÷¤ò¼èÆÀ
138    $col    = sfGetCommaList($arrCol);
139    $arrRet = $objQuery->select($col, "dtb_baseinfo");
140    // POSTÃͤμèÆÀ
141    $objFormParam->setParam($arrRet[0]);
142    //¥­¥ã¥ó¥Ú¡¼¥ó¤Îºï½ü
143    if($_POST['mode'] == 'delete') {
144        $sqlval['del_flg'] = '1';
145        $sqlval['update_date'] = 'now()';
146        $objQuery->begin();
147        $objQuery->update("dtb_campaign", $sqlval, "campaign_id = ? ", array($_POST['campaign_id']));
148        $objQuery->delete("dtb_campaign_detail", "campaign_id = ? ", array($_POST['campaign_id']));
149        $objQuery->commit();
150    }
151    //¥­¥ã¥ó¥Ú¡¼¥ó¥Ç¡¼¥¿¤Î¼èÆÀ
152    $objPage->arrCampData = lfGetCampaignData();
153    // ¥«¥Æ¥´¥ê¤ÎÆɹþ
154    $objPage->arrCatList = sfGetCategoryList();
155    break;
156}
157
158$objPage->arrForm = $objFormParam->getFormParamList();
159$objView->assignobj($objPage);
160$objView->display(MAIN_FRAME);
161
162//--------------------------------------------------------------------------------------------------------------------------------------
163/* ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ */
164function lfInitParam() {
165    global $objFormParam;
166    $objFormParam->addParam("¥Ý¥¤¥ó¥ÈÉÕͿΨ", "point_rate", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"));
167    $objFormParam->addParam("²ñ°÷ÅÐÏ¿»þÉÕÍ¿¥Ý¥¤¥ó¥È", "welcome_point", INT_LEN, "n", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK"));
168}
169
170function lfUpdateData() {
171    global $objFormParam;
172    // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£
173    $sqlval = $objFormParam->getHashArray();
174    $sqlval['update_date'] = 'Now()';
175    $objQuery = new SC_Query();
176    // UPDATE¤Î¼Â¹Ô
177    $ret = $objQuery->update("dtb_baseinfo", $sqlval);
178}
179
180function lfInsertData() {
181    global $objFormParam;
182    // ÆþÎϥǡ¼¥¿¤òÅϤ¹¡£
183    $sqlval = $objFormParam->getHashArray();
184    $sqlval['update_date'] = 'Now()';
185    $objQuery = new SC_Query();
186    // INSERT¤Î¼Â¹Ô
187    $ret = $objQuery->insert("dtb_baseinfo", $sqlval);
188}
189
190//ÅÐÏ¿ºÑ¤ß¥­¥ã¥ó¥Ú¡¼¥ó¤Î¼èÆÀ
191function lfGetCampaigndata() {
192    $objQuery = new SC_Query;
193    //ÅÐÏ¿ÆüÉÕ½ç¤Ëʤ٤ë
194    $objQuery->setorder('update_date DESC');
195    $arrData = $objQuery->select("*", "dtb_campaign", "del_flg = 0");
196    for($i = 0; $i < count($arrData); $i++) {
197        if ($arrData[$i]['search_condition'] != "") {
198            $arrRet[$i] = unserialize($arrData[$i]['search_condition']);
199            foreach($arrRet[$i] as $key => $val) {
200                switch($key) {
201                case 'search_product_flag':
202                case 'search_status':
203                    $arrData[$i][$key] = split("-", $val);
204                    break;
205                default:
206                    $arrData[$i][$key] = $val;
207                    break;
208                }
209            }
210        }
211    }
212    return $arrData;
213}
214
215//---- ÆþÎÏ¥¨¥é¡¼¥Á¥§¥Ã¥¯
216function lfErrorCheck($array) {
217   
218    foreach($array as $key => $val) {
219        if(!ereg("^search", $key)) {
220            $arrRet[$key] = $val;
221        }
222    }
223   
224    $objErr = new SC_CheckError($arrRet);
225   
226    $objErr->doFunc(array("³«»ÏÆü(ǯ)", "startyear"), array("SELECT_CHECK", "NUM_CHECK"));
227    $objErr->doFunc(array("³«»ÏÆü(·î)", "startmonth"), array("SELECT_CHECK", "NUM_CHECK"));
228    $objErr->doFunc(array("³«»ÏÆü(Æü)", "startday"), array("SELECT_CHECK", "NUM_CHECK"));   
229    $objErr->doFunc(array("³«»ÏÆü(»þ)", "starthour"), array("SELECT_CHECK", "NUM_CHECK"));
230    $objErr->doFunc(array("½ªÎ»Æü(ǯ)", "endyear"), array("SELECT_CHECK", "NUM_CHECK"));
231    $objErr->doFunc(array("½ªÎ»Æü(·î)", "endmonth"), array("SELECT_CHECK", "NUM_CHECK"));   
232    $objErr->doFunc(array("½ªÎ»Æü(Æü)", "endday"), array("SELECT_CHECK", "NUM_CHECK"));
233    $objErr->doFunc(array("½ªÎ»Æü(»þ)", "endhour"), array("SELECT_CHECK", "NUM_CHECK"));   
234    $objErr->doFunc(array("³«»ÏÆü", "startyear", "startmonth", "startday", "starthour"), array("CHECK_DATE2"));
235    $objErr->doFunc(array("½ªÎ»Æü", "endyear", "endmonth", "endday", "endhour"), array("CHECK_DATE2"));
236    $objErr->doFunc(array("³«»ÏÆü","½ªÎ»Æü", "startyear", "startmonth", "startday", "starthour", "endyear", "endmonth", "endday", "endhour"), array("CHECK_SET_TERM2"));
237    $objErr->doFunc(array("¥­¥ã¥ó¥Ú¡¼¥ó̾", "campaign_name", STEXT_LEN), array("EXIST_CHECK", "SPTAB_CHECK", "MAX_LENGTH_CHECK"));
238    $objErr->doFunc(array("¥­¥ã¥ó¥Ú¡¼¥ó¥Ý¥¤¥ó¥ÈÉÕͿΨ", "campaign_point_rate", INT_LEN), array("EXIST_CHECK", "SPTAB_CHECK", "NUM_CHECK", "MAX_LENGTH_CHECK"));
239   
240    return $objErr->arrErr;
241}
242
243//¥­¥ã¥ó¥Ú¡¼¥óÅÐÏ¿
244function lfRegistCampaign($array) {
245    $objQuery = new SC_Query;
246   
247    $objQuery->begin();
248    $sqlval['campaign_name'] = $array['campaign_name'];
249    $sqlval['campaign_point_rate'] = $array['campaign_point_rate'];
250    $sqlval['start_date'] = $array['startyear']."-".$array['startmonth']."-".$array['startday']." ".$array['starthour'].":00:00";
251    $sqlval['end_date'] = $array['endyear']."-".$array['endmonth']."-".$array['endday']." ".$array['endhour'].":00:00";
252    //¸¡º÷¾ò·ï¤ò³ÊǼ¤¹¤ë¥­¡¼¤ò»ØÄꤹ¤ë
253    foreach($array as $key => $val) {
254        //¥Ú¡¼¥¸NO¤Ï³ÊǼ¤·¤Ê¤¤
255        if(ereg("^search", $key) && !ereg("^search_page", $key)) {
256            $arrRet[$key] = $val;
257        }
258    }
259    $sqlval['search_condition'] = serialize($arrRet);
260    $sqlval['create_date'] = 'now()';
261    //ÊÔ½¸»þ
262    if(sfIsInt($array['campaign_id'])) {
263        $sqlval['update_date'] = 'now()';
264        //¹¹¿·
265        $objQuery->update("dtb_campaign", $sqlval, "campaign_id = ?", array($array['campaign_id']));
266        //¾ÜºÙ¥Æ¡¼¥Ö¥ë¤òºï½ü
267        $objQuery->delete("dtb_campaign_detail", "campaign_id = ? ", array($array['campaign_id']));
268        $sqlvaldet['campaign_id'] = $array['campaign_id'];
269    } else {
270        //¿·µ¬ÅÐÏ¿
271        $campaign_id = $objQuery->nextval("dtb_campaign", "campaign_id");
272        $sqlval['campaign_id'] = $campaign_id;
273        $objQuery->insert("dtb_campaign", $sqlval);
274        $sqlvaldet['campaign_id'] = $campaign_id;
275    }
276    $sqlvaldet['campaign_point_rate'] = $array['campaign_point_rate'];
277    //¥­¥ã¥ó¥Ú¡¼¥ó¾¦ÉÊID¤òÇÛÎó¤Ë³ÊǼ
278    $arrID = explode("-", $array['campaign_product_id']);
279    foreach($arrID as $val) {
280        $sqlvaldet['product_id'] = $val;
281        $objQuery->insert("dtb_campaign_detail", $sqlvaldet);
282    }
283    $objQuery->commit();
284}
Note: See TracBrowser for help on using the repository browser.