# MyVendor\BeMart

BeMart page resources generated from BEAR.Sunday source, ALPS vocabulary, and available fake data fixtures.

## Routes (147)

| HTTP Route | Methods | Resource |
|------------|---------|----------|
| /action-redirect | GET, POST | Page/ActionRedirect |
| /cart | GET | Page/Cart |
| /contact | GET, POST | Page/Contact |
| /entry | GET, POST | Page/Entry |
| /forgot-complete | GET | Page/ForgotComplete |
| /forgot-password | GET, POST | Page/ForgotPassword |
| /index | GET | Page/Index |
| /login | GET, POST | Page/Login |
| /logout | POST | Page/Logout |
| /mypage | GET | Page/Mypage |
| /product | GET | Page/Product |
| /products | GET | Page/Products |
| /reset | GET, POST | Page/Reset |
| /shopping | GET | Page/Shopping |
| /unsupported-route | GET, POST | Page/UnsupportedRoute |
| /admin/action-redirect | GET, POST | Page/Admin/ActionRedirect |
| /admin/authority-role | GET, POST | Page/Admin/AuthorityRole |
| /admin/base-info | GET, POST | Page/Admin/BaseInfo |
| /admin/calendar | GET, POST, DELETE | Page/Admin/Calendar |
| /admin/change-password | GET, POST | Page/Admin/ChangePassword |
| /admin/create-customer | POST | Page/Admin/CreateCustomer |
| /admin/csv-config | GET, POST | Page/Admin/CsvConfig |
| /admin/customer | GET, POST | Page/Admin/Customer |
| /admin/customer-csv | GET | Page/Admin/CustomerCsv |
| /admin/customer-delivery-edit | GET, POST, DELETE | Page/Admin/CustomerDeliveryEdit |
| /admin/customer-list | GET | Page/Admin/CustomerList |
| /admin/delete-customer | POST | Page/Admin/DeleteCustomer |
| /admin/empty-page | GET | Page/Admin/EmptyPage |
| /admin/index | GET | Page/Admin/Index |
| /admin/log | GET | Page/Admin/Log |
| /admin/login | GET, POST | Page/Admin/Login |
| /admin/login-history | GET | Page/Admin/LoginHistory |
| /admin/logout | POST | Page/Admin/Logout |
| /admin/mail-template | GET, POST, DELETE | Page/Admin/MailTemplate |
| /admin/master-data | GET, PUT | Page/Admin/MasterData |
| /admin/master-data-edit | PUT | Page/Admin/MasterDataEdit |
| /admin/member | GET, POST, PUT, DELETE | Page/Admin/Member |
| /admin/member-list | GET | Page/Admin/MemberList |
| /admin/order | GET, PUT | Page/Admin/Order |
| /admin/order-list | GET | Page/Admin/OrderList |
| /admin/order-status | GET, PUT, POST | Page/Admin/OrderStatus |
| /admin/plugin | DELETE | Page/Admin/Plugin |
| /admin/plugin-disable | POST | Page/Admin/PluginDisable |
| /admin/plugin-enable | POST | Page/Admin/PluginEnable |
| /admin/plugin-list | GET, POST | Page/Admin/PluginList |
| /admin/product | GET, POST, PUT, DELETE | Page/Admin/Product |
| /admin/product-bulk-status | POST | Page/Admin/ProductBulkStatus |
| /admin/product-copy | POST | Page/Admin/ProductCopy |
| /admin/product-csv | GET, POST | Page/Admin/ProductCsv |
| /admin/product-list | GET | Page/Admin/ProductList |
| /admin/product-new | GET | Page/Admin/ProductNew |
| /admin/security | GET, PUT | Page/Admin/Security |
| /admin/sort-no-move | PUT | Page/Admin/SortNoMove |
| /admin/system | GET | Page/Admin/System |
| /admin/toggle-visible | PUT | Page/Admin/ToggleVisible |
| /admin/trade-law | GET, POST | Page/Admin/TradeLaw |
| /admin/two-factor-auth | GET, POST | Page/Admin/TwoFactorAuth |
| /admin/two-factor-auth-edit | GET | Page/Admin/TwoFactorAuthEdit |
| /admin/two-factor-auth-set | GET, PUT | Page/Admin/TwoFactorAuthSet |
| /admin/unsupported-route | GET, POST | Page/Admin/UnsupportedRoute |
| /cart/item | POST, PUT, DELETE | Page/Cart/Item |
| /contact/complete | GET | Page/Contact/Complete |
| /contact/confirm | GET | Page/Contact/Confirm |
| /entry/activate | GET, POST | Page/Entry/Activate |
| /entry/complete | GET | Page/Entry/Complete |
| /entry/confirm | GET | Page/Entry/Confirm |
| /help/about | GET | Page/Help/About |
| /help/agreement | GET | Page/Help/Agreement |
| /help/guide | GET | Page/Help/Guide |
| /help/privacy | GET | Page/Help/Privacy |
| /help/trade-law | GET | Page/Help/TradeLaw |
| /mypage/address | GET, PUT, DELETE | Page/Mypage/Address |
| /mypage/address-list | GET, POST | Page/Mypage/AddressList |
| /mypage/change | GET, POST | Page/Mypage/Change |
| /mypage/change-complete | GET | Page/Mypage/ChangeComplete |
| /mypage/favorite | POST, DELETE | Page/Mypage/Favorite |
| /mypage/favorite-list | GET | Page/Mypage/FavoriteList |
| /mypage/history | GET | Page/Mypage/History |
| /mypage/order-history | GET | Page/Mypage/OrderHistory |
| /mypage/reorder | POST | Page/Mypage/Reorder |
| /mypage/withdraw | GET, POST | Page/Mypage/Withdraw |
| /mypage/withdraw-complete | GET | Page/Mypage/WithdrawComplete |
| /mypage/withdraw-confirm | GET | Page/Mypage/WithdrawConfirm |
| /shopping/checkout | POST | Page/Shopping/Checkout |
| /shopping/complete | GET | Page/Shopping/Complete |
| /shopping/confirm | GET, POST | Page/Shopping/Confirm |
| /shopping/error | GET | Page/Shopping/Error |
| /shopping/login | GET | Page/Shopping/Login |
| /shopping/non-member | GET, POST | Page/Shopping/NonMember |
| /shopping/shipping | GET, POST | Page/Shopping/Shipping |
| /shopping/shipping-edit | GET, POST | Page/Shopping/ShippingEdit |
| /shopping/shipping-multiple | GET, POST | Page/Shopping/ShippingMultiple |
| /shopping/shipping-multiple-edit | GET, POST | Page/Shopping/ShippingMultipleEdit |
| /admin/block/block | GET, PUT, DELETE | Page/Admin/Block/Block |
| /admin/block/block-list | GET, POST | Page/Admin/Block/BlockList |
| /admin/category/category | GET, PUT, DELETE | Page/Admin/Category/Category |
| /admin/category/category-list | GET, POST | Page/Admin/Category/CategoryList |
| /admin/category/csv | GET, POST | Page/Admin/Category/Csv |
| /admin/category/edit | GET | Page/Admin/Category/Edit |
| /admin/class-category/class-category | PUT, DELETE | Page/Admin/ClassCategory/ClassCategory |
| /admin/class-category/class-category-export | GET | Page/Admin/ClassCategory/ClassCategoryExport |
| /admin/class-category/class-category-list | GET, POST | Page/Admin/ClassCategory/ClassCategoryList |
| /admin/class-name/class-name | PUT, DELETE | Page/Admin/ClassName/ClassName |
| /admin/class-name/class-name-export | GET | Page/Admin/ClassName/ClassNameExport |
| /admin/class-name/class-name-list | GET, POST | Page/Admin/ClassName/ClassNameList |
| /admin/content/cache | GET, PUT | Page/Admin/Content/Cache |
| /admin/content/css | GET, PUT | Page/Admin/Content/Css |
| /admin/content/file-manager | GET | Page/Admin/Content/FileManager |
| /admin/content/js | GET, PUT | Page/Admin/Content/Js |
| /admin/content/maintenance | GET, PUT | Page/Admin/Content/Maintenance |
| /admin/customer/resend-activation-mail | POST | Page/Admin/Customer/ResendActivationMail |
| /admin/delivery/delivery | GET, PUT, DELETE | Page/Admin/Delivery/Delivery |
| /admin/delivery/delivery-list | GET, POST | Page/Admin/Delivery/DeliveryList |
| /admin/layout/layout | GET, PUT | Page/Admin/Layout/Layout |
| /admin/layout/layout-list | GET | Page/Admin/Layout/LayoutList |
| /admin/mail-template/create | POST | Page/Admin/MailTemplate/Create |
| /admin/news/news | GET, PUT, DELETE | Page/Admin/News/News |
| /admin/news/news-list | GET, POST | Page/Admin/News/NewsList |
| /admin/order/bulk-delete | POST | Page/Admin/Order/BulkDelete |
| /admin/order/create | POST | Page/Admin/Order/Create |
| /admin/order/edit | GET | Page/Admin/Order/Edit |
| /admin/order/export-order | GET | Page/Admin/Order/ExportOrder |
| /admin/order/export-order-pdf | GET, POST | Page/Admin/Order/ExportOrderPdf |
| /admin/order/export-shipping | GET | Page/Admin/Order/ExportShipping |
| /admin/order/import-shipping | GET, POST | Page/Admin/Order/ImportShipping |
| /admin/order/mail-confirm | GET | Page/Admin/Order/MailConfirm |
| /admin/order/order-pdf | GET | Page/Admin/Order/OrderPdf |
| /admin/order/send-mail | GET, POST | Page/Admin/Order/SendMail |
| /admin/order/shipping-address | GET, POST, PUT | Page/Admin/Order/ShippingAddress |
| /admin/order/shipping-notify-mail | GET, POST | Page/Admin/Order/ShippingNotifyMail |
| /admin/order/tracking-number | PUT | Page/Admin/Order/TrackingNumber |
| /admin/page/page | GET, PUT, DELETE | Page/Admin/Page/Page |
| /admin/page/page-list | GET, POST | Page/Admin/Page/PageList |
| /admin/payment/payment | GET, PUT, DELETE | Page/Admin/Payment/Payment |
| /admin/payment/payment-list | GET, POST | Page/Admin/Payment/PaymentList |
| /admin/product/csv-category | GET | Page/Admin/Product/CsvCategory |
| /admin/product/csv-class-category | GET, POST | Page/Admin/Product/CsvClassCategory |
| /admin/product/csv-class-name | GET, POST | Page/Admin/Product/CsvClassName |
| /admin/product/csv-product | GET | Page/Admin/Product/CsvProduct |
| /admin/product/edit | GET | Page/Admin/Product/Edit |
| /admin/product/product-class | GET, POST | Page/Admin/Product/ProductClass |
| /admin/tag/tag | DELETE | Page/Admin/Tag/Tag |
| /admin/tag/tag-list | GET, POST | Page/Admin/Tag/TagList |
| /admin/tax-rule/tax-rule | DELETE | Page/Admin/TaxRule/TaxRule |
| /admin/tax-rule/tax-rule-list | GET, POST | Page/Admin/TaxRule/TaxRuleList |
| /admin/template/template-add | GET, POST | Page/Admin/Template/TemplateAdd |
| /admin/template/template-list | GET, PUT, DELETE, POST | Page/Admin/Template/TemplateList |

## ResourceObjects (147)

### Page/ActionRedirect
`/action-redirect`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | returnTo | - |
| POST | returnTo | - |

### Page/Cart
`/cart`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | sessionPrefix | href(doAddCartItem), href(goCheckoutEntry) |

### Page/Contact
`/contact`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doSubmitContact) |
| POST | contactName01, contactName02, contactEmail, contactContents, mode | href(goTop) |

