Displaying results based on 'status'

Fri, 27 Nov 2015 09:38:40 -0800

Hi Carole,

The code that I posted are just examples so you might need to replace some variables and values.

I'm guessing that your properties are stored in 'lease_warehouse' table/section so you need to replace my example code's table name 'properties' with 'lease_warehouse' (replace it with correct table/section name if my guess is wrong).
Here's how the "new on market" MySql query and code to display it might look like:

// new on market $newOnMarketPropertiesRecords = mysql_select('lease_warehouse', 'status = "available" ORDER BY createdDate LIMIT 4'); ?> No records were found! Some code here..

Let me know if that works or post any errors you get if it didn't.

Thanks,

Displaying results based on 'status'

Thu, 26 Nov 2015 14:43:02 -0800

Hi Daryl

I'll give this one more go.

I am currently using

$count=0;

$maxCols=4;

?>
.... and then to close it

No records were found!

So does that mean I replace this (err, I guess with ...

// new on market
$newOnMarketPropertiesRecords = mysql_select('properties', 'status = "available" ORDER BY createdDate LIMIT 4');

Tried that and it didn't work (as that also makes a list, and I need it to be columns)

Displaying results based on 'status'

Thu, 26 Nov 2015 13:14:05 -0800

Hi Carole,

I wrote my example assuming that the properties are in one cmsb section, ie: "properties" and the status types are in a drop-down list field (not from separate sections) in that "properties" section.
And a property/record in "properties" section can have one of these status types: available, under offer or leased
Is that correct?

So for this line from my example:

// new on market $newOnMarketPropertiesRecords = mysql_select('properties', 'status = "available" ORDER BY createdDate LIMIT 4');

We're pulling 4 records (LIMIT 4) from 'properties' section where 'status' is 'available'.
While the one below pulls 4 records from the same 'properties' section but, this time, the status of the records that we're pulling is 'under offer'

// under offer $underOfferPropertiesRecords = mysql_select('properties', 'status = "under offer" ORDER BY createdDate LIMIT 4');

As for the errors, if after replacing my example section/table name 'properties' with the actual section where you store your properties and the actual status type still returns some errors, can you please post the errors you've received?

Thanks,

Displaying results based on 'status'

Wed, 25 Nov 2015 04:50:12 -0800

Hi Carole,

See if you can use something from this code from my FAQ page.

It uses a list field called category

You can use sort order to determine how the records are presented, so "newest first", would be 'orderBy' => 'createdDate DESC', as below.

Good luck,

Jerry Kornbluth

// load viewer library $libraryPath = 'cmsAdmin/lib/viewer_functions.php'; $dirsToCheck = array('/path_to_your_server/','','../','../../','../../../'); foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }} if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); } list($faqRecords, $faqMetaData) = getRecords(array( 'tableName' => 'faq', 'orderBy' => 'createdDate DESC', )); ?> http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> http://www.w3.org/1999/xhtml"> FAQ


    foreach ($faqRecords as $record): 
 $group = $record['category:label']; // load sub-group value from record. ?>

FAQ

CLICK/TAP FOR ANSWERS...

if ($group != $old_group) {echo "

$group

";}?>


if (!preg_match("/^http:\/\//i", $record['url'])) {
$record['url'] = "http://" . $record['url'];   }

?>



      - -

Displaying results based on 'status'

Tue, 24 Nov 2015 18:45:54 -0800

Hi Daryl

I think this is assuming each of the status types are a different section within the cmsb (they aren't) - a property can be any of the available, under offer or leased (drop down) which changes the status on the single file.

I've tried the below and am getting endless errors.

Displaying results based on 'status'

Mon, 23 Nov 2015 13:36:01 -0800

Hi Carole,

One way to do it is to have a query for each of the status and add where clause to select specific status.
For example:

// new on market $newOnMarketPropertiesRecords = mysql_select('properties', 'status = "available" ORDER BY createdDate LIMIT 4'); // under offer $underOfferPropertiesRecords = mysql_select('properties', 'status = "under offer" ORDER BY createdDate LIMIT 4'); // leased $leasedPropertiesRecords = mysql_select('properties', 'status = "leased" ORDER BY createdDate LIMIT 4');

And then use foreach loop to display the contents under their designated headings:

// for "new on market" heading foreach ($newOnMarketPropertiesRecords as $newOnMarketPropertiesRecord){ echo htmlencode($newOnMarketPropertiesRecord['name']); }

Hope this helps!

Cheers,

Displaying results based on 'status'

Sun, 22 Nov 2015 20:26:20 -0800

Hi Jerry

Thanks for this. It looks very confusing, but I'll try and wade thru it.

Displaying results based on 'status'

Sat, 21 Nov 2015 12:19:29 -0800

Hi Carole,

Here's a recipe from my CMSB Cookbook http://www.thecmsbcookbook.com that might help...

Best,

Jerry Kornbluth

SORTING BY GROUP AND INSERTING GROUP HEADINGS IN A LIST VIEWER (ANOTHER APPROACH) - Mar 23rd, 2012

This approach seems to be a bit easier to implement but it only worked with a bit of help from Jason Sauchuk, from
Interactive Tools.

I wanted to allow for an expanding list of categories (actually board of director positions in an organization) that
could be managed by my client from the management interface, without resorting to any coding changes.

The first thing I did was to create a multi-record editor called board_of_director_positions with only one text field
called position. I set the sort to dragSortOrder DESC so that the positions would appear in the correct order.

Then, in the accounts editor, since some board members held 2 positions, I populated 2 single value list fields
(board_of_director_position_1 and board_of_director_position_2) using the board_of_director_positions table as the
source, the num field for the option values and the position field for the label values.

Then I used array_pluck after the list records call to create a variable containing a list of the positions so that I
could display their names in my viewer

list($accountsRecords, $accountsMetaData) = getRecords(array(
    'tableName'   => 'accounts',

  ));

list($board_of_director_positionsRecords, $board_of_director_positionsMetaData) = getRecords(array(
    'tableName'   => 'board_of_director_positions',
   ));

  $directorposition = array_filter(array_pluck($board_of_director_positionsRecords, 'position')); ?>

In the body of the viewer, I looped through and listed all of the positions, and then looped through all of the accounts
editor records for matches to those positions.

After much consternation, Jason suggested adding the pseudo field :label to the accounts record fields, since otherwise
I was trying to compare a record number to a text label. And that popped the office holders names into their correct
slots.

?php foreach ($directorposition as $position): ?>

echo strtoupper($position); ?>

foreach ($accountsRecords as $record): ?>

if ($record['board_of_director_position_1:label'] == $position || $record['board_of_director_position_2:label'] ==
$position) : ?>

echo strtoupper($record[full_name']); ?>

This concept is easily applied to something like an FAQ page where there are multiple categories and multiple questions
in each category.

Create a multi-record FAQ CATEGORIES editor with one text field called category, a dragSortOrder field and an optional
hidden checkbox.
Create a multi-record FAQ editor with a single value pull down list field populated using the faq_categories table as
the source, the num field for the option values and the position field for the label values.

Then, as above, I used array_pluck after the list records call to create a variable containing a list of the categories
so that I could display their names in my viewer

$faqgroup = array_filter(array_pluck($faq_categoriesRecords, 'category'));

Again as above, In the body of the viewer, I looped through and listed all of the categories, and then looped through
all of the FAQ editor records for matches to those categories.

category:label'] == $group) : ?>
question']); ?> ?>
answer'], 25); ?>
answer']) > 25) : ?>_link']; ?>">class="body-text-bold-10">... read more

Since I'm using a detail page for the complete answers, I included functions called maxWords and wordCount to show a
"read more" link only if there were more than 25 words in the answer. These functions are defined in the head section of
my viewer, with:

PHP
function maxWords($textOrHtml, $maxWords) {
$text = strip_tags($textOrHtml);
$words = preg_split("/\s+/", $text, $maxWords+1);
if (count($words) > $maxWords) { unset($words[$maxWords]); }
$output = join(' ', $words);

return $output;
}
?>

function wordCount($textOrHtml) {
$text = strip_tags($textOrHtml, "");
$words = preg_split("/\s+/", $text);

return count($words);
}
?>

Displaying results based on 'status'

Thu, 19 Nov 2015 19:35:34 -0800

I'm stuck on this one. I have a list of properties which are either 'available', 'under offer' or 'leased'. I have used the drop down function to select the status of each.

What I am wanting to do on the home page is display different properties under different headings such as:

1) new on market (display 4 (from the available))

2) under offer (display 4 listed as under offer) and

3) leased (display 4 (ideally the most recently) leased)

Any ideas of how I can go about doing this?

Thanks

Carole