PHP getTVDisplayFormat函数代码示例

//.........这里部分代码省略.........
         for ($j = $i; $j < $jMax; $j++) {
             $docId = $docIds[$j];
             $docCache =& $tvInfo[$docId];
             $inArray = array_keys($docCache);
             foreach ($inArray as &$tvName) {
                 $tvName = '\'' . $this->itsMODx->db->escape($tvName) . '\'';
             }
             $inList = implode(',', $inArray);
             $sqlArray[] = '(SELECT' . ' sc.id AS docid' . ', st.name AS name' . ', IF(stc.value != \'\',stc.value,st.default_text) AS value' . ', st.display AS display' . ', st.display_params AS display_params' . ', st.type AS type' . ' FROM ' . $st . ' st' . ' LEFT JOIN ' . $stc . ' stc' . ' ON st.id = stc.tmplvarid' . ' AND stc.contentid = ' . $docId . ' INNER JOIN ' . $stt . ' stt' . ' ON stt.tmplvarid = st.id' . ' INNER JOIN ' . $sc . ' sc' . ' ON sc.id = ' . $docId . ' WHERE' . ' st.name IN (' . $inList . ')' . ' AND sc.deleted = 0' . ')';
         }
         if (count($sqlArray) == 0) {
             continue;
         }
         $sql = implode(' UNION ', $sqlArray) . ';';
         // Grab the data from the database...
         $result = $this->itsMODx->db->query($sql);
         $count = $this->itsMODx->recordCount($result);
         // Set up find and replace arrays...
         $find = array();
         $replace = array();
         for ($j = 0; $j < $count; $j++) {
             $row = $this->itsMODx->db->getRow($result);
             $docId =& $row['docid'];
             $tvName =& $row['name'];
             $tvValue =& $row['value'];
             $tvDisplay =& $row['display'];
             $tvDisplayParams =& $row['display_params'];
             $tvType =& $row['type'];
             $matches =& $tvInfo[$docId][$tvName];
             include_once $basepath . '/tmplvars.format.inc.php';
             include_once $basepath . '/tmplvars.commands.inc.php';
             $w = '100%';
             $h = '300';
             $escapedvalue = YamsUtils::PregQuoteReplacement(getTVDisplayFormat($tvName, $tvValue, $tvDisplay, $tvDisplayParams, $tvType));
             foreach ($matches as $match => $phx) {
                 $find[] = $match;
                 $replace[] = $escapedvalue;
                 // TO DO: PHx stuff...
             }
         }
         if (count($find) == 0) {
             continue;
         }
         $content = preg_replace($find, $replace, $content, -1, $nReplacements);
         if ($nReplacements > 0) {
             $contentChanged = TRUE;
         }
     }
     // release the tv cache...
     unset($tvInfo);
     // Now loop over the dv array cache and write an SQL statement
     // that will grab the information from the database
     // a maximum of YAMS_DOC_LIMIT docs at a time
     $docIds = array_keys($dvInfo);
     $nDocs = count($docIds);
     $sc = $this->itsMODx->getFullTableName('site_content');
     $dg = $this->itsMODx->getFullTableName('document_groups');
     // get document groups for current user
     $docgrp = $this->itsMODx->getUserDocGroups();
     if (is_array($docgrp)) {
         $docgrp = implode(',', $docgrp);
     }
     // get document
     if ($this->itsMODx->isFrontend()) {
         $access = 'sc.privateweb=0';
     } else {

 /**
  * getTemplateVarOutput
  * @version 1.0.1 (2014-02-19)
  * 
  * @desc Returns an associative array containing TV rendered output values.
  * 
  * @param $idnames {array; '*'} - Which TVs to fetch - Can relate to the TV ids in the db (array elements should be numeric only) or the TV names (array elements should be names only). @required
  * @param $docid {integer; ''} - Id of a document to get. Default: an empty string which indicates the current document.
  * @param $published {0; 1; 'all'} - Document publication status. Once the parameter equals 'all', the result will be returned regardless of whether the ducuments are published or they are not. Default: 1.
  * @param $sep {string} - Separator that is used while concatenating in getTVDisplayFormat(). Default: ''.
  * 
  * @return {array; false} - Result array, or false.
  */
 function getTemplateVarOutput($idnames = array(), $docid = '', $published = 1, $sep = '')
 {
     if (count($idnames) == 0) {
         return false;
     } else {
         $output = array();
         $vars = $idnames == '*' || is_array($idnames) ? $idnames : array($idnames);
         $docid = intval($docid) ? intval($docid) : $this->documentIdentifier;
         // remove sort for speed
         $result = $this->getTemplateVars($vars, '*', $docid, $published, '', '');
         if ($result == false) {
             return false;
         } else {
             $baspath = MODX_MANAGER_PATH . 'includes';
             include_once $baspath . '/tmplvars.format.inc.php';
             include_once $baspath . '/tmplvars.commands.inc.php';
             for ($i = 0; $i < count($result); $i++) {
                 $row = $result[$i];
                 if (!$row['id']) {
                     $output[$row['name']] = $row['value'];
                 } else {
                     $output[$row['name']] = getTVDisplayFormat($row['name'], $row['value'], $row['display'], $row['display_params'], $row['type'], $docid, $sep);
                 }
             }
             return $output;
         }
     }
 }

 function appendTV($tvname, $docIDs)
 {
     global $modx;
     $baspath = MODX_MANAGER_PATH . "includes";
     include_once $baspath . "/tmplvars.format.inc.php";
     include_once $baspath . "/tmplvars.commands.inc.php";
     $tbl_site_tmplvar_contentvalues = $modx->getFullTableName('site_tmplvar_contentvalues');
     $tbl_site_tmplvars = $modx->getFullTableName('site_tmplvars');
     $rs = $modx->db->select("stv.name,stc.tmplvarid,stc.contentid,stv.type,stv.display,stv.display_params,stc.value", "{$tbl_site_tmplvar_contentvalues} stc LEFT JOIN {$tbl_site_tmplvars} stv ON stv.id=stc.tmplvarid ", "stv.name='{$tvname}' AND stc.contentid IN (" . implode($docIDs, ",") . ")", "stc.contentid ASC");
     $resourceArray = array();
     while ($row = $modx->db->getRow($rs)) {
         $resourceArray["#{$row['contentid']}"][$row['name']] = getTVDisplayFormat($row['name'], $row['value'], $row['display'], $row['display_params'], $row['type'], $row['contentid']);
     }
     if (count($resourceArray) != count($docIDs)) {
         $rs = $modx->db->select('name,type,display,display_params,default_text', $tbl_site_tmplvars, "name='{$tvname}'", 1);
         $row = $modx->db->getRow($rs);
         if (strtoupper($row['default_text']) == '@INHERIT') {
             foreach ($docIDs as $id) {
                 $output = getTVDisplayFormat($row['name'], $row['default_text'], $row['display'], $row['display_params'], $row['type'], $id);
                 if (!isset($resourceArray["#{$id}"])) {
                     $resourceArray["#{$id}"][$tvname] = $output;
                 }
             }
         } else {
             $output = getTVDisplayFormat($row['name'], $row['default_text'], $row['display'], $row['display_params'], $row['type'], $row['contentid']);
             foreach ($docIDs as $id) {
                 if (!isset($resourceArray["#{$id}"])) {
                     $resourceArray["#{$id}"][$tvname] = $output;
                 }
             }
         }
     }
     return $resourceArray;
 }

 public function renderTV($tvname)
 {
     $out = null;
     if ($this->getID() > 0) {
         include_once MODX_MANAGER_PATH . "includes/tmplvars.format.inc.php";
         include_once MODX_MANAGER_PATH . "includes/tmplvars.commands.inc.php";
         $tvval = $this->get($tvname);
         $param = APIHelpers::getkey($this->tvd, $tvname, array());
         $display = APIHelpers::getkey($param, 'display', '');
         $display_params = APIHelpers::getkey($param, 'display_params', '');
         $type = APIHelpers::getkey($param, 'type', '');
         $out = getTVDisplayFormat($tvname, $tvval, $display, $display_params, $type, $this->getID(), '');
     }
     return $out;
 }

 function getTemplateVarOutput($idnames = array(), $docid = "", $published = 1, $sep = '')
 {
     if (count($idnames) == 0) {
         return false;
     } else {
         $output = array();
         $vars = $idnames == '*' || is_array($idnames) ? $idnames : array($idnames);
         $docid = intval($docid) ? intval($docid) : $this->documentIdentifier;
         $result = $this->getTemplateVars($vars, "*", $docid, $published, "", "", $sep);
         // remove sort for speed
         if ($result == false) {
             return false;
         } else {
             $baspath = $this->config["base_path"] . "manager/includes";
             include_once $baspath . "/tmplvars.format.inc.php";
             include_once $baspath . "/tmplvars.commands.inc.php";
             for ($i = 0; $i < count($result); $i++) {
                 $row = $result[$i];
                 if (!$row['id']) {
                     $output[$row['name']] = $row['value'];
                 } else {
                     $output[$row['name']] = getTVDisplayFormat($row['name'], $row['value'], $row['display'], $row['display_params'], $row['type'], $docid, $sep);
                 }
             }
             return $output;
         }
     }
 }

 function appendTV($tvname, $docIDs)
 {
     global $modx;
     $baspath = $modx->config["base_path"] . "manager/includes";
     include_once $baspath . "/tmplvars.format.inc.php";
     include_once $baspath . "/tmplvars.commands.inc.php";
     $tb1 = $modx->getFullTableName("site_tmplvar_contentvalues");
     $tb2 = $modx->getFullTableName("site_tmplvars");
     $query = "SELECT stv.name,stc.tmplvarid,stc.contentid,stv.type,stv.display,stv.display_params,stc.value";
     $query .= " FROM " . $tb1 . " stc LEFT JOIN " . $tb2 . " stv ON stv.id=stc.tmplvarid ";
     $query .= " WHERE stv.name='" . $tvname . "' AND stc.contentid IN (" . implode($docIDs, ",") . ") ORDER BY stc.contentid ASC;";
     $rs = $modx->db->query($query);
     $tot = $modx->db->getRecordCount($rs);
     $resourceArray = array();
     for ($i = 0; $i < $tot; $i++) {
         $row = @$modx->fetchRow($rs);
         $resourceArray["#{$row['contentid']}"][$row['name']] = getTVDisplayFormat($row['name'], $row['value'], $row['display'], $row['display_params'], $row['type'], $row['contentid']);
     }
     if ($tot != count($docIDs)) {
         $query = "SELECT name,type,display,display_params,default_text";
         $query .= " FROM {$tb2}";
         $query .= " WHERE name='" . $tvname . "' LIMIT 1";
         $rs = $modx->db->query($query);
         $row = @$modx->fetchRow($rs);
         $defaultOutput = getTVDisplayFormat($row['name'], $row['default_text'], $row['display'], $row['display_params'], $row['type']);
         foreach ($docIDs as $id) {
             if (!isset($resourceArray["#{$id}"])) {
                 $resourceArray["#{$id}"][$tvname] = $defaultOutput;
             }
         }
     }
     return $resourceArray;
 }

 /**
  *
  * @param array $contentIds
  * @return array
  */
 function getTmplVars($contentIds)
 {
     $templateVars = array();
     if ($this->config['renderTVDisplayFormat']) {
         include_once MODX_MANAGER_PATH . "includes/tmplvars.format.inc.php";
         include_once MODX_MANAGER_PATH . "includes/tmplvars.commands.inc.php";
     }
     if (count($contentIds) > 0) {
         $query1 = "\r\n            SELECT tv.name FROM " . $this->modx->getFullTableName('site_tmplvars') . " tv\r\n            LEFT JOIN " . $this->modx->getFullTableName('site_tmplvar_templates') . " stvt ON stvt.tmplvarid = tv.id\r\n            WHERE stvt.templateid IN (SELECT DISTINCT template FROM " . $this->config['tbl_catalog'] . " WHERE id IN (" . implode(',', $contentIds) . "))\r\n          ";
         $tv_names_res = $this->modx->db->query($query1);
         $tv_names = array();
         if ($this->modx->db->getRecordCount($tv_names_res) > 0) {
             $query2 = "\r\n              SELECT tv.name, tvc.value, tvc.contentid, tv.display, tv.display_params, tv.type\r\n              FROM " . $this->modx->getFullTableName('site_tmplvars') . " tv, " . $this->config['tbl_catalog_tv'] . " tvc\r\n              WHERE tv.id = tvc.tmplvarid AND tvc.contentid IN (" . implode(',', $contentIds) . ")\r\n            ";
             $tv_values_res = $this->modx->db->query($query2);
             if ($this->modx->db->getRecordCount($tv_values_res) === 0) {
                 return $templateVars;
             }
             //get tv names
             while ($row = $this->modx->db->getRow($tv_names_res)) {
                 $tv_names[] = $row['name'];
             }
             unset($row);
             //get tv values
             while ($row = $this->modx->db->getRow($tv_values_res)) {
                 if ($this->config['renderTVDisplayFormat']) {
                     $tvout = getTVDisplayFormat($row['name'], $row['value'], $row['display'], $row['display_params'], $row['type'], $row['contentid']);
                     $templateVars[$row['contentid']] = !isset($templateVars[$row['contentid']]) ? array($row['name'] => $tvout) : array_merge($templateVars[$row['contentid']], array($row['name'] => $tvout));
                 } else {
                     $templateVars[$row['contentid']] = !isset($templateVars[$row['contentid']]) ? array($row['name'] => $row['value']) : array_merge($templateVars[$row['contentid']], array($row['name'] => $row['value']));
                 }
             }
             unset($row);
             //fill holes
             foreach ($templateVars as $key => &$val) {
                 $hole = array_diff($tv_names, array_keys($val));
                 foreach ($hole as $k => $v) {
                     $val[$v] = '';
                 }
             }
         }
     }
     return $templateVars;
 }

 function getTemplateVarOutput($idnames = array(), $docid = '', $published = 1, $sep = '')
 {
     if (is_array($idnames) && count($idnames) == 0) {
         return false;
     } else {
         $output = array();
         $vars = $idnames == '*' || is_array($idnames) ? $idnames : array($idnames);
         $docid = intval($docid) ? intval($docid) : $this->documentIdentifier;
         $result = $this->getTemplateVars($vars, '*', $docid, $published, '', '');
         // remove sort for speed
         if ($result == false) {
             return false;
         } else {
             $core_path = $this->config['core_path'];
             include_once "{$core_path}tmplvars.format.inc.php";
             include_once "{$core_path}tmplvars.commands.inc.php";
             foreach ($result as $row) {
                 if (!$row['id']) {
                     $output[$row['name']] = $row['value'];
                 } else {
                     $output[$row['name']] = getTVDisplayFormat($row['name'], $row['value'], $row['display'], $row['display_params'], $row['type'], $docid, $sep);
                 }
             }
             return $output;
         }
     }
 }

 /**
  * getTemplateVarOutput
  * @version 1.0 (2013-03-16)
  * 
  * @desc Returns the associative array of fields and TVs of a document.
  * 
  * @note
  * Differences from the native method:
  * 	— $published parameter can be set as false, and if it is then document publication status does not matter.
  * 
  * @param $idnames {array; '*'} - Id, TVs names, or documents fields to get. @required
  * @param $docid {integer; ''} - Id of a document to get. Default: Current document.
  * @param $published {false; 0; 1} - Document publication status which does not matter if published === false. Default: false.
  * @param $sep {string} - Separator that is used while concatenating in getTVDisplayFormat(). Default: ''.
  * 
  * @return {mixed} - Массив TV или false, если что-то не так.
  */
 public static function getTemplateVarOutput($idnames = array(), $docid = "", $published = false, $sep = '')
 {
     global $modx;
     if (count($idnames) == 0) {
         return false;
     } else {
         $output = array();
         $vars = $idnames == '*' || is_array($idnames) ? $idnames : array($idnames);
         $docid = intval($docid) ? intval($docid) : $modx->documentIdentifier;
         $result = self::getTemplateVars($vars, '*', $docid, $published, '', '');
         // remove sort for speed
         if ($result == false) {
             return false;
         } else {
             $baspath = $modx->config['base_path'] . 'manager/includes';
             include_once $baspath . '/tmplvars.format.inc.php';
             include_once $baspath . '/tmplvars.commands.inc.php';
             for ($i = 0; $i < count($result); $i++) {
                 $row = $result[$i];
                 if (!$row['id']) {
                     $output[$row['name']] = $row['value'];
                 } else {
                     $output[$row['name']] = getTVDisplayFormat($row['name'], $row['value'], $row['display'], $row['display_params'], $row['type'], $docid, $sep);
                 }
             }
             return $output;
         }
     }
 }