Laravel 4: left join with where claus not showing none linked rows -


I am trying to create an artisan cron job in Laravel 4 which is available to all the subscribers, who are known for the well-known ORM Should use. I am trying to accomplish that at least one month ago I subscribe to all the consumers who have paid the last time or new subscriptions that were never paid. Even though I only get information from the user table (user 1 and 3), the value of the pay table is 'null', that means that they are not with the limit, although I only want to say 'null' if they have a table There is no value in the payments.

My code: 

  $ ('Payments.user_id', '=', 'user.id') - & gt; ('Payments.paid_on') (payment 'payday_on'), date ("D"), date ("Y"), '& lt; = ', Date (' YMD HH: I: S ', MKTEM (0, 0, 0, Date ("M")) - & gt; Where ('payments.paid_on', '& gt; =', Date ('YMD H: I: S', Mktm (0, 0, 0, Date ("M") -1, Date ("D") - 10, Date ("Y"))));}) - & gt; Where ('user.start', '& lt;', Date ('YMD H: I: S', Time ()) - & Gt; Where ('user.end', '& gt;', Date ('YMD H: I: S', Time ())) - & gt; (Get 'user. *', 'Payments.paid_on']);   
 An example of this data is:  
  (user) ID End start | 1 | 2014-02-24 00:00:00 | 2015-02-24 00:00:00 | 2 | 2012-03-24 00:00:00 | 2013-01-24 00:00 : 00 | | 3 | 2014-03-24 00:00:00 | 2015-03-24 00:00:00 | (payment) user_id Paid_on | 1 | 2014-02-24 00:00:00 | 1 | 2014-03-24 00:00:00 | 2 | 2013-01-24 00:00:00 |   
 I hope that something like this will be done:  < Pre>  | 1 | 2014-02-24 00:00:00 | 2015-02-24 00:00:00 | 1 | 2014-03-24 00:00:00 | 3 | 2014-03- 24 00:00:00 | 2015-03-24 00:00:00 |    
 
 
 Do not know that I have come to the right conclusion But this is what I have ended, check above whether the value exists in the right table where the block and if I did not check whether there is one for zero, the code is here:  
  $ payments = user: left zones ('payment', 'user.id', '=', 'payments.user_id') - & gt; Where ('User (' UMD HK: I: S ', Time ()) - & gt; Where ('user.and', '& gt;', date ('YMD HK: I: S', time ()) -> where (function ($ query) {$ query- & gt; where (' Payments.paid_on ',' & lt; = ', Date (' Ymd H: i: s', mktime (0, 0, 0, Date ("m") - 1, Date ("D"), Date (" Y ')))) - where (' payments.paid_on ',' & gt; = ', date (' YMD H: I: S ', mktm (0, 0, 0, date ("m") - 1, date ("D") - 5, date ("Y"))) -> ($ OrQuery) {$ orQuery-> where tap ('payments.paid');}); } - & gt; Receive (['Users. *', 'Payments.paid_on']);

Comments

Post a Comment

Popular posts from this blog

Java - Error: no suitable method found for add(int, java.lang.String) -

I'm in the middle of homework work and I'm stuck. At this point in my code, I think that I should have a GUI window that opens and allows me to type "inserted text number". Notice is not going anywhere but at this point, If I pass through the problem then it will be in a linked list. I am getting two of the same error for the lines. Add (index, element); And I can not seem to get past it, there is no suitable method for the error "add (int, java. string string)". Code is below, please advise. To clarify - this will not be a method error because it is a linked list. There should not be any way involved. import java.awt. *; Import java.awt.event. *; Import javax.swing. *; Import java.util. *; Import java.util.Scanner; Import java.util.LinkedList; Public class TopTenList JFrame {Private TopTenList tt; See the Private JTextArea list; Private JTextField cmdTextField; Private JTextField resultsTestfield; // This GUI window is the code for the public toptist...
Read more

java - JPA TypedQuery: Parameter value element did not match expected type -

I am using JPA 2.0 and getting the following code in the DAO layer: Public Zero Test () {string key = "status"; String [] Conditions = {"A", "B"}; & Lt; TestTable & gt; Results = Search (Keys, Conditions); } Public listing & lt; TestTable & gt; Search (string key, object value error) {string sql = "test ndf to testlet and jade nand." + Key + "in:" + key; TypedQuery & LT; TestTable & gt; Query = entityManager.createQuery (SQL, TestTable.class); Query.setParameter (key, Arrays.asList (valueArr)) / *** Error Line *** Return query.getResultList (); } In the above error line, it throws the following exception: java.lang.IllegalArgumentException: parameter value element [[Ljava.lang.String; @ cbe5bc] did not match the expected type [java.lang.String] Why is this expected type string while actually this string []? Please help! Note: This is derived from the normal routine and is a simplified code. I can no...
Read more

c++ - static template member variable has internal linkage but is not defined -

Yes, I know, there is a question with almost the same title, but it refers to a different situation. Error message) In my case, I have a .cpp file with a big named designation name (implementation details). There is a property class template with a static data member in that name space, which I need to access from outside the unknown namespace. I give it a little bit of meat: file.hpp namespace Bar {template & lt; Typename A & gt; Struct foo {static_assert (is_same & lt; a, float & gt; :: value} is_same & lt; a, double>: value, ""); Fixed zero set_static_var (a const & x); // ...}; } and file.cpp namespace {template & lt; Typename A & gt; Struct foo_traits {// supports the implementation of several static code bars: foo & lt; & Gt; Fixed A data; }; The template's & lt; & Gt; Float foo_traits & lt; Float & gt; :: datum; // No change if this is in the global namespace template & lt; & Gt; Doub...
Read more