Index: /branches/beta/data/downloads/module/mdl_combz/combz_mail.tpl =================================================================== --- /branches/beta/data/downloads/module/mdl_combz/combz_mail.tpl (revision 16649) +++ /branches/beta/data/downloads/module/mdl_combz/combz_mail.tpl (revision 16649) @@ -0,0 +1,4 @@ + + + + Index: /branches/beta/data/downloads/module/mdl_combz/mdl_combz.php =================================================================== --- /branches/beta/data/downloads/module/mdl_combz/mdl_combz.php (revision 16649) +++ /branches/beta/data/downloads/module/mdl_combz/mdl_combz.php (revision 16649) @@ -0,0 +1,92 @@ +tpl_mainpage = MODULE_PATH . 'mdl_combz/mdl_combz.tpl'; + $this->tpl_subtitle = MODULE_NAME; + } +} +$objPage = new LC_Page(); +$objView = new SC_AdminView(); +$objQuery = new SC_Query(); + +// ǧ¾Ú³Îǧ +$objSess = new SC_Session(); +sfIsSuccess($objSess); + +// ¥Ñ¥é¥á¡¼¥¿´ÉÍý¥¯¥é¥¹ +$objFormParam = new SC_FormParam(); +$objFormParam = lfInitParam($objFormParam); +// POSTÃͤμèÆÀ +$objFormParam->setParam($_POST); + +// ÈÆÍѹàÌܤòÄɲÃ(ɬ¿Ü¡ª¡ª) +sfAlterMemo(); + +switch($_POST['mode']) { +case 'edit': + // ÆþÎÏ¥¨¥é¡¼È½Äê + $objPage->arrErr = lfCheckError(); + + // ¥¨¥é¡¼¤Ê¤·¤Î¾ì¹ç¤Ë¤Ï¥Ç¡¼¥¿¤ò¹¹¿· + if(count($objPage->arrErr) == 0) { + // ¥Ç¡¼¥¿¹¹¿· + sfSetModuleDB(MODULE_ID, $objFormParam); + // javascript¼Â¹Ô + $objPage->tpl_onload = 'alert("ÅÐÏ¿´°Î»¤·¤Þ¤·¤¿¡£"); window.close();'; + } + + break; +case 'module_del': + // ÈÆÍѹàÌܤθºß¥Á¥§¥Ã¥¯ + if(sfColumnExists("dtb_payment", "memo01")){ + // ¥Ç¡¼¥¿¤Îºï½ü¥Õ¥é¥°¤ò¤¿¤Æ¤ë + $objQuery->query("UPDATE dtb_payment SET del_flg = 1 WHERE module_id = ?", array(MDL_COMBZ_ID)); + } + break; +default: + // ¥Ç¡¼¥¿¤Î¥í¡¼¥É + lfLoadData(); + break; +} + +$objPage->arrForm = $objFormParam->getFormParamList(); + +$objView->assignobj($objPage); //ÊÑ¿ô¤ò¥Æ¥ó¥×¥ì¡¼¥È¤Ë¥¢¥µ¥¤¥ó¤¹¤ë +$objView->display($objPage->tpl_mainpage); //¥Æ¥ó¥×¥ì¡¼¥È¤Î½ÐÎÏ +//------------------------------------------------------------------------------------------------------- +/* ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ */ +function lfInitParam($objFormParam) { + $objFormParam->addParam("ȯ¹Ô¼ÔID", "pubid", STEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "SPTAB_CHECK")); + $objFormParam->addParam("¥Ñ¥¹¥ï¡¼¥É", "pw", STEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "SPTAB_CHECK")); + $objFormParam->addParam("¥á¥ë¥Þ¥¬ID", "magid", STEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK", "SPTAB_CHECK")); + return $objFormParam; +} + +// ¥¨¥é¡¼¥Á¥§¥Ã¥¯¤ò¹Ô¤¦ +function lfCheckError(){ + global $objFormParam; + $arrErr = $objFormParam->checkError(); + return $arrErr; +} + +// ÅÐÏ¿¥Ç¡¼¥¿¤òÆɤ߹þ¤à +function lfLoadData(){ + global $objFormParam; + //¥Ç¡¼¥¿¤ò¼èÆÀ + $arrRet = sfGetModuleDB(MODULE_ID); + // Ãͤò¥»¥Ã¥È + $objFormParam->setParam($arrRet); +} +?> Index: /branches/beta/data/downloads/module/mdl_combz/mdl_combz.inc =================================================================== --- /branches/beta/data/downloads/module/mdl_combz/mdl_combz.inc (revision 16649) +++ /branches/beta/data/downloads/module/mdl_combz/mdl_combz.inc (revision 16649) @@ -0,0 +1,162 @@ +getHashArray(); + foreach($arrRet as $key => $val) { + $arrVal[$key] = $val; + } + $sqlval['sub_data'] = serialize($arrVal); + $objQuery->update("dtb_module", $sqlval, "module_id = ?", array($module_id)); +} + +/************************************************************************************************************** + * ´Ø¿ô̾ ¡§sfGetModuleDB + * ½èÍýÆâÍÆ ¡§É¬Íפʥǡ¼¥¿¤ò¼èÆÀ¤¹¤ë¡£ + * °ú¿ô1 ¡§ + * °ú¿ô2 ¡§ + * °ú¿ô3 ¡§ + * Ìá¤êÃÍ ¡§¼èÆÀ·ë²Ì + **************************************************************************************************************/ +// DB¤«¤é¥Ç¡¼¥¿¤ò¼èÆÀ¤¹¤ë +function sfGetModuleDB($module_id){ + $objQuery = new SC_Query(); + $arrVal = array($module_id); + $arrRet = array(); + $sql = "SELECT + sub_data + FROM dtb_module WHERE module_id = ? " . $where; + $arrRet = $objQuery->getall($sql, $arrVal); + return unserialize($arrRet[0]['sub_data']); +} +/************************************************************************************************************** + * ´Ø¿ô̾ ¡§sfCombzReserve + * ½èÍýÆâÍÆ ¡§ + * °ú¿ô1 ¡§ + * °ú¿ô2 ¡§ + * °ú¿ô3 ¡§ + * Ìá¤êÃÍ ¡§¼èÆÀ·ë²Ì + **************************************************************************************************************/ +function sfCombzReserve($where, $arrval) { + ini_set("mbstring.http_input", COMBZ_ENCODE); + ini_set("mbstring.http_output", COMBZ_ENCODE); + ini_set("default_charset", COMBZ_ENCODE); + ini_set("mbstring.internal_encoding", COMBZ_ENCODE); + + //¥Ç¡¼¥¿¤ò¼èÆÀ + $arrForm = sfGetModuleDB(MODULE_ID); + //¥Ú¡¼¥¸´ÉÍý¥¯¥é¥¹ + class LC_ReservePage { + //¥³¥ó¥¹¥È¥é¥¯¥¿ + function LC_ReservePage() { + //¥á¥¤¥ó¥Æ¥ó¥×¥ì¡¼¥È¤Î»ØÄê + $this->tpl_mainpage = MODULE_PATH . 'mdl_combz/combz_reserve.tpl'; + } + } + + $objPage = new LC_ReservePage(); + $objView = new SC_AdminView(); + $objQuery = new SC_Query(); + + $objPage->arrForm = $arrForm; + $objView->assignobj($objPage); //ÊÑ¿ô¤ò¥Æ¥ó¥×¥ì¡¼¥È¤Ë¥¢¥µ¥¤¥ó¤¹¤ë + $fetch = $objView->fetch($objPage->tpl_mainpage); //¥Æ¥ó¥×¥ì¡¼¥È¤Î½ÐÎÏ + $fetch = mb_convert_encoding($fetch, COMBZ_ENCODE); + print($fetch); +} + +/************************************************************************************************************** + * ´Ø¿ô̾ ¡§sfCombzRegist + * ½èÍýÆâÍÆ ¡§ + * °ú¿ô1 ¡§ + * °ú¿ô2 ¡§ + * °ú¿ô3 ¡§ + * Ìá¤êÃÍ ¡§¼èÆÀ·ë²Ì + **************************************************************************************************************/ +function sfCombzRegist($where, $arrval) { + ini_set("mbstring.http_input", COMBZ_ENCODE); + ini_set("mbstring.http_output", COMBZ_ENCODE); + ini_set("default_charset", COMBZ_ENCODE); + ini_set("mbstring.internal_encoding", COMBZ_ENCODE); + + //¥Ç¡¼¥¿¤ò¼èÆÀ + $arrForm = sfGetModuleDB(MODULE_ID); + + //¥Ú¡¼¥¸´ÉÍý¥¯¥é¥¹ + class LC_ReservePage { + //¥³¥ó¥¹¥È¥é¥¯¥¿ + function LC_ReservePage() { + //¥á¥¤¥ó¥Æ¥ó¥×¥ì¡¼¥È¤Î»ØÄê + $this->tpl_mainpage = MODULE_PATH . 'mdl_combz/combz_regist.tpl'; + } + } + + $objPage = new LC_ReservePage(); + $objView = new SC_AdminView(); + + $objQuery = new SC_Query(); + $arrRet = $objQuery->select("email, email_mobile", "dtb_customer", $where, $arrval); + $arrForm['set_data'] = ""; + for($i = 0; $i < count($arrRet); $i++) { + if($arrRet[$i]['email'] != "") { + $arrForm['set_data'].= $arrRet[$i]['email'] . "\n"; + } + if($arrRet[$i]['email_mobile'] != "" && $arrRet[$i]['email'] != $arrRet[$i]['email_mobile']) { + $arrForm['set_data'].= $arrRet[$i]['email_mobile'] . "\n"; + } + } + + $objPage->arrForm = $arrForm; + $objView->assignobj($objPage); //ÊÑ¿ô¤ò¥Æ¥ó¥×¥ì¡¼¥È¤Ë¥¢¥µ¥¤¥ó¤¹¤ë + $fetch = $objView->fetch($objPage->tpl_mainpage); //¥Æ¥ó¥×¥ì¡¼¥È¤Î½ÐÎÏ + $fetch = mb_convert_encoding($fetch, COMBZ_ENCODE); + print($fetch); + +} + +/************************************************************************************************************** + * ´Ø¿ô̾ ¡§sfCombzPost + * ½èÍýÆâÍÆ ¡§ + * °ú¿ô1 ¡§ + * °ú¿ô2 ¡§ + * °ú¿ô3 ¡§ + * Ìá¤êÃÍ ¡§¼èÆÀ·ë²Ì + **************************************************************************************************************/ +function sfCombzPost($combz_type, $where, $arrval) { + switch($combz_type) { + case 'reserve': + sfCombzReserve($where, $arrval); + break; + case 'regist': + sfCombzRegist($where, $arrval); + break; + default: + print("¥³¥ó¥Ó¡¼¥ºÏ¢·È¡§ÉÔÀµ¤ÊÃͤǤ¹¡£"); + break; + } + exit; +} Index: /branches/beta/data/downloads/module/mdl_combz/combz_reserve.tpl =================================================================== --- /branches/beta/data/downloads/module/mdl_combz/combz_reserve.tpl (revision 16649) +++ /branches/beta/data/downloads/module/mdl_combz/combz_reserve.tpl (revision 16649) @@ -0,0 +1,172 @@ + + + + + + + + + + + + + +ƒRƒ“ƒr[ƒY—\–ñ”­s + + + + + + +
+ + + + + + + + +
+ + + + + + + +
+ + + + + + + + + + + + + + +
+ + + + + + + + + + + + + + + +
ƒRƒ“ƒr[ƒY—\–ñ”­s
+ + + + +
+ ¦ “o˜^ŒãAƒRƒ“ƒr[ƒYŠÇ—‰æ–ʏã‚Å”­s“úŽž‚ðŽw’肵‚Ä‚­‚¾‚³‚¢B
+ ¦ ƒƒ‹ƒ}ƒKŒ–¼Aƒƒ‹ƒ}ƒK–{•¶‚Í“o˜^Œã‚ɁAC³‚·‚邱‚Æ‚ª‚Å‚«‚Ü‚·B +
+ + + + +
+ + + + + + + + + + + + + + + + + + + + + + + +
”­sŽÒID ¦ + + + +
ƒpƒXƒ[ƒh ¦ + + + +
ƒƒ‹ƒ}ƒKID ¦ + + + +
ƒƒ‹ƒ}ƒKŒ–¼ + + + +
ƒƒ‹ƒ}ƒK–{•¶
+ + + +
+ + + + + + + + + + + + + + + +
+ + + + +
+
+
+
+ +
+ +
+ + + + + + Index: /branches/beta/data/downloads/module/mdl_combz/mdl_combz.tpl =================================================================== --- /branches/beta/data/downloads/module/mdl_combz/mdl_combz.tpl (revision 16649) +++ /branches/beta/data/downloads/module/mdl_combz/mdl_combz.tpl (revision 16649) @@ -0,0 +1,157 @@ + + + + + + + + + + + + + + + + + +<!--{$tpl_subtitle}--> + + + + + +
+ + + + + + + + +
+ + + + + + + +
+ + + + + + + + + + + + + + +
+ + + + + + + + + + + + + + + +
+ + + +
+ + + + + + + + + + + + + + + + + +
¢£Combz
ȯ¹Ô¼ÔID ¢¨ + + + +
¥Ñ¥¹¥ï¡¼¥É ¢¨ + + + +
¥á¥ë¥Þ¥¬ID ¢¨ + + + +
+ + + + + + + + + + + + + + + +
+ + + + +
+
+
+
+ +
+ +
+ + + + + Index: /branches/beta/data/downloads/module/mdl_combz/combz_regist.tpl =================================================================== --- /branches/beta/data/downloads/module/mdl_combz/combz_regist.tpl (revision 16649) +++ /branches/beta/data/downloads/module/mdl_combz/combz_regist.tpl (revision 16649) @@ -0,0 +1,152 @@ + + + + + + + + + + + + + + + +ƒRƒ“ƒr[ƒYˆêŠ‡“ÇŽÒ“o˜^ + + + + + + +
+ + + + + + + + +
+ + + + + + + +
+ + + + + + + + + + + + + + +
+ + + + + + + + + + + + + + + +
ƒRƒ“ƒr[ƒYˆêŠ‡“ÇŽÒ“o˜^
+ + + + + + + + + + + + + + + + + + +
”­sŽÒID ¦ + + + +
ƒpƒXƒ[ƒh ¦ + + + +
ƒƒ‹ƒ}ƒKID ¦ + + + +
“ÇŽÒƒŠƒXƒg ¦ + + + +
+ + + + + + + + + + + + + + + +
+ + + + +
+
+
+
+ +
+ +
+ + + + + +