Simpale AJAX Shout out box for joomla

If we google as "joomla shout out box" we can get multiple results specific to joomla as show form fallowing link.

http://extensions.joomla.org/extensions/communication/shoutbox

Other than using above extensions we can implement our own shout out box with fallowing features.

Adding our recently entered shout out for waiting shout out list. Normally as a normal users, they may entered deferent type of shout outs with out caring. That type of situation we need a human monitoring system to monitor shout outs.
Display recently added shout outs in the side of admin through the separate admin panel. In this type of application admin should has a facility to monitor the shout outs and accept or cancel that shout out easily real time.
Adding accepted shout outs to shout list for display all users and remove form waiting list.
Identify accepted shout out and rejected shout out easily for users.
If there is a restriction like one user can add limited number of shout outs, available number of shout out need to be display real time without refreshing page.
limit number of shout out user can browse through his view.

Key concept behind the shout out application

Most of the time you may have a problem how system collect the newly added shout out without refreshing the page. The concept behind this is not more complicated. In this application periodically send the ajax request to server and check for newly added shout out with admin acceptance. In the same time system should has a capability to track the red shout out to over come read the red shout outs again and again. Here we can use time stamp to over come this problem. We can insert user entered shout out for shout out table and can set the time stamp for each one according to the oder of admin response.

Shout may be in one of the fallowing sate

0->Pending shout for approval

1->Accepted shout out by admin

-1 -> Canceled shout out by admin

Then after according to oder of reviewing, we can set time stamp and its state(0, 1 or -1).

And also client browser need to memorize last time stamp that is red. Then every time client browser can check the DB for newly confirmed or canceled shout outs with time stamp.

1. Browser memorize time stamp value < state ="">2. Browser memorize time stamp value> Any shot out with 1 or -1 state = Red shout out by client browser

Comments

How to add a new column to vtiger existing table

When we add a new column to existing vtiger table, we need do more than just adding a column to selected vtiger table. If you do so, you may unable to do some DB operation like insert update and deleted. This is the way how we can do this. 1. Add a new column to selected table as normal 2. Add a new row to "vtiger_field" table as fallow "insert into vtiger_field values (tabid, fieldid, columnname, tablename, generatedtype, uitype, fieldname, fieldlabel, readonly, presence, selected,maximumlength, sequence, block, displaytype, typeofdata, quickcreate,quickcreatesequence, info_type)" When you set a value to "presence" field be make sure to select 0 or 2. Otherwise your selected field not populated with vtiger field list.

How to extract vtiger DB data

Here is the code sample how extract data form vtiger DB with WHERE close. Sample:1 require_once('include/DatabaseUtil.php'); global $adb; $tabid = array('9','16'); $sql = "SELECT tabid, fieldname, fieldid, fieldlabel,columnname, tablename, uitype, typeofdata, presence FROM vtiger_field WHERE tabid in (" . generateQuestionMarks($tabid) . ")"; $result = $adb->pquery($sql, array($tabid)); // get result $noofrows = $adb->num_rows($result); // get number of rows $i=0; $data=array(); while($resultrow = $adb->fetch_array($result)) { $tabid=$resultrow['tabid']; $resultrow=['fieldlabel']; $data[$i]=array($tabid, $resultrow); } Sample:2 require_once('include/DatabaseUtil.php'); global $adb; $query = 'select idlists,from_email,to_email,cc_email,bcc_email from vtiger_emaildetails where emailid =?'; $result = $adb->pquery($query, array($focus->id)); $from_email = $adb->query_result($result,0,'from_...

Updating Vtiger Email module for sending Fax and SMS

Most of the time vtiger users searching modules for sending Fax and some time SMS to their customers. Actually writing a separate module for sending Fax may be a time consuming work. So that here I am going to explain how extend possibility of vtiger Email module to send Fax. If you good enough to understand this process, you can update this module to send SMS also. For sending emails we are normally using our own SMTP server. But we have to use some commercial API to send FAX and SMS. In here lets we select two commonly use APIs like "Interfax" and "clickatell" to send Fax and SMS. These APIs are providing email supported APIs to send Fax and SMS. That is why we can use vtiger Email module to send Fax and SMS. From this post I am not going to explain step by step who to hack Email module to send Fax and SMS because it is not a stride forward process. Actually I want to explain that we can use Vtiger Email module to send Fax and SMS other than sending emails aft...

Anandafit

Search This Blog