if (!isset($userActionObj)) {
include_once SITE_CLASS_APPLICATION . 'user/class.UserActionVerification.php';
$userActionObj = new UserActionVerification();
}
// print_r($Data);
$userActionObj->setAllVar($Data);
$userActionObj->insert();
}
//prints(count($emailArr));exit;
for ($i = 0; $i < count($emailArr); $i++) {
$smname = $emailArr[$i]['vFirstName'] . ' ' . $emailArr[$i]['vLastName'];
$emailTo = $emailArr[$i]['vEmail'];
//set the values of the body of email format
$post_arr = array($smname, $userName, $userEmail, $secMan['vFirstName'] . " " . $secMan['vLast Name'], $link, $SITE_NAME, $MAIL_FOOTER, SITE_URL_DUM);
//send mail to the Security Manager and Organization's Admin User
//print_r($post_arr);
if (trim($smname) != '') {
$sendMail->Send($mailtype, "Member", $emailTo, $body_arr, $post_arr);
}
}
}
$var_msg = "rus";
$_SESSION['SESS_' . PRJ_CONST_PREFIX . '_MSG'] = $var_msg;
header("Location:" . SITE_URL_DUM . "oaeditprofile/" . $var_msg);
} else {
$var_msg = "raerr.";
$_SESSION['SESS_' . PRJ_CONST_PREFIX . '_MSG'] = $var_msg;
header("Location:" . SITE_URL_DUM . "oaeditprofile/" . $var_msg);
}
//print SITE_URL_DUM.$var_msg;
exit;
$dt['eCreatedType'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
$dt['dActionDate'] = calcGTzTime(date("Y-m-d H:i:s"), 'Y-m-d H:i:s');
$userActionObj->setAllVar($dt);
$userActionObj->insert();
//
$emailArr = array();
$sts = $statusmasterObj->getDetails('iStatusID', " AND vForAuction LIKE '%RFQ2 Bid,%' AND vStatus_en='Create' ");
$csts = $sts[0]['iStatusID'];
$emailArr = $orgUsrObj->getPermittedUsers($dtls[0]['iBuyer2Id'], "{$csts}%", '', 'vRFQ2BidPermits', " AND ou.eEmailNotification='Yes' AND ou.eStatus='Active' ");
$body_arr = array("#USER#", "#REJECTED_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})", $dtls[0]['vRFQ2Code'], $dtls[0]['vBidNum'], $dtls[0]['fBidAdvanceTotal'], $dtls[0]['fBidPriceTotal'], $link, $MAIL_FOOTER, SITE_URL);
$sendMail->Send("RFQ2 Bid Rejected", "Member", $email, $body_arr, $post_arr);
}
}
}
$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} ";
$dt['dActionDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
$userActionObj->setAllVar($dt);
$userActionObj->insert();
//
$emailArr = array();
//
$sts = $statusmasterObj->getDetails('iStatusID', " AND vForAuction LIKE '%RFQ2 Award,%' AND vStatus_en='" . $nxtp[$nxtk] . "' ");
$csts = $sts[0]['iStatusID'];
$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']);
include SITE_CLASS_GEN . "class.sendmail.php";
$sendMail = new SendPHPMail();
if (!isset($secManObj)) {
include_once SITE_CLASS_APPLICATION . 'securitymanager/class.SecurityManager.php';
$secManObj = new SecurityManager();
}
$gdbobj->getRequestVars();
//prints($_POST);exit;
$password = md5(PostVar('vPassword'));
$Data['vPassword'] = $password;
$iSMID = PostVar("iSMID");
$arr = $secManObj->select($iSMID);
$secManObj->setAllVar($arr);
$secManObj->setAllVar($Data);
$where = "iSMID = '" . $iSMID . "'";
$res = $secManObj->update($where);
if ($res) {
$NAME = $arr[0]['vFirstName'] . " " . $arr[0]['vLastName'];
//set the valuse of the body of email format
$body_arr = array("#NAME#", "#PASSWORD#", "#MAIL_FOOTER#", "#SITE_URL#");
$post_arr = array($NAME, PostVar('vPassword'), $MAIL_FOOTER, SITE_URL_DUM);
//send mail to the desired member
$sendMail->Send("Password changed", "Security Manager", $arr[0]['vEmail'], $body_arr, $post_arr);
}
if ($res) {
$var_msg = "Password changed Successfully.";
} else {
$var_msg = "Eror-in password change.";
}
header("Location:index.php?file=se-smchangepass&view=edit&iSMID=" . $iSMID . "&parent=se-securitymanage&var_msg={$var_msg}");
exit;
$Data['eType'] = 'Modified';
$Data['vMailSubject_en'] = $db_email[0]['vSub_en'];
$Data['vMailSubject_fr'] = $db_email[0]['vSub_fr'];
$Data['tMailContent_en'] = $emailContent_en;
$Data['tMailContent_fr'] = $emailContent_fr;
$Data['iCreatedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
$Data['eCreatedType'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
$Data['dActionDate'] = date("Y-m-d H:i:s");
$userActionObj->setAllVar($Data);
$userActionObj->insert();
for ($i = 0; $i < count($smdtls); $i++) {
$smname = $smdtls[$i]['vFirstName'] . ' ' . $smdtls[$i]['vLastName'];
$email = $smdtls[$i]['vEmail'];
$body_arr = array("#SMNAME#", "#ORGNAME#", "#ACODE#", "#LINK#", "#MODIFIED_BY#", "#MAIL_FOOTER#", "#SITE_URL#");
$post_arr = array($smname, $vBuyerName, $data['vAssociationCode'], $link, $sess_user_name . "({$sess_usertype_short})", $MAIL_FOOTER, SITE_URL_DUM);
$sendMail->Send("Association Updated", "Member", $email, $body_arr, $post_arr);
}
}
//if($msg == 'rus')
//{
// $where = " vAssociationCode = '".$vAssociationCode."' and iBuyerOrganizationID != '".$iBuyerOrganizationID."'";
// $orgAssocObj->updateData(array('eStatus'=>'Inactive'), $where);
// $orgAssocVerifyObj->updateData(array('eStatus'=>'Inactive'), $where);
//}
} else {
include SITE_CLASS_GEN . "class.validation.php";
$validation = new Validation();
### SERVER SIDE VALIDATION ####
$RequiredFiledArr = array('iBuyerOrganizationID' => $smarty->get_template_vars('MSG_SELECT_BUYER_ORGANIZATION'), 'assocorgs' => $smarty->get_template_vars("LBL_SELECT_SELLER_ORG"), 'suporgcode' => $smarty->get_template_vars("LBL_SELECT_SELLER_ORG"), 'assocCode' => $smarty->get_template_vars("LBL_SELECT_SELLER_ORG"));
/*
array( 'orgcode' =>$smarty->get_template_vars('LBL_ENTER_COMP_REG_CODE_NAME'),
$dt['tMailContent_fr'] = $emailContent_fr;
$dt['eSubject'] = "Invoice";
$dt['iCreatedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
$dt['eCreatedType'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
$dt['dActionDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
$userActionObj->setAllVar($dt);
$userActionObj->insert();
if (is_array($tusrs) && count($tusrs) > 0) {
$body_arr = array("#NAME#", "#MODIFIED_BY#", "#INVCODE#", "#SUPPLIERORG#", "#SUPORGCODE#", "#BUYERORG#", "#BUYORGCODE#", "#LINK#", "#MAIL_FOOTER#", "#SITE_URL#");
#pr($iovdt);
for ($i = 0; $i < count($tusrs); $i++) {
$smname = $tusrs[$i]['vFirstName'] . ' ' . $tusrs[$i]['vLastName'];
$email = $tusrs[$i]['vEmail'];
# $post_arr = Array($smname,$sess_user_name."($sess_usertype_short)",$iovdt[0]['vInvoiceCode'],$iovdt[0]['vSupplierName'],$splrorg[0]['vOrganizationCode'],$iovdt[0]['vBuyerCompanyName'],$iovdt[0]['vBuyerCode'],$link,$MAIL_FOOTER,SITE_URL);
$post_arr = array($smname, $sess_user_name . "({$sess_usertype_short})", $iovdt[0]['vInvoiceCode'], $iovdt[0]['vSupplierName'], $iovdt[0]['vInvoiceSupplierCode'], $iovdt[0]['vBuyerName'], $iovdt[0]['vAssociatePOBuyerCode'], $link, $MAIL_FOOTER, SITE_URL);
$sendMail->Send('New Invoice Acceptance', "Member", $email, $body_arr, $post_arr);
#echo "<hr/>";
}
}
}
}
if ($id) {
$msg = "rus";
} else {
$msg = "ruserr";
}
$_SESSION['SESS_' . PRJ_CONST_PREFIX . '_MSG'] = $msg;
$isusts = $statusmasterObj->getDetails('*', " AND eFor='Invoice' AND vStatus_en='Issued' ");
$isusts = $isusts[0]['iStatusID'];
if ($invdtl[0]['iStatusID'] >= $isusts && $curORGID == $invdtl[0]['iBuyerOrganizationID']) {
$nstatus = $nstatus == 1 ? 'all' : $nstatus;
$Data['vMailSubject_en'] = $db_email[0]['vSub_en'];
$Data['vMailSubject_fr'] = $db_email[0]['vSub_fr'];
$Data['tMailContent_en'] = $emailContent_en;
$Data['tMailContent_fr'] = $emailContent_fr;
$Data['iCreatedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
$Data['eCreatedType'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
$Data['dActionDate'] = date("Y-m-d H:i:s");
## INSERT INTO USER ACTION TABLE
$userActionObj->setAllVar($Data);
$userActionObj->insert();
for ($i = 0; $i < count($smdtls); $i++) {
$smname = $smdtls[$i]['vFirstName'] . ' ' . $smdtls[$i]['vLastName'];
$email = $smdtls[$i]['vEmail'];
$body_arr = array("#SMNAME#", "#ORGNAME#", "#ACODE#", "#LINK#", "#MODIFIED_BY#", "#MAIL_FOOTER#", "#SITE_URL#");
$post_arr = array($smname, $ORGNAME, $CODE, $link, $sess_user_name . "({$sess_usertype_short})", $MAIL_FOOTER, SITE_URL_DUM);
$sendMail->Send("Association Status Changed", "Member", $email, $body_arr, $post_arr);
}
unset($Data);
unset($_POST);
if ($res) {
$var_msg = $smarty->get_template_vars('MSG_STATUS_SENT_SUCC');
} else {
$var_msg = $smarty->get_template_vars('MSG_STATUS_SENT_ERR');
}
}
} else {
// if($mode == 'deleteall' || $mode == 'delete')
$where = " AND iAsociationID IN ({$val}) ";
$arr = $assObj->getDetails('*', $where);
foreach ($arr as $k => $v) {
$whr = " vAssociationCode='" . $v['vAssociationCode'] . "'";
$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;
$dt['eSubject'] = "PO";
$dt['iCreatedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
$dt['eCreatedType'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
$dt['dActionDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
$userActionObj->setAllVar($dt);
$userActionObj->insert();
if (is_array($tusrs) && count($tusrs) > 0) {
for ($i = 0; $i < count($tusrs); $i++) {
$smname = $tusrs[$i]['vFirstName'] . ' ' . $tusrs[$i]['vLastName'];
$email = $tusrs[$i]['vEmail'];
$post_arr = array($smname, $sess_user_name . "({$sess_usertype_short})", $povdt[0]['vPOCode'], $povdt[0]['vSupplierName'], $splrorg[0]['vOrganizationCode'], $povdt[0]['vBuyerCompanyName'], $povdt[0]['vBuyerCode'], $link, $MAIL_FOOTER, SITE_URL_DUM);
$sendMail->Send($sub1, "Member", $email, $body_arr, $post_arr);
}
}
/* $invdt[0]['vInvoiceSupplierCode'] = $splrorg[0]['vOrganizationCode'];
$invdt[0]['vInvoiceCode'] = $vInvoiceCode;
$vInvoiceNumber = "INV".$vInvoiceCode."-".trim($invdt[0]['vInvoiceSupplierCode']);
$invdt[0]['vInvoiceNumber'] = $vInvoiceNumber;
$invdt[0]['fOtherTax1'] = $invdt[0]['fOther_tax_1'];
$invdt[0]['vAssociatePOBuyerCode'] = $invdt[0]['vBuyerCode'];
$invdt[0]['vBuyerName'] = $invdt[0]['vBuyerCompanyName'];
$invdt[0]['vBuyerContactParty'] = $invdt[0]['vBuyerContactName'];
$invdt[0]['tInvoiceDescription'] = $invdt[0]['tOrderDescription'];
$invdt[0]['fInvoiceTotal'] = $invdt[0]['fPOTotal'];
$invdt[0]['vFromIP'] = $_SERVER['REMOTE_ADDR'];
$invdt[0]['dCreatedDate'] = $invdt[0]['dIssueDate'] = date("Y-m-d H:i:s");
unset($invdt[0]['fOther_tax_1']);
$Data['vMailSubject_en'] = $db_email[0]['vSub_en'];
$Data['vMailSubject_fr'] = $db_email[0]['vSub_fr'];
$Data['tMailContent_en'] = $emailContent_en;
$Data['tMailContent_fr'] = $emailContent_fr;
$Data['iCreatedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
$Data['eCreatedType'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
$Data['dActionDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
## INSERT INTO USER ACTION TABLE
$userActionObj->setAllVar($Data);
$userActionObj->insert();
for ($i = 0; $i < count($smdtls); $i++) {
$smname = $smdtls[$i]['vFirstName'] . ' ' . $smdtls[$i]['vLastName'];
$email = $smdtls[$i]['vEmail'];
$body_arr = array("#SMNAME#", "#USERNAME#", "#USEREMAIL#", "#SECNAME", "#LINK#", "#MODIFIED_BY#", "#MAIL_FOOTER#", "#SITE_URL#");
$post_arr = array($smname, $userName, $userEmail, $smname, $link, $sess_user_name . "({$sess_usertype_short})", $MAIL_FOOTER, SITE_URL_DUM);
$sendMail->Send("Organization User Status Changed", "Member", $email, $body_arr, $post_arr);
}
unset($Data);
unset($_POST);
if ($res) {
$var_msg = $smarty->get_template_vars('MSG_STATUS_SENT_SUCC');
} else {
$var_msg = $smarty->get_template_vars('MSG_STATUS_SENT_ERR');
}
}
} else {
$where = "AND iUserID IN ({$val})";
$arr = $UsrObj->getDetails('*', $where);
foreach ($arr as $k => $v) {
if (($v['eStatus'] == 'Active' || $v['eStatus'] == 'Inactive' || $v['eStatus'] == '') && $v['eNeedToVerify'] != 'Yes') {
$data['eStatus'] = 'Delete';
$dt['iCreatedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
$dt['eCreatedType'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
$dt['dActionDate'] = calcGTzTime(date("Y-m-d H:i:s"), 'Y-m-d H:i:s');
$userActionObj->setAllVar($dt);
$userActionObj->insert();
//
$emailArr = array();
$sts = $statusmasterObj->getDetails('iStatusID', " AND vForAuction LIKE '%RFQ2,%' AND vStatus_en='Verify' ");
$vsts = $sts[0]['iStatusID'];
$emailArr = $orgUsrObj->getPermittedUsers($dtls[$l]['iOrganizationID'], "{$vsts}%", '', 'vRFQ2Permits', " AND ou.eEmailNotification='Yes' AND ou.eStatus='Active' ");
$body_arr = array("#NAME#", "#CREATEDBY#", "#RFQ2CODE#", "#INVOICECODE#", "#STARTDATE#", "#ENDDATE#", "#TYPE#", "#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})", $dtls[$l]['vCompanyName'] . '(' . $dtls[$l]['vOrganizationCode'] . ')', $dtls[$l]['vRFQ2Code'], $dtls[$l]['vInvoiceCode'], $dtls[$l]['dStartDate'], $dtls[$l]['dEndDate'], $link, $MAIL_FOOTER, SITE_URL);
$sendMail->Send("RFQ2 Deleted", "Member", $email, $body_arr, $post_arr);
}
}
//}
}
//
}
$msg = $smarty->get_template_vars('MSG_DEL_SENT_SUCC');
} else {
$msg = $smarty->get_template_vars('MSG_DEL_SENT_ERR');
}
}
}
echo $msg;
exit;
$sendMail = new SendPHPMail();
if (!isset($secManObj)) {
include_once SITE_CLASS_APPLICATION . 'securitymanager/class.SecurityManager.php';
$secManObj = new SecurityManager();
}
$gdbobj->getRequestVars();
$password = $generalobj->encrypt(PostVar('vPassword'));
$Data['vPassword'] = $password;
$iSMID = PostVar("iSMID");
$email = $_POST['vEmail'];
$FirstName = $_POST['vFirstName'];
$LastName = $_POST['vLastName'];
$where = "iSMID = '" . $iSMID . "'";
$res = $secManObj->updateData($Data, $where);
//$arr[0]['vEmail'];
if ($res) {
$NAME = $FirstName . " " . $LastName;
$pass = PostVar('vPassword');
//set the valuse of the body of email format
$body_arr = array("#NAME#", "#PASSWORD#", "#MAIL_FOOTER#", "#SITE_URL#");
$post_arr = array($NAME, $pass, $MAIL_FOOTER, SITE_URL_DUM);
//send mail to the desired member
$sendMail->Send("Password changed", "Member", $email, $body_arr, $post_arr);
}
if ($res) {
$var_msg = "Password changed Successfully.";
} else {
$var_msg = "Eror-in password change.";
}
header("Location:index.php?file=se-smchangepass&view=edit&iSMID=" . $iSMID . "&parent=se-securitymanager&var_msg={$var_msg}");
exit;
include_once SITE_CLASS_APPLICATION . 'user/class.UserActionVerification.php';
$userActionObj = new UserActionVerification();
}
//prints($Data);exit;
$userActionObj->setAllVar($Data);
$userActionObj->insert();
}
//prints(count($emailArr));exit;
for ($i = 0; $i < count($emailArr); $i++) {
$smname = $emailArr[$i]['vFirstName'] . ' ' . $emailArr[$i]['vLastName'];
$emailTo = $emailArr[$i]['vEmail'];
//set the values of the body of email format
$post_arr = array($smname, $userName, $userEmail, $secMan['vFirstName'] . " " . $secMan['vLast Name'], $compname, $compcode, $link, $sess_user_name . "({$sess_usertype_short})", $MAIL_FOOTER, SITE_URL_DUM);
//send mail to the Security Manager and Organization's Admin User
if (trim($smname) != '') {
$sendMail->Send($mailtype, "Member", $emailTo, $body_arr, $post_arr, '', '');
}
}
}
if ($view == "edit") {
$_SESSION['from'] = 'usr';
$var_msg = "rus";
} elseif ($view == "verify") {
$var_msg = "rvs";
} else {
$_SESSION['from'] = 'usr';
$var_msg = "ras";
}
unset($Data);
unset($_POST);
if ($dupl == 'dpl') {
$Data['tMailContent_fr'] = $emailContent_fr;
$Data['iCreatedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
$Data['eCreatedType'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
$Data['dActionDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
// print_r($Data);
$userActionObj->setAllVar($Data);
$userActionObj->insert();
for ($i = 0; $i < count($emailArr); $i++) {
$smname = $emailArr[$i]['vFirstName'] . ' ' . $emailArr[$i]['vLastName'];
$email = $emailArr[$i]['vEmail'];
//set the values of the body of email format
$body_arr = array("#SMNAME#", "#CNAME#", "#LINK#", "#MODIFIED_BY#", "#REGNO#", "#ORGCODE#", "#MAIL_FOOTER#", "#SITE_URL#");
$post_arr = array($smname, $cname, $link, $sess_user_name . "({$sess_usertype_short})", $regno, $code, $MAIL_FOOTER, SITE_URL_DUM);
//prints($body_arr);exit;
//send mail to the Admin
$sendMail->Send("Organization Updated", "Member", $email, $body_arr, $post_arr);
}
}
if ($res) {
$orgdtls = $orgObj->select($iOrganizationID);
if ($orgdtls[0]['eOrganizationType'] == 'Supplier') {
$opdt['vOrderStatusLevel'] = '';
$rs = $orgprefObj->updateData($opdt, "iOrganizationID={$iOrganizationID}");
} else {
if ($orgdtls[0]['eOrganizationType'] == 'Buyer') {
$opdt['vInvoiceStatusLevel'] = '';
$rs = $orgprefObj->updateData($opdt, "iOrganizationID={$iOrganizationID}");
}
}
$rs = $orgUserPermObj->clearExtraPermits($iOrganizationID, $orgdtls[0]['eOrganizationType']);
}
$Data['vMailSubject_en'] = $db_email[0]['vSub_en'];
$Data['vMailSubject_fr'] = $db_email[0]['vSub_fr'];
$Data['tMailContent_en'] = $emailContent_en;
$Data['tMailContent_fr'] = $emailContent_fr;
$Data['iCreatedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
$Data['eCreatedType'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
$Data['dActionDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
## INSERT INTO USER ACTION TABLE
$userActionObj->setAllVar($Data);
$userActionObj->insert();
for ($i = 0; $i < count($smdtls); $i++) {
$smname = $smdtls[$i]['vFirstName'] . ' ' . $smdtls[$i]['vLastName'];
$email = $smdtls[$i]['vEmail'];
$body_arr = array("#SMNAME#", "#GNAME#", "#ORGNAME#", "#CODE#", "#LINK#", "#MODIFIED_BY#", "#MAIL_FOOTER#", "#SITE_URL#");
$post_arr = array($smname, $GNAME, $ORGNAME, $CODE, $link, $sess_user_name . "({$sess_usertype_short})", $MAIL_FOOTER, SITE_URL_DUM);
$sendMail->Send("Group Status Changed", "Member", $email, $body_arr, $post_arr);
}
unset($Data);
unset($_POST);
if ($res) {
$var_msg = $smarty->get_template_vars('MSG_STATUS_SENT_SUCC');
} else {
$var_msg = $smarty->get_template_vars('MSG_STATUS_SENT_ERR');
}
}
} else {
$where = "AND iGroupID IN ({$val})";
$arr = $orgGroupObj->getDetails('*', $where);
foreach ($arr as $k => $v) {
if ($v['eStatus'] == 'Active' || $v['eStatus'] == 'Inactive') {
$data['eStatus'] = 'Delete';
$Data['vMailSubject_en'] = $db_email[0]['vSub_en'];
$Data['vMailSubject_fr'] = $db_email[0]['vSub_fr'];
$Data['tMailContent_en'] = $emailContent_en;
$Data['tMailContent_fr'] = $emailContent_fr;
$Data['iCreatedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
$Data['eCreatedType'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
$Data['dActionDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
## INSERT INTO USER ACTION TABLE
$userActionObj->setAllVar($Data);
$userActionObj->insert();
for ($i = 0; $i < count($emailarr); $i++) {
$smname = $emailarr[$i]['vFirstName'] . ' ' . $emailarr[$i]['vLastName'];
$email = $emailarr[$i]['vEmail'];
$body_arr = array("#SMNAME#", "#GNAME#", "#ORGNAME#", "#CODE#", "#LINK#", "#MODIFIED_BY#", "#MAIL_FOOTER#", "#SITE_URL#");
$post_arr = array($smname, $GNAME, $orgnm, $CODE, $link, $sess_user_name . "({$sess_usertype_short})", $MAIL_FOOTER, SITE_URL_DUM);
$sendMail->Send("Group Updated", "Member", $email, $body_arr, $post_arr);
}
}
unset($Data);
unset($_POST);
if ($res) {
$var_msg = "rus";
} else {
$var_msg = "ruserr";
}
} else {
include SITE_CLASS_GEN . "class.validation.php";
$validation = new Validation();
$RequiredFiledArr = array('iOrganizationID' => $smarty->get_template_vars('LBL_SELECT_ONE_ORG'), 'vGroupName' => $smarty->get_template_vars('LBL_ENTER_GROUP_NAME'));
$resArr = $validation->isEmpty($RequiredFiledArr);
$DupGroupName = $validation->ChekDupGroupName($id, 'vGroupName', PRJ_DB_PREFIX . "_organization_group", $Data['vGroupName'], $smarty->get_template_vars('LBL_GROUP_NAME_TAKEN'));
//prints($Data);exit;
$secManObj->setAllVar($Data);
$id = $secManObj->insert();
if ($id) {
$var_msg = "Record Added Successfully.";
$NAME = $Data['vFirstName'] . " " . $Data['vLastName'];
$link = $Data['vEmail'];
$password = PostVar('vPassword');
//set the values of the body of email format
$body_arr = array("#NAME#", "#SITE_NAME#", "#USERNAME#", "#EMAIL#", "#MAIL_FOOTER#", "#SITE_URL#");
// $admins = $adminUserObj->getDetails('*'," AND eStatus='Active' AND iAdminId!=".$_SESSION['B2B_SESS_USERID']);
// for($l=0;$l<count($admins);$l++)
// {
$post_arr = array($NAME, $SITE_NAME, $Data['vUserName'], $link, $MAIL_FOOTER, SITE_URL_DUM);
//send mail to the Admins
$sendMail->Send("New Security Manager Added", "Admin", $ADMIN_EMAIL, $body_arr, $post_arr);
// }
//set the values of the body of email format
$body_arr = array("#NAME#", "#SITE_NAME#", "#USERNAME#", "#PASSWORD#", "#EMAIL#", "#MAIL_FOOTER#", "#SITE_URL#");
$post_arr = array($NAME, $SITE_NAME, $Data['vUserName'], $password, $link, $MAIL_FOOTER, SITE_URL_DUM);
// prints($post_arr); exit;
//send mail to the desired member
$sendMail->Send("Registration", "Member", $link, $body_arr, $post_arr);
$eml = $Data['vEmail'];
unset($Data);
// dpr email for duplication of email in rec
if ($dupl == 'dpl') {
$emailArr = $adminUserObj->getDetails('vFirstName,vLastName,vEmail', " AND iAdminID !='" . $iAdminID . "'");
$link = SITE_URL_DUM . "b2badmin/index.php?file=se-securitymanager&view=edit&iSMID=" . $id;
for ($i = 0; $i < count($emailArr); $i++) {
$smname = $emailArr[$i]['vFirstName'] . ' ' . $emailArr[$i]['vLastName'];
$Data['dActionDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
//print_r($Data);exit;
$Data['iCreatedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
$Data['eCreatedType'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
// prints($Data); exit;
$userActionObj->setAllVar($Data);
$userActionObj->insert();
// prints($emailArr); exit;
for ($i = 0; $i < count($emailArr); $i++) {
$smname = $emailArr[$i]['vFirstName'] . ' ' . $emailArr[$i]['vLastName'];
$email = $emailArr[$i]['vEmail'];
//set the values of the body of email format
$body_arr = array("#NAME#", "#ORGNAME#", "#ORGCODE#", "#USERNAME#", "#USEREMAIL#", "#LINK#", "#MODIFIED_BY#", "#MAIL_FOOTER#", "#SITE_URL#");
$post_arr = array($smname, $orgdt[0]['vCompanyName'], $orgdt[0]['vOrganizationCode'], $usrdt[0]['vUserName'], $usrdt[0]['vEmail'], $link, $sess_user_name . "({$sess_usertype_short})", $MAIL_FOOTER, SITE_URL_DUM);
//send mail to the Admin
$sendMail->Send("User Rights Changed", "Member", $email, $body_arr, $post_arr);
}
}
/*
## INSERT INTO VERIFY TABLE
$Data_verify = $Data;
$Data_verify['iPermissionID'] = $iPermissionID;
$orgUserPermVerifyObj->setAllVar($Data_verify);
$res = $orgUserPermVerifyObj->insert();
*/
unset($Data);
unset($_POST);
if ($res && $var_msg == '') {
$var_msg = "ras";
} else {
if ($var_msg == '') {
$dt['tMailContent_en'] = $emailContent_en;
$dt['tMailContent_fr'] = $emailContent_fr;
$dt['iCreatedBy'] = $userId;
$dt['eCreatedType'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
$dt['eSubject'] = "PO";
$dt['dActionDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
// if((is_array($emailArr) && count($emailArr) > 0) || (is_array($usrarr) && count($usrarr)>0)) {
$userActionObj->setAllVar($dt);
// pritns($dt); exit;
$userActionObj->insert();
$where = 'AND vType="Invoice Deleted" AND eSection = "Member"';
$db_email = $emailObj->getDetails('*', $where);
$link = SITE_URL_DUM . "invoiceview/" . $v['iInvoiceID'];
for ($i = 0; $i < count($emailArr); $i++) {
$smname = $emailArr[$i]['vFirstName'] . ' ' . $emailArr[$i]['vLastName'];
$email = $emailArr[$i]['vEmail'];
$body_arr = array("#SMNAME#", "#INVNUMBER#", "#INVCODE#", "#SUPPLIER#", "#BUYER#", "#LINK#", "#DELETE_BY#", "#MAIL_FOOTER#", "#SITE_URL#");
$post_arr = array($smname, $INVNUMBER, $INVCODE, $SUPPLIER, $BUYER, $link, $sess_user_name . "({$sess_usertype_short})", $MAIL_FOOTER, SITE_URL_DUM);
$sendMail->Send("Invoice Deleted", "Member", $email, $body_arr, $post_arr);
}
unset($Data);
unset($_POST);
if ($res) {
$var_msg = $smarty->get_template_vars('MSG_DEL_SENT_SUCC');
} else {
$var_msg = $smarty->get_template_vars('MSG_DEL_SENT_ERR');
}
}
}
echo $var_msg;
exit;
$dt['eCreatedType'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
$dt['dActionDate'] = calcGTzTime(date("Y-m-d H:i:s"), 'Y-m-d H:i:s');
$userActionObj->setAllVar($dt);
$userActionObj->insert();
//
$emailArr = array();
$sts = $statusmasterObj->getDetails('iStatusID', " AND vForAuction LIKE '%RFQ2 Award,%' AND vStatus_en='Create' ");
$csts = $sts[0]['iStatusID'];
$emailArr = $orgUsrObj->getPermittedUsers($dtls[0]['iBuyer2Id'], "{$csts}%", '', 'vRFQ2AwardPermits', " AND ou.eEmailNotification='Yes' AND ou.eStatus='Active' AND ou.iUserID != '" . $sess_id . "' ");
$body_arr = array("#NAME#", "#CREATED_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($orgdtls[0]['vCompanyName'] . '(' . $orgdtls[0]['vOrganizationCode'] . ')', $dtls[0]['vRFQ2Code'], $dtls[0]['vBidNum'], $dtls[0]['fBidAdvanceTotal'], $dtls[0]['fBidPriceTotal'], $link, $MAIL_FOOTER, SITE_URL);
$sendMail->Send("New RFQ2 Award", "Member", $email, $body_arr, $post_arr);
}
}
//
} else {
//
$db_email = $emailObj->getDetails('*', " AND vType='New RFQ2 Award' AND eSection='Member' ");
$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, '', '', '', '');
//
$link = SITE_URL . "rfq2awardview/" . $dtls[0]['iRFQ2Id'];
$body_arr = array("#CREATED_BY#", "#RFQ2CODE#", "#ADVANCE#", "#PRICE#", "#LINK#");
$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#");
$Data['vMailSubject_fr'] = $db_email[0]['vSub_fr'];
$Data['tMailContent_en'] = $emailContent_en;
$Data['tMailContent_fr'] = $emailContent_fr;
$Data['iCreatedBy'] = isset($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID']) ? $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'] : '0';
$Data['eCreatedType'] = isset($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT']) ? $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'] : '0';
$Data['dActionDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
$userActionObj->setAllVar($Data);
$userActionObj->insert();
for ($i = 0; $i < count($arr); $i++) {
$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' ";
include SITE_CLASS_GEN . "class.sendmail.php";
$sendMail = new SendPHPMail();
$parseObj = new xmlparser();
$userName = GetVar('uname');
$type = GetVar('type');
$adArr = $adminobj->chkFPassword($userName);
/*echo "<pre>";
print_r($adArr);exit;*/
$xmlcontent = '<?xml version="1.0"?><list>';
if (count($adArr) > 0) {
$sucss = '1';
$newpass = $generalobj->GenerateAdminPass('4');
//$xmlcontent .='<uname>'.stripslashes($adArr[0]['vPassword']).'</uname>';
if ($type == 'uname') {
$Data['vPassword'] = md5($newpass);
$where = " iAdminId = '" . $adArr[0]['iAdminId'] . "'";
$res = $dbobj->MySQLQueryPerform("" . PRJ_DB_PREFIX . "_administrator", $Data, 'update', $where);
if ($res) {
$body_arr = array("#NAME#", "#USERNAME#", "#PASSWORD#", "#MAIL_FOOTER#", "#SITE_URL#");
$post_arr = array($adArr[0]['Name'], $userName, $newpass, $MAIL_FOOTER, SITE_URL_DUM);
$sendMail->Send("Forgot Passsword Admin", "Admin", $adArr[0]['vEmail'], $body_arr, $post_arr);
}
}
} else {
$sucss = '0';
}
$xmlcontent .= '<type>' . $type . '</type>';
$xmlcontent .= '<succ>' . str_replace("&", "and", $sucss) . '</succ>';
$xmlcontent .= '</list>';
$parseObj = new xmlparser();
$parseObj->output_xml($xmlcontent);
}
if (is_array($oadms) && count($oadms) > 0) {
$oa_emails = multi21Array($oadms, 'vEmail');
$oa_emails = array_filter($oa_emails);
$oaemails = @implode(',', $oa_emails);
}
//
if (!isset($sendMail)) {
include_once SITE_CLASS_GEN . "class.sendmail.php";
$sendMail = new SendPHPMail();
}
if (trim($smemails) != '') {
$user = '******';
$body_arr = array("#USER#", "#BUYER2#", "#BUYER#", "#ACODE#", "#LINK#", "#MODIFIED_BY#", "#MAIL_FOOTER#", "#SITE_URL#");
$post_arr = array($user, $assocs[$l]['vBuyer2'], $assocs[$l]['vBuyer'], $assocs[$l]['vACode'], $link, $sess_user_name . "({$sess_usertype_short})", $MAIL_FOOTER, SITE_URL_DUM);
$sendMail->Send($esubtyp, "Member", $smemails, $body_arr, $post_arr);
}
if (trim($oaemails) != '') {
$user = '******';
$body_arr = array("#USER#", "#BUYER2#", "#BUYER#", "#ACODE#", "#LINK#", "#MODIFIED_BY#", "#MAIL_FOOTER#", "#SITE_URL#");
$post_arr = array($user, $assocs[$l]['vBuyer2'], $assocs[$l]['vBuyer'], $assocs[$l]['vACode'], $link, $sess_user_name . "({$sess_usertype_short})", $MAIL_FOOTER, SITE_URL_DUM);
$sendMail->Send($esubtyp, "Member", $oaemails, $body_arr, $post_arr);
}
//
}
}
}
}
}
ob_clean();
echo $msg;
$where .= " AND org.vCompCode='" . $orgcode . "' ";
$memArr = $generalobj->getTableInfo(PRJ_DB_PREFIX . '_organization_user user INNER JOIN ' . PRJ_DB_PREFIX . '_organization_master org on user.iOrganizationID=org.iOrganizationID', $where, 'iUserID,vUserName,vFirstName,vLastName,vPassword,user.vEmail,user.iOrganizationID,user.vAnswer,user.eStatus', '', "");
$table = PRJ_DB_PREFIX . '_organization_user';
}
}
//
$msg = "";
if (is_array($memArr[0]) && count($memArr[0]) > 0) {
if (!isset($memArr[0]['eStatus']) || $memArr[0]['eStatus'] != 'Active') {
$msg = $smarty->get_template_vars('LBL_ACCOUNT_NOT_ACTIVE_OR_MODIFIED');
} else {
$activationcode = substr($memtype, 0, 1) . '-' . md5($memArr[0]['vEmail'] . time());
if ($memtype == 'securitymanager') {
$where = " iSMID=" . $memArr[0]['iSMID'] . " ";
} else {
$where = " iUserID=" . $memArr[0]['iUserID'] . " ";
}
$dbobj->MySQLQueryPerform($table, array('vActivationCode' => $activationcode), 'update', $where);
$bodyarray = array("#NAME#", "#SITE_NAME#", "#LINK", "#MAIL_FOOTER#", "#SITE_URL#");
$name = $memArr[0]['vUserName'];
$email = $memArr[0]['vEmail'];
$link = SITE_URL_DUM . "forgotpass" . '/' . $activationcode;
$postarray = array($name, $SITE_NAME, $link, $MAIL_FOOTER, SITE_URL_DUM);
$rs = $sendMail->Send('Forgot Password Link', 'Member', $email, $bodyarray, $postarray);
$msg = $smarty->get_template_vars('LBL_LINK_TO_CHANGE_PASSWORD_EMAILED');
}
} else {
$msg = $smarty->get_template_vars('LBL_WRONG_USER_DETAILS');
}
echo $msg;
exit;
