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;
}
