Esempio n. 1
0
            } 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}) ";
Esempio n. 2
0
                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 ";
Esempio n. 3
0
    $_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'])) {