Super_Invoice - Check customer orders count (background check)

[sbbemn]

Hello all,

I am close but no cigar on checking the customers orders and if greater than 1, then no action.

Trouble I am having is getting the history of orders. Here is the code I have so far...

       $customers_orders = $db->Execute("select o.orders_id, o.date_purchased
                                          from " . TABLE_ORDERS . " o
                                          where customers_id = '" . (int)$order_check->customers_id . "'");
       $no_history = ($customers_orders->recordCount() = 1); 

I am getting " Fatal error: Can't use method return value in write context " referring to the last line above. Any guidance would be appreciated!

[Ajeh]

recordCount() should be RecordCount() and = should be ==

But what are you really trying to test? If there is only 1 Order? Or if there is at least 1 Order?

[sbbemn]

Thanks - silly little things overlooked! I will work on that right now.

Basically checking to see if it is the customer's 1st (and only) order. That way we know they are a 1st time buyer and flag them if the order is over $x.

[sbbemn]

Works great! Thanks Ajeh
here is what I did to check customer's orders and if only 1 order and 1st time buyer...

       $customers_orders = $db->Execute("select o.orders_id, o.date_purchased
                                          from " . TABLE_ORDERS . " o
                                          where customers_id = '" . (int)$order_check->customers_id . "'");
       $no_history = ($customers_orders->RecordCount() == 1); 

Then on the super_invoice I used $no_history to flag the customer. Use any method or special heading of your choice.

[Ajeh]

Thanks for the update that this is working for you and the explanation of its use for you ...

[sbbemn]

I came up with another feature though that is of use - order age.

If the customer orders list is newer than 35 days. This is within credit card billing cycle for fraud and chargebacks.

I tested this on a dev site - seemed to work. Hard to test completely on a dev site based on the others parameter checks I have.

       $customers_orders = $db->Execute("select o.orders_id, o.date_purchased
                                          from " . TABLE_ORDERS . " o
                                          where customers_id = '" . (int)$order_check->customers_id . "'");
       
       $days35fromnow = strtotime("+35 days", strtotime("<date-from-db>"));
       $no_history = ($customers_orders->date_purchased >= $days35fromnow); 

[Ajeh]

At a glance ... you have an error:

$no_history = ($customers_orders->date_purchased >= $days35fromnow);

This should be:

$no_history = ($customers_orders->fields['date_purchased'] >= $days35fromnow);