### Page/Entry
`/entry`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goCustomerRegistrationConfirm), href(doRegisterCustomer) |
| POST | email, password, name01, name02, kana01, kana02, companyName, phoneNumber, postalCode, pref, addr01, addr02, birth, sex, job, email_confirm, password_confirm, birth_year, birth_month, birth_day, user_policy_check, mode | href(goTop) |

### Page/ForgotComplete
`/forgot-complete`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goLogin), href(goTop) |

### Page/ForgotPassword
`/forgot-password`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doRequestPasswordReset), href(goLogin) |
| POST | email* | href(goLogin) |

### Page/Index
`/index`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goProductList), href(goCart), href(goContactForm), href(goCustomerRegistration), href(goLogin), href(goMypage), href(goHelpAbout), href(goHelpGuide), href(goHelpAgreement), href(goHelpPrivacy), href(goHelpTradeLaw) |

### Page/Login
`/login`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doLogin), href(goCustomerRegistration), href(doRequestPasswordReset) |
| POST | email, password, mode | href(goMypage) |

### Page/Logout
`/logout`

| Method | Parameters | Links |
|--------|------------|-------|
| POST | - | href(goTop) |

### Page/Mypage
`/mypage`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | orderLimit | href(goOrderHistory), href(goMypageHistory), href(goMypageChange), href(goCustomerAddressList), href(goFavoriteList), href(goMypageWithdraw), href(goCart), href(goProductList), href(doAddFavorite), href(doRemoveFavorite) |

### Page/Product
`/product`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | productCode* | href(goProductList), href(doAddCartItem), href(doAddFavorite), href(doRemoveFavorite) |

### Page/Products
`/products`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | name, nameKeyword, limit, offset, category_id, pageno, disp_number, orderby | href(goProduct), href(goCart), href(goTop), src(productSource) |

### Page/Reset
`/reset`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | resetKey | href(doResetPassword), href(goLogin) |
| POST | resetKey*, password* | href(goLogin) |

### Page/Shopping
`/shopping`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | sessionPrefix | href(doConfirmOrder), href(goCart) |

### Page/UnsupportedRoute
`/unsupported-route`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | routeName | - |
| POST | routeName, returnTo | - |

### Page/Admin/ActionRedirect
`/admin/action-redirect`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | returnTo | - |
| POST | returnTo | - |

### Page/Admin/AuthorityRole
`/admin/authority-role`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doUpdateAuthorityRole), href(goMemberList) |
| POST | loginId, authority, AuthorityRoles | href(goMember), href(goMemberList), href(goLoginHistoryList) |

### Page/Admin/BaseInfo
`/admin/base-info`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doUpdateBaseInfo), href(goPaymentList), href(goProductList), href(goOrderList) |
| POST | shopName*, shopKana, shopNameEng, companyName, postalCode, pref, addr01, addr02, phoneNumber, businessHour, shopEmail01, shopMessage | href(goTop), href(goPaymentList) |

### Page/Admin/Calendar
`/admin/calendar`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doCreateCalendarHoliday), href(doUpdateCalendar), href(doDeleteCalendarHoliday) |
| POST | operation, title, holiday, calendarId | href(goCalendar) |
| DELETE | calendarId | href(goCalendar) |

### Page/Admin/ChangePassword
`/admin/change-password`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goAdminHome) |
| POST | currentPassword*, changePasswordFirst*, changePasswordSecond* | href(goAdminHome) |

### Page/Admin/CreateCustomer
`/admin/create-customer`

| Method | Parameters | Links |
|--------|------------|-------|
| POST | email*, password*, name01*, name02*, kana01, kana02, companyName, phoneNumber, postalCode, pref, addr01, addr02, birth, sex, job | href(goCustomer) |

### Page/Admin/CsvConfig
`/admin/csv-config`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | csvType | href(doUpdateCsv) |
| POST | csvType*, columns, csvOutput, csvNotOutput | href(goTop), href(goExportProduct) |

### Page/Admin/Customer
`/admin/customer`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | email, customerId, id | href(goCustomerList), href(doUpdateCustomerProfile) |
| POST | customerId*, email*, name01*, name02*, kana01, kana02, companyName, phoneNumber, postalCode, pref, addr01, addr02, birth, sex, job, password | href(goCustomer) |

### Page/Admin/CustomerCsv
`/admin/customer-csv`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goCustomerList), href(goExportClassName) |

### Page/Admin/CustomerDeliveryEdit
`/admin/customer-delivery-edit`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | customerId, id | href(goCustomerList), href(doCreateCustomerDeliveryAddress), href(doUpdateCustomerDeliveryAddress), href(doDeleteCustomerDeliveryAddress) |
| POST | customerId*, name01*, name02*, postalCode*, pref*, addr01*, addr02*, phoneNumber*, addressId, kana01, kana02, companyName | href(goCustomer), href(goCustomerList) |
| DELETE | customerId*, addressId* | href(goCustomer), href(goCustomerList) |

### Page/Admin/CustomerList
`/admin/customer-list`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | nameKeyword, emailKeyword, limit | href(goCustomer), href(doCreateCustomer), href(doDeleteCustomer), href(doResendActivationMail) |

### Page/Admin/DeleteCustomer
`/admin/delete-customer`

| Method | Parameters | Links |
|--------|------------|-------|
| POST | customerId* | href(goCustomerList) |

### Page/Admin/EmptyPage
`/admin/empty-page`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | - |

### Page/Admin/Index
`/admin/index`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goMemberList), href(goContentCache), href(doAdminLogout) |

### Page/Admin/Log
`/admin/log`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | - |

### Page/Admin/Login
`/admin/login`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doAdminLogin) |
| POST | loginId, password, mode | href(goAdminTop) |

### Page/Admin/LoginHistory
`/admin/login-history`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | limit | href(goSecurity), href(goMemberList) |

### Page/Admin/Logout
`/admin/logout`

| Method | Parameters | Links |
|--------|------------|-------|
| POST | - | href(goAdminLogin) |

### Page/Admin/MailTemplate
`/admin/mail-template`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | mailTemplateId | href(doCreateMailTemplate), href(doUpdateMailTemplate), href(doDeleteMailTemplate), href(goOrderMail), href(goPaymentList), href(goOrderList) |
| POST | mailTemplateId*, mailSubject, mail_subject | href(goTop), href(goOrderMail), href(doDeleteMailTemplate) |
| DELETE | mailTemplateId* | href(goMailTemplateList) |

### Page/Admin/MasterData
`/admin/master-data`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | masterType | href(doSelectMasterData) |
| PUT | masterType | href(doUpdateMasterData) |

### Page/Admin/MasterDataEdit
`/admin/master-data-edit`

| Method | Parameters | Links |
|--------|------------|-------|
| PUT | masterType*, rows | href(goMasterData) |

### Page/Admin/Member
`/admin/member`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | loginId | href(goMemberList), href(doUpdateMember), href(doDeleteMember) |
| POST | loginId*, password*, name*, authority*, passwordConfirm, mode | href(goMember) |
| PUT | loginId*, name, mode | href(goMember) |
| DELETE | loginId*, mode | href(goMemberList) |

### Page/Admin/MemberList
`/admin/member-list`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | nameKeyword, limit, offset | href(goMember), href(doCreateMember), href(doUpdateMember), href(doDeleteMember), href(doUpdateAuthorityRole) |

### Page/Admin/Order
`/admin/order`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | orderNo* | href(goOrderList), href(doUpdateOrder), href(doUpdateOrderStatus), href(goOrderShippingAddress) |
| PUT | orderNo*, discount, charge, usePoint | href(goOrder), href(doUpdateOrderStatus) |

### Page/Admin/OrderList
`/admin/order-list`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | limit, offset | href(goOrder), href(doCreateOrder) |

### Page/Admin/OrderStatus
`/admin/order-status`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | - |
| PUT | orderStatuses, orderStatusRows | - |
| POST | orderNo*, orderStatus* | href(goOrder), href(goOrderList), href(goOrderShippingAddress) |

### Page/Admin/Plugin
`/admin/plugin`

| Method | Parameters | Links |
|--------|------------|-------|
| DELETE | pluginCode* | href(goPluginList) |

### Page/Admin/PluginDisable
`/admin/plugin-disable`

| Method | Parameters | Links |
|--------|------------|-------|
| POST | pluginCode* | href(goPluginList) |

### Page/Admin/PluginEnable
`/admin/plugin-enable`

| Method | Parameters | Links |
|--------|------------|-------|
| POST | pluginCode* | href(goPluginList) |

### Page/Admin/PluginList
`/admin/plugin-list`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doEnablePlugin), href(doDisablePlugin), href(doUninstallPlugin) |
| POST | pluginCode*, pluginName*, pluginVersion* | href(goPluginList) |

### Page/Admin/Product
`/admin/product`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | productCode* | href(goProductList), href(doUpdateProduct), href(doDeleteProduct), href(doCopyProduct) |
| POST | productCode*, productName*, price02*, stock, productStatus, description, searchWord, note | - |
| PUT | productCode*, productName, price02, stock, productStatus, description, searchWord, note | href(goProductList) |
| DELETE | productCode* | - |

### Page/Admin/ProductBulkStatus
`/admin/product-bulk-status`

| Method | Parameters | Links |
|--------|------------|-------|
| POST | productCodes*, productStatus* | href(goProductList) |

### Page/Admin/ProductCopy
`/admin/product-copy`

| Method | Parameters | Links |
|--------|------------|-------|
| POST | productCode*, newProductCode* | href(goProduct), href(goProductList) |

### Page/Admin/ProductCsv
`/admin/product-csv`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goProductList), href(doImportProductCsv), href(goExportCategory) |
| POST | csv* | href(goExportCategory) |

### Page/Admin/ProductList
`/admin/product-list`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | nameKeyword, limit, offset | href(goProduct), href(doCreateProduct), href(doBulkUpdateProductStatus), href(goExportProduct) |

### Page/Admin/ProductNew
`/admin/product-new`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doCreateProduct), href(goProductList) |

### Page/Admin/Security
`/admin/security`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doUpdateSecurity) |
| PUT | adminAllowHosts, adminDenyHosts, frontAllowHosts, frontDenyHosts, trustedHosts | href(goTwoFactorAuthSet) |

### Page/Admin/SortNoMove
`/admin/sort-no-move`

| Method | Parameters | Links |
|--------|------------|-------|
| PUT | masterType*, rowId*, sortNo* | - |

### Page/Admin/System
`/admin/system`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doAdminLogout) |

### Page/Admin/ToggleVisible
`/admin/toggle-visible`

| Method | Parameters | Links |
|--------|------------|-------|
| PUT | masterType*, rowId*, visible* | - |

### Page/Admin/TradeLaw
`/admin/trade-law`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doUpdateTradeLaw) |
| POST | tradeLawBody, mode, trade_law_1_name, trade_law_1_description, trade_law_1_displayOrderScreen, trade_law_2_name, trade_law_2_description, trade_law_2_displayOrderScreen, trade_law_3_name, trade_law_3_description, trade_law_3_displayOrderScreen, trade_law_4_name, trade_law_4_description, trade_law_4_displayOrderScreen, trade_law_5_name, trade_law_5_description, trade_law_5_displayOrderScreen, trade_law_6_name, trade_law_6_description, trade_law_6_displayOrderScreen | href(goTop), href(goContentCss) |

### Page/Admin/TwoFactorAuth
`/admin/two-factor-auth`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doVerifyTwoFactorAuth), href(goAdminLogin) |
| POST | deviceToken*, loginId, mode | href(goContentCache), href(goAdminHome) |

### Page/Admin/TwoFactorAuthEdit
`/admin/two-factor-auth-edit`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | - |

