public function getPalletID($recName){
        $sql = "Select Pallets.id AS PalletID, Pallets.recName FROM Pallets WHERE recName LIKE ? ";
        $tempResSet = $this->executeQuery($sql);
    //  $result = array();
    //  for($i = 0; i < count($tempResSet); $i++){
    //  array_push($result, $tempResSet[$i]);
    //  }
        return $tempResSet;
    }

    public function  getPalletsCreated($date1, $date2){
        $sql = "Select Pallets.id, Pallets.recName From Pallets where created >= ? and created < ? ";
        $resSet = $this->executeQuery($sql, array($date1, $date2));
        return $resSet;
    }

    public function getDeliveredTo(){
        $sql = "Select Pallets.customerName as Customer, Orders.id as OrderID FROM Pallets, Orders WHERE Pallets.status like 'delivered' ";
        $resSet = $this->executeQuery($sql);
        return $resSet;
    }