示例#1
0
 function getListFiledOfModule($moduleName, $relID = false)
 {
     $db = PearDatabase::getInstance();
     $tabid = getTabid($moduleName);
     $sql = "select `fieldid`, `fieldlabel`, `uitype`, `block` from vtiger_field where tabid = ? AND presence <> ? AND typeofdata <> ? AND `block` NOT IN (?)";
     $result = $db->pquery($sql, array($tabid, 1, 'P~M', 0));
     $output = array();
     $block = ['blockId' => '', 'blockLabel' => ''];
     for ($i = 0; $i < $db->num_rows($result); $i++) {
         $blockid = $db->query_result($result, $i, 'block');
         if ($block['blockId'] != $blockid) {
             $block['blockId'] = $blockid;
             $block['blockLabel'] = getBlockName($blockid);
         }
         if ($relID) {
             $id = $db->query_result($result, $i, 'fieldid') . '||' . $relID;
         } else {
             $id = $db->query_result($result, $i, 'fieldid');
         }
         $output[$blockid][$i]['label'] = vtranslate($db->query_result($result, $i, 'fieldlabel'), $moduleName);
         $output[$blockid][$i]['id'] = $id;
         $output[$blockid][$i]['uitype'] = $db->query_result($result, $i, 'uitype');
         $output[$blockid]['blockLabel'] = vtranslate($block['blockLabel'], $moduleName);
     }
     return $output;
 }
示例#2
0
 function fixGetColumnsListbyBlockForInventory($module, $blockid, &$module_columnlist)
 {
     global $log;
     $blockname = getBlockName($blockid);
     if ($blockname == 'LBL_RELATED_PRODUCTS' && ($module == 'PurchaseOrder' || $module == 'SalesOrder' || $module == 'Quotes' || $module == 'Invoice')) {
         $fieldtablename = 'vtiger_inventoryproductrel';
         $fields = array('productid' => getTranslatedString('Product Name', $module), 'serviceid' => getTranslatedString('Service Name', $module), 'listprice' => getTranslatedString('List Price', $module), 'discount_amount' => getTranslatedString('Discount', $module), 'quantity' => getTranslatedString('Quantity', $module), 'comment' => getTranslatedString('Comments', $module));
         $fields_datatype = array('productid' => 'V', 'serviceid' => 'V', 'listprice' => 'I', 'discount_amount' => 'I', 'quantity' => 'I', 'comment' => 'V');
         foreach ($fields as $fieldcolname => $label) {
             $column_name = str_replace(' ', '__', $label);
             $fieldtypeofdata = $fields_datatype[$fieldcolname];
             $optionvalue = $fieldtablename . ":" . $fieldcolname . ":" . $module . "__" . $column_name . ":" . $fieldcolname . ":" . $fieldtypeofdata;
             $module_columnlist[$optionvalue] = $label;
         }
     }
     $log->info("Reports :: FieldColumns->Successfully returned ColumnslistbyBlock" . $module . $block);
     return $module_columnlist;
 }
