[Skip to main content](#vessel-content)
# Profile for nkelkar
##
[](/forum/user/5012-nkelkar "View nkelkar's Profile")
**[ Offline](/forum/user/5012-nkelkar)**
- **User Type:** User
- **Register Date:** 11 Dec 2011
- **Last login:** 12 years 7 months ago
- **Time Zone:** UTC +0:00
- **Local Time:** 14:43
- **Posts:** 7
- **Profile views:** 237
- **Thank you received:** 1
- **Location:** [Calgary, Canada](https://maps.google.com?q=Calgary,%20Canada)
- **Gender:** Male
- **Birthdate:** Unknown
- Posts
# nkelkar's recent posts (7 messages )
All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year All Since last visit 4 Hours 8 Hours 12 Hours 24 Hours 48 Hours Week Month Year
| [ ](#forumbottom) | Subject | Replies / Views | Last Post | [ ](#forumtop) |
|---|---|---|---|---|
| [](/forum/3-bug-report/67820-upgrade-issue-from-business-1-5-5-to-1-6-0#67985) | [Upgrade issue from Business 1.5.5 to 1.6.0](/forum/3-bug-report/67820-upgrade-issue-from-business-1-5-5-to-1-6-0#67985 "Hello We have a Joomla 1.7.3, which I was able to upgrade to Joomla 2.5.7 (on GoDaddy linux hosting, in a Test environment, Production is untouched as of now) Worth mentioning, that we still have unti 12 Dec 2012 for our yearly support to expire. :laugh: I also wanted to upgrade the HikaShop Business Edition, currently at 1.5.5 sitting on Joomla 2.5.7 - THIS WORKS FINE TOO in the Test environment. Issue is when I download the zip file "com_hikashop_business_1.6.0_2012-09-28" and try to install via Extension Manager, thats when the failure starts. 500 - An error has occurred. JDatabaseMySQL::query: 1060 - Duplicate column name 'cart_type' SQL=ALTER TABLE `josweb_hikashop_cart` ADD `cart_type` varchar(25) NOT NULL DEFAULT 'cart', ADD `cart_name` varchar(50) NOT NULL, ADD `cart_share` varchar(255) NOT NULL DEFAULT 'nobody', ADD `cart_current` INT NOT NULL DEFAULT '0' Attached is a screenshot - hijashop-error.PNG At this point, the front end cart will not work - when I try to add something, an "undefined" shows up in the Cart module. Also if I try to add a HikaShop menu item, the text is incorrect - see attached hikashop-error-menu.PNG I tried searching in the forums for someone with similar issues, but cannot find anything. This seems to be a bug? Pointer? Regards, NK") Category: [Bug Report](/forum/3-bug-report "Please report any bugs or errors here.") Topic started 14 years 1 month ago, by [nkelkar](/forum/user/5012-nkelkar "View nkelkar's Profile") [Last Post](/forum/3-bug-report/67820-upgrade-issue-from-business-1-5-5-to-1-6-0#67985 "Those steps fixed the issue. Thanks. Now I am able to move to the upgraded versions, not just for Joomla 2.5.7, but the Hikashop Busines 1.6.0 as well Regards NK") 14 years 4 weeks ago by [nkelkar](/forum/user/5012-nkelkar "View nkelkar's Profile") | Replies:2 Views:2375 | [Last Post](/forum/3-bug-report/67820-upgrade-issue-from-business-1-5-5-to-1-6-0#67985 "Those steps fixed the issue. Thanks. Now I am able to move to the upgraded versions, not just for Joomla 2.5.7, but the Hikashop Busines 1.6.0 as well Regards NK") by [nkelkar](/forum/user/5012-nkelkar "View nkelkar's Profile") 14 years 4 weeks ago |
| [](/forum/3-bug-report/67820-upgrade-issue-from-business-1-5-5-to-1-6-0#67820) | [Upgrade issue from Business 1.5.5 to 1.6.0](/forum/3-bug-report/67820-upgrade-issue-from-business-1-5-5-to-1-6-0#67820 "Hello We have a Joomla 1.7.3, which I was able to upgrade to Joomla 2.5.7 (on GoDaddy linux hosting, in a Test environment, Production is untouched as of now) Worth mentioning, that we still have unti 12 Dec 2012 for our yearly support to expire. :laugh: I also wanted to upgrade the HikaShop Business Edition, currently at 1.5.5 sitting on Joomla 2.5.7 - THIS WORKS FINE TOO in the Test environment. Issue is when I download the zip file "com_hikashop_business_1.6.0_2012-09-28" and try to install via Extension Manager, thats when the failure starts. 500 - An error has occurred. JDatabaseMySQL::query: 1060 - Duplicate column name 'cart_type' SQL=ALTER TABLE `josweb_hikashop_cart` ADD `cart_type` varchar(25) NOT NULL DEFAULT 'cart', ADD `cart_name` varchar(50) NOT NULL, ADD `cart_share` varchar(255) NOT NULL DEFAULT 'nobody', ADD `cart_current` INT NOT NULL DEFAULT '0' Attached is a screenshot - hijashop-error.PNG At this point, the front end cart will not work - when I try to add something, an "undefined" shows up in the Cart module. Also if I try to add a HikaShop menu item, the text is incorrect - see attached hikashop-error-menu.PNG I tried searching in the forums for someone with similar issues, but cannot find anything. This seems to be a bug? Pointer? Regards, NK") Category: [Bug Report](/forum/3-bug-report "Please report any bugs or errors here.") Topic started 14 years 1 month ago, by [nkelkar](/forum/user/5012-nkelkar "View nkelkar's Profile") [Last Post](/forum/3-bug-report/67820-upgrade-issue-from-business-1-5-5-to-1-6-0#67985 "Those steps fixed the issue. Thanks. Now I am able to move to the upgraded versions, not just for Joomla 2.5.7, but the Hikashop Busines 1.6.0 as well Regards NK") 14 years 4 weeks ago by [nkelkar](/forum/user/5012-nkelkar "View nkelkar's Profile") | Replies:2 Views:2375 | [Last Post](/forum/3-bug-report/67820-upgrade-issue-from-business-1-5-5-to-1-6-0#67985 "Those steps fixed the issue. Thanks. Now I am able to move to the upgraded versions, not just for Joomla 2.5.7, but the Hikashop Busines 1.6.0 as well Regards NK") by [nkelkar](/forum/user/5012-nkelkar "View nkelkar's Profile") 14 years 4 weeks ago |
| [](/forum/17-serial-how-to/59326-re-seat-number-how-to#59536) | [Re: Seat Number How To](/forum/17-serial-how-to/59326-re-seat-number-how-to#59536 "Hello We have a Hikashop Business Edition, and need to add a "seat number" feature to the existing product/catalog. We are non-profit. I read through the documentation for HikaSerail, but was unable to locate exactly how to implement my requirement. So here is the requirement first. Ordinarily for events such as "New Year Celebration", "Summer Picnic", etc, we create just basic 'Adult', 'Child' and 'Senior' tickets at different costs, say $15, $5 and $10 each. Users login, add to cart what they want, and checkout through PayPal. Works just fine. We have an upcoming Stage Performace, and we need to sell tickets. Whats different here is, this event is obviously going to take place in a Theatre with pre defined seats. Seats 1,2,3,4,5,6,7,8,9,10 are VIP seats Seats 11,12,13,14,15,16,17,18,19,20 are EXECUTIVE seats Seats 21, 22, 23, 24, 25, 26, 27, 28, 29, 30 are GENERAL admission seats. We want users to PICK which seat they are buying, say I want to buy 3 x EXECUTIVE seats, I should have the option of picking 11, 12, 13. When I complete my order (or through some status), then those 11, 12, 13 should not be offered for other users. ** In reality there are about 200 seats available, and we will be creating three categories as above, extrapolating my scenario from 30 seats to 200 seats ** How can I achieve this through Hika Serial - or is it too much to ask? Regards NKELKAR") Category: [Serial: How to?](/forum/17-serial-how-to "If you didn't find the answer on our documentation neither on existing posts, please ask your question about HikaSerial here.") Topic started 14 years 2 months ago, by [nkelkar](/forum/user/5012-nkelkar "View nkelkar's Profile") [Last Post](/forum/17-serial-how-to/59326-re-seat-number-how-to#100000429 "Hi, For anyone reading this: picking seats like at a theatre is now possible with the plugin. You draw the hall once from its picture (rows, seat numbers, price zones such as VIP or general), and visitors choose their seats on the plan for each show; the seats are held in their cart for a few minutes while they check out. With HikaSerial, the "Seat ticket" generator that comes with the plugin gives one code per seat sold, holding the show, the date, the row and the seat number, ready to print as a QR code on a PDF ticket. There is a demo with our template: mezzanine.demo.hikashop.com/ It needs the and plugins, and HikaShop Business") 1 hour 51 minutes ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:6 Views:2241 | [Last Post](/forum/17-serial-how-to/59326-re-seat-number-how-to#100000429 "Hi, For anyone reading this: picking seats like at a theatre is now possible with the plugin. You draw the hall once from its picture (rows, seat numbers, price zones such as VIP or general), and visitors choose their seats on the plan for each show; the seats are held in their cart for a few minutes while they check out. With HikaSerial, the "Seat ticket" generator that comes with the plugin gives one code per seat sold, holding the show, the date, the row and the seat number, ready to print as a QR code on a PDF ticket. There is a demo with our template: mezzanine.demo.hikashop.com/ It needs the and plugins, and HikaShop Business") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 hour 51 minutes ago |
| [](/forum/17-serial-how-to/59326-re-seat-number-how-to#59394) | [Re: Seat Number How To](/forum/17-serial-how-to/59326-re-seat-number-how-to#59394 "Hello We have a Hikashop Business Edition, and need to add a "seat number" feature to the existing product/catalog. We are non-profit. I read through the documentation for HikaSerail, but was unable to locate exactly how to implement my requirement. So here is the requirement first. Ordinarily for events such as "New Year Celebration", "Summer Picnic", etc, we create just basic 'Adult', 'Child' and 'Senior' tickets at different costs, say $15, $5 and $10 each. Users login, add to cart what they want, and checkout through PayPal. Works just fine. We have an upcoming Stage Performace, and we need to sell tickets. Whats different here is, this event is obviously going to take place in a Theatre with pre defined seats. Seats 1,2,3,4,5,6,7,8,9,10 are VIP seats Seats 11,12,13,14,15,16,17,18,19,20 are EXECUTIVE seats Seats 21, 22, 23, 24, 25, 26, 27, 28, 29, 30 are GENERAL admission seats. We want users to PICK which seat they are buying, say I want to buy 3 x EXECUTIVE seats, I should have the option of picking 11, 12, 13. When I complete my order (or through some status), then those 11, 12, 13 should not be offered for other users. ** In reality there are about 200 seats available, and we will be creating three categories as above, extrapolating my scenario from 30 seats to 200 seats ** How can I achieve this through Hika Serial - or is it too much to ask? Regards NKELKAR") Category: [Serial: How to?](/forum/17-serial-how-to "If you didn't find the answer on our documentation neither on existing posts, please ask your question about HikaSerial here.") Topic started 14 years 2 months ago, by [nkelkar](/forum/user/5012-nkelkar "View nkelkar's Profile") [Last Post](/forum/17-serial-how-to/59326-re-seat-number-how-to#100000429 "Hi, For anyone reading this: picking seats like at a theatre is now possible with the plugin. You draw the hall once from its picture (rows, seat numbers, price zones such as VIP or general), and visitors choose their seats on the plan for each show; the seats are held in their cart for a few minutes while they check out. With HikaSerial, the "Seat ticket" generator that comes with the plugin gives one code per seat sold, holding the show, the date, the row and the seat number, ready to print as a QR code on a PDF ticket. There is a demo with our template: mezzanine.demo.hikashop.com/ It needs the and plugins, and HikaShop Business") 1 hour 51 minutes ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:6 Views:2241 | [Last Post](/forum/17-serial-how-to/59326-re-seat-number-how-to#100000429 "Hi, For anyone reading this: picking seats like at a theatre is now possible with the plugin. You draw the hall once from its picture (rows, seat numbers, price zones such as VIP or general), and visitors choose their seats on the plan for each show; the seats are held in their cart for a few minutes while they check out. With HikaSerial, the "Seat ticket" generator that comes with the plugin gives one code per seat sold, holding the show, the date, the row and the seat number, ready to print as a QR code on a PDF ticket. There is a demo with our template: mezzanine.demo.hikashop.com/ It needs the and plugins, and HikaShop Business") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 hour 51 minutes ago |
| [](/forum/17-serial-how-to/59326-re-seat-number-how-to#59326) | [Re: Seat Number How To](/forum/17-serial-how-to/59326-re-seat-number-how-to#59326 "Hello We have a Hikashop Business Edition, and need to add a "seat number" feature to the existing product/catalog. We are non-profit. I read through the documentation for HikaSerail, but was unable to locate exactly how to implement my requirement. So here is the requirement first. Ordinarily for events such as "New Year Celebration", "Summer Picnic", etc, we create just basic 'Adult', 'Child' and 'Senior' tickets at different costs, say $15, $5 and $10 each. Users login, add to cart what they want, and checkout through PayPal. Works just fine. We have an upcoming Stage Performace, and we need to sell tickets. Whats different here is, this event is obviously going to take place in a Theatre with pre defined seats. Seats 1,2,3,4,5,6,7,8,9,10 are VIP seats Seats 11,12,13,14,15,16,17,18,19,20 are EXECUTIVE seats Seats 21, 22, 23, 24, 25, 26, 27, 28, 29, 30 are GENERAL admission seats. We want users to PICK which seat they are buying, say I want to buy 3 x EXECUTIVE seats, I should have the option of picking 11, 12, 13. When I complete my order (or through some status), then those 11, 12, 13 should not be offered for other users. ** In reality there are about 200 seats available, and we will be creating three categories as above, extrapolating my scenario from 30 seats to 200 seats ** How can I achieve this through Hika Serial - or is it too much to ask? Regards NKELKAR") Category: [Serial: How to?](/forum/17-serial-how-to "If you didn't find the answer on our documentation neither on existing posts, please ask your question about HikaSerial here.") Topic started 14 years 2 months ago, by [nkelkar](/forum/user/5012-nkelkar "View nkelkar's Profile") [Last Post](/forum/17-serial-how-to/59326-re-seat-number-how-to#100000429 "Hi, For anyone reading this: picking seats like at a theatre is now possible with the plugin. You draw the hall once from its picture (rows, seat numbers, price zones such as VIP or general), and visitors choose their seats on the plan for each show; the seats are held in their cart for a few minutes while they check out. With HikaSerial, the "Seat ticket" generator that comes with the plugin gives one code per seat sold, holding the show, the date, the row and the seat number, ready to print as a QR code on a PDF ticket. There is a demo with our template: mezzanine.demo.hikashop.com/ It needs the and plugins, and HikaShop Business") 1 hour 51 minutes ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") | Replies:6 Views:2241 | [Last Post](/forum/17-serial-how-to/59326-re-seat-number-how-to#100000429 "Hi, For anyone reading this: picking seats like at a theatre is now possible with the plugin. You draw the hall once from its picture (rows, seat numbers, price zones such as VIP or general), and visitors choose their seats on the plan for each show; the seats are held in their cart for a few minutes while they check out. With HikaSerial, the "Seat ticket" generator that comes with the plugin gives one code per seat sold, holding the show, the date, the row and the seat number, ready to print as a QR code on a PDF ticket. There is a demo with our template: mezzanine.demo.hikashop.com/ It needs the and plugins, and HikaShop Business") by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") 1 hour 51 minutes ago |
| [](/forum/4-how-to/44570-create-order-reports-in-sql-or-otherwise#44630) | [Create Order Reports (in sql or otherwise)](/forum/4-how-to/44570-create-order-reports-in-sql-or-otherwise#44630 "Hi We sell event tickets, and have 2 products - Adult and Child tickets. How can I run a report in SQL (via phpmyadmin) or otherwise to see how many of Adult tickets and Child tickets - basically products - were purchased? I also need a list (group by account name). e.g PersonA brought 2 Adult tickets and 3 Child tickets PersonB brought 5 Adult tickets and 2 Child tickets The report should spit out something like: PersonA - Adult 2 - Child 3 PersonB - Adult 5 - Child 2 Total - Adult 7 - Child 5 This is basically to plan how many people will be attending. Thanks...") Category: [How to?](/forum/4-how-to "If you didn't find the answer on our documentation neither on existing posts, please ask your question here.") Topic started 14 years 7 months ago, by [nkelkar](/forum/user/5012-nkelkar "View nkelkar's Profile") [Last Post](/forum/4-how-to/44570-create-order-reports-in-sql-or-otherwise#44630 "I had to do this on a bit of an emergency notice. Its great to have an ERD, I simply opened the tables in phpMyAdmin and figured out what I needed. I wll now check the ERD to see if I did something wrong (hopefully not). For others who might be looking to do the same, here are the snippets of code. FIRST, the SQL Query that will get Count of the Quantities. So I know I sold 'n' number of Adult Tickets and 'y' number of Child Tickets. This is to get a number so we can order food, arrange for appropriate venue, etc. SELECT count(tableprefix_hikashop_order_product.order_product_id) as Orders, tableprefix_hikashop_order_product.order_product_name as Item, sum(tableprefix_hikashop_order_product.order_product_quantity) as Quantity FROM tableprefix_hikashop_order_product INNER JOIN tableprefix_hikashop_order ON tableprefix_hikashop_order_product.order_id=tableprefix_hikashop_order.order_id WHERE tableprefix_hikashop_order.order_status="confirmed" Group By order_product_name SECOND, Details of people attending, and what they purchased (line items from the order_products table). Had to work on some fancy inner joins (4 table join). If you want to limit to some particular products, use something on lines of -- AND tableprefix_hikashop_product.product_name like '%Membership' -- SELECT tableprefix_users.name, tableprefix_users.email, tableprefix_hikashop_order.order_number, DATE_FORMAT(FROM_UNIXTIME(tableprefix_hikashop_order.order_created),'%d/%m/%Y') as created, tableprefix_hikashop_product.product_name as item, tableprefix_hikashop_order_product.order_product_quantity as quantity, tableprefix_hikashop_order_product.order_product_price as unit_price FROM tableprefix_users INNER JOIN tableprefix_hikashop_user ON tableprefix_hikashop_user.user_cms_id=tableprefix_users.id INNER JOIN tableprefix_hikashop_order ON tableprefix_hikashop_order.order_user_id=tableprefix_hikashop_user.user_id INNER JOIN tableprefix_hikashop_order_product ON tableprefix_hikashop_order_product.order_id=tableprefix_hikashop_order.order_id INNER JOIN tableprefix_hikashop_product ON tableprefix_hikashop_product.product_id=tableprefix_hikashop_order_product.product_id WHERE tableprefix_hikashop_order.order_status="confirmed" ORDER BY tableprefix_users.name ASC, tableprefix_hikashop_order.order_created ASC These two reports give me exactly what I was looking for. I embedded them into php, made some nice tables and the reports are available for the event organizers. Hope this helps.") 14 years 7 months ago by [nkelkar](/forum/user/5012-nkelkar "View nkelkar's Profile") | Replies:2 Views:1767 | [Last Post](/forum/4-how-to/44570-create-order-reports-in-sql-or-otherwise#44630 "I had to do this on a bit of an emergency notice. Its great to have an ERD, I simply opened the tables in phpMyAdmin and figured out what I needed. I wll now check the ERD to see if I did something wrong (hopefully not). For others who might be looking to do the same, here are the snippets of code. FIRST, the SQL Query that will get Count of the Quantities. So I know I sold 'n' number of Adult Tickets and 'y' number of Child Tickets. This is to get a number so we can order food, arrange for appropriate venue, etc. SELECT count(tableprefix_hikashop_order_product.order_product_id) as Orders, tableprefix_hikashop_order_product.order_product_name as Item, sum(tableprefix_hikashop_order_product.order_product_quantity) as Quantity FROM tableprefix_hikashop_order_product INNER JOIN tableprefix_hikashop_order ON tableprefix_hikashop_order_product.order_id=tableprefix_hikashop_order.order_id WHERE tableprefix_hikashop_order.order_status="confirmed" Group By order_product_name SECOND, Details of people attending, and what they purchased (line items from the order_products table). Had to work on some fancy inner joins (4 table join). If you want to limit to some particular products, use something on lines of -- AND tableprefix_hikashop_product.product_name like '%Membership' -- SELECT tableprefix_users.name, tableprefix_users.email, tableprefix_hikashop_order.order_number, DATE_FORMAT(FROM_UNIXTIME(tableprefix_hikashop_order.order_created),'%d/%m/%Y') as created, tableprefix_hikashop_product.product_name as item, tableprefix_hikashop_order_product.order_product_quantity as quantity, tableprefix_hikashop_order_product.order_product_price as unit_price FROM tableprefix_users INNER JOIN tableprefix_hikashop_user ON tableprefix_hikashop_user.user_cms_id=tableprefix_users.id INNER JOIN tableprefix_hikashop_order ON tableprefix_hikashop_order.order_user_id=tableprefix_hikashop_user.user_id INNER JOIN tableprefix_hikashop_order_product ON tableprefix_hikashop_order_product.order_id=tableprefix_hikashop_order.order_id INNER JOIN tableprefix_hikashop_product ON tableprefix_hikashop_product.product_id=tableprefix_hikashop_order_product.product_id WHERE tableprefix_hikashop_order.order_status="confirmed" ORDER BY tableprefix_users.name ASC, tableprefix_hikashop_order.order_created ASC These two reports give me exactly what I was looking for. I embedded them into php, made some nice tables and the reports are available for the event organizers. Hope this helps.") by [nkelkar](/forum/user/5012-nkelkar "View nkelkar's Profile") 14 years 7 months ago |
| [](/forum/4-how-to/44570-create-order-reports-in-sql-or-otherwise#44570) | [Create Order Reports (in sql or otherwise)](/forum/4-how-to/44570-create-order-reports-in-sql-or-otherwise#44570 "Hi We sell event tickets, and have 2 products - Adult and Child tickets. How can I run a report in SQL (via phpmyadmin) or otherwise to see how many of Adult tickets and Child tickets - basically products - were purchased? I also need a list (group by account name). e.g PersonA brought 2 Adult tickets and 3 Child tickets PersonB brought 5 Adult tickets and 2 Child tickets The report should spit out something like: PersonA - Adult 2 - Child 3 PersonB - Adult 5 - Child 2 Total - Adult 7 - Child 5 This is basically to plan how many people will be attending. Thanks...") Category: [How to?](/forum/4-how-to "If you didn't find the answer on our documentation neither on existing posts, please ask your question here.") Topic started 14 years 7 months ago, by [nkelkar](/forum/user/5012-nkelkar "View nkelkar's Profile") [Last Post](/forum/4-how-to/44570-create-order-reports-in-sql-or-otherwise#44630 "I had to do this on a bit of an emergency notice. Its great to have an ERD, I simply opened the tables in phpMyAdmin and figured out what I needed. I wll now check the ERD to see if I did something wrong (hopefully not). For others who might be looking to do the same, here are the snippets of code. FIRST, the SQL Query that will get Count of the Quantities. So I know I sold 'n' number of Adult Tickets and 'y' number of Child Tickets. This is to get a number so we can order food, arrange for appropriate venue, etc. SELECT count(tableprefix_hikashop_order_product.order_product_id) as Orders, tableprefix_hikashop_order_product.order_product_name as Item, sum(tableprefix_hikashop_order_product.order_product_quantity) as Quantity FROM tableprefix_hikashop_order_product INNER JOIN tableprefix_hikashop_order ON tableprefix_hikashop_order_product.order_id=tableprefix_hikashop_order.order_id WHERE tableprefix_hikashop_order.order_status="confirmed" Group By order_product_name SECOND, Details of people attending, and what they purchased (line items from the order_products table). Had to work on some fancy inner joins (4 table join). If you want to limit to some particular products, use something on lines of -- AND tableprefix_hikashop_product.product_name like '%Membership' -- SELECT tableprefix_users.name, tableprefix_users.email, tableprefix_hikashop_order.order_number, DATE_FORMAT(FROM_UNIXTIME(tableprefix_hikashop_order.order_created),'%d/%m/%Y') as created, tableprefix_hikashop_product.product_name as item, tableprefix_hikashop_order_product.order_product_quantity as quantity, tableprefix_hikashop_order_product.order_product_price as unit_price FROM tableprefix_users INNER JOIN tableprefix_hikashop_user ON tableprefix_hikashop_user.user_cms_id=tableprefix_users.id INNER JOIN tableprefix_hikashop_order ON tableprefix_hikashop_order.order_user_id=tableprefix_hikashop_user.user_id INNER JOIN tableprefix_hikashop_order_product ON tableprefix_hikashop_order_product.order_id=tableprefix_hikashop_order.order_id INNER JOIN tableprefix_hikashop_product ON tableprefix_hikashop_product.product_id=tableprefix_hikashop_order_product.product_id WHERE tableprefix_hikashop_order.order_status="confirmed" ORDER BY tableprefix_users.name ASC, tableprefix_hikashop_order.order_created ASC These two reports give me exactly what I was looking for. I embedded them into php, made some nice tables and the reports are available for the event organizers. Hope this helps.") 14 years 7 months ago by [nkelkar](/forum/user/5012-nkelkar "View nkelkar's Profile") | Replies:2 Views:1767 | [Last Post](/forum/4-how-to/44570-create-order-reports-in-sql-or-otherwise#44630 "I had to do this on a bit of an emergency notice. Its great to have an ERD, I simply opened the tables in phpMyAdmin and figured out what I needed. I wll now check the ERD to see if I did something wrong (hopefully not). For others who might be looking to do the same, here are the snippets of code. FIRST, the SQL Query that will get Count of the Quantities. So I know I sold 'n' number of Adult Tickets and 'y' number of Child Tickets. This is to get a number so we can order food, arrange for appropriate venue, etc. SELECT count(tableprefix_hikashop_order_product.order_product_id) as Orders, tableprefix_hikashop_order_product.order_product_name as Item, sum(tableprefix_hikashop_order_product.order_product_quantity) as Quantity FROM tableprefix_hikashop_order_product INNER JOIN tableprefix_hikashop_order ON tableprefix_hikashop_order_product.order_id=tableprefix_hikashop_order.order_id WHERE tableprefix_hikashop_order.order_status="confirmed" Group By order_product_name SECOND, Details of people attending, and what they purchased (line items from the order_products table). Had to work on some fancy inner joins (4 table join). If you want to limit to some particular products, use something on lines of -- AND tableprefix_hikashop_product.product_name like '%Membership' -- SELECT tableprefix_users.name, tableprefix_users.email, tableprefix_hikashop_order.order_number, DATE_FORMAT(FROM_UNIXTIME(tableprefix_hikashop_order.order_created),'%d/%m/%Y') as created, tableprefix_hikashop_product.product_name as item, tableprefix_hikashop_order_product.order_product_quantity as quantity, tableprefix_hikashop_order_product.order_product_price as unit_price FROM tableprefix_users INNER JOIN tableprefix_hikashop_user ON tableprefix_hikashop_user.user_cms_id=tableprefix_users.id INNER JOIN tableprefix_hikashop_order ON tableprefix_hikashop_order.order_user_id=tableprefix_hikashop_user.user_id INNER JOIN tableprefix_hikashop_order_product ON tableprefix_hikashop_order_product.order_id=tableprefix_hikashop_order.order_id INNER JOIN tableprefix_hikashop_product ON tableprefix_hikashop_product.product_id=tableprefix_hikashop_order_product.product_id WHERE tableprefix_hikashop_order.order_status="confirmed" ORDER BY tableprefix_users.name ASC, tableprefix_hikashop_order.order_created ASC These two reports give me exactly what I was looking for. I embedded them into php, made some nice tables and the reports are available for the event organizers. Hope this helps.") by [nkelkar](/forum/user/5012-nkelkar "View nkelkar's Profile") 14 years 7 months ago |
[](/forum/topics/feed/mode-topics?format=feed&type=rss)
Time to create page: 0.132 seconds
[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
[](#top)