public function retrieve($id) { global $adb, $default_charset, $site_URL; $ids = vtws_getIdComponents($id); $elemid = $ids[1]; $doc = parent::retrieve($id); // Add relations $relsrs = $adb->pquery("SELECT crmid FROM vtiger_senotesrel where notesid=?", array($elemid)); $rels = array(); while ($rl = $adb->fetch_array($relsrs)) { $rels[] = $this->vtyiicpng_getWSEntityId(getSalesEntityType($rl['crmid'])) . $rl['crmid']; } $doc['relations'] = $rels; if ($doc['filelocationtype'] == 'I') { // Add direct download link $relatt = $adb->pquery("SELECT attachmentsid FROM vtiger_seattachmentsrel WHERE crmid=?", array($elemid)); if ($relatt and $adb->num_rows($relatt) == 1) { $fileid = $adb->query_result($relatt, 0, 0); $attrs = $adb->pquery("SELECT * FROM vtiger_attachments WHERE attachmentsid = ?", array($fileid)); if ($attrs and $adb->num_rows($attrs) == 1) { $name = @$adb->query_result($attrs, 0, "name"); $filepath = @$adb->query_result($attrs, 0, "path"); $name = html_entity_decode($name, ENT_QUOTES, $default_charset); $doc['_downloadurl'] = $site_URL . "/" . $filepath . $fileid . "_" . $name; } } } return $doc; }
public function retrieve($id) { $element = parent::retrieve($id); $skipLineItemFields = getLineItemFields(); foreach ($skipLineItemFields as $key => $field) { if (array_key_exists($field, $element)) { unset($element[$field]); } } $handler = vtws_getModuleHandlerFromName('LineItem', $this->user); $idComponents = vtws_getIdComponents($id); $lineItems = $handler->getAllLineItemForParent($idComponents[1]); $element['LineItems'] = $lineItems; return $element; }
public function retrieve($id, $deleted = false) { global $adb; $ids = vtws_getIdComponents($id); $elemid = $ids[1]; $data = parent::retrieve($id); if (!Emails::EmailHasBeenSent($elemid)) { $data['date_start'] = ''; } // Add relations $relsrs = $adb->pquery("SELECT crmid FROM vtiger_senotesrel where notesid=?", array($elemid)); $rels = array(); while ($rl = $adb->fetch_array($relsrs)) { $rels[] = $this->vtyiicpng_getWSEntityId(getSalesEntityType($rl['crmid'])) . $rl['crmid']; } $data['relations'] = $rels; return $data; }