Beispiel #1
0
 $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');