how can I show my signal transaction data as project name

» php » how can I show my signal transaction data as project name

By : Dave

Date : November 23 2020, 01:01 AM

I wish this helpful for you you should show that what are you getting as output/or if any error.
As per as I understand, last PHP code should be like following:

code :

<?php while($rows=mysql_fetch_array($resultnew)){
        if(!isset($rec1)) $rec1=$rows["amount"];
         //as we only want to set this in first loop. don't create $rec1 before while, if you created any then use another variable here. $rec1 should be unset. ?>
        <tr>
            <td><?php echo $sl++; ?></td>
            <td><?php echo $rows[ 'id']; ?></td>
            <td><?php echo $rows[ 'date']; ?></td>
            <td><?php echo $rows[ 'project_name']; ?></td>
            <td><?php echo $rec1; ?></td>
            <td><?php 
                  echo $receive_ammount=$rows[ 'receive_ammount'];
                  $rec1-=$receive_amount; ?>
            </td>
            <td><?php echo $rec1 ; ?></td>
       </tr>
<?php } ?>

Share :

Sum data as MySQL transaction ID and show it as student ID

By : Peshawa M. Qadir

Date : March 29 2020, 07:55 AM

it should still fix some issue Try this:
Here you need to get amount Student wise, so need to do GROUP BY student & also want sum amount, so need to call SUM function and pass amount in it.

code :

SELECT std_id AS studentid , SUM(pay) as Amount 
FROM table 
GROUP BY std_id;

How to show transaction input data in a Hyperledger Composer query

By : Dzikuri

Date : March 29 2020, 07:55 AM

Does that help So actually, instead of bothering with a query to the Historian, I got this to work using this query

code :

query myTransactions{
  description: "return all transactions made (not system transactions)"
  statement: SELECT org.acme.sample.NAME_OF_TRANSACTION_CLASS

}

How to iterate and show the transaction input data?

By : user1502741

Date : March 29 2020, 07:55 AM

help you fix your problem The easy way to start looking at this is to use the composer-rest-server and use a GET request against your CreatePPR transaction. You can use the GET to retrieve all those transactions or the GET with a specific Transaction ID to retrieve a single transaction.
You can also write queries that will generate endpoints in the REST server and there is a tutorial on Queries in the composer documentation.

code :

async function tGetTranCreatePPR ()
{

const BusinessNetworkConnection = require('composer-client').BusinessNetworkConnection;

var bnc = new BusinessNetworkConnection;
await bnc.connect('admin@PPR-network');

const factory = bnc.getBusinessNetwork().getFactory();
const myPPRRegistry = await bnc.getTransactionRegistry('org.com.TestNetwork.CreatePPR');
var myPPR = await myPPRRegistry.get('2sdf34r23dwed235asdasr345wrwes908');
console.log('myPPR: ',myPPR);
return;
}

How to rollback outer transaction in case of failed inner transaction in but inner transaction should save data Spring

By : user2768898

Date : March 29 2020, 07:55 AM

To fix this issue Configure the inner transactional method as Propagation.REQUIRES_NEW such that it will always commit (i.e save the data) when the method completes whether the outer transactional method rollbacks or not.
Also, make sure outer method does not self invocation the inner method as @Transactional does not work in this case (See Method visibility and @Transactional section in docs).

code :

@Service
public class Service1 {

    @Autowired
    private Service2 service2;

    @Transactional(rollbackFor=Exception.class)
    public void test1(Account account) throws Exception {
        DOA.save(account);
        status = service2.test2(account);
        if(status!='SUCCESS'){
            throw new Exception("Api call failed");
        }
    }
}

@Service
public class Service2{

    @Transactional(propagation=Propagation.REQUIRES_NEW)
    public void test2(Account account) {
        response // API Call
        DOA.save(response);
        return response.status;
    }
}

Project Advice: push ERP/SQL transaction data to Slack

By : ASv

Date : March 29 2020, 07:55 AM

should help you out Epicor ERP has a powerful extension system built in.
I would create a Business Process Method (BPM) for ReceiptEntry.Update. This wouldn't check for added rows but more specifically where the Recieved flag has been changed to set. This will prevent you getting multiple notifications every time a user saves an incomplete record.