laravel - Eloquent filtering of nested -

-

I have such a DB format: 

  user + id + email + password profile + ID + owner + ID (FK user.id) + Type_ID (FK type ID) + Address_ID (FK address.ID) + org_name + + + phone + email + url etc. posting + ID + profile_id (FK profile id) + title + Description Address + ID + Road + City + Province_ID (FK Provinces ID) + Country_ID (FK country.id) etc. Country ID + No Trying to use a well-known ORM to know a set of posting based on type_id, city, country_id and / or province_ad + m province + id + name + abbreviated country id

I am here. These fields are subordinate objects on $ posting-> profiles-> addresses, etc.

Do I want to downgrade my debut - merge the address data into it to streamline the profile? Or, what is one way to do this without having to do all of my data without remodeling?

Assume that you have defined address for profile Regarding connection to , 

  $ posts = posting :: with (['profile' = & gt; function ($ query) usage ($ type_id) {$ query- & gt; UseTypeId ($ type_id)}, 'profile.address' = & gt; function ($ query) ($ country_id, $ province_id) {$ query- & gt; Where COUNTountId ($ country_id) - & gt; Where Travers ID $ Province_id);}]) - & gt; get ();

Comments

Post a Comment

Popular posts from this blog

java - org.apache.http.ProtocolException: Target host is not specified -

-
I have written a simple httprequest / response code and I am getting this error below: I used to type in my classpath httpclient, httpcore, common -Codecs and general logging. I am very new to Java and I do not know what's going on here. Please help me. code: import org.apache.http.client.HttpClient; Import org.apache.http.client.methods.HttpGet; Import org.apache.http.HttpResponse; Import org.apache.http.impl.client.HttpClientBuilder; Import org.apache.http.Header; Import org.apache.http.HttpHeaders; Public class UnshorteningUrl {public static zero main (string [] args throws exception {HttpGet request = zero; HTTP Client Client = HTTP ClientBuilder.credit (). Build (); Try {Request = New HTTP Gate ("trib.me/1lBFzSi"); HttpResponse httpResponse = client.execute (request); Header [] header = httpResponse.getHeaders (HttpHeaders.LOCATION); // Preconditions.checkState (headers.length == 1); String new url = header [0] .getValue (); System.out.println ("new url...
Read more

c# - Chart control: Design messed Up after clearing and re-adding Y-Values -

-
Image
The day was struggling with this. I have three series on a chart that looks like this. Note: I am using vanof control. They are being added on the basis of input from the calculation. I am using this code to add value to each series. this.chart1.Series ["green"]. Points. AddY (greenvalue); This.chart1.Series ["totalsaving"] Points.AddY (totalsavingvalue). This.chart1.Series ["blue"] Points.AddY (bluevalue). I have set series properties like this. Both green and totalsaving are set to StackedColumn, the blue chart is set to the column for type. I started then To do is a button that brings the user back to the input field and then I am using this code to clear the series values ​​on the start code. chart 1. Series ["totaling"]. Points. clear (); Chart1.Series ["green"] Points.Clear () .; Chart1.Series ["blue"] Points.Clear () .; The same calculation click above is being calculated for the calculation of th...
Read more

ruby on rails - Apipie interferes with proper error codes -

-
I can not find this little bit in the API's docs. Let me make this special AP ready, and I thought I would document it with APP, all fine and dandy, and the ultimate verification is good, but I feel that the response to failure in verification I can not seem to throw the right HTTP code in For example, I have this post / user method, which obviously makes the user in my database good, right? Well, this is something wrong, and it's ok, but if, say, I throw the standards that it does not pass the validity of the apipie, chops apipies and throws a good old-fashioned error, if something is wrong, 422 responds with a fixed unit failure / error: post '/users.json' ,: user = & gt; D Apipie :: ParamInvalid: Invalid parameter 'Email' value "": Regular expression / [a-zA-Z0-9 will match - -] + \ @ [a-zA-Z0-9 \ -.] + \. [Az] {2,} /. # ./spec/requests/usersapi_spec.rb:66:in `In Block (Level 3) & lt; Top (required) & gt; ' Let me assume ...
Read more