$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'] = "RFQ2";
$dt['eType'] = "Create";
$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[0]['iOrganizationID'], "{$vsts}%", '', 'vRFQ2Permits', " AND ou.eEmailNotification='Yes' AND ou.eStatus='Active' ");
$body_arr = array("#USER#", "#CREATED_BY#", "#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, $orgdtls[0]['vCompanyName'] . '(' . $orgdtls[0]['vOrganizationCode'] . ')', $dtls[0]['vRFQ2Code'], $dtls[0]['vInvoiceCode'], $dtls[0]['dStartDate'], $dtls[0]['dEndDate'], $dtls[0]['eBidCriteria'], $link, $MAIL_FOOTER, SITE_URL);
$sendMail->Send("New RFQ2", "Member", $email, $body_arr, $post_arr);
}
}
}
}
$msg = 'ras';
} else {
$msg = 'raer';
}
if ($id) {
if ($dt['iaStatusID'] == $acptsts) {
$r = $invOrdObj->updateData(array('dAcceptedDate' => calcGTzTime(date('Y-m-d'), 'Y-m-d')), " iInvoiceID={$iInvoiceID} ");
}
$isusts = $statusmasterObj->getDetails('*', " AND eFor='Invoice' AND vStatus_en='Issued' ");
if ($nsts == $isusts[0]['iStatusID'] && $invdtl[0]['iStatusID'] != $isusts[0]['iStatusID']) {
// && ($invdtl[0]['iPurchaseOrderID'] == '' || $invdtl[0]['iPurchaseOrderID']<1)
// $vInvoiceCode = $generalobj->getUniqueCode(PRJ_DB_PREFIX."_inovice_order_heading","vInvoiceCode");
$iovdt = $invOrdObj->select($iInvoiceID);
#$splrorg = $orgObj->select($iovdt[0]['iSupplierOrganizationID']); // iBuyerOrganizationID
#$byrorg = $orgObj->select($iovdt[0]['iBuyerOrganizationID']);
#pr($splrorg);
#pr($byrorg);
// New Invoice Acceptance
$acptsts = $statusmasterObj->getDetails('*', " AND eFor='Invoice' AND vStatus_en='Accepted' ");
$tusrs = $orgUsrObj->getPermittedUsers($iovdt[0]['iBuyerOrganizationID'], $acptsts[0]['iStatusID'], 'inv', 'acpt');
$where = "AND vType='New Invoice Acceptance' AND eSection='Member'";
$db_email = $emailObj->getDetails('*', $where);
$link = SITE_URL . "invoiceview/" . $iInvoiceID;
$body = array("#INVCODE#", "#SUPPLIERORG#", "#SUPORGCODE#", "#BUYERORG#", "#BUYORGCODE#", "#LINK#");
$post = array($iovdt[0]['vInvSupplierCode'], $iovdt[0]['vSupplierName'], $iovdt[0]['vInvoiceSupplierCode'], $iovdt[0]['vBuyerName'], $iovdt[0]['vAssociatePOBuyerCode'], $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'] = $iInvoiceID;
// $id
$dt['iOrganizationID'] = $iovdt[0]['iBuyerOrganizationID'];
// $iovdt[0]['iSupplierOrganizationID'];
$dt['vMailSubject_en'] = $db_email[0]['vSub_en'];
for ($l = 0; $l < count($mchpref['inv']); $l++) {
$mth[] = $mchpref['inv'][$l]['iStatusID'];
}
$orginvstatus = $orgpref['inv'];
for ($l = 0; $l < count($orginvstatus); $l++) {
if ($orginvstatus[$l]['iStatusID'] > $invdt[0]['iStatusID'] && in_array($orginvstatus[$l]['iStatusID'], $mth)) {
$nxtstatus = $orginvstatus[$l];
break;
}
}
} else {
$nxtstatus['iStatusID'] = '0';
}
$sts = $nxtstatus['iStatusID'];
// $invdt[0]['iStatusID'];
$susrarr = $orgUsrObj->getPermittedUsers($invdt[0]['iSupplierOrganizationID'], $sts, 'inv', 'isu');
$busrarr = $orgUsrObj->getPermittedUsers($invdt[0]['iBuyerOrganizationID'], $sts, 'inv', 'acpt');
// $usrarr = $orgUsrObj->getPermittedUsers($invdt[0]['iBuyerOrganizationID'],$sts,'inv','acpt');
$link = SITE_URL . "invoiceview/" . $in;
$body = array("#ADDED_BY#", "#INVCODE#", "#SUPPLIERORG#", "#SUPORGCODE#", "#BUYERORG#", "#BUYORGCODE#", "#LINK#");
$post = array($sess_user_name . "({$sess_usertype_short})", $invdt[0]['vInvoiceCode'], $invdt[0]['vSupplierName'], $invdt[0]['vInvoiceSupplierCode'], $invdt[0]['vBuyerName'], $invdt[0]['vAssociatePOBuyerCode'], $link);
$rplarr = array("Hello #USER#,", "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['iOrganizationID'] = $curORGID;
// $invdt[0]['iSupplierOrganizationID'];
$dt['vMailSubject_en'] = $db_email[0]['vSub_en'];
$dt['vMailSubject_fr'] = $db_email[0]['vSub_fr'];
$dt['tMailContent_en'] = $emailContent_en;