示例#3
0
 /** Function to get vtiger_fields for the given module and block
  *  This function gets the vtiger_fields for the given module
  *  It accepts the module and the block as arguments and
  *  returns the array column lists
  *  Array module_columnlist[ vtiger_fieldtablename:fieldcolname:module_fieldlabel1:fieldname:fieldtypeofdata]=fieldlabel
  */
 function getColumnsListbyBlock($module, $block)
 {
     global $adb, $log, $current_user;
     if (is_string($block)) {
         $block = explode(",", $block);
     }
     $skipTalbes = array('vtiger_emaildetails', 'vtiger_attachments');
     $tabid = getTabid($module);
     if ($module == 'Calendar') {
         $tabid = array('9', '16');
     }
     $params = array($tabid, $block);
     require 'user_privileges/user_privileges_' . $current_user->id . '.php';
     //Security Check
     if ($is_admin == true || $profileGlobalPermission[1] == 0 || $profileGlobalPermission[2] == 0) {
         $sql = "select * from vtiger_field where vtiger_field.tabid in (" . generateQuestionMarks($tabid) . ") and vtiger_field.block in (" . generateQuestionMarks($block) . ") and vtiger_field.displaytype in (1,2,3) and vtiger_field.presence in (0,2) AND tablename NOT IN (" . generateQuestionMarks($skipTalbes) . ") ";
         //fix for Ticket #4016
         if ($module == "Calendar") {
             $sql .= " group by vtiger_field.fieldlabel order by sequence";
         } else {
             $sql .= " order by sequence";
         }
     } else {
         $profileList = getCurrentUserProfileList();
         $sql = "select * from vtiger_field inner join vtiger_profile2field on vtiger_profile2field.fieldid=vtiger_field.fieldid inner join vtiger_def_org_field on vtiger_def_org_field.fieldid=vtiger_field.fieldid where vtiger_field.tabid in (" . generateQuestionMarks($tabid) . ") and vtiger_field.block in (" . generateQuestionMarks($block) . ") and vtiger_field.displaytype in (1,2,3) and vtiger_profile2field.visible=0 and vtiger_def_org_field.visible=0 and vtiger_field.presence in (0,2)";
         if (count($profileList) > 0) {
             $sql .= " and vtiger_profile2field.profileid in (" . generateQuestionMarks($profileList) . ")";
             array_push($params, $profileList);
         }
         $sql .= ' and tablename NOT IN (' . generateQuestionMarks($skipTalbes) . ') ';
         //fix for Ticket #4016
         if ($module == "Calendar") {
             $sql .= " group by vtiger_field.fieldlabel order by sequence";
         } else {
             $sql .= " group by vtiger_field.fieldid order by sequence";
         }
     }
     array_push($params, $skipTalbes);
     $module_columnlist = array();
     $result = $adb->pquery($sql, $params);
     $noofrows = $adb->num_rows($result);
     for ($i = 0; $i < $noofrows; $i++) {
         $fieldtablename = $adb->query_result($result, $i, "tablename");
         $fieldcolname = $adb->query_result($result, $i, "columnname");
         $fieldname = $adb->query_result($result, $i, "fieldname");
         $fieldtype = $adb->query_result($result, $i, "typeofdata");
         $uitype = $adb->query_result($result, $i, "uitype");
         $fieldtype = explode("~", $fieldtype);
         $fieldtypeofdata = $fieldtype[0];
         $blockid = $adb->query_result($result, $i, "block");
         //Here we Changing the displaytype of the field. So that its criteria will be displayed correctly in Reports Advance Filter.
         $fieldtypeofdata = ChangeTypeOfData_Filter($fieldtablename, $fieldcolname, $fieldtypeofdata);
         if ($uitype == 68 || $uitype == 59) {
             $fieldtypeofdata = 'V';
         }
         if ($fieldtablename == "vtiger_crmentity") {
             $fieldtablename = $fieldtablename . $module;
         }
         if ($fieldname == "assigned_user_id") {
             $fieldtablename = "vtiger_users" . $module;
             $fieldcolname = "user_name";
         }
         if ($fieldname == "assigned_user_id1") {
             $fieldtablename = "vtiger_usersRel1";
             $fieldcolname = "user_name";
         }
         $fieldlabel = $adb->query_result($result, $i, "fieldlabel");
         if ($module == 'Emails' and $fieldlabel == 'Date & Time Sent') {
             $fieldlabel = 'Date Sent';
             $fieldtypeofdata = 'D';
         }
         $fieldlabel1 = str_replace(' ', '_', $fieldlabel);
         $fieldlabel1 = ReportRun::replaceSpecialChar($fieldlabel1);
         $optionvalue = $fieldtablename . ":" . $fieldcolname . ":" . $module . "_" . $fieldlabel1 . ":" . $fieldname . ":" . $fieldtypeofdata;
         $this->adv_rel_fields[$fieldtypeofdata][] = '$' . $module . '#' . $fieldname . '$' . "::" . getTranslatedString($module, $module) . " " . getTranslatedString($fieldlabel, $module);
         $module_columnlist[$optionvalue] = $fieldlabel;
     }
     $blockname = getBlockName($block);
     if ($blockname == 'LBL_RELATED_PRODUCTS' && in_array($module, getInventoryModules())) {
         $fieldtablename = 'vtiger_inventoryproductrel';
         $fields = array('productid' => getTranslatedString('Product Name', $module), 'serviceid' => getTranslatedString('Service Name', $module), 'listprice' => getTranslatedString('List Price', $module), 'discount' => getTranslatedString('Discount', $module), 'quantity' => getTranslatedString('Quantity', $module), 'comment' => getTranslatedString('Comments', $module));
         $fields_datatype = array('productid' => 'V', 'serviceid' => 'V', 'listprice' => 'N', 'discount' => 'N', 'quantity' => 'N', 'comment' => 'V');
         foreach ($fields as $fieldcolname => $label) {
             $fieldtypeofdata = $fields_datatype[$fieldcolname];
             if ($fieldcolname != 'productid' || $fieldcolname != 'serviceid') {
                 $optionvalue = $fieldtablename . $module . ":" . $fieldcolname . ":" . $module . "_" . $label . ":" . $fieldcolname . ":" . $fieldtypeofdata;
             } else {
                 $optionvalue = $fieldtablename . ":" . $fieldcolname . ":" . $module . "_" . $label . ":" . $fieldcolname . ":" . $fieldtypeofdata;
             }
             $module_columnlist[$optionvalue] = $label;
         }
     }
     $log->info("Reports :: FieldColumns->Successfully returned ColumnslistbyBlock" . $module . $block);
     return $module_columnlist;
 }
