SugarCRM: adding custom field in subpanel

How to add custom field into subpanel? Belo is example of Contracts subpanel that is showing in Accounts module/detailview.

irst thing that needs to be done is define a new field in subpanel definition and make that field point to a class. We are edititing the following file custom/modules/Contracts/metadata/subpanels/ForAccounts.php and adding additional field fot showing with following code:

'mediaart_new_field' => array(
'vname' => 'LBL_NEW_FIELD',
'widget_class' => 'SubPanelMediaartNewField', //class name
'width' => '10%',
'custom_link_only' => true,
'displayHeaderCell' => false,

After we have added that part of code we need to create coresponding SugarWidgetSubPanel class in the following path
/include/generic/Sugarwidgets/SugarWidgetSubPanelMediaartNewField.php with code like this:

<?php if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
class SugarWidgetSubPanelMediaartNewField extends SugarWidgetField //payattention to the name of class here

function displayHeaderCell(&$layout_def){
if(!empty($layout_def['displayHeaderCell']) && $layout_def['displayHeaderCell'] == false) {
return ' ';
else {
return parent::displayHeaderCell($layout_def);

function displayList(&$layout_def){
global $focus;
$key = strtoupper($layout_def['varname']);
$key = $this->_get_column_alias($layout_def);
$key = strtoupper($key);
// Current ProductTemplate record (in current subpanel row)
$module = $layout_def['module'];
$record = $layout_def['fields']['ID']; //id contract
$contractName = $layout_def['fields']['NAME']; //name contract


$parent_id=$_REQUEST['record']; //id account-a
//Here you define your logic, my quary to the database and the return from this function will be displayed in subpanel
//So for example you can do
$db = DBManagerFactory::getInstance();
$query = "SELECT * FROM contracts WHERE id = '$record' and account_id = '$parent_id'";
$result = $db->query($query, true,"greska");
$result = $db->fetchByAssoc($result);
$quantity = $result['broj_slucajeva'];
return $quantity; //value of this cariable will be shown in subpanel
} ?>

Lorem Ipsum

What is Lorem Ipsum?

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry’s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.

Why do we use it?

It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using ‘Content here, content here’, making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for ‘lorem ipsum’ will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).

Where does it come from?

Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of „de Finibus Bonorum et Malorum“ (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, „Lorem ipsum dolor sit amet..“, comes from a line in section 1.10.32.

How to: Replacing with CSS equivalent

Today i get new problem, how to add simple image properties by CSS.

On CSS, you don’t simply put HTML attributes into a stylesheet. CSS
has its own properties that only occasionally overlap with obsolete
HTML attributes.

There is no such property as ‘align’ or hspace/vspace in CSS. You are looking for the
‘float’ and ‘margin’ properties.  If a browser does anything with an align property, then
it’s proprietary behaviour that will not work across multiple browsers.

img {
float: right;

it’s same as HTML

>img align="right" hspace="5" vspace="5">

Web form to Custom Module

I need capture info from web to my custom SugarCRM module.
After some modification i use „Web to lead“ script:
if (... we are saving custom Module ...) {
$myinfo = new MyModule();
$myinfo->phone = $_REQUEST['phone'];
$myinfo->fax = $_REQUEST['fax'];
$myinfo->email = $_REQUEST['email']; // etc...

// done!
i f somebody have better soltion please write comment.

sport pick’s

Your favourite team is playing today? You want to bet but you are not sure who the winner will really be and what are your chances of winning a bet? Get your answer right now:

This web site is one of our latest completed tasks. It is a nice and simple web page devoted to sport fans.

Go: A New Programming Language from google

Google released a new, experimental programming language. People working in Google believes programming should be fast, productive, and most importantly, fun. Go combines the development speed of working in a dynamic language like Python with the performance of a compiled language like C. Typical builds feel instantaneous; even large binaries compile in just a few seconds and the code runs close to the speed of C. A short promotional video about the Go Programming Language presented by Russ Cox.