LittleRipples Project

Changing Joomla Rentalotplus component to take multiple bookings on each unit

2012-02-16T10:13:00.001Z

Suitable for single user booking systems only

The aim here is to take have a unit/training centre where we can book multiple places ( number set in admin ) on various dates.

As rentalot is a booking system it's designed to book for groups and families, in my scenario users will only be booking for themselves and never for groups .

If your system is for booking groups then the following hack is of no use.

When installed and using the Daily view the process works like

> You see the calendar that shows you available dates

> on the next page you select the dates and click on the 'availability' check

> this then activates the check. it's this check that I've changed and therefor

allowing multiple bookings on the same unit on the same day.

Following the breadcrumbs back from the view I found where to enter the solution in

administrator/components/com_rentalotplus/models/booking.php

if you add the following function to this class

[code]

function totalBooking()

{

$unit_id = $this->_data->unit_id;

$sql="SELECT COUNT(unit_id) AS totalRecord FROM ".$this->_db->nameQuote(LA_DB_TBL_PREFIX.'bookings')." WHERE unit_id='".$unit_id."'";

$this->_db->setQuery($sql);

$Result = $this->_db->loadObjectList();

//print_r($Result); 

return $Result;

}

[/code]

and then find 'function checkForBookingOverlaps'

UNDER $count = count($rows);

ADD

[code]

//find out how many spaces in the unit

$unitspaces = $this->totalBooking(); //DJ

$totalBooking=$unitspaces[0]->totalRecord;

$totalBooking=$totalBooking-1;

[/code]

then find the condition ($count != 0' )

and change this to

($count > $totalBooking)

Here's a pdf of Changing Joomla Rentalotplus component to take multiple bookings on each unit if it helps anyone.

Rentalot Plus calendar not working in Joomla 1.7

2012-02-15T10:58:00.000Z

I've installed rentalotplus on a joomla 1.7 installation and did not have the calendar when checking for Availability.

It was working on a 2.5 installation but I've had to go back to 1.7 as the commumnity builder component would not install on 2.5

Here's an image of what was happening.

the solution is to log into the admin area.

Go to

> components

> rentalot

> configuration

> general

and then navigate down to the 'Site date picker' dropdown and change this. One of them should work for your site. For me it was JQuery

Making some changes on a Joomla MVC Component.

2012-02-14T12:39:00.000Z

I thought I'd write a blog about some changes paid to get made to the Rentalotplus component last week. To be honest my requirements must have been lost in translation as the results weren't a working example of what I needed. However I do feel the code is of note.

The result of the changes do this . * make a row check of bookings in the database

* if there has been too many bookings then the 'Book Now' button will not show.

Here's the code changes.

OPEN models/classic.php

in the function &getData

ADD

$result = $this->totalBooking($unit_id);

UNDERNEATH

$this->stats_hit($unit_id);

AFTER THE CLOSING BRACKET OF THAT FUNCTION ADD

function totalBooking($unit_id)
{

$sql="SELECT COUNT(unit_id) AS totalRecord FROM m37hf_rentalot_plus_bookings WHERE unit_id='".$unit_id."'";
$this->_db->setQuery($sql);

$Result = $this->_db->loadObjectList();
//print_r($Result);
return $Result;

}
// --

the OPEN views/daily/view.html.php

FIND the line

$classic_model = $this->getModel('classic');

AFTER ADD

$itemstext = $classic_model->totalBooking($unit_id); //GHRIX

$totalBooking=$itemstext[0]->totalRecord;

$unit_model = $this->getModel('unit');

$unit_data = $unit_model->getOne($unit_id);

$max_people = $unit_data->max_people - 1;

if($totalBooking<$max_people) { $book_button = $menu_params->get('book_button', 'yes');

}
else
{
$
book_button = '';
}

#####

Basically in the Model view we load the data with the information about how many reservations have been made for this unit.

Then in the view we retrieve that information .

$classic_model has already been used to load the data from the model

* so we then use $itemstext to get the 'totalBooking' infromation from that data.

* its an array though so using $itemstext[0] gets the number we're after

* using the getModel('unit') we can access the unit information that we need for comparison.

* the comparrison is done and button displayed if we need it to be.

the only thing is that it doesn't really do anything as for it to be in anyway of use I'll need to put a date check on the mysql call and we'll need to change the check on the availability check on the following page.

joomla 1.7 cb install Unable to find install package

2012-02-07T16:51:00.000Z

the first thing you should try if you get the message 'Unable to find install package' while installing Community Builder on 1.7 is upload the folder 'com_comprofiler' into your 'tmp' folder . And then use the install from folder function in Component installer.

It work for me anyway :)

