function save_related_module($module, $crmid, $with_module, $with_crmid) { parent::save_related_module($module, $crmid, $with_module, $with_crmid); if ($with_module == 'ServiceContracts') { $serviceContract = CRMEntity::getInstance("ServiceContracts"); $serviceContract->updateHelpDeskRelatedTo($with_crmid, $crmid); $serviceContract->updateServiceContractState($with_crmid); } }
/** * Handle saving related module information. * NOTE: This function has been added to CRMEntity (base class). * You can override the behavior by re-defining it here. */ function save_related_module($module, $crmid, $with_module, $with_crmids) { if (!is_array($with_crmids)) { $with_crmids = array($with_crmids); } foreach ($with_crmids as $with_crmid) { parent::save_related_module($module, $crmid, $with_module, $with_crmid); if ($with_module == 'HelpDesk') { $this->updateHelpDeskRelatedTo($crmid, $with_crmid); $this->updateServiceContractState($crmid); } } }
function save_related_module($module, $crmid, $with_module, $with_crmids) { $adb = PearDatabase::getInstance(); if (!is_array($with_crmids)) { $with_crmids = array($with_crmids); } foreach ($with_crmids as $with_crmid) { if ($with_module == 'Contacts') { //When we select contact from potential related list $sql = "insert into vtiger_contpotentialrel values (?,?)"; $adb->pquery($sql, array($with_crmid, $crmid)); } elseif ($with_module == 'Products') { //when we select product from potential related list $sql = "insert into vtiger_seproductsrel values (?,?,?)"; $adb->pquery($sql, array($crmid, $with_crmid, 'Potentials')); } else { parent::save_related_module($module, $crmid, $with_module, $with_crmid); } } }
function save_related_module($module, $crmid, $with_module, $with_crmids) { $adb = PearDatabase::getInstance(); if (!is_array($with_crmids)) { $with_crmids = array($with_crmids); } foreach ($with_crmids as $with_crmid) { if ($with_module == 'Products') { $checkResult = $adb->pquery('SELECT 1 FROM vtiger_seproductsrel WHERE productid = ? AND crmid = ?', array($with_crmid, $crmid)); if ($checkResult && $adb->num_rows($checkResult) > 0) { continue; } $adb->pquery("insert into vtiger_seproductsrel values (?,?,?)", array($crmid, $with_crmid, 'Contacts')); } elseif ($with_module == 'Campaigns') { $checkResult = $adb->pquery('SELECT 1 FROM vtiger_campaigncontrel WHERE campaignid = ? AND contacrid = ?', array($with_crmid, $crmid)); if ($checkResult && $adb->num_rows($checkResult) > 0) { continue; } $adb->pquery("insert into vtiger_campaigncontrel values(?,?,1)", array($with_crmid, $crmid)); } elseif ($with_module == 'Potentials') { $adb->pquery("insert into vtiger_contpotentialrel values(?,?)", array($crmid, $with_crmid)); } elseif ($with_module == 'Vendors') { $adb->pquery("insert into vtiger_vendorcontactrel values (?,?)", array($with_crmid, $crmid)); } else { parent::save_related_module($module, $crmid, $with_module, $with_crmid); } } }
function save_related_module($module, $crmid, $with_module, $with_crmids) { $adb = PearDatabase::getInstance(); if (!is_array($with_crmids)) { $with_crmids = array($with_crmids); } foreach ($with_crmids as $with_crmid) { if ($with_module == 'Products') { $adb->pquery("insert into vtiger_seproductsrel values (?,?,?)", array($crmid, $with_crmid, $module)); } elseif ($with_module == 'Campaigns') { $adb->pquery("insert into vtiger_campaignleadrel values(?,?,1)", array($with_crmid, $crmid)); } else { parent::save_related_module($module, $crmid, $with_module, $with_crmid); } } }
function save_related_module($module, $crmid, $with_module, $with_crmids) { $adb = PearDatabase::getInstance(); if (!is_array($with_crmids)) { $with_crmids = array($with_crmids); } foreach ($with_crmids as $with_crmid) { if ($with_module == 'Leads' || $with_module == 'Accounts' || $with_module == 'Contacts' || $with_module == 'Potentials' || $with_module == 'Products') { $query = $adb->pquery("SELECT * from vtiger_seproductsrel WHERE crmid=? and productid=?", array($crmid, $with_crmid)); if ($adb->num_rows($query) == 0) { $adb->pquery("insert into vtiger_seproductsrel values (?,?,?)", array($with_crmid, $crmid, $with_module)); } } else { parent::save_related_module($module, $crmid, $with_module, $with_crmid); } } }
function save_related_module($module, $crmid, $with_module, $with_crmids) { $adb = $this->db; if (!is_array($with_crmids)) { $with_crmids = array($with_crmids); } foreach ($with_crmids as $with_crmid) { if ($with_module == 'Products') { $adb->pquery("insert into vtiger_seproductsrel values(?,?,?)", array($crmid, $with_crmid, $module)); } elseif ($with_module == 'Campaigns') { $checkResult = $adb->pquery('SELECT 1 FROM vtiger_campaignaccountrel WHERE campaignid = ? AND accountid = ?', array($with_crmid, $crmid)); if ($checkResult && $adb->num_rows($checkResult) > 0) { continue; } $adb->pquery("insert into vtiger_campaignaccountrel values(?,?,1)", array($with_crmid, $crmid)); } else { parent::save_related_module($module, $crmid, $with_module, $with_crmid); } } }
function save_related_module($module, $crmid, $with_module, $with_crmids) { $adb = PearDatabase::getInstance(); if (!is_array($with_crmids)) { $with_crmids = array($with_crmids); } foreach ($with_crmids as $with_crmid) { if ($with_module == 'Leads') { $checkResult = $adb->pquery('SELECT 1 FROM vtiger_campaignleadrel WHERE campaignid = ? AND leadid = ?', array($crmid, $with_crmid)); if ($checkResult && $adb->num_rows($checkResult) > 0) { continue; } $sql = 'INSERT INTO vtiger_campaignleadrel VALUES(?,?,1)'; $adb->pquery($sql, array($crmid, $with_crmid)); } elseif ($with_module == 'Contacts') { $checkResult = $adb->pquery('SELECT 1 FROM vtiger_campaigncontrel WHERE campaignid = ? AND contactid = ?', array($crmid, $with_crmid)); if ($checkResult && $adb->num_rows($checkResult) > 0) { continue; } $sql = 'INSERT INTO vtiger_campaigncontrel VALUES(?,?,1)'; $adb->pquery($sql, array($crmid, $with_crmid)); if (GlobalVariable::getVariable('Campaign_CreatePotentialOnContactRelation', '0') == '1') { self::createPotentialRelatedTo($with_crmid, $crmid); } } elseif ($with_module == 'Accounts') { $checkResult = $adb->pquery('SELECT 1 FROM vtiger_campaignaccountrel WHERE campaignid = ? AND accountid = ?', array($crmid, $with_crmid)); if ($checkResult && $adb->num_rows($checkResult) > 0) { continue; } $sql = 'INSERT INTO vtiger_campaignaccountrel VALUES(?,?,1)'; $adb->pquery($sql, array($crmid, $with_crmid)); if (GlobalVariable::getVariable('Campaign_CreatePotentialOnAccountRelation', '0') == '1') { self::createPotentialRelatedTo($with_crmid, $crmid); } } else { parent::save_related_module($module, $crmid, $with_module, $with_crmid); } } }
function save_related_module($module, $crmid, $with_module, $with_crmids) { $db = PearDatabase::getInstance(); $currentUser = Users_Record_Model::getCurrentUserModel(); if (!is_array($with_crmids)) { $with_crmids = [$with_crmids]; } foreach ($with_crmids as $with_crmid) { if ($with_module == 'Products') { $insert = $db->insert('vtiger_seproductsrel', ['crmid' => $crmid, 'productid' => $with_crmid, 'setype' => $module, 'rel_created_user' => $currentUser->getId(), 'rel_created_time' => date('Y-m-d H:i:s')]); } elseif ($with_module == 'Campaigns') { $checkResult = $db->pquery('SELECT 1 FROM vtiger_campaignaccountrel WHERE campaignid = ? AND accountid = ?', [$with_crmid, $crmid]); if ($db->getRowCount($checkResult) > 0) { continue; } $db->insert('vtiger_campaignaccountrel', ['campaignid' => $with_crmid, 'accountid' => $crmid, 'campaignrelstatusid' => 1]); } else { parent::save_related_module($module, $crmid, $with_module, $with_crmid); } } }
function save_related_module($module, $crmid, $with_module, $with_crmids) { $adb = PearDatabase::getInstance(); if (!is_array($with_crmids)) { $with_crmids = array($with_crmids); } foreach ($with_crmids as $with_crmid) { if ($with_module == 'Contacts') { $adb->pquery("insert into vtiger_vendorcontactrel values (?,?)", array($crmid, $with_crmid)); } elseif ($with_module == 'Products') { $adb->pquery("update vtiger_products set vendor_id=? where productid=?", array($crmid, $with_crmid)); } else { parent::save_related_module($module, $crmid, $with_module, $with_crmid); } } }
/** * Save the related module record information. Triggered from CRMEntity->saveentity method or updateRelations.php * @param String This module name * @param Integer This module record number * @param String Related module name * @param mixed Integer or Array of related module record number */ function save_related_module($module, $crmid, $with_module, $with_crmid) { global $adb; if ($module == 'Documents') { // in this case we have to turn the parameters around to call the parent method correctly if (!is_array($with_crmid)) { $with_crmid = array($with_crmid); } foreach ($with_crmid as $relcrmid) { $checkpresence = $adb->pquery("SELECT crmid FROM vtiger_senotesrel WHERE crmid = ? AND notesid = ?", array($relcrmid, $crmid)); // Relation already exists? No need to add again if ($checkpresence && $adb->num_rows($checkpresence)) { continue; } $adb->pquery("INSERT INTO vtiger_senotesrel(crmid, notesid) VALUES(?,?)", array($relcrmid, $crmid)); } } else { // just call parent method parent::save_related_module($module, $crmid, $with_module, $with_crmid); } }
/** * Here we override the parent's method, * This is done because the related lists for this module use a custom query * that queries the child module's table (column of the uitype10 field) * * @see data/CRMEntity#save_related_module($module, $crmid, $with_module, $with_crmid) */ function save_related_module($module, $crmid, $with_module, $with_crmid) { if (!in_array($with_module, array('ProjectMilestone', 'ProjectTask'))) { parent::save_related_module($module, $crmid, $with_module, $with_crmid); return; } /** * $_REQUEST['action']=='Save' when choosing ADD from Related list. * Do nothing on the project's entity when creating a related new child using ADD in relatedlist * by doing nothing we do not insert any line in the crmentity's table when * we are relating a module to this module */ if ($_REQUEST['action'] != 'updateRelations') { return; } $_REQUEST['submode'] = 'no_html_conversion'; //update the child elements' column value for uitype10 $destinationModule = vtlib_purify($_REQUEST['destination_module']); if (!is_array($with_crmid)) { $with_crmid = array($with_crmid); } foreach ($with_crmid as $relcrmid) { $child = CRMEntity::getInstance($destinationModule); $child->retrieve_entity_info($relcrmid, $destinationModule); $child->mode = 'edit'; $child->column_fields['projectid'] = $crmid; $child->save($destinationModule, $relcrmid); } }
function save_related_module($module, $crmid, $with_module, $with_crmids) { $db = PearDatabase::getInstance(); $currentUser = Users_Record_Model::getCurrentUserModel(); if (!is_array($with_crmids)) { $with_crmids = array($with_crmids); } foreach ($with_crmids as $with_crmid) { if ($with_module == 'Leads' || $with_module == 'Accounts' || $with_module == 'Contacts' || $with_module == 'Products') { $query = $db->pquery("SELECT * from vtiger_seproductsrel WHERE crmid=? and productid=?", array($crmid, $with_crmid)); if ($db->getRowCount($result) == 0) { $db->insert('vtiger_seproductsrel', ['crmid' => $with_crmid, 'productid' => $crmid, 'setype' => $with_module, 'rel_created_user' => $currentUser->getId(), 'rel_created_time' => date('Y-m-d H:i:s')]); } } else { parent::save_related_module($module, $crmid, $with_module, $with_crmid); } } }
/** * Handle saving related module information. * NOTE: This function has been added to CRMEntity (base class). * You can override the behavior by re-defining it here. */ function save_related_module($module, $crmid, $with_module, $with_crmid) { parent::save_related_module($module, $crmid, $with_module, $with_crmid); if ($with_module == 'HelpDesk') { $this->updateHelpDeskRelatedTo($crmid, $with_crmid); $this->updateServiceContractState($crmid); } }
function save_related_module($module, $crmid, $with_module, $with_crmids) { $adb = PearDatabase::getInstance(); $currentUser = Users_Record_Model::getCurrentUserModel(); if (!is_array($with_crmids)) { $with_crmids = array($with_crmids); } foreach ($with_crmids as $with_crmid) { if ($with_module == 'Products') { $adb->insert('vtiger_seproductsrel', ['crmid' => $crmid, 'productid' => $with_crmid, 'setype' => $module, 'rel_created_user' => $currentUser->getId(), 'rel_created_time' => date('Y-m-d H:i:s')]); } elseif ($with_module == 'Campaigns') { $adb->insert('vtiger_campaignleadrel', ['campaignid' => $with_crmid, 'leadid' => $crmid, 'campaignrelstatusid' => 1]); } else { parent::save_related_module($module, $crmid, $with_module, $with_crmid); } } }