$opatype = $orgas == 'Buyer' ? 'BProduct' : ($orgas == 'Supplier' ? 'SProduct' : $opatype); $atbl = $opatype == 'BProduct' ? PRJ_DB_PREFIX . "_buyer2_buyer_bproduct_association" : ($opatype == 'SProduct' ? PRJ_DB_PREFIX . "_buyer2_supplier_sproduct_association" : ''); $absfld = $opatype == 'BProduct' ? "iBuyerId" : ($opatype == 'SProduct' ? "iSupplierId" : ''); if (is_array($abdata) && count($abdata) > 0 && $iProductId > 0 && $curORGID > 0 && $atbl != '') { for ($l = 0; $l < count($abdata); $l++) { $sql = "Select iAssociationId from {$atbl} where iProductId={$iProductId} AND {$absfld}={$curORGID} AND iBuyer2Id=" . $abdata[$l]; $adt = $dbobj->MySQLSelect($sql); if (isset($adt[0]['iAssociationId']) && $adt[0]['iAssociationId'] > 0) { $adata['iRFQ2Id'] = $id; $adata['iBuyer2Id'] = $abdata[$l]; $adata['iAssociationId'] = $adt[0]['iAssociationId']; $adata['ePType'] = $opatype; $adata['dADate'] = calcGTzTime(date('Y-m-d'), 'Y-m-d'); $rs = $rpb2Obj->insert($adata); } else { $rs = $rfq2Obj->clearRfq2NAssoc($id); if ($rs) { $generalobj->getPostForm($_POST, '', SITE_URL_DUM . "rfq2create/pb2m"); exit; } else { $sql = "Select iAssociationId, iProductId from {$atbl} where {$absfld}={$curORGID} AND iBuyer2Id=" . $abdata[$l]; // iProductId=$iProductId AND $adt = $dbobj->MySQLSelect($sql); // if (isset($adt[0]['iAssociationId']) && $adt[0]['iAssociationId'] > 0) { $adata['iRFQ2Id'] = $id; $adata['iBuyer2Id'] = $abdata[$l]; $adata['iProductId'] = $adt[0]['iProductId']; $adata['iAssociationId'] = $adt[0]['iAssociationId']; $adata['ePType'] = $opatype; $adata['dADate'] = calcGTzTime(date('Y-m-d'), 'Y-m-d');