joomla rentalot plus - combining the calendar view and booking page - notes

2012-01-31T14:32:00.000Z

In Joomla Rentalot Plus I'm trying to combine a page so that the calendar view appears above the date selector.

This is what I know -

* the calendar is called on the page components/com_rentalotplus/views/daily/view.html.php

at line 136 we see the code

[code]// draw the daily view

if (count($items) == 0)
echo '

'.JText::_('COM_RENTALOTPLUS_NO_PRICE_UNIT').' ('.$date_from.' - '.$date_to.')

';
else
echo LA_daily_view::draw_daily_view($items, $classic_model, $this->config_data, $unit_id, $this->current_currency_row->code, $currency_symbol, $currency_format);
[/code]

I would like this view to be seen as well at this point in the code

components/com_rentalotplus/views/check/view.html.php

under line 98.

The problem i have is calling from outside an object and not use $this

Duplicated site is running slower - hacked site fixed be checking reWrite rules

2012-01-30T13:43:00.000Z

After transferring a website from a testing server to a live environment I noticed that the speed of requests and page loading time had severlly deteriorated.

If you get this problem then firstly I'd suggest using Mozilla Firefox browser and the Firebug tool.

Click on the 'net' tab and you'll then be given a break down of what 's wrong.

in this case it was a virus, I realised the page was calling a mysterious folder and it's contents. The contents where easily deleted but the folder wasn't real and created by a ReWrite Rule. The next port of call was the .htaccess file.

which read

RewriteEngine On
RewriteRule ^c/(.*) wp-blog.php?p=$1
RewriteRule ^icons/(.*) 109a0ca/$1
RewriteRule ^sitemap.xml wp-blog.php?sitemap=1
RewriteRule ^robots.txt wp-blog.php?robots=1
RewriteRule ^feed/ wp-blog.php?feed=1

on the site I was transferring from there was no Rewrite rules, and therefore no problem.

I changed the .htaccess file to this

RewriteEngine Off
RewriteCond %{REQUEST_URI} !^/c

to doubly make sure nothing is send to the 'c' folder, where the problem resided.

The problem with loading times is now sorted.

Getting a Booking System to work on Joomla

2012-01-27T15:36:00.002Z

Getting a Booking System to work on Joomla

I'm attempting to set up a booking system and the went and paid for the component BookIT - however I tried the installation in Joomla 2.5 but it didn't work. And also in Joomla 1.7 with no joy either. However I can get it to work in Joomla 1.5 .

The problem seems to be with the calendar showing. However I haven't sorted all issues and am thinking I will probably use a different solution.

Joomla 2.5 installation tips !

2012-01-27T08:59:00.000Z

I've just installed Joomla 2.5 and had to work a couple of things out for myself as theres no installation guide for this version at the time of writing. Infact the readme text included was for upgrading from 1.7 .

* download the full Joomla 2.5 package here

* install on your server and head for the installation folder /installation

* follow instructions and that;s it

However I then got the following message

'A file permissions error has occurred.'

You then need to change all your folder permissions to 755 and files to 644.

Except for the configuration.php file which should be 444

AFTER DOING THIS I WAS STILL GETTING THE 'A file permissions error has occurred.'

I googled 'joomla 2.5 installation A file permissions error has occurred.'

the solution was that I overlooked the public_html/ folder (doh!) that needs to be 755 also.

SOLVED :)

getting rid of white space from text using PHP

2012-01-26T10:36:00.000Z

A simple thing to do, but theres a ton of ways to do it. I believe this is the best way to get rid of white space from text using PHP

[code] $sPattern = '/\s*/m';
$sReplace = '';
$bacs_end_date = preg_replace( $sPattern, $sReplace, $bacs_end_date );
$bacs_start_date = preg_replace( $sPattern, $sReplace, $bacs_start_date );[/code]

Removing the 'Handles' or Pointers from News Pro GK4 Module

2012-01-21T22:38:00.002Z

Removing the 'Handles' or Pointers from News Pro GK4 Module

This post is relevant to those who are using the News Pro GK4 Module in the module mode 'News Slideshow' and you want to get rid of the arrows top and bottom of the boxes.

