PHP Organization::select方法代码示例

/*if($userData['eStatus']!='')
     $statusVal=$userData['eStatus'];
else
     $statusVal='Need to Verify';
*/
$userData['eUserType'] = isset($userData['eUserType']) ? $userData['eUserType'] : '';
if ($userData['eUserType'] == '') {
    $userData['eUserType'] = 'User';
}
$userTypes = $gdbobj->getEnumSelect("" . PRJ_DB_PREFIX . "_organization_user", "eUserType", "Data[eUserType]", "eUserType", "", $userData['eUserType'], "class='drop-down' onchange='showHidePermission(this.value)' ", "Select User Type");
//$eStatus = $gdbobj->getEnumSelect("".PRJ_DB_PREFIX."_organization_user", "eStatus","Data[eStatus]", "eStatus","",$statusVal,"style='width:200px;' class='drop-down' ","Select Status");
$view = isset($view) ? $view : '';
if ($view != 'edit') {
    if ($sess_usertype != 'SM') {
        // prints($udts); exit;
        $orgdetails = $orgObj->select($curORGID);
        //prints($orgdetails);exit;
    }
}
$userData['iOrganizationID'] = isset($userData['iOrganizationID']) ? $userData['iOrganizationID'] : '';
if ($userData['iOrganizationID'] != '') {
    // $orgdtls = $orgObj->select($userData[iOrganizationID]);
    $orgdetails = $orgObj->select($userData['iOrganizationID']);
}
// prints($orgdetails); exit;
$userData['vPhone'] = isset($userData['vPhone']) ? $userData['vPhone'] : '';
$phoneData = explode("-", $userData['vPhone']);
if (count($phoneData) == 1) {
    $userData['vPhone'] = $phoneData[0];
} else {
    $userData['vPhoneCode'] = $phoneData[0];

// 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;
} else {
    if (isset($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ORGTYPE']) && $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ORGTYPE'] == 'Buyer2') {
        if (trim($iAssociationId) == '' || $iAssociationId < 1) {
            if (!isset($orgObj)) {
                include_once SITE_CLASS_APPLICATION . "organization/class.Organization.php";
                $orgObj = new Organization();
            }
            $b2orgdtls = $orgObj->select($curORGID);
            if (is_array($b2orgdtls) && count($b2orgdtls) > 0) {
                $arr[0]['iBuyer2Id'] = $curORGID;
                $arr[0]['vBuyer2'] = isset($b2orgdtls[0]['vCompanyName']) ? $b2orgdtls[0]['vCompanyName'] : '';
                $arr[0]['vB2Code'] = isset($b2orgdtls[0]['vCompCode']) ? $b2orgdtls[0]['vCompCode'] : '';
            }
        }
    }
}
if (isset($arr[0]['iBuyer2Id']) && trim($arr[0]['iBuyer2Id']) != '' && $arr[0]['iBuyer2Id'] > 0 && $arr[0]['iBuyer2Id'] != $curORGID && $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USRTYPE'] != 'SM') {
    header("Location: " . SITE_URL_DUM . "b2bprodtasoclist");
    exit;
}
$smarty->assign('mod', $mod);
$smarty->assign('arr', $arr);
$smarty->assign('msg', $msg);

if (!isset($poLineObj)) {
    include_once SITE_CLASS_APPLICATION . "user/class.PurchaseOrderLine.php";
    $poLineObj = new PurchaseOrderLine();
}
if (!isset($invAttachmentObj)) {
    include_once SITE_CLASS_APPLICATION . "user/class.InvoiceOrderAttachment.php";
    $invAttachmentObj = new InvoiceOrderAttachment();
}
if (!isset($imgObj)) {
    include_once SITE_CLASS_GEN . "class.imagecrop.php";
    $imgObj = new imagecrop();
}
$totusrs = $orgUsrObj->getDetails(" COUNT(*) as tot ", " AND iOrganizationID={$curORGID} AND eUserType='User'");
$totusrs = $totusrs[0]['tot'];
$ordt = $orgUsrObj->getDetails('*', " AND iOrganizationID={$curORGID} AND eUserType='Admin' AND eStatus='Active'");
$org = $orgObj->select($curORGID);
$smdt = $secManObj->getDetails('*', " AND iASMID=" . $org[0]['iASMID'] . " AND eStatus='Active'");
if (is_array($smdt) && is_array($ordt)) {
    $emailArr = array_merge($smdt, $ordt);
} else {
    if (is_array($smdt)) {
        $emailArr = $smdt;
    } else {
        if (is_array($ordt)) {
            $emailArr = $ordt;
        }
    }
}
// prints($emailArr); exit;
$view = $_POST['view'];
$frmbuyer = $_POST['frmbuyer'];

