$cursorttype = $_POST['cursorttype'];
if ($cursort != '') {
if ($cursorttype == '1') {
$cursort_type = 'ASC';
} else {
$cursort_type = 'DESC';
}
$orderBy = " {$cursort} {$cursort_type}";
} else {
$orderBy = " b2bpb.dADate DESC ";
}
## ENDS HERE ###
$where .= " AND NOT (b2bpb.eStatus='Delete' AND b2bpb.eNeedToVerify!='Yes') ";
$limit = " LIMIT " . ($page - 1) * $REC_LIMIT_FRONT . ", " . $REC_LIMIT_FRONT . " ";
$jtbl = "";
$fields = "b2bpb.*, (Select vCompanyName from " . PRJ_DB_PREFIX . "_organization_master where iOrganizationID=b2bpb.iBuyer2Id) as vBuyer2,\r\n\t\t\t\t\t (Select vProductName from " . PRJ_DB_PREFIX . "_bproduct_organization where iProductId=b2bpb.iProductId) as vProduct,\r\n (Select vCompanyName from " . PRJ_DB_PREFIX . "_organization_master where iOrganizationID=b2bpb.iBuyerId) as vBuyer";
// (Select CONCAT(vCompanyName,' (',b2bpb.vSupplierCode,')') from b2b_organization_master where iOrganizationID=b2bpb.iSupplierAssocationID) as vSupplierOrg
$asocs = $assObj->getJoinTableInfo($jtbl, $fields, $where, $orderBy, $groupBy, $limit, 'yes');
// prints($asocs); exit;
$count = $asocs['tot'];
unset($asocs['tot']);
if (!isset($pgajxobj)) {
require_once SITE_CLASS_GEN . "class.paging-ajax.php";
}
$pgajxobj = new Paging($count, $page, "listb2bprdtbassocs", $REC_LIMIT_FRONT);
$paging = $pgajxobj->getListPG($page);
$pgmsg = $pgajxobj->setMessage("Records");
$smarty->assign('count', $count);
$smarty->assign('asocs', $asocs);
$smarty->assign('paging', $paging);
$smarty->assign('pgmsg', $pgmsg);
$msg = $smarty->get_template_vars('MSG_DEL_SUCC');
} elseif ($msg == 'derr') {
$msg = $smarty->get_template_vars('MSG_DEL_ERR');
} elseif ($msg == 'rss') {
$msg = $smarty->get_template_vars('MSG_STATUS_SUCC');
} elseif ($msg == 'rserr') {
$msg = $smarty->get_template_vars('MSG_STATUS_ERR');
} else {
$msg = '';
}
$arr = array();
if (trim($iAssociationId) != '' && $iAssociationId > 0) {
$mod = 'edit';
$flds = " b2bpb.*, org.vCompanyName as vBuyer2, org.vCompCode as vB2Code, bpo.vProductName as vProduct, bpo.vProductCode, bo.vCompanyName as vBuyer, bo.vCompCode as vBCode ";
$jtbl = " LEFT JOIN " . PRJ_DB_PREFIX . "_bproduct_organization bpo on bpo.iProductId=b2bpb.iProductId\r\n LEFT JOIN " . PRJ_DB_PREFIX . "_organization_master org on org.iOrganizationID=b2bpb.iBuyer2Id\r\n LEFT JOIN " . PRJ_DB_PREFIX . "_organization_master bo on bo.iOrganizationID=b2bpb.iBuyerId";
$arr = $b2bpbObj->getJoinTableInfo($jtbl, $flds, " AND iAssociationId={$iAssociationId} ");
if (!(is_array($arr) && count($arr) > 0)) {
header('Location: ' . SITE_URL_DUM . 'b2bprodtbasoclist');
exit;
} else {
if (!(isset($arr[0]['eStatus']) && (($arr[0]['eStatus'] == 'Active' || $arr[0]['eStatus'] == 'Inactive') && $arr[0]['eNeedToVerify'] != 'Yes'))) {
header('Location: ' . SITE_URL_DUM . 'b2bprodtbasocview/' . $iAssociationId);
exit;
}
}
if ($arr[0]['eStatus'] == 'Delete' && $arr[0]['eNeedToVerify'] != 'Yes') {
header('Location: ' . SITE_URL_DUM . 'b2bprodtbasoclist/rnme');
exit;
}
} else {
$mod = 'add';