<?php if (!isset($b2bpaObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.Buyer2_BProduct_Association.php"; $b2bpaObj = new Buyer2_BProduct_Association(); } if (!isset($b2bpavObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.Buyer2_BProduct_Association_ToVerify.php"; $b2bpavObj = new Buyer2_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 = $b2bpavObj->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';
<?php if (!isset($b2bpaObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.Buyer2_BProduct_Association.php"; $b2bpaObj = new Buyer2_BProduct_Association(); } if (!isset($b2bpavObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.Buyer2_BProduct_Association_ToVerify.php"; $b2bpavObj = new Buyer2_BProduct_Association_ToVerify(); } $iAssociationId = GetVar('id'); // $msg = GetVar('msg'); $mod = ''; $flds = " b2bpav.*, org.vCompanyName as vBuyer2, org.vCompCode, bpo.vProductName as vProduct, bpo.vProductCode "; $jtbl = " LEFT JOIN " . PRJ_DB_PREFIX . "_bproduct_organization bpo on bpo.iProductId=b2bpav.iProductId\r\n LEFT JOIN " . PRJ_DB_PREFIX . "_organization_master org on org.iOrganizationID=b2bpav.iBuyer2Id "; $vb2bprdtls = $b2bpavObj->getJoinTableInfo($jtbl, $flds, " AND b2bpav.iAssociationId={$iAssociationId} ", ' b2bpav.iVerifiedID DESC ', '', ' LIMIT 0,1'); $vrq = $b2bpavObj->isVerifyReq($vb2bprdtls); $vsts = ''; if ($vrq == 'vreq') { $vsts = $b2bpavObj->chkRecVrf($vb2bprdtls); if ($vsts == 'nr' || $vsts == 'om') { header('Location: ' . SITE_URL_DUM . 'b2bprodtasoclist'); exit; } } else { if ($vrq == 'nr') { $flds = " b2bpa.*, org.vCompanyName as vBuyer2, org.vCompCode, bpo.vProductName as vProduct, bpo.vProductCode "; $jtbl = " LEFT JOIN " . PRJ_DB_PREFIX . "_bproduct_organization bpo on bpo.iProductId=b2bpa.iProductId\r\n LEFT JOIN " . PRJ_DB_PREFIX . "_organization_master org on org.iOrganizationID=b2bpa.iBuyer2Id "; $vb2bprdtls = $b2bpaObj->getJoinTableInfo($jtbl, $flds, " AND iAssociationId={$iAssociationId} "); $vrq = $b2bpavObj->isVerifyReq($vb2bprdtls); if ($vrq == 'vreq') {
<?php $iAssociationId = GetVar('id'); /*if($sess_usertype == 'orgadmin') { // && $asoc != $iAssociationId header("Location: ".SITE_URL_DUM."oadashboard"); exit; }*/ if (!isset($b2bpaObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.Buyer2_BProduct_Association.php"; $b2bpaObj = new Buyer2_BProduct_Association(); } if (!isset($b2bpavObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.Buyer2_BProduct_Association_ToVerify.php"; $b2bpavObj = new Buyer2_BProduct_Association_ToVerify(); } $b2bprdtls = $b2bpaObj->select($iAssociationId); $b2bprdthistory = $b2bpavObj->getHistory($iAssociationId); // prints($b2bprdthistory); exit; $smarty->assign('b2bprdtls', $b2bprdtls); $smarty->assign('b2bprdthistory', $b2bprdthistory);
$buyer2 = isset($_POST['buyer2']) ? $_POST['buyer2'] : ''; $code = isset($_POST['code']) ? $_POST['code'] : ''; $product = isset($_POST['product']) ? $_POST['product'] : ''; $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_BProduct_Association.php"; $assObj = new Buyer2_BProduct_Association(); } $where = ""; $_POST['srchval'] = isset($_POST['srchval']) ? $_POST['srchval'] : ''; if ($_POST['srchval'] == 'act') { $where .= " AND b2bpa.eStatus='Active' "; } else { if ($_POST['srchval'] == 'inact') { $where .= " AND b2bpa.eStatus='Inactive' "; } } if ($mode == 'all') { if ($val != '') { $where .= " AND ((Select vCompanyName from " . PRJ_DB_PREFIX . "_organization_master where iOrganizationID=b2bpa.iBuyer2Id) LIKE '%{$val}%' OR\r\n\t\t\t\t\t\t(Select vProductName from " . PRJ_DB_PREFIX . "_bproduct_organization where iProductId=b2bpa.iProductId) LIKE '%{$val}%' OR vACode LIKE '%{$val}%' )"; } // echo $where; exit;
<?php $mode = PostVar('mode'); $val = PostVar('val'); if (trim($val) == '' || $val < 1 || trim($mode) == '') { exit; } if (!isset($b2bpaObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.Buyer2_BProduct_Association.php"; $b2bpaObj = new Buyer2_BProduct_Association(); } if (!isset($b2bpavObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.Buyer2_BProduct_Association_ToVerify.php"; $b2bpavObj = new Buyer2_BProduct_Association_ToVerify(); } if (!isset($emailObj)) { include_once SITE_CLASS_APPLICATION . 'class.EmailTemplate.php'; $emailObj = new EmailTemplate(); } $flds = "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"; $assocs = $b2bpaObj->getDetails($flds, " AND b2bpa.eStatus IN ('Active','Inactive') AND b2bpa.eNeedToVerify!='Yes' AND b2bpa.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($b2bpaObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.Buyer2_BProduct_Association.php"; $b2bpaObj = new Buyer2_BProduct_Association(); } $b2orgid = PostVar('b2orgid'); $prdtid = PostVar('prdtid'); $flds = PostVar('flds'); $dtls = $b2bpaObj->getDetails("{$flds}", " AND iProductId={$prdtid} AND iBuyer2Id={$b2orgid} "); $txt = array(); if (is_array($dtls) && count($dtls) > 0) { foreach ($dtls[0] as $ky => $vl) { $txt[] .= $vl; } } if (is_array($txt) && count($txt) > 0) { echo implode('|,|', $txt); } exit;