} } if ($iOrganizationID != '') { $where .= " AND iOrganizationID={$iOrganizationID} "; } if (trim($type) != '') { $where .= " AND eUserType='{$type}' "; } if ($orgname != '') { $where .= ' AND (vFirstName LIKE ("%' . $orgname . '%") OR vLastName LIKE ("%' . $orgname . '%"))'; } if (!isset($ENABLE_AUCTION) || $ENABLE_AUCTION == 'No') { // $where .= " AND iOrganizationID NOT IN (Select iOrganizationID from ".PRJ_DB_PREFIX."_organization_master where eOrganizationType!='Buyer2')"; } // echo $where; exit; $res = $UsrObj->getDetails_PG("CONCAT(vFirstName,' ',vLastName) as vTitle,iUserID as Id,iOrganizationID as iOrganizationID", $where); //prints($res);exit; unset($res['tot']); $html = ''; if ($orgtype == 'supplier') { $typeMsg = $smarty->get_template_vars('LBL_SUPPLIER') . " " . $smarty->get_template_vars('LBL_CONTACT_PARTY'); } elseif ($orgtype == 'buyer') { $typeMsg = $smarty->get_template_vars('LBL_BUYER') . " " . $smarty->get_template_vars('LBL_CONTACT_PARTY'); } elseif ($orgtype == 'user') { $typeMsg = $smarty->get_template_vars('LBL_ORG_USER'); } if (count($res) > 0) { $i = 0; if ($htmlTag == "option") { $html = "<option value=''>---" . $smarty->get_template_vars('LBL_SELECT') . " " . $typeMsg . "---</option>"; }