示例#4
0
 public function getBlockName()
 {
     if (empty($this->blockName)) {
         $this->blockName = getBlockName($this->blockId);
     }
     return $this->blockName;
 }
示例#5
0
 public static function getMainModuleFields($moduleName)
 {
     $db = PearDatabase::getInstance();
     if (is_array($moduleName)) {
         $moduleName = $moduleName['moduleName'];
     } elseif (strpos($moduleName, '+') !== false) {
         $moduleName = explode('+', $moduleName)[1];
     }
     $tabId = getTabid($moduleName);
     $query = 'SELECT `fieldid`, `fieldlabel`, `fieldname`, `uitype`, `block` FROM `vtiger_field` WHERE `tabid` = ? AND `presence` != ? AND `typeofdata` != ? AND `block` NOT IN (?) ORDER BY block,sequence;';
     $result = $db->pquery($query, [$tabId, 1, 'P~M', 0]);
     $output = [];
     $currentBlockId = '';
     $currentBlockName = '';
     $i = 0;
     while ($row = $db->fetchByAssoc($result)) {
         if ($currentBlockId != $row['block']) {
             $currentBlockName = vtranslate(getBlockName($row['block']), $moduleName);
         }
         $currentBlockId = $row['block'];
         $output[$currentBlockName][$i]['label'] = vtranslate($row['fieldlabel'], $moduleName);
         $output[$currentBlockName][$i]['id'] = $row['fieldid'];
         $output[$currentBlockName][$i]['name'] = $row['fieldname'];
         $output[$currentBlockName][$i]['uitype'] = $row['uitype'];
         $i++;
     }
     return $output;
 }
