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)) {
require_once SITE_CLASS_APPLICATION . "organization/class.OrganizationAssociation.php";
$orgAssocObj = new OrganizationAssociation();
}
$jtbl = " LEFT JOIN " . PRJ_DB_PREFIX . "_security_manager sm on oa.iVerifiedSMID=sm.iSMID ";
$groupby = " oa.iBuyerOrganizationID ";
$fields = " oa.*,CONCAT(sm.vFirstName,' ',sm.vLastName) as vVerifiedBy,\r\n\t\t\t\t\t(Select vCompanyName from b2b_organization_master where iOrganizationID=oa.iBuyerOrganizationID) as vBuyerOrg ";
$activeassocs = $orgAssocObj->getJoinTableInfo($jtbl, $fields, " AND oa.eStatus!='Inactive'", " oa.dCreatedDate DESC ", '', " LIMIT 0,2");
if (isset($activeassocs['tot'])) {
$tot_activeassocs = $activeassocs['tot'];
} else {
$tot_activeassocs = "";
}
unset($activeassocs['tot']);
$smarty->assign("activeassocs", $activeassocs);
$smarty->assign("tot_activeassocs", $tot_activeassocs);
// -----------------------------------------------------------------------------------------------------------
$secDetail = $secManObj->getDetails('tDashboard', ' AND iSMID = "' . $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'] . '" ', '', '', '');
$tDashboard = $secDetail[0]['tDashboard'];
$smarty->assign("tDashboard", $tDashboard);
/* ---------- */
if (isset($ENABLE_AUCTION) && $ENABLE_AUCTION == 'Yes') {
$b2bpr_dtls = $generalobj->getTableInfo(" " . PRJ_DB_PREFIX . "_buyer2_bproduct_association b2bpa ", "", "b2bpa.*, (Select vCompanyName from " . PRJ_DB_PREFIX . "_organization_master where iOrganizationID=b2bpa.iBuyer2Id) as vBuyer2,\r\n \t\t\t\t\t (Select vProductName from " . PRJ_DB_PREFIX . "_bproduct_organization where iProductId=b2bpa.iProductId) as vProduct", " LIMIT 0,1 ", " ORDER BY iAssociationId DESC ", "");
$auth3sts = $auth3sts[0]['iStatusID'];
$jtbl = " LEFT JOIN " . PRJ_DB_PREFIX . "_organization_user_permission per on ou.iUserID=per.iUserID\r\n\t\t\t\t LEFT JOIN " . PRJ_DB_PREFIX . "_country_master cm on ou.vCountry=cm.vCountryCode ";
$orgslusrvrfy = $orgUserObj->getJoinTableInfo($jtbl, " ou.*, cm.vCountry as vCountryName ", " AND (per.tPermission LIKE '%inv:%{$auth1sts}%' || per.tPermission LIKE '%inv:%{$auth2sts}%' || per.tPermission LIKE '%inv:%{$auth3sts}%') AND (ou.eStatus='Need to Verify' OR ou.eStatus='Modified' OR ou.eNeedToVerify='Yes') AND ou.iOrganizationID={$curORGID}) {$bw} ", " ou.iUserID DESC ", ' ou.iUserID ', " LIMIT 0,2 ", 'yes');
$tot_orgslusrvrfy = $orgslusrvrfy['tot'];
// prints($orgslusrvrfy); exit;
unset($orgslusrvrfy['tot']);
$smarty->assign("orgbyusrvrfy", $orgbyusrvrfy);
$smarty->assign("tot_orgbyusrvrfy", $tot_orgbyusrvrfy);
$smarty->assign("orgslusrvrfy", $orgslusrvrfy);
$smarty->assign("tot_orgslusrvrfy", $tot_orgslusrvrfy);
// -----------------------------------------------------------------------------------------------------------
// --- Organization Associations -----------------------------------------------------------------------------
$jtbl = " LEFT JOIN " . PRJ_DB_PREFIX . "_security_manager sm on oa.iVerifiedSMID=sm.iSMID\r\n\t\t\t\t LEFT JOIN " . PRJ_DB_PREFIX . "_organization_user ou on oa.iVerifiedSMID=ou.iUserID\r\n\t\t\t\t";
$groupby = " oa.iBuyerOrganizationID ";
$fields = " oa.*, CONCAT(ou.vFirstName,' ',ou.vLastName) as oaVerifiedBy , CONCAT(sm.vFirstName,' ',sm.vLastName) as smverifiedBy,\r\n\t\t\t\t\t(Select vCompanyName from b2b_organization_master where iOrganizationID=oa.iBuyerOrganizationID) as vBuyerOrg ";
$activeassocs = $orgAssocObj->getJoinTableInfo($jtbl, $fields, " AND iBuyerOrganizationID={$curORGID} AND oa.eStatus!='Inactive'", " oa.dCreatedDate DESC ", ' oa.iAsociationID ', " LIMIT 0,2");
$tot_activeassocs = isset($activeassocs['tot']) ? $activeassocs['tot'] : "";
unset($activeassocs['tot']);
//prints($activeassocs); exit;
$smarty->assign("activeassocs", $activeassocs);
$smarty->assign("tot_activeassocs", $tot_activeassocs);
// -----------------------------------------------------------------------------------------------------------
// --- Purchase Order -----------------------------------------------------------------------------
$poisu = $statusmasterObj->getDetails('iStatusID', " AND eFor='PO' AND vStatus_en='Issued' ");
$poisu = $poisu[0]['iStatusID'];
$porjt = $statusmasterObj->getDetails('iStatusID', " AND eFor='PO' AND vStatus_en='Rejected' ");
$porjt = $porjt[0]['iStatusID'];
$invisu = $statusmasterObj->getDetails('iStatusID', " AND eFor='Invoice' AND vStatus_en='Issued' ");
$invisu = $invisu[0]['iStatusID'];
$invrjt = $statusmasterObj->getDetails('iStatusID', " AND eFor='Invoice' AND vStatus_en='Rejected' ");
$invrjt = $invrjt[0]['iStatusID'];
if ($cursort != '') {
if ($cursorttype == '1') {
$cursort_type = 'ASC';
} else {
$cursort_type = 'DESC';
}
$orderBy = " {$cursort} {$cursort_type}";
} else {
$orderBy = " oa.dCreatedDate DESC ";
}
## ENDS HERE ###
$limit = " LIMIT " . ($page - 1) * $REC_LIMIT_FRONT . ", " . $REC_LIMIT_FRONT . " ";
$jtbl = "";
/* $fields = " oa.*, (Select vCompanyName from b2b_organization_master where iOrganizationID=iBuyerOrganizationID) as vBuyerOrg,
GROUP_CONCAT((Select DISTINCT CONCAT(vCompanyName,' (',oa.vSupplierCode,')') from b2b_organization_master where iOrganizationID=oa.iSupplierAssocationID )) as vSupplierOrg "; // AND (oa.eStatus='Active' || oa.eStatus = 'Inactive') AND oa.eNeedToVerify!='Yes'
*/
$fields = " oa.*, (Select vCompanyName from b2b_organization_master where iOrganizationID=iBuyerOrganizationID) as vBuyerOrg,\r\n\t\t\t\t\t (Select vCompanyName from b2b_organization_master where iOrganizationID=oa.iSupplierAssocationID) as vSupplierOrg ";
// (Select CONCAT(vCompanyName,' (',oa.vSupplierCode,')') from b2b_organization_master where iOrganizationID=oa.iSupplierAssocationID) as vSupplierOrg
$activegroup = $assObj->getJoinTableInfo($jtbl, $fields, $where, $orderBy, $groupBy, $limit, 'yes');
// prints($activegroup);exit;
$count = $activegroup['tot'];
unset($activegroup['tot']);
if (!isset($pgajxobj)) {
require_once SITE_CLASS_GEN . "class.paging-ajax.php";
}
$pgajxobj = new Paging($count, $page, "listassociations", $REC_LIMIT_FRONT);
$paging = $pgajxobj->getListPG($page);
$pgmsg = $pgajxobj->setMessage("Records");
$smarty->assign('activegroup', $activegroup);
$smarty->assign('paging', $paging);
$smarty->assign('pgmsg', $pgmsg);
