Codeigniter: Return true if dates are NOT between 2 values

Question

I am using codeigniter to build a rental website for a client. I am trying to return true only if no rental periods match my query. Basically there is a rental table with start date and end date.

My customer selects a start date from a datepicker and the end date is a set number of days after the start date.

So I want to find out if any rental items are being rented on those dates to verify wether the client can reserve the item. Here is what I have so far and I need to accomplish this with Codeigniters active record...

function check_product($periodLength) {

     //This is the start time they chose from the picker
    $startTime = $_POST['date'];
     //The period length is a variable of days, so the end date would be their chosen start date plus a certain amount of days...
    $endTime = strtotime('+'.$periodLength.'day', $startTime);

    $this->db->where('productsId', $_POST['productId']);
           //This is where I need help!!! What query would give me records that are NOT between the start and end dates that i'm wanting
    $query = $this->db->get('rentals');
    $data = array();

    foreach ($query->result() as $row) {
    $data[] = array(
        'id' => $row->id,
        'customerId' => $row->customerId,
        'productsId' => $row->productsId,
        'periodStart' => $row->periodStart,
        'periodEnd' => $row->periodEnd,
        'status' => $row->status,
        'specialInstructions' => $row->specialInstructions,
        'adminNotes' => $row->adminNotes
    );
    }
    return $data;
}

Most of my problem is just in my head i'm sure but i need to figure out if my startdate to enddate period is already reserved.

The canonical inverse of this question Construct a CodeIgniter WHERE condition with the value BETWEEN two column values — mickmackusa
– mickmackusa ♦, Commented Dec 5 at 3:09
I fear this question is a little too murky in its description. It would be great to have a minimal reproducible example to clarify what logic is required. Your method returns an array of arrays, not a boolean value (as described in your title). — mickmackusa
– mickmackusa ♦, Commented Dec 5 at 6:41

Code Prank · Accepted Answer · 2013-02-20 06:04:06Z

2

Try this:

    $startTime = $_POST['date'];
    $endTime = strtotime('+'.$periodLength.'day', $startTime);

    $this->db->where('productsId', $_POST['productId']);
    $this->db->where(" $startTime NOT BETWEEN periodStart AND periodEnd AND $endTime NOT BETWEEN periodStart AND periodEnd OR ($startTime < periodStart AND $endTime > periodEnd) ");
    //Since this is a complex where clause i would recommend 
    //to put enitre clause in single where statement rather than 
    //putting in different where statement. 
    //And it is upto codeigniter active record standards

     $query = $this->db->get('rentals');

answered Feb 20, 2013 at 6:04

Code Prank

4,2706 gold badges35 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mickmackusa Dec 5 at 3:12

That's about 4-too-many conjunctions in one where() call for my coding tastes.

Collectives™ on Stack Overflow

Codeigniter: Return true if dates are NOT between 2 values

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related