Sidebar menu items & links

Mon, 28 Mar 2016 22:18:11 -0700

Hi guys

I am revisiting a project I developed with CMS Builder 5 years ago, and need to add a link on the left sidebar of the CMS Admin page.

I have added the link in the Section Editor area, but it still does not show up in the sidebar.

I am obviously forgetting something, any ideas?

Grouping by Categories then Sub-Categories

Sun, 09 Oct 2011 05:56:03 -0700

Hi guys,

I have implemented Gerry's code for inserting headings when a category changes, works great.

I am trying to generate reports that list all of our equipment by "Type" then groups each type into its "branch"

I effectively got the code working by doubling it up, and changing fields, and added in listing counts at each heading.

I can get it to work, however the issue is this:

When a "Type" heading changes, and the only listing is one for the same "branch" as the last record in the previous "type", it doesnt list the "Branch" at the start of the group.

Sounds a bit complex, so attached is a screenshot of the results I am getting.
Note that the heading "Lawn Mowers', the listings are from "Haeuslers Echuca", which is the same as the last record from the previous Equipment type, and therefore does not list the branch heading because it is not different to the last listing.

Basically, every time the Equipment type changes, i need the branch heading to be displayed, regardless of if it hasn't changed from the last Equipment type.

Also here is the very dodgy and un-refined code I have so far:





   $type = $record['type'];// load sub-group value from record.
