$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"; }