source: temp/branches/ec-cube-beta/html/admin/contents/campaign.php @ 10803

Revision 10803, 8.5 KB checked in by uehara, 20 years ago (diff)
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
9//---- ǧ¾Ú²ÄÈݤÎȽÄê
10$objSess = new SC_Session();
11sfIsSuccess($objSess);
12
13//---- ¥Ú¡¼¥¸É½¼¨¥¯¥é¥¹
14class LC_Page {
15   
16    function LC_Page() {
17        $this->tpl_mainpage = 'contents/campaign.tpl';
18        $this->tpl_subnavi = 'contents/subnavi.tpl';
19        $this->tpl_subno = "campaign";
20        $this->tpl_mainno = 'contents';
21        $this->tpl_subtitle = '¥­¥ã¥ó¥Ú¡¼¥ó´ÉÍý';
22        // ¥«¡¼¥È¤Ë¾¦Éʤ¬Æþ¤Ã¤Æ¤¤¤ë¤Ë¥Á¥§¥Ã¥¯¤¬Æþ¤Ã¤Æ¤¤¤ë¤«¥Á¥§¥Ã¥¯
23        $this->tpl_onload = "fnIsCartOn();";
24    }
25}
26
27
28$objPage = new LC_Page();
29$objView = new SC_AdminView();
30$objQuery = new SC_Query();
31$objFormParam = new SC_FormParam();
32
33// ǧ¾Ú²ÄÈݤÎȽÄê
34sfIsSuccess($objSess);
35
36// ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½
37lfInitParam();
38// ¥Õ¥©¡¼¥à¤ÎÃͤò¥»¥Ã¥È
39$objFormParam->setParam($_POST);
40
41// ¥Õ¥©¡¼¥à¤ÎÃͤò¥Æ¥ó¥×¥ì¡¼¥È¤ØÅϤ¹
42$objPage->arrForm = $objFormParam->getHashArray();
43$campaign_id = $_POST['campaign_id'];
44
45switch($_POST['mode']) {
46    // ¿·µ¬ÅÐÏ¿/ÊÔ½¸ÅÐÏ¿
47    case 'regist':
48        // ¥¨¥é¡¼¥Á¥§¥Ã¥¯
49        $objPage->arrErr = lfErrorCheck();
50       
51        if(count($objPage->arrErr) <= 0) {
52            // ÅÐÏ¿
53            lfRegistCampaign($campaign_id);
54            // ¥­¥ã¥ó¥Ú¡¼¥óTOP¤Ø¥ê¥À¥¤¥ì¥¯¥È
55            header("location: ".URL_CAMPAIGN_TOP);
56        }
57        break;
58    // ÊÔ½¸²¡²¼»þ
59    case 'update':
60        // ¥­¥ã¥ó¥Ú¡¼¥ó¾ðÊó¤ò¼èÆÀ
61        $objPage->arrForm = lfGetCampaign($campaign_id);
62        break;
63    // ºï½ü²¡²¼»þ
64    case 'delete':
65        // ºï½ü
66        lfDeleteCampaign($campaign_id);
67        // ¥­¥ã¥ó¥Ú¡¼¥óTOP¤Ø¥ê¥À¥¤¥ì¥¯¥È
68        header("location: ".URL_CAMPAIGN_TOP);
69        break;
70    default:
71        break;
72}
73
74// ¥­¥ã¥ó¥Ú¡¼¥ó°ìÍ÷¼èÆÀ
75$objPage->arrCampaign = lfGetCampaignList();
76
77// ¥­¥ã¥ó¥Ú¡¼¥ó´ü´ÖÍÑ
78$objDate = new SC_Date();
79$objPage->arrYear = $objDate->getYear();
80$objPage->arrMonth = $objDate->getMonth();
81$objPage->arrDay = $objDate->getDay();
82$objPage->arrHour = $objDate->getHour();
83$objPage->arrMinutes = $objDate->getMinutes();
84
85//----¡¡¥Ú¡¼¥¸É½¼¨
86$objView->assignobj($objPage);
87$objView->display(MAIN_FRAME);
88
89
90//---------------------------------------------------------------------------------------------------------------------------------------------------------
91/*
92 * ´Ø¿ô̾¡§lfInitParam
93 * ÀâÌÀ¡¡¡§ÆþÎϾðÊó¤Î½é´ü²½
94 */
95function lfInitParam() {
96    global $objFormParam;
97       
98    $objFormParam->addParam("¥­¥ã¥ó¥Ú¡¼¥ó̾", "campaign_name", MTEXT_LEN, "KVa", array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
99   
100    $objFormParam->addParam("³«»ÏÆü»þ", "start_year", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
101    $objFormParam->addParam("³«»ÏÆü»þ", "start_month", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
102    $objFormParam->addParam("³«»ÏÆü»þ", "start_day", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
103    $objFormParam->addParam("³«»ÏÆü»þ", "start_hour", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
104    $objFormParam->addParam("³«»ÏÆü»þ", "start_minute", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
105
106    $objFormParam->addParam("Ää»ßÆü»þ", "end_year", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
107    $objFormParam->addParam("Ää»ßÆü»þ", "end_month", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
108    $objFormParam->addParam("Ää»ßÆü»þ", "end_day", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
109    $objFormParam->addParam("Ää»ßÆü»þ", "end_hour", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
110    $objFormParam->addParam("Ää»ßÆü»þ", "end_minute", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
111
112    $objFormParam->addParam("¥Ç¥£¥ì¥¯¥È¥ê̾", "directory_name", MTEXT_LEN, "KVa", array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
113    $objFormParam->addParam("¿½¹þ¿ôÀ©¸æ", "limit_count", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
114    $objFormParam->addParam("½ÅÊ£¿½¹þÀ©¸æ", "orverlapping_flg", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
115    $objFormParam->addParam("¥«¡¼¥È¤Ë¾¦ÉʤòÆþ¤ì¤ë", "cart_flg", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
116    $objFormParam->addParam("Á÷ÎÁ̵ÎÁÀßÄê", "deliv_free_flg", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
117
118}
119
120/*
121 * ´Ø¿ô̾¡§lfErrorCheck()
122 * ÀâÌÀ¡¡¡§¥¨¥é¡¼¥Á¥§¥Ã¥¯
123 * Ìá¤êÃÍ¡§¥¨¥é¡¼Ê¸»ú³ÊǼÇÛÎó
124 */
125function lfErrorCheck() {
126   
127    global $objFormParam;
128
129    $arrList = $objFormParam->getHashArray();
130    $objErr = new SC_CheckError($arrList);
131    $objErr->arrErr = $objFormParam->checkError();
132   
133    $objErr->doFunc(array("³«»ÏÆü»þ", "start_year", "start_month", "start_day", "start_hour", "start_minute", "0"), array("CHECK_DATE2"));
134    $objErr->doFunc(array("Ää»ßÆü»þ", "end_year", "end_month", "end_day", "end_hour", "end_minute", "0"), array("CHECK_DATE2"));
135    $objErr->doFunc(array("³«»ÏÆü»þ", "Ää»ßÆü»þ", "start_year", "start_month", "start_day", "start_hour", "start_minute", "00", "end_year", "end_month", "end_day", "end_hour", "end_minute", "59"), array("CHECK_SET_TERM2"));
136   
137    return $objErr->arrErr;
138}
139
140/*
141 * ´Ø¿ô̾¡§lfRegistCampaign()
142 * °ú¿ô1 ¡§¥­¥ã¥ó¥Ú¡¼¥óID(¥¢¥Ã¥×¥Ç¡¼¥È»þ¤Ë»ØÄê)
143 * ÀâÌÀ¡¡¡§¥­¥ã¥ó¥Ú¡¼¥óÅÐÏ¿/¹¹¿·
144 * Ìá¤êÃÍ¡§Ìµ¤·
145 */
146function lfRegistCampaign($campaign_id = "") {
147
148    global $objFormParam;
149    global $objQuery;
150   
151    $objSiteInfo = new SC_SiteInfo();
152    $arrInfo = $objSiteInfo->data;
153    $arrList = $objFormParam->getHashArray();   
154
155    // ³«»ÏÆü»þ¡¦½ªÎ»Æü»þÀ°·Á
156    $start_date = $arrList['start_year']."-".sprintf("%02d", $arrList['start_month'])."-".sprintf("%02d", $arrList['start_day'])." ".sprintf("%02d", $arrList['start_hour']).":".sprintf("%02d", $arrList['start_minute']).":00";
157    $end_date = $arrList['end_year']."-".sprintf("%02d", $arrList['end_month'])."-".sprintf("%02d", $arrList['end_day'])." ".sprintf("%02d", $arrList['end_hour']).":".sprintf("%02d", $arrList['end_minute']).":00";
158
159    // ¥Ý¥¤¥ó¥È¥ì¡¼¥È¤ÏÀßÄꤵ¤ì¤Æ¤¤¤Ê¤±¤ì¤Ð0¤òÁÞÆþ
160    if($arrInfo['point_rate'] == "") $arrInfo['point_rate'] = "0";
161    // ¥Õ¥é¥°¤ÏÀßÄꤵ¤ì¤Æ¤¤¤Ê¤±¤ì¤Ð0¤òÁÞÆþ
162    if(!$arrList['limit_count']) $arrList['limit_count'] = "0";
163    if(!$arrList['orverlapping_flg']) $arrList['orverlapping_flg'] = "0";
164    if(!$arrList['cart_flg']) $arrList['cart_flg'] = "0";
165    if(!$arrList['deliv_free_flg']) $arrList['deliv_free_flg'] = "0";
166   
167    $sqlval['campaign_name'] = $arrList['campaign_name'];
168    $sqlval['campaign_point_rate'] = $arrInfo['point_rate'];
169    $sqlval['start_date'] = $start_date;
170    $sqlval['end_date'] = $end_date;
171    $sqlval['directory_name'] = $arrList['directory_name'];
172    $sqlval['limit_count'] = $arrList['limit_count'];
173    $sqlval['orverlapping_flg'] = $arrList['orverlapping_flg'];
174    $sqlval['cart_flg'] = $arrList['cart_flg'];
175    $sqlval['deliv_free_flg'] = $arrList['deliv_free_flg'];
176    $sqlval['update_date'] = "now()";
177   
178    // ¥­¥ã¥ó¥Ú¡¼¥óID¤Ç»ØÄꤵ¤ì¤Æ¤¤¤ë¾ì¹ç¤Ïupdate
179    if($campaign_id != "") {
180        // update
181        $objQuery->update("dtb_campaign", $sqlval, "campaign_id = ?", array($campaign_id));     
182       
183    } else {
184        $sqlval['create_date'] = "now()";   
185        // insert
186        $objQuery->insert("dtb_campaign", $sqlval);
187    }
188}
189
190/*
191 * ´Ø¿ô̾¡§lfGetCampaignList()
192 * ÀâÌÀ¡¡¡§¥­¥ã¥ó¥Ú¡¼¥ó°ìÍ÷¤ò¼èÆÀ
193 * Ìá¤êÃÍ¡§¥­¥ã¥ó¥Ú¡¼¥ó°ìÍ÷ÇÛÎó
194 */
195function lfGetCampaignList() {
196   
197    global $objQuery;
198   
199    $col = "campaign_id,campaign_name,directory_name,total_count";
200    $objQuery->setorder("update_date DESC");
201    $arrRet = $objQuery->select($col, "dtb_campaign", "del_flg = 0");
202
203    return $arrRet;
204}
205
206/*
207 * ´Ø¿ô̾¡§lfGetCampaign()
208 * °ú¿ô1 ¡§¥­¥ã¥ó¥Ú¡¼¥óID
209 * ÀâÌÀ¡¡¡§¥­¥ã¥ó¥Ú¡¼¥ó¾ðÊó¼èÆÀ
210 * Ìá¤êÃÍ¡§¥­¥ã¥ó¥Ú¡¼¥ó¾ðÊóÇÛÎó
211 */
212function lfGetCampaign($campaign_id) {
213   
214    global $objQuery;
215   
216    $col = "campaign_id,campaign_name,start_date,end_date,directory_name,limit_count,orverlapping_flg,cart_flg,deliv_free_flg";
217    $arrRet = $objQuery->select($col, "dtb_campaign", "campaign_id = ?", array($campaign_id));
218
219    // ³«»ÏÆü»þ¡¦Ää»ßÆü»þ¤òʬ²ò
220    $start_date = (date("Y/m/d/H/i/s" , strtotime($arrRet[0]['start_date'])));
221    list($arrRet[0]['start_year'],$arrRet[0]['start_month'],$arrRet[0]['start_day'],$arrRet[0]['start_hour'], $arrRet[0]['start_minute'], $arrRet[0]['start_second']) = split("/", $start_date);
222    $end_date = (date("Y/m/d/H/i/s" , strtotime($arrRet[0]['end_date'])));
223    list($arrRet[0]['end_year'],$arrRet[0]['end_month'],$arrRet[0]['end_day'],$arrRet[0]['end_hour'], $arrRet[0]['end_minute'], $arrRet[0]['end_second']) = split("/", $end_date);
224   
225    return $arrRet[0];
226}
227
228/*
229 * ´Ø¿ô̾¡§lfDeleteCampaign()
230 * °ú¿ô1 ¡§¥­¥ã¥ó¥Ú¡¼¥óID
231 * ÀâÌÀ¡¡¡§¥­¥ã¥ó¥Ú¡¼¥óºï½ü
232 * Ìá¤êÃÍ¡§Ìµ¤·
233 */
234function lfDeleteCampaign($campaign_id) {
235
236    global $objQuery;
237
238    $sqlval['del_flg'] = 1;
239    $sqlval['update_date'] = "now()";   
240
241    // delete
242    $objQuery->update("dtb_campaign", $sqlval, "campaign_id = ?", array($campaign_id));     
243}
244?>
Note: See TracBrowser for help on using the repository browser.