### Page/Admin/TwoFactorAuthSet
`/admin/two-factor-auth-set`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doSetTwoFactorAuth), href(goAdminLogin) |
| PUT | deviceToken*, loginId, authKey, mode | href(goTwoFactorAuth), href(goAdminHome) |

### Page/Admin/UnsupportedRoute
`/admin/unsupported-route`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | routeName | - |
| POST | routeName, returnTo | - |

### Page/Cart/Item
`/cart/item`

| Method | Parameters | Links |
|--------|------------|-------|
| POST | productCode*, quantity, sessionPrefix, operation | href(goCart), href(doRemoveCartItem), href(goCheckoutEntry) |
| PUT | productCode*, quantity*, sessionPrefix | href(goCart) |
| DELETE | productCode*, sessionPrefix | href(goCart) |

### Page/Contact/Complete
`/contact/complete`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | ticketId | href(goTop) |

### Page/Contact/Confirm
`/contact/confirm`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doSubmitContact), href(goTop) |

### Page/Entry/Activate
`/entry/activate`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goTop) |
| POST | secretKey* | href(goLogin) |

### Page/Entry/Complete
`/entry/complete`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goTop) |

### Page/Entry/Confirm
`/entry/confirm`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doRegisterCustomer), href(goTop) |

### Page/Help/About
`/help/about`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goTop) |

### Page/Help/Agreement
`/help/agreement`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goTop) |

### Page/Help/Guide
`/help/guide`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goTop) |

### Page/Help/Privacy
`/help/privacy`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goTop) |

### Page/Help/TradeLaw
`/help/trade-law`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goTop) |

### Page/Mypage/Address
`/mypage/address`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | addressId | href(doCreateCustomerAddress), href(doUpdateCustomerAddress), href(goCustomerAddressList) |
| PUT | addressId*, name01, name02, kana01, kana02, companyName, postalCode, pref, addr01, addr02, phoneNumber | href(goCustomerAddressList) |
| DELETE | addressId* | href(goFavoriteList), href(goCustomerAddressList) |

### Page/Mypage/AddressList
`/mypage/address-list`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doCreateCustomerAddress), href(doUpdateCustomerAddress), href(doDeleteCustomerAddress), href(goMypage) |
| POST | name01*, name02*, postalCode*, pref*, addr01*, addr02*, phoneNumber*, kana01, kana02, companyName | href(goCustomerAddressList) |

### Page/Mypage/Change
`/mypage/change`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doUpdateCustomer), href(goMypage) |
| POST | email*, name01, name02, kana01, kana02, companyName, phoneNumber, postalCode, pref, addr01, addr02 | href(goMypageChangeComplete), href(goMypage) |

### Page/Mypage/ChangeComplete
`/mypage/change-complete`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goTop), href(goCustomerAddressList), href(goMypage) |

### Page/Mypage/Favorite
`/mypage/favorite`

| Method | Parameters | Links |
|--------|------------|-------|
| POST | productCode* | href(doRemoveFavorite), href(goProduct) |
| DELETE | productCode* | href(goMypageWithdraw), href(goMypage) |

### Page/Mypage/FavoriteList
`/mypage/favorite-list`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doAddFavorite), href(doRemoveFavorite), href(goMypage) |

### Page/Mypage/History
`/mypage/history`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | orderNo* | href(doReorder), href(goMypage) |

### Page/Mypage/OrderHistory
`/mypage/order-history`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | historyLimit, offset | href(goMypageHistory), href(goMypage) |

### Page/Mypage/Reorder
`/mypage/reorder`

| Method | Parameters | Links |
|--------|------------|-------|
| POST | orderNo* | href(goCart) |

### Page/Mypage/Withdraw
`/mypage/withdraw`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doWithdrawCustomer) |
| POST | - | href(goMypageWithdrawComplete), href(goTop) |

### Page/Mypage/WithdrawComplete
`/mypage/withdraw-complete`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goTop) |

### Page/Mypage/WithdrawConfirm
`/mypage/withdraw-confirm`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doWithdrawCustomer), href(goMypage) |

### Page/Shopping/Checkout
`/shopping/checkout`

| Method | Parameters | Links |
|--------|------------|-------|
| POST | preOrderId* | href(goTop), href(goCart) |

### Page/Shopping/Complete
`/shopping/complete`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | orderNo | href(goTop), href(goCart), href(goMypage), src(orderSource) |

### Page/Shopping/Confirm
`/shopping/confirm`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | preOrderId, paymentMethodId | href(doCheckout), href(goShoppingError) |
| POST | preOrderId*, payment | href(doCheckout), href(goShoppingError) |

### Page/Shopping/Error
`/shopping/error`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goCart) |

### Page/Shopping/Login
`/shopping/login`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doLogin), href(goCustomerRegistration), href(goShoppingNonMember) |

### Page/Shopping/NonMember
`/shopping/non-member`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doSubmitNonMember), href(goCart) |
| POST | name01, name02, kana01, kana02, email, phoneNumber, postalCode, pref, addr01, addr02, sessionPrefix | href(doConfirmOrder), href(goShopping) |

### Page/Shopping/Shipping
`/shopping/shipping`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doSelectShippingAddress), href(goShoppingShippingEdit), href(goShoppingShippingMultiple) |
| POST | shippingAddressId | href(goShopping) |

### Page/Shopping/ShippingEdit
`/shopping/shipping-edit`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doUpdateShippingAddress), href(goShoppingShipping) |
| POST | name01, name02, kana01, kana02, companyName, postalCode, pref, addr01, addr02, phoneNumber | href(goShopping) |

### Page/Shopping/ShippingMultiple
`/shopping/shipping-multiple`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goShopping), href(goShoppingShipping) |
| POST | allocations | href(goShopping) |

### Page/Shopping/ShippingMultipleEdit
`/shopping/shipping-multiple-edit`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doAddMultipleShippingAddress), href(goShoppingShippingMultiple) |
| POST | name01, name02, kana01, kana02, companyName, postalCode, pref, addr01, addr02, phoneNumber | href(goShoppingShippingMultiple) |

### Page/Admin/Block/Block
`/admin/block/block`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | blockId | href(goBlockList), href(doUpdateBlock), href(doDeleteBlock) |
| PUT | blockId*, blockName, blockFileName | href(goBlockList) |
| DELETE | blockId* | href(goBlockList), href(goLayoutList) |

### Page/Admin/Block/BlockList
`/admin/block/block-list`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doCreateBlock) |
| POST | blockName*, blockFileName* | href(goBlockList) |

### Page/Admin/Category/Category
`/admin/category/category`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | categoryId* | href(goCategoryList), href(doUpdateCategory), href(doDeleteCategory) |
| PUT | categoryId*, categoryName, sortNo, parentId | href(goCategory) |
| DELETE | categoryId* | href(goCategoryList) |

### Page/Admin/Category/CategoryList
`/admin/category/category-list`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doCreateCategory), href(goCategory), href(doUpdateCategory), href(doDeleteCategory), href(doImportCategoryCsv), href(goExportCategory) |
| POST | categoryName*, sortNo*, parentId | href(goCategoryList) |

### Page/Admin/Category/Csv
`/admin/category/csv`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goCategoryList), href(doImportCategoryCsv) |
| POST | csv* | href(goCategoryList), href(goExportOrder) |

### Page/Admin/Category/Edit
`/admin/category/edit`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | categoryId | href(doCreateCategory), href(doUpdateCategory), href(goCategoryList) |

### Page/Admin/ClassCategory/ClassCategory
`/admin/class-category/class-category`

| Method | Parameters | Links |
|--------|------------|-------|
| PUT | classCategoryId*, classCategoryName | href(goClassCategoryList) |
| DELETE | classCategoryId* | href(goClassCategoryList) |

### Page/Admin/ClassCategory/ClassCategoryExport
`/admin/class-category/class-category-export`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | classNameId | href(doImportClassCategoryCsv) |

### Page/Admin/ClassCategory/ClassCategoryList
`/admin/class-category/class-category-list`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | classNameId | href(doCreateClassCategory), href(doUpdateClassCategory), href(doDeleteClassCategory), href(goClassNameList) |
| POST | classNameId*, classCategoryName* | href(goClassCategoryList) |

### Page/Admin/ClassName/ClassName
`/admin/class-name/class-name`

| Method | Parameters | Links |
|--------|------------|-------|
| PUT | classNameId*, classNameLabel | href(goClassNameList) |
| DELETE | classNameId* | href(goClassNameList) |

### Page/Admin/ClassName/ClassNameExport
`/admin/class-name/class-name-export`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doImportClassNameCsv) |

### Page/Admin/ClassName/ClassNameList
`/admin/class-name/class-name-list`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doCreateClassName), href(doUpdateClassName), href(doDeleteClassName), href(goClassCategoryList) |
| POST | classNameLabel* | href(goClassNameList) |

### Page/Admin/Content/Cache
`/admin/content/cache`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doClearCache) |
| PUT | mode | href(goMaintenance) |

### Page/Admin/Content/Css
`/admin/content/css`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doUpdateContentCss) |
| PUT | css, mode | href(goContentJs) |

### Page/Admin/Content/FileManager
`/admin/content/file-manager`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | - |

### Page/Admin/Content/Js
`/admin/content/js`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doUpdateContentJs) |
| PUT | js, mode | - |

### Page/Admin/Content/Maintenance
`/admin/content/maintenance`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doToggleMaintenance) |
| PUT | enabled*, mode | href(goSystemInfo) |

### Page/Admin/Customer/ResendActivationMail
`/admin/customer/resend-activation-mail`

| Method | Parameters | Links |
|--------|------------|-------|
| POST | email* | href(goCustomer) |

### Page/Admin/Delivery/Delivery
`/admin/delivery/delivery`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | deliveryId | href(doUpdateDelivery) |
| PUT | deliveryId*, deliveryName, visible | href(goDeliveryList) |
| DELETE | deliveryId* | href(goDeliveryList), href(goTaxRuleList) |

### Page/Admin/Delivery/DeliveryList
`/admin/delivery/delivery-list`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doCreateDelivery), href(goDelivery), href(doUpdateDelivery), href(doDeleteDelivery) |
| POST | deliveryName*, visible | href(goDeliveryList) |

### Page/Admin/Layout/Layout
`/admin/layout/layout`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | layoutId | href(goLayoutList), href(doUpdateLayout) |
| PUT | layoutId*, layoutName, name | href(goLayoutList), href(goTradeLawList) |

### Page/Admin/Layout/LayoutList
`/admin/layout/layout-list`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goLayout), href(doUpdateLayout) |

### Page/Admin/MailTemplate/Create
`/admin/mail-template/create`

| Method | Parameters | Links |
|--------|------------|-------|
| POST | mailTemplateName*, fileName*, mailSubject* | href(goMailTemplateList), href(doUpdateMailTemplate), href(doDeleteMailTemplate) |

### Page/Admin/News/News
`/admin/news/news`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | newsId | href(goNewsList) |
| PUT | newsId*, newsTitle, newsDescription, newsUrl, publishDate, linkMethod | href(goNews) |
| DELETE | newsId* | href(goNewsList), href(goPageList) |

### Page/Admin/News/NewsList
`/admin/news/news-list`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doCreateNews), href(goNews), href(doUpdateNews), href(doDeleteNews) |
| POST | newsTitle*, publishDate*, newsDescription, newsUrl, linkMethod | href(goNewsList) |

### Page/Admin/Order/BulkDelete
`/admin/order/bulk-delete`

| Method | Parameters | Links |
|--------|------------|-------|
| POST | orderNos, ids, mode | href(goOrderList) |

### Page/Admin/Order/Create
`/admin/order/create`