if ($type != $old_type) { // If different from the last sub-group value, print the sub-group name.
print ' space 
';
 print '';
  echo "$type"; 
 print '  Listings:  ';
 list($listingsCount, $listingsCountMetaData) = getRecords(array(
    'tableName'   => 'listings',
   	'where' => "type='$type'"
  ));

  echo $listingsCountMetaData['totalRecords'];
//echo mysql_select_count_from($listingsCount, 'branch');  
 print '
';}
 if ($type != $old_type) { // If different from the last sub-group value, print the sub-group name.
 print '
'; } ?>

   
   
   print ''; print '
';
print '  ';
print 'Haeuslers '; echo "$branch"; 
 print '  Listings:  ';
 list($listingsCount2, $listingsCount2MetaData) = getRecords(array(
    'tableName'   => 'listings',
   	'where' => "branch='$branch' and type='$type' and approved='1'"

  ));
  echo $listingsCount2MetaData['totalRecords'];
//echo mysql_select_count_from($listingsCount, 'branch');  
 print '
';}
 if ($branch != $old_branch) { // If different from the last sub-group value, print the sub-group name.
 print '
'; }
   ?>

Re: [tom] Iframe targeting

Mon, 03 Oct 2011 16:14:28 -0700

You are a godsend Tom!

everywhere else i looked, the mention of sent people running.[:/]

Unfortunately, our existing site uses them, so i have to integrate with it.

I ended up getting it to work with a few mods,

with the link, i had to do a bit of directory navigating to get the results right, then add the listing link to it:

Then I had to change a little bit of the body code on the receiving page to make the iframe the right size and blend in like the old one did:

The only other thing I had to do was modify the header script of the receiving page to display the original content if no link is specified, (by adding to the " if( results == null ) " line, otherwise opening that page directly from the existing menu gave a blank iframe.

Works like a charm now!

Thanks again mate :)

Iframe targeting

Sun, 02 Oct 2011 23:31:40 -0700

Hi,
This is probably more of a HTML/Javascript question, but you guys all seem pretty switched on with all this, so here goes!

I have an iframe on our homepage, the source of which is a scrolling list of machinery, out of the CMSB
When a unit is clicked on, I want the details page to open in an Iframe on another page of our website.

I have read http://www.interactivetools.com/iforum/P59754#59754
the only issue is that our homepage and the other page containing the iframe are html, not php

Re: [Dave] Where Statement Issue

Sun, 02 Oct 2011 03:16:37 -0700

Top Job Dave,

That was it!

I can see now why it wasn't working correctly

Thanks mate

Where Statement Issue

Sat, 01 Oct 2011 22:31:37 -0700

Hi guys,

I am trying to limit my page results to the following criteria:

'Approved'= 1 (checked)
'sales_status' = "in Stock" or "Coming In"

here is my current page query:

 list($listingsRecords, $listingsMetaData) = getRecords(array(
    'tableName'   => 'listings',
    'perPage'     => '6',
	'where'       => 'sales_status="In Stock" OR sales_status="Coming In"' and 'approved="1"',

I cant get it to limit it so that all criteria are checked.

I can get it to show the right "sales_status" records, but it ignores the "approved" check.

If I reverse the order of the statement, it show approved records only, but only "in stock" records.

i.e, the AND part is working, and the OR part is working, but not both at the same time.

Im sure its just the way I have the statement worded, but can only find references to WHERE / AND statements, not WHERE / AND /OR statement

Re: [Jason] Page number links

Sat, 01 Oct 2011 22:22:30 -0700

Ahh, perfect

Thanks Jason!

Page number links

Fri, 30 Sep 2011 18:15:25 -0700

HI guys,

Got a quick one here:

I have a search page set up, with 2 frames, "Header" and "Content"

"Header" frame contains the drop-downs and parameters for the search, and "Content" displays the results, usually in multiple pages.

The page works great, and does everything I want it to.

The Prev/Next page links on the "content" page all work, and cycle through the appropriate selected records.

The issue I have, is that use Pagination code that allows user select an individual page, but when using an individual page link, the frame reverts to the whole listing, ignoring the specified criteria.

The Prev/next page links use the $listingsMetaData['prevPageLink'] / ['nextPageLink'], and as I said, these work correctly, and pass the search criteria on the the next page, but the individual page links just use "?page=" and do not pass on the criteria, which results in the whole listing being returned with no filtering.

At the moment, i have the links disabled, so the page numbers are just for indication.

Any Ideas here?

Re: [ross] Drop-down box record count / refreshing

Thu, 29 Sep 2011 15:55:46 -0700

Ahh, beautiful mate!

That worked a treat :)

I was trying almost the same thing, but as using:

to get the empty ones.

Thanks Ross!

Re: [MickC] Drop-down box record count / refreshing

Wed, 28 Sep 2011 21:18:10 -0700

Okay, so I have all my search menus working well, getting list options as above.

We decided to do away with the count because it looked messy in the list.

What I want to do now, is to only put an entry in the list if there are records for it.

Our "Manufacturers" list is quite long, and a lot of the time, most of them wont have any matching records, so I only want the list to populate with options if they have records matching them.

Im sure i can do it with the same mySql count function, where anything with a count of less than 1 would be omitted, possibly with an "If" for each option?

Approved uncheck on saving

Tue, 20 Sep 2011 20:20:52 -0700

Is there an easy way of have a record automatically become "unapproved" when a non-editor changes it?

We have salesmen that enter machine details, then a designated editor checks them, and ticks the approved checkbox to enable them to be listed on the website.

Editors only have access to the approved checkbox, and salesmen can only create new records, view all, and modify only their own.

What i want to prevent, is after the Editor approves it, the salesman can modify it to add more pictures etc, but when doing so could enter incorrect pricing etc, while sitll listed on the website.

Ideally, on a salesman modifying the record, if it unchecks the approved status, the editor must check it before it appears back on the website.

Any ideas?

A few Questions

Tue, 20 Sep 2011 07:17:07 -0700

Hi guys,

I'm going quite well with this system, I just have a few queries that should be easy to answer.

I have bought CMSB 2.12, CreatePDF plugin, Report Builder, and the Basic Auto template.

A) Most of our Internal staff will be using the admin side of the software, and to make it easier, I want to be able to modify the layout of the Section.

For example, I want to have about 8-10 options under Advanced search, but want them spread out across the top of the section, not one under the other.

I have explored the .php files, and heavily modified the style.css and the SimplAdmin images to reflect our company colors, but cant seem to see where you can alter the layout of the actual section listings

B) in the same area, i have listings that when opened, have "Created by" and "updated by", but i want this to state the users Full name, not the login name. I know how to do it in with the createdBy.fullname for the lsiting itself, but not the other parts of the page.

C)Id like to add the option of making a button to print the reports that the report builder makes, or at least a print button

That's enough for now, im off to the plug-ins forum to get the most out of my 90 days free support [;)]

Re: [Jason] Include/create hyperlinks from a report query

Sun, 18 Sep 2011 03:53:02 -0700

Thanks Jason,

I have had a go, but cant quite figure out what to change.

All our records have a unique field called "stock_number"
I want users to run any report, which will have a list of units, with stock numbers as part of the report.

But, i want this field in the report,or a button next to the row, that editors can click on to take them straight into the edit page for that record. (otherwise they have to run the report, write the stock numbers down and go back to the listing to edit them.

so for example, i have a report that lists units that are on hire. - in the stock number field, instead of a text sating "U20013" i want this to be a link to " /admin.php?menu=listings&action=edit&num=" then the listing number.

Or a button next to it.

Re: [videopixel] Facebook comments plugin

Sat, 17 Sep 2011 22:00:30 -0700

Hi Videopixel,

I just set up the Facebook Like/Recommend plugin at the bottom of each dynamic listing, and just used PHP code to specify the URL - works perfectly for me!

here is the code that does the job:

This makes the url specify the exact page to go to.

I know this is for the Like/Share plugin, but i looked at the code for the Comments plugin and it looks very similar

See how that goes :)

Re: [MickC] Query about PDF creator Plugin

Sat, 17 Sep 2011 01:56:13 -0700

I tidied a few things up and get it working perfectly,

I even worked out a way to dynamically name the PDF file with a bit of trial and error.. [;)]


  $filename= $listingsRecord['manufacturer']."-".$listingsRecord['Model'];
  $num= $listingsRecord['num'];
  $url  = "listingInfoSheet.php?".$num;
  $data = createPDF_fromUrl($url);
  createPDF_display('attachment', $data, $filename.'.pdf');
