PHP Organization::getDetails方法代码示例

    /*  if($ISSEARCHED != 'Yes'){
    				$where .= " AND iOrganizationID IN ($iSellerOrgs) ";
    			}else{
    		*/
    //$where .= " AND iOrganizationID NOT IN ($iSellerOrgs) ";
    /*if($islorgs != '')
    			$where .= " AND iOrganizationID NOT IN ($iSellerOrgs".','."$islorgs) ";
    		else
    			$where .= " AND iOrganizationID NOT IN ($iSellerOrgs) ";
    		 */
    //   }
}
// echo $where;exit;
$orderBy = " iOrganizationID Asc";
//echo $where; exit;
$res = $orgObj->getDetails('vOrganizationCode,vCompanyName,vCompanyRegNo,iOrganizationID', $where, $orderBy);
// print_r($res);exit;
if (count($res) > 0 && is_array($res)) {
    ?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
	<td class="blue-hadd-bg">
	<table width="100%" border="0" cellspacing="0" cellpadding="0">
		<tr>
		 <td width="30px" height="26" >&nbsp;
			  <input type="checkbox" class="radib-btn" name="uid_chkall" id="uid_chkall" style="vertical-align:middle;" />
		 </td>
		 <td width="70px" >Reg. No. </td>
		 <td width="100px" >Organization Code</td>
		 <td width="100px" >Organization Name</td>
		 <td width="70px" align="center">Code </td>

                if (!isset($sproductObj)) {
                    include_once SITE_CLASS_APPLICATION . 'productorganization/class.SProductOrganization.php';
                    $sproductObj = new SProductOrganization();
                }
                $product_dtls = $sproductObj->select($rfq2pb2_dtls[0]['iProductId']);
            }
        }
    }
    $buyer2ids = multi21Array($rfq2pb2_dtls, 'iBuyer2Id');
    $buyer2ids = array_unique($buyer2ids);
    $buyer2ids = array_filter($buyer2ids);
    $b2ids = '';
    if (is_array($buyer2ids) && count($buyer2ids) > 0) {
        $b2ids = @implode(',', $buyer2ids);
    }
    $buyer2_dtls = $orgObj->getDetails('*', " AND iOrganizationID IN ({$b2ids}) ");
    // pr($buyer2_dtls); exit;
}
// pr($product_dtls); exit;
// pr($dtls); exit;
$vreq = 'n';
$permitted = 'n';
$orgprf = $orgprefObj->getDetails('*', " AND iOrganizationID=" . $dtls[0]['iOrganizationID']);
if (($dtls[0]['vStatus_en'] == 'Create' && $orgprf[0]['eRFQ2VerifyReq'] == 'Yes' || $dtls[0]['eDelete'] == 'Yes') && $sess_usertype_short == 'OU') {
    $vreq = 'y';
    if ($dtls[0]['iModifiedById'] != $sess_id && $dtls[0]['iOrganizationID'] == $curORGID) {
        $rfq2vp = $orgUserPermObj->getUserRfq2Permits($sess_id);
        if (isset($rfq2vp['Verify']) && $rfq2vp['Verify'] == 'y') {
            $permitted = 'y';
        }
    }

}
// prints($uarr); exit;
if (is_array($sar) && is_array($uar)) {
    $emlar = array_merge($sar, $uar);
} else {
    if (is_array($sar)) {
        $emlar = $sar;
    } else {
        if (is_array($uar)) {
            $emlar = $uar;
        }
    }
}
// prints($Data);exit;
$where = 'AND iOrganizationID = ' . $iOrganizationID . '';
$ordata = $orgObj->getDetails('*', $where);
$sname = $arr[0]['vFirstName'] . ' ' . $arr[0]['vLastName'];
$cname = $ordata[0]['vCompanyName'];
$regno = $ordata[0]['vCompanyRegNo'];
$code = $ordata[0]['vOrganizationCode'];
if ($view == 'reject') {
    //echo $view; exit;
    $iOrganizationID = $_POST['iOrgId'];
    $dt['eNeedToVerify'] = $data['eNeedToVerify'] = 'No';
    $dt['tReasonToReject'] = $_POST['tReasonToReject'];
    $dt['iRejectedById'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
    $dt['eRejectedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
    $dt['dRejectedDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
    $dt['eStatus'] = $data['eStatus'] = "Active";
    $orgpfdtls = $orgprefObj->getDetails('*', " AND iOrganizationID={$iOrganizationID} ");
    if ($orgpfdtls[0]['eStatus'] == 'Need to Verify') {

    $where .= " AND (eOrganizationType='{$orgtype}' OR eOrganizationType='Both')";
}
if (trim($assoc) != '' && trim($assoc) != 'all') {
    $where .= " AND iOrganizationID IN (Select iSupplierAssocationID from " . PRJ_DB_PREFIX . "_organization_association where vAssociationCode='{$assoc}' AND eStatus='Active' AND eNeedToVerify='No') ";
}
$where .= " AND eStatus='Active' AND eNeedToVerify!='Yes' " . $orgWhere;
// echo $where;exit;
//print $where;
if ($extc = 'invb') {
    $where .= " AND iOrganizationID IN (Select iBuyerOrganizationID from " . PRJ_DB_PREFIX . "_organization_association where iSupplierAssocationID='" . $_GET['orgid'] . "') ";
} else {
    if ($extc = 'invs') {
        $where .= " AND iOrganizationID IN (Select iSupplierAssocationID from " . PRJ_DB_PREFIX . "_organization_association where iBuyerOrganizationID='" . $_GET['orgid'] . "') ";
    }
}
$res = $orgObj->getDetails('vOrganizationCode,vCompanyName as vTitle,vCompanyRegNo,iOrganizationID as Id', $where, "vCompanyName");
// prints($res);exit;
$html = "";
if ($orgtype == 'supplier') {
    $compName = $smarty->get_template_vars('LBL_SELECT') . " " . $smarty->get_template_vars('LBL_SUPPLIER') . " " . $smarty->get_template_vars('LBL_COMPANY');
} elseif ($orgtype == 'buyer' && $isAssociation == '') {
    $compName = $smarty->get_template_vars('LBL_SELECT') . " " . $smarty->get_template_vars('LBL_BUYER') . " " . $smarty->get_template_vars('LBL_COMPANY');
} elseif ($orgtype == 'buyer' && $isAssociation == 'yes') {
    $compName = $smarty->get_template_vars('MSG_SELECT_BUYER_ORGANIZATION');
} elseif ($orgtype == '' && $isAssociation == 'no') {
    $compName = $smarty->get_template_vars('MSG_SELECT_ORGANIZATION');
}
if (count($res) > 0 && is_array($res)) {
    $i = 0;
    if ($htmlTag == "option") {
        $html = "<option value=''>---" . $compName . "---</option>";

    $OuserData = $userData = $userData[0];
    $uprmts = $orgUserPerObj->getDetails('*', " AND iUserID={$iUserID} ");
    $vuprmts = $orgUserPermVerifyObj->getDetails('*', " AND iUserID={$iUserID} ", ' iVerifiedID DESC ', '', ' LIMIT 0,1 ');
}
$state = $cntstObj->getgeneralArr(PRJ_DB_PREFIX . "_state_master", " AND eStatus='Active'", "vStateCode", "vState", "vCountryCode", "vStateCode,vState,vCountryCode");
$stateArr = $state[0];
//$stateArr	=	array($stateArr);
//echo $stateArr[0][2];
//prints($stateArr);exit;
$groupArr = $cntstObj->getgeneralArr(PRJ_DB_PREFIX . "_organization_group", " AND eStatus='Active' ", "iGroupID", "vGroupName", "iOrganizationID", "iGroupID,vGroupName,iOrganizationID");
$groupArr = $groupArr[0];
$db_country = $countryObj->getCountryDetail("iCountryId,vCountry,vCountryCode", "AND eStatus = 'Active'");
//prints($db_country);exit;
$db_state = $stateObj->getStateDetail("iStateId, vStateCode, vState", "AND eStatus = 'Active' AND vCountryCode = '" . $userData['vCountry'] . "'", "vState");
$where = " AND iOrganizationID=" . $OuserData['iOrganizationID'] . "";
$organization = $orgObj->getDetails('*', $where);
// prints($organization); exit;
$msg = $smarty->get_template_vars('MSG_NEED_VERIFY');
//prints($userData);exit;
if ($userData['eUserType'] != '') {
    $userTypeVal = $userData['eUserType'];
} else {
    $userTypeVal = 'User';
}
$userTypes = $gdbobj->getEnumSelect("" . PRJ_DB_PREFIX . "_organization_user", "eUserType", "Data[eUserType]", "eUserType", "", $userTypeVal, "style='width:200px;' class='drop-down' ", "Select User Type");
//$eStatus = $gdbobj->getEnumSelect("".PRJ_DB_PREFIX."_organization_user", "eStatus","Data[eStatus]", "eStatus","",$statusVal,"style='width:200px;' class='drop-down' ","Select Status");
$where = 'AND iUserID = ' . $iUserID . '';
$udts = $userToVerifyObj->getDetails('*', $where, ' iVerifiedID desc ', '', ' LIMIT 0,1 ');
$udts = $udts[0];
//prints($udts);//exit;
if ($udts['eStatus'] == 'Modified' || $udts['eNeedToVerify'] == 'Yes' || $udts['eStatus'] == 'Delete') {

if (strpos($ures[0]['eImportCreation'], 'po') !== false) {
    $eimport['po'] = 'Yes';
}
if (strpos($ures[0]['eImportCreation'], 'inv') !== false) {
    $eimport['inv'] = 'Yes';
}
$ures[0]['eVerify'] = isset($ures[0]['eVerify']) ? $ures[0]['eVerify'] : '';
if (strpos($ures[0]['eVerify'], 'pi:ia') !== false) {
    $everify['po'] = 'Yes';
}
if (strpos($ures[0]['eVerify'], 'ii:pa') !== false) {
    $everify['inv'] = 'Yes';
}
// prints($poUserAcpt); exit;
$where = " AND iOrganizationID='" . $userdata[0]['iOrganizationID'] . "'";
$orgdata = $orgObj->getDetails('vCompanyName,eOrganizationType', $where);
$orgname = $orgdata[0]['vCompanyName'];
$where = "";
$status = $orgStaObj->getDetails('vStatus_' . LANG . ' as title,vStatusMsg_' . LANG . ',iStatusID as Id,eFor,eType,vStatus_en as status', $where, 'iDisplayOrder', '');
// prints($ures); exit;
$ures[0]['eStatus'] = isset($ures[0]['eStatus']) ? $ures[0]['eStatus'] : '';
if ($ures[0]['eStatus'] == 'Need to Verify') {
    switch ($sess_usertype) {
        case 'securitymanager':
            if ($ures[0]['eCreatedBy'] == 'SM') {
                if ($ures[0]['iCreatedBy'] != $sess_id) {
                    $verify = 'yes';
                } else {
                    $verify = 'no';
                }
            } else {

    }
} else {
    $mod = 'add';
    $arr = $post_data = array();
    if (isset($_SESSION[PRJ_CONST_PREFIX . '_postdata'])) {
        $post_data = unserialize($_SESSION[PRJ_CONST_PREFIX . '_postdata']);
        unset($_SESSION[PRJ_CONST_PREFIX . '_postdata']);
    }
    if (isset($post_data['Data']) && count($post_data['Data']) > 0) {
        $arr[0] = $post_data['Data'];
        if (isset($arr[0]['iBuyer2Id']) && $arr[0]['iBuyer2Id'] > 0) {
            if (!isset($orgObj)) {
                include_once SITE_CLASS_APPLICATION . "organization/class.Organization.php";
                $orgObj = new Organization();
            }
            $buyer2 = $orgObj->getDetails('vCompanyName,vCompCode', " AND iOrganizationID='" . $arr[0]['iBuyer2Id'] . "'");
            $arr[0]['vBuyer2'] = $buyer2[0]['vCompanyName'];
            $arr[0]['vB2Code'] = $buyer2[0]['vCompCode'];
        }
        $arr[0]['iProductId'] = 0;
    }
    // pr($arr); exit;
}
// For OAs
if (isset($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ORGTYPE']) && $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ORGTYPE'] != 'Buyer2' && $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USRTYPE'] != 'SM') {
    if ($iAssociationId > 0) {
        header("Location: " . SITE_URL_DUM . "b2bprodtasocview/{$iAssociationId}");
    } else {
        header("Location: " . SITE_URL_DUM . "b2bprodtasoclist");
    }
    exit;

if (!isset($orgObj)) {
    include_once SITE_CLASS_APPLICATION . "organization/class.Organization.php";
    $orgObj = new Organization();
}
if (trim($snm) != '' && trim($scd) == '') {
    $whr .= " AND vCompanyName LIKE '%{$snm}%' ";
} else {
    if (trim($scd) != '' && trim($snm) == '') {
        $whr .= " AND vCompCode LIKE '%{$scd}%' ";
    } else {
        if (trim($scd) != '' && trim($snm) != '') {
            $whr .= " AND (vCompanyName LIKE '%{$snm}%' OR vCompCode LIKE '%{$scd}%') ";
        }
    }
}
$b2orgs = $orgObj->getDetails("*", " AND eOrganizationType='Buyer2' AND eStatus='Active' {$whr} ", " vCompanyName ASC ");
// prints($b2orgs); exit;
if (is_array($b2orgs) && count($b2orgs) > 0) {
    $ln = count($b2orgs);
    $html .= "<select id='{$fid}' name='{$fnm}' class='{$cls}' onchange='return {$oc};' style='{$styl}' title='" . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_BUYER2') . "'>";
    for ($l = 0; $l < $ln; $l++) {
        $html .= "<option value='" . $b2orgs[$l]['iOrganizationID'] . "'>" . $b2orgs[$l]['vCompanyName'] . " (" . $b2orgs[$l]['vCompCode'] . ")" . "</option>";
    }
    $html .= "</select>";
} else {
    $html .= "<select id='{$fid}' name='{$fnm}' class='{$cls}' onchange='return {$oc};' style='{$styl}' title='" . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_BUYER2') . "'>";
    $html .= "<option value=''>---" . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_BUYER2') . "---</option>";
    $html .= "</select>";
}
echo $html;
exit;

        $whr .= " AND vCompCode LIKE '%{$scd}%' ";
    } else {
        if (trim($scd) != '' && trim($snm) != '') {
            $whr .= " AND (vCompanyName LIKE '%{$snm}%' OR vCompCode LIKE '%{$scd}%') ";
        }
    }
}
if (trim($iBuyer2Id) != '' && $iBuyer2Id > 0 && trim($iProductId) != '' && $iProductId > 0) {
    $whr .= " AND iOrganizationID NOT IN (Select iBuyerId from " . PRJ_DB_PREFIX . "_buyer2_buyer_bproduct_association where iBuyer2Id={$iBuyer2Id} AND iProductId={$iProductId} AND NOT (eStatus='Delete' AND eNeedToVerify='No'))";
}
if (trim($sid) != '' && $sid > 0) {
    $whr .= " OR iOrganizationID={$sid} ";
}
$whr .= " AND (eOrganizationType='Buyer' OR eOrganizationType='Both') AND iOrganizationID IN (Select iBuyerId from " . PRJ_DB_PREFIX . "_buyer2_buyer_association where iBuyer2Id={$iBuyer2Id} AND NOT (eStatus='Delete' AND eNeedToVerify='No') AND eStatus!='Need to Verify') ";
// echo $whr; exit;
$borg = $orgObj->getDetails("*", " AND eStatus='Active' AND eNeedToVerify!='Yes' {$whr} ", " vCompanyName ASC ");
// prints($borg); exit;
if (is_array($borg) && count($borg) > 0) {
    $ln = count($borg);
    $html .= "<select id='{$fid}' name='{$fnm}' class='{$cls}' {$ea} style='{$styl}' title='" . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_BUYER') . "'>";
    for ($l = 0; $l < $ln; $l++) {
        $sel = "";
        if ($sid > 0 && $borg[$l]['iOrganizationID'] == $sid) {
            $sel = "selected='selected'";
        }
        $html .= "<option value='" . $borg[$l]['iOrganizationID'] . "' {$sel} >" . $borg[$l]['vCompanyName'] . " (" . $borg[$l]['vCompCode'] . ")" . "</option>";
    }
    $html .= "</select>";
} else {
    $html .= "<select id='{$fid}' name='{$fnm}' class='{$cls}' {$ea} style='{$styl}' title='" . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_BUYER') . "'>";
    $html .= "<option value=''>---" . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_BUYER') . "---</option>";

if (!isset($countryObj)) {
    include_once SITE_CLASS_APPLICATION . "class.Country.php";
    $countryObj = new Country();
}
if (!isset($stateObj)) {
    include_once SITE_CLASS_APPLICATION . "class.State.php";
    $stateObj = new State();
}
if (!isset($cntstObj)) {
    include_once SITE_CLASS_GEN . "class.countrystate.php";
    $cntstObj = new CountryState();
}
if ($iOrganizationID != '') {
    $view = 'edit';
    $where = 'AND iOrganizationID = ' . $iOrganizationID . '';
    $Oarr = $arr = $orgObj->getDetails('*', $where);
    $Oprefarr = $prefarr = $orgprefObj->getDetails('iAdditionalInfoID', $where);
    $OiAdditionalInfoID = $iAdditionalInfoID = $prefarr[0]['iAdditionalInfoID'];
    //   prints($arr);exit;
}
//Get State Array
$state = $cntstObj->getgeneralArr(PRJ_DB_PREFIX . "_state_master", " AND eStatus='Active'", "vStateCode", "vState", "vCountryCode", "vStateCode,vState,vCountryCode");
$stateArr = $state[0];
//prints($stateArr);exit;
$db_country = $countryObj->getCountryDetail("iCountryId,vCountry,vCountryCode", "AND eStatus = 'Active'");
//prints($db_country);exit;
$db_state = $stateObj->getStateDetail("iStateId, vStateCode, vState", "AND eStatus = 'Active' AND vCountryCode = '" . $arr[0]['vCountry'] . "'", "vState");
//prints($db_state);exit;
// pr($arr); exit;
$verify = '';
$smarty->assign('stateArr', $stateArr);

    $emailObj = new EmailTemplate();
}
if (!isset($sendMail)) {
    include_once SITE_CLASS_GEN . "class.sendmail.php";
    $sendMail = new SendPHPMail();
}
if (!isset($statusmasterObj)) {
    include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php";
    $statusmasterObj = new StatusMaster();
}
$Data = $_POST['Data'];
$iUserId = $Data['iUserID'];
$iPermissionID = isset($_POST['iPermissionID']) ? $_POST['iPermissionID'] : '';
$view = $_POST['view'];
$usrdt = $orgUsrObj->getDetails('*', " AND iUserID={$iUserId}");
$orgdt = $orgObj->getDetails('*', " AND iOrganizationID=" . $usrdt[0]['iOrganizationID'] . "");
// prints($orgdt);exit;
// pr($_POST); exit;
if ($iUserId != '') {
    $uprmt = $orgUserPermObj->getDetails('*', " AND iUserID={$iUserId}");
    if (is_array($uprmt) && count($uprmt) > 0) {
        if (($uprmt[0]['eStatus'] == 'Active' || $uprmt[0]['eStatus'] == 'Inactive') && $uprmt[0]['eNeedToVerify'] != 'Yes') {
            // prints($orgdt); exit;
        } else {
            if (($view == 'edit' || $view == 'add' || $view == '') && count($uprmt) > 0 && $_SESSION['from'] != 'usr') {
                header('Location:' . SITE_URL_DUM . 'organizationuserlist');
                exit;
            }
        }
    }
}

    $orgprefObj = new OrganizationPreference();
}
if (!isset($orgPrefVrfObj)) {
    include_once SITE_CLASS_APPLICATION . "organization/class.OrganizationPreferenceToverify.php";
    $orgPrefVrfObj = new OrganizationPreferenceToverify();
}
$activationcode = GetVar('msg');
if (trim($activationcode) == '') {
    header("Location: " . SITE_URL_DUM . "home");
    exit;
}
//$id = $orgObj->getid($activationcode);
$where = " vActivationCode='{$activationcode}' ";
$data['eStatus'] = 'Active';
$data['vActivationCode'] = '';
$dtls = $orgObj->getDetails('*', ' AND ' . $where);
if (is_array($dtls) && count($dtls) > 0 && isset($dtls[0]['iOrganizationID']) && $dtls[0]['iOrganizationID'] > 0) {
    $rs = $orgObj->updateData($data, $where);
    $r = $orgUsrObj->updateData($data, $where);
    // unset($data['vActivationCode']);
    $s = $orgvrfObj->updateData($data, $where);
    $s = $userToVerifyObj->updateData($data, $where);
    unset($data['vActivationCode']);
    $where = " iOrganizationID = " . $dtls[0]['iOrganizationID'] . "";
    $s = $orgprefObj->updateData($data, $where);
    $opdtls = $orgprefObj->getDetails('*', ' AND ' . $where);
    if (isset($opdtls[0]['iAdditionalInfoID']) && $opdtls[0]['iAdditionalInfoID'] > 0) {
        $where = " iAdditionalInfoID = " . $opdtls[0]['iAdditionalInfoID'] . "";
        $s = $orgPrefVrfObj->updateData($data, $where);
    }
} else {

}
$sname = $arr[0]['vFirstName'] . ' ' . $arr[0]['vLastName'];
$cname = $Data['vCompanyName'];
$regno = $Data['vCompanyRegNo'];
$code = isset($Data['vOrganizationCode']) ? $Data['vOrganizationCode'] : '';
// echo $view; exit;
if ($view == 'reject') {
    //echo $view; exit;
    $iOrganizationID = $_POST['iOrgId'];
    $dt['eNeedToVerify'] = $data['eNeedToVerify'] = 'No';
    $dt['tReasonToReject'] = $_POST['tReasonToReject'];
    $dt['iRejectedById'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
    $dt['eRejectedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
    $dt['dRejectedDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
    $dt['eStatus'] = $data['eStatus'] = "Active";
    $orgdtls = $orgObj->getDetails('*', " AND iOrganizationID={$iOrganizationID} ");
    $orgvrfdt = $orgvrfObj->getDetails('*', " AND iOrganizationID={$iOrganizationID} ", ' iVerifiedID DESC ', '', ' LIMIT 0,1 ');
    if ($orgdtls[0]['eStatus'] == 'Need to Verify') {
        $dt['eStatus'] = $data['eStatus'] = "Inactive";
    } else {
        if ($orgvrfdt[0]['eStatus'] == 'Inactive' && $orgvrfdt[0]['eNeedToVerify'] == 'Yes') {
            $dt['eNeedToVerify'] = $data['eNeedToVerify'] = "No";
            $dt['eStatus'] = $data['eStatus'] = "Active";
        } else {
            if ($orgvrfdt[0]['eStatus'] == 'Active' && $orgvrfdt[0]['eNeedToVerify'] == 'Yes') {
                $dt['eNeedToVerify'] = $data['eNeedToVerify'] = "No";
                $dt['eStatus'] = $data['eStatus'] = "Inactive";
            } else {
                if ($orgdtls[0]['eStatus'] == 'Modified') {
                    $dt['eStatus'] = $data['eStatus'] = "Active";
                    $data['iModifiedByID'] = "";

}
$view = isset($view) ? $view : '';
if ($iUserID != '') {
    $view = 'edit';
    $where = " AND iUserID='" . $iUserID . "'";
    $userdata = $orgUserObj->getDetails('*', $where);
    $ures = $orgUserPerObj->getDetails('*', $where);
    $userStatus = @explode(";", $ures[0]['tPermission']);
    $invUserStatus = $userStatus[0];
    $invUserStatus = str_replace("inv:", "", $invUserStatus);
    $poUserStatus = isset($userStatus[1]) ? $userStatus[1] : '';
    $poUserStatus = str_replace("po:", "", $poUserStatus);
    $invUserStatus = @explode(',', $invUserStatus);
    $poUserStatus = @explode(',', $poUserStatus);
    $where = " AND iOrganizationID='" . $userdata[0]['iOrganizationID'] . "'";
    $orgdata = $orgObj->getDetails('*', $where);
    // prints($orgdata); exit;
    $orgname = $orgdata[0]['vCompanyName'];
    $where = "";
    $status = $orgStaObj->getDetails('vStatus_' . LANG . ' as title,vStatusMsg_' . LANG . ',iStatusID as Id,eFor', $where, 'iDisplayOrder', '');
}
$ures[0]['eStatus'] = isset($ures[0]['eStatus']) ? $ures[0]['eStatus'] : '';
if ($ures[0]['eStatus'] == 'Need to Verify') {
    switch ($sess_usertype) {
        case 'securitymanager':
            if ($ures[0]['eCreatedBy'] == 'SM') {
                if ($ures[0]['iCreatedBy'] != $sess_id) {
                    $verify = 'yes';
                }
            } else {
                $verify = 'no';