| Method | Parameters | Links |
|--------|------------|-------|
| POST | customerId*, paymentMethodId*, orderItems*, deliveryFeeTotal, charge, discount | href(goOrderList), href(goOrder) |

### Page/Admin/Order/Edit
`/admin/order/edit`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | orderNo | href(doUpdateOrder), href(goOrderList) |

### Page/Admin/Order/ExportOrder
`/admin/order/export-order`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goOrderList), href(goExportShipping) |

### Page/Admin/Order/ExportOrderPdf
`/admin/order/export-order-pdf`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | orderNos, orderNo | href(goOrderList), href(goExportOrder) |
| POST | orderNos, orderNo | - |

### Page/Admin/Order/ExportShipping
`/admin/order/export-shipping`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goOrderList), href(doImportShippingCsv) |

### Page/Admin/Order/ImportShipping
`/admin/order/import-shipping`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doImportShippingCsv), href(goExportShipping) |
| POST | csv* | href(goOrderList), href(goExportShipping), href(goExportCustomer) |

### Page/Admin/Order/MailConfirm
`/admin/order/mail-confirm`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | orderNo | href(doSendOrderMail), href(goOrderMail) |

### Page/Admin/Order/OrderPdf
`/admin/order/order-pdf`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | orderNo | href(goExportOrderPdf), href(goOrderList) |

### Page/Admin/Order/SendMail
`/admin/order/send-mail`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | orderNo | href(doSendOrderMail), href(goOrderMailConfirm), href(goOrder) |
| POST | orderNo* | href(goOrder), href(goExportOrderPdf), href(goExportOrder) |

### Page/Admin/Order/ShippingAddress
`/admin/order/shipping-address`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | orderNo | href(doUpdateOrderShippingAddress), href(doSelectShippingAddress) |
| POST | orderNo*, addressId* | href(goOrder), href(doUpdateOrderShippingAddress) |
| PUT | orderNo*, name01*, name02*, postalCode*, pref*, addr01*, addr02*, phoneNumber* | href(goOrder), href(doSelectShippingAddress), href(doUpdateTrackingNumber) |

### Page/Admin/Order/ShippingNotifyMail
`/admin/order/shipping-notify-mail`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | orderNo* | href(doSendShippingNotifyMail), href(goOrder) |
| POST | orderNo* | href(goOrder) |

### Page/Admin/Order/TrackingNumber
`/admin/order/tracking-number`

| Method | Parameters | Links |
|--------|------------|-------|
| PUT | orderNo*, trackingNumber* | href(goOrder), href(goOrderMail) |

### Page/Admin/Page/Page
`/admin/page/page`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | pageId | href(goPageList) |
| PUT | pageId*, pageName, pageUrl, pageFileName | href(goPage) |
| DELETE | pageId* | href(goPageList), href(goBlockList) |

### Page/Admin/Page/PageList
`/admin/page/page-list`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doCreatePage), href(goPage), href(doUpdatePage), href(doDeletePage) |
| POST | pageName*, pageUrl*, pageFileName* | href(goPageList) |

### Page/Admin/Payment/Payment
`/admin/payment/payment`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | paymentId | href(doUpdatePayment), href(doDeletePayment) |
| PUT | paymentId*, paymentMethodName, charge, ruleMin, ruleMax, visible | href(goPaymentList) |
| DELETE | paymentId* | href(goPaymentList), href(goDeliveryList) |

### Page/Admin/Payment/PaymentList
`/admin/payment/payment-list`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doCreatePayment), href(goPayment), href(doToggleVisible), href(goProductList), href(goOrderList) |
| POST | paymentMethodName*, charge, ruleMin, ruleMax, visible | href(goPaymentList) |

### Page/Admin/Product/CsvCategory
`/admin/product/csv-category`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goProductList) |

### Page/Admin/Product/CsvClassCategory
`/admin/product/csv-class-category`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goProductList) |
| POST | csv | - |

### Page/Admin/Product/CsvClassName
`/admin/product/csv-class-name`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goProductList) |
| POST | csv | href(goExportClassCategory) |

### Page/Admin/Product/CsvProduct
`/admin/product/csv-product`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goProductList) |

### Page/Admin/Product/Edit
`/admin/product/edit`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | productCode | href(doCreateProduct), href(doUpdateProduct), href(doDeleteProduct), href(goProductList) |

### Page/Admin/Product/ProductClass
`/admin/product/product-class`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | productCode | href(goProduct), href(goProductList), href(doRegisterProductClass) |
| POST | productCode*, price02, stock, stock_unlimited, delivery_fee, product_code | href(goProductList) |

### Page/Admin/Tag/Tag
`/admin/tag/tag`

| Method | Parameters | Links |
|--------|------------|-------|
| DELETE | tagId* | href(goTagList) |

### Page/Admin/Tag/TagList
`/admin/tag/tag-list`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doCreateTag), href(doDeleteTag) |
| POST | tagName* | href(goTagList) |

### Page/Admin/TaxRule/TaxRule
`/admin/tax-rule/tax-rule`

| Method | Parameters | Links |
|--------|------------|-------|
| DELETE | taxRuleId* | href(goTaxRuleList), href(goCalendar) |

### Page/Admin/TaxRule/TaxRuleList
`/admin/tax-rule/tax-rule-list`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(doCreateTaxRule), href(doDeleteTaxRule) |
| POST | taxRate*, applyDate*, roundingType | href(goTaxRuleList) |

### Page/Admin/Template/TemplateAdd
`/admin/template/template-add`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goTemplateList), href(doInstallTemplate) |
| POST | templateCode*, templateName*, file | href(goTemplateList), href(doSelectTemplate) |

### Page/Admin/Template/TemplateList
`/admin/template/template-list`

| Method | Parameters | Links |
|--------|------------|-------|
| GET | - | href(goTemplateInstall), href(doSelectTemplate), href(doDownloadTemplate), href(doDeleteTemplate) |
| PUT | templateId* | href(doDownloadTemplate) |
| DELETE | templateId* | href(goTemplateList) |
| POST | templateId* | href(doDeleteTemplate) |

## Responses (240)

