/*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} ");
if (trim($grpid) != '' && is_numeric($grpid) && $grpid > 0) {
$grpdt = $orgGroupObj->select($grpid);
if (is_array($grpdt) && count($grpdt) > 0) {
if (trim($grpdt[0]['vRFQ2AwardAcceptPermits']) != '') {
$grfq2awrdacpt = @explode(',', $grpdt[0]['vRFQ2AwardAcceptPermits']);
}
if (trim($grpdt[0]['vRFQ2BidPermits']) != '') {
$grfq2bid = @explode(',', $grpdt[0]['vRFQ2BidPermits']);
}
}
}
$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'];
$org_rfq2AwardAcptStatus = array();
if (trim($ores[0]['vRFQ2AwardAcceptLevel']) != '') {
$org_rfq2AwardAcptStatus = @explode(',', $ores[0]['vRFQ2AwardAcceptLevel']);
}
// }
// prints($grpdt); exit;
$rfq2awardacceptsts = $orgStaObj->getDetails('vStatus_' . LANG . ' as title,vStatusMsg_' . LANG . ',iStatusID as Id,eFor,eType,vStatusMsg_en as msg,vStatus_en as status', " AND vStatus_en NOT IN ('Create','Verify','Accepted','Rejected') AND eType='Optional' AND vForAuction LIKE '%RFQ2 Award Acceptance%' ", '', '');
// prints($rfq2awardacceptsts); exit;
$codsts = $orgStaObj->getDetails('vStatus_' . LANG . ' as title,vStatusMsg_' . LANG . ',iStatusID as Id,eFor,eType,vStatusMsg_en as msg,vStatus_en as status', " AND vStatus_en='Create' AND vForAuction!='' ", '', '');
$vodsts = $orgStaObj->getDetails('vStatus_' . LANG . ' as title,vStatusMsg_' . LANG . ',iStatusID as Id,eFor,eType,vStatusMsg_en as msg,vStatus_en as status', " AND vStatus_en='Verify' AND vForAuction!='' ", '', '');
$aodsts = $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 vForAuction!='' ", '', '');
$rodsts = $orgStaObj->getDetails('vStatus_' . LANG . ' as title,vStatusMsg_' . LANG . ',iStatusID as Id,eFor,eType,vStatusMsg_en as msg,vStatus_en as status', " AND vStatus_en='Rejected' AND vForAuction!='' ", '', '');
$html = '';
$dis = '';
if (!isset($orgPrefObj)) {
require_once SITE_CLASS_APPLICATION . "organization/class.OrganizationPreference.php";
$orgPrefObj = new OrganizationPreference();
//$sess_id
}
if ($iGroupID != '') {
$view = 'verify';
$OgrpData = $grpData = $orgGroupObj->select($iGroupID);
if ($sess_usertype_short == 'OA' && $grpData[0]['iOrganizationID'] != $curORGID) {
header("Location: " . SITE_URL_DUM . "grouplist");
exit;
}
// $msg = $smarty->get_template_vars('MSG_NEED_VERIFY');
// prints($grpData);exit;
$OuserStatus = $userStatus = @explode(";", $grpData[0]['tPermission']);
$Oorgdata = $orgdata = $orgObj->select($grpData[0]['iOrganizationID']);
$where = ' AND iUserID IN (' . $grpData[0]['tUserID'] . ')';
$Ouserdata = $userdata = $UsrObj->getDetails("CONCAT(vFirstName,' ',vLastName) as vTitle,iUserID as Id", $where);
$where = " ";
$Ostatus = $status = $orgStaObj->getDetails('vStatus_' . LANG . ' as title,vStatusMsg_' . LANG . ',iStatusID as Id,eFor,eType,vStatus_en as status', $where, 'iDisplayOrder', '');
//prints($status);exit;
$where = 'AND iGroupID = ' . $iGroupID . '';
$gdts = $orgGroupVerifyfObj->getDetails('*', $where, ' iVerifiedID desc ', '', ' LIMIT 0,1 ');
if ($gdts[0]['eStatus'] == 'Modified' || $gdts[0]['eNeedToVerify'] == 'Yes' || $gdts[0]['eStatus'] == 'Inactive') {
$where = 'AND iGroupID = ' . $iGroupID . '';
$orderby = ' iVerifiedID Desc';
$grpData = $orgGroupVerifyfObj->getDetails('*', $where, $orderby);
$orgdata = $orgObj->select($grpData[0]['iOrganizationID']);
$where = ' AND iUserID IN (' . $grpData[0]['tUserID'] . ')';
$userdata = $UsrObj->getDetails("CONCAT(vFirstName,' ',vLastName) as vTitle,iUserID as Id", $where);
//prints($userdata);exit;
//prints($groupArr);
$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'", "vState");
//print_r($_SESSION);
$sql = "select vLanguageCode,vLanguage from b2b_language";
$res = $dbobj->MySQLSelect($sql);
$secQueArr1 = array("ID" => "iSecretQuestion1ID", "Name" => "Data[iSecretQuestion1ID]", "Type" => "Query", "tableName" => PRJ_DB_PREFIX . "_sec_question", "fieldId" => "iQuestionId", "fieldName" => "vQuestion_" . $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_LANG'], "extVal" => '', "selectedVal" => $userData['iSecretQuestion1ID'], "width" => '200px', "height" => '', "onchange" => '', "selectText" => "---Select Secret Question---", "where" => "eStatus ='Active' ", "multiple_select" => "", "orderby" => '', "extra" => "", "validationmsg" => "");
$secQueArr2 = array("ID" => "iSecretQuestion2ID", "Name" => "Data[iSecretQuestion2ID]", "Type" => "Query", "tableName" => PRJ_DB_PREFIX . "_sec_question", "fieldId" => "iQuestionId", "fieldName" => "vQuestion_" . $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_LANG'], "extVal" => '', "selectedVal" => $userData['iSecretQuestion2ID'], "width" => '200px', "height" => '', "onchange" => '', "selectText" => "---Select Secret Question---", "where" => "eStatus ='Active' ", "multiple_select" => "", "orderby" => '', "extra" => "", "validationmsg" => "");
$secQuestion1 = $gdbobj->DynamicDropDown($secQueArr1);
$secQuestion1 = str_replace("class=\"input1\"", "class='required' title='Select Secret Question' tabindex='18'", $secQuestion1);
$secQuestion2 = $gdbobj->DynamicDropDown($secQueArr2);
$secQuestion2 = str_replace("class=\"input1\"", "tabindex='20'", $secQuestion2);
if ($userData['iOrganizationID'] != '') {
$orgdtls = $orgObj->select($userData['iOrganizationID']);
}
$phoneData = explode("-", $userData['vPhone']);
if (count($phoneData) == 1) {
$userData['vPhone'] = $phoneData[0];
} else {
$userData['vPhoneCode'] = $phoneData[0];
$userData['vPhone'] = $phoneData[1];
}
$phoneData = explode("-", $userData['vMobile']);
if (count($phoneData) == 1) {
$userData['vMobile'] = $phoneData[0];
} else {
$userData['vMobileCode'] = $phoneData[0];
$userData['vMobile'] = $phoneData[1];
}
} else {
$msg = 'rrer';
}
}
}
if (trim(strtolower($view)) == 'award') {
//
$jtbl = " LEFT JOIN " . PRJ_DB_PREFIX . "_status_master sm on r2bd.iStatusID=sm.iStatusID\r\n\t\t\t\t\tLEFT JOIN " . PRJ_DB_PREFIX . "_rfq2_master rfq2 on r2bd.iRFQ2Id=rfq2.iRFQ2Id ";
$where .= " AND r2bd.iBidId={$iBidId} ";
$fields = " r2bd.*, rfq2.*, sm.vStatus_en as vStatus, r2bd.eSaved ";
$dtls = $r2bdObj->getJoinTableInfo($jtbl, $fields, $where, '', '', '', '');
//
if ($sacpt == 'y') {
//
$db_email = $emailObj->getDetails('*', " AND vType='New RFQ2 Award' AND eSection='Member' ");
$orgdtls = $orgObj->select($dtls[0]['iOrganizationID']);
$link = SITE_URL . "b2rfq2awardview/" . $id;
$body_arr = array("#CREATED_BY#", "#RFQ2CODE#", "#BIDNUM#", "#ADVANCE#", "#PRICE#", "#LINK#");
$post = array($orgdtls[0]['vCompanyName'] . '(' . $orgdtls[0]['vOrganizationCode'] . ')', $dtls[0]['vRFQ2Code'], $dtls[0]['vBidNum'], $dtls[0]['fBidAdvanceTotal'], $dtls[0]['fBidPriceTotal'], $link);
$rplarr = array("Hello #NAME#,", "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));
$dt = array();
$dt['iItemID'] = $id;
$dt['iOrganizationID'] = $dtls[0]['iBuyer2Id'];
$dt['vMailSubject_en'] = $db_email[0]['vSub_en'];
$dt['vMailSubject_fr'] = $db_email[0]['vSub_fr'];
$dt['tMailContent_en'] = $emailContent_en;
$dt['tMailContent_fr'] = $emailContent_fr;
$where = $whu . ' AND eStatus="Active" AND eUserType="Admin" AND iOrganizationID=' . $curORGID . ' ';
$uar = $orgUsrObj->getDetails('*', $where);
// 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;
}
}
}
// $orgObj->setiOrganizationID($dt['iBuyerOrganizationID']);
$dt = $orgObj->select($iBuyerOrganizationID);
$vBuyerCode = $dt[0]['vOrganizationCode'];
// $orgObj->getvOrganizationCode();
$vBuyerName = $dt[0]['vCompanyName'];
$iSupplierAssocationID = PostVar('assocorgs');
$del = PostVar('del');
// prints($_POST); exit;
// $arr=$orgAssocObj->getDetails('iBuyerOrganizationID',' AND iAsociationID="'.$iAsociationID.'" and eStatus != "Inactive" ');
//$vSupplierCode = PostVar('suporgcode');
$vSupplierCode = PostVar('assocCode');
$data['iBuyerOrganizationID'] = $iBuyerOrganizationID;
$data['vAssociationCode'] = $vAssociationCode;
$data['vBuyerCode'] = $vBuyerCode;
$data['iCreatedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
$data['eCreatedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
// pr($data); exit;
$msg = "rrs";
} else {
$msg = "rrer";
}
} else {
$msg = "rrer";
}
}
}
if ($res && trim($sub) != '' && $sub != 'New Bid For RFQ2') {
$jtbl = " LEFT JOIN " . PRJ_DB_PREFIX . "_status_master sm on r2bd.iStatusID=sm.iStatusID\r\n\t\t\t\t\tLEFT JOIN " . PRJ_DB_PREFIX . "_rfq2_master rfq2 on r2bd.iRFQ2Id=rfq2.iRFQ2Id ";
$where .= " AND r2bd.iBidId={$id} ";
$fields = " r2bd.*, rfq2.*, sm.vStatus_en as vStatus, r2bd.eSaved ";
$dtls = $r2bdObj->getJoinTableInfo($jtbl, $fields, $where, '', '', '', '');
//
$orgdtls = $orgObj->select($dtls[0]['iBuyer2Id']);
if (is_array($dtls) && count($dtls) > 0 && is_array($orgdtls) && count($orgdtls) > 0) {
$db_email = $emailObj->getDetails('*', " AND vType='{$sub}' AND eSection='Member' ");
$link = SITE_URL . "viewsrfq2bid/" . $id;
// $body
$post = array($sess_user_name . "({$sess_usertype_short})", $dtls[0]['vRFQ2Code'], $dtls[0]['vBidNum'], $dtls[0]['fBidAdvanceTotal'], $dtls[0]['fBidPriceTotal'], $link);
$rplarr = array("Hello #NAME#,", "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));
$dt['iItemID'] = $id;
$dt['iOrganizationID'] = $dtls[0]['iBuyer2Id'];
$dt['vMailSubject_en'] = $db_email[0]['vSub_en'];
$dt['vMailSubject_fr'] = $db_email[0]['vSub_fr'];
$dt['tMailContent_en'] = $emailContent_en;
$smname = $arr[$i]['vFirstName'] . ' ' . $arr[$i]['vLastName'];
$email = $arr[$i]['vEmail'];
//set the values of the body of email format
$body_arr = array("#SMNAME#", "#CNAME#", "#LINK#", "#ADDED_BY#", "#REGNO#", "#ORGCODE#", "#COMPCODE#", "#MAIL_FOOTER#", "#SITE_URL#");
$post_arr = array($smname, $cname, $link, $smarty->get_template_vars('LBL_SELF_REGISTRATION'), $regno, $code, $compcode, $MAIL_FOOTER, SITE_URL_DUM);
//send mail to the Admin
$sendMail->Send("New Organization Added", "Member", $email, $body_arr, $post_arr);
}
}
//
if ($uid && count($arr) > 0) {
$userName = $_POST['vUserName'];
$userEmail = $_POST['vpEmail'];
$link = SITE_URL_DUM . "organizationuserview/" . $uid;
$body_arr = array("#SMNAME#", "#USERNAME#", "#USEREMAIL#", "#CNAME#", "#COMPCODE#", "#LINK#", "#ADDED_BY#", "#MAIL_FOOTER#", "#SITE_URL#");
$orgDetail = $orgObj->select($oid);
$compname = $orgDetail[0]['vCompanyName'];
$compcode = $orgDetail[0]['vCompCode'];
$emailTo = '';
//set the values of the body of email format
$post_arr = array('', $userName, $userEmail, $smname, $compname, $compcode, $link, $smarty->get_template_vars('LBL_SELF_REGISTRATION'), $MAIL_FOOTER, SITE_URL_DUM);
$where = " AND vType='New Organization Admin Added' AND eSection='Member' ";
$db_email = $emailObj->getDetails('*', $where);
$body = array("#USERNAME#", "#USEREMAIL#", "#CNAME#", "#COMPCODE#", "#LINK#", "#ADDED_BY#");
$post = array($userName, $userEmail, $compname, $compcode, $link, $smarty->get_template_vars('LBL_SELF_REGISTRATION'));
$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));
$Data = array();
// $orgGroupObj->updateData(array('eNeedToVerify'=>'Yes'),$where);
} else {
$var_msg = $smarty->get_template_vars('MSG_VERIFY_NEED_TO_VERIFY_OR_MODIFIED');
echo $var_msg;
exit;
}
} elseif ($v['eStatus'] == 'Modified' || $v['eStatus'] == 'Need to Verify') {
$var_msg = $smarty->get_template_vars('MSG_VERIFY_NEED_TO_VERIFY_OR_MODIFIED');
echo $var_msg;
exit;
}
$where = " AND iGroupID = " . $v['iGroupID'] . "";
$orderby = ' iVerifiedID Desc';
$vrfid = $ogrpvrfObj->getDetails('iVerifiedID', $where, $orderby);
// --------------------- ORGANIZATION DATA FETCHED ------------------------------------------//
$orgdata = $orgObj->select($v['iOrganizationID']);
$GNAME = $v['vGroupName'];
$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="Group Status Changed" AND eSection = "Member"';
$db_email = $emailObj->getDetails('*', $where);
$link = SITE_URL_DUM . "groupview/" . $v['iGroupID'];
$body = array("#GNAME#", "#ORGNAME#", "#CODE#", "#LINK#", "#MODIFIED_BY#");
$post = array($GNAME, $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']);
} elseif($msg == 'raserr') {
$msg = $smarty->get_template_vars('MSG_ADD_ERR');
} else*/
if ($msg == 'tmm') {
$mmsg = $smarty->get_template_vars('LBL_PO_TOTAL_MISMATCH');
$msg = '';
}
/* 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']);
}
$iPurchaseOrderID = $_GET['id'];
$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($iPurchaseOrderID) != '' && is_numeric($iPurchaseOrderID)) {
header("Location: " . SITE_URL_DUM . "purchaseorderview/{$iPurchaseOrderID}");
} else {
header("Location: " . SITE_URL_DUM . "polist/all");
}
}
exit;
}
if ($sess_usertype_short == 'OU' && $poCreate != 'Yes') {
header("Location: " . SITE_URL_DUM . "polist/all");
exit;
$id = $secManObj->updateData($data, $where);
} else {
if ($memtype == 'orguser') {
if (!isset($orgUsrObj)) {
require_once SITE_CLASS_APPLICATION . "user/class.OrganizationUser.php";
$orgUsrObj = new OrganizationUser();
}
$where = " (vUserName='******') ";
$data['vActivationCode'] = '';
$data['vPassword'] = $generalobj->encrypt($newpass);
$id = $orgUsrObj->updateData($data, $where);
if (!isset($orgObj)) {
include_once SITE_CLASS_APPLICATION . "organization/class.Organization.php";
$orgObj = new Organization();
}
$orgDetail = $orgObj->select($memArr[0]['iOrganizationID']);
}
}
$name = $memArr[0]['vFirstName'] . " " . $memArr[0]['vLastName'];
if (!isset($sendMail)) {
require_once SITE_CLASS_GEN . "class.sendmail.php";
$sendMail = new SendPHPMail();
}
/*if($memtype == 'orguser')
{
$compname=$orgDetail[0]['vCompanyName'];
$compcode=$orgDetail[0]['vCompCode'];
//assign values of the Body of the Email Format
$bodyarray = array("#SITE_NAME#","#NAME#","#USERNAME#","#EMAIL#","#PASSWORD#","#CNAME#","#COMPCODE#","#MAIL_FOOTER#","#SITE_URL#");
$postarray = array($SITE_NAME,$name,$memArr[0]['vUserName'],$memArr[0]['vEmail'],$newpass,$compname,$compcode,$MAIL_FOOTER,SITE_URL_DUM);
//echo $email;
$emailObj = new EmailTemplate();
}
$Data = PostVar("Data");
if (is_array($Data['vCurrency'])) {
$Data['vCurrency'] = @implode(',', $Data['vCurrency']);
}
if (trim($Data['eSecureImportExport']) != 'Yes') {
$Data['eSecureImportExport'] = 'No';
}
$iAdditionalInfoID = PostVar("iAdditionalInfoID");
$iOrganizationID = PostVar("iOrganizationID");
$iASMID = PostVar("iASMID");
$view = PostVar("view");
if ($iOrganizationID != '') {
//$orgObj->setiOrganizationID($iOrganizationID);
$orgdtls = $orgObj->select($iOrganizationID);
$arr = $orgprefObj->getDetails('*', " AND iOrganizationID={$iOrganizationID}");
if ($arr[0]['iAdditionalInfoID'] != '') {
$view = 'edit';
} else {
$view = 'add';
}
}
//------------------------DEFALT VALUES OF PURCHASE ORDER -----------------------------------------//
if ($orgdtls[0]['eOrganizationType'] != 'Supplier') {
$where = ' AND eFor = "PO" AND eType = "Default" AND eStatus = "Active"';
$postatus = $stMstrObj->getDetails('*', $where);
foreach ($postatus as $k => $v) {
$poarr[] = $v['iStatusID'];
}
$postatus = @implode(',', $poarr);
$emailArr = $orgUsrObj->getPermittedUsers($curORGID, "%{$csts}%", '', 'vRFQ2AwardPermits', " AND ou.eEmailNotification='Yes' AND ou.eStatus='Active' ");
$body_arr = array("#NAME#", "#MODIFIED_BY#", "#RFQ2CODE#", "#BIDNUM#", "#ADVANCE#", "#PRICE#", "#LINK#", "#MAIL_FOOTER#", "#SITE_URL#");
if (is_array($emailArr) && count($emailArr) > 0) {
for ($i = 0; $i < count($emailArr); $i++) {
$smname = $emailArr[$i]['vFirstName'] . ' ' . $emailArr[$i]['vLastName'];
$email = $emailArr[$i]['vEmail'];
$post_arr = array($smname, $sess_user_name . "({$sess_usertype_short})", $prv_dtls[0]['vRFQ2Code'], $prv_dtls[0]['vBidNum'], $prv_dtls[0]['fBidAdvanceTotal'], $prv_dtls[0]['fBidPriceTotal'], $link, $MAIL_FOOTER, SITE_URL);
$sendMail->Send("RFQ2 Award Status Changed", "Member", $email, $body_arr, $post_arr);
}
}
// }
// else
if ($nstatus[0]['vStatus_en'] == 'Auth3' || $nstatus[0]['vStatus_en'] == 'Accepted') {
if ($nstatus[0]['vStatus_en'] == 'Auth3' && $data['iStatusID'] != $asts[0]['iStatusID']) {
$db_email = $emailObj->getDetails('*', " AND vType='New RFQ2 Award' AND eSection='Member' ");
$oth_org = $orgObj->select($prv_dtls[0]['iOrganizationID']);
$link = SITE_URL . "b2rfq2awardview/" . $iAwardId;
$body_arr = array("#BY#", "#RFQ2CODE#", "#BIDNUM#", "#ADVANCE#", "#PRICE#", "#LINK#");
$post = array($oth_org[0]['vCompanyName'] . '(' . $oth_org[0]['vOrganizationCode'] . ')', $prv_dtls[0]['vRFQ2Code'], $prv_dtls[0]['vBidNum'], $prv_dtls[0]['fBidAdvanceTotal'], $prv_dtls[0]['fBidPriceTotal'], $link);
$rplarr = array("Hello #NAME#,", "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));
$dt = array();
$dt['iItemID'] = $iAwardId;
$dt['iOrganizationID'] = $prv_dtls[0]['iBuyer2Id'];
$dt['vMailSubject_en'] = $db_email[0]['vSub_en'];
$dt['vMailSubject_fr'] = $db_email[0]['vSub_fr'];
$dt['tMailContent_en'] = $emailContent_en;
$dt['tMailContent_fr'] = $emailContent_fr;
