// OR eCreatedType = \'OU\' // $where .= ' AND (dActionDate > \''.$lastLoginDate.'\')'; // iCreatedBy <> '.$_SESSION['SESS_'.PRJ_CONST_PREFIX.'_ID'].' AND $where .= ' AND iVerifiedID NOT IN (SELECT iInboxId FROM ' . PRJ_DB_PREFIX . '_user_deleted_inbox WHERE iUserId = \'' . $sess_id . '\' AND eUserType = \'' . $sess_usertype_short . '\') '; // AND eViewed!=\'Yes\' $orderBy = " ORDER BY iVerifiedID DESC"; $limit = ' LIMIT 0,5'; $sql_res = 'CALL GetInbox("OU"," ' . $where . '","","' . $orderBy . '","' . $limit . '")'; // echo $sql_res; $res = $dbobj->Onlyquery($sql_res); $smarty->assign("res", $res); // ----------- $secDetail = $orgUserObj->getDetails('tDashboard', ' AND iUserID = "' . $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'] . '" ', '', '', ''); //Prints($secDetail);exit; $tDashboard = $secDetail[0]['tDashboard']; $smarty->assign("tDashboard", $tDashboard); $totalbids = $r2bdobj->getOrgBids($curORGID); //prints($result);exit; //---- $bidstatistic = $orgUserObj->getOrgRFQ2Bids($curORGID); # prints($bidstatistic); exit; $latestaward = $rfq2awardObj->getrfq2awards($curORGID); // prints($latestaward);exit; $award = $rfq2awardObj->getB2Award($curORGID); $orgawsts = $orgprefObj->getDetails('vRFQ2AwardAcceptLevel', " AND iOrganizationID={$curORGID} "); $aworgsts = array(); $aworgsts = @explode(',', $orgawsts[0]['vRFQ2AwardAcceptLevel']); // $award = $award[0]; //pr($sts);EXIT; // prints($award);exit; $smarty->assign("award", $award); $smarty->assign("aworgsts", $aworgsts);