Index: branches/version-1/data/downloads/module/mdl_zaikorobot/mdl_zaikorobot.php =================================================================== --- branches/version-1/data/downloads/module/mdl_zaikorobot/mdl_zaikorobot.php (revision 17531) +++ branches/version-1/data/downloads/module/mdl_zaikorobot/mdl_zaikorobot.php (revision 17531) @@ -0,0 +1,111 @@ +tpl_mainpage = MODULE_PATH . 'mdl_zaikorobot/mdl_zaikorobot.tpl'; + $this->tpl_subtitle = 'zaiko robotÏ¢·È¥â¥¸¥å¡¼¥ë'; + } +} +$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) { + // ¥Ç¡¼¥¿¹¹¿· + sfZaikoSetModuleDB(MDL_ZAIKOROBOT_ID, $objFormParam); + // ·èºÑ·ë²Ì¼õÉÕ¥Õ¥¡¥¤¥ë¤Î¥³¥Ô¡¼ + copy(MODULE_PATH. "mdl_zaikorobot/hunglead_stock.php", HTML_PATH. "user_data/hunglead_stock.php"); + // ´°Î»ÄÌÃÎ + $objPage->tpl_onload = 'alert("ÅÐÏ¿´°Î»¤·¤Þ¤·¤¿¡£");window.close();'; + } + break; +default: + // ¥Ç¡¼¥¿¤Î¥í¡¼¥É + lfLoadData(); + break; +} + +$objPage->arrForm = $objFormParam->getFormParamList(); + +$objView->assignobj($objPage); +$objView->display($objPage->tpl_mainpage); + +//----------------------------------------------------------------------- + +/** + * ¥Ñ¥é¥á¡¼¥¿¾ðÊó¤Î½é´ü²½ + */ +function lfInitParam($objFormParam) { + $objFormParam->addParam("ID", "id", STEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK")); + $objFormParam->addParam("¥Ñ¥¹¥ï¡¼¥É", "pass", STEXT_LEN, "KVa", array("EXIST_CHECK", "MAX_LENGTH_CHECK")); + return $objFormParam; +} + +/** + * ¥¨¥é¡¼¥Á¥§¥Ã¥¯ + */ +function lfCheckError() { + global $objFormParam; + $arrErr = $objFormParam->checkError(); + return $arrErr; +} + +/** + * ÅÐÏ¿¥Ç¡¼¥¿¤Î¼èÆÀ + */ +function lfLoadData() { + global $objFormParam; + //¥Ç¡¼¥¿¤ò¼èÆÀ + $arrRet = sfZaikoGetModuleDB(MDL_ZAIKOROBOT_ID); + // Ãͤò¥»¥Ã¥È + $objFormParam->setParam($arrRet); +} + +?> Index: branches/version-1/data/downloads/module/mdl_zaikorobot/mdl_zaikorobot.inc =================================================================== --- branches/version-1/data/downloads/module/mdl_zaikorobot/mdl_zaikorobot.inc (revision 17531) +++ branches/version-1/data/downloads/module/mdl_zaikorobot/mdl_zaikorobot.inc (revision 17531) @@ -0,0 +1,107 @@ +getHashArray(); + foreach($arrRet as $key => $val) { + $arrVal[$key] = $val; + } + $sqlval['sub_data'] = serialize($arrVal); + $objQuery->update("dtb_module", $sqlval, "module_id = ?", array($module_id)); +} + +/** + * DB¤«¤é¥Ç¡¼¥¿¼èÆÀ + */ +function sfZaikoGetModuleDB($module_id) { + $objQuery = new SC_Query(); + $arrVal = array($module_id); + $arrRet = array(); + $sql = "SELECT sub_data + FROM dtb_module WHERE module_id = ?"; + $arrRet = $objQuery->getall($sql, $arrVal); + return unserialize($arrRet[0]['sub_data']); +} + +/** + * ID¥Á¥§¥Ã¥¯ + */ +function sfZaikoIdCheck() { + $ret = sfZaikoGetModuleDb(MDL_ZAIKOROBOT_ID); + // ǧ¾ÚÀ®¸ù + if (isset($_POST['sys_id']) && isset($_POST['sys_pass']) && + $ret['id'] == $_POST['sys_id'] && $ret['pass'] == $_POST['sys_pass']) { + return true; + // ǧ¾Ú¥¨¥é¡¼ + } else { + echo "NG\n"; + echo "auth_error"; + exit; + } +} + +/** + * ºß¸ËÄ´À° + */ +function sfZaikoUpdate() { + if (isset($_POST['product'])) { + $objQuery = new SC_Query(); + $cnt = "0"; + foreach($_POST['product'] as $key => $val) { + $table = "dtb_products_class"; + $where = "product_id = ? AND product_code = ?"; + $arrval = array(); + $arrval[] = empty($val['product_id']) ? "0" : $val['product_id']; + $arrval[] = empty($val['product_code']) ? "0" : $val['product_code']; + // ºß¸Ë¹¹¿· + if (sfDataExists($table, $where, $arrval) === true) { + $sqlval['stock'] = empty($val['stock']) ? "0" : $val['stock']; + $objQuery->update($table, $sqlval, $where, $arrval); + // ¾¦ÉÊ¥¨¥é¡¼ + } else { + $cnt++; + if ($cnt == "1") $mes = "NG\n"; + $mes .= "no_product(product_id=". $arrval[0]. ",product_code=". $arrval[1]. ")\n"; + } + } + // À®¸ù + if ($cnt == "0") { + $mes = "OK"; + } + // ¥¯¥¨¥ê¡¼¥¨¥é¡¼ + } else { + $mes = "NG\n". "no_query"; + } + echo $mes; + exit; +} + +?> Index: branches/version-1/data/downloads/module/mdl_zaikorobot/mdl_zaikorobot.tpl =================================================================== --- branches/version-1/data/downloads/module/mdl_zaikorobot/mdl_zaikorobot.tpl (revision 17531) +++ branches/version-1/data/downloads/module/mdl_zaikorobot/mdl_zaikorobot.tpl (revision 17531) @@ -0,0 +1,168 @@ + + + + + + + + + + + + + + + +<!--{$tpl_subtitle}--> + + + + + + +
+ + + + + + + + +
+ + + + + + + +
+ + + + + + + + + + + + + + +
+ + + + + + + + + + + + + + + +
+ + + + + +
+ zaiko robotϢư¥â¥¸¥å¡¼¥ë¤ò¤´ÍøÍÑĺ¤¯¤Ë¤Ï¡¢¥æ¡¼¥¶Íͤ´¼«¿È¤Ç¥Ï¥ó¥°¥ê¡¼¥É³ô¼°²ñ¼Ò¤È¤´·ÀÌóĺ¤¯É¬Íפ¬¤¢¤ê¤Þ¤¹¡£
+ ¤ª¿½¤·¹þ¤ß¤Ë¤Ä¤­¤Þ¤·¤Æ¤Ï¡¢²¼µ­¤Î¥Ú¡¼¥¸¤è¤ê¤ªÌ䤤¹ç¤ï¤»²¼¤µ¤¤¡£

+ ¡ä¡ä¥Ï¥ó¥°¥ê¡¼¥É³ô¼°²ñ¼Ò +
+ + +
+ + + + + + + + + + +
ID¢¨ + + + +
¥Ñ¥¹¥ï¡¼¥É¢¨ + + + +
+ + + + + + + + + + + + + + + +
+ + + + +
+
+
+
+ +
+ +
+ + + Index: branches/version-1/data/downloads/module/mdl_zaikorobot/hunglead_stock.php =================================================================== --- branches/version-1/data/downloads/module/mdl_zaikorobot/hunglead_stock.php (revision 17531) +++ branches/version-1/data/downloads/module/mdl_zaikorobot/hunglead_stock.php (revision 17531) @@ -0,0 +1,34 @@ +