示例#6
0
            if (count($arr) < 3) {
                break;
            }
            $lines = explode(",", $arr[2]);
            foreach ($lines as $key => $value) {
                $lines[$key] = base64_decode($value);
            }
            $fdata = implode("<br />", $lines);
            break;
        case 23:
        case 24:
            $arr = explode("x ", $fdata);
            //Separate the quantity from the item/block number
            $item = explode(":", $arr[1]);
            //Separate the damage value from the item/block
            $changeString = $arr[0] . "x " . getBlockName($item[0]);
            //String is now "quantity"x "blockname"
            if ($item[1] != "0") {
                $changeString = $changeString . ":" . $item[1];
            }
            //If item has a damage value other than 0, add it to changeString
            $fdata = $changeString;
            break;
    }
    $action = str_replace(array_reverse(array_keys($lang["actions"])), array_reverse($lang["actions"]), $action);
    //Add to output row
    array_push($row, $entry->data_id, $entry->timestamp, $players[$entry->player_id], $action, $worlds[$entry->world_id], round($entry->x, 1) . "," . round($entry->y, 1) . "," . round($entry->z, 1), $fdata);
    array_push($output["data"], $row);
}
echo json_encode($output);
/*
示例#7
0
文件: Reports.php 项目: hardikk/HNH
 /** Function to get vtiger_fields for the given module and block
  *  This function gets the vtiger_fields for the given module
  *  It accepts the module and the block as arguments and 
  *  returns the array column lists
  *  Array module_columnlist[ vtiger_fieldtablename:fieldcolname:module_fieldlabel1:fieldname:fieldtypeofdata]=fieldlabel
  */
 function getColumnsListbyBlock($module, $block)
 {
     global $adb;
     global $log;
     global $current_user;
     if (is_string($block)) {
         $block = explode(",", $block);
     }
     $tabid = getTabid($module);
     if ($module == 'Calendar') {
         $tabid = array('9', '16');
     }
     $params = array($tabid, $block);
     require 'user_privileges/user_privileges_' . $current_user->id . '.php';
     //Security Check
     if ($is_admin == true || $profileGlobalPermission[1] == 0 || $profileGlobalPermission[2] == 0) {
         $sql = "select * from vtiger_field where vtiger_field.tabid in (" . generateQuestionMarks($tabid) . ") and vtiger_field.block in (" . generateQuestionMarks($block) . ") and vtiger_field.displaytype in (1,2,3) and vtiger_field.presence in (0,2) ";
         //fix for Ticket #4016
         if ($module == "Calendar") {
             $sql .= " group by vtiger_field.fieldlabel order by sequence";
         } else {
             $sql .= " order by sequence";
         }
     } else {
         $profileList = getCurrentUserProfileList();
         $sql = "select * from vtiger_field inner join vtiger_profile2field on vtiger_profile2field.fieldid=vtiger_field.fieldid inner join vtiger_def_org_field on vtiger_def_org_field.fieldid=vtiger_field.fieldid where vtiger_field.tabid in (" . generateQuestionMarks($tabid) . ")  and vtiger_field.block in (" . generateQuestionMarks($block) . ") and vtiger_field.displaytype in (1,2,3) and vtiger_profile2field.visible=0 and vtiger_def_org_field.visible=0 and vtiger_field.presence in (0,2)";
         if (count($profileList) > 0) {
             $sql .= " and vtiger_profile2field.profileid in (" . generateQuestionMarks($profileList) . ")";
             array_push($params, $profileList);
         }
         //fix for Ticket #4016
         if ($module == "Calendar") {
             $sql .= " group by vtiger_field.fieldid,vtiger_field.fieldlabel order by sequence";
         } else {
             $sql .= " group by vtiger_field.fieldid order by sequence";
         }
     }
     $result = $adb->pquery($sql, $params);
     $noofrows = $adb->num_rows($result);
     for ($i = 0; $i < $noofrows; $i++) {
         $fieldtablename = $adb->query_result($result, $i, "tablename");
         $fieldcolname = $adb->query_result($result, $i, "columnname");
         $fieldname = $adb->query_result($result, $i, "fieldname");
         $fieldtype = $adb->query_result($result, $i, "typeofdata");
         $uitype = $adb->query_result($result, $i, "uitype");
         $fieldtype = explode("~", $fieldtype);
         $fieldtypeofdata = $fieldtype[0];
         //Here we Changing the displaytype of the field. So that its criteria will be displayed correctly in Reports Advance Filter.
         $fieldtypeofdata = ChangeTypeOfData_Filter($fieldtablename, $fieldcolname, $fieldtypeofdata);
         if ($uitype == 68 || $uitype == 59) {
             $fieldtypeofdata = 'V';
         }
         if ($fieldtablename == "vtiger_crmentity") {
             $fieldtablename = $fieldtablename . $module;
         }
         if ($fieldname == "assigned_user_id") {
             $fieldtablename = "vtiger_users" . $module;
             $fieldcolname = "user_name";
         }
         if ($fieldname == "account_id") {
             $fieldtablename = "vtiger_account" . $module;
             $fieldcolname = "accountname";
         }
         if ($fieldname == "contact_id") {
             $fieldtablename = "vtiger_contactdetails" . $module;
             $fieldcolname = "lastname";
         }
         if ($fieldname == "parent_id") {
             $fieldtablename = "vtiger_crmentityRel" . $module;
             $fieldcolname = "setype";
         }
         if ($fieldname == "vendor_id") {
             $fieldtablename = "vtiger_vendorRel" . $module;
             $fieldcolname = "vendorname";
         }
         if ($fieldname == "potential_id") {
             $fieldtablename = "vtiger_potentialRel" . $module;
             $fieldcolname = "potentialname";
         }
         if ($fieldname == "assigned_user_id1") {
             $fieldtablename = "vtiger_usersRel1";
             $fieldcolname = "user_name";
         }
         if ($fieldname == 'quote_id') {
             $fieldtablename = "vtiger_quotes" . $module;
             $fieldcolname = "subject";
         }
         $product_id_tables = array("vtiger_troubletickets" => "vtiger_productsRel", "vtiger_campaign" => "vtiger_productsCampaigns", "vtiger_faq" => "vtiger_productsFaq");
         if ($fieldname == 'product_id' && isset($product_id_tables[$fieldtablename])) {
             $fieldtablename = $product_id_tables[$fieldtablename];
             $fieldcolname = "productname";
         }
         if ($fieldname == 'campaignid' && $module == 'Potentials') {
             $fieldtablename = "vtiger_campaign" . $module;
             $fieldcolname = "campaignname";
         }
         if ($fieldname == 'currency_id' && $fieldtablename == 'vtiger_pricebook') {
             $fieldtablename = "vtiger_currency_info" . $module;
             $fieldcolname = "currency_name";
         }
         $fieldlabel = $adb->query_result($result, $i, "fieldlabel");
         $fieldlabel1 = str_replace(" ", "_", $fieldlabel);
         $optionvalue = $fieldtablename . ":" . $fieldcolname . ":" . $module . "_" . $fieldlabel1 . ":" . $fieldname . ":" . $fieldtypeofdata;
         $this->adv_rel_fields[$fieldtypeofdata][] = '$' . $module . '#' . $fieldname . '$' . "::" . getTranslatedString($module, $module) . " " . $fieldlabel;
         //added to escape attachments fields in Reports as we have multiple attachments
         if ($module != 'HelpDesk' || $fieldname != 'filename') {
             $module_columnlist[$optionvalue] = $fieldlabel;
         }
     }
     $blockname = getBlockName($block);
     if ($blockname == 'LBL_RELATED_PRODUCTS' && ($module == 'PurchaseOrder' || $module == 'SalesOrder' || $module == 'Quotes' || $module == 'Invoice')) {
         $fieldtablename = 'vtiger_inventoryproductrel';
         $fields = array('productid' => getTranslatedString('Product Name', $module), 'serviceid' => getTranslatedString('Service Name', $module), 'listprice' => getTranslatedString('List Price', $module), 'discount' => getTranslatedString('Discount', $module), 'quantity' => getTranslatedString('Quantity', $module), 'comment' => getTranslatedString('Comments', $module));
         $fields_datatype = array('productid' => 'V', 'serviceid' => 'V', 'listprice' => 'I', 'discount' => 'I', 'quantity' => 'I', 'comment' => 'V');
         foreach ($fields as $fieldcolname => $label) {
             $fieldtypeofdata = $fields_datatype[$fieldcolname];
             $optionvalue = $fieldtablename . ":" . $fieldcolname . ":" . $module . "_" . $label . ":" . $fieldcolname . ":" . $fieldtypeofdata;
             $module_columnlist[$optionvalue] = $label;
         }
     }
     $log->info("Reports :: FieldColumns->Successfully returned ColumnslistbyBlock" . $module . $block);
     return $module_columnlist;
 }
