$elid = PostVar('elid');
$elnm = PostVar('elnm');
$ocf = PostVar('ocf');
$ext = stripcslashes(PostVar('ext'));
$dflt = stripcslashes(PostVar('dflt'));
if (!isset($invOrdObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.InvoiceOrderHeading.php";
$invOrdObj = new InvoiceOrderHeading();
}
if (!isset($purOrdObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.PurchaseOrderHeading.php";
$purOrdObj = new PurchaseOrderHeading();
}
$orgas = "";
if ($eType == "Invoice") {
$invdtls = $invOrdObj->getDetails('iBuyerOrganizationID,iSupplierOrganizationID', " AND iInvoiceID={$iInvoiceID} ");
} else {
if ($eType == "PO") {
$invdtls = $purOrdObj->getDetails('iBuyerOrganizationID,iSupplierOrganizationID', " AND iPurchaseOrderID={$iPurchaseOrderID} ");
}
}
if ($invdtls[0]['iBuyerOrganizationID'] == $curORGID) {
$orgas = "Buyer";
} else {
if ($invdtls[0]['iSupplierOrganizationID'] == $curORGID) {
$orgas = "Supplier";
}
}
$orgas = trim($orgas) != '' ? $orgas : $uorg_type;
$dtls = array();
if ($curORGID > 0 && $orgas != '') {
$phoneData = @explode("-", $podtls[0][$field]);
if (count($phoneData) == 1) {
$podtls[0][$field] = $phoneData[0];
} else {
$podtls[0][$field . 'Code'] = $phoneData[0];
$podtls[0][$field] = $phoneData[1];
}
}
phoneCode('vBillToContactTelephone');
phoneCode('vShipToContactTelephone');
# Invoice Code DropDownBox Data [START]
$stsdtls = $statusmasterObj->getDetails('*', " AND vStatus_en='Accepted' AND eFor='Invoice' ");
$sid = $sts = $stsdtls[0]['iStatusID'];
$where = " AND iStatusID={$sts} ";
$where .= " AND iBuyerOrganizationID={$curORGID} ";
$invoiceCodeData = $invOrdObj->getDetails("vInvoiceCode as vTitle,iInvoiceID as Id", $where);
# Invoice Code DropDownBox Data [END]
# PO Code DropDownBox Data [START]
//$stsdtls = $statusmasterObj->getDetails('*'," AND vStatus_en='Accepted' AND eFor='PO' ");
//$sts = $stsdtls[0]['iStatusID'];
//$where = " AND iStatusID=$sts ";
$where = " AND iBuyerOrganizationID={$curORGID} ";
$POCodeData = $pohObj->getDetails("vPOCode as vTitle,iPurchaseOrderID as Id", $where);
# PO Code DropDownBox Data [END]
// prints($podtls);exit;
$smarty->assign('poad', $poad);
$smarty->assign('podtls', $podtls);
$smarty->assign('asocdtls', $asocdtls);
$smarty->assign('lineItemTax', $lineItemTax);
$smarty->assign('stateArr', $stateArr);
$smarty->assign('OrgCode', $OrgCode);
$nxtstatus = $isusts[0]; // $acptsts[0]; // $isusts[0];
} */
}
}
}
// prints($nxtstatus); exit;
// echo $permitted; exit;
//prints($poData);
if ($poData['iModifiedByID'] == $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'] && $poData['eDelete'] == 'Yes') {
$nxtstatus['vStatusMsg'] = $smarty->get_template_vars('MSG_OTHER_VERIFICATION_NEED');
}
//prints($poData);
$crt_inv = '';
if ($poData['iStatusID'] == $acptsts[0]['iStatusID'] && (trim($poData['iInvoiceID']) < 1 || trim($poData['iInvoiceID']) == '') && $var_msg != 'pop') {
if ($curORGID == $poData['iSupplierOrganizationID']) {
$inv = $iohObj->getDetails('iInvoiceID', " AND iPurchaseOrderID={$iPurchaseOrderID} ");
if (count($inv) == 0) {
$crt_inv = 'yes';
}
}
// echo "hi"; exit;
}
$invstat = '';
if ($poData['iBuyerOrganizationID'] == $curORGID) {
if ($isusts[0]['iStatusID'] == $poData['iStatusID'] && (trim($poData['iInvoiceID']) == '' || trim($poData['iInvoiceID']) < 1)) {
// $invstat = 'ureview';
} else {
// if(trim($poData['iInvoiceID'])>0)
$rlinv = $iohObj->getDetails('iStatusID', " AND iPurchaseOrderID={$iPurchaseOrderID} ", " iInvoiceID DESC ");
if (isset($rlinv) && count($rlinv) > 0) {
if ($rlinv[0]['iStatusID'] == 0 && isset($rlinv[0]['iStatusID'])) {
$wh = "AND iOrganizationID = {$curORGID}";
}
$usercary = array("ID" => "promptuser_id", "Name" => "promptuser_id", "Type" => "Query", "tableName" => PRJ_DB_PREFIX . "_organization_user", "fieldId" => "iUserID", "fieldName" => "vUserName", "extVal" => '', "selectedVal" => '', "width" => '230px', "height" => '', "onchange" => '', "selectText" => "--- " . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_USER') . " ---", "where" => " eStatus = 'Active' {$wh} ", "multiple_select" => "", "orderby" => '', "extra" => "title='" . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_USER') . "'", "validationmsg" => "", "class" => "required");
$user_combo = $gdbobj->DynamicDropDown($usercary);
$user_combo = str_replace('"', '\\"', $user_combo);
$user_combo = "<span class='puser' style='display:inline-block;'>" . $user_combo . "</span><span style='float:right; padding-right:70px;'>" . $smarty->get_template_vars('LBL_FILTER_LIST_BY') . " : <input type='text' name='usrfilter' id='usrfilter' style='width:100px;' /></span>";
$shuc = '';
} else {
$user_combo = "<input type='text' name='promptuser_id' id='promptuser_id' class='required' value='" . $sess_id . "' />";
}
//
if ($sess_usertype_short != 'SM') {
$wh = "(iSupplierOrganizationID = {$curORGID} OR iBuyerOrganizationID = {$curORGID})";
$invcary = array("ID" => "promptinvoice_id", "Name" => "promptinvoice_id", "Type" => "Query", "tableName" => PRJ_DB_PREFIX . "_inovice_order_heading", "fieldId" => "iInvoiceID", "fieldName" => "vInvSupplierCode", "extVal" => '', "selectedVal" => '', "width" => '230px', "height" => '', "onchange" => '', "selectText" => "--- " . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_INVOICE') . " ---", "where" => " {$wh} ", "multiple_select" => "", "orderby" => '', "extra" => "title='" . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_INVOICE') . "'", "validationmsg" => "", "class" => "required");
if ($parameter == "inv") {
$res = $invoiceObj->getDetails('iInvoiceID,vInvSupplierCode', "and iInvoiceID={$iID} AND (iSupplierOrganizationID = {$curORGID} OR iBuyerOrganizationID = {$curORGID})");
$inv_combo = $res[0]['vInvSupplierCode'];
$inv_combo = "<span class='pinv' style='display:inline-block;'>" . $inv_combo . "</span><input type='hidden' name='promptinvoice_id' id='promptinvoice_id' value='" . $res[0]['iInvoiceID'] . "'>";
} else {
$inv_combo = $gdbobj->DynamicDropDown($invcary);
$inv_combo = str_replace('"', '\\"', $inv_combo);
$inv_combo = "<span class='pinv' style='display:inline-block;'>" . $inv_combo . "</span><span style='float:right; padding-right:70px;'>" . $smarty->get_template_vars('LBL_FILTER_LIST_BY') . " : <input type='text' name='invfilter' id='invfilter' style='width:100px;' /></span>";
}
}
//
if ($sess_usertype_short != 'SM') {
$wh = "(iSupplierOrganizationID = {$curORGID} OR iBuyerOrganizationID = {$curORGID})";
$pocary = array("ID" => "promptpo_id", "Name" => "promptpo_id", "Type" => "Query", "tableName" => PRJ_DB_PREFIX . "_purchase_order_heading", "fieldId" => "iPurchaseOrderID", "fieldName" => "vPoBuyerCode", "extVal" => '', "selectedVal" => '', "width" => '230px', "height" => '', "onchange" => '', "selectText" => "--- " . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_PURCHASE_ORDER') . " ---", "where" => " {$wh} ", "multiple_select" => "", "orderby" => '', "extra" => "title='" . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_PURCHASE_ORDER') . "'", "validationmsg" => "", "class" => "required");
if ($parameter == "po") {
$res = $pursesordObj->getDetails('iPurchaseOrderID,vPoBuyerCode', "and iPurchaseOrderID={$iID} AND (iSupplierOrganizationID = {$curORGID} OR iBuyerOrganizationID = {$curORGID})");
$po_combo = $res[0]['vPoBuyerCode'];
if($sess_usertype == 'securitymanager')
$where=" AND bom.iASMID='".$sess_id."'";
else
$where = " AND bom.iOrganizationID = '".$sess_id."'";
*/
$where = " AND iStatusID={$sts} ";
if ($key != '' && $htmlTag == '') {
$where .= ' AND vInvoiceCode LIKE "%' . $key . '%" ';
}
// echo $curORGID; exit;
//if($iOrganizationID != '')
//{
$where .= " AND iBuyerOrganizationID={$curORGID} ";
//}
// echo $where; exit;
$res = $iohObj->getDetails("vInvoiceCode as vTitle,iInvoiceID as Id", $where);
// prints($res);exit;
unset($res['tot']);
$html = '';
if (count($res) > 0 && is_array($res)) {
$i = 0;
if ($htmlTag == "option") {
$html = "<option value=''>---" . $smarty->get_template_vars('LBL_SELECT') . " " . $smarty->get_template_vars('LBL_PO') . "---</option>";
}
foreach ($res as $arr) {
if ($htmlTag == 'option') {
if ($val == $arr['Id']) {
$selected = "selected";
} else {
$selected = "";
}
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'] . " ");
}
}
}
}
}
}
}
} else {
$msg = 'rver';