?>

Now the customer's file is meaningfully named, instead of 4 different "example.pdf" files.

Now to play with a few switches and see what else I can do!

Re: [Jason] Drop-down box record count / refreshing

Fri, 16 Sep 2011 21:42:27 -0700

Thanks Jason.

That worked perfectly. My attempt had me about 2 characters off....

Now I am going to try and employ an "if" statement so that any options with a listing count of "0" will not be shown

I haven't had a proper go at this yet, but this is the code i have so far - but Dreamweaver doesnt like it.

I will have a play and see what I can do

Re: [Jason] Query about PDF creator Plugin

Fri, 16 Sep 2011 21:37:01 -0700

Hi jason.

Thanks for you help mate, it ended up being a DNS problem, of all things!

The domain name it is running on only has entries in our local DNS server, not to the public. I got it to the stage where it would make PDFs of any public website, but all "internal" pages would just come up blank.

Anyway, I made the domain name public and the problem disappeared. Obviousy the PDF engine uses the DNS of the hosting provider to resolve the domain name, which is where i was coming unstuck. [crazy]

Query about PDF creator Plugin

Fri, 16 Sep 2011 09:21:53 -0700

I have just bought the PDF creator plugin and installed it, after a few fixes it is working.
I have also bough the Cookbook, and scoured the forum and the cookbook for an answer for this:

I have a listing of used equipment, each record of which links to a detail page for each item. I also created another detail page which will be converted to PDF so the customer can print off, email etc.

Every time i put the code into the page i get the following issue:

If i put the createPDF code like this:

in the header


in the body
CLICK TO CONVERT THIS PAGE TO A PDF
which id about halfway down the page, i get an error like this:
createPDF_display: Can't output PDF because headers already sent! Output started in /home/haeusler/public_html/used/listing/listingInfoSheetPrep.php line 125. Make sure you don't have any html or whitespace characters in your code before calls to createPDF_ functions.

If i move it up to the top of the page, it makes a PDF, but it is just a blank white page.

The only errors after i installed and tested it were ones that required me to add the switch to ignore errors.

Running the test in the admin section, the google page works correctly.



Include/create hyperlinks from a report query
Fri, 16 Sep 2011 04:23:01 -0700
I have just bought and installed the Report Builder plug in.

What i want to, is have the report contain a hyperlink to edit the record.

I made a report on out "listings" table, and it shows all records where "approved=No" - this works well.

What i need, is to make a hyperlink out of the results so the editor can click it to go directly to the edit page of that record.

If I could access the php page that the report is on, i could code it in, but I can't seem to find where that page is.
When the report is in the browser,  it shows the URL as ..cmsAdmin/admin.php?_pluginName=reportBuilder&_report=4



Re: [Jason] Drop-down box record count / refreshing
Thu, 15 Sep 2011 17:53:40 -0700
Thanks Jason, 

I gave it a quick try, but just got 0's after each option.
I tried this code last night and it gave every option a 1 after it.
  
Anway, i'll have a play with this tonight
Thanks mate.



Editor editing certain records only
Thu, 15 Sep 2011 07:49:14 -0700
G'day, 

Another one I can't find an easy way around:

I have set up a used machinery database with CMSB, with 5 different branches.

I have it set so that internal users can view records all records, add new ones, but only change their own entries, and an editor at each branch needs to approve them before they are listed on our public website. - this part all works fine.

What I want to be able to do, is have it so that the editors can only edit records for their own branch.

I have a listbox field in the "listings" called "branch" 
and in the User accounts table, i also have a field called "branch" but this is a multiple choice checkbox ( the reason being that some editors need access to more than one branch - just to be difficult  [;)] )

So in then end, when creating or editing a user, I can just tick the checkboxes for the branches I want them to have access to.

Any ideas?



Drop-down box record count / refreshing
Thu, 15 Sep 2011 01:11:20 -0700
I am using multiple drop down boxes to search machines by location, type, or manufacturer. 
They auto-populate options from the table, I even employed the mm_jumpmenu feature to prevent user from having to click a button.

I have the problem where if you choose say "location 1", the page refreshes with the correct results, but if you then want to specify another field, eg "Manufacturer 1",  the page will show only the results  for that manufacturer, and the Location dropdown reverts back to "all locations"   
Is there a way to make this work?

2nd part of this question is:
I have the options coming out of the table correctly, but i have seen where drop downs  have "Make (3)" with the 3 being the number of listings in that category.
Is this just come coding to get the information to display?

Here is the current code for one of the drop downs: