$cursort_type = 'ASC';
} else {
$cursort_type = 'DESC';
}
$orderBy = " {$cursort} {$cursort_type}";
} else {
$orderBy = " dCreatedDate DESC ";
}
## ENDS HERE ###
/* if(trim($stype) != '') {
// if($stype == 'act')
}
*/
$limit = " LIMIT " . ($page - 1) * $REC_LIMIT_FRONT . ", " . $REC_LIMIT_FRONT . " ";
$jtbl = "LEFT JOIN " . PRJ_DB_PREFIX . "_country_master cm on BINARY org.vCountry=cm.vCountryCode";
$orglist = $orgObj->getJoinTableInfo($jtbl, "org.iOrganizationID,org.vCompanyName,org.vOrganizationCode,org.eOrganizationType,cm.vCountry,org.eStatus,cm.vCountry", $where, $orderBy, '', $limit, 'yes');
//$orglist = $orgObj->getDetails_PG('*',$where,$orderBy,'',$limit);
$count = $orglist['tot'];
//prints($count);exit;
// print "A".$count."A";
unset($orglist['tot']);
if (!isset($pgajxobj)) {
require_once SITE_CLASS_GEN . "class.paging-ajax.php";
}
$pgajxobj = new Paging($count, $page, "listorgs", $REC_LIMIT_FRONT);
$paging = $pgajxobj->getListPG($page);
$pgmsg = $pgajxobj->setMessage("Records");
$smarty->assign('orglist', $orglist);
$smarty->assign('count', $count);
$smarty->assign('paging', $paging);
$smarty->assign('pgmsg', $pgmsg);
//echo $where;
$sql_res = 'CALL GetInbox("SM"," ' . $where . '","","' . $orderBy . '","' . $limit . '")';
// echo $sql_res; exit;
$res = $dbobj->Onlyquery($sql_res);
$smarty->assign("res", $res);
//Prints($res);exit;
// --- Organizations -----------------------------------------------------------------------------------------
if (!isset($orgObj)) {
require_once SITE_CLASS_APPLICATION . "organization/class.Organization.php";
$orgObj = new Organization();
}
// $jTable = Array(" LEFT JOIN ".PRJ_DB_PREFIX."_country_master cm "," LEFT JOIN ".PRJ_DB_PREFIX."_security_manager sm ");
// $jOn = Array(" org.vCountry=cm.vCountryCode "," org.iVerifiedSMID=sm.iSMID ");
// $activeorgs = $orgObj->getJoinTableInfo($jTable,$jOn,"org.*,cm.vCountry as vCountryName,CONCAT(sm.vFirstName,' ',sm.vLastName) as vVerifiedBy"," AND org.eStatus='Active'"," dVerifiedDate DESC ",''," LIMIT 0,3",'yes');
$jtbl = " LEFT JOIN " . PRJ_DB_PREFIX . "_country_master cm on org.vCountry=cm.vCountryCode LEFT JOIN " . PRJ_DB_PREFIX . "_security_manager sm on org.iVerifiedSMID=sm.iSMID ";
$activeorgs = $orgObj->getJoinTableInfo($jtbl, "org.*,cm.vCountry as vCountryName,CONCAT(sm.vFirstName,' ',sm.vLastName) as vVerifiedBy", " AND org.eStatus='Active'", " org.dVerifiedDate DESC ", ' org.iOrganizationID ', " LIMIT 0,3", 'yes');
$tot_activeorgs = $activeorgs['tot'];
unset($activeorgs['tot']);
// $orgstoverify = $orgObj->getDetails("*"," AND (eStatus='Need to Verify' OR eStatus='Modified')"," dVerifiedDate DESC ",''," LIMIT 0,3");
$jtbl = " LEFT JOIN " . PRJ_DB_PREFIX . "_country_master cm on org.vCountry=cm.vCountryCode ";
$orgstoverify = $orgObj->getJoinTableInfo($jtbl, "org.*,cm.vCountry as vCountryName", " AND (org.eStatus='Need to Verify' OR org.eStatus='Modified')", " org.dCreatedDate DESC ", ' org.iOrganizationID ', " LIMIT 0,3", 'yes');
$tot_orgstoverify = $orgstoverify['tot'];
unset($orgstoverify['tot']);
// prints($activeorgs); exit;
$smarty->assign("activeorgs", $activeorgs);
$smarty->assign("tot_activeorgs", $tot_activeorgs);
$smarty->assign("orgstoverify", $orgstoverify);
$smarty->assign("tot_orgstoverify", $tot_orgstoverify);
// -----------------------------------------------------------------------------------------------------------
// --- Organization Associations -----------------------------------------------------------------------------
if (!isset($orgAssocObj)) {
