$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;