Pickup and Delivery Datetime ticket custom Field

[mr_louis_simion]

Hi,
I am setting up for food retail two branches. Please i need urgent help in moving on with the setup since i have one week to finish setting up.
Steps :
1- I installed SambaPOS v4
2- I installed SQL Server Express
3- In SambaPOS v4 Local Settings I have setup the Connection string to the SQL db and it is connected.
4- I created few Products and few categories.

To Move On:
I need to setup PickUp with pickup time that is needed to appear in the ticket list.
I need to have Delivery setup also with delivery time.
Please Can someone inform me of the steps to follow and have them setup properly

[JTRTech]

I’d start with the delivery tutorial emre posted last week to form the core of the setup;

Custom Package Delivery for V5

This tutorial is a re-implementation for V3 Custom Delivery Tutorial. You need to install at least 5.1.55 Version. In this tutorial I’ll show you how to implement a custom package delivery system. This implementation will allow you to assign tickets to deliverers and track waiting / delivered items. ##Preparing Deliverers We’ll start by creating a new Entity Type for Deliverers. [image] When we create a new Entity Type we can assign them to Tickets. That definition tells…

[mr_louis_simion]

Thanks I will do that. I now uninstalled SQL 2012 and SambaPOS4 and will install SambaPOS v5 trial and SQL 2014 and move on from there because i plan to buy to SambaPos v5. I ll start with setting up delivery for that Thank you JTRTech. I ll change the main topic description later on the steps i undergo.

[JTRTech]

For what your planning the latest v5 would be a must, many features which will be perfect for you.
With a bit of adjustment/help you could also use the google address lookup and delivery route planner others have used

[mr_louis_simion]

I want to have for each Ticket DateTime custom mandatory input field when creating the ticket. I would need to have this field in the search fields when i display ticket list in Ticket Screen. How can I do that? Thanks for the previous help @JTRTech.

[JTRTech]

You want to change the ticket date on ticket creation?
Mind if I ask why?

There is an action for that - Update Ticket Date.
Could possibly use a [?Prompt] but expect you are likely get potential issues - be sure to set a mask for starters.
If you explain what your trying to do there may be a better way as think [?Prompt] could be problematic.
Need more info to offer better solution.

[mr_louis_simion]

Oh No, maybe my question was not that clear.
I want to have for each ticket PickUp or Delivery (DateTime). Since my clients might call and ask for an order and that they wanted delivered at a certain date at a specific time. So I definitely dont want to touch the Ticket Creation Date but i want to have for each ticket when opening to attach DateTime. Later on this dateTime field i want to use it to see my pending tickets in Tickets List or a custom Search Screen so i can plan for the items in my orders and how to start doing them.

[JTRTech]

Ok,
You will have a few options for that, ticket tag would probably be the best option so its nice and clearly visible on the ticket and can be input in to templates etc.
The [?Prompt] would be an option or depending on how specific you wanted to be you could have an automation command value list of options like each hour and half past the hour etc…

[mr_louis_simion]

Adding Tag works Fine and using the regular expression: in the rule to give 2015-12-31 23:59

(((\d\d)(([02468][048])|([13579][26]))-02-29)|(((\d\d)(\d\d)))-((((0\d)|(1[0-2]))-((0\d)|(1\d)|(2[0-8])))|((((0[13578])|(1[02]))-31)|(((0[1,3-9])|(1[0-2]))-(29|30)))))\s(([01]\d|2[0-3]):([0-5]\d):([0-5]\d))

Thanks.

After Adding the Date Time Tag for my tickets. How can I search a list for a specific date or between two dates (mean List for me open tickets where the Ticket Tag Date is between A and B)

[Jesse]

You could use SQL inside a custom Report to do that. Maybe build a Custom Entity Screen and use Editor Widget with masks for defining date and use a Custom Report Widget to display the desired report which would read the entry from the editor widget into the SQL for the report.

Advanced setup and your probably confused but its possible. I recommend looking at the time clock tutorials and maybe try the punch editor built by QMcKay for ideas.

[mr_louis_simion]