| Response | Schema | Properties |
|----------|--------|------------|
| Get-action-redirect | get-action-redirect.json | message |
| Post-action-redirect | post-action-redirect.json | message |
| Get-cart | get-cart.json | carts, cartCount, totalPrice, csrfToken, deliveryFeeTotal |
| Get-contact | get-contact.json | form, fields, submitTo, transitionId, csrfToken |
| Post-contact | post-contact.json | contactEmail, contactName02, contactName01, ticketId |
| Get-entry | get-entry.json | form, fields, submitTo, transitionId, csrfToken |
| Post-entry | post-entry.json | name01, customerId, customerStatus, email, initialPoint, name02 |
| Get-forgot-complete | get-forgot-complete.json | fields, submitTo, transitionId |
| Get-forgot-password | get-forgot-password.json | form, fields, submitTo, transitionId, csrfToken |
| Post-forgot-password | post-forgot-password.json | message |
| Get-index | get-index.json | fields, submitTo, staticContent, transitionId |
| Get-login | get-login.json | form, fields, submitTo, transitionId, csrfToken |
| Post-login | post-login.json | name01, customerId, customerStatus, email, name02 |
| Post-logout | post-logout.json | message, wasLoggedIn, customerId |
| Get-mypage | get-mypage.json | name01, customerId, recentOrders, email, favoriteCount, recentOrderCount, name02 |
| Get-product | get-product.json | form, stock, productName, description, classNames, price02, mainImage, tagNames, categoryNames, productCode, stockFind, csrfToken |
| Get-products | get-products.json | filters, pager, transitionId, csrfToken, totalItemCount, products |
| Get-reset | get-reset.json | form, fields, resetKey, submitTo, transitionId, csrfToken |
| Post-reset | post-reset.json | customerId |
| Get-shopping | get-shopping.json | form, cartCount, totalPrice, canCheckout, name02, customerId, deliveryFeeTotal, name01, carts, email, paymentMethods, defaultShippingAddress, preOrderId, csrfToken |
| Get-unsupported-route | get-unsupported-route.json | message, routeName |
| Post-unsupported-route | post-unsupported-route.json | message, routeName |
| Get-admin-action-redirect | get-admin-action-redirect.json | message |
| Post-admin-action-redirect | post-admin-action-redirect.json | message |
| Get-admin-authority-role | get-admin-authority-role.json | authorityOptions, rules, csrfToken |
| Post-admin-authority-role | post-admin-authority-role.json | message, adminId, loginId, previousAuthority, authority, changed, transitionId, count, rules |
| Get-admin-base-info | get-admin-base-info.json | form, phoneNumber, shopKana, businessHour, addr02, postalCode, pref, addr01, shopEmail01, shopName, companyName, shopMessage, shopNameEng, csrfToken |
| Post-admin-base-info | post-admin-base-info.json | phoneNumber, shopKana, changed, businessHour, addr02, postalCode, pref, addr01, shopEmail01, shopName, companyName, shopMessage, shopNameEng |
| Get-admin-calendar | get-admin-calendar.json | form, calendars, errors, csrfToken |
| Post-admin-calendar | post-admin-calendar.json | title, message, transitionId, calendarId, holiday |
| Delete-admin-calendar | delete-admin-calendar.json | message, transitionId, calendarId |
| Get-admin-change-password | get-admin-change-password.json | form, transitionId, fields, csrfToken |
| Post-admin-change-password | post-admin-change-password.json | message, transitionId, loginId, adminId |
| Post-admin-create-customer | post-admin-create-customer.json | name01, customerId, customerStatus, email, initialPoint, name02 |
| Get-admin-csv-config | get-admin-csv-config.json | form, notOutputColumns, outputColumns, csvType, csrfToken |
| Post-admin-csv-config | post-admin-csv-config.json | message, csvType, columns, count |
| Get-admin-customer | get-admin-customer.json | form, sex, kana02, phoneNumber, initialPoint, totalSpent, name02, kana01, name01, favorites, postalCode, addr01, birth, customerId, addr02, customerStatus, email, pref, favoriteCount, companyName, job, orders, orderCount, csrfToken |
| Post-admin-update-customer | post-admin-update-customer.json | name01, customerId, email, name02 |
| Get-admin-customer-csv | get-admin-customer-csv.json | rowCount, csv |
| Get-admin-customer-delivery-edit | get-admin-customer-delivery-edit.json | form, customerId, csrfToken |
| Post-admin-customer-delivery-edit | post-admin-customer-delivery-edit.json | addressId, customerId, name01, name02, kana01, kana02, companyName, phoneNumber, postalCode, pref, addr01, addr02 |
| Delete-admin-customer-delivery-edit | delete-admin-customer-delivery-edit.json | addressId, customerId |
| Get-admin-customer-list | get-admin-customer-list.json | filters, count, csrfToken, searchForm, customers |
| Post-admin-delete-customer | post-admin-delete-customer.json | alreadyDeleted, originalEmail, message, customerId |
| Get-admin-empty-page | get-admin-empty-page.json |  |
| Get-admin-index | get-admin-index.json | countNonStockProducts, salesToday, recommendedPlugins, orders, salesThisMonth, orderStatuses, countCustomers, countProducts, salesYesterday, csrfToken |
| Get-admin-log | get-admin-log.json | log, form |
| Get-admin-login | get-admin-login.json | form, fields, submitTo, transitionId, csrfToken |
| Post-admin-login | post-admin-login.json | name, loginId, authority, adminId |
| Get-admin-login-history | get-admin-login-history.json | entries, count |
| Post-admin-logout | post-admin-logout.json | message, wasLoggedIn, adminId |
| Get-admin-mail-template | get-admin-mail-template.json | form, mailTemplates, id, count, csrfToken, Mail |
| Post-admin-mail-template | post-admin-mail-template.json | mailTemplateId, mailTemplateName, fileName, changed, mailSubject |
| Delete-admin-mail-template | delete-admin-mail-template.json | mailTemplateId, mailTemplateName, fileName, message, transitionId |
| Get-admin-master-data | get-admin-master-data.json | form, csrfToken, submitTo, masterTypes, selectedMaster, rows |
| Put-admin-master-data | put-admin-master-data.json | message, form, csrfToken, submitTo, masterTypes, transitionId, selectedMaster, rows |
| Put-admin-master-data-edit | put-admin-master-data-edit.json | message, transitionId, masterType, count |
| Get-admin-member | get-admin-member.json | form, name, loginId, csrfToken, sortNo, authority, work, adminId |
| Post-admin-member | post-admin-member.json | name, sortNo, loginId, authority, work, adminId |
| Put-admin-member | put-admin-member.json | name, sortNo, loginId, authority, work, adminId |
| Delete-admin-member | delete-admin-member.json | message, adminId, loginId, alreadyDeleted |
| Get-admin-member-list | get-admin-member-list.json | filters, count, csrfToken, members |
| Get-admin-order | get-admin-order.json | paymentDate, paymentMethodId, orderNo, orderStatus, orderDate, preOrderId, itemCount, discount, addPoint, items, customer, customerId, deliveryFeeTotal, usePoint, charge, paymentTotal, tax, orderStatusOptions, subtotal, csrfToken, total |
| Put-admin-order | put-admin-order.json | orderNo, customerId, orderStatus, deliveryFeeTotal, usePoint, charge, paymentTotal, tax, subtotal, discount, total |
| Get-admin-order-list | get-admin-order-list.json | offset, limit, orders, count, searchForm, csrfToken |
| Get-admin-order-status | get-admin-order-status.json | form, orderStatuses, csrfToken |
| Put-admin-order-status | put-admin-order-status.json | orderStatusRows, message, count, transitionId |
| Post-admin-order-status | post-admin-order-status.json | changed, previousStatus, orderNo, orderStatus |
| Delete-admin-plugin | delete-admin-plugin.json | pluginCode, wasInstalled |
| Post-admin-plugin-disable | post-admin-plugin-disable.json | changed, pluginCode, enabled |
| Post-admin-plugin-enable | post-admin-plugin-enable.json | changed, pluginCode, enabled |
| Get-admin-plugin-list | get-admin-plugin-list.json | plugins, count |
| Post-admin-plugin-list | post-admin-plugin-list.json | pluginCode, alreadyInstalled, installed, pluginName, enabled, pluginVersion |
| Get-admin-product | get-admin-product.json | stock, productName, description, classNames, price02, mainImage, tagNames, categoryNames, productCode, note, productStatusOptions, productStatus, csrfToken, searchWord |
| Post-admin-product | post-admin-product.json | stock, productName, productCode, description, productStatus, price02 |
| Put-admin-product | put-admin-product.json | stock, productName, productCode, description, productStatus, price02 |
| Delete-admin-product | delete-admin-product.json | alreadyDeleted, productName, productCode, message |
| Post-admin-product-bulk-status | post-admin-product-bulk-status.json | requestedCount, changedCount, productCodes, productStatus |
| Post-admin-product-copy | post-admin-product-copy.json | productCode, newProductCode, newProductName, price02, stock |
| Get-admin-product-csv | get-admin-product-csv.json | count, csv, csrfToken |
| Post-admin-product-csv | post-admin-product-csv.json | message, transitionId, count, productCodes |
| Get-admin-product-list | get-admin-product-list.json | csrfToken, filters, count, searchForm, products |
| Get-admin-product-new | get-admin-product-new.json | productStatusOptions, csrfToken |
| Get-admin-security | get-admin-security.json | isSecureRequest, form, csrfToken |
| Put-admin-security | put-admin-security.json | message, transitionId, trustedHosts |
| Put-admin-sort-no-move | put-admin-sort-no-move.json | message, masterType, rowId, sortNo |
| Get-admin-system | get-admin-system.json | info, phpinfoEnabled, csrfToken |
| Put-admin-toggle-visible | put-admin-toggle-visible.json | masterType, rowId, visible |
| Get-admin-trade-law | get-admin-trade-law.json | tradeLawBody, form, csrfToken, tradeLawRows |
| Post-admin-trade-law | post-admin-trade-law.json | tradeLawBody, changed |
| Get-admin-two-factor-auth | get-admin-two-factor-auth.json | form, transitionId, fields, csrfToken |
| Post-admin-two-factor-auth | post-admin-two-factor-auth.json | message, transitionId, loginId |
| Get-admin-two-factor-auth-edit | get-admin-two-factor-auth-edit.json | form, memberName, shopName, authKey, csrfToken |
| Get-admin-two-factor-auth-set | get-admin-two-factor-auth-set.json | form, fields, memberName, shopName, transitionId, authKey, csrfToken |
| Put-admin-two-factor-auth-set | put-admin-two-factor-auth-set.json | message, transitionId, loginId |
| Get-admin-unsupported-route | get-admin-unsupported-route.json | message, routeName |
| Post-admin-unsupported-route | post-admin-unsupported-route.json | message, routeName |
| Post-cart-item | post-cart-item.json | cartKey, requestedQuantity, saleTypeName, productCode, totalPrice, unitPrice, adjustedQuantity, deliveryFeeTotal |
| Put-cart-item | put-cart-item.json | cartKey, requestedQuantity, saleTypeName, productCode, totalPrice, unitPrice, adjustedQuantity, deliveryFeeTotal |
| Delete-cart-item | delete-cart-item.json | cartKey, productCode, totalPrice, deliveryFeeTotal |
| Get-contact-complete | get-contact-complete.json | fields, submitTo, staticContent, transitionId, ticketId |
| Get-contact-confirm | get-contact-confirm.json | form, fields, submitTo, staticContent, transitionId, csrfToken |
| Get-entry-activate | get-entry-activate.json | fields, submitTo, staticContent, transitionId |
| Post-entry-activate | post-entry-activate.json | message |
| Get-entry-complete | get-entry-complete.json | fields, submitTo, staticContent, transitionId |
| Get-entry-confirm | get-entry-confirm.json | form, fields, submitTo, staticContent, transitionId, csrfToken |
| Get-help-about | get-help-about.json | fields, submitTo, staticContent, transitionId |
| Get-help-agreement | get-help-agreement.json | fields, submitTo, staticContent, transitionId |
| Get-help-guide | get-help-guide.json | fields, submitTo, staticContent, transitionId |
| Get-help-privacy | get-help-privacy.json | fields, submitTo, staticContent, transitionId |
| Get-help-trade-law | get-help-trade-law.json | fields, submitTo, staticContent, transitionId |
| Get-mypage-address | get-mypage-address.json | form, submitTo, transitionId, csrfToken, addressId |
| Put-mypage-address | put-mypage-address.json | kana02, phoneNumber, name02, customerId, kana01, name01, addr02, postalCode, pref, addr01, companyName, addressId |
| Delete-mypage-address | delete-mypage-address.json | customerId, addressId |
| Get-mypage-address-list | get-mypage-address-list.json | count, addresses, customerId |
| Post-mypage-address-list | post-mypage-address-list.json | kana02, phoneNumber, name02, customerId, kana01, name01, addr02, postalCode, pref, addr01, companyName, addressId |
| Get-mypage-change | get-mypage-change.json | form, kana02, phoneNumber, name02, customerId, kana01, name01, addr02, email, postalCode, pref, addr01, submitTo, companyName, csrfToken |
| Post-mypage-change | post-mypage-change.json | message, email, customerId, name01, name02 |
| Get-mypage-change-complete | get-mypage-change-complete.json | fields, submitTo, staticContent, transitionId |
| Post-mypage-favorite | post-mypage-favorite.json | alreadyExisted, productName, productCode, unitPrice, customerId |
| Delete-mypage-favorite | delete-mypage-favorite.json | alreadyAbsent, customerId, productCode |
| Get-mypage-favorite-list | get-mypage-favorite-list.json | favoriteCount, customerId, favorites |
| Get-mypage-history | get-mypage-history.json | addPoint, paymentDate, message, orderNo, deliveryFeeTotal, orderStatus, usePoint, orderDate, mailHistories, charge, paymentTotal, tax, paymentMethod, subtotal, discount, shippings, total, csrfToken |
| Get-mypage-order-history | get-mypage-order-history.json | offset, limit, orders, customerId, orderCount |
| Post-mypage-reorder | post-mypage-reorder.json | skippedCount, skippedProductCodes, addedCount, cartKeys, orderNo, customerId |
| Get-mypage-withdraw | get-mypage-withdraw.json | name01, fields, email, name02, submitTo, transitionId, csrfToken, customerId |
| Post-mypage-withdraw | post-mypage-withdraw.json | message, cleared, customerId |
| Get-mypage-withdraw-complete | get-mypage-withdraw-complete.json | fields, submitTo, staticContent, transitionId |
| Get-mypage-withdraw-confirm | get-mypage-withdraw-confirm.json | fields, submitTo, transitionId, csrfToken |
| Post-shopping-checkout | post-shopping-checkout.json | addPoint, orderDate, paymentTotal, completeMessage, paymentDate, orderNo, customerId, total, orderStatus |
| Get-shopping-complete | get-shopping-complete.json | completeMessage, staticContent, transitionId, orderNo |
| Get-shopping-confirm | get-shopping-confirm.json | addPoint, items, paymentMethodId, customer, deliveryFeeTotal, usePoint, charge, paymentMethodName, paymentTotal, preOrderId, tax, submitTo, subtotal, transitionId, discount, csrfToken, total |
| Get-shopping-error | get-shopping-error.json | fields, submitTo, staticContent, transitionId |
| Get-shopping-login | get-shopping-login.json | form, fields, submitTo, staticContent, transitionId, csrfToken |
| Get-shopping-non-member | get-shopping-non-member.json | form, fields, submitTo, transitionId, csrfToken |
| Post-shopping-non-member | post-shopping-non-member.json | name01, email, paymentMethodId, preOrderId, name02 |
| Get-shopping-shipping | get-shopping-shipping.json | fields, submitTo, staticContent, transitionId, addresses, csrfToken |
| Post-shopping-shipping | post-shopping-shipping.json | message, transitionId, shippingAddressId |
| Get-shopping-shipping-edit | get-shopping-shipping-edit.json | form, fields, submitTo, staticContent, transitionId, csrfToken |
| Post-shopping-shipping-edit | post-shopping-shipping-edit.json | kana02, phoneNumber, message, name02, kana01, name01, addr02, postalCode, pref, addr01, companyName, transitionId |
| Get-shopping-shipping-multiple | get-shopping-shipping-multiple.json | fields, submitTo, staticContent, transitionId, addresses, cartItems |
| Post-shopping-shipping-multiple | post-shopping-shipping-multiple.json | message, transitionId, allocationCount |
| Get-shopping-shipping-multiple-edit | get-shopping-shipping-multiple-edit.json | form, fields, submitTo, staticContent, transitionId, csrfToken |
| Post-shopping-shipping-multiple-edit | post-shopping-shipping-multiple-edit.json | kana02, phoneNumber, message, name02, kana01, name01, addr02, postalCode, pref, addr01, companyName, transitionId |
| Get-admin-block-block | get-admin-block-block.json | blockId, blockName, blockFileName, blockDeletable, form, csrfToken |
| Put-admin-block-block | put-admin-block-block.json | blockDeletable, blockName, blockId, blockFileName |
| Delete-admin-block-block | delete-admin-block-block.json | message, blockId |
| Get-admin-block-block-list | get-admin-block-block-list.json | count, blocks, csrfToken |
| Post-admin-block-block-list | post-admin-block-block-list.json | blockDeletable, blockName, blockId, blockFileName |
| Get-admin-category-category | get-admin-category-category.json | parentId, categoryName, sortNo, categoryId, csrfToken |
| Put-admin-category-category | put-admin-category-category.json | parentId, categoryName, sortNo, categoryId |
| Delete-admin-category-category | delete-admin-category-category.json | categoryId |
| Get-admin-category-category-list | get-admin-category-category-list.json | count, categories, csrfToken |
| Post-admin-category-category-list | post-admin-category-category-list.json | parentId, categoryName, sortNo, categoryId |
| Get-admin-category-csv | get-admin-category-csv.json | rowCount, csv, csrfToken |
| Post-admin-category-csv | post-admin-category-csv.json | deleted, imported, message, transitionId, accepted, lineCount |
| Get-admin-category-edit | get-admin-category-edit.json | form, categories, category, count, categoryId, csrfToken |
| Put-admin-class-category-class-category | put-admin-class-category-class-category.json | classCategoryId, name, classNameId |
| Delete-admin-class-category-class-category | delete-admin-class-category-class-category.json | classCategoryId |
| Get-admin-class-category-class-category-export | get-admin-class-category-class-category-export.json | content, csrfToken |
| Get-admin-class-category-class-category-list | get-admin-class-category-class-category-list.json | form, classNameId, count, classCategories |
| Post-admin-class-category-class-category-list | post-admin-class-category-class-category-list.json | classCategoryId, name, classNameId |
| Put-admin-class-name-class-name | put-admin-class-name-class-name.json | name, classNameId |
| Delete-admin-class-name-class-name | delete-admin-class-name-class-name.json | classNameId |
| Get-admin-class-name-class-name-export | get-admin-class-name-class-name-export.json | content, csrfToken |
| Get-admin-class-name-class-name-list | get-admin-class-name-class-name-list.json | form, count, classNames |
| Post-admin-class-name-class-name-list | post-admin-class-name-class-name-list.json | name, classNameId |
| Get-admin-content-cache | get-admin-content-cache.json | csrfToken |
| Put-admin-content-cache | put-admin-content-cache.json | message, transitionId |
| Get-admin-content-css | get-admin-content-css.json | form, csrfToken |
| Put-admin-content-css | put-admin-content-css.json | length, message, transitionId |
| Get-admin-content-file-manager | get-admin-content-file-manager.json | form, tplIsTopDir, arrFileList, errors, tplNowDir, tplParentDir |
| Get-admin-content-js | get-admin-content-js.json | form, csrfToken |
| Put-admin-content-js | put-admin-content-js.json | length, message, transitionId |
| Get-admin-content-maintenance | get-admin-content-maintenance.json | isMaintenance, csrfToken |
| Put-admin-content-maintenance | put-admin-content-maintenance.json | message, transitionId, isMaintenance |
| Post-admin-customer-resend-activation-mail | post-admin-customer-resend-activation-mail.json | message, customerId, email |
| Get-admin-delivery-delivery | get-admin-delivery-delivery.json | deliveryId, form, delivery, csrfToken |
| Put-admin-delivery-delivery | put-admin-delivery-delivery.json | deliveryId, deliveryName, visible |
| Delete-admin-delivery-delivery | delete-admin-delivery-delivery.json | deliveryId |
| Get-admin-delivery-delivery-list | get-admin-delivery-delivery-list.json | deliveries, count, csrfToken |
| Post-admin-delivery-delivery-list | post-admin-delivery-delivery-list.json | deliveryId, deliveryName, visible |
| Get-admin-layout-layout | get-admin-layout-layout.json | layoutId, layoutName, deviceType, csrfToken, form |
| Put-admin-layout-layout | put-admin-layout-layout.json | deviceType, layoutId, layoutName |
| Get-admin-layout-layout-list | get-admin-layout-layout-list.json | count, layouts |
| Post-admin-mail-template-create | post-admin-mail-template-create.json | mailTemplateId, mailTemplateName, fileName, mailSubject |
| Get-admin-news-news | get-admin-news-news.json | form, newsUrl, linkMethod, newsId, newsTitle, csrfToken, publishDate, newsDescription |
| Put-admin-news-news | put-admin-news-news.json | newsUrl, linkMethod, newsId, newsTitle, publishDate, newsDescription |
| Delete-admin-news-news | delete-admin-news-news.json | newsId |
| Get-admin-news-news-list | get-admin-news-news-list.json | news, count, csrfToken |
| Post-admin-news-news-list | post-admin-news-news-list.json | newsUrl, linkMethod, newsId, newsTitle, publishDate, newsDescription |
| Post-admin-order-bulk-delete | post-admin-order-bulk-delete.json | requestedCount, orderNos, changedCount |
| Post-admin-order-create | post-admin-order-create.json | message, orderNo, customerId, paymentMethodId, subtotal, deliveryFeeTotal, charge, discount, tax, total, paymentTotal, addPoint, itemCount, orderStatus, orderDate |
| Get-admin-order-edit | get-admin-order-edit.json | form, order, items, orderNo, csrfToken |
| Get-admin-order-export-order | get-admin-order-export-order.json | rowCount, csv |
| Get-admin-order-export-order-pdf | get-admin-order-export-order-pdf.json | message, orderNo, orderNos, pdf, size, fileName |
| Get-admin-order-export-shipping | get-admin-order-export-shipping.json | rowCount, csv, csrfToken |
| Get-admin-order-import-shipping | get-admin-order-import-shipping.json | csrfToken |
| Post-admin-order-import-shipping | post-admin-order-import-shipping.json | skipped, imported, message, transitionId, accepted, lineCount |
| Get-admin-order-mail-confirm | get-admin-order-mail-confirm.json | orderNo, csrfToken |
| Get-admin-order-order-pdf | get-admin-order-order-pdf.json | form, orderNo |
| Get-admin-order-send-mail | get-admin-order-send-mail.json | form, orderNo, csrfToken |
| Post-admin-order-send-mail | post-admin-order-send-mail.json | mailBody, message, sendDate, orderNo, mailSubject, customerId |
| Get-admin-order-shipping-address | get-admin-order-shipping-address.json | form, orderNo, csrfToken |
| Post-admin-order-shipping-address | post-admin-order-shipping-address.json | message |
| Put-admin-order-shipping-address | put-admin-order-shipping-address.json | name01, addr02, postalCode, pref, addr01, phoneNumber, orderNo, name02 |
| Get-admin-order-shipping-notify-mail | get-admin-order-shipping-notify-mail.json | orderNo, customerId, message, csrfToken, submitTo |
| Post-admin-order-shipping-notify-mail | post-admin-order-shipping-notify-mail.json | trackingNumber, message, orderNo, customerId |
| Put-admin-order-tracking-number | put-admin-order-tracking-number.json | status, message, trackingNumber, orderNo |
| Get-admin-page-page | get-admin-page-page.json | form, pageFileName, pageUrl, pageId, pageName, csrfToken, pageEditType |
| Put-admin-page-page | put-admin-page-page.json | pageFileName, pageUrl, pageId, pageName, pageEditType |
| Delete-admin-page-page | delete-admin-page-page.json | message, pageId |
| Get-admin-page-page-list | get-admin-page-page-list.json | count, pages, csrfToken |
| Post-admin-page-page-list | post-admin-page-page-list.json | pageFileName, pageUrl, pageId, pageName, pageEditType |
| Get-admin-payment-payment | get-admin-payment-payment.json | form, paymentId, payment, csrfToken |
| Put-admin-payment-payment | put-admin-payment-payment.json | charge, paymentMethodName, ruleMin, ruleMax, visible, paymentId |
| Delete-admin-payment-payment | delete-admin-payment-payment.json | paymentId |
| Get-admin-payment-payment-list | get-admin-payment-payment-list.json | payments, count, csrfToken |
| Post-admin-payment-payment-list | post-admin-payment-payment-list.json | charge, paymentMethodName, ruleMin, ruleMax, visible, paymentId |
| Get-admin-product-csv-category | get-admin-product-csv-category.json | form, csvTitle, skeletonRoute, columns, csrfToken |
| Get-admin-product-csv-class-category | get-admin-product-csv-class-category.json | form, csvTitle, skeletonRoute, columns, csrfToken |
| Post-admin-product-csv-class-category | post-admin-product-csv-class-category.json | message, accepted, transitionId |
| Get-admin-product-csv-class-name | get-admin-product-csv-class-name.json | form, csvTitle, skeletonRoute, columns, csrfToken |
| Post-admin-product-csv-class-name | post-admin-product-csv-class-name.json | message, accepted, transitionId |
| Get-admin-product-csv-product | get-admin-product-csv-product.json | form, csvTitle, skeletonRoute, columns, csrfToken |
| Get-admin-product-edit | get-admin-product-edit.json | form, product, productCode, csrfToken |
| Get-admin-product-product-class | get-admin-product-product-class.json | csrfToken, form, productCode, classes |
| Post-admin-product-product-class | post-admin-product-product-class.json | productClassId, productCode |
| Delete-admin-tag-tag | delete-admin-tag-tag.json | tagId |
| Get-admin-tag-tag-list | get-admin-tag-tag-list.json | form, count, tags, csrfToken |
| Post-admin-tag-tag-list | post-admin-tag-tag-list.json | tagId, tagName |
| Delete-admin-tax-rule-tax-rule | delete-admin-tax-rule-tax-rule.json | taxRuleId |
| Get-admin-tax-rule-tax-rule-list | get-admin-tax-rule-tax-rule-list.json | form, taxRules, count, csrfToken |
| Post-admin-tax-rule-tax-rule-list | post-admin-tax-rule-tax-rule-list.json | roundingType, taxRate, taxRuleId, applyDate |
| Get-admin-template-template-add | get-admin-template-template-add.json | form, csrfToken |
| Post-admin-template-template-add | post-admin-template-template-add.json | message, templateId, archiveName, archiveSize, transitionId |
| Get-admin-template-template-list | get-admin-template-template-list.json | count, templates, csrfToken |
| Put-admin-template-template-list | put-admin-template-template-list.json | message, transitionId, templateId |
| Delete-admin-template-template-list | delete-admin-template-template-list.json | message, transitionId, templateId |
| Post-admin-template-template-list | post-admin-template-template-list.json | message, value |

