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

Revision 10784, 7.6 KB checked in by uehara, 19 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
44//----¡¡¿·µ¬ÅÐÏ¿/ÊÔ½¸ÅÐÏ¿
45switch($_POST['mode']) {
46    case 'regist':
47        // ¥¨¥é¡¼¥Á¥§¥Ã¥¯
48        $objPage->arrErr = lfErrorCheck();
49       
50        if(count($objPage->arrErr) <= 0) {
51            // ÅÐÏ¿
52            lfRegistCampaign();
53            $objPage->tpl_onload = "alert('ÅÐÏ¿¤¬´°Î»¤·¤Þ¤·¤¿');";
54            // ¥Õ¥©¡¼¥à¤ÎÃͤò¥¯¥ê¥¢
55            $objPage->arrForm = array();
56        }
57        break;
58    case 'update':
59        // ¥­¥ã¥ó¥Ú¡¼¥ó¾ðÊó¤ò¼èÆÀ
60        $objPage->arrForm = lfGetCampaign($_POST['campaign_id']);
61        break;
62    case 'delete':
63        echo "delete";
64        break;
65    default:
66        break;
67}
68
69// ¥­¥ã¥ó¥Ú¡¼¥ó°ìÍ÷¼èÆÀ
70$objPage->arrCampaign = lfGetCampaignList();
71
72// ¥­¥ã¥ó¥Ú¡¼¥ó´ü´ÖÍÑ
73$objDate = new SC_Date();
74$objPage->arrYear = $objDate->getYear();
75$objPage->arrMonth = $objDate->getMonth();
76$objPage->arrDay = $objDate->getDay();
77$objPage->arrHour = $objDate->getHour();
78$objPage->arrMinutes = $objDate->getMinutes();
79
80//----¡¡¥Ú¡¼¥¸É½¼¨
81$objView->assignobj($objPage);
82$objView->display(MAIN_FRAME);
83
84
85//---------------------------------------------------------------------------------------------------------------------------------------------------------
86/*
87 * ´Ø¿ô̾¡§lfInitParam
88 * ÀâÌÀ¡¡¡§ÆþÎϾðÊó¤Î½é´ü²½
89 */
90function lfInitParam() {
91    global $objFormParam;
92       
93    $objFormParam->addParam("¥­¥ã¥ó¥Ú¡¼¥ó̾", "campaign_name", MTEXT_LEN, "KVa", array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
94   
95    // ´ü´Ö½¸·×
96    $objFormParam->addParam("³«»ÏÆü»þ", "start_year", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
97    $objFormParam->addParam("³«»ÏÆü»þ", "start_month", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
98    $objFormParam->addParam("³«»ÏÆü»þ", "start_day", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
99    $objFormParam->addParam("³«»ÏÆü»þ", "start_hour", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
100    $objFormParam->addParam("³«»ÏÆü»þ", "start_minute", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
101
102    $objFormParam->addParam("Ää»ßÆü»þ", "end_year", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
103    $objFormParam->addParam("Ää»ßÆü»þ", "end_month", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
104    $objFormParam->addParam("Ää»ßÆü»þ", "end_day", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
105    $objFormParam->addParam("Ää»ßÆü»þ", "end_hour", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
106    $objFormParam->addParam("Ää»ßÆü»þ", "end_minute", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
107
108    $objFormParam->addParam("¥Ç¥£¥ì¥¯¥È¥ê̾", "directory_name", MTEXT_LEN, "KVa", array("EXIST_CHECK","SPTAB_CHECK","MAX_LENGTH_CHECK"));
109    $objFormParam->addParam("¿½¹þ¿ôÀ©¸æ", "limit_count", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
110    $objFormParam->addParam("½ÅÊ£¿½¹þÀ©¸æ", "orverlapping_flg", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
111    $objFormParam->addParam("¥«¡¼¥È¤Ë¾¦ÉʤòÆþ¤ì¤ë", "cart_flg", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
112    $objFormParam->addParam("Á÷ÎÁ̵ÎÁÀßÄê", "deliv_free_flg", INT_LEN, "n", array("MAX_LENGTH_CHECK", "NUM_CHECK"));
113
114}
115
116/*
117 * ´Ø¿ô̾¡§lfErrorCheck()
118 * ÀâÌÀ¡¡¡§¥¨¥é¡¼¥Á¥§¥Ã¥¯
119 * Ìá¤êÃÍ¡§¥¨¥é¡¼Ê¸»ú³ÊǼÇÛÎó
120 */
121function lfErrorCheck() {
122   
123    global $objFormParam;
124
125    $arrList = $objFormParam->getHashArray();
126    $objErr = new SC_CheckError($arrList);
127    $objErr->arrErr = $objFormParam->checkError();
128   
129    $objErr->doFunc(array("³«»ÏÆü»þ", "start_year", "start_month", "start_day", "start_hour", "start_minute", "0"), array("CHECK_DATE2"));
130    $objErr->doFunc(array("Ää»ßÆü»þ", "end_year", "end_month", "end_day", "end_hour", "end_minute", "0"), array("CHECK_DATE2"));
131    $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"));
132   
133    return $objErr->arrErr;
134}
135
136/*
137 * ´Ø¿ô̾¡§lfRegistCampaign()
138 * ÀâÌÀ¡¡¡§¥­¥ã¥ó¥Ú¡¼¥óÅÐÏ¿
139 * Ìá¤êÃÍ¡§Ìµ¤·
140 */
141function lfRegistCampaign() {
142
143    global $objFormParam;
144    global $objQuery;
145   
146    $objSiteInfo = new SC_SiteInfo();
147    $arrInfo = $objSiteInfo->data;
148    $arrList = $objFormParam->getHashArray();   
149
150    // ³«»ÏÆü»þ¡¦½ªÎ»Æü»þÀ°·Á
151    $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";
152    $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";
153
154    // ¥Ý¥¤¥ó¥È¥ì¡¼¥È¤ÏÀßÄꤵ¤ì¤Æ¤¤¤Ê¤±¤ì¤Ð0¤òÁÞÆþ
155    if($arrInfo['point_rate'] == "") $arrInfo['point_rate'] = "0";
156
157    $sqlval['campaign_name'] = $arrList['campaign_name'];
158    $sqlval['campaign_point_rate'] = $arrInfo['point_rate'];
159    $sqlval['start_date'] = $start_date;
160    $sqlval['end_date'] = $end_date;
161    $sqlval['directory_name'] = $arrList['directory_name'];
162    if($arrList['limit_count']) $sqlval['limit_count'] = $arrList['limit_count'];
163    if($arrList['orverlapping_flg']) $sqlval['orverlapping_flg'] = $arrList['orverlapping_flg'];
164    if($arrList['cart_flg']) $sqlval['cart_flg'] = $arrList['cart_flg'];
165    if($arrList['deliv_free_flg']) $sqlval['deliv_free_flg'] = $arrList['deliv_free_flg'];
166    $sqlval['create_date'] = "now()";
167    $sqlval['update_date'] = "now()";
168   
169    // insert
170    $objQuery->insert("dtb_campaign", $sqlval);
171}
172
173/*
174 * ´Ø¿ô̾¡§lfGetCampaignList()
175 * ÀâÌÀ¡¡¡§¥­¥ã¥ó¥Ú¡¼¥ó°ìÍ÷¤ò¼èÆÀ
176 * Ìá¤êÃÍ¡§¥­¥ã¥ó¥Ú¡¼¥ó°ìÍ÷ÇÛÎó
177 */
178function lfGetCampaignList() {
179   
180    global $objQuery;
181   
182    $col = "campaign_id,campaign_name,directory_name,total_count";
183    $objQuery->setorder("update_date");
184    $arrRet = $objQuery->select($col, "dtb_campaign", "del_flg = 0");
185
186    return $arrRet;
187}
188
189/*
190 * ´Ø¿ô̾¡§lfGetCampaign()
191 * °ú¿ô1 ¡§¥­¥ã¥ó¥Ú¡¼¥óID
192 * ÀâÌÀ¡¡¡§¥­¥ã¥ó¥Ú¡¼¥ó¾ðÊó¼èÆÀ
193 * Ìá¤êÃÍ¡§¥­¥ã¥ó¥Ú¡¼¥ó¾ðÊóÇÛÎó
194 */
195function lfGetCampaign($campaign_id) {
196   
197    global $objQuery;
198   
199    $col = "campaign_id,campaign_name,start_date,end_date,directory_name,limit_count,orverlapping_flg,cart_flg,deliv_free_flg";
200    $arrRet = $objQuery->select($col, "dtb_campaign", "campaign_id = ?", array($campaign_id));
201
202    // ³«»ÏÆü»þ¡¦Ää»ßÆü»þ¤òʬ²ò
203    $start_date = (date("Y/m/d/H/i/s" , strtotime($arrRet[0]['start_date'])));
204    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);
205    $end_date = (date("Y/m/d/H/i/s" , strtotime($arrRet[0]['end_date'])));
206    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);
207   
208    return $arrRet[0];
209}
210?>
Note: See TracBrowser for help on using the repository browser.