Any Documentation coz i went to Reports in Manage Module and I didnt see its usual sql syntax .

[Jesse]

Here is custom reports info…

http://www.sambapos.com/wiki/doku.php/custom_reporting

@mr_louis_simion

Any Documentation coz i went to Reports in Manage Module and I didnt see its usual sql syntax .

Most custom reports dont use SQL they use Custom Report Tags. SQL is an option however and it can be more flexible because your not limited by the tags. Custom Report Tags are easier and can cover most situations but for what you want to do you probably need SQL and some jscript.

SQL is not a SambaPOS feature but Custom Reports supports SQL. To learn SQL you should probably google SQL or look up some SQL tutorials with Google. You should probably also use MSSMS to look at and learn the Database Tables and how they interact so you can use SQL to get what you want.

[mr_louis_simion]

Thank you I can manage with SQL syntax.
I have seen that i can have a screen that displays a report.
I want to have on that screen the filter criteria input and according to that criteria i want to execute my sql and display the table on screen. Is that Possible to do?
Its like custom Search Screen

[mr_louis_simion]

I am aiming at having a report with start date and end date as search criteria and display grouped by date(from Ticket Tag delivery Date)Items without having (modifiers or order tags added)
and another report displaying grouped by date(from Ticket Tag delivery Date)Items that have (modifiers or order tags added)

[mr_louis_simion]

Edit: Database Removed (Emre)

Hi,
I have attached database with configuration for sambapos v5
Admin Login: 1234

The restaurant is Delivery or Pick up (where the orders are usually taken by phone prior than the pickup date)
Product with Modifiers: Salads.
I have created the Delivery module.
I have two Ticket Types, Ticket and Delivery Ticket.
I added Date Time as Ticket Tag to specify for each ticket.

I still need to be able to create my custom report screen according to the Pickup/Delivery DAte Time and ability to filter the products that dont have any Modifier Tags.

Please can someone have a look at my system if its setup fine and practical to work on. The two branch restaurant is opening next week and i guess i wont be able to set everything properly without help.

I ordered a 25" touch screen i7 16GBRAM Windows 10 desktop to be used as the server and the terminal. After i get it i will start working on setting up normal laser printer to print my reports and tickets. I will also start working on setting up access to tablets and have the other store branch connecting to this.

Please if someone can validate what i have done and proper to use. Thanks

[emre]

I’ve removed your database backup.

Please don’t share your database backup unless requested by forum staff and only send via PM.

Thanks.

[emre]

See this post for creating a report that works by delivery date.

Custom Reports - Filtering by date of Ticket Tag

Hi Everyone, I’ve been working on a home delivery system within SambaPOS for a cafe who takes orders a few days prior to delivery of the order. A big big thanks to @Jesse for the guidance to help me pass existing barriers. I’m now at the stage where i’m building a custom report to allow staff to print a report of upcoming orders. I have a ticket tag called DeliveryDate that contains the date of delivery. I was hoping to be able to filter by this tag on the Report screen so staff can select the…

This post demonstrates creating a custom screen. See Passing parameters to Custom Report Viewer Widget section.

SambaPOS 5.1.48 - 5.1.49 features

5.1.49 Download: http://sambapos.com/?wpfb_dl=130 I’m releasing 5.1.49 earlier than planned to fix that issue ##New 5.1.49 Features Data Export configuration accepts file name templates. If I use star character (*) as a file name placeholder, default folder and default extension will determined from template. For example: If I configure file name as C:\Users\Emre\Documents\SambaPOS5\*.xml Save File Dialog will appear as… [image] ##New 5.1.48 features Hide Header setting added to Navi…

This post also demonstrates some related features.

SambaPOS 5.1.50 Release

New date ticket tag handling and report filtering features. [image] As you know we can type report date ranges next to report names in Report Display Widget. These date ranges are Today, Yesterday, This Week, Next Week, This Month, Next Month. As shown on the report tool. Last x Days and Next x Days range names added to these ranges. TTDR expression (ticket tag date range) added. So you can filter tickets tag date values in report expressions. When used together with above feature we can…