## SQL (168)

| File | Query |
|------|-------|
| address_delete.sql | `DELETE FROM
  dtb_customer_address
WHERE
  :addressId REGEXP '^[0-9]+$'
  AND...` |
| address_get.sql | `SELECT
  CAST(ca.id AS CHAR) AS address_id,
  CAST(ca.customer_id AS CHAR) AS...` |
| address_list_by_customer.sql | `SELECT
  CAST(ca.id AS CHAR) AS address_id,
  CAST(ca.customer_id AS CHAR) AS...` |
| address_next_id.sql | `SELECT
  IFNULL(
    MAX(id),
    0
  ) + 1 AS next_id
FROM
  dtb_customer_ad...` |
| address_put.sql | `INSERT INTO dtb_customer_address (
  id, customer_id, name01, name02, kana01,...` |
| admin_create.sql | `INSERT INTO dtb_member (
  id, work_id, authority_id, name, login_id,
  passw...` |
| admin_delete.sql | `UPDATE
  dtb_member
SET
  work_id = 0,
  update_date = NOW()
WHERE
  :adminId...` |
| admin_find_by_id.sql | `SELECT
  CAST(id AS CHAR) AS id,
  login_id,
  password,
  COALESCE(name, '')...` |
| admin_find_by_login.sql | `SELECT
  CAST(id AS CHAR) AS id,
  login_id,
  password,
  COALESCE(name, '')...` |
| admin_list.sql | `SELECT
  CAST(id AS CHAR) AS id,
  login_id,
  password,
  COALESCE(name, '')...` |