示例#8
0
 /** Function to get vtiger_fields for the given module and block
  *  This function gets the vtiger_fields for the given module
  *  It accepts the module and the block as arguments and 
  *  returns the array column lists
  *  Array module_columnlist[ vtiger_fieldtablename:fieldcolname:module_fieldlabel1:fieldname:fieldtypeofdata]=fieldlabel
  */
 function getColumnsListbyBlock($module, $block, $relfieldid = "")
 {
     $r4u_columnlist_name = ITS4YouReports::getITS4YouReportStoreName($module, $block);
     $r4u_rel_fields_name = ITS4YouReports::getITS4YouReportStoreName("adv_rel_fields");
     $r4u_sel_fields_name = ITS4YouReports::getITS4YouReportStoreName("adv_sel_fields");
     unset($_SESSION[$r4u_columnlist_name]);
     unset($_SESSION[$r4u_rel_fields_name]);
     unset($_SESSION[$r4u_sel_fields_name]);
     //return false;
     if ($r4u_columnlist_name != "" && isset($_SESSION[$r4u_columnlist_name]) && !empty($_SESSION[$r4u_columnlist_name])) {
         $module_columnlist = unserialize($_SESSION[$r4u_columnlist_name]);
         $this->adv_rel_fields = unserialize($_SESSION[$r4u_rel_fields_name]);
         $this->adv_sel_fields = unserialize($_SESSION[$r4u_sel_fields_name]);
         return $module_columnlist;
     } else {
         unset($_SESSION[$r4u_columnlist_name]);
         //unset($_SESSION[$r4u_rel_fields_name]);
         //unset($_SESSION[$r4u_sel_fields_name]);
         $adb = PearDatabase::getInstance();
         if (is_string($block)) {
             $block = explode(",", $block);
         }
         $tabid = getTabid($module);
         if ($module == 'Calendar') {
             $tabid = array('9', '16');
         }
         $params = array($tabid, $block);
         $user_privileges_path = 'user_privileges/user_privileges_' . $this->current_user->id . '.php';
         if (file_exists($user_privileges_path)) {
             require $user_privileges_path;
         }
         //Security Check
         if ($is_admin == true || $profileGlobalPermission[1] == 0 || $profileGlobalPermission[2] == 0) {
             $sql = "select * from vtiger_field where vtiger_field.tabid in (" . generateQuestionMarks($tabid) . ") and vtiger_field.block in (" . generateQuestionMarks($block) . ") and vtiger_field.displaytype in (1,2,3) and vtiger_field.presence in (0,2) ";
             //fix for Ticket #4016
             if ($module == "Calendar") {
                 $sql .= " group by vtiger_field.fieldlabel order by sequence";
             } else {
                 $sql .= " order by sequence";
             }
         } else {
             $profileList = getCurrentUserProfileList();
             $sql = "select * from vtiger_field inner join vtiger_profile2field on vtiger_profile2field.fieldid=vtiger_field.fieldid inner join vtiger_def_org_field on vtiger_def_org_field.fieldid=vtiger_field.fieldid where vtiger_field.tabid in (" . generateQuestionMarks($tabid) . ")  and vtiger_field.block in (" . generateQuestionMarks($block) . ") and vtiger_field.displaytype in (1,2,3) and vtiger_profile2field.visible=0 and vtiger_def_org_field.visible=0 and vtiger_field.presence in (0,2)";
             if (count($profileList) > 0) {
                 $sql .= " and vtiger_profile2field.profileid in (" . generateQuestionMarks($profileList) . ")";
                 array_push($params, $profileList);
             }
             //fix for Ticket #4016
             if ($module == "Calendar") {
                 $sql .= " group by vtiger_field.fieldid,vtiger_field.fieldlabel order by sequence";
             } else {
                 $sql .= " group by vtiger_field.fieldid order by sequence";
             }
         }
         //$adb->setDebug(true);
         $f_result = $adb->pquery($sql, $params);
         //$adb->setDebug(false);
         $noofrows = $adb->num_rows($f_result);
         $lead_converted_added = false;
         for ($i = 0; $i < $noofrows; $i++) {
             //$_SESSION_r4u_rel_fields = unserialize($_SESSION[$r4u_rel_fields_name]);
             //$_SESSION_r4u_sel_fields = unserialize($_SESSION[$r4u_sel_fields_name]);
             $fieldid = $adb->query_result($f_result, $i, "fieldid");
             // ITS4YOU-UP SlOl 1. 10. 2013 10:46:35
             $fieldtablename = $adb->query_result($f_result, $i, "tablename");
             if ($this->primarymodule != $module) {
                 $fieldtablename = $fieldtablename;
                 if ($relfieldid != "") {
                     $fieldtablename .= "_{$relfieldid}";
                 }
             }
             $fieldcolname = $adb->query_result($f_result, $i, "columnname");
             $fieldname = $adb->query_result($f_result, $i, "fieldname");
             $fieldtype = $adb->query_result($f_result, $i, "typeofdata");
             $uitype = $adb->query_result($f_result, $i, "uitype");
             $fieldtype = explode("~", $fieldtype);
             // Fix to get table alias for orderby and groupby sql
             /* if ($relfieldid == "" && in_array($uitype, array("10",))) {
                $relfieldid = $fieldid;
                } */
             $fieldtypeofdata = $fieldtype[0];
             //Here we Changing the displaytype of the field. So that its criteria will be displayed correctly in Reports Advance Filter.
             $fieldtypeofdata = ChangeTypeOfData_Filter($fieldtablename, $fieldcolname, $fieldtypeofdata);
             if ($uitype == 68 || $uitype == 59) {
                 $fieldtypeofdata = 'V';
             }
             $fieldlabel = $adb->query_result($f_result, $i, "fieldlabel");
             $fieldlabel1 = $fieldlabel;
             if ($relfieldid != "") {
                 $relfieldid_str = $relfieldid;
             }
             // this is defining module id for uitype 10
             if ($relfieldid != "" && $this->primarymodule != $module) {
                 $rel_field_row = $adb->fetchByAssoc($adb->pquery("SELECT uitype FROM vtiger_field WHERE fieldid = ? ", array($relfieldid)), 0);
                 $rel_field_uitype = $rel_field_row["uitype"];
                 if ($rel_field_uitype == 10) {
                     $relfieldid_str = getTabid($module) . ":" . $relfieldid;
                 }
             }
             $module_lbl = vtranslate($module, $module);
             $optionvalue = $fieldtablename . ":" . $fieldcolname . ":" . $module . "_" . $fieldlabel1 . ":" . $fieldname . ":" . $fieldtypeofdata . ($relfieldid != "" ? ":" . $relfieldid_str : "");
             // $optionvalue = $fieldtablename.":".$fieldcolname.":".$module."_".$fieldlabel1.":".$fieldname.":".$fieldtypeofdata;
             $adv_rel_field_val = '$' . $module . '#' . $fieldname . '$' . "::" . $module_lbl . " " . $fieldlabel;
             $this->adv_rel_fields[$fieldtypeofdata][] = $adv_rel_field_val;
             // ITS4YOU-CR SlOl 26. 3. 2014 10:57:41
             if (in_array($uitype, ITS4YouReports::$s_uitypes) && !array_key_exists($optionvalue, $this->adv_sel_fields) && !in_array($module, array("Users"))) {
                 $this->adv_sel_fields[$optionvalue] = true;
             }
             // ITS4YOU-END 26. 3. 2014 10:57:44
             $translate_module = $module;
             //added to escape attachments fields in Reports as we have multiple attachments
             if ($module != 'HelpDesk' || $fieldname != 'filename') {
                 $module_columnlist[$optionvalue] = vtranslate($fieldlabel, $translate_module);
             }
             // ITS4YOU-CR SlOl - IS CONVERTED FIELD FOR LEADS
             if ($module == "Leads" && $block == 13 && $i == $noofrows - 1 && $lead_converted_added != true) {
                 $sc_col_str = "vtiger_leaddetails:converted:" . $module . "_Converted:converted:C";
                 $this->adv_sel_fields[$sc_col_str] = true;
                 $lead_converted_added = true;
                 $module_columnlist[$sc_col_str] = vtranslate("Converted", $module);
             }
             // CONVERTED END
             unset($_SESSION[$r4u_rel_fields_name]);
             $_SESSION[$r4u_rel_fields_name] = serialize($this->adv_rel_fields);
             unset($_SESSION[$r4u_sel_fields_name]);
             $_SESSION[$r4u_sel_fields_name] = serialize($this->adv_sel_fields);
         }
         $blockname = getBlockName($block);
         if ($blockname == 'LBL_RELATED_PRODUCTS' && in_array($module, self::$inventory_modules)) {
             if ($relfieldid != "") {
                 $rel_field_row = $adb->fetchByAssoc($adb->pquery("SELECT uitype FROM vtiger_field WHERE fieldid = ? ", array($relfieldid)), 0);
                 $rel_field_uitype = $rel_field_row["uitype"];
                 if ($rel_field_uitype == 10) {
                     $relfieldid_str = ":" . getTabid($module) . ":" . $relfieldid;
                 } else {
                     $relfieldid_str = ":" . $relfieldid;
                 }
             }
             $fieldtablename = 'vtiger_inventoryproductrel';
             if ($relfieldid != "") {
                 $fieldtablename .= "_{$relfieldid}";
             }
             $fields = array('prodname' => $module_lbl . " " . vtranslate('LBL_PRODUCT_SERVICE_NAME', $this->currentModule), 'ps_productcategory' => $module_lbl . " " . vtranslate('LBL_ITEM_CATEGORY', $this->currentModule), 'ps_productno' => $module_lbl . " " . vtranslate('LBL_ITEM_NO', $this->currentModule), 'comment' => $module_lbl . " " . vtranslate('Comments', $module), 'quantity' => $module_lbl . " " . vtranslate('Quantity', $module), 'listprice' => $module_lbl . " " . vtranslate('List Price', $module), 'ps_producttotal' => $module_lbl . " " . vtranslate('LBL_PRODUCT_TOTAL', $this->currentModule), 'discount' => $module_lbl . " " . vtranslate('Discount', $module), 'ps_productstotalafterdiscount' => $module_lbl . " " . vtranslate('LBL_PRODUCTTOTALAFTERDISCOUNT', $this->currentModule), 'ps_productvatsum' => $module_lbl . " " . vtranslate('LBL_PRODUCT_VAT_SUM', $this->currentModule), 'ps_producttotalsum' => $module_lbl . " " . vtranslate('LBL_PRODUCT_TOTAL_VAT', $this->currentModule));
             $fields_datatype = array('prodname' => 'V', 'ps_productcategory' => 'V', 'ps_productno' => 'V', 'comment' => 'V', 'prodname' => 'V', 'quantity' => 'I', 'listprice' => 'I', 'ps_producttotal' => 'I', 'discount' => 'I', 'ps_productstotalafterdiscount' => 'I', 'ps_productvatsum' => 'I', 'ps_producttotalsum' => 'I');
             $module_lbl = vtranslate($module, $module);
             foreach ($fields as $fieldcolname => $label) {
                 $fieldtypeofdata = $fields_datatype[$fieldcolname];
                 $optionvalue = $fieldtablename . ":" . $fieldcolname . ":" . $module . "_" . $label . ":" . $fieldcolname . ":" . $fieldtypeofdata . $relfieldid_str;
                 $module_columnlist[$optionvalue] = $label;
                 // $module_lbl." ".
             }
         }
         $_SESSION[$r4u_columnlist_name] = serialize($module_columnlist);
         return $module_columnlist;
     }
 }
