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) != '') { $sql1 = "UPDATE " . PRJ_DB_PREFIX . "_buyer2_bproduct_association SET eStatus = IF(eStatus='Inactive','Active','Inactive'), eNeedToVerify='Yes', eModifiedBy='" . $sess_usertype_short . "', iModifiedByID='" . $sess_id . "', dModifiedDate='" . date('Y-m-d H:i:s') . "', eVerifiedBy='', iVerifiedByID='', dVerifiedDate='', eRejectedBy='', iRejectedByID='', dRejectedDate='' WHERE iAssociationId IN ({$vl})"; $sql2 = "INSERT INTO b2b_buyer2_bproduct_association_toverify\r\n (iAssociationId,iBuyer2Id,iProductId,vACode,fGlobalLimit,fOutstandingAmt,fFeePc,fFeeFlat,fAdvancePc,fMinValue,fMaxValue,vAccount1,vAccount2,vAccount3,vAccount4,vAccount5,vAccount6,vAccount7,vAccount8,vNarrative,dADate,vFromIP,iCreatedByID,eCreatedBy,iModifiedByID,eModifiedBy,dModifiedDate,iRejectedByID,eRejectedBy,dRejectedDate,iVerifiedByID,eVerifiedBy,dVerifiedDate,tReasonToReject,eNeedToVerify,eStatus)\r\n SELECT * FROM b2b_buyer2_bproduct_association WHERE iAssociationId IN ({$vl})"; // $rs = $dbobj->dotransaction($sqls); $rs = $dbobj->sql_query($sql1); if ($rs) {
$whr_cndt = " AND vType='{$esubtyp}' AND eSection='Member' "; $email_cnt = $emailObj->getDetails('*', $whr_cndt); $type = "Modified"; $body = array("#BUYER2#", "#PRODUCT#", "#ACODE#", "#LINK#", "#MODIFIED_BY#"); $body_arr = array("#USER#", "#BUYER2#", "#PRODUCT#", "#ACODE#", "#LINK#", "#MODIFIED_BY#", "#MAIL_FOOTER#", "#SITE_URL#"); } else { $msg = 'uerr'; } $id = $iAssociationId; } else { if ($mod == 'add') { // $mod = 'add'; if (isset($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ORGTYPE']) && $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ORGTYPE'] == 'Buyer2') { $Data['iBuyer2Id'] = $curORGID; } $drec = $b2bpaObj->getDetails('*', " AND iBuyer2Id=" . $Data['iBuyer2Id'] . " AND iProductId=" . $Data['iProductId'] . ""); if (is_array($drec) && count($drec) > 0 && isset($drec[0]['iAssociationId']) && $drec[0]['iAssociationId'] > 0) { if (isset($_SERVER['HTTP_REFERER']) && trim($_SERVER['HTTP_REFERER']) != '') { header("Location: " . $_SERVER['HTTP_REFERER']); } else { header("Location: " . SITE_URL_DUM . "b2bprodtasoclist"); } exit; } $Data['dADate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s'); $Data['vFromIP'] = $_SERVER['REMOTE_ADDR']; $Data['eCreatedBy'] = $sess_usertype_short; $Data['iCreatedByID'] = $sess_id; $Data['eStatus'] = 'Need to Verify'; $Data['vACode'] = $b2bpaObj->getUniqueCode(''); $rs = $id = $b2bpaObj->insert($Data);
<?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;