Example #1
0
// 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);