| admin_next_id.sql | `SELECT
  IFNULL(
    MAX(id),
    0
  ) + 1 AS next_id
FROM
  dtb_member` |
| admin_reorder.sql | `UPDATE
  dtb_member
SET
  sort_no = :sortNo,
  update_date = NOW()
WHERE
  :a...` |
| admin_search.sql | `SELECT
  CAST(id AS CHAR) AS id,
  login_id,
  password,
  COALESCE(name, '')...` |
| admin_two_factor_enable.sql | `UPDATE
  dtb_member
SET
  two_factor_auth_key = :secret,
  two_factor_auth_en...` |
| admin_two_factor_secret.sql | `SELECT
  two_factor_auth_key
FROM
  dtb_member
WHERE
  login_id = :loginId
  ...` |
| admin_update.sql | `UPDATE
  dtb_member
SET
  login_id = JSON_VALUE(
    CAST(:admin AS CHAR),
  ...` |
| admin_update_authority.sql | `UPDATE
  dtb_member
SET
  authority_id = :newAuthority,
  update_date = NOW()...` |
| admin_update_password.sql | `UPDATE
  dtb_member
SET
  password = :passwordHash,
  update_date = NOW()
WHE...` |
| authority_role_delete_all.sql | `DELETE FROM
  dtb_authority_role` |
| authority_role_insert.sql | `INSERT INTO dtb_authority_role (
  authority_id, creator_id, deny_url, create...` |
| authority_role_list.sql | `SELECT
  authority_id AS authority,
  deny_url AS denyUrl
FROM
  dtb_authorit...` |
| block_next_id.sql | `SELECT
  IFNULL(
    MAX(id),
    0
  ) + 1 AS next_id
FROM
  dtb_block` |
| calendarHoliday_next_id.sql | `SELECT
  IFNULL(
    MAX(id),
    0
  ) + 1 AS next_id
FROM
  dtb_calendar` |
| cart_by_key.sql | `SELECT
  c.cart_key,
  c.sale_type_id,
  st.name AS sale_type_name,
  (
    S...` |
| cart_by_session_prefix.sql | `SELECT
  c.cart_key,
  c.sale_type_id,
  st.name AS sale_type_name,
  (
    S...` |
| cart_clear_pre_order.sql | `DELETE FROM
  dtb_cart
WHERE
  pre_order_id = :preOrderId` |
| cart_clear_session_prefix.sql | `DELETE FROM
  dtb_cart
WHERE
  cart_key LIKE CONCAT(
    REPLACE(
      REPLA...` |
| cart_save.sql | `SET
  @bemart_cart_missing_codes = (
    SELECT
      COALESCE(
        GROUP...` |
| category_next_id.sql | `SELECT
  IFNULL(
    MAX(id),
    0
  ) + 1 AS next_id
FROM
  dtb_category` |
| classCategory_next_id.sql | `SELECT
  IFNULL(
    MAX(id),
    0
  ) + 1 AS next_id
FROM
  dtb_class_category` |
| className_next_id.sql | `SELECT
  IFNULL(
    MAX(id),
    0
  ) + 1 AS next_id
FROM
  dtb_class_name` |
| csv_column_delete_type.sql | `DELETE FROM
  dtb_csv
WHERE
  csv_type_id = :csvType` |
| csv_column_insert_type.sql | `INSERT INTO dtb_csv (
  csv_type_id, entity_name, field_name,
  disp_name, so...` |
| csv_column_list_by_type.sql | `SELECT
  csv_type_id AS csvType,
  field_name AS columnName,
  enabled,
  sor...` |
| csv_column_replace_type.sql | `INSERT INTO dtb_csv (
  csv_type_id, entity_name, field_name,
  disp_name, so...` |
| customer_activate.sql | `UPDATE
  dtb_customer
SET
  customer_status_id = 2,
  update_date = NOW()
WHE...` |
| customer_email_exists.sql | `SELECT
  1 AS found
FROM
  dtb_customer
WHERE
  email = :email
LIMIT
  1` |
| customer_find_by_email.sql | `SELECT
  id,
  email,
  password,
  name01,
  name02,
  kana01,
  kana02,
  c...` |
| customer_find_by_id.sql | `SELECT
  id,
  email,
  password,
  name01,
  name02,
  kana01,
  kana02,
  c...` |
| customer_find_by_secret_key.sql | `SELECT
  id,
  email,
  password,
  name01,
  name02,
  kana01,
  kana02,
  c...` |
| customer_next_id.sql | `SELECT
  IFNULL(
    MAX(id),
    0
  ) + 1 AS next_id
FROM
  dtb_customer` |
| customer_register.sql | `INSERT INTO dtb_customer (
  id, customer_status_id, sex_id, job_id,
  pref_i...` |
| customer_search.sql | `SELECT
  c.id,
  c.email,
  c.password,
  c.name01,
  c.name02,
  c.kana01,
 ...` |
| customer_update.sql | `UPDATE
  dtb_customer
SET
  email = JSON_VALUE(
    CAST(:customer AS CHAR),
...` |
| customer_update_password.sql | `UPDATE
  dtb_customer
SET
  password = :passwordHash,
  update_date = NOW()
W...` |
| dashboard_counts.sql | `SELECT
    (
        SELECT
            COUNT(*)
        FROM
            dtb...` |
| delivery_next_id.sql | `SELECT
  IFNULL(
    MAX(id),
    0
  ) + 1 AS next_id
FROM
  dtb_delivery` |
| favorite_add.sql | `INSERT IGNORE INTO dtb_customer_favorite_product (
  customer_id, product_id,...` |
| favorite_has.sql | `SELECT
  1 AS found
FROM
  dtb_customer_favorite_product fav
  INNER JOIN dtb...` |
| favorite_list.sql | `SELECT
  fav.customer_id,
  pc.product_code,
  p.name AS product_name,
  pc.p...` |
| favorite_remove.sql | `DELETE fav
FROM
  dtb_customer_favorite_product fav
  INNER JOIN dtb_product_...` |
| news_next_id.sql | `SELECT
  IFNULL(
    MAX(id),
    0
  ) + 1 AS next_id
FROM
  dtb_news` |
| order_by_order_no.sql | `SELECT
  order_no,
  pre_order_id,
  customer_id,
  payment_id,
  subtotal,
 ...` |
| order_by_pre_order_id.sql | `SELECT
  o.pre_order_id,
  o.customer_id,
  o.payment_id,
  o.delivery_fee_to...` |
| order_claim_pre_order.sql | `UPDATE
  dtb_order
SET
  order_no = :orderNo,
  order_status_id = 1,
  update...` |
| order_claimed_no.sql | `SELECT
  COALESCE(o.order_no, '') AS order_no
FROM
  dtb_order o
WHERE
  o.pr...` |
| order_history_by_order_no.sql | `SELECT
  o.order_no,
  o.customer_id,
  o.message,
  p.payment_method,
  o.su...` |
| order_item_register.sql | `INSERT INTO dtb_order_item (
  order_id, product_id, product_class_id,
  prod...` |
| order_items_by_order_no.sql | `SELECT
  o.order_no,
  oi.product_code,
  oi.product_name,
  oi.quantity,
  o...` |
| order_list_all.sql | `SELECT
  order_no,
  pre_order_id,
  customer_id,
  payment_id,
  subtotal,
 ...` |
| order_list_by_customer.sql | `SELECT
  order_no,
  pre_order_id,
  customer_id,
  payment_id,
  subtotal,
 ...` |
| order_mail_history_insert.sql | `INSERT INTO dtb_mail_history (
  order_id, creator_id, send_date, mail_subjec...` |
| order_register.sql | `INSERT INTO dtb_order (
  customer_id, payment_id, pre_order_id,
  order_no, ...` |
| order_update.sql | `UPDATE
  dtb_order
SET
  customer_id = CASE WHEN JSON_VALUE(
    CAST(:order ...` |
| order_update_status.sql | `UPDATE
  dtb_order
SET
  order_status_id = :newStatus,
  update_date = NOW()
...` |
| page_next_id.sql | `SELECT
  IFNULL(
    MAX(id),
    0
  ) + 1 AS next_id
FROM
  dtb_page` |
| password_reset_delete.sql | `UPDATE
  dtb_customer
SET
  reset_key = NULL,
  reset_expire = NULL
WHERE
  r...` |
| password_reset_get.sql | `SELECT
  id,
  reset_key,
  COALESCE(
    reset_expire,
    DATE_SUB(
      N...` |
| password_reset_put.sql | `UPDATE
  dtb_customer
SET
  reset_key = JSON_VALUE(
    CAST(:token AS CHAR),...` |
| paymentMethodAdmin_next_id.sql | `SELECT
  IFNULL(
    MAX(id),
    0
  ) + 1 AS next_id
FROM
  dtb_payment` |
| plugin_find_by_code.sql | `SELECT
  code,
  name,
  version,
  initialized,
  enabled
FROM
  dtb_plugin
...` |
| plugin_install.sql | `INSERT INTO dtb_plugin (
  name, code, version, source, initialized,
  enable...` |
| plugin_list_all.sql | `SELECT
  code,
  name,
  version,
  initialized,
  enabled
FROM
  dtb_plugin
...` |
| plugin_set_enabled.sql | `SELECT
  COUNT(*) INTO @bemart_plugin_found
FROM
  dtb_plugin
WHERE
  code = ...` |
| plugin_uninstall.sql | `DELETE FROM
  dtb_plugin
WHERE
  code = :pluginCode` |
| productClass_next_id.sql | `SELECT
  IFNULL(
    MAX(id),
    0
  ) + 1 AS next_id
FROM
  dtb_product_class` |
| product_class_get.sql | `SELECT
  pc.product_code,
  p.name AS product_name,
  pc.stock,
  pc.stock_un...` |
| product_copy.sql | `SET
  @bemart_product_copy_id = 0;

INSERT INTO dtb_product (
  product_statu...` |
| product_create.sql | `INSERT INTO dtb_product (
  product_status_id, name, note, description_detail...` |
| product_export.sql | `SELECT
  b.product_code,
  b.product_name,
  b.price02,
  b.stock,
  b.produc...` |
| product_get.sql | `SELECT
  pc.product_code,
  p.name AS product_name,
  pc.price02,
  pc.stock,...` |
| product_list.sql | `SELECT
  b.product_code,
  b.product_name,
  b.price02,
  b.stock,
  b.produc...` |
| product_search.sql | `SELECT
  b.product_code,
  b.product_name,
  b.price02,
  b.stock,
  b.produc...` |
| product_soft_delete.sql | `UPDATE
  dtb_product p
  INNER JOIN dtb_product_class pc ON pc.product_id = p...` |
| product_status_bulk_update.sql | `UPDATE
  dtb_product p
  INNER JOIN dtb_product_class pc ON pc.product_id = p...` |
| product_update.sql | `UPDATE
  dtb_product p
  INNER JOIN dtb_product_class pc ON pc.product_id = p...` |
| shipping_get_by_order_no.sql | `SELECT
  o.order_no,
  s.name01,
  s.name02,
  s.postal_code,
  s.pref_id,
  ...` |
| shipping_list_all.sql | `SELECT
  o.order_no,
  s.name01,
  s.name02,
  s.postal_code,
  s.pref_id,
  ...` |
| shipping_put.sql | `INSERT INTO dtb_shipping (
  id, order_id, pref_id, name01, name02,
  postal_...` |
| shipping_tracking_by_order_no.sql | `SELECT
  s.tracking_number
FROM
  dtb_order o
  INNER JOIN dtb_shipping s ON ...` |
| shipping_update_tracking.sql | `INSERT INTO dtb_shipping (
  id, order_id, name01, name02, tracking_number,
 ...` |
