![](".$image_path."arrow_down.gif)
";
}
else
{
$sorder = 'ASC';
$arrow = "![](".$image_path."arrow_up.gif)
";
}
}
//crmv@9808
$name = "![](\"".resourcever("ok.gif")."\")
";
}
elseif ( $expiry_date < $today){
$expiry_date = getDisplayDate(date("Y-m-d",strtotime($expiry_date))); //crmv@35579
$value = "".$expiry_date." ![](\"".resourcever("no.gif")."\")
";
}
}
//crmv@7214e
elseif(($module == 'Quotes' && $name == 'Potential Name') || ($module == 'SalesOrder' && $name == 'Potential Name')) {
$potential_id = $adb->query_result($list_result,$i-1,"potentialid");
$potential_name = getPotentialName($potential_id);
$value = '",$sub_prod); $qty_stock=$adb->query_result($list_result,$list_result_count,'qtyinstock'); $slashes_temp_val = popup_from_html(getProductName($entity_id)); $slashes_temp_val = htmlspecialchars($slashes_temp_val,ENT_QUOTES,$default_charset); $description=$adb->query_result($list_result,$list_result_count,'description'); $slashes_desc = htmlspecialchars($description,ENT_QUOTES,$default_charset); $sub_products_link = 'popup_type.'&curr_row='.vtlib_purify($row_id).'¤cyid='.vtlib_purify($_REQUEST['currencyid']).'"\' > '.getTranslatedString('LBL_SUB_PRODUCTS',$module).''; //crmv@21048m //crmv@25897 if(!isset($_REQUEST['record_id'])){ $sub_products_query = $adb->pquery("SELECT * from ".$table_prefix."_seproductsrel WHERE productid=? AND setype='Products'",array($entity_id)); if($adb->num_rows($sub_products_query)>0) $list_header[]=$sub_products_link; else $list_header[]= $app_strings['LBL_NO_SUB_PRODUCTS']; } } if($module=='Services' && $focus->popup_type=='inventory_service') { global $default_charset; require('user_privileges/requireUserPrivileges.php'); // crmv@39110 $row_id = $_REQUEST['curr_row']; //To get all the tax types and values and pass it to product details $tax_str = ''; $tax_details = $InventoryUtils->getAllTaxes(); for($tax_count=0;$tax_count
',$groupNameList)); } } } } elseif(in_array($uitype,array(52,77))) { $value = getUserName($adb->query_result($list_result,$list_result_count,$colname),$showfullusername); //crmv@101008 } //crmv@18338 elseif($uitype == 5 || $uitype == 6 || $uitype == 23 || $uitype == 70 || $uitype == 1021) //crmv@18338 end { // crmv@67509 if($temp_val != '' && $temp_val != '0000-00-00') { if ($uitype == 5 || $uitype == 6 || $uitype == 23){ $temp_val = substr($temp_val,0,10); } $value = adjustTimezone($temp_val, 0, null, false); // crmv@25610-timezone crmv@50039 $value = getDisplayDate($value ?: $temp_val); } elseif($temp_val == '0000-00-00') { $value = ''; } else { $value = $temp_val; } // crmv@67509e } elseif($uitype == 15 || $uitype == 16 || ($uitype == 55 && $fieldname =="salutationtype")) { global $current_user,$adb; $roleid=$current_user->roleid; $values_arr = getAssignedPicklistValues($fieldname, $roleid, $adb,$module); //crmv@18228 if ($module == 'Calendar' && $colname == 'activitystatus'){ $values_arr = array_merge($values_arr,getAssignedPicklistValues('eventstatus', $roleid, $adb,$module)); } //crmv@18228 end $value = $adb->query_result_no_html($list_result,$list_result_count,$colname); // crmv@186665 $value_decoded = decode_html($value); $pickcount = count($values_arr); //crmv@fix activitytype if (!($module == 'Calendar' && $fieldname == 'activitytype' && $value == 'Task')){ if ($pickcount > 0){ if (!in_array($value_decoded,array_keys($values_arr)) && $value_decoded != '') $value = "".$app_strings['LBL_NOT_ACCESSIBLE'].""; else $value = textlength_check($values_arr[$value_decoded]); } elseif($pickcount == 0 && count($value)) { $value = "".$app_strings['LBL_NOT_ACCESSIBLE'].""; } } else{ $value = getTranslatedString($value,$module); } //crmv@fix activitytype end } //crmv@8982 elseif($uitype == 1015) { $temp_val = decode_html($adb->query_result($list_result,$list_result_count,$colname)); $value = textlength_check(to_html(PickListMulti::getTranslatedPicklist($temp_val,$colname))); } //crmv@8982e elseif($uitype == 71 || $uitype == 72) { if($temp_val != '') { if(in_array($fieldname, array('unit_price', 'unit_cost'))) { // crmv@92112 $currency_id = $InventoryUtils->getProductBaseCurrency($entity_id,$module); $cursym_convrate = getCurrencySymbolandCRate($currency_id); $value = "".$cursym_convrate['symbol']." ". $temp_val; } else { $rate = $user_info['conv_rate']; //changes made to remove vte_currency symbol infront of each vte_potential amount if ($temp_val != 0) $value = convertFromMasterCurrency($temp_val,$rate); // crmv@92519 else $value = $temp_val; $value = formatUserNumber(floatval($value)); // crmv@83877 } } else { $value = ''; } // crmv@83877 crmv@92112 } elseif($uitype == 7 || $uitype == 9) { if ($value !== '') { $value = formatUserNumber(floatval($temp_val), true); } // crmv@83877e crmv@92112e } elseif($uitype == 17) { $value = ''.$temp_val.''; } //crmv@7216 elseif($uitype == 1013 && ($_REQUEST['action'] != 'Popup' && $_REQUEST['file'] != 'Popup')) { if(isPermitted("Fax","EditView") == 'yes') { //check added for fax link in user detailview $querystr="SELECT fieldid FROM ".$table_prefix."_field WHERE tabid=? and fieldname=?"; $queryres = $adb->pquery($querystr, array(getTabid($module), $fieldname)); $fieldid = $adb->query_result($queryres,0,'fieldid'); $value = ''.$temp_val.''; } else $value = $temp_val; } //crmv@7216e elseif($uitype == 13 || $uitype == 104 && ($_REQUEST['action'] != 'Popup' && $_REQUEST['file'] != 'Popup')) { if(VteSession::get('internal_mailer') == 1) { //check added for email link in user detailview $querystr="SELECT fieldid FROM ".$table_prefix."_field WHERE tabid=? and fieldname=?"; $queryres = $adb->pquery($querystr, array(getTabid($module), $fieldname)); //Change this index 0 - to get the vte_fieldid based on email1 or email2 $fieldid = $adb->query_result($queryres,0,'fieldid'); $value = ''.$temp_val.''; } else $value = ''.$temp_val.''; } elseif($uitype == 56) { if($temp_val == 1) { $value = $app_strings['yes']; } else { $value = $app_strings['no']; } } elseif($uitype == 61) { //crmv@7216 if ($module == 'Fax') { $attachmentid = [];//crmv@204903 $res_fax=$adb->pquery("SELECT * FROM ".$table_prefix."_seattachmentsrel WHERE crmid = ?",array($entity_id)); $n_fax=$adb->num_rows($res_fax); for ($i=0;$i<$n_fax;$i++){ $attachmentid[]= $adb->query_result($res_fax,$i,'attachmentsid'); } $value=""; $cnt_fax=count($attachmentid); $cnt2_fax=0; if ($cnt_fax>0){ foreach ($attachmentid as $att){ $attachmentname=$adb->query_result($adb->pquery("SELECT name FROM ".$table_prefix."_attachments WHERE attachmentsid = ?",array($att)),0,'name'); $value .=''.$attachmentname.''; $cnt2_fax++; if ($cnt2_fax < $cnt_fax ) $value.=", "; } } } //crmv@7216e else { $attachmentid=$adb->query_result($adb->pquery("SELECT * FROM ".$table_prefix."_seattachmentsrel WHERE crmid = ?", array($entity_id)),0,'attachmentsid'); $value = ''.$temp_val.''; } } elseif($uitype == 98) { $value = ''.textlength_check(getRoleName($temp_val)).''; } //crmv@7220 //crmv@17471 elseif(($uitype == 11 || $uitype == 1014) && get_use_asterisk($current_user->id) == 'true') { $value = "".$temp_val.""; } //crmv@17471 end elseif($uitype == 33) { $value = ($temp_val != "") ? str_ireplace(' |##| ',', ',$temp_val) : ""; if(!$is_admin && $value != '') { $value = ($field_val != "") ? str_ireplace(' |##| ',', ',$field_val) : ""; if($value != '') { $value_arr=explode(',',trim($value)); $roleid=$current_user->roleid; $subrole = getRoleSubordinates($roleid); if(count($subrole)> 0) { $roleids = $subrole; array_push($roleids, $roleid); } else { $roleids = $roleid; } //crmv@19371 //se la picklist supporta il nuovo metodo if (in_array('picklist_valueid',$adb->database->MetaColumnNames($table_prefix."_$fieldname")) && $fieldname != 'product_lines'){ $order_by = "sortid,$fieldname"; $pick_query="select $fieldname from ".$table_prefix."_$fieldname where exists (select * from ".$table_prefix."_role2picklist where ".$table_prefix."_role2picklist.picklistvalueid = ".$table_prefix."_$fieldname.picklist_valueid and roleid in (". generateQuestionMarks($roleids) .")"; $pick_query.=" order by $order_by asc)"; $params = array($roleids); } //altrimenti uso il vecchio else { if (in_array('sortorderid',$adb->database->MetaColumnNames($table_prefix."_$fieldname"))) $order_by = "sortorderid,$fieldname"; else $order_by = $fieldname; $pick_query="select $fieldname from ".$table_prefix."_$fieldname"; if ($fieldname == 'product_lines') $pick_query .= ' where presence = 1'; //vtc e $pick_query.=" order by $order_by asc"; $params = array(); } //crmv@19371e $pickListResult = $adb->pquery($pick_query, $params); $picklistval = Array(); for($i=0;$i<$adb->num_rows($pickListResult);$i++) { $picklistarr[]=$adb->query_result($pickListResult,$i,$fieldname); } $value_temp = Array(); $string_temp = ''; $str_c = 0; foreach($value_arr as $ind => $val) { $notaccess = ''.$app_strings['LBL_NOT_ACCESSIBLE'].""; if(!(strlen(preg_replace("/(<\/?)(\w+)([^>]*>)/i","",$string_temp)) > $listview_max_textlength)) { $value_temp1 = (in_array(trim($val),$picklistarr))?$val:$notaccess; if($str_c!=0) $string_temp .= ' , '; $string_temp .= $value_temp1; $str_c++; } else $string_temp .='...'; } $value=$string_temp; } } } elseif($uitype == 85) { $value = ($temp_val != "") ? "{$temp_val}" : ""; } elseif($uitype == 116) { $value = ($temp_val != "") ? getCurrencyName($temp_val) : ""; } elseif($uitype == 117) { // NOTE: Without symbol the value could be used for filtering/lookup hence avoiding the translation $value = ($temp_val != "") ? getCurrencyName($temp_val,false) : ""; } //vtc elseif($uitype == 26){ $value = $this->getFolderName($module, $temp_val); } //vtc e //Added for email status tracking //crmv@26639 elseif($uitype == 25) { $entityid = $_REQUEST['record']; $emailid = $adb->query_result($list_result,$list_result_count,"crmid"); $result = $adb->pquery("SELECT access_count FROM ".$table_prefix."_email_track WHERE crmid=? AND mailid=?", array($entityid,$emailid)); $access_count = ''; if ($result && $adb->num_rows($result) > 0) { $access_count = $adb->query_result($result,0,"access_count"); } $result1 = $adb->pquery("SELECT send_mode FROM ".$table_prefix."_emaildetails WHERE emailid = ?", array($emailid)); if ($result1 && $adb->num_rows($result1) > 0) { $send_mode = $adb->query_result($result1,0,"send_mode"); } $value = $access_count; if (!$value) { if ($send_mode == 'multiple') { $value = 0; } else { $value = '-'; } } } //crmv@26639e //asterisk changes end here elseif($uitype == 8){ if(!empty($temp_val)){ $temp_val = html_entity_decode($temp_val,ENT_QUOTES,$default_charset); $json = new Zend_Json(); $value = vt_suppressHTMLTags(implode(',',$json->decode($temp_val))); } } //crmv@18338 elseif($uitype == 1020){ //crmv@46872 @TODO:optimize sla config if ($fieldname == 'sla_time'){ $sla_obj = CRMEntity::getInstance('SLA'); $sla_config_global = $sla_obj->get_config(); if ((count($sla_config_global)>0 && in_array($module,array_keys($sla_config_global)))){ switch ($sla_config_global[$module]['time_measure']){ case 'minutes': $temp_val = $temp_val*60; break; case 'hours': $temp_val = $temp_val*3600; break; case 'days': $temp_val = $temp_val*86400; break; } } } //crmv@46872 e $value=time_duration(abs($temp_val)); if (strpos($fieldname,"remaining")!==false || strpos($fieldname,"_out_")!==false){ if (strpos($fieldname,"remaining")!==false){ if ($temp_val<=0) $color = "red"; else $color = "green"; } if (strpos($fieldname,"_out_")!==false){ if ($temp_val>0) $color = "red"; else $color = "green"; } $value = "$value"; } } //crmv@18338 end //end email status tracking else { if($fieldname == $focus->list_link_field) { if($mode == "search") { //crmv@29190 global $autocomplete_return_function; if($popuptype == "specific" || $popuptype=="toDospecific") { // Added for get the first name of contact in Popup window if($colname == "lastname" && $module == 'Contacts') { $temp_val = getFullNameFromQResult($list_result,$list_result_count,"Contacts"); } $slashes_temp_val = popup_from_html($temp_val); $slashes_temp_val = htmlspecialchars($slashes_temp_val,ENT_QUOTES,$default_charset); //Added to avoid the error when select SO from Invoice through AjaxEdit if($module == 'SalesOrder') { $autocomplete_return_function[$entity_id] = 'set_return_specific("'.$entity_id.'", "'.nl2br(decode_html($slashes_temp_val)).'","'.$_REQUEST['form'].'");'; $value = ''.$temp_val.''; //crmv@21048m } elseif($module =='Contacts') { $cntct_focus = CRMEntity::getInstance('Contacts'); $cntct_focus->retrieve_entity_info($entity_id,"Contacts"); //ADDED TO CHECK THE FIELD PERMISSIONS FOR $xyz=array('mailingstreet','mailingcity','mailingzip','mailingpobox','mailingcountry','mailingstate','otherstreet','othercity','otherzip','otherpobox','othercountry','otherstate'); for($i=0;$i<12;$i++){ if (getFieldVisibilityPermission($module, $current_user->id,$xyz[$i]) == '0'){ $cntct_focus->column_fields[$xyz[$i]] = $cntct_focus->column_fields[$xyz[$i]]; } else $cntct_focus->column_fields[$xyz[$i]] = ''; } // For ToDo creation the underlying form is not named as EditView $form = !empty($_REQUEST['form']) ? $_REQUEST['form'] : ''; if(!empty($form)) $form = htmlspecialchars($form,ENT_QUOTES,$default_charset); $mailing_street = str_replace(array("\r","\n"),array('\r','\n'), popup_decode_html($cntct_focus->column_fields['mailingstreet'])); $other_street = str_replace(array("\r","\n"),array('\r','\n'), popup_decode_html($cntct_focus->column_fields['otherstreet'])); $autocomplete_return_function[$entity_id] = 'set_return_contact_address("'.$entity_id.'", "'.nl2br(decode_html($slashes_temp_val)).'", "'.$mailing_street.'", "'.$other_street.'", "'.popup_decode_html($cntct_focus->column_fields['mailingcity']).'", "'.popup_decode_html($cntct_focus->column_fields['othercity']).'", "'.popup_decode_html($cntct_focus->column_fields['mailingstate']).'", "'.popup_decode_html($cntct_focus->column_fields['otherstate']).'", "'.popup_decode_html($cntct_focus->column_fields['mailingzip']).'", "'.popup_decode_html($cntct_focus->column_fields['otherzip']).'", "'.popup_decode_html($cntct_focus->column_fields['mailingcountry']).'", "'.popup_decode_html($cntct_focus->column_fields['othercountry']).'","'.popup_decode_html($cntct_focus->column_fields['mailingpobox']).'", "'.popup_decode_html($cntct_focus->column_fields['otherpobox']).'","'.$form.'");'; $value = ''.$temp_val.''; //crmv@21048m } elseif($popuptype=='toDospecific') { $autocomplete_return_function[$entity_id] = 'set_return_toDospecific("'.$entity_id.'", "'.nl2br(decode_html($slashes_temp_val)).'");'; $value = ''.$temp_val.''; //crmv@21048m } else { $autocomplete_return_function[$entity_id] = 'set_return_specific("'.$entity_id.'", "'.nl2br(decode_html($slashes_temp_val)).'");'; $value = ''.$temp_val.''; //crmv@21048m } } elseif($popuptype == "detailview") { if($colname == "lastname" && ($module == 'Contacts' || $module == 'Leads')) { $temp_val = getFullNameFromQResult($list_result,$list_result_count,$module); } $slashes_temp_val = popup_from_html($temp_val); $slashes_temp_val = htmlspecialchars($slashes_temp_val,ENT_QUOTES,$default_charset); $focus->record_id = $_REQUEST['recordid']; if($_REQUEST['return_module'] == "Calendar" && $module == 'Contacts') //crmv@17001 { $autocomplete_return_function[$entity_id] = 'add_data_to_relatedlist_incal("'.$entity_id.'","'.decode_html($slashes_temp_val).'");'; $value = ''.$temp_val.''; } else { $autocomplete_return_function[$entity_id] = 'add_data_to_relatedlist("'.$entity_id.'","'.$focus->record_id.'","'.$module.'");'; $value = ''.$temp_val.''; //crmv@21048m } } elseif($popuptype == "inventory_prod") { $row_id = $_REQUEST['curr_row']; //To get all the tax types and values and pass it to product details $tax_str = ''; $tax_details = $InventoryUtils->getAllTaxes(); for($tax_count=0;$tax_count
",$sub_prod); $field_val = ListViewUtils::decodeFromDb($field_val); // crmv@16267 crmv@55228 $description = $adb->query_result_no_html($list_result,$list_result_count,'description'); $order_code = $adb->query_result_no_html($list_result,$list_result_count,'productcode'); $qty_stock = floatval($adb->query_result_no_html($list_result,$list_result_count,'qtyinstock')); // crmv@42024 $unit_cost = floatval($adb->query_result_no_html($list_result,$list_result_count,'unit_cost')); // crmv@198024 $confid = $adb->query_result_no_html($list_result,$list_result_count,'confproductid'); if ($confid > 0 && vtlib_isModuleActive('ConfProducts')) { $col_fields = [ 'record_id' => $entity_id, 'confproductid' => $confid, 'confprodinfo' => $adb->query_result_no_html($list_result,$list_result_count,'confprodinfo'), ]; $return_fields = array(); $xx = null; $focus->addAttributesBlock($col_fields, 'array', $return_fields, $xx, $xx); if (count($return_fields) > 0) { if (!empty($description)) $description .= "\n\n"; foreach ($return_fields as $attr) { $description .= "{$attr['fieldlabel']}: {$attr['value']}\n"; } } } // crmv@198024e $tmp_arr = array( "entityid" => $entity_id, "prodname" => $field_val, "unitprice" => formatUserNumber($unitprice), "qtyinstk" => formatUserNumber($qty_stock), "taxstring" => $tax_str, "rowid" => $row_id, "desc" => strip_tags($description), "subprod_ids" => $sub_det, "prod_code" => strip_tags($order_code), 'unit_cost' => $unit_cost, ); // prepare the list of arguments for the js callback $argList = array(); foreach ($tmp_arr as $key => $pval) { $argList[] = ListViewUtils::encodeForJs($pval, '"'); } $args = '"'.implode('", "', $argList).'"'; // js function $autocomplete_return_function[$entity_id] = "set_return_inventory($args);"; // prepare for html inclusion require_once('include/Zend/Json.php'); $autocompleteHtml = ListViewUtils::encodeForHtmlAttr($autocomplete_return_function[$entity_id], "'"); $prod_arr = ListViewUtils::encodeForHtmlAttr(Zend_Json::encode($tmp_arr), "'"); // html value $value = ''.$temp_val.''; //crmv@21048m //crmv@25989 //crmv@16267e crmv@55228e crmv@107331e } elseif($popuptype == "inventory_prod_po") { $row_id = $_REQUEST['curr_row']; //To get all the tax types and values and pass it to product details $tax_str = ''; $tax_details = $InventoryUtils->getAllTaxes(); for($tax_count=0;$tax_count
",$sub_prod); //crmv@16267 crmv@55228 $slashes_temp_val = popup_from_html($field_val); $slashes_temp_val = htmlspecialchars($slashes_temp_val,ENT_QUOTES,$default_charset); $description = popup_from_html($adb->query_result($list_result,$list_result_count,'description')); $slashes_temp_desc = decode_html(nl2br(htmlspecialchars($description,ENT_QUOTES,$default_charset))); $slashes_desc = stripslashes($slashes_temp_desc); $slashes_desc = str_replace(array("\r","\n",'"'),array('\r','\n','\"'),$slashes_desc); //crmv@28483 $order_code = $adb->query_result($list_result,$list_result_count,'productcode'); $unit_cost = floatval($adb->query_result($list_result,$list_result_count,'unit_cost')); $tmp_arr = array("entityid"=>$entity_id,"prodname"=>"".stripslashes(decode_html(nl2br($slashes_temp_val)))."","unitprice" => formatUserNumber($unitprice), "qtyinstk"=>formatUserNumber($qty_stock),"taxstring"=>"$tax_str","rowid"=>"$row_id","desc"=>"".strip_tags($slashes_desc)."","subprod_ids"=>"$sub_det","prod_code"=>"$order_code",'unit_cost'=>$unit_cost); // crmv@42024 require_once('include/Zend/Json.php'); $prod_arr = str_replace("'", ''', Zend_Json::encode($tmp_arr)); // crmv@92378 $autocomplete_return_function[$entity_id] = 'set_return_inventory_po("'.$entity_id.'", "'.decode_html(nl2br($slashes_temp_val)).'", "'.formatUserNumber($unitprice).'", "'.$tax_str.'","'.$row_id.'","'.strip_tags($slashes_desc).'","'.$sub_det.'","'.$order_code.'","'.$unit_cost.'");'; // crmv@42024 $value = ''.$temp_val.''; //crmv@21048m //crmv@16267e crmv@55228e } elseif($popuptype == "inventory_service") { $row_id = $_REQUEST['curr_row']; //To get all the tax types and values and pass it to product details $tax_str = ''; $tax_details = $InventoryUtils->getAllTaxes(); for($tax_count=0;$tax_count
';print_r($_REQUEST);echo ''; /* //commented due to usablity conflict -- Philip $output .= ''.$navigation_array['allflag'].' '; */ // vtlib Customization : For uitype 10 popup during paging if($_REQUEST['form'] == 'vtlibPopupView') { $url_string .= '&form=vtlibPopupView&forfield='.vtlib_purify($_REQUEST['forfield']).'&srcmodule='.vtlib_purify($_REQUEST['srcmodule']).'&forrecord='.vtlib_purify($_REQUEST['forrecord']); } // END $url_string = ''; if($module == 'Calendar' && $action_val == 'index') { if($_REQUEST['view'] == ''){ if($current_user->activity_view == "This Year"){ $mysel = 'year'; }else if($current_user->activity_view == "This Month"){ $mysel = 'month'; }else if($current_user->activity_view == "This Week"){ $mysel = 'week'; }else{ $mysel = 'day'; } } $data_value=date('Y-m-d H:i:s'); preg_match('/(\d{4})-(\d{2})-(\d{2}) (\d{2}):(\d{2}):(\d{2})/',$data_value,$value); $date_data = Array( 'day'=>$value[3], 'month'=>$value[2], 'year'=>$value[1], 'hour'=>$value[4], 'min'=>$value[5], ); $tab_type = ($_REQUEST['subtab'] == '')?'event':$_REQUEST['subtab']; $url_string .= isset($_REQUEST['view'])?"&view=".$_REQUEST['view']:"&view=".$mysel; $url_string .= isset($_REQUEST['subtab'])?"&subtab=".$_REQUEST['subtab']:''; $url_string .= isset($_REQUEST['viewOption'])?"&viewOption=".$_REQUEST['viewOption']:'&viewOption=listview'; $url_string .= isset($_REQUEST['day'])?"&day=".$_REQUEST['day']:'&day='.$date_data['day']; $url_string .= isset($_REQUEST['week'])?"&week=".$_REQUEST['week']:''; $url_string .= isset($_REQUEST['month'])?"&month=".$_REQUEST['month']:'&month='.$date_data['month']; $url_string .= isset($_REQUEST['year'])?"&year=".$_REQUEST['year']:"&year=".$date_data['year']; $url_string .= isset($_REQUEST['n_type'])?"&n_type=".$_REQUEST['n_type']:''; $url_string .= isset($_REQUEST['search_option'])?"&search_option=".$_REQUEST['search_option']:''; } if($module == 'Calendar' && $action_val != 'index') //added for the All link from the homepage -- ticket 5211 $url_string .= isset($_REQUEST['from_homepage'])?"&from_homepage=".$_REQUEST['from_homepage']:''; if(($navigation_array['prev']) != 0) { if($module == 'Calendar' && $action_val == 'index') { //$output .= '
';
$output .= ' ';
//$output .= '
';
$output .= ' ';
}
//crmv@8719
else if($action_val == "FindDuplicate")
{
$output .= ' . ')
';
$output .= ' . ')
';
}
//crmv@8719e
//vtc
elseif($module == 'Documents')
{
$output .= ' ';
$output .= ' ';
}
//vtc e
else{
$output .= ' ';
$output .= ' ';
}
}
else
{
$output .= '
';
$output .= '
';
}
for ($i=$navigation_array['first'];$i<=$navigation_array['end'];$i++){
if ($navigation_array['current']==$i){
$output .=''.$i.' ';
}
else{
if($module == 'Calendar' && $action_val == 'index')
{
//$output .= ''.$i.' ';
$output .= ''.$i.' ';
}
//crmv@8719
else if($action_val == "FindDuplicate")
$output .= ''.$i.' ';
//crmv@8719e
//vtc
elseif($module == 'Documents')
{
$output .= ''.$i.' ';
}
//vtc e
else
$output .= ''.$i.' ';
}
}
if(($navigation_array['next']) !=0)
{
if($module == 'Calendar' && $action_val == 'index')
{
//$output .= '
';
$output .= ' ';
//$output .= '
';
$output .= ' ';
}
//crmv@8719
else if($action_val == "FindDuplicate")
{
$output .= ' . ')
';
$output .= ' . ')
';
}
//crmv@8719e
//vtc
elseif($module == 'Documents')
{
$output .= ' ';
$output .= ' ';
}
//vtc e
else
{
$output .= ' ';
$output .= ' ';
}
}
else
{
$output .= '
';
$output .= '
';
}
//vtc
if($module != 'Documents')
$output .= ' ';
$output .= ' ';
}else{
$output .= ' . ')
';
$output .= ' . ')
';
}
// central input field
if($action_val == "FindDuplicate"){
$pageLink = "getDuplicateListViewEntries_js('$module','parenttab=$tabname&start='+this.value+'$url_string');";
}elseif($action_val == 'UnifiedSearch'){
$pageLink = "getUnifiedSearchEntries_js('$module','parenttab=$tabname&start='+this.value+'$url_string');";
}elseif($module == 'Documents'){
$pageLink = "getListViewEntries_js('$module','parenttab=$tabname&start='+this.value+'$url_string&folderid=$action_val');";
}elseif($module == 'Messages'){ //crmv@2963m
}else{
$pageLink = "getListViewEntries_js('$module','parenttab=$tabname&start='+this.value+'$url_string');";
}
if($module == 'Documents' && $action_val != 'UnifiedSearch'){
$url = '&folderid='.$action_val;
}else{
$url = '';
}
$jsHandler = "return VT_disableFormSubmit(event);";
$output .= getTranslatedString('Page', 'APP_STRINGS')." "; // crmv@31245
$output .= "";
$output .= "{$app_strings['LBL_LIST_OF']} {$navigation_array['verylast']}";
// last 2 buttons
if(($navigation_array['next']) !=0){
if($action_val == "FindDuplicate"){
$nextLink = 'getDuplicateListViewEntries_js(\''.$module.'\',\'parenttab='.$tabname.'&start='.$navigation_array['next'].$url_string.'\');';
$lastLink = 'getDuplicateListViewEntries_js(\''.$module.'\',\'parenttab='.$tabname.'&start='.$navigation_array['verylast'].$url_string.'\');';
}elseif($action_val == 'UnifiedSearch'){
$nextLink = 'getUnifiedSearchEntries_js(\''.$module.'\',\'parenttab='.$tabname.'&start='.$navigation_array['next'].$url_string.'\');';
$lastLink = 'getUnifiedSearchEntries_js(\''.$module.'\',\'parenttab='.$tabname.'&start='.$navigation_array['verylast'].$url_string.'\');';
}elseif($module == 'Documents'){
$nextLink = 'getListViewEntries_js(\''.$module.'\',\'parenttab='.$tabname.'&start='.$navigation_array['next'].$url_string.'&folderid='.$action_val.'\');';
$lastLink = 'getListViewEntries_js(\''.$module.'\',\'parenttab='.$tabname.'&start='.$navigation_array['verylast'].$url_string.'&folderid='.$action_val.'\');';
}else{
$nextLink = 'getListViewEntries_js(\''.$module.'\',\'parenttab='.$tabname.'&start='.$navigation_array['next'].$url_string.'\');';
$lastLink = 'getListViewEntries_js(\''.$module.'\',\'parenttab='.$tabname.'&start='.$navigation_array['verylast'].$url_string.'\');';
}
//crmv@2963m
if ($module == 'Messages'){
global $current_account, $current_folder, $thread;
$url_string .= "&account=$current_account&folder=$current_folder&thread=$thread";
$output .= ' ';
} else {
$output .= ' ';
$output .= ' ';
}
//crmv@2963me
}else{
$output .= ' . ')
';
$output .= ' . ')
';
}
// TODO: use a template instead!
if ($navigation_array['verylast'] == '1' || empty($navigation_array['verylast'])) {
$output = '';
} else {
//crmv@132891
$output = <<!['.$app_strings[$parent_module].']('.resourcever('themes/images/modulesimg/'.$parent_module.'.png').' "'.$app_strings[$parent_module].'"){kind=small}
';
}
$action = "DetailView";
if($parent_module == 'Accounts')
{
$parent_query = "SELECT accountname FROM ".$table_prefix."_account WHERE accountid=?";
$parent_result = $adb->pquery($parent_query, array($parent_id));
$parent_name = textlength_check($adb->query_result($parent_result,0,"accountname"));
}
if($parent_module == 'Leads')
{
$parent_query = "SELECT firstname,lastname FROM ".$table_prefix."_leaddetails WHERE leadid=?";
$parent_result = $adb->pquery($parent_query, array($parent_id));
$parent_name = getFullNameFromQResult($parent_result,0,"Leads");
}
if($parent_module == 'Potentials')
{
$parent_query = "SELECT potentialname FROM ".$table_prefix."_potential WHERE potentialid=?";
$parent_result = $adb->pquery($parent_query, array($parent_id));
$parent_name = textlength_check($adb->query_result($parent_result,0,"potentialname"));
}
if($parent_module == 'Products')
{
$parent_query = "SELECT productname FROM ".$table_prefix."_products WHERE productid=?";
$parent_result = $adb->pquery($parent_query, array($parent_id));
$parent_name = $adb->query_result($parent_result,0,"productname");
}
if($parent_module == 'Quotes')
{
$parent_query = "SELECT subject FROM ".$table_prefix."_quotes WHERE quoteid=?";
$parent_result = $adb->pquery($parent_query, array($parent_id));
$parent_name = $adb->query_result($parent_result,0,"subject");
}
if($parent_module == 'PurchaseOrder')
{
$parent_query = "SELECT subject FROM ".$table_prefix."_purchaseorder WHERE purchaseorderid=?";
$parent_result = $adb->pquery($parent_query, array($parent_id));
$parent_name = $adb->query_result($parent_result,0,"subject");
}
if($parent_module == 'Invoice')
{
$parent_query = "SELECT subject FROM ".$table_prefix."_invoice WHERE invoiceid=?";
$parent_result = $adb->pquery($parent_query, array($parent_id));
$parent_name = $adb->query_result($parent_result,0,"subject");
}
if($parent_module == 'SalesOrder')
{
$parent_query = "SELECT subject FROM ".$table_prefix."_salesorder WHERE salesorderid=?";
$parent_result = $adb->pquery($parent_query, array($parent_id));
$parent_name = $adb->query_result($parent_result,0,"subject");
}
//crmv@7216
if($parent_module == 'Contacts' && ($module == 'Emails' || $module == 'Fax' || $module =='Sms' || $module == 'HelpDesk'))
{
//crmv@7216e
$parent_query = "SELECT firstname,lastname FROM ".$table_prefix."_contactdetails WHERE contactid=?";
$parent_result = $adb->pquery($parent_query, array($parent_id));
$parent_name = getFullNameFromQResult($parent_result,0,"Contacts");
}
if($parent_module == 'HelpDesk')
{
$parent_query = "SELECT title FROM ".$table_prefix."_troubletickets WHERE ticketid=?";
$parent_result = $adb->pquery($parent_query, array($parent_id));
$parent_name = $adb->query_result($parent_result,0,"title");
//if(strlen($parent_name) > 25)
//{
$parent_name = textlength_check($parent_name);
//}
}
if($parent_module == 'Campaigns')
{
$parent_query = "SELECT campaignname FROM ".$table_prefix."_campaign WHERE campaignid=?";
$parent_result = $adb->pquery($parent_query, array($parent_id));
$parent_name = $adb->query_result($parent_result,0,"campaignname");
//if(strlen($parent_name) > 25)
//{
$parent_name = textlength_check($parent_name);
//}
}
if($parent_module == 'Vendors')
{
$parent_query = "SELECT vendorname FROM ".$table_prefix."_vendor WHERE vendorid=?";
$parent_result = $adb->pquery($parent_query, array($parent_id));
$parent_name = $adb->query_result($parent_result,0,"vendorname");
//if(strlen($parent_name) > 25)
//{
$parent_name = textlength_check($parent_name);
//}
}
//crmv@vistreport
if($parent_module == 'Visitreport')
{
$parent_query = "SELECT visitreportname FROM ".$table_prefix."_visitreport WHERE visitreportid=?";
$parent_result = $adb->pquery($parent_query, array($parent_id));
$parent_name = $adb->query_result($parent_result,0,"visitreportname");
//if(strlen($parent_name) > 25)
//{
$parent_name = textlength_check($parent_name);
//}
}
//crmv@vistreport e
//added by rdhital for better emails - Raju
if ($parent_module == 'Multiple')
{
$parent_value = $parent_name;
}
else
{
$parent_value = $module_icon."".textlength_check($parent_name)."";
}
//code added by raju ends
$log->debug("Exiting getRelatedTo method ...");
return $parent_value;
}
/**This function stores the variables in session sent in list view url string.
*Param $lv_array - list view session array
*Param $noofrows - no of rows
*Param $max_ent - maximum entires
*Param $module - module name
*Param $related - related module
*Return type void.
*/
function setSessionVar($lv_array,$noofrows,$max_ent,$module='',$related='')
{
$start = '';
if($noofrows>=1)
{
$lv_array['start']=1;
$start = 1;
}
elseif($related!='' && $noofrows == 0)
{
$lv_array['start']=1;
$start = 1;
}
else
{
$lv_array['start']=0;
$start = 0;
}
if(isset($_REQUEST['start']) && $_REQUEST['start'] !='')
{
$lv_array['start']=$_REQUEST['start'];
$start = $_REQUEST['start'];
}elseif(VteSession::getArray(array('rlvs', $module, $related, 'start')) != '')
{
if($related!='')
{
$lv_array['start']=VteSession::getArray(array('rlvs', $module, $related, 'start'));
$start = VteSession::getArray(array('rlvs', $module, $related, 'start'));
}
}
if(isset($_REQUEST['viewname']) && $_REQUEST['viewname'] !='')
$lv_array['viewname']=$_REQUEST['viewname'];
if($related=='')
setLVS($_REQUEST['module'],$lv_array);
else
VteSession::setArray(array('rlvs', $module, $related), $lv_array);
if ($start < ceil ($noofrows / $max_ent) && $start !='')
{
$start = ceil ($noofrows / $max_ent);
if($related=='')
setLVS($currentModule,$start,'start');
}
}
/** function used to get the account id for the given input account name
* @param string $account_name - account name to which we want the id
* return int $accountid - accountid for the given account name will be returned
*/
function getAccountId($account_name)
{
global $log;
$log->info("in getAccountId ".$account_name);
global $adb, $table_prefix;
if($account_name != '')
{
// for avoid single quotes error
//slashes_account_name = popup_from_html($account_name); /* Commented by Asha. Need to see if this is required as Prepared statements is used here*/
$sql = "select accountid from ".$table_prefix."_account INNER JOIN ".$table_prefix."_crmentity ON ".$table_prefix."_crmentity.crmid = ".$table_prefix."_account.accountid where ".$table_prefix."_crmentity.deleted = 0 and ".$table_prefix."_account.accountname=?";
$result = $adb->pquery($sql, array($account_name));
$accountid = $adb->query_result($result,0,"accountid");
}
return $accountid;
}
function decode_html($str)
{
global $default_charset;
$action = $_REQUEST['action'] ?? '';
$file = $_REQUEST['file'] ?? '';
if($action == 'Popup' || $file == 'Popup')
return html_entity_decode($str);
else
return html_entity_decode($str,ENT_QUOTES,$default_charset);
}
/**
* Alternative decoding function which coverts irrespective of $_REQUEST values.
* Useful incase of Popup (Listview etc...) where if decode_html will not work as expected
*/
function decode_html_force($str) {
global $default_charset;
return html_entity_decode($str,ENT_QUOTES,$default_charset);
}
function popup_decode_html($str)
{
global $default_charset;
$slashes_str = popup_from_html($str);
$slashes_str = htmlspecialchars($slashes_str,ENT_QUOTES,$default_charset);
$slashes_str = str_replace("\n",'\n',$slashes_str); //crmv@28482
return decode_html(br2nl($slashes_str));
}
//function added to check the text length in the listview.
//crmv@2963m crmv@146670
function textlength_check($field_val, $length = null) {
global $listview_max_textlength, $default_charset;
if (is_null($length)) $length = $listview_max_textlength;
if (is_string($field_val) && $length && $length > 0) { //crmv@167234
$temp_val = preg_replace("/(<\/?)(\w+)([^>]*>)/i","",$field_val);
$temp_val = trim(html_entity_decode($temp_val, ENT_QUOTES, $default_charset));
if (function_exists('mb_substr')) {
if(mb_strlen($temp_val,$default_charset) > $length) {
$temp_val = mb_substr($temp_val,0,$length,$default_charset).'...';
}
} else {
if(strlen($temp_val) > $length) {
$temp_val = substr($temp_val,0,$length).'...';
}
}
$temp_val = htmlentities($temp_val, ENT_QUOTES, $default_charset);
} else {
$temp_val = $field_val;
}
return $temp_val;
}
//crmv@2963me crmv@146670e
//crmv@16208
/**
* this function accepts a modulename and a fieldname and returns the first related module for it
* it expects the uitype of the field to be 10
* @param string $module - the modulename
* @param string $fieldname - the field name
* @return string $data - the first related module
*/
function getFirstModule($module, $fieldname){
global $adb, $table_prefix;
$sql = "select fieldid, uitype from ".$table_prefix."_field where tabid=? and fieldname=?";
$result = $adb->pquery($sql, array(getTabid($module), $fieldname));
if($adb->num_rows($result)>0){
$uitype = $adb->query_result($result, 0, "uitype");
if($uitype == 10){
$fieldid = $adb->query_result($result, 0, "fieldid");
$sql = "select * from ".$table_prefix."_fieldmodulerel where fieldid=?";
$result = $adb->pquery($sql, array($fieldid));
$count = $adb->num_rows($result);
if($count > 0){
$data = $adb->query_result($result, 0, "relmodule");
}
}
}
return $data;
}
//crmv@16208 end
function VT_getSimpleNavigationValues($start,$size,$total){
$prev = $start -1;
if($prev < 0){
$prev = 0;
}
if($total === null){
return array('start'=>$start,'first'=>$start,'current'=>$start,'end'=>$start,'end_val'=>$size,'allflag'=>'All',
'prev'=>$prev,'next'=>$start+1,'verylast'=>'last');
}
if(empty($total)){
$lastPage = 1;
}else{
$lastPage = ceil($total/$size);
}
$next = $start+1;
if($next > $lastPage){
$next = 0;
}
return array('start'=>$start,'first'=>$start,'current'=>$start,'end'=>$start,'end_val'=>$size,'allflag'=>'All',
'prev'=>$prev,'next'=>$next,'verylast'=>$lastPage);
}
//crmv@31245
function getRecordRangeMessage($numRows, $limitStartRecord, $noofrows = '') {
global $adb, $app_strings;
$recordListRangeMsg = '';
if ($noofrows){
if ($numRows > 0) {
if (($limitStartRecord+$numRows) > $noofrows)
$toNum = $noofrows;
else
$toNum = ($limitStartRecord+$numRows);
}
$recordListRangeMsg = sprintf($app_strings['LBL_LISTVIEW_NAVIGATION_STR1'], ($limitStartRecord+1), $toNum, $noofrows);
}
else {
if ($numRows > 0) {
$recordListRangeMsg = sprintf($app_strings['LBL_LISTVIEW_NAVIGATION_STR2'], ($limitStartRecord+1), ($limitStartRecord+$numRows));
}
}
return $recordListRangeMsg;
}
//crmv@31245e
function listQueryNonAdminChange($query, $module, $scope='') {
$instance = CRMEntity::getInstance($module);
return $instance->listQueryNonAdminChange($query,$module,$scope);
}
// crmv@57608
function listQueryNonAdminChange_parent($query, $module, $scope='', $onlyCondition = false) {
$instance = CRMEntity::getInstance($module);
return $instance->listQueryNonAdminChange_parent($query,$module,$scope, $onlyCondition);
}
// crmv@57608e
//crmv@31126 crmv@122985 crmv@185356
function getEntityId($module, $entityName) {
global $log, $adb;
$log->info("in getEntityId " . $entityName);
$ENU = EntityNameUtils::getInstance();
$entityId = $ENU->searchEntity($entityName, $module, 'single', false); // crmv@192957
if (!$entityId) {
$entityId = 0;
// search by skipping the cache
$sql = $ENU->getEntityNameQuery($module);
$sql = "SELECT crmid FROM ($sql) nt WHERE nt.entityname = ?";
$result = $adb->pquery($sql, array($entityName));
if ($adb->num_rows($result) > 0) {
$entityId = intval($adb->query_result_no_html($result, 0, 'crmid'));
}
}
return $entityId;
}
//crmv@31126e crmv@122985e crmv@185356e