| 1 | <?php |
|---|
| 2 | /** |
|---|
| 3 | * |
|---|
| 4 | * @copyright 2000-2006 LOCKON CO.,LTD. All Rights Reserved. |
|---|
| 5 | * @version CVS: $Id$ |
|---|
| 6 | * @link http://www.lockon.co.jp/ |
|---|
| 7 | * |
|---|
| 8 | */ |
|---|
| 9 | |
|---|
| 10 | require_once("../../require.php"); |
|---|
| 11 | |
|---|
| 12 | define("MDL_EPSILON_ID", 4); |
|---|
| 13 | |
|---|
| 14 | $arrPayment = array( |
|---|
| 15 | 1 => '¥¯¥ì¥¸¥Ã¥È', |
|---|
| 16 | 2 => '¥³¥ó¥Ó¥Ë' |
|---|
| 17 | ); |
|---|
| 18 | |
|---|
| 19 | $arrCredit = array( |
|---|
| 20 | 1 => 'VISA, MASTER', |
|---|
| 21 | 2 => 'JCB, AMEX' |
|---|
| 22 | ); |
|---|
| 23 | |
|---|
| 24 | $arrConvenience = array( |
|---|
| 25 | 11 => '¥»¥Ö¥ó¥¤¥ì¥Ö¥ó' |
|---|
| 26 | ,21 => '¥Õ¥¡¥ß¥ê¡¼¥Þ¡¼¥È' |
|---|
| 27 | ,31 => 'LAWSON' |
|---|
| 28 | ,32 => '¥»¥¤¥³¡¼¥Þ¡¼¥È' |
|---|
| 29 | ,33 => '¥ß¥Ë¥¹¥È¥Ã¥×' |
|---|
| 30 | ,34 => '¥Ç¥¤¥ê¡¼¥ä¥Þ¥¶¥' |
|---|
| 31 | ); |
|---|
| 32 | |
|---|
| 33 | //¥Ú¡¼¥¸´ÉÍý¥¯¥é¥¹ |
|---|
| 34 | class LC_Page { |
|---|
| 35 | //¥³¥ó¥¹¥È¥é¥¯¥¿ |
|---|
| 36 | function LC_Page() { |
|---|
| 37 | //¥á¥¤¥ó¥Æ¥ó¥×¥ì¡¼¥È¤Î»ØÄê |
|---|
| 38 | $this->tpl_mainpage = MODULE_PATH . 'mdl_epsilon.tpl'; |
|---|
| 39 | $this->tpl_subtitle = '¥¤¥×¥·¥í¥ó·èºÑ¥â¥¸¥å¡¼¥ë'; |
|---|
| 40 | global $arrPayment; |
|---|
| 41 | $this->arrPayment = $arrPayment; |
|---|
| 42 | global $arrCredit; |
|---|
| 43 | $this->arrCredit = $arrCredit; |
|---|
| 44 | global $arrConvenience; |
|---|
| 45 | $this->arrConvenience = $arrConvenience; |
|---|
| 46 | } |
|---|
| 47 | } |
|---|
| 48 | $objPage = new LC_Page(); |
|---|
| 49 | $objView = new SC_AdminView(); |
|---|
| 50 | |
|---|
| 51 | // ǧ¾Ú³Îǧ |
|---|
| 52 | $objSess = new SC_Session(); |
|---|
| 53 | sfIsSuccess($objSess); |
|---|
| 54 | |
|---|
| 55 | // ¥Ñ¥é¥á¡¼¥¿´ÉÍý¥¯¥é¥¹ |
|---|
| 56 | $objFormParam = new SC_FormParam(); |
|---|
| 57 | $objFormParam = lfInitParam($objFormParam); |
|---|
| 58 | // POSTÃͤμèÆÀ |
|---|
| 59 | $objFormParam->setParam($_POST); |
|---|
| 60 | |
|---|
| 61 | $objQuery = new SC_Query(); |
|---|
| 62 | |
|---|
| 63 | // ÈÆÍѹàÌܤòÄɲà |
|---|
| 64 | sfAlterMemo(); |
|---|
| 65 | |
|---|
| 66 | switch($_POST['mode']) { |
|---|
| 67 | case 'edit': |
|---|
| 68 | // ÆþÎÏ¥¨¥é¡¼È½Äê |
|---|
| 69 | $objPage->arrErr = lfCheckError(); |
|---|
| 70 | |
|---|
| 71 | if(count($objPage->arrErr) == 0) { |
|---|
| 72 | // ÍøÍÑ¥³¥ó¥Ó¥Ë¤Ë¥Á¥§¥Ã¥¯¤¬Æþ¤Ã¤Æ¤¤¤ë¾ì¹ç¤Ë¤Ï¡¢¥Ï¥¤¥Õ¥ó¶èÀÚ¤ê¤ËÊÔ½¸¤¹¤ë |
|---|
| 73 | $convCnt = count($_POST["convenience"]); |
|---|
| 74 | if($convCnt > 0){ |
|---|
| 75 | $convenience = $_POST["convenience"][0]; |
|---|
| 76 | for($i = 1 ; $i < $convCnt ; $i++){ |
|---|
| 77 | $convenience .= "-" . $_POST["convenience"][$i]; |
|---|
| 78 | } |
|---|
| 79 | } |
|---|
| 80 | |
|---|
| 81 | // DEL/INS¤ÇÅÐÏ¿¤¹¤ë¡£ |
|---|
| 82 | $delsql = "DELETE FROM dtb_payment WHERE memo01 = ?"; |
|---|
| 83 | $objQuery->query($delsql, array(MDL_EPSILON_ID)); |
|---|
| 84 | |
|---|
| 85 | foreach($_POST["payment"] as $key => $val){ |
|---|
| 86 | |
|---|
| 87 | // ¥é¥ó¥¯¤ÎºÇÂçÃͤò¼èÆÀ¤¹¤ë |
|---|
| 88 | $max_rank = $objQuery->getone("SELECT max(rank) FROM dtb_payment"); |
|---|
| 89 | |
|---|
| 90 | // ¥¯¥ì¥¸¥Ã¥È¤Ë¥Á¥§¥Ã¥¯¤¬Æþ¤Ã¤Æ¤¤¤ì¤Ð¥¯¥ì¥¸¥Ã¥È¤òÅÐÏ¿¤¹¤ë |
|---|
| 91 | if($val == 1){ |
|---|
| 92 | $arrData = array( |
|---|
| 93 | "payment_method" => "¥¯¥ì¥¸¥Ã¥È(¥¤¥×¥·¥í¥ó)" |
|---|
| 94 | ,"rule" => "0" |
|---|
| 95 | ,"deliv_id" =>0 |
|---|
| 96 | ,"rank" => $max_rank + 1 |
|---|
| 97 | ,"fix" => 3 |
|---|
| 98 | ,"creator_id" => $objSess->member_id |
|---|
| 99 | ,"create_date" => "now()" |
|---|
| 100 | ,"update_date" => "now()" |
|---|
| 101 | ,"upper_rule" => 500000 |
|---|
| 102 | ,"memo01" => MDL_EPSILON_ID |
|---|
| 103 | ,"memo02" => $_POST["code"] |
|---|
| 104 | ,"memo03" => $_POST["url"] |
|---|
| 105 | ,"memo04" => $val |
|---|
| 106 | ,"memo05" => "10000-0000-00000" |
|---|
| 107 | ); |
|---|
| 108 | } |
|---|
| 109 | |
|---|
| 110 | // ¥³¥ó¥Ó¥Ë¤Ë¥Á¥§¥Ã¥¯¤¬Æþ¤Ã¤Æ¤¤¤ì¤Ð¥³¥ó¥Ó¥Ë¤òÅÐÏ¿¤¹¤ë |
|---|
| 111 | if($val == 2){ |
|---|
| 112 | $arrData = array( |
|---|
| 113 | "payment_method" => "¥³¥ó¥Ó¥Ë(¥¤¥×¥·¥í¥ó)" |
|---|
| 114 | ,"rule" => "0" |
|---|
| 115 | ,"deliv_id" =>0 |
|---|
| 116 | ,"rank" => $max_rank + 1 |
|---|
| 117 | ,"fix" => 3 |
|---|
| 118 | ,"creator_id" => $objSess->member_id |
|---|
| 119 | ,"create_date" => "now()" |
|---|
| 120 | ,"update_date" => "now()" |
|---|
| 121 | ,"upper_rule" => 500000 |
|---|
| 122 | ,"memo01" => MDL_EPSILON_ID |
|---|
| 123 | ,"memo02" => $_POST["code"] |
|---|
| 124 | ,"memo03" => $_POST["url"] |
|---|
| 125 | ,"memo04" => $val |
|---|
| 126 | ,"memo05" => "00100-0000-00000" |
|---|
| 127 | ,"memo06" => $convenience |
|---|
| 128 | ); |
|---|
| 129 | } |
|---|
| 130 | |
|---|
| 131 | $objQuery->insert("dtb_payment", $arrData); |
|---|
| 132 | |
|---|
| 133 | } |
|---|
| 134 | |
|---|
| 135 | // javascript¼Â¹Ô |
|---|
| 136 | $objPage->tpl_onload = 'alert("ÅÐÏ¿´°Î»¤·¤Þ¤·¤¿¡£\n´ðËܾðÊó¡ä»ÙʧÊýË¡ÀßÄê¤è¤ê¾ÜºÙÀßÄê¤ò¤·¤Æ¤¯¤À¤µ¤¤¡£"); window.close();'; |
|---|
| 137 | } |
|---|
| 138 | break; |
|---|
| 139 | case 'module_del': |
|---|
| 140 | // ÈÆÍѹàÌܤθºß¥Á¥§¥Ã¥¯ |
|---|
| 141 | if(!sfColumnExists("dtb_payment", "memo01")){ |
|---|
| 142 | // ¥Ç¡¼¥¿¤Îºï½ü |
|---|
| 143 | $objQuery->query("DELETE FROM dtb_payment WHERE memo01 = ?", array(MDL_EPSILON_ID)); |
|---|
| 144 | } |
|---|
| 145 | break; |
|---|
| 146 | default: |
|---|
| 147 | // ¥Ç¡¼¥¿¤Î¥í¡¼¥É |
|---|
| 148 | lfLoadData(); |
|---|
| 149 | break; |
|---|
| 150 | } |
|---|
| 151 | |
|---|
| 152 | $objPage->arrForm = $objFormParam->getFormParamList(); |
|---|
| 153 | |
|---|
| 154 | $objView->assignobj($objPage); //ÊÑ¿ô¤ò¥Æ¥ó¥×¥ì¡¼¥È¤Ë¥¢¥µ¥¤¥ó¤¹¤ëaaaaa |
|---|
| 155 | $objView->display($objPage->tpl_mainpage); //¥Æ¥ó¥×¥ì¡¼¥È¤Î½ÐÎÏ |
|---|
| 156 | //------------------------------------------------------------------------------------------------------- |
|---|
| 157 | /* ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ */ |
|---|
| 158 | function lfInitParam($objFormParam) { |
|---|
| 159 | $objFormParam->addParam("·ÀÌ󥳡¼¥É", "code", INT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK")); |
|---|
| 160 | $objFormParam->addParam("ÀܳÀèURL", "url", URL_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "URL_CHECK")); |
|---|
| 161 | $objFormParam->addParam("ÍøÍÑ·èºÑ", "payment", "", "", array("EXIST_CHECK")); |
|---|
| 162 | $objFormParam->addParam("ÍøÍÑ¥¯¥ì¥¸¥Ã¥È", "credit"); |
|---|
| 163 | $objFormParam->addParam("ÍøÍÑ¥³¥ó¥Ó¥Ë", "convenience"); |
|---|
| 164 | return $objFormParam; |
|---|
| 165 | } |
|---|
| 166 | |
|---|
| 167 | // ¥¨¥é¡¼¥Á¥§¥Ã¥¯¤ò¹Ô¤¦ |
|---|
| 168 | function lfCheckError(){ |
|---|
| 169 | global $objFormParam; |
|---|
| 170 | |
|---|
| 171 | $arrErr = $objFormParam->checkError(); |
|---|
| 172 | |
|---|
| 173 | // ÍøÍÑ¥¯¥ì¥¸¥Ã¥È¡¢ÍøÍÑ¥³¥ó¥Ó¥Ë¤Î¥¨¥é¡¼¥Á¥§¥Ã¥¯ |
|---|
| 174 | $arrChkPay = $_POST["payment"]; |
|---|
| 175 | foreach($arrChkPay as $key => $val){ |
|---|
| 176 | // ÍøÍÑ¥¯¥ì¥¸¥Ã¥È |
|---|
| 177 | if($val == 1 and count($_POST["credit"]) <= 0){ |
|---|
| 178 | $arrErr["credit"] = "ÍøÍÑ¥¯¥ì¥¸¥Ã¥È¤¬ÁªÂò¤µ¤ì¤Æ¤¤¤Þ¤»¤ó¡£<br />"; |
|---|
| 179 | } |
|---|
| 180 | |
|---|
| 181 | // ÍøÍÑ¥³¥ó¥Ó¥Ë |
|---|
| 182 | if($val == 2 and count($_POST["convenience"]) <= 0){ |
|---|
| 183 | $arrErr["convenience"] = "ÍøÍÑ¥³¥ó¥Ó¥Ë¤¬ÁªÂò¤µ¤ì¤Æ¤¤¤Þ¤»¤ó¡£<br />"; |
|---|
| 184 | } } |
|---|
| 185 | |
|---|
| 186 | return $arrErr; |
|---|
| 187 | } |
|---|
| 188 | |
|---|
| 189 | // ÅÐÏ¿¥Ç¡¼¥¿¤òÆÉ¤ß¹þ¤à |
|---|
| 190 | function lfLoadData(){ |
|---|
| 191 | global $objQuery; |
|---|
| 192 | global $objFormParam; |
|---|
| 193 | |
|---|
| 194 | $sql = "SELECT |
|---|
| 195 | memo01, |
|---|
| 196 | memo02 as code, |
|---|
| 197 | memo03 as url, |
|---|
| 198 | memo04 as payment, |
|---|
| 199 | memo05 as payment_code, |
|---|
| 200 | memo06 as conbenience |
|---|
| 201 | FROM dtb_payment WHERE memo01 = ?"; |
|---|
| 202 | $arrRet = $objQuery->getall($sql, array(MDL_EPSILON_ID)); |
|---|
| 203 | |
|---|
| 204 | // ²èÌÌɽ¼¨ÍѤ˥ǡ¼¥¿¤òÊÑ´¹ |
|---|
| 205 | $arrDisp = $arrRet[0]; |
|---|
| 206 | foreach($arrRet as $key => $val){ |
|---|
| 207 | // ÍøÍÑ·èºÑ¤òɽ¼¨ÍѤËÊÑ´¹ |
|---|
| 208 | $arrDisp["payment"][$key] .= $val["payment"]; |
|---|
| 209 | } |
|---|
| 210 | |
|---|
| 211 | sfprintr($arrDisp); |
|---|
| 212 | $objFormParam->setParam($arrRet[0]); |
|---|
| 213 | } |
|---|
| 214 | |
|---|
| 215 | ?> |
|---|