if ($totusrs > 1) {
$dt['iStatusID'] = $nstatus;
} else {
$stsdtls = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Issued' ");
$isusts = $stsdtls[0]['iStatusID'];
if ($podtl[0]['iSupplierOrganizationID'] == $curORGID && $podtl[0]['iStatusID'] == $isusts) {
$acptsts = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Accepted' ");
$dt['iStatusID'] = $acptsts[0]['iStatusID'];
} else {
// $stsdtls = $statusmasterObj->getDetails('*'," AND eFor='PO' AND vStatus_en='Issued' ");
$dt['iStatusID'] = $isusts;
}
}
$dt['iModifiedByID'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
// prints($dt); exit;
$id = $pohObj->updateData($dt, " iPurchaseOrderID={$iPurchaseOrderID} ");
$vrfydt['iVerifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
$vrfydt['eVerifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
// $vrfydt['eCreatedType'] = $_SESSION['SESS_'.PRJ_CONST_PREFIX.'_USER_TYPE_SHORT'];
$vrfydt['dVerifyDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
$vrfydt['vVerifyFromIP'] = $_SERVER['REMOTE_ADDR'];
$res = $userActionObj->updateData($vrfydt, "iItemID={$id} AND eSubject='PO'");
if ($id) {
$isusts = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Issued' ");
if ($nstatus == $isusts[0]['iStatusID'] && ($podtl[0]['iInvoiceID'] == '' || $podtl[0]['iInvoiceID'] < 1)) {
// $vInvoiceCode = $generalobj->getUniqueCode(PRJ_DB_PREFIX."_inovice_order_heading","vInvoiceCode");
$povdt = $pohObj->select($iPurchaseOrderID);
$splrorg = $orgObj->select($povdt[0]['iSupplierOrganizationID']);
// New PO Acceptance
$acptsts = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Accepted' ");
$tusrs = $orgUsrObj->getPermittedUsers($povdt[0]['iSupplierOrganizationID'], $acptsts[0]['iStatusID'], 'po', 'acpt');
$fields = "poh.*,(select org.vCompanyName from b2b_organization_master org where org.iOrganizationID=poh.iSupplierOrganizationID) as vSupplierName";
$arr = $poObj->getJoinTableInfo("", $fields, $where);
//prints($arr);exit;
$userId = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
$orgId = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ORGID'];
$where = " AND iOrganizationID='{$orgId}'";
$emailArr = $orgUserObj->getDetails('vFirstName,vLastName,vEmail', $where);
$where = "";
foreach ($arr as $k => $v) {
$data['eDelete'] = 'Yes';
$data['iModifiedByID'] = $userId;
// $data['eModifiedBy'] = $_SESSION['SESS_'.PRJ_CONST_PREFIX.'_USER_TYPE_SHORT'];
// $data['dModifiedDate'] = date('Y-m-d H:i:s');
$poObj->setAllVar($data);
$where = "iPurchaseOrderID IN (" . $v['iPurchaseOrderID'] . ")";
$res = $poObj->updateData($data, $where);
$link = SITE_URL_DUM . "purchaseorderview/" . $v['iPurchaseOrderID'];
$POCODE = $v['vPOCode'];
$PONUMBER = $v['vPONumber'];
$SUPPLIER = $v['vSupplierName'];
if ($SUPPLIER == '') {
$SUPPLIER = "---";
}
$BUYER = $v['vBuyerCompanyName'];
$where = "AND vType='PO Deleted' AND eSection='Member'";
$db_email = $emailObj->getDetails('*', $where);
$body = array("#DELETE_BY#", "#PONUMBER#", "#POCODE#", "#SUPPLIER#", "#BUYER#", "#LINK#");
$post = array($sess_user_name . "({$sess_usertype_short})", $PONUMBER, $POCODE, $SUPPLIER, $BUYER, $link);
$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));
}
if ($id) {
$msg = "rus";
} else {
$msg = "ruserr";
}
}
}
}
//echo "$subt<br/>$dist<br/>$chgt<br/>$ltl";
//exit;
$eSaved = $_POST['eSaved'];
if ($eSaved != 'Yes') {
$dtl['eSaved'] = $eSaved;
$wh_cn = "iPurchaseOrderID={$iPurchaseOrderID}";
$rs = $pohObj->updateData($dtl, $wh_cn);
}
// prints($ilineItemCode); exit;
$lineitmCode = "0";
if (is_array($ilineItemCode) && count($ilineItemCode) > 0) {
$lineitmCode = @implode("','", $ilineItemCode);
}
$d = $poLineObj->del(" AND vItemCode NOT IN ('{$lineitmCode}') AND iPurchaseOrderID={$iPurchaseOrderID} ");
$pdt = array();
if ($podt[0]['eLineItemTax'] == 'Yes' || !($podt[0]['fVat'] > 0) && $tvat > 0) {
$pdt['fVat'] = $tvat;
// $pdt['fOther_tax_1'] = $otax;
}
if ($podt[0]['eLineItemTax'] == 'Yes' || !($podt[0]['fOther_tax_1'] > 0) && $otax > 0) {
// $pdt['fVat'] = $tvat;
$pdt['fOther_tax_1'] = $otax;
$redtl = array('iRFQ2Id' => $dtls[0]['iRFQ2Id'], 'iBuyer2Id' => $dtls[0]['iBuyer2Id'], 'iBuyerId' => $dtls[0]['iBuyerOrganizationId'], 'iSupplierId' => $dtls[0]['iSupplierOrganizationId'], 'iInvoiceID' => $dtls[0]['iInvoiceID'], 'iPurchaseOrderID' => $dtls[0]['iPurchaseOrderID'], 'vCurrency' => $dtls[0]['vCurrency'], 'dReviewDate' => date('Y-m-d', strtotime("+5 day", strtotime(date('Y-m-d')))), 'eFrom' => $dtls[0]['eFrom']);
$re = $rfq2extractObj->insert($redtl);
// set invoice rfq2awarded yes
if ($dtls[0]['eFrom'] == 'Invoice') {
if (!isset($invOrdObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.InvoiceOrderHeading.php";
$invOrdObj = new InvoiceOrderHeading();
}
$ress = $invOrdObj->updateData(array('eRfq2Awarded' => 'Yes'), " iInvoiceID=" . $dtls[0]['iInvoiceID']);
} else {
if ($dtls[0]['eFrom'] == 'PO') {
if (!isset($poOrdObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.PurchaseOrderHeading.php";
$poOrdObj = new PurchaseOrderHeading();
}
$ress = $poOrdObj->updateData(array('eRfq2Awarded' => 'Yes'), " iPurchaseOrderID=" . $dtls[0]['iPurchaseOrderID']);
}
}
//send mail to buyer2 for award.
$db_email = $emailObj->getDetails('*', " AND vType='New RFQ2 Award' AND eSection='Member' ");
$orgdtls = $orgObj->select($dtls[0]['iOrganizationID']);
$link = SITE_URL . "b2rfq2awardview/" . $r2awid;
$body = 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'] = $r2awid;
$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);
$iPOId = $pohObj->insert();
$vImage = $imgObj->ImageUpload('PO', 'image', $iPOId, $_FILES['importfile'], '');
$Dta['vImage'] = $vImage;
$iPOId = $pohObj->updateData($Dta, "iPurchaseOrderID={$iPOId}");
$var_msg = 'poimportsucc';
@unlink($filepath);
header("Location:" . SITE_URL . "importpurchaseorders/{$var_msg}");
exit;
}
$enc = $_POST['enctyp'];
// $enc = $encPO;
//if($enc == 'y')
//{
$opf = $orgprefObj->getDetails('*', " AND iOrganizationID={$curORGID} ");
if ($opf[0]['eSecureImportPO'] == 'Yes') {
$enc = 'y';
}
$encKey = $opf[0]['vEncryptionKey'];
$encAlgo = $opf[0]['eCryptAlgo'];
$emailArr = $orgUsrObj->getPermittedUsers($prv_dtls[0]['iOrganizationID'], "{$csts}%", '', 'vRFQ2AwardPermits', " AND ou.eEmailNotification='Yes' AND ou.eStatus='Active' ");
$body_arr = array("#NAME#", "#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, $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, $MAIL_FOOTER, SITE_URL);
$sendMail->Send("RFQ2 Award Accepted", "Member", $email, $body_arr, $post_arr);
}
}
//
if ($prv_dtls[0]['eFrom'] == "Invoice") {
$ress = $invOrdObj->updateData(array('eRfq2Awarded' => 'Yes'), " iInvoiceID=" . $prv_dtls[0]['iInvoiceID'] . " ");
} else {
if ($prv_dtls[0]['eFrom'] == "PO") {
$ress = $purOrdObj->updateData(array('eRfq2Awarded' => 'Yes'), " iPurchaseOrderID=" . $prv_dtls[0]['iPurchaseOrderID'] . " ");
if ($prv_dtls[0]['iPurchaseOrderID'] != "0" && $prv_dtls[0]['iPurchaseOrderID'] != "") {
$inv_det = $invOrdObj->getDetails('*', " AND iPurchaseOrderID = '" . $prv_dtls[0]['iPurchaseOrderID'] . "' ");
$rfq2_dets = $rfq2Obj->getDetails('*', " AND iInvoiceID = '" . $inv_det[0]['iInvoiceID'] . "' ");
if (count($rfq2_dets) > 0) {
$rfq2_dtls['fPOAwardAdvace'] = $prv_dtls[0]['fBidAdvanceTotal'];
$rfq2_dtls['fPOAwardPrice'] = $prv_dtls[0]['fBidPriceTotal'];
$rfq2_dtls['fPOAwardAmount'] = $prv_dtls[0]['fBidAmount'];
$ress = $rfq2Obj->updateData($rfq2_dtls, " iRFQ2Id=" . $prv_dtls[0]['iRFQ2Id'] . " ");
}
}
}
}
}
}
}
