$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 ) "; } $where_s = " AND bsm.iStatusID IN(" . '0,' . $userStatus . ")"; $statistics = $orgUserObj->getOUSatistics($where_s, $curORGID, '', ''); $astatistics = $orgUserObj->getOUSatistics($where_s, $curORGID, $wh_po, $wh_inv, 'acpt'); // prints($statistics); exit; $crstatisu = $orgUserObj->getCrStats($curORGID); $smarty->assign("crstatisu", $crstatisu); $crstatact = $orgUserObj->getCrStats($curORGID, 'acpt'); $vstatistics = $orgUserObj->getNtvPI($curORGID, ''); $avstatistics = $orgUserObj->getNtvPI($curORGID, 'acpt'); $povisu = $statusmasterObj->getDetails('iStatusID', " AND eFor='PO' AND vStatus_en='Verify' "); $povisu = $povisu[0]['iStatusID']; $iovapt = $statusmasterObj->getDetails('iStatusID', " AND eFor='Invoice' AND vStatus_en='Verify' "); $iovapt = $iovapt[0]['iStatusID']; $crio = $statusmasterObj->getDetails('iStatusID', " AND eFor='Invoice' AND vStatus_en='Create' "); $crio = $crio[0]['iStatusID']; $crpo = $statusmasterObj->getDetails('iStatusID', " AND eFor='PO' AND vStatus_en='Create' "); $crpo = $crpo[0]['iStatusID']; $isupo = $statusmasterObj->getDetails('iStatusID', " AND eFor='PO' AND vStatus_en='Issue' "); $isupo = $isupo[0]['iStatusID']; $isuio = $statusmasterObj->getDetails('iStatusID', " AND eFor='Invoice' AND vStatus_en='Issue' ");