Exemple #1
0
 function getSortView($modname)
 {
     global $adb;
     $entityname = getModTabName($modname);
     $query = "select fieldid,columnname,fieldlabel from ec_field where \n\t\t\t\t\ttabid = {$entityname['tabid']} and uitype in (15,16,111) ";
     $result = $adb->getList($query);
     $numrows = $adb->num_rows($result);
     $treeproj = array();
     $tree["treeid"] = 'tree';
     $tree["treename"] = $app_strings["Category"];
     $tree["click"] = '';
     $tree["treeparent"] = '-1';
     $treeproj[] = $tree;
     if ($numrows > 0) {
         $mod_strings = return_specified_module_language("zh_cn", $modname);
         for ($i = 0; $i < $numrows; $i++) {
             $fieldid = $adb->query_result($result, $i, "fieldid");
             $columnname = $adb->query_result($result, $i, "columnname");
             $fieldlabel = $adb->query_result($result, $i, "fieldlabel");
             if ($app_strings[$fieldlabel]) {
                 $fieldtitle = $app_strings[$fieldlabel];
             } else {
                 if ($mod_strings[$fieldlabel]) {
                     $fieldtitle = $mod_strings[$fieldlabel];
                 } else {
                     $fieldtitle = $fieldlabel;
                 }
             }
             $tree = array();
             $tree["treeid"] = $fieldid;
             $tree["treename"] = $fieldtitle;
             $tree["click"] = '';
             $tree["treeparent"] = 'tree';
             $treeproj[] = $tree;
             if ($columnname == 'account_type') {
                 $colname = "accounttype";
             } else {
                 $colname = $columnname;
             }
             $picksql = "select colvalue from ec_picklist where colname = '{$colname}' order by sequence ";
             $pickresult = $adb->getList($picksql);
             $pickrows = $adb->num_rows($pickresult);
             if ($pickrows && $pickrows > 0) {
                 for ($j = 0; $j < $pickrows; $j++) {
                     $colvalue = $adb->query_result($pickresult, $j, "colvalue");
                     $tree = array();
                     $tree["treeid"] = $colvalue;
                     $tree["treename"] = $colvalue;
                     $tree["click"] = "search_field={$entityname['tablename']}.{$columnname}&\n\t\t\t\t\t\t\t\t\t\t\tsearch_text={$colvalue}&sortview={$sortview}";
                     $tree["treeparent"] = $fieldid;
                     $treeproj[] = $tree;
                 }
             }
         }
     }
     require_once "include/Zend/Json.php";
     $json = new Zend_Json();
     $jsontree = $json->encode($treeproj);
     return $jsontree;
 }
Exemple #2
0
global $app_strings, $adb, $current_user;
$sortview = $_REQUEST['sortview'];
$modname = $_REQUEST['modname'];
$entityname = getModTabName($modname);
if (!$entityname || empty($entityname)) {
    echo '';
    die;
}
if ($sortview == 'view_assort') {
    $key = "view_assort_{$modname}_" . $current_user->id;
    //$treeproj = getSqlCacheData($key);
    if (!$treeproj) {
        if ($modname == 'Contacts') {
            $modname = 'Accounts';
            $entityname = getModTabName("Accounts");
        }
        $query = "select fieldid,columnname,fieldlabel from ec_field where \n\t\t\t\t\ttabid = {$entityname['tabid']} and uitype in (15,16,111) ";
        $result = $adb->getList($query);
        $numrows = $adb->num_rows($result);
        $treeproj = array();
        $tree["treeid"] = 'tree';
        $tree["treename"] = $app_strings["Category"];
        $tree["click"] = '';
        $tree["treeparent"] = '-1';
        $treeproj[] = $tree;
        if ($numrows > 0) {
            $mod_strings = return_specified_module_language("zh_cn", $modname);
            for ($i = 0; $i < $numrows; $i++) {
                $fieldid = $adb->query_result($result, $i, "fieldid");
                $columnname = $adb->query_result($result, $i, "columnname");