$mod = "Accounts";
$id = vtlib_purify($_REQUEST['acc_id']);
}
}
$smarty->assign("mod_var_name", "parent_module");
$smarty->assign("mod_var_value", $mod);
$smarty->assign("recid_var_name", "relmod_id");
$smarty->assign("recid_var_value", $id);
$where_relquery .= getPopupCheckquery($currentModule, $mod, $id);
} else {
if (isset($_REQUEST['task_relmod_id'])) {
$smarty->assign("mod_var_name", "task_parent_module");
$smarty->assign("mod_var_value", vtlib_purify($_REQUEST['task_parent_module']));
$smarty->assign("recid_var_name", "task_relmod_id");
$smarty->assign("recid_var_value", vtlib_purify($_REQUEST['task_relmod_id']));
$where_relquery .= getPopupCheckquery($currentModule, $_REQUEST['task_parent_module'], $_REQUEST['task_relmod_id']);
}
}
if ($currentModule == 'Products' && !$_REQUEST['record_id'] && ($popuptype == 'inventory_prod' || $popuptype == 'inventory_prod_po')) {
$where_relquery .= " and vtiger_products.discontinued <> 0 AND (vtiger_products.productid NOT IN (SELECT crmid FROM vtiger_seproductsrel WHERE setype='Products'))";
} elseif ($currentModule == 'Products' && $_REQUEST['record_id'] && ($popuptype == 'inventory_prod' || $popuptype == 'inventory_prod_po')) {
$where_relquery .= " and vtiger_products.discontinued <> 0 AND (vtiger_products.productid IN (SELECT crmid FROM vtiger_seproductsrel WHERE setype='Products' AND productid=" . $adb->sql_escape_string($_REQUEST['record_id']) . "))";
} elseif ($currentModule == 'Products' && $_REQUEST['return_module'] != 'Products') {
$where_relquery .= " and vtiger_products.discontinued <> 0";
}
if ($_REQUEST['return_module'] == 'Products' && $currentModule == 'Products' && $_REQUEST['recordid']) {
$where_relquery .= " and vtiger_products.discontinued <> 0 AND (vtiger_crmentity.crmid NOT IN (" . $adb->sql_escape_string($_REQUEST['recordid']) . ") AND vtiger_crmentity.crmid NOT IN (SELECT productid FROM vtiger_seproductsrel WHERE setype='Products') AND vtiger_crmentity.crmid NOT IN (SELECT crmid FROM vtiger_seproductsrel WHERE setype='Products' AND productid=" . $adb->sql_escape_string($_REQUEST['recordid']) . "))";
}
if ($currentModule == 'Services' && $popuptype == 'inventory_service') {
$where_relquery .= " and vtiger_service.discontinued <> 0";
}
$mod = "Accounts";
$id = vtlib_purify($_REQUEST['acc_id']);
}
}
$smarty->assign("mod_var_name", "parent_module");
$smarty->assign("mod_var_value", $mod);
$smarty->assign("recid_var_name", "relmod_id");
$smarty->assign("recid_var_value", $id);
$where_relquery .= getPopupCheckquery($currentModule, $mod, $id);
} else {
if (isset($_REQUEST['task_relmod_id'])) {
$smarty->assign("mod_var_name", "task_parent_module");
$smarty->assign("mod_var_value", vtlib_purify($_REQUEST['task_parent_module']));
$smarty->assign("recid_var_name", "task_relmod_id");
$smarty->assign("recid_var_value", vtlib_purify($_REQUEST['task_relmod_id']));
$where_relquery .= getPopupCheckquery($currentModule, vtlib_purify($_REQUEST['task_parent_module']), vtlib_purify($_REQUEST['task_relmod_id']));
}
}
if ($currentModule == 'Products' && !$_REQUEST['record_id'] && ($popuptype == 'inventory_prod' || $popuptype == 'inventory_prod_po')) {
$where_relquery .= " and vtiger_products.discontinued <> 0 AND (vtiger_products.productid NOT IN (SELECT crmid FROM vtiger_seproductsrel WHERE setype='Products'))";
} elseif ($currentModule == 'Products' && $_REQUEST['record_id'] && ($popuptype == 'inventory_prod' || $popuptype == 'inventory_prod_po')) {
$where_relquery .= " and vtiger_products.discontinued <> 0 AND (vtiger_products.productid IN (SELECT crmid FROM vtiger_seproductsrel WHERE setype='Products' AND productid=" . $adb->sql_escape_string($_REQUEST['record_id']) . "))";
} elseif ($currentModule == 'Products' && $_REQUEST['return_module'] != 'Products') {
$where_relquery .= " and vtiger_products.discontinued <> 0";
}
if ($_REQUEST['return_module'] == 'Products' && $currentModule == 'Products' && $_REQUEST['recordid']) {
$where_relquery .= " and vtiger_products.discontinued <> 0 AND (vtiger_crmentity.crmid NOT IN (" . $adb->sql_escape_string($_REQUEST['recordid']) . ") AND vtiger_crmentity.crmid NOT IN (SELECT productid FROM vtiger_seproductsrel WHERE setype='Products') AND vtiger_crmentity.crmid NOT IN (SELECT crmid FROM vtiger_seproductsrel WHERE setype='Products' AND productid=" . $adb->sql_escape_string($_REQUEST['recordid']) . "))";
}
if ($currentModule == 'Services' && $popuptype == 'inventory_service') {
$where_relquery .= " and vtiger_service.discontinued <> 0";
}
