<?php
if (!isset($b2bpbObj)) {
include_once SITE_CLASS_APPLICATION . "organization/class.Buyer2_Buyer_BProduct_Association.php";
$b2bpbObj = new Buyer2_Buyer_BProduct_Association();
}
if (!isset($b2bpbvObj)) {
include_once SITE_CLASS_APPLICATION . "organization/class.Buyer2_Buyer_BProduct_Association_ToVerify.php";
$b2bpbvObj = new Buyer2_Buyer_BProduct_Association_ToVerify();
}
if (!isset($emailObj)) {
include_once SITE_CLASS_APPLICATION . 'class.EmailTemplate.php';
$emailObj = new EmailTemplate();
}
$mod = PostVar('mod');
$admr = PostVar('admr');
$iAssociationId = PostVar('iAssociationId');
$Data = PostVar('Data');
$body_arr = '';
$type = '';
$post_data = $_POST;
if ($mod == 'verify') {
$dtv = $vasocdt = $b2bpbvObj->getDetails('*', " AND iAssociationId={$iAssociationId} ", ' iVerifiedID DESC ', '', ' LIMIT 0,1');
$dtv = $dtv[0];
if (is_array($vasocdt) && count($vasocdt) > 0 && isset($vasocdt[0]['iAssociationId']) && isset($vasocdt[0]['iVerifiedID'])) {
$dtv['eVerifiedBy'] = $sess_usertype_short;
$dtv['iVerifiedByID'] = $sess_id;
$dtv['dVerifiedDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
// if(! (($dtv['eStatus']=='Active' || $dtv['eStatus']=='Inactive' || $dtv['eStatus']=='Delete') )) {
if (!(($dtv['eStatus'] == 'Active' || $dtv['eStatus'] == 'Inactive' || $dtv['eStatus'] == 'Delete') && $dtv['eNeedToVerify'] == 'Yes')) {
$dtv['eStatus'] = 'Active';
$code = isset($_POST['code']) ? $_POST['code'] : '';
$product = isset($_POST['product']) ? $_POST['product'] : '';
$buyer = isset($_POST['buyer']) ? $_POST['buyer'] : '';
$stype = isset($_POST['styp']) ? $_POST['styp'] : '';
$page = $_POST['page'];
if (trim($page) == '' || trim($page) < 1) {
$page = 1;
}
// prints($_POST); exit;
if (!isset($orgObj)) {
include_once SITE_CLASS_APPLICATION . "organization/class.Organization.php";
$orgObj = new Organization();
}
if (!isset($assObj)) {
include_once SITE_CLASS_APPLICATION . "organization/class.Buyer2_Buyer_BProduct_Association.php";
$assObj = new Buyer2_Buyer_BProduct_Association();
}
$where = "";
$_POST['srchval'] = isset($_POST['srchval']) ? $_POST['srchval'] : '';
if ($_POST['srchval'] == 'act') {
$where .= " AND b2bpb.eStatus='Active' ";
} else {
if ($_POST['srchval'] == 'inact') {
$where .= " AND b2bpb.eStatus='Inactive' ";
}
}
if ($mode == 'all') {
if ($val != '') {
$where .= " AND ((Select vCompanyName from " . PRJ_DB_PREFIX . "_organization_master where iOrganizationID=b2bpb.iBuyer2Id) LIKE '%{$val}%' OR\r\n \t\t\t\t\t\t(Select vProductName from " . PRJ_DB_PREFIX . "_bproduct_organization where iProductId=b2bpb.iProductId) LIKE '%{$val}%' OR\r\n (Select vCompanyName from " . PRJ_DB_PREFIX . "_organization_master where iOrganizationID=b2bpb.iBuyerId) LIKE '%{$val}%' OR\r\n vACode LIKE '%{$val}%' )";
}
// echo $where; exit;
<?php
$mode = PostVar('mode');
$val = PostVar('val');
if (trim($val) == '' || $val < 1 || trim($mode) == '') {
exit;
}
if (!isset($b2bpbObj)) {
include_once SITE_CLASS_APPLICATION . "organization/class.Buyer2_Buyer_BProduct_Association.php";
$b2bpbObj = new Buyer2_Buyer_BProduct_Association();
}
if (!isset($b2bpbvObj)) {
include_once SITE_CLASS_APPLICATION . "organization/class.Buyer2_Buyer_BProduct_Association_ToVerify.php";
$b2bpbvObj = new Buyer2_Buyer_BProduct_Association_ToVerify();
}
if (!isset($emailObj)) {
include_once SITE_CLASS_APPLICATION . 'class.EmailTemplate.php';
$emailObj = new EmailTemplate();
}
$flds = "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";
$assocs = $b2bpbObj->getDetails($flds, " AND b2bpb.eStatus IN ('Active','Inactive') AND b2bpb.eNeedToVerify!='Yes' AND b2bpb.iAssociationId IN ({$val}) ");
// pr($assocs); exit;
$assocsids = multi21Array($assocs, 'iAssociationId');
$vl = '';
if (is_array($assocsids) && count($assocsids) > 0) {
$vl = @implode(',', $assocsids);
}
$rs = false;
$type = '';
$esubtyp = '';
if ($mode == 'status' && trim($vl) != '') {
<?php
if (!isset($b2bpbObj)) {
include_once SITE_CLASS_APPLICATION . "organization/class.Buyer2_Buyer_BProduct_Association.php";
$b2bpbObj = new Buyer2_Buyer_BProduct_Association();
}
$iAssociationId = GetVar('id');
// $msg = GetVar('msg');
$msg = '';
if (isset($_SESSION[PRJ_CONST_PREFIX . '_action_msg']) && trim($_SESSION[PRJ_CONST_PREFIX . '_action_msg']) != '') {
$msg = $_SESSION[PRJ_CONST_PREFIX . '_action_msg'];
unset($_SESSION[PRJ_CONST_PREFIX . '_action_msg']);
}
if ($msg == 'ras') {
$msg = $smarty->get_template_vars('MSG_ADD_SUCC');
} elseif ($msg == 'aerr') {
$msg = $smarty->get_template_vars('MSG_ADD_ERR');
} elseif ($msg == 'rus') {
$msg = $smarty->get_template_vars('MSG_UPDATE_SUCC');
} elseif ($msg == 'uerr') {
$msg = $smarty->get_template_vars('MSG_UPDATE_ERR');
} elseif ($msg == 'rvs') {
$msg = $smarty->get_template_vars('MSG_VERIFY_SUCC');
} elseif ($msg == 'verr') {
$msg = $smarty->get_template_vars('MSG_VERIFY_ERR');
} elseif ($msg == 'rds') {
$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');
$orgas = "";
$invdtls = $invOrdObj->getDetails('iBuyerOrganizationID,iSupplierOrganizationID', " AND iInvoiceID={$iInvoiceID} ");
if ($invdtls[0]['iBuyerOrganizationID'] == $curORGID) {
$orgas = "Buyer";
} else {
if ($invdtls[0]['iSupplierOrganizationID'] == $curORGID) {
$orgas = "Supplier";
}
}
$orgas = trim($orgas) != '' ? $orgas : $uorg_type;
$dtls = array();
if ($curORGID > 0 && $orgas != '') {
if ($orgas == 'Buyer') {
if (!isset($b2bpbObj)) {
include_once SITE_CLASS_APPLICATION . 'organization/class.Buyer2_Buyer_BProduct_Association.php';
$b2bpbObj = new Buyer2_Buyer_BProduct_Association();
}
$dtls = $b2bpbObj->getDetails("*", " AND iBuyerId={$curORGID} AND iBuyer2Id={$iBuyer2Id} AND iProductId={$ipids} ");
} else {
if ($orgas == 'Supplier') {
if (!isset($b2spsObj)) {
include_once SITE_CLASS_APPLICATION . 'organization/class.Buyer2_Supplier_SProduct_Association.php';
$b2spsObj = new Buyer2_Supplier_SProduct_Association();
}
$dtls = $b2spsObj->getDetails("*", " AND iSupplierId={$curORGID} AND iBuyer2Id={$iBuyer2Id} AND iProductId={$ipids} ");
} else {
if ($orgas == 'Both') {
$sql = "(Select DISTINCT * from " . PRJ_DB_PREFIX . "_buyer2_buyer_bproduct_association where iBuyerId={$curORGID} AND iBuyer2Id={$iBuyer2Id} AND iProductId={$ipids})\r\n\t\t\t\t\tUNION\r\n\t\t\t\t\t(Select DISTINCT * from " . PRJ_DB_PREFIX . "_buyer2_supplier_sproduct_association where iSupplierId={$curORGID} AND iBuyer2Id={$iBuyer2Id} AND iProductId={$ipids})\r\n\t\t\t\t\tORDER BY vACode ASC";
// echo $sql; exit;
$dtls = $dbobj->MySQLSelect($sql);
}
<?php
$iAssociationId = GetVar('id');
/*if($sess_usertype == 'orgadmin' && $asoc != $iAssociationId) {
header("Location: ".SITE_URL_DUM."oadashboard");
exit;
}*/
if (!isset($b2bpbObj)) {
include_once SITE_CLASS_APPLICATION . "organization/class.Buyer2_Buyer_BProduct_Association.php";
$b2bpbObj = new Buyer2_Buyer_BProduct_Association();
}
if (!isset($b2bpbvObj)) {
include_once SITE_CLASS_APPLICATION . "organization/class.Buyer2_Buyer_BProduct_Association_ToVerify.php";
$b2bpbvObj = new Buyer2_Buyer_BProduct_Association_ToVerify();
}
$b2bprdtls = $b2bpbObj->select($iAssociationId);
$b2bprdthistory = $b2bpbvObj->getHistory($iAssociationId);
// prints($b2bprdthistory); exit;
$smarty->assign('b2bprdtls', $b2bprdtls);
$smarty->assign('b2bprdthistory', $b2bprdthistory);