| tag_delete.sql | `DELETE FROM
  dtb_tag
WHERE
  :tagId REGEXP '^[0-9]+$'
  AND id = CAST(:tagId...` |
| tag_get.sql | `SELECT
  CAST(id AS CHAR) AS tagId,
  name AS tagName
FROM
  dtb_tag
WHERE
  ...` |
| tag_list.sql | `SELECT
  CAST(id AS CHAR) AS tagId,
  name AS tagName
FROM
  dtb_tag
ORDER BY...` |
| tag_next_id.sql | `SELECT
  IFNULL(
    MAX(id),
    0
  ) + 1 AS next_id
FROM
  dtb_tag` |
| tag_put.sql | `INSERT INTO dtb_tag (
  id, name, sort_no, discriminator_type
)
SELECT
  CAST...` |
| tag_reorder.sql | `UPDATE
  dtb_tag
SET
  sort_no = :sortNo
WHERE
  :tagId REGEXP '^[0-9]+$'
  A...` |
| taxRule_next_id.sql | `SELECT
  IFNULL(
    MAX(id),
    0
  ) + 1 AS next_id
FROM
  dtb_tax_rule` |
| tbase_info_get.sql | `SELECT
  shop_name,
  shop_kana,
  shop_name_eng,
  company_name,
  postal_co...` |
| tbase_info_put.sql | `INSERT INTO dtb_base_info (
  id, shop_name, shop_kana, shop_name_eng,
  comp...` |
| tblock_get.sql | `SELECT
  CAST(id AS CHAR),
  block_name,
  file_name,
  deletable
FROM
  dtb_...` |
| tblock_list.sql | `SELECT
  CAST(id AS CHAR),
  block_name,
  file_name,
  deletable
FROM
  dtb_...` |
| tblock_put.sql | `INSERT INTO dtb_block (
  id, block_name, file_name, deletable,
  create_date...` |
| tblock_remove.sql | `DELETE b,
  bp
FROM
  dtb_block b
  LEFT JOIN dtb_block_position bp ON bp.blo...` |
| tcalendar_holiday_delete.sql | `DELETE FROM
  dtb_calendar
WHERE
  :calendarId REGEXP '^[0-9]+$'
  AND id = C...` |
| tcalendar_holiday_get.sql | `SELECT
  CAST(id AS CHAR),
  title,
  DATE_FORMAT(holiday, '%Y-%m-%d')
FROM
 ...` |
| tcalendar_holiday_list.sql | `SELECT
  CAST(id AS CHAR),
  title,
  DATE_FORMAT(holiday, '%Y-%m-%d')
FROM
 ...` |
| tcalendar_holiday_put.sql | `INSERT INTO dtb_calendar (
  id, title, holiday, create_date, update_date,
  ...` |
| tcategory_get.sql | `SELECT
  CAST(id AS CHAR) AS id,
  category_name,
  CAST(parent_category_id A...` |
| tcategory_list.sql | `SELECT
  c.id,
  c.category_name,
  c.parent_category_id,
  c.sort_no
FROM
  ...` |
| tcategory_put.sql | `INSERT INTO dtb_category (
  id, category_name, parent_category_id,
  sort_no...` |
| tcategory_remove.sql | `DELETE FROM
  dtb_product_category
WHERE
  :categoryId REGEXP '^[0-9]+$'
  AN...` |
| tclass_category_delete.sql | `DELETE FROM
  dtb_class_category
WHERE
  :classCategoryId REGEXP '^[0-9]+$'
 ...` |
| tclass_category_get.sql | `SELECT
  CAST(id AS CHAR) AS classCategoryId,
  CAST(class_name_id AS CHAR) A...` |
| tclass_category_list.sql | `SELECT
  CAST(id AS CHAR) AS classCategoryId,
  CAST(class_name_id AS CHAR) A...` |
| tclass_category_list_by_class_name.sql | `SELECT
  CAST(id AS CHAR) AS classCategoryId,
  CAST(class_name_id AS CHAR) A...` |
| tclass_category_put.sql | `INSERT INTO dtb_class_category (
  id, class_name_id, name, sort_no, visible,...` |
| tclass_category_reorder.sql | `UPDATE
  dtb_class_category
SET
  sort_no = :sortNo,
  update_date = NOW()
WH...` |
| tclass_category_visible.sql | `UPDATE
  dtb_class_category
SET
  visible = :visible,
  update_date = NOW()
W...` |
| tclass_name_get.sql | `SELECT
  CAST(id AS CHAR) AS classNameId,
  name
FROM
  dtb_class_name
WHERE
...` |
| tclass_name_list.sql | `SELECT
  CAST(id AS CHAR) AS classNameId,
  name
FROM
  dtb_class_name
ORDER ...` |
| tclass_name_put.sql | `INSERT INTO dtb_class_name (
  id, name, sort_no, create_date, update_date,
 ...` |
| tclass_name_remove.sql | `DELETE FROM
  dtb_class_name
WHERE
  :classNameId REGEXP '^[0-9]+$'
  AND id ...` |
| tclass_name_reorder.sql | `UPDATE
  dtb_class_name
SET
  sort_no = :sortNo,
  update_date = NOW()
WHERE
...` |
| tdelivery_delete.sql | `DELETE FROM
  dtb_delivery
WHERE
  :deliveryId REGEXP '^[0-9]+$'
  AND id = C...` |
| tdelivery_get.sql | `SELECT
  CAST(id AS CHAR),
  name,
  visible
FROM
  dtb_delivery
WHERE
  :del...` |
| tdelivery_list.sql | `SELECT
  CAST(id AS CHAR),
  name,
  visible
FROM
  dtb_delivery
ORDER BY
  i...` |
| tdelivery_put.sql | `INSERT INTO dtb_delivery (
  id, name, visible, create_date, update_date,
  d...` |
| tdelivery_reorder.sql | `UPDATE
  dtb_delivery
SET
  sort_no = :sortNo,
  update_date = NOW()
WHERE
  ...` |
| tdelivery_visible.sql | `UPDATE
  dtb_delivery
SET
  visible = :visible,
  update_date = NOW()
WHERE
 ...` |
| tlayout_get.sql | `SELECT
  CAST(id AS CHAR),
  layout_name,
  CAST(device_type_id AS UNSIGNED)
...` |
| tlayout_list.sql | `SELECT
  CAST(id AS CHAR),
  layout_name,
  CAST(device_type_id AS UNSIGNED)
...` |
| tlayout_put.sql | `INSERT INTO dtb_layout (
  id, layout_name, device_type_id, create_date,
  up...` |
| tlogin_history_account_failures.sql | `SELECT
  COUNT(*) AS failures
FROM
  dtb_login_history lh
WHERE
  lh.user_nam...` |
| tlogin_history_insert.sql | `INSERT INTO dtb_login_history (
  login_history_status_id, user_name,
  clien...` |
| tlogin_history_list.sql | `SELECT
  lh.create_date,
  lh.user_name AS login_id,
  (lh.login_history_stat...` |
| tlogin_history_recent_failures.sql | `SELECT
  COUNT(*) AS failures
FROM
  dtb_login_history lh
WHERE
  lh.user_nam...` |
| tmail_template_delete.sql | `DELETE FROM
  dtb_mail_template
WHERE
  :mailTemplateId > 0
  AND id = :mailT...` |
| tmail_template_get.sql | `SELECT
  id,
  name,
  file_name,
  mail_subject,
  deletable
FROM
  dtb_mail...` |
| tmail_template_list.sql | `SELECT
  id,
  name,
  file_name,
  mail_subject,
  deletable
FROM
  dtb_mail...` |
| tmail_template_put.sql | `INSERT INTO dtb_mail_template (
  id, name, file_name, mail_subject,
  create...` |
| tmail_template_update.sql | `UPDATE
  dtb_mail_template
SET
  mail_subject = JSON_VALUE(
    CAST(:entity ...` |
| tnews_delete.sql | `DELETE FROM
  dtb_news
WHERE
  :newsId REGEXP '^[0-9]+$'
  AND id = CAST(:new...` |
| tnews_get.sql | `SELECT
  CAST(id AS CHAR),
  title,
  description,
  url,
  DATE_FORMAT(
    ...` |
| tnews_list.sql | `SELECT
  CAST(id AS CHAR),
  title,
  description,
  url,
  DATE_FORMAT(
    ...` |
| tnews_put.sql | `INSERT INTO dtb_news (
  id, title, description, url, publish_date,
  link_me...` |
| tnews_visible.sql | `UPDATE
  dtb_news
SET
  visible = :visible,
  update_date = NOW()
WHERE
  :ne...` |
| tpage_get.sql | `SELECT
  CAST(id AS CHAR),
  page_name,
  url,
  file_name,
  CAST(edit_type ...` |
| tpage_list.sql | `SELECT
  CAST(id AS CHAR),
  page_name,
  url,
  file_name,
  CAST(edit_type ...` |
| tpage_put.sql | `INSERT INTO dtb_page (
  id, page_name, url, file_name, edit_type,
  create_d...` |
| tpage_remove.sql | `DELETE
  p,
  pl
FROM
  dtb_page p
  LEFT JOIN dtb_page_layout pl ON pl.page_...` |
| tpayment_get.sql | `SELECT
  CAST(id AS CHAR),
  payment_method,
  CAST(charge AS SIGNED),
  CAST...` |
| tpayment_list.sql | `SELECT
  CAST(id AS CHAR),
  payment_method,
  CAST(charge AS SIGNED),
  CAST...` |
| tpayment_put.sql | `INSERT INTO dtb_payment (
  id, payment_method, charge, rule_min,
  rule_max,...` |
| tpayment_remove.sql | `DELETE FROM
  dtb_payment_option
WHERE
  :paymentId REGEXP '^[0-9]+$'
  AND p...` |
| tpayment_reorder.sql | `UPDATE
  dtb_payment
SET
  sort_no = :sortNo,
  update_date = NOW()
WHERE
  :...` |
| tpayment_visible.sql | `UPDATE
  dtb_payment
SET
  visible = :visible,
  update_date = NOW()
WHERE
  ...` |
| tproduct_class_get.sql | `SELECT
  CAST(id AS CHAR) AS productClassId,
  product_code AS productCode,
 ...` |
| tproduct_class_put.sql | `INSERT INTO dtb_product_class (
  id, product_id, product_code, stock, stock_...` |
| ttax_rule_delete.sql | `DELETE FROM
  dtb_tax_rule
WHERE
  :taxRuleId REGEXP '^[0-9]+$'
  AND id = CA...` |
| ttax_rule_get.sql | `SELECT
  CAST(id AS CHAR),
  CAST(
    tax_rate AS DECIMAL(10, 2)
  ),
  CAST...` |
| ttax_rule_list.sql | `SELECT
  CAST(id AS CHAR),
  CAST(
    tax_rate AS DECIMAL(10, 2)
  ),
  CAST...` |
| ttax_rule_put.sql | `INSERT INTO dtb_tax_rule (
  id, tax_rate, rounding_type_id, apply_date,
  cr...` |
| ttemplate_delete.sql | `DELETE FROM
  dtb_template
WHERE
  :templateId REGEXP '^[0-9]+$'
  AND id = C...` |
| ttemplate_list.sql | `SELECT
  id,
  template_name,
  device_type_id
FROM
  dtb_template
ORDER BY
 ...` |
| ttemplate_put.sql | `INSERT INTO dtb_template (
  id, device_type_id, template_code,
  template_na...` |
| ttrade_law_get.sql | `SELECT
  COALESCE(
    (
      SELECT
        description
      FROM
        ...` |
| ttrade_law_put.sql | `INSERT INTO dtb_tradelaw (
  id, name, description, sort_no, display_order_sc...` |