Index: temp/trunk/data/downloads/module/mdl_epsilon/mdl_epsilon.php =================================================================== --- temp/trunk/data/downloads/module/mdl_epsilon/mdl_epsilon.php (revision 7557) +++ temp/trunk/data/downloads/module/mdl_epsilon/mdl_epsilon.php (revision 7557) @@ -0,0 +1,230 @@ + '¥¯¥ì¥¸¥Ã¥È', + 2 => '¥³¥ó¥Ó¥Ë' +); + +$arrCredit = array( + 1 => 'VISA, MASTER', + 2 => 'JCB, AMEX' +); + +$arrConvenience = array( + 11 => '¥»¥Ö¥ó¥¤¥ì¥Ö¥ó' + ,21 => '¥Õ¥¡¥ß¥ê¡¼¥Þ¡¼¥È' + ,31 => 'LAWSON' + ,32 => '¥»¥¤¥³¡¼¥Þ¡¼¥È' + ,33 => '¥ß¥Ë¥¹¥È¥Ã¥×' + ,34 => '¥Ç¥¤¥ê¡¼¥ä¥Þ¥¶¥­' +); + +//¥Ú¡¼¥¸´ÉÍý¥¯¥é¥¹ +class LC_Page { + //¥³¥ó¥¹¥È¥é¥¯¥¿ + function LC_Page() { + //¥á¥¤¥ó¥Æ¥ó¥×¥ì¡¼¥È¤Î»ØÄê + $this->tpl_mainpage = MODULE_PATH . 'mdl_epsilon.tpl'; + $this->tpl_subtitle = '¥¤¥×¥·¥í¥ó·èºÑ¥â¥¸¥å¡¼¥ë'; + global $arrPayment; + $this->arrPayment = $arrPayment; + global $arrCredit; + $this->arrCredit = $arrCredit; + global $arrConvenience; + $this->arrConvenience = $arrConvenience; + } +} +$objPage = new LC_Page(); +$objView = new SC_AdminView(); + +// ǧ¾Ú³Îǧ +$objSess = new SC_Session(); +sfIsSuccess($objSess); + +// ¥Ñ¥é¥á¡¼¥¿´ÉÍý¥¯¥é¥¹ +$objFormParam = new SC_FormParam(); +$objFormParam = lfInitParam($objFormParam); +// POSTÃͤμèÆÀ +$objFormParam->setParam($_POST); + +$objQuery = new SC_Query(); + +// ÈÆÍѹàÌܤòÄɲÃ(ɬ¿Ü¡ª¡ª) +sfAlterMemo(); + +switch($_POST['mode']) { +case 'edit': + // ÆþÎÏ¥¨¥é¡¼È½Äê + $objPage->arrErr = lfCheckError(); + + if(count($objPage->arrErr) == 0) { + // ÍøÍÑ¥³¥ó¥Ó¥Ë¤Ë¥Á¥§¥Ã¥¯¤¬Æþ¤Ã¤Æ¤¤¤ë¾ì¹ç¤Ë¤Ï¡¢¥Ï¥¤¥Õ¥ó¶èÀÚ¤ê¤ËÊÔ½¸¤¹¤ë + $convCnt = count($_POST["convenience"]); + if($convCnt > 0){ + $convenience = $_POST["convenience"][0]; + for($i = 1 ; $i < $convCnt ; $i++){ + $convenience .= "-" . $_POST["convenience"][$i]; + } + } + + // DEL/INS¤ÇÅÐÏ¿¤¹¤ë¡£ + $delsql = "DELETE FROM dtb_payment WHERE memo01 = ?"; + $objQuery->query($delsql, array(MDL_EPSILON_ID)); + + foreach($_POST["payment"] as $key => $val){ + + // ¥é¥ó¥¯¤ÎºÇÂçÃͤò¼èÆÀ¤¹¤ë + $max_rank = $objQuery->getone("SELECT max(rank) FROM dtb_payment"); + + // ¥¯¥ì¥¸¥Ã¥È¤Ë¥Á¥§¥Ã¥¯¤¬Æþ¤Ã¤Æ¤¤¤ì¤Ð¥¯¥ì¥¸¥Ã¥È¤òÅÐÏ¿¤¹¤ë + if($val == 1){ + (in_array(1, $_POST["credit"])) ? $visa = "1" : $visa = "0"; + (in_array(2, $_POST["credit"])) ? $jcb = "1" : $jcb = "0"; + + $arrData = array( + "payment_method" => "¥¯¥ì¥¸¥Ã¥È(¥¤¥×¥·¥í¥ó)" + ,"rule" => "0" + ,"deliv_id" =>0 + ,"rank" => $max_rank + 1 + ,"fix" => 3 + ,"creator_id" => $objSess->member_id + ,"create_date" => "now()" + ,"update_date" => "now()" + ,"upper_rule" => 500000 + ,"memo01" => MDL_EPSILON_ID + ,"memo02" => $_POST["code"] + ,"memo03" => $_POST["url"] + ,"memo04" => $val + ,"memo05" => $visa . $jcb . "000-0000-00000" + ); + } + + // ¥³¥ó¥Ó¥Ë¤Ë¥Á¥§¥Ã¥¯¤¬Æþ¤Ã¤Æ¤¤¤ì¤Ð¥³¥ó¥Ó¥Ë¤òÅÐÏ¿¤¹¤ë + if($val == 2){ + $arrData = array( + "payment_method" => "¥³¥ó¥Ó¥Ë(¥¤¥×¥·¥í¥ó)" + ,"rule" => "0" + ,"deliv_id" =>0 + ,"rank" => $max_rank + 1 + ,"fix" => 3 + ,"creator_id" => $objSess->member_id + ,"create_date" => "now()" + ,"update_date" => "now()" + ,"upper_rule" => 500000 + ,"memo01" => MDL_EPSILON_ID + ,"memo02" => $_POST["code"] + ,"memo03" => $_POST["url"] + ,"memo04" => $val + ,"memo05" => "00100-0000-00000" + ,"memo06" => $convenience + ); + } + + $objQuery->insert("dtb_payment", $arrData); + + } + + // javascript¼Â¹Ô + $objPage->tpl_onload = 'alert("ÅÐÏ¿´°Î»¤·¤Þ¤·¤¿¡£\n´ðËܾðÊó¡ä»ÙʧÊýË¡ÀßÄê¤è¤ê¾ÜºÙÀßÄê¤ò¤·¤Æ¤¯¤À¤µ¤¤¡£"); window.close();'; + } + break; +case 'module_del': + // ÈÆÍѹàÌܤθºß¥Á¥§¥Ã¥¯ + if(sfColumnExists("dtb_payment", "memo01")){ + // ¥Ç¡¼¥¿¤Îºï½ü + $objQuery->query("DELETE FROM dtb_payment WHERE memo01 = ?", array(MDL_EPSILON_ID)); + } + break; +default: + // ¥Ç¡¼¥¿¤Î¥í¡¼¥É + lfLoadData(); + break; +} + +$objPage->arrForm = $objFormParam->getFormParamList(); + +$objView->assignobj($objPage); //ÊÑ¿ô¤ò¥Æ¥ó¥×¥ì¡¼¥È¤Ë¥¢¥µ¥¤¥ó¤¹¤ë +$objView->display($objPage->tpl_mainpage); //¥Æ¥ó¥×¥ì¡¼¥È¤Î½ÐÎÏ +//------------------------------------------------------------------------------------------------------- +/* ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ */ +function lfInitParam($objFormParam) { + $objFormParam->addParam("·ÀÌ󥳡¼¥É", "code", INT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK")); + $objFormParam->addParam("ÀܳÀèURL", "url", URL_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "URL_CHECK")); + $objFormParam->addParam("ÍøÍÑ·èºÑ", "payment", "", "", array("EXIST_CHECK")); + $objFormParam->addParam("ÍøÍÑ¥¯¥ì¥¸¥Ã¥È", "credit"); + $objFormParam->addParam("ÍøÍÑ¥³¥ó¥Ó¥Ë", "convenience"); + return $objFormParam; +} + +// ¥¨¥é¡¼¥Á¥§¥Ã¥¯¤ò¹Ô¤¦ +function lfCheckError(){ + global $objFormParam; + + $arrErr = $objFormParam->checkError(); + + // ÍøÍÑ¥¯¥ì¥¸¥Ã¥È¡¢ÍøÍÑ¥³¥ó¥Ó¥Ë¤Î¥¨¥é¡¼¥Á¥§¥Ã¥¯ + $arrChkPay = $_POST["payment"]; + foreach($arrChkPay as $key => $val){ + // ÍøÍÑ¥¯¥ì¥¸¥Ã¥È + if($val == 1 and count($_POST["credit"]) <= 0){ + $arrErr["credit"] = "ÍøÍÑ¥¯¥ì¥¸¥Ã¥È¤¬ÁªÂò¤µ¤ì¤Æ¤¤¤Þ¤»¤ó¡£
"; + } + + // ÍøÍÑ¥³¥ó¥Ó¥Ë + if($val == 2 and count($_POST["convenience"]) <= 0){ + $arrErr["convenience"] = "ÍøÍÑ¥³¥ó¥Ó¥Ë¤¬ÁªÂò¤µ¤ì¤Æ¤¤¤Þ¤»¤ó¡£
"; + } } + + return $arrErr; +} + +// ÅÐÏ¿¥Ç¡¼¥¿¤òÆɤ߹þ¤à +function lfLoadData(){ + global $objQuery; + global $objFormParam; + + $sql = "SELECT + memo01, + memo02 as code, + memo03 as url, + memo04 as payment, + memo05 as payment_code, + memo06 as convenience + FROM dtb_payment WHERE memo01 = ?"; + $arrRet = $objQuery->getall($sql, array(MDL_EPSILON_ID)); + + $objFormParam->setParam($arrRet[0]); + + // ²èÌÌɽ¼¨ÍѤ˥ǡ¼¥¿¤òÊÑ´¹ + $arrDisp = array(); + foreach($arrRet as $key => $val){ + // ÍøÍÑ·èºÑ¤òɽ¼¨ÍѤËÊÑ´¹ + $arrDisp["payment"][$key] = $val["payment"]; + + // ¥¯¥ì¥¸¥Ã¥È¤Î·èºÑ¶èʬ¤ò¼èÆÀ + if($val["payment"] == 1) $credit = $val["payment_code"]; + + // ¥³¥ó¥Ó¥Ë + if($val["payment"] == 2) $arrDisp["convenience"] = $val["convenience"]; + } + $objFormParam->setParam($arrDisp); + $objFormParam->splitParamCheckBoxes("convenience"); + + // ¥¯¥ì¥¸¥Ã¥È + if(substr($credit, 0, 1)) $arrCredit["credit"][] = 1; + if(substr($credit, 1, 1)) $arrCredit["credit"][] = 2; + $objFormParam->setParam($arrCredit); +} + +?> Index: temp/trunk/data/downloads/module/mdl_epsilon.php =================================================================== --- temp/trunk/data/downloads/module/mdl_epsilon.php (revision 7554) +++ (revision ) @@ -1,230 +1,0 @@ - '¥¯¥ì¥¸¥Ã¥È', - 2 => '¥³¥ó¥Ó¥Ë' -); - -$arrCredit = array( - 1 => 'VISA, MASTER', - 2 => 'JCB, AMEX' -); - -$arrConvenience = array( - 11 => '¥»¥Ö¥ó¥¤¥ì¥Ö¥ó' - ,21 => '¥Õ¥¡¥ß¥ê¡¼¥Þ¡¼¥È' - ,31 => 'LAWSON' - ,32 => '¥»¥¤¥³¡¼¥Þ¡¼¥È' - ,33 => '¥ß¥Ë¥¹¥È¥Ã¥×' - ,34 => '¥Ç¥¤¥ê¡¼¥ä¥Þ¥¶¥­' -); - -//¥Ú¡¼¥¸´ÉÍý¥¯¥é¥¹ -class LC_Page { - //¥³¥ó¥¹¥È¥é¥¯¥¿ - function LC_Page() { - //¥á¥¤¥ó¥Æ¥ó¥×¥ì¡¼¥È¤Î»ØÄê - $this->tpl_mainpage = MODULE_PATH . 'mdl_epsilon.tpl'; - $this->tpl_subtitle = '¥¤¥×¥·¥í¥ó·èºÑ¥â¥¸¥å¡¼¥ë'; - global $arrPayment; - $this->arrPayment = $arrPayment; - global $arrCredit; - $this->arrCredit = $arrCredit; - global $arrConvenience; - $this->arrConvenience = $arrConvenience; - } -} -$objPage = new LC_Page(); -$objView = new SC_AdminView(); - -// ǧ¾Ú³Îǧ -$objSess = new SC_Session(); -sfIsSuccess($objSess); - -// ¥Ñ¥é¥á¡¼¥¿´ÉÍý¥¯¥é¥¹ -$objFormParam = new SC_FormParam(); -$objFormParam = lfInitParam($objFormParam); -// POSTÃͤμèÆÀ -$objFormParam->setParam($_POST); - -$objQuery = new SC_Query(); - -// ÈÆÍѹàÌܤòÄɲÃ(ɬ¿Ü¡ª¡ª) -sfAlterMemo(); - -switch($_POST['mode']) { -case 'edit': - // ÆþÎÏ¥¨¥é¡¼È½Äê - $objPage->arrErr = lfCheckError(); - - if(count($objPage->arrErr) == 0) { - // ÍøÍÑ¥³¥ó¥Ó¥Ë¤Ë¥Á¥§¥Ã¥¯¤¬Æþ¤Ã¤Æ¤¤¤ë¾ì¹ç¤Ë¤Ï¡¢¥Ï¥¤¥Õ¥ó¶èÀÚ¤ê¤ËÊÔ½¸¤¹¤ë - $convCnt = count($_POST["convenience"]); - if($convCnt > 0){ - $convenience = $_POST["convenience"][0]; - for($i = 1 ; $i < $convCnt ; $i++){ - $convenience .= "-" . $_POST["convenience"][$i]; - } - } - - // DEL/INS¤ÇÅÐÏ¿¤¹¤ë¡£ - $delsql = "DELETE FROM dtb_payment WHERE memo01 = ?"; - $objQuery->query($delsql, array(MDL_EPSILON_ID)); - - foreach($_POST["payment"] as $key => $val){ - - // ¥é¥ó¥¯¤ÎºÇÂçÃͤò¼èÆÀ¤¹¤ë - $max_rank = $objQuery->getone("SELECT max(rank) FROM dtb_payment"); - - // ¥¯¥ì¥¸¥Ã¥È¤Ë¥Á¥§¥Ã¥¯¤¬Æþ¤Ã¤Æ¤¤¤ì¤Ð¥¯¥ì¥¸¥Ã¥È¤òÅÐÏ¿¤¹¤ë - if($val == 1){ - (in_array(1, $_POST["credit"])) ? $visa = "1" : $visa = "0"; - (in_array(2, $_POST["credit"])) ? $jcb = "1" : $jcb = "0"; - - $arrData = array( - "payment_method" => "¥¯¥ì¥¸¥Ã¥È(¥¤¥×¥·¥í¥ó)" - ,"rule" => "0" - ,"deliv_id" =>0 - ,"rank" => $max_rank + 1 - ,"fix" => 3 - ,"creator_id" => $objSess->member_id - ,"create_date" => "now()" - ,"update_date" => "now()" - ,"upper_rule" => 500000 - ,"memo01" => MDL_EPSILON_ID - ,"memo02" => $_POST["code"] - ,"memo03" => $_POST["url"] - ,"memo04" => $val - ,"memo05" => $visa . $jcb . "000-0000-00000" - ); - } - - // ¥³¥ó¥Ó¥Ë¤Ë¥Á¥§¥Ã¥¯¤¬Æþ¤Ã¤Æ¤¤¤ì¤Ð¥³¥ó¥Ó¥Ë¤òÅÐÏ¿¤¹¤ë - if($val == 2){ - $arrData = array( - "payment_method" => "¥³¥ó¥Ó¥Ë(¥¤¥×¥·¥í¥ó)" - ,"rule" => "0" - ,"deliv_id" =>0 - ,"rank" => $max_rank + 1 - ,"fix" => 3 - ,"creator_id" => $objSess->member_id - ,"create_date" => "now()" - ,"update_date" => "now()" - ,"upper_rule" => 500000 - ,"memo01" => MDL_EPSILON_ID - ,"memo02" => $_POST["code"] - ,"memo03" => $_POST["url"] - ,"memo04" => $val - ,"memo05" => "00100-0000-00000" - ,"memo06" => $convenience - ); - } - - $objQuery->insert("dtb_payment", $arrData); - - } - - // javascript¼Â¹Ô - $objPage->tpl_onload = 'alert("ÅÐÏ¿´°Î»¤·¤Þ¤·¤¿¡£\n´ðËܾðÊó¡ä»ÙʧÊýË¡ÀßÄê¤è¤ê¾ÜºÙÀßÄê¤ò¤·¤Æ¤¯¤À¤µ¤¤¡£"); window.close();'; - } - break; -case 'module_del': - // ÈÆÍѹàÌܤθºß¥Á¥§¥Ã¥¯ - if(sfColumnExists("dtb_payment", "memo01")){ - // ¥Ç¡¼¥¿¤Îºï½ü - $objQuery->query("DELETE FROM dtb_payment WHERE memo01 = ?", array(MDL_EPSILON_ID)); - } - break; -default: - // ¥Ç¡¼¥¿¤Î¥í¡¼¥É - lfLoadData(); - break; -} - -$objPage->arrForm = $objFormParam->getFormParamList(); - -$objView->assignobj($objPage); //ÊÑ¿ô¤ò¥Æ¥ó¥×¥ì¡¼¥È¤Ë¥¢¥µ¥¤¥ó¤¹¤ë -$objView->display($objPage->tpl_mainpage); //¥Æ¥ó¥×¥ì¡¼¥È¤Î½ÐÎÏ -//------------------------------------------------------------------------------------------------------- -/* ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ */ -function lfInitParam($objFormParam) { - $objFormParam->addParam("·ÀÌ󥳡¼¥É", "code", INT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "NUM_CHECK")); - $objFormParam->addParam("ÀܳÀèURL", "url", URL_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "URL_CHECK")); - $objFormParam->addParam("ÍøÍÑ·èºÑ", "payment", "", "", array("EXIST_CHECK")); - $objFormParam->addParam("ÍøÍÑ¥¯¥ì¥¸¥Ã¥È", "credit"); - $objFormParam->addParam("ÍøÍÑ¥³¥ó¥Ó¥Ë", "convenience"); - return $objFormParam; -} - -// ¥¨¥é¡¼¥Á¥§¥Ã¥¯¤ò¹Ô¤¦ -function lfCheckError(){ - global $objFormParam; - - $arrErr = $objFormParam->checkError(); - - // ÍøÍÑ¥¯¥ì¥¸¥Ã¥È¡¢ÍøÍÑ¥³¥ó¥Ó¥Ë¤Î¥¨¥é¡¼¥Á¥§¥Ã¥¯ - $arrChkPay = $_POST["payment"]; - foreach($arrChkPay as $key => $val){ - // ÍøÍÑ¥¯¥ì¥¸¥Ã¥È - if($val == 1 and count($_POST["credit"]) <= 0){ - $arrErr["credit"] = "ÍøÍÑ¥¯¥ì¥¸¥Ã¥È¤¬ÁªÂò¤µ¤ì¤Æ¤¤¤Þ¤»¤ó¡£
"; - } - - // ÍøÍÑ¥³¥ó¥Ó¥Ë - if($val == 2 and count($_POST["convenience"]) <= 0){ - $arrErr["convenience"] = "ÍøÍÑ¥³¥ó¥Ó¥Ë¤¬ÁªÂò¤µ¤ì¤Æ¤¤¤Þ¤»¤ó¡£
"; - } } - - return $arrErr; -} - -// ÅÐÏ¿¥Ç¡¼¥¿¤òÆɤ߹þ¤à -function lfLoadData(){ - global $objQuery; - global $objFormParam; - - $sql = "SELECT - memo01, - memo02 as code, - memo03 as url, - memo04 as payment, - memo05 as payment_code, - memo06 as convenience - FROM dtb_payment WHERE memo01 = ?"; - $arrRet = $objQuery->getall($sql, array(MDL_EPSILON_ID)); - - $objFormParam->setParam($arrRet[0]); - - // ²èÌÌɽ¼¨ÍѤ˥ǡ¼¥¿¤òÊÑ´¹ - $arrDisp = array(); - foreach($arrRet as $key => $val){ - // ÍøÍÑ·èºÑ¤òɽ¼¨ÍѤËÊÑ´¹ - $arrDisp["payment"][$key] = $val["payment"]; - - // ¥¯¥ì¥¸¥Ã¥È¤Î·èºÑ¶èʬ¤ò¼èÆÀ - if($val["payment"] == 1) $credit = $val["payment_code"]; - - // ¥³¥ó¥Ó¥Ë - if($val["payment"] == 2) $arrDisp["convenience"] = $val["convenience"]; - } - $objFormParam->setParam($arrDisp); - $objFormParam->splitParamCheckBoxes("convenience"); - - // ¥¯¥ì¥¸¥Ã¥È - if(substr($credit, 0, 1)) $arrCredit["credit"][] = 1; - if(substr($credit, 1, 1)) $arrCredit["credit"][] = 2; - $objFormParam->setParam($arrCredit); -} - -?>