function unlinkRelationship($id, $return_module, $return_id)
{
$log = vglobal('log');
if (empty($return_module) || empty($return_id)) {
return;
}
if ($return_module == 'Accounts') {
$this->trash($this->module_name, $id);
} elseif ($return_module == 'Campaigns') {
$sql = 'UPDATE vtiger_potential SET campaignid = ? WHERE potentialid = ?';
$this->db->pquery($sql, array(null, $id));
} elseif ($return_module == 'Products') {
$sql = 'DELETE FROM vtiger_seproductsrel WHERE crmid=? AND productid=?';
$this->db->pquery($sql, array($id, $return_id));
} elseif ($return_module == 'Contacts') {
$sql = 'DELETE FROM vtiger_contpotentialrel WHERE potentialid=? AND contactid=?';
$this->db->pquery($sql, array($id, $return_id));
} else {
parent::unlinkRelationship($id, $return_module, $return_id);
}
}
function unlinkRelationship($id, $return_module, $return_id)
{
$log = vglobal('log');
if (empty($return_module) || empty($return_id)) {
return;
}
if ($return_module == 'Accounts' || $return_module == 'Contacts') {
$this->trash('Invoice', $id);
} elseif ($return_module == 'SalesOrder') {
$relation_query = 'UPDATE vtiger_invoice set salesorderid=? where invoiceid=?';
$this->db->pquery($relation_query, array(null, $id));
} else {
parent::unlinkRelationship($id, $return_module, $return_id);
}
}
function unlinkRelationship($id, $return_module, $return_id)
{
$log = vglobal('log');
if (empty($return_module) || empty($return_id)) {
return;
}
if ($return_module == 'Accounts') {
$sql = 'UPDATE vtiger_contactdetails SET parentid = ? WHERE contactid = ?';
$this->db->pquery($sql, array(null, $id));
} elseif ($return_module == 'Potentials') {
$sql = 'DELETE FROM vtiger_contpotentialrel WHERE contactid=? AND potentialid=?';
$this->db->pquery($sql, array($id, $return_id));
} elseif ($return_module == 'Campaigns') {
$sql = 'DELETE FROM vtiger_campaigncontrel WHERE contactid=? AND campaignid=?';
$this->db->pquery($sql, array($id, $return_id));
} elseif ($return_module == 'Products') {
$sql = 'DELETE FROM vtiger_seproductsrel WHERE crmid=? AND productid=?';
$this->db->pquery($sql, array($id, $return_id));
} elseif ($return_module == 'Vendors') {
$sql = 'DELETE FROM vtiger_vendorcontactrel WHERE vendorid=? AND contactid=?';
$this->db->pquery($sql, array($return_id, $id));
} else {
parent::unlinkRelationship($id, $return_module, $return_id);
}
}
function unlinkRelationship($id, $return_module, $return_id)
{
$log = vglobal('log');
if (empty($return_module) || empty($return_id)) {
return;
}
if ($return_module == 'Campaigns') {
$sql = 'DELETE FROM vtiger_campaignleadrel WHERE leadid=? AND campaignid=?';
$this->db->pquery($sql, array($id, $return_id));
} elseif ($return_module == 'Products') {
$sql = 'DELETE FROM vtiger_seproductsrel WHERE crmid=? AND productid=?';
$this->db->pquery($sql, array($id, $return_id));
} else {
parent::unlinkRelationship($id, $return_module, $return_id);
}
}
function unlinkRelationship($id, $return_module, $return_id)
{
global $adb;
parent::unlinkRelationship($id, $return_module, $return_id);
$rs = $adb->pquery("select related_id,parent_id from vtiger_cobropago where cobropagoid=?", array($id));
if ($rs and $adb->num_rows($rs) == 1) {
$relatedId = $adb->query_result($rs, 0, 'related_id');
$pid = $adb->query_result($rs, 0, 'parent_id');
if (!empty($relatedId) and self::invoice_control_installed()) {
Invoice::updateAmountDue($relatedId);
}
// Calculate related module balance
CobroPago::calculateRelatedTotals($pid);
}
}
function unlinkRelationship($id, $return_module, $return_id)
{
$log = vglobal('log');
if (empty($return_module) || empty($return_id)) {
return;
}
if ($return_module == 'Accounts' || $return_module == 'Contacts') {
$sql_req = 'UPDATE vtiger_calculations SET relatedid=? WHERE calculationsid = ?';
$this->db->pquery($sql_req, array(null, $id));
} else {
parent::unlinkRelationship($id, $return_module, $return_id);
}
}
function unlinkRelationship($id, $return_module, $return_id)
{
$log = vglobal('log');
if (empty($return_module) || empty($return_id)) {
return;
}
if ($return_module == 'Leads') {
$sql = 'DELETE FROM vtiger_campaignleadrel WHERE campaignid=? AND leadid=?';
$this->db->pquery($sql, array($id, $return_id));
} elseif ($return_module == 'Contacts') {
$sql = 'DELETE FROM vtiger_campaigncontrel WHERE campaignid=? AND contactid=?';
$this->db->pquery($sql, array($id, $return_id));
} elseif ($return_module == 'Accounts') {
$sql = 'DELETE FROM vtiger_campaignaccountrel WHERE campaignid=? AND accountid=?';
$this->db->pquery($sql, array($id, $return_id));
$sql = 'DELETE FROM vtiger_campaigncontrel WHERE campaignid=? AND contactid IN (SELECT contactid FROM vtiger_contactdetails WHERE accountid=?)';
$this->db->pquery($sql, array($id, $return_id));
} else {
parent::unlinkRelationship($id, $return_module, $return_id);
}
}
function unlinkRelationship($id, $return_module, $return_id)
{
global $log;
if (empty($return_module) || empty($return_id)) {
return;
}
if ($return_module == 'Contacts') {
$sql = 'DELETE FROM vtiger_vendorcontactrel WHERE vendorid=? AND contactid=?';
$this->db->pquery($sql, array($id, $return_id));
} else {
parent::unlinkRelationship($id, $return_module, $return_id);
}
}
function unlinkRelationship($id, $return_module, $return_id)
{
$log = vglobal('log');
if (empty($return_module) || empty($return_id)) {
return;
}
if ($return_module == 'Accounts') {
$sql = 'UPDATE vtiger_troubletickets SET parent_id=? WHERE ticketid=?';
$this->db->pquery($sql, array(null, $id));
$se_sql = 'DELETE FROM vtiger_seticketsrel WHERE ticketid=?';
$this->db->pquery($se_sql, array($id));
} elseif ($return_module == 'Contacts') {
$sql = 'UPDATE vtiger_troubletickets SET contact_id=? WHERE ticketid=?';
$this->db->pquery($sql, array(null, $id));
$se_sql = 'DELETE FROM vtiger_seticketsrel WHERE ticketid=?';
$this->db->pquery($se_sql, array($id));
} elseif ($return_module == 'Products') {
$sql = 'UPDATE vtiger_troubletickets SET product_id=? WHERE ticketid=?';
$this->db->pquery($sql, array(null, $id));
} else {
parent::unlinkRelationship($id, $return_module, $return_id);
}
}
function unlinkRelationship($id, $return_module, $return_id)
{
$log = vglobal('log');
if (empty($return_module) || empty($return_id)) {
return;
}
if ($return_module == 'Accounts') {
$this->trash('SalesOrder', $id);
} elseif ($return_module == 'Quotes') {
$relation_query = 'UPDATE vtiger_salesorder SET quoteid=? WHERE salesorderid=?';
$this->db->pquery($relation_query, array(null, $id));
} elseif ($return_module == 'Potentials') {
$relation_query = 'UPDATE vtiger_salesorder SET potentialid=? WHERE salesorderid=?';
$this->db->pquery($relation_query, array(null, $id));
} elseif ($return_module == 'Contacts') {
$relation_query = 'UPDATE vtiger_salesorder SET contactid=? WHERE salesorderid=?';
$this->db->pquery($relation_query, array(null, $id));
} else {
parent::unlinkRelationship($id, $return_module, $return_id);
}
}
function unlinkRelationship($id, $return_module, $return_id)
{
$log = vglobal('log');
if (empty($return_module) || empty($return_id)) {
return;
}
if ($return_module == 'Leads' || $return_module == 'Contacts') {
$sql = 'DELETE FROM vtiger_seproductsrel WHERE productid = ? AND crmid = ?';
$this->db->pquery($sql, array($id, $return_id));
} elseif ($return_module == 'Vendors') {
$sql = 'UPDATE vtiger_products SET vendor_id = ? WHERE productid = ?';
$this->db->pquery($sql, array(null, $id));
} elseif ($return_module == 'Accounts') {
$sql = 'DELETE FROM vtiger_seproductsrel WHERE productid = ? AND (crmid = ? OR crmid IN (SELECT contactid FROM vtiger_contactdetails WHERE parentid=?))';
$param = array($id, $return_id, $return_id);
$this->db->pquery($sql, $param);
} else {
parent::unlinkRelationship($id, $return_module, $return_id);
}
}
function unlinkRelationship($id, $return_module, $return_id)
{
$log = vglobal('log');
if (empty($return_module) || empty($return_id)) {
return;
}
if ($return_module == 'Accounts' || $return_module == 'Contacts' || $return_module == 'Vendors') {
$sql_req = 'UPDATE vtiger_osscosts SET relategid=? WHERE osscostsid = ?';
$this->db->pquery($sql_req, array(null, $id));
} elseif ($return_module == 'Potentials') {
$sql_req = 'UPDATE vtiger_osscosts SET potentialid=? WHERE osscostsid = ?';
$this->db->pquery($sql_req, array(null, $id));
} elseif ($return_module == 'HelpDesk') {
$sql_req = 'UPDATE vtiger_osscosts SET ticketid=? WHERE osscostsid = ?';
$this->db->pquery($sql_req, array(null, $id));
} elseif ($return_module == 'Project') {
$sql_req = 'UPDATE vtiger_osscosts SET projectid=? WHERE osscostsid = ?';
$this->db->pquery($sql_req, array(null, $id));
} else {
parent::unlinkRelationship($id, $return_module, $return_id);
}
}
function unlinkRelationship($id, $return_module, $return_id)
{
$log = vglobal('log');
if (empty($return_module) || empty($return_id)) {
return;
}
if ($return_module == 'Vendors') {
$sql_req = 'UPDATE vtiger_crmentity SET deleted = 1 WHERE crmid= ?';
$this->db->pquery($sql_req, array($id));
} else {
parent::unlinkRelationship($id, $return_module, $return_id);
}
}