Open /modules/mod_news_pro_gk4/interface/css/style.portal.mode.2.css

EDIT OUT these lines

nspMainPortalMode2 .nspArt.active >div > div { background: transparent url('../images/nsp_portal_mode_2_img.png') no-repeat center top; }
.nspMainPortalMode2 .nspArt.active > div > div > div { background: transparent url('../images/nsp_portal_mode_2_img.png') no-repeat center bottom; }

jquery css how to make text fade in fade out

2012-01-20T10:09:00.000Z

[code]jQuery(function($){
$("#selectedElement").fadeOut().delay(2000).fadeIn();
});[/code]

Using Joomla's DBO

2012-01-16T23:11:00.001Z

After using the tutorial for making a component one thing it doesn't go into is coming off the beaten track when it comes to database calls. Here's a page that I've found pretty help full.

http://docs.joomla.org/Category:JDatabase

What I'm trying to do is get a list of products from virtuemart.

$db = JFactory::getDBO();
$query = "SELECT * FROM #__example2";
$db->setQuery($query);
$db->query();
$rows = $db->loadRowList();

to be continued ...

Transferred joomla site to non https site

2012-01-16T16:21:00.000Z

Joomla turn off 'Force SSL' in mysql

Actually it's not set in mysql - you'll need to OPEN configuration.php

AND CHANGE

var $force_ssl = '1';

TO

var $force_ssl = '0';

and always with a Joomla Virtuemart site transfer you'll need to change the address saved in Virtuemart - read this blog ->
'duplicated joomla and virtuemart site goes to old website address when accessing virtuemart through the backend'

how to stick google analytics in < head > on wordpress website

2012-01-09T11:06:00.001Z

this is the folder you need to find.

wp-content/themes/your-theme/header

then look for the /head tag.

How to get rid of 'Download information as' text on the contact page of Joomla 1.7 installation

2011-12-20T15:18:00.000Z

I couldn't find answer to this after googling a few things like

joomla 1.7 get rid of Download information as: text on contact page

joomla delete Download information as:text on contact page

here's what I needed to do

OPEN

components/com_contact/views/contact/tmpl/default.php

line

63 is

get rid of it !!

:)

Changing the color of the buttons in GK4 on Joomla 1.7

2011-12-15T13:37:00.000Z

you need to locate the css on this page

modules/mod_news_pro_gk4/interface/css/style.portal.mode.2.css

once there its the color here you'll need to change

modules/mod_news_pro_gk4/interface/css/style.portal.mode.2.css

and this image modules/mod_news_pro_gk4/images/nsp_portal_mode_2_interface.png

where is the mysql database on this server

2011-12-06T14:21:00.000Z

I've been asking question like 'how do i find the mysql database on this server. When it's just occurred to me that as I know the local host address and password etc. then all I need to do is set up phpMyAdmin www.phpmyadmin.net/home_page/index.php and I'll be able to have the access I need.

I'll fil you in on process when I get round to doing it next week. Here's a link to the documentation on downloading http://www.phpmyadmin.net/documentation/#quick_install

Getting multiple Backgrounds to work on one page using CSS

2011-11-30T13:26:00.001Z

The Problem here is this: Take a look at this screenshot.

I wanting to show 3 layers at once using the z-index. However to do this I needed to set the div position to 'absolute' and that through the layout out in other areas.

One suggestion I got was to make a relative container to put the other DIVs in .

However I got this solution to work where I can use 2 backgrounds in one DIV. There's also a fix for IE 8

Multiple Background in CSS DIV -

Here's the css that worked for me on Wise Monkey Media -

background: url("../../images/wisemonkeymediatail.gif") no-repeat scroll right bottom, url("../../images/mp-background-shading.png") repeat scroll center top transparent;

check the next blog for my IE8 fix

Can you force an old module from Joomla 1.5 to work on Joomla 1.7

2011-11-29T11:05:00.000Z

I'm using this news reel GK4 on this Surfing News website. It's got one really cool feature which I like is that you can scroll left or right through the pages of news items. However this feature isn't carried over in the Joomla 1.7 update. So I was wondering if I could force it to work. The answer to this I think is no. Here's what I tried

* Copied the folder over

* copied the jos_module entry for gk4 into the new site. You have to do this by hand as there are extra fields, and some have been ended.

* changed the params - it now starts with { and ends with } . Also /n needs to be swapped for :

