public function revise($element)
 {
     $ids = vtws_getIdComponents($element["id"]);
     $element = DataTransform::sanitizeForInsert($element, $this->meta);
     $crmObject = new VtigerCRMObject($this->tabId, true);
     $crmObject->setObjectId($ids[1]);
     $error = $crmObject->revise($element);
     if (!$error) {
         throw new WebServiceException(WebServiceErrorCode::$DATABASEQUERYERROR, vtws_getWebserviceTranslatedString('LBL_' . WebServiceErrorCode::$DATABASEQUERYERROR));
     }
     $id = $crmObject->getObjectId();
     $error = $crmObject->read($id);
     if (!$error) {
         throw new WebServiceException(WebServiceErrorCode::$DATABASEQUERYERROR, vtws_getWebserviceTranslatedString('LBL_' . WebServiceErrorCode::$DATABASEQUERYERROR));
     }
     return DataTransform::filterAndSanitize($crmObject->getFields(), $this->meta);
 }
 public function update($element)
 {
     $ids = vtws_getIdComponents($element["id"]);
     $element = DataTransform::sanitizeForInsert($element, $this->meta);
     $crmObject = new VtigerCRMObject($this->tabId, true);
     $crmObject->setObjectId($ids[1]);
     $error = $crmObject->update($element);
     if (!$error) {
         throw new WebServiceException(WebServiceErrorCode::$DATABASEQUERYERROR, "Database error while performing required operation");
     }
     $id = $crmObject->getObjectId();
     $error = $crmObject->read($id);
     if (!$error) {
         throw new WebServiceException(WebServiceErrorCode::$DATABASEQUERYERROR, "Database error while performing required operation");
     }
     return DataTransform::filterAndSanitize($crmObject->getFields(), $this->meta);
 }
Exemplo n.º 3
0
 public function revise($element)
 {
     $ids = vtws_getIdComponents($element["id"]);
     $element = DataTransform::sanitizeForInsert($element, $this->meta);
     $element = $this->restrictFields($element, true);
     $success = $this->__retrieve($ids[1]);
     if (!$success) {
         throw new WebServiceException(WebServiceErrorCode::$RECORDNOTFOUND, "Record not found");
     }
     $allDetails = $this->getElement();
     foreach ($allDetails as $index => $value) {
         if (!isset($element)) {
             $element[$index] = $value;
         }
     }
     $success = $this->__revise($element, $ids[1]);
     if (!$success) {
         throw new WebServiceException(WebServiceErrorCode::$DATABASEQUERYERROR, "Database error while performing required operation");
     }
     return $this->retrieve(vtws_getId($this->meta->getEntityId(), $ids[1]));
 }
 public function update($element)
 {
     $ids = vtws_getIdComponents($element["id"]);
     $element = DataTransform::sanitizeForInsert($element, $this->meta);
     $element = $this->restrictFields($element);
     $columnStr = 'set ' . implode('=?,', array_keys($element)) . ' =? ';
     $query = 'update ' . $this->entityTableName . ' ' . $columnStr . 'where ' . $this->meta->getObectIndexColumn() . '=?';
     $params = array_values($element);
     array_push($params, $ids[1]);
     $result = null;
     $transactionSuccessful = vtws_runQueryAsTransaction($query, $params, $result);
     if (!$transactionSuccessful) {
         throw new WebServiceException(WebServiceErrorCode::$DATABASEQUERYERROR, "Database error while performing required operation");
     }
     return $this->retrieve(vtws_getId($ids[0], $ids[1]));
 }
Exemplo n.º 5
0
 public function update($element)
 {
     global $adb;
     $ids = vtws_getIdComponents($element["id"]);
     if (!empty($element['filename'])) {
         $element['filesize'] = $element['filename']['size'];
         $attachid = SaveAttachmentDB($element);
         $element['filetype'] = $element['filename']['type'];
         $element['filename'] = $filename = str_replace(' ', '_', $element['filename']['name']);
     }
     $relations = $element['relations'];
     unset($element['relations']);
     $element = DataTransform::sanitizeForInsert($element, $this->meta);
     $crmObject = new VtigerCRMObject($this->tabId, true);
     $crmObject->setObjectId($ids[1]);
     $error = $crmObject->update($element);
     if (!$error) {
         throw new WebServiceException(WebServiceErrorCode::$DATABASEQUERYERROR, "Database error while performing required operation");
     }
     $id = $crmObject->getObjectId();
     $error = $crmObject->read($id);
     if (!$error) {
         throw new WebServiceException(WebServiceErrorCode::$DATABASEQUERYERROR, "Database error while performing required operation");
     }
     if (!empty($attachid)) {
         // Link file attached to document
         $adb->pquery("DELETE from vtiger_seattachmentsrel where crmid=?", array($id));
         $adb->pquery("INSERT INTO vtiger_seattachmentsrel(crmid, attachmentsid) VALUES(?,?)", array($id, $attachid));
     }
     // Establish relations
     //$adb->pquery("DELETE from vtiger_senotesrel where crmid=?",Array($id));
     //foreach ($relations as $rel) {
     //	$ids = vtws_getIdComponents($rel);
     //	$relid = $ids[1];
     //	$adb->pquery("INSERT INTO vtiger_senotesrel(crmid, notesid) VALUES(?,?)",Array($relid, $id));
     //}
     return DataTransform::filterAndSanitize($crmObject->getFields(), $this->meta);
 }