[Skip to main content](#vessel-content) # Views ## - **[bmmleroy](/forum/user/36879-bmmleroy "View bmmleroy's Profile")** - [![bmmleroy's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36879-bmmleroy "View bmmleroy's Profile") Topic Author - [ Offline](/forum/user/36879-bmmleroy) Less More - Posts: 6 - Thank you received: 1 - - 10 years 2 months ago [\#247352](#247352) by [bmmleroy](/forum/user/36879-bmmleroy "View bmmleroy's Profile") *[Views](/forum/31-development/885954-views#247352 "Dear all, I make use of views mainly to call MySQL procedures, which is an impressive facility. However I can't seem to find the view associated with the backend removal of products from an order in Hikashop or the frontend removal in Hikamarket (Front End). I do not use HS (Professional 2.6.3) for commercial purposes, but actually as a core for a corporate environment which provides different types of clothing and special pieces of equipment to various categories of personnel, which are associated with a system of credits specific in time and value to each category, and this calls for a lot of database activity. Thank you. Bruno")* was created by *[bmmleroy](/forum/user/36879-bmmleroy "View bmmleroy's Profile")* Dear all, I make use of views mainly to call MySQL procedures, which is an impressive facility. However I can't seem to find the view associated with the backend removal of products from an order in Hikashop or the frontend removal in Hikamarket (Front End). I do not use HS (Professional 2.6.3) for commercial purposes, but actually as a core for a corporate environment which provides different types of clothing and special pieces of equipment to various categories of personnel, which are associated with a system of credits specific in time and value to each category, and this calls for a lot of database activity. Thank you. Bruno Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMxLWRldmVsb3BtZW50Lzg4NTk1NC12aWV3cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 10 years 2 months ago [\#247356](#247356) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Views](/forum/31-development/885954-views#247356 "Dear all, I make use of views mainly to call MySQL procedures, which is an impressive facility. However I can't seem to find the view associated with the backend removal of products from an order in Hikashop or the frontend removal in Hikamarket (Front End). I do not use HS (Professional 2.6.3) for commercial purposes, but actually as a core for a corporate environment which provides different types of clothing and special pieces of equipment to various categories of personnel, which are associated with a system of credits specific in time and value to each category, and this calls for a lot of database activity. Thank you. Bruno")* Hi, For HikaShop, the delete button is displayed by the file "show_products" of the view "order" with this code: Code: <a onclick="return window.orderMgr.delProduct(this, <?php echo $product->order_product_id; ?>);" href="<?php echo hikashop_completeLink('order&task=product_delete&order_id='.$this->order->order_id.'&order_product_id='.$product->order_product_id); ?>"><img src="<?php echo HIKASHOP_IMAGES; ?>delete.png" alt="<?php echo JText::_('HIKA_DELETE'); ?>"/></a> But there is no view for after you click on the button. It just redisplays the view file. So if you want to add processing when an order product is deleted, you want to create a small plugin of the group hikashop and implement the trigger onAfterOrderUpdate which will give you a variable $order with the products data allowing you to do what you need to do. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMxLWRldmVsb3BtZW50Lzg4NTk1NC12aWV3cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[bmmleroy](/forum/user/36879-bmmleroy "View bmmleroy's Profile")** - [![bmmleroy's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36879-bmmleroy "View bmmleroy's Profile") Topic Author - [ Offline](/forum/user/36879-bmmleroy) Less More - Posts: 6 - Thank you received: 1 - - 10 years 2 months ago [\#247404](#247404) by [bmmleroy](/forum/user/36879-bmmleroy "View bmmleroy's Profile") Replied by *[bmmleroy](/forum/user/36879-bmmleroy "View bmmleroy's Profile")* on topic *[Views](/forum/31-development/885954-views#247404 "Dear all, I make use of views mainly to call MySQL procedures, which is an impressive facility. However I can't seem to find the view associated with the backend removal of products from an order in Hikashop or the frontend removal in Hikamarket (Front End). I do not use HS (Professional 2.6.3) for commercial purposes, but actually as a core for a corporate environment which provides different types of clothing and special pieces of equipment to various categories of personnel, which are associated with a system of credits specific in time and value to each category, and this calls for a lot of database activity. Thank you. Bruno")* Thank you very much Nicolas, I suspected as much but I wanted to be 100% sure. I guess I'll have to roll up my sleeves and have a go at creating a plugin. As a temporary solution I have created triggers on hikashop_order_product to call the procedures in question, which works fine, but I would prefer to have them explicitly called from hikashop and database triggers are understandably not encouraged by our IT people running our servers. Thanks again. Bruno Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMxLWRldmVsb3BtZW50Lzg4NTk1NC12aWV3cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 10 years 2 months ago [\#247414](#247414) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Views](/forum/31-development/885954-views#247414 "Dear all, I make use of views mainly to call MySQL procedures, which is an impressive facility. However I can't seem to find the view associated with the backend removal of products from an order in Hikashop or the frontend removal in Hikamarket (Front End). I do not use HS (Professional 2.6.3) for commercial purposes, but actually as a core for a corporate environment which provides different types of clothing and special pieces of equipment to various categories of personnel, which are associated with a system of credits specific in time and value to each category, and this calls for a lot of database activity. Thank you. Bruno")* Hi, That's right, a plugin will be more appropriate for that specific task. Both HikaShop and HikaMarket are re-saving the order when removing a product. The order object have "product" set with a 0 quantity. You can for example find in HikaMarket : Code: $order_product->order_product_quantity = 0; $order->product = array( $order_product ); So thanks to the trigger onAfterOrderUpdate ; you can check if the order object have that "product" variable and analyze the content. If you found one product with a 0 quantity, you can know that the product have been removed from the order. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMxLWRldmVsb3BtZW50Lzg4NTk1NC12aWV3cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[bmmleroy](/forum/user/36879-bmmleroy "View bmmleroy's Profile")** - [![bmmleroy's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36879-bmmleroy "View bmmleroy's Profile") Topic Author - [ Offline](/forum/user/36879-bmmleroy) Less More - Posts: 6 - Thank you received: 1 - - 10 years 2 months ago [\#247440](#247440) by [bmmleroy](/forum/user/36879-bmmleroy "View bmmleroy's Profile") Replied by *[bmmleroy](/forum/user/36879-bmmleroy "View bmmleroy's Profile")* on topic *[Views](/forum/31-development/885954-views#247440 "Dear all, I make use of views mainly to call MySQL procedures, which is an impressive facility. However I can't seem to find the view associated with the backend removal of products from an order in Hikashop or the frontend removal in Hikamarket (Front End). I do not use HS (Professional 2.6.3) for commercial purposes, but actually as a core for a corporate environment which provides different types of clothing and special pieces of equipment to various categories of personnel, which are associated with a system of credits specific in time and value to each category, and this calls for a lot of database activity. Thank you. Bruno")* Thank you Jerome for this precision, it's all beginning to fall into place now. Bàt, Bruno Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMxLWRldmVsb3BtZW50Lzg4NTk1NC12aWV3cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[bmmleroy](/forum/user/36879-bmmleroy "View bmmleroy's Profile")** - [![bmmleroy's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36879-bmmleroy "View bmmleroy's Profile") Topic Author - [ Offline](/forum/user/36879-bmmleroy) Less More - Posts: 6 - Thank you received: 1 - - 10 years 2 months ago [\#247638](#247638) by [bmmleroy](/forum/user/36879-bmmleroy "View bmmleroy's Profile") Replied by *[bmmleroy](/forum/user/36879-bmmleroy "View bmmleroy's Profile")* on topic *[Views](/forum/31-development/885954-views#247638 "Dear all, I make use of views mainly to call MySQL procedures, which is an impressive facility. However I can't seem to find the view associated with the backend removal of products from an order in Hikashop or the frontend removal in Hikamarket (Front End). I do not use HS (Professional 2.6.3) for commercial purposes, but actually as a core for a corporate environment which provides different types of clothing and special pieces of equipment to various categories of personnel, which are associated with a system of credits specific in time and value to each category, and this calls for a lot of database activity. Thank you. Bruno")* Hi Jerome and Nicolas, You were absolutely right, plugins **are** the perfect solution for solving my peripheral database issues. In particular, the fact that parameters from the order object can be passed on to the stored procedures (for example $order->order_user_id) makes these a lot more efficient in terms of execution time. Thanks again. Bàt, Bruno The following user(s) said Thank You: [Jerome](/forum/user/80-jerome "View Jerome's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMxLWRldmVsb3BtZW50Lzg4NTk1NC12aWV3cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[bmmleroy](/forum/user/36879-bmmleroy "View bmmleroy's Profile")** - [![bmmleroy's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36879-bmmleroy "View bmmleroy's Profile") Topic Author - [ Offline](/forum/user/36879-bmmleroy) Less More - Posts: 6 - Thank you received: 1 - - 10 years 2 months ago [\#247909](#247909) by [bmmleroy](/forum/user/36879-bmmleroy "View bmmleroy's Profile") Replied by *[bmmleroy](/forum/user/36879-bmmleroy "View bmmleroy's Profile")* on topic *[Views](/forum/31-development/885954-views#247909 "Dear all, I make use of views mainly to call MySQL procedures, which is an impressive facility. However I can't seem to find the view associated with the backend removal of products from an order in Hikashop or the frontend removal in Hikamarket (Front End). I do not use HS (Professional 2.6.3) for commercial purposes, but actually as a core for a corporate environment which provides different types of clothing and special pieces of equipment to various categories of personnel, which are associated with a system of credits specific in time and value to each category, and this calls for a lot of database activity. Thank you. Bruno")* Hi, Is there any particular reason why trigger function 'onBeforeOrderDelete' does not appear in your documentation? Can you confirm that this is just an documentary oversight and that deprecating this function is not under consideration? I use it in a plugin, and it works like a charm. Thank you, Bruno Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMxLWRldmVsb3BtZW50Lzg4NTk1NC12aWV3cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 10 years 2 months ago [\#247911](#247911) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Views](/forum/31-development/885954-views#247911 "Dear all, I make use of views mainly to call MySQL procedures, which is an impressive facility. However I can't seem to find the view associated with the backend removal of products from an order in Hikashop or the frontend removal in Hikamarket (Front End). I do not use HS (Professional 2.6.3) for commercial purposes, but actually as a core for a corporate environment which provides different types of clothing and special pieces of equipment to various categories of personnel, which are associated with a system of credits specific in time and value to each category, and this calls for a lot of database activity. Thank you. Bruno")* Hi, The developer documentation is not up to date. You can be sure that this specific trigger is not about to be removed due to the fact it is used by several plugins and components. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMxLWRldmVsb3BtZW50Lzg4NTk1NC12aWV3cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[bmmleroy](/forum/user/36879-bmmleroy "View bmmleroy's Profile")** - [![bmmleroy's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/36879-bmmleroy "View bmmleroy's Profile") Topic Author - [ Offline](/forum/user/36879-bmmleroy) Less More - Posts: 6 - Thank you received: 1 - - 10 years 2 months ago [\#247975](#247975) by [bmmleroy](/forum/user/36879-bmmleroy "View bmmleroy's Profile") Replied by *[bmmleroy](/forum/user/36879-bmmleroy "View bmmleroy's Profile")* on topic *[Views](/forum/31-development/885954-views#247975 "Dear all, I make use of views mainly to call MySQL procedures, which is an impressive facility. However I can't seem to find the view associated with the backend removal of products from an order in Hikashop or the frontend removal in Hikamarket (Front End). I do not use HS (Professional 2.6.3) for commercial purposes, but actually as a core for a corporate environment which provides different types of clothing and special pieces of equipment to various categories of personnel, which are associated with a system of credits specific in time and value to each category, and this calls for a lot of database activity. Thank you. Bruno")* Thanks Jerome. Bon weekend. Bruno Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMxLWRldmVsb3BtZW50Lzg4NTk1NC12aWV3cz90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.330 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)