示例#9
0
 function getFieldListbyBlock($module, $block, $type)
 {
     global $adb;
     global $log;
     global $current_user;
     if (is_string($block)) {
         $block = explode(",", $block);
     }
     $tabid = getTabid($module, $this->dbname);
     if ($module == 'Calendar') {
         $tabid = array('9', '16');
     }
     $params = array($tabid, $block);
     $sql = "select * from {$this->dbname}.vtiger_field where vtiger_field.tabid in (" . generateQuestionMarks($tabid) . ") and vtiger_field.block in (" . generateQuestionMarks($block) . ") and vtiger_field.displaytype in (1,2,3) and vtiger_field.presence in (0,2) ";
     $result = $adb->pquery($sql, $params);
     $pmod = getTabModuleName($this->primodule, $this->dbname);
     $noofrows = $adb->num_rows($result);
     for ($i = 0; $i < $noofrows; $i++) {
         $fieldtablename = $adb->query_result($result, $i, "tablename");
         $fieldcolname = $adb->query_result($result, $i, "columnname");
         $fieldname = $adb->query_result($result, $i, "fieldname");
         $fieldtype = $adb->query_result($result, $i, "typeofdata");
         $uitype = $adb->query_result($result, $i, "uitype");
         $fieldid = $adb->query_result($result, $i, "fieldid");
         $fieldtype = explode("~", $fieldtype);
         $fieldtypeofdata = $fieldtype[0];
         if ($uitype == 68 || $uitype == 59) {
             $fieldtypeofdata = 'V';
         }
         if ($fieldtablename == "vtiger_crmentity") {
             $fieldtablename = $fieldtablename . $module;
         }
         if ($fieldname == "assigned_user_id") {
             $fieldtablename = "vtiger_users" . $module;
             $fieldcolname = "user_name";
         }
         if ($fieldname == "assigned_user_id1") {
             $fieldtablename = "vtiger_usersRel1";
             $fieldcolname = "user_name";
         }
         $fieldlabel = $adb->query_result($result, $i, "fieldlabel");
         $fieldlabel1 = str_replace(" ", "_", $fieldlabel);
         if ($type == "related") {
             $optionvalue = $fieldtablename . ":" . $fieldcolname . ":" . $module . ":" . $fieldname . ":" . $fieldid . ":" . $type . ":" . $this->rel_fields->{$pmod}->{$module};
         } else {
             $optionvalue = $fieldtablename . ":" . $fieldcolname . ":" . $module . ":" . $fieldname . ":" . $fieldid . ":" . $type;
         }
         if ($module != 'HelpDesk' || $fieldname != 'filename') {
             $module_columnlist[$optionvalue] = $fieldlabel;
         }
     }
     $blockname = getBlockName($block, $this->dbname);
     if ($blockname == 'LBL_RELATED_PRODUCTS' && ($module == 'PurchaseOrder' || $module == 'SalesOrder' || $module == 'Quotes' || $module == 'Invoice')) {
         $fieldtablename = 'vtiger_inventoryproductrel';
         $fields = array('productid' => getTranslatedString('Product Name', $module), 'serviceid' => getTranslatedString('Service Name', $module), 'listprice' => getTranslatedString('List Price', $module), 'discount' => getTranslatedString('Discount', $module), 'quantity' => getTranslatedString('Quantity', $module), 'comment' => getTranslatedString('Comments', $module));
         $fields_datatype = array('productid' => 'V', 'serviceid' => 'V', 'listprice' => 'I', 'discount' => 'I', 'quantity' => 'I', 'comment' => 'V');
         foreach ($fields as $fieldcolname => $label) {
             $fieldtypeofdata = $fields_datatype[$fieldcolname];
             if ($type == "related") {
                 $optionvalue = $fieldtablename . ":" . $fieldcolname . ":" . $module . ":" . $fieldcolname . ":" . $fieldid . ":" . $type . ":" . $this->rel_fields->{$pmod}->{$module};
             } else {
                 $optionvalue = $fieldtablename . ":" . $fieldcolname . ":" . $module . ":" . $fieldcolname . ":" . $fieldid . ":" . $type;
             }
             $module_columnlist[$optionvalue] = $label;
         }
     }
     $log->info("Map :: FieldColumns->Successfully returned FieldlistbyBlock" . $module . $block);
     return $module_columnlist;
 }