} else {
if ($poStatus == $iusts) {
$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}) ";
if (in_array($iprvsts, $invusts)) {
$where .= " AND ioh.iStatusID=" . $iprvsts;
} 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 ";
$_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ORGNAME'] = $orgdata[0]['vCompanyName'];
$orgpref = $orgprefObj->getDetails('*', " AND iOrganizationID={$curORGID}");
// print_r($orgpref[0]);
$postatus = $orgpref[0]['vOrderStatusLevel'];
$invstatus = $orgpref[0]['vInvoiceStatusLevel'];
$poUserStatusIds = $postatus;
$invUserStatusIds = $invstatus;
//print $postatus;
if (trim($postatus) != '') {
$postatus = @explode(',', $postatus);
}
if (trim($invstatus) != '') {
$invstatus = @explode(',', $invstatus);
}
//print_r($postatus);
$postatus = $statusmasterObj->getStatusDetails($postatus, 'PO');
//print_r($invstatus);
$invstatus = $statusmasterObj->getStatusDetails($invstatus, 'Invoice');
$smarty->assign('postatus', $postatus);
$smarty->assign('invstatus', $invstatus);
}
if ($uorg_type != 'SM' && isset($ENABLE_AUCTION) && $ENABLE_AUCTION == 'Yes') {
if (!isset($rfq2Obj)) {
include_once SITE_CLASS_APPLICATION . "user/class.RFQ2Master.php";
$rfq2Obj = new RFQ2Master();
}
$rs = $rfq2Obj->setAllRfq2Ststus();
}
$where = "";
$orgtype = isset($odt[0]['eOrganizationType']) ? $odt[0]['eOrganizationType'] : '';
if (isset($_SESSION['from'])) {