{"id":8971,"date":"2024-08-27T07:52:59","date_gmt":"2024-08-27T07:52:59","guid":{"rendered":"https:\/\/www.infinitivehost.com\/knowledge-base\/?p=8971"},"modified":"2024-08-31T08:01:20","modified_gmt":"2024-08-31T08:01:20","slug":"remove-11-crm-module-relationships-with-php-in-vtiger-7","status":"publish","type":"post","link":"https:\/\/www.infinitivehost.com\/knowledge-base\/remove-11-crm-module-relationships-with-php-in-vtiger-7\/","title":{"rendered":"Remove 1:1 CRM Module Relationships with PHP in Vtiger 7"},"content":{"rendered":"
<\/span> 1,134<\/span> Views<\/span><\/div>\n

To delete or remove a 1:1 relationship between (CRM Module) custom modules in Vtiger CRM 7 using a PHP script with vtlib functions, you need to follow these general steps:<\/p>\n\n\n\n

    \n
  1. Load Vtiger Framework<\/strong>: Ensure your script includes the necessary Vtiger framework files to interact with the CRM.<\/li>\n\n\n\n
  2. Identify Modules<\/strong>: Identify the custom modules involved in the relationship.<\/li>\n\n\n\n
  3. Remove Relationship<\/strong>: Use the vtlib functions to remove the relationship between these modules.<\/li>\n<\/ol>\n\n\n\n

    Here’s a sample PHP script demonstrating how to remove a 1:1 relationship between two custom modules, CustomModule1<\/code> and CustomModule2<\/code>:<\/p>\n\n\n\n

    <?php\n\/\/ Load Vtiger framework\nrequire_once 'include\/entryPoint.php';\nrequire_once 'include\/utils\/CommonUtils.php';\nrequire_once 'include\/utils\/UserInfoUtil.php';\nrequire_once 'modules\/Vtiger\/CRMEntity.php';\nrequire_once 'vtlib\/Vtiger\/Module.php';\n\n\/\/ Function to remove the relationship\nfunction removeRelationship($module1, $module2) {\n    global $adb;\n\n    \/\/ Get module instances\n    $moduleInstance1 = Vtiger_Module::getInstance($module1);\n    $moduleInstance2 = Vtiger_Module::getInstance($module2);\n\n    if ($moduleInstance1 && $moduleInstance2) {\n        \/\/ Get the relationship type between the two modules\n        $relationInfo = Vtiger_Relation_Model::getInstance($moduleInstance1, $moduleInstance2);\n\n        if ($relationInfo) {\n            \/\/ Delete the relationship\n            $relationInfo->delete();\n            echo \"1:1 relationship between $module1 and $module2 has been removed successfully.\";\n        } else {\n            echo \"No relationship found between $module1 and $module2.\";\n        }\n    } else {\n        echo \"One or both modules not found.\";\n    }\n}\n\n\/\/ Define your custom modules\n$customModule1 = 'CustomModule1'; \/\/ Replace with your actual custom module name\n$customModule2 = 'CustomModule2'; \/\/ Replace with your actual custom module name\n\n\/\/ Remove the relationship\nremoveRelationship($customModule1, $customModule2);\n\n?><\/code><\/mark><\/code><\/pre>\n\n\n\n
    Explanation:<\/h3>\n\n\n\n
      \n
    1. Load Vtiger Framework<\/strong>: The require_once<\/code> statements include necessary Vtiger files to ensure your script can interact with the Vtiger CRM framework.<\/li>\n\n\n\n
    2. Define Modules<\/strong>: You define the custom modules you want to work with (CustomModule1<\/code> and CustomModule2<\/code>). Replace these placeholders with the actual module names.<\/li>\n\n\n\n
    3. Get Module Instances<\/strong>: Using Vtiger_Module::getInstance()<\/code>, you get the instances of the modules.<\/li>\n\n\n\n
    4. Check Relationship<\/strong>: The Vtiger_Relation_Model::getInstance()<\/code> function checks for the existing relationship between the modules.<\/li>\n\n\n\n
    5. Delete Relationship<\/strong>: If the relationship exists, you call the delete()<\/code> method to remove it.<\/li>\n<\/ol>\n\n\n\n
      Notes:<\/h3>\n\n\n\n