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);