<?php

include S_SECTIONS . "/member/memberaccess.php";
$iOrganizationID = GetVar('id');
if ($sess_usertype == 'orgadmin' && $orgid != $iOrganizationID) {
    header("Location: " . SITE_URL_DUM . "oadashboard");
    exit;
}
if (!isset($orgprefObj)) {
    include_once SITE_CLASS_APPLICATION . "organization/class.OrganizationPreference.php";
    $orgprefObj = new OrganizationPreference();
}
if (!isset($orgPrefVrfObj)) {
    include_once SITE_CLASS_APPLICATION . "organization/class.OrganizationPreferenceToverify.php";
    $orgPrefVrfObj = new OrganizationPreferenceToverify();
}
if (!isset($orgObj)) {
    require_once SITE_CLASS_APPLICATION . "organization/class.Organization.php";
    $orgObj = new Organization();
}
$orgdtls = $orgObj->select($iOrganizationID);
$orgprefhistory = $orgprefObj->getHistory($iOrganizationID);
// prints($orgprefhistory); exit;
$smarty->assign('orgdtls', $orgdtls);
$smarty->assign('orgprefhistory', $orgprefhistory);

$fromtype = isset($_GET['fromtype']) ? $_GET['fromtype'] : '';
$type = $_GET['type'];
$iId = $_GET['iId'];
$prms = $_GET['prms'];
$acpt = $_GET['acpt'];
$grpid = $_GET['grpid'];
$prmsarr = @explode(',', $prms);
$grpdt = array();
if (trim($grpid) != '' && is_numeric($grpid) && $grpid > 0) {
    $grpdt = $orgGroupObj->select($grpid);
}
$view = isset($view) ? $view : '';
$ores = array();
if (trim($view) == 'undefined' || trim($view) == '') {
    $ores = $orgPrefObj->getDetails('*', " AND iOrganizationId=" . $iId);
    $orgdtl = $orgObj->select($iId);
    $orgtype = $orgdtl[0]['eOrganizationType'];
}
if ($orgtype == 'Buyer2') {
    include_once 'aj_getB2OrgStatus.php';
}
// prints($ores); exit;
//
$ecreate = array();
$eimport = array();
$everify = array();
$grpdt[0]['eFormCreation'] = isset($grpdt[0]['eFormCreation']) ? $grpdt[0]['eFormCreation'] : '';
if (strpos($grpdt[0]['eFormCreation'], 'po') !== false) {
    //	$ecreate['po'] = 'Yes';
    $ecreate['po'] = "checked='checked'";
}

    $where = " AND ioh.iInvoiceID IN ({$invs})";
}
// echo $where; exit;
//$enc = $_POST['enc'];
//$enc=$encInvoice;
//if($enc == 'y')
//{
$opf = $orgprefObj->getDetails('*', " AND iOrganizationID={$curORGID} ");
if ($opf[0]['eSecureExportInvoice'] == 'Yes') {
    $arr_loaded_ext = get_loaded_extensions();
    if (in_array('mcrypt', $arr_loaded_ext)) {
        $enc = 'y';
        //
        $encKey = $opf[0]['vEncryptionKey'];
        $encAlgo = $opf[0]['eCryptAlgo'];
        $orgdt = $orgObj->select($curORGID);
        $code[] = $orgdt[0]['vOrganizationCode'] . $orgdt[0]['iOrganizationID'];
        $code[] = $orgdt[0]['dCreatedDate'];
        //
        $iv_val = $encobj->setEncValues($encKey, $encAlgo, $code, '');
    }
}
//}
// $limit = " LIMIT ".($page-1)*$REC_LIMIT_FRONT.", ".$REC_LIMIT_FRONT." ";
// print $where;
// and poh.iStatusID in (".$poUserStatusIds.")
$orderBy = " ioh.iInvoiceID ";
$jtbl .= " LEFT JOIN " . PRJ_DB_PREFIX . "_status_master sm on sm.iStatusID = ioh.iStatusID";
$jtbl .= " LEFT JOIN " . PRJ_DB_PREFIX . "_organization_user ou on ou.iUserID = ioh.iBuyerID";
$jtbl .= " LEFT JOIN " . PRJ_DB_PREFIX . "_purchase_order_heading poh on poh.iPurchaseOrderID = ioh.iPurchaseOrderID";
$jtbl .= " LEFT JOIN " . PRJ_DB_PREFIX . "_invoice_otherinformation ioi on ioh.iInvoiceID=ioi.iInvoiceID ";

    include_once SITE_CLASS_APPLICATION . "user/class.InvoiceOrderAttachment.php";
    $invAttachmentObj = new InvoiceOrderAttachment();
}
if (!isset($pohObj)) {
    include_once SITE_CLASS_APPLICATION . "user/class.PurchaseOrderHeading.php";
    $pohObj = new PurchaseOrderHeading();
}
if (!isset($bnkObj)) {
    include_once SITE_CLASS_APPLICATION . "class.BankMaster.php";
    $bnkObj = new BankMaster();
}
// prints($invUserStatusIds); exit;
if (trim($invUserStatusIds) != '') {
    $uinvprmt_ary = @explode(',', $invUserStatusIds);
}
$orgdtls = $orgObj->select($curORGID);
if ($orgdtls[0]['eCreateMethodAllowed'] == 'File Import' || $sess_usertype_short != 'OU') {
    if ($sess_usertype_short == 'SM') {
        header("Location: " . SITE_URL_DUM . "smdashboard/all");
    } else {
        if (trim($iInvoiceID) != '' && is_numeric($iInvoiceID)) {
            header("Location: " . SITE_URL_DUM . "invoiceview/{$iInvoiceID}");
        } else {
            header("Location: " . SITE_URL_DUM . "invoicelist/all");
        }
    }
    exit;
}
$binvp = '';
if ($uorg_type == 'Buyer') {
    // echo $uorg_type; exit;

     $msg = $smarty->get_template_vars('MSG_ADD_SUCC');
} elseif($msg == 'raserr') {
     $msg = $smarty->get_template_vars('MSG_ADD_ERR');
} elseif($msg == 'tmm') {
     $mmsg = $smarty->get_template_vars('LBL_PO_TOTAL_MISMATCH');
} else{ $msg=''; }*/
$UserName = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_NAME'];
//$msg=$_REQUEST['msg'];
if (isset($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_MSG']) && $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_MSG'] != '') {
    $msg = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_MSG'];
    unset($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_MSG']);
}
$invad = isset($_SESSION['invadd']) ? $_SESSION['invadd'] : '';
$iInvoiceID = $_GET['id'];
$msg = '';
$orgdtls = $orgObj->select($curORGID);
if ($orgdtls[0]['eCreateMethodAllowed'] == 'File Import' || $sess_usertype_short != 'OU') {
    if ($sess_usertype_short == 'SM') {
        header("Location: " . SITE_URL_DUM . "smdashboard/all");
    } else {
        if (trim($iInvoiceID) != '' && is_numeric($iInvoiceID)) {
            header("Location: " . SITE_URL_DUM . "invoiceview/{$iInvoiceID}");
        } else {
            header("Location: " . SITE_URL_DUM . "polist/all");
        }
    }
    exit;
}
$binvp = '';
if ($uorg_type == 'Buyer') {
    // echo $uorg_type; exit;

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';
    $orgObj->setiOrganizationID($iOrganizationID);
    $orgdtls = $orgObj->select('');
    if ($pg == 'verify') {
        $Oarr = $arr = $orgPrefVrfObj->getDetails('*', " AND iOrganizationID={$iOrganizationID}");
        $OiAdditionalInfoID = $iAdditionalInfoID = $arr[0]['iAdditionalInfoID'];
        //          $where = 'AND iVerifiedID = "'.$iAdditionalInfoID.'"';
        //          $arr = $orgPrefVrfObj->getDetails('*',$where);
    } else {
        $Oarr = $arr = $orgprefObj->getDetails('*', " AND iOrganizationID={$iOrganizationID}");
        $OiAdditionalInfoID = $iAdditionalInfoID = $arr[0]['iAdditionalInfoID'];
        //          $where = 'AND iAdditionalInfoID = "'.$iAdditionalInfoID.'"';
        //$arr = $orgprefObj->getDetails('*',$where);
    }
    //prints($arr);exit;
}
//Get State Array
$state = $cntstObj->getgeneralArr(PRJ_DB_PREFIX . "_state_master", " AND eStatus='Active'", "vStateCode", "vState", "vCountryCode", "vStateCode,vState,vCountryCode");

$newarr = array();
if ($iAsociationID != '') {
    $view = 'edit';
    $orgAssocObj->setiAsociationID($iAsociationID);
    $fields = " *, (Select vCompanyName from b2b_organization_master where iOrganizationID=iBuyerOrganizationID) as vBuyerOrg,\r\n                         (Select vCompanyName from b2b_organization_master where iOrganizationID=iSupplierAssocationID) as vSupplierOrg ";
    $assorgdt = $orgAssocObj->getDetails($fields, " AND iAsociationID={$iAsociationID}", '', '', '');
    if ($sess_usertype_short == 'OA' && $assorgdt[0]['iBuyerOrganizationID'] != $curORGID) {
        header("Location: " . SITE_URL_DUM . "associationlist");
        exit;
    }
    // prints($assorgdt);exit;
    if ($assorgdt[0]['eStatus'] == 'Need to Verify' || $assorgdt[0]['eStatus'] == 'Modified') {
        header('Location:' . SITE_URL_DUM . 'associationview/' . $iAsociationID);
        exit;
    }
    $orgdata = $orgObj->select($assorgdt[0]['iBuyerOrganizationID']);
    $orgdata[0]['iBuyerOrganizationID'] = $assorgdt[0]['iBuyerOrganizationID'];
    $where .= " AND  eOrganizationType!='Buyer' AND iOrganizationID!='" . $assorgdt[0]['iBuyerOrganizationID'] . "'";
    $sellerorgs = $orgAssocObj->getDetails('iSupplierAssocationID,vSupplierCode', " AND iBuyerOrganizationID='" . $assorgdt[0]['iBuyerOrganizationID'] . "' AND vAssociationCode='" . $assorgdt[0]['vAssociationCode'] . "' AND ((eStatus='Active' || eStatus='Inactive') AND eNeedToVerify!='Yes')");
    // exit;
    foreach ($sellerorgs as $k => $v) {
        if ($v['iSupplierAssocationID'] != 0) {
            $newarr[$v['iSupplierAssocationID']]['vSupplierCode'] = $v['vSupplierCode'];
        }
        $starr[] = $v['iSupplierAssocationID'];
    }
    if (is_array($sellerorgs) && count($sellerorgs) > 0) {
        $iSellerOrgs = @implode(',', $starr);
    } else {
        if (trim($sellerorgs[0]['iSupplierAssocationID']) != '') {
            $iSellerOrgs = $sellerorgs[0]['iSupplierAssocationID'];

     $Data_pref[$pref_ary[$l]] = $Data[$pref_ary[$l]];
     unset($Data[$pref_ary[$l]]);
 }
 // prints($Data); exit;
 $Data['dCreatedDate'] = date('Y-m-d H:i:s');
 $Data['vFromIP'] = $_SERVER['REMOTE_ADDR'];
 $stsdtls = $statusmasterObj->getDetails('iStatusID', " AND eFor='Invoice' AND vStatus_en='Create' ");
 if ($reqVerification == 'Yes') {
     $Data['iStatusID'] = 0;
 } else {
     $Data['iStatusID'] = $stsdtls[0]['iStatusID'];
 }
 $Data['iSupplierOrganizationID'] = $curORGID;
 $Data['iSupplierID'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
 $Data['vSupplierContactParty'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_NAME'];
 $supplierOrgDtls = $orgObj->select($curORGID);
 $Data['vSupplierName'] = $supplierOrgDtls[0]['vCompanyName'];
 $Data['vSupplierAddLine1'] = $supplierOrgDtls[0]['vAddressLine1'];
 $Data['vSupplierAddLine2'] = $supplierOrgDtls[0]['vAddressLine2'];
 $Data['vSupplierZipCode'] = $supplierOrgDtls[0]['vZipcode'];
 $Data['vSupplierState'] = $supplierOrgDtls[0]['vState'];
 $Data['vSupplierCountry'] = $supplierOrgDtls[0]['vCountry'];
 $Data['vInvoiceSupplierCode'] = $supplierOrgDtls[0]['vOrganizationCode'];
 $Data['vSupplierContactTelephone'] = $supplierOrgDtls[0]['vPhone'];
 $vItmCode = $pohObj->getUniqueCode();
 $Data['vInvoiceCode'] = $vItmCode;
 $vInvoiceNumber = "INV" . $vItmCode . "-" . trim($Data['vInvoiceSupplierCode']);
 $Data['vInvoiceNumber'] = $vInvoiceNumber;
 if (trim($Data['eSaved']) == '') {
     $Data['eSaved'] = 'No';
 }

 // prints($where); exit;
 $res = $assObj->updateData($dlts, $where);
 //$assvrfObj->setAllVar($dlts);
 //$res = $assvrfObj->updateData($dlts, $where);
 $where = ' AND iAsociationID = ' . $v['iAsociationID'] . '';
 $dts = $v;
 $dts['iModifiedByID'] = $sess_id;
 $dts['eModifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
 $dts['dModifiedDate'] = date('Y-m-d H:i:s');
 $dts['eStatus'] = 'Delete';
 $assvrfObj->setAllVar($dts);
 $rs = $assvrfObj->insert();
 $orderby = ' iVerifiedID Desc';
 $vrfid = $assvrfObj->getDetails('iVerifiedID', $where, $orderby);
 // ---------------------  ORGANIZATION DATA FETCHED ------------------------------------------//
 $orgdata = $orgObj->select($v['iBuyerOrganizationID']);
 $ORGNAME = $orgdata[0]['vCompanyName'];
 $CODE = $orgdata[0]['vOrganizationCode'];
 $where = 'AND iSMID != ' . $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'] . ' AND eStatus = "Active"';
 $smdtls = $secManObj->getDetails('*', $where);
 // ---------------------
 $where = 'AND vType="Association Deleted" AND eSection = "Member"';
 $db_email = $emailObj->getDetails('*', $where);
 $link = SITE_URL_DUM . "associationview/" . $v['iAsociationID'];
 $body = array("#ORGNAME#", "#ACODE#", "#LINK#", "#DELETE_BY#");
 $post = array($ORGNAME, $CODE, $link, $sess_user_name . "({$sess_usertype_short})");
 $rplarr = array("Hello #SMNAME#,", "background-color: rgb(239, 239, 239);", "Regards,", "#MAIL_FOOTER#", "#SITE_URL#");
 $tbody_en = str_replace($rplarr, " ", $db_email[0]['tBody_en']);
 $emailContent_en = trim(str_replace($body, $post, $tbody_en));
 $tbody_fr = str_replace($rplarr, " ", $db_email[0]['tBody_fr']);
 $emailContent_fr = trim(str_replace($body, $post, $tbody_fr));

    $orgGrpObj = new OrganizationGroup();
}
// set folder struct for users
$usersec = "";
$orderStatus = $invoiceStatus = $ures = array();
$poUserStatusIds = $poUserStatus = $invUserStatusIds = $invUserStatus = $poUserAcptIds = $invUserAcptIds = $poUserAcpt = $invUserAcpt = "";
switch ($sess_usertype) {
    case 'securitymanager':
        $usersec = 'securitymanager';
        $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'] = 'SM';
        break;
    case 'orguser':
        $usersec = 'user';
        $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'] = 'OU';
        $usrdtls = $orgUsrObj->select($sess_id);
        $odt = $orgObj->select($curORGID);
        $opf = $orgprefObj->getDetails('*', " AND iOrganizationID={$curORGID} ");
        //					 if($odt[0]['eReqVerification'] == 'Yes') {
        if ($usrdtls[0]['ePermissionType'] == 'Individual') {
            $uWhere = " AND iUserID='" . $sess_id . "' AND eStatus!='Need to Verify' ";
            $ures = $orgUserPerObj->getDetails('*', $uWhere);
        } else {
            if ($usrdtls[0]['ePermissionType'] == 'Group') {
                $gwhere .= " AND iGroupID=" . $usrdtls[0]['iGroupID'] . " AND eStatus!='Need to Verify' ";
                $ures = $orgGrpObj->getDetails('*', $gwhere);
                // prints($ures); exit;
            }
        }
        //
        if (!isset($userStatusObj)) {
            require_once SITE_CLASS_APPLICATION . "class.StatusMaster.php";

$type = $_GET['type'];
$iId = $_GET['iId'];
$orgUsrObj->setiUserID($iId);
$userdtls = $orgUsrObj->select($iId);
// prints($userdtls); exit;
if (!(is_array($userdtls) && count($userdtls) > 0)) {
    echo $smarty->get_template_vars('MSG_SELECT_ORG_USER') . " " . $smarty->get_template_vars('LBL_TO_PROCEED') . " !";
    exit;
}
if ($userdtls[0]['eUserType'] == 'Admin') {
    echo $smarty->get_template_vars('MSG_ADMIN_RIGHTS_NOT_REQ');
    exit;
}
//$where = " AND iGroupID = '".$iId."'";
$ores = $orgPrefObj->getDetails('*', " AND iOrganizationId=" . $userdtls[0]['iOrganizationID']);
$orgdtl = $orgObj->select($userdtls[0]['iOrganizationID']);
$orgtype = $orgdtl[0]['eOrganizationType'];
if ($orgtype == 'Buyer2') {
    include_once 'aj_getB2OrgUserStatus.php';
}
$orderStatus = $invoiceStatus = array();
$where = " AND iUserID='" . $iId . "'";
$ures = $orgUserPerObj->getDetails('*', $where);
// prints($ures);exit;
$poisusts = $orgStaObj->getDetails('vStatus_' . LANG . ' as title,vStatusMsg_' . LANG . ',iStatusID as Id,eFor,eType,vStatusMsg_en as msg,vStatus_en as status', " AND vStatus_en='Issue' AND eFor='PO' ", '', '');
// $orderStatus .= ",".$poisusts[0]['iStatusID'];
//$ores[0]['vOrderStatusLevel'] .= ",".$poisusts[0]['iStatusID'];
$poacptsts = $orgStaObj->getDetails('vStatus_' . LANG . ' as title,vStatusMsg_' . LANG . ',iStatusID as Id,eFor,eType,vStatusMsg_en as msg,vStatus_en as status', " AND vStatus_en='Accepted' AND eFor='PO' ", '', '');
// $ordacptStatus .= ",".$poacptsts[0]['iStatusID'];
//$ores[0]['vOrderAcceptanceLevel'] .= ",".$poacptsts[0]['iStatusID'];
$invisusts = $orgStaObj->getDetails('vStatus_' . LANG . ' as title,vStatusMsg_' . LANG . ',iStatusID as Id,eFor,eType,vStatusMsg_en as msg,vStatus_en as status', " AND vStatus_en='Issue' AND eFor='Invoice' ", '', '');

     unset($Data[$pref_ary[$l]]);
 }
 // prints($Data); exit;
 $Data['dCreateDate'] = date('Y-m-d H:i:s');
 $Data['vFromIP'] = $_SERVER['REMOTE_ADDR'];
 $stsdtls = $statusmasterObj->getDetails('iStatusID', " AND eFor='PO' AND vStatus_en='Create' ");
 if ($reqVerification == 'Yes') {
     $Data['iStatusID'] = 0;
 } else {
     $Data['iStatusID'] = $stsdtls[0]['iStatusID'];
 }
 //$Data['iStatusID'] = $stsdtls[0]['iStatusID'];
 $Data['iBuyerOrganizationID'] = $curORGID;
 $Data['iBuyerID'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
 $Data['vBuyerContactName'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_NAME'];
 $buyerOrgDtls = $orgObj->select($curORGID);
 $Data['vBuyerCode'] = $buyerOrgDtls[0]['vOrganizationCode'];
 $Data['vBuyerCompanyName'] = $buyerOrgDtls[0]['vCompanyName'];
 $Data['vBuyerContactTelephone'] = $buyerOrgDtls[0]['vPhone'];
 $Data['vBuyerContactEmail'] = $buyerOrgDtls[0]['vEmail'];
 $vItmCode = $pohObj->getUniqueCode();
 $Data['vPOCode'] = $vItmCode;
 $Data['vPONumber'] = "PO" . $Data['vPOCode'] . "-" . trim($Data['vBuyerCode']);
 if (trim($Data['eSaved']) == '') {
     $Data['eSaved'] = 'No';
 }
 //prints($Data); exit;
 $pohObj->setAllVar($Data);
 $dup = $pohObj->chkDuplicate('vPONumber', $Data);
 if ($dup > 0) {
     $ids = $pohObj->updateData($Data, " iPurchaseOrderID = {$dup} ");