datetime - Solr: Opening hours, whats open now -

-

i have looked around everywhere, not find single place gives answer, there many places ideas shared no actual end end example/solution given.

what need simple, have bunch of restaurants have opening hours each restaurant have different opening hours in day (i.e open 9-11, 13-15 , maybe 18-21) each place have different schedule per days of week, lets on weekends , wednesdays half day.

my data in db stored below:

|restaurant id| day of week | open time  |close time| |pizza123     | 1           | 0800       | 1100     | |pizza123     | 1           | 1300       | 1500     | |pizza123     | 1           | 1700       | 2100     | |pizza123     | 2           | 0800       | 1500     | |pizza123     | 2           | 1800       | +0200    | .......

from read need consider solrs spatialfortimedurations, explains me following:

  1. i store opening time x
  2. i store closing time y
  3. which expressed x y (x space y)
  4. i supply these values string solr
  5. these values should supplied field of type solr.spatialrecursiveprefixtreefieldtype

this far have gotten.

below questions:

what day of week? solves problem opening/closing hours

how query place thats open "now"?

how query place open next hour or tomorrow noon?

how deal opening hours span across 2 days, see last example in sample db table above.

please share sample queries can wrap head around

please let me know there else missing

many thanks

so have managed resolve this, interested answer can found here http://wiki.apache.org/solr/daterangefield


Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5);
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:
Read more