Excellent HTML Table design CSS

Got some excellent design clues from here -

http://www.smashingmagazine.com/2008/08/13/top-10-css-table-designs/

Empty Subreport in jasper report

In  case your subreport gives empty/ blank screen, chances are it may be due to datasource problem.Remember to add the following in subreport tag(in case of empty datasource)-



and it should look somewhat like this -

Exception - java.lang.NoClassDefFoundError: org/apache/poi/ss/usermodel/Font

If the exception as -

org.springframework.web.util.NestedServletException: 

Handler processing failed; 

nested exception is java.lang.NoClassDefFoundError: 

org/apache/poi/ss/usermodel/Font 

shows, adding the poi jar from http://poi.apache.org/download.html 

helps to get going.

Creating Interactive Jasper Reports using parameters and variables in iReport

To create an interactive jasper report using iReport, we can use parameters in jasper report.

1. Create a new parameter -

2. Use the parameter in the query -

3. Use the required variable in detail band to display a list.

Create subreport using iReport

php age validation

here it is -
$then = strtotime("$birth_date_year/$birth_date_month/$birth_date_day");
$min = strtotime('+18 years', $then);
if(time() < $min) {
die('Not 18'); }

Add a new contact in vtiger crm

vtiger_contactaddress(insert)-->
INSERT INTO `vtiger_contactaddress` VALUES (210, '', '', '', '', '', '', '', '', '', '', '', '');

vtiger_contactdetails(insert)-->
INSERT INTO `vtiger_contactdetails` VALUES (210, 'CON16', 0, '--None--', 'Jyoti', 'Sahoo', '', '', '', '', '', '', '0', NULL, NULL, NULL, NULL, '', '0', '0', '', '0', '0');

vtiger_contactscf(indert)-->
INSERT INTO `vtiger_contactscf` VALUES (210, '', '');

vtiger_contactsubdetails(insert)-->
INSERT INTO `vtiger_contactsubdetails` VALUES (210, '', '', '', '', NULL, 0, 0, '--None--');

vtiger_crmentity(insert)-->
INSERT INTO `vtiger_crmentity` VALUES (210, 1, 1, 0, 'Contacts', '', '2010-03-23 05:21:53', '2010-03-23 05:21:53', '2010-03-23 05:21:59', NULL, 0, 1, 0);

vtiger_crmentity_seq(update)-->increase id value
INSERT INTO `vtiger_crmentity_seq` VALUES (210);

vtiger_customerdetails(insert)-->
INSERT INTO `vtiger_customerdetails` VALUES (210, '0', '2010-03-23', '2011-03-23');

vtiger_modentity_num(update) -> 4 -> "Contacts"(cur_id) is updated to the required value
INSERT INTO `vtiger_modentity_num` VALUES (4, 'Contacts', 'CON', '1', '17', '1');


not required -->
vtiger_tracker
vtiger_users

webservice

Web services in PHP using the NuSOAP library

View more documents from Fulvio Corno.