this still produces a NSP error. The next stage would be to google how to change my Joomla 1.5 module into joomla 1.7 or something similar. If you know of a solution then please let me know.

tar: Unexpected EOF in archive

2011-11-28T16:03:00.000Z

i got this message while unzipping a gzip file

tar: Unexpected EOF in archive
tar: Error is not recoverable: exiting now

The reason I was getting it was because the file had not fully downloaded to the server.

Understanding Someone Elses MYSQL

2011-11-26T23:39:00.000Z

Working through someone elses lovely Legacy code I've come to this MySQL statement that seems a bit odd. So this blog is about trying to understand it. Which by the way ultimately I don't. If you do and can explain it to me better than these notes then let me know :) After this blog I will be going away and trying prove it is wrong - so please check future posts.

SELECT pay_rate, LEFT(TIMEDIFF('24:00:00',TIMEDIFF(start_time, end_time)),5) AS hours, hours_only FROM shifts WHERE (employee_id = '160' AND shift_date BETWEEN '2010-11-12' AND '2010-11-18') OR (employee_id = '160' AND postdate_staff_invoice = '2')

SELECT pay_rate, // we only looking to return 1 field

LEFT // check here for 'LEFT' explained - http://www.roseindia.net/sql/mysql-example/mysql-left.shtml -

take this example mysql> SELECT left ('GirishTewari',6)as LeftString;

this means that in this example we're taking the first charcters of this result

TIMEDIFF('24:00:00',TIMEDIFF(start_time, end_time))

#########

So what does

TIMEDIFF('24:00:00',TIMEDIFF(start_time, end_time))

mean. Well

TIMEDIFF() returns expr1 – expr2 expressed as a time value. expr1 and expr2 are time or date-and-time expressions, but both must be of the same type.

* in this example the second expression will be calculated from the row from the database we're in.

AS - I normally use this after calling FROM as a form of shorthand ie

FROM tableOne AS t1

#################

WHERE (employee_id = '160' AND shift_date BETWEEN '2010-11-12' AND '2010-11-18') OR (employee_id = '160' AND postdate_staff_invoice = '2')

Well at least this makes more sense - except for what's after the 'OR'

To be honest this mysql looks all wrong. I think the next stage is to find out what result we're expecting. IS IT JUST TO FIND OUT THE PAY RATE !!

//////////

Here's some searches I've made in looking for answers.

MYSQL LEFT EXPLAINED

Moving a PHP script from a local network onto a Website

2011-11-25T14:22:00.000Z

While I'm working on a script that sits on a local server I've put it up on our own webspace. The only thing is I seem to be have a problem with the folder locations

ie
require_once '/Classes/PHPExcel.php';

needed to be changed to

require_once 'Classes/PHPExcel.php';

i think the way to do this is have a configuration page where I can set up folder directions. Like

$pathtoclasses = 'Classes';

the require once will then read

require_once $pathtoclasses.'/PHPExcel.php';

that can be changed easily when putting this software back on the server. I've put this floder directions in db.php for know as I'll need to change the configuration on this page anyways.

Zoom out with paint magnifier tool

2011-11-24T22:12:00.000Z

Just incase you find yourself using Microsoft Paint then you may find yourself frustrated by the 'Magnifier Tool'

the thing is you don't seem to be able to zoom out. It's a one way thing, even after trying 'shift +click' or 'alt+click'.

The only way you can zoom out is using the Zoom in and Zoom out slider at the bottom right hand side of the page :))

The thing is you

How to delete your Video on Screenr.com

2011-11-22T16:15:00.000Z

I've recently been using Screenr to record help videos, one thing that wasn't straight forward ( everything else on there is extremely easy to use ) was deleting a video after I'd made it.

The trick is you have to continue the process of publishing before you get the option of 'deleting the screencast' which is in red texgt at the bottom right hand side of the screen.

joomla virtuemart - putting a equalled sized box around products on Category pages

2011-11-16T21:37:00.000Z

my categories pages where looking a bit untidy with some items being taller and wider than others.

So on request I wanted to ' make a box to around products in Virtuemart on Joomla '

after adding some simple css to the existing browse page. namely

.browseProductContainer {
border: 1px solid #CCCCCC;
width: 235px !important;
}

the sol my page looked like this

the solution was to add a height to the table under the 'browseProductContainer DIV'

table.tablebrowse1 {
height: 375px;
margin-top: -20px;

}

It's now sorted and you can look at Womens Dresses