// echo $opf[0]['vOrderAcceptanceLevel']; exit;
// prints($orglvl); exit;
//prints($urights); exit;
$smarty->assign("urights", $urights);
$smarty->assign("orglvl", $orglvl);
$userStatus = $stMstrObj->getDetails('iStatusID', "", " iStatusId ASC ");
// prints($userStatus); exit;
for ($i = 0; $i < count($userStatus); $i++) {
$usts[] = $userStatus[$i]['iStatusID'];
}
if (is_array($usts) && count($usts) > 0) {
$userStatus = @implode(',', $usts);
} else {
$userStatus = "";
}
$poisu = $statusmasterObj->getDetails('iStatusID', " AND eFor='PO' AND vStatus_en='Issued' ");
$poisu = $poisu[0]['iStatusID'];
$poapt = $statusmasterObj->getDetails('iStatusID', " AND eFor='PO' AND vStatus_en='Accepted' ");
$poapt = $poapt[0]['iStatusID'];
$invisu = $statusmasterObj->getDetails('iStatusID', " AND eFor='Invoice' AND vStatus_en='Issued' ");
$invisu = $invisu[0]['iStatusID'];
$invapt = $statusmasterObj->getDetails('iStatusID', " AND eFor='Invoice' AND vStatus_en='Accepted' ");
$invapt = $invapt[0]['iStatusID'];
$wh_po = '';
$wh_inv = '';
if ($orgtype != 'Buyer') {
$wh_po = " OR IF(bsm.iStatusID={$poisu} OR bsm.iStatusID={$poapt}, (iSupplierOrganizationID={$curORGID}),0 ) ";
}
if ($orgtype != 'Supplier') {
$wh_inv = " OR IF(bsm.iStatusID={$invisu} OR bsm.iStatusID={$invapt}, (iBuyerOrganizationID={$curORGID}),0 ) ";
}
$iASMID = PostVar("iASMID");
$view = PostVar("view");
if ($iOrganizationID != '') {
//$orgObj->setiOrganizationID($iOrganizationID);
$orgdtls = $orgObj->select($iOrganizationID);
$arr = $orgprefObj->getDetails('*', " AND iOrganizationID={$iOrganizationID}");
if ($arr[0]['iAdditionalInfoID'] != '') {
$view = 'edit';
} else {
$view = 'add';
}
}
//------------------------DEFALT VALUES OF PURCHASE ORDER -----------------------------------------//
if ($orgdtls[0]['eOrganizationType'] != 'Supplier') {
$where = ' AND eFor = "PO" AND eType = "Default" AND eStatus = "Active"';
$postatus = $stMstrObj->getDetails('*', $where);
foreach ($postatus as $k => $v) {
$poarr[] = $v['iStatusID'];
}
$postatus = @implode(',', $poarr);
}
//------------------------DEFALT VALUES OF PURCHASE ORDER -----------------------------------------//
if ($orgdtls[0]['eOrganizationType'] != 'Buyer') {
$where = ' AND eFor = "Invoice" AND eType = "Default" AND eStatus = "Active"';
$invstatus = $stMstrObj->getDetails('*', $where);
foreach ($invstatus as $k => $v) {
$invarr[] = $v['iStatusID'];
}
$invstatus = @implode(',', $invarr);
}
//echo $postatus.'===';//exit;
$smarty->assign('dtls', $dtls);
$smarty->assign('orgprf', $orgprf);
$smarty->assign('rfq2b2', $rfq2b2);
$smarty->assign('rfq2files', $rfq2files);
$smarty->assign('rfq2prdt', $rfq2prdt);
$smarty->assign('rfq2pb2asoc', $rfq2pb2asoc);
} else {
if ($irfq2id > 0 && $msg == 'i') {
$invoiceid = $irfq2id;
$irfq2id = 0;
}
if (!isset($statusmasterObj)) {
include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php";
$statusmasterObj = new StatusMaster();
}
$acptsts = $statusmasterObj->getDetails('*', " AND eFor='Invoice' AND vStatus_en='Accepted' ");
$acptsts = $acptsts[0]['iStatusID'];
$invCombAry = array("ID" => "iInvoiceID", "Name" => "Data[iInvoiceID]", "Type" => "Query", "tableName" => "" . PRJ_DB_PREFIX . "_inovice_order_heading", "fieldId" => "iInvoiceID", "fieldName" => "vInvSupplierCode", "extVal" => '', "selectedVal" => "{$invoiceid}", "width" => '', "height" => '', "onchange" => '', "selectText" => "--- " . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_INVOICE') . " ---", "where" => " iStatusID='{$acptsts}' AND iaStatusID='{$acptsts}' AND (iBuyerOrganizationID={$curORGID} OR iSupplierOrganizationID={$curORGID}) AND eRfq2Awarded='No' AND iInvoiceID NOT IN (SELECT iInvoiceID FROM " . PRJ_DB_PREFIX . "_rfq2_master WHERE eDelete!='Verified' AND eAuctionStatus!='Cancelled') OR iInvoiceID={$invoiceid} ", "multiple_select" => "", "orderby" => 'vInvSupplierCode', "validationmsg" => '', "extra" => " title='" . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_INVOICE') . "' ", "class" => "form-control");
$invoices = $gdbobj->DynamicDropDown($invCombAry);
$smarty->assign('invoices', $invoices);
//
$pacptsts = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Accepted' ");
$pacptsts = $pacptsts[0]['iStatusID'];
$poCombAry = array("ID" => "iPurchaseOrderID", "Name" => "Data[iPurchaseOrderID]", "Type" => "Query", "tableName" => "" . PRJ_DB_PREFIX . "_purchase_order_heading", "fieldId" => "iPurchaseOrderID", "fieldName" => "vPoBuyerCode", "extVal" => '', "selectedVal" => $dtls[0]['iPurchaseOrderID'], "width" => '', "height" => '', "onchange" => '', "selectText" => "--- " . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_PURCHASE_ORDER') . " ---", "where" => " iStatusID='{$pacptsts}' AND iaStatusID='{$pacptsts}' AND (iBuyerOrganizationID={$curORGID} OR iSupplierOrganizationID={$curORGID}) AND eRfq2Awarded='No' AND iPurchaseOrderID NOT IN (SELECT iPurchaseOrderID FROM " . PRJ_DB_PREFIX . "_rfq2_master WHERE eFrom='PO' AND eDelete!='Verified' AND eAuctionStatus!='Cancelled') AND (Select COUNT(iInvoiceID) from " . PRJ_DB_PREFIX . "_inovice_order_heading where iPurchaseOrderID=" . PRJ_DB_PREFIX . "_purchase_order_heading.iPurchaseOrderID AND iStatusID='{$acptsts}' AND iaStatusID='{$acptsts}' AND (iBuyerOrganizationID={$curORGID} OR iSupplierOrganizationID={$curORGID}) {$invsc}) < 1 {$posc} ", "multiple_select" => "", "orderby" => 'vPoBuyerCode', "validationmsg" => '', "extra" => " title='" . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_PO') . "' ", "class" => "form-control");
$pos = $gdbobj->DynamicDropDown($poCombAry);
# pr($pos); exit;
$smarty->assign('pos', $pos);
//
}
if ($sess_usertype_short == 'OA') {
header("Location: " . SITE_URL_DUM . "rfq2view/{$irfq2id}");
} */
// $Data['iPurchaseOrderID'] = $_POST['iPurchaseOrderID'];
$Data['vBillToContactTelephone'] = $_POST['vBillToContactTelephoneCode'] . "-" . $Data['vBillToContactTelephone'];
$Data['dCashDiscountBaseline'] = $Data['dCashDiscountBaseline'] != '' ? calcGTzTime($Data['dCashDiscountBaseline'], 'Y-m-d') : '';
$Data['dNetPaymentdate'] = $Data['dNetPaymentdate'] != '' ? calcGTzTime($Data['dNetPaymentdate'], 'Y-m-d') : '';
// prints($Data); exit;
unset($Data['supplierID']);
if ($Data['eSaved'] != 'Yes') {
$Data['eSaved'] = 'No';
}
if ($view == '' || $view == 'add') {
### SERVER SIDE VALIDATION ####
include SITE_CLASS_GEN . "class.validation.php";
$validation = new Validation();
$RequiredFiledArr = array('iBuyerOrganizationID' => $smarty->get_template_vars('LBL_SELECT') . " " . $smarty->get_template_vars('LBL_BUYER') . " " . $smarty->get_template_vars('LBL_COMPANY'), 'vBuyerContactParty' => $smarty->get_template_vars('LBL_SELECT') . " " . $smarty->get_template_vars('LBL_BUYER') . " " . $smarty->get_template_vars('LBL_CONTACT_PARTY'), 'eLineItemTax' => $smarty->get_template_vars('LBL_ENTER') . " " . $smarty->get_template_vars('LBL_LINE_ITEM_TAX'), 'vBillToParty' => $smarty->get_template_vars('LBL_ENTER') . " " . $smarty->get_template_vars('LBL_BILL_TO') . " " . $smarty->get_template_vars('LBL_PARTY'), 'vBillToAddLine1' => $smarty->get_template_vars('LBL_ENTER') . " " . $smarty->get_template_vars('LBL_BILL_TO') . " " . $smarty->get_template_vars('LBL_ADDR_LINE') . "1", 'vBillToCity' => $smarty->get_template_vars('LBL_ENTER') . " " . $smarty->get_template_vars('LBL_BILL_TO') . " " . $smarty->get_template_vars('LBL_CITY'), 'vBillToCountry' => $smarty->get_template_vars('LBL_ENTER') . " " . $smarty->get_template_vars('LBL_BILL_TO') . " " . $smarty->get_template_vars('LBL_COUNTRY'), 'vBillToState' => $smarty->get_template_vars('LBL_ENTER') . " " . $smarty->get_template_vars('LBL_BILL_TO') . " " . $smarty->get_template_vars('LBL_STATE'), 'vBillToZipCode' => $smarty->get_template_vars('LBL_ENTER') . " " . $smarty->get_template_vars('LBL_BILL_TO') . " " . $smarty->get_template_vars('LBL_ZIP_CODE'), 'vBillToContactParty' => $smarty->get_template_vars('LBL_ENTER') . " " . $smarty->get_template_vars('LBL_BILL_TO') . " " . $smarty->get_template_vars('LBL_CONTACT_PARTY'), 'vBillToContactTelephoneCode' => $smarty->get_template_vars('LBL_ENTER') . " " . $smarty->get_template_vars('LBL_BILL_TO') . " " . $smarty->get_template_vars('LBL_CONTACT_TELEPHONE') . " " . $smarty->get_template_vars('LBL_CODE'), 'vBillToContactTelephone' => $smarty->get_template_vars('LBL_ENTER') . " " . $smarty->get_template_vars('LBL_BILL_TO') . " " . $smarty->get_template_vars('LBL_CONTACT_TELEPHONE'), 'vCurrency' => $smarty->get_template_vars('LBL_ENTER') . " " . $smarty->get_template_vars('LBL_CURRENCT'));
$stsdtls = $statusmasterObj->getDetails('*', " AND vStatus_en='Accepted' AND eFor='PO' ");
$sts = $stsdtls[0]['iStatusID'];
$where = " AND iStatusID={$sts} ";
$where .= " AND iSupplierOrganizationID={$curORGID} ";
$where .= " AND (Select count(iInvoiceID) from b2b_inovice_order_heading where iPurchaseOrderID=poh.iPurchaseOrderID)=0 ";
$POCodeData = $pohObj->getJoinTableInfo('', "poh.vPOCode as vTitle,poh.iPurchaseOrderID as Id", $where);
if (is_array($POCodeData) && count($POCodeData) > 0) {
// $RequiredFiledArr['iPurchaseOrderID'] = $smarty->get_template_vars('LBL_SELECT')." ".$smarty->get_template_vars('LBL_PURCHASE_ORDER');
}
$resArr = $validation->isEmpty($RequiredFiledArr);
$numdt = array();
//$numdt['iOpeningUnit'] = $Data['iOpeningUnit'];
//$nvldmsg['iOpeningUnit'] = $smarty->get_template_vars('LBL_PRE_PAYMENT')." ".$smarty->get_template_vars('LBL_MUST_BE_NUMERIC');
$numdt['fVAT'] = $Data['fVAT'];
$nvldmsg['fVAT'] = $smarty->get_template_vars('LBL_VAT') . " " . $smarty->get_template_vars('LBL_MUST_BE_NUMERIC');
$numdt['fPOTotal'] = $Data['fPOTotal'];
$invoiceorderfile = $invoiceorderObj->getdetails('*', "AND iInvoiceID='" . $bdtls[0]['iInvoiceID'] . "'");
$invoiceorderfilearr = array();
if (is_array($invoiceorderfile) && count($invoiceorderfile) > 0) {
for ($l = 0; $l < count($invoiceorderfile); $l++) {
if (is_file($cfgimg['INV']['docs']['path'] . $invoiceorderfile[0]['iInvoiceID'] . '/' . $invoiceorderfile[0]['vFile'])) {
$invoicefile = $invoiceorderfile[$l]['vFile'];
$no = strpos($invoicefile, "_");
$invoicefile = substr($invoicefile, $no + 1);
$no = strpos($invoicefile, "_");
$invoicefile = substr($invoicefile, $no + 1);
$invoiceorderfilearr[$l]['filename'] = $invoicefile;
$invoiceorderfilearr[$l]['fileurl'] = $cfgimg['INV']['docs']['url'] . $invoiceorderfile[0]['iInvoiceID'] . '/' . $invoiceorderfile[$l]['vFile'];
}
}
}
$rsts = $statusmasterObj->getDetails('*', " AND vForAuction LIKE '%RFQ2 Award,%' AND vStatus_en='Rejected' ");
$rsts = $rsts[0]['iStatusID'];
if (isset($bdtls[0]['iRFQ2Id']) && $bdtls[0]['iRFQ2Id'] > 0) {
// $rfq2_dtls = $rfq2fObj->select($bdtls[0]['iRFQ2Id']);
//prints($invoiceorderfilearr);exit;
//$rfq2file = $rfq2fObj->getDetails('*'," AND iRFQ2Id='".$bdtls[0]['iRFQ2Id']."'");
$rfq2file = $rfq2fObj->getDetails('*', " AND iRFQ2Id='" . $bdtls[0]['iRFQ2Id'] . "'");
$cfgimg['rfq2']['docs']['path'] . $dtls[0]['iRFQ2Id'] . '/' . $rfq2file[0]['vFile'];
$rfq2files = array();
if (is_array($rfq2file) && count($rfq2file) > 0) {
for ($l = 0; $l < count($rfq2file); $l++) {
if (is_file($cfgimg['rfq2']['docs']['path'] . $rfq2file[0]['iRFQ2Id'] . '/' . $rfq2file[0]['vFile'])) {
$bidfiles = $rfq2file[$l]['vFile'];
$no = strpos($bidfiles, "_", "_");
$bidfiles = substr($bidfiles, $no + 1);
$no = strpos($bidfiles, "_", "_");
} else {
$invacptStatus = array();
}
if (trim($res[0]['vInvoiceStatusLevel']) != '') {
$invoiceStatus = @explode(',', $res[0]['vInvoiceStatusLevel']);
} else {
$invoiceStatus = array();
}
if (trim($res[0]['vOrderAcceptanceLevel']) != '') {
$ordacptStatus = @explode(',', $res[0]['vOrderAcceptanceLevel']);
} else {
$ordacptStatus = array();
}
// prints($ordacptStatus); exit;
//
$rfq2awardsts = $orgStaObj->getDetails('vStatus_' . LANG . ' as title,vStatusMsg_' . LANG . ',iStatusID as Id,eFor,eType,vStatusMsg_en as msg,vStatus_en as status', " AND vStatus_en NOT IN ('Create','Verify','Accepted','Rejected') AND eType='Optional' AND vForAuction LIKE '%RFQ2 Award,%' ", '', '');
// prints($rfq2awardacceptsts); exit;
$codsts = $orgStaObj->getDetails('vStatus_' . LANG . ' as title,vStatusMsg_' . LANG . ',iStatusID as Id,eFor,eType,vStatusMsg_en as msg,vStatus_en as status', " AND vStatus_en='Create' AND vForAuction!='' ", '', '');
$vodsts = $orgStaObj->getDetails('vStatus_' . LANG . ' as title,vStatusMsg_' . LANG . ',iStatusID as Id,eFor,eType,vStatusMsg_en as msg,vStatus_en as status', " AND vStatus_en='Verify' AND vForAuction!='' ", '', '');
$aodsts = $orgStaObj->getDetails('vStatus_' . LANG . ' as title,vStatusMsg_' . LANG . ',iStatusID as Id,eFor,eType,vStatusMsg_en as msg,vStatus_en as status', " AND vStatus_en='Accepted' AND vForAuction!='' ", '', '');
$rodsts = $orgStaObj->getDetails('vStatus_' . LANG . ' as title,vStatusMsg_' . LANG . ',iStatusID as Id,eFor,eType,vStatusMsg_en as msg,vStatus_en as status', " AND vStatus_en='Rejected' AND vForAuction!='' ", '', '');
//
$org_rfq2AwardStatus = array();
if (trim($ores[0]['vRFQ2AwardStatusLevel']) != '') {
$org_rfq2AwardStatus = @explode(',', $ores[0]['vRFQ2AwardStatusLevel']);
}
//
$urfq2 = array();
$urfq2awrd = array();
if (is_array($grpdt) && count($grpdt) > 0) {
if (trim($grpdt[0]['vRFQ2Permits']) != '') {
if ($arr[0]['eModifiedBy'] == 'OA') {
if ($arr[0]['iModifiedByID'] != $sess_id) {
$verify = 'yes';
} else {
$verify = 'no';
}
} else {
$verify = 'yes';
}
break;
}
}
}
}
$where = " AND eFor='Invoice' AND eStatus='Active' AND vStatus_en NOT IN ('Accepted','Issue','Verify') ";
$invarr = $stMstrObj->getDetails('*', $where);
$selinvarr = @explode(',', $arr[0]['vInvoiceStatusLevel']);
$where = " AND eFor='PO' AND eStatus='Active' AND vStatus_en NOT IN ('Accepted','Issue','Verify') ";
$POarr = $stMstrObj->getDetails('*', $where);
$selPOarr = @explode(',', $arr[0]['vOrderStatusLevel']);
$acptInvArr = @explode(',', $arr[0]['vInvoiceAcceptanceLevel']);
$acptOrdArr = @explode(',', $arr[0]['vOrderAcceptanceLevel']);
if ($arr[0]['eStatus'] == 'Need to Verify') {
if ($arr[0]['iCreatedBy'] == $sess_id) {
$msg = $smarty->get_template_vars('MSG_OTHER_VERIFICATION_NEED');
}
} else {
switch ($arr[0]['eStatus']) {
case "Modified":
if ($arr[0]['iModifiedByID'] == $sess_id) {
$msg = $smarty->get_template_vars('MSG_OTHER_VERIFICATION_NEED');
// prints($resArr);exit;
if ($resArr) {
$_SESSION['Data'] = $Data;
header("Location:" . $_SERVER['HTTP_REFERER'] . "");
exit;
}
}
if ($Data['iUserID'] != '') {
// prints($_POST); exit;
// Prints($_SESSION);exit;
//$Data['iUserID'] = $_POST['iUserID'];
//
$Data['eInvFPO'] = $_POST['eInvFPO'];
//
## INSERT PERMISSION
$po_deflvl_ary = $statusmasterObj->getDetails('iStatusID', " AND eType='Default' AND eFor='PO' ", ' iDisplayOrder ASC ');
$inv_deflvl_ary = $statusmasterObj->getDetails('iStatusID', " AND eType='Default' AND eFor='Invoice' ", ' iDisplayOrder ASC ');
$stsdtls = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Issued' ");
$poisusts = $stsdtls[0]['iStatusID'];
$stsdtls = $statusmasterObj->getDetails('*', " AND eFor='Invoice' AND vStatus_en='Issued' ");
$invisusts = $stsdtls[0]['iStatusID'];
$stsdtls = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Accepted' ");
$poacptsts = $stsdtls[0]['iStatusID'];
$stsdtls = $statusmasterObj->getDetails('*', " AND eFor='Invoice' AND vStatus_en='Accepted' ");
$invacptsts = $stsdtls[0]['iStatusID'];
$stsdtls = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Create' ");
$pocrtsts = $stsdtls[0]['iStatusID'];
$stsdtls = $statusmasterObj->getDetails('*', " AND eFor='Invoice' AND vStatus_en='Create' ");
$invcrtsts = $stsdtls[0]['iStatusID'];
$stsdtls = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Rejected' ");
$porjsts = $stsdtls[0]['iStatusID'];
if (trim(strtolower($view)) == 'award' || trim(strtolower($view)) == 'save') {
$dtls = $r2bdObj->select($iBidId);
if (is_array($dtls) && count($dtls) > 0 && isset($dtls[0]['iBidId']) && $dtls[0]['iBidId'] > 0) {
$data['iBidId'] = $iBidId;
$data['iRFQ2Id'] = $dtls[0]['iRFQ2Id'];
$data['eOrgCreatedBy'] = $orgtyp = $rfq2Obj->getR2InvOrgType($curORGID, $dtls[0]['iRFQ2Id']);
$data['iCreatedById'] = $sess_id;
$data['iModifiedById'] = $sess_id;
$data['dADate'] = calcGTzTime(date("Y-m-d H:i:s"), 'Y-m-d H:i:s');
if (trim(strtolower($view)) == 'save') {
$data['eSaved'] = 'Yes';
} else {
$data['eSaved'] = 'No';
}
$data['eDelete'] = 'No';
$csts = $statusmasterObj->getDetails('*', " AND vForAuction LIKE '%RFQ2 Award,%' AND vStatus_en='Create' ");
$vsts = $statusmasterObj->getDetails('*', " AND vForAuction LIKE '%RFQ2 Award,%' AND vStatus_en='Verify' ");
$asts = $statusmasterObj->getDetails('*', " AND vForAuction LIKE '%RFQ2 Award,%' AND vStatus_en='Auth3' ");
$orglsts = $orgprefObj->getLastOrgPrefFor($curORGID, "vRFQ2AwardStatusLevel", $asts[0]['iStatusID']);
$vreq = $orgprefObj->getDetails('eRFQ2AwardVerifyReq', " AND iOrganizationID={$orgid} ");
//pr($vreq); exit;
if (isset($vreq[0]['eRFQ2AwardVerifyReq']) && $vreq[0]['eRFQ2AwardVerifyReq'] == 'Yes' || $data['eSaved'] == "Yes") {
// || $orglsts>$vsts[0]['iStatusID']
$data['iStatusID'] = $csts[0]['iStatusID'];
} else {
$data['iStatusID'] = $vsts[0]['iStatusID'];
}
//exit;
$data['iaStatusID'] = '0';
$data['vAwardNum'] = $r2awObj->getUniqueCode();
//pr($data); exit;
$Data['eStatus'] = 'Need to Verify';
/*else
$Data['eStatus'] = 'Active';*/
### CHECK MULTIPLE ADMIN AVAILABLE FOR THIS ORGANIZATION OR NOT
/*$chkMulAdmin = $orgObj->ChkMultipleOrgAdmin();
if($chkMulAdmin == '1'){
$Data['eStatus'] = 'Active';
}else{
// $Data['eStatus'] = $data['eStatus'];
}*/
## INSERT PERMISSION
$InvoicePermission = array();
$OrderPermission = array();
$InvoiceAcceptance = array();
$OrderAcceptance = array();
$invdflts = $statusmasterObj->getDetails('*', " AND eFor='Invoice' AND eType='Default' ");
$podflts = $statusmasterObj->getDetails('*', " AND eFor='PO' AND eType='Default' ");
$stsdtls = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Issued' ");
$poisusts = $stsdtls[0]['iStatusID'];
$stsdtls = $statusmasterObj->getDetails('*', " AND eFor='Invoice' AND vStatus_en='Issued' ");
$invisusts = $stsdtls[0]['iStatusID'];
$stsdtls = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Accepted' ");
$poacptsts = $stsdtls[0]['iStatusID'];
$stsdtls = $statusmasterObj->getDetails('*', " AND eFor='Invoice' AND vStatus_en='Accepted' ");
$invacptsts = $stsdtls[0]['iStatusID'];
$stsdtls = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Create' ");
$pocrtsts = $stsdtls[0]['iStatusID'];
$stsdtls = $statusmasterObj->getDetails('*', " AND eFor='Invoice' AND vStatus_en='Create' ");
$invcrtsts = $stsdtls[0]['iStatusID'];
$invdflts_ary = array();
$podflts_ary = array();
}
// prints($Data); exit;
if ($enc == 'y') {
foreach ($Data as $k => $v) {
$Data[$k] = $encobj->mdecrypt($v);
}
}
//
for ($l = 0; $l < count($pref_ary); $l++) {
$Data_pref[$pref_ary[$l]] = $Data[$pref_ary[$l]];
unset($Data[$pref_ary[$l]]);
}
// prints($Data); exit;
$Data['dCreateDate'] = date('Y-m-d H:i:s');
$Data['vFromIP'] = $_SERVER['REMOTE_ADDR'];
$stsdtls = $statusmasterObj->getDetails('iStatusID', " AND eFor='PO' AND vStatus_en='Create' ");
if ($reqVerification == 'Yes') {
$Data['iStatusID'] = 0;
} else {
$Data['iStatusID'] = $stsdtls[0]['iStatusID'];
}
//$Data['iStatusID'] = $stsdtls[0]['iStatusID'];
$Data['iBuyerOrganizationID'] = $curORGID;
$Data['iBuyerID'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
$Data['vBuyerContactName'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_NAME'];
$buyerOrgDtls = $orgObj->select($curORGID);
$Data['vBuyerCode'] = $buyerOrgDtls[0]['vOrganizationCode'];
$Data['vBuyerCompanyName'] = $buyerOrgDtls[0]['vCompanyName'];
$Data['vBuyerContactTelephone'] = $buyerOrgDtls[0]['vPhone'];
$Data['vBuyerContactEmail'] = $buyerOrgDtls[0]['vEmail'];
$vItmCode = $pohObj->getUniqueCode();
include_once SITE_CLASS_APPLICATION . "user/class.OrganizationUser.php";
$orgUserObj = new OrganizationUser();
}
if (!isset($r2bdobj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Bids.php";
$r2bdobj = new Rfq2Bids();
}
if (!isset($rfq2awardObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Award.php";
$rfq2awardObj = new Rfq2Award();
}
if (!isset($statusmasterObj)) {
include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php";
$statusmasterObj = new StatusMaster();
}
$sts = $statusmasterObj->getDetails(" DISTINCT iStatusID, vStatus_en, vStatus_fr, vStatus_" . LANG . " as vStatus ", " AND vForAuction LIKE '%RFQ2%'");
$smarty->assign("sts", $sts);
// --- Statistics --------------------------------------------------------------------------------------------
$where = " iBuyerOrganizationID={$orgid} ";
$assocstats = $orgObj->getOADashboardAssocStats(PRJ_DB_PREFIX . "_organization_association", $where);
$where = " iOrganizationID={$orgid} ";
$groupstats = $orgObj->getOADashboardGrpStats(PRJ_DB_PREFIX . "_organization_group", $where);
$orguserstats = $orgUserObj->getOADashboardUsrStats(PRJ_DB_PREFIX . "_organization_user", $where . " AND eUserType='User' ");
$orgadminstats = $orgUserObj->getOADashboardUsrStats(PRJ_DB_PREFIX . "_organization_user", $where . " AND eUserType='Admin' ");
$where = " iUserID IN (Select iUserID from " . PRJ_DB_PREFIX . "_organization_user where {$where} AND eUserType='User' ) ";
$userrightsstats = $orgUserObj->getOADashboardUsrStats(PRJ_DB_PREFIX . "_organization_user_permission", $where);
// prints($userrightsstats); exit;
$where = " AND iOrganizationID={$orgid}";
//$where = "";
//prints($assocstats); exit;
$smarty->assign("assocstats", $assocstats);
include_once SITE_CLASS_APPLICATION . "user/class.PurchaseOrderHeading.php";
$pohObj = new PurchaseOrderHeading();
}
if (!isset($statusmasterObj)) {
include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php";
$statusmasterObj = new StatusMaster();
}
$key = $_GET['q'];
$type = $_GET['type'];
$iId = $_GET['iId'];
$name = trim($_GET['name']);
$iOrganizationID = trim($_GET['icompid']);
$htmlTag = $_GET['htmltag'];
$val = $_GET['val'];
// prints($_GET); exit;
$stsdtls = $statusmasterObj->getDetails('*', " AND vStatus_en='Accepted' AND eFor='PO' ");
$sts = $stsdtls[0]['iStatusID'];
// prints($stsdtls); exit;
/*
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 vPOCode LIKE "%' . $key . '%" ';
}
// echo $curORGID; exit;
//if($iOrganizationID != '')
//{
$poStatus = $iprvsts = $vsts;
$where .= " AND poh.iaStatusID={$vsts} ";
}
if (in_array($poStatus, $poacpt)) {
$where .= " AND poh.iaStatusID=" . $poStatus;
} else {
$where .= " AND poh.iaStatusID=''";
}
}
}
}
// $where .= " AND poh.iaStatusID=".$poStatus;
// echo $where; exit;
$poDetail = $statusmasterObj->getStatusDetails($poStatus, 'PO');
if ($poDetail[0]['vStatus'] == 'Issuance') {
$iAuthIDs = $statusmasterObj->getDetails("group_concat(iStatusID) as authIDs", "AND vStatus_en like('%auth%') and efor='PO'");
// print_r($iAuthIDs);
$iAuthIDs = $iAuthIDs[0]['authIDs'];
if ($iAuthIDs != '') {
$where .= " OR sm.iStatusID in(" . $iAuthIDs . ")";
}
}
}
//print "A".$poUserStatusIds;
//print $poUserStatusIds;
if ($orgtype == 'Supplier' && ($poStatus == $isusts || $poStatus == $acptsts || $poStatus == '' && $orgtype == 'Supplier')) {
if (trim($poStatus) == '') {
// $where = " AND poh.iSupplierOrganizationID=$curORGID AND poh.iStatusID IN ($isusts,$acptsts) ";
$where = " AND poh.iSupplierOrganizationID={$curORGID} AND poh.iaStatusID IN ({$poOrgAcptIds}) ";
} else {
if (is_numeric($poStatus) && $poStatus > 0 && in_array($poStatus, $poacpt)) {
} else {
$view = 'add';
if (isset($_SESSION['Data'])) {
$arr[0] = $_SESSION['Data'];
unset($_SESSION['Data']);
}
}
}
$arr[0]['eCreateMethodAllowedPO'] = isset($arr[0]['eCreateMethodAllowedPO']) ? $arr[0]['eCreateMethodAllowedPO'] : '';
$arr[0]['eReqVerification'] = isset($arr[0]['eReqVerification']) ? $arr[0]['eReqVerification'] : '';
$arr[0]['eCreateMethodAllowedInv'] = isset($arr[0]['eCreateMethodAllowedInv']) ? $arr[0]['eCreateMethodAllowedInv'] : '';
$crMethodPO = $gdbobj->getEnumSelect("" . PRJ_DB_PREFIX . "_organization_default_settings", "eCreateMethodAllowedPO", "Data[eCreateMethodAllowedPO]", "eCreateMethodAllowedPO", "", "" . $arr[0]['eCreateMethodAllowedPO'] . "", "class='required' style='width:170px;' title='Select Method Allowed'", "Select Method Allowed", "---Select PO Create Method----");
$crMethodINV = $gdbobj->getEnumSelect("" . PRJ_DB_PREFIX . "_organization_default_settings", "eCreateMethodAllowedInv", "Data[eCreateMethodAllowedInv]", "eCreateMethodAllowedInv", "", "" . $arr[0]['eCreateMethodAllowedInv'] . "", "class='required' style='width:170px;' title='Select Method Allowed'", "Select Method Allowed", "---Select Invoice Create Method----");
$reqVerif = $gdbobj->getEnumSelect("" . PRJ_DB_PREFIX . "_organization_master", "eReqVerification", "Data[eReqVerification]", "eReqVerification", "", "" . $arr[0]['eReqVerification'] . "", "class='required' tabIndex='28' ", "", "");
$where = "AND eFor='Invoice' AND eType='Optional' AND eStatus='Active'";
$invarr = $stMstrObj->getDetails(' *, vStatus_en as status ', $where);
$selinvarr = @explode(',', $arr[0]['vInvoiceStatusLevel']);
$where = "AND eFor='PO' AND eType='Optional' AND eStatus='Active'";
$POarr = $stMstrObj->getDetails(' *, vStatus_en as status ', $where);
$selPOarr = @explode(',', $arr[0]['vOrderStatusLevel']);
$acptInvArr = @explode(',', $arr[0]['vInvoiceAcceptanceLevel']);
$acptOrdArr = @explode(',', $arr[0]['vOrderAcceptanceLevel']);
$lvls = array('Auth1', 'Auth2', 'Auth3');
// currency combo box
$csql = "Select DISTINCT vCode as vCurrency from " . PRJ_DB_PREFIX . "_currency_master where eStatus='Active' ";
$currency = $dbobj->MySqlSelect($csql);
//prints($currency); exit;
if (isset($arr[0]['vCurrency']) && trim($arr[0]['vCurrency']) != '') {
$arr[0]['vCurrency'] = @explode(',', $arr[0]['vCurrency']);
} else {
if (!isset($arr[0]['vCurrency']) || trim($arr[0]['vCurrency']) == '') {
// $generalobj->getPostForm($_POST,'rae',SITE_URL_DUM."b2rfq2view/".$Data['iRFQ2Id']);
header("Location: " . SITE_URL_DUM . "b2rfq2view/" . $Data['iRFQ2Id'] . "/rae");
exit;
}
$cvbd = $r2bdObj->chkTenderBidAmount($rfq2dtls[0]['eBidCriteria'], $Data['iRFQ2Id'], '0', $Data['fBidAdvanceTotal'], $Data['fBidPriceTotal'], $Data['fBidAmount'], $curORGID);
// pr($cvbd); exit;
}
if ($cvbd['b'] == 'n' || $cvbd['a'] == 'n' || $cvbd['p'] == 'n') {
// header("Location: ".SITE_URL_DUM."b2rfq2view/$Data['iRFQ2Id']/$vbd_msg");
$generalobj->getPostForm($_POST, $cvbd['msg'], SITE_URL_DUM . "b2rfq2view/" . $Data['iRFQ2Id']);
exit;
}
$Data['vBidNum'] = $r2bdObj->getUniqueCode('');
$orgprf = $orgprefObj->getDetails('*', " AND iOrganizationID=" . $curORGID);
if ($orgprf[0]['eRFQ2BidVerifyReq'] == 'Yes' || $Data['eSaved'] == 'Yes') {
$sts = $statusmasterObj->getDetails('iStatusID', " AND vForAuction LIKE '%RFQ2 Bid,%' AND vStatus_en='Create' ");
$Data['iStatusID'] = $sts[0]['iStatusID'];
$Data['eStatus'] = 'pending';
if ($Data['eSaved'] != 'Yes') {
$sub = "New RFQ2 Bid";
$typ = "Create";
$body = array("#CREATED_BY#", "#RFQ2CODE#", "#BIDNUM#", "#ADVANCE#", "#PRICE#", "#LINK#");
$body_arr = array("#NAME#", "#CREATED_BY#", "#RFQ2CODE#", "#BIDNUM#", "#ADVANCE#", "#PRICE#", "#LINK#", "#MAIL_FOOTER#", "#SITE_URL#");
}
} else {
$sts = $statusmasterObj->getDetails('iStatusID', " AND vForAuction LIKE '%RFQ2 Bid,%' AND vStatus_en='Verify' ");
$Data['iStatusID'] = $sts[0]['iStatusID'];
$Data['eStatus'] = 'current';
$sub = "New Bid For RFQ2";
$typ = "Create";
}
* @author Snehasis Mohapatra
*/
if (!isset($stMstrObj)) {
include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php";
$stMstrObj = new StatusMaster();
}
$gdbobj->getRequestVars();
$view = GetVar("view");
$iStatusID = GetVar("iStatusID");
$actionfile = GetVar("file");
if (count($_POST) > 0) {
$arr = array();
$arr[0] = $_POST;
} else {
if ($view == 'edit') {
$arr = $stMstrObj->getDetails("*", "AND iStatusID = '{$iStatusID}'");
$db_order = $stMstrObj->getDetails("count(*)", "");
$order = $db_order[0]['count(*)'];
//prints($arr);exit;
} else {
$view = "add";
$db_order = $stMstrObj->getDetails("count(*)", "");
$order = $db_order[0]['count(*)'] + 1;
//prints($order);exit;
}
}
$lang = $gdbobj->getLanguage();
?>
<form name="frmadd" id="frmadd" action="index.php?file=<?php
echo $actionfile;
?>
$d = $invLineObj->del(" AND vItemCode NOT IN ('{$lineitmCode}') AND iInvoiceID={$iInvoiceID} ");
$eSaved = $_POST['eSaved'];
if ($eSaved == 'Yes') {
$dtl['eSaved'] = $eSaved;
$wh_cn = "iInvoiceID={$iInvoiceID}";
$rs = $invOrdObj->updateData($dtl, $wh_cn);
}
}
if (isset($_SESSION['invadd'])) {
unset($_SESSION['invadd']);
}
if ($msg != 'raserr' && $msg != 'ruserr') {
if (is_array($cnitm) && count($cnitm) > 0) {
$msg = 'rus';
} else {
$msg = 'ras';
}
}
$_SESSION['SESS_' . PRJ_CONST_PREFIX . '_MSG'] = $msg;
$isusts = $statusmasterObj->getDetails('*', " AND eFor='Invoice' AND vStatus_en='Issued' ");
$isusts = $isusts[0]['iStatusID'];
if ($invdt[0]['iStatusID'] >= $isusts && $curORGID == $invdtl[0]['iBuyerOrganizationID']) {
header("Location:" . SITE_URL_DUM . "invacptlist/{$msg}");
} else {
if ($invdt[0]['iBuyerOrganizationID'] == $curORGID && $invdt[0]['eCreateByBuyer'] == 'Yes') {
header("Location:" . SITE_URL_DUM . "invacptlist/{$msg}");
} else {
header("Location:" . SITE_URL_DUM . "invoicelist/{$msg}");
}
}
exit;
$page = 1;
}
//Prints($_POST); exit;
if (!isset($r2bdObj)) {
include_once SITE_CLASS_APPLICATION . "user/" . "class.Rfq2Bids.php";
$r2bdObj = new Rfq2Bids();
}
if (!isset($r2awObj)) {
include_once SITE_CLASS_APPLICATION . "user/" . "class.Rfq2Award.php";
$r2awObj = new Rfq2Award();
}
if (!isset($statusmasterObj)) {
include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php";
$statusmasterObj = new StatusMaster();
}
$asts = $statusmasterObj->getDetails('iStatusID', " AND vForAuction!='' AND vStatus_en='Auth3' ");
$asts = $asts[0]['iStatusID'];
$where = "";
$having = "";
if ($mode == 'srch') {
if (trim($vRFQ2Code) != '') {
$where = " AND rfq2.vRFQ2Code LIKE '%{$vRFQ2Code}%'";
}
if (trim($vInvoiceCode) != '') {
$where .= " AND (ioh.vInvoiceCode LIKE '%{$vInvoiceCode}%' OR poh.vPOCode LIKE '%{$vInvoiceCode}%')";
}
if (trim($vProductName) != '') {
$having .= " HAVING vProductName LIKE '%{$vProductName}%'";
}
if (trim($vBuyerName) != '') {
$where .= " AND (ioh.vBuyerName LIKE '%{$vBuyerName}%' OR poh.vBuyerCompanyName LIKE '%{$vBuyerName}%')";
$invUserStatus = @explode(',', $invUserStatus);
}
if (trim($poUserStatus) != '') {
$poUserStatus = @explode(',', $poUserStatus);
}
$invUserAcpt = $userAcpt[0];
$invUserAcpt = str_replace("inv:", "", $invUserAcpt);
$poUserAcpt = isset($userAcpt[1]) ? $userAcpt[1] : '';
$poUserAcpt = str_replace("po:", "", $poUserAcpt);
if (trim($invUserAcpt) != '') {
$invUserAcpt = @explode(',', $invUserAcpt);
}
if (trim($poUserAcpt) != '') {
$poUserAcpt = @explode(',', $poUserAcpt);
}
$poapt = $orgStaObj->getDetails('vStatus_' . LANG . ' as title,vStatusMsg_' . LANG . ',iStatusID as Id,eFor,eType,vStatus_en as status', " AND eFor='PO' AND vStatus_en='Accepted' ");
$invapt = $orgStaObj->getDetails('vStatus_' . LANG . ' as title,vStatusMsg_' . LANG . ',iStatusID as Id,eFor,eType,vStatus_en as status', " AND eFor='Invoice' AND vStatus_en='Accepted' ");
$ecreate = array();
$eimport = array();
$everify = array();
$ures[0]['eFormCreation'] = isset($ures[0]['eFormCreation']) ? $ures[0]['eFormCreation'] : '';
if (strpos($ures[0]['eFormCreation'], 'po') !== false) {
$ecreate['po'] = 'Yes';
}
if (strpos($ures[0]['eFormCreation'], 'inv') !== false) {
$ecreate['inv'] = 'Yes';
}
$ures[0]['eImportCreation'] = isset($ures[0]['eImportCreation']) ? $ures[0]['eImportCreation'] : '';
if (strpos($ures[0]['eImportCreation'], 'po') !== false) {
$eimport['po'] = 'Yes';
}
if (!isset($iohObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.InvoiceOrderHeading.php";
$iohObj = new InvoiceOrderHeading();
}
if (!isset($statusmasterObj)) {
include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php";
$statusmasterObj = new StatusMaster();
}
if (!isset($orgObj)) {
include_once SITE_CLASS_APPLICATION . "organization/class.Organization.php";
$orgObj = new Organization();
}
// $poData=$pohObj->select($iPurchaseOrderID);
$fields = " poh.*, (select vState from b2b_state_master sm where BINARY sm.vStateCode=poh.vShipToState AND BINARY sm.vCountryCode=poh.vShipToCountry) as vShipToState,\r\n\t\t\t\t(select vCountry from b2b_country_master cm where BINARY cm.vCountryCode=poh.vShipToCountry) as vShipToCountry,\r\n\t\t\t\t(select vState from b2b_state_master sm where BINARY sm.vStateCode=poh.vBillToState AND BINARY sm.vCountryCode=poh.vBillToCountry) as vBillToState,\r\n\t\t\t\t(select vCountry from b2b_country_master cm where BINARY cm.vCountryCode=poh.vBillToCountry) as vBillToCountry,\r\n\t\t\t\t(select org.vCompanyName from b2b_organization_master org where org.iOrganizationID=poh.iSupplierOrganizationID) as vSupplierName,\r\n\t\t\t\t(select CONCAT(usr.vFirstName,' ',usr.vLastName) as name from b2b_organization_user usr where usr.iUserID=poh.iSupplierID) as vSupplierContactParty ";
$poData = $pohObj->getJoinTableInfo('', $fields, " AND iPurchaseOrderID={$iPurchaseOrderID} ");
$isdtls = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Issued' ");
$isdtls = $isdtls[0]['iStatusID'];
if ($uorg_type == 'Buyer2') {
$b2us = $pohObj->getPurchaseOrderRfq2Buyer2OrgIds($iPurchaseOrderID);
if (!in_array($curORGID, $b2us)) {
header("Location: " . SITE_URL_DUM . "invoicelist");
exit;
}
} else {
if ($poData[0]['iBuyerOrganizationID'] != $curORGID && $poData[0]['iSupplierOrganizationID'] != $curORGID) {
header("Location: " . SITE_URL_DUM . "polist/all");
exit;
} else {
if ($poData[0]['iSupplierOrganizationID'] == $curORGID && $poData[0]['iStatusID'] < $isdtls) {
header("Location: " . SITE_URL_DUM . "polist/all");
exit;
$smarty->assign('view', $view);
}
$smarty->assign('rfq2filearr', $rfq2filearr);
$smarty->assign('dtls', $dtls);
$smarty->assign('bdtls', $bdtls);
$smarty->assign('b2rfq2sts', $b2rfq2sts);
$smarty->assign('allow_bid', $allow_bid);
$smarty->assign('product_dtls', $product_dtls);
// $smarty->assign('invattachs', $invattachs);
$smarty->assign('rfq2pb2_dtls', $rfq2pb2_dtls);
$smarty->assign('curORGID', $curORGID);
} else {
if ($sess_usertype == 'orgadmin') {
header("Location: " . SITE_URL_DUM . "b2rfq2list");
exit;
}
$acptsts = $statusmasterObj->getDetails('iStatusID', " AND vForAuction LIKE 'RFQ2,%' AND vStatus_en='Verify' ");
$acptsts = $acptsts[0]['iStatusID'];
$rfq2CombAry = array("ID" => "iRFQ2Id", "Name" => "Data[iRFQ2Id]", "Type" => "Query", "tableName" => "" . PRJ_DB_PREFIX . "_rfq2_master", "fieldId" => "iRFQ2Id", "fieldName" => "vRFQ2Code", "extVal" => '', "selectedVal" => '', "width" => '210px', "height" => '', "onchange" => '', "selectText" => "--- " . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_RFQ2') . " ---", "where" => " iStatusID='{$acptsts}' AND (Select count(rpb2.iRfq2ProductB2Id) from " . PRJ_DB_PREFIX . "_rfq2_product_buyer2 rpb2 where rpb2.iRFQ2Id=iRFQ2Id AND iBuyer2Id={$curORGID})>0 AND (eAuctionStatus='Live' OR (eAuctionStatus NOT IN ('Completed','Cancelled') AND dStartDate<=NOW() AND dEndDate>=NOW())) ", "multiple_select" => "", "orderby" => 'vRFQ2Code', "validationmsg" => '', "extra" => " title='" . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_RFQ2') . "' ", "class" => "required");
$rfq2s = $gdbobj->DynamicDropDown($rfq2CombAry);
$smarty->assign('rfq2s', $rfq2s);
}
if ($sess_usertype_short == 'OU' && $uorg_type == 'Buyer2' && $uorg_type != 'SM') {
$ur2p = $orgUserPermObj->getUserR2Permits($sess_id, '%,RFQ2 Bid,%', 'vRFQ2BidPermits');
$smarty->assign('ur2p', $ur2p);
}
$smarty->assign('iRFQ2Id', $id);
$smarty->assign('msg', $msg);
$smarty->assign('vmsg', $vmsg);
$smarty->assign('view', $view);
// check for live rfq2 and bid can only be added/edited for those
$sproductObj = new SProductOrganization();
}
$product_dtls = $sproductObj->select($rfq2pb2_dtls[0]['iProductId']);
//pr($product_dtls);exit;
}
}
}
}
// pr($product_dtls); exit;
// pr($bdtls); exit;
$b2rfq2sts = "";
if (isset($bdtls[0]['iRFQ2Id']) && $bdtls[0]['iRFQ2Id'] > 0) {
$b2rfq2sts = $rfq2Obj->getB2Rfq2Status($bdtls[0]['iRFQ2Id']);
//
if ($b2rfq2sts == 'completed') {
$rsts = $statusmasterObj->getDetails('*', " AND vForAuction LIKE '%RFQ2 Award,%' AND vStatus_en='Rejected' ");
$rsts = $rsts[0]['iStatusID'];
$jtbl = "INNER JOIN " . PRJ_DB_PREFIX . "_rfq2_master rfq2 on r2bd.iRFQ2Id=rfq2.iRFQ2Id\r\n LEFT JOIN " . PRJ_DB_PREFIX . "_inovice_order_heading ih ON rfq2.iInvoiceID=ih.iInvoiceID\r\n\t\t\t\tLEFT JOIN " . PRJ_DB_PREFIX . "_status_master sm ON sm.iStatusID=r2bd.iStatusID\r\n\t\t\t\tLEFT JOIN " . PRJ_DB_PREFIX . "_organization_master org ON org.iOrganizationID=r2bd.iBuyer2Id ";
$where = " AND r2bd.iRFQ2Id=" . $bdtls[0]['iRFQ2Id'] . " AND r2bd.iBidId NOT IN (Select iBidId from " . PRJ_DB_PREFIX . "_rfq2award_master where iStatusID={$rsts}) AND iBidId!=" . $bdtls[0]['iBidId'] . " AND r2bd.eSaved!='Yes' AND r2bd.eStatus Not IN ('pending','rejected') ";
// AND r2bd.iBidId!=".$bdtls[0]['iBidId']."
$orderby = " fBidAmount DESC ";
if ($rfq2_dtls[0]['eBidCriteria'] == 'Advance') {
$orderby = " fBidAdvanceTotal DESC ";
} else {
if ($rfq2_dtls[0]['eBidCriteria'] == 'Advance') {
$orderby = " fBidPriceTotal ASC ";
}
}
$obid_dtls = $r2bdObj->getJoinTableInfo($jtbl, " DISTINCT *, org.vCompanyName as vBuyer2, r2bd.eStatus, r2bd.eSaved, r2bd.eDelete, r2bd.iModifiedById, rfq2.eAuctionStatus as rStatus ", "{$where}", "{$orderby}", "", "", "");
// pr($obid_dtls); exit;
$smarty->assign('obid_dtls', $obid_dtls);
}
if (!isset($statusmasterObj)) {
include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php";
$statusmasterObj = new StatusMaster();
}
if (!isset($r2bdobj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Bids.php";
$r2bdobj = new Rfq2Bids();
}
if (!isset($rfq2awardObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.Rfq2Award.php";
$rfq2awardObj = new Rfq2Award();
}
// --- Statistics --------------------------------------------------------------------------------------------
// -----------
$sts = $statusmasterObj->getDetails(" DISTINCT iStatusID, vStatus_en, vStatus_fr, vStatus_" . LANG . " as vStatus ", " AND vForAuction LIKE '%RFQ2%'");
#pr($sts);exit;
$smarty->assign("sts", $sts);
// -----------------------------------------------------------------------------------------------------------
// --- Last Logins -------------------------------------------------------------------------------------------
if (!isset($lghObj)) {
require_once SITE_CLASS_APPLICATION . "class.LoginHistory.php";
$lghObj = new LoginHistory();
}
$lastlogins = $lghObj->getDetails("*", " AND iAdminId={$sess_id}", " dLoginDate DESC ", '', " LIMIT 0,3");
$lastLoginDate = $lastlogins[0]['dLoginDate'];
$smarty->assign("lastlogins", $lastlogins);
// INBOX DETAIL -----------------------------------------------------------------------------------------------------------
//Prints($_SESSION['SESS_'.PRJ_CONST_PREFIX.'_INBOX_VIEWED']);exit;
$curViewedInbox = isset($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_INBOX_VIEWED']) ? $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_INBOX_VIEWED'] : '';
$curViewedInboxStr = @implode(',', $curViewedInbox);
//$sql="select vOrganizationCode, vCompanyName from b2b_organization_master org,b2b_organization_user user where org.iOrganizationId=user.iOrganizationId and user.vUserName='******'";
//$sql="select vOrganizationCode, vCompanyName from b2b_organization_master org where org.iOrganizationId=$curORGID";
//$res=$dbobj->MySqlSelect($sql); //$curORGID
$orgdtls = $orgObj->select($curORGID);
$orgname = $orgdtls[0]['vCompanyName'];
$OrgCode = $orgdtls[0]['vOrganizationCode'];
// prints($orgname);exit;
$poad = isset($_SESSION['poadd']) ? $_SESSION['poadd'] : '';
$podtls = array();
$asocdtls = array();
$sorgdtls = array();
$invdl = array();
$poAttachments = array();
if ($view == 'edit') {
$podtls = $pohObj->select($iPurchaseOrderID);
$isdtls = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Issued' ");
$isdtls = $isdtls[0]['iStatusID'];
if ($podtls[0]['iBuyerOrganizationID'] != $curORGID && $podtls[0]['iSupplierOrganizationID'] != $curORGID) {
header("Location: " . SITE_URL_DUM . "polist/all");
exit;
} else {
if ($podtls[0]['iSupplierOrganizationID'] == $curORGID && $podtls[0]['iStatusID'] < $isdtls) {
header("Location: " . SITE_URL_DUM . "polist/all");
exit;
}
}
$sorgdtls = $orgObj->select($podtls[0]['iSupplierOrganizationID']);
if ($podtls[0]['iInvoiceID'] > 0) {
$invdl = $invOrdObj->select($podtls[0]['iInvoiceID']);
}
$asocdtls = $asocObj->getDetails('*', " AND iBuyerOrganizationID={$curORGID} AND iSupplierAssocationID=" . $podtls[0]['iSupplierOrganizationID']);
if ($eFrom == "Next") {
$redirecturl = SITE_URL_DUM . "invoiceadditems/{$iInvoiceID}/sucss";
} else {
$redirecturl = SITE_URL_DUM . "invoicelist/{$msg}";
}
$_SESSION['SESS_' . PRJ_CONST_PREFIX . '_MSG'] = $msg;
} else {
$redirecturl = SITE_URL_DUM . "invoiceadditems/{$iInvoiceID}/sucss";
}
} else {
$redirecturl = SITE_URL_DUM . "invpref/{$iInvoiceID}/rerr";
}
header("Location: {$redirecturl}");
exit;
//------------------------------------------------------------------------------------------------------------------------------------------------
$poisu = $statusmasterObj->getDetails('iStatusID', " AND eFor='PO' AND (vStatus_en='Auth1' || vStatus_en='Auth2' || vStatus_en='Auth3') ");
// prints($poisu); exit;
$totusrs = $orgUsrObj->getDetails(" COUNT(*) as tot ", " AND iOrganizationID={$curORGID} AND eUserType='User'");
$totusrs = $totusrs[0]['tot'];
$ordt = $orgUsrObj->getDetails('*', " AND iOrganizationID={$curORGID} AND eUserType='Admin' AND eStatus='Active'");
$org = $orgObj->select($curORGID);
$smdt = $secManObj->getDetails('*', " AND iASMID=" . $org[0]['iASMID'] . " AND eStatus='Active'");
// $jtbl = " LEFT JOIN b2b_organization_user_permission up on ou.iUserID=up.iUserID ";
// $usreml = $orgUsrObj->getJoinTableInfo($jtbl,'*'," AND ou.iOrganizationID=$curORGID AND ou.iUserID!=$sess_id AND ou.eUserType='User' AND ou.eStatus='Active' AND (up.tPermission LIKE '%po:%".$poisu[0]['iStatusID']."%' OR up.tPermission LIKE '%po:%".$poisu[1]['iStatusID']."%' OR up.tPermission LIKE '%po:%".$poisu[2]['iStatusID']."%')");
// prints($usreml); exit;
if (is_array($smdt) && is_array($ordt)) {
$emailArr = array_merge($smdt, $ordt);
} else {
if (is_array($smdt)) {
$emailArr = $smdt;
} else {
} else {
$where .= " AND ioh.iStatusID=''";
}
} else {
if (in_array($invStatus, $invusts)) {
$where .= " AND ioh.iStatusID=" . $invStatus . " AND ioh.eSaved!='Yes' ";
} else {
$where .= " AND ioh.iStatusID=''";
}
}
}
}
// echo $where; exit;
$invDetail = $statusmasterObj->getStatusDetails($invStatus, 'Invoice');
if ($invDetail[0]['vStatus'] == 'Issuance') {
$iAuthIDs = $statusmasterObj->getDetails("group_concat(iStatusid) as authIDs", "AND vStatus_en like('%auth%') and efor='Invoice'");
// print_r($iAuthIDs);
$iAuthIDs = $iAuthIDs[0]['authIDs'];
if ($iAuthIDs != '') {
$where .= " OR sm.iStatusID in(" . $iAuthIDs . ")";
}
}
}
/* if($orgtype == 'Buyer' && ($invStatus == $isusts || $invStatus == $acptsts || $invStatus=='')) {
if(trim($invStatus) == '') {
$where = " AND ioh.iBuyerOrganizationID=$curORGID AND ioh.iStatusID IN ($isusts,$acptsts) ";
} else if(is_numeric($invStatus) && $invStatus>0) {
if($invStatus == $isusts || $invStatus == $acptsts) {
$where = " AND ioh.iBuyerOrganizationID=$curORGID AND ioh.iStatusID=$invStatus ";
}
}
unset($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_MSG']);
if ($msg == 'ras') {
$msg = $smarty->get_template_vars('MSG_ADD_SUCC');
} elseif ($msg == 'raserr') {
$msg = $smarty->get_template_vars('MSG_ADD_ERR');
} elseif ($msg == 'rus') {
$msg = $smarty->get_template_vars('MSG_UPDATE_SUCC');
} elseif ($msg == 'ruserr') {
$msg = $smarty->get_template_vars('MSG_UPDATE_ERR');
} else {
if ($msg == 'pocr') {
$msg = $smarty->get_template_vars('MSG_PO_CREATED');
} else {
$msg = '';
}
}
if (!isset($statusmasterObj)) {
include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php";
$statusmasterObj = new StatusMaster();
}
$poStatus = $_GET['id'];
$_SESSION['polvl'] = $poStatus;
$rejectStatusID = $statusmasterObj->getDetails('iStatusID', ' AND vStatus_en="Rejected" AND eFor="PO"');
$rejectStatusID = $rejectStatusID[0]['iStatusID'];
$deletepo = '';
if ($poStatus == $rejectStatusID) {
$deletepo = 'Yes';
}
$smarty->assign('deletepo', $deletepo);
$smarty->assign('poStatus', $poStatus);
$smarty->assign("msg", $msg);
// echo $status; exit;
// $page = (isset($_POST['page']))? $_POST['page'] : '';
$page = PostVar('page');
if (trim($page) == '' || trim($page) < 1) {
$page = 1;
}
//Prints($_POST); exit;
if (!isset($r2bdObj)) {
include_once SITE_CLASS_APPLICATION . "user/" . "class.Rfq2Bids.php";
$r2bdObj = new Rfq2Bids();
}
if (!isset($statusmasterObj)) {
include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php";
$statusmasterObj = new StatusMaster();
}
$csts = $statusmasterObj->getDetails('iStatusID', " AND vForAuction LIKE 'RFQ2,%' AND vStatus_en='Create' ");
$csts = $csts[0]['iStatusID'];
$where = "";
$having = "";
if ($mode == 'srch') {
if (trim($vRFQ2Code) != '') {
$where = " AND rfq2.vRFQ2Code LIKE '%{$vRFQ2Code}%'";
}
if (trim($vInvoiceCode) != '') {
$where .= " AND (ioh.vInvoiceCode LIKE '%{$vInvoiceCode}%' OR poh.vPOCode LIKE '%{$vInvoiceCode}%')";
}
if (trim($vProductName) != '') {
$having .= " HAVING vProductName LIKE '%{$vProductName}%'";
}
if (trim($vBuyerName) != '') {
$where .= " AND (ioh.vBuyerName LIKE '%{$vBuyerName}%' OR poh.vBuyerCompanyName LIKE '%{$vBuyerName}%')";
// echo $status; exit;
// $page = (isset($_POST['page']))? $_POST['page'] : '';
$page = PostVar('page');
if (trim($page) == '' || trim($page) < 1) {
$page = 1;
}
//Prints($_POST); exit;
if (!isset($rfq2Obj)) {
include_once SITE_CLASS_APPLICATION . "user/class.RFQ2Master.php";
$rfq2Obj = new RFQ2Master();
}
if (!isset($statusmasterObj)) {
include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php";
$statusmasterObj = new StatusMaster();
}
$rsts = $statusmasterObj->getDetails('iStatusID', " AND vForAuction LIKE 'RFQ2,%' AND vStatus_en='Rejected' ");
$rsts = $rsts[0]['iStatusID'];
$where = "";
$having = "";
if ($mode == 'srch') {
if (trim($vRFQ2Code) != '') {
$where = " AND rfq2.vRFQ2Code LIKE '%{$vRFQ2Code}%'";
}
if (trim($vInvoiceCode) != '') {
$where .= " AND (ioh.vInvoiceCode LIKE '%{$vInvoiceCode}%' OR poh.vPOCode LIKE '%{$vInvoiceCode}%')";
}
if (trim($vProductName) != '') {
$having .= " HAVING vProductName LIKE '%{$vProductName}%'";
}
if (trim($vBuyerName) != '') {
$where .= " AND (ioh.vBuyerName LIKE '%{$vBuyerName}%' OR poh.vBuyerCompanyName LIKE '%